[2024-01-03 00:01:23] [index:background] Health check
[2024-01-03 00:05:24] [indexer:background] Health check
[2024-01-03 00:05:24] [index:background] Health check
[2024-01-03 00:09:43] [indexer:background] Health check
[2024-01-03 00:11:06] [index:background] Health check
[2024-01-03 00:13:49] [indexer:background] Health check
[2024-01-03 00:17:24] [index:background] Health check
[2024-01-03 00:19:32] [indexer:background] Health check
[2024-01-03 00:21:35] [index:background] Health check
[2024-01-03 00:23:56] [indexer:background] Health check
[2024-01-03 00:26:25] [index:background] Health check
[2024-01-03 00:29:26] [indexer:background] Health check
[2024-01-03 00:31:57] [index:background] Health check
[2024-01-03 00:36:13] [indexer:background] Health check
[2024-01-03 00:36:13] [index:background] Health check
[2024-01-03 00:39:19] [indexer:background] Health check
[2024-01-03 00:40:43] [index:background] Health check
[2024-01-03 00:44:31] [indexer:background] Health check
[2024-01-03 00:46:40] [index:background] Health check
[2024-01-03 00:49:20] [indexer:background] Health check
[2024-01-03 00:50:26] [index:background] Health check
[2024-01-03 00:54:29] [indexer:background] Health check
[2024-01-03 00:55:25] [index:background] Health check
[2024-01-03 00:58:48] [indexer:background] Health check
[2024-01-03 01:00:25] [index:background] Health check
[2024-01-03 01:05:17] [indexer:background] Health check
[2024-01-03 01:07:33] [index:background] Health check
[2024-01-03 01:09:35] [indexer:background] Health check
[2024-01-03 01:10:49] [index:background] Health check
[2024-01-03 01:14:33] [indexer:background] Health check
[2024-01-03 01:16:24] [index:background] Health check
[2024-01-03 01:20:27] [indexer:background] Health check
[2024-01-03 01:20:27] [index:background] Health check
[2024-01-03 01:24:00] [indexer:background] Health check
[2024-01-03 01:26:51] [index:background] Health check
[2024-01-03 01:29:02] [indexer:background] Health check
[2024-01-03 01:31:12] [index:background] Health check
[2024-01-03 01:33:49] [indexer:background] Health check
[2024-01-03 01:35:36] [index:background] Health check
[2024-01-03 01:38:51] [indexer:background] Health check
[2024-01-03 01:40:34] [index:background] Health check
[2024-01-03 01:43:51] [indexer:background] Health check
[2024-01-03 01:46:45] [index:background] Health check
[2024-01-03 01:48:55] [indexer:background] Health check
[2024-01-03 01:52:00] [index:background] Health check
[2024-01-03 01:54:56] [indexer:background] Health check
[2024-01-03 01:55:29] [index:background] Health check
[2024-01-03 02:00:39] [indexer:background] Health check
[2024-01-03 02:00:39] [index:background] Health check
[2024-01-03 02:03:57] [indexer:background] Health check
[2024-01-03 02:05:25] [index:background] Health check
[2024-01-03 02:08:49] [indexer:background] Health check
[2024-01-03 02:10:37] [index:background] Health check
[2024-01-03 02:15:31] [indexer:background] Health check
[2024-01-03 02:15:31] [index:background] Health check
[2024-01-03 02:20:32] [indexer:background] Health check
[2024-01-03 02:20:32] [index:background] Health check
[2024-01-03 02:24:16] [indexer:background] Health check
[2024-01-03 02:25:50] [index:background] Health check
[2024-01-03 02:28:48] [indexer:background] Health check
[2024-01-03 02:30:29] [index:background] Health check
[2024-01-03 02:33:57] [indexer:background] Health check
[2024-01-03 02:36:46] [index:background] Health check
[2024-01-03 02:40:10] [indexer:background] Health check
[2024-01-03 02:41:01] [index:background] Health check
[2024-01-03 02:44:12] [indexer:background] Health check
[2024-01-03 02:46:17] [index:background] Health check
[2024-01-03 02:46:17] [index:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2024-01-03 02:46:19] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2024-01-03 02:48:55] [indexer:background] Health check
[2024-01-03 02:48:55] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2024-01-03 02:51:37] [index:background] Health check
[2024-01-03 02:51:37] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2024-01-03 02:51:39] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2024-01-03 02:54:21] [indexer:background] Health check
[2024-01-03 02:54:21] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2024-01-03 02:56:37] [index:background] Health check
[2024-01-03 02:59:04] [indexer:background] Health check
[2024-01-03 02:59:04] [indexer:background] CPU load threshold (3) breached: 3.87 [waiting 2]
[2024-01-03 03:00:57] [index:background] Health check
[2024-01-03 03:00:57] [index:background] CPU load threshold (3) breached: 4.29 [waiting 2]
[2024-01-03 03:00:59] [indexer:background] CPU load threshold (3) breached: 4.27 [waiting 2]
[2024-01-03 03:04:52] [indexer:background] Health check
[2024-01-03 03:05:37] [index:background] Health check
[2024-01-03 03:05:37] [index:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2024-01-03 03:05:39] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2024-01-03 03:09:35] [indexer:background] Health check
[2024-01-03 03:10:43] [index:background] Health check
[2024-01-03 03:13:59] [indexer:background] Health check
[2024-01-03 03:13:59] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-01-03 03:16:31] [index:background] Health check
[2024-01-03 03:18:52] [indexer:background] Health check
[2024-01-03 03:18:52] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2024-01-03 03:21:11] [index:background] Health check
[2024-01-03 03:21:11] [index:background] CPU load threshold (3) breached: 4.05 [waiting 2]
[2024-01-03 03:21:13] [indexer:background] CPU load threshold (3) breached: 4.05 [waiting 2]
[2024-01-03 03:25:15] [indexer:background] Health check
[2024-01-03 03:25:15] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2]
[2024-01-03 03:28:47] [index:background] Health check
[2024-01-03 03:28:52] [indexer:background] Health check
[2024-01-03 03:28:52] [indexer:background] Health check
[2024-01-03 03:30:29] [index:background] Health check
[2024-01-03 03:30:29] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2024-01-03 03:30:31] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2024-01-03 03:31:46] [query] Query for: 2023
[2024-01-03 03:31:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 03:31:46] [query] Engine: default
[2024-01-03 03:31:46] [query] Tokens: 2023
[2024-01-03 03:31:46] [query] Mods: 6
[2024-01-03 03:31:47] [query] Found results using: or logic
[2024-01-03 03:31:47] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 03:31:47] [query] Results: 255 Pages of results: 26
[2024-01-03 03:31:47] [query] Execution time: 0.49068
[2024-01-03 03:31:47] [query] Query for: 2023
[2024-01-03 03:31:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-03 03:31:47] [query] Engine: default
[2024-01-03 03:31:47] [query] Tokens: 2023
[2024-01-03 03:31:47] [query] Mods: 6
[2024-01-03 03:31:47] [query] Found results using: or logic
[2024-01-03 03:31:47] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-03 03:31:47] [query] Results: 255 Pages of results: 3
[2024-01-03 03:31:47] [query] Execution time: 0.13481
[2024-01-03 03:34:03] [indexer:background] Health check
[2024-01-03 03:34:03] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-01-03 03:36:02] [index:background] Health check
[2024-01-03 03:39:15] [indexer:background] Health check
[2024-01-03 03:40:59] [index:background] Health check
[2024-01-03 03:40:59] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-01-03 03:41:01] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-01-03 03:43:52] [indexer:background] Health check
[2024-01-03 03:45:28] [index:background] Health check
[2024-01-03 03:45:28] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2024-01-03 03:45:30] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2]
[2024-01-03 03:50:02] [indexer:background] Health check
[2024-01-03 03:51:44] [index:background] Health check
[2024-01-03 03:53:50] [indexer:background] Health check
[2024-01-03 03:55:41] [index:background] Health check
[2024-01-03 03:59:07] [indexer:background] Health check
[2024-01-03 03:59:07] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2024-01-03 04:01:52] [index:background] Health check
[2024-01-03 04:04:40] [indexer:background] Health check
[2024-01-03 04:05:42] [index:background] Health check
[2024-01-03 04:10:12] [indexer:background] Health check
[2024-01-03 04:10:47] [index:background] Health check
[2024-01-03 04:14:50] [indexer:background] Health check
[2024-01-03 04:15:55] [index:background] Health check
[2024-01-03 04:20:01] [indexer:background] Health check
[2024-01-03 04:20:01] [indexer:background] CPU load threshold (3) breached: 4.39 [waiting 2]
[2024-01-03 04:20:58] [index:background] Health check
[2024-01-03 04:20:58] [index:background] CPU load threshold (3) breached: 3.83 [waiting 2]
[2024-01-03 04:21:00] [indexer:background] CPU load threshold (3) breached: 3.83 [waiting 2]
[2024-01-03 04:24:52] [indexer:background] Health check
[2024-01-03 04:24:52] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2]
[2024-01-03 04:26:01] [index:background] Health check
[2024-01-03 04:26:01] [index:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2024-01-03 04:26:03] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2024-01-03 04:28:57] [indexer:background] Health check
[2024-01-03 04:28:57] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2024-01-03 04:31:31] [index:background] Health check
[2024-01-03 04:31:31] [index:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2024-01-03 04:31:33] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2024-01-03 04:35:59] [indexer:background] Health check
[2024-01-03 04:35:59] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2024-01-03 04:36:01] [index:background] Health check
[2024-01-03 04:36:01] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2024-01-03 04:36:03] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2024-01-03 04:39:12] [indexer:background] Health check
[2024-01-03 04:39:12] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2024-01-03 04:41:26] [index:background] Health check
[2024-01-03 04:41:26] [index:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2024-01-03 04:41:29] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-01-03 04:49:57] [indexer:background] Health check
[2024-01-03 04:49:57] [index:background] Health check
[2024-01-03 04:51:42] [index:background] Health check
[2024-01-03 04:54:00] [indexer:background] Health check
[2024-01-03 04:55:46] [index:background] Health check
[2024-01-03 04:58:54] [indexer:background] Health check
[2024-01-03 05:01:42] [index:background] Health check
[2024-01-03 05:03:48] [indexer:background] Health check
[2024-01-03 05:05:41] [index:background] Health check
[2024-01-03 05:09:25] [indexer:background] Health check
[2024-01-03 05:11:08] [index:background] Health check
[2024-01-03 05:16:14] [indexer:background] Health check
[2024-01-03 05:16:14] [index:background] Health check
[2024-01-03 05:19:19] [indexer:background] Health check
[2024-01-03 05:20:35] [index:background] Health check
[2024-01-03 05:23:55] [indexer:background] Health check
[2024-01-03 05:26:28] [index:background] Health check
[2024-01-03 05:28:48] [indexer:background] Health check
[2024-01-03 05:30:34] [index:background] Health check
[2024-01-03 05:35:27] [indexer:background] Health check
[2024-01-03 05:35:27] [index:background] Health check
[2024-01-03 05:39:00] [indexer:background] Health check
[2024-01-03 05:40:59] [index:background] Health check
[2024-01-03 05:45:35] [indexer:background] Health check
[2024-01-03 05:45:36] [index:background] Health check
[2024-01-03 05:49:28] [indexer:background] Health check
[2024-01-03 05:50:25] [index:background] Health check
[2024-01-03 05:54:00] [indexer:background] Health check
[2024-01-03 05:55:26] [index:background] Health check
[2024-01-03 05:59:01] [indexer:background] Health check
[2024-01-03 06:00:37] [index:background] Health check
[2024-01-03 06:03:51] [indexer:background] Health check
[2024-01-03 06:05:39] [index:background] Health check
[2024-01-03 06:09:01] [indexer:background] Health check
[2024-01-03 06:10:28] [index:background] Health check
[2024-01-03 06:13:49] [indexer:background] Health check
[2024-01-03 06:15:28] [index:background] Health check
[2024-01-03 06:18:49] [indexer:background] Health check
[2024-01-03 06:21:19] [index:background] Health check
[2024-01-03 06:23:49] [indexer:background] Health check
[2024-01-03 06:25:31] [index:background] Health check
[2024-01-03 06:30:49] [indexer:background] Health check
[2024-01-03 06:30:49] [index:background] Health check
[2024-01-03 06:34:14] [indexer:background] Health check
[2024-01-03 06:35:37] [index:background] Health check
[2024-01-03 06:38:53] [indexer:background] Health check
[2024-01-03 06:40:44] [index:background] Health check
[2024-01-03 06:43:54] [indexer:background] Health check
[2024-01-03 06:45:29] [index:background] Health check
[2024-01-03 06:48:56] [indexer:background] Health check
[2024-01-03 06:50:56] [index:background] Health check
[2024-01-03 06:54:01] [indexer:background] Health check
[2024-01-03 06:56:00] [index:background] Health check
[2024-01-03 06:59:12] [indexer:background] Health check
[2024-01-03 07:01:31] [index:background] Health check
[2024-01-03 07:05:32] [indexer:background] Health check
[2024-01-03 07:05:32] [index:background] Health check
[2024-01-03 07:09:25] [indexer:background] Health check
[2024-01-03 07:10:25] [index:background] Health check
[2024-01-03 07:14:23] [indexer:background] Health check
[2024-01-03 07:15:37] [index:background] Health check
[2024-01-03 07:18:54] [indexer:background] Health check
[2024-01-03 07:20:28] [index:background] Health check
[2024-01-03 07:23:50] [indexer:background] Health check
[2024-01-03 07:25:29] [index:background] Health check
[2024-01-03 07:28:48] [indexer:background] Health check
[2024-01-03 07:30:44] [index:background] Health check
[2024-01-03 07:35:20] [indexer:background] Health check
[2024-01-03 07:35:46] [index:background] Health check
[2024-01-03 07:38:57] [indexer:background] Health check
[2024-01-03 07:40:27] [index:background] Health check
[2024-01-03 07:43:56] [indexer:background] Health check
[2024-01-03 07:45:55] [index:background] Health check
[2024-01-03 07:48:59] [indexer:background] Health check
[2024-01-03 07:51:04] [index:background] Health check
[2024-01-03 07:54:41] [indexer:background] Health check
[2024-01-03 07:55:39] [index:background] Health check
[2024-01-03 07:59:26] [indexer:background] Health check
[2024-01-03 08:00:33] [index:background] Health check
[2024-01-03 08:06:48] [indexer:background] Health check
[2024-01-03 08:06:48] [index:background] Health check
[2024-01-03 08:09:05] [indexer:background] Health check
[2024-01-03 08:11:38] [index:background] Health check
[2024-01-03 08:14:55] [indexer:background] Health check
[2024-01-03 08:16:03] [index:background] Health check
[2024-01-03 08:20:31] [indexer:background] Health check
[2024-01-03 08:20:31] [index:background] Health check
[2024-01-03 08:23:58] [indexer:background] Health check
[2024-01-03 08:25:35] [index:background] Health check
[2024-01-03 08:29:19] [indexer:background] Health check
[2024-01-03 08:30:34] [index:background] Health check
[2024-01-03 08:34:05] [indexer:background] Health check
[2024-01-03 08:36:00] [index:background] Health check
[2024-01-03 08:39:22] [indexer:background] Health check
[2024-01-03 08:41:07] [index:background] Health check
[2024-01-03 08:46:38] [indexer:background] Health check
[2024-01-03 08:46:38] [index:background] Health check
[2024-01-03 08:49:49] [indexer:background] Health check
[2024-01-03 08:50:44] [index:background] Health check
[2024-01-03 08:54:27] [indexer:background] Health check
[2024-01-03 08:55:56] [index:background] Health check
[2024-01-03 08:59:33] [indexer:background] Health check
[2024-01-03 09:00:38] [index:background] Health check
[2024-01-03 09:05:04] [indexer:background] Health check
[2024-01-03 09:05:50] [index:background] Health check
[2024-01-03 09:08:50] [indexer:background] Health check
[2024-01-03 09:11:21] [index:background] Health check
[2024-01-03 09:14:22] [indexer:background] Health check
[2024-01-03 09:15:56] [index:background] Health check
[2024-01-03 09:19:46] [indexer:background] Health check
[2024-01-03 09:21:19] [index:background] Health check
[2024-01-03 09:25:00] [indexer:background] Health check
[2024-01-03 09:26:02] [index:background] Health check
[2024-01-03 09:28:49] [indexer:background] Health check
[2024-01-03 09:31:20] [index:background] Health check
[2024-01-03 09:33:53] [indexer:background] Health check
[2024-01-03 09:35:52] [index:background] Health check
[2024-01-03 09:39:27] [indexer:background] Health check
[2024-01-03 09:41:24] [index:background] Health check
[2024-01-03 09:45:24] [indexer:background] Health check
[2024-01-03 09:45:24] [index:background] Health check
[2024-01-03 09:50:28] [indexer:background] Health check
[2024-01-03 09:50:28] [index:background] Health check
[2024-01-03 09:54:05] [indexer:background] Health check
[2024-01-03 09:57:44] [index:background] Health check
[2024-01-03 09:57:44] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2024-01-03 09:57:46] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2]
[2024-01-03 10:00:17] [indexer:background] Health check
[2024-01-03 10:01:48] [index:background] Health check
[2024-01-03 10:04:45] [indexer:background] Health check
[2024-01-03 10:05:53] [index:background] Health check
[2024-01-03 10:09:08] [indexer:background] Health check
[2024-01-03 10:10:25] [index:background] Health check
[2024-01-03 10:14:03] [indexer:background] Health check
[2024-01-03 10:15:34] [index:background] Health check
[2024-01-03 10:18:54] [indexer:background] Health check
[2024-01-03 10:22:37] [index:background] Health check
[2024-01-03 10:24:05] [indexer:background] Health check
[2024-01-03 10:26:02] [index:background] Health check
[2024-01-03 10:28:58] [indexer:background] Health check
[2024-01-03 10:30:48] [index:background] Health check
[2024-01-03 10:33:51] [indexer:background] Health check
[2024-01-03 10:35:47] [index:background] Health check
[2024-01-03 10:38:48] [indexer:background] Health check
[2024-01-03 10:41:18] [index:background] Health check
[2024-01-03 10:44:26] [indexer:background] Health check
[2024-01-03 10:48:01] [index:background] Health check
[2024-01-03 10:49:13] [indexer:background] Health check
[2024-01-03 10:50:35] [index:background] Health check
[2024-01-03 10:53:52] [indexer:background] Health check
[2024-01-03 10:53:52] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2024-01-03 10:55:53] [index:background] Health check
[2024-01-03 10:59:09] [indexer:background] Health check
[2024-01-03 11:00:43] [index:background] Health check
[2024-01-03 11:03:56] [indexer:background] Health check
[2024-01-03 11:05:37] [index:background] Health check
[2024-01-03 11:09:29] [indexer:background] Health check
[2024-01-03 11:11:06] [index:background] Health check
[2024-01-03 11:14:06] [indexer:background] Health check
[2024-01-03 11:15:30] [index:background] Health check
[2024-01-03 11:16:11] [query] Query for: 2024
[2024-01-03 11:16:11] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 11:16:11] [query] Engine: default
[2024-01-03 11:16:11] [query] Tokens: 2024
[2024-01-03 11:16:11] [query] Mods: 6
[2024-01-03 11:16:12] [query] Found results using: or logic
[2024-01-03 11:16: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 11:16:12] [query] Results: 132 Pages of results: 14
[2024-01-03 11:16:12] [query] Execution time: 0.90281
[2024-01-03 11:16:12] [query] Query for: 2024
[2024-01-03 11:16:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-03 11:16:12] [query] Engine: default
[2024-01-03 11:16:12] [query] Tokens: 2024
[2024-01-03 11:16:12] [query] Mods: 6
[2024-01-03 11:16:12] [query] Found results using: or logic
[2024-01-03 11:16: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-03 11:16:12] [query] Results: 132 Pages of results: 2
[2024-01-03 11:16:12] [query] Execution time: 0.07730
[2024-01-03 11:18:49] [indexer:background] Health check
[2024-01-03 11:20:36] [index:background] Health check
[2024-01-03 11:23:49] [indexer:background] Health check
[2024-01-03 11:26:12] [index:background] Health check
[2024-01-03 11:29:19] [indexer:background] Health check
[2024-01-03 11:32:09] [index:background] Health check
[2024-01-03 11:35:26] [indexer:background] Health check
[2024-01-03 11:35:26] [index:background] Health check
[2024-01-03 11:39:18] [indexer:background] Health check
[2024-01-03 11:41:11] [index:background] Health check
[2024-01-03 11:43:51] [indexer:background] Health check
[2024-01-03 11:46:51] [index:background] Health check
[2024-01-03 11:49:07] [indexer:background] Health check
[2024-01-03 11:51:46] [index:background] Health check
[2024-01-03 11:53:55] [indexer:background] Health check
[2024-01-03 11:55:37] [index:background] Health check
[2024-01-03 12:00:44] [indexer:background] Health check
[2024-01-03 12:00:44] [index:background] Health check
[2024-01-03 12:04:21] [indexer:background] Health check
[2024-01-03 12:05:48] [index:background] Health check
[2024-01-03 12:08:55] [indexer:background] Health check
[2024-01-03 12:10:36] [index:background] Health check
[2024-01-03 12:10:36] [index:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2024-01-03 12:10:38] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2024-01-03 12:14:42] [indexer:background] Health check
[2024-01-03 12:15:58] [index:background] Health check
[2024-01-03 12:19:26] [indexer:background] Health check
[2024-01-03 12:21:00] [index:background] Health check
[2024-01-03 12:23:56] [indexer:background] Health check
[2024-01-03 12:25:49] [index:background] Health check
[2024-01-03 12:28:53] [indexer:background] Health check
[2024-01-03 12:30:49] [index:background] Health check
[2024-01-03 12:34:12] [indexer:background] Health check
[2024-01-03 12:35:45] [index:background] Health check
[2024-01-03 12:38:59] [indexer:background] Health check
[2024-01-03 12:40:42] [index:background] Health check
[2024-01-03 12:44:20] [indexer:background] Health check
[2024-01-03 12:45:49] [index:background] Health check
[2024-01-03 12:49:11] [indexer:background] Health check
[2024-01-03 12:50:46] [index:background] Health check
[2024-01-03 12:53:59] [indexer:background] Health check
[2024-01-03 12:55:33] [index:background] Health check
[2024-01-03 12:59:06] [indexer:background] Health check
[2024-01-03 13:00:36] [index:background] Health check
[2024-01-03 13:04:27] [indexer:background] Health check
[2024-01-03 13:05:28] [index:background] Health check
[2024-01-03 13:09:01] [indexer:background] Health check
[2024-01-03 13:11:52] [index:background] Health check
[2024-01-03 13:16:08] [indexer:background] Health check
[2024-01-03 13:16:08] [index:background] Health check
[2024-01-03 13:20:07] [indexer:background] Health check
[2024-01-03 13:20:28] [index:background] Health check
[2024-01-03 13:24:14] [indexer:background] Health check
[2024-01-03 13:25:28] [index:background] Health check
[2024-01-03 13:29:01] [indexer:background] Health check
[2024-01-03 13:30:59] [index:background] Health check
[2024-01-03 13:34:31] [indexer:background] Health check
[2024-01-03 13:38:33] [index:background] Health check
[2024-01-03 13:38:50] [indexer:background] Health check
[2024-01-03 13:41:02] [index:background] Health check
[2024-01-03 13:45:06] [indexer:background] Health check
[2024-01-03 13:45:47] [index:background] Health check
[2024-01-03 13:48:57] [indexer:background] Health check
[2024-01-03 13:50:25] [index:background] Health check
[2024-01-03 13:54:07] [indexer:background] Health check
[2024-01-03 13:55:45] [index:background] Health check
[2024-01-03 13:59:36] [indexer:background] Health check
[2024-01-03 14:00:49] [index:background] Health check
[2024-01-03 14:05:22] [indexer:background] Health check
[2024-01-03 14:05:27] [index:background] Health check
[2024-01-03 14:09:18] [indexer:background] Health check
[2024-01-03 14:11:24] [index:background] Health check
[2024-01-03 14:14:43] [indexer:background] Health check
[2024-01-03 14:16:10] [index:background] Health check
[2024-01-03 14:19:24] [indexer:background] Health check
[2024-01-03 14:20:41] [index:background] Health check
[2024-01-03 14:25:19] [indexer:background] Health check
[2024-01-03 14:25:58] [index:background] Health check
[2024-01-03 14:29:34] [indexer:background] Health check
[2024-01-03 14:30:41] [index:background] Health check
[2024-01-03 14:34:24] [indexer:background] Health check
[2024-01-03 14:36:50] [index:background] Health check
[2024-01-03 14:39:39] [indexer:background] Health check
[2024-01-03 14:40:31] [index:background] Health check
[2024-01-03 14:43:57] [indexer:background] Health check
[2024-01-03 14:46:21] [index:background] Health check
[2024-01-03 14:58:28] [indexer:background] Health check
[2024-01-03 14:58:28] [index:background] Health check
[2024-01-03 14:59:07] [indexer:background] Health check
[2024-01-03 15:00:41] [index:background] Health check
[2024-01-03 15:04:10] [indexer:background] Health check
[2024-01-03 15:05:43] [index:background] Health check
[2024-01-03 15:09:09] [indexer:background] Health check
[2024-01-03 15:11:01] [index:background] Health check
[2024-01-03 15:15:09] [indexer:background] Health check
[2024-01-03 15:16:03] [index:background] Health check
[2024-01-03 15:19:03] [indexer:background] Health check
[2024-01-03 15:20:33] [index:background] Health check
[2024-01-03 15:23:48] [indexer:background] Health check
[2024-01-03 15:25:51] [index:background] Health check
[2024-01-03 15:29:40] [indexer:background] Health check
[2024-01-03 15:30:55] [index:background] Health check
[2024-01-03 15:34:37] [indexer:background] Health check
[2024-01-03 15:36:48] [index:background] Health check
[2024-01-03 15:39:14] [indexer:background] Health check
[2024-01-03 15:40:33] [index:background] Health check
[2024-01-03 15:44:32] [indexer:background] Health check
[2024-01-03 15:46:27] [index:background] Health check
[2024-01-03 15:49:03] [indexer:background] Health check
[2024-01-03 15:49:03] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2]
[2024-01-03 15:51:21] [index:background] Health check
[2024-01-03 15:51:21] [index:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2024-01-03 15:51:23] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2024-01-03 15:54:07] [indexer:background] Health check
[2024-01-03 15:54:07] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2024-01-03 15:55:35] [index:background] Health check
[2024-01-03 15:58:49] [indexer:background] Health check
[2024-01-03 16:00:51] [index:background] Health check
[2024-01-03 16:04:09] [indexer:background] Health check
[2024-01-03 16:06:50] [index:background] Health check
[2024-01-03 16:10:21] [indexer:background] Health check
[2024-01-03 16:10:38] [index:background] Health check
[2024-01-03 16:13:51] [indexer:background] Health check
[2024-01-03 16:15:49] [index:background] Health check
[2024-01-03 16:19:02] [indexer:background] Health check
[2024-01-03 16:21:13] [index:background] Health check
[2024-01-03 16:25:00] [indexer:background] Health check
[2024-01-03 16:26:01] [index:background] Health check
[2024-01-03 16:29:50] [indexer:background] Health check
[2024-01-03 16:30:44] [index:background] Health check
[2024-01-03 16:36:26] [indexer:background] Health check
[2024-01-03 16:36:26] [index:background] Health check
[2024-01-03 16:39:22] [indexer:background] Health check
[2024-01-03 16:40:53] [index:background] Health check
[2024-01-03 16:44:09] [indexer:background] Health check
[2024-01-03 16:45:26] [index:background] Health check
[2024-01-03 16:49:15] [indexer:background] Health check
[2024-01-03 16:50:37] [index:background] Health check
[2024-01-03 16:55:49] [indexer:background] Health check
[2024-01-03 16:55:49] [index:background] Health check
[2024-01-03 16:59:22] [indexer:background] Health check
[2024-01-03 17:01:44] [index:background] Health check
[2024-01-03 17:04:28] [indexer:background] Health check
[2024-01-03 17:05:43] [index:background] Health check
[2024-01-03 17:09:41] [indexer:background] Health check
[2024-01-03 17:10:51] [index:background] Health check
[2024-01-03 17:16:17] [indexer:background] Health check
[2024-01-03 17:16:17] [index:background] Health check
[2024-01-03 17:19:13] [indexer:background] Health check
[2024-01-03 17:21:25] [index:background] Health check
[2024-01-03 17:24:12] [indexer:background] Health check
[2024-01-03 17:25:29] [index:background] Health check
[2024-01-03 17:30:12] [indexer:background] Health check
[2024-01-03 17:31:52] [index:background] Health check
[2024-01-03 17:33:50] [indexer:background] Health check
[2024-01-03 17:36:15] [index:background] Health check
[2024-01-03 17:39:24] [indexer:background] Health check
[2024-01-03 17:40:34] [index:background] Health check
[2024-01-03 17:44:09] [indexer:background] Health check
[2024-01-03 17:46:52] [index:background] Health check
[2024-01-03 17:49:45] [indexer:background] Health check
[2024-01-03 17:50:33] [index:background] Health check
[2024-01-03 17:55:19] [indexer:background] Health check
[2024-01-03 17:55:28] [index:background] Health check
[2024-01-03 18:01:12] [indexer:background] Health check
[2024-01-03 18:01:12] [index:background] Health check
[2024-01-03 18:05:32] [indexer:background] Health check
[2024-01-03 18:05:32] [index:background] Health check
[2024-01-03 18:09:25] [indexer:background] Health check
[2024-01-03 18:10:24] [index:background] Health check
[2024-01-03 18:14:22] [indexer:background] Health check
[2024-01-03 18:15:50] [index:background] Health check
[2024-01-03 18:19:20] [indexer:background] Health check
[2024-01-03 18:20:34] [index:background] Health check
[2024-01-03 18:25:31] [indexer:background] Health check
[2024-01-03 18:25:32] [index:background] Health check
[2024-01-03 18:28:53] [indexer:background] Health check
[2024-01-03 18:30:51] [index:background] Health check
[2024-01-03 18:34:46] [indexer:background] Health check
[2024-01-03 18:36:37] [index:background] Health check
[2024-01-03 18:39:00] [indexer:background] Health check
[2024-01-03 18:40:25] [index:background] Health check
[2024-01-03 18:44:23] [indexer:background] Health check
[2024-01-03 18:46:26] [index:background] Health check
[2024-01-03 18:49:39] [indexer:background] Health check
[2024-01-03 18:50:48] [index:background] Health check
[2024-01-03 18:54:20] [indexer:background] Health check
[2024-01-03 18:56:07] [index:background] Health check
[2024-01-03 18:59:05] [indexer:background] Health check
[2024-01-03 19:01:25] [index:background] Health check
[2024-01-03 19:02:27] [query] Query for: 2023
[2024-01-03 19:02:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 19:02:27] [query] Engine: default
[2024-01-03 19:02:27] [query] Tokens: 2023
[2024-01-03 19:02:27] [query] Mods: 6
[2024-01-03 19:02:28] [query] Found results using: or logic
[2024-01-03 19:02:28] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 19:02:28] [query] Results: 255 Pages of results: 26
[2024-01-03 19:02:28] [query] Execution time: 0.47541
[2024-01-03 19:02:28] [query] Query for: 2023
[2024-01-03 19:02:28] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-03 19:02:28] [query] Engine: default
[2024-01-03 19:02:28] [query] Tokens: 2023
[2024-01-03 19:02:28] [query] Mods: 6
[2024-01-03 19:02:28] [query] Found results using: or logic
[2024-01-03 19:02:28] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-03 19:02:28] [query] Results: 255 Pages of results: 3
[2024-01-03 19:02:28] [query] Execution time: 0.11395
[2024-01-03 19:04:01] [indexer:background] Health check
[2024-01-03 19:05:45] [index:background] Health check
[2024-01-03 19:09:37] [indexer:background] Health check
[2024-01-03 19:10:28] [index:background] Health check
[2024-01-03 19:15:43] [indexer:background] Health check
[2024-01-03 19:15:43] [index:background] Health check
[2024-01-03 19:20:05] [indexer:background] Health check
[2024-01-03 19:20:30] [index:background] Health check
[2024-01-03 19:24:05] [indexer:background] Health check
[2024-01-03 19:25:41] [index:background] Health check
[2024-01-03 19:28:55] [indexer:background] Health check
[2024-01-03 19:30:36] [index:background] Health check
[2024-01-03 19:33:58] [indexer:background] Health check
[2024-01-03 19:35:30] [index:background] Health check
[2024-01-03 19:38:53] [indexer:background] Health check
[2024-01-03 19:40:26] [index:background] Health check
[2024-01-03 19:43:49] [indexer:background] Health check
[2024-01-03 19:45:26] [index:background] Health check
[2024-01-03 19:48:49] [indexer:background] Health check
[2024-01-03 19:50:31] [index:background] Health check
[2024-01-03 19:54:00] [indexer:background] Health check
[2024-01-03 19:55:25] [index:background] Health check
[2024-01-03 19:58:57] [indexer:background] Health check
[2024-01-03 20:00:27] [index:background] Health check
[2024-01-03 20:03:48] [indexer:background] Health check
[2024-01-03 20:05:28] [index:background] Health check
[2024-01-03 20:08:51] [indexer:background] Health check
[2024-01-03 20:10:26] [index:background] Health check
[2024-01-03 20:13:50] [indexer:background] Health check
[2024-01-03 20:13:55] [query] Query for: best toaster for sale
[2024-01-03 20:13:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 20:13:55] [query] Engine: default
[2024-01-03 20:13:56] [query] Tokens: sale, salit, salissantes, salées, salir, salée, salas, salai, sali, salés, salant, sala, sales, salé, foras, forant, foris, forées, fore, foré, fora, forer, forés, fores, best, toast, for, sal
[2024-01-03 20:13:56] [query] Mods: 6
[2024-01-03 20:13:56] [query] Trying AND logic
[2024-01-03 20:13:56] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-01-03 20:13:56] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-01-03 20:13:56] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-01-03 20:13:56] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-01-03 20:13:56] [query] Using OR logic
[2024-01-03 20:13:56] [query] Found results using: and logic
[2024-01-03 20: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 (17932,588293,494177,474456,473130,331213,203564,178421,76243,49830,652336,35093,26185,16699,453713,332908,262868,128801,84528,84185,54844,50244,31407,14848,50122,544847,7459,41833) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 20:13:56] [query] Results: 1041 Pages of results: 105
[2024-01-03 20:13:56] [query] Execution time: 1.02858
[2024-01-03 20:15:25] [index:background] Health check
[2024-01-03 20:19:59] [indexer:background] Health check
[2024-01-03 20:20:28] [index:background] Health check
[2024-01-03 20:24:40] [indexer:background] Health check
[2024-01-03 20:25:35] [index:background] Health check
[2024-01-03 20:28:49] [indexer:background] Health check
[2024-01-03 20:30:30] [index:background] Health check
[2024-01-03 20:33:48] [indexer:background] Health check
[2024-01-03 20:35:33] [index:background] Health check
[2024-01-03 20:38:50] [indexer:background] Health check
[2024-01-03 20:41:37] [index:background] Health check
[2024-01-03 20:43:52] [indexer:background] Health check
[2024-01-03 20:45:26] [index:background] Health check
[2024-01-03 20:45:42] [query] Query for: {search_term_string}
[2024-01-03 20:45:42] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 70 offset: 0 fields: all
[2024-01-03 20:45:42] [query] Engine: default
[2024-01-03 20:45:42] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-03 20:45:42] [query] Mods: 6
[2024-01-03 20:45:42] [query] Using OR logic
[2024-01-03 20:45:43] [query] Found results using: or logic
[2024-01-03 20:45: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 (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 690, 10
[2024-01-03 20:45:43] [query] Results: 1346 Pages of results: 135
[2024-01-03 20:45:43] [query] Execution time: 1.02647
[2024-01-03 20:48:59] [indexer:background] Health check
[2024-01-03 20:50:30] [index:background] Health check
[2024-01-03 20:53:49] [indexer:background] Health check
[2024-01-03 20:55:26] [index:background] Health check
[2024-01-03 20:58:54] [indexer:background] Health check
[2024-01-03 21:00:26] [index:background] Health check
[2024-01-03 21:03:48] [indexer:background] Health check
[2024-01-03 21:05:25] [index:background] Health check
[2024-01-03 21:08:49] [indexer:background] Health check
[2024-01-03 21:10:25] [index:background] Health check
[2024-01-03 21:13:58] [indexer:background] Health check
[2024-01-03 21:15:32] [index:background] Health check
[2024-01-03 21:17:23] [query] Query for: {search_term_string}
[2024-01-03 21:17:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 62 offset: 0 fields: all
[2024-01-03 21:17:23] [query] Engine: default
[2024-01-03 21:17:23] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-03 21:17:23] [query] Mods: 6
[2024-01-03 21:17:23] [query] Using OR logic
[2024-01-03 21:17:24] [query] Found results using: or logic
[2024-01-03 21:17: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 (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 610, 10
[2024-01-03 21:17:24] [query] Results: 1346 Pages of results: 135
[2024-01-03 21:17:24] [query] Execution time: 0.81693
[2024-01-03 21:18:49] [indexer:background] Health check
[2024-01-03 21:20:30] [index:background] Health check
[2024-01-03 21:23:52] [indexer:background] Health check
[2024-01-03 21:25:30] [index:background] Health check
[2024-01-03 21:28:55] [indexer:background] Health check
[2024-01-03 21:30:28] [index:background] Health check
[2024-01-03 21:33:49] [indexer:background] Health check
[2024-01-03 21:35:28] [index:background] Health check
[2024-01-03 21:38:49] [indexer:background] Health check
[2024-01-03 21:40:26] [index:background] Health check
[2024-01-03 21:43:52] [indexer:background] Health check
[2024-01-03 21:45:25] [index:background] Health check
[2024-01-03 21:49:04] [indexer:background] Health check
[2024-01-03 21:50:32] [index:background] Health check
[2024-01-03 21:53:55] [indexer:background] Health check
[2024-01-03 21:55:28] [index:background] Health check
[2024-01-03 21:56:29] [query] Query for: 2024
[2024-01-03 21:56:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 21:56:29] [query] Engine: default
[2024-01-03 21:56:29] [query] Tokens: 2024
[2024-01-03 21:56:29] [query] Mods: 6
[2024-01-03 21:56:29] [query] Found results using: or logic
[2024-01-03 21:56:29] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 21:56:29] [query] Results: 132 Pages of results: 14
[2024-01-03 21:56:29] [query] Execution time: 0.55139
[2024-01-03 21:58:50] [indexer:background] Health check
[2024-01-03 22:00:29] [index:background] Health check
[2024-01-03 22:03:52] [indexer:background] Health check
[2024-01-03 22:05:31] [index:background] Health check
[2024-01-03 22:06:12] [query] Query for: 2024
[2024-01-03 22:06:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 22:06:12] [query] Engine: default
[2024-01-03 22:06:12] [query] Tokens: 2024
[2024-01-03 22:06:12] [query] Mods: 6
[2024-01-03 22:06:12] [query] Found results using: or logic
[2024-01-03 22:06: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 22:06:12] [query] Results: 132 Pages of results: 14
[2024-01-03 22:06:12] [query] Execution time: 0.03822
[2024-01-03 22:08:48] [indexer:background] Health check
[2024-01-03 22:10:28] [index:background] Health check
[2024-01-03 22:13:48] [indexer:background] Health check
[2024-01-03 22:15:27] [index:background] Health check
[2024-01-03 22:17:23] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2024-01-03 22:17:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 89 offset: 0 fields: all
[2024-01-03 22:17:23] [query] Engine: default
[2024-01-03 22:17:24] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2024-01-03 22:17:24] [query] Mods: 6
[2024-01-03 22:17:24] [query] Using OR logic
[2024-01-03 22:17:24] [query] Found results using: or logic
[2024-01-03 22:17: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 (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 880, 10
[2024-01-03 22:17:24] [query] Results: 894 Pages of results: 90
[2024-01-03 22:17:24] [query] Execution time: 0.97427
[2024-01-03 22:18:57] [indexer:background] Health check
[2024-01-03 22:20:36] [index:background] Health check
[2024-01-03 22:23:52] [indexer:background] Health check
[2024-01-03 22:26:27] [index:background] Health check
[2024-01-03 22:29:01] [indexer:background] Health check
[2024-01-03 22:30:25] [index:background] Health check
[2024-01-03 22:33:57] [indexer:background] Health check
[2024-01-03 22:35:37] [index:background] Health check
[2024-01-03 22:38:49] [indexer:background] Health check
[2024-01-03 22:40:32] [index:background] Health check
[2024-01-03 22:43:56] [indexer:background] Health check
[2024-01-03 22:45:29] [index:background] Health check
[2024-01-03 22:48:50] [indexer:background] Health check
[2024-01-03 22:50:30] [index:background] Health check
[2024-01-03 22:53:55] [indexer:background] Health check
[2024-01-03 22:55:30] [index:background] Health check
[2024-01-03 22:59:03] [indexer:background] Health check
[2024-01-03 23:00:37] [index:background] Health check
[2024-01-03 23:03:53] [indexer:background] Health check
[2024-01-03 23:05:28] [index:background] Health check
[2024-01-03 23:09:00] [indexer:background] Health check
[2024-01-03 23:10:25] [index:background] Health check
[2024-01-03 23:11:16] [query] Query for: arrete-n�-12914_2014_finance-publique-impots-et-douanes_tresorerie-paierie-generale.pdf
[2024-01-03 23:11:16] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 23:11:16] [query] Engine: default
[2024-01-03 23:11:17] [query] Tokens: paieries, finance, financer, financa, financée, financé, finançant, financant, financez, financera, financeront, financie, financs, financi, impots, paierie, financements, paieri, publiques, publique, publication, publications, publiquea, publicité, publicités, publiquement, publiqua, publiqui, publicateur, tresorerie, tresoreries, arrete, arrets, arreta, arrété, arreté, arretera, arreteront, arrèté, arretant, arrétées, arretea, arrète, finances, arreter, arréter, arretie, arrèt, arréte, douanes, douane, douanement, douani, douanies, arretes, douans, financées, financés, financement, arret, n�, 12914, 2014, financ, publiqu, impot, douan
[2024-01-03 23:11:17] [query] Mods: 6
[2024-01-03 23:11:17] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2024-01-03 23:11:17] [query] Using OR logic
[2024-01-03 23:11:24] [query] Found results using: or logic
[2024-01-03 23:11: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 (473752,1221,8804,10800,15019,27032,27653,28790,34790,38664,147650,178508,418789,507839,4762,108725,8009,751413,866,1043,4943,5187,10823,13418,49505,77759,711996,763135,784579,17134,376646,17551,45128,51347,69901,69934,130628,219790,353841,376604,478327,503204,514969,922,28780,575556,586210,689535,799275,526,636,22019,245023,700272,4766,737898,221,799,858,2865,770525,484734,1361,690302,692852,16968,709775) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 23:11:24] [query] Results: 3804 Pages of results: 381
[2024-01-03 23:11:24] [query] Execution time: 7.61590
[2024-01-03 23:11:24] [query] Query for: arrete-n�-12914_2014_finance-publique-impots-et-douanes_tresorerie-paierie-generale.pdf
[2024-01-03 23:11:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-03 23:11:24] [query] Engine: default
[2024-01-03 23:11:24] [query] Tokens: paieries, finance, financer, financa, financée, financé, finançant, financant, financez, financera, financeront, financie, financs, financi, impots, paierie, financements, paieri, publiques, publique, publication, publications, publiquea, publicité, publicités, publiquement, publiqua, publiqui, publicateur, tresorerie, tresoreries, arrete, arrets, arreta, arrété, arreté, arretera, arreteront, arrèté, arretant, arrétées, arretea, arrète, finances, arreter, arréter, arretie, arrèt, arréte, douanes, douane, douanement, douani, douanies, arretes, douans, financées, financés, financement, arret, n�, 12914, 2014, financ, publiqu, impot, douan
[2024-01-03 23:11:24] [query] Mods: 6
[2024-01-03 23:11:24] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2024-01-03 23:11:24] [query] Using OR logic
[2024-01-03 23:11:29] [query] Found results using: or logic
[2024-01-03 23:11:29] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (473752,1221,8804,10800,15019,27032,27653,28790,34790,38664,147650,178508,418789,507839,4762,108725,8009,751413,866,1043,4943,5187,10823,13418,49505,77759,711996,763135,784579,17134,376646,17551,45128,51347,69901,69934,130628,219790,353841,376604,478327,503204,514969,922,28780,575556,586210,689535,799275,526,636,22019,245023,700272,4766,737898,221,799,858,2865,770525,484734,1361,690302,692852,16968,709775) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-03 23:11:29] [query] Results: 3804 Pages of results: 39
[2024-01-03 23:11:29] [query] Execution time: 5.62091
[2024-01-03 23:14:37] [indexer:background] Health check
[2024-01-03 23:15:32] [index:background] Health check
[2024-01-03 23:18:50] [indexer:background] Health check
[2024-01-03 23:20:29] [index:background] Health check
[2024-01-03 23:24:05] [indexer:background] Health check
[2024-01-03 23:25:26] [index:background] Health check
[2024-01-03 23:28:59] [indexer:background] Health check
[2024-01-03 23:30:27] [index:background] Health check
[2024-01-03 23:33:53] [indexer:background] Health check
[2024-01-03 23:35:38] [index:background] Health check
[2024-01-03 23:38:55] [indexer:background] Health check
[2024-01-03 23:40:30] [index:background] Health check
[2024-01-03 23:43:47] [indexer:background] Health check
[2024-01-03 23:45:26] [index:background] Health check
[2024-01-03 23:48:49] [indexer:background] Health check
[2024-01-03 23:50:27] [index:background] Health check
[2024-01-03 23:52:17] [query] Query for: 2024
[2024-01-03 23:52:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-03 23:52:17] [query] Engine: default
[2024-01-03 23:52:17] [query] Tokens: 2024
[2024-01-03 23:52:17] [query] Mods: 6
[2024-01-03 23:52:17] [query] Found results using: or logic
[2024-01-03 23:52: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-03 23:52:17] [query] Results: 132 Pages of results: 14
[2024-01-03 23:52:17] [query] Execution time: 0.04620
[2024-01-03 23:53:51] [indexer:background] Health check
[2024-01-03 23:55:29] [index:background] Health check
[2024-01-03 23:58:52] [indexer:background] Health check