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