[2024-01-27 00:00:22] [indexer:background] Health check [2024-01-27 00:00:37] [index:background] Health check [2024-01-27 00:06:37] [indexer:background] Health check [2024-01-27 00:06:37] [index:background] Health check [2024-01-27 00:10:06] [indexer:background] Health check [2024-01-27 00:10:31] [index:background] Health check [2024-01-27 00:15:54] [indexer:background] Health check [2024-01-27 00:15:54] [index:background] Health check [2024-01-27 00:20:21] [indexer:background] Health check [2024-01-27 00:21:00] [index:background] Health check [2024-01-27 00:25:11] [indexer:background] Health check [2024-01-27 00:26:02] [index:background] Health check [2024-01-27 00:30:22] [indexer:background] Health check [2024-01-27 00:31:55] [index:background] Health check [2024-01-27 00:35:11] [indexer:background] Health check [2024-01-27 00:35:45] [index:background] Health check [2024-01-27 00:39:57] [indexer:background] Health check [2024-01-27 00:42:00] [index:background] Health check [2024-01-27 00:45:27] [indexer:background] Health check [2024-01-27 00:45:27] [index:background] Health check [2024-01-27 00:50:07] [indexer:background] Health check [2024-01-27 00:53:34] [index:background] Health check [2024-01-27 00:57:48] [indexer:background] Health check [2024-01-27 00:57:48] [index:background] Health check [2024-01-27 01:00:05] [indexer:background] Health check [2024-01-27 01:00:44] [index:background] Health check [2024-01-27 01:05:05] [indexer:background] Health check [2024-01-27 01:05:24] [index:background] Health check [2024-01-27 01:10:21] [indexer:background] Health check [2024-01-27 01:10:28] [index:background] Health check [2024-01-27 01:16:39] [indexer:background] Health check [2024-01-27 01:16:39] [index:background] Health check [2024-01-27 01:20:39] [indexer:background] Health check [2024-01-27 01:20:39] [index:background] Health check [2024-01-27 01:25:00] [indexer:background] Health check [2024-01-27 01:26:39] [index:background] Health check [2024-01-27 01:30:19] [indexer:background] Health check [2024-01-27 01:30:24] [index:background] Health check [2024-01-27 01:36:38] [indexer:background] Health check [2024-01-27 01:36:38] [index:background] Health check [2024-01-27 01:40:43] [indexer:background] Health check [2024-01-27 01:40:43] [index:background] Health check [2024-01-27 01:48:40] [indexer:background] Health check [2024-01-27 01:48:40] [index:background] Health check [2024-01-27 01:52:12] [indexer:background] Health check [2024-01-27 01:52:12] [index:background] Health check [2024-01-27 01:55:07] [indexer:background] Health check [2024-01-27 01:55:26] [index:background] Health check [2024-01-27 02:01:17] [indexer:background] Health check [2024-01-27 02:01:17] [index:background] Health check [2024-01-27 02:05:46] [indexer:background] Health check [2024-01-27 02:05:46] [index:background] Health check [2024-01-27 02:10:16] [indexer:background] Health check [2024-01-27 02:11:06] [index:background] Health check [2024-01-27 02:16:19] [indexer:background] Health check [2024-01-27 02:16:19] [index:background] Health check [2024-01-27 02:20:10] [indexer:background] Health check [2024-01-27 02:20:25] [index:background] Health check [2024-01-27 02:25:42] [indexer:background] Health check [2024-01-27 02:25:42] [index:background] Health check [2024-01-27 02:33:29] [indexer:background] Health check [2024-01-27 02:33:29] [index:background] Health check [2024-01-27 02:37:01] [indexer:background] Health check [2024-01-27 02:37:07] [index:background] Health check [2024-01-27 02:41:48] [indexer:background] Health check [2024-01-27 02:41:48] [index:background] Health check [2024-01-27 02:45:02] [indexer:background] Health check [2024-01-27 02:45:02] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2024-01-27 02:45:29] [index:background] Health check [2024-01-27 02:45:29] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2024-01-27 02:45:31] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2024-01-27 02:50:15] [indexer:background] Health check [2024-01-27 02:50:15] [indexer:background] CPU load threshold (3) breached: 3.78 [waiting 2] [2024-01-27 02:51:02] [index:background] Health check [2024-01-27 02:51:02] [index:background] CPU load threshold (3) breached: 3.59 [waiting 2] [2024-01-27 02:51:04] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2024-01-27 02:56:12] [indexer:background] Health check [2024-01-27 02:56:12] [indexer:background] CPU load threshold (3) breached: 3.67 [waiting 2] [2024-01-27 02:56:14] [index:background] Health check [2024-01-27 02:56:14] [index:background] CPU load threshold (3) breached: 3.67 [waiting 2] [2024-01-27 02:56:16] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2] [2024-01-27 03:00:14] [indexer:background] Health check [2024-01-27 03:00:14] [indexer:background] CPU load threshold (3) breached: 4.26 [waiting 2] [2024-01-27 03:01:30] [index:background] Health check [2024-01-27 03:01:30] [index:background] CPU load threshold (3) breached: 4.18 [waiting 2] [2024-01-27 03:01:32] [indexer:background] CPU load threshold (3) breached: 4.18 [waiting 2] [2024-01-27 03:05:25] [indexer:background] Health check [2024-01-27 03:05:25] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2024-01-27 03:05:27] [index:background] Health check [2024-01-27 03:05:27] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2024-01-27 03:05:29] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2024-01-27 03:10:45] [indexer:background] Health check [2024-01-27 03:10:45] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2024-01-27 03:10:47] [index:background] Health check [2024-01-27 03:10:47] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2024-01-27 03:10:49] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2024-01-27 03:16:12] [indexer:background] Health check [2024-01-27 03:16:12] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2024-01-27 03:16:14] [index:background] Health check [2024-01-27 03:16:14] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2024-01-27 03:16:16] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2] [2024-01-27 03:20:09] [indexer:background] Health check [2024-01-27 03:20:09] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2024-01-27 03:22:07] [index:background] Health check [2024-01-27 03:22:07] [index:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2024-01-27 03:22:09] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2024-01-27 03:26:55] [indexer:background] Health check [2024-01-27 03:26:55] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2024-01-27 03:26:57] [index:background] Health check [2024-01-27 03:26:57] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2024-01-27 03:26:59] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2024-01-27 03:30:01] [indexer:background] Health check [2024-01-27 03:30:57] [index:background] Health check [2024-01-27 03:35:44] [indexer:background] Health check [2024-01-27 03:35:45] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2024-01-27 03:35:47] [index:background] Health check [2024-01-27 03:35:47] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2024-01-27 03:35:49] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2024-01-27 03:40:19] [indexer:background] Health check [2024-01-27 03:41:48] [index:background] Health check [2024-01-27 03:41:48] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2] [2024-01-27 03:41:50] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2] [2024-01-27 03:46:33] [indexer:background] Health check [2024-01-27 03:46:33] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2024-01-27 03:46:35] [index:background] Health check [2024-01-27 03:46:35] [index:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2024-01-27 03:46:37] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2024-01-27 03:50:31] [indexer:background] Health check [2024-01-27 03:50:31] [indexer:background] CPU load threshold (3) breached: 3.76 [waiting 2] [2024-01-27 03:50:33] [index:background] Health check [2024-01-27 03:50:33] [index:background] CPU load threshold (3) breached: 3.62 [waiting 2] [2024-01-27 03:50:35] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2] [2024-01-27 03:56:13] [indexer:background] Health check [2024-01-27 03:56:13] [index:background] Health check [2024-01-27 04:00:36] [indexer:background] Health check [2024-01-27 04:00:37] [index:background] Health check [2024-01-27 04:06:00] [indexer:background] Health check [2024-01-27 04:06:00] [index:background] Health check [2024-01-27 04:10:18] [indexer:background] Health check [2024-01-27 04:11:35] [index:background] Health check [2024-01-27 04:16:01] [indexer:background] Health check [2024-01-27 04:16:01] [index:background] Health check [2024-01-27 04:20:18] [indexer:background] Health check [2024-01-27 04:21:08] [index:background] Health check [2024-01-27 04:27:04] [indexer:background] Health check [2024-01-27 04:27:04] [index:background] Health check [2024-01-27 04:32:02] [indexer:background] Health check [2024-01-27 04:32:02] [index:background] Health check [2024-01-27 04:36:57] [indexer:background] Health check [2024-01-27 04:36:57] [index:background] Health check [2024-01-27 04:41:59] [indexer:background] Health check [2024-01-27 04:41:59] [index:background] Health check [2024-01-27 04:46:41] [indexer:background] Health check [2024-01-27 04:46:41] [index:background] Health check [2024-01-27 04:50:18] [indexer:background] Health check [2024-01-27 04:55:07] [index:background] Health check [2024-01-27 04:55:07] [indexer:background] Health check [2024-01-27 04:55:07] [indexer:background] Health check [2024-01-27 04:56:28] [index:background] Health check [2024-01-27 05:04:46] [indexer:background] Health check [2024-01-27 05:04:46] [index:background] Health check [2024-01-27 05:05:01] [indexer:background] Health check [2024-01-27 05:06:07] [index:background] Health check [2024-01-27 05:11:26] [indexer:background] Health check [2024-01-27 05:11:26] [index:background] Health check [2024-01-27 05:15:01] [indexer:background] Health check [2024-01-27 05:15:44] [index:background] Health check [2024-01-27 05:21:48] [indexer:background] Health check [2024-01-27 05:21:48] [index:background] Health check [2024-01-27 05:25:18] [indexer:background] Health check [2024-01-27 05:25:50] [index:background] Health check [2024-01-27 05:30:13] [indexer:background] Health check [2024-01-27 05:30:51] [index:background] Health check [2024-01-27 05:37:00] [indexer:background] Health check [2024-01-27 05:37:00] [index:background] Health check [2024-01-27 05:40:18] [indexer:background] Health check [2024-01-27 05:41:21] [index:background] Health check [2024-01-27 05:45:49] [indexer:background] Health check [2024-01-27 05:45:49] [index:background] Health check [2024-01-27 05:50:19] [indexer:background] Health check [2024-01-27 05:50:57] [index:background] Health check [2024-01-27 05:55:11] [indexer:background] Health check [2024-01-27 05:55:40] [index:background] Health check [2024-01-27 06:00:20] [indexer:background] Health check [2024-01-27 06:00:46] [index:background] Health check [2024-01-27 06:05:17] [indexer:background] Health check [2024-01-27 06:05:32] [index:background] Health check [2024-01-27 06:10:25] [indexer:background] Health check [2024-01-27 06:10:25] [index:background] Health check [2024-01-27 06:15:14] [indexer:background] Health check [2024-01-27 06:16:30] [index:background] Health check [2024-01-27 06:19:58] [indexer:background] Health check [2024-01-27 06:20:24] [index:background] Health check [2024-01-27 06:25:01] [indexer:background] Health check [2024-01-27 06:25:23] [index:background] Health check [2024-01-27 06:29:59] [indexer:background] Health check [2024-01-27 06:31:07] [index:background] Health check [2024-01-27 06:36:01] [indexer:background] Health check [2024-01-27 06:36:01] [index:background] Health check [2024-01-27 06:40:18] [indexer:background] Health check [2024-01-27 06:40:44] [index:background] Health check [2024-01-27 06:46:12] [indexer:background] Health check [2024-01-27 06:46:12] [index:background] Health check [2024-01-27 06:51:29] [indexer:background] Health check [2024-01-27 06:51:29] [index:background] Health check [2024-01-27 06:54:59] [indexer:background] Health check [2024-01-27 06:55:48] [index:background] Health check [2024-01-27 07:00:14] [indexer:background] Health check [2024-01-27 07:01:49] [index:background] Health check [2024-01-27 07:06:04] [indexer:background] Health check [2024-01-27 07:06:04] [index:background] Health check [2024-01-27 07:10:34] [indexer:background] Health check [2024-01-27 07:10:34] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2024-01-27 07:10:36] [index:background] Health check [2024-01-27 07:10:36] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2024-01-27 07:10:38] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2] [2024-01-27 07:15:23] [indexer:background] Health check [2024-01-27 07:15:23] [index:background] Health check [2024-01-27 07:20:49] [indexer:background] Health check [2024-01-27 07:20:49] [index:background] Health check [2024-01-27 07:28:09] [indexer:background] Health check [2024-01-27 07:28:10] [index:background] Health check [2024-01-27 07:30:22] [indexer:background] Health check [2024-01-27 07:33:10] [index:background] Health check [2024-01-27 07:36:18] [indexer:background] Health check [2024-01-27 07:36:18] [index:background] Health check [2024-01-27 07:45:05] [indexer:background] Health check [2024-01-27 07:45:05] [index:background] Health check [2024-01-27 07:47:32] [index:background] Health check [2024-01-27 07:50:06] [indexer:background] Health check [2024-01-27 07:53:13] [index:background] Health check [2024-01-27 07:55:08] [indexer:background] Health check [2024-01-27 07:56:19] [index:background] Health check [2024-01-27 08:00:57] [indexer:background] Health check [2024-01-27 08:00:57] [index:background] Health check [2024-01-27 08:05:32] [indexer:background] Health check [2024-01-27 08:05:32] [index:background] Health check [2024-01-27 08:10:01] [indexer:background] Health check [2024-01-27 08:10:28] [index:background] Health check [2024-01-27 08:15:37] [indexer:background] Health check [2024-01-27 08:15:37] [index:background] Health check [2024-01-27 08:20:15] [indexer:background] Health check [2024-01-27 08:20:32] [index:background] Health check [2024-01-27 08:25:02] [indexer:background] Health check [2024-01-27 08:25:24] [index:background] Health check [2024-01-27 08:30:24] [indexer:background] Health check [2024-01-27 08:30:24] [index:background] Health check [2024-01-27 08:35:39] [indexer:background] Health check [2024-01-27 08:35:39] [index:background] Health check [2024-01-27 08:40:05] [indexer:background] Health check [2024-01-27 08:40:29] [index:background] Health check [2024-01-27 08:45:27] [indexer:background] Health check [2024-01-27 08:45:27] [index:background] Health check [2024-01-27 08:50:10] [indexer:background] Health check [2024-01-27 08:50:23] [index:background] Health check [2024-01-27 08:55:02] [indexer:background] Health check [2024-01-27 08:55:30] [index:background] Health check [2024-01-27 09:00:22] [indexer:background] Health check [2024-01-27 09:00:33] [index:background] Health check [2024-01-27 09:05:14] [indexer:background] Health check [2024-01-27 09:05:32] [index:background] Health check [2024-01-27 09:10:20] [indexer:background] Health check [2024-01-27 09:11:36] [index:background] Health check [2024-01-27 09:15:00] [indexer:background] Health check [2024-01-27 09:15:41] [index:background] Health check [2024-01-27 09:23:33] [indexer:background] Health check [2024-01-27 09:23:33] [index:background] Health check [2024-01-27 09:25:07] [indexer:background] Health check [2024-01-27 09:25:46] [index:background] Health check [2024-01-27 09:29:59] [indexer:background] Health check [2024-01-27 09:30:28] [index:background] Health check [2024-01-27 09:35:42] [indexer:background] Health check [2024-01-27 09:35:42] [index:background] Health check [2024-01-27 09:41:13] [indexer:background] Health check [2024-01-27 09:41:13] [index:background] Health check [2024-01-27 09:45:12] [indexer:background] Health check [2024-01-27 09:45:56] [index:background] Health check [2024-01-27 09:49:58] [indexer:background] Health check [2024-01-27 09:50:46] [index:background] Health check [2024-01-27 09:51:44] [query] Query for: 2023 [2024-01-27 09:51:44] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-01-27 09:51:44] [query] Engine: default [2024-01-27 09:51:45] [query] Tokens: 2023 [2024-01-27 09:51:45] [query] Mods: 6 [2024-01-27 09:51:45] [query] Found results using: or logic [2024-01-27 09:51:45] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-01-27 09:51:45] [query] Results: 255 Pages of results: 26 [2024-01-27 09:51:45] [query] Execution time: 0.94992 [2024-01-27 09:55:09] [indexer:background] Health check [2024-01-27 09:57:39] [index:background] Health check [2024-01-27 10:00:55] [indexer:background] Health check [2024-01-27 10:00:55] [index:background] Health check [2024-01-27 10:06:51] [indexer:background] Health check [2024-01-27 10:06:51] [index:background] Health check [2024-01-27 10:10:29] [indexer:background] Health check [2024-01-27 10:10:29] [index:background] Health check [2024-01-27 10:14:59] [indexer:background] Health check [2024-01-27 10:16:08] [index:background] Health check [2024-01-27 10:21:18] [indexer:background] Health check [2024-01-27 10:21:18] [index:background] Health check [2024-01-27 10:26:11] [indexer:background] Health check [2024-01-27 10:26:11] [index:background] Health check [2024-01-27 10:30:07] [indexer:background] Health check [2024-01-27 10:31:07] [index:background] Health check [2024-01-27 10:35:09] [indexer:background] Health check [2024-01-27 10:35:49] [index:background] Health check [2024-01-27 10:40:36] [indexer:background] Health check [2024-01-27 10:40:37] [index:background] Health check [2024-01-27 10:45:09] [indexer:background] Health check [2024-01-27 10:47:03] [index:background] Health check [2024-01-27 10:50:14] [indexer:background] Health check [2024-01-27 10:51:08] [index:background] Health check [2024-01-27 10:54:07] [query] Query for: search_term_string [2024-01-27 10:54:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-01-27 10:54:07] [query] Engine: default [2024-01-27 10:54:07] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-01-27 10:54:07] [query] Mods: 6 [2024-01-27 10:54:07] [query] Using OR logic [2024-01-27 10:54:08] [query] Found results using: or logic [2024-01-27 10:54:08] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-01-27 10:54:08] [query] Results: 1348 Pages of results: 135 [2024-01-27 10:54:08] [query] Execution time: 1.24948 [2024-01-27 10:55:01] [indexer:background] Health check [2024-01-27 10:55:37] [index:background] Health check [2024-01-27 10:58:36] [query] Query for: search_term_string [2024-01-27 10:58:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-01-27 10:58:36] [query] Engine: default [2024-01-27 10:58:36] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-01-27 10:58:36] [query] Mods: 6 [2024-01-27 10:58:36] [query] Using OR logic [2024-01-27 10:58:36] [query] Found results using: or logic [2024-01-27 10:58:36] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-01-27 10:58:36] [query] Results: 1348 Pages of results: 135 [2024-01-27 10:58:36] [query] Execution time: 0.04217 [2024-01-27 11:01:13] [indexer:background] Health check [2024-01-27 11:01:13] [index:background] Health check [2024-01-27 11:05:50] [indexer:background] Health check [2024-01-27 11:05:50] [index:background] Health check [2024-01-27 11:10:06] [indexer:background] Health check [2024-01-27 11:10:29] [index:background] Health check [2024-01-27 11:15:09] [indexer:background] Health check [2024-01-27 11:15:26] [index:background] Health check [2024-01-27 11:20:34] [indexer:background] Health check [2024-01-27 11:20:34] [index:background] Health check [2024-01-27 11:25:30] [indexer:background] Health check [2024-01-27 11:25:30] [index:background] Health check [2024-01-27 11:30:29] [indexer:background] Health check [2024-01-27 11:30:30] [index:background] Health check [2024-01-27 11:35:35] [indexer:background] Health check [2024-01-27 11:35:35] [index:background] Health check [2024-01-27 11:40:14] [indexer:background] Health check [2024-01-27 11:40:58] [index:background] Health check [2024-01-27 11:43:38] [query] Query for: 2023 [2024-01-27 11:43:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-01-27 11:43:38] [query] Engine: default [2024-01-27 11:43:38] [query] Tokens: 2023 [2024-01-27 11:43:38] [query] Mods: 6 [2024-01-27 11:43:38] [query] Found results using: or logic [2024-01-27 11:43:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-01-27 11:43:38] [query] Results: 255 Pages of results: 26 [2024-01-27 11:43:38] [query] Execution time: 0.04065 [2024-01-27 11:43:38] [query] Query for: 2023 [2024-01-27 11:43:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-01-27 11:43:38] [query] Engine: default [2024-01-27 11:43:38] [query] Tokens: 2023 [2024-01-27 11:43:38] [query] Mods: 6 [2024-01-27 11:43:38] [query] Found results using: or logic [2024-01-27 11:43:39] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100 [2024-01-27 11:43:39] [query] Results: 255 Pages of results: 3 [2024-01-27 11:43:39] [query] Execution time: 0.22762 [2024-01-27 11:45:32] [indexer:background] Health check [2024-01-27 11:45:32] [index:background] Health check [2024-01-27 11:49:58] [indexer:background] Health check [2024-01-27 11:50:26] [index:background] Health check [2024-01-27 11:56:02] [indexer:background] Health check [2024-01-27 11:56:02] [index:background] Health check [2024-01-27 12:00:03] [indexer:background] Health check [2024-01-27 12:01:07] [index:background] Health check [2024-01-27 12:05:26] [indexer:background] Health check [2024-01-27 12:05:27] [index:background] Health check [2024-01-27 12:10:03] [indexer:background] Health check [2024-01-27 12:11:09] [index:background] Health check [2024-01-27 12:15:08] [indexer:background] Health check [2024-01-27 12:15:29] [index:background] Health check [2024-01-27 12:20:13] [indexer:background] Health check [2024-01-27 12:20:42] [index:background] Health check [2024-01-27 12:25:39] [indexer:background] Health check [2024-01-27 12:25:39] [index:background] Health check [2024-01-27 12:30:18] [indexer:background] Health check [2024-01-27 12:31:25] [index:background] Health check [2024-01-27 12:35:46] [indexer:background] Health check [2024-01-27 12:35:46] [index:background] Health check [2024-01-27 12:40:43] [indexer:background] Health check [2024-01-27 12:40:43] [index:background] Health check [2024-01-27 12:45:07] [indexer:background] Health check [2024-01-27 12:46:22] [index:background] Health check [2024-01-27 12:50:40] [indexer:background] Health check [2024-01-27 12:50:40] [index:background] Health check [2024-01-27 12:55:36] [indexer:background] Health check [2024-01-27 12:55:36] [index:background] Health check [2024-01-27 13:00:05] [indexer:background] Health check [2024-01-27 13:02:02] [index:background] Health check [2024-01-27 13:05:12] [indexer:background] Health check [2024-01-27 13:06:06] [index:background] Health check [2024-01-27 13:10:30] [indexer:background] Health check [2024-01-27 13:10:31] [index:background] Health check [2024-01-27 13:15:23] [indexer:background] Health check [2024-01-27 13:15:30] [index:background] Health check [2024-01-27 13:20:49] [indexer:background] Health check [2024-01-27 13:20:49] [index:background] Health check [2024-01-27 13:25:13] [indexer:background] Health check [2024-01-27 13:25:53] [index:background] Health check [2024-01-27 13:30:55] [indexer:background] Health check [2024-01-27 13:30:55] [index:background] Health check [2024-01-27 13:35:42] [indexer:background] Health check [2024-01-27 13:35:42] [index:background] Health check [2024-01-27 13:40:35] [indexer:background] Health check [2024-01-27 13:40:35] [index:background] Health check [2024-01-27 13:46:08] [indexer:background] Health check [2024-01-27 13:46:08] [index:background] Health check [2024-01-27 13:50:09] [indexer:background] Health check [2024-01-27 13:50:24] [index:background] Health check [2024-01-27 13:55:48] [indexer:background] Health check [2024-01-27 13:55:48] [index:background] Health check [2024-01-27 14:00:34] [indexer:background] Health check [2024-01-27 14:00:34] [index:background] Health check [2024-01-27 14:05:03] [indexer:background] Health check [2024-01-27 14:05:25] [index:background] Health check [2024-01-27 14:10:33] [indexer:background] Health check [2024-01-27 14:10:33] [index:background] Health check [2024-01-27 14:15:20] [indexer:background] Health check [2024-01-27 14:16:42] [index:background] Health check [2024-01-27 14:20:44] [indexer:background] Health check [2024-01-27 14:20:44] [index:background] Health check [2024-01-27 14:25:09] [indexer:background] Health check [2024-01-27 14:26:26] [index:background] Health check [2024-01-27 14:30:24] [indexer:background] Health check [2024-01-27 14:30:24] [index:background] Health check [2024-01-27 14:35:12] [indexer:background] Health check [2024-01-27 14:35:33] [index:background] Health check [2024-01-27 14:41:02] [indexer:background] Health check [2024-01-27 14:41:02] [index:background] Health check [2024-01-27 14:45:01] [indexer:background] Health check [2024-01-27 14:45:51] [index:background] Health check [2024-01-27 14:50:31] [indexer:background] Health check [2024-01-27 14:50:31] [index:background] Health check [2024-01-27 14:55:20] [indexer:background] Health check [2024-01-27 14:55:28] [index:background] Health check [2024-01-27 15:00:11] [indexer:background] Health check [2024-01-27 15:00:34] [index:background] Health check [2024-01-27 15:05:24] [indexer:background] Health check [2024-01-27 15:05:24] [index:background] Health check [2024-01-27 15:10:02] [indexer:background] Health check [2024-01-27 15:10:25] [index:background] Health check [2024-01-27 15:15:22] [indexer:background] Health check [2024-01-27 15:15:30] [index:background] Health check [2024-01-27 15:21:15] [indexer:background] Health check [2024-01-27 15:21:15] [index:background] Health check [2024-01-27 15:26:21] [indexer:background] Health check [2024-01-27 15:26:21] [index:background] Health check [2024-01-27 15:36:17] [indexer:background] Health check [2024-01-27 15:36:17] [index:background] Health check [2024-01-27 15:40:33] [indexer:background] Health check [2024-01-27 15:40:33] [index:background] Health check [2024-01-27 15:45:02] [indexer:background] Health check [2024-01-27 15:45:35] [index:background] Health check [2024-01-27 15:50:25] [indexer:background] Health check [2024-01-27 15:50:25] [index:background] Health check [2024-01-27 15:56:16] [indexer:background] Health check [2024-01-27 15:56:16] [index:background] Health check [2024-01-27 16:00:52] [indexer:background] Health check [2024-01-27 16:00:52] [index:background] Health check [2024-01-27 16:05:10] [indexer:background] Health check [2024-01-27 16:05:30] [index:background] Health check [2024-01-27 16:09:57] [indexer:background] Health check [2024-01-27 16:10:53] [index:background] Health check [2024-01-27 16:15:02] [indexer:background] Health check [2024-01-27 16:15:31] [index:background] Health check [2024-01-27 16:20:38] [indexer:background] Health check [2024-01-27 16:20:38] [index:background] Health check [2024-01-27 16:25:02] [indexer:background] Health check [2024-01-27 16:26:17] [index:background] Health check [2024-01-27 16:30:00] [indexer:background] Health check [2024-01-27 16:30:51] [index:background] Health check [2024-01-27 16:35:21] [indexer:background] Health check [2024-01-27 16:35:37] [index:background] Health check [2024-01-27 16:40:05] [indexer:background] Health check [2024-01-27 16:40:36] [index:background] Health check [2024-01-27 16:45:04] [indexer:background] Health check [2024-01-27 16:45:38] [index:background] Health check [2024-01-27 16:50:24] [indexer:background] Health check [2024-01-27 16:50:24] [index:background] Health check [2024-01-27 16:50:30] [query] Query for: 2024 [2024-01-27 16:50:30] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-01-27 16:50:30] [query] Engine: default [2024-01-27 16:50:30] [query] Tokens: 2024 [2024-01-27 16:50:30] [query] Mods: 6 [2024-01-27 16:50:30] [query] Found results using: or logic [2024-01-27 16:50:30] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-01-27 16:50:30] [query] Results: 132 Pages of results: 14 [2024-01-27 16:50:30] [query] Execution time: 0.39150 [2024-01-27 16:55:12] [indexer:background] Health check [2024-01-27 16:55:47] [index:background] Health check [2024-01-27 16:59:58] [indexer:background] Health check [2024-01-27 17:00:30] [index:background] Health check [2024-01-27 17:05:12] [indexer:background] Health check [2024-01-27 17:06:07] [index:background] Health check [2024-01-27 17:10:12] [indexer:background] Health check [2024-01-27 17:10:55] [index:background] Health check [2024-01-27 17:15:02] [indexer:background] Health check [2024-01-27 17:17:51] [index:background] Health check [2024-01-27 17:20:48] [indexer:background] Health check [2024-01-27 17:20:48] [index:background] Health check [2024-01-27 17:25:16] [indexer:background] Health check [2024-01-27 17:25:44] [index:background] Health check [2024-01-27 17:30:01] [indexer:background] Health check [2024-01-27 17:30:43] [index:background] Health check [2024-01-27 17:35:16] [indexer:background] Health check [2024-01-27 17:35:33] [index:background] Health check [2024-01-27 17:40:26] [indexer:background] Health check [2024-01-27 17:40:26] [index:background] Health check [2024-01-27 17:46:03] [indexer:background] Health check [2024-01-27 17:46:03] [index:background] Health check [2024-01-27 17:50:00] [indexer:background] Health check [2024-01-27 17:50:34] [index:background] Health check [2024-01-27 17:55:09] [indexer:background] Health check [2024-01-27 17:57:12] [index:background] Health check [2024-01-27 18:00:51] [indexer:background] Health check [2024-01-27 18:00:51] [index:background] Health check [2024-01-27 18:05:11] [indexer:background] Health check [2024-01-27 18:06:10] [index:background] Health check [2024-01-27 18:10:20] [indexer:background] Health check [2024-01-27 18:11:38] [index:background] Health check [2024-01-27 18:15:45] [indexer:background] Health check [2024-01-27 18:15:45] [index:background] Health check [2024-01-27 18:20:10] [indexer:background] Health check [2024-01-27 18:20:49] [index:background] Health check [2024-01-27 18:25:19] [indexer:background] Health check [2024-01-27 18:25:33] [index:background] Health check [2024-01-27 18:31:24] [indexer:background] Health check [2024-01-27 18:31:24] [index:background] Health check [2024-01-27 18:36:16] [indexer:background] Health check [2024-01-27 18:36:16] [index:background] Health check [2024-01-27 18:40:07] [indexer:background] Health check [2024-01-27 18:40:07] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2] [2024-01-27 18:40:39] [index:background] Health check [2024-01-27 18:45:05] [indexer:background] Health check [2024-01-27 18:45:26] [index:background] Health check [2024-01-27 18:50:11] [indexer:background] Health check [2024-01-27 18:51:12] [index:background] Health check [2024-01-27 18:56:01] [indexer:background] Health check [2024-01-27 18:56:01] [index:background] Health check [2024-01-27 19:01:17] [indexer:background] Health check [2024-01-27 19:01:17] [index:background] Health check [2024-01-27 19:05:10] [indexer:background] Health check [2024-01-27 19:06:03] [index:background] Health check [2024-01-27 19:11:31] [indexer:background] Health check [2024-01-27 19:11:31] [index:background] Health check [2024-01-27 19:14:51] [query] Query for: 2024 [2024-01-27 19:14:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-01-27 19:14:51] [query] Engine: default [2024-01-27 19:14:51] [query] Tokens: 2024 [2024-01-27 19:14:51] [query] Mods: 6 [2024-01-27 19:14:51] [query] Found results using: or logic [2024-01-27 19:14:51] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-01-27 19:14:51] [query] Results: 132 Pages of results: 14 [2024-01-27 19:14:51] [query] Execution time: 0.04121 [2024-01-27 19:15:06] [indexer:background] Health check [2024-01-27 19:15:28] [index:background] Health check [2024-01-27 19:21:05] [indexer:background] Health check [2024-01-27 19:21:05] [index:background] Health check [2024-01-27 19:25:52] [indexer:background] Health check [2024-01-27 19:25:52] [index:background] Health check [2024-01-27 19:29:59] [indexer:background] Health check [2024-01-27 19:30:32] [index:background] Health check [2024-01-27 19:35:10] [indexer:background] Health check [2024-01-27 19:37:12] [index:background] Health check [2024-01-27 19:40:03] [indexer:background] Health check [2024-01-27 19:41:35] [index:background] Health check [2024-01-27 19:45:32] [indexer:background] Health check [2024-01-27 19:45:32] [index:background] Health check [2024-01-27 19:49:58] [indexer:background] Health check [2024-01-27 19:50:31] [index:background] Health check [2024-01-27 19:50:31] [index:background] CPU load threshold (3) breached: 7.59 [waiting 2] [2024-01-27 19:50:33] [indexer:background] CPU load threshold (3) breached: 7.59 [waiting 2] [2024-01-27 19:56:01] [indexer:background] Health check [2024-01-27 19:56:01] [index:background] Health check [2024-01-27 20:01:31] [indexer:background] Health check [2024-01-27 20:01:31] [index:background] Health check [2024-01-27 20:05:10] [indexer:background] Health check [2024-01-27 20:05:52] [index:background] Health check [2024-01-27 20:10:39] [indexer:background] Health check [2024-01-27 20:10:39] [index:background] Health check [2024-01-27 20:15:22] [indexer:background] Health check [2024-01-27 20:15:58] [index:background] Health check [2024-01-27 20:20:09] [indexer:background] Health check [2024-01-27 20:21:18] [index:background] Health check [2024-01-27 20:25:11] [indexer:background] Health check [2024-01-27 20:25:51] [index:background] Health check [2024-01-27 20:31:10] [indexer:background] Health check [2024-01-27 20:31:10] [index:background] Health check [2024-01-27 20:35:54] [indexer:background] Health check [2024-01-27 20:35:54] [index:background] Health check [2024-01-27 20:40:28] [indexer:background] Health check [2024-01-27 20:40:28] [index:background] Health check [2024-01-27 20:45:15] [indexer:background] Health check [2024-01-27 20:45:35] [index:background] Health check [2024-01-27 20:50:40] [indexer:background] Health check [2024-01-27 20:50:40] [index:background] Health check [2024-01-27 20:56:59] [indexer:background] Health check [2024-01-27 20:56:59] [index:background] Health check [2024-01-27 21:00:37] [indexer:background] Health check [2024-01-27 21:00:37] [index:background] Health check [2024-01-27 21:05:00] [indexer:background] Health check [2024-01-27 21:05:36] [index:background] Health check [2024-01-27 21:10:20] [indexer:background] Health check [2024-01-27 21:10:45] [index:background] Health check [2024-01-27 21:15:06] [indexer:background] Health check [2024-01-27 21:15:47] [index:background] Health check [2024-01-27 21:20:02] [indexer:background] Health check [2024-01-27 21:20:33] [index:background] Health check [2024-01-27 21:25:40] [indexer:background] Health check [2024-01-27 21:25:40] [index:background] Health check [2024-01-27 21:30:27] [indexer:background] Health check [2024-01-27 21:30:27] [index:background] Health check [2024-01-27 21:35:54] [indexer:background] Health check [2024-01-27 21:35:54] [index:background] Health check [2024-01-27 21:40:20] [indexer:background] Health check [2024-01-27 21:40:27] [index:background] Health check [2024-01-27 21:44:59] [indexer:background] Health check [2024-01-27 21:46:00] [index:background] Health check [2024-01-27 21:49:59] [indexer:background] Health check [2024-01-27 21:50:24] [index:background] Health check [2024-01-27 21:55:32] [indexer:background] Health check [2024-01-27 21:55:32] [index:background] Health check [2024-01-27 22:02:15] [indexer:background] Health check [2024-01-27 22:02:15] [index:background] Health check [2024-01-27 22:05:09] [indexer:background] Health check [2024-01-27 22:07:05] [index:background] Health check [2024-01-27 22:10:06] [indexer:background] Health check [2024-01-27 22:13:56] [index:background] Health check [2024-01-27 22:15:26] [indexer:background] Health check [2024-01-27 22:15:26] [index:background] Health check [2024-01-27 22:20:16] [indexer:background] Health check [2024-01-27 22:21:15] [index:background] Health check [2024-01-27 22:25:28] [indexer:background] Health check [2024-01-27 22:25:28] [index:background] Health check [2024-01-27 22:30:05] [indexer:background] Health check [2024-01-27 22:31:27] [index:background] Health check [2024-01-27 22:35:48] [indexer:background] Health check [2024-01-27 22:35:48] [index:background] Health check [2024-01-27 22:40:04] [indexer:background] Health check [2024-01-27 22:40:36] [index:background] Health check [2024-01-27 22:45:09] [indexer:background] Health check [2024-01-27 22:46:51] [index:background] Health check [2024-01-27 22:50:38] [indexer:background] Health check [2024-01-27 22:50:38] [index:background] Health check [2024-01-27 22:55:14] [indexer:background] Health check [2024-01-27 22:56:16] [index:background] Health check [2024-01-27 23:00:04] [indexer:background] Health check [2024-01-27 23:00:52] [index:background] Health check [2024-01-27 23:06:32] [indexer:background] Health check [2024-01-27 23:06:32] [index:background] Health check [2024-01-27 23:10:38] [indexer:background] Health check [2024-01-27 23:10:38] [index:background] Health check [2024-01-27 23:15:09] [indexer:background] Health check [2024-01-27 23:16:04] [index:background] Health check [2024-01-27 23:20:08] [indexer:background] Health check [2024-01-27 23:20:59] [index:background] Health check [2024-01-27 23:25:16] [indexer:background] Health check [2024-01-27 23:26:52] [index:background] Health check [2024-01-27 23:33:18] [indexer:background] Health check [2024-01-27 23:33:19] [index:background] Health check [2024-01-27 23:36:27] [indexer:background] Health check [2024-01-27 23:36:27] [index:background] Health check [2024-01-27 23:40:19] [indexer:background] Health check [2024-01-27 23:40:28] [index:background] Health check [2024-01-27 23:45:01] [indexer:background] Health check [2024-01-27 23:45:51] [index:background] Health check [2024-01-27 23:50:03] [indexer:background] Health check [2024-01-27 23:50:43] [index:background] Health check [2024-01-27 23:55:37] [indexer:background] Health check [2024-01-27 23:55:37] [index:background] Health check