[2022-03-05 00:01:57] [indexer:background:27] Health check [2022-03-05 00:01:57] [index:background:27] Health check [2022-03-05 00:08:04] [indexer:background:27] Health check [2022-03-05 00:08:04] [index:background:27] Health check [2022-03-05 00:15:10] [indexer:background:27] Health check [2022-03-05 00:15:10] [index:background:27] Health check [2022-03-05 00:19:21] [index:background:27] Health check [2022-03-05 00:19:21] [indexer:background:27] Health check [2022-03-05 00:19:21] [indexer:background:27] Health check [2022-03-05 00:29:55] [index:background:27] Health check [2022-03-05 00:29:55] [indexer:background:27] Health check [2022-03-05 00:29:55] [indexer:background:27] Health check [2022-03-05 00:39:35] [index:background:27] Health check [2022-03-05 00:39:35] [indexer:background:27] Health check [2022-03-05 00:39:35] [indexer:background:27] Health check [2022-03-05 00:49:17] [index:background:27] Health check [2022-03-05 00:49:17] [indexer:background:27] Health check [2022-03-05 00:49:17] [indexer:background:27] Health check [2022-03-05 00:54:58] [index:background:27] Health check [2022-03-05 00:54:58] [indexer:background:27] Health check [2022-03-05 00:54:58] [indexer:background:27] Health check [2022-03-05 00:57:16] [index:background:27] Health check [2022-03-05 01:17:55] [indexer:background:27] Health check [2022-03-05 01:17:55] [index:background:27] Health check [2022-03-05 01:22:31] [indexer:background:27] Health check [2022-03-05 01:22:31] [index:background:27] Health check [2022-03-05 01:28:48] [indexer:background:27] Health check [2022-03-05 01:28:48] [index:background:27] Health check [2022-03-05 01:34:44] [index:background:27] Health check [2022-03-05 01:34:44] [indexer:background:27] Health check [2022-03-05 01:34:44] [indexer:background:27] Health check [2022-03-05 01:45:03] [index:background:27] Health check [2022-03-05 01:45:03] [indexer:background:27] Health check [2022-03-05 01:45:03] [indexer:background:27] Health check [2022-03-05 01:47:41] [index:background:27] Health check [2022-03-05 02:00:38] [indexer:background:27] Health check [2022-03-05 02:00:38] [index:background:27] Health check [2022-03-05 02:06:11] [index:background:27] Health check [2022-03-05 02:06:11] [indexer:background:27] Health check [2022-03-05 02:06:11] [indexer:background:27] Health check [2022-03-05 02:33:06] [indexer:background:27] Health check [2022-03-05 02:33:06] [index:background:27] Health check [2022-03-05 02:35:27] [indexer:background:27] Health check [2022-03-05 02:39:50] [index:background:27] Health check [2022-03-05 02:39:50] [indexer:background:27] Health check [2022-03-05 02:39:50] [indexer:background:27] Health check [2022-03-05 02:42:00] [index:background:27] Health check [2022-03-05 02:47:28] [indexer:background:27] Health check [2022-03-05 02:47:29] [index:background:27] Health check [2022-03-05 02:56:52] [indexer:background:27] Health check [2022-03-05 02:56:52] [index:background:27] Health check [2022-03-05 03:00:29] [indexer:background:27] Health check [2022-03-05 03:01:34] [index:background:27] Health check [2022-03-05 03:05:14] [indexer:background:27] Health check [2022-03-05 03:06:22] [index:background:27] Health check [2022-03-05 03:11:28] [indexer:background:27] Health check [2022-03-05 03:11:28] [index:background:27] Health check [2022-03-05 03:14:29] [indexer:background:27] Health check [2022-03-05 03:16:51] [index:background:27] Health check [2022-03-05 03:21:51] [indexer:background:27] Health check [2022-03-05 03:21:51] [index:background:27] Health check [2022-03-05 03:35:41] [indexer:background:27] Health check [2022-03-05 03:35:41] [index:background:27] Health check [2022-03-05 03:43:48] [index:background:27] Health check [2022-03-05 03:43:48] [indexer:background:27] Health check [2022-03-05 03:43:48] [indexer:background:27] Health check [2022-03-05 04:02:09] [index:background:27] Health check [2022-03-05 04:02:09] [indexer:background:27] Health check [2022-03-05 04:02:09] [indexer:background:27] Health check [2022-03-05 04:05:15] [indexer:background:27] Health check [2022-03-05 04:06:05] [index:background:27] Health check [2022-03-05 04:15:09] [indexer:background:27] Health check [2022-03-05 04:15:09] [index:background:27] Health check [2022-03-05 04:34:46] [index:background:27] Health check [2022-03-05 04:34:46] [indexer:background:27] Health check [2022-03-05 04:34:46] [indexer:background:27] Health check [2022-03-05 04:38:45] [index:background:27] Health check [2022-03-05 04:38:45] [indexer:background:27] Health check [2022-03-05 04:38:45] [indexer:background:27] Health check [2022-03-05 04:48:08] [index:background:27] Health check [2022-03-05 04:48:08] [indexer:background:27] Health check [2022-03-05 04:48:08] [indexer:background:27] Health check [2022-03-05 04:59:00] [indexer:background:27] Health check [2022-03-05 04:59:00] [index:background:27] Health check [2022-03-05 05:06:27] [index:background:27] Health check [2022-03-05 05:06:27] [indexer:background:27] Health check [2022-03-05 05:06:27] [indexer:background:27] Health check [2022-03-05 05:10:44] [indexer:background:27] Health check [2022-03-05 05:24:53] [index:background:27] Health check [2022-03-05 05:24:53] [indexer:background:27] Health check [2022-03-05 05:24:53] [indexer:background:27] Health check [2022-03-05 05:32:02] [index:background:27] Health check [2022-03-05 05:32:02] [indexer:background:27] Health check [2022-03-05 05:32:02] [indexer:background:27] Health check [2022-03-05 05:34:05] [indexer:background:27] Health check [2022-03-05 05:43:20] [index:background:27] Health check [2022-03-05 05:43:20] [indexer:background:27] Health check [2022-03-05 05:43:20] [indexer:background:27] Health check [2022-03-05 05:52:59] [indexer:background:27] Health check [2022-03-05 05:52:59] [index:background:27] Health check [2022-03-05 05:54:53] [indexer:background:27] Health check [2022-03-05 05:57:54] [index:background:27] Health check [2022-03-05 06:09:51] [indexer:background:27] Health check [2022-03-05 06:09:51] [index:background:27] Health check [2022-03-05 06:11:30] [index:background:27] Health check [2022-03-05 06:45:20] [indexer:background:27] Health check [2022-03-05 06:45:21] [index:background:27] Health check [2022-03-05 06:49:17] [index:background:27] Health check [2022-03-05 06:49:17] [indexer:background:27] Health check [2022-03-05 06:49:17] [indexer:background:27] Health check [2022-03-05 06:54:56] [index:background:27] Health check [2022-03-05 06:54:56] [indexer:background:27] Health check [2022-03-05 06:54:56] [indexer:background:27] Health check [2022-03-05 07:05:15] [index:background:27] Health check [2022-03-05 07:05:15] [indexer:background:27] Health check [2022-03-05 07:05:15] [indexer:background:27] Health check [2022-03-05 07:10:44] [index:background:27] Health check [2022-03-05 07:10:44] [indexer:background:27] Health check [2022-03-05 07:10:44] [indexer:background:27] Health check [2022-03-05 07:18:31] [index:background:27] Health check [2022-03-05 07:18:31] [indexer:background:27] Health check [2022-03-05 07:18:31] [indexer:background:27] Health check [2022-03-05 07:24:31] [index:background:27] Health check [2022-03-05 07:24:31] [indexer:background:27] Health check [2022-03-05 07:24:31] [indexer:background:27] Health check [2022-03-05 07:26:27] [index:background:27] Health check [2022-03-05 07:41:23] [indexer:background:27] Health check [2022-03-05 07:41:23] [index:background:27] Health check [2022-03-05 07:47:02] [indexer:background:27] Health check [2022-03-05 07:47:02] [index:background:27] Health check [2022-03-05 07:56:14] [indexer:background:27] Health check [2022-03-05 07:56:14] [index:background:27] Health check [2022-03-05 08:03:25] [indexer:background:27] Health check [2022-03-05 08:03:25] [index:background:27] Health check [2022-03-05 08:03:45] [indexer:background:27] Health check [2022-03-05 08:08:04] [index:background:27] Health check [2022-03-05 08:14:48] [indexer:background:27] Health check [2022-03-05 08:14:48] [index:background:27] Health check [2022-03-05 08:26:31] [index:background:27] Health check [2022-03-05 08:26:31] [indexer:background:27] Health check [2022-03-05 08:26:31] [indexer:background:27] Health check [2022-03-05 08:32:44] [indexer:background:27] Health check [2022-03-05 08:32:44] [indexer:background:27] Health check [2022-03-05 08:32:44] [indexer:background:27] Process is LOCKED, health check in 47 seconds [2022-03-05 08:32:45] [index:background:27] Health check [2022-03-05 08:32:45] [indexer:background:27] Process is LOCKED, health check in 46 seconds [2022-03-05 08:32:45] [index:background:27] Health check [2022-03-05 08:36:00] [indexer:background:27] Health check [2022-03-05 08:39:09] [index:background:27] Health check [2022-03-05 08:39:09] [indexer:background:27] Health check [2022-03-05 08:39:09] [indexer:background:27] Health check [2022-03-05 08:42:09] [index:background:27] Health check [2022-03-05 08:48:32] [indexer:background:27] Health check [2022-03-05 08:48:32] [index:background:27] Health check [2022-03-05 08:53:06] [index:background:27] Health check [2022-03-05 09:05:32] [indexer:background:27] Health check [2022-03-05 09:05:32] [index:background:27] Health check [2022-03-05 09:06:24] [index:background:27] Health check [2022-03-05 09:06:24] [index:background:27] Health check [2022-03-05 09:06:24] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 09:08:31] [indexer:background:27] Health check [2022-03-05 09:14:45] [index:background:27] Health check [2022-03-05 09:14:45] [indexer:background:27] Health check [2022-03-05 09:14:45] [indexer:background:27] Health check [2022-03-05 09:18:45] [index:background:27] Health check [2022-03-05 09:18:45] [indexer:background:27] Health check [2022-03-05 09:18:45] [indexer:background:27] Health check [2022-03-05 09:21:05] [index:background:27] Health check [2022-03-05 09:23:31] [indexer:background:27] Health check [2022-03-05 09:26:04] [index:background:27] Health check [2022-03-05 09:28:31] [indexer:background:27] Health check [2022-03-05 09:31:04] [index:background:27] Health check [2022-03-05 09:33:31] [indexer:background:27] Health check [2022-03-05 09:36:04] [index:background:27] Health check [2022-03-05 09:38:31] [indexer:background:27] Health check [2022-03-05 09:41:04] [index:background:27] Health check [2022-03-05 09:43:32] [indexer:background:27] Health check [2022-03-05 09:46:04] [index:background:27] Health check [2022-03-05 09:48:31] [indexer:background:27] Health check [2022-03-05 09:51:04] [index:background:27] Health check [2022-03-05 09:53:31] [indexer:background:27] Health check [2022-03-05 09:56:04] [index:background:27] Health check [2022-03-05 09:58:31] [indexer:background:27] Health check [2022-03-05 10:01:05] [index:background:27] Health check [2022-03-05 10:03:31] [indexer:background:27] Health check [2022-03-05 10:06:04] [index:background:27] Health check [2022-03-05 10:08:31] [indexer:background:27] Health check [2022-03-05 10:11:04] [index:background:27] Health check [2022-03-05 10:14:02] [indexer:background:27] Health check [2022-03-05 10:16:44] [index:background:27] Health check [2022-03-05 10:20:34] [indexer:background:27] Health check [2022-03-05 10:21:35] [index:background:27] Health check [2022-03-05 10:31:26] [indexer:background:27] Health check [2022-03-05 10:31:26] [index:background:27] Health check [2022-03-05 10:33:42] [indexer:background:27] Health check [2022-03-05 10:40:31] [index:background:27] Health check [2022-03-05 10:40:31] [indexer:background:27] Health check [2022-03-05 10:40:31] [indexer:background:27] Health check [2022-03-05 10:42:01] [index:background:27] Health check [2022-03-05 10:44:26] [indexer:background:27] Health check [2022-03-05 10:48:15] [index:background:27] Health check [2022-03-05 10:50:44] [indexer:background:27] Health check [2022-03-05 10:52:09] [index:background:27] Health check [2022-03-05 10:54:15] [indexer:background:27] Health check [2022-03-05 10:59:22] [index:background:27] Health check [2022-03-05 10:59:22] [indexer:background:27] Health check [2022-03-05 10:59:22] [indexer:background:27] Health check [2022-03-05 10:59:36] [query:27] Query for: broken bone [2022-03-05 10:59:36] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-03-05 10:59:36] [query:27] Engine: default [2022-03-05 10:59:36] [query:27] Tokens: broken, bone [2022-03-05 10:59:36] [query:27] Mods: 2 [2022-03-05 10:59:36] [query:27] Trying AND logic [2022-03-05 10:59:36] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-03-05 10:59:36] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-03-05 10:59:36] [query:27] Found results using: and logic [2022-03-05 10:59:36] [query:27] 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 IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (1485,22001) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) 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' ) ))) AND s.id IN ('2981', '5332') GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_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, 5 [2022-03-05 10:59:36] [query:27] Results: 2 Pages of results: 1 [2022-03-05 10:59:37] [query:27] Execution time: 0.10921 [2022-03-05 11:01:22] [index:background:27] Health check [2022-03-05 11:03:17] [query:27] Query for: broken bone [2022-03-05 11:03:17] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-03-05 11:03:17] [query:27] Engine: default [2022-03-05 11:03:17] [query:27] Tokens: broken, bone [2022-03-05 11:03:17] [query:27] Mods: 2 [2022-03-05 11:03:17] [query:27] Trying AND logic [2022-03-05 11:03:17] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-03-05 11:03:17] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-03-05 11:03:17] [query:27] Found results using: and logic [2022-03-05 11:03:17] [query:27] 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 IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (1485,22001) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) 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' ) ))) AND s.id IN ('2981', '5332') GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_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, 5 [2022-03-05 11:03:17] [query:27] Results: 2 Pages of results: 1 [2022-03-05 11:03:17] [query:27] Execution time: 0.07801 [2022-03-05 11:05:10] [indexer:background:27] Health check [2022-03-05 11:06:28] [index:background:27] Health check [2022-03-05 11:08:50] [indexer:background:27] Health check [2022-03-05 11:12:21] [index:background:27] Health check [2022-03-05 11:16:50] [indexer:background:27] Health check [2022-03-05 11:16:50] [index:background:27] Health check [2022-03-05 11:21:40] [indexer:background:27] Health check [2022-03-05 11:21:40] [index:background:27] Health check [2022-03-05 11:25:55] [indexer:background:27] Health check [2022-03-05 11:26:43] [index:background:27] Health check [2022-03-05 11:26:43] [index:background:27] Health check [2022-03-05 11:26:43] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 11:29:03] [indexer:background:27] Health check [2022-03-05 11:33:11] [index:background:27] Health check [2022-03-05 11:39:28] [indexer:background:27] Health check [2022-03-05 11:39:28] [index:background:27] Health check [2022-03-05 11:44:01] [index:background:27] Health check [2022-03-05 11:44:01] [indexer:background:27] Health check [2022-03-05 11:44:01] [indexer:background:27] Health check [2022-03-05 11:53:48] [index:background:27] Health check [2022-03-05 11:53:48] [indexer:background:27] Health check [2022-03-05 11:53:48] [indexer:background:27] Health check [2022-03-05 11:56:56] [index:background:27] Health check [2022-03-05 12:01:04] [indexer:background:27] Health check [2022-03-05 12:01:04] [index:background:27] Health check [2022-03-05 12:06:30] [indexer:background:27] Health check [2022-03-05 12:06:30] [index:background:27] Health check [2022-03-05 12:13:48] [indexer:background:27] Health check [2022-03-05 12:13:48] [index:background:27] Health check [2022-03-05 12:16:58] [index:background:27] Health check [2022-03-05 12:18:38] [indexer:background:27] Health check [2022-03-05 12:22:08] [index:background:27] Health check [2022-03-05 12:26:33] [indexer:background:27] Health check [2022-03-05 12:26:33] [index:background:27] Health check [2022-03-05 12:36:00] [indexer:background:27] Health check [2022-03-05 12:36:00] [index:background:27] Health check [2022-03-05 12:40:34] [index:background:27] Health check [2022-03-05 12:40:34] [indexer:background:27] Health check [2022-03-05 12:40:34] [indexer:background:27] Health check [2022-03-05 12:47:39] [index:background:27] Health check [2022-03-05 12:47:39] [indexer:background:27] Health check [2022-03-05 12:47:39] [indexer:background:27] Health check [2022-03-05 12:50:07] [indexer:background:27] Health check [2022-03-05 12:51:20] [index:background:27] Health check [2022-03-05 12:54:59] [indexer:background:27] Health check [2022-03-05 13:01:11] [index:background:27] Health check [2022-03-05 13:01:11] [index:background:27] Health check [2022-03-05 13:01:11] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 13:01:11] [indexer:background:27] Health check [2022-03-05 13:01:11] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 13:01:11] [indexer:background:27] Health check [2022-03-05 13:01:11] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 13:05:53] [indexer:background:27] Health check [2022-03-05 13:05:53] [indexer:background:27] Health check [2022-03-05 13:05:53] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 13:07:54] [index:background:27] Health check [2022-03-05 13:10:39] [indexer:background:27] Health check [2022-03-05 13:15:36] [index:background:27] Health check [2022-03-05 13:15:36] [indexer:background:27] Health check [2022-03-05 13:15:36] [indexer:background:27] Health check [2022-03-05 13:16:08] [index:background:27] Health check [2022-03-05 13:17:34] [query:27] Query for: md4002 handbook [2022-03-05 13:17:34] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-03-05 13:17:34] [query:27] Engine: default [2022-03-05 13:17:35] [query:27] Tokens: handbooks, md4002, handbook [2022-03-05 13:17:35] [query:27] Mods: 2 [2022-03-05 13:17:35] [query:27] Trying AND logic [2022-03-05 13:17:35] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-03-05 13:17:35] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-03-05 13:17:35] [query:27] Found results using: and logic [2022-03-05 13:17:35] [query:27] 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 IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (3943,2268,1249) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) 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' ) ))) AND s.id IN ('2318', '2684', '2948', '2950', '3310', '4043', '4435', '7227', '7539', '7551', '7552', '7553', '7554', '8416', '8423', '9198', '9502', '9859', '9969') GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_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, 5 [2022-03-05 13:17:35] [query:27] Results: 19 Pages of results: 4 [2022-03-05 13:17:35] [query:27] Execution time: 0.12481 [2022-03-05 13:18:55] [indexer:background:27] Health check [2022-03-05 13:21:10] [index:background:27] Health check [2022-03-05 13:26:19] [indexer:background:27] Health check [2022-03-05 13:26:19] [index:background:27] Health check [2022-03-05 13:31:04] [indexer:background:27] Health check [2022-03-05 13:31:04] [index:background:27] Health check [2022-03-05 13:34:36] [indexer:background:27] Health check [2022-03-05 13:36:47] [index:background:27] Health check [2022-03-05 13:38:54] [indexer:background:27] Health check [2022-03-05 13:41:44] [index:background:27] Health check [2022-03-05 13:46:06] [indexer:background:27] Health check [2022-03-05 13:46:06] [index:background:27] Health check [2022-03-05 13:51:15] [indexer:background:27] Health check [2022-03-05 13:51:15] [index:background:27] Health check [2022-03-05 13:54:34] [indexer:background:27] Health check [2022-03-05 13:57:59] [index:background:27] Health check [2022-03-05 13:57:59] [index:background:27] Health check [2022-03-05 13:57:59] [indexer:background:27] Process is LOCKED, health check in 32 seconds [2022-03-05 14:01:26] [indexer:background:27] Health check [2022-03-05 14:01:26] [index:background:27] Health check [2022-03-05 14:08:12] [indexer:background:27] Health check [2022-03-05 14:08:12] [index:background:27] Health check [2022-03-05 14:10:39] [indexer:background:27] Health check [2022-03-05 14:13:06] [index:background:27] Health check [2022-03-05 14:13:06] [index:background:27] Health check [2022-03-05 14:13:06] [indexer:background:27] Process is LOCKED, health check in 25 seconds [2022-03-05 14:13:32] [indexer:background:27] Health check [2022-03-05 14:16:06] [index:background:27] Health check [2022-03-05 14:22:08] [indexer:background:27] Health check [2022-03-05 14:22:08] [index:background:27] Health check [2022-03-05 14:24:34] [indexer:background:27] Health check [2022-03-05 14:28:13] [index:background:27] Health check [2022-03-05 14:28:13] [index:background:27] Health check [2022-03-05 14:28:13] [indexer:background:27] Process is LOCKED, health check in 18 seconds [2022-03-05 14:33:20] [indexer:background:27] Health check [2022-03-05 14:33:20] [index:background:27] Health check [2022-03-05 14:38:49] [indexer:background:27] Health check [2022-03-05 14:38:49] [indexer:background:27] Health check [2022-03-05 14:38:49] [indexer:background:27] Process is LOCKED, health check in 5 mins [2022-03-05 14:38:49] [index:background:27] Health check [2022-03-05 14:38:49] [index:background:27] Health check [2022-03-05 14:38:49] [index:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 14:38:49] [indexer:background:27] Process is LOCKED, health check in 5 mins [2022-03-05 14:42:15] [index:background:27] Health check [2022-03-05 14:44:03] [indexer:background:27] Health check [2022-03-05 14:47:13] [index:background:27] Health check [2022-03-05 14:49:06] [indexer:background:27] Health check [2022-03-05 14:49:06] [indexer:background:27] Health check [2022-03-05 14:49:06] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 14:52:35] [index:background:27] Health check [2022-03-05 14:54:06] [indexer:background:27] Health check [2022-03-05 14:59:31] [index:background:27] Health check [2022-03-05 14:59:31] [index:background:27] Health check [2022-03-05 14:59:31] [index:background:27] Process is LOCKED [2022-03-05 14:59:31] [indexer:background:27] Health check [2022-03-05 14:59:31] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 15:00:39] [index:background:27] Health check [2022-03-05 15:05:15] [indexer:background:27] Health check [2022-03-05 15:05:55] [index:background:27] Health check [2022-03-05 15:10:22] [indexer:background:27] Health check [2022-03-05 15:10:22] [indexer:background:27] Health check [2022-03-05 15:10:22] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 15:15:34] [index:background:27] Health check [2022-03-05 15:15:34] [index:background:27] Health check [2022-03-05 15:15:34] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 15:15:34] [indexer:background:27] Health check [2022-03-05 15:15:34] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 15:15:34] [indexer:background:27] Health check [2022-03-05 15:15:34] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 15:15:54] [index:background:27] Health check [2022-03-05 15:20:35] [indexer:background:27] Health check [2022-03-05 15:22:39] [index:background:27] Health check [2022-03-05 15:26:26] [indexer:background:27] Health check [2022-03-05 15:26:26] [indexer:background:27] Health check [2022-03-05 15:26:26] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 15:26:26] [index:background:27] Health check [2022-03-05 15:26:26] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 15:26:26] [index:background:27] Health check [2022-03-05 15:30:49] [indexer:background:27] Health check [2022-03-05 15:30:49] [index:background:27] Health check [2022-03-05 15:33:39] [indexer:background:27] Health check [2022-03-05 15:36:18] [index:background:27] Health check [2022-03-05 15:36:18] [index:background:27] Health check [2022-03-05 15:36:18] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 15:41:31] [indexer:background:27] Health check [2022-03-05 15:41:31] [indexer:background:27] Health check [2022-03-05 15:41:31] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 15:41:31] [index:background:27] Health check [2022-03-05 15:41:31] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 15:41:31] [index:background:27] Health check [2022-03-05 15:46:12] [indexer:background:27] Health check [2022-03-05 15:46:12] [index:background:27] Health check [2022-03-05 15:50:03] [indexer:background:27] Health check [2022-03-05 15:51:57] [index:background:27] Health check [2022-03-05 15:57:07] [indexer:background:27] Health check [2022-03-05 15:57:07] [indexer:background:27] Health check [2022-03-05 15:57:07] [indexer:background:27] Process is LOCKED, health check in 1 min [2022-03-05 15:57:07] [index:background:27] Health check [2022-03-05 15:57:07] [indexer:background:27] Process is LOCKED, health check in 1 min [2022-03-05 15:57:07] [index:background:27] Health check [2022-03-05 16:02:06] [indexer:background:27] Health check [2022-03-05 16:02:06] [index:background:27] Health check [2022-03-05 16:05:48] [indexer:background:27] Health check [2022-03-05 16:05:48] [index:background:27] Health check [2022-03-05 16:12:27] [indexer:background:27] Health check [2022-03-05 16:12:27] [index:background:27] Health check [2022-03-05 16:19:23] [indexer:background:27] Health check [2022-03-05 16:19:23] [index:background:27] Health check [2022-03-05 16:20:57] [index:background:27] Health check [2022-03-05 16:20:57] [index:background:27] Health check [2022-03-05 16:20:57] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 16:24:37] [indexer:background:27] Health check [2022-03-05 16:26:20] [index:background:27] Health check [2022-03-05 16:26:20] [index:background:27] Health check [2022-03-05 16:26:20] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 16:31:24] [indexer:background:27] Health check [2022-03-05 16:31:24] [indexer:background:27] Health check [2022-03-05 16:31:24] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 16:31:24] [index:background:27] Health check [2022-03-05 16:31:24] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 16:31:24] [index:background:27] Health check [2022-03-05 16:36:32] [indexer:background:27] Health check [2022-03-05 16:36:32] [indexer:background:27] Health check [2022-03-05 16:36:32] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 16:36:32] [index:background:27] Health check [2022-03-05 16:36:32] [index:background:27] Health check [2022-03-05 16:36:32] [index:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 16:39:40] [indexer:background:27] Health check [2022-03-05 16:39:40] [index:background:27] Health check [2022-03-05 16:43:33] [indexer:background:27] Health check [2022-03-05 16:46:40] [index:background:27] Health check [2022-03-05 16:51:51] [indexer:background:27] Health check [2022-03-05 16:51:51] [indexer:background:27] Health check [2022-03-05 16:51:51] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 16:51:51] [index:background:27] Health check [2022-03-05 16:51:51] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 16:51:51] [index:background:27] Health check [2022-03-05 16:55:28] [indexer:background:27] Health check [2022-03-05 16:55:28] [index:background:27] Health check [2022-03-05 17:01:24] [indexer:background:27] Health check [2022-03-05 17:01:24] [index:background:27] Health check [2022-03-05 17:05:53] [indexer:background:27] Health check [2022-03-05 17:05:53] [index:background:27] Health check [2022-03-05 17:12:22] [indexer:background:27] Health check [2022-03-05 17:12:22] [index:background:27] Health check [2022-03-05 17:14:26] [indexer:background:27] Health check [2022-03-05 17:17:38] [index:background:27] Health check [2022-03-05 17:17:38] [index:background:27] Health check [2022-03-05 17:17:38] [indexer:background:27] Process is LOCKED, health check in 53 seconds [2022-03-05 17:22:44] [indexer:background:27] Health check [2022-03-05 17:22:44] [indexer:background:27] Health check [2022-03-05 17:22:44] [indexer:background:27] Process is LOCKED, health check in 47 seconds [2022-03-05 17:22:44] [index:background:27] Health check [2022-03-05 17:22:44] [index:background:27] Health check [2022-03-05 17:22:44] [indexer:background:27] Process is LOCKED, health check in 47 seconds [2022-03-05 17:28:19] [indexer:background:27] Health check [2022-03-05 17:28:19] [index:background:27] Health check [2022-03-05 17:34:23] [indexer:background:27] Health check [2022-03-05 17:34:23] [indexer:background:27] Health check [2022-03-05 17:34:23] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 17:34:23] [index:background:27] Health check [2022-03-05 17:34:23] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 17:34:23] [index:background:27] Health check [2022-03-05 17:35:53] [index:background:27] Health check [2022-03-05 17:39:10] [indexer:background:27] Health check [2022-03-05 17:44:28] [index:background:27] Health check [2022-03-05 17:44:28] [indexer:background:27] Health check [2022-03-05 17:44:28] [indexer:background:27] Health check [2022-03-05 17:44:45] [index:background:27] Health check [2022-03-05 17:44:45] [index:background:27] Health check [2022-03-05 17:44:45] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 17:49:32] [indexer:background:27] Health check [2022-03-05 17:50:09] [index:background:27] Health check [2022-03-05 17:50:09] [index:background:27] Health check [2022-03-05 17:50:09] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 17:54:08] [indexer:background:27] Health check [2022-03-05 17:55:44] [index:background:27] Health check [2022-03-05 17:55:44] [index:background:27] Health check [2022-03-05 17:55:44] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 18:00:40] [indexer:background:27] Health check [2022-03-05 18:00:40] [indexer:background:27] Health check [2022-03-05 18:00:40] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 18:00:40] [index:background:27] Health check [2022-03-05 18:00:40] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 18:00:40] [index:background:27] Health check [2022-03-05 18:04:31] [indexer:background:27] Health check [2022-03-05 18:05:50] [index:background:27] Health check [2022-03-05 18:05:50] [index:background:27] Health check [2022-03-05 18:05:50] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 18:08:43] [indexer:background:27] Health check [2022-03-05 18:10:55] [index:background:27] Health check [2022-03-05 18:10:55] [index:background:27] Health check [2022-03-05 18:10:55] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 18:15:42] [indexer:background:27] Health check [2022-03-05 18:15:42] [index:background:27] Health check [2022-03-05 18:20:47] [indexer:background:27] Health check [2022-03-05 18:20:47] [index:background:27] Health check [2022-03-05 18:25:39] [indexer:background:27] Health check [2022-03-05 18:25:39] [index:background:27] Health check [2022-03-05 18:29:43] [indexer:background:27] Health check [2022-03-05 18:29:43] [index:background:27] Health check [2022-03-05 18:37:05] [indexer:background:27] Health check [2022-03-05 18:37:05] [index:background:27] Health check [2022-03-05 18:39:52] [indexer:background:27] Health check [2022-03-05 18:39:52] [index:background:27] Health check [2022-03-05 18:48:11] [indexer:background:27] Health check [2022-03-05 18:48:11] [indexer:background:27] Health check [2022-03-05 18:48:11] [index:background:27] Health check [2022-03-05 18:48:11] [indexer:background:27] Process is LOCKED, health check in 20 seconds [2022-03-05 18:53:51] [indexer:background:27] Health check [2022-03-05 18:53:51] [indexer:background:27] Health check [2022-03-05 18:53:51] [indexer:background:27] Process is LOCKED, health check in 5 mins [2022-03-05 18:53:51] [index:background:27] Health check [2022-03-05 18:53:51] [indexer:background:27] Process is LOCKED, health check in 5 mins [2022-03-05 18:53:51] [index:background:27] Health check [2022-03-05 18:55:50] [index:background:27] Health check [2022-03-05 18:59:01] [indexer:background:27] Health check [2022-03-05 18:59:01] [indexer:background:27] Health check [2022-03-05 18:59:01] [indexer:background:27] Process is LOCKED, health check in 5 mins [2022-03-05 19:01:02] [index:background:27] Health check [2022-03-05 19:04:18] [indexer:background:27] Health check [2022-03-05 19:04:18] [indexer:background:27] Health check [2022-03-05 19:04:18] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 19:09:29] [index:background:27] Health check [2022-03-05 19:09:29] [indexer:background:27] Health check [2022-03-05 19:09:29] [indexer:background:27] Health check [2022-03-05 19:10:57] [index:background:27] Health check [2022-03-05 19:16:24] [indexer:background:27] Health check [2022-03-05 19:16:24] [index:background:27] Health check [2022-03-05 19:22:01] [indexer:background:27] Health check [2022-03-05 19:22:01] [index:background:27] Health check [2022-03-05 19:25:27] [indexer:background:27] Health check [2022-03-05 19:25:28] [index:background:27] Health check [2022-03-05 19:32:52] [indexer:background:27] Health check [2022-03-05 19:32:52] [index:background:27] Health check [2022-03-05 19:34:55] [indexer:background:27] Health check [2022-03-05 19:34:55] [index:background:27] Health check [2022-03-05 19:39:36] [indexer:background:27] Health check [2022-03-05 19:41:29] [index:background:27] Health check [2022-03-05 19:43:43] [indexer:background:27] Health check [2022-03-05 19:49:03] [index:background:27] Health check [2022-03-05 19:49:04] [indexer:background:27] Health check [2022-03-05 19:49:04] [indexer:background:27] Health check [2022-03-05 19:51:32] [index:background:27] Health check [2022-03-05 19:54:18] [indexer:background:27] Health check [2022-03-05 19:54:18] [indexer:background:27] Health check [2022-03-05 19:54:18] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 19:54:55] [index:background:27] Health check [2022-03-05 19:59:13] [indexer:background:27] Health check [2022-03-05 19:59:56] [index:background:27] Health check [2022-03-05 19:59:56] [index:background:27] Health check [2022-03-05 19:59:56] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 20:05:15] [indexer:background:27] Health check [2022-03-05 20:05:15] [index:background:27] Health check [2022-03-05 20:08:48] [indexer:background:27] Health check [2022-03-05 20:10:02] [index:background:27] Health check [2022-03-05 20:15:20] [indexer:background:27] Health check [2022-03-05 20:15:20] [index:background:27] Health check [2022-03-05 20:18:59] [indexer:background:27] Health check [2022-03-05 20:21:14] [index:background:27] Health check [2022-03-05 20:21:14] [index:background:27] Health check [2022-03-05 20:21:14] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 20:26:32] [indexer:background:27] Health check [2022-03-05 20:26:32] [indexer:background:27] Health check [2022-03-05 20:26:32] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 20:26:32] [index:background:27] Health check [2022-03-05 20:26:32] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 20:26:32] [index:background:27] Health check [2022-03-05 20:28:57] [indexer:background:27] Health check [2022-03-05 20:31:36] [index:background:27] Health check [2022-03-05 20:36:53] [indexer:background:27] Health check [2022-03-05 20:36:53] [indexer:background:27] Health check [2022-03-05 20:36:53] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 20:36:53] [index:background:27] Health check [2022-03-05 20:36:53] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 20:36:53] [index:background:27] Health check [2022-03-05 20:41:14] [indexer:background:27] Health check [2022-03-05 20:41:14] [index:background:27] Health check [2022-03-05 20:47:41] [indexer:background:27] Health check [2022-03-05 20:47:41] [indexer:background:27] Health check [2022-03-05 20:47:41] [indexer:background:27] Process is LOCKED, health check in 50 seconds [2022-03-05 20:47:41] [index:background:27] Health check [2022-03-05 20:47:41] [indexer:background:27] Process is LOCKED, health check in 50 seconds [2022-03-05 20:47:41] [index:background:27] Health check [2022-03-05 20:52:59] [indexer:background:27] Health check [2022-03-05 20:52:59] [indexer:background:27] Health check [2022-03-05 20:52:59] [indexer:background:27] Process is LOCKED, health check in 32 seconds [2022-03-05 20:52:59] [index:background:27] Health check [2022-03-05 20:52:59] [index:background:27] Health check [2022-03-05 20:52:59] [indexer:background:27] Process is LOCKED, health check in 32 seconds [2022-03-05 20:53:52] [indexer:background:27] Health check [2022-03-05 20:58:17] [index:background:27] Health check [2022-03-05 20:58:17] [index:background:27] Health check [2022-03-05 20:58:17] [indexer:background:27] Process is LOCKED, health check in 14 seconds [2022-03-05 21:03:27] [indexer:background:27] Health check [2022-03-05 21:03:27] [index:background:27] Health check [2022-03-05 21:03:32] [indexer:background:27] Health check [2022-03-05 21:09:52] [index:background:27] Health check [2022-03-05 21:09:52] [index:background:27] Health check [2022-03-05 21:09:52] [indexer:background:27] Process is LOCKED, health check in 1 min [2022-03-05 21:09:52] [indexer:background:27] Health check [2022-03-05 21:09:52] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 21:09:52] [indexer:background:27] Health check [2022-03-05 21:09:52] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-03-05 21:14:04] [indexer:background:27] Health check [2022-03-05 21:15:12] [index:background:27] Health check [2022-03-05 21:15:12] [index:background:27] Health check [2022-03-05 21:15:12] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 21:20:30] [indexer:background:27] Health check [2022-03-05 21:20:30] [indexer:background:27] Health check [2022-03-05 21:20:30] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 21:20:30] [index:background:27] Health check [2022-03-05 21:20:30] [indexer:background:27] Process is LOCKED, health check in 3 mins [2022-03-05 21:20:30] [index:background:27] Health check [2022-03-05 21:23:36] [indexer:background:27] Health check [2022-03-05 21:25:49] [index:background:27] Health check [2022-03-05 21:28:34] [indexer:background:27] Health check [2022-03-05 21:30:27] [index:background:27] Health check [2022-03-05 21:36:35] [indexer:background:27] Health check [2022-03-05 21:36:35] [indexer:background:27] Health check [2022-03-05 21:36:35] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 21:36:35] [index:background:27] Health check [2022-03-05 21:36:35] [index:background:27] Health check [2022-03-05 21:36:35] [indexer:background:27] Process is LOCKED, health check in 2 mins [2022-03-05 21:44:05] [indexer:background:27] Health check [2022-03-05 21:44:05] [index:background:27] Health check [2022-03-05 21:44:43] [index:background:27] Health check [2022-03-05 21:44:43] [query:27] Query for: Application [2022-03-05 21:44:43] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-03-05 21:44:43] [query:27] Engine: default [2022-03-05 21:44:43] [query:27] Tokens: application, applicants, applicable, applications, applicant, applicant's, applicability, applicables, applic [2022-03-05 21:44:43] [query:27] Mods: 2 [2022-03-05 21:44:43] [query:27] Using OR logic [2022-03-05 21:44:43] [query:27] Found results using: and logic [2022-03-05 21:44:43] [query:27] 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 IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (417,456,620,849,3372,41487,44414,48111,36198) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) 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' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_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, 5 [2022-03-05 21:44:43] [query:27] Results: 157 Pages of results: 32 [2022-03-05 21:44:43] [query:27] Execution time: 0.06240 [2022-03-05 21:50:02] [indexer:background:27] Health check [2022-03-05 21:50:02] [index:background:27] Health check [2022-03-05 21:56:04] [indexer:background:27] Health check [2022-03-05 21:56:04] [index:background:27] Health check [2022-03-05 22:02:23] [indexer:background:27] Health check [2022-03-05 22:02:23] [index:background:27] Health check [2022-03-05 22:06:07] [indexer:background:27] Health check [2022-03-05 22:06:07] [index:background:27] Health check [2022-03-05 22:09:20] [indexer:background:27] Health check [2022-03-05 22:20:02] [index:background:27] Health check [2022-03-05 22:20:02] [indexer:background:27] Health check [2022-03-05 22:20:02] [indexer:background:27] Health check [2022-03-05 22:23:54] [indexer:background:27] Health check [2022-03-05 22:31:04] [index:background:27] Health check [2022-03-05 22:31:04] [indexer:background:27] Health check [2022-03-05 22:31:04] [indexer:background:27] Health check [2022-03-05 22:36:37] [indexer:background:27] Health check [2022-03-05 22:36:37] [index:background:27] Health check [2022-03-05 22:38:35] [indexer:background:27] Health check [2022-03-05 22:42:07] [index:background:27] Health check [2022-03-05 22:57:44] [indexer:background:27] Health check [2022-03-05 22:57:44] [index:background:27] Health check [2022-03-05 23:00:43] [indexer:background:27] Health check [2022-03-05 23:00:43] [index:background:27] Health check [2022-03-05 23:05:38] [indexer:background:27] Health check [2022-03-05 23:05:38] [index:background:27] Health check [2022-03-05 23:09:12] [indexer:background:27] Health check [2022-03-05 23:10:20] [index:background:27] Health check [2022-03-05 23:14:45] [indexer:background:27] Health check [2022-03-05 23:14:45] [index:background:27] Health check [2022-03-05 23:18:56] [indexer:background:27] Health check [2022-03-05 23:20:54] [index:background:27] Health check [2022-03-05 23:37:26] [indexer:background:27] Health check [2022-03-05 23:37:26] [index:background:27] Health check [2022-03-05 23:51:14] [indexer:background:27] Health check [2022-03-05 23:51:15] [index:background:27] Health check [2022-03-05 23:57:31] [indexer:background:27] Health check [2022-03-05 23:57:31] [index:background:27] Health check [2022-03-05 23:59:03] [indexer:background:27] Health check [2022-03-05 23:59:41] [index:background:27] Health check