[2022-04-29 00:02:14] [indexer:background:27] Health check [2022-04-29 00:02:14] [index:background:27] Health check [2022-04-29 00:04:07] [indexer:background:27] Health check [2022-04-29 00:15:04] [index:background:27] Health check [2022-04-29 00:15:04] [indexer:background:27] Health check [2022-04-29 00:15:04] [indexer:background:27] Health check [2022-04-29 00:17:26] [index:background:27] Health check [2022-04-29 00:18:31] [indexer:background:27] Health check [2022-04-29 00:28:09] [index:background:27] Health check [2022-04-29 00:28:09] [indexer:background:27] Health check [2022-04-29 00:28:09] [indexer:background:27] Health check [2022-04-29 00:30:27] [indexer:background:27] Health check [2022-04-29 00:53:52] [index:background:27] Health check [2022-04-29 00:53:52] [indexer:background:27] Health check [2022-04-29 00:53:52] [indexer:background:27] Health check [2022-04-29 00:56:57] [index:background:27] Health check [2022-04-29 01:07:52] [indexer:background:27] Health check [2022-04-29 01:07:52] [index:background:27] Health check [2022-04-29 01:12:19] [indexer:background:27] Health check [2022-04-29 01:12:19] [index:background:27] Health check [2022-04-29 01:15:06] [indexer:background:27] Health check [2022-04-29 01:20:29] [index:background:27] Health check [2022-04-29 01:20:29] [indexer:background:27] Health check [2022-04-29 01:20:29] [indexer:background:27] Health check [2022-04-29 01:25:33] [index:background:27] Health check [2022-04-29 01:25:34] [indexer:background:27] Health check [2022-04-29 01:25:34] [indexer:background:27] Health check [2022-04-29 01:43:48] [index:background:27] Health check [2022-04-29 01:43:48] [indexer:background:27] Health check [2022-04-29 01:43:48] [indexer:background:27] Health check [2022-04-29 01:47:51] [index:background:27] Health check [2022-04-29 01:51:39] [indexer:background:27] Health check [2022-04-29 01:51:52] [index:background:27] Health check [2022-04-29 01:56:07] [indexer:background:27] Health check [2022-04-29 02:02:12] [index:background:27] Health check [2022-04-29 02:02:12] [indexer:background:27] Health check [2022-04-29 02:02:12] [indexer:background:27] Health check [2022-04-29 02:05:58] [indexer:background:27] Health check [2022-04-29 02:08:16] [index:background:27] Health check [2022-04-29 02:13:50] [indexer:background:27] Health check [2022-04-29 02:13:50] [index:background:27] Health check [2022-04-29 02:17:04] [index:background:27] Health check [2022-04-29 02:21:08] [indexer:background:27] Health check [2022-04-29 02:23:29] [index:background:27] Health check [2022-04-29 02:23:29] [indexer:background:27] Health check [2022-04-29 02:23:29] [indexer:background:27] Health check [2022-04-29 02:29:40] [index:background:27] Health check [2022-04-29 02:29:40] [indexer:background:27] Health check [2022-04-29 02:29:40] [indexer:background:27] Health check [2022-04-29 02:40:45] [index:background:27] Health check [2022-04-29 02:40:45] [indexer:background:27] Health check [2022-04-29 02:40:45] [indexer:background:27] Health check [2022-04-29 02:44:10] [index:background:27] Health check [2022-04-29 02:44:10] [indexer:background:27] Health check [2022-04-29 02:44:10] [indexer:background:27] Health check [2022-04-29 03:03:13] [index:background:27] Health check [2022-04-29 03:03:13] [indexer:background:27] Health check [2022-04-29 03:03:13] [indexer:background:27] Health check [2022-04-29 03:05:03] [indexer:background:27] Health check [2022-04-29 03:14:20] [index:background:27] Health check [2022-04-29 03:14:20] [indexer:background:27] Health check [2022-04-29 03:14:21] [indexer:background:27] Health check [2022-04-29 03:22:42] [index:background:27] Health check [2022-04-29 03:22:42] [indexer:background:27] Health check [2022-04-29 03:22:42] [indexer:background:27] Health check [2022-04-29 03:24:11] [indexer:background:27] Health check [2022-04-29 03:35:45] [index:background:27] Health check [2022-04-29 03:35:45] [indexer:background:27] Health check [2022-04-29 03:35:45] [indexer:background:27] Health check [2022-04-29 03:39:10] [index:background:27] Health check [2022-04-29 03:39:10] [indexer:background:27] Health check [2022-04-29 03:39:10] [indexer:background:27] Health check [2022-04-29 03:42:19] [index:background:27] Health check [2022-04-29 03:49:47] [indexer:background:27] Health check [2022-04-29 03:49:47] [index:background:27] Health check [2022-04-29 03:57:35] [index:background:27] Health check [2022-04-29 03:57:35] [indexer:background:27] Health check [2022-04-29 03:57:35] [indexer:background:27] Health check [2022-04-29 04:01:26] [indexer:background:27] Health check [2022-04-29 04:02:00] [index:background:27] Health check [2022-04-29 04:04:28] [indexer:background:27] Health check [2022-04-29 04:17:45] [index:background:27] Health check [2022-04-29 04:17:45] [indexer:background:27] Health check [2022-04-29 04:17:45] [indexer:background:27] Health check [2022-04-29 04:20:22] [indexer:background:27] Health check [2022-04-29 04:25:05] [index:background:27] Health check [2022-04-29 04:25:05] [indexer:background:27] Health check [2022-04-29 04:25:05] [indexer:background:27] Health check [2022-04-29 04:27:30] [index:background:27] Health check [2022-04-29 04:31:03] [indexer:background:27] Health check [2022-04-29 04:33:22] [index:background:27] Health check [2022-04-29 04:33:22] [indexer:background:27] Health check [2022-04-29 04:33:22] [indexer:background:27] Health check [2022-04-29 04:38:37] [index:background:27] Health check [2022-04-29 04:38:38] [indexer:background:27] Health check [2022-04-29 04:38:38] [indexer:background:27] Health check [2022-04-29 04:43:39] [index:background:27] Health check [2022-04-29 04:43:40] [indexer:background:27] Health check [2022-04-29 04:43:40] [indexer:background:27] Health check [2022-04-29 04:49:14] [index:background:27] Health check [2022-04-29 04:49:14] [indexer:background:27] Health check [2022-04-29 04:49:14] [indexer:background:27] Health check [2022-04-29 04:53:51] [index:background:27] Health check [2022-04-29 04:53:51] [indexer:background:27] Health check [2022-04-29 04:53:51] [indexer:background:27] Health check [2022-04-29 05:00:05] [index:background:27] Health check [2022-04-29 05:00:05] [indexer:background:27] Health check [2022-04-29 05:00:05] [indexer:background:27] Health check [2022-04-29 05:05:41] [index:background:27] Health check [2022-04-29 05:05:41] [indexer:background:27] Health check [2022-04-29 05:05:41] [indexer:background:27] Health check [2022-04-29 05:10:56] [index:background:27] Health check [2022-04-29 05:10:56] [indexer:background:27] Health check [2022-04-29 05:10:56] [indexer:background:27] Health check [2022-04-29 05:11:48] [index:background:27] Health check [2022-04-29 05:17:20] [indexer:background:27] Health check [2022-04-29 05:17:20] [index:background:27] Health check [2022-04-29 05:21:08] [indexer:background:27] Health check [2022-04-29 05:23:04] [index:background:27] Health check [2022-04-29 05:28:24] [indexer:background:27] Health check [2022-04-29 05:28:25] [index:background:27] Health check [2022-04-29 05:35:22] [index:background:27] Health check [2022-04-29 05:35:22] [indexer:background:27] Health check [2022-04-29 05:35:22] [indexer:background:27] Health check [2022-04-29 05:39:56] [index:background:27] Health check [2022-04-29 05:39:56] [indexer:background:27] Health check [2022-04-29 05:39:56] [indexer:background:27] Health check [2022-04-29 05:46:49] [index:background:27] Health check [2022-04-29 05:46:49] [indexer:background:27] Health check [2022-04-29 05:46:49] [indexer:background:27] Health check [2022-04-29 05:52:10] [indexer:background:27] Health check [2022-04-29 05:52:10] [index:background:27] Health check [2022-04-29 05:59:12] [indexer:background:27] Health check [2022-04-29 05:59:12] [index:background:27] Health check [2022-04-29 06:05:25] [index:background:27] Health check [2022-04-29 06:05:25] [indexer:background:27] Health check [2022-04-29 06:05:25] [indexer:background:27] Health check [2022-04-29 06:11:27] [index:background:27] Health check [2022-04-29 06:11:27] [indexer:background:27] Health check [2022-04-29 06:11:27] [indexer:background:27] Health check [2022-04-29 06:15:53] [index:background:27] Health check [2022-04-29 06:15:53] [indexer:background:27] Health check [2022-04-29 06:15:53] [indexer:background:27] Health check [2022-04-29 06:17:49] [index:background:27] Health check [2022-04-29 06:19:41] [indexer:background:27] Health check [2022-04-29 06:24:09] [index:background:27] Health check [2022-04-29 06:24:09] [indexer:background:27] Health check [2022-04-29 06:24:09] [indexer:background:27] Health check [2022-04-29 06:30:35] [index:background:27] Health check [2022-04-29 06:30:35] [indexer:background:27] Health check [2022-04-29 06:30:35] [indexer:background:27] Health check [2022-04-29 06:36:20] [index:background:27] Health check [2022-04-29 06:36:20] [indexer:background:27] Health check [2022-04-29 06:36:20] [indexer:background:27] Health check [2022-04-29 06:42:57] [index:background:27] Health check [2022-04-29 06:42:57] [indexer:background:27] Health check [2022-04-29 06:42:57] [indexer:background:27] Health check [2022-04-29 06:49:38] [indexer:background:27] Health check [2022-04-29 06:49:38] [index:background:27] Health check [2022-04-29 06:53:05] [index:background:27] Health check [2022-04-29 06:54:38] [indexer:background:27] Health check [2022-04-29 07:02:36] [index:background:27] Health check [2022-04-29 07:02:36] [indexer:background:27] Health check [2022-04-29 07:02:36] [indexer:background:27] Health check [2022-04-29 07:07:30] [indexer:background:27] Health check [2022-04-29 07:07:30] [index:background:27] Health check [2022-04-29 07:08:54] [indexer:background:27] Health check [2022-04-29 07:14:33] [index:background:27] Health check [2022-04-29 07:14:33] [indexer:background:27] Health check [2022-04-29 07:14:33] [indexer:background:27] Health check [2022-04-29 07:22:22] [index:background:27] Health check [2022-04-29 07:22:22] [indexer:background:27] Health check [2022-04-29 07:22:22] [indexer:background:27] Health check [2022-04-29 07:23:20] [indexer:background:27] Health check [2022-04-29 07:29:01] [index:background:27] Health check [2022-04-29 07:29:01] [indexer:background:27] Health check [2022-04-29 07:29:01] [indexer:background:27] Health check [2022-04-29 07:32:46] [index:background:27] Health check [2022-04-29 07:33:18] [indexer:background:27] Health check [2022-04-29 07:36:47] [index:background:27] Health check [2022-04-29 07:38:19] [indexer:background:27] Health check [2022-04-29 07:41:47] [index:background:27] Health check [2022-04-29 07:43:19] [indexer:background:27] Health check [2022-04-29 07:46:47] [index:background:27] Health check [2022-04-29 07:48:19] [indexer:background:27] Health check [2022-04-29 07:51:48] [index:background:27] Health check [2022-04-29 07:53:18] [indexer:background:27] Health check [2022-04-29 07:56:48] [index:background:27] Health check [2022-04-29 07:58:19] [indexer:background:27] Health check [2022-04-29 08:01:47] [index:background:27] Health check [2022-04-29 08:03:18] [indexer:background:27] Health check [2022-04-29 08:06:48] [index:background:27] Health check [2022-04-29 08:08:18] [indexer:background:27] Health check [2022-04-29 08:11:47] [index:background:27] Health check [2022-04-29 08:13:18] [indexer:background:27] Health check [2022-04-29 08:16:47] [index:background:27] Health check [2022-04-29 08:18:18] [indexer:background:27] Health check [2022-04-29 08:21:47] [index:background:27] Health check [2022-04-29 08:23:18] [indexer:background:27] Health check [2022-04-29 08:26:47] [index:background:27] Health check [2022-04-29 08:28:18] [indexer:background:27] Health check [2022-04-29 08:31:47] [index:background:27] Health check [2022-04-29 08:33:19] [indexer:background:27] Health check [2022-04-29 08:36:47] [index:background:27] Health check [2022-04-29 08:38:18] [indexer:background:27] Health check [2022-04-29 08:41:47] [index:background:27] Health check [2022-04-29 08:44:41] [indexer:background:27] Health check [2022-04-29 08:45:55] [query:27] Query for: finance [2022-04-29 08:45:55] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 08:45:55] [query:27] Engine: default [2022-04-29 08:45:55] [query:27] Tokens: finance, financed, financi [2022-04-29 08:45:55] [query:27] Mods: 2 [2022-04-29 08:45:55] [query:27] Using OR logic [2022-04-29 08:45:55] [query:27] Found results using: and logic [2022-04-29 08:45:55] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (545,47254,48075) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 08:45:55] [query:27] Results: 36 Pages of results: 8 [2022-04-29 08:45:55] [query:27] Execution time: 0.09361 [2022-04-29 08:46:16] [query:27] Query for: finance [2022-04-29 08:46:16] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 08:46:16] [query:27] Engine: default [2022-04-29 08:46:16] [query:27] Tokens: finance, financed, financi [2022-04-29 08:46:16] [query:27] Mods: 2 [2022-04-29 08:46:16] [query:27] Using OR logic [2022-04-29 08:46:16] [query:27] Found results using: and logic [2022-04-29 08:46:16] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (545,47254,48075) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 08:46:16] [query:27] Results: 36 Pages of results: 8 [2022-04-29 08:46:16] [query:27] Execution time: 0.07801 [2022-04-29 08:50:29] [index:background:27] Health check [2022-04-29 08:50:29] [indexer:background:27] Health check [2022-04-29 08:50:29] [indexer:background:27] Health check [2022-04-29 08:53:16] [index:background:27] Health check [2022-04-29 08:53:22] [indexer:background:27] Health check [2022-04-29 08:58:17] [index:background:27] Health check [2022-04-29 09:03:30] [indexer:background:27] Health check [2022-04-29 09:03:30] [index:background:27] Health check [2022-04-29 09:08:27] [index:background:27] Health check [2022-04-29 09:08:27] [indexer:background:27] Health check [2022-04-29 09:08:27] [indexer:background:27] Health check [2022-04-29 09:12:19] [index:background:27] Health check [2022-04-29 09:15:32] [indexer:background:27] Health check [2022-04-29 09:20:02] [index:background:27] Health check [2022-04-29 09:20:02] [indexer:background:27] Health check [2022-04-29 09:20:02] [indexer:background:27] Health check [2022-04-29 09:22:44] [index:background:27] Health check [2022-04-29 09:24:06] [indexer:background:27] Health check [2022-04-29 09:27:03] [index:background:27] Health check [2022-04-29 09:34:04] [indexer:background:27] Health check [2022-04-29 09:34:04] [index:background:27] Health check [2022-04-29 09:38:02] [index:background:27] Health check [2022-04-29 09:40:11] [indexer:background:27] Health check [2022-04-29 09:42:15] [index:background:27] Health check [2022-04-29 09:43:51] [indexer:background:27] Health check [2022-04-29 09:46:48] [index:background:27] Health check [2022-04-29 09:50:41] [indexer:background:27] Health check [2022-04-29 09:53:18] [index:background:27] Health check [2022-04-29 09:53:18] [indexer:background:27] Health check [2022-04-29 09:53:18] [indexer:background:27] Health check [2022-04-29 09:57:53] [index:background:27] Health check [2022-04-29 09:59:26] [indexer:background:27] Health check [2022-04-29 10:04:01] [index:background:27] Health check [2022-04-29 10:04:01] [indexer:background:27] Health check [2022-04-29 10:04:01] [indexer:background:27] Health check [2022-04-29 10:08:37] [index:background:27] Health check [2022-04-29 10:08:37] [indexer:background:27] Health check [2022-04-29 10:08:37] [indexer:background:27] Health check [2022-04-29 10:12:10] [index:background:27] Health check [2022-04-29 10:13:41] [indexer:background:27] Health check [2022-04-29 10:17:12] [index:background:27] Health check [2022-04-29 10:19:38] [indexer:background:27] Health check [2022-04-29 10:19:48] [query:27] Query for: email [2022-04-29 10:19:48] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 10:19:48] [query:27] Engine: default [2022-04-29 10:19:48] [query:27] Tokens: emailed, emailing, emails, email [2022-04-29 10:19:48] [query:27] Mods: 2 [2022-04-29 10:19:48] [query:27] Using OR logic [2022-04-29 10:19:48] [query:27] Found results using: and logic [2022-04-29 10:19:48] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (900,1663,3096,739) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 10:19:48] [query:27] Results: 171 Pages of results: 35 [2022-04-29 10:19:48] [query:27] Execution time: 0.04681 [2022-04-29 10:26:59] [index:background:27] Health check [2022-04-29 10:26:59] [indexer:background:27] Health check [2022-04-29 10:26:59] [indexer:background:27] Health check [2022-04-29 10:30:25] [indexer:background:27] Health check [2022-04-29 10:32:07] [index:background:27] Health check [2022-04-29 10:33:20] [indexer:background:27] Health check [2022-04-29 10:41:44] [index:background:27] Health check [2022-04-29 10:41:44] [indexer:background:27] Health check [2022-04-29 10:41:44] [indexer:background:27] Health check [2022-04-29 10:44:11] [index:background:27] Health check [2022-04-29 10:44:11] [indexer:background:27] Health check [2022-04-29 10:44:11] [indexer:background:27] Health check [2022-04-29 10:49:14] [index:background:27] Health check [2022-04-29 10:49:14] [indexer:background:27] Health check [2022-04-29 10:49:14] [indexer:background:27] Health check [2022-04-29 10:51:49] [index:background:27] Health check [2022-04-29 10:51:49] [query:27] Query for: finance [2022-04-29 10:51:49] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 10:51:49] [query:27] Engine: default [2022-04-29 10:51:49] [query:27] Tokens: finance, financed, financi [2022-04-29 10:51:49] [query:27] Mods: 2 [2022-04-29 10:51:49] [query:27] Using OR logic [2022-04-29 10:51:49] [query:27] Found results using: and logic [2022-04-29 10:51:49] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (545,47254,48075) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 10:51:49] [query:27] Results: 36 Pages of results: 8 [2022-04-29 10:51:49] [query:27] Execution time: 0.07801 [2022-04-29 10:54:44] [indexer:background:27] Health check [2022-04-29 10:54:44] [indexer:background:27] Health check [2022-04-29 10:54:44] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-04-29 10:56:55] [index:background:27] Health check [2022-04-29 11:04:04] [indexer:background:27] Health check [2022-04-29 11:04:04] [index:background:27] Health check [2022-04-29 11:09:41] [index:background:27] Health check [2022-04-29 11:09:41] [indexer:background:27] Health check [2022-04-29 11:09:41] [indexer:background:27] Health check [2022-04-29 11:14:51] [index:background:27] Health check [2022-04-29 11:14:51] [indexer:background:27] Health check [2022-04-29 11:14:51] [indexer:background:27] Health check [2022-04-29 11:17:38] [index:background:27] Health check [2022-04-29 11:20:58] [indexer:background:27] Health check [2022-04-29 11:25:38] [index:background:27] Health check [2022-04-29 11:25:38] [indexer:background:27] Health check [2022-04-29 11:25:38] [indexer:background:27] Health check [2022-04-29 11:26:48] [index:background:27] Health check [2022-04-29 11:30:12] [indexer:background:27] Health check [2022-04-29 11:38:17] [index:background:27] Health check [2022-04-29 11:38:17] [indexer:background:27] Health check [2022-04-29 11:38:17] [indexer:background:27] Health check [2022-04-29 11:38:18] [indexer:background:27] Health check [2022-04-29 11:42:23] [index:background:27] Health check [2022-04-29 11:42:23] [index:background:27] Health check [2022-04-29 11:42:23] [indexer:background:27] Process is LOCKED, health check in 55 seconds [2022-04-29 11:48:34] [indexer:background:27] Health check [2022-04-29 11:48:34] [index:background:27] Health check [2022-04-29 11:54:55] [index:background:27] Health check [2022-04-29 11:54:55] [indexer:background:27] Health check [2022-04-29 11:54:55] [indexer:background:27] Health check [2022-04-29 11:59:38] [index:background:27] Health check [2022-04-29 11:59:38] [index:background:27] Health check [2022-04-29 11:59:38] [indexer:background:27] Process is LOCKED, health check in 1 min [2022-04-29 11:59:38] [indexer:background:27] Health check [2022-04-29 11:59:38] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-04-29 11:59:38] [indexer:background:27] Health check [2022-04-29 11:59:38] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-04-29 12:01:55] [index:background:27] Health check [2022-04-29 12:03:57] [indexer:background:27] Health check [2022-04-29 12:07:33] [index:background:27] Health check [2022-04-29 12:09:44] [indexer:background:27] Health check [2022-04-29 12:16:18] [index:background:27] Health check [2022-04-29 12:16:18] [indexer:background:27] Health check [2022-04-29 12:16:18] [indexer:background:27] Health check [2022-04-29 12:16:58] [index:background:27] Health check [2022-04-29 12:19:11] [indexer:background:27] Health check [2022-04-29 12:23:48] [index:background:27] Health check [2022-04-29 12:23:48] [indexer:background:27] Health check [2022-04-29 12:23:48] [indexer:background:27] Health check [2022-04-29 12:27:12] [index:background:27] Health check [2022-04-29 12:30:24] [indexer:background:27] Health check [2022-04-29 12:33:15] [index:background:27] Health check [2022-04-29 12:34:07] [indexer:background:27] Health check [2022-04-29 12:39:09] [index:background:27] Health check [2022-04-29 12:39:09] [indexer:background:27] Health check [2022-04-29 12:39:09] [indexer:background:27] Health check [2022-04-29 12:43:06] [index:background:27] Health check [2022-04-29 12:44:05] [indexer:background:27] Health check [2022-04-29 12:49:15] [index:background:27] Health check [2022-04-29 12:49:15] [indexer:background:27] Health check [2022-04-29 12:49:15] [indexer:background:27] Health check [2022-04-29 12:52:03] [index:background:27] Health check [2022-04-29 12:53:46] [indexer:background:27] Health check [2022-04-29 13:04:31] [index:background:27] Health check [2022-04-29 13:04:31] [indexer:background:27] Health check [2022-04-29 13:04:31] [indexer:background:27] Health check [2022-04-29 13:09:15] [index:background:27] Health check [2022-04-29 13:09:15] [indexer:background:27] Health check [2022-04-29 13:09:15] [indexer:background:27] Health check [2022-04-29 13:12:25] [index:background:27] Health check [2022-04-29 13:13:58] [indexer:background:27] Health check [2022-04-29 13:17:29] [index:background:27] Health check [2022-04-29 13:19:26] [indexer:background:27] Health check [2022-04-29 13:26:34] [index:background:27] Health check [2022-04-29 13:26:34] [indexer:background:27] Health check [2022-04-29 13:26:34] [indexer:background:27] Health check [2022-04-29 13:27:29] [index:background:27] Health check [2022-04-29 13:29:42] [indexer:background:27] Health check [2022-04-29 13:33:32] [index:background:27] Health check [2022-04-29 13:33:32] [indexer:background:27] Health check [2022-04-29 13:33:32] [indexer:background:27] Health check [2022-04-29 13:36:59] [index:background:27] Health check [2022-04-29 13:38:45] [indexer:background:27] Health check [2022-04-29 13:43:01] [index:background:27] Health check [2022-04-29 13:43:59] [indexer:background:27] Health check [2022-04-29 13:43:59] [indexer:background:27] Health check [2022-04-29 13:43:59] [indexer:background:27] Process is LOCKED, health check in 4 mins [2022-04-29 13:47:17] [index:background:27] Health check [2022-04-29 13:49:00] [indexer:background:27] Health check [2022-04-29 13:52:11] [index:background:27] Health check [2022-04-29 13:53:41] [indexer:background:27] Health check [2022-04-29 13:57:50] [index:background:27] Health check [2022-04-29 13:59:49] [indexer:background:27] Health check [2022-04-29 14:02:06] [index:background:27] Health check [2022-04-29 14:04:02] [indexer:background:27] Health check [2022-04-29 14:06:19] [query:27] Query for: allocation [2022-04-29 14:06:19] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 14:06:19] [query:27] Engine: default [2022-04-29 14:06:19] [query:27] Tokens: allocation, allocations, allocated, allocate, allocating, allocates, alloc [2022-04-29 14:06:19] [query:27] Mods: 2 [2022-04-29 14:06:19] [query:27] Using OR logic [2022-04-29 14:06:20] [query:27] Found results using: and logic [2022-04-29 14:06:20] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (423,442,548,762,5574,9763,26593) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 14:06:20] [query:27] Results: 94 Pages of results: 19 [2022-04-29 14:06:20] [query:27] Execution time: 0.06241 [2022-04-29 14:09:11] [index:background:27] Health check [2022-04-29 14:09:11] [indexer:background:27] Health check [2022-04-29 14:09:11] [indexer:background:27] Health check [2022-04-29 14:12:51] [index:background:27] Health check [2022-04-29 14:13:25] [indexer:background:27] Health check [2022-04-29 14:17:04] [index:background:27] Health check [2022-04-29 14:20:08] [indexer:background:27] Health check [2022-04-29 14:21:49] [index:background:27] Health check [2022-04-29 14:23:36] [indexer:background:27] Health check [2022-04-29 14:27:49] [index:background:27] Health check [2022-04-29 14:29:49] [indexer:background:27] Health check [2022-04-29 14:32:05] [index:background:27] Health check [2022-04-29 14:33:43] [indexer:background:27] Health check [2022-04-29 14:33:43] [query:27] Query for: special considerations [2022-04-29 14:33:43] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 14:33:43] [query:27] Engine: default [2022-04-29 14:33:43] [query:27] Tokens: considerate, specialities, speciality, considere, considerately, considerably, considerations, consideration, considerable, specially, special [2022-04-29 14:33:43] [query:27] Mods: 2 [2022-04-29 14:33:43] [query:27] Trying AND logic [2022-04-29 14:33:43] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-29 14:33:43] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-29 14:33:43] [query:27] Found results using: and logic [2022-04-29 14:33: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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (2179,27533,15531,50515,41079,12600,9928,3672,3664,45802,437) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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 ('2234', '3310', '3402', '3767', '4578', '5332', '5363', '6747', '7233', '7296', '8635', '8652', '8887', '9083', '9228', '9506') 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-04-29 14:33:43] [query:27] Results: 16 Pages of results: 4 [2022-04-29 14:33:43] [query:27] Execution time: 0.20282 [2022-04-29 14:37:02] [index:background:27] Health check [2022-04-29 14:38:48] [indexer:background:27] Health check [2022-04-29 14:42:55] [index:background:27] Health check [2022-04-29 14:43:35] [indexer:background:27] Health check [2022-04-29 14:47:05] [index:background:27] Health check [2022-04-29 14:48:56] [indexer:background:27] Health check [2022-04-29 14:52:00] [index:background:27] Health check [2022-04-29 14:53:38] [indexer:background:27] Health check [2022-04-29 14:57:48] [index:background:27] Health check [2022-04-29 14:58:42] [indexer:background:27] Health check [2022-04-29 15:02:05] [index:background:27] Health check [2022-04-29 15:03:23] [indexer:background:27] Health check [2022-04-29 15:07:05] [index:background:27] Health check [2022-04-29 15:08:31] [indexer:background:27] Health check [2022-04-29 15:09:20] [query:27] Query for: conference [2022-04-29 15:09:20] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 15:09:20] [query:27] Engine: default [2022-04-29 15:09:20] [query:27] Tokens: conference, conferences, conferred, confer [2022-04-29 15:09:20] [query:27] Mods: 2 [2022-04-29 15:09:20] [query:27] Using OR logic [2022-04-29 15:09:20] [query:27] Found results using: and logic [2022-04-29 15:09:20] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (1410,4493,18885,10348) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 15:09:20] [query:27] Results: 39 Pages of results: 8 [2022-04-29 15:09:20] [query:27] Execution time: 0.03120 [2022-04-29 15:09:31] [query:27] Query for: conference [2022-04-29 15:09:31] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 2 offset: 0 fields: all [2022-04-29 15:09:31] [query:27] Engine: default [2022-04-29 15:09:31] [query:27] Tokens: conference, conferences, conferred, confer [2022-04-29 15:09:31] [query:27] Mods: 2 [2022-04-29 15:09:31] [query:27] Using OR logic [2022-04-29 15:09:31] [query:27] Found results using: and logic [2022-04-29 15:09:31] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (1410,4493,18885,10348) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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 5, 5 [2022-04-29 15:09:31] [query:27] Results: 39 Pages of results: 8 [2022-04-29 15:09:31] [query:27] Execution time: 0.06241 [2022-04-29 15:12:03] [index:background:27] Health check [2022-04-29 15:13:24] [indexer:background:27] Health check [2022-04-29 15:13:24] [query:27] Query for: travel [2022-04-29 15:13:24] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 15:13:24] [query:27] Engine: default [2022-04-29 15:13:24] [query:27] Tokens: travelling, traveling, travellers, travelled, traveller, travel [2022-04-29 15:13:24] [query:27] Mods: 2 [2022-04-29 15:13:24] [query:27] Using OR logic [2022-04-29 15:13:24] [query:27] Found results using: and logic [2022-04-29 15:13:25] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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 (493,4492,16291,29968,46286,2045) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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-04-29 15:13:25] [query:27] Results: 50 Pages of results: 10 [2022-04-29 15:13:25] [query:27] Execution time: 0.04680 [2022-04-29 15:15:08] [query:27] Query for: student funding application [2022-04-29 15:15:08] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-29 15:15:08] [query:27] Engine: default [2022-04-29 15:15:08] [query:27] Tokens: application, students, funde, funding, funds, funded, applicables, applicability, applicant's, applicant, applications, applicable, applicants, student's, student, fund, applic [2022-04-29 15:15:08] [query:27] Mods: 2 [2022-04-29 15:15:08] [query:27] Trying AND logic [2022-04-29 15:15:08] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-29 15:15:08] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-29 15:15:08] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-29 15:15:08] [query:27] Found results using: and logic [2022-04-29 15:15:08] [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 ('content','slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_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'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) ) 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,145,44308,3734,948,941,48111,44414,41487,3372,849,620,456,398,261,5208,36198) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.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 ('10067', '10069', '10356', '10406', '1897', '2185', '2585', '3356', '3358', '3527', '3917', '4043', '4055', '4361', '4845', '5363', '6918', '7296', '7343', '7389', '8635', '9349', '9372', '9453', '9891', '9909', '9911', '9918', '9971', '9994') 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-04-29 15:15:08] [query:27] Results: 30 Pages of results: 6 [2022-04-29 15:15:08] [query:27] Execution time: 0.14041 [2022-04-29 15:16:53] [index:background:27] Health check [2022-04-29 15:18:38] [indexer:background:27] Health check [2022-04-29 15:22:36] [index:background:27] Health check [2022-04-29 15:23:20] [indexer:background:27] Health check [2022-04-29 15:26:59] [index:background:27] Health check [2022-04-29 15:28:31] [indexer:background:27] Health check [2022-04-29 15:32:34] [index:background:27] Health check [2022-04-29 15:36:16] [indexer:background:27] Health check [2022-04-29 15:37:54] [index:background:27] Health check [2022-04-29 15:38:24] [indexer:background:27] Health check [2022-04-29 15:42:00] [index:background:27] Health check [2022-04-29 15:43:58] [indexer:background:27] Health check [2022-04-29 15:46:53] [index:background:27] Health check [2022-04-29 15:49:46] [indexer:background:27] Health check [2022-04-29 15:52:35] [index:background:27] Health check [2022-04-29 15:56:40] [indexer:background:27] Health check [2022-04-29 15:58:40] [index:background:27] Health check [2022-04-29 15:58:40] [indexer:background:27] Health check [2022-04-29 15:58:40] [indexer:background:27] Health check [2022-04-29 16:01:49] [index:background:27] Health check [2022-04-29 16:03:57] [indexer:background:27] Health check [2022-04-29 16:07:11] [index:background:27] Health check [2022-04-29 16:11:14] [indexer:background:27] Health check [2022-04-29 16:13:15] [index:background:27] Health check [2022-04-29 16:13:39] [indexer:background:27] Health check [2022-04-29 16:17:06] [index:background:27] Health check [2022-04-29 16:20:04] [indexer:background:27] Health check [2022-04-29 16:22:06] [index:background:27] Health check [2022-04-29 16:24:54] [indexer:background:27] Health check [2022-04-29 16:27:26] [index:background:27] Health check [2022-04-29 16:29:46] [indexer:background:27] Health check [2022-04-29 16:31:47] [index:background:27] Health check [2022-04-29 16:33:18] [indexer:background:27] Health check [2022-04-29 16:36:47] [index:background:27] Health check [2022-04-29 16:38:49] [indexer:background:27] Health check [2022-04-29 16:42:06] [index:background:27] Health check [2022-04-29 16:44:08] [indexer:background:27] Health check [2022-04-29 16:48:45] [index:background:27] Health check [2022-04-29 16:48:45] [indexer:background:27] Health check [2022-04-29 16:48:45] [indexer:background:27] Health check [2022-04-29 16:53:47] [index:background:27] Health check [2022-04-29 16:53:47] [indexer:background:27] Health check [2022-04-29 16:53:47] [indexer:background:27] Health check [2022-04-29 16:58:21] [index:background:27] Health check [2022-04-29 16:58:21] [indexer:background:27] Health check [2022-04-29 16:58:21] [indexer:background:27] Health check [2022-04-29 17:03:05] [index:background:27] Health check [2022-04-29 17:04:34] [indexer:background:27] Health check [2022-04-29 17:08:39] [index:background:27] Health check [2022-04-29 17:08:39] [indexer:background:27] Health check [2022-04-29 17:08:39] [indexer:background:27] Health check [2022-04-29 17:12:46] [index:background:27] Health check [2022-04-29 17:13:43] [indexer:background:27] Health check [2022-04-29 17:19:20] [index:background:27] Health check [2022-04-29 17:19:20] [indexer:background:27] Health check [2022-04-29 17:19:20] [indexer:background:27] Health check [2022-04-29 17:22:51] [index:background:27] Health check [2022-04-29 17:25:16] [indexer:background:27] Health check [2022-04-29 17:27:09] [index:background:27] Health check [2022-04-29 17:28:47] [indexer:background:27] Health check [2022-04-29 17:33:13] [index:background:27] Health check [2022-04-29 17:33:46] [indexer:background:27] Health check [2022-04-29 17:37:24] [index:background:27] Health check [2022-04-29 17:39:09] [indexer:background:27] Health check [2022-04-29 17:42:35] [index:background:27] Health check [2022-04-29 17:47:47] [indexer:background:27] Health check [2022-04-29 17:47:47] [index:background:27] Health check [2022-04-29 17:51:49] [indexer:background:27] Health check [2022-04-29 17:51:49] [index:background:27] Health check [2022-04-29 17:53:51] [indexer:background:27] Health check [2022-04-29 17:56:59] [index:background:27] Health check [2022-04-29 18:00:39] [indexer:background:27] Health check [2022-04-29 18:02:14] [index:background:27] Health check [2022-04-29 18:05:13] [indexer:background:27] Health check [2022-04-29 18:08:17] [index:background:27] Health check [2022-04-29 18:08:45] [indexer:background:27] Health check [2022-04-29 18:12:12] [index:background:27] Health check [2022-04-29 18:15:08] [indexer:background:27] Health check [2022-04-29 18:17:11] [index:background:27] Health check [2022-04-29 18:20:41] [indexer:background:27] Health check [2022-04-29 18:22:36] [index:background:27] Health check [2022-04-29 18:24:25] [indexer:background:27] Health check [2022-04-29 18:27:14] [index:background:27] Health check [2022-04-29 18:29:24] [indexer:background:27] Health check [2022-04-29 18:34:51] [index:background:27] Health check [2022-04-29 18:34:51] [indexer:background:27] Health check [2022-04-29 18:34:51] [indexer:background:27] Health check [2022-04-29 18:36:52] [index:background:27] Health check [2022-04-29 18:38:52] [indexer:background:27] Health check [2022-04-29 18:43:37] [index:background:27] Health check [2022-04-29 18:43:37] [indexer:background:27] Health check [2022-04-29 18:43:37] [indexer:background:27] Health check [2022-04-29 18:47:25] [index:background:27] Health check [2022-04-29 18:51:06] [indexer:background:27] Health check [2022-04-29 18:53:12] [index:background:27] Health check [2022-04-29 18:54:20] [indexer:background:27] Health check [2022-04-29 18:57:58] [index:background:27] Health check [2022-04-29 18:59:27] [indexer:background:27] Health check [2022-04-29 19:05:32] [index:background:27] Health check [2022-04-29 19:05:32] [indexer:background:27] Health check [2022-04-29 19:05:32] [indexer:background:27] Health check [2022-04-29 19:07:38] [index:background:27] Health check [2022-04-29 19:08:45] [indexer:background:27] Health check [2022-04-29 19:12:28] [index:background:27] Health check [2022-04-29 19:13:59] [indexer:background:27] Health check [2022-04-29 19:17:57] [index:background:27] Health check [2022-04-29 19:19:53] [indexer:background:27] Health check [2022-04-29 19:22:00] [index:background:27] Health check [2022-04-29 19:23:48] [indexer:background:27] Health check [2022-04-29 19:28:18] [index:background:27] Health check [2022-04-29 19:28:18] [indexer:background:27] Health check [2022-04-29 19:28:18] [indexer:background:27] Health check [2022-04-29 19:32:22] [index:background:27] Health check [2022-04-29 19:34:05] [indexer:background:27] Health check [2022-04-29 19:37:29] [index:background:27] Health check [2022-04-29 19:41:07] [indexer:background:27] Health check [2022-04-29 19:42:40] [index:background:27] Health check [2022-04-29 19:44:53] [indexer:background:27] Health check [2022-04-29 19:49:03] [index:background:27] Health check [2022-04-29 19:49:03] [indexer:background:27] Health check [2022-04-29 19:49:03] [indexer:background:27] Health check [2022-04-29 19:51:47] [index:background:27] Health check [2022-04-29 19:55:26] [indexer:background:27] Health check [2022-04-29 19:56:56] [index:background:27] Health check [2022-04-29 20:01:01] [indexer:background:27] Health check [2022-04-29 20:02:57] [index:background:27] Health check [2022-04-29 20:03:24] [indexer:background:27] Health check [2022-04-29 20:06:50] [index:background:27] Health check [2022-04-29 20:08:26] [indexer:background:27] Health check [2022-04-29 20:11:48] [index:background:27] Health check [2022-04-29 20:14:42] [indexer:background:27] Health check [2022-04-29 20:17:13] [index:background:27] Health check [2022-04-29 20:19:19] [indexer:background:27] Health check [2022-04-29 20:24:00] [index:background:27] Health check [2022-04-29 20:24:00] [indexer:background:27] Health check [2022-04-29 20:24:00] [indexer:background:27] Health check [2022-04-29 20:29:34] [index:background:27] Health check [2022-04-29 20:29:34] [indexer:background:27] Health check [2022-04-29 20:29:34] [indexer:background:27] Health check [2022-04-29 20:31:56] [index:background:27] Health check [2022-04-29 20:34:27] [indexer:background:27] Health check [2022-04-29 20:37:48] [index:background:27] Health check [2022-04-29 20:38:18] [indexer:background:27] Health check [2022-04-29 20:41:57] [index:background:27] Health check [2022-04-29 20:45:46] [indexer:background:27] Health check [2022-04-29 20:47:54] [index:background:27] Health check [2022-04-29 20:48:57] [indexer:background:27] Health check [2022-04-29 20:53:27] [index:background:27] Health check [2022-04-29 20:53:27] [indexer:background:27] Health check [2022-04-29 20:53:27] [indexer:background:27] Health check [2022-04-29 20:58:09] [index:background:27] Health check [2022-04-29 21:00:04] [indexer:background:27] Health check [2022-04-29 21:02:27] [index:background:27] Health check [2022-04-29 21:03:19] [indexer:background:27] Health check [2022-04-29 21:08:31] [index:background:27] Health check [2022-04-29 21:08:31] [indexer:background:27] Health check [2022-04-29 21:08:31] [indexer:background:27] Health check [2022-04-29 21:12:33] [index:background:27] Health check [2022-04-29 21:14:25] [indexer:background:27] Health check [2022-04-29 21:16:53] [index:background:27] Health check [2022-04-29 21:18:35] [indexer:background:27] Health check [2022-04-29 21:22:04] [index:background:27] Health check [2022-04-29 21:24:23] [indexer:background:27] Health check [2022-04-29 21:26:48] [index:background:27] Health check [2022-04-29 21:28:43] [indexer:background:27] Health check [2022-04-29 21:31:56] [index:background:27] Health check [2022-04-29 21:34:10] [indexer:background:27] Health check [2022-04-29 21:37:11] [index:background:27] Health check [2022-04-29 21:41:10] [indexer:background:27] Health check [2022-04-29 21:43:37] [index:background:27] Health check [2022-04-29 21:43:37] [indexer:background:27] Health check [2022-04-29 21:43:37] [indexer:background:27] Health check [2022-04-29 21:46:59] [index:background:27] Health check [2022-04-29 21:49:52] [indexer:background:27] Health check [2022-04-29 21:51:54] [index:background:27] Health check [2022-04-29 21:55:26] [indexer:background:27] Health check [2022-04-29 21:57:22] [index:background:27] Health check [2022-04-29 21:59:30] [indexer:background:27] Health check [2022-04-29 22:04:16] [index:background:27] Health check [2022-04-29 22:04:16] [indexer:background:27] Health check [2022-04-29 22:04:16] [indexer:background:27] Health check [2022-04-29 22:09:51] [index:background:27] Health check [2022-04-29 22:09:51] [indexer:background:27] Health check [2022-04-29 22:09:51] [indexer:background:27] Health check [2022-04-29 22:12:14] [index:background:27] Health check [2022-04-29 22:13:52] [indexer:background:27] Health check [2022-04-29 22:18:36] [index:background:27] Health check [2022-04-29 22:18:36] [indexer:background:27] Health check [2022-04-29 22:18:36] [indexer:background:27] Health check [2022-04-29 22:24:04] [index:background:27] Health check [2022-04-29 22:24:04] [indexer:background:27] Health check [2022-04-29 22:24:04] [indexer:background:27] Health check [2022-04-29 22:28:07] [index:background:27] Health check [2022-04-29 22:28:22] [indexer:background:27] Health check [2022-04-29 22:32:54] [index:background:27] Health check [2022-04-29 22:34:27] [indexer:background:27] Health check [2022-04-29 22:38:33] [index:background:27] Health check [2022-04-29 22:38:33] [indexer:background:27] Health check [2022-04-29 22:38:33] [indexer:background:27] Health check [2022-04-29 22:42:36] [index:background:27] Health check [2022-04-29 22:43:41] [indexer:background:27] Health check [2022-04-29 22:47:16] [index:background:27] Health check [2022-04-29 22:48:51] [indexer:background:27] Health check [2022-04-29 22:52:53] [index:background:27] Health check [2022-04-29 22:55:17] [indexer:background:27] Health check [2022-04-29 22:56:57] [index:background:27] Health check [2022-04-29 22:58:43] [indexer:background:27] Health check [2022-04-29 23:03:45] [index:background:27] Health check [2022-04-29 23:03:45] [indexer:background:27] Health check [2022-04-29 23:03:45] [indexer:background:27] Health check [2022-04-29 23:07:19] [index:background:27] Health check [2022-04-29 23:09:19] [indexer:background:27] Health check [2022-04-29 23:12:30] [index:background:27] Health check [2022-04-29 23:16:05] [indexer:background:27] Health check [2022-04-29 23:17:27] [index:background:27] Health check [2022-04-29 23:21:42] [indexer:background:27] Health check [2022-04-29 23:22:52] [index:background:27] Health check [2022-04-29 23:23:38] [indexer:background:27] Health check [2022-04-29 23:26:49] [index:background:27] Health check [2022-04-29 23:30:27] [indexer:background:27] Health check [2022-04-29 23:31:59] [index:background:27] Health check [2022-04-29 23:35:14] [indexer:background:27] Health check [2022-04-29 23:37:56] [index:background:27] Health check [2022-04-29 23:38:24] [indexer:background:27] Health check [2022-04-29 23:41:48] [index:background:27] Health check [2022-04-29 23:44:45] [indexer:background:27] Health check [2022-04-29 23:46:49] [index:background:27] Health check [2022-04-29 23:50:21] [indexer:background:27] Health check [2022-04-29 23:52:20] [index:background:27] Health check [2022-04-29 23:53:29] [indexer:background:27] Health check [2022-04-29 23:59:12] [index:background:27] Health check [2022-04-29 23:59:12] [indexer:background:27] Health check [2022-04-29 23:59:12] [indexer:background:27] Health check