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