[2024-03-17 00:04:27] [index:background] Health check [2024-03-17 00:04:27] [indexer:background] Health check [2024-03-17 00:04:27] [indexer:background] Health check [2024-03-17 00:07:02] [index:background] Health check [2024-03-17 00:07:21] [indexer:background] Health check [2024-03-17 00:14:04] [index:background] Health check [2024-03-17 00:14:04] [indexer:background] Health check [2024-03-17 00:14:04] [indexer:background] Health check [2024-03-17 00:17:55] [index:background] Health check [2024-03-17 00:17:55] [indexer:background] Health check [2024-03-17 00:17:55] [indexer:background] Health check [2024-03-17 00:22:03] [index:background] Health check [2024-03-17 00:26:25] [indexer:background] Health check [2024-03-17 00:27:02] [index:background] Health check [2024-03-17 00:27:14] [indexer:background] Health check [2024-03-17 00:32:46] [index:background] Health check [2024-03-17 00:32:46] [indexer:background] Health check [2024-03-17 00:32:46] [indexer:background] Health check [2024-03-17 00:38:25] [index:background] Health check [2024-03-17 00:38:25] [indexer:background] Health check [2024-03-17 00:38:25] [indexer:background] Health check [2024-03-17 00:42:44] [index:background] Health check [2024-03-17 00:42:44] [indexer:background] Health check [2024-03-17 00:42:44] [indexer:background] Health check [2024-03-17 00:47:22] [index:background] Health check [2024-03-17 00:47:22] [indexer:background] Health check [2024-03-17 00:47:22] [indexer:background] Health check [2024-03-17 00:52:24] [index:background] Health check [2024-03-17 00:52:24] [indexer:background] Health check [2024-03-17 00:52:24] [indexer:background] Health check [2024-03-17 00:58:43] [index:background] Health check [2024-03-17 00:58:43] [indexer:background] Health check [2024-03-17 00:58:43] [indexer:background] Health check [2024-03-17 01:03:00] [index:background] Health check [2024-03-17 01:03:00] [indexer:background] Health check [2024-03-17 01:03:00] [indexer:background] Health check [2024-03-17 01:07:03] [index:background] Health check [2024-03-17 01:07:47] [indexer:background] Health check [2024-03-17 01:12:20] [index:background] Health check [2024-03-17 01:12:20] [indexer:background] Health check [2024-03-17 01:12:20] [indexer:background] Health check [2024-03-17 01:17:23] [index:background] Health check [2024-03-17 01:17:23] [indexer:background] Health check [2024-03-17 01:17:23] [indexer:background] Health check [2024-03-17 01:22:04] [index:background] Health check [2024-03-17 01:22:19] [indexer:background] Health check [2024-03-17 01:27:08] [index:background] Health check [2024-03-17 01:28:12] [indexer:background] Health check [2024-03-17 01:32:25] [index:background] Health check [2024-03-17 01:32:25] [indexer:background] Health check [2024-03-17 01:32:25] [indexer:background] Health check [2024-03-17 01:37:43] [index:background] Health check [2024-03-17 01:37:43] [indexer:background] Health check [2024-03-17 01:37:43] [indexer:background] Health check [2024-03-17 01:42:14] [index:background] Health check [2024-03-17 01:42:14] [indexer:background] Health check [2024-03-17 01:42:14] [indexer:background] Health check [2024-03-17 01:47:30] [index:background] Health check [2024-03-17 01:47:30] [indexer:background] Health check [2024-03-17 01:47:30] [indexer:background] Health check [2024-03-17 01:53:35] [index:background] Health check [2024-03-17 01:53:35] [indexer:background] Health check [2024-03-17 01:53:35] [indexer:background] Health check [2024-03-17 01:57:15] [index:background] Health check [2024-03-17 01:57:15] [indexer:background] Health check [2024-03-17 01:57:15] [indexer:background] Health check [2024-03-17 02:02:03] [index:background] Health check [2024-03-17 02:03:11] [indexer:background] Health check [2024-03-17 02:07:31] [index:background] Health check [2024-03-17 02:07:31] [indexer:background] Health check [2024-03-17 02:07:31] [indexer:background] Health check [2024-03-17 02:13:16] [index:background] Health check [2024-03-17 02:13:16] [indexer:background] Health check [2024-03-17 02:13:16] [indexer:background] Health check [2024-03-17 02:18:32] [index:background] Health check [2024-03-17 02:18:32] [indexer:background] Health check [2024-03-17 02:18:32] [indexer:background] Health check [2024-03-17 02:22:18] [index:background] Health check [2024-03-17 02:22:18] [indexer:background] Health check [2024-03-17 02:22:18] [indexer:background] Health check [2024-03-17 02:27:32] [index:background] Health check [2024-03-17 02:27:32] [indexer:background] Health check [2024-03-17 02:27:32] [indexer:background] Health check [2024-03-17 02:32:22] [index:background] Health check [2024-03-17 02:32:22] [indexer:background] Health check [2024-03-17 02:32:22] [indexer:background] Health check [2024-03-17 02:38:18] [index:background] Health check [2024-03-17 02:38:18] [indexer:background] Health check [2024-03-17 02:38:18] [indexer:background] Health check [2024-03-17 02:42:03] [index:background] Health check [2024-03-17 02:42:38] [indexer:background] Health check [2024-03-17 02:47:18] [index:background] Health check [2024-03-17 02:47:18] [indexer:background] Health check [2024-03-17 02:47:19] [indexer:background] Health check [2024-03-17 02:53:33] [index:background] Health check [2024-03-17 02:53:33] [indexer:background] Health check [2024-03-17 02:53:33] [indexer:background] Health check [2024-03-17 02:57:56] [index:background] Health check [2024-03-17 02:57:56] [indexer:background] Health check [2024-03-17 02:57:56] [indexer:background] Health check [2024-03-17 03:02:16] [index:background] Health check [2024-03-17 03:02:16] [indexer:background] Health check [2024-03-17 03:02:16] [indexer:background] Health check [2024-03-17 03:07:34] [index:background] Health check [2024-03-17 03:07:34] [index:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2024-03-17 03:07:36] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2024-03-17 03:07:38] [indexer:background] Health check [2024-03-17 03:07:38] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2024-03-17 03:07:40] [indexer:background] Health check [2024-03-17 03:07:40] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2024-03-17 03:12:07] [index:background] Health check [2024-03-17 03:12:27] [indexer:background] Health check [2024-03-17 03:17:08] [index:background] Health check [2024-03-17 03:17:13] [indexer:background] Health check [2024-03-17 03:17:49] [query] Query for: {search_term_string} [2024-03-17 03:17:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-17 03:17:49] [query] Engine: default [2024-03-17 03:17:49] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-17 03:17:49] [query] Mods: 6 [2024-03-17 03:17:49] [query] Using OR logic [2024-03-17 03:17:50] [query] Found results using: or logic [2024-03-17 03:17:50] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-03-17 03:17:50] [query] Results: 1356 Pages of results: 136 [2024-03-17 03:17:50] [query] Execution time: 1.09269 [2024-03-17 03:21:06] [query] Query for: {search_term_string} [2024-03-17 03:21:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-17 03:21:06] [query] Engine: default [2024-03-17 03:21:06] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-17 03:21:06] [query] Mods: 6 [2024-03-17 03:21:06] [query] Using OR logic [2024-03-17 03:21:06] [query] Found results using: or logic [2024-03-17 03:21:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-03-17 03:21:06] [query] Results: 1356 Pages of results: 136 [2024-03-17 03:21:06] [query] Execution time: 0.09545 [2024-03-17 03:22:48] [index:background] Health check [2024-03-17 03:22:48] [indexer:background] Health check [2024-03-17 03:22:48] [indexer:background] Health check [2024-03-17 03:27:10] [index:background] Health check [2024-03-17 03:27:27] [indexer:background] Health check [2024-03-17 03:32:05] [index:background] Health check [2024-03-17 03:32:27] [indexer:background] Health check [2024-03-17 03:37:10] [index:background] Health check [2024-03-17 03:37:26] [indexer:background] Health check [2024-03-17 03:42:32] [index:background] Health check [2024-03-17 03:42:32] [indexer:background] Health check [2024-03-17 03:42:32] [indexer:background] Health check [2024-03-17 03:47:17] [index:background] Health check [2024-03-17 03:47:17] [indexer:background] Health check [2024-03-17 03:47:17] [indexer:background] Health check [2024-03-17 03:52:44] [index:background] Health check [2024-03-17 03:52:45] [indexer:background] Health check [2024-03-17 03:52:45] [indexer:background] Health check [2024-03-17 03:57:16] [index:background] Health check [2024-03-17 03:57:16] [indexer:background] Health check [2024-03-17 03:57:16] [indexer:background] Health check [2024-03-17 04:02:53] [index:background] Health check [2024-03-17 04:02:53] [indexer:background] Health check [2024-03-17 04:02:53] [indexer:background] Health check [2024-03-17 04:08:38] [index:background] Health check [2024-03-17 04:08:38] [indexer:background] Health check [2024-03-17 04:08:38] [indexer:background] Health check [2024-03-17 04:12:32] [index:background] Health check [2024-03-17 04:12:32] [indexer:background] Health check [2024-03-17 04:12:32] [indexer:background] Health check [2024-03-17 04:17:33] [index:background] Health check [2024-03-17 04:17:34] [indexer:background] Health check [2024-03-17 04:17:34] [indexer:background] Health check [2024-03-17 04:22:23] [index:background] Health check [2024-03-17 04:22:23] [indexer:background] Health check [2024-03-17 04:22:23] [indexer:background] Health check [2024-03-17 04:27:49] [index:background] Health check [2024-03-17 04:27:49] [indexer:background] Health check [2024-03-17 04:27:49] [indexer:background] Health check [2024-03-17 04:32:46] [index:background] Health check [2024-03-17 04:32:46] [indexer:background] Health check [2024-03-17 04:32:46] [indexer:background] Health check [2024-03-17 04:38:10] [index:background] Health check [2024-03-17 04:38:10] [indexer:background] Health check [2024-03-17 04:38:10] [indexer:background] Health check [2024-03-17 04:43:50] [index:background] Health check [2024-03-17 04:43:50] [indexer:background] Health check [2024-03-17 04:43:50] [indexer:background] Health check [2024-03-17 04:47:42] [index:background] Health check [2024-03-17 04:47:42] [indexer:background] Health check [2024-03-17 04:47:42] [indexer:background] Health check [2024-03-17 04:52:04] [index:background] Health check [2024-03-17 04:52:26] [indexer:background] Health check [2024-03-17 04:57:31] [index:background] Health check [2024-03-17 04:57:32] [indexer:background] Health check [2024-03-17 04:57:32] [indexer:background] Health check [2024-03-17 05:02:06] [index:background] Health check [2024-03-17 05:03:13] [indexer:background] Health check [2024-03-17 05:07:09] [index:background] Health check [2024-03-17 05:07:20] [indexer:background] Health check [2024-03-17 05:12:35] [index:background] Health check [2024-03-17 05:12:35] [indexer:background] Health check [2024-03-17 05:12:35] [indexer:background] Health check [2024-03-17 05:18:08] [index:background] Health check [2024-03-17 05:18:08] [indexer:background] Health check [2024-03-17 05:18:08] [indexer:background] Health check [2024-03-17 05:22:51] [index:background] Health check [2024-03-17 05:22:51] [indexer:background] Health check [2024-03-17 05:22:51] [indexer:background] Health check [2024-03-17 05:28:26] [index:background] Health check [2024-03-17 05:28:26] [indexer:background] Health check [2024-03-17 05:28:26] [indexer:background] Health check [2024-03-17 05:32:58] [index:background] Health check [2024-03-17 05:32:58] [indexer:background] Health check [2024-03-17 05:32:58] [indexer:background] Health check [2024-03-17 05:37:09] [index:background] Health check [2024-03-17 05:37:16] [indexer:background] Health check [2024-03-17 05:42:59] [index:background] Health check [2024-03-17 05:42:59] [indexer:background] Health check [2024-03-17 05:42:59] [indexer:background] Health check [2024-03-17 05:47:19] [index:background] Health check [2024-03-17 05:47:20] [indexer:background] Health check [2024-03-17 05:47:20] [indexer:background] Health check [2024-03-17 05:52:03] [index:background] Health check [2024-03-17 05:52:52] [indexer:background] Health check [2024-03-17 05:57:19] [index:background] Health check [2024-03-17 05:57:19] [indexer:background] Health check [2024-03-17 05:57:19] [indexer:background] Health check [2024-03-17 06:02:09] [index:background] Health check [2024-03-17 06:03:34] [indexer:background] Health check [2024-03-17 06:07:35] [index:background] Health check [2024-03-17 06:07:35] [indexer:background] Health check [2024-03-17 06:07:35] [indexer:background] Health check [2024-03-17 06:12:17] [index:background] Health check [2024-03-17 06:12:17] [indexer:background] Health check [2024-03-17 06:12:17] [indexer:background] Health check [2024-03-17 06:18:06] [index:background] Health check [2024-03-17 06:18:06] [indexer:background] Health check [2024-03-17 06:18:06] [indexer:background] Health check [2024-03-17 06:23:30] [index:background] Health check [2024-03-17 06:23:30] [indexer:background] Health check [2024-03-17 06:23:31] [indexer:background] Health check [2024-03-17 06:27:04] [index:background] Health check [2024-03-17 06:27:40] [indexer:background] Health check [2024-03-17 06:32:20] [index:background] Health check [2024-03-17 06:32:20] [indexer:background] Health check [2024-03-17 06:32:20] [indexer:background] Health check [2024-03-17 06:38:17] [index:background] Health check [2024-03-17 06:38:17] [indexer:background] Health check [2024-03-17 06:38:17] [indexer:background] Health check [2024-03-17 06:42:11] [index:background] Health check [2024-03-17 06:42:11] [indexer:background] Health check [2024-03-17 06:42:11] [indexer:background] Health check [2024-03-17 06:47:25] [index:background] Health check [2024-03-17 06:47:25] [indexer:background] Health check [2024-03-17 06:47:25] [indexer:background] Health check [2024-03-17 06:52:53] [index:background] Health check [2024-03-17 06:52:54] [indexer:background] Health check [2024-03-17 06:52:54] [indexer:background] Health check [2024-03-17 06:57:22] [index:background] Health check [2024-03-17 06:57:22] [indexer:background] Health check [2024-03-17 06:57:22] [indexer:background] Health check [2024-03-17 07:02:38] [index:background] Health check [2024-03-17 07:02:38] [indexer:background] Health check [2024-03-17 07:02:38] [indexer:background] Health check [2024-03-17 07:08:00] [index:background] Health check [2024-03-17 07:08:00] [indexer:background] Health check [2024-03-17 07:08:00] [indexer:background] Health check [2024-03-17 07:12:16] [index:background] Health check [2024-03-17 07:12:16] [indexer:background] Health check [2024-03-17 07:12:16] [indexer:background] Health check [2024-03-17 07:17:15] [index:background] Health check [2024-03-17 07:17:15] [indexer:background] Health check [2024-03-17 07:17:15] [indexer:background] Health check [2024-03-17 07:22:38] [index:background] Health check [2024-03-17 07:22:38] [indexer:background] Health check [2024-03-17 07:22:38] [indexer:background] Health check [2024-03-17 07:27:19] [index:background] Health check [2024-03-17 07:27:19] [indexer:background] Health check [2024-03-17 07:27:19] [indexer:background] Health check [2024-03-17 07:32:04] [index:background] Health check [2024-03-17 07:32:57] [indexer:background] Health check [2024-03-17 07:37:09] [index:background] Health check [2024-03-17 07:37:16] [indexer:background] Health check [2024-03-17 07:43:03] [index:background] Health check [2024-03-17 07:43:03] [indexer:background] Health check [2024-03-17 07:43:03] [indexer:background] Health check [2024-03-17 07:47:22] [index:background] Health check [2024-03-17 07:47:22] [indexer:background] Health check [2024-03-17 07:47:22] [indexer:background] Health check [2024-03-17 07:52:07] [index:background] Health check [2024-03-17 07:52:25] [indexer:background] Health check [2024-03-17 07:57:12] [index:background] Health check [2024-03-17 07:57:12] [indexer:background] Health check [2024-03-17 07:57:12] [indexer:background] Health check [2024-03-17 08:02:22] [index:background] Health check [2024-03-17 08:02:22] [indexer:background] Health check [2024-03-17 08:02:22] [indexer:background] Health check [2024-03-17 08:07:43] [index:background] Health check [2024-03-17 08:07:43] [indexer:background] Health check [2024-03-17 08:07:43] [indexer:background] Health check [2024-03-17 08:12:15] [index:background] Health check [2024-03-17 08:12:15] [indexer:background] Health check [2024-03-17 08:12:15] [indexer:background] Health check [2024-03-17 08:17:49] [index:background] Health check [2024-03-17 08:17:49] [indexer:background] Health check [2024-03-17 08:17:49] [indexer:background] Health check [2024-03-17 08:22:40] [index:background] Health check [2024-03-17 08:22:40] [indexer:background] Health check [2024-03-17 08:22:40] [indexer:background] Health check [2024-03-17 08:27:11] [index:background] Health check [2024-03-17 08:27:11] [indexer:background] Health check [2024-03-17 08:27:11] [indexer:background] Health check [2024-03-17 08:33:25] [index:background] Health check [2024-03-17 08:33:25] [indexer:background] Health check [2024-03-17 08:33:25] [indexer:background] Health check [2024-03-17 08:37:26] [index:background] Health check [2024-03-17 08:37:26] [indexer:background] Health check [2024-03-17 08:37:26] [indexer:background] Health check [2024-03-17 08:42:21] [index:background] Health check [2024-03-17 08:42:21] [indexer:background] Health check [2024-03-17 08:42:21] [indexer:background] Health check [2024-03-17 08:48:05] [index:background] Health check [2024-03-17 08:48:05] [indexer:background] Health check [2024-03-17 08:48:05] [indexer:background] Health check [2024-03-17 08:53:42] [index:background] Health check [2024-03-17 08:53:42] [indexer:background] Health check [2024-03-17 08:53:42] [indexer:background] Health check [2024-03-17 09:01:32] [index:background] Health check [2024-03-17 09:01:32] [indexer:background] Health check [2024-03-17 09:01:33] [indexer:background] Health check [2024-03-17 09:02:08] [index:background] Health check [2024-03-17 09:02:20] [indexer:background] Health check [2024-03-17 09:08:10] [index:background] Health check [2024-03-17 09:08:10] [indexer:background] Health check [2024-03-17 09:08:10] [indexer:background] Health check [2024-03-17 09:12:30] [index:background] Health check [2024-03-17 09:12:30] [indexer:background] Health check [2024-03-17 09:12:30] [indexer:background] Health check [2024-03-17 09:17:10] [index:background] Health check [2024-03-17 09:17:13] [indexer:background] Health check [2024-03-17 09:22:13] [index:background] Health check [2024-03-17 09:22:13] [indexer:background] Health check [2024-03-17 09:22:13] [indexer:background] Health check [2024-03-17 09:27:28] [index:background] Health check [2024-03-17 09:27:28] [indexer:background] Health check [2024-03-17 09:27:28] [indexer:background] Health check [2024-03-17 09:32:39] [index:background] Health check [2024-03-17 09:32:39] [indexer:background] Health check [2024-03-17 09:32:39] [indexer:background] Health check [2024-03-17 09:37:34] [index:background] Health check [2024-03-17 09:37:34] [indexer:background] Health check [2024-03-17 09:37:34] [indexer:background] Health check [2024-03-17 09:43:55] [index:background] Health check [2024-03-17 09:43:55] [indexer:background] Health check [2024-03-17 09:43:55] [indexer:background] Health check [2024-03-17 09:47:41] [index:background] Health check [2024-03-17 09:47:41] [indexer:background] Health check [2024-03-17 09:47:41] [indexer:background] Health check [2024-03-17 09:52:49] [index:background] Health check [2024-03-17 09:52:49] [indexer:background] Health check [2024-03-17 09:52:49] [indexer:background] Health check [2024-03-17 09:58:11] [index:background] Health check [2024-03-17 09:58:11] [indexer:background] Health check [2024-03-17 09:58:11] [indexer:background] Health check [2024-03-17 10:02:10] [index:background] Health check [2024-03-17 10:03:00] [indexer:background] Health check [2024-03-17 10:07:31] [index:background] Health check [2024-03-17 10:07:31] [indexer:background] Health check [2024-03-17 10:07:31] [indexer:background] Health check [2024-03-17 10:12:27] [index:background] Health check [2024-03-17 10:12:27] [indexer:background] Health check [2024-03-17 10:12:27] [indexer:background] Health check [2024-03-17 10:17:42] [index:background] Health check [2024-03-17 10:17:42] [indexer:background] Health check [2024-03-17 10:17:42] [indexer:background] Health check [2024-03-17 10:22:04] [index:background] Health check [2024-03-17 10:22:52] [indexer:background] Health check [2024-03-17 10:27:24] [index:background] Health check [2024-03-17 10:27:25] [indexer:background] Health check [2024-03-17 10:27:25] [indexer:background] Health check [2024-03-17 10:32:07] [index:background] Health check [2024-03-17 10:33:15] [indexer:background] Health check [2024-03-17 10:37:28] [index:background] Health check [2024-03-17 10:37:28] [indexer:background] Health check [2024-03-17 10:37:28] [indexer:background] Health check [2024-03-17 10:43:18] [index:background] Health check [2024-03-17 10:43:18] [indexer:background] Health check [2024-03-17 10:43:18] [indexer:background] Health check [2024-03-17 10:47:30] [index:background] Health check [2024-03-17 10:47:30] [indexer:background] Health check [2024-03-17 10:47:30] [indexer:background] Health check [2024-03-17 10:52:09] [index:background] Health check [2024-03-17 10:52:37] [indexer:background] Health check [2024-03-17 10:57:14] [index:background] Health check [2024-03-17 10:57:14] [indexer:background] Health check [2024-03-17 10:57:14] [indexer:background] Health check [2024-03-17 11:03:04] [index:background] Health check [2024-03-17 11:03:04] [indexer:background] Health check [2024-03-17 11:03:04] [indexer:background] Health check [2024-03-17 11:07:22] [index:background] Health check [2024-03-17 11:07:22] [indexer:background] Health check [2024-03-17 11:07:22] [indexer:background] Health check [2024-03-17 11:12:05] [index:background] Health check [2024-03-17 11:12:30] [indexer:background] Health check [2024-03-17 11:18:30] [index:background] Health check [2024-03-17 11:18:30] [indexer:background] Health check [2024-03-17 11:18:30] [indexer:background] Health check [2024-03-17 11:23:09] [index:background] Health check [2024-03-17 11:23:09] [indexer:background] Health check [2024-03-17 11:23:09] [indexer:background] Health check [2024-03-17 11:29:29] [index:background] Health check [2024-03-17 11:29:29] [indexer:background] Health check [2024-03-17 11:29:30] [indexer:background] Health check [2024-03-17 11:32:02] [index:background] Health check [2024-03-17 11:32:12] [indexer:background] Health check [2024-03-17 11:37:17] [index:background] Health check [2024-03-17 11:37:17] [indexer:background] Health check [2024-03-17 11:37:17] [indexer:background] Health check [2024-03-17 11:42:05] [index:background] Health check [2024-03-17 11:42:20] [indexer:background] Health check [2024-03-17 11:47:59] [index:background] Health check [2024-03-17 11:47:59] [indexer:background] Health check [2024-03-17 11:47:59] [indexer:background] Health check [2024-03-17 11:53:49] [index:background] Health check [2024-03-17 11:53:49] [index:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2024-03-17 11:53:51] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2024-03-17 11:53:53] [indexer:background] Health check [2024-03-17 11:53:53] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2024-03-17 11:53:55] [indexer:background] Health check [2024-03-17 11:53:55] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2024-03-17 11:57:51] [index:background] Health check [2024-03-17 11:57:51] [indexer:background] Health check [2024-03-17 11:57:51] [indexer:background] Health check [2024-03-17 12:02:11] [index:background] Health check [2024-03-17 12:02:11] [indexer:background] Health check [2024-03-17 12:02:11] [indexer:background] Health check [2024-03-17 12:09:17] [index:background] Health check [2024-03-17 12:09:17] [indexer:background] Health check [2024-03-17 12:09:17] [indexer:background] Health check [2024-03-17 12:12:07] [index:background] Health check [2024-03-17 12:12:16] [indexer:background] Health check [2024-03-17 12:17:28] [index:background] Health check [2024-03-17 12:17:28] [indexer:background] Health check [2024-03-17 12:17:28] [indexer:background] Health check [2024-03-17 12:23:56] [index:background] Health check [2024-03-17 12:23:57] [indexer:background] Health check [2024-03-17 12:23:57] [indexer:background] Health check [2024-03-17 12:27:29] [index:background] Health check [2024-03-17 12:27:29] [indexer:background] Health check [2024-03-17 12:27:29] [indexer:background] Health check [2024-03-17 12:32:11] [index:background] Health check [2024-03-17 12:32:11] [indexer:background] Health check [2024-03-17 12:32:11] [indexer:background] Health check [2024-03-17 12:37:44] [index:background] Health check [2024-03-17 12:37:45] [indexer:background] Health check [2024-03-17 12:37:45] [indexer:background] Health check [2024-03-17 12:42:15] [index:background] Health check [2024-03-17 12:42:15] [indexer:background] Health check [2024-03-17 12:42:15] [indexer:background] Health check [2024-03-17 12:47:10] [index:background] Health check [2024-03-17 12:47:49] [indexer:background] Health check [2024-03-17 12:52:06] [index:background] Health check [2024-03-17 12:53:05] [indexer:background] Health check [2024-03-17 12:57:26] [index:background] Health check [2024-03-17 12:57:26] [indexer:background] Health check [2024-03-17 12:57:26] [indexer:background] Health check [2024-03-17 13:02:20] [index:background] Health check [2024-03-17 13:02:20] [indexer:background] Health check [2024-03-17 13:02:20] [indexer:background] Health check [2024-03-17 13:10:38] [index:background] Health check [2024-03-17 13:10:38] [indexer:background] Health check [2024-03-17 13:10:38] [indexer:background] Health check [2024-03-17 13:12:52] [index:background] Health check [2024-03-17 13:12:52] [indexer:background] Health check [2024-03-17 13:12:52] [indexer:background] Health check [2024-03-17 13:17:43] [index:background] Health check [2024-03-17 13:17:43] [indexer:background] Health check [2024-03-17 13:17:43] [indexer:background] Health check [2024-03-17 13:22:39] [index:background] Health check [2024-03-17 13:22:39] [indexer:background] Health check [2024-03-17 13:22:39] [indexer:background] Health check [2024-03-17 13:27:33] [index:background] Health check [2024-03-17 13:27:33] [indexer:background] Health check [2024-03-17 13:27:33] [indexer:background] Health check [2024-03-17 13:32:20] [index:background] Health check [2024-03-17 13:32:20] [indexer:background] Health check [2024-03-17 13:32:20] [indexer:background] Health check [2024-03-17 13:37:48] [index:background] Health check [2024-03-17 13:37:48] [indexer:background] Health check [2024-03-17 13:37:48] [indexer:background] Health check [2024-03-17 13:42:23] [index:background] Health check [2024-03-17 13:42:23] [indexer:background] Health check [2024-03-17 13:42:23] [indexer:background] Health check [2024-03-17 13:48:20] [index:background] Health check [2024-03-17 13:48:20] [indexer:background] Health check [2024-03-17 13:48:20] [indexer:background] Health check [2024-03-17 13:52:36] [index:background] Health check [2024-03-17 13:52:36] [indexer:background] Health check [2024-03-17 13:52:36] [indexer:background] Health check [2024-03-17 13:57:26] [index:background] Health check [2024-03-17 13:57:26] [indexer:background] Health check [2024-03-17 13:57:26] [indexer:background] Health check [2024-03-17 14:03:11] [index:background] Health check [2024-03-17 14:03:11] [indexer:background] Health check [2024-03-17 14:03:11] [indexer:background] Health check [2024-03-17 14:08:18] [index:background] Health check [2024-03-17 14:08:18] [indexer:background] Health check [2024-03-17 14:08:18] [indexer:background] Health check [2024-03-17 14:15:18] [index:background] Health check [2024-03-17 14:15:18] [indexer:background] Health check [2024-03-17 14:15:18] [indexer:background] Health check [2024-03-17 14:17:12] [index:background] Health check [2024-03-17 14:17:12] [indexer:background] Health check [2024-03-17 14:17:12] [indexer:background] Health check [2024-03-17 14:22:10] [index:background] Health check [2024-03-17 14:22:14] [indexer:background] Health check [2024-03-17 14:27:04] [index:background] Health check [2024-03-17 14:28:22] [indexer:background] Health check [2024-03-17 14:33:20] [index:background] Health check [2024-03-17 14:33:20] [indexer:background] Health check [2024-03-17 14:33:20] [indexer:background] Health check [2024-03-17 14:38:13] [index:background] Health check [2024-03-17 14:38:13] [indexer:background] Health check [2024-03-17 14:38:13] [indexer:background] Health check [2024-03-17 14:42:22] [index:background] Health check [2024-03-17 14:42:22] [indexer:background] Health check [2024-03-17 14:42:22] [indexer:background] Health check [2024-03-17 14:47:07] [index:background] Health check [2024-03-17 14:47:24] [indexer:background] Health check [2024-03-17 14:52:14] [index:background] Health check [2024-03-17 14:52:14] [indexer:background] Health check [2024-03-17 14:52:14] [indexer:background] Health check [2024-03-17 14:57:22] [index:background] Health check [2024-03-17 14:57:22] [indexer:background] Health check [2024-03-17 14:57:22] [indexer:background] Health check [2024-03-17 15:02:49] [index:background] Health check [2024-03-17 15:02:49] [indexer:background] Health check [2024-03-17 15:02:49] [indexer:background] Health check [2024-03-17 15:12:44] [index:background] Health check [2024-03-17 15:12:44] [indexer:background] Health check [2024-03-17 15:12:44] [indexer:background] Health check [2024-03-17 15:17:13] [index:background] Health check [2024-03-17 15:17:13] [indexer:background] Health check [2024-03-17 15:17:13] [indexer:background] Health check [2024-03-17 15:25:30] [index:background] Health check [2024-03-17 15:25:30] [indexer:background] Health check [2024-03-17 15:25:30] [indexer:background] Health check [2024-03-17 15:27:13] [index:background] Health check [2024-03-17 15:27:13] [indexer:background] Health check [2024-03-17 15:27:13] [indexer:background] Health check [2024-03-17 15:28:03] [query] Query for: search_term_string [2024-03-17 15:28:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 4 offset: 0 fields: all [2024-03-17 15:28:03] [query] Engine: default [2024-03-17 15:28:03] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-17 15:28:03] [query] Mods: 6 [2024-03-17 15:28:03] [query] Using OR logic [2024-03-17 15:28:05] [query] Found results using: or logic [2024-03-17 15:28:05] [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 30, 10 [2024-03-17 15:28:05] [query] Results: 1356 Pages of results: 136 [2024-03-17 15:28:05] [query] Execution time: 2.08198 [2024-03-17 15:32:29] [index:background] Health check [2024-03-17 15:32:29] [indexer:background] Health check [2024-03-17 15:32:29] [indexer:background] Health check [2024-03-17 15:39:04] [index:background] Health check [2024-03-17 15:39:04] [indexer:background] Health check [2024-03-17 15:39:04] [indexer:background] Health check [2024-03-17 15:43:32] [index:background] Health check [2024-03-17 15:43:32] [indexer:background] Health check [2024-03-17 15:43:32] [indexer:background] Health check [2024-03-17 15:47:05] [index:background] Health check [2024-03-17 15:47:55] [indexer:background] Health check [2024-03-17 15:52:50] [index:background] Health check [2024-03-17 15:52:50] [indexer:background] Health check [2024-03-17 15:52:50] [indexer:background] Health check [2024-03-17 15:59:03] [index:background] Health check [2024-03-17 15:59:03] [indexer:background] Health check [2024-03-17 15:59:03] [indexer:background] Health check [2024-03-17 16:02:11] [index:background] Health check [2024-03-17 16:02:11] [indexer:background] Health check [2024-03-17 16:02:11] [indexer:background] Health check [2024-03-17 16:07:04] [index:background] Health check [2024-03-17 16:08:17] [indexer:background] Health check [2024-03-17 16:12:21] [index:background] Health check [2024-03-17 16:12:21] [indexer:background] Health check [2024-03-17 16:12:21] [indexer:background] Health check [2024-03-17 16:18:21] [index:background] Health check [2024-03-17 16:18:21] [indexer:background] Health check [2024-03-17 16:18:21] [indexer:background] Health check [2024-03-17 16:23:12] [index:background] Health check [2024-03-17 16:23:12] [indexer:background] Health check [2024-03-17 16:23:12] [indexer:background] Health check [2024-03-17 16:27:12] [index:background] Health check [2024-03-17 16:27:12] [indexer:background] Health check [2024-03-17 16:27:12] [indexer:background] Health check [2024-03-17 16:32:06] [index:background] Health check [2024-03-17 16:33:35] [indexer:background] Health check [2024-03-17 16:39:11] [index:background] Health check [2024-03-17 16:39:11] [indexer:background] Health check [2024-03-17 16:39:11] [indexer:background] Health check [2024-03-17 16:42:08] [index:background] Health check [2024-03-17 16:42:57] [indexer:background] Health check [2024-03-17 16:47:05] [index:background] Health check [2024-03-17 16:47:07] [query] Query for: search_term_string [2024-03-17 16:47:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2024-03-17 16:47:07] [query] Engine: default [2024-03-17 16:47:07] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-17 16:47:07] [query] Mods: 6 [2024-03-17 16:47:07] [query] Using OR logic [2024-03-17 16:47:08] [query] Found results using: or logic [2024-03-17 16:47:08] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 10, 10 [2024-03-17 16:47:08] [query] Results: 1356 Pages of results: 136 [2024-03-17 16:47:08] [query] Execution time: 0.45367 [2024-03-17 16:47:16] [indexer:background] Health check [2024-03-17 16:53:24] [index:background] Health check [2024-03-17 16:53:24] [indexer:background] Health check [2024-03-17 16:53:24] [indexer:background] Health check [2024-03-17 16:57:03] [index:background] Health check [2024-03-17 16:57:57] [indexer:background] Health check [2024-03-17 17:02:30] [index:background] Health check [2024-03-17 17:02:30] [indexer:background] Health check [2024-03-17 17:02:30] [indexer:background] Health check [2024-03-17 17:07:11] [index:background] Health check [2024-03-17 17:07:11] [indexer:background] Health check [2024-03-17 17:07:11] [indexer:background] Health check [2024-03-17 17:13:27] [index:background] Health check [2024-03-17 17:13:27] [indexer:background] Health check [2024-03-17 17:13:27] [indexer:background] Health check [2024-03-17 17:17:27] [index:background] Health check [2024-03-17 17:17:27] [indexer:background] Health check [2024-03-17 17:17:28] [indexer:background] Health check [2024-03-17 17:22:33] [index:background] Health check [2024-03-17 17:22:33] [indexer:background] Health check [2024-03-17 17:22:33] [indexer:background] Health check [2024-03-17 17:27:42] [index:background] Health check [2024-03-17 17:27:42] [indexer:background] Health check [2024-03-17 17:27:42] [indexer:background] Health check [2024-03-17 17:32:25] [index:background] Health check [2024-03-17 17:32:25] [indexer:background] Health check [2024-03-17 17:32:25] [indexer:background] Health check [2024-03-17 17:37:41] [index:background] Health check [2024-03-17 17:37:41] [indexer:background] Health check [2024-03-17 17:37:41] [indexer:background] Health check [2024-03-17 17:39:39] [query] Query for: search_term_string [2024-03-17 17:39:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 24 offset: 0 fields: all [2024-03-17 17:39:39] [query] Engine: default [2024-03-17 17:39:39] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-17 17:39:39] [query] Mods: 6 [2024-03-17 17:39:39] [query] Using OR logic [2024-03-17 17:39:39] [query] Found results using: or logic [2024-03-17 17:39: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 (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 230, 10 [2024-03-17 17:39:39] [query] Results: 1356 Pages of results: 136 [2024-03-17 17:39:39] [query] Execution time: 0.33670 [2024-03-17 17:42:02] [index:background] Health check [2024-03-17 17:44:46] [indexer:background] Health check [2024-03-17 17:47:24] [index:background] Health check [2024-03-17 17:47:24] [indexer:background] Health check [2024-03-17 17:47:24] [indexer:background] Health check [2024-03-17 17:52:13] [index:background] Health check [2024-03-17 17:52:14] [indexer:background] Health check [2024-03-17 17:52:14] [indexer:background] Health check [2024-03-17 17:58:29] [index:background] Health check [2024-03-17 17:58:29] [indexer:background] Health check [2024-03-17 17:58:29] [indexer:background] Health check [2024-03-17 18:04:04] [index:background] Health check [2024-03-17 18:04:04] [indexer:background] Health check [2024-03-17 18:04:04] [indexer:background] Health check [2024-03-17 18:07:02] [index:background] Health check [2024-03-17 18:07:14] [indexer:background] Health check [2024-03-17 18:12:07] [index:background] Health check [2024-03-17 18:13:25] [indexer:background] Health check [2024-03-17 18:18:43] [index:background] Health check [2024-03-17 18:18:43] [indexer:background] Health check [2024-03-17 18:18:43] [indexer:background] Health check [2024-03-17 18:24:00] [index:background] Health check [2024-03-17 18:24:00] [indexer:background] Health check [2024-03-17 18:24:00] [indexer:background] Health check [2024-03-17 18:29:25] [index:background] Health check [2024-03-17 18:29:25] [indexer:background] Health check [2024-03-17 18:29:25] [indexer:background] Health check [2024-03-17 18:32:05] [index:background] Health check [2024-03-17 18:32:29] [indexer:background] Health check [2024-03-17 18:37:05] [index:background] Health check [2024-03-17 18:37:14] [indexer:background] Health check [2024-03-17 18:42:04] [index:background] Health check [2024-03-17 18:42:14] [indexer:background] Health check [2024-03-17 18:47:07] [index:background] Health check [2024-03-17 18:47:13] [indexer:background] Health check [2024-03-17 18:52:27] [index:background] Health check [2024-03-17 18:52:27] [indexer:background] Health check [2024-03-17 18:52:27] [indexer:background] Health check [2024-03-17 18:57:44] [index:background] Health check [2024-03-17 18:57:44] [indexer:background] Health check [2024-03-17 18:57:44] [indexer:background] Health check [2024-03-17 19:02:49] [index:background] Health check [2024-03-17 19:02:49] [indexer:background] Health check [2024-03-17 19:02:49] [indexer:background] Health check [2024-03-17 19:07:05] [index:background] Health check [2024-03-17 19:09:00] [indexer:background] Health check [2024-03-17 19:13:07] [index:background] Health check [2024-03-17 19:13:07] [indexer:background] Health check [2024-03-17 19:13:08] [indexer:background] Health check [2024-03-17 19:18:15] [index:background] Health check [2024-03-17 19:18:16] [indexer:background] Health check [2024-03-17 19:18:16] [indexer:background] Health check [2024-03-17 19:22:53] [index:background] Health check [2024-03-17 19:22:53] [indexer:background] Health check [2024-03-17 19:22:53] [indexer:background] Health check [2024-03-17 19:28:06] [index:background] Health check [2024-03-17 19:28:06] [indexer:background] Health check [2024-03-17 19:28:06] [indexer:background] Health check [2024-03-17 19:32:04] [index:background] Health check [2024-03-17 19:33:03] [indexer:background] Health check [2024-03-17 19:37:55] [index:background] Health check [2024-03-17 19:37:55] [indexer:background] Health check [2024-03-17 19:37:55] [indexer:background] Health check [2024-03-17 19:43:24] [index:background] Health check [2024-03-17 19:43:24] [indexer:background] Health check [2024-03-17 19:43:24] [indexer:background] Health check [2024-03-17 19:48:01] [index:background] Health check [2024-03-17 19:48:01] [indexer:background] Health check [2024-03-17 19:48:01] [indexer:background] Health check [2024-03-17 19:52:03] [index:background] Health check [2024-03-17 19:53:13] [indexer:background] Health check [2024-03-17 19:57:16] [index:background] Health check [2024-03-17 19:57:16] [indexer:background] Health check [2024-03-17 19:57:16] [indexer:background] Health check [2024-03-17 20:03:11] [index:background] Health check [2024-03-17 20:03:11] [indexer:background] Health check [2024-03-17 20:03:11] [indexer:background] Health check [2024-03-17 20:07:03] [index:background] Health check [2024-03-17 20:07:14] [indexer:background] Health check [2024-03-17 20:12:27] [index:background] Health check [2024-03-17 20:12:27] [indexer:background] Health check [2024-03-17 20:12:27] [indexer:background] Health check [2024-03-17 20:17:28] [index:background] Health check [2024-03-17 20:17:28] [indexer:background] Health check [2024-03-17 20:17:28] [indexer:background] Health check [2024-03-17 20:22:25] [index:background] Health check [2024-03-17 20:22:25] [indexer:background] Health check [2024-03-17 20:22:25] [indexer:background] Health check [2024-03-17 20:27:39] [index:background] Health check [2024-03-17 20:27:39] [indexer:background] Health check [2024-03-17 20:27:39] [indexer:background] Health check [2024-03-17 20:32:35] [index:background] Health check [2024-03-17 20:32:35] [indexer:background] Health check [2024-03-17 20:32:35] [indexer:background] Health check [2024-03-17 20:37:14] [index:background] Health check [2024-03-17 20:37:14] [indexer:background] Health check [2024-03-17 20:37:14] [indexer:background] Health check [2024-03-17 20:42:14] [index:background] Health check [2024-03-17 20:42:14] [indexer:background] Health check [2024-03-17 20:42:14] [indexer:background] Health check [2024-03-17 20:48:47] [index:background] Health check [2024-03-17 20:48:47] [indexer:background] Health check [2024-03-17 20:48:47] [indexer:background] Health check [2024-03-17 20:53:53] [index:background] Health check [2024-03-17 20:53:53] [indexer:background] Health check [2024-03-17 20:53:53] [indexer:background] Health check [2024-03-17 20:58:11] [index:background] Health check [2024-03-17 20:58:11] [indexer:background] Health check [2024-03-17 20:58:11] [indexer:background] Health check [2024-03-17 21:02:11] [index:background] Health check [2024-03-17 21:03:06] [indexer:background] Health check [2024-03-17 21:07:07] [index:background] Health check [2024-03-17 21:07:56] [indexer:background] Health check [2024-03-17 21:12:10] [index:background] Health check [2024-03-17 21:12:20] [indexer:background] Health check [2024-03-17 21:17:03] [index:background] Health check [2024-03-17 21:17:12] [indexer:background] Health check [2024-03-17 21:22:39] [index:background] Health check [2024-03-17 21:22:40] [indexer:background] Health check [2024-03-17 21:22:40] [indexer:background] Health check [2024-03-17 21:27:38] [index:background] Health check [2024-03-17 21:27:38] [indexer:background] Health check [2024-03-17 21:27:38] [indexer:background] Health check [2024-03-17 21:32:03] [index:background] Health check [2024-03-17 21:32:24] [indexer:background] Health check [2024-03-17 21:37:28] [index:background] Health check [2024-03-17 21:37:28] [indexer:background] Health check [2024-03-17 21:37:28] [indexer:background] Health check [2024-03-17 21:42:17] [index:background] Health check [2024-03-17 21:42:17] [indexer:background] Health check [2024-03-17 21:42:17] [indexer:background] Health check [2024-03-17 21:47:06] [index:background] Health check [2024-03-17 21:47:27] [indexer:background] Health check [2024-03-17 21:52:28] [index:background] Health check [2024-03-17 21:52:28] [indexer:background] Health check [2024-03-17 21:52:28] [indexer:background] Health check [2024-03-17 21:57:43] [index:background] Health check [2024-03-17 21:57:43] [indexer:background] Health check [2024-03-17 21:57:43] [indexer:background] Health check [2024-03-17 22:02:32] [index:background] Health check [2024-03-17 22:02:32] [indexer:background] Health check [2024-03-17 22:02:33] [indexer:background] Health check [2024-03-17 22:07:12] [index:background] Health check [2024-03-17 22:07:12] [indexer:background] Health check [2024-03-17 22:07:12] [indexer:background] Health check [2024-03-17 22:12:07] [index:background] Health check [2024-03-17 22:12:13] [indexer:background] Health check [2024-03-17 22:17:38] [index:background] Health check [2024-03-17 22:17:38] [indexer:background] Health check [2024-03-17 22:17:38] [indexer:background] Health check [2024-03-17 22:22:22] [index:background] Health check [2024-03-17 22:22:22] [indexer:background] Health check [2024-03-17 22:22:22] [indexer:background] Health check [2024-03-17 22:27:14] [index:background] Health check [2024-03-17 22:27:14] [indexer:background] Health check [2024-03-17 22:27:14] [indexer:background] Health check [2024-03-17 22:32:17] [index:background] Health check [2024-03-17 22:32:17] [indexer:background] Health check [2024-03-17 22:32:17] [indexer:background] Health check [2024-03-17 22:38:41] [index:background] Health check [2024-03-17 22:38:41] [indexer:background] Health check [2024-03-17 22:38:41] [indexer:background] Health check [2024-03-17 22:42:05] [index:background] Health check [2024-03-17 22:42:27] [indexer:background] Health check [2024-03-17 22:47:04] [index:background] Health check [2024-03-17 22:47:26] [indexer:background] Health check [2024-03-17 22:52:32] [index:background] Health check [2024-03-17 22:52:32] [indexer:background] Health check [2024-03-17 22:52:32] [indexer:background] Health check [2024-03-17 22:57:18] [index:background] Health check [2024-03-17 22:57:18] [indexer:background] Health check [2024-03-17 22:57:18] [indexer:background] Health check [2024-03-17 23:02:25] [index:background] Health check [2024-03-17 23:02:25] [indexer:background] Health check [2024-03-17 23:02:25] [indexer:background] Health check [2024-03-17 23:07:05] [index:background] Health check [2024-03-17 23:07:56] [indexer:background] Health check [2024-03-17 23:12:27] [index:background] Health check [2024-03-17 23:12:27] [indexer:background] Health check [2024-03-17 23:12:27] [indexer:background] Health check [2024-03-17 23:17:02] [index:background] Health check [2024-03-17 23:17:18] [indexer:background] Health check [2024-03-17 23:22:12] [index:background] Health check [2024-03-17 23:22:12] [indexer:background] Health check [2024-03-17 23:22:12] [indexer:background] Health check [2024-03-17 23:27:35] [index:background] Health check [2024-03-17 23:27:35] [indexer:background] Health check [2024-03-17 23:27:35] [indexer:background] Health check [2024-03-17 23:33:10] [index:background] Health check [2024-03-17 23:33:10] [indexer:background] Health check [2024-03-17 23:33:10] [indexer:background] Health check [2024-03-17 23:37:08] [index:background] Health check [2024-03-17 23:37:44] [indexer:background] Health check [2024-03-17 23:42:26] [index:background] Health check [2024-03-17 23:42:26] [indexer:background] Health check [2024-03-17 23:42:26] [indexer:background] Health check [2024-03-17 23:47:21] [index:background] Health check [2024-03-17 23:47:21] [indexer:background] Health check [2024-03-17 23:47:21] [indexer:background] Health check [2024-03-17 23:52:02] [index:background] Health check [2024-03-17 23:52:23] [indexer:background] Health check [2024-03-17 23:57:06] [index:background] Health check [2024-03-17 23:57:29] [indexer:background] Health check