[2024-06-02 00:01:17] [index:background] Health check
[2024-06-02 00:01:18] [indexer:background] Health check
[2024-06-02 00:01:18] [indexer:background] Health check
[2024-06-02 00:06:01] [index:background] Health check
[2024-06-02 00:06:01] [indexer:background] Health check
[2024-06-02 00:06:01] [indexer:background] Health check
[2024-06-02 00:09:39] [index:background] Health check
[2024-06-02 00:09:39] [indexer:background] Health check
[2024-06-02 00:09:40] [indexer:background] Health check
[2024-06-02 00:13:52] [index:background] Health check
[2024-06-02 00:14:21] [indexer:background] Health check
[2024-06-02 00:18:47] [index:background] Health check
[2024-06-02 00:19:25] [indexer:background] Health check
[2024-06-02 00:19:25] [query] Query for: 2024
[2024-06-02 00:19:25] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 00:19:25] [query] Engine: default
[2024-06-02 00:19:25] [query] Tokens: 2024
[2024-06-02 00:19:25] [query] Mods: 6
[2024-06-02 00:19:25] [query] Found results using: or logic
[2024-06-02 00:19: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-06-02 00:19:25] [query] Results: 157 Pages of results: 16
[2024-06-02 00:19:25] [query] Execution time: 0.36778
[2024-06-02 00:19:25] [query] Query for: 2024
[2024-06-02 00:19:25] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-06-02 00:19:25] [query] Engine: default
[2024-06-02 00:19:25] [query] Tokens: 2024
[2024-06-02 00:19:25] [query] Mods: 6
[2024-06-02 00:19:25] [query] Found results using: or logic
[2024-06-02 00:19: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-06-02 00:19:25] [query] Results: 157 Pages of results: 2
[2024-06-02 00:19:25] [query] Execution time: 0.12780
[2024-06-02 00:23:49] [index:background] Health check
[2024-06-02 00:24:58] [indexer:background] Health check
[2024-06-02 00:29:57] [index:background] Health check
[2024-06-02 00:29:57] [indexer:background] Health check
[2024-06-02 00:29:57] [indexer:background] Health check
[2024-06-02 00:34:04] [index:background] Health check
[2024-06-02 00:38:52] [indexer:background] Health check
[2024-06-02 00:38:52] [index:background] Health check
[2024-06-02 00:40:43] [indexer:background] Health check
[2024-06-02 00:44:06] [index:background] Health check
[2024-06-02 00:47:16] [indexer:background] Health check
[2024-06-02 00:48:49] [index:background] Health check
[2024-06-02 00:50:18] [indexer:background] Health check
[2024-06-02 00:55:46] [index:background] Health check
[2024-06-02 00:55:46] [indexer:background] Health check
[2024-06-02 00:55:47] [indexer:background] Health check
[2024-06-02 01:00:19] [index:background] Health check
[2024-06-02 01:00:19] [indexer:background] Health check
[2024-06-02 01:00:19] [indexer:background] Health check
[2024-06-02 01:04:02] [index:background] Health check
[2024-06-02 01:05:55] [indexer:background] Health check
[2024-06-02 01:11:51] [index:background] Health check
[2024-06-02 01:11:51] [indexer:background] Health check
[2024-06-02 01:11:51] [indexer:background] Health check
[2024-06-02 01:13:59] [index:background] Health check
[2024-06-02 01:16:06] [indexer:background] Health check
[2024-06-02 01:19:25] [index:background] Health check
[2024-06-02 01:19:25] [indexer:background] Health check
[2024-06-02 01:19:25] [indexer:background] Health check
[2024-06-02 01:24:12] [index:background] Health check
[2024-06-02 01:24:59] [indexer:background] Health check
[2024-06-02 01:29:26] [index:background] Health check
[2024-06-02 01:29:26] [indexer:background] Health check
[2024-06-02 01:29:26] [indexer:background] Health check
[2024-06-02 01:34:30] [index:background] Health check
[2024-06-02 01:34:30] [indexer:background] Health check
[2024-06-02 01:34:30] [indexer:background] Health check
[2024-06-02 01:40:04] [index:background] Health check
[2024-06-02 01:40:04] [indexer:background] Health check
[2024-06-02 01:40:04] [indexer:background] Health check
[2024-06-02 01:43:55] [index:background] Health check
[2024-06-02 01:44:23] [indexer:background] Health check
[2024-06-02 01:50:17] [index:background] Health check
[2024-06-02 01:50:18] [indexer:background] Health check
[2024-06-02 01:50:18] [indexer:background] Health check
[2024-06-02 01:52:22] [query] Query for: 2024
[2024-06-02 01:52:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 01:52:22] [query] Engine: default
[2024-06-02 01:52:22] [query] Tokens: 2024
[2024-06-02 01:52:22] [query] Mods: 6
[2024-06-02 01:52:22] [query] Found results using: or logic
[2024-06-02 01:52:22] [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-06-02 01:52:22] [query] Results: 157 Pages of results: 16
[2024-06-02 01:52:22] [query] Execution time: 0.35560
[2024-06-02 01:54:01] [index:background] Health check
[2024-06-02 01:55:55] [indexer:background] Health check
[2024-06-02 01:59:49] [index:background] Health check
[2024-06-02 01:59:49] [indexer:background] Health check
[2024-06-02 01:59:49] [indexer:background] Health check
[2024-06-02 02:04:11] [index:background] Health check
[2024-06-02 02:04:57] [indexer:background] Health check
[2024-06-02 02:04:57] [indexer:background] Health check
[2024-06-02 02:09:04] [index:background] Health check
[2024-06-02 02:09:43] [indexer:background] Health check
[2024-06-02 02:12:56] [query] Query for: 2025
[2024-06-02 02:12:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 02:12:56] [query] Engine: default
[2024-06-02 02:12:56] [query] Tokens: 2025
[2024-06-02 02:12:56] [query] Mods: 6
[2024-06-02 02:12:56] [query] Found results using: or logic
[2024-06-02 02:12:56] [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-06-02 02:12:56] [query] Results: 138 Pages of results: 14
[2024-06-02 02:12:56] [query] Execution time: 0.17946
[2024-06-02 02:12:56] [query] Query for: 2025
[2024-06-02 02:12:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-06-02 02:12:56] [query] Engine: default
[2024-06-02 02:12:56] [query] Tokens: 2025
[2024-06-02 02:12:56] [query] Mods: 6
[2024-06-02 02:12:56] [query] Found results using: or logic
[2024-06-02 02:12:56] [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-06-02 02:12:56] [query] Results: 138 Pages of results: 2
[2024-06-02 02:12:56] [query] Execution time: 0.28900
[2024-06-02 02:13:57] [index:background] Health check
[2024-06-02 02:14:33] [indexer:background] Health check
[2024-06-02 02:19:28] [index:background] Health check
[2024-06-02 02:19:28] [indexer:background] Health check
[2024-06-02 02:19:28] [indexer:background] Health check
[2024-06-02 02:25:03] [index:background] Health check
[2024-06-02 02:25:03] [indexer:background] Health check
[2024-06-02 02:25:03] [indexer:background] Health check
[2024-06-02 02:30:47] [index:background] Health check
[2024-06-02 02:30:47] [indexer:background] Health check
[2024-06-02 02:30:47] [indexer:background] Health check
[2024-06-02 02:36:40] [index:background] Health check
[2024-06-02 02:36:40] [indexer:background] Health check
[2024-06-02 02:36:40] [indexer:background] Health check
[2024-06-02 02:39:29] [index:background] Health check
[2024-06-02 02:39:29] [indexer:background] Health check
[2024-06-02 02:39:29] [indexer:background] Health check
[2024-06-02 02:44:09] [index:background] Health check
[2024-06-02 02:44:52] [indexer:background] Health check
[2024-06-02 02:49:35] [index:background] Health check
[2024-06-02 02:49:36] [indexer:background] Health check
[2024-06-02 02:49:36] [indexer:background] Health check
[2024-06-02 02:53:48] [index:background] Health check
[2024-06-02 02:54:27] [indexer:background] Health check
[2024-06-02 02:58:58] [index:background] Health check
[2024-06-02 02:59:31] [indexer:background] Health check
[2024-06-02 03:03:41] [index:background] Health check
[2024-06-02 03:03:41] [index:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2024-06-02 03:05:50] [indexer:background] Health check
[2024-06-02 03:08:45] [index:background] Health check
[2024-06-02 03:09:57] [indexer:background] Health check
[2024-06-02 03:13:43] [index:background] Health check
[2024-06-02 03:15:50] [indexer:background] Health check
[2024-06-02 03:19:43] [index:background] Health check
[2024-06-02 03:19:44] [indexer:background] Health check
[2024-06-02 03:19:44] [indexer:background] Health check
[2024-06-02 03:24:08] [index:background] Health check
[2024-06-02 03:25:44] [indexer:background] Health check
[2024-06-02 03:25:44] [query] Query for: 2024
[2024-06-02 03:25:44] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 03:25:44] [query] Engine: default
[2024-06-02 03:25:44] [query] Tokens: 2024
[2024-06-02 03:25:44] [query] Mods: 6
[2024-06-02 03:25:44] [query] Found results using: or logic
[2024-06-02 03:25:44] [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-06-02 03:25:44] [query] Results: 157 Pages of results: 16
[2024-06-02 03:25:44] [query] Execution time: 0.18642
[2024-06-02 03:25:44] [query] Query for: 2024
[2024-06-02 03:25:44] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-06-02 03:25:44] [query] Engine: default
[2024-06-02 03:25:44] [query] Tokens: 2024
[2024-06-02 03:25:44] [query] Mods: 6
[2024-06-02 03:25:44] [query] Found results using: or logic
[2024-06-02 03:25:45] [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-06-02 03:25:45] [query] Results: 157 Pages of results: 2
[2024-06-02 03:25:45] [query] Execution time: 0.23833
[2024-06-02 03:29:51] [index:background] Health check
[2024-06-02 03:29:51] [indexer:background] Health check
[2024-06-02 03:29:51] [indexer:background] Health check
[2024-06-02 03:33:44] [index:background] Health check
[2024-06-02 03:34:32] [indexer:background] Health check
[2024-06-02 03:41:00] [index:background] Health check
[2024-06-02 03:41:00] [indexer:background] Health check
[2024-06-02 03:41:00] [indexer:background] Health check
[2024-06-02 03:44:04] [index:background] Health check
[2024-06-02 03:46:31] [indexer:background] Health check
[2024-06-02 03:50:37] [index:background] Health check
[2024-06-02 03:50:37] [indexer:background] Health check
[2024-06-02 03:50:37] [indexer:background] Health check
[2024-06-02 03:55:17] [index:background] Health check
[2024-06-02 03:55:17] [indexer:background] Health check
[2024-06-02 03:55:17] [indexer:background] Health check
[2024-06-02 04:01:55] [index:background] Health check
[2024-06-02 04:01:55] [indexer:background] Health check
[2024-06-02 04:01:55] [indexer:background] Health check
[2024-06-02 04:04:26] [index:background] Health check
[2024-06-02 04:04:26] [indexer:background] Health check
[2024-06-02 04:04:26] [indexer:background] Health check
[2024-06-02 04:10:25] [index:background] Health check
[2024-06-02 04:10:25] [indexer:background] Health check
[2024-06-02 04:10:25] [indexer:background] Health check
[2024-06-02 04:15:05] [index:background] Health check
[2024-06-02 04:15:05] [indexer:background] Health check
[2024-06-02 04:15:05] [indexer:background] Health check
[2024-06-02 04:21:12] [index:background] Health check
[2024-06-02 04:21:13] [indexer:background] Health check
[2024-06-02 04:21:13] [indexer:background] Health check
[2024-06-02 04:23:53] [index:background] Health check
[2024-06-02 04:24:57] [indexer:background] Health check
[2024-06-02 04:29:19] [index:background] Health check
[2024-06-02 04:29:19] [indexer:background] Health check
[2024-06-02 04:29:19] [indexer:background] Health check
[2024-06-02 04:33:54] [index:background] Health check
[2024-06-02 04:35:11] [indexer:background] Health check
[2024-06-02 04:39:57] [index:background] Health check
[2024-06-02 04:39:58] [indexer:background] Health check
[2024-06-02 04:39:58] [indexer:background] Health check
[2024-06-02 04:44:05] [index:background] Health check
[2024-06-02 04:44:43] [indexer:background] Health check
[2024-06-02 04:49:08] [index:background] Health check
[2024-06-02 04:49:16] [indexer:background] Health check
[2024-06-02 04:53:54] [index:background] Health check
[2024-06-02 04:56:05] [indexer:background] Health check
[2024-06-02 04:58:43] [index:background] Health check
[2024-06-02 04:59:22] [indexer:background] Health check
[2024-06-02 05:04:04] [index:background] Health check
[2024-06-02 05:04:39] [indexer:background] Health check
[2024-06-02 05:08:54] [index:background] Health check
[2024-06-02 05:09:29] [indexer:background] Health check
[2024-06-02 05:13:47] [index:background] Health check
[2024-06-02 05:14:18] [indexer:background] Health check
[2024-06-02 05:19:26] [index:background] Health check
[2024-06-02 05:19:26] [indexer:background] Health check
[2024-06-02 05:19:26] [indexer:background] Health check
[2024-06-02 05:24:56] [index:background] Health check
[2024-06-02 05:24:56] [indexer:background] Health check
[2024-06-02 05:24:56] [indexer:background] Health check
[2024-06-02 05:28:49] [index:background] Health check
[2024-06-02 05:30:31] [indexer:background] Health check
[2024-06-02 05:34:39] [index:background] Health check
[2024-06-02 05:34:40] [indexer:background] Health check
[2024-06-02 05:34:40] [indexer:background] Health check
[2024-06-02 05:38:49] [index:background] Health check
[2024-06-02 05:40:12] [indexer:background] Health check
[2024-06-02 05:43:59] [index:background] Health check
[2024-06-02 05:44:17] [indexer:background] Health check
[2024-06-02 05:48:43] [index:background] Health check
[2024-06-02 05:49:16] [indexer:background] Health check
[2024-06-02 05:55:03] [index:background] Health check
[2024-06-02 05:55:03] [indexer:background] Health check
[2024-06-02 05:55:03] [indexer:background] Health check
[2024-06-02 05:59:06] [index:background] Health check
[2024-06-02 06:00:32] [indexer:background] Health check
[2024-06-02 06:08:21] [index:background] Health check
[2024-06-02 06:08:21] [indexer:background] Health check
[2024-06-02 06:08:21] [indexer:background] Health check
[2024-06-02 06:10:10] [index:background] Health check
[2024-06-02 06:10:10] [indexer:background] Health check
[2024-06-02 06:10:10] [indexer:background] Health check
[2024-06-02 06:14:14] [index:background] Health check
[2024-06-02 06:16:10] [indexer:background] Health check
[2024-06-02 06:19:54] [index:background] Health check
[2024-06-02 06:19:54] [indexer:background] Health check
[2024-06-02 06:19:54] [indexer:background] Health check
[2024-06-02 06:24:14] [index:background] Health check
[2024-06-02 06:28:03] [indexer:background] Health check
[2024-06-02 06:29:48] [index:background] Health check
[2024-06-02 06:29:48] [indexer:background] Health check
[2024-06-02 06:29:48] [indexer:background] Health check
[2024-06-02 06:35:20] [index:background] Health check
[2024-06-02 06:35:20] [indexer:background] Health check
[2024-06-02 06:35:21] [indexer:background] Health check
[2024-06-02 06:38:55] [index:background] Health check
[2024-06-02 06:40:18] [indexer:background] Health check
[2024-06-02 06:43:57] [index:background] Health check
[2024-06-02 06:45:21] [indexer:background] Health check
[2024-06-02 06:51:58] [index:background] Health check
[2024-06-02 06:51:58] [indexer:background] Health check
[2024-06-02 06:51:58] [indexer:background] Health check
[2024-06-02 06:55:06] [index:background] Health check
[2024-06-02 06:55:06] [indexer:background] Health check
[2024-06-02 06:55:06] [indexer:background] Health check
[2024-06-02 06:58:57] [index:background] Health check
[2024-06-02 06:59:18] [indexer:background] Health check
[2024-06-02 07:03:49] [index:background] Health check
[2024-06-02 07:04:51] [indexer:background] Health check
[2024-06-02 07:10:27] [index:background] Health check
[2024-06-02 07:10:27] [indexer:background] Health check
[2024-06-02 07:10:27] [indexer:background] Health check
[2024-06-02 07:14:05] [index:background] Health check
[2024-06-02 07:14:23] [indexer:background] Health check
[2024-06-02 07:19:57] [index:background] Health check
[2024-06-02 07:19:57] [indexer:background] Health check
[2024-06-02 07:19:57] [indexer:background] Health check
[2024-06-02 07:21:01] [query] Query for: search_term_string
[2024-06-02 07:21:01] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 07:21:01] [query] Engine: default
[2024-06-02 07:21:01] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-06-02 07:21:01] [query] Mods: 6
[2024-06-02 07:21:01] [query] Using OR logic
[2024-06-02 07:21:02] [query] Found results using: or logic
[2024-06-02 07:21: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 (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-06-02 07:21:02] [query] Results: 1364 Pages of results: 137
[2024-06-02 07:21:02] [query] Execution time: 0.89051
[2024-06-02 07:24:09] [index:background] Health check
[2024-06-02 07:24:32] [indexer:background] Health check
[2024-06-02 07:28:48] [index:background] Health check
[2024-06-02 07:29:44] [indexer:background] Health check
[2024-06-02 07:33:43] [index:background] Health check
[2024-06-02 07:34:41] [indexer:background] Health check
[2024-06-02 07:38:47] [index:background] Health check
[2024-06-02 07:40:04] [indexer:background] Health check
[2024-06-02 07:43:59] [index:background] Health check
[2024-06-02 07:44:25] [indexer:background] Health check
[2024-06-02 07:49:42] [index:background] Health check
[2024-06-02 07:49:42] [indexer:background] Health check
[2024-06-02 07:49:43] [indexer:background] Health check
[2024-06-02 07:53:49] [index:background] Health check
[2024-06-02 07:55:23] [indexer:background] Health check
[2024-06-02 07:59:56] [index:background] Health check
[2024-06-02 07:59:56] [indexer:background] Health check
[2024-06-02 07:59:56] [indexer:background] Health check
[2024-06-02 08:04:45] [index:background] Health check
[2024-06-02 08:04:46] [indexer:background] Health check
[2024-06-02 08:04:46] [indexer:background] Health check
[2024-06-02 08:10:39] [index:background] Health check
[2024-06-02 08:10:39] [indexer:background] Health check
[2024-06-02 08:10:39] [indexer:background] Health check
[2024-06-02 08:15:28] [index:background] Health check
[2024-06-02 08:15:28] [indexer:background] Health check
[2024-06-02 08:15:28] [indexer:background] Health check
[2024-06-02 08:24:39] [index:background] Health check
[2024-06-02 08:24:39] [indexer:background] Health check
[2024-06-02 08:24:39] [indexer:background] Health check
[2024-06-02 08:28:56] [index:background] Health check
[2024-06-02 08:30:23] [indexer:background] Health check
[2024-06-02 08:34:07] [index:background] Health check
[2024-06-02 08:35:37] [indexer:background] Health check
[2024-06-02 08:38:47] [index:background] Health check
[2024-06-02 08:39:23] [indexer:background] Health check
[2024-06-02 08:44:19] [index:background] Health check
[2024-06-02 08:44:19] [indexer:background] Health check
[2024-06-02 08:44:19] [indexer:background] Health check
[2024-06-02 08:50:32] [index:background] Health check
[2024-06-02 08:50:32] [indexer:background] Health check
[2024-06-02 08:50:32] [indexer:background] Health check
[2024-06-02 08:54:04] [index:background] Health check
[2024-06-02 08:54:32] [indexer:background] Health check
[2024-06-02 08:59:27] [index:background] Health check
[2024-06-02 08:59:27] [indexer:background] Health check
[2024-06-02 08:59:27] [indexer:background] Health check
[2024-06-02 09:03:59] [index:background] Health check
[2024-06-02 09:05:23] [indexer:background] Health check
[2024-06-02 09:08:54] [index:background] Health check
[2024-06-02 09:10:07] [indexer:background] Health check
[2024-06-02 09:14:07] [index:background] Health check
[2024-06-02 09:14:33] [indexer:background] Health check
[2024-06-02 09:19:13] [index:background] Health check
[2024-06-02 09:20:00] [indexer:background] Health check
[2024-06-02 09:23:04] [query] Query for: 2023
[2024-06-02 09:23:04] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 09:23:04] [query] Engine: default
[2024-06-02 09:23:04] [query] Tokens: 2023
[2024-06-02 09:23:04] [query] Mods: 6
[2024-06-02 09:23:04] [query] Found results using: or logic
[2024-06-02 09:23:04] [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-06-02 09:23:04] [query] Results: 278 Pages of results: 28
[2024-06-02 09:23:04] [query] Execution time: 0.34405
[2024-06-02 09:24:06] [index:background] Health check
[2024-06-02 09:26:59] [indexer:background] Health check
[2024-06-02 09:29:11] [index:background] Health check
[2024-06-02 09:29:45] [indexer:background] Health check
[2024-06-02 09:35:21] [index:background] Health check
[2024-06-02 09:35:21] [indexer:background] Health check
[2024-06-02 09:35:21] [indexer:background] Health check
[2024-06-02 09:39:26] [index:background] Health check
[2024-06-02 09:39:26] [indexer:background] Health check
[2024-06-02 09:39:26] [indexer:background] Health check
[2024-06-02 09:44:23] [index:background] Health check
[2024-06-02 09:44:23] [indexer:background] Health check
[2024-06-02 09:44:23] [indexer:background] Health check
[2024-06-02 09:49:45] [index:background] Health check
[2024-06-02 09:49:45] [indexer:background] Health check
[2024-06-02 09:49:45] [indexer:background] Health check
[2024-06-02 09:53:47] [index:background] Health check
[2024-06-02 09:54:49] [indexer:background] Health check
[2024-06-02 09:58:59] [index:background] Health check
[2024-06-02 09:59:51] [indexer:background] Health check
[2024-06-02 10:03:58] [index:background] Health check
[2024-06-02 10:04:42] [indexer:background] Health check
[2024-06-02 10:08:50] [index:background] Health check
[2024-06-02 10:09:52] [indexer:background] Health check
[2024-06-02 10:14:22] [index:background] Health check
[2024-06-02 10:14:22] [indexer:background] Health check
[2024-06-02 10:14:22] [indexer:background] Health check
[2024-06-02 10:19:21] [index:background] Health check
[2024-06-02 10:19:21] [indexer:background] Health check
[2024-06-02 10:19:21] [indexer:background] Health check
[2024-06-02 10:25:16] [index:background] Health check
[2024-06-02 10:25:16] [indexer:background] Health check
[2024-06-02 10:25:16] [indexer:background] Health check
[2024-06-02 10:29:14] [index:background] Health check
[2024-06-02 10:29:57] [indexer:background] Health check
[2024-06-02 10:34:02] [index:background] Health check
[2024-06-02 10:34:42] [indexer:background] Health check
[2024-06-02 10:38:43] [index:background] Health check
[2024-06-02 10:39:47] [indexer:background] Health check
[2024-06-02 10:44:17] [index:background] Health check
[2024-06-02 10:44:17] [indexer:background] Health check
[2024-06-02 10:44:17] [indexer:background] Health check
[2024-06-02 10:49:42] [index:background] Health check
[2024-06-02 10:49:42] [indexer:background] Health check
[2024-06-02 10:49:42] [indexer:background] Health check
[2024-06-02 10:53:44] [index:background] Health check
[2024-06-02 10:54:36] [indexer:background] Health check
[2024-06-02 10:58:47] [index:background] Health check
[2024-06-02 11:00:14] [indexer:background] Health check
[2024-06-02 11:06:06] [index:background] Health check
[2024-06-02 11:06:06] [indexer:background] Health check
[2024-06-02 11:06:06] [indexer:background] Health check
[2024-06-02 11:11:48] [index:background] Health check
[2024-06-02 11:11:48] [indexer:background] Health check
[2024-06-02 11:11:48] [indexer:background] Health check
[2024-06-02 11:14:22] [index:background] Health check
[2024-06-02 11:14:22] [indexer:background] Health check
[2024-06-02 11:14:22] [indexer:background] Health check
[2024-06-02 11:18:50] [index:background] Health check
[2024-06-02 11:19:23] [indexer:background] Health check
[2024-06-02 11:25:01] [index:background] Health check
[2024-06-02 11:25:01] [indexer:background] Health check
[2024-06-02 11:25:01] [indexer:background] Health check
[2024-06-02 11:31:45] [index:background] Health check
[2024-06-02 11:31:45] [indexer:background] Health check
[2024-06-02 11:31:45] [indexer:background] Health check
[2024-06-02 11:34:53] [index:background] Health check
[2024-06-02 11:34:53] [indexer:background] Health check
[2024-06-02 11:34:53] [indexer:background] Health check
[2024-06-02 11:39:10] [index:background] Health check
[2024-06-02 11:39:49] [indexer:background] Health check
[2024-06-02 11:45:31] [index:background] Health check
[2024-06-02 11:45:31] [indexer:background] Health check
[2024-06-02 11:45:31] [indexer:background] Health check
[2024-06-02 11:50:18] [index:background] Health check
[2024-06-02 11:50:18] [indexer:background] Health check
[2024-06-02 11:50:18] [indexer:background] Health check
[2024-06-02 11:54:18] [index:background] Health check
[2024-06-02 11:54:18] [indexer:background] Health check
[2024-06-02 11:54:18] [indexer:background] Health check
[2024-06-02 11:59:55] [index:background] Health check
[2024-06-02 11:59:55] [indexer:background] Health check
[2024-06-02 11:59:55] [indexer:background] Health check
[2024-06-02 12:05:42] [index:background] Health check
[2024-06-02 12:05:43] [indexer:background] Health check
[2024-06-02 12:05:43] [indexer:background] Health check
[2024-06-02 12:10:44] [index:background] Health check
[2024-06-02 12:10:44] [indexer:background] Health check
[2024-06-02 12:10:44] [indexer:background] Health check
[2024-06-02 12:16:33] [index:background] Health check
[2024-06-02 12:16:33] [indexer:background] Health check
[2024-06-02 12:16:33] [indexer:background] Health check
[2024-06-02 12:19:12] [index:background] Health check
[2024-06-02 12:19:45] [indexer:background] Health check
[2024-06-02 12:24:24] [index:background] Health check
[2024-06-02 12:24:24] [indexer:background] Health check
[2024-06-02 12:24:24] [indexer:background] Health check
[2024-06-02 12:29:34] [index:background] Health check
[2024-06-02 12:29:34] [indexer:background] Health check
[2024-06-02 12:29:34] [indexer:background] Health check
[2024-06-02 12:33:42] [index:background] Health check
[2024-06-02 12:34:17] [indexer:background] Health check
[2024-06-02 12:38:42] [index:background] Health check
[2024-06-02 12:40:27] [indexer:background] Health check
[2024-06-02 12:44:05] [index:background] Health check
[2024-06-02 12:44:44] [indexer:background] Health check
[2024-06-02 12:49:00] [index:background] Health check
[2024-06-02 12:50:08] [indexer:background] Health check
[2024-06-02 12:53:43] [index:background] Health check
[2024-06-02 12:54:48] [indexer:background] Health check
[2024-06-02 12:58:52] [index:background] Health check
[2024-06-02 13:00:15] [indexer:background] Health check
[2024-06-02 13:03:55] [index:background] Health check
[2024-06-02 13:05:42] [indexer:background] Health check
[2024-06-02 13:08:58] [index:background] Health check
[2024-06-02 13:09:40] [indexer:background] Health check
[2024-06-02 13:14:08] [index:background] Health check
[2024-06-02 13:14:22] [indexer:background] Health check
[2024-06-02 13:20:36] [index:background] Health check
[2024-06-02 13:20:36] [indexer:background] Health check
[2024-06-02 13:20:36] [indexer:background] Health check
[2024-06-02 13:24:48] [index:background] Health check
[2024-06-02 13:24:48] [indexer:background] Health check
[2024-06-02 13:24:48] [indexer:background] Health check
[2024-06-02 13:29:00] [index:background] Health check
[2024-06-02 13:29:37] [indexer:background] Health check
[2024-06-02 13:34:15] [index:background] Health check
[2024-06-02 13:34:15] [indexer:background] Health check
[2024-06-02 13:34:16] [indexer:background] Health check
[2024-06-02 13:38:53] [index:background] Health check
[2024-06-02 13:39:19] [indexer:background] Health check
[2024-06-02 13:46:15] [index:background] Health check
[2024-06-02 13:46:15] [indexer:background] Health check
[2024-06-02 13:46:15] [indexer:background] Health check
[2024-06-02 13:48:43] [index:background] Health check
[2024-06-02 13:49:25] [indexer:background] Health check
[2024-06-02 13:54:17] [index:background] Health check
[2024-06-02 13:54:17] [indexer:background] Health check
[2024-06-02 13:54:17] [indexer:background] Health check
[2024-06-02 13:59:49] [index:background] Health check
[2024-06-02 13:59:49] [indexer:background] Health check
[2024-06-02 13:59:49] [indexer:background] Health check
[2024-06-02 14:09:49] [index:background] Health check
[2024-06-02 14:09:49] [indexer:background] Health check
[2024-06-02 14:09:49] [indexer:background] Health check
[2024-06-02 14:14:46] [index:background] Health check
[2024-06-02 14:14:46] [indexer:background] Health check
[2024-06-02 14:14:46] [indexer:background] Health check
[2024-06-02 14:19:06] [index:background] Health check
[2024-06-02 14:19:42] [indexer:background] Health check
[2024-06-02 14:23:49] [index:background] Health check
[2024-06-02 14:24:20] [indexer:background] Health check
[2024-06-02 14:28:50] [index:background] Health check
[2024-06-02 14:30:11] [indexer:background] Health check
[2024-06-02 14:33:54] [index:background] Health check
[2024-06-02 14:34:57] [indexer:background] Health check
[2024-06-02 14:40:13] [index:background] Health check
[2024-06-02 14:40:13] [indexer:background] Health check
[2024-06-02 14:40:13] [indexer:background] Health check
[2024-06-02 14:44:13] [index:background] Health check
[2024-06-02 14:45:38] [indexer:background] Health check
[2024-06-02 14:48:54] [index:background] Health check
[2024-06-02 14:49:37] [indexer:background] Health check
[2024-06-02 14:54:00] [index:background] Health check
[2024-06-02 14:55:03] [indexer:background] Health check
[2024-06-02 15:00:08] [index:background] Health check
[2024-06-02 15:00:08] [indexer:background] Health check
[2024-06-02 15:00:08] [indexer:background] Health check
[2024-06-02 15:07:09] [index:background] Health check
[2024-06-02 15:07:09] [indexer:background] Health check
[2024-06-02 15:07:09] [indexer:background] Health check
[2024-06-02 15:09:56] [index:background] Health check
[2024-06-02 15:09:56] [indexer:background] Health check
[2024-06-02 15:09:56] [indexer:background] Health check
[2024-06-02 15:14:06] [index:background] Health check
[2024-06-02 15:16:45] [indexer:background] Health check
[2024-06-02 15:18:41] [index:background] Health check
[2024-06-02 15:20:03] [indexer:background] Health check
[2024-06-02 15:24:48] [index:background] Health check
[2024-06-02 15:24:48] [indexer:background] Health check
[2024-06-02 15:24:48] [indexer:background] Health check
[2024-06-02 15:29:54] [index:background] Health check
[2024-06-02 15:29:55] [indexer:background] Health check
[2024-06-02 15:29:55] [indexer:background] Health check
[2024-06-02 15:34:04] [index:background] Health check
[2024-06-02 15:35:08] [indexer:background] Health check
[2024-06-02 15:40:11] [index:background] Health check
[2024-06-02 15:40:11] [indexer:background] Health check
[2024-06-02 15:40:11] [indexer:background] Health check
[2024-06-02 15:46:29] [index:background] Health check
[2024-06-02 15:46:29] [indexer:background] Health check
[2024-06-02 15:46:29] [indexer:background] Health check
[2024-06-02 15:49:15] [index:background] Health check
[2024-06-02 15:49:15] [indexer:background] Health check
[2024-06-02 15:49:15] [indexer:background] Health check
[2024-06-02 15:53:50] [index:background] Health check
[2024-06-02 15:54:49] [indexer:background] Health check
[2024-06-02 15:58:49] [index:background] Health check
[2024-06-02 15:59:16] [indexer:background] Health check
[2024-06-02 16:06:00] [index:background] Health check
[2024-06-02 16:06:00] [indexer:background] Health check
[2024-06-02 16:06:00] [indexer:background] Health check
[2024-06-02 16:09:44] [index:background] Health check
[2024-06-02 16:09:44] [indexer:background] Health check
[2024-06-02 16:09:44] [indexer:background] Health check
[2024-06-02 16:14:22] [index:background] Health check
[2024-06-02 16:14:22] [indexer:background] Health check
[2024-06-02 16:14:22] [indexer:background] Health check
[2024-06-02 16:21:18] [index:background] Health check
[2024-06-02 16:21:18] [indexer:background] Health check
[2024-06-02 16:21:18] [indexer:background] Health check
[2024-06-02 16:24:00] [index:background] Health check
[2024-06-02 16:24:17] [indexer:background] Health check
[2024-06-02 16:28:48] [index:background] Health check
[2024-06-02 16:29:37] [indexer:background] Health check
[2024-06-02 16:34:00] [index:background] Health check
[2024-06-02 16:34:46] [indexer:background] Health check
[2024-06-02 16:39:29] [index:background] Health check
[2024-06-02 16:39:29] [indexer:background] Health check
[2024-06-02 16:39:29] [indexer:background] Health check
[2024-06-02 16:44:53] [index:background] Health check
[2024-06-02 16:44:53] [indexer:background] Health check
[2024-06-02 16:44:53] [indexer:background] Health check
[2024-06-02 16:48:58] [index:background] Health check
[2024-06-02 16:50:12] [indexer:background] Health check
[2024-06-02 16:55:27] [index:background] Health check
[2024-06-02 16:55:27] [indexer:background] Health check
[2024-06-02 16:55:27] [indexer:background] Health check
[2024-06-02 17:04:47] [index:background] Health check
[2024-06-02 17:04:47] [indexer:background] Health check
[2024-06-02 17:04:47] [indexer:background] Health check
[2024-06-02 17:09:49] [index:background] Health check
[2024-06-02 17:09:49] [indexer:background] Health check
[2024-06-02 17:09:49] [indexer:background] Health check
[2024-06-02 17:14:55] [index:background] Health check
[2024-06-02 17:14:56] [indexer:background] Health check
[2024-06-02 17:14:56] [indexer:background] Health check
[2024-06-02 17:19:50] [index:background] Health check
[2024-06-02 17:19:50] [indexer:background] Health check
[2024-06-02 17:19:50] [indexer:background] Health check
[2024-06-02 17:24:43] [index:background] Health check
[2024-06-02 17:24:43] [indexer:background] Health check
[2024-06-02 17:24:44] [indexer:background] Health check
[2024-06-02 17:28:52] [index:background] Health check
[2024-06-02 17:29:53] [indexer:background] Health check
[2024-06-02 17:34:12] [index:background] Health check
[2024-06-02 17:37:14] [indexer:background] Health check
[2024-06-02 17:41:15] [index:background] Health check
[2024-06-02 17:41:16] [indexer:background] Health check
[2024-06-02 17:41:16] [indexer:background] Health check
[2024-06-02 17:43:45] [index:background] Health check
[2024-06-02 17:44:21] [indexer:background] Health check
[2024-06-02 17:48:51] [index:background] Health check
[2024-06-02 17:49:57] [indexer:background] Health check
[2024-06-02 17:54:57] [index:background] Health check
[2024-06-02 17:54:57] [indexer:background] Health check
[2024-06-02 17:54:57] [indexer:background] Health check
[2024-06-02 17:59:38] [index:background] Health check
[2024-06-02 17:59:38] [indexer:background] Health check
[2024-06-02 17:59:38] [indexer:background] Health check
[2024-06-02 18:04:48] [index:background] Health check
[2024-06-02 18:04:48] [indexer:background] Health check
[2024-06-02 18:04:48] [indexer:background] Health check
[2024-06-02 18:08:49] [index:background] Health check
[2024-06-02 18:09:03] [query] Query for: search_term_string
[2024-06-02 18:09:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-06-02 18:09:03] [query] Engine: default
[2024-06-02 18:09:04] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-06-02 18:09:04] [query] Mods: 6
[2024-06-02 18:09:04] [query] Using OR logic
[2024-06-02 18:09:05] [query] Found results using: or logic
[2024-06-02 18:09: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 (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-06-02 18:09:05] [query] Results: 1364 Pages of results: 137
[2024-06-02 18:09:05] [query] Execution time: 1.22772
[2024-06-02 18:09:32] [indexer:background] Health check
[2024-06-02 18:15:19] [index:background] Health check
[2024-06-02 18:15:19] [indexer:background] Health check
[2024-06-02 18:15:19] [indexer:background] Health check
[2024-06-02 18:21:15] [index:background] Health check
[2024-06-02 18:21:15] [indexer:background] Health check
[2024-06-02 18:21:15] [indexer:background] Health check
[2024-06-02 18:24:02] [index:background] Health check
[2024-06-02 18:24:50] [indexer:background] Health check
[2024-06-02 18:29:09] [index:background] Health check
[2024-06-02 18:30:05] [indexer:background] Health check
[2024-06-02 18:34:03] [index:background] Health check
[2024-06-02 18:34:41] [indexer:background] Health check
[2024-06-02 18:38:45] [index:background] Health check
[2024-06-02 18:39:16] [indexer:background] Health check
[2024-06-02 18:44:22] [index:background] Health check
[2024-06-02 18:44:22] [indexer:background] Health check
[2024-06-02 18:44:22] [indexer:background] Health check
[2024-06-02 18:49:03] [index:background] Health check
[2024-06-02 18:50:04] [indexer:background] Health check
[2024-06-02 18:54:42] [index:background] Health check
[2024-06-02 18:54:42] [indexer:background] Health check
[2024-06-02 18:54:42] [indexer:background] Health check
[2024-06-02 18:58:53] [index:background] Health check
[2024-06-02 19:00:08] [indexer:background] Health check
[2024-06-02 19:03:56] [index:background] Health check
[2024-06-02 19:04:24] [indexer:background] Health check
[2024-06-02 19:09:55] [index:background] Health check
[2024-06-02 19:09:55] [indexer:background] Health check
[2024-06-02 19:09:55] [indexer:background] Health check
[2024-06-02 19:14:08] [index:background] Health check
[2024-06-02 19:15:32] [indexer:background] Health check
[2024-06-02 19:19:16] [index:background] Health check
[2024-06-02 19:19:16] [indexer:background] Health check
[2024-06-02 19:19:16] [indexer:background] Health check
[2024-06-02 19:23:51] [index:background] Health check
[2024-06-02 19:25:20] [indexer:background] Health check
[2024-06-02 19:29:53] [index:background] Health check
[2024-06-02 19:29:53] [indexer:background] Health check
[2024-06-02 19:29:53] [indexer:background] Health check
[2024-06-02 19:33:50] [index:background] Health check
[2024-06-02 19:34:38] [indexer:background] Health check
[2024-06-02 19:39:18] [index:background] Health check
[2024-06-02 19:39:19] [indexer:background] Health check
[2024-06-02 19:39:19] [indexer:background] Health check
[2024-06-02 19:44:04] [index:background] Health check
[2024-06-02 19:44:40] [indexer:background] Health check
[2024-06-02 19:48:51] [index:background] Health check
[2024-06-02 19:49:49] [indexer:background] Health check
[2024-06-02 19:54:01] [index:background] Health check
[2024-06-02 19:55:15] [indexer:background] Health check
[2024-06-02 20:00:35] [index:background] Health check
[2024-06-02 20:00:35] [indexer:background] Health check
[2024-06-02 20:00:36] [indexer:background] Health check
[2024-06-02 20:04:14] [index:background] Health check
[2024-06-02 20:05:17] [indexer:background] Health check
[2024-06-02 20:12:45] [index:background] Health check
[2024-06-02 20:12:45] [indexer:background] Health check
[2024-06-02 20:12:45] [indexer:background] Health check
[2024-06-02 20:14:27] [index:background] Health check
[2024-06-02 20:14:27] [indexer:background] Health check
[2024-06-02 20:14:27] [indexer:background] Health check
[2024-06-02 20:20:16] [index:background] Health check
[2024-06-02 20:20:16] [indexer:background] Health check
[2024-06-02 20:20:16] [indexer:background] Health check
[2024-06-02 20:23:44] [index:background] Health check
[2024-06-02 20:26:24] [indexer:background] Health check
[2024-06-02 20:29:05] [index:background] Health check
[2024-06-02 20:30:25] [indexer:background] Health check
[2024-06-02 20:34:03] [index:background] Health check
[2024-06-02 20:34:19] [indexer:background] Health check
[2024-06-02 20:38:42] [index:background] Health check
[2024-06-02 20:41:28] [indexer:background] Health check
[2024-06-02 20:45:32] [index:background] Health check
[2024-06-02 20:45:32] [indexer:background] Health check
[2024-06-02 20:45:32] [indexer:background] Health check
[2024-06-02 20:48:43] [index:background] Health check
[2024-06-02 20:49:23] [indexer:background] Health check
[2024-06-02 20:54:32] [index:background] Health check
[2024-06-02 20:54:32] [indexer:background] Health check
[2024-06-02 20:54:32] [indexer:background] Health check
[2024-06-02 20:59:50] [index:background] Health check
[2024-06-02 20:59:50] [indexer:background] Health check
[2024-06-02 20:59:50] [indexer:background] Health check
[2024-06-02 21:03:55] [index:background] Health check
[2024-06-02 21:06:56] [indexer:background] Health check
[2024-06-02 21:10:20] [index:background] Health check
[2024-06-02 21:10:20] [indexer:background] Health check
[2024-06-02 21:10:20] [indexer:background] Health check
[2024-06-02 21:14:17] [index:background] Health check
[2024-06-02 21:14:17] [indexer:background] Health check
[2024-06-02 21:14:17] [indexer:background] Health check
[2024-06-02 21:18:52] [index:background] Health check
[2024-06-02 21:20:32] [indexer:background] Health check
[2024-06-02 21:26:03] [index:background] Health check
[2024-06-02 21:26:03] [indexer:background] Health check
[2024-06-02 21:26:03] [indexer:background] Health check
[2024-06-02 21:28:44] [index:background] Health check
[2024-06-02 21:30:19] [indexer:background] Health check
[2024-06-02 21:34:29] [index:background] Health check
[2024-06-02 21:34:29] [indexer:background] Health check
[2024-06-02 21:34:29] [indexer:background] Health check
[2024-06-02 21:39:17] [index:background] Health check
[2024-06-02 21:39:17] [indexer:background] Health check
[2024-06-02 21:39:17] [indexer:background] Health check
[2024-06-02 21:43:49] [index:background] Health check
[2024-06-02 21:44:44] [indexer:background] Health check
[2024-06-02 21:49:17] [index:background] Health check
[2024-06-02 21:49:17] [indexer:background] Health check
[2024-06-02 21:49:17] [indexer:background] Health check
[2024-06-02 21:54:26] [index:background] Health check
[2024-06-02 21:54:26] [indexer:background] Health check
[2024-06-02 21:54:26] [indexer:background] Health check
[2024-06-02 21:59:31] [index:background] Health check
[2024-06-02 21:59:31] [indexer:background] Health check
[2024-06-02 21:59:31] [indexer:background] Health check
[2024-06-02 22:03:46] [index:background] Health check
[2024-06-02 22:05:05] [indexer:background] Health check
[2024-06-02 22:08:42] [index:background] Health check
[2024-06-02 22:09:16] [indexer:background] Health check
[2024-06-02 22:14:02] [index:background] Health check
[2024-06-02 22:14:25] [indexer:background] Health check
[2024-06-02 22:18:50] [index:background] Health check
[2024-06-02 22:19:57] [indexer:background] Health check
[2024-06-02 22:24:31] [index:background] Health check
[2024-06-02 22:24:31] [indexer:background] Health check
[2024-06-02 22:24:32] [indexer:background] Health check
[2024-06-02 22:29:42] [index:background] Health check
[2024-06-02 22:29:42] [indexer:background] Health check
[2024-06-02 22:29:42] [indexer:background] Health check
[2024-06-02 22:33:43] [index:background] Health check
[2024-06-02 22:36:55] [indexer:background] Health check
[2024-06-02 22:39:17] [index:background] Health check
[2024-06-02 22:39:17] [indexer:background] Health check
[2024-06-02 22:39:17] [indexer:background] Health check
[2024-06-02 22:45:52] [index:background] Health check
[2024-06-02 22:45:52] [indexer:background] Health check
[2024-06-02 22:45:52] [indexer:background] Health check
[2024-06-02 22:48:42] [index:background] Health check
[2024-06-02 22:50:42] [indexer:background] Health check
[2024-06-02 22:54:23] [index:background] Health check
[2024-06-02 22:54:23] [indexer:background] Health check
[2024-06-02 22:54:23] [indexer:background] Health check
[2024-06-02 23:01:34] [index:background] Health check
[2024-06-02 23:01:34] [indexer:background] Health check
[2024-06-02 23:01:34] [indexer:background] Health check
[2024-06-02 23:08:06] [index:background] Health check
[2024-06-02 23:08:06] [indexer:background] Health check
[2024-06-02 23:08:06] [indexer:background] Health check
[2024-06-02 23:10:53] [index:background] Health check
[2024-06-02 23:10:54] [indexer:background] Health check
[2024-06-02 23:10:54] [indexer:background] Health check
[2024-06-02 23:16:26] [index:background] Health check
[2024-06-02 23:16:26] [indexer:background] Health check
[2024-06-02 23:16:26] [indexer:background] Health check
[2024-06-02 23:18:44] [index:background] Health check
[2024-06-02 23:19:58] [indexer:background] Health check
[2024-06-02 23:23:42] [index:background] Health check
[2024-06-02 23:24:19] [indexer:background] Health check
[2024-06-02 23:28:58] [index:background] Health check
[2024-06-02 23:30:00] [indexer:background] Health check
[2024-06-02 23:34:33] [index:background] Health check
[2024-06-02 23:34:33] [indexer:background] Health check
[2024-06-02 23:34:33] [indexer:background] Health check
[2024-06-02 23:39:24] [index:background] Health check
[2024-06-02 23:39:24] [indexer:background] Health check
[2024-06-02 23:39:24] [indexer:background] Health check
[2024-06-02 23:44:10] [index:background] Health check
[2024-06-02 23:44:50] [indexer:background] Health check
[2024-06-02 23:49:05] [index:background] Health check
[2024-06-02 23:50:21] [indexer:background] Health check
[2024-06-02 23:54:07] [index:background] Health check
[2024-06-02 23:55:22] [indexer:background] Health check
[2024-06-02 23:59:34] [index:background] Health check
[2024-06-02 23:59:34] [indexer:background] Health check
[2024-06-02 23:59:34] [indexer:background] Health check