[2024-02-08 00:00:53] [indexer:background] Health check
[2024-02-08 00:00:53] [index:background] Health check
[2024-02-08 00:08:04] [indexer:background] Health check
[2024-02-08 00:08:04] [index:background] Health check
[2024-02-08 00:10:35] [indexer:background] Health check
[2024-02-08 00:10:35] [index:background] Health check
[2024-02-08 00:15:01] [indexer:background] Health check
[2024-02-08 00:15:24] [index:background] Health check
[2024-02-08 00:20:01] [indexer:background] Health check
[2024-02-08 00:21:26] [index:background] Health check
[2024-02-08 00:25:34] [indexer:background] Health check
[2024-02-08 00:25:34] [index:background] Health check
[2024-02-08 00:30:00] [indexer:background] Health check
[2024-02-08 00:30:28] [index:background] Health check
[2024-02-08 00:35:20] [indexer:background] Health check
[2024-02-08 00:36:40] [index:background] Health check
[2024-02-08 00:40:02] [indexer:background] Health check
[2024-02-08 00:40:35] [index:background] Health check
[2024-02-08 00:45:24] [indexer:background] Health check
[2024-02-08 00:45:24] [index:background] Health check
[2024-02-08 00:51:08] [indexer:background] Health check
[2024-02-08 00:51:08] [index:background] Health check
[2024-02-08 00:54:59] [indexer:background] Health check
[2024-02-08 00:55:25] [index:background] Health check
[2024-02-08 01:00:26] [indexer:background] Health check
[2024-02-08 01:00:26] [index:background] Health check
[2024-02-08 01:06:24] [indexer:background] Health check
[2024-02-08 01:06:24] [index:background] Health check
[2024-02-08 01:10:53] [indexer:background] Health check
[2024-02-08 01:10:53] [index:background] Health check
[2024-02-08 01:15:50] [indexer:background] Health check
[2024-02-08 01:15:50] [index:background] Health check
[2024-02-08 01:20:16] [indexer:background] Health check
[2024-02-08 01:20:48] [index:background] Health check
[2024-02-08 01:25:00] [indexer:background] Health check
[2024-02-08 01:28:21] [index:background] Health check
[2024-02-08 01:30:03] [indexer:background] Health check
[2024-02-08 01:35:26] [index:background] Health check
[2024-02-08 01:35:27] [indexer:background] Health check
[2024-02-08 01:35:27] [indexer:background] Health check
[2024-02-08 01:42:29] [indexer:background] Health check
[2024-02-08 01:42:29] [index:background] Health check
[2024-02-08 01:46:20] [indexer:background] Health check
[2024-02-08 01:46:20] [index:background] Health check
[2024-02-08 01:50:29] [indexer:background] Health check
[2024-02-08 01:50:29] [index:background] Health check
[2024-02-08 01:55:04] [indexer:background] Health check
[2024-02-08 01:57:24] [index:background] Health check
[2024-02-08 02:00:13] [indexer:background] Health check
[2024-02-08 02:00:45] [index:background] Health check
[2024-02-08 02:05:49] [indexer:background] Health check
[2024-02-08 02:05:49] [index:background] Health check
[2024-02-08 02:10:27] [indexer:background] Health check
[2024-02-08 02:10:27] [index:background] Health check
[2024-02-08 02:17:51] [indexer:background] Health check
[2024-02-08 02:17:51] [index:background] Health check
[2024-02-08 02:21:13] [indexer:background] Health check
[2024-02-08 02:21:13] [index:background] Health check
[2024-02-08 02:26:20] [indexer:background] Health check
[2024-02-08 02:26:20] [index:background] Health check
[2024-02-08 02:30:40] [indexer:background] Health check
[2024-02-08 02:30:40] [index:background] Health check
[2024-02-08 02:35:01] [indexer:background] Health check
[2024-02-08 02:36:28] [index:background] Health check
[2024-02-08 02:40:23] [indexer:background] Health check
[2024-02-08 02:40:23] [index:background] Health check
[2024-02-08 02:45:12] [indexer:background] Health check
[2024-02-08 02:45:42] [index:background] Health check
[2024-02-08 02:45:42] [index:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-02-08 02:45:44] [indexer:background] CPU load threshold (3) breached: 3.18 [waiting 2]
[2024-02-08 02:51:17] [indexer:background] Health check
[2024-02-08 02:51:17] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2024-02-08 02:51:19] [index:background] Health check
[2024-02-08 02:51:19] [index:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2024-02-08 02:51:21] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2024-02-08 02:55:26] [indexer:background] Health check
[2024-02-08 02:55:27] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-02-08 02:55:29] [index:background] Health check
[2024-02-08 02:55:29] [index:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2024-02-08 02:55:31] [indexer:background] CPU load threshold (3) breached: 3.65 [waiting 2]
[2024-02-08 03:00:27] [indexer:background] Health check
[2024-02-08 03:00:27] [index:background] Health check
[2024-02-08 03:06:06] [indexer:background] Health check
[2024-02-08 03:06:06] [index:background] Health check
[2024-02-08 03:09:57] [indexer:background] Health check
[2024-02-08 03:09:57] [indexer:background] CPU load threshold (3) breached: 3.78 [waiting 2]
[2024-02-08 03:17:10] [index:background] Health check
[2024-02-08 03:17:10] [index:background] CPU load threshold (3) breached: 3.68 [waiting 2]
[2024-02-08 03:17:12] [indexer:background] CPU load threshold (3) breached: 3.68 [waiting 2]
[2024-02-08 03:17:14] [indexer:background] Health check
[2024-02-08 03:17:14] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2024-02-08 03:17:16] [indexer:background] Health check
[2024-02-08 03:17:17] [indexer:background] CPU load threshold (3) breached: 3.63 [waiting 2]
[2024-02-08 03:21:31] [indexer:background] Health check
[2024-02-08 03:21:31] [indexer:background] CPU load threshold (3) breached: 4.08 [waiting 2]
[2024-02-08 03:21:33] [index:background] Health check
[2024-02-08 03:21:33] [index:background] CPU load threshold (3) breached: 4.08 [waiting 2]
[2024-02-08 03:21:35] [indexer:background] CPU load threshold (3) breached: 4 [waiting 2]
[2024-02-08 03:25:03] [indexer:background] Health check
[2024-02-08 03:29:08] [index:background] Health check
[2024-02-08 03:29:08] [index:background] CPU load threshold (3) breached: 3.16 [waiting 2]
[2024-02-08 03:29:10] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-02-08 03:30:12] [indexer:background] Health check
[2024-02-08 03:30:12] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2024-02-08 03:32:09] [index:background] Health check
[2024-02-08 03:35:41] [indexer:background] Health check
[2024-02-08 03:35:41] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2024-02-08 03:35:43] [index:background] Health check
[2024-02-08 03:35:43] [index:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2024-02-08 03:35:45] [indexer:background] CPU load threshold (3) breached: 3.89 [waiting 2]
[2024-02-08 03:43:36] [indexer:background] Health check
[2024-02-08 03:43:36] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2024-02-08 03:43:38] [index:background] Health check
[2024-02-08 03:43:38] [index:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2024-02-08 03:43:40] [indexer:background] CPU load threshold (3) breached: 3.58 [waiting 2]
[2024-02-08 03:46:53] [indexer:background] Health check
[2024-02-08 03:46:53] [indexer:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2024-02-08 03:46:55] [index:background] Health check
[2024-02-08 03:46:55] [index:background] CPU load threshold (3) breached: 3.32 [waiting 2]
[2024-02-08 03:46:57] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2024-02-08 03:52:00] [indexer:background] Health check
[2024-02-08 03:52:00] [indexer:background] CPU load threshold (3) breached: 4.56 [waiting 2]
[2024-02-08 03:52:02] [index:background] Health check
[2024-02-08 03:52:02] [index:background] CPU load threshold (3) breached: 4.68 [waiting 2]
[2024-02-08 03:52:04] [indexer:background] CPU load threshold (3) breached: 4.68 [waiting 2]
[2024-02-08 03:56:04] [indexer:background] Health check
[2024-02-08 03:56:04] [indexer:background] CPU load threshold (3) breached: 3.33 [waiting 2]
[2024-02-08 03:56:06] [index:background] Health check
[2024-02-08 03:56:06] [index:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2024-02-08 03:56:08] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2024-02-08 04:00:40] [indexer:background] Health check
[2024-02-08 04:00:40] [index:background] Health check
[2024-02-08 04:04:58] [indexer:background] Health check
[2024-02-08 04:05:24] [index:background] Health check
[2024-02-08 04:10:01] [indexer:background] Health check
[2024-02-08 04:10:32] [index:background] Health check
[2024-02-08 04:16:08] [indexer:background] Health check
[2024-02-08 04:16:08] [index:background] Health check
[2024-02-08 04:23:22] [indexer:background] Health check
[2024-02-08 04:23:22] [index:background] Health check
[2024-02-08 04:25:05] [indexer:background] Health check
[2024-02-08 04:31:48] [index:background] Health check
[2024-02-08 04:31:53] [indexer:background] Health check
[2024-02-08 04:31:53] [indexer:background] Health check
[2024-02-08 04:39:30] [indexer:background] Health check
[2024-02-08 04:39:30] [index:background] Health check
[2024-02-08 04:41:08] [indexer:background] Health check
[2024-02-08 04:41:08] [index:background] Health check
[2024-02-08 04:47:23] [indexer:background] Health check
[2024-02-08 04:47:23] [index:background] Health check
[2024-02-08 04:48:21] [query] Query for: 2024
[2024-02-08 04:48:21] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 04:48:21] [query] Engine: default
[2024-02-08 04:48:21] [query] Tokens: 2024
[2024-02-08 04:48:21] [query] Mods: 6
[2024-02-08 04:48:21] [query] Found results using: or logic
[2024-02-08 04:48: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-02-08 04:48:21] [query] Results: 136 Pages of results: 14
[2024-02-08 04:48:21] [query] Execution time: 0.43432
[2024-02-08 04:51:01] [indexer:background] Health check
[2024-02-08 04:51:01] [index:background] Health check
[2024-02-08 04:55:51] [indexer:background] Health check
[2024-02-08 04:55:51] [index:background] Health check
[2024-02-08 05:00:07] [indexer:background] Health check
[2024-02-08 05:00:41] [index:background] Health check
[2024-02-08 05:05:47] [indexer:background] Health check
[2024-02-08 05:05:47] [index:background] Health check
[2024-02-08 05:10:01] [indexer:background] Health check
[2024-02-08 05:10:48] [index:background] Health check
[2024-02-08 05:15:49] [indexer:background] Health check
[2024-02-08 05:15:49] [index:background] Health check
[2024-02-08 05:20:06] [indexer:background] Health check
[2024-02-08 05:21:43] [index:background] Health check
[2024-02-08 05:25:55] [indexer:background] Health check
[2024-02-08 05:25:55] [index:background] Health check
[2024-02-08 05:30:01] [indexer:background] Health check
[2024-02-08 05:30:24] [index:background] Health check
[2024-02-08 05:38:20] [indexer:background] Health check
[2024-02-08 05:38:20] [index:background] Health check
[2024-02-08 05:40:20] [indexer:background] Health check
[2024-02-08 05:40:24] [index:background] Health check
[2024-02-08 05:45:19] [indexer:background] Health check
[2024-02-08 05:45:57] [index:background] Health check
[2024-02-08 05:50:52] [indexer:background] Health check
[2024-02-08 05:50:52] [index:background] Health check
[2024-02-08 05:58:15] [indexer:background] Health check
[2024-02-08 05:58:15] [index:background] Health check
[2024-02-08 06:01:13] [indexer:background] Health check
[2024-02-08 06:01:13] [index:background] Health check
[2024-02-08 06:05:58] [indexer:background] Health check
[2024-02-08 06:05:58] [index:background] Health check
[2024-02-08 06:12:29] [indexer:background] Health check
[2024-02-08 06:12:29] [index:background] Health check
[2024-02-08 06:16:10] [indexer:background] Health check
[2024-02-08 06:16:10] [index:background] Health check
[2024-02-08 06:20:07] [indexer:background] Health check
[2024-02-08 06:21:07] [index:background] Health check
[2024-02-08 06:25:42] [indexer:background] Health check
[2024-02-08 06:25:42] [index:background] Health check
[2024-02-08 06:32:07] [indexer:background] Health check
[2024-02-08 06:32:07] [index:background] Health check
[2024-02-08 06:36:16] [indexer:background] Health check
[2024-02-08 06:36:16] [index:background] Health check
[2024-02-08 06:42:02] [indexer:background] Health check
[2024-02-08 06:42:02] [index:background] Health check
[2024-02-08 06:46:16] [indexer:background] Health check
[2024-02-08 06:46:16] [index:background] Health check
[2024-02-08 06:50:08] [indexer:background] Health check
[2024-02-08 06:50:37] [index:background] Health check
[2024-02-08 06:56:36] [indexer:background] Health check
[2024-02-08 06:56:36] [index:background] Health check
[2024-02-08 07:01:01] [indexer:background] Health check
[2024-02-08 07:01:01] [index:background] Health check
[2024-02-08 07:07:30] [indexer:background] Health check
[2024-02-08 07:07:30] [index:background] Health check
[2024-02-08 07:11:21] [indexer:background] Health check
[2024-02-08 07:11:21] [index:background] Health check
[2024-02-08 07:14:57] [indexer:background] Health check
[2024-02-08 07:17:41] [index:background] Health check
[2024-02-08 07:20:07] [indexer:background] Health check
[2024-02-08 07:21:47] [index:background] Health check
[2024-02-08 07:24:59] [indexer:background] Health check
[2024-02-08 07:25:35] [index:background] Health check
[2024-02-08 07:30:49] [indexer:background] Health check
[2024-02-08 07:30:49] [index:background] Health check
[2024-02-08 07:37:10] [indexer:background] Health check
[2024-02-08 07:37:10] [index:background] Health check
[2024-02-08 07:40:23] [indexer:background] Health check
[2024-02-08 07:40:23] [index:background] Health check
[2024-02-08 07:47:12] [indexer:background] Health check
[2024-02-08 07:47:12] [index:background] Health check
[2024-02-08 07:50:46] [indexer:background] Health check
[2024-02-08 07:50:46] [index:background] Health check
[2024-02-08 07:56:07] [indexer:background] Health check
[2024-02-08 07:56:07] [index:background] Health check
[2024-02-08 08:00:07] [indexer:background] Health check
[2024-02-08 08:03:31] [index:background] Health check
[2024-02-08 08:06:37] [indexer:background] Health check
[2024-02-08 08:06:37] [index:background] Health check
[2024-02-08 08:11:20] [indexer:background] Health check
[2024-02-08 08:11:20] [index:background] Health check
[2024-02-08 08:16:12] [indexer:background] Health check
[2024-02-08 08:16:12] [index:background] Health check
[2024-02-08 08:21:08] [indexer:background] Health check
[2024-02-08 08:21:08] [index:background] Health check
[2024-02-08 08:25:18] [indexer:background] Health check
[2024-02-08 08:26:44] [index:background] Health check
[2024-02-08 08:29:59] [indexer:background] Health check
[2024-02-08 08:30:24] [index:background] Health check
[2024-02-08 08:34:58] [indexer:background] Health check
[2024-02-08 08:35:31] [index:background] Health check
[2024-02-08 08:35:39] [query] Query for: 2024
[2024-02-08 08:35:39] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 08:35:39] [query] Engine: default
[2024-02-08 08:35:39] [query] Tokens: 2024
[2024-02-08 08:35:39] [query] Mods: 6
[2024-02-08 08:35:39] [query] Found results using: or logic
[2024-02-08 08:35:39] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-02-08 08:35:39] [query] Results: 136 Pages of results: 14
[2024-02-08 08:35:39] [query] Execution time: 0.04017
[2024-02-08 08:40:07] [indexer:background] Health check
[2024-02-08 08:40:25] [index:background] Health check
[2024-02-08 08:44:59] [indexer:background] Health check
[2024-02-08 08:45:24] [index:background] Health check
[2024-02-08 08:49:59] [indexer:background] Health check
[2024-02-08 08:50:33] [index:background] Health check
[2024-02-08 08:55:05] [indexer:background] Health check
[2024-02-08 08:55:05] [indexer] Queued next batch (1)
[2024-02-08 08:55:08] [indexer] Processing batch (1)
[2024-02-08 08:55:08] [indexer] Indexing post.attachment:14783
[2024-02-08 08:55:08] [index] Marking [1] post.attachment 14783 as indexed
[2024-02-08 08:55:08] [indexer] Index built
[2024-02-08 08:55:26] [index:background] Health check
[2024-02-08 09:00:12] [indexer:background] Health check
[2024-02-08 09:00:27] [index:background] Health check
[2024-02-08 09:00:34] [query] Query for: 2023
[2024-02-08 09:00:34] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 09:00:34] [query] Engine: default
[2024-02-08 09:00:34] [query] Tokens: 2023
[2024-02-08 09:00:34] [query] Mods: 6
[2024-02-08 09:00:35] [query] Found results using: or logic
[2024-02-08 09:00: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 (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-02-08 09:00:35] [query] Results: 259 Pages of results: 26
[2024-02-08 09:00:35] [query] Execution time: 1.00619
[2024-02-08 09:00:35] [query] Query for: 2023
[2024-02-08 09:00:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-02-08 09:00:35] [query] Engine: default
[2024-02-08 09:00:35] [query] Tokens: 2023
[2024-02-08 09:00:35] [query] Mods: 6
[2024-02-08 09:00:35] [query] Found results using: or logic
[2024-02-08 09:00: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 (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-02-08 09:00:35] [query] Results: 259 Pages of results: 3
[2024-02-08 09:00:35] [query] Execution time: 0.11535
[2024-02-08 09:05:04] [indexer:background] Health check
[2024-02-08 09:05:29] [index:background] Health check
[2024-02-08 09:10:02] [indexer:background] Health check
[2024-02-08 09:10:02] [indexer] Queued next batch (1)
[2024-02-08 09:10:05] [indexer] Processing batch (1)
[2024-02-08 09:10:05] [indexer] Indexing post.attachment:14794
[2024-02-08 09:10:06] [index] Marking [1] post.attachment 14794 as indexed
[2024-02-08 09:10:06] [indexer] Index built
[2024-02-08 09:10:33] [index:background] Health check
[2024-02-08 09:15:02] [indexer:background] Health check
[2024-02-08 09:15:02] [indexer] Queued next batch (1)
[2024-02-08 09:15:04] [indexer] Processing batch (1)
[2024-02-08 09:15:04] [indexer] Indexing post.attachment:14799
[2024-02-08 09:15:07] [index] Marking [1] post.attachment 14799 as indexed
[2024-02-08 09:15:07] [indexer] Index built
[2024-02-08 09:15:32] [index:background] Health check
[2024-02-08 09:20:13] [indexer:background] Health check
[2024-02-08 09:20:13] [indexer] Queued next batch (1)
[2024-02-08 09:20:15] [indexer] Processing batch (1)
[2024-02-08 09:20:15] [indexer] Indexing post.attachment:14805
[2024-02-08 09:20:17] [index] Marking [1] post.attachment 14805 as indexed
[2024-02-08 09:20:17] [indexer] Index built
[2024-02-08 09:20:28] [index:background] Health check
[2024-02-08 09:25:02] [indexer:background] Health check
[2024-02-08 09:25:02] [indexer] Queued next batch (1)
[2024-02-08 09:25:05] [indexer] Processing batch (1)
[2024-02-08 09:25:05] [indexer] Indexing post.attachment:14811
[2024-02-08 09:25:06] [index] Marking [1] post.attachment 14811 as indexed
[2024-02-08 09:25:06] [indexer] Index built
[2024-02-08 09:25:06] [indexer:background] CPU load threshold (3) breached: 3.19 [waiting 2]
[2024-02-08 09:26:31] [index:background] Health check
[2024-02-08 09:26:31] [indexer] Queued next batch (1)
[2024-02-08 09:26:34] [indexer] Processing batch (1)
[2024-02-08 09:26:34] [indexer] Indexing post.attachment:14817
[2024-02-08 09:26:41] [index] Marking [1] post.attachment 14817 as indexed
[2024-02-08 09:26:41] [indexer] Index built
[2024-02-08 09:30:01] [indexer:background] Health check
[2024-02-08 09:30:33] [index:background] Health check
[2024-02-08 09:35:02] [indexer:background] Health check
[2024-02-08 09:35:02] [indexer] Queued next batch (1)
[2024-02-08 09:35:02] [indexer:background] CPU load threshold (3) breached: 3.16 [waiting 2]
[2024-02-08 09:35:07] [indexer] Processing batch (1)
[2024-02-08 09:35:07] [indexer] Indexing post.attachment:14820
[2024-02-08 09:35:08] [index] Marking [1] post.attachment 14820 as indexed
[2024-02-08 09:35:08] [indexer] Index built
[2024-02-08 09:35:08] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-02-08 09:36:05] [index:background] Health check
[2024-02-08 09:39:59] [indexer:background] Health check
[2024-02-08 09:40:35] [index:background] Health check
[2024-02-08 09:45:03] [indexer:background] Health check
[2024-02-08 09:45:42] [index:background] Health check
[2024-02-08 09:50:03] [indexer:background] Health check
[2024-02-08 09:50:40] [index:background] Health check
[2024-02-08 09:56:51] [indexer:background] Health check
[2024-02-08 09:56:51] [index:background] Health check
[2024-02-08 10:00:35] [indexer:background] Health check
[2024-02-08 10:00:35] [index:background] Health check
[2024-02-08 10:07:19] [query] Query for: arrete-n�-12914_2014_finance-publique-impots-et-douanes_tresorerie-paierie-generale.pdf
[2024-02-08 10:07:19] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 10:07:19] [query] Engine: default
[2024-02-08 10:07:19] [indexer:background] Health check
[2024-02-08 10:07:19] [index:background] Health check
[2024-02-08 10:07:20] [query] Tokens: paierie, finances, finance, financer, financa, financée, financé, finançant, financant, financez, financera, financeront, financie, financs, financi, impots, financements, paieries, paieri, publiques, publique, publication, publications, publiquea, publicité, publicités, publiquement, publiqua, publiqui, publicateur, tresorerie, tresoreries, arrete, arrets, arreta, arrété, arreté, arretera, arreteront, arrèté, arretant, arrétées, arretea, arrète, financement, arreter, arréter, arretie, arrèt, arréte, douanes, douane, douanement, douani, douanies, arretes, douans, douana, financées, financés, arret, n�, 12914, 2014, financ, publiqu, impot, douan
[2024-02-08 10:07:20] [query] Mods: 6
[2024-02-08 10:07:20] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2024-02-08 10:07:20] [query] Using OR logic
[2024-02-08 10:07:27] [query] Found results using: or logic
[2024-02-08 10:07:27] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (108725,922,1221,8804,10800,15019,27032,27653,28790,34790,38664,147650,178508,418789,507839,4762,8009,473752,751413,866,1043,4943,5187,10823,13418,49505,77759,711996,763135,784579,17134,376646,17551,45128,51347,69901,69934,130628,219790,353841,376604,478327,503204,514969,858,28780,575556,586210,689535,799275,526,636,22019,245023,700272,4766,737898,804431,221,799,2865,770525,484734,1361,690302,692852,16968,709775) 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-02-08 10:07:27] [query] Results: 3822 Pages of results: 383
[2024-02-08 10:07:27] [query] Execution time: 8.15884
[2024-02-08 10:12:19] [indexer:background] Health check
[2024-02-08 10:12:19] [index:background] Health check
[2024-02-08 10:15:37] [indexer:background] Health check
[2024-02-08 10:15:37] [index:background] Health check
[2024-02-08 10:20:10] [indexer:background] Health check
[2024-02-08 10:21:12] [index:background] Health check
[2024-02-08 10:25:00] [indexer:background] Health check
[2024-02-08 10:25:32] [index:background] Health check
[2024-02-08 10:30:03] [query] Query for: 2024
[2024-02-08 10:30:03] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 10:30:03] [query] Engine: default
[2024-02-08 10:30:03] [indexer:background] Health check
[2024-02-08 10:30:03] [query] Tokens: 2024
[2024-02-08 10:30:03] [query] Mods: 6
[2024-02-08 10:30:03] [query] Found results using: or logic
[2024-02-08 10:30:03] [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-02-08 10:30:03] [query] Results: 136 Pages of results: 14
[2024-02-08 10:30:03] [query] Execution time: 0.26159
[2024-02-08 10:31:00] [index:background] Health check
[2024-02-08 10:35:27] [indexer:background] Health check
[2024-02-08 10:35:27] [index:background] Health check
[2024-02-08 10:40:47] [indexer:background] Health check
[2024-02-08 10:40:47] [index:background] Health check
[2024-02-08 10:45:56] [indexer:background] Health check
[2024-02-08 10:45:56] [index:background] Health check
[2024-02-08 10:50:22] [indexer:background] Health check
[2024-02-08 10:50:46] [index:background] Health check
[2024-02-08 10:55:09] [indexer:background] Health check
[2024-02-08 10:56:09] [index:background] Health check
[2024-02-08 11:00:22] [indexer:background] Health check
[2024-02-08 11:00:54] [index:background] Health check
[2024-02-08 11:05:39] [indexer:background] Health check
[2024-02-08 11:05:39] [index:background] Health check
[2024-02-08 11:10:00] [indexer:background] Health check
[2024-02-08 11:10:45] [index:background] Health check
[2024-02-08 11:15:22] [indexer:background] Health check
[2024-02-08 11:15:28] [index:background] Health check
[2024-02-08 11:20:45] [indexer:background] Health check
[2024-02-08 11:20:45] [index:background] Health check
[2024-02-08 11:27:09] [indexer:background] Health check
[2024-02-08 11:27:09] [index:background] Health check
[2024-02-08 11:30:35] [indexer:background] Health check
[2024-02-08 11:30:35] [index:background] Health check
[2024-02-08 11:35:03] [indexer:background] Health check
[2024-02-08 11:35:47] [index:background] Health check
[2024-02-08 11:40:39] [indexer:background] Health check
[2024-02-08 11:40:39] [index:background] Health check
[2024-02-08 11:45:50] [indexer:background] Health check
[2024-02-08 11:45:50] [index:background] Health check
[2024-02-08 11:50:06] [indexer:background] Health check
[2024-02-08 11:50:28] [index:background] Health check
[2024-02-08 11:55:37] [indexer:background] Health check
[2024-02-08 11:55:37] [index:background] Health check
[2024-02-08 12:01:38] [indexer:background] Health check
[2024-02-08 12:01:38] [index:background] Health check
[2024-02-08 12:05:00] [indexer:background] Health check
[2024-02-08 12:05:38] [index:background] Health check
[2024-02-08 12:10:00] [indexer:background] Health check
[2024-02-08 12:13:10] [index:background] Health check
[2024-02-08 12:15:34] [indexer:background] Health check
[2024-02-08 12:15:34] [index:background] Health check
[2024-02-08 12:20:01] [indexer:background] Health check
[2024-02-08 12:21:30] [index:background] Health check
[2024-02-08 12:25:10] [indexer:background] Health check
[2024-02-08 12:25:53] [index:background] Health check
[2024-02-08 12:29:58] [indexer:background] Health check
[2024-02-08 12:30:27] [index:background] Health check
[2024-02-08 12:35:11] [indexer:background] Health check
[2024-02-08 12:37:18] [index:background] Health check
[2024-02-08 12:41:06] [indexer:background] Health check
[2024-02-08 12:41:06] [index:background] Health check
[2024-02-08 12:46:28] [indexer:background] Health check
[2024-02-08 12:46:28] [index:background] Health check
[2024-02-08 12:50:02] [indexer:background] Health check
[2024-02-08 12:50:25] [index:background] Health check
[2024-02-08 12:55:24] [indexer:background] Health check
[2024-02-08 12:55:24] [index:background] Health check
[2024-02-08 13:00:39] [indexer:background] Health check
[2024-02-08 13:00:39] [index:background] Health check
[2024-02-08 13:06:06] [indexer:background] Health check
[2024-02-08 13:06:06] [index:background] Health check
[2024-02-08 13:10:04] [indexer:background] Health check
[2024-02-08 13:11:29] [index:background] Health check
[2024-02-08 13:17:36] [indexer:background] Health check
[2024-02-08 13:17:36] [index:background] Health check
[2024-02-08 13:21:36] [indexer:background] Health check
[2024-02-08 13:21:36] [index:background] Health check
[2024-02-08 13:25:59] [indexer:background] Health check
[2024-02-08 13:25:59] [index:background] Health check
[2024-02-08 13:30:00] [indexer:background] Health check
[2024-02-08 13:31:29] [index:background] Health check
[2024-02-08 13:35:45] [indexer:background] Health check
[2024-02-08 13:35:45] [index:background] Health check
[2024-02-08 13:40:00] [indexer:background] Health check
[2024-02-08 13:40:26] [index:background] Health check
[2024-02-08 13:45:03] [indexer:background] Health check
[2024-02-08 13:45:37] [index:background] Health check
[2024-02-08 13:50:30] [indexer:background] Health check
[2024-02-08 13:50:30] [index:background] Health check
[2024-02-08 13:55:03] [indexer:background] Health check
[2024-02-08 13:55:25] [index:background] Health check
[2024-02-08 14:00:01] [indexer:background] Health check
[2024-02-08 14:00:26] [index:background] Health check
[2024-02-08 14:05:45] [indexer:background] Health check
[2024-02-08 14:05:45] [index:background] Health check
[2024-02-08 14:05:45] [query] Query for: 2024
[2024-02-08 14:05:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 14:05:45] [query] Engine: default
[2024-02-08 14:05:45] [query] Tokens: 2024
[2024-02-08 14:05:45] [query] Mods: 6
[2024-02-08 14:05:45] [query] Found results using: or logic
[2024-02-08 14:05: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 (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-02-08 14:05:45] [query] Results: 136 Pages of results: 14
[2024-02-08 14:05:45] [query] Execution time: 0.04526
[2024-02-08 14:05:45] [query] Query for: 2024
[2024-02-08 14:05:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-02-08 14:05:45] [query] Engine: default
[2024-02-08 14:05:45] [query] Tokens: 2024
[2024-02-08 14:05:45] [query] Mods: 6
[2024-02-08 14:05:45] [query] Found results using: or logic
[2024-02-08 14:05: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 (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-02-08 14:05:45] [query] Results: 136 Pages of results: 2
[2024-02-08 14:05:45] [query] Execution time: 0.17648
[2024-02-08 14:10:25] [indexer:background] Health check
[2024-02-08 14:10:25] [index:background] Health check
[2024-02-08 14:20:04] [indexer:background] Health check
[2024-02-08 14:20:04] [index:background] Health check
[2024-02-08 14:20:57] [index:background] Health check
[2024-02-08 14:25:56] [indexer:background] Health check
[2024-02-08 14:25:56] [index:background] Health check
[2024-02-08 14:32:49] [indexer:background] Health check
[2024-02-08 14:32:49] [index:background] Health check
[2024-02-08 14:35:03] [indexer:background] Health check
[2024-02-08 14:35:32] [index:background] Health check
[2024-02-08 14:41:20] [indexer:background] Health check
[2024-02-08 14:41:20] [index:background] Health check
[2024-02-08 14:45:29] [indexer:background] Health check
[2024-02-08 14:45:29] [index:background] Health check
[2024-02-08 14:50:18] [indexer:background] Health check
[2024-02-08 14:51:01] [index:background] Health check
[2024-02-08 14:56:28] [indexer:background] Health check
[2024-02-08 14:56:28] [index:background] Health check
[2024-02-08 15:00:52] [indexer:background] Health check
[2024-02-08 15:00:52] [index:background] Health check
[2024-02-08 15:04:59] [indexer:background] Health check
[2024-02-08 15:06:28] [index:background] Health check
[2024-02-08 15:10:15] [indexer:background] Health check
[2024-02-08 15:10:41] [index:background] Health check
[2024-02-08 15:16:17] [indexer:background] Health check
[2024-02-08 15:16:17] [index:background] Health check
[2024-02-08 15:20:00] [indexer:background] Health check
[2024-02-08 15:20:00] [indexer:background] CPU load threshold (3) breached: 3.72 [waiting 2]
[2024-02-08 15:20:27] [index:background] Health check
[2024-02-08 15:20:27] [index:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2024-02-08 15:20:29] [indexer:background] CPU load threshold (3) breached: 3.53 [waiting 2]
[2024-02-08 15:24:58] [indexer:background] Health check
[2024-02-08 15:26:00] [index:background] Health check
[2024-02-08 15:31:33] [indexer:background] Health check
[2024-02-08 15:31:33] [index:background] Health check
[2024-02-08 15:35:09] [indexer:background] Health check
[2024-02-08 15:36:48] [index:background] Health check
[2024-02-08 15:40:00] [indexer:background] Health check
[2024-02-08 15:40:27] [index:background] Health check
[2024-02-08 15:45:11] [indexer:background] Health check
[2024-02-08 15:45:47] [index:background] Health check
[2024-02-08 15:50:03] [indexer:background] Health check
[2024-02-08 15:50:56] [index:background] Health check
[2024-02-08 15:55:03] [indexer:background] Health check
[2024-02-08 15:56:36] [index:background] Health check
[2024-02-08 15:59:58] [indexer:background] Health check
[2024-02-08 16:01:16] [index:background] Health check
[2024-02-08 16:06:31] [indexer:background] Health check
[2024-02-08 16:06:31] [index:background] Health check
[2024-02-08 16:10:04] [indexer:background] Health check
[2024-02-08 16:10:53] [index:background] Health check
[2024-02-08 16:15:05] [indexer:background] Health check
[2024-02-08 16:15:29] [index:background] Health check
[2024-02-08 16:20:03] [indexer:background] Health check
[2024-02-08 16:20:27] [index:background] Health check
[2024-02-08 16:25:08] [indexer:background] Health check
[2024-02-08 16:25:37] [index:background] Health check
[2024-02-08 16:31:44] [index] Marking post.page 14659 to be dropped
[2024-02-08 16:31:48] [index] Dropping post.page 14659
[2024-02-08 16:31:48] [indexer] Queued next batch (1)
[2024-02-08 16:31:50] [index] Marking post.page 14659 to be dropped
[2024-02-08 16:31:51] [indexer] Processing batch (1)
[2024-02-08 16:31:51] [indexer] Indexing post.page:14659
[2024-02-08 16:31:51] [index] Marking [1] post.page 14659 as indexed
[2024-02-08 16:31:51] [indexer] Index built
[2024-02-08 16:31:53] [index] Dropping post.page 14659
[2024-02-08 16:31:53] [indexer] Queued next batch (1)
[2024-02-08 16:31:54] [indexer] Processing batch (1)
[2024-02-08 16:31:54] [indexer] Indexing post.page:14659
[2024-02-08 16:31:54] [index] Marking [1] post.page 14659 as indexed
[2024-02-08 16:31:54] [indexer] Index built
[2024-02-08 16:32:06] [indexer:background] Health check
[2024-02-08 16:32:06] [index:background] Health check
[2024-02-08 16:32:15] [index] Marking post.page 14659 to be dropped
[2024-02-08 16:32:18] [index] Dropping post.page 14659
[2024-02-08 16:32:18] [indexer] Queued next batch (1)
[2024-02-08 16:32:20] [indexer] Processing batch (1)
[2024-02-08 16:32:20] [indexer] Indexing post.page:14659
[2024-02-08 16:32:20] [index] Marking [1] post.page 14659 as indexed
[2024-02-08 16:32:20] [indexer] Index built
[2024-02-08 16:32:22] [index] Marking post.page 14659 to be dropped
[2024-02-08 16:32:26] [index] Dropping post.page 14659
[2024-02-08 16:32:26] [indexer] Queued next batch (1)
[2024-02-08 16:32:28] [indexer] Processing batch (1)
[2024-02-08 16:32:28] [indexer] Indexing post.page:14659
[2024-02-08 16:32:28] [index] Marking [1] post.page 14659 as indexed
[2024-02-08 16:32:28] [indexer] Index built
[2024-02-08 16:35:27] [indexer:background] Health check
[2024-02-08 16:35:27] [index:background] Health check
[2024-02-08 16:40:18] [indexer:background] Health check
[2024-02-08 16:40:38] [index:background] Health check
[2024-02-08 16:45:00] [indexer:background] Health check
[2024-02-08 16:45:36] [index:background] Health check
[2024-02-08 16:50:22] [indexer:background] Health check
[2024-02-08 16:50:30] [index:background] Health check
[2024-02-08 16:55:04] [indexer:background] Health check
[2024-02-08 16:55:28] [index:background] Health check
[2024-02-08 17:00:08] [indexer:background] Health check
[2024-02-08 17:01:15] [index:background] Health check
[2024-02-08 17:02:12] [query] Query for: 2025
[2024-02-08 17:02:12] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 17:02:12] [query] Engine: default
[2024-02-08 17:02:12] [query] Tokens: 2025
[2024-02-08 17:02:12] [query] Mods: 6
[2024-02-08 17:02:12] [query] Found results using: or logic
[2024-02-08 17:02:12] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-02-08 17:02:12] [query] Results: 137 Pages of results: 14
[2024-02-08 17:02:12] [query] Execution time: 0.44260
[2024-02-08 17:03:05] [query] Query for: {search_term_string}
[2024-02-08 17:03:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 62 offset: 0 fields: all
[2024-02-08 17:03:05] [query] Engine: default
[2024-02-08 17:03:05] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-02-08 17:03:05] [query] Mods: 6
[2024-02-08 17:03:05] [query] Using OR logic
[2024-02-08 17:03:06] [query] Found results using: or logic
[2024-02-08 17:03:06] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 610, 10
[2024-02-08 17:03:06] [query] Results: 1352 Pages of results: 136
[2024-02-08 17:03:06] [query] Execution time: 0.80686
[2024-02-08 17:05:01] [indexer:background] Health check
[2024-02-08 17:05:25] [index:background] Health check
[2024-02-08 17:09:59] [indexer:background] Health check
[2024-02-08 17:10:27] [index:background] Health check
[2024-02-08 17:17:12] [indexer:background] Health check
[2024-02-08 17:17:12] [index:background] Health check
[2024-02-08 17:20:44] [indexer:background] Health check
[2024-02-08 17:20:44] [index:background] Health check
[2024-02-08 17:25:08] [indexer:background] Health check
[2024-02-08 17:25:27] [index:background] Health check
[2024-02-08 17:30:14] [indexer:background] Health check
[2024-02-08 17:30:44] [index:background] Health check
[2024-02-08 17:36:48] [indexer:background] Health check
[2024-02-08 17:36:48] [index:background] Health check
[2024-02-08 17:40:22] [indexer:background] Health check
[2024-02-08 17:40:25] [index:background] Health check
[2024-02-08 17:45:52] [indexer:background] Health check
[2024-02-08 17:45:53] [index:background] Health check
[2024-02-08 17:50:11] [indexer:background] Health check
[2024-02-08 17:50:28] [index:background] Health check
[2024-02-08 17:55:24] [indexer:background] Health check
[2024-02-08 17:55:24] [index:background] Health check
[2024-02-08 18:00:43] [indexer:background] Health check
[2024-02-08 18:00:44] [index:background] Health check
[2024-02-08 18:05:45] [indexer:background] Health check
[2024-02-08 18:05:45] [index:background] Health check
[2024-02-08 18:10:17] [indexer:background] Health check
[2024-02-08 18:12:13] [index:background] Health check
[2024-02-08 18:15:21] [indexer:background] Health check
[2024-02-08 18:15:51] [index:background] Health check
[2024-02-08 18:20:42] [indexer:background] Health check
[2024-02-08 18:20:42] [index:background] Health check
[2024-02-08 18:24:58] [indexer:background] Health check
[2024-02-08 18:25:29] [index:background] Health check
[2024-02-08 18:30:24] [indexer:background] Health check
[2024-02-08 18:30:24] [index:background] Health check
[2024-02-08 18:32:29] [query] Query for: 2025
[2024-02-08 18:32:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-08 18:32:29] [query] Engine: default
[2024-02-08 18:32:29] [query] Tokens: 2025
[2024-02-08 18:32:29] [query] Mods: 6
[2024-02-08 18:32:29] [query] Found results using: or logic
[2024-02-08 18:32: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 (15055) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 10
[2024-02-08 18:32:29] [query] Results: 137 Pages of results: 14
[2024-02-08 18:32:29] [query] Execution time: 0.04683
[2024-02-08 18:35:42] [indexer:background] Health check
[2024-02-08 18:35:42] [index:background] Health check
[2024-02-08 18:40:39] [indexer:background] Health check
[2024-02-08 18:40:39] [index:background] Health check
[2024-02-08 18:45:00] [indexer:background] Health check
[2024-02-08 18:47:15] [index:background] Health check
[2024-02-08 18:50:11] [indexer:background] Health check
[2024-02-08 18:51:07] [index:background] Health check
[2024-02-08 18:56:16] [indexer:background] Health check
[2024-02-08 18:56:16] [index:background] Health check
[2024-02-08 19:00:40] [indexer:background] Health check
[2024-02-08 19:00:41] [index:background] Health check
[2024-02-08 19:05:31] [indexer:background] Health check
[2024-02-08 19:05:31] [index:background] Health check
[2024-02-08 19:10:16] [indexer:background] Health check
[2024-02-08 19:10:54] [index:background] Health check
[2024-02-08 19:15:54] [indexer:background] Health check
[2024-02-08 19:15:54] [index:background] Health check
[2024-02-08 19:19:59] [indexer:background] Health check
[2024-02-08 19:20:58] [index:background] Health check
[2024-02-08 19:25:22] [indexer:background] Health check
[2024-02-08 19:25:25] [index:background] Health check
[2024-02-08 19:30:28] [indexer:background] Health check
[2024-02-08 19:30:28] [index:background] Health check
[2024-02-08 19:36:23] [indexer:background] Health check
[2024-02-08 19:36:23] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-02-08 19:36:25] [index:background] Health check
[2024-02-08 19:36:25] [index:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-02-08 19:36:27] [indexer:background] CPU load threshold (3) breached: 3.57 [waiting 2]
[2024-02-08 19:43:51] [indexer:background] Health check
[2024-02-08 19:43:51] [index:background] Health check
[2024-02-08 19:45:26] [indexer:background] Health check
[2024-02-08 19:45:26] [index:background] Health check
[2024-02-08 19:50:22] [indexer:background] Health check
[2024-02-08 19:50:51] [index:background] Health check
[2024-02-08 19:55:19] [indexer:background] Health check
[2024-02-08 19:56:20] [index:background] Health check
[2024-02-08 19:59:59] [indexer:background] Health check
[2024-02-08 20:02:44] [index:background] Health check
[2024-02-08 20:05:52] [indexer:background] Health check
[2024-02-08 20:05:52] [index:background] Health check
[2024-02-08 20:09:57] [indexer:background] Health check
[2024-02-08 20:12:18] [index:background] Health check
[2024-02-08 20:15:33] [indexer:background] Health check
[2024-02-08 20:15:33] [index:background] Health check
[2024-02-08 20:20:06] [indexer:background] Health check
[2024-02-08 20:20:30] [index:background] Health check
[2024-02-08 20:25:00] [indexer:background] Health check
[2024-02-08 20:27:20] [index:background] Health check
[2024-02-08 20:30:04] [indexer:background] Health check
[2024-02-08 20:31:05] [index:background] Health check
[2024-02-08 20:35:55] [indexer:background] Health check
[2024-02-08 20:35:55] [index:background] Health check
[2024-02-08 20:40:32] [indexer:background] Health check
[2024-02-08 20:40:32] [index:background] Health check
[2024-02-08 20:45:20] [indexer:background] Health check
[2024-02-08 20:46:13] [index:background] Health check
[2024-02-08 20:51:05] [indexer:background] Health check
[2024-02-08 20:51:05] [index:background] Health check
[2024-02-08 20:55:25] [indexer:background] Health check
[2024-02-08 20:55:25] [index:background] Health check
[2024-02-08 21:00:09] [indexer:background] Health check
[2024-02-08 21:01:18] [index:background] Health check
[2024-02-08 21:05:48] [indexer:background] Health check
[2024-02-08 21:05:48] [index:background] Health check
[2024-02-08 21:10:34] [indexer:background] Health check
[2024-02-08 21:10:34] [index:background] Health check
[2024-02-08 21:15:04] [indexer:background] Health check
[2024-02-08 21:15:40] [index:background] Health check
[2024-02-08 21:20:12] [indexer:background] Health check
[2024-02-08 21:20:35] [index:background] Health check
[2024-02-08 21:24:57] [indexer:background] Health check
[2024-02-08 21:26:17] [index:background] Health check
[2024-02-08 21:30:11] [indexer:background] Health check
[2024-02-08 21:30:25] [index:background] Health check
[2024-02-08 21:35:26] [indexer:background] Health check
[2024-02-08 21:35:26] [index:background] Health check
[2024-02-08 21:40:03] [indexer:background] Health check
[2024-02-08 21:40:47] [index:background] Health check
[2024-02-08 21:45:12] [indexer:background] Health check
[2024-02-08 21:45:26] [index:background] Health check
[2024-02-08 21:50:11] [indexer:background] Health check
[2024-02-08 21:50:46] [index:background] Health check
[2024-02-08 21:56:06] [indexer:background] Health check
[2024-02-08 21:56:06] [index:background] Health check
[2024-02-08 22:00:00] [indexer:background] Health check
[2024-02-08 22:00:32] [index:background] Health check
[2024-02-08 22:05:20] [indexer:background] Health check
[2024-02-08 22:05:41] [index:background] Health check
[2024-02-08 22:10:08] [indexer:background] Health check
[2024-02-08 22:10:43] [index:background] Health check
[2024-02-08 22:15:11] [indexer:background] Health check
[2024-02-08 22:16:22] [index:background] Health check
[2024-02-08 22:21:32] [indexer:background] Health check
[2024-02-08 22:21:32] [index:background] Health check
[2024-02-08 22:25:58] [indexer:background] Health check
[2024-02-08 22:25:58] [index:background] Health check
[2024-02-08 22:29:58] [indexer:background] Health check
[2024-02-08 22:30:50] [index:background] Health check
[2024-02-08 22:35:51] [indexer:background] Health check
[2024-02-08 22:35:51] [index:background] Health check
[2024-02-08 22:41:26] [indexer:background] Health check
[2024-02-08 22:41:26] [index:background] Health check
[2024-02-08 22:45:27] [indexer:background] Health check
[2024-02-08 22:45:27] [index:background] Health check
[2024-02-08 22:50:03] [indexer:background] Health check
[2024-02-08 22:51:06] [index:background] Health check
[2024-02-08 22:55:36] [indexer:background] Health check
[2024-02-08 22:55:36] [index:background] Health check
[2024-02-08 23:00:05] [indexer:background] Health check
[2024-02-08 23:00:36] [index:background] Health check
[2024-02-08 23:08:41] [indexer:background] Health check
[2024-02-08 23:08:42] [index:background] Health check
[2024-02-08 23:10:16] [indexer:background] Health check
[2024-02-08 23:10:45] [index:background] Health check
[2024-02-08 23:16:03] [indexer:background] Health check
[2024-02-08 23:16:03] [index:background] Health check
[2024-02-08 23:20:37] [indexer:background] Health check
[2024-02-08 23:20:37] [index:background] Health check
[2024-02-08 23:25:00] [indexer:background] Health check
[2024-02-08 23:25:43] [index:background] Health check
[2024-02-08 23:30:51] [indexer:background] Health check
[2024-02-08 23:30:51] [index:background] Health check
[2024-02-08 23:35:18] [indexer:background] Health check
[2024-02-08 23:36:12] [index:background] Health check
[2024-02-08 23:41:08] [indexer:background] Health check
[2024-02-08 23:41:08] [index:background] Health check
[2024-02-08 23:45:04] [indexer:background] Health check
[2024-02-08 23:45:38] [index:background] Health check
[2024-02-08 23:50:15] [indexer:background] Health check
[2024-02-08 23:50:39] [index:background] Health check
[2024-02-08 23:55:29] [indexer:background] Health check
[2024-02-08 23:55:29] [index:background] Health check