[2024-06-04 00:04:15] [index:background] Health check
[2024-06-04 00:04:15] [indexer:background] Health check
[2024-06-04 00:04:15] [indexer:background] Health check
[2024-06-04 00:09:03] [index:background] Health check
[2024-06-04 00:09:36] [indexer:background] Health check
[2024-06-04 00:16:29] [index:background] Health check
[2024-06-04 00:16:29] [indexer:background] Health check
[2024-06-04 00:16:29] [indexer:background] Health check
[2024-06-04 00:20:07] [index:background] Health check
[2024-06-04 00:20:07] [indexer:background] Health check
[2024-06-04 00:20:07] [indexer:background] Health check
[2024-06-04 00:24:44] [index:background] Health check
[2024-06-04 00:24:44] [indexer:background] Health check
[2024-06-04 00:24:44] [indexer:background] Health check
[2024-06-04 00:29:22] [index:background] Health check
[2024-06-04 00:29:22] [indexer:background] Health check
[2024-06-04 00:29:22] [indexer:background] Health check
[2024-06-04 00:34:06] [index:background] Health check
[2024-06-04 00:34:44] [indexer:background] Health check
[2024-06-04 00:39:02] [index:background] Health check
[2024-06-04 00:39:36] [indexer:background] Health check
[2024-06-04 00:47:03] [index:background] Health check
[2024-06-04 00:47:04] [indexer:background] Health check
[2024-06-04 00:47:04] [indexer:background] Health check
[2024-06-04 00:49:15] [index:background] Health check
[2024-06-04 00:49:15] [indexer:background] Health check
[2024-06-04 00:49:15] [indexer:background] Health check
[2024-06-04 00:54:23] [index:background] Health check
[2024-06-04 00:54:23] [indexer:background] Health check
[2024-06-04 00:54:23] [indexer:background] Health check
[2024-06-04 00:59:25] [index:background] Health check
[2024-06-04 00:59:25] [indexer:background] Health check
[2024-06-04 00:59:25] [indexer:background] Health check
[2024-06-04 01:04:01] [index:background] Health check
[2024-06-04 01:04:30] [indexer:background] Health check
[2024-06-04 01:08:41] [index:background] Health check
[2024-06-04 01:11:45] [indexer:background] Health check
[2024-06-04 01:13:53] [index:background] Health check
[2024-06-04 01:14:31] [indexer:background] Health check
[2024-06-04 01:19:10] [index:background] Health check
[2024-06-04 01:19:48] [indexer:background] Health check
[2024-06-04 01:27:50] [index:background] Health check
[2024-06-04 01:27:50] [indexer:background] Health check
[2024-06-04 01:27:50] [indexer:background] Health check
[2024-06-04 01:29:39] [index:background] Health check
[2024-06-04 01:29:39] [indexer:background] Health check
[2024-06-04 01:29:39] [indexer:background] Health check
[2024-06-04 01:34:45] [index:background] Health check
[2024-06-04 01:34:45] [indexer:background] Health check
[2024-06-04 01:34:45] [indexer:background] Health check
[2024-06-04 01:38:57] [index:background] Health check
[2024-06-04 01:38:59] [query] Query for: 2024
[2024-06-04 01:38:59] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-04 01:38:59] [query] Engine: default
[2024-06-04 01:39:00] [query] Tokens: 2024
[2024-06-04 01:39:00] [query] Mods: 6
[2024-06-04 01:39:00] [query] Found results using: or logic
[2024-06-04 01:39:00] [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-06-04 01:39:00] [query] Results: 157 Pages of results: 16
[2024-06-04 01:39:00] [query] Execution time: 1.17880
[2024-06-04 01:41:06] [indexer:background] Health check
[2024-06-04 01:43:43] [index:background] Health check
[2024-06-04 01:45:29] [indexer:background] Health check
[2024-06-04 01:53:07] [index:background] Health check
[2024-06-04 01:53:07] [indexer:background] Health check
[2024-06-04 01:53:07] [indexer:background] Health check
[2024-06-04 01:54:08] [index:background] Health check
[2024-06-04 01:54:17] [indexer:background] Health check
[2024-06-04 01:58:41] [index:background] Health check
[2024-06-04 01:59:52] [indexer:background] Health check
[2024-06-04 02:04:13] [index:background] Health check
[2024-06-04 02:04:19] [indexer:background] Health check
[2024-06-04 02:09:32] [index:background] Health check
[2024-06-04 02:09:32] [indexer:background] Health check
[2024-06-04 02:09:32] [indexer:background] Health check
[2024-06-04 02:13:58] [index:background] Health check
[2024-06-04 02:14:33] [indexer:background] Health check
[2024-06-04 02:18:58] [index:background] Health check
[2024-06-04 02:19:21] [indexer:background] Health check
[2024-06-04 02:24:01] [index:background] Health check
[2024-06-04 02:24:21] [indexer:background] Health check
[2024-06-04 02:28:58] [index:background] Health check
[2024-06-04 02:29:42] [indexer:background] Health check
[2024-06-04 02:33:56] [index:background] Health check
[2024-06-04 02:34:18] [indexer:background] Health check
[2024-06-04 02:39:19] [index:background] Health check
[2024-06-04 02:39:19] [indexer:background] Health check
[2024-06-04 02:39:19] [indexer:background] Health check
[2024-06-04 02:44:24] [index:background] Health check
[2024-06-04 02:44:24] [indexer:background] Health check
[2024-06-04 02:44:24] [indexer:background] Health check
[2024-06-04 02:50:33] [index:background] Health check
[2024-06-04 02:50:33] [indexer:background] Health check
[2024-06-04 02:50:33] [indexer:background] Health check
[2024-06-04 02:54:17] [index:background] Health check
[2024-06-04 02:54:17] [indexer:background] Health check
[2024-06-04 02:54:17] [indexer:background] Health check
[2024-06-04 02:59:06] [index:background] Health check
[2024-06-04 03:00:04] [indexer:background] Health check
[2024-06-04 03:06:08] [index:background] Health check
[2024-06-04 03:06:08] [indexer:background] Health check
[2024-06-04 03:06:08] [indexer:background] Health check
[2024-06-04 03:10:03] [index:background] Health check
[2024-06-04 03:10:03] [indexer:background] Health check
[2024-06-04 03:10:03] [indexer:background] Health check
[2024-06-04 03:14:03] [index:background] Health check
[2024-06-04 03:15:54] [indexer:background] Health check
[2024-06-04 03:18:51] [index:background] Health check
[2024-06-04 03:19:53] [indexer:background] Health check
[2024-06-04 03:23:59] [index:background] Health check
[2024-06-04 03:24:25] [indexer:background] Health check
[2024-06-04 03:29:03] [index:background] Health check
[2024-06-04 03:31:17] [indexer:background] Health check
[2024-06-04 03:35:20] [index:background] Health check
[2024-06-04 03:35:20] [indexer:background] Health check
[2024-06-04 03:35:20] [indexer:background] Health check
[2024-06-04 03:39:56] [index:background] Health check
[2024-06-04 03:39:56] [indexer:background] Health check
[2024-06-04 03:39:56] [indexer:background] Health check
[2024-06-04 03:43:45] [index:background] Health check
[2024-06-04 03:44:52] [indexer:background] Health check
[2024-06-04 03:49:09] [index:background] Health check
[2024-06-04 03:49:59] [indexer:background] Health check
[2024-06-04 03:55:33] [index:background] Health check
[2024-06-04 03:55:33] [indexer:background] Health check
[2024-06-04 03:55:33] [indexer:background] Health check
[2024-06-04 03:58:45] [index:background] Health check
[2024-06-04 04:00:17] [indexer:background] Health check
[2024-06-04 04:04:27] [index:background] Health check
[2024-06-04 04:04:27] [index:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2024-06-04 04:04:30] [indexer:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2024-06-04 04:04:32] [indexer:background] Health check
[2024-06-04 04:04:32] [indexer:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2024-06-04 04:04:34] [indexer:background] Health check
[2024-06-04 04:04:34] [indexer:background] CPU load threshold (3) breached: 3.91 [waiting 2]
[2024-06-04 04:08:53] [index:background] Health check
[2024-06-04 04:10:12] [indexer:background] Health check
[2024-06-04 04:13:58] [index:background] Health check
[2024-06-04 04:14:54] [indexer:background] Health check
[2024-06-04 04:18:53] [index:background] Health check
[2024-06-04 04:19:17] [indexer:background] Health check
[2024-06-04 04:24:30] [index:background] Health check
[2024-06-04 04:24:30] [indexer:background] Health check
[2024-06-04 04:24:30] [indexer:background] Health check
[2024-06-04 04:29:16] [index:background] Health check
[2024-06-04 04:29:16] [indexer:background] Health check
[2024-06-04 04:29:16] [indexer:background] Health check
[2024-06-04 04:34:22] [index:background] Health check
[2024-06-04 04:34:22] [indexer:background] Health check
[2024-06-04 04:34:22] [indexer:background] Health check
[2024-06-04 04:38:46] [index:background] Health check
[2024-06-04 04:40:55] [indexer:background] Health check
[2024-06-04 04:44:12] [index:background] Health check
[2024-06-04 04:45:03] [indexer:background] Health check
[2024-06-04 04:49:28] [index:background] Health check
[2024-06-04 04:49:28] [indexer:background] Health check
[2024-06-04 04:49:28] [indexer:background] Health check
[2024-06-04 04:54:22] [index:background] Health check
[2024-06-04 04:54:22] [indexer:background] Health check
[2024-06-04 04:54:23] [indexer:background] Health check
[2024-06-04 04:58:42] [index:background] Health check
[2024-06-04 05:00:06] [indexer:background] Health check
[2024-06-04 05:03:46] [index:background] Health check
[2024-06-04 05:04:22] [indexer:background] Health check
[2024-06-04 05:09:32] [index:background] Health check
[2024-06-04 05:09:32] [indexer:background] Health check
[2024-06-04 05:09:32] [indexer:background] Health check
[2024-06-04 05:14:41] [index:background] Health check
[2024-06-04 05:14:41] [indexer:background] Health check
[2024-06-04 05:14:41] [indexer:background] Health check
[2024-06-04 05:19:16] [index:background] Health check
[2024-06-04 05:19:16] [indexer:background] Health check
[2024-06-04 05:19:16] [indexer:background] Health check
[2024-06-04 05:23:55] [index:background] Health check
[2024-06-04 05:25:07] [indexer:background] Health check
[2024-06-04 05:28:55] [index:background] Health check
[2024-06-04 05:29:23] [indexer:background] Health check
[2024-06-04 05:33:47] [index:background] Health check
[2024-06-04 05:34:37] [indexer:background] Health check
[2024-06-04 05:39:45] [index:background] Health check
[2024-06-04 05:39:45] [indexer:background] Health check
[2024-06-04 05:39:45] [indexer:background] Health check
[2024-06-04 05:45:04] [index:background] Health check
[2024-06-04 05:45:04] [indexer:background] Health check
[2024-06-04 05:45:04] [indexer:background] Health check
[2024-06-04 05:48:42] [index:background] Health check
[2024-06-04 05:50:29] [indexer:background] Health check
[2024-06-04 05:54:49] [index:background] Health check
[2024-06-04 05:54:49] [indexer:background] Health check
[2024-06-04 05:54:49] [indexer:background] Health check
[2024-06-04 05:58:57] [index:background] Health check
[2024-06-04 05:59:32] [indexer:background] Health check
[2024-06-04 06:04:26] [index:background] Health check
[2024-06-04 06:04:26] [indexer:background] Health check
[2024-06-04 06:04:26] [indexer:background] Health check
[2024-06-04 06:08:44] [index:background] Health check
[2024-06-04 06:09:39] [indexer:background] Health check
[2024-06-04 06:13:45] [index:background] Health check
[2024-06-04 06:14:33] [indexer:background] Health check
[2024-06-04 06:18:41] [index:background] Health check
[2024-06-04 06:20:53] [indexer:background] Health check
[2024-06-04 06:23:47] [index:background] Health check
[2024-06-04 06:24:26] [indexer:background] Health check
[2024-06-04 06:29:29] [index:background] Health check
[2024-06-04 06:29:29] [indexer:background] Health check
[2024-06-04 06:29:29] [indexer:background] Health check
[2024-06-04 06:34:04] [index:background] Health check
[2024-06-04 06:34:19] [indexer:background] Health check
[2024-06-04 06:39:11] [index:background] Health check
[2024-06-04 06:42:18] [indexer:background] Health check
[2024-06-04 06:44:01] [index:background] Health check
[2024-06-04 06:44:26] [indexer:background] Health check
[2024-06-04 06:48:47] [index:background] Health check
[2024-06-04 06:49:39] [indexer:background] Health check
[2024-06-04 06:53:59] [index:background] Health check
[2024-06-04 06:54:18] [indexer:background] Health check
[2024-06-04 06:58:58] [index:background] Health check
[2024-06-04 06:59:28] [indexer:background] Health check
[2024-06-04 07:03:48] [index:background] Health check
[2024-06-04 07:07:19] [indexer:background] Health check
[2024-06-04 07:09:08] [index:background] Health check
[2024-06-04 07:09:17] [indexer:background] Health check
[2024-06-04 07:15:07] [index:background] Health check
[2024-06-04 07:15:07] [indexer:background] Health check
[2024-06-04 07:15:07] [indexer:background] Health check
[2024-06-04 07:18:41] [index:background] Health check
[2024-06-04 07:19:20] [indexer:background] Health check
[2024-06-04 07:20:37] [index] Marking post.attachment 15707 to be dropped
[2024-06-04 07:20:40] [index] Dropping post.attachment 15707
[2024-06-04 07:20:40] [indexer] Queued next batch (1)
[2024-06-04 07:20:41] [indexer] Processing batch (1)
[2024-06-04 07:20:41] [indexer] Indexing post.attachment:15707
[2024-06-04 07:20:44] [index] Marking [1] post.attachment 15707 as indexed
[2024-06-04 07:20:44] [indexer] Index built
[2024-06-04 07:23:44] [index:background] Health check
[2024-06-04 07:24:33] [indexer:background] Health check
[2024-06-04 07:29:06] [index:background] Health check
[2024-06-04 07:29:16] [indexer:background] Health check
[2024-06-04 07:34:12] [index:background] Health check
[2024-06-04 07:34:29] [indexer:background] Health check
[2024-06-04 07:40:47] [index:background] Health check
[2024-06-04 07:40:47] [index:background] Health check
[2024-06-04 07:40:47] [indexer:background] Health check
[2024-06-04 07:40:47] [indexer:background] Health check
[2024-06-04 07:40:47] [indexer:background] Health check
[2024-06-04 07:40:47] [indexer:background] Health check
[2024-06-04 07:44:39] [index:background] Health check
[2024-06-04 07:44:39] [indexer:background] Health check
[2024-06-04 07:44:39] [indexer:background] Health check
[2024-06-04 07:49:35] [index:background] Health check
[2024-06-04 07:49:35] [indexer:background] Health check
[2024-06-04 07:49:36] [indexer:background] Health check
[2024-06-04 07:53:53] [index:background] Health check
[2024-06-04 07:54:19] [indexer:background] Health check
[2024-06-04 07:58:47] [index:background] Health check
[2024-06-04 08:00:44] [indexer:background] Health check
[2024-06-04 08:03:49] [index:background] Health check
[2024-06-04 08:04:19] [indexer:background] Health check
[2024-06-04 08:09:41] [index:background] Health check
[2024-06-04 08:09:41] [indexer:background] Health check
[2024-06-04 08:09:41] [indexer:background] Health check
[2024-06-04 08:14:33] [index:background] Health check
[2024-06-04 08:14:33] [indexer:background] Health check
[2024-06-04 08:14:33] [indexer:background] Health check
[2024-06-04 08:19:42] [index:background] Health check
[2024-06-04 08:19:42] [indexer:background] Health check
[2024-06-04 08:19:42] [indexer:background] Health check
[2024-06-04 08:24:34] [index:background] Health check
[2024-06-04 08:24:34] [indexer:background] Health check
[2024-06-04 08:24:34] [indexer:background] Health check
[2024-06-04 08:29:00] [index:background] Health check
[2024-06-04 08:29:27] [indexer:background] Health check
[2024-06-04 08:34:20] [index:background] Health check
[2024-06-04 08:34:20] [indexer:background] Health check
[2024-06-04 08:34:20] [indexer:background] Health check
[2024-06-04 08:38:49] [index:background] Health check
[2024-06-04 08:42:29] [indexer:background] Health check
[2024-06-04 08:43:52] [index:background] Health check
[2024-06-04 08:45:06] [indexer:background] Health check
[2024-06-04 08:49:51] [index:background] Health check
[2024-06-04 08:49:52] [indexer:background] Health check
[2024-06-04 08:49:52] [indexer:background] Health check
[2024-06-04 08:54:16] [index:background] Health check
[2024-06-04 08:54:16] [indexer:background] Health check
[2024-06-04 08:54:16] [indexer:background] Health check
[2024-06-04 08:58:49] [index:background] Health check
[2024-06-04 08:59:26] [indexer:background] Health check
[2024-06-04 09:03:55] [index:background] Health check
[2024-06-04 09:04:31] [indexer:background] Health check
[2024-06-04 09:09:32] [index:background] Health check
[2024-06-04 09:09:32] [indexer:background] Health check
[2024-06-04 09:09:32] [indexer:background] Health check
[2024-06-04 09:14:47] [index:background] Health check
[2024-06-04 09:14:47] [indexer:background] Health check
[2024-06-04 09:14:47] [indexer:background] Health check
[2024-06-04 09:19:51] [index:background] Health check
[2024-06-04 09:19:51] [indexer:background] Health check
[2024-06-04 09:19:52] [indexer:background] Health check
[2024-06-04 09:24:35] [index:background] Health check
[2024-06-04 09:24:35] [indexer:background] Health check
[2024-06-04 09:24:35] [indexer:background] Health check
[2024-06-04 09:30:08] [index:background] Health check
[2024-06-04 09:30:08] [indexer:background] Health check
[2024-06-04 09:30:08] [indexer:background] Health check
[2024-06-04 09:31:04] [query] Query for: 2023
[2024-06-04 09:31:04] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-04 09:31:04] [query] Engine: default
[2024-06-04 09:31:04] [query] Tokens: 2023
[2024-06-04 09:31:04] [query] Mods: 6
[2024-06-04 09:31:04] [query] Found results using: or logic
[2024-06-04 09:31:04] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-06-04 09:31:04] [query] Results: 279 Pages of results: 28
[2024-06-04 09:31:04] [query] Execution time: 0.36417
[2024-06-04 09:33:55] [index:background] Health check
[2024-06-04 09:37:06] [indexer:background] Health check
[2024-06-04 09:41:24] [index:background] Health check
[2024-06-04 09:41:24] [indexer:background] Health check
[2024-06-04 09:41:24] [indexer:background] Health check
[2024-06-04 09:43:43] [index:background] Health check
[2024-06-04 09:44:38] [indexer:background] Health check
[2024-06-04 09:48:42] [index:background] Health check
[2024-06-04 09:49:31] [indexer:background] Health check
[2024-06-04 09:53:51] [index:background] Health check
[2024-06-04 09:54:20] [indexer:background] Health check
[2024-06-04 09:58:46] [index:background] Health check
[2024-06-04 09:59:32] [indexer:background] Health check
[2024-06-04 10:04:02] [index:background] Health check
[2024-06-04 10:04:26] [indexer:background] Health check
[2024-06-04 10:09:54] [index:background] Health check
[2024-06-04 10:09:54] [indexer:background] Health check
[2024-06-04 10:09:54] [indexer:background] Health check
[2024-06-04 10:15:23] [index:background] Health check
[2024-06-04 10:15:23] [indexer:background] Health check
[2024-06-04 10:15:23] [indexer:background] Health check
[2024-06-04 10:17:56] [query] Query for: 2024
[2024-06-04 10:17:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-04 10:17:56] [query] Engine: default
[2024-06-04 10:17:56] [query] Tokens: 2024
[2024-06-04 10:17:56] [query] Mods: 6
[2024-06-04 10:17:56] [query] Found results using: or logic
[2024-06-04 10:17:56] [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-06-04 10:17:56] [query] Results: 158 Pages of results: 16
[2024-06-04 10:17:56] [query] Execution time: 0.25131
[2024-06-04 10:19:43] [index:background] Health check
[2024-06-04 10:19:43] [indexer:background] Health check
[2024-06-04 10:19:43] [indexer:background] Health check
[2024-06-04 10:23:42] [index:background] Health check
[2024-06-04 10:25:12] [indexer:background] Health check
[2024-06-04 10:29:40] [index:background] Health check
[2024-06-04 10:29:40] [indexer:background] Health check
[2024-06-04 10:29:40] [indexer:background] Health check
[2024-06-04 10:33:42] [index:background] Health check
[2024-06-04 10:34:41] [indexer:background] Health check
[2024-06-04 10:39:08] [index:background] Health check
[2024-06-04 10:39:20] [indexer:background] Health check
[2024-06-04 10:44:40] [index:background] Health check
[2024-06-04 10:44:40] [indexer:background] Health check
[2024-06-04 10:44:40] [indexer:background] Health check
[2024-06-04 10:48:51] [index:background] Health check
[2024-06-04 10:50:07] [indexer:background] Health check
[2024-06-04 10:54:44] [index:background] Health check
[2024-06-04 10:54:44] [indexer:background] Health check
[2024-06-04 10:54:44] [indexer:background] Health check
[2024-06-04 10:58:56] [index:background] Health check
[2024-06-04 10:59:48] [indexer:background] Health check
[2024-06-04 11:04:37] [index:background] Health check
[2024-06-04 11:04:37] [indexer:background] Health check
[2024-06-04 11:04:37] [indexer:background] Health check
[2024-06-04 11:09:31] [index:background] Health check
[2024-06-04 11:09:31] [indexer:background] Health check
[2024-06-04 11:09:31] [indexer:background] Health check
[2024-06-04 11:14:18] [index:background] Health check
[2024-06-04 11:14:18] [indexer:background] Health check
[2024-06-04 11:14:18] [indexer:background] Health check
[2024-06-04 11:19:43] [index:background] Health check
[2024-06-04 11:19:43] [indexer:background] Health check
[2024-06-04 11:19:43] [indexer:background] Health check
[2024-06-04 11:24:11] [index:background] Health check
[2024-06-04 11:26:44] [indexer:background] Health check
[2024-06-04 11:28:42] [index:background] Health check
[2024-06-04 11:29:17] [indexer:background] Health check
[2024-06-04 11:33:53] [index:background] Health check
[2024-06-04 11:35:22] [indexer:background] Health check
[2024-06-04 11:40:25] [index:background] Health check
[2024-06-04 11:40:25] [indexer:background] Health check
[2024-06-04 11:40:25] [indexer:background] Health check
[2024-06-04 11:43:55] [index:background] Health check
[2024-06-04 11:44:41] [indexer:background] Health check
[2024-06-04 11:48:44] [index:background] Health check
[2024-06-04 11:49:18] [indexer:background] Health check
[2024-06-04 11:54:12] [index:background] Health check
[2024-06-04 11:54:50] [indexer:background] Health check
[2024-06-04 12:00:38] [index:background] Health check
[2024-06-04 12:00:38] [indexer:background] Health check
[2024-06-04 12:00:38] [indexer:background] Health check
[2024-06-04 12:03:51] [index:background] Health check
[2024-06-04 12:05:26] [indexer:background] Health check
[2024-06-04 12:09:16] [index:background] Health check
[2024-06-04 12:09:16] [indexer:background] Health check
[2024-06-04 12:09:16] [indexer:background] Health check
[2024-06-04 12:15:06] [index:background] Health check
[2024-06-04 12:15:07] [indexer:background] Health check
[2024-06-04 12:15:07] [indexer:background] Health check
[2024-06-04 12:19:01] [index:background] Health check
[2024-06-04 12:20:07] [indexer:background] Health check
[2024-06-04 12:25:23] [index:background] Health check
[2024-06-04 12:25:23] [indexer:background] Health check
[2024-06-04 12:25:23] [indexer:background] Health check
[2024-06-04 12:29:16] [index:background] Health check
[2024-06-04 12:29:16] [indexer:background] Health check
[2024-06-04 12:29:16] [indexer:background] Health check
[2024-06-04 12:33:42] [index:background] Health check
[2024-06-04 12:34:59] [indexer:background] Health check
[2024-06-04 12:38:57] [index:background] Health check
[2024-06-04 12:40:09] [indexer:background] Health check
[2024-06-04 12:45:06] [index:background] Health check
[2024-06-04 12:45:06] [indexer:background] Health check
[2024-06-04 12:45:06] [indexer:background] Health check
[2024-06-04 12:45:55] [query] Query for: arrêté 9030 du 10 décembre 1986
[2024-06-04 12:45:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-04 12:45:55] [query] Engine: default
[2024-06-04 12:45:56] [query] Tokens: arretant, du 10e, decembres, decembre, arréte, arrèt, arretie, arréter, arrète, arretea, arrétées, arrèté, arreteront, arretera, arreté, arrété, arreta, arrets, arreter, arrete, arretes, arret, 9030, decembr, 1986, du 10, arrete 9030 decembre 1986
[2024-06-04 12:45:56] [query] Mods: 6
[2024-06-04 12:45:56] [query] Using OR logic
[2024-06-04 12:45:59] [query] Found results using: or logic
[2024-06-04 12:45:59] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (376604,375687,215528,697,799275,689535,586210,575556,514969,503204,478327,353841,219790,130628,69934,69901,51347,45128,28780,17551,4766,2865,127326,28486,14373,2073,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-06-04 12:45:59] [query] Results: 3312 Pages of results: 332
[2024-06-04 12:45:59] [query] Execution time: 3.73187
[2024-06-04 12:48:55] [index:background] Health check
[2024-06-04 12:49:37] [indexer:background] Health check
[2024-06-04 12:54:15] [index:background] Health check
[2024-06-04 12:54:15] [indexer:background] Health check
[2024-06-04 12:54:15] [indexer:background] Health check
[2024-06-04 12:58:43] [index:background] Health check
[2024-06-04 12:59:28] [indexer:background] Health check
[2024-06-04 13:04:55] [index:background] Health check
[2024-06-04 13:04:55] [indexer:background] Health check
[2024-06-04 13:04:55] [indexer:background] Health check
[2024-06-04 13:09:13] [index:background] Health check
[2024-06-04 13:10:15] [indexer:background] Health check
[2024-06-04 13:13:55] [index:background] Health check
[2024-06-04 13:14:50] [indexer:background] Health check
[2024-06-04 13:19:07] [index:background] Health check
[2024-06-04 13:19:40] [indexer:background] Health check
[2024-06-04 13:24:45] [index:background] Health check
[2024-06-04 13:24:45] [indexer:background] Health check
[2024-06-04 13:24:45] [indexer:background] Health check
[2024-06-04 13:29:27] [index:background] Health check
[2024-06-04 13:29:27] [indexer:background] Health check
[2024-06-04 13:29:27] [indexer:background] Health check
[2024-06-04 13:33:51] [index:background] Health check
[2024-06-04 13:34:17] [indexer:background] Health check
[2024-06-04 13:39:21] [index:background] Health check
[2024-06-04 13:39:21] [indexer:background] Health check
[2024-06-04 13:39:21] [indexer:background] Health check
[2024-06-04 13:43:55] [index:background] Health check
[2024-06-04 13:45:05] [indexer:background] Health check
[2024-06-04 13:49:35] [index:background] Health check
[2024-06-04 13:49:35] [indexer:background] Health check
[2024-06-04 13:49:35] [indexer:background] Health check
[2024-06-04 13:53:59] [index:background] Health check
[2024-06-04 13:54:17] [indexer:background] Health check
[2024-06-04 13:58:42] [index:background] Health check
[2024-06-04 13:59:17] [indexer:background] Health check
[2024-06-04 14:03:45] [index:background] Health check
[2024-06-04 14:04:30] [indexer:background] Health check
[2024-06-04 14:08:50] [index:background] Health check
[2024-06-04 14:09:58] [indexer:background] Health check
[2024-06-04 14:14:16] [index:background] Health check
[2024-06-04 14:14:16] [indexer:background] Health check
[2024-06-04 14:14:17] [indexer:background] Health check
[2024-06-04 14:18:46] [index:background] Health check
[2024-06-04 14:19:18] [indexer:background] Health check
[2024-06-04 14:23:43] [index:background] Health check
[2024-06-04 14:24:21] [indexer:background] Health check
[2024-06-04 14:28:44] [index:background] Health check
[2024-06-04 14:29:40] [indexer:background] Health check
[2024-06-04 14:33:44] [index:background] Health check
[2024-06-04 14:34:18] [indexer:background] Health check
[2024-06-04 14:42:36] [index:background] Health check
[2024-06-04 14:42:36] [indexer:background] Health check
[2024-06-04 14:42:36] [indexer:background] Health check
[2024-06-04 14:44:17] [index:background] Health check
[2024-06-04 14:44:17] [indexer:background] Health check
[2024-06-04 14:44:17] [indexer:background] Health check
[2024-06-04 14:48:44] [index:background] Health check
[2024-06-04 14:49:18] [indexer:background] Health check
[2024-06-04 14:54:24] [index:background] Health check
[2024-06-04 14:54:24] [indexer:background] Health check
[2024-06-04 14:54:24] [indexer:background] Health check
[2024-06-04 14:59:30] [index:background] Health check
[2024-06-04 14:59:30] [indexer:background] Health check
[2024-06-04 14:59:30] [indexer:background] Health check
[2024-06-04 15:04:12] [index:background] Health check
[2024-06-04 15:04:17] [indexer:background] Health check
[2024-06-04 15:08:54] [index:background] Health check
[2024-06-04 15:09:56] [indexer:background] Health check
[2024-06-04 15:13:45] [index:background] Health check
[2024-06-04 15:14:33] [indexer:background] Health check
[2024-06-04 15:18:45] [index:background] Health check
[2024-06-04 15:20:40] [indexer:background] Health check
[2024-06-04 15:23:44] [index:background] Health check
[2024-06-04 15:26:10] [indexer:background] Health check
[2024-06-04 15:26:11] [indexer:background] Health check
[2024-06-04 15:28:51] [index:background] Health check
[2024-06-04 15:29:28] [indexer:background] Health check
[2024-06-04 15:34:56] [index:background] Health check
[2024-06-04 15:34:56] [indexer:background] Health check
[2024-06-04 15:34:56] [indexer:background] Health check
[2024-06-04 15:39:05] [index:background] Health check
[2024-06-04 15:40:17] [indexer:background] Health check
[2024-06-04 15:44:10] [index:background] Health check
[2024-06-04 15:44:39] [indexer:background] Health check
[2024-06-04 15:48:48] [index:background] Health check
[2024-06-04 15:50:13] [indexer:background] Health check
[2024-06-04 15:54:24] [index:background] Health check
[2024-06-04 15:54:24] [indexer:background] Health check
[2024-06-04 15:54:25] [indexer:background] Health check
[2024-06-04 15:59:06] [index:background] Health check
[2024-06-04 15:59:58] [indexer:background] Health check
[2024-06-04 16:04:08] [index:background] Health check
[2024-06-04 16:04:18] [indexer:background] Health check
[2024-06-04 16:09:44] [index:background] Health check
[2024-06-04 16:09:44] [indexer:background] Health check
[2024-06-04 16:09:44] [indexer:background] Health check
[2024-06-04 16:12:39] [query] Query for: 2023
[2024-06-04 16:12:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-04 16:12:39] [query] Engine: default
[2024-06-04 16:12:40] [query] Tokens: 2023
[2024-06-04 16:12:40] [query] Mods: 6
[2024-06-04 16:12:40] [query] Found results using: or logic
[2024-06-04 16:12:40] [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-06-04 16:12:40] [query] Results: 279 Pages of results: 28
[2024-06-04 16:12:40] [query] Execution time: 0.88660
[2024-06-04 16:12:40] [query] Query for: 2023
[2024-06-04 16:12:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-06-04 16:12:40] [query] Engine: default
[2024-06-04 16:12:40] [query] Tokens: 2023
[2024-06-04 16:12:40] [query] Mods: 6
[2024-06-04 16:12:40] [query] Found results using: or logic
[2024-06-04 16:12:40] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-06-04 16:12:40] [query] Results: 279 Pages of results: 3
[2024-06-04 16:12:41] [query] Execution time: 0.18715
[2024-06-04 16:14:35] [index:background] Health check
[2024-06-04 16:14:36] [indexer:background] Health check
[2024-06-04 16:14:36] [indexer:background] Health check
[2024-06-04 16:19:26] [index:background] Health check
[2024-06-04 16:19:26] [indexer:background] Health check
[2024-06-04 16:19:26] [indexer:background] Health check
[2024-06-04 16:23:59] [index:background] Health check
[2024-06-04 16:24:22] [indexer:background] Health check
[2024-06-04 16:29:48] [index:background] Health check
[2024-06-04 16:29:48] [indexer:background] Health check
[2024-06-04 16:29:48] [indexer:background] Health check
[2024-06-04 16:34:04] [index:background] Health check
[2024-06-04 16:34:19] [indexer:background] Health check
[2024-06-04 16:38:45] [index:background] Health check
[2024-06-04 16:39:54] [indexer:background] Health check
[2024-06-04 16:43:54] [index:background] Health check
[2024-06-04 16:44:28] [indexer:background] Health check
[2024-06-04 16:49:05] [index:background] Health check
[2024-06-04 16:50:04] [indexer:background] Health check
[2024-06-04 16:53:53] [index:background] Health check
[2024-06-04 16:54:21] [indexer:background] Health check
[2024-06-04 16:58:49] [index:background] Health check
[2024-06-04 16:59:15] [indexer:background] Health check
[2024-06-04 17:06:37] [index:background] Health check
[2024-06-04 17:06:37] [indexer:background] Health check
[2024-06-04 17:06:37] [indexer:background] Health check
[2024-06-04 17:10:03] [index:background] Health check
[2024-06-04 17:10:03] [indexer:background] Health check
[2024-06-04 17:10:03] [indexer:background] Health check
[2024-06-04 17:15:09] [index:background] Health check
[2024-06-04 17:15:09] [indexer:background] Health check
[2024-06-04 17:15:09] [indexer:background] Health check
[2024-06-04 17:22:01] [index:background] Health check
[2024-06-04 17:22:01] [indexer:background] Health check
[2024-06-04 17:22:01] [indexer:background] Health check
[2024-06-04 17:24:22] [index:background] Health check
[2024-06-04 17:24:23] [indexer:background] Health check
[2024-06-04 17:24:23] [indexer:background] Health check
[2024-06-04 17:28:49] [index:background] Health check
[2024-06-04 17:29:17] [indexer:background] Health check
[2024-06-04 17:35:09] [index:background] Health check
[2024-06-04 17:35:09] [indexer:background] Health check
[2024-06-04 17:35:09] [indexer:background] Health check
[2024-06-04 17:41:20] [index:background] Health check
[2024-06-04 17:41:20] [indexer:background] Health check
[2024-06-04 17:41:20] [indexer:background] Health check
[2024-06-04 17:43:50] [index:background] Health check
[2024-06-04 17:44:18] [indexer:background] Health check
[2024-06-04 17:48:59] [index:background] Health check
[2024-06-04 17:49:42] [indexer:background] Health check
[2024-06-04 17:54:53] [index:background] Health check
[2024-06-04 17:54:55] [indexer:background] Health check
[2024-06-04 17:54:55] [indexer:background] Health check
[2024-06-04 17:59:27] [index:background] Health check
[2024-06-04 17:59:27] [indexer:background] Health check
[2024-06-04 17:59:27] [indexer:background] Health check
[2024-06-04 18:05:29] [index:background] Health check
[2024-06-04 18:05:29] [indexer:background] Health check
[2024-06-04 18:05:29] [indexer:background] Health check
[2024-06-04 18:09:17] [index:background] Health check
[2024-06-04 18:09:17] [indexer:background] Health check
[2024-06-04 18:09:17] [indexer:background] Health check
[2024-06-04 18:14:01] [index:background] Health check
[2024-06-04 18:14:30] [indexer:background] Health check
[2024-06-04 18:18:57] [index:background] Health check
[2024-06-04 18:19:21] [indexer:background] Health check
[2024-06-04 18:24:50] [index:background] Health check
[2024-06-04 18:24:50] [indexer:background] Health check
[2024-06-04 18:24:50] [indexer:background] Health check
[2024-06-04 18:30:18] [index:background] Health check
[2024-06-04 18:30:18] [indexer:background] Health check
[2024-06-04 18:30:18] [indexer:background] Health check
[2024-06-04 18:34:05] [index:background] Health check
[2024-06-04 18:35:40] [indexer:background] Health check
[2024-06-04 18:39:56] [index:background] Health check
[2024-06-04 18:39:56] [indexer:background] Health check
[2024-06-04 18:39:56] [indexer:background] Health check
[2024-06-04 18:45:07] [index:background] Health check
[2024-06-04 18:45:07] [indexer:background] Health check
[2024-06-04 18:45:07] [indexer:background] Health check
[2024-06-04 18:48:42] [index:background] Health check
[2024-06-04 18:49:50] [indexer:background] Health check
[2024-06-04 18:53:49] [index:background] Health check
[2024-06-04 18:54:34] [indexer:background] Health check
[2024-06-04 18:58:42] [index:background] Health check
[2024-06-04 18:59:17] [indexer:background] Health check
[2024-06-04 19:03:46] [index:background] Health check
[2024-06-04 19:04:19] [indexer:background] Health check
[2024-06-04 19:09:56] [index:background] Health check
[2024-06-04 19:09:56] [indexer:background] Health check
[2024-06-04 19:09:56] [indexer:background] Health check
[2024-06-04 19:14:26] [index:background] Health check
[2024-06-04 19:14:26] [indexer:background] Health check
[2024-06-04 19:14:26] [indexer:background] Health check
[2024-06-04 19:19:28] [index:background] Health check
[2024-06-04 19:19:28] [indexer:background] Health check
[2024-06-04 19:19:28] [indexer:background] Health check
[2024-06-04 19:23:53] [index:background] Health check
[2024-06-04 19:25:20] [indexer:background] Health check
[2024-06-04 19:29:51] [index:background] Health check
[2024-06-04 19:29:51] [indexer:background] Health check
[2024-06-04 19:29:51] [indexer:background] Health check
[2024-06-04 19:35:18] [index:background] Health check
[2024-06-04 19:35:18] [indexer:background] Health check
[2024-06-04 19:35:18] [indexer:background] Health check
[2024-06-04 19:40:46] [index:background] Health check
[2024-06-04 19:40:46] [index:background] CPU load threshold (3) breached: 3.28 [waiting 2]
[2024-06-04 19:40:48] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-06-04 19:40:50] [indexer:background] Health check
[2024-06-04 19:40:50] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-06-04 19:40:52] [indexer:background] Health check
[2024-06-04 19:44:04] [index:background] Health check
[2024-06-04 19:44:27] [indexer:background] Health check
[2024-06-04 19:49:46] [index:background] Health check
[2024-06-04 19:49:46] [indexer:background] Health check
[2024-06-04 19:49:46] [indexer:background] Health check
[2024-06-04 19:56:23] [index:background] Health check
[2024-06-04 19:56:23] [indexer:background] Health check
[2024-06-04 19:56:23] [indexer:background] Health check
[2024-06-04 19:59:13] [index:background] Health check
[2024-06-04 19:59:35] [indexer:background] Health check
[2024-06-04 20:03:58] [index:background] Health check
[2024-06-04 20:04:16] [indexer:background] Health check
[2024-06-04 20:09:22] [index:background] Health check
[2024-06-04 20:09:22] [indexer:background] Health check
[2024-06-04 20:09:22] [indexer:background] Health check
[2024-06-04 20:16:03] [index:background] Health check
[2024-06-04 20:16:03] [indexer:background] Health check
[2024-06-04 20:16:03] [indexer:background] Health check
[2024-06-04 20:18:50] [index:background] Health check
[2024-06-04 20:19:23] [indexer:background] Health check
[2024-06-04 20:24:32] [index:background] Health check
[2024-06-04 20:24:32] [indexer:background] Health check
[2024-06-04 20:24:33] [indexer:background] Health check
[2024-06-04 20:29:12] [index:background] Health check
[2024-06-04 20:29:35] [indexer:background] Health check
[2024-06-04 20:35:28] [index:background] Health check
[2024-06-04 20:35:28] [indexer:background] Health check
[2024-06-04 20:35:28] [indexer:background] Health check
[2024-06-04 20:40:42] [index:background] Health check
[2024-06-04 20:40:42] [indexer:background] Health check
[2024-06-04 20:40:42] [indexer:background] Health check
[2024-06-04 20:45:09] [index:background] Health check
[2024-06-04 20:45:09] [indexer:background] Health check
[2024-06-04 20:45:09] [indexer:background] Health check
[2024-06-04 20:51:15] [index:background] Health check
[2024-06-04 20:51:15] [indexer:background] Health check
[2024-06-04 20:51:15] [indexer:background] Health check
[2024-06-04 20:53:45] [index:background] Health check
[2024-06-04 20:54:27] [indexer:background] Health check
[2024-06-04 20:59:37] [index:background] Health check
[2024-06-04 20:59:37] [indexer:background] Health check
[2024-06-04 20:59:37] [indexer:background] Health check
[2024-06-04 21:03:59] [index:background] Health check
[2024-06-04 21:06:10] [indexer:background] Health check
[2024-06-04 21:09:36] [index:background] Health check
[2024-06-04 21:09:36] [indexer:background] Health check
[2024-06-04 21:09:36] [indexer:background] Health check
[2024-06-04 21:14:16] [index:background] Health check
[2024-06-04 21:14:16] [indexer:background] Health check
[2024-06-04 21:14:16] [indexer:background] Health check
[2024-06-04 21:18:47] [index:background] Health check
[2024-06-04 21:21:36] [indexer:background] Health check
[2024-06-04 21:24:02] [index:background] Health check
[2024-06-04 21:24:18] [indexer:background] Health check
[2024-06-04 21:28:55] [index:background] Health check
[2024-06-04 21:30:25] [indexer:background] Health check
[2024-06-04 21:34:47] [index:background] Health check
[2024-06-04 21:34:47] [indexer:background] Health check
[2024-06-04 21:34:47] [indexer:background] Health check
[2024-06-04 21:40:36] [index:background] Health check
[2024-06-04 21:40:36] [indexer:background] Health check
[2024-06-04 21:40:36] [indexer:background] Health check
[2024-06-04 21:44:27] [index:background] Health check
[2024-06-04 21:44:27] [indexer:background] Health check
[2024-06-04 21:44:27] [indexer:background] Health check
[2024-06-04 21:49:10] [index:background] Health check
[2024-06-04 21:49:53] [indexer:background] Health check
[2024-06-04 21:53:48] [index:background] Health check
[2024-06-04 21:55:08] [indexer:background] Health check
[2024-06-04 21:59:38] [index:background] Health check
[2024-06-04 21:59:39] [indexer:background] Health check
[2024-06-04 21:59:39] [indexer:background] Health check
[2024-06-04 22:04:07] [index:background] Health check
[2024-06-04 22:04:18] [indexer:background] Health check
[2024-06-04 22:08:42] [index:background] Health check
[2024-06-04 22:09:20] [indexer:background] Health check
[2024-06-04 22:14:16] [index:background] Health check
[2024-06-04 22:15:20] [indexer:background] Health check
[2024-06-04 22:19:03] [index:background] Health check
[2024-06-04 22:19:48] [indexer:background] Health check
[2024-06-04 22:24:01] [index:background] Health check
[2024-06-04 22:24:50] [indexer:background] Health check
[2024-06-04 22:29:10] [index:background] Health check
[2024-06-04 22:29:10] [query] Query for: 2024
[2024-06-04 22:29:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-04 22:29:10] [query] Engine: default
[2024-06-04 22:29:11] [query] Tokens: 2024
[2024-06-04 22:29:11] [query] Mods: 6
[2024-06-04 22:29:11] [query] Found results using: or logic
[2024-06-04 22:29:11] [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-06-04 22:29:11] [query] Results: 158 Pages of results: 16
[2024-06-04 22:29:11] [query] Execution time: 0.99952
[2024-06-04 22:29:11] [query] Query for: 2024
[2024-06-04 22:29:11] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-06-04 22:29:11] [query] Engine: default
[2024-06-04 22:29:11] [query] Tokens: 2024
[2024-06-04 22:29:11] [query] Mods: 6
[2024-06-04 22:29:11] [query] Found results using: or logic
[2024-06-04 22:29:11] [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-06-04 22:29:11] [query] Results: 158 Pages of results: 2
[2024-06-04 22:29:11] [query] Execution time: 0.16901
[2024-06-04 22:31:51] [indexer:background] Health check
[2024-06-04 22:36:26] [index:background] Health check
[2024-06-04 22:36:26] [indexer:background] Health check
[2024-06-04 22:36:26] [indexer:background] Health check
[2024-06-04 22:42:22] [index:background] Health check
[2024-06-04 22:42:22] [indexer:background] Health check
[2024-06-04 22:42:22] [indexer:background] Health check
[2024-06-04 22:44:31] [index:background] Health check
[2024-06-04 22:44:31] [indexer:background] Health check
[2024-06-04 22:44:31] [indexer:background] Health check
[2024-06-04 22:48:58] [index:background] Health check
[2024-06-04 22:53:51] [indexer:background] Health check
[2024-06-04 22:53:51] [index:background] Health check
[2024-06-04 22:56:57] [indexer:background] Health check
[2024-06-04 23:01:50] [index:background] Health check
[2024-06-04 23:01:50] [indexer:background] Health check
[2024-06-04 23:01:50] [indexer:background] Health check
[2024-06-04 23:05:04] [index:background] Health check
[2024-06-04 23:05:05] [indexer:background] Health check
[2024-06-04 23:05:05] [indexer:background] Health check
[2024-06-04 23:08:54] [index:background] Health check
[2024-06-04 23:12:02] [indexer:background] Health check
[2024-06-04 23:13:52] [index:background] Health check
[2024-06-04 23:15:12] [indexer:background] Health check
[2024-06-04 23:18:50] [index:background] Health check
[2024-06-04 23:21:13] [indexer:background] Health check
[2024-06-04 23:26:14] [index:background] Health check
[2024-06-04 23:26:14] [indexer:background] Health check
[2024-06-04 23:26:14] [indexer:background] Health check
[2024-06-04 23:29:00] [index:background] Health check
[2024-06-04 23:29:50] [indexer:background] Health check
[2024-06-04 23:33:56] [index:background] Health check
[2024-06-04 23:34:18] [indexer:background] Health check
[2024-06-04 23:38:50] [index:background] Health check
[2024-06-04 23:39:30] [indexer:background] Health check
[2024-06-04 23:44:09] [index:background] Health check
[2024-06-04 23:45:03] [indexer:background] Health check
[2024-06-04 23:49:15] [index:background] Health check
[2024-06-04 23:49:15] [indexer:background] Health check
[2024-06-04 23:49:15] [indexer:background] Health check
[2024-06-04 23:56:55] [index:background] Health check
[2024-06-04 23:56:55] [indexer:background] Health check
[2024-06-04 23:56:55] [indexer:background] Health check
[2024-06-04 23:58:43] [index:background] Health check