[2024-05-31 00:03:43] [index:background] Health check
[2024-05-31 00:04:18] [indexer:background] Health check
[2024-05-31 00:09:45] [index:background] Health check
[2024-05-31 00:09:45] [indexer:background] Health check
[2024-05-31 00:09:45] [indexer:background] Health check
[2024-05-31 00:14:03] [index:background] Health check
[2024-05-31 00:14:23] [indexer:background] Health check
[2024-05-31 00:24:34] [index:background] Health check
[2024-05-31 00:24:34] [indexer:background] Health check
[2024-05-31 00:24:34] [indexer:background] Health check
[2024-05-31 00:29:03] [index:background] Health check
[2024-05-31 00:30:21] [indexer:background] Health check
[2024-05-31 00:34:41] [index:background] Health check
[2024-05-31 00:34:41] [indexer:background] Health check
[2024-05-31 00:34:41] [indexer:background] Health check
[2024-05-31 00:40:54] [index:background] Health check
[2024-05-31 00:40:54] [indexer:background] Health check
[2024-05-31 00:40:54] [indexer:background] Health check
[2024-05-31 00:44:54] [index:background] Health check
[2024-05-31 00:44:54] [indexer:background] Health check
[2024-05-31 00:44:54] [indexer:background] Health check
[2024-05-31 00:48:42] [index:background] Health check
[2024-05-31 00:49:16] [indexer:background] Health check
[2024-05-31 00:54:05] [index:background] Health check
[2024-05-31 00:54:21] [indexer:background] Health check
[2024-05-31 00:58:47] [index:background] Health check
[2024-05-31 01:05:02] [indexer:background] Health check
[2024-05-31 01:05:08] [index:background] Health check
[2024-05-31 01:10:15] [index:background] Health check
[2024-05-31 01:10:15] [indexer:background] Health check
[2024-05-31 01:10:15] [indexer:background] Health check
[2024-05-31 01:14:19] [index:background] Health check
[2024-05-31 01:14:19] [indexer:background] Health check
[2024-05-31 01:14:19] [indexer:background] Health check
[2024-05-31 01:19:33] [index:background] Health check
[2024-05-31 01:19:33] [indexer:background] Health check
[2024-05-31 01:19:33] [indexer:background] Health check
[2024-05-31 01:24:40] [index:background] Health check
[2024-05-31 01:24:40] [indexer:background] Health check
[2024-05-31 01:24:40] [indexer:background] Health check
[2024-05-31 01:29:46] [index:background] Health check
[2024-05-31 01:29:46] [indexer:background] Health check
[2024-05-31 01:29:46] [indexer:background] Health check
[2024-05-31 01:34:04] [index:background] Health check
[2024-05-31 01:34:23] [indexer:background] Health check
[2024-05-31 01:38:54] [index:background] Health check
[2024-05-31 01:40:12] [indexer:background] Health check
[2024-05-31 01:43:43] [index:background] Health check
[2024-05-31 01:44:30] [indexer:background] Health check
[2024-05-31 01:48:55] [index:background] Health check
[2024-05-31 01:50:38] [indexer:background] Health check
[2024-05-31 01:53:43] [index:background] Health check
[2024-05-31 01:54:50] [indexer:background] Health check
[2024-05-31 01:58:53] [index:background] Health check
[2024-05-31 01:59:21] [indexer:background] Health check
[2024-05-31 02:06:19] [index:background] Health check
[2024-05-31 02:06:19] [indexer:background] Health check
[2024-05-31 02:06:19] [indexer:background] Health check
[2024-05-31 02:09:48] [index:background] Health check
[2024-05-31 02:09:48] [indexer:background] Health check
[2024-05-31 02:09:48] [indexer:background] Health check
[2024-05-31 02:13:46] [index:background] Health check
[2024-05-31 02:18:03] [indexer:background] Health check
[2024-05-31 02:19:32] [index:background] Health check
[2024-05-31 02:19:32] [indexer:background] Health check
[2024-05-31 02:19:32] [indexer:background] Health check
[2024-05-31 02:23:43] [index:background] Health check
[2024-05-31 02:24:17] [indexer:background] Health check
[2024-05-31 02:28:45] [index:background] Health check
[2024-05-31 02:29:45] [indexer:background] Health check
[2024-05-31 02:33:44] [index:background] Health check
[2024-05-31 02:37:48] [indexer:background] Health check
[2024-05-31 02:38:47] [index:background] Health check
[2024-05-31 02:40:58] [indexer:background] Health check
[2024-05-31 02:44:00] [index:background] Health check
[2024-05-31 02:44:49] [indexer:background] Health check
[2024-05-31 02:50:21] [index:background] Health check
[2024-05-31 02:50:21] [indexer:background] Health check
[2024-05-31 02:50:21] [indexer:background] Health check
[2024-05-31 02:54:11] [index:background] Health check
[2024-05-31 02:56:09] [indexer:background] Health check
[2024-05-31 03:00:12] [index:background] Health check
[2024-05-31 03:00:12] [indexer:background] Health check
[2024-05-31 03:00:12] [indexer:background] Health check
[2024-05-31 03:06:39] [index:background] Health check
[2024-05-31 03:06:39] [indexer:background] Health check
[2024-05-31 03:06:40] [indexer:background] Health check
[2024-05-31 03:10:29] [index:background] Health check
[2024-05-31 03:10:29] [indexer:background] Health check
[2024-05-31 03:10:29] [indexer:background] Health check
[2024-05-31 03:14:01] [index:background] Health check
[2024-05-31 03:15:13] [indexer:background] Health check
[2024-05-31 03:18:57] [index:background] Health check
[2024-05-31 03:20:23] [indexer:background] Health check
[2024-05-31 03:23:45] [index:background] Health check
[2024-05-31 03:25:21] [indexer:background] Health check
[2024-05-31 03:29:16] [index:background] Health check
[2024-05-31 03:29:16] [indexer:background] Health check
[2024-05-31 03:29:16] [indexer:background] Health check
[2024-05-31 03:33:50] [index:background] Health check
[2024-05-31 03:35:54] [indexer:background] Health check
[2024-05-31 03:38:52] [index:background] Health check
[2024-05-31 03:39:20] [indexer:background] Health check
[2024-05-31 03:45:30] [index:background] Health check
[2024-05-31 03:45:30] [indexer:background] Health check
[2024-05-31 03:45:30] [indexer:background] Health check
[2024-05-31 03:48:47] [index:background] Health check
[2024-05-31 03:50:06] [indexer:background] Health check
[2024-05-31 03:54:07] [index:background] Health check
[2024-05-31 03:55:27] [indexer:background] Health check
[2024-05-31 04:02:26] [index:background] Health check
[2024-05-31 04:02:27] [indexer:background] Health check
[2024-05-31 04:02:27] [indexer:background] Health check
[2024-05-31 04:03:52] [index:background] Health check
[2024-05-31 04:06:43] [indexer:background] Health check
[2024-05-31 04:09:06] [index:background] Health check
[2024-05-31 04:10:07] [indexer:background] Health check
[2024-05-31 04:13:45] [index:background] Health check
[2024-05-31 04:19:17] [indexer:background] Health check
[2024-05-31 04:19:19] [index:background] Health check
[2024-05-31 04:24:21] [index:background] Health check
[2024-05-31 04:24:21] [indexer:background] Health check
[2024-05-31 04:24:21] [indexer:background] Health check
[2024-05-31 04:29:53] [index:background] Health check
[2024-05-31 04:29:53] [indexer:background] Health check
[2024-05-31 04:29:54] [indexer:background] Health check
[2024-05-31 04:34:02] [index:background] Health check
[2024-05-31 04:34:55] [indexer:background] Health check
[2024-05-31 04:38:53] [index:background] Health check
[2024-05-31 04:40:15] [indexer:background] Health check
[2024-05-31 04:45:06] [index:background] Health check
[2024-05-31 04:45:06] [indexer:background] Health check
[2024-05-31 04:45:06] [indexer:background] Health check
[2024-05-31 04:49:30] [index:background] Health check
[2024-05-31 04:49:30] [indexer:background] Health check
[2024-05-31 04:49:30] [indexer:background] Health check
[2024-05-31 04:53:52] [index:background] Health check
[2024-05-31 04:56:38] [indexer:background] Health check
[2024-05-31 04:58:43] [index:background] Health check
[2024-05-31 04:59:17] [indexer:background] Health check
[2024-05-31 05:03:44] [index:background] Health check
[2024-05-31 05:04:17] [indexer:background] Health check
[2024-05-31 05:09:32] [index:background] Health check
[2024-05-31 05:09:33] [indexer:background] Health check
[2024-05-31 05:09:33] [indexer:background] Health check
[2024-05-31 05:13:54] [index:background] Health check
[2024-05-31 05:14:34] [indexer:background] Health check
[2024-05-31 05:19:02] [index:background] Health check
[2024-05-31 05:21:55] [indexer:background] Health check
[2024-05-31 05:23:56] [index:background] Health check
[2024-05-31 05:24:31] [indexer:background] Health check
[2024-05-31 05:28:58] [index:background] Health check
[2024-05-31 05:29:55] [indexer:background] Health check
[2024-05-31 05:34:44] [index:background] Health check
[2024-05-31 05:34:44] [indexer:background] Health check
[2024-05-31 05:34:45] [indexer:background] Health check
[2024-05-31 05:39:17] [index:background] Health check
[2024-05-31 05:39:17] [indexer:background] Health check
[2024-05-31 05:39:17] [indexer:background] Health check
[2024-05-31 05:43:47] [index:background] Health check
[2024-05-31 05:45:22] [indexer:background] Health check
[2024-05-31 05:48:47] [index:background] Health check
[2024-05-31 05:49:18] [indexer:background] Health check
[2024-05-31 05:54:44] [index:background] Health check
[2024-05-31 05:54:44] [indexer:background] Health check
[2024-05-31 05:54:44] [indexer:background] Health check
[2024-05-31 05:59:08] [index:background] Health check
[2024-05-31 05:59:33] [indexer:background] Health check
[2024-05-31 06:03:48] [index:background] Health check
[2024-05-31 06:05:44] [indexer:background] Health check
[2024-05-31 06:10:28] [index:background] Health check
[2024-05-31 06:10:28] [indexer:background] Health check
[2024-05-31 06:10:28] [indexer:background] Health check
[2024-05-31 06:16:09] [index:background] Health check
[2024-05-31 06:16:09] [indexer:background] Health check
[2024-05-31 06:16:09] [indexer:background] Health check
[2024-05-31 06:18:43] [index:background] Health check
[2024-05-31 06:19:53] [indexer:background] Health check
[2024-05-31 06:23:58] [index:background] Health check
[2024-05-31 06:25:03] [indexer:background] Health check
[2024-05-31 06:30:47] [index:background] Health check
[2024-05-31 06:30:47] [indexer:background] Health check
[2024-05-31 06:30:47] [indexer:background] Health check
[2024-05-31 06:34:17] [index:background] Health check
[2024-05-31 06:34:17] [indexer:background] Health check
[2024-05-31 06:34:17] [indexer:background] Health check
[2024-05-31 06:40:17] [index:background] Health check
[2024-05-31 06:40:17] [indexer:background] Health check
[2024-05-31 06:40:17] [indexer:background] Health check
[2024-05-31 06:44:10] [index:background] Health check
[2024-05-31 06:44:30] [indexer:background] Health check
[2024-05-31 06:48:51] [index:background] Health check
[2024-05-31 06:50:30] [indexer:background] Health check
[2024-05-31 06:54:26] [index:background] Health check
[2024-05-31 06:54:26] [indexer:background] Health check
[2024-05-31 06:54:26] [indexer:background] Health check
[2024-05-31 06:59:23] [index:background] Health check
[2024-05-31 06:59:23] [indexer:background] Health check
[2024-05-31 06:59:23] [indexer:background] Health check
[2024-05-31 07:04:07] [index:background] Health check
[2024-05-31 07:04:23] [indexer:background] Health check
[2024-05-31 07:08:50] [index:background] Health check
[2024-05-31 07:09:19] [indexer:background] Health check
[2024-05-31 07:13:44] [index:background] Health check
[2024-05-31 07:14:35] [indexer:background] Health check
[2024-05-31 07:18:43] [index:background] Health check
[2024-05-31 07:19:19] [indexer:background] Health check
[2024-05-31 07:23:51] [index:background] Health check
[2024-05-31 07:24:23] [indexer:background] Health check
[2024-05-31 07:28:46] [index:background] Health check
[2024-05-31 07:29:30] [indexer:background] Health check
[2024-05-31 07:33:46] [index:background] Health check
[2024-05-31 07:34:31] [indexer:background] Health check
[2024-05-31 07:38:43] [index:background] Health check
[2024-05-31 07:39:23] [indexer:background] Health check
[2024-05-31 07:43:46] [index:background] Health check
[2024-05-31 07:44:18] [indexer:background] Health check
[2024-05-31 07:48:46] [index:background] Health check
[2024-05-31 07:49:17] [indexer:background] Health check
[2024-05-31 07:53:47] [index:background] Health check
[2024-05-31 07:54:23] [indexer:background] Health check
[2024-05-31 07:58:51] [index:background] Health check
[2024-05-31 07:59:17] [indexer:background] Health check
[2024-05-31 08:03:49] [index:background] Health check
[2024-05-31 08:04:43] [indexer:background] Health check
[2024-05-31 08:08:55] [index:background] Health check
[2024-05-31 08:09:26] [indexer:background] Health check
[2024-05-31 08:13:47] [index:background] Health check
[2024-05-31 08:14:19] [indexer:background] Health check
[2024-05-31 08:18:46] [index:background] Health check
[2024-05-31 08:19:18] [indexer:background] Health check
[2024-05-31 08:23:55] [index:background] Health check
[2024-05-31 08:24:17] [indexer:background] Health check
[2024-05-31 08:28:49] [index:background] Health check
[2024-05-31 08:29:38] [indexer:background] Health check
[2024-05-31 08:34:03] [index:background] Health check
[2024-05-31 08:34:26] [indexer:background] Health check
[2024-05-31 08:39:37] [index:background] Health check
[2024-05-31 08:39:37] [indexer:background] Health check
[2024-05-31 08:39:37] [indexer:background] Health check
[2024-05-31 08:43:57] [index:background] Health check
[2024-05-31 08:45:11] [indexer:background] Health check
[2024-05-31 08:48:47] [index:background] Health check
[2024-05-31 08:49:26] [indexer:background] Health check
[2024-05-31 08:54:30] [index:background] Health check
[2024-05-31 08:54:30] [indexer:background] Health check
[2024-05-31 08:54:30] [indexer:background] Health check
[2024-05-31 08:58:54] [index:background] Health check
[2024-05-31 08:59:31] [indexer:background] Health check
[2024-05-31 09:04:14] [index:background] Health check
[2024-05-31 09:05:16] [indexer:background] Health check
[2024-05-31 09:08:44] [index:background] Health check
[2024-05-31 09:09:58] [indexer:background] Health check
[2024-05-31 09:09:58] [indexer:background] CPU load threshold (3) breached: 4.92 [waiting 2]
[2024-05-31 09:14:08] [index:background] Health check
[2024-05-31 09:14:58] [indexer:background] Health check
[2024-05-31 09:21:37] [index:background] Health check
[2024-05-31 09:21:37] [indexer:background] Health check
[2024-05-31 09:21:37] [indexer:background] Health check
[2024-05-31 09:24:17] [index:background] Health check
[2024-05-31 09:24:17] [indexer:background] Health check
[2024-05-31 09:24:17] [indexer:background] Health check
[2024-05-31 09:29:42] [index:background] Health check
[2024-05-31 09:29:42] [indexer:background] Health check
[2024-05-31 09:29:42] [indexer:background] Health check
[2024-05-31 09:35:28] [index:background] Health check
[2024-05-31 09:35:28] [indexer:background] Health check
[2024-05-31 09:35:28] [indexer:background] Health check
[2024-05-31 09:39:36] [index:background] Health check
[2024-05-31 09:39:37] [indexer:background] Health check
[2024-05-31 09:39:37] [indexer:background] Health check
[2024-05-31 09:44:00] [index:background] Health check
[2024-05-31 09:45:01] [indexer:background] Health check
[2024-05-31 09:48:52] [index:background] Health check
[2024-05-31 09:49:18] [indexer:background] Health check
[2024-05-31 09:54:28] [index:background] Health check
[2024-05-31 09:54:28] [indexer:background] Health check
[2024-05-31 09:54:28] [indexer:background] Health check
[2024-05-31 09:58:44] [index:background] Health check
[2024-05-31 09:59:46] [indexer:background] Health check
[2024-05-31 10:04:19] [index:background] Health check
[2024-05-31 10:04:19] [indexer:background] Health check
[2024-05-31 10:04:19] [indexer:background] Health check
[2024-05-31 10:08:45] [index:background] Health check
[2024-05-31 10:09:23] [indexer:background] Health check
[2024-05-31 10:09:37] [query] Query for: 2024
[2024-05-31 10:09:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-05-31 10:09:37] [query] Engine: default
[2024-05-31 10:09:37] [query] Tokens: 2024
[2024-05-31 10:09:37] [query] Mods: 6
[2024-05-31 10:09:37] [query] Found results using: or logic
[2024-05-31 10:09:37] [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
[2024-05-31 10:09:37] [query] Results: 157 Pages of results: 16
[2024-05-31 10:09:37] [query] Execution time: 0.34595
[2024-05-31 10:09:37] [query] Query for: 2024
[2024-05-31 10:09:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-05-31 10:09:37] [query] Engine: default
[2024-05-31 10:09:37] [query] Tokens: 2024
[2024-05-31 10:09:37] [query] Mods: 6
[2024-05-31 10:09:37] [query] Found results using: or logic
[2024-05-31 10:09:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-05-31 10:09:37] [query] Results: 157 Pages of results: 2
[2024-05-31 10:09:37] [query] Execution time: 0.14414
[2024-05-31 10:13:45] [index:background] Health check
[2024-05-31 10:14:24] [indexer:background] Health check
[2024-05-31 10:18:54] [index:background] Health check
[2024-05-31 10:20:01] [indexer:background] Health check
[2024-05-31 10:24:14] [index:background] Health check
[2024-05-31 10:24:37] [indexer:background] Health check
[2024-05-31 10:29:22] [index:background] Health check
[2024-05-31 10:29:22] [indexer:background] Health check
[2024-05-31 10:29:22] [indexer:background] Health check
[2024-05-31 10:34:06] [index:background] Health check
[2024-05-31 10:34:37] [indexer:background] Health check
[2024-05-31 10:39:57] [index:background] Health check
[2024-05-31 10:39:58] [indexer:background] Health check
[2024-05-31 10:39:58] [indexer:background] Health check
[2024-05-31 10:44:01] [index:background] Health check
[2024-05-31 10:44:29] [indexer:background] Health check
[2024-05-31 10:50:03] [index:background] Health check
[2024-05-31 10:50:03] [indexer:background] Health check
[2024-05-31 10:50:03] [indexer:background] Health check
[2024-05-31 10:54:00] [index:background] Health check
[2024-05-31 10:54:27] [indexer:background] Health check
[2024-05-31 10:58:52] [index:background] Health check
[2024-05-31 10:59:31] [indexer:background] Health check
[2024-05-31 11:06:46] [index:background] Health check
[2024-05-31 11:06:46] [indexer:background] Health check
[2024-05-31 11:06:46] [indexer:background] Health check
[2024-05-31 11:10:09] [index:background] Health check
[2024-05-31 11:10:09] [indexer:background] Health check
[2024-05-31 11:10:09] [indexer:background] Health check
[2024-05-31 11:13:48] [index:background] Health check
[2024-05-31 11:14:42] [indexer:background] Health check
[2024-05-31 11:19:01] [index:background] Health check
[2024-05-31 11:21:39] [indexer:background] Health check
[2024-05-31 11:21:39] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2024-05-31 11:23:54] [index:background] Health check
[2024-05-31 11:24:44] [indexer:background] Health check
[2024-05-31 11:28:51] [index:background] Health check
[2024-05-31 11:29:21] [indexer:background] Health check
[2024-05-31 11:34:23] [index:background] Health check
[2024-05-31 11:34:23] [indexer:background] Health check
[2024-05-31 11:34:23] [indexer:background] Health check
[2024-05-31 11:39:48] [index:background] Health check
[2024-05-31 11:39:48] [indexer:background] Health check
[2024-05-31 11:39:48] [indexer:background] Health check
[2024-05-31 11:44:03] [index:background] Health check
[2024-05-31 11:44:34] [indexer:background] Health check
[2024-05-31 11:48:52] [index:background] Health check
[2024-05-31 11:49:21] [indexer:background] Health check
[2024-05-31 11:56:35] [index:background] Health check
[2024-05-31 11:56:35] [indexer:background] Health check
[2024-05-31 11:56:35] [indexer:background] Health check
[2024-05-31 11:59:12] [index:background] Health check
[2024-05-31 11:59:41] [indexer:background] Health check
[2024-05-31 12:04:04] [index:background] Health check
[2024-05-31 12:04:28] [indexer:background] Health check
[2024-05-31 12:08:44] [index:background] Health check
[2024-05-31 12:09:23] [indexer:background] Health check
[2024-05-31 12:13:41] [index:background] Health check
[2024-05-31 12:15:07] [indexer:background] Health check
[2024-05-31 12:18:50] [index:background] Health check
[2024-05-31 12:20:20] [indexer:background] Health check
[2024-05-31 12:24:01] [index:background] Health check
[2024-05-31 12:26:30] [indexer:background] Health check
[2024-05-31 12:29:29] [index:background] Health check
[2024-05-31 12:29:29] [indexer:background] Health check
[2024-05-31 12:29:29] [indexer:background] Health check
[2024-05-31 12:34:07] [index:background] Health check
[2024-05-31 12:38:31] [indexer:background] Health check
[2024-05-31 12:39:01] [index:background] Health check
[2024-05-31 12:39:45] [indexer:background] Health check
[2024-05-31 12:43:45] [index:background] Health check
[2024-05-31 12:45:31] [indexer:background] Health check
[2024-05-31 12:49:04] [index:background] Health check
[2024-05-31 12:49:18] [indexer:background] Health check
[2024-05-31 12:53:42] [index:background] Health check
[2024-05-31 12:54:16] [indexer:background] Health check
[2024-05-31 12:58:44] [index:background] Health check
[2024-05-31 12:59:17] [indexer:background] Health check
[2024-05-31 13:04:56] [index:background] Health check
[2024-05-31 13:04:56] [indexer:background] Health check
[2024-05-31 13:04:56] [indexer:background] Health check
[2024-05-31 13:09:11] [index:background] Health check
[2024-05-31 13:11:30] [indexer:background] Health check
[2024-05-31 13:13:49] [index:background] Health check
[2024-05-31 13:14:57] [indexer:background] Health check
[2024-05-31 13:18:42] [index:background] Health check
[2024-05-31 13:19:18] [indexer:background] Health check
[2024-05-31 13:23:44] [index:background] Health check
[2024-05-31 13:24:16] [indexer:background] Health check
[2024-05-31 13:28:58] [index:background] Health check
[2024-05-31 13:29:18] [indexer:background] Health check
[2024-05-31 13:35:28] [index:background] Health check
[2024-05-31 13:35:28] [indexer:background] Health check
[2024-05-31 13:35:28] [indexer:background] Health check
[2024-05-31 13:39:49] [index:background] Health check
[2024-05-31 13:39:49] [indexer:background] Health check
[2024-05-31 13:39:49] [indexer:background] Health check
[2024-05-31 13:44:08] [index:background] Health check
[2024-05-31 13:44:24] [indexer:background] Health check
[2024-05-31 13:49:44] [index:background] Health check
[2024-05-31 13:49:44] [indexer:background] Health check
[2024-05-31 13:49:44] [indexer:background] Health check
[2024-05-31 13:56:20] [index:background] Health check
[2024-05-31 13:56:20] [indexer:background] Health check
[2024-05-31 13:56:20] [indexer:background] Health check
[2024-05-31 13:59:26] [index:background] Health check
[2024-05-31 13:59:26] [indexer:background] Health check
[2024-05-31 13:59:26] [indexer:background] Health check
[2024-05-31 14:05:39] [index:background] Health check
[2024-05-31 14:05:39] [indexer:background] Health check
[2024-05-31 14:05:39] [indexer:background] Health check
[2024-05-31 14:10:31] [index:background] Health check
[2024-05-31 14:10:31] [indexer:background] Health check
[2024-05-31 14:10:31] [indexer:background] Health check
[2024-05-31 14:14:47] [index:background] Health check
[2024-05-31 14:14:47] [indexer:background] Health check
[2024-05-31 14:14:47] [indexer:background] Health check
[2024-05-31 14:18:49] [index:background] Health check
[2024-05-31 14:19:34] [indexer:background] Health check
[2024-05-31 14:24:00] [index:background] Health check
[2024-05-31 14:24:25] [indexer:background] Health check
[2024-05-31 14:29:48] [index:background] Health check
[2024-05-31 14:29:49] [indexer:background] Health check
[2024-05-31 14:29:49] [indexer:background] Health check
[2024-05-31 14:34:24] [index:background] Health check
[2024-05-31 14:34:24] [indexer:background] Health check
[2024-05-31 14:34:24] [indexer:background] Health check
[2024-05-31 14:39:08] [index:background] Health check
[2024-05-31 14:39:37] [indexer:background] Health check
[2024-05-31 14:44:04] [index:background] Health check
[2024-05-31 14:44:31] [indexer:background] Health check
[2024-05-31 14:49:20] [index:background] Health check
[2024-05-31 14:49:20] [indexer:background] Health check
[2024-05-31 14:49:20] [indexer:background] Health check
[2024-05-31 14:53:42] [index:background] Health check
[2024-05-31 14:54:23] [indexer:background] Health check
[2024-05-31 14:59:21] [index:background] Health check
[2024-05-31 14:59:21] [indexer:background] Health check
[2024-05-31 14:59:21] [indexer:background] Health check
[2024-05-31 15:04:07] [index:background] Health check
[2024-05-31 15:04:44] [indexer:background] Health check
[2024-05-31 15:08:05] [query] Query for: 2025
[2024-05-31 15:08:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-05-31 15:08:05] [query] Engine: default
[2024-05-31 15:08:05] [query] Tokens: 2025
[2024-05-31 15:08:05] [query] Mods: 6
[2024-05-31 15:08:05] [query] Found results using: or logic
[2024-05-31 15:08:05] [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-05-31 15:08:05] [query] Results: 138 Pages of results: 14
[2024-05-31 15:08:05] [query] Execution time: 0.36178
[2024-05-31 15:08:05] [query] Query for: 2025
[2024-05-31 15:08:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-05-31 15:08:05] [query] Engine: default
[2024-05-31 15:08:06] [query] Tokens: 2025
[2024-05-31 15:08:06] [query] Mods: 6
[2024-05-31 15:08:06] [query] Found results using: or logic
[2024-05-31 15:08:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-05-31 15:08:06] [query] Results: 138 Pages of results: 2
[2024-05-31 15:08:06] [query] Execution time: 0.14160
[2024-05-31 15:09:26] [index:background] Health check
[2024-05-31 15:09:26] [indexer:background] Health check
[2024-05-31 15:09:26] [indexer:background] Health check
[2024-05-31 15:13:49] [index:background] Health check
[2024-05-31 15:14:29] [indexer:background] Health check
[2024-05-31 15:19:14] [index:background] Health check
[2024-05-31 15:19:36] [indexer:background] Health check
[2024-05-31 15:23:48] [index:background] Health check
[2024-05-31 15:25:20] [indexer:background] Health check
[2024-05-31 15:29:06] [index:background] Health check
[2024-05-31 15:29:18] [indexer:background] Health check
[2024-05-31 15:33:54] [index:background] Health check
[2024-05-31 15:34:35] [indexer:background] Health check
[2024-05-31 15:38:54] [index:background] Health check
[2024-05-31 15:40:01] [indexer:background] Health check
[2024-05-31 15:44:14] [index:background] Health check
[2024-05-31 15:44:37] [indexer:background] Health check
[2024-05-31 15:48:51] [index:background] Health check
[2024-05-31 15:49:45] [indexer:background] Health check
[2024-05-31 15:53:55] [index:background] Health check
[2024-05-31 15:54:23] [indexer:background] Health check
[2024-05-31 15:59:11] [index:background] Health check
[2024-05-31 15:59:29] [indexer:background] Health check
[2024-05-31 15:59:29] [indexer:background] Health check
[2024-05-31 16:04:50] [index:background] Health check
[2024-05-31 16:04:50] [indexer:background] Health check
[2024-05-31 16:04:50] [indexer:background] Health check
[2024-05-31 16:08:59] [index:background] Health check
[2024-05-31 16:09:18] [indexer:background] Health check
[2024-05-31 16:14:57] [index:background] Health check
[2024-05-31 16:14:57] [indexer:background] Health check
[2024-05-31 16:14:57] [indexer:background] Health check
[2024-05-31 16:18:45] [index:background] Health check
[2024-05-31 16:19:20] [indexer:background] Health check
[2024-05-31 16:24:51] [index:background] Health check
[2024-05-31 16:24:51] [indexer:background] Health check
[2024-05-31 16:24:51] [indexer:background] Health check
[2024-05-31 16:28:52] [index:background] Health check
[2024-05-31 16:31:22] [indexer:background] Health check
[2024-05-31 16:34:40] [index:background] Health check
[2024-05-31 16:34:40] [indexer:background] Health check
[2024-05-31 16:34:40] [indexer:background] Health check
[2024-05-31 16:39:19] [index:background] Health check
[2024-05-31 16:39:19] [indexer:background] Health check
[2024-05-31 16:39:19] [indexer:background] Health check
[2024-05-31 16:43:54] [query] Query for: 2024
[2024-05-31 16:43:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-05-31 16:43:54] [query] Engine: default
[2024-05-31 16:43:55] [query] Tokens: 2024
[2024-05-31 16:43:55] [query] Mods: 6
[2024-05-31 16:43:55] [query] Found results using: or logic
[2024-05-31 16:43:55] [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
[2024-05-31 16:43:55] [query] Results: 157 Pages of results: 16
[2024-05-31 16:43:55] [query] Execution time: 0.38658
[2024-05-31 16:43:55] [index:background] Health check
[2024-05-31 16:44:19] [indexer:background] Health check
[2024-05-31 16:48:45] [index:background] Health check
[2024-05-31 16:50:00] [indexer:background] Health check
[2024-05-31 16:54:39] [index:background] Health check
[2024-05-31 16:54:39] [indexer:background] Health check
[2024-05-31 16:54:39] [indexer:background] Health check
[2024-05-31 16:58:41] [index:background] Health check
[2024-05-31 17:00:06] [indexer:background] Health check
[2024-05-31 17:04:22] [index:background] Health check
[2024-05-31 17:04:22] [indexer:background] Health check
[2024-05-31 17:04:22] [indexer:background] Health check
[2024-05-31 17:11:20] [index:background] Health check
[2024-05-31 17:11:20] [indexer:background] Health check
[2024-05-31 17:11:20] [indexer:background] Health check
[2024-05-31 17:14:53] [index:background] Health check
[2024-05-31 17:14:53] [indexer:background] Health check
[2024-05-31 17:14:53] [indexer:background] Health check
[2024-05-31 17:19:12] [index:background] Health check
[2024-05-31 17:19:34] [indexer:background] Health check
[2024-05-31 17:25:44] [index:background] Health check
[2024-05-31 17:25:44] [indexer:background] Health check
[2024-05-31 17:25:44] [indexer:background] Health check
[2024-05-31 17:28:56] [index:background] Health check
[2024-05-31 17:32:09] [indexer:background] Health check
[2024-05-31 17:38:29] [index:background] Health check
[2024-05-31 17:38:29] [indexer:background] Health check
[2024-05-31 17:38:29] [indexer:background] Health check
[2024-05-31 17:38:59] [index:background] Health check
[2024-05-31 17:40:06] [indexer:background] Health check
[2024-05-31 17:43:46] [index:background] Health check
[2024-05-31 17:44:47] [indexer:background] Health check
[2024-05-31 17:48:49] [index:background] Health check
[2024-05-31 17:49:26] [indexer:background] Health check
[2024-05-31 17:53:46] [index:background] Health check
[2024-05-31 17:54:18] [indexer:background] Health check
[2024-05-31 17:59:42] [index:background] Health check
[2024-05-31 17:59:42] [indexer:background] Health check
[2024-05-31 17:59:42] [indexer:background] Health check
[2024-05-31 18:03:45] [index:background] Health check
[2024-05-31 18:04:47] [indexer:background] Health check
[2024-05-31 18:09:33] [index:background] Health check
[2024-05-31 18:09:33] [indexer:background] Health check
[2024-05-31 18:09:33] [indexer:background] Health check
[2024-05-31 18:17:16] [index:background] Health check
[2024-05-31 18:17:16] [indexer:background] Health check
[2024-05-31 18:17:16] [indexer:background] Health check
[2024-05-31 18:18:45] [index:background] Health check
[2024-05-31 18:20:03] [indexer:background] Health check
[2024-05-31 18:24:25] [index:background] Health check
[2024-05-31 18:24:25] [indexer:background] Health check
[2024-05-31 18:24:25] [indexer:background] Health check
[2024-05-31 18:28:43] [index:background] Health check
[2024-05-31 18:29:51] [indexer:background] Health check
[2024-05-31 18:33:58] [index:background] Health check
[2024-05-31 18:34:23] [indexer:background] Health check
[2024-05-31 18:39:16] [index:background] Health check
[2024-05-31 18:39:16] [indexer:background] Health check
[2024-05-31 18:39:17] [indexer:background] Health check
[2024-05-31 18:43:53] [index:background] Health check
[2024-05-31 18:44:18] [indexer:background] Health check
[2024-05-31 18:48:52] [index:background] Health check
[2024-05-31 18:49:17] [indexer:background] Health check
[2024-05-31 18:54:03] [index:background] Health check
[2024-05-31 18:55:21] [indexer:background] Health check
[2024-05-31 18:58:57] [index:background] Health check
[2024-05-31 18:59:16] [indexer:background] Health check
[2024-05-31 19:03:44] [index:background] Health check
[2024-05-31 19:04:32] [indexer:background] Health check
[2024-05-31 19:08:46] [index:background] Health check
[2024-05-31 19:09:17] [indexer:background] Health check
[2024-05-31 19:14:51] [index:background] Health check
[2024-05-31 19:14:51] [indexer:background] Health check
[2024-05-31 19:14:51] [indexer:background] Health check
[2024-05-31 19:19:02] [index:background] Health check
[2024-05-31 19:20:30] [indexer:background] Health check
[2024-05-31 19:25:29] [index:background] Health check
[2024-05-31 19:25:29] [indexer:background] Health check
[2024-05-31 19:25:29] [indexer:background] Health check
[2024-05-31 19:28:57] [index:background] Health check
[2024-05-31 19:29:24] [indexer:background] Health check
[2024-05-31 19:36:10] [index:background] Health check
[2024-05-31 19:36:10] [indexer:background] Health check
[2024-05-31 19:36:10] [indexer:background] Health check
[2024-05-31 19:39:19] [index:background] Health check
[2024-05-31 19:39:19] [indexer:background] Health check
[2024-05-31 19:39:19] [indexer:background] Health check
[2024-05-31 19:44:13] [index:background] Health check
[2024-05-31 19:45:36] [indexer:background] Health check
[2024-05-31 19:49:06] [index:background] Health check
[2024-05-31 19:49:45] [indexer:background] Health check
[2024-05-31 19:53:57] [index:background] Health check
[2024-05-31 19:58:39] [indexer:background] Health check
[2024-05-31 19:58:42] [index:background] Health check
[2024-05-31 19:59:36] [indexer:background] Health check
[2024-05-31 20:04:53] [index:background] Health check
[2024-05-31 20:04:53] [indexer:background] Health check
[2024-05-31 20:04:53] [indexer:background] Health check
[2024-05-31 20:08:44] [index:background] Health check
[2024-05-31 20:10:08] [indexer:background] Health check
[2024-05-31 20:14:33] [index:background] Health check
[2024-05-31 20:14:33] [indexer:background] Health check
[2024-05-31 20:14:33] [indexer:background] Health check
[2024-05-31 20:19:17] [index:background] Health check
[2024-05-31 20:19:18] [indexer:background] Health check
[2024-05-31 20:19:18] [indexer:background] Health check
[2024-05-31 20:23:44] [index:background] Health check
[2024-05-31 20:26:08] [indexer:background] Health check
[2024-05-31 20:28:55] [query] Query for: 2025
[2024-05-31 20:28:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-05-31 20:28:55] [query] Engine: default
[2024-05-31 20:28:55] [query] Tokens: 2025
[2024-05-31 20:28:55] [query] Mods: 6
[2024-05-31 20:28:55] [query] Found results using: or logic
[2024-05-31 20:28:55] [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-05-31 20:28:55] [query] Results: 138 Pages of results: 14
[2024-05-31 20:28:55] [query] Execution time: 0.35037
[2024-05-31 20:28:57] [index:background] Health check
[2024-05-31 20:31:06] [indexer:background] Health check
[2024-05-31 20:34:15] [index:background] Health check
[2024-05-31 20:34:25] [indexer:background] Health check
[2024-05-31 20:40:22] [index:background] Health check
[2024-05-31 20:40:22] [indexer:background] Health check
[2024-05-31 20:40:22] [indexer:background] Health check
[2024-05-31 20:44:37] [index:background] Health check
[2024-05-31 20:44:37] [indexer:background] Health check
[2024-05-31 20:44:37] [indexer:background] Health check
[2024-05-31 20:48:55] [index:background] Health check
[2024-05-31 20:49:43] [indexer:background] Health check
[2024-05-31 20:53:42] [index:background] Health check
[2024-05-31 20:54:26] [indexer:background] Health check
[2024-05-31 21:00:14] [index:background] Health check
[2024-05-31 21:00:14] [indexer:background] Health check
[2024-05-31 21:00:15] [indexer:background] Health check
[2024-05-31 21:04:20] [index:background] Health check
[2024-05-31 21:04:20] [indexer:background] Health check
[2024-05-31 21:04:20] [indexer:background] Health check
[2024-05-31 21:09:01] [index:background] Health check
[2024-05-31 21:09:20] [indexer:background] Health check
[2024-05-31 21:14:46] [index:background] Health check
[2024-05-31 21:14:46] [indexer:background] Health check
[2024-05-31 21:14:46] [indexer:background] Health check
[2024-05-31 21:19:08] [index:background] Health check
[2024-05-31 21:19:22] [indexer:background] Health check
[2024-05-31 21:24:00] [index:background] Health check
[2024-05-31 21:25:30] [indexer:background] Health check
[2024-05-31 21:29:51] [index:background] Health check
[2024-05-31 21:29:51] [indexer:background] Health check
[2024-05-31 21:29:51] [indexer:background] Health check
[2024-05-31 21:34:01] [index:background] Health check
[2024-05-31 21:34:43] [indexer:background] Health check
[2024-05-31 21:38:53] [index:background] Health check
[2024-05-31 21:41:13] [indexer:background] Health check
[2024-05-31 21:44:24] [index:background] Health check
[2024-05-31 21:44:24] [indexer:background] Health check
[2024-05-31 21:44:24] [indexer:background] Health check
[2024-05-31 21:49:57] [index:background] Health check
[2024-05-31 21:49:57] [indexer:background] Health check
[2024-05-31 21:49:57] [indexer:background] Health check
[2024-05-31 21:53:51] [index:background] Health check
[2024-05-31 21:55:12] [indexer:background] Health check
[2024-05-31 21:59:07] [index:background] Health check
[2024-05-31 22:00:28] [indexer:background] Health check
[2024-05-31 22:03:50] [index:background] Health check
[2024-05-31 22:04:40] [indexer:background] Health check
[2024-05-31 22:10:48] [index:background] Health check
[2024-05-31 22:10:48] [indexer:background] Health check
[2024-05-31 22:10:48] [indexer:background] Health check
[2024-05-31 22:14:11] [index:background] Health check
[2024-05-31 22:14:26] [indexer:background] Health check
[2024-05-31 22:19:27] [index:background] Health check
[2024-05-31 22:19:27] [indexer:background] Health check
[2024-05-31 22:19:27] [indexer:background] Health check
[2024-05-31 22:24:29] [index:background] Health check
[2024-05-31 22:24:30] [indexer:background] Health check
[2024-05-31 22:24:30] [indexer:background] Health check
[2024-05-31 22:29:03] [index:background] Health check
[2024-05-31 22:29:51] [indexer:background] Health check
[2024-05-31 22:33:48] [index:background] Health check
[2024-05-31 22:34:16] [indexer:background] Health check
[2024-05-31 22:39:10] [index:background] Health check
[2024-05-31 22:40:16] [indexer:background] Health check
[2024-05-31 22:43:53] [index:background] Health check
[2024-05-31 22:45:42] [indexer:background] Health check
[2024-05-31 22:50:11] [index:background] Health check
[2024-05-31 22:50:11] [indexer:background] Health check
[2024-05-31 22:50:11] [indexer:background] Health check
[2024-05-31 22:54:24] [index:background] Health check
[2024-05-31 22:54:24] [indexer:background] Health check
[2024-05-31 22:54:24] [indexer:background] Health check
[2024-05-31 22:58:47] [index:background] Health check
[2024-05-31 22:59:33] [indexer:background] Health check
[2024-05-31 23:03:49] [index:background] Health check
[2024-05-31 23:05:56] [indexer:background] Health check
[2024-05-31 23:09:27] [index:background] Health check
[2024-05-31 23:09:27] [indexer:background] Health check
[2024-05-31 23:09:27] [indexer:background] Health check
[2024-05-31 23:14:24] [index:background] Health check
[2024-05-31 23:14:24] [indexer:background] Health check
[2024-05-31 23:14:24] [indexer:background] Health check
[2024-05-31 23:19:58] [index:background] Health check
[2024-05-31 23:19:58] [indexer:background] Health check
[2024-05-31 23:19:58] [indexer:background] Health check
[2024-05-31 23:24:21] [index:background] Health check
[2024-05-31 23:24:21] [indexer:background] Health check
[2024-05-31 23:24:21] [indexer:background] Health check
[2024-05-31 23:30:32] [index:background] Health check
[2024-05-31 23:30:32] [indexer:background] Health check
[2024-05-31 23:30:32] [indexer:background] Health check
[2024-05-31 23:34:27] [index:background] Health check
[2024-05-31 23:34:27] [indexer:background] Health check
[2024-05-31 23:34:27] [indexer:background] Health check
[2024-05-31 23:40:03] [index:background] Health check
[2024-05-31 23:40:03] [indexer:background] Health check
[2024-05-31 23:40:03] [indexer:background] Health check
[2024-05-31 23:44:02] [index:background] Health check
[2024-05-31 23:44:25] [indexer:background] Health check
[2024-05-31 23:48:41] [index:background] Health check
[2024-05-31 23:51:38] [indexer:background] Health check
[2024-05-31 23:54:24] [index:background] Health check
[2024-05-31 23:54:24] [indexer:background] Health check
[2024-05-31 23:54:24] [indexer:background] Health check
[2024-05-31 23:58:46] [index:background] Health check