[2024-07-16 00:04:49] [index:background] Health check
[2024-07-16 00:04:49] [indexer:background] Health check
[2024-07-16 00:04:49] [indexer:background] Health check
[2024-07-16 00:09:08] [index:background] Health check
[2024-07-16 00:10:13] [indexer:background] Health check
[2024-07-16 00:13:56] [index:background] Health check
[2024-07-16 00:14:57] [indexer:background] Health check
[2024-07-16 00:21:41] [index:background] Health check
[2024-07-16 00:21:41] [indexer:background] Health check
[2024-07-16 00:21:41] [indexer:background] Health check
[2024-07-16 00:24:31] [index:background] Health check
[2024-07-16 00:24:31] [indexer:background] Health check
[2024-07-16 00:24:31] [indexer:background] Health check
[2024-07-16 00:29:24] [index:background] Health check
[2024-07-16 00:29:25] [indexer:background] Health check
[2024-07-16 00:29:25] [indexer:background] Health check
[2024-07-16 00:33:42] [index:background] Health check
[2024-07-16 00:35:49] [indexer:background] Health check
[2024-07-16 00:38:43] [index:background] Health check
[2024-07-16 00:40:06] [indexer:background] Health check
[2024-07-16 00:44:14] [index:background] Health check
[2024-07-16 00:44:30] [indexer:background] Health check
[2024-07-16 00:49:04] [index:background] Health check
[2024-07-16 00:50:09] [indexer:background] Health check
[2024-07-16 00:53:50] [index:background] Health check
[2024-07-16 00:55:24] [indexer:background] Health check
[2024-07-16 00:59:52] [index:background] Health check
[2024-07-16 00:59:52] [indexer:background] Health check
[2024-07-16 00:59:52] [indexer:background] Health check
[2024-07-16 01:04:52] [index:background] Health check
[2024-07-16 01:04:52] [indexer:background] Health check
[2024-07-16 01:04:52] [indexer:background] Health check
[2024-07-16 01:09:23] [index:background] Health check
[2024-07-16 01:09:23] [indexer:background] Health check
[2024-07-16 01:09:23] [indexer:background] Health check
[2024-07-16 01:14:40] [index:background] Health check
[2024-07-16 01:14:40] [indexer:background] Health check
[2024-07-16 01:14:40] [indexer:background] Health check
[2024-07-16 01:19:53] [index:background] Health check
[2024-07-16 01:19:53] [indexer:background] Health check
[2024-07-16 01:19:53] [indexer:background] Health check
[2024-07-16 01:23:45] [index:background] Health check
[2024-07-16 01:24:35] [indexer:background] Health check
[2024-07-16 01:29:46] [index:background] Health check
[2024-07-16 01:29:46] [indexer:background] Health check
[2024-07-16 01:29:46] [indexer:background] Health check
[2024-07-16 01:33:54] [index:background] Health check
[2024-07-16 01:35:01] [indexer:background] Health check
[2024-07-16 01:39:04] [index:background] Health check
[2024-07-16 01:40:45] [indexer:background] Health check
[2024-07-16 01:44:07] [index:background] Health check
[2024-07-16 01:44:35] [indexer:background] Health check
[2024-07-16 01:48:42] [index:background] Health check
[2024-07-16 01:49:48] [indexer:background] Health check
[2024-07-16 01:54:08] [index:background] Health check
[2024-07-16 01:55:13] [indexer:background] Health check
[2024-07-16 01:59:19] [index:background] Health check
[2024-07-16 01:59:19] [indexer:background] Health check
[2024-07-16 01:59:19] [indexer:background] Health check
[2024-07-16 02:04:08] [index:background] Health check
[2024-07-16 02:05:51] [indexer:background] Health check
[2024-07-16 02:10:13] [index:background] Health check
[2024-07-16 02:10:14] [indexer:background] Health check
[2024-07-16 02:10:14] [indexer:background] Health check
[2024-07-16 02:14:27] [index:background] Health check
[2024-07-16 02:14:27] [indexer:background] Health check
[2024-07-16 02:14:27] [indexer:background] Health check
[2024-07-16 02:19:54] [index:background] Health check
[2024-07-16 02:19:54] [indexer:background] Health check
[2024-07-16 02:19:54] [indexer:background] Health check
[2024-07-16 02:23:54] [index:background] Health check
[2024-07-16 02:24:24] [indexer:background] Health check
[2024-07-16 02:30:40] [index:background] Health check
[2024-07-16 02:30:40] [indexer:background] Health check
[2024-07-16 02:30:40] [indexer:background] Health check
[2024-07-16 02:33:53] [index:background] Health check
[2024-07-16 02:36:09] [indexer:background] Health check
[2024-07-16 02:39:10] [index:background] Health check
[2024-07-16 02:39:35] [indexer:background] Health check
[2024-07-16 02:44:04] [index:background] Health check
[2024-07-16 02:44:29] [indexer:background] Health check
[2024-07-16 02:48:50] [index:background] Health check
[2024-07-16 02:48:50] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2024-07-16 02:48:52] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2024-07-16 02:49:26] [indexer:background] Health check
[2024-07-16 02:49:26] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-07-16 02:54:07] [index:background] Health check
[2024-07-16 02:54:18] [indexer:background] Health check
[2024-07-16 02:59:23] [index:background] Health check
[2024-07-16 02:59:23] [indexer:background] Health check
[2024-07-16 02:59:23] [indexer:background] Health check
[2024-07-16 03:03:48] [index:background] Health check
[2024-07-16 03:04:29] [indexer:background] Health check
[2024-07-16 03:10:37] [index:background] Health check
[2024-07-16 03:10:37] [indexer:background] Health check
[2024-07-16 03:10:37] [indexer:background] Health check
[2024-07-16 03:13:51] [index:background] Health check
[2024-07-16 03:15:22] [indexer:background] Health check
[2024-07-16 03:18:48] [index:background] Health check
[2024-07-16 03:21:03] [indexer:background] Health check
[2024-07-16 03:24:04] [index:background] Health check
[2024-07-16 03:27:15] [indexer:background] Health check
[2024-07-16 03:29:21] [index:background] Health check
[2024-07-16 03:29:21] [indexer:background] Health check
[2024-07-16 03:29:21] [indexer:background] Health check
[2024-07-16 03:35:34] [index:background] Health check
[2024-07-16 03:35:34] [indexer:background] Health check
[2024-07-16 03:35:34] [indexer:background] Health check
[2024-07-16 03:38:45] [index:background] Health check
[2024-07-16 03:40:12] [indexer:background] Health check
[2024-07-16 03:44:22] [index:background] Health check
[2024-07-16 03:44:22] [indexer:background] Health check
[2024-07-16 03:44:22] [indexer:background] Health check
[2024-07-16 03:48:52] [index:background] Health check
[2024-07-16 03:49:17] [indexer:background] Health check
[2024-07-16 03:53:43] [index:background] Health check
[2024-07-16 03:55:04] [indexer:background] Health check
[2024-07-16 03:59:19] [index:background] Health check
[2024-07-16 03:59:19] [indexer:background] Health check
[2024-07-16 03:59:19] [indexer:background] Health check
[2024-07-16 04:05:44] [index:background] Health check
[2024-07-16 04:05:44] [indexer:background] Health check
[2024-07-16 04:05:44] [indexer:background] Health check
[2024-07-16 04:08:47] [index:background] Health check
[2024-07-16 04:10:18] [indexer:background] Health check
[2024-07-16 04:17:31] [index:background] Health check
[2024-07-16 04:17:31] [indexer:background] Health check
[2024-07-16 04:17:31] [indexer:background] Health check
[2024-07-16 04:19:35] [index:background] Health check
[2024-07-16 04:19:35] [indexer:background] Health check
[2024-07-16 04:19:35] [indexer:background] Health check
[2024-07-16 04:24:37] [index:background] Health check
[2024-07-16 04:24:37] [indexer:background] Health check
[2024-07-16 04:24:37] [indexer:background] Health check
[2024-07-16 04:28:52] [index:background] Health check
[2024-07-16 04:29:32] [indexer:background] Health check
[2024-07-16 04:35:46] [index:background] Health check
[2024-07-16 04:35:46] [indexer:background] Health check
[2024-07-16 04:35:46] [indexer:background] Health check
[2024-07-16 04:38:49] [index:background] Health check
[2024-07-16 04:42:13] [indexer:background] Health check
[2024-07-16 04:43:49] [index:background] Health check
[2024-07-16 04:44:35] [indexer:background] Health check
[2024-07-16 04:48:50] [index:background] Health check
[2024-07-16 04:49:32] [indexer:background] Health check
[2024-07-16 04:54:48] [index:background] Health check
[2024-07-16 04:54:48] [indexer:background] Health check
[2024-07-16 04:54:48] [indexer:background] Health check
[2024-07-16 04:58:59] [index:background] Health check
[2024-07-16 05:00:00] [indexer:background] Health check
[2024-07-16 05:08:54] [index:background] Health check
[2024-07-16 05:08:54] [indexer:background] Health check
[2024-07-16 05:08:54] [indexer:background] Health check
[2024-07-16 05:09:30] [indexer:background] Health check
[2024-07-16 05:14:35] [index:background] Health check
[2024-07-16 05:14:35] [indexer:background] Health check
[2024-07-16 05:14:35] [indexer:background] Health check
[2024-07-16 05:19:54] [index:background] Health check
[2024-07-16 05:19:54] [indexer:background] Health check
[2024-07-16 05:19:54] [indexer:background] Health check
[2024-07-16 05:24:28] [index:background] Health check
[2024-07-16 05:24:28] [indexer:background] Health check
[2024-07-16 05:24:28] [indexer:background] Health check
[2024-07-16 05:29:34] [index:background] Health check
[2024-07-16 05:29:34] [indexer:background] Health check
[2024-07-16 05:29:34] [indexer:background] Health check
[2024-07-16 05:34:39] [index:background] Health check
[2024-07-16 05:34:40] [indexer:background] Health check
[2024-07-16 05:34:40] [indexer:background] Health check
[2024-07-16 05:39:26] [index:background] Health check
[2024-07-16 05:39:26] [indexer:background] Health check
[2024-07-16 05:39:26] [indexer:background] Health check
[2024-07-16 05:45:35] [index:background] Health check
[2024-07-16 05:45:35] [indexer:background] Health check
[2024-07-16 05:45:35] [indexer:background] Health check
[2024-07-16 05:49:22] [index:background] Health check
[2024-07-16 05:49:22] [indexer:background] Health check
[2024-07-16 05:49:22] [indexer:background] Health check
[2024-07-16 05:54:15] [index:background] Health check
[2024-07-16 05:54:15] [indexer:background] Health check
[2024-07-16 05:54:15] [indexer:background] Health check
[2024-07-16 05:59:54] [index:background] Health check
[2024-07-16 05:59:54] [indexer:background] Health check
[2024-07-16 05:59:54] [indexer:background] Health check
[2024-07-16 06:03:52] [index:background] Health check
[2024-07-16 06:05:01] [indexer:background] Health check
[2024-07-16 06:09:30] [index:background] Health check
[2024-07-16 06:09:30] [indexer:background] Health check
[2024-07-16 06:09:30] [indexer:background] Health check
[2024-07-16 06:14:07] [index:background] Health check
[2024-07-16 06:14:26] [indexer:background] Health check
[2024-07-16 06:19:38] [index:background] Health check
[2024-07-16 06:19:39] [indexer:background] Health check
[2024-07-16 06:19:39] [indexer:background] Health check
[2024-07-16 06:24:19] [index:background] Health check
[2024-07-16 06:24:19] [indexer:background] Health check
[2024-07-16 06:24:20] [indexer:background] Health check
[2024-07-16 06:28:54] [index:background] Health check
[2024-07-16 06:29:28] [indexer:background] Health check
[2024-07-16 06:35:44] [index:background] Health check
[2024-07-16 06:35:44] [indexer:background] Health check
[2024-07-16 06:35:44] [indexer:background] Health check
[2024-07-16 06:39:09] [index:background] Health check
[2024-07-16 06:40:10] [indexer:background] Health check
[2024-07-16 06:45:27] [index:background] Health check
[2024-07-16 06:45:28] [indexer:background] Health check
[2024-07-16 06:45:28] [indexer:background] Health check
[2024-07-16 06:49:20] [index:background] Health check
[2024-07-16 06:49:20] [indexer:background] Health check
[2024-07-16 06:49:20] [indexer:background] Health check
[2024-07-16 06:53:51] [index:background] Health check
[2024-07-16 06:54:52] [indexer:background] Health check
[2024-07-16 06:59:15] [index:background] Health check
[2024-07-16 06:59:15] [indexer:background] Health check
[2024-07-16 06:59:15] [indexer:background] Health check
[2024-07-16 07:04:35] [index:background] Health check
[2024-07-16 07:04:35] [indexer:background] Health check
[2024-07-16 07:04:35] [indexer:background] Health check
[2024-07-16 07:08:47] [index:background] Health check
[2024-07-16 07:09:40] [indexer:background] Health check
[2024-07-16 07:13:55] [index:background] Health check
[2024-07-16 07:14:42] [indexer:background] Health check
[2024-07-16 07:18:49] [index:background] Health check
[2024-07-16 07:19:26] [indexer:background] Health check
[2024-07-16 07:25:12] [index:background] Health check
[2024-07-16 07:25:12] [indexer:background] Health check
[2024-07-16 07:25:12] [indexer:background] Health check
[2024-07-16 07:28:56] [index:background] Health check
[2024-07-16 07:29:30] [indexer:background] Health check
[2024-07-16 07:34:42] [index:background] Health check
[2024-07-16 07:34:42] [indexer:background] Health check
[2024-07-16 07:34:42] [indexer:background] Health check
[2024-07-16 07:39:18] [index:background] Health check
[2024-07-16 07:39:18] [indexer:background] Health check
[2024-07-16 07:39:18] [indexer:background] Health check
[2024-07-16 07:43:43] [index:background] Health check
[2024-07-16 07:44:45] [indexer:background] Health check
[2024-07-16 07:49:22] [index:background] Health check
[2024-07-16 07:49:22] [indexer:background] Health check
[2024-07-16 07:49:22] [indexer:background] Health check
[2024-07-16 07:53:59] [index:background] Health check
[2024-07-16 07:54:23] [indexer:background] Health check
[2024-07-16 07:58:44] [index:background] Health check
[2024-07-16 07:59:33] [indexer:background] Health check
[2024-07-16 08:04:59] [index:background] Health check
[2024-07-16 08:04:59] [indexer:background] Health check
[2024-07-16 08:05:00] [indexer:background] Health check
[2024-07-16 08:10:24] [index:background] Health check
[2024-07-16 08:10:24] [indexer:background] Health check
[2024-07-16 08:10:24] [indexer:background] Health check
[2024-07-16 08:14:24] [index:background] Health check
[2024-07-16 08:14:24] [indexer:background] Health check
[2024-07-16 08:14:24] [indexer:background] Health check
[2024-07-16 08:18:43] [index:background] Health check
[2024-07-16 08:19:28] [indexer:background] Health check
[2024-07-16 08:23:57] [index:background] Health check
[2024-07-16 08:25:01] [indexer:background] Health check
[2024-07-16 08:29:22] [index:background] Health check
[2024-07-16 08:29:23] [indexer:background] Health check
[2024-07-16 08:29:23] [indexer:background] Health check
[2024-07-16 08:33:44] [index:background] Health check
[2024-07-16 08:34:21] [indexer:background] Health check
[2024-07-16 08:39:27] [index:background] Health check
[2024-07-16 08:39:27] [indexer:background] Health check
[2024-07-16 08:39:27] [indexer:background] Health check
[2024-07-16 08:43:59] [index:background] Health check
[2024-07-16 08:45:30] [indexer:background] Health check
[2024-07-16 08:49:42] [index:background] Health check
[2024-07-16 08:49:43] [indexer:background] Health check
[2024-07-16 08:49:43] [indexer:background] Health check
[2024-07-16 08:52:33] [query] Query for: 2025
[2024-07-16 08:52:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-16 08:52:33] [query] Engine: default
[2024-07-16 08:52:35] [query] Tokens: 2025
[2024-07-16 08:52:35] [query] Mods: 6
[2024-07-16 08:52:35] [query] Found results using: or logic
[2024-07-16 08:52:35] [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 (15055) 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
[2024-07-16 08:52:35] [query] Results: 138 Pages of results: 14
[2024-07-16 08:52:35] [query] Execution time: 2.04564
[2024-07-16 08:52:35] [query] Query for: 2025
[2024-07-16 08:52:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-07-16 08:52:35] [query] Engine: default
[2024-07-16 08:52:35] [query] Tokens: 2025
[2024-07-16 08:52:35] [query] Mods: 6
[2024-07-16 08:52:35] [query] Found results using: or logic
[2024-07-16 08:52:36] [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 (15055) 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
[2024-07-16 08:52:36] [query] Results: 138 Pages of results: 2
[2024-07-16 08:52:36] [query] Execution time: 0.22352
[2024-07-16 08:53:50] [index:background] Health check
[2024-07-16 08:54:40] [indexer:background] Health check
[2024-07-16 08:58:49] [index:background] Health check
[2024-07-16 08:59:44] [indexer:background] Health check
[2024-07-16 09:03:44] [index:background] Health check
[2024-07-16 09:04:19] [indexer:background] Health check
[2024-07-16 09:09:17] [index:background] Health check
[2024-07-16 09:09:18] [indexer:background] Health check
[2024-07-16 09:09:18] [indexer:background] Health check
[2024-07-16 09:15:08] [index:background] Health check
[2024-07-16 09:15:08] [indexer:background] Health check
[2024-07-16 09:15:08] [indexer:background] Health check
[2024-07-16 09:18:49] [index:background] Health check
[2024-07-16 09:19:26] [indexer:background] Health check
[2024-07-16 09:27:03] [index:background] Health check
[2024-07-16 09:27:03] [indexer:background] Health check
[2024-07-16 09:27:03] [indexer:background] Health check
[2024-07-16 09:28:48] [index:background] Health check
[2024-07-16 09:29:19] [indexer:background] Health check
[2024-07-16 09:34:12] [index:background] Health check
[2024-07-16 09:34:28] [indexer:background] Health check
[2024-07-16 09:38:45] [index:background] Health check
[2024-07-16 09:39:18] [indexer:background] Health check
[2024-07-16 09:43:46] [index:background] Health check
[2024-07-16 09:44:27] [indexer:background] Health check
[2024-07-16 09:49:36] [index:background] Health check
[2024-07-16 09:49:36] [indexer:background] Health check
[2024-07-16 09:49:36] [indexer:background] Health check
[2024-07-16 09:53:59] [index:background] Health check
[2024-07-16 09:54:44] [indexer:background] Health check
[2024-07-16 09:59:46] [index:background] Health check
[2024-07-16 09:59:46] [indexer:background] Health check
[2024-07-16 09:59:46] [indexer:background] Health check
[2024-07-16 10:03:43] [index:background] Health check
[2024-07-16 10:05:00] [indexer:background] Health check
[2024-07-16 10:08:41] [index:background] Health check
[2024-07-16 10:10:10] [indexer:background] Health check
[2024-07-16 10:13:43] [index:background] Health check
[2024-07-16 10:14:28] [indexer:background] Health check
[2024-07-16 10:19:06] [index:background] Health check
[2024-07-16 10:19:35] [indexer:background] Health check
[2024-07-16 10:23:47] [index:background] Health check
[2024-07-16 10:24:55] [indexer:background] Health check
[2024-07-16 10:28:52] [index:background] Health check
[2024-07-16 10:31:11] [indexer:background] Health check
[2024-07-16 10:33:49] [index:background] Health check
[2024-07-16 10:35:13] [indexer:background] Health check
[2024-07-16 10:41:27] [index:background] Health check
[2024-07-16 10:41:27] [indexer:background] Health check
[2024-07-16 10:41:27] [indexer:background] Health check
[2024-07-16 10:43:51] [index:background] Health check
[2024-07-16 10:44:33] [indexer:background] Health check
[2024-07-16 10:49:05] [index:background] Health check
[2024-07-16 10:49:45] [indexer:background] Health check
[2024-07-16 10:53:51] [index:background] Health check
[2024-07-16 10:55:50] [indexer:background] Health check
[2024-07-16 10:58:52] [index:background] Health check
[2024-07-16 10:59:40] [indexer:background] Health check
[2024-07-16 11:04:18] [index:background] Health check
[2024-07-16 11:04:18] [indexer:background] Health check
[2024-07-16 11:04:18] [indexer:background] Health check
[2024-07-16 11:08:54] [index:background] Health check
[2024-07-16 11:09:38] [indexer:background] Health check
[2024-07-16 11:13:44] [index:background] Health check
[2024-07-16 11:15:05] [indexer:background] Health check
[2024-07-16 11:18:42] [index:background] Health check
[2024-07-16 11:19:18] [indexer:background] Health check
[2024-07-16 11:23:43] [index:background] Health check
[2024-07-16 11:24:21] [indexer:background] Health check
[2024-07-16 11:28:43] [index:background] Health check
[2024-07-16 11:29:16] [indexer:background] Health check
[2024-07-16 11:33:42] [index:background] Health check
[2024-07-16 11:34:18] [indexer:background] Health check
[2024-07-16 11:38:45] [index:background] Health check
[2024-07-16 11:39:17] [indexer:background] Health check
[2024-07-16 11:43:45] [index:background] Health check
[2024-07-16 11:43:45] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2024-07-16 11:43:47] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2024-07-16 11:44:17] [indexer:background] Health check
[2024-07-16 11:48:44] [index:background] Health check
[2024-07-16 11:49:17] [indexer:background] Health check
[2024-07-16 11:53:42] [index:background] Health check
[2024-07-16 11:54:19] [indexer:background] Health check
[2024-07-16 11:58:45] [index:background] Health check
[2024-07-16 11:59:18] [indexer:background] Health check
[2024-07-16 12:03:43] [index:background] Health check
[2024-07-16 12:04:16] [indexer:background] Health check
[2024-07-16 12:08:44] [index:background] Health check
[2024-07-16 12:09:20] [indexer:background] Health check
[2024-07-16 12:13:44] [index:background] Health check
[2024-07-16 12:14:16] [indexer:background] Health check
[2024-07-16 12:18:42] [index:background] Health check
[2024-07-16 12:19:17] [indexer:background] Health check
[2024-07-16 12:23:42] [index:background] Health check
[2024-07-16 12:24:17] [indexer:background] Health check
[2024-07-16 12:28:43] [index:background] Health check
[2024-07-16 12:29:17] [indexer:background] Health check
[2024-07-16 12:33:44] [index:background] Health check
[2024-07-16 12:34:17] [indexer:background] Health check
[2024-07-16 12:38:44] [index:background] Health check
[2024-07-16 12:39:18] [indexer:background] Health check
[2024-07-16 12:43:54] [index:background] Health check
[2024-07-16 12:44:22] [indexer:background] Health check
[2024-07-16 12:48:44] [index:background] Health check
[2024-07-16 12:49:44] [indexer:background] Health check
[2024-07-16 12:53:46] [index:background] Health check
[2024-07-16 12:54:18] [indexer:background] Health check
[2024-07-16 12:58:45] [index:background] Health check
[2024-07-16 12:59:16] [indexer:background] Health check
[2024-07-16 13:03:42] [index:background] Health check
[2024-07-16 13:04:17] [indexer:background] Health check
[2024-07-16 13:08:43] [index:background] Health check
[2024-07-16 13:09:17] [indexer:background] Health check
[2024-07-16 13:13:45] [index:background] Health check
[2024-07-16 13:14:16] [indexer:background] Health check
[2024-07-16 13:18:45] [index:background] Health check
[2024-07-16 13:19:17] [indexer:background] Health check
[2024-07-16 13:23:43] [index:background] Health check
[2024-07-16 13:24:16] [indexer:background] Health check
[2024-07-16 13:29:43] [index:background] Health check
[2024-07-16 13:29:43] [indexer:background] Health check
[2024-07-16 13:29:43] [indexer:background] Health check
[2024-07-16 13:33:44] [index:background] Health check
[2024-07-16 13:34:16] [indexer:background] Health check
[2024-07-16 13:38:44] [index:background] Health check
[2024-07-16 13:39:17] [indexer:background] Health check
[2024-07-16 13:43:43] [index:background] Health check
[2024-07-16 13:44:18] [indexer:background] Health check
[2024-07-16 13:48:43] [index:background] Health check
[2024-07-16 13:49:17] [indexer:background] Health check
[2024-07-16 13:53:46] [index:background] Health check
[2024-07-16 13:54:18] [indexer:background] Health check
[2024-07-16 13:58:42] [index:background] Health check
[2024-07-16 13:59:17] [indexer:background] Health check
[2024-07-16 14:03:44] [index:background] Health check
[2024-07-16 14:04:17] [indexer:background] Health check
[2024-07-16 14:08:43] [index:background] Health check
[2024-07-16 14:09:18] [indexer:background] Health check
[2024-07-16 14:13:42] [index:background] Health check
[2024-07-16 14:14:16] [indexer:background] Health check
[2024-07-16 14:18:43] [index:background] Health check
[2024-07-16 14:19:16] [indexer:background] Health check
[2024-07-16 14:23:44] [index:background] Health check
[2024-07-16 14:24:18] [indexer:background] Health check
[2024-07-16 14:28:43] [index:background] Health check
[2024-07-16 14:29:18] [indexer:background] Health check
[2024-07-16 14:33:43] [index:background] Health check
[2024-07-16 14:34:17] [indexer:background] Health check
[2024-07-16 14:38:43] [index:background] Health check
[2024-07-16 14:39:18] [indexer:background] Health check
[2024-07-16 14:43:43] [index:background] Health check
[2024-07-16 14:44:18] [indexer:background] Health check
[2024-07-16 14:48:45] [index:background] Health check
[2024-07-16 14:49:18] [indexer:background] Health check
[2024-07-16 14:53:43] [index:background] Health check
[2024-07-16 14:54:19] [indexer:background] Health check
[2024-07-16 14:58:43] [index:background] Health check
[2024-07-16 14:59:17] [indexer:background] Health check
[2024-07-16 15:03:43] [index:background] Health check
[2024-07-16 15:04:18] [indexer:background] Health check
[2024-07-16 15:08:43] [index:background] Health check
[2024-07-16 15:09:18] [indexer:background] Health check
[2024-07-16 15:13:43] [index:background] Health check
[2024-07-16 15:14:18] [indexer:background] Health check
[2024-07-16 15:18:44] [index:background] Health check
[2024-07-16 15:19:16] [indexer:background] Health check
[2024-07-16 15:23:44] [index:background] Health check
[2024-07-16 15:24:18] [indexer:background] Health check
[2024-07-16 15:28:43] [index:background] Health check
[2024-07-16 15:29:17] [indexer:background] Health check
[2024-07-16 15:33:42] [index:background] Health check
[2024-07-16 15:34:18] [indexer:background] Health check
[2024-07-16 15:39:19] [index:background] Health check
[2024-07-16 15:39:19] [indexer:background] Health check
[2024-07-16 15:39:19] [indexer:background] Health check
[2024-07-16 15:43:42] [index:background] Health check
[2024-07-16 15:44:16] [indexer:background] Health check
[2024-07-16 15:48:42] [index:background] Health check
[2024-07-16 15:49:16] [indexer:background] Health check
[2024-07-16 15:53:42] [index:background] Health check
[2024-07-16 15:54:17] [indexer:background] Health check
[2024-07-16 15:58:44] [index:background] Health check
[2024-07-16 15:59:17] [indexer:background] Health check
[2024-07-16 16:03:44] [index:background] Health check
[2024-07-16 16:04:17] [indexer:background] Health check
[2024-07-16 16:08:42] [index:background] Health check
[2024-07-16 16:09:17] [indexer:background] Health check
[2024-07-16 16:13:43] [index:background] Health check
[2024-07-16 16:14:17] [indexer:background] Health check
[2024-07-16 16:18:43] [index:background] Health check
[2024-07-16 16:19:18] [indexer:background] Health check
[2024-07-16 16:23:42] [index:background] Health check
[2024-07-16 16:24:16] [indexer:background] Health check
[2024-07-16 16:28:44] [index:background] Health check
[2024-07-16 16:29:16] [indexer:background] Health check
[2024-07-16 16:33:43] [index:background] Health check
[2024-07-16 16:34:18] [indexer:background] Health check
[2024-07-16 16:38:42] [index:background] Health check
[2024-07-16 16:39:17] [indexer:background] Health check
[2024-07-16 16:43:42] [index:background] Health check
[2024-07-16 16:44:17] [indexer:background] Health check
[2024-07-16 16:48:42] [index:background] Health check
[2024-07-16 16:49:18] [indexer:background] Health check
[2024-07-16 16:53:43] [index:background] Health check
[2024-07-16 16:54:18] [indexer:background] Health check
[2024-07-16 16:58:42] [index:background] Health check
[2024-07-16 16:59:17] [indexer:background] Health check
[2024-07-16 17:03:43] [index:background] Health check
[2024-07-16 17:04:18] [indexer:background] Health check
[2024-07-16 17:08:43] [index:background] Health check
[2024-07-16 17:09:18] [indexer:background] Health check
[2024-07-16 17:13:43] [index:background] Health check
[2024-07-16 17:14:17] [indexer:background] Health check
[2024-07-16 17:18:43] [index:background] Health check
[2024-07-16 17:19:17] [indexer:background] Health check
[2024-07-16 17:23:45] [index:background] Health check
[2024-07-16 17:24:17] [indexer:background] Health check
[2024-07-16 17:28:44] [index:background] Health check
[2024-07-16 17:29:18] [indexer:background] Health check
[2024-07-16 17:33:44] [index:background] Health check
[2024-07-16 17:34:16] [indexer:background] Health check
[2024-07-16 17:39:20] [index:background] Health check
[2024-07-16 17:39:20] [indexer:background] Health check
[2024-07-16 17:39:20] [indexer:background] Health check
[2024-07-16 17:43:42] [index:background] Health check
[2024-07-16 17:44:17] [indexer:background] Health check
[2024-07-16 17:48:43] [index:background] Health check
[2024-07-16 17:49:18] [indexer:background] Health check
[2024-07-16 17:53:43] [index:background] Health check
[2024-07-16 17:54:17] [indexer:background] Health check
[2024-07-16 17:59:28] [index:background] Health check
[2024-07-16 17:59:29] [indexer:background] Health check
[2024-07-16 17:59:29] [indexer:background] Health check
[2024-07-16 18:03:44] [index:background] Health check
[2024-07-16 18:04:18] [indexer:background] Health check
[2024-07-16 18:08:42] [index:background] Health check
[2024-07-16 18:09:16] [indexer:background] Health check
[2024-07-16 18:13:44] [index:background] Health check
[2024-07-16 18:14:17] [indexer:background] Health check
[2024-07-16 18:18:44] [index:background] Health check
[2024-07-16 18:19:16] [indexer:background] Health check
[2024-07-16 18:23:44] [index:background] Health check
[2024-07-16 18:24:18] [indexer:background] Health check
[2024-07-16 18:28:42] [index:background] Health check
[2024-07-16 18:29:18] [indexer:background] Health check
[2024-07-16 18:33:44] [index:background] Health check
[2024-07-16 18:34:17] [indexer:background] Health check
[2024-07-16 18:38:43] [index:background] Health check
[2024-07-16 18:39:18] [indexer:background] Health check
[2024-07-16 18:43:42] [index:background] Health check
[2024-07-16 18:44:16] [indexer:background] Health check
[2024-07-16 18:48:43] [index:background] Health check
[2024-07-16 18:49:17] [indexer:background] Health check
[2024-07-16 18:53:43] [index:background] Health check
[2024-07-16 18:54:18] [indexer:background] Health check
[2024-07-16 18:58:43] [index:background] Health check
[2024-07-16 18:59:16] [indexer:background] Health check
[2024-07-16 19:03:43] [index:background] Health check
[2024-07-16 19:04:16] [indexer:background] Health check
[2024-07-16 19:08:44] [index:background] Health check
[2024-07-16 19:09:16] [indexer:background] Health check
[2024-07-16 19:13:43] [index:background] Health check
[2024-07-16 19:14:18] [indexer:background] Health check
[2024-07-16 19:18:42] [index:background] Health check
[2024-07-16 19:19:17] [indexer:background] Health check
[2024-07-16 19:23:43] [index:background] Health check
[2024-07-16 19:24:17] [indexer:background] Health check
[2024-07-16 19:28:43] [index:background] Health check
[2024-07-16 19:29:17] [indexer:background] Health check
[2024-07-16 19:33:44] [index:background] Health check
[2024-07-16 19:34:18] [indexer:background] Health check
[2024-07-16 19:38:43] [index:background] Health check
[2024-07-16 19:39:18] [indexer:background] Health check
[2024-07-16 19:43:43] [index:background] Health check
[2024-07-16 19:44:17] [indexer:background] Health check
[2024-07-16 19:48:45] [index:background] Health check
[2024-07-16 19:49:17] [indexer:background] Health check
[2024-07-16 19:53:44] [index:background] Health check
[2024-07-16 19:54:18] [indexer:background] Health check
[2024-07-16 19:58:44] [index:background] Health check
[2024-07-16 20:00:19] [indexer:background] Health check
[2024-07-16 20:00:19] [indexer:background] Health check
[2024-07-16 20:03:43] [index:background] Health check
[2024-07-16 20:04:17] [indexer:background] Health check
[2024-07-16 20:04:55] [query] Query for: {search_term_string}
[2024-07-16 20:04:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-16 20:04:55] [query] Engine: default
[2024-07-16 20:04:56] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-07-16 20:04:56] [query] Mods: 6
[2024-07-16 20:04:56] [query] Using OR logic
[2024-07-16 20:04:57] [query] Found results using: or logic
[2024-07-16 20:04:57] [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
[2024-07-16 20:04:57] [query] Results: 1365 Pages of results: 137
[2024-07-16 20:04:57] [query] Execution time: 2.80449
[2024-07-16 20:08:44] [index:background] Health check
[2024-07-16 20:09:17] [indexer:background] Health check
[2024-07-16 20:13:43] [index:background] Health check
[2024-07-16 20:14:18] [indexer:background] Health check
[2024-07-16 20:18:43] [index:background] Health check
[2024-07-16 20:19:18] [indexer:background] Health check
[2024-07-16 20:23:43] [index:background] Health check
[2024-07-16 20:24:17] [indexer:background] Health check
[2024-07-16 20:28:43] [index:background] Health check
[2024-07-16 20:29:17] [indexer:background] Health check
[2024-07-16 20:33:43] [index:background] Health check
[2024-07-16 20:34:16] [indexer:background] Health check
[2024-07-16 20:38:44] [index:background] Health check
[2024-07-16 20:39:16] [indexer:background] Health check
[2024-07-16 20:43:43] [index:background] Health check
[2024-07-16 20:44:16] [indexer:background] Health check
[2024-07-16 20:48:43] [index:background] Health check
[2024-07-16 20:49:17] [indexer:background] Health check
[2024-07-16 20:53:43] [index:background] Health check
[2024-07-16 20:54:17] [indexer:background] Health check
[2024-07-16 20:58:44] [index:background] Health check
[2024-07-16 20:59:17] [indexer:background] Health check
[2024-07-16 21:03:42] [index:background] Health check
[2024-07-16 21:04:17] [indexer:background] Health check
[2024-07-16 21:08:43] [index:background] Health check
[2024-07-16 21:09:17] [indexer:background] Health check
[2024-07-16 21:13:42] [index:background] Health check
[2024-07-16 21:14:17] [indexer:background] Health check
[2024-07-16 21:18:44] [index:background] Health check
[2024-07-16 21:19:18] [indexer:background] Health check
[2024-07-16 21:23:43] [index:background] Health check
[2024-07-16 21:24:17] [indexer:background] Health check
[2024-07-16 21:28:43] [index:background] Health check
[2024-07-16 21:29:18] [indexer:background] Health check
[2024-07-16 21:33:43] [index:background] Health check
[2024-07-16 21:34:17] [indexer:background] Health check
[2024-07-16 21:38:43] [index:background] Health check
[2024-07-16 21:39:17] [indexer:background] Health check
[2024-07-16 21:43:43] [index:background] Health check
[2024-07-16 21:44:18] [indexer:background] Health check
[2024-07-16 21:48:43] [index:background] Health check
[2024-07-16 21:49:16] [indexer:background] Health check
[2024-07-16 21:54:37] [index:background] Health check
[2024-07-16 21:54:37] [indexer:background] Health check
[2024-07-16 21:54:37] [indexer:background] Health check
[2024-07-16 22:03:08] [index:background] Health check
[2024-07-16 22:03:08] [indexer:background] Health check
[2024-07-16 22:03:08] [indexer:background] Health check
[2024-07-16 22:03:43] [index:background] Health check
[2024-07-16 22:04:18] [indexer:background] Health check
[2024-07-16 22:08:44] [index:background] Health check
[2024-07-16 22:09:16] [indexer:background] Health check
[2024-07-16 22:14:32] [index:background] Health check
[2024-07-16 22:14:32] [indexer:background] Health check
[2024-07-16 22:14:32] [indexer:background] Health check
[2024-07-16 22:18:47] [index:background] Health check
[2024-07-16 22:19:40] [indexer:background] Health check
[2024-07-16 22:23:49] [index:background] Health check
[2024-07-16 22:24:24] [indexer:background] Health check
[2024-07-16 22:29:14] [index:background] Health check
[2024-07-16 22:31:12] [indexer:background] Health check
[2024-07-16 22:36:08] [index:background] Health check
[2024-07-16 22:36:09] [indexer:background] Health check
[2024-07-16 22:36:09] [indexer:background] Health check
[2024-07-16 22:41:09] [index:background] Health check
[2024-07-16 22:41:09] [indexer:background] Health check
[2024-07-16 22:41:09] [indexer:background] Health check
[2024-07-16 22:43:49] [index:background] Health check
[2024-07-16 22:45:09] [indexer:background] Health check
[2024-07-16 22:48:51] [index:background] Health check
[2024-07-16 22:49:16] [indexer:background] Health check
[2024-07-16 22:53:46] [index:background] Health check
[2024-07-16 22:54:51] [indexer:background] Health check
[2024-07-16 22:59:31] [index:background] Health check
[2024-07-16 22:59:31] [indexer:background] Health check
[2024-07-16 22:59:31] [indexer:background] Health check
[2024-07-16 23:04:24] [index:background] Health check
[2024-07-16 23:04:25] [indexer:background] Health check
[2024-07-16 23:04:25] [indexer:background] Health check
[2024-07-16 23:06:39] [query] Query for: 2023
[2024-07-16 23:06:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-16 23:06:39] [query] Engine: default
[2024-07-16 23:06:41] [query] Tokens: 2023
[2024-07-16 23:06:41] [query] Mods: 6
[2024-07-16 23:06:41] [query] Found results using: or logic
[2024-07-16 23:06: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
[2024-07-16 23:06:41] [query] Results: 280 Pages of results: 28
[2024-07-16 23:06:41] [query] Execution time: 1.53963
[2024-07-16 23:09:47] [index:background] Health check
[2024-07-16 23:09:47] [indexer:background] Health check
[2024-07-16 23:09:47] [indexer:background] Health check
[2024-07-16 23:15:38] [index:background] Health check
[2024-07-16 23:15:38] [indexer:background] Health check
[2024-07-16 23:15:38] [indexer:background] Health check
[2024-07-16 23:18:49] [index:background] Health check
[2024-07-16 23:19:49] [indexer:background] Health check
[2024-07-16 23:24:05] [index:background] Health check
[2024-07-16 23:25:05] [indexer:background] Health check
[2024-07-16 23:28:59] [index:background] Health check
[2024-07-16 23:30:29] [indexer:background] Health check
[2024-07-16 23:34:01] [index:background] Health check
[2024-07-16 23:35:18] [indexer:background] Health check
[2024-07-16 23:35:18] [indexer:background] CPU load threshold (3) breached: 4.72 [waiting 2]
[2024-07-16 23:38:59] [index:background] Health check
[2024-07-16 23:44:01] [indexer:background] Health check
[2024-07-16 23:44:01] [index:background] Health check
[2024-07-16 23:47:08] [indexer:background] Health check
[2024-07-16 23:48:48] [index:background] Health check
[2024-07-16 23:49:41] [indexer:background] Health check
[2024-07-16 23:56:24] [index:background] Health check
[2024-07-16 23:56:24] [indexer:background] Health check
[2024-07-16 23:56:24] [indexer:background] Health check
[2024-07-16 23:59:50] [index:background] Health check
[2024-07-16 23:59:50] [indexer:background] Health check
[2024-07-16 23:59:50] [indexer:background] Health check