[2024-04-04 00:00:14] [index:background] Health check [2024-04-04 00:04:31] [indexer:background] Health check [2024-04-04 00:05:09] [index:background] Health check [2024-04-04 00:14:42] [indexer:background] Health check [2024-04-04 00:14:42] [index:background] Health check [2024-04-04 00:15:27] [index:background] Health check [2024-04-04 00:17:49] [indexer:background] Health check [2024-04-04 00:20:48] [index:background] Health check [2024-04-04 00:22:31] [indexer:background] Health check [2024-04-04 00:25:46] [index:background] Health check [2024-04-04 00:27:25] [indexer:background] Health check [2024-04-04 00:32:00] [index:background] Health check [2024-04-04 00:32:15] [indexer:background] Health check [2024-04-04 00:35:02] [index:background] Health check [2024-04-04 00:37:16] [indexer:background] Health check [2024-04-04 00:40:12] [index:background] Health check [2024-04-04 00:42:13] [indexer:background] Health check [2024-04-04 00:45:53] [index:background] Health check [2024-04-04 00:47:24] [indexer:background] Health check [2024-04-04 00:49:57] [index:background] Health check [2024-04-04 00:52:58] [indexer:background] Health check [2024-04-04 00:55:12] [index:background] Health check [2024-04-04 00:58:00] [indexer:background] Health check [2024-04-04 01:00:31] [index:background] Health check [2024-04-04 01:02:40] [indexer:background] Health check [2024-04-04 01:04:57] [index:background] Health check [2024-04-04 01:07:16] [indexer:background] Health check [2024-04-04 01:13:02] [index:background] Health check [2024-04-04 01:13:02] [indexer:background] Health check [2024-04-04 01:13:02] [indexer:background] Health check [2024-04-04 01:16:04] [index:background] Health check [2024-04-04 01:17:33] [indexer:background] Health check [2024-04-04 01:20:01] [index:background] Health check [2024-04-04 01:23:29] [indexer:background] Health check [2024-04-04 01:24:51] [index:background] Health check [2024-04-04 01:27:55] [indexer:background] Health check [2024-04-04 01:30:33] [index:background] Health check [2024-04-04 01:32:23] [indexer:background] Health check [2024-04-04 01:36:51] [index:background] Health check [2024-04-04 01:37:37] [indexer:background] Health check [2024-04-04 01:39:51] [index:background] Health check [2024-04-04 01:42:51] [indexer:background] Health check [2024-04-04 01:45:38] [index:background] Health check [2024-04-04 01:47:11] [indexer:background] Health check [2024-04-04 01:50:39] [index:background] Health check [2024-04-04 01:52:44] [indexer:background] Health check [2024-04-04 01:54:53] [index:background] Health check [2024-04-04 01:57:59] [indexer:background] Health check [2024-04-04 02:00:02] [index:background] Health check [2024-04-04 02:02:30] [indexer:background] Health check [2024-04-04 02:05:29] [index:background] Health check [2024-04-04 02:08:05] [indexer:background] Health check [2024-04-04 02:09:58] [index:background] Health check [2024-04-04 02:12:12] [indexer:background] Health check [2024-04-04 02:15:12] [index:background] Health check [2024-04-04 02:17:23] [indexer:background] Health check [2024-04-04 02:22:43] [index:background] Health check [2024-04-04 02:22:43] [indexer:background] Health check [2024-04-04 02:22:43] [indexer:background] Health check [2024-04-04 02:25:18] [index:background] Health check [2024-04-04 02:30:32] [indexer:background] Health check [2024-04-04 02:30:32] [index:background] Health check [2024-04-04 02:32:18] [indexer:background] Health check [2024-04-04 02:36:54] [index:background] Health check [2024-04-04 02:37:19] [indexer:background] Health check [2024-04-04 02:39:54] [index:background] Health check [2024-04-04 02:42:52] [indexer:background] Health check [2024-04-04 02:44:50] [index:background] Health check [2024-04-04 02:48:05] [indexer:background] Health check [2024-04-04 02:50:13] [index:background] Health check [2024-04-04 02:50:51] [query] Query for: 2024 [2024-04-04 02:50:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-04 02:50:51] [query] Engine: default [2024-04-04 02:50:52] [query] Tokens: 2024 [2024-04-04 02:50:52] [query] Mods: 6 [2024-04-04 02:50:52] [query] Found results using: or logic [2024-04-04 02:50:52] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-04 02:50:52] [query] Results: 149 Pages of results: 15 [2024-04-04 02:50:52] [query] Execution time: 1.17655 [2024-04-04 02:50:52] [query] Query for: 2024 [2024-04-04 02:50:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-04-04 02:50:52] [query] Engine: default [2024-04-04 02:50:52] [query] Tokens: 2024 [2024-04-04 02:50:52] [query] Mods: 6 [2024-04-04 02:50:52] [query] Found results using: or logic [2024-04-04 02:50:53] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100 [2024-04-04 02:50:53] [query] Results: 149 Pages of results: 2 [2024-04-04 02:50:53] [query] Execution time: 0.09611 [2024-04-04 02:52:46] [indexer:background] Health check [2024-04-04 02:54:52] [index:background] Health check [2024-04-04 02:58:05] [indexer:background] Health check [2024-04-04 03:00:34] [index:background] Health check [2024-04-04 03:02:18] [indexer:background] Health check [2024-04-04 03:05:22] [index:background] Health check [2024-04-04 03:07:32] [indexer:background] Health check [2024-04-04 03:12:00] [index:background] Health check [2024-04-04 03:12:25] [indexer:background] Health check [2024-04-04 03:14:59] [index:background] Health check [2024-04-04 03:18:30] [indexer:background] Health check [2024-04-04 03:21:53] [index:background] Health check [2024-04-04 03:22:13] [indexer:background] Health check [2024-04-04 03:25:54] [index:background] Health check [2024-04-04 03:27:34] [indexer:background] Health check [2024-04-04 03:30:40] [index:background] Health check [2024-04-04 03:32:42] [indexer:background] Health check [2024-04-04 03:34:52] [index:background] Health check [2024-04-04 03:37:38] [indexer:background] Health check [2024-04-04 03:39:59] [index:background] Health check [2024-04-04 03:39:59] [index:background] CPU load threshold (3) breached: 4.65 [waiting 2] [2024-04-04 03:40:01] [indexer:background] CPU load threshold (3) breached: 4.65 [waiting 2] [2024-04-04 03:42:57] [indexer:background] Health check [2024-04-04 03:45:10] [index:background] Health check [2024-04-04 03:50:04] [indexer:background] Health check [2024-04-04 03:50:04] [index:background] Health check [2024-04-04 03:52:32] [indexer:background] Health check [2024-04-04 03:55:29] [index:background] Health check [2024-04-04 03:57:55] [indexer:background] Health check [2024-04-04 04:00:21] [index:background] Health check [2024-04-04 04:02:56] [indexer:background] Health check [2024-04-04 04:05:22] [index:background] Health check [2024-04-04 04:07:15] [indexer:background] Health check [2024-04-04 04:09:53] [index:background] Health check [2024-04-04 04:10:19] [query] Query for: search_term_string [2024-04-04 04:10:19] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-04 04:10:19] [query] Engine: default [2024-04-04 04:10:19] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-04 04:10:19] [query] Mods: 6 [2024-04-04 04:10:19] [query] Using OR logic [2024-04-04 04:10:20] [query] Found results using: or logic [2024-04-04 04:10:20] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-04 04:10:20] [query] Results: 1361 Pages of results: 137 [2024-04-04 04:10:20] [query] Execution time: 1.27615 [2024-04-04 04:12:40] [indexer:background] Health check [2024-04-04 04:15:18] [index:background] Health check [2024-04-04 04:17:59] [indexer:background] Health check [2024-04-04 04:20:03] [index:background] Health check [2024-04-04 04:22:32] [indexer:background] Health check [2024-04-04 04:25:25] [index:background] Health check [2024-04-04 04:27:18] [indexer:background] Health check [2024-04-04 04:31:09] [index:background] Health check [2024-04-04 04:33:23] [indexer:background] Health check [2024-04-04 04:33:35] [query] Query for: search_term_string [2024-04-04 04:33:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-04 04:33:35] [query] Engine: default [2024-04-04 04:33:35] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-04 04:33:35] [query] Mods: 6 [2024-04-04 04:33:35] [query] Using OR logic [2024-04-04 04:33:35] [query] Found results using: or logic [2024-04-04 04:33: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 (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-04 04:33:35] [query] Results: 1361 Pages of results: 137 [2024-04-04 04:33:35] [query] Execution time: 0.04551 [2024-04-04 04:34:50] [index:background] Health check [2024-04-04 04:37:13] [indexer:background] Health check [2024-04-04 04:40:07] [index:background] Health check [2024-04-04 04:42:26] [indexer:background] Health check [2024-04-04 04:46:05] [index:background] Health check [2024-04-04 04:48:05] [indexer:background] Health check [2024-04-04 04:49:51] [index:background] Health check [2024-04-04 04:55:17] [indexer:background] Health check [2024-04-04 04:55:17] [index:background] Health check [2024-04-04 04:59:08] [indexer:background] Health check [2024-04-04 05:00:24] [index:background] Health check [2024-04-04 05:03:24] [indexer:background] Health check [2024-04-04 05:05:02] [index:background] Health check [2024-04-04 05:07:59] [indexer:background] Health check [2024-04-04 05:10:07] [index:background] Health check [2024-04-04 05:12:13] [indexer:background] Health check [2024-04-04 05:14:56] [index:background] Health check [2024-04-04 05:17:40] [indexer:background] Health check [2024-04-04 05:20:18] [index:background] Health check [2024-04-04 05:24:03] [indexer:background] Health check [2024-04-04 05:25:38] [index:background] Health check [2024-04-04 05:27:14] [indexer:background] Health check [2024-04-04 05:30:17] [index:background] Health check [2024-04-04 05:33:05] [indexer:background] Health check [2024-04-04 05:35:30] [index:background] Health check [2024-04-04 05:37:19] [indexer:background] Health check [2024-04-04 05:40:15] [index:background] Health check [2024-04-04 05:42:52] [indexer:background] Health check [2024-04-04 05:45:42] [index:background] Health check [2024-04-04 05:48:29] [indexer:background] Health check [2024-04-04 05:49:56] [index:background] Health check [2024-04-04 05:52:39] [indexer:background] Health check [2024-04-04 05:55:04] [index:background] Health check [2024-04-04 05:58:13] [indexer:background] Health check [2024-04-04 06:00:59] [index:background] Health check [2024-04-04 06:03:45] [indexer:background] Health check [2024-04-04 06:05:11] [index:background] Health check [2024-04-04 06:07:57] [indexer:background] Health check [2024-04-04 06:10:32] [index:background] Health check [2024-04-04 06:12:41] [indexer:background] Health check [2024-04-04 06:14:55] [index:background] Health check [2024-04-04 06:17:43] [indexer:background] Health check [2024-04-04 06:20:28] [index:background] Health check [2024-04-04 06:22:18] [indexer:background] Health check [2024-04-04 06:25:16] [index:background] Health check [2024-04-04 06:27:11] [indexer:background] Health check [2024-04-04 06:30:16] [index:background] Health check [2024-04-04 06:32:54] [indexer:background] Health check [2024-04-04 06:35:53] [index:background] Health check [2024-04-04 06:38:39] [indexer:background] Health check [2024-04-04 06:40:02] [index:background] Health check [2024-04-04 06:42:19] [indexer:background] Health check [2024-04-04 06:45:02] [index:background] Health check [2024-04-04 06:48:24] [indexer:background] Health check [2024-04-04 06:49:55] [index:background] Health check [2024-04-04 06:53:07] [indexer:background] Health check [2024-04-04 06:55:58] [index:background] Health check [2024-04-04 06:57:22] [indexer:background] Health check [2024-04-04 07:00:34] [index:background] Health check [2024-04-04 07:02:53] [indexer:background] Health check [2024-04-04 07:04:58] [index:background] Health check [2024-04-04 07:07:18] [indexer:background] Health check [2024-04-04 07:13:08] [index:background] Health check [2024-04-04 07:13:08] [indexer:background] Health check [2024-04-04 07:13:08] [indexer:background] Health check [2024-04-04 07:16:29] [index:background] Health check [2024-04-04 07:17:11] [indexer:background] Health check [2024-04-04 07:20:11] [index:background] Health check [2024-04-04 07:25:19] [indexer:background] Health check [2024-04-04 07:25:19] [index:background] Health check [2024-04-04 07:27:24] [indexer:background] Health check [2024-04-04 07:29:57] [index:background] Health check [2024-04-04 07:32:47] [indexer:background] Health check [2024-04-04 07:37:51] [index:background] Health check [2024-04-04 07:37:51] [indexer:background] Health check [2024-04-04 07:37:51] [indexer:background] Health check [2024-04-04 07:40:16] [index:background] Health check [2024-04-04 07:43:00] [indexer:background] Health check [2024-04-04 07:47:35] [index:background] Health check [2024-04-04 07:47:35] [indexer:background] Health check [2024-04-04 07:47:35] [indexer:background] Health check [2024-04-04 07:51:10] [index:background] Health check [2024-04-04 07:52:19] [indexer:background] Health check [2024-04-04 07:55:04] [index:background] Health check [2024-04-04 07:57:13] [indexer:background] Health check [2024-04-04 08:00:25] [index:background] Health check [2024-04-04 08:03:31] [indexer:background] Health check [2024-04-04 08:04:55] [index:background] Health check [2024-04-04 08:07:17] [indexer:background] Health check [2024-04-04 08:10:28] [index:background] Health check [2024-04-04 08:13:16] [indexer:background] Health check [2024-04-04 08:15:57] [index:background] Health check [2024-04-04 08:17:36] [indexer:background] Health check [2024-04-04 08:20:29] [index:background] Health check [2024-04-04 08:22:13] [indexer:background] Health check [2024-04-04 08:22:13] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2024-04-04 08:25:58] [index:background] Health check [2024-04-04 08:27:23] [indexer:background] Health check [2024-04-04 08:30:22] [index:background] Health check [2024-04-04 08:32:57] [indexer:background] Health check [2024-04-04 08:35:53] [index:background] Health check [2024-04-04 08:37:36] [indexer:background] Health check [2024-04-04 08:40:07] [index:background] Health check [2024-04-04 08:42:47] [indexer:background] Health check [2024-04-04 08:44:52] [index:background] Health check [2024-04-04 08:47:12] [indexer:background] Health check [2024-04-04 08:49:52] [index:background] Health check [2024-04-04 08:52:15] [indexer:background] Health check [2024-04-04 08:55:02] [index:background] Health check [2024-04-04 08:58:11] [indexer:background] Health check [2024-04-04 09:00:56] [index:background] Health check [2024-04-04 09:02:22] [indexer:background] Health check [2024-04-04 09:05:09] [index:background] Health check [2024-04-04 09:07:14] [indexer:background] Health check [2024-04-04 09:10:17] [index:background] Health check [2024-04-04 09:12:13] [indexer:background] Health check [2024-04-04 09:14:53] [index:background] Health check [2024-04-04 09:17:46] [indexer:background] Health check [2024-04-04 09:20:30] [index:background] Health check [2024-04-04 09:22:12] [indexer:background] Health check [2024-04-04 09:25:45] [index:background] Health check [2024-04-04 09:27:34] [indexer:background] Health check [2024-04-04 09:30:18] [index:background] Health check [2024-04-04 09:32:28] [indexer:background] Health check [2024-04-04 09:35:02] [index:background] Health check [2024-04-04 09:37:15] [indexer:background] Health check [2024-04-04 09:40:09] [index:background] Health check [2024-04-04 09:43:17] [indexer:background] Health check [2024-04-04 09:45:13] [index:background] Health check [2024-04-04 09:47:12] [indexer:background] Health check [2024-04-04 09:51:05] [index:background] Health check [2024-04-04 09:52:57] [indexer:background] Health check [2024-04-04 09:55:31] [index:background] Health check [2024-04-04 09:57:16] [indexer:background] Health check [2024-04-04 09:59:53] [index:background] Health check [2024-04-04 10:02:36] [indexer:background] Health check [2024-04-04 10:05:29] [index:background] Health check [2024-04-04 10:08:16] [indexer:background] Health check [2024-04-04 10:11:29] [index:background] Health check [2024-04-04 10:11:29] [index:background] Health check [2024-04-04 10:12:49] [indexer:background] Health check [2024-04-04 10:15:01] [index:background] Health check [2024-04-04 10:19:21] [indexer:background] Health check [2024-04-04 10:20:53] [index:background] Health check [2024-04-04 10:23:23] [indexer:background] Health check [2024-04-04 10:25:04] [index:background] Health check [2024-04-04 10:27:17] [indexer:background] Health check [2024-04-04 10:29:55] [index:background] Health check [2024-04-04 10:32:12] [indexer:background] Health check [2024-04-04 10:35:24] [index:background] Health check [2024-04-04 10:37:48] [indexer:background] Health check [2024-04-04 10:40:23] [index:background] Health check [2024-04-04 10:42:13] [indexer:background] Health check [2024-04-04 10:45:37] [index:background] Health check [2024-04-04 10:47:25] [indexer:background] Health check [2024-04-04 10:50:18] [index:background] Health check [2024-04-04 10:53:16] [indexer:background] Health check [2024-04-04 10:54:55] [index:background] Health check [2024-04-04 10:57:49] [indexer:background] Health check [2024-04-04 11:00:32] [index:background] Health check [2024-04-04 11:03:20] [indexer:background] Health check [2024-04-04 11:05:02] [index:background] Health check [2024-04-04 11:07:29] [indexer:background] Health check [2024-04-04 11:10:15] [index:background] Health check [2024-04-04 11:13:03] [indexer:background] Health check [2024-04-04 11:15:53] [index:background] Health check [2024-04-04 11:17:28] [indexer:background] Health check [2024-04-04 11:20:19] [index:background] Health check [2024-04-04 11:22:57] [indexer:background] Health check [2024-04-04 11:25:31] [index:background] Health check [2024-04-04 11:27:19] [indexer:background] Health check [2024-04-04 11:29:56] [index:background] Health check [2024-04-04 11:32:20] [indexer:background] Health check [2024-04-04 11:35:06] [index:background] Health check [2024-04-04 11:37:15] [indexer:background] Health check [2024-04-04 11:40:13] [index:background] Health check [2024-04-04 11:42:13] [indexer:background] Health check [2024-04-04 11:44:57] [index:background] Health check [2024-04-04 11:47:13] [indexer:background] Health check [2024-04-04 11:50:11] [index:background] Health check [2024-04-04 11:52:14] [indexer:background] Health check [2024-04-04 11:55:07] [index:background] Health check [2024-04-04 11:57:56] [indexer:background] Health check [2024-04-04 12:00:47] [index:background] Health check [2024-04-04 12:05:37] [indexer:background] Health check [2024-04-04 12:05:37] [index:background] Health check [2024-04-04 12:08:15] [indexer:background] Health check [2024-04-04 12:11:00] [index:background] Health check [2024-04-04 12:13:42] [indexer:background] Health check [2024-04-04 12:16:04] [index:background] Health check [2024-04-04 12:17:18] [indexer:background] Health check [2024-04-04 12:19:59] [index:background] Health check [2024-04-04 12:23:19] [indexer:background] Health check [2024-04-04 12:26:19] [index:background] Health check [2024-04-04 12:28:30] [indexer:background] Health check [2024-04-04 12:31:51] [index:background] Health check [2024-04-04 12:32:36] [indexer:background] Health check [2024-04-04 12:38:33] [index:background] Health check [2024-04-04 12:38:33] [indexer:background] Health check [2024-04-04 12:38:33] [indexer:background] Health check [2024-04-04 12:40:28] [index:background] Health check [2024-04-04 12:43:36] [indexer:background] Health check [2024-04-04 12:44:53] [index:background] Health check [2024-04-04 12:47:35] [indexer:background] Health check [2024-04-04 12:50:29] [index:background] Health check [2024-04-04 12:52:52] [indexer:background] Health check [2024-04-04 12:54:50] [index:background] Health check [2024-04-04 12:57:27] [indexer:background] Health check [2024-04-04 13:00:15] [index:background] Health check [2024-04-04 13:02:30] [indexer:background] Health check [2024-04-04 13:05:51] [index:background] Health check [2024-04-04 13:07:19] [indexer:background] Health check [2024-04-04 13:11:41] [index:background] Health check [2024-04-04 13:14:20] [indexer:background] Health check [2024-04-04 13:16:53] [index:background] Health check [2024-04-04 13:18:23] [indexer:background] Health check [2024-04-04 13:20:11] [index:background] Health check [2024-04-04 13:22:33] [indexer:background] Health check [2024-04-04 13:25:14] [index:background] Health check [2024-04-04 13:27:45] [indexer:background] Health check [2024-04-04 13:30:06] [index:background] Health check [2024-04-04 13:33:18] [indexer:background] Health check [2024-04-04 13:35:24] [index:background] Health check [2024-04-04 13:38:15] [indexer:background] Health check [2024-04-04 13:40:00] [index:background] Health check [2024-04-04 13:42:30] [indexer:background] Health check [2024-04-04 13:45:07] [index:background] Health check [2024-04-04 13:47:32] [indexer:background] Health check [2024-04-04 13:50:45] [index:background] Health check [2024-04-04 13:52:17] [indexer:background] Health check [2024-04-04 13:56:19] [index:background] Health check [2024-04-04 13:57:50] [indexer:background] Health check [2024-04-04 13:59:57] [index:background] Health check [2024-04-04 14:02:46] [indexer:background] Health check [2024-04-04 14:05:01] [index:background] Health check [2024-04-04 14:07:14] [indexer:background] Health check [2024-04-04 14:10:15] [index:background] Health check [2024-04-04 14:12:30] [indexer:background] Health check [2024-04-04 14:14:54] [index:background] Health check [2024-04-04 14:17:21] [indexer:background] Health check [2024-04-04 14:19:55] [index:background] Health check [2024-04-04 14:23:12] [indexer:background] Health check [2024-04-04 14:26:02] [index:background] Health check [2024-04-04 14:27:24] [indexer:background] Health check [2024-04-04 14:31:30] [index:background] Health check [2024-04-04 14:32:13] [indexer:background] Health check [2024-04-04 14:34:59] [index:background] Health check [2024-04-04 14:37:42] [indexer:background] Health check [2024-04-04 14:40:32] [index:background] Health check [2024-04-04 14:43:03] [indexer:background] Health check [2024-04-04 14:45:02] [index:background] Health check [2024-04-04 14:47:27] [indexer:background] Health check [2024-04-04 14:50:05] [index:background] Health check [2024-04-04 14:52:16] [indexer:background] Health check [2024-04-04 14:54:55] [index:background] Health check [2024-04-04 14:57:31] [indexer:background] Health check [2024-04-04 14:59:57] [index:background] Health check [2024-04-04 15:02:28] [indexer:background] Health check [2024-04-04 15:05:08] [index:background] Health check [2024-04-04 15:08:06] [indexer:background] Health check [2024-04-04 15:10:51] [index:background] Health check [2024-04-04 15:12:14] [indexer:background] Health check [2024-04-04 15:15:00] [index:background] Health check [2024-04-04 15:17:51] [indexer:background] Health check [2024-04-04 15:20:27] [index:background] Health check [2024-04-04 15:22:59] [indexer:background] Health check [2024-04-04 15:26:38] [index:background] Health check [2024-04-04 15:29:02] [indexer:background] Health check [2024-04-04 15:34:13] [index:background] Health check [2024-04-04 15:34:13] [indexer:background] Health check [2024-04-04 15:34:13] [indexer:background] Health check [2024-04-04 15:38:19] [index:background] Health check [2024-04-04 15:38:19] [indexer:background] Health check [2024-04-04 15:38:19] [indexer:background] Health check [2024-04-04 15:40:03] [index:background] Health check [2024-04-04 15:43:02] [indexer:background] Health check [2024-04-04 15:44:53] [index:background] Health check [2024-04-04 15:48:01] [indexer:background] Health check [2024-04-04 15:51:33] [index:background] Health check [2024-04-04 15:53:02] [indexer:background] Health check [2024-04-04 15:55:46] [index:background] Health check [2024-04-04 15:58:04] [indexer:background] Health check [2024-04-04 16:02:19] [index:background] Health check [2024-04-04 16:02:19] [indexer:background] Health check [2024-04-04 16:02:19] [indexer:background] Health check [2024-04-04 16:05:29] [index:background] Health check [2024-04-04 16:08:52] [indexer:background] Health check [2024-04-04 16:11:19] [index:background] Health check [2024-04-04 16:13:55] [indexer:background] Health check [2024-04-04 16:19:54] [index:background] Health check [2024-04-04 16:19:54] [indexer:background] Health check [2024-04-04 16:19:54] [indexer:background] Health check [2024-04-04 16:24:27] [indexer:background] Health check [2024-04-04 16:25:08] [index:background] Health check [2024-04-04 16:27:26] [indexer:background] Health check [2024-04-04 16:29:59] [index:background] Health check [2024-04-04 16:32:24] [indexer:background] Health check [2024-04-04 16:35:20] [index:background] Health check [2024-04-04 16:37:47] [indexer:background] Health check [2024-04-04 16:42:19] [index:background] Health check [2024-04-04 16:42:19] [indexer:background] Health check [2024-04-04 16:42:19] [indexer:background] Health check [2024-04-04 16:45:19] [index:background] Health check [2024-04-04 16:47:36] [indexer:background] Health check [2024-04-04 16:50:57] [index:background] Health check [2024-04-04 16:52:22] [indexer:background] Health check [2024-04-04 16:55:31] [index:background] Health check [2024-04-04 16:58:20] [indexer:background] Health check [2024-04-04 17:00:19] [index:background] Health check [2024-04-04 17:02:43] [indexer:background] Health check [2024-04-04 17:05:59] [index:background] Health check [2024-04-04 17:07:23] [indexer:background] Health check [2024-04-04 17:10:14] [index:background] Health check [2024-04-04 17:13:13] [indexer:background] Health check [2024-04-04 17:14:51] [index:background] Health check [2024-04-04 17:17:31] [indexer:background] Health check [2024-04-04 17:21:59] [index:background] Health check [2024-04-04 17:23:29] [indexer:background] Health check [2024-04-04 17:24:57] [index:background] Health check [2024-04-04 17:27:52] [indexer:background] Health check [2024-04-04 17:30:46] [index:background] Health check [2024-04-04 17:32:11] [indexer:background] Health check [2024-04-04 17:34:53] [index:background] Health check [2024-04-04 17:38:04] [indexer:background] Health check [2024-04-04 17:42:14] [index:background] Health check [2024-04-04 17:42:15] [indexer:background] Health check [2024-04-04 17:42:15] [indexer:background] Health check [2024-04-04 17:45:16] [index:background] Health check [2024-04-04 17:48:11] [indexer:background] Health check [2024-04-04 17:51:13] [index:background] Health check [2024-04-04 17:52:13] [indexer:background] Health check [2024-04-04 17:55:37] [index:background] Health check [2024-04-04 17:58:27] [indexer:background] Health check [2024-04-04 17:59:58] [index:background] Health check [2024-04-04 18:02:30] [indexer:background] Health check [2024-04-04 18:05:58] [index:background] Health check [2024-04-04 18:07:55] [indexer:background] Health check [2024-04-04 18:08:37] [query] Query for: search_term_string [2024-04-04 18:08:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-04 18:08:37] [query] Engine: default [2024-04-04 18:08:37] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-04 18:08:37] [query] Mods: 6 [2024-04-04 18:08:37] [query] Using OR logic [2024-04-04 18:08:38] [query] Found results using: or logic [2024-04-04 18:08:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-04 18:08:38] [query] Results: 1361 Pages of results: 137 [2024-04-04 18:08:38] [query] Execution time: 1.03015 [2024-04-04 18:10:29] [index:background] Health check [2024-04-04 18:12:42] [indexer:background] Health check [2024-04-04 18:17:31] [index:background] Health check [2024-04-04 18:17:31] [indexer:background] Health check [2024-04-04 18:17:31] [indexer:background] Health check [2024-04-04 18:19:19] [query] Query for: search_term_string [2024-04-04 18:19:19] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-04 18:19:19] [query] Engine: default [2024-04-04 18:19:19] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-04-04 18:19:19] [query] Mods: 6 [2024-04-04 18:19:19] [query] Using OR logic [2024-04-04 18:19:19] [query] Found results using: or logic [2024-04-04 18:19:19] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-04 18:19:19] [query] Results: 1361 Pages of results: 137 [2024-04-04 18:19:19] [query] Execution time: 0.05752 [2024-04-04 18:21:00] [index:background] Health check [2024-04-04 18:23:23] [indexer:background] Health check [2024-04-04 18:24:50] [index:background] Health check [2024-04-04 18:27:34] [indexer:background] Health check [2024-04-04 18:30:28] [index:background] Health check [2024-04-04 18:32:13] [indexer:background] Health check [2024-04-04 18:35:02] [index:background] Health check [2024-04-04 18:38:06] [indexer:background] Health check [2024-04-04 18:40:57] [index:background] Health check [2024-04-04 18:42:24] [indexer:background] Health check [2024-04-04 18:45:22] [index:background] Health check [2024-04-04 18:47:20] [indexer:background] Health check [2024-04-04 18:50:13] [index:background] Health check [2024-04-04 18:52:39] [indexer:background] Health check [2024-04-04 18:57:39] [index:background] Health check [2024-04-04 18:57:40] [indexer:background] Health check [2024-04-04 18:57:40] [indexer:background] Health check [2024-04-04 19:00:04] [index:background] Health check [2024-04-04 19:03:26] [indexer:background] Health check [2024-04-04 19:05:23] [index:background] Health check [2024-04-04 19:07:47] [indexer:background] Health check [2024-04-04 19:11:05] [index:background] Health check [2024-04-04 19:14:01] [indexer:background] Health check [2024-04-04 19:15:22] [index:background] Health check [2024-04-04 19:17:45] [indexer:background] Health check [2024-04-04 19:19:51] [index:background] Health check [2024-04-04 19:22:52] [indexer:background] Health check [2024-04-04 19:25:28] [index:background] Health check [2024-04-04 19:27:16] [indexer:background] Health check [2024-04-04 19:30:16] [index:background] Health check [2024-04-04 19:32:14] [indexer:background] Health check [2024-04-04 19:34:57] [index:background] Health check [2024-04-04 19:37:34] [indexer:background] Health check [2024-04-04 19:40:27] [index:background] Health check [2024-04-04 19:43:02] [indexer:background] Health check [2024-04-04 19:44:52] [index:background] Health check [2024-04-04 19:47:44] [indexer:background] Health check [2024-04-04 19:50:36] [index:background] Health check [2024-04-04 19:53:33] [indexer:background] Health check [2024-04-04 19:56:35] [index:background] Health check [2024-04-04 19:57:16] [indexer:background] Health check [2024-04-04 20:00:59] [index:background] Health check [2024-04-04 20:02:24] [indexer:background] Health check [2024-04-04 20:04:50] [index:background] Health check [2024-04-04 20:08:04] [indexer:background] Health check [2024-04-04 20:09:56] [index:background] Health check [2024-04-04 20:12:53] [indexer:background] Health check [2024-04-04 20:14:59] [index:background] Health check [2024-04-04 20:17:15] [indexer:background] Health check [2024-04-04 20:20:05] [index:background] Health check [2024-04-04 20:22:35] [indexer:background] Health check [2024-04-04 20:26:10] [index:background] Health check [2024-04-04 20:28:27] [indexer:background] Health check [2024-04-04 20:30:04] [index:background] Health check [2024-04-04 20:33:18] [indexer:background] Health check [2024-04-04 20:35:43] [index:background] Health check [2024-04-04 20:37:42] [indexer:background] Health check [2024-04-04 20:40:44] [index:background] Health check [2024-04-04 20:43:41] [indexer:background] Health check [2024-04-04 20:45:14] [index:background] Health check [2024-04-04 20:48:00] [indexer:background] Health check [2024-04-04 20:49:58] [index:background] Health check [2024-04-04 20:53:25] [indexer:background] Health check [2024-04-04 20:55:09] [index:background] Health check [2024-04-04 20:57:18] [indexer:background] Health check [2024-04-04 21:00:29] [index:background] Health check [2024-04-04 21:02:16] [indexer:background] Health check [2024-04-04 21:05:13] [index:background] Health check [2024-04-04 21:09:50] [indexer:background] Health check [2024-04-04 21:09:50] [index:background] Health check [2024-04-04 21:13:30] [indexer:background] Health check [2024-04-04 21:14:59] [index:background] Health check [2024-04-04 21:16:24] [query] Query for: 2023 [2024-04-04 21:16:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-04-04 21:16:24] [query] Engine: default [2024-04-04 21:16:24] [query] Tokens: 2023 [2024-04-04 21:16:24] [query] Mods: 6 [2024-04-04 21:16:24] [query] Found results using: or logic [2024-04-04 21:16:24] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-04-04 21:16:24] [query] Results: 272 Pages of results: 28 [2024-04-04 21:16:24] [query] Execution time: 0.46842 [2024-04-04 21:16:24] [query] Query for: 2023 [2024-04-04 21:16:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-04-04 21:16:24] [query] Engine: default [2024-04-04 21:16:24] [query] Tokens: 2023 [2024-04-04 21:16:24] [query] Mods: 6 [2024-04-04 21:16:24] [query] Found results using: or logic [2024-04-04 21:16:24] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100 [2024-04-04 21:16:24] [query] Results: 272 Pages of results: 3 [2024-04-04 21:16:24] [query] Execution time: 0.10311 [2024-04-04 21:19:13] [indexer:background] Health check [2024-04-04 21:20:15] [index:background] Health check [2024-04-04 21:23:38] [indexer:background] Health check [2024-04-04 21:24:59] [index:background] Health check [2024-04-04 21:29:27] [indexer:background] Health check [2024-04-04 21:30:08] [index:background] Health check [2024-04-04 21:34:16] [indexer:background] Health check [2024-04-04 21:34:57] [index:background] Health check [2024-04-04 21:37:13] [indexer:background] Health check [2024-04-04 21:39:57] [index:background] Health check [2024-04-04 21:42:15] [indexer:background] Health check [2024-04-04 21:45:42] [index:background] Health check [2024-04-04 21:47:25] [indexer:background] Health check [2024-04-04 21:50:01] [index:background] Health check [2024-04-04 21:52:22] [indexer:background] Health check [2024-04-04 21:55:10] [index:background] Health check [2024-04-04 21:57:20] [indexer:background] Health check [2024-04-04 22:02:12] [index:background] Health check [2024-04-04 22:02:12] [indexer:background] Health check [2024-04-04 22:02:12] [indexer:background] Health check [2024-04-04 22:05:27] [index:background] Health check [2024-04-04 22:07:17] [indexer:background] Health check [2024-04-04 22:12:29] [index:background] Health check [2024-04-04 22:12:29] [indexer:background] Health check [2024-04-04 22:12:29] [indexer:background] Health check [2024-04-04 22:15:46] [index:background] Health check [2024-04-04 22:17:51] [indexer:background] Health check [2024-04-04 22:19:50] [index:background] Health check [2024-04-04 22:22:34] [indexer:background] Health check [2024-04-04 22:25:12] [index:background] Health check [2024-04-04 22:27:30] [indexer:background] Health check [2024-04-04 22:30:36] [index:background] Health check [2024-04-04 22:32:33] [indexer:background] Health check [2024-04-04 22:35:29] [index:background] Health check [2024-04-04 22:38:24] [indexer:background] Health check [2024-04-04 22:39:52] [index:background] Health check [2024-04-04 22:42:43] [indexer:background] Health check [2024-04-04 22:44:57] [index:background] Health check [2024-04-04 22:47:51] [indexer:background] Health check [2024-04-04 22:50:44] [index:background] Health check [2024-04-04 22:52:20] [indexer:background] Health check [2024-04-04 22:55:11] [index:background] Health check [2024-04-04 22:57:57] [indexer:background] Health check [2024-04-04 23:00:33] [index:background] Health check [2024-04-04 23:02:35] [indexer:background] Health check [2024-04-04 23:05:24] [index:background] Health check [2024-04-04 23:08:28] [indexer:background] Health check [2024-04-04 23:09:53] [index:background] Health check [2024-04-04 23:12:22] [indexer:background] Health check [2024-04-04 23:15:48] [index:background] Health check [2024-04-04 23:17:15] [indexer:background] Health check [2024-04-04 23:20:06] [index:background] Health check [2024-04-04 23:22:54] [indexer:background] Health check [2024-04-04 23:26:00] [index:background] Health check [2024-04-04 23:27:44] [indexer:background] Health check [2024-04-04 23:30:09] [index:background] Health check [2024-04-04 23:33:19] [indexer:background] Health check [2024-04-04 23:37:51] [index:background] Health check [2024-04-04 23:37:51] [indexer:background] Health check [2024-04-04 23:37:51] [indexer:background] Health check [2024-04-04 23:40:45] [index:background] Health check [2024-04-04 23:42:31] [indexer:background] Health check [2024-04-04 23:45:36] [index:background] Health check [2024-04-04 23:48:05] [indexer:background] Health check [2024-04-04 23:50:00] [index:background] Health check [2024-04-04 23:52:36] [indexer:background] Health check [2024-04-04 23:55:05] [index:background] Health check [2024-04-04 23:58:44] [indexer:background] Health check