[2023-10-24 00:02:52] [indexer:background] Health check [2023-10-24 00:04:33] [index:background] Health check [2023-10-24 00:07:16] [indexer:background] Health check [2023-10-24 00:12:00] [index:background] Health check [2023-10-24 00:12:00] [indexer:background] Health check [2023-10-24 00:12:00] [indexer:background] Health check [2023-10-24 00:13:43] [index:background] Health check [2023-10-24 00:17:18] [indexer:background] Health check [2023-10-24 00:18:43] [index:background] Health check [2023-10-24 00:25:31] [indexer:background] Health check [2023-10-24 00:25:32] [index:background] Health check [2023-10-24 00:27:51] [indexer:background] Health check [2023-10-24 00:29:10] [index:background] Health check [2023-10-24 00:32:00] [indexer:background] Health check [2023-10-24 00:33:03] [index:background] Health check [2023-10-24 00:36:54] [indexer:background] Health check [2023-10-24 00:39:13] [index:background] Health check [2023-10-24 00:43:47] [indexer:background] Health check [2023-10-24 00:43:47] [index:background] Health check [2023-10-24 00:47:22] [indexer:background] Health check [2023-10-24 00:48:48] [index:background] Health check [2023-10-24 00:56:15] [indexer:background] Health check [2023-10-24 00:56:15] [index:background] Health check [2023-10-24 00:57:48] [indexer:background] Health check [2023-10-24 01:00:31] [index:background] Health check [2023-10-24 01:02:27] [indexer:background] Health check [2023-10-24 01:03:26] [index:background] Health check [2023-10-24 01:08:28] [indexer:background] Health check [2023-10-24 01:08:28] [index:background] Health check [2023-10-24 01:13:49] [indexer:background] Health check [2023-10-24 01:13:49] [index:background] Health check [2023-10-24 01:17:47] [indexer:background] Health check [2023-10-24 01:19:04] [index:background] Health check [2023-10-24 01:22:02] [indexer:background] Health check [2023-10-24 01:23:18] [index:background] Health check [2023-10-24 01:27:29] [indexer:background] Health check [2023-10-24 01:28:17] [index:background] Health check [2023-10-24 01:33:32] [indexer:background] Health check [2023-10-24 01:33:32] [index:background] Health check [2023-10-24 01:36:54] [indexer:background] Health check [2023-10-24 01:38:33] [index:background] Health check [2023-10-24 01:42:18] [indexer:background] Health check [2023-10-24 01:45:08] [index:background] Health check [2023-10-24 01:48:54] [indexer:background] Health check [2023-10-24 01:48:54] [index:background] Health check [2023-10-24 01:49:11] [query] Query for: 2023 [2023-10-24 01:49:11] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-24 01:49:11] [query] Engine: default [2023-10-24 01:49:13] [query] Tokens: 2023 [2023-10-24 01:49:13] [query] Mods: 6 [2023-10-24 01:49:13] [query] Found results using: or logic [2023-10-24 01:49:13] [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 [2023-10-24 01:49:13] [query] Results: 249 Pages of results: 25 [2023-10-24 01:49:13] [query] Execution time: 1.69158 [2023-10-24 01:53:08] [indexer:background] Health check [2023-10-24 01:53:08] [index:background] Health check [2023-10-24 01:57:02] [indexer:background] Health check [2023-10-24 01:58:05] [index:background] Health check [2023-10-24 02:01:54] [indexer:background] Health check [2023-10-24 02:03:42] [index:background] Health check [2023-10-24 02:07:47] [indexer:background] Health check [2023-10-24 02:08:09] [index:background] Health check [2023-10-24 02:11:53] [indexer:background] Health check [2023-10-24 02:13:03] [index:background] Health check [2023-10-24 02:17:30] [indexer:background] Health check [2023-10-24 02:18:28] [index:background] Health check [2023-10-24 02:22:25] [indexer:background] Health check [2023-10-24 02:23:31] [index:background] Health check [2023-10-24 02:26:52] [indexer:background] Health check [2023-10-24 02:30:05] [index:background] Health check [2023-10-24 02:32:22] [indexer:background] Health check [2023-10-24 02:33:58] [index:background] Health check [2023-10-24 02:37:07] [indexer:background] Health check [2023-10-24 02:37:07] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-24 02:39:30] [index:background] Health check [2023-10-24 02:39:30] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-24 02:39:32] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-24 02:42:11] [indexer:background] Health check [2023-10-24 02:42:12] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2] [2023-10-24 02:43:08] [index:background] Health check [2023-10-24 02:47:14] [indexer:background] Health check [2023-10-24 02:47:14] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2] [2023-10-24 02:48:44] [index:background] Health check [2023-10-24 02:48:44] [index:background] CPU load threshold (3) breached: 4.17 [waiting 2] [2023-10-24 02:48:46] [indexer:background] CPU load threshold (3) breached: 4.17 [waiting 2] [2023-10-24 02:52:20] [query] Query for: {search_term_string} [2023-10-24 02:52:20] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 122 offset: 0 fields: all [2023-10-24 02:52:20] [query] Engine: default [2023-10-24 02:52:21] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-24 02:52:21] [query] Mods: 6 [2023-10-24 02:52:21] [query] Using OR logic [2023-10-24 02:52:21] [indexer:background] Health check [2023-10-24 02:52:21] [indexer:background] CPU load threshold (3) breached: 4.05 [waiting 2] [2023-10-24 02:52:23] [query] Found results using: or logic [2023-10-24 02:52:23] [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 1210, 10 [2023-10-24 02:52:23] [query] Results: 1344 Pages of results: 135 [2023-10-24 02:52:23] [query] Execution time: 2.61471 [2023-10-24 02:53:22] [index:background] Health check [2023-10-24 02:53:22] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-10-24 02:53:24] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-24 02:57:34] [indexer:background] Health check [2023-10-24 02:58:20] [index:background] Health check [2023-10-24 02:58:20] [index:background] CPU load threshold (3) breached: 3.84 [waiting 2] [2023-10-24 02:58:22] [indexer:background] CPU load threshold (3) breached: 3.84 [waiting 2] [2023-10-24 03:02:14] [indexer:background] Health check [2023-10-24 03:02:14] [indexer:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2023-10-24 03:03:26] [index:background] Health check [2023-10-24 03:03:26] [index:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2023-10-24 03:03:28] [indexer:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2023-10-24 03:08:16] [indexer:background] Health check [2023-10-24 03:08:16] [indexer:background] CPU load threshold (3) breached: 3.93 [waiting 2] [2023-10-24 03:08:18] [index:background] Health check [2023-10-24 03:08:18] [index:background] CPU load threshold (3) breached: 3.93 [waiting 2] [2023-10-24 03:08:20] [indexer:background] CPU load threshold (3) breached: 4.01 [waiting 2] [2023-10-24 03:11:55] [indexer:background] Health check [2023-10-24 03:11:56] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-24 03:13:22] [index:background] Health check [2023-10-24 03:13:22] [index:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-10-24 03:13:24] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-10-24 03:17:40] [indexer:background] Health check [2023-10-24 03:17:40] [indexer:background] CPU load threshold (3) breached: 4.33 [waiting 2] [2023-10-24 03:18:08] [index:background] Health check [2023-10-24 03:18:08] [index:background] CPU load threshold (3) breached: 4.03 [waiting 2] [2023-10-24 03:18:10] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-10-24 03:22:03] [indexer:background] Health check [2023-10-24 03:22:03] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2023-10-24 03:23:50] [index:background] Health check [2023-10-24 03:23:50] [index:background] CPU load threshold (3) breached: 4.05 [waiting 2] [2023-10-24 03:23:52] [indexer:background] CPU load threshold (3) breached: 4.05 [waiting 2] [2023-10-24 03:26:57] [indexer:background] Health check [2023-10-24 03:26:57] [indexer:background] CPU load threshold (3) breached: 5.24 [waiting 2] [2023-10-24 03:29:05] [index:background] Health check [2023-10-24 03:32:33] [indexer:background] Health check [2023-10-24 03:32:33] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2] [2023-10-24 03:33:16] [index:background] Health check [2023-10-24 03:33:16] [index:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-10-24 03:33:18] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-10-24 03:37:35] [indexer:background] Health check [2023-10-24 03:37:35] [indexer:background] CPU load threshold (3) breached: 3.77 [waiting 2] [2023-10-24 03:38:55] [index:background] Health check [2023-10-24 03:38:55] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2] [2023-10-24 03:38:57] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-10-24 03:42:03] [indexer:background] Health check [2023-10-24 03:42:03] [indexer:background] CPU load threshold (3) breached: 3.94 [waiting 2] [2023-10-24 03:43:22] [index:background] Health check [2023-10-24 03:43:22] [index:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-10-24 03:43:24] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-10-24 03:46:56] [indexer:background] Health check [2023-10-24 03:48:12] [index:background] Health check [2023-10-24 03:52:04] [indexer:background] Health check [2023-10-24 03:53:23] [index:background] Health check [2023-10-24 03:57:38] [indexer:background] Health check [2023-10-24 03:58:07] [index:background] Health check [2023-10-24 04:03:14] [indexer:background] Health check [2023-10-24 04:03:14] [index:background] Health check [2023-10-24 04:06:57] [indexer:background] Health check [2023-10-24 04:08:05] [index:background] Health check [2023-10-24 04:11:58] [indexer:background] Health check [2023-10-24 04:13:14] [index:background] Health check [2023-10-24 04:17:07] [indexer:background] Health check [2023-10-24 04:18:30] [index:background] Health check [2023-10-24 04:22:20] [indexer:background] Health check [2023-10-24 04:23:10] [index:background] Health check [2023-10-24 04:26:58] [indexer:background] Health check [2023-10-24 04:28:10] [index:background] Health check [2023-10-24 04:31:53] [indexer:background] Health check [2023-10-24 04:33:33] [index:background] Health check [2023-10-24 04:37:20] [indexer:background] Health check [2023-10-24 04:39:46] [index:background] Health check [2023-10-24 04:39:46] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-24 04:39:48] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-24 04:42:11] [indexer:background] Health check [2023-10-24 04:42:11] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2] [2023-10-24 04:43:55] [index:background] Health check [2023-10-24 04:43:55] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-24 04:43:57] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-24 04:46:56] [indexer:background] Health check [2023-10-24 04:46:56] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-24 04:48:05] [index:background] Health check [2023-10-24 04:48:05] [index:background] CPU load threshold (3) breached: 3.66 [waiting 2] [2023-10-24 04:48:07] [indexer:background] CPU load threshold (3) breached: 3.66 [waiting 2] [2023-10-24 04:53:01] [indexer:background] Health check [2023-10-24 04:53:01] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2] [2023-10-24 04:54:53] [index:background] Health check [2023-10-24 04:58:02] [indexer:background] Health check [2023-10-24 04:58:02] [index:background] Health check [2023-10-24 05:02:32] [indexer:background] Health check [2023-10-24 05:04:23] [index:background] Health check [2023-10-24 05:07:00] [indexer:background] Health check [2023-10-24 05:10:27] [index:background] Health check [2023-10-24 05:12:45] [indexer:background] Health check [2023-10-24 05:13:20] [index:background] Health check [2023-10-24 05:16:54] [indexer:background] Health check [2023-10-24 05:18:09] [index:background] Health check [2023-10-24 05:22:02] [indexer:background] Health check [2023-10-24 05:23:18] [index:background] Health check [2023-10-24 05:27:53] [indexer:background] Health check [2023-10-24 05:29:31] [index:background] Health check [2023-10-24 05:31:55] [indexer:background] Health check [2023-10-24 05:33:05] [index:background] Health check [2023-10-24 05:37:20] [indexer:background] Health check [2023-10-24 05:38:48] [index:background] Health check [2023-10-24 05:42:41] [indexer:background] Health check [2023-10-24 05:44:14] [index:background] Health check [2023-10-24 05:48:01] [indexer:background] Health check [2023-10-24 05:48:09] [index:background] Health check [2023-10-24 05:53:11] [indexer:background] Health check [2023-10-24 05:53:11] [index:background] Health check [2023-10-24 05:57:05] [indexer:background] Health check [2023-10-24 05:58:29] [index:background] Health check [2023-10-24 06:02:16] [indexer:background] Health check [2023-10-24 06:03:20] [index:background] Health check [2023-10-24 06:07:13] [indexer:background] Health check [2023-10-24 06:08:11] [index:background] Health check [2023-10-24 06:12:30] [indexer:background] Health check [2023-10-24 06:13:25] [index:background] Health check [2023-10-24 06:17:26] [indexer:background] Health check [2023-10-24 06:18:09] [index:background] Health check [2023-10-24 06:22:20] [indexer:background] Health check [2023-10-24 06:23:42] [index:background] Health check [2023-10-24 06:27:34] [indexer:background] Health check [2023-10-24 06:28:04] [index:background] Health check [2023-10-24 06:32:12] [indexer:background] Health check [2023-10-24 06:33:02] [index:background] Health check [2023-10-24 06:37:03] [indexer:background] Health check [2023-10-24 06:38:31] [index:background] Health check [2023-10-24 06:42:28] [indexer:background] Health check [2023-10-24 06:44:07] [index:background] Health check [2023-10-24 06:46:55] [indexer:background] Health check [2023-10-24 06:48:35] [index:background] Health check [2023-10-24 06:52:20] [indexer:background] Health check [2023-10-24 06:54:36] [index:background] Health check [2023-10-24 06:56:53] [indexer:background] Health check [2023-10-24 06:58:20] [index:background] Health check [2023-10-24 07:01:53] [indexer:background] Health check [2023-10-24 07:03:37] [index:background] Health check [2023-10-24 07:07:20] [indexer:background] Health check [2023-10-24 07:10:37] [index:background] Health check [2023-10-24 07:12:21] [indexer:background] Health check [2023-10-24 07:13:49] [index:background] Health check [2023-10-24 07:14:37] [query] Query for: 2023 [2023-10-24 07:14:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-24 07:14:37] [query] Engine: default [2023-10-24 07:14:38] [query] Tokens: 2023 [2023-10-24 07:14:38] [query] Mods: 6 [2023-10-24 07:14:39] [query] Found results using: or logic [2023-10-24 07:14: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, 10 [2023-10-24 07:14:39] [query] Results: 249 Pages of results: 25 [2023-10-24 07:14:39] [query] Execution time: 1.54640 [2023-10-24 07:17:23] [indexer:background] Health check [2023-10-24 07:20:12] [index:background] Health check [2023-10-24 07:22:21] [indexer:background] Health check [2023-10-24 07:23:24] [index:background] Health check [2023-10-24 07:23:24] [index:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-24 07:23:27] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-10-24 07:28:36] [indexer:background] Health check [2023-10-24 07:28:36] [index:background] Health check [2023-10-24 07:32:37] [indexer:background] Health check [2023-10-24 07:34:26] [index:background] Health check [2023-10-24 07:37:21] [indexer:background] Health check [2023-10-24 07:37:21] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-10-24 07:39:47] [index:background] Health check [2023-10-24 07:42:01] [indexer:background] Health check [2023-10-24 07:42:01] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2] [2023-10-24 07:43:58] [index:background] Health check [2023-10-24 07:47:31] [indexer:background] Health check [2023-10-24 07:48:25] [index:background] Health check [2023-10-24 07:52:03] [indexer:background] Health check [2023-10-24 07:53:20] [index:background] Health check [2023-10-24 07:58:11] [indexer:background] Health check [2023-10-24 07:58:11] [index:background] Health check [2023-10-24 08:02:37] [indexer:background] Health check [2023-10-24 08:03:34] [index:background] Health check [2023-10-24 08:07:17] [indexer:background] Health check [2023-10-24 08:08:08] [index:background] Health check [2023-10-24 08:12:04] [indexer:background] Health check [2023-10-24 08:12:04] [indexer:background] CPU load threshold (3) breached: 4.08 [waiting 2] [2023-10-24 08:13:28] [index:background] Health check [2023-10-24 08:17:15] [indexer:background] Health check [2023-10-24 08:18:25] [index:background] Health check [2023-10-24 08:22:52] [indexer:background] Health check [2023-10-24 08:22:52] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-10-24 08:23:04] [index:background] Health check [2023-10-24 08:23:04] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-24 08:23:06] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2] [2023-10-24 08:27:06] [indexer:background] Health check [2023-10-24 08:28:05] [index:background] Health check [2023-10-24 08:28:05] [index:background] CPU load threshold (3) breached: 3.97 [waiting 2] [2023-10-24 08:28:07] [indexer:background] CPU load threshold (3) breached: 3.97 [waiting 2] [2023-10-24 08:32:08] [indexer:background] Health check [2023-10-24 08:33:04] [index:background] Health check [2023-10-24 08:37:25] [indexer:background] Health check [2023-10-24 08:37:25] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2] [2023-10-24 08:39:05] [index:background] Health check [2023-10-24 08:42:04] [indexer:background] Health check [2023-10-24 08:43:17] [index:background] Health check [2023-10-24 08:43:17] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-24 08:43:19] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-24 08:46:58] [indexer:background] Health check [2023-10-24 08:46:58] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-24 08:48:20] [index:background] Health check [2023-10-24 08:48:20] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-10-24 08:48:22] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-24 08:52:28] [indexer:background] Health check [2023-10-24 08:52:28] [indexer:background] CPU load threshold (3) breached: 4.14 [waiting 2] [2023-10-24 08:53:44] [index:background] Health check [2023-10-24 08:53:44] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2023-10-24 08:53:46] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2023-10-24 09:00:40] [indexer:background] Health check [2023-10-24 09:00:40] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-24 09:00:42] [index:background] Health check [2023-10-24 09:02:25] [indexer:background] Health check [2023-10-24 09:02:25] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2023-10-24 09:03:47] [index:background] Health check [2023-10-24 09:03:47] [index:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-10-24 09:03:49] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-10-24 09:07:32] [indexer:background] Health check [2023-10-24 09:07:32] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2] [2023-10-24 09:08:56] [index:background] Health check [2023-10-24 09:12:25] [indexer:background] Health check [2023-10-24 09:12:25] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-10-24 09:14:53] [index:background] Health check [2023-10-24 09:17:43] [indexer:background] Health check [2023-10-24 09:17:43] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 09:18:02] [index:background] Health check [2023-10-24 09:18:02] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-24 09:18:04] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-24 09:22:36] [indexer:background] Health check [2023-10-24 09:22:36] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-10-24 09:23:32] [index:background] Health check [2023-10-24 09:27:06] [indexer:background] Health check [2023-10-24 09:30:23] [index:background] Health check [2023-10-24 09:30:23] [index:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-24 09:30:25] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-24 09:34:25] [indexer:background] Health check [2023-10-24 09:34:25] [index:background] Health check [2023-10-24 09:36:57] [indexer:background] Health check [2023-10-24 09:36:57] [indexer:background] CPU load threshold (3) breached: 5.06 [waiting 2] [2023-10-24 09:38:20] [index:background] Health check [2023-10-24 09:38:20] [index:background] CPU load threshold (3) breached: 4.13 [waiting 2] [2023-10-24 09:38:22] [indexer:background] CPU load threshold (3) breached: 4.13 [waiting 2] [2023-10-24 09:43:04] [indexer:background] Health check [2023-10-24 09:43:04] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2023-10-24 09:43:06] [index:background] Health check [2023-10-24 09:43:06] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2023-10-24 09:43:08] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2023-10-24 09:47:16] [indexer:background] Health check [2023-10-24 09:47:16] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-24 09:48:13] [index:background] Health check [2023-10-24 09:48:13] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-10-24 09:48:15] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-10-24 09:52:17] [indexer:background] Health check [2023-10-24 09:52:17] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-10-24 09:53:19] [index:background] Health check [2023-10-24 09:57:51] [indexer:background] Health check [2023-10-24 09:58:06] [index:background] Health check [2023-10-24 10:02:43] [indexer:background] Health check [2023-10-24 10:03:03] [index:background] Health check [2023-10-24 10:07:39] [indexer:background] Health check [2023-10-24 10:07:39] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-24 10:08:03] [index:background] Health check [2023-10-24 10:11:52] [indexer:background] Health check [2023-10-24 10:13:27] [index:background] Health check [2023-10-24 10:17:15] [indexer:background] Health check [2023-10-24 10:17:15] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-10-24 10:18:08] [index:background] Health check [2023-10-24 10:22:34] [indexer:background] Health check [2023-10-24 10:24:20] [index:background] Health check [2023-10-24 10:28:01] [indexer:background] Health check [2023-10-24 10:28:05] [index:background] Health check [2023-10-24 10:32:04] [indexer:background] Health check [2023-10-24 10:32:04] [indexer:background] CPU load threshold (3) breached: 10.31 [waiting 2] [2023-10-24 10:33:57] [index:background] Health check [2023-10-24 10:33:57] [index:background] CPU load threshold (3) breached: 3.29 [waiting 2] [2023-10-24 10:33:59] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2] [2023-10-24 10:37:00] [indexer:background] Health check [2023-10-24 10:37:00] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-10-24 10:38:49] [index:background] Health check [2023-10-24 10:38:49] [index:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-10-24 10:38:51] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-10-24 10:42:31] [indexer:background] Health check [2023-10-24 10:44:30] [index:background] Health check [2023-10-24 10:47:12] [indexer:background] Health check [2023-10-24 10:47:41] [query] Query for: {search_term_string} [2023-10-24 10:47:41] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-24 10:47:41] [query] Engine: default [2023-10-24 10:47:41] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-24 10:47:41] [query] Mods: 6 [2023-10-24 10:47:41] [query] Using OR logic [2023-10-24 10:47:43] [query] Found results using: or logic [2023-10-24 10:47:43] [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 [2023-10-24 10:47:43] [query] Results: 1344 Pages of results: 135 [2023-10-24 10:47:43] [query] Execution time: 1.75221 [2023-10-24 10:48:56] [index:background] Health check [2023-10-24 10:52:00] [indexer:background] Health check [2023-10-24 10:53:03] [index:background] Health check [2023-10-24 10:57:00] [indexer:background] Health check [2023-10-24 10:58:18] [index:background] Health check [2023-10-24 11:04:57] [indexer:background] Health check [2023-10-24 11:04:57] [index:background] Health check [2023-10-24 11:06:52] [indexer:background] Health check [2023-10-24 11:06:52] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2] [2023-10-24 11:09:17] [index:background] Health check [2023-10-24 11:09:17] [index:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-24 11:09:19] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-24 11:12:22] [indexer:background] Health check [2023-10-24 11:14:27] [index:background] Health check [2023-10-24 11:14:27] [index:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2023-10-24 11:14:29] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2] [2023-10-24 11:17:10] [indexer:background] Health check [2023-10-24 11:18:04] [index:background] Health check [2023-10-24 11:22:07] [indexer:background] Health check [2023-10-24 11:23:56] [index:background] Health check [2023-10-24 11:26:53] [indexer:background] Health check [2023-10-24 11:28:15] [index:background] Health check [2023-10-24 11:31:23] [query] Query for: {search_term_string} [2023-10-24 11:31:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-24 11:31:23] [query] Engine: default [2023-10-24 11:31:23] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-24 11:31:23] [query] Mods: 6 [2023-10-24 11:31:23] [query] Using OR logic [2023-10-24 11:31:23] [query] Found results using: or logic [2023-10-24 11:31:23] [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 [2023-10-24 11:31:23] [query] Results: 1344 Pages of results: 135 [2023-10-24 11:31:23] [query] Execution time: 0.04206 [2023-10-24 11:32:02] [indexer:background] Health check [2023-10-24 11:33:02] [index:background] Health check [2023-10-24 11:33:02] [index:background] CPU load threshold (3) breached: 3.43 [waiting 2] [2023-10-24 11:33:04] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2023-10-24 11:36:53] [indexer:background] Health check [2023-10-24 11:36:53] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-10-24 11:38:20] [index:background] Health check [2023-10-24 11:38:20] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 11:38:22] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 11:39:55] [index] Marking post.attachment 13841 to be dropped [2023-10-24 11:39:58] [index] Dropping post.attachment 13841 [2023-10-24 11:39:58] [index:background] CPU load threshold (3) breached: 3.47 [waiting 2] [2023-10-24 11:40:00] [indexer] Queued next batch (1) [2023-10-24 11:40:00] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-24 11:40:03] [indexer] Processing batch (1) [2023-10-24 11:40:03] [indexer] Indexing post.attachment:13841 [2023-10-24 11:40:03] [index] Marking [1] post.attachment 13841 as indexed [2023-10-24 11:40:03] [indexer] Index built [2023-10-24 11:40:03] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-24 11:42:10] [indexer:background] Health check [2023-10-24 11:43:30] [index:background] Health check [2023-10-24 11:47:28] [indexer:background] Health check [2023-10-24 11:48:29] [index:background] Health check [2023-10-24 11:51:52] [indexer:background] Health check [2023-10-24 11:51:53] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2] [2023-10-24 11:53:23] [index:background] Health check [2023-10-24 11:53:23] [index:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2023-10-24 11:53:25] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-10-24 11:57:01] [indexer:background] Health check [2023-10-24 11:57:01] [indexer:background] CPU load threshold (3) breached: 3.66 [waiting 2] [2023-10-24 11:58:18] [index:background] Health check [2023-10-24 11:58:18] [index:background] CPU load threshold (3) breached: 4.14 [waiting 2] [2023-10-24 11:58:20] [indexer:background] CPU load threshold (3) breached: 4.05 [waiting 2] [2023-10-24 12:01:55] [indexer:background] Health check [2023-10-24 12:01:55] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-10-24 12:03:55] [index:background] Health check [2023-10-24 12:07:22] [indexer:background] Health check [2023-10-24 12:07:22] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2023-10-24 12:08:07] [index:background] Health check [2023-10-24 12:12:50] [indexer:background] Health check [2023-10-24 12:14:06] [index:background] Health check [2023-10-24 12:14:06] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2] [2023-10-24 12:14:08] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2] [2023-10-24 12:16:51] [indexer:background] Health check [2023-10-24 12:16:51] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2] [2023-10-24 12:18:02] [index:background] Health check [2023-10-24 12:18:02] [indexer] Queued next batch (1) [2023-10-24 12:18:03] [index] Marking post.attachment 13842 to be dropped [2023-10-24 12:18:05] [indexer] Processing batch (1) [2023-10-24 12:18:05] [indexer] Indexing post.attachment:13842 [2023-10-24 12:18:05] [index] Marking [1] post.attachment 13842 as indexed [2023-10-24 12:18:06] [indexer] Index built [2023-10-24 12:18:06] [index] Dropping post.attachment 13842 [2023-10-24 12:18:06] [indexer] Queued next batch (1) [2023-10-24 12:18:07] [indexer] Processing batch (1) [2023-10-24 12:18:07] [indexer] Indexing post.attachment:13842 [2023-10-24 12:18:07] [index] Marking [1] post.attachment 13842 as indexed [2023-10-24 12:18:07] [indexer] Index built [2023-10-24 12:21:59] [indexer:background] Health check [2023-10-24 12:23:11] [index:background] Health check [2023-10-24 12:27:58] [indexer:background] Health check [2023-10-24 12:29:36] [index:background] Health check [2023-10-24 12:31:53] [indexer:background] Health check [2023-10-24 12:33:43] [index:background] Health check [2023-10-24 12:37:39] [indexer:background] Health check [2023-10-24 12:37:39] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2] [2023-10-24 12:39:09] [index:background] Health check [2023-10-24 12:42:22] [indexer:background] Health check [2023-10-24 12:43:12] [index:background] Health check [2023-10-24 12:48:36] [indexer:background] Health check [2023-10-24 12:48:36] [index:background] Health check [2023-10-24 12:51:51] [indexer:background] Health check [2023-10-24 12:53:11] [index:background] Health check [2023-10-24 12:56:53] [indexer:background] Health check [2023-10-24 12:56:53] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2] [2023-10-24 12:58:51] [index:background] Health check [2023-10-24 13:02:13] [indexer:background] Health check [2023-10-24 13:02:13] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-10-24 13:04:18] [index:background] Health check [2023-10-24 13:06:53] [indexer:background] Health check [2023-10-24 13:06:53] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2] [2023-10-24 13:09:13] [index:background] Health check [2023-10-24 13:09:13] [index:background] CPU load threshold (3) breached: 3.29 [waiting 2] [2023-10-24 13:09:15] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2] [2023-10-24 13:11:56] [indexer:background] Health check [2023-10-24 13:13:18] [index:background] Health check [2023-10-24 13:16:56] [indexer:background] Health check [2023-10-24 13:18:38] [index:background] Health check [2023-10-24 13:22:02] [indexer:background] Health check [2023-10-24 13:23:15] [index:background] Health check [2023-10-24 13:23:15] [index:background] CPU load threshold (3) breached: 3.41 [waiting 2] [2023-10-24 13:23:17] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2] [2023-10-24 13:26:56] [indexer:background] Health check [2023-10-24 13:28:06] [index:background] Health check [2023-10-24 13:31:55] [indexer:background] Health check [2023-10-24 13:33:40] [index:background] Health check [2023-10-24 13:36:52] [indexer:background] Health check [2023-10-24 13:39:05] [index:background] Health check [2023-10-24 13:43:14] [indexer:background] Health check [2023-10-24 13:43:14] [index:background] Health check [2023-10-24 13:48:14] [indexer:background] Health check [2023-10-24 13:48:14] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-10-24 13:48:16] [index:background] Health check [2023-10-24 13:48:16] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 13:48:18] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 13:52:57] [indexer:background] Health check [2023-10-24 13:53:08] [index:background] Health check [2023-10-24 13:57:52] [indexer:background] Health check [2023-10-24 13:58:08] [index:background] Health check [2023-10-24 14:02:18] [indexer:background] Health check [2023-10-24 14:03:23] [index:background] Health check [2023-10-24 14:07:43] [indexer:background] Health check [2023-10-24 14:11:06] [index:background] Health check [2023-10-24 14:12:59] [indexer:background] Health check [2023-10-24 14:13:50] [index:background] Health check [2023-10-24 14:18:32] [indexer:background] Health check [2023-10-24 14:18:32] [index:background] Health check [2023-10-24 14:21:55] [indexer:background] Health check [2023-10-24 14:21:55] [indexer:background] CPU load threshold (3) breached: 3.79 [waiting 2] [2023-10-24 14:23:12] [index:background] Health check [2023-10-24 14:23:12] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 14:23:14] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-24 14:27:52] [indexer:background] Health check [2023-10-24 14:27:52] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2] [2023-10-24 14:28:18] [index:background] Health check [2023-10-24 14:28:18] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-24 14:28:20] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-24 14:32:45] [indexer:background] Health check [2023-10-24 14:32:45] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-24 14:33:04] [index:background] Health check [2023-10-24 14:33:04] [index:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-10-24 14:33:06] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-10-24 14:36:57] [indexer:background] Health check [2023-10-24 14:38:30] [index:background] Health check [2023-10-24 14:41:55] [indexer:background] Health check [2023-10-24 14:43:08] [index:background] Health check [2023-10-24 14:47:06] [indexer:background] Health check [2023-10-24 14:48:27] [index:background] Health check [2023-10-24 14:52:25] [indexer:background] Health check [2023-10-24 14:53:15] [index:background] Health check [2023-10-24 14:53:15] [index:background] CPU load threshold (3) breached: 3.62 [waiting 2] [2023-10-24 14:53:17] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2] [2023-10-24 14:58:20] [indexer:background] Health check [2023-10-24 14:58:20] [index:background] Health check [2023-10-24 15:02:23] [indexer:background] Health check [2023-10-24 15:04:00] [index:background] Health check [2023-10-24 15:07:10] [indexer:background] Health check [2023-10-24 15:08:35] [index:background] Health check [2023-10-24 15:08:35] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-24 15:08:37] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-24 15:12:23] [indexer:background] Health check [2023-10-24 15:13:02] [index:background] Health check [2023-10-24 15:13:02] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-10-24 15:13:04] [indexer:background] CPU load threshold (3) breached: 3.47 [waiting 2] [2023-10-24 15:17:15] [indexer:background] Health check [2023-10-24 15:18:19] [index:background] Health check [2023-10-24 15:22:01] [indexer:background] Health check [2023-10-24 15:23:16] [index:background] Health check [2023-10-24 15:27:23] [indexer:background] Health check [2023-10-24 15:28:21] [index:background] Health check [2023-10-24 15:32:05] [indexer:background] Health check [2023-10-24 15:32:05] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2] [2023-10-24 15:34:46] [index:background] Health check [2023-10-24 15:37:11] [indexer:background] Health check [2023-10-24 15:38:17] [index:background] Health check [2023-10-24 15:42:28] [indexer:background] Health check [2023-10-24 15:43:12] [index:background] Health check [2023-10-24 15:47:49] [indexer:background] Health check [2023-10-24 15:48:05] [index:background] Health check [2023-10-24 15:52:00] [indexer:background] Health check [2023-10-24 15:53:27] [index:background] Health check [2023-10-24 15:56:57] [indexer:background] Health check [2023-10-24 15:58:33] [index:background] Health check [2023-10-24 16:02:59] [indexer:background] Health check [2023-10-24 16:03:46] [index:background] Health check [2023-10-24 16:07:49] [indexer:background] Health check [2023-10-24 16:08:15] [index:background] Health check [2023-10-24 16:12:23] [indexer:background] Health check [2023-10-24 16:12:23] [indexer:background] CPU load threshold (3) breached: 4.6 [waiting 2] [2023-10-24 16:13:14] [index:background] Health check [2023-10-24 16:16:54] [indexer:background] Health check [2023-10-24 16:18:06] [index:background] Health check [2023-10-24 16:21:56] [indexer:background] Health check [2023-10-24 16:23:07] [index:background] Health check [2023-10-24 16:27:09] [indexer:background] Health check [2023-10-24 16:28:08] [index:background] Health check [2023-10-24 16:32:06] [indexer:background] Health check [2023-10-24 16:33:19] [index:background] Health check [2023-10-24 16:37:48] [indexer:background] Health check [2023-10-24 16:38:08] [index:background] Health check [2023-10-24 16:42:01] [indexer:background] Health check [2023-10-24 16:43:08] [index:background] Health check [2023-10-24 16:46:58] [indexer:background] Health check [2023-10-24 16:48:38] [index:background] Health check [2023-10-24 16:52:52] [indexer:background] Health check [2023-10-24 16:54:21] [index:background] Health check [2023-10-24 16:56:56] [indexer:background] Health check [2023-10-24 16:58:02] [index:background] Health check [2023-10-24 17:02:04] [indexer:background] Health check [2023-10-24 17:03:27] [index:background] Health check [2023-10-24 17:07:15] [indexer:background] Health check [2023-10-24 17:08:06] [index:background] Health check [2023-10-24 17:11:53] [indexer:background] Health check [2023-10-24 17:13:11] [index:background] Health check [2023-10-24 17:17:28] [indexer:background] Health check [2023-10-24 17:18:41] [index:background] Health check [2023-10-24 17:22:41] [indexer:background] Health check [2023-10-24 17:23:07] [index:background] Health check [2023-10-24 17:27:03] [indexer:background] Health check [2023-10-24 17:28:11] [index:background] Health check [2023-10-24 17:32:21] [indexer:background] Health check [2023-10-24 17:33:12] [index:background] Health check [2023-10-24 17:37:11] [indexer:background] Health check [2023-10-24 17:39:12] [index:background] Health check [2023-10-24 17:42:31] [indexer:background] Health check [2023-10-24 17:43:16] [index:background] Health check [2023-10-24 17:49:08] [indexer:background] Health check [2023-10-24 17:49:08] [index:background] Health check [2023-10-24 17:52:10] [indexer:background] Health check [2023-10-24 17:53:04] [index:background] Health check [2023-10-24 17:53:50] [index] Marking post.page 13848 to be dropped [2023-10-24 17:53:52] [index] Dropping post.page 13848 [2023-10-24 17:53:52] [indexer] Index built [2023-10-24 17:57:04] [indexer:background] Health check [2023-10-24 17:57:04] [indexer] Queued next batch (1) [2023-10-24 17:57:06] [indexer] Processing batch (1) [2023-10-24 17:57:06] [indexer] Indexing post.attachment:13849 [2023-10-24 17:57:06] [index] Marking [1] post.attachment 13849 as indexed [2023-10-24 17:57:07] [indexer] Index built [2023-10-24 17:58:05] [index:background] Health check [2023-10-24 18:02:16] [indexer:background] Health check [2023-10-24 18:02:16] [indexer] Queued next batch (1) [2023-10-24 18:02:19] [indexer] Processing batch (1) [2023-10-24 18:02:19] [indexer] Indexing post.attachment:13851 [2023-10-24 18:02:19] [index] Marking [1] post.attachment 13851 as indexed [2023-10-24 18:02:19] [indexer] Index built [2023-10-24 18:03:14] [index:background] Health check [2023-10-24 18:06:51] [indexer:background] Health check [2023-10-24 18:08:16] [index:background] Health check [2023-10-24 18:11:55] [indexer:background] Health check [2023-10-24 18:13:16] [index:background] Health check [2023-10-24 18:16:11] [index] Marking post.page 13848 to be dropped [2023-10-24 18:16:14] [index] Dropping post.page 13848 [2023-10-24 18:16:14] [indexer] Index built [2023-10-24 18:16:15] [index] Marking post.page 13848 to be dropped [2023-10-24 18:16:18] [index] Dropping post.page 13848 [2023-10-24 18:16:18] [indexer] Index built [2023-10-24 18:16:56] [indexer:background] Health check [2023-10-24 18:18:47] [index:background] Health check [2023-10-24 18:20:36] [index] Marking post.page 13848 to be dropped [2023-10-24 18:20:39] [index] Dropping post.page 13848 [2023-10-24 18:20:39] [indexer] Queued next batch (1) [2023-10-24 18:20:41] [index] Marking post.page 13848 to be dropped [2023-10-24 18:20:42] [indexer] Processing batch (1) [2023-10-24 18:20:42] [indexer] Indexing post.page:13848 [2023-10-24 18:20:42] [index] Marking [1] post.page 13848 as indexed [2023-10-24 18:20:42] [indexer] Index built [2023-10-24 18:20:44] [index] Dropping post.page 13848 [2023-10-24 18:20:44] [indexer] Queued next batch (1) [2023-10-24 18:20:46] [indexer] Processing batch (1) [2023-10-24 18:20:46] [indexer] Indexing post.page:13848 [2023-10-24 18:20:46] [index] Marking [1] post.page 13848 as indexed [2023-10-24 18:20:46] [indexer] Index built [2023-10-24 18:22:06] [indexer:background] Health check [2023-10-24 18:23:10] [index:background] Health check [2023-10-24 18:28:14] [indexer:background] Health check [2023-10-24 18:28:14] [index:background] Health check [2023-10-24 18:32:40] [indexer:background] Health check [2023-10-24 18:33:05] [index:background] Health check [2023-10-24 18:38:17] [indexer:background] Health check [2023-10-24 18:38:17] [index:background] Health check [2023-10-24 18:41:57] [indexer:background] Health check [2023-10-24 18:43:41] [index:background] Health check [2023-10-24 18:47:42] [indexer:background] Health check [2023-10-24 18:48:56] [index:background] Health check [2023-10-24 18:53:11] [indexer:background] Health check [2023-10-24 18:53:12] [index:background] Health check [2023-10-24 18:56:57] [indexer:background] Health check [2023-10-24 18:58:49] [index:background] Health check [2023-10-24 19:02:39] [indexer:background] Health check [2023-10-24 19:04:20] [index:background] Health check [2023-10-24 19:06:51] [indexer:background] Health check [2023-10-24 19:08:13] [index:background] Health check [2023-10-24 19:11:58] [indexer:background] Health check [2023-10-24 19:13:43] [index:background] Health check [2023-10-24 19:17:46] [indexer:background] Health check [2023-10-24 19:18:08] [index:background] Health check [2023-10-24 19:22:20] [indexer:background] Health check [2023-10-24 19:23:31] [index:background] Health check [2023-10-24 19:28:41] [indexer:background] Health check [2023-10-24 19:28:41] [index:background] Health check [2023-10-24 19:33:24] [indexer:background] Health check [2023-10-24 19:33:24] [index:background] Health check [2023-10-24 19:39:36] [indexer:background] Health check [2023-10-24 19:39:36] [index:background] Health check [2023-10-24 19:43:30] [indexer:background] Health check [2023-10-24 19:43:30] [index:background] Health check [2023-10-24 19:48:27] [indexer:background] Health check [2023-10-24 19:48:27] [index:background] Health check [2023-10-24 19:52:50] [indexer:background] Health check [2023-10-24 19:56:01] [index:background] Health check [2023-10-24 19:57:33] [indexer:background] Health check [2023-10-24 19:59:14] [index:background] Health check [2023-10-24 20:01:52] [indexer:background] Health check [2023-10-24 20:03:55] [index:background] Health check [2023-10-24 20:08:05] [indexer:background] Health check [2023-10-24 20:08:05] [index:background] Health check [2023-10-24 20:11:53] [indexer:background] Health check [2023-10-24 20:13:17] [index:background] Health check [2023-10-24 20:18:07] [indexer:background] Health check [2023-10-24 20:18:07] [index:background] Health check [2023-10-24 20:23:07] [indexer:background] Health check [2023-10-24 20:23:07] [index:background] Health check [2023-10-24 20:26:57] [indexer:background] Health check [2023-10-24 20:28:26] [index:background] Health check [2023-10-24 20:32:06] [indexer:background] Health check [2023-10-24 20:33:22] [index:background] Health check [2023-10-24 20:38:06] [indexer:background] Health check [2023-10-24 20:38:06] [index:background] Health check [2023-10-24 20:41:08] [query] Query for: 2024 [2023-10-24 20:41:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-24 20:41:08] [query] Engine: default [2023-10-24 20:41:09] [query] Tokens: 2024 [2023-10-24 20:41:09] [query] Mods: 6 [2023-10-24 20:41:09] [query] Found results using: or logic [2023-10-24 20:41:09] [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 [2023-10-24 20:41:09] [query] Results: 129 Pages of results: 13 [2023-10-24 20:41:09] [query] Execution time: 0.94376 [2023-10-24 20:43:06] [indexer:background] Health check [2023-10-24 20:43:06] [index:background] Health check [2023-10-24 20:47:27] [indexer:background] Health check [2023-10-24 20:48:37] [index:background] Health check [2023-10-24 20:51:53] [indexer:background] Health check [2023-10-24 20:53:06] [index:background] Health check [2023-10-24 20:58:31] [indexer:background] Health check [2023-10-24 20:58:31] [index:background] Health check [2023-10-24 21:01:58] [indexer:background] Health check [2023-10-24 21:03:07] [index:background] Health check [2023-10-24 21:07:47] [indexer:background] Health check [2023-10-24 21:08:54] [index:background] Health check [2023-10-24 21:11:54] [indexer:background] Health check [2023-10-24 21:11:54] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2023-10-24 21:13:06] [index:background] Health check [2023-10-24 21:13:06] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-10-24 21:13:08] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-10-24 21:17:04] [indexer:background] Health check [2023-10-24 21:18:27] [index:background] Health check [2023-10-24 21:21:56] [indexer:background] Health check [2023-10-24 21:23:20] [index:background] Health check [2023-10-24 21:26:53] [indexer:background] Health check [2023-10-24 21:28:07] [index:background] Health check [2023-10-24 21:32:45] [indexer:background] Health check [2023-10-24 21:34:11] [index:background] Health check [2023-10-24 21:37:01] [indexer:background] Health check [2023-10-24 21:38:33] [index:background] Health check [2023-10-24 21:41:59] [indexer:background] Health check [2023-10-24 21:44:01] [index:background] Health check [2023-10-24 21:47:06] [indexer:background] Health check [2023-10-24 21:48:28] [index:background] Health check [2023-10-24 21:51:57] [indexer:background] Health check [2023-10-24 21:53:39] [index:background] Health check [2023-10-24 21:57:52] [indexer:background] Health check [2023-10-24 21:58:27] [index:background] Health check [2023-10-24 22:02:46] [indexer:background] Health check [2023-10-24 22:03:20] [index:background] Health check [2023-10-24 22:09:22] [indexer:background] Health check [2023-10-24 22:09:22] [index:background] Health check [2023-10-24 22:12:25] [indexer:background] Health check [2023-10-24 22:14:10] [index:background] Health check [2023-10-24 22:16:58] [indexer:background] Health check [2023-10-24 22:20:48] [index:background] Health check [2023-10-24 22:24:01] [indexer:background] Health check [2023-10-24 22:24:01] [index:background] Health check [2023-10-24 22:26:57] [indexer:background] Health check [2023-10-24 22:28:26] [index:background] Health check [2023-10-24 22:33:16] [indexer:background] Health check [2023-10-24 22:33:16] [index:background] Health check [2023-10-24 22:36:58] [indexer:background] Health check [2023-10-24 22:38:32] [index:background] Health check [2023-10-24 22:42:48] [indexer:background] Health check [2023-10-24 22:43:24] [index:background] Health check [2023-10-24 22:50:03] [indexer:background] Health check [2023-10-24 22:50:03] [index:background] Health check [2023-10-24 22:54:10] [indexer:background] Health check [2023-10-24 22:54:10] [index:background] Health check [2023-10-24 22:57:57] [indexer:background] Health check [2023-10-24 22:58:16] [index:background] Health check [2023-10-24 23:02:27] [indexer:background] Health check [2023-10-24 23:03:21] [index:background] Health check [2023-10-24 23:07:31] [indexer:background] Health check [2023-10-24 23:08:05] [index:background] Health check [2023-10-24 23:14:49] [indexer:background] Health check [2023-10-24 23:14:49] [index:background] Health check [2023-10-24 23:17:25] [indexer:background] Health check [2023-10-24 23:18:23] [index:background] Health check [2023-10-24 23:22:02] [indexer:background] Health check [2023-10-24 23:23:57] [index:background] Health check [2023-10-24 23:28:27] [indexer:background] Health check [2023-10-24 23:28:27] [index:background] Health check [2023-10-24 23:32:00] [indexer:background] Health check [2023-10-24 23:33:13] [index:background] Health check [2023-10-24 23:38:11] [indexer:background] Health check [2023-10-24 23:38:11] [index:background] Health check [2023-10-24 23:42:45] [indexer:background] Health check [2023-10-24 23:44:44] [index:background] Health check [2023-10-24 23:47:08] [indexer:background] Health check [2023-10-24 23:48:07] [index:background] Health check [2023-10-24 23:51:57] [indexer:background] Health check [2023-10-24 23:53:46] [index:background] Health check [2023-10-24 23:57:13] [indexer:background] Health check [2023-10-24 23:59:23] [index:background] Health check