[2023-11-29 00:04:23] [index:background] Health check
[2023-11-29 00:05:06] [indexer:background] Health check
[2023-11-29 00:09:22] [index:background] Health check
[2023-11-29 00:11:29] [indexer:background] Health check
[2023-11-29 00:13:21] [index:background] Health check
[2023-11-29 00:14:50] [indexer:background] Health check
[2023-11-29 00:18:03] [index:background] Health check
[2023-11-29 00:21:45] [indexer:background] Health check
[2023-11-29 00:23:07] [index:background] Health check
[2023-11-29 00:25:38] [indexer:background] Health check
[2023-11-29 00:31:42] [index:background] Health check
[2023-11-29 00:31:42] [indexer:background] Health check
[2023-11-29 00:31:42] [indexer:background] Health check
[2023-11-29 00:33:39] [index:background] Health check
[2023-11-29 00:36:01] [indexer:background] Health check
[2023-11-29 00:40:19] [index:background] Health check
[2023-11-29 00:40:19] [indexer:background] Health check
[2023-11-29 00:40:19] [indexer:background] Health check
[2023-11-29 00:43:48] [index:background] Health check
[2023-11-29 00:45:49] [indexer:background] Health check
[2023-11-29 00:49:22] [index:background] Health check
[2023-11-29 00:49:37] [indexer:background] Health check
[2023-11-29 00:53:43] [index:background] Health check
[2023-11-29 00:55:13] [indexer:background] Health check
[2023-11-29 00:59:02] [index:background] Health check
[2023-11-29 01:00:31] [indexer:background] Health check
[2023-11-29 01:04:32] [index:background] Health check
[2023-11-29 01:04:32] [indexer:background] Health check
[2023-11-29 01:04:32] [indexer:background] Health check
[2023-11-29 01:08:41] [index:background] Health check
[2023-11-29 01:12:03] [indexer:background] Health check
[2023-11-29 01:16:08] [index:background] Health check
[2023-11-29 01:16:08] [indexer:background] Health check
[2023-11-29 01:16:08] [indexer:background] Health check
[2023-11-29 01:18:37] [index:background] Health check
[2023-11-29 01:21:44] [indexer:background] Health check
[2023-11-29 01:23:20] [index:background] Health check
[2023-11-29 01:24:36] [indexer:background] Health check
[2023-11-29 01:31:16] [index:background] Health check
[2023-11-29 01:31:16] [indexer:background] Health check
[2023-11-29 01:31:16] [indexer:background] Health check
[2023-11-29 01:34:07] [index:background] Health check
[2023-11-29 01:39:18] [indexer:background] Health check
[2023-11-29 01:39:18] [index:background] Health check
[2023-11-29 01:39:46] [indexer:background] Health check
[2023-11-29 01:43:36] [index:background] Health check
[2023-11-29 01:46:12] [indexer:background] Health check
[2023-11-29 01:48:48] [index:background] Health check
[2023-11-29 01:51:13] [indexer:background] Health check
[2023-11-29 01:54:11] [index:background] Health check
[2023-11-29 01:54:33] [indexer:background] Health check
[2023-11-29 01:58:29] [index:background] Health check
[2023-11-29 02:00:32] [indexer:background] Health check
[2023-11-29 02:03:08] [index:background] Health check
[2023-11-29 02:06:07] [indexer:background] Health check
[2023-11-29 02:08:34] [index:background] Health check
[2023-11-29 02:10:08] [indexer:background] Health check
[2023-11-29 02:13:43] [index:background] Health check
[2023-11-29 02:14:37] [indexer:background] Health check
[2023-11-29 02:18:41] [index:background] Health check
[2023-11-29 02:19:37] [indexer:background] Health check
[2023-11-29 02:25:06] [index:background] Health check
[2023-11-29 02:25:06] [indexer:background] Health check
[2023-11-29 02:25:06] [indexer:background] Health check
[2023-11-29 02:29:05] [index:background] Health check
[2023-11-29 02:31:03] [indexer:background] Health check
[2023-11-29 02:39:30] [index:background] Health check
[2023-11-29 02:39:30] [indexer:background] Health check
[2023-11-29 02:39:30] [indexer:background] Health check
[2023-11-29 02:39:34] [indexer:background] Health check
[2023-11-29 02:44:29] [index:background] Health check
[2023-11-29 02:44:29] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2]
[2023-11-29 02:44:31] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2023-11-29 02:47:35] [indexer:background] Health check
[2023-11-29 02:47:35] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-11-29 02:50:36] [index:background] Health check
[2023-11-29 02:50:37] [indexer:background] Health check
[2023-11-29 02:50:37] [indexer:background] Health check
[2023-11-29 02:53:36] [index:background] Health check
[2023-11-29 02:53:36] [index:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-11-29 02:53:38] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-11-29 02:55:06] [indexer:background] Health check
[2023-11-29 02:55:06] [indexer:background] CPU load threshold (3) breached: 3.94 [waiting 2]
[2023-11-29 02:55:06] [indexer:background] Health check
[2023-11-29 02:55:08] [indexer:background] CPU load threshold (3) breached: 3.94 [waiting 2]
[2023-11-29 02:58:10] [index:background] Health check
[2023-11-29 02:58:10] [index:background] CPU load threshold (3) breached: 4.09 [waiting 2]
[2023-11-29 02:58:12] [indexer:background] CPU load threshold (3) breached: 4 [waiting 2]
[2023-11-29 03:00:35] [indexer:background] Health check
[2023-11-29 03:00:35] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2023-11-29 03:04:07] [index:background] Health check
[2023-11-29 03:04:07] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-11-29 03:04:09] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-11-29 03:06:17] [indexer:background] Health check
[2023-11-29 03:09:57] [index:background] Health check
[2023-11-29 03:09:58] [indexer:background] Health check
[2023-11-29 03:09:58] [indexer:background] Health check
[2023-11-29 03:13:06] [index:background] Health check
[2023-11-29 03:13:06] [index:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-11-29 03:13:08] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-11-29 03:17:10] [indexer:background] Health check
[2023-11-29 03:17:10] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2023-11-29 03:20:39] [index:background] Health check
[2023-11-29 03:20:39] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-11-29 03:20:41] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-11-29 03:20:43] [indexer:background] Health check
[2023-11-29 03:20:43] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-11-29 03:20:45] [indexer:background] Health check
[2023-11-29 03:20:45] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2023-11-29 03:28:03] [index:background] Health check
[2023-11-29 03:28:03] [indexer:background] Health check
[2023-11-29 03:28:04] [indexer:background] Health check
[2023-11-29 03:32:08] [indexer:background] Health check
[2023-11-29 03:34:38] [index:background] Health check
[2023-11-29 03:34:38] [indexer:background] Health check
[2023-11-29 03:34:38] [indexer:background] Health check
[2023-11-29 03:37:04] [query] Query for: 2024
[2023-11-29 03:37:04] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 03:37:04] [query] Engine: default
[2023-11-29 03:37:04] [query] Tokens: 2024
[2023-11-29 03:37:04] [query] Mods: 6
[2023-11-29 03:37:04] [query] Found results using: or logic
[2023-11-29 03:37: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 (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-29 03:37:04] [query] Results: 130 Pages of results: 13
[2023-11-29 03:37:04] [query] Execution time: 0.41699
[2023-11-29 03:42:40] [index:background] Health check
[2023-11-29 03:42:40] [index:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-11-29 03:42:42] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-11-29 03:42:44] [indexer:background] Health check
[2023-11-29 03:42:44] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-11-29 03:42:46] [indexer:background] Health check
[2023-11-29 03:42:46] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-11-29 03:46:15] [index:background] Health check
[2023-11-29 03:46:15] [indexer:background] Health check
[2023-11-29 03:46:15] [indexer:background] Health check
[2023-11-29 03:50:35] [index:background] Health check
[2023-11-29 03:50:35] [indexer:background] Health check
[2023-11-29 03:50:35] [indexer:background] Health check
[2023-11-29 03:53:10] [index:background] Health check
[2023-11-29 03:55:14] [indexer:background] Health check
[2023-11-29 03:58:15] [index:background] Health check
[2023-11-29 03:59:40] [indexer:background] Health check
[2023-11-29 04:08:08] [index:background] Health check
[2023-11-29 04:08:08] [indexer:background] Health check
[2023-11-29 04:08:08] [indexer:background] Health check
[2023-11-29 04:13:40] [indexer:background] Health check
[2023-11-29 04:13:40] [index:background] Health check
[2023-11-29 04:17:28] [indexer:background] Health check
[2023-11-29 04:19:30] [index:background] Health check
[2023-11-29 04:19:33] [indexer:background] Health check
[2023-11-29 04:24:45] [index:background] Health check
[2023-11-29 04:24:45] [indexer:background] Health check
[2023-11-29 04:24:45] [indexer:background] Health check
[2023-11-29 04:28:30] [index:background] Health check
[2023-11-29 04:32:44] [indexer:background] Health check
[2023-11-29 04:33:06] [index:background] Health check
[2023-11-29 04:34:41] [indexer:background] Health check
[2023-11-29 04:38:26] [index:background] Health check
[2023-11-29 04:40:13] [indexer:background] Health check
[2023-11-29 04:45:09] [index:background] Health check
[2023-11-29 04:45:09] [indexer:background] Health check
[2023-11-29 04:45:09] [indexer:background] Health check
[2023-11-29 04:50:36] [index:background] Health check
[2023-11-29 04:50:36] [indexer:background] Health check
[2023-11-29 04:50:36] [indexer:background] Health check
[2023-11-29 04:54:36] [index:background] Health check
[2023-11-29 04:54:36] [indexer:background] Health check
[2023-11-29 04:54:36] [indexer:background] Health check
[2023-11-29 04:58:10] [index:background] Health check
[2023-11-29 04:59:36] [indexer:background] Health check
[2023-11-29 05:03:05] [index:background] Health check
[2023-11-29 05:04:33] [indexer:background] Health check
[2023-11-29 05:08:19] [index:background] Health check
[2023-11-29 05:10:23] [indexer:background] Health check
[2023-11-29 05:12:46] [query] Query for: 2024
[2023-11-29 05:12:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 05:12:46] [query] Engine: default
[2023-11-29 05:12:46] [query] Tokens: 2024
[2023-11-29 05:12:46] [query] Mods: 6
[2023-11-29 05:12:46] [query] Found results using: or logic
[2023-11-29 05:12:46] [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-29 05:12:46] [query] Results: 130 Pages of results: 13
[2023-11-29 05:12:46] [query] Execution time: 0.04103
[2023-11-29 05:13:23] [index:background] Health check
[2023-11-29 05:14:46] [indexer:background] Health check
[2023-11-29 05:18:46] [index:background] Health check
[2023-11-29 05:19:48] [indexer:background] Health check
[2023-11-29 05:25:10] [index:background] Health check
[2023-11-29 05:25:10] [indexer:background] Health check
[2023-11-29 05:25:10] [indexer:background] Health check
[2023-11-29 05:28:06] [index:background] Health check
[2023-11-29 05:29:45] [indexer:background] Health check
[2023-11-29 05:34:00] [index:background] Health check
[2023-11-29 05:34:42] [indexer:background] Health check
[2023-11-29 05:38:11] [index:background] Health check
[2023-11-29 05:39:56] [indexer:background] Health check
[2023-11-29 05:43:23] [index:background] Health check
[2023-11-29 05:44:34] [indexer:background] Health check
[2023-11-29 05:51:39] [index:background] Health check
[2023-11-29 05:51:39] [indexer:background] Health check
[2023-11-29 05:51:39] [indexer:background] Health check
[2023-11-29 05:53:05] [index:background] Health check
[2023-11-29 05:54:53] [indexer:background] Health check
[2023-11-29 05:59:32] [index:background] Health check
[2023-11-29 05:59:37] [indexer:background] Health check
[2023-11-29 05:59:37] [indexer:background] Health check
[2023-11-29 06:03:27] [index:background] Health check
[2023-11-29 06:05:25] [indexer:background] Health check
[2023-11-29 06:08:21] [index:background] Health check
[2023-11-29 06:10:19] [indexer:background] Health check
[2023-11-29 06:14:33] [index:background] Health check
[2023-11-29 06:14:33] [indexer:background] Health check
[2023-11-29 06:14:33] [indexer:background] Health check
[2023-11-29 06:20:52] [index:background] Health check
[2023-11-29 06:20:52] [indexer:background] Health check
[2023-11-29 06:20:52] [indexer:background] Health check
[2023-11-29 06:28:50] [index:background] Health check
[2023-11-29 06:28:50] [indexer:background] Health check
[2023-11-29 06:28:50] [indexer:background] Health check
[2023-11-29 06:29:56] [indexer:background] Health check
[2023-11-29 06:33:46] [index:background] Health check
[2023-11-29 06:35:31] [indexer:background] Health check
[2023-11-29 06:39:58] [index:background] Health check
[2023-11-29 06:39:58] [indexer:background] Health check
[2023-11-29 06:39:58] [indexer:background] Health check
[2023-11-29 06:45:42] [index:background] Health check
[2023-11-29 06:45:42] [indexer:background] Health check
[2023-11-29 06:45:42] [indexer:background] Health check
[2023-11-29 06:48:52] [index:background] Health check
[2023-11-29 06:51:14] [indexer:background] Health check
[2023-11-29 06:54:36] [index:background] Health check
[2023-11-29 06:54:36] [indexer:background] Health check
[2023-11-29 06:54:36] [indexer:background] Health check
[2023-11-29 07:00:00] [index:background] Health check
[2023-11-29 07:00:00] [indexer:background] Health check
[2023-11-29 07:00:00] [indexer:background] Health check
[2023-11-29 07:03:50] [index:background] Health check
[2023-11-29 07:07:01] [indexer:background] Health check
[2023-11-29 07:09:43] [index:background] Health check
[2023-11-29 07:09:43] [indexer:background] Health check
[2023-11-29 07:09:43] [indexer:background] Health check
[2023-11-29 07:16:41] [index:background] Health check
[2023-11-29 07:16:41] [indexer:background] Health check
[2023-11-29 07:16:41] [indexer:background] Health check
[2023-11-29 07:18:09] [index:background] Health check
[2023-11-29 07:20:50] [indexer:background] Health check
[2023-11-29 07:23:22] [index:background] Health check
[2023-11-29 07:24:37] [indexer:background] Health check
[2023-11-29 07:29:46] [index:background] Health check
[2023-11-29 07:29:46] [indexer:background] Health check
[2023-11-29 07:29:46] [indexer:background] Health check
[2023-11-29 07:34:50] [index:background] Health check
[2023-11-29 07:34:50] [indexer:background] Health check
[2023-11-29 07:34:50] [indexer:background] Health check
[2023-11-29 07:39:01] [index:background] Health check
[2023-11-29 07:39:47] [indexer:background] Health check
[2023-11-29 07:44:09] [index:background] Health check
[2023-11-29 07:48:13] [indexer:background] Health check
[2023-11-29 07:48:16] [index:background] Health check
[2023-11-29 07:49:43] [indexer:background] Health check
[2023-11-29 07:53:37] [index:background] Health check
[2023-11-29 07:55:35] [indexer:background] Health check
[2023-11-29 07:58:22] [index:background] Health check
[2023-11-29 07:59:46] [indexer:background] Health check
[2023-11-29 08:03:08] [index:background] Health check
[2023-11-29 08:03:52] [query] Query for: 2024
[2023-11-29 08:03:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 08:03:52] [query] Engine: default
[2023-11-29 08:03:52] [query] Tokens: 2024
[2023-11-29 08:03:52] [query] Mods: 6
[2023-11-29 08:03:52] [query] Found results using: or logic
[2023-11-29 08:03:52] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-11-29 08:03:52] [query] Results: 130 Pages of results: 13
[2023-11-29 08:03:52] [query] Execution time: 0.03832
[2023-11-29 08:04:34] [indexer:background] Health check
[2023-11-29 08:09:35] [index:background] Health check
[2023-11-29 08:09:35] [indexer:background] Health check
[2023-11-29 08:09:35] [indexer:background] Health check
[2023-11-29 08:14:06] [index:background] Health check
[2023-11-29 08:15:17] [indexer:background] Health check
[2023-11-29 08:18:05] [index:background] Health check
[2023-11-29 08:19:50] [indexer:background] Health check
[2023-11-29 08:23:33] [index:background] Health check
[2023-11-29 08:24:57] [indexer:background] Health check
[2023-11-29 08:28:30] [index:background] Health check
[2023-11-29 08:29:35] [indexer:background] Health check
[2023-11-29 08:33:57] [index:background] Health check
[2023-11-29 08:34:58] [indexer:background] Health check
[2023-11-29 08:38:34] [index:background] Health check
[2023-11-29 08:38:34] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-11-29 08:38:36] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-11-29 08:41:04] [indexer:background] Health check
[2023-11-29 08:45:26] [index:background] Health check
[2023-11-29 08:45:27] [indexer:background] Health check
[2023-11-29 08:45:27] [indexer:background] Health check
[2023-11-29 08:48:03] [index:background] Health check
[2023-11-29 08:50:25] [indexer:background] Health check
[2023-11-29 08:53:31] [index:background] Health check
[2023-11-29 08:54:53] [indexer:background] Health check
[2023-11-29 08:59:09] [index:background] Health check
[2023-11-29 08:59:45] [indexer:background] Health check
[2023-11-29 09:03:26] [index:background] Health check
[2023-11-29 09:03:26] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-29 09:04:41] [indexer:background] Health check
[2023-11-29 09:08:30] [index:background] Health check
[2023-11-29 09:09:56] [indexer:background] Health check
[2023-11-29 09:13:13] [query] Query for: 2024
[2023-11-29 09:13:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 09:13:13] [query] Engine: default
[2023-11-29 09:13:13] [query] Tokens: 2024
[2023-11-29 09:13:13] [query] Mods: 6
[2023-11-29 09:13:13] [query] Found results using: or logic
[2023-11-29 09:13:13] [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-29 09:13:13] [query] Results: 130 Pages of results: 13
[2023-11-29 09:13:13] [query] Execution time: 0.04134
[2023-11-29 09:13:15] [index:background] Health check
[2023-11-29 09:15:22] [indexer:background] Health check
[2023-11-29 09:18:03] [index:background] Health check
[2023-11-29 09:18:03] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-29 09:18:05] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-29 09:19:57] [indexer:background] Health check
[2023-11-29 09:23:41] [index:background] Health check
[2023-11-29 09:24:36] [indexer:background] Health check
[2023-11-29 09:28:23] [index:background] Health check
[2023-11-29 09:29:48] [indexer:background] Health check
[2023-11-29 09:33:20] [index:background] Health check
[2023-11-29 09:35:12] [indexer:background] Health check
[2023-11-29 09:35:12] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-11-29 09:38:18] [index:background] Health check
[2023-11-29 09:39:32] [indexer:background] Health check
[2023-11-29 09:44:18] [index:background] Health check
[2023-11-29 09:45:31] [indexer:background] Health check
[2023-11-29 09:48:02] [index:background] Health check
[2023-11-29 09:51:05] [indexer:background] Health check
[2023-11-29 09:53:29] [index:background] Health check
[2023-11-29 09:55:19] [indexer:background] Health check
[2023-11-29 09:59:51] [index:background] Health check
[2023-11-29 09:59:51] [indexer:background] Health check
[2023-11-29 09:59:52] [indexer:background] Health check
[2023-11-29 10:04:54] [index:background] Health check
[2023-11-29 10:04:54] [indexer:background] Health check
[2023-11-29 10:04:54] [indexer:background] Health check
[2023-11-29 10:08:04] [index:background] Health check
[2023-11-29 10:08:04] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2023-11-29 10:08:06] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-11-29 10:09:46] [indexer:background] Health check
[2023-11-29 10:13:32] [index:background] Health check
[2023-11-29 10:13:32] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-11-29 10:13:34] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-11-29 10:16:15] [indexer:background] Health check
[2023-11-29 10:18:05] [index:background] Health check
[2023-11-29 10:18:05] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-29 10:18:07] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-11-29 10:19:36] [indexer:background] Health check
[2023-11-29 10:19:36] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-11-29 10:23:09] [index:background] Health check
[2023-11-29 10:25:40] [indexer:background] Health check
[2023-11-29 10:28:04] [index:background] Health check
[2023-11-29 10:29:32] [indexer:background] Health check
[2023-11-29 10:34:34] [index:background] Health check
[2023-11-29 10:34:34] [indexer:background] Health check
[2023-11-29 10:34:34] [indexer:background] Health check
[2023-11-29 10:38:31] [index:background] Health check
[2023-11-29 10:39:39] [indexer:background] Health check
[2023-11-29 10:43:03] [index:background] Health check
[2023-11-29 10:45:40] [indexer:background] Health check
[2023-11-29 10:48:04] [index:background] Health check
[2023-11-29 10:49:42] [indexer:background] Health check
[2023-11-29 10:53:04] [index:background] Health check
[2023-11-29 10:55:26] [indexer:background] Health check
[2023-11-29 10:59:48] [index:background] Health check
[2023-11-29 10:59:48] [indexer:background] Health check
[2023-11-29 10:59:48] [indexer:background] Health check
[2023-11-29 11:03:18] [index:background] Health check
[2023-11-29 11:03:18] [index:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2023-11-29 11:03:20] [indexer:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2023-11-29 11:05:18] [indexer:background] Health check
[2023-11-29 11:08:05] [index:background] Health check
[2023-11-29 11:09:54] [indexer:background] Health check
[2023-11-29 11:13:12] [index:background] Health check
[2023-11-29 11:15:57] [indexer:background] Health check
[2023-11-29 11:18:11] [index:background] Health check
[2023-11-29 11:20:31] [indexer:background] Health check
[2023-11-29 11:23:14] [index:background] Health check
[2023-11-29 11:24:57] [indexer:background] Health check
[2023-11-29 11:28:06] [index:background] Health check
[2023-11-29 11:29:47] [indexer:background] Health check
[2023-11-29 11:33:52] [index:background] Health check
[2023-11-29 11:34:54] [indexer:background] Health check
[2023-11-29 11:38:41] [index:background] Health check
[2023-11-29 11:41:36] [indexer:background] Health check
[2023-11-29 11:43:21] [index:background] Health check
[2023-11-29 11:45:25] [indexer:background] Health check
[2023-11-29 11:48:16] [index:background] Health check
[2023-11-29 11:49:47] [indexer:background] Health check
[2023-11-29 11:53:06] [index:background] Health check
[2023-11-29 11:55:48] [indexer:background] Health check
[2023-11-29 11:59:30] [index:background] Health check
[2023-11-29 12:00:00] [indexer:background] Health check
[2023-11-29 12:03:14] [index:background] Health check
[2023-11-29 12:05:00] [indexer:background] Health check
[2023-11-29 12:08:05] [index:background] Health check
[2023-11-29 12:10:54] [indexer:background] Health check
[2023-11-29 12:14:26] [index:background] Health check
[2023-11-29 12:14:42] [indexer:background] Health check
[2023-11-29 12:18:10] [index:background] Health check
[2023-11-29 12:25:15] [indexer:background] Health check
[2023-11-29 12:25:15] [index:background] Health check
[2023-11-29 12:28:03] [index:background] Health check
[2023-11-29 12:30:17] [indexer:background] Health check
[2023-11-29 12:33:38] [index:background] Health check
[2023-11-29 12:36:07] [indexer:background] Health check
[2023-11-29 12:38:37] [index:background] Health check
[2023-11-29 12:40:01] [indexer:background] Health check
[2023-11-29 12:44:46] [index:background] Health check
[2023-11-29 12:44:46] [indexer:background] Health check
[2023-11-29 12:44:46] [indexer:background] Health check
[2023-11-29 12:50:48] [index:background] Health check
[2023-11-29 12:50:48] [indexer:background] Health check
[2023-11-29 12:50:48] [indexer:background] Health check
[2023-11-29 12:53:36] [index:background] Health check
[2023-11-29 12:55:17] [indexer:background] Health check
[2023-11-29 12:58:38] [index:background] Health check
[2023-11-29 12:59:48] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2023-11-29 12:59:48] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 12:59:48] [query] Engine: default
[2023-11-29 12:59:49] [indexer:background] Health check
[2023-11-29 12:59:49] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2023-11-29 12:59:49] [query] Mods: 6
[2023-11-29 12:59:49] [query] Using OR logic
[2023-11-29 12:59:50] [query] Found results using: or logic
[2023-11-29 12:59: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 (20886,13853,27861,45186,333334,8840,4915,69784,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-11-29 12:59:50] [query] Results: 894 Pages of results: 90
[2023-11-29 12:59:50] [query] Execution time: 1.16340
[2023-11-29 13:02:16] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2023-11-29 13:02:16] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 13:02:16] [query] Engine: default
[2023-11-29 13:02:16] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2023-11-29 13:02:16] [query] Mods: 6
[2023-11-29 13:02:16] [query] Using OR logic
[2023-11-29 13:02:16] [query] Found results using: or logic
[2023-11-29 13:02:16] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (20886,13853,27861,45186,333334,8840,4915,69784,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-11-29 13:02:16] [query] Results: 894 Pages of results: 90
[2023-11-29 13:02:16] [query] Execution time: 0.04911
[2023-11-29 13:03:36] [index:background] Health check
[2023-11-29 13:05:33] [indexer:background] Health check
[2023-11-29 13:08:12] [index:background] Health check
[2023-11-29 13:10:56] [indexer:background] Health check
[2023-11-29 13:13:44] [index:background] Health check
[2023-11-29 13:15:34] [indexer:background] Health check
[2023-11-29 13:15:34] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-29 13:18:31] [index:background] Health check
[2023-11-29 13:19:38] [indexer:background] Health check
[2023-11-29 13:23:02] [index:background] Health check
[2023-11-29 13:23:02] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-29 13:23:04] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-29 13:26:12] [indexer:background] Health check
[2023-11-29 13:28:49] [index:background] Health check
[2023-11-29 13:30:24] [indexer:background] Health check
[2023-11-29 13:33:16] [index:background] Health check
[2023-11-29 13:35:10] [indexer:background] Health check
[2023-11-29 13:38:42] [index:background] Health check
[2023-11-29 13:40:06] [indexer:background] Health check
[2023-11-29 13:43:18] [index:background] Health check
[2023-11-29 13:43:18] [index:background] Health check
[2023-11-29 13:45:23] [indexer:background] Health check
[2023-11-29 13:48:34] [index:background] Health check
[2023-11-29 13:51:51] [indexer:background] Health check
[2023-11-29 13:53:35] [index:background] Health check
[2023-11-29 13:54:46] [indexer:background] Health check
[2023-11-29 13:58:13] [index:background] Health check
[2023-11-29 13:59:36] [indexer:background] Health check
[2023-11-29 14:03:15] [index:background] Health check
[2023-11-29 14:06:18] [indexer:background] Health check
[2023-11-29 14:08:03] [index:background] Health check
[2023-11-29 14:09:55] [indexer:background] Health check
[2023-11-29 14:13:32] [index:background] Health check
[2023-11-29 14:14:40] [indexer:background] Health check
[2023-11-29 14:18:47] [index:background] Health check
[2023-11-29 14:18:47] [index:background] CPU load threshold (3) breached: 4.19 [waiting 2]
[2023-11-29 14:18:49] [indexer:background] CPU load threshold (3) breached: 4.18 [waiting 2]
[2023-11-29 14:20:35] [indexer:background] Health check
[2023-11-29 14:20:35] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-11-29 14:23:14] [index:background] Health check
[2023-11-29 14:23:14] [index:background] CPU load threshold (3) breached: 4.37 [waiting 2]
[2023-11-29 14:23:16] [indexer:background] CPU load threshold (3) breached: 4.37 [waiting 2]
[2023-11-29 14:24:43] [indexer:background] Health check
[2023-11-29 14:24:43] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-11-29 14:29:16] [index:background] Health check
[2023-11-29 14:30:54] [indexer:background] Health check
[2023-11-29 14:33:13] [index:background] Health check
[2023-11-29 14:36:34] [indexer:background] Health check
[2023-11-29 14:38:48] [index:background] Health check
[2023-11-29 14:39:37] [indexer:background] Health check
[2023-11-29 14:43:39] [index:background] Health check
[2023-11-29 14:44:48] [indexer:background] Health check
[2023-11-29 14:48:14] [index:background] Health check
[2023-11-29 14:49:45] [indexer:background] Health check
[2023-11-29 14:53:26] [index:background] Health check
[2023-11-29 14:54:56] [indexer:background] Health check
[2023-11-29 14:58:04] [index:background] Health check
[2023-11-29 14:58:04] [indexer] Queued next batch (1)
[2023-11-29 14:58:08] [indexer] Processing batch (1)
[2023-11-29 14:58:08] [indexer] Indexing post.attachment:14041
[2023-11-29 14:58:08] [index] Marking [1] post.attachment 14041 as indexed
[2023-11-29 14:58:08] [indexer] Index built
[2023-11-29 14:59:36] [indexer:background] Health check
[2023-11-29 14:59:36] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2023-11-29 15:03:03] [index:background] Health check
[2023-11-29 15:04:38] [indexer:background] Health check
[2023-11-29 15:08:03] [index:background] Health check
[2023-11-29 15:08:03] [indexer] Queued next batch (1)
[2023-11-29 15:08:06] [indexer] Processing batch (1)
[2023-11-29 15:08:06] [indexer] Indexing post.attachment:14045
[2023-11-29 15:08:06] [index] Marking [1] post.attachment 14045 as indexed
[2023-11-29 15:08:06] [indexer] Index built
[2023-11-29 15:09:35] [indexer:background] Health check
[2023-11-29 15:13:09] [index:background] Health check
[2023-11-29 15:13:09] [indexer] Queued next batch (1)
[2023-11-29 15:13:12] [indexer] Processing batch (1)
[2023-11-29 15:13:12] [indexer] Indexing post.attachment:14049
[2023-11-29 15:13:12] [index] Marking [1] post.attachment 14049 as indexed
[2023-11-29 15:13:12] [indexer] Index built
[2023-11-29 15:15:46] [indexer:background] Health check
[2023-11-29 15:15:47] [indexer:background] Health check
[2023-11-29 15:18:04] [index:background] Health check
[2023-11-29 15:18:04] [indexer] Queued next batch (1)
[2023-11-29 15:18:07] [indexer] Processing batch (1)
[2023-11-29 15:18:07] [indexer] Indexing post.attachment:14053
[2023-11-29 15:18:07] [index] Marking [1] post.attachment 14053 as indexed
[2023-11-29 15:18:07] [indexer] Index built
[2023-11-29 15:19:59] [indexer:background] Health check
[2023-11-29 15:23:17] [index:background] Health check
[2023-11-29 15:24:48] [indexer:background] Health check
[2023-11-29 15:28:05] [index:background] Health check
[2023-11-29 15:29:41] [indexer:background] Health check
[2023-11-29 15:33:30] [index:background] Health check
[2023-11-29 15:34:41] [indexer:background] Health check
[2023-11-29 15:38:07] [index:background] Health check
[2023-11-29 15:39:35] [indexer:background] Health check
[2023-11-29 15:39:35] [indexer] Queued next batch (1)
[2023-11-29 15:44:29] [index:background] Health check
[2023-11-29 15:44:29] [indexer] Processing batch (1)
[2023-11-29 15:44:29] [indexer] Indexing post.attachment:14054
[2023-11-29 15:44:29] [index] Marking [1] post.attachment 14054 as indexed
[2023-11-29 15:45:13] [indexer:background] Health check
[2023-11-29 15:48:06] [index:background] Health check
[2023-11-29 15:50:31] [indexer:background] Health check
[2023-11-29 15:54:13] [index:background] Health check
[2023-11-29 15:54:34] [indexer:background] Health check
[2023-11-29 15:58:06] [index:background] Health check
[2023-11-29 15:59:41] [indexer:background] Health check
[2023-11-29 16:03:13] [index:background] Health check
[2023-11-29 16:04:41] [indexer:background] Health check
[2023-11-29 16:08:13] [index:background] Health check
[2023-11-29 16:09:34] [indexer:background] Health check
[2023-11-29 16:13:24] [index:background] Health check
[2023-11-29 16:14:43] [indexer:background] Health check
[2023-11-29 16:18:09] [index:background] Health check
[2023-11-29 16:19:38] [indexer:background] Health check
[2023-11-29 16:23:08] [index:background] Health check
[2023-11-29 16:24:53] [indexer:background] Health check
[2023-11-29 16:28:10] [index:background] Health check
[2023-11-29 16:29:40] [indexer:background] Health check
[2023-11-29 16:33:10] [index:background] Health check
[2023-11-29 16:34:37] [indexer:background] Health check
[2023-11-29 16:38:35] [index:background] Health check
[2023-11-29 16:40:04] [indexer:background] Health check
[2023-11-29 16:43:11] [index:background] Health check
[2023-11-29 16:44:36] [indexer:background] Health check
[2023-11-29 16:46:07] [query] Query for: 2023
[2023-11-29 16:46:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 16:46:07] [query] Engine: default
[2023-11-29 16:46:08] [query] Tokens: 2023
[2023-11-29 16:46:08] [query] Mods: 6
[2023-11-29 16:46:08] [query] Found results using: or logic
[2023-11-29 16:46:08] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-11-29 16:46:08] [query] Results: 253 Pages of results: 26
[2023-11-29 16:46:08] [query] Execution time: 1.00752
[2023-11-29 16:46:08] [query] Query for: 2023
[2023-11-29 16:46:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-29 16:46:08] [query] Engine: default
[2023-11-29 16:46:08] [query] Tokens: 2023
[2023-11-29 16:46:08] [query] Mods: 6
[2023-11-29 16:46:08] [query] Found results using: or logic
[2023-11-29 16:46:08] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2023-11-29 16:46:08] [query] Results: 253 Pages of results: 3
[2023-11-29 16:46:08] [query] Execution time: 0.11173
[2023-11-29 16:48:40] [index:background] Health check
[2023-11-29 16:50:21] [indexer:background] Health check
[2023-11-29 16:50:23] [query] Query for: {search_term_string}
[2023-11-29 16:50:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 62 offset: 0 fields: all
[2023-11-29 16:50:23] [query] Engine: default
[2023-11-29 16:50:24] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-29 16:50:24] [query] Mods: 6
[2023-11-29 16:50:24] [query] Using OR logic
[2023-11-29 16:50:24] [query] Found results using: or logic
[2023-11-29 16:50:24] [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 610, 10
[2023-11-29 16:50:24] [query] Results: 1346 Pages of results: 135
[2023-11-29 16:50:24] [query] Execution time: 1.06280
[2023-11-29 16:54:24] [index:background] Health check
[2023-11-29 16:54:39] [indexer:background] Health check
[2023-11-29 16:58:27] [index:background] Health check
[2023-11-29 17:00:44] [indexer:background] Health check
[2023-11-29 17:03:12] [index:background] Health check
[2023-11-29 17:05:29] [indexer:background] Health check
[2023-11-29 17:08:09] [index:background] Health check
[2023-11-29 17:09:46] [indexer:background] Health check
[2023-11-29 17:11:41] [query] Query for: 2023
[2023-11-29 17:11:41] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 17:11:41] [query] Engine: default
[2023-11-29 17:11:41] [query] Tokens: 2023
[2023-11-29 17:11:41] [query] Mods: 6
[2023-11-29 17:11:41] [query] Found results using: or logic
[2023-11-29 17:11:41] [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-29 17:11:41] [query] Results: 253 Pages of results: 26
[2023-11-29 17:11:41] [query] Execution time: 0.04402
[2023-11-29 17:13:17] [index:background] Health check
[2023-11-29 17:14:39] [indexer:background] Health check
[2023-11-29 17:18:08] [index:background] Health check
[2023-11-29 17:18:08] [indexer] Queued next batch (1)
[2023-11-29 17:18:11] [indexer] Processing batch (1)
[2023-11-29 17:18:11] [indexer] Indexing post.attachment:14061
[2023-11-29 17:18:11] [index] Marking [1] post.attachment 14061 as indexed
[2023-11-29 17:18:11] [indexer] Index built
[2023-11-29 17:20:27] [indexer:background] Health check
[2023-11-29 17:23:13] [index:background] Health check
[2023-11-29 17:24:43] [indexer:background] Health check
[2023-11-29 17:28:43] [index:background] Health check
[2023-11-29 17:29:33] [indexer:background] Health check
[2023-11-29 17:33:32] [index:background] Health check
[2023-11-29 17:35:09] [indexer:background] Health check
[2023-11-29 17:38:49] [index:background] Health check
[2023-11-29 17:42:52] [indexer:background] Health check
[2023-11-29 17:43:37] [index:background] Health check
[2023-11-29 17:44:59] [indexer:background] Health check
[2023-11-29 17:49:40] [index:background] Health check
[2023-11-29 17:49:40] [indexer:background] Health check
[2023-11-29 17:49:40] [indexer:background] Health check
[2023-11-29 17:52:32] [query] Query for: 2024
[2023-11-29 17:52:32] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-29 17:52:32] [query] Engine: default
[2023-11-29 17:52:32] [query] Tokens: 2024
[2023-11-29 17:52:32] [query] Mods: 6
[2023-11-29 17:52:33] [query] Found results using: or logic
[2023-11-29 17:52:33] [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-29 17:52:33] [query] Results: 130 Pages of results: 13
[2023-11-29 17:52:33] [query] Execution time: 0.11081
[2023-11-29 17:53:42] [index:background] Health check
[2023-11-29 17:55:43] [indexer:background] Health check
[2023-11-29 17:59:04] [index:background] Health check
[2023-11-29 18:00:06] [indexer:background] Health check
[2023-11-29 18:03:23] [index:background] Health check
[2023-11-29 18:04:48] [indexer:background] Health check
[2023-11-29 18:08:17] [index:background] Health check
[2023-11-29 18:09:35] [indexer:background] Health check
[2023-11-29 18:13:05] [index:background] Health check
[2023-11-29 18:14:36] [indexer:background] Health check
[2023-11-29 18:18:14] [index:background] Health check
[2023-11-29 18:20:28] [indexer:background] Health check
[2023-11-29 18:23:39] [index:background] Health check
[2023-11-29 18:24:42] [indexer:background] Health check
[2023-11-29 18:28:24] [index:background] Health check
[2023-11-29 18:30:24] [indexer:background] Health check
[2023-11-29 18:33:39] [index:background] Health check
[2023-11-29 18:36:53] [indexer:background] Health check
[2023-11-29 18:38:45] [index:background] Health check
[2023-11-29 18:39:34] [indexer:background] Health check
[2023-11-29 18:43:06] [index:background] Health check
[2023-11-29 18:45:35] [indexer:background] Health check
[2023-11-29 18:48:02] [index:background] Health check
[2023-11-29 18:49:34] [indexer:background] Health check
[2023-11-29 18:53:05] [index:background] Health check
[2023-11-29 18:53:05] [index:background] CPU load threshold (3) breached: 4.23 [waiting 2]
[2023-11-29 18:53:08] [indexer:background] CPU load threshold (3) breached: 3.89 [waiting 2]
[2023-11-29 18:54:36] [indexer:background] Health check
[2023-11-29 18:58:08] [index:background] Health check
[2023-11-29 18:59:34] [indexer:background] Health check
[2023-11-29 19:05:11] [index:background] Health check
[2023-11-29 19:05:11] [indexer:background] Health check
[2023-11-29 19:05:11] [indexer:background] Health check
[2023-11-29 19:09:59] [index:background] Health check
[2023-11-29 19:09:59] [indexer:background] Health check
[2023-11-29 19:09:59] [indexer:background] Health check
[2023-11-29 19:15:41] [index:background] Health check
[2023-11-29 19:15:41] [indexer:background] Health check
[2023-11-29 19:15:41] [indexer:background] Health check
[2023-11-29 19:19:03] [index:background] Health check
[2023-11-29 19:20:20] [indexer:background] Health check
[2023-11-29 19:23:18] [index:background] Health check
[2023-11-29 19:25:11] [indexer:background] Health check
[2023-11-29 19:28:43] [index:background] Health check
[2023-11-29 19:31:09] [indexer:background] Health check
[2023-11-29 19:34:10] [index:background] Health check
[2023-11-29 19:36:13] [indexer:background] Health check
[2023-11-29 19:38:37] [index:background] Health check
[2023-11-29 19:39:42] [indexer:background] Health check
[2023-11-29 19:43:03] [index:background] Health check
[2023-11-29 19:45:01] [indexer:background] Health check
[2023-11-29 19:49:56] [index:background] Health check
[2023-11-29 19:49:56] [indexer:background] Health check
[2023-11-29 19:49:56] [indexer:background] Health check
[2023-11-29 19:53:57] [index:background] Health check
[2023-11-29 19:55:22] [indexer:background] Health check
[2023-11-29 19:58:22] [index:background] Health check
[2023-11-29 20:00:26] [indexer:background] Health check
[2023-11-29 20:03:25] [index:background] Health check
[2023-11-29 20:05:36] [indexer:background] Health check
[2023-11-29 20:08:19] [index:background] Health check
[2023-11-29 20:10:30] [indexer:background] Health check
[2023-11-29 20:15:52] [index:background] Health check
[2023-11-29 20:15:52] [indexer:background] Health check
[2023-11-29 20:15:52] [indexer:background] Health check
[2023-11-29 20:19:28] [index:background] Health check
[2023-11-29 20:22:24] [indexer:background] Health check
[2023-11-29 20:23:59] [index:background] Health check
[2023-11-29 20:24:41] [indexer:background] Health check
[2023-11-29 20:28:44] [index:background] Health check
[2023-11-29 20:29:41] [indexer:background] Health check
[2023-11-29 20:33:58] [index:background] Health check
[2023-11-29 20:37:08] [indexer:background] Health check
[2023-11-29 20:39:25] [index:background] Health check
[2023-11-29 20:40:33] [indexer:background] Health check
[2023-11-29 20:43:12] [index:background] Health check
[2023-11-29 20:46:07] [indexer:background] Health check
[2023-11-29 20:52:44] [index:background] Health check
[2023-11-29 20:52:44] [indexer:background] Health check
[2023-11-29 20:52:44] [indexer:background] Health check
[2023-11-29 20:54:26] [index:background] Health check
[2023-11-29 20:57:25] [indexer:background] Health check
[2023-11-29 20:58:49] [index:background] Health check
[2023-11-29 21:02:04] [indexer:background] Health check
[2023-11-29 21:07:38] [index:background] Health check
[2023-11-29 21:07:38] [indexer:background] Health check
[2023-11-29 21:07:39] [indexer:background] Health check
[2023-11-29 21:08:05] [index:background] Health check
[2023-11-29 21:09:55] [indexer:background] Health check
[2023-11-29 21:13:12] [index:background] Health check
[2023-11-29 21:15:30] [indexer:background] Health check
[2023-11-29 21:18:47] [index:background] Health check
[2023-11-29 21:20:04] [indexer:background] Health check
[2023-11-29 21:23:06] [index:background] Health check
[2023-11-29 21:25:19] [indexer:background] Health check
[2023-11-29 21:28:12] [index:background] Health check
[2023-11-29 21:30:53] [indexer:background] Health check
[2023-11-29 21:35:20] [index:background] Health check
[2023-11-29 21:35:20] [indexer:background] Health check
[2023-11-29 21:35:20] [indexer:background] Health check
[2023-11-29 21:40:25] [index:background] Health check
[2023-11-29 21:40:25] [indexer:background] Health check
[2023-11-29 21:40:25] [indexer:background] Health check
[2023-11-29 21:44:31] [index:background] Health check
[2023-11-29 21:44:50] [indexer:background] Health check
[2023-11-29 21:49:32] [index:background] Health check
[2023-11-29 21:49:32] [indexer:background] Health check
[2023-11-29 21:49:32] [indexer:background] Health check
[2023-11-29 21:53:46] [index:background] Health check
[2023-11-29 21:55:08] [indexer:background] Health check
[2023-11-29 21:58:12] [index:background] Health check
[2023-11-29 21:59:48] [indexer:background] Health check
[2023-11-29 22:05:14] [index:background] Health check
[2023-11-29 22:05:14] [indexer:background] Health check
[2023-11-29 22:05:14] [indexer:background] Health check
[2023-11-29 22:09:00] [index:background] Health check
[2023-11-29 22:10:28] [indexer:background] Health check
[2023-11-29 22:13:12] [index:background] Health check
[2023-11-29 22:14:45] [indexer:background] Health check
[2023-11-29 22:18:15] [index:background] Health check
[2023-11-29 22:20:54] [indexer:background] Health check
[2023-11-29 22:23:28] [index:background] Health check
[2023-11-29 22:24:43] [indexer:background] Health check
[2023-11-29 22:28:10] [index:background] Health check
[2023-11-29 22:29:51] [indexer:background] Health check
[2023-11-29 22:33:13] [index:background] Health check
[2023-11-29 22:34:49] [indexer:background] Health check
[2023-11-29 22:40:42] [index:background] Health check
[2023-11-29 22:40:42] [indexer:background] Health check
[2023-11-29 22:40:42] [indexer:background] Health check
[2023-11-29 22:43:59] [index:background] Health check
[2023-11-29 22:44:53] [indexer:background] Health check
[2023-11-29 22:48:47] [index:background] Health check
[2023-11-29 22:52:52] [indexer:background] Health check
[2023-11-29 22:53:14] [index:background] Health check
[2023-11-29 22:54:40] [indexer:background] Health check
[2023-11-29 22:58:12] [index:background] Health check
[2023-11-29 23:00:28] [indexer:background] Health check
[2023-11-29 23:06:51] [index:background] Health check
[2023-11-29 23:06:51] [indexer:background] Health check
[2023-11-29 23:06:51] [indexer:background] Health check
[2023-11-29 23:10:20] [index:background] Health check
[2023-11-29 23:10:21] [indexer:background] Health check
[2023-11-29 23:10:21] [indexer:background] Health check
[2023-11-29 23:13:12] [index:background] Health check
[2023-11-29 23:16:56] [indexer:background] Health check
[2023-11-29 23:18:35] [index:background] Health check
[2023-11-29 23:20:10] [indexer:background] Health check
[2023-11-29 23:23:22] [index:background] Health check
[2023-11-29 23:25:33] [indexer:background] Health check
[2023-11-29 23:28:12] [index:background] Health check
[2023-11-29 23:30:14] [indexer:background] Health check
[2023-11-29 23:35:02] [index:background] Health check
[2023-11-29 23:35:02] [indexer:background] Health check
[2023-11-29 23:35:02] [indexer:background] Health check
[2023-11-29 23:39:40] [index:background] Health check
[2023-11-29 23:39:40] [indexer:background] Health check
[2023-11-29 23:39:40] [indexer:background] Health check
[2023-11-29 23:44:09] [index:background] Health check
[2023-11-29 23:46:03] [indexer:background] Health check
[2023-11-29 23:48:05] [index:background] Health check
[2023-11-29 23:50:30] [indexer:background] Health check
[2023-11-29 23:54:30] [index:background] Health check
[2023-11-29 23:55:44] [indexer:background] Health check
[2023-11-29 23:59:15] [index:background] Health check
[2023-11-29 23:59:39] [indexer:background] Health check