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