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