[2024-04-18 00:02:55] [index:background] Health check
[2024-04-18 00:04:18] [indexer:background] Health check
[2024-04-18 00:09:44] [index:background] Health check
[2024-04-18 00:09:47] [indexer:background] Health check
[2024-04-18 00:09:47] [indexer:background] Health check
[2024-04-18 00:13:26] [index:background] Health check
[2024-04-18 00:14:19] [indexer:background] Health check
[2024-04-18 00:17:51] [index:background] Health check
[2024-04-18 00:20:14] [indexer:background] Health check
[2024-04-18 00:23:35] [index:background] Health check
[2024-04-18 00:25:18] [indexer:background] Health check
[2024-04-18 00:28:08] [index:background] Health check
[2024-04-18 00:29:49] [indexer:background] Health check
[2024-04-18 00:32:35] [index:background] Health check
[2024-04-18 00:35:06] [indexer:background] Health check
[2024-04-18 00:37:52] [index:background] Health check
[2024-04-18 00:40:38] [indexer:background] Health check
[2024-04-18 00:43:48] [index:background] Health check
[2024-04-18 00:44:55] [indexer:background] Health check
[2024-04-18 00:48:51] [index:background] Health check
[2024-04-18 00:49:34] [indexer:background] Health check
[2024-04-18 00:53:04] [index:background] Health check
[2024-04-18 00:56:10] [indexer:background] Health check
[2024-04-18 00:58:03] [index:background] Health check
[2024-04-18 01:02:41] [indexer:background] Health check
[2024-04-18 01:02:41] [index:background] Health check
[2024-04-18 01:04:27] [indexer:background] Health check
[2024-04-18 01:08:07] [index:background] Health check
[2024-04-18 01:10:28] [indexer:background] Health check
[2024-04-18 01:13:18] [index:background] Health check
[2024-04-18 01:14:47] [indexer:background] Health check
[2024-04-18 01:18:07] [index:background] Health check
[2024-04-18 01:20:19] [indexer:background] Health check
[2024-04-18 01:23:55] [index:background] Health check
[2024-04-18 01:25:38] [indexer:background] Health check
[2024-04-18 01:28:25] [index:background] Health check
[2024-04-18 01:30:22] [indexer:background] Health check
[2024-04-18 01:32:34] [index:background] Health check
[2024-04-18 01:34:16] [indexer:background] Health check
[2024-04-18 01:37:35] [index:background] Health check
[2024-04-18 01:39:25] [indexer:background] Health check
[2024-04-18 01:40:57] [query] Query for: 2025
[2024-04-18 01:40:57] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 01:40:57] [query] Engine: default
[2024-04-18 01:40:57] [query] Tokens: 2025
[2024-04-18 01:40:57] [query] Mods: 6
[2024-04-18 01:40:57] [query] Found results using: or logic
[2024-04-18 01:40:57] [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-18 01:40:57] [query] Results: 138 Pages of results: 14
[2024-04-18 01:40:57] [query] Execution time: 0.52595
[2024-04-18 01:42:46] [index:background] Health check
[2024-04-18 01:44:51] [indexer:background] Health check
[2024-04-18 01:47:58] [index:background] Health check
[2024-04-18 01:50:01] [indexer:background] Health check
[2024-04-18 01:52:36] [index:background] Health check
[2024-04-18 01:54:18] [indexer:background] Health check
[2024-04-18 01:59:00] [index:background] Health check
[2024-04-18 01:59:27] [indexer:background] Health check
[2024-04-18 02:02:39] [index:background] Health check
[2024-04-18 02:04:22] [indexer:background] Health check
[2024-04-18 02:08:11] [index:background] Health check
[2024-04-18 02:09:23] [indexer:background] Health check
[2024-04-18 02:12:52] [index:background] Health check
[2024-04-18 02:14:15] [indexer:background] Health check
[2024-04-18 02:18:07] [index:background] Health check
[2024-04-18 02:19:41] [indexer:background] Health check
[2024-04-18 02:22:43] [index:background] Health check
[2024-04-18 02:24:19] [indexer:background] Health check
[2024-04-18 02:28:13] [index:background] Health check
[2024-04-18 02:29:40] [indexer:background] Health check
[2024-04-18 02:32:52] [index:background] Health check
[2024-04-18 02:34:23] [indexer:background] Health check
[2024-04-18 02:38:17] [index:background] Health check
[2024-04-18 02:39:21] [indexer:background] Health check
[2024-04-18 02:43:00] [index:background] Health check
[2024-04-18 02:44:32] [indexer:background] Health check
[2024-04-18 02:47:39] [index:background] Health check
[2024-04-18 02:49:21] [indexer:background] Health check
[2024-04-18 02:52:36] [index:background] Health check
[2024-04-18 02:54:39] [indexer:background] Health check
[2024-04-18 02:57:53] [index:background] Health check
[2024-04-18 02:59:25] [indexer:background] Health check
[2024-04-18 03:02:48] [index:background] Health check
[2024-04-18 03:04:41] [indexer:background] Health check
[2024-04-18 03:07:50] [index:background] Health check
[2024-04-18 03:09:54] [indexer:background] Health check
[2024-04-18 03:15:06] [index:background] Health check
[2024-04-18 03:15:09] [indexer:background] Health check
[2024-04-18 03:15:09] [indexer:background] Health check
[2024-04-18 03:17:52] [index:background] Health check
[2024-04-18 03:19:35] [indexer:background] Health check
[2024-04-18 03:22:36] [index:background] Health check
[2024-04-18 03:24:17] [indexer:background] Health check
[2024-04-18 03:27:34] [index:background] Health check
[2024-04-18 03:27:34] [index:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2024-04-18 03:27:36] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2]
[2024-04-18 03:29:16] [indexer:background] Health check
[2024-04-18 03:32:35] [index:background] Health check
[2024-04-18 03:34:17] [indexer:background] Health check
[2024-04-18 03:37:37] [index:background] Health check
[2024-04-18 03:39:18] [indexer:background] Health check
[2024-04-18 03:42:35] [index:background] Health check
[2024-04-18 03:44:19] [indexer:background] Health check
[2024-04-18 03:47:36] [index:background] Health check
[2024-04-18 03:47:36] [index:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2024-04-18 03:47:38] [indexer:background] CPU load threshold (3) breached: 3.48 [waiting 2]
[2024-04-18 03:49:17] [indexer:background] Health check
[2024-04-18 03:49:17] [indexer:background] CPU load threshold (3) breached: 3.71 [waiting 2]
[2024-04-18 03:52:34] [index:background] Health check
[2024-04-18 03:54:16] [indexer:background] Health check
[2024-04-18 03:57:35] [index:background] Health check
[2024-04-18 03:57:35] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-04-18 03:59:18] [indexer:background] Health check
[2024-04-18 04:02:39] [index:background] Health check
[2024-04-18 04:02:39] [index:background] CPU load threshold (3) breached: 4.13 [waiting 2]
[2024-04-18 04:02:41] [indexer:background] CPU load threshold (3) breached: 4.13 [waiting 2]
[2024-04-18 04:05:53] [indexer:background] Health check
[2024-04-18 04:09:10] [index:background] Health check
[2024-04-18 04:10:12] [indexer:background] Health check
[2024-04-18 04:13:04] [index:background] Health check
[2024-04-18 04:14:38] [indexer:background] Health check
[2024-04-18 04:17:44] [index:background] Health check
[2024-04-18 04:19:34] [indexer:background] Health check
[2024-04-18 04:22:41] [index:background] Health check
[2024-04-18 04:24:51] [indexer:background] Health check
[2024-04-18 04:29:33] [index:background] Health check
[2024-04-18 04:29:33] [indexer:background] Health check
[2024-04-18 04:29:33] [indexer:background] Health check
[2024-04-18 04:33:21] [index:background] Health check
[2024-04-18 04:34:25] [indexer:background] Health check
[2024-04-18 04:37:44] [index:background] Health check
[2024-04-18 04:38:48] [query] Query for: search_term_string
[2024-04-18 04:38:48] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 136 offset: 0 fields: all
[2024-04-18 04:38:48] [query] Engine: default
[2024-04-18 04:38:49] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-18 04:38:49] [query] Mods: 6
[2024-04-18 04:38:49] [query] Using OR logic
[2024-04-18 04:38:50] [query] Found results using: or logic
[2024-04-18 04:38: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 1350, 10
[2024-04-18 04:38:50] [query] Results: 1361 Pages of results: 137
[2024-04-18 04:38:50] [query] Execution time: 1.74003
[2024-04-18 04:38:54] [query] Query for: search_term_string
[2024-04-18 04:38:54] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 135 offset: 0 fields: all
[2024-04-18 04:38:54] [query] Engine: default
[2024-04-18 04:38:54] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-18 04:38:54] [query] Mods: 6
[2024-04-18 04:38:54] [query] Using OR logic
[2024-04-18 04:38:55] [query] Found results using: or logic
[2024-04-18 04:38:55] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 1340, 10
[2024-04-18 04:38:55] [query] Results: 1361 Pages of results: 137
[2024-04-18 04:38:55] [query] Execution time: 0.32135
[2024-04-18 04:40:23] [indexer:background] Health check
[2024-04-18 04:44:54] [index:background] Health check
[2024-04-18 04:44:56] [indexer:background] Health check
[2024-04-18 04:44:56] [indexer:background] Health check
[2024-04-18 04:48:00] [index:background] Health check
[2024-04-18 04:49:34] [indexer:background] Health check
[2024-04-18 04:52:52] [index:background] Health check
[2024-04-18 04:54:22] [indexer:background] Health check
[2024-04-18 04:57:35] [index:background] Health check
[2024-04-18 04:59:38] [indexer:background] Health check
[2024-04-18 05:03:12] [index:background] Health check
[2024-04-18 05:04:43] [indexer:background] Health check
[2024-04-18 05:09:08] [index:background] Health check
[2024-04-18 05:10:24] [indexer:background] Health check
[2024-04-18 05:13:12] [index:background] Health check
[2024-04-18 05:14:51] [indexer:background] Health check
[2024-04-18 05:17:39] [index:background] Health check
[2024-04-18 05:20:01] [indexer:background] Health check
[2024-04-18 05:22:43] [index:background] Health check
[2024-04-18 05:24:46] [indexer:background] Health check
[2024-04-18 05:27:45] [index:background] Health check
[2024-04-18 05:29:41] [indexer:background] Health check
[2024-04-18 05:32:38] [index:background] Health check
[2024-04-18 05:34:16] [indexer:background] Health check
[2024-04-18 05:37:53] [index:background] Health check
[2024-04-18 05:39:17] [indexer:background] Health check
[2024-04-18 05:42:36] [index:background] Health check
[2024-04-18 05:44:19] [indexer:background] Health check
[2024-04-18 05:47:47] [index:background] Health check
[2024-04-18 05:49:25] [indexer:background] Health check
[2024-04-18 05:52:36] [index:background] Health check
[2024-04-18 05:54:40] [indexer:background] Health check
[2024-04-18 05:57:37] [index:background] Health check
[2024-04-18 05:59:15] [indexer:background] Health check
[2024-04-18 06:02:43] [index:background] Health check
[2024-04-18 06:02:43] [index:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2024-04-18 06:02:45] [indexer:background] CPU load threshold (3) breached: 3.3 [waiting 2]
[2024-04-18 06:04:34] [indexer:background] Health check
[2024-04-18 06:08:05] [index:background] Health check
[2024-04-18 06:11:09] [indexer:background] Health check
[2024-04-18 06:13:48] [index:background] Health check
[2024-04-18 06:14:16] [indexer:background] Health check
[2024-04-18 06:17:44] [index:background] Health check
[2024-04-18 06:19:18] [indexer:background] Health check
[2024-04-18 06:22:51] [index:background] Health check
[2024-04-18 06:24:29] [indexer:background] Health check
[2024-04-18 06:27:38] [index:background] Health check
[2024-04-18 06:29:17] [indexer:background] Health check
[2024-04-18 06:32:44] [index:background] Health check
[2024-04-18 06:34:19] [indexer:background] Health check
[2024-04-18 06:37:36] [index:background] Health check
[2024-04-18 06:39:16] [indexer:background] Health check
[2024-04-18 06:42:38] [index:background] Health check
[2024-04-18 06:44:25] [indexer:background] Health check
[2024-04-18 06:47:34] [index:background] Health check
[2024-04-18 06:49:23] [indexer:background] Health check
[2024-04-18 06:52:47] [index:background] Health check
[2024-04-18 06:54:17] [indexer:background] Health check
[2024-04-18 06:57:35] [index:background] Health check
[2024-04-18 06:59:17] [indexer:background] Health check
[2024-04-18 07:02:36] [index:background] Health check
[2024-04-18 07:02:36] [index:background] CPU load threshold (3) breached: 4.64 [waiting 2]
[2024-04-18 07:02:38] [indexer:background] CPU load threshold (3) breached: 4.64 [waiting 2]
[2024-04-18 07:04:15] [indexer:background] Health check
[2024-04-18 07:07:35] [index:background] Health check
[2024-04-18 07:09:16] [indexer:background] Health check
[2024-04-18 07:12:58] [index:background] Health check
[2024-04-18 07:14:19] [indexer:background] Health check
[2024-04-18 07:17:46] [index:background] Health check
[2024-04-18 07:19:15] [indexer:background] Health check
[2024-04-18 07:22:38] [index:background] Health check
[2024-04-18 07:24:21] [indexer:background] Health check
[2024-04-18 07:27:45] [index:background] Health check
[2024-04-18 07:30:15] [indexer:background] Health check
[2024-04-18 07:33:26] [index:background] Health check
[2024-04-18 07:34:34] [indexer:background] Health check
[2024-04-18 07:37:54] [index:background] Health check
[2024-04-18 07:38:58] [query] Query for: search_term_string
[2024-04-18 07:38:58] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 7 offset: 0 fields: all
[2024-04-18 07:38:58] [query] Engine: default
[2024-04-18 07:38:58] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-04-18 07:38:58] [query] Mods: 6
[2024-04-18 07:38:58] [query] Using OR logic
[2024-04-18 07:38:59] [query] Found results using: or logic
[2024-04-18 07:38:59] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-18 07:38:59] [query] Results: 1361 Pages of results: 137
[2024-04-18 07:38:59] [query] Execution time: 0.89944
[2024-04-18 07:40:05] [indexer:background] Health check
[2024-04-18 07:42:50] [index:background] Health check
[2024-04-18 07:44:19] [indexer:background] Health check
[2024-04-18 07:48:25] [index:background] Health check
[2024-04-18 07:49:49] [indexer:background] Health check
[2024-04-18 07:53:26] [index:background] Health check
[2024-04-18 07:54:52] [indexer:background] Health check
[2024-04-18 07:57:47] [index:background] Health check
[2024-04-18 07:59:34] [indexer:background] Health check
[2024-04-18 08:03:20] [index:background] Health check
[2024-04-18 08:03:20] [index:background] CPU load threshold (3) breached: 3.98 [waiting 2]
[2024-04-18 08:03:22] [indexer:background] CPU load threshold (3) breached: 3.98 [waiting 2]
[2024-04-18 08:04:20] [indexer:background] Health check
[2024-04-18 08:07:50] [index:background] Health check
[2024-04-18 08:09:33] [indexer:background] Health check
[2024-04-18 08:13:37] [index:background] Health check
[2024-04-18 08:14:48] [indexer:background] Health check
[2024-04-18 08:17:35] [index:background] Health check
[2024-04-18 08:19:21] [indexer:background] Health check
[2024-04-18 08:23:04] [index:background] Health check
[2024-04-18 08:24:30] [indexer:background] Health check
[2024-04-18 08:27:57] [index:background] Health check
[2024-04-18 08:29:31] [indexer:background] Health check
[2024-04-18 08:32:49] [index:background] Health check
[2024-04-18 08:34:34] [indexer:background] Health check
[2024-04-18 08:37:42] [index:background] Health check
[2024-04-18 08:39:55] [indexer:background] Health check
[2024-04-18 08:42:35] [index:background] Health check
[2024-04-18 08:44:18] [indexer:background] Health check
[2024-04-18 08:47:54] [index:background] Health check
[2024-04-18 08:49:22] [indexer:background] Health check
[2024-04-18 08:53:20] [index:background] Health check
[2024-04-18 08:54:40] [indexer:background] Health check
[2024-04-18 08:58:13] [index:background] Health check
[2024-04-18 08:59:23] [indexer:background] Health check
[2024-04-18 09:02:34] [index:background] Health check
[2024-04-18 09:04:27] [indexer:background] Health check
[2024-04-18 09:04:27] [indexer:background] CPU load threshold (3) breached: 6.25 [waiting 2]
[2024-04-18 09:09:19] [index:background] Health check
[2024-04-18 09:09:19] [indexer:background] Health check
[2024-04-18 09:09:19] [indexer:background] Health check
[2024-04-18 09:12:56] [index:background] Health check
[2024-04-18 09:14:40] [indexer:background] Health check
[2024-04-18 09:17:36] [index:background] Health check
[2024-04-18 09:19:18] [indexer:background] Health check
[2024-04-18 09:23:14] [index:background] Health check
[2024-04-18 09:25:07] [indexer:background] Health check
[2024-04-18 09:27:45] [index:background] Health check
[2024-04-18 09:29:25] [indexer:background] Health check
[2024-04-18 09:33:17] [index:background] Health check
[2024-04-18 09:34:33] [indexer:background] Health check
[2024-04-18 09:37:35] [index:background] Health check
[2024-04-18 09:39:30] [indexer:background] Health check
[2024-04-18 09:42:37] [index:background] Health check
[2024-04-18 09:44:17] [indexer:background] Health check
[2024-04-18 09:47:37] [index:background] Health check
[2024-04-18 09:49:54] [indexer:background] Health check
[2024-04-18 09:52:34] [index:background] Health check
[2024-04-18 09:54:35] [indexer:background] Health check
[2024-04-18 09:57:43] [index:background] Health check
[2024-04-18 09:59:22] [indexer:background] Health check
[2024-04-18 10:02:50] [index:background] Health check
[2024-04-18 10:05:03] [indexer:background] Health check
[2024-04-18 10:05:03] [indexer:background] CPU load threshold (3) breached: 4.02 [waiting 2]
[2024-04-18 10:07:36] [index:background] Health check
[2024-04-18 10:11:46] [indexer:background] Health check
[2024-04-18 10:12:40] [index:background] Health check
[2024-04-18 10:15:12] [indexer:background] Health check
[2024-04-18 10:18:16] [index:background] Health check
[2024-04-18 10:19:30] [indexer:background] Health check
[2024-04-18 10:23:05] [index:background] Health check
[2024-04-18 10:24:29] [indexer:background] Health check
[2024-04-18 10:27:49] [index:background] Health check
[2024-04-18 10:29:29] [indexer:background] Health check
[2024-04-18 10:33:03] [index:background] Health check
[2024-04-18 10:34:20] [indexer:background] Health check
[2024-04-18 10:37:45] [index:background] Health check
[2024-04-18 10:39:26] [indexer:background] Health check
[2024-04-18 10:42:54] [index:background] Health check
[2024-04-18 10:44:27] [indexer:background] Health check
[2024-04-18 10:47:34] [index:background] Health check
[2024-04-18 10:49:54] [indexer:background] Health check
[2024-04-18 10:53:12] [index:background] Health check
[2024-04-18 10:54:20] [indexer:background] Health check
[2024-04-18 10:58:05] [index:background] Health check
[2024-04-18 10:59:20] [indexer:background] Health check
[2024-04-18 11:02:57] [index:background] Health check
[2024-04-18 11:04:18] [indexer:background] Health check
[2024-04-18 11:07:38] [index:background] Health check
[2024-04-18 11:09:29] [indexer:background] Health check
[2024-04-18 11:12:33] [index:background] Health check
[2024-04-18 11:14:18] [indexer:background] Health check
[2024-04-18 11:17:37] [index:background] Health check
[2024-04-18 11:19:24] [indexer:background] Health check
[2024-04-18 11:23:33] [index:background] Health check
[2024-04-18 11:24:34] [indexer:background] Health check
[2024-04-18 11:27:41] [index:background] Health check
[2024-04-18 11:29:35] [indexer:background] Health check
[2024-04-18 11:32:59] [index:background] Health check
[2024-04-18 11:34:17] [indexer:background] Health check
[2024-04-18 11:39:37] [index:background] Health check
[2024-04-18 11:39:37] [indexer:background] Health check
[2024-04-18 11:39:37] [indexer:background] Health check
[2024-04-18 11:42:38] [index:background] Health check
[2024-04-18 11:44:48] [indexer:background] Health check
[2024-04-18 11:48:01] [index:background] Health check
[2024-04-18 11:51:14] [indexer:background] Health check
[2024-04-18 11:53:14] [index:background] Health check
[2024-04-18 11:54:59] [indexer:background] Health check
[2024-04-18 11:58:33] [index:background] Health check
[2024-04-18 11:59:15] [indexer:background] Health check
[2024-04-18 12:04:55] [index:background] Health check
[2024-04-18 12:04:55] [indexer:background] Health check
[2024-04-18 12:04:55] [indexer:background] Health check
[2024-04-18 12:07:55] [index:background] Health check
[2024-04-18 12:09:49] [indexer:background] Health check
[2024-04-18 12:13:16] [index:background] Health check
[2024-04-18 12:14:56] [indexer:background] Health check
[2024-04-18 12:18:00] [index:background] Health check
[2024-04-18 12:19:44] [indexer:background] Health check
[2024-04-18 12:23:00] [index:background] Health check
[2024-04-18 12:24:40] [indexer:background] Health check
[2024-04-18 12:28:02] [index:background] Health check
[2024-04-18 12:29:17] [indexer:background] Health check
[2024-04-18 12:33:06] [index:background] Health check
[2024-04-18 12:34:25] [indexer:background] Health check
[2024-04-18 12:37:49] [index:background] Health check
[2024-04-18 12:39:52] [indexer:background] Health check
[2024-04-18 12:42:50] [index:background] Health check
[2024-04-18 12:44:25] [indexer:background] Health check
[2024-04-18 12:47:50] [index:background] Health check
[2024-04-18 12:49:22] [indexer:background] Health check
[2024-04-18 12:53:03] [index:background] Health check
[2024-04-18 12:54:22] [indexer:background] Health check
[2024-04-18 12:58:21] [index:background] Health check
[2024-04-18 12:59:36] [indexer:background] Health check
[2024-04-18 13:04:17] [index:background] Health check
[2024-04-18 13:04:17] [indexer:background] Health check
[2024-04-18 13:04:17] [indexer:background] Health check
[2024-04-18 13:10:38] [index:background] Health check
[2024-04-18 13:10:38] [indexer:background] Health check
[2024-04-18 13:10:38] [indexer:background] Health check
[2024-04-18 13:12:34] [index:background] Health check
[2024-04-18 13:14:15] [indexer:background] Health check
[2024-04-18 13:18:43] [index:background] Health check
[2024-04-18 13:19:45] [indexer:background] Health check
[2024-04-18 13:23:50] [index:background] Health check
[2024-04-18 13:25:03] [indexer:background] Health check
[2024-04-18 13:27:35] [index:background] Health check
[2024-04-18 13:29:15] [indexer:background] Health check
[2024-04-18 13:32:54] [index:background] Health check
[2024-04-18 13:34:31] [indexer:background] Health check
[2024-04-18 13:37:43] [index:background] Health check
[2024-04-18 13:39:56] [indexer:background] Health check
[2024-04-18 13:44:09] [index:background] Health check
[2024-04-18 13:44:40] [indexer:background] Health check
[2024-04-18 13:47:35] [index:background] Health check
[2024-04-18 13:49:19] [indexer:background] Health check
[2024-04-18 13:52:36] [index:background] Health check
[2024-04-18 13:54:26] [indexer:background] Health check
[2024-04-18 13:58:13] [index:background] Health check
[2024-04-18 13:59:16] [indexer:background] Health check
[2024-04-18 14:03:48] [index:background] Health check
[2024-04-18 14:04:45] [indexer:background] Health check
[2024-04-18 14:04:46] [query] Query for: 2023
[2024-04-18 14:04:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 14:04:46] [query] Engine: default
[2024-04-18 14:04:46] [query] Tokens: 2023
[2024-04-18 14:04:46] [query] Mods: 6
[2024-04-18 14:04:46] [query] Found results using: or logic
[2024-04-18 14:04:46] [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-18 14:04:46] [query] Results: 273 Pages of results: 28
[2024-04-18 14:04:46] [query] Execution time: 0.41183
[2024-04-18 14:04:46] [query] Query for: 2023
[2024-04-18 14:04:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-04-18 14:04:46] [query] Engine: default
[2024-04-18 14:04:46] [query] Tokens: 2023
[2024-04-18 14:04:46] [query] Mods: 6
[2024-04-18 14:04:46] [query] Found results using: or logic
[2024-04-18 14:04:46] [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-18 14:04:46] [query] Results: 273 Pages of results: 3
[2024-04-18 14:04:46] [query] Execution time: 0.06617
[2024-04-18 14:07:40] [index:background] Health check
[2024-04-18 14:07:40] [index:background] CPU load threshold (3) breached: 4.39 [waiting 2]
[2024-04-18 14:07:42] [indexer:background] CPU load threshold (3) breached: 4.39 [waiting 2]
[2024-04-18 14:09:31] [indexer:background] Health check
[2024-04-18 14:13:49] [index:background] Health check
[2024-04-18 14:14:33] [indexer:background] Health check
[2024-04-18 14:17:43] [index:background] Health check
[2024-04-18 14:19:22] [indexer:background] Health check
[2024-04-18 14:21:17] [query] Query for: 2023
[2024-04-18 14:21:17] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 14:21:17] [query] Engine: default
[2024-04-18 14:21:17] [query] Tokens: 2023
[2024-04-18 14:21:17] [query] Mods: 6
[2024-04-18 14:21:17] [query] Found results using: or logic
[2024-04-18 14:21:17] [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-18 14:21:17] [query] Results: 273 Pages of results: 28
[2024-04-18 14:21:17] [query] Execution time: 0.03748
[2024-04-18 14:23:20] [index:background] Health check
[2024-04-18 14:24:50] [indexer:background] Health check
[2024-04-18 14:27:36] [index:background] Health check
[2024-04-18 14:29:16] [indexer:background] Health check
[2024-04-18 14:32:35] [index:background] Health check
[2024-04-18 14:34:18] [indexer:background] Health check
[2024-04-18 14:39:55] [index:background] Health check
[2024-04-18 14:39:55] [indexer:background] Health check
[2024-04-18 14:39:56] [indexer:background] Health check
[2024-04-18 14:43:00] [index:background] Health check
[2024-04-18 14:44:21] [indexer:background] Health check
[2024-04-18 14:47:48] [index:background] Health check
[2024-04-18 14:48:29] [query] Query for: 2024
[2024-04-18 14:48:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 14:48:29] [query] Engine: default
[2024-04-18 14:48:29] [query] Tokens: 2024
[2024-04-18 14:48:29] [query] Mods: 6
[2024-04-18 14:48:29] [query] Found results using: or logic
[2024-04-18 14:48:29] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-18 14:48:29] [query] Results: 150 Pages of results: 15
[2024-04-18 14:48:29] [query] Execution time: 0.17555
[2024-04-18 14:49:19] [indexer:background] Health check
[2024-04-18 14:52:36] [index:background] Health check
[2024-04-18 14:54:20] [indexer:background] Health check
[2024-04-18 14:57:37] [index:background] Health check
[2024-04-18 15:00:40] [indexer:background] Health check
[2024-04-18 15:02:50] [index:background] Health check
[2024-04-18 15:04:53] [indexer:background] Health check
[2024-04-18 15:07:53] [index:background] Health check
[2024-04-18 15:09:15] [indexer:background] Health check
[2024-04-18 15:12:52] [index:background] Health check
[2024-04-18 15:14:46] [indexer:background] Health check
[2024-04-18 15:17:39] [index:background] Health check
[2024-04-18 15:20:26] [indexer:background] Health check
[2024-04-18 15:22:38] [index:background] Health check
[2024-04-18 15:24:38] [indexer:background] Health check
[2024-04-18 15:27:44] [index:background] Health check
[2024-04-18 15:30:52] [indexer:background] Health check
[2024-04-18 15:32:35] [index:background] Health check
[2024-04-18 15:34:28] [indexer:background] Health check
[2024-04-18 15:37:33] [index:background] Health check
[2024-04-18 15:39:21] [indexer:background] Health check
[2024-04-18 15:42:54] [index:background] Health check
[2024-04-18 15:45:37] [indexer:background] Health check
[2024-04-18 15:47:34] [index:background] Health check
[2024-04-18 15:50:32] [indexer:background] Health check
[2024-04-18 15:55:23] [index:background] Health check
[2024-04-18 15:55:23] [indexer:background] Health check
[2024-04-18 15:55:23] [indexer:background] Health check
[2024-04-18 15:57:43] [index:background] Health check
[2024-04-18 15:59:24] [indexer:background] Health check
[2024-04-18 16:02:48] [index:background] Health check
[2024-04-18 16:05:39] [indexer:background] Health check
[2024-04-18 16:08:22] [index:background] Health check
[2024-04-18 16:08:22] [index:background] CPU load threshold (3) breached: 4.26 [waiting 2]
[2024-04-18 16:08:24] [indexer:background] CPU load threshold (3) breached: 4.26 [waiting 2]
[2024-04-18 16:09:18] [indexer:background] Health check
[2024-04-18 16:13:26] [index:background] Health check
[2024-04-18 16:14:31] [indexer:background] Health check
[2024-04-18 16:17:38] [index:background] Health check
[2024-04-18 16:19:42] [indexer:background] Health check
[2024-04-18 16:23:17] [index:background] Health check
[2024-04-18 16:24:29] [indexer:background] Health check
[2024-04-18 16:28:31] [index:background] Health check
[2024-04-18 16:29:20] [indexer:background] Health check
[2024-04-18 16:33:08] [index:background] Health check
[2024-04-18 16:34:30] [indexer:background] Health check
[2024-04-18 16:37:45] [index:background] Health check
[2024-04-18 16:40:03] [indexer:background] Health check
[2024-04-18 16:42:35] [index:background] Health check
[2024-04-18 16:44:24] [indexer:background] Health check
[2024-04-18 16:47:37] [index:background] Health check
[2024-04-18 16:49:36] [query] Query for: 2024
[2024-04-18 16:49:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 16:49:36] [query] Engine: default
[2024-04-18 16:49:36] [query] Tokens: 2024
[2024-04-18 16:49:36] [query] Mods: 6
[2024-04-18 16:49:36] [query] Found results using: or logic
[2024-04-18 16:49:36] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-18 16:49:36] [query] Results: 150 Pages of results: 15
[2024-04-18 16:49:36] [query] Execution time: 0.03482
[2024-04-18 16:49:36] [indexer:background] Health check
[2024-04-18 16:52:34] [index:background] Health check
[2024-04-18 16:54:20] [indexer:background] Health check
[2024-04-18 16:57:39] [index:background] Health check
[2024-04-18 16:59:20] [indexer:background] Health check
[2024-04-18 17:03:55] [index:background] Health check
[2024-04-18 17:05:28] [indexer:background] Health check
[2024-04-18 17:08:04] [index:background] Health check
[2024-04-18 17:10:02] [indexer:background] Health check
[2024-04-18 17:13:36] [index:background] Health check
[2024-04-18 17:14:42] [indexer:background] Health check
[2024-04-18 17:17:45] [index:background] Health check
[2024-04-18 17:20:11] [indexer:background] Health check
[2024-04-18 17:25:49] [index:background] Health check
[2024-04-18 17:25:49] [indexer:background] Health check
[2024-04-18 17:25:49] [indexer:background] Health check
[2024-04-18 17:27:35] [index:background] Health check
[2024-04-18 17:30:00] [indexer:background] Health check
[2024-04-18 17:32:48] [index:background] Health check
[2024-04-18 17:34:37] [indexer:background] Health check
[2024-04-18 17:37:38] [index:background] Health check
[2024-04-18 17:39:25] [indexer:background] Health check
[2024-04-18 17:44:08] [index:background] Health check
[2024-04-18 17:44:45] [indexer:background] Health check
[2024-04-18 17:47:45] [index:background] Health check
[2024-04-18 17:50:14] [indexer:background] Health check
[2024-04-18 17:52:35] [index:background] Health check
[2024-04-18 17:55:13] [indexer:background] Health check
[2024-04-18 17:57:49] [index:background] Health check
[2024-04-18 17:59:28] [indexer:background] Health check
[2024-04-18 18:02:33] [index:background] Health check
[2024-04-18 18:05:51] [indexer:background] Health check
[2024-04-18 18:08:00] [index:background] Health check
[2024-04-18 18:09:26] [indexer:background] Health check
[2024-04-18 18:12:48] [index:background] Health check
[2024-04-18 18:16:07] [indexer:background] Health check
[2024-04-18 18:19:14] [index:background] Health check
[2024-04-18 18:19:48] [indexer:background] Health check
[2024-04-18 18:22:56] [index:background] Health check
[2024-04-18 18:25:27] [indexer:background] Health check
[2024-04-18 18:27:38] [index:background] Health check
[2024-04-18 18:29:17] [indexer:background] Health check
[2024-04-18 18:31:50] [query] Query for: 2023
[2024-04-18 18:31:50] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 18:31:50] [query] Engine: default
[2024-04-18 18:31:50] [query] Tokens: 2023
[2024-04-18 18:31:50] [query] Mods: 6
[2024-04-18 18:31:50] [query] Found results using: or logic
[2024-04-18 18:31: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 (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-18 18:31:50] [query] Results: 273 Pages of results: 28
[2024-04-18 18:31:50] [query] Execution time: 0.03772
[2024-04-18 18:31:53] [query] Query for: 2024
[2024-04-18 18:31:53] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 18:31:53] [query] Engine: default
[2024-04-18 18:31:53] [query] Tokens: 2024
[2024-04-18 18:31:53] [query] Mods: 6
[2024-04-18 18:31:53] [query] Found results using: or logic
[2024-04-18 18:31:53] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-04-18 18:31:53] [query] Results: 150 Pages of results: 15
[2024-04-18 18:31:53] [query] Execution time: 0.02561
[2024-04-18 18:32:42] [index:background] Health check
[2024-04-18 18:34:36] [indexer:background] Health check
[2024-04-18 18:37:55] [index:background] Health check
[2024-04-18 18:39:24] [indexer:background] Health check
[2024-04-18 18:43:34] [index:background] Health check
[2024-04-18 18:44:54] [indexer:background] Health check
[2024-04-18 18:48:31] [index:background] Health check
[2024-04-18 18:49:24] [indexer:background] Health check
[2024-04-18 18:53:40] [index:background] Health check
[2024-04-18 18:55:00] [indexer:background] Health check
[2024-04-18 18:57:51] [index:background] Health check
[2024-04-18 18:59:37] [indexer:background] Health check
[2024-04-18 19:02:48] [index:background] Health check
[2024-04-18 19:04:19] [indexer:background] Health check
[2024-04-18 19:07:37] [index:background] Health check
[2024-04-18 19:09:20] [indexer:background] Health check
[2024-04-18 19:13:02] [index:background] Health check
[2024-04-18 19:14:15] [indexer:background] Health check
[2024-04-18 19:17:37] [index:background] Health check
[2024-04-18 19:19:18] [indexer:background] Health check
[2024-04-18 19:22:55] [index:background] Health check
[2024-04-18 19:24:30] [indexer:background] Health check
[2024-04-18 19:28:58] [index:background] Health check
[2024-04-18 19:29:17] [indexer:background] Health check
[2024-04-18 19:32:54] [index:background] Health check
[2024-04-18 19:34:41] [indexer:background] Health check
[2024-04-18 19:38:23] [index:background] Health check
[2024-04-18 19:39:19] [indexer:background] Health check
[2024-04-18 19:42:53] [index:background] Health check
[2024-04-18 19:44:53] [indexer:background] Health check
[2024-04-18 19:47:42] [index:background] Health check
[2024-04-18 19:49:35] [indexer:background] Health check
[2024-04-18 19:53:46] [index:background] Health check
[2024-04-18 19:54:25] [indexer:background] Health check
[2024-04-18 19:58:19] [index:background] Health check
[2024-04-18 19:59:25] [indexer:background] Health check
[2024-04-18 20:03:27] [index:background] Health check
[2024-04-18 20:04:34] [indexer:background] Health check
[2024-04-18 20:07:52] [index:background] Health check
[2024-04-18 20:11:37] [indexer:background] Health check
[2024-04-18 20:12:35] [query] Query for: 2025
[2024-04-18 20:12:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 20:12:35] [query] Engine: default
[2024-04-18 20:12:36] [index:background] Health check
[2024-04-18 20:12:36] [query] Tokens: 2025
[2024-04-18 20:12:36] [query] Mods: 6
[2024-04-18 20:12:36] [query] Found results using: or logic
[2024-04-18 20:12: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 (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-18 20:12:36] [query] Results: 138 Pages of results: 14
[2024-04-18 20:12:36] [query] Execution time: 1.02154
[2024-04-18 20:14:15] [indexer:background] Health check
[2024-04-18 20:17:59] [index:background] Health check
[2024-04-18 20:19:53] [indexer:background] Health check
[2024-04-18 20:22:34] [index:background] Health check
[2024-04-18 20:24:30] [indexer:background] Health check
[2024-04-18 20:27:36] [index:background] Health check
[2024-04-18 20:30:32] [indexer:background] Health check
[2024-04-18 20:32:46] [index:background] Health check
[2024-04-18 20:34:49] [indexer:background] Health check
[2024-04-18 20:37:52] [index:background] Health check
[2024-04-18 20:39:38] [indexer:background] Health check
[2024-04-18 20:42:47] [index:background] Health check
[2024-04-18 20:45:08] [indexer:background] Health check
[2024-04-18 20:47:46] [index:background] Health check
[2024-04-18 20:51:01] [indexer:background] Health check
[2024-04-18 20:52:44] [index:background] Health check
[2024-04-18 20:55:28] [indexer:background] Health check
[2024-04-18 20:57:44] [index:background] Health check
[2024-04-18 20:59:32] [indexer:background] Health check
[2024-04-18 21:02:35] [index:background] Health check
[2024-04-18 21:05:46] [indexer:background] Health check
[2024-04-18 21:07:38] [index:background] Health check
[2024-04-18 21:09:29] [indexer:background] Health check
[2024-04-18 21:13:13] [index:background] Health check
[2024-04-18 21:14:17] [indexer:background] Health check
[2024-04-18 21:17:35] [index:background] Health check
[2024-04-18 21:20:30] [indexer:background] Health check
[2024-04-18 21:22:44] [index:background] Health check
[2024-04-18 21:24:16] [indexer:background] Health check
[2024-04-18 21:27:36] [index:background] Health check
[2024-04-18 21:29:29] [indexer:background] Health check
[2024-04-18 21:32:50] [index:background] Health check
[2024-04-18 21:34:16] [indexer:background] Health check
[2024-04-18 21:37:34] [index:background] Health check
[2024-04-18 21:39:23] [indexer:background] Health check
[2024-04-18 21:42:39] [index:background] Health check
[2024-04-18 21:44:28] [indexer:background] Health check
[2024-04-18 21:48:09] [index:background] Health check
[2024-04-18 21:49:44] [indexer:background] Health check
[2024-04-18 21:52:37] [index:background] Health check
[2024-04-18 21:54:32] [indexer:background] Health check
[2024-04-18 21:57:37] [index:background] Health check
[2024-04-18 21:59:18] [indexer:background] Health check
[2024-04-18 22:02:42] [index:background] Health check
[2024-04-18 22:05:17] [indexer:background] Health check
[2024-04-18 22:07:46] [index:background] Health check
[2024-04-18 22:09:19] [indexer:background] Health check
[2024-04-18 22:13:21] [index:background] Health check
[2024-04-18 22:14:26] [indexer:background] Health check
[2024-04-18 22:18:31] [index:background] Health check
[2024-04-18 22:19:33] [indexer:background] Health check
[2024-04-18 22:22:45] [index:background] Health check
[2024-04-18 22:25:20] [indexer:background] Health check
[2024-04-18 22:29:09] [index:background] Health check
[2024-04-18 22:29:17] [indexer:background] Health check
[2024-04-18 22:33:00] [index:background] Health check
[2024-04-18 22:34:50] [indexer:background] Health check
[2024-04-18 22:37:44] [index:background] Health check
[2024-04-18 22:39:31] [indexer:background] Health check
[2024-04-18 22:43:18] [index:background] Health check
[2024-04-18 22:44:30] [indexer:background] Health check
[2024-04-18 22:48:39] [index:background] Health check
[2024-04-18 22:49:17] [indexer:background] Health check
[2024-04-18 22:53:44] [index:background] Health check
[2024-04-18 22:55:19] [indexer:background] Health check
[2024-04-18 22:57:34] [index:background] Health check
[2024-04-18 22:59:28] [indexer:background] Health check
[2024-04-18 23:02:55] [index:background] Health check
[2024-04-18 23:04:19] [indexer:background] Health check
[2024-04-18 23:07:53] [index:background] Health check
[2024-04-18 23:09:25] [indexer:background] Health check
[2024-04-18 23:12:40] [index:background] Health check
[2024-04-18 23:14:21] [indexer:background] Health check
[2024-04-18 23:17:44] [index:background] Health check
[2024-04-18 23:19:16] [indexer:background] Health check
[2024-04-18 23:23:16] [index:background] Health check
[2024-04-18 23:24:32] [query] Query for: 2025
[2024-04-18 23:24:32] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-04-18 23:24:32] [query] Engine: default
[2024-04-18 23:24:32] [query] Tokens: 2025
[2024-04-18 23:24:32] [query] Mods: 6
[2024-04-18 23:24:32] [query] Found results using: or logic
[2024-04-18 23:24:32] [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-18 23:24:32] [query] Results: 138 Pages of results: 14
[2024-04-18 23:24:32] [query] Execution time: 0.31894
[2024-04-18 23:24:32] [indexer:background] Health check
[2024-04-18 23:27:36] [index:background] Health check
[2024-04-18 23:29:28] [indexer:background] Health check
[2024-04-18 23:32:52] [index:background] Health check
[2024-04-18 23:34:31] [indexer:background] Health check
[2024-04-18 23:37:47] [index:background] Health check
[2024-04-18 23:39:39] [indexer:background] Health check
[2024-04-18 23:42:35] [index:background] Health check
[2024-04-18 23:44:27] [indexer:background] Health check
[2024-04-18 23:47:46] [index:background] Health check
[2024-04-18 23:49:17] [indexer:background] Health check
[2024-04-18 23:52:39] [index:background] Health check
[2024-04-18 23:54:25] [indexer:background] Health check
[2024-04-18 23:57:48] [index:background] Health check
[2024-04-18 23:59:28] [indexer:background] Health check