[2023-10-06 00:02:26] [indexer:background] Health check [2023-10-06 00:02:26] [index:background] Health check [2023-10-06 00:07:31] [indexer:background] Health check [2023-10-06 00:07:31] [index:background] Health check [2023-10-06 00:11:41] [indexer:background] Health check [2023-10-06 00:12:21] [index:background] Health check [2023-10-06 00:17:06] [indexer:background] Health check [2023-10-06 00:18:01] [index:background] Health check [2023-10-06 00:21:51] [indexer:background] Health check [2023-10-06 00:22:22] [index:background] Health check [2023-10-06 00:27:23] [indexer:background] Health check [2023-10-06 00:27:23] [index:background] Health check [2023-10-06 00:32:23] [indexer:background] Health check [2023-10-06 00:32:25] [index:background] Health check [2023-10-06 00:37:03] [indexer:background] Health check [2023-10-06 00:37:25] [index:background] Health check [2023-10-06 00:42:12] [indexer:background] Health check [2023-10-06 00:42:12] [index:background] Health check [2023-10-06 00:46:51] [indexer:background] Health check [2023-10-06 00:47:11] [index:background] Health check [2023-10-06 00:53:41] [indexer:background] Health check [2023-10-06 00:53:42] [index:background] Health check [2023-10-06 00:55:19] [query] Query for: 2023 [2023-10-06 00:55:19] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 00:55:19] [query] Engine: default [2023-10-06 00:55:20] [query] Tokens: 2023 [2023-10-06 00:55:20] [query] Mods: 6 [2023-10-06 00:55:20] [query] Found results using: or logic [2023-10-06 00:55:20] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 [2023-10-06 00:55:20] [query] Results: 245 Pages of results: 25 [2023-10-06 00:55:20] [query] Execution time: 0.78893 [2023-10-06 00:58:39] [indexer:background] Health check [2023-10-06 00:58:39] [index:background] Health check [2023-10-06 01:03:22] [indexer:background] Health check [2023-10-06 01:03:22] [index:background] Health check [2023-10-06 01:07:43] [indexer:background] Health check [2023-10-06 01:07:43] [index:background] Health check [2023-10-06 01:11:42] [indexer:background] Health check [2023-10-06 01:13:09] [index:background] Health check [2023-10-06 01:16:56] [indexer:background] Health check [2023-10-06 01:17:14] [index:background] Health check [2023-10-06 01:22:41] [indexer:background] Health check [2023-10-06 01:22:41] [index:background] Health check [2023-10-06 01:27:50] [indexer:background] Health check [2023-10-06 01:27:50] [index:background] Health check [2023-10-06 01:34:05] [indexer:background] Health check [2023-10-06 01:34:05] [index:background] Health check [2023-10-06 01:36:50] [indexer:background] Health check [2023-10-06 01:38:19] [index:background] Health check [2023-10-06 01:42:20] [indexer:background] Health check [2023-10-06 01:42:20] [index:background] Health check [2023-10-06 01:47:54] [indexer:background] Health check [2023-10-06 01:47:54] [index:background] Health check [2023-10-06 01:52:18] [indexer:background] Health check [2023-10-06 01:52:18] [index:background] Health check [2023-10-06 01:57:55] [indexer:background] Health check [2023-10-06 01:57:59] [index:background] Health check [2023-10-06 02:01:55] [indexer:background] Health check [2023-10-06 02:03:19] [index:background] Health check [2023-10-06 02:06:52] [indexer:background] Health check [2023-10-06 02:07:32] [index:background] Health check [2023-10-06 02:11:40] [indexer:background] Health check [2023-10-06 02:16:01] [index:background] Health check [2023-10-06 02:17:36] [indexer:background] Health check [2023-10-06 02:17:36] [index:background] Health check [2023-10-06 02:23:41] [indexer:background] Health check [2023-10-06 02:23:41] [index:background] Health check [2023-10-06 02:26:50] [indexer:background] Health check [2023-10-06 02:27:50] [index:background] Health check [2023-10-06 02:31:45] [indexer:background] Health check [2023-10-06 02:32:13] [index:background] Health check [2023-10-06 02:36:48] [indexer:background] Health check [2023-10-06 02:36:48] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-10-06 02:37:28] [index:background] Health check [2023-10-06 02:43:38] [indexer:background] Health check [2023-10-06 02:43:41] [index:background] Health check [2023-10-06 02:47:11] [indexer:background] Health check [2023-10-06 02:47:11] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2] [2023-10-06 02:47:14] [index:background] Health check [2023-10-06 02:47:14] [index:background] CPU load threshold (3) breached: 3.53 [waiting 2] [2023-10-06 02:47:16] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2] [2023-10-06 02:51:54] [indexer:background] Health check [2023-10-06 02:51:54] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-06 02:55:41] [index:background] Health check [2023-10-06 02:55:41] [index:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-10-06 02:55:43] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-10-06 02:56:40] [indexer:background] Health check [2023-10-06 02:56:40] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-10-06 02:59:34] [index:background] Health check [2023-10-06 02:59:34] [index:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2023-10-06 02:59:36] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-10-06 03:02:22] [indexer:background] Health check [2023-10-06 03:02:22] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2] [2023-10-06 03:02:24] [index:background] Health check [2023-10-06 03:02:24] [index:background] CPU load threshold (3) breached: 3.54 [waiting 2] [2023-10-06 03:02:26] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2] [2023-10-06 03:08:27] [indexer:background] Health check [2023-10-06 03:08:27] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-06 03:08:30] [index:background] Health check [2023-10-06 03:08:30] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-10-06 03:08:32] [indexer:background] CPU load threshold (3) breached: 3.83 [waiting 2] [2023-10-06 03:11:47] [indexer:background] Health check [2023-10-06 03:11:47] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2] [2023-10-06 03:12:45] [index:background] Health check [2023-10-06 03:12:45] [index:background] CPU load threshold (3) breached: 3.41 [waiting 2] [2023-10-06 03:12:47] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2023-10-06 03:16:44] [indexer:background] Health check [2023-10-06 03:16:44] [indexer:background] CPU load threshold (3) breached: 4.58 [waiting 2] [2023-10-06 03:17:16] [index:background] Health check [2023-10-06 03:17:16] [index:background] CPU load threshold (3) breached: 4.78 [waiting 2] [2023-10-06 03:17:18] [indexer:background] CPU load threshold (3) breached: 4.78 [waiting 2] [2023-10-06 03:21:42] [indexer:background] Health check [2023-10-06 03:21:42] [indexer:background] CPU load threshold (3) breached: 4.32 [waiting 2] [2023-10-06 03:22:14] [index:background] Health check [2023-10-06 03:22:14] [index:background] CPU load threshold (3) breached: 4.45 [waiting 2] [2023-10-06 03:22:16] [indexer:background] CPU load threshold (3) breached: 4.45 [waiting 2] [2023-10-06 03:26:42] [indexer:background] Health check [2023-10-06 03:26:42] [indexer:background] CPU load threshold (3) breached: 4.04 [waiting 2] [2023-10-06 03:27:12] [index:background] Health check [2023-10-06 03:27:12] [index:background] CPU load threshold (3) breached: 4.42 [waiting 2] [2023-10-06 03:27:14] [indexer:background] CPU load threshold (3) breached: 4.42 [waiting 2] [2023-10-06 03:31:42] [indexer:background] Health check [2023-10-06 03:31:42] [indexer:background] CPU load threshold (3) breached: 4.65 [waiting 2] [2023-10-06 03:32:12] [index:background] Health check [2023-10-06 03:32:12] [index:background] CPU load threshold (3) breached: 5.09 [waiting 2] [2023-10-06 03:32:14] [indexer:background] CPU load threshold (3) breached: 5.08 [waiting 2] [2023-10-06 03:36:41] [indexer:background] Health check [2023-10-06 03:36:41] [indexer:background] CPU load threshold (3) breached: 4.63 [waiting 2] [2023-10-06 03:37:12] [index:background] Health check [2023-10-06 03:37:12] [index:background] CPU load threshold (3) breached: 4.87 [waiting 2] [2023-10-06 03:37:14] [indexer:background] CPU load threshold (3) breached: 4.88 [waiting 2] [2023-10-06 03:42:25] [indexer:background] Health check [2023-10-06 03:42:25] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2] [2023-10-06 03:42:27] [index:background] Health check [2023-10-06 03:42:27] [index:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2023-10-06 03:42:30] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2023-10-06 03:47:14] [indexer:background] Health check [2023-10-06 03:47:14] [index:background] Health check [2023-10-06 03:53:44] [indexer:background] Health check [2023-10-06 03:53:44] [index:background] Health check [2023-10-06 03:58:41] [indexer:background] Health check [2023-10-06 03:58:41] [index:background] Health check [2023-10-06 04:01:56] [indexer:background] Health check [2023-10-06 04:02:48] [index:background] Health check [2023-10-06 04:07:23] [indexer:background] Health check [2023-10-06 04:07:23] [index:background] Health check [2023-10-06 04:12:30] [indexer:background] Health check [2023-10-06 04:12:30] [index:background] Health check [2023-10-06 04:16:56] [indexer:background] Health check [2023-10-06 04:17:14] [index:background] Health check [2023-10-06 04:21:42] [indexer:background] Health check [2023-10-06 04:22:14] [index:background] Health check [2023-10-06 04:29:45] [indexer:background] Health check [2023-10-06 04:29:45] [index:background] Health check [2023-10-06 04:32:12] [indexer:background] Health check [2023-10-06 04:32:12] [index:background] Health check [2023-10-06 04:36:48] [indexer:background] Health check [2023-10-06 04:38:44] [index:background] Health check [2023-10-06 04:41:40] [indexer:background] Health check [2023-10-06 04:42:12] [index:background] Health check [2023-10-06 04:46:41] [indexer:background] Health check [2023-10-06 04:47:11] [index:background] Health check [2023-10-06 04:51:40] [indexer:background] Health check [2023-10-06 04:52:11] [index:background] Health check [2023-10-06 04:56:41] [indexer:background] Health check [2023-10-06 04:57:11] [index:background] Health check [2023-10-06 05:02:00] [indexer:background] Health check [2023-10-06 05:02:00] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-10-06 05:02:14] [index:background] Health check [2023-10-06 05:02:14] [index:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2023-10-06 05:02:16] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2023-10-06 05:06:41] [indexer:background] Health check [2023-10-06 05:07:12] [index:background] Health check [2023-10-06 05:11:41] [indexer:background] Health check [2023-10-06 05:12:11] [index:background] Health check [2023-10-06 05:16:41] [indexer:background] Health check [2023-10-06 05:17:11] [index:background] Health check [2023-10-06 05:21:41] [indexer:background] Health check [2023-10-06 05:22:17] [index:background] Health check [2023-10-06 05:27:48] [indexer:background] Health check [2023-10-06 05:27:48] [index:background] Health check [2023-10-06 05:32:03] [indexer:background] Health check [2023-10-06 05:33:32] [index:background] Health check [2023-10-06 05:37:08] [indexer:background] Health check [2023-10-06 05:38:25] [index:background] Health check [2023-10-06 05:42:06] [indexer:background] Health check [2023-10-06 05:42:20] [index:background] Health check [2023-10-06 05:48:47] [indexer:background] Health check [2023-10-06 05:48:47] [index:background] Health check [2023-10-06 05:51:47] [indexer:background] Health check [2023-10-06 05:52:42] [index:background] Health check [2023-10-06 05:57:00] [indexer:background] Health check [2023-10-06 05:57:12] [index:background] Health check [2023-10-06 06:01:55] [indexer:background] Health check [2023-10-06 06:03:45] [index:background] Health check [2023-10-06 06:06:53] [indexer:background] Health check [2023-10-06 06:08:31] [index:background] Health check [2023-10-06 06:12:17] [indexer:background] Health check [2023-10-06 06:12:17] [index:background] Health check [2023-10-06 06:17:21] [indexer:background] Health check [2023-10-06 06:17:21] [index:background] Health check [2023-10-06 06:21:51] [indexer:background] Health check [2023-10-06 06:22:27] [index:background] Health check [2023-10-06 06:26:44] [indexer:background] Health check [2023-10-06 06:27:19] [index:background] Health check [2023-10-06 06:29:12] [query] Query for: drou.cn [2023-10-06 06:29:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 06:29:12] [query] Query for: drou.cn [2023-10-06 06:29:12] [query] Engine: default [2023-10-06 06:29:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 06:29:12] [query] Engine: default [2023-10-06 06:29:12] [query] Tokens: drou drou.cn [2023-10-06 06:29:12] [query] Tokens: drou drou.cn [2023-10-06 06:29:12] [query] Mods: 6 [2023-10-06 06:29:12] [query] Mods: 6 [2023-10-06 06:29:12] [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 (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 [2023-10-06 06:29:12] [query] Results: 0 Pages of results: 0 [2023-10-06 06:29:12] [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 (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 [2023-10-06 06:29:12] [query] Results: 0 Pages of results: 0 [2023-10-06 06:29:12] [query] Execution time: 0.30734 [2023-10-06 06:29:12] [query] Execution time: 0.30840 [2023-10-06 06:31:43] [indexer:background] Health check [2023-10-06 06:32:17] [index:background] Health check [2023-10-06 06:37:32] [indexer:background] Health check [2023-10-06 06:37:32] [index:background] Health check [2023-10-06 06:42:40] [indexer:background] Health check [2023-10-06 06:42:40] [index:background] Health check [2023-10-06 06:46:59] [indexer:background] Health check [2023-10-06 06:47:30] [index:background] Health check [2023-10-06 06:52:52] [indexer:background] Health check [2023-10-06 06:52:52] [index:background] Health check [2023-10-06 06:58:30] [indexer:background] Health check [2023-10-06 06:58:30] [index:background] Health check [2023-10-06 07:03:06] [indexer:background] Health check [2023-10-06 07:03:06] [index:background] Health check [2023-10-06 07:06:43] [indexer:background] Health check [2023-10-06 07:07:16] [index:background] Health check [2023-10-06 07:11:43] [indexer:background] Health check [2023-10-06 07:12:15] [index:background] Health check [2023-10-06 07:16:59] [indexer:background] Health check [2023-10-06 07:17:58] [index:background] Health check [2023-10-06 07:22:30] [indexer:background] Health check [2023-10-06 07:22:30] [index:background] Health check [2023-10-06 07:27:37] [indexer:background] Health check [2023-10-06 07:27:38] [index:background] Health check [2023-10-06 07:32:52] [indexer:background] Health check [2023-10-06 07:32:52] [index:background] Health check [2023-10-06 07:36:57] [indexer:background] Health check [2023-10-06 07:37:31] [index:background] Health check [2023-10-06 07:41:50] [indexer:background] Health check [2023-10-06 07:42:27] [index:background] Health check [2023-10-06 07:47:12] [indexer:background] Health check [2023-10-06 07:47:12] [index:background] Health check [2023-10-06 07:52:27] [indexer:background] Health check [2023-10-06 07:52:27] [index:background] Health check [2023-10-06 07:57:09] [indexer:background] Health check [2023-10-06 07:57:51] [index:background] Health check [2023-10-06 08:01:59] [indexer:background] Health check [2023-10-06 08:02:15] [index:background] Health check [2023-10-06 08:02:15] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-10-06 08:07:07] [indexer:background] Health check [2023-10-06 08:07:07] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-06 08:08:10] [index:background] Health check [2023-10-06 08:11:46] [indexer:background] Health check [2023-10-06 08:13:18] [index:background] Health check [2023-10-06 08:13:18] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-10-06 08:13:20] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-10-06 08:16:49] [indexer:background] Health check [2023-10-06 08:17:49] [index:background] Health check [2023-10-06 08:23:27] [indexer:background] Health check [2023-10-06 08:23:27] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-06 08:23:29] [index:background] Health check [2023-10-06 08:23:29] [index:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-10-06 08:23:31] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2023-10-06 08:27:10] [indexer:background] Health check [2023-10-06 08:27:10] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2] [2023-10-06 08:27:12] [index:background] Health check [2023-10-06 08:27:12] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-10-06 08:27:14] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-10-06 08:32:33] [indexer:background] Health check [2023-10-06 08:32:33] [index:background] Health check [2023-10-06 08:36:49] [indexer:background] Health check [2023-10-06 08:37:17] [index:background] Health check [2023-10-06 08:42:08] [indexer:background] Health check [2023-10-06 08:42:27] [index:background] Health check [2023-10-06 08:47:21] [indexer:background] Health check [2023-10-06 08:47:21] [index:background] Health check [2023-10-06 08:52:50] [indexer:background] Health check [2023-10-06 08:52:50] [index:background] Health check [2023-10-06 08:57:05] [indexer:background] Health check [2023-10-06 08:57:05] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2] [2023-10-06 08:57:41] [index:background] Health check [2023-10-06 09:02:08] [indexer:background] Health check [2023-10-06 09:02:08] [indexer:background] CPU load threshold (3) breached: 3.7 [waiting 2] [2023-10-06 09:02:14] [index:background] Health check [2023-10-06 09:02:14] [index:background] CPU load threshold (3) breached: 3.88 [waiting 2] [2023-10-06 09:02:16] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2] [2023-10-06 09:07:56] [indexer:background] Health check [2023-10-06 09:07:59] [index:background] Health check [2023-10-06 09:12:02] [indexer:background] Health check [2023-10-06 09:12:53] [index:background] Health check [2023-10-06 09:16:40] [indexer:background] Health check [2023-10-06 09:17:49] [index:background] Health check [2023-10-06 09:17:49] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-10-06 09:17:51] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-10-06 09:21:56] [indexer:background] Health check [2023-10-06 09:22:15] [index:background] Health check [2023-10-06 09:26:46] [indexer:background] Health check [2023-10-06 09:27:26] [index:background] Health check [2023-10-06 09:31:44] [indexer:background] Health check [2023-10-06 09:32:18] [index:background] Health check [2023-10-06 09:36:48] [indexer:background] Health check [2023-10-06 09:37:34] [index:background] Health check [2023-10-06 09:37:34] [index:background] CPU load threshold (3) breached: 3.88 [waiting 2] [2023-10-06 09:37:36] [indexer:background] CPU load threshold (3) breached: 3.81 [waiting 2] [2023-10-06 09:43:09] [indexer:background] Health check [2023-10-06 09:43:09] [index:background] Health check [2023-10-06 09:48:08] [indexer:background] Health check [2023-10-06 09:48:09] [index:background] Health check [2023-10-06 09:52:02] [indexer:background] Health check [2023-10-06 09:53:51] [index:background] Health check [2023-10-06 09:56:44] [indexer:background] Health check [2023-10-06 09:56:44] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2] [2023-10-06 09:57:18] [index:background] Health check [2023-10-06 09:57:18] [index:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-10-06 09:57:20] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-10-06 10:02:25] [indexer:background] Health check [2023-10-06 10:02:25] [index:background] Health check [2023-10-06 10:07:17] [indexer:background] Health check [2023-10-06 10:07:17] [index:background] Health check [2023-10-06 10:12:38] [indexer:background] Health check [2023-10-06 10:12:38] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2] [2023-10-06 10:12:40] [index:background] Health check [2023-10-06 10:12:40] [index:background] CPU load threshold (3) breached: 3.54 [waiting 2] [2023-10-06 10:12:42] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2] [2023-10-06 10:16:57] [indexer:background] Health check [2023-10-06 10:17:24] [index:background] Health check [2023-10-06 10:22:16] [indexer:background] Health check [2023-10-06 10:22:16] [index:background] Health check [2023-10-06 10:26:45] [indexer:background] Health check [2023-10-06 10:27:17] [index:background] Health check [2023-10-06 10:27:17] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-06 10:27:19] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-06 10:31:53] [indexer:background] Health check [2023-10-06 10:32:19] [index:background] Health check [2023-10-06 10:37:35] [indexer:background] Health check [2023-10-06 10:37:35] [index:background] Health check [2023-10-06 10:42:58] [indexer:background] Health check [2023-10-06 10:42:58] [index:background] Health check [2023-10-06 10:49:28] [indexer:background] Health check [2023-10-06 10:49:29] [index:background] Health check [2023-10-06 10:52:25] [indexer:background] Health check [2023-10-06 10:52:25] [index:background] Health check [2023-10-06 10:57:15] [indexer:background] Health check [2023-10-06 10:57:15] [index:background] Health check [2023-10-06 11:02:43] [indexer:background] Health check [2023-10-06 11:02:43] [index:background] Health check [2023-10-06 11:07:08] [indexer:background] Health check [2023-10-06 11:08:58] [index:background] Health check [2023-10-06 11:11:48] [indexer:background] Health check [2023-10-06 11:13:23] [index:background] Health check [2023-10-06 11:17:31] [indexer:background] Health check [2023-10-06 11:17:31] [index:background] Health check [2023-10-06 11:21:45] [indexer:background] Health check [2023-10-06 11:22:17] [index:background] Health check [2023-10-06 11:27:36] [indexer:background] Health check [2023-10-06 11:27:36] [index:background] Health check [2023-10-06 11:31:58] [indexer:background] Health check [2023-10-06 11:32:48] [index:background] Health check [2023-10-06 11:36:56] [indexer:background] Health check [2023-10-06 11:37:17] [index:background] Health check [2023-10-06 11:42:11] [indexer:background] Health check [2023-10-06 11:42:11] [index:background] Health check [2023-10-06 11:47:03] [indexer:background] Health check [2023-10-06 11:47:11] [index:background] Health check [2023-10-06 11:51:56] [indexer:background] Health check [2023-10-06 11:53:12] [index:background] Health check [2023-10-06 11:56:49] [indexer:background] Health check [2023-10-06 11:57:35] [index:background] Health check [2023-10-06 12:02:40] [indexer:background] Health check [2023-10-06 12:02:40] [index:background] Health check [2023-10-06 12:06:44] [indexer:background] Health check [2023-10-06 12:07:18] [index:background] Health check [2023-10-06 12:12:58] [indexer:background] Health check [2023-10-06 12:12:58] [index:background] Health check [2023-10-06 12:16:39] [indexer:background] Health check [2023-10-06 12:18:58] [index:background] Health check [2023-10-06 12:23:18] [indexer:background] Health check [2023-10-06 12:23:18] [index:background] Health check [2023-10-06 12:27:01] [indexer:background] Health check [2023-10-06 12:27:29] [index:background] Health check [2023-10-06 12:31:46] [indexer:background] Health check [2023-10-06 12:32:48] [index:background] Health check [2023-10-06 12:36:48] [indexer:background] Health check [2023-10-06 12:37:14] [index:background] Health check [2023-10-06 12:37:14] [index:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-06 12:37:16] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-06 12:41:59] [indexer:background] Health check [2023-10-06 12:43:37] [index:background] Health check [2023-10-06 12:45:17] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125 [2023-10-06 12:45:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 12:45:17] [query] Engine: default [2023-10-06 12:45:18] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill [2023-10-06 12:45:18] [query] Mods: 6 [2023-10-06 12:45:18] [query] Using OR logic [2023-10-06 12:45:19] [query] Found results using: or logic [2023-10-06 12:45:19] [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 (20886,13853,27861,45186,333334,8840,4915,69784,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 [2023-10-06 12:45:19] [query] Results: 891 Pages of results: 90 [2023-10-06 12:45:19] [query] Execution time: 1.79943 [2023-10-06 12:49:55] [indexer:background] Health check [2023-10-06 12:49:55] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-06 12:49:57] [index:background] Health check [2023-10-06 12:49:57] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-10-06 12:49:59] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2] [2023-10-06 12:51:43] [indexer:background] Health check [2023-10-06 12:52:47] [index:background] Health check [2023-10-06 12:56:45] [indexer:background] Health check [2023-10-06 12:57:42] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125 [2023-10-06 12:57:42] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 12:57:42] [query] Engine: default [2023-10-06 12:57:42] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill [2023-10-06 12:57:42] [query] Mods: 6 [2023-10-06 12:57:42] [query] Using OR logic [2023-10-06 12:57:42] [query] Found results using: or logic [2023-10-06 12:57:42] [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 (20886,13853,27861,45186,333334,8840,4915,69784,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 [2023-10-06 12:57:42] [query] Results: 891 Pages of results: 90 [2023-10-06 12:57:42] [query] Execution time: 0.05730 [2023-10-06 12:57:43] [index:background] Health check [2023-10-06 13:02:23] [indexer:background] Health check [2023-10-06 13:02:23] [index:background] Health check [2023-10-06 13:07:12] [indexer:background] Health check [2023-10-06 13:07:12] [index:background] Health check [2023-10-06 13:07:14] [query] Query for: 2023 [2023-10-06 13:07:14] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 13:07:14] [query] Engine: default [2023-10-06 13:07:15] [query] Tokens: 2023 [2023-10-06 13:07:15] [query] Mods: 6 [2023-10-06 13:07:15] [query] Found results using: or logic [2023-10-06 13:07:15] [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 [2023-10-06 13:07:15] [query] Results: 245 Pages of results: 25 [2023-10-06 13:07:15] [query] Execution time: 0.76731 [2023-10-06 13:10:07] [query] Query for: search_term_string [2023-10-06 13:10:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 13:10:07] [query] Engine: default [2023-10-06 13:10:08] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-06 13:10:08] [query] Mods: 6 [2023-10-06 13:10:08] [query] Using OR logic [2023-10-06 13:10:09] [query] Found results using: or logic [2023-10-06 13:10:09] [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 [2023-10-06 13:10:09] [query] Results: 1343 Pages of results: 135 [2023-10-06 13:10:09] [query] Execution time: 1.43188 [2023-10-06 13:11:46] [indexer:background] Health check [2023-10-06 13:12:15] [index:background] Health check [2023-10-06 13:16:46] [indexer:background] Health check [2023-10-06 13:17:13] [index:background] Health check [2023-10-06 13:22:06] [indexer:background] Health check [2023-10-06 13:22:33] [query] Query for: search_term_string [2023-10-06 13:22:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 13:22:33] [query] Engine: default [2023-10-06 13:22:33] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-10-06 13:22:33] [query] Mods: 6 [2023-10-06 13:22:33] [query] Using OR logic [2023-10-06 13:22:33] [query] Found results using: or logic [2023-10-06 13:22:33] [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 [2023-10-06 13:22:33] [query] Results: 1343 Pages of results: 135 [2023-10-06 13:22:33] [query] Execution time: 0.05093 [2023-10-06 13:22:33] [index:background] Health check [2023-10-06 13:27:09] [indexer:background] Health check [2023-10-06 13:27:15] [index:background] Health check [2023-10-06 13:31:56] [indexer:background] Health check [2023-10-06 13:32:58] [index:background] Health check [2023-10-06 13:36:46] [indexer:background] Health check [2023-10-06 13:38:44] [index:background] Health check [2023-10-06 13:41:57] [indexer:background] Health check [2023-10-06 13:42:21] [index:background] Health check [2023-10-06 13:42:21] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-06 13:42:23] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2] [2023-10-06 13:46:51] [indexer:background] Health check [2023-10-06 13:48:18] [index:background] Health check [2023-10-06 13:52:39] [indexer:background] Health check [2023-10-06 13:52:39] [index:background] Health check [2023-10-06 13:56:40] [indexer:background] Health check [2023-10-06 13:58:11] [index:background] Health check [2023-10-06 14:02:27] [indexer:background] Health check [2023-10-06 14:02:27] [index:background] Health check [2023-10-06 14:06:45] [indexer:background] Health check [2023-10-06 14:06:45] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2] [2023-10-06 14:08:35] [index:background] Health check [2023-10-06 14:12:04] [indexer:background] Health check [2023-10-06 14:12:23] [index:background] Health check [2023-10-06 14:17:01] [indexer:background] Health check [2023-10-06 14:17:12] [index:background] Health check [2023-10-06 14:21:47] [indexer:background] Health check [2023-10-06 14:22:25] [index:background] Health check [2023-10-06 14:28:30] [indexer:background] Health check [2023-10-06 14:28:30] [index:background] Health check [2023-10-06 14:32:05] [indexer:background] Health check [2023-10-06 14:32:41] [index:background] Health check [2023-10-06 14:37:14] [indexer:background] Health check [2023-10-06 14:37:14] [index:background] Health check [2023-10-06 14:42:23] [indexer:background] Health check [2023-10-06 14:42:23] [index:background] Health check [2023-10-06 14:46:58] [indexer:background] Health check [2023-10-06 14:46:58] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2] [2023-10-06 14:49:53] [index:background] Health check [2023-10-06 14:51:53] [indexer:background] Health check [2023-10-06 14:52:38] [index:background] Health check [2023-10-06 14:57:10] [indexer:background] Health check [2023-10-06 14:57:10] [index:background] Health check [2023-10-06 15:02:20] [indexer:background] Health check [2023-10-06 15:02:20] [index:background] Health check [2023-10-06 15:06:46] [indexer:background] Health check [2023-10-06 15:07:40] [index:background] Health check [2023-10-06 15:12:04] [indexer:background] Health check [2023-10-06 15:12:11] [index:background] Health check [2023-10-06 15:17:06] [indexer:background] Health check [2023-10-06 15:19:50] [index:background] Health check [2023-10-06 15:22:48] [indexer:background] Health check [2023-10-06 15:22:48] [index:background] Health check [2023-10-06 15:26:54] [indexer:background] Health check [2023-10-06 15:27:38] [index:background] Health check [2023-10-06 15:34:04] [indexer:background] Health check [2023-10-06 15:34:04] [index:background] Health check [2023-10-06 15:37:38] [indexer:background] Health check [2023-10-06 15:37:38] [index:background] Health check [2023-10-06 15:42:29] [indexer:background] Health check [2023-10-06 15:42:30] [index:background] Health check [2023-10-06 15:49:05] [indexer:background] Health check [2023-10-06 15:49:05] [index:background] Health check [2023-10-06 15:51:53] [indexer:background] Health check [2023-10-06 15:56:23] [index:background] Health check [2023-10-06 15:58:18] [indexer:background] Health check [2023-10-06 15:58:18] [index:background] Health check [2023-10-06 16:02:33] [indexer:background] Health check [2023-10-06 16:02:33] [index:background] Health check [2023-10-06 16:09:38] [indexer:background] Health check [2023-10-06 16:09:38] [index:background] Health check [2023-10-06 16:13:27] [indexer:background] Health check [2023-10-06 16:13:27] [index:background] Health check [2023-10-06 16:17:02] [indexer:background] Health check [2023-10-06 16:18:46] [index:background] Health check [2023-10-06 16:22:33] [indexer:background] Health check [2023-10-06 16:22:33] [index:background] Health check [2023-10-06 16:26:56] [indexer:background] Health check [2023-10-06 16:27:38] [index:background] Health check [2023-10-06 16:31:53] [indexer:background] Health check [2023-10-06 16:32:15] [index:background] Health check [2023-10-06 16:37:51] [indexer:background] Health check [2023-10-06 16:37:51] [index:background] Health check [2023-10-06 16:43:22] [indexer:background] Health check [2023-10-06 16:43:22] [index:background] Health check [2023-10-06 16:47:04] [indexer:background] Health check [2023-10-06 16:51:38] [index:background] Health check [2023-10-06 16:52:19] [indexer:background] Health check [2023-10-06 16:52:19] [index:background] Health check [2023-10-06 16:59:24] [indexer:background] Health check [2023-10-06 16:59:24] [index:background] Health check [2023-10-06 17:05:25] [indexer:background] Health check [2023-10-06 17:05:25] [index:background] Health check [2023-10-06 17:07:58] [indexer:background] Health check [2023-10-06 17:07:58] [index:background] Health check [2023-10-06 17:11:50] [indexer:background] Health check [2023-10-06 17:12:15] [index:background] Health check [2023-10-06 17:16:40] [indexer:background] Health check [2023-10-06 17:17:11] [index:background] Health check [2023-10-06 17:22:50] [indexer:background] Health check [2023-10-06 17:22:50] [index:background] Health check [2023-10-06 17:28:16] [indexer:background] Health check [2023-10-06 17:28:16] [index:background] Health check [2023-10-06 17:32:15] [indexer:background] Health check [2023-10-06 17:32:15] [index:background] Health check [2023-10-06 17:39:53] [indexer:background] Health check [2023-10-06 17:39:53] [index:background] Health check [2023-10-06 17:42:03] [indexer:background] Health check [2023-10-06 17:43:09] [index:background] Health check [2023-10-06 17:47:05] [indexer:background] Health check [2023-10-06 17:49:53] [index:background] Health check [2023-10-06 17:54:04] [indexer:background] Health check [2023-10-06 17:54:04] [index:background] Health check [2023-10-06 17:57:18] [indexer:background] Health check [2023-10-06 17:57:18] [index:background] Health check [2023-10-06 18:01:50] [indexer:background] Health check [2023-10-06 18:05:49] [index:background] Health check [2023-10-06 18:07:08] [indexer:background] Health check [2023-10-06 18:08:31] [index:background] Health check [2023-10-06 18:11:49] [indexer:background] Health check [2023-10-06 18:12:01] [query] Query for: sécurité civile [2023-10-06 18:12:01] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:12:01] [query] Engine: default [2023-10-06 18:12:02] [query] Tokens: civile, civiles, civils, civilea, civili, civilement, civilité, civilités, civiliste, securite, securita, securities, securites, civil [2023-10-06 18:12:02] [query] Mods: 6 [2023-10-06 18:12:02] [query] Trying AND logic [2023-10-06 18:12:02] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:12:02] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:12:13] [query] Found results using: and logic [2023-10-06 18:12:13] [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 (813,34457,35812,66285,207442,402917,478426,626629,667934,345,63405,67721,324835,6503) 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 (345, 63405, 67721, 324835) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 [2023-10-06 18:12:13] [query] Results: 1383 Pages of results: 139 [2023-10-06 18:12:13] [query] Execution time: 12.38410 [2023-10-06 18:12:13] [query] Query for: sécurité civile [2023-10-06 18:12:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-10-06 18:12:13] [query] Engine: default [2023-10-06 18:12:13] [query] Tokens: civile, civiles, civils, civilea, civili, civilement, civilité, civilités, civiliste, securite, securita, securities, securites, civil [2023-10-06 18:12:13] [query] Mods: 6 [2023-10-06 18:12:13] [query] Trying AND logic [2023-10-06 18:12:13] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:12:13] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:12:17] [index:background] Health check [2023-10-06 18:12:17] [query] Found results using: and logic [2023-10-06 18:12:17] [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 (813,34457,35812,66285,207442,402917,478426,626629,667934,345,63405,67721,324835,6503) 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 (345, 63405, 67721, 324835) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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, 100 [2023-10-06 18:12:17] [query] Results: 1383 Pages of results: 14 [2023-10-06 18:12:17] [query] Execution time: 4.44629 [2023-10-06 18:13:54] [query] Query for: sécurité civile [2023-10-06 18:13:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2023-10-06 18:13:54] [query] Engine: default [2023-10-06 18:13:54] [query] Tokens: civile, civiles, civils, civilea, civili, civilement, civilité, civilités, civiliste, securite, securita, securities, securites, civil [2023-10-06 18:13:54] [query] Mods: 6 [2023-10-06 18:13:54] [query] Trying AND logic [2023-10-06 18:13:54] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:13:54] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:13:56] [query] Found results using: and logic [2023-10-06 18:13: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 (813,34457,35812,66285,207442,402917,478426,626629,667934,345,63405,67721,324835,6503) 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 (345, 63405, 67721, 324835) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 10, 10 [2023-10-06 18:13:56] [query] Results: 1383 Pages of results: 139 [2023-10-06 18:13:56] [query] Execution time: 2.49573 [2023-10-06 18:13:56] [query] Query for: sécurité civile [2023-10-06 18:13:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 2 offset: 0 fields: all [2023-10-06 18:13:56] [query] Engine: default [2023-10-06 18:13:56] [query] Tokens: civile, civiles, civils, civilea, civili, civilement, civilité, civilités, civiliste, securite, securita, securities, securites, civil [2023-10-06 18:13:56] [query] Mods: 6 [2023-10-06 18:13:56] [query] Trying AND logic [2023-10-06 18:13:56] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:13:56] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:13:58] [query] Found results using: and logic [2023-10-06 18:13:58] [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 (813,34457,35812,66285,207442,402917,478426,626629,667934,345,63405,67721,324835,6503) 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 (345, 63405, 67721, 324835) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 100, 100 [2023-10-06 18:13:58] [query] Results: 1383 Pages of results: 14 [2023-10-06 18:13:58] [query] Execution time: 1.47432 [2023-10-06 18:14:09] [query] Query for: incendie [2023-10-06 18:14:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:14:09] [query] Engine: default [2023-10-06 18:14:09] [query] Tokens: incendies, incendie [2023-10-06 18:14:09] [query] Mods: 6 [2023-10-06 18:14:09] [query] Using OR logic [2023-10-06 18:14:09] [query] Found results using: and logic [2023-10-06 18:14:09] [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 (6481,6627) 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 [2023-10-06 18:14:09] [query] Results: 210 Pages of results: 21 [2023-10-06 18:14:09] [query] Execution time: 0.72421 [2023-10-06 18:14:09] [query] Query for: incendie [2023-10-06 18:14:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-10-06 18:14:09] [query] Engine: default [2023-10-06 18:14:09] [query] Tokens: incendies, incendie [2023-10-06 18:14:09] [query] Mods: 6 [2023-10-06 18:14:09] [query] Using OR logic [2023-10-06 18:14:09] [query] Found results using: and logic [2023-10-06 18:14:10] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (6481,6627) 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 [2023-10-06 18:14:10] [query] Results: 210 Pages of results: 3 [2023-10-06 18:14:10] [query] Execution time: 0.11126 [2023-10-06 18:14:10] [query] Query for: incendie [2023-10-06 18:14:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:14:10] [query] Engine: default [2023-10-06 18:14:10] [query] Tokens: incendies, incendie [2023-10-06 18:14:10] [query] Mods: 6 [2023-10-06 18:14:10] [query] Using OR logic [2023-10-06 18:14:10] [query] Found results using: and logic [2023-10-06 18:14:10] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (6481,6627) 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 [2023-10-06 18:14:10] [query] Results: 210 Pages of results: 21 [2023-10-06 18:14:10] [query] Execution time: 0.03689 [2023-10-06 18:14:10] [query] Query for: incendie [2023-10-06 18:14:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-10-06 18:14:10] [query] Engine: default [2023-10-06 18:14:10] [query] Tokens: incendies, incendie [2023-10-06 18:14:10] [query] Mods: 6 [2023-10-06 18:14:10] [query] Using OR logic [2023-10-06 18:14:10] [query] Found results using: and logic [2023-10-06 18:14: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 (6481,6627) 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 [2023-10-06 18:14:11] [query] Results: 210 Pages of results: 3 [2023-10-06 18:14:11] [query] Execution time: 0.06639 [2023-10-06 18:17:05] [indexer:background] Health check [2023-10-06 18:17:12] [index:background] Health check [2023-10-06 18:22:59] [indexer:background] Health check [2023-10-06 18:22:59] [index:background] Health check [2023-10-06 18:27:02] [indexer:background] Health check [2023-10-06 18:28:15] [index:background] Health check [2023-10-06 18:32:30] [indexer:background] Health check [2023-10-06 18:32:30] [index:background] Health check [2023-10-06 18:37:22] [indexer:background] Health check [2023-10-06 18:37:22] [index:background] Health check [2023-10-06 18:39:30] [query] Query for: code civil [2023-10-06 18:39:30] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:39:30] [query] Engine: default [2023-10-06 18:39:31] [query] Tokens: civiliste, codir, codis, codé, codées, codi, codea, codes, code, civilités, civilité, civilement, civili, civilea, civils, civiles, civile, cod, civil [2023-10-06 18:39:31] [query] Mods: 6 [2023-10-06 18:39:31] [query] Trying AND logic [2023-10-06 18:39:31] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:31] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:35] [query] Found results using: and logic [2023-10-06 18:39:35] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (667934,618720,552583,463276,85413,62216,55224,4669,612,626629,478426,402917,207442,66285,35812,34457,813,701962,6503) 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 (612, 4669, 55224, 62216, 85413, 463276, 552583, 618720, 701962) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 [2023-10-06 18:39:35] [query] Results: 1462 Pages of results: 147 [2023-10-06 18:39:35] [query] Execution time: 5.59392 [2023-10-06 18:39:35] [query] Query for: code civil [2023-10-06 18:39:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-10-06 18:39:35] [query] Engine: default [2023-10-06 18:39:35] [query] Tokens: civiliste, codir, codis, codé, codées, codi, codea, codes, code, civilités, civilité, civilement, civili, civilea, civils, civiles, civile, cod, civil [2023-10-06 18:39:35] [query] Mods: 6 [2023-10-06 18:39:35] [query] Trying AND logic [2023-10-06 18:39:35] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:35] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:37] [query] Query for: code civil [2023-10-06 18:39:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:39:37] [query] Engine: default [2023-10-06 18:39:37] [query] Tokens: civiliste, codir, codis, codé, codées, codi, codea, codes, code, civilités, civilité, civilement, civili, civilea, civils, civiles, civile, cod, civil [2023-10-06 18:39:37] [query] Mods: 6 [2023-10-06 18:39:37] [query] Trying AND logic [2023-10-06 18:39:37] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:37] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:37] [query] Found results using: and logic [2023-10-06 18:39:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (667934,618720,552583,463276,85413,62216,55224,4669,612,626629,478426,402917,207442,66285,35812,34457,813,701962,6503) 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 (612, 4669, 55224, 62216, 85413, 463276, 552583, 618720, 701962) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 [2023-10-06 18:39:37] [query] Results: 1462 Pages of results: 147 [2023-10-06 18:39:37] [query] Execution time: 0.03417 [2023-10-06 18:39:37] [query] Query for: code civil [2023-10-06 18:39:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-10-06 18:39:37] [query] Engine: default [2023-10-06 18:39:37] [query] Tokens: civiliste, codir, codis, codé, codées, codi, codea, codes, code, civilités, civilité, civilement, civili, civilea, civils, civiles, civile, cod, civil [2023-10-06 18:39:37] [query] Mods: 6 [2023-10-06 18:39:37] [query] Trying AND logic [2023-10-06 18:39:37] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:37] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:37] [query] Found results using: and logic [2023-10-06 18:39:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (667934,618720,552583,463276,85413,62216,55224,4669,612,626629,478426,402917,207442,66285,35812,34457,813,701962,6503) 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 (612, 4669, 55224, 62216, 85413, 463276, 552583, 618720, 701962) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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, 100 [2023-10-06 18:39:37] [query] Results: 1462 Pages of results: 15 [2023-10-06 18:39:37] [query] Execution time: 1.62334 [2023-10-06 18:39:38] [query] Found results using: and logic [2023-10-06 18:39:38] [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 (667934,618720,552583,463276,85413,62216,55224,4669,612,626629,478426,402917,207442,66285,35812,34457,813,701962,6503) 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 (612, 4669, 55224, 62216, 85413, 463276, 552583, 618720, 701962) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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, 100 [2023-10-06 18:39:38] [query] Results: 1462 Pages of results: 15 [2023-10-06 18:39:38] [query] Execution time: 0.74901 [2023-10-06 18:39:55] [query] Query for: code civil [2023-10-06 18:39:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2023-10-06 18:39:55] [query] Engine: default [2023-10-06 18:39:55] [query] Tokens: civiliste, codir, codis, codé, codées, codi, codea, codes, code, civilités, civilité, civilement, civili, civilea, civils, civiles, civile, cod, civil [2023-10-06 18:39:55] [query] Mods: 6 [2023-10-06 18:39:55] [query] Trying AND logic [2023-10-06 18:39:55] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:55] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:56] [query] Found results using: and logic [2023-10-06 18:39: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 (667934,618720,552583,463276,85413,62216,55224,4669,612,626629,478426,402917,207442,66285,35812,34457,813,701962,6503) 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 (612, 4669, 55224, 62216, 85413, 463276, 552583, 618720, 701962) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 10, 10 [2023-10-06 18:39:56] [query] Results: 1462 Pages of results: 147 [2023-10-06 18:39:56] [query] Execution time: 1.01579 [2023-10-06 18:39:56] [query] Query for: code civil [2023-10-06 18:39:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 2 offset: 0 fields: all [2023-10-06 18:39:56] [query] Engine: default [2023-10-06 18:39:56] [query] Tokens: civiliste, codir, codis, codé, codées, codi, codea, codes, code, civilités, civilité, civilement, civili, civilea, civils, civiles, civile, cod, civil [2023-10-06 18:39:56] [query] Mods: 6 [2023-10-06 18:39:56] [query] Trying AND logic [2023-10-06 18:39:56] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:56] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 18:39:56] [query] Found results using: and logic [2023-10-06 18:39: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 (667934,618720,552583,463276,85413,62216,55224,4669,612,626629,478426,402917,207442,66285,35812,34457,813,701962,6503) 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 (612, 4669, 55224, 62216, 85413, 463276, 552583, 618720, 701962) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (813, 6503, 34457, 35812, 66285, 207442, 402917, 478426, 626629, 667934) 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 100, 100 [2023-10-06 18:39:56] [query] Results: 1462 Pages of results: 15 [2023-10-06 18:39:56] [query] Execution time: 0.64924 [2023-10-06 18:41:46] [indexer:background] Health check [2023-10-06 18:42:19] [index:background] Health check [2023-10-06 18:47:01] [indexer:background] Health check [2023-10-06 18:48:25] [index:background] Health check [2023-10-06 18:51:24] [query] Query for: drou.cn [2023-10-06 18:51:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:51:24] [query] Engine: default [2023-10-06 18:51:24] [query] Query for: drou.cn [2023-10-06 18:51:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 18:51:24] [query] Engine: default [2023-10-06 18:51:24] [query] Tokens: drou drou.cn [2023-10-06 18:51:24] [query] Tokens: drou drou.cn [2023-10-06 18:51:24] [query] Mods: 6 [2023-10-06 18:51:24] [query] Mods: 6 [2023-10-06 18:51:24] [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 (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 [2023-10-06 18:51:24] [query] Results: 0 Pages of results: 0 [2023-10-06 18:51:24] [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 (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 [2023-10-06 18:51:24] [query] Results: 0 Pages of results: 0 [2023-10-06 18:51:24] [query] Execution time: 0.22828 [2023-10-06 18:51:24] [query] Execution time: 0.34649 [2023-10-06 18:55:04] [indexer:background] Health check [2023-10-06 18:55:06] [index:background] Health check [2023-10-06 18:57:03] [indexer:background] Health check [2023-10-06 19:05:03] [index:background] Health check [2023-10-06 19:05:03] [indexer:background] Health check [2023-10-06 19:05:03] [indexer:background] Health check [2023-10-06 19:06:42] [indexer:background] Health check [2023-10-06 19:07:10] [index:background] Health check [2023-10-06 19:11:57] [indexer:background] Health check [2023-10-06 19:12:37] [index:background] Health check [2023-10-06 19:18:06] [indexer:background] Health check [2023-10-06 19:18:06] [index:background] Health check [2023-10-06 19:21:42] [indexer:background] Health check [2023-10-06 19:23:12] [index:background] Health check [2023-10-06 19:26:53] [indexer:background] Health check [2023-10-06 19:28:19] [index:background] Health check [2023-10-06 19:32:52] [indexer:background] Health check [2023-10-06 19:32:52] [index:background] Health check [2023-10-06 19:38:09] [indexer:background] Health check [2023-10-06 19:38:09] [index:background] Health check [2023-10-06 19:43:26] [indexer:background] Health check [2023-10-06 19:43:27] [index:background] Health check [2023-10-06 19:46:54] [indexer:background] Health check [2023-10-06 19:48:21] [index:background] Health check [2023-10-06 19:52:34] [indexer:background] Health check [2023-10-06 19:52:34] [index:background] Health check [2023-10-06 19:56:45] [indexer:background] Health check [2023-10-06 19:56:45] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-10-06 19:57:42] [index:background] Health check [2023-10-06 20:02:03] [indexer:background] Health check [2023-10-06 20:02:11] [index:background] Health check [2023-10-06 20:06:51] [indexer:background] Health check [2023-10-06 20:09:06] [index:background] Health check [2023-10-06 20:13:27] [indexer:background] Health check [2023-10-06 20:13:27] [index:background] Health check [2023-10-06 20:17:55] [indexer:background] Health check [2023-10-06 20:17:55] [index:background] Health check [2023-10-06 20:22:18] [indexer:background] Health check [2023-10-06 20:22:18] [index:background] Health check [2023-10-06 20:26:47] [query] Query for: 2024 [2023-10-06 20:26:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 20:26:47] [query] Engine: default [2023-10-06 20:26:47] [indexer:background] Health check [2023-10-06 20:26:48] [query] Tokens: 2024 [2023-10-06 20:26:48] [query] Mods: 6 [2023-10-06 20:26:48] [query] Found results using: or logic [2023-10-06 20:26:48] [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 [2023-10-06 20:26:48] [query] Results: 128 Pages of results: 13 [2023-10-06 20:26:48] [query] Execution time: 1.13705 [2023-10-06 20:27:14] [index:background] Health check [2023-10-06 20:33:43] [indexer:background] Health check [2023-10-06 20:33:44] [index:background] Health check [2023-10-06 20:37:11] [indexer:background] Health check [2023-10-06 20:37:11] [index:background] Health check [2023-10-06 20:43:21] [indexer:background] Health check [2023-10-06 20:43:21] [index:background] Health check [2023-10-06 20:46:50] [indexer:background] Health check [2023-10-06 20:47:35] [index:background] Health check [2023-10-06 20:51:57] [indexer:background] Health check [2023-10-06 20:53:33] [index:background] Health check [2023-10-06 20:56:56] [indexer:background] Health check [2023-10-06 20:57:19] [index:background] Health check [2023-10-06 21:01:43] [indexer:background] Health check [2023-10-06 21:02:51] [index:background] Health check [2023-10-06 21:06:51] [indexer:background] Health check [2023-10-06 21:07:41] [index:background] Health check [2023-10-06 21:12:11] [indexer:background] Health check [2023-10-06 21:12:11] [index:background] Health check [2023-10-06 21:16:53] [indexer:background] Health check [2023-10-06 21:17:26] [index:background] Health check [2023-10-06 21:22:11] [indexer:background] Health check [2023-10-06 21:22:11] [index:background] Health check [2023-10-06 21:27:30] [indexer:background] Health check [2023-10-06 21:27:30] [index:background] Health check [2023-10-06 21:31:54] [indexer:background] Health check [2023-10-06 21:32:24] [index:background] Health check [2023-10-06 21:37:33] [indexer:background] Health check [2023-10-06 21:37:33] [index:background] Health check [2023-10-06 21:44:22] [indexer:background] Health check [2023-10-06 21:44:23] [indexer:background] Health check [2023-10-06 21:44:23] [index:background] Health check [2023-10-06 21:46:52] [query] Query for: nouvelle grille salariale des services pétroliers [2023-10-06 21:46:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-10-06 21:46:52] [query] Engine: default [2023-10-06 21:46:52] [indexer:background] Health check [2023-10-06 21:46:52] [query] Tokens: nouvelée, servica, servicer, servicea, service, services, salariaux, salariales, salariale, petroliers, petrolier, nouveler, nouvele, nouvelé, grille, nouveles, nouvelés, nouvellements, nouvelable, nouvellea, nouvela, nouvellement, nouvell, nouvelables, nouvelles, nouvelle, grilles, nouvel, grill, salarial, servic [2023-10-06 21:46:52] [query] Mods: 6 [2023-10-06 21:46:52] [query] Trying AND logic [2023-10-06 21:46:52] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 21:46:52] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 21:46:52] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 21:46:52] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 21:46:52] [query] Skipping AND logic Source Attribute consideration (single Engine) [2023-10-06 21:47:15] [index:background] Health check [2023-10-06 21:47:43] [query] Found results using: and logic [2023-10-06 21:47:43] [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 (548976,772124,712101,10750,4547,405,404928,30537,13543,17281,17079,679449,592228,592116,4478,548282,548230,513413,512948,66188,66043,50714,23280,15202,7576,1403,15455,4285,10393,5664,59840) 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 ('10444', '10445', '4701', '4704', '4710', '4711', '7165', '7166', '7317', '7318', '7581', '7598', '7599', '7756', '7757') 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 [2023-10-06 21:47:43] [query] Results: 15 Pages of results: 2 [2023-10-06 21:47:43] [query] Execution time: 51.02409 [2023-10-06 21:54:00] [indexer:background] Health check [2023-10-06 21:54:00] [index:background] Health check [2023-10-06 21:57:48] [indexer:background] Health check [2023-10-06 21:57:48] [index:background] Health check [2023-10-06 22:02:33] [indexer:background] Health check [2023-10-06 22:02:33] [index:background] Health check [2023-10-06 22:06:54] [indexer:background] Health check [2023-10-06 22:07:12] [index:background] Health check [2023-10-06 22:12:06] [indexer:background] Health check [2023-10-06 22:12:25] [index:background] Health check [2023-10-06 22:19:24] [indexer:background] Health check [2023-10-06 22:19:24] [index:background] Health check [2023-10-06 22:25:30] [indexer:background] Health check [2023-10-06 22:25:30] [index:background] Health check [2023-10-06 22:26:40] [indexer:background] Health check [2023-10-06 22:27:31] [index:background] Health check [2023-10-06 22:31:43] [indexer:background] Health check [2023-10-06 22:33:08] [index:background] Health check [2023-10-06 22:39:06] [indexer:background] Health check [2023-10-06 22:39:06] [index:background] Health check [2023-10-06 22:41:48] [indexer:background] Health check [2023-10-06 22:43:30] [index:background] Health check [2023-10-06 22:47:11] [indexer:background] Health check [2023-10-06 22:47:11] [index:background] Health check [2023-10-06 22:52:34] [indexer:background] Health check [2023-10-06 22:52:34] [index:background] Health check [2023-10-06 22:56:46] [indexer:background] Health check [2023-10-06 22:57:38] [index:background] Health check [2023-10-06 23:02:30] [indexer:background] Health check [2023-10-06 23:02:30] [index:background] Health check [2023-10-06 23:07:46] [indexer:background] Health check [2023-10-06 23:07:48] [index:background] Health check [2023-10-06 23:12:15] [indexer:background] Health check [2023-10-06 23:12:15] [index:background] Health check [2023-10-06 23:18:22] [indexer:background] Health check [2023-10-06 23:18:23] [index:background] Health check [2023-10-06 23:24:41] [indexer:background] Health check [2023-10-06 23:24:41] [index:background] Health check [2023-10-06 23:27:09] [indexer:background] Health check [2023-10-06 23:27:11] [index:background] Health check [2023-10-06 23:32:23] [indexer:background] Health check [2023-10-06 23:32:23] [index:background] Health check [2023-10-06 23:36:44] [indexer:background] Health check [2023-10-06 23:38:32] [index:background] Health check [2023-10-06 23:42:28] [indexer:background] Health check [2023-10-06 23:42:29] [index:background] Health check [2023-10-06 23:46:47] [indexer:background] Health check [2023-10-06 23:48:13] [index:background] Health check [2023-10-06 23:52:23] [indexer:background] Health check [2023-10-06 23:52:23] [index:background] Health check [2023-10-06 23:59:22] [indexer:background] Health check [2023-10-06 23:59:22] [index:background] Health check