[2023-10-12 00:01:17] [index:background] Health check [2023-10-12 00:02:31] [indexer:background] Health check [2023-10-12 00:02:31] [index:background] Health check [2023-10-12 00:07:56] [indexer:background] Health check [2023-10-12 00:07:56] [index:background] Health check [2023-10-12 00:12:09] [indexer:background] Health check [2023-10-12 00:12:27] [index:background] Health check [2023-10-12 00:17:38] [indexer:background] Health check [2023-10-12 00:17:39] [index:background] Health check [2023-10-12 00:21:54] [indexer:background] Health check [2023-10-12 00:23:23] [index:background] Health check [2023-10-12 00:26:44] [indexer:background] Health check [2023-10-12 00:27:22] [index:background] Health check [2023-10-12 00:32:54] [indexer:background] Health check [2023-10-12 00:32:54] [index:background] Health check [2023-10-12 00:37:07] [indexer:background] Health check [2023-10-12 00:38:29] [index:background] Health check [2023-10-12 00:42:12] [indexer:background] Health check [2023-10-12 00:42:13] [index:background] Health check [2023-10-12 00:43:22] [query] Query for: 2024 [2023-10-12 00:43:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 00:43:22] [query] Engine: default [2023-10-12 00:43:23] [query] Tokens: 2024 [2023-10-12 00:43:23] [query] Mods: 6 [2023-10-12 00:43:23] [query] Found results using: or logic [2023-10-12 00:43:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 00:43:23] [query] Results: 128 Pages of results: 13 [2023-10-12 00:43:23] [query] Execution time: 0.64076 [2023-10-12 00:46:59] [indexer:background] Health check [2023-10-12 00:48:16] [index:background] Health check [2023-10-12 00:52:29] [indexer:background] Health check [2023-10-12 00:52:29] [index:background] Health check [2023-10-12 00:56:53] [indexer:background] Health check [2023-10-12 00:57:56] [index:background] Health check [2023-10-12 01:02:06] [indexer:background] Health check [2023-10-12 01:02:11] [index:background] Health check [2023-10-12 01:07:42] [indexer:background] Health check [2023-10-12 01:07:42] [index:background] Health check [2023-10-12 01:11:53] [indexer:background] Health check [2023-10-12 01:13:15] [index:background] Health check [2023-10-12 01:17:10] [indexer:background] Health check [2023-10-12 01:17:10] [index:background] Health check [2023-10-12 01:23:00] [indexer:background] Health check [2023-10-12 01:23:00] [index:background] Health check [2023-10-12 01:27:11] [indexer:background] Health check [2023-10-12 01:27:11] [index:background] Health check [2023-10-12 01:32:19] [indexer:background] Health check [2023-10-12 01:32:19] [index:background] Health check [2023-10-12 01:36:52] [indexer:background] Health check [2023-10-12 01:38:16] [index:background] Health check [2023-10-12 01:43:09] [indexer:background] Health check [2023-10-12 01:43:09] [index:background] Health check [2023-10-12 01:47:04] [indexer:background] Health check [2023-10-12 01:47:12] [index:background] Health check [2023-10-12 01:52:38] [indexer:background] Health check [2023-10-12 01:52:38] [index:background] Health check [2023-10-12 01:58:01] [indexer:background] Health check [2023-10-12 01:58:01] [index:background] Health check [2023-10-12 02:03:03] [indexer:background] Health check [2023-10-12 02:03:03] [index:background] Health check [2023-10-12 02:08:48] [indexer:background] Health check [2023-10-12 02:08:48] [index:background] Health check [2023-10-12 02:11:50] [indexer:background] Health check [2023-10-12 02:13:11] [index:background] Health check [2023-10-12 02:18:01] [indexer:background] Health check [2023-10-12 02:18:01] [index:background] Health check [2023-10-12 02:23:58] [indexer:background] Health check [2023-10-12 02:23:58] [index:background] Health check [2023-10-12 02:29:38] [indexer:background] Health check [2023-10-12 02:29:38] [index:background] Health check [2023-10-12 02:31:50] [indexer:background] Health check [2023-10-12 02:36:43] [index:background] Health check [2023-10-12 02:36:43] [indexer:background] Health check [2023-10-12 02:36:43] [indexer:background] Health check [2023-10-12 02:38:09] [index:background] Health check [2023-10-12 02:42:44] [indexer:background] Health check [2023-10-12 02:42:44] [index:background] Health check [2023-10-12 02:46:54] [indexer:background] Health check [2023-10-12 02:48:12] [index:background] Health check [2023-10-12 02:52:50] [indexer:background] Health check [2023-10-12 02:52:50] [index:background] Health check [2023-10-12 02:57:14] [indexer:background] Health check [2023-10-12 02:57:14] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-12 02:57:16] [index:background] Health check [2023-10-12 02:57:16] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-10-12 02:57:18] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-10-12 03:04:00] [indexer:background] Health check [2023-10-12 03:04:01] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-10-12 03:04:03] [index:background] Health check [2023-10-12 03:04:03] [index:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-10-12 03:04:05] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-10-12 03:06:44] [indexer:background] Health check [2023-10-12 03:06:44] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-10-12 03:11:04] [index:background] Health check [2023-10-12 03:11:04] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-10-12 03:11:06] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-12 03:12:20] [indexer:background] Health check [2023-10-12 03:12:20] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2] [2023-10-12 03:12:22] [index:background] Health check [2023-10-12 03:12:22] [index:background] CPU load threshold (3) breached: 3.76 [waiting 2] [2023-10-12 03:12:24] [indexer:background] CPU load threshold (3) breached: 3.76 [waiting 2] [2023-10-12 03:17:27] [indexer:background] Health check [2023-10-12 03:17:27] [index:background] Health check [2023-10-12 03:22:14] [indexer:background] Health check [2023-10-12 03:22:14] [index:background] Health check [2023-10-12 03:26:41] [indexer:background] Health check [2023-10-12 03:27:36] [index:background] Health check [2023-10-12 03:31:44] [indexer:background] Health check [2023-10-12 03:34:55] [index:background] Health check [2023-10-12 03:36:54] [indexer:background] Health check [2023-10-12 03:38:11] [index:background] Health check [2023-10-12 03:42:00] [indexer:background] Health check [2023-10-12 03:43:15] [index:background] Health check [2023-10-12 03:47:45] [indexer:background] Health check [2023-10-12 03:47:45] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2] [2023-10-12 03:47:47] [index:background] Health check [2023-10-12 03:47:47] [index:background] CPU load threshold (3) breached: 3.42 [waiting 2] [2023-10-12 03:47:49] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2] [2023-10-12 03:54:04] [indexer:background] Health check [2023-10-12 03:54:04] [index:background] Health check [2023-10-12 03:56:44] [indexer:background] Health check [2023-10-12 03:57:14] [index:background] Health check [2023-10-12 04:02:55] [indexer:background] Health check [2023-10-12 04:02:55] [index:background] Health check [2023-10-12 04:08:23] [indexer:background] Health check [2023-10-12 04:08:23] [index:background] Health check [2023-10-12 04:11:40] [indexer:background] Health check [2023-10-12 04:12:13] [index:background] Health check [2023-10-12 04:16:41] [indexer:background] Health check [2023-10-12 04:17:16] [index:background] Health check [2023-10-12 04:22:37] [indexer:background] Health check [2023-10-12 04:22:37] [index:background] Health check [2023-10-12 04:26:55] [indexer:background] Health check [2023-10-12 04:27:54] [index:background] Health check [2023-10-12 04:31:41] [indexer:background] Health check [2023-10-12 04:32:25] [index:background] Health check [2023-10-12 04:36:44] [indexer:background] Health check [2023-10-12 04:37:15] [index:background] Health check [2023-10-12 04:43:48] [indexer:background] Health check [2023-10-12 04:43:48] [index:background] Health check [2023-10-12 04:47:04] [indexer:background] Health check [2023-10-12 04:47:15] [index:background] Health check [2023-10-12 04:52:08] [indexer:background] Health check [2023-10-12 04:53:04] [index:background] Health check [2023-10-12 04:57:12] [indexer:background] Health check [2023-10-12 04:57:12] [index:background] Health check [2023-10-12 05:01:56] [indexer:background] Health check [2023-10-12 05:04:13] [index:background] Health check [2023-10-12 05:08:53] [indexer:background] Health check [2023-10-12 05:08:53] [index:background] Health check [2023-10-12 05:11:49] [indexer:background] Health check [2023-10-12 05:12:42] [index:background] Health check [2023-10-12 05:17:36] [indexer:background] Health check [2023-10-12 05:17:36] [index:background] Health check [2023-10-12 05:22:42] [indexer:background] Health check [2023-10-12 05:22:42] [index:background] Health check [2023-10-12 05:27:45] [indexer:background] Health check [2023-10-12 05:27:45] [index:background] Health check [2023-10-12 05:32:21] [indexer:background] Health check [2023-10-12 05:32:21] [index:background] Health check [2023-10-12 05:37:47] [indexer:background] Health check [2023-10-12 05:37:48] [index:background] Health check [2023-10-12 05:41:43] [query] Query for: {search_term_string} [2023-10-12 05:41:43] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 05:41:43] [query] Engine: default [2023-10-12 05:41:44] [indexer:background] Health check [2023-10-12 05:41:44] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-12 05:41:44] [query] Mods: 6 [2023-10-12 05:41:44] [query] Using OR logic [2023-10-12 05:41:45] [query] Found results using: or logic [2023-10-12 05:41:45] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 05:41:45] [query] Results: 1343 Pages of results: 135 [2023-10-12 05:41:45] [query] Execution time: 1.64827 [2023-10-12 05:42:47] [index:background] Health check [2023-10-12 05:46:47] [indexer:background] Health check [2023-10-12 05:47:14] [index:background] Health check [2023-10-12 05:51:45] [indexer:background] Health check [2023-10-12 05:52:50] [index:background] Health check [2023-10-12 05:52:51] [query] Query for: {search_term_string} [2023-10-12 05:52:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 05:52:51] [query] Engine: default [2023-10-12 05:52:51] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-12 05:52:51] [query] Mods: 6 [2023-10-12 05:52:51] [query] Using OR logic [2023-10-12 05:52:51] [query] Found results using: or logic [2023-10-12 05:52: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 0, 10 [2023-10-12 05:52:51] [query] Results: 1343 Pages of results: 135 [2023-10-12 05:52:51] [query] Execution time: 0.03966 [2023-10-12 05:57:15] [indexer:background] Health check [2023-10-12 05:57:15] [index:background] Health check [2023-10-12 06:02:49] [indexer:background] Health check [2023-10-12 06:02:49] [index:background] Health check [2023-10-12 06:06:48] [indexer:background] Health check [2023-10-12 06:08:12] [index:background] Health check [2023-10-12 06:12:03] [indexer:background] Health check [2023-10-12 06:12:33] [index:background] Health check [2023-10-12 06:16:51] [indexer:background] Health check [2023-10-12 06:18:09] [index:background] Health check [2023-10-12 06:22:15] [indexer:background] Health check [2023-10-12 06:22:16] [index:background] Health check [2023-10-12 06:26:55] [indexer:background] Health check [2023-10-12 06:27:50] [index:background] Health check [2023-10-12 06:32:00] [indexer:background] Health check [2023-10-12 06:32:19] [index:background] Health check [2023-10-12 06:36:49] [indexer:background] Health check [2023-10-12 06:37:37] [index:background] Health check [2023-10-12 06:41:41] [indexer:background] Health check [2023-10-12 06:42:17] [index:background] Health check [2023-10-12 06:47:11] [indexer:background] Health check [2023-10-12 06:47:12] [index:background] Health check [2023-10-12 06:51:42] [indexer:background] Health check [2023-10-12 06:52:51] [index:background] Health check [2023-10-12 06:57:01] [indexer:background] Health check [2023-10-12 06:58:30] [index:background] Health check [2023-10-12 07:02:03] [indexer:background] Health check [2023-10-12 07:02:38] [index:background] Health check [2023-10-12 07:06:46] [indexer:background] Health check [2023-10-12 07:08:04] [index:background] Health check [2023-10-12 07:12:46] [indexer:background] Health check [2023-10-12 07:12:46] [index:background] Health check [2023-10-12 07:16:55] [indexer:background] Health check [2023-10-12 07:17:21] [index:background] Health check [2023-10-12 07:22:05] [indexer:background] Health check [2023-10-12 07:24:07] [index:background] Health check [2023-10-12 07:27:09] [indexer:background] Health check [2023-10-12 07:28:08] [index:background] Health check [2023-10-12 07:32:11] [indexer:background] Health check [2023-10-12 07:32:11] [index:background] Health check [2023-10-12 07:37:23] [indexer:background] Health check [2023-10-12 07:37:23] [index:background] Health check [2023-10-12 07:42:16] [indexer:background] Health check [2023-10-12 07:42:16] [index:background] Health check [2023-10-12 07:47:07] [indexer:background] Health check [2023-10-12 07:47:07] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-12 07:47:14] [index:background] Health check [2023-10-12 07:47:15] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2023-10-12 07:47:17] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2023-10-12 07:51:44] [indexer:background] Health check [2023-10-12 07:52:21] [index:background] Health check [2023-10-12 07:57:08] [indexer:background] Health check [2023-10-12 07:58:23] [index:background] Health check [2023-10-12 08:01:47] [indexer:background] Health check [2023-10-12 08:02:25] [index:background] Health check [2023-10-12 08:02:30] [query] Query for: {search_term_string} [2023-10-12 08:02:30] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 132 offset: 0 fields: all [2023-10-12 08:02:30] [query] Engine: default [2023-10-12 08:02:30] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-12 08:02:30] [query] Mods: 6 [2023-10-12 08:02:30] [query] Using OR logic [2023-10-12 08:02:31] [query] Found results using: or logic [2023-10-12 08:02:31] [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 1310, 10 [2023-10-12 08:02:31] [query] Results: 1343 Pages of results: 135 [2023-10-12 08:02:31] [query] Execution time: 0.83963 [2023-10-12 08:08:29] [indexer:background] Health check [2023-10-12 08:08:29] [index:background] Health check [2023-10-12 08:12:43] [indexer:background] Health check [2023-10-12 08:12:43] [indexer:background] CPU load threshold (3) breached: 4.21 [waiting 2] [2023-10-12 08:12:45] [index:background] Health check [2023-10-12 08:12:45] [index:background] CPU load threshold (3) breached: 4.52 [waiting 2] [2023-10-12 08:12:47] [indexer:background] CPU load threshold (3) breached: 4.52 [waiting 2] [2023-10-12 08:16:46] [indexer:background] Health check [2023-10-12 08:16:46] [indexer:background] CPU load threshold (3) breached: 4.1 [waiting 2] [2023-10-12 08:17:17] [index:background] Health check [2023-10-12 08:17:17] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-10-12 08:17:19] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-10-12 08:21:44] [indexer:background] Health check [2023-10-12 08:21:44] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-12 08:22:29] [index:background] Health check [2023-10-12 08:22:29] [index:background] CPU load threshold (3) breached: 3.43 [waiting 2] [2023-10-12 08:22:31] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-10-12 08:26:56] [indexer:background] Health check [2023-10-12 08:26:56] [indexer:background] CPU load threshold (3) breached: 7.05 [waiting 2] [2023-10-12 08:27:13] [index:background] Health check [2023-10-12 08:27:13] [index:background] CPU load threshold (3) breached: 7.44 [waiting 2] [2023-10-12 08:27:14] [index:background] Health check [2023-10-12 08:27:15] [index:background] CPU load threshold (3) breached: 7.24 [waiting 2] [2023-10-12 08:27:16] [indexer:background] CPU load threshold (3) breached: 7.24 [waiting 2] [2023-10-12 08:27:18] [indexer:background] CPU load threshold (3) breached: 7.24 [waiting 2] [2023-10-12 08:32:27] [indexer:background] Health check [2023-10-12 08:32:27] [indexer:background] CPU load threshold (3) breached: 3.93 [waiting 2] [2023-10-12 08:32:29] [index:background] Health check [2023-10-12 08:32:29] [index:background] CPU load threshold (3) breached: 3.93 [waiting 2] [2023-10-12 08:32:31] [indexer:background] CPU load threshold (3) breached: 3.93 [waiting 2] [2023-10-12 08:36:49] [indexer:background] Health check [2023-10-12 08:37:16] [index:background] Health check [2023-10-12 08:37:16] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-12 08:37:18] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-10-12 08:42:01] [indexer:background] Health check [2023-10-12 08:42:01] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-10-12 08:42:47] [index:background] Health check [2023-10-12 08:46:51] [indexer:background] Health check [2023-10-12 08:48:05] [index:background] Health check [2023-10-12 08:52:27] [indexer:background] Health check [2023-10-12 08:52:27] [index:background] Health check [2023-10-12 08:56:43] [indexer:background] Health check [2023-10-12 08:57:58] [index:background] Health check [2023-10-12 08:57:58] [index:background] CPU load threshold (3) breached: 3.85 [waiting 2] [2023-10-12 08:58:00] [indexer:background] CPU load threshold (3) breached: 3.85 [waiting 2] [2023-10-12 09:02:09] [indexer:background] Health check [2023-10-12 09:02:30] [index:background] Health check [2023-10-12 09:02:30] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-10-12 09:06:41] [indexer:background] Health check [2023-10-12 09:06:41] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2] [2023-10-12 09:08:57] [index:background] Health check [2023-10-12 09:08:57] [index:background] CPU load threshold (3) breached: 3.82 [waiting 2] [2023-10-12 09:08:59] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2023-10-12 09:12:00] [indexer:background] Health check [2023-10-12 09:12:00] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-10-12 09:12:41] [index:background] Health check [2023-10-12 09:12:41] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-10-12 09:12:43] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-10-12 09:17:01] [indexer:background] Health check [2023-10-12 09:17:01] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2023-10-12 09:17:19] [index:background] Health check [2023-10-12 09:17:19] [index:background] CPU load threshold (3) breached: 4.04 [waiting 2] [2023-10-12 09:17:21] [indexer:background] CPU load threshold (3) breached: 4.04 [waiting 2] [2023-10-12 09:21:41] [indexer:background] Health check [2023-10-12 09:21:41] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2023-10-12 09:22:12] [index:background] Health check [2023-10-12 09:22:12] [index:background] CPU load threshold (3) breached: 3.77 [waiting 2] [2023-10-12 09:22:14] [indexer:background] CPU load threshold (3) breached: 3.47 [waiting 2] [2023-10-12 09:26:41] [indexer:background] Health check [2023-10-12 09:26:41] [indexer:background] CPU load threshold (3) breached: 3.97 [waiting 2] [2023-10-12 09:29:00] [index:background] Health check [2023-10-12 09:29:00] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-10-12 09:29:01] [index:background] Health check [2023-10-12 09:29:02] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-10-12 09:29:02] [indexer:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-10-12 09:29:04] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2] [2023-10-12 09:31:58] [indexer:background] Health check [2023-10-12 09:31:58] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-10-12 09:32:13] [index:background] Health check [2023-10-12 09:32:13] [index:background] CPU load threshold (3) breached: 4.04 [waiting 2] [2023-10-12 09:32:15] [indexer:background] CPU load threshold (3) breached: 4.44 [waiting 2] [2023-10-12 09:36:49] [indexer:background] Health check [2023-10-12 09:37:12] [index:background] Health check [2023-10-12 09:43:14] [indexer:background] Health check [2023-10-12 09:43:14] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-10-12 09:43:16] [index:background] Health check [2023-10-12 09:43:16] [index:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2023-10-12 09:43:18] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2023-10-12 09:48:33] [indexer:background] Health check [2023-10-12 09:48:33] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2] [2023-10-12 09:48:35] [index:background] Health check [2023-10-12 09:48:35] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 09:48:37] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 09:52:20] [indexer:background] Health check [2023-10-12 09:52:20] [index:background] Health check [2023-10-12 09:56:43] [indexer:background] Health check [2023-10-12 09:57:40] [index:background] Health check [2023-10-12 10:01:42] [indexer:background] Health check [2023-10-12 10:02:41] [index:background] Health check [2023-10-12 10:07:23] [indexer:background] Health check [2023-10-12 10:07:23] [index:background] Health check [2023-10-12 10:11:57] [indexer:background] Health check [2023-10-12 10:13:36] [index:background] Health check [2023-10-12 10:17:58] [indexer:background] Health check [2023-10-12 10:17:58] [index:background] Health check [2023-10-12 10:22:32] [indexer:background] Health check [2023-10-12 10:22:32] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-10-12 10:22:34] [index:background] Health check [2023-10-12 10:22:34] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-10-12 10:26:46] [indexer:background] Health check [2023-10-12 10:27:58] [index:background] Health check [2023-10-12 10:31:59] [indexer:background] Health check [2023-10-12 10:33:51] [index:background] Health check [2023-10-12 10:37:44] [indexer:background] Health check [2023-10-12 10:37:44] [index:background] Health check [2023-10-12 10:42:19] [indexer:background] Health check [2023-10-12 10:42:19] [index:background] Health check [2023-10-12 10:46:56] [indexer:background] Health check [2023-10-12 10:47:37] [index:background] Health check [2023-10-12 10:51:43] [indexer:background] Health check [2023-10-12 10:52:57] [index:background] Health check [2023-10-12 10:56:39] [indexer:background] Health check [2023-10-12 10:56:39] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-12 10:57:17] [index:background] Health check [2023-10-12 11:01:41] [indexer:background] Health check [2023-10-12 11:02:47] [index:background] Health check [2023-10-12 11:06:42] [indexer:background] Health check [2023-10-12 11:07:50] [index:background] Health check [2023-10-12 11:13:00] [indexer:background] Health check [2023-10-12 11:13:01] [index:background] Health check [2023-10-12 11:19:50] [indexer:background] Health check [2023-10-12 11:19:50] [index:background] Health check [2023-10-12 11:22:16] [indexer:background] Health check [2023-10-12 11:22:16] [index:background] Health check [2023-10-12 11:27:22] [indexer:background] Health check [2023-10-12 11:27:22] [index:background] Health check [2023-10-12 11:31:23] [query] Query for: drou.cn [2023-10-12 11:31:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 11:31:23] [query] Engine: default [2023-10-12 11:31:23] [query] Query for: drou.cn [2023-10-12 11:31:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 11:31:23] [query] Engine: default [2023-10-12 11:31:23] [query] Tokens: drou drou.cn [2023-10-12 11:31:23] [query] Tokens: drou drou.cn [2023-10-12 11:31:23] [query] Mods: 6 [2023-10-12 11:31:23] [query] Mods: 6 [2023-10-12 11:31:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 11:31:23] [query] Results: 0 Pages of results: 0 [2023-10-12 11:31:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 11:31:23] [query] Results: 0 Pages of results: 0 [2023-10-12 11:31:23] [query] Execution time: 0.22192 [2023-10-12 11:31:23] [query] Execution time: 0.22898 [2023-10-12 11:32:07] [indexer:background] Health check [2023-10-12 11:32:23] [index:background] Health check [2023-10-12 11:36:46] [indexer:background] Health check [2023-10-12 11:40:00] [index:background] Health check [2023-10-12 11:41:41] [indexer:background] Health check [2023-10-12 11:42:20] [index:background] Health check [2023-10-12 11:46:44] [indexer:background] Health check [2023-10-12 11:47:35] [index:background] Health check [2023-10-12 11:47:35] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-10-12 11:47:37] [indexer:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-10-12 11:52:35] [indexer:background] Health check [2023-10-12 11:52:35] [index:background] Health check [2023-10-12 11:56:51] [indexer:background] Health check [2023-10-12 11:57:38] [index:background] Health check [2023-10-12 12:04:19] [indexer:background] Health check [2023-10-12 12:04:19] [index:background] Health check [2023-10-12 12:07:01] [indexer:background] Health check [2023-10-12 12:08:27] [index:background] Health check [2023-10-12 12:12:37] [indexer:background] Health check [2023-10-12 12:12:37] [index:background] Health check [2023-10-12 12:17:07] [indexer:background] Health check [2023-10-12 12:17:07] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2] [2023-10-12 12:17:27] [index:background] Health check [2023-10-12 12:17:27] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 12:17:30] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 12:21:59] [indexer:background] Health check [2023-10-12 12:23:58] [index:background] Health check [2023-10-12 12:27:01] [indexer:background] Health check [2023-10-12 12:28:15] [index:background] Health check [2023-10-12 12:28:15] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-10-12 12:28:17] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-10-12 12:31:43] [indexer:background] Health check [2023-10-12 12:32:19] [index:background] Health check [2023-10-12 12:36:47] [indexer:background] Health check [2023-10-12 12:36:47] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2] [2023-10-12 12:37:48] [index:background] Health check [2023-10-12 12:42:50] [indexer:background] Health check [2023-10-12 12:42:50] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-12 12:42:52] [index:background] Health check [2023-10-12 12:42:52] [index:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-12 12:42:54] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-12 12:47:06] [indexer:background] Health check [2023-10-12 12:47:06] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2] [2023-10-12 12:48:34] [index:background] Health check [2023-10-12 12:48:34] [index:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-12 12:48:36] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-12 12:52:45] [indexer:background] Health check [2023-10-12 12:52:45] [index:background] Health check [2023-10-12 12:58:45] [indexer:background] Health check [2023-10-12 12:58:45] [index:background] Health check [2023-10-12 13:02:12] [indexer:background] Health check [2023-10-12 13:02:12] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-12 13:02:14] [index:background] Health check [2023-10-12 13:07:37] [indexer:background] Health check [2023-10-12 13:07:37] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-12 13:07:39] [index:background] Health check [2023-10-12 13:07:39] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-10-12 13:07:41] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-10-12 13:11:49] [indexer:background] Health check [2023-10-12 13:11:49] [indexer:background] CPU load threshold (3) breached: 4.32 [waiting 2] [2023-10-12 13:19:12] [index:background] Health check [2023-10-12 13:19:12] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-12 13:19:14] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-12 13:19:16] [indexer:background] Health check [2023-10-12 13:19:16] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 13:19:18] [indexer:background] Health check [2023-10-12 13:19:18] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 13:23:04] [indexer:background] Health check [2023-10-12 13:23:04] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2023-10-12 13:23:06] [index:background] Health check [2023-10-12 13:23:06] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-10-12 13:23:08] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-10-12 13:28:02] [indexer:background] Health check [2023-10-12 13:28:02] [index:background] Health check [2023-10-12 13:34:32] [indexer:background] Health check [2023-10-12 13:34:32] [index:background] Health check [2023-10-12 13:36:48] [indexer:background] Health check [2023-10-12 13:36:48] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-10-12 13:38:52] [index:background] Health check [2023-10-12 13:45:16] [indexer:background] Health check [2023-10-12 13:45:16] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-12 13:45:18] [index:background] Health check [2023-10-12 13:45:18] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-12 13:45:20] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-12 13:47:07] [indexer:background] Health check [2023-10-12 13:47:07] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-10-12 13:47:30] [index:background] Health check [2023-10-12 13:47:30] [index:background] CPU load threshold (3) breached: 3.06 [waiting 2] [2023-10-12 13:47:32] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2] [2023-10-12 13:51:42] [indexer:background] Health check [2023-10-12 13:52:16] [index:background] Health check [2023-10-12 13:52:16] [index:background] CPU load threshold (3) breached: 3.66 [waiting 2] [2023-10-12 13:52:18] [indexer:background] CPU load threshold (3) breached: 3.66 [waiting 2] [2023-10-12 13:56:44] [indexer:background] Health check [2023-10-12 13:57:27] [index:background] Health check [2023-10-12 14:02:02] [indexer:background] Health check [2023-10-12 14:02:02] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-10-12 14:03:02] [index:background] Health check [2023-10-12 14:03:02] [index:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-10-12 14:03:04] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-10-12 14:07:40] [indexer:background] Health check [2023-10-12 14:07:40] [index:background] Health check [2023-10-12 14:12:31] [indexer:background] Health check [2023-10-12 14:12:31] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2] [2023-10-12 14:12:33] [index:background] Health check [2023-10-12 14:16:56] [indexer:background] Health check [2023-10-12 14:16:56] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-12 14:17:15] [index:background] Health check [2023-10-12 14:17:15] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 14:17:17] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-10-12 14:21:41] [indexer:background] Health check [2023-10-12 14:21:41] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2] [2023-10-12 14:22:41] [index:background] Health check [2023-10-12 14:22:41] [index:background] CPU load threshold (3) breached: 3.83 [waiting 2] [2023-10-12 14:22:43] [indexer:background] CPU load threshold (3) breached: 3.92 [waiting 2] [2023-10-12 14:27:15] [indexer:background] Health check [2023-10-12 14:27:16] [index:background] Health check [2023-10-12 14:32:46] [indexer:background] Health check [2023-10-12 14:32:46] [index:background] Health check [2023-10-12 14:36:39] [indexer:background] Health check [2023-10-12 14:37:32] [index:background] Health check [2023-10-12 14:41:43] [indexer:background] Health check [2023-10-12 14:42:11] [index:background] Health check [2023-10-12 14:46:54] [indexer:background] Health check [2023-10-12 14:46:54] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2] [2023-10-12 14:47:15] [index:background] Health check [2023-10-12 14:47:15] [index:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-10-12 14:47:17] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-10-12 14:51:41] [indexer:background] Health check [2023-10-12 14:53:11] [index:background] Health check [2023-10-12 14:57:05] [indexer:background] Health check [2023-10-12 14:57:05] [indexer:background] CPU load threshold (3) breached: 4.7 [waiting 2] [2023-10-12 14:58:01] [index:background] Health check [2023-10-12 14:58:01] [index:background] CPU load threshold (3) breached: 3.24 [waiting 2] [2023-10-12 14:58:03] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2] [2023-10-12 15:03:00] [indexer:background] Health check [2023-10-12 15:03:01] [index:background] Health check [2023-10-12 15:10:14] [indexer:background] Health check [2023-10-12 15:10:14] [index:background] Health check [2023-10-12 15:13:23] [indexer:background] Health check [2023-10-12 15:13:23] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-10-12 15:13:25] [index:background] Health check [2023-10-12 15:13:25] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-10-12 15:13:27] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-10-12 15:17:42] [indexer:background] Health check [2023-10-12 15:17:42] [index:background] Health check [2023-10-12 15:22:42] [indexer:background] Health check [2023-10-12 15:22:42] [index:background] Health check [2023-10-12 15:27:38] [indexer:background] Health check [2023-10-12 15:27:38] [index:background] Health check [2023-10-12 15:31:46] [indexer:background] Health check [2023-10-12 15:32:14] [index:background] Health check [2023-10-12 15:37:36] [indexer:background] Health check [2023-10-12 15:37:36] [index:background] Health check [2023-10-12 15:41:51] [indexer:background] Health check [2023-10-12 15:42:19] [index:background] Health check [2023-10-12 15:47:01] [indexer:background] Health check [2023-10-12 15:47:28] [index:background] Health check [2023-10-12 15:51:53] [indexer:background] Health check [2023-10-12 15:52:24] [index:background] Health check [2023-10-12 15:56:43] [indexer:background] Health check [2023-10-12 15:58:27] [index:background] Health check [2023-10-12 16:01:55] [indexer:background] Health check [2023-10-12 16:03:10] [index:background] Health check [2023-10-12 16:09:05] [indexer:background] Health check [2023-10-12 16:09:05] [index:background] Health check [2023-10-12 16:12:02] [indexer:background] Health check [2023-10-12 16:12:12] [index:background] Health check [2023-10-12 16:17:13] [indexer:background] Health check [2023-10-12 16:17:13] [index:background] Health check [2023-10-12 16:18:25] [indexer:background] Health check [2023-10-12 16:18:25] [index:background] Health check [2023-10-12 16:21:41] [indexer:background] Health check [2023-10-12 16:21:41] [index] Marking post.page 13826 to be dropped [2023-10-12 16:21:44] [index] Dropping post.page 13826 [2023-10-12 16:21:44] [indexer] Index built [2023-10-12 16:22:25] [index:background] Health check [2023-10-12 16:26:45] [indexer:background] Health check [2023-10-12 16:27:45] [index:background] Health check [2023-10-12 16:33:03] [indexer:background] Health check [2023-10-12 16:33:03] [index:background] Health check [2023-10-12 16:37:01] [indexer:background] Health check [2023-10-12 16:38:55] [index:background] Health check [2023-10-12 16:42:00] [indexer:background] Health check [2023-10-12 16:43:27] [index:background] Health check [2023-10-12 16:46:47] [indexer:background] Health check [2023-10-12 16:47:27] [index:background] Health check [2023-10-12 16:51:58] [indexer:background] Health check [2023-10-12 16:52:45] [index:background] Health check [2023-10-12 16:57:05] [indexer:background] Health check [2023-10-12 16:57:22] [index:background] Health check [2023-10-12 17:01:43] [indexer:background] Health check [2023-10-12 17:02:25] [index:background] Health check [2023-10-12 17:07:22] [indexer:background] Health check [2023-10-12 17:07:22] [index:background] Health check [2023-10-12 17:13:24] [indexer:background] Health check [2023-10-12 17:13:24] [index:background] Health check [2023-10-12 17:17:19] [indexer:background] Health check [2023-10-12 17:17:19] [index:background] Health check [2023-10-12 17:23:17] [indexer:background] Health check [2023-10-12 17:23:17] [index:background] Health check [2023-10-12 17:27:15] [indexer:background] Health check [2023-10-12 17:27:15] [index:background] Health check [2023-10-12 17:35:56] [indexer:background] Health check [2023-10-12 17:35:56] [index:background] Health check [2023-10-12 17:36:44] [indexer:background] Health check [2023-10-12 17:37:25] [index:background] Health check [2023-10-12 17:42:04] [indexer:background] Health check [2023-10-12 17:42:29] [index:background] Health check [2023-10-12 17:47:13] [indexer:background] Health check [2023-10-12 17:47:13] [index:background] Health check [2023-10-12 17:52:31] [indexer:background] Health check [2023-10-12 17:52:32] [index:background] Health check [2023-10-12 17:58:03] [indexer:background] Health check [2023-10-12 17:58:03] [index:background] Health check [2023-10-12 18:02:32] [indexer:background] Health check [2023-10-12 18:02:32] [index:background] Health check [2023-10-12 18:06:40] [indexer:background] Health check [2023-10-12 18:07:53] [index:background] Health check [2023-10-12 18:15:20] [indexer:background] Health check [2023-10-12 18:15:20] [index:background] Health check [2023-10-12 18:18:19] [indexer:background] Health check [2023-10-12 18:18:19] [index:background] Health check [2023-10-12 18:23:38] [indexer:background] Health check [2023-10-12 18:23:38] [index:background] Health check [2023-10-12 18:31:12] [indexer:background] Health check [2023-10-12 18:31:12] [index:background] Health check [2023-10-12 18:33:58] [indexer:background] Health check [2023-10-12 18:33:58] [index:background] Health check [2023-10-12 18:38:36] [indexer:background] Health check [2023-10-12 18:38:36] [index:background] Health check [2023-10-12 18:43:56] [indexer:background] Health check [2023-10-12 18:43:56] [index:background] Health check [2023-10-12 18:46:46] [indexer:background] Health check [2023-10-12 18:47:12] [index:background] Health check [2023-10-12 18:51:42] [indexer:background] Health check [2023-10-12 18:52:24] [index:background] Health check [2023-10-12 18:58:13] [indexer:background] Health check [2023-10-12 18:58:13] [index:background] Health check [2023-10-12 19:02:33] [indexer:background] Health check [2023-10-12 19:02:33] [index:background] Health check [2023-10-12 19:07:20] [indexer:background] Health check [2023-10-12 19:07:20] [index:background] Health check [2023-10-12 19:12:08] [indexer:background] Health check [2023-10-12 19:12:36] [index:background] Health check [2023-10-12 19:16:41] [indexer:background] Health check [2023-10-12 19:17:33] [index:background] Health check [2023-10-12 19:22:45] [indexer:background] Health check [2023-10-12 19:22:45] [index:background] Health check [2023-10-12 19:26:43] [indexer:background] Health check [2023-10-12 19:27:13] [index:background] Health check [2023-10-12 19:29:05] [query] Query for: 2024 [2023-10-12 19:29:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 19:29:05] [query] Engine: default [2023-10-12 19:29:07] [query] Tokens: 2024 [2023-10-12 19:29:07] [query] Mods: 6 [2023-10-12 19:29:08] [query] Found results using: or logic [2023-10-12 19:29: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 19:29:08] [query] Results: 128 Pages of results: 13 [2023-10-12 19:29:08] [query] Execution time: 2.95698 [2023-10-12 19:31:46] [indexer:background] Health check [2023-10-12 19:32:18] [index:background] Health check [2023-10-12 19:36:47] [indexer:background] Health check [2023-10-12 19:37:13] [index:background] Health check [2023-10-12 19:41:42] [indexer:background] Health check [2023-10-12 19:42:15] [index:background] Health check [2023-10-12 19:46:43] [indexer:background] Health check [2023-10-12 19:47:15] [index:background] Health check [2023-10-12 19:51:45] [indexer:background] Health check [2023-10-12 19:52:18] [index:background] Health check [2023-10-12 19:56:45] [indexer:background] Health check [2023-10-12 19:57:18] [index:background] Health check [2023-10-12 20:01:47] [indexer:background] Health check [2023-10-12 20:02:12] [index:background] Health check [2023-10-12 20:06:41] [indexer:background] Health check [2023-10-12 20:07:14] [index:background] Health check [2023-10-12 20:11:45] [indexer:background] Health check [2023-10-12 20:12:18] [index:background] Health check [2023-10-12 20:16:40] [indexer:background] Health check [2023-10-12 20:17:13] [index:background] Health check [2023-10-12 20:21:44] [indexer:background] Health check [2023-10-12 20:22:18] [index:background] Health check [2023-10-12 20:26:42] [indexer:background] Health check [2023-10-12 20:27:15] [index:background] Health check [2023-10-12 20:34:02] [indexer:background] Health check [2023-10-12 20:34:02] [index:background] Health check [2023-10-12 20:36:55] [indexer:background] Health check [2023-10-12 20:42:11] [index:background] Health check [2023-10-12 20:42:13] [indexer:background] Health check [2023-10-12 20:42:13] [indexer:background] Health check [2023-10-12 20:46:53] [indexer:background] Health check [2023-10-12 20:49:50] [index:background] Health check [2023-10-12 20:52:10] [indexer:background] Health check [2023-10-12 20:52:10] [index:background] Health check [2023-10-12 20:57:12] [indexer:background] Health check [2023-10-12 20:57:12] [index:background] Health check [2023-10-12 21:01:53] [indexer:background] Health check [2023-10-12 21:02:36] [index:background] Health check [2023-10-12 21:06:46] [indexer:background] Health check [2023-10-12 21:07:53] [index:background] Health check [2023-10-12 21:11:47] [indexer:background] Health check [2023-10-12 21:12:24] [index:background] Health check [2023-10-12 21:17:52] [indexer:background] Health check [2023-10-12 21:17:52] [index:background] Health check [2023-10-12 21:22:00] [indexer:background] Health check [2023-10-12 21:22:50] [index:background] Health check [2023-10-12 21:26:43] [indexer:background] Health check [2023-10-12 21:27:29] [index:background] Health check [2023-10-12 21:32:22] [indexer:background] Health check [2023-10-12 21:32:22] [index:background] Health check [2023-10-12 21:36:54] [indexer:background] Health check [2023-10-12 21:37:32] [index:background] Health check [2023-10-12 21:41:42] [indexer:background] Health check [2023-10-12 21:42:11] [index:background] Health check [2023-10-12 21:46:55] [indexer:background] Health check [2023-10-12 21:47:17] [index:background] Health check [2023-10-12 21:51:46] [indexer:background] Health check [2023-10-12 21:52:27] [index:background] Health check [2023-10-12 21:56:40] [indexer:background] Health check [2023-10-12 21:58:32] [index:background] Health check [2023-10-12 22:02:45] [indexer:background] Health check [2023-10-12 22:02:45] [index:background] Health check [2023-10-12 22:06:53] [indexer:background] Health check [2023-10-12 22:07:28] [index:background] Health check [2023-10-12 22:12:56] [indexer:background] Health check [2023-10-12 22:12:56] [index:background] Health check [2023-10-12 22:16:39] [indexer:background] Health check [2023-10-12 22:18:13] [index:background] Health check [2023-10-12 22:22:11] [indexer:background] Health check [2023-10-12 22:22:11] [index:background] Health check [2023-10-12 22:27:55] [indexer:background] Health check [2023-10-12 22:27:55] [index:background] Health check [2023-10-12 22:31:42] [indexer:background] Health check [2023-10-12 22:32:24] [index:background] Health check [2023-10-12 22:39:58] [indexer:background] Health check [2023-10-12 22:39:58] [index:background] Health check [2023-10-12 22:44:03] [indexer:background] Health check [2023-10-12 22:44:03] [index:background] Health check [2023-10-12 22:46:46] [indexer:background] Health check [2023-10-12 22:47:41] [index:background] Health check [2023-10-12 22:52:18] [indexer:background] Health check [2023-10-12 22:52:18] [index:background] Health check [2023-10-12 22:56:53] [indexer:background] Health check [2023-10-12 22:58:19] [index:background] Health check [2023-10-12 23:02:46] [indexer:background] Health check [2023-10-12 23:02:46] [index:background] Health check [2023-10-12 23:06:53] [indexer:background] Health check [2023-10-12 23:07:19] [index:background] Health check [2023-10-12 23:11:43] [indexer:background] Health check [2023-10-12 23:12:28] [index:background] Health check [2023-10-12 23:19:20] [indexer:background] Health check [2023-10-12 23:19:20] [index:background] Health check [2023-10-12 23:22:34] [indexer:background] Health check [2023-10-12 23:22:34] [index:background] Health check [2023-10-12 23:26:53] [indexer:background] Health check [2023-10-12 23:27:45] [index:background] Health check [2023-10-12 23:32:48] [indexer:background] Health check [2023-10-12 23:32:48] [index:background] Health check [2023-10-12 23:36:58] [indexer:background] Health check [2023-10-12 23:38:19] [index:background] Health check [2023-10-12 23:41:45] [indexer:background] Health check [2023-10-12 23:42:13] [index:background] Health check [2023-10-12 23:46:40] [indexer:background] Health check [2023-10-12 23:47:12] [index:background] Health check [2023-10-12 23:51:43] [indexer:background] Health check [2023-10-12 23:52:12] [index:background] Health check [2023-10-12 23:56:47] [indexer:background] Health check [2023-10-12 23:57:17] [index:background] Health check [2023-10-12 23:59:46] [query] Query for: drou.cn [2023-10-12 23:59:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 23:59:46] [query] Query for: drou.cn [2023-10-12 23:59:46] [query] Engine: default [2023-10-12 23:59:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-12 23:59:46] [query] Engine: default [2023-10-12 23:59:47] [query] Tokens: drou drou.cn [2023-10-12 23:59:47] [query] Tokens: drou drou.cn [2023-10-12 23:59:47] [query] Mods: 6 [2023-10-12 23:59:47] [query] Mods: 6 [2023-10-12 23:59:47] [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 (0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 23:59:47] [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 (0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-10-12 23:59:47] [query] Results: 0 Pages of results: 0 [2023-10-12 23:59:47] [query] Results: 0 Pages of results: 0 [2023-10-12 23:59:47] [query] Execution time: 0.17541 [2023-10-12 23:59:47] [query] Execution time: 0.17621