[2023-11-08 00:05:37] [index:background] Health check
[2023-11-08 00:05:37] [indexer:background] Health check
[2023-11-08 00:05:37] [indexer:background] Health check
[2023-11-08 00:10:04] [index:background] Health check
[2023-11-08 00:10:04] [indexer:background] Health check
[2023-11-08 00:10:04] [indexer:background] Health check
[2023-11-08 00:13:09] [index:background] Health check
[2023-11-08 00:15:23] [indexer:background] Health check
[2023-11-08 00:18:54] [index:background] Health check
[2023-11-08 00:19:38] [indexer:background] Health check
[2023-11-08 00:24:10] [index:background] Health check
[2023-11-08 00:24:43] [indexer:background] Health check
[2023-11-08 00:28:25] [index:background] Health check
[2023-11-08 00:29:35] [indexer:background] Health check
[2023-11-08 00:33:29] [index:background] Health check
[2023-11-08 00:36:33] [indexer:background] Health check
[2023-11-08 00:38:10] [index:background] Health check
[2023-11-08 00:40:26] [indexer:background] Health check
[2023-11-08 00:43:02] [index:background] Health check
[2023-11-08 00:45:09] [indexer:background] Health check
[2023-11-08 00:48:55] [index:background] Health check
[2023-11-08 00:50:25] [indexer:background] Health check
[2023-11-08 00:53:42] [index:background] Health check
[2023-11-08 00:55:05] [indexer:background] Health check
[2023-11-08 00:58:13] [index:background] Health check
[2023-11-08 00:59:33] [indexer:background] Health check
[2023-11-08 01:03:35] [index:background] Health check
[2023-11-08 01:04:46] [indexer:background] Health check
[2023-11-08 01:08:03] [index:background] Health check
[2023-11-08 01:09:35] [indexer:background] Health check
[2023-11-08 01:13:05] [index:background] Health check
[2023-11-08 01:14:34] [indexer:background] Health check
[2023-11-08 01:18:05] [index:background] Health check
[2023-11-08 01:19:35] [indexer:background] Health check
[2023-11-08 01:23:03] [index:background] Health check
[2023-11-08 01:24:36] [indexer:background] Health check
[2023-11-08 01:28:43] [index:background] Health check
[2023-11-08 01:31:02] [indexer:background] Health check
[2023-11-08 01:33:07] [index:background] Health check
[2023-11-08 01:35:26] [indexer:background] Health check
[2023-11-08 01:38:20] [index:background] Health check
[2023-11-08 01:39:54] [indexer:background] Health check
[2023-11-08 01:43:26] [index:background] Health check
[2023-11-08 01:45:01] [indexer:background] Health check
[2023-11-08 01:48:03] [index:background] Health check
[2023-11-08 01:50:42] [indexer:background] Health check
[2023-11-08 01:53:19] [index:background] Health check
[2023-11-08 01:55:02] [indexer:background] Health check
[2023-11-08 01:58:03] [index:background] Health check
[2023-11-08 01:59:34] [indexer:background] Health check
[2023-11-08 02:04:33] [index:background] Health check
[2023-11-08 02:04:33] [indexer:background] Health check
[2023-11-08 02:04:33] [indexer:background] Health check
[2023-11-08 02:10:32] [index:background] Health check
[2023-11-08 02:10:32] [indexer:background] Health check
[2023-11-08 02:10:32] [indexer:background] Health check
[2023-11-08 02:15:30] [index:background] Health check
[2023-11-08 02:15:30] [indexer:background] Health check
[2023-11-08 02:15:30] [indexer:background] Health check
[2023-11-08 02:18:04] [index:background] Health check
[2023-11-08 02:19:35] [indexer:background] Health check
[2023-11-08 02:24:03] [index:background] Health check
[2023-11-08 02:24:36] [indexer:background] Health check
[2023-11-08 02:28:33] [index:background] Health check
[2023-11-08 02:29:34] [indexer:background] Health check
[2023-11-08 02:34:10] [index:background] Health check
[2023-11-08 02:35:33] [indexer:background] Health check
[2023-11-08 02:38:29] [index:background] Health check
[2023-11-08 02:38:29] [index:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2023-11-08 02:38:31] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2023-11-08 02:39:41] [indexer:background] Health check
[2023-11-08 02:39:41] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-11-08 02:43:51] [index:background] Health check
[2023-11-08 02:43:51] [index:background] CPU load threshold (3) breached: 4.58 [waiting 2]
[2023-11-08 02:43:53] [indexer:background] CPU load threshold (3) breached: 4.58 [waiting 2]
[2023-11-08 02:44:47] [indexer:background] Health check
[2023-11-08 02:44:47] [indexer:background] CPU load threshold (3) breached: 4 [waiting 2]
[2023-11-08 02:48:05] [index:background] Health check
[2023-11-08 02:49:34] [indexer:background] Health check
[2023-11-08 02:49:34] [indexer:background] CPU load threshold (3) breached: 3.28 [waiting 2]
[2023-11-08 02:54:51] [index:background] Health check
[2023-11-08 02:54:51] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2023-11-08 02:54:54] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2023-11-08 02:54:56] [indexer:background] Health check
[2023-11-08 02:54:56] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-11-08 02:54:58] [indexer:background] Health check
[2023-11-08 02:54:58] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-11-08 02:59:21] [index:background] Health check
[2023-11-08 02:59:21] [index:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-11-08 02:59:23] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-11-08 03:00:22] [indexer:background] Health check
[2023-11-08 03:00:22] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-11-08 03:04:16] [index:background] Health check
[2023-11-08 03:04:16] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2023-11-08 03:04:18] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2023-11-08 03:05:13] [indexer:background] Health check
[2023-11-08 03:05:13] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-11-08 03:09:04] [index:background] Health check
[2023-11-08 03:09:04] [index:background] CPU load threshold (3) breached: 3.9 [waiting 2]
[2023-11-08 03:09:06] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2]
[2023-11-08 03:10:06] [indexer:background] Health check
[2023-11-08 03:10:06] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-08 03:14:55] [index:background] Health check
[2023-11-08 03:14:55] [index:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2023-11-08 03:14:57] [indexer:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2023-11-08 03:15:00] [indexer:background] Health check
[2023-11-08 03:15:00] [indexer:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2023-11-08 03:15:02] [indexer:background] Health check
[2023-11-08 03:15:02] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-11-08 03:20:38] [index:background] Health check
[2023-11-08 03:20:38] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-11-08 03:20:40] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-11-08 03:20:43] [indexer:background] Health check
[2023-11-08 03:20:43] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-11-08 03:20:45] [indexer:background] Health check
[2023-11-08 03:20:45] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-11-08 03:23:53] [index:background] Health check
[2023-11-08 03:24:40] [indexer:background] Health check
[2023-11-08 03:28:13] [index:background] Health check
[2023-11-08 03:28:13] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2023-11-08 03:28:15] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2023-11-08 03:29:37] [indexer:background] Health check
[2023-11-08 03:29:37] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2023-11-08 03:34:01] [index:background] Health check
[2023-11-08 03:34:01] [index:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-08 03:34:03] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-08 03:35:10] [indexer:background] Health check
[2023-11-08 03:35:10] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2023-11-08 03:38:07] [index:background] Health check
[2023-11-08 03:38:07] [index:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-08 03:38:09] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-11-08 03:39:54] [indexer:background] Health check
[2023-11-08 03:43:23] [index:background] Health check
[2023-11-08 03:44:56] [indexer:background] Health check
[2023-11-08 03:48:23] [index:background] Health check
[2023-11-08 03:50:18] [indexer:background] Health check
[2023-11-08 03:53:06] [index:background] Health check
[2023-11-08 03:54:33] [indexer:background] Health check
[2023-11-08 03:58:05] [index:background] Health check
[2023-11-08 03:59:34] [indexer:background] Health check
[2023-11-08 04:03:04] [index:background] Health check
[2023-11-08 04:04:34] [indexer:background] Health check
[2023-11-08 04:08:05] [index:background] Health check
[2023-11-08 04:09:35] [indexer:background] Health check
[2023-11-08 04:13:04] [index:background] Health check
[2023-11-08 04:15:36] [indexer:background] Health check
[2023-11-08 04:18:06] [index:background] Health check
[2023-11-08 04:19:37] [indexer:background] Health check
[2023-11-08 04:25:09] [index:background] Health check
[2023-11-08 04:25:09] [indexer:background] Health check
[2023-11-08 04:25:09] [indexer:background] Health check
[2023-11-08 04:30:56] [index:background] Health check
[2023-11-08 04:30:56] [indexer:background] Health check
[2023-11-08 04:30:56] [indexer:background] Health check
[2023-11-08 04:35:43] [index:background] Health check
[2023-11-08 04:35:43] [indexer:background] Health check
[2023-11-08 04:35:43] [indexer:background] Health check
[2023-11-08 04:38:34] [index:background] Health check
[2023-11-08 04:41:10] [indexer:background] Health check
[2023-11-08 04:43:19] [index:background] Health check
[2023-11-08 04:46:21] [indexer:background] Health check
[2023-11-08 04:51:24] [index:background] Health check
[2023-11-08 04:51:24] [indexer:background] Health check
[2023-11-08 04:51:24] [indexer:background] Health check
[2023-11-08 04:53:35] [index:background] Health check
[2023-11-08 04:55:01] [indexer:background] Health check
[2023-11-08 05:00:24] [index:background] Health check
[2023-11-08 05:00:25] [indexer:background] Health check
[2023-11-08 05:00:25] [indexer:background] Health check
[2023-11-08 05:04:11] [index:background] Health check
[2023-11-08 05:05:15] [indexer:background] Health check
[2023-11-08 05:09:37] [index:background] Health check
[2023-11-08 05:09:37] [indexer:background] Health check
[2023-11-08 05:09:37] [indexer:background] Health check
[2023-11-08 05:13:05] [index:background] Health check
[2023-11-08 05:14:34] [indexer:background] Health check
[2023-11-08 05:18:04] [index:background] Health check
[2023-11-08 05:19:34] [indexer:background] Health check
[2023-11-08 05:23:08] [index:background] Health check
[2023-11-08 05:24:33] [indexer:background] Health check
[2023-11-08 05:28:06] [index:background] Health check
[2023-11-08 05:31:57] [indexer:background] Health check
[2023-11-08 05:33:34] [index:background] Health check
[2023-11-08 05:34:40] [indexer:background] Health check
[2023-11-08 05:38:46] [index:background] Health check
[2023-11-08 05:40:05] [indexer:background] Health check
[2023-11-08 05:42:03] [query] Query for: 2023
[2023-11-08 05:42:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-08 05:42:03] [query] Engine: default
[2023-11-08 05:42:03] [query] Tokens: 2023
[2023-11-08 05:42:03] [query] Mods: 6
[2023-11-08 05:42:04] [query] Found results using: or logic
[2023-11-08 05:42:04] [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-08 05:42:04] [query] Results: 253 Pages of results: 26
[2023-11-08 05:42:04] [query] Execution time: 1.19435
[2023-11-08 05:43:42] [index:background] Health check
[2023-11-08 05:44:34] [indexer:background] Health check
[2023-11-08 05:48:13] [index:background] Health check
[2023-11-08 05:49:34] [indexer:background] Health check
[2023-11-08 05:53:02] [index:background] Health check
[2023-11-08 05:54:36] [indexer:background] Health check
[2023-11-08 05:58:11] [index:background] Health check
[2023-11-08 05:59:53] [indexer:background] Health check
[2023-11-08 06:05:51] [index:background] Health check
[2023-11-08 06:05:51] [indexer:background] Health check
[2023-11-08 06:05:51] [indexer:background] Health check
[2023-11-08 06:08:07] [index:background] Health check
[2023-11-08 06:09:35] [indexer:background] Health check
[2023-11-08 06:14:28] [index:background] Health check
[2023-11-08 06:14:33] [indexer:background] Health check
[2023-11-08 06:18:12] [index:background] Health check
[2023-11-08 06:21:28] [indexer:background] Health check
[2023-11-08 06:24:36] [index:background] Health check
[2023-11-08 06:24:36] [indexer:background] Health check
[2023-11-08 06:24:36] [indexer:background] Health check
[2023-11-08 06:28:10] [index:background] Health check
[2023-11-08 06:29:35] [indexer:background] Health check
[2023-11-08 06:33:15] [index:background] Health check
[2023-11-08 06:34:36] [indexer:background] Health check
[2023-11-08 06:38:05] [index:background] Health check
[2023-11-08 06:39:34] [indexer:background] Health check
[2023-11-08 06:43:04] [index:background] Health check
[2023-11-08 06:44:34] [indexer:background] Health check
[2023-11-08 06:48:24] [index:background] Health check
[2023-11-08 06:51:45] [indexer:background] Health check
[2023-11-08 06:53:27] [index:background] Health check
[2023-11-08 06:54:45] [indexer:background] Health check
[2023-11-08 06:58:10] [index:background] Health check
[2023-11-08 07:00:10] [indexer:background] Health check
[2023-11-08 07:03:53] [index:background] Health check
[2023-11-08 07:04:35] [indexer:background] Health check
[2023-11-08 07:08:18] [index:background] Health check
[2023-11-08 07:09:34] [indexer:background] Health check
[2023-11-08 07:14:02] [index:background] Health check
[2023-11-08 07:14:35] [indexer:background] Health check
[2023-11-08 07:18:39] [index:background] Health check
[2023-11-08 07:20:05] [indexer:background] Health check
[2023-11-08 07:23:07] [index:background] Health check
[2023-11-08 07:26:53] [indexer:background] Health check
[2023-11-08 07:29:00] [index:background] Health check
[2023-11-08 07:29:40] [indexer:background] Health check
[2023-11-08 07:34:13] [index:background] Health check
[2023-11-08 07:35:37] [indexer:background] Health check
[2023-11-08 07:38:22] [index:background] Health check
[2023-11-08 07:39:34] [indexer:background] Health check
[2023-11-08 07:43:16] [index:background] Health check
[2023-11-08 07:45:37] [indexer:background] Health check
[2023-11-08 07:48:07] [index:background] Health check
[2023-11-08 07:49:44] [indexer:background] Health check
[2023-11-08 07:55:29] [index:background] Health check
[2023-11-08 07:55:29] [indexer:background] Health check
[2023-11-08 07:55:29] [indexer:background] Health check
[2023-11-08 08:01:46] [index:background] Health check
[2023-11-08 08:01:47] [indexer:background] Health check
[2023-11-08 08:01:47] [indexer:background] Health check
[2023-11-08 08:04:58] [index:background] Health check
[2023-11-08 08:04:58] [indexer:background] Health check
[2023-11-08 08:04:58] [indexer:background] Health check
[2023-11-08 08:08:29] [index:background] Health check
[2023-11-08 08:11:42] [indexer:background] Health check
[2023-11-08 08:13:04] [index:background] Health check
[2023-11-08 08:14:54] [indexer:background] Health check
[2023-11-08 08:18:04] [index:background] Health check
[2023-11-08 08:20:00] [indexer:background] Health check
[2023-11-08 08:23:08] [index:background] Health check
[2023-11-08 08:23:22] [query] Query for: 2024
[2023-11-08 08:23:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-08 08:23:22] [query] Engine: default
[2023-11-08 08:23:23] [query] Tokens: 2024
[2023-11-08 08:23:23] [query] Mods: 6
[2023-11-08 08:23:23] [query] Found results using: or logic
[2023-11-08 08:23:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-11-08 08:23:23] [query] Results: 130 Pages of results: 13
[2023-11-08 08:23:23] [query] Execution time: 1.54110
[2023-11-08 08:23:23] [query] Query for: 2024
[2023-11-08 08:23:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-08 08:23:23] [query] Engine: default
[2023-11-08 08:23:23] [query] Tokens: 2024
[2023-11-08 08:23:23] [query] Mods: 6
[2023-11-08 08:23:23] [query] Found results using: or logic
[2023-11-08 08:23:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2023-11-08 08:23:23] [query] Results: 130 Pages of results: 2
[2023-11-08 08:23:23] [query] Execution time: 0.10491
[2023-11-08 08:25:17] [indexer:background] Health check
[2023-11-08 08:28:28] [index:background] Health check
[2023-11-08 08:30:08] [indexer:background] Health check
[2023-11-08 08:33:46] [index:background] Health check
[2023-11-08 08:34:37] [indexer:background] Health check
[2023-11-08 08:38:05] [index:background] Health check
[2023-11-08 08:39:54] [indexer:background] Health check
[2023-11-08 08:43:36] [index:background] Health check
[2023-11-08 08:46:27] [indexer:background] Health check
[2023-11-08 08:48:39] [index:background] Health check
[2023-11-08 08:50:50] [indexer:background] Health check
[2023-11-08 08:53:17] [index:background] Health check
[2023-11-08 08:55:38] [indexer:background] Health check
[2023-11-08 08:58:24] [index:background] Health check
[2023-11-08 08:59:37] [indexer:background] Health check
[2023-11-08 09:03:06] [index:background] Health check
[2023-11-08 09:04:48] [indexer:background] Health check
[2023-11-08 09:08:38] [index:background] Health check
[2023-11-08 09:09:53] [indexer:background] Health check
[2023-11-08 09:13:04] [index:background] Health check
[2023-11-08 09:13:04] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-11-08 09:13:06] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-11-08 09:14:53] [indexer:background] Health check
[2023-11-08 09:18:25] [index:background] Health check
[2023-11-08 09:19:38] [indexer:background] Health check
[2023-11-08 09:19:38] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2023-11-08 09:23:41] [index:background] Health check
[2023-11-08 09:24:37] [indexer:background] Health check
[2023-11-08 09:28:21] [index:background] Health check
[2023-11-08 09:30:33] [indexer:background] Health check
[2023-11-08 09:33:18] [index:background] Health check
[2023-11-08 09:36:27] [indexer:background] Health check
[2023-11-08 09:39:19] [index:background] Health check
[2023-11-08 09:39:45] [indexer:background] Health check
[2023-11-08 09:43:06] [index:background] Health check
[2023-11-08 09:45:20] [indexer:background] Health check
[2023-11-08 09:48:14] [index:background] Health check
[2023-11-08 09:49:37] [indexer:background] Health check
[2023-11-08 09:49:37] [indexer:background] CPU load threshold (3) breached: 3.84 [waiting 2]
[2023-11-08 09:53:25] [index:background] Health check
[2023-11-08 09:55:00] [indexer:background] Health check
[2023-11-08 09:59:14] [index:background] Health check
[2023-11-08 09:59:14] [index:background] CPU load threshold (3) breached: 3.71 [waiting 2]
[2023-11-08 09:59:16] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2]
[2023-11-08 09:59:42] [indexer:background] Health check
[2023-11-08 10:05:13] [index:background] Health check
[2023-11-08 10:05:13] [indexer:background] Health check
[2023-11-08 10:05:13] [indexer:background] Health check
[2023-11-08 10:08:33] [index:background] Health check
[2023-11-08 10:09:36] [indexer:background] Health check
[2023-11-08 10:14:56] [index:background] Health check
[2023-11-08 10:14:56] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-11-08 10:14:58] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-11-08 10:15:00] [indexer:background] Health check
[2023-11-08 10:15:00] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-11-08 10:15:02] [indexer:background] Health check
[2023-11-08 10:18:19] [index:background] Health check
[2023-11-08 10:19:41] [indexer:background] Health check
[2023-11-08 10:23:26] [index:background] Health check
[2023-11-08 10:24:54] [indexer:background] Health check
[2023-11-08 10:30:56] [index:background] Health check
[2023-11-08 10:30:56] [indexer:background] Health check
[2023-11-08 10:30:56] [indexer:background] Health check
[2023-11-08 10:33:29] [index:background] Health check
[2023-11-08 10:33:29] [index:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-11-08 10:33:31] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-11-08 10:34:35] [indexer:background] Health check
[2023-11-08 10:38:11] [index:background] Health check
[2023-11-08 10:40:25] [indexer:background] Health check
[2023-11-08 10:40:25] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-11-08 10:43:09] [index:background] Health check
[2023-11-08 10:43:09] [index:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-11-08 10:43:11] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-11-08 10:45:09] [indexer:background] Health check
[2023-11-08 10:48:40] [index:background] Health check
[2023-11-08 10:50:11] [indexer:background] Health check
[2023-11-08 10:50:11] [indexer:background] CPU load threshold (3) breached: 4.29 [waiting 2]
[2023-11-08 10:53:21] [index:background] Health check
[2023-11-08 10:55:04] [indexer:background] Health check
[2023-11-08 10:58:08] [index:background] Health check
[2023-11-08 11:00:35] [indexer:background] Health check
[2023-11-08 11:04:47] [index:background] Health check
[2023-11-08 11:04:47] [indexer:background] Health check
[2023-11-08 11:04:47] [indexer:background] Health check
[2023-11-08 11:08:38] [index:background] Health check
[2023-11-08 11:09:35] [indexer:background] Health check
[2023-11-08 11:13:06] [index:background] Health check
[2023-11-08 11:14:38] [indexer:background] Health check
[2023-11-08 11:18:04] [index:background] Health check
[2023-11-08 11:19:38] [indexer:background] Health check
[2023-11-08 11:24:41] [index:background] Health check
[2023-11-08 11:24:41] [indexer:background] Health check
[2023-11-08 11:24:41] [indexer:background] Health check
[2023-11-08 11:28:22] [index:background] Health check
[2023-11-08 11:29:47] [indexer:background] Health check
[2023-11-08 11:33:25] [index:background] Health check
[2023-11-08 11:34:46] [indexer:background] Health check
[2023-11-08 11:38:05] [index:background] Health check
[2023-11-08 11:39:41] [indexer:background] Health check
[2023-11-08 11:43:25] [index:background] Health check
[2023-11-08 11:44:46] [indexer:background] Health check
[2023-11-08 11:48:22] [index:background] Health check
[2023-11-08 11:49:36] [indexer:background] Health check
[2023-11-08 11:53:40] [index:background] Health check
[2023-11-08 11:54:36] [indexer:background] Health check
[2023-11-08 11:58:51] [index:background] Health check
[2023-11-08 11:59:56] [indexer:background] Health check
[2023-11-08 12:03:37] [index:background] Health check
[2023-11-08 12:04:39] [indexer:background] Health check
[2023-11-08 12:09:42] [index:background] Health check
[2023-11-08 12:09:42] [indexer:background] Health check
[2023-11-08 12:09:42] [indexer:background] Health check
[2023-11-08 12:13:03] [index:background] Health check
[2023-11-08 12:14:50] [indexer:background] Health check
[2023-11-08 12:19:23] [index:background] Health check
[2023-11-08 12:20:06] [indexer:background] Health check
[2023-11-08 12:24:04] [index:background] Health check
[2023-11-08 12:25:55] [indexer:background] Health check
[2023-11-08 12:28:03] [index:background] Health check
[2023-11-08 12:30:12] [indexer:background] Health check
[2023-11-08 12:33:36] [index:background] Health check
[2023-11-08 12:34:33] [indexer:background] Health check
[2023-11-08 12:39:54] [index:background] Health check
[2023-11-08 12:39:54] [indexer:background] Health check
[2023-11-08 12:39:54] [indexer:background] Health check
[2023-11-08 12:43:02] [index:background] Health check
[2023-11-08 12:45:13] [indexer:background] Health check
[2023-11-08 12:48:07] [index:background] Health check
[2023-11-08 12:49:47] [indexer:background] Health check
[2023-11-08 12:49:47] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-11-08 12:53:05] [index:background] Health check
[2023-11-08 12:56:32] [indexer:background] Health check
[2023-11-08 12:59:54] [index:background] Health check
[2023-11-08 12:59:54] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-11-08 12:59:56] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-11-08 12:59:58] [indexer:background] Health check
[2023-11-08 12:59:58] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-11-08 13:00:00] [indexer:background] Health check
[2023-11-08 13:00:00] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2023-11-08 13:05:26] [index:background] Health check
[2023-11-08 13:05:26] [indexer:background] Health check
[2023-11-08 13:05:27] [indexer:background] Health check
[2023-11-08 13:08:55] [index:background] Health check
[2023-11-08 13:12:51] [indexer:background] Health check
[2023-11-08 13:12:51] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-11-08 13:14:34] [index:background] Health check
[2023-11-08 13:14:34] [indexer:background] Health check
[2023-11-08 13:14:34] [indexer:background] Health check
[2023-11-08 13:18:19] [index:background] Health check
[2023-11-08 13:18:19] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-11-08 13:18:21] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-11-08 13:19:50] [indexer:background] Health check
[2023-11-08 13:19:50] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2023-11-08 13:23:42] [index:background] Health check
[2023-11-08 13:24:42] [indexer:background] Health check
[2023-11-08 13:28:23] [index:background] Health check
[2023-11-08 13:29:41] [indexer:background] Health check
[2023-11-08 13:33:50] [index:background] Health check
[2023-11-08 13:35:16] [indexer:background] Health check
[2023-11-08 13:38:05] [index:background] Health check
[2023-11-08 13:38:05] [index:background] CPU load threshold (3) breached: 24.21 [waiting 2]
[2023-11-08 13:38:07] [indexer:background] CPU load threshold (3) breached: 22.59 [waiting 2]
[2023-11-08 13:39:34] [indexer:background] Health check
[2023-11-08 13:39:34] [indexer:background] CPU load threshold (3) breached: 7.49 [waiting 2]
[2023-11-08 13:43:26] [index:background] Health check
[2023-11-08 13:43:26] [index:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-11-08 13:43:28] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-11-08 13:44:43] [indexer:background] Health check
[2023-11-08 13:44:43] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2023-11-08 13:49:10] [index:background] Health check
[2023-11-08 13:50:12] [indexer:background] Health check
[2023-11-08 13:50:12] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2023-11-08 13:54:39] [index:background] Health check
[2023-11-08 13:54:39] [index:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2023-11-08 13:54:41] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-11-08 13:54:43] [indexer:background] Health check
[2023-11-08 13:54:43] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-11-08 13:54:45] [indexer:background] Health check
[2023-11-08 13:54:45] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-11-08 14:00:12] [index:background] Health check
[2023-11-08 14:00:12] [indexer:background] Health check
[2023-11-08 14:00:12] [indexer:background] Health check
[2023-11-08 14:03:04] [index:background] Health check
[2023-11-08 14:03:04] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-08 14:03:06] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-08 14:04:57] [indexer:background] Health check
[2023-11-08 14:04:57] [indexer:background] CPU load threshold (3) breached: 3.67 [waiting 2]
[2023-11-08 14:08:15] [index:background] Health check
[2023-11-08 14:08:15] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-08 14:08:17] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2023-11-08 14:10:01] [indexer:background] Health check
[2023-11-08 14:10:01] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-11-08 14:13:18] [index:background] Health check
[2023-11-08 14:13:18] [index:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-11-08 14:13:20] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-11-08 14:15:36] [indexer:background] Health check
[2023-11-08 14:18:17] [index:background] Health check
[2023-11-08 14:19:48] [indexer:background] Health check
[2023-11-08 14:19:48] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-11-08 14:23:23] [index:background] Health check
[2023-11-08 14:23:23] [index:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-11-08 14:23:25] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-11-08 14:27:04] [indexer:background] Health check
[2023-11-08 14:27:04] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-11-08 14:28:52] [index:background] Health check
[2023-11-08 14:29:42] [indexer:background] Health check
[2023-11-08 14:29:42] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-08 14:33:47] [index:background] Health check
[2023-11-08 14:33:47] [index:background] CPU load threshold (3) breached: 3.66 [waiting 2]
[2023-11-08 14:33:49] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2]
[2023-11-08 14:35:46] [indexer:background] Health check
[2023-11-08 14:39:13] [index:background] Health check
[2023-11-08 14:43:32] [indexer:background] Health check
[2023-11-08 14:43:32] [index:background] Health check
[2023-11-08 14:45:03] [indexer:background] Health check
[2023-11-08 14:49:10] [index:background] Health check
[2023-11-08 14:50:38] [indexer:background] Health check
[2023-11-08 14:53:21] [index:background] Health check
[2023-11-08 14:54:51] [indexer:background] Health check
[2023-11-08 14:54:52] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-11-08 14:58:28] [index:background] Health check
[2023-11-08 14:59:40] [indexer:background] Health check
[2023-11-08 15:03:07] [index:background] Health check
[2023-11-08 15:05:59] [indexer:background] Health check
[2023-11-08 15:05:59] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-11-08 15:08:21] [index:background] Health check
[2023-11-08 15:09:53] [indexer:background] Health check
[2023-11-08 15:13:27] [index:background] Health check
[2023-11-08 15:14:50] [indexer:background] Health check
[2023-11-08 15:18:24] [index:background] Health check
[2023-11-08 15:19:48] [indexer:background] Health check
[2023-11-08 15:23:23] [index:background] Health check
[2023-11-08 15:23:23] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-08 15:23:25] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-08 15:24:50] [indexer:background] Health check
[2023-11-08 15:24:50] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2023-11-08 15:28:52] [index:background] Health check
[2023-11-08 15:29:32] [indexer:background] Health check
[2023-11-08 15:31:55] [query] Query for: search_term_string
[2023-11-08 15:31:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-08 15:31:55] [query] Engine: default
[2023-11-08 15:31:56] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-08 15:31:56] [query] Mods: 6
[2023-11-08 15:31:56] [query] Using OR logic
[2023-11-08 15:31:59] [query] Found results using: or logic
[2023-11-08 15:31:59] [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-11-08 15:31:59] [query] Results: 1346 Pages of results: 135
[2023-11-08 15:31:59] [query] Execution time: 3.31327
[2023-11-08 15:33:46] [index:background] Health check
[2023-11-08 15:34:42] [indexer:background] Health check
[2023-11-08 15:39:50] [index:background] Health check
[2023-11-08 15:39:50] [indexer:background] Health check
[2023-11-08 15:39:50] [indexer:background] Health check
[2023-11-08 15:40:29] [query] Query for: search_term_string
[2023-11-08 15:40:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-08 15:40:29] [query] Engine: default
[2023-11-08 15:40:29] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-08 15:40:29] [query] Mods: 6
[2023-11-08 15:40:29] [query] Using OR logic
[2023-11-08 15:40:29] [query] Found results using: or logic
[2023-11-08 15:40: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-11-08 15:40:29] [query] Results: 1346 Pages of results: 135
[2023-11-08 15:40:29] [query] Execution time: 0.04587
[2023-11-08 15:43:20] [index:background] Health check
[2023-11-08 15:44:50] [indexer:background] Health check
[2023-11-08 15:48:04] [index:background] Health check
[2023-11-08 15:48:04] [index:background] CPU load threshold (3) breached: 3.89 [waiting 2]
[2023-11-08 15:48:06] [indexer:background] CPU load threshold (3) breached: 3.89 [waiting 2]
[2023-11-08 15:49:53] [indexer:background] Health check
[2023-11-08 15:49:53] [indexer:background] CPU load threshold (3) breached: 4.44 [waiting 2]
[2023-11-08 15:53:07] [index:background] Health check
[2023-11-08 15:54:46] [indexer:background] Health check
[2023-11-08 15:58:51] [index:background] Health check
[2023-11-08 16:00:10] [indexer:background] Health check
[2023-11-08 16:04:56] [index:background] Health check
[2023-11-08 16:04:56] [indexer:background] Health check
[2023-11-08 16:04:56] [indexer:background] Health check
[2023-11-08 16:09:23] [index:background] Health check
[2023-11-08 16:10:49] [indexer:background] Health check
[2023-11-08 16:13:28] [index:background] Health check
[2023-11-08 16:14:50] [indexer:background] Health check
[2023-11-08 16:19:04] [index:background] Health check
[2023-11-08 16:23:15] [indexer:background] Health check
[2023-11-08 16:23:15] [index:background] Health check
[2023-11-08 16:24:32] [indexer:background] Health check
[2023-11-08 16:28:44] [index:background] Health check
[2023-11-08 16:29:50] [indexer:background] Health check
[2023-11-08 16:33:07] [index:background] Health check
[2023-11-08 16:35:58] [indexer:background] Health check
[2023-11-08 16:39:54] [index:background] Health check
[2023-11-08 16:39:54] [indexer:background] Health check
[2023-11-08 16:39:54] [indexer:background] Health check
[2023-11-08 16:43:25] [index:background] Health check
[2023-11-08 16:44:33] [indexer:background] Health check
[2023-11-08 16:49:03] [index:background] Health check
[2023-11-08 16:49:34] [indexer:background] Health check
[2023-11-08 16:53:07] [index:background] Health check
[2023-11-08 16:56:56] [indexer:background] Health check
[2023-11-08 16:58:52] [index:background] Health check
[2023-11-08 16:59:34] [indexer:background] Health check
[2023-11-08 17:03:05] [index:background] Health check
[2023-11-08 17:05:47] [indexer:background] Health check
[2023-11-08 17:08:53] [index:background] Health check
[2023-11-08 17:09:50] [indexer:background] Health check
[2023-11-08 17:13:30] [index:background] Health check
[2023-11-08 17:14:42] [indexer:background] Health check
[2023-11-08 17:18:50] [index:background] Health check
[2023-11-08 17:20:19] [indexer:background] Health check
[2023-11-08 17:24:25] [index:background] Health check
[2023-11-08 17:25:12] [indexer:background] Health check
[2023-11-08 17:28:33] [index:background] Health check
[2023-11-08 17:29:58] [indexer:background] Health check
[2023-11-08 17:33:07] [index:background] Health check
[2023-11-08 17:35:22] [indexer:background] Health check
[2023-11-08 17:38:03] [index:background] Health check
[2023-11-08 17:39:34] [indexer:background] Health check
[2023-11-08 17:45:39] [index:background] Health check
[2023-11-08 17:45:39] [indexer:background] Health check
[2023-11-08 17:45:39] [indexer:background] Health check
[2023-11-08 17:48:20] [index:background] Health check
[2023-11-08 17:49:32] [indexer:background] Health check
[2023-11-08 17:54:51] [index:background] Health check
[2023-11-08 17:54:51] [indexer:background] Health check
[2023-11-08 17:54:51] [indexer:background] Health check
[2023-11-08 17:58:07] [index:background] Health check
[2023-11-08 18:00:47] [indexer:background] Health check
[2023-11-08 18:03:45] [index:background] Health check
[2023-11-08 18:05:03] [indexer:background] Health check
[2023-11-08 18:08:06] [index:background] Health check
[2023-11-08 18:10:12] [indexer:background] Health check
[2023-11-08 18:14:26] [index:background] Health check
[2023-11-08 18:14:50] [indexer:background] Health check
[2023-11-08 18:18:33] [index:background] Health check
[2023-11-08 18:19:45] [indexer:background] Health check
[2023-11-08 18:23:42] [index:background] Health check
[2023-11-08 18:24:54] [indexer:background] Health check
[2023-11-08 18:28:43] [index:background] Health check
[2023-11-08 18:30:07] [indexer:background] Health check
[2023-11-08 18:35:05] [index:background] Health check
[2023-11-08 18:35:07] [indexer:background] Health check
[2023-11-08 18:35:07] [indexer:background] Health check
[2023-11-08 18:39:00] [index:background] Health check
[2023-11-08 18:40:17] [indexer:background] Health check
[2023-11-08 18:43:17] [index:background] Health check
[2023-11-08 18:44:50] [indexer:background] Health check
[2023-11-08 18:48:03] [index:background] Health check
[2023-11-08 18:50:08] [indexer:background] Health check
[2023-11-08 18:53:35] [index:background] Health check
[2023-11-08 18:54:48] [indexer:background] Health check
[2023-11-08 18:54:48] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2023-11-08 18:58:02] [index:background] Health check
[2023-11-08 19:00:39] [indexer:background] Health check
[2023-11-08 19:06:27] [index:background] Health check
[2023-11-08 19:06:27] [indexer:background] Health check
[2023-11-08 19:06:27] [indexer:background] Health check
[2023-11-08 19:10:38] [index:background] Health check
[2023-11-08 19:10:38] [indexer:background] Health check
[2023-11-08 19:10:38] [indexer:background] Health check
[2023-11-08 19:14:03] [index:background] Health check
[2023-11-08 19:16:43] [indexer:background] Health check
[2023-11-08 19:18:50] [index:background] Health check
[2023-11-08 19:19:43] [indexer:background] Health check
[2023-11-08 19:23:07] [index:background] Health check
[2023-11-08 19:24:36] [indexer:background] Health check
[2023-11-08 19:28:10] [index:background] Health check
[2023-11-08 19:29:35] [indexer:background] Health check
[2023-11-08 19:33:37] [index:background] Health check
[2023-11-08 19:34:38] [indexer:background] Health check
[2023-11-08 19:40:50] [index:background] Health check
[2023-11-08 19:40:52] [indexer:background] Health check
[2023-11-08 19:40:52] [indexer:background] Health check
[2023-11-08 19:43:14] [index:background] Health check
[2023-11-08 19:44:54] [indexer:background] Health check
[2023-11-08 19:49:10] [index:background] Health check
[2023-11-08 19:49:33] [indexer:background] Health check
[2023-11-08 19:53:15] [index:background] Health check
[2023-11-08 19:54:17] [query] Query for: 2023
[2023-11-08 19:54:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-08 19:54:17] [query] Engine: default
[2023-11-08 19:54:18] [query] Tokens: 2023
[2023-11-08 19:54:18] [query] Mods: 6
[2023-11-08 19:54:18] [query] Found results using: or logic
[2023-11-08 19:54:18] [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-08 19:54:18] [query] Results: 253 Pages of results: 26
[2023-11-08 19:54:18] [query] Execution time: 1.66986
[2023-11-08 19:54:18] [query] Query for: 2023
[2023-11-08 19:54:18] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-08 19:54:18] [query] Engine: default
[2023-11-08 19:54:18] [query] Tokens: 2023
[2023-11-08 19:54:18] [query] Mods: 6
[2023-11-08 19:54:18] [query] Found results using: or logic
[2023-11-08 19:54:19] [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-08 19:54:19] [query] Results: 253 Pages of results: 3
[2023-11-08 19:54:19] [query] Execution time: 0.10757
[2023-11-08 19:55:38] [indexer:background] Health check
[2023-11-08 19:59:01] [index:background] Health check
[2023-11-08 20:01:18] [indexer:background] Health check
[2023-11-08 20:03:15] [index:background] Health check
[2023-11-08 20:06:54] [indexer:background] Health check
[2023-11-08 20:09:21] [index:background] Health check
[2023-11-08 20:10:09] [indexer:background] Health check
[2023-11-08 20:13:45] [index:background] Health check
[2023-11-08 20:14:34] [indexer:background] Health check
[2023-11-08 20:18:52] [index:background] Health check
[2023-11-08 20:20:49] [indexer:background] Health check
[2023-11-08 20:23:52] [index:background] Health check
[2023-11-08 20:24:36] [indexer:background] Health check
[2023-11-08 20:29:36] [index:background] Health check
[2023-11-08 20:29:36] [indexer:background] Health check
[2023-11-08 20:29:36] [indexer:background] Health check
[2023-11-08 20:33:54] [index:background] Health check
[2023-11-08 20:34:38] [indexer:background] Health check
[2023-11-08 20:38:07] [index:background] Health check
[2023-11-08 20:40:05] [indexer:background] Health check
[2023-11-08 20:43:24] [index:background] Health check
[2023-11-08 20:45:51] [indexer:background] Health check
[2023-11-08 20:48:09] [index:background] Health check
[2023-11-08 20:48:09] [index:background] CPU load threshold (3) breached: 21.09 [waiting 2]
[2023-11-08 20:48:11] [indexer:background] CPU load threshold (3) breached: 21.09 [waiting 2]
[2023-11-08 20:49:57] [indexer:background] Health check
[2023-11-08 20:49:57] [indexer:background] CPU load threshold (3) breached: 4.88 [waiting 2]
[2023-11-08 20:53:43] [index:background] Health check
[2023-11-08 20:55:05] [indexer:background] Health check
[2023-11-08 20:58:51] [index:background] Health check
[2023-11-08 21:02:02] [indexer:background] Health check
[2023-11-08 21:03:21] [index:background] Health check
[2023-11-08 21:05:00] [indexer:background] Health check
[2023-11-08 21:10:40] [index:background] Health check
[2023-11-08 21:10:40] [indexer:background] Health check
[2023-11-08 21:10:40] [indexer:background] Health check
[2023-11-08 21:13:51] [index:background] Health check
[2023-11-08 21:14:43] [indexer:background] Health check
[2023-11-08 21:18:08] [index:background] Health check
[2023-11-08 21:19:40] [indexer:background] Health check
[2023-11-08 21:23:16] [index:background] Health check
[2023-11-08 21:24:35] [indexer:background] Health check
[2023-11-08 21:28:11] [index:background] Health check
[2023-11-08 21:29:34] [indexer:background] Health check
[2023-11-08 21:33:22] [index:background] Health check
[2023-11-08 21:35:07] [indexer:background] Health check
[2023-11-08 21:39:00] [index:background] Health check
[2023-11-08 21:39:48] [indexer:background] Health check
[2023-11-08 21:43:32] [index:background] Health check
[2023-11-08 21:45:05] [indexer:background] Health check
[2023-11-08 21:48:39] [index:background] Health check
[2023-11-08 21:50:45] [indexer:background] Health check
[2023-11-08 21:53:59] [index:background] Health check
[2023-11-08 21:54:46] [indexer:background] Health check
[2023-11-08 21:58:29] [index:background] Health check
[2023-11-08 21:59:36] [indexer:background] Health check
[2023-11-08 22:03:15] [index:background] Health check
[2023-11-08 22:04:44] [indexer:background] Health check
[2023-11-08 22:08:40] [index:background] Health check
[2023-11-08 22:10:40] [indexer:background] Health check
[2023-11-08 22:13:19] [index:background] Health check
[2023-11-08 22:14:41] [indexer:background] Health check
[2023-11-08 22:18:46] [index:background] Health check
[2023-11-08 22:19:37] [indexer:background] Health check
[2023-11-08 22:24:17] [index:background] Health check
[2023-11-08 22:26:34] [indexer:background] Health check
[2023-11-08 22:28:18] [index:background] Health check
[2023-11-08 22:29:40] [indexer:background] Health check
[2023-11-08 22:33:04] [index:background] Health check
[2023-11-08 22:36:42] [indexer:background] Health check
[2023-11-08 22:39:35] [index:background] Health check
[2023-11-08 22:39:35] [indexer:background] Health check
[2023-11-08 22:39:35] [indexer:background] Health check
[2023-11-08 22:43:44] [index:background] Health check
[2023-11-08 22:44:46] [indexer:background] Health check
[2023-11-08 22:49:23] [index:background] Health check
[2023-11-08 22:49:55] [indexer:background] Health check
[2023-11-08 22:53:41] [index:background] Health check
[2023-11-08 22:55:19] [indexer:background] Health check
[2023-11-08 22:58:27] [index:background] Health check
[2023-11-08 22:59:37] [indexer:background] Health check
[2023-11-08 23:03:40] [index:background] Health check
[2023-11-08 23:04:58] [indexer:background] Health check
[2023-11-08 23:08:05] [index:background] Health check
[2023-11-08 23:12:57] [indexer:background] Health check
[2023-11-08 23:13:44] [index:background] Health check
[2023-11-08 23:15:02] [indexer:background] Health check
[2023-11-08 23:18:56] [index:background] Health check
[2023-11-08 23:19:32] [indexer:background] Health check
[2023-11-08 23:23:28] [index:background] Health check
[2023-11-08 23:26:42] [indexer:background] Health check
[2023-11-08 23:28:59] [index:background] Health check
[2023-11-08 23:30:24] [indexer:background] Health check
[2023-11-08 23:33:22] [index:background] Health check
[2023-11-08 23:34:34] [indexer:background] Health check
[2023-11-08 23:38:13] [index:background] Health check
[2023-11-08 23:39:29] [query] Query for: 2024
[2023-11-08 23:39:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-08 23:39:29] [query] Engine: default
[2023-11-08 23:39:30] [query] Tokens: 2024
[2023-11-08 23:39:30] [query] Mods: 6
[2023-11-08 23:39:30] [query] Found results using: or logic
[2023-11-08 23:39: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 (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-08 23:39:30] [query] Results: 130 Pages of results: 13
[2023-11-08 23:39:30] [query] Execution time: 0.91641
[2023-11-08 23:39:59] [indexer:background] Health check
[2023-11-08 23:43:51] [index:background] Health check
[2023-11-08 23:45:03] [indexer:background] Health check
[2023-11-08 23:48:46] [index:background] Health check
[2023-11-08 23:49:37] [indexer:background] Health check
[2023-11-08 23:53:26] [index:background] Health check
[2023-11-08 23:54:49] [indexer:background] Health check
[2023-11-08 23:58:38] [index:background] Health check