[2023-11-06 00:01:15] [indexer:background] Health check [2023-11-06 00:03:32] [index:background] Health check [2023-11-06 00:04:56] [indexer:background] Health check [2023-11-06 00:08:50] [index:background] Health check [2023-11-06 00:09:56] [indexer:background] Health check [2023-11-06 00:13:04] [index:background] Health check [2023-11-06 00:14:34] [indexer:background] Health check [2023-11-06 00:18:03] [index:background] Health check [2023-11-06 00:18:03] [index:background] CPU load threshold (3) breached: 5.06 [waiting 2] [2023-11-06 00:18:05] [indexer:background] CPU load threshold (3) breached: 4.81 [waiting 2] [2023-11-06 00:20:50] [indexer:background] Health check [2023-11-06 00:23:42] [index:background] Health check [2023-11-06 00:24:50] [indexer:background] Health check [2023-11-06 00:28:21] [index:background] Health check [2023-11-06 00:29:44] [indexer:background] Health check [2023-11-06 00:33:56] [index:background] Health check [2023-11-06 00:35:19] [indexer:background] Health check [2023-11-06 00:40:03] [index:background] Health check [2023-11-06 00:40:03] [indexer:background] Health check [2023-11-06 00:40:03] [indexer:background] Health check [2023-11-06 00:43:49] [index:background] Health check [2023-11-06 00:44:56] [indexer:background] Health check [2023-11-06 00:50:09] [index:background] Health check [2023-11-06 00:50:09] [indexer:background] Health check [2023-11-06 00:50:09] [indexer:background] Health check [2023-11-06 00:53:45] [index:background] Health check [2023-11-06 00:54:35] [indexer:background] Health check [2023-11-06 01:01:27] [index:background] Health check [2023-11-06 01:01:27] [indexer:background] Health check [2023-11-06 01:01:27] [indexer:background] Health check [2023-11-06 01:05:03] [index:background] Health check [2023-11-06 01:05:03] [indexer:background] Health check [2023-11-06 01:05:03] [indexer:background] Health check [2023-11-06 01:08:51] [index:background] Health check [2023-11-06 01:12:11] [indexer:background] Health check [2023-11-06 01:13:23] [index:background] Health check [2023-11-06 01:14:44] [indexer:background] Health check [2023-11-06 01:18:58] [index:background] Health check [2023-11-06 01:20:16] [indexer:background] Health check [2023-11-06 01:23:08] [index:background] Health check [2023-11-06 01:26:03] [indexer:background] Health check [2023-11-06 01:28:05] [index:background] Health check [2023-11-06 01:29:33] [indexer:background] Health check [2023-11-06 01:33:15] [index:background] Health check [2023-11-06 01:34:45] [indexer:background] Health check [2023-11-06 01:39:23] [index:background] Health check [2023-11-06 01:39:39] [indexer:background] Health check [2023-11-06 01:43:50] [index:background] Health check [2023-11-06 01:46:39] [indexer:background] Health check [2023-11-06 01:48:28] [index:background] Health check [2023-11-06 01:49:36] [indexer:background] Health check [2023-11-06 01:55:24] [index:background] Health check [2023-11-06 01:55:24] [indexer:background] Health check [2023-11-06 01:55:24] [indexer:background] Health check [2023-11-06 01:59:15] [index:background] Health check [2023-11-06 02:00:28] [indexer:background] Health check [2023-11-06 02:03:12] [index:background] Health check [2023-11-06 02:04:38] [indexer:background] Health check [2023-11-06 02:09:38] [index:background] Health check [2023-11-06 02:09:38] [indexer:background] Health check [2023-11-06 02:09:38] [indexer:background] Health check [2023-11-06 02:13:06] [index:background] Health check [2023-11-06 02:15:36] [indexer:background] Health check [2023-11-06 02:18:12] [index:background] Health check [2023-11-06 02:19:36] [indexer:background] Health check [2023-11-06 02:23:22] [index:background] Health check [2023-11-06 02:24:47] [indexer:background] Health check [2023-11-06 02:28:22] [index:background] Health check [2023-11-06 02:29:38] [indexer:background] Health check [2023-11-06 02:34:00] [index:background] Health check [2023-11-06 02:34:39] [indexer:background] Health check [2023-11-06 02:38:04] [index:background] Health check [2023-11-06 02:38:04] [index:background] CPU load threshold (3) breached: 3.19 [waiting 2] [2023-11-06 02:38:06] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-06 02:39:39] [indexer:background] Health check [2023-11-06 02:45:33] [index:background] Health check [2023-11-06 02:45:33] [indexer:background] Health check [2023-11-06 02:45:33] [indexer:background] Health check [2023-11-06 02:48:15] [index:background] Health check [2023-11-06 02:49:38] [indexer:background] Health check [2023-11-06 02:53:16] [index:background] Health check [2023-11-06 02:53:16] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-06 02:53:18] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2] [2023-11-06 02:54:47] [indexer:background] Health check [2023-11-06 02:54:47] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2] [2023-11-06 02:59:07] [index:background] Health check [2023-11-06 02:59:07] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-06 02:59:09] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-06 02:59:59] [indexer:background] Health check [2023-11-06 03:04:02] [index:background] Health check [2023-11-06 03:04:02] [index:background] CPU load threshold (3) breached: 4.18 [waiting 2] [2023-11-06 03:04:04] [indexer:background] CPU load threshold (3) breached: 4.18 [waiting 2] [2023-11-06 03:05:06] [indexer:background] Health check [2023-11-06 03:05:06] [indexer:background] CPU load threshold (3) breached: 4.6 [waiting 2] [2023-11-06 03:08:02] [index:background] Health check [2023-11-06 03:09:52] [indexer:background] Health check [2023-11-06 03:13:51] [index:background] Health check [2023-11-06 03:13:51] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-06 03:13:53] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2] [2023-11-06 03:14:38] [indexer:background] Health check [2023-11-06 03:14:38] [indexer:background] CPU load threshold (3) breached: 3.62 [waiting 2] [2023-11-06 03:18:42] [index:background] Health check [2023-11-06 03:24:16] [indexer:background] Health check [2023-11-06 03:24:17] [indexer:background] CPU load threshold (3) breached: 3.66 [waiting 2] [2023-11-06 03:24:19] [index:background] Health check [2023-11-06 03:24:19] [index:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-11-06 03:24:21] [indexer:background] CPU load threshold (3) breached: 3.69 [waiting 2] [2023-11-06 03:25:33] [indexer:background] Health check [2023-11-06 03:25:33] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2] [2023-11-06 03:29:19] [index:background] Health check [2023-11-06 03:29:19] [index:background] CPU load threshold (3) breached: 3.3 [waiting 2] [2023-11-06 03:29:21] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2] [2023-11-06 03:30:18] [indexer:background] Health check [2023-11-06 03:30:18] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2] [2023-11-06 03:33:14] [index:background] Health check [2023-11-06 03:37:28] [indexer:background] Health check [2023-11-06 03:37:29] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2] [2023-11-06 03:38:42] [index:background] Health check [2023-11-06 03:39:47] [indexer:background] Health check [2023-11-06 03:39:47] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2] [2023-11-06 03:43:46] [index:background] Health check [2023-11-06 03:45:08] [indexer:background] Health check [2023-11-06 03:48:48] [index:background] Health check [2023-11-06 03:53:09] [indexer:background] Health check [2023-11-06 03:53:09] [index:background] Health check [2023-11-06 03:57:59] [indexer:background] Health check [2023-11-06 03:58:03] [index:background] Health check [2023-11-06 04:00:32] [indexer:background] Health check [2023-11-06 04:03:32] [index:background] Health check [2023-11-06 04:05:56] [indexer:background] Health check [2023-11-06 04:09:26] [index:background] Health check [2023-11-06 04:12:27] [indexer:background] Health check [2023-11-06 04:12:27] [indexer:background] Health check [2023-11-06 04:13:50] [index:background] Health check [2023-11-06 04:14:53] [indexer:background] Health check [2023-11-06 04:18:44] [index:background] Health check [2023-11-06 04:20:11] [indexer:background] Health check [2023-11-06 04:24:15] [index:background] Health check [2023-11-06 04:26:17] [indexer:background] Health check [2023-11-06 04:31:52] [index:background] Health check [2023-11-06 04:31:52] [indexer:background] Health check [2023-11-06 04:31:52] [indexer:background] Health check [2023-11-06 04:34:41] [index:background] Health check [2023-11-06 04:34:41] [indexer:background] Health check [2023-11-06 04:34:41] [indexer:background] Health check [2023-11-06 04:38:11] [index:background] Health check [2023-11-06 04:40:08] [indexer:background] Health check [2023-11-06 04:44:53] [index:background] Health check [2023-11-06 04:44:53] [indexer:background] Health check [2023-11-06 04:44:53] [indexer:background] Health check [2023-11-06 04:48:36] [index:background] Health check [2023-11-06 04:49:59] [indexer:background] Health check [2023-11-06 04:53:14] [index:background] Health check [2023-11-06 04:54:34] [indexer:background] Health check [2023-11-06 04:58:25] [index:background] Health check [2023-11-06 05:00:07] [indexer:background] Health check [2023-11-06 05:03:03] [index:background] Health check [2023-11-06 05:04:49] [indexer:background] Health check [2023-11-06 05:08:07] [index:background] Health check [2023-11-06 05:10:12] [indexer:background] Health check [2023-11-06 05:13:18] [index:background] Health check [2023-11-06 05:15:08] [indexer:background] Health check [2023-11-06 05:18:39] [index:background] Health check [2023-11-06 05:20:15] [indexer:background] Health check [2023-11-06 05:24:15] [index:background] Health check [2023-11-06 05:25:03] [indexer:background] Health check [2023-11-06 05:28:11] [index:background] Health check [2023-11-06 05:29:40] [indexer:background] Health check [2023-11-06 05:33:21] [index:background] Health check [2023-11-06 05:34:34] [indexer:background] Health check [2023-11-06 05:38:32] [index:background] Health check [2023-11-06 05:39:34] [indexer:background] Health check [2023-11-06 05:43:17] [index:background] Health check [2023-11-06 05:44:34] [indexer:background] Health check [2023-11-06 05:48:12] [index:background] Health check [2023-11-06 05:50:34] [indexer:background] Health check [2023-11-06 05:55:52] [index:background] Health check [2023-11-06 05:55:52] [indexer:background] Health check [2023-11-06 05:55:52] [indexer:background] Health check [2023-11-06 05:59:57] [index:background] Health check [2023-11-06 06:00:01] [indexer:background] Health check [2023-11-06 06:00:01] [indexer:background] Health check [2023-11-06 06:03:39] [index:background] Health check [2023-11-06 06:04:46] [indexer:background] Health check [2023-11-06 06:08:28] [index:background] Health check [2023-11-06 06:09:43] [indexer:background] Health check [2023-11-06 06:13:04] [index:background] Health check [2023-11-06 06:14:40] [indexer:background] Health check [2023-11-06 06:18:05] [index:background] Health check [2023-11-06 06:19:38] [indexer:background] Health check [2023-11-06 06:23:18] [index:background] Health check [2023-11-06 06:24:48] [indexer:background] Health check [2023-11-06 06:28:15] [index:background] Health check [2023-11-06 06:29:36] [indexer:background] Health check [2023-11-06 06:33:09] [index:background] Health check [2023-11-06 06:34:43] [indexer:background] Health check [2023-11-06 06:38:05] [index:background] Health check [2023-11-06 06:39:41] [indexer:background] Health check [2023-11-06 06:43:05] [index:background] Health check [2023-11-06 06:44:42] [indexer:background] Health check [2023-11-06 06:48:43] [index:background] Health check [2023-11-06 06:49:35] [indexer:background] Health check [2023-11-06 06:53:18] [index:background] Health check [2023-11-06 06:54:52] [indexer:background] Health check [2023-11-06 06:58:53] [index:background] Health check [2023-11-06 07:01:04] [indexer:background] Health check [2023-11-06 07:03:16] [index:background] Health check [2023-11-06 07:03:21] [index:background] Health check [2023-11-06 07:04:37] [indexer:background] Health check [2023-11-06 07:08:04] [index:background] Health check [2023-11-06 07:09:41] [indexer:background] Health check [2023-11-06 07:13:05] [index:background] Health check [2023-11-06 07:14:34] [indexer:background] Health check [2023-11-06 07:18:06] [index:background] Health check [2023-11-06 07:19:37] [indexer:background] Health check [2023-11-06 07:23:07] [index:background] Health check [2023-11-06 07:24:36] [indexer:background] Health check [2023-11-06 07:28:08] [index:background] Health check [2023-11-06 07:29:38] [indexer:background] Health check [2023-11-06 07:33:08] [index:background] Health check [2023-11-06 07:34:36] [indexer:background] Health check [2023-11-06 07:38:20] [index:background] Health check [2023-11-06 07:40:14] [indexer:background] Health check [2023-11-06 07:43:09] [index:background] Health check [2023-11-06 07:44:35] [indexer:background] Health check [2023-11-06 07:48:10] [index:background] Health check [2023-11-06 07:49:40] [indexer:background] Health check [2023-11-06 07:53:08] [index:background] Health check [2023-11-06 07:54:34] [indexer:background] Health check [2023-11-06 07:58:05] [index:background] Health check [2023-11-06 07:59:36] [indexer:background] Health check [2023-11-06 08:03:05] [index:background] Health check [2023-11-06 08:04:38] [indexer:background] Health check [2023-11-06 08:08:03] [index:background] Health check [2023-11-06 08:09:34] [indexer:background] Health check [2023-11-06 08:13:29] [index:background] Health check [2023-11-06 08:14:35] [indexer:background] Health check [2023-11-06 08:18:11] [index:background] Health check [2023-11-06 08:19:43] [indexer:background] Health check [2023-11-06 08:23:07] [index:background] Health check [2023-11-06 08:24:46] [indexer:background] Health check [2023-11-06 08:28:05] [index:background] Health check [2023-11-06 08:29:34] [indexer:background] Health check [2023-11-06 08:33:06] [index:background] Health check [2023-11-06 08:34:35] [indexer:background] Health check [2023-11-06 08:38:50] [index:background] Health check [2023-11-06 08:39:54] [indexer:background] Health check [2023-11-06 08:43:09] [index:background] Health check [2023-11-06 08:44:34] [indexer:background] Health check [2023-11-06 08:48:08] [index:background] Health check [2023-11-06 08:48:08] [index:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-11-06 08:48:10] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2] [2023-11-06 08:50:04] [indexer:background] Health check [2023-11-06 08:54:51] [index:background] Health check [2023-11-06 08:54:51] [indexer:background] Health check [2023-11-06 08:54:51] [indexer:background] Health check [2023-11-06 08:58:10] [index:background] Health check [2023-11-06 08:58:58] [query] Query for: 2023 [2023-11-06 08:58:58] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-06 08:58:58] [query] Engine: default [2023-11-06 08:58:59] [query] Tokens: 2023 [2023-11-06 08:58:59] [query] Mods: 6 [2023-11-06 08:58:59] [query] Found results using: or logic [2023-11-06 08:58:59] [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-06 08:58:59] [query] Results: 252 Pages of results: 26 [2023-11-06 08:58:59] [query] Execution time: 0.99575 [2023-11-06 08:59:52] [indexer:background] Health check [2023-11-06 09:03:42] [index:background] Health check [2023-11-06 09:04:36] [indexer:background] Health check [2023-11-06 09:09:17] [index:background] Health check [2023-11-06 09:09:47] [indexer:background] Health check [2023-11-06 09:14:32] [index:background] Health check [2023-11-06 09:14:40] [indexer:background] Health check [2023-11-06 09:18:44] [index:background] Health check [2023-11-06 09:19:37] [indexer:background] Health check [2023-11-06 09:23:02] [index:background] Health check [2023-11-06 09:25:06] [indexer:background] Health check [2023-11-06 09:28:14] [index:background] Health check [2023-11-06 09:29:50] [indexer:background] Health check [2023-11-06 09:33:02] [index:background] Health check [2023-11-06 09:36:31] [indexer:background] Health check [2023-11-06 09:39:36] [index:background] Health check [2023-11-06 09:39:36] [indexer:background] Health check [2023-11-06 09:39:36] [indexer:background] Health check [2023-11-06 09:43:14] [index:background] Health check [2023-11-06 09:46:05] [indexer:background] Health check [2023-11-06 09:48:56] [index:background] Health check [2023-11-06 09:49:50] [indexer:background] Health check [2023-11-06 09:55:04] [index:background] Health check [2023-11-06 09:55:04] [indexer:background] Health check [2023-11-06 09:55:04] [indexer:background] Health check [2023-11-06 09:59:22] [index:background] Health check [2023-11-06 10:01:51] [indexer:background] Health check [2023-11-06 10:04:09] [index:background] Health check [2023-11-06 10:04:36] [indexer:background] Health check [2023-11-06 10:08:45] [index:background] Health check [2023-11-06 10:10:32] [indexer:background] Health check [2023-11-06 10:14:27] [index:background] Health check [2023-11-06 10:14:27] [index:background] CPU load threshold (3) breached: 3.23 [waiting 2] [2023-11-06 10:14:29] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2] [2023-11-06 10:14:48] [indexer:background] Health check [2023-11-06 10:18:10] [index:background] Health check [2023-11-06 10:19:44] [indexer:background] Health check [2023-11-06 10:19:44] [indexer:background] Health check [2023-11-06 10:23:13] [index:background] Health check [2023-11-06 10:24:39] [indexer:background] Health check [2023-11-06 10:28:13] [index:background] Health check [2023-11-06 10:29:41] [indexer:background] Health check [2023-11-06 10:33:09] [index:background] Health check [2023-11-06 10:34:34] [indexer:background] Health check [2023-11-06 10:34:34] [indexer:background] CPU load threshold (3) breached: 3.49 [waiting 2] [2023-11-06 10:38:05] [index:background] Health check [2023-11-06 10:38:05] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-11-06 10:38:07] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-11-06 10:39:34] [indexer:background] Health check [2023-11-06 10:43:13] [index:background] Health check [2023-11-06 10:44:35] [indexer:background] Health check [2023-11-06 10:50:41] [index:background] Health check [2023-11-06 10:50:41] [indexer:background] Health check [2023-11-06 10:50:41] [indexer:background] Health check [2023-11-06 10:53:30] [index:background] Health check [2023-11-06 10:55:10] [indexer:background] Health check [2023-11-06 10:58:17] [index:background] Health check [2023-11-06 10:59:39] [indexer:background] Health check [2023-11-06 10:59:39] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2] [2023-11-06 11:04:21] [index:background] Health check [2023-11-06 11:04:46] [indexer:background] Health check [2023-11-06 11:08:16] [index:background] Health check [2023-11-06 11:11:26] [indexer:background] Health check [2023-11-06 11:13:06] [index:background] Health check [2023-11-06 11:14:40] [indexer:background] Health check [2023-11-06 11:19:05] [index:background] Health check [2023-11-06 11:20:30] [indexer:background] Health check [2023-11-06 11:24:49] [index:background] Health check [2023-11-06 11:24:49] [indexer:background] Health check [2023-11-06 11:24:49] [indexer:background] Health check [2023-11-06 11:28:17] [index:background] Health check [2023-11-06 11:30:12] [indexer:background] Health check [2023-11-06 11:34:02] [index:background] Health check [2023-11-06 11:36:18] [indexer:background] Health check [2023-11-06 11:38:36] [index:background] Health check [2023-11-06 11:40:39] [indexer:background] Health check [2023-11-06 11:44:06] [index:background] Health check [2023-11-06 11:45:42] [indexer:background] Health check [2023-11-06 11:48:57] [index:background] Health check [2023-11-06 11:51:24] [indexer:background] Health check [2023-11-06 11:53:26] [index:background] Health check [2023-11-06 11:54:34] [indexer:background] Health check [2023-11-06 11:58:03] [index:background] Health check [2023-11-06 11:59:34] [indexer:background] Health check [2023-11-06 12:03:04] [index:background] Health check [2023-11-06 12:04:33] [indexer:background] Health check [2023-11-06 12:08:20] [index:background] Health check [2023-11-06 12:09:34] [indexer:background] Health check [2023-11-06 12:13:07] [index:background] Health check [2023-11-06 12:14:54] [indexer:background] Health check [2023-11-06 12:18:23] [index:background] Health check [2023-11-06 12:20:06] [indexer:background] Health check [2023-11-06 12:23:17] [index:background] Health check [2023-11-06 12:25:27] [indexer:background] Health check [2023-11-06 12:28:19] [index:background] Health check [2023-11-06 12:29:39] [indexer:background] Health check [2023-11-06 12:33:48] [index:background] Health check [2023-11-06 12:34:55] [indexer:background] Health check [2023-11-06 12:38:30] [index:background] Health check [2023-11-06 12:40:23] [indexer:background] Health check [2023-11-06 12:43:26] [index:background] Health check [2023-11-06 12:47:20] [indexer:background] Health check [2023-11-06 12:48:53] [index:background] Health check [2023-11-06 12:49:45] [indexer:background] Health check [2023-11-06 12:53:12] [index:background] Health check [2023-11-06 12:54:37] [indexer:background] Health check [2023-11-06 12:58:45] [index:background] Health check [2023-11-06 13:00:01] [indexer:background] Health check [2023-11-06 13:04:17] [query] Query for: {search_term_string} [2023-11-06 13:04:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 62 offset: 0 fields: all [2023-11-06 13:04:17] [query] Engine: default [2023-11-06 13:04:18] [index:background] Health check [2023-11-06 13:04:18] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-11-06 13:04:18] [query] Mods: 6 [2023-11-06 13:04:18] [query] Using OR logic [2023-11-06 13:04:20] [query] Found results using: or logic [2023-11-06 13:04:20] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 610, 10 [2023-11-06 13:04:20] [query] Results: 1346 Pages of results: 135 [2023-11-06 13:04:20] [query] Execution time: 3.17974 [2023-11-06 13:05:32] [indexer:background] Health check [2023-11-06 13:09:21] [index:background] Health check [2023-11-06 13:13:41] [indexer:background] Health check [2023-11-06 13:13:41] [index:background] Health check [2023-11-06 13:15:14] [indexer:background] Health check [2023-11-06 13:18:06] [index:background] Health check [2023-11-06 13:19:44] [indexer:background] Health check [2023-11-06 13:21:51] [query] Query for: {search_term_string} [2023-11-06 13:21:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-06 13:21:51] [query] Engine: default [2023-11-06 13:21:51] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2023-11-06 13:21:51] [query] Mods: 6 [2023-11-06 13:21:51] [query] Using OR logic [2023-11-06 13:21:51] [query] Found results using: or logic [2023-11-06 13:21:51] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-06 13:21:51] [query] Results: 1346 Pages of results: 135 [2023-11-06 13:21:51] [query] Execution time: 0.47830 [2023-11-06 13:25:39] [index:background] Health check [2023-11-06 13:25:39] [index:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-06 13:25:41] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2] [2023-11-06 13:25:43] [indexer:background] Health check [2023-11-06 13:25:43] [indexer:background] Health check [2023-11-06 13:28:55] [index:background] Health check [2023-11-06 13:32:24] [indexer:background] Health check [2023-11-06 13:33:22] [index:background] Health check [2023-11-06 13:34:53] [indexer:background] Health check [2023-11-06 13:38:54] [index:background] Health check [2023-11-06 13:40:49] [indexer:background] Health check [2023-11-06 13:44:08] [index:background] Health check [2023-11-06 13:44:55] [indexer:background] Health check [2023-11-06 13:49:54] [index:background] Health check [2023-11-06 13:49:54] [indexer:background] Health check [2023-11-06 13:49:54] [indexer:background] Health check [2023-11-06 13:53:43] [index:background] Health check [2023-11-06 13:54:42] [indexer:background] Health check [2023-11-06 13:58:07] [index:background] Health check [2023-11-06 14:00:10] [indexer:background] Health check [2023-11-06 14:03:05] [index:background] Health check [2023-11-06 14:05:02] [indexer:background] Health check [2023-11-06 14:09:05] [index:background] Health check [2023-11-06 14:09:46] [indexer:background] Health check [2023-11-06 14:16:53] [index:background] Health check [2023-11-06 14:16:53] [indexer:background] Health check [2023-11-06 14:16:53] [indexer:background] Health check [2023-11-06 14:19:46] [index:background] Health check [2023-11-06 14:19:46] [indexer:background] Health check [2023-11-06 14:19:46] [indexer:background] Health check [2023-11-06 14:23:29] [index:background] Health check [2023-11-06 14:25:01] [indexer:background] Health check [2023-11-06 14:28:42] [index:background] Health check [2023-11-06 14:29:53] [indexer:background] Health check [2023-11-06 14:37:44] [index:background] Health check [2023-11-06 14:37:44] [indexer:background] Health check [2023-11-06 14:37:44] [indexer:background] Health check [2023-11-06 14:38:25] [index:background] Health check [2023-11-06 14:42:49] [indexer:background] Health check [2023-11-06 14:43:06] [index:background] Health check [2023-11-06 14:44:38] [indexer:background] Health check [2023-11-06 14:48:15] [index:background] Health check [2023-11-06 14:49:54] [indexer:background] Health check [2023-11-06 14:53:03] [index:background] Health check [2023-11-06 14:54:45] [indexer:background] Health check [2023-11-06 14:58:04] [index:background] Health check [2023-11-06 15:00:04] [indexer:background] Health check [2023-11-06 15:03:39] [index:background] Health check [2023-11-06 15:04:34] [indexer:background] Health check [2023-11-06 15:08:34] [index:background] Health check [2023-11-06 15:09:42] [indexer:background] Health check [2023-11-06 15:13:55] [index:background] Health check [2023-11-06 15:15:20] [indexer:background] Health check [2023-11-06 15:15:20] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2] [2023-11-06 15:18:07] [index:background] Health check [2023-11-06 15:18:07] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-11-06 15:18:09] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2] [2023-11-06 15:20:07] [indexer:background] Health check [2023-11-06 15:26:36] [index:background] Health check [2023-11-06 15:26:36] [indexer:background] Health check [2023-11-06 15:26:36] [indexer:background] Health check [2023-11-06 15:29:24] [index:background] Health check [2023-11-06 15:30:38] [indexer:background] Health check [2023-11-06 15:34:42] [index:background] Health check [2023-11-06 15:34:42] [indexer:background] Health check [2023-11-06 15:34:42] [indexer:background] Health check [2023-11-06 15:40:42] [index:background] Health check [2023-11-06 15:40:42] [indexer:background] Health check [2023-11-06 15:40:42] [indexer:background] Health check [2023-11-06 15:43:03] [index:background] Health check [2023-11-06 15:44:38] [indexer:background] Health check [2023-11-06 15:48:59] [index:background] Health check [2023-11-06 15:49:53] [indexer:background] Health check [2023-11-06 15:56:00] [index:background] Health check [2023-11-06 15:56:00] [indexer:background] Health check [2023-11-06 15:56:00] [indexer:background] Health check [2023-11-06 15:58:18] [index:background] Health check [2023-11-06 15:59:39] [indexer:background] Health check [2023-11-06 16:03:02] [index:background] Health check [2023-11-06 16:03:02] [index:background] CPU load threshold (3) breached: 3.56 [waiting 2] [2023-11-06 16:03:05] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2] [2023-11-06 16:04:44] [indexer:background] Health check [2023-11-06 16:13:47] [index:background] Health check [2023-11-06 16:13:47] [indexer:background] Health check [2023-11-06 16:13:47] [indexer:background] Health check [2023-11-06 16:16:15] [indexer:background] Health check [2023-11-06 16:18:39] [index:background] Health check [2023-11-06 16:19:35] [indexer:background] Health check [2023-11-06 16:23:22] [index:background] Health check [2023-11-06 16:26:44] [indexer:background] Health check [2023-11-06 16:30:45] [index:background] Health check [2023-11-06 16:30:45] [indexer:background] Health check [2023-11-06 16:30:45] [indexer:background] Health check [2023-11-06 16:33:07] [index:background] Health check [2023-11-06 16:34:46] [indexer:background] Health check [2023-11-06 16:38:11] [index:background] Health check [2023-11-06 16:39:52] [indexer:background] Health check [2023-11-06 16:44:05] [index:background] Health check [2023-11-06 16:45:57] [indexer:background] Health check [2023-11-06 16:48:41] [index:background] Health check [2023-11-06 16:49:53] [indexer:background] Health check [2023-11-06 16:53:08] [index:background] Health check [2023-11-06 16:54:39] [indexer:background] Health check [2023-11-06 16:56:58] [index] Marking post.attachment 14000 to be dropped [2023-11-06 16:57:01] [index] Dropping post.attachment 14000 [2023-11-06 16:57:01] [indexer] Queued next batch (1) [2023-11-06 16:57:02] [indexer] Processing batch (1) [2023-11-06 16:57:02] [indexer] Indexing post.attachment:14000 [2023-11-06 16:57:03] [index] Marking [1] post.attachment 14000 as indexed [2023-11-06 16:57:03] [indexer] Index built [2023-11-06 16:59:43] [index:background] Health check [2023-11-06 16:59:43] [indexer:background] Health check [2023-11-06 16:59:43] [indexer:background] Health check [2023-11-06 17:03:58] [index:background] Health check [2023-11-06 17:05:43] [indexer:background] Health check [2023-11-06 17:08:48] [index:background] Health check [2023-11-06 17:10:02] [indexer:background] Health check [2023-11-06 17:13:34] [index:background] Health check [2023-11-06 17:15:18] [indexer:background] Health check [2023-11-06 17:18:12] [index:background] Health check [2023-11-06 17:21:58] [indexer:background] Health check [2023-11-06 17:24:35] [index:background] Health check [2023-11-06 17:24:35] [indexer:background] Health check [2023-11-06 17:24:35] [indexer:background] Health check [2023-11-06 17:29:00] [index:background] Health check [2023-11-06 17:30:51] [indexer:background] Health check [2023-11-06 17:36:51] [index:background] Health check [2023-11-06 17:36:51] [indexer:background] Health check [2023-11-06 17:36:51] [indexer:background] Health check [2023-11-06 17:38:05] [index:background] Health check [2023-11-06 17:42:07] [indexer:background] Health check [2023-11-06 17:43:15] [index:background] Health check [2023-11-06 17:45:57] [indexer:background] Health check [2023-11-06 17:49:40] [index:background] Health check [2023-11-06 17:49:40] [indexer:background] Health check [2023-11-06 17:49:40] [indexer:background] Health check [2023-11-06 17:53:42] [index:background] Health check [2023-11-06 17:55:08] [indexer:background] Health check [2023-11-06 17:59:57] [index:background] Health check [2023-11-06 18:00:04] [indexer:background] Health check [2023-11-06 18:00:04] [indexer:background] Health check [2023-11-06 18:05:57] [index:background] Health check [2023-11-06 18:05:57] [indexer:background] Health check [2023-11-06 18:05:57] [indexer:background] Health check [2023-11-06 18:08:11] [index:background] Health check [2023-11-06 18:10:04] [indexer:background] Health check [2023-11-06 18:14:21] [index:background] Health check [2023-11-06 18:14:42] [indexer:background] Health check [2023-11-06 18:18:24] [index:background] Health check [2023-11-06 18:19:53] [indexer:background] Health check [2023-11-06 18:23:59] [index:background] Health check [2023-11-06 18:26:07] [indexer:background] Health check [2023-11-06 18:29:11] [index:background] Health check [2023-11-06 18:30:06] [indexer:background] Health check [2023-11-06 18:33:16] [index:background] Health check [2023-11-06 18:34:55] [indexer:background] Health check [2023-11-06 18:38:02] [index:background] Health check [2023-11-06 18:39:39] [indexer:background] Health check [2023-11-06 18:43:03] [index:background] Health check [2023-11-06 18:44:33] [indexer:background] Health check [2023-11-06 18:48:05] [index:background] Health check [2023-11-06 18:49:53] [indexer:background] Health check [2023-11-06 18:53:21] [index:background] Health check [2023-11-06 18:54:45] [indexer:background] Health check [2023-11-06 18:58:35] [index:background] Health check [2023-11-06 18:59:44] [indexer:background] Health check [2023-11-06 19:03:06] [index:background] Health check [2023-11-06 19:05:47] [indexer:background] Health check [2023-11-06 19:08:24] [index:background] Health check [2023-11-06 19:09:52] [indexer:background] Health check [2023-11-06 19:14:40] [index:background] Health check [2023-11-06 19:14:42] [indexer:background] Health check [2023-11-06 19:14:42] [indexer:background] Health check [2023-11-06 19:19:18] [index:background] Health check [2023-11-06 19:19:34] [indexer:background] Health check [2023-11-06 19:25:08] [index:background] Health check [2023-11-06 19:25:08] [indexer:background] Health check [2023-11-06 19:25:08] [indexer:background] Health check [2023-11-06 19:28:50] [index:background] Health check [2023-11-06 19:29:56] [indexer:background] Health check [2023-11-06 19:33:42] [index:background] Health check [2023-11-06 19:36:20] [indexer:background] Health check [2023-11-06 19:39:31] [index:background] Health check [2023-11-06 19:41:57] [indexer:background] Health check [2023-11-06 19:44:33] [index:background] Health check [2023-11-06 19:44:33] [indexer:background] Health check [2023-11-06 19:44:33] [indexer:background] Health check [2023-11-06 19:48:47] [index:background] Health check [2023-11-06 19:49:34] [indexer:background] Health check [2023-11-06 19:53:11] [index:background] Health check [2023-11-06 19:55:57] [indexer:background] Health check [2023-11-06 19:58:38] [index:background] Health check [2023-11-06 20:00:01] [indexer:background] Health check [2023-11-06 20:04:05] [index:background] Health check [2023-11-06 20:07:58] [indexer:background] Health check [2023-11-06 20:08:20] [index:background] Health check [2023-11-06 20:10:11] [indexer:background] Health check [2023-11-06 20:13:39] [index:background] Health check [2023-11-06 20:15:16] [indexer:background] Health check [2023-11-06 20:18:32] [index:background] Health check [2023-11-06 20:19:38] [indexer:background] Health check [2023-11-06 20:23:32] [index:background] Health check [2023-11-06 20:25:05] [indexer:background] Health check [2023-11-06 20:30:34] [index:background] Health check [2023-11-06 20:30:34] [indexer:background] Health check [2023-11-06 20:30:34] [indexer:background] Health check [2023-11-06 20:33:03] [index:background] Health check [2023-11-06 20:34:53] [indexer:background] Health check [2023-11-06 20:39:55] [index:background] Health check [2023-11-06 20:39:55] [indexer:background] Health check [2023-11-06 20:39:55] [indexer:background] Health check [2023-11-06 20:46:10] [index:background] Health check [2023-11-06 20:46:10] [indexer:background] Health check [2023-11-06 20:46:10] [indexer:background] Health check [2023-11-06 20:49:54] [index:background] Health check [2023-11-06 20:49:54] [indexer:background] Health check [2023-11-06 20:49:54] [indexer:background] Health check [2023-11-06 20:54:08] [index:background] Health check [2023-11-06 20:54:53] [indexer:background] Health check [2023-11-06 20:58:35] [index:background] Health check [2023-11-06 20:59:50] [indexer:background] Health check [2023-11-06 21:04:21] [index:background] Health check [2023-11-06 21:04:54] [indexer:background] Health check [2023-11-06 21:10:11] [index:background] Health check [2023-11-06 21:10:11] [indexer:background] Health check [2023-11-06 21:10:11] [indexer:background] Health check [2023-11-06 21:13:37] [index:background] Health check [2023-11-06 21:16:30] [indexer:background] Health check [2023-11-06 21:20:38] [index:background] Health check [2023-11-06 21:20:38] [indexer:background] Health check [2023-11-06 21:20:38] [indexer:background] Health check [2023-11-06 21:24:38] [index:background] Health check [2023-11-06 21:24:38] [indexer:background] Health check [2023-11-06 21:24:38] [indexer:background] Health check [2023-11-06 21:29:50] [index:background] Health check [2023-11-06 21:29:50] [indexer:background] Health check [2023-11-06 21:29:50] [indexer:background] Health check [2023-11-06 21:35:03] [index:background] Health check [2023-11-06 21:35:03] [indexer:background] Health check [2023-11-06 21:35:03] [indexer:background] Health check [2023-11-06 21:38:18] [index:background] Health check [2023-11-06 21:40:00] [indexer:background] Health check [2023-11-06 21:43:26] [index:background] Health check [2023-11-06 21:45:09] [indexer:background] Health check [2023-11-06 21:49:54] [index:background] Health check [2023-11-06 21:49:54] [indexer:background] Health check [2023-11-06 21:49:54] [indexer:background] Health check [2023-11-06 21:54:33] [index:background] Health check [2023-11-06 21:54:33] [indexer:background] Health check [2023-11-06 21:54:33] [indexer:background] Health check [2023-11-06 22:01:32] [index:background] Health check [2023-11-06 22:01:32] [indexer:background] Health check [2023-11-06 22:01:32] [indexer:background] Health check [2023-11-06 22:05:05] [index:background] Health check [2023-11-06 22:05:05] [indexer:background] Health check [2023-11-06 22:05:05] [indexer:background] Health check [2023-11-06 22:09:42] [index:background] Health check [2023-11-06 22:09:42] [indexer:background] Health check [2023-11-06 22:09:42] [indexer:background] Health check [2023-11-06 22:13:43] [index:background] Health check [2023-11-06 22:14:36] [indexer:background] Health check [2023-11-06 22:18:36] [index:background] Health check [2023-11-06 22:19:46] [indexer:background] Health check [2023-11-06 22:26:06] [index:background] Health check [2023-11-06 22:26:06] [indexer:background] Health check [2023-11-06 22:26:06] [indexer:background] Health check [2023-11-06 22:29:03] [index:background] Health check [2023-11-06 22:32:50] [indexer:background] Health check [2023-11-06 22:33:25] [index:background] Health check [2023-11-06 22:36:39] [indexer:background] Health check [2023-11-06 22:39:50] [index:background] Health check [2023-11-06 22:39:50] [indexer:background] Health check [2023-11-06 22:39:50] [indexer:background] Health check [2023-11-06 22:43:53] [index:background] Health check [2023-11-06 22:45:37] [indexer:background] Health check [2023-11-06 22:48:46] [index:background] Health check [2023-11-06 22:50:12] [indexer:background] Health check [2023-11-06 22:54:30] [index:background] Health check [2023-11-06 22:54:56] [indexer:background] Health check [2023-11-06 22:59:11] [index:background] Health check [2023-11-06 23:01:51] [indexer:background] Health check [2023-11-06 23:01:51] [query] Query for: 2023 [2023-11-06 23:01:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2023-11-06 23:01:51] [query] Engine: default [2023-11-06 23:01:52] [query] Tokens: 2023 [2023-11-06 23:01:52] [query] Mods: 6 [2023-11-06 23:01:52] [query] Found results using: or logic [2023-11-06 23:01:52] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-06 23:01:52] [query] Results: 253 Pages of results: 26 [2023-11-06 23:01:52] [query] Execution time: 1.07273 [2023-11-06 23:01:52] [query] Query for: 2023 [2023-11-06 23:01:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-11-06 23:01:52] [query] Engine: default [2023-11-06 23:01:52] [query] Tokens: 2023 [2023-11-06 23:01:52] [query] Mods: 6 [2023-11-06 23:01:52] [query] Found results using: or logic [2023-11-06 23:01:53] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-06 23:01:53] [query] Results: 253 Pages of results: 3 [2023-11-06 23:01:53] [query] Execution time: 0.08836 [2023-11-06 23:03:32] [index:background] Health check [2023-11-06 23:04:53] [indexer:background] Health check [2023-11-06 23:08:37] [index:background] Health check [2023-11-06 23:11:01] [indexer:background] Health check [2023-11-06 23:13:07] [index:background] Health check [2023-11-06 23:15:00] [indexer:background] Health check [2023-11-06 23:19:08] [index:background] Health check [2023-11-06 23:23:16] [indexer:background] Health check [2023-11-06 23:23:16] [index:background] Health check [2023-11-06 23:36:18] [indexer:background] Health check [2023-11-06 23:36:18] [index:background] Health check [2023-11-06 23:38:25] [index:background] Health check [2023-11-06 23:40:16] [indexer:background] Health check [2023-11-06 23:43:27] [index:background] Health check [2023-11-06 23:45:34] [indexer:background] Health check [2023-11-06 23:48:18] [index:background] Health check [2023-11-06 23:49:54] [indexer:background] Health check [2023-11-06 23:53:57] [index:background] Health check [2023-11-06 23:54:41] [indexer:background] Health check [2023-11-06 23:58:44] [index:background] Health check [2023-11-06 23:59:33] [indexer:background] Health check