[2024-05-05 00:00:00] [indexer:background] Health check [2024-05-05 00:03:19] [index:background] Health check [2024-05-05 00:05:34] [indexer:background] Health check [2024-05-05 00:08:36] [index:background] Health check [2024-05-05 00:09:45] [indexer:background] Health check [2024-05-05 00:12:56] [index:background] Health check [2024-05-05 00:15:42] [indexer:background] Health check [2024-05-05 00:17:34] [index:background] Health check [2024-05-05 00:19:21] [indexer:background] Health check [2024-05-05 00:24:14] [index:background] Health check [2024-05-05 00:26:39] [indexer:background] Health check [2024-05-05 00:27:47] [index:background] Health check [2024-05-05 00:29:45] [indexer:background] Health check [2024-05-05 00:33:12] [index:background] Health check [2024-05-05 00:35:15] [indexer:background] Health check [2024-05-05 00:39:17] [index:background] Health check [2024-05-05 00:39:17] [indexer:background] Health check [2024-05-05 00:39:18] [indexer:background] Health check [2024-05-05 00:42:46] [index:background] Health check [2024-05-05 00:45:49] [indexer:background] Health check [2024-05-05 00:50:05] [index:background] Health check [2024-05-05 00:50:05] [indexer:background] Health check [2024-05-05 00:50:05] [indexer:background] Health check [2024-05-05 00:53:24] [index:background] Health check [2024-05-05 00:54:19] [indexer:background] Health check [2024-05-05 01:00:03] [index:background] Health check [2024-05-05 01:00:03] [indexer:background] Health check [2024-05-05 01:00:03] [indexer:background] Health check [2024-05-05 01:02:50] [index:background] Health check [2024-05-05 01:04:53] [indexer:background] Health check [2024-05-05 01:08:12] [index:background] Health check [2024-05-05 01:11:06] [indexer:background] Health check [2024-05-05 01:13:23] [index:background] Health check [2024-05-05 01:14:49] [indexer:background] Health check [2024-05-05 01:18:10] [index:background] Health check [2024-05-05 01:19:46] [indexer:background] Health check [2024-05-05 01:23:44] [index:background] Health check [2024-05-05 01:25:02] [indexer:background] Health check [2024-05-05 01:27:39] [index:background] Health check [2024-05-05 01:29:29] [indexer:background] Health check [2024-05-05 01:33:17] [index:background] Health check [2024-05-05 01:34:41] [indexer:background] Health check [2024-05-05 01:39:31] [index:background] Health check [2024-05-05 01:39:31] [indexer:background] Health check [2024-05-05 01:39:31] [indexer:background] Health check [2024-05-05 01:43:24] [index:background] Health check [2024-05-05 01:44:32] [indexer:background] Health check [2024-05-05 01:46:53] [query] Query for: 2024 [2024-05-05 01:46:53] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 01:46:53] [query] Engine: default [2024-05-05 01:46:54] [query] Tokens: 2024 [2024-05-05 01:46:54] [query] Mods: 6 [2024-05-05 01:46:55] [query] Found results using: or logic [2024-05-05 01:46:55] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-05-05 01:46:55] [query] Results: 155 Pages of results: 16 [2024-05-05 01:46:55] [query] Execution time: 1.45751 [2024-05-05 01:47:33] [index:background] Health check [2024-05-05 01:49:20] [indexer:background] Health check [2024-05-05 01:54:13] [index:background] Health check [2024-05-05 01:56:13] [indexer:background] Health check [2024-05-05 01:58:28] [index:background] Health check [2024-05-05 01:59:43] [indexer:background] Health check [2024-05-05 02:03:08] [index:background] Health check [2024-05-05 02:04:38] [indexer:background] Health check [2024-05-05 02:08:11] [index:background] Health check [2024-05-05 02:09:57] [indexer:background] Health check [2024-05-05 02:12:50] [index:background] Health check [2024-05-05 02:16:15] [indexer:background] Health check [2024-05-05 02:18:37] [index:background] Health check [2024-05-05 02:19:22] [indexer:background] Health check [2024-05-05 02:23:49] [index:background] Health check [2024-05-05 02:24:42] [indexer:background] Health check [2024-05-05 02:27:54] [index:background] Health check [2024-05-05 02:29:18] [indexer:background] Health check [2024-05-05 02:33:42] [index:background] Health check [2024-05-05 02:34:27] [indexer:background] Health check [2024-05-05 02:37:33] [index:background] Health check [2024-05-05 02:39:30] [indexer:background] Health check [2024-05-05 02:42:47] [index:background] Health check [2024-05-05 02:42:48] [index:background] Health check [2024-05-05 02:44:35] [indexer:background] Health check [2024-05-05 02:47:35] [index:background] Health check [2024-05-05 02:49:17] [indexer:background] Health check [2024-05-05 02:49:17] [indexer:background] CPU load threshold (3) breached: 3 [waiting 2] [2024-05-05 02:52:54] [index:background] Health check [2024-05-05 02:56:31] [indexer:background] Health check [2024-05-05 02:58:19] [index:background] Health check [2024-05-05 02:59:36] [indexer:background] Health check [2024-05-05 03:02:39] [index:background] Health check [2024-05-05 03:05:07] [indexer:background] Health check [2024-05-05 03:07:50] [index:background] Health check [2024-05-05 03:10:49] [indexer:background] Health check [2024-05-05 03:12:50] [index:background] Health check [2024-05-05 03:15:03] [indexer:background] Health check [2024-05-05 03:17:56] [index:background] Health check [2024-05-05 03:20:21] [indexer:background] Health check [2024-05-05 03:26:37] [index:background] Health check [2024-05-05 03:26:37] [indexer:background] Health check [2024-05-05 03:26:37] [indexer:background] Health check [2024-05-05 03:28:18] [index:background] Health check [2024-05-05 03:28:23] [query] Query for: 2024 [2024-05-05 03:28:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 03:28:23] [query] Engine: default [2024-05-05 03:28:24] [query] Tokens: 2024 [2024-05-05 03:28:24] [query] Mods: 6 [2024-05-05 03:28:25] [query] Found results using: or logic [2024-05-05 03:28: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 (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-05-05 03:28:25] [query] Results: 155 Pages of results: 16 [2024-05-05 03:28:25] [query] Execution time: 1.60233 [2024-05-05 03:28:25] [query] Query for: 2024 [2024-05-05 03:28:25] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-05-05 03:28:25] [query] Engine: default [2024-05-05 03:28:25] [query] Tokens: 2024 [2024-05-05 03:28:25] [query] Mods: 6 [2024-05-05 03:28:25] [query] Found results using: or logic [2024-05-05 03:28: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 (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-05-05 03:28:25] [query] Results: 155 Pages of results: 2 [2024-05-05 03:28:25] [query] Execution time: 0.17727 [2024-05-05 03:29:27] [indexer:background] Health check [2024-05-05 03:32:50] [index:background] Health check [2024-05-05 03:35:07] [indexer:background] Health check [2024-05-05 03:38:28] [index:background] Health check [2024-05-05 03:39:18] [indexer:background] Health check [2024-05-05 03:42:57] [index:background] Health check [2024-05-05 03:45:19] [indexer:background] Health check [2024-05-05 03:45:19] [indexer:background] Health check [2024-05-05 03:47:41] [index:background] Health check [2024-05-05 03:51:46] [indexer:background] Health check [2024-05-05 03:54:02] [index:background] Health check [2024-05-05 03:54:20] [indexer:background] Health check [2024-05-05 03:58:30] [index:background] Health check [2024-05-05 03:59:24] [indexer:background] Health check [2024-05-05 04:04:15] [index:background] Health check [2024-05-05 04:04:15] [indexer:background] Health check [2024-05-05 04:04:15] [indexer:background] Health check [2024-05-05 04:12:21] [index:background] Health check [2024-05-05 04:12:21] [indexer:background] Health check [2024-05-05 04:12:21] [indexer:background] Health check [2024-05-05 04:16:20] [index:background] Health check [2024-05-05 04:16:20] [indexer:background] Health check [2024-05-05 04:16:20] [indexer:background] Health check [2024-05-05 04:18:17] [index:background] Health check [2024-05-05 04:19:48] [indexer:background] Health check [2024-05-05 04:24:16] [index:background] Health check [2024-05-05 04:24:28] [indexer:background] Health check [2024-05-05 04:28:54] [index:background] Health check [2024-05-05 04:29:23] [indexer:background] Health check [2024-05-05 04:31:33] [query] Query for: 2025 [2024-05-05 04:31:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 04:31:33] [query] Engine: default [2024-05-05 04:31:33] [query] Tokens: 2025 [2024-05-05 04:31:33] [query] Mods: 6 [2024-05-05 04:31:33] [query] Found results using: or logic [2024-05-05 04:31: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 (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-05-05 04:31:33] [query] Results: 138 Pages of results: 14 [2024-05-05 04:31:33] [query] Execution time: 0.33454 [2024-05-05 04:32:05] [query] Query for: 2025 [2024-05-05 04:32:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 04:32:05] [query] Engine: default [2024-05-05 04:32:05] [query] Tokens: 2025 [2024-05-05 04:32:05] [query] Mods: 6 [2024-05-05 04:32:05] [query] Found results using: or logic [2024-05-05 04:32:05] [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-05-05 04:32:05] [query] Results: 138 Pages of results: 14 [2024-05-05 04:32:05] [query] Execution time: 0.14197 [2024-05-05 04:33:14] [index:background] Health check [2024-05-05 04:35:19] [indexer:background] Health check [2024-05-05 04:38:22] [index:background] Health check [2024-05-05 04:40:31] [indexer:background] Health check [2024-05-05 04:43:02] [index:background] Health check [2024-05-05 04:44:51] [indexer:background] Health check [2024-05-05 04:48:58] [index:background] Health check [2024-05-05 04:51:24] [indexer:background] Health check [2024-05-05 04:52:57] [index:background] Health check [2024-05-05 04:55:07] [indexer:background] Health check [2024-05-05 04:58:49] [index:background] Health check [2024-05-05 04:59:56] [indexer:background] Health check [2024-05-05 05:03:04] [index:background] Health check [2024-05-05 05:04:50] [indexer:background] Health check [2024-05-05 05:08:40] [index:background] Health check [2024-05-05 05:10:31] [indexer:background] Health check [2024-05-05 05:13:33] [index:background] Health check [2024-05-05 05:14:25] [indexer:background] Health check [2024-05-05 05:18:31] [index:background] Health check [2024-05-05 05:19:22] [indexer:background] Health check [2024-05-05 05:23:03] [index:background] Health check [2024-05-05 05:24:25] [indexer:background] Health check [2024-05-05 05:28:13] [index:background] Health check [2024-05-05 05:29:24] [indexer:background] Health check [2024-05-05 05:32:35] [index:background] Health check [2024-05-05 05:36:30] [indexer:background] Health check [2024-05-05 05:38:54] [index:background] Health check [2024-05-05 05:39:20] [indexer:background] Health check [2024-05-05 05:43:17] [index:background] Health check [2024-05-05 05:44:29] [indexer:background] Health check [2024-05-05 05:47:36] [index:background] Health check [2024-05-05 05:49:16] [indexer:background] Health check [2024-05-05 05:49:24] [query] Query for: 2024 [2024-05-05 05:49:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 05:49:24] [query] Engine: default [2024-05-05 05:49:24] [query] Tokens: 2024 [2024-05-05 05:49:24] [query] Mods: 6 [2024-05-05 05:49:24] [query] Found results using: or logic [2024-05-05 05:49: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-05-05 05:49:24] [query] Results: 155 Pages of results: 16 [2024-05-05 05:49:24] [query] Execution time: 0.52742 [2024-05-05 05:52:58] [index:background] Health check [2024-05-05 05:54:52] [indexer:background] Health check [2024-05-05 05:57:55] [index:background] Health check [2024-05-05 05:59:38] [indexer:background] Health check [2024-05-05 06:03:07] [index:background] Health check [2024-05-05 06:04:29] [indexer:background] Health check [2024-05-05 06:08:28] [index:background] Health check [2024-05-05 06:09:18] [indexer:background] Health check [2024-05-05 06:13:13] [index:background] Health check [2024-05-05 06:14:40] [indexer:background] Health check [2024-05-05 06:18:21] [index:background] Health check [2024-05-05 06:20:03] [indexer:background] Health check [2024-05-05 06:25:31] [index:background] Health check [2024-05-05 06:25:31] [indexer:background] Health check [2024-05-05 06:25:31] [indexer:background] Health check [2024-05-05 06:29:01] [index:background] Health check [2024-05-05 06:29:44] [indexer:background] Health check [2024-05-05 06:35:17] [index:background] Health check [2024-05-05 06:35:17] [indexer:background] Health check [2024-05-05 06:35:17] [indexer:background] Health check [2024-05-05 06:37:56] [index:background] Health check [2024-05-05 06:39:25] [indexer:background] Health check [2024-05-05 06:39:40] [query] Query for: 2023 [2024-05-05 06:39:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 06:39:40] [query] Engine: default [2024-05-05 06:39:41] [query] Tokens: 2023 [2024-05-05 06:39:41] [query] Mods: 6 [2024-05-05 06:39:41] [query] Found results using: or logic [2024-05-05 06:39: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-05-05 06:39:41] [query] Results: 277 Pages of results: 28 [2024-05-05 06:39:41] [query] Execution time: 0.38999 [2024-05-05 06:42:36] [index:background] Health check [2024-05-05 06:45:09] [indexer:background] Health check [2024-05-05 06:47:49] [index:background] Health check [2024-05-05 06:50:15] [indexer:background] Health check [2024-05-05 06:53:12] [index:background] Health check [2024-05-05 06:55:07] [indexer:background] Health check [2024-05-05 06:57:47] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125 [2024-05-05 06:57:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 06:57:47] [query] Engine: default [2024-05-05 06:57:47] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill [2024-05-05 06:57:47] [query] Mods: 6 [2024-05-05 06:57:47] [query] Using OR logic [2024-05-05 06:57:48] [query] Found results using: or logic [2024-05-05 06:57: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 (20886,13853,27861,45186,333334,8840,4915,69784,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-05-05 06:57:48] [query] Results: 905 Pages of results: 91 [2024-05-05 06:57:48] [query] Execution time: 1.33416 [2024-05-05 06:59:52] [index:background] Health check [2024-05-05 06:59:52] [indexer:background] Health check [2024-05-05 06:59:52] [indexer:background] Health check [2024-05-05 07:02:37] [index:background] Health check [2024-05-05 07:05:02] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125 [2024-05-05 07:05:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 07:05:02] [query] Engine: default [2024-05-05 07:05:02] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill [2024-05-05 07:05:02] [query] Mods: 6 [2024-05-05 07:05:02] [query] Using OR logic [2024-05-05 07:05:02] [query] Found results using: or logic [2024-05-05 07:05:02] [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 (20886,13853,27861,45186,333334,8840,4915,69784,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-05-05 07:05:02] [query] Results: 905 Pages of results: 91 [2024-05-05 07:05:02] [query] Execution time: 0.34439 [2024-05-05 07:05:03] [indexer:background] Health check [2024-05-05 07:07:37] [index:background] Health check [2024-05-05 07:11:14] [indexer:background] Health check [2024-05-05 07:14:26] [index:background] Health check [2024-05-05 07:14:26] [indexer:background] Health check [2024-05-05 07:14:26] [indexer:background] Health check [2024-05-05 07:17:33] [index:background] Health check [2024-05-05 07:19:19] [indexer:background] Health check [2024-05-05 07:22:36] [index:background] Health check [2024-05-05 07:24:25] [indexer:background] Health check [2024-05-05 07:27:42] [index:background] Health check [2024-05-05 07:29:17] [indexer:background] Health check [2024-05-05 07:33:46] [index:background] Health check [2024-05-05 07:35:56] [indexer:background] Health check [2024-05-05 07:37:54] [index:background] Health check [2024-05-05 07:39:21] [indexer:background] Health check [2024-05-05 07:42:40] [index:background] Health check [2024-05-05 07:44:44] [indexer:background] Health check [2024-05-05 07:48:11] [index:background] Health check [2024-05-05 07:49:52] [indexer:background] Health check [2024-05-05 07:52:52] [index:background] Health check [2024-05-05 07:54:18] [indexer:background] Health check [2024-05-05 07:57:42] [index:background] Health check [2024-05-05 07:58:08] [query] Query for: 2024 [2024-05-05 07:58:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 07:58:08] [query] Engine: default [2024-05-05 07:58:08] [query] Tokens: 2024 [2024-05-05 07:58:08] [query] Mods: 6 [2024-05-05 07:58:08] [query] Found results using: or logic [2024-05-05 07:58:08] [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-05-05 07:58:08] [query] Results: 155 Pages of results: 16 [2024-05-05 07:58:08] [query] Execution time: 0.73028 [2024-05-05 07:59:26] [indexer:background] Health check [2024-05-05 08:02:47] [index:background] Health check [2024-05-05 08:04:36] [indexer:background] Health check [2024-05-05 08:07:35] [index:background] Health check [2024-05-05 08:09:26] [indexer:background] Health check [2024-05-05 08:12:45] [index:background] Health check [2024-05-05 08:15:18] [indexer:background] Health check [2024-05-05 08:17:57] [index:background] Health check [2024-05-05 08:19:39] [indexer:background] Health check [2024-05-05 08:22:53] [index:background] Health check [2024-05-05 08:24:32] [indexer:background] Health check [2024-05-05 08:27:46] [index:background] Health check [2024-05-05 08:29:46] [indexer:background] Health check [2024-05-05 08:35:00] [index:background] Health check [2024-05-05 08:35:00] [indexer:background] Health check [2024-05-05 08:35:00] [indexer:background] Health check [2024-05-05 08:42:45] [index:background] Health check [2024-05-05 08:42:48] [indexer:background] Health check [2024-05-05 08:42:48] [indexer:background] Health check [2024-05-05 08:45:19] [indexer:background] Health check [2024-05-05 08:47:47] [index:background] Health check [2024-05-05 08:49:56] [indexer:background] Health check [2024-05-05 08:52:40] [index:background] Health check [2024-05-05 08:54:25] [indexer:background] Health check [2024-05-05 08:57:33] [index:background] Health check [2024-05-05 08:59:16] [indexer:background] Health check [2024-05-05 09:03:38] [index:background] Health check [2024-05-05 09:05:15] [indexer:background] Health check [2024-05-05 09:08:03] [index:background] Health check [2024-05-05 09:09:49] [indexer:background] Health check [2024-05-05 09:13:29] [index:background] Health check [2024-05-05 09:14:38] [indexer:background] Health check [2024-05-05 09:17:47] [index:background] Health check [2024-05-05 09:19:57] [indexer:background] Health check [2024-05-05 09:22:59] [index:background] Health check [2024-05-05 09:24:22] [indexer:background] Health check [2024-05-05 09:29:21] [index:background] Health check [2024-05-05 09:29:21] [indexer:background] Health check [2024-05-05 09:29:21] [indexer:background] Health check [2024-05-05 09:32:42] [index:background] Health check [2024-05-05 09:35:30] [indexer:background] Health check [2024-05-05 09:38:12] [index:background] Health check [2024-05-05 09:39:21] [indexer:background] Health check [2024-05-05 09:43:22] [index:background] Health check [2024-05-05 09:46:08] [indexer:background] Health check [2024-05-05 09:48:33] [index:background] Health check [2024-05-05 09:49:16] [indexer:background] Health check [2024-05-05 09:53:12] [index:background] Health check [2024-05-05 09:55:00] [indexer:background] Health check [2024-05-05 09:58:45] [index:background] Health check [2024-05-05 09:59:44] [indexer:background] Health check [2024-05-05 10:02:51] [index:background] Health check [2024-05-05 10:05:35] [indexer:background] Health check [2024-05-05 10:07:39] [index:background] Health check [2024-05-05 10:09:40] [indexer:background] Health check [2024-05-05 10:14:03] [index:background] Health check [2024-05-05 10:14:44] [indexer:background] Health check [2024-05-05 10:18:13] [index:background] Health check [2024-05-05 10:20:02] [indexer:background] Health check [2024-05-05 10:23:27] [index:background] Health check [2024-05-05 10:24:25] [indexer:background] Health check [2024-05-05 10:27:57] [index:background] Health check [2024-05-05 10:29:30] [indexer:background] Health check [2024-05-05 10:33:29] [index:background] Health check [2024-05-05 10:34:58] [indexer:background] Health check [2024-05-05 10:37:56] [index:background] Health check [2024-05-05 10:39:16] [indexer:background] Health check [2024-05-05 10:43:18] [index:background] Health check [2024-05-05 10:45:27] [indexer:background] Health check [2024-05-05 10:48:49] [index:background] Health check [2024-05-05 10:50:07] [indexer:background] Health check [2024-05-05 10:53:45] [index:background] Health check [2024-05-05 10:54:40] [indexer:background] Health check [2024-05-05 10:57:35] [index:background] Health check [2024-05-05 10:59:48] [indexer:background] Health check [2024-05-05 11:03:19] [index:background] Health check [2024-05-05 11:04:17] [indexer:background] Health check [2024-05-05 11:07:33] [index:background] Health check [2024-05-05 11:11:04] [indexer:background] Health check [2024-05-05 11:13:03] [index:background] Health check [2024-05-05 11:14:32] [indexer:background] Health check [2024-05-05 11:17:42] [index:background] Health check [2024-05-05 11:19:29] [indexer:background] Health check [2024-05-05 11:22:39] [index:background] Health check [2024-05-05 11:24:17] [indexer:background] Health check [2024-05-05 11:27:39] [index:background] Health check [2024-05-05 11:29:16] [indexer:background] Health check [2024-05-05 11:32:53] [index:background] Health check [2024-05-05 11:35:09] [indexer:background] Health check [2024-05-05 11:37:46] [index:background] Health check [2024-05-05 11:39:50] [indexer:background] Health check [2024-05-05 11:42:46] [index:background] Health check [2024-05-05 11:44:16] [indexer:background] Health check [2024-05-05 11:48:01] [index:background] Health check [2024-05-05 11:49:39] [indexer:background] Health check [2024-05-05 11:52:41] [index:background] Health check [2024-05-05 11:55:54] [indexer:background] Health check [2024-05-05 11:58:51] [index:background] Health check [2024-05-05 11:59:42] [indexer:background] Health check [2024-05-05 12:04:08] [index:background] Health check [2024-05-05 12:04:29] [indexer:background] Health check [2024-05-05 12:09:48] [index:background] Health check [2024-05-05 12:09:48] [indexer:background] Health check [2024-05-05 12:09:48] [indexer:background] Health check [2024-05-05 12:12:47] [index:background] Health check [2024-05-05 12:14:29] [indexer:background] Health check [2024-05-05 12:17:37] [index:background] Health check [2024-05-05 12:20:29] [indexer:background] Health check [2024-05-05 12:22:41] [index:background] Health check [2024-05-05 12:24:40] [indexer:background] Health check [2024-05-05 12:27:51] [index:background] Health check [2024-05-05 12:29:48] [indexer:background] Health check [2024-05-05 12:34:01] [index:background] Health check [2024-05-05 12:34:27] [indexer:background] Health check [2024-05-05 12:39:06] [index:background] Health check [2024-05-05 12:40:25] [indexer:background] Health check [2024-05-05 12:42:35] [index:background] Health check [2024-05-05 12:44:47] [indexer:background] Health check [2024-05-05 12:47:34] [index:background] Health check [2024-05-05 12:49:16] [indexer:background] Health check [2024-05-05 12:52:45] [index:background] Health check [2024-05-05 12:54:18] [indexer:background] Health check [2024-05-05 12:58:09] [index:background] Health check [2024-05-05 12:59:40] [indexer:background] Health check [2024-05-05 13:03:20] [index:background] Health check [2024-05-05 13:04:27] [indexer:background] Health check [2024-05-05 13:07:47] [index:background] Health check [2024-05-05 13:09:16] [indexer:background] Health check [2024-05-05 13:12:34] [index:background] Health check [2024-05-05 13:14:21] [indexer:background] Health check [2024-05-05 13:18:21] [index:background] Health check [2024-05-05 13:19:22] [indexer:background] Health check [2024-05-05 13:22:44] [index:background] Health check [2024-05-05 13:24:28] [indexer:background] Health check [2024-05-05 13:28:18] [index:background] Health check [2024-05-05 13:29:32] [indexer:background] Health check [2024-05-05 13:32:33] [index:background] Health check [2024-05-05 13:34:48] [indexer:background] Health check [2024-05-05 13:37:42] [index:background] Health check [2024-05-05 13:39:43] [indexer:background] Health check [2024-05-05 13:42:35] [index:background] Health check [2024-05-05 13:44:17] [indexer:background] Health check [2024-05-05 13:47:35] [index:background] Health check [2024-05-05 13:49:22] [indexer:background] Health check [2024-05-05 13:54:18] [index:background] Health check [2024-05-05 13:54:18] [indexer:background] Health check [2024-05-05 13:54:18] [indexer:background] Health check [2024-05-05 13:57:37] [index:background] Health check [2024-05-05 13:59:46] [indexer:background] Health check [2024-05-05 14:03:22] [query] Query for: 2023 [2024-05-05 14:03:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 14:03:22] [query] Engine: default [2024-05-05 14:03:23] [query] Tokens: 2023 [2024-05-05 14:03:23] [query] Mods: 6 [2024-05-05 14:03:24] [index:background] Health check [2024-05-05 14:03:24] [query] Found results using: or logic [2024-05-05 14:03: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 (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-05-05 14:03:24] [query] Results: 277 Pages of results: 28 [2024-05-05 14:03:24] [query] Execution time: 2.14211 [2024-05-05 14:03:24] [query] Query for: 2023 [2024-05-05 14:03:24] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-05-05 14:03:24] [query] Engine: default [2024-05-05 14:03:24] [query] Tokens: 2023 [2024-05-05 14:03:24] [query] Mods: 6 [2024-05-05 14:03:24] [query] Found results using: or logic [2024-05-05 14:03: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 (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100 [2024-05-05 14:03:24] [query] Results: 277 Pages of results: 3 [2024-05-05 14:03:24] [query] Execution time: 0.18627 [2024-05-05 14:05:07] [indexer:background] Health check [2024-05-05 14:07:35] [index:background] Health check [2024-05-05 14:10:58] [indexer:background] Health check [2024-05-05 14:12:39] [index:background] Health check [2024-05-05 14:14:26] [indexer:background] Health check [2024-05-05 14:18:00] [index:background] Health check [2024-05-05 14:19:17] [indexer:background] Health check [2024-05-05 14:23:03] [index:background] Health check [2024-05-05 14:24:39] [indexer:background] Health check [2024-05-05 14:28:18] [index:background] Health check [2024-05-05 14:29:15] [indexer:background] Health check [2024-05-05 14:33:12] [index:background] Health check [2024-05-05 14:34:18] [indexer:background] Health check [2024-05-05 14:37:34] [index:background] Health check [2024-05-05 14:39:21] [indexer:background] Health check [2024-05-05 14:43:49] [index:background] Health check [2024-05-05 14:44:19] [indexer:background] Health check [2024-05-05 14:48:01] [index:background] Health check [2024-05-05 14:50:05] [indexer:background] Health check [2024-05-05 14:52:41] [index:background] Health check [2024-05-05 14:55:16] [indexer:background] Health check [2024-05-05 14:57:38] [index:background] Health check [2024-05-05 15:02:41] [indexer:background] Health check [2024-05-05 15:02:41] [index:background] Health check [2024-05-05 15:04:24] [indexer:background] Health check [2024-05-05 15:08:26] [index:background] Health check [2024-05-05 15:09:30] [indexer:background] Health check [2024-05-05 15:14:15] [index:background] Health check [2024-05-05 15:14:15] [indexer:background] Health check [2024-05-05 15:14:15] [indexer:background] Health check [2024-05-05 15:19:28] [index:background] Health check [2024-05-05 15:19:28] [indexer:background] Health check [2024-05-05 15:19:28] [indexer:background] Health check [2024-05-05 15:22:39] [index:background] Health check [2024-05-05 15:25:48] [indexer:background] Health check [2024-05-05 15:28:27] [index:background] Health check [2024-05-05 15:29:18] [indexer:background] Health check [2024-05-05 15:34:09] [index:background] Health check [2024-05-05 15:36:08] [indexer:background] Health check [2024-05-05 15:37:53] [index:background] Health check [2024-05-05 15:40:31] [indexer:background] Health check [2024-05-05 15:42:35] [index:background] Health check [2024-05-05 15:47:07] [indexer:background] Health check [2024-05-05 15:47:53] [index:background] Health check [2024-05-05 15:50:18] [indexer:background] Health check [2024-05-05 15:53:35] [index:background] Health check [2024-05-05 15:55:05] [indexer:background] Health check [2024-05-05 15:57:55] [index:background] Health check [2024-05-05 15:59:52] [indexer:background] Health check [2024-05-05 16:02:57] [index:background] Health check [2024-05-05 16:04:22] [indexer:background] Health check [2024-05-05 16:08:53] [index:background] Health check [2024-05-05 16:10:29] [indexer:background] Health check [2024-05-05 16:13:02] [index:background] Health check [2024-05-05 16:15:12] [indexer:background] Health check [2024-05-05 16:18:14] [index:background] Health check [2024-05-05 16:19:23] [indexer:background] Health check [2024-05-05 16:22:46] [index:background] Health check [2024-05-05 16:26:16] [indexer:background] Health check [2024-05-05 16:28:00] [index:background] Health check [2024-05-05 16:29:43] [indexer:background] Health check [2024-05-05 16:32:38] [index:background] Health check [2024-05-05 16:34:17] [indexer:background] Health check [2024-05-05 16:38:02] [index:background] Health check [2024-05-05 16:39:29] [indexer:background] Health check [2024-05-05 16:42:35] [index:background] Health check [2024-05-05 16:44:16] [indexer:background] Health check [2024-05-05 16:47:35] [index:background] Health check [2024-05-05 16:49:17] [indexer:background] Health check [2024-05-05 16:52:40] [index:background] Health check [2024-05-05 16:54:56] [indexer:background] Health check [2024-05-05 16:57:57] [index:background] Health check [2024-05-05 16:59:24] [indexer:background] Health check [2024-05-05 17:02:42] [index:background] Health check [2024-05-05 17:05:16] [indexer:background] Health check [2024-05-05 17:10:09] [index:background] Health check [2024-05-05 17:10:09] [indexer:background] Health check [2024-05-05 17:10:09] [indexer:background] Health check [2024-05-05 17:12:46] [index:background] Health check [2024-05-05 17:14:37] [indexer:background] Health check [2024-05-05 17:18:48] [index:background] Health check [2024-05-05 17:19:40] [indexer:background] Health check [2024-05-05 17:24:34] [index:background] Health check [2024-05-05 17:24:34] [indexer:background] Health check [2024-05-05 17:24:34] [indexer:background] Health check [2024-05-05 17:28:41] [index:background] Health check [2024-05-05 17:30:19] [indexer:background] Health check [2024-05-05 17:34:37] [index:background] Health check [2024-05-05 17:34:37] [indexer:background] Health check [2024-05-05 17:34:37] [indexer:background] Health check [2024-05-05 17:39:02] [index:background] Health check [2024-05-05 17:40:14] [indexer:background] Health check [2024-05-05 17:42:44] [index:background] Health check [2024-05-05 17:44:22] [indexer:background] Health check [2024-05-05 17:49:07] [index:background] Health check [2024-05-05 17:50:03] [indexer:background] Health check [2024-05-05 17:52:56] [index:background] Health check [2024-05-05 17:55:13] [indexer:background] Health check [2024-05-05 17:58:02] [index:background] Health check [2024-05-05 18:00:04] [indexer:background] Health check [2024-05-05 18:03:17] [index:background] Health check [2024-05-05 18:04:59] [indexer:background] Health check [2024-05-05 18:08:29] [index:background] Health check [2024-05-05 18:09:27] [indexer:background] Health check [2024-05-05 18:12:53] [index:background] Health check [2024-05-05 18:14:47] [indexer:background] Health check [2024-05-05 18:17:52] [index:background] Health check [2024-05-05 18:21:00] [indexer:background] Health check [2024-05-05 18:22:42] [index:background] Health check [2024-05-05 18:25:03] [indexer:background] Health check [2024-05-05 18:27:47] [index:background] Health check [2024-05-05 18:29:28] [indexer:background] Health check [2024-05-05 18:33:00] [index:background] Health check [2024-05-05 18:35:16] [indexer:background] Health check [2024-05-05 18:38:08] [index:background] Health check [2024-05-05 18:39:18] [indexer:background] Health check [2024-05-05 18:42:43] [index:background] Health check [2024-05-05 18:45:58] [indexer:background] Health check [2024-05-05 18:48:17] [index:background] Health check [2024-05-05 18:49:38] [indexer:background] Health check [2024-05-05 18:53:28] [index:background] Health check [2024-05-05 18:54:51] [indexer:background] Health check [2024-05-05 18:57:55] [index:background] Health check [2024-05-05 18:59:53] [indexer:background] Health check [2024-05-05 19:04:09] [index:background] Health check [2024-05-05 19:04:24] [indexer:background] Health check [2024-05-05 19:08:44] [index:background] Health check [2024-05-05 19:09:49] [indexer:background] Health check [2024-05-05 19:13:16] [index:background] Health check [2024-05-05 19:14:30] [indexer:background] Health check [2024-05-05 19:17:59] [index:background] Health check [2024-05-05 19:19:30] [indexer:background] Health check [2024-05-05 19:22:33] [index:background] Health check [2024-05-05 19:25:34] [indexer:background] Health check [2024-05-05 19:27:49] [index:background] Health check [2024-05-05 19:30:04] [indexer:background] Health check [2024-05-05 19:33:42] [index:background] Health check [2024-05-05 19:34:41] [indexer:background] Health check [2024-05-05 19:39:10] [index:background] Health check [2024-05-05 19:39:49] [query] Query for: 2023 [2024-05-05 19:39:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 19:39:49] [query] Engine: default [2024-05-05 19:39:50] [indexer:background] Health check [2024-05-05 19:39:51] [query] Tokens: 2023 [2024-05-05 19:39:51] [query] Mods: 6 [2024-05-05 19:39:51] [query] Found results using: or logic [2024-05-05 19:39:51] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-05-05 19:39:51] [query] Results: 277 Pages of results: 28 [2024-05-05 19:39:51] [query] Execution time: 1.82925 [2024-05-05 19:42:35] [index:background] Health check [2024-05-05 19:45:39] [indexer:background] Health check [2024-05-05 19:50:56] [index:background] Health check [2024-05-05 19:50:56] [indexer:background] Health check [2024-05-05 19:50:56] [indexer:background] Health check [2024-05-05 19:53:08] [index:background] Health check [2024-05-05 19:54:51] [indexer:background] Health check [2024-05-05 19:58:11] [index:background] Health check [2024-05-05 20:00:00] [indexer:background] Health check [2024-05-05 20:03:12] [index:background] Health check [2024-05-05 20:04:36] [indexer:background] Health check [2024-05-05 20:08:28] [index:background] Health check [2024-05-05 20:10:03] [indexer:background] Health check [2024-05-05 20:12:42] [index:background] Health check [2024-05-05 20:15:10] [indexer:background] Health check [2024-05-05 20:17:47] [index:background] Health check [2024-05-05 20:19:51] [indexer:background] Health check [2024-05-05 20:22:44] [index:background] Health check [2024-05-05 20:24:52] [indexer:background] Health check [2024-05-05 20:27:35] [index:background] Health check [2024-05-05 20:29:25] [indexer:background] Health check [2024-05-05 20:33:01] [index:background] Health check [2024-05-05 20:34:57] [indexer:background] Health check [2024-05-05 20:38:34] [index:background] Health check [2024-05-05 20:39:17] [indexer:background] Health check [2024-05-05 20:42:35] [index:background] Health check [2024-05-05 20:44:40] [indexer:background] Health check [2024-05-05 20:48:31] [index:background] Health check [2024-05-05 20:50:16] [indexer:background] Health check [2024-05-05 20:53:00] [index:background] Health check [2024-05-05 20:56:37] [indexer:background] Health check [2024-05-05 20:59:07] [index:background] Health check [2024-05-05 21:00:38] [indexer:background] Health check [2024-05-05 21:02:49] [index:background] Health check [2024-05-05 21:05:12] [indexer:background] Health check [2024-05-05 21:09:34] [index:background] Health check [2024-05-05 21:09:34] [indexer:background] Health check [2024-05-05 21:09:34] [indexer:background] Health check [2024-05-05 21:12:53] [index:background] Health check [2024-05-05 21:15:32] [indexer:background] Health check [2024-05-05 21:18:12] [index:background] Health check [2024-05-05 21:19:43] [indexer:background] Health check [2024-05-05 21:22:34] [index:background] Health check [2024-05-05 21:25:21] [indexer:background] Health check [2024-05-05 21:31:34] [index:background] Health check [2024-05-05 21:31:34] [indexer:background] Health check [2024-05-05 21:31:35] [indexer:background] Health check [2024-05-05 21:32:55] [index:background] Health check [2024-05-05 21:34:21] [indexer:background] Health check [2024-05-05 21:38:06] [index:background] Health check [2024-05-05 21:39:25] [indexer:background] Health check [2024-05-05 21:42:34] [index:background] Health check [2024-05-05 21:44:16] [indexer:background] Health check [2024-05-05 21:48:12] [index:background] Health check [2024-05-05 21:49:19] [indexer:background] Health check [2024-05-05 21:53:47] [index:background] Health check [2024-05-05 21:55:36] [indexer:background] Health check [2024-05-05 21:57:50] [index:background] Health check [2024-05-05 21:59:47] [indexer:background] Health check [2024-05-05 22:03:54] [index:background] Health check [2024-05-05 22:05:36] [indexer:background] Health check [2024-05-05 22:09:44] [index:background] Health check [2024-05-05 22:09:45] [indexer:background] Health check [2024-05-05 22:09:45] [indexer:background] Health check [2024-05-05 22:13:12] [index:background] Health check [2024-05-05 22:14:17] [indexer:background] Health check [2024-05-05 22:18:21] [index:background] Health check [2024-05-05 22:19:22] [indexer:background] Health check [2024-05-05 22:23:27] [index:background] Health check [2024-05-05 22:24:20] [indexer:background] Health check [2024-05-05 22:28:31] [index:background] Health check [2024-05-05 22:29:32] [indexer:background] Health check [2024-05-05 22:32:34] [index:background] Health check [2024-05-05 22:34:37] [indexer:background] Health check [2024-05-05 22:38:37] [index:background] Health check [2024-05-05 22:38:38] [index:background] Health check [2024-05-05 22:39:19] [indexer:background] Health check [2024-05-05 22:42:36] [index:background] Health check [2024-05-05 22:44:18] [indexer:background] Health check [2024-05-05 22:47:51] [index:background] Health check [2024-05-05 22:49:52] [indexer:background] Health check [2024-05-05 22:52:56] [index:background] Health check [2024-05-05 22:54:52] [indexer:background] Health check [2024-05-05 22:58:01] [index:background] Health check [2024-05-05 23:00:03] [indexer:background] Health check [2024-05-05 23:03:06] [index:background] Health check [2024-05-05 23:04:24] [indexer:background] Health check [2024-05-05 23:07:13] [query] Query for: 2024 [2024-05-05 23:07:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-05-05 23:07:13] [query] Engine: default [2024-05-05 23:07:15] [query] Tokens: 2024 [2024-05-05 23:07:15] [query] Mods: 6 [2024-05-05 23:07:16] [query] Found results using: or logic [2024-05-05 23:07:16] [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-05-05 23:07:16] [query] Results: 155 Pages of results: 16 [2024-05-05 23:07:16] [query] Execution time: 2.12605 [2024-05-05 23:07:16] [query] Query for: 2024 [2024-05-05 23:07:16] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all [2024-05-05 23:07:16] [query] Engine: default [2024-05-05 23:07:16] [query] Tokens: 2024 [2024-05-05 23:07:16] [query] Mods: 6 [2024-05-05 23:07:16] [query] Found results using: or logic [2024-05-05 23:07:16] [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-05-05 23:07:16] [query] Results: 155 Pages of results: 2 [2024-05-05 23:07:16] [query] Execution time: 0.16413 [2024-05-05 23:09:26] [index:background] Health check [2024-05-05 23:09:27] [indexer:background] Health check [2024-05-05 23:09:27] [indexer:background] Health check [2024-05-05 23:12:36] [index:background] Health check [2024-05-05 23:14:44] [indexer:background] Health check [2024-05-05 23:17:49] [index:background] Health check [2024-05-05 23:20:35] [indexer:background] Health check [2024-05-05 23:22:49] [index:background] Health check [2024-05-05 23:25:10] [indexer:background] Health check [2024-05-05 23:27:35] [index:background] Health check [2024-05-05 23:29:40] [indexer:background] Health check [2024-05-05 23:32:41] [index:background] Health check [2024-05-05 23:35:07] [indexer:background] Health check [2024-05-05 23:38:41] [index:background] Health check [2024-05-05 23:40:10] [indexer:background] Health check [2024-05-05 23:42:53] [index:background] Health check [2024-05-05 23:44:17] [indexer:background] Health check [2024-05-05 23:47:39] [index:background] Health check [2024-05-05 23:49:30] [indexer:background] Health check [2024-05-05 23:54:04] [index:background] Health check [2024-05-05 23:55:26] [indexer:background] Health check [2024-05-05 23:57:54] [index:background] Health check [2024-05-05 23:59:46] [indexer:background] Health check