[2024-01-30 00:00:55] [indexer:background] Health check
[2024-01-30 00:00:55] [index:background] Health check
[2024-01-30 00:06:03] [indexer:background] Health check
[2024-01-30 00:06:03] [index:background] Health check
[2024-01-30 00:10:30] [indexer:background] Health check
[2024-01-30 00:10:30] [index:background] Health check
[2024-01-30 00:15:58] [indexer:background] Health check
[2024-01-30 00:15:58] [index:background] Health check
[2024-01-30 00:19:59] [indexer:background] Health check
[2024-01-30 00:20:42] [index:background] Health check
[2024-01-30 00:25:18] [indexer:background] Health check
[2024-01-30 00:26:00] [index:background] Health check
[2024-01-30 00:30:08] [indexer:background] Health check
[2024-01-30 00:32:21] [index:background] Health check
[2024-01-30 00:36:13] [indexer:background] Health check
[2024-01-30 00:36:13] [index:background] Health check
[2024-01-30 00:36:47] [query] Query for: 2023
[2024-01-30 00:36:47] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 00:36:47] [query] Engine: default
[2024-01-30 00:36:48] [query] Tokens: 2023
[2024-01-30 00:36:48] [query] Mods: 6
[2024-01-30 00:36:49] [query] Found results using: or logic
[2024-01-30 00:36:49] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 00:36:49] [query] Results: 255 Pages of results: 26
[2024-01-30 00:36:49] [query] Execution time: 1.67505
[2024-01-30 00:40:45] [indexer:background] Health check
[2024-01-30 00:40:45] [index:background] Health check
[2024-01-30 00:45:03] [indexer:background] Health check
[2024-01-30 00:47:11] [index:background] Health check
[2024-01-30 00:50:19] [indexer:background] Health check
[2024-01-30 00:50:43] [index:background] Health check
[2024-01-30 00:55:52] [indexer:background] Health check
[2024-01-30 00:55:53] [index:background] Health check
[2024-01-30 01:01:04] [indexer:background] Health check
[2024-01-30 01:01:04] [index:background] Health check
[2024-01-30 01:05:01] [indexer:background] Health check
[2024-01-30 01:06:15] [index:background] Health check
[2024-01-30 01:11:57] [indexer:background] Health check
[2024-01-30 01:11:57] [index:background] Health check
[2024-01-30 01:15:03] [indexer:background] Health check
[2024-01-30 01:16:16] [index:background] Health check
[2024-01-30 01:20:54] [indexer:background] Health check
[2024-01-30 01:20:54] [index:background] Health check
[2024-01-30 01:25:31] [indexer:background] Health check
[2024-01-30 01:25:31] [index:background] Health check
[2024-01-30 01:30:08] [indexer:background] Health check
[2024-01-30 01:31:25] [index:background] Health check
[2024-01-30 01:36:40] [indexer:background] Health check
[2024-01-30 01:36:40] [index:background] Health check
[2024-01-30 01:39:58] [indexer:background] Health check
[2024-01-30 01:40:37] [index:background] Health check
[2024-01-30 01:45:50] [indexer:background] Health check
[2024-01-30 01:45:51] [index:background] Health check
[2024-01-30 01:51:46] [indexer:background] Health check
[2024-01-30 01:51:46] [index:background] Health check
[2024-01-30 01:55:07] [indexer:background] Health check
[2024-01-30 01:55:26] [index:background] Health check
[2024-01-30 02:00:33] [indexer:background] Health check
[2024-01-30 02:00:33] [index:background] Health check
[2024-01-30 02:07:25] [indexer:background] Health check
[2024-01-30 02:07:25] [index:background] Health check
[2024-01-30 02:10:56] [indexer:background] Health check
[2024-01-30 02:10:56] [index:background] Health check
[2024-01-30 02:16:11] [indexer:background] Health check
[2024-01-30 02:16:11] [index:background] Health check
[2024-01-30 02:20:51] [indexer:background] Health check
[2024-01-30 02:20:51] [index:background] Health check
[2024-01-30 02:25:25] [indexer:background] Health check
[2024-01-30 02:25:25] [index:background] Health check
[2024-01-30 02:31:25] [indexer:background] Health check
[2024-01-30 02:31:25] [index:background] Health check
[2024-01-30 02:35:19] [indexer:background] Health check
[2024-01-30 02:36:02] [index:background] Health check
[2024-01-30 02:40:21] [indexer:background] Health check
[2024-01-30 02:42:25] [index:background] Health check
[2024-01-30 02:44:57] [indexer:background] Health check
[2024-01-30 02:44:57] [indexer:background] CPU load threshold (3) breached: 4.15 [waiting 2]
[2024-01-30 02:45:49] [index:background] Health check
[2024-01-30 02:45:49] [index:background] CPU load threshold (3) breached: 3.79 [waiting 2]
[2024-01-30 02:45:51] [indexer:background] CPU load threshold (3) breached: 3.8 [waiting 2]
[2024-01-30 02:53:17] [indexer:background] Health check
[2024-01-30 02:53:17] [indexer:background] CPU load threshold (3) breached: 3.77 [waiting 2]
[2024-01-30 02:53:19] [index:background] Health check
[2024-01-30 02:53:19] [index:background] CPU load threshold (3) breached: 3.77 [waiting 2]
[2024-01-30 02:53:21] [indexer:background] CPU load threshold (3) breached: 3.77 [waiting 2]
[2024-01-30 02:54:59] [indexer:background] Health check
[2024-01-30 02:54:59] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2024-01-30 02:55:33] [index:background] Health check
[2024-01-30 02:55:33] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2024-01-30 02:55:35] [indexer:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2024-01-30 03:00:06] [indexer:background] Health check
[2024-01-30 03:00:54] [index:background] Health check
[2024-01-30 03:00:54] [index:background] CPU load threshold (3) breached: 4.25 [waiting 2]
[2024-01-30 03:00:56] [indexer:background] CPU load threshold (3) breached: 4.25 [waiting 2]
[2024-01-30 03:05:05] [indexer:background] Health check
[2024-01-30 03:06:51] [index:background] Health check
[2024-01-30 03:06:51] [index:background] CPU load threshold (3) breached: 3.51 [waiting 2]
[2024-01-30 03:06:53] [indexer:background] CPU load threshold (3) breached: 3.39 [waiting 2]
[2024-01-30 03:10:15] [indexer:background] Health check
[2024-01-30 03:10:15] [indexer:background] CPU load threshold (3) breached: 3.78 [waiting 2]
[2024-01-30 03:11:20] [index:background] Health check
[2024-01-30 03:11:20] [index:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2024-01-30 03:11:22] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2024-01-30 03:15:37] [indexer:background] Health check
[2024-01-30 03:15:37] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2024-01-30 03:15:39] [index:background] Health check
[2024-01-30 03:15:39] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-01-30 03:15:41] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-01-30 03:21:01] [indexer:background] Health check
[2024-01-30 03:21:01] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2024-01-30 03:21:03] [index:background] Health check
[2024-01-30 03:21:03] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2024-01-30 03:25:53] [indexer:background] Health check
[2024-01-30 03:25:53] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2024-01-30 03:25:55] [index:background] Health check
[2024-01-30 03:25:55] [index:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2024-01-30 03:25:57] [indexer:background] CPU load threshold (3) breached: 3.05 [waiting 2]
[2024-01-30 03:31:54] [indexer:background] Health check
[2024-01-30 03:31:54] [index:background] Health check
[2024-01-30 03:35:05] [indexer:background] Health check
[2024-01-30 03:35:05] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-01-30 03:35:35] [index:background] Health check
[2024-01-30 03:35:35] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-01-30 03:35:37] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-01-30 03:40:09] [indexer:background] Health check
[2024-01-30 03:40:30] [index:background] Health check
[2024-01-30 03:40:30] [index:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2024-01-30 03:40:32] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2024-01-30 03:49:42] [indexer:background] Health check
[2024-01-30 03:49:42] [indexer:background] CPU load threshold (3) breached: 4.42 [waiting 2]
[2024-01-30 03:49:44] [index:background] Health check
[2024-01-30 03:49:44] [index:background] CPU load threshold (3) breached: 4.42 [waiting 2]
[2024-01-30 03:49:46] [indexer:background] CPU load threshold (3) breached: 4.47 [waiting 2]
[2024-01-30 03:50:41] [indexer:background] Health check
[2024-01-30 03:50:41] [indexer:background] CPU load threshold (3) breached: 4.27 [waiting 2]
[2024-01-30 03:50:43] [index:background] Health check
[2024-01-30 03:50:43] [index:background] CPU load threshold (3) breached: 4.27 [waiting 2]
[2024-01-30 03:50:45] [indexer:background] CPU load threshold (3) breached: 4.17 [waiting 2]
[2024-01-30 03:55:22] [indexer:background] Health check
[2024-01-30 03:56:31] [index:background] Health check
[2024-01-30 04:00:14] [indexer:background] Health check
[2024-01-30 04:00:34] [index:background] Health check
[2024-01-30 04:05:42] [indexer:background] Health check
[2024-01-30 04:05:42] [index:background] Health check
[2024-01-30 04:10:24] [indexer:background] Health check
[2024-01-30 04:10:24] [index:background] Health check
[2024-01-30 04:15:22] [indexer:background] Health check
[2024-01-30 04:15:47] [index:background] Health check
[2024-01-30 04:22:35] [indexer:background] Health check
[2024-01-30 04:22:35] [index:background] Health check
[2024-01-30 04:25:30] [indexer:background] Health check
[2024-01-30 04:25:31] [index:background] Health check
[2024-01-30 04:33:00] [indexer:background] Health check
[2024-01-30 04:33:00] [index:background] Health check
[2024-01-30 04:35:23] [indexer:background] Health check
[2024-01-30 04:35:23] [index:background] Health check
[2024-01-30 04:42:31] [indexer:background] Health check
[2024-01-30 04:42:31] [index:background] Health check
[2024-01-30 04:46:40] [indexer:background] Health check
[2024-01-30 04:46:40] [index:background] Health check
[2024-01-30 04:49:58] [indexer:background] Health check
[2024-01-30 04:52:23] [index:background] Health check
[2024-01-30 04:55:33] [indexer:background] Health check
[2024-01-30 04:55:33] [index:background] Health check
[2024-01-30 05:00:33] [indexer:background] Health check
[2024-01-30 05:00:33] [index:background] Health check
[2024-01-30 05:05:05] [indexer:background] Health check
[2024-01-30 05:05:34] [index:background] Health check
[2024-01-30 05:12:25] [indexer:background] Health check
[2024-01-30 05:12:25] [index:background] Health check
[2024-01-30 05:15:45] [indexer:background] Health check
[2024-01-30 05:15:45] [index:background] Health check
[2024-01-30 05:21:16] [indexer:background] Health check
[2024-01-30 05:21:16] [index:background] Health check
[2024-01-30 05:25:59] [indexer:background] Health check
[2024-01-30 05:25:59] [index:background] Health check
[2024-01-30 05:30:47] [indexer:background] Health check
[2024-01-30 05:30:47] [index:background] Health check
[2024-01-30 05:35:04] [indexer:background] Health check
[2024-01-30 05:35:47] [index:background] Health check
[2024-01-30 05:40:11] [indexer:background] Health check
[2024-01-30 05:41:06] [index:background] Health check
[2024-01-30 05:44:58] [indexer:background] Health check
[2024-01-30 05:45:24] [index:background] Health check
[2024-01-30 05:50:03] [indexer:background] Health check
[2024-01-30 05:50:51] [index:background] Health check
[2024-01-30 05:55:07] [indexer:background] Health check
[2024-01-30 05:55:24] [index:background] Health check
[2024-01-30 06:00:00] [indexer:background] Health check
[2024-01-30 06:01:13] [index:background] Health check
[2024-01-30 06:05:09] [indexer:background] Health check
[2024-01-30 06:06:22] [index:background] Health check
[2024-01-30 06:09:59] [indexer:background] Health check
[2024-01-30 06:10:38] [index:background] Health check
[2024-01-30 06:15:09] [indexer:background] Health check
[2024-01-30 06:15:27] [index:background] Health check
[2024-01-30 06:19:59] [indexer:background] Health check
[2024-01-30 06:20:26] [index:background] Health check
[2024-01-30 06:22:45] [query] Query for: 2024
[2024-01-30 06:22:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 06:22:45] [query] Engine: default
[2024-01-30 06:22:46] [query] Tokens: 2024
[2024-01-30 06:22:46] [query] Mods: 6
[2024-01-30 06:22:46] [query] Found results using: or logic
[2024-01-30 06:22:46] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 06:22:46] [query] Results: 132 Pages of results: 14
[2024-01-30 06:22:46] [query] Execution time: 1.73128
[2024-01-30 06:22:46] [query] Query for: 2024
[2024-01-30 06:22:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-30 06:22:46] [query] Engine: default
[2024-01-30 06:22:46] [query] Tokens: 2024
[2024-01-30 06:22:46] [query] Mods: 6
[2024-01-30 06:22:46] [query] Found results using: or logic
[2024-01-30 06:22:46] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-30 06:22:46] [query] Results: 132 Pages of results: 2
[2024-01-30 06:22:46] [query] Execution time: 0.07958
[2024-01-30 06:25:03] [indexer:background] Health check
[2024-01-30 06:25:39] [index:background] Health check
[2024-01-30 06:30:15] [indexer:background] Health check
[2024-01-30 06:30:25] [index:background] Health check
[2024-01-30 06:35:01] [indexer:background] Health check
[2024-01-30 06:35:35] [index:background] Health check
[2024-01-30 06:40:00] [indexer:background] Health check
[2024-01-30 06:40:23] [index:background] Health check
[2024-01-30 06:44:59] [indexer:background] Health check
[2024-01-30 06:45:27] [index:background] Health check
[2024-01-30 06:50:04] [indexer:background] Health check
[2024-01-30 06:50:47] [index:background] Health check
[2024-01-30 06:55:07] [indexer:background] Health check
[2024-01-30 06:55:26] [index:background] Health check
[2024-01-30 07:00:05] [indexer:background] Health check
[2024-01-30 07:01:05] [index:background] Health check
[2024-01-30 07:05:19] [indexer:background] Health check
[2024-01-30 07:05:26] [index:background] Health check
[2024-01-30 07:10:01] [indexer:background] Health check
[2024-01-30 07:10:26] [index:background] Health check
[2024-01-30 07:14:58] [indexer:background] Health check
[2024-01-30 07:15:46] [index:background] Health check
[2024-01-30 07:20:15] [indexer:background] Health check
[2024-01-30 07:20:26] [index:background] Health check
[2024-01-30 07:25:00] [indexer:background] Health check
[2024-01-30 07:25:39] [index:background] Health check
[2024-01-30 07:30:07] [indexer:background] Health check
[2024-01-30 07:31:24] [index:background] Health check
[2024-01-30 07:34:58] [indexer:background] Health check
[2024-01-30 07:35:27] [index:background] Health check
[2024-01-30 07:40:03] [indexer:background] Health check
[2024-01-30 07:40:29] [index:background] Health check
[2024-01-30 07:45:11] [indexer:background] Health check
[2024-01-30 07:45:27] [index:background] Health check
[2024-01-30 07:49:59] [indexer:background] Health check
[2024-01-30 07:50:26] [index:background] Health check
[2024-01-30 07:55:15] [indexer:background] Health check
[2024-01-30 07:55:26] [index:background] Health check
[2024-01-30 08:00:02] [indexer:background] Health check
[2024-01-30 08:00:27] [index:background] Health check
[2024-01-30 08:04:59] [indexer:background] Health check
[2024-01-30 08:05:32] [index:background] Health check
[2024-01-30 08:09:59] [indexer:background] Health check
[2024-01-30 08:10:26] [index:background] Health check
[2024-01-30 08:15:03] [indexer:background] Health check
[2024-01-30 08:15:35] [index:background] Health check
[2024-01-30 08:19:59] [indexer:background] Health check
[2024-01-30 08:20:26] [index:background] Health check
[2024-01-30 08:25:00] [indexer:background] Health check
[2024-01-30 08:25:26] [index:background] Health check
[2024-01-30 08:30:06] [indexer:background] Health check
[2024-01-30 08:30:06] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2024-01-30 08:30:27] [index:background] Health check
[2024-01-30 08:35:00] [indexer:background] Health check
[2024-01-30 08:35:26] [index:background] Health check
[2024-01-30 08:40:02] [indexer:background] Health check
[2024-01-30 08:40:35] [index:background] Health check
[2024-01-30 08:45:02] [indexer:background] Health check
[2024-01-30 08:45:26] [index:background] Health check
[2024-01-30 08:50:02] [indexer:background] Health check
[2024-01-30 08:50:26] [index:background] Health check
[2024-01-30 08:55:01] [indexer:background] Health check
[2024-01-30 08:55:27] [index:background] Health check
[2024-01-30 09:00:00] [indexer:background] Health check
[2024-01-30 09:00:00] [indexer:background] CPU load threshold (3) breached: 3.13 [waiting 2]
[2024-01-30 09:00:26] [index:background] Health check
[2024-01-30 09:05:04] [indexer:background] Health check
[2024-01-30 09:05:26] [index:background] Health check
[2024-01-30 09:10:02] [indexer:background] Health check
[2024-01-30 09:10:02] [indexer:background] CPU load threshold (3) breached: 3.11 [waiting 2]
[2024-01-30 09:10:26] [index:background] Health check
[2024-01-30 09:10:26] [index:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2024-01-30 09:10:28] [indexer:background] CPU load threshold (3) breached: 3.45 [waiting 2]
[2024-01-30 09:14:58] [indexer:background] Health check
[2024-01-30 09:14:58] [indexer:background] CPU load threshold (3) breached: 3.34 [waiting 2]
[2024-01-30 09:15:26] [index:background] Health check
[2024-01-30 09:15:26] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2024-01-30 09:15:28] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2]
[2024-01-30 09:20:02] [indexer:background] Health check
[2024-01-30 09:20:02] [indexer:background] CPU load threshold (3) breached: 3.14 [waiting 2]
[2024-01-30 09:20:28] [index:background] Health check
[2024-01-30 09:25:04] [indexer:background] Health check
[2024-01-30 09:25:04] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2024-01-30 09:25:26] [index:background] Health check
[2024-01-30 09:25:26] [index:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2024-01-30 09:25:28] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2024-01-30 09:30:02] [indexer:background] Health check
[2024-01-30 09:30:27] [index:background] Health check
[2024-01-30 09:35:12] [indexer:background] Health check
[2024-01-30 09:35:27] [index:background] Health check
[2024-01-30 09:35:27] [index:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2024-01-30 09:35:29] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2024-01-30 09:40:03] [indexer:background] Health check
[2024-01-30 09:40:26] [index:background] Health check
[2024-01-30 09:45:02] [indexer:background] Health check
[2024-01-30 09:45:27] [index:background] Health check
[2024-01-30 09:46:53] [query] Query for: 2023
[2024-01-30 09:46:53] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 09:46:53] [query] Engine: default
[2024-01-30 09:46:53] [query] Tokens: 2023
[2024-01-30 09:46:53] [query] Mods: 6
[2024-01-30 09:46:53] [query] Found results using: or logic
[2024-01-30 09:46:53] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 09:46:53] [query] Results: 255 Pages of results: 26
[2024-01-30 09:46:53] [query] Execution time: 0.48628
[2024-01-30 09:46:53] [query] Query for: 2023
[2024-01-30 09:46:53] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-01-30 09:46:53] [query] Engine: default
[2024-01-30 09:46:53] [query] Tokens: 2023
[2024-01-30 09:46:53] [query] Mods: 6
[2024-01-30 09:46:54] [query] Found results using: or logic
[2024-01-30 09:46: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 (4302) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 100
[2024-01-30 09:46:54] [query] Results: 255 Pages of results: 3
[2024-01-30 09:46:54] [query] Execution time: 0.10350
[2024-01-30 09:50:16] [indexer:background] Health check
[2024-01-30 09:50:26] [index:background] Health check
[2024-01-30 09:55:03] [indexer:background] Health check
[2024-01-30 09:55:28] [index:background] Health check
[2024-01-30 09:59:58] [indexer:background] Health check
[2024-01-30 10:00:28] [index:background] Health check
[2024-01-30 10:04:59] [indexer:background] Health check
[2024-01-30 10:05:26] [index:background] Health check
[2024-01-30 10:10:00] [indexer:background] Health check
[2024-01-30 10:10:26] [index:background] Health check
[2024-01-30 10:14:58] [indexer:background] Health check
[2024-01-30 10:15:27] [index:background] Health check
[2024-01-30 10:20:08] [indexer:background] Health check
[2024-01-30 10:20:30] [index:background] Health check
[2024-01-30 10:25:00] [indexer:background] Health check
[2024-01-30 10:25:26] [index:background] Health check
[2024-01-30 10:30:32] [indexer:background] Health check
[2024-01-30 10:30:32] [index:background] Health check
[2024-01-30 10:34:58] [indexer:background] Health check
[2024-01-30 10:35:28] [index:background] Health check
[2024-01-30 10:35:28] [index:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2024-01-30 10:35:30] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2024-01-30 10:39:58] [indexer:background] Health check
[2024-01-30 10:40:26] [index:background] Health check
[2024-01-30 10:44:59] [indexer:background] Health check
[2024-01-30 10:45:31] [index:background] Health check
[2024-01-30 10:50:03] [indexer:background] Health check
[2024-01-30 10:50:30] [index:background] Health check
[2024-01-30 10:55:02] [indexer:background] Health check
[2024-01-30 10:55:02] [indexer:background] CPU load threshold (3) breached: 3.1 [waiting 2]
[2024-01-30 10:55:31] [index:background] Health check
[2024-01-30 11:00:02] [indexer:background] Health check
[2024-01-30 11:00:02] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-01-30 11:00:33] [index:background] Health check
[2024-01-30 11:00:33] [index:background] CPU load threshold (3) breached: 3.24 [waiting 2]
[2024-01-30 11:00:35] [indexer:background] CPU load threshold (3) breached: 3.24 [waiting 2]
[2024-01-30 11:04:59] [indexer:background] Health check
[2024-01-30 11:05:26] [index:background] Health check
[2024-01-30 11:10:47] [indexer:background] Health check
[2024-01-30 11:10:47] [index:background] Health check
[2024-01-30 11:15:00] [indexer:background] Health check
[2024-01-30 11:15:31] [index:background] Health check
[2024-01-30 11:19:59] [indexer:background] Health check
[2024-01-30 11:20:31] [index:background] Health check
[2024-01-30 11:25:01] [indexer:background] Health check
[2024-01-30 11:25:25] [index:background] Health check
[2024-01-30 11:30:02] [indexer:background] Health check
[2024-01-30 11:30:26] [query] Query for: 2024
[2024-01-30 11:30:26] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 11:30:26] [query] Engine: default
[2024-01-30 11:30:26] [index:background] Health check
[2024-01-30 11:30:27] [query] Tokens: 2024
[2024-01-30 11:30:27] [query] Mods: 6
[2024-01-30 11:30:28] [query] Found results using: or logic
[2024-01-30 11:30:28] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 11:30:28] [query] Results: 132 Pages of results: 14
[2024-01-30 11:30:28] [query] Execution time: 1.83923
[2024-01-30 11:34:59] [indexer:background] Health check
[2024-01-30 11:36:36] [index:background] Health check
[2024-01-30 11:40:03] [indexer:background] Health check
[2024-01-30 11:40:29] [index:background] Health check
[2024-01-30 11:45:01] [indexer:background] Health check
[2024-01-30 11:45:31] [index:background] Health check
[2024-01-30 11:50:02] [indexer:background] Health check
[2024-01-30 11:50:27] [index:background] Health check
[2024-01-30 11:55:16] [indexer:background] Health check
[2024-01-30 11:55:31] [index:background] Health check
[2024-01-30 12:00:02] [indexer:background] Health check
[2024-01-30 12:00:26] [index:background] Health check
[2024-01-30 12:05:01] [indexer:background] Health check
[2024-01-30 12:05:24] [index:background] Health check
[2024-01-30 12:10:31] [indexer:background] Health check
[2024-01-30 12:10:31] [index:background] Health check
[2024-01-30 12:15:02] [indexer:background] Health check
[2024-01-30 12:15:26] [index:background] Health check
[2024-01-30 12:19:59] [indexer:background] Health check
[2024-01-30 12:20:26] [index:background] Health check
[2024-01-30 12:25:03] [indexer:background] Health check
[2024-01-30 12:25:26] [index:background] Health check
[2024-01-30 12:30:02] [indexer:background] Health check
[2024-01-30 12:30:31] [index:background] Health check
[2024-01-30 12:35:08] [indexer:background] Health check
[2024-01-30 12:35:27] [index:background] Health check
[2024-01-30 12:39:59] [indexer:background] Health check
[2024-01-30 12:40:26] [index:background] Health check
[2024-01-30 12:45:02] [indexer:background] Health check
[2024-01-30 12:45:27] [index:background] Health check
[2024-01-30 12:50:06] [indexer:background] Health check
[2024-01-30 12:50:28] [index:background] Health check
[2024-01-30 12:55:03] [indexer:background] Health check
[2024-01-30 12:55:03] [indexer:background] CPU load threshold (3) breached: 3.25 [waiting 2]
[2024-01-30 12:55:26] [index:background] Health check
[2024-01-30 12:59:58] [indexer:background] Health check
[2024-01-30 12:59:58] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2024-01-30 13:01:28] [index:background] Health check
[2024-01-30 13:01:28] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-01-30 13:01:30] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-01-30 13:04:58] [indexer:background] Health check
[2024-01-30 13:05:26] [index:background] Health check
[2024-01-30 13:10:35] [indexer:background] Health check
[2024-01-30 13:10:35] [index:background] Health check
[2024-01-30 13:15:02] [indexer:background] Health check
[2024-01-30 13:15:28] [index:background] Health check
[2024-01-30 13:20:02] [indexer:background] Health check
[2024-01-30 13:20:28] [index:background] Health check
[2024-01-30 13:24:58] [indexer:background] Health check
[2024-01-30 13:24:58] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2024-01-30 13:25:30] [index:background] Health check
[2024-01-30 13:30:48] [indexer:background] Health check
[2024-01-30 13:30:48] [index:background] Health check
[2024-01-30 13:34:59] [indexer:background] Health check
[2024-01-30 13:35:31] [index:background] Health check
[2024-01-30 13:41:07] [indexer:background] Health check
[2024-01-30 13:41:08] [index:background] Health check
[2024-01-30 13:45:03] [indexer:background] Health check
[2024-01-30 13:45:26] [index:background] Health check
[2024-01-30 13:50:08] [indexer:background] Health check
[2024-01-30 13:50:26] [index:background] Health check
[2024-01-30 13:55:00] [indexer:background] Health check
[2024-01-30 13:55:26] [index:background] Health check
[2024-01-30 14:00:11] [indexer:background] Health check
[2024-01-30 14:00:36] [index:background] Health check
[2024-01-30 14:04:58] [indexer:background] Health check
[2024-01-30 14:05:27] [index:background] Health check
[2024-01-30 14:09:58] [indexer:background] Health check
[2024-01-30 14:10:26] [index:background] Health check
[2024-01-30 14:14:58] [indexer:background] Health check
[2024-01-30 14:15:26] [index:background] Health check
[2024-01-30 14:20:03] [indexer:background] Health check
[2024-01-30 14:20:27] [index:background] Health check
[2024-01-30 14:24:59] [indexer:background] Health check
[2024-01-30 14:26:26] [index:background] Health check
[2024-01-30 14:30:04] [indexer:background] Health check
[2024-01-30 14:30:26] [index:background] Health check
[2024-01-30 14:35:02] [indexer:background] Health check
[2024-01-30 14:35:26] [index:background] Health check
[2024-01-30 14:40:02] [indexer:background] Health check
[2024-01-30 14:40:27] [index:background] Health check
[2024-01-30 14:45:00] [indexer:background] Health check
[2024-01-30 14:45:26] [index:background] Health check
[2024-01-30 14:50:04] [indexer:background] Health check
[2024-01-30 14:50:26] [index:background] Health check
[2024-01-30 14:54:58] [indexer:background] Health check
[2024-01-30 14:55:26] [index:background] Health check
[2024-01-30 15:01:03] [indexer:background] Health check
[2024-01-30 15:01:03] [index:background] Health check
[2024-01-30 15:05:03] [indexer:background] Health check
[2024-01-30 15:05:26] [index:background] Health check
[2024-01-30 15:09:58] [indexer:background] Health check
[2024-01-30 15:10:27] [index:background] Health check
[2024-01-30 15:14:59] [indexer:background] Health check
[2024-01-30 15:16:07] [index:background] Health check
[2024-01-30 15:16:42] [query] Query for: search_term_string
[2024-01-30 15:16:42] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 15:16:42] [query] Engine: default
[2024-01-30 15:16:43] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-30 15:16:43] [query] Mods: 6
[2024-01-30 15:16:43] [query] Using OR logic
[2024-01-30 15:16:45] [query] Found results using: or logic
[2024-01-30 15:16:45] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 15:16:45] [query] Results: 1348 Pages of results: 135
[2024-01-30 15:16:45] [query] Execution time: 3.58158
[2024-01-30 15:20:02] [indexer:background] Health check
[2024-01-30 15:20:26] [index:background] Health check
[2024-01-30 15:24:58] [indexer:background] Health check
[2024-01-30 15:26:11] [index:background] Health check
[2024-01-30 15:29:59] [indexer:background] Health check
[2024-01-30 15:30:27] [index:background] Health check
[2024-01-30 15:33:35] [query] Query for: search_term_string
[2024-01-30 15:33:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 15:33:35] [query] Engine: default
[2024-01-30 15:33:35] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-30 15:33:35] [query] Mods: 6
[2024-01-30 15:33:35] [query] Using OR logic
[2024-01-30 15:33:35] [query] Found results using: or logic
[2024-01-30 15:33:35] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 15:33:35] [query] Results: 1348 Pages of results: 135
[2024-01-30 15:33:35] [query] Execution time: 0.04362
[2024-01-30 15:35:01] [indexer:background] Health check
[2024-01-30 15:35:01] [indexer:background] CPU load threshold (3) breached: 3.03 [waiting 2]
[2024-01-30 15:35:27] [index:background] Health check
[2024-01-30 15:40:02] [indexer:background] Health check
[2024-01-30 15:40:26] [index:background] Health check
[2024-01-30 15:44:58] [indexer:background] Health check
[2024-01-30 15:45:27] [index:background] Health check
[2024-01-30 15:45:34] [query] Query for: 2024
[2024-01-30 15:45:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-01-30 15:45:34] [query] Engine: default
[2024-01-30 15:45:35] [query] Tokens: 2024
[2024-01-30 15:45:35] [query] Mods: 6
[2024-01-30 15:45:35] [query] Found results using: or logic
[2024-01-30 15:45: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 (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-01-30 15:45:35] [query] Results: 132 Pages of results: 14
[2024-01-30 15:45:35] [query] Execution time: 0.67522
[2024-01-30 15:50:00] [indexer:background] Health check
[2024-01-30 15:50:26] [index:background] Health check
[2024-01-30 15:54:58] [indexer:background] Health check
[2024-01-30 15:55:26] [index:background] Health check
[2024-01-30 16:00:02] [indexer:background] Health check
[2024-01-30 16:00:28] [index:background] Health check
[2024-01-30 16:05:03] [indexer:background] Health check
[2024-01-30 16:05:26] [index:background] Health check
[2024-01-30 16:09:59] [indexer:background] Health check
[2024-01-30 16:10:00] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2024-01-30 16:10:27] [index:background] Health check
[2024-01-30 16:10:27] [index:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2024-01-30 16:10:29] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2024-01-30 16:15:00] [indexer:background] Health check
[2024-01-30 16:15:25] [index:background] Health check
[2024-01-30 16:20:02] [indexer:background] Health check
[2024-01-30 16:20:27] [index:background] Health check
[2024-01-30 16:25:02] [indexer:background] Health check
[2024-01-30 16:25:27] [index:background] Health check
[2024-01-30 16:30:07] [indexer:background] Health check
[2024-01-30 16:30:30] [index:background] Health check
[2024-01-30 16:34:58] [indexer:background] Health check
[2024-01-30 16:35:27] [index:background] Health check
[2024-01-30 16:40:01] [indexer:background] Health check
[2024-01-30 16:40:01] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2]
[2024-01-30 16:41:19] [index:background] Health check
[2024-01-30 16:41:19] [index:background] CPU load threshold (3) breached: 3.27 [waiting 2]
[2024-01-30 16:41:21] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-01-30 16:44:59] [indexer:background] Health check
[2024-01-30 16:44:59] [indexer:background] CPU load threshold (3) breached: 3.12 [waiting 2]
[2024-01-30 16:45:26] [index:background] Health check
[2024-01-30 16:45:26] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-01-30 16:45:28] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2024-01-30 16:50:03] [indexer:background] Health check
[2024-01-30 16:50:03] [indexer:background] CPU load threshold (3) breached: 3.36 [waiting 2]
[2024-01-30 16:50:26] [index:background] Health check
[2024-01-30 16:50:26] [index:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-01-30 16:50:28] [indexer:background] CPU load threshold (3) breached: 3.02 [waiting 2]
[2024-01-30 16:55:08] [indexer:background] Health check
[2024-01-30 16:55:26] [index:background] Health check
[2024-01-30 16:59:59] [indexer:background] Health check
[2024-01-30 17:00:26] [index:background] Health check
[2024-01-30 17:05:27] [indexer:background] Health check
[2024-01-30 17:05:28] [index:background] Health check
[2024-01-30 17:11:08] [indexer:background] Health check
[2024-01-30 17:11:08] [index:background] Health check
[2024-01-30 17:15:03] [indexer:background] Health check
[2024-01-30 17:15:30] [index:background] Health check
[2024-01-30 17:20:02] [indexer:background] Health check
[2024-01-30 17:20:27] [index:background] Health check
[2024-01-30 17:24:59] [indexer:background] Health check
[2024-01-30 17:25:31] [index:background] Health check
[2024-01-30 17:30:02] [indexer:background] Health check
[2024-01-30 17:30:31] [index:background] Health check
[2024-01-30 17:34:59] [indexer:background] Health check
[2024-01-30 17:35:31] [index:background] Health check
[2024-01-30 17:39:59] [indexer:background] Health check
[2024-01-30 17:40:27] [index:background] Health check
[2024-01-30 17:44:59] [indexer:background] Health check
[2024-01-30 17:45:26] [index:background] Health check
[2024-01-30 17:50:02] [indexer:background] Health check
[2024-01-30 17:50:26] [index:background] Health check
[2024-01-30 17:55:02] [indexer:background] Health check
[2024-01-30 17:55:27] [index:background] Health check
[2024-01-30 17:59:59] [indexer:background] Health check
[2024-01-30 18:00:26] [index:background] Health check
[2024-01-30 18:05:02] [indexer:background] Health check
[2024-01-30 18:05:27] [index:background] Health check
[2024-01-30 18:09:59] [indexer:background] Health check
[2024-01-30 18:10:26] [index:background] Health check
[2024-01-30 18:14:58] [indexer:background] Health check
[2024-01-30 18:15:26] [index:background] Health check
[2024-01-30 18:20:04] [indexer:background] Health check
[2024-01-30 18:20:26] [index:background] Health check
[2024-01-30 18:25:18] [indexer:background] Health check
[2024-01-30 18:25:27] [index:background] Health check
[2024-01-30 18:29:59] [indexer:background] Health check
[2024-01-30 18:30:26] [index:background] Health check
[2024-01-30 18:35:16] [indexer:background] Health check
[2024-01-30 18:35:26] [index:background] Health check
[2024-01-30 18:40:06] [indexer:background] Health check
[2024-01-30 18:40:59] [index:background] Health check
[2024-01-30 18:42:50] [query] Query for: {search_term_string}
[2024-01-30 18:42:50] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 2 offset: 0 fields: all
[2024-01-30 18:42:50] [query] Engine: default
[2024-01-30 18:42:50] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-01-30 18:42:50] [query] Mods: 6
[2024-01-30 18:42:50] [query] Using OR logic
[2024-01-30 18:42:51] [query] Found results using: or logic
[2024-01-30 18:42:51] [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 10, 10
[2024-01-30 18:42:51] [query] Results: 1348 Pages of results: 135
[2024-01-30 18:42:51] [query] Execution time: 1.43945
[2024-01-30 18:44:59] [indexer:background] Health check
[2024-01-30 18:45:26] [index:background] Health check
[2024-01-30 18:50:01] [indexer:background] Health check
[2024-01-30 18:50:26] [index:background] Health check
[2024-01-30 18:55:03] [indexer:background] Health check
[2024-01-30 18:55:26] [index:background] Health check
[2024-01-30 19:00:02] [indexer:background] Health check
[2024-01-30 19:00:31] [index:background] Health check
[2024-01-30 19:05:41] [indexer:background] Health check
[2024-01-30 19:05:41] [index:background] Health check
[2024-01-30 19:10:03] [indexer:background] Health check
[2024-01-30 19:10:25] [index:background] Health check
[2024-01-30 19:14:59] [indexer:background] Health check
[2024-01-30 19:15:32] [index:background] Health check
[2024-01-30 19:19:59] [indexer:background] Health check
[2024-01-30 19:20:25] [index:background] Health check
[2024-01-30 19:25:05] [indexer:background] Health check
[2024-01-30 19:25:28] [index:background] Health check
[2024-01-30 19:29:59] [indexer:background] Health check
[2024-01-30 19:30:26] [index:background] Health check
[2024-01-30 19:35:00] [indexer:background] Health check
[2024-01-30 19:35:27] [index:background] Health check
[2024-01-30 19:40:04] [indexer:background] Health check
[2024-01-30 19:40:30] [index:background] Health check
[2024-01-30 19:44:59] [indexer:background] Health check
[2024-01-30 19:45:27] [index:background] Health check
[2024-01-30 19:50:04] [indexer:background] Health check
[2024-01-30 19:50:27] [index:background] Health check
[2024-01-30 19:54:59] [indexer:background] Health check
[2024-01-30 19:55:26] [index:background] Health check
[2024-01-30 19:59:59] [indexer:background] Health check
[2024-01-30 20:00:24] [index:background] Health check
[2024-01-30 20:05:00] [indexer:background] Health check
[2024-01-30 20:05:32] [index:background] Health check
[2024-01-30 20:09:59] [indexer:background] Health check
[2024-01-30 20:10:32] [index:background] Health check
[2024-01-30 20:14:59] [indexer:background] Health check
[2024-01-30 20:15:30] [index:background] Health check
[2024-01-30 20:19:59] [indexer:background] Health check
[2024-01-30 20:20:24] [index:background] Health check
[2024-01-30 20:25:14] [indexer:background] Health check
[2024-01-30 20:25:48] [index:background] Health check
[2024-01-30 20:30:57] [indexer:background] Health check
[2024-01-30 20:30:57] [index:background] Health check
[2024-01-30 20:34:59] [indexer:background] Health check
[2024-01-30 20:35:27] [index:background] Health check
[2024-01-30 20:40:00] [indexer:background] Health check
[2024-01-30 20:40:27] [index:background] Health check
[2024-01-30 20:44:59] [indexer:background] Health check
[2024-01-30 20:45:27] [index:background] Health check
[2024-01-30 20:50:08] [indexer:background] Health check
[2024-01-30 20:50:28] [index:background] Health check
[2024-01-30 20:54:58] [indexer:background] Health check
[2024-01-30 20:55:26] [index:background] Health check
[2024-01-30 20:59:59] [indexer:background] Health check
[2024-01-30 21:00:32] [index:background] Health check
[2024-01-30 21:04:59] [indexer:background] Health check
[2024-01-30 21:05:32] [index:background] Health check
[2024-01-30 21:09:59] [indexer:background] Health check
[2024-01-30 21:10:26] [index:background] Health check
[2024-01-30 21:15:00] [indexer:background] Health check
[2024-01-30 21:15:27] [index:background] Health check
[2024-01-30 21:19:59] [indexer:background] Health check
[2024-01-30 21:20:24] [index:background] Health check
[2024-01-30 21:24:59] [indexer:background] Health check
[2024-01-30 21:25:24] [index:background] Health check
[2024-01-30 21:30:08] [indexer:background] Health check
[2024-01-30 21:30:37] [index:background] Health check
[2024-01-30 21:34:59] [indexer:background] Health check
[2024-01-30 21:35:24] [index:background] Health check
[2024-01-30 21:39:59] [indexer:background] Health check
[2024-01-30 21:40:27] [index:background] Health check
[2024-01-30 21:46:03] [indexer:background] Health check
[2024-01-30 21:46:03] [index:background] Health check
[2024-01-30 21:50:00] [indexer:background] Health check
[2024-01-30 21:50:27] [index:background] Health check
[2024-01-30 21:54:59] [indexer:background] Health check
[2024-01-30 21:55:24] [index:background] Health check
[2024-01-30 21:59:58] [indexer:background] Health check
[2024-01-30 22:00:24] [index:background] Health check
[2024-01-30 22:04:59] [indexer:background] Health check
[2024-01-30 22:05:27] [index:background] Health check
[2024-01-30 22:10:04] [indexer:background] Health check
[2024-01-30 22:10:27] [index:background] Health check
[2024-01-30 22:15:00] [indexer:background] Health check
[2024-01-30 22:15:27] [index:background] Health check
[2024-01-30 22:19:59] [indexer:background] Health check
[2024-01-30 22:20:32] [index:background] Health check
[2024-01-30 22:24:59] [indexer:background] Health check
[2024-01-30 22:25:28] [index:background] Health check
[2024-01-30 22:29:59] [indexer:background] Health check
[2024-01-30 22:30:24] [index:background] Health check
[2024-01-30 22:34:59] [indexer:background] Health check
[2024-01-30 22:35:28] [index:background] Health check
[2024-01-30 22:39:59] [indexer:background] Health check
[2024-01-30 22:40:30] [index:background] Health check
[2024-01-30 22:45:27] [indexer:background] Health check
[2024-01-30 22:45:27] [index:background] Health check
[2024-01-30 22:49:58] [indexer:background] Health check
[2024-01-30 22:50:27] [index:background] Health check
[2024-01-30 22:55:00] [indexer:background] Health check
[2024-01-30 22:55:27] [index:background] Health check
[2024-01-30 22:59:59] [indexer:background] Health check
[2024-01-30 23:00:28] [index:background] Health check
[2024-01-30 23:05:10] [indexer:background] Health check
[2024-01-30 23:07:16] [index:background] Health check
[2024-01-30 23:09:58] [indexer:background] Health check
[2024-01-30 23:10:28] [index:background] Health check
[2024-01-30 23:15:22] [indexer:background] Health check
[2024-01-30 23:15:27] [index:background] Health check
[2024-01-30 23:19:59] [indexer:background] Health check
[2024-01-30 23:20:27] [index:background] Health check
[2024-01-30 23:25:03] [indexer:background] Health check
[2024-01-30 23:25:27] [index:background] Health check
[2024-01-30 23:30:04] [indexer:background] Health check
[2024-01-30 23:30:24] [index:background] Health check
[2024-01-30 23:35:00] [indexer:background] Health check
[2024-01-30 23:35:27] [index:background] Health check
[2024-01-30 23:40:00] [indexer:background] Health check
[2024-01-30 23:40:26] [index:background] Health check
[2024-01-30 23:44:59] [indexer:background] Health check
[2024-01-30 23:45:25] [index:background] Health check
[2024-01-30 23:50:00] [indexer:background] Health check
[2024-01-30 23:50:27] [index:background] Health check
[2024-01-30 23:54:58] [indexer:background] Health check
[2024-01-30 23:55:26] [index:background] Health check
[2024-01-30 23:59:59] [indexer:background] Health check