[2024-03-02 00:01:07] [index:background] Health check [2024-03-02 00:02:36] [indexer:background] Health check [2024-03-02 00:05:44] [index:background] Health check [2024-03-02 00:07:22] [indexer:background] Health check [2024-03-02 00:10:50] [index:background] Health check [2024-03-02 00:12:16] [indexer:background] Health check [2024-03-02 00:15:50] [index:background] Health check [2024-03-02 00:18:41] [indexer:background] Health check [2024-03-02 00:21:04] [index:background] Health check [2024-03-02 00:22:16] [indexer:background] Health check [2024-03-02 00:25:46] [index:background] Health check [2024-03-02 00:27:23] [indexer:background] Health check [2024-03-02 00:30:56] [index:background] Health check [2024-03-02 00:32:13] [indexer:background] Health check [2024-03-02 00:35:59] [index:background] Health check [2024-03-02 00:40:01] [indexer:background] Health check [2024-03-02 00:41:23] [index:background] Health check [2024-03-02 00:42:52] [indexer:background] Health check [2024-03-02 00:45:39] [index:background] Health check [2024-03-02 00:47:23] [indexer:background] Health check [2024-03-02 00:51:51] [index:background] Health check [2024-03-02 00:53:12] [indexer:background] Health check [2024-03-02 00:56:26] [index:background] Health check [2024-03-02 00:58:05] [indexer:background] Health check [2024-03-02 01:00:40] [index:background] Health check [2024-03-02 01:02:11] [indexer:background] Health check [2024-03-02 01:05:45] [index:background] Health check [2024-03-02 01:08:02] [indexer:background] Health check [2024-03-02 01:15:22] [index:background] Health check [2024-03-02 01:15:22] [indexer:background] Health check [2024-03-02 01:15:22] [indexer:background] Health check [2024-03-02 01:15:53] [index:background] Health check [2024-03-02 01:18:41] [indexer:background] Health check [2024-03-02 01:21:21] [index:background] Health check [2024-03-02 01:23:25] [indexer:background] Health check [2024-03-02 01:26:22] [index:background] Health check [2024-03-02 01:27:22] [indexer:background] Health check [2024-03-02 01:30:59] [index:background] Health check [2024-03-02 01:33:24] [indexer:background] Health check [2024-03-02 01:35:39] [index:background] Health check [2024-03-02 01:37:45] [indexer:background] Health check [2024-03-02 01:42:07] [index:background] Health check [2024-03-02 01:42:23] [indexer:background] Health check [2024-03-02 01:46:25] [index:background] Health check [2024-03-02 01:48:48] [indexer:background] Health check [2024-03-02 01:50:38] [index:background] Health check [2024-03-02 01:52:25] [indexer:background] Health check [2024-03-02 01:58:36] [index:background] Health check [2024-03-02 01:58:36] [indexer:background] Health check [2024-03-02 01:58:36] [indexer:background] Health check [2024-03-02 02:01:28] [index:background] Health check [2024-03-02 02:02:52] [indexer:background] Health check [2024-03-02 02:05:38] [index:background] Health check [2024-03-02 02:08:31] [indexer:background] Health check [2024-03-02 02:11:17] [index:background] Health check [2024-03-02 02:13:46] [indexer:background] Health check [2024-03-02 02:17:09] [index:background] Health check [2024-03-02 02:17:14] [indexer:background] Health check [2024-03-02 02:23:31] [index:background] Health check [2024-03-02 02:23:31] [indexer:background] Health check [2024-03-02 02:23:31] [indexer:background] Health check [2024-03-02 02:25:43] [index:background] Health check [2024-03-02 02:28:16] [indexer:background] Health check [2024-03-02 02:33:32] [index:background] Health check [2024-03-02 02:33:32] [indexer:background] Health check [2024-03-02 02:33:32] [indexer:background] Health check [2024-03-02 02:37:16] [index:background] Health check [2024-03-02 02:37:16] [indexer:background] Health check [2024-03-02 02:37:16] [indexer:background] Health check [2024-03-02 02:42:28] [index:background] Health check [2024-03-02 02:42:28] [indexer:background] Health check [2024-03-02 02:42:28] [indexer:background] Health check [2024-03-02 02:48:03] [index:background] Health check [2024-03-02 02:48:04] [indexer:background] Health check [2024-03-02 02:48:04] [indexer:background] Health check [2024-03-02 02:51:08] [index:background] Health check [2024-03-02 02:52:30] [indexer:background] Health check [2024-03-02 02:55:51] [index:background] Health check [2024-03-02 03:00:03] [indexer:background] Health check [2024-03-02 03:00:51] [index:background] Health check [2024-03-02 03:02:46] [indexer:background] Health check [2024-03-02 03:05:40] [index:background] Health check [2024-03-02 03:08:08] [indexer:background] Health check [2024-03-02 03:11:34] [index:background] Health check [2024-03-02 03:12:15] [indexer:background] Health check [2024-03-02 03:16:40] [index:background] Health check [2024-03-02 03:17:57] [indexer:background] Health check [2024-03-02 03:20:45] [index:background] Health check [2024-03-02 03:23:41] [indexer:background] Health check [2024-03-02 03:27:06] [index:background] Health check [2024-03-02 03:28:45] [indexer:background] Health check [2024-03-02 03:31:20] [index:background] Health check [2024-03-02 03:32:46] [indexer:background] Health check [2024-03-02 03:34:22] [query] Query for: 2024 [2024-03-02 03:34:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 03:34:22] [query] Engine: default [2024-03-02 03:34:22] [query] Tokens: 2024 [2024-03-02 03:34:22] [query] Mods: 6 [2024-03-02 03:34:22] [query] Found results using: or logic [2024-03-02 03:34:22] [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-03-02 03:34:22] [query] Results: 141 Pages of results: 15 [2024-03-02 03:34:22] [query] Execution time: 0.40096 [2024-03-02 03:37:31] [index:background] Health check [2024-03-02 03:37:31] [indexer:background] Health check [2024-03-02 03:37:31] [indexer:background] Health check [2024-03-02 03:42:29] [index:background] Health check [2024-03-02 03:42:29] [indexer:background] Health check [2024-03-02 03:42:29] [indexer:background] Health check [2024-03-02 03:46:22] [index:background] Health check [2024-03-02 03:48:01] [indexer:background] Health check [2024-03-02 03:52:02] [index:background] Health check [2024-03-02 03:52:46] [indexer:background] Health check [2024-03-02 03:57:35] [index:background] Health check [2024-03-02 03:57:35] [indexer:background] Health check [2024-03-02 03:57:35] [indexer:background] Health check [2024-03-02 04:01:07] [index:background] Health check [2024-03-02 04:01:27] [query] Query for: 2024 [2024-03-02 04:01:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 04:01:27] [query] Engine: default [2024-03-02 04:01:27] [query] Tokens: 2024 [2024-03-02 04:01:27] [query] Mods: 6 [2024-03-02 04:01:27] [query] Found results using: or logic [2024-03-02 04:01:27] [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-03-02 04:01:27] [query] Results: 141 Pages of results: 15 [2024-03-02 04:01:27] [query] Execution time: 0.03579 [2024-03-02 04:03:41] [indexer:background] Health check [2024-03-02 04:12:48] [index:background] Health check [2024-03-02 04:12:48] [indexer:background] Health check [2024-03-02 04:12:48] [indexer:background] Health check [2024-03-02 04:16:20] [index:background] Health check [2024-03-02 04:17:22] [indexer:background] Health check [2024-03-02 04:21:31] [index:background] Health check [2024-03-02 04:22:53] [indexer:background] Health check [2024-03-02 04:25:45] [index:background] Health check [2024-03-02 04:28:37] [indexer:background] Health check [2024-03-02 04:31:24] [index:background] Health check [2024-03-02 04:33:40] [indexer:background] Health check [2024-03-02 04:35:45] [index:background] Health check [2024-03-02 04:39:01] [indexer:background] Health check [2024-03-02 04:41:40] [index:background] Health check [2024-03-02 04:43:45] [indexer:background] Health check [2024-03-02 04:50:28] [index:background] Health check [2024-03-02 04:50:28] [indexer:background] Health check [2024-03-02 04:50:28] [indexer:background] Health check [2024-03-02 04:53:39] [index:background] Health check [2024-03-02 04:53:39] [indexer:background] Health check [2024-03-02 04:53:39] [indexer:background] Health check [2024-03-02 04:59:34] [index:background] Health check [2024-03-02 04:59:34] [indexer:background] Health check [2024-03-02 04:59:34] [indexer:background] Health check [2024-03-02 05:01:24] [index:background] Health check [2024-03-02 05:05:00] [indexer:background] Health check [2024-03-02 05:07:13] [index:background] Health check [2024-03-02 05:07:13] [indexer:background] Health check [2024-03-02 05:07:13] [indexer:background] Health check [2024-03-02 05:10:56] [index:background] Health check [2024-03-02 05:12:20] [indexer:background] Health check [2024-03-02 05:16:30] [index:background] Health check [2024-03-02 05:17:53] [indexer:background] Health check [2024-03-02 05:20:39] [index:background] Health check [2024-03-02 05:22:35] [indexer:background] Health check [2024-03-02 05:26:17] [index:background] Health check [2024-03-02 05:27:44] [indexer:background] Health check [2024-03-02 05:31:22] [index:background] Health check [2024-03-02 05:32:42] [indexer:background] Health check [2024-03-02 05:35:37] [index:background] Health check [2024-03-02 05:37:12] [indexer:background] Health check [2024-03-02 05:41:46] [index:background] Health check [2024-03-02 05:43:15] [indexer:background] Health check [2024-03-02 05:46:02] [index:background] Health check [2024-03-02 05:47:26] [indexer:background] Health check [2024-03-02 05:50:38] [index:background] Health check [2024-03-02 05:52:55] [indexer:background] Health check [2024-03-02 05:55:49] [index:background] Health check [2024-03-02 05:57:13] [indexer:background] Health check [2024-03-02 06:00:39] [index:background] Health check [2024-03-02 06:02:48] [indexer:background] Health check [2024-03-02 06:05:37] [index:background] Health check [2024-03-02 06:08:24] [indexer:background] Health check [2024-03-02 06:11:11] [index:background] Health check [2024-03-02 06:12:36] [indexer:background] Health check [2024-03-02 06:16:34] [index:background] Health check [2024-03-02 06:18:11] [indexer:background] Health check [2024-03-02 06:20:59] [index:background] Health check [2024-03-02 06:22:30] [indexer:background] Health check [2024-03-02 06:26:36] [index:background] Health check [2024-03-02 06:28:33] [indexer:background] Health check [2024-03-02 06:30:46] [index:background] Health check [2024-03-02 06:32:12] [indexer:background] Health check [2024-03-02 06:35:41] [index:background] Health check [2024-03-02 06:37:45] [indexer:background] Health check [2024-03-02 06:40:37] [index:background] Health check [2024-03-02 06:43:03] [indexer:background] Health check [2024-03-02 06:46:13] [index:background] Health check [2024-03-02 06:47:37] [indexer:background] Health check [2024-03-02 06:50:52] [index:background] Health check [2024-03-02 06:52:17] [indexer:background] Health check [2024-03-02 06:56:01] [index:background] Health check [2024-03-02 06:57:24] [indexer:background] Health check [2024-03-02 07:00:47] [index:background] Health check [2024-03-02 07:02:13] [indexer:background] Health check [2024-03-02 07:06:42] [index:background] Health check [2024-03-02 07:08:26] [indexer:background] Health check [2024-03-02 07:11:15] [index:background] Health check [2024-03-02 07:12:46] [indexer:background] Health check [2024-03-02 07:15:41] [index:background] Health check [2024-03-02 07:17:11] [indexer:background] Health check [2024-03-02 07:20:51] [index:background] Health check [2024-03-02 07:22:11] [indexer:background] Health check [2024-03-02 07:25:47] [index:background] Health check [2024-03-02 07:27:22] [indexer:background] Health check [2024-03-02 07:32:52] [index:background] Health check [2024-03-02 07:32:52] [indexer:background] Health check [2024-03-02 07:32:52] [indexer:background] Health check [2024-03-02 07:36:21] [index:background] Health check [2024-03-02 07:40:31] [indexer:background] Health check [2024-03-02 07:41:08] [index:background] Health check [2024-03-02 07:43:25] [indexer:background] Health check [2024-03-02 07:47:06] [index:background] Health check [2024-03-02 07:48:34] [indexer:background] Health check [2024-03-02 07:50:52] [index:background] Health check [2024-03-02 07:53:38] [indexer:background] Health check [2024-03-02 07:56:26] [index:background] Health check [2024-03-02 07:59:45] [indexer:background] Health check [2024-03-02 08:02:37] [index:background] Health check [2024-03-02 08:02:38] [indexer:background] Health check [2024-03-02 08:02:38] [indexer:background] Health check [2024-03-02 08:05:37] [index:background] Health check [2024-03-02 08:07:11] [indexer:background] Health check [2024-03-02 08:10:39] [index:background] Health check [2024-03-02 08:10:39] [index:background] CPU load threshold (3) breached: 6.44 [waiting 2] [2024-03-02 08:10:41] [indexer:background] CPU load threshold (3) breached: 6.44 [waiting 2] [2024-03-02 08:13:33] [indexer:background] Health check [2024-03-02 08:16:34] [index:background] Health check [2024-03-02 08:18:01] [indexer:background] Health check [2024-03-02 08:21:16] [index:background] Health check [2024-03-02 08:22:21] [indexer:background] Health check [2024-03-02 08:26:23] [index:background] Health check [2024-03-02 08:27:13] [indexer:background] Health check [2024-03-02 08:31:08] [index:background] Health check [2024-03-02 08:32:36] [indexer:background] Health check [2024-03-02 08:36:00] [index:background] Health check [2024-03-02 08:38:04] [indexer:background] Health check [2024-03-02 08:41:25] [index:background] Health check [2024-03-02 08:42:53] [indexer:background] Health check [2024-03-02 08:45:47] [index:background] Health check [2024-03-02 08:47:17] [indexer:background] Health check [2024-03-02 08:50:55] [index:background] Health check [2024-03-02 08:52:36] [indexer:background] Health check [2024-03-02 08:56:32] [index:background] Health check [2024-03-02 08:57:23] [indexer:background] Health check [2024-03-02 09:00:53] [index:background] Health check [2024-03-02 09:02:19] [indexer:background] Health check [2024-03-02 09:06:45] [index:background] Health check [2024-03-02 09:08:20] [indexer:background] Health check [2024-03-02 09:10:45] [index:background] Health check [2024-03-02 09:12:29] [indexer:background] Health check [2024-03-02 09:16:16] [index:background] Health check [2024-03-02 09:17:15] [indexer:background] Health check [2024-03-02 09:21:23] [index:background] Health check [2024-03-02 09:22:52] [indexer:background] Health check [2024-03-02 09:28:34] [index:background] Health check [2024-03-02 09:28:34] [indexer:background] Health check [2024-03-02 09:28:34] [indexer:background] Health check [2024-03-02 09:31:40] [index:background] Health check [2024-03-02 09:32:30] [indexer:background] Health check [2024-03-02 09:36:04] [index:background] Health check [2024-03-02 09:37:30] [indexer:background] Health check [2024-03-02 09:41:57] [index:background] Health check [2024-03-02 09:42:46] [indexer:background] Health check [2024-03-02 09:46:20] [index:background] Health check [2024-03-02 09:47:51] [indexer:background] Health check [2024-03-02 09:50:41] [index:background] Health check [2024-03-02 09:53:14] [indexer:background] Health check [2024-03-02 09:56:27] [index:background] Health check [2024-03-02 09:58:13] [indexer:background] Health check [2024-03-02 10:03:29] [index:background] Health check [2024-03-02 10:03:29] [indexer:background] Health check [2024-03-02 10:03:29] [indexer:background] Health check [2024-03-02 10:07:06] [index:background] Health check [2024-03-02 10:08:39] [indexer:background] Health check [2024-03-02 10:11:30] [index:background] Health check [2024-03-02 10:13:03] [indexer:background] Health check [2024-03-02 10:16:14] [index:background] Health check [2024-03-02 10:18:52] [indexer:background] Health check [2024-03-02 10:20:41] [index:background] Health check [2024-03-02 10:23:11] [indexer:background] Health check [2024-03-02 10:26:10] [index:background] Health check [2024-03-02 10:27:40] [indexer:background] Health check [2024-03-02 10:30:55] [index:background] Health check [2024-03-02 10:32:47] [indexer:background] Health check [2024-03-02 10:36:09] [index:background] Health check [2024-03-02 10:37:32] [indexer:background] Health check [2024-03-02 10:41:00] [index:background] Health check [2024-03-02 10:43:04] [indexer:background] Health check [2024-03-02 10:45:46] [index:background] Health check [2024-03-02 10:47:20] [indexer:background] Health check [2024-03-02 10:50:46] [index:background] Health check [2024-03-02 10:52:22] [indexer:background] Health check [2024-03-02 10:55:43] [index:background] Health check [2024-03-02 10:57:16] [indexer:background] Health check [2024-03-02 11:01:46] [index:background] Health check [2024-03-02 11:03:49] [indexer:background] Health check [2024-03-02 11:06:08] [index:background] Health check [2024-03-02 11:07:44] [indexer:background] Health check [2024-03-02 11:11:13] [index:background] Health check [2024-03-02 11:12:14] [indexer:background] Health check [2024-03-02 11:15:44] [index:background] Health check [2024-03-02 11:18:15] [indexer:background] Health check [2024-03-02 11:20:47] [index:background] Health check [2024-03-02 11:22:38] [indexer:background] Health check [2024-03-02 11:25:42] [index:background] Health check [2024-03-02 11:27:32] [indexer:background] Health check [2024-03-02 11:31:10] [index:background] Health check [2024-03-02 11:32:37] [indexer:background] Health check [2024-03-02 11:35:40] [index:background] Health check [2024-03-02 11:37:24] [indexer:background] Health check [2024-03-02 11:41:08] [index:background] Health check [2024-03-02 11:42:26] [indexer:background] Health check [2024-03-02 11:45:46] [index:background] Health check [2024-03-02 11:47:18] [indexer:background] Health check [2024-03-02 11:50:40] [index:background] Health check [2024-03-02 11:52:16] [indexer:background] Health check [2024-03-02 11:56:13] [index:background] Health check [2024-03-02 11:58:05] [indexer:background] Health check [2024-03-02 12:00:58] [index:background] Health check [2024-03-02 12:02:23] [indexer:background] Health check [2024-03-02 12:05:38] [index:background] Health check [2024-03-02 12:07:28] [indexer:background] Health check [2024-03-02 12:10:48] [index:background] Health check [2024-03-02 12:12:35] [indexer:background] Health check [2024-03-02 12:16:32] [index:background] Health check [2024-03-02 12:17:41] [indexer:background] Health check [2024-03-02 12:20:52] [index:background] Health check [2024-03-02 12:22:14] [indexer:background] Health check [2024-03-02 12:26:38] [index:background] Health check [2024-03-02 12:27:16] [indexer:background] Health check [2024-03-02 12:30:59] [index:background] Health check [2024-03-02 12:32:54] [indexer:background] Health check [2024-03-02 12:36:43] [index:background] Health check [2024-03-02 12:38:00] [indexer:background] Health check [2024-03-02 12:40:49] [index:background] Health check [2024-03-02 12:42:38] [indexer:background] Health check [2024-03-02 12:45:48] [index:background] Health check [2024-03-02 12:47:58] [indexer:background] Health check [2024-03-02 12:50:57] [index:background] Health check [2024-03-02 12:52:11] [indexer:background] Health check [2024-03-02 12:56:54] [index:background] Health check [2024-03-02 12:57:12] [indexer:background] Health check [2024-03-02 13:01:15] [index:background] Health check [2024-03-02 13:02:33] [indexer:background] Health check [2024-03-02 13:05:58] [index:background] Health check [2024-03-02 13:08:00] [indexer:background] Health check [2024-03-02 13:11:13] [index:background] Health check [2024-03-02 13:12:31] [indexer:background] Health check [2024-03-02 13:15:56] [index:background] Health check [2024-03-02 13:17:51] [indexer:background] Health check [2024-03-02 13:20:40] [index:background] Health check [2024-03-02 13:22:13] [indexer:background] Health check [2024-03-02 13:25:41] [index:background] Health check [2024-03-02 13:27:55] [indexer:background] Health check [2024-03-02 13:30:47] [index:background] Health check [2024-03-02 13:32:17] [indexer:background] Health check [2024-03-02 13:35:55] [index:background] Health check [2024-03-02 13:37:22] [indexer:background] Health check [2024-03-02 13:40:39] [index:background] Health check [2024-03-02 13:42:12] [indexer:background] Health check [2024-03-02 13:46:14] [index:background] Health check [2024-03-02 13:47:12] [indexer:background] Health check [2024-03-02 13:50:38] [index:background] Health check [2024-03-02 13:53:19] [indexer:background] Health check [2024-03-02 13:55:51] [index:background] Health check [2024-03-02 13:57:46] [indexer:background] Health check [2024-03-02 14:01:29] [index:background] Health check [2024-03-02 14:02:36] [indexer:background] Health check [2024-03-02 14:07:29] [index:background] Health check [2024-03-02 14:07:29] [indexer:background] Health check [2024-03-02 14:07:29] [indexer:background] Health check [2024-03-02 14:11:41] [index:background] Health check [2024-03-02 14:12:20] [indexer:background] Health check [2024-03-02 14:15:43] [index:background] Health check [2024-03-02 14:17:11] [indexer:background] Health check [2024-03-02 14:20:39] [index:background] Health check [2024-03-02 14:22:22] [indexer:background] Health check [2024-03-02 14:25:39] [index:background] Health check [2024-03-02 14:27:18] [indexer:background] Health check [2024-03-02 14:31:15] [index:background] Health check [2024-03-02 14:32:38] [indexer:background] Health check [2024-03-02 14:35:45] [index:background] Health check [2024-03-02 14:37:19] [indexer:background] Health check [2024-03-02 14:40:56] [index:background] Health check [2024-03-02 14:42:20] [indexer:background] Health check [2024-03-02 14:47:19] [index:background] Health check [2024-03-02 14:47:19] [indexer:background] Health check [2024-03-02 14:47:19] [indexer:background] Health check [2024-03-02 14:53:04] [index:background] Health check [2024-03-02 14:53:04] [indexer:background] Health check [2024-03-02 14:53:04] [indexer:background] Health check [2024-03-02 14:53:29] [query] Query for: 2025 [2024-03-02 14:53:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 14:53:29] [query] Engine: default [2024-03-02 14:53:30] [query] Tokens: 2025 [2024-03-02 14:53:30] [query] Mods: 6 [2024-03-02 14:53:30] [query] Found results using: or logic [2024-03-02 14:53: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 (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-03-02 14:53:30] [query] Results: 137 Pages of results: 14 [2024-03-02 14:53:30] [query] Execution time: 1.44704 [2024-03-02 14:55:36] [index:background] Health check [2024-03-02 14:57:40] [indexer:background] Health check [2024-03-02 15:01:12] [index:background] Health check [2024-03-02 15:03:00] [indexer:background] Health check [2024-03-02 15:05:56] [index:background] Health check [2024-03-02 15:07:20] [indexer:background] Health check [2024-03-02 15:10:53] [index:background] Health check [2024-03-02 15:12:12] [indexer:background] Health check [2024-03-02 15:16:01] [index:background] Health check [2024-03-02 15:17:23] [indexer:background] Health check [2024-03-02 15:21:19] [index:background] Health check [2024-03-02 15:22:36] [indexer:background] Health check [2024-03-02 15:25:38] [index:background] Health check [2024-03-02 15:27:48] [indexer:background] Health check [2024-03-02 15:30:50] [index:background] Health check [2024-03-02 15:33:29] [indexer:background] Health check [2024-03-02 15:35:53] [index:background] Health check [2024-03-02 15:36:00] [query] Query for: {search_term_string} [2024-03-02 15:36:00] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 15:36:00] [query] Engine: default [2024-03-02 15:36:00] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-02 15:36:00] [query] Mods: 6 [2024-03-02 15:36:00] [query] Using OR logic [2024-03-02 15:36:01] [query] Found results using: or logic [2024-03-02 15:36:01] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-03-02 15:36:01] [query] Results: 1356 Pages of results: 136 [2024-03-02 15:36:01] [query] Execution time: 1.16429 [2024-03-02 15:37:44] [indexer:background] Health check [2024-03-02 15:41:09] [index:background] Health check [2024-03-02 15:43:41] [query] Query for: {search_term_string} [2024-03-02 15:43:41] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 15:43:41] [query] Engine: default [2024-03-02 15:43:41] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-02 15:43:41] [query] Mods: 6 [2024-03-02 15:43:41] [query] Using OR logic [2024-03-02 15:43:41] [query] Found results using: or logic [2024-03-02 15:43: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 (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-03-02 15:43:41] [query] Results: 1356 Pages of results: 136 [2024-03-02 15:43:41] [query] Execution time: 0.04614 [2024-03-02 15:43:41] [indexer:background] Health check [2024-03-02 15:46:11] [index:background] Health check [2024-03-02 15:48:41] [indexer:background] Health check [2024-03-02 15:50:50] [index:background] Health check [2024-03-02 15:53:16] [indexer:background] Health check [2024-03-02 15:56:12] [index:background] Health check [2024-03-02 15:57:40] [indexer:background] Health check [2024-03-02 16:01:23] [index:background] Health check [2024-03-02 16:02:17] [indexer:background] Health check [2024-03-02 16:05:50] [index:background] Health check [2024-03-02 16:08:43] [indexer:background] Health check [2024-03-02 16:13:06] [index:background] Health check [2024-03-02 16:13:06] [indexer:background] Health check [2024-03-02 16:13:06] [indexer:background] Health check [2024-03-02 16:17:29] [index:background] Health check [2024-03-02 16:17:29] [indexer:background] Health check [2024-03-02 16:17:29] [indexer:background] Health check [2024-03-02 16:20:50] [index:background] Health check [2024-03-02 16:22:31] [indexer:background] Health check [2024-03-02 16:25:54] [index:background] Health check [2024-03-02 16:27:34] [indexer:background] Health check [2024-03-02 16:30:48] [index:background] Health check [2024-03-02 16:34:04] [indexer:background] Health check [2024-03-02 16:35:52] [index:background] Health check [2024-03-02 16:37:12] [indexer:background] Health check [2024-03-02 16:41:04] [index:background] Health check [2024-03-02 16:42:22] [indexer:background] Health check [2024-03-02 16:47:35] [index:background] Health check [2024-03-02 16:47:35] [indexer:background] Health check [2024-03-02 16:47:35] [indexer:background] Health check [2024-03-02 16:49:42] [query] Query for: hôtellerie et tourisme culture arts [2024-03-02 16:49:42] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 16:49:42] [query] Engine: default [2024-03-02 16:49:42] [query] Tokens: arts, culture, cultures, cultura, hotellerie, tourisme, tourism, cultur, art [2024-03-02 16:49:42] [query] Mods: 6 [2024-03-02 16:49:42] [query] Trying AND logic [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Query for: hôtellerie et tourisme culture arts [2024-03-02 16:49:42] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-02 16:49:42] [query] Engine: default [2024-03-02 16:49:42] [query] Tokens: arts, culture, cultures, cultura, hotellerie, tourisme, tourism, cultur, art [2024-03-02 16:49:42] [query] Mods: 6 [2024-03-02 16:49:42] [query] Trying AND logic [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:42] [query] Skipping AND logic Source Attribute consideration (single Engine) [2024-03-02 16:49:44] [query] Found results using: and logic [2024-03-02 16:49:44] [query] Found results using: and logic [2024-03-02 16:49:44] [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 (23594,3693,5873,478347,4142,4709,47755,736715,4694) 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' ) ) ))) AND s.id IN ( SELECT id FROM ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (3693, 5873, 478347, 736715) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (4142) GROUP BY id) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (4694, 23594) GROUP BY id) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (4709, 47755) GROUP BY id) GROUP BY id) AS a) 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-03-02 16:49:44] [query] Results: 213 Pages of results: 22 [2024-03-02 16:49:44] [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 (23594,3693,5873,478347,4142,4709,47755,736715,4694) 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' ) ) ))) AND s.id IN ( SELECT id FROM ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (3693, 5873, 478347, 736715) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (4142) GROUP BY id) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (4694, 23594) GROUP BY id) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (4709, 47755) GROUP BY id) GROUP BY id) AS a) 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-03-02 16:49:44] [query] Results: 213 Pages of results: 22 [2024-03-02 16:49:44] [query] Execution time: 2.20316 [2024-03-02 16:49:44] [query] Execution time: 2.79355 [2024-03-02 16:50:36] [index:background] Health check [2024-03-02 16:52:43] [indexer:background] Health check [2024-03-02 16:55:44] [index:background] Health check [2024-03-02 16:57:29] [indexer:background] Health check [2024-03-02 17:00:45] [index:background] Health check [2024-03-02 17:02:47] [indexer:background] Health check [2024-03-02 17:06:24] [index:background] Health check [2024-03-02 17:07:17] [indexer:background] Health check [2024-03-02 17:11:08] [index:background] Health check [2024-03-02 17:12:57] [indexer:background] Health check [2024-03-02 17:15:40] [index:background] Health check [2024-03-02 17:17:17] [indexer:background] Health check [2024-03-02 17:20:45] [index:background] Health check [2024-03-02 17:23:14] [indexer:background] Health check [2024-03-02 17:26:53] [index:background] Health check [2024-03-02 17:27:15] [indexer:background] Health check [2024-03-02 17:30:43] [index:background] Health check [2024-03-02 17:32:15] [indexer:background] Health check [2024-03-02 17:35:47] [index:background] Health check [2024-03-02 17:37:14] [indexer:background] Health check [2024-03-02 17:42:35] [index:background] Health check [2024-03-02 17:42:35] [indexer:background] Health check [2024-03-02 17:42:35] [indexer:background] Health check [2024-03-02 17:46:00] [index:background] Health check [2024-03-02 17:47:30] [indexer:background] Health check [2024-03-02 17:51:12] [index:background] Health check [2024-03-02 17:52:45] [indexer:background] Health check [2024-03-02 17:55:36] [index:background] Health check [2024-03-02 17:57:16] [indexer:background] Health check [2024-03-02 18:01:21] [index:background] Health check [2024-03-02 18:02:52] [indexer:background] Health check [2024-03-02 18:05:41] [index:background] Health check [2024-03-02 18:07:22] [indexer:background] Health check [2024-03-02 18:10:37] [index:background] Health check [2024-03-02 18:14:01] [indexer:background] Health check [2024-03-02 18:15:38] [index:background] Health check [2024-03-02 18:17:15] [indexer:background] Health check [2024-03-02 18:20:52] [index:background] Health check [2024-03-02 18:22:44] [indexer:background] Health check [2024-03-02 18:25:48] [index:background] Health check [2024-03-02 18:27:12] [indexer:background] Health check [2024-03-02 18:30:49] [index:background] Health check [2024-03-02 18:33:00] [indexer:background] Health check [2024-03-02 18:36:20] [index:background] Health check [2024-03-02 18:37:16] [indexer:background] Health check [2024-03-02 18:40:49] [index:background] Health check [2024-03-02 18:42:28] [indexer:background] Health check [2024-03-02 18:45:54] [index:background] Health check [2024-03-02 18:47:18] [indexer:background] Health check [2024-03-02 18:50:37] [index:background] Health check [2024-03-02 18:53:10] [indexer:background] Health check [2024-03-02 18:55:36] [index:background] Health check [2024-03-02 18:57:22] [indexer:background] Health check [2024-03-02 19:00:44] [index:background] Health check [2024-03-02 19:02:29] [indexer:background] Health check [2024-03-02 19:06:12] [index:background] Health check [2024-03-02 19:07:16] [indexer:background] Health check [2024-03-02 19:11:09] [index:background] Health check [2024-03-02 19:12:25] [indexer:background] Health check [2024-03-02 19:15:41] [index:background] Health check [2024-03-02 19:17:14] [indexer:background] Health check [2024-03-02 19:20:42] [index:background] Health check [2024-03-02 19:23:13] [indexer:background] Health check [2024-03-02 19:25:55] [index:background] Health check [2024-03-02 19:29:39] [indexer:background] Health check [2024-03-02 19:31:37] [index:background] Health check [2024-03-02 19:32:19] [indexer:background] Health check [2024-03-02 19:37:36] [index:background] Health check [2024-03-02 19:37:36] [indexer:background] Health check [2024-03-02 19:37:37] [indexer:background] Health check [2024-03-02 19:41:27] [index:background] Health check [2024-03-02 19:42:40] [indexer:background] Health check [2024-03-02 19:48:57] [index:background] Health check [2024-03-02 19:48:57] [indexer:background] Health check [2024-03-02 19:48:57] [indexer:background] Health check [2024-03-02 19:51:13] [index:background] Health check [2024-03-02 19:52:24] [indexer:background] Health check [2024-03-02 19:55:40] [index:background] Health check [2024-03-02 19:58:18] [indexer:background] Health check [2024-03-02 20:00:43] [index:background] Health check [2024-03-02 20:02:58] [indexer:background] Health check [2024-03-02 20:05:41] [index:background] Health check [2024-03-02 20:07:33] [indexer:background] Health check [2024-03-02 20:11:02] [index:background] Health check [2024-03-02 20:13:09] [indexer:background] Health check [2024-03-02 20:16:46] [index:background] Health check [2024-03-02 20:18:19] [indexer:background] Health check [2024-03-02 20:21:19] [index:background] Health check [2024-03-02 20:22:14] [indexer:background] Health check [2024-03-02 20:26:58] [index:background] Health check [2024-03-02 20:28:23] [indexer:background] Health check [2024-03-02 20:30:51] [index:background] Health check [2024-03-02 20:35:08] [indexer:background] Health check [2024-03-02 20:36:47] [index:background] Health check [2024-03-02 20:37:25] [indexer:background] Health check [2024-03-02 20:41:04] [index:background] Health check [2024-03-02 20:42:27] [indexer:background] Health check [2024-03-02 20:45:38] [index:background] Health check [2024-03-02 20:47:30] [indexer:background] Health check [2024-03-02 20:51:37] [index:background] Health check [2024-03-02 20:52:42] [indexer:background] Health check [2024-03-02 20:56:27] [index:background] Health check [2024-03-02 20:59:34] [indexer:background] Health check [2024-03-02 21:00:48] [index:background] Health check [2024-03-02 21:02:29] [indexer:background] Health check [2024-03-02 21:05:56] [index:background] Health check [2024-03-02 21:07:57] [indexer:background] Health check [2024-03-02 21:11:11] [index:background] Health check [2024-03-02 21:13:15] [indexer:background] Health check [2024-03-02 21:17:35] [index:background] Health check [2024-03-02 21:17:36] [indexer:background] Health check [2024-03-02 21:17:36] [indexer:background] Health check [2024-03-02 21:21:33] [index:background] Health check [2024-03-02 21:22:33] [indexer:background] Health check [2024-03-02 21:25:39] [index:background] Health check [2024-03-02 21:27:52] [indexer:background] Health check [2024-03-02 21:30:42] [index:background] Health check [2024-03-02 21:33:07] [indexer:background] Health check [2024-03-02 21:36:59] [index:background] Health check [2024-03-02 21:37:59] [indexer:background] Health check [2024-03-02 21:40:47] [index:background] Health check [2024-03-02 21:43:00] [indexer:background] Health check [2024-03-02 21:45:55] [index:background] Health check [2024-03-02 21:47:46] [indexer:background] Health check [2024-03-02 21:51:47] [index:background] Health check [2024-03-02 21:52:24] [indexer:background] Health check [2024-03-02 21:56:28] [index:background] Health check [2024-03-02 21:57:12] [indexer:background] Health check [2024-03-02 22:01:33] [index:background] Health check [2024-03-02 22:04:00] [indexer:background] Health check [2024-03-02 22:07:01] [index:background] Health check [2024-03-02 22:09:29] [indexer:background] Health check [2024-03-02 22:10:51] [index:background] Health check [2024-03-02 22:13:05] [indexer:background] Health check [2024-03-02 22:15:37] [index:background] Health check [2024-03-02 22:17:43] [indexer:background] Health check [2024-03-02 22:20:38] [index:background] Health check [2024-03-02 22:22:48] [indexer:background] Health check [2024-03-02 22:25:46] [index:background] Health check [2024-03-02 22:27:31] [indexer:background] Health check [2024-03-02 22:31:08] [index:background] Health check [2024-03-02 22:32:26] [indexer:background] Health check [2024-03-02 22:35:37] [index:background] Health check [2024-03-02 22:37:15] [indexer:background] Health check [2024-03-02 22:41:45] [index:background] Health check [2024-03-02 22:44:03] [indexer:background] Health check [2024-03-02 22:45:47] [index:background] Health check [2024-03-02 22:47:32] [indexer:background] Health check [2024-03-02 22:50:49] [index:background] Health check [2024-03-02 22:52:40] [indexer:background] Health check [2024-03-02 22:55:38] [index:background] Health check [2024-03-02 22:57:30] [indexer:background] Health check [2024-03-02 23:01:14] [index:background] Health check [2024-03-02 23:02:30] [indexer:background] Health check [2024-03-02 23:06:06] [index:background] Health check [2024-03-02 23:07:30] [indexer:background] Health check