[2024-04-23 00:03:38] [index:background] Health check
[2024-04-23 00:04:19] [indexer:background] Health check
[2024-04-23 00:07:37] [index:background] Health check
[2024-04-23 00:09:18] [indexer:background] Health check
[2024-04-23 00:12:39] [index:background] Health check
[2024-04-23 00:14:21] [indexer:background] Health check
[2024-04-23 00:17:34] [index:background] Health check
[2024-04-23 00:19:21] [indexer:background] Health check
[2024-04-23 00:22:38] [index:background] Health check
[2024-04-23 00:24:18] [indexer:background] Health check
[2024-04-23 00:27:35] [index:background] Health check
[2024-04-23 00:29:21] [indexer:background] Health check
[2024-04-23 00:32:40] [index:background] Health check
[2024-04-23 00:34:17] [indexer:background] Health check
[2024-04-23 00:37:41] [index:background] Health check
[2024-04-23 00:39:17] [indexer:background] Health check
[2024-04-23 00:43:43] [index:background] Health check
[2024-04-23 00:44:24] [indexer:background] Health check
[2024-04-23 00:47:38] [index:background] Health check
[2024-04-23 00:49:27] [indexer:background] Health check
[2024-04-23 00:52:44] [index:background] Health check
[2024-04-23 00:54:19] [indexer:background] Health check
[2024-04-23 00:57:40] [index:background] Health check
[2024-04-23 00:59:16] [indexer:background] Health check
[2024-04-23 01:02:36] [index:background] Health check
[2024-04-23 01:04:18] [indexer:background] Health check
[2024-04-23 01:07:39] [index:background] Health check
[2024-04-23 01:09:20] [indexer:background] Health check
[2024-04-23 01:12:36] [index:background] Health check
[2024-04-23 01:14:19] [indexer:background] Health check
[2024-04-23 01:17:39] [index:background] Health check
[2024-04-23 01:19:19] [indexer:background] Health check
[2024-04-23 01:22:36] [index:background] Health check
[2024-04-23 01:24:22] [indexer:background] Health check
[2024-04-23 01:27:37] [index:background] Health check
[2024-04-23 01:29:20] [indexer:background] Health check
[2024-04-23 01:32:38] [index:background] Health check
[2024-04-23 01:34:18] [indexer:background] Health check
[2024-04-23 01:37:40] [index:background] Health check
[2024-04-23 01:39:19] [indexer:background] Health check
[2024-04-23 01:42:43] [index:background] Health check
[2024-04-23 01:44:18] [indexer:background] Health check
[2024-04-23 01:47:43] [index:background] Health check
[2024-04-23 01:50:25] [indexer:background] Health check
[2024-04-23 01:52:41] [index:background] Health check
[2024-04-23 01:54:09] [query] Query for: 2025
[2024-04-23 01:54:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 01:54:09] [query] Engine: default
[2024-04-23 01:54:09] [query] Tokens: 2025
[2024-04-23 01:54:09] [query] Mods: 6
[2024-04-23 01:54:09] [query] Found results using: or logic
[2024-04-23 01:54: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 (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-04-23 01:54:09] [query] Results: 138 Pages of results: 14
[2024-04-23 01:54:09] [query] Execution time: 0.62910
[2024-04-23 01:54:16] [indexer:background] Health check
[2024-04-23 01:57:39] [index:background] Health check
[2024-04-23 01:59:27] [indexer:background] Health check
[2024-04-23 02:02:39] [index:background] Health check
[2024-04-23 02:04:20] [indexer:background] Health check
[2024-04-23 02:07:38] [index:background] Health check
[2024-04-23 02:09:22] [indexer:background] Health check
[2024-04-23 02:12:48] [index:background] Health check
[2024-04-23 02:14:22] [indexer:background] Health check
[2024-04-23 02:14:51] [query] Query for: 2025
[2024-04-23 02:14:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 02:14:51] [query] Engine: default
[2024-04-23 02:14:51] [query] Tokens: 2025
[2024-04-23 02:14:51] [query] Mods: 6
[2024-04-23 02:14:51] [query] Found results using: or logic
[2024-04-23 02:14: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 (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-04-23 02:14:51] [query] Results: 138 Pages of results: 14
[2024-04-23 02:14:51] [query] Execution time: 0.17639
[2024-04-23 02:14:51] [query] Query for: 2025
[2024-04-23 02:14:51] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-23 02:14:51] [query] Engine: default
[2024-04-23 02:14:51] [query] Tokens: 2025
[2024-04-23 02:14:51] [query] Mods: 6
[2024-04-23 02:14:51] [query] Found results using: or logic
[2024-04-23 02:14: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 (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-04-23 02:14:51] [query] Results: 138 Pages of results: 2
[2024-04-23 02:14:51] [query] Execution time: 0.14470
[2024-04-23 02:17:37] [index:background] Health check
[2024-04-23 02:19:31] [indexer:background] Health check
[2024-04-23 02:22:35] [index:background] Health check
[2024-04-23 02:24:47] [indexer:background] Health check
[2024-04-23 02:27:34] [index:background] Health check
[2024-04-23 02:29:20] [indexer:background] Health check
[2024-04-23 02:32:42] [index:background] Health check
[2024-04-23 02:34:25] [indexer:background] Health check
[2024-04-23 02:37:41] [index:background] Health check
[2024-04-23 02:39:30] [indexer:background] Health check
[2024-04-23 02:42:39] [index:background] Health check
[2024-04-23 02:44:24] [indexer:background] Health check
[2024-04-23 02:47:41] [index:background] Health check
[2024-04-23 02:49:22] [indexer:background] Health check
[2024-04-23 02:52:45] [index:background] Health check
[2024-04-23 02:54:18] [indexer:background] Health check
[2024-04-23 02:57:46] [index:background] Health check
[2024-04-23 02:59:21] [indexer:background] Health check
[2024-04-23 03:02:46] [index:background] Health check
[2024-04-23 03:04:24] [indexer:background] Health check
[2024-04-23 03:07:39] [index:background] Health check
[2024-04-23 03:09:19] [indexer:background] Health check
[2024-04-23 03:12:37] [index:background] Health check
[2024-04-23 03:14:21] [indexer:background] Health check
[2024-04-23 03:17:35] [index:background] Health check
[2024-04-23 03:19:19] [indexer:background] Health check
[2024-04-23 03:22:40] [index:background] Health check
[2024-04-23 03:24:17] [indexer:background] Health check
[2024-04-23 03:27:38] [index:background] Health check
[2024-04-23 03:29:21] [indexer:background] Health check
[2024-04-23 03:32:35] [index:background] Health check
[2024-04-23 03:32:35] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2]
[2024-04-23 03:34:23] [indexer:background] Health check
[2024-04-23 03:37:39] [index:background] Health check
[2024-04-23 03:39:19] [indexer:background] Health check
[2024-04-23 03:42:45] [index:background] Health check
[2024-04-23 03:44:22] [indexer:background] Health check
[2024-04-23 03:47:41] [index:background] Health check
[2024-04-23 03:49:18] [indexer:background] Health check
[2024-04-23 03:52:43] [index:background] Health check
[2024-04-23 03:54:24] [indexer:background] Health check
[2024-04-23 03:57:40] [index:background] Health check
[2024-04-23 03:59:20] [indexer:background] Health check
[2024-04-23 04:02:44] [index:background] Health check
[2024-04-23 04:04:22] [indexer:background] Health check
[2024-04-23 04:07:55] [index:background] Health check
[2024-04-23 04:09:22] [indexer:background] Health check
[2024-04-23 04:12:35] [index:background] Health check
[2024-04-23 04:14:22] [indexer:background] Health check
[2024-04-23 04:17:37] [index:background] Health check
[2024-04-23 04:19:24] [indexer:background] Health check
[2024-04-23 04:22:35] [index:background] Health check
[2024-04-23 04:24:16] [indexer:background] Health check
[2024-04-23 04:32:04] [index:background] Health check
[2024-04-23 04:32:05] [indexer:background] Health check
[2024-04-23 04:32:05] [indexer:background] Health check
[2024-04-23 04:33:48] [index:background] Health check
[2024-04-23 04:37:05] [indexer:background] Health check
[2024-04-23 04:38:00] [index:background] Health check
[2024-04-23 04:39:21] [indexer:background] Health check
[2024-04-23 04:39:25] [query] Query for: 2023
[2024-04-23 04:39:25] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 04:39:25] [query] Engine: default
[2024-04-23 04:39:26] [query] Tokens: 2023
[2024-04-23 04:39:26] [query] Mods: 6
[2024-04-23 04:39:26] [query] Found results using: or logic
[2024-04-23 04:39:26] [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-04-23 04:39:26] [query] Results: 273 Pages of results: 28
[2024-04-23 04:39:26] [query] Execution time: 0.24715
[2024-04-23 04:39:29] [query] Query for: 2024
[2024-04-23 04:39:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 04:39:29] [query] Engine: default
[2024-04-23 04:39:29] [query] Tokens: 2024
[2024-04-23 04:39:29] [query] Mods: 6
[2024-04-23 04:39:29] [query] Found results using: or logic
[2024-04-23 04:39:29] [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-04-23 04:39:29] [query] Results: 151 Pages of results: 16
[2024-04-23 04:39:29] [query] Execution time: 0.16250
[2024-04-23 04:43:19] [index:background] Health check
[2024-04-23 04:48:31] [indexer:background] Health check
[2024-04-23 04:48:32] [index:background] Health check
[2024-04-23 04:50:33] [indexer:background] Health check
[2024-04-23 04:54:06] [index:background] Health check
[2024-04-23 04:56:51] [indexer:background] Health check
[2024-04-23 04:57:46] [index:background] Health check
[2024-04-23 04:59:18] [indexer:background] Health check
[2024-04-23 05:02:48] [index:background] Health check
[2024-04-23 05:06:11] [indexer:background] Health check
[2024-04-23 05:07:34] [index:background] Health check
[2024-04-23 05:13:14] [indexer:background] Health check
[2024-04-23 05:13:14] [index:background] Health check
[2024-04-23 05:14:47] [indexer:background] Health check
[2024-04-23 05:18:33] [index:background] Health check
[2024-04-23 05:19:57] [indexer:background] Health check
[2024-04-23 05:23:29] [index:background] Health check
[2024-04-23 05:24:48] [indexer:background] Health check
[2024-04-23 05:27:51] [index:background] Health check
[2024-04-23 05:29:16] [indexer:background] Health check
[2024-04-23 05:34:43] [index:background] Health check
[2024-04-23 05:34:44] [indexer:background] Health check
[2024-04-23 05:34:44] [indexer:background] Health check
[2024-04-23 05:37:42] [index:background] Health check
[2024-04-23 05:39:17] [indexer:background] Health check
[2024-04-23 05:43:14] [index:background] Health check
[2024-04-23 05:44:32] [indexer:background] Health check
[2024-04-23 05:48:43] [index:background] Health check
[2024-04-23 05:49:54] [indexer:background] Health check
[2024-04-23 05:53:02] [index:background] Health check
[2024-04-23 05:54:21] [indexer:background] Health check
[2024-04-23 05:57:43] [index:background] Health check
[2024-04-23 05:59:59] [indexer:background] Health check
[2024-04-23 06:02:36] [index:background] Health check
[2024-04-23 06:04:45] [indexer:background] Health check
[2024-04-23 06:06:00] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2024-04-23 06:06:00] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 06:06:00] [query] Engine: default
[2024-04-23 06:06:00] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2024-04-23 06:06:00] [query] Mods: 6
[2024-04-23 06:06:00] [query] Using OR logic
[2024-04-23 06:06:00] [query] Found results using: or logic
[2024-04-23 06:06:00] [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-04-23 06:06:00] [query] Results: 905 Pages of results: 91
[2024-04-23 06:06:00] [query] Execution time: 0.70422
[2024-04-23 06:08:09] [index:background] Health check
[2024-04-23 06:09:35] [indexer:background] Health check
[2024-04-23 06:13:18] [index:background] Health check
[2024-04-23 06:14:46] [indexer:background] Health check
[2024-04-23 06:17:49] [index:background] Health check
[2024-04-23 06:19:53] [indexer:background] Health check
[2024-04-23 06:22:47] [index:background] Health check
[2024-04-23 06:24:49] [indexer:background] Health check
[2024-04-23 06:27:58] [index:background] Health check
[2024-04-23 06:29:45] [indexer:background] Health check
[2024-04-23 06:32:51] [index:background] Health check
[2024-04-23 06:34:30] [indexer:background] Health check
[2024-04-23 06:37:46] [index:background] Health check
[2024-04-23 06:39:22] [indexer:background] Health check
[2024-04-23 06:39:29] [query] Query for: {search_term_string}
[2024-04-23 06:39:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 132 offset: 0 fields: all
[2024-04-23 06:39:29] [query] Engine: default
[2024-04-23 06:39:29] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-23 06:39:29] [query] Mods: 6
[2024-04-23 06:39:29] [query] Using OR logic
[2024-04-23 06:39:30] [query] Found results using: or logic
[2024-04-23 06:39:30] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 1310, 10
[2024-04-23 06:39:30] [query] Results: 1361 Pages of results: 137
[2024-04-23 06:39:30] [query] Execution time: 0.93370
[2024-04-23 06:42:52] [index:background] Health check
[2024-04-23 06:44:16] [indexer:background] Health check
[2024-04-23 06:47:54] [index:background] Health check
[2024-04-23 06:49:32] [indexer:background] Health check
[2024-04-23 06:50:59] [query] Query for: 🎵 order keftab 250 mg 👴 www.healspill.online - uses dosage 🎵order 750 125
[2024-04-23 06:50:59] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 06:50:59] [query] Engine: default
[2024-04-23 06:50:59] [query] Tokens: dosage, online, uses, usees, order, 250, www, use, 🎵 keftab 👴 healspill
[2024-04-23 06:50:59] [query] Mods: 6
[2024-04-23 06:50:59] [query] Using OR logic
[2024-04-23 06:50:59] [query] Found results using: or logic
[2024-04-23 06:50:59] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-04-23 06:50:59] [query] Results: 905 Pages of results: 91
[2024-04-23 06:50:59] [query] Execution time: 0.54634
[2024-04-23 06:52:57] [index:background] Health check
[2024-04-23 06:56:31] [indexer:background] Health check
[2024-04-23 06:57:53] [index:background] Health check
[2024-04-23 06:59:17] [indexer:background] Health check
[2024-04-23 07:02:42] [index:background] Health check
[2024-04-23 07:04:22] [indexer:background] Health check
[2024-04-23 07:07:44] [index:background] Health check
[2024-04-23 07:09:21] [indexer:background] Health check
[2024-04-23 07:12:53] [index:background] Health check
[2024-04-23 07:14:30] [indexer:background] Health check
[2024-04-23 07:17:41] [index:background] Health check
[2024-04-23 07:19:29] [indexer:background] Health check
[2024-04-23 07:22:35] [index:background] Health check
[2024-04-23 07:25:11] [indexer:background] Health check
[2024-04-23 07:27:39] [index:background] Health check
[2024-04-23 07:29:20] [indexer:background] Health check
[2024-04-23 07:33:33] [index:background] Health check
[2024-04-23 07:34:34] [indexer:background] Health check
[2024-04-23 07:37:53] [index:background] Health check
[2024-04-23 07:39:21] [indexer:background] Health check
[2024-04-23 07:39:48] [query] Query for: {search_term_string}
[2024-04-23 07:39:48] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 133 offset: 0 fields: all
[2024-04-23 07:39:48] [query] Engine: default
[2024-04-23 07:39:48] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-23 07:39:48] [query] Mods: 6
[2024-04-23 07:39:48] [query] Using OR logic
[2024-04-23 07:39:49] [query] Found results using: or logic
[2024-04-23 07:39:49] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 1320, 10
[2024-04-23 07:39:49] [query] Results: 1361 Pages of results: 137
[2024-04-23 07:39:49] [query] Execution time: 0.84961
[2024-04-23 07:42:36] [index:background] Health check
[2024-04-23 07:44:26] [indexer:background] Health check
[2024-04-23 07:47:47] [index:background] Health check
[2024-04-23 07:49:46] [indexer:background] Health check
[2024-04-23 07:53:09] [index:background] Health check
[2024-04-23 07:54:16] [indexer:background] Health check
[2024-04-23 07:58:03] [index:background] Health check
[2024-04-23 07:59:33] [indexer:background] Health check
[2024-04-23 08:03:07] [index:background] Health check
[2024-04-23 08:05:03] [indexer:background] Health check
[2024-04-23 08:09:41] [index:background] Health check
[2024-04-23 08:09:41] [indexer:background] Health check
[2024-04-23 08:09:41] [indexer:background] Health check
[2024-04-23 08:12:47] [index:background] Health check
[2024-04-23 08:14:34] [indexer:background] Health check
[2024-04-23 08:18:20] [index:background] Health check
[2024-04-23 08:19:23] [indexer:background] Health check
[2024-04-23 08:19:23] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2024-04-23 08:22:42] [index:background] Health check
[2024-04-23 08:25:18] [indexer:background] Health check
[2024-04-23 08:28:34] [index:background] Health check
[2024-04-23 08:30:02] [indexer:background] Health check
[2024-04-23 08:32:55] [index:background] Health check
[2024-04-23 08:34:16] [indexer:background] Health check
[2024-04-23 08:37:37] [index:background] Health check
[2024-04-23 08:39:21] [query] Query for: 2023
[2024-04-23 08:39:21] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 08:39:21] [query] Engine: default
[2024-04-23 08:39:21] [query] Tokens: 2023
[2024-04-23 08:39:21] [query] Mods: 6
[2024-04-23 08:39:21] [query] Found results using: or logic
[2024-04-23 08:39:21] [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-04-23 08:39:21] [query] Results: 273 Pages of results: 28
[2024-04-23 08:39:21] [query] Execution time: 0.31008
[2024-04-23 08:39:21] [indexer:background] Health check
[2024-04-23 08:43:08] [index:background] Health check
[2024-04-23 08:44:39] [indexer:background] Health check
[2024-04-23 08:47:39] [index:background] Health check
[2024-04-23 08:49:29] [indexer:background] Health check
[2024-04-23 08:53:00] [index:background] Health check
[2024-04-23 08:54:23] [indexer:background] Health check
[2024-04-23 08:58:24] [index:background] Health check
[2024-04-23 08:59:33] [indexer:background] Health check
[2024-04-23 09:02:47] [index:background] Health check
[2024-04-23 09:04:47] [indexer:background] Health check
[2024-04-23 09:07:44] [index:background] Health check
[2024-04-23 09:09:25] [indexer:background] Health check
[2024-04-23 09:12:33] [index:background] Health check
[2024-04-23 09:14:25] [indexer:background] Health check
[2024-04-23 09:18:31] [index:background] Health check
[2024-04-23 09:19:45] [indexer:background] Health check
[2024-04-23 09:22:33] [index:background] Health check
[2024-04-23 09:24:32] [indexer:background] Health check
[2024-04-23 09:28:06] [index:background] Health check
[2024-04-23 09:29:20] [indexer:background] Health check
[2024-04-23 09:32:48] [index:background] Health check
[2024-04-23 09:34:39] [indexer:background] Health check
[2024-04-23 09:37:36] [index:background] Health check
[2024-04-23 09:39:42] [indexer:background] Health check
[2024-04-23 09:43:13] [index:background] Health check
[2024-04-23 09:44:36] [indexer:background] Health check
[2024-04-23 09:47:55] [index:background] Health check
[2024-04-23 09:49:17] [indexer:background] Health check
[2024-04-23 09:52:44] [index:background] Health check
[2024-04-23 09:55:17] [indexer:background] Health check
[2024-04-23 09:57:46] [index:background] Health check
[2024-04-23 09:59:49] [indexer:background] Health check
[2024-04-23 10:02:59] [index:background] Health check
[2024-04-23 10:04:17] [indexer:background] Health check
[2024-04-23 10:07:53] [index:background] Health check
[2024-04-23 10:09:58] [indexer:background] Health check
[2024-04-23 10:12:38] [index:background] Health check
[2024-04-23 10:14:19] [indexer:background] Health check
[2024-04-23 10:17:57] [index:background] Health check
[2024-04-23 10:19:18] [indexer:background] Health check
[2024-04-23 10:24:21] [index:background] Health check
[2024-04-23 10:24:21] [indexer:background] Health check
[2024-04-23 10:24:22] [indexer:background] Health check
[2024-04-23 10:28:35] [index:background] Health check
[2024-04-23 10:29:34] [indexer:background] Health check
[2024-04-23 10:32:47] [index:background] Health check
[2024-04-23 10:34:28] [indexer:background] Health check
[2024-04-23 10:37:40] [index:background] Health check
[2024-04-23 10:39:19] [indexer:background] Health check
[2024-04-23 10:42:35] [index:background] Health check
[2024-04-23 10:44:19] [indexer:background] Health check
[2024-04-23 10:48:07] [index:background] Health check
[2024-04-23 10:49:53] [indexer:background] Health check
[2024-04-23 10:52:42] [index:background] Health check
[2024-04-23 10:55:11] [indexer:background] Health check
[2024-04-23 10:57:42] [index:background] Health check
[2024-04-23 10:59:49] [indexer:background] Health check
[2024-04-23 11:02:40] [index:background] Health check
[2024-04-23 11:05:11] [indexer:background] Health check
[2024-04-23 11:08:13] [index:background] Health check
[2024-04-23 11:09:39] [indexer:background] Health check
[2024-04-23 11:13:31] [index:background] Health check
[2024-04-23 11:14:34] [indexer:background] Health check
[2024-04-23 11:17:50] [index:background] Health check
[2024-04-23 11:19:46] [indexer:background] Health check
[2024-04-23 11:22:54] [index:background] Health check
[2024-04-23 11:24:33] [indexer:background] Health check
[2024-04-23 11:27:37] [index:background] Health check
[2024-04-23 11:27:37] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2024-04-23 11:27:39] [indexer:background] CPU load threshold (3) breached: 3.73 [waiting 2]
[2024-04-23 11:29:22] [indexer:background] Health check
[2024-04-23 11:32:56] [index:background] Health check
[2024-04-23 11:34:27] [indexer:background] Health check
[2024-04-23 11:38:32] [index:background] Health check
[2024-04-23 11:40:28] [indexer:background] Health check
[2024-04-23 11:42:51] [index:background] Health check
[2024-04-23 11:44:37] [indexer:background] Health check
[2024-04-23 11:48:49] [index:background] Health check
[2024-04-23 11:49:16] [indexer:background] Health check
[2024-04-23 11:53:01] [index:background] Health check
[2024-04-23 11:54:25] [indexer:background] Health check
[2024-04-23 11:57:47] [index:background] Health check
[2024-04-23 11:59:34] [indexer:background] Health check
[2024-04-23 12:02:47] [index:background] Health check
[2024-04-23 12:04:35] [indexer:background] Health check
[2024-04-23 12:08:16] [index:background] Health check
[2024-04-23 12:09:49] [indexer:background] Health check
[2024-04-23 12:12:37] [index:background] Health check
[2024-04-23 12:14:32] [indexer:background] Health check
[2024-04-23 12:18:45] [index:background] Health check
[2024-04-23 12:19:18] [indexer:background] Health check
[2024-04-23 12:23:00] [index:background] Health check
[2024-04-23 12:24:46] [indexer:background] Health check
[2024-04-23 12:27:36] [index:background] Health check
[2024-04-23 12:29:16] [indexer:background] Health check
[2024-04-23 12:32:34] [index:background] Health check
[2024-04-23 12:34:19] [indexer:background] Health check
[2024-04-23 12:37:58] [index:background] Health check
[2024-04-23 12:39:24] [indexer:background] Health check
[2024-04-23 12:42:37] [index:background] Health check
[2024-04-23 12:44:34] [indexer:background] Health check
[2024-04-23 12:47:49] [index:background] Health check
[2024-04-23 12:52:19] [indexer:background] Health check
[2024-04-23 12:52:54] [index:background] Health check
[2024-04-23 12:54:48] [indexer:background] Health check
[2024-04-23 12:58:01] [index:background] Health check
[2024-04-23 12:59:44] [indexer:background] Health check
[2024-04-23 13:02:52] [index:background] Health check
[2024-04-23 13:04:22] [indexer:background] Health check
[2024-04-23 13:08:06] [index:background] Health check
[2024-04-23 13:10:13] [indexer:background] Health check
[2024-04-23 13:12:35] [index:background] Health check
[2024-04-23 13:14:28] [indexer:background] Health check
[2024-04-23 13:19:56] [index:background] Health check
[2024-04-23 13:19:59] [indexer:background] Health check
[2024-04-23 13:19:59] [indexer:background] Health check
[2024-04-23 13:22:52] [index:background] Health check
[2024-04-23 13:24:17] [indexer:background] Health check
[2024-04-23 13:28:30] [index:background] Health check
[2024-04-23 13:29:26] [indexer:background] Health check
[2024-04-23 13:32:48] [index:background] Health check
[2024-04-23 13:35:13] [indexer:background] Health check
[2024-04-23 13:37:57] [index:background] Health check
[2024-04-23 13:40:10] [indexer:background] Health check
[2024-04-23 13:43:35] [index:background] Health check
[2024-04-23 13:44:34] [indexer:background] Health check
[2024-04-23 13:48:04] [index:background] Health check
[2024-04-23 13:49:27] [indexer:background] Health check
[2024-04-23 13:52:38] [index:background] Health check
[2024-04-23 13:54:27] [indexer:background] Health check
[2024-04-23 13:57:34] [index:background] Health check
[2024-04-23 13:59:19] [indexer:background] Health check
[2024-04-23 14:02:51] [index:background] Health check
[2024-04-23 14:04:40] [indexer:background] Health check
[2024-04-23 14:07:41] [index:background] Health check
[2024-04-23 14:09:23] [indexer:background] Health check
[2024-04-23 14:12:38] [index:background] Health check
[2024-04-23 14:14:25] [indexer:background] Health check
[2024-04-23 14:18:18] [index:background] Health check
[2024-04-23 14:19:18] [indexer:background] Health check
[2024-04-23 14:22:37] [index:background] Health check
[2024-04-23 14:24:24] [indexer:background] Health check
[2024-04-23 14:28:00] [index:background] Health check
[2024-04-23 14:29:26] [indexer:background] Health check
[2024-04-23 14:32:35] [index:background] Health check
[2024-04-23 14:34:31] [indexer:background] Health check
[2024-04-23 14:37:35] [query] Query for: 2024
[2024-04-23 14:37:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 14:37:35] [query] Engine: default
[2024-04-23 14:37:36] [index:background] Health check
[2024-04-23 14:37:36] [query] Tokens: 2024
[2024-04-23 14:37:36] [query] Mods: 6
[2024-04-23 14:37:36] [query] Found results using: or logic
[2024-04-23 14:37:36] [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-04-23 14:37:36] [query] Results: 151 Pages of results: 16
[2024-04-23 14:37:36] [query] Execution time: 1.19081
[2024-04-23 14:39:21] [indexer:background] Health check
[2024-04-23 14:42:59] [index:background] Health check
[2024-04-23 14:44:30] [indexer:background] Health check
[2024-04-23 14:48:12] [index:background] Health check
[2024-04-23 14:49:26] [indexer:background] Health check
[2024-04-23 14:52:38] [index:background] Health check
[2024-04-23 14:54:18] [indexer:background] Health check
[2024-04-23 14:57:41] [index:background] Health check
[2024-04-23 14:59:41] [indexer:background] Health check
[2024-04-23 15:02:36] [index:background] Health check
[2024-04-23 15:04:32] [indexer:background] Health check
[2024-04-23 15:07:48] [index:background] Health check
[2024-04-23 15:09:22] [indexer:background] Health check
[2024-04-23 15:10:47] [query] Query for: 2024
[2024-04-23 15:10:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 15:10:47] [query] Engine: default
[2024-04-23 15:10:48] [query] Tokens: 2024
[2024-04-23 15:10:48] [query] Mods: 6
[2024-04-23 15:10:48] [query] Found results using: or logic
[2024-04-23 15:10: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 (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-04-23 15:10:48] [query] Results: 151 Pages of results: 16
[2024-04-23 15:10:48] [query] Execution time: 0.38622
[2024-04-23 15:12:39] [index:background] Health check
[2024-04-23 15:14:36] [indexer:background] Health check
[2024-04-23 15:17:35] [index:background] Health check
[2024-04-23 15:19:29] [indexer:background] Health check
[2024-04-23 15:22:35] [index:background] Health check
[2024-04-23 15:24:18] [indexer:background] Health check
[2024-04-23 15:28:03] [index:background] Health check
[2024-04-23 15:29:22] [indexer:background] Health check
[2024-04-23 15:32:58] [index:background] Health check
[2024-04-23 15:34:16] [indexer:background] Health check
[2024-04-23 15:37:54] [index:background] Health check
[2024-04-23 15:39:23] [indexer:background] Health check
[2024-04-23 15:44:05] [index:background] Health check
[2024-04-23 15:45:16] [indexer:background] Health check
[2024-04-23 15:48:29] [index:background] Health check
[2024-04-23 15:49:17] [indexer:background] Health check
[2024-04-23 15:52:48] [index:background] Health check
[2024-04-23 15:55:03] [indexer:background] Health check
[2024-04-23 15:57:40] [index:background] Health check
[2024-04-23 15:59:19] [indexer:background] Health check
[2024-04-23 16:02:45] [index:background] Health check
[2024-04-23 16:06:02] [indexer:background] Health check
[2024-04-23 16:07:43] [index:background] Health check
[2024-04-23 16:09:17] [indexer:background] Health check
[2024-04-23 16:13:21] [index:background] Health check
[2024-04-23 16:16:16] [indexer:background] Health check
[2024-04-23 16:17:45] [index:background] Health check
[2024-04-23 16:19:35] [indexer:background] Health check
[2024-04-23 16:22:37] [index:background] Health check
[2024-04-23 16:25:36] [indexer:background] Health check
[2024-04-23 16:27:40] [index:background] Health check
[2024-04-23 16:30:13] [indexer:background] Health check
[2024-04-23 16:33:46] [index:background] Health check
[2024-04-23 16:34:22] [indexer:background] Health check
[2024-04-23 16:37:54] [index:background] Health check
[2024-04-23 16:39:23] [indexer:background] Health check
[2024-04-23 16:42:51] [index:background] Health check
[2024-04-23 16:44:23] [indexer:background] Health check
[2024-04-23 16:47:36] [index:background] Health check
[2024-04-23 16:49:32] [indexer:background] Health check
[2024-04-23 16:52:37] [index:background] Health check
[2024-04-23 16:55:52] [indexer:background] Health check
[2024-04-23 16:57:44] [index:background] Health check
[2024-04-23 16:59:17] [indexer:background] Health check
[2024-04-23 17:02:37] [index:background] Health check
[2024-04-23 17:04:17] [indexer:background] Health check
[2024-04-23 17:07:47] [index:background] Health check
[2024-04-23 17:09:16] [indexer:background] Health check
[2024-04-23 17:12:42] [index:background] Health check
[2024-04-23 17:15:06] [indexer:background] Health check
[2024-04-23 17:17:56] [index:background] Health check
[2024-04-23 17:19:39] [indexer:background] Health check
[2024-04-23 17:22:57] [index:background] Health check
[2024-04-23 17:25:28] [indexer:background] Health check
[2024-04-23 17:28:01] [index:background] Health check
[2024-04-23 17:29:28] [indexer:background] Health check
[2024-04-23 17:32:42] [index:background] Health check
[2024-04-23 17:34:37] [indexer:background] Health check
[2024-04-23 17:38:18] [index:background] Health check
[2024-04-23 17:39:18] [indexer:background] Health check
[2024-04-23 17:42:29] [query] Query for: 2025
[2024-04-23 17:42:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 17:42:29] [query] Engine: default
[2024-04-23 17:42:29] [query] Tokens: 2025
[2024-04-23 17:42:29] [query] Mods: 6
[2024-04-23 17:42:29] [query] Found results using: or logic
[2024-04-23 17:42:29] [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-04-23 17:42:29] [query] Results: 138 Pages of results: 14
[2024-04-23 17:42:29] [query] Execution time: 0.22625
[2024-04-23 17:42:29] [query] Query for: 2025
[2024-04-23 17:42:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-23 17:42:29] [query] Engine: default
[2024-04-23 17:42:29] [query] Tokens: 2025
[2024-04-23 17:42:29] [query] Mods: 6
[2024-04-23 17:42:29] [query] Found results using: or logic
[2024-04-23 17:42:29] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-04-23 17:42:29] [query] Results: 138 Pages of results: 2
[2024-04-23 17:42:29] [query] Execution time: 0.14277
[2024-04-23 17:42:55] [index:background] Health check
[2024-04-23 17:45:04] [indexer:background] Health check
[2024-04-23 17:47:51] [index:background] Health check
[2024-04-23 17:49:22] [indexer:background] Health check
[2024-04-23 17:53:19] [index:background] Health check
[2024-04-23 17:55:19] [indexer:background] Health check
[2024-04-23 17:58:03] [index:background] Health check
[2024-04-23 18:00:18] [indexer:background] Health check
[2024-04-23 18:02:47] [index:background] Health check
[2024-04-23 18:05:37] [indexer:background] Health check
[2024-04-23 18:07:37] [index:background] Health check
[2024-04-23 18:09:25] [indexer:background] Health check
[2024-04-23 18:12:36] [index:background] Health check
[2024-04-23 18:14:20] [indexer:background] Health check
[2024-04-23 18:17:36] [index:background] Health check
[2024-04-23 18:19:17] [indexer:background] Health check
[2024-04-23 18:22:34] [index:background] Health check
[2024-04-23 18:24:18] [indexer:background] Health check
[2024-04-23 18:27:35] [index:background] Health check
[2024-04-23 18:29:19] [indexer:background] Health check
[2024-04-23 18:33:30] [index:background] Health check
[2024-04-23 18:35:09] [indexer:background] Health check
[2024-04-23 18:37:59] [index:background] Health check
[2024-04-23 18:39:28] [indexer:background] Health check
[2024-04-23 18:42:49] [index:background] Health check
[2024-04-23 18:44:19] [indexer:background] Health check
[2024-04-23 18:47:59] [index:background] Health check
[2024-04-23 18:50:16] [indexer:background] Health check
[2024-04-23 18:53:02] [index:background] Health check
[2024-04-23 18:54:25] [indexer:background] Health check
[2024-04-23 18:57:37] [index:background] Health check
[2024-04-23 19:00:05] [indexer:background] Health check
[2024-04-23 19:03:47] [index:background] Health check
[2024-04-23 19:04:20] [indexer:background] Health check
[2024-04-23 19:07:58] [index:background] Health check
[2024-04-23 19:10:23] [indexer:background] Health check
[2024-04-23 19:13:20] [index:background] Health check
[2024-04-23 19:14:22] [indexer:background] Health check
[2024-04-23 19:17:41] [index:background] Health check
[2024-04-23 19:19:18] [indexer:background] Health check
[2024-04-23 19:23:23] [index:background] Health check
[2024-04-23 19:24:31] [indexer:background] Health check
[2024-04-23 19:27:49] [index:background] Health check
[2024-04-23 19:29:22] [indexer:background] Health check
[2024-04-23 19:33:09] [index:background] Health check
[2024-04-23 19:34:35] [indexer:background] Health check
[2024-04-23 19:37:37] [index:background] Health check
[2024-04-23 19:39:25] [indexer:background] Health check
[2024-04-23 19:43:32] [index:background] Health check
[2024-04-23 19:44:35] [indexer:background] Health check
[2024-04-23 19:47:44] [index:background] Health check
[2024-04-23 19:49:53] [indexer:background] Health check
[2024-04-23 19:53:08] [index:background] Health check
[2024-04-23 19:54:16] [indexer:background] Health check
[2024-04-23 19:58:56] [index:background] Health check
[2024-04-23 19:59:47] [indexer:background] Health check
[2024-04-23 20:02:43] [index:background] Health check
[2024-04-23 20:04:28] [indexer:background] Health check
[2024-04-23 20:08:07] [index:background] Health check
[2024-04-23 20:10:06] [indexer:background] Health check
[2024-04-23 20:14:12] [index:background] Health check
[2024-04-23 20:15:07] [indexer:background] Health check
[2024-04-23 20:17:43] [index:background] Health check
[2024-04-23 20:20:02] [indexer:background] Health check
[2024-04-23 20:22:57] [index:background] Health check
[2024-04-23 20:24:32] [indexer:background] Health check
[2024-04-23 20:28:54] [index:background] Health check
[2024-04-23 20:29:26] [indexer:background] Health check
[2024-04-23 20:33:19] [index:background] Health check
[2024-04-23 20:34:53] [indexer:background] Health check
[2024-04-23 20:37:41] [index:background] Health check
[2024-04-23 20:40:00] [indexer:background] Health check
[2024-04-23 20:42:48] [index:background] Health check
[2024-04-23 20:44:17] [indexer:background] Health check
[2024-04-23 20:47:42] [index:background] Health check
[2024-04-23 20:50:13] [indexer:background] Health check
[2024-04-23 20:52:58] [index:background] Health check
[2024-04-23 20:54:19] [indexer:background] Health check
[2024-04-23 20:57:53] [index:background] Health check
[2024-04-23 20:59:35] [indexer:background] Health check
[2024-04-23 21:02:59] [index:background] Health check
[2024-04-23 21:04:28] [indexer:background] Health check
[2024-04-23 21:08:02] [index:background] Health check
[2024-04-23 21:09:27] [indexer:background] Health check
[2024-04-23 21:12:35] [index:background] Health check
[2024-04-23 21:14:25] [indexer:background] Health check
[2024-04-23 21:18:00] [index:background] Health check
[2024-04-23 21:19:32] [indexer:background] Health check
[2024-04-23 21:22:51] [index:background] Health check
[2024-04-23 21:24:35] [indexer:background] Health check
[2024-04-23 21:27:43] [index:background] Health check
[2024-04-23 21:30:48] [indexer:background] Health check
[2024-04-23 21:33:55] [index:background] Health check
[2024-04-23 21:36:27] [indexer:background] Health check
[2024-04-23 21:37:45] [index:background] Health check
[2024-04-23 21:39:55] [indexer:background] Health check
[2024-04-23 21:42:40] [index:background] Health check
[2024-04-23 21:44:18] [indexer:background] Health check
[2024-04-23 21:47:53] [index:background] Health check
[2024-04-23 21:49:32] [indexer:background] Health check
[2024-04-23 21:53:01] [index:background] Health check
[2024-04-23 21:54:21] [indexer:background] Health check
[2024-04-23 21:59:17] [index:background] Health check
[2024-04-23 21:59:17] [indexer:background] Health check
[2024-04-23 21:59:17] [indexer:background] Health check
[2024-04-23 22:03:03] [index:background] Health check
[2024-04-23 22:04:17] [indexer:background] Health check
[2024-04-23 22:07:48] [index:background] Health check
[2024-04-23 22:09:18] [indexer:background] Health check
[2024-04-23 22:12:46] [index:background] Health check
[2024-04-23 22:14:32] [indexer:background] Health check
[2024-04-23 22:17:43] [index:background] Health check
[2024-04-23 22:19:23] [indexer:background] Health check
[2024-04-23 22:22:40] [index:background] Health check
[2024-04-23 22:24:30] [indexer:background] Health check
[2024-04-23 22:27:41] [index:background] Health check
[2024-04-23 22:29:23] [indexer:background] Health check
[2024-04-23 22:32:57] [index:background] Health check
[2024-04-23 22:34:20] [indexer:background] Health check
[2024-04-23 22:38:13] [index:background] Health check
[2024-04-23 22:39:31] [indexer:background] Health check
[2024-04-23 22:41:39] [query] Query for: 2024
[2024-04-23 22:41:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-23 22:41:39] [query] Engine: default
[2024-04-23 22:41:40] [query] Tokens: 2024
[2024-04-23 22:41:40] [query] Mods: 6
[2024-04-23 22:41:40] [query] Found results using: or logic
[2024-04-23 22:41:40] [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-04-23 22:41:40] [query] Results: 151 Pages of results: 16
[2024-04-23 22:41:40] [query] Execution time: 1.12784
[2024-04-23 22:41:40] [query] Query for: 2024
[2024-04-23 22:41:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-23 22:41:40] [query] Engine: default
[2024-04-23 22:41:40] [query] Tokens: 2024
[2024-04-23 22:41:40] [query] Mods: 6
[2024-04-23 22:41:40] [query] Found results using: or logic
[2024-04-23 22:41:40] [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-04-23 22:41:40] [query] Results: 151 Pages of results: 2
[2024-04-23 22:41:40] [query] Execution time: 0.17387
[2024-04-23 22:44:07] [index:background] Health check
[2024-04-23 22:44:23] [indexer:background] Health check
[2024-04-23 22:47:51] [index:background] Health check
[2024-04-23 22:50:17] [indexer:background] Health check
[2024-04-23 22:53:05] [index:background] Health check
[2024-04-23 22:54:26] [indexer:background] Health check
[2024-04-23 22:57:34] [index:background] Health check
[2024-04-23 22:59:37] [indexer:background] Health check
[2024-04-23 23:02:55] [index:background] Health check
[2024-04-23 23:04:19] [indexer:background] Health check
[2024-04-23 23:07:47] [index:background] Health check
[2024-04-23 23:09:38] [indexer:background] Health check
[2024-04-23 23:12:54] [index:background] Health check
[2024-04-23 23:14:30] [indexer:background] Health check
[2024-04-23 23:17:50] [index:background] Health check
[2024-04-23 23:20:08] [indexer:background] Health check
[2024-04-23 23:22:52] [index:background] Health check
[2024-04-23 23:24:24] [indexer:background] Health check
[2024-04-23 23:28:10] [index:background] Health check
[2024-04-23 23:29:27] [indexer:background] Health check
[2024-04-23 23:32:34] [index:background] Health check
[2024-04-23 23:34:17] [indexer:background] Health check
[2024-04-23 23:37:44] [index:background] Health check
[2024-04-23 23:39:30] [indexer:background] Health check
[2024-04-23 23:43:22] [index:background] Health check
[2024-04-23 23:44:46] [indexer:background] Health check
[2024-04-23 23:48:08] [index:background] Health check
[2024-04-23 23:51:05] [indexer:background] Health check
[2024-04-23 23:52:38] [index:background] Health check
[2024-04-23 23:54:27] [indexer:background] Health check
[2024-04-23 23:57:37] [index:background] Health check
[2024-04-23 23:59:20] [indexer:background] Health check