[2023-04-12 00:02:04] [indexer:background] Health check [2023-04-12 00:02:07] [index:background] Health check [2023-04-12 00:05:49] [indexer:background] Health check [2023-04-12 00:05:49] [index:background] Health check [2023-04-12 00:09:33] [indexer:background] Health check [2023-04-12 00:09:33] [index:background] Health check [2023-04-12 00:13:23] [indexer:background] Health check [2023-04-12 00:14:30] [index:background] Health check [2023-04-12 00:20:18] [indexer:background] Health check [2023-04-12 00:20:18] [index:background] Health check [2023-04-12 00:23:10] [indexer:background] Health check [2023-04-12 00:25:07] [index:background] Health check [2023-04-12 00:28:35] [indexer:background] Health check [2023-04-12 00:30:23] [index:background] Health check [2023-04-12 00:33:21] [indexer:background] Health check [2023-04-12 00:34:14] [index:background] Health check [2023-04-12 00:39:07] [indexer:background] Health check [2023-04-12 00:39:18] [index:background] Health check [2023-04-12 00:44:19] [indexer:background] Health check [2023-04-12 00:44:19] [index:background] Health check [2023-04-12 00:48:11] [indexer:background] Health check [2023-04-12 00:49:13] [index:background] Health check [2023-04-12 00:53:10] [indexer:background] Health check [2023-04-12 00:54:14] [index:background] Health check [2023-04-12 01:01:25] [indexer:background] Health check [2023-04-12 01:01:25] [index:background] Health check [2023-04-12 01:03:12] [indexer:background] Health check [2023-04-12 01:07:52] [index:background] Health check [2023-04-12 01:08:08] [indexer:background] Health check [2023-04-12 01:10:36] [index:background] Health check [2023-04-12 01:13:43] [indexer:background] Health check [2023-04-12 01:14:20] [index:background] Health check [2023-04-12 01:18:07] [indexer:background] Health check [2023-04-12 01:19:36] [index:background] Health check [2023-04-12 01:23:14] [indexer:background] Health check [2023-04-12 01:25:35] [index:background] Health check [2023-04-12 01:29:23] [indexer:background] Health check [2023-04-12 01:29:23] [index:background] Health check [2023-04-12 01:33:08] [indexer:background] Health check [2023-04-12 01:34:58] [index:background] Health check [2023-04-12 01:40:21] [indexer:background] Health check [2023-04-12 01:40:21] [index:background] Health check [2023-04-12 01:44:30] [indexer:background] Health check [2023-04-12 01:44:30] [index:background] Health check [2023-04-12 01:48:38] [indexer:background] Health check [2023-04-12 01:54:37] [index:background] Health check [2023-04-12 01:54:40] [indexer:background] Health check [2023-04-12 01:54:40] [indexer:background] Health check [2023-04-12 01:58:17] [indexer:background] Health check [2023-04-12 01:59:15] [index:background] Health check [2023-04-12 02:04:58] [indexer:background] Health check [2023-04-12 02:04:58] [index:background] Health check [2023-04-12 02:10:07] [indexer:background] Health check [2023-04-12 02:10:10] [index:background] Health check [2023-04-12 02:14:11] [indexer:background] Health check [2023-04-12 02:14:44] [index:background] Health check [2023-04-12 02:20:25] [indexer:background] Health check [2023-04-12 02:20:28] [index:background] Health check [2023-04-12 02:24:11] [indexer:background] Health check [2023-04-12 02:24:11] [index:background] Health check [2023-04-12 02:28:14] [indexer:background] Health check [2023-04-12 02:29:28] [index:background] Health check [2023-04-12 02:33:13] [indexer:background] Health check [2023-04-12 02:34:16] [index:background] Health check [2023-04-12 02:38:06] [indexer:background] Health check [2023-04-12 02:38:06] [indexer:background] CPU load threshold (3) breached: 4.36 [waiting 2] [2023-04-12 02:43:25] [index:background] Health check [2023-04-12 02:43:27] [indexer:background] Health check [2023-04-12 02:43:27] [indexer:background] Health check [2023-04-12 02:44:45] [index:background] Health check [2023-04-12 02:48:29] [indexer:background] Health check [2023-04-12 02:49:44] [index:background] Health check [2023-04-12 02:53:57] [indexer:background] Health check [2023-04-12 02:54:52] [index:background] Health check [2023-04-12 02:59:51] [indexer:background] Health check [2023-04-12 02:59:54] [index:background] Health check [2023-04-12 03:03:21] [indexer:background] Health check [2023-04-12 03:06:31] [index:background] Health check [2023-04-12 03:10:02] [indexer:background] Health check [2023-04-12 03:10:02] [index:background] Health check [2023-04-12 03:13:17] [indexer:background] Health check [2023-04-12 03:14:24] [index:background] Health check [2023-04-12 03:20:22] [indexer:background] Health check [2023-04-12 03:20:22] [index:background] Health check [2023-04-12 03:24:57] [indexer:background] Health check [2023-04-12 03:24:57] [index:background] Health check [2023-04-12 03:29:20] [indexer:background] Health check [2023-04-12 03:29:20] [index:background] Health check [2023-04-12 03:33:06] [indexer:background] Health check [2023-04-12 03:34:17] [index:background] Health check [2023-04-12 03:39:37] [indexer:background] Health check [2023-04-12 03:39:37] [index:background] Health check [2023-04-12 03:45:32] [indexer:background] Health check [2023-04-12 03:45:34] [index:background] Health check [2023-04-12 03:48:35] [indexer:background] Health check [2023-04-12 03:52:43] [index:background] Health check [2023-04-12 03:55:18] [indexer:background] Health check [2023-04-12 03:55:21] [index:background] Health check [2023-04-12 03:58:06] [indexer:background] Health check [2023-04-12 04:00:23] [index:background] Health check [2023-04-12 04:05:17] [indexer:background] Health check [2023-04-12 04:05:17] [index:background] Health check [2023-04-12 04:08:37] [indexer:background] Health check [2023-04-12 04:09:19] [index:background] Health check [2023-04-12 04:13:04] [indexer:background] Health check [2023-04-12 04:16:59] [index:background] Health check [2023-04-12 04:21:32] [indexer:background] Health check [2023-04-12 04:21:32] [index:background] Health check [2023-04-12 04:25:37] [indexer:background] Health check [2023-04-12 04:25:37] [index:background] Health check [2023-04-12 04:28:15] [indexer:background] Health check [2023-04-12 04:29:16] [index:background] Health check [2023-04-12 04:36:20] [indexer:background] Health check [2023-04-12 04:36:20] [index:background] Health check [2023-04-12 04:38:08] [indexer:background] Health check [2023-04-12 04:39:20] [index:background] Health check [2023-04-12 04:43:22] [indexer:background] Health check [2023-04-12 04:46:08] [index:background] Health check [2023-04-12 04:48:07] [indexer:background] Health check [2023-04-12 04:51:08] [index:background] Health check [2023-04-12 04:54:08] [indexer:background] Health check [2023-04-12 04:54:12] [index:background] Health check [2023-04-12 04:58:54] [indexer:background] Health check [2023-04-12 05:01:10] [index:background] Health check [2023-04-12 05:04:32] [indexer:background] Health check [2023-04-12 05:04:32] [index:background] Health check [2023-04-12 05:08:34] [indexer:background] Health check [2023-04-12 05:12:23] [index:background] Health check [2023-04-12 05:13:12] [indexer:background] Health check [2023-04-12 05:14:29] [index:background] Health check [2023-04-12 05:19:09] [indexer:background] Health check [2023-04-12 05:19:09] [index:background] Health check [2023-04-12 05:23:15] [indexer:background] Health check [2023-04-12 05:24:13] [index:background] Health check [2023-04-12 05:28:41] [indexer:background] Health check [2023-04-12 05:30:34] [index:background] Health check [2023-04-12 05:34:02] [indexer:background] Health check [2023-04-12 05:34:11] [index:background] Health check [2023-04-12 05:38:07] [indexer:background] Health check [2023-04-12 05:39:34] [index:background] Health check [2023-04-12 05:43:06] [indexer:background] Health check [2023-04-12 05:44:52] [index:background] Health check [2023-04-12 05:48:48] [indexer:background] Health check [2023-04-12 05:51:43] [index:background] Health check [2023-04-12 05:54:27] [indexer:background] Health check [2023-04-12 05:54:30] [index:background] Health check [2023-04-12 05:58:42] [indexer:background] Health check [2023-04-12 05:59:12] [index:background] Health check [2023-04-12 06:03:15] [indexer:background] Health check [2023-04-12 06:04:30] [index:background] Health check [2023-04-12 06:09:48] [indexer:background] Health check [2023-04-12 06:09:51] [index:background] Health check [2023-04-12 06:14:07] [indexer:background] Health check [2023-04-12 06:14:28] [index:background] Health check [2023-04-12 06:18:59] [indexer:background] Health check [2023-04-12 06:20:09] [index:background] Health check [2023-04-12 06:25:19] [indexer:background] Health check [2023-04-12 06:25:22] [index:background] Health check [2023-04-12 06:28:31] [indexer:background] Health check [2023-04-12 06:30:05] [index:background] Health check [2023-04-12 06:35:00] [indexer:background] Health check [2023-04-12 06:35:00] [index:background] Health check [2023-04-12 06:38:21] [indexer:background] Health check [2023-04-12 06:39:14] [index:background] Health check [2023-04-12 06:43:27] [indexer:background] Health check [2023-04-12 06:44:21] [index:background] Health check [2023-04-12 06:48:22] [indexer:background] Health check [2023-04-12 06:49:29] [index:background] Health check [2023-04-12 06:54:35] [indexer:background] Health check [2023-04-12 06:54:39] [index:background] Health check [2023-04-12 06:58:12] [indexer:background] Health check [2023-04-12 07:00:12] [index:background] Health check [2023-04-12 07:04:22] [indexer:background] Health check [2023-04-12 07:04:22] [index:background] Health check [2023-04-12 07:08:23] [indexer:background] Health check [2023-04-12 07:09:28] [index:background] Health check [2023-04-12 07:14:01] [indexer:background] Health check [2023-04-12 07:14:55] [index:background] Health check [2023-04-12 07:18:06] [indexer:background] Health check [2023-04-12 07:19:31] [index:background] Health check [2023-04-12 07:23:09] [indexer:background] Health check [2023-04-12 07:24:47] [index:background] Health check [2023-04-12 07:30:13] [indexer:background] Health check [2023-04-12 07:30:16] [index:background] Health check [2023-04-12 07:33:24] [indexer:background] Health check [2023-04-12 07:34:17] [index:background] Health check [2023-04-12 07:39:46] [indexer:background] Health check [2023-04-12 07:39:46] [index:background] Health check [2023-04-12 07:43:50] [indexer:background] Health check [2023-04-12 07:44:59] [index:background] Health check [2023-04-12 07:49:50] [indexer:background] Health check [2023-04-12 07:49:50] [index:background] Health check [2023-04-12 07:53:13] [indexer:background] Health check [2023-04-12 07:54:26] [index:background] Health check [2023-04-12 07:58:36] [indexer:background] Health check [2023-04-12 07:59:16] [index:background] Health check [2023-04-12 08:03:38] [indexer:background] Health check [2023-04-12 08:05:45] [index:background] Health check [2023-04-12 08:08:09] [indexer:background] Health check [2023-04-12 08:10:59] [index:background] Health check [2023-04-12 08:14:16] [indexer:background] Health check [2023-04-12 08:14:20] [index:background] Health check [2023-04-12 08:18:11] [indexer:background] Health check [2023-04-12 08:20:19] [index:background] Health check [2023-04-12 08:24:20] [indexer:background] Health check [2023-04-12 08:24:20] [index:background] Health check [2023-04-12 08:28:27] [indexer:background] Health check [2023-04-12 08:30:30] [index:background] Health check [2023-04-12 08:33:07] [indexer:background] Health check [2023-04-12 08:34:18] [index:background] Health check [2023-04-12 08:38:18] [indexer:background] Health check [2023-04-12 08:39:13] [index:background] Health check [2023-04-12 08:43:55] [indexer:background] Health check [2023-04-12 08:44:41] [index:background] Health check [2023-04-12 08:48:29] [indexer:background] Health check [2023-04-12 08:49:13] [index:background] Health check [2023-04-12 08:53:11] [indexer:background] Health check [2023-04-12 08:54:30] [index:background] Health check [2023-04-12 08:58:18] [indexer:background] Health check [2023-04-12 08:59:37] [index:background] Health check [2023-04-12 09:03:57] [indexer:background] Health check [2023-04-12 09:06:16] [index:background] Health check [2023-04-12 09:09:07] [indexer:background] Health check [2023-04-12 09:09:58] [index:background] Health check [2023-04-12 09:17:16] [indexer:background] Health check [2023-04-12 09:17:16] [index:background] Health check [2023-04-12 09:18:11] [indexer:background] Health check [2023-04-12 09:19:43] [index:background] Health check [2023-04-12 09:23:22] [indexer:background] Health check [2023-04-12 09:24:19] [index:background] Health check [2023-04-12 09:28:40] [indexer:background] Health check [2023-04-12 09:30:16] [index:background] Health check [2023-04-12 09:33:06] [indexer:background] Health check [2023-04-12 09:34:19] [index:background] Health check [2023-04-12 09:39:49] [indexer:background] Health check [2023-04-12 09:39:49] [index:background] Health check [2023-04-12 09:43:09] [indexer:background] Health check [2023-04-12 09:44:43] [index:background] Health check [2023-04-12 09:49:34] [indexer:background] Health check [2023-04-12 09:49:34] [index:background] Health check [2023-04-12 09:53:43] [indexer:background] Health check [2023-04-12 09:54:28] [index:background] Health check [2023-04-12 09:59:01] [indexer:background] Health check [2023-04-12 09:59:50] [index:background] Health check [2023-04-12 10:03:17] [indexer:background] Health check [2023-04-12 10:05:49] [index:background] Health check [2023-04-12 10:08:30] [indexer:background] Health check [2023-04-12 10:10:33] [index:background] Health check [2023-04-12 10:13:24] [indexer:background] Health check [2023-04-12 10:14:12] [index:background] Health check [2023-04-12 10:18:30] [indexer:background] Health check [2023-04-12 10:19:16] [index:background] Health check [2023-04-12 10:20:32] [query] Query for: djombo [2023-04-12 10:20:32] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 10:20:32] [query] Engine: default [2023-04-12 10:20:32] [query] Tokens: djombo [2023-04-12 10:20:32] [query] Mods: 3 [2023-04-12 10:20:33] [query] Found results using: or logic [2023-04-12 10:22:08] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (3834) 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 [2023-04-12 10:22:08] [query] Results: 173 Pages of results: 1 [2023-04-12 10:22:08] [query] Execution time: 95.55653 [2023-04-12 10:22:09] [query] Query for: djombo [2023-04-12 10:22:09] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 10:22:09] [query] Engine: default [2023-04-12 10:22:09] [query] Tokens: djombo [2023-04-12 10:22:09] [query] Mods: 3 [2023-04-12 10:22:09] [query] Found results using: or logic [2023-04-12 10:23:09] [indexer:background] Health check [2023-04-12 10:24:16] [index:background] Health check [2023-04-12 10:25:36] [index] Marking post.page 5430 to be dropped [2023-04-12 10:25:36] [index] Marking post.page 5560 to be dropped [2023-04-12 10:25:40] [index] Dropping post.page 5430 [2023-04-12 10:25:40] [index] Dropping post.page 5560 [2023-04-12 10:25:40] [indexer] Queued next batch (2) [2023-04-12 10:25:42] [indexer] Processing batch (2) [2023-04-12 10:25:42] [indexer] Indexing post.page:5430 [2023-04-12 10:25:42] [index] Marking [1] post.page 5430 as indexed [2023-04-12 10:25:42] [indexer] Indexing post.page:5560 [2023-04-12 10:25:42] [index] Marking [1] post.page 5560 as indexed [2023-04-12 10:25:42] [indexer] Index built [2023-04-12 10:25:56] [query] Query for: djombo [2023-04-12 10:25:56] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 10:25:56] [query] Engine: default [2023-04-12 10:25:56] [query] Tokens: djombo [2023-04-12 10:25:56] [query] Mods: 3 [2023-04-12 10:25:57] [query] Found results using: or logic [2023-04-12 10:26:28] [query] Query for: djom [2023-04-12 10:26:28] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: 50 page: 1 offset: 0 fields: all [2023-04-12 10:26:28] [query] Engine: default [2023-04-12 10:26:28] [query] Tokens: djoma, djomas, djom [2023-04-12 10:26:28] [query] Mods: 3 [2023-04-12 10:26:28] [query] Using OR logic [2023-04-12 10:26:29] [query] Found results using: and logic [2023-04-12 10:26: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.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 (93782,687819,165250) 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 [2023-04-12 10:26:35] [query] Results: 8 Pages of results: 1 [2023-04-12 10:26:35] [query] Execution time: 6.44476 [2023-04-12 10:26:35] [query] Query for: djombo [2023-04-12 10:26:35] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: 50 page: 1 offset: 0 fields: all [2023-04-12 10:26:35] [query] Engine: default [2023-04-12 10:26:35] [query] Tokens: djombo [2023-04-12 10:26:35] [query] Mods: 3 [2023-04-12 10:26:35] [query] Found results using: or logic [2023-04-12 10:27:25] [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 (3834) 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 [2023-04-12 10:27:25] [query] Results: 173 Pages of results: 4 [2023-04-12 10:27:25] [query] Execution time: 50.20295 [2023-04-12 10:27: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.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 (3834) 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 [2023-04-12 10:27:35] [query] Results: 173 Pages of results: 1 [2023-04-12 10:27:35] [query] Execution time: 99.57802 [2023-04-12 10:27:39] [query] Query for: djombo [2023-04-12 10:27:39] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: 100 page: 1 offset: 0 fields: all [2023-04-12 10:27:39] [query] Engine: default [2023-04-12 10:27:39] [query] Tokens: djombo [2023-04-12 10:27:39] [query] Mods: 3 [2023-04-12 10:27:39] [query] Found results using: or logic [2023-04-12 10:28:10] [indexer:background] Health check [2023-04-12 10:28:10] [indexer:background] CPU load threshold (3) breached: 4.31 [waiting 2] [2023-04-12 10:28:53] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (3834) 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 [2023-04-12 10:28:53] [query] Results: 173 Pages of results: 2 [2023-04-12 10:28:53] [query] Execution time: 74.64411 [2023-04-12 10:29:14] [index:background] Health check [2023-04-12 10:29:14] [index:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2023-04-12 10:29:16] [indexer:background] CPU load threshold (3) breached: 3.74 [waiting 2] [2023-04-12 10:33:15] [indexer:background] Health check [2023-04-12 10:35:05] [index:background] Health check [2023-04-12 10:35:08] [settings] Displaying options page [2023-04-12 12:21:57] [index:background] Health check [2023-04-12 12:22:03] [settings] Displaying options page [2023-04-12 12:22:10] [settings] Displaying options page [2023-04-12 12:23:58] [indexer:background] Health check [2023-04-12 12:24:03] [settings] Displaying options page [2023-04-12 12:24:10] [settings] Displaying options page [2023-04-12 12:27:15] [index:background] Health check [2023-04-12 12:30:03] [indexer:background] Health check [2023-04-12 12:31:58] [index:background] Health check [2023-04-12 12:34:23] [indexer:background] Health check [2023-04-12 12:36:59] [index:background] Health check [2023-04-12 12:39:16] [indexer:background] Health check [2023-04-12 12:41:58] [index:background] Health check [2023-04-12 12:44:00] [indexer:background] Health check [2023-04-12 12:49:31] [index:background] Health check [2023-04-12 12:49:31] [indexer:background] Health check [2023-04-12 12:49:31] [indexer:background] Health check [2023-04-12 12:53:00] [index:background] Health check [2023-04-12 12:55:10] [indexer:background] Health check [2023-04-12 12:57:36] [index:background] Health check [2023-04-12 12:59:29] [indexer:background] Health check [2023-04-12 13:02:13] [index:background] Health check [2023-04-12 13:05:19] [indexer:background] Health check [2023-04-12 13:07:32] [index:background] Health check [2023-04-12 13:09:33] [indexer:background] Health check [2023-04-12 13:12:28] [index:background] Health check [2023-04-12 13:15:09] [indexer:background] Health check [2023-04-12 13:18:12] [index:background] Health check [2023-04-12 13:20:50] [query] Query for: djombo [2023-04-12 13:20:50] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 13:20:50] [query] Engine: default [2023-04-12 13:20:51] [query] Tokens: djombo [2023-04-12 13:20:51] [query] Mods: 3 [2023-04-12 13:20:51] [query] Found results using: or logic [2023-04-12 13:20:53] [indexer:background] Health check [2023-04-12 13:21:22] [query] Query for: djombo [2023-04-12 13:21:22] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 13:21:22] [query] Engine: default [2023-04-12 13:21:22] [query] Tokens: djombo [2023-04-12 13:21:22] [query] Mods: 3 [2023-04-12 13:21:22] [query] Found results using: or logic [2023-04-12 13:22:01] [index:background] Health check [2023-04-12 13:22:01] [index:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-04-12 13:22:03] [indexer:background] CPU load threshold (3) breached: 3.07 [waiting 2] [2023-04-12 13:22:55] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (3834) 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 [2023-04-12 13:22:55] [query] Results: 173 Pages of results: 1 [2023-04-12 13:22:55] [query] Execution time: 93.64651 [2023-04-12 13:22:56] [query] Query for: djombo [2023-04-12 13:22:56] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 13:22:56] [query] Engine: default [2023-04-12 13:22:56] [query] Tokens: djombo [2023-04-12 13:22:56] [query] Mods: 3 [2023-04-12 13:22:56] [query] Found results using: or logic [2023-04-12 13:24:12] [indexer:background] Health check [2023-04-12 13:24:28] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (3834) 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 [2023-04-12 13:24:28] [query] Results: 173 Pages of results: 1 [2023-04-12 13:24:28] [query] Execution time: 92.56264 [2023-04-12 13:24:29] [query] Query for: djombo [2023-04-12 13:24:29] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 13:24:29] [query] Engine: default [2023-04-12 13:24:29] [query] Tokens: djombo [2023-04-12 13:24:29] [query] Mods: 3 [2023-04-12 13:24:29] [query] Found results using: or logic [2023-04-12 13:26:01] [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 (3834) 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 [2023-04-12 13:26:01] [query] Results: 173 Pages of results: 1 [2023-04-12 13:26:01] [query] Execution time: 91.71932 [2023-04-12 13:28:48] [index:background] Health check [2023-04-12 13:29:06] [indexer:background] Health check [2023-04-12 13:33:24] [index:background] Health check [2023-04-12 13:34:14] [indexer:background] Health check [2023-04-12 13:37:39] [index:background] Health check [2023-04-12 13:42:39] [indexer:background] Health check [2023-04-12 13:42:39] [index:background] Health check [2023-04-12 13:45:06] [indexer:background] Health check [2023-04-12 13:49:33] [index:background] Health check [2023-04-12 13:49:33] [indexer:background] Health check [2023-04-12 13:49:33] [indexer:background] Health check [2023-04-12 13:52:10] [index:background] Health check [2023-04-12 13:54:27] [indexer:background] Health check [2023-04-12 13:57:07] [index:background] Health check [2023-04-12 14:01:01] [indexer:background] Health check [2023-04-12 14:02:55] [index:background] Health check [2023-04-12 14:04:29] [indexer:background] Health check [2023-04-12 14:07:33] [index:background] Health check [2023-04-12 14:10:39] [indexer:background] Health check [2023-04-12 14:13:11] [index:background] Health check [2023-04-12 14:14:02] [indexer:background] Health check [2023-04-12 14:19:07] [index:background] Health check [2023-04-12 14:19:07] [indexer:background] Health check [2023-04-12 14:19:07] [indexer:background] Health check [2023-04-12 14:23:38] [index:background] Health check [2023-04-12 14:25:22] [indexer:background] Health check [2023-04-12 14:29:00] [index:background] Health check [2023-04-12 14:29:00] [indexer:background] Health check [2023-04-12 14:29:00] [indexer:background] Health check [2023-04-12 14:32:00] [index:background] Health check [2023-04-12 14:34:46] [indexer:background] Health check [2023-04-12 14:37:00] [index:background] Health check [2023-04-12 14:39:22] [indexer:background] Health check [2023-04-12 14:42:24] [index:background] Health check [2023-04-12 14:44:12] [indexer:background] Health check [2023-04-12 14:46:58] [index:background] Health check [2023-04-12 14:49:11] [indexer:background] Health check [2023-04-12 14:52:02] [index:background] Health check [2023-04-12 14:54:34] [indexer:background] Health check [2023-04-12 14:55:11] [query] Query for: djombo [2023-04-12 14:55:11] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 14:55:11] [query] Engine: default [2023-04-12 14:55:11] [query] Tokens: djombo [2023-04-12 14:55:11] [query] Mods: 3 [2023-04-12 14:55:11] [query] Found results using: or logic [2023-04-12 14:56:44] [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 (3834) 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 [2023-04-12 14:56:44] [query] Results: 173 Pages of results: 1 [2023-04-12 14:56:44] [query] Execution time: 92.77005 [2023-04-12 14:57:16] [index:background] Health check [2023-04-12 14:59:02] [indexer:background] Health check [2023-04-12 15:01:57] [index:background] Health check [2023-04-12 15:04:39] [indexer:background] Health check [2023-04-12 15:06:59] [index:background] Health check [2023-04-12 15:10:02] [indexer:background] Health check [2023-04-12 15:11:06] [settings] Displaying options page [2023-04-12 15:11:26] [settings] Displaying options page [2023-04-12 15:12:10] [index:background] Health check [2023-04-12 15:12:34] [settings] Displaying options page [2023-04-12 15:12:41] [query] Query for: djombo [2023-04-12 15:12:41] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 15:12:41] [query] Engine: default [2023-04-12 15:12:41] [query] Tokens: djombo [2023-04-12 15:12:41] [query] Mods: 3 [2023-04-12 15:12:41] [query] Found results using: or logic [2023-04-12 15:12:41] [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 (3834) 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 [2023-04-12 15:12:41] [query] Results: 173 Pages of results: 1 [2023-04-12 15:12:41] [query] Execution time: 0.16229 [2023-04-12 15:12:43] [query] Query for: djombo [2023-04-12 15:12:43] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 15:12:43] [query] Engine: default [2023-04-12 15:12:43] [query] Tokens: djombo [2023-04-12 15:12:43] [query] Mods: 3 [2023-04-12 15:12:43] [query] Found results using: or logic [2023-04-12 15:12:43] [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 (3834) 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 [2023-04-12 15:12:43] [query] Results: 173 Pages of results: 1 [2023-04-12 15:12:43] [query] Execution time: 0.13417 [2023-04-12 15:12:47] [settings] Displaying options page [2023-04-12 15:15:32] [indexer:background] Health check [2023-04-12 15:17:08] [index:background] Health check [2023-04-12 15:17:14] [query] Query for: djombo [2023-04-12 15:17:14] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 15:17:14] [query] Engine: default [2023-04-12 15:17:14] [query] Tokens: djombo [2023-04-12 15:17:14] [query] Mods: 3 [2023-04-12 15:17:14] [query] Found results using: or logic [2023-04-12 15:17:14] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (3834) 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 [2023-04-12 15:17:14] [query] Results: 173 Pages of results: 1 [2023-04-12 15:17:14] [query] Execution time: 0.13604 [2023-04-12 15:19:06] [indexer:background] Health check [2023-04-12 15:21:57] [index:background] Health check [2023-04-12 15:25:24] [indexer:background] Health check [2023-04-12 15:27:50] [index:background] Health check [2023-04-12 15:29:34] [indexer:background] Health check [2023-04-12 15:32:14] [index:background] Health check [2023-04-12 15:34:07] [indexer:background] Health check [2023-04-12 15:37:20] [index:background] Health check [2023-04-12 15:39:20] [indexer:background] Health check [2023-04-12 15:42:46] [index:background] Health check [2023-04-12 15:44:39] [indexer:background] Health check [2023-04-12 15:47:28] [index:background] Health check [2023-04-12 15:48:58] [indexer:background] Health check [2023-04-12 15:52:37] [index:background] Health check [2023-04-12 15:54:34] [indexer:background] Health check [2023-04-12 15:57:49] [index:background] Health check [2023-04-12 16:01:02] [indexer:background] Health check [2023-04-12 16:02:04] [index:background] Health check [2023-04-12 16:04:13] [indexer:background] Health check [2023-04-12 16:06:59] [index:background] Health check [2023-04-12 16:08:59] [indexer:background] Health check [2023-04-12 16:12:18] [index:background] Health check [2023-04-12 16:14:04] [indexer:background] Health check [2023-04-12 16:17:42] [index:background] Health check [2023-04-12 16:19:20] [indexer:background] Health check [2023-04-12 16:22:05] [index:background] Health check [2023-04-12 16:24:03] [indexer:background] Health check [2023-04-12 16:27:34] [index:background] Health check [2023-04-12 16:29:14] [indexer:background] Health check [2023-04-12 16:32:01] [index:background] Health check [2023-04-12 16:35:02] [indexer:background] Health check [2023-04-12 16:37:28] [index:background] Health check [2023-04-12 16:39:04] [indexer:background] Health check [2023-04-12 16:42:02] [index:background] Health check [2023-04-12 16:44:53] [indexer:background] Health check [2023-04-12 16:47:00] [index:background] Health check [2023-04-12 16:49:20] [indexer:background] Health check [2023-04-12 16:52:41] [index:background] Health check [2023-04-12 16:54:33] [indexer:background] Health check [2023-04-12 16:57:37] [index:background] Health check [2023-04-12 16:58:57] [indexer:background] Health check [2023-04-12 17:02:57] [index:background] Health check [2023-04-12 17:03:59] [indexer:background] Health check [2023-04-12 17:07:02] [index:background] Health check [2023-04-12 17:09:02] [indexer:background] Health check [2023-04-12 17:12:06] [index:background] Health check [2023-04-12 17:14:07] [indexer:background] Health check [2023-04-12 17:17:00] [index:background] Health check [2023-04-12 17:19:27] [indexer:background] Health check [2023-04-12 17:22:42] [index:background] Health check [2023-04-12 17:24:11] [indexer:background] Health check [2023-04-12 17:27:09] [index:background] Health check [2023-04-12 17:28:57] [indexer:background] Health check [2023-04-12 17:32:02] [index:background] Health check [2023-04-12 17:33:57] [indexer:background] Health check [2023-04-12 17:33:57] [indexer:background] CPU load threshold (3) breached: 3.95 [waiting 2] [2023-04-12 17:39:52] [index:background] Health check [2023-04-12 17:39:53] [indexer:background] Health check [2023-04-12 17:39:53] [indexer:background] Health check [2023-04-12 17:42:01] [index:background] Health check [2023-04-12 17:44:08] [indexer:background] Health check [2023-04-12 17:46:59] [index:background] Health check [2023-04-12 17:49:01] [indexer:background] Health check [2023-04-12 17:52:39] [index:background] Health check [2023-04-12 17:52:40] [index:background] Health check [2023-04-12 17:53:09] [query] Query for: djom [2023-04-12 17:53:09] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 17:53:09] [query] Engine: default [2023-04-12 17:53:09] [query] Tokens: djoma, djomas, djom [2023-04-12 17:53:09] [query] Mods: 3 [2023-04-12 17:53:09] [query] Using OR logic [2023-04-12 17:53:10] [query] Found results using: and logic [2023-04-12 17:53:10] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (93782,687819,165250) 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 [2023-04-12 17:53:10] [query] Results: 8 Pages of results: 1 [2023-04-12 17:53:10] [query] Execution time: 0.23706 [2023-04-12 17:53:10] [query] Query for: djombo [2023-04-12 17:53:10] [query] Arguments: engine: default (previously instantiated) mods: 2 site: all per_page: -1 page: 1 offset: 0 fields: all [2023-04-12 17:53:10] [query] Engine: default [2023-04-12 17:53:10] [query] Tokens: djombo [2023-04-12 17:53:10] [query] Mods: 3 [2023-04-12 17:53:10] [query] Found results using: or logic [2023-04-12 17:53:10] [query] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source = 'post.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 (3834) 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 [2023-04-12 17:53:10] [query] Results: 173 Pages of results: 1 [2023-04-12 17:53:10] [query] Execution time: 0.40399 [2023-04-12 17:54:08] [indexer:background] Health check [2023-04-12 17:57:06] [index:background] Health check [2023-04-12 17:58:57] [indexer:background] Health check [2023-04-12 18:02:42] [index:background] Health check [2023-04-12 18:03:57] [indexer:background] Health check [2023-04-12 18:06:57] [index:background] Health check [2023-04-12 18:09:42] [indexer:background] Health check [2023-04-12 18:12:01] [index:background] Health check [2023-04-12 18:13:57] [indexer:background] Health check [2023-04-12 18:16:57] [index:background] Health check [2023-04-12 18:19:04] [indexer:background] Health check [2023-04-12 18:22:24] [index:background] Health check [2023-04-12 18:24:24] [indexer:background] Health check [2023-04-12 18:27:19] [index:background] Health check [2023-04-12 18:29:19] [indexer:background] Health check [2023-04-12 18:32:24] [index:background] Health check [2023-04-12 18:34:02] [indexer:background] Health check [2023-04-12 18:37:17] [index:background] Health check [2023-04-12 18:39:24] [indexer:background] Health check [2023-04-12 18:41:59] [index:background] Health check [2023-04-12 18:44:24] [indexer:background] Health check [2023-04-12 18:47:24] [index:background] Health check [2023-04-12 18:48:57] [indexer:background] Health check [2023-04-12 18:52:05] [index:background] Health check [2023-04-12 18:54:15] [indexer:background] Health check [2023-04-12 18:57:00] [index:background] Health check [2023-04-12 19:00:24] [indexer:background] Health check [2023-04-12 19:02:24] [index:background] Health check [2023-04-12 19:04:24] [indexer:background] Health check [2023-04-12 19:07:24] [index:background] Health check [2023-04-12 19:09:05] [indexer:background] Health check [2023-04-12 19:12:19] [index:background] Health check [2023-04-12 19:14:24] [indexer:background] Health check [2023-04-12 19:18:24] [index:background] Health check [2023-04-12 19:19:24] [indexer:background] Health check [2023-04-12 19:22:24] [index:background] Health check [2023-04-12 19:23:56] [indexer:background] Health check [2023-04-12 19:27:08] [index:background] Health check [2023-04-12 19:29:18] [indexer:background] Health check [2023-04-12 19:32:24] [index:background] Health check [2023-04-12 19:33:57] [indexer:background] Health check [2023-04-12 19:37:24] [index:background] Health check [2023-04-12 19:39:03] [indexer:background] Health check [2023-04-12 19:42:24] [index:background] Health check [2023-04-12 19:43:59] [indexer:background] Health check [2023-04-12 19:47:11] [index:background] Health check [2023-04-12 19:49:06] [indexer:background] Health check [2023-04-12 19:52:25] [index:background] Health check [2023-04-12 19:55:37] [indexer:background] Health check [2023-04-12 19:57:24] [index:background] Health check [2023-04-12 19:59:24] [indexer:background] Health check [2023-04-12 20:02:01] [index:background] Health check [2023-04-12 20:04:08] [indexer:background] Health check [2023-04-12 20:07:19] [index:background] Health check [2023-04-12 20:09:24] [indexer:background] Health check [2023-04-12 20:12:24] [index:background] Health check [2023-04-12 20:14:24] [indexer:background] Health check [2023-04-12 20:17:24] [index:background] Health check [2023-04-12 20:18:57] [indexer:background] Health check [2023-04-12 20:22:11] [index:background] Health check [2023-04-12 20:24:20] [indexer:background] Health check [2023-04-12 20:27:24] [index:background] Health check [2023-04-12 20:29:34] [indexer:background] Health check [2023-04-12 20:32:24] [index:background] Health check [2023-04-12 20:34:24] [indexer:background] Health check [2023-04-12 20:37:02] [index:background] Health check [2023-04-12 20:39:00] [indexer:background] Health check [2023-04-12 20:41:57] [index:background] Health check [2023-04-12 20:44:24] [indexer:background] Health check [2023-04-12 20:47:24] [index:background] Health check [2023-04-12 20:49:23] [indexer:background] Health check [2023-04-12 20:52:24] [index:background] Health check [2023-04-12 20:53:55] [indexer:background] Health check [2023-04-12 20:57:10] [index:background] Health check [2023-04-12 20:59:16] [indexer:background] Health check [2023-04-12 21:02:25] [index:background] Health check [2023-04-12 21:04:24] [indexer:background] Health check [2023-04-12 21:07:35] [index:background] Health check [2023-04-12 21:09:24] [indexer:background] Health check [2023-04-12 21:12:24] [index:background] Health check [2023-04-12 21:13:57] [indexer:background] Health check [2023-04-12 21:16:57] [index:background] Health check [2023-04-12 21:19:17] [indexer:background] Health check [2023-04-12 21:23:25] [index:background] Health check [2023-04-12 21:24:24] [indexer:background] Health check [2023-04-12 21:27:24] [index:background] Health check [2023-04-12 21:29:24] [indexer:background] Health check [2023-04-12 21:32:01] [index:background] Health check [2023-04-12 21:35:16] [indexer:background] Health check [2023-04-12 21:37:24] [index:background] Health check [2023-04-12 21:39:24] [indexer:background] Health check [2023-04-12 21:42:24] [index:background] Health check [2023-04-12 21:44:24] [indexer:background] Health check [2023-04-12 21:47:24] [index:background] Health check [2023-04-12 21:48:57] [indexer:background] Health check [2023-04-12 21:52:11] [index:background] Health check [2023-04-12 21:54:21] [indexer:background] Health check [2023-04-12 21:57:24] [index:background] Health check [2023-04-12 21:59:24] [indexer:background] Health check [2023-04-12 22:02:24] [index:background] Health check [2023-04-12 22:04:24] [indexer:background] Health check [2023-04-12 22:07:05] [index:background] Health check [2023-04-12 22:09:14] [indexer:background] Health check [2023-04-12 22:12:18] [index:background] Health check [2023-04-12 22:14:24] [indexer:background] Health check [2023-04-12 22:17:24] [index:background] Health check [2023-04-12 22:19:24] [indexer:background] Health check [2023-04-12 22:22:24] [index:background] Health check [2023-04-12 22:23:57] [indexer:background] Health check [2023-04-12 22:27:08] [index:background] Health check [2023-04-12 22:29:16] [indexer:background] Health check [2023-04-12 22:32:24] [index:background] Health check [2023-04-12 22:34:24] [indexer:background] Health check [2023-04-12 22:37:39] [index:background] Health check [2023-04-12 22:39:47] [indexer:background] Health check [2023-04-12 22:41:56] [index:background] Health check [2023-04-12 22:44:05] [indexer:background] Health check [2023-04-12 22:47:18] [index:background] Health check [2023-04-12 22:48:59] [indexer:background] Health check [2023-04-12 22:54:11] [index:background] Health check [2023-04-12 22:54:11] [indexer:background] Health check [2023-04-12 22:54:11] [indexer:background] Health check [2023-04-12 22:59:28] [index:background] Health check [2023-04-12 22:59:28] [indexer:background] Health check [2023-04-12 22:59:28] [indexer:background] Health check [2023-04-12 23:05:11] [index:background] Health check [2023-04-12 23:05:11] [indexer:background] Health check [2023-04-12 23:05:11] [indexer:background] Health check [2023-04-12 23:07:10] [index:background] Health check [2023-04-12 23:10:42] [indexer:background] Health check [2023-04-12 23:12:32] [index:background] Health check [2023-04-12 23:15:18] [indexer:background] Health check [2023-04-12 23:17:02] [index:background] Health check [2023-04-12 23:19:20] [indexer:background] Health check [2023-04-12 23:22:06] [index:background] Health check [2023-04-12 23:24:00] [indexer:background] Health check [2023-04-12 23:27:40] [index:background] Health check [2023-04-12 23:29:59] [indexer:background] Health check [2023-04-12 23:34:51] [index:background] Health check [2023-04-12 23:34:51] [indexer:background] Health check [2023-04-12 23:34:51] [indexer:background] Health check [2023-04-12 23:39:55] [index:background] Health check [2023-04-12 23:39:55] [indexer:background] Health check [2023-04-12 23:39:55] [indexer:background] Health check [2023-04-12 23:46:10] [index:background] Health check [2023-04-12 23:46:10] [indexer:background] Health check [2023-04-12 23:46:10] [indexer:background] Health check [2023-04-12 23:47:41] [index:background] Health check [2023-04-12 23:49:29] [indexer:background] Health check [2023-04-12 23:51:57] [index:background] Health check [2023-04-12 23:58:21] [indexer:background] Health check [2023-04-12 23:58:21] [index:background] Health check