[2024-04-22 00:02:38] [index:background] Health check
[2024-04-22 00:05:15] [indexer:background] Health check
[2024-04-22 00:08:04] [index:background] Health check
[2024-04-22 00:09:20] [indexer:background] Health check
[2024-04-22 00:13:27] [index:background] Health check
[2024-04-22 00:14:22] [indexer:background] Health check
[2024-04-22 00:17:35] [index:background] Health check
[2024-04-22 00:20:25] [indexer:background] Health check
[2024-04-22 00:23:10] [index:background] Health check
[2024-04-22 00:24:32] [indexer:background] Health check
[2024-04-22 00:28:36] [index:background] Health check
[2024-04-22 00:30:08] [indexer:background] Health check
[2024-04-22 00:32:44] [index:background] Health check
[2024-04-22 00:34:18] [indexer:background] Health check
[2024-04-22 00:37:36] [index:background] Health check
[2024-04-22 00:39:42] [indexer:background] Health check
[2024-04-22 00:42:38] [index:background] Health check
[2024-04-22 00:44:41] [indexer:background] Health check
[2024-04-22 00:47:38] [index:background] Health check
[2024-04-22 00:50:01] [indexer:background] Health check
[2024-04-22 00:52:54] [index:background] Health check
[2024-04-22 00:54:33] [indexer:background] Health check
[2024-04-22 00:58:02] [index:background] Health check
[2024-04-22 00:59:42] [indexer:background] Health check
[2024-04-22 01:02:58] [index:background] Health check
[2024-04-22 01:04:21] [indexer:background] Health check
[2024-04-22 01:07:48] [index:background] Health check
[2024-04-22 01:09:29] [indexer:background] Health check
[2024-04-22 01:15:01] [index:background] Health check
[2024-04-22 01:15:01] [indexer:background] Health check
[2024-04-22 01:15:01] [indexer:background] Health check
[2024-04-22 01:17:50] [index:background] Health check
[2024-04-22 01:20:03] [indexer:background] Health check
[2024-04-22 01:23:00] [index:background] Health check
[2024-04-22 01:24:32] [indexer:background] Health check
[2024-04-22 01:28:01] [index:background] Health check
[2024-04-22 01:30:40] [indexer:background] Health check
[2024-04-22 01:33:05] [index:background] Health check
[2024-04-22 01:34:50] [indexer:background] Health check
[2024-04-22 01:37:53] [index:background] Health check
[2024-04-22 01:40:42] [indexer:background] Health check
[2024-04-22 01:43:06] [index:background] Health check
[2024-04-22 01:44:28] [indexer:background] Health check
[2024-04-22 01:49:01] [index:background] Health check
[2024-04-22 01:49:22] [query] Query for: {search_term_string}
[2024-04-22 01:49:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 134 offset: 0 fields: all
[2024-04-22 01:49:22] [query] Engine: default
[2024-04-22 01:49:22] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 01:49:22] [query] Mods: 6
[2024-04-22 01:49:22] [query] Using OR logic
[2024-04-22 01:49:22] [indexer:background] Health check
[2024-04-22 01:49:23] [query] Found results using: or logic
[2024-04-22 01:49: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 1330, 10
[2024-04-22 01:49:23] [query] Results: 1361 Pages of results: 137
[2024-04-22 01:49:23] [query] Execution time: 1.13455
[2024-04-22 01:54:37] [index:background] Health check
[2024-04-22 01:54:37] [indexer:background] Health check
[2024-04-22 01:54:37] [indexer:background] Health check
[2024-04-22 01:57:45] [index:background] Health check
[2024-04-22 01:59:58] [indexer:background] Health check
[2024-04-22 02:02:42] [index:background] Health check
[2024-04-22 02:05:56] [indexer:background] Health check
[2024-04-22 02:10:27] [index:background] Health check
[2024-04-22 02:10:27] [indexer:background] Health check
[2024-04-22 02:10:27] [indexer:background] Health check
[2024-04-22 02:13:51] [index:background] Health check
[2024-04-22 02:15:45] [indexer:background] Health check
[2024-04-22 02:18:45] [index:background] Health check
[2024-04-22 02:20:33] [indexer:background] Health check
[2024-04-22 02:23:04] [index:background] Health check
[2024-04-22 02:24:21] [indexer:background] Health check
[2024-04-22 02:28:05] [index:background] Health check
[2024-04-22 02:29:46] [indexer:background] Health check
[2024-04-22 02:32:45] [index:background] Health check
[2024-04-22 02:35:04] [indexer:background] Health check
[2024-04-22 02:37:35] [index:background] Health check
[2024-04-22 02:39:10] [query] Query for: {search_term_string}
[2024-04-22 02:39:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 7 offset: 0 fields: all
[2024-04-22 02:39:10] [query] Engine: default
[2024-04-22 02:39:10] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 02:39:10] [query] Mods: 6
[2024-04-22 02:39:10] [query] Using OR logic
[2024-04-22 02:39:10] [query] Found results using: or logic
[2024-04-22 02:39:10] [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 60, 10
[2024-04-22 02:39:10] [query] Results: 1361 Pages of results: 137
[2024-04-22 02:39:10] [query] Execution time: 0.60383
[2024-04-22 02:39:17] [indexer:background] Health check
[2024-04-22 02:42:34] [index:background] Health check
[2024-04-22 02:45:19] [indexer:background] Health check
[2024-04-22 02:48:09] [index:background] Health check
[2024-04-22 02:49:31] [indexer:background] Health check
[2024-04-22 02:53:36] [index:background] Health check
[2024-04-22 02:57:50] [indexer:background] Health check
[2024-04-22 02:57:51] [index:background] Health check
[2024-04-22 02:59:25] [indexer:background] Health check
[2024-04-22 02:59:43] [query] Query for: 2025
[2024-04-22 02:59:43] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 02:59:43] [query] Engine: default
[2024-04-22 02:59:43] [query] Tokens: 2025
[2024-04-22 02:59:43] [query] Mods: 6
[2024-04-22 02:59:43] [query] Found results using: or logic
[2024-04-22 02:59:43] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 02:59:43] [query] Results: 138 Pages of results: 14
[2024-04-22 02:59:43] [query] Execution time: 0.89479
[2024-04-22 02:59:43] [query] Query for: 2025
[2024-04-22 02:59:43] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-22 02:59:43] [query] Engine: default
[2024-04-22 02:59:43] [query] Tokens: 2025
[2024-04-22 02:59:43] [query] Mods: 6
[2024-04-22 02:59:43] [query] Found results using: or logic
[2024-04-22 02:59: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 (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-04-22 02:59:44] [query] Results: 138 Pages of results: 2
[2024-04-22 02:59:44] [query] Execution time: 0.47533
[2024-04-22 03:03:31] [index:background] Health check
[2024-04-22 03:04:49] [indexer:background] Health check
[2024-04-22 03:09:08] [index:background] Health check
[2024-04-22 03:09:28] [indexer:background] Health check
[2024-04-22 03:12:48] [index:background] Health check
[2024-04-22 03:12:48] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2024-04-22 03:12:50] [indexer:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2024-04-22 03:14:47] [indexer:background] Health check
[2024-04-22 03:17:41] [index:background] Health check
[2024-04-22 03:19:22] [indexer:background] Health check
[2024-04-22 03:23:32] [index:background] Health check
[2024-04-22 03:26:16] [indexer:background] Health check
[2024-04-22 03:27:54] [index:background] Health check
[2024-04-22 03:30:02] [indexer:background] Health check
[2024-04-22 03:34:12] [index:background] Health check
[2024-04-22 03:34:23] [indexer:background] Health check
[2024-04-22 03:38:00] [index:background] Health check
[2024-04-22 03:41:10] [indexer:background] Health check
[2024-04-22 03:42:33] [index:background] Health check
[2024-04-22 03:42:33] [index:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-04-22 03:42:35] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-04-22 03:44:18] [indexer:background] Health check
[2024-04-22 03:49:37] [index:background] Health check
[2024-04-22 03:49:37] [indexer:background] Health check
[2024-04-22 03:49:37] [indexer:background] Health check
[2024-04-22 03:54:10] [index:background] Health check
[2024-04-22 03:54:22] [indexer:background] Health check
[2024-04-22 03:58:36] [index:background] Health check
[2024-04-22 03:59:18] [indexer:background] Health check
[2024-04-22 04:02:50] [index:background] Health check
[2024-04-22 04:04:54] [indexer:background] Health check
[2024-04-22 04:10:10] [index:background] Health check
[2024-04-22 04:10:10] [indexer:background] Health check
[2024-04-22 04:10:10] [indexer:background] Health check
[2024-04-22 04:15:20] [index:background] Health check
[2024-04-22 04:15:23] [indexer:background] Health check
[2024-04-22 04:15:23] [indexer:background] Health check
[2024-04-22 04:18:48] [index:background] Health check
[2024-04-22 04:20:45] [indexer:background] Health check
[2024-04-22 04:24:03] [index:background] Health check
[2024-04-22 04:26:24] [indexer:background] Health check
[2024-04-22 04:28:09] [index:background] Health check
[2024-04-22 04:31:00] [indexer:background] Health check
[2024-04-22 04:32:37] [index:background] Health check
[2024-04-22 04:35:00] [indexer:background] Health check
[2024-04-22 04:40:19] [index:background] Health check
[2024-04-22 04:40:19] [indexer:background] Health check
[2024-04-22 04:40:19] [indexer:background] Health check
[2024-04-22 04:44:23] [index:background] Health check
[2024-04-22 04:44:23] [indexer:background] Health check
[2024-04-22 04:44:23] [indexer:background] Health check
[2024-04-22 04:48:34] [index:background] Health check
[2024-04-22 04:49:18] [indexer:background] Health check
[2024-04-22 04:55:07] [index:background] Health check
[2024-04-22 04:55:07] [indexer:background] Health check
[2024-04-22 04:55:07] [indexer:background] Health check
[2024-04-22 05:01:54] [index:background] Health check
[2024-04-22 05:01:54] [indexer:background] Health check
[2024-04-22 05:01:54] [indexer:background] Health check
[2024-04-22 05:02:43] [index:background] Health check
[2024-04-22 05:04:18] [indexer:background] Health check
[2024-04-22 05:08:41] [index:background] Health check
[2024-04-22 05:10:58] [indexer:background] Health check
[2024-04-22 05:12:34] [index:background] Health check
[2024-04-22 05:14:27] [indexer:background] Health check
[2024-04-22 05:18:47] [index:background] Health check
[2024-04-22 05:20:10] [indexer:background] Health check
[2024-04-22 05:23:09] [index:background] Health check
[2024-04-22 05:24:33] [indexer:background] Health check
[2024-04-22 05:28:29] [index:background] Health check
[2024-04-22 05:28:56] [query] Query for: 2023
[2024-04-22 05:28:56] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 05:28:56] [query] Engine: default
[2024-04-22 05:28:56] [query] Tokens: 2023
[2024-04-22 05:28:56] [query] Mods: 6
[2024-04-22 05:28:56] [query] Found results using: or logic
[2024-04-22 05:28: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 (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 05:28:56] [query] Results: 273 Pages of results: 28
[2024-04-22 05:28:56] [query] Execution time: 0.39891
[2024-04-22 05:29:02] [query] Query for: 2025
[2024-04-22 05:29:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 05:29:02] [query] Engine: default
[2024-04-22 05:29:02] [query] Tokens: 2025
[2024-04-22 05:29:02] [query] Mods: 6
[2024-04-22 05:29:02] [query] Found results using: or logic
[2024-04-22 05:29: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 (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 05:29:02] [query] Results: 138 Pages of results: 14
[2024-04-22 05:29:02] [query] Execution time: 0.02676
[2024-04-22 05:29:09] [query] Query for: 2023
[2024-04-22 05:29:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 05:29:09] [query] Engine: default
[2024-04-22 05:29:09] [query] Tokens: 2023
[2024-04-22 05:29:09] [query] Mods: 6
[2024-04-22 05:29:09] [query] Found results using: or logic
[2024-04-22 05:29:09] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 05:29:09] [query] Results: 273 Pages of results: 28
[2024-04-22 05:29:09] [query] Execution time: 0.02490
[2024-04-22 05:29:09] [query] Query for: 2023
[2024-04-22 05:29:09] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-22 05:29:09] [query] Engine: default
[2024-04-22 05:29:09] [query] Tokens: 2023
[2024-04-22 05:29:09] [query] Mods: 6
[2024-04-22 05:29:09] [query] Found results using: or logic
[2024-04-22 05:29:09] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-04-22 05:29:09] [query] Results: 273 Pages of results: 3
[2024-04-22 05:29:09] [query] Execution time: 0.10479
[2024-04-22 05:30:16] [indexer:background] Health check
[2024-04-22 05:33:11] [index:background] Health check
[2024-04-22 05:34:34] [indexer:background] Health check
[2024-04-22 05:38:50] [index:background] Health check
[2024-04-22 05:40:17] [indexer:background] Health check
[2024-04-22 05:43:06] [index:background] Health check
[2024-04-22 05:44:16] [indexer:background] Health check
[2024-04-22 05:48:46] [index:background] Health check
[2024-04-22 05:50:10] [indexer:background] Health check
[2024-04-22 05:52:59] [index:background] Health check
[2024-04-22 05:54:27] [indexer:background] Health check
[2024-04-22 05:57:34] [index:background] Health check
[2024-04-22 06:00:21] [indexer:background] Health check
[2024-04-22 06:02:57] [index:background] Health check
[2024-04-22 06:04:31] [indexer:background] Health check
[2024-04-22 06:07:41] [index:background] Health check
[2024-04-22 06:10:19] [indexer:background] Health check
[2024-04-22 06:12:55] [index:background] Health check
[2024-04-22 06:14:31] [indexer:background] Health check
[2024-04-22 06:18:13] [index:background] Health check
[2024-04-22 06:20:15] [indexer:background] Health check
[2024-04-22 06:23:31] [index:background] Health check
[2024-04-22 06:24:28] [indexer:background] Health check
[2024-04-22 06:27:48] [index:background] Health check
[2024-04-22 06:30:26] [indexer:background] Health check
[2024-04-22 06:33:02] [index:background] Health check
[2024-04-22 06:35:37] [indexer:background] Health check
[2024-04-22 06:37:52] [index:background] Health check
[2024-04-22 06:39:17] [indexer:background] Health check
[2024-04-22 06:39:49] [query] Query for: {search_term_string}
[2024-04-22 06:39:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 8 offset: 0 fields: all
[2024-04-22 06:39:49] [query] Engine: default
[2024-04-22 06:39:50] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 06:39:50] [query] Mods: 6
[2024-04-22 06:39:50] [query] Using OR logic
[2024-04-22 06:39:50] [query] Found results using: or logic
[2024-04-22 06:39:50] [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 70, 10
[2024-04-22 06:39:50] [query] Results: 1361 Pages of results: 137
[2024-04-22 06:39:50] [query] Execution time: 0.51205
[2024-04-22 06:44:02] [index:background] Health check
[2024-04-22 06:44:41] [indexer:background] Health check
[2024-04-22 06:48:35] [index:background] Health check
[2024-04-22 06:49:27] [indexer:background] Health check
[2024-04-22 06:52:41] [index:background] Health check
[2024-04-22 06:57:15] [indexer:background] Health check
[2024-04-22 06:58:11] [index:background] Health check
[2024-04-22 07:00:37] [indexer:background] Health check
[2024-04-22 07:04:37] [index:background] Health check
[2024-04-22 07:04:37] [indexer:background] Health check
[2024-04-22 07:04:37] [indexer:background] Health check
[2024-04-22 07:08:22] [index:background] Health check
[2024-04-22 07:11:37] [indexer:background] Health check
[2024-04-22 07:14:34] [index:background] Health check
[2024-04-22 07:14:34] [indexer:background] Health check
[2024-04-22 07:14:34] [indexer:background] Health check
[2024-04-22 07:18:57] [index:background] Health check
[2024-04-22 07:21:34] [indexer:background] Health check
[2024-04-22 07:22:52] [index:background] Health check
[2024-04-22 07:24:31] [indexer:background] Health check
[2024-04-22 07:28:41] [index:background] Health check
[2024-04-22 07:29:17] [indexer:background] Health check
[2024-04-22 07:33:03] [index:background] Health check
[2024-04-22 07:34:27] [indexer:background] Health check
[2024-04-22 07:37:38] [index:background] Health check
[2024-04-22 07:39:17] [indexer:background] Health check
[2024-04-22 07:42:37] [index:background] Health check
[2024-04-22 07:44:15] [indexer:background] Health check
[2024-04-22 07:49:13] [index:background] Health check
[2024-04-22 07:49:33] [indexer:background] Health check
[2024-04-22 07:52:46] [index:background] Health check
[2024-04-22 07:54:30] [indexer:background] Health check
[2024-04-22 07:58:25] [index:background] Health check
[2024-04-22 07:59:16] [indexer:background] Health check
[2024-04-22 08:02:37] [index:background] Health check
[2024-04-22 08:04:17] [indexer:background] Health check
[2024-04-22 08:08:12] [index:background] Health check
[2024-04-22 08:09:35] [indexer:background] Health check
[2024-04-22 08:13:28] [index:background] Health check
[2024-04-22 08:15:04] [indexer:background] Health check
[2024-04-22 08:17:33] [index:background] Health check
[2024-04-22 08:19:20] [indexer:background] Health check
[2024-04-22 08:23:05] [index:background] Health check
[2024-04-22 08:24:46] [indexer:background] Health check
[2024-04-22 08:27:42] [index:background] Health check
[2024-04-22 08:29:38] [indexer:background] Health check
[2024-04-22 08:33:23] [index:background] Health check
[2024-04-22 08:34:46] [indexer:background] Health check
[2024-04-22 08:37:36] [index:background] Health check
[2024-04-22 08:40:41] [indexer:background] Health check
[2024-04-22 08:42:36] [index:background] Health check
[2024-04-22 08:44:17] [indexer:background] Health check
[2024-04-22 08:47:54] [index:background] Health check
[2024-04-22 08:49:43] [indexer:background] Health check
[2024-04-22 08:52:39] [index:background] Health check
[2024-04-22 08:55:58] [indexer:background] Health check
[2024-04-22 08:57:36] [index:background] Health check
[2024-04-22 09:02:47] [indexer:background] Health check
[2024-04-22 09:02:47] [index:background] Health check
[2024-04-22 09:04:17] [indexer:background] Health check
[2024-04-22 09:07:47] [index:background] Health check
[2024-04-22 09:10:01] [indexer:background] Health check
[2024-04-22 09:12:54] [index:background] Health check
[2024-04-22 09:14:17] [indexer:background] Health check
[2024-04-22 09:18:42] [index:background] Health check
[2024-04-22 09:21:00] [indexer:background] Health check
[2024-04-22 09:23:59] [index:background] Health check
[2024-04-22 09:25:49] [indexer:background] Health check
[2024-04-22 09:27:36] [index:background] Health check
[2024-04-22 09:29:48] [indexer:background] Health check
[2024-04-22 09:32:46] [index:background] Health check
[2024-04-22 09:34:27] [indexer:background] Health check
[2024-04-22 09:38:03] [index:background] Health check
[2024-04-22 09:39:15] [indexer:background] Health check
[2024-04-22 09:42:36] [index:background] Health check
[2024-04-22 09:44:34] [indexer:background] Health check
[2024-04-22 09:47:45] [index:background] Health check
[2024-04-22 09:50:24] [indexer:background] Health check
[2024-04-22 09:50:39] [query] Query for: 000203/mhc-cab
[2024-04-22 09:50:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 09:50:39] [query] Engine: default
[2024-04-22 09:50:40] [query] Tokens: cabi, 000203, mhc, cab, mhc-cab
[2024-04-22 09:50:40] [query] Mods: 6
[2024-04-22 09:50:40] [query] Trying AND logic
[2024-04-22 09:50:40] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:40] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:40] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:40] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:40] [query] Using OR logic
[2024-04-22 09:50:40] [query] Found results using: and logic
[2024-04-22 09:50: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 (39398,498781,138530,15187,479456) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 09:50:40] [query] Results: 1007 Pages of results: 101
[2024-04-22 09:50:40] [query] Execution time: 1.06955
[2024-04-22 09:50:41] [query] Query for: 000203/mhc-cab
[2024-04-22 09:50:41] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 09:50:41] [query] Engine: default
[2024-04-22 09:50:41] [query] Tokens: cabi, 000203, mhc, cab, mhc-cab
[2024-04-22 09:50:41] [query] Mods: 6
[2024-04-22 09:50:41] [query] Trying AND logic
[2024-04-22 09:50:41] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:41] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:41] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:41] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:50:41] [query] Using OR logic
[2024-04-22 09:50:41] [query] Found results using: and logic
[2024-04-22 09:50:41] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (39398,498781,138530,15187,479456) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 09:50:41] [query] Results: 1007 Pages of results: 101
[2024-04-22 09:50:41] [query] Execution time: 0.27765
[2024-04-22 09:51:10] [query] Query for: loi n° 3/2007
[2024-04-22 09:51:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 09:51:10] [query] Engine: default
[2024-04-22 09:51:10] [query] Tokens: loie, loyer, loia, loya, loyi, loyant, loyis, loii, n°s, loi, n°, 2007
[2024-04-22 09:51:10] [query] Mods: 6
[2024-04-22 09:51:10] [query] Trying AND logic
[2024-04-22 09:51:10] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:51:10] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:51:10] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:51:12] [query] Found results using: and logic
[2024-04-22 09:51:12] [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 (1740,20535,55165,72489,250776,669031,732569,750620,87404,3877,13299,853) 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' ) ) ))) AND s.id IN ( SELECT id FROM ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (853) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (1740, 3877, 20535, 55165, 72489, 250776, 669031, 732569, 750620) GROUP BY id) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (13299, 87404) GROUP BY id) GROUP BY id) AS a) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 09:51:12] [query] Results: 1213 Pages of results: 122
[2024-04-22 09:51:12] [query] Execution time: 1.75372
[2024-04-22 09:51:13] [query] Query for: loi n° 3/2007
[2024-04-22 09:51:13] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 09:51:13] [query] Engine: default
[2024-04-22 09:51:13] [query] Tokens: loie, loyer, loia, loya, loyi, loyant, loyis, loii, n°s, loi, n°, 2007
[2024-04-22 09:51:13] [query] Mods: 6
[2024-04-22 09:51:13] [query] Trying AND logic
[2024-04-22 09:51:13] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:51:13] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:51:13] [query] Skipping AND logic Source Attribute consideration (single Engine)
[2024-04-22 09:51:14] [query] Found results using: and logic
[2024-04-22 09:51: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 (1740,20535,55165,72489,250776,669031,732569,750620,87404,3877,13299,853) 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' ) ) ))) AND s.id IN ( SELECT id FROM ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (853) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (1740, 3877, 20535, 55165, 72489, 250776, 669031, 732569, 750620) GROUP BY id) AND id IN ( SELECT id FROM mod441_searchwp_index s WHERE 1=1 AND 1=1 AND token IN (13299, 87404) GROUP BY id) GROUP BY id) AS a) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 09:51:14] [query] Results: 1213 Pages of results: 122
[2024-04-22 09:51:14] [query] Execution time: 1.19623
[2024-04-22 09:52:35] [index:background] Health check
[2024-04-22 09:55:22] [indexer:background] Health check
[2024-04-22 09:57:57] [index:background] Health check
[2024-04-22 10:00:36] [indexer:background] Health check
[2024-04-22 10:02:39] [index:background] Health check
[2024-04-22 10:04:37] [indexer:background] Health check
[2024-04-22 10:07:37] [index:background] Health check
[2024-04-22 10:10:27] [indexer:background] Health check
[2024-04-22 10:12:45] [index:background] Health check
[2024-04-22 10:14:54] [indexer:background] Health check
[2024-04-22 10:17:36] [index:background] Health check
[2024-04-22 10:19:16] [indexer:background] Health check
[2024-04-22 10:22:35] [index:background] Health check
[2024-04-22 10:24:38] [indexer:background] Health check
[2024-04-22 10:27:43] [index:background] Health check
[2024-04-22 10:29:34] [indexer:background] Health check
[2024-04-22 10:32:33] [index:background] Health check
[2024-04-22 10:34:21] [indexer:background] Health check
[2024-04-22 10:39:19] [index:background] Health check
[2024-04-22 10:39:19] [indexer:background] Health check
[2024-04-22 10:39:19] [indexer:background] Health check
[2024-04-22 10:43:12] [index:background] Health check
[2024-04-22 10:44:25] [indexer:background] Health check
[2024-04-22 10:47:45] [index:background] Health check
[2024-04-22 10:49:35] [indexer:background] Health check
[2024-04-22 10:52:36] [index:background] Health check
[2024-04-22 10:54:33] [indexer:background] Health check
[2024-04-22 10:57:52] [index:background] Health check
[2024-04-22 10:59:32] [indexer:background] Health check
[2024-04-22 11:02:42] [index:background] Health check
[2024-04-22 11:04:35] [indexer:background] Health check
[2024-04-22 11:07:36] [index:background] Health check
[2024-04-22 11:09:18] [indexer:background] Health check
[2024-04-22 11:13:38] [index:background] Health check
[2024-04-22 11:14:34] [indexer:background] Health check
[2024-04-22 11:18:13] [index:background] Health check
[2024-04-22 11:19:39] [indexer:background] Health check
[2024-04-22 11:22:50] [index:background] Health check
[2024-04-22 11:24:33] [indexer:background] Health check
[2024-04-22 11:28:56] [index:background] Health check
[2024-04-22 11:30:21] [indexer:background] Health check
[2024-04-22 11:33:22] [index:background] Health check
[2024-04-22 11:34:52] [indexer:background] Health check
[2024-04-22 11:38:08] [index:background] Health check
[2024-04-22 11:41:46] [indexer:background] Health check
[2024-04-22 11:44:15] [index:background] Health check
[2024-04-22 11:44:15] [indexer:background] Health check
[2024-04-22 11:44:16] [indexer:background] Health check
[2024-04-22 11:49:13] [index:background] Health check
[2024-04-22 11:50:32] [indexer:background] Health check
[2024-04-22 11:52:51] [index:background] Health check
[2024-04-22 11:55:23] [indexer:background] Health check
[2024-04-22 11:57:36] [index:background] Health check
[2024-04-22 12:00:40] [indexer:background] Health check
[2024-04-22 12:04:30] [index:background] Health check
[2024-04-22 12:04:30] [indexer:background] Health check
[2024-04-22 12:04:30] [indexer:background] Health check
[2024-04-22 12:07:40] [index:background] Health check
[2024-04-22 12:09:25] [indexer:background] Health check
[2024-04-22 12:12:54] [index:background] Health check
[2024-04-22 12:18:07] [indexer:background] Health check
[2024-04-22 12:18:08] [index:background] Health check
[2024-04-22 12:21:24] [indexer:background] Health check
[2024-04-22 12:23:12] [index:background] Health check
[2024-04-22 12:24:19] [indexer:background] Health check
[2024-04-22 12:27:35] [index:background] Health check
[2024-04-22 12:29:55] [indexer:background] Health check
[2024-04-22 12:34:20] [index:background] Health check
[2024-04-22 12:34:20] [indexer:background] Health check
[2024-04-22 12:34:20] [indexer:background] Health check
[2024-04-22 12:38:21] [index:background] Health check
[2024-04-22 12:39:15] [indexer:background] Health check
[2024-04-22 12:42:58] [index:background] Health check
[2024-04-22 12:44:27] [indexer:background] Health check
[2024-04-22 12:48:09] [index:background] Health check
[2024-04-22 12:49:22] [indexer:background] Health check
[2024-04-22 12:52:45] [index:background] Health check
[2024-04-22 12:55:02] [indexer:background] Health check
[2024-04-22 12:57:38] [index:background] Health check
[2024-04-22 13:02:20] [indexer:background] Health check
[2024-04-22 13:05:13] [index:background] Health check
[2024-04-22 13:05:13] [indexer:background] Health check
[2024-04-22 13:05:13] [indexer:background] Health check
[2024-04-22 13:07:57] [index:background] Health check
[2024-04-22 13:10:14] [indexer:background] Health check
[2024-04-22 13:13:18] [index:background] Health check
[2024-04-22 13:14:47] [indexer:background] Health check
[2024-04-22 13:17:56] [index:background] Health check
[2024-04-22 13:19:18] [indexer:background] Health check
[2024-04-22 13:23:59] [index:background] Health check
[2024-04-22 13:24:43] [indexer:background] Health check
[2024-04-22 13:28:28] [index:background] Health check
[2024-04-22 13:29:49] [indexer:background] Health check
[2024-04-22 13:32:47] [index:background] Health check
[2024-04-22 13:34:21] [indexer:background] Health check
[2024-04-22 13:37:38] [index:background] Health check
[2024-04-22 13:39:25] [indexer:background] Health check
[2024-04-22 13:45:22] [index:background] Health check
[2024-04-22 13:45:22] [indexer:background] Health check
[2024-04-22 13:45:22] [indexer:background] Health check
[2024-04-22 13:48:15] [index:background] Health check
[2024-04-22 13:49:55] [indexer:background] Health check
[2024-04-22 13:52:44] [index:background] Health check
[2024-04-22 13:54:21] [indexer:background] Health check
[2024-04-22 13:58:46] [index:background] Health check
[2024-04-22 14:00:13] [indexer:background] Health check
[2024-04-22 14:02:59] [index:background] Health check
[2024-04-22 14:05:58] [indexer:background] Health check
[2024-04-22 14:07:54] [index:background] Health check
[2024-04-22 14:10:57] [indexer:background] Health check
[2024-04-22 14:12:38] [index:background] Health check
[2024-04-22 14:14:34] [indexer:background] Health check
[2024-04-22 14:18:17] [index:background] Health check
[2024-04-22 14:19:18] [indexer:background] Health check
[2024-04-22 14:23:13] [index:background] Health check
[2024-04-22 14:25:31] [indexer:background] Health check
[2024-04-22 14:27:38] [index:background] Health check
[2024-04-22 14:29:31] [indexer:background] Health check
[2024-04-22 14:33:19] [index:background] Health check
[2024-04-22 14:34:46] [indexer:background] Health check
[2024-04-22 14:37:55] [index:background] Health check
[2024-04-22 14:39:19] [indexer:background] Health check
[2024-04-22 14:43:07] [index:background] Health check
[2024-04-22 14:44:33] [indexer:background] Health check
[2024-04-22 14:49:31] [index:background] Health check
[2024-04-22 14:49:34] [indexer:background] Health check
[2024-04-22 14:49:34] [indexer:background] Health check
[2024-04-22 14:54:55] [index:background] Health check
[2024-04-22 14:54:56] [indexer:background] Health check
[2024-04-22 14:54:56] [indexer:background] Health check
[2024-04-22 14:58:04] [index:background] Health check
[2024-04-22 14:59:20] [indexer:background] Health check
[2024-04-22 15:02:35] [index:background] Health check
[2024-04-22 15:07:30] [indexer:background] Health check
[2024-04-22 15:07:34] [index:background] Health check
[2024-04-22 15:09:20] [indexer:background] Health check
[2024-04-22 15:12:34] [index:background] Health check
[2024-04-22 15:14:27] [indexer:background] Health check
[2024-04-22 15:17:37] [index:background] Health check
[2024-04-22 15:19:21] [indexer:background] Health check
[2024-04-22 15:22:46] [index:background] Health check
[2024-04-22 15:24:51] [indexer:background] Health check
[2024-04-22 15:28:08] [index:background] Health check
[2024-04-22 15:31:32] [indexer:background] Health check
[2024-04-22 15:33:17] [index:background] Health check
[2024-04-22 15:35:08] [indexer:background] Health check
[2024-04-22 15:37:58] [index:background] Health check
[2024-04-22 15:40:27] [indexer:background] Health check
[2024-04-22 15:42:38] [index:background] Health check
[2024-04-22 15:45:54] [indexer:background] Health check
[2024-04-22 15:48:01] [index:background] Health check
[2024-04-22 15:52:14] [indexer:background] Health check
[2024-04-22 15:52:47] [index:background] Health check
[2024-04-22 15:55:53] [indexer:background] Health check
[2024-04-22 15:57:42] [index:background] Health check
[2024-04-22 15:59:26] [indexer:background] Health check
[2024-04-22 16:03:20] [index:background] Health check
[2024-04-22 16:07:15] [indexer:background] Health check
[2024-04-22 16:07:48] [index:background] Health check
[2024-04-22 16:10:35] [indexer:background] Health check
[2024-04-22 16:13:48] [index:background] Health check
[2024-04-22 16:13:48] [index:background] CPU load threshold (3) breached: 7.67 [waiting 2]
[2024-04-22 16:13:50] [indexer:background] CPU load threshold (3) breached: 7.67 [waiting 2]
[2024-04-22 16:14:37] [indexer:background] Health check
[2024-04-22 16:14:37] [indexer:background] CPU load threshold (3) breached: 12.04 [waiting 2]
[2024-04-22 16:20:23] [index:background] Health check
[2024-04-22 16:20:23] [indexer:background] Health check
[2024-04-22 16:20:23] [indexer:background] Health check
[2024-04-22 16:23:49] [index:background] Health check
[2024-04-22 16:25:20] [indexer:background] Health check
[2024-04-22 16:28:22] [index:background] Health check
[2024-04-22 16:29:38] [indexer:background] Health check
[2024-04-22 16:32:45] [index:background] Health check
[2024-04-22 16:34:31] [indexer:background] Health check
[2024-04-22 16:38:31] [index:background] Health check
[2024-04-22 16:39:17] [indexer:background] Health check
[2024-04-22 16:42:38] [index:background] Health check
[2024-04-22 16:44:19] [indexer:background] Health check
[2024-04-22 16:47:52] [index:background] Health check
[2024-04-22 16:50:08] [indexer:background] Health check
[2024-04-22 16:52:44] [index:background] Health check
[2024-04-22 16:54:28] [indexer:background] Health check
[2024-04-22 16:54:34] [query] Query for: {search_term_string}
[2024-04-22 16:54:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 16:54:34] [query] Engine: default
[2024-04-22 16:54:34] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 16:54:34] [query] Mods: 6
[2024-04-22 16:54:34] [query] Using OR logic
[2024-04-22 16:54:35] [query] Found results using: or logic
[2024-04-22 16:54:35] [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-04-22 16:54:35] [query] Results: 1361 Pages of results: 137
[2024-04-22 16:54:35] [query] Execution time: 0.65078
[2024-04-22 16:58:28] [index:background] Health check
[2024-04-22 17:00:18] [indexer:background] Health check
[2024-04-22 17:03:14] [index:background] Health check
[2024-04-22 17:04:40] [indexer:background] Health check
[2024-04-22 17:07:47] [index:background] Health check
[2024-04-22 17:10:30] [indexer:background] Health check
[2024-04-22 17:13:22] [index:background] Health check
[2024-04-22 17:14:34] [indexer:background] Health check
[2024-04-22 17:16:05] [query] Query for: {search_term_string}
[2024-04-22 17:16:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 17:16:05] [query] Engine: default
[2024-04-22 17:16:05] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 17:16:05] [query] Mods: 6
[2024-04-22 17:16:05] [query] Using OR logic
[2024-04-22 17:16:06] [query] Found results using: or logic
[2024-04-22 17:16:06] [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-04-22 17:16:06] [query] Results: 1361 Pages of results: 137
[2024-04-22 17:16:06] [query] Execution time: 0.34353
[2024-04-22 17:18:38] [index:background] Health check
[2024-04-22 17:19:51] [indexer:background] Health check
[2024-04-22 17:22:45] [index:background] Health check
[2024-04-22 17:25:41] [indexer:background] Health check
[2024-04-22 17:27:35] [index:background] Health check
[2024-04-22 17:29:18] [indexer:background] Health check
[2024-04-22 17:32:35] [index:background] Health check
[2024-04-22 17:34:19] [indexer:background] Health check
[2024-04-22 17:37:35] [index:background] Health check
[2024-04-22 17:39:18] [indexer:background] Health check
[2024-04-22 17:42:35] [index:background] Health check
[2024-04-22 17:44:17] [indexer:background] Health check
[2024-04-22 17:47:35] [index:background] Health check
[2024-04-22 17:49:17] [indexer:background] Health check
[2024-04-22 17:52:35] [index:background] Health check
[2024-04-22 17:54:18] [indexer:background] Health check
[2024-04-22 17:57:35] [index:background] Health check
[2024-04-22 17:59:17] [indexer:background] Health check
[2024-04-22 18:02:36] [index:background] Health check
[2024-04-22 18:04:17] [indexer:background] Health check
[2024-04-22 18:07:34] [index:background] Health check
[2024-04-22 18:09:17] [indexer:background] Health check
[2024-04-22 18:12:34] [index:background] Health check
[2024-04-22 18:14:17] [indexer:background] Health check
[2024-04-22 18:17:35] [index:background] Health check
[2024-04-22 18:19:18] [indexer:background] Health check
[2024-04-22 18:22:35] [index:background] Health check
[2024-04-22 18:24:15] [indexer:background] Health check
[2024-04-22 18:28:12] [index:background] Health check
[2024-04-22 18:29:59] [indexer:background] Health check
[2024-04-22 18:35:01] [index:background] Health check
[2024-04-22 18:35:01] [indexer:background] Health check
[2024-04-22 18:35:01] [indexer:background] Health check
[2024-04-22 18:39:24] [index:background] Health check
[2024-04-22 18:39:24] [indexer:background] Health check
[2024-04-22 18:39:24] [indexer:background] Health check
[2024-04-22 18:42:58] [index:background] Health check
[2024-04-22 18:44:15] [indexer:background] Health check
[2024-04-22 18:48:32] [index:background] Health check
[2024-04-22 18:50:04] [indexer:background] Health check
[2024-04-22 18:51:22] [query] Query for: 2023
[2024-04-22 18:51:22] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 18:51:22] [query] Engine: default
[2024-04-22 18:51:22] [query] Tokens: 2023
[2024-04-22 18:51:22] [query] Mods: 6
[2024-04-22 18:51:22] [query] Found results using: or logic
[2024-04-22 18:51: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 (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 18:51:22] [query] Results: 273 Pages of results: 28
[2024-04-22 18:51:22] [query] Execution time: 0.38734
[2024-04-22 18:53:51] [index:background] Health check
[2024-04-22 18:54:20] [indexer:background] Health check
[2024-04-22 18:58:26] [index:background] Health check
[2024-04-22 18:59:21] [indexer:background] Health check
[2024-04-22 19:02:52] [index:background] Health check
[2024-04-22 19:03:35] [query] Query for: search_term_string
[2024-04-22 19:03:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 19:03:35] [query] Engine: default
[2024-04-22 19:03:35] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 19:03:35] [query] Mods: 6
[2024-04-22 19:03:35] [query] Using OR logic
[2024-04-22 19:03:36] [query] Found results using: or logic
[2024-04-22 19:03:36] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-04-22 19:03:36] [query] Results: 1361 Pages of results: 137
[2024-04-22 19:03:36] [query] Execution time: 0.72408
[2024-04-22 19:04:28] [indexer:background] Health check
[2024-04-22 19:07:53] [index:background] Health check
[2024-04-22 19:09:31] [indexer:background] Health check
[2024-04-22 19:13:27] [index:background] Health check
[2024-04-22 19:14:21] [indexer:background] Health check
[2024-04-22 19:17:44] [index:background] Health check
[2024-04-22 19:19:34] [indexer:background] Health check
[2024-04-22 19:23:21] [index:background] Health check
[2024-04-22 19:24:30] [indexer:background] Health check
[2024-04-22 19:25:03] [query] Query for: search_term_string
[2024-04-22 19:25:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 19:25:03] [query] Engine: default
[2024-04-22 19:25:03] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-22 19:25:03] [query] Mods: 6
[2024-04-22 19:25:03] [query] Using OR logic
[2024-04-22 19:25:04] [query] Found results using: or logic
[2024-04-22 19:25: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 (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-04-22 19:25:04] [query] Results: 1361 Pages of results: 137
[2024-04-22 19:25:04] [query] Execution time: 0.74571
[2024-04-22 19:29:09] [index:background] Health check
[2024-04-22 19:29:35] [indexer:background] Health check
[2024-04-22 19:33:10] [index:background] Health check
[2024-04-22 19:34:35] [indexer:background] Health check
[2024-04-22 19:37:41] [index:background] Health check
[2024-04-22 19:40:13] [indexer:background] Health check
[2024-04-22 19:42:36] [index:background] Health check
[2024-04-22 19:44:18] [indexer:background] Health check
[2024-04-22 19:48:14] [index:background] Health check
[2024-04-22 19:49:57] [indexer:background] Health check
[2024-04-22 19:52:46] [index:background] Health check
[2024-04-22 19:55:33] [indexer:background] Health check
[2024-04-22 19:58:16] [index:background] Health check
[2024-04-22 19:59:46] [indexer:background] Health check
[2024-04-22 20:00:38] [query] Query for: 2023
[2024-04-22 20:00:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 20:00:38] [query] Engine: default
[2024-04-22 20:00:38] [query] Tokens: 2023
[2024-04-22 20:00:38] [query] Mods: 6
[2024-04-22 20:00:38] [query] Found results using: or logic
[2024-04-22 20:00:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 20:00:38] [query] Results: 273 Pages of results: 28
[2024-04-22 20:00:38] [query] Execution time: 0.31869
[2024-04-22 20:02:34] [index:background] Health check
[2024-04-22 20:04:26] [indexer:background] Health check
[2024-04-22 20:07:36] [index:background] Health check
[2024-04-22 20:08:28] [query] Query for: 2025
[2024-04-22 20:08:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-22 20:08:29] [query] Engine: default
[2024-04-22 20:08:29] [query] Tokens: 2025
[2024-04-22 20:08:29] [query] Mods: 6
[2024-04-22 20:08:29] [query] Found results using: or logic
[2024-04-22 20:08:29] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-22 20:08:29] [query] Results: 138 Pages of results: 14
[2024-04-22 20:08:29] [query] Execution time: 0.20318
[2024-04-22 20:08:29] [query] Query for: 2025
[2024-04-22 20:08:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-22 20:08:29] [query] Engine: default
[2024-04-22 20:08:29] [query] Tokens: 2025
[2024-04-22 20:08:29] [query] Mods: 6
[2024-04-22 20:08:29] [query] Found results using: or logic
[2024-04-22 20:08:29] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-04-22 20:08:29] [query] Results: 138 Pages of results: 2
[2024-04-22 20:08:29] [query] Execution time: 0.13372
[2024-04-22 20:09:23] [indexer:background] Health check
[2024-04-22 20:12:36] [index:background] Health check
[2024-04-22 20:14:17] [indexer:background] Health check
[2024-04-22 20:17:36] [index:background] Health check
[2024-04-22 20:19:20] [indexer:background] Health check
[2024-04-22 20:22:37] [index:background] Health check
[2024-04-22 20:24:24] [indexer:background] Health check
[2024-04-22 20:27:44] [index:background] Health check
[2024-04-22 20:29:21] [indexer:background] Health check
[2024-04-22 20:32:43] [index:background] Health check
[2024-04-22 20:34:23] [indexer:background] Health check
[2024-04-22 20:37:36] [index:background] Health check
[2024-04-22 20:39:22] [indexer:background] Health check
[2024-04-22 20:42:46] [index:background] Health check
[2024-04-22 20:44:19] [indexer:background] Health check
[2024-04-22 20:47:36] [index:background] Health check
[2024-04-22 20:49:18] [indexer:background] Health check
[2024-04-22 20:52:36] [index:background] Health check
[2024-04-22 20:54:28] [indexer:background] Health check
[2024-04-22 20:57:38] [index:background] Health check
[2024-04-22 20:59:17] [indexer:background] Health check
[2024-04-22 21:02:34] [index:background] Health check
[2024-04-22 21:04:21] [indexer:background] Health check
[2024-04-22 21:07:38] [index:background] Health check
[2024-04-22 21:09:35] [indexer:background] Health check
[2024-04-22 21:12:38] [index:background] Health check
[2024-04-22 21:14:20] [indexer:background] Health check
[2024-04-22 21:17:44] [index:background] Health check
[2024-04-22 21:19:16] [indexer:background] Health check
[2024-04-22 21:22:40] [index:background] Health check
[2024-04-22 21:24:23] [indexer:background] Health check
[2024-04-22 21:27:45] [index:background] Health check
[2024-04-22 21:29:20] [indexer:background] Health check
[2024-04-22 21:32:36] [index:background] Health check
[2024-04-22 21:34:16] [indexer:background] Health check
[2024-04-22 21:37:34] [index:background] Health check
[2024-04-22 21:39:19] [indexer:background] Health check
[2024-04-22 21:42:45] [index:background] Health check
[2024-04-22 21:44:17] [indexer:background] Health check
[2024-04-22 21:47:36] [index:background] Health check
[2024-04-22 21:49:17] [indexer:background] Health check
[2024-04-22 21:52:38] [index:background] Health check
[2024-04-22 21:54:18] [indexer:background] Health check
[2024-04-22 21:57:34] [index:background] Health check
[2024-04-22 21:59:16] [indexer:background] Health check
[2024-04-22 22:02:41] [index:background] Health check
[2024-04-22 22:04:19] [indexer:background] Health check
[2024-04-22 22:07:35] [index:background] Health check
[2024-04-22 22:09:17] [indexer:background] Health check
[2024-04-22 22:12:35] [index:background] Health check
[2024-04-22 22:14:20] [indexer:background] Health check
[2024-04-22 22:17:35] [index:background] Health check
[2024-04-22 22:19:18] [indexer:background] Health check
[2024-04-22 22:22:37] [index:background] Health check
[2024-04-22 22:24:23] [indexer:background] Health check
[2024-04-22 22:27:39] [index:background] Health check
[2024-04-22 22:29:17] [indexer:background] Health check
[2024-04-22 22:32:42] [index:background] Health check
[2024-04-22 22:34:24] [indexer:background] Health check
[2024-04-22 22:37:39] [index:background] Health check
[2024-04-22 22:39:17] [indexer:background] Health check
[2024-04-22 22:42:38] [index:background] Health check
[2024-04-22 22:44:20] [indexer:background] Health check
[2024-04-22 22:47:36] [index:background] Health check
[2024-04-22 22:49:25] [indexer:background] Health check
[2024-04-22 22:52:38] [index:background] Health check
[2024-04-22 22:54:22] [indexer:background] Health check
[2024-04-22 22:57:38] [index:background] Health check
[2024-04-22 22:59:28] [indexer:background] Health check
[2024-04-22 23:02:37] [index:background] Health check
[2024-04-22 23:04:20] [indexer:background] Health check
[2024-04-22 23:07:36] [index:background] Health check
[2024-04-22 23:09:58] [indexer:background] Health check
[2024-04-22 23:12:41] [index:background] Health check
[2024-04-22 23:14:19] [indexer:background] Health check
[2024-04-22 23:17:40] [index:background] Health check
[2024-04-22 23:19:23] [indexer:background] Health check
[2024-04-22 23:22:39] [index:background] Health check
[2024-04-22 23:24:18] [indexer:background] Health check
[2024-04-22 23:27:43] [index:background] Health check
[2024-04-22 23:29:17] [indexer:background] Health check
[2024-04-22 23:32:38] [index:background] Health check
[2024-04-22 23:34:16] [indexer:background] Health check
[2024-04-22 23:37:39] [index:background] Health check
[2024-04-22 23:39:17] [indexer:background] Health check
[2024-04-22 23:42:39] [index:background] Health check
[2024-04-22 23:44:20] [indexer:background] Health check
[2024-04-22 23:47:35] [index:background] Health check
[2024-04-22 23:49:22] [indexer:background] Health check
[2024-04-22 23:52:35] [index:background] Health check
[2024-04-22 23:54:21] [indexer:background] Health check
[2024-04-22 23:57:37] [index:background] Health check
[2024-04-22 23:59:16] [indexer:background] Health check