[2024-01-07 00:02:48] [index:background] Health check
[2024-01-07 00:05:12] [indexer:background] Health check
[2024-01-07 00:06:51] [index:background] Health check
[2024-01-07 00:08:51] [indexer:background] Health check
[2024-01-07 00:10:43] [index:background] Health check
[2024-01-07 00:13:51] [indexer:background] Health check
[2024-01-07 00:17:17] [index:background] Health check
[2024-01-07 00:18:49] [indexer:background] Health check
[2024-01-07 00:20:44] [index:background] Health check
[2024-01-07 00:23:54] [indexer:background] Health check
[2024-01-07 00:27:16] [index:background] Health check
[2024-01-07 00:29:26] [indexer:background] Health check
[2024-01-07 00:30:52] [index:background] Health check
[2024-01-07 00:34:17] [indexer:background] Health check
[2024-01-07 00:36:13] [index:background] Health check
[2024-01-07 00:39:46] [indexer:background] Health check
[2024-01-07 00:40:35] [index:background] Health check
[2024-01-07 00:44:28] [indexer:background] Health check
[2024-01-07 00:45:38] [index:background] Health check
[2024-01-07 00:51:22] [indexer:background] Health check
[2024-01-07 00:51:22] [index:background] Health check
[2024-01-07 00:56:21] [indexer:background] Health check
[2024-01-07 00:56:21] [index:background] Health check
[2024-01-07 01:01:55] [indexer:background] Health check
[2024-01-07 01:01:55] [index:background] Health check
[2024-01-07 01:03:50] [indexer:background] Health check
[2024-01-07 01:08:29] [index:background] Health check
[2024-01-07 01:12:33] [indexer:background] Health check
[2024-01-07 01:12:33] [index:background] Health check
[2024-01-07 01:15:03] [indexer:background] Health check
[2024-01-07 01:15:41] [index:background] Health check
[2024-01-07 01:24:46] [indexer:background] Health check
[2024-01-07 01:24:46] [index:background] Health check
[2024-01-07 01:25:55] [index:background] Health check
[2024-01-07 01:32:17] [indexer:background] Health check
[2024-01-07 01:32:17] [index:background] Health check
[2024-01-07 01:34:47] [indexer:background] Health check
[2024-01-07 01:35:29] [index:background] Health check
[2024-01-07 01:39:33] [indexer:background] Health check
[2024-01-07 01:42:06] [index:background] Health check
[2024-01-07 01:44:16] [indexer:background] Health check
[2024-01-07 01:48:35] [index:background] Health check
[2024-01-07 01:51:10] [indexer:background] Health check
[2024-01-07 01:51:10] [index:background] Health check
[2024-01-07 01:54:47] [indexer:background] Health check
[2024-01-07 01:55:35] [index:background] Health check
[2024-01-07 01:58:55] [indexer:background] Health check
[2024-01-07 02:00:42] [index:background] Health check
[2024-01-07 02:06:46] [indexer:background] Health check
[2024-01-07 02:06:46] [index:background] Health check
[2024-01-07 02:09:25] [indexer:background] Health check
[2024-01-07 02:11:49] [index:background] Health check
[2024-01-07 02:15:28] [indexer:background] Health check
[2024-01-07 02:15:28] [index:background] Health check
[2024-01-07 02:19:22] [indexer:background] Health check
[2024-01-07 02:20:55] [index:background] Health check
[2024-01-07 02:24:00] [indexer:background] Health check
[2024-01-07 02:26:46] [index:background] Health check
[2024-01-07 02:29:06] [indexer:background] Health check
[2024-01-07 02:33:26] [index:background] Health check
[2024-01-07 02:34:40] [indexer:background] Health check
[2024-01-07 02:36:15] [index:background] Health check
[2024-01-07 02:39:42] [indexer:background] Health check
[2024-01-07 02:41:02] [index:background] Health check
[2024-01-07 02:44:50] [indexer:background] Health check
[2024-01-07 02:44:50] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2024-01-07 02:46:33] [index:background] Health check
[2024-01-07 02:50:17] [indexer:background] Health check
[2024-01-07 02:50:17] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2024-01-07 02:52:07] [index:background] Health check
[2024-01-07 02:54:09] [indexer:background] Health check
[2024-01-07 02:54:09] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-01-07 02:56:50] [index:background] Health check
[2024-01-07 02:56:50] [index:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2024-01-07 02:56:52] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2024-01-07 02:59:26] [indexer:background] Health check
[2024-01-07 02:59:26] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2024-01-07 03:00:51] [index:background] Health check
[2024-01-07 03:00:51] [index:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2024-01-07 03:00:53] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2]
[2024-01-07 03:04:17] [indexer:background] Health check
[2024-01-07 03:06:27] [index:background] Health check
[2024-01-07 03:06:27] [index:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2024-01-07 03:06:29] [indexer:background] CPU load threshold (3) breached: 3.17 [waiting 2]
[2024-01-07 03:08:57] [indexer:background] Health check
[2024-01-07 03:08:57] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2024-01-07 03:10:24] [index:background] Health check
[2024-01-07 03:10:24] [index:background] CPU load threshold (3) breached: 3.55 [waiting 2]
[2024-01-07 03:10:26] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2]
[2024-01-07 03:15:54] [indexer:background] Health check
[2024-01-07 03:15:54] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2024-01-07 03:15:56] [index:background] Health check
[2024-01-07 03:15:56] [index:background] CPU load threshold (3) breached: 4.21 [waiting 2]
[2024-01-07 03:15:58] [indexer:background] CPU load threshold (3) breached: 4.21 [waiting 2]
[2024-01-07 03:19:00] [indexer:background] Health check
[2024-01-07 03:19:00] [indexer:background] CPU load threshold (3) breached: 3.93 [waiting 2]
[2024-01-07 03:21:05] [index:background] Health check
[2024-01-07 03:21:06] [index:background] CPU load threshold (3) breached: 3.59 [waiting 2]
[2024-01-07 03:21:08] [indexer:background] CPU load threshold (3) breached: 3.59 [waiting 2]
[2024-01-07 03:25:43] [indexer:background] Health check
[2024-01-07 03:25:43] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2]
[2024-01-07 03:25:46] [index:background] Health check
[2024-01-07 03:25:46] [index:background] CPU load threshold (3) breached: 4.17 [waiting 2]
[2024-01-07 03:25:48] [indexer:background] CPU load threshold (3) breached: 4.17 [waiting 2]
[2024-01-07 03:28:54] [query] Query for: search_term_string
[2024-01-07 03:28:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 45 offset: 0 fields: all
[2024-01-07 03:28:54] [query] Engine: default
[2024-01-07 03:28:55] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-07 03:28:55] [query] Mods: 6
[2024-01-07 03:28:55] [query] Using OR logic
[2024-01-07 03:28:55] [indexer:background] Health check
[2024-01-07 03:28:55] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2024-01-07 03:28:55] [query] Found results using: or logic
[2024-01-07 03:28:55] [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 440, 10
[2024-01-07 03:28:55] [query] Results: 1346 Pages of results: 135
[2024-01-07 03:28:55] [query] Execution time: 1.13078
[2024-01-07 03:32:52] [index:background] Health check
[2024-01-07 03:35:31] [indexer:background] Health check
[2024-01-07 03:35:32] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2024-01-07 03:35:34] [index:background] Health check
[2024-01-07 03:35:34] [index:background] CPU load threshold (3) breached: 3.38 [waiting 2]
[2024-01-07 03:35:36] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2024-01-07 03:40:18] [indexer:background] Health check
[2024-01-07 03:40:18] [indexer:background] CPU load threshold (3) breached: 3.5 [waiting 2]
[2024-01-07 03:41:07] [index:background] Health check
[2024-01-07 03:41:07] [index:background] CPU load threshold (3) breached: 4.14 [waiting 2]
[2024-01-07 03:41:09] [indexer:background] CPU load threshold (3) breached: 4.14 [waiting 2]
[2024-01-07 03:44:25] [indexer:background] Health check
[2024-01-07 03:44:25] [indexer:background] CPU load threshold (3) breached: 3.76 [waiting 2]
[2024-01-07 03:45:32] [index:background] Health check
[2024-01-07 03:45:32] [index:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2024-01-07 03:45:34] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2024-01-07 03:49:03] [indexer:background] Health check
[2024-01-07 03:49:03] [indexer:background] CPU load threshold (3) breached: 3.83 [waiting 2]
[2024-01-07 03:50:49] [index:background] Health check
[2024-01-07 03:50:49] [index:background] CPU load threshold (3) breached: 3.69 [waiting 2]
[2024-01-07 03:50:51] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2024-01-07 03:54:50] [indexer:background] Health check
[2024-01-07 03:55:39] [index:background] Health check
[2024-01-07 03:56:58] [query] Query for: 2024
[2024-01-07 03:56:58] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 03:56:58] [query] Engine: default
[2024-01-07 03:56:58] [query] Tokens: 2024
[2024-01-07 03:56:58] [query] Mods: 6
[2024-01-07 03:56:59] [query] Found results using: or logic
[2024-01-07 03:56:59] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-07 03:56:59] [query] Results: 132 Pages of results: 14
[2024-01-07 03:56:59] [query] Execution time: 0.21953
[2024-01-07 03:56:59] [query] Query for: 2024
[2024-01-07 03:56:59] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-07 03:56:59] [query] Engine: default
[2024-01-07 03:56:59] [query] Tokens: 2024
[2024-01-07 03:56:59] [query] Mods: 6
[2024-01-07 03:56:59] [query] Found results using: or logic
[2024-01-07 03:56:59] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-07 03:56:59] [query] Results: 132 Pages of results: 2
[2024-01-07 03:56:59] [query] Execution time: 0.08447
[2024-01-07 03:59:00] [indexer:background] Health check
[2024-01-07 04:00:36] [index:background] Health check
[2024-01-07 04:05:07] [indexer:background] Health check
[2024-01-07 04:07:39] [index:background] Health check
[2024-01-07 04:11:13] [indexer:background] Health check
[2024-01-07 04:11:13] [index:background] Health check
[2024-01-07 04:14:39] [indexer:background] Health check
[2024-01-07 04:16:34] [index:background] Health check
[2024-01-07 04:18:48] [indexer:background] Health check
[2024-01-07 04:21:48] [index:background] Health check
[2024-01-07 04:23:58] [indexer:background] Health check
[2024-01-07 04:25:36] [index:background] Health check
[2024-01-07 04:33:01] [indexer:background] Health check
[2024-01-07 04:33:01] [index:background] Health check
[2024-01-07 04:35:24] [indexer:background] Health check
[2024-01-07 04:35:24] [index:background] Health check
[2024-01-07 04:41:41] [indexer:background] Health check
[2024-01-07 04:41:41] [index:background] Health check
[2024-01-07 04:43:49] [indexer:background] Health check
[2024-01-07 04:45:25] [index:background] Health check
[2024-01-07 04:48:48] [indexer:background] Health check
[2024-01-07 04:50:25] [index:background] Health check
[2024-01-07 04:53:48] [indexer:background] Health check
[2024-01-07 04:56:39] [index:background] Health check
[2024-01-07 04:58:59] [indexer:background] Health check
[2024-01-07 05:01:04] [index:background] Health check
[2024-01-07 05:04:09] [indexer:background] Health check
[2024-01-07 05:05:52] [index:background] Health check
[2024-01-07 05:09:46] [indexer:background] Health check
[2024-01-07 05:11:05] [index:background] Health check
[2024-01-07 05:15:23] [indexer:background] Health check
[2024-01-07 05:15:23] [index:background] Health check
[2024-01-07 05:19:58] [indexer:background] Health check
[2024-01-07 05:21:58] [index:background] Health check
[2024-01-07 05:23:48] [indexer:background] Health check
[2024-01-07 05:25:42] [index:background] Health check
[2024-01-07 05:29:58] [indexer:background] Health check
[2024-01-07 05:30:27] [index:background] Health check
[2024-01-07 05:34:56] [indexer:background] Health check
[2024-01-07 05:35:38] [index:background] Health check
[2024-01-07 05:38:51] [indexer:background] Health check
[2024-01-07 05:41:11] [index:background] Health check
[2024-01-07 05:43:59] [indexer:background] Health check
[2024-01-07 05:45:32] [index:background] Health check
[2024-01-07 05:49:49] [indexer:background] Health check
[2024-01-07 05:51:17] [index:background] Health check
[2024-01-07 05:53:58] [indexer:background] Health check
[2024-01-07 05:55:56] [index:background] Health check
[2024-01-07 05:59:34] [indexer:background] Health check
[2024-01-07 06:01:48] [index:background] Health check
[2024-01-07 06:04:39] [indexer:background] Health check
[2024-01-07 06:05:58] [index:background] Health check
[2024-01-07 06:10:05] [indexer:background] Health check
[2024-01-07 06:10:40] [index:background] Health check
[2024-01-07 06:13:49] [indexer:background] Health check
[2024-01-07 06:16:14] [index:background] Health check
[2024-01-07 06:20:15] [indexer:background] Health check
[2024-01-07 06:20:50] [index:background] Health check
[2024-01-07 06:24:28] [indexer:background] Health check
[2024-01-07 06:25:57] [index:background] Health check
[2024-01-07 06:28:50] [indexer:background] Health check
[2024-01-07 06:30:55] [index:background] Health check
[2024-01-07 06:33:51] [indexer:background] Health check
[2024-01-07 06:35:39] [index:background] Health check
[2024-01-07 06:39:36] [indexer:background] Health check
[2024-01-07 06:41:14] [index:background] Health check
[2024-01-07 06:44:53] [indexer:background] Health check
[2024-01-07 06:47:33] [index:background] Health check
[2024-01-07 06:48:53] [indexer:background] Health check
[2024-01-07 06:52:03] [index:background] Health check
[2024-01-07 06:54:57] [indexer:background] Health check
[2024-01-07 06:56:35] [index:background] Health check
[2024-01-07 06:59:06] [indexer:background] Health check
[2024-01-07 07:01:30] [index:background] Health check
[2024-01-07 07:06:59] [indexer:background] Health check
[2024-01-07 07:06:59] [index:background] Health check
[2024-01-07 07:09:40] [indexer:background] Health check
[2024-01-07 07:11:49] [index:background] Health check
[2024-01-07 07:15:28] [indexer:background] Health check
[2024-01-07 07:15:28] [index:background] Health check
[2024-01-07 07:19:06] [indexer:background] Health check
[2024-01-07 07:21:01] [index:background] Health check
[2024-01-07 07:23:58] [indexer:background] Health check
[2024-01-07 07:27:59] [index:background] Health check
[2024-01-07 07:29:39] [indexer:background] Health check
[2024-01-07 07:32:06] [index:background] Health check
[2024-01-07 07:32:06] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2024-01-07 07:32:08] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2024-01-07 07:36:53] [indexer:background] Health check
[2024-01-07 07:36:54] [index:background] Health check
[2024-01-07 07:41:13] [indexer:background] Health check
[2024-01-07 07:41:13] [index:background] Health check
[2024-01-07 07:43:53] [indexer:background] Health check
[2024-01-07 07:46:08] [index:background] Health check
[2024-01-07 07:49:03] [indexer:background] Health check
[2024-01-07 07:50:26] [index:background] Health check
[2024-01-07 07:53:48] [indexer:background] Health check
[2024-01-07 07:55:24] [index:background] Health check
[2024-01-07 07:58:49] [indexer:background] Health check
[2024-01-07 08:00:25] [index:background] Health check
[2024-01-07 08:05:13] [indexer:background] Health check
[2024-01-07 08:05:28] [index:background] Health check
[2024-01-07 08:08:53] [indexer:background] Health check
[2024-01-07 08:10:36] [index:background] Health check
[2024-01-07 08:14:01] [indexer:background] Health check
[2024-01-07 08:16:29] [index:background] Health check
[2024-01-07 08:21:24] [indexer:background] Health check
[2024-01-07 08:21:24] [index:background] Health check
[2024-01-07 08:25:55] [indexer:background] Health check
[2024-01-07 08:25:55] [index:background] Health check
[2024-01-07 08:28:54] [indexer:background] Health check
[2024-01-07 08:32:43] [index:background] Health check
[2024-01-07 08:34:32] [indexer:background] Health check
[2024-01-07 08:36:28] [index:background] Health check
[2024-01-07 08:39:06] [indexer:background] Health check
[2024-01-07 08:41:08] [index:background] Health check
[2024-01-07 08:44:20] [indexer:background] Health check
[2024-01-07 08:46:27] [index:background] Health check
[2024-01-07 08:49:20] [indexer:background] Health check
[2024-01-07 08:50:28] [index:background] Health check
[2024-01-07 08:55:33] [indexer:background] Health check
[2024-01-07 08:55:33] [index:background] Health check
[2024-01-07 08:59:05] [indexer:background] Health check
[2024-01-07 09:01:07] [index:background] Health check
[2024-01-07 09:04:00] [indexer:background] Health check
[2024-01-07 09:08:10] [index:background] Health check
[2024-01-07 09:10:10] [indexer:background] Health check
[2024-01-07 09:11:09] [index:background] Health check
[2024-01-07 09:14:34] [indexer:background] Health check
[2024-01-07 09:15:35] [index:background] Health check
[2024-01-07 09:19:06] [indexer:background] Health check
[2024-01-07 09:20:52] [index:background] Health check
[2024-01-07 09:24:49] [query] Query for: 2024
[2024-01-07 09:24:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 09:24:49] [query] Engine: default
[2024-01-07 09:24:49] [query] Tokens: 2024
[2024-01-07 09:24:49] [query] Mods: 6
[2024-01-07 09:24:49] [query] Found results using: or logic
[2024-01-07 09:24: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-07 09:24:49] [query] Results: 132 Pages of results: 14
[2024-01-07 09:24:49] [query] Execution time: 0.04369
[2024-01-07 09:24:49] [indexer:background] Health check
[2024-01-07 09:26:48] [index:background] Health check
[2024-01-07 09:29:29] [indexer:background] Health check
[2024-01-07 09:30:43] [index:background] Health check
[2024-01-07 09:34:51] [indexer:background] Health check
[2024-01-07 09:35:53] [index:background] Health check
[2024-01-07 09:39:37] [indexer:background] Health check
[2024-01-07 09:40:31] [index:background] Health check
[2024-01-07 09:44:13] [indexer:background] Health check
[2024-01-07 09:45:52] [index:background] Health check
[2024-01-07 09:48:57] [indexer:background] Health check
[2024-01-07 09:48:57] [indexer:background] CPU load threshold (3) breached: 3.91 [waiting 2]
[2024-01-07 09:50:49] [index:background] Health check
[2024-01-07 09:54:29] [indexer:background] Health check
[2024-01-07 09:55:49] [index:background] Health check
[2024-01-07 09:58:49] [indexer:background] Health check
[2024-01-07 10:00:26] [index:background] Health check
[2024-01-07 10:03:50] [indexer:background] Health check
[2024-01-07 10:05:24] [index:background] Health check
[2024-01-07 10:08:48] [indexer:background] Health check
[2024-01-07 10:10:25] [index:background] Health check
[2024-01-07 10:14:03] [indexer:background] Health check
[2024-01-07 10:15:43] [index:background] Health check
[2024-01-07 10:19:28] [indexer:background] Health check
[2024-01-07 10:21:17] [index:background] Health check
[2024-01-07 10:24:31] [indexer:background] Health check
[2024-01-07 10:25:24] [index:background] Health check
[2024-01-07 10:29:57] [indexer:background] Health check
[2024-01-07 10:30:31] [index:background] Health check
[2024-01-07 10:33:03] [query] Query for: 2023
[2024-01-07 10:33:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 10:33:03] [query] Engine: default
[2024-01-07 10:33:03] [query] Tokens: 2023
[2024-01-07 10:33:03] [query] Mods: 6
[2024-01-07 10:33:04] [query] Found results using: or logic
[2024-01-07 10:33:04] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-07 10:33:04] [query] Results: 255 Pages of results: 26
[2024-01-07 10:33:04] [query] Execution time: 1.10872
[2024-01-07 10:33:04] [query] Query for: 2023
[2024-01-07 10:33:04] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-07 10:33:04] [query] Engine: default
[2024-01-07 10:33:04] [query] Tokens: 2023
[2024-01-07 10:33:04] [query] Mods: 6
[2024-01-07 10:33:04] [query] Found results using: or logic
[2024-01-07 10:33:04] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-07 10:33:04] [query] Results: 255 Pages of results: 3
[2024-01-07 10:33:04] [query] Execution time: 0.11451
[2024-01-07 10:33:51] [indexer:background] Health check
[2024-01-07 10:35:57] [index:background] Health check
[2024-01-07 10:38:50] [indexer:background] Health check
[2024-01-07 10:40:50] [index:background] Health check
[2024-01-07 10:44:00] [indexer:background] Health check
[2024-01-07 10:45:49] [index:background] Health check
[2024-01-07 10:49:01] [indexer:background] Health check
[2024-01-07 10:50:59] [index:background] Health check
[2024-01-07 10:55:25] [indexer:background] Health check
[2024-01-07 10:55:25] [index:background] Health check
[2024-01-07 11:00:21] [indexer:background] Health check
[2024-01-07 11:00:48] [index:background] Health check
[2024-01-07 11:04:10] [indexer:background] Health check
[2024-01-07 11:05:30] [index:background] Health check
[2024-01-07 11:09:54] [indexer:background] Health check
[2024-01-07 11:12:39] [index:background] Health check
[2024-01-07 11:16:58] [indexer:background] Health check
[2024-01-07 11:16:58] [index:background] Health check
[2024-01-07 11:20:09] [indexer:background] Health check
[2024-01-07 11:22:16] [index:background] Health check
[2024-01-07 11:24:45] [indexer:background] Health check
[2024-01-07 11:25:27] [index:background] Health check
[2024-01-07 11:29:10] [indexer:background] Health check
[2024-01-07 11:30:40] [index:background] Health check
[2024-01-07 11:33:52] [indexer:background] Health check
[2024-01-07 11:37:08] [index:background] Health check
[2024-01-07 11:40:44] [indexer:background] Health check
[2024-01-07 11:40:44] [index:background] Health check
[2024-01-07 11:44:13] [indexer:background] Health check
[2024-01-07 11:46:06] [index:background] Health check
[2024-01-07 11:49:55] [indexer:background] Health check
[2024-01-07 11:51:46] [index:background] Health check
[2024-01-07 11:54:13] [indexer:background] Health check
[2024-01-07 11:55:25] [index:background] Health check
[2024-01-07 11:58:53] [indexer:background] Health check
[2024-01-07 12:02:14] [index:background] Health check
[2024-01-07 12:04:06] [indexer:background] Health check
[2024-01-07 12:05:43] [index:background] Health check
[2024-01-07 12:10:21] [indexer:background] Health check
[2024-01-07 12:10:28] [index:background] Health check
[2024-01-07 12:13:54] [indexer:background] Health check
[2024-01-07 12:16:26] [index:background] Health check
[2024-01-07 12:19:45] [indexer:background] Health check
[2024-01-07 12:20:40] [query] Query for: arrete-n�-12914_2014_finance-publique-impots-et-douanes_tresorerie-paierie-generale.pdf
[2024-01-07 12:20:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 12:20:40] [query] Engine: default
[2024-01-07 12:20:41] [index:background] Health check
[2024-01-07 12:20:42] [query] Tokens: paieries, finance, financer, financa, financée, financé, finançant, financant, financez, financera, financeront, financie, financs, financi, impots, paierie, financements, paieri, publiques, publique, publication, publications, publiquea, publicité, publicités, publiquement, publiqua, publiqui, publicateur, tresorerie, tresoreries, arrete, arrets, arreta, arrété, arreté, arretera, arreteront, arrèté, arretant, arrétées, arretea, arrète, finances, arreter, arréter, arretie, arrèt, arréte, douanes, douane, douanement, douani, douanies, arretes, douans, financées, financés, financement, arret, n�, 12914, 2014, financ, publiqu, impot, douan
[2024-01-07 12:20:42] [query] Mods: 6
[2024-01-07 12:20:42] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2024-01-07 12:20:42] [query] Using OR logic
[2024-01-07 12:20:50] [query] Found results using: or logic
[2024-01-07 12:20:50] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (473752,1221,8804,10800,15019,27032,27653,28790,34790,38664,147650,178508,418789,507839,4762,108725,8009,751413,866,1043,4943,5187,10823,13418,49505,77759,711996,763135,784579,17134,376646,17551,45128,51347,69901,69934,130628,219790,353841,376604,478327,503204,514969,922,28780,575556,586210,689535,799275,526,636,22019,245023,700272,4766,737898,221,799,858,2865,770525,484734,1361,690302,692852,16968,709775) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-07 12:20:50] [query] Results: 3804 Pages of results: 381
[2024-01-07 12:20:50] [query] Execution time: 9.56903
[2024-01-07 12:24:27] [indexer:background] Health check
[2024-01-07 12:26:31] [index:background] Health check
[2024-01-07 12:29:14] [indexer:background] Health check
[2024-01-07 12:30:29] [index:background] Health check
[2024-01-07 12:34:45] [indexer:background] Health check
[2024-01-07 12:37:29] [index:background] Health check
[2024-01-07 12:39:00] [indexer:background] Health check
[2024-01-07 12:40:33] [index:background] Health check
[2024-01-07 12:44:32] [indexer:background] Health check
[2024-01-07 12:47:04] [index:background] Health check
[2024-01-07 12:50:01] [indexer:background] Health check
[2024-01-07 12:50:34] [index:background] Health check
[2024-01-07 12:54:46] [indexer:background] Health check
[2024-01-07 12:56:32] [index:background] Health check
[2024-01-07 12:59:10] [indexer:background] Health check
[2024-01-07 13:01:16] [index:background] Health check
[2024-01-07 13:04:10] [indexer:background] Health check
[2024-01-07 13:06:00] [index:background] Health check
[2024-01-07 13:09:07] [indexer:background] Health check
[2024-01-07 13:10:45] [index:background] Health check
[2024-01-07 13:15:29] [indexer:background] Health check
[2024-01-07 13:15:29] [index:background] Health check
[2024-01-07 13:18:50] [indexer:background] Health check
[2024-01-07 13:21:11] [index:background] Health check
[2024-01-07 13:24:45] [indexer:background] Health check
[2024-01-07 13:29:32] [index:background] Health check
[2024-01-07 13:29:32] [indexer:background] Health check
[2024-01-07 13:29:32] [indexer:background] Health check
[2024-01-07 13:30:27] [index:background] Health check
[2024-01-07 13:33:57] [indexer:background] Health check
[2024-01-07 13:35:41] [index:background] Health check
[2024-01-07 13:39:10] [indexer:background] Health check
[2024-01-07 13:40:25] [index:background] Health check
[2024-01-07 13:43:54] [indexer:background] Health check
[2024-01-07 13:46:18] [index:background] Health check
[2024-01-07 13:49:18] [indexer:background] Health check
[2024-01-07 13:50:44] [index:background] Health check
[2024-01-07 13:54:38] [indexer:background] Health check
[2024-01-07 13:56:50] [index:background] Health check
[2024-01-07 13:59:03] [indexer:background] Health check
[2024-01-07 14:00:56] [index:background] Health check
[2024-01-07 14:05:33] [indexer:background] Health check
[2024-01-07 14:05:33] [index:background] Health check
[2024-01-07 14:09:09] [indexer:background] Health check
[2024-01-07 14:11:08] [index:background] Health check
[2024-01-07 14:13:51] [indexer:background] Health check
[2024-01-07 14:16:11] [index:background] Health check
[2024-01-07 14:19:28] [indexer:background] Health check
[2024-01-07 14:21:05] [index:background] Health check
[2024-01-07 14:25:15] [indexer:background] Health check
[2024-01-07 14:27:00] [index:background] Health check
[2024-01-07 14:28:48] [indexer:background] Health check
[2024-01-07 14:30:44] [index:background] Health check
[2024-01-07 14:36:31] [indexer:background] Health check
[2024-01-07 14:36:31] [index:background] Health check
[2024-01-07 14:39:05] [indexer:background] Health check
[2024-01-07 14:42:21] [index:background] Health check
[2024-01-07 14:44:36] [indexer:background] Health check
[2024-01-07 14:50:36] [index:background] Health check
[2024-01-07 14:50:36] [indexer:background] Health check
[2024-01-07 14:50:36] [indexer:background] Health check
[2024-01-07 14:54:25] [indexer:background] Health check
[2024-01-07 14:57:57] [index:background] Health check
[2024-01-07 15:00:18] [indexer:background] Health check
[2024-01-07 15:00:38] [index:background] Health check
[2024-01-07 15:04:39] [indexer:background] Health check
[2024-01-07 15:06:05] [index:background] Health check
[2024-01-07 15:08:55] [indexer:background] Health check
[2024-01-07 15:10:29] [index:background] Health check
[2024-01-07 15:15:05] [indexer:background] Health check
[2024-01-07 15:15:53] [index:background] Health check
[2024-01-07 15:18:56] [indexer:background] Health check
[2024-01-07 15:22:41] [index:background] Health check
[2024-01-07 15:24:05] [indexer:background] Health check
[2024-01-07 15:25:26] [index:background] Health check
[2024-01-07 15:28:51] [indexer:background] Health check
[2024-01-07 15:30:45] [index:background] Health check
[2024-01-07 15:34:30] [indexer:background] Health check
[2024-01-07 15:34:37] [query] Query for: search_term_string
[2024-01-07 15:34:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 15:34:37] [query] Engine: default
[2024-01-07 15:34:37] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-07 15:34:37] [query] Mods: 6
[2024-01-07 15:34:37] [query] Using OR logic
[2024-01-07 15:34:38] [query] Found results using: or logic
[2024-01-07 15:34:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-07 15:34:38] [query] Results: 1346 Pages of results: 135
[2024-01-07 15:34:38] [query] Execution time: 1.01479
[2024-01-07 15:36:02] [index:background] Health check
[2024-01-07 15:40:39] [indexer:background] Health check
[2024-01-07 15:40:39] [index:background] Health check
[2024-01-07 15:45:11] [indexer:background] Health check
[2024-01-07 15:45:52] [index:background] Health check
[2024-01-07 15:49:57] [indexer:background] Health check
[2024-01-07 15:51:05] [index:background] Health check
[2024-01-07 15:54:34] [indexer:background] Health check
[2024-01-07 15:59:24] [query] Query for: search_term_string
[2024-01-07 15:59:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 15:59:24] [query] Engine: default
[2024-01-07 15:59:24] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-07 15:59:24] [query] Mods: 6
[2024-01-07 15:59:24] [query] Using OR logic
[2024-01-07 15:59:24] [query] Found results using: or logic
[2024-01-07 15:59:24] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-07 15:59:24] [query] Results: 1346 Pages of results: 135
[2024-01-07 15:59:24] [query] Execution time: 0.04647
[2024-01-07 15:59:24] [index:background] Health check
[2024-01-07 15:59:25] [indexer:background] Health check
[2024-01-07 15:59:25] [indexer:background] Health check
[2024-01-07 16:02:08] [index:background] Health check
[2024-01-07 16:04:53] [indexer:background] Health check
[2024-01-07 16:05:34] [index:background] Health check
[2024-01-07 16:09:38] [indexer:background] Health check
[2024-01-07 16:10:38] [index:background] Health check
[2024-01-07 16:15:48] [indexer:background] Health check
[2024-01-07 16:15:48] [index:background] Health check
[2024-01-07 16:18:58] [indexer:background] Health check
[2024-01-07 16:22:39] [index:background] Health check
[2024-01-07 16:28:11] [indexer:background] Health check
[2024-01-07 16:28:11] [index:background] Health check
[2024-01-07 16:30:39] [indexer:background] Health check
[2024-01-07 16:30:39] [index:background] Health check
[2024-01-07 16:35:06] [indexer:background] Health check
[2024-01-07 16:38:35] [index:background] Health check
[2024-01-07 16:38:49] [indexer:background] Health check
[2024-01-07 16:41:52] [index:background] Health check
[2024-01-07 16:44:48] [indexer:background] Health check
[2024-01-07 16:48:44] [index:background] Health check
[2024-01-07 16:48:54] [indexer:background] Health check
[2024-01-07 16:50:36] [index:background] Health check
[2024-01-07 16:54:56] [indexer:background] Health check
[2024-01-07 16:58:28] [index:background] Health check
[2024-01-07 17:02:24] [indexer:background] Health check
[2024-01-07 17:02:24] [index:background] Health check
[2024-01-07 17:04:42] [indexer:background] Health check
[2024-01-07 17:05:25] [index:background] Health check
[2024-01-07 17:09:10] [indexer:background] Health check
[2024-01-07 17:11:09] [index:background] Health check
[2024-01-07 17:13:55] [indexer:background] Health check
[2024-01-07 17:16:08] [index:background] Health check
[2024-01-07 17:18:52] [indexer:background] Health check
[2024-01-07 17:21:02] [index:background] Health check
[2024-01-07 17:24:11] [indexer:background] Health check
[2024-01-07 17:25:32] [index:background] Health check
[2024-01-07 17:31:40] [indexer:background] Health check
[2024-01-07 17:31:41] [index:background] Health check
[2024-01-07 17:34:12] [indexer:background] Health check
[2024-01-07 17:35:24] [index:background] Health check
[2024-01-07 17:39:15] [indexer:background] Health check
[2024-01-07 17:40:38] [index:background] Health check
[2024-01-07 17:45:08] [indexer:background] Health check
[2024-01-07 17:45:26] [index:background] Health check
[2024-01-07 17:48:52] [indexer:background] Health check
[2024-01-07 17:50:38] [index:background] Health check
[2024-01-07 17:54:07] [indexer:background] Health check
[2024-01-07 17:55:51] [index:background] Health check
[2024-01-07 17:59:05] [indexer:background] Health check
[2024-01-07 18:00:32] [index:background] Health check
[2024-01-07 18:05:05] [indexer:background] Health check
[2024-01-07 18:07:41] [index:background] Health check
[2024-01-07 18:09:01] [indexer:background] Health check
[2024-01-07 18:10:38] [index:background] Health check
[2024-01-07 18:13:57] [indexer:background] Health check
[2024-01-07 18:15:27] [index:background] Health check
[2024-01-07 18:19:34] [indexer:background] Health check
[2024-01-07 18:20:55] [index:background] Health check
[2024-01-07 18:24:17] [indexer:background] Health check
[2024-01-07 18:27:22] [index:background] Health check
[2024-01-07 18:27:23] [index:background] Health check
[2024-01-07 18:29:02] [indexer:background] Health check
[2024-01-07 18:30:37] [index:background] Health check
[2024-01-07 18:34:41] [indexer:background] Health check
[2024-01-07 18:36:30] [index:background] Health check
[2024-01-07 18:39:12] [indexer:background] Health check
[2024-01-07 18:43:09] [index:background] Health check
[2024-01-07 18:44:40] [indexer:background] Health check
[2024-01-07 18:47:41] [index:background] Health check
[2024-01-07 18:52:40] [indexer:background] Health check
[2024-01-07 18:52:40] [index:background] Health check
[2024-01-07 18:54:53] [indexer:background] Health check
[2024-01-07 18:55:28] [index:background] Health check
[2024-01-07 18:59:09] [indexer:background] Health check
[2024-01-07 19:00:24] [index:background] Health check
[2024-01-07 19:04:40] [indexer:background] Health check
[2024-01-07 19:07:22] [index:background] Health check
[2024-01-07 19:08:48] [indexer:background] Health check
[2024-01-07 19:10:46] [index:background] Health check
[2024-01-07 19:16:06] [indexer:background] Health check
[2024-01-07 19:16:06] [index:background] Health check
[2024-01-07 19:18:57] [indexer:background] Health check
[2024-01-07 19:21:50] [index:background] Health check
[2024-01-07 19:24:02] [indexer:background] Health check
[2024-01-07 19:25:47] [index:background] Health check
[2024-01-07 19:30:26] [indexer:background] Health check
[2024-01-07 19:30:26] [index:background] Health check
[2024-01-07 19:34:01] [indexer:background] Health check
[2024-01-07 19:37:22] [index:background] Health check
[2024-01-07 19:39:10] [indexer:background] Health check
[2024-01-07 19:40:41] [index:background] Health check
[2024-01-07 19:40:41] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2024-01-07 19:45:22] [indexer:background] Health check
[2024-01-07 19:46:33] [index:background] Health check
[2024-01-07 19:48:52] [indexer:background] Health check
[2024-01-07 19:48:52] [indexer:background] CPU load threshold (3) breached: 3.9 [waiting 2]
[2024-01-07 19:54:54] [index:background] Health check
[2024-01-07 19:54:54] [index:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2024-01-07 19:54:56] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2024-01-07 19:54:58] [indexer:background] Health check
[2024-01-07 19:54:58] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2]
[2024-01-07 19:55:00] [indexer:background] Health check
[2024-01-07 19:55:00] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2]
[2024-01-07 19:57:10] [index:background] Health check
[2024-01-07 19:57:10] [index:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-01-07 19:57:12] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-01-07 19:59:24] [indexer:background] Health check
[2024-01-07 19:59:24] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2024-01-07 20:01:39] [index:background] Health check
[2024-01-07 20:01:39] [index:background] CPU load threshold (3) breached: 4.1 [waiting 2]
[2024-01-07 20:01:41] [indexer:background] CPU load threshold (3) breached: 4.1 [waiting 2]
[2024-01-07 20:06:50] [indexer:background] Health check
[2024-01-07 20:06:50] [index:background] Health check
[2024-01-07 20:09:50] [indexer:background] Health check
[2024-01-07 20:09:50] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2024-01-07 20:10:55] [index:background] Health check
[2024-01-07 20:14:57] [indexer:background] Health check
[2024-01-07 20:16:08] [index:background] Health check
[2024-01-07 20:20:35] [indexer:background] Health check
[2024-01-07 20:20:35] [index:background] Health check
[2024-01-07 20:25:12] [indexer:background] Health check
[2024-01-07 20:25:26] [index:background] Health check
[2024-01-07 20:28:52] [indexer:background] Health check
[2024-01-07 20:30:56] [index:background] Health check
[2024-01-07 20:34:03] [indexer:background] Health check
[2024-01-07 20:37:12] [index:background] Health check
[2024-01-07 20:40:23] [indexer:background] Health check
[2024-01-07 20:40:23] [index:background] Health check
[2024-01-07 20:45:31] [indexer:background] Health check
[2024-01-07 20:45:31] [index:background] Health check
[2024-01-07 20:52:31] [indexer:background] Health check
[2024-01-07 20:52:31] [index:background] Health check
[2024-01-07 20:54:40] [indexer:background] Health check
[2024-01-07 20:55:34] [index:background] Health check
[2024-01-07 20:59:05] [indexer:background] Health check
[2024-01-07 21:02:05] [index:background] Health check
[2024-01-07 21:04:18] [indexer:background] Health check
[2024-01-07 21:07:01] [index:background] Health check
[2024-01-07 21:09:21] [indexer:background] Health check
[2024-01-07 21:10:30] [index:background] Health check
[2024-01-07 21:13:55] [indexer:background] Health check
[2024-01-07 21:15:33] [index:background] Health check
[2024-01-07 21:21:22] [indexer:background] Health check
[2024-01-07 21:21:22] [index:background] Health check
[2024-01-07 21:25:09] [indexer:background] Health check
[2024-01-07 21:25:29] [index:background] Health check
[2024-01-07 21:29:48] [indexer:background] Health check
[2024-01-07 21:30:37] [index:background] Health check
[2024-01-07 21:34:39] [indexer:background] Health check
[2024-01-07 21:35:49] [index:background] Health check
[2024-01-07 21:39:26] [indexer:background] Health check
[2024-01-07 21:40:41] [index:background] Health check
[2024-01-07 21:43:48] [indexer:background] Health check
[2024-01-07 21:46:06] [index:background] Health check
[2024-01-07 21:49:19] [indexer:background] Health check
[2024-01-07 21:50:39] [index:background] Health check
[2024-01-07 21:55:59] [indexer:background] Health check
[2024-01-07 21:55:59] [index:background] Health check
[2024-01-07 21:59:35] [indexer:background] Health check
[2024-01-07 22:05:17] [index:background] Health check
[2024-01-07 22:05:17] [indexer:background] Health check
[2024-01-07 22:05:17] [indexer:background] Health check
[2024-01-07 22:06:14] [index:background] Health check
[2024-01-07 22:09:44] [indexer:background] Health check
[2024-01-07 22:10:51] [index:background] Health check
[2024-01-07 22:14:04] [indexer:background] Health check
[2024-01-07 22:15:13] [query] Query for: 2024
[2024-01-07 22:15:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-07 22:15:13] [query] Engine: default
[2024-01-07 22:15:14] [query] Tokens: 2024
[2024-01-07 22:15:14] [query] Mods: 6
[2024-01-07 22:15:14] [query] Found results using: or logic
[2024-01-07 22:15: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
[2024-01-07 22:15:14] [query] Results: 132 Pages of results: 14
[2024-01-07 22:15:14] [query] Execution time: 0.49124
[2024-01-07 22:17:08] [index:background] Health check
[2024-01-07 22:18:59] [indexer:background] Health check
[2024-01-07 22:20:28] [index:background] Health check
[2024-01-07 22:24:05] [indexer:background] Health check
[2024-01-07 22:26:06] [index:background] Health check
[2024-01-07 22:30:16] [indexer:background] Health check
[2024-01-07 22:31:30] [index:background] Health check
[2024-01-07 22:34:10] [indexer:background] Health check
[2024-01-07 22:35:44] [index:background] Health check
[2024-01-07 22:38:50] [indexer:background] Health check
[2024-01-07 22:40:25] [index:background] Health check
[2024-01-07 22:43:48] [indexer:background] Health check
[2024-01-07 22:46:47] [index:background] Health check
[2024-01-07 22:49:03] [indexer:background] Health check
[2024-01-07 22:52:02] [index:background] Health check
[2024-01-07 22:53:57] [indexer:background] Health check
[2024-01-07 22:55:30] [index:background] Health check
[2024-01-07 22:58:55] [indexer:background] Health check
[2024-01-07 23:00:35] [index:background] Health check
[2024-01-07 23:04:15] [indexer:background] Health check
[2024-01-07 23:06:15] [index:background] Health check
[2024-01-07 23:09:24] [indexer:background] Health check
[2024-01-07 23:11:12] [index:background] Health check
[2024-01-07 23:14:47] [indexer:background] Health check
[2024-01-07 23:18:31] [index:background] Health check
[2024-01-07 23:18:53] [indexer:background] Health check
[2024-01-07 23:22:55] [index:background] Health check
[2024-01-07 23:22:55] [index:background] Health check
[2024-01-07 23:24:28] [indexer:background] Health check
[2024-01-07 23:25:34] [index:background] Health check
[2024-01-07 23:32:17] [indexer:background] Health check
[2024-01-07 23:32:17] [index:background] Health check
[2024-01-07 23:33:53] [indexer:background] Health check
[2024-01-07 23:35:39] [index:background] Health check
[2024-01-07 23:39:42] [indexer:background] Health check
[2024-01-07 23:40:31] [index:background] Health check
[2024-01-07 23:46:54] [indexer:background] Health check
[2024-01-07 23:46:54] [index:background] Health check
[2024-01-07 23:48:49] [indexer:background] Health check
[2024-01-07 23:50:29] [index:background] Health check
[2024-01-07 23:56:22] [indexer:background] Health check
[2024-01-07 23:56:22] [index:background] Health check
[2024-01-07 23:59:13] [indexer:background] Health check