[2024-07-15 00:04:02] [index:background] Health check
[2024-07-15 00:07:52] [indexer:background] Health check
[2024-07-15 00:08:44] [index:background] Health check
[2024-07-15 00:10:13] [indexer:background] Health check
[2024-07-15 00:14:04] [index:background] Health check
[2024-07-15 00:14:49] [indexer:background] Health check
[2024-07-15 00:19:26] [index:background] Health check
[2024-07-15 00:19:26] [indexer:background] Health check
[2024-07-15 00:19:26] [indexer:background] Health check
[2024-07-15 00:23:46] [index:background] Health check
[2024-07-15 00:24:17] [indexer:background] Health check
[2024-07-15 00:28:59] [index:background] Health check
[2024-07-15 00:31:20] [indexer:background] Health check
[2024-07-15 00:35:46] [index:background] Health check
[2024-07-15 00:35:46] [indexer:background] Health check
[2024-07-15 00:35:46] [indexer:background] Health check
[2024-07-15 00:40:20] [index:background] Health check
[2024-07-15 00:40:20] [indexer:background] Health check
[2024-07-15 00:40:20] [indexer:background] Health check
[2024-07-15 00:44:37] [index:background] Health check
[2024-07-15 00:44:37] [indexer:background] Health check
[2024-07-15 00:44:38] [indexer:background] Health check
[2024-07-15 00:48:50] [index:background] Health check
[2024-07-15 00:49:31] [indexer:background] Health check
[2024-07-15 00:54:44] [index:background] Health check
[2024-07-15 00:54:44] [indexer:background] Health check
[2024-07-15 00:54:44] [indexer:background] Health check
[2024-07-15 00:59:02] [index:background] Health check
[2024-07-15 00:59:57] [indexer:background] Health check
[2024-07-15 01:03:42] [index:background] Health check
[2024-07-15 01:05:57] [indexer:background] Health check
[2024-07-15 01:08:58] [index:background] Health check
[2024-07-15 01:10:30] [indexer:background] Health check
[2024-07-15 01:14:13] [index:background] Health check
[2024-07-15 01:15:52] [indexer:background] Health check
[2024-07-15 01:18:43] [index:background] Health check
[2024-07-15 01:20:23] [indexer:background] Health check
[2024-07-15 01:27:14] [index:background] Health check
[2024-07-15 01:27:14] [indexer:background] Health check
[2024-07-15 01:27:14] [indexer:background] Health check
[2024-07-15 01:32:23] [index:background] Health check
[2024-07-15 01:32:23] [indexer:background] Health check
[2024-07-15 01:32:24] [indexer:background] Health check
[2024-07-15 01:34:58] [index:background] Health check
[2024-07-15 01:34:58] [indexer:background] Health check
[2024-07-15 01:34:58] [indexer:background] Health check
[2024-07-15 01:38:59] [index:background] Health check
[2024-07-15 01:40:45] [indexer:background] Health check
[2024-07-15 01:44:55] [index:background] Health check
[2024-07-15 01:44:55] [indexer:background] Health check
[2024-07-15 01:44:55] [indexer:background] Health check
[2024-07-15 01:49:25] [index:background] Health check
[2024-07-15 01:49:25] [indexer:background] Health check
[2024-07-15 01:49:25] [indexer:background] Health check
[2024-07-15 01:54:52] [index:background] Health check
[2024-07-15 01:54:53] [indexer:background] Health check
[2024-07-15 01:54:53] [indexer:background] Health check
[2024-07-15 01:58:56] [index:background] Health check
[2024-07-15 02:00:26] [indexer:background] Health check
[2024-07-15 02:04:45] [index:background] Health check
[2024-07-15 02:04:45] [indexer:background] Health check
[2024-07-15 02:04:45] [indexer:background] Health check
[2024-07-15 02:10:18] [index:background] Health check
[2024-07-15 02:10:18] [indexer:background] Health check
[2024-07-15 02:10:18] [indexer:background] Health check
[2024-07-15 02:14:08] [index:background] Health check
[2024-07-15 02:14:47] [indexer:background] Health check
[2024-07-15 02:20:16] [index:background] Health check
[2024-07-15 02:20:16] [indexer:background] Health check
[2024-07-15 02:20:16] [indexer:background] Health check
[2024-07-15 02:23:56] [index:background] Health check
[2024-07-15 02:24:36] [indexer:background] Health check
[2024-07-15 02:29:46] [index:background] Health check
[2024-07-15 02:29:46] [indexer:background] Health check
[2024-07-15 02:29:46] [indexer:background] Health check
[2024-07-15 02:33:50] [index:background] Health check
[2024-07-15 02:34:24] [indexer:background] Health check
[2024-07-15 02:40:28] [index:background] Health check
[2024-07-15 02:40:28] [indexer:background] Health check
[2024-07-15 02:40:28] [indexer:background] Health check
[2024-07-15 02:44:30] [index:background] Health check
[2024-07-15 02:44:30] [indexer:background] Health check
[2024-07-15 02:44:30] [indexer:background] Health check
[2024-07-15 02:51:37] [index:background] Health check
[2024-07-15 02:51:37] [indexer:background] Health check
[2024-07-15 02:51:37] [indexer:background] Health check
[2024-07-15 02:53:46] [index:background] Health check
[2024-07-15 02:54:21] [indexer:background] Health check
[2024-07-15 02:59:16] [index:background] Health check
[2024-07-15 02:59:16] [indexer:background] Health check
[2024-07-15 02:59:16] [indexer:background] Health check
[2024-07-15 03:06:12] [index:background] Health check
[2024-07-15 03:06:12] [indexer:background] Health check
[2024-07-15 03:06:12] [indexer:background] Health check
[2024-07-15 03:10:14] [index:background] Health check
[2024-07-15 03:10:14] [indexer:background] Health check
[2024-07-15 03:10:14] [indexer:background] Health check
[2024-07-15 03:14:21] [index:background] Health check
[2024-07-15 03:14:21] [indexer:background] Health check
[2024-07-15 03:14:21] [indexer:background] Health check
[2024-07-15 03:19:52] [index:background] Health check
[2024-07-15 03:19:52] [indexer:background] Health check
[2024-07-15 03:19:52] [indexer:background] Health check
[2024-07-15 03:26:20] [index:background] Health check
[2024-07-15 03:26:21] [indexer:background] Health check
[2024-07-15 03:26:21] [indexer:background] Health check
[2024-07-15 03:29:46] [index:background] Health check
[2024-07-15 03:29:46] [indexer:background] Health check
[2024-07-15 03:29:46] [indexer:background] Health check
[2024-07-15 03:33:51] [index:background] Health check
[2024-07-15 03:34:56] [indexer:background] Health check
[2024-07-15 03:38:51] [index:background] Health check
[2024-07-15 03:39:19] [indexer:background] Health check
[2024-07-15 03:44:45] [index:background] Health check
[2024-07-15 03:44:45] [indexer:background] Health check
[2024-07-15 03:44:45] [indexer:background] Health check
[2024-07-15 03:49:21] [index:background] Health check
[2024-07-15 03:49:21] [indexer:background] Health check
[2024-07-15 03:49:21] [indexer:background] Health check
[2024-07-15 03:53:45] [index:background] Health check
[2024-07-15 03:55:24] [indexer:background] Health check
[2024-07-15 04:02:21] [index:background] Health check
[2024-07-15 04:02:21] [indexer:background] Health check
[2024-07-15 04:02:21] [indexer:background] Health check
[2024-07-15 04:04:44] [index:background] Health check
[2024-07-15 04:04:44] [indexer:background] Health check
[2024-07-15 04:04:44] [indexer:background] Health check
[2024-07-15 04:08:50] [index:background] Health check
[2024-07-15 04:11:14] [indexer:background] Health check
[2024-07-15 04:15:21] [index:background] Health check
[2024-07-15 04:15:21] [indexer:background] Health check
[2024-07-15 04:15:22] [indexer:background] Health check
[2024-07-15 04:19:53] [index:background] Health check
[2024-07-15 04:19:53] [indexer:background] Health check
[2024-07-15 04:19:53] [indexer:background] Health check
[2024-07-15 04:24:41] [index:background] Health check
[2024-07-15 04:24:41] [indexer:background] Health check
[2024-07-15 04:24:41] [indexer:background] Health check
[2024-07-15 04:28:41] [index:background] Health check
[2024-07-15 04:30:01] [indexer:background] Health check
[2024-07-15 04:36:03] [index:background] Health check
[2024-07-15 04:36:03] [indexer:background] Health check
[2024-07-15 04:36:03] [indexer:background] Health check
[2024-07-15 04:38:49] [index:background] Health check
[2024-07-15 04:39:31] [indexer:background] Health check
[2024-07-15 04:45:41] [index:background] Health check
[2024-07-15 04:45:41] [indexer:background] Health check
[2024-07-15 04:45:41] [indexer:background] Health check
[2024-07-15 04:48:50] [index:background] Health check
[2024-07-15 04:49:40] [indexer:background] Health check
[2024-07-15 04:54:01] [index:background] Health check
[2024-07-15 04:54:45] [indexer:background] Health check
[2024-07-15 04:59:33] [index:background] Health check
[2024-07-15 04:59:33] [indexer:background] Health check
[2024-07-15 04:59:34] [indexer:background] Health check
[2024-07-15 05:04:12] [index:background] Health check
[2024-07-15 05:04:44] [indexer:background] Health check
[2024-07-15 05:11:29] [index:background] Health check
[2024-07-15 05:11:30] [indexer:background] Health check
[2024-07-15 05:11:30] [indexer:background] Health check
[2024-07-15 05:14:23] [index:background] Health check
[2024-07-15 05:14:23] [indexer:background] Health check
[2024-07-15 05:14:23] [indexer:background] Health check
[2024-07-15 05:19:18] [index:background] Health check
[2024-07-15 05:19:18] [indexer:background] Health check
[2024-07-15 05:19:18] [indexer:background] Health check
[2024-07-15 05:24:24] [index:background] Health check
[2024-07-15 05:24:24] [indexer:background] Health check
[2024-07-15 05:24:24] [indexer:background] Health check
[2024-07-15 05:29:00] [index:background] Health check
[2024-07-15 05:30:31] [indexer:background] Health check
[2024-07-15 05:33:42] [index:background] Health check
[2024-07-15 05:34:31] [indexer:background] Health check
[2024-07-15 05:38:48] [index:background] Health check
[2024-07-15 05:40:59] [indexer:background] Health check
[2024-07-15 05:44:34] [index:background] Health check
[2024-07-15 05:44:34] [indexer:background] Health check
[2024-07-15 05:44:34] [indexer:background] Health check
[2024-07-15 05:49:54] [index:background] Health check
[2024-07-15 05:49:54] [indexer:background] Health check
[2024-07-15 05:49:54] [indexer:background] Health check
[2024-07-15 05:56:00] [index:background] Health check
[2024-07-15 05:56:00] [indexer:background] Health check
[2024-07-15 05:56:00] [indexer:background] Health check
[2024-07-15 05:59:00] [index:background] Health check
[2024-07-15 05:59:39] [indexer:background] Health check
[2024-07-15 06:04:06] [index:background] Health check
[2024-07-15 06:04:31] [indexer:background] Health check
[2024-07-15 06:09:23] [index:background] Health check
[2024-07-15 06:09:24] [indexer:background] Health check
[2024-07-15 06:09:24] [indexer:background] Health check
[2024-07-15 06:13:42] [index:background] Health check
[2024-07-15 06:15:04] [indexer:background] Health check
[2024-07-15 06:18:42] [index:background] Health check
[2024-07-15 06:19:23] [indexer:background] Health check
[2024-07-15 06:24:24] [index:background] Health check
[2024-07-15 06:24:24] [indexer:background] Health check
[2024-07-15 06:24:24] [indexer:background] Health check
[2024-07-15 06:28:51] [index:background] Health check
[2024-07-15 06:29:27] [indexer:background] Health check
[2024-07-15 06:34:19] [index:background] Health check
[2024-07-15 06:34:19] [indexer:background] Health check
[2024-07-15 06:34:19] [indexer:background] Health check
[2024-07-15 06:38:58] [index:background] Health check
[2024-07-15 06:39:45] [indexer:background] Health check
[2024-07-15 06:44:24] [index:background] Health check
[2024-07-15 06:44:24] [indexer:background] Health check
[2024-07-15 06:44:24] [indexer:background] Health check
[2024-07-15 06:48:55] [index:background] Health check
[2024-07-15 06:49:47] [indexer:background] Health check
[2024-07-15 06:53:49] [index:background] Health check
[2024-07-15 06:55:00] [indexer:background] Health check
[2024-07-15 07:00:51] [index:background] Health check
[2024-07-15 07:00:51] [indexer:background] Health check
[2024-07-15 07:00:52] [indexer:background] Health check
[2024-07-15 07:04:07] [index:background] Health check
[2024-07-15 07:06:13] [indexer:background] Health check
[2024-07-15 07:08:46] [index:background] Health check
[2024-07-15 07:09:29] [indexer:background] Health check
[2024-07-15 07:13:44] [index:background] Health check
[2024-07-15 07:14:18] [indexer:background] Health check
[2024-07-15 07:19:14] [index:background] Health check
[2024-07-15 07:19:18] [indexer:background] Health check
[2024-07-15 07:24:21] [index:background] Health check
[2024-07-15 07:24:21] [indexer:background] Health check
[2024-07-15 07:24:21] [indexer:background] Health check
[2024-07-15 07:29:41] [index:background] Health check
[2024-07-15 07:29:41] [indexer:background] Health check
[2024-07-15 07:29:41] [indexer:background] Health check
[2024-07-15 07:33:46] [index:background] Health check
[2024-07-15 07:34:47] [indexer:background] Health check
[2024-07-15 07:38:57] [index:background] Health check
[2024-07-15 07:39:42] [indexer:background] Health check
[2024-07-15 07:44:10] [index:background] Health check
[2024-07-15 07:45:23] [indexer:background] Health check
[2024-07-15 07:48:59] [index:background] Health check
[2024-07-15 07:51:03] [indexer:background] Health check
[2024-07-15 07:53:50] [index:background] Health check
[2024-07-15 07:54:34] [indexer:background] Health check
[2024-07-15 07:58:46] [index:background] Health check
[2024-07-15 07:59:26] [indexer:background] Health check
[2024-07-15 08:05:06] [index:background] Health check
[2024-07-15 08:05:06] [indexer:background] Health check
[2024-07-15 08:05:06] [indexer:background] Health check
[2024-07-15 08:08:49] [index:background] Health check
[2024-07-15 08:09:37] [indexer:background] Health check
[2024-07-15 08:13:49] [index:background] Health check
[2024-07-15 08:14:40] [indexer:background] Health check
[2024-07-15 08:20:17] [index:background] Health check
[2024-07-15 08:20:17] [indexer:background] Health check
[2024-07-15 08:20:17] [indexer:background] Health check
[2024-07-15 08:23:43] [index:background] Health check
[2024-07-15 08:24:48] [indexer:background] Health check
[2024-07-15 08:28:50] [index:background] Health check
[2024-07-15 08:30:02] [indexer:background] Health check
[2024-07-15 08:34:04] [index:background] Health check
[2024-07-15 08:34:25] [indexer:background] Health check
[2024-07-15 08:38:52] [index:background] Health check
[2024-07-15 08:39:32] [indexer:background] Health check
[2024-07-15 08:43:45] [index:background] Health check
[2024-07-15 08:44:30] [indexer:background] Health check
[2024-07-15 08:48:44] [index:background] Health check
[2024-07-15 08:51:17] [indexer:background] Health check
[2024-07-15 08:53:42] [index:background] Health check
[2024-07-15 08:54:18] [indexer:background] Health check
[2024-07-15 08:58:42] [index:background] Health check
[2024-07-15 09:00:11] [indexer:background] Health check
[2024-07-15 09:03:54] [index:background] Health check
[2024-07-15 09:03:54] [index:background] Health check
[2024-07-15 09:04:26] [indexer:background] Health check
[2024-07-15 09:08:42] [index:background] Health check
[2024-07-15 09:09:17] [indexer:background] Health check
[2024-07-15 09:13:53] [index:background] Health check
[2024-07-15 09:14:25] [indexer:background] Health check
[2024-07-15 09:18:54] [index:background] Health check
[2024-07-15 09:19:22] [indexer:background] Health check
[2024-07-15 09:23:52] [index:background] Health check
[2024-07-15 09:24:52] [indexer:background] Health check
[2024-07-15 09:28:53] [index:background] Health check
[2024-07-15 09:29:19] [indexer:background] Health check
[2024-07-15 09:33:57] [index:background] Health check
[2024-07-15 09:34:46] [indexer:background] Health check
[2024-07-15 09:38:47] [index:background] Health check
[2024-07-15 09:39:41] [indexer:background] Health check
[2024-07-15 09:43:52] [index:background] Health check
[2024-07-15 09:44:44] [indexer:background] Health check
[2024-07-15 09:48:51] [index:background] Health check
[2024-07-15 09:49:36] [indexer:background] Health check
[2024-07-15 09:54:15] [index:background] Health check
[2024-07-15 09:54:16] [indexer:background] Health check
[2024-07-15 09:54:16] [indexer:background] Health check
[2024-07-15 09:58:42] [index:background] Health check
[2024-07-15 09:59:19] [indexer:background] Health check
[2024-07-15 10:04:03] [index:background] Health check
[2024-07-15 10:04:42] [indexer:background] Health check
[2024-07-15 10:08:58] [index:background] Health check
[2024-07-15 10:09:50] [indexer:background] Health check
[2024-07-15 10:13:42] [index:background] Health check
[2024-07-15 10:14:32] [indexer:background] Health check
[2024-07-15 10:18:48] [index:background] Health check
[2024-07-15 10:19:31] [indexer:background] Health check
[2024-07-15 10:24:31] [index:background] Health check
[2024-07-15 10:24:31] [indexer:background] Health check
[2024-07-15 10:24:31] [indexer:background] Health check
[2024-07-15 10:28:53] [index:background] Health check
[2024-07-15 10:29:20] [indexer:background] Health check
[2024-07-15 10:33:45] [index:background] Health check
[2024-07-15 10:35:08] [indexer:background] Health check
[2024-07-15 10:38:43] [index:background] Health check
[2024-07-15 10:40:25] [indexer:background] Health check
[2024-07-15 10:44:03] [index:background] Health check
[2024-07-15 10:44:19] [indexer:background] Health check
[2024-07-15 10:48:56] [index:background] Health check
[2024-07-15 10:49:19] [indexer:background] Health check
[2024-07-15 10:53:42] [index:background] Health check
[2024-07-15 10:56:13] [indexer:background] Health check
[2024-07-15 10:58:45] [index:background] Health check
[2024-07-15 10:59:37] [indexer:background] Health check
[2024-07-15 11:03:50] [index:background] Health check
[2024-07-15 11:04:22] [indexer:background] Health check
[2024-07-15 11:08:57] [index:background] Health check
[2024-07-15 11:10:42] [indexer:background] Health check
[2024-07-15 11:13:45] [index:background] Health check
[2024-07-15 11:14:19] [indexer:background] Health check
[2024-07-15 11:18:44] [index:background] Health check
[2024-07-15 11:19:18] [indexer:background] Health check
[2024-07-15 11:23:50] [index:background] Health check
[2024-07-15 11:24:23] [indexer:background] Health check
[2024-07-15 11:26:11] [query] Query for: constitution
[2024-07-15 11:26:11] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: 50 page: 1 offset: 0 fields: all
[2024-07-15 11:26:11] [query] Engine: default
[2024-07-15 11:26:12] [query] Tokens: constituaient, constituantes, constituants, constituante, constituera, constitues, constitués, constitueront, constituée, constitué, constituait, constitutions, constituerait, constituées, constituant, constitua, constituer, constitution, constitue, constitu
[2024-07-15 11:26:12] [query] Mods: 3
[2024-07-15 11:26:12] [query] Using OR logic
[2024-07-15 11:26:15] [query] Found results using: and logic
[2024-07-15 11:26:15] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.dlp_document' AND (s.attribute IN ('title','slug','taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.dlp_document' AND (s.attribute IN ('content','excerpt','meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) LEFT JOIN mod441_posts swpqueryorder ON (swpqueryorder.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (26506,340935,177927,68383,46388,32471,30901,28167,26515,1410,21148,20987,16510,14988,14046,10579,8070,4676,1434,54397) AND 1=1 AND ((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' ) ) ) 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) LEFT JOIN mod441_posts swpqueryorder ON (swpqueryorder.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 swpqueryorder.post_title ASC, relevance DESC LIMIT 0, 50
[2024-07-15 11:26:15] [query] Results: 994 Pages of results: 20
[2024-07-15 11:26:15] [query] Execution time: 3.71223
[2024-07-15 11:28:46] [index:background] Health check
[2024-07-15 11:29:23] [indexer:background] Health check
[2024-07-15 11:32:35] [query] Query for: constitution
[2024-07-15 11:32:35] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-07-15 11:32:35] [query] Engine: default
[2024-07-15 11:32:35] [query] Tokens: constituaient, constituantes, constituants, constituante, constituera, constitues, constitués, constitueront, constituée, constitué, constituait, constitutions, constituerait, constituées, constituant, constitua, constituer, constitution, constitue, constitu
[2024-07-15 11:32:35] [query] Mods: 3
[2024-07-15 11:32:35] [query] Using OR logic
[2024-07-15 11:32:37] [query] Found results using: and logic
[2024-07-15 11:32:37] [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.dlp_document' AND (s.attribute IN ('title','slug','taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.dlp_document' AND (s.attribute IN ('content','excerpt','meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) LEFT JOIN mod441_posts swpqueryorder ON (swpqueryorder.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (26506,340935,177927,68383,46388,32471,30901,28167,26515,1410,21148,20987,16510,14988,14046,10579,8070,4676,1434,54397) AND 1=1 AND ((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' ) ) ) 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) LEFT JOIN mod441_posts swpqueryorder ON (swpqueryorder.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 swpqueryorder.post_title ASC, relevance DESC LIMIT 0, 100
[2024-07-15 11:32:37] [query] Results: 994 Pages of results: 10
[2024-07-15 11:32:37] [query] Execution time: 2.69407
[2024-07-15 11:33:46] [index:background] Health check
[2024-07-15 11:34:30] [indexer:background] Health check
[2024-07-15 11:39:02] [index:background] Health check
[2024-07-15 11:40:42] [indexer:background] Health check
[2024-07-15 11:43:49] [index:background] Health check
[2024-07-15 11:44:58] [indexer:background] Health check
[2024-07-15 11:47:04] [query] Query for: constitution
[2024-07-15 11:47:04] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: 50 page: 1 offset: 0 fields: all
[2024-07-15 11:47:04] [query] Engine: default
[2024-07-15 11:47:04] [query] Tokens: constituaient, constituantes, constituants, constituante, constituera, constitues, constitués, constitueront, constituée, constitué, constituait, constitutions, constituerait, constituées, constituant, constitua, constituer, constitution, constitue, constitu
[2024-07-15 11:47:04] [query] Mods: 3
[2024-07-15 11:47:04] [query] Using OR logic
[2024-07-15 11:47:06] [query] Found results using: and logic
[2024-07-15 11:47: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.dlp_document' AND (s.attribute IN ('title','slug','taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.dlp_document' AND (s.attribute IN ('content','excerpt','meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) LEFT JOIN mod441_posts swpqueryorder ON (swpqueryorder.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (26506,340935,177927,68383,46388,32471,30901,28167,26515,1410,21148,20987,16510,14988,14046,10579,8070,4676,1434,54397) AND 1=1 AND ((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' ) ) ) 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) LEFT JOIN mod441_posts swpqueryorder ON (swpqueryorder.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 swpqueryorder.post_title ASC, relevance DESC LIMIT 0, 50
[2024-07-15 11:47:06] [query] Results: 994 Pages of results: 20
[2024-07-15 11:47:06] [query] Execution time: 2.40812
[2024-07-15 11:48:42] [index:background] Health check
[2024-07-15 11:49:19] [indexer:background] Health check
[2024-07-15 11:54:20] [index:background] Health check
[2024-07-15 11:54:20] [indexer:background] Health check
[2024-07-15 11:54:20] [indexer:background] Health check
[2024-07-15 11:58:50] [index:background] Health check
[2024-07-15 11:59:18] [indexer:background] Health check
[2024-07-15 12:04:07] [index:background] Health check
[2024-07-15 12:05:29] [indexer:background] Health check
[2024-07-15 12:09:26] [index:background] Health check
[2024-07-15 12:09:26] [indexer:background] Health check
[2024-07-15 12:09:26] [indexer:background] Health check
[2024-07-15 12:14:29] [index:background] Health check
[2024-07-15 12:14:29] [indexer:background] Health check
[2024-07-15 12:14:29] [indexer:background] Health check
[2024-07-15 12:18:50] [index:background] Health check
[2024-07-15 12:19:47] [indexer:background] Health check
[2024-07-15 12:23:46] [query] Query for: 2025
[2024-07-15 12:23:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-15 12:23:46] [query] Engine: default
[2024-07-15 12:23:47] [query] Tokens: 2025
[2024-07-15 12:23:47] [query] Mods: 6
[2024-07-15 12:23:47] [query] Found results using: or logic
[2024-07-15 12:23:47] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-07-15 12:23:47] [query] Results: 138 Pages of results: 14
[2024-07-15 12:23:47] [query] Execution time: 0.42923
[2024-07-15 12:23:47] [index:background] Health check
[2024-07-15 12:24:21] [indexer:background] Health check
[2024-07-15 12:28:45] [index:background] Health check
[2024-07-15 12:29:20] [indexer:background] Health check
[2024-07-15 12:33:43] [index:background] Health check
[2024-07-15 12:34:17] [indexer:background] Health check
[2024-07-15 12:38:45] [index:background] Health check
[2024-07-15 12:39:19] [indexer:background] Health check
[2024-07-15 12:43:46] [index:background] Health check
[2024-07-15 12:44:17] [indexer:background] Health check
[2024-07-15 12:48:46] [index:background] Health check
[2024-07-15 12:49:54] [indexer:background] Health check
[2024-07-15 12:54:06] [index:background] Health check
[2024-07-15 12:54:33] [indexer:background] Health check
[2024-07-15 12:58:44] [index:background] Health check
[2024-07-15 13:00:14] [indexer:background] Health check
[2024-07-15 13:03:43] [index:background] Health check
[2024-07-15 13:04:34] [indexer:background] Health check
[2024-07-15 13:08:51] [index:background] Health check
[2024-07-15 13:09:37] [indexer:background] Health check
[2024-07-15 13:13:45] [index:background] Health check
[2024-07-15 13:14:27] [indexer:background] Health check
[2024-07-15 13:18:50] [index:background] Health check
[2024-07-15 13:21:43] [indexer:background] Health check
[2024-07-15 13:23:44] [index:background] Health check
[2024-07-15 13:25:06] [indexer:background] Health check
[2024-07-15 13:29:08] [index:background] Health check
[2024-07-15 13:29:29] [indexer:background] Health check
[2024-07-15 13:33:48] [index:background] Health check
[2024-07-15 13:34:30] [indexer:background] Health check
[2024-07-15 13:38:50] [index:background] Health check
[2024-07-15 13:39:18] [indexer:background] Health check
[2024-07-15 13:44:16] [index:background] Health check
[2024-07-15 13:44:16] [indexer:background] Health check
[2024-07-15 13:44:16] [indexer:background] Health check
[2024-07-15 13:49:22] [index:background] Health check
[2024-07-15 13:49:22] [indexer:background] Health check
[2024-07-15 13:49:22] [indexer:background] Health check
[2024-07-15 13:53:50] [index:background] Health check
[2024-07-15 13:54:32] [indexer:background] Health check
[2024-07-15 13:58:51] [index:background] Health check
[2024-07-15 14:00:14] [indexer:background] Health check
[2024-07-15 14:04:36] [index:background] Health check
[2024-07-15 14:04:36] [indexer:background] Health check
[2024-07-15 14:04:36] [indexer:background] Health check
[2024-07-15 14:08:49] [index:background] Health check
[2024-07-15 14:10:02] [indexer:background] Health check
[2024-07-15 14:14:20] [index:background] Health check
[2024-07-15 14:14:20] [indexer:background] Health check
[2024-07-15 14:14:20] [indexer:background] Health check
[2024-07-15 14:20:04] [index:background] Health check
[2024-07-15 14:20:04] [indexer:background] Health check
[2024-07-15 14:20:04] [indexer:background] Health check
[2024-07-15 14:23:59] [index:background] Health check
[2024-07-15 14:24:35] [indexer:background] Health check
[2024-07-15 14:28:47] [index:background] Health check
[2024-07-15 14:29:16] [indexer:background] Health check
[2024-07-15 14:33:54] [index:background] Health check
[2024-07-15 14:34:52] [indexer:background] Health check
[2024-07-15 14:38:53] [index:background] Health check
[2024-07-15 14:40:09] [indexer:background] Health check
[2024-07-15 14:44:17] [index:background] Health check
[2024-07-15 14:44:17] [indexer:background] Health check
[2024-07-15 14:44:17] [indexer:background] Health check
[2024-07-15 14:48:42] [index:background] Health check
[2024-07-15 14:50:19] [indexer:background] Health check
[2024-07-15 14:54:18] [index:background] Health check
[2024-07-15 14:54:18] [indexer:background] Health check
[2024-07-15 14:54:18] [indexer:background] Health check
[2024-07-15 14:59:31] [index:background] Health check
[2024-07-15 14:59:31] [indexer:background] Health check
[2024-07-15 14:59:31] [indexer:background] Health check
[2024-07-15 15:04:10] [index:background] Health check
[2024-07-15 15:04:34] [indexer:background] Health check
[2024-07-15 15:09:01] [index:background] Health check
[2024-07-15 15:09:52] [indexer:background] Health check
[2024-07-15 15:13:51] [index:background] Health check
[2024-07-15 15:14:30] [indexer:background] Health check
[2024-07-15 15:18:44] [index:background] Health check
[2024-07-15 15:19:22] [indexer:background] Health check
[2024-07-15 15:23:48] [index:background] Health check
[2024-07-15 15:24:21] [indexer:background] Health check
[2024-07-15 15:29:15] [index:background] Health check
[2024-07-15 15:29:15] [indexer:background] Health check
[2024-07-15 15:29:15] [indexer:background] Health check
[2024-07-15 15:34:49] [index:background] Health check
[2024-07-15 15:34:49] [indexer:background] Health check
[2024-07-15 15:34:49] [indexer:background] Health check
[2024-07-15 15:38:42] [index:background] Health check
[2024-07-15 15:40:13] [indexer:background] Health check
[2024-07-15 15:44:05] [index:background] Health check
[2024-07-15 15:44:36] [indexer:background] Health check
[2024-07-15 15:48:49] [index:background] Health check
[2024-07-15 15:49:31] [indexer:background] Health check
[2024-07-15 15:55:58] [index:background] Health check
[2024-07-15 15:55:58] [indexer:background] Health check
[2024-07-15 15:55:58] [indexer:background] Health check
[2024-07-15 16:01:27] [index:background] Health check
[2024-07-15 16:01:27] [indexer:background] Health check
[2024-07-15 16:01:27] [index:background] Health check
[2024-07-15 16:01:27] [indexer:background] Health check
[2024-07-15 16:01:27] [indexer:background] Health check
[2024-07-15 16:01:27] [indexer:background] Health check
[2024-07-15 16:04:02] [index:background] Health check
[2024-07-15 16:04:17] [indexer:background] Health check
[2024-07-15 16:09:21] [index:background] Health check
[2024-07-15 16:09:21] [indexer:background] Health check
[2024-07-15 16:09:21] [indexer:background] Health check
[2024-07-15 16:13:50] [index:background] Health check
[2024-07-15 16:14:17] [indexer:background] Health check
[2024-07-15 16:19:44] [index:background] Health check
[2024-07-15 16:19:44] [index:background] CPU load threshold (3) breached: 7.88 [waiting 2]
[2024-07-15 16:19:46] [indexer:background] CPU load threshold (3) breached: 7.49 [waiting 2]
[2024-07-15 16:19:48] [indexer:background] Health check
[2024-07-15 16:19:48] [indexer:background] CPU load threshold (3) breached: 7.49 [waiting 2]
[2024-07-15 16:19:50] [indexer:background] Health check
[2024-07-15 16:19:50] [indexer:background] CPU load threshold (3) breached: 7.69 [waiting 2]
[2024-07-15 16:23:51] [index:background] Health check
[2024-07-15 16:23:52] [index:background] CPU load threshold (3) breached: 16.79 [waiting 2]
[2024-07-15 16:23:54] [indexer:background] CPU load threshold (3) breached: 16.79 [waiting 2]
[2024-07-15 16:24:30] [indexer:background] Health check
[2024-07-15 16:24:30] [indexer:background] CPU load threshold (3) breached: 16.9 [waiting 2]
[2024-07-15 16:28:42] [index:background] Health check
[2024-07-15 16:28:42] [index:background] CPU load threshold (3) breached: 18.37 [waiting 2]
[2024-07-15 16:28:44] [indexer:background] CPU load threshold (3) breached: 18.37 [waiting 2]
[2024-07-15 16:29:50] [indexer:background] Health check
[2024-07-15 16:29:50] [indexer:background] CPU load threshold (3) breached: 19.21 [waiting 2]
[2024-07-15 16:33:43] [index:background] Health check
[2024-07-15 16:33:44] [index:background] CPU load threshold (3) breached: 14.34 [waiting 2]
[2024-07-15 16:33:46] [indexer:background] CPU load threshold (3) breached: 13.67 [waiting 2]
[2024-07-15 16:34:24] [indexer:background] Health check
[2024-07-15 16:34:24] [indexer:background] CPU load threshold (3) breached: 11.04 [waiting 2]
[2024-07-15 16:39:32] [index:background] Health check
[2024-07-15 16:39:32] [index:background] CPU load threshold (3) breached: 3.6 [waiting 2]
[2024-07-15 16:39:35] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2]
[2024-07-15 16:39:37] [indexer:background] Health check
[2024-07-15 16:39:37] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2024-07-15 16:39:39] [indexer:background] Health check
[2024-07-15 16:39:39] [indexer:background] CPU load threshold (3) breached: 3.31 [waiting 2]
[2024-07-15 16:43:55] [index:background] Health check
[2024-07-15 16:43:55] [index:background] CPU load threshold (3) breached: 4.55 [waiting 2]
[2024-07-15 16:43:57] [indexer:background] CPU load threshold (3) breached: 4.34 [waiting 2]
[2024-07-15 16:44:18] [indexer:background] Health check
[2024-07-15 16:44:18] [indexer:background] CPU load threshold (3) breached: 4.65 [waiting 2]
[2024-07-15 16:46:29] [query] Query for: 2023
[2024-07-15 16:46:29] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-15 16:46:29] [query] Engine: default
[2024-07-15 16:46:30] [query] Tokens: 2023
[2024-07-15 16:46:30] [query] Mods: 6
[2024-07-15 16:46:31] [query] Found results using: or logic
[2024-07-15 16:46:31] [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-07-15 16:46:31] [query] Results: 280 Pages of results: 28
[2024-07-15 16:46:31] [query] Execution time: 1.91185
[2024-07-15 16:49:51] [index:background] Health check
[2024-07-15 16:49:51] [index:background] CPU load threshold (3) breached: 6.41 [waiting 2]
[2024-07-15 16:49:53] [indexer:background] CPU load threshold (3) breached: 6.41 [waiting 2]
[2024-07-15 16:49:55] [indexer:background] Health check
[2024-07-15 16:49:55] [indexer:background] CPU load threshold (3) breached: 6.41 [waiting 2]
[2024-07-15 16:49:57] [indexer:background] Health check
[2024-07-15 16:49:57] [indexer:background] CPU load threshold (3) breached: 6.46 [waiting 2]
[2024-07-15 16:54:13] [index:background] Health check
[2024-07-15 16:54:13] [index:background] CPU load threshold (3) breached: 6.5 [waiting 2]
[2024-07-15 16:54:16] [indexer:background] CPU load threshold (3) breached: 6.5 [waiting 2]
[2024-07-15 16:55:15] [indexer:background] Health check
[2024-07-15 16:55:15] [indexer:background] CPU load threshold (3) breached: 7.17 [waiting 2]
[2024-07-15 16:58:44] [index:background] Health check
[2024-07-15 16:58:44] [index:background] CPU load threshold (3) breached: 6.1 [waiting 2]
[2024-07-15 16:58:46] [indexer:background] CPU load threshold (3) breached: 6.1 [waiting 2]
[2024-07-15 16:59:18] [indexer:background] Health check
[2024-07-15 16:59:18] [indexer:background] CPU load threshold (3) breached: 5.52 [waiting 2]
[2024-07-15 17:04:04] [index:background] Health check
[2024-07-15 17:04:04] [index:background] CPU load threshold (3) breached: 4.04 [waiting 2]
[2024-07-15 17:04:06] [indexer:background] CPU load threshold (3) breached: 3.96 [waiting 2]
[2024-07-15 17:04:35] [indexer:background] Health check
[2024-07-15 17:04:35] [indexer:background] CPU load threshold (3) breached: 3.93 [waiting 2]
[2024-07-15 17:08:51] [index:background] Health check
[2024-07-15 17:09:44] [indexer:background] Health check
[2024-07-15 17:14:55] [index:background] Health check
[2024-07-15 17:14:55] [indexer:background] Health check
[2024-07-15 17:14:55] [indexer:background] Health check
[2024-07-15 17:18:47] [index:background] Health check
[2024-07-15 17:19:33] [indexer:background] Health check
[2024-07-15 17:23:42] [index:background] Health check
[2024-07-15 17:24:18] [indexer:background] Health check
[2024-07-15 17:28:59] [index:background] Health check
[2024-07-15 17:29:53] [indexer:background] Health check
[2024-07-15 17:33:48] [index:background] Health check
[2024-07-15 17:36:00] [indexer:background] Health check
[2024-07-15 17:38:41] [index:background] Health check
[2024-07-15 17:40:09] [indexer:background] Health check
[2024-07-15 17:43:45] [index:background] Health check
[2024-07-15 17:44:24] [indexer:background] Health check
[2024-07-15 17:49:02] [index:background] Health check
[2024-07-15 17:49:50] [indexer:background] Health check
[2024-07-15 17:55:12] [index:background] Health check
[2024-07-15 17:55:12] [indexer:background] Health check
[2024-07-15 17:55:12] [indexer:background] Health check
[2024-07-15 18:00:16] [index:background] Health check
[2024-07-15 18:00:16] [indexer:background] Health check
[2024-07-15 18:00:17] [indexer:background] Health check
[2024-07-15 18:03:46] [index:background] Health check
[2024-07-15 18:04:36] [indexer:background] Health check
[2024-07-15 18:08:05] [query] Query for: 2024
[2024-07-15 18:08:05] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-15 18:08:05] [query] Engine: default
[2024-07-15 18:08:05] [query] Tokens: 2024
[2024-07-15 18:08:05] [query] Mods: 6
[2024-07-15 18:08:06] [query] Found results using: or logic
[2024-07-15 18:08: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 (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-07-15 18:08:06] [query] Results: 159 Pages of results: 16
[2024-07-15 18:08:06] [query] Execution time: 1.07290
[2024-07-15 18:08:06] [query] Query for: 2024
[2024-07-15 18:08:06] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-07-15 18:08:06] [query] Engine: default
[2024-07-15 18:08:06] [query] Tokens: 2024
[2024-07-15 18:08:06] [query] Mods: 6
[2024-07-15 18:08:06] [query] Found results using: or logic
[2024-07-15 18:08: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 (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-07-15 18:08:06] [query] Results: 159 Pages of results: 2
[2024-07-15 18:08:06] [query] Execution time: 0.16703
[2024-07-15 18:09:59] [index:background] Health check
[2024-07-15 18:09:59] [indexer:background] Health check
[2024-07-15 18:09:59] [indexer:background] Health check
[2024-07-15 18:13:49] [index:background] Health check
[2024-07-15 18:14:19] [indexer:background] Health check
[2024-07-15 18:19:22] [index:background] Health check
[2024-07-15 18:19:22] [indexer:background] Health check
[2024-07-15 18:19:22] [indexer:background] Health check
[2024-07-15 18:23:52] [index:background] Health check
[2024-07-15 18:25:00] [indexer:background] Health check
[2024-07-15 18:28:41] [index:background] Health check
[2024-07-15 18:30:47] [indexer:background] Health check
[2024-07-15 18:35:15] [index:background] Health check
[2024-07-15 18:35:16] [indexer:background] Health check
[2024-07-15 18:35:16] [indexer:background] Health check
[2024-07-15 18:38:52] [index:background] Health check
[2024-07-15 18:39:23] [indexer:background] Health check
[2024-07-15 18:44:43] [index:background] Health check
[2024-07-15 18:44:43] [indexer:background] Health check
[2024-07-15 18:44:43] [indexer:background] Health check
[2024-07-15 18:48:58] [index:background] Health check
[2024-07-15 18:50:13] [indexer:background] Health check
[2024-07-15 18:54:13] [index:background] Health check
[2024-07-15 18:54:43] [indexer:background] Health check
[2024-07-15 18:57:02] [query] Query for: 2024
[2024-07-15 18:57:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-07-15 18:57:02] [query] Engine: default
[2024-07-15 18:57:02] [query] Tokens: 2024
[2024-07-15 18:57:02] [query] Mods: 6
[2024-07-15 18:57:02] [query] Found results using: or logic
[2024-07-15 18:57:02] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (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-07-15 18:57:02] [query] Results: 159 Pages of results: 16
[2024-07-15 18:57:02] [query] Execution time: 0.29599
[2024-07-15 19:01:03] [index:background] Health check
[2024-07-15 19:01:03] [indexer:background] Health check
[2024-07-15 19:01:03] [indexer:background] Health check
[2024-07-15 19:03:45] [index:background] Health check
[2024-07-15 19:05:51] [indexer:background] Health check
[2024-07-15 19:11:09] [index:background] Health check
[2024-07-15 19:11:09] [indexer:background] Health check
[2024-07-15 19:11:09] [indexer:background] Health check
[2024-07-15 19:15:52] [index:background] Health check
[2024-07-15 19:15:52] [indexer:background] Health check
[2024-07-15 19:15:52] [indexer:background] Health check
[2024-07-15 19:18:43] [index:background] Health check
[2024-07-15 19:19:37] [indexer:background] Health check
[2024-07-15 19:24:30] [index:background] Health check
[2024-07-15 19:24:30] [indexer:background] Health check
[2024-07-15 19:24:30] [indexer:background] Health check
[2024-07-15 19:28:44] [index:background] Health check
[2024-07-15 19:29:17] [indexer:background] Health check
[2024-07-15 19:33:44] [index:background] Health check
[2024-07-15 19:34:17] [indexer:background] Health check
[2024-07-15 19:38:42] [index:background] Health check
[2024-07-15 19:39:17] [indexer:background] Health check
[2024-07-15 19:43:43] [index:background] Health check
[2024-07-15 19:44:17] [indexer:background] Health check
[2024-07-15 19:48:44] [index:background] Health check
[2024-07-15 19:49:19] [indexer:background] Health check
[2024-07-15 19:53:42] [index:background] Health check
[2024-07-15 19:54:18] [indexer:background] Health check
[2024-07-15 19:58:43] [index:background] Health check
[2024-07-15 19:59:18] [indexer:background] Health check
[2024-07-15 20:03:44] [index:background] Health check
[2024-07-15 20:04:17] [indexer:background] Health check
[2024-07-15 20:08:44] [index:background] Health check
[2024-07-15 20:09:17] [indexer:background] Health check
[2024-07-15 20:13:43] [index:background] Health check
[2024-07-15 20:14:16] [indexer:background] Health check
[2024-07-15 20:18:42] [index:background] Health check
[2024-07-15 20:19:17] [indexer:background] Health check
[2024-07-15 20:23:43] [index:background] Health check
[2024-07-15 20:24:16] [indexer:background] Health check
[2024-07-15 20:28:43] [index:background] Health check
[2024-07-15 20:29:18] [indexer:background] Health check
[2024-07-15 20:33:43] [index:background] Health check
[2024-07-15 20:34:18] [indexer:background] Health check
[2024-07-15 20:38:44] [index:background] Health check
[2024-07-15 20:39:17] [indexer:background] Health check
[2024-07-15 20:43:43] [index:background] Health check
[2024-07-15 20:44:17] [indexer:background] Health check
[2024-07-15 20:48:43] [index:background] Health check
[2024-07-15 20:49:18] [indexer:background] Health check
[2024-07-15 20:53:42] [index:background] Health check
[2024-07-15 20:54:16] [indexer:background] Health check
[2024-07-15 20:58:43] [index:background] Health check
[2024-07-15 20:59:17] [indexer:background] Health check
[2024-07-15 21:03:43] [index:background] Health check
[2024-07-15 21:04:17] [indexer:background] Health check
[2024-07-15 21:08:44] [index:background] Health check
[2024-07-15 21:09:16] [indexer:background] Health check
[2024-07-15 21:13:42] [index:background] Health check
[2024-07-15 21:14:19] [indexer:background] Health check
[2024-07-15 21:18:43] [index:background] Health check
[2024-07-15 21:19:18] [indexer:background] Health check
[2024-07-15 21:23:43] [index:background] Health check
[2024-07-15 21:24:16] [indexer:background] Health check
[2024-07-15 21:28:43] [index:background] Health check
[2024-07-15 21:29:21] [indexer:background] Health check
[2024-07-15 21:33:42] [index:background] Health check
[2024-07-15 21:34:16] [indexer:background] Health check
[2024-07-15 21:38:43] [index:background] Health check
[2024-07-15 21:39:16] [indexer:background] Health check
[2024-07-15 21:43:43] [index:background] Health check
[2024-07-15 21:44:17] [indexer:background] Health check
[2024-07-15 21:48:42] [index:background] Health check
[2024-07-15 21:49:16] [indexer:background] Health check
[2024-07-15 21:53:43] [index:background] Health check
[2024-07-15 21:54:16] [indexer:background] Health check
[2024-07-15 21:58:42] [index:background] Health check
[2024-07-15 21:59:18] [indexer:background] Health check
[2024-07-15 22:03:42] [index:background] Health check
[2024-07-15 22:04:18] [indexer:background] Health check
[2024-07-15 22:08:45] [index:background] Health check
[2024-07-15 22:09:17] [indexer:background] Health check
[2024-07-15 22:13:43] [index:background] Health check
[2024-07-15 22:14:17] [indexer:background] Health check
[2024-07-15 22:18:43] [index:background] Health check
[2024-07-15 22:19:17] [indexer:background] Health check
[2024-07-15 22:23:43] [index:background] Health check
[2024-07-15 22:24:17] [indexer:background] Health check
[2024-07-15 22:28:43] [index:background] Health check
[2024-07-15 22:29:17] [indexer:background] Health check
[2024-07-15 22:33:43] [index:background] Health check
[2024-07-15 22:34:17] [indexer:background] Health check
[2024-07-15 22:38:43] [index:background] Health check
[2024-07-15 22:39:17] [indexer:background] Health check
[2024-07-15 22:43:43] [index:background] Health check
[2024-07-15 22:44:17] [indexer:background] Health check
[2024-07-15 22:48:43] [index:background] Health check
[2024-07-15 22:49:17] [indexer:background] Health check
[2024-07-15 22:53:43] [index:background] Health check
[2024-07-15 22:54:16] [indexer:background] Health check
[2024-07-15 22:58:42] [index:background] Health check
[2024-07-15 22:59:16] [indexer:background] Health check
[2024-07-15 23:03:44] [index:background] Health check
[2024-07-15 23:04:17] [indexer:background] Health check
[2024-07-15 23:08:43] [index:background] Health check
[2024-07-15 23:09:17] [indexer:background] Health check
[2024-07-15 23:13:43] [index:background] Health check
[2024-07-15 23:14:17] [indexer:background] Health check
[2024-07-15 23:18:43] [index:background] Health check
[2024-07-15 23:19:16] [indexer:background] Health check
[2024-07-15 23:23:43] [index:background] Health check
[2024-07-15 23:24:17] [indexer:background] Health check
[2024-07-15 23:28:44] [index:background] Health check
[2024-07-15 23:29:17] [indexer:background] Health check
[2024-07-15 23:33:44] [index:background] Health check
[2024-07-15 23:34:18] [indexer:background] Health check
[2024-07-15 23:38:43] [index:background] Health check
[2024-07-15 23:39:17] [indexer:background] Health check
[2024-07-15 23:43:44] [index:background] Health check
[2024-07-15 23:44:18] [indexer:background] Health check
[2024-07-15 23:48:42] [index:background] Health check
[2024-07-15 23:49:17] [indexer:background] Health check
[2024-07-15 23:53:43] [index:background] Health check
[2024-07-15 23:54:17] [indexer:background] Health check
[2024-07-15 23:58:43] [index:background] Health check
[2024-07-15 23:59:17] [indexer:background] Health check