[2024-03-23 00:02:14] [index:background] Health check [2024-03-23 00:02:14] [indexer:background] Health check [2024-03-23 00:02:14] [indexer:background] Health check [2024-03-23 00:08:40] [index:background] Health check [2024-03-23 00:08:40] [indexer:background] Health check [2024-03-23 00:08:40] [indexer:background] Health check [2024-03-23 00:12:06] [index:background] Health check [2024-03-23 00:12:32] [indexer:background] Health check [2024-03-23 00:17:34] [index:background] Health check [2024-03-23 00:17:34] [indexer:background] Health check [2024-03-23 00:17:34] [indexer:background] Health check [2024-03-23 00:22:08] [index:background] Health check [2024-03-23 00:23:35] [indexer:background] Health check [2024-03-23 00:27:09] [index:background] Health check [2024-03-23 00:27:30] [indexer:background] Health check [2024-03-23 00:33:01] [index:background] Health check [2024-03-23 00:33:01] [indexer:background] Health check [2024-03-23 00:33:01] [indexer:background] Health check [2024-03-23 00:37:11] [index:background] Health check [2024-03-23 00:37:11] [indexer:background] Health check [2024-03-23 00:37:11] [indexer:background] Health check [2024-03-23 00:44:08] [index:background] Health check [2024-03-23 00:44:08] [indexer:background] Health check [2024-03-23 00:44:08] [indexer:background] Health check [2024-03-23 00:47:46] [index:background] Health check [2024-03-23 00:47:46] [indexer:background] Health check [2024-03-23 00:47:46] [indexer:background] Health check [2024-03-23 00:52:04] [index:background] Health check [2024-03-23 00:52:48] [indexer:background] Health check [2024-03-23 00:58:21] [index:background] Health check [2024-03-23 00:58:21] [indexer:background] Health check [2024-03-23 00:58:21] [indexer:background] Health check [2024-03-23 01:02:14] [index:background] Health check [2024-03-23 01:02:14] [indexer:background] Health check [2024-03-23 01:02:14] [indexer:background] Health check [2024-03-23 01:07:15] [index:background] Health check [2024-03-23 01:07:15] [indexer:background] Health check [2024-03-23 01:07:15] [indexer:background] Health check [2024-03-23 01:13:27] [index:background] Health check [2024-03-23 01:13:27] [indexer:background] Health check [2024-03-23 01:13:27] [indexer:background] Health check [2024-03-23 01:17:08] [index:background] Health check [2024-03-23 01:17:22] [indexer:background] Health check [2024-03-23 01:22:53] [index:background] Health check [2024-03-23 01:22:53] [indexer:background] Health check [2024-03-23 01:22:53] [indexer:background] Health check [2024-03-23 01:27:47] [index:background] Health check [2024-03-23 01:27:47] [indexer:background] Health check [2024-03-23 01:27:47] [indexer:background] Health check [2024-03-23 01:34:01] [index:background] Health check [2024-03-23 01:34:01] [indexer:background] Health check [2024-03-23 01:34:01] [indexer:background] Health check [2024-03-23 01:39:14] [index:background] Health check [2024-03-23 01:39:14] [indexer:background] Health check [2024-03-23 01:39:14] [indexer:background] Health check [2024-03-23 01:42:51] [index:background] Health check [2024-03-23 01:42:51] [indexer:background] Health check [2024-03-23 01:42:51] [indexer:background] Health check [2024-03-23 01:48:23] [index:background] Health check [2024-03-23 01:48:23] [indexer:background] Health check [2024-03-23 01:48:23] [indexer:background] Health check [2024-03-23 01:52:09] [index:background] Health check [2024-03-23 01:53:28] [indexer:background] Health check [2024-03-23 01:58:13] [index:background] Health check [2024-03-23 01:58:13] [indexer:background] Health check [2024-03-23 01:58:13] [indexer:background] Health check [2024-03-23 02:02:40] [index:background] Health check [2024-03-23 02:02:40] [indexer:background] Health check [2024-03-23 02:02:40] [indexer:background] Health check [2024-03-23 02:08:58] [index:background] Health check [2024-03-23 02:08:58] [indexer:background] Health check [2024-03-23 02:08:58] [indexer:background] Health check [2024-03-23 02:13:24] [index:background] Health check [2024-03-23 02:13:24] [indexer:background] Health check [2024-03-23 02:13:24] [indexer:background] Health check [2024-03-23 02:17:46] [index:background] Health check [2024-03-23 02:17:46] [indexer:background] Health check [2024-03-23 02:17:46] [indexer:background] Health check [2024-03-23 02:22:16] [index:background] Health check [2024-03-23 02:22:16] [indexer:background] Health check [2024-03-23 02:22:16] [indexer:background] Health check [2024-03-23 02:28:28] [index:background] Health check [2024-03-23 02:28:28] [indexer:background] Health check [2024-03-23 02:28:28] [indexer:background] Health check [2024-03-23 02:32:36] [index:background] Health check [2024-03-23 02:32:36] [indexer:background] Health check [2024-03-23 02:32:36] [indexer:background] Health check [2024-03-23 02:37:28] [index:background] Health check [2024-03-23 02:37:29] [indexer:background] Health check [2024-03-23 02:37:29] [indexer:background] Health check [2024-03-23 02:42:46] [index:background] Health check [2024-03-23 02:42:46] [indexer:background] Health check [2024-03-23 02:42:46] [indexer:background] Health check [2024-03-23 02:47:03] [index:background] Health check [2024-03-23 02:47:14] [indexer:background] Health check [2024-03-23 02:52:26] [index:background] Health check [2024-03-23 02:52:26] [indexer:background] Health check [2024-03-23 02:52:26] [indexer:background] Health check [2024-03-23 02:57:48] [index:background] Health check [2024-03-23 02:57:48] [indexer:background] Health check [2024-03-23 02:57:48] [indexer:background] Health check [2024-03-23 03:02:31] [index:background] Health check [2024-03-23 03:02:31] [indexer:background] Health check [2024-03-23 03:02:31] [indexer:background] Health check [2024-03-23 03:08:17] [index:background] Health check [2024-03-23 03:08:17] [indexer:background] Health check [2024-03-23 03:08:17] [indexer:background] Health check [2024-03-23 03:12:35] [index:background] Health check [2024-03-23 03:12:35] [indexer:background] Health check [2024-03-23 03:12:35] [indexer:background] Health check [2024-03-23 03:17:21] [index:background] Health check [2024-03-23 03:17:21] [indexer:background] Health check [2024-03-23 03:17:21] [indexer:background] Health check [2024-03-23 03:22:31] [index:background] Health check [2024-03-23 03:22:31] [indexer:background] Health check [2024-03-23 03:22:31] [indexer:background] Health check [2024-03-23 03:22:37] [query] Query for: 2024 [2024-03-23 03:22:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 03:22:37] [query] Engine: default [2024-03-23 03:22:37] [query] Tokens: 2024 [2024-03-23 03:22:37] [query] Mods: 6 [2024-03-23 03:22:37] [query] Found results using: or logic [2024-03-23 03:22:37] [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-03-23 03:22:37] [query] Results: 144 Pages of results: 15 [2024-03-23 03:22:37] [query] Execution time: 0.42342 [2024-03-23 03:28:42] [index:background] Health check [2024-03-23 03:28:42] [indexer:background] Health check [2024-03-23 03:28:42] [indexer:background] Health check [2024-03-23 03:32:22] [index:background] Health check [2024-03-23 03:32:22] [indexer:background] Health check [2024-03-23 03:32:22] [indexer:background] Health check [2024-03-23 03:37:56] [index:background] Health check [2024-03-23 03:37:56] [indexer:background] Health check [2024-03-23 03:37:56] [indexer:background] Health check [2024-03-23 03:43:11] [index:background] Health check [2024-03-23 03:43:11] [indexer:background] Health check [2024-03-23 03:43:11] [indexer:background] Health check [2024-03-23 03:47:06] [index:background] Health check [2024-03-23 03:48:33] [query] Query for: 2024 [2024-03-23 03:48:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 03:48:33] [query] Engine: default [2024-03-23 03:48:33] [query] Tokens: 2024 [2024-03-23 03:48:33] [query] Mods: 6 [2024-03-23 03:48:33] [query] Found results using: or logic [2024-03-23 03:48:33] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-03-23 03:48:33] [query] Results: 144 Pages of results: 15 [2024-03-23 03:48:33] [query] Execution time: 0.04521 [2024-03-23 03:49:05] [indexer:background] Health check [2024-03-23 03:49:05] [indexer:background] Health check [2024-03-23 03:52:07] [index:background] Health check [2024-03-23 03:52:31] [indexer:background] Health check [2024-03-23 03:57:13] [index:background] Health check [2024-03-23 03:57:13] [indexer:background] Health check [2024-03-23 03:57:13] [indexer:background] Health check [2024-03-23 04:02:45] [index:background] Health check [2024-03-23 04:02:45] [indexer:background] Health check [2024-03-23 04:02:45] [indexer:background] Health check [2024-03-23 04:08:22] [index:background] Health check [2024-03-23 04:08:22] [indexer:background] Health check [2024-03-23 04:08:22] [indexer:background] Health check [2024-03-23 04:12:31] [index:background] Health check [2024-03-23 04:12:31] [indexer:background] Health check [2024-03-23 04:12:31] [indexer:background] Health check [2024-03-23 04:17:12] [index:background] Health check [2024-03-23 04:17:12] [indexer:background] Health check [2024-03-23 04:17:12] [indexer:background] Health check [2024-03-23 04:22:12] [index:background] Health check [2024-03-23 04:22:12] [indexer:background] Health check [2024-03-23 04:22:12] [indexer:background] Health check [2024-03-23 04:27:04] [index:background] Health check [2024-03-23 04:27:14] [indexer:background] Health check [2024-03-23 04:33:04] [index:background] Health check [2024-03-23 04:33:04] [indexer:background] Health check [2024-03-23 04:33:04] [indexer:background] Health check [2024-03-23 04:39:01] [index:background] Health check [2024-03-23 04:39:01] [indexer:background] Health check [2024-03-23 04:39:01] [indexer:background] Health check [2024-03-23 04:43:43] [index:background] Health check [2024-03-23 04:43:43] [indexer:background] Health check [2024-03-23 04:43:44] [indexer:background] Health check [2024-03-23 04:47:21] [index:background] Health check [2024-03-23 04:47:21] [indexer:background] Health check [2024-03-23 04:47:21] [indexer:background] Health check [2024-03-23 04:52:05] [index:background] Health check [2024-03-23 04:56:16] [indexer:background] Health check [2024-03-23 04:57:56] [index:background] Health check [2024-03-23 04:57:56] [indexer:background] Health check [2024-03-23 04:57:56] [indexer:background] Health check [2024-03-23 05:02:30] [index:background] Health check [2024-03-23 05:02:30] [indexer:background] Health check [2024-03-23 05:02:30] [indexer:background] Health check [2024-03-23 05:07:20] [index:background] Health check [2024-03-23 05:07:20] [indexer:background] Health check [2024-03-23 05:07:20] [indexer:background] Health check [2024-03-23 05:13:00] [index:background] Health check [2024-03-23 05:13:00] [indexer:background] Health check [2024-03-23 05:13:01] [indexer:background] Health check [2024-03-23 05:17:03] [index:background] Health check [2024-03-23 05:17:13] [indexer:background] Health check [2024-03-23 05:21:22] [query] Query for: search_term_string [2024-03-23 05:21:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 05:21:22] [query] Engine: default [2024-03-23 05:21:23] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-23 05:21:23] [query] Mods: 6 [2024-03-23 05:21:23] [query] Using OR logic [2024-03-23 05:21:23] [query] Found results using: or logic [2024-03-23 05:21:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10 [2024-03-23 05:21:23] [query] Results: 1356 Pages of results: 136 [2024-03-23 05:21:23] [query] Execution time: 1.17682 [2024-03-23 05:22:36] [index:background] Health check [2024-03-23 05:22:36] [indexer:background] Health check [2024-03-23 05:22:36] [indexer:background] Health check [2024-03-23 05:28:15] [index:background] Health check [2024-03-23 05:28:15] [indexer:background] Health check [2024-03-23 05:28:15] [indexer:background] Health check [2024-03-23 05:29:43] [query] Query for: search_term_string [2024-03-23 05:29:43] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 05:29:43] [query] Engine: default [2024-03-23 05:29:43] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-23 05:29:43] [query] Mods: 6 [2024-03-23 05:29:43] [query] Using OR logic [2024-03-23 05:29:43] [query] Found results using: or logic [2024-03-23 05:29:43] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-03-23 05:29:43] [query] Results: 1356 Pages of results: 136 [2024-03-23 05:29:43] [query] Execution time: 0.04198 [2024-03-23 05:32:28] [index:background] Health check [2024-03-23 05:32:28] [indexer:background] Health check [2024-03-23 05:32:28] [indexer:background] Health check [2024-03-23 05:38:09] [index:background] Health check [2024-03-23 05:38:09] [indexer:background] Health check [2024-03-23 05:38:09] [indexer:background] Health check [2024-03-23 05:42:21] [index:background] Health check [2024-03-23 05:42:21] [indexer:background] Health check [2024-03-23 05:42:21] [indexer:background] Health check [2024-03-23 05:47:59] [index:background] Health check [2024-03-23 05:47:59] [indexer:background] Health check [2024-03-23 05:47:59] [indexer:background] Health check [2024-03-23 05:52:07] [index:background] Health check [2024-03-23 05:52:15] [indexer:background] Health check [2024-03-23 05:57:45] [index:background] Health check [2024-03-23 05:57:45] [indexer:background] Health check [2024-03-23 05:57:45] [indexer:background] Health check [2024-03-23 06:02:27] [index:background] Health check [2024-03-23 06:02:27] [indexer:background] Health check [2024-03-23 06:02:27] [indexer:background] Health check [2024-03-23 06:07:32] [index:background] Health check [2024-03-23 06:07:32] [indexer:background] Health check [2024-03-23 06:07:32] [indexer:background] Health check [2024-03-23 06:13:09] [index:background] Health check [2024-03-23 06:13:09] [indexer:background] Health check [2024-03-23 06:13:09] [indexer:background] Health check [2024-03-23 06:17:21] [index:background] Health check [2024-03-23 06:17:21] [indexer:background] Health check [2024-03-23 06:17:21] [indexer:background] Health check [2024-03-23 06:22:22] [index:background] Health check [2024-03-23 06:22:22] [indexer:background] Health check [2024-03-23 06:22:22] [indexer:background] Health check [2024-03-23 06:27:57] [index:background] Health check [2024-03-23 06:27:57] [indexer:background] Health check [2024-03-23 06:27:58] [indexer:background] Health check [2024-03-23 06:32:06] [index:background] Health check [2024-03-23 06:32:34] [indexer:background] Health check [2024-03-23 06:37:05] [index:background] Health check [2024-03-23 06:37:39] [indexer:background] Health check [2024-03-23 06:43:09] [index:background] Health check [2024-03-23 06:43:09] [indexer:background] Health check [2024-03-23 06:43:09] [indexer:background] Health check [2024-03-23 06:49:07] [index:background] Health check [2024-03-23 06:49:07] [indexer:background] Health check [2024-03-23 06:49:07] [indexer:background] Health check [2024-03-23 06:52:57] [index:background] Health check [2024-03-23 06:52:57] [indexer:background] Health check [2024-03-23 06:52:57] [indexer:background] Health check [2024-03-23 06:57:10] [index:background] Health check [2024-03-23 06:57:53] [indexer:background] Health check [2024-03-23 07:02:48] [index:background] Health check [2024-03-23 07:02:48] [indexer:background] Health check [2024-03-23 07:02:48] [indexer:background] Health check [2024-03-23 07:07:39] [index:background] Health check [2024-03-23 07:07:39] [indexer:background] Health check [2024-03-23 07:07:39] [indexer:background] Health check [2024-03-23 07:13:28] [index:background] Health check [2024-03-23 07:13:28] [indexer:background] Health check [2024-03-23 07:13:28] [indexer:background] Health check [2024-03-23 07:17:08] [index:background] Health check [2024-03-23 07:19:32] [indexer:background] Health check [2024-03-23 07:22:23] [index:background] Health check [2024-03-23 07:22:23] [indexer:background] Health check [2024-03-23 07:22:23] [indexer:background] Health check [2024-03-23 07:27:16] [index:background] Health check [2024-03-23 07:27:16] [indexer:background] Health check [2024-03-23 07:27:16] [indexer:background] Health check [2024-03-23 07:32:10] [index:background] Health check [2024-03-23 07:33:17] [indexer:background] Health check [2024-03-23 07:37:04] [index:background] Health check [2024-03-23 07:37:12] [indexer:background] Health check [2024-03-23 07:42:23] [index:background] Health check [2024-03-23 07:42:23] [indexer:background] Health check [2024-03-23 07:42:23] [indexer:background] Health check [2024-03-23 07:47:17] [index:background] Health check [2024-03-23 07:47:17] [indexer:background] Health check [2024-03-23 07:47:17] [indexer:background] Health check [2024-03-23 07:52:55] [index:background] Health check [2024-03-23 07:52:55] [indexer:background] Health check [2024-03-23 07:52:55] [indexer:background] Health check [2024-03-23 07:57:09] [index:background] Health check [2024-03-23 07:57:16] [indexer:background] Health check [2024-03-23 08:02:48] [index:background] Health check [2024-03-23 08:02:48] [indexer:background] Health check [2024-03-23 08:02:48] [indexer:background] Health check [2024-03-23 08:07:09] [index:background] Health check [2024-03-23 08:07:19] [indexer:background] Health check [2024-03-23 08:13:25] [index:background] Health check [2024-03-23 08:13:25] [indexer:background] Health check [2024-03-23 08:13:25] [indexer:background] Health check [2024-03-23 08:17:40] [index:background] Health check [2024-03-23 08:17:40] [indexer:background] Health check [2024-03-23 08:17:40] [indexer:background] Health check [2024-03-23 08:22:24] [index:background] Health check [2024-03-23 08:22:24] [indexer:background] Health check [2024-03-23 08:22:24] [indexer:background] Health check [2024-03-23 08:27:13] [index:background] Health check [2024-03-23 08:27:13] [indexer:background] Health check [2024-03-23 08:27:13] [indexer:background] Health check [2024-03-23 08:32:02] [index:background] Health check [2024-03-23 08:32:45] [indexer:background] Health check [2024-03-23 08:37:25] [index:background] Health check [2024-03-23 08:37:25] [indexer:background] Health check [2024-03-23 08:37:25] [indexer:background] Health check [2024-03-23 08:42:31] [index:background] Health check [2024-03-23 08:42:31] [indexer:background] Health check [2024-03-23 08:42:31] [indexer:background] Health check [2024-03-23 08:47:08] [index:background] Health check [2024-03-23 08:47:41] [indexer:background] Health check [2024-03-23 08:52:43] [index:background] Health check [2024-03-23 08:52:43] [indexer:background] Health check [2024-03-23 08:52:43] [indexer:background] Health check [2024-03-23 08:57:06] [index:background] Health check [2024-03-23 08:57:33] [indexer:background] Health check [2024-03-23 09:02:50] [index:background] Health check [2024-03-23 09:02:50] [indexer:background] Health check [2024-03-23 09:02:50] [indexer:background] Health check [2024-03-23 09:09:05] [index:background] Health check [2024-03-23 09:09:05] [indexer:background] Health check [2024-03-23 09:09:05] [indexer:background] Health check [2024-03-23 09:12:27] [index:background] Health check [2024-03-23 09:12:27] [indexer:background] Health check [2024-03-23 09:12:27] [indexer:background] Health check [2024-03-23 09:17:41] [index:background] Health check [2024-03-23 09:17:41] [indexer:background] Health check [2024-03-23 09:17:41] [indexer:background] Health check [2024-03-23 09:24:30] [index:background] Health check [2024-03-23 09:24:30] [indexer:background] Health check [2024-03-23 09:24:30] [indexer:background] Health check [2024-03-23 09:27:26] [index:background] Health check [2024-03-23 09:27:26] [indexer:background] Health check [2024-03-23 09:27:26] [indexer:background] Health check [2024-03-23 09:32:38] [index:background] Health check [2024-03-23 09:32:38] [indexer:background] Health check [2024-03-23 09:32:38] [indexer:background] Health check [2024-03-23 09:37:36] [index:background] Health check [2024-03-23 09:37:37] [indexer:background] Health check [2024-03-23 09:37:37] [indexer:background] Health check [2024-03-23 09:43:13] [index:background] Health check [2024-03-23 09:43:13] [indexer:background] Health check [2024-03-23 09:43:13] [indexer:background] Health check [2024-03-23 09:47:07] [index:background] Health check [2024-03-23 09:47:17] [indexer:background] Health check [2024-03-23 09:54:33] [index:background] Health check [2024-03-23 09:54:33] [indexer:background] Health check [2024-03-23 09:54:33] [indexer:background] Health check [2024-03-23 09:57:04] [index:background] Health check [2024-03-23 09:59:29] [indexer:background] Health check [2024-03-23 10:02:23] [index:background] Health check [2024-03-23 10:02:23] [indexer:background] Health check [2024-03-23 10:02:23] [indexer:background] Health check [2024-03-23 10:07:30] [index:background] Health check [2024-03-23 10:07:30] [indexer:background] Health check [2024-03-23 10:07:30] [indexer:background] Health check [2024-03-23 10:12:08] [index:background] Health check [2024-03-23 10:13:15] [indexer:background] Health check [2024-03-23 10:17:18] [index:background] Health check [2024-03-23 10:17:18] [indexer:background] Health check [2024-03-23 10:17:18] [indexer:background] Health check [2024-03-23 10:22:11] [index:background] Health check [2024-03-23 10:22:11] [indexer:background] Health check [2024-03-23 10:22:11] [indexer:background] Health check [2024-03-23 10:28:13] [index:background] Health check [2024-03-23 10:28:13] [indexer:background] Health check [2024-03-23 10:28:13] [indexer:background] Health check [2024-03-23 10:32:48] [index:background] Health check [2024-03-23 10:32:48] [indexer:background] Health check [2024-03-23 10:32:48] [indexer:background] Health check [2024-03-23 10:37:21] [index:background] Health check [2024-03-23 10:37:21] [indexer:background] Health check [2024-03-23 10:37:21] [indexer:background] Health check [2024-03-23 10:42:28] [index:background] Health check [2024-03-23 10:42:28] [indexer:background] Health check [2024-03-23 10:42:28] [indexer:background] Health check [2024-03-23 10:49:13] [index:background] Health check [2024-03-23 10:49:13] [indexer:background] Health check [2024-03-23 10:49:13] [indexer:background] Health check [2024-03-23 10:52:14] [index:background] Health check [2024-03-23 10:52:14] [indexer:background] Health check [2024-03-23 10:52:14] [indexer:background] Health check [2024-03-23 10:57:21] [index:background] Health check [2024-03-23 10:57:21] [indexer:background] Health check [2024-03-23 10:57:21] [indexer:background] Health check [2024-03-23 11:02:47] [index:background] Health check [2024-03-23 11:02:47] [indexer:background] Health check [2024-03-23 11:02:47] [indexer:background] Health check [2024-03-23 11:07:16] [index:background] Health check [2024-03-23 11:07:16] [indexer:background] Health check [2024-03-23 11:07:16] [indexer:background] Health check [2024-03-23 11:12:58] [index:background] Health check [2024-03-23 11:12:58] [indexer:background] Health check [2024-03-23 11:12:58] [indexer:background] Health check [2024-03-23 11:17:04] [index:background] Health check [2024-03-23 11:17:18] [indexer:background] Health check [2024-03-23 11:22:58] [index:background] Health check [2024-03-23 11:22:58] [indexer:background] Health check [2024-03-23 11:22:58] [indexer:background] Health check [2024-03-23 11:27:32] [index:background] Health check [2024-03-23 11:27:32] [indexer:background] Health check [2024-03-23 11:27:32] [indexer:background] Health check [2024-03-23 11:32:21] [index:background] Health check [2024-03-23 11:32:21] [indexer:background] Health check [2024-03-23 11:32:21] [indexer:background] Health check [2024-03-23 11:37:14] [index:background] Health check [2024-03-23 11:37:14] [indexer:background] Health check [2024-03-23 11:37:14] [indexer:background] Health check [2024-03-23 11:44:03] [index:background] Health check [2024-03-23 11:44:03] [indexer:background] Health check [2024-03-23 11:44:03] [indexer:background] Health check [2024-03-23 11:47:41] [index:background] Health check [2024-03-23 11:47:41] [indexer:background] Health check [2024-03-23 11:47:41] [indexer:background] Health check [2024-03-23 11:52:02] [index:background] Health check [2024-03-23 11:53:03] [indexer:background] Health check [2024-03-23 11:57:59] [index:background] Health check [2024-03-23 11:57:59] [indexer:background] Health check [2024-03-23 11:57:59] [indexer:background] Health check [2024-03-23 12:02:10] [index:background] Health check [2024-03-23 12:02:13] [indexer:background] Health check [2024-03-23 12:09:24] [index:background] Health check [2024-03-23 12:09:24] [indexer:background] Health check [2024-03-23 12:09:24] [indexer:background] Health check [2024-03-23 12:12:30] [index:background] Health check [2024-03-23 12:12:30] [indexer:background] Health check [2024-03-23 12:12:30] [indexer:background] Health check [2024-03-23 12:19:05] [index:background] Health check [2024-03-23 12:19:05] [indexer:background] Health check [2024-03-23 12:19:05] [indexer:background] Health check [2024-03-23 12:24:52] [index:background] Health check [2024-03-23 12:24:52] [indexer:background] Health check [2024-03-23 12:24:52] [indexer:background] Health check [2024-03-23 12:29:17] [index:background] Health check [2024-03-23 12:29:17] [indexer:background] Health check [2024-03-23 12:29:17] [indexer:background] Health check [2024-03-23 12:32:02] [index:background] Health check [2024-03-23 12:32:18] [indexer:background] Health check [2024-03-23 12:37:05] [index:background] Health check [2024-03-23 12:37:13] [indexer:background] Health check [2024-03-23 12:42:08] [index:background] Health check [2024-03-23 12:43:46] [indexer:background] Health check [2024-03-23 12:47:18] [index:background] Health check [2024-03-23 12:47:18] [indexer:background] Health check [2024-03-23 12:47:18] [indexer:background] Health check [2024-03-23 12:52:29] [index:background] Health check [2024-03-23 12:52:29] [indexer:background] Health check [2024-03-23 12:52:29] [indexer:background] Health check [2024-03-23 12:57:36] [index:background] Health check [2024-03-23 12:57:36] [indexer:background] Health check [2024-03-23 12:57:36] [indexer:background] Health check [2024-03-23 13:02:25] [index:background] Health check [2024-03-23 13:02:25] [indexer:background] Health check [2024-03-23 13:02:25] [indexer:background] Health check [2024-03-23 13:07:22] [index:background] Health check [2024-03-23 13:07:22] [indexer:background] Health check [2024-03-23 13:07:22] [indexer:background] Health check [2024-03-23 13:12:52] [index:background] Health check [2024-03-23 13:12:52] [indexer:background] Health check [2024-03-23 13:12:52] [indexer:background] Health check [2024-03-23 13:18:25] [index:background] Health check [2024-03-23 13:18:25] [indexer:background] Health check [2024-03-23 13:18:25] [indexer:background] Health check [2024-03-23 13:22:09] [index:background] Health check [2024-03-23 13:23:01] [indexer:background] Health check [2024-03-23 13:28:10] [index:background] Health check [2024-03-23 13:28:10] [indexer:background] Health check [2024-03-23 13:28:10] [indexer:background] Health check [2024-03-23 13:32:52] [index:background] Health check [2024-03-23 13:32:52] [indexer:background] Health check [2024-03-23 13:32:52] [indexer:background] Health check [2024-03-23 13:37:18] [index:background] Health check [2024-03-23 13:37:18] [indexer:background] Health check [2024-03-23 13:37:18] [indexer:background] Health check [2024-03-23 13:42:19] [index:background] Health check [2024-03-23 13:42:19] [indexer:background] Health check [2024-03-23 13:42:19] [indexer:background] Health check [2024-03-23 13:47:17] [index:background] Health check [2024-03-23 13:47:17] [indexer:background] Health check [2024-03-23 13:47:17] [indexer:background] Health check [2024-03-23 13:52:14] [index:background] Health check [2024-03-23 13:52:14] [indexer:background] Health check [2024-03-23 13:52:14] [indexer:background] Health check [2024-03-23 13:58:28] [index:background] Health check [2024-03-23 13:58:28] [indexer:background] Health check [2024-03-23 13:58:28] [indexer:background] Health check [2024-03-23 14:03:09] [index:background] Health check [2024-03-23 14:03:09] [indexer:background] Health check [2024-03-23 14:03:09] [indexer:background] Health check [2024-03-23 14:08:15] [index:background] Health check [2024-03-23 14:08:15] [indexer:background] Health check [2024-03-23 14:08:15] [indexer:background] Health check [2024-03-23 14:12:53] [index:background] Health check [2024-03-23 14:12:53] [indexer:background] Health check [2024-03-23 14:12:53] [indexer:background] Health check [2024-03-23 14:17:40] [index:background] Health check [2024-03-23 14:17:40] [indexer:background] Health check [2024-03-23 14:17:40] [indexer:background] Health check [2024-03-23 14:22:35] [index:background] Health check [2024-03-23 14:22:35] [indexer:background] Health check [2024-03-23 14:22:35] [indexer:background] Health check [2024-03-23 14:27:44] [index:background] Health check [2024-03-23 14:27:44] [indexer:background] Health check [2024-03-23 14:27:44] [indexer:background] Health check [2024-03-23 14:32:27] [index:background] Health check [2024-03-23 14:32:27] [indexer:background] Health check [2024-03-23 14:32:27] [indexer:background] Health check [2024-03-23 14:37:03] [index:background] Health check [2024-03-23 14:37:22] [indexer:background] Health check [2024-03-23 14:45:10] [index:background] Health check [2024-03-23 14:45:10] [indexer:background] Health check [2024-03-23 14:45:10] [indexer:background] Health check [2024-03-23 14:47:50] [index:background] Health check [2024-03-23 14:47:50] [indexer:background] Health check [2024-03-23 14:47:50] [indexer:background] Health check [2024-03-23 14:52:50] [index:background] Health check [2024-03-23 14:52:50] [indexer:background] Health check [2024-03-23 14:52:50] [indexer:background] Health check [2024-03-23 14:57:27] [index:background] Health check [2024-03-23 14:57:27] [indexer:background] Health check [2024-03-23 14:57:27] [indexer:background] Health check [2024-03-23 15:02:03] [index:background] Health check [2024-03-23 15:02:48] [indexer:background] Health check [2024-03-23 15:07:44] [index:background] Health check [2024-03-23 15:07:44] [indexer:background] Health check [2024-03-23 15:07:44] [indexer:background] Health check [2024-03-23 15:12:07] [index:background] Health check [2024-03-23 15:12:21] [indexer:background] Health check [2024-03-23 15:17:14] [index:background] Health check [2024-03-23 15:17:14] [indexer:background] Health check [2024-03-23 15:17:14] [indexer:background] Health check [2024-03-23 15:19:14] [query] Query for: search_term_string [2024-03-23 15:19:14] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 15:19:14] [query] Engine: default [2024-03-23 15:19:14] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-23 15:19:14] [query] Mods: 6 [2024-03-23 15:19:14] [query] Using OR logic [2024-03-23 15:19:14] [query] Found results using: or logic [2024-03-23 15:19:14] [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-03-23 15:19:14] [query] Results: 1356 Pages of results: 136 [2024-03-23 15:19:14] [query] Execution time: 0.04879 [2024-03-23 15:22:31] [index:background] Health check [2024-03-23 15:22:31] [indexer:background] Health check [2024-03-23 15:22:31] [indexer:background] Health check [2024-03-23 15:24:33] [query] Query for: opticiens [2024-03-23 15:24:33] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 15:24:33] [query] Engine: default [2024-03-23 15:24:33] [query] Tokens: opticien [2024-03-23 15:24:33] [query] Mods: 6 [2024-03-23 15:24:33] [query] Found results using: or logic [2024-03-23 15:24:33] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END) ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (543937) 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-03-23 15:24:33] [query] Results: 8 Pages of results: 1 [2024-03-23 15:24:33] [query] Execution time: 0.65919 [2024-03-23 15:27:07] [index:background] Health check [2024-03-23 15:29:35] [indexer:background] Health check [2024-03-23 15:34:44] [index:background] Health check [2024-03-23 15:34:44] [indexer:background] Health check [2024-03-23 15:34:44] [indexer:background] Health check [2024-03-23 15:36:40] [query] Query for: search_term_string [2024-03-23 15:36:40] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 15:36:40] [query] Engine: default [2024-03-23 15:36:40] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string [2024-03-23 15:36:40] [query] Mods: 6 [2024-03-23 15:36:40] [query] Using OR logic [2024-03-23 15:36:40] [query] Found results using: or logic [2024-03-23 15:36: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 (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-03-23 15:36:40] [query] Results: 1356 Pages of results: 136 [2024-03-23 15:36:40] [query] Execution time: 0.03901 [2024-03-23 15:37:03] [index:background] Health check [2024-03-23 15:38:30] [indexer:background] Health check [2024-03-23 15:42:40] [index:background] Health check [2024-03-23 15:42:40] [indexer:background] Health check [2024-03-23 15:42:40] [indexer:background] Health check [2024-03-23 15:47:18] [index:background] Health check [2024-03-23 15:47:18] [indexer:background] Health check [2024-03-23 15:47:18] [indexer:background] Health check [2024-03-23 15:52:25] [index:background] Health check [2024-03-23 15:52:25] [indexer:background] Health check [2024-03-23 15:52:25] [indexer:background] Health check [2024-03-23 15:57:06] [index:background] Health check [2024-03-23 15:57:12] [indexer:background] Health check [2024-03-23 16:02:12] [index:background] Health check [2024-03-23 16:02:18] [indexer:background] Health check [2024-03-23 16:07:12] [index:background] Health check [2024-03-23 16:07:12] [indexer:background] Health check [2024-03-23 16:07:12] [indexer:background] Health check [2024-03-23 16:12:25] [index:background] Health check [2024-03-23 16:12:25] [indexer:background] Health check [2024-03-23 16:12:25] [indexer:background] Health check [2024-03-23 16:17:10] [index:background] Health check [2024-03-23 16:18:16] [indexer:background] Health check [2024-03-23 16:22:23] [index:background] Health check [2024-03-23 16:22:23] [indexer:background] Health check [2024-03-23 16:22:23] [indexer:background] Health check [2024-03-23 16:28:06] [index:background] Health check [2024-03-23 16:28:06] [indexer:background] Health check [2024-03-23 16:28:06] [indexer:background] Health check [2024-03-23 16:32:03] [index:background] Health check [2024-03-23 16:32:21] [indexer:background] Health check [2024-03-23 16:37:35] [index:background] Health check [2024-03-23 16:37:35] [indexer:background] Health check [2024-03-23 16:37:35] [indexer:background] Health check [2024-03-23 16:42:35] [index:background] Health check [2024-03-23 16:42:35] [indexer:background] Health check [2024-03-23 16:42:35] [indexer:background] Health check [2024-03-23 16:47:17] [index:background] Health check [2024-03-23 16:47:17] [indexer:background] Health check [2024-03-23 16:47:18] [indexer:background] Health check [2024-03-23 16:52:33] [index:background] Health check [2024-03-23 16:52:33] [indexer:background] Health check [2024-03-23 16:52:33] [indexer:background] Health check [2024-03-23 16:57:20] [index:background] Health check [2024-03-23 16:57:21] [indexer:background] Health check [2024-03-23 16:57:21] [indexer:background] Health check [2024-03-23 17:02:04] [index:background] Health check [2024-03-23 17:03:30] [indexer:background] Health check [2024-03-23 17:07:55] [index:background] Health check [2024-03-23 17:07:55] [indexer:background] Health check [2024-03-23 17:07:55] [indexer:background] Health check [2024-03-23 17:13:16] [index:background] Health check [2024-03-23 17:13:16] [indexer:background] Health check [2024-03-23 17:13:16] [indexer:background] Health check [2024-03-23 17:17:19] [index:background] Health check [2024-03-23 17:17:19] [indexer:background] Health check [2024-03-23 17:17:19] [indexer:background] Health check [2024-03-23 17:22:05] [index:background] Health check [2024-03-23 17:23:33] [indexer:background] Health check [2024-03-23 17:27:45] [index:background] Health check [2024-03-23 17:27:45] [indexer:background] Health check [2024-03-23 17:27:45] [indexer:background] Health check [2024-03-23 17:32:55] [index:background] Health check [2024-03-23 17:32:55] [indexer:background] Health check [2024-03-23 17:32:55] [indexer:background] Health check [2024-03-23 17:37:14] [index:background] Health check [2024-03-23 17:37:14] [indexer:background] Health check [2024-03-23 17:37:14] [indexer:background] Health check [2024-03-23 17:43:41] [index:background] Health check [2024-03-23 17:43:41] [indexer:background] Health check [2024-03-23 17:43:41] [indexer:background] Health check [2024-03-23 17:47:12] [index:background] Health check [2024-03-23 17:47:12] [indexer:background] Health check [2024-03-23 17:47:12] [indexer:background] Health check [2024-03-23 17:52:44] [index:background] Health check [2024-03-23 17:52:44] [indexer:background] Health check [2024-03-23 17:52:44] [indexer:background] Health check [2024-03-23 17:57:02] [index:background] Health check [2024-03-23 17:58:07] [indexer:background] Health check [2024-03-23 18:02:03] [index:background] Health check [2024-03-23 18:02:29] [indexer:background] Health check [2024-03-23 18:08:50] [index:background] Health check [2024-03-23 18:08:50] [indexer:background] Health check [2024-03-23 18:08:50] [indexer:background] Health check [2024-03-23 18:12:21] [index:background] Health check [2024-03-23 18:12:21] [indexer:background] Health check [2024-03-23 18:12:21] [indexer:background] Health check [2024-03-23 18:17:29] [index:background] Health check [2024-03-23 18:17:29] [indexer:background] Health check [2024-03-23 18:17:29] [indexer:background] Health check [2024-03-23 18:22:37] [index:background] Health check [2024-03-23 18:22:37] [indexer:background] Health check [2024-03-23 18:22:37] [indexer:background] Health check [2024-03-23 18:27:07] [index:background] Health check [2024-03-23 18:27:24] [indexer:background] Health check [2024-03-23 18:34:25] [index:background] Health check [2024-03-23 18:34:25] [indexer:background] Health check [2024-03-23 18:34:25] [indexer:background] Health check [2024-03-23 18:37:28] [index:background] Health check [2024-03-23 18:37:28] [indexer:background] Health check [2024-03-23 18:37:28] [indexer:background] Health check [2024-03-23 18:44:35] [index:background] Health check [2024-03-23 18:44:35] [indexer:background] Health check [2024-03-23 18:44:35] [indexer:background] Health check [2024-03-23 18:47:39] [index:background] Health check [2024-03-23 18:47:39] [indexer:background] Health check [2024-03-23 18:47:39] [indexer:background] Health check [2024-03-23 18:53:18] [index:background] Health check [2024-03-23 18:53:18] [indexer:background] Health check [2024-03-23 18:53:18] [indexer:background] Health check [2024-03-23 19:02:03] [index:background] Health check [2024-03-23 19:02:03] [indexer:background] Health check [2024-03-23 19:02:03] [indexer:background] Health check [2024-03-23 19:04:23] [indexer:background] Health check [2024-03-23 19:07:05] [index:background] Health check [2024-03-23 19:08:22] [indexer:background] Health check [2024-03-23 19:12:27] [index:background] Health check [2024-03-23 19:12:27] [indexer:background] Health check [2024-03-23 19:12:27] [indexer:background] Health check [2024-03-23 19:18:23] [index:background] Health check [2024-03-23 19:18:23] [indexer:background] Health check [2024-03-23 19:18:23] [indexer:background] Health check [2024-03-23 19:22:21] [index:background] Health check [2024-03-23 19:22:21] [indexer:background] Health check [2024-03-23 19:22:21] [indexer:background] Health check [2024-03-23 19:28:01] [index:background] Health check [2024-03-23 19:28:01] [indexer:background] Health check [2024-03-23 19:28:01] [indexer:background] Health check [2024-03-23 19:32:03] [index:background] Health check [2024-03-23 19:32:39] [indexer:background] Health check [2024-03-23 19:38:10] [index:background] Health check [2024-03-23 19:38:10] [indexer:background] Health check [2024-03-23 19:38:10] [indexer:background] Health check [2024-03-23 19:46:09] [index:background] Health check [2024-03-23 19:46:09] [indexer:background] Health check [2024-03-23 19:46:09] [indexer:background] Health check [2024-03-23 19:48:58] [index:background] Health check [2024-03-23 19:48:58] [indexer:background] Health check [2024-03-23 19:48:58] [indexer:background] Health check [2024-03-23 19:52:09] [index:background] Health check [2024-03-23 19:52:59] [indexer:background] Health check [2024-03-23 20:02:44] [index:background] Health check [2024-03-23 20:02:44] [indexer:background] Health check [2024-03-23 20:02:44] [indexer:background] Health check [2024-03-23 20:07:39] [index:background] Health check [2024-03-23 20:07:39] [indexer:background] Health check [2024-03-23 20:07:39] [indexer:background] Health check [2024-03-23 20:12:15] [index:background] Health check [2024-03-23 20:12:15] [indexer:background] Health check [2024-03-23 20:12:15] [indexer:background] Health check [2024-03-23 20:18:31] [index:background] Health check [2024-03-23 20:18:31] [indexer:background] Health check [2024-03-23 20:18:31] [indexer:background] Health check [2024-03-23 20:22:14] [index:background] Health check [2024-03-23 20:22:14] [indexer:background] Health check [2024-03-23 20:22:14] [indexer:background] Health check [2024-03-23 20:27:08] [index:background] Health check [2024-03-23 20:28:03] [indexer:background] Health check [2024-03-23 20:32:21] [index:background] Health check [2024-03-23 20:32:21] [indexer:background] Health check [2024-03-23 20:32:21] [indexer:background] Health check [2024-03-23 20:37:08] [index:background] Health check [2024-03-23 20:37:18] [indexer:background] Health check [2024-03-23 20:43:36] [index:background] Health check [2024-03-23 20:43:36] [indexer:background] Health check [2024-03-23 20:43:36] [indexer:background] Health check [2024-03-23 20:48:11] [index:background] Health check [2024-03-23 20:48:11] [indexer:background] Health check [2024-03-23 20:48:11] [indexer:background] Health check [2024-03-23 20:52:27] [index:background] Health check [2024-03-23 20:52:27] [indexer:background] Health check [2024-03-23 20:52:27] [indexer:background] Health check [2024-03-23 20:57:09] [index:background] Health check [2024-03-23 20:57:24] [indexer:background] Health check [2024-03-23 21:05:25] [index:background] Health check [2024-03-23 21:05:25] [indexer:background] Health check [2024-03-23 21:05:25] [indexer:background] Health check [2024-03-23 21:09:21] [index:background] Health check [2024-03-23 21:09:21] [indexer:background] Health check [2024-03-23 21:09:21] [indexer:background] Health check [2024-03-23 21:12:20] [index:background] Health check [2024-03-23 21:12:20] [indexer:background] Health check [2024-03-23 21:12:20] [indexer:background] Health check [2024-03-23 21:20:57] [index:background] Health check [2024-03-23 21:20:57] [indexer:background] Health check [2024-03-23 21:20:57] [indexer:background] Health check [2024-03-23 21:23:01] [index:background] Health check [2024-03-23 21:23:01] [indexer:background] Health check [2024-03-23 21:23:01] [indexer:background] Health check [2024-03-23 21:27:07] [index:background] Health check [2024-03-23 21:28:33] [indexer:background] Health check [2024-03-23 21:32:39] [index:background] Health check [2024-03-23 21:32:39] [indexer:background] Health check [2024-03-23 21:32:39] [indexer:background] Health check [2024-03-23 21:38:10] [index:background] Health check [2024-03-23 21:38:10] [indexer:background] Health check [2024-03-23 21:38:10] [indexer:background] Health check [2024-03-23 21:43:05] [index:background] Health check [2024-03-23 21:43:05] [indexer:background] Health check [2024-03-23 21:43:05] [indexer:background] Health check [2024-03-23 21:48:07] [index:background] Health check [2024-03-23 21:48:07] [indexer:background] Health check [2024-03-23 21:48:07] [indexer:background] Health check [2024-03-23 21:53:44] [index:background] Health check [2024-03-23 21:53:44] [indexer:background] Health check [2024-03-23 21:53:44] [indexer:background] Health check [2024-03-23 21:58:20] [index:background] Health check [2024-03-23 21:58:20] [indexer:background] Health check [2024-03-23 21:58:20] [indexer:background] Health check [2024-03-23 22:02:20] [index:background] Health check [2024-03-23 22:02:20] [indexer:background] Health check [2024-03-23 22:02:20] [indexer:background] Health check [2024-03-23 22:07:30] [index:background] Health check [2024-03-23 22:07:30] [indexer:background] Health check [2024-03-23 22:07:30] [indexer:background] Health check [2024-03-23 22:12:25] [index:background] Health check [2024-03-23 22:12:25] [indexer:background] Health check [2024-03-23 22:12:25] [indexer:background] Health check [2024-03-23 22:17:02] [index:background] Health check [2024-03-23 22:17:19] [indexer:background] Health check [2024-03-23 22:17:57] [query] Query for: 2023 [2024-03-23 22:17:57] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all [2024-03-23 22:17:57] [query] Engine: default [2024-03-23 22:17:57] [query] Tokens: 2023 [2024-03-23 22:17:57] [query] Mods: 6 [2024-03-23 22:17:58] [query] Found results using: or logic [2024-03-23 22:17:58] [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-03-23 22:17:58] [query] Results: 267 Pages of results: 27 [2024-03-23 22:17:58] [query] Execution time: 0.39050 [2024-03-23 22:22:13] [index:background] Health check [2024-03-23 22:22:13] [indexer:background] Health check [2024-03-23 22:22:13] [indexer:background] Health check [2024-03-23 22:27:06] [index:background] Health check [2024-03-23 22:28:40] [indexer:background] Health check [2024-03-23 22:32:38] [index:background] Health check [2024-03-23 22:32:38] [indexer:background] Health check [2024-03-23 22:32:38] [indexer:background] Health check [2024-03-23 22:38:27] [index:background] Health check [2024-03-23 22:38:27] [indexer:background] Health check [2024-03-23 22:38:27] [indexer:background] Health check [2024-03-23 22:43:17] [index:background] Health check [2024-03-23 22:43:18] [indexer:background] Health check [2024-03-23 22:43:18] [indexer:background] Health check [2024-03-23 22:47:59] [index:background] Health check [2024-03-23 22:47:59] [indexer:background] Health check [2024-03-23 22:47:59] [indexer:background] Health check [2024-03-23 22:53:24] [index:background] Health check [2024-03-23 22:53:24] [indexer:background] Health check [2024-03-23 22:53:24] [indexer:background] Health check [2024-03-23 22:58:17] [index:background] Health check [2024-03-23 22:58:17] [indexer:background] Health check [2024-03-23 22:58:17] [indexer:background] Health check [2024-03-23 23:02:50] [index:background] Health check [2024-03-23 23:02:50] [indexer:background] Health check [2024-03-23 23:02:50] [indexer:background] Health check [2024-03-23 23:08:16] [index:background] Health check [2024-03-23 23:08:16] [indexer:background] Health check [2024-03-23 23:08:16] [indexer:background] Health check [2024-03-23 23:16:50] [index:background] Health check [2024-03-23 23:16:50] [indexer:background] Health check [2024-03-23 23:16:50] [indexer:background] Health check [2024-03-23 23:19:25] [index:background] Health check [2024-03-23 23:19:25] [indexer:background] Health check [2024-03-23 23:19:25] [indexer:background] Health check [2024-03-23 23:22:35] [index:background] Health check [2024-03-23 23:22:35] [indexer:background] Health check [2024-03-23 23:22:35] [indexer:background] Health check [2024-03-23 23:28:35] [index:background] Health check [2024-03-23 23:28:35] [indexer:background] Health check [2024-03-23 23:28:35] [indexer:background] Health check [2024-03-23 23:32:23] [index:background] Health check [2024-03-23 23:32:23] [indexer:background] Health check [2024-03-23 23:32:23] [indexer:background] Health check [2024-03-23 23:38:54] [index:background] Health check [2024-03-23 23:38:54] [indexer:background] Health check [2024-03-23 23:38:54] [indexer:background] Health check [2024-03-23 23:46:53] [index:background] Health check [2024-03-23 23:46:54] [indexer:background] Health check [2024-03-23 23:46:54] [indexer:background] Health check [2024-03-23 23:47:59] [index:background] Health check [2024-03-23 23:47:59] [indexer:background] Health check [2024-03-23 23:47:59] [indexer:background] Health check [2024-03-23 23:53:43] [index:background] Health check [2024-03-23 23:53:43] [indexer:background] Health check [2024-03-23 23:53:43] [indexer:background] Health check [2024-03-23 23:58:16] [index:background] Health check [2024-03-23 23:58:16] [indexer:background] Health check [2024-03-23 23:58:16] [indexer:background] Health check