[2024-04-15 00:00:10] [index:background] Health check
[2024-04-15 00:04:17] [indexer:background] Health check
[2024-04-15 00:05:14] [index:background] Health check
[2024-04-15 00:09:18] [indexer:background] Health check
[2024-04-15 00:10:12] [index:background] Health check
[2024-04-15 00:15:20] [indexer:background] Health check
[2024-04-15 00:15:20] [index:background] Health check
[2024-04-15 00:19:20] [indexer:background] Health check
[2024-04-15 00:20:12] [index:background] Health check
[2024-04-15 00:24:18] [indexer:background] Health check
[2024-04-15 00:25:13] [index:background] Health check
[2024-04-15 00:29:17] [indexer:background] Health check
[2024-04-15 00:30:10] [index:background] Health check
[2024-04-15 00:34:16] [indexer:background] Health check
[2024-04-15 00:35:12] [index:background] Health check
[2024-04-15 00:35:54] [query] Query for: 2024
[2024-04-15 00:35:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 00:35:54] [query] Engine: default
[2024-04-15 00:35:54] [query] Tokens: 2024
[2024-04-15 00:35:54] [query] Mods: 6
[2024-04-15 00:35:54] [query] Found results using: or logic
[2024-04-15 00:35:54] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-15 00:35:54] [query] Results: 150 Pages of results: 15
[2024-04-15 00:35:54] [query] Execution time: 0.32707
[2024-04-15 00:39:16] [indexer:background] Health check
[2024-04-15 00:40:13] [index:background] Health check
[2024-04-15 00:44:17] [indexer:background] Health check
[2024-04-15 00:45:10] [index:background] Health check
[2024-04-15 00:49:18] [indexer:background] Health check
[2024-04-15 00:50:11] [index:background] Health check
[2024-04-15 00:54:18] [indexer:background] Health check
[2024-04-15 00:55:10] [index:background] Health check
[2024-04-15 00:59:17] [indexer:background] Health check
[2024-04-15 01:00:14] [index:background] Health check
[2024-04-15 01:04:44] [indexer:background] Health check
[2024-04-15 01:05:11] [index:background] Health check
[2024-04-15 01:09:16] [indexer:background] Health check
[2024-04-15 01:11:12] [index:background] Health check
[2024-04-15 01:14:19] [indexer:background] Health check
[2024-04-15 01:15:10] [index:background] Health check
[2024-04-15 01:19:21] [indexer:background] Health check
[2024-04-15 01:23:54] [index:background] Health check
[2024-04-15 01:26:07] [indexer:background] Health check
[2024-04-15 01:26:09] [index:background] Health check
[2024-04-15 01:34:58] [indexer:background] Health check
[2024-04-15 01:34:58] [index:background] Health check
[2024-04-15 01:38:28] [index:background] Health check
[2024-04-15 01:39:18] [indexer:background] Health check
[2024-04-15 01:40:35] [index:background] Health check
[2024-04-15 01:46:17] [indexer:background] Health check
[2024-04-15 01:46:17] [index:background] Health check
[2024-04-15 01:58:06] [indexer:background] Health check
[2024-04-15 01:58:06] [index:background] Health check
[2024-04-15 01:59:40] [indexer:background] Health check
[2024-04-15 02:01:08] [index:background] Health check
[2024-04-15 02:05:04] [indexer:background] Health check
[2024-04-15 02:05:13] [index:background] Health check
[2024-04-15 02:07:47] [query] Query for: 2023
[2024-04-15 02:07:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 02:07:47] [query] Engine: default
[2024-04-15 02:07:47] [query] Tokens: 2023
[2024-04-15 02:07:47] [query] Mods: 6
[2024-04-15 02:07:47] [query] Found results using: or logic
[2024-04-15 02:07:47] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-15 02:07:47] [query] Results: 273 Pages of results: 28
[2024-04-15 02:07:47] [query] Execution time: 0.24690
[2024-04-15 02:09:23] [indexer:background] Health check
[2024-04-15 02:10:50] [index:background] Health check
[2024-04-15 02:14:24] [indexer:background] Health check
[2024-04-15 02:16:36] [index:background] Health check
[2024-04-15 02:19:51] [indexer:background] Health check
[2024-04-15 02:20:17] [index:background] Health check
[2024-04-15 02:25:01] [indexer:background] Health check
[2024-04-15 02:25:21] [index:background] Health check
[2024-04-15 02:32:49] [indexer:background] Health check
[2024-04-15 02:32:50] [index:background] Health check
[2024-04-15 02:34:31] [indexer:background] Health check
[2024-04-15 02:36:33] [index:background] Health check
[2024-04-15 02:40:02] [indexer:background] Health check
[2024-04-15 02:40:19] [index:background] Health check
[2024-04-15 02:45:45] [indexer:background] Health check
[2024-04-15 02:45:45] [index:background] Health check
[2024-04-15 02:56:28] [indexer:background] Health check
[2024-04-15 02:56:28] [index:background] Health check
[2024-04-15 02:59:23] [indexer:background] Health check
[2024-04-15 03:01:50] [index:background] Health check
[2024-04-15 03:01:50] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2024-04-15 03:01:52] [indexer:background] CPU load threshold (3) breached: 3.28 [waiting 2]
[2024-04-15 03:04:25] [indexer:background] Health check
[2024-04-15 03:04:25] [indexer:background] CPU load threshold (3) breached: 3.78 [waiting 2]
[2024-04-15 03:05:12] [index:background] Health check
[2024-04-15 03:05:12] [index:background] CPU load threshold (3) breached: 3.59 [waiting 2]
[2024-04-15 03:05:14] [indexer:background] CPU load threshold (3) breached: 3.59 [waiting 2]
[2024-04-15 03:09:59] [indexer:background] Health check
[2024-04-15 03:10:41] [index:background] Health check
[2024-04-15 03:15:21] [indexer:background] Health check
[2024-04-15 03:15:21] [index:background] Health check
[2024-04-15 03:20:08] [indexer:background] Health check
[2024-04-15 03:20:23] [index:background] Health check
[2024-04-15 03:26:37] [indexer:background] Health check
[2024-04-15 03:26:37] [index:background] Health check
[2024-04-15 03:33:34] [indexer:background] Health check
[2024-04-15 03:33:34] [index:background] Health check
[2024-04-15 03:36:53] [indexer:background] Health check
[2024-04-15 03:36:55] [index:background] Health check
[2024-04-15 03:39:39] [indexer:background] Health check
[2024-04-15 03:43:35] [index:background] Health check
[2024-04-15 03:50:48] [indexer:background] Health check
[2024-04-15 03:50:48] [index:background] Health check
[2024-04-15 03:55:58] [indexer:background] Health check
[2024-04-15 03:55:58] [index:background] Health check
[2024-04-15 03:59:41] [indexer:background] Health check
[2024-04-15 04:04:20] [index:background] Health check
[2024-04-15 04:04:21] [indexer:background] Health check
[2024-04-15 04:04:21] [indexer:background] Health check
[2024-04-15 04:05:34] [index:background] Health check
[2024-04-15 04:11:59] [indexer:background] Health check
[2024-04-15 04:11:59] [index:background] Health check
[2024-04-15 04:14:22] [indexer:background] Health check
[2024-04-15 04:15:37] [index:background] Health check
[2024-04-15 04:19:16] [indexer:background] Health check
[2024-04-15 04:20:12] [index:background] Health check
[2024-04-15 04:24:29] [indexer:background] Health check
[2024-04-15 04:25:23] [index:background] Health check
[2024-04-15 04:29:48] [indexer:background] Health check
[2024-04-15 04:31:47] [index:background] Health check
[2024-04-15 04:35:16] [indexer:background] Health check
[2024-04-15 04:35:17] [index:background] Health check
[2024-04-15 04:39:22] [indexer:background] Health check
[2024-04-15 04:40:10] [index:background] Health check
[2024-04-15 04:45:17] [indexer:background] Health check
[2024-04-15 04:45:17] [index:background] Health check
[2024-04-15 04:51:05] [indexer:background] Health check
[2024-04-15 04:51:05] [index:background] Health check
[2024-04-15 04:56:59] [indexer:background] Health check
[2024-04-15 04:56:59] [index:background] Health check
[2024-04-15 05:01:54] [indexer:background] Health check
[2024-04-15 05:01:54] [index:background] Health check
[2024-04-15 05:05:57] [indexer:background] Health check
[2024-04-15 05:05:57] [index:background] Health check
[2024-04-15 05:10:46] [indexer:background] Health check
[2024-04-15 05:10:46] [index:background] Health check
[2024-04-15 05:14:19] [indexer:background] Health check
[2024-04-15 05:15:50] [index:background] Health check
[2024-04-15 05:20:18] [indexer:background] Health check
[2024-04-15 05:20:18] [index:background] Health check
[2024-04-15 05:24:40] [indexer:background] Health check
[2024-04-15 05:26:02] [index:background] Health check
[2024-04-15 05:29:25] [indexer:background] Health check
[2024-04-15 05:30:14] [index:background] Health check
[2024-04-15 05:34:25] [indexer:background] Health check
[2024-04-15 05:35:41] [index:background] Health check
[2024-04-15 05:39:37] [indexer:background] Health check
[2024-04-15 05:41:23] [index:background] Health check
[2024-04-15 05:45:31] [indexer:background] Health check
[2024-04-15 05:45:33] [index:background] Health check
[2024-04-15 05:49:41] [indexer:background] Health check
[2024-04-15 05:51:09] [index:background] Health check
[2024-04-15 05:55:17] [indexer:background] Health check
[2024-04-15 05:55:17] [index:background] Health check
[2024-04-15 05:59:42] [indexer:background] Health check
[2024-04-15 06:02:15] [index:background] Health check
[2024-04-15 06:05:15] [indexer:background] Health check
[2024-04-15 06:05:15] [index:background] Health check
[2024-04-15 06:09:22] [indexer:background] Health check
[2024-04-15 06:10:46] [index:background] Health check
[2024-04-15 06:15:17] [indexer:background] Health check
[2024-04-15 06:15:17] [index:background] Health check
[2024-04-15 06:19:58] [indexer:background] Health check
[2024-04-15 06:20:23] [index:background] Health check
[2024-04-15 06:25:01] [indexer:background] Health check
[2024-04-15 06:29:27] [index:background] Health check
[2024-04-15 06:29:27] [indexer:background] Health check
[2024-04-15 06:29:27] [indexer:background] Health check
[2024-04-15 06:31:29] [index:background] Health check
[2024-04-15 06:38:18] [indexer:background] Health check
[2024-04-15 06:38:18] [index:background] Health check
[2024-04-15 06:38:27] [query] Query for: {search_term_string}
[2024-04-15 06:38:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 7 offset: 0 fields: all
[2024-04-15 06:38:27] [query] Engine: default
[2024-04-15 06:38:28] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-15 06:38:28] [query] Mods: 6
[2024-04-15 06:38:28] [query] Using OR logic
[2024-04-15 06:38:29] [query] Found results using: or logic
[2024-04-15 06:38:29] [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 60, 10
[2024-04-15 06:38:29] [query] Results: 1361 Pages of results: 137
[2024-04-15 06:38:29] [query] Execution time: 1.06487
[2024-04-15 06:38:36] [query] Query for: {search_term_string}
[2024-04-15 06:38:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 6 offset: 0 fields: all
[2024-04-15 06:38:36] [query] Engine: default
[2024-04-15 06:38:36] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-15 06:38:36] [query] Mods: 6
[2024-04-15 06:38:36] [query] Using OR logic
[2024-04-15 06:38:37] [query] Found results using: or logic
[2024-04-15 06:38:37] [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 50, 10
[2024-04-15 06:38:37] [query] Results: 1361 Pages of results: 137
[2024-04-15 06:38:37] [query] Execution time: 0.41493
[2024-04-15 06:38:40] [query] Query for: {search_term_string}
[2024-04-15 06:38:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 5 offset: 0 fields: all
[2024-04-15 06:38:40] [query] Engine: default
[2024-04-15 06:38:40] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-15 06:38:40] [query] Mods: 6
[2024-04-15 06:38:40] [query] Using OR logic
[2024-04-15 06:38:41] [query] Found results using: or logic
[2024-04-15 06:38:41] [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 40, 10
[2024-04-15 06:38:41] [query] Results: 1361 Pages of results: 137
[2024-04-15 06:38:41] [query] Execution time: 0.25218
[2024-04-15 06:40:28] [indexer:background] Health check
[2024-04-15 06:40:28] [index:background] Health check
[2024-04-15 06:47:32] [indexer:background] Health check
[2024-04-15 06:47:32] [index:background] Health check
[2024-04-15 06:49:17] [indexer:background] Health check
[2024-04-15 06:51:01] [index:background] Health check
[2024-04-15 06:55:40] [indexer:background] Health check
[2024-04-15 06:55:40] [index:background] Health check
[2024-04-15 07:00:48] [indexer:background] Health check
[2024-04-15 07:00:48] [index:background] Health check
[2024-04-15 07:05:24] [indexer:background] Health check
[2024-04-15 07:05:24] [index:background] Health check
[2024-04-15 07:09:19] [indexer:background] Health check
[2024-04-15 07:10:46] [index:background] Health check
[2024-04-15 07:14:53] [indexer:background] Health check
[2024-04-15 07:16:00] [index:background] Health check
[2024-04-15 07:19:36] [indexer:background] Health check
[2024-04-15 07:20:20] [index:background] Health check
[2024-04-15 07:26:50] [indexer:background] Health check
[2024-04-15 07:26:51] [index:background] Health check
[2024-04-15 07:29:39] [indexer:background] Health check
[2024-04-15 07:31:36] [index:background] Health check
[2024-04-15 07:34:16] [indexer:background] Health check
[2024-04-15 07:37:24] [index:background] Health check
[2024-04-15 07:40:16] [indexer:background] Health check
[2024-04-15 07:40:16] [index:background] Health check
[2024-04-15 07:44:49] [indexer:background] Health check
[2024-04-15 07:45:41] [index:background] Health check
[2024-04-15 07:49:19] [indexer:background] Health check
[2024-04-15 07:50:50] [index:background] Health check
[2024-04-15 07:54:17] [indexer:background] Health check
[2024-04-15 07:55:12] [index:background] Health check
[2024-04-15 07:59:17] [indexer:background] Health check
[2024-04-15 08:00:28] [index:background] Health check
[2024-04-15 08:04:28] [indexer:background] Health check
[2024-04-15 08:05:49] [index:background] Health check
[2024-04-15 08:10:10] [indexer:background] Health check
[2024-04-15 08:10:10] [index:background] Health check
[2024-04-15 08:14:23] [indexer:background] Health check
[2024-04-15 08:15:46] [index:background] Health check
[2024-04-15 08:19:17] [indexer:background] Health check
[2024-04-15 08:20:29] [index:background] Health check
[2024-04-15 08:24:23] [indexer:background] Health check
[2024-04-15 08:26:02] [index:background] Health check
[2024-04-15 08:29:52] [indexer:background] Health check
[2024-04-15 08:30:11] [index:background] Health check
[2024-04-15 08:34:18] [indexer:background] Health check
[2024-04-15 08:35:45] [index:background] Health check
[2024-04-15 08:35:45] [index:background] CPU load threshold (3) breached: 4.65 [waiting 2]
[2024-04-15 08:35:47] [indexer:background] CPU load threshold (3) breached: 4.52 [waiting 2]
[2024-04-15 08:40:05] [indexer:background] Health check
[2024-04-15 08:40:14] [index:background] Health check
[2024-04-15 08:44:23] [indexer:background] Health check
[2024-04-15 08:45:21] [index:background] Health check
[2024-04-15 08:49:57] [indexer:background] Health check
[2024-04-15 08:50:44] [index:background] Health check
[2024-04-15 08:54:26] [indexer:background] Health check
[2024-04-15 08:55:32] [index:background] Health check
[2024-04-15 08:59:32] [indexer:background] Health check
[2024-04-15 09:00:44] [index:background] Health check
[2024-04-15 09:04:18] [indexer:background] Health check
[2024-04-15 09:05:14] [index:background] Health check
[2024-04-15 09:09:28] [indexer:background] Health check
[2024-04-15 09:12:14] [index:background] Health check
[2024-04-15 09:14:22] [indexer:background] Health check
[2024-04-15 09:15:12] [index:background] Health check
[2024-04-15 09:20:20] [indexer:background] Health check
[2024-04-15 09:20:20] [index:background] Health check
[2024-04-15 09:24:32] [indexer:background] Health check
[2024-04-15 09:26:12] [index:background] Health check
[2024-04-15 09:29:41] [indexer:background] Health check
[2024-04-15 09:35:24] [index:background] Health check
[2024-04-15 09:35:24] [indexer:background] Health check
[2024-04-15 09:35:24] [indexer:background] Health check
[2024-04-15 09:39:31] [indexer:background] Health check
[2024-04-15 09:40:10] [index:background] Health check
[2024-04-15 09:44:28] [indexer:background] Health check
[2024-04-15 09:45:47] [index:background] Health check
[2024-04-15 09:50:00] [indexer:background] Health check
[2024-04-15 09:50:49] [index:background] Health check
[2024-04-15 09:56:43] [indexer:background] Health check
[2024-04-15 09:56:43] [index:background] Health check
[2024-04-15 09:59:34] [indexer:background] Health check
[2024-04-15 10:00:10] [index:background] Health check
[2024-04-15 10:04:16] [indexer:background] Health check
[2024-04-15 10:05:13] [index:background] Health check
[2024-04-15 10:11:38] [indexer:background] Health check
[2024-04-15 10:11:38] [index:background] Health check
[2024-04-15 10:14:18] [indexer:background] Health check
[2024-04-15 10:15:16] [index:background] Health check
[2024-04-15 10:19:44] [indexer:background] Health check
[2024-04-15 10:20:53] [index:background] Health check
[2024-04-15 10:24:21] [indexer:background] Health check
[2024-04-15 10:25:54] [index:background] Health check
[2024-04-15 10:30:23] [indexer:background] Health check
[2024-04-15 10:30:23] [index:background] Health check
[2024-04-15 10:34:17] [indexer:background] Health check
[2024-04-15 10:36:12] [index:background] Health check
[2024-04-15 10:36:13] [index:background] Health check
[2024-04-15 10:36:13] [index:background] Health check
[2024-04-15 10:39:18] [indexer:background] Health check
[2024-04-15 10:39:18] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2]
[2024-04-15 10:41:53] [index:background] Health check
[2024-04-15 10:45:37] [indexer:background] Health check
[2024-04-15 10:45:37] [index:background] Health check
[2024-04-15 10:49:21] [indexer:background] Health check
[2024-04-15 10:52:53] [index:background] Health check
[2024-04-15 10:54:19] [indexer:background] Health check
[2024-04-15 10:55:10] [index:background] Health check
[2024-04-15 10:59:18] [indexer:background] Health check
[2024-04-15 11:01:06] [index:background] Health check
[2024-04-15 11:04:19] [indexer:background] Health check
[2024-04-15 11:05:21] [index:background] Health check
[2024-04-15 11:09:20] [indexer:background] Health check
[2024-04-15 11:10:13] [index:background] Health check
[2024-04-15 11:14:23] [indexer:background] Health check
[2024-04-15 11:15:14] [index:background] Health check
[2024-04-15 11:19:26] [indexer:background] Health check
[2024-04-15 11:20:16] [index:background] Health check
[2024-04-15 11:24:20] [indexer:background] Health check
[2024-04-15 11:25:54] [index:background] Health check
[2024-04-15 11:29:24] [indexer:background] Health check
[2024-04-15 11:30:35] [index:background] Health check
[2024-04-15 11:34:53] [indexer:background] Health check
[2024-04-15 11:35:13] [index:background] Health check
[2024-04-15 11:40:49] [indexer:background] Health check
[2024-04-15 11:40:49] [index:background] Health check
[2024-04-15 11:44:41] [indexer:background] Health check
[2024-04-15 11:45:57] [index:background] Health check
[2024-04-15 11:49:17] [indexer:background] Health check
[2024-04-15 11:50:18] [index:background] Health check
[2024-04-15 11:54:45] [indexer:background] Health check
[2024-04-15 11:55:52] [index:background] Health check
[2024-04-15 11:59:19] [indexer:background] Health check
[2024-04-15 12:00:23] [index:background] Health check
[2024-04-15 12:04:19] [indexer:background] Health check
[2024-04-15 12:05:24] [index:background] Health check
[2024-04-15 12:09:31] [indexer:background] Health check
[2024-04-15 12:10:13] [index:background] Health check
[2024-04-15 12:14:53] [indexer:background] Health check
[2024-04-15 12:18:43] [index:background] Health check
[2024-04-15 12:20:58] [indexer:background] Health check
[2024-04-15 12:20:58] [index:background] Health check
[2024-04-15 12:24:22] [indexer:background] Health check
[2024-04-15 12:25:37] [index:background] Health check
[2024-04-15 12:29:51] [indexer:background] Health check
[2024-04-15 12:32:40] [index:background] Health check
[2024-04-15 12:35:26] [indexer:background] Health check
[2024-04-15 12:35:27] [index:background] Health check
[2024-04-15 12:40:19] [indexer:background] Health check
[2024-04-15 12:40:19] [index:background] Health check
[2024-04-15 12:46:21] [indexer:background] Health check
[2024-04-15 12:46:21] [index:background] Health check
[2024-04-15 12:49:16] [indexer:background] Health check
[2024-04-15 12:50:38] [index:background] Health check
[2024-04-15 12:54:39] [indexer:background] Health check
[2024-04-15 12:56:14] [index:background] Health check
[2024-04-15 12:59:40] [indexer:background] Health check
[2024-04-15 13:01:08] [index:background] Health check
[2024-04-15 13:05:16] [indexer:background] Health check
[2024-04-15 13:05:16] [index:background] Health check
[2024-04-15 13:09:24] [indexer:background] Health check
[2024-04-15 13:10:49] [index:background] Health check
[2024-04-15 13:14:42] [indexer:background] Health check
[2024-04-15 13:15:50] [index:background] Health check
[2024-04-15 13:19:33] [indexer:background] Health check
[2024-04-15 13:22:53] [index:background] Health check
[2024-04-15 13:24:33] [indexer:background] Health check
[2024-04-15 13:26:14] [index:background] Health check
[2024-04-15 13:31:00] [indexer:background] Health check
[2024-04-15 13:31:00] [index:background] Health check
[2024-04-15 13:34:17] [indexer:background] Health check
[2024-04-15 13:35:30] [index:background] Health check
[2024-04-15 13:39:30] [indexer:background] Health check
[2024-04-15 13:39:30] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2024-04-15 13:40:55] [index:background] Health check
[2024-04-15 13:44:30] [indexer:background] Health check
[2024-04-15 13:45:41] [index:background] Health check
[2024-04-15 13:49:48] [indexer:background] Health check
[2024-04-15 13:50:25] [index:background] Health check
[2024-04-15 13:54:44] [indexer:background] Health check
[2024-04-15 13:55:12] [index:background] Health check
[2024-04-15 13:59:27] [indexer:background] Health check
[2024-04-15 14:00:35] [index:background] Health check
[2024-04-15 14:05:13] [indexer:background] Health check
[2024-04-15 14:05:13] [index:background] Health check
[2024-04-15 14:05:24] [query] Query for: 2025
[2024-04-15 14:05:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 14:05:24] [query] Engine: default
[2024-04-15 14:05:25] [query] Tokens: 2025
[2024-04-15 14:05:25] [query] Mods: 6
[2024-04-15 14:05:25] [query] Found results using: or logic
[2024-04-15 14:05:25] [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 (15055) 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-15 14:05:25] [query] Results: 138 Pages of results: 14
[2024-04-15 14:05:25] [query] Execution time: 0.90814
[2024-04-15 14:05:36] [query] Query for: 2023
[2024-04-15 14:05:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 14:05:36] [query] Engine: default
[2024-04-15 14:05:36] [query] Tokens: 2023
[2024-04-15 14:05:36] [query] Mods: 6
[2024-04-15 14:05:36] [query] Found results using: or logic
[2024-04-15 14:05:36] [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-15 14:05:36] [query] Results: 273 Pages of results: 28
[2024-04-15 14:05:36] [query] Execution time: 0.27157
[2024-04-15 14:05:36] [query] Query for: 2023
[2024-04-15 14:05:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-15 14:05:36] [query] Engine: default
[2024-04-15 14:05:36] [query] Tokens: 2023
[2024-04-15 14:05:36] [query] Mods: 6
[2024-04-15 14:05:36] [query] Found results using: or logic
[2024-04-15 14:05:36] [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-15 14:05:36] [query] Results: 273 Pages of results: 3
[2024-04-15 14:05:36] [query] Execution time: 0.08791
[2024-04-15 14:05:39] [query] Query for: 2023
[2024-04-15 14:05:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 14:05:39] [query] Engine: default
[2024-04-15 14:05:39] [query] Tokens: 2023
[2024-04-15 14:05:39] [query] Mods: 6
[2024-04-15 14:05:39] [query] Found results using: or logic
[2024-04-15 14:05: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 (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-15 14:05:39] [query] Results: 273 Pages of results: 28
[2024-04-15 14:05:39] [query] Execution time: 0.02770
[2024-04-15 14:09:30] [indexer:background] Health check
[2024-04-15 14:10:23] [index:background] Health check
[2024-04-15 14:12:50] [query] Query for: 2024
[2024-04-15 14:12:50] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 14:12:50] [query] Engine: default
[2024-04-15 14:12:50] [query] Tokens: 2024
[2024-04-15 14:12:50] [query] Mods: 6
[2024-04-15 14:12:50] [query] Found results using: or logic
[2024-04-15 14:12:50] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-15 14:12:50] [query] Results: 150 Pages of results: 15
[2024-04-15 14:12:50] [query] Execution time: 0.28962
[2024-04-15 14:14:39] [indexer:background] Health check
[2024-04-15 14:15:12] [index:background] Health check
[2024-04-15 14:19:23] [indexer:background] Health check
[2024-04-15 14:20:16] [index:background] Health check
[2024-04-15 14:24:56] [indexer:background] Health check
[2024-04-15 14:25:27] [index:background] Health check
[2024-04-15 14:29:29] [indexer:background] Health check
[2024-04-15 14:30:15] [index:background] Health check
[2024-04-15 14:34:20] [indexer:background] Health check
[2024-04-15 14:35:44] [query] Query for: 2025
[2024-04-15 14:35:44] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 14:35:44] [query] Engine: default
[2024-04-15 14:35:44] [query] Tokens: 2025
[2024-04-15 14:35:44] [query] Mods: 6
[2024-04-15 14:35:44] [query] Found results using: or logic
[2024-04-15 14:35:44] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) 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-15 14:35:44] [query] Results: 138 Pages of results: 14
[2024-04-15 14:35:44] [query] Execution time: 0.36831
[2024-04-15 14:35:44] [index:background] Health check
[2024-04-15 14:39:54] [indexer:background] Health check
[2024-04-15 14:40:15] [index:background] Health check
[2024-04-15 14:40:15] [index:background] CPU load threshold (3) breached: 5.28 [waiting 2]
[2024-04-15 14:40:18] [indexer:background] CPU load threshold (3) breached: 5.28 [waiting 2]
[2024-04-15 14:44:26] [indexer:background] Health check
[2024-04-15 14:45:14] [index:background] Health check
[2024-04-15 14:49:22] [indexer:background] Health check
[2024-04-15 14:50:15] [index:background] Health check
[2024-04-15 14:54:38] [indexer:background] Health check
[2024-04-15 14:55:17] [index:background] Health check
[2024-04-15 14:59:35] [indexer:background] Health check
[2024-04-15 15:00:45] [index:background] Health check
[2024-04-15 15:04:42] [indexer:background] Health check
[2024-04-15 15:06:28] [index:background] Health check
[2024-04-15 15:09:18] [indexer:background] Health check
[2024-04-15 15:10:14] [index:background] Health check
[2024-04-15 15:14:18] [indexer:background] Health check
[2024-04-15 15:15:17] [index:background] Health check
[2024-04-15 15:19:19] [indexer:background] Health check
[2024-04-15 15:20:10] [index:background] Health check
[2024-04-15 15:24:28] [indexer:background] Health check
[2024-04-15 15:25:12] [index:background] Health check
[2024-04-15 15:29:22] [indexer:background] Health check
[2024-04-15 15:30:16] [index:background] Health check
[2024-04-15 15:34:17] [indexer:background] Health check
[2024-04-15 15:35:17] [index:background] Health check
[2024-04-15 15:41:26] [indexer:background] Health check
[2024-04-15 15:41:26] [indexer:background] CPU load threshold (3) breached: 4.48 [waiting 2]
[2024-04-15 15:41:28] [index:background] Health check
[2024-04-15 15:41:28] [index:background] CPU load threshold (3) breached: 4.13 [waiting 2]
[2024-04-15 15:41:30] [indexer:background] CPU load threshold (3) breached: 4.13 [waiting 2]
[2024-04-15 15:44:18] [indexer:background] Health check
[2024-04-15 15:45:41] [index:background] Health check
[2024-04-15 15:49:32] [indexer:background] Health check
[2024-04-15 15:50:14] [index:background] Health check
[2024-04-15 15:55:14] [indexer:background] Health check
[2024-04-15 15:55:14] [index:background] Health check
[2024-04-15 15:59:21] [indexer:background] Health check
[2024-04-15 16:00:46] [index:background] Health check
[2024-04-15 16:04:28] [indexer:background] Health check
[2024-04-15 16:05:10] [index:background] Health check
[2024-04-15 16:09:19] [indexer:background] Health check
[2024-04-15 16:10:17] [index:background] Health check
[2024-04-15 16:14:29] [indexer:background] Health check
[2024-04-15 16:15:14] [index:background] Health check
[2024-04-15 16:19:19] [indexer:background] Health check
[2024-04-15 16:20:19] [index:background] Health check
[2024-04-15 16:24:30] [indexer:background] Health check
[2024-04-15 16:25:17] [index:background] Health check
[2024-04-15 16:29:26] [indexer:background] Health check
[2024-04-15 16:31:00] [index:background] Health check
[2024-04-15 16:34:21] [indexer:background] Health check
[2024-04-15 16:35:12] [index:background] Health check
[2024-04-15 16:39:20] [indexer:background] Health check
[2024-04-15 16:40:29] [index:background] Health check
[2024-04-15 16:44:19] [indexer:background] Health check
[2024-04-15 16:45:24] [index:background] Health check
[2024-04-15 16:49:36] [indexer:background] Health check
[2024-04-15 16:51:00] [index:background] Health check
[2024-04-15 16:54:30] [indexer:background] Health check
[2024-04-15 16:55:11] [index:background] Health check
[2024-04-15 16:59:26] [indexer:background] Health check
[2024-04-15 17:00:26] [index:background] Health check
[2024-04-15 17:05:01] [indexer:background] Health check
[2024-04-15 17:06:26] [index:background] Health check
[2024-04-15 17:11:09] [indexer:background] Health check
[2024-04-15 17:11:09] [index:background] Health check
[2024-04-15 17:14:37] [indexer:background] Health check
[2024-04-15 17:15:25] [index:background] Health check
[2024-04-15 17:19:38] [indexer:background] Health check
[2024-04-15 17:20:14] [index:background] Health check
[2024-04-15 17:25:42] [indexer:background] Health check
[2024-04-15 17:25:42] [index:background] Health check
[2024-04-15 17:35:18] [indexer:background] Health check
[2024-04-15 17:35:18] [index:background] Health check
[2024-04-15 17:40:17] [indexer:background] Health check
[2024-04-15 17:40:17] [index:background] Health check
[2024-04-15 17:45:25] [indexer:background] Health check
[2024-04-15 17:45:25] [index:background] Health check
[2024-04-15 17:55:16] [indexer:background] Health check
[2024-04-15 17:55:16] [index:background] Health check
[2024-04-15 17:59:30] [indexer:background] Health check
[2024-04-15 18:00:29] [index:background] Health check
[2024-04-15 18:05:16] [indexer:background] Health check
[2024-04-15 18:05:16] [index:background] Health check
[2024-04-15 18:10:02] [indexer:background] Health check
[2024-04-15 18:10:36] [index:background] Health check
[2024-04-15 18:14:15] [indexer:background] Health check
[2024-04-15 18:15:23] [index:background] Health check
[2024-04-15 18:20:18] [indexer:background] Health check
[2024-04-15 18:20:18] [index:background] Health check
[2024-04-15 18:24:54] [indexer:background] Health check
[2024-04-15 18:26:47] [index:background] Health check
[2024-04-15 18:30:16] [indexer:background] Health check
[2024-04-15 18:30:16] [index:background] Health check
[2024-04-15 18:35:44] [indexer:background] Health check
[2024-04-15 18:35:44] [index:background] Health check
[2024-04-15 18:40:04] [indexer:background] Health check
[2024-04-15 18:40:43] [index:background] Health check
[2024-04-15 18:45:02] [indexer:background] Health check
[2024-04-15 18:45:37] [index:background] Health check
[2024-04-15 18:49:37] [indexer:background] Health check
[2024-04-15 18:51:07] [index:background] Health check
[2024-04-15 18:56:28] [indexer:background] Health check
[2024-04-15 18:56:28] [index:background] Health check
[2024-04-15 19:00:18] [indexer:background] Health check
[2024-04-15 19:00:18] [index:background] Health check
[2024-04-15 19:05:36] [indexer:background] Health check
[2024-04-15 19:05:36] [index:background] Health check
[2024-04-15 19:11:04] [indexer:background] Health check
[2024-04-15 19:11:04] [index:background] Health check
[2024-04-15 19:14:18] [indexer:background] Health check
[2024-04-15 19:15:31] [index:background] Health check
[2024-04-15 19:19:44] [indexer:background] Health check
[2024-04-15 19:22:31] [index:background] Health check
[2024-04-15 19:24:41] [indexer:background] Health check
[2024-04-15 19:25:13] [query] Query for: search_term_string
[2024-04-15 19:25:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 19:25:13] [query] Engine: default
[2024-04-15 19:25:13] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-15 19:25:13] [query] Mods: 6
[2024-04-15 19:25:13] [query] Using OR logic
[2024-04-15 19:25:13] [index:background] Health check
[2024-04-15 19:25:14] [query] Found results using: or logic
[2024-04-15 19:25:14] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-15 19:25:14] [query] Results: 1361 Pages of results: 137
[2024-04-15 19:25:14] [query] Execution time: 0.91443
[2024-04-15 19:27:49] [query] Query for: search_term_string
[2024-04-15 19:27:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 19:27:49] [query] Engine: default
[2024-04-15 19:27:49] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-15 19:27:49] [query] Mods: 6
[2024-04-15 19:27:49] [query] Using OR logic
[2024-04-15 19:27:49] [query] Found results using: or logic
[2024-04-15 19:27:49] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-15 19:27:49] [query] Results: 1361 Pages of results: 137
[2024-04-15 19:27:49] [query] Execution time: 0.05970
[2024-04-15 19:29:31] [indexer:background] Health check
[2024-04-15 19:29:31] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2024-04-15 19:30:19] [index:background] Health check
[2024-04-15 19:35:06] [indexer:background] Health check
[2024-04-15 19:35:25] [index:background] Health check
[2024-04-15 19:39:48] [indexer:background] Health check
[2024-04-15 19:40:10] [index:background] Health check
[2024-04-15 19:45:02] [indexer:background] Health check
[2024-04-15 19:47:24] [index:background] Health check
[2024-04-15 19:52:44] [indexer:background] Health check
[2024-04-15 19:52:44] [index:background] Health check
[2024-04-15 19:54:32] [indexer:background] Health check
[2024-04-15 19:56:09] [index:background] Health check
[2024-04-15 19:59:40] [indexer:background] Health check
[2024-04-15 20:00:18] [index:background] Health check
[2024-04-15 20:05:43] [indexer:background] Health check
[2024-04-15 20:05:44] [index:background] Health check
[2024-04-15 20:09:54] [indexer:background] Health check
[2024-04-15 20:14:59] [index:background] Health check
[2024-04-15 20:14:59] [indexer:background] Health check
[2024-04-15 20:14:59] [indexer:background] Health check
[2024-04-15 20:15:50] [index:background] Health check
[2024-04-15 20:22:07] [indexer:background] Health check
[2024-04-15 20:22:07] [index:background] Health check
[2024-04-15 20:27:06] [indexer:background] Health check
[2024-04-15 20:27:06] [index:background] Health check
[2024-04-15 20:30:46] [indexer:background] Health check
[2024-04-15 20:30:46] [index:background] Health check
[2024-04-15 20:34:32] [indexer:background] Health check
[2024-04-15 20:37:01] [index:background] Health check
[2024-04-15 20:39:33] [indexer:background] Health check
[2024-04-15 20:41:21] [index:background] Health check
[2024-04-15 20:44:50] [indexer:background] Health check
[2024-04-15 20:45:11] [index:background] Health check
[2024-04-15 20:49:41] [indexer:background] Health check
[2024-04-15 20:51:08] [index:background] Health check
[2024-04-15 20:58:06] [indexer:background] Health check
[2024-04-15 20:58:06] [index:background] Health check
[2024-04-15 20:59:54] [indexer:background] Health check
[2024-04-15 21:00:50] [index:background] Health check
[2024-04-15 21:05:29] [indexer:background] Health check
[2024-04-15 21:05:29] [index:background] Health check
[2024-04-15 21:09:56] [indexer:background] Health check
[2024-04-15 21:13:13] [index:background] Health check
[2024-04-15 21:15:01] [indexer:background] Health check
[2024-04-15 21:15:59] [index:background] Health check
[2024-04-15 21:19:26] [indexer:background] Health check
[2024-04-15 21:20:22] [index:background] Health check
[2024-04-15 21:24:42] [indexer:background] Health check
[2024-04-15 21:27:03] [index:background] Health check
[2024-04-15 21:29:21] [indexer:background] Health check
[2024-04-15 21:30:16] [index:background] Health check
[2024-04-15 21:30:16] [index:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2024-04-15 21:30:18] [indexer:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2024-04-15 21:34:39] [indexer:background] Health check
[2024-04-15 21:36:29] [index:background] Health check
[2024-04-15 21:40:30] [indexer:background] Health check
[2024-04-15 21:40:30] [index:background] Health check
[2024-04-15 21:44:15] [indexer:background] Health check
[2024-04-15 21:46:00] [index:background] Health check
[2024-04-15 21:50:55] [indexer:background] Health check
[2024-04-15 21:50:55] [index:background] Health check
[2024-04-15 21:58:12] [indexer:background] Health check
[2024-04-15 21:58:12] [index:background] Health check
[2024-04-15 21:59:18] [indexer:background] Health check
[2024-04-15 22:01:17] [index:background] Health check
[2024-04-15 22:03:36] [query] Query for: 2025
[2024-04-15 22:03:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 22:03:36] [query] Engine: default
[2024-04-15 22:03:36] [query] Tokens: 2025
[2024-04-15 22:03:36] [query] Mods: 6
[2024-04-15 22:03:36] [query] Found results using: or logic
[2024-04-15 22:03:36] [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 (15055) 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-15 22:03:36] [query] Results: 138 Pages of results: 14
[2024-04-15 22:03:36] [query] Execution time: 0.13933
[2024-04-15 22:04:23] [indexer:background] Health check
[2024-04-15 22:06:57] [index:background] Health check
[2024-04-15 22:10:34] [indexer:background] Health check
[2024-04-15 22:10:34] [index:background] Health check
[2024-04-15 22:15:03] [indexer:background] Health check
[2024-04-15 22:16:23] [index:background] Health check
[2024-04-15 22:22:38] [indexer:background] Health check
[2024-04-15 22:22:39] [index:background] Health check
[2024-04-15 22:25:09] [indexer:background] Health check
[2024-04-15 22:25:09] [index:background] Health check
[2024-04-15 22:28:20] [query] Query for: 2024
[2024-04-15 22:28:20] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-15 22:28:20] [query] Engine: default
[2024-04-15 22:28:20] [query] Tokens: 2024
[2024-04-15 22:28:20] [query] Mods: 6
[2024-04-15 22:28:20] [query] Found results using: or logic
[2024-04-15 22:28: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 (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-15 22:28:20] [query] Results: 150 Pages of results: 15
[2024-04-15 22:28:20] [query] Execution time: 0.30397
[2024-04-15 22:29:45] [indexer:background] Health check
[2024-04-15 22:30:16] [index:background] Health check
[2024-04-15 22:30:16] [index:background] CPU load threshold (3) breached: 4.2 [waiting 2]
[2024-04-15 22:30:18] [indexer:background] CPU load threshold (3) breached: 4.1 [waiting 2]
[2024-04-15 22:35:11] [indexer:background] Health check
[2024-04-15 22:35:11] [index:background] Health check
[2024-04-15 22:40:53] [indexer:background] Health check
[2024-04-15 22:40:53] [index:background] Health check
[2024-04-15 22:45:03] [indexer:background] Health check
[2024-04-15 22:45:13] [index:background] Health check
[2024-04-15 22:49:21] [indexer:background] Health check
[2024-04-15 22:50:36] [index:background] Health check
[2024-04-15 22:54:46] [indexer:background] Health check
[2024-04-15 22:56:18] [index:background] Health check
[2024-04-15 23:02:00] [indexer:background] Health check
[2024-04-15 23:02:02] [index:background] Health check
[2024-04-15 23:04:55] [indexer:background] Health check
[2024-04-15 23:05:55] [index:background] Health check
[2024-04-15 23:09:19] [indexer:background] Health check
[2024-04-15 23:10:35] [index:background] Health check
[2024-04-15 23:15:06] [indexer:background] Health check
[2024-04-15 23:16:01] [index:background] Health check
[2024-04-15 23:19:38] [indexer:background] Health check
[2024-04-15 23:20:22] [index:background] Health check
[2024-04-15 23:25:29] [indexer:background] Health check
[2024-04-15 23:25:29] [index:background] Health check
[2024-04-15 23:29:17] [indexer:background] Health check
[2024-04-15 23:30:31] [index:background] Health check
[2024-04-15 23:34:38] [indexer:background] Health check
[2024-04-15 23:39:07] [index:background] Health check
[2024-04-15 23:40:39] [indexer:background] Health check
[2024-04-15 23:40:39] [index:background] Health check
[2024-04-15 23:44:45] [indexer:background] Health check
[2024-04-15 23:45:38] [index:background] Health check
[2024-04-15 23:49:28] [indexer:background] Health check
[2024-04-15 23:51:51] [index:background] Health check
[2024-04-15 23:54:51] [indexer:background] Health check
[2024-04-15 23:55:14] [index:background] Health check