[2023-11-03 00:03:59] [index:background] Health check
[2023-11-03 00:05:44] [indexer:background] Health check
[2023-11-03 00:08:38] [index:background] Health check
[2023-11-03 00:09:55] [indexer:background] Health check
[2023-11-03 00:12:39] [index:background] Health check
[2023-11-03 00:14:58] [indexer:background] Health check
[2023-11-03 00:18:04] [index:background] Health check
[2023-11-03 00:21:01] [indexer:background] Health check
[2023-11-03 00:23:42] [index:background] Health check
[2023-11-03 00:25:22] [indexer:background] Health check
[2023-11-03 00:27:35] [index:background] Health check
[2023-11-03 00:30:04] [indexer:background] Health check
[2023-11-03 00:33:35] [index:background] Health check
[2023-11-03 00:34:55] [indexer:background] Health check
[2023-11-03 00:37:33] [index:background] Health check
[2023-11-03 00:39:35] [indexer:background] Health check
[2023-11-03 00:42:24] [index:background] Health check
[2023-11-03 00:45:41] [indexer:background] Health check
[2023-11-03 00:47:59] [index:background] Health check
[2023-11-03 00:50:16] [indexer:background] Health check
[2023-11-03 00:53:11] [index:background] Health check
[2023-11-03 00:55:20] [indexer:background] Health check
[2023-11-03 00:57:35] [index:background] Health check
[2023-11-03 01:00:03] [indexer:background] Health check
[2023-11-03 01:02:48] [index:background] Health check
[2023-11-03 01:04:46] [indexer:background] Health check
[2023-11-03 01:07:06] [query] Query for: 2024
[2023-11-03 01:07:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-03 01:07:06] [query] Engine: default
[2023-11-03 01:07:07] [query] Tokens: 2024
[2023-11-03 01:07:07] [query] Mods: 6
[2023-11-03 01:07:07] [query] Found results using: or logic
[2023-11-03 01:07:07] [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-11-03 01:07:07] [query] Results: 130 Pages of results: 13
[2023-11-03 01:07:07] [query] Execution time: 0.79449
[2023-11-03 01:11:04] [index:background] Health check
[2023-11-03 01:11:04] [indexer:background] Health check
[2023-11-03 01:11:04] [indexer:background] Health check
[2023-11-03 01:12:34] [index:background] Health check
[2023-11-03 01:15:29] [indexer:background] Health check
[2023-11-03 01:17:22] [index:background] Health check
[2023-11-03 01:20:00] [indexer:background] Health check
[2023-11-03 01:22:40] [index:background] Health check
[2023-11-03 01:24:48] [indexer:background] Health check
[2023-11-03 01:27:26] [index:background] Health check
[2023-11-03 01:29:51] [indexer:background] Health check
[2023-11-03 01:33:03] [index:background] Health check
[2023-11-03 01:34:40] [indexer:background] Health check
[2023-11-03 01:37:42] [index:background] Health check
[2023-11-03 01:40:52] [indexer:background] Health check
[2023-11-03 01:42:32] [index:background] Health check
[2023-11-03 01:44:58] [indexer:background] Health check
[2023-11-03 01:48:00] [index:background] Health check
[2023-11-03 01:50:16] [indexer:background] Health check
[2023-11-03 01:52:23] [index:background] Health check
[2023-11-03 01:54:38] [indexer:background] Health check
[2023-11-03 01:58:32] [index:background] Health check
[2023-11-03 01:59:47] [indexer:background] Health check
[2023-11-03 02:02:23] [index:background] Health check
[2023-11-03 02:05:44] [indexer:background] Health check
[2023-11-03 02:07:33] [index:background] Health check
[2023-11-03 02:09:35] [indexer:background] Health check
[2023-11-03 02:13:41] [index:background] Health check
[2023-11-03 02:15:38] [indexer:background] Health check
[2023-11-03 02:17:57] [index:background] Health check
[2023-11-03 02:21:38] [indexer:background] Health check
[2023-11-03 02:23:45] [index:background] Health check
[2023-11-03 02:24:54] [indexer:background] Health check
[2023-11-03 02:27:21] [index:background] Health check
[2023-11-03 02:29:36] [indexer:background] Health check
[2023-11-03 02:37:22] [index:background] Health check
[2023-11-03 02:37:22] [indexer:background] Health check
[2023-11-03 02:37:22] [indexer:background] Health check
[2023-11-03 02:40:08] [indexer:background] Health check
[2023-11-03 02:42:35] [index:background] Health check
[2023-11-03 02:42:35] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-11-03 02:42:37] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-11-03 02:45:12] [indexer:background] Health check
[2023-11-03 02:52:13] [index:background] Health check
[2023-11-03 02:52:13] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2023-11-03 02:52:15] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2023-11-03 02:52:17] [indexer:background] Health check
[2023-11-03 02:52:17] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2023-11-03 02:52:19] [indexer:background] Health check
[2023-11-03 02:52:19] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2023-11-03 02:52:49] [index:background] Health check
[2023-11-03 02:52:49] [index:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-11-03 02:52:51] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-11-03 02:54:43] [indexer:background] Health check
[2023-11-03 02:57:36] [index:background] Health check
[2023-11-03 02:57:36] [index:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-11-03 02:57:38] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-11-03 03:00:54] [indexer:background] Health check
[2023-11-03 03:03:56] [index:background] Health check
[2023-11-03 03:04:37] [indexer:background] Health check
[2023-11-03 03:04:37] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2023-11-03 03:07:43] [index:background] Health check
[2023-11-03 03:07:43] [index:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2023-11-03 03:07:45] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2]
[2023-11-03 03:10:27] [indexer:background] Health check
[2023-11-03 03:10:27] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-11-03 03:15:56] [index:background] Health check
[2023-11-03 03:15:56] [index:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2023-11-03 03:15:58] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2023-11-03 03:16:04] [indexer:background] Health check
[2023-11-03 03:16:04] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-11-03 03:16:06] [indexer:background] Health check
[2023-11-03 03:16:06] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2023-11-03 03:18:48] [index:background] Health check
[2023-11-03 03:18:48] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2023-11-03 03:18:51] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-11-03 03:21:40] [indexer:background] Health check
[2023-11-03 03:21:40] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-11-03 03:22:38] [index:background] Health check
[2023-11-03 03:22:38] [index:background] CPU load threshold (3) breached: 3.83 [waiting 2]
[2023-11-03 03:22:40] [indexer:background] CPU load threshold (3) breached: 3.83 [waiting 2]
[2023-11-03 03:24:34] [indexer:background] Health check
[2023-11-03 03:24:34] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2023-11-03 03:28:03] [index:background] Health check
[2023-11-03 03:28:03] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-11-03 03:28:05] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-11-03 03:29:35] [indexer:background] Health check
[2023-11-03 03:29:35] [indexer:background] CPU load threshold (3) breached: 3.82 [waiting 2]
[2023-11-03 03:32:32] [index:background] Health check
[2023-11-03 03:32:32] [index:background] CPU load threshold (3) breached: 3.62 [waiting 2]
[2023-11-03 03:32:34] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2]
[2023-11-03 03:35:07] [indexer:background] Health check
[2023-11-03 03:35:07] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2]
[2023-11-03 03:38:46] [index:background] Health check
[2023-11-03 03:38:46] [index:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-11-03 03:38:48] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-11-03 03:39:41] [indexer:background] Health check
[2023-11-03 03:39:41] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-11-03 03:42:46] [index:background] Health check
[2023-11-03 03:42:46] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2023-11-03 03:42:48] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2023-11-03 03:44:52] [indexer:background] Health check
[2023-11-03 03:47:42] [index:background] Health check
[2023-11-03 03:49:34] [indexer:background] Health check
[2023-11-03 03:52:53] [index:background] Health check
[2023-11-03 03:54:43] [indexer:background] Health check
[2023-11-03 03:57:24] [index:background] Health check
[2023-11-03 03:59:41] [indexer:background] Health check
[2023-11-03 04:02:33] [index:background] Health check
[2023-11-03 04:04:50] [indexer:background] Health check
[2023-11-03 04:07:23] [index:background] Health check
[2023-11-03 04:14:03] [indexer:background] Health check
[2023-11-03 04:14:04] [index:background] Health check
[2023-11-03 04:15:36] [indexer:background] Health check
[2023-11-03 04:17:29] [index:background] Health check
[2023-11-03 04:20:43] [indexer:background] Health check
[2023-11-03 04:23:13] [index:background] Health check
[2023-11-03 04:29:39] [indexer:background] Health check
[2023-11-03 04:29:39] [index:background] Health check
[2023-11-03 04:34:38] [index:background] Health check
[2023-11-03 04:34:38] [indexer:background] Health check
[2023-11-03 04:34:38] [indexer:background] Health check
[2023-11-03 04:39:21] [index:background] Health check
[2023-11-03 04:44:04] [indexer:background] Health check
[2023-11-03 04:44:04] [index:background] Health check
[2023-11-03 04:45:41] [indexer:background] Health check
[2023-11-03 04:47:56] [index:background] Health check
[2023-11-03 04:50:18] [indexer:background] Health check
[2023-11-03 04:56:01] [index:background] Health check
[2023-11-03 04:56:01] [indexer:background] Health check
[2023-11-03 04:56:01] [indexer:background] Health check
[2023-11-03 04:57:43] [index:background] Health check
[2023-11-03 05:00:52] [indexer:background] Health check
[2023-11-03 05:02:29] [index:background] Health check
[2023-11-03 05:04:46] [indexer:background] Health check
[2023-11-03 05:06:38] [query] Query for: 2023
[2023-11-03 05:06:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-03 05:06:38] [query] Engine: default
[2023-11-03 05:06:38] [query] Tokens: 2023
[2023-11-03 05:06:38] [query] Mods: 6
[2023-11-03 05:06:38] [query] Found results using: or logic
[2023-11-03 05:06:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-11-03 05:06:38] [query] Results: 251 Pages of results: 26
[2023-11-03 05:06:38] [query] Execution time: 0.78954
[2023-11-03 05:06:38] [query] Query for: 2023
[2023-11-03 05:06:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-03 05:06:38] [query] Engine: default
[2023-11-03 05:06:38] [query] Tokens: 2023
[2023-11-03 05:06:38] [query] Mods: 6
[2023-11-03 05:06:39] [query] Found results using: or logic
[2023-11-03 05:06:39] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2023-11-03 05:06:39] [query] Results: 251 Pages of results: 3
[2023-11-03 05:06:39] [query] Execution time: 0.10350
[2023-11-03 05:08:13] [index:background] Health check
[2023-11-03 05:09:41] [indexer:background] Health check
[2023-11-03 05:12:28] [index:background] Health check
[2023-11-03 05:17:03] [indexer:background] Health check
[2023-11-03 05:18:21] [index:background] Health check
[2023-11-03 05:21:02] [indexer:background] Health check
[2023-11-03 05:22:44] [index:background] Health check
[2023-11-03 05:25:34] [indexer:background] Health check
[2023-11-03 05:27:37] [index:background] Health check
[2023-11-03 05:30:38] [indexer:background] Health check
[2023-11-03 05:32:29] [index:background] Health check
[2023-11-03 05:35:43] [indexer:background] Health check
[2023-11-03 05:37:24] [index:background] Health check
[2023-11-03 05:40:54] [indexer:background] Health check
[2023-11-03 05:42:52] [index:background] Health check
[2023-11-03 05:44:39] [indexer:background] Health check
[2023-11-03 05:47:21] [index:background] Health check
[2023-11-03 05:49:59] [indexer:background] Health check
[2023-11-03 05:52:22] [index:background] Health check
[2023-11-03 05:54:51] [indexer:background] Health check
[2023-11-03 05:57:45] [index:background] Health check
[2023-11-03 05:59:56] [indexer:background] Health check
[2023-11-03 06:03:10] [index:background] Health check
[2023-11-03 06:04:54] [indexer:background] Health check
[2023-11-03 06:08:20] [index:background] Health check
[2023-11-03 06:09:49] [indexer:background] Health check
[2023-11-03 06:12:42] [index:background] Health check
[2023-11-03 06:15:55] [indexer:background] Health check
[2023-11-03 06:18:06] [index:background] Health check
[2023-11-03 06:20:41] [indexer:background] Health check
[2023-11-03 06:22:25] [index:background] Health check
[2023-11-03 06:24:47] [indexer:background] Health check
[2023-11-03 06:28:20] [index:background] Health check
[2023-11-03 06:29:42] [indexer:background] Health check
[2023-11-03 06:32:26] [index:background] Health check
[2023-11-03 06:34:36] [indexer:background] Health check
[2023-11-03 06:38:12] [index:background] Health check
[2023-11-03 06:40:32] [indexer:background] Health check
[2023-11-03 06:45:45] [index:background] Health check
[2023-11-03 06:45:45] [indexer:background] Health check
[2023-11-03 06:45:45] [indexer:background] Health check
[2023-11-03 06:47:35] [index:background] Health check
[2023-11-03 06:49:51] [indexer:background] Health check
[2023-11-03 06:56:11] [index:background] Health check
[2023-11-03 06:56:11] [indexer:background] Health check
[2023-11-03 06:56:11] [indexer:background] Health check
[2023-11-03 06:58:13] [index:background] Health check
[2023-11-03 06:59:49] [indexer:background] Health check
[2023-11-03 07:02:36] [index:background] Health check
[2023-11-03 07:04:54] [indexer:background] Health check
[2023-11-03 07:07:41] [index:background] Health check
[2023-11-03 07:13:49] [indexer:background] Health check
[2023-11-03 07:13:50] [index:background] Health check
[2023-11-03 07:14:51] [indexer:background] Health check
[2023-11-03 07:17:42] [index:background] Health check
[2023-11-03 07:21:33] [indexer:background] Health check
[2023-11-03 07:24:22] [index:background] Health check
[2023-11-03 07:27:05] [indexer:background] Health check
[2023-11-03 07:27:41] [index:background] Health check
[2023-11-03 07:29:38] [indexer:background] Health check
[2023-11-03 07:32:23] [index:background] Health check
[2023-11-03 07:35:07] [indexer:background] Health check
[2023-11-03 07:37:50] [index:background] Health check
[2023-11-03 07:39:40] [indexer:background] Health check
[2023-11-03 07:42:35] [index:background] Health check
[2023-11-03 07:44:46] [indexer:background] Health check
[2023-11-03 07:48:18] [index:background] Health check
[2023-11-03 07:49:44] [indexer:background] Health check
[2023-11-03 07:53:11] [index:background] Health check
[2023-11-03 07:55:06] [indexer:background] Health check
[2023-11-03 07:57:45] [index:background] Health check
[2023-11-03 08:00:20] [indexer:background] Health check
[2023-11-03 08:02:33] [index:background] Health check
[2023-11-03 08:05:39] [indexer:background] Health check
[2023-11-03 08:07:45] [index:background] Health check
[2023-11-03 08:10:43] [indexer:background] Health check
[2023-11-03 08:13:49] [index:background] Health check
[2023-11-03 08:14:45] [indexer:background] Health check
[2023-11-03 08:17:29] [index:background] Health check
[2023-11-03 08:20:24] [indexer:background] Health check
[2023-11-03 08:23:11] [index:background] Health check
[2023-11-03 08:25:14] [indexer:background] Health check
[2023-11-03 08:27:24] [index:background] Health check
[2023-11-03 08:31:18] [indexer:background] Health check
[2023-11-03 08:32:54] [index:background] Health check
[2023-11-03 08:35:26] [indexer:background] Health check
[2023-11-03 08:38:48] [index:background] Health check
[2023-11-03 08:39:59] [indexer:background] Health check
[2023-11-03 08:43:19] [index:background] Health check
[2023-11-03 08:45:09] [indexer:background] Health check
[2023-11-03 08:47:35] [index:background] Health check
[2023-11-03 08:50:14] [indexer:background] Health check
[2023-11-03 08:54:29] [index:background] Health check
[2023-11-03 08:56:48] [indexer:background] Health check
[2023-11-03 08:58:13] [index:background] Health check
[2023-11-03 08:59:32] [indexer:background] Health check
[2023-11-03 09:02:25] [index:background] Health check
[2023-11-03 09:02:25] [index:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-11-03 09:02:27] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2023-11-03 09:04:37] [indexer:background] Health check
[2023-11-03 09:08:21] [index:background] Health check
[2023-11-03 09:08:21] [index:background] CPU load threshold (3) breached: 4.1 [waiting 2]
[2023-11-03 09:08:23] [indexer:background] CPU load threshold (3) breached: 4.01 [waiting 2]
[2023-11-03 09:10:02] [indexer:background] Health check
[2023-11-03 09:10:02] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2023-11-03 09:13:45] [index:background] Health check
[2023-11-03 09:15:34] [indexer:background] Health check
[2023-11-03 09:18:18] [index:background] Health check
[2023-11-03 09:20:02] [indexer:background] Health check
[2023-11-03 09:23:51] [index:background] Health check
[2023-11-03 09:24:42] [indexer:background] Health check
[2023-11-03 09:29:40] [index:background] Health check
[2023-11-03 09:29:42] [indexer:background] Health check
[2023-11-03 09:29:42] [indexer:background] Health check
[2023-11-03 09:32:41] [index:background] Health check
[2023-11-03 09:34:41] [indexer:background] Health check
[2023-11-03 09:37:24] [index:background] Health check
[2023-11-03 09:40:10] [indexer:background] Health check
[2023-11-03 09:42:23] [index:background] Health check
[2023-11-03 09:45:01] [indexer:background] Health check
[2023-11-03 09:47:32] [index:background] Health check
[2023-11-03 09:50:45] [indexer:background] Health check
[2023-11-03 09:52:49] [index:background] Health check
[2023-11-03 09:54:55] [indexer:background] Health check
[2023-11-03 09:58:10] [index:background] Health check
[2023-11-03 10:00:09] [indexer:background] Health check
[2023-11-03 10:03:37] [index:background] Health check
[2023-11-03 10:04:59] [indexer:background] Health check
[2023-11-03 10:08:08] [index:background] Health check
[2023-11-03 10:09:37] [indexer:background] Health check
[2023-11-03 10:12:32] [index:background] Health check
[2023-11-03 10:12:32] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-11-03 10:12:34] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-11-03 10:14:58] [indexer:background] Health check
[2023-11-03 10:17:33] [index:background] Health check
[2023-11-03 10:19:39] [indexer:background] Health check
[2023-11-03 10:22:38] [index:background] Health check
[2023-11-03 10:25:32] [indexer:background] Health check
[2023-11-03 10:25:32] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-11-03 10:29:00] [index:background] Health check
[2023-11-03 10:30:21] [indexer:background] Health check
[2023-11-03 10:32:24] [index:background] Health check
[2023-11-03 10:34:47] [indexer:background] Health check
[2023-11-03 10:37:50] [index:background] Health check
[2023-11-03 10:40:22] [indexer:background] Health check
[2023-11-03 10:43:29] [index:background] Health check
[2023-11-03 10:44:56] [indexer:background] Health check
[2023-11-03 10:47:41] [index:background] Health check
[2023-11-03 10:49:37] [indexer:background] Health check
[2023-11-03 10:52:37] [index:background] Health check
[2023-11-03 10:55:57] [indexer:background] Health check
[2023-11-03 10:58:46] [index:background] Health check
[2023-11-03 11:00:02] [indexer:background] Health check
[2023-11-03 11:02:54] [index:background] Health check
[2023-11-03 11:03:51] [index] Marking post.attachment 13999 to be dropped
[2023-11-03 11:03:54] [index] Dropping post.attachment 13999
[2023-11-03 11:03:54] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-03 11:03:56] [indexer] Queued next batch (1)
[2023-11-03 11:03:56] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-03 11:04:00] [indexer] Processing batch (1)
[2023-11-03 11:04:00] [indexer] Indexing post.attachment:13999
[2023-11-03 11:04:00] [index] Marking [1] post.attachment 13999 as indexed
[2023-11-03 11:04:00] [indexer] Index built
[2023-11-03 11:04:00] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2]
[2023-11-03 11:04:38] [indexer:background] Health check
[2023-11-03 11:08:29] [index:background] Health check
[2023-11-03 11:10:55] [indexer:background] Health check
[2023-11-03 11:12:32] [index:background] Health check
[2023-11-03 11:14:53] [indexer:background] Health check
[2023-11-03 11:17:27] [index:background] Health check
[2023-11-03 11:19:52] [indexer:background] Health check
[2023-11-03 11:23:09] [index:background] Health check
[2023-11-03 11:27:18] [indexer:background] Health check
[2023-11-03 11:27:28] [index:background] Health check
[2023-11-03 11:29:54] [indexer:background] Health check
[2023-11-03 11:33:17] [index:background] Health check
[2023-11-03 11:35:19] [indexer:background] Health check
[2023-11-03 11:37:39] [index:background] Health check
[2023-11-03 11:39:55] [indexer:background] Health check
[2023-11-03 11:43:00] [index:background] Health check
[2023-11-03 11:44:36] [indexer:background] Health check
[2023-11-03 11:45:44] [query] Query for: 2023
[2023-11-03 11:45:44] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-03 11:45:44] [query] Engine: default
[2023-11-03 11:45:45] [query] Tokens: 2023
[2023-11-03 11:45:45] [query] Mods: 6
[2023-11-03 11:45:45] [query] Found results using: or logic
[2023-11-03 11:45:45] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-03 11:45:45] [query] Results: 252 Pages of results: 26
[2023-11-03 11:45:45] [query] Execution time: 1.25176
[2023-11-03 11:45:45] [query] Query for: 2023
[2023-11-03 11:45:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-03 11:45:45] [query] Engine: default
[2023-11-03 11:45:45] [query] Tokens: 2023
[2023-11-03 11:45:45] [query] Mods: 6
[2023-11-03 11:45:45] [query] Found results using: or logic
[2023-11-03 11:45:45] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2023-11-03 11:45:45] [query] Results: 252 Pages of results: 3
[2023-11-03 11:45:45] [query] Execution time: 0.09280
[2023-11-03 11:47:30] [index:background] Health check
[2023-11-03 11:50:12] [indexer:background] Health check
[2023-11-03 11:53:52] [index:background] Health check
[2023-11-03 11:57:14] [indexer:background] Health check
[2023-11-03 11:57:36] [index:background] Health check
[2023-11-03 12:01:17] [indexer:background] Health check
[2023-11-03 12:02:39] [index:background] Health check
[2023-11-03 12:04:58] [indexer:background] Health check
[2023-11-03 12:09:30] [index:background] Health check
[2023-11-03 12:09:34] [indexer:background] Health check
[2023-11-03 12:12:27] [index:background] Health check
[2023-11-03 12:15:13] [indexer:background] Health check
[2023-11-03 12:18:02] [index:background] Health check
[2023-11-03 12:20:41] [indexer:background] Health check
[2023-11-03 12:22:31] [index:background] Health check
[2023-11-03 12:24:35] [indexer:background] Health check
[2023-11-03 12:27:35] [index:background] Health check
[2023-11-03 12:30:27] [indexer:background] Health check
[2023-11-03 12:33:08] [index:background] Health check
[2023-11-03 12:34:34] [indexer:background] Health check
[2023-11-03 12:40:16] [index:background] Health check
[2023-11-03 12:40:16] [indexer:background] Health check
[2023-11-03 12:40:16] [indexer:background] Health check
[2023-11-03 12:43:04] [index:background] Health check
[2023-11-03 12:45:31] [indexer:background] Health check
[2023-11-03 12:48:04] [index:background] Health check
[2023-11-03 12:49:55] [indexer:background] Health check
[2023-11-03 12:52:34] [index:background] Health check
[2023-11-03 12:55:30] [indexer:background] Health check
[2023-11-03 12:58:23] [index:background] Health check
[2023-11-03 12:59:41] [indexer:background] Health check
[2023-11-03 13:02:24] [index:background] Health check
[2023-11-03 13:05:02] [indexer:background] Health check
[2023-11-03 13:08:02] [index:background] Health check
[2023-11-03 13:09:39] [indexer:background] Health check
[2023-11-03 13:13:07] [index:background] Health check
[2023-11-03 13:14:52] [indexer:background] Health check
[2023-11-03 13:17:40] [index:background] Health check
[2023-11-03 13:20:13] [indexer:background] Health check
[2023-11-03 13:23:18] [index:background] Health check
[2023-11-03 13:25:14] [indexer:background] Health check
[2023-11-03 13:28:47] [index:background] Health check
[2023-11-03 13:29:48] [indexer:background] Health check
[2023-11-03 13:32:58] [index:background] Health check
[2023-11-03 13:37:05] [indexer:background] Health check
[2023-11-03 13:37:58] [index:background] Health check
[2023-11-03 13:39:53] [indexer:background] Health check
[2023-11-03 13:42:42] [index:background] Health check
[2023-11-03 13:44:50] [indexer:background] Health check
[2023-11-03 13:51:46] [index:background] Health check
[2023-11-03 13:51:46] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-11-03 13:51:48] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-11-03 13:51:52] [indexer:background] Health check
[2023-11-03 13:51:52] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2023-11-03 13:51:54] [indexer:background] Health check
[2023-11-03 13:51:54] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2023-11-03 13:52:35] [index:background] Health check
[2023-11-03 13:54:39] [indexer:background] Health check
[2023-11-03 13:58:07] [index:background] Health check
[2023-11-03 13:59:50] [indexer:background] Health check
[2023-11-03 14:03:38] [index:background] Health check
[2023-11-03 14:04:51] [indexer:background] Health check
[2023-11-03 14:08:16] [index:background] Health check
[2023-11-03 14:08:16] [index:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2023-11-03 14:08:19] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2023-11-03 14:10:13] [indexer:background] Health check
[2023-11-03 14:12:31] [index:background] Health check
[2023-11-03 14:15:18] [indexer:background] Health check
[2023-11-03 14:18:24] [index:background] Health check
[2023-11-03 14:20:12] [indexer:background] Health check
[2023-11-03 14:25:15] [index:background] Health check
[2023-11-03 14:25:15] [indexer:background] Health check
[2023-11-03 14:25:15] [indexer:background] Health check
[2023-11-03 14:27:30] [index:background] Health check
[2023-11-03 14:27:30] [index:background] Health check
[2023-11-03 14:29:37] [indexer:background] Health check
[2023-11-03 14:32:23] [index:background] Health check
[2023-11-03 14:34:53] [indexer:background] Health check
[2023-11-03 14:38:26] [index:background] Health check
[2023-11-03 14:41:09] [indexer:background] Health check
[2023-11-03 14:42:22] [index:background] Health check
[2023-11-03 14:45:16] [indexer:background] Health check
[2023-11-03 14:47:37] [index:background] Health check
[2023-11-03 14:52:31] [indexer:background] Health check
[2023-11-03 14:52:33] [index:background] Health check
[2023-11-03 14:55:40] [indexer:background] Health check
[2023-11-03 14:57:45] [index:background] Health check
[2023-11-03 15:00:26] [indexer:background] Health check
[2023-11-03 15:02:24] [index:background] Health check
[2023-11-03 15:04:37] [indexer:background] Health check
[2023-11-03 15:07:22] [index:background] Health check
[2023-11-03 15:09:59] [indexer:background] Health check
[2023-11-03 15:12:54] [index:background] Health check
[2023-11-03 15:14:49] [indexer:background] Health check
[2023-11-03 15:17:24] [index:background] Health check
[2023-11-03 15:20:20] [indexer:background] Health check
[2023-11-03 15:23:15] [index:background] Health check
[2023-11-03 15:25:47] [indexer:background] Health check
[2023-11-03 15:28:21] [index:background] Health check
[2023-11-03 15:32:24] [indexer:background] Health check
[2023-11-03 15:32:24] [index:background] Health check
[2023-11-03 15:35:07] [indexer:background] Health check
[2023-11-03 15:37:37] [index:background] Health check
[2023-11-03 15:40:45] [indexer:background] Health check
[2023-11-03 15:43:25] [index:background] Health check
[2023-11-03 15:44:59] [indexer:background] Health check
[2023-11-03 15:47:24] [index:background] Health check
[2023-11-03 15:50:28] [indexer:background] Health check
[2023-11-03 15:53:13] [index:background] Health check
[2023-11-03 15:54:56] [indexer:background] Health check
[2023-11-03 15:58:48] [index:background] Health check
[2023-11-03 15:59:41] [indexer:background] Health check
[2023-11-03 16:05:07] [index:background] Health check
[2023-11-03 16:05:07] [indexer:background] Health check
[2023-11-03 16:05:07] [indexer:background] Health check
[2023-11-03 16:08:28] [index:background] Health check
[2023-11-03 16:09:37] [indexer:background] Health check
[2023-11-03 16:13:06] [index:background] Health check
[2023-11-03 16:15:32] [indexer:background] Health check
[2023-11-03 16:19:59] [index:background] Health check
[2023-11-03 16:19:59] [indexer:background] Health check
[2023-11-03 16:19:59] [indexer:background] Health check
[2023-11-03 16:22:28] [index:background] Health check
[2023-11-03 16:24:54] [indexer:background] Health check
[2023-11-03 16:28:49] [index:background] Health check
[2023-11-03 16:29:50] [indexer:background] Health check
[2023-11-03 16:33:38] [index:background] Health check
[2023-11-03 16:35:32] [indexer:background] Health check
[2023-11-03 16:37:39] [index:background] Health check
[2023-11-03 16:42:23] [indexer:background] Health check
[2023-11-03 16:42:23] [index:background] Health check
[2023-11-03 16:45:49] [indexer:background] Health check
[2023-11-03 16:47:22] [index:background] Health check
[2023-11-03 16:51:50] [indexer:background] Health check
[2023-11-03 16:52:36] [index:background] Health check
[2023-11-03 16:55:03] [indexer:background] Health check
[2023-11-03 17:02:24] [index:background] Health check
[2023-11-03 17:02:27] [indexer:background] Health check
[2023-11-03 17:02:27] [indexer:background] Health check
[2023-11-03 17:04:35] [indexer:background] Health check
[2023-11-03 17:09:14] [index:background] Health check
[2023-11-03 17:09:36] [indexer:background] Health check
[2023-11-03 17:13:03] [index:background] Health check
[2023-11-03 17:15:24] [indexer:background] Health check
[2023-11-03 17:17:27] [index:background] Health check
[2023-11-03 17:19:34] [indexer:background] Health check
[2023-11-03 17:22:24] [index:background] Health check
[2023-11-03 17:24:38] [indexer:background] Health check
[2023-11-03 17:27:25] [index:background] Health check
[2023-11-03 17:29:35] [indexer:background] Health check
[2023-11-03 17:32:23] [index:background] Health check
[2023-11-03 17:34:36] [indexer:background] Health check
[2023-11-03 17:37:29] [index:background] Health check
[2023-11-03 17:39:41] [indexer:background] Health check
[2023-11-03 17:42:22] [index:background] Health check
[2023-11-03 17:45:06] [indexer:background] Health check
[2023-11-03 17:48:09] [index:background] Health check
[2023-11-03 17:48:09] [index:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-03 17:48:11] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-03 17:49:34] [indexer:background] Health check
[2023-11-03 17:52:27] [index:background] Health check
[2023-11-03 17:54:36] [indexer:background] Health check
[2023-11-03 17:58:30] [index:background] Health check
[2023-11-03 18:00:23] [indexer:background] Health check
[2023-11-03 18:02:35] [index:background] Health check
[2023-11-03 18:04:33] [indexer:background] Health check
[2023-11-03 18:07:31] [index:background] Health check
[2023-11-03 18:10:21] [indexer:background] Health check
[2023-11-03 18:12:22] [index:background] Health check
[2023-11-03 18:14:48] [indexer:background] Health check
[2023-11-03 18:17:27] [index:background] Health check
[2023-11-03 18:20:10] [indexer:background] Health check
[2023-11-03 18:22:46] [index:background] Health check
[2023-11-03 18:30:20] [indexer:background] Health check
[2023-11-03 18:30:20] [index:background] Health check
[2023-11-03 18:32:23] [index:background] Health check
[2023-11-03 18:34:38] [indexer:background] Health check
[2023-11-03 18:39:41] [index:background] Health check
[2023-11-03 18:39:41] [indexer:background] Health check
[2023-11-03 18:39:41] [indexer:background] Health check
[2023-11-03 18:44:41] [index:background] Health check
[2023-11-03 18:44:41] [indexer:background] Health check
[2023-11-03 18:44:41] [indexer:background] Health check
[2023-11-03 18:47:54] [index:background] Health check
[2023-11-03 18:49:54] [indexer:background] Health check
[2023-11-03 18:54:06] [index:background] Health check
[2023-11-03 18:54:41] [indexer:background] Health check
[2023-11-03 18:57:23] [index:background] Health check
[2023-11-03 19:00:32] [indexer:background] Health check
[2023-11-03 19:03:46] [index:background] Health check
[2023-11-03 19:05:11] [indexer:background] Health check
[2023-11-03 19:08:05] [index:background] Health check
[2023-11-03 19:09:49] [indexer:background] Health check
[2023-11-03 19:13:48] [index:background] Health check
[2023-11-03 19:15:07] [indexer:background] Health check
[2023-11-03 19:18:41] [index:background] Health check
[2023-11-03 19:20:32] [indexer:background] Health check
[2023-11-03 19:23:32] [index:background] Health check
[2023-11-03 19:26:10] [indexer:background] Health check
[2023-11-03 19:28:27] [index:background] Health check
[2023-11-03 19:29:53] [indexer:background] Health check
[2023-11-03 19:33:29] [index:background] Health check
[2023-11-03 19:35:21] [indexer:background] Health check
[2023-11-03 19:37:45] [index:background] Health check
[2023-11-03 19:39:52] [indexer:background] Health check
[2023-11-03 19:44:36] [index:background] Health check
[2023-11-03 19:44:36] [indexer:background] Health check
[2023-11-03 19:44:36] [indexer:background] Health check
[2023-11-03 19:50:18] [index:background] Health check
[2023-11-03 19:50:19] [indexer:background] Health check
[2023-11-03 19:50:19] [indexer:background] Health check
[2023-11-03 19:53:32] [index:background] Health check
[2023-11-03 19:55:13] [indexer:background] Health check
[2023-11-03 19:55:33] [query] Query for: 2024
[2023-11-03 19:55:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-03 19:55:33] [query] Engine: default
[2023-11-03 19:55:34] [query] Tokens: 2024
[2023-11-03 19:55:34] [query] Mods: 6
[2023-11-03 19:55:50] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-03 19:55:50] [query] Results: 1 Pages of results: 1
[2023-11-03 19:55:50] [query] Execution time: 16.75613
[2023-11-03 19:57:45] [index:background] Health check
[2023-11-03 20:01:39] [query] Query for: 2023
[2023-11-03 20:01:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-03 20:01:39] [query] Engine: default
[2023-11-03 20:01:39] [query] Tokens: 2023
[2023-11-03 20:01:39] [query] Mods: 6
[2023-11-03 20:01:39] [query] Found results using: or logic
[2023-11-03 20:01:39] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-03 20:01:39] [query] Results: 252 Pages of results: 26
[2023-11-03 20:01:39] [query] Execution time: 0.37136
[2023-11-03 20:02:51] [indexer:background] Health check
[2023-11-03 20:02:52] [indexer:background] Health check
[2023-11-03 20:02:52] [index:background] Health check
[2023-11-03 20:04:39] [indexer:background] Health check
[2023-11-03 20:07:24] [index:background] Health check
[2023-11-03 20:09:48] [indexer:background] Health check
[2023-11-03 20:12:45] [index:background] Health check
[2023-11-03 20:14:47] [indexer:background] Health check
[2023-11-03 20:18:07] [index:background] Health check
[2023-11-03 20:21:58] [indexer:background] Health check
[2023-11-03 20:25:26] [index:background] Health check
[2023-11-03 20:25:27] [indexer:background] Health check
[2023-11-03 20:25:27] [indexer:background] Health check
[2023-11-03 20:27:55] [index:background] Health check
[2023-11-03 20:29:59] [indexer:background] Health check
[2023-11-03 20:32:22] [index:background] Health check
[2023-11-03 20:34:36] [indexer:background] Health check
[2023-11-03 20:40:40] [index:background] Health check
[2023-11-03 20:40:40] [indexer:background] Health check
[2023-11-03 20:40:40] [indexer:background] Health check
[2023-11-03 20:42:28] [index:background] Health check
[2023-11-03 20:45:56] [indexer:background] Health check
[2023-11-03 20:49:49] [index:background] Health check
[2023-11-03 20:49:49] [indexer:background] Health check
[2023-11-03 20:49:49] [indexer:background] Health check
[2023-11-03 20:53:32] [index:background] Health check
[2023-11-03 20:54:36] [indexer:background] Health check
[2023-11-03 20:57:53] [index:background] Health check
[2023-11-03 21:03:18] [indexer:background] Health check
[2023-11-03 21:03:18] [index:background] Health check
[2023-11-03 21:05:56] [indexer:background] Health check
[2023-11-03 21:07:58] [index:background] Health check
[2023-11-03 21:10:42] [indexer:background] Health check
[2023-11-03 21:12:48] [index:background] Health check
[2023-11-03 21:14:46] [indexer:background] Health check
[2023-11-03 21:17:52] [index:background] Health check
[2023-11-03 21:20:00] [indexer:background] Health check
[2023-11-03 21:23:02] [index:background] Health check
[2023-11-03 21:24:33] [indexer:background] Health check
[2023-11-03 21:27:49] [index:background] Health check
[2023-11-03 21:29:46] [indexer:background] Health check
[2023-11-03 21:33:38] [index:background] Health check
[2023-11-03 21:35:50] [indexer:background] Health check
[2023-11-03 21:39:23] [index:background] Health check
[2023-11-03 21:41:18] [indexer:background] Health check
[2023-11-03 21:42:25] [index:background] Health check
[2023-11-03 21:46:21] [indexer:background] Health check
[2023-11-03 21:49:47] [index:background] Health check
[2023-11-03 21:49:47] [indexer:background] Health check
[2023-11-03 21:49:47] [indexer:background] Health check
[2023-11-03 21:52:23] [index:background] Health check
[2023-11-03 21:54:50] [indexer:background] Health check
[2023-11-03 22:00:16] [index:background] Health check
[2023-11-03 22:00:16] [indexer:background] Health check
[2023-11-03 22:00:16] [indexer:background] Health check
[2023-11-03 22:03:02] [index:background] Health check
[2023-11-03 22:05:14] [indexer:background] Health check
[2023-11-03 22:07:26] [index:background] Health check
[2023-11-03 22:15:28] [indexer:background] Health check
[2023-11-03 22:15:29] [index:background] Health check
[2023-11-03 22:18:22] [index:background] Health check
[2023-11-03 22:20:25] [indexer:background] Health check
[2023-11-03 22:24:19] [index:background] Health check
[2023-11-03 22:25:36] [indexer:background] Health check
[2023-11-03 22:28:04] [index:background] Health check
[2023-11-03 22:29:49] [indexer:background] Health check
[2023-11-03 22:34:57] [index:background] Health check
[2023-11-03 22:34:57] [indexer:background] Health check
[2023-11-03 22:34:57] [indexer:background] Health check
[2023-11-03 22:37:56] [index:background] Health check
[2023-11-03 22:41:11] [indexer:background] Health check
[2023-11-03 22:42:23] [index:background] Health check
[2023-11-03 22:45:19] [indexer:background] Health check
[2023-11-03 22:47:23] [index:background] Health check
[2023-11-03 22:52:08] [indexer:background] Health check
[2023-11-03 22:52:42] [index:background] Health check
[2023-11-03 22:54:34] [indexer:background] Health check
[2023-11-03 22:58:07] [index:background] Health check
[2023-11-03 23:00:44] [indexer:background] Health check
[2023-11-03 23:06:53] [index:background] Health check
[2023-11-03 23:06:53] [indexer:background] Health check
[2023-11-03 23:06:53] [indexer:background] Health check
[2023-11-03 23:08:13] [index:background] Health check
[2023-11-03 23:09:58] [indexer:background] Health check
[2023-11-03 23:12:40] [index:background] Health check
[2023-11-03 23:15:54] [indexer:background] Health check
[2023-11-03 23:17:23] [index:background] Health check
[2023-11-03 23:19:48] [indexer:background] Health check
[2023-11-03 23:22:31] [index:background] Health check
[2023-11-03 23:24:56] [indexer:background] Health check
[2023-11-03 23:27:39] [index:background] Health check
[2023-11-03 23:30:29] [indexer:background] Health check
[2023-11-03 23:32:51] [index:background] Health check
[2023-11-03 23:35:24] [indexer:background] Health check
[2023-11-03 23:40:50] [index:background] Health check
[2023-11-03 23:40:50] [indexer:background] Health check
[2023-11-03 23:40:50] [indexer:background] Health check
[2023-11-03 23:40:50] [query] Query for: 2024
[2023-11-03 23:40:50] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-03 23:40:50] [query] Engine: default
[2023-11-03 23:40:50] [query] Tokens: 2024
[2023-11-03 23:40:50] [query] Mods: 6
[2023-11-03 23:40:51] [query] Found results using: or logic
[2023-11-03 23:40:51] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-03 23:40:51] [query] Results: 130 Pages of results: 13
[2023-11-03 23:40:51] [query] Execution time: 0.48315
[2023-11-03 23:40:51] [query] Query for: 2024
[2023-11-03 23:40:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-03 23:40:51] [query] Engine: default
[2023-11-03 23:40:51] [query] Tokens: 2024
[2023-11-03 23:40:51] [query] Mods: 6
[2023-11-03 23:40:51] [query] Found results using: or logic
[2023-11-03 23:40:51] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-03 23:40:51] [query] Results: 130 Pages of results: 2
[2023-11-03 23:40:51] [query] Execution time: 0.07357
[2023-11-03 23:42:31] [index:background] Health check
[2023-11-03 23:46:23] [indexer:background] Health check
[2023-11-03 23:48:00] [index:background] Health check
[2023-11-03 23:50:17] [indexer:background] Health check
[2023-11-03 23:52:24] [index:background] Health check
[2023-11-03 23:54:33] [indexer:background] Health check
[2023-11-03 23:57:33] [index:background] Health check
[2023-11-03 23:59:36] [indexer:background] Health check