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