[2023-10-19 00:02:52] [indexer:background] Health check
[2023-10-19 00:03:36] [index:background] Health check
[2023-10-19 00:07:18] [indexer:background] Health check
[2023-10-19 00:11:13] [index:background] Health check
[2023-10-19 00:14:06] [indexer:background] Health check
[2023-10-19 00:14:06] [index:background] Health check
[2023-10-19 00:17:48] [indexer:background] Health check
[2023-10-19 00:18:50] [index:background] Health check
[2023-10-19 00:21:57] [indexer:background] Health check
[2023-10-19 00:23:06] [index:background] Health check
[2023-10-19 00:27:52] [indexer:background] Health check
[2023-10-19 00:28:42] [index:background] Health check
[2023-10-19 00:32:02] [indexer:background] Health check
[2023-10-19 00:35:41] [index:background] Health check
[2023-10-19 00:39:36] [indexer:background] Health check
[2023-10-19 00:39:36] [index:background] Health check
[2023-10-19 00:41:54] [indexer:background] Health check
[2023-10-19 00:43:42] [index:background] Health check
[2023-10-19 00:48:31] [indexer:background] Health check
[2023-10-19 00:48:31] [index:background] Health check
[2023-10-19 00:51:47] [indexer:background] Health check
[2023-10-19 00:53:58] [index:background] Health check
[2023-10-19 00:57:12] [indexer:background] Health check
[2023-10-19 00:58:11] [index:background] Health check
[2023-10-19 01:02:03] [indexer:background] Health check
[2023-10-19 01:03:10] [index:background] Health check
[2023-10-19 01:07:27] [indexer:background] Health check
[2023-10-19 01:08:28] [index:background] Health check
[2023-10-19 01:12:47] [indexer:background] Health check
[2023-10-19 01:13:28] [index:background] Health check
[2023-10-19 01:16:45] [indexer:background] Health check
[2023-10-19 01:18:31] [index:background] Health check
[2023-10-19 01:21:39] [indexer:background] Health check
[2023-10-19 01:24:42] [index:background] Health check
[2023-10-19 01:27:23] [indexer:background] Health check
[2023-10-19 01:28:25] [index:background] Health check
[2023-10-19 01:36:17] [indexer:background] Health check
[2023-10-19 01:36:19] [index:background] Health check
[2023-10-19 01:37:15] [indexer:background] Health check
[2023-10-19 01:38:50] [index:background] Health check
[2023-10-19 01:45:35] [indexer:background] Health check
[2023-10-19 01:45:35] [index:background] Health check
[2023-10-19 01:47:33] [query] Query for: 2024
[2023-10-19 01:47:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 01:47:33] [query] Engine: default
[2023-10-19 01:47:34] [indexer:background] Health check
[2023-10-19 01:47:34] [query] Tokens: 2024
[2023-10-19 01:47:34] [query] Mods: 6
[2023-10-19 01:47:34] [query] Found results using: or logic
[2023-10-19 01:47:34] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-19 01:47:34] [query] Results: 128 Pages of results: 13
[2023-10-19 01:47:34] [query] Execution time: 0.88928
[2023-10-19 01:48:11] [index:background] Health check
[2023-10-19 01:53:07] [indexer:background] Health check
[2023-10-19 01:53:07] [index:background] Health check
[2023-10-19 01:59:20] [indexer:background] Health check
[2023-10-19 01:59:20] [index:background] Health check
[2023-10-19 02:03:12] [indexer:background] Health check
[2023-10-19 02:03:12] [index:background] Health check
[2023-10-19 02:06:41] [indexer:background] Health check
[2023-10-19 02:08:09] [index:background] Health check
[2023-10-19 02:12:26] [indexer:background] Health check
[2023-10-19 02:15:19] [index:background] Health check
[2023-10-19 02:19:11] [indexer:background] Health check
[2023-10-19 02:19:11] [index:background] Health check
[2023-10-19 02:24:35] [indexer:background] Health check
[2023-10-19 02:24:35] [index:background] Health check
[2023-10-19 02:26:52] [indexer:background] Health check
[2023-10-19 02:28:40] [index:background] Health check
[2023-10-19 02:33:01] [indexer:background] Health check
[2023-10-19 02:34:57] [index:background] Health check
[2023-10-19 02:38:24] [indexer:background] Health check
[2023-10-19 02:38:25] [index:background] Health check
[2023-10-19 02:46:08] [indexer:background] Health check
[2023-10-19 02:46:08] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 02:46:10] [index:background] Health check
[2023-10-19 02:46:10] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 02:46:12] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 02:47:26] [indexer:background] Health check
[2023-10-19 02:48:38] [index:background] Health check
[2023-10-19 02:52:45] [indexer:background] Health check
[2023-10-19 02:54:24] [index:background] Health check
[2023-10-19 02:56:57] [indexer:background] Health check
[2023-10-19 02:58:18] [index:background] Health check
[2023-10-19 03:02:26] [indexer:background] Health check
[2023-10-19 03:02:26] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2023-10-19 03:04:19] [index:background] Health check
[2023-10-19 03:06:56] [indexer:background] Health check
[2023-10-19 03:08:12] [index:background] Health check
[2023-10-19 03:12:17] [indexer:background] Health check
[2023-10-19 03:13:11] [index:background] Health check
[2023-10-19 03:13:11] [index:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2023-10-19 03:13:13] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2023-10-19 03:16:40] [indexer:background] Health check
[2023-10-19 03:19:05] [index:background] Health check
[2023-10-19 03:21:59] [indexer:background] Health check
[2023-10-19 03:23:20] [index:background] Health check
[2023-10-19 03:23:20] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-19 03:23:22] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-19 03:26:59] [indexer:background] Health check
[2023-10-19 03:26:59] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 03:29:11] [index:background] Health check
[2023-10-19 03:29:11] [index:background] CPU load threshold (3) breached: 3.66 [waiting 2]
[2023-10-19 03:29:13] [indexer:background] CPU load threshold (3) breached: 3.66 [waiting 2]
[2023-10-19 03:31:55] [indexer:background] Health check
[2023-10-19 03:31:55] [indexer:background] CPU load threshold (3) breached: 3.77 [waiting 2]
[2023-10-19 03:33:53] [index:background] Health check
[2023-10-19 03:37:07] [indexer:background] Health check
[2023-10-19 03:37:07] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-19 03:38:12] [index:background] Health check
[2023-10-19 03:41:51] [indexer:background] Health check
[2023-10-19 03:43:13] [index:background] Health check
[2023-10-19 03:47:08] [indexer:background] Health check
[2023-10-19 03:47:08] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-19 03:48:28] [index:background] Health check
[2023-10-19 03:51:56] [indexer:background] Health check
[2023-10-19 03:53:38] [index:background] Health check
[2023-10-19 03:57:17] [indexer:background] Health check
[2023-10-19 03:58:27] [index:background] Health check
[2023-10-19 04:02:21] [indexer:background] Health check
[2023-10-19 04:03:12] [index:background] Health check
[2023-10-19 04:08:05] [indexer:background] Health check
[2023-10-19 04:08:05] [index:background] Health check
[2023-10-19 04:12:04] [indexer:background] Health check
[2023-10-19 04:13:38] [index:background] Health check
[2023-10-19 04:17:49] [indexer:background] Health check
[2023-10-19 04:18:05] [index:background] Health check
[2023-10-19 04:22:06] [indexer:background] Health check
[2023-10-19 04:23:21] [index:background] Health check
[2023-10-19 04:27:16] [indexer:background] Health check
[2023-10-19 04:28:46] [index:background] Health check
[2023-10-19 04:32:22] [indexer:background] Health check
[2023-10-19 04:34:34] [index:background] Health check
[2023-10-19 04:40:30] [indexer:background] Health check
[2023-10-19 04:40:30] [index:background] Health check
[2023-10-19 04:42:53] [indexer:background] Health check
[2023-10-19 04:44:11] [index:background] Health check
[2023-10-19 04:48:10] [indexer:background] Health check
[2023-10-19 04:48:10] [index:background] Health check
[2023-10-19 04:52:10] [indexer:background] Health check
[2023-10-19 04:59:13] [index:background] Health check
[2023-10-19 04:59:13] [indexer:background] Health check
[2023-10-19 04:59:13] [indexer:background] Health check
[2023-10-19 05:02:27] [indexer:background] Health check
[2023-10-19 05:03:02] [index:background] Health check
[2023-10-19 05:07:14] [indexer:background] Health check
[2023-10-19 05:08:48] [index:background] Health check
[2023-10-19 05:12:38] [indexer:background] Health check
[2023-10-19 05:14:11] [index:background] Health check
[2023-10-19 05:17:13] [indexer:background] Health check
[2023-10-19 05:18:15] [index:background] Health check
[2023-10-19 05:22:00] [indexer:background] Health check
[2023-10-19 05:23:30] [index:background] Health check
[2023-10-19 05:27:02] [indexer:background] Health check
[2023-10-19 05:28:46] [index:background] Health check
[2023-10-19 05:31:40] [indexer:background] Health check
[2023-10-19 05:33:21] [index:background] Health check
[2023-10-19 05:36:42] [indexer:background] Health check
[2023-10-19 05:39:18] [index:background] Health check
[2023-10-19 05:42:26] [indexer:background] Health check
[2023-10-19 05:43:19] [index:background] Health check
[2023-10-19 05:46:45] [indexer:background] Health check
[2023-10-19 05:48:13] [index:background] Health check
[2023-10-19 05:51:51] [indexer:background] Health check
[2023-10-19 05:51:52] [query] Query for: 2024
[2023-10-19 05:51:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 05:51:52] [query] Engine: default
[2023-10-19 05:51:52] [query] Tokens: 2024
[2023-10-19 05:51:52] [query] Mods: 6
[2023-10-19 05:51:52] [query] Found results using: or logic
[2023-10-19 05:51:52] [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-19 05:51:52] [query] Results: 128 Pages of results: 13
[2023-10-19 05:51:52] [query] Execution time: 0.03600
[2023-10-19 05:51:52] [query] Query for: 2024
[2023-10-19 05:51:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-19 05:51:52] [query] Engine: default
[2023-10-19 05:51:52] [query] Tokens: 2024
[2023-10-19 05:51:52] [query] Mods: 6
[2023-10-19 05:51:52] [query] Found results using: or logic
[2023-10-19 05:51:52] [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, 100
[2023-10-19 05:51:52] [query] Results: 128 Pages of results: 2
[2023-10-19 05:51:52] [query] Execution time: 0.09558
[2023-10-19 05:53:10] [index:background] Health check
[2023-10-19 05:57:28] [indexer:background] Health check
[2023-10-19 05:58:38] [index:background] Health check
[2023-10-19 06:01:48] [indexer:background] Health check
[2023-10-19 06:03:56] [index:background] Health check
[2023-10-19 06:06:41] [indexer:background] Health check
[2023-10-19 06:08:04] [index:background] Health check
[2023-10-19 06:11:53] [indexer:background] Health check
[2023-10-19 06:13:53] [index:background] Health check
[2023-10-19 06:17:22] [indexer:background] Health check
[2023-10-19 06:18:16] [index:background] Health check
[2023-10-19 06:23:22] [indexer:background] Health check
[2023-10-19 06:23:22] [index:background] Health check
[2023-10-19 06:26:41] [indexer:background] Health check
[2023-10-19 06:28:36] [index:background] Health check
[2023-10-19 06:32:39] [indexer:background] Health check
[2023-10-19 06:34:55] [index:background] Health check
[2023-10-19 06:37:18] [indexer:background] Health check
[2023-10-19 06:38:12] [index:background] Health check
[2023-10-19 06:42:26] [indexer:background] Health check
[2023-10-19 06:43:42] [index:background] Health check
[2023-10-19 06:46:50] [indexer:background] Health check
[2023-10-19 06:48:06] [index:background] Health check
[2023-10-19 06:52:11] [indexer:background] Health check
[2023-10-19 06:53:55] [index:background] Health check
[2023-10-19 06:56:42] [indexer:background] Health check
[2023-10-19 06:58:25] [index:background] Health check
[2023-10-19 07:01:55] [indexer:background] Health check
[2023-10-19 07:03:52] [index:background] Health check
[2023-10-19 07:07:35] [indexer:background] Health check
[2023-10-19 07:08:52] [index:background] Health check
[2023-10-19 07:11:48] [indexer:background] Health check
[2023-10-19 07:13:11] [index:background] Health check
[2023-10-19 07:17:11] [indexer:background] Health check
[2023-10-19 07:18:36] [index:background] Health check
[2023-10-19 07:22:01] [indexer:background] Health check
[2023-10-19 07:23:35] [index:background] Health check
[2023-10-19 07:27:59] [indexer:background] Health check
[2023-10-19 07:28:22] [index:background] Health check
[2023-10-19 07:32:01] [indexer:background] Health check
[2023-10-19 07:33:36] [index:background] Health check
[2023-10-19 07:37:16] [indexer:background] Health check
[2023-10-19 07:38:24] [index:background] Health check
[2023-10-19 07:42:13] [indexer:background] Health check
[2023-10-19 07:42:13] [indexer:background] CPU load threshold (3) breached: 4.13 [waiting 2]
[2023-10-19 07:44:11] [index:background] Health check
[2023-10-19 07:46:48] [indexer:background] Health check
[2023-10-19 07:48:43] [index:background] Health check
[2023-10-19 07:51:27] [query] Query for: search_term_string
[2023-10-19 07:51:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 07:51:27] [query] Engine: default
[2023-10-19 07:51:27] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-10-19 07:51:27] [query] Mods: 6
[2023-10-19 07:51:27] [query] Using OR logic
[2023-10-19 07:51:29] [query] Found results using: or logic
[2023-10-19 07:51:29] [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-19 07:51:29] [query] Results: 1343 Pages of results: 135
[2023-10-19 07:51:29] [query] Execution time: 2.34295
[2023-10-19 07:51:53] [indexer:background] Health check
[2023-10-19 07:53:12] [index:background] Health check
[2023-10-19 07:57:57] [indexer:background] Health check
[2023-10-19 07:58:35] [index:background] Health check
[2023-10-19 08:01:59] [indexer:background] Health check
[2023-10-19 08:01:59] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-10-19 08:03:05] [index:background] Health check
[2023-10-19 08:03:05] [index:background] CPU load threshold (3) breached: 3.24 [waiting 2]
[2023-10-19 08:03:08] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2]
[2023-10-19 08:06:46] [indexer:background] Health check
[2023-10-19 08:08:02] [index:background] Health check
[2023-10-19 08:11:52] [indexer:background] Health check
[2023-10-19 08:14:05] [index:background] Health check
[2023-10-19 08:18:04] [indexer:background] Health check
[2023-10-19 08:18:04] [index:background] Health check
[2023-10-19 08:22:09] [indexer:background] Health check
[2023-10-19 08:23:12] [index:background] Health check
[2023-10-19 08:26:57] [indexer:background] Health check
[2023-10-19 08:28:06] [query] Query for: search_term_string
[2023-10-19 08:28:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 08:28:06] [query] Engine: default
[2023-10-19 08:28:06] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-10-19 08:28:06] [query] Mods: 6
[2023-10-19 08:28:06] [query] Using OR logic
[2023-10-19 08:28:06] [query] Found results using: or logic
[2023-10-19 08:28:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-19 08:28:06] [query] Results: 1343 Pages of results: 135
[2023-10-19 08:28:06] [query] Execution time: 0.04194
[2023-10-19 08:28:06] [index:background] Health check
[2023-10-19 08:31:41] [indexer:background] Health check
[2023-10-19 08:33:10] [index:background] Health check
[2023-10-19 08:37:52] [indexer:background] Health check
[2023-10-19 08:38:16] [index:background] Health check
[2023-10-19 08:41:55] [indexer:background] Health check
[2023-10-19 08:41:55] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-19 08:43:16] [index:background] Health check
[2023-10-19 08:47:13] [indexer:background] Health check
[2023-10-19 08:48:05] [index:background] Health check
[2023-10-19 08:48:05] [index:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2023-10-19 08:48:07] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-10-19 08:52:24] [indexer:background] Health check
[2023-10-19 08:53:37] [index:background] Health check
[2023-10-19 08:56:56] [indexer:background] Health check
[2023-10-19 08:56:56] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-10-19 08:58:04] [index:background] Health check
[2023-10-19 09:01:42] [indexer:background] Health check
[2023-10-19 09:01:42] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 09:03:03] [index:background] Health check
[2023-10-19 09:03:03] [index:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-10-19 09:03:05] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-10-19 09:06:40] [indexer:background] Health check
[2023-10-19 09:06:40] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2]
[2023-10-19 09:08:04] [index:background] Health check
[2023-10-19 09:08:04] [index:background] CPU load threshold (3) breached: 4.51 [waiting 2]
[2023-10-19 09:08:06] [indexer:background] CPU load threshold (3) breached: 4.47 [waiting 2]
[2023-10-19 09:11:40] [indexer:background] Health check
[2023-10-19 09:11:41] [indexer:background] CPU load threshold (3) breached: 4.53 [waiting 2]
[2023-10-19 09:13:04] [index:background] Health check
[2023-10-19 09:13:04] [index:background] CPU load threshold (3) breached: 4.52 [waiting 2]
[2023-10-19 09:13:06] [indexer:background] CPU load threshold (3) breached: 4.52 [waiting 2]
[2023-10-19 09:16:41] [indexer:background] Health check
[2023-10-19 09:16:41] [indexer:background] CPU load threshold (3) breached: 4.18 [waiting 2]
[2023-10-19 09:18:05] [index:background] Health check
[2023-10-19 09:18:05] [index:background] CPU load threshold (3) breached: 5.02 [waiting 2]
[2023-10-19 09:18:07] [indexer:background] CPU load threshold (3) breached: 5.1 [waiting 2]
[2023-10-19 09:21:40] [indexer:background] Health check
[2023-10-19 09:21:40] [indexer:background] CPU load threshold (3) breached: 4.4 [waiting 2]
[2023-10-19 09:23:06] [index:background] Health check
[2023-10-19 09:23:06] [index:background] CPU load threshold (3) breached: 4.54 [waiting 2]
[2023-10-19 09:23:08] [indexer:background] CPU load threshold (3) breached: 4.41 [waiting 2]
[2023-10-19 09:26:41] [indexer:background] Health check
[2023-10-19 09:26:41] [indexer:background] CPU load threshold (3) breached: 4.07 [waiting 2]
[2023-10-19 09:28:04] [index:background] Health check
[2023-10-19 09:28:04] [index:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-10-19 09:28:06] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-10-19 09:31:42] [indexer:background] Health check
[2023-10-19 09:31:42] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-10-19 09:33:03] [index:background] Health check
[2023-10-19 09:33:03] [index:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-10-19 09:33:05] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-10-19 09:36:42] [indexer:background] Health check
[2023-10-19 09:36:42] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2023-10-19 09:38:03] [index:background] Health check
[2023-10-19 09:38:03] [index:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-10-19 09:38:05] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-10-19 09:41:41] [indexer:background] Health check
[2023-10-19 09:43:04] [index:background] Health check
[2023-10-19 09:43:04] [index:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2023-10-19 09:43:06] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2023-10-19 09:46:41] [indexer:background] Health check
[2023-10-19 09:46:41] [indexer:background] CPU load threshold (3) breached: 4.27 [waiting 2]
[2023-10-19 09:48:03] [index:background] Health check
[2023-10-19 09:48:03] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2023-10-19 09:48:05] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2023-10-19 09:52:41] [indexer:background] Health check
[2023-10-19 09:53:04] [index:background] Health check
[2023-10-19 09:56:41] [indexer:background] Health check
[2023-10-19 09:56:41] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-10-19 09:58:04] [index:background] Health check
[2023-10-19 09:58:04] [index:background] CPU load threshold (3) breached: 3.62 [waiting 2]
[2023-10-19 09:58:06] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2]
[2023-10-19 10:01:42] [indexer:background] Health check
[2023-10-19 10:01:42] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2023-10-19 10:03:03] [index:background] Health check
[2023-10-19 10:03:04] [index:background] CPU load threshold (3) breached: 3.76 [waiting 2]
[2023-10-19 10:03:06] [indexer:background] CPU load threshold (3) breached: 3.76 [waiting 2]
[2023-10-19 10:06:41] [indexer:background] Health check
[2023-10-19 10:06:41] [indexer:background] CPU load threshold (3) breached: 3.93 [waiting 2]
[2023-10-19 10:08:04] [index:background] Health check
[2023-10-19 10:09:05] [query] Query for: 2023
[2023-10-19 10:09:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 10:09:05] [query] Engine: default
[2023-10-19 10:09:06] [query] Tokens: 2023
[2023-10-19 10:09:06] [query] Mods: 6
[2023-10-19 10:09:06] [query] Found results using: or logic
[2023-10-19 10:09:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-19 10:09:06] [query] Results: 248 Pages of results: 25
[2023-10-19 10:09:06] [query] Execution time: 1.06045
[2023-10-19 10:11:40] [indexer:background] Health check
[2023-10-19 10:11:40] [indexer:background] CPU load threshold (3) breached: 4.14 [waiting 2]
[2023-10-19 10:13:04] [index:background] Health check
[2023-10-19 10:13:04] [index:background] CPU load threshold (3) breached: 3.92 [waiting 2]
[2023-10-19 10:13:06] [indexer:background] CPU load threshold (3) breached: 4 [waiting 2]
[2023-10-19 10:16:41] [indexer:background] Health check
[2023-10-19 10:16:41] [indexer:background] CPU load threshold (3) breached: 4.12 [waiting 2]
[2023-10-19 10:18:05] [index:background] Health check
[2023-10-19 10:18:05] [index:background] CPU load threshold (3) breached: 4.35 [waiting 2]
[2023-10-19 10:18:07] [indexer:background] CPU load threshold (3) breached: 4.35 [waiting 2]
[2023-10-19 10:21:41] [indexer:background] Health check
[2023-10-19 10:21:41] [indexer:background] CPU load threshold (3) breached: 4.06 [waiting 2]
[2023-10-19 10:23:05] [index:background] Health check
[2023-10-19 10:23:05] [index:background] CPU load threshold (3) breached: 4 [waiting 2]
[2023-10-19 10:23:07] [indexer:background] CPU load threshold (3) breached: 4 [waiting 2]
[2023-10-19 10:26:44] [indexer:background] Health check
[2023-10-19 10:28:07] [index:background] Health check
[2023-10-19 10:31:43] [indexer:background] Health check
[2023-10-19 10:33:06] [index:background] Health check
[2023-10-19 10:36:42] [indexer:background] Health check
[2023-10-19 10:38:03] [index:background] Health check
[2023-10-19 10:41:43] [indexer:background] Health check
[2023-10-19 10:41:43] [indexer:background] CPU load threshold (3) breached: 3.56 [waiting 2]
[2023-10-19 10:43:07] [index:background] Health check
[2023-10-19 10:43:07] [index:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2023-10-19 10:43:09] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2023-10-19 10:46:43] [indexer:background] Health check
[2023-10-19 10:46:43] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-19 10:48:08] [index:background] Health check
[2023-10-19 10:51:43] [indexer:background] Health check
[2023-10-19 10:53:06] [index:background] Health check
[2023-10-19 10:56:49] [indexer:background] Health check
[2023-10-19 10:58:09] [index:background] Health check
[2023-10-19 11:01:44] [indexer:background] Health check
[2023-10-19 11:03:04] [index:background] Health check
[2023-10-19 11:06:43] [indexer:background] Health check
[2023-10-19 11:08:05] [index:background] Health check
[2023-10-19 11:11:46] [indexer:background] Health check
[2023-10-19 11:13:07] [index:background] Health check
[2023-10-19 11:16:45] [indexer:background] Health check
[2023-10-19 11:18:06] [index:background] Health check
[2023-10-19 11:21:43] [indexer:background] Health check
[2023-10-19 11:23:04] [index:background] Health check
[2023-10-19 11:26:48] [indexer:background] Health check
[2023-10-19 11:28:11] [index:background] Health check
[2023-10-19 11:31:44] [indexer:background] Health check
[2023-10-19 11:33:08] [index:background] Health check
[2023-10-19 11:36:40] [indexer:background] Health check
[2023-10-19 11:38:03] [index:background] Health check
[2023-10-19 11:41:43] [indexer:background] Health check
[2023-10-19 11:43:07] [index:background] Health check
[2023-10-19 11:46:41] [indexer:background] Health check
[2023-10-19 11:48:05] [index:background] Health check
[2023-10-19 11:48:05] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-10-19 11:48:07] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-10-19 11:51:42] [indexer:background] Health check
[2023-10-19 11:51:42] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2]
[2023-10-19 11:53:05] [index:background] Health check
[2023-10-19 11:53:05] [index:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-10-19 11:53:07] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-10-19 11:56:45] [indexer:background] Health check
[2023-10-19 11:56:45] [indexer:background] CPU load threshold (3) breached: 4.92 [waiting 2]
[2023-10-19 11:58:05] [index:background] Health check
[2023-10-19 11:58:05] [index:background] CPU load threshold (3) breached: 5.05 [waiting 2]
[2023-10-19 11:58:07] [indexer:background] CPU load threshold (3) breached: 5.05 [waiting 2]
[2023-10-19 12:01:41] [indexer:background] Health check
[2023-10-19 12:01:41] [indexer:background] CPU load threshold (3) breached: 4.74 [waiting 2]
[2023-10-19 12:03:04] [index:background] Health check
[2023-10-19 12:03:04] [index:background] CPU load threshold (3) breached: 4.19 [waiting 2]
[2023-10-19 12:03:06] [indexer:background] CPU load threshold (3) breached: 4.26 [waiting 2]
[2023-10-19 12:06:40] [indexer:background] Health check
[2023-10-19 12:06:40] [indexer:background] CPU load threshold (3) breached: 4.67 [waiting 2]
[2023-10-19 12:08:04] [index:background] Health check
[2023-10-19 12:08:04] [index:background] CPU load threshold (3) breached: 5.22 [waiting 2]
[2023-10-19 12:08:06] [indexer:background] CPU load threshold (3) breached: 5.28 [waiting 2]
[2023-10-19 12:11:41] [indexer:background] Health check
[2023-10-19 12:11:41] [indexer:background] CPU load threshold (3) breached: 4.85 [waiting 2]
[2023-10-19 12:13:04] [index:background] Health check
[2023-10-19 12:13:04] [index:background] CPU load threshold (3) breached: 4.89 [waiting 2]
[2023-10-19 12:13:06] [indexer:background] CPU load threshold (3) breached: 4.66 [waiting 2]
[2023-10-19 12:16:40] [indexer:background] Health check
[2023-10-19 12:16:40] [indexer:background] CPU load threshold (3) breached: 5.06 [waiting 2]
[2023-10-19 12:18:03] [index:background] Health check
[2023-10-19 12:18:03] [index:background] CPU load threshold (3) breached: 4.03 [waiting 2]
[2023-10-19 12:18:05] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2]
[2023-10-19 12:21:42] [indexer:background] Health check
[2023-10-19 12:21:42] [indexer:background] CPU load threshold (3) breached: 4.87 [waiting 2]
[2023-10-19 12:23:05] [index:background] Health check
[2023-10-19 12:23:05] [index:background] CPU load threshold (3) breached: 4.98 [waiting 2]
[2023-10-19 12:23:07] [indexer:background] CPU load threshold (3) breached: 4.98 [waiting 2]
[2023-10-19 12:26:42] [indexer:background] Health check
[2023-10-19 12:26:42] [indexer:background] CPU load threshold (3) breached: 4.91 [waiting 2]
[2023-10-19 12:28:06] [index:background] Health check
[2023-10-19 12:28:06] [index:background] CPU load threshold (3) breached: 6.47 [waiting 2]
[2023-10-19 12:28:08] [indexer:background] CPU load threshold (3) breached: 6.47 [waiting 2]
[2023-10-19 12:31:40] [indexer:background] Health check
[2023-10-19 12:31:41] [indexer:background] CPU load threshold (3) breached: 4.82 [waiting 2]
[2023-10-19 12:33:03] [index:background] Health check
[2023-10-19 12:33:03] [index:background] CPU load threshold (3) breached: 5.64 [waiting 2]
[2023-10-19 12:33:05] [indexer:background] CPU load threshold (3) breached: 5.64 [waiting 2]
[2023-10-19 12:36:40] [indexer:background] Health check
[2023-10-19 12:36:40] [indexer:background] CPU load threshold (3) breached: 5.77 [waiting 2]
[2023-10-19 12:38:04] [index:background] Health check
[2023-10-19 12:38:04] [index:background] CPU load threshold (3) breached: 7.26 [waiting 2]
[2023-10-19 12:38:06] [indexer:background] CPU load threshold (3) breached: 7.26 [waiting 2]
[2023-10-19 12:41:41] [indexer:background] Health check
[2023-10-19 12:41:41] [indexer:background] CPU load threshold (3) breached: 5.8 [waiting 2]
[2023-10-19 12:43:04] [index:background] Health check
[2023-10-19 12:43:04] [index:background] CPU load threshold (3) breached: 5.3 [waiting 2]
[2023-10-19 12:43:07] [indexer:background] CPU load threshold (3) breached: 5.2 [waiting 2]
[2023-10-19 12:47:42] [indexer:background] Health check
[2023-10-19 12:47:42] [indexer:background] CPU load threshold (3) breached: 5.68 [waiting 2]
[2023-10-19 12:48:03] [index:background] Health check
[2023-10-19 12:48:03] [index:background] CPU load threshold (3) breached: 5.99 [waiting 2]
[2023-10-19 12:48:05] [indexer:background] CPU load threshold (3) breached: 5.99 [waiting 2]
[2023-10-19 12:51:41] [indexer:background] Health check
[2023-10-19 12:51:41] [indexer:background] CPU load threshold (3) breached: 5.34 [waiting 2]
[2023-10-19 12:53:04] [index:background] Health check
[2023-10-19 12:53:04] [index:background] CPU load threshold (3) breached: 5.34 [waiting 2]
[2023-10-19 12:53:06] [indexer:background] CPU load threshold (3) breached: 5.34 [waiting 2]
[2023-10-19 12:56:42] [indexer:background] Health check
[2023-10-19 12:56:42] [indexer:background] CPU load threshold (3) breached: 5.27 [waiting 2]
[2023-10-19 12:58:05] [index:background] Health check
[2023-10-19 12:58:05] [index:background] CPU load threshold (3) breached: 5.27 [waiting 2]
[2023-10-19 12:58:07] [indexer:background] CPU load threshold (3) breached: 5.33 [waiting 2]
[2023-10-19 13:01:40] [indexer:background] Health check
[2023-10-19 13:01:40] [indexer:background] CPU load threshold (3) breached: 5.02 [waiting 2]
[2023-10-19 13:03:04] [index:background] Health check
[2023-10-19 13:03:04] [index:background] CPU load threshold (3) breached: 5.71 [waiting 2]
[2023-10-19 13:03:07] [indexer:background] CPU load threshold (3) breached: 5.71 [waiting 2]
[2023-10-19 13:06:41] [indexer:background] Health check
[2023-10-19 13:06:41] [indexer:background] CPU load threshold (3) breached: 4.56 [waiting 2]
[2023-10-19 13:08:03] [index:background] Health check
[2023-10-19 13:08:03] [index:background] CPU load threshold (3) breached: 4.34 [waiting 2]
[2023-10-19 13:08:05] [indexer:background] CPU load threshold (3) breached: 4.34 [waiting 2]
[2023-10-19 13:11:41] [indexer:background] Health check
[2023-10-19 13:11:41] [indexer:background] CPU load threshold (3) breached: 4.39 [waiting 2]
[2023-10-19 13:13:05] [index:background] Health check
[2023-10-19 13:13:05] [index:background] CPU load threshold (3) breached: 4.14 [waiting 2]
[2023-10-19 13:13:07] [indexer:background] CPU load threshold (3) breached: 4.14 [waiting 2]
[2023-10-19 13:16:42] [indexer:background] Health check
[2023-10-19 13:16:42] [indexer:background] CPU load threshold (3) breached: 4.83 [waiting 2]
[2023-10-19 13:18:07] [index:background] Health check
[2023-10-19 13:18:07] [index:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2023-10-19 13:18:09] [indexer:background] CPU load threshold (3) breached: 3.91 [waiting 2]
[2023-10-19 13:21:27] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2023-10-19 13:21:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 13:21:27] [query] Engine: default
[2023-10-19 13:21:29] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2023-10-19 13:21:29] [query] Mods: 6
[2023-10-19 13:21:29] [query] Using OR logic
[2023-10-19 13:21:30] [query] Found results using: or logic
[2023-10-19 13:21:30] [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 (20886,13853,27861,45186,333334,8840,4915,69784,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-19 13:21:30] [query] Results: 892 Pages of results: 90
[2023-10-19 13:21:30] [query] Execution time: 2.43862
[2023-10-19 13:21:42] [indexer:background] Health check
[2023-10-19 13:21:42] [indexer:background] CPU load threshold (3) breached: 3.94 [waiting 2]
[2023-10-19 13:23:04] [index:background] Health check
[2023-10-19 13:23:04] [index:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2023-10-19 13:23:06] [indexer:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2023-10-19 13:26:42] [indexer:background] Health check
[2023-10-19 13:26:42] [indexer:background] CPU load threshold (3) breached: 4 [waiting 2]
[2023-10-19 13:28:05] [index:background] Health check
[2023-10-19 13:28:05] [index:background] CPU load threshold (3) breached: 3.8 [waiting 2]
[2023-10-19 13:28:07] [indexer:background] CPU load threshold (3) breached: 3.8 [waiting 2]
[2023-10-19 13:31:41] [indexer:background] Health check
[2023-10-19 13:31:41] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2023-10-19 13:33:04] [index:background] Health check
[2023-10-19 13:33:04] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-19 13:33:06] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-19 13:36:41] [indexer:background] Health check
[2023-10-19 13:36:41] [indexer:background] CPU load threshold (3) breached: 4.04 [waiting 2]
[2023-10-19 13:38:04] [index:background] Health check
[2023-10-19 13:38:04] [index:background] CPU load threshold (3) breached: 4.31 [waiting 2]
[2023-10-19 13:38:06] [indexer:background] CPU load threshold (3) breached: 4.31 [waiting 2]
[2023-10-19 13:41:41] [indexer:background] Health check
[2023-10-19 13:41:41] [indexer:background] CPU load threshold (3) breached: 4.07 [waiting 2]
[2023-10-19 13:43:03] [index:background] Health check
[2023-10-19 13:43:03] [index:background] CPU load threshold (3) breached: 4.63 [waiting 2]
[2023-10-19 13:43:05] [indexer:background] CPU load threshold (3) breached: 4.5 [waiting 2]
[2023-10-19 13:46:42] [indexer:background] Health check
[2023-10-19 13:46:42] [indexer:background] CPU load threshold (3) breached: 3.28 [waiting 2]
[2023-10-19 13:48:04] [index:background] Health check
[2023-10-19 13:48:04] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2023-10-19 13:48:06] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2023-10-19 13:51:40] [indexer:background] Health check
[2023-10-19 13:53:04] [index:background] Health check
[2023-10-19 13:53:04] [index:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2023-10-19 13:53:06] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-10-19 13:56:41] [indexer:background] Health check
[2023-10-19 13:56:41] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-10-19 13:58:03] [index:background] Health check
[2023-10-19 13:58:03] [index:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-10-19 13:58:05] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-10-19 13:59:28] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2023-10-19 13:59:28] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 13:59:28] [query] Engine: default
[2023-10-19 13:59:28] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2023-10-19 13:59:28] [query] Mods: 6
[2023-10-19 13:59:28] [query] Using OR logic
[2023-10-19 13:59:28] [query] Found results using: or logic
[2023-10-19 13:59:28] [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 (20886,13853,27861,45186,333334,8840,4915,69784,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-19 13:59:28] [query] Results: 892 Pages of results: 90
[2023-10-19 13:59:28] [query] Execution time: 0.04811
[2023-10-19 14:01:42] [indexer:background] Health check
[2023-10-19 14:01:42] [indexer:background] CPU load threshold (3) breached: 4.26 [waiting 2]
[2023-10-19 14:03:04] [index:background] Health check
[2023-10-19 14:03:04] [index:background] CPU load threshold (3) breached: 4.31 [waiting 2]
[2023-10-19 14:03:06] [indexer:background] CPU load threshold (3) breached: 4.37 [waiting 2]
[2023-10-19 14:06:40] [indexer:background] Health check
[2023-10-19 14:06:40] [indexer:background] CPU load threshold (3) breached: 4.67 [waiting 2]
[2023-10-19 14:08:03] [index:background] Health check
[2023-10-19 14:08:03] [index:background] CPU load threshold (3) breached: 4.76 [waiting 2]
[2023-10-19 14:08:05] [indexer:background] CPU load threshold (3) breached: 4.54 [waiting 2]
[2023-10-19 14:11:41] [indexer:background] Health check
[2023-10-19 14:11:41] [indexer:background] CPU load threshold (3) breached: 4.49 [waiting 2]
[2023-10-19 14:13:05] [index:background] Health check
[2023-10-19 14:13:05] [index:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2023-10-19 14:13:07] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-10-19 14:16:42] [indexer:background] Health check
[2023-10-19 14:16:42] [indexer:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2023-10-19 14:18:51] [index:background] Health check
[2023-10-19 14:18:51] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2023-10-19 14:18:53] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2023-10-19 14:21:40] [indexer:background] Health check
[2023-10-19 14:24:06] [index:background] Health check
[2023-10-19 14:24:06] [index:background] CPU load threshold (3) breached: 30.52 [waiting 2]
[2023-10-19 14:24:06] [index:background] Health check
[2023-10-19 14:24:08] [index:background] CPU load threshold (3) breached: 30.52 [waiting 2]
[2023-10-19 14:24:08] [indexer:background] CPU load threshold (3) breached: 30.52 [waiting 2]
[2023-10-19 14:24:10] [indexer:background] CPU load threshold (3) breached: 30.52 [waiting 2]
[2023-10-19 14:26:40] [indexer:background] Health check
[2023-10-19 14:26:40] [indexer:background] CPU load threshold (3) breached: 5.18 [waiting 2]
[2023-10-19 14:28:05] [index:background] Health check
[2023-10-19 14:28:05] [index:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2023-10-19 14:28:07] [indexer:background] CPU load threshold (3) breached: 3.83 [waiting 2]
[2023-10-19 14:31:42] [indexer:background] Health check
[2023-10-19 14:33:04] [index:background] Health check
[2023-10-19 14:36:41] [indexer:background] Health check
[2023-10-19 14:38:03] [index:background] Health check
[2023-10-19 14:38:03] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-19 14:38:05] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-19 14:41:40] [indexer:background] Health check
[2023-10-19 14:41:40] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-10-19 14:43:04] [index:background] Health check
[2023-10-19 14:46:41] [indexer:background] Health check
[2023-10-19 14:46:41] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-10-19 14:48:06] [index:background] Health check
[2023-10-19 14:48:06] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2023-10-19 14:48:08] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-10-19 14:51:40] [indexer:background] Health check
[2023-10-19 14:51:40] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-10-19 14:53:03] [index:background] Health check
[2023-10-19 14:53:03] [index:background] CPU load threshold (3) breached: 4.19 [waiting 2]
[2023-10-19 14:53:05] [indexer:background] CPU load threshold (3) breached: 4.19 [waiting 2]
[2023-10-19 14:56:42] [indexer:background] Health check
[2023-10-19 14:58:03] [index:background] Health check
[2023-10-19 15:01:41] [indexer:background] Health check
[2023-10-19 15:01:41] [indexer:background] CPU load threshold (3) breached: 3.52 [waiting 2]
[2023-10-19 15:03:03] [index:background] Health check
[2023-10-19 15:03:03] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-19 15:03:05] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-19 15:06:41] [indexer:background] Health check
[2023-10-19 15:08:03] [index:background] Health check
[2023-10-19 15:11:41] [indexer:background] Health check
[2023-10-19 15:13:05] [index:background] Health check
[2023-10-19 15:13:05] [index:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2023-10-19 15:13:07] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2023-10-19 15:16:41] [indexer:background] Health check
[2023-10-19 15:16:41] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2]
[2023-10-19 15:18:04] [index:background] Health check
[2023-10-19 15:18:04] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-19 15:18:06] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-19 15:21:41] [indexer:background] Health check
[2023-10-19 15:23:04] [index:background] Health check
[2023-10-19 15:23:04] [index:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-10-19 15:23:06] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-10-19 15:26:43] [indexer:background] Health check
[2023-10-19 15:26:43] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 15:28:04] [index:background] Health check
[2023-10-19 15:28:04] [index:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-10-19 15:28:06] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-10-19 15:28:57] [index] Marking post.attachment 13833 to be dropped
[2023-10-19 15:29:00] [index] Dropping post.attachment 13833
[2023-10-19 15:29:00] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-10-19 15:29:02] [indexer] Queued next batch (1)
[2023-10-19 15:29:02] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-10-19 15:29:05] [indexer] Processing batch (1)
[2023-10-19 15:29:05] [indexer] Indexing post.attachment:13833
[2023-10-19 15:29:05] [index] Marking [1] post.attachment 13833 as indexed
[2023-10-19 15:29:06] [indexer] Index built
[2023-10-19 15:29:06] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2023-10-19 15:30:03] [index] Marking post.attachment 13834 to be dropped
[2023-10-19 15:30:06] [index] Dropping post.attachment 13834
[2023-10-19 15:30:06] [indexer] Queued next batch (1)
[2023-10-19 15:30:08] [indexer] Processing batch (1)
[2023-10-19 15:30:08] [indexer] Indexing post.attachment:13834
[2023-10-19 15:30:08] [index] Marking [1] post.attachment 13834 as indexed
[2023-10-19 15:30:08] [indexer] Index built
[2023-10-19 15:31:41] [indexer:background] Health check
[2023-10-19 15:31:41] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2]
[2023-10-19 15:33:04] [index:background] Health check
[2023-10-19 15:33:04] [index:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-10-19 15:33:06] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-10-19 15:36:41] [indexer:background] Health check
[2023-10-19 15:36:41] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2023-10-19 15:38:05] [index:background] Health check
[2023-10-19 15:41:40] [indexer:background] Health check
[2023-10-19 15:43:03] [index:background] Health check
[2023-10-19 15:46:41] [indexer:background] Health check
[2023-10-19 15:48:03] [index:background] Health check
[2023-10-19 15:51:48] [indexer:background] Health check
[2023-10-19 15:53:03] [index:background] Health check
[2023-10-19 15:56:41] [indexer:background] Health check
[2023-10-19 15:58:04] [index:background] Health check
[2023-10-19 16:01:41] [indexer:background] Health check
[2023-10-19 16:04:06] [index:background] Health check
[2023-10-19 16:07:04] [indexer:background] Health check
[2023-10-19 16:08:04] [index:background] Health check
[2023-10-19 16:12:55] [indexer:background] Health check
[2023-10-19 16:13:29] [index:background] Health check
[2023-10-19 16:16:55] [indexer:background] Health check
[2023-10-19 16:18:09] [index:background] Health check
[2023-10-19 16:22:16] [indexer:background] Health check
[2023-10-19 16:24:04] [index:background] Health check
[2023-10-19 16:26:49] [indexer:background] Health check
[2023-10-19 16:28:04] [index:background] Health check
[2023-10-19 16:28:33] [query] Query for: délibération n°007-2017du 24 fevrier 2017
[2023-10-19 16:28:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 16:28:33] [query] Engine: default
[2023-10-19 16:28:35] [query] Tokens: deliberative, deliberantes, delibère, deliberatifs, deliberes, deliberera, deliberement, deliberants, deliberé, delibéré, deliberation, deliberer, delibere, deliberations, deliberant, delibératifs, fevrier, n°007, 2017du, 2017, 007, 007-2017du 2017du 24 fevrier 2017
[2023-10-19 16:28:35] [query] Mods: 6
[2023-10-19 16:28:35] [query] Using OR logic
[2023-10-19 16:28:38] [query] Found results using: or logic
[2023-10-19 16:28: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 (80222,549383,493510,383352,349896,334209,239834,157014,131916,79735,70783,70782,70779,60672,17463,788491,111,625420,573551,565,80037,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-19 16:28:38] [query] Results: 2278 Pages of results: 228
[2023-10-19 16:28:38] [query] Execution time: 4.73340
[2023-10-19 16:28:38] [query] Query for: délibération n°007-2017du 24 fevrier 2017
[2023-10-19 16:28:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-19 16:28:38] [query] Engine: default
[2023-10-19 16:28:38] [query] Tokens: deliberative, deliberantes, delibère, deliberatifs, deliberes, deliberera, deliberement, deliberants, deliberé, delibéré, deliberation, deliberer, delibere, deliberations, deliberant, delibératifs, fevrier, n°007, 2017du, 2017, 007, 007-2017du 2017du 24 fevrier 2017
[2023-10-19 16:28:38] [query] Mods: 6
[2023-10-19 16:28:38] [query] Using OR logic
[2023-10-19 16:28:40] [query] Found results using: or logic
[2023-10-19 16:28:40] [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 (80222,549383,493510,383352,349896,334209,239834,157014,131916,79735,70783,70782,70779,60672,17463,788491,111,625420,573551,565,80037,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, 100
[2023-10-19 16:28:40] [query] Results: 2278 Pages of results: 23
[2023-10-19 16:28:40] [query] Execution time: 2.20455
[2023-10-19 16:32:06] [indexer:background] Health check
[2023-10-19 16:33:28] [index:background] Health check
[2023-10-19 16:37:26] [indexer:background] Health check
[2023-10-19 16:38:10] [index:background] Health check
[2023-10-19 16:44:33] [indexer:background] Health check
[2023-10-19 16:44:33] [index:background] Health check
[2023-10-19 16:47:14] [indexer:background] Health check
[2023-10-19 16:48:11] [index:background] Health check
[2023-10-19 16:53:22] [indexer:background] Health check
[2023-10-19 16:53:22] [index:background] Health check
[2023-10-19 16:57:08] [indexer:background] Health check
[2023-10-19 16:58:04] [index:background] Health check
[2023-10-19 17:02:17] [indexer:background] Health check
[2023-10-19 17:03:27] [index:background] Health check
[2023-10-19 17:07:23] [indexer:background] Health check
[2023-10-19 17:08:55] [index:background] Health check
[2023-10-19 17:11:41] [indexer:background] Health check
[2023-10-19 17:15:44] [index:background] Health check
[2023-10-19 17:17:03] [indexer:background] Health check
[2023-10-19 17:18:06] [index:background] Health check
[2023-10-19 17:21:57] [indexer:background] Health check
[2023-10-19 17:23:39] [index:background] Health check
[2023-10-19 17:27:57] [indexer:background] Health check
[2023-10-19 17:28:04] [index:background] Health check
[2023-10-19 17:31:56] [indexer:background] Health check
[2023-10-19 17:33:16] [index:background] Health check
[2023-10-19 17:36:44] [indexer:background] Health check
[2023-10-19 17:38:19] [index:background] Health check
[2023-10-19 17:41:53] [indexer:background] Health check
[2023-10-19 17:44:45] [index:background] Health check
[2023-10-19 17:48:54] [indexer:background] Health check
[2023-10-19 17:48:54] [index:background] Health check
[2023-10-19 17:52:31] [indexer:background] Health check
[2023-10-19 17:53:39] [index:background] Health check
[2023-10-19 17:56:58] [indexer:background] Health check
[2023-10-19 18:00:56] [index:background] Health check
[2023-10-19 18:03:09] [indexer:background] Health check
[2023-10-19 18:03:09] [index:background] Health check
[2023-10-19 18:07:46] [indexer:background] Health check
[2023-10-19 18:08:42] [index:background] Health check
[2023-10-19 18:16:38] [indexer:background] Health check
[2023-10-19 18:16:38] [index:background] Health check
[2023-10-19 18:16:43] [indexer:background] Health check
[2023-10-19 18:19:16] [index:background] Health check
[2023-10-19 18:22:13] [indexer:background] Health check
[2023-10-19 18:26:33] [index:background] Health check
[2023-10-19 18:28:54] [indexer:background] Health check
[2023-10-19 18:28:54] [index:background] Health check
[2023-10-19 18:35:22] [indexer:background] Health check
[2023-10-19 18:35:22] [index:background] Health check
[2023-10-19 18:36:39] [indexer:background] Health check
[2023-10-19 18:39:04] [index:background] Health check
[2023-10-19 18:43:24] [indexer:background] Health check
[2023-10-19 18:43:24] [index:background] Health check
[2023-10-19 18:49:46] [indexer:background] Health check
[2023-10-19 18:49:46] [index:background] Health check
[2023-10-19 18:52:01] [indexer:background] Health check
[2023-10-19 18:56:00] [index:background] Health check
[2023-10-19 18:56:44] [indexer:background] Health check
[2023-10-19 18:59:27] [index:background] Health check
[2023-10-19 19:02:37] [indexer:background] Health check
[2023-10-19 19:04:05] [index:background] Health check
[2023-10-19 19:08:07] [indexer:background] Health check
[2023-10-19 19:08:07] [index:background] Health check
[2023-10-19 19:12:24] [indexer:background] Health check
[2023-10-19 19:13:15] [index:background] Health check
[2023-10-19 19:17:26] [indexer:background] Health check
[2023-10-19 19:18:56] [index:background] Health check
[2023-10-19 19:21:45] [indexer:background] Health check
[2023-10-19 19:25:15] [index:background] Health check
[2023-10-19 19:27:02] [indexer:background] Health check
[2023-10-19 19:29:19] [index:background] Health check
[2023-10-19 19:32:04] [indexer:background] Health check
[2023-10-19 19:33:24] [index:background] Health check
[2023-10-19 19:39:01] [indexer:background] Health check
[2023-10-19 19:39:01] [index:background] Health check
[2023-10-19 19:43:11] [indexer:background] Health check
[2023-10-19 19:43:11] [index:background] Health check
[2023-10-19 19:48:13] [indexer:background] Health check
[2023-10-19 19:48:13] [index:background] Health check
[2023-10-19 19:51:54] [indexer:background] Health check
[2023-10-19 19:54:28] [index:background] Health check
[2023-10-19 19:58:04] [indexer:background] Health check
[2023-10-19 19:58:04] [index:background] Health check
[2023-10-19 20:01:52] [indexer:background] Health check
[2023-10-19 20:03:15] [index:background] Health check
[2023-10-19 20:07:08] [indexer:background] Health check
[2023-10-19 20:08:44] [index:background] Health check
[2023-10-19 20:12:22] [indexer:background] Health check
[2023-10-19 20:13:02] [index:background] Health check
[2023-10-19 20:17:22] [indexer:background] Health check
[2023-10-19 20:18:13] [index:background] Health check
[2023-10-19 20:22:42] [indexer:background] Health check
[2023-10-19 20:24:03] [index:background] Health check
[2023-10-19 20:27:04] [indexer:background] Health check
[2023-10-19 20:28:17] [index:background] Health check
[2023-10-19 20:34:02] [indexer:background] Health check
[2023-10-19 20:34:02] [index:background] Health check
[2023-10-19 20:36:42] [indexer:background] Health check
[2023-10-19 20:38:17] [index:background] Health check
[2023-10-19 20:43:34] [indexer:background] Health check
[2023-10-19 20:43:35] [index:background] Health check
[2023-10-19 20:46:55] [indexer:background] Health check
[2023-10-19 20:48:50] [index:background] Health check
[2023-10-19 20:52:06] [indexer:background] Health check
[2023-10-19 20:53:14] [index:background] Health check
[2023-10-19 20:57:08] [indexer:background] Health check
[2023-10-19 20:58:13] [index:background] Health check
[2023-10-19 21:02:16] [indexer:background] Health check
[2023-10-19 21:05:08] [index:background] Health check
[2023-10-19 21:07:51] [indexer:background] Health check
[2023-10-19 21:09:50] [index:background] Health check
[2023-10-19 21:12:36] [indexer:background] Health check
[2023-10-19 21:14:20] [index:background] Health check
[2023-10-19 21:16:42] [indexer:background] Health check
[2023-10-19 21:18:30] [index:background] Health check
[2023-10-19 21:21:51] [indexer:background] Health check
[2023-10-19 21:23:25] [index:background] Health check
[2023-10-19 21:27:07] [indexer:background] Health check
[2023-10-19 21:28:23] [index:background] Health check
[2023-10-19 21:33:21] [indexer:background] Health check
[2023-10-19 21:33:21] [index:background] Health check
[2023-10-19 21:37:14] [indexer:background] Health check
[2023-10-19 21:38:04] [index:background] Health check
[2023-10-19 21:41:56] [indexer:background] Health check
[2023-10-19 21:43:13] [index:background] Health check
[2023-10-19 21:49:55] [indexer:background] Health check
[2023-10-19 21:49:55] [index:background] Health check
[2023-10-19 21:52:41] [indexer:background] Health check
[2023-10-19 21:57:34] [index:background] Health check
[2023-10-19 21:57:35] [indexer:background] Health check
[2023-10-19 21:57:35] [indexer:background] Health check
[2023-10-19 21:59:32] [index:background] Health check
[2023-10-19 22:01:53] [indexer:background] Health check
[2023-10-19 22:04:01] [index:background] Health check
[2023-10-19 22:07:57] [indexer:background] Health check
[2023-10-19 22:08:28] [index:background] Health check
[2023-10-19 22:12:02] [indexer:background] Health check
[2023-10-19 22:14:17] [index:background] Health check
[2023-10-19 22:17:00] [indexer:background] Health check
[2023-10-19 22:18:24] [index:background] Health check
[2023-10-19 22:22:25] [indexer:background] Health check
[2023-10-19 22:24:21] [index:background] Health check
[2023-10-19 22:27:07] [indexer:background] Health check
[2023-10-19 22:28:13] [index:background] Health check
[2023-10-19 22:34:48] [indexer:background] Health check
[2023-10-19 22:34:48] [index:background] Health check
[2023-10-19 22:38:00] [indexer:background] Health check
[2023-10-19 22:39:20] [index:background] Health check
[2023-10-19 22:42:31] [indexer:background] Health check
[2023-10-19 22:44:29] [index:background] Health check
[2023-10-19 22:47:49] [indexer:background] Health check
[2023-10-19 22:48:55] [index:background] Health check
[2023-10-19 22:52:02] [indexer:background] Health check
[2023-10-19 22:54:19] [index:background] Health check
[2023-10-19 23:02:17] [indexer:background] Health check
[2023-10-19 23:02:17] [index:background] Health check
[2023-10-19 23:04:14] [index:background] Health check
[2023-10-19 23:06:56] [indexer:background] Health check
[2023-10-19 23:08:16] [index:background] Health check
[2023-10-19 23:12:31] [indexer:background] Health check
[2023-10-19 23:13:06] [index:background] Health check
[2023-10-19 23:17:56] [indexer:background] Health check
[2023-10-19 23:19:24] [index:background] Health check
[2023-10-19 23:22:14] [indexer:background] Health check
[2023-10-19 23:23:36] [index:background] Health check
[2023-10-19 23:28:37] [indexer:background] Health check
[2023-10-19 23:28:38] [index:background] Health check
[2023-10-19 23:31:49] [indexer:background] Health check
[2023-10-19 23:43:34] [index:background] Health check
[2023-10-19 23:43:34] [indexer:background] Health check
[2023-10-19 23:43:34] [indexer:background] Health check
[2023-10-19 23:47:32] [indexer:background] Health check
[2023-10-19 23:48:42] [index:background] Health check
[2023-10-19 23:49:15] [query] Query for: 2024
[2023-10-19 23:49:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-19 23:49:15] [query] Engine: default
[2023-10-19 23:49:15] [query] Tokens: 2024
[2023-10-19 23:49:15] [query] Mods: 6
[2023-10-19 23:49:15] [query] Found results using: or logic
[2023-10-19 23:49: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
[2023-10-19 23:49:15] [query] Results: 129 Pages of results: 13
[2023-10-19 23:49:15] [query] Execution time: 0.41546
[2023-10-19 23:49:15] [query] Query for: 2024
[2023-10-19 23:49:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-19 23:49:15] [query] Engine: default
[2023-10-19 23:49:15] [query] Tokens: 2024
[2023-10-19 23:49:15] [query] Mods: 6
[2023-10-19 23:49:15] [query] Found results using: or logic
[2023-10-19 23:49: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, 100
[2023-10-19 23:49:15] [query] Results: 129 Pages of results: 2
[2023-10-19 23:49:15] [query] Execution time: 0.08199
[2023-10-19 23:53:55] [indexer:background] Health check
[2023-10-19 23:53:55] [index:background] Health check
[2023-10-19 23:58:28] [indexer:background] Health check
[2023-10-19 23:58:28] [index:background] Health check