[2024-04-09 00:00:20] [index:background] Health check
[2024-04-09 00:03:04] [indexer:background] Health check
[2024-04-09 00:05:54] [index:background] Health check
[2024-04-09 00:07:18] [indexer:background] Health check
[2024-04-09 00:10:33] [index:background] Health check
[2024-04-09 00:13:35] [indexer:background] Health check
[2024-04-09 00:17:07] [index:background] Health check
[2024-04-09 00:18:28] [indexer:background] Health check
[2024-04-09 00:21:07] [index:background] Health check
[2024-04-09 00:22:44] [indexer:background] Health check
[2024-04-09 00:22:44] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2]
[2024-04-09 00:25:14] [index:background] Health check
[2024-04-09 00:27:14] [indexer:background] Health check
[2024-04-09 00:30:12] [index:background] Health check
[2024-04-09 00:32:14] [indexer:background] Health check
[2024-04-09 00:36:22] [index:background] Health check
[2024-04-09 00:37:13] [indexer:background] Health check
[2024-04-09 00:40:24] [index:background] Health check
[2024-04-09 00:43:05] [indexer:background] Health check
[2024-04-09 00:46:29] [index:background] Health check
[2024-04-09 00:47:56] [indexer:background] Health check
[2024-04-09 00:50:44] [index:background] Health check
[2024-04-09 00:52:43] [indexer:background] Health check
[2024-04-09 00:55:57] [index:background] Health check
[2024-04-09 00:57:43] [indexer:background] Health check
[2024-04-09 01:00:34] [index:background] Health check
[2024-04-09 01:03:08] [indexer:background] Health check
[2024-04-09 01:05:22] [index:background] Health check
[2024-04-09 01:07:19] [indexer:background] Health check
[2024-04-09 01:10:14] [index:background] Health check
[2024-04-09 01:12:44] [indexer:background] Health check
[2024-04-09 01:17:34] [index:background] Health check
[2024-04-09 01:17:34] [indexer:background] Health check
[2024-04-09 01:17:34] [indexer:background] Health check
[2024-04-09 01:20:32] [index:background] Health check
[2024-04-09 01:22:19] [indexer:background] Health check
[2024-04-09 01:25:42] [index:background] Health check
[2024-04-09 01:27:20] [indexer:background] Health check
[2024-04-09 01:30:16] [index:background] Health check
[2024-04-09 01:32:35] [indexer:background] Health check
[2024-04-09 01:35:21] [index:background] Health check
[2024-04-09 01:37:44] [indexer:background] Health check
[2024-04-09 01:40:47] [index:background] Health check
[2024-04-09 01:42:17] [indexer:background] Health check
[2024-04-09 01:45:12] [index:background] Health check
[2024-04-09 01:47:13] [indexer:background] Health check
[2024-04-09 01:50:14] [index:background] Health check
[2024-04-09 01:52:13] [indexer:background] Health check
[2024-04-09 01:55:34] [index:background] Health check
[2024-04-09 01:57:17] [indexer:background] Health check
[2024-04-09 02:00:38] [index:background] Health check
[2024-04-09 02:02:15] [indexer:background] Health check
[2024-04-09 02:05:26] [index:background] Health check
[2024-04-09 02:07:16] [indexer:background] Health check
[2024-04-09 02:10:31] [index:background] Health check
[2024-04-09 02:12:54] [indexer:background] Health check
[2024-04-09 02:16:05] [index:background] Health check
[2024-04-09 02:17:29] [indexer:background] Health check
[2024-04-09 02:21:37] [index:background] Health check
[2024-04-09 02:23:14] [indexer:background] Health check
[2024-04-09 02:25:25] [index:background] Health check
[2024-04-09 02:32:09] [indexer:background] Health check
[2024-04-09 02:32:09] [index:background] Health check
[2024-04-09 02:35:29] [indexer:background] Health check
[2024-04-09 02:35:29] [index:background] Health check
[2024-04-09 02:37:12] [indexer:background] Health check
[2024-04-09 02:40:38] [index:background] Health check
[2024-04-09 02:40:38] [index:background] CPU load threshold (3) breached: 3.13 [waiting 2]
[2024-04-09 02:40:41] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2024-04-09 02:42:50] [indexer:background] Health check
[2024-04-09 02:45:34] [index:background] Health check
[2024-04-09 02:47:42] [indexer:background] Health check
[2024-04-09 02:50:20] [index:background] Health check
[2024-04-09 02:52:40] [indexer:background] Health check
[2024-04-09 02:55:18] [index:background] Health check
[2024-04-09 02:58:03] [indexer:background] Health check
[2024-04-09 03:00:27] [index:background] Health check
[2024-04-09 03:02:23] [indexer:background] Health check
[2024-04-09 03:06:33] [index:background] Health check
[2024-04-09 03:08:14] [indexer:background] Health check
[2024-04-09 03:11:03] [index:background] Health check
[2024-04-09 03:14:53] [indexer:background] Health check
[2024-04-09 03:18:28] [index:background] Health check
[2024-04-09 03:18:31] [indexer:background] Health check
[2024-04-09 03:18:31] [indexer:background] Health check
[2024-04-09 03:21:31] [index:background] Health check
[2024-04-09 03:22:18] [indexer:background] Health check
[2024-04-09 03:25:32] [index:background] Health check
[2024-04-09 03:25:32] [index:background] CPU load threshold (3) breached: 5.59 [waiting 2]
[2024-04-09 03:25:34] [indexer:background] CPU load threshold (3) breached: 5.3 [waiting 2]
[2024-04-09 03:27:27] [indexer:background] Health check
[2024-04-09 03:30:22] [index:background] Health check
[2024-04-09 03:37:16] [indexer:background] Health check
[2024-04-09 03:37:16] [index:background] Health check
[2024-04-09 03:41:32] [index:background] Health check
[2024-04-09 03:42:55] [indexer:background] Health check
[2024-04-09 03:45:38] [index:background] Health check
[2024-04-09 03:48:05] [indexer:background] Health check
[2024-04-09 03:48:05] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2024-04-09 03:50:13] [index:background] Health check
[2024-04-09 03:52:38] [indexer:background] Health check
[2024-04-09 03:58:44] [index:background] Health check
[2024-04-09 03:58:44] [indexer:background] Health check
[2024-04-09 03:58:44] [indexer:background] Health check
[2024-04-09 04:00:29] [index:background] Health check
[2024-04-09 04:00:29] [index:background] CPU load threshold (3) breached: 3.77 [waiting 2]
[2024-04-09 04:00:31] [indexer:background] CPU load threshold (3) breached: 3.71 [waiting 2]
[2024-04-09 04:03:27] [indexer:background] Health check
[2024-04-09 04:03:27] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2024-04-09 04:06:15] [index:background] Health check
[2024-04-09 04:07:37] [indexer:background] Health check
[2024-04-09 04:10:24] [index:background] Health check
[2024-04-09 04:12:36] [indexer:background] Health check
[2024-04-09 04:15:56] [index:background] Health check
[2024-04-09 04:17:13] [indexer:background] Health check
[2024-04-09 04:21:03] [index:background] Health check
[2024-04-09 04:22:55] [indexer:background] Health check
[2024-04-09 04:25:44] [index:background] Health check
[2024-04-09 04:25:44] [index:background] CPU load threshold (3) breached: 4.39 [waiting 2]
[2024-04-09 04:25:46] [indexer:background] CPU load threshold (3) breached: 4.12 [waiting 2]
[2024-04-09 04:28:02] [indexer:background] Health check
[2024-04-09 04:31:18] [index:background] Health check
[2024-04-09 04:32:43] [indexer:background] Health check
[2024-04-09 04:37:20] [index:background] Health check
[2024-04-09 04:37:21] [indexer:background] Health check
[2024-04-09 04:37:21] [indexer:background] Health check
[2024-04-09 04:40:15] [index:background] Health check
[2024-04-09 04:42:38] [indexer:background] Health check
[2024-04-09 04:46:21] [index:background] Health check
[2024-04-09 04:47:39] [indexer:background] Health check
[2024-04-09 04:50:15] [index:background] Health check
[2024-04-09 04:52:21] [indexer:background] Health check
[2024-04-09 04:55:10] [index:background] Health check
[2024-04-09 04:58:37] [indexer:background] Health check
[2024-04-09 05:01:24] [index:background] Health check
[2024-04-09 05:03:11] [indexer:background] Health check
[2024-04-09 05:05:15] [index:background] Health check
[2024-04-09 05:11:58] [indexer:background] Health check
[2024-04-09 05:11:58] [index:background] Health check
[2024-04-09 05:13:19] [indexer:background] Health check
[2024-04-09 05:15:20] [index:background] Health check
[2024-04-09 05:17:17] [indexer:background] Health check
[2024-04-09 05:20:28] [index:background] Health check
[2024-04-09 05:23:25] [indexer:background] Health check
[2024-04-09 05:26:38] [index:background] Health check
[2024-04-09 05:26:38] [index:background] CPU load threshold (3) breached: 4.16 [waiting 2]
[2024-04-09 05:26:40] [indexer:background] CPU load threshold (3) breached: 3.91 [waiting 2]
[2024-04-09 05:27:29] [indexer:background] Health check
[2024-04-09 05:30:56] [index:background] Health check
[2024-04-09 05:32:47] [indexer:background] Health check
[2024-04-09 05:35:16] [index:background] Health check
[2024-04-09 05:38:23] [indexer:background] Health check
[2024-04-09 05:41:11] [index:background] Health check
[2024-04-09 05:42:34] [indexer:background] Health check
[2024-04-09 05:45:20] [index:background] Health check
[2024-04-09 05:47:13] [indexer:background] Health check
[2024-04-09 05:50:54] [index:background] Health check
[2024-04-09 05:52:11] [indexer:background] Health check
[2024-04-09 05:55:35] [index:background] Health check
[2024-04-09 05:57:50] [indexer:background] Health check
[2024-04-09 06:00:44] [index:background] Health check
[2024-04-09 06:03:23] [indexer:background] Health check
[2024-04-09 06:06:12] [index:background] Health check
[2024-04-09 06:07:35] [indexer:background] Health check
[2024-04-09 06:10:21] [index:background] Health check
[2024-04-09 06:12:47] [indexer:background] Health check
[2024-04-09 06:15:54] [index:background] Health check
[2024-04-09 06:17:19] [indexer:background] Health check
[2024-04-09 06:21:08] [index:background] Health check
[2024-04-09 06:23:22] [indexer:background] Health check
[2024-04-09 06:26:06] [index:background] Health check
[2024-04-09 06:27:13] [indexer:background] Health check
[2024-04-09 06:27:13] [indexer:background] CPU load threshold (3) breached: 5.65 [waiting 2]
[2024-04-09 06:30:17] [index:background] Health check
[2024-04-09 06:33:04] [indexer:background] Health check
[2024-04-09 06:35:48] [index:background] Health check
[2024-04-09 06:37:22] [indexer:background] Health check
[2024-04-09 06:40:36] [index:background] Health check
[2024-04-09 06:43:08] [indexer:background] Health check
[2024-04-09 06:45:31] [index:background] Health check
[2024-04-09 06:48:21] [indexer:background] Health check
[2024-04-09 06:50:18] [index:background] Health check
[2024-04-09 06:52:31] [indexer:background] Health check
[2024-04-09 06:55:14] [index:background] Health check
[2024-04-09 06:57:32] [indexer:background] Health check
[2024-04-09 07:00:39] [index:background] Health check
[2024-04-09 07:03:59] [indexer:background] Health check
[2024-04-09 07:05:29] [index:background] Health check
[2024-04-09 07:07:51] [indexer:background] Health check
[2024-04-09 07:10:55] [index:background] Health check
[2024-04-09 07:12:43] [indexer:background] Health check
[2024-04-09 07:15:39] [index:background] Health check
[2024-04-09 07:17:46] [indexer:background] Health check
[2024-04-09 07:20:55] [index:background] Health check
[2024-04-09 07:22:55] [indexer:background] Health check
[2024-04-09 07:27:35] [index:background] Health check
[2024-04-09 07:27:35] [index:background] CPU load threshold (3) breached: 4.41 [waiting 2]
[2024-04-09 07:27:37] [indexer:background] CPU load threshold (3) breached: 4.41 [waiting 2]
[2024-04-09 07:27:39] [indexer:background] Health check
[2024-04-09 07:27:39] [indexer:background] CPU load threshold (3) breached: 4.41 [waiting 2]
[2024-04-09 07:27:41] [indexer:background] Health check
[2024-04-09 07:27:41] [indexer:background] CPU load threshold (3) breached: 5.02 [waiting 2]
[2024-04-09 07:30:12] [index:background] Health check
[2024-04-09 07:32:29] [indexer:background] Health check
[2024-04-09 07:35:26] [index:background] Health check
[2024-04-09 07:38:44] [indexer:background] Health check
[2024-04-09 07:40:36] [index:background] Health check
[2024-04-09 07:43:30] [indexer:background] Health check
[2024-04-09 07:45:41] [index:background] Health check
[2024-04-09 07:47:32] [indexer:background] Health check
[2024-04-09 07:49:29] [query] Query for: {search_term_string}
[2024-04-09 07:49:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 07:49:29] [query] Engine: default
[2024-04-09 07:49:29] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-09 07:49:29] [query] Mods: 6
[2024-04-09 07:49:29] [query] Using OR logic
[2024-04-09 07:49:30] [query] Found results using: or logic
[2024-04-09 07:49: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 (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-09 07:49:30] [query] Results: 1361 Pages of results: 137
[2024-04-09 07:49:30] [query] Execution time: 1.51223
[2024-04-09 07:50:56] [index:background] Health check
[2024-04-09 07:53:17] [indexer:background] Health check
[2024-04-09 07:55:01] [query] Query for: {search_term_string}
[2024-04-09 07:55:01] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 07:55:01] [query] Engine: default
[2024-04-09 07:55:01] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-09 07:55:01] [query] Mods: 6
[2024-04-09 07:55:01] [query] Using OR logic
[2024-04-09 07:55:01] [query] Found results using: or logic
[2024-04-09 07:55:01] [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-09 07:55:01] [query] Results: 1361 Pages of results: 137
[2024-04-09 07:55:01] [query] Execution time: 0.04565
[2024-04-09 07:56:27] [index:background] Health check
[2024-04-09 07:57:17] [indexer:background] Health check
[2024-04-09 08:00:37] [query] Query for: search_term_string
[2024-04-09 08:00:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 08:00:37] [query] Engine: default
[2024-04-09 08:00:37] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-09 08:00:37] [query] Mods: 6
[2024-04-09 08:00:37] [query] Using OR logic
[2024-04-09 08:00:37] [query] Found results using: or logic
[2024-04-09 08:00: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 0, 10
[2024-04-09 08:00:37] [query] Results: 1361 Pages of results: 137
[2024-04-09 08:00:37] [query] Execution time: 0.04378
[2024-04-09 08:00:37] [index:background] Health check
[2024-04-09 08:05:34] [indexer:background] Health check
[2024-04-09 08:05:35] [index:background] Health check
[2024-04-09 08:06:10] [query] Query for: search_term_string
[2024-04-09 08:06:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 08:06:10] [query] Engine: default
[2024-04-09 08:06:10] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-09 08:06:10] [query] Mods: 6
[2024-04-09 08:06:10] [query] Using OR logic
[2024-04-09 08:06:10] [query] Found results using: or logic
[2024-04-09 08:06:10] [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-09 08:06:10] [query] Results: 1361 Pages of results: 137
[2024-04-09 08:06:10] [query] Execution time: 0.04340
[2024-04-09 08:08:13] [indexer:background] Health check
[2024-04-09 08:10:44] [index:background] Health check
[2024-04-09 08:12:13] [indexer:background] Health check
[2024-04-09 08:15:14] [index:background] Health check
[2024-04-09 08:17:20] [indexer:background] Health check
[2024-04-09 08:20:26] [index:background] Health check
[2024-04-09 08:22:17] [indexer:background] Health check
[2024-04-09 08:26:14] [index:background] Health check
[2024-04-09 08:27:18] [indexer:background] Health check
[2024-04-09 08:30:23] [index:background] Health check
[2024-04-09 08:32:55] [indexer:background] Health check
[2024-04-09 08:35:35] [index:background] Health check
[2024-04-09 08:37:24] [indexer:background] Health check
[2024-04-09 08:40:40] [index:background] Health check
[2024-04-09 08:42:16] [indexer:background] Health check
[2024-04-09 08:45:11] [index:background] Health check
[2024-04-09 08:48:13] [indexer:background] Health check
[2024-04-09 08:50:32] [index:background] Health check
[2024-04-09 08:52:23] [indexer:background] Health check
[2024-04-09 08:55:34] [index:background] Health check
[2024-04-09 08:57:38] [indexer:background] Health check
[2024-04-09 09:00:14] [index:background] Health check
[2024-04-09 09:02:30] [indexer:background] Health check
[2024-04-09 09:05:10] [index:background] Health check
[2024-04-09 09:07:58] [indexer:background] Health check
[2024-04-09 09:10:47] [index:background] Health check
[2024-04-09 09:12:16] [indexer:background] Health check
[2024-04-09 09:16:18] [index:background] Health check
[2024-04-09 09:17:45] [indexer:background] Health check
[2024-04-09 09:20:30] [index:background] Health check
[2024-04-09 09:22:31] [indexer:background] Health check
[2024-04-09 09:25:10] [index:background] Health check
[2024-04-09 09:27:32] [indexer:background] Health check
[2024-04-09 09:30:12] [index:background] Health check
[2024-04-09 09:32:16] [indexer:background] Health check
[2024-04-09 09:38:39] [index:background] Health check
[2024-04-09 09:38:39] [indexer:background] Health check
[2024-04-09 09:38:39] [indexer:background] Health check
[2024-04-09 09:40:49] [index:background] Health check
[2024-04-09 09:43:08] [indexer:background] Health check
[2024-04-09 09:47:04] [index:background] Health check
[2024-04-09 09:47:58] [indexer:background] Health check
[2024-04-09 09:50:26] [index:background] Health check
[2024-04-09 09:52:45] [indexer:background] Health check
[2024-04-09 09:55:33] [index:background] Health check
[2024-04-09 09:58:22] [indexer:background] Health check
[2024-04-09 10:00:37] [index:background] Health check
[2024-04-09 10:04:17] [indexer:background] Health check
[2024-04-09 10:06:15] [index:background] Health check
[2024-04-09 10:08:11] [indexer:background] Health check
[2024-04-09 10:10:10] [index:background] Health check
[2024-04-09 10:13:28] [indexer:background] Health check
[2024-04-09 10:15:18] [index:background] Health check
[2024-04-09 10:17:18] [indexer:background] Health check
[2024-04-09 10:20:10] [index:background] Health check
[2024-04-09 10:22:21] [indexer:background] Health check
[2024-04-09 10:25:15] [index:background] Health check
[2024-04-09 10:27:24] [indexer:background] Health check
[2024-04-09 10:30:14] [index:background] Health check
[2024-04-09 10:30:14] [index:background] CPU load threshold (3) breached: 4.54 [waiting 2]
[2024-04-09 10:30:16] [indexer:background] CPU load threshold (3) breached: 4.54 [waiting 2]
[2024-04-09 10:32:15] [indexer:background] Health check
[2024-04-09 10:35:12] [index:background] Health check
[2024-04-09 10:37:45] [indexer:background] Health check
[2024-04-09 10:40:32] [index:background] Health check
[2024-04-09 10:42:16] [indexer:background] Health check
[2024-04-09 10:45:20] [index:background] Health check
[2024-04-09 10:47:13] [indexer:background] Health check
[2024-04-09 10:53:28] [index:background] Health check
[2024-04-09 10:53:31] [indexer:background] Health check
[2024-04-09 10:53:31] [indexer:background] Health check
[2024-04-09 10:55:16] [index:background] Health check
[2024-04-09 10:57:55] [indexer:background] Health check
[2024-04-09 11:00:28] [index:background] Health check
[2024-04-09 11:02:37] [indexer:background] Health check
[2024-04-09 11:05:11] [index:background] Health check
[2024-04-09 11:07:42] [indexer:background] Health check
[2024-04-09 11:10:31] [index:background] Health check
[2024-04-09 11:12:16] [indexer:background] Health check
[2024-04-09 11:16:05] [index:background] Health check
[2024-04-09 11:17:22] [indexer:background] Health check
[2024-04-09 11:20:09] [index:background] Health check
[2024-04-09 11:23:04] [indexer:background] Health check
[2024-04-09 11:25:30] [index:background] Health check
[2024-04-09 11:27:14] [indexer:background] Health check
[2024-04-09 11:30:15] [index:background] Health check
[2024-04-09 11:30:15] [index:background] CPU load threshold (3) breached: 4.82 [waiting 2]
[2024-04-09 11:30:17] [indexer:background] CPU load threshold (3) breached: 4.51 [waiting 2]
[2024-04-09 11:32:19] [indexer:background] Health check
[2024-04-09 11:35:14] [index:background] Health check
[2024-04-09 11:38:26] [indexer:background] Health check
[2024-04-09 11:40:59] [index:background] Health check
[2024-04-09 11:42:37] [indexer:background] Health check
[2024-04-09 11:45:11] [index:background] Health check
[2024-04-09 11:47:36] [indexer:background] Health check
[2024-04-09 11:51:45] [index:background] Health check
[2024-04-09 11:52:23] [indexer:background] Health check
[2024-04-09 11:56:31] [index:background] Health check
[2024-04-09 11:58:01] [indexer:background] Health check
[2024-04-09 12:01:38] [index:background] Health check
[2024-04-09 12:02:15] [indexer:background] Health check
[2024-04-09 12:05:58] [index:background] Health check
[2024-04-09 12:07:42] [indexer:background] Health check
[2024-04-09 12:10:16] [index:background] Health check
[2024-04-09 12:12:15] [indexer:background] Health check
[2024-04-09 12:16:41] [index:background] Health check
[2024-04-09 12:18:16] [indexer:background] Health check
[2024-04-09 12:20:34] [index:background] Health check
[2024-04-09 12:22:59] [indexer:background] Health check
[2024-04-09 12:25:28] [index:background] Health check
[2024-04-09 12:27:23] [indexer:background] Health check
[2024-04-09 12:30:14] [index:background] Health check
[2024-04-09 12:30:14] [index:background] CPU load threshold (3) breached: 5.76 [waiting 2]
[2024-04-09 12:30:16] [indexer:background] CPU load threshold (3) breached: 5.76 [waiting 2]
[2024-04-09 12:32:21] [indexer:background] Health check
[2024-04-09 12:35:42] [index:background] Health check
[2024-04-09 12:37:16] [indexer:background] Health check
[2024-04-09 12:41:41] [index:background] Health check
[2024-04-09 12:43:28] [indexer:background] Health check
[2024-04-09 12:46:30] [index:background] Health check
[2024-04-09 12:48:22] [indexer:background] Health check
[2024-04-09 12:50:31] [index:background] Health check
[2024-04-09 12:52:31] [indexer:background] Health check
[2024-04-09 12:55:23] [index:background] Health check
[2024-04-09 12:58:15] [indexer:background] Health check
[2024-04-09 13:01:32] [index:background] Health check
[2024-04-09 13:02:13] [indexer:background] Health check
[2024-04-09 13:06:47] [index:background] Health check
[2024-04-09 13:07:17] [indexer:background] Health check
[2024-04-09 13:10:12] [index:background] Health check
[2024-04-09 13:12:13] [indexer:background] Health check
[2024-04-09 13:15:29] [index:background] Health check
[2024-04-09 13:17:15] [indexer:background] Health check
[2024-04-09 13:20:10] [index:background] Health check
[2024-04-09 13:22:23] [indexer:background] Health check
[2024-04-09 13:25:13] [index:background] Health check
[2024-04-09 13:27:17] [indexer:background] Health check
[2024-04-09 13:30:20] [index:background] Health check
[2024-04-09 13:32:30] [indexer:background] Health check
[2024-04-09 13:32:30] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2024-04-09 13:35:14] [index:background] Health check
[2024-04-09 13:37:43] [indexer:background] Health check
[2024-04-09 13:40:25] [index:background] Health check
[2024-04-09 13:44:36] [indexer:background] Health check
[2024-04-09 13:46:41] [index:background] Health check
[2024-04-09 13:47:22] [indexer:background] Health check
[2024-04-09 13:51:09] [index:background] Health check
[2024-04-09 13:52:30] [indexer:background] Health check
[2024-04-09 13:55:18] [index:background] Health check
[2024-04-09 13:57:26] [indexer:background] Health check
[2024-04-09 14:00:26] [index:background] Health check
[2024-04-09 14:02:16] [indexer:background] Health check
[2024-04-09 14:07:08] [index:background] Health check
[2024-04-09 14:07:45] [indexer:background] Health check
[2024-04-09 14:10:32] [index:background] Health check
[2024-04-09 14:12:30] [indexer:background] Health check
[2024-04-09 14:15:14] [index:background] Health check
[2024-04-09 14:17:21] [indexer:background] Health check
[2024-04-09 14:20:17] [index:background] Health check
[2024-04-09 14:22:24] [indexer:background] Health check
[2024-04-09 14:25:12] [index:background] Health check
[2024-04-09 14:25:12] [index:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-04-09 14:25:14] [indexer:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-04-09 14:27:20] [indexer:background] Health check
[2024-04-09 14:27:20] [indexer:background] CPU load threshold (3) breached: 6.68 [waiting 2]
[2024-04-09 14:31:09] [index:background] Health check
[2024-04-09 14:31:09] [index:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2024-04-09 14:31:11] [indexer:background] CPU load threshold (3) breached: 3.98 [waiting 2]
[2024-04-09 14:32:24] [indexer:background] Health check
[2024-04-09 14:32:24] [indexer:background] CPU load threshold (3) breached: 4.42 [waiting 2]
[2024-04-09 14:35:14] [index:background] Health check
[2024-04-09 14:38:14] [indexer:background] Health check
[2024-04-09 14:40:44] [index:background] Health check
[2024-04-09 14:42:29] [indexer:background] Health check
[2024-04-09 14:45:19] [index:background] Health check
[2024-04-09 14:47:35] [indexer:background] Health check
[2024-04-09 14:50:59] [index:background] Health check
[2024-04-09 14:53:09] [indexer:background] Health check
[2024-04-09 14:55:53] [index:background] Health check
[2024-04-09 14:57:43] [indexer:background] Health check
[2024-04-09 15:00:14] [index:background] Health check
[2024-04-09 15:03:00] [indexer:background] Health check
[2024-04-09 15:05:47] [index:background] Health check
[2024-04-09 15:07:21] [indexer:background] Health check
[2024-04-09 15:10:49] [index:background] Health check
[2024-04-09 15:12:44] [indexer:background] Health check
[2024-04-09 15:15:13] [index:background] Health check
[2024-04-09 15:17:46] [indexer:background] Health check
[2024-04-09 15:21:06] [index:background] Health check
[2024-04-09 15:23:56] [indexer:background] Health check
[2024-04-09 15:25:19] [index:background] Health check
[2024-04-09 15:27:27] [indexer:background] Health check
[2024-04-09 15:30:32] [index:background] Health check
[2024-04-09 15:32:14] [indexer:background] Health check
[2024-04-09 15:32:14] [indexer:background] CPU load threshold (3) breached: 5.88 [waiting 2]
[2024-04-09 15:35:53] [index:background] Health check
[2024-04-09 15:37:53] [indexer:background] Health check
[2024-04-09 15:40:14] [index:background] Health check
[2024-04-09 15:42:14] [indexer:background] Health check
[2024-04-09 15:45:14] [index:background] Health check
[2024-04-09 15:47:34] [indexer:background] Health check
[2024-04-09 15:51:07] [index:background] Health check
[2024-04-09 15:52:33] [indexer:background] Health check
[2024-04-09 15:55:10] [index:background] Health check
[2024-04-09 15:58:59] [indexer:background] Health check
[2024-04-09 16:00:11] [index:background] Health check
[2024-04-09 16:02:29] [indexer:background] Health check
[2024-04-09 16:07:28] [index:background] Health check
[2024-04-09 16:07:28] [indexer:background] Health check
[2024-04-09 16:07:28] [indexer:background] Health check
[2024-04-09 16:10:16] [index:background] Health check
[2024-04-09 16:12:18] [indexer:background] Health check
[2024-04-09 16:15:38] [index:background] Health check
[2024-04-09 16:17:17] [indexer:background] Health check
[2024-04-09 16:22:40] [index:background] Health check
[2024-04-09 16:22:40] [indexer:background] Health check
[2024-04-09 16:22:40] [indexer:background] Health check
[2024-04-09 16:25:27] [index:background] Health check
[2024-04-09 16:27:52] [indexer:background] Health check
[2024-04-09 16:31:01] [index:background] Health check
[2024-04-09 16:32:25] [indexer:background] Health check
[2024-04-09 16:32:25] [indexer:background] CPU load threshold (3) breached: 5.69 [waiting 2]
[2024-04-09 16:35:11] [index:background] Health check
[2024-04-09 16:37:59] [indexer:background] Health check
[2024-04-09 16:40:11] [index:background] Health check
[2024-04-09 16:42:18] [indexer:background] Health check
[2024-04-09 16:46:15] [index:background] Health check
[2024-04-09 16:46:37] [query] Query for: 2023
[2024-04-09 16:46:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 16:46:37] [query] Engine: default
[2024-04-09 16:46:38] [query] Tokens: 2023
[2024-04-09 16:46:38] [query] Mods: 6
[2024-04-09 16:46:38] [query] Found results using: or logic
[2024-04-09 16:46:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-09 16:46:38] [query] Results: 273 Pages of results: 28
[2024-04-09 16:46:38] [query] Execution time: 0.85479
[2024-04-09 16:46:38] [query] Query for: 2023
[2024-04-09 16:46:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-09 16:46:38] [query] Engine: default
[2024-04-09 16:46:38] [query] Tokens: 2023
[2024-04-09 16:46:38] [query] Mods: 6
[2024-04-09 16:46:38] [query] Found results using: or logic
[2024-04-09 16:46:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-09 16:46:38] [query] Results: 273 Pages of results: 3
[2024-04-09 16:46:38] [query] Execution time: 0.10628
[2024-04-09 16:47:45] [indexer:background] Health check
[2024-04-09 16:50:32] [index:background] Health check
[2024-04-09 16:53:19] [indexer:background] Health check
[2024-04-09 16:56:02] [index:background] Health check
[2024-04-09 16:57:29] [indexer:background] Health check
[2024-04-09 17:00:22] [index:background] Health check
[2024-04-09 17:02:30] [indexer:background] Health check
[2024-04-09 17:05:55] [index:background] Health check
[2024-04-09 17:07:19] [indexer:background] Health check
[2024-04-09 17:11:36] [index:background] Health check
[2024-04-09 17:12:24] [indexer:background] Health check
[2024-04-09 17:17:17] [index:background] Health check
[2024-04-09 17:17:17] [indexer:background] Health check
[2024-04-09 17:17:17] [indexer:background] Health check
[2024-04-09 17:21:13] [index:background] Health check
[2024-04-09 17:23:10] [indexer:background] Health check
[2024-04-09 17:25:11] [index:background] Health check
[2024-04-09 17:27:36] [indexer:background] Health check
[2024-04-09 17:31:03] [index:background] Health check
[2024-04-09 17:32:26] [indexer:background] Health check
[2024-04-09 17:32:26] [indexer:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2024-04-09 17:35:22] [index:background] Health check
[2024-04-09 17:38:13] [indexer:background] Health check
[2024-04-09 17:40:57] [index:background] Health check
[2024-04-09 17:42:17] [indexer:background] Health check
[2024-04-09 17:45:22] [index:background] Health check
[2024-04-09 17:49:18] [indexer:background] Health check
[2024-04-09 17:50:15] [index:background] Health check
[2024-04-09 17:53:37] [indexer:background] Health check
[2024-04-09 17:55:27] [index:background] Health check
[2024-04-09 17:57:32] [indexer:background] Health check
[2024-04-09 18:00:30] [index:background] Health check
[2024-04-09 18:02:39] [indexer:background] Health check
[2024-04-09 18:08:19] [index:background] Health check
[2024-04-09 18:08:19] [indexer:background] Health check
[2024-04-09 18:08:19] [indexer:background] Health check
[2024-04-09 18:10:38] [index:background] Health check
[2024-04-09 18:12:20] [indexer:background] Health check
[2024-04-09 18:16:14] [index:background] Health check
[2024-04-09 18:17:32] [indexer:background] Health check
[2024-04-09 18:20:43] [index:background] Health check
[2024-04-09 18:22:48] [indexer:background] Health check
[2024-04-09 18:33:57] [index:background] Health check
[2024-04-09 18:33:57] [index:background] CPU load threshold (3) breached: 5.32 [waiting 2]
[2024-04-09 18:33:59] [indexer:background] CPU load threshold (3) breached: 5.32 [waiting 2]
[2024-04-09 18:34:01] [indexer:background] Health check
[2024-04-09 18:34:01] [indexer:background] CPU load threshold (3) breached: 5.32 [waiting 2]
[2024-04-09 18:34:03] [indexer:background] Health check
[2024-04-09 18:34:03] [indexer:background] CPU load threshold (3) breached: 5.22 [waiting 2]
[2024-04-09 18:36:36] [index:background] Health check
[2024-04-09 18:37:15] [indexer:background] Health check
[2024-04-09 18:41:06] [index:background] Health check
[2024-04-09 18:44:27] [indexer:background] Health check
[2024-04-09 18:45:11] [index:background] Health check
[2024-04-09 18:51:31] [indexer:background] Health check
[2024-04-09 18:51:31] [index:background] Health check
[2024-04-09 18:52:15] [indexer:background] Health check
[2024-04-09 18:55:31] [index:background] Health check
[2024-04-09 18:57:50] [indexer:background] Health check
[2024-04-09 19:00:13] [index:background] Health check
[2024-04-09 19:02:23] [indexer:background] Health check
[2024-04-09 19:05:17] [query] Query for: search_term_string
[2024-04-09 19:05:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 19:05:17] [query] Engine: default
[2024-04-09 19:05:17] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-09 19:05:17] [query] Mods: 6
[2024-04-09 19:05:17] [query] Using OR logic
[2024-04-09 19:05:17] [index:background] Health check
[2024-04-09 19:05:18] [query] Found results using: or logic
[2024-04-09 19:05:18] [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-09 19:05:18] [query] Results: 1361 Pages of results: 137
[2024-04-09 19:05:18] [query] Execution time: 1.08725
[2024-04-09 19:07:45] [indexer:background] Health check
[2024-04-09 19:10:21] [index:background] Health check
[2024-04-09 19:13:42] [indexer:background] Health check
[2024-04-09 19:16:17] [index:background] Health check
[2024-04-09 19:17:40] [indexer:background] Health check
[2024-04-09 19:22:06] [index:background] Health check
[2024-04-09 19:22:51] [indexer:background] Health check
[2024-04-09 19:26:17] [index:background] Health check
[2024-04-09 19:27:13] [indexer:background] Health check
[2024-04-09 19:30:27] [index:background] Health check
[2024-04-09 19:33:18] [indexer:background] Health check
[2024-04-09 19:36:05] [index:background] Health check
[2024-04-09 19:37:35] [indexer:background] Health check
[2024-04-09 19:42:00] [index:background] Health check
[2024-04-09 19:46:59] [indexer:background] Health check
[2024-04-09 19:46:59] [index:background] Health check
[2024-04-09 19:47:19] [indexer:background] Health check
[2024-04-09 19:50:23] [index:background] Health check
[2024-04-09 19:52:33] [indexer:background] Health check
[2024-04-09 19:55:36] [index:background] Health check
[2024-04-09 19:57:14] [indexer:background] Health check
[2024-04-09 20:01:13] [index:background] Health check
[2024-04-09 20:02:30] [indexer:background] Health check
[2024-04-09 20:08:26] [index:background] Health check
[2024-04-09 20:08:26] [indexer:background] Health check
[2024-04-09 20:08:26] [indexer:background] Health check
[2024-04-09 20:10:15] [index:background] Health check
[2024-04-09 20:12:16] [indexer:background] Health check
[2024-04-09 20:16:27] [index:background] Health check
[2024-04-09 20:17:23] [indexer:background] Health check
[2024-04-09 20:20:12] [index:background] Health check
[2024-04-09 20:22:20] [indexer:background] Health check
[2024-04-09 20:25:11] [index:background] Health check
[2024-04-09 20:28:12] [indexer:background] Health check
[2024-04-09 20:30:20] [index:background] Health check
[2024-04-09 20:32:18] [indexer:background] Health check
[2024-04-09 20:35:43] [index:background] Health check
[2024-04-09 20:35:43] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2024-04-09 20:35:45] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2024-04-09 20:38:46] [indexer:background] Health check
[2024-04-09 20:40:23] [index:background] Health check
[2024-04-09 20:43:10] [indexer:background] Health check
[2024-04-09 20:49:09] [index:background] Health check
[2024-04-09 20:49:10] [indexer:background] Health check
[2024-04-09 20:49:10] [indexer:background] Health check
[2024-04-09 20:52:49] [index:background] Health check
[2024-04-09 20:52:49] [indexer:background] Health check
[2024-04-09 20:52:49] [indexer:background] Health check
[2024-04-09 20:57:09] [index:background] Health check
[2024-04-09 20:57:34] [indexer:background] Health check
[2024-04-09 21:00:13] [index:background] Health check
[2024-04-09 21:02:21] [indexer:background] Health check
[2024-04-09 21:05:26] [index:background] Health check
[2024-04-09 21:07:53] [indexer:background] Health check
[2024-04-09 21:13:27] [index:background] Health check
[2024-04-09 21:13:27] [indexer:background] Health check
[2024-04-09 21:13:27] [indexer:background] Health check
[2024-04-09 21:15:48] [index:background] Health check
[2024-04-09 21:17:41] [indexer:background] Health check
[2024-04-09 21:20:30] [index:background] Health check
[2024-04-09 21:24:38] [indexer:background] Health check
[2024-04-09 21:25:58] [index:background] Health check
[2024-04-09 21:28:16] [indexer:background] Health check
[2024-04-09 21:30:14] [index:background] Health check
[2024-04-09 21:34:16] [indexer:background] Health check
[2024-04-09 21:37:01] [index:background] Health check
[2024-04-09 21:37:16] [indexer:background] Health check
[2024-04-09 21:41:26] [index:background] Health check
[2024-04-09 21:42:23] [indexer:background] Health check
[2024-04-09 21:45:44] [index:background] Health check
[2024-04-09 21:48:30] [indexer:background] Health check
[2024-04-09 21:50:17] [index:background] Health check
[2024-04-09 21:52:12] [indexer:background] Health check
[2024-04-09 21:57:03] [index:background] Health check
[2024-04-09 21:58:18] [indexer:background] Health check
[2024-04-09 22:00:59] [index:background] Health check
[2024-04-09 22:02:50] [indexer:background] Health check
[2024-04-09 22:05:13] [index:background] Health check
[2024-04-09 22:07:12] [indexer:background] Health check
[2024-04-09 22:10:17] [index:background] Health check
[2024-04-09 22:13:04] [indexer:background] Health check
[2024-04-09 22:15:18] [index:background] Health check
[2024-04-09 22:17:12] [indexer:background] Health check
[2024-04-09 22:20:29] [index:background] Health check
[2024-04-09 22:22:46] [indexer:background] Health check
[2024-04-09 22:26:20] [index:background] Health check
[2024-04-09 22:28:28] [indexer:background] Health check
[2024-04-09 22:30:50] [index:background] Health check
[2024-04-09 22:33:44] [indexer:background] Health check
[2024-04-09 22:39:28] [index:background] Health check
[2024-04-09 22:39:28] [indexer:background] Health check
[2024-04-09 22:39:28] [indexer:background] Health check
[2024-04-09 22:43:05] [index:background] Health check
[2024-04-09 22:43:07] [indexer:background] Health check
[2024-04-09 22:43:07] [indexer:background] Health check
[2024-04-09 22:45:50] [index:background] Health check
[2024-04-09 22:47:16] [indexer:background] Health check
[2024-04-09 22:51:40] [index:background] Health check
[2024-04-09 22:52:37] [indexer:background] Health check
[2024-04-09 22:56:02] [index:background] Health check
[2024-04-09 22:57:49] [indexer:background] Health check
[2024-04-09 23:02:03] [index:background] Health check
[2024-04-09 23:02:18] [indexer:background] Health check
[2024-04-09 23:06:39] [index:background] Health check
[2024-04-09 23:07:24] [indexer:background] Health check
[2024-04-09 23:12:04] [index:background] Health check
[2024-04-09 23:12:22] [indexer:background] Health check
[2024-04-09 23:15:20] [index:background] Health check
[2024-04-09 23:17:14] [indexer:background] Health check
[2024-04-09 23:21:22] [index:background] Health check
[2024-04-09 23:22:23] [indexer:background] Health check
[2024-04-09 23:25:35] [index:background] Health check
[2024-04-09 23:27:37] [indexer:background] Health check
[2024-04-09 23:31:11] [index:background] Health check
[2024-04-09 23:32:35] [indexer:background] Health check
[2024-04-09 23:34:48] [query] Query for: lzk2lug7umbtltm8vc1dqfmtmzhbcmak
[2024-04-09 23:34:48] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 23:34:48] [query] Query for: lzk2lug7umbtltm8vc1dqfmtmzhbcmak
[2024-04-09 23:34:48] [query] Engine: default
[2024-04-09 23:34:48] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-09 23:34:48] [query] Engine: default
[2024-04-09 23:34:48] [query] Tokens: lzk2lug7umbtltm8vc1dqfmtmzhbcmak
[2024-04-09 23:34:48] [query] Tokens: lzk2lug7umbtltm8vc1dqfmtmzhbcmak
[2024-04-09 23:34:48] [query] Mods: 6
[2024-04-09 23:34:48] [query] Mods: 6
[2024-04-09 23:34:48] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-09 23:34:48] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-09 23:34:48] [query] Results: 0 Pages of results: 0
[2024-04-09 23:34:48] [query] Results: 0 Pages of results: 0
[2024-04-09 23:34:48] [query] Execution time: 0.06719
[2024-04-09 23:34:48] [query] Execution time: 0.06809
[2024-04-09 23:35:23] [index:background] Health check
[2024-04-09 23:37:22] [indexer:background] Health check
[2024-04-09 23:37:22] [indexer:background] CPU load threshold (3) breached: 4.55 [waiting 2]
[2024-04-09 23:40:10] [index:background] Health check
[2024-04-09 23:42:13] [indexer:background] Health check
[2024-04-09 23:45:11] [index:background] Health check
[2024-04-09 23:48:27] [indexer:background] Health check
[2024-04-09 23:50:43] [index:background] Health check
[2024-04-09 23:52:13] [indexer:background] Health check
[2024-04-09 23:56:09] [index:background] Health check
[2024-04-09 23:58:04] [indexer:background] Health check