[2024-11-29 00:02:22] [indexer:background] Health check
[2024-11-29 00:02:22] [indexer:background] CPU load threshold (3) breached: 6.96 [waiting 2]
[2024-11-29 00:04:37] [index:background] Health check
[2024-11-29 00:04:37] [index:background] CPU load threshold (3) breached: 7.32 [waiting 2]
[2024-11-29 00:04:39] [indexer:background] CPU load threshold (3) breached: 7.32 [waiting 2]
[2024-11-29 00:07:53] [indexer:background] Health check
[2024-11-29 00:07:53] [indexer:background] CPU load threshold (3) breached: 7.01 [waiting 2]
[2024-11-29 00:09:38] [index:background] Health check
[2024-11-29 00:09:38] [index:background] CPU load threshold (3) breached: 6.14 [waiting 2]
[2024-11-29 00:09:40] [indexer:background] CPU load threshold (3) breached: 6.14 [waiting 2]
[2024-11-29 00:13:00] [indexer:background] Health check
[2024-11-29 00:13:00] [indexer:background] CPU load threshold (3) breached: 6.3 [waiting 2]
[2024-11-29 00:14:56] [index:background] Health check
[2024-11-29 00:14:56] [index:background] CPU load threshold (3) breached: 6.82 [waiting 2]
[2024-11-29 00:14:58] [indexer:background] CPU load threshold (3) breached: 6.68 [waiting 2]
[2024-11-29 00:16:49] [indexer:background] Health check
[2024-11-29 00:16:49] [indexer:background] CPU load threshold (3) breached: 7.7 [waiting 2]
[2024-11-29 00:19:56] [index:background] Health check
[2024-11-29 00:19:56] [index:background] CPU load threshold (3) breached: 7.94 [waiting 2]
[2024-11-29 00:19:58] [indexer:background] CPU load threshold (3) breached: 7.55 [waiting 2]
[2024-11-29 00:22:07] [indexer:background] Health check
[2024-11-29 00:22:07] [indexer:background] CPU load threshold (3) breached: 6.49 [waiting 2]
[2024-11-29 00:24:56] [index:background] Health check
[2024-11-29 00:24:56] [index:background] CPU load threshold (3) breached: 5.97 [waiting 2]
[2024-11-29 00:24:58] [indexer:background] CPU load threshold (3) breached: 6.46 [waiting 2]
[2024-11-29 00:26:52] [indexer:background] Health check
[2024-11-29 00:26:52] [indexer:background] CPU load threshold (3) breached: 14.54 [waiting 2]
[2024-11-29 00:29:56] [index:background] Health check
[2024-11-29 00:29:56] [index:background] CPU load threshold (3) breached: 15.34 [waiting 2]
[2024-11-29 00:29:59] [indexer:background] CPU load threshold (3) breached: 15.07 [waiting 2]
[2024-11-29 00:31:49] [indexer:background] Health check
[2024-11-29 00:31:49] [indexer:background] CPU load threshold (3) breached: 10.57 [waiting 2]
[2024-11-29 00:34:56] [index:background] Health check
[2024-11-29 00:34:56] [index:background] CPU load threshold (3) breached: 7.27 [waiting 2]
[2024-11-29 00:34:58] [indexer:background] CPU load threshold (3) breached: 7.17 [waiting 2]
[2024-11-29 00:36:57] [indexer:background] Health check
[2024-11-29 00:36:57] [indexer:background] CPU load threshold (3) breached: 6.03 [waiting 2]
[2024-11-29 00:39:57] [index:background] Health check
[2024-11-29 00:39:57] [index:background] CPU load threshold (3) breached: 7.05 [waiting 2]
[2024-11-29 00:39:59] [indexer:background] CPU load threshold (3) breached: 6.89 [waiting 2]
[2024-11-29 00:43:00] [indexer:background] Health check
[2024-11-29 00:43:00] [indexer:background] CPU load threshold (3) breached: 6.98 [waiting 2]
[2024-11-29 00:44:38] [index:background] Health check
[2024-11-29 00:44:38] [index:background] CPU load threshold (3) breached: 8.41 [waiting 2]
[2024-11-29 00:44:40] [indexer:background] CPU load threshold (3) breached: 8.7 [waiting 2]
[2024-11-29 00:46:48] [indexer:background] Health check
[2024-11-29 00:46:48] [indexer:background] CPU load threshold (3) breached: 5.86 [waiting 2]
[2024-11-29 00:49:57] [index:background] Health check
[2024-11-29 00:49:57] [index:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-11-29 00:49:59] [indexer:background] CPU load threshold (3) breached: 7.17 [waiting 2]
[2024-11-29 00:51:55] [indexer:background] Health check
[2024-11-29 00:51:55] [indexer:background] CPU load threshold (3) breached: 6.81 [waiting 2]
[2024-11-29 00:54:47] [index:background] Health check
[2024-11-29 00:54:47] [index:background] CPU load threshold (3) breached: 5.7 [waiting 2]
[2024-11-29 00:54:50] [indexer:background] CPU load threshold (3) breached: 5.88 [waiting 2]
[2024-11-29 00:57:29] [indexer:background] Health check
[2024-11-29 00:57:29] [indexer:background] CPU load threshold (3) breached: 7.01 [waiting 2]
[2024-11-29 01:02:07] [index:background] Health check
[2024-11-29 01:02:07] [index:background] CPU load threshold (3) breached: 6.83 [waiting 2]
[2024-11-29 01:02:09] [indexer:background] CPU load threshold (3) breached: 6.85 [waiting 2]
[2024-11-29 01:02:12] [indexer:background] Health check
[2024-11-29 01:02:12] [indexer:background] CPU load threshold (3) breached: 6.85 [waiting 2]
[2024-11-29 01:02:14] [indexer:background] Health check
[2024-11-29 01:02:14] [indexer:background] CPU load threshold (3) breached: 6.85 [waiting 2]
[2024-11-29 01:04:50] [index:background] Health check
[2024-11-29 01:04:50] [index:background] CPU load threshold (3) breached: 8.02 [waiting 2]
[2024-11-29 01:04:52] [indexer:background] CPU load threshold (3) breached: 8.02 [waiting 2]
[2024-11-29 01:06:59] [indexer:background] Health check
[2024-11-29 01:06:59] [indexer:background] CPU load threshold (3) breached: 7.03 [waiting 2]
[2024-11-29 01:11:59] [index:background] Health check
[2024-11-29 01:11:59] [index:background] CPU load threshold (3) breached: 7.98 [waiting 2]
[2024-11-29 01:12:01] [indexer:background] CPU load threshold (3) breached: 7.58 [waiting 2]
[2024-11-29 01:12:03] [indexer:background] Health check
[2024-11-29 01:12:03] [indexer:background] CPU load threshold (3) breached: 7.58 [waiting 2]
[2024-11-29 01:12:05] [indexer:background] Health check
[2024-11-29 01:12:05] [indexer:background] CPU load threshold (3) breached: 7.61 [waiting 2]
[2024-11-29 01:14:49] [index:background] Health check
[2024-11-29 01:14:49] [index:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 01:14:51] [indexer:background] CPU load threshold (3) breached: 7.85 [waiting 2]
[2024-11-29 01:18:49] [indexer:background] Health check
[2024-11-29 01:18:49] [indexer:background] CPU load threshold (3) breached: 9.34 [waiting 2]
[2024-11-29 01:20:18] [index:background] Health check
[2024-11-29 01:20:18] [index:background] CPU load threshold (3) breached: 9.67 [waiting 2]
[2024-11-29 01:20:21] [indexer:background] CPU load threshold (3) breached: 9.54 [waiting 2]
[2024-11-29 01:21:52] [indexer:background] Health check
[2024-11-29 01:21:52] [indexer:background] CPU load threshold (3) breached: 10.71 [waiting 2]
[2024-11-29 01:26:15] [index:background] Health check
[2024-11-29 01:26:15] [index:background] CPU load threshold (3) breached: 7.52 [waiting 2]
[2024-11-29 01:26:17] [indexer:background] CPU load threshold (3) breached: 7.52 [waiting 2]
[2024-11-29 01:26:47] [indexer:background] Health check
[2024-11-29 01:26:47] [indexer:background] CPU load threshold (3) breached: 7.87 [waiting 2]
[2024-11-29 01:31:44] [index:background] Health check
[2024-11-29 01:31:44] [index:background] CPU load threshold (3) breached: 6.95 [waiting 2]
[2024-11-29 01:31:47] [indexer:background] CPU load threshold (3) breached: 7.03 [waiting 2]
[2024-11-29 01:31:51] [indexer:background] Health check
[2024-11-29 01:31:51] [indexer:background] CPU load threshold (3) breached: 7.27 [waiting 2]
[2024-11-29 01:33:57] [query] Query for: search_term_string
[2024-11-29 01:33:57] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 128 offset: 0 fields: all
[2024-11-29 01:33:57] [query] Engine: default
[2024-11-29 01:33:57] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 01:33:57] [query] Mods: 6
[2024-11-29 01:33:57] [query] Using OR logic
[2024-11-29 01:33:58] [query] Found results using: or logic
[2024-11-29 01:33:58] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 1270, 10
[2024-11-29 01:33:58] [query] Results: 1382 Pages of results: 139
[2024-11-29 01:33:58] [query] Execution time: 0.87435
[2024-11-29 01:35:25] [index:background] Health check
[2024-11-29 01:35:25] [index:background] CPU load threshold (3) breached: 8.26 [waiting 2]
[2024-11-29 01:35:27] [indexer:background] CPU load threshold (3) breached: 8 [waiting 2]
[2024-11-29 01:37:52] [indexer:background] Health check
[2024-11-29 01:37:52] [indexer:background] CPU load threshold (3) breached: 9.03 [waiting 2]
[2024-11-29 01:39:59] [index:background] Health check
[2024-11-29 01:39:59] [index:background] CPU load threshold (3) breached: 8.73 [waiting 2]
[2024-11-29 01:40:01] [indexer:background] CPU load threshold (3) breached: 8.99 [waiting 2]
[2024-11-29 01:42:35] [indexer:background] Health check
[2024-11-29 01:42:36] [indexer:background] CPU load threshold (3) breached: 8.06 [waiting 2]
[2024-11-29 01:47:52] [index:background] Health check
[2024-11-29 01:47:52] [index:background] CPU load threshold (3) breached: 6.98 [waiting 2]
[2024-11-29 01:47:54] [indexer:background] CPU load threshold (3) breached: 6.98 [waiting 2]
[2024-11-29 01:47:57] [indexer:background] Health check
[2024-11-29 01:47:57] [indexer:background] CPU load threshold (3) breached: 6.74 [waiting 2]
[2024-11-29 01:47:59] [indexer:background] Health check
[2024-11-29 01:47:59] [indexer:background] CPU load threshold (3) breached: 6.74 [waiting 2]
[2024-11-29 01:51:29] [index:background] Health check
[2024-11-29 01:51:29] [index:background] CPU load threshold (3) breached: 6.79 [waiting 2]
[2024-11-29 01:51:32] [indexer:background] CPU load threshold (3) breached: 6.73 [waiting 2]
[2024-11-29 01:51:34] [query] Query for: search_term_string
[2024-11-29 01:51:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 125 offset: 0 fields: all
[2024-11-29 01:51:34] [query] Engine: default
[2024-11-29 01:51:34] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 01:51:34] [query] Mods: 6
[2024-11-29 01:51:34] [query] Using OR logic
[2024-11-29 01:51:35] [query] Found results using: or logic
[2024-11-29 01:51:35] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 1240, 10
[2024-11-29 01:51:35] [query] Results: 1382 Pages of results: 139
[2024-11-29 01:51:35] [query] Execution time: 0.89106
[2024-11-29 01:52:26] [indexer:background] Health check
[2024-11-29 01:52:27] [indexer:background] CPU load threshold (3) breached: 6.4 [waiting 2]
[2024-11-29 01:55:07] [index:background] Health check
[2024-11-29 01:55:07] [index:background] CPU load threshold (3) breached: 8.6 [waiting 2]
[2024-11-29 01:55:09] [indexer:background] CPU load threshold (3) breached: 8.6 [waiting 2]
[2024-11-29 01:58:23] [indexer:background] Health check
[2024-11-29 01:58:23] [indexer:background] CPU load threshold (3) breached: 6.77 [waiting 2]
[2024-11-29 02:00:24] [index:background] Health check
[2024-11-29 02:00:24] [index:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-11-29 02:00:26] [indexer:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-11-29 02:01:49] [indexer:background] Health check
[2024-11-29 02:01:49] [indexer:background] CPU load threshold (3) breached: 7.18 [waiting 2]
[2024-11-29 02:04:49] [index:background] Health check
[2024-11-29 02:04:49] [index:background] CPU load threshold (3) breached: 8.36 [waiting 2]
[2024-11-29 02:04:51] [indexer:background] CPU load threshold (3) breached: 8.36 [waiting 2]
[2024-11-29 02:09:15] [query] Query for: search_term_string
[2024-11-29 02:09:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 126 offset: 0 fields: all
[2024-11-29 02:09:15] [query] Engine: default
[2024-11-29 02:09:15] [indexer:background] Health check
[2024-11-29 02:09:16] [indexer:background] CPU load threshold (3) breached: 7.49 [waiting 2]
[2024-11-29 02:09:16] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 02:09:16] [query] Mods: 6
[2024-11-29 02:09:16] [query] Using OR logic
[2024-11-29 02:09:16] [query] Found results using: or logic
[2024-11-29 02:09:16] [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 1250, 10
[2024-11-29 02:09:16] [query] Results: 1382 Pages of results: 139
[2024-11-29 02:09:16] [query] Execution time: 0.80582
[2024-11-29 02:09:52] [index:background] Health check
[2024-11-29 02:09:52] [index:background] CPU load threshold (3) breached: 7.81 [waiting 2]
[2024-11-29 02:09:54] [indexer:background] CPU load threshold (3) breached: 7.81 [waiting 2]
[2024-11-29 02:12:31] [indexer:background] Health check
[2024-11-29 02:12:31] [indexer:background] CPU load threshold (3) breached: 7.2 [waiting 2]
[2024-11-29 02:14:41] [index:background] Health check
[2024-11-29 02:14:41] [index:background] CPU load threshold (3) breached: 7.66 [waiting 2]
[2024-11-29 02:14:43] [indexer:background] CPU load threshold (3) breached: 7.69 [waiting 2]
[2024-11-29 02:17:33] [indexer:background] Health check
[2024-11-29 02:17:33] [indexer:background] CPU load threshold (3) breached: 7.57 [waiting 2]
[2024-11-29 02:19:37] [index:background] Health check
[2024-11-29 02:19:37] [index:background] CPU load threshold (3) breached: 6.92 [waiting 2]
[2024-11-29 02:19:39] [indexer:background] CPU load threshold (3) breached: 6.92 [waiting 2]
[2024-11-29 02:21:48] [indexer:background] Health check
[2024-11-29 02:21:48] [indexer:background] CPU load threshold (3) breached: 7.29 [waiting 2]
[2024-11-29 02:25:09] [index:background] Health check
[2024-11-29 02:25:09] [index:background] CPU load threshold (3) breached: 6.99 [waiting 2]
[2024-11-29 02:25:11] [indexer:background] CPU load threshold (3) breached: 6.99 [waiting 2]
[2024-11-29 02:26:55] [query] Query for: search_term_string
[2024-11-29 02:26:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 9 offset: 0 fields: all
[2024-11-29 02:26:55] [query] Engine: default
[2024-11-29 02:26:55] [indexer:background] Health check
[2024-11-29 02:26:55] [indexer:background] CPU load threshold (3) breached: 5.75 [waiting 2]
[2024-11-29 02:26:55] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 02:26:55] [query] Mods: 6
[2024-11-29 02:26:55] [query] Using OR logic
[2024-11-29 02:26:55] [query] Found results using: or logic
[2024-11-29 02:26: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 80, 10
[2024-11-29 02:26:55] [query] Results: 1382 Pages of results: 139
[2024-11-29 02:26:55] [query] Execution time: 0.76635
[2024-11-29 02:30:04] [index:background] Health check
[2024-11-29 02:30:04] [index:background] CPU load threshold (3) breached: 5.98 [waiting 2]
[2024-11-29 02:30:06] [indexer:background] CPU load threshold (3) breached: 5.98 [waiting 2]
[2024-11-29 02:32:10] [indexer:background] Health check
[2024-11-29 02:32:10] [indexer:background] CPU load threshold (3) breached: 7.18 [waiting 2]
[2024-11-29 02:34:37] [index:background] Health check
[2024-11-29 02:34:37] [index:background] CPU load threshold (3) breached: 8.49 [waiting 2]
[2024-11-29 02:34:39] [indexer:background] CPU load threshold (3) breached: 8.61 [waiting 2]
[2024-11-29 02:36:47] [indexer:background] Health check
[2024-11-29 02:36:47] [indexer:background] CPU load threshold (3) breached: 10.51 [waiting 2]
[2024-11-29 02:39:38] [index:background] Health check
[2024-11-29 02:39:38] [index:background] CPU load threshold (3) breached: 11.01 [waiting 2]
[2024-11-29 02:39:40] [indexer:background] CPU load threshold (3) breached: 10.93 [waiting 2]
[2024-11-29 02:41:47] [indexer:background] Health check
[2024-11-29 02:41:47] [indexer:background] CPU load threshold (3) breached: 9.38 [waiting 2]
[2024-11-29 02:44:38] [index:background] Health check
[2024-11-29 02:44:38] [index:background] CPU load threshold (3) breached: 11.53 [waiting 2]
[2024-11-29 02:44:40] [indexer:background] CPU load threshold (3) breached: 11.25 [waiting 2]
[2024-11-29 02:46:48] [indexer:background] Health check
[2024-11-29 02:46:48] [indexer:background] CPU load threshold (3) breached: 11.95 [waiting 2]
[2024-11-29 02:49:37] [index:background] Health check
[2024-11-29 02:49:37] [index:background] CPU load threshold (3) breached: 11.26 [waiting 2]
[2024-11-29 02:49:39] [indexer:background] CPU load threshold (3) breached: 11.8 [waiting 2]
[2024-11-29 02:51:48] [indexer:background] Health check
[2024-11-29 02:51:48] [indexer:background] CPU load threshold (3) breached: 9.71 [waiting 2]
[2024-11-29 02:54:37] [index:background] Health check
[2024-11-29 02:54:37] [index:background] CPU load threshold (3) breached: 9.32 [waiting 2]
[2024-11-29 02:54:39] [indexer:background] CPU load threshold (3) breached: 9.32 [waiting 2]
[2024-11-29 02:56:48] [indexer:background] Health check
[2024-11-29 02:56:48] [indexer:background] CPU load threshold (3) breached: 10.61 [waiting 2]
[2024-11-29 02:59:37] [index:background] Health check
[2024-11-29 02:59:37] [index:background] CPU load threshold (3) breached: 10.69 [waiting 2]
[2024-11-29 02:59:39] [indexer:background] CPU load threshold (3) breached: 10.69 [waiting 2]
[2024-11-29 03:01:47] [indexer:background] Health check
[2024-11-29 03:01:47] [indexer:background] CPU load threshold (3) breached: 10.27 [waiting 2]
[2024-11-29 03:04:37] [index:background] Health check
[2024-11-29 03:04:37] [index:background] CPU load threshold (3) breached: 10.76 [waiting 2]
[2024-11-29 03:04:39] [indexer:background] CPU load threshold (3) breached: 10.76 [waiting 2]
[2024-11-29 03:06:47] [indexer:background] Health check
[2024-11-29 03:06:47] [indexer:background] CPU load threshold (3) breached: 12.34 [waiting 2]
[2024-11-29 03:09:37] [index:background] Health check
[2024-11-29 03:09:37] [index:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 03:09:39] [indexer:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 03:11:47] [indexer:background] Health check
[2024-11-29 03:11:47] [indexer:background] CPU load threshold (3) breached: 14.94 [waiting 2]
[2024-11-29 03:14:37] [index:background] Health check
[2024-11-29 03:14:37] [index:background] CPU load threshold (3) breached: 7.19 [waiting 2]
[2024-11-29 03:14:39] [indexer:background] CPU load threshold (3) breached: 7.19 [waiting 2]
[2024-11-29 03:16:47] [indexer:background] Health check
[2024-11-29 03:16:47] [indexer:background] CPU load threshold (3) breached: 7.95 [waiting 2]
[2024-11-29 03:19:38] [index:background] Health check
[2024-11-29 03:19:38] [index:background] CPU load threshold (3) breached: 8.5 [waiting 2]
[2024-11-29 03:19:40] [indexer:background] CPU load threshold (3) breached: 8.5 [waiting 2]
[2024-11-29 03:21:47] [indexer:background] Health check
[2024-11-29 03:21:47] [indexer:background] CPU load threshold (3) breached: 9.2 [waiting 2]
[2024-11-29 03:24:38] [index:background] Health check
[2024-11-29 03:24:38] [index:background] CPU load threshold (3) breached: 7.61 [waiting 2]
[2024-11-29 03:24:40] [indexer:background] CPU load threshold (3) breached: 7.61 [waiting 2]
[2024-11-29 03:26:48] [indexer:background] Health check
[2024-11-29 03:26:48] [indexer:background] CPU load threshold (3) breached: 7.41 [waiting 2]
[2024-11-29 03:29:37] [index:background] Health check
[2024-11-29 03:29:37] [index:background] CPU load threshold (3) breached: 7.96 [waiting 2]
[2024-11-29 03:29:39] [indexer:background] CPU load threshold (3) breached: 7.96 [waiting 2]
[2024-11-29 03:31:47] [indexer:background] Health check
[2024-11-29 03:31:47] [indexer:background] CPU load threshold (3) breached: 9.41 [waiting 2]
[2024-11-29 03:33:15] [query] Query for: search_term_string
[2024-11-29 03:33:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 125 offset: 0 fields: all
[2024-11-29 03:33:15] [query] Engine: default
[2024-11-29 03:33:15] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 03:33:15] [query] Mods: 6
[2024-11-29 03:33:15] [query] Using OR logic
[2024-11-29 03:33:15] [query] Found results using: or logic
[2024-11-29 03:33:15] [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 1240, 10
[2024-11-29 03:33:15] [query] Results: 1382 Pages of results: 139
[2024-11-29 03:33:15] [query] Execution time: 0.78313
[2024-11-29 03:34:37] [index:background] Health check
[2024-11-29 03:34:37] [index:background] CPU load threshold (3) breached: 8.08 [waiting 2]
[2024-11-29 03:34:39] [indexer:background] CPU load threshold (3) breached: 8.08 [waiting 2]
[2024-11-29 03:36:47] [indexer:background] Health check
[2024-11-29 03:36:47] [indexer:background] CPU load threshold (3) breached: 7.8 [waiting 2]
[2024-11-29 03:39:37] [index:background] Health check
[2024-11-29 03:39:37] [index:background] CPU load threshold (3) breached: 8.52 [waiting 2]
[2024-11-29 03:39:39] [indexer:background] CPU load threshold (3) breached: 8.52 [waiting 2]
[2024-11-29 03:41:47] [indexer:background] Health check
[2024-11-29 03:41:47] [indexer:background] CPU load threshold (3) breached: 8.7 [waiting 2]
[2024-11-29 03:44:37] [index:background] Health check
[2024-11-29 03:44:37] [index:background] CPU load threshold (3) breached: 8.8 [waiting 2]
[2024-11-29 03:44:39] [indexer:background] CPU load threshold (3) breached: 8.8 [waiting 2]
[2024-11-29 03:46:48] [indexer:background] Health check
[2024-11-29 03:46:48] [indexer:background] CPU load threshold (3) breached: 9.38 [waiting 2]
[2024-11-29 03:49:38] [index:background] Health check
[2024-11-29 03:49:38] [index:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 03:49:40] [indexer:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 03:51:49] [indexer:background] Health check
[2024-11-29 03:51:49] [indexer:background] CPU load threshold (3) breached: 10.04 [waiting 2]
[2024-11-29 03:54:37] [index:background] Health check
[2024-11-29 03:54:37] [index:background] CPU load threshold (3) breached: 9.75 [waiting 2]
[2024-11-29 03:54:39] [indexer:background] CPU load threshold (3) breached: 9.75 [waiting 2]
[2024-11-29 03:56:53] [indexer:background] Health check
[2024-11-29 03:56:53] [indexer:background] CPU load threshold (3) breached: 9.04 [waiting 2]
[2024-11-29 04:00:01] [index:background] Health check
[2024-11-29 04:00:01] [index:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 04:00:03] [indexer:background] CPU load threshold (3) breached: 9.2 [waiting 2]
[2024-11-29 04:01:55] [indexer:background] Health check
[2024-11-29 04:01:56] [indexer:background] CPU load threshold (3) breached: 8.61 [waiting 2]
[2024-11-29 04:05:31] [index:background] Health check
[2024-11-29 04:05:31] [index:background] CPU load threshold (3) breached: 10.15 [waiting 2]
[2024-11-29 04:05:33] [indexer:background] CPU load threshold (3) breached: 10.3 [waiting 2]
[2024-11-29 04:08:44] [indexer:background] Health check
[2024-11-29 04:08:44] [indexer:background] CPU load threshold (3) breached: 8.25 [waiting 2]
[2024-11-29 04:09:15] [query] Query for: search_term_string
[2024-11-29 04:09:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 8 offset: 0 fields: all
[2024-11-29 04:09:15] [query] Engine: default
[2024-11-29 04:09:15] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 04:09:15] [query] Mods: 6
[2024-11-29 04:09:15] [query] Using OR logic
[2024-11-29 04:09:16] [query] Found results using: or logic
[2024-11-29 04:09:16] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 70, 10
[2024-11-29 04:09:16] [query] Results: 1382 Pages of results: 139
[2024-11-29 04:09:16] [query] Execution time: 0.82692
[2024-11-29 04:09:39] [index:background] Health check
[2024-11-29 04:09:39] [index:background] CPU load threshold (3) breached: 8.9 [waiting 2]
[2024-11-29 04:09:41] [indexer:background] CPU load threshold (3) breached: 8.9 [waiting 2]
[2024-11-29 04:11:49] [indexer:background] Health check
[2024-11-29 04:11:49] [indexer:background] CPU load threshold (3) breached: 8.85 [waiting 2]
[2024-11-29 04:14:56] [index:background] Health check
[2024-11-29 04:14:56] [index:background] CPU load threshold (3) breached: 8.85 [waiting 2]
[2024-11-29 04:14:58] [indexer:background] CPU load threshold (3) breached: 8.62 [waiting 2]
[2024-11-29 04:19:09] [indexer:background] Health check
[2024-11-29 04:19:09] [indexer:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 04:21:07] [index:background] Health check
[2024-11-29 04:21:07] [index:background] CPU load threshold (3) breached: 9.82 [waiting 2]
[2024-11-29 04:21:09] [indexer:background] CPU load threshold (3) breached: 9.76 [waiting 2]
[2024-11-29 04:21:55] [indexer:background] Health check
[2024-11-29 04:21:55] [indexer:background] CPU load threshold (3) breached: 10.27 [waiting 2]
[2024-11-29 04:25:30] [index:background] Health check
[2024-11-29 04:25:30] [index:background] CPU load threshold (3) breached: 9.11 [waiting 2]
[2024-11-29 04:25:32] [indexer:background] CPU load threshold (3) breached: 9.11 [waiting 2]
[2024-11-29 04:26:48] [indexer:background] Health check
[2024-11-29 04:26:48] [indexer:background] CPU load threshold (3) breached: 10.42 [waiting 2]
[2024-11-29 04:31:25] [index:background] Health check
[2024-11-29 04:31:25] [index:background] CPU load threshold (3) breached: 11.17 [waiting 2]
[2024-11-29 04:31:27] [indexer:background] CPU load threshold (3) breached: 11.17 [waiting 2]
[2024-11-29 04:32:01] [indexer:background] Health check
[2024-11-29 04:32:01] [indexer:background] CPU load threshold (3) breached: 10.97 [waiting 2]
[2024-11-29 04:34:55] [index:background] Health check
[2024-11-29 04:34:55] [index:background] CPU load threshold (3) breached: 10.24 [waiting 2]
[2024-11-29 04:34:57] [indexer:background] CPU load threshold (3) breached: 10.24 [waiting 2]
[2024-11-29 04:37:32] [indexer:background] Health check
[2024-11-29 04:37:32] [indexer:background] CPU load threshold (3) breached: 11.71 [waiting 2]
[2024-11-29 04:40:01] [index:background] Health check
[2024-11-29 04:40:01] [index:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 04:40:03] [indexer:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 04:43:02] [indexer:background] Health check
[2024-11-29 04:43:02] [indexer:background] CPU load threshold (3) breached: 9.69 [waiting 2]
[2024-11-29 04:44:51] [index:background] Health check
[2024-11-29 04:44:51] [index:background] CPU load threshold (3) breached: 8.5 [waiting 2]
[2024-11-29 04:44:53] [indexer:background] CPU load threshold (3) breached: 8.5 [waiting 2]
[2024-11-29 04:45:15] [query] Query for: search_term_string
[2024-11-29 04:45:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 7 offset: 0 fields: all
[2024-11-29 04:45:15] [query] Engine: default
[2024-11-29 04:45:16] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 04:45:16] [query] Mods: 6
[2024-11-29 04:45:16] [query] Using OR logic
[2024-11-29 04:45:16] [query] Found results using: or logic
[2024-11-29 04:45:16] [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-11-29 04:45:16] [query] Results: 1382 Pages of results: 139
[2024-11-29 04:45:16] [query] Execution time: 0.82040
[2024-11-29 04:47:54] [indexer:background] Health check
[2024-11-29 04:47:54] [indexer:background] CPU load threshold (3) breached: 8.95 [waiting 2]
[2024-11-29 04:50:30] [index:background] Health check
[2024-11-29 04:50:30] [index:background] CPU load threshold (3) breached: 8.05 [waiting 2]
[2024-11-29 04:50:32] [indexer:background] CPU load threshold (3) breached: 8.05 [waiting 2]
[2024-11-29 04:51:48] [indexer:background] Health check
[2024-11-29 04:51:48] [indexer:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 04:54:38] [index:background] Health check
[2024-11-29 04:54:38] [index:background] CPU load threshold (3) breached: 7.96 [waiting 2]
[2024-11-29 04:54:40] [indexer:background] CPU load threshold (3) breached: 7.96 [waiting 2]
[2024-11-29 04:56:47] [indexer:background] Health check
[2024-11-29 04:56:47] [indexer:background] CPU load threshold (3) breached: 7.94 [waiting 2]
[2024-11-29 04:59:38] [index:background] Health check
[2024-11-29 04:59:38] [index:background] CPU load threshold (3) breached: 7.94 [waiting 2]
[2024-11-29 04:59:40] [indexer:background] CPU load threshold (3) breached: 7.94 [waiting 2]
[2024-11-29 05:01:48] [indexer:background] Health check
[2024-11-29 05:01:48] [indexer:background] CPU load threshold (3) breached: 8.21 [waiting 2]
[2024-11-29 05:04:37] [index:background] Health check
[2024-11-29 05:04:37] [index:background] CPU load threshold (3) breached: 7.53 [waiting 2]
[2024-11-29 05:04:39] [indexer:background] CPU load threshold (3) breached: 7.53 [waiting 2]
[2024-11-29 05:06:48] [indexer:background] Health check
[2024-11-29 05:06:48] [indexer:background] CPU load threshold (3) breached: 8.29 [waiting 2]
[2024-11-29 05:09:37] [index:background] Health check
[2024-11-29 05:09:37] [index:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 05:09:39] [indexer:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 05:11:47] [indexer:background] Health check
[2024-11-29 05:11:48] [indexer:background] CPU load threshold (3) breached: 8.82 [waiting 2]
[2024-11-29 05:14:38] [index:background] Health check
[2024-11-29 05:14:38] [index:background] CPU load threshold (3) breached: 8.86 [waiting 2]
[2024-11-29 05:14:40] [indexer:background] CPU load threshold (3) breached: 8.86 [waiting 2]
[2024-11-29 05:17:48] [indexer:background] Health check
[2024-11-29 05:17:48] [indexer:background] CPU load threshold (3) breached: 6.97 [waiting 2]
[2024-11-29 05:20:30] [index:background] Health check
[2024-11-29 05:20:30] [index:background] CPU load threshold (3) breached: 8.24 [waiting 2]
[2024-11-29 05:20:32] [indexer:background] CPU load threshold (3) breached: 8.3 [waiting 2]
[2024-11-29 05:21:15] [query] Query for: search_term_string
[2024-11-29 05:21:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 124 offset: 0 fields: all
[2024-11-29 05:21:15] [query] Engine: default
[2024-11-29 05:21:16] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 05:21:16] [query] Mods: 6
[2024-11-29 05:21:16] [query] Using OR logic
[2024-11-29 05:21:16] [query] Found results using: or logic
[2024-11-29 05:21:16] [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 1230, 10
[2024-11-29 05:21:16] [query] Results: 1382 Pages of results: 139
[2024-11-29 05:21:16] [query] Execution time: 0.88716
[2024-11-29 05:21:49] [indexer:background] Health check
[2024-11-29 05:21:49] [indexer:background] CPU load threshold (3) breached: 7.74 [waiting 2]
[2024-11-29 05:24:40] [index:background] Health check
[2024-11-29 05:24:40] [index:background] CPU load threshold (3) breached: 7.63 [waiting 2]
[2024-11-29 05:24:42] [indexer:background] CPU load threshold (3) breached: 7.74 [waiting 2]
[2024-11-29 05:28:06] [indexer:background] Health check
[2024-11-29 05:28:06] [indexer:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-11-29 05:29:51] [index:background] Health check
[2024-11-29 05:29:51] [index:background] CPU load threshold (3) breached: 7.21 [waiting 2]
[2024-11-29 05:29:53] [indexer:background] CPU load threshold (3) breached: 7.51 [waiting 2]
[2024-11-29 05:32:23] [indexer:background] Health check
[2024-11-29 05:32:23] [indexer:background] CPU load threshold (3) breached: 8.47 [waiting 2]
[2024-11-29 05:34:37] [index:background] Health check
[2024-11-29 05:34:37] [index:background] CPU load threshold (3) breached: 10.43 [waiting 2]
[2024-11-29 05:34:39] [indexer:background] CPU load threshold (3) breached: 10.43 [waiting 2]
[2024-11-29 05:37:22] [indexer:background] Health check
[2024-11-29 05:37:22] [indexer:background] CPU load threshold (3) breached: 8.54 [waiting 2]
[2024-11-29 05:39:37] [index:background] Health check
[2024-11-29 05:39:37] [index:background] CPU load threshold (3) breached: 7.8 [waiting 2]
[2024-11-29 05:39:40] [indexer:background] CPU load threshold (3) breached: 7.8 [waiting 2]
[2024-11-29 05:42:23] [indexer:background] Health check
[2024-11-29 05:42:23] [indexer:background] CPU load threshold (3) breached: 8.81 [waiting 2]
[2024-11-29 05:46:00] [index:background] Health check
[2024-11-29 05:46:00] [index:background] CPU load threshold (3) breached: 7.11 [waiting 2]
[2024-11-29 05:46:03] [indexer:background] CPU load threshold (3) breached: 7.1 [waiting 2]
[2024-11-29 05:47:05] [indexer:background] Health check
[2024-11-29 05:47:05] [indexer:background] CPU load threshold (3) breached: 6.45 [waiting 2]
[2024-11-29 05:51:16] [index:background] Health check
[2024-11-29 05:51:16] [index:background] CPU load threshold (3) breached: 8.38 [waiting 2]
[2024-11-29 05:51:18] [indexer:background] CPU load threshold (3) breached: 8.19 [waiting 2]
[2024-11-29 05:52:02] [indexer:background] Health check
[2024-11-29 05:52:02] [indexer:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 05:54:42] [index:background] Health check
[2024-11-29 05:54:42] [index:background] CPU load threshold (3) breached: 8.43 [waiting 2]
[2024-11-29 05:54:44] [indexer:background] CPU load threshold (3) breached: 8.16 [waiting 2]
[2024-11-29 05:58:07] [indexer:background] Health check
[2024-11-29 05:58:07] [indexer:background] CPU load threshold (3) breached: 7.94 [waiting 2]
[2024-11-29 05:59:38] [index:background] Health check
[2024-11-29 05:59:38] [index:background] CPU load threshold (3) breached: 8.15 [waiting 2]
[2024-11-29 05:59:40] [indexer:background] CPU load threshold (3) breached: 8.14 [waiting 2]
[2024-11-29 06:03:15] [indexer:background] Health check
[2024-11-29 06:03:15] [indexer:background] CPU load threshold (3) breached: 9.06 [waiting 2]
[2024-11-29 06:05:27] [index:background] Health check
[2024-11-29 06:05:27] [index:background] CPU load threshold (3) breached: 8.24 [waiting 2]
[2024-11-29 06:05:29] [indexer:background] CPU load threshold (3) breached: 8.38 [waiting 2]
[2024-11-29 06:06:52] [indexer:background] Health check
[2024-11-29 06:06:52] [indexer:background] CPU load threshold (3) breached: 9.13 [waiting 2]
[2024-11-29 06:10:37] [index:background] Health check
[2024-11-29 06:10:37] [index:background] CPU load threshold (3) breached: 9.07 [waiting 2]
[2024-11-29 06:10:40] [indexer:background] CPU load threshold (3) breached: 9.15 [waiting 2]
[2024-11-29 06:12:01] [indexer:background] Health check
[2024-11-29 06:12:01] [indexer:background] CPU load threshold (3) breached: 9.17 [waiting 2]
[2024-11-29 06:14:38] [index:background] Health check
[2024-11-29 06:14:38] [index:background] CPU load threshold (3) breached: 9.13 [waiting 2]
[2024-11-29 06:14:40] [indexer:background] CPU load threshold (3) breached: 8.88 [waiting 2]
[2024-11-29 06:17:29] [indexer:background] Health check
[2024-11-29 06:17:30] [indexer:background] CPU load threshold (3) breached: 8.42 [waiting 2]
[2024-11-29 06:19:53] [index:background] Health check
[2024-11-29 06:19:53] [index:background] CPU load threshold (3) breached: 9.33 [waiting 2]
[2024-11-29 06:19:55] [indexer:background] CPU load threshold (3) breached: 9.14 [waiting 2]
[2024-11-29 06:21:14] [query] Query for: search_term_string
[2024-11-29 06:21:14] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 123 offset: 0 fields: all
[2024-11-29 06:21:14] [query] Engine: default
[2024-11-29 06:21:14] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 06:21:14] [query] Mods: 6
[2024-11-29 06:21:14] [query] Using OR logic
[2024-11-29 06:21:15] [query] Found results using: or logic
[2024-11-29 06:21:15] [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 1220, 10
[2024-11-29 06:21:15] [query] Results: 1382 Pages of results: 139
[2024-11-29 06:21:15] [query] Execution time: 0.76886
[2024-11-29 06:22:08] [indexer:background] Health check
[2024-11-29 06:22:09] [indexer:background] CPU load threshold (3) breached: 8.02 [waiting 2]
[2024-11-29 06:25:09] [index:background] Health check
[2024-11-29 06:25:09] [index:background] CPU load threshold (3) breached: 10.05 [waiting 2]
[2024-11-29 06:25:11] [indexer:background] CPU load threshold (3) breached: 10.05 [waiting 2]
[2024-11-29 06:26:56] [indexer:background] Health check
[2024-11-29 06:26:57] [indexer:background] CPU load threshold (3) breached: 9.73 [waiting 2]
[2024-11-29 06:30:00] [index:background] Health check
[2024-11-29 06:30:00] [index:background] CPU load threshold (3) breached: 9.54 [waiting 2]
[2024-11-29 06:30:02] [indexer:background] CPU load threshold (3) breached: 9.54 [waiting 2]
[2024-11-29 06:33:43] [indexer:background] Health check
[2024-11-29 06:33:43] [indexer:background] CPU load threshold (3) breached: 14.28 [waiting 2]
[2024-11-29 06:36:25] [index:background] Health check
[2024-11-29 06:36:25] [index:background] CPU load threshold (3) breached: 11.64 [waiting 2]
[2024-11-29 06:36:27] [indexer:background] CPU load threshold (3) breached: 11.64 [waiting 2]
[2024-11-29 06:37:09] [indexer:background] Health check
[2024-11-29 06:37:09] [indexer:background] CPU load threshold (3) breached: 11.04 [waiting 2]
[2024-11-29 06:39:38] [index:background] Health check
[2024-11-29 06:39:38] [index:background] CPU load threshold (3) breached: 10.38 [waiting 2]
[2024-11-29 06:39:40] [indexer:background] CPU load threshold (3) breached: 10.38 [waiting 2]
[2024-11-29 06:41:52] [indexer:background] Health check
[2024-11-29 06:41:52] [indexer:background] CPU load threshold (3) breached: 9.78 [waiting 2]
[2024-11-29 06:44:43] [index:background] Health check
[2024-11-29 06:44:43] [index:background] CPU load threshold (3) breached: 8.91 [waiting 2]
[2024-11-29 06:44:45] [indexer:background] CPU load threshold (3) breached: 8.91 [waiting 2]
[2024-11-29 06:47:11] [indexer:background] Health check
[2024-11-29 06:47:12] [indexer:background] CPU load threshold (3) breached: 9.51 [waiting 2]
[2024-11-29 06:49:49] [index:background] Health check
[2024-11-29 06:49:49] [index:background] CPU load threshold (3) breached: 9.52 [waiting 2]
[2024-11-29 06:49:51] [indexer:background] CPU load threshold (3) breached: 9.32 [waiting 2]
[2024-11-29 06:52:02] [indexer:background] Health check
[2024-11-29 06:52:02] [indexer:background] CPU load threshold (3) breached: 9.87 [waiting 2]
[2024-11-29 06:54:50] [index:background] Health check
[2024-11-29 06:54:50] [index:background] CPU load threshold (3) breached: 9.83 [waiting 2]
[2024-11-29 06:54:52] [indexer:background] CPU load threshold (3) breached: 10.25 [waiting 2]
[2024-11-29 06:57:16] [indexer:background] Health check
[2024-11-29 06:57:16] [indexer:background] CPU load threshold (3) breached: 8.26 [waiting 2]
[2024-11-29 06:59:45] [index:background] Health check
[2024-11-29 06:59:45] [index:background] CPU load threshold (3) breached: 8.18 [waiting 2]
[2024-11-29 06:59:47] [indexer:background] CPU load threshold (3) breached: 7.92 [waiting 2]
[2024-11-29 07:02:07] [indexer:background] Health check
[2024-11-29 07:02:07] [indexer:background] CPU load threshold (3) breached: 9.86 [waiting 2]
[2024-11-29 07:05:42] [index:background] Health check
[2024-11-29 07:05:42] [index:background] CPU load threshold (3) breached: 8.21 [waiting 2]
[2024-11-29 07:05:45] [indexer:background] CPU load threshold (3) breached: 8.21 [waiting 2]
[2024-11-29 07:06:47] [indexer:background] Health check
[2024-11-29 07:06:47] [indexer:background] CPU load threshold (3) breached: 7.76 [waiting 2]
[2024-11-29 07:10:11] [index:background] Health check
[2024-11-29 07:10:11] [index:background] CPU load threshold (3) breached: 9.13 [waiting 2]
[2024-11-29 07:10:13] [indexer:background] CPU load threshold (3) breached: 13.93 [waiting 2]
[2024-11-29 07:12:17] [indexer:background] Health check
[2024-11-29 07:12:18] [indexer:background] CPU load threshold (3) breached: 22.26 [waiting 2]
[2024-11-29 07:15:06] [index:background] Health check
[2024-11-29 07:15:06] [index:background] CPU load threshold (3) breached: 40.3 [waiting 2]
[2024-11-29 07:15:08] [indexer:background] CPU load threshold (3) breached: 39.23 [waiting 2]
[2024-11-29 07:17:12] [indexer:background] Health check
[2024-11-29 07:17:12] [indexer:background] CPU load threshold (3) breached: 42.81 [waiting 2]
[2024-11-29 07:21:13] [index:background] Health check
[2024-11-29 07:21:13] [index:background] CPU load threshold (3) breached: 43.3 [waiting 2]
[2024-11-29 07:21:15] [indexer:background] CPU load threshold (3) breached: 43.3 [waiting 2]
[2024-11-29 07:22:58] [indexer:background] Health check
[2024-11-29 07:22:58] [indexer:background] CPU load threshold (3) breached: 22.46 [waiting 2]
[2024-11-29 07:24:54] [index:background] Health check
[2024-11-29 07:24:54] [index:background] CPU load threshold (3) breached: 15.41 [waiting 2]
[2024-11-29 07:24:56] [indexer:background] CPU load threshold (3) breached: 15.41 [waiting 2]
[2024-11-29 07:27:29] [indexer:background] Health check
[2024-11-29 07:27:30] [indexer:background] CPU load threshold (3) breached: 18.43 [waiting 2]
[2024-11-29 07:29:51] [index:background] Health check
[2024-11-29 07:29:51] [index:background] CPU load threshold (3) breached: 18.36 [waiting 2]
[2024-11-29 07:29:53] [indexer:background] CPU load threshold (3) breached: 18.09 [waiting 2]
[2024-11-29 07:33:12] [indexer:background] Health check
[2024-11-29 07:33:12] [indexer:background] CPU load threshold (3) breached: 15.65 [waiting 2]
[2024-11-29 07:34:52] [index:background] Health check
[2024-11-29 07:34:52] [index:background] CPU load threshold (3) breached: 13.57 [waiting 2]
[2024-11-29 07:34:54] [indexer:background] CPU load threshold (3) breached: 13.21 [waiting 2]
[2024-11-29 07:36:47] [indexer:background] Health check
[2024-11-29 07:36:47] [indexer:background] CPU load threshold (3) breached: 9.67 [waiting 2]
[2024-11-29 07:40:53] [index:background] Health check
[2024-11-29 07:40:53] [index:background] CPU load threshold (3) breached: 9.87 [waiting 2]
[2024-11-29 07:40:55] [indexer:background] CPU load threshold (3) breached: 9.87 [waiting 2]
[2024-11-29 07:43:49] [indexer:background] Health check
[2024-11-29 07:43:49] [indexer:background] CPU load threshold (3) breached: 9.33 [waiting 2]
[2024-11-29 07:45:17] [index:background] Health check
[2024-11-29 07:45:17] [index:background] CPU load threshold (3) breached: 9.57 [waiting 2]
[2024-11-29 07:45:19] [indexer:background] CPU load threshold (3) breached: 9.44 [waiting 2]
[2024-11-29 07:46:51] [indexer:background] Health check
[2024-11-29 07:46:51] [indexer:background] CPU load threshold (3) breached: 9.25 [waiting 2]
[2024-11-29 07:50:01] [index:background] Health check
[2024-11-29 07:50:01] [index:background] CPU load threshold (3) breached: 10.05 [waiting 2]
[2024-11-29 07:50:03] [indexer:background] CPU load threshold (3) breached: 10.05 [waiting 2]
[2024-11-29 07:52:55] [indexer:background] Health check
[2024-11-29 07:52:55] [indexer:background] CPU load threshold (3) breached: 8.78 [waiting 2]
[2024-11-29 07:55:59] [index:background] Health check
[2024-11-29 07:55:59] [index:background] CPU load threshold (3) breached: 8.57 [waiting 2]
[2024-11-29 07:56:01] [indexer:background] CPU load threshold (3) breached: 8.57 [waiting 2]
[2024-11-29 07:58:09] [indexer:background] Health check
[2024-11-29 07:58:09] [indexer:background] CPU load threshold (3) breached: 7.05 [waiting 2]
[2024-11-29 08:00:51] [index:background] Health check
[2024-11-29 08:00:51] [index:background] CPU load threshold (3) breached: 7.36 [waiting 2]
[2024-11-29 08:00:53] [indexer:background] CPU load threshold (3) breached: 7.36 [waiting 2]
[2024-11-29 08:03:06] [indexer:background] Health check
[2024-11-29 08:03:06] [indexer:background] CPU load threshold (3) breached: 8.2 [waiting 2]
[2024-11-29 08:04:38] [index:background] Health check
[2024-11-29 08:04:38] [index:background] CPU load threshold (3) breached: 6.43 [waiting 2]
[2024-11-29 08:04:40] [indexer:background] CPU load threshold (3) breached: 6.16 [waiting 2]
[2024-11-29 08:07:52] [indexer:background] Health check
[2024-11-29 08:07:52] [indexer:background] CPU load threshold (3) breached: 6.19 [waiting 2]
[2024-11-29 08:09:59] [index:background] Health check
[2024-11-29 08:09:59] [index:background] CPU load threshold (3) breached: 7.51 [waiting 2]
[2024-11-29 08:10:01] [indexer:background] CPU load threshold (3) breached: 7.14 [waiting 2]
[2024-11-29 08:12:04] [indexer:background] Health check
[2024-11-29 08:12:04] [indexer:background] CPU load threshold (3) breached: 7.39 [waiting 2]
[2024-11-29 08:14:46] [index:background] Health check
[2024-11-29 08:14:46] [index:background] CPU load threshold (3) breached: 7.18 [waiting 2]
[2024-11-29 08:14:48] [indexer:background] CPU load threshold (3) breached: 7.18 [waiting 2]
[2024-11-29 08:16:58] [indexer:background] Health check
[2024-11-29 08:16:58] [indexer:background] CPU load threshold (3) breached: 8.99 [waiting 2]
[2024-11-29 08:20:03] [index:background] Health check
[2024-11-29 08:20:03] [index:background] CPU load threshold (3) breached: 7.65 [waiting 2]
[2024-11-29 08:20:06] [indexer:background] CPU load threshold (3) breached: 7.91 [waiting 2]
[2024-11-29 08:22:04] [indexer:background] Health check
[2024-11-29 08:22:04] [indexer:background] CPU load threshold (3) breached: 7.89 [waiting 2]
[2024-11-29 08:25:01] [index:background] Health check
[2024-11-29 08:25:01] [index:background] CPU load threshold (3) breached: 8.49 [waiting 2]
[2024-11-29 08:25:03] [indexer:background] CPU load threshold (3) breached: 8.49 [waiting 2]
[2024-11-29 08:28:31] [indexer:background] Health check
[2024-11-29 08:28:31] [indexer:background] CPU load threshold (3) breached: 7.33 [waiting 2]
[2024-11-29 08:29:52] [index:background] Health check
[2024-11-29 08:29:52] [index:background] CPU load threshold (3) breached: 7.58 [waiting 2]
[2024-11-29 08:29:54] [indexer:background] CPU load threshold (3) breached: 7.58 [waiting 2]
[2024-11-29 08:32:32] [indexer:background] Health check
[2024-11-29 08:32:33] [indexer:background] CPU load threshold (3) breached: 7.44 [waiting 2]
[2024-11-29 08:35:35] [index:background] Health check
[2024-11-29 08:35:35] [index:background] CPU load threshold (3) breached: 6.43 [waiting 2]
[2024-11-29 08:35:38] [indexer:background] CPU load threshold (3) breached: 6.43 [waiting 2]
[2024-11-29 08:38:00] [indexer:background] Health check
[2024-11-29 08:38:00] [indexer:background] CPU load threshold (3) breached: 7.32 [waiting 2]
[2024-11-29 08:39:56] [index:background] Health check
[2024-11-29 08:39:56] [index:background] CPU load threshold (3) breached: 7.47 [waiting 2]
[2024-11-29 08:39:58] [indexer:background] CPU load threshold (3) breached: 7.47 [waiting 2]
[2024-11-29 08:42:12] [indexer:background] Health check
[2024-11-29 08:42:12] [indexer:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 08:46:12] [index:background] Health check
[2024-11-29 08:46:12] [index:background] CPU load threshold (3) breached: 8.26 [waiting 2]
[2024-11-29 08:46:14] [indexer:background] CPU load threshold (3) breached: 8.26 [waiting 2]
[2024-11-29 08:46:47] [indexer:background] Health check
[2024-11-29 08:46:47] [indexer:background] CPU load threshold (3) breached: 7.04 [waiting 2]
[2024-11-29 08:49:38] [index:background] Health check
[2024-11-29 08:49:38] [index:background] CPU load threshold (3) breached: 8.57 [waiting 2]
[2024-11-29 08:49:40] [indexer:background] CPU load threshold (3) breached: 8.57 [waiting 2]
[2024-11-29 08:52:05] [indexer:background] Health check
[2024-11-29 08:52:05] [indexer:background] CPU load threshold (3) breached: 12.21 [waiting 2]
[2024-11-29 08:55:22] [index:background] Health check
[2024-11-29 08:55:22] [index:background] CPU load threshold (3) breached: 11.34 [waiting 2]
[2024-11-29 08:55:24] [indexer:background] CPU load threshold (3) breached: 11.34 [waiting 2]
[2024-11-29 08:56:54] [indexer:background] Health check
[2024-11-29 08:56:54] [indexer:background] CPU load threshold (3) breached: 8.74 [waiting 2]
[2024-11-29 08:59:39] [index:background] Health check
[2024-11-29 08:59:39] [index:background] CPU load threshold (3) breached: 8.15 [waiting 2]
[2024-11-29 08:59:41] [indexer:background] CPU load threshold (3) breached: 8.15 [waiting 2]
[2024-11-29 09:01:55] [indexer:background] Health check
[2024-11-29 09:01:55] [indexer:background] CPU load threshold (3) breached: 8.31 [waiting 2]
[2024-11-29 09:04:50] [index:background] Health check
[2024-11-29 09:04:50] [index:background] CPU load threshold (3) breached: 8.52 [waiting 2]
[2024-11-29 09:04:52] [indexer:background] CPU load threshold (3) breached: 8.24 [waiting 2]
[2024-11-29 09:07:00] [indexer:background] Health check
[2024-11-29 09:07:00] [indexer:background] CPU load threshold (3) breached: 7.9 [waiting 2]
[2024-11-29 09:09:40] [index:background] Health check
[2024-11-29 09:09:40] [index:background] CPU load threshold (3) breached: 7.69 [waiting 2]
[2024-11-29 09:09:42] [indexer:background] CPU load threshold (3) breached: 7.69 [waiting 2]
[2024-11-29 09:12:02] [indexer:background] Health check
[2024-11-29 09:12:02] [indexer:background] CPU load threshold (3) breached: 9.25 [waiting 2]
[2024-11-29 09:12:30] [index] Marking post.attachment 16746 to be dropped
[2024-11-29 09:12:32] [index] Dropping post.attachment 16746
[2024-11-29 09:12:32] [index:background] CPU load threshold (3) breached: 8.22 [waiting 2]
[2024-11-29 09:12:34] [indexer] Queued next batch (1)
[2024-11-29 09:12:34] [indexer:background] CPU load threshold (3) breached: 8.21 [waiting 2]
[2024-11-29 09:12:38] [indexer] Processing batch (1)
[2024-11-29 09:12:38] [indexer] Indexing post.attachment:16746
[2024-11-29 09:12:39] [index] Marking [1] post.attachment 16746 as indexed
[2024-11-29 09:12:39] [indexer] Index built
[2024-11-29 09:12:39] [indexer:background] CPU load threshold (3) breached: 8.03 [waiting 2]
[2024-11-29 09:14:40] [index:background] Health check
[2024-11-29 09:14:40] [index:background] CPU load threshold (3) breached: 9.04 [waiting 2]
[2024-11-29 09:14:42] [indexer:background] CPU load threshold (3) breached: 9.04 [waiting 2]
[2024-11-29 09:16:49] [indexer:background] Health check
[2024-11-29 09:16:49] [indexer] Queued next batch (1)
[2024-11-29 09:16:49] [indexer:background] CPU load threshold (3) breached: 9.27 [waiting 2]
[2024-11-29 09:16:53] [indexer] Processing batch (1)
[2024-11-29 09:16:53] [indexer] Indexing post.attachment:16747
[2024-11-29 09:16:53] [index] Marking [1] post.attachment 16747 as indexed
[2024-11-29 09:16:53] [indexer] Index built
[2024-11-29 09:16:53] [indexer:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 09:19:44] [index:background] Health check
[2024-11-29 09:19:44] [index:background] CPU load threshold (3) breached: 7.42 [waiting 2]
[2024-11-29 09:19:47] [indexer:background] CPU load threshold (3) breached: 7.42 [waiting 2]
[2024-11-29 09:21:49] [indexer:background] Health check
[2024-11-29 09:21:49] [indexer:background] CPU load threshold (3) breached: 7.44 [waiting 2]
[2024-11-29 09:24:52] [index:background] Health check
[2024-11-29 09:24:52] [index:background] CPU load threshold (3) breached: 11.61 [waiting 2]
[2024-11-29 09:24:54] [indexer:background] CPU load threshold (3) breached: 11.48 [waiting 2]
[2024-11-29 09:26:46] [indexer:background] Health check
[2024-11-29 09:26:46] [indexer] Queued next batch (1)
[2024-11-29 09:26:46] [indexer:background] CPU load threshold (3) breached: 10.9 [waiting 2]
[2024-11-29 09:26:50] [indexer] Processing batch (1)
[2024-11-29 09:26:50] [indexer] Indexing post.attachment:16749
[2024-11-29 09:26:50] [index] Marking [1] post.attachment 16749 as indexed
[2024-11-29 09:26:50] [indexer] Index built
[2024-11-29 09:26:50] [indexer:background] CPU load threshold (3) breached: 10.99 [waiting 2]
[2024-11-29 09:27:23] [query] Query for: search_term_string
[2024-11-29 09:27:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 122 offset: 0 fields: all
[2024-11-29 09:27:23] [query] Engine: default
[2024-11-29 09:27:24] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 09:27:24] [query] Mods: 6
[2024-11-29 09:27:24] [query] Using OR logic
[2024-11-29 09:27:24] [query] Found results using: or logic
[2024-11-29 09:27:24] [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 1210, 10
[2024-11-29 09:27:24] [query] Results: 1382 Pages of results: 139
[2024-11-29 09:27:24] [query] Execution time: 0.99775
[2024-11-29 09:30:03] [index:background] Health check
[2024-11-29 09:30:03] [index:background] CPU load threshold (3) breached: 8.31 [waiting 2]
[2024-11-29 09:30:05] [indexer:background] CPU load threshold (3) breached: 8.31 [waiting 2]
[2024-11-29 09:32:12] [indexer:background] Health check
[2024-11-29 09:32:12] [indexer:background] CPU load threshold (3) breached: 9.41 [waiting 2]
[2024-11-29 09:36:05] [index:background] Health check
[2024-11-29 09:36:05] [index:background] CPU load threshold (3) breached: 8.2 [waiting 2]
[2024-11-29 09:36:07] [indexer:background] CPU load threshold (3) breached: 8.2 [waiting 2]
[2024-11-29 09:36:49] [indexer:background] Health check
[2024-11-29 09:36:49] [indexer:background] CPU load threshold (3) breached: 8.68 [waiting 2]
[2024-11-29 09:39:41] [index:background] Health check
[2024-11-29 09:39:41] [index:background] CPU load threshold (3) breached: 7.72 [waiting 2]
[2024-11-29 09:39:43] [indexer:background] CPU load threshold (3) breached: 7.72 [waiting 2]
[2024-11-29 09:41:55] [indexer:background] Health check
[2024-11-29 09:41:55] [indexer] Queued next batch (1)
[2024-11-29 09:41:55] [indexer:background] CPU load threshold (3) breached: 9.45 [waiting 2]
[2024-11-29 09:42:00] [indexer] Processing batch (1)
[2024-11-29 09:42:00] [indexer] Indexing post.attachment:16754
[2024-11-29 09:42:00] [index] Marking [1] post.attachment 16754 as indexed
[2024-11-29 09:42:00] [indexer] Index built
[2024-11-29 09:42:00] [indexer:background] CPU load threshold (3) breached: 9.33 [waiting 2]
[2024-11-29 09:44:53] [index:background] Health check
[2024-11-29 09:44:53] [index:background] CPU load threshold (3) breached: 11.29 [waiting 2]
[2024-11-29 09:44:55] [indexer:background] CPU load threshold (3) breached: 11.99 [waiting 2]
[2024-11-29 09:46:49] [indexer:background] Health check
[2024-11-29 09:46:49] [indexer:background] CPU load threshold (3) breached: 13.97 [waiting 2]
[2024-11-29 09:49:43] [index:background] Health check
[2024-11-29 09:49:43] [index:background] CPU load threshold (3) breached: 8.3 [waiting 2]
[2024-11-29 09:49:45] [indexer:background] CPU load threshold (3) breached: 8.19 [waiting 2]
[2024-11-29 09:51:55] [indexer:background] Health check
[2024-11-29 09:51:55] [indexer:background] CPU load threshold (3) breached: 8.46 [waiting 2]
[2024-11-29 09:54:39] [index:background] Health check
[2024-11-29 09:54:39] [index:background] CPU load threshold (3) breached: 8.05 [waiting 2]
[2024-11-29 09:54:41] [indexer:background] CPU load threshold (3) breached: 8.05 [waiting 2]
[2024-11-29 09:56:57] [indexer:background] Health check
[2024-11-29 09:56:57] [indexer:background] CPU load threshold (3) breached: 8.13 [waiting 2]
[2024-11-29 10:00:14] [index:background] Health check
[2024-11-29 10:00:14] [index:background] CPU load threshold (3) breached: 7.27 [waiting 2]
[2024-11-29 10:00:16] [indexer:background] CPU load threshold (3) breached: 7.33 [waiting 2]
[2024-11-29 10:03:23] [indexer:background] Health check
[2024-11-29 10:03:23] [indexer:background] CPU load threshold (3) breached: 9.1 [waiting 2]
[2024-11-29 10:04:39] [index:background] Health check
[2024-11-29 10:04:39] [index:background] CPU load threshold (3) breached: 9.29 [waiting 2]
[2024-11-29 10:04:41] [indexer:background] CPU load threshold (3) breached: 9.35 [waiting 2]
[2024-11-29 10:07:27] [indexer:background] Health check
[2024-11-29 10:07:27] [indexer:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 10:09:51] [index:background] Health check
[2024-11-29 10:09:51] [index:background] CPU load threshold (3) breached: 9.93 [waiting 2]
[2024-11-29 10:09:53] [indexer:background] CPU load threshold (3) breached: 9.93 [waiting 2]
[2024-11-29 10:12:02] [indexer:background] Health check
[2024-11-29 10:12:02] [indexer:background] CPU load threshold (3) breached: 8.38 [waiting 2]
[2024-11-29 10:14:57] [index:background] Health check
[2024-11-29 10:14:57] [index:background] CPU load threshold (3) breached: 8.41 [waiting 2]
[2024-11-29 10:14:59] [indexer:background] CPU load threshold (3) breached: 8.41 [waiting 2]
[2024-11-29 10:17:13] [indexer:background] Health check
[2024-11-29 10:17:13] [indexer:background] CPU load threshold (3) breached: 8.52 [waiting 2]
[2024-11-29 10:20:54] [index:background] Health check
[2024-11-29 10:20:54] [index:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 10:20:56] [indexer:background] CPU load threshold (3) breached: 9.04 [waiting 2]
[2024-11-29 10:21:49] [indexer:background] Health check
[2024-11-29 10:21:49] [indexer:background] CPU load threshold (3) breached: 8.56 [waiting 2]
[2024-11-29 10:24:50] [index:background] Health check
[2024-11-29 10:24:50] [index:background] CPU load threshold (3) breached: 9.5 [waiting 2]
[2024-11-29 10:24:52] [indexer:background] CPU load threshold (3) breached: 9.54 [waiting 2]
[2024-11-29 10:27:05] [indexer:background] Health check
[2024-11-29 10:27:05] [indexer:background] CPU load threshold (3) breached: 10.04 [waiting 2]
[2024-11-29 10:29:46] [index:background] Health check
[2024-11-29 10:29:46] [index:background] CPU load threshold (3) breached: 9.67 [waiting 2]
[2024-11-29 10:29:48] [indexer:background] CPU load threshold (3) breached: 9.67 [waiting 2]
[2024-11-29 10:33:19] [indexer:background] Health check
[2024-11-29 10:33:19] [indexer:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 10:35:08] [index:background] Health check
[2024-11-29 10:35:08] [index:background] CPU load threshold (3) breached: 8.77 [waiting 2]
[2024-11-29 10:35:10] [indexer:background] CPU load threshold (3) breached: 8.77 [waiting 2]
[2024-11-29 10:37:21] [indexer:background] Health check
[2024-11-29 10:37:21] [indexer:background] CPU load threshold (3) breached: 12.25 [waiting 2]
[2024-11-29 10:39:42] [index:background] Health check
[2024-11-29 10:39:42] [index:background] CPU load threshold (3) breached: 10.87 [waiting 2]
[2024-11-29 10:39:44] [indexer:background] CPU load threshold (3) breached: 10.87 [waiting 2]
[2024-11-29 10:41:12] [query] Query for: search_term_string
[2024-11-29 10:41:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 122 offset: 0 fields: all
[2024-11-29 10:41:12] [query] Engine: default
[2024-11-29 10:41:13] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 10:41:13] [query] Mods: 6
[2024-11-29 10:41:13] [query] Using OR logic
[2024-11-29 10:41:14] [query] Found results using: or logic
[2024-11-29 10:41: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 1210, 10
[2024-11-29 10:41:14] [query] Results: 1382 Pages of results: 139
[2024-11-29 10:41:14] [query] Execution time: 1.60366
[2024-11-29 10:42:02] [indexer:background] Health check
[2024-11-29 10:42:02] [indexer:background] CPU load threshold (3) breached: 9.65 [waiting 2]
[2024-11-29 10:45:11] [index:background] Health check
[2024-11-29 10:45:11] [index:background] CPU load threshold (3) breached: 9.71 [waiting 2]
[2024-11-29 10:45:13] [indexer:background] CPU load threshold (3) breached: 9.98 [waiting 2]
[2024-11-29 10:47:21] [indexer:background] Health check
[2024-11-29 10:47:21] [indexer:background] CPU load threshold (3) breached: 10.87 [waiting 2]
[2024-11-29 10:49:41] [index:background] Health check
[2024-11-29 10:49:41] [index:background] CPU load threshold (3) breached: 9.93 [waiting 2]
[2024-11-29 10:49:43] [indexer:background] CPU load threshold (3) breached: 9.86 [waiting 2]
[2024-11-29 10:51:15] [query] Query for: search_term_string
[2024-11-29 10:51:15] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 11 offset: 0 fields: all
[2024-11-29 10:51:15] [query] Engine: default
[2024-11-29 10:51:16] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 10:51:16] [query] Mods: 6
[2024-11-29 10:51:16] [query] Using OR logic
[2024-11-29 10:51:16] [query] Found results using: or logic
[2024-11-29 10:51:16] [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 100, 10
[2024-11-29 10:51:16] [query] Results: 1382 Pages of results: 139
[2024-11-29 10:51:16] [query] Execution time: 1.16687
[2024-11-29 10:51:47] [indexer:background] Health check
[2024-11-29 10:51:47] [indexer:background] CPU load threshold (3) breached: 10.28 [waiting 2]
[2024-11-29 10:55:09] [index:background] Health check
[2024-11-29 10:55:09] [index:background] CPU load threshold (3) breached: 10.17 [waiting 2]
[2024-11-29 10:55:11] [indexer:background] CPU load threshold (3) breached: 10.17 [waiting 2]
[2024-11-29 10:57:02] [indexer:background] Health check
[2024-11-29 10:57:02] [indexer:background] CPU load threshold (3) breached: 9.02 [waiting 2]
[2024-11-29 10:59:54] [index:background] Health check
[2024-11-29 10:59:54] [index:background] CPU load threshold (3) breached: 8.68 [waiting 2]
[2024-11-29 10:59:56] [indexer:background] CPU load threshold (3) breached: 8.68 [waiting 2]
[2024-11-29 11:02:34] [indexer:background] Health check
[2024-11-29 11:02:34] [indexer:background] CPU load threshold (3) breached: 10.6 [waiting 2]
[2024-11-29 11:05:03] [index:background] Health check
[2024-11-29 11:05:03] [index:background] CPU load threshold (3) breached: 9.65 [waiting 2]
[2024-11-29 11:05:05] [indexer:background] CPU load threshold (3) breached: 9.65 [waiting 2]
[2024-11-29 11:06:56] [indexer:background] Health check
[2024-11-29 11:06:56] [indexer:background] CPU load threshold (3) breached: 8.75 [waiting 2]
[2024-11-29 11:09:38] [index:background] Health check
[2024-11-29 11:09:38] [index:background] CPU load threshold (3) breached: 9.23 [waiting 2]
[2024-11-29 11:09:40] [indexer:background] CPU load threshold (3) breached: 9.29 [waiting 2]
[2024-11-29 11:12:00] [indexer:background] Health check
[2024-11-29 11:12:00] [indexer:background] CPU load threshold (3) breached: 8.83 [waiting 2]
[2024-11-29 11:15:43] [index:background] Health check
[2024-11-29 11:15:43] [index:background] CPU load threshold (3) breached: 10.18 [waiting 2]
[2024-11-29 11:15:45] [indexer:background] CPU load threshold (3) breached: 10.18 [waiting 2]
[2024-11-29 11:17:44] [indexer:background] Health check
[2024-11-29 11:17:44] [indexer:background] CPU load threshold (3) breached: 9.67 [waiting 2]
[2024-11-29 11:19:01] [query] Query for: search_term_string
[2024-11-29 11:19:01] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 13 offset: 0 fields: all
[2024-11-29 11:19:01] [query] Engine: default
[2024-11-29 11:19:02] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 11:19:02] [query] Mods: 6
[2024-11-29 11:19:02] [query] Using OR logic
[2024-11-29 11:19:02] [query] Found results using: or logic
[2024-11-29 11:19:02] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 120, 10
[2024-11-29 11:19:02] [query] Results: 1382 Pages of results: 139
[2024-11-29 11:19:02] [query] Execution time: 1.04406
[2024-11-29 11:20:30] [index:background] Health check
[2024-11-29 11:20:30] [index:background] CPU load threshold (3) breached: 9.57 [waiting 2]
[2024-11-29 11:20:32] [indexer:background] CPU load threshold (3) breached: 9.57 [waiting 2]
[2024-11-29 11:21:53] [indexer:background] Health check
[2024-11-29 11:21:53] [indexer:background] CPU load threshold (3) breached: 8.88 [waiting 2]
[2024-11-29 11:26:07] [index:background] Health check
[2024-11-29 11:26:07] [index:background] CPU load threshold (3) breached: 9.4 [waiting 2]
[2024-11-29 11:26:09] [indexer:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 11:27:06] [indexer:background] Health check
[2024-11-29 11:27:06] [indexer:background] CPU load threshold (3) breached: 12.01 [waiting 2]
[2024-11-29 11:29:54] [index:background] Health check
[2024-11-29 11:29:54] [index:background] CPU load threshold (3) breached: 10.01 [waiting 2]
[2024-11-29 11:29:56] [indexer:background] CPU load threshold (3) breached: 10.01 [waiting 2]
[2024-11-29 11:32:15] [indexer:background] Health check
[2024-11-29 11:32:15] [indexer:background] CPU load threshold (3) breached: 10.63 [waiting 2]
[2024-11-29 11:34:58] [index:background] Health check
[2024-11-29 11:34:58] [index:background] CPU load threshold (3) breached: 9.38 [waiting 2]
[2024-11-29 11:35:00] [indexer:background] CPU load threshold (3) breached: 9.43 [waiting 2]
[2024-11-29 11:36:48] [indexer:background] Health check
[2024-11-29 11:36:48] [indexer:background] CPU load threshold (3) breached: 9.26 [waiting 2]
[2024-11-29 11:41:30] [index:background] Health check
[2024-11-29 11:41:30] [index:background] CPU load threshold (3) breached: 8.87 [waiting 2]
[2024-11-29 11:41:32] [indexer:background] CPU load threshold (3) breached: 8.87 [waiting 2]
[2024-11-29 11:41:50] [indexer:background] Health check
[2024-11-29 11:41:50] [indexer:background] CPU load threshold (3) breached: 8.49 [waiting 2]
[2024-11-29 11:43:55] [query] Query for: 2025
[2024-11-29 11:43:55] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 3 offset: 0 fields: all
[2024-11-29 11:43:55] [query] Engine: default
[2024-11-29 11:43:56] [query] Tokens: 2025
[2024-11-29 11:43:56] [query] Mods: 6
[2024-11-29 11:43:56] [query] Found results using: or logic
[2024-11-29 11:43:56] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 20, 10
[2024-11-29 11:43:56] [query] Results: 166 Pages of results: 17
[2024-11-29 11:43:56] [query] Execution time: 0.53508
[2024-11-29 11:45:01] [index:background] Health check
[2024-11-29 11:45:01] [index:background] CPU load threshold (3) breached: 10.24 [waiting 2]
[2024-11-29 11:45:03] [indexer:background] CPU load threshold (3) breached: 10.24 [waiting 2]
[2024-11-29 11:46:49] [indexer:background] Health check
[2024-11-29 11:46:50] [indexer:background] CPU load threshold (3) breached: 10.52 [waiting 2]
[2024-11-29 11:50:31] [index:background] Health check
[2024-11-29 11:50:31] [index:background] CPU load threshold (3) breached: 16.99 [waiting 2]
[2024-11-29 11:50:33] [indexer:background] CPU load threshold (3) breached: 16.99 [waiting 2]
[2024-11-29 11:51:50] [indexer:background] Health check
[2024-11-29 11:51:51] [indexer:background] CPU load threshold (3) breached: 11.87 [waiting 2]
[2024-11-29 11:55:10] [query] Query for: search_term_string
[2024-11-29 11:55:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 9 offset: 0 fields: all
[2024-11-29 11:55:10] [query] Engine: default
[2024-11-29 11:55:10] [index:background] Health check
[2024-11-29 11:55:10] [index:background] CPU load threshold (3) breached: 10.77 [waiting 2]
[2024-11-29 11:55:10] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 11:55:10] [query] Mods: 6
[2024-11-29 11:55:10] [query] Using OR logic
[2024-11-29 11:55:11] [query] Found results using: or logic
[2024-11-29 11:55:11] [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 80, 10
[2024-11-29 11:55:11] [query] Results: 1382 Pages of results: 139
[2024-11-29 11:55:11] [query] Execution time: 0.91137
[2024-11-29 11:55:12] [indexer:background] CPU load threshold (3) breached: 10.77 [waiting 2]
[2024-11-29 11:56:53] [indexer:background] Health check
[2024-11-29 11:56:53] [indexer:background] CPU load threshold (3) breached: 10.43 [waiting 2]
[2024-11-29 12:00:05] [index:background] Health check
[2024-11-29 12:00:05] [index:background] CPU load threshold (3) breached: 15.49 [waiting 2]
[2024-11-29 12:00:07] [indexer:background] CPU load threshold (3) breached: 15.49 [waiting 2]
[2024-11-29 12:03:08] [indexer:background] Health check
[2024-11-29 12:03:08] [indexer:background] CPU load threshold (3) breached: 10.19 [waiting 2]
[2024-11-29 12:05:02] [index:background] Health check
[2024-11-29 12:05:02] [index:background] CPU load threshold (3) breached: 10 [waiting 2]
[2024-11-29 12:05:04] [indexer:background] CPU load threshold (3) breached: 10 [waiting 2]
[2024-11-29 12:08:10] [indexer:background] Health check
[2024-11-29 12:08:11] [indexer:background] CPU load threshold (3) breached: 9.48 [waiting 2]
[2024-11-29 12:10:36] [index:background] Health check
[2024-11-29 12:10:36] [index:background] CPU load threshold (3) breached: 9.71 [waiting 2]
[2024-11-29 12:10:38] [indexer:background] CPU load threshold (3) breached: 9.71 [waiting 2]
[2024-11-29 12:11:56] [indexer:background] Health check
[2024-11-29 12:11:56] [indexer:background] CPU load threshold (3) breached: 10.35 [waiting 2]
[2024-11-29 12:14:57] [query] Query for: 2025
[2024-11-29 12:14:57] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 17 offset: 0 fields: all
[2024-11-29 12:14:57] [query] Engine: default
[2024-11-29 12:14:57] [index:background] Health check
[2024-11-29 12:14:57] [index:background] CPU load threshold (3) breached: 9.58 [waiting 2]
[2024-11-29 12:14:57] [query] Tokens: 2025
[2024-11-29 12:14:57] [query] Mods: 6
[2024-11-29 12:14:57] [query] Found results using: or logic
[2024-11-29 12:14: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 160, 10
[2024-11-29 12:14:57] [query] Results: 166 Pages of results: 17
[2024-11-29 12:14:57] [query] Execution time: 0.30363
[2024-11-29 12:14:59] [indexer:background] CPU load threshold (3) breached: 9.58 [waiting 2]
[2024-11-29 12:17:41] [indexer:background] Health check
[2024-11-29 12:17:41] [indexer:background] CPU load threshold (3) breached: 8.77 [waiting 2]
[2024-11-29 12:18:10] [query] Query for: search_term_string
[2024-11-29 12:18:10] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 13 offset: 0 fields: all
[2024-11-29 12:18:10] [query] Engine: default
[2024-11-29 12:18:10] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 12:18:10] [query] Mods: 6
[2024-11-29 12:18:10] [query] Using OR logic
[2024-11-29 12:18:10] [query] Found results using: or logic
[2024-11-29 12:18:10] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 120, 10
[2024-11-29 12:18:10] [query] Results: 1382 Pages of results: 139
[2024-11-29 12:18:10] [query] Execution time: 0.83375
[2024-11-29 12:21:17] [index:background] Health check
[2024-11-29 12:21:17] [index:background] CPU load threshold (3) breached: 8.68 [waiting 2]
[2024-11-29 12:21:19] [indexer:background] CPU load threshold (3) breached: 8.68 [waiting 2]
[2024-11-29 12:22:08] [indexer:background] Health check
[2024-11-29 12:22:08] [indexer:background] CPU load threshold (3) breached: 8.63 [waiting 2]
[2024-11-29 12:24:41] [index:background] Health check
[2024-11-29 12:24:41] [index:background] CPU load threshold (3) breached: 7.97 [waiting 2]
[2024-11-29 12:24:43] [indexer:background] CPU load threshold (3) breached: 7.98 [waiting 2]
[2024-11-29 12:27:52] [indexer:background] Health check
[2024-11-29 12:27:52] [indexer:background] CPU load threshold (3) breached: 8.31 [waiting 2]
[2024-11-29 12:29:56] [index:background] Health check
[2024-11-29 12:29:56] [index:background] CPU load threshold (3) breached: 8.11 [waiting 2]
[2024-11-29 12:29:58] [indexer:background] CPU load threshold (3) breached: 10.42 [waiting 2]
[2024-11-29 12:32:25] [indexer:background] Health check
[2024-11-29 12:32:25] [indexer:background] CPU load threshold (3) breached: 11.7 [waiting 2]
[2024-11-29 12:35:58] [index:background] Health check
[2024-11-29 12:35:58] [index:background] CPU load threshold (3) breached: 10.51 [waiting 2]
[2024-11-29 12:36:00] [indexer:background] CPU load threshold (3) breached: 10.51 [waiting 2]
[2024-11-29 12:37:24] [indexer:background] Health check
[2024-11-29 12:37:24] [indexer:background] CPU load threshold (3) breached: 10.12 [waiting 2]
[2024-11-29 12:40:02] [index:background] Health check
[2024-11-29 12:40:02] [index:background] CPU load threshold (3) breached: 10.61 [waiting 2]
[2024-11-29 12:40:04] [indexer:background] CPU load threshold (3) breached: 11.52 [waiting 2]
[2024-11-29 12:41:47] [indexer:background] Health check
[2024-11-29 12:41:47] [indexer:background] CPU load threshold (3) breached: 11.11 [waiting 2]
[2024-11-29 12:44:38] [index:background] Health check
[2024-11-29 12:44:38] [index:background] CPU load threshold (3) breached: 11.95 [waiting 2]
[2024-11-29 12:44:40] [indexer:background] CPU load threshold (3) breached: 11.95 [waiting 2]
[2024-11-29 12:49:00] [indexer:background] Health check
[2024-11-29 12:49:00] [indexer:background] CPU load threshold (3) breached: 9.45 [waiting 2]
[2024-11-29 12:49:50] [index:background] Health check
[2024-11-29 12:49:50] [index:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 12:49:52] [indexer:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 12:52:14] [indexer:background] Health check
[2024-11-29 12:52:14] [indexer:background] CPU load threshold (3) breached: 13.68 [waiting 2]
[2024-11-29 12:54:45] [index:background] Health check
[2024-11-29 12:54:45] [index:background] CPU load threshold (3) breached: 9.71 [waiting 2]
[2024-11-29 12:54:47] [indexer:background] CPU load threshold (3) breached: 9.71 [waiting 2]
[2024-11-29 12:58:33] [indexer:background] Health check
[2024-11-29 12:58:33] [indexer:background] CPU load threshold (3) breached: 9.31 [waiting 2]
[2024-11-29 13:00:05] [index:background] Health check
[2024-11-29 13:00:05] [index:background] CPU load threshold (3) breached: 9.25 [waiting 2]
[2024-11-29 13:00:07] [indexer:background] CPU load threshold (3) breached: 9.25 [waiting 2]
[2024-11-29 13:03:02] [indexer:background] Health check
[2024-11-29 13:03:02] [indexer:background] CPU load threshold (3) breached: 10.78 [waiting 2]
[2024-11-29 13:04:40] [index:background] Health check
[2024-11-29 13:04:40] [index:background] CPU load threshold (3) breached: 9.24 [waiting 2]
[2024-11-29 13:04:43] [indexer:background] CPU load threshold (3) breached: 9.24 [waiting 2]
[2024-11-29 13:07:07] [indexer:background] Health check
[2024-11-29 13:07:07] [indexer:background] CPU load threshold (3) breached: 10.45 [waiting 2]
[2024-11-29 13:10:54] [index:background] Health check
[2024-11-29 13:10:54] [index:background] CPU load threshold (3) breached: 9.81 [waiting 2]
[2024-11-29 13:10:56] [indexer:background] CPU load threshold (3) breached: 9.81 [waiting 2]
[2024-11-29 13:12:11] [indexer:background] Health check
[2024-11-29 13:12:11] [indexer:background] CPU load threshold (3) breached: 8.24 [waiting 2]
[2024-11-29 13:14:42] [index:background] Health check
[2024-11-29 13:14:42] [index:background] CPU load threshold (3) breached: 8.33 [waiting 2]
[2024-11-29 13:14:44] [indexer:background] CPU load threshold (3) breached: 8.06 [waiting 2]
[2024-11-29 13:17:50] [indexer:background] Health check
[2024-11-29 13:17:50] [indexer:background] CPU load threshold (3) breached: 8.89 [waiting 2]
[2024-11-29 13:19:49] [index:background] Health check
[2024-11-29 13:19:49] [index:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 13:19:52] [indexer:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 13:22:28] [indexer:background] Health check
[2024-11-29 13:22:28] [indexer:background] CPU load threshold (3) breached: 7.18 [waiting 2]
[2024-11-29 13:24:57] [index:background] Health check
[2024-11-29 13:24:57] [index:background] CPU load threshold (3) breached: 6.8 [waiting 2]
[2024-11-29 13:24:59] [indexer:background] CPU load threshold (3) breached: 6.8 [waiting 2]
[2024-11-29 13:26:47] [indexer:background] Health check
[2024-11-29 13:26:47] [indexer:background] CPU load threshold (3) breached: 7.87 [waiting 2]
[2024-11-29 13:30:18] [index:background] Health check
[2024-11-29 13:30:18] [index:background] CPU load threshold (3) breached: 10.03 [waiting 2]
[2024-11-29 13:30:21] [indexer:background] CPU load threshold (3) breached: 10.11 [waiting 2]
[2024-11-29 13:32:10] [indexer:background] Health check
[2024-11-29 13:32:10] [indexer:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 13:34:39] [index:background] Health check
[2024-11-29 13:34:39] [index:background] CPU load threshold (3) breached: 9.46 [waiting 2]
[2024-11-29 13:34:41] [indexer:background] CPU load threshold (3) breached: 9.18 [waiting 2]
[2024-11-29 13:37:49] [indexer:background] Health check
[2024-11-29 13:37:49] [indexer:background] CPU load threshold (3) breached: 9.5 [waiting 2]
[2024-11-29 13:40:29] [index:background] Health check
[2024-11-29 13:40:29] [index:background] CPU load threshold (3) breached: 10.35 [waiting 2]
[2024-11-29 13:40:31] [indexer:background] CPU load threshold (3) breached: 10.16 [waiting 2]
[2024-11-29 13:42:04] [indexer:background] Health check
[2024-11-29 13:42:04] [indexer:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 13:46:54] [index:background] Health check
[2024-11-29 13:46:54] [index:background] CPU load threshold (3) breached: 21.12 [waiting 2]
[2024-11-29 13:46:56] [indexer:background] CPU load threshold (3) breached: 20.23 [waiting 2]
[2024-11-29 13:46:58] [indexer:background] Health check
[2024-11-29 13:46:58] [indexer:background] CPU load threshold (3) breached: 20.23 [waiting 2]
[2024-11-29 13:47:00] [indexer:background] Health check
[2024-11-29 13:47:00] [indexer:background] CPU load threshold (3) breached: 20.23 [waiting 2]
[2024-11-29 13:50:12] [index:background] Health check
[2024-11-29 13:50:12] [index:background] CPU load threshold (3) breached: 14.6 [waiting 2]
[2024-11-29 13:50:14] [indexer:background] CPU load threshold (3) breached: 14.6 [waiting 2]
[2024-11-29 13:51:55] [indexer:background] Health check
[2024-11-29 13:51:55] [indexer:background] CPU load threshold (3) breached: 12.09 [waiting 2]
[2024-11-29 13:54:46] [index:background] Health check
[2024-11-29 13:54:46] [index:background] CPU load threshold (3) breached: 9.95 [waiting 2]
[2024-11-29 13:54:48] [indexer:background] CPU load threshold (3) breached: 10.44 [waiting 2]
[2024-11-29 13:56:56] [indexer:background] Health check
[2024-11-29 13:56:56] [indexer:background] CPU load threshold (3) breached: 10.2 [waiting 2]
[2024-11-29 13:56:57] [query] Query for: search_term_string
[2024-11-29 13:56:57] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 10 offset: 0 fields: all
[2024-11-29 13:56:57] [query] Engine: default
[2024-11-29 13:56:57] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 13:56:57] [query] Mods: 6
[2024-11-29 13:56:57] [query] Using OR logic
[2024-11-29 13:56:58] [query] Found results using: or logic
[2024-11-29 13:56:58] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 90, 10
[2024-11-29 13:56:58] [query] Results: 1382 Pages of results: 139
[2024-11-29 13:56:58] [query] Execution time: 1.35635
[2024-11-29 14:02:51] [index:background] Health check
[2024-11-29 14:02:51] [index:background] CPU load threshold (3) breached: 7.79 [waiting 2]
[2024-11-29 14:02:53] [indexer:background] CPU load threshold (3) breached: 7.79 [waiting 2]
[2024-11-29 14:02:55] [indexer:background] Health check
[2024-11-29 14:02:55] [indexer:background] CPU load threshold (3) breached: 7.79 [waiting 2]
[2024-11-29 14:02:57] [indexer:background] Health check
[2024-11-29 14:02:57] [indexer:background] CPU load threshold (3) breached: 8.05 [waiting 2]
[2024-11-29 14:04:48] [index:background] Health check
[2024-11-29 14:04:48] [index:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 14:04:50] [indexer:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 14:06:58] [indexer:background] Health check
[2024-11-29 14:06:59] [indexer:background] CPU load threshold (3) breached: 8.59 [waiting 2]
[2024-11-29 14:10:01] [index:background] Health check
[2024-11-29 14:10:01] [index:background] CPU load threshold (3) breached: 15.17 [waiting 2]
[2024-11-29 14:10:03] [indexer:background] CPU load threshold (3) breached: 14.67 [waiting 2]
[2024-11-29 14:12:00] [indexer:background] Health check
[2024-11-29 14:12:00] [indexer:background] CPU load threshold (3) breached: 14.05 [waiting 2]
[2024-11-29 14:15:02] [index:background] Health check
[2024-11-29 14:15:02] [index:background] CPU load threshold (3) breached: 11.44 [waiting 2]
[2024-11-29 14:15:04] [indexer:background] CPU load threshold (3) breached: 11.44 [waiting 2]
[2024-11-29 14:17:12] [indexer:background] Health check
[2024-11-29 14:17:13] [indexer:background] CPU load threshold (3) breached: 9.39 [waiting 2]
[2024-11-29 14:20:05] [index:background] Health check
[2024-11-29 14:20:05] [index:background] CPU load threshold (3) breached: 9.73 [waiting 2]
[2024-11-29 14:20:07] [indexer:background] CPU load threshold (3) breached: 9.73 [waiting 2]
[2024-11-29 14:22:07] [indexer:background] Health check
[2024-11-29 14:22:07] [indexer:background] CPU load threshold (3) breached: 9.53 [waiting 2]
[2024-11-29 14:24:52] [index:background] Health check
[2024-11-29 14:24:52] [index:background] CPU load threshold (3) breached: 9.05 [waiting 2]
[2024-11-29 14:24:54] [indexer:background] CPU load threshold (3) breached: 9.05 [waiting 2]
[2024-11-29 14:27:04] [indexer:background] Health check
[2024-11-29 14:27:04] [indexer:background] CPU load threshold (3) breached: 10.09 [waiting 2]
[2024-11-29 14:29:44] [index:background] Health check
[2024-11-29 14:29:44] [index:background] CPU load threshold (3) breached: 9.06 [waiting 2]
[2024-11-29 14:29:47] [indexer:background] CPU load threshold (3) breached: 9.06 [waiting 2]
[2024-11-29 14:32:34] [indexer:background] Health check
[2024-11-29 14:32:34] [indexer:background] CPU load threshold (3) breached: 8.19 [waiting 2]
[2024-11-29 14:34:07] [query] Query for: search_term_string
[2024-11-29 14:34:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 14 offset: 0 fields: all
[2024-11-29 14:34:07] [query] Engine: default
[2024-11-29 14:34:07] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 14:34:07] [query] Mods: 6
[2024-11-29 14:34:07] [query] Using OR logic
[2024-11-29 14:34:08] [query] Found results using: or logic
[2024-11-29 14:34:08] [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 130, 10
[2024-11-29 14:34:08] [query] Results: 1382 Pages of results: 139
[2024-11-29 14:34:08] [query] Execution time: 0.87900
[2024-11-29 14:35:23] [index:background] Health check
[2024-11-29 14:35:23] [index:background] CPU load threshold (3) breached: 7.16 [waiting 2]
[2024-11-29 14:35:25] [indexer:background] CPU load threshold (3) breached: 7.16 [waiting 2]
[2024-11-29 14:37:04] [indexer:background] Health check
[2024-11-29 14:37:04] [indexer:background] CPU load threshold (3) breached: 10.54 [waiting 2]
[2024-11-29 14:40:09] [index:background] Health check
[2024-11-29 14:40:09] [index:background] CPU load threshold (3) breached: 7.9 [waiting 2]
[2024-11-29 14:40:11] [indexer:background] CPU load threshold (3) breached: 7.9 [waiting 2]
[2024-11-29 14:41:48] [indexer:background] Health check
[2024-11-29 14:41:48] [indexer:background] CPU load threshold (3) breached: 9.65 [waiting 2]
[2024-11-29 14:44:44] [index:background] Health check
[2024-11-29 14:44:44] [index:background] CPU load threshold (3) breached: 8.91 [waiting 2]
[2024-11-29 14:44:46] [indexer:background] CPU load threshold (3) breached: 8.91 [waiting 2]
[2024-11-29 14:46:48] [indexer:background] Health check
[2024-11-29 14:46:48] [indexer:background] CPU load threshold (3) breached: 9.85 [waiting 2]
[2024-11-29 14:49:50] [index:background] Health check
[2024-11-29 14:49:50] [index:background] CPU load threshold (3) breached: 7.55 [waiting 2]
[2024-11-29 14:49:52] [indexer:background] CPU load threshold (3) breached: 7.55 [waiting 2]
[2024-11-29 14:51:54] [indexer:background] Health check
[2024-11-29 14:51:55] [indexer:background] CPU load threshold (3) breached: 6.71 [waiting 2]
[2024-11-29 14:54:05] [query] Query for: search_term_string
[2024-11-29 14:54:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 11 offset: 0 fields: all
[2024-11-29 14:54:05] [query] Engine: default
[2024-11-29 14:54:06] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 14:54:06] [query] Mods: 6
[2024-11-29 14:54:06] [query] Using OR logic
[2024-11-29 14:54:06] [query] Found results using: or logic
[2024-11-29 14:54:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 100, 10
[2024-11-29 14:54:06] [query] Results: 1382 Pages of results: 139
[2024-11-29 14:54:06] [query] Execution time: 0.81092
[2024-11-29 14:55:07] [index:background] Health check
[2024-11-29 14:55:07] [index:background] CPU load threshold (3) breached: 7.53 [waiting 2]
[2024-11-29 14:55:09] [indexer:background] CPU load threshold (3) breached: 7.56 [waiting 2]
[2024-11-29 14:56:49] [indexer:background] Health check
[2024-11-29 14:56:49] [indexer:background] CPU load threshold (3) breached: 7.96 [waiting 2]
[2024-11-29 14:59:39] [index:background] Health check
[2024-11-29 14:59:39] [index:background] CPU load threshold (3) breached: 8.09 [waiting 2]
[2024-11-29 14:59:41] [indexer:background] CPU load threshold (3) breached: 7.93 [waiting 2]
[2024-11-29 15:01:57] [indexer:background] Health check
[2024-11-29 15:01:57] [indexer:background] CPU load threshold (3) breached: 7.87 [waiting 2]
[2024-11-29 15:05:31] [index:background] Health check
[2024-11-29 15:05:31] [index:background] CPU load threshold (3) breached: 8.67 [waiting 2]
[2024-11-29 15:05:33] [indexer:background] CPU load threshold (3) breached: 8.67 [waiting 2]
[2024-11-29 15:07:12] [indexer:background] Health check
[2024-11-29 15:07:12] [indexer:background] CPU load threshold (3) breached: 7.35 [waiting 2]
[2024-11-29 15:10:29] [index:background] Health check
[2024-11-29 15:10:29] [index:background] CPU load threshold (3) breached: 7.11 [waiting 2]
[2024-11-29 15:10:31] [indexer:background] CPU load threshold (3) breached: 8.79 [waiting 2]
[2024-11-29 15:12:07] [indexer:background] Health check
[2024-11-29 15:12:07] [indexer:background] CPU load threshold (3) breached: 7.94 [waiting 2]
[2024-11-29 15:15:35] [index:background] Health check
[2024-11-29 15:15:35] [index:background] CPU load threshold (3) breached: 8.3 [waiting 2]
[2024-11-29 15:15:37] [indexer:background] CPU load threshold (3) breached: 8.3 [waiting 2]
[2024-11-29 15:17:13] [indexer:background] Health check
[2024-11-29 15:17:13] [indexer:background] CPU load threshold (3) breached: 9.15 [waiting 2]
[2024-11-29 15:20:18] [index:background] Health check
[2024-11-29 15:20:18] [index:background] CPU load threshold (3) breached: 9.16 [waiting 2]
[2024-11-29 15:20:20] [indexer:background] CPU load threshold (3) breached: 9.15 [waiting 2]
[2024-11-29 15:22:56] [indexer:background] Health check
[2024-11-29 15:22:56] [indexer:background] CPU load threshold (3) breached: 9.05 [waiting 2]
[2024-11-29 15:25:08] [index:background] Health check
[2024-11-29 15:25:08] [index:background] CPU load threshold (3) breached: 9 [waiting 2]
[2024-11-29 15:25:10] [indexer:background] CPU load threshold (3) breached: 9 [waiting 2]
[2024-11-29 15:27:48] [indexer:background] Health check
[2024-11-29 15:27:48] [indexer:background] CPU load threshold (3) breached: 9.35 [waiting 2]
[2024-11-29 15:30:01] [index:background] Health check
[2024-11-29 15:30:01] [index:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 15:30:03] [indexer:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 15:32:01] [indexer:background] Health check
[2024-11-29 15:32:01] [indexer:background] CPU load threshold (3) breached: 12 [waiting 2]
[2024-11-29 15:34:05] [query] Query for: search_term_string
[2024-11-29 15:34:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 120 offset: 0 fields: all
[2024-11-29 15:34:05] [query] Engine: default
[2024-11-29 15:34:06] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 15:34:06] [query] Mods: 6
[2024-11-29 15:34:06] [query] Using OR logic
[2024-11-29 15:34:06] [query] Found results using: or logic
[2024-11-29 15:34:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 1190, 10
[2024-11-29 15:34:06] [query] Results: 1382 Pages of results: 139
[2024-11-29 15:34:06] [query] Execution time: 0.82491
[2024-11-29 15:35:01] [index:background] Health check
[2024-11-29 15:35:01] [index:background] CPU load threshold (3) breached: 10.2 [waiting 2]
[2024-11-29 15:35:03] [indexer:background] CPU load threshold (3) breached: 10.2 [waiting 2]
[2024-11-29 15:38:58] [indexer:background] Health check
[2024-11-29 15:38:58] [indexer:background] CPU load threshold (3) breached: 8.8 [waiting 2]
[2024-11-29 15:42:19] [index:background] Health check
[2024-11-29 15:42:19] [index:background] CPU load threshold (3) breached: 9.07 [waiting 2]
[2024-11-29 15:42:21] [indexer:background] CPU load threshold (3) breached: 9.22 [waiting 2]
[2024-11-29 15:42:23] [indexer:background] Health check
[2024-11-29 15:42:23] [indexer:background] CPU load threshold (3) breached: 9.22 [waiting 2]
[2024-11-29 15:42:25] [indexer:background] Health check
[2024-11-29 15:42:25] [indexer:background] CPU load threshold (3) breached: 9.22 [waiting 2]
[2024-11-29 15:45:51] [index:background] Health check
[2024-11-29 15:45:51] [index:background] CPU load threshold (3) breached: 12.69 [waiting 2]
[2024-11-29 15:45:53] [indexer:background] CPU load threshold (3) breached: 12.69 [waiting 2]
[2024-11-29 15:46:53] [indexer:background] Health check
[2024-11-29 15:46:54] [indexer:background] CPU load threshold (3) breached: 9.59 [waiting 2]
[2024-11-29 15:49:38] [index:background] Health check
[2024-11-29 15:49:38] [index:background] CPU load threshold (3) breached: 9.96 [waiting 2]
[2024-11-29 15:49:40] [indexer:background] CPU load threshold (3) breached: 9.96 [waiting 2]
[2024-11-29 15:51:47] [indexer:background] Health check
[2024-11-29 15:51:47] [indexer:background] CPU load threshold (3) breached: 8.87 [waiting 2]
[2024-11-29 15:54:07] [query] Query for: search_term_string
[2024-11-29 15:54:07] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 121 offset: 0 fields: all
[2024-11-29 15:54:07] [query] Engine: default
[2024-11-29 15:54:07] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 15:54:07] [query] Mods: 6
[2024-11-29 15:54:07] [query] Using OR logic
[2024-11-29 15:54:07] [query] Found results using: or logic
[2024-11-29 15:54:07] [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 1200, 10
[2024-11-29 15:54:07] [query] Results: 1382 Pages of results: 139
[2024-11-29 15:54:07] [query] Execution time: 0.77327
[2024-11-29 15:55:48] [index:background] Health check
[2024-11-29 15:55:48] [index:background] CPU load threshold (3) breached: 12.06 [waiting 2]
[2024-11-29 15:55:50] [indexer:background] CPU load threshold (3) breached: 12.06 [waiting 2]
[2024-11-29 15:57:50] [indexer:background] Health check
[2024-11-29 15:57:50] [indexer:background] CPU load threshold (3) breached: 8.02 [waiting 2]
[2024-11-29 16:00:49] [index:background] Health check
[2024-11-29 16:00:49] [index:background] CPU load threshold (3) breached: 7.89 [waiting 2]
[2024-11-29 16:00:51] [indexer:background] CPU load threshold (3) breached: 7.89 [waiting 2]
[2024-11-29 16:01:56] [indexer:background] Health check
[2024-11-29 16:01:56] [indexer:background] CPU load threshold (3) breached: 9.02 [waiting 2]
[2024-11-29 16:05:02] [index:background] Health check
[2024-11-29 16:05:02] [index:background] CPU load threshold (3) breached: 8.31 [waiting 2]
[2024-11-29 16:05:04] [indexer:background] CPU load threshold (3) breached: 8.28 [waiting 2]
[2024-11-29 16:07:02] [indexer:background] Health check
[2024-11-29 16:07:02] [indexer:background] CPU load threshold (3) breached: 6.83 [waiting 2]
[2024-11-29 16:09:53] [index:background] Health check
[2024-11-29 16:09:53] [index:background] CPU load threshold (3) breached: 9.86 [waiting 2]
[2024-11-29 16:09:55] [indexer:background] CPU load threshold (3) breached: 9.86 [waiting 2]
[2024-11-29 16:12:00] [indexer:background] Health check
[2024-11-29 16:12:00] [indexer:background] CPU load threshold (3) breached: 8.87 [waiting 2]
[2024-11-29 16:14:48] [index:background] Health check
[2024-11-29 16:14:48] [index:background] CPU load threshold (3) breached: 10.99 [waiting 2]
[2024-11-29 16:14:50] [indexer:background] CPU load threshold (3) breached: 10.99 [waiting 2]
[2024-11-29 16:17:04] [indexer:background] Health check
[2024-11-29 16:17:04] [indexer:background] CPU load threshold (3) breached: 10.69 [waiting 2]
[2024-11-29 16:19:43] [index:background] Health check
[2024-11-29 16:19:43] [index:background] CPU load threshold (3) breached: 8.58 [waiting 2]
[2024-11-29 16:19:45] [indexer:background] CPU load threshold (3) breached: 8.58 [waiting 2]
[2024-11-29 16:22:14] [indexer:background] Health check
[2024-11-29 16:22:14] [indexer:background] CPU load threshold (3) breached: 8.02 [waiting 2]
[2024-11-29 16:25:03] [index:background] Health check
[2024-11-29 16:25:03] [index:background] CPU load threshold (3) breached: 8.36 [waiting 2]
[2024-11-29 16:25:05] [indexer:background] CPU load threshold (3) breached: 8.33 [waiting 2]
[2024-11-29 16:29:46] [indexer:background] Health check
[2024-11-29 16:29:46] [indexer:background] CPU load threshold (3) breached: 11.35 [waiting 2]
[2024-11-29 16:29:48] [index:background] Health check
[2024-11-29 16:29:48] [index:background] CPU load threshold (3) breached: 11.35 [waiting 2]
[2024-11-29 16:29:50] [indexer:background] CPU load threshold (3) breached: 11.56 [waiting 2]
[2024-11-29 16:31:47] [indexer:background] Health check
[2024-11-29 16:31:47] [indexer:background] CPU load threshold (3) breached: 9 [waiting 2]
[2024-11-29 16:34:08] [query] Query for: search_term_string
[2024-11-29 16:34:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 16 offset: 0 fields: all
[2024-11-29 16:34:08] [query] Engine: default
[2024-11-29 16:34:08] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 16:34:08] [query] Mods: 6
[2024-11-29 16:34:08] [query] Using OR logic
[2024-11-29 16:34:09] [query] Found results using: or logic
[2024-11-29 16:34:09] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 150, 10
[2024-11-29 16:34:09] [query] Results: 1382 Pages of results: 139
[2024-11-29 16:34:09] [query] Execution time: 0.94279
[2024-11-29 16:35:40] [index:background] Health check
[2024-11-29 16:35:40] [index:background] CPU load threshold (3) breached: 9.63 [waiting 2]
[2024-11-29 16:35:42] [indexer:background] CPU load threshold (3) breached: 9.63 [waiting 2]
[2024-11-29 16:37:24] [indexer:background] Health check
[2024-11-29 16:37:24] [indexer:background] CPU load threshold (3) breached: 7.54 [waiting 2]
[2024-11-29 16:40:43] [index:background] Health check
[2024-11-29 16:40:43] [index:background] CPU load threshold (3) breached: 9.14 [waiting 2]
[2024-11-29 16:40:45] [indexer:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 16:42:35] [indexer:background] Health check
[2024-11-29 16:42:35] [indexer:background] CPU load threshold (3) breached: 12.89 [waiting 2]
[2024-11-29 16:44:56] [index:background] Health check
[2024-11-29 16:44:56] [index:background] CPU load threshold (3) breached: 8.18 [waiting 2]
[2024-11-29 16:44:58] [indexer:background] CPU load threshold (3) breached: 8.18 [waiting 2]
[2024-11-29 16:47:04] [indexer:background] Health check
[2024-11-29 16:47:04] [indexer:background] CPU load threshold (3) breached: 12.13 [waiting 2]
[2024-11-29 16:49:57] [index:background] Health check
[2024-11-29 16:49:57] [index:background] CPU load threshold (3) breached: 8.91 [waiting 2]
[2024-11-29 16:49:59] [indexer:background] CPU load threshold (3) breached: 9.47 [waiting 2]
[2024-11-29 16:51:53] [indexer:background] Health check
[2024-11-29 16:51:53] [indexer:background] CPU load threshold (3) breached: 7.9 [waiting 2]
[2024-11-29 16:55:15] [index:background] Health check
[2024-11-29 16:55:15] [index:background] CPU load threshold (3) breached: 9.11 [waiting 2]
[2024-11-29 16:55:17] [indexer:background] CPU load threshold (3) breached: 9.11 [waiting 2]
[2024-11-29 16:56:38] [query] Query for: search_term_string
[2024-11-29 16:56:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 12 offset: 0 fields: all
[2024-11-29 16:56:38] [query] Engine: default
[2024-11-29 16:56:38] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 16:56:38] [query] Mods: 6
[2024-11-29 16:56:38] [query] Using OR logic
[2024-11-29 16:56:39] [query] Found results using: or logic
[2024-11-29 16:56: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 110, 10
[2024-11-29 16:56:39] [query] Results: 1382 Pages of results: 139
[2024-11-29 16:56:39] [query] Execution time: 0.72964
[2024-11-29 16:56:48] [indexer:background] Health check
[2024-11-29 16:56:48] [indexer:background] CPU load threshold (3) breached: 8.57 [waiting 2]
[2024-11-29 16:59:48] [index:background] Health check
[2024-11-29 16:59:48] [index:background] CPU load threshold (3) breached: 7.92 [waiting 2]
[2024-11-29 16:59:50] [indexer:background] CPU load threshold (3) breached: 8.17 [waiting 2]
[2024-11-29 17:01:53] [indexer:background] Health check
[2024-11-29 17:01:53] [indexer:background] CPU load threshold (3) breached: 9.23 [waiting 2]
[2024-11-29 17:04:48] [index:background] Health check
[2024-11-29 17:04:48] [index:background] CPU load threshold (3) breached: 8.92 [waiting 2]
[2024-11-29 17:04:51] [indexer:background] CPU load threshold (3) breached: 9.09 [waiting 2]
[2024-11-29 17:07:12] [indexer:background] Health check
[2024-11-29 17:07:12] [indexer:background] CPU load threshold (3) breached: 8.65 [waiting 2]
[2024-11-29 17:10:00] [index:background] Health check
[2024-11-29 17:10:00] [index:background] CPU load threshold (3) breached: 10.9 [waiting 2]
[2024-11-29 17:10:02] [indexer:background] CPU load threshold (3) breached: 10.98 [waiting 2]
[2024-11-29 17:12:44] [indexer:background] Health check
[2024-11-29 17:12:44] [indexer:background] CPU load threshold (3) breached: 11.9 [waiting 2]
[2024-11-29 17:14:55] [index:background] Health check
[2024-11-29 17:14:55] [index:background] CPU load threshold (3) breached: 11.2 [waiting 2]
[2024-11-29 17:14:57] [indexer:background] CPU load threshold (3) breached: 11.27 [waiting 2]
[2024-11-29 17:17:00] [indexer:background] Health check
[2024-11-29 17:17:00] [indexer:background] CPU load threshold (3) breached: 9.21 [waiting 2]
[2024-11-29 17:19:51] [index:background] Health check
[2024-11-29 17:19:51] [index:background] CPU load threshold (3) breached: 13.45 [waiting 2]
[2024-11-29 17:19:53] [indexer:background] CPU load threshold (3) breached: 13.89 [waiting 2]
[2024-11-29 17:22:58] [indexer:background] Health check
[2024-11-29 17:22:58] [indexer:background] CPU load threshold (3) breached: 13.66 [waiting 2]
[2024-11-29 17:25:37] [index:background] Health check
[2024-11-29 17:25:37] [index:background] CPU load threshold (3) breached: 14.73 [waiting 2]
[2024-11-29 17:25:39] [indexer:background] CPU load threshold (3) breached: 14.73 [waiting 2]
[2024-11-29 17:29:05] [indexer:background] Health check
[2024-11-29 17:29:05] [indexer:background] CPU load threshold (3) breached: 14.48 [waiting 2]
[2024-11-29 17:34:24] [index:background] Health check
[2024-11-29 17:34:24] [index:background] CPU load threshold (3) breached: 11.19 [waiting 2]
[2024-11-29 17:34:26] [indexer:background] CPU load threshold (3) breached: 11.01 [waiting 2]
[2024-11-29 17:34:29] [indexer:background] Health check
[2024-11-29 17:34:29] [indexer:background] CPU load threshold (3) breached: 11.01 [waiting 2]
[2024-11-29 17:34:31] [indexer:background] Health check
[2024-11-29 17:34:31] [indexer:background] CPU load threshold (3) breached: 11.01 [waiting 2]
[2024-11-29 17:34:51] [index:background] Health check
[2024-11-29 17:34:51] [index:background] CPU load threshold (3) breached: 10.65 [waiting 2]
[2024-11-29 17:34:53] [indexer:background] CPU load threshold (3) breached: 10.68 [waiting 2]
[2024-11-29 17:40:02] [indexer:background] Health check
[2024-11-29 17:40:02] [indexer:background] CPU load threshold (3) breached: 10.84 [waiting 2]
[2024-11-29 17:40:04] [index:background] Health check
[2024-11-29 17:40:04] [index:background] CPU load threshold (3) breached: 10.84 [waiting 2]
[2024-11-29 17:40:06] [indexer:background] CPU load threshold (3) breached: 10.84 [waiting 2]
[2024-11-29 17:41:37] [query] Query for: search_term_string
[2024-11-29 17:41:37] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 12 offset: 0 fields: all
[2024-11-29 17:41:37] [query] Engine: default
[2024-11-29 17:41:38] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 17:41:38] [query] Mods: 6
[2024-11-29 17:41:38] [query] Using OR logic
[2024-11-29 17:41:38] [query] Found results using: or logic
[2024-11-29 17:41:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 110, 10
[2024-11-29 17:41:38] [query] Results: 1382 Pages of results: 139
[2024-11-29 17:41:38] [query] Execution time: 0.74344
[2024-11-29 17:42:22] [indexer:background] Health check
[2024-11-29 17:42:22] [indexer:background] CPU load threshold (3) breached: 13.73 [waiting 2]
[2024-11-29 17:45:16] [index:background] Health check
[2024-11-29 17:45:16] [index:background] CPU load threshold (3) breached: 12.54 [waiting 2]
[2024-11-29 17:45:18] [indexer:background] CPU load threshold (3) breached: 12.57 [waiting 2]
[2024-11-29 17:47:30] [indexer:background] Health check
[2024-11-29 17:47:30] [indexer:background] CPU load threshold (3) breached: 11.76 [waiting 2]
[2024-11-29 17:49:52] [index:background] Health check
[2024-11-29 17:49:52] [index:background] CPU load threshold (3) breached: 11.88 [waiting 2]
[2024-11-29 17:49:54] [indexer:background] CPU load threshold (3) breached: 11.88 [waiting 2]
[2024-11-29 17:52:27] [indexer:background] Health check
[2024-11-29 17:52:27] [indexer:background] CPU load threshold (3) breached: 9.25 [waiting 2]
[2024-11-29 17:55:13] [index:background] Health check
[2024-11-29 17:55:13] [index:background] CPU load threshold (3) breached: 9.01 [waiting 2]
[2024-11-29 17:55:15] [indexer:background] CPU load threshold (3) breached: 9.01 [waiting 2]
[2024-11-29 17:57:13] [indexer:background] Health check
[2024-11-29 17:57:13] [indexer:background] CPU load threshold (3) breached: 11.69 [waiting 2]
[2024-11-29 17:59:52] [index:background] Health check
[2024-11-29 17:59:52] [index:background] CPU load threshold (3) breached: 10.97 [waiting 2]
[2024-11-29 17:59:54] [indexer:background] CPU load threshold (3) breached: 10.58 [waiting 2]
[2024-11-29 18:01:49] [indexer:background] Health check
[2024-11-29 18:01:49] [indexer:background] CPU load threshold (3) breached: 11.62 [waiting 2]
[2024-11-29 18:04:08] [query] Query for: search_term_string
[2024-11-29 18:04:08] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 121 offset: 0 fields: all
[2024-11-29 18:04:08] [query] Engine: default
[2024-11-29 18:04:08] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 18:04:08] [query] Mods: 6
[2024-11-29 18:04:08] [query] Using OR logic
[2024-11-29 18:04:09] [query] Found results using: or logic
[2024-11-29 18:04:09] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 1200, 10
[2024-11-29 18:04:09] [query] Results: 1382 Pages of results: 139
[2024-11-29 18:04:09] [query] Execution time: 0.89735
[2024-11-29 18:06:11] [index:background] Health check
[2024-11-29 18:06:11] [index:background] CPU load threshold (3) breached: 10.85 [waiting 2]
[2024-11-29 18:06:13] [indexer:background] CPU load threshold (3) breached: 11.03 [waiting 2]
[2024-11-29 18:09:52] [indexer:background] Health check
[2024-11-29 18:09:52] [indexer:background] CPU load threshold (3) breached: 10.88 [waiting 2]
[2024-11-29 18:09:54] [index:background] Health check
[2024-11-29 18:09:54] [index:background] CPU load threshold (3) breached: 10.57 [waiting 2]
[2024-11-29 18:09:56] [indexer:background] CPU load threshold (3) breached: 10.57 [waiting 2]
[2024-11-29 18:13:24] [indexer:background] Health check
[2024-11-29 18:13:24] [indexer:background] CPU load threshold (3) breached: 10.44 [waiting 2]
[2024-11-29 18:14:52] [index:background] Health check
[2024-11-29 18:14:52] [index:background] CPU load threshold (3) breached: 10.51 [waiting 2]
[2024-11-29 18:14:54] [indexer:background] CPU load threshold (3) breached: 10.14 [waiting 2]
[2024-11-29 18:17:02] [indexer:background] Health check
[2024-11-29 18:17:02] [indexer:background] CPU load threshold (3) breached: 11.42 [waiting 2]
[2024-11-29 18:20:03] [index:background] Health check
[2024-11-29 18:20:03] [index:background] CPU load threshold (3) breached: 12.8 [waiting 2]
[2024-11-29 18:20:05] [indexer:background] CPU load threshold (3) breached: 12.74 [waiting 2]
[2024-11-29 18:23:43] [indexer:background] Health check
[2024-11-29 18:23:43] [indexer:background] CPU load threshold (3) breached: 16.73 [waiting 2]
[2024-11-29 18:25:03] [index:background] Health check
[2024-11-29 18:25:03] [index:background] CPU load threshold (3) breached: 14.81 [waiting 2]
[2024-11-29 18:25:06] [indexer:background] CPU load threshold (3) breached: 14.59 [waiting 2]
[2024-11-29 18:27:11] [indexer:background] Health check
[2024-11-29 18:27:12] [indexer:background] CPU load threshold (3) breached: 12.06 [waiting 2]
[2024-11-29 18:29:55] [index:background] Health check
[2024-11-29 18:29:55] [index:background] CPU load threshold (3) breached: 12.1 [waiting 2]
[2024-11-29 18:29:57] [indexer:background] CPU load threshold (3) breached: 12.1 [waiting 2]
[2024-11-29 18:31:52] [indexer:background] Health check
[2024-11-29 18:31:52] [indexer:background] CPU load threshold (3) breached: 11.56 [waiting 2]
[2024-11-29 18:35:16] [index:background] Health check
[2024-11-29 18:35:16] [index:background] CPU load threshold (3) breached: 13.08 [waiting 2]
[2024-11-29 18:35:18] [indexer:background] CPU load threshold (3) breached: 13.08 [waiting 2]
[2024-11-29 18:37:35] [indexer:background] Health check
[2024-11-29 18:37:35] [indexer:background] CPU load threshold (3) breached: 10.86 [waiting 2]
[2024-11-29 18:39:47] [index:background] Health check
[2024-11-29 18:39:47] [index:background] CPU load threshold (3) breached: 12.79 [waiting 2]
[2024-11-29 18:39:49] [indexer:background] CPU load threshold (3) breached: 12.79 [waiting 2]
[2024-11-29 18:42:15] [indexer:background] Health check
[2024-11-29 18:42:15] [indexer:background] CPU load threshold (3) breached: 11.75 [waiting 2]
[2024-11-29 18:45:16] [index:background] Health check
[2024-11-29 18:45:16] [index:background] CPU load threshold (3) breached: 10.88 [waiting 2]
[2024-11-29 18:45:18] [indexer:background] CPU load threshold (3) breached: 10.88 [waiting 2]
[2024-11-29 18:47:02] [indexer:background] Health check
[2024-11-29 18:47:02] [indexer:background] CPU load threshold (3) breached: 11.36 [waiting 2]
[2024-11-29 18:50:02] [index:background] Health check
[2024-11-29 18:50:02] [index:background] CPU load threshold (3) breached: 11.73 [waiting 2]
[2024-11-29 18:50:04] [indexer:background] CPU load threshold (3) breached: 11.73 [waiting 2]
[2024-11-29 18:51:50] [indexer:background] Health check
[2024-11-29 18:51:50] [indexer:background] CPU load threshold (3) breached: 11.02 [waiting 2]
[2024-11-29 18:52:39] [query] Query for: search_term_string
[2024-11-29 18:52:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 14 offset: 0 fields: all
[2024-11-29 18:52:39] [query] Engine: default
[2024-11-29 18:52:39] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 18:52:39] [query] Mods: 6
[2024-11-29 18:52:39] [query] Using OR logic
[2024-11-29 18:52:39] [query] Found results using: or logic
[2024-11-29 18:52: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 130, 10
[2024-11-29 18:52:39] [query] Results: 1382 Pages of results: 139
[2024-11-29 18:52:39] [query] Execution time: 0.33310
[2024-11-29 18:55:49] [index:background] Health check
[2024-11-29 18:55:49] [index:background] CPU load threshold (3) breached: 11.17 [waiting 2]
[2024-11-29 18:55:51] [indexer:background] CPU load threshold (3) breached: 12.04 [waiting 2]
[2024-11-29 18:56:48] [indexer:background] Health check
[2024-11-29 18:56:48] [indexer:background] CPU load threshold (3) breached: 11.09 [waiting 2]
[2024-11-29 19:00:23] [query] Query for: search_term_string
[2024-11-29 19:00:23] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 13 offset: 0 fields: all
[2024-11-29 19:00:23] [query] Engine: default
[2024-11-29 19:00:23] [index:background] Health check
[2024-11-29 19:00:23] [index:background] CPU load threshold (3) breached: 10.48 [waiting 2]
[2024-11-29 19:00:23] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 19:00:23] [query] Mods: 6
[2024-11-29 19:00:23] [query] Using OR logic
[2024-11-29 19:00:23] [query] Found results using: or logic
[2024-11-29 19:00:23] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 120, 10
[2024-11-29 19:00:23] [query] Results: 1382 Pages of results: 139
[2024-11-29 19:00:23] [query] Execution time: 0.20845
[2024-11-29 19:00:25] [indexer:background] CPU load threshold (3) breached: 10.48 [waiting 2]
[2024-11-29 19:02:50] [indexer:background] Health check
[2024-11-29 19:02:50] [indexer:background] CPU load threshold (3) breached: 11.09 [waiting 2]
[2024-11-29 19:05:38] [index:background] Health check
[2024-11-29 19:05:38] [index:background] CPU load threshold (3) breached: 9.93 [waiting 2]
[2024-11-29 19:05:40] [indexer:background] CPU load threshold (3) breached: 9.93 [waiting 2]
[2024-11-29 19:10:19] [indexer:background] Health check
[2024-11-29 19:10:19] [indexer:background] CPU load threshold (3) breached: 11.21 [waiting 2]
[2024-11-29 19:10:21] [index:background] Health check
[2024-11-29 19:10:21] [index:background] CPU load threshold (3) breached: 10.88 [waiting 2]
[2024-11-29 19:10:23] [indexer:background] CPU load threshold (3) breached: 10.88 [waiting 2]
[2024-11-29 19:11:56] [indexer:background] Health check
[2024-11-29 19:11:56] [indexer:background] CPU load threshold (3) breached: 11.6 [waiting 2]
[2024-11-29 19:15:13] [index:background] Health check
[2024-11-29 19:15:13] [index:background] CPU load threshold (3) breached: 11.75 [waiting 2]
[2024-11-29 19:15:15] [indexer:background] CPU load threshold (3) breached: 11.75 [waiting 2]
[2024-11-29 19:17:11] [indexer:background] Health check
[2024-11-29 19:17:11] [indexer:background] CPU load threshold (3) breached: 12.55 [waiting 2]
[2024-11-29 19:19:44] [index:background] Health check
[2024-11-29 19:19:44] [index:background] CPU load threshold (3) breached: 11.7 [waiting 2]
[2024-11-29 19:19:46] [indexer:background] CPU load threshold (3) breached: 11.7 [waiting 2]
[2024-11-29 19:21:51] [indexer:background] Health check
[2024-11-29 19:21:51] [indexer:background] CPU load threshold (3) breached: 11.54 [waiting 2]
[2024-11-29 19:24:41] [index:background] Health check
[2024-11-29 19:24:41] [index:background] CPU load threshold (3) breached: 11.38 [waiting 2]
[2024-11-29 19:24:43] [indexer:background] CPU load threshold (3) breached: 11.11 [waiting 2]
[2024-11-29 19:27:10] [indexer:background] Health check
[2024-11-29 19:27:10] [indexer:background] CPU load threshold (3) breached: 10.35 [waiting 2]
[2024-11-29 19:29:41] [index:background] Health check
[2024-11-29 19:29:41] [index:background] CPU load threshold (3) breached: 9.8 [waiting 2]
[2024-11-29 19:29:43] [indexer:background] CPU load threshold (3) breached: 9.81 [waiting 2]
[2024-11-29 19:32:45] [indexer:background] Health check
[2024-11-29 19:32:45] [indexer:background] CPU load threshold (3) breached: 11.34 [waiting 2]
[2024-11-29 19:36:43] [index:background] Health check
[2024-11-29 19:36:43] [index:background] CPU load threshold (3) breached: 13.66 [waiting 2]
[2024-11-29 19:36:45] [indexer:background] CPU load threshold (3) breached: 13.66 [waiting 2]
[2024-11-29 19:36:55] [indexer:background] Health check
[2024-11-29 19:36:55] [indexer:background] CPU load threshold (3) breached: 13.01 [waiting 2]
[2024-11-29 19:39:47] [index:background] Health check
[2024-11-29 19:39:47] [index:background] CPU load threshold (3) breached: 10.52 [waiting 2]
[2024-11-29 19:39:50] [indexer:background] CPU load threshold (3) breached: 10.52 [waiting 2]
[2024-11-29 19:41:57] [indexer:background] Health check
[2024-11-29 19:41:57] [indexer:background] CPU load threshold (3) breached: 11.63 [waiting 2]
[2024-11-29 19:44:44] [index:background] Health check
[2024-11-29 19:44:44] [index:background] CPU load threshold (3) breached: 11.37 [waiting 2]
[2024-11-29 19:44:46] [indexer:background] CPU load threshold (3) breached: 11.37 [waiting 2]
[2024-11-29 19:45:29] [query] Query for: search_term_string
[2024-11-29 19:45:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 118 offset: 0 fields: all
[2024-11-29 19:45:29] [query] Engine: default
[2024-11-29 19:45:29] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 19:45:29] [query] Mods: 6
[2024-11-29 19:45:29] [query] Using OR logic
[2024-11-29 19:45:29] [query] Found results using: or logic
[2024-11-29 19:45: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 (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 1170, 10
[2024-11-29 19:45:29] [query] Results: 1382 Pages of results: 139
[2024-11-29 19:45:29] [query] Execution time: 0.72241
[2024-11-29 19:47:59] [indexer:background] Health check
[2024-11-29 19:47:59] [indexer:background] CPU load threshold (3) breached: 12.29 [waiting 2]
[2024-11-29 19:49:43] [index:background] Health check
[2024-11-29 19:49:43] [index:background] CPU load threshold (3) breached: 11.33 [waiting 2]
[2024-11-29 19:49:45] [indexer:background] CPU load threshold (3) breached: 11.38 [waiting 2]
[2024-11-29 19:53:15] [indexer:background] Health check
[2024-11-29 19:53:15] [indexer:background] CPU load threshold (3) breached: 10.99 [waiting 2]
[2024-11-29 19:55:02] [index:background] Health check
[2024-11-29 19:55:02] [index:background] CPU load threshold (3) breached: 9.96 [waiting 2]
[2024-11-29 19:55:04] [indexer:background] CPU load threshold (3) breached: 10.2 [waiting 2]
[2024-11-29 19:57:13] [indexer:background] Health check
[2024-11-29 19:57:13] [indexer:background] CPU load threshold (3) breached: 11.78 [waiting 2]
[2024-11-29 19:57:38] [query] Query for: search_term_string
[2024-11-29 19:57:38] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 119 offset: 0 fields: all
[2024-11-29 19:57:38] [query] Engine: default
[2024-11-29 19:57:38] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 19:57:38] [query] Mods: 6
[2024-11-29 19:57:38] [query] Using OR logic
[2024-11-29 19:57:38] [query] Found results using: or logic
[2024-11-29 19:57:38] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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 1180, 10
[2024-11-29 19:57:38] [query] Results: 1382 Pages of results: 139
[2024-11-29 19:57:38] [query] Execution time: 0.16694
[2024-11-29 19:59:57] [index:background] Health check
[2024-11-29 19:59:57] [index:background] CPU load threshold (3) breached: 10.27 [waiting 2]
[2024-11-29 19:59:59] [indexer:background] CPU load threshold (3) breached: 10.16 [waiting 2]
[2024-11-29 20:01:47] [indexer:background] Health check
[2024-11-29 20:01:48] [indexer:background] CPU load threshold (3) breached: 12.18 [waiting 2]
[2024-11-29 20:04:55] [index:background] Health check
[2024-11-29 20:04:55] [index:background] CPU load threshold (3) breached: 11.49 [waiting 2]
[2024-11-29 20:04:57] [indexer:background] CPU load threshold (3) breached: 11.49 [waiting 2]
[2024-11-29 20:07:01] [indexer:background] Health check
[2024-11-29 20:07:01] [indexer:background] CPU load threshold (3) breached: 10.94 [waiting 2]
[2024-11-29 20:10:23] [index:background] Health check
[2024-11-29 20:10:23] [index:background] CPU load threshold (3) breached: 11.58 [waiting 2]
[2024-11-29 20:10:25] [indexer:background] CPU load threshold (3) breached: 12.89 [waiting 2]
[2024-11-29 20:13:02] [indexer:background] Health check
[2024-11-29 20:13:02] [indexer:background] CPU load threshold (3) breached: 11.83 [waiting 2]
[2024-11-29 20:15:13] [index:background] Health check
[2024-11-29 20:15:13] [index:background] CPU load threshold (3) breached: 11.65 [waiting 2]
[2024-11-29 20:15:15] [indexer:background] CPU load threshold (3) breached: 11.84 [waiting 2]
[2024-11-29 20:17:14] [indexer:background] Health check
[2024-11-29 20:17:14] [indexer:background] CPU load threshold (3) breached: 9.54 [waiting 2]
[2024-11-29 20:19:43] [index:background] Health check
[2024-11-29 20:19:43] [index:background] CPU load threshold (3) breached: 10.37 [waiting 2]
[2024-11-29 20:19:45] [indexer:background] CPU load threshold (3) breached: 10.26 [waiting 2]
[2024-11-29 20:22:21] [indexer:background] Health check
[2024-11-29 20:22:21] [indexer:background] CPU load threshold (3) breached: 11.37 [waiting 2]
[2024-11-29 20:24:37] [index:background] Health check
[2024-11-29 20:24:37] [index:background] CPU load threshold (3) breached: 12.09 [waiting 2]
[2024-11-29 20:24:39] [indexer:background] CPU load threshold (3) breached: 12.09 [waiting 2]
[2024-11-29 20:24:52] [query] Query for: search_term_string
[2024-11-29 20:24:52] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 15 offset: 0 fields: all
[2024-11-29 20:24:52] [query] Engine: default
[2024-11-29 20:24:52] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 20:24:52] [query] Mods: 6
[2024-11-29 20:24:52] [query] Using OR logic
[2024-11-29 20:24:52] [query] Found results using: or logic
[2024-11-29 20:24:52] [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 140, 10
[2024-11-29 20:24:52] [query] Results: 1382 Pages of results: 139
[2024-11-29 20:24:52] [query] Execution time: 0.18863
[2024-11-29 20:27:49] [indexer:background] Health check
[2024-11-29 20:27:49] [indexer:background] CPU load threshold (3) breached: 10.37 [waiting 2]
[2024-11-29 20:29:37] [index:background] Health check
[2024-11-29 20:29:37] [index:background] CPU load threshold (3) breached: 11.43 [waiting 2]
[2024-11-29 20:29:39] [indexer:background] CPU load threshold (3) breached: 11.43 [waiting 2]
[2024-11-29 20:32:59] [indexer:background] Health check
[2024-11-29 20:32:59] [indexer:background] CPU load threshold (3) breached: 11.8 [waiting 2]
[2024-11-29 20:34:39] [index:background] Health check
[2024-11-29 20:34:39] [index:background] CPU load threshold (3) breached: 12.98 [waiting 2]
[2024-11-29 20:34:41] [indexer:background] CPU load threshold (3) breached: 12.74 [waiting 2]
[2024-11-29 20:37:12] [indexer:background] Health check
[2024-11-29 20:37:12] [indexer:background] CPU load threshold (3) breached: 11.08 [waiting 2]
[2024-11-29 20:42:01] [index:background] Health check
[2024-11-29 20:42:01] [index:background] CPU load threshold (3) breached: 10.65 [waiting 2]
[2024-11-29 20:42:03] [indexer:background] CPU load threshold (3) breached: 10.65 [waiting 2]
[2024-11-29 20:42:05] [indexer:background] Health check
[2024-11-29 20:42:05] [indexer:background] CPU load threshold (3) breached: 10.65 [waiting 2]
[2024-11-29 20:42:07] [indexer:background] Health check
[2024-11-29 20:42:07] [indexer:background] CPU load threshold (3) breached: 10.52 [waiting 2]
[2024-11-29 20:44:38] [index:background] Health check
[2024-11-29 20:44:38] [index:background] CPU load threshold (3) breached: 11.39 [waiting 2]
[2024-11-29 20:44:40] [indexer:background] CPU load threshold (3) breached: 11.39 [waiting 2]
[2024-11-29 20:46:47] [indexer:background] Health check
[2024-11-29 20:46:47] [indexer:background] CPU load threshold (3) breached: 10.05 [waiting 2]
[2024-11-29 20:49:46] [index:background] Health check
[2024-11-29 20:49:46] [index:background] CPU load threshold (3) breached: 9.9 [waiting 2]
[2024-11-29 20:49:48] [indexer:background] CPU load threshold (3) breached: 9.9 [waiting 2]
[2024-11-29 20:51:59] [indexer:background] Health check
[2024-11-29 20:51:59] [indexer:background] CPU load threshold (3) breached: 10.16 [waiting 2]
[2024-11-29 20:53:27] [query] Query for: search_term_string
[2024-11-29 20:53:27] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 116 offset: 0 fields: all
[2024-11-29 20:53:27] [query] Engine: default
[2024-11-29 20:53:27] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 20:53:27] [query] Mods: 6
[2024-11-29 20:53:27] [query] Using OR logic
[2024-11-29 20:53:27] [query] Found results using: or logic
[2024-11-29 20:53:27] [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 1150, 10
[2024-11-29 20:53:27] [query] Results: 1382 Pages of results: 139
[2024-11-29 20:53:27] [query] Execution time: 0.20223
[2024-11-29 20:54:57] [index:background] Health check
[2024-11-29 20:54:57] [index:background] CPU load threshold (3) breached: 11.29 [waiting 2]
[2024-11-29 20:54:59] [indexer:background] CPU load threshold (3) breached: 11.29 [waiting 2]
[2024-11-29 20:57:23] [indexer:background] Health check
[2024-11-29 20:57:23] [indexer:background] CPU load threshold (3) breached: 11.24 [waiting 2]
[2024-11-29 21:01:04] [index:background] Health check
[2024-11-29 21:01:04] [index:background] CPU load threshold (3) breached: 11.76 [waiting 2]
[2024-11-29 21:01:06] [indexer:background] CPU load threshold (3) breached: 11.76 [waiting 2]
[2024-11-29 21:02:01] [indexer:background] Health check
[2024-11-29 21:02:01] [indexer:background] CPU load threshold (3) breached: 11.51 [waiting 2]
[2024-11-29 21:05:03] [index:background] Health check
[2024-11-29 21:05:03] [index:background] CPU load threshold (3) breached: 11.36 [waiting 2]
[2024-11-29 21:05:05] [indexer:background] CPU load threshold (3) breached: 11.36 [waiting 2]
[2024-11-29 21:06:47] [indexer:background] Health check
[2024-11-29 21:06:47] [indexer:background] CPU load threshold (3) breached: 11.96 [waiting 2]
[2024-11-29 21:10:19] [index:background] Health check
[2024-11-29 21:10:19] [index:background] CPU load threshold (3) breached: 11 [waiting 2]
[2024-11-29 21:10:22] [indexer:background] CPU load threshold (3) breached: 11 [waiting 2]
[2024-11-29 21:11:49] [indexer:background] Health check
[2024-11-29 21:11:49] [indexer:background] CPU load threshold (3) breached: 11.47 [waiting 2]
[2024-11-29 21:15:01] [index:background] Health check
[2024-11-29 21:15:01] [index:background] CPU load threshold (3) breached: 11.32 [waiting 2]
[2024-11-29 21:15:03] [indexer:background] CPU load threshold (3) breached: 11.69 [waiting 2]
[2024-11-29 21:17:04] [indexer:background] Health check
[2024-11-29 21:17:04] [indexer:background] CPU load threshold (3) breached: 11.01 [waiting 2]
[2024-11-29 21:19:40] [index:background] Health check
[2024-11-29 21:19:40] [index:background] CPU load threshold (3) breached: 13.02 [waiting 2]
[2024-11-29 21:19:42] [indexer:background] CPU load threshold (3) breached: 13.02 [waiting 2]
[2024-11-29 21:22:21] [indexer:background] Health check
[2024-11-29 21:22:21] [indexer:background] CPU load threshold (3) breached: 13.85 [waiting 2]
[2024-11-29 21:24:59] [index:background] Health check
[2024-11-29 21:24:59] [index:background] CPU load threshold (3) breached: 10.6 [waiting 2]
[2024-11-29 21:25:01] [indexer:background] CPU load threshold (3) breached: 10.6 [waiting 2]
[2024-11-29 21:26:57] [indexer:background] Health check
[2024-11-29 21:26:57] [indexer:background] CPU load threshold (3) breached: 13.23 [waiting 2]
[2024-11-29 21:29:44] [index:background] Health check
[2024-11-29 21:29:44] [index:background] CPU load threshold (3) breached: 10.86 [waiting 2]
[2024-11-29 21:29:46] [indexer:background] CPU load threshold (3) breached: 10.86 [waiting 2]
[2024-11-29 21:31:49] [indexer:background] Health check
[2024-11-29 21:31:49] [indexer:background] CPU load threshold (3) breached: 10.57 [waiting 2]
[2024-11-29 21:35:14] [index:background] Health check
[2024-11-29 21:35:14] [index:background] CPU load threshold (3) breached: 9.57 [waiting 2]
[2024-11-29 21:35:16] [indexer:background] CPU load threshold (3) breached: 9.57 [waiting 2]
[2024-11-29 21:37:32] [indexer:background] Health check
[2024-11-29 21:37:32] [indexer:background] CPU load threshold (3) breached: 8.71 [waiting 2]
[2024-11-29 21:39:48] [index:background] Health check
[2024-11-29 21:39:48] [index:background] CPU load threshold (3) breached: 9.04 [waiting 2]
[2024-11-29 21:39:50] [indexer:background] CPU load threshold (3) breached: 8.96 [waiting 2]
[2024-11-29 21:41:51] [indexer:background] Health check
[2024-11-29 21:41:51] [indexer:background] CPU load threshold (3) breached: 6.62 [waiting 2]
[2024-11-29 21:44:54] [index:background] Health check
[2024-11-29 21:44:54] [index:background] CPU load threshold (3) breached: 8.81 [waiting 2]
[2024-11-29 21:44:56] [indexer:background] CPU load threshold (3) breached: 8.81 [waiting 2]
[2024-11-29 21:47:03] [indexer:background] Health check
[2024-11-29 21:47:03] [indexer:background] CPU load threshold (3) breached: 9.35 [waiting 2]
[2024-11-29 21:50:00] [index:background] Health check
[2024-11-29 21:50:00] [index:background] CPU load threshold (3) breached: 7.64 [waiting 2]
[2024-11-29 21:50:02] [indexer:background] CPU load threshold (3) breached: 7.64 [waiting 2]
[2024-11-29 21:52:17] [indexer:background] Health check
[2024-11-29 21:52:17] [indexer:background] CPU load threshold (3) breached: 7.76 [waiting 2]
[2024-11-29 21:54:39] [index:background] Health check
[2024-11-29 21:54:39] [index:background] CPU load threshold (3) breached: 6.74 [waiting 2]
[2024-11-29 21:54:41] [indexer:background] CPU load threshold (3) breached: 6.74 [waiting 2]
[2024-11-29 21:56:48] [indexer:background] Health check
[2024-11-29 21:56:48] [indexer:background] CPU load threshold (3) breached: 7.81 [waiting 2]
[2024-11-29 22:00:13] [index:background] Health check
[2024-11-29 22:00:13] [index:background] CPU load threshold (3) breached: 6.97 [waiting 2]
[2024-11-29 22:00:15] [indexer:background] CPU load threshold (3) breached: 6.97 [waiting 2]
[2024-11-29 22:02:06] [query] Query for: search_term_string
[2024-11-29 22:02:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 117 offset: 0 fields: all
[2024-11-29 22:02:06] [query] Engine: default
[2024-11-29 22:02:07] [indexer:background] Health check
[2024-11-29 22:02:07] [indexer:background] CPU load threshold (3) breached: 6.97 [waiting 2]
[2024-11-29 22:02:07] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 22:02:07] [query] Mods: 6
[2024-11-29 22:02:07] [query] Using OR logic
[2024-11-29 22:02:07] [query] Found results using: or logic
[2024-11-29 22:02:07] [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 1160, 10
[2024-11-29 22:02:07] [query] Results: 1382 Pages of results: 139
[2024-11-29 22:02:07] [query] Execution time: 1.00811
[2024-11-29 22:04:38] [index:background] Health check
[2024-11-29 22:04:38] [index:background] CPU load threshold (3) breached: 7.02 [waiting 2]
[2024-11-29 22:04:40] [indexer:background] CPU load threshold (3) breached: 7.1 [waiting 2]
[2024-11-29 22:07:06] [indexer:background] Health check
[2024-11-29 22:07:06] [indexer:background] CPU load threshold (3) breached: 6.51 [waiting 2]
[2024-11-29 22:10:13] [index:background] Health check
[2024-11-29 22:10:13] [index:background] CPU load threshold (3) breached: 7.23 [waiting 2]
[2024-11-29 22:10:15] [indexer:background] CPU load threshold (3) breached: 7.53 [waiting 2]
[2024-11-29 22:11:51] [indexer:background] Health check
[2024-11-29 22:11:51] [indexer:background] CPU load threshold (3) breached: 8.07 [waiting 2]
[2024-11-29 22:16:26] [index:background] Health check
[2024-11-29 22:16:26] [index:background] CPU load threshold (3) breached: 7.3 [waiting 2]
[2024-11-29 22:16:28] [indexer:background] CPU load threshold (3) breached: 7.3 [waiting 2]
[2024-11-29 22:17:21] [indexer:background] Health check
[2024-11-29 22:17:21] [indexer:background] CPU load threshold (3) breached: 7.53 [waiting 2]
[2024-11-29 22:21:27] [index:background] Health check
[2024-11-29 22:21:27] [index:background] CPU load threshold (3) breached: 6.21 [waiting 2]
[2024-11-29 22:21:29] [indexer:background] CPU load threshold (3) breached: 6.21 [waiting 2]
[2024-11-29 22:21:49] [indexer:background] Health check
[2024-11-29 22:21:49] [indexer:background] CPU load threshold (3) breached: 5.92 [waiting 2]
[2024-11-29 22:25:07] [index:background] Health check
[2024-11-29 22:25:07] [index:background] CPU load threshold (3) breached: 8.1 [waiting 2]
[2024-11-29 22:25:09] [indexer:background] CPU load threshold (3) breached: 8.1 [waiting 2]
[2024-11-29 22:27:11] [indexer:background] Health check
[2024-11-29 22:27:11] [indexer:background] CPU load threshold (3) breached: 5.99 [waiting 2]
[2024-11-29 22:30:16] [index:background] Health check
[2024-11-29 22:30:16] [index:background] CPU load threshold (3) breached: 6.15 [waiting 2]
[2024-11-29 22:30:18] [indexer:background] CPU load threshold (3) breached: 6.15 [waiting 2]
[2024-11-29 22:32:05] [indexer:background] Health check
[2024-11-29 22:32:05] [indexer:background] CPU load threshold (3) breached: 6.59 [waiting 2]
[2024-11-29 22:34:47] [index:background] Health check
[2024-11-29 22:34:47] [index:background] CPU load threshold (3) breached: 6.74 [waiting 2]
[2024-11-29 22:34:49] [indexer:background] CPU load threshold (3) breached: 6.74 [waiting 2]
[2024-11-29 22:37:45] [indexer:background] Health check
[2024-11-29 22:37:45] [indexer:background] CPU load threshold (3) breached: 7.62 [waiting 2]
[2024-11-29 22:39:42] [index:background] Health check
[2024-11-29 22:39:42] [index:background] CPU load threshold (3) breached: 8.56 [waiting 2]
[2024-11-29 22:39:44] [indexer:background] CPU load threshold (3) breached: 8.56 [waiting 2]
[2024-11-29 22:42:02] [indexer:background] Health check
[2024-11-29 22:42:02] [indexer:background] CPU load threshold (3) breached: 8.54 [waiting 2]
[2024-11-29 22:46:56] [index:background] Health check
[2024-11-29 22:46:56] [index:background] CPU load threshold (3) breached: 9.29 [waiting 2]
[2024-11-29 22:46:58] [indexer:background] CPU load threshold (3) breached: 9.26 [waiting 2]
[2024-11-29 22:47:00] [indexer:background] Health check
[2024-11-29 22:47:00] [indexer:background] CPU load threshold (3) breached: 9.26 [waiting 2]
[2024-11-29 22:47:02] [indexer:background] Health check
[2024-11-29 22:47:02] [indexer:background] CPU load threshold (3) breached: 9.24 [waiting 2]
[2024-11-29 22:50:08] [index:background] Health check
[2024-11-29 22:50:08] [index:background] CPU load threshold (3) breached: 9.37 [waiting 2]
[2024-11-29 22:50:10] [indexer:background] CPU load threshold (3) breached: 9.37 [waiting 2]
[2024-11-29 22:52:04] [indexer:background] Health check
[2024-11-29 22:52:04] [indexer:background] CPU load threshold (3) breached: 9.57 [waiting 2]
[2024-11-29 22:55:03] [index:background] Health check
[2024-11-29 22:55:03] [index:background] CPU load threshold (3) breached: 8.2 [waiting 2]
[2024-11-29 22:55:05] [indexer:background] CPU load threshold (3) breached: 8.2 [waiting 2]
[2024-11-29 22:58:22] [indexer:background] Health check
[2024-11-29 22:58:22] [indexer:background] CPU load threshold (3) breached: 7.99 [waiting 2]
[2024-11-29 22:59:49] [index:background] Health check
[2024-11-29 22:59:49] [index:background] CPU load threshold (3) breached: 7.04 [waiting 2]
[2024-11-29 22:59:52] [indexer:background] CPU load threshold (3) breached: 7.04 [waiting 2]
[2024-11-29 23:04:00] [indexer:background] Health check
[2024-11-29 23:04:00] [indexer:background] CPU load threshold (3) breached: 7.85 [waiting 2]
[2024-11-29 23:04:38] [index:background] Health check
[2024-11-29 23:04:38] [index:background] CPU load threshold (3) breached: 7.16 [waiting 2]
[2024-11-29 23:04:40] [indexer:background] CPU load threshold (3) breached: 7.16 [waiting 2]
[2024-11-29 23:07:15] [indexer:background] Health check
[2024-11-29 23:07:15] [indexer:background] CPU load threshold (3) breached: 8.29 [waiting 2]
[2024-11-29 23:09:49] [index:background] Health check
[2024-11-29 23:09:49] [index:background] CPU load threshold (3) breached: 8.59 [waiting 2]
[2024-11-29 23:09:51] [indexer:background] CPU load threshold (3) breached: 8.59 [waiting 2]
[2024-11-29 23:11:55] [indexer:background] Health check
[2024-11-29 23:11:55] [indexer:background] CPU load threshold (3) breached: 7.35 [waiting 2]
[2024-11-29 23:15:56] [index:background] Health check
[2024-11-29 23:15:56] [index:background] CPU load threshold (3) breached: 8.27 [waiting 2]
[2024-11-29 23:15:59] [indexer:background] CPU load threshold (3) breached: 8.49 [waiting 2]
[2024-11-29 23:18:34] [indexer:background] Health check
[2024-11-29 23:18:34] [indexer:background] CPU load threshold (3) breached: 8.05 [waiting 2]
[2024-11-29 23:19:42] [index:background] Health check
[2024-11-29 23:19:42] [index:background] CPU load threshold (3) breached: 8.6 [waiting 2]
[2024-11-29 23:19:44] [indexer:background] CPU load threshold (3) breached: 8.87 [waiting 2]
[2024-11-29 23:21:50] [indexer:background] Health check
[2024-11-29 23:21:50] [indexer:background] CPU load threshold (3) breached: 8.02 [waiting 2]
[2024-11-29 23:21:53] [query] Query for: search_term_string
[2024-11-29 23:21:53] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 115 offset: 0 fields: all
[2024-11-29 23:21:53] [query] Engine: default
[2024-11-29 23:21:53] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-11-29 23:21:53] [query] Mods: 6
[2024-11-29 23:21:53] [query] Using OR logic
[2024-11-29 23:21:54] [query] Found results using: or logic
[2024-11-29 23:21:54] [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 1140, 10
[2024-11-29 23:21:54] [query] Results: 1382 Pages of results: 139
[2024-11-29 23:21:54] [query] Execution time: 1.10855
[2024-11-29 23:24:58] [index:background] Health check
[2024-11-29 23:24:58] [index:background] CPU load threshold (3) breached: 8.67 [waiting 2]
[2024-11-29 23:25:00] [indexer:background] CPU load threshold (3) breached: 8.94 [waiting 2]
[2024-11-29 23:27:30] [indexer:background] Health check
[2024-11-29 23:27:30] [indexer:background] CPU load threshold (3) breached: 7.81 [waiting 2]
[2024-11-29 23:29:40] [index:background] Health check
[2024-11-29 23:29:40] [index:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 23:29:43] [indexer:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 23:31:51] [indexer:background] Health check
[2024-11-29 23:31:51] [indexer:background] CPU load threshold (3) breached: 8.34 [waiting 2]
[2024-11-29 23:36:54] [index:background] Health check
[2024-11-29 23:36:54] [index:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 23:36:56] [indexer:background] CPU load threshold (3) breached: 7.83 [waiting 2]
[2024-11-29 23:37:00] [indexer:background] Health check
[2024-11-29 23:37:00] [indexer:background] CPU load threshold (3) breached: 7.85 [waiting 2]
[2024-11-29 23:37:02] [indexer:background] Health check
[2024-11-29 23:37:02] [indexer:background] CPU load threshold (3) breached: 7.85 [waiting 2]
[2024-11-29 23:39:47] [index:background] Health check
[2024-11-29 23:39:47] [index:background] CPU load threshold (3) breached: 7.53 [waiting 2]
[2024-11-29 23:39:49] [indexer:background] CPU load threshold (3) breached: 7.17 [waiting 2]
[2024-11-29 23:42:02] [indexer:background] Health check
[2024-11-29 23:42:02] [indexer:background] CPU load threshold (3) breached: 7.48 [waiting 2]
[2024-11-29 23:45:14] [index:background] Health check
[2024-11-29 23:45:14] [index:background] CPU load threshold (3) breached: 7.22 [waiting 2]
[2024-11-29 23:45:16] [indexer:background] CPU load threshold (3) breached: 7.22 [waiting 2]
[2024-11-29 23:47:01] [indexer:background] Health check
[2024-11-29 23:47:01] [indexer:background] CPU load threshold (3) breached: 7.35 [waiting 2]
[2024-11-29 23:51:15] [index:background] Health check
[2024-11-29 23:51:15] [index:background] CPU load threshold (3) breached: 6 [waiting 2]
[2024-11-29 23:51:17] [indexer:background] CPU load threshold (3) breached: 6 [waiting 2]
[2024-11-29 23:52:33] [indexer:background] Health check
[2024-11-29 23:52:33] [indexer:background] CPU load threshold (3) breached: 6.52 [waiting 2]
[2024-11-29 23:56:24] [index:background] Health check
[2024-11-29 23:56:24] [index:background] CPU load threshold (3) breached: 9.76 [waiting 2]
[2024-11-29 23:56:26] [indexer:background] CPU load threshold (3) breached: 9.3 [waiting 2]
[2024-11-29 23:56:58] [indexer:background] Health check
[2024-11-29 23:56:58] [indexer:background] CPU load threshold (3) breached: 7.99 [waiting 2]