[2023-10-23 00:01:39] [indexer:background] Health check
[2023-10-23 00:04:14] [index:background] Health check
[2023-10-23 00:07:58] [indexer:background] Health check
[2023-10-23 00:08:37] [index:background] Health check
[2023-10-23 00:11:47] [indexer:background] Health check
[2023-10-23 00:13:04] [index:background] Health check
[2023-10-23 00:17:06] [indexer:background] Health check
[2023-10-23 00:21:55] [index:background] Health check
[2023-10-23 00:21:55] [indexer:background] Health check
[2023-10-23 00:21:55] [indexer:background] Health check
[2023-10-23 00:23:21] [index:background] Health check
[2023-10-23 00:30:40] [indexer:background] Health check
[2023-10-23 00:30:42] [index:background] Health check
[2023-10-23 00:33:28] [indexer:background] Health check
[2023-10-23 00:33:28] [index:background] Health check
[2023-10-23 00:39:20] [indexer:background] Health check
[2023-10-23 00:39:20] [index:background] Health check
[2023-10-23 00:46:11] [indexer:background] Health check
[2023-10-23 00:46:11] [index:background] Health check
[2023-10-23 00:47:13] [indexer:background] Health check
[2023-10-23 00:48:52] [index:background] Health check
[2023-10-23 00:51:46] [query] Query for: search_term_string
[2023-10-23 00:51:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 00:51:46] [query] Engine: default
[2023-10-23 00:51:47] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-10-23 00:51:47] [query] Mods: 6
[2023-10-23 00:51:47] [query] Using OR logic
[2023-10-23 00:51:47] [indexer:background] Health check
[2023-10-23 00:51:48] [query] Found results using: or logic
[2023-10-23 00:51:48] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 00:51:48] [query] Results: 1344 Pages of results: 135
[2023-10-23 00:51:48] [query] Execution time: 1.30589
[2023-10-23 00:54:11] [index:background] Health check
[2023-10-23 00:57:00] [indexer:background] Health check
[2023-10-23 00:58:36] [index:background] Health check
[2023-10-23 01:02:28] [indexer:background] Health check
[2023-10-23 01:03:46] [index:background] Health check
[2023-10-23 01:06:41] [indexer:background] Health check
[2023-10-23 01:08:17] [index:background] Health check
[2023-10-23 01:12:08] [indexer:background] Health check
[2023-10-23 01:14:21] [index:background] Health check
[2023-10-23 01:18:30] [indexer:background] Health check
[2023-10-23 01:18:30] [index:background] Health check
[2023-10-23 01:22:29] [indexer:background] Health check
[2023-10-23 01:23:30] [index:background] Health check
[2023-10-23 01:27:36] [indexer:background] Health check
[2023-10-23 01:31:10] [index:background] Health check
[2023-10-23 01:31:48] [indexer:background] Health check
[2023-10-23 01:31:48] [query] Query for: 2023
[2023-10-23 01:31:48] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 01:31:48] [query] Engine: default
[2023-10-23 01:31:48] [query] Tokens: 2023
[2023-10-23 01:31:48] [query] Mods: 6
[2023-10-23 01:31:48] [query] Found results using: or logic
[2023-10-23 01:31:49] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 01:31:49] [query] Results: 249 Pages of results: 25
[2023-10-23 01:31:49] [query] Execution time: 0.28502
[2023-10-23 01:31:49] [query] Query for: 2023
[2023-10-23 01:31:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-23 01:31:49] [query] Engine: default
[2023-10-23 01:31:49] [query] Tokens: 2023
[2023-10-23 01:31:49] [query] Mods: 6
[2023-10-23 01:31:49] [query] Found results using: or logic
[2023-10-23 01:31:49] [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
[2023-10-23 01:31:49] [query] Results: 249 Pages of results: 3
[2023-10-23 01:31:49] [query] Execution time: 0.10356
[2023-10-23 01:38:40] [index:background] Health check
[2023-10-23 01:38:40] [indexer:background] Health check
[2023-10-23 01:38:40] [indexer:background] Health check
[2023-10-23 01:43:38] [indexer:background] Health check
[2023-10-23 01:43:39] [index:background] Health check
[2023-10-23 01:46:48] [indexer:background] Health check
[2023-10-23 01:48:06] [index:background] Health check
[2023-10-23 01:53:21] [indexer:background] Health check
[2023-10-23 01:53:21] [index:background] Health check
[2023-10-23 01:56:48] [indexer:background] Health check
[2023-10-23 01:58:47] [index:background] Health check
[2023-10-23 02:02:13] [indexer:background] Health check
[2023-10-23 02:03:32] [index:background] Health check
[2023-10-23 02:07:50] [indexer:background] Health check
[2023-10-23 02:08:45] [index:background] Health check
[2023-10-23 02:12:20] [indexer:background] Health check
[2023-10-23 02:12:20] [indexer:background] Health check
[2023-10-23 02:14:53] [index:background] Health check
[2023-10-23 02:17:35] [indexer:background] Health check
[2023-10-23 02:18:16] [index:background] Health check
[2023-10-23 02:26:42] [indexer:background] Health check
[2023-10-23 02:26:42] [index:background] Health check
[2023-10-23 02:27:07] [indexer:background] Health check
[2023-10-23 02:28:35] [index:background] Health check
[2023-10-23 02:32:41] [indexer:background] Health check
[2023-10-23 02:33:08] [index:background] Health check
[2023-10-23 02:37:25] [indexer:background] Health check
[2023-10-23 02:37:25] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2]
[2023-10-23 02:39:45] [index:background] Health check
[2023-10-23 02:39:45] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-10-23 02:39:47] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-10-23 02:49:30] [indexer:background] Health check
[2023-10-23 02:49:30] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2]
[2023-10-23 02:49:32] [index:background] Health check
[2023-10-23 02:49:32] [index:background] CPU load threshold (3) breached: 3.33 [waiting 2]
[2023-10-23 02:49:34] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2023-10-23 02:53:31] [indexer:background] Health check
[2023-10-23 02:53:31] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2023-10-23 02:53:33] [index:background] Health check
[2023-10-23 02:53:33] [index:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2023-10-23 02:53:35] [indexer:background] CPU load threshold (3) breached: 3.66 [waiting 2]
[2023-10-23 02:58:49] [indexer:background] Health check
[2023-10-23 02:58:49] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-10-23 02:58:51] [index:background] Health check
[2023-10-23 02:58:51] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-23 02:58:53] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-23 03:02:58] [indexer:background] Health check
[2023-10-23 03:02:58] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2]
[2023-10-23 03:03:16] [index:background] Health check
[2023-10-23 03:03:16] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-10-23 03:03:18] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2023-10-23 03:10:37] [indexer:background] Health check
[2023-10-23 03:10:37] [indexer:background] CPU load threshold (3) breached: 4.11 [waiting 2]
[2023-10-23 03:10:39] [index:background] Health check
[2023-10-23 03:10:39] [index:background] CPU load threshold (3) breached: 4.11 [waiting 2]
[2023-10-23 03:10:41] [indexer:background] CPU load threshold (3) breached: 4.27 [waiting 2]
[2023-10-23 03:11:53] [indexer:background] Health check
[2023-10-23 03:11:53] [indexer:background] CPU load threshold (3) breached: 4.45 [waiting 2]
[2023-10-23 03:13:27] [index:background] Health check
[2023-10-23 03:13:27] [index:background] CPU load threshold (3) breached: 3.73 [waiting 2]
[2023-10-23 03:13:30] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2]
[2023-10-23 03:17:31] [indexer:background] Health check
[2023-10-23 03:17:31] [indexer:background] CPU load threshold (3) breached: 4.29 [waiting 2]
[2023-10-23 03:19:48] [index:background] Health check
[2023-10-23 03:19:48] [index:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2023-10-23 03:19:50] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2023-10-23 03:23:19] [indexer:background] Health check
[2023-10-23 03:23:19] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2]
[2023-10-23 03:23:21] [index:background] Health check
[2023-10-23 03:23:21] [index:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-10-23 03:23:23] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-10-23 03:27:50] [indexer:background] Health check
[2023-10-23 03:30:45] [index:background] Health check
[2023-10-23 03:30:45] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2023-10-23 03:30:47] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-10-23 03:33:21] [indexer:background] Health check
[2023-10-23 03:33:21] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2]
[2023-10-23 03:33:23] [index:background] Health check
[2023-10-23 03:33:23] [index:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-10-23 03:33:25] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-10-23 03:41:51] [indexer:background] Health check
[2023-10-23 03:41:51] [indexer:background] CPU load threshold (3) breached: 5.17 [waiting 2]
[2023-10-23 03:41:53] [index:background] Health check
[2023-10-23 03:41:53] [index:background] CPU load threshold (3) breached: 5.23 [waiting 2]
[2023-10-23 03:41:55] [indexer:background] CPU load threshold (3) breached: 5.23 [waiting 2]
[2023-10-23 03:46:06] [index:background] Health check
[2023-10-23 03:47:06] [indexer:background] Health check
[2023-10-23 03:48:04] [index:background] Health check
[2023-10-23 03:53:10] [indexer:background] Health check
[2023-10-23 03:53:10] [index:background] Health check
[2023-10-23 03:55:47] [query] Query for: search_term_string
[2023-10-23 03:55:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 03:55:47] [query] Engine: default
[2023-10-23 03:55:47] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-10-23 03:55:47] [query] Mods: 6
[2023-10-23 03:55:47] [query] Using OR logic
[2023-10-23 03:55:47] [query] Found results using: or logic
[2023-10-23 03:55: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 (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 03:55:47] [query] Results: 1344 Pages of results: 135
[2023-10-23 03:55:47] [query] Execution time: 0.05956
[2023-10-23 03:57:35] [indexer:background] Health check
[2023-10-23 03:58:22] [index:background] Health check
[2023-10-23 04:02:14] [indexer:background] Health check
[2023-10-23 04:03:04] [index:background] Health check
[2023-10-23 04:07:19] [indexer:background] Health check
[2023-10-23 04:08:29] [index:background] Health check
[2023-10-23 04:14:14] [indexer:background] Health check
[2023-10-23 04:14:14] [index:background] Health check
[2023-10-23 04:17:25] [indexer:background] Health check
[2023-10-23 04:18:04] [index:background] Health check
[2023-10-23 04:21:59] [indexer:background] Health check
[2023-10-23 04:23:48] [index:background] Health check
[2023-10-23 04:23:48] [index:background] CPU load threshold (3) breached: 11.47 [waiting 2]
[2023-10-23 04:23:50] [indexer:background] CPU load threshold (3) breached: 10.63 [waiting 2]
[2023-10-23 04:26:58] [indexer:background] Health check
[2023-10-23 04:28:08] [index:background] Health check
[2023-10-23 04:32:07] [indexer:background] Health check
[2023-10-23 04:33:23] [index:background] Health check
[2023-10-23 04:37:01] [indexer:background] Health check
[2023-10-23 04:38:18] [index:background] Health check
[2023-10-23 04:42:33] [indexer:background] Health check
[2023-10-23 04:44:06] [index:background] Health check
[2023-10-23 04:47:26] [indexer:background] Health check
[2023-10-23 04:48:04] [index:background] Health check
[2023-10-23 04:54:52] [indexer:background] Health check
[2023-10-23 04:54:52] [index:background] Health check
[2023-10-23 04:57:59] [indexer:background] Health check
[2023-10-23 04:58:29] [index:background] Health check
[2023-10-23 05:04:00] [indexer:background] Health check
[2023-10-23 05:04:00] [index:background] Health check
[2023-10-23 05:08:18] [indexer:background] Health check
[2023-10-23 05:08:18] [index:background] Health check
[2023-10-23 05:12:39] [indexer:background] Health check
[2023-10-23 05:13:54] [index:background] Health check
[2023-10-23 05:16:58] [indexer:background] Health check
[2023-10-23 05:18:02] [index:background] Health check
[2023-10-23 05:23:34] [indexer:background] Health check
[2023-10-23 05:23:34] [index:background] Health check
[2023-10-23 05:28:17] [indexer:background] Health check
[2023-10-23 05:28:17] [index:background] Health check
[2023-10-23 05:34:33] [indexer:background] Health check
[2023-10-23 05:34:33] [index:background] Health check
[2023-10-23 05:38:46] [indexer:background] Health check
[2023-10-23 05:38:46] [index:background] Health check
[2023-10-23 05:42:00] [indexer:background] Health check
[2023-10-23 05:43:29] [index:background] Health check
[2023-10-23 05:47:29] [indexer:background] Health check
[2023-10-23 05:48:19] [index:background] Health check
[2023-10-23 05:53:06] [indexer:background] Health check
[2023-10-23 05:53:06] [index:background] Health check
[2023-10-23 05:58:25] [indexer:background] Health check
[2023-10-23 05:58:25] [index:background] Health check
[2023-10-23 06:03:00] [indexer:background] Health check
[2023-10-23 06:04:13] [index:background] Health check
[2023-10-23 06:07:28] [indexer:background] Health check
[2023-10-23 06:08:11] [index:background] Health check
[2023-10-23 06:11:57] [indexer:background] Health check
[2023-10-23 06:14:01] [index:background] Health check
[2023-10-23 06:16:57] [indexer:background] Health check
[2023-10-23 06:18:27] [index:background] Health check
[2023-10-23 06:22:04] [indexer:background] Health check
[2023-10-23 06:23:32] [index:background] Health check
[2023-10-23 06:27:02] [indexer:background] Health check
[2023-10-23 06:29:04] [index:background] Health check
[2023-10-23 06:33:27] [indexer:background] Health check
[2023-10-23 06:33:27] [index:background] Health check
[2023-10-23 06:37:07] [indexer:background] Health check
[2023-10-23 06:38:32] [index:background] Health check
[2023-10-23 06:41:53] [indexer:background] Health check
[2023-10-23 06:43:14] [index:background] Health check
[2023-10-23 06:47:27] [indexer:background] Health check
[2023-10-23 06:48:04] [index:background] Health check
[2023-10-23 06:51:55] [indexer:background] Health check
[2023-10-23 06:54:22] [index:background] Health check
[2023-10-23 06:59:05] [indexer:background] Health check
[2023-10-23 06:59:05] [index:background] Health check
[2023-10-23 07:02:14] [indexer:background] Health check
[2023-10-23 07:03:43] [index:background] Health check
[2023-10-23 07:07:30] [indexer:background] Health check
[2023-10-23 07:08:34] [index:background] Health check
[2023-10-23 07:11:54] [indexer:background] Health check
[2023-10-23 07:13:23] [index:background] Health check
[2023-10-23 07:17:16] [indexer:background] Health check
[2023-10-23 07:18:04] [index:background] Health check
[2023-10-23 07:22:50] [indexer:background] Health check
[2023-10-23 07:23:08] [index:background] Health check
[2023-10-23 07:27:14] [indexer:background] Health check
[2023-10-23 07:29:03] [index:background] Health check
[2023-10-23 07:32:52] [indexer:background] Health check
[2023-10-23 07:34:44] [index:background] Health check
[2023-10-23 07:36:52] [indexer:background] Health check
[2023-10-23 07:38:51] [index:background] Health check
[2023-10-23 07:42:50] [indexer:background] Health check
[2023-10-23 07:43:54] [index:background] Health check
[2023-10-23 07:47:08] [indexer:background] Health check
[2023-10-23 07:48:03] [index:background] Health check
[2023-10-23 07:54:59] [indexer:background] Health check
[2023-10-23 07:54:59] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2023-10-23 07:55:01] [index:background] Health check
[2023-10-23 07:55:01] [index:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2023-10-23 07:55:03] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2023-10-23 07:58:56] [indexer:background] Health check
[2023-10-23 07:58:56] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-10-23 07:58:58] [index:background] Health check
[2023-10-23 07:58:58] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-10-23 08:04:31] [indexer:background] Health check
[2023-10-23 08:04:31] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 08:04:33] [index:background] Health check
[2023-10-23 08:04:33] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 08:04:35] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 08:07:42] [indexer:background] Health check
[2023-10-23 08:07:42] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2023-10-23 08:08:53] [index:background] Health check
[2023-10-23 08:08:53] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2023-10-23 08:08:55] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2023-10-23 08:12:12] [indexer:background] Health check
[2023-10-23 08:13:20] [index:background] Health check
[2023-10-23 08:21:52] [indexer:background] Health check
[2023-10-23 08:21:52] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-10-23 08:21:54] [index:background] Health check
[2023-10-23 08:21:54] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-10-23 08:21:56] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-23 08:23:54] [index:background] Health check
[2023-10-23 08:23:54] [index:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-10-23 08:27:44] [indexer:background] Health check
[2023-10-23 08:27:44] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2023-10-23 08:29:23] [index:background] Health check
[2023-10-23 08:29:23] [index:background] CPU load threshold (3) breached: 3.18 [waiting 2]
[2023-10-23 08:29:25] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2]
[2023-10-23 08:32:34] [indexer:background] Health check
[2023-10-23 08:33:32] [index:background] Health check
[2023-10-23 08:37:20] [indexer:background] Health check
[2023-10-23 08:37:20] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-23 08:38:04] [index:background] Health check
[2023-10-23 08:38:04] [index:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-10-23 08:38:06] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2023-10-23 08:42:24] [indexer:background] Health check
[2023-10-23 08:42:24] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2]
[2023-10-23 08:43:04] [index:background] Health check
[2023-10-23 08:43:04] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2023-10-23 08:43:06] [indexer:background] CPU load threshold (3) breached: 3.8 [waiting 2]
[2023-10-23 08:46:55] [indexer:background] Health check
[2023-10-23 08:46:55] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2023-10-23 08:49:19] [index:background] Health check
[2023-10-23 08:52:06] [indexer:background] Health check
[2023-10-23 08:52:06] [indexer:background] CPU load threshold (3) breached: 4.15 [waiting 2]
[2023-10-23 08:53:20] [index:background] Health check
[2023-10-23 08:53:20] [index:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-10-23 08:53:22] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2]
[2023-10-23 08:56:53] [indexer:background] Health check
[2023-10-23 08:56:53] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-10-23 08:58:20] [index:background] Health check
[2023-10-23 09:00:12] [query] Query for: 2024
[2023-10-23 09:00:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 09:00:12] [query] Engine: default
[2023-10-23 09:00:13] [query] Tokens: 2024
[2023-10-23 09:00:13] [query] Mods: 6
[2023-10-23 09:00:14] [query] Found results using: or logic
[2023-10-23 09:00:14] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 09:00:14] [query] Results: 129 Pages of results: 13
[2023-10-23 09:00:14] [query] Execution time: 1.12622
[2023-10-23 09:00:14] [query] Query for: 2024
[2023-10-23 09:00:14] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-23 09:00:14] [query] Engine: default
[2023-10-23 09:00:14] [query] Tokens: 2024
[2023-10-23 09:00:14] [query] Mods: 6
[2023-10-23 09:00:14] [query] Found results using: or logic
[2023-10-23 09:00:14] [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
[2023-10-23 09:00:14] [query] Results: 129 Pages of results: 2
[2023-10-23 09:00:14] [query] Execution time: 0.08286
[2023-10-23 09:02:40] [indexer:background] Health check
[2023-10-23 09:04:08] [index:background] Health check
[2023-10-23 09:07:03] [indexer:background] Health check
[2023-10-23 09:08:31] [index:background] Health check
[2023-10-23 09:12:03] [indexer:background] Health check
[2023-10-23 09:12:03] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-10-23 09:13:44] [index:background] Health check
[2023-10-23 09:17:06] [indexer:background] Health check
[2023-10-23 09:17:06] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-10-23 09:18:20] [index:background] Health check
[2023-10-23 09:22:19] [indexer:background] Health check
[2023-10-23 09:22:19] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2023-10-23 09:23:33] [index:background] Health check
[2023-10-23 09:23:33] [index:background] CPU load threshold (3) breached: 3.4 [waiting 2]
[2023-10-23 09:23:35] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2]
[2023-10-23 09:27:02] [indexer:background] Health check
[2023-10-23 09:28:16] [index:background] Health check
[2023-10-23 09:28:16] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-23 09:28:18] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2]
[2023-10-23 09:32:08] [indexer:background] Health check
[2023-10-23 09:32:08] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-10-23 09:33:31] [index:background] Health check
[2023-10-23 09:33:31] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-10-23 09:33:33] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-10-23 09:36:59] [indexer:background] Health check
[2023-10-23 09:36:59] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2]
[2023-10-23 09:38:16] [index:background] Health check
[2023-10-23 09:38:16] [index:background] CPU load threshold (3) breached: 3.84 [waiting 2]
[2023-10-23 09:38:18] [indexer:background] CPU load threshold (3) breached: 3.84 [waiting 2]
[2023-10-23 09:42:06] [indexer:background] Health check
[2023-10-23 09:42:06] [indexer:background] CPU load threshold (3) breached: 3.59 [waiting 2]
[2023-10-23 09:44:18] [index:background] Health check
[2023-10-23 09:47:13] [indexer:background] Health check
[2023-10-23 09:48:19] [index:background] Health check
[2023-10-23 09:51:54] [indexer:background] Health check
[2023-10-23 09:54:03] [index:background] Health check
[2023-10-23 09:54:03] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-10-23 09:54:05] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-23 09:57:35] [indexer:background] Health check
[2023-10-23 09:58:49] [index:background] Health check
[2023-10-23 10:01:54] [indexer:background] Health check
[2023-10-23 10:01:54] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2023-10-23 10:03:10] [index:background] Health check
[2023-10-23 10:03:10] [index:background] CPU load threshold (3) breached: 3.49 [waiting 2]
[2023-10-23 10:03:12] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2023-10-23 10:07:58] [indexer:background] Health check
[2023-10-23 10:08:04] [index:background] Health check
[2023-10-23 10:12:26] [indexer:background] Health check
[2023-10-23 10:13:10] [index:background] Health check
[2023-10-23 10:17:09] [indexer:background] Health check
[2023-10-23 10:18:12] [index:background] Health check
[2023-10-23 10:22:05] [indexer:background] Health check
[2023-10-23 10:24:06] [index:background] Health check
[2023-10-23 10:24:06] [index:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-10-23 10:24:08] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-10-23 10:27:45] [indexer:background] Health check
[2023-10-23 10:28:07] [index:background] Health check
[2023-10-23 10:31:52] [indexer:background] Health check
[2023-10-23 10:31:52] [indexer:background] CPU load threshold (3) breached: 4.02 [waiting 2]
[2023-10-23 10:34:02] [index:background] Health check
[2023-10-23 10:37:07] [indexer:background] Health check
[2023-10-23 10:38:02] [index:background] Health check
[2023-10-23 10:42:51] [indexer:background] Health check
[2023-10-23 10:43:31] [index:background] Health check
[2023-10-23 10:47:33] [indexer:background] Health check
[2023-10-23 10:49:38] [index:background] Health check
[2023-10-23 10:52:57] [indexer:background] Health check
[2023-10-23 10:56:14] [index:background] Health check
[2023-10-23 10:57:00] [indexer:background] Health check
[2023-10-23 10:58:21] [index:background] Health check
[2023-10-23 11:01:51] [indexer:background] Health check
[2023-10-23 11:03:46] [index:background] Health check
[2023-10-23 11:06:59] [indexer:background] Health check
[2023-10-23 11:08:25] [index:background] Health check
[2023-10-23 11:14:55] [indexer:background] Health check
[2023-10-23 11:14:55] [index:background] Health check
[2023-10-23 11:17:34] [indexer:background] Health check
[2023-10-23 11:18:27] [index:background] Health check
[2023-10-23 11:22:38] [indexer:background] Health check
[2023-10-23 11:23:24] [index:background] Health check
[2023-10-23 11:27:46] [indexer:background] Health check
[2023-10-23 11:27:46] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-10-23 11:28:35] [index:background] Health check
[2023-10-23 11:28:36] [index:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-10-23 11:28:38] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-10-23 11:32:43] [indexer:background] Health check
[2023-10-23 11:32:43] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2023-10-23 11:33:47] [index:background] Health check
[2023-10-23 11:37:52] [indexer:background] Health check
[2023-10-23 11:38:16] [index:background] Health check
[2023-10-23 11:41:57] [indexer:background] Health check
[2023-10-23 11:43:20] [index:background] Health check
[2023-10-23 11:46:52] [indexer:background] Health check
[2023-10-23 11:48:58] [index:background] Health check
[2023-10-23 11:53:10] [indexer:background] Health check
[2023-10-23 11:53:10] [index:background] Health check
[2023-10-23 11:57:37] [indexer:background] Health check
[2023-10-23 11:58:52] [index:background] Health check
[2023-10-23 12:01:51] [indexer:background] Health check
[2023-10-23 12:03:23] [index:background] Health check
[2023-10-23 12:03:23] [index:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2023-10-23 12:03:25] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2023-10-23 12:07:00] [indexer:background] Health check
[2023-10-23 12:08:56] [index:background] Health check
[2023-10-23 12:12:13] [indexer:background] Health check
[2023-10-23 12:13:07] [index:background] Health check
[2023-10-23 12:16:55] [indexer:background] Health check
[2023-10-23 12:18:10] [index:background] Health check
[2023-10-23 12:22:52] [indexer:background] Health check
[2023-10-23 12:22:52] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2]
[2023-10-23 12:23:08] [index:background] Health check
[2023-10-23 12:23:08] [index:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2023-10-23 12:23:10] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2023-10-23 12:26:54] [indexer:background] Health check
[2023-10-23 12:28:33] [index:background] Health check
[2023-10-23 12:33:22] [indexer:background] Health check
[2023-10-23 12:33:22] [index:background] Health check
[2023-10-23 12:37:00] [indexer:background] Health check
[2023-10-23 12:38:18] [index:background] Health check
[2023-10-23 12:38:18] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 12:38:20] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 12:41:58] [indexer:background] Health check
[2023-10-23 12:43:57] [index:background] Health check
[2023-10-23 12:43:57] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-23 12:43:59] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-10-23 12:47:23] [indexer:background] Health check
[2023-10-23 12:47:23] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-10-23 12:50:48] [index:background] Health check
[2023-10-23 12:50:48] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-10-23 12:50:50] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-10-23 12:52:30] [indexer:background] Health check
[2023-10-23 12:52:30] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-10-23 12:53:06] [index:background] Health check
[2023-10-23 12:59:12] [indexer:background] Health check
[2023-10-23 12:59:12] [index:background] Health check
[2023-10-23 13:03:48] [indexer:background] Health check
[2023-10-23 13:03:48] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-10-23 13:03:50] [index:background] Health check
[2023-10-23 13:03:50] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-23 13:03:52] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-23 13:07:01] [indexer:background] Health check
[2023-10-23 13:08:30] [index:background] Health check
[2023-10-23 13:13:08] [indexer:background] Health check
[2023-10-23 13:13:08] [index:background] Health check
[2023-10-23 13:17:43] [indexer:background] Health check
[2023-10-23 13:18:52] [index:background] Health check
[2023-10-23 13:18:52] [index:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-10-23 13:18:54] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2023-10-23 13:23:35] [indexer:background] Health check
[2023-10-23 13:23:35] [index:background] Health check
[2023-10-23 13:27:08] [indexer:background] Health check
[2023-10-23 13:28:12] [index:background] Health check
[2023-10-23 13:28:12] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2023-10-23 13:28:14] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2023-10-23 13:32:54] [indexer:background] Health check
[2023-10-23 13:32:54] [indexer:background] CPU load threshold (3) breached: 3.86 [waiting 2]
[2023-10-23 13:33:54] [index:background] Health check
[2023-10-23 13:38:59] [indexer:background] Health check
[2023-10-23 13:38:59] [index:background] Health check
[2023-10-23 13:43:54] [indexer:background] Health check
[2023-10-23 13:43:54] [indexer:background] CPU load threshold (3) breached: 4.05 [waiting 2]
[2023-10-23 13:43:56] [index:background] Health check
[2023-10-23 13:43:56] [index:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2023-10-23 13:43:58] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2023-10-23 13:47:18] [indexer:background] Health check
[2023-10-23 13:48:34] [index:background] Health check
[2023-10-23 13:52:08] [indexer:background] Health check
[2023-10-23 13:54:55] [index:background] Health check
[2023-10-23 13:56:57] [indexer:background] Health check
[2023-10-23 13:56:57] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2]
[2023-10-23 13:58:16] [index:background] Health check
[2023-10-23 14:04:25] [indexer:background] Health check
[2023-10-23 14:04:25] [index:background] Health check
[2023-10-23 14:08:29] [indexer:background] Health check
[2023-10-23 14:08:30] [index:background] Health check
[2023-10-23 14:12:38] [indexer:background] Health check
[2023-10-23 14:13:23] [index:background] Health check
[2023-10-23 14:17:56] [indexer:background] Health check
[2023-10-23 14:18:06] [index:background] Health check
[2023-10-23 14:22:58] [indexer:background] Health check
[2023-10-23 14:23:08] [index:background] Health check
[2023-10-23 14:27:02] [indexer:background] Health check
[2023-10-23 14:28:04] [index:background] Health check
[2023-10-23 14:31:52] [indexer:background] Health check
[2023-10-23 14:31:52] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2]
[2023-10-23 14:33:05] [index:background] Health check
[2023-10-23 14:33:05] [index:background] CPU load threshold (3) breached: 3.84 [waiting 2]
[2023-10-23 14:33:07] [indexer:background] CPU load threshold (3) breached: 3.84 [waiting 2]
[2023-10-23 14:36:53] [indexer:background] Health check
[2023-10-23 14:36:53] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2023-10-23 14:38:03] [index:background] Health check
[2023-10-23 14:38:03] [index:background] CPU load threshold (3) breached: 3.7 [waiting 2]
[2023-10-23 14:38:05] [indexer:background] CPU load threshold (3) breached: 3.7 [waiting 2]
[2023-10-23 14:41:52] [indexer:background] Health check
[2023-10-23 14:41:52] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2]
[2023-10-23 14:43:04] [index:background] Health check
[2023-10-23 14:43:04] [index:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-10-23 14:43:06] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2023-10-23 14:46:52] [indexer:background] Health check
[2023-10-23 14:46:52] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2023-10-23 14:48:04] [index:background] Health check
[2023-10-23 14:52:53] [indexer:background] Health check
[2023-10-23 14:52:53] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2023-10-23 14:53:05] [index:background] Health check
[2023-10-23 14:53:05] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2023-10-23 14:53:07] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2023-10-23 14:56:54] [indexer:background] Health check
[2023-10-23 14:56:54] [indexer:background] CPU load threshold (3) breached: 3.7 [waiting 2]
[2023-10-23 14:58:03] [index:background] Health check
[2023-10-23 14:58:03] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2023-10-23 14:58:05] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-10-23 15:01:54] [indexer:background] Health check
[2023-10-23 15:01:54] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2023-10-23 15:03:56] [index:background] Health check
[2023-10-23 15:03:56] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-23 15:03:58] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-23 15:06:54] [indexer:background] Health check
[2023-10-23 15:06:54] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-10-23 15:08:04] [index:background] Health check
[2023-10-23 15:08:04] [index:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2023-10-23 15:08:06] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2023-10-23 15:11:53] [indexer:background] Health check
[2023-10-23 15:11:53] [indexer:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2023-10-23 15:13:04] [index:background] Health check
[2023-10-23 15:13:04] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2023-10-23 15:13:06] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2023-10-23 15:16:53] [indexer:background] Health check
[2023-10-23 15:16:53] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2023-10-23 15:18:05] [index:background] Health check
[2023-10-23 15:21:53] [indexer:background] Health check
[2023-10-23 15:21:53] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2023-10-23 15:23:04] [index:background] Health check
[2023-10-23 15:26:55] [indexer:background] Health check
[2023-10-23 15:26:55] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-10-23 15:28:03] [index:background] Health check
[2023-10-23 15:31:53] [indexer:background] Health check
[2023-10-23 15:33:04] [index:background] Health check
[2023-10-23 15:33:04] [index:background] CPU load threshold (3) breached: 3.73 [waiting 2]
[2023-10-23 15:33:06] [indexer:background] CPU load threshold (3) breached: 3.59 [waiting 2]
[2023-10-23 15:36:54] [indexer:background] Health check
[2023-10-23 15:36:54] [indexer:background] CPU load threshold (3) breached: 4.26 [waiting 2]
[2023-10-23 15:38:04] [index:background] Health check
[2023-10-23 15:38:04] [index:background] CPU load threshold (3) breached: 3.92 [waiting 2]
[2023-10-23 15:38:06] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2]
[2023-10-23 15:40:47] [query] Query for: projet de décret fixant les modalités d'application la tva au secteur petrolier amont
[2023-10-23 15:40:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 15:40:47] [query] Engine: default
[2023-10-23 15:40:48] [query] Tokens: modalities, fixes, fixées, fixe, fixa, fixé, fixant, fixer, fixée, fixera, fixeront, fixea, fixante, modalites, modalita, modalite, application, petrolier, petroliers, projets, projeter, projeta, projette, projetée, projeté, projete, projetées, projetés, projetes, secteurs, secteura, decretant, appliquer, appliqua, applique, appliquée, applications, appliquant, appliqué, appliquera, appliqués, appliques, appliquées, appliquait, appliqueront, appliquerait, applicatifs, d'appliquer, d'application, d'applications, decrets, decreter, decrete, decrète, decretes, decrét, decrett, fixés, projet, decret, fix, appliqu, tva, secteur, amont
[2023-10-23 15:40:48] [query] Mods: 6
[2023-10-23 15:40:48] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2023-10-23 15:40:48] [query] Using OR logic
[2023-10-23 15:41:00] [query] Found results using: or logic
[2023-10-23 15:41:00] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (333331,1853,4446,8703,11228,14189,15002,21295,30411,128566,199815,508782,726447,4216,23762,78168,1771,17079,17281,798,1924,24118,35764,56423,56899,57739,164909,233761,234216,72,66405,690021,9876,11099,13712,16262,23318,26272,27859,31084,34374,35917,43788,62719,79336,317798,543010,25355,33524,471097,4765,28909,60789,398486,418079,480066,572867,1789,611,17465,69757,692864,7764,91,3341) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 15:41:00] [query] Results: 4031 Pages of results: 404
[2023-10-23 15:41:00] [query] Execution time: 13.45434
[2023-10-23 15:41:00] [query] Query for: projet de décret fixant les modalités d'application la tva au secteur petrolier amont
[2023-10-23 15:41:00] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-23 15:41:00] [query] Engine: default
[2023-10-23 15:41:00] [query] Tokens: modalities, fixes, fixées, fixe, fixa, fixé, fixant, fixer, fixée, fixera, fixeront, fixea, fixante, modalites, modalita, modalite, application, petrolier, petroliers, projets, projeter, projeta, projette, projetée, projeté, projete, projetées, projetés, projetes, secteurs, secteura, decretant, appliquer, appliqua, applique, appliquée, applications, appliquant, appliqué, appliquera, appliqués, appliques, appliquées, appliquait, appliqueront, appliquerait, applicatifs, d'appliquer, d'application, d'applications, decrets, decreter, decrete, decrète, decretes, decrét, decrett, fixés, projet, decret, fix, appliqu, tva, secteur, amont
[2023-10-23 15:41:00] [query] Mods: 6
[2023-10-23 15:41:00] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2023-10-23 15:41:00] [query] Using OR logic
[2023-10-23 15:41:13] [query] Found results using: or logic
[2023-10-23 15:41:13] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (333331,1853,4446,8703,11228,14189,15002,21295,30411,128566,199815,508782,726447,4216,23762,78168,1771,17079,17281,798,1924,24118,35764,56423,56899,57739,164909,233761,234216,72,66405,690021,9876,11099,13712,16262,23318,26272,27859,31084,34374,35917,43788,62719,79336,317798,543010,25355,33524,471097,4765,28909,60789,398486,418079,480066,572867,1789,611,17465,69757,692864,7764,91,3341) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2023-10-23 15:41:13] [query] Results: 4031 Pages of results: 41
[2023-10-23 15:41:13] [query] Execution time: 12.65724
[2023-10-23 15:41:53] [indexer:background] Health check
[2023-10-23 15:41:53] [indexer:background] CPU load threshold (3) breached: 4.04 [waiting 2]
[2023-10-23 15:43:03] [index:background] Health check
[2023-10-23 15:43:03] [index:background] CPU load threshold (3) breached: 4.3 [waiting 2]
[2023-10-23 15:43:05] [indexer:background] CPU load threshold (3) breached: 4.3 [waiting 2]
[2023-10-23 15:46:53] [indexer:background] Health check
[2023-10-23 15:46:53] [indexer:background] CPU load threshold (3) breached: 4.23 [waiting 2]
[2023-10-23 15:48:04] [index:background] Health check
[2023-10-23 15:48:04] [index:background] CPU load threshold (3) breached: 3.81 [waiting 2]
[2023-10-23 15:48:06] [indexer:background] CPU load threshold (3) breached: 3.82 [waiting 2]
[2023-10-23 15:52:56] [indexer:background] Health check
[2023-10-23 15:52:56] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2023-10-23 15:52:56] [indexer:background] Health check
[2023-10-23 15:52:58] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2023-10-23 15:53:04] [index:background] Health check
[2023-10-23 15:53:04] [index:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2023-10-23 15:53:06] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2023-10-23 15:56:54] [indexer:background] Health check
[2023-10-23 15:56:54] [indexer:background] CPU load threshold (3) breached: 3.89 [waiting 2]
[2023-10-23 15:58:05] [index:background] Health check
[2023-10-23 16:04:16] [indexer:background] Health check
[2023-10-23 16:04:16] [index:background] Health check
[2023-10-23 16:07:49] [indexer:background] Health check
[2023-10-23 16:08:09] [index:background] Health check
[2023-10-23 16:12:14] [indexer:background] Health check
[2023-10-23 16:13:15] [index:background] Health check
[2023-10-23 16:13:15] [index:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2023-10-23 16:13:18] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2023-10-23 16:17:40] [indexer:background] Health check
[2023-10-23 16:18:18] [index:background] Health check
[2023-10-23 16:18:18] [index:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2023-10-23 16:18:20] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2023-10-23 16:22:15] [indexer:background] Health check
[2023-10-23 16:26:15] [index:background] Health check
[2023-10-23 16:27:07] [indexer:background] Health check
[2023-10-23 16:28:42] [index:background] Health check
[2023-10-23 16:32:37] [indexer:background] Health check
[2023-10-23 16:34:33] [index:background] Health check
[2023-10-23 16:36:54] [indexer:background] Health check
[2023-10-23 16:38:56] [index:background] Health check
[2023-10-23 16:41:54] [indexer:background] Health check
[2023-10-23 16:43:05] [index:background] Health check
[2023-10-23 16:47:23] [indexer:background] Health check
[2023-10-23 16:49:08] [index:background] Health check
[2023-10-23 16:51:52] [indexer:background] Health check
[2023-10-23 16:53:38] [index:background] Health check
[2023-10-23 16:57:04] [indexer:background] Health check
[2023-10-23 16:59:11] [index:background] Health check
[2023-10-23 16:59:13] [query] Query for: décret n°2020 du 12 octobre 2023 portant modalités d'applications de la tva dans le secteur l'amont pétrolier
[2023-10-23 16:59:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 16:59:13] [query] Engine: default
[2023-10-23 16:59:14] [query] Tokens: ports, porterait, portés, portées, portera, portée, portantes, porta, porter, portaient, portant, porte, porté, portes, octobra, octobrea, octobre, octobres, portait, portants, portante, porteront, portement, portez, porteraient, portea, portis, porti, porties, portie, portir, secteurs, secteura, application, appliquée, applications, appliquant, appliqué, appliquera, appliqués, appliques, appliquées, appliquait, appliqueront, appliquerait, applicatifs, applique, decrets, decreter, decrete, decrète, decretes, decrét, decrett, decretant, modalites, appliqua, modalita, modalite, appliquer, modalities, decret, n°2020, octobr, 2023, port, appliqu, tva, secteur, amont
[2023-10-23 16:59:14] [query] Mods: 6
[2023-10-23 16:59:15] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2023-10-23 16:59:15] [query] Using OR logic
[2023-10-23 16:59:33] [query] Found results using: or logic
[2023-10-23 16:59:33] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4740,26661,26605,26431,26012,15118,13854,10816,7427,32181,3151,1094,1053,168,732736,65930,575,38022,35073,41584,54247,64914,493549,509025,553163,721039,768528,768561,770783,771593,777701,72,66405,1771,16262,23318,26272,27859,31084,34374,35917,43788,62719,79336,317798,543010,13712,4765,28909,60789,398486,418079,480066,572867,690021,4216,11099,23762,78168,9876,333331,17465,199037,225304,4302,368,692864,7764,91,3341) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 16:59:33] [query] Results: 4234 Pages of results: 424
[2023-10-23 16:59:33] [query] Execution time: 20.22068
[2023-10-23 16:59:33] [query] Query for: décret n°2020 du 12 octobre 2023 portant modalités d'applications de la tva dans le secteur l'amont pétrolier
[2023-10-23 16:59:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-10-23 16:59:33] [query] Engine: default
[2023-10-23 16:59:33] [query] Tokens: ports, porterait, portés, portées, portera, portée, portantes, porta, porter, portaient, portant, porte, porté, portes, octobra, octobrea, octobre, octobres, portait, portants, portante, porteront, portement, portez, porteraient, portea, portis, porti, porties, portie, portir, secteurs, secteura, application, appliquée, applications, appliquant, appliqué, appliquera, appliqués, appliques, appliquées, appliquait, appliqueront, appliquerait, applicatifs, applique, decrets, decreter, decrete, decrète, decretes, decrét, decrett, decretant, modalites, appliqua, modalita, modalite, appliquer, modalities, decret, n°2020, octobr, 2023, port, appliqu, tva, secteur, amont
[2023-10-23 16:59:33] [query] Mods: 6
[2023-10-23 16:59:33] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2023-10-23 16:59:33] [query] Using OR logic
[2023-10-23 16:59:46] [query] Found results using: or logic
[2023-10-23 16:59:46] [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 (4740,26661,26605,26431,26012,15118,13854,10816,7427,32181,3151,1094,1053,168,732736,65930,575,38022,35073,41584,54247,64914,493549,509025,553163,721039,768528,768561,770783,771593,777701,72,66405,1771,16262,23318,26272,27859,31084,34374,35917,43788,62719,79336,317798,543010,13712,4765,28909,60789,398486,418079,480066,572867,690021,4216,11099,23762,78168,9876,333331,17465,199037,225304,4302,368,692864,7764,91,3341) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2023-10-23 16:59:46] [query] Results: 4234 Pages of results: 43
[2023-10-23 16:59:46] [query] Execution time: 12.81661
[2023-10-23 17:02:07] [indexer:background] Health check
[2023-10-23 17:04:45] [index:background] Health check
[2023-10-23 17:05:04] [query] Query for: écret n°2020 du 12 octobre 2023 portant modalités d'applications de la tva dans le secteur l'amont pétrolier
[2023-10-23 17:05:04] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 17:05:04] [query] Engine: default
[2023-10-23 17:05:05] [query] Tokens: portait, portes, porté, porte, portant, ports, porter, porta, portantes, portée, portera, portées, portés, porterait, portaient, octobra, portants, portante, porteront, portement, portez, porteraient, portea, portis, porti, porties, portie, portir, secteurs, secteura, appliqua, applique, appliquée, applications, appliquant, appliqué, appliquera, appliqués, appliques, appliquées, appliquait, appliqueront, appliquerait, applicatifs, ecrete, modalites, modalita, modalite, modalities, octobre, octobres, octobrea, appliquer, application, ecret, n°2020, octobr, 2023, port, appliqu, tva, secteur, amont
[2023-10-23 17:05:05] [query] Mods: 6
[2023-10-23 17:05:05] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2023-10-23 17:05:05] [query] Using OR logic
[2023-10-23 17:05:16] [query] Found results using: or logic
[2023-10-23 17:05:16] [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 (35073,168,1053,1094,3151,4740,7427,10816,13854,15118,26012,26431,26605,26661,32181,732736,41584,54247,64914,493549,509025,553163,721039,768528,768561,770783,771593,777701,72,66405,11099,13712,16262,23318,26272,27859,31084,34374,35917,43788,62719,79336,317798,543010,221020,4216,23762,78168,333331,575,38022,65930,9876,1771,374943,199037,225304,4302,368,692864,7764,91,3341) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 17:05:16] [query] Results: 2960 Pages of results: 296
[2023-10-23 17:05:16] [query] Execution time: 11.84608
[2023-10-23 17:07:40] [indexer:background] Health check
[2023-10-23 17:09:03] [index:background] Health check
[2023-10-23 17:12:41] [indexer:background] Health check
[2023-10-23 17:14:21] [index:background] Health check
[2023-10-23 17:17:10] [indexer:background] Health check
[2023-10-23 17:18:08] [index:background] Health check
[2023-10-23 17:23:06] [indexer:background] Health check
[2023-10-23 17:23:06] [index:background] Health check
[2023-10-23 17:27:25] [indexer:background] Health check
[2023-10-23 17:28:09] [index:background] Health check
[2023-10-23 17:34:19] [indexer:background] Health check
[2023-10-23 17:34:19] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-10-23 17:34:21] [index:background] Health check
[2023-10-23 17:34:21] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-10-23 17:36:56] [indexer:background] Health check
[2023-10-23 17:39:12] [index:background] Health check
[2023-10-23 17:39:12] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 17:39:14] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-10-23 17:42:14] [indexer:background] Health check
[2023-10-23 17:43:47] [index:background] Health check
[2023-10-23 17:47:29] [indexer:background] Health check
[2023-10-23 17:48:16] [index:background] Health check
[2023-10-23 17:52:38] [indexer:background] Health check
[2023-10-23 17:53:15] [index:background] Health check
[2023-10-23 18:00:57] [indexer:background] Health check
[2023-10-23 18:00:57] [index:background] Health check
[2023-10-23 18:02:32] [indexer:background] Health check
[2023-10-23 18:03:33] [index:background] Health check
[2023-10-23 18:07:19] [indexer:background] Health check
[2023-10-23 18:09:33] [index:background] Health check
[2023-10-23 18:12:30] [indexer:background] Health check
[2023-10-23 18:14:04] [index:background] Health check
[2023-10-23 18:17:01] [indexer:background] Health check
[2023-10-23 18:19:46] [index:background] Health check
[2023-10-23 18:22:31] [indexer:background] Health check
[2023-10-23 18:23:13] [index:background] Health check
[2023-10-23 18:27:54] [indexer:background] Health check
[2023-10-23 18:28:31] [index:background] Health check
[2023-10-23 18:31:51] [indexer:background] Health check
[2023-10-23 18:35:12] [index:background] Health check
[2023-10-23 18:37:03] [indexer:background] Health check
[2023-10-23 18:40:03] [index:background] Health check
[2023-10-23 18:42:39] [indexer:background] Health check
[2023-10-23 18:43:52] [index:background] Health check
[2023-10-23 18:47:06] [indexer:background] Health check
[2023-10-23 18:48:22] [index:background] Health check
[2023-10-23 18:52:24] [indexer:background] Health check
[2023-10-23 18:54:09] [index:background] Health check
[2023-10-23 18:57:19] [indexer:background] Health check
[2023-10-23 18:58:42] [index:background] Health check
[2023-10-23 19:02:29] [indexer:background] Health check
[2023-10-23 19:03:27] [index:background] Health check
[2023-10-23 19:07:39] [indexer:background] Health check
[2023-10-23 19:12:20] [index:background] Health check
[2023-10-23 19:12:20] [indexer:background] Health check
[2023-10-23 19:12:20] [indexer:background] Health check
[2023-10-23 19:14:24] [index:background] Health check
[2023-10-23 19:17:03] [indexer:background] Health check
[2023-10-23 19:23:55] [index:background] Health check
[2023-10-23 19:23:55] [indexer:background] Health check
[2023-10-23 19:23:55] [indexer:background] Health check
[2023-10-23 19:29:38] [indexer:background] Health check
[2023-10-23 19:29:38] [index:background] Health check
[2023-10-23 19:32:07] [indexer:background] Health check
[2023-10-23 19:34:15] [index:background] Health check
[2023-10-23 19:41:08] [indexer:background] Health check
[2023-10-23 19:41:08] [index:background] Health check
[2023-10-23 19:42:30] [indexer:background] Health check
[2023-10-23 19:42:30] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2023-10-23 19:44:05] [index:background] Health check
[2023-10-23 19:47:27] [indexer:background] Health check
[2023-10-23 19:48:07] [index:background] Health check
[2023-10-23 19:52:06] [indexer:background] Health check
[2023-10-23 19:53:02] [index:background] Health check
[2023-10-23 20:00:13] [indexer:background] Health check
[2023-10-23 20:00:13] [index:background] Health check
[2023-10-23 20:03:01] [indexer:background] Health check
[2023-10-23 20:04:56] [index:background] Health check
[2023-10-23 20:07:10] [indexer:background] Health check
[2023-10-23 20:08:23] [index:background] Health check
[2023-10-23 20:11:51] [indexer:background] Health check
[2023-10-23 20:14:11] [index:background] Health check
[2023-10-23 20:20:12] [indexer:background] Health check
[2023-10-23 20:20:12] [index:background] Health check
[2023-10-23 20:23:27] [indexer:background] Health check
[2023-10-23 20:23:27] [index:background] Health check
[2023-10-23 20:27:27] [indexer:background] Health check
[2023-10-23 20:29:29] [index:background] Health check
[2023-10-23 20:31:58] [indexer:background] Health check
[2023-10-23 20:35:03] [index:background] Health check
[2023-10-23 20:37:40] [indexer:background] Health check
[2023-10-23 20:39:04] [index:background] Health check
[2023-10-23 20:42:41] [indexer:background] Health check
[2023-10-23 20:43:32] [index:background] Health check
[2023-10-23 20:50:07] [indexer:background] Health check
[2023-10-23 20:50:07] [index:background] Health check
[2023-10-23 20:53:41] [indexer:background] Health check
[2023-10-23 20:53:41] [index:background] Health check
[2023-10-23 20:57:07] [indexer:background] Health check
[2023-10-23 21:00:15] [index:background] Health check
[2023-10-23 21:02:22] [indexer:background] Health check
[2023-10-23 21:03:28] [index:background] Health check
[2023-10-23 21:07:42] [indexer:background] Health check
[2023-10-23 21:07:42] [indexer:background] CPU load threshold (3) breached: 6.36 [waiting 2]
[2023-10-23 21:08:25] [index:background] Health check
[2023-10-23 21:08:25] [index:background] CPU load threshold (3) breached: 3.91 [waiting 2]
[2023-10-23 21:08:27] [indexer:background] CPU load threshold (3) breached: 3.91 [waiting 2]
[2023-10-23 21:13:07] [indexer:background] Health check
[2023-10-23 21:13:07] [index:background] Health check
[2023-10-23 21:18:29] [indexer:background] Health check
[2023-10-23 21:18:29] [index:background] Health check
[2023-10-23 21:21:51] [indexer:background] Health check
[2023-10-23 21:24:11] [index:background] Health check
[2023-10-23 21:28:25] [indexer:background] Health check
[2023-10-23 21:28:25] [index:background] Health check
[2023-10-23 21:32:26] [indexer:background] Health check
[2023-10-23 21:33:06] [index:background] Health check
[2023-10-23 21:37:04] [indexer:background] Health check
[2023-10-23 21:40:07] [index:background] Health check
[2023-10-23 21:45:41] [indexer:background] Health check
[2023-10-23 21:45:41] [index:background] Health check
[2023-10-23 21:50:55] [indexer:background] Health check
[2023-10-23 21:50:55] [index:background] Health check
[2023-10-23 21:51:53] [indexer:background] Health check
[2023-10-23 21:53:39] [index:background] Health check
[2023-10-23 21:56:31] [query] Query for: 2024
[2023-10-23 21:56:31] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-10-23 21:56:31] [query] Engine: default
[2023-10-23 21:56:32] [query] Tokens: 2024
[2023-10-23 21:56:32] [query] Mods: 6
[2023-10-23 21:56:32] [query] Found results using: or logic
[2023-10-23 21:56:32] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2023-10-23 21:56:32] [query] Results: 129 Pages of results: 13
[2023-10-23 21:56:32] [query] Execution time: 1.03301
[2023-10-23 21:57:41] [indexer:background] Health check
[2023-10-23 21:58:54] [index:background] Health check
[2023-10-23 22:04:03] [indexer:background] Health check
[2023-10-23 22:04:03] [index:background] Health check
[2023-10-23 22:07:18] [indexer:background] Health check
[2023-10-23 22:08:52] [index:background] Health check
[2023-10-23 22:13:26] [indexer:background] Health check
[2023-10-23 22:13:26] [index:background] Health check
[2023-10-23 22:17:27] [indexer:background] Health check
[2023-10-23 22:20:23] [index:background] Health check
[2023-10-23 22:22:26] [indexer:background] Health check
[2023-10-23 22:23:18] [index:background] Health check
[2023-10-23 22:32:12] [indexer:background] Health check
[2023-10-23 22:32:12] [index:background] Health check
[2023-10-23 22:33:19] [index:background] Health check
[2023-10-23 22:37:13] [indexer:background] Health check
[2023-10-23 22:38:56] [index:background] Health check
[2023-10-23 22:41:52] [indexer:background] Health check
[2023-10-23 22:43:38] [index:background] Health check
[2023-10-23 22:47:15] [indexer:background] Health check
[2023-10-23 22:48:53] [index:background] Health check
[2023-10-23 22:52:45] [indexer:background] Health check
[2023-10-23 22:54:19] [index:background] Health check
[2023-10-23 22:58:20] [indexer:background] Health check
[2023-10-23 22:58:20] [index:background] Health check
[2023-10-23 23:02:18] [indexer:background] Health check
[2023-10-23 23:04:25] [index:background] Health check
[2023-10-23 23:07:24] [indexer:background] Health check
[2023-10-23 23:08:49] [index:background] Health check
[2023-10-23 23:14:06] [indexer:background] Health check
[2023-10-23 23:14:06] [index:background] Health check
[2023-10-23 23:16:53] [indexer:background] Health check
[2023-10-23 23:18:18] [index:background] Health check
[2023-10-23 23:21:56] [indexer:background] Health check
[2023-10-23 23:23:06] [index:background] Health check
[2023-10-23 23:26:53] [indexer:background] Health check
[2023-10-23 23:28:25] [index:background] Health check
[2023-10-23 23:35:15] [indexer:background] Health check
[2023-10-23 23:35:15] [index:background] Health check
[2023-10-23 23:39:00] [indexer:background] Health check
[2023-10-23 23:39:00] [index:background] Health check
[2023-10-23 23:42:07] [indexer:background] Health check
[2023-10-23 23:44:10] [index:background] Health check
[2023-10-23 23:47:22] [indexer:background] Health check
[2023-10-23 23:48:22] [index:background] Health check
[2023-10-23 23:52:43] [indexer:background] Health check
[2023-10-23 23:53:40] [index:background] Health check
[2023-10-23 23:58:30] [indexer:background] Health check
[2023-10-23 23:58:30] [index:background] Health check