[2024-07-09 00:00:12] [indexer:background] Health check
[2024-07-09 00:05:01] [index:background] Health check
[2024-07-09 00:05:01] [indexer:background] Health check
[2024-07-09 00:05:01] [indexer:background] Health check
[2024-07-09 00:08:47] [index:background] Health check
[2024-07-09 00:10:22] [indexer:background] Health check
[2024-07-09 00:14:20] [index:background] Health check
[2024-07-09 00:14:20] [indexer:background] Health check
[2024-07-09 00:14:20] [indexer:background] Health check
[2024-07-09 00:20:10] [index:background] Health check
[2024-07-09 00:20:10] [indexer:background] Health check
[2024-07-09 00:20:10] [indexer:background] Health check
[2024-07-09 00:24:33] [index:background] Health check
[2024-07-09 00:24:33] [indexer:background] Health check
[2024-07-09 00:24:33] [indexer:background] Health check
[2024-07-09 00:28:48] [index:background] Health check
[2024-07-09 00:31:42] [indexer:background] Health check
[2024-07-09 00:34:20] [index:background] Health check
[2024-07-09 00:34:20] [indexer:background] Health check
[2024-07-09 00:34:20] [indexer:background] Health check
[2024-07-09 00:39:27] [index:background] Health check
[2024-07-09 00:39:27] [indexer:background] Health check
[2024-07-09 00:39:27] [indexer:background] Health check
[2024-07-09 00:43:56] [index:background] Health check
[2024-07-09 00:45:08] [indexer:background] Health check
[2024-07-09 00:49:05] [index:background] Health check
[2024-07-09 00:49:16] [indexer:background] Health check
[2024-07-09 00:53:44] [index:background] Health check
[2024-07-09 00:54:16] [indexer:background] Health check
[2024-07-09 00:58:42] [index:background] Health check
[2024-07-09 00:59:17] [indexer:background] Health check
[2024-07-09 01:03:46] [index:background] Health check
[2024-07-09 01:04:16] [indexer:background] Health check
[2024-07-09 01:08:44] [index:background] Health check
[2024-07-09 01:09:18] [indexer:background] Health check
[2024-07-09 01:13:53] [index:background] Health check
[2024-07-09 01:18:49] [indexer:background] Health check
[2024-07-09 01:18:49] [index:background] Health check
[2024-07-09 01:20:23] [indexer:background] Health check
[2024-07-09 01:27:33] [index:background] Health check
[2024-07-09 01:27:33] [indexer:background] Health check
[2024-07-09 01:27:33] [indexer:background] Health check
[2024-07-09 01:29:25] [index:background] Health check
[2024-07-09 01:29:25] [indexer:background] Health check
[2024-07-09 01:29:25] [indexer:background] Health check
[2024-07-09 01:34:45] [index:background] Health check
[2024-07-09 01:34:45] [indexer:background] Health check
[2024-07-09 01:34:45] [indexer:background] Health check
[2024-07-09 01:39:05] [index:background] Health check
[2024-07-09 01:39:38] [indexer:background] Health check
[2024-07-09 01:44:41] [index:background] Health check
[2024-07-09 01:44:41] [indexer:background] Health check
[2024-07-09 01:44:41] [indexer:background] Health check
[2024-07-09 01:48:57] [index:background] Health check
[2024-07-09 01:51:59] [indexer:background] Health check
[2024-07-09 01:53:46] [index:background] Health check
[2024-07-09 01:55:14] [indexer:background] Health check
[2024-07-09 01:59:41] [index:background] Health check
[2024-07-09 01:59:41] [indexer:background] Health check
[2024-07-09 01:59:41] [indexer:background] Health check
[2024-07-09 02:03:42] [index:background] Health check
[2024-07-09 02:05:23] [indexer:background] Health check
[2024-07-09 02:09:10] [index:background] Health check
[2024-07-09 02:09:43] [indexer:background] Health check
[2024-07-09 02:13:56] [index:background] Health check
[2024-07-09 02:14:37] [indexer:background] Health check
[2024-07-09 02:19:53] [index:background] Health check
[2024-07-09 02:19:53] [indexer:background] Health check
[2024-07-09 02:19:53] [indexer:background] Health check
[2024-07-09 02:23:54] [index:background] Health check
[2024-07-09 02:24:24] [indexer:background] Health check
[2024-07-09 02:28:57] [index:background] Health check
[2024-07-09 02:29:17] [indexer:background] Health check
[2024-07-09 02:36:13] [index:background] Health check
[2024-07-09 02:36:13] [indexer:background] Health check
[2024-07-09 02:36:13] [indexer:background] Health check
[2024-07-09 02:42:05] [index:background] Health check
[2024-07-09 02:42:05] [indexer:background] Health check
[2024-07-09 02:42:05] [indexer:background] Health check
[2024-07-09 02:43:50] [index:background] Health check
[2024-07-09 02:44:53] [indexer:background] Health check
[2024-07-09 02:44:53] [indexer:background] CPU load threshold (3) breached: 6.29 [waiting 2]
[2024-07-09 02:49:00] [index:background] Health check
[2024-07-09 02:51:56] [indexer:background] Health check
[2024-07-09 02:54:21] [index:background] Health check
[2024-07-09 02:54:21] [indexer:background] Health check
[2024-07-09 02:54:22] [indexer:background] Health check
[2024-07-09 03:01:05] [index:background] Health check
[2024-07-09 03:01:05] [indexer:background] Health check
[2024-07-09 03:01:06] [indexer:background] Health check
[2024-07-09 03:04:29] [index:background] Health check
[2024-07-09 03:04:29] [indexer:background] Health check
[2024-07-09 03:04:29] [indexer:background] Health check
[2024-07-09 03:10:00] [index:background] Health check
[2024-07-09 03:10:00] [indexer:background] Health check
[2024-07-09 03:10:00] [indexer:background] Health check
[2024-07-09 03:13:46] [index:background] Health check
[2024-07-09 03:14:26] [indexer:background] Health check
[2024-07-09 03:18:53] [index:background] Health check
[2024-07-09 03:19:19] [indexer:background] Health check
[2024-07-09 03:23:59] [index:background] Health check
[2024-07-09 03:25:36] [indexer:background] Health check
[2024-07-09 03:31:13] [index:background] Health check
[2024-07-09 03:31:13] [indexer:background] Health check
[2024-07-09 03:31:13] [indexer:background] Health check
[2024-07-09 03:35:17] [index:background] Health check
[2024-07-09 03:35:17] [indexer:background] Health check
[2024-07-09 03:35:17] [indexer:background] Health check
[2024-07-09 03:40:31] [index:background] Health check
[2024-07-09 03:40:31] [indexer:background] Health check
[2024-07-09 03:40:31] [indexer:background] Health check
[2024-07-09 03:43:58] [index:background] Health check
[2024-07-09 03:45:39] [indexer:background] Health check
[2024-07-09 03:49:13] [index:background] Health check
[2024-07-09 03:49:58] [indexer:background] Health check
[2024-07-09 03:53:41] [index:background] Health check
[2024-07-09 03:54:17] [indexer:background] Health check
[2024-07-09 03:58:42] [index:background] Health check
[2024-07-09 03:59:17] [indexer:background] Health check
[2024-07-09 04:03:42] [index:background] Health check
[2024-07-09 04:04:16] [indexer:background] Health check
[2024-07-09 04:08:43] [index:background] Health check
[2024-07-09 04:09:18] [indexer:background] Health check
[2024-07-09 04:09:18] [indexer:background] CPU load threshold (3) breached: 3.55 [waiting 2]
[2024-07-09 04:13:42] [index:background] Health check
[2024-07-09 04:13:42] [index:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2024-07-09 04:13:44] [indexer:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2024-07-09 04:14:17] [indexer:background] Health check
[2024-07-09 04:14:17] [indexer:background] CPU load threshold (3) breached: 3.41 [waiting 2]
[2024-07-09 04:18:43] [index:background] Health check
[2024-07-09 04:18:43] [index:background] CPU load threshold (3) breached: 4.59 [waiting 2]
[2024-07-09 04:18:45] [indexer:background] CPU load threshold (3) breached: 4.62 [waiting 2]
[2024-07-09 04:19:16] [indexer:background] Health check
[2024-07-09 04:19:16] [indexer:background] CPU load threshold (3) breached: 4.3 [waiting 2]
[2024-07-09 04:23:44] [index:background] Health check
[2024-07-09 04:23:44] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2024-07-09 04:23:46] [indexer:background] CPU load threshold (3) breached: 3.88 [waiting 2]
[2024-07-09 04:24:17] [indexer:background] Health check
[2024-07-09 04:24:17] [indexer:background] CPU load threshold (3) breached: 3.77 [waiting 2]
[2024-07-09 04:28:43] [index:background] Health check
[2024-07-09 04:28:43] [index:background] CPU load threshold (3) breached: 3.95 [waiting 2]
[2024-07-09 04:28:45] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2]
[2024-07-09 04:29:16] [indexer:background] Health check
[2024-07-09 04:29:16] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2024-07-09 04:33:43] [index:background] Health check
[2024-07-09 04:33:43] [index:background] CPU load threshold (3) breached: 4.12 [waiting 2]
[2024-07-09 04:33:45] [indexer:background] CPU load threshold (3) breached: 4.12 [waiting 2]
[2024-07-09 04:34:16] [indexer:background] Health check
[2024-07-09 04:34:16] [indexer:background] CPU load threshold (3) breached: 4.02 [waiting 2]
[2024-07-09 04:38:44] [index:background] Health check
[2024-07-09 04:38:44] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2024-07-09 04:38:46] [indexer:background] CPU load threshold (3) breached: 3.76 [waiting 2]
[2024-07-09 04:39:17] [indexer:background] Health check
[2024-07-09 04:39:17] [indexer:background] CPU load threshold (3) breached: 3.71 [waiting 2]
[2024-07-09 04:43:43] [index:background] Health check
[2024-07-09 04:43:43] [index:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2024-07-09 04:43:46] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2024-07-09 04:44:17] [indexer:background] Health check
[2024-07-09 04:48:43] [index:background] Health check
[2024-07-09 04:48:43] [index:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2024-07-09 04:48:45] [indexer:background] CPU load threshold (3) breached: 3.43 [waiting 2]
[2024-07-09 04:49:18] [indexer:background] Health check
[2024-07-09 04:49:18] [indexer:background] CPU load threshold (3) breached: 3.92 [waiting 2]
[2024-07-09 04:55:21] [index:background] Health check
[2024-07-09 04:55:21] [indexer:background] Health check
[2024-07-09 04:55:21] [indexer:background] Health check
[2024-07-09 04:59:41] [index:background] Health check
[2024-07-09 04:59:41] [indexer:background] Health check
[2024-07-09 04:59:41] [indexer:background] Health check
[2024-07-09 05:04:26] [index:background] Health check
[2024-07-09 05:04:26] [indexer:background] Health check
[2024-07-09 05:04:26] [indexer:background] Health check
[2024-07-09 05:09:09] [index:background] Health check
[2024-07-09 05:11:50] [indexer:background] Health check
[2024-07-09 05:14:04] [index:background] Health check
[2024-07-09 05:18:11] [indexer:background] Health check
[2024-07-09 05:19:13] [index:background] Health check
[2024-07-09 05:19:31] [indexer:background] Health check
[2024-07-09 05:22:59] [query] Query for: 2023
[2024-07-09 05:22:59] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-09 05:22:59] [query] Engine: default
[2024-07-09 05:23:00] [query] Tokens: 2023
[2024-07-09 05:23:00] [query] Mods: 6
[2024-07-09 05:23:01] [query] Found results using: or logic
[2024-07-09 05:23: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
[2024-07-09 05:23:01] [query] Results: 280 Pages of results: 28
[2024-07-09 05:23:01] [query] Execution time: 1.64378
[2024-07-09 05:24:11] [index:background] Health check
[2024-07-09 05:25:08] [indexer:background] Health check
[2024-07-09 05:29:07] [index:background] Health check
[2024-07-09 05:31:56] [indexer:background] Health check
[2024-07-09 05:33:51] [index:background] Health check
[2024-07-09 05:34:17] [indexer:background] Health check
[2024-07-09 05:39:40] [index:background] Health check
[2024-07-09 05:39:40] [indexer:background] Health check
[2024-07-09 05:39:40] [indexer:background] Health check
[2024-07-09 05:45:35] [index:background] Health check
[2024-07-09 05:45:35] [indexer:background] Health check
[2024-07-09 05:45:35] [indexer:background] Health check
[2024-07-09 05:48:51] [index:background] Health check
[2024-07-09 05:50:33] [indexer:background] Health check
[2024-07-09 05:54:01] [index:background] Health check
[2024-07-09 05:55:32] [indexer:background] Health check
[2024-07-09 06:00:50] [index:background] Health check
[2024-07-09 06:00:50] [indexer:background] Health check
[2024-07-09 06:00:50] [indexer:background] Health check
[2024-07-09 06:05:29] [index:background] Health check
[2024-07-09 06:05:29] [indexer:background] Health check
[2024-07-09 06:05:29] [indexer:background] Health check
[2024-07-09 06:08:43] [index:background] Health check
[2024-07-09 06:09:22] [indexer:background] Health check
[2024-07-09 06:15:16] [index:background] Health check
[2024-07-09 06:15:16] [indexer:background] Health check
[2024-07-09 06:15:16] [indexer:background] Health check
[2024-07-09 06:19:16] [index:background] Health check
[2024-07-09 06:19:16] [indexer:background] Health check
[2024-07-09 06:19:16] [indexer:background] Health check
[2024-07-09 06:24:55] [index:background] Health check
[2024-07-09 06:24:55] [indexer:background] Health check
[2024-07-09 06:24:55] [indexer:background] Health check
[2024-07-09 06:29:40] [index:background] Health check
[2024-07-09 06:29:40] [indexer:background] Health check
[2024-07-09 06:29:40] [indexer:background] Health check
[2024-07-09 06:32:37] [query] Query for: 2025
[2024-07-09 06:32:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-09 06:32:37] [query] Engine: default
[2024-07-09 06:32:37] [query] Tokens: 2025
[2024-07-09 06:32:37] [query] Mods: 6
[2024-07-09 06:32:37] [query] Found results using: or logic
[2024-07-09 06:32:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-07-09 06:32:37] [query] Results: 138 Pages of results: 14
[2024-07-09 06:32:37] [query] Execution time: 0.31454
[2024-07-09 06:32:37] [query] Query for: 2025
[2024-07-09 06:32:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-07-09 06:32:37] [query] Engine: default
[2024-07-09 06:32:37] [query] Tokens: 2025
[2024-07-09 06:32:37] [query] Mods: 6
[2024-07-09 06:32:37] [query] Found results using: or logic
[2024-07-09 06:32:37] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-07-09 06:32:37] [query] Results: 138 Pages of results: 2
[2024-07-09 06:32:37] [query] Execution time: 0.16421
[2024-07-09 06:34:51] [index:background] Health check
[2024-07-09 06:34:51] [indexer:background] Health check
[2024-07-09 06:34:51] [indexer:background] Health check
[2024-07-09 06:38:45] [index:background] Health check
[2024-07-09 06:40:03] [indexer:background] Health check
[2024-07-09 06:45:36] [index:background] Health check
[2024-07-09 06:45:36] [indexer:background] Health check
[2024-07-09 06:45:36] [indexer:background] Health check
[2024-07-09 06:50:38] [index:background] Health check
[2024-07-09 06:50:38] [indexer:background] Health check
[2024-07-09 06:50:38] [indexer:background] Health check
[2024-07-09 06:53:43] [index:background] Health check
[2024-07-09 06:54:30] [indexer:background] Health check
[2024-07-09 06:59:24] [index:background] Health check
[2024-07-09 06:59:24] [indexer:background] Health check
[2024-07-09 06:59:24] [indexer:background] Health check
[2024-07-09 07:03:51] [index:background] Health check
[2024-07-09 07:04:44] [indexer:background] Health check
[2024-07-09 07:09:46] [index:background] Health check
[2024-07-09 07:09:46] [indexer:background] Health check
[2024-07-09 07:09:46] [indexer:background] Health check
[2024-07-09 07:18:55] [index:background] Health check
[2024-07-09 07:18:55] [indexer:background] Health check
[2024-07-09 07:18:55] [indexer:background] Health check
[2024-07-09 07:19:24] [indexer:background] Health check
[2024-07-09 07:25:34] [index:background] Health check
[2024-07-09 07:25:34] [indexer:background] Health check
[2024-07-09 07:25:34] [indexer:background] Health check
[2024-07-09 07:28:44] [index:background] Health check
[2024-07-09 07:30:20] [indexer:background] Health check
[2024-07-09 07:34:46] [index:background] Health check
[2024-07-09 07:34:46] [indexer:background] Health check
[2024-07-09 07:34:46] [indexer:background] Health check
[2024-07-09 07:41:43] [index:background] Health check
[2024-07-09 07:41:43] [indexer:background] Health check
[2024-07-09 07:41:43] [indexer:background] Health check
[2024-07-09 07:44:03] [index:background] Health check
[2024-07-09 07:44:34] [indexer:background] Health check
[2024-07-09 07:48:43] [index:background] Health check
[2024-07-09 07:49:21] [indexer:background] Health check
[2024-07-09 07:53:48] [index:background] Health check
[2024-07-09 07:54:54] [indexer:background] Health check
[2024-07-09 07:58:54] [index:background] Health check
[2024-07-09 08:00:53] [indexer:background] Health check
[2024-07-09 08:04:35] [index:background] Health check
[2024-07-09 08:04:35] [indexer:background] Health check
[2024-07-09 08:04:35] [indexer:background] Health check
[2024-07-09 08:09:10] [index:background] Health check
[2024-07-09 08:10:18] [indexer:background] Health check
[2024-07-09 08:14:32] [index:background] Health check
[2024-07-09 08:14:32] [indexer:background] Health check
[2024-07-09 08:14:32] [indexer:background] Health check
[2024-07-09 08:18:44] [index:background] Health check
[2024-07-09 08:19:50] [indexer:background] Health check
[2024-07-09 08:23:52] [index:background] Health check
[2024-07-09 08:24:39] [indexer:background] Health check
[2024-07-09 08:29:00] [index:background] Health check
[2024-07-09 08:29:30] [indexer:background] Health check
[2024-07-09 08:34:39] [index:background] Health check
[2024-07-09 08:34:39] [indexer:background] Health check
[2024-07-09 08:34:39] [indexer:background] Health check
[2024-07-09 08:39:05] [index:background] Health check
[2024-07-09 08:39:43] [indexer:background] Health check
[2024-07-09 08:46:26] [index:background] Health check
[2024-07-09 08:46:26] [indexer:background] Health check
[2024-07-09 08:46:26] [indexer:background] Health check
[2024-07-09 08:48:56] [index:background] Health check
[2024-07-09 08:49:29] [indexer:background] Health check
[2024-07-09 08:55:14] [index:background] Health check
[2024-07-09 08:55:14] [indexer:background] Health check
[2024-07-09 08:55:14] [indexer:background] Health check
[2024-07-09 08:59:41] [index:background] Health check
[2024-07-09 08:59:41] [indexer:background] Health check
[2024-07-09 08:59:41] [indexer:background] Health check
[2024-07-09 09:04:33] [index:background] Health check
[2024-07-09 09:04:33] [indexer:background] Health check
[2024-07-09 09:04:33] [indexer:background] Health check
[2024-07-09 09:08:43] [index:background] Health check
[2024-07-09 09:10:20] [indexer:background] Health check
[2024-07-09 09:13:52] [index:background] Health check
[2024-07-09 09:14:16] [indexer:background] Health check
[2024-07-09 09:19:16] [index:background] Health check
[2024-07-09 09:19:16] [indexer:background] Health check
[2024-07-09 09:19:16] [indexer:background] Health check
[2024-07-09 09:23:54] [index:background] Health check
[2024-07-09 09:25:13] [indexer:background] Health check
[2024-07-09 09:28:52] [index:background] Health check
[2024-07-09 09:29:24] [indexer:background] Health check
[2024-07-09 09:35:35] [index:background] Health check
[2024-07-09 09:35:35] [indexer:background] Health check
[2024-07-09 09:35:35] [indexer:background] Health check
[2024-07-09 09:39:10] [index:background] Health check
[2024-07-09 09:39:29] [indexer:background] Health check
[2024-07-09 09:43:59] [index:background] Health check
[2024-07-09 09:44:50] [indexer:background] Health check
[2024-07-09 09:49:34] [index:background] Health check
[2024-07-09 09:49:34] [indexer:background] Health check
[2024-07-09 09:49:34] [indexer:background] Health check
[2024-07-09 09:53:51] [index:background] Health check
[2024-07-09 09:54:19] [indexer:background] Health check
[2024-07-09 09:59:16] [index:background] Health check
[2024-07-09 09:59:16] [indexer:background] Health check
[2024-07-09 09:59:16] [indexer:background] Health check
[2024-07-09 10:03:48] [index:background] Health check
[2024-07-09 10:04:33] [indexer:background] Health check
[2024-07-09 10:09:10] [index:background] Health check
[2024-07-09 10:10:20] [indexer:background] Health check
[2024-07-09 10:15:30] [index:background] Health check
[2024-07-09 10:15:30] [indexer:background] Health check
[2024-07-09 10:15:30] [indexer:background] Health check
[2024-07-09 10:20:47] [index:background] Health check
[2024-07-09 10:20:47] [indexer:background] Health check
[2024-07-09 10:20:47] [indexer:background] Health check
[2024-07-09 10:23:50] [index:background] Health check
[2024-07-09 10:24:36] [indexer:background] Health check
[2024-07-09 10:28:59] [index:background] Health check
[2024-07-09 10:29:21] [indexer:background] Health check
[2024-07-09 10:33:44] [index:background] Health check
[2024-07-09 10:35:37] [indexer:background] Health check
[2024-07-09 10:39:00] [index:background] Health check
[2024-07-09 10:39:23] [indexer:background] Health check
[2024-07-09 10:44:32] [index:background] Health check
[2024-07-09 10:44:32] [indexer:background] Health check
[2024-07-09 10:44:32] [indexer:background] Health check
[2024-07-09 10:49:15] [index:background] Health check
[2024-07-09 10:49:15] [indexer:background] Health check
[2024-07-09 10:49:15] [indexer:background] Health check
[2024-07-09 10:53:55] [index:background] Health check
[2024-07-09 10:54:16] [indexer:background] Health check
[2024-07-09 10:59:00] [index:background] Health check
[2024-07-09 10:59:28] [indexer:background] Health check
[2024-07-09 11:04:52] [index:background] Health check
[2024-07-09 11:04:52] [indexer:background] Health check
[2024-07-09 11:04:52] [indexer:background] Health check
[2024-07-09 11:09:02] [index:background] Health check
[2024-07-09 11:11:05] [indexer:background] Health check
[2024-07-09 11:14:20] [index:background] Health check
[2024-07-09 11:14:20] [indexer:background] Health check
[2024-07-09 11:14:20] [indexer:background] Health check
[2024-07-09 11:19:16] [index:background] Health check
[2024-07-09 11:19:16] [indexer:background] Health check
[2024-07-09 11:19:16] [indexer:background] Health check
[2024-07-09 11:23:41] [index:background] Health check
[2024-07-09 11:25:12] [indexer:background] Health check
[2024-07-09 11:29:59] [index:background] Health check
[2024-07-09 11:29:59] [indexer:background] Health check
[2024-07-09 11:29:59] [indexer:background] Health check
[2024-07-09 11:33:59] [index:background] Health check
[2024-07-09 11:34:30] [indexer:background] Health check
[2024-07-09 11:38:55] [index:background] Health check
[2024-07-09 11:39:57] [indexer:background] Health check
[2024-07-09 11:44:57] [index:background] Health check
[2024-07-09 11:44:57] [indexer:background] Health check
[2024-07-09 11:44:57] [indexer:background] Health check
[2024-07-09 11:49:09] [index:background] Health check
[2024-07-09 11:50:15] [indexer:background] Health check
[2024-07-09 11:54:20] [index:background] Health check
[2024-07-09 11:54:21] [indexer:background] Health check
[2024-07-09 11:54:21] [indexer:background] Health check
[2024-07-09 11:59:21] [index:background] Health check
[2024-07-09 11:59:21] [indexer:background] Health check
[2024-07-09 11:59:22] [indexer:background] Health check
[2024-07-09 12:02:08] [query] Query for: 2024
[2024-07-09 12:02:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-09 12:02:08] [query] Engine: default
[2024-07-09 12:02:09] [query] Tokens: 2024
[2024-07-09 12:02:09] [query] Mods: 6
[2024-07-09 12:02:09] [query] Found results using: or logic
[2024-07-09 12:02:09] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-07-09 12:02:09] [query] Results: 159 Pages of results: 16
[2024-07-09 12:02:09] [query] Execution time: 0.63459
[2024-07-09 12:02:09] [query] Query for: 2024
[2024-07-09 12:02:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-07-09 12:02:09] [query] Engine: default
[2024-07-09 12:02:09] [query] Tokens: 2024
[2024-07-09 12:02:09] [query] Mods: 6
[2024-07-09 12:02:09] [query] Found results using: or logic
[2024-07-09 12:02:09] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-07-09 12:02:09] [query] Results: 159 Pages of results: 2
[2024-07-09 12:02:09] [query] Execution time: 0.15011
[2024-07-09 12:03:49] [index:background] Health check
[2024-07-09 12:06:52] [indexer:background] Health check
[2024-07-09 12:09:05] [index:background] Health check
[2024-07-09 12:10:09] [indexer:background] Health check
[2024-07-09 12:14:33] [index:background] Health check
[2024-07-09 12:14:33] [indexer:background] Health check
[2024-07-09 12:14:33] [indexer:background] Health check
[2024-07-09 12:18:52] [index:background] Health check
[2024-07-09 12:19:24] [indexer:background] Health check
[2024-07-09 12:23:46] [index:background] Health check
[2024-07-09 12:24:30] [indexer:background] Health check
[2024-07-09 12:29:41] [index:background] Health check
[2024-07-09 12:29:41] [indexer:background] Health check
[2024-07-09 12:29:42] [indexer:background] Health check
[2024-07-09 12:34:42] [index:background] Health check
[2024-07-09 12:34:43] [indexer:background] Health check
[2024-07-09 12:34:43] [indexer:background] Health check
[2024-07-09 12:38:53] [index:background] Health check
[2024-07-09 12:39:43] [indexer:background] Health check
[2024-07-09 12:43:56] [index:background] Health check
[2024-07-09 12:45:28] [indexer:background] Health check
[2024-07-09 12:48:43] [index:background] Health check
[2024-07-09 12:49:28] [indexer:background] Health check
[2024-07-09 12:53:44] [index:background] Health check
[2024-07-09 12:54:33] [indexer:background] Health check
[2024-07-09 12:59:55] [index:background] Health check
[2024-07-09 12:59:55] [indexer:background] Health check
[2024-07-09 12:59:55] [indexer:background] Health check
[2024-07-09 13:04:07] [index:background] Health check
[2024-07-09 13:04:42] [indexer:background] Health check
[2024-07-09 13:08:43] [index:background] Health check
[2024-07-09 13:09:26] [indexer:background] Health check
[2024-07-09 13:14:29] [index:background] Health check
[2024-07-09 13:14:29] [indexer:background] Health check
[2024-07-09 13:14:29] [indexer:background] Health check
[2024-07-09 13:19:02] [index:background] Health check
[2024-07-09 13:19:48] [indexer:background] Health check
[2024-07-09 13:28:17] [index:background] Health check
[2024-07-09 13:28:17] [indexer:background] Health check
[2024-07-09 13:28:17] [indexer:background] Health check
[2024-07-09 13:28:55] [index:background] Health check
[2024-07-09 13:29:51] [indexer:background] Health check
[2024-07-09 13:34:03] [index:background] Health check
[2024-07-09 13:36:03] [indexer:background] Health check
[2024-07-09 13:39:43] [index:background] Health check
[2024-07-09 13:39:43] [indexer:background] Health check
[2024-07-09 13:39:43] [indexer:background] Health check
[2024-07-09 13:44:01] [index:background] Health check
[2024-07-09 13:44:25] [indexer:background] Health check
[2024-07-09 13:48:45] [index:background] Health check
[2024-07-09 13:49:42] [indexer:background] Health check
[2024-07-09 13:53:57] [index:background] Health check
[2024-07-09 13:54:42] [indexer:background] Health check
[2024-07-09 13:58:49] [index:background] Health check
[2024-07-09 13:59:55] [indexer:background] Health check
[2024-07-09 14:03:48] [index:background] Health check
[2024-07-09 14:04:23] [indexer:background] Health check
[2024-07-09 14:09:16] [index:background] Health check
[2024-07-09 14:09:16] [indexer:background] Health check
[2024-07-09 14:09:16] [indexer:background] Health check
[2024-07-09 14:13:45] [index:background] Health check
[2024-07-09 14:14:48] [indexer:background] Health check
[2024-07-09 14:20:21] [index:background] Health check
[2024-07-09 14:20:21] [indexer:background] Health check
[2024-07-09 14:20:21] [indexer:background] Health check
[2024-07-09 14:23:49] [index:background] Health check
[2024-07-09 14:25:01] [indexer:background] Health check
[2024-07-09 14:29:43] [index:background] Health check
[2024-07-09 14:29:43] [indexer:background] Health check
[2024-07-09 14:29:43] [indexer:background] Health check
[2024-07-09 14:33:53] [index:background] Health check
[2024-07-09 14:34:23] [indexer:background] Health check
[2024-07-09 14:39:10] [index:background] Health check
[2024-07-09 14:40:14] [indexer:background] Health check
[2024-07-09 14:43:46] [index:background] Health check
[2024-07-09 14:44:27] [indexer:background] Health check
[2024-07-09 14:49:08] [index:background] Health check
[2024-07-09 14:51:22] [indexer:background] Health check
[2024-07-09 14:54:19] [index:background] Health check
[2024-07-09 14:54:19] [indexer:background] Health check
[2024-07-09 14:54:19] [indexer:background] Health check
[2024-07-09 14:58:45] [index:background] Health check
[2024-07-09 14:59:42] [indexer:background] Health check
[2024-07-09 15:04:21] [index:background] Health check
[2024-07-09 15:04:21] [indexer:background] Health check
[2024-07-09 15:04:21] [indexer:background] Health check
[2024-07-09 15:08:43] [index:background] Health check
[2024-07-09 15:09:20] [indexer:background] Health check
[2024-07-09 15:14:45] [index:background] Health check
[2024-07-09 15:14:45] [indexer:background] Health check
[2024-07-09 15:14:45] [indexer:background] Health check
[2024-07-09 15:18:41] [index:background] Health check
[2024-07-09 15:20:08] [indexer:background] Health check
[2024-07-09 15:23:43] [index:background] Health check
[2024-07-09 15:25:04] [indexer:background] Health check
[2024-07-09 15:29:34] [index:background] Health check
[2024-07-09 15:29:34] [indexer:background] Health check
[2024-07-09 15:29:34] [indexer:background] Health check
[2024-07-09 15:34:15] [index:background] Health check
[2024-07-09 15:34:15] [indexer:background] Health check
[2024-07-09 15:34:15] [indexer:background] Health check
[2024-07-09 15:38:45] [index:background] Health check
[2024-07-09 15:39:42] [indexer:background] Health check
[2024-07-09 15:43:48] [index:background] Health check
[2024-07-09 15:45:01] [indexer:background] Health check
[2024-07-09 15:48:59] [index:background] Health check
[2024-07-09 15:51:04] [indexer:background] Health check
[2024-07-09 15:54:04] [index:background] Health check
[2024-07-09 15:54:27] [indexer:background] Health check
[2024-07-09 16:00:42] [index:background] Health check
[2024-07-09 16:00:42] [indexer:background] Health check
[2024-07-09 16:00:42] [indexer:background] Health check
[2024-07-09 16:03:46] [index:background] Health check
[2024-07-09 16:05:34] [indexer:background] Health check
[2024-07-09 16:10:52] [index:background] Health check
[2024-07-09 16:10:52] [indexer:background] Health check
[2024-07-09 16:10:52] [indexer:background] Health check
[2024-07-09 16:13:56] [index:background] Health check
[2024-07-09 16:14:24] [indexer:background] Health check
[2024-07-09 16:19:01] [index:background] Health check
[2024-07-09 16:19:31] [indexer:background] Health check
[2024-07-09 16:25:32] [index:background] Health check
[2024-07-09 16:25:32] [indexer:background] Health check
[2024-07-09 16:25:32] [indexer:background] Health check
[2024-07-09 16:30:50] [index:background] Health check
[2024-07-09 16:30:50] [indexer:background] Health check
[2024-07-09 16:30:50] [indexer:background] Health check
[2024-07-09 16:34:31] [index:background] Health check
[2024-07-09 16:34:31] [indexer:background] Health check
[2024-07-09 16:34:31] [indexer:background] Health check
[2024-07-09 16:39:23] [index:background] Health check
[2024-07-09 16:39:23] [indexer:background] Health check
[2024-07-09 16:39:23] [indexer:background] Health check
[2024-07-09 16:43:43] [index:background] Health check
[2024-07-09 16:44:39] [indexer:background] Health check
[2024-07-09 16:51:06] [index:background] Health check
[2024-07-09 16:51:06] [indexer:background] Health check
[2024-07-09 16:51:07] [indexer:background] Health check
[2024-07-09 16:53:54] [index:background] Health check
[2024-07-09 16:54:20] [indexer:background] Health check
[2024-07-09 16:58:41] [index:background] Health check
[2024-07-09 16:59:17] [indexer:background] Health check
[2024-07-09 17:03:43] [index:background] Health check
[2024-07-09 17:04:18] [indexer:background] Health check
[2024-07-09 17:09:27] [index:background] Health check
[2024-07-09 17:09:27] [indexer:background] Health check
[2024-07-09 17:09:27] [indexer:background] Health check
[2024-07-09 17:17:17] [index:background] Health check
[2024-07-09 17:17:17] [indexer:background] Health check
[2024-07-09 17:17:17] [indexer:background] Health check
[2024-07-09 17:19:30] [index:background] Health check
[2024-07-09 17:19:30] [indexer:background] Health check
[2024-07-09 17:19:30] [indexer:background] Health check
[2024-07-09 17:23:54] [index:background] Health check
[2024-07-09 17:26:24] [indexer:background] Health check
[2024-07-09 17:29:53] [index:background] Health check
[2024-07-09 17:29:53] [indexer:background] Health check
[2024-07-09 17:29:53] [indexer:background] Health check
[2024-07-09 17:34:23] [index:background] Health check
[2024-07-09 17:34:23] [indexer:background] Health check
[2024-07-09 17:34:23] [indexer:background] Health check
[2024-07-09 17:40:42] [index:background] Health check
[2024-07-09 17:40:42] [indexer:background] Health check
[2024-07-09 17:40:42] [indexer:background] Health check
[2024-07-09 17:43:43] [index:background] Health check
[2024-07-09 17:44:36] [indexer:background] Health check
[2024-07-09 17:49:16] [index:background] Health check
[2024-07-09 17:49:16] [indexer:background] Health check
[2024-07-09 17:49:16] [indexer:background] Health check
[2024-07-09 17:53:53] [index:background] Health check
[2024-07-09 17:55:19] [indexer:background] Health check
[2024-07-09 17:59:09] [index:background] Health check
[2024-07-09 18:01:20] [indexer:background] Health check
[2024-07-09 18:08:28] [index:background] Health check
[2024-07-09 18:08:28] [indexer:background] Health check
[2024-07-09 18:08:28] [indexer:background] Health check
[2024-07-09 18:08:49] [index:background] Health check
[2024-07-09 18:09:44] [indexer:background] Health check
[2024-07-09 18:17:14] [index:background] Health check
[2024-07-09 18:17:14] [indexer:background] Health check
[2024-07-09 18:17:14] [indexer:background] Health check
[2024-07-09 18:18:43] [index:background] Health check
[2024-07-09 18:20:09] [indexer:background] Health check
[2024-07-09 18:23:48] [index:background] Health check
[2024-07-09 18:25:41] [indexer:background] Health check
[2024-07-09 18:29:02] [index:background] Health check
[2024-07-09 18:32:09] [indexer:background] Health check
[2024-07-09 18:33:56] [index:background] Health check
[2024-07-09 18:35:10] [indexer:background] Health check
[2024-07-09 18:38:49] [index:background] Health check
[2024-07-09 18:40:45] [indexer:background] Health check
[2024-07-09 18:44:14] [index:background] Health check
[2024-07-09 18:44:17] [indexer:background] Health check
[2024-07-09 18:49:09] [index:background] Health check
[2024-07-09 18:53:32] [indexer:background] Health check
[2024-07-09 18:54:14] [index:background] Health check
[2024-07-09 18:54:40] [indexer:background] Health check
[2024-07-09 18:59:21] [index:background] Health check
[2024-07-09 18:59:21] [indexer:background] Health check
[2024-07-09 18:59:21] [indexer:background] Health check
[2024-07-09 19:04:47] [index:background] Health check
[2024-07-09 19:04:47] [indexer:background] Health check
[2024-07-09 19:04:47] [indexer:background] Health check
[2024-07-09 19:09:46] [index:background] Health check
[2024-07-09 19:09:46] [indexer:background] Health check
[2024-07-09 19:09:46] [indexer:background] Health check
[2024-07-09 19:14:58] [index:background] Health check
[2024-07-09 19:14:58] [indexer:background] Health check
[2024-07-09 19:14:58] [indexer:background] Health check
[2024-07-09 19:19:05] [index:background] Health check
[2024-07-09 19:20:18] [indexer:background] Health check
[2024-07-09 19:24:13] [index:background] Health check
[2024-07-09 19:25:08] [indexer:background] Health check
[2024-07-09 19:29:41] [index:background] Health check
[2024-07-09 19:29:42] [indexer:background] Health check
[2024-07-09 19:29:42] [indexer:background] Health check
[2024-07-09 19:34:34] [index:background] Health check
[2024-07-09 19:34:34] [indexer:background] Health check
[2024-07-09 19:34:34] [indexer:background] Health check
[2024-07-09 19:40:11] [index:background] Health check
[2024-07-09 19:40:11] [indexer:background] Health check
[2024-07-09 19:40:11] [indexer:background] Health check
[2024-07-09 19:44:07] [index:background] Health check
[2024-07-09 19:48:37] [indexer:background] Health check
[2024-07-09 19:48:57] [index:background] Health check
[2024-07-09 19:49:32] [indexer:background] Health check
[2024-07-09 19:54:30] [index:background] Health check
[2024-07-09 19:54:30] [indexer:background] Health check
[2024-07-09 19:54:30] [indexer:background] Health check
[2024-07-09 20:00:43] [index:background] Health check
[2024-07-09 20:00:43] [indexer:background] Health check
[2024-07-09 20:00:43] [indexer:background] Health check
[2024-07-09 20:04:40] [index:background] Health check
[2024-07-09 20:04:40] [indexer:background] Health check
[2024-07-09 20:04:40] [indexer:background] Health check
[2024-07-09 20:08:54] [index:background] Health check
[2024-07-09 20:10:17] [indexer:background] Health check
[2024-07-09 20:17:08] [index:background] Health check
[2024-07-09 20:17:08] [indexer:background] Health check
[2024-07-09 20:17:08] [indexer:background] Health check
[2024-07-09 20:18:43] [index:background] Health check
[2024-07-09 20:21:54] [indexer:background] Health check
[2024-07-09 20:25:24] [index:background] Health check
[2024-07-09 20:25:24] [indexer:background] Health check
[2024-07-09 20:25:24] [indexer:background] Health check
[2024-07-09 20:30:28] [index:background] Health check
[2024-07-09 20:30:29] [indexer:background] Health check
[2024-07-09 20:30:29] [indexer:background] Health check
[2024-07-09 20:33:47] [index:background] Health check
[2024-07-09 20:35:57] [indexer:background] Health check
[2024-07-09 20:39:35] [index:background] Health check
[2024-07-09 20:39:35] [indexer:background] Health check
[2024-07-09 20:39:35] [indexer:background] Health check
[2024-07-09 20:44:48] [index:background] Health check
[2024-07-09 20:44:48] [indexer:background] Health check
[2024-07-09 20:44:48] [indexer:background] Health check
[2024-07-09 20:50:12] [index:background] Health check
[2024-07-09 20:50:12] [indexer:background] Health check
[2024-07-09 20:50:12] [indexer:background] Health check
[2024-07-09 20:55:14] [index:background] Health check
[2024-07-09 20:55:14] [indexer:background] Health check
[2024-07-09 20:55:14] [indexer:background] Health check
[2024-07-09 20:59:04] [index:background] Health check
[2024-07-09 21:00:51] [indexer:background] Health check
[2024-07-09 21:04:09] [index:background] Health check
[2024-07-09 21:04:24] [indexer:background] Health check
[2024-07-09 21:08:48] [index:background] Health check
[2024-07-09 21:10:14] [indexer:background] Health check
[2024-07-09 21:14:50] [index:background] Health check
[2024-07-09 21:14:50] [indexer:background] Health check
[2024-07-09 21:14:50] [indexer:background] Health check
[2024-07-09 21:19:35] [index:background] Health check
[2024-07-09 21:19:35] [indexer:background] Health check
[2024-07-09 21:19:35] [indexer:background] Health check
[2024-07-09 21:24:23] [index:background] Health check
[2024-07-09 21:24:23] [indexer:background] Health check
[2024-07-09 21:24:23] [indexer:background] Health check
[2024-07-09 21:29:03] [index:background] Health check
[2024-07-09 21:29:18] [indexer:background] Health check
[2024-07-09 21:34:34] [index:background] Health check
[2024-07-09 21:34:34] [indexer:background] Health check
[2024-07-09 21:34:34] [indexer:background] Health check
[2024-07-09 21:39:00] [index:background] Health check
[2024-07-09 21:39:43] [indexer:background] Health check
[2024-07-09 21:44:01] [index:background] Health check
[2024-07-09 21:45:04] [indexer:background] Health check
[2024-07-09 21:49:16] [index:background] Health check
[2024-07-09 21:49:16] [indexer:background] Health check
[2024-07-09 21:49:16] [indexer:background] Health check
[2024-07-09 21:54:10] [index:background] Health check
[2024-07-09 21:54:39] [indexer:background] Health check
[2024-07-09 22:00:47] [index:background] Health check
[2024-07-09 22:00:47] [indexer:background] Health check
[2024-07-09 22:00:47] [indexer:background] Health check
[2024-07-09 22:04:33] [index:background] Health check
[2024-07-09 22:04:33] [indexer:background] Health check
[2024-07-09 22:04:33] [indexer:background] Health check
[2024-07-09 22:08:56] [index:background] Health check
[2024-07-09 22:09:38] [indexer:background] Health check
[2024-07-09 22:15:25] [index:background] Health check
[2024-07-09 22:15:25] [indexer:background] Health check
[2024-07-09 22:15:25] [indexer:background] Health check
[2024-07-09 22:17:58] [query] Query for: 2023
[2024-07-09 22:17:58] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-09 22:17:58] [query] Engine: default
[2024-07-09 22:18:00] [query] Tokens: 2023
[2024-07-09 22:18:00] [query] Mods: 6
[2024-07-09 22:18:01] [query] Found results using: or logic
[2024-07-09 22:18: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
[2024-07-09 22:18:01] [query] Results: 280 Pages of results: 28
[2024-07-09 22:18:01] [query] Execution time: 2.20404
[2024-07-09 22:18:50] [index:background] Health check
[2024-07-09 22:18:50] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-07-09 22:18:52] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-07-09 22:20:17] [indexer:background] Health check
[2024-07-09 22:25:28] [index:background] Health check
[2024-07-09 22:25:28] [indexer:background] Health check
[2024-07-09 22:25:28] [indexer:background] Health check
[2024-07-09 22:29:22] [index:background] Health check
[2024-07-09 22:29:22] [indexer:background] Health check
[2024-07-09 22:29:22] [indexer:background] Health check
[2024-07-09 22:33:50] [index:background] Health check
[2024-07-09 22:34:35] [indexer:background] Health check
[2024-07-09 22:39:06] [index:background] Health check
[2024-07-09 22:39:36] [indexer:background] Health check
[2024-07-09 22:45:40] [index:background] Health check
[2024-07-09 22:45:40] [indexer:background] Health check
[2024-07-09 22:45:40] [indexer:background] Health check
[2024-07-09 22:50:35] [index:background] Health check
[2024-07-09 22:50:35] [indexer:background] Health check
[2024-07-09 22:50:35] [indexer:background] Health check
[2024-07-09 22:54:27] [index:background] Health check
[2024-07-09 22:54:27] [indexer:background] Health check
[2024-07-09 22:54:27] [indexer:background] Health check
[2024-07-09 22:58:51] [index:background] Health check
[2024-07-09 22:59:42] [indexer:background] Health check
[2024-07-09 23:05:07] [index:background] Health check
[2024-07-09 23:05:07] [indexer:background] Health check
[2024-07-09 23:05:07] [indexer:background] Health check
[2024-07-09 23:09:12] [index:background] Health check
[2024-07-09 23:10:01] [indexer:background] Health check
[2024-07-09 23:13:47] [index:background] Health check
[2024-07-09 23:15:02] [indexer:background] Health check
[2024-07-09 23:21:29] [index:background] Health check
[2024-07-09 23:21:30] [indexer:background] Health check
[2024-07-09 23:21:30] [indexer:background] Health check
[2024-07-09 23:23:41] [index:background] Health check
[2024-07-09 23:25:04] [indexer:background] Health check
[2024-07-09 23:30:43] [index:background] Health check
[2024-07-09 23:30:43] [indexer:background] Health check
[2024-07-09 23:30:43] [indexer:background] Health check
[2024-07-09 23:35:02] [index:background] Health check
[2024-07-09 23:35:02] [indexer:background] Health check
[2024-07-09 23:35:03] [indexer:background] Health check
[2024-07-09 23:38:59] [index:background] Health check
[2024-07-09 23:39:18] [indexer:background] Health check
[2024-07-09 23:43:43] [index:background] Health check
[2024-07-09 23:45:29] [indexer:background] Health check
[2024-07-09 23:49:39] [index:background] Health check
[2024-07-09 23:49:39] [indexer:background] Health check
[2024-07-09 23:49:39] [indexer:background] Health check
[2024-07-09 23:55:37] [index:background] Health check
[2024-07-09 23:55:37] [indexer:background] Health check
[2024-07-09 23:55:37] [indexer:background] Health check
[2024-07-09 23:59:12] [index:background] Health check
[2024-07-09 23:59:20] [indexer:background] Health check