[2024-02-01 00:00:06] [indexer:background] Health check [2024-02-01 00:02:53] [index:background] Health check [2024-02-01 00:05:42] [indexer:background] Health check [2024-02-01 00:05:42] [index:background] Health check [2024-02-01 00:10:18] [indexer:background] Health check [2024-02-01 00:13:37] [index:background] Health check [2024-02-01 00:15:36] [indexer:background] Health check [2024-02-01 00:15:36] [index:background] Health check [2024-02-01 00:23:00] [indexer:background] Health check [2024-02-01 00:23:00] [index:background] Health check [2024-02-01 00:29:08] [indexer:background] Health check [2024-02-01 00:29:08] [index:background] Health check [2024-02-01 00:30:36] [indexer:background] Health check [2024-02-01 00:30:36] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2024-02-01 00:30:38] [index:background] Health check [2024-02-01 00:30:38] [index:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2024-02-01 00:30:40] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2024-02-01 00:35:41] [indexer:background] Health check [2024-02-01 00:35:41] [index:background] Health check [2024-02-01 00:40:00] [indexer:background] Health check [2024-02-01 00:40:24] [index:background] Health check [2024-02-01 00:46:18] [indexer:background] Health check [2024-02-01 00:46:18] [index:background] Health check [2024-02-01 00:50:52] [indexer:background] Health check [2024-02-01 00:50:52] [index:background] Health check [2024-02-01 00:55:31] [indexer:background] Health check [2024-02-01 00:55:31] [index:background] Health check [2024-02-01 01:00:04] [indexer:background] Health check [2024-02-01 01:00:59] [index:background] Health check [2024-02-01 01:06:31] [indexer:background] Health check [2024-02-01 01:06:31] [indexer:background] Health check [2024-02-01 01:06:31] [index:background] Health check [2024-02-01 01:10:50] [indexer:background] Health check [2024-02-01 01:10:50] [index:background] Health check [2024-02-01 01:15:00] [indexer:background] Health check [2024-02-01 01:16:27] [index:background] Health check [2024-02-01 01:21:39] [indexer:background] Health check [2024-02-01 01:21:39] [index:background] Health check [2024-02-01 01:24:59] [indexer:background] Health check [2024-02-01 01:25:53] [index:background] Health check [2024-02-01 01:30:26] [indexer:background] Health check [2024-02-01 01:30:26] [index:background] Health check [2024-02-01 01:31:45] [query] Query for: 2024 [2024-02-01 01:31:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 01:31:45] [query] Engine: default [2024-02-01 01:31:45] [query] Tokens: 2024 [2024-02-01 01:31:45] [query] Mods: 6 [2024-02-01 01:31:45] [query] Found results using: or logic [2024-02-01 01:31: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 (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-02-01 01:31:45] [query] Results: 132 Pages of results: 14 [2024-02-01 01:31:45] [query] Execution time: 0.53435 [2024-02-01 01:31:45] [query] Query for: 2024 [2024-02-01 01:31:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-02-01 01:31:45] [query] Engine: default [2024-02-01 01:31:45] [query] Tokens: 2024 [2024-02-01 01:31:45] [query] Mods: 6 [2024-02-01 01:31:45] [query] Found results using: or logic [2024-02-01 01:31: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 (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, 100 [2024-02-01 01:31:45] [query] Results: 132 Pages of results: 2 [2024-02-01 01:31:45] [query] Execution time: 0.11247 [2024-02-01 01:37:00] [indexer:background] Health check [2024-02-01 01:37:00] [index:background] Health check [2024-02-01 01:40:27] [indexer:background] Health check [2024-02-01 01:40:27] [index:background] Health check [2024-02-01 01:46:15] [indexer:background] Health check [2024-02-01 01:46:15] [index:background] Health check [2024-02-01 01:50:27] [indexer:background] Health check [2024-02-01 01:50:27] [index:background] Health check [2024-02-01 01:55:01] [indexer:background] Health check [2024-02-01 01:56:22] [index:background] Health check [2024-02-01 02:01:11] [indexer:background] Health check [2024-02-01 02:01:11] [index:background] Health check [2024-02-01 02:05:49] [indexer:background] Health check [2024-02-01 02:05:49] [index:background] Health check [2024-02-01 02:13:39] [indexer:background] Health check [2024-02-01 02:13:39] [index:background] Health check [2024-02-01 02:15:06] [indexer:background] Health check [2024-02-01 02:16:29] [index:background] Health check [2024-02-01 02:20:53] [indexer:background] Health check [2024-02-01 02:20:54] [index:background] Health check [2024-02-01 02:25:57] [indexer:background] Health check [2024-02-01 02:25:57] [index:background] Health check [2024-02-01 02:30:35] [indexer:background] Health check [2024-02-01 02:30:35] [index:background] Health check [2024-02-01 02:35:01] [indexer:background] Health check [2024-02-01 02:35:45] [index:background] Health check [2024-02-01 02:40:05] [indexer:background] Health check [2024-02-01 02:40:49] [index:background] Health check [2024-02-01 02:44:59] [indexer:background] Health check [2024-02-01 02:45:53] [index:background] Health check [2024-02-01 02:45:53] [index:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2024-02-01 02:50:24] [indexer:background] Health check [2024-02-01 02:50:24] [indexer:background] CPU load threshold (3) breached: 3.99 [waiting 2] [2024-02-01 02:50:26] [index:background] Health check [2024-02-01 02:50:26] [index:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2024-02-01 02:50:28] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2024-02-01 02:55:26] [indexer:background] Health check [2024-02-01 02:55:26] [indexer:background] CPU load threshold (3) breached: 3.79 [waiting 2] [2024-02-01 02:55:28] [index:background] Health check [2024-02-01 02:55:28] [index:background] CPU load threshold (3) breached: 3.79 [waiting 2] [2024-02-01 02:55:30] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2] [2024-02-01 03:00:02] [indexer:background] Health check [2024-02-01 03:00:02] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2] [2024-02-01 03:00:33] [index:background] Health check [2024-02-01 03:00:33] [index:background] CPU load threshold (3) breached: 3.49 [waiting 2] [2024-02-01 03:00:35] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2] [2024-02-01 03:05:36] [indexer:background] Health check [2024-02-01 03:05:36] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2024-02-01 03:05:39] [index:background] Health check [2024-02-01 03:05:39] [index:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2024-02-01 03:05:41] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2] [2024-02-01 03:10:04] [indexer:background] Health check [2024-02-01 03:10:26] [index:background] Health check [2024-02-01 03:10:26] [index:background] CPU load threshold (3) breached: 3.99 [waiting 2] [2024-02-01 03:10:29] [indexer:background] CPU load threshold (3) breached: 3.99 [waiting 2] [2024-02-01 03:14:59] [indexer:background] Health check [2024-02-01 03:14:59] [indexer:background] CPU load threshold (3) breached: 4.35 [waiting 2] [2024-02-01 03:16:00] [index:background] Health check [2024-02-01 03:16:00] [index:background] CPU load threshold (3) breached: 5.27 [waiting 2] [2024-02-01 03:16:02] [indexer:background] CPU load threshold (3) breached: 5.01 [waiting 2] [2024-02-01 03:20:00] [indexer:background] Health check [2024-02-01 03:20:00] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2] [2024-02-01 03:23:15] [index:background] Health check [2024-02-01 03:23:15] [index:background] CPU load threshold (3) breached: 4.26 [waiting 2] [2024-02-01 03:23:17] [indexer:background] CPU load threshold (3) breached: 4.4 [waiting 2] [2024-02-01 03:25:20] [indexer:background] Health check [2024-02-01 03:25:20] [indexer:background] CPU load threshold (3) breached: 4.22 [waiting 2] [2024-02-01 03:26:03] [index:background] Health check [2024-02-01 03:26:03] [index:background] CPU load threshold (3) breached: 4.53 [waiting 2] [2024-02-01 03:26:05] [indexer:background] CPU load threshold (3) breached: 4.53 [waiting 2] [2024-02-01 03:31:42] [indexer:background] Health check [2024-02-01 03:31:42] [indexer:background] CPU load threshold (3) breached: 4.06 [waiting 2] [2024-02-01 03:31:45] [index:background] Health check [2024-02-01 03:31:45] [index:background] CPU load threshold (3) breached: 4.06 [waiting 2] [2024-02-01 03:31:47] [indexer:background] CPU load threshold (3) breached: 3.82 [waiting 2] [2024-02-01 03:35:27] [indexer:background] Health check [2024-02-01 03:35:27] [indexer:background] CPU load threshold (3) breached: 4.99 [waiting 2] [2024-02-01 03:35:29] [index:background] Health check [2024-02-01 03:35:29] [index:background] CPU load threshold (3) breached: 4.99 [waiting 2] [2024-02-01 03:35:31] [indexer:background] CPU load threshold (3) breached: 4.99 [waiting 2] [2024-02-01 03:41:01] [indexer:background] Health check [2024-02-01 03:41:01] [indexer:background] CPU load threshold (3) breached: 5.65 [waiting 2] [2024-02-01 03:41:04] [index:background] Health check [2024-02-01 03:41:04] [index:background] CPU load threshold (3) breached: 6.32 [waiting 2] [2024-02-01 03:41:06] [indexer:background] CPU load threshold (3) breached: 6.32 [waiting 2] [2024-02-01 03:45:04] [indexer:background] Health check [2024-02-01 03:45:04] [indexer:background] CPU load threshold (3) breached: 5.38 [waiting 2] [2024-02-01 03:46:11] [index:background] Health check [2024-02-01 03:46:11] [index:background] CPU load threshold (3) breached: 5.09 [waiting 2] [2024-02-01 03:46:13] [indexer:background] CPU load threshold (3) breached: 4.84 [waiting 2] [2024-02-01 03:50:03] [indexer:background] Health check [2024-02-01 03:50:03] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2] [2024-02-01 03:51:27] [index:background] Health check [2024-02-01 03:51:27] [index:background] CPU load threshold (3) breached: 4.85 [waiting 2] [2024-02-01 03:51:29] [indexer:background] CPU load threshold (3) breached: 4.86 [waiting 2] [2024-02-01 03:56:02] [indexer:background] Health check [2024-02-01 03:56:02] [index:background] Health check [2024-02-01 04:02:01] [indexer:background] Health check [2024-02-01 04:02:01] [index:background] Health check [2024-02-01 04:05:52] [indexer:background] Health check [2024-02-01 04:05:52] [index:background] Health check [2024-02-01 04:10:43] [indexer:background] Health check [2024-02-01 04:10:43] [index:background] Health check [2024-02-01 04:15:14] [indexer:background] Health check [2024-02-01 04:16:02] [index:background] Health check [2024-02-01 04:20:08] [indexer:background] Health check [2024-02-01 04:21:42] [index:background] Health check [2024-02-01 04:25:05] [indexer:background] Health check [2024-02-01 04:27:10] [index:background] Health check [2024-02-01 04:30:30] [indexer:background] Health check [2024-02-01 04:30:30] [index:background] Health check [2024-02-01 04:35:02] [indexer:background] Health check [2024-02-01 04:36:12] [index:background] Health check [2024-02-01 04:40:04] [indexer:background] Health check [2024-02-01 04:40:25] [index:background] Health check [2024-02-01 04:46:28] [indexer:background] Health check [2024-02-01 04:46:28] [index:background] Health check [2024-02-01 04:50:09] [indexer:background] Health check [2024-02-01 04:50:26] [index:background] Health check [2024-02-01 04:55:40] [indexer:background] Health check [2024-02-01 04:55:40] [index:background] Health check [2024-02-01 05:00:30] [indexer:background] Health check [2024-02-01 05:00:30] [index:background] Health check [2024-02-01 05:06:03] [indexer:background] Health check [2024-02-01 05:06:08] [index:background] Health check [2024-02-01 05:10:01] [indexer:background] Health check [2024-02-01 05:10:26] [index:background] Health check [2024-02-01 05:15:46] [indexer:background] Health check [2024-02-01 05:15:46] [index:background] Health check [2024-02-01 05:20:01] [indexer:background] Health check [2024-02-01 05:20:59] [index:background] Health check [2024-02-01 05:25:43] [indexer:background] Health check [2024-02-01 05:25:44] [index:background] Health check [2024-02-01 05:30:05] [indexer:background] Health check [2024-02-01 05:30:26] [index:background] Health check [2024-02-01 05:35:06] [indexer:background] Health check [2024-02-01 05:35:50] [index:background] Health check [2024-02-01 05:40:06] [indexer:background] Health check [2024-02-01 05:41:30] [index:background] Health check [2024-02-01 05:47:11] [indexer:background] Health check [2024-02-01 05:47:11] [index:background] Health check [2024-02-01 05:50:04] [indexer:background] Health check [2024-02-01 05:50:53] [index:background] Health check [2024-02-01 05:55:44] [indexer:background] Health check [2024-02-01 05:55:44] [index:background] Health check [2024-02-01 06:00:00] [indexer:background] Health check [2024-02-01 06:01:25] [index:background] Health check [2024-02-01 06:05:16] [indexer:background] Health check [2024-02-01 06:05:37] [index:background] Health check [2024-02-01 06:10:06] [indexer:background] Health check [2024-02-01 06:11:13] [index:background] Health check [2024-02-01 06:15:29] [indexer:background] Health check [2024-02-01 06:15:29] [index:background] Health check [2024-02-01 06:20:04] [indexer:background] Health check [2024-02-01 06:20:31] [index:background] Health check [2024-02-01 06:25:21] [indexer:background] Health check [2024-02-01 06:25:40] [index:background] Health check [2024-02-01 06:31:05] [indexer:background] Health check [2024-02-01 06:31:05] [index:background] Health check [2024-02-01 06:35:17] [indexer:background] Health check [2024-02-01 06:36:40] [index:background] Health check [2024-02-01 06:41:30] [indexer:background] Health check [2024-02-01 06:41:30] [index:background] Health check [2024-02-01 06:45:12] [indexer:background] Health check [2024-02-01 06:45:41] [index:background] Health check [2024-02-01 06:50:04] [indexer:background] Health check [2024-02-01 06:50:46] [index:background] Health check [2024-02-01 06:55:03] [indexer:background] Health check [2024-02-01 06:55:38] [index:background] Health check [2024-02-01 07:00:41] [indexer:background] Health check [2024-02-01 07:00:42] [index:background] Health check [2024-02-01 07:05:51] [indexer:background] Health check [2024-02-01 07:05:51] [index:background] Health check [2024-02-01 07:10:29] [indexer:background] Health check [2024-02-01 07:10:29] [index:background] Health check [2024-02-01 07:14:59] [indexer:background] Health check [2024-02-01 07:16:04] [index:background] Health check [2024-02-01 07:20:30] [indexer:background] Health check [2024-02-01 07:20:30] [index:background] Health check [2024-02-01 07:26:23] [indexer:background] Health check [2024-02-01 07:26:23] [index:background] Health check [2024-02-01 07:26:53] [query] Query for: 2024 [2024-02-01 07:26:53] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 07:26:53] [query] Engine: default [2024-02-01 07:26:53] [query] Tokens: 2024 [2024-02-01 07:26:53] [query] Mods: 6 [2024-02-01 07:26:53] [query] Found results using: or logic [2024-02-01 07:26:53] [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-02-01 07:26:53] [query] Results: 132 Pages of results: 14 [2024-02-01 07:26:53] [query] Execution time: 0.04150 [2024-02-01 07:28:40] [query] Query for: 2024 [2024-02-01 07:28:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2024-02-01 07:28:40] [query] Engine: default [2024-02-01 07:28:40] [query] Tokens: 2024 [2024-02-01 07:28:40] [query] Mods: 6 [2024-02-01 07:28:40] [query] Found results using: or logic [2024-02-01 07:28:40] [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 10, 10 [2024-02-01 07:28:40] [query] Results: 132 Pages of results: 14 [2024-02-01 07:28:40] [query] Execution time: 0.10671 [2024-02-01 07:30:00] [indexer:background] Health check [2024-02-01 07:30:23] [index:background] Health check [2024-02-01 07:35:03] [indexer:background] Health check [2024-02-01 07:36:16] [index:background] Health check [2024-02-01 07:39:57] [indexer:background] Health check [2024-02-01 07:41:10] [index:background] Health check [2024-02-01 07:45:01] [indexer:background] Health check [2024-02-01 07:46:19] [index:background] Health check [2024-02-01 07:50:35] [indexer:background] Health check [2024-02-01 07:50:35] [index:background] Health check [2024-02-01 07:55:01] [indexer:background] Health check [2024-02-01 07:56:31] [index:background] Health check [2024-02-01 07:58:56] [query] Query for: 2023 [2024-02-01 07:58:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 07:58:56] [query] Engine: default [2024-02-01 07:58:57] [query] Tokens: 2023 [2024-02-01 07:58:57] [query] Mods: 6 [2024-02-01 07:58:57] [query] Found results using: or logic [2024-02-01 07:58:57] [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-02-01 07:58:57] [query] Results: 255 Pages of results: 26 [2024-02-01 07:58:57] [query] Execution time: 1.01927 [2024-02-01 08:00:01] [indexer:background] Health check [2024-02-01 08:00:31] [index:background] Health check [2024-02-01 08:05:45] [indexer:background] Health check [2024-02-01 08:05:45] [index:background] Health check [2024-02-01 08:10:33] [query] Query for: 2023 [2024-02-01 08:10:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2024-02-01 08:10:33] [query] Engine: default [2024-02-01 08:10:33] [query] Tokens: 2023 [2024-02-01 08:10:33] [query] Mods: 6 [2024-02-01 08:10:33] [query] Found results using: or logic [2024-02-01 08:10:33] [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 10, 10 [2024-02-01 08:10:33] [query] Results: 255 Pages of results: 26 [2024-02-01 08:10:33] [query] Execution time: 0.06293 [2024-02-01 08:11:14] [indexer:background] Health check [2024-02-01 08:11:14] [index:background] Health check [2024-02-01 08:15:05] [indexer:background] Health check [2024-02-01 08:15:35] [index:background] Health check [2024-02-01 08:21:32] [indexer:background] Health check [2024-02-01 08:21:33] [index:background] Health check [2024-02-01 08:26:58] [indexer:background] Health check [2024-02-01 08:26:58] [index:background] Health check [2024-02-01 08:30:46] [indexer:background] Health check [2024-02-01 08:30:46] [index:background] Health check [2024-02-01 08:35:37] [indexer:background] Health check [2024-02-01 08:35:37] [index:background] Health check [2024-02-01 08:40:11] [indexer:background] Health check [2024-02-01 08:40:42] [index:background] Health check [2024-02-01 08:45:03] [indexer:background] Health check [2024-02-01 08:45:28] [index:background] Health check [2024-02-01 08:50:00] [indexer:background] Health check [2024-02-01 08:51:04] [index:background] Health check [2024-02-01 08:55:01] [indexer:background] Health check [2024-02-01 08:55:26] [index:background] Health check [2024-02-01 08:55:26] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2024-02-01 08:55:28] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2] [2024-02-01 08:59:59] [indexer:background] Health check [2024-02-01 08:59:59] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2] [2024-02-01 09:02:25] [index:background] Health check [2024-02-01 09:02:25] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2024-02-01 09:02:27] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2024-02-01 09:05:12] [indexer:background] Health check [2024-02-01 09:06:38] [index:background] Health check [2024-02-01 09:10:51] [indexer:background] Health check [2024-02-01 09:10:51] [index:background] Health check [2024-02-01 09:15:24] [indexer:background] Health check [2024-02-01 09:15:24] [index:background] Health check [2024-02-01 09:20:09] [indexer:background] Health check [2024-02-01 09:20:41] [index:background] Health check [2024-02-01 09:20:41] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2024-02-01 09:20:43] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2024-02-01 09:25:09] [indexer:background] Health check [2024-02-01 09:25:40] [index:background] Health check [2024-02-01 09:30:00] [indexer:background] Health check [2024-02-01 09:30:00] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2] [2024-02-01 09:30:26] [index:background] Health check [2024-02-01 09:30:26] [index:background] CPU load threshold (3) breached: 3.49 [waiting 2] [2024-02-01 09:30:28] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2] [2024-02-01 09:34:59] [indexer:background] Health check [2024-02-01 09:35:54] [index:background] Health check [2024-02-01 09:40:43] [indexer:background] Health check [2024-02-01 09:40:43] [index:background] Health check [2024-02-01 09:45:03] [indexer:background] Health check [2024-02-01 09:46:08] [index:background] Health check [2024-02-01 09:50:10] [indexer:background] Health check [2024-02-01 09:51:43] [index:background] Health check [2024-02-01 09:55:14] [indexer:background] Health check [2024-02-01 09:57:36] [index:background] Health check [2024-02-01 10:00:35] [indexer:background] Health check [2024-02-01 10:00:35] [index:background] Health check [2024-02-01 10:00:35] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2024-02-01 10:00:37] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2024-02-01 10:05:26] [indexer:background] Health check [2024-02-01 10:05:26] [index:background] Health check [2024-02-01 10:11:10] [indexer:background] Health check [2024-02-01 10:11:10] [index:background] Health check [2024-02-01 10:15:24] [indexer:background] Health check [2024-02-01 10:15:24] [index:background] Health check [2024-02-01 10:21:05] [indexer:background] Health check [2024-02-01 10:21:05] [index:background] Health check [2024-02-01 10:25:05] [indexer:background] Health check [2024-02-01 10:25:05] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2024-02-01 10:25:30] [index:background] Health check [2024-02-01 10:30:03] [indexer:background] Health check [2024-02-01 10:31:14] [index:background] Health check [2024-02-01 10:35:25] [indexer:background] Health check [2024-02-01 10:35:25] [index:background] Health check [2024-02-01 10:41:10] [indexer:background] Health check [2024-02-01 10:41:10] [index:background] Health check [2024-02-01 10:45:09] [indexer:background] Health check [2024-02-01 10:46:34] [index:background] Health check [2024-02-01 10:50:46] [indexer:background] Health check [2024-02-01 10:50:46] [index:background] Health check [2024-02-01 10:55:33] [indexer:background] Health check [2024-02-01 10:55:33] [index:background] Health check [2024-02-01 11:01:19] [indexer:background] Health check [2024-02-01 11:01:19] [index:background] Health check [2024-02-01 11:06:06] [indexer:background] Health check [2024-02-01 11:06:06] [index:background] Health check [2024-02-01 11:11:32] [indexer:background] Health check [2024-02-01 11:11:32] [index:background] Health check [2024-02-01 11:15:03] [indexer:background] Health check [2024-02-01 11:15:29] [index:background] Health check [2024-02-01 11:20:13] [indexer:background] Health check [2024-02-01 11:20:35] [index:background] Health check [2024-02-01 11:25:03] [indexer:background] Health check [2024-02-01 11:26:57] [index:background] Health check [2024-02-01 11:30:52] [indexer:background] Health check [2024-02-01 11:30:52] [index:background] Health check [2024-02-01 11:35:11] [indexer:background] Health check [2024-02-01 11:35:59] [index:background] Health check [2024-02-01 11:40:33] [indexer:background] Health check [2024-02-01 11:40:33] [index:background] Health check [2024-02-01 11:44:59] [indexer:background] Health check [2024-02-01 11:45:03] [query] Query for: 2023 [2024-02-01 11:45:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 11:45:03] [query] Engine: default [2024-02-01 11:45:03] [query] Tokens: 2023 [2024-02-01 11:45:03] [query] Mods: 6 [2024-02-01 11:45:03] [query] Found results using: or logic [2024-02-01 11:45:03] [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-02-01 11:45:03] [query] Results: 255 Pages of results: 26 [2024-02-01 11:45:03] [query] Execution time: 0.03853 [2024-02-01 11:45:03] [query] Query for: 2023 [2024-02-01 11:45:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-02-01 11:45:03] [query] Engine: default [2024-02-01 11:45:03] [query] Tokens: 2023 [2024-02-01 11:45:03] [query] Mods: 6 [2024-02-01 11:45:04] [query] Found results using: or logic [2024-02-01 11:45:04] [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-02-01 11:45:04] [query] Results: 255 Pages of results: 3 [2024-02-01 11:45:04] [query] Execution time: 0.20376 [2024-02-01 11:45:42] [index:background] Health check [2024-02-01 11:50:12] [indexer:background] Health check [2024-02-01 11:50:12] [indexer:background] CPU load threshold (3) breached: 4.38 [waiting 2] [2024-02-01 11:50:47] [index:background] Health check [2024-02-01 11:50:47] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2024-02-01 11:50:49] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2024-02-01 11:55:38] [indexer:background] Health check [2024-02-01 11:55:39] [index:background] Health check [2024-02-01 12:00:11] [indexer:background] Health check [2024-02-01 12:00:49] [index:background] Health check [2024-02-01 12:05:19] [indexer:background] Health check [2024-02-01 12:05:46] [index:background] Health check [2024-02-01 12:11:54] [indexer:background] Health check [2024-02-01 12:11:54] [index:background] Health check [2024-02-01 12:15:17] [indexer:background] Health check [2024-02-01 12:15:42] [index:background] Health check [2024-02-01 12:20:05] [indexer:background] Health check [2024-02-01 12:20:27] [index:background] Health check [2024-02-01 12:25:55] [indexer:background] Health check [2024-02-01 12:25:55] [index:background] Health check [2024-02-01 12:30:38] [indexer:background] Health check [2024-02-01 12:30:38] [index:background] Health check [2024-02-01 12:35:52] [indexer:background] Health check [2024-02-01 12:35:52] [index:background] Health check [2024-02-01 12:40:10] [indexer:background] Health check [2024-02-01 12:40:42] [index:background] Health check [2024-02-01 12:45:26] [indexer:background] Health check [2024-02-01 12:45:26] [index:background] Health check [2024-02-01 12:50:10] [indexer:background] Health check [2024-02-01 12:50:31] [index:background] Health check [2024-02-01 12:56:11] [indexer:background] Health check [2024-02-01 12:56:12] [index:background] Health check [2024-02-01 13:03:13] [indexer:background] Health check [2024-02-01 13:03:13] [index:background] Health check [2024-02-01 13:05:11] [indexer:background] Health check [2024-02-01 13:06:33] [index:background] Health check [2024-02-01 13:10:02] [indexer:background] Health check [2024-02-01 13:10:57] [index:background] Health check [2024-02-01 13:15:03] [indexer:background] Health check [2024-02-01 13:15:45] [index:background] Health check [2024-02-01 13:20:08] [indexer:background] Health check [2024-02-01 13:21:38] [index:background] Health check [2024-02-01 13:27:16] [indexer:background] Health check [2024-02-01 13:27:17] [index:background] Health check [2024-02-01 13:30:01] [indexer:background] Health check [2024-02-01 13:30:01] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2] [2024-02-01 13:31:27] [index:background] Health check [2024-02-01 13:35:01] [indexer:background] Health check [2024-02-01 13:35:40] [index:background] Health check [2024-02-01 13:40:29] [indexer:background] Health check [2024-02-01 13:40:29] [index:background] Health check [2024-02-01 13:45:35] [indexer:background] Health check [2024-02-01 13:45:35] [index:background] Health check [2024-02-01 13:50:12] [indexer:background] Health check [2024-02-01 13:51:09] [index:background] Health check [2024-02-01 13:55:22] [indexer:background] Health check [2024-02-01 13:56:46] [index:background] Health check [2024-02-01 14:00:59] [indexer:background] Health check [2024-02-01 14:00:59] [index:background] Health check [2024-02-01 14:05:22] [indexer:background] Health check [2024-02-01 14:05:32] [index:background] Health check [2024-02-01 14:12:22] [indexer:background] Health check [2024-02-01 14:12:22] [index:background] Health check [2024-02-01 14:15:01] [indexer:background] Health check [2024-02-01 14:15:47] [index:background] Health check [2024-02-01 14:21:39] [indexer:background] Health check [2024-02-01 14:21:39] [index:background] Health check [2024-02-01 14:25:52] [indexer:background] Health check [2024-02-01 14:25:52] [index:background] Health check [2024-02-01 14:30:14] [indexer:background] Health check [2024-02-01 14:30:39] [index:background] Health check [2024-02-01 14:36:05] [indexer:background] Health check [2024-02-01 14:36:05] [index:background] Health check [2024-02-01 14:41:37] [indexer:background] Health check [2024-02-01 14:41:37] [index:background] Health check [2024-02-01 14:45:10] [indexer:background] Health check [2024-02-01 14:45:25] [index:background] Health check [2024-02-01 14:50:22] [indexer:background] Health check [2024-02-01 14:51:47] [index:background] Health check [2024-02-01 14:54:58] [indexer:background] Health check [2024-02-01 14:55:38] [index:background] Health check [2024-02-01 15:01:28] [indexer:background] Health check [2024-02-01 15:01:28] [index:background] Health check [2024-02-01 15:05:17] [indexer:background] Health check [2024-02-01 15:05:49] [index:background] Health check [2024-02-01 15:10:42] [indexer:background] Health check [2024-02-01 15:10:42] [index:background] Health check [2024-02-01 15:15:37] [indexer:background] Health check [2024-02-01 15:15:37] [index:background] Health check [2024-02-01 15:20:11] [indexer:background] Health check [2024-02-01 15:20:30] [index:background] Health check [2024-02-01 15:25:24] [indexer:background] Health check [2024-02-01 15:25:24] [index:background] Health check [2024-02-01 15:30:53] [indexer:background] Health check [2024-02-01 15:30:53] [index:background] Health check [2024-02-01 15:34:58] [indexer:background] Health check [2024-02-01 15:36:36] [index:background] Health check [2024-02-01 15:41:14] [query] Query for: 2023 [2024-02-01 15:41:14] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 15:41:14] [query] Engine: default [2024-02-01 15:41:14] [query] Tokens: 2023 [2024-02-01 15:41:14] [query] Mods: 6 [2024-02-01 15:41:14] [query] Found results using: or logic [2024-02-01 15:41:14] [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-02-01 15:41:14] [query] Results: 255 Pages of results: 26 [2024-02-01 15:41:14] [query] Execution time: 0.33228 [2024-02-01 15:41:14] [indexer:background] Health check [2024-02-01 15:41:14] [index:background] Health check [2024-02-01 15:45:19] [query] Query for: 2023 [2024-02-01 15:45:19] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2024-02-01 15:45:19] [query] Engine: default [2024-02-01 15:45:19] [query] Tokens: 2023 [2024-02-01 15:45:19] [query] Mods: 6 [2024-02-01 15:45:19] [query] Found results using: or logic [2024-02-01 15:45:19] [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 10, 10 [2024-02-01 15:45:19] [query] Results: 255 Pages of results: 26 [2024-02-01 15:45:19] [query] Execution time: 0.15054 [2024-02-01 15:45:20] [indexer:background] Health check [2024-02-01 15:45:36] [query] Query for: 2023 [2024-02-01 15:45:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 3 offset: 0 fields: all [2024-02-01 15:45:36] [query] Engine: default [2024-02-01 15:45:36] [query] Tokens: 2023 [2024-02-01 15:45:36] [query] Mods: 6 [2024-02-01 15:45:36] [query] Found results using: or logic [2024-02-01 15:45:37] [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 20, 10 [2024-02-01 15:45:37] [query] Results: 255 Pages of results: 26 [2024-02-01 15:45:37] [query] Execution time: 0.07057 [2024-02-01 15:45:37] [index:background] Health check [2024-02-01 15:50:13] [indexer:background] Health check [2024-02-01 15:51:19] [index:background] Health check [2024-02-01 15:55:14] [indexer:background] Health check [2024-02-01 15:56:12] [index:background] Health check [2024-02-01 15:59:59] [indexer:background] Health check [2024-02-01 16:01:56] [index:background] Health check [2024-02-01 16:05:01] [indexer:background] Health check [2024-02-01 16:05:33] [index:background] Health check [2024-02-01 16:10:00] [indexer:background] Health check [2024-02-01 16:10:25] [index:background] Health check [2024-02-01 16:15:06] [indexer:background] Health check [2024-02-01 16:16:41] [index:background] Health check [2024-02-01 16:20:02] [indexer:background] Health check [2024-02-01 16:20:55] [index:background] Health check [2024-02-01 16:24:59] [indexer:background] Health check [2024-02-01 16:24:59] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2] [2024-02-01 16:25:26] [index:background] Health check [2024-02-01 16:25:26] [index:background] CPU load threshold (3) breached: 3.08 [waiting 2] [2024-02-01 16:25:28] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2] [2024-02-01 16:29:58] [indexer:background] Health check [2024-02-01 16:30:24] [index:background] Health check [2024-02-01 16:34:59] [indexer:background] Health check [2024-02-01 16:35:25] [index:background] Health check [2024-02-01 16:40:00] [indexer:background] Health check [2024-02-01 16:40:26] [index:background] Health check [2024-02-01 16:44:58] [indexer:background] Health check [2024-02-01 16:45:24] [index:background] Health check [2024-02-01 16:49:58] [indexer:background] Health check [2024-02-01 16:50:25] [index:background] Health check [2024-02-01 16:54:59] [indexer:background] Health check [2024-02-01 16:55:28] [index:background] Health check [2024-02-01 17:00:03] [indexer:background] Health check [2024-02-01 17:00:26] [index:background] Health check [2024-02-01 17:05:00] [indexer:background] Health check [2024-02-01 17:05:26] [index:background] Health check [2024-02-01 17:10:04] [indexer:background] Health check [2024-02-01 17:11:19] [index:background] Health check [2024-02-01 17:15:25] [indexer:background] Health check [2024-02-01 17:15:25] [index:background] Health check [2024-02-01 17:20:53] [indexer:background] Health check [2024-02-01 17:20:53] [index:background] Health check [2024-02-01 17:25:38] [indexer:background] Health check [2024-02-01 17:25:38] [index:background] Health check [2024-02-01 17:30:35] [indexer:background] Health check [2024-02-01 17:30:35] [index:background] Health check [2024-02-01 17:36:09] [indexer:background] Health check [2024-02-01 17:36:09] [index:background] Health check [2024-02-01 17:40:37] [indexer:background] Health check [2024-02-01 17:40:37] [index:background] Health check [2024-02-01 17:45:03] [indexer:background] Health check [2024-02-01 17:46:47] [index:background] Health check [2024-02-01 17:49:34] [query] Query for: 2024 [2024-02-01 17:49:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 17:49:34] [query] Engine: default [2024-02-01 17:49:34] [query] Tokens: 2024 [2024-02-01 17:49:34] [query] Mods: 6 [2024-02-01 17:49:34] [query] Found results using: or logic [2024-02-01 17:49:34] [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-02-01 17:49:34] [query] Results: 132 Pages of results: 14 [2024-02-01 17:49:34] [query] Execution time: 0.43630 [2024-02-01 17:52:50] [indexer:background] Health check [2024-02-01 17:52:50] [index:background] Health check [2024-02-01 17:55:04] [indexer:background] Health check [2024-02-01 17:55:51] [index:background] Health check [2024-02-01 17:59:57] [indexer:background] Health check [2024-02-01 18:00:54] [index:background] Health check [2024-02-01 18:05:40] [indexer:background] Health check [2024-02-01 18:05:40] [index:background] Health check [2024-02-01 18:11:14] [indexer:background] Health check [2024-02-01 18:11:14] [index:background] Health check [2024-02-01 18:16:36] [indexer:background] Health check [2024-02-01 18:16:36] [index:background] Health check [2024-02-01 18:20:02] [indexer:background] Health check [2024-02-01 18:20:56] [index:background] Health check [2024-02-01 18:25:17] [indexer:background] Health check [2024-02-01 18:26:36] [index:background] Health check [2024-02-01 18:30:47] [indexer:background] Health check [2024-02-01 18:30:47] [index:background] Health check [2024-02-01 18:35:10] [indexer:background] Health check [2024-02-01 18:39:18] [index:background] Health check [2024-02-01 18:40:26] [indexer:background] Health check [2024-02-01 18:40:26] [index:background] Health check [2024-02-01 18:44:59] [indexer:background] Health check [2024-02-01 18:46:17] [index:background] Health check [2024-02-01 18:50:36] [indexer:background] Health check [2024-02-01 18:50:36] [index:background] Health check [2024-02-01 18:55:21] [indexer:background] Health check [2024-02-01 18:55:30] [index:background] Health check [2024-02-01 19:00:19] [indexer:background] Health check [2024-02-01 19:00:55] [index:background] Health check [2024-02-01 19:05:08] [indexer:background] Health check [2024-02-01 19:06:02] [index:background] Health check [2024-02-01 19:10:17] [indexer:background] Health check [2024-02-01 19:11:45] [index:background] Health check [2024-02-01 19:15:03] [indexer:background] Health check [2024-02-01 19:15:50] [index:background] Health check [2024-02-01 19:20:03] [indexer:background] Health check [2024-02-01 19:20:33] [index:background] Health check [2024-02-01 19:25:08] [indexer:background] Health check [2024-02-01 19:25:24] [index:background] Health check [2024-02-01 19:30:08] [indexer:background] Health check [2024-02-01 19:30:30] [index:background] Health check [2024-02-01 19:35:06] [indexer:background] Health check [2024-02-01 19:35:28] [index:background] Health check [2024-02-01 19:40:12] [indexer:background] Health check [2024-02-01 19:40:27] [index:background] Health check [2024-02-01 19:45:29] [indexer:background] Health check [2024-02-01 19:45:29] [index:background] Health check [2024-02-01 19:48:02] [query] Query for: 2024 [2024-02-01 19:48:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-02-01 19:48:02] [query] Engine: default [2024-02-01 19:48:02] [query] Tokens: 2024 [2024-02-01 19:48:02] [query] Mods: 6 [2024-02-01 19:48:02] [query] Found results using: or logic [2024-02-01 19:48:02] [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-02-01 19:48:02] [query] Results: 132 Pages of results: 14 [2024-02-01 19:48:02] [query] Execution time: 0.04291 [2024-02-01 19:50:06] [indexer:background] Health check [2024-02-01 19:50:34] [index:background] Health check [2024-02-01 19:54:59] [indexer:background] Health check [2024-02-01 19:56:23] [index:background] Health check [2024-02-01 20:00:04] [indexer:background] Health check [2024-02-01 20:00:37] [index:background] Health check [2024-02-01 20:05:23] [indexer:background] Health check [2024-02-01 20:05:23] [index:background] Health check [2024-02-01 20:10:14] [indexer:background] Health check [2024-02-01 20:10:28] [index:background] Health check [2024-02-01 20:15:08] [indexer:background] Health check [2024-02-01 20:16:24] [index:background] Health check [2024-02-01 20:20:04] [indexer:background] Health check [2024-02-01 20:21:42] [index:background] Health check [2024-02-01 20:25:57] [indexer:background] Health check [2024-02-01 20:25:57] [index:background] Health check [2024-02-01 20:30:12] [indexer:background] Health check [2024-02-01 20:31:58] [index:background] Health check [2024-02-01 20:35:07] [indexer:background] Health check [2024-02-01 20:36:56] [index:background] Health check [2024-02-01 20:40:03] [indexer:background] Health check [2024-02-01 20:41:36] [index:background] Health check [2024-02-01 20:45:48] [indexer:background] Health check [2024-02-01 20:45:49] [index:background] Health check [2024-02-01 20:50:11] [indexer:background] Health check [2024-02-01 20:50:41] [index:background] Health check [2024-02-01 20:55:50] [indexer:background] Health check [2024-02-01 20:55:50] [index:background] Health check [2024-02-01 21:00:00] [indexer:background] Health check [2024-02-01 21:00:29] [index:background] Health check [2024-02-01 21:05:05] [indexer:background] Health check [2024-02-01 21:05:25] [index:background] Health check [2024-02-01 21:09:57] [indexer:background] Health check [2024-02-01 21:10:34] [index:background] Health check [2024-02-01 21:15:25] [indexer:background] Health check [2024-02-01 21:15:25] [index:background] Health check [2024-02-01 21:20:06] [indexer:background] Health check [2024-02-01 21:20:24] [index:background] Health check [2024-02-01 21:24:59] [indexer:background] Health check [2024-02-01 21:25:25] [index:background] Health check [2024-02-01 21:30:16] [indexer:background] Health check [2024-02-01 21:31:01] [index:background] Health check [2024-02-01 21:35:55] [indexer:background] Health check [2024-02-01 21:35:55] [index:background] Health check [2024-02-01 21:40:08] [indexer:background] Health check [2024-02-01 21:40:39] [index:background] Health check [2024-02-01 21:45:48] [indexer:background] Health check [2024-02-01 21:45:48] [index:background] Health check [2024-02-01 21:50:03] [indexer:background] Health check [2024-02-01 21:50:38] [index:background] Health check [2024-02-01 21:55:41] [indexer:background] Health check [2024-02-01 21:55:41] [index:background] Health check [2024-02-01 22:00:11] [indexer:background] Health check [2024-02-01 22:00:26] [index:background] Health check [2024-02-01 22:06:57] [indexer:background] Health check [2024-02-01 22:06:57] [index:background] Health check [2024-02-01 22:10:15] [indexer:background] Health check [2024-02-01 22:11:32] [index:background] Health check [2024-02-01 22:15:32] [indexer:background] Health check [2024-02-01 22:15:32] [index:background] Health check [2024-02-01 22:20:43] [indexer:background] Health check [2024-02-01 22:20:43] [index:background] Health check [2024-02-01 22:25:07] [indexer:background] Health check [2024-02-01 22:25:23] [index:background] Health check [2024-02-01 22:30:00] [indexer:background] Health check [2024-02-01 22:30:29] [index:background] Health check [2024-02-01 22:35:15] [indexer:background] Health check [2024-02-01 22:35:40] [index:background] Health check [2024-02-01 22:41:09] [indexer:background] Health check [2024-02-01 22:41:09] [index:background] Health check [2024-02-01 22:45:03] [indexer:background] Health check [2024-02-01 22:45:23] [index:background] Health check [2024-02-01 22:50:37] [indexer:background] Health check [2024-02-01 22:50:38] [index:background] Health check [2024-02-01 22:55:06] [indexer:background] Health check [2024-02-01 22:55:50] [index:background] Health check [2024-02-01 23:00:00] [indexer:background] Health check [2024-02-01 23:00:33] [index:background] Health check [2024-02-01 23:05:35] [indexer:background] Health check [2024-02-01 23:05:35] [index:background] Health check [2024-02-01 23:10:47] [indexer:background] Health check [2024-02-01 23:10:47] [index:background] Health check [2024-02-01 23:15:31] [indexer:background] Health check [2024-02-01 23:15:31] [index:background] Health check [2024-02-01 23:20:55] [indexer:background] Health check [2024-02-01 23:20:55] [index:background] Health check [2024-02-01 23:24:58] [indexer:background] Health check [2024-02-01 23:25:34] [index:background] Health check [2024-02-01 23:30:03] [indexer:background] Health check [2024-02-01 23:33:21] [index:background] Health check [2024-02-01 23:35:02] [indexer:background] Health check [2024-02-01 23:36:01] [index:background] Health check [2024-02-01 23:40:06] [indexer:background] Health check [2024-02-01 23:42:59] [index:background] Health check [2024-02-01 23:45:00] [indexer:background] Health check [2024-02-01 23:48:05] [index:background] Health check [2024-02-01 23:50:02] [indexer:background] Health check [2024-02-01 23:50:50] [index:background] Health check [2024-02-01 23:55:04] [indexer:background] Health check [2024-02-01 23:56:26] [index:background] Health check