[2023-11-20 00:01:14] [indexer:background] Health check [2023-11-20 00:03:59] [index:background] Health check [2023-11-20 00:05:27] [indexer:background] Health check [2023-11-20 00:08:04] [index:background] Health check [2023-11-20 00:08:04] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-20 00:09:36] [indexer:background] Health check [2023-11-20 00:13:48] [index:background] Health check [2023-11-20 00:14:55] [indexer:background] Health check [2023-11-20 00:18:59] [index:background] Health check [2023-11-20 00:19:33] [indexer:background] Health check [2023-11-20 00:27:48] [index:background] Health check [2023-11-20 00:27:48] [index:background] CPU load threshold (3) breached: 3.13 [waiting 2] [2023-11-20 00:27:50] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2] [2023-11-20 00:27:52] [indexer:background] Health check [2023-11-20 00:27:52] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2] [2023-11-20 00:27:54] [indexer:background] Health check [2023-11-20 00:27:54] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2] [2023-11-20 00:28:31] [index:background] Health check [2023-11-20 00:31:54] [indexer:background] Health check [2023-11-20 00:37:10] [index:background] Health check [2023-11-20 00:37:10] [indexer:background] Health check [2023-11-20 00:37:10] [indexer:background] Health check [2023-11-20 00:38:55] [index:background] Health check [2023-11-20 00:40:10] [indexer:background] Health check [2023-11-20 00:44:21] [index:background] Health check [2023-11-20 00:45:45] [indexer:background] Health check [2023-11-20 00:48:31] [index:background] Health check [2023-11-20 00:53:06] [query] Query for: 2024 [2023-11-20 00:53:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 00:53:06] [query] Engine: default [2023-11-20 00:53:06] [query] Tokens: 2024 [2023-11-20 00:53:06] [query] Mods: 6 [2023-11-20 00:53:06] [query] Found results using: or logic [2023-11-20 00:53:06] [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-11-20 00:53:06] [query] Results: 130 Pages of results: 13 [2023-11-20 00:53:06] [query] Execution time: 0.84042 [2023-11-20 00:53:06] [query] Query for: 2024 [2023-11-20 00:53:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-11-20 00:53:06] [query] Engine: default [2023-11-20 00:53:06] [query] Tokens: 2024 [2023-11-20 00:53:06] [query] Mods: 6 [2023-11-20 00:53:06] [query] Found results using: or logic [2023-11-20 00:53:06] [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-11-20 00:53:06] [query] Results: 130 Pages of results: 2 [2023-11-20 00:53:06] [query] Execution time: 0.10741 [2023-11-20 00:53:08] [indexer:background] Health check [2023-11-20 00:53:08] [index:background] Health check [2023-11-20 00:55:25] [indexer:background] Health check [2023-11-20 01:00:20] [index:background] Health check [2023-11-20 01:00:20] [indexer:background] Health check [2023-11-20 01:00:20] [indexer:background] Health check [2023-11-20 01:03:05] [index:background] Health check [2023-11-20 01:05:13] [indexer:background] Health check [2023-11-20 01:11:26] [index:background] Health check [2023-11-20 01:11:26] [indexer:background] Health check [2023-11-20 01:11:26] [indexer:background] Health check [2023-11-20 01:14:56] [index:background] Health check [2023-11-20 01:14:56] [indexer:background] Health check [2023-11-20 01:14:56] [indexer:background] Health check [2023-11-20 01:18:31] [index:background] Health check [2023-11-20 01:20:27] [indexer:background] Health check [2023-11-20 01:21:35] [query] Query for: 2024 [2023-11-20 01:21:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 01:21:35] [query] Engine: default [2023-11-20 01:21:35] [query] Tokens: 2024 [2023-11-20 01:21:35] [query] Mods: 6 [2023-11-20 01:21:35] [query] Found results using: or logic [2023-11-20 01:21:35] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-20 01:21:35] [query] Results: 130 Pages of results: 13 [2023-11-20 01:21:35] [query] Execution time: 0.04919 [2023-11-20 01:21:35] [query] Query for: 2024 [2023-11-20 01:21:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-11-20 01:21:35] [query] Engine: default [2023-11-20 01:21:35] [query] Tokens: 2024 [2023-11-20 01:21:35] [query] Mods: 6 [2023-11-20 01:21:35] [query] Found results using: or logic [2023-11-20 01:21:35] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-20 01:21:35] [query] Results: 130 Pages of results: 2 [2023-11-20 01:21:35] [query] Execution time: 0.07931 [2023-11-20 01:24:27] [index:background] Health check [2023-11-20 01:25:27] [indexer:background] Health check [2023-11-20 01:28:58] [index:background] Health check [2023-11-20 01:30:21] [indexer:background] Health check [2023-11-20 01:35:17] [index:background] Health check [2023-11-20 01:35:18] [indexer:background] Health check [2023-11-20 01:35:18] [indexer:background] Health check [2023-11-20 01:38:19] [index:background] Health check [2023-11-20 01:40:23] [indexer:background] Health check [2023-11-20 01:43:05] [index:background] Health check [2023-11-20 01:45:10] [indexer:background] Health check [2023-11-20 01:49:55] [index:background] Health check [2023-11-20 01:49:55] [indexer:background] Health check [2023-11-20 01:49:55] [indexer:background] Health check [2023-11-20 01:54:50] [index:background] Health check [2023-11-20 01:54:50] [indexer:background] Health check [2023-11-20 01:54:50] [indexer:background] Health check [2023-11-20 01:59:08] [index:background] Health check [2023-11-20 02:01:43] [indexer:background] Health check [2023-11-20 02:03:27] [index:background] Health check [2023-11-20 02:06:03] [indexer:background] Health check [2023-11-20 02:10:25] [index:background] Health check [2023-11-20 02:10:25] [indexer:background] Health check [2023-11-20 02:10:25] [indexer:background] Health check [2023-11-20 02:13:33] [index:background] Health check [2023-11-20 02:18:26] [indexer:background] Health check [2023-11-20 02:18:26] [index:background] Health check [2023-11-20 02:20:57] [indexer:background] Health check [2023-11-20 02:24:55] [index:background] Health check [2023-11-20 02:24:55] [indexer:background] Health check [2023-11-20 02:24:55] [indexer:background] Health check [2023-11-20 02:29:50] [index:background] Health check [2023-11-20 02:29:50] [indexer:background] Health check [2023-11-20 02:29:50] [indexer:background] Health check [2023-11-20 02:34:05] [index:background] Health check [2023-11-20 02:36:17] [indexer:background] Health check [2023-11-20 02:36:17] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-11-20 02:39:58] [index:background] Health check [2023-11-20 02:39:58] [index:background] CPU load threshold (3) breached: 4.01 [waiting 2] [2023-11-20 02:40:00] [indexer:background] CPU load threshold (3) breached: 4.01 [waiting 2] [2023-11-20 02:40:02] [indexer:background] Health check [2023-11-20 02:40:02] [indexer:background] CPU load threshold (3) breached: 4.01 [waiting 2] [2023-11-20 02:40:04] [indexer:background] Health check [2023-11-20 02:40:04] [indexer:background] CPU load threshold (3) breached: 4.01 [waiting 2] [2023-11-20 02:44:46] [index:background] Health check [2023-11-20 02:44:46] [index:background] CPU load threshold (3) breached: 4.11 [waiting 2] [2023-11-20 02:44:48] [indexer:background] CPU load threshold (3) breached: 4.27 [waiting 2] [2023-11-20 02:44:50] [indexer:background] Health check [2023-11-20 02:44:51] [indexer:background] CPU load threshold (3) breached: 4.27 [waiting 2] [2023-11-20 02:44:53] [indexer:background] Health check [2023-11-20 02:44:53] [indexer:background] CPU load threshold (3) breached: 4.57 [waiting 2] [2023-11-20 02:48:37] [index:background] Health check [2023-11-20 02:48:37] [index:background] CPU load threshold (3) breached: 4.33 [waiting 2] [2023-11-20 02:48:39] [indexer:background] CPU load threshold (3) breached: 4.14 [waiting 2] [2023-11-20 02:53:16] [indexer:background] Health check [2023-11-20 02:53:16] [indexer:background] CPU load threshold (3) breached: 3.75 [waiting 2] [2023-11-20 02:53:18] [index:background] Health check [2023-11-20 02:53:18] [index:background] CPU load threshold (3) breached: 3.85 [waiting 2] [2023-11-20 02:53:20] [indexer:background] CPU load threshold (3) breached: 3.85 [waiting 2] [2023-11-20 02:54:57] [indexer:background] Health check [2023-11-20 02:54:57] [indexer:background] CPU load threshold (3) breached: 4.83 [waiting 2] [2023-11-20 02:58:38] [index:background] Health check [2023-11-20 02:58:38] [index:background] CPU load threshold (3) breached: 4.51 [waiting 2] [2023-11-20 02:58:40] [indexer:background] CPU load threshold (3) breached: 4.51 [waiting 2] [2023-11-20 02:59:46] [indexer:background] Health check [2023-11-20 02:59:46] [indexer:background] CPU load threshold (3) breached: 5.42 [waiting 2] [2023-11-20 03:03:07] [index:background] Health check [2023-11-20 03:03:07] [index:background] CPU load threshold (3) breached: 4.55 [waiting 2] [2023-11-20 03:03:09] [indexer:background] CPU load threshold (3) breached: 4.43 [waiting 2] [2023-11-20 03:05:44] [indexer:background] Health check [2023-11-20 03:05:44] [indexer:background] CPU load threshold (3) breached: 5.04 [waiting 2] [2023-11-20 03:09:33] [index:background] Health check [2023-11-20 03:09:33] [index:background] CPU load threshold (3) breached: 4.13 [waiting 2] [2023-11-20 03:09:35] [indexer:background] CPU load threshold (3) breached: 4.2 [waiting 2] [2023-11-20 03:09:37] [indexer:background] Health check [2023-11-20 03:09:37] [indexer:background] CPU load threshold (3) breached: 4.2 [waiting 2] [2023-11-20 03:09:39] [indexer:background] Health check [2023-11-20 03:09:39] [indexer:background] CPU load threshold (3) breached: 4.11 [waiting 2] [2023-11-20 03:13:24] [index:background] Health check [2023-11-20 03:13:24] [index:background] CPU load threshold (3) breached: 4.21 [waiting 2] [2023-11-20 03:13:26] [indexer:background] CPU load threshold (3) breached: 4.28 [waiting 2] [2023-11-20 03:14:41] [indexer:background] Health check [2023-11-20 03:14:41] [indexer:background] CPU load threshold (3) breached: 5.39 [waiting 2] [2023-11-20 03:18:47] [index:background] Health check [2023-11-20 03:18:47] [index:background] CPU load threshold (3) breached: 5.36 [waiting 2] [2023-11-20 03:18:50] [indexer:background] CPU load threshold (3) breached: 5.17 [waiting 2] [2023-11-20 03:20:46] [indexer:background] Health check [2023-11-20 03:20:46] [indexer:background] CPU load threshold (3) breached: 4.54 [waiting 2] [2023-11-20 03:25:26] [index:background] Health check [2023-11-20 03:25:26] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-11-20 03:25:28] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-11-20 03:25:30] [indexer:background] Health check [2023-11-20 03:25:30] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-11-20 03:25:32] [indexer:background] Health check [2023-11-20 03:25:32] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-11-20 03:28:24] [index:background] Health check [2023-11-20 03:28:24] [index:background] CPU load threshold (3) breached: 3.91 [waiting 2] [2023-11-20 03:28:26] [indexer:background] CPU load threshold (3) breached: 3.76 [waiting 2] [2023-11-20 03:29:45] [indexer:background] Health check [2023-11-20 03:29:45] [indexer:background] CPU load threshold (3) breached: 3.8 [waiting 2] [2023-11-20 03:33:07] [index:background] Health check [2023-11-20 03:35:02] [indexer:background] Health check [2023-11-20 03:38:39] [index:background] Health check [2023-11-20 03:39:42] [indexer:background] Health check [2023-11-20 03:44:16] [index:background] Health check [2023-11-20 03:44:16] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-20 03:44:18] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-20 03:46:18] [indexer:background] Health check [2023-11-20 03:48:13] [index:background] Health check [2023-11-20 03:48:13] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 03:48:15] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 03:49:45] [indexer:background] Health check [2023-11-20 03:53:59] [index:background] Health check [2023-11-20 03:55:34] [indexer:background] Health check [2023-11-20 03:58:11] [index:background] Health check [2023-11-20 04:02:03] [indexer:background] Health check [2023-11-20 04:03:57] [index:background] Health check [2023-11-20 04:05:16] [indexer:background] Health check [2023-11-20 04:08:38] [index:background] Health check [2023-11-20 04:10:47] [indexer:background] Health check [2023-11-20 04:13:11] [index:background] Health check [2023-11-20 04:14:47] [indexer:background] Health check [2023-11-20 04:19:11] [index:background] Health check [2023-11-20 04:19:11] [query] Query for: 2023 [2023-11-20 04:19:11] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 04:19:11] [query] Engine: default [2023-11-20 04:19:11] [query] Tokens: 2023 [2023-11-20 04:19:11] [query] Mods: 6 [2023-11-20 04:19:12] [query] Found results using: or logic [2023-11-20 04:19:12] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-20 04:19:12] [query] Results: 253 Pages of results: 26 [2023-11-20 04:19:12] [query] Execution time: 0.56489 [2023-11-20 04:19:12] [query] Query for: 2023 [2023-11-20 04:19:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-11-20 04:19:12] [query] Engine: default [2023-11-20 04:19:12] [query] Tokens: 2023 [2023-11-20 04:19:12] [query] Mods: 6 [2023-11-20 04:19:12] [query] Found results using: or logic [2023-11-20 04:19:12] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-20 04:19:12] [query] Results: 253 Pages of results: 3 [2023-11-20 04:19:12] [query] Execution time: 0.09760 [2023-11-20 04:20:20] [indexer:background] Health check [2023-11-20 04:23:43] [index:background] Health check [2023-11-20 04:24:32] [indexer:background] Health check [2023-11-20 04:28:26] [index:background] Health check [2023-11-20 04:30:06] [indexer:background] Health check [2023-11-20 04:33:06] [index:background] Health check [2023-11-20 04:33:06] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-20 04:33:08] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2] [2023-11-20 04:34:49] [indexer:background] Health check [2023-11-20 04:38:49] [index:background] Health check [2023-11-20 04:40:24] [indexer:background] Health check [2023-11-20 04:43:58] [index:background] Health check [2023-11-20 04:44:59] [indexer:background] Health check [2023-11-20 04:48:09] [index:background] Health check [2023-11-20 04:50:18] [indexer:background] Health check [2023-11-20 04:53:43] [index:background] Health check [2023-11-20 04:55:12] [indexer:background] Health check [2023-11-20 04:59:08] [index:background] Health check [2023-11-20 04:59:58] [indexer:background] Health check [2023-11-20 05:03:26] [index:background] Health check [2023-11-20 05:04:55] [indexer:background] Health check [2023-11-20 05:09:02] [index:background] Health check [2023-11-20 05:10:22] [indexer:background] Health check [2023-11-20 05:14:36] [index:background] Health check [2023-11-20 05:14:38] [indexer:background] Health check [2023-11-20 05:14:38] [indexer:background] Health check [2023-11-20 05:18:45] [index:background] Health check [2023-11-20 05:20:06] [indexer:background] Health check [2023-11-20 05:23:21] [index:background] Health check [2023-11-20 05:24:48] [indexer:background] Health check [2023-11-20 05:28:07] [index:background] Health check [2023-11-20 05:30:05] [indexer:background] Health check [2023-11-20 05:33:13] [index:background] Health check [2023-11-20 05:35:20] [indexer:background] Health check [2023-11-20 05:38:14] [index:background] Health check [2023-11-20 05:39:34] [indexer:background] Health check [2023-11-20 05:43:06] [index:background] Health check [2023-11-20 05:44:53] [indexer:background] Health check [2023-11-20 05:48:47] [index:background] Health check [2023-11-20 05:49:54] [indexer:background] Health check [2023-11-20 05:53:28] [index:background] Health check [2023-11-20 05:54:58] [indexer:background] Health check [2023-11-20 05:58:15] [index:background] Health check [2023-11-20 06:00:29] [indexer:background] Health check [2023-11-20 06:03:15] [index:background] Health check [2023-11-20 06:04:38] [indexer:background] Health check [2023-11-20 06:08:47] [index:background] Health check [2023-11-20 06:10:16] [indexer:background] Health check [2023-11-20 06:15:31] [index:background] Health check [2023-11-20 06:15:34] [indexer:background] Health check [2023-11-20 06:15:34] [indexer:background] Health check [2023-11-20 06:18:32] [index:background] Health check [2023-11-20 06:19:33] [indexer:background] Health check [2023-11-20 06:23:23] [index:background] Health check [2023-11-20 06:27:01] [indexer:background] Health check [2023-11-20 06:29:14] [index:background] Health check [2023-11-20 06:29:44] [indexer:background] Health check [2023-11-20 06:35:40] [index:background] Health check [2023-11-20 06:35:40] [indexer:background] Health check [2023-11-20 06:35:40] [indexer:background] Health check [2023-11-20 06:38:29] [index:background] Health check [2023-11-20 06:39:44] [indexer:background] Health check [2023-11-20 06:44:05] [index:background] Health check [2023-11-20 06:45:12] [indexer:background] Health check [2023-11-20 06:48:29] [index:background] Health check [2023-11-20 06:50:03] [indexer:background] Health check [2023-11-20 06:53:05] [index:background] Health check [2023-11-20 06:54:45] [indexer:background] Health check [2023-11-20 06:58:43] [index:background] Health check [2023-11-20 07:00:29] [indexer:background] Health check [2023-11-20 07:03:43] [index:background] Health check [2023-11-20 07:06:59] [indexer:background] Health check [2023-11-20 07:08:10] [index:background] Health check [2023-11-20 07:12:07] [indexer:background] Health check [2023-11-20 07:13:24] [index:background] Health check [2023-11-20 07:15:30] [indexer:background] Health check [2023-11-20 07:18:42] [index:background] Health check [2023-11-20 07:21:07] [indexer:background] Health check [2023-11-20 07:23:09] [index:background] Health check [2023-11-20 07:24:44] [indexer:background] Health check [2023-11-20 07:28:14] [index:background] Health check [2023-11-20 07:30:16] [indexer:background] Health check [2023-11-20 07:33:47] [index:background] Health check [2023-11-20 07:34:42] [indexer:background] Health check [2023-11-20 07:38:59] [index:background] Health check [2023-11-20 07:40:00] [indexer:background] Health check [2023-11-20 07:43:30] [index:background] Health check [2023-11-20 07:45:43] [indexer:background] Health check [2023-11-20 07:48:04] [index:background] Health check [2023-11-20 07:49:49] [indexer:background] Health check [2023-11-20 07:53:28] [index:background] Health check [2023-11-20 07:57:21] [indexer:background] Health check [2023-11-20 07:58:44] [index:background] Health check [2023-11-20 08:00:09] [indexer:background] Health check [2023-11-20 08:00:10] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2023-11-20 08:03:24] [index:background] Health check [2023-11-20 08:04:34] [indexer:background] Health check [2023-11-20 08:04:34] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2] [2023-11-20 08:08:59] [index:background] Health check [2023-11-20 08:11:42] [indexer:background] Health check [2023-11-20 08:13:42] [index:background] Health check [2023-11-20 08:13:42] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-11-20 08:13:44] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2023-11-20 08:14:52] [indexer:background] Health check [2023-11-20 08:18:07] [index:background] Health check [2023-11-20 08:20:01] [indexer:background] Health check [2023-11-20 08:24:05] [index:background] Health check [2023-11-20 08:24:05] [index:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-11-20 08:24:07] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2] [2023-11-20 08:26:04] [indexer:background] Health check [2023-11-20 08:28:05] [index:background] Health check [2023-11-20 08:28:05] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2] [2023-11-20 08:28:07] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2] [2023-11-20 08:30:31] [indexer:background] Health check [2023-11-20 08:33:23] [index:background] Health check [2023-11-20 08:33:23] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 08:33:25] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2] [2023-11-20 08:35:09] [indexer:background] Health check [2023-11-20 08:35:09] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2] [2023-11-20 08:38:41] [index:background] Health check [2023-11-20 08:39:40] [indexer:background] Health check [2023-11-20 08:41:12] [query] Query for: 2024 [2023-11-20 08:41:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 08:41:12] [query] Engine: default [2023-11-20 08:41:12] [query] Tokens: 2024 [2023-11-20 08:41:12] [query] Mods: 6 [2023-11-20 08:41:12] [query] Found results using: or logic [2023-11-20 08:41:12] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2023-11-20 08:41:12] [query] Results: 130 Pages of results: 13 [2023-11-20 08:41:12] [query] Execution time: 0.05127 [2023-11-20 08:43:33] [index:background] Health check [2023-11-20 08:44:49] [indexer:background] Health check [2023-11-20 08:48:23] [index:background] Health check [2023-11-20 08:51:00] [indexer:background] Health check [2023-11-20 08:54:42] [index:background] Health check [2023-11-20 08:54:42] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-20 08:54:44] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-20 08:54:46] [indexer:background] Health check [2023-11-20 08:54:46] [indexer:background] CPU load threshold (3) breached: 6.04 [waiting 2] [2023-11-20 08:54:48] [indexer:background] Health check [2023-11-20 08:54:48] [indexer:background] CPU load threshold (3) breached: 6.04 [waiting 2] [2023-11-20 08:58:15] [index:background] Health check [2023-11-20 08:59:37] [indexer:background] Health check [2023-11-20 09:03:51] [index:background] Health check [2023-11-20 09:04:41] [indexer:background] Health check [2023-11-20 09:08:32] [index:background] Health check [2023-11-20 09:09:32] [indexer:background] Health check [2023-11-20 09:13:15] [index:background] Health check [2023-11-20 09:15:02] [indexer:background] Health check [2023-11-20 09:15:02] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 09:18:16] [index:background] Health check [2023-11-20 09:19:41] [indexer:background] Health check [2023-11-20 09:24:28] [index:background] Health check [2023-11-20 09:24:54] [indexer:background] Health check [2023-11-20 09:28:06] [index:background] Health check [2023-11-20 09:29:54] [indexer:background] Health check [2023-11-20 09:33:17] [index:background] Health check [2023-11-20 09:36:40] [indexer:background] Health check [2023-11-20 09:36:40] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2] [2023-11-20 09:38:04] [index:background] Health check [2023-11-20 09:38:04] [index:background] CPU load threshold (3) breached: 3.84 [waiting 2] [2023-11-20 09:38:06] [indexer:background] CPU load threshold (3) breached: 3.84 [waiting 2] [2023-11-20 09:39:56] [indexer:background] Health check [2023-11-20 09:39:56] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2] [2023-11-20 09:44:37] [index:background] Health check [2023-11-20 09:44:37] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-11-20 09:44:39] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2023-11-20 09:44:41] [indexer:background] Health check [2023-11-20 09:44:41] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2] [2023-11-20 09:44:43] [indexer:background] Health check [2023-11-20 09:44:43] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-11-20 09:48:32] [index:background] Health check [2023-11-20 09:48:32] [index:background] CPU load threshold (3) breached: 3.12 [waiting 2] [2023-11-20 09:48:34] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-20 09:50:07] [indexer:background] Health check [2023-11-20 09:53:58] [index:background] Health check [2023-11-20 09:53:58] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2] [2023-11-20 09:54:00] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2] [2023-11-20 09:55:50] [indexer:background] Health check [2023-11-20 09:58:27] [index:background] Health check [2023-11-20 09:58:27] [index:background] CPU load threshold (3) breached: 3.53 [waiting 2] [2023-11-20 09:58:29] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-11-20 10:00:02] [indexer:background] Health check [2023-11-20 10:00:02] [indexer:background] CPU load threshold (3) breached: 4.1 [waiting 2] [2023-11-20 10:03:06] [index:background] Health check [2023-11-20 10:03:06] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-11-20 10:03:08] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2] [2023-11-20 10:04:58] [indexer:background] Health check [2023-11-20 10:04:59] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2023-11-20 10:08:05] [index:background] Health check [2023-11-20 10:08:05] [index:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-11-20 10:08:07] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-11-20 10:09:59] [indexer:background] Health check [2023-11-20 10:09:59] [indexer:background] CPU load threshold (3) breached: 3.79 [waiting 2] [2023-11-20 10:13:04] [index:background] Health check [2023-11-20 10:13:04] [index:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-11-20 10:13:07] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-11-20 10:15:28] [indexer:background] Health check [2023-11-20 10:15:28] [indexer:background] CPU load threshold (3) breached: 4.03 [waiting 2] [2023-11-20 10:18:35] [index:background] Health check [2023-11-20 10:18:35] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2023-11-20 10:18:37] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2023-11-20 10:20:18] [indexer:background] Health check [2023-11-20 10:20:18] [indexer:background] CPU load threshold (3) breached: 4.29 [waiting 2] [2023-11-20 10:24:45] [index:background] Health check [2023-11-20 10:24:45] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-11-20 10:24:47] [indexer:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-11-20 10:24:49] [indexer:background] Health check [2023-11-20 10:24:49] [indexer:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-11-20 10:24:51] [indexer:background] Health check [2023-11-20 10:24:51] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2] [2023-11-20 10:28:07] [index:background] Health check [2023-11-20 10:28:07] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 10:28:09] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 10:30:04] [indexer:background] Health check [2023-11-20 10:30:04] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2] [2023-11-20 10:33:17] [index:background] Health check [2023-11-20 10:33:17] [index:background] CPU load threshold (3) breached: 4.17 [waiting 2] [2023-11-20 10:33:19] [indexer:background] CPU load threshold (3) breached: 4.17 [waiting 2] [2023-11-20 10:34:33] [indexer:background] Health check [2023-11-20 10:34:33] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-11-20 10:38:56] [index:background] Health check [2023-11-20 10:38:57] [index:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-11-20 10:38:59] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-11-20 10:39:34] [indexer:background] Health check [2023-11-20 10:39:34] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 10:43:10] [index:background] Health check [2023-11-20 10:43:10] [index:background] CPU load threshold (3) breached: 3.94 [waiting 2] [2023-11-20 10:43:12] [indexer:background] CPU load threshold (3) breached: 4.02 [waiting 2] [2023-11-20 10:44:34] [indexer:background] Health check [2023-11-20 10:44:34] [indexer:background] CPU load threshold (3) breached: 3.85 [waiting 2] [2023-11-20 10:48:06] [index:background] Health check [2023-11-20 10:48:06] [index:background] CPU load threshold (3) breached: 4.2 [waiting 2] [2023-11-20 10:48:08] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-11-20 10:51:48] [indexer:background] Health check [2023-11-20 10:51:48] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2] [2023-11-20 10:53:59] [index:background] Health check [2023-11-20 10:53:59] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2] [2023-11-20 10:54:42] [indexer:background] Health check [2023-11-20 10:54:42] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2023-11-20 10:58:24] [index:background] Health check [2023-11-20 10:58:24] [index:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-11-20 10:58:26] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 10:59:57] [indexer:background] Health check [2023-11-20 10:59:57] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-11-20 11:04:26] [index:background] Health check [2023-11-20 11:04:26] [index:background] CPU load threshold (3) breached: 3.41 [waiting 2] [2023-11-20 11:04:28] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2023-11-20 11:04:55] [indexer:background] Health check [2023-11-20 11:04:55] [indexer:background] CPU load threshold (3) breached: 3.87 [waiting 2] [2023-11-20 11:09:29] [index:background] Health check [2023-11-20 11:09:53] [indexer:background] Health check [2023-11-20 11:13:21] [index:background] Health check [2023-11-20 11:15:00] [indexer:background] Health check [2023-11-20 11:18:04] [index:background] Health check [2023-11-20 11:19:56] [indexer:background] Health check [2023-11-20 11:24:17] [index:background] Health check [2023-11-20 11:24:44] [indexer:background] Health check [2023-11-20 11:28:24] [index:background] Health check [2023-11-20 11:30:03] [indexer:background] Health check [2023-11-20 11:30:03] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2] [2023-11-20 11:33:42] [index:background] Health check [2023-11-20 11:36:27] [indexer:background] Health check [2023-11-20 11:38:28] [index:background] Health check [2023-11-20 11:39:49] [indexer:background] Health check [2023-11-20 11:44:16] [index:background] Health check [2023-11-20 11:45:12] [indexer:background] Health check [2023-11-20 11:49:08] [index:background] Health check [2023-11-20 11:49:51] [indexer:background] Health check [2023-11-20 11:53:56] [index:background] Health check [2023-11-20 11:54:32] [indexer:background] Health check [2023-11-20 11:59:15] [index:background] Health check [2023-11-20 12:00:56] [indexer:background] Health check [2023-11-20 12:03:10] [index:background] Health check [2023-11-20 12:04:50] [indexer:background] Health check [2023-11-20 12:09:09] [index:background] Health check [2023-11-20 12:09:37] [indexer:background] Health check [2023-11-20 12:13:37] [index:background] Health check [2023-11-20 12:15:34] [indexer:background] Health check [2023-11-20 12:18:32] [index:background] Health check [2023-11-20 12:20:43] [indexer:background] Health check [2023-11-20 12:23:44] [index:background] Health check [2023-11-20 12:24:47] [indexer:background] Health check [2023-11-20 12:28:28] [index:background] Health check [2023-11-20 12:28:28] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-11-20 12:28:30] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-11-20 12:31:28] [indexer:background] Health check [2023-11-20 12:34:27] [index:background] Health check [2023-11-20 12:35:02] [indexer:background] Health check [2023-11-20 12:38:13] [index:background] Health check [2023-11-20 12:40:17] [indexer:background] Health check [2023-11-20 12:40:17] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-11-20 12:43:10] [index:background] Health check [2023-11-20 12:44:55] [indexer:background] Health check [2023-11-20 12:49:42] [index:background] Health check [2023-11-20 12:49:42] [indexer:background] Health check [2023-11-20 12:49:42] [indexer:background] Health check [2023-11-20 12:53:49] [index:background] Health check [2023-11-20 12:55:34] [indexer:background] Health check [2023-11-20 12:58:26] [index:background] Health check [2023-11-20 12:59:39] [indexer:background] Health check [2023-11-20 13:03:08] [index:background] Health check [2023-11-20 13:03:08] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-11-20 13:03:10] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-11-20 13:06:32] [indexer:background] Health check [2023-11-20 13:08:22] [index:background] Health check [2023-11-20 13:08:22] [index:background] CPU load threshold (3) breached: 3.13 [waiting 2] [2023-11-20 13:08:24] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2] [2023-11-20 13:11:11] [indexer:background] Health check [2023-11-20 13:13:15] [index:background] Health check [2023-11-20 13:15:05] [indexer:background] Health check [2023-11-20 13:18:03] [index:background] Health check [2023-11-20 13:18:03] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2023-11-20 13:18:05] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2023-11-20 13:19:33] [indexer:background] Health check [2023-11-20 13:19:33] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2] [2023-11-20 13:20:33] [query] Query for: 2024 [2023-11-20 13:20:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 13:20:33] [query] Engine: default [2023-11-20 13:20:33] [query] Tokens: 2024 [2023-11-20 13:20:33] [query] Mods: 6 [2023-11-20 13:20:33] [query] Found results using: or logic [2023-11-20 13:20: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 (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-11-20 13:20:33] [query] Results: 130 Pages of results: 13 [2023-11-20 13:20:33] [query] Execution time: 0.43034 [2023-11-20 13:23:55] [index:background] Health check [2023-11-20 13:23:55] [index:background] CPU load threshold (3) breached: 4.24 [waiting 2] [2023-11-20 13:23:57] [indexer:background] CPU load threshold (3) breached: 4.24 [waiting 2] [2023-11-20 13:25:54] [indexer:background] Health check [2023-11-20 13:25:54] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-20 13:28:16] [index:background] Health check [2023-11-20 13:30:16] [indexer:background] Health check [2023-11-20 13:33:37] [index:background] Health check [2023-11-20 13:34:51] [indexer:background] Health check [2023-11-20 13:40:31] [index:background] Health check [2023-11-20 13:40:31] [indexer:background] Health check [2023-11-20 13:40:31] [indexer:background] Health check [2023-11-20 13:43:48] [index:background] Health check [2023-11-20 13:43:48] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 13:43:50] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2] [2023-11-20 13:45:16] [indexer:background] Health check [2023-11-20 13:45:16] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2] [2023-11-20 13:48:11] [index:background] Health check [2023-11-20 13:48:11] [index:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2023-11-20 13:48:13] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2023-11-20 13:54:48] [indexer:background] Health check [2023-11-20 13:54:48] [indexer:background] CPU load threshold (3) breached: 3.59 [waiting 2] [2023-11-20 13:54:50] [index:background] Health check [2023-11-20 13:54:50] [index:background] CPU load threshold (3) breached: 3.71 [waiting 2] [2023-11-20 13:54:52] [indexer:background] CPU load threshold (3) breached: 3.71 [waiting 2] [2023-11-20 13:58:39] [index:background] Health check [2023-11-20 13:58:39] [index:background] CPU load threshold (3) breached: 3.45 [waiting 2] [2023-11-20 13:58:41] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2] [2023-11-20 14:00:19] [indexer:background] Health check [2023-11-20 14:00:19] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2] [2023-11-20 14:03:15] [index:background] Health check [2023-11-20 14:03:15] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 14:03:17] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 14:04:41] [indexer:background] Health check [2023-11-20 14:04:41] [indexer:background] CPU load threshold (3) breached: 4.98 [waiting 2] [2023-11-20 14:08:06] [index:background] Health check [2023-11-20 14:11:08] [indexer:background] Health check [2023-11-20 14:13:27] [index:background] Health check [2023-11-20 14:15:04] [indexer:background] Health check [2023-11-20 14:15:04] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2] [2023-11-20 14:18:26] [index:background] Health check [2023-11-20 14:20:58] [indexer:background] Health check [2023-11-20 14:23:05] [index:background] Health check [2023-11-20 14:23:05] [index:background] CPU load threshold (3) breached: 4.18 [waiting 2] [2023-11-20 14:23:07] [indexer:background] CPU load threshold (3) breached: 3.84 [waiting 2] [2023-11-20 14:24:50] [indexer:background] Health check [2023-11-20 14:24:50] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-20 14:28:47] [index:background] Health check [2023-11-20 14:29:44] [indexer:background] Health check [2023-11-20 14:29:45] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2] [2023-11-20 14:33:16] [index:background] Health check [2023-11-20 14:33:16] [index:background] CPU load threshold (3) breached: 3.34 [waiting 2] [2023-11-20 14:33:18] [indexer:background] CPU load threshold (3) breached: 3.47 [waiting 2] [2023-11-20 14:35:03] [indexer:background] Health check [2023-11-20 14:35:03] [indexer:background] CPU load threshold (3) breached: 3.38 [waiting 2] [2023-11-20 14:38:24] [index:background] Health check [2023-11-20 14:38:24] [index:background] CPU load threshold (3) breached: 3.92 [waiting 2] [2023-11-20 14:38:26] [indexer:background] CPU load threshold (3) breached: 3.92 [waiting 2] [2023-11-20 14:39:38] [indexer:background] Health check [2023-11-20 14:39:38] [indexer:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2023-11-20 14:45:12] [index:background] Health check [2023-11-20 14:45:12] [index:background] CPU load threshold (3) breached: 4.47 [waiting 2] [2023-11-20 14:45:14] [indexer:background] CPU load threshold (3) breached: 4.47 [waiting 2] [2023-11-20 14:45:16] [indexer:background] Health check [2023-11-20 14:45:16] [indexer:background] CPU load threshold (3) breached: 4.47 [waiting 2] [2023-11-20 14:45:18] [indexer:background] Health check [2023-11-20 14:45:18] [indexer:background] CPU load threshold (3) breached: 4.67 [waiting 2] [2023-11-20 14:48:12] [index:background] Health check [2023-11-20 14:49:34] [indexer:background] Health check [2023-11-20 14:49:34] [indexer:background] CPU load threshold (3) breached: 3.46 [waiting 2] [2023-11-20 14:54:00] [index:background] Health check [2023-11-20 14:54:40] [indexer:background] Health check [2023-11-20 14:57:25] [query] Query for: search_term_string [2023-11-20 14:57:25] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 14:57:25] [query] Engine: default [2023-11-20 14:57:26] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-11-20 14:57:26] [query] Mods: 6 [2023-11-20 14:57:26] [query] Using OR logic [2023-11-20 14:57:27] [query] Found results using: or logic [2023-11-20 14:57:27] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-20 14:57:27] [query] Results: 1346 Pages of results: 135 [2023-11-20 14:57:27] [query] Execution time: 1.42821 [2023-11-20 14:59:05] [index:background] Health check [2023-11-20 15:00:11] [indexer:background] Health check [2023-11-20 15:00:11] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2023-11-20 15:01:34] [query] Query for: search_term_string [2023-11-20 15:01:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 15:01:34] [query] Engine: default [2023-11-20 15:01:34] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-11-20 15:01:34] [query] Mods: 6 [2023-11-20 15:01:34] [query] Using OR logic [2023-11-20 15:01:34] [query] Found results using: or logic [2023-11-20 15:01:34] [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-11-20 15:01:34] [query] Results: 1346 Pages of results: 135 [2023-11-20 15:01:34] [query] Execution time: 0.05767 [2023-11-20 15:03:29] [index:background] Health check [2023-11-20 15:03:29] [index:background] CPU load threshold (3) breached: 4.12 [waiting 2] [2023-11-20 15:03:31] [indexer:background] CPU load threshold (3) breached: 4.12 [waiting 2] [2023-11-20 15:05:01] [indexer:background] Health check [2023-11-20 15:05:01] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-11-20 15:08:32] [index:background] Health check [2023-11-20 15:08:32] [index:background] CPU load threshold (3) breached: 3.52 [waiting 2] [2023-11-20 15:08:34] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-11-20 15:11:52] [indexer:background] Health check [2023-11-20 15:11:52] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-11-20 15:13:04] [index:background] Health check [2023-11-20 15:13:04] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-20 15:13:06] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-20 15:14:54] [indexer:background] Health check [2023-11-20 15:18:21] [index:background] Health check [2023-11-20 15:18:21] [index:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-11-20 15:18:23] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2] [2023-11-20 15:19:37] [indexer:background] Health check [2023-11-20 15:19:37] [indexer:background] CPU load threshold (3) breached: 3.35 [waiting 2] [2023-11-20 15:23:09] [index:background] Health check [2023-11-20 15:25:21] [indexer:background] Health check [2023-11-20 15:28:30] [index:background] Health check [2023-11-20 15:30:50] [indexer:background] Health check [2023-11-20 15:30:50] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-11-20 15:33:26] [index:background] Health check [2023-11-20 15:33:26] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-11-20 15:33:28] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-11-20 15:35:26] [indexer:background] Health check [2023-11-20 15:38:47] [index:background] Health check [2023-11-20 15:38:47] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 15:38:49] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-20 15:40:21] [indexer:background] Health check [2023-11-20 15:40:21] [indexer:background] CPU load threshold (3) breached: 3.87 [waiting 2] [2023-11-20 15:43:54] [index:background] Health check [2023-11-20 15:43:54] [index:background] CPU load threshold (3) breached: 3.77 [waiting 2] [2023-11-20 15:43:56] [indexer:background] CPU load threshold (3) breached: 3.7 [waiting 2] [2023-11-20 15:46:35] [indexer:background] Health check [2023-11-20 15:46:35] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2023-11-20 15:48:25] [index:background] Health check [2023-11-20 15:48:25] [index:background] CPU load threshold (3) breached: 3.71 [waiting 2] [2023-11-20 15:48:27] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2023-11-20 15:49:34] [indexer:background] Health check [2023-11-20 15:49:35] [indexer:background] CPU load threshold (3) breached: 4.15 [waiting 2] [2023-11-20 15:53:11] [index:background] Health check [2023-11-20 15:53:11] [index:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-11-20 15:53:13] [indexer:background] CPU load threshold (3) breached: 3.64 [waiting 2] [2023-11-20 15:54:39] [indexer:background] Health check [2023-11-20 15:54:39] [indexer:background] CPU load threshold (3) breached: 4.45 [waiting 2] [2023-11-20 15:58:35] [index:background] Health check [2023-11-20 15:58:35] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-11-20 15:58:37] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 15:59:35] [indexer:background] Health check [2023-11-20 15:59:35] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2] [2023-11-20 16:04:59] [index:background] Health check [2023-11-20 16:04:59] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2023-11-20 16:05:01] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2023-11-20 16:05:03] [indexer:background] Health check [2023-11-20 16:05:03] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2023-11-20 16:05:05] [indexer:background] Health check [2023-11-20 16:05:05] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2] [2023-11-20 16:08:34] [index:background] Health check [2023-11-20 16:09:41] [indexer:background] Health check [2023-11-20 16:09:41] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2] [2023-11-20 16:15:54] [index:background] Health check [2023-11-20 16:15:54] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-11-20 16:15:56] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-11-20 16:15:58] [indexer:background] Health check [2023-11-20 16:15:58] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-11-20 16:16:00] [indexer:background] Health check [2023-11-20 16:16:00] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-11-20 16:18:12] [index:background] Health check [2023-11-20 16:18:12] [index:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-11-20 16:18:14] [indexer:background] CPU load threshold (3) breached: 3.01 [waiting 2] [2023-11-20 16:21:34] [indexer:background] Health check [2023-11-20 16:21:34] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2] [2023-11-20 16:23:05] [index:background] Health check [2023-11-20 16:24:55] [indexer:background] Health check [2023-11-20 16:24:55] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2] [2023-11-20 16:28:26] [index:background] Health check [2023-11-20 16:28:26] [index:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-11-20 16:28:28] [indexer:background] CPU load threshold (3) breached: 3.87 [waiting 2] [2023-11-20 16:29:33] [indexer:background] Health check [2023-11-20 16:29:33] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2] [2023-11-20 16:33:14] [index:background] Health check [2023-11-20 16:33:14] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-20 16:33:16] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-20 16:34:36] [indexer:background] Health check [2023-11-20 16:38:50] [index:background] Health check [2023-11-20 16:38:50] [index:background] CPU load threshold (3) breached: 3.15 [waiting 2] [2023-11-20 16:38:52] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2] [2023-11-20 16:39:37] [indexer:background] Health check [2023-11-20 16:43:15] [index:background] Health check [2023-11-20 16:45:36] [indexer:background] Health check [2023-11-20 16:50:45] [index:background] Health check [2023-11-20 16:50:45] [indexer:background] Health check [2023-11-20 16:50:45] [indexer:background] Health check [2023-11-20 16:54:07] [index:background] Health check [2023-11-20 16:54:36] [indexer:background] Health check [2023-11-20 16:58:15] [index:background] Health check [2023-11-20 17:00:49] [indexer:background] Health check [2023-11-20 17:04:13] [index:background] Health check [2023-11-20 17:05:09] [indexer:background] Health check [2023-11-20 17:10:49] [index:background] Health check [2023-11-20 17:10:49] [indexer:background] Health check [2023-11-20 17:10:49] [indexer:background] Health check [2023-11-20 17:14:28] [index:background] Health check [2023-11-20 17:14:37] [indexer:background] Health check [2023-11-20 17:18:13] [index:background] Health check [2023-11-20 17:19:53] [indexer:background] Health check [2023-11-20 17:23:09] [index:background] Health check [2023-11-20 17:24:51] [indexer:background] Health check [2023-11-20 17:28:04] [index:background] Health check [2023-11-20 17:29:56] [indexer:background] Health check [2023-11-20 17:34:09] [index:background] Health check [2023-11-20 17:35:10] [indexer:background] Health check [2023-11-20 17:40:20] [index:background] Health check [2023-11-20 17:40:20] [indexer:background] Health check [2023-11-20 17:40:20] [indexer:background] Health check [2023-11-20 17:44:18] [index:background] Health check [2023-11-20 17:44:57] [indexer:background] Health check [2023-11-20 17:50:32] [index:background] Health check [2023-11-20 17:50:32] [indexer:background] Health check [2023-11-20 17:50:33] [indexer:background] Health check [2023-11-20 17:53:10] [index:background] Health check [2023-11-20 17:54:44] [indexer:background] Health check [2023-11-20 17:58:53] [index:background] Health check [2023-11-20 18:02:39] [indexer:background] Health check [2023-11-20 18:04:40] [index:background] Health check [2023-11-20 18:04:40] [indexer:background] Health check [2023-11-20 18:04:40] [indexer:background] Health check [2023-11-20 18:10:19] [index:background] Health check [2023-11-20 18:10:19] [indexer:background] Health check [2023-11-20 18:10:19] [indexer:background] Health check [2023-11-20 18:13:59] [index:background] Health check [2023-11-20 18:14:37] [indexer:background] Health check [2023-11-20 18:18:04] [index:background] Health check [2023-11-20 18:19:32] [indexer:background] Health check [2023-11-20 18:24:22] [index:background] Health check [2023-11-20 18:24:36] [indexer:background] Health check [2023-11-20 18:31:26] [index:background] Health check [2023-11-20 18:31:26] [indexer:background] Health check [2023-11-20 18:31:26] [indexer:background] Health check [2023-11-20 18:33:56] [index:background] Health check [2023-11-20 18:37:08] [indexer:background] Health check [2023-11-20 18:38:21] [index:background] Health check [2023-11-20 18:40:38] [indexer:background] Health check [2023-11-20 18:43:35] [index:background] Health check [2023-11-20 18:44:47] [indexer:background] Health check [2023-11-20 18:48:53] [index:background] Health check [2023-11-20 18:51:19] [indexer:background] Health check [2023-11-20 18:53:24] [index:background] Health check [2023-11-20 18:57:06] [indexer:background] Health check [2023-11-20 18:58:43] [index:background] Health check [2023-11-20 18:59:33] [indexer:background] Health check [2023-11-20 19:04:48] [index:background] Health check [2023-11-20 19:04:48] [indexer:background] Health check [2023-11-20 19:04:48] [indexer:background] Health check [2023-11-20 19:08:49] [index:background] Health check [2023-11-20 19:12:26] [indexer:background] Health check [2023-11-20 19:14:08] [index:background] Health check [2023-11-20 19:15:40] [indexer:background] Health check [2023-11-20 19:18:22] [index:background] Health check [2023-11-20 19:20:51] [indexer:background] Health check [2023-11-20 19:23:39] [index:background] Health check [2023-11-20 19:25:04] [indexer:background] Health check [2023-11-20 19:28:53] [index:background] Health check [2023-11-20 19:30:39] [indexer:background] Health check [2023-11-20 19:34:30] [index:background] Health check [2023-11-20 19:36:14] [indexer:background] Health check [2023-11-20 19:38:55] [index:background] Health check [2023-11-20 19:40:36] [indexer:background] Health check [2023-11-20 19:40:36] [indexer:background] CPU load threshold (3) breached: 4.06 [waiting 2] [2023-11-20 19:43:27] [index:background] Health check [2023-11-20 19:44:39] [indexer:background] Health check [2023-11-20 19:49:59] [index:background] Health check [2023-11-20 19:49:59] [indexer:background] Health check [2023-11-20 19:49:59] [indexer:background] Health check [2023-11-20 19:53:47] [index:background] Health check [2023-11-20 19:54:54] [indexer:background] Health check [2023-11-20 19:59:08] [query] Query for: {search_term_string} [2023-11-20 19:59:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 62 offset: 0 fields: all [2023-11-20 19:59:08] [query] Engine: default [2023-11-20 19:59:08] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-11-20 19:59:08] [query] Mods: 6 [2023-11-20 19:59:08] [query] Using OR logic [2023-11-20 19:59:08] [index:background] Health check [2023-11-20 19:59:08] [query] Found results using: or logic [2023-11-20 19:59:08] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 610, 10 [2023-11-20 19:59:08] [query] Results: 1346 Pages of results: 135 [2023-11-20 19:59:08] [query] Execution time: 0.93551 [2023-11-20 20:01:39] [indexer:background] Health check [2023-11-20 20:03:25] [index:background] Health check [2023-11-20 20:04:35] [indexer:background] Health check [2023-11-20 20:08:58] [index:background] Health check [2023-11-20 20:10:16] [indexer:background] Health check [2023-11-20 20:13:09] [index:background] Health check [2023-11-20 20:15:35] [indexer:background] Health check [2023-11-20 20:18:31] [index:background] Health check [2023-11-20 20:19:55] [indexer:background] Health check [2023-11-20 20:24:07] [index:background] Health check [2023-11-20 20:26:52] [indexer:background] Health check [2023-11-20 20:29:29] [index:background] Health check [2023-11-20 20:29:38] [indexer:background] Health check [2023-11-20 20:34:03] [index:background] Health check [2023-11-20 20:36:38] [indexer:background] Health check [2023-11-20 20:38:36] [index:background] Health check [2023-11-20 20:42:45] [indexer:background] Health check [2023-11-20 20:43:56] [index:background] Health check [2023-11-20 20:45:38] [indexer:background] Health check [2023-11-20 20:49:18] [index:background] Health check [2023-11-20 20:50:28] [indexer:background] Health check [2023-11-20 20:53:26] [index:background] Health check [2023-11-20 20:54:48] [indexer:background] Health check [2023-11-20 20:59:08] [index:background] Health check [2023-11-20 20:59:55] [indexer:background] Health check [2023-11-20 21:04:08] [index:background] Health check [2023-11-20 21:05:36] [indexer:background] Health check [2023-11-20 21:08:26] [index:background] Health check [2023-11-20 21:09:49] [indexer:background] Health check [2023-11-20 21:13:11] [index:background] Health check [2023-11-20 21:14:44] [indexer:background] Health check [2023-11-20 21:15:56] [query] Query for: unicongo.cg/wp-content/uploads/2023/03/arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf [2023-11-20 21:15:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 21:15:56] [query] Engine: default [2023-11-20 21:15:57] [query] Tokens: projetées, programmation, projeta, projette, programmer, programmés, programmé, programmée, programmea, projetée, projeté, projete, programma, programmées, projeter, projetés, projetes, programms, programmations, reformation, reformes, reforme, reformer, reformiste, reformatrices, reformés, reforms, projets, contenté, contente, contents, contenter, contentant, enseignement, enseigner, enseignements, enseignants, enseigne, enseignant, enseignes, enseignée, enseignante, enseignées, enseignez, reformant, enseigné, enseignés, programmes, reforma, programme, unicongo, content, upload, 2023, 2013, enseign, projet, reform, programm, arretena°6069 [2023-11-20 21:15:57] [query] Mods: 6 [2023-11-20 21:15:57] [query] Using OR logic [2023-11-20 21:16:02] [query] Found results using: or logic [2023-11-20 21:16:02] [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 (164909,14909,24118,35764,41699,44312,46430,50833,54660,56423,56899,57739,69019,77883,1924,233761,234216,371717,547242,595439,1429,28194,32405,35921,420177,425178,422315,798,57512,57888,59716,62741,408393,194,6999,13465,14296,21046,34979,47686,127317,270200,394176,443174,651786,636317,800109,231,651785,629,23,9354,528679,4302,562,474548,611,422314,692647,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-11-20 21:16:02] [query] Results: 2487 Pages of results: 249 [2023-11-20 21:16:02] [query] Execution time: 5.31223 [2023-11-20 21:16:02] [query] Query for: unicongo.cg/wp-content/uploads/2023/03/arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf [2023-11-20 21:16:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-11-20 21:16:02] [query] Engine: default [2023-11-20 21:16:02] [query] Tokens: projetées, programmation, projeta, projette, programmer, programmés, programmé, programmée, programmea, projetée, projeté, projete, programma, programmées, projeter, projetés, projetes, programms, programmations, reformation, reformes, reforme, reformer, reformiste, reformatrices, reformés, reforms, projets, contenté, contente, contents, contenter, contentant, enseignement, enseigner, enseignements, enseignants, enseigne, enseignant, enseignes, enseignée, enseignante, enseignées, enseignez, reformant, enseigné, enseignés, programmes, reforma, programme, unicongo, content, upload, 2023, 2013, enseign, projet, reform, programm, arretena°6069 [2023-11-20 21:16:02] [query] Mods: 6 [2023-11-20 21:16:02] [query] Using OR logic [2023-11-20 21:16:05] [query] Found results using: or logic [2023-11-20 21:16:06] [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 (164909,14909,24118,35764,41699,44312,46430,50833,54660,56423,56899,57739,69019,77883,1924,233761,234216,371717,547242,595439,1429,28194,32405,35921,420177,425178,422315,798,57512,57888,59716,62741,408393,194,6999,13465,14296,21046,34979,47686,127317,270200,394176,443174,651786,636317,800109,231,651785,629,23,9354,528679,4302,562,474548,611,422314,692647,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, 100 [2023-11-20 21:16:06] [query] Results: 2487 Pages of results: 25 [2023-11-20 21:16:06] [query] Execution time: 3.91439 [2023-11-20 21:18:41] [index:background] Health check [2023-11-20 21:18:41] [query] Query for: unicongo.cg/wp-content/uploads/2023/03/arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf [2023-11-20 21:18:41] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all [2023-11-20 21:18:41] [query] Engine: default [2023-11-20 21:18:41] [query] Tokens: projetées, programmation, projeta, projette, programmer, programmés, programmé, programmée, programmea, projetée, projeté, projete, programma, programmées, projeter, projetés, projetes, programms, programmations, reformation, reformes, reforme, reformer, reformiste, reformatrices, reformés, reforms, projets, contenté, contente, contents, contenter, contentant, enseignement, enseigner, enseignements, enseignants, enseigne, enseignant, enseignes, enseignée, enseignante, enseignées, enseignez, reformant, enseigné, enseignés, programmes, reforma, programme, unicongo, content, upload, 2023, 2013, enseign, projet, reform, programm, arretena°6069 [2023-11-20 21:18:41] [query] Mods: 6 [2023-11-20 21:18:41] [query] Using OR logic [2023-11-20 21:18:45] [query] Found results using: or logic [2023-11-20 21:18:45] [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 (164909,14909,24118,35764,41699,44312,46430,50833,54660,56423,56899,57739,69019,77883,1924,233761,234216,371717,547242,595439,1429,28194,32405,35921,420177,425178,422315,798,57512,57888,59716,62741,408393,194,6999,13465,14296,21046,34979,47686,127317,270200,394176,443174,651786,636317,800109,231,651785,629,23,9354,528679,4302,562,474548,611,422314,692647,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 10, 10 [2023-11-20 21:18:45] [query] Results: 2487 Pages of results: 249 [2023-11-20 21:18:45] [query] Execution time: 3.78046 [2023-11-20 21:18:45] [query] Query for: unicongo.cg/wp-content/uploads/2023/03/arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf arretenâ°6069-2013_enseignement_projet-reforme-des-programmes-de-formation.pdf [2023-11-20 21:18:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 2 offset: 0 fields: all [2023-11-20 21:18:45] [query] Engine: default [2023-11-20 21:18:45] [query] Tokens: projetées, programmation, projeta, projette, programmer, programmés, programmé, programmée, programmea, projetée, projeté, projete, programma, programmées, projeter, projetés, projetes, programms, programmations, reformation, reformes, reforme, reformer, reformiste, reformatrices, reformés, reforms, projets, contenté, contente, contents, contenter, contentant, enseignement, enseigner, enseignements, enseignants, enseigne, enseignant, enseignes, enseignée, enseignante, enseignées, enseignez, reformant, enseigné, enseignés, programmes, reforma, programme, unicongo, content, upload, 2023, 2013, enseign, projet, reform, programm, arretena°6069 [2023-11-20 21:18:45] [query] Mods: 6 [2023-11-20 21:18:45] [query] Using OR logic [2023-11-20 21:18:48] [query] Found results using: or logic [2023-11-20 21:18: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 (164909,14909,24118,35764,41699,44312,46430,50833,54660,56423,56899,57739,69019,77883,1924,233761,234216,371717,547242,595439,1429,28194,32405,35921,420177,425178,422315,798,57512,57888,59716,62741,408393,194,6999,13465,14296,21046,34979,47686,127317,270200,394176,443174,651786,636317,800109,231,651785,629,23,9354,528679,4302,562,474548,611,422314,692647,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 100, 100 [2023-11-20 21:18:48] [query] Results: 2487 Pages of results: 25 [2023-11-20 21:18:48] [query] Execution time: 3.47542 [2023-11-20 21:22:21] [indexer:background] Health check [2023-11-20 21:24:01] [index:background] Health check [2023-11-20 21:25:30] [indexer:background] Health check [2023-11-20 21:29:01] [index:background] Health check [2023-11-20 21:30:24] [indexer:background] Health check [2023-11-20 21:34:28] [index:background] Health check [2023-11-20 21:35:42] [indexer:background] Health check [2023-11-20 21:38:49] [index:background] Health check [2023-11-20 21:40:17] [indexer:background] Health check [2023-11-20 21:45:44] [index:background] Health check [2023-11-20 21:45:44] [indexer:background] Health check [2023-11-20 21:45:44] [indexer:background] Health check [2023-11-20 21:49:34] [index:background] Health check [2023-11-20 21:49:34] [indexer:background] Health check [2023-11-20 21:49:34] [indexer:background] Health check [2023-11-20 21:54:04] [index:background] Health check [2023-11-20 21:54:49] [indexer:background] Health check [2023-11-20 21:58:15] [index:background] Health check [2023-11-20 21:59:38] [indexer:background] Health check [2023-11-20 22:03:08] [index:background] Health check [2023-11-20 22:06:59] [indexer:background] Health check [2023-11-20 22:10:56] [index:background] Health check [2023-11-20 22:10:56] [indexer:background] Health check [2023-11-20 22:10:56] [indexer:background] Health check [2023-11-20 22:13:32] [index:background] Health check [2023-11-20 22:14:59] [indexer:background] Health check [2023-11-20 22:18:51] [index:background] Health check [2023-11-20 22:20:22] [indexer:background] Health check [2023-11-20 22:23:03] [index:background] Health check [2023-11-20 22:24:37] [indexer:background] Health check [2023-11-20 22:31:15] [index:background] Health check [2023-11-20 22:31:15] [indexer:background] Health check [2023-11-20 22:31:15] [indexer:background] Health check [2023-11-20 22:36:39] [index:background] Health check [2023-11-20 22:36:39] [indexer:background] Health check [2023-11-20 22:36:39] [indexer:background] Health check [2023-11-20 22:38:21] [index:background] Health check [2023-11-20 22:39:57] [indexer:background] Health check [2023-11-20 22:43:06] [index:background] Health check [2023-11-20 22:44:55] [indexer:background] Health check [2023-11-20 22:48:12] [index:background] Health check [2023-11-20 22:51:15] [indexer:background] Health check [2023-11-20 22:54:38] [index:background] Health check [2023-11-20 22:54:39] [indexer:background] Health check [2023-11-20 22:54:39] [indexer:background] Health check [2023-11-20 22:56:44] [query] Query for: 2023 [2023-11-20 22:56:44] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 22:56:44] [query] Engine: default [2023-11-20 22:56:44] [query] Tokens: 2023 [2023-11-20 22:56:44] [query] Mods: 6 [2023-11-20 22:56:44] [query] Found results using: or logic [2023-11-20 22:56:44] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-11-20 22:56:44] [query] Results: 253 Pages of results: 26 [2023-11-20 22:56:44] [query] Execution time: 0.45531 [2023-11-20 22:58:35] [index:background] Health check [2023-11-20 23:00:10] [indexer:background] Health check [2023-11-20 23:04:54] [index:background] Health check [2023-11-20 23:04:54] [indexer:background] Health check [2023-11-20 23:04:54] [indexer:background] Health check [2023-11-20 23:04:54] [query] Query for: 2024 [2023-11-20 23:04:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-20 23:04:54] [query] Engine: default [2023-11-20 23:04:54] [query] Tokens: 2024 [2023-11-20 23:04:54] [query] Mods: 6 [2023-11-20 23:04:54] [query] Found results using: or logic [2023-11-20 23:04:54] [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-11-20 23:04:54] [query] Results: 130 Pages of results: 13 [2023-11-20 23:04:54] [query] Execution time: 0.03686 [2023-11-20 23:04:54] [query] Query for: 2024 [2023-11-20 23:04:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-11-20 23:04:54] [query] Engine: default [2023-11-20 23:04:54] [query] Tokens: 2024 [2023-11-20 23:04:54] [query] Mods: 6 [2023-11-20 23:04:54] [query] Found results using: or logic [2023-11-20 23:04:54] [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-11-20 23:04:54] [query] Results: 130 Pages of results: 2 [2023-11-20 23:04:54] [query] Execution time: 0.13045 [2023-11-20 23:10:03] [index:background] Health check [2023-11-20 23:10:03] [indexer:background] Health check [2023-11-20 23:10:03] [indexer:background] Health check [2023-11-20 23:13:23] [index:background] Health check [2023-11-20 23:14:47] [indexer:background] Health check [2023-11-20 23:18:49] [index:background] Health check [2023-11-20 23:19:36] [indexer:background] Health check [2023-11-20 23:23:06] [index:background] Health check [2023-11-20 23:24:36] [indexer:background] Health check [2023-11-20 23:28:09] [index:background] Health check [2023-11-20 23:30:01] [indexer:background] Health check [2023-11-20 23:33:04] [index:background] Health check [2023-11-20 23:34:44] [indexer:background] Health check [2023-11-20 23:38:29] [index:background] Health check [2023-11-20 23:42:23] [indexer:background] Health check [2023-11-20 23:43:57] [index:background] Health check [2023-11-20 23:45:30] [indexer:background] Health check [2023-11-20 23:48:04] [index:background] Health check [2023-11-20 23:50:49] [indexer:background] Health check [2023-11-20 23:53:03] [index:background] Health check [2023-11-20 23:56:37] [indexer:background] Health check