[2023-11-05 00:03:04] [index:background] Health check
[2023-11-05 00:04:41] [indexer:background] Health check
[2023-11-05 00:08:06] [index:background] Health check
[2023-11-05 00:09:34] [indexer:background] Health check
[2023-11-05 00:13:08] [index:background] Health check
[2023-11-05 00:14:35] [indexer:background] Health check
[2023-11-05 00:18:56] [index:background] Health check
[2023-11-05 00:19:33] [indexer:background] Health check
[2023-11-05 00:23:18] [index:background] Health check
[2023-11-05 00:25:15] [indexer:background] Health check
[2023-11-05 00:28:45] [index:background] Health check
[2023-11-05 00:29:50] [indexer:background] Health check
[2023-11-05 00:35:38] [index:background] Health check
[2023-11-05 00:35:38] [indexer:background] Health check
[2023-11-05 00:35:38] [indexer:background] Health check
[2023-11-05 00:38:16] [index:background] Health check
[2023-11-05 00:39:46] [indexer:background] Health check
[2023-11-05 00:43:46] [index:background] Health check
[2023-11-05 00:45:10] [indexer:background] Health check
[2023-11-05 00:48:45] [index:background] Health check
[2023-11-05 00:50:16] [indexer:background] Health check
[2023-11-05 00:53:41] [index:background] Health check
[2023-11-05 00:54:40] [indexer:background] Health check
[2023-11-05 00:58:13] [index:background] Health check
[2023-11-05 01:01:39] [indexer:background] Health check
[2023-11-05 01:03:06] [index:background] Health check
[2023-11-05 01:05:44] [indexer:background] Health check
[2023-11-05 01:10:26] [index:background] Health check
[2023-11-05 01:10:26] [indexer:background] Health check
[2023-11-05 01:10:26] [indexer:background] Health check
[2023-11-05 01:15:58] [index:background] Health check
[2023-11-05 01:15:58] [indexer:background] Health check
[2023-11-05 01:15:58] [indexer:background] Health check
[2023-11-05 01:18:26] [index:background] Health check
[2023-11-05 01:20:55] [indexer:background] Health check
[2023-11-05 01:23:25] [index:background] Health check
[2023-11-05 01:24:59] [indexer:background] Health check
[2023-11-05 01:28:17] [index:background] Health check
[2023-11-05 01:29:41] [indexer:background] Health check
[2023-11-05 01:33:53] [index:background] Health check
[2023-11-05 01:34:42] [indexer:background] Health check
[2023-11-05 01:39:44] [index:background] Health check
[2023-11-05 01:39:44] [indexer:background] Health check
[2023-11-05 01:39:44] [indexer:background] Health check
[2023-11-05 01:43:23] [index:background] Health check
[2023-11-05 01:44:43] [indexer:background] Health check
[2023-11-05 01:48:30] [index:background] Health check
[2023-11-05 01:50:03] [indexer:background] Health check
[2023-11-05 01:55:11] [index:background] Health check
[2023-11-05 01:55:11] [indexer:background] Health check
[2023-11-05 01:55:11] [indexer:background] Health check
[2023-11-05 01:58:38] [index:background] Health check
[2023-11-05 02:00:50] [indexer:background] Health check
[2023-11-05 02:00:50] [query] Query for: 2023
[2023-11-05 02:00:50] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 02:00:50] [query] Engine: default
[2023-11-05 02:00:51] [query] Tokens: 2023
[2023-11-05 02:00:51] [query] Mods: 6
[2023-11-05 02:00:51] [query] Found results using: or logic
[2023-11-05 02:00:51] [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-05 02:00:51] [query] Results: 252 Pages of results: 26
[2023-11-05 02:00:51] [query] Execution time: 0.46679
[2023-11-05 02:00:51] [query] Query for: 2023
[2023-11-05 02:00:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-05 02:00:51] [query] Engine: default
[2023-11-05 02:00:51] [query] Tokens: 2023
[2023-11-05 02:00:51] [query] Mods: 6
[2023-11-05 02:00:51] [query] Found results using: or logic
[2023-11-05 02:00:51] [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-05 02:00:51] [query] Results: 252 Pages of results: 3
[2023-11-05 02:00:51] [query] Execution time: 0.10771
[2023-11-05 02:03:03] [index:background] Health check
[2023-11-05 02:05:47] [indexer:background] Health check
[2023-11-05 02:08:26] [index:background] Health check
[2023-11-05 02:11:34] [indexer:background] Health check
[2023-11-05 02:14:03] [index:background] Health check
[2023-11-05 02:15:01] [indexer:background] Health check
[2023-11-05 02:18:03] [index:background] Health check
[2023-11-05 02:21:21] [indexer:background] Health check
[2023-11-05 02:23:21] [index:background] Health check
[2023-11-05 02:25:22] [indexer:background] Health check
[2023-11-05 02:28:29] [index:background] Health check
[2023-11-05 02:32:32] [indexer:background] Health check
[2023-11-05 02:33:05] [index:background] Health check
[2023-11-05 02:34:53] [indexer:background] Health check
[2023-11-05 02:39:06] [index:background] Health check
[2023-11-05 02:41:11] [indexer:background] Health check
[2023-11-05 02:44:59] [index:background] Health check
[2023-11-05 02:44:59] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-11-05 02:45:01] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2023-11-05 02:45:03] [indexer:background] Health check
[2023-11-05 02:45:03] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2]
[2023-11-05 02:45:05] [indexer:background] Health check
[2023-11-05 02:45:05] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2]
[2023-11-05 02:48:05] [index:background] Health check
[2023-11-05 02:48:05] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2023-11-05 02:48:08] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2023-11-05 02:49:53] [indexer:background] Health check
[2023-11-05 02:54:11] [index:background] Health check
[2023-11-05 02:54:36] [indexer:background] Health check
[2023-11-05 02:58:03] [index:background] Health check
[2023-11-05 02:58:03] [index:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-11-05 02:58:05] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2023-11-05 02:59:55] [indexer:background] Health check
[2023-11-05 02:59:55] [indexer:background] CPU load threshold (3) breached: 3.15 [waiting 2]
[2023-11-05 03:03:46] [index:background] Health check
[2023-11-05 03:04:47] [indexer:background] Health check
[2023-11-05 03:08:19] [index:background] Health check
[2023-11-05 03:08:19] [index:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2023-11-05 03:08:22] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2023-11-05 03:10:06] [indexer:background] Health check
[2023-11-05 03:10:06] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2023-11-05 03:13:25] [index:background] Health check
[2023-11-05 03:14:46] [indexer:background] Health check
[2023-11-05 03:18:03] [index:background] Health check
[2023-11-05 03:19:33] [indexer:background] Health check
[2023-11-05 03:19:33] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2]
[2023-11-05 03:23:05] [index:background] Health check
[2023-11-05 03:24:39] [indexer:background] Health check
[2023-11-05 03:24:39] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2023-11-05 03:29:14] [index:background] Health check
[2023-11-05 03:29:14] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-05 03:29:16] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2023-11-05 03:30:19] [indexer:background] Health check
[2023-11-05 03:32:52] [query] Query for: {search_term_string}
[2023-11-05 03:32:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 03:32:52] [query] Engine: default
[2023-11-05 03:32:52] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 03:32:52] [query] Mods: 6
[2023-11-05 03:32:52] [query] Using OR logic
[2023-11-05 03:32:53] [query] Found results using: or logic
[2023-11-05 03:32: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 (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-05 03:32:53] [query] Results: 1346 Pages of results: 135
[2023-11-05 03:32:53] [query] Execution time: 1.18980
[2023-11-05 03:33:41] [index:background] Health check
[2023-11-05 03:34:56] [indexer:background] Health check
[2023-11-05 03:39:36] [index:background] Health check
[2023-11-05 03:39:36] [indexer:background] Health check
[2023-11-05 03:39:36] [indexer:background] Health check
[2023-11-05 03:43:42] [index:background] Health check
[2023-11-05 03:46:37] [indexer:background] Health check
[2023-11-05 03:48:03] [index:background] Health check
[2023-11-05 03:51:54] [indexer:background] Health check
[2023-11-05 03:53:29] [index:background] Health check
[2023-11-05 03:54:37] [indexer:background] Health check
[2023-11-05 03:58:32] [index:background] Health check
[2023-11-05 04:02:01] [indexer:background] Health check
[2023-11-05 04:03:47] [index:background] Health check
[2023-11-05 04:05:23] [indexer:background] Health check
[2023-11-05 04:08:03] [query] Query for: {search_term_string}
[2023-11-05 04:08:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 04:08:03] [query] Engine: default
[2023-11-05 04:08:03] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 04:08:03] [query] Mods: 6
[2023-11-05 04:08:03] [query] Using OR logic
[2023-11-05 04:08:03] [query] Found results using: or logic
[2023-11-05 04:08:03] [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-05 04:08:03] [query] Results: 1346 Pages of results: 135
[2023-11-05 04:08:03] [query] Execution time: 0.04178
[2023-11-05 04:08:03] [index:background] Health check
[2023-11-05 04:11:48] [indexer:background] Health check
[2023-11-05 04:13:09] [index:background] Health check
[2023-11-05 04:17:09] [indexer:background] Health check
[2023-11-05 04:18:14] [index:background] Health check
[2023-11-05 04:20:21] [indexer:background] Health check
[2023-11-05 04:24:11] [index:background] Health check
[2023-11-05 04:24:33] [indexer:background] Health check
[2023-11-05 04:29:16] [index:background] Health check
[2023-11-05 04:30:47] [indexer:background] Health check
[2023-11-05 04:33:23] [index:background] Health check
[2023-11-05 04:34:57] [indexer:background] Health check
[2023-11-05 04:38:22] [index:background] Health check
[2023-11-05 04:41:14] [indexer:background] Health check
[2023-11-05 04:45:42] [index:background] Health check
[2023-11-05 04:45:42] [indexer:background] Health check
[2023-11-05 04:45:42] [indexer:background] Health check
[2023-11-05 04:48:02] [index:background] Health check
[2023-11-05 04:49:35] [indexer:background] Health check
[2023-11-05 04:54:08] [index:background] Health check
[2023-11-05 04:55:19] [indexer:background] Health check
[2023-11-05 04:58:04] [index:background] Health check
[2023-11-05 04:59:37] [indexer:background] Health check
[2023-11-05 05:06:10] [index:background] Health check
[2023-11-05 05:06:10] [indexer:background] Health check
[2023-11-05 05:06:10] [indexer:background] Health check
[2023-11-05 05:08:14] [index:background] Health check
[2023-11-05 05:09:42] [indexer:background] Health check
[2023-11-05 05:13:15] [index:background] Health check
[2023-11-05 05:15:41] [indexer:background] Health check
[2023-11-05 05:18:27] [index:background] Health check
[2023-11-05 05:19:38] [indexer:background] Health check
[2023-11-05 05:23:04] [index:background] Health check
[2023-11-05 05:24:43] [indexer:background] Health check
[2023-11-05 05:28:06] [index:background] Health check
[2023-11-05 05:30:19] [indexer:background] Health check
[2023-11-05 05:33:34] [index:background] Health check
[2023-11-05 05:34:33] [indexer:background] Health check
[2023-11-05 05:38:07] [index:background] Health check
[2023-11-05 05:39:33] [indexer:background] Health check
[2023-11-05 05:43:04] [index:background] Health check
[2023-11-05 05:44:35] [indexer:background] Health check
[2023-11-05 05:48:04] [index:background] Health check
[2023-11-05 05:49:34] [indexer:background] Health check
[2023-11-05 05:53:04] [index:background] Health check
[2023-11-05 05:54:34] [indexer:background] Health check
[2023-11-05 05:58:03] [index:background] Health check
[2023-11-05 05:59:35] [indexer:background] Health check
[2023-11-05 06:03:36] [index:background] Health check
[2023-11-05 06:04:50] [indexer:background] Health check
[2023-11-05 06:09:24] [index:background] Health check
[2023-11-05 06:10:02] [indexer:background] Health check
[2023-11-05 06:13:02] [index:background] Health check
[2023-11-05 06:14:45] [indexer:background] Health check
[2023-11-05 06:18:03] [index:background] Health check
[2023-11-05 06:20:12] [indexer:background] Health check
[2023-11-05 06:23:05] [index:background] Health check
[2023-11-05 06:25:40] [indexer:background] Health check
[2023-11-05 06:28:07] [index:background] Health check
[2023-11-05 06:30:02] [indexer:background] Health check
[2023-11-05 06:33:16] [index:background] Health check
[2023-11-05 06:34:38] [indexer:background] Health check
[2023-11-05 06:38:14] [index:background] Health check
[2023-11-05 06:40:05] [indexer:background] Health check
[2023-11-05 06:43:19] [index:background] Health check
[2023-11-05 06:45:21] [indexer:background] Health check
[2023-11-05 06:49:59] [index:background] Health check
[2023-11-05 06:49:59] [indexer:background] Health check
[2023-11-05 06:49:59] [indexer:background] Health check
[2023-11-05 06:53:04] [index:background] Health check
[2023-11-05 06:55:40] [indexer:background] Health check
[2023-11-05 06:58:22] [index:background] Health check
[2023-11-05 07:00:36] [indexer:background] Health check
[2023-11-05 07:03:35] [index:background] Health check
[2023-11-05 07:05:01] [indexer:background] Health check
[2023-11-05 07:08:03] [index:background] Health check
[2023-11-05 07:09:36] [indexer:background] Health check
[2023-11-05 07:13:04] [index:background] Health check
[2023-11-05 07:14:35] [indexer:background] Health check
[2023-11-05 07:18:11] [index:background] Health check
[2023-11-05 07:21:02] [indexer:background] Health check
[2023-11-05 07:23:07] [index:background] Health check
[2023-11-05 07:24:38] [indexer:background] Health check
[2023-11-05 07:28:04] [index:background] Health check
[2023-11-05 07:29:38] [indexer:background] Health check
[2023-11-05 07:33:08] [index:background] Health check
[2023-11-05 07:34:40] [indexer:background] Health check
[2023-11-05 07:38:04] [index:background] Health check
[2023-11-05 07:39:34] [indexer:background] Health check
[2023-11-05 07:43:21] [index:background] Health check
[2023-11-05 07:44:39] [indexer:background] Health check
[2023-11-05 07:48:07] [index:background] Health check
[2023-11-05 07:49:37] [indexer:background] Health check
[2023-11-05 07:53:04] [index:background] Health check
[2023-11-05 07:54:37] [indexer:background] Health check
[2023-11-05 07:58:07] [index:background] Health check
[2023-11-05 07:59:33] [indexer:background] Health check
[2023-11-05 08:03:06] [index:background] Health check
[2023-11-05 08:04:33] [indexer:background] Health check
[2023-11-05 08:08:03] [index:background] Health check
[2023-11-05 08:09:33] [indexer:background] Health check
[2023-11-05 08:13:02] [index:background] Health check
[2023-11-05 08:14:52] [indexer:background] Health check
[2023-11-05 08:18:31] [index:background] Health check
[2023-11-05 08:20:04] [indexer:background] Health check
[2023-11-05 08:23:08] [index:background] Health check
[2023-11-05 08:25:41] [indexer:background] Health check
[2023-11-05 08:28:20] [index:background] Health check
[2023-11-05 08:30:04] [indexer:background] Health check
[2023-11-05 08:33:03] [index:background] Health check
[2023-11-05 08:35:13] [indexer:background] Health check
[2023-11-05 08:39:14] [index:background] Health check
[2023-11-05 08:39:49] [indexer:background] Health check
[2023-11-05 08:43:18] [index:background] Health check
[2023-11-05 08:44:53] [indexer:background] Health check
[2023-11-05 08:49:14] [index:background] Health check
[2023-11-05 08:50:31] [indexer:background] Health check
[2023-11-05 08:53:16] [index:background] Health check
[2023-11-05 08:54:42] [indexer:background] Health check
[2023-11-05 08:58:54] [index:background] Health check
[2023-11-05 08:59:44] [indexer:background] Health check
[2023-11-05 09:03:39] [index:background] Health check
[2023-11-05 09:04:37] [indexer:background] Health check
[2023-11-05 09:08:36] [index:background] Health check
[2023-11-05 09:09:45] [indexer:background] Health check
[2023-11-05 09:14:14] [index:background] Health check
[2023-11-05 09:14:38] [indexer:background] Health check
[2023-11-05 09:19:15] [index:background] Health check
[2023-11-05 09:21:25] [indexer:background] Health check
[2023-11-05 09:26:42] [index:background] Health check
[2023-11-05 09:26:42] [indexer:background] Health check
[2023-11-05 09:26:43] [indexer:background] Health check
[2023-11-05 09:29:28] [index:background] Health check
[2023-11-05 09:29:35] [indexer:background] Health check
[2023-11-05 09:34:06] [index:background] Health check
[2023-11-05 09:34:42] [indexer:background] Health check
[2023-11-05 09:41:07] [index:background] Health check
[2023-11-05 09:41:07] [indexer:background] Health check
[2023-11-05 09:41:07] [indexer:background] Health check
[2023-11-05 09:43:02] [index:background] Health check
[2023-11-05 09:45:33] [indexer:background] Health check
[2023-11-05 09:48:18] [index:background] Health check
[2023-11-05 09:49:55] [indexer:background] Health check
[2023-11-05 09:53:04] [index:background] Health check
[2023-11-05 09:54:11] [query] Query for: search_term_string
[2023-11-05 09:54:11] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 09:54:11] [query] Engine: default
[2023-11-05 09:54:11] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 09:54:11] [query] Mods: 6
[2023-11-05 09:54:11] [query] Using OR logic
[2023-11-05 09:54:11] [query] Found results using: or logic
[2023-11-05 09:54:11] [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-05 09:54:11] [query] Results: 1346 Pages of results: 135
[2023-11-05 09:54:11] [query] Execution time: 0.04774
[2023-11-05 09:55:17] [indexer:background] Health check
[2023-11-05 09:58:33] [index:background] Health check
[2023-11-05 10:02:15] [indexer:background] Health check
[2023-11-05 10:03:04] [index:background] Health check
[2023-11-05 10:05:38] [indexer:background] Health check
[2023-11-05 10:08:20] [index:background] Health check
[2023-11-05 10:09:33] [indexer:background] Health check
[2023-11-05 10:13:03] [index:background] Health check
[2023-11-05 10:13:03] [index:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-11-05 10:13:05] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2023-11-05 10:14:35] [indexer:background] Health check
[2023-11-05 10:14:35] [indexer:background] CPU load threshold (3) breached: 3.47 [waiting 2]
[2023-11-05 10:18:03] [index:background] Health check
[2023-11-05 10:19:34] [indexer:background] Health check
[2023-11-05 10:23:03] [index:background] Health check
[2023-11-05 10:24:30] [query] Query for: 2023
[2023-11-05 10:24:30] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 10:24:30] [query] Engine: default
[2023-11-05 10:24:30] [query] Tokens: 2023
[2023-11-05 10:24:30] [query] Mods: 6
[2023-11-05 10:24:30] [query] Found results using: or logic
[2023-11-05 10:24:30] [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-05 10:24:30] [query] Results: 252 Pages of results: 26
[2023-11-05 10:24:30] [query] Execution time: 0.04887
[2023-11-05 10:24:34] [indexer:background] Health check
[2023-11-05 10:24:34] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2023-11-05 10:28:05] [index:background] Health check
[2023-11-05 10:29:05] [query] Query for: search_term_string
[2023-11-05 10:29:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 10:29:05] [query] Engine: default
[2023-11-05 10:29:05] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 10:29:05] [query] Mods: 6
[2023-11-05 10:29:05] [query] Using OR logic
[2023-11-05 10:29:05] [query] Found results using: or logic
[2023-11-05 10:29:05] [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-05 10:29:05] [query] Results: 1346 Pages of results: 135
[2023-11-05 10:29:05] [query] Execution time: 0.05996
[2023-11-05 10:29:34] [indexer:background] Health check
[2023-11-05 10:33:04] [index:background] Health check
[2023-11-05 10:34:33] [indexer:background] Health check
[2023-11-05 10:38:04] [index:background] Health check
[2023-11-05 10:39:33] [indexer:background] Health check
[2023-11-05 10:43:03] [index:background] Health check
[2023-11-05 10:44:34] [indexer:background] Health check
[2023-11-05 10:48:05] [index:background] Health check
[2023-11-05 10:49:34] [indexer:background] Health check
[2023-11-05 10:53:03] [index:background] Health check
[2023-11-05 10:54:34] [indexer:background] Health check
[2023-11-05 10:58:05] [index:background] Health check
[2023-11-05 10:59:33] [indexer:background] Health check
[2023-11-05 11:03:34] [index:background] Health check
[2023-11-05 11:04:35] [indexer:background] Health check
[2023-11-05 11:08:50] [index:background] Health check
[2023-11-05 11:10:09] [indexer:background] Health check
[2023-11-05 11:13:27] [index:background] Health check
[2023-11-05 11:15:52] [indexer:background] Health check
[2023-11-05 11:18:39] [index:background] Health check
[2023-11-05 11:21:35] [indexer:background] Health check
[2023-11-05 11:23:44] [index:background] Health check
[2023-11-05 11:25:54] [indexer:background] Health check
[2023-11-05 11:28:12] [index:background] Health check
[2023-11-05 11:30:46] [indexer:background] Health check
[2023-11-05 11:34:06] [index:background] Health check
[2023-11-05 11:34:44] [indexer:background] Health check
[2023-11-05 11:38:02] [index:background] Health check
[2023-11-05 11:39:53] [indexer:background] Health check
[2023-11-05 11:43:53] [index:background] Health check
[2023-11-05 11:44:33] [indexer:background] Health check
[2023-11-05 11:48:03] [index:background] Health check
[2023-11-05 11:50:47] [indexer:background] Health check
[2023-11-05 11:53:05] [index:background] Health check
[2023-11-05 11:55:03] [indexer:background] Health check
[2023-11-05 11:59:03] [index:background] Health check
[2023-11-05 11:59:34] [indexer:background] Health check
[2023-11-05 12:03:28] [index:background] Health check
[2023-11-05 12:04:51] [indexer:background] Health check
[2023-11-05 12:08:56] [index:background] Health check
[2023-11-05 12:10:35] [indexer:background] Health check
[2023-11-05 12:13:10] [index:background] Health check
[2023-11-05 12:15:55] [indexer:background] Health check
[2023-11-05 12:18:41] [index:background] Health check
[2023-11-05 12:20:04] [indexer:background] Health check
[2023-11-05 12:24:29] [index:background] Health check
[2023-11-05 12:25:34] [indexer:background] Health check
[2023-11-05 12:30:48] [index:background] Health check
[2023-11-05 12:30:48] [indexer:background] Health check
[2023-11-05 12:30:48] [indexer:background] Health check
[2023-11-05 12:33:13] [index:background] Health check
[2023-11-05 12:35:56] [indexer:background] Health check
[2023-11-05 12:38:08] [index:background] Health check
[2023-11-05 12:39:37] [indexer:background] Health check
[2023-11-05 12:43:20] [index:background] Health check
[2023-11-05 12:45:16] [indexer:background] Health check
[2023-11-05 12:48:53] [index:background] Health check
[2023-11-05 12:53:05] [indexer:background] Health check
[2023-11-05 12:53:05] [index:background] Health check
[2023-11-05 12:56:16] [indexer:background] Health check
[2023-11-05 12:58:11] [index:background] Health check
[2023-11-05 12:59:33] [indexer:background] Health check
[2023-11-05 13:03:03] [index:background] Health check
[2023-11-05 13:05:41] [indexer:background] Health check
[2023-11-05 13:09:53] [index:background] Health check
[2023-11-05 13:09:53] [indexer:background] Health check
[2023-11-05 13:09:53] [indexer:background] Health check
[2023-11-05 13:14:05] [index:background] Health check
[2023-11-05 13:15:27] [indexer:background] Health check
[2023-11-05 13:18:59] [index:background] Health check
[2023-11-05 13:19:37] [indexer:background] Health check
[2023-11-05 13:24:19] [index:background] Health check
[2023-11-05 13:24:59] [indexer:background] Health check
[2023-11-05 13:30:28] [index:background] Health check
[2023-11-05 13:30:28] [indexer:background] Health check
[2023-11-05 13:30:28] [indexer:background] Health check
[2023-11-05 13:34:17] [index:background] Health check
[2023-11-05 13:35:42] [indexer:background] Health check
[2023-11-05 13:38:07] [index:background] Health check
[2023-11-05 13:39:36] [indexer:background] Health check
[2023-11-05 13:43:10] [index:background] Health check
[2023-11-05 13:44:35] [indexer:background] Health check
[2023-11-05 13:48:05] [index:background] Health check
[2023-11-05 13:49:39] [indexer:background] Health check
[2023-11-05 13:54:22] [index:background] Health check
[2023-11-05 13:55:05] [indexer:background] Health check
[2023-11-05 13:58:19] [index:background] Health check
[2023-11-05 14:00:32] [indexer:background] Health check
[2023-11-05 14:03:51] [index:background] Health check
[2023-11-05 14:06:02] [indexer:background] Health check
[2023-11-05 14:10:31] [index:background] Health check
[2023-11-05 14:10:31] [indexer:background] Health check
[2023-11-05 14:10:31] [indexer:background] Health check
[2023-11-05 14:13:05] [index:background] Health check
[2023-11-05 14:15:35] [indexer:background] Health check
[2023-11-05 14:20:30] [index:background] Health check
[2023-11-05 14:20:30] [indexer:background] Health check
[2023-11-05 14:20:30] [indexer:background] Health check
[2023-11-05 14:24:42] [index:background] Health check
[2023-11-05 14:24:42] [indexer:background] Health check
[2023-11-05 14:24:42] [indexer:background] Health check
[2023-11-05 14:28:27] [index:background] Health check
[2023-11-05 14:29:52] [indexer:background] Health check
[2023-11-05 14:33:13] [index:background] Health check
[2023-11-05 14:35:11] [indexer:background] Health check
[2023-11-05 14:38:06] [index:background] Health check
[2023-11-05 14:39:34] [indexer:background] Health check
[2023-11-05 14:41:34] [query] Query for: 2024
[2023-11-05 14:41:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 14:41:34] [query] Engine: default
[2023-11-05 14:41:35] [query] Tokens: 2024
[2023-11-05 14:41:35] [query] Mods: 6
[2023-11-05 14:41:35] [query] Found results using: or logic
[2023-11-05 14:41: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-05 14:41:35] [query] Results: 130 Pages of results: 13
[2023-11-05 14:41:35] [query] Execution time: 0.48146
[2023-11-05 14:41:35] [query] Query for: 2024
[2023-11-05 14:41:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2023-11-05 14:41:35] [query] Engine: default
[2023-11-05 14:41:35] [query] Tokens: 2024
[2023-11-05 14:41:35] [query] Mods: 6
[2023-11-05 14:41:35] [query] Found results using: or logic
[2023-11-05 14:41: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-05 14:41:35] [query] Results: 130 Pages of results: 2
[2023-11-05 14:41:35] [query] Execution time: 0.08884
[2023-11-05 14:43:06] [index:background] Health check
[2023-11-05 14:44:39] [indexer:background] Health check
[2023-11-05 14:48:05] [index:background] Health check
[2023-11-05 14:49:35] [indexer:background] Health check
[2023-11-05 14:53:10] [index:background] Health check
[2023-11-05 14:54:36] [indexer:background] Health check
[2023-11-05 14:58:05] [index:background] Health check
[2023-11-05 14:59:34] [indexer:background] Health check
[2023-11-05 15:03:06] [index:background] Health check
[2023-11-05 15:04:36] [indexer:background] Health check
[2023-11-05 15:08:10] [index:background] Health check
[2023-11-05 15:09:35] [indexer:background] Health check
[2023-11-05 15:13:08] [index:background] Health check
[2023-11-05 15:14:38] [indexer:background] Health check
[2023-11-05 15:18:04] [index:background] Health check
[2023-11-05 15:19:36] [indexer:background] Health check
[2023-11-05 15:23:10] [index:background] Health check
[2023-11-05 15:24:47] [indexer:background] Health check
[2023-11-05 15:28:14] [index:background] Health check
[2023-11-05 15:29:57] [indexer:background] Health check
[2023-11-05 15:33:38] [index:background] Health check
[2023-11-05 15:34:34] [indexer:background] Health check
[2023-11-05 15:38:46] [index:background] Health check
[2023-11-05 15:39:50] [indexer:background] Health check
[2023-11-05 15:44:12] [index:background] Health check
[2023-11-05 15:45:27] [indexer:background] Health check
[2023-11-05 15:48:07] [index:background] Health check
[2023-11-05 15:50:50] [indexer:background] Health check
[2023-11-05 15:53:59] [index:background] Health check
[2023-11-05 15:55:13] [indexer:background] Health check
[2023-11-05 15:58:06] [index:background] Health check
[2023-11-05 15:59:51] [indexer:background] Health check
[2023-11-05 16:03:13] [index:background] Health check
[2023-11-05 16:04:45] [indexer:background] Health check
[2023-11-05 16:08:04] [index:background] Health check
[2023-11-05 16:09:53] [indexer:background] Health check
[2023-11-05 16:13:28] [index:background] Health check
[2023-11-05 16:15:20] [indexer:background] Health check
[2023-11-05 16:18:23] [index:background] Health check
[2023-11-05 16:19:48] [indexer:background] Health check
[2023-11-05 16:23:05] [index:background] Health check
[2023-11-05 16:25:37] [indexer:background] Health check
[2023-11-05 16:28:34] [index:background] Health check
[2023-11-05 16:33:39] [indexer:background] Health check
[2023-11-05 16:33:41] [index:background] Health check
[2023-11-05 16:34:34] [indexer:background] Health check
[2023-11-05 16:39:16] [index:background] Health check
[2023-11-05 16:39:57] [indexer:background] Health check
[2023-11-05 16:41:27] [query] Query for: 2024
[2023-11-05 16:41:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 16:41:27] [query] Engine: default
[2023-11-05 16:41:27] [query] Tokens: 2024
[2023-11-05 16:41:27] [query] Mods: 6
[2023-11-05 16:41:27] [query] Found results using: or logic
[2023-11-05 16:41: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 (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-05 16:41:27] [query] Results: 130 Pages of results: 13
[2023-11-05 16:41:27] [query] Execution time: 0.04622
[2023-11-05 16:43:12] [index:background] Health check
[2023-11-05 16:44:38] [indexer:background] Health check
[2023-11-05 16:49:24] [index:background] Health check
[2023-11-05 16:50:48] [indexer:background] Health check
[2023-11-05 16:53:03] [index:background] Health check
[2023-11-05 16:54:34] [indexer:background] Health check
[2023-11-05 16:58:03] [index:background] Health check
[2023-11-05 16:59:33] [indexer:background] Health check
[2023-11-05 17:03:04] [index:background] Health check
[2023-11-05 17:04:33] [indexer:background] Health check
[2023-11-05 17:08:25] [index:background] Health check
[2023-11-05 17:10:29] [indexer:background] Health check
[2023-11-05 17:13:13] [index:background] Health check
[2023-11-05 17:15:39] [indexer:background] Health check
[2023-11-05 17:21:52] [index:background] Health check
[2023-11-05 17:21:52] [indexer:background] Health check
[2023-11-05 17:21:52] [indexer:background] Health check
[2023-11-05 17:24:01] [index:background] Health check
[2023-11-05 17:25:01] [indexer:background] Health check
[2023-11-05 17:28:53] [index:background] Health check
[2023-11-05 17:30:57] [indexer:background] Health check
[2023-11-05 17:33:20] [index:background] Health check
[2023-11-05 17:34:54] [indexer:background] Health check
[2023-11-05 17:41:35] [index:background] Health check
[2023-11-05 17:41:35] [indexer:background] Health check
[2023-11-05 17:41:35] [indexer:background] Health check
[2023-11-05 17:44:24] [index:background] Health check
[2023-11-05 17:44:48] [indexer:background] Health check
[2023-11-05 17:48:46] [index:background] Health check
[2023-11-05 17:49:58] [indexer:background] Health check
[2023-11-05 17:53:25] [index:background] Health check
[2023-11-05 17:54:34] [indexer:background] Health check
[2023-11-05 17:59:51] [index:background] Health check
[2023-11-05 17:59:55] [indexer:background] Health check
[2023-11-05 17:59:56] [indexer:background] Health check
[2023-11-05 18:04:53] [index:background] Health check
[2023-11-05 18:04:53] [indexer:background] Health check
[2023-11-05 18:04:53] [indexer:background] Health check
[2023-11-05 18:08:14] [index:background] Health check
[2023-11-05 18:09:34] [indexer:background] Health check
[2023-11-05 18:14:35] [index:background] Health check
[2023-11-05 18:14:35] [indexer:background] Health check
[2023-11-05 18:14:35] [indexer:background] Health check
[2023-11-05 18:19:00] [index:background] Health check
[2023-11-05 18:22:27] [indexer:background] Health check
[2023-11-05 18:24:26] [index:background] Health check
[2023-11-05 18:26:02] [indexer:background] Health check
[2023-11-05 18:30:21] [index:background] Health check
[2023-11-05 18:30:21] [indexer:background] Health check
[2023-11-05 18:30:22] [indexer:background] Health check
[2023-11-05 18:34:07] [index:background] Health check
[2023-11-05 18:36:08] [indexer:background] Health check
[2023-11-05 18:39:11] [index:background] Health check
[2023-11-05 18:39:13] [query] Query for: search_term_string
[2023-11-05 18:39:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 18:39:13] [query] Engine: default
[2023-11-05 18:39:15] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 18:39:15] [query] Mods: 6
[2023-11-05 18:39:15] [query] Using OR logic
[2023-11-05 18:39:17] [query] Found results using: or logic
[2023-11-05 18:39:17] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-05 18:39:17] [query] Results: 1346 Pages of results: 135
[2023-11-05 18:39:17] [query] Execution time: 4.32126
[2023-11-05 18:42:34] [indexer:background] Health check
[2023-11-05 18:43:12] [index:background] Health check
[2023-11-05 18:45:14] [indexer:background] Health check
[2023-11-05 18:51:24] [index:background] Health check
[2023-11-05 18:51:24] [indexer:background] Health check
[2023-11-05 18:51:24] [indexer:background] Health check
[2023-11-05 18:54:43] [index:background] Health check
[2023-11-05 18:54:45] [indexer:background] Health check
[2023-11-05 18:54:45] [indexer:background] Health check
[2023-11-05 18:59:43] [index:background] Health check
[2023-11-05 18:59:43] [indexer:background] Health check
[2023-11-05 18:59:43] [indexer:background] Health check
[2023-11-05 19:04:40] [index:background] Health check
[2023-11-05 19:04:40] [indexer:background] Health check
[2023-11-05 19:04:40] [indexer:background] Health check
[2023-11-05 19:08:33] [index:background] Health check
[2023-11-05 19:09:36] [indexer:background] Health check
[2023-11-05 19:13:06] [index:background] Health check
[2023-11-05 19:17:34] [indexer:background] Health check
[2023-11-05 19:19:27] [index:background] Health check
[2023-11-05 19:19:59] [indexer:background] Health check
[2023-11-05 19:24:00] [index:background] Health check
[2023-11-05 19:25:33] [indexer:background] Health check
[2023-11-05 19:28:23] [index:background] Health check
[2023-11-05 19:29:44] [indexer:background] Health check
[2023-11-05 19:33:46] [index:background] Health check
[2023-11-05 19:37:42] [indexer:background] Health check
[2023-11-05 19:40:04] [index:background] Health check
[2023-11-05 19:40:04] [indexer:background] Health check
[2023-11-05 19:40:04] [indexer:background] Health check
[2023-11-05 19:43:53] [index:background] Health check
[2023-11-05 19:45:36] [indexer:background] Health check
[2023-11-05 19:49:58] [index:background] Health check
[2023-11-05 19:49:58] [indexer:background] Health check
[2023-11-05 19:49:58] [indexer:background] Health check
[2023-11-05 19:53:26] [index:background] Health check
[2023-11-05 19:55:46] [indexer:background] Health check
[2023-11-05 19:58:52] [index:background] Health check
[2023-11-05 20:00:58] [indexer:background] Health check
[2023-11-05 20:03:08] [index:background] Health check
[2023-11-05 20:06:03] [indexer:background] Health check
[2023-11-05 20:09:14] [index:background] Health check
[2023-11-05 20:10:00] [indexer:background] Health check
[2023-11-05 20:13:43] [index:background] Health check
[2023-11-05 20:15:36] [indexer:background] Health check
[2023-11-05 20:19:50] [index:background] Health check
[2023-11-05 20:19:50] [indexer:background] Health check
[2023-11-05 20:19:50] [indexer:background] Health check
[2023-11-05 20:23:46] [index:background] Health check
[2023-11-05 20:24:44] [indexer:background] Health check
[2023-11-05 20:28:43] [index:background] Health check
[2023-11-05 20:29:36] [indexer:background] Health check
[2023-11-05 20:35:59] [index:background] Health check
[2023-11-05 20:35:59] [indexer:background] Health check
[2023-11-05 20:35:59] [indexer:background] Health check
[2023-11-05 20:39:53] [index:background] Health check
[2023-11-05 20:39:53] [indexer:background] Health check
[2023-11-05 20:39:53] [indexer:background] Health check
[2023-11-05 20:44:58] [index:background] Health check
[2023-11-05 20:44:58] [indexer:background] Health check
[2023-11-05 20:44:58] [indexer:background] Health check
[2023-11-05 20:49:36] [index:background] Health check
[2023-11-05 20:49:36] [indexer:background] Health check
[2023-11-05 20:49:36] [indexer:background] Health check
[2023-11-05 20:53:23] [index:background] Health check
[2023-11-05 20:55:09] [indexer:background] Health check
[2023-11-05 20:58:10] [index:background] Health check
[2023-11-05 21:00:10] [indexer:background] Health check
[2023-11-05 21:03:30] [index:background] Health check
[2023-11-05 21:05:17] [indexer:background] Health check
[2023-11-05 21:08:16] [index:background] Health check
[2023-11-05 21:15:29] [indexer:background] Health check
[2023-11-05 21:15:30] [index:background] Health check
[2023-11-05 21:20:07] [index:background] Health check
[2023-11-05 21:20:07] [indexer:background] Health check
[2023-11-05 21:20:07] [indexer:background] Health check
[2023-11-05 21:23:43] [index:background] Health check
[2023-11-05 21:24:38] [indexer:background] Health check
[2023-11-05 21:31:57] [index:background] Health check
[2023-11-05 21:31:57] [indexer:background] Health check
[2023-11-05 21:31:57] [indexer:background] Health check
[2023-11-05 21:33:07] [index:background] Health check
[2023-11-05 21:35:43] [indexer:background] Health check
[2023-11-05 21:38:34] [index:background] Health check
[2023-11-05 21:39:42] [indexer:background] Health check
[2023-11-05 21:43:45] [index:background] Health check
[2023-11-05 21:45:20] [indexer:background] Health check
[2023-11-05 21:49:11] [index:background] Health check
[2023-11-05 21:49:46] [indexer:background] Health check
[2023-11-05 21:53:38] [index:background] Health check
[2023-11-05 21:54:52] [indexer:background] Health check
[2023-11-05 21:58:50] [index:background] Health check
[2023-11-05 22:00:06] [indexer:background] Health check
[2023-11-05 22:03:51] [index:background] Health check
[2023-11-05 22:04:46] [indexer:background] Health check
[2023-11-05 22:08:43] [index:background] Health check
[2023-11-05 22:10:14] [indexer:background] Health check
[2023-11-05 22:13:17] [index:background] Health check
[2023-11-05 22:15:16] [indexer:background] Health check
[2023-11-05 22:18:34] [index:background] Health check
[2023-11-05 22:19:51] [indexer:background] Health check
[2023-11-05 22:23:13] [index:background] Health check
[2023-11-05 22:24:35] [indexer:background] Health check
[2023-11-05 22:28:07] [index:background] Health check
[2023-11-05 22:31:01] [query] Query for: {search_term_string}
[2023-11-05 22:31:01] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 22:31:01] [query] Engine: default
[2023-11-05 22:31:01] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 22:31:01] [query] Mods: 6
[2023-11-05 22:31:01] [query] Using OR logic
[2023-11-05 22:31:01] [indexer:background] Health check
[2023-11-05 22:31:02] [query] Found results using: or logic
[2023-11-05 22:31: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 (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-05 22:31:02] [query] Results: 1346 Pages of results: 135
[2023-11-05 22:31:02] [query] Execution time: 1.31912
[2023-11-05 22:34:11] [index:background] Health check
[2023-11-05 22:35:17] [indexer:background] Health check
[2023-11-05 22:42:29] [index:background] Health check
[2023-11-05 22:42:29] [indexer:background] Health check
[2023-11-05 22:42:29] [indexer:background] Health check
[2023-11-05 22:43:27] [index:background] Health check
[2023-11-05 22:44:54] [indexer:background] Health check
[2023-11-05 22:48:47] [index:background] Health check
[2023-11-05 22:50:24] [indexer:background] Health check
[2023-11-05 22:53:22] [index:background] Health check
[2023-11-05 22:54:39] [query] Query for: {search_term_string}
[2023-11-05 22:54:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 22:54:39] [query] Engine: default
[2023-11-05 22:54:39] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 22:54:39] [query] Mods: 6
[2023-11-05 22:54:39] [query] Using OR logic
[2023-11-05 22:54:39] [query] Found results using: or logic
[2023-11-05 22:54:39] [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-05 22:54:39] [query] Results: 1346 Pages of results: 135
[2023-11-05 22:54:39] [query] Execution time: 0.04169
[2023-11-05 22:54:40] [indexer:background] Health check
[2023-11-05 22:58:10] [index:background] Health check
[2023-11-05 22:59:35] [indexer:background] Health check
[2023-11-05 23:04:26] [index:background] Health check
[2023-11-05 23:05:59] [indexer:background] Health check
[2023-11-05 23:10:52] [index:background] Health check
[2023-11-05 23:10:52] [indexer:background] Health check
[2023-11-05 23:10:52] [indexer:background] Health check
[2023-11-05 23:13:52] [index:background] Health check
[2023-11-05 23:14:53] [indexer:background] Health check
[2023-11-05 23:18:17] [query] Query for: search_term_string
[2023-11-05 23:18:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2023-11-05 23:18:17] [query] Engine: default
[2023-11-05 23:18:17] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2023-11-05 23:18:17] [query] Mods: 6
[2023-11-05 23:18:17] [query] Using OR logic
[2023-11-05 23:18:17] [query] Found results using: or logic
[2023-11-05 23:18:17] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-05 23:18:17] [query] Results: 1346 Pages of results: 135
[2023-11-05 23:18:17] [query] Execution time: 0.04293
[2023-11-05 23:18:17] [index:background] Health check
[2023-11-05 23:19:48] [indexer:background] Health check
[2023-11-05 23:24:06] [index:background] Health check
[2023-11-05 23:24:42] [indexer:background] Health check
[2023-11-05 23:28:43] [index:background] Health check
[2023-11-05 23:30:39] [indexer:background] Health check
[2023-11-05 23:33:14] [index:background] Health check
[2023-11-05 23:34:45] [indexer:background] Health check
[2023-11-05 23:38:46] [index:background] Health check
[2023-11-05 23:40:16] [indexer:background] Health check
[2023-11-05 23:44:01] [index:background] Health check
[2023-11-05 23:46:53] [indexer:background] Health check
[2023-11-05 23:49:38] [index:background] Health check
[2023-11-05 23:49:38] [indexer:background] Health check
[2023-11-05 23:49:38] [indexer:background] Health check
[2023-11-05 23:53:47] [index:background] Health check
[2023-11-05 23:55:15] [indexer:background] Health check
[2023-11-05 23:58:07] [index:background] Health check