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