[2024-04-16 00:00:23] [indexer:background] Health check [2024-04-16 00:00:23] [index:background] Health check [2024-04-16 00:04:24] [indexer:background] Health check [2024-04-16 00:05:59] [index:background] Health check [2024-04-16 00:10:47] [indexer:background] Health check [2024-04-16 00:10:47] [index:background] Health check [2024-04-16 00:14:26] [indexer:background] Health check [2024-04-16 00:15:13] [index:background] Health check [2024-04-16 00:20:03] [indexer:background] Health check [2024-04-16 00:20:41] [index:background] Health check [2024-04-16 00:24:57] [indexer:background] Health check [2024-04-16 00:25:15] [index:background] Health check [2024-04-16 00:30:30] [indexer:background] Health check [2024-04-16 00:30:31] [index:background] Health check [2024-04-16 00:34:25] [indexer:background] Health check [2024-04-16 00:35:09] [index:background] Health check [2024-04-16 00:39:55] [indexer:background] Health check [2024-04-16 00:40:05] [indexer:background] Health check [2024-04-16 00:40:30] [index:background] Health check [2024-04-16 00:44:27] [indexer:background] Health check [2024-04-16 00:45:19] [index:background] Health check [2024-04-16 00:49:17] [indexer:background] Health check [2024-04-16 00:50:36] [index:background] Health check [2024-04-16 00:55:12] [indexer:background] Health check [2024-04-16 00:55:12] [index:background] Health check [2024-04-16 00:59:44] [indexer:background] Health check [2024-04-16 01:01:34] [index:background] Health check [2024-04-16 01:05:12] [indexer:background] Health check [2024-04-16 01:05:12] [index:background] Health check [2024-04-16 01:09:18] [indexer:background] Health check [2024-04-16 01:10:13] [index:background] Health check [2024-04-16 01:14:58] [indexer:background] Health check [2024-04-16 01:16:25] [index:background] Health check [2024-04-16 01:19:15] [indexer:background] Health check [2024-04-16 01:20:23] [index:background] Health check [2024-04-16 01:25:20] [indexer:background] Health check [2024-04-16 01:25:20] [index:background] Health check [2024-04-16 01:29:42] [indexer:background] Health check [2024-04-16 01:31:07] [index:background] Health check [2024-04-16 01:35:06] [indexer:background] Health check [2024-04-16 01:35:22] [index:background] Health check [2024-04-16 01:40:40] [indexer:background] Health check [2024-04-16 01:40:40] [index:background] Health check [2024-04-16 01:44:25] [indexer:background] Health check [2024-04-16 01:46:05] [index:background] Health check [2024-04-16 01:52:58] [indexer:background] Health check [2024-04-16 01:52:58] [index:background] Health check [2024-04-16 01:54:36] [indexer:background] Health check [2024-04-16 01:56:18] [index:background] Health check [2024-04-16 01:59:16] [indexer:background] Health check [2024-04-16 02:01:42] [index:background] Health check [2024-04-16 02:05:11] [indexer:background] Health check [2024-04-16 02:05:11] [index:background] Health check [2024-04-16 02:09:22] [indexer:background] Health check [2024-04-16 02:10:11] [index:background] Health check [2024-04-16 02:14:21] [indexer:background] Health check [2024-04-16 02:15:12] [index:background] Health check [2024-04-16 02:21:26] [indexer:background] Health check [2024-04-16 02:21:29] [index:background] Health check [2024-04-16 02:24:17] [indexer:background] Health check [2024-04-16 02:25:11] [index:background] Health check [2024-04-16 02:29:26] [indexer:background] Health check [2024-04-16 02:30:34] [index:background] Health check [2024-04-16 02:38:10] [indexer:background] Health check [2024-04-16 02:38:10] [index:background] Health check [2024-04-16 02:39:26] [indexer:background] Health check [2024-04-16 02:41:29] [index:background] Health check [2024-04-16 02:44:24] [indexer:background] Health check [2024-04-16 02:46:44] [index:background] Health check [2024-04-16 02:49:17] [indexer:background] Health check [2024-04-16 02:50:15] [index:background] Health check [2024-04-16 02:54:53] [indexer:background] Health check [2024-04-16 02:55:21] [index:background] Health check [2024-04-16 02:59:51] [indexer:background] Health check [2024-04-16 03:03:08] [index:background] Health check [2024-04-16 03:05:25] [indexer:background] Health check [2024-04-16 03:05:25] [index:background] Health check [2024-04-16 03:09:35] [indexer:background] Health check [2024-04-16 03:10:47] [index:background] Health check [2024-04-16 03:14:41] [indexer:background] Health check [2024-04-16 03:16:04] [index:background] Health check [2024-04-16 03:20:15] [indexer:background] Health check [2024-04-16 03:20:15] [index:background] Health check [2024-04-16 03:25:46] [indexer:background] Health check [2024-04-16 03:25:46] [index:background] Health check [2024-04-16 03:30:03] [indexer:background] Health check [2024-04-16 03:30:20] [index:background] Health check [2024-04-16 03:34:16] [indexer:background] Health check [2024-04-16 03:34:16] [indexer:background] CPU load threshold (3) breached: 4.64 [waiting 2] [2024-04-16 03:35:12] [index:background] Health check [2024-04-16 03:35:12] [index:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2024-04-16 03:35:14] [indexer:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2024-04-16 03:39:18] [indexer:background] Health check [2024-04-16 03:41:41] [index:background] Health check [2024-04-16 03:45:14] [indexer:background] Health check [2024-04-16 03:45:15] [index:background] Health check [2024-04-16 03:49:43] [indexer:background] Health check [2024-04-16 03:52:12] [index:background] Health check [2024-04-16 03:55:01] [indexer:background] Health check [2024-04-16 03:56:43] [index:background] Health check [2024-04-16 03:59:45] [indexer:background] Health check [2024-04-16 04:00:20] [index:background] Health check [2024-04-16 04:05:47] [indexer:background] Health check [2024-04-16 04:05:47] [index:background] Health check [2024-04-16 04:09:17] [indexer:background] Health check [2024-04-16 04:11:10] [index:background] Health check [2024-04-16 04:14:19] [indexer:background] Health check [2024-04-16 04:15:43] [index:background] Health check [2024-04-16 04:19:52] [indexer:background] Health check [2024-04-16 04:20:18] [index:background] Health check [2024-04-16 04:24:36] [indexer:background] Health check [2024-04-16 04:25:46] [index:background] Health check [2024-04-16 04:29:57] [indexer:background] Health check [2024-04-16 04:30:19] [index:background] Health check [2024-04-16 04:35:52] [indexer:background] Health check [2024-04-16 04:35:52] [index:background] Health check [2024-04-16 04:40:51] [indexer:background] Health check [2024-04-16 04:40:51] [index:background] Health check [2024-04-16 04:44:47] [indexer:background] Health check [2024-04-16 04:45:54] [index:background] Health check [2024-04-16 04:50:08] [indexer:background] Health check [2024-04-16 04:50:30] [index:background] Health check [2024-04-16 04:54:51] [indexer:background] Health check [2024-04-16 04:55:29] [index:background] Health check [2024-04-16 04:59:19] [indexer:background] Health check [2024-04-16 05:00:31] [index:background] Health check [2024-04-16 05:04:19] [indexer:background] Health check [2024-04-16 05:05:23] [index:background] Health check [2024-04-16 05:09:35] [indexer:background] Health check [2024-04-16 05:10:39] [index:background] Health check [2024-04-16 05:14:27] [indexer:background] Health check [2024-04-16 05:15:25] [index:background] Health check [2024-04-16 05:19:38] [indexer:background] Health check [2024-04-16 05:20:27] [index:background] Health check [2024-04-16 05:24:19] [indexer:background] Health check [2024-04-16 05:25:11] [index:background] Health check [2024-04-16 05:31:11] [indexer:background] Health check [2024-04-16 05:31:13] [index:background] Health check [2024-04-16 05:34:48] [indexer:background] Health check [2024-04-16 05:34:48] [indexer:background] CPU load threshold (3) breached: 4.18 [waiting 2] [2024-04-16 05:35:30] [index:background] Health check [2024-04-16 05:41:38] [indexer:background] Health check [2024-04-16 05:41:38] [index:background] Health check [2024-04-16 05:44:16] [indexer:background] Health check [2024-04-16 05:45:13] [index:background] Health check [2024-04-16 05:49:17] [indexer:background] Health check [2024-04-16 05:52:00] [index:background] Health check [2024-04-16 05:54:17] [indexer:background] Health check [2024-04-16 05:56:07] [index:background] Health check [2024-04-16 06:00:16] [indexer:background] Health check [2024-04-16 06:00:16] [index:background] Health check [2024-04-16 06:04:24] [indexer:background] Health check [2024-04-16 06:05:20] [index:background] Health check [2024-04-16 06:09:21] [indexer:background] Health check [2024-04-16 06:10:11] [index:background] Health check [2024-04-16 06:14:19] [indexer:background] Health check [2024-04-16 06:15:39] [index:background] Health check [2024-04-16 06:19:37] [indexer:background] Health check [2024-04-16 06:20:28] [index:background] Health check [2024-04-16 06:24:38] [indexer:background] Health check [2024-04-16 06:25:17] [index:background] Health check [2024-04-16 06:29:36] [indexer:background] Health check [2024-04-16 06:30:33] [index:background] Health check [2024-04-16 06:34:20] [indexer:background] Health check [2024-04-16 06:35:40] [index:background] Health check [2024-04-16 06:38:49] [query] Query for: {search_term_string} [2024-04-16 06:38:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 136 offset: 0 fields: all [2024-04-16 06:38:49] [query] Engine: default [2024-04-16 06:38:50] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-16 06:38:50] [query] Mods: 6 [2024-04-16 06:38:50] [query] Using OR logic [2024-04-16 06:38:51] [query] Found results using: or logic [2024-04-16 06:38:51] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 1350, 10 [2024-04-16 06:38:51] [query] Results: 1361 Pages of results: 137 [2024-04-16 06:38:51] [query] Execution time: 1.90360 [2024-04-16 06:38:58] [query] Query for: {search_term_string} [2024-04-16 06:38:58] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 134 offset: 0 fields: all [2024-04-16 06:38:58] [query] Engine: default [2024-04-16 06:38:58] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-16 06:38:58] [query] Mods: 6 [2024-04-16 06:38:58] [query] Using OR logic [2024-04-16 06:38:58] [query] Found results using: or logic [2024-04-16 06:38:58] [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 1330, 10 [2024-04-16 06:38:58] [query] Results: 1361 Pages of results: 137 [2024-04-16 06:38:58] [query] Execution time: 0.29346 [2024-04-16 06:39:17] [indexer:background] Health check [2024-04-16 06:39:27] [query] Query for: {search_term_string} [2024-04-16 06:39:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 135 offset: 0 fields: all [2024-04-16 06:39:27] [query] Engine: default [2024-04-16 06:39:27] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-16 06:39:27] [query] Mods: 6 [2024-04-16 06:39:27] [query] Using OR logic [2024-04-16 06:39:27] [query] Found results using: or logic [2024-04-16 06:39:27] [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 1340, 10 [2024-04-16 06:39:27] [query] Results: 1361 Pages of results: 137 [2024-04-16 06:39:27] [query] Execution time: 0.22845 [2024-04-16 06:41:11] [index:background] Health check [2024-04-16 06:45:20] [indexer:background] Health check [2024-04-16 06:45:20] [index:background] Health check [2024-04-16 06:50:16] [indexer:background] Health check [2024-04-16 06:50:16] [index:background] Health check [2024-04-16 06:55:14] [indexer:background] Health check [2024-04-16 06:55:14] [index:background] Health check [2024-04-16 07:00:00] [indexer:background] Health check [2024-04-16 07:01:24] [index:background] Health check [2024-04-16 07:05:25] [indexer:background] Health check [2024-04-16 07:05:25] [index:background] Health check [2024-04-16 07:09:18] [indexer:background] Health check [2024-04-16 07:10:37] [index:background] Health check [2024-04-16 07:14:50] [indexer:background] Health check [2024-04-16 07:15:26] [index:background] Health check [2024-04-16 07:19:26] [indexer:background] Health check [2024-04-16 07:21:57] [index:background] Health check [2024-04-16 07:24:16] [indexer:background] Health check [2024-04-16 07:25:10] [index:background] Health check [2024-04-16 07:29:44] [indexer:background] Health check [2024-04-16 07:30:13] [index:background] Health check [2024-04-16 07:34:33] [indexer:background] Health check [2024-04-16 07:35:46] [index:background] Health check [2024-04-16 07:35:46] [index:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2024-04-16 07:35:48] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2024-04-16 07:40:43] [indexer:background] Health check [2024-04-16 07:40:43] [index:background] Health check [2024-04-16 07:44:22] [indexer:background] Health check [2024-04-16 07:45:13] [index:background] Health check [2024-04-16 07:50:22] [indexer:background] Health check [2024-04-16 07:50:22] [index:background] Health check [2024-04-16 07:54:24] [indexer:background] Health check [2024-04-16 07:55:25] [index:background] Health check [2024-04-16 07:59:31] [indexer:background] Health check [2024-04-16 08:00:12] [index:background] Health check [2024-04-16 08:04:20] [indexer:background] Health check [2024-04-16 08:05:16] [index:background] Health check [2024-04-16 08:10:03] [indexer:background] Health check [2024-04-16 08:10:52] [index:background] Health check [2024-04-16 08:14:30] [indexer:background] Health check [2024-04-16 08:15:40] [index:background] Health check [2024-04-16 08:19:17] [indexer:background] Health check [2024-04-16 08:20:09] [index:background] Health check [2024-04-16 08:24:23] [indexer:background] Health check [2024-04-16 08:25:49] [index:background] Health check [2024-04-16 08:29:32] [indexer:background] Health check [2024-04-16 08:30:27] [index:background] Health check [2024-04-16 08:35:04] [indexer:background] Health check [2024-04-16 08:35:37] [index:background] Health check [2024-04-16 08:39:24] [indexer:background] Health check [2024-04-16 08:40:15] [index:background] Health check [2024-04-16 08:44:33] [indexer:background] Health check [2024-04-16 08:45:13] [index:background] Health check [2024-04-16 08:49:28] [indexer:background] Health check [2024-04-16 08:50:44] [index:background] Health check [2024-04-16 08:54:23] [indexer:background] Health check [2024-04-16 08:55:29] [index:background] Health check [2024-04-16 09:00:15] [indexer:background] Health check [2024-04-16 09:00:15] [index:background] Health check [2024-04-16 09:04:51] [indexer:background] Health check [2024-04-16 09:05:27] [index:background] Health check [2024-04-16 09:09:26] [indexer:background] Health check [2024-04-16 09:10:12] [index:background] Health check [2024-04-16 09:14:42] [indexer:background] Health check [2024-04-16 09:16:28] [index:background] Health check [2024-04-16 09:21:49] [indexer:background] Health check [2024-04-16 09:21:49] [index:background] Health check [2024-04-16 09:24:37] [indexer:background] Health check [2024-04-16 09:25:14] [index:background] Health check [2024-04-16 09:30:02] [indexer:background] Health check [2024-04-16 09:30:27] [index:background] Health check [2024-04-16 09:34:27] [indexer:background] Health check [2024-04-16 09:35:18] [index:background] Health check [2024-04-16 09:39:20] [indexer:background] Health check [2024-04-16 09:40:39] [index:background] Health check [2024-04-16 09:44:31] [indexer:background] Health check [2024-04-16 09:45:24] [index:background] Health check [2024-04-16 09:50:02] [indexer:background] Health check [2024-04-16 09:50:26] [index:background] Health check [2024-04-16 09:54:31] [indexer:background] Health check [2024-04-16 09:55:29] [index:background] Health check [2024-04-16 09:59:48] [indexer:background] Health check [2024-04-16 10:00:36] [index:background] Health check [2024-04-16 10:04:19] [indexer:background] Health check [2024-04-16 10:05:12] [index:background] Health check [2024-04-16 10:09:16] [indexer:background] Health check [2024-04-16 10:10:13] [index:background] Health check [2024-04-16 10:14:19] [indexer:background] Health check [2024-04-16 10:15:17] [index:background] Health check [2024-04-16 10:19:17] [indexer:background] Health check [2024-04-16 10:20:13] [index:background] Health check [2024-04-16 10:24:17] [indexer:background] Health check [2024-04-16 10:25:13] [index:background] Health check [2024-04-16 10:29:50] [indexer:background] Health check [2024-04-16 10:30:14] [index:background] Health check [2024-04-16 10:34:19] [indexer:background] Health check [2024-04-16 10:35:10] [index:background] Health check [2024-04-16 10:39:42] [indexer:background] Health check [2024-04-16 10:40:12] [index:background] Health check [2024-04-16 10:44:16] [indexer:background] Health check [2024-04-16 10:45:16] [index:background] Health check [2024-04-16 10:49:23] [indexer:background] Health check [2024-04-16 10:50:12] [index:background] Health check [2024-04-16 10:54:19] [indexer:background] Health check [2024-04-16 10:55:11] [index:background] Health check [2024-04-16 10:59:18] [indexer:background] Health check [2024-04-16 11:00:12] [index:background] Health check [2024-04-16 11:04:18] [indexer:background] Health check [2024-04-16 11:05:10] [index:background] Health check [2024-04-16 11:09:16] [indexer:background] Health check [2024-04-16 11:10:10] [index:background] Health check [2024-04-16 11:14:27] [indexer:background] Health check [2024-04-16 11:15:16] [index:background] Health check [2024-04-16 11:19:17] [indexer:background] Health check [2024-04-16 11:20:11] [index:background] Health check [2024-04-16 11:24:39] [indexer:background] Health check [2024-04-16 11:25:15] [index:background] Health check [2024-04-16 11:29:35] [indexer:background] Health check [2024-04-16 11:30:33] [index:background] Health check [2024-04-16 11:34:35] [indexer:background] Health check [2024-04-16 11:35:25] [index:background] Health check [2024-04-16 11:40:43] [indexer:background] Health check [2024-04-16 11:40:43] [index:background] Health check [2024-04-16 11:44:34] [indexer:background] Health check [2024-04-16 11:45:47] [index:background] Health check [2024-04-16 11:49:58] [indexer:background] Health check [2024-04-16 11:50:41] [index:background] Health check [2024-04-16 11:54:48] [indexer:background] Health check [2024-04-16 11:56:17] [index:background] Health check [2024-04-16 11:59:21] [indexer:background] Health check [2024-04-16 12:00:15] [index:background] Health check [2024-04-16 12:04:20] [indexer:background] Health check [2024-04-16 12:05:32] [index:background] Health check [2024-04-16 12:10:19] [indexer:background] Health check [2024-04-16 12:10:19] [index:background] Health check [2024-04-16 12:14:40] [indexer:background] Health check [2024-04-16 12:15:34] [index:background] Health check [2024-04-16 12:20:23] [indexer:background] Health check [2024-04-16 12:20:23] [index:background] Health check [2024-04-16 12:25:46] [indexer:background] Health check [2024-04-16 12:25:46] [index:background] Health check [2024-04-16 12:29:32] [indexer:background] Health check [2024-04-16 12:30:11] [index:background] Health check [2024-04-16 12:35:25] [indexer:background] Health check [2024-04-16 12:35:25] [index:background] Health check [2024-04-16 12:39:20] [indexer:background] Health check [2024-04-16 12:39:20] [indexer:background] CPU load threshold (3) breached: 4.3 [waiting 2] [2024-04-16 12:40:33] [index:background] Health check [2024-04-16 12:44:18] [indexer:background] Health check [2024-04-16 12:45:20] [index:background] Health check [2024-04-16 12:49:34] [indexer:background] Health check [2024-04-16 12:50:37] [index:background] Health check [2024-04-16 12:54:47] [indexer:background] Health check [2024-04-16 12:55:15] [index:background] Health check [2024-04-16 12:59:21] [indexer:background] Health check [2024-04-16 13:00:22] [index:background] Health check [2024-04-16 13:04:17] [indexer:background] Health check [2024-04-16 13:05:10] [index:background] Health check [2024-04-16 13:09:17] [indexer:background] Health check [2024-04-16 13:10:36] [index:background] Health check [2024-04-16 13:14:41] [indexer:background] Health check [2024-04-16 13:15:19] [index:background] Health check [2024-04-16 13:19:26] [indexer:background] Health check [2024-04-16 13:20:28] [index:background] Health check [2024-04-16 13:24:42] [indexer:background] Health check [2024-04-16 13:25:07] [query] Query for: 2023 [2024-04-16 13:25:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 13:25:07] [query] Engine: default [2024-04-16 13:25:07] [query] Tokens: 2023 [2024-04-16 13:25:07] [query] Mods: 6 [2024-04-16 13:25:07] [query] Found results using: or logic [2024-04-16 13:25: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 (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-16 13:25:08] [query] Results: 273 Pages of results: 28 [2024-04-16 13:25:08] [query] Execution time: 0.42863 [2024-04-16 13:25:11] [index:background] Health check [2024-04-16 13:25:11] [query] Query for: 2024 [2024-04-16 13:25:11] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 13:25:11] [query] Engine: default [2024-04-16 13:25:11] [query] Tokens: 2024 [2024-04-16 13:25:11] [query] Mods: 6 [2024-04-16 13:25:11] [query] Found results using: or logic [2024-04-16 13:25:11] [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-04-16 13:25:11] [query] Results: 150 Pages of results: 15 [2024-04-16 13:25:11] [query] Execution time: 0.14514 [2024-04-16 13:29:51] [indexer:background] Health check [2024-04-16 13:30:14] [index:background] Health check [2024-04-16 13:34:51] [indexer:background] Health check [2024-04-16 13:35:18] [index:background] Health check [2024-04-16 13:39:18] [indexer:background] Health check [2024-04-16 13:40:19] [index:background] Health check [2024-04-16 13:40:19] [index:background] CPU load threshold (3) breached: 4.42 [waiting 2] [2024-04-16 13:40:21] [indexer:background] CPU load threshold (3) breached: 4.15 [waiting 2] [2024-04-16 13:44:33] [indexer:background] Health check [2024-04-16 13:45:35] [index:background] Health check [2024-04-16 13:49:32] [indexer:background] Health check [2024-04-16 13:50:26] [index:background] Health check [2024-04-16 13:54:16] [indexer:background] Health check [2024-04-16 13:55:11] [index:background] Health check [2024-04-16 13:59:16] [indexer:background] Health check [2024-04-16 14:00:10] [index:background] Health check [2024-04-16 14:04:16] [indexer:background] Health check [2024-04-16 14:05:12] [index:background] Health check [2024-04-16 14:09:58] [indexer:background] Health check [2024-04-16 14:10:35] [index:background] Health check [2024-04-16 14:14:29] [indexer:background] Health check [2024-04-16 14:15:33] [index:background] Health check [2024-04-16 14:19:16] [indexer:background] Health check [2024-04-16 14:20:55] [index:background] Health check [2024-04-16 14:25:16] [indexer:background] Health check [2024-04-16 14:25:16] [index:background] Health check [2024-04-16 14:29:42] [indexer:background] Health check [2024-04-16 14:30:33] [index:background] Health check [2024-04-16 14:34:18] [indexer:background] Health check [2024-04-16 14:35:56] [index:background] Health check [2024-04-16 14:39:31] [indexer:background] Health check [2024-04-16 14:40:42] [index:background] Health check [2024-04-16 14:44:20] [indexer:background] Health check [2024-04-16 14:45:52] [index:background] Health check [2024-04-16 14:49:26] [indexer:background] Health check [2024-04-16 14:50:57] [index:background] Health check [2024-04-16 14:54:21] [indexer:background] Health check [2024-04-16 14:55:28] [index:background] Health check [2024-04-16 14:59:27] [indexer:background] Health check [2024-04-16 15:01:19] [index:background] Health check [2024-04-16 15:04:26] [indexer:background] Health check [2024-04-16 15:05:15] [index:background] Health check [2024-04-16 15:09:42] [indexer:background] Health check [2024-04-16 15:10:28] [index:background] Health check [2024-04-16 15:14:18] [indexer:background] Health check [2024-04-16 15:16:20] [index:background] Health check [2024-04-16 15:19:23] [indexer:background] Health check [2024-04-16 15:20:21] [index:background] Health check [2024-04-16 15:24:27] [indexer:background] Health check [2024-04-16 15:25:30] [index:background] Health check [2024-04-16 15:29:29] [indexer:background] Health check [2024-04-16 15:30:33] [index:background] Health check [2024-04-16 15:30:36] [query] Query for: search_term_string [2024-04-16 15:30:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 15:30:36] [query] Engine: default [2024-04-16 15:30:36] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-16 15:30:36] [query] Mods: 6 [2024-04-16 15:30:36] [query] Using OR logic [2024-04-16 15:30:37] [query] Found results using: or logic [2024-04-16 15:30:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-04-16 15:30:37] [query] Results: 1361 Pages of results: 137 [2024-04-16 15:30:37] [query] Execution time: 1.49295 [2024-04-16 15:34:16] [indexer:background] Health check [2024-04-16 15:36:19] [index:background] Health check [2024-04-16 15:39:59] [indexer:background] Health check [2024-04-16 15:40:14] [index:background] Health check [2024-04-16 15:43:21] [query] Query for: search_term_string [2024-04-16 15:43:21] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 15:43:21] [query] Engine: default [2024-04-16 15:43:21] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-16 15:43:21] [query] Mods: 6 [2024-04-16 15:43:21] [query] Using OR logic [2024-04-16 15:43:21] [query] Found results using: or logic [2024-04-16 15:43:21] [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-04-16 15:43:21] [query] Results: 1361 Pages of results: 137 [2024-04-16 15:43:21] [query] Execution time: 0.03605 [2024-04-16 15:47:00] [indexer:background] Health check [2024-04-16 15:47:00] [index:background] Health check [2024-04-16 15:49:20] [indexer:background] Health check [2024-04-16 15:50:55] [index:background] Health check [2024-04-16 15:54:21] [indexer:background] Health check [2024-04-16 15:55:32] [index:background] Health check [2024-04-16 15:59:16] [indexer:background] Health check [2024-04-16 16:00:11] [index:background] Health check [2024-04-16 16:04:17] [indexer:background] Health check [2024-04-16 16:05:10] [index:background] Health check [2024-04-16 16:10:38] [indexer:background] Health check [2024-04-16 16:10:39] [index:background] Health check [2024-04-16 16:15:06] [indexer:background] Health check [2024-04-16 16:15:50] [index:background] Health check [2024-04-16 16:21:05] [indexer:background] Health check [2024-04-16 16:21:05] [index:background] Health check [2024-04-16 16:24:27] [indexer:background] Health check [2024-04-16 16:25:19] [index:background] Health check [2024-04-16 16:29:48] [indexer:background] Health check [2024-04-16 16:30:41] [index:background] Health check [2024-04-16 16:34:17] [indexer:background] Health check [2024-04-16 16:35:11] [index:background] Health check [2024-04-16 16:39:17] [indexer:background] Health check [2024-04-16 16:40:10] [index:background] Health check [2024-04-16 16:40:15] [query] Query for: 2024 [2024-04-16 16:40:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 16:40:15] [query] Engine: default [2024-04-16 16:40:15] [query] Tokens: 2024 [2024-04-16 16:40:15] [query] Mods: 6 [2024-04-16 16:40:15] [query] Found results using: or logic [2024-04-16 16:40:15] [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-04-16 16:40:15] [query] Results: 150 Pages of results: 15 [2024-04-16 16:40:15] [query] Execution time: 0.03427 [2024-04-16 16:44:17] [indexer:background] Health check [2024-04-16 16:45:11] [index:background] Health check [2024-04-16 16:49:17] [indexer:background] Health check [2024-04-16 16:50:11] [index:background] Health check [2024-04-16 16:54:18] [indexer:background] Health check [2024-04-16 16:55:11] [index:background] Health check [2024-04-16 16:59:18] [indexer:background] Health check [2024-04-16 17:00:11] [index:background] Health check [2024-04-16 17:04:18] [indexer:background] Health check [2024-04-16 17:05:11] [index:background] Health check [2024-04-16 17:09:40] [indexer:background] Health check [2024-04-16 17:10:11] [index:background] Health check [2024-04-16 17:14:17] [indexer:background] Health check [2024-04-16 17:15:11] [index:background] Health check [2024-04-16 17:19:19] [indexer:background] Health check [2024-04-16 17:20:11] [index:background] Health check [2024-04-16 17:24:18] [indexer:background] Health check [2024-04-16 17:25:11] [index:background] Health check [2024-04-16 17:29:17] [indexer:background] Health check [2024-04-16 17:30:11] [index:background] Health check [2024-04-16 17:34:17] [indexer:background] Health check [2024-04-16 17:35:10] [index:background] Health check [2024-04-16 17:39:17] [indexer:background] Health check [2024-04-16 17:40:10] [index:background] Health check [2024-04-16 17:44:16] [indexer:background] Health check [2024-04-16 17:45:11] [index:background] Health check [2024-04-16 17:50:18] [indexer:background] Health check [2024-04-16 17:50:18] [index:background] Health check [2024-04-16 17:54:17] [indexer:background] Health check [2024-04-16 17:55:11] [index:background] Health check [2024-04-16 17:59:28] [indexer:background] Health check [2024-04-16 18:01:55] [index:background] Health check [2024-04-16 18:04:28] [indexer:background] Health check [2024-04-16 18:06:25] [index:background] Health check [2024-04-16 18:09:47] [indexer:background] Health check [2024-04-16 18:10:48] [index:background] Health check [2024-04-16 18:15:23] [indexer:background] Health check [2024-04-16 18:15:24] [index:background] Health check [2024-04-16 18:19:23] [indexer:background] Health check [2024-04-16 18:21:12] [index:background] Health check [2024-04-16 18:24:36] [indexer:background] Health check [2024-04-16 18:25:33] [index:background] Health check [2024-04-16 18:29:20] [indexer:background] Health check [2024-04-16 18:30:11] [index:background] Health check [2024-04-16 18:34:18] [indexer:background] Health check [2024-04-16 18:35:45] [index:background] Health check [2024-04-16 18:40:25] [indexer:background] Health check [2024-04-16 18:40:25] [index:background] Health check [2024-04-16 18:46:03] [indexer:background] Health check [2024-04-16 18:46:03] [index:background] Health check [2024-04-16 18:49:24] [indexer:background] Health check [2024-04-16 18:50:26] [index:background] Health check [2024-04-16 18:54:17] [indexer:background] Health check [2024-04-16 18:55:10] [index:background] Health check [2024-04-16 18:59:17] [indexer:background] Health check [2024-04-16 19:00:10] [index:background] Health check [2024-04-16 19:04:26] [indexer:background] Health check [2024-04-16 19:06:09] [index:background] Health check [2024-04-16 19:09:32] [indexer:background] Health check [2024-04-16 19:10:26] [index:background] Health check [2024-04-16 19:14:46] [indexer:background] Health check [2024-04-16 19:15:28] [index:background] Health check [2024-04-16 19:19:27] [indexer:background] Health check [2024-04-16 19:20:12] [index:background] Health check [2024-04-16 19:24:24] [indexer:background] Health check [2024-04-16 19:26:23] [index:background] Health check [2024-04-16 19:30:33] [indexer:background] Health check [2024-04-16 19:30:33] [index:background] Health check [2024-04-16 19:34:45] [indexer:background] Health check [2024-04-16 19:36:15] [index:background] Health check [2024-04-16 19:39:45] [indexer:background] Health check [2024-04-16 19:40:18] [index:background] Health check [2024-04-16 19:44:29] [indexer:background] Health check [2024-04-16 19:45:11] [index:background] Health check [2024-04-16 19:49:41] [indexer:background] Health check [2024-04-16 19:50:48] [index:background] Health check [2024-04-16 19:54:50] [indexer:background] Health check [2024-04-16 19:57:18] [index:background] Health check [2024-04-16 19:57:19] [index:background] Health check [2024-04-16 20:00:01] [indexer:background] Health check [2024-04-16 20:00:24] [index:background] Health check [2024-04-16 20:04:23] [indexer:background] Health check [2024-04-16 20:05:18] [index:background] Health check [2024-04-16 20:09:54] [indexer:background] Health check [2024-04-16 20:10:49] [index:background] Health check [2024-04-16 20:15:27] [indexer:background] Health check [2024-04-16 20:15:27] [index:background] Health check [2024-04-16 20:19:27] [indexer:background] Health check [2024-04-16 20:20:35] [index:background] Health check [2024-04-16 20:24:17] [indexer:background] Health check [2024-04-16 20:25:30] [index:background] Health check [2024-04-16 20:27:02] [query] Query for: 2024 [2024-04-16 20:27:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 20:27:02] [query] Engine: default [2024-04-16 20:27:03] [query] Tokens: 2024 [2024-04-16 20:27:03] [query] Mods: 6 [2024-04-16 20:27:03] [query] Found results using: or logic [2024-04-16 20:27:03] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-04-16 20:27:03] [query] Results: 150 Pages of results: 15 [2024-04-16 20:27:03] [query] Execution time: 0.96300 [2024-04-16 20:29:24] [indexer:background] Health check [2024-04-16 20:29:24] [indexer:background] CPU load threshold (3) breached: 8.11 [waiting 2] [2024-04-16 20:31:39] [index:background] Health check [2024-04-16 20:35:00] [indexer:background] Health check [2024-04-16 20:35:46] [index:background] Health check [2024-04-16 20:39:52] [indexer:background] Health check [2024-04-16 20:40:37] [index:background] Health check [2024-04-16 20:44:49] [indexer:background] Health check [2024-04-16 20:46:18] [index:background] Health check [2024-04-16 20:49:45] [indexer:background] Health check [2024-04-16 20:50:50] [index:background] Health check [2024-04-16 20:54:24] [indexer:background] Health check [2024-04-16 20:55:30] [index:background] Health check [2024-04-16 20:59:30] [indexer:background] Health check [2024-04-16 21:02:41] [index:background] Health check [2024-04-16 21:04:30] [indexer:background] Health check [2024-04-16 21:06:00] [index:background] Health check [2024-04-16 21:09:57] [indexer:background] Health check [2024-04-16 21:11:20] [index:background] Health check [2024-04-16 21:14:43] [indexer:background] Health check [2024-04-16 21:15:45] [index:background] Health check [2024-04-16 21:19:43] [indexer:background] Health check [2024-04-16 21:20:11] [index:background] Health check [2024-04-16 21:24:23] [indexer:background] Health check [2024-04-16 21:25:27] [index:background] Health check [2024-04-16 21:30:12] [indexer:background] Health check [2024-04-16 21:30:12] [index:background] Health check [2024-04-16 21:35:18] [indexer:background] Health check [2024-04-16 21:35:18] [index:background] Health check [2024-04-16 21:39:39] [indexer:background] Health check [2024-04-16 21:41:40] [index:background] Health check [2024-04-16 21:45:16] [indexer:background] Health check [2024-04-16 21:45:16] [index:background] Health check [2024-04-16 21:49:28] [indexer:background] Health check [2024-04-16 21:50:48] [index:background] Health check [2024-04-16 21:54:20] [indexer:background] Health check [2024-04-16 21:55:43] [index:background] Health check [2024-04-16 21:59:42] [indexer:background] Health check [2024-04-16 22:00:37] [index:background] Health check [2024-04-16 22:04:36] [indexer:background] Health check [2024-04-16 22:04:37] [query] Query for: 2023 [2024-04-16 22:04:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-16 22:04:37] [query] Engine: default [2024-04-16 22:04:37] [query] Tokens: 2023 [2024-04-16 22:04:37] [query] Mods: 6 [2024-04-16 22:04:37] [query] Found results using: or logic [2024-04-16 22:04:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-16 22:04:37] [query] Results: 273 Pages of results: 28 [2024-04-16 22:04:37] [query] Execution time: 0.83166 [2024-04-16 22:04:37] [query] Query for: 2023 [2024-04-16 22:04:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-04-16 22:04:37] [query] Engine: default [2024-04-16 22:04:37] [query] Tokens: 2023 [2024-04-16 22:04:37] [query] Mods: 6 [2024-04-16 22:04:38] [query] Found results using: or logic [2024-04-16 22:04:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100 [2024-04-16 22:04:38] [query] Results: 273 Pages of results: 3 [2024-04-16 22:04:38] [query] Execution time: 0.07606 [2024-04-16 22:05:09] [index:background] Health check [2024-04-16 22:09:31] [indexer:background] Health check [2024-04-16 22:11:51] [index:background] Health check [2024-04-16 22:14:29] [indexer:background] Health check [2024-04-16 22:15:39] [index:background] Health check [2024-04-16 22:15:39] [index:background] Health check [2024-04-16 22:19:26] [indexer:background] Health check [2024-04-16 22:20:11] [index:background] Health check [2024-04-16 22:24:25] [indexer:background] Health check [2024-04-16 22:25:51] [index:background] Health check [2024-04-16 22:29:17] [indexer:background] Health check [2024-04-16 22:30:14] [index:background] Health check [2024-04-16 22:34:17] [indexer:background] Health check [2024-04-16 22:35:37] [index:background] Health check [2024-04-16 22:39:44] [indexer:background] Health check [2024-04-16 22:40:12] [index:background] Health check [2024-04-16 22:44:54] [indexer:background] Health check [2024-04-16 22:45:28] [index:background] Health check [2024-04-16 22:49:59] [indexer:background] Health check [2024-04-16 22:51:02] [index:background] Health check [2024-04-16 22:54:31] [indexer:background] Health check [2024-04-16 22:56:22] [index:background] Health check [2024-04-16 22:59:54] [indexer:background] Health check [2024-04-16 23:01:36] [index:background] Health check [2024-04-16 23:04:57] [indexer:background] Health check [2024-04-16 23:05:29] [index:background] Health check [2024-04-16 23:09:35] [indexer:background] Health check [2024-04-16 23:13:35] [index:background] Health check [2024-04-16 23:15:31] [indexer:background] Health check [2024-04-16 23:15:31] [index:background] Health check [2024-04-16 23:19:40] [indexer:background] Health check [2024-04-16 23:21:44] [index:background] Health check [2024-04-16 23:24:28] [indexer:background] Health check [2024-04-16 23:25:13] [index:background] Health check [2024-04-16 23:29:17] [indexer:background] Health check [2024-04-16 23:30:13] [index:background] Health check [2024-04-16 23:34:44] [indexer:background] Health check [2024-04-16 23:35:13] [index:background] Health check [2024-04-16 23:39:29] [indexer:background] Health check [2024-04-16 23:40:56] [index:background] Health check [2024-04-16 23:44:50] [indexer:background] Health check [2024-04-16 23:44:50] [indexer:background] CPU load threshold (3) breached: 4.06 [waiting 2] [2024-04-16 23:45:41] [index:background] Health check [2024-04-16 23:49:16] [indexer:background] Health check [2024-04-16 23:51:16] [index:background] Health check [2024-04-16 23:54:51] [indexer:background] Health check [2024-04-16 23:55:29] [index:background] Health check [2024-04-16 23:59:59] [indexer:background] Health check