[2024-07-10 00:03:51] [index:background] Health check [2024-07-10 00:04:44] [indexer:background] Health check [2024-07-10 00:08:49] [index:background] Health check [2024-07-10 00:10:09] [indexer:background] Health check [2024-07-10 00:15:16] [index:background] Health check [2024-07-10 00:15:17] [indexer:background] Health check [2024-07-10 00:15:17] [indexer:background] Health check [2024-07-10 00:16:12] [query] Query for: 2023 [2024-07-10 00:16:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 00:16:12] [query] Engine: default [2024-07-10 00:16:12] [query] Tokens: 2023 [2024-07-10 00:16:12] [query] Mods: 6 [2024-07-10 00:16:13] [query] Found results using: or logic [2024-07-10 00:16:13] [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-10 00:16:13] [query] Results: 280 Pages of results: 28 [2024-07-10 00:16:13] [query] Execution time: 0.80700 [2024-07-10 00:18:41] [index:background] Health check [2024-07-10 00:20:52] [indexer:background] Health check [2024-07-10 00:22:43] [query] Query for: 2023 [2024-07-10 00:22:43] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 00:22:43] [query] Engine: default [2024-07-10 00:22:43] [query] Tokens: 2023 [2024-07-10 00:22:43] [query] Mods: 6 [2024-07-10 00:22:43] [query] Found results using: or logic [2024-07-10 00:22:43] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-10 00:22:43] [query] Results: 280 Pages of results: 28 [2024-07-10 00:22:43] [query] Execution time: 0.16998 [2024-07-10 00:24:56] [index:background] Health check [2024-07-10 00:24:56] [indexer:background] Health check [2024-07-10 00:24:56] [indexer:background] Health check [2024-07-10 00:28:43] [index:background] Health check [2024-07-10 00:30:58] [indexer:background] Health check [2024-07-10 00:34:59] [index:background] Health check [2024-07-10 00:34:59] [indexer:background] Health check [2024-07-10 00:34:59] [indexer:background] Health check [2024-07-10 00:39:14] [index:background] Health check [2024-07-10 00:39:31] [indexer:background] Health check [2024-07-10 00:43:44] [index:background] Health check [2024-07-10 00:44:18] [indexer:background] Health check [2024-07-10 00:48:47] [index:background] Health check [2024-07-10 00:49:32] [indexer:background] Health check [2024-07-10 00:58:01] [index:background] Health check [2024-07-10 00:58:01] [indexer:background] Health check [2024-07-10 00:58:01] [indexer:background] Health check [2024-07-10 00:59:13] [index:background] Health check [2024-07-10 01:00:07] [indexer:background] Health check [2024-07-10 01:04:18] [index:background] Health check [2024-07-10 01:04:18] [indexer:background] Health check [2024-07-10 01:04:18] [indexer:background] Health check [2024-07-10 01:12:17] [index:background] Health check [2024-07-10 01:12:17] [indexer:background] Health check [2024-07-10 01:12:17] [indexer:background] Health check [2024-07-10 01:13:42] [index:background] Health check [2024-07-10 01:15:09] [indexer:background] Health check [2024-07-10 01:18:52] [index:background] Health check [2024-07-10 01:19:42] [indexer:background] Health check [2024-07-10 01:24:05] [index:background] Health check [2024-07-10 01:25:39] [indexer:background] Health check [2024-07-10 01:29:59] [index:background] Health check [2024-07-10 01:29:59] [indexer:background] Health check [2024-07-10 01:29:59] [indexer:background] Health check [2024-07-10 01:33:46] [index:background] Health check [2024-07-10 01:34:17] [indexer:background] Health check [2024-07-10 01:38:50] [index:background] Health check [2024-07-10 01:39:22] [indexer:background] Health check [2024-07-10 01:43:47] [index:background] Health check [2024-07-10 01:44:20] [indexer:background] Health check [2024-07-10 01:48:55] [index:background] Health check [2024-07-10 01:49:19] [indexer:background] Health check [2024-07-10 01:55:32] [index:background] Health check [2024-07-10 01:55:32] [indexer:background] Health check [2024-07-10 01:55:32] [indexer:background] Health check [2024-07-10 01:59:17] [index:background] Health check [2024-07-10 01:59:17] [indexer:background] Health check [2024-07-10 01:59:17] [indexer:background] Health check [2024-07-10 02:04:49] [index:background] Health check [2024-07-10 02:04:49] [indexer:background] Health check [2024-07-10 02:04:50] [indexer:background] Health check [2024-07-10 02:08:50] [index:background] Health check [2024-07-10 02:09:31] [indexer:background] Health check [2024-07-10 02:14:17] [index:background] Health check [2024-07-10 02:14:17] [indexer:background] Health check [2024-07-10 02:14:17] [indexer:background] Health check [2024-07-10 02:20:51] [index:background] Health check [2024-07-10 02:20:51] [indexer:background] Health check [2024-07-10 02:20:51] [indexer:background] Health check [2024-07-10 02:23:42] [index:background] Health check [2024-07-10 02:24:47] [indexer:background] Health check [2024-07-10 02:29:39] [index:background] Health check [2024-07-10 02:29:39] [indexer:background] Health check [2024-07-10 02:29:39] [indexer:background] Health check [2024-07-10 02:33:43] [index:background] Health check [2024-07-10 02:35:00] [indexer:background] Health check [2024-07-10 02:39:09] [index:background] Health check [2024-07-10 02:40:14] [indexer:background] Health check [2024-07-10 02:43:48] [index:background] Health check [2024-07-10 02:44:19] [indexer:background] Health check [2024-07-10 02:48:45] [index:background] Health check [2024-07-10 02:51:59] [indexer:background] Health check [2024-07-10 02:51:59] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2] [2024-07-10 02:54:25] [index:background] Health check [2024-07-10 02:54:25] [indexer:background] Health check [2024-07-10 02:54:25] [indexer:background] Health check [2024-07-10 03:00:32] [index:background] Health check [2024-07-10 03:00:32] [indexer:background] Health check [2024-07-10 03:00:32] [indexer:background] Health check [2024-07-10 03:05:14] [index:background] Health check [2024-07-10 03:05:14] [indexer:background] Health check [2024-07-10 03:05:14] [indexer:background] Health check [2024-07-10 03:08:51] [index:background] Health check [2024-07-10 03:09:17] [indexer:background] Health check [2024-07-10 03:13:47] [index:background] Health check [2024-07-10 03:14:37] [indexer:background] Health check [2024-07-10 03:19:41] [index:background] Health check [2024-07-10 03:19:41] [indexer:background] Health check [2024-07-10 03:19:41] [indexer:background] Health check [2024-07-10 03:23:45] [index:background] Health check [2024-07-10 03:24:27] [indexer:background] Health check [2024-07-10 03:24:27] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2] [2024-07-10 03:29:07] [index:background] Health check [2024-07-10 03:29:28] [indexer:background] Health check [2024-07-10 03:34:27] [index:background] Health check [2024-07-10 03:34:27] [indexer:background] Health check [2024-07-10 03:34:27] [indexer:background] Health check [2024-07-10 03:39:00] [index:background] Health check [2024-07-10 03:39:18] [indexer:background] Health check [2024-07-10 03:44:49] [index:background] Health check [2024-07-10 03:44:50] [indexer:background] Health check [2024-07-10 03:44:50] [indexer:background] Health check [2024-07-10 03:48:50] [index:background] Health check [2024-07-10 03:49:17] [indexer:background] Health check [2024-07-10 03:54:52] [index:background] Health check [2024-07-10 03:54:52] [indexer:background] Health check [2024-07-10 03:54:52] [indexer:background] Health check [2024-07-10 03:58:47] [index:background] Health check [2024-07-10 03:59:23] [indexer:background] Health check [2024-07-10 04:03:46] [index:background] Health check [2024-07-10 04:04:45] [indexer:background] Health check [2024-07-10 04:09:31] [index:background] Health check [2024-07-10 04:09:32] [indexer:background] Health check [2024-07-10 04:09:32] [indexer:background] Health check [2024-07-10 04:13:31] [query] Query for: 2024 [2024-07-10 04:13:31] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 04:13:31] [query] Engine: default [2024-07-10 04:13:32] [query] Tokens: 2024 [2024-07-10 04:13:32] [query] Mods: 6 [2024-07-10 04:13:33] [query] Found results using: or logic [2024-07-10 04:13:33] [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-10 04:13:33] [query] Results: 159 Pages of results: 16 [2024-07-10 04:13:33] [query] Execution time: 1.34923 [2024-07-10 04:15:21] [index:background] Health check [2024-07-10 04:15:21] [indexer:background] Health check [2024-07-10 04:15:21] [indexer:background] Health check [2024-07-10 04:19:15] [index:background] Health check [2024-07-10 04:19:15] [indexer:background] Health check [2024-07-10 04:19:15] [indexer:background] Health check [2024-07-10 04:23:46] [index:background] Health check [2024-07-10 04:24:57] [indexer:background] Health check [2024-07-10 04:28:51] [index:background] Health check [2024-07-10 04:29:39] [indexer:background] Health check [2024-07-10 04:33:49] [index:background] Health check [2024-07-10 04:35:35] [indexer:background] Health check [2024-07-10 04:39:23] [index:background] Health check [2024-07-10 04:39:23] [indexer:background] Health check [2024-07-10 04:39:23] [indexer:background] Health check [2024-07-10 04:44:35] [index:background] Health check [2024-07-10 04:44:35] [indexer:background] Health check [2024-07-10 04:44:35] [indexer:background] Health check [2024-07-10 04:48:50] [index:background] Health check [2024-07-10 04:49:19] [indexer:background] Health check [2024-07-10 04:53:45] [index:background] Health check [2024-07-10 04:55:09] [indexer:background] Health check [2024-07-10 04:58:50] [index:background] Health check [2024-07-10 04:59:25] [indexer:background] Health check [2024-07-10 05:03:49] [index:background] Health check [2024-07-10 05:04:57] [indexer:background] Health check [2024-07-10 05:08:50] [index:background] Health check [2024-07-10 05:10:37] [indexer:background] Health check [2024-07-10 05:13:49] [index:background] Health check [2024-07-10 05:14:17] [indexer:background] Health check [2024-07-10 05:17:08] [query] Query for: 2024 [2024-07-10 05:17:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 05:17:08] [query] Engine: default [2024-07-10 05:17:09] [query] Tokens: 2024 [2024-07-10 05:17:09] [query] Mods: 6 [2024-07-10 05:17:09] [query] Found results using: or logic [2024-07-10 05:17: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-10 05:17:09] [query] Results: 159 Pages of results: 16 [2024-07-10 05:17:09] [query] Execution time: 1.04648 [2024-07-10 05:17:09] [query] Query for: 2024 [2024-07-10 05:17:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-07-10 05:17:09] [query] Engine: default [2024-07-10 05:17:09] [query] Tokens: 2024 [2024-07-10 05:17:09] [query] Mods: 6 [2024-07-10 05:17:09] [query] Found results using: or logic [2024-07-10 05:17: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-10 05:17:09] [query] Results: 159 Pages of results: 2 [2024-07-10 05:17:09] [query] Execution time: 0.17972 [2024-07-10 05:18:49] [index:background] Health check [2024-07-10 05:19:26] [indexer:background] Health check [2024-07-10 05:23:47] [index:background] Health check [2024-07-10 05:24:20] [indexer:background] Health check [2024-07-10 05:32:10] [index:background] Health check [2024-07-10 05:32:10] [indexer:background] Health check [2024-07-10 05:32:10] [indexer:background] Health check [2024-07-10 05:33:55] [index:background] Health check [2024-07-10 05:34:55] [indexer:background] Health check [2024-07-10 05:40:03] [index:background] Health check [2024-07-10 05:40:03] [indexer:background] Health check [2024-07-10 05:40:03] [indexer:background] Health check [2024-07-10 05:43:46] [index:background] Health check [2024-07-10 05:45:50] [indexer:background] Health check [2024-07-10 05:48:53] [index:background] Health check [2024-07-10 05:49:18] [indexer:background] Health check [2024-07-10 05:53:45] [index:background] Health check [2024-07-10 05:55:13] [indexer:background] Health check [2024-07-10 05:58:57] [index:background] Health check [2024-07-10 06:01:30] [indexer:background] Health check [2024-07-10 06:03:48] [index:background] Health check [2024-07-10 06:04:27] [indexer:background] Health check [2024-07-10 06:08:50] [index:background] Health check [2024-07-10 06:10:15] [indexer:background] Health check [2024-07-10 06:13:50] [index:background] Health check [2024-07-10 06:14:17] [indexer:background] Health check [2024-07-10 06:20:10] [index:background] Health check [2024-07-10 06:20:10] [indexer:background] Health check [2024-07-10 06:20:10] [indexer:background] Health check [2024-07-10 06:23:51] [index:background] Health check [2024-07-10 06:24:30] [indexer:background] Health check [2024-07-10 06:28:50] [index:background] Health check [2024-07-10 06:30:56] [indexer:background] Health check [2024-07-10 06:33:50] [index:background] Health check [2024-07-10 06:34:18] [indexer:background] Health check [2024-07-10 06:38:50] [index:background] Health check [2024-07-10 06:39:35] [indexer:background] Health check [2024-07-10 06:43:50] [index:background] Health check [2024-07-10 06:46:35] [indexer:background] Health check [2024-07-10 06:48:54] [index:background] Health check [2024-07-10 06:49:47] [indexer:background] Health check [2024-07-10 06:53:55] [index:background] Health check [2024-07-10 06:57:00] [indexer:background] Health check [2024-07-10 06:59:11] [index:background] Health check [2024-07-10 06:59:28] [indexer:background] Health check [2024-07-10 07:03:43] [index:background] Health check [2024-07-10 07:05:16] [indexer:background] Health check [2024-07-10 07:08:55] [index:background] Health check [2024-07-10 07:09:45] [indexer:background] Health check [2024-07-10 07:15:02] [index:background] Health check [2024-07-10 07:15:02] [indexer:background] Health check [2024-07-10 07:15:02] [indexer:background] Health check [2024-07-10 07:18:49] [index:background] Health check [2024-07-10 07:19:27] [indexer:background] Health check [2024-07-10 07:25:19] [index:background] Health check [2024-07-10 07:25:19] [indexer:background] Health check [2024-07-10 07:25:19] [indexer:background] Health check [2024-07-10 07:28:42] [index:background] Health check [2024-07-10 07:32:49] [indexer:background] Health check [2024-07-10 07:33:52] [index:background] Health check [2024-07-10 07:34:21] [indexer:background] Health check [2024-07-10 07:38:52] [index:background] Health check [2024-07-10 07:39:19] [indexer:background] Health check [2024-07-10 07:43:53] [index:background] Health check [2024-07-10 07:44:19] [indexer:background] Health check [2024-07-10 07:48:52] [index:background] Health check [2024-07-10 07:49:44] [indexer:background] Health check [2024-07-10 07:53:53] [index:background] Health check [2024-07-10 07:54:26] [indexer:background] Health check [2024-07-10 07:58:53] [index:background] Health check [2024-07-10 07:59:28] [indexer:background] Health check [2024-07-10 08:03:53] [index:background] Health check [2024-07-10 08:04:21] [indexer:background] Health check [2024-07-10 08:10:23] [index:background] Health check [2024-07-10 08:10:23] [indexer:background] Health check [2024-07-10 08:10:23] [indexer:background] Health check [2024-07-10 08:14:21] [index:background] Health check [2024-07-10 08:14:21] [indexer:background] Health check [2024-07-10 08:14:21] [indexer:background] Health check [2024-07-10 08:16:22] [query] Query for: 2025 [2024-07-10 08:16:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 08:16:22] [query] Engine: default [2024-07-10 08:16:23] [query] Tokens: 2025 [2024-07-10 08:16:23] [query] Mods: 6 [2024-07-10 08:16:23] [query] Found results using: or logic [2024-07-10 08:16: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 (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-10 08:16:23] [query] Results: 138 Pages of results: 14 [2024-07-10 08:16:23] [query] Execution time: 1.43241 [2024-07-10 08:20:06] [index:background] Health check [2024-07-10 08:20:06] [indexer:background] Health check [2024-07-10 08:20:06] [indexer:background] Health check [2024-07-10 08:24:11] [index:background] Health check [2024-07-10 08:24:53] [indexer:background] Health check [2024-07-10 08:28:47] [index:background] Health check [2024-07-10 08:29:25] [indexer:background] Health check [2024-07-10 08:33:45] [index:background] Health check [2024-07-10 08:36:04] [indexer:background] Health check [2024-07-10 08:39:03] [index:background] Health check [2024-07-10 08:39:39] [indexer:background] Health check [2024-07-10 08:46:09] [index:background] Health check [2024-07-10 08:46:09] [indexer:background] Health check [2024-07-10 08:46:09] [indexer:background] Health check [2024-07-10 08:48:43] [index:background] Health check [2024-07-10 08:49:31] [indexer:background] Health check [2024-07-10 08:53:54] [index:background] Health check [2024-07-10 08:54:39] [indexer:background] Health check [2024-07-10 08:58:55] [index:background] Health check [2024-07-10 09:00:49] [indexer:background] Health check [2024-07-10 09:03:44] [index:background] Health check [2024-07-10 09:04:17] [indexer:background] Health check [2024-07-10 09:08:53] [index:background] Health check [2024-07-10 09:09:53] [indexer:background] Health check [2024-07-10 09:13:50] [index:background] Health check [2024-07-10 09:14:18] [indexer:background] Health check [2024-07-10 09:18:59] [index:background] Health check [2024-07-10 09:19:19] [indexer:background] Health check [2024-07-10 09:23:57] [index:background] Health check [2024-07-10 09:24:36] [indexer:background] Health check [2024-07-10 09:28:47] [index:background] Health check [2024-07-10 09:29:19] [indexer:background] Health check [2024-07-10 09:33:59] [index:background] Health check [2024-07-10 09:34:23] [indexer:background] Health check [2024-07-10 09:38:59] [index:background] Health check [2024-07-10 09:39:22] [indexer:background] Health check [2024-07-10 09:44:52] [index:background] Health check [2024-07-10 09:44:53] [indexer:background] Health check [2024-07-10 09:44:53] [indexer:background] Health check [2024-07-10 09:48:44] [index:background] Health check [2024-07-10 09:49:21] [indexer:background] Health check [2024-07-10 09:53:46] [index:background] Health check [2024-07-10 09:54:21] [indexer:background] Health check [2024-07-10 09:58:44] [index:background] Health check [2024-07-10 09:59:18] [indexer:background] Health check [2024-07-10 10:03:54] [index:background] Health check [2024-07-10 10:04:16] [indexer:background] Health check [2024-07-10 10:09:42] [index:background] Health check [2024-07-10 10:09:43] [indexer:background] Health check [2024-07-10 10:09:43] [indexer:background] Health check [2024-07-10 10:14:15] [index:background] Health check [2024-07-10 10:14:15] [indexer:background] Health check [2024-07-10 10:14:15] [indexer:background] Health check [2024-07-10 10:18:56] [index:background] Health check [2024-07-10 10:19:31] [indexer:background] Health check [2024-07-10 10:23:56] [index:background] Health check [2024-07-10 10:24:36] [indexer:background] Health check [2024-07-10 10:28:48] [index:background] Health check [2024-07-10 10:29:34] [indexer:background] Health check [2024-07-10 10:33:42] [index:background] Health check [2024-07-10 10:34:19] [indexer:background] Health check [2024-07-10 10:38:58] [index:background] Health check [2024-07-10 10:39:45] [indexer:background] Health check [2024-07-10 10:43:58] [index:background] Health check [2024-07-10 10:44:37] [indexer:background] Health check [2024-07-10 10:50:52] [index:background] Health check [2024-07-10 10:50:52] [indexer:background] Health check [2024-07-10 10:50:52] [indexer:background] Health check [2024-07-10 10:53:59] [index:background] Health check [2024-07-10 10:54:51] [indexer:background] Health check [2024-07-10 10:58:49] [index:background] Health check [2024-07-10 10:59:28] [indexer:background] Health check [2024-07-10 11:05:02] [index:background] Health check [2024-07-10 11:05:02] [indexer:background] Health check [2024-07-10 11:05:02] [indexer:background] Health check [2024-07-10 11:09:00] [index:background] Health check [2024-07-10 11:09:22] [indexer:background] Health check [2024-07-10 11:13:47] [index:background] Health check [2024-07-10 11:16:55] [indexer:background] Health check [2024-07-10 11:18:58] [index:background] Health check [2024-07-10 11:19:17] [indexer:background] Health check [2024-07-10 11:23:56] [index:background] Health check [2024-07-10 11:25:14] [indexer:background] Health check [2024-07-10 11:28:54] [index:background] Health check [2024-07-10 11:30:18] [indexer:background] Health check [2024-07-10 11:33:59] [index:background] Health check [2024-07-10 11:35:01] [indexer:background] Health check [2024-07-10 11:39:03] [index:background] Health check [2024-07-10 11:39:40] [indexer:background] Health check [2024-07-10 11:43:58] [index:background] Health check [2024-07-10 11:44:25] [indexer:background] Health check [2024-07-10 11:49:01] [index:background] Health check [2024-07-10 11:49:36] [indexer:background] Health check [2024-07-10 11:53:53] [index:background] Health check [2024-07-10 11:54:19] [indexer:background] Health check [2024-07-10 11:59:00] [index:background] Health check [2024-07-10 11:59:31] [indexer:background] Health check [2024-07-10 12:03:48] [index:background] Health check [2024-07-10 12:05:03] [indexer:background] Health check [2024-07-10 12:09:09] [index:background] Health check [2024-07-10 12:09:36] [indexer:background] Health check [2024-07-10 12:14:30] [index:background] Health check [2024-07-10 12:14:30] [indexer:background] Health check [2024-07-10 12:14:30] [indexer:background] Health check [2024-07-10 12:19:08] [index:background] Health check [2024-07-10 12:19:46] [indexer:background] Health check [2024-07-10 12:23:47] [index:background] Health check [2024-07-10 12:24:58] [indexer:background] Health check [2024-07-10 12:29:04] [index:background] Health check [2024-07-10 12:29:37] [indexer:background] Health check [2024-07-10 12:36:06] [index:background] Health check [2024-07-10 12:36:06] [indexer:background] Health check [2024-07-10 12:36:06] [indexer:background] Health check [2024-07-10 12:38:52] [index:background] Health check [2024-07-10 12:39:24] [indexer:background] Health check [2024-07-10 12:44:12] [index:background] Health check [2024-07-10 12:45:20] [indexer:background] Health check [2024-07-10 12:51:35] [index:background] Health check [2024-07-10 12:51:35] [indexer:background] Health check [2024-07-10 12:51:35] [indexer:background] Health check [2024-07-10 12:53:44] [index:background] Health check [2024-07-10 12:54:32] [indexer:background] Health check [2024-07-10 12:58:54] [index:background] Health check [2024-07-10 12:59:20] [indexer:background] Health check [2024-07-10 13:04:02] [index:background] Health check [2024-07-10 13:04:22] [indexer:background] Health check [2024-07-10 13:09:01] [index:background] Health check [2024-07-10 13:09:56] [indexer:background] Health check [2024-07-10 13:15:07] [index:background] Health check [2024-07-10 13:15:07] [index:background] Health check [2024-07-10 13:15:07] [indexer:background] Health check [2024-07-10 13:15:07] [indexer:background] Health check [2024-07-10 13:19:01] [index:background] Health check [2024-07-10 13:19:30] [indexer:background] Health check [2024-07-10 13:24:01] [index:background] Health check [2024-07-10 13:24:53] [indexer:background] Health check [2024-07-10 13:28:50] [index:background] Health check [2024-07-10 13:29:41] [indexer:background] Health check [2024-07-10 13:33:59] [index:background] Health check [2024-07-10 13:34:32] [indexer:background] Health check [2024-07-10 13:40:54] [index:background] Health check [2024-07-10 13:40:54] [indexer:background] Health check [2024-07-10 13:40:54] [indexer:background] Health check [2024-07-10 13:43:44] [index:background] Health check [2024-07-10 13:44:57] [indexer:background] Health check [2024-07-10 13:49:43] [index:background] Health check [2024-07-10 13:49:44] [indexer:background] Health check [2024-07-10 13:49:44] [indexer:background] Health check [2024-07-10 13:55:19] [index:background] Health check [2024-07-10 13:55:19] [indexer:background] Health check [2024-07-10 13:55:19] [indexer:background] Health check [2024-07-10 13:59:34] [index:background] Health check [2024-07-10 13:59:34] [indexer:background] Health check [2024-07-10 13:59:34] [indexer:background] Health check [2024-07-10 14:04:19] [index:background] Health check [2024-07-10 14:04:19] [indexer:background] Health check [2024-07-10 14:04:20] [indexer:background] Health check [2024-07-10 14:09:22] [index:background] Health check [2024-07-10 14:09:22] [indexer:background] Health check [2024-07-10 14:09:22] [indexer:background] Health check [2024-07-10 14:14:14] [index:background] Health check [2024-07-10 14:14:24] [indexer:background] Health check [2024-07-10 14:18:55] [index:background] Health check [2024-07-10 14:19:38] [indexer:background] Health check [2024-07-10 14:24:09] [index:background] Health check [2024-07-10 14:25:03] [indexer:background] Health check [2024-07-10 14:28:51] [index:background] Health check [2024-07-10 14:29:17] [indexer:background] Health check [2024-07-10 14:34:05] [index:background] Health check [2024-07-10 14:34:57] [indexer:background] Health check [2024-07-10 14:39:08] [index:background] Health check [2024-07-10 14:40:21] [indexer:background] Health check [2024-07-10 14:44:10] [index:background] Health check [2024-07-10 14:44:27] [indexer:background] Health check [2024-07-10 14:49:00] [index:background] Health check [2024-07-10 14:50:18] [indexer:background] Health check [2024-07-10 14:53:57] [index:background] Health check [2024-07-10 14:54:30] [indexer:background] Health check [2024-07-10 14:59:04] [index:background] Health check [2024-07-10 15:00:11] [indexer:background] Health check [2024-07-10 15:03:53] [index:background] Health check [2024-07-10 15:04:21] [indexer:background] Health check [2024-07-10 15:08:46] [index:background] Health check [2024-07-10 15:09:28] [indexer:background] Health check [2024-07-10 15:13:47] [index:background] Health check [2024-07-10 15:14:41] [indexer:background] Health check [2024-07-10 15:17:47] [query] Query for: 2023 [2024-07-10 15:17:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 15:17:47] [query] Engine: default [2024-07-10 15:17:47] [query] Tokens: 2023 [2024-07-10 15:17:47] [query] Mods: 6 [2024-07-10 15:17:48] [query] Found results using: or logic [2024-07-10 15:17:48] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-10 15:17:48] [query] Results: 280 Pages of results: 28 [2024-07-10 15:17:48] [query] Execution time: 0.84967 [2024-07-10 15:19:06] [index:background] Health check [2024-07-10 15:19:31] [indexer:background] Health check [2024-07-10 15:23:58] [index:background] Health check [2024-07-10 15:25:24] [indexer:background] Health check [2024-07-10 15:29:09] [index:background] Health check [2024-07-10 15:29:33] [indexer:background] Health check [2024-07-10 15:34:07] [index:background] Health check [2024-07-10 15:35:59] [indexer:background] Health check [2024-07-10 15:38:42] [index:background] Health check [2024-07-10 15:39:23] [indexer:background] Health check [2024-07-10 15:44:07] [index:background] Health check [2024-07-10 15:44:25] [indexer:background] Health check [2024-07-10 15:49:08] [index:background] Health check [2024-07-10 15:49:36] [indexer:background] Health check [2024-07-10 15:53:52] [index:background] Health check [2024-07-10 15:54:34] [indexer:background] Health check [2024-07-10 15:59:00] [index:background] Health check [2024-07-10 15:59:43] [indexer:background] Health check [2024-07-10 16:04:08] [index:background] Health check [2024-07-10 16:04:58] [indexer:background] Health check [2024-07-10 16:08:53] [index:background] Health check [2024-07-10 16:10:36] [indexer:background] Health check [2024-07-10 16:13:54] [index:background] Health check [2024-07-10 16:14:58] [indexer:background] Health check [2024-07-10 16:18:43] [index:background] Health check [2024-07-10 16:19:39] [indexer:background] Health check [2024-07-10 16:23:42] [index:background] Health check [2024-07-10 16:26:16] [indexer:background] Health check [2024-07-10 16:30:05] [index:background] Health check [2024-07-10 16:30:05] [indexer:background] Health check [2024-07-10 16:30:05] [indexer:background] Health check [2024-07-10 16:34:34] [index:background] Health check [2024-07-10 16:34:34] [indexer:background] Health check [2024-07-10 16:34:34] [indexer:background] Health check [2024-07-10 16:40:03] [index:background] Health check [2024-07-10 16:40:03] [indexer:background] Health check [2024-07-10 16:40:03] [indexer:background] Health check [2024-07-10 16:44:19] [index:background] Health check [2024-07-10 16:44:19] [indexer:background] Health check [2024-07-10 16:44:19] [indexer:background] Health check [2024-07-10 16:48:47] [index:background] Health check [2024-07-10 16:51:24] [indexer:background] Health check [2024-07-10 16:54:34] [index:background] Health check [2024-07-10 16:54:34] [indexer:background] Health check [2024-07-10 16:54:34] [indexer:background] Health check [2024-07-10 16:58:44] [index:background] Health check [2024-07-10 16:59:37] [indexer:background] Health check [2024-07-10 17:05:56] [index:background] Health check [2024-07-10 17:05:56] [indexer:background] Health check [2024-07-10 17:05:56] [indexer:background] Health check [2024-07-10 17:10:45] [index:background] Health check [2024-07-10 17:10:45] [indexer:background] Health check [2024-07-10 17:10:45] [indexer:background] Health check [2024-07-10 17:14:11] [index:background] Health check [2024-07-10 17:14:23] [indexer:background] Health check [2024-07-10 17:18:42] [index:background] Health check [2024-07-10 17:19:35] [indexer:background] Health check [2024-07-10 17:24:47] [index:background] Health check [2024-07-10 17:24:47] [indexer:background] Health check [2024-07-10 17:24:47] [indexer:background] Health check [2024-07-10 17:29:33] [index:background] Health check [2024-07-10 17:29:34] [indexer:background] Health check [2024-07-10 17:29:34] [indexer:background] Health check [2024-07-10 17:33:43] [index:background] Health check [2024-07-10 17:35:09] [indexer:background] Health check [2024-07-10 17:39:09] [index:background] Health check [2024-07-10 17:40:25] [indexer:background] Health check [2024-07-10 17:44:10] [index:background] Health check [2024-07-10 17:44:22] [indexer:background] Health check [2024-07-10 17:49:20] [index:background] Health check [2024-07-10 17:49:20] [indexer:background] Health check [2024-07-10 17:49:20] [indexer:background] Health check [2024-07-10 17:54:15] [index:background] Health check [2024-07-10 17:54:15] [indexer:background] Health check [2024-07-10 17:54:15] [indexer:background] Health check [2024-07-10 17:59:19] [index:background] Health check [2024-07-10 17:59:23] [indexer:background] Health check [2024-07-10 18:04:09] [index:background] Health check [2024-07-10 18:04:51] [indexer:background] Health check [2024-07-10 18:09:09] [index:background] Health check [2024-07-10 18:09:55] [indexer:background] Health check [2024-07-10 18:14:16] [index:background] Health check [2024-07-10 18:14:16] [indexer:background] Health check [2024-07-10 18:14:16] [indexer:background] Health check [2024-07-10 18:18:42] [query] Query for: 2025 [2024-07-10 18:18:42] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-07-10 18:18:42] [query] Engine: default [2024-07-10 18:18:43] [query] Tokens: 2025 [2024-07-10 18:18:43] [query] Mods: 6 [2024-07-10 18:18:43] [query] Found results using: or logic [2024-07-10 18:18:43] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-10 18:18:43] [query] Results: 138 Pages of results: 14 [2024-07-10 18:18:43] [query] Execution time: 1.11677 [2024-07-10 18:18:44] [index:background] Health check [2024-07-10 18:19:24] [indexer:background] Health check [2024-07-10 18:23:46] [index:background] Health check [2024-07-10 18:25:44] [indexer:background] Health check [2024-07-10 18:29:10] [index:background] Health check [2024-07-10 18:29:27] [indexer:background] Health check [2024-07-10 18:34:06] [index:background] Health check [2024-07-10 18:34:28] [indexer:background] Health check [2024-07-10 18:38:54] [index:background] Health check [2024-07-10 18:40:35] [indexer:background] Health check [2024-07-10 18:43:56] [index:background] Health check [2024-07-10 18:44:55] [indexer:background] Health check [2024-07-10 18:48:58] [index:background] Health check [2024-07-10 18:49:24] [indexer:background] Health check [2024-07-10 18:54:03] [index:background] Health check [2024-07-10 18:55:58] [indexer:background] Health check [2024-07-10 18:59:11] [index:background] Health check [2024-07-10 18:59:53] [indexer:background] Health check [2024-07-10 19:04:13] [index:background] Health check [2024-07-10 19:04:16] [indexer:background] Health check [2024-07-10 19:08:52] [index:background] Health check [2024-07-10 19:09:22] [indexer:background] Health check [2024-07-10 19:13:45] [index:background] Health check [2024-07-10 19:14:17] [indexer:background] Health check [2024-07-10 19:19:12] [index:background] Health check [2024-07-10 19:20:48] [indexer:background] Health check [2024-07-10 19:23:59] [index:background] Health check [2024-07-10 19:24:56] [indexer:background] Health check [2024-07-10 19:29:15] [index:background] Health check [2024-07-10 19:29:20] [indexer:background] Health check [2024-07-10 19:34:06] [index:background] Health check [2024-07-10 19:34:16] [indexer:background] Health check [2024-07-10 19:39:12] [index:background] Health check [2024-07-10 19:39:44] [indexer:background] Health check [2024-07-10 19:44:12] [index:background] Health check [2024-07-10 19:44:50] [indexer:background] Health check [2024-07-10 19:49:12] [index:background] Health check [2024-07-10 19:51:31] [indexer:background] Health check [2024-07-10 19:54:14] [index:background] Health check [2024-07-10 19:54:18] [indexer:background] Health check [2024-07-10 19:58:45] [index:background] Health check [2024-07-10 19:59:26] [indexer:background] Health check [2024-07-10 20:04:14] [index:background] Health check [2024-07-10 20:05:58] [indexer:background] Health check [2024-07-10 20:09:01] [index:background] Health check [2024-07-10 20:09:21] [indexer:background] Health check [2024-07-10 20:13:46] [index:background] Health check [2024-07-10 20:14:27] [indexer:background] Health check [2024-07-10 20:18:45] [index:background] Health check [2024-07-10 20:24:19] [indexer:background] Health check [2024-07-10 20:24:20] [index:background] Health check [2024-07-10 20:29:41] [index:background] Health check [2024-07-10 20:29:41] [indexer:background] Health check [2024-07-10 20:29:41] [indexer:background] Health check [2024-07-10 20:35:47] [index:background] Health check [2024-07-10 20:35:47] [indexer:background] Health check [2024-07-10 20:35:47] [indexer:background] Health check [2024-07-10 20:39:54] [index:background] Health check [2024-07-10 20:39:55] [indexer:background] Health check [2024-07-10 20:39:55] [indexer:background] Health check [2024-07-10 20:43:44] [index:background] Health check [2024-07-10 20:45:07] [indexer:background] Health check [2024-07-10 20:48:45] [index:background] Health check [2024-07-10 20:48:45] [index:background] Health check [2024-07-10 20:49:39] [indexer:background] Health check [2024-07-10 20:55:14] [index:background] Health check [2024-07-10 20:55:14] [indexer:background] Health check [2024-07-10 20:55:14] [indexer:background] Health check [2024-07-10 20:59:17] [index:background] Health check [2024-07-10 20:59:17] [indexer:background] Health check [2024-07-10 20:59:17] [indexer:background] Health check [2024-07-10 21:04:41] [index:background] Health check [2024-07-10 21:04:41] [indexer:background] Health check [2024-07-10 21:04:41] [indexer:background] Health check [2024-07-10 21:10:05] [index:background] Health check [2024-07-10 21:10:05] [indexer:background] Health check [2024-07-10 21:10:05] [indexer:background] Health check [2024-07-10 21:14:25] [index:background] Health check [2024-07-10 21:14:25] [indexer:background] Health check [2024-07-10 21:14:25] [indexer:background] Health check [2024-07-10 21:19:09] [index:background] Health check [2024-07-10 21:19:55] [indexer:background] Health check [2024-07-10 21:23:44] [index:background] Health check [2024-07-10 21:24:22] [indexer:background] Health check [2024-07-10 21:29:20] [index:background] Health check [2024-07-10 21:29:21] [indexer:background] Health check [2024-07-10 21:29:21] [indexer:background] Health check [2024-07-10 21:34:18] [index:background] Health check [2024-07-10 21:34:18] [indexer:background] Health check [2024-07-10 21:34:18] [indexer:background] Health check [2024-07-10 21:38:42] [index:background] Health check [2024-07-10 21:39:45] [indexer:background] Health check [2024-07-10 21:44:49] [index:background] Health check [2024-07-10 21:44:49] [indexer:background] Health check [2024-07-10 21:44:49] [indexer:background] Health check [2024-07-10 21:49:09] [index:background] Health check [2024-07-10 21:49:20] [indexer:background] Health check [2024-07-10 21:54:34] [index:background] Health check [2024-07-10 21:54:34] [indexer:background] Health check [2024-07-10 21:54:34] [indexer:background] Health check [2024-07-10 21:58:49] [index:background] Health check [2024-07-10 22:01:37] [indexer:background] Health check [2024-07-10 22:04:21] [index:background] Health check [2024-07-10 22:04:22] [indexer:background] Health check [2024-07-10 22:04:22] [indexer:background] Health check [2024-07-10 22:09:00] [index:background] Health check [2024-07-10 22:09:34] [indexer:background] Health check [2024-07-10 22:16:06] [index:background] Health check [2024-07-10 22:16:06] [indexer:background] Health check [2024-07-10 22:16:06] [indexer:background] Health check [2024-07-10 22:18:47] [index:background] Health check [2024-07-10 22:20:28] [indexer:background] Health check [2024-07-10 22:24:37] [index:background] Health check [2024-07-10 22:24:37] [indexer:background] Health check [2024-07-10 22:24:37] [indexer:background] Health check [2024-07-10 22:29:35] [index:background] Health check [2024-07-10 22:29:35] [indexer:background] Health check [2024-07-10 22:29:35] [indexer:background] Health check [2024-07-10 22:33:47] [index:background] Health check [2024-07-10 22:34:18] [indexer:background] Health check [2024-07-10 22:38:42] [index:background] Health check [2024-07-10 22:39:20] [indexer:background] Health check [2024-07-10 22:44:03] [index:background] Health check [2024-07-10 22:44:16] [indexer:background] Health check [2024-07-10 22:49:49] [index:background] Health check [2024-07-10 22:49:49] [indexer:background] Health check [2024-07-10 22:49:49] [indexer:background] Health check [2024-07-10 22:54:31] [index:background] Health check [2024-07-10 22:54:31] [indexer:background] Health check [2024-07-10 22:54:31] [indexer:background] Health check [2024-07-10 22:58:49] [index:background] Health check [2024-07-10 23:02:28] [indexer:background] Health check [2024-07-10 23:03:44] [index:background] Health check [2024-07-10 23:06:29] [indexer:background] Health check [2024-07-10 23:08:50] [index:background] Health check [2024-07-10 23:10:46] [indexer:background] Health check [2024-07-10 23:14:08] [index:background] Health check [2024-07-10 23:14:34] [indexer:background] Health check [2024-07-10 23:19:14] [index:background] Health check [2024-07-10 23:19:17] [indexer:background] Health check [2024-07-10 23:24:24] [index:background] Health check [2024-07-10 23:24:24] [indexer:background] Health check [2024-07-10 23:24:24] [indexer:background] Health check [2024-07-10 23:29:17] [index:background] Health check [2024-07-10 23:29:17] [indexer:background] Health check [2024-07-10 23:29:17] [indexer:background] Health check [2024-07-10 23:33:47] [index:background] Health check [2024-07-10 23:34:35] [indexer:background] Health check [2024-07-10 23:38:42] [index:background] Health check [2024-07-10 23:39:18] [indexer:background] Health check [2024-07-10 23:43:42] [index:background] Health check [2024-07-10 23:44:17] [indexer:background] Health check [2024-07-10 23:49:22] [index:background] Health check [2024-07-10 23:49:23] [indexer:background] Health check [2024-07-10 23:49:23] [indexer:background] Health check [2024-07-10 23:54:18] [index:background] Health check [2024-07-10 23:54:18] [indexer:background] Health check [2024-07-10 23:54:18] [indexer:background] Health check [2024-07-10 23:59:12] [index:background] Health check [2024-07-10 23:59:17] [indexer:background] Health check