[2022-04-15 00:00:39] [index:background:27] Health check [2022-04-15 00:05:14] [indexer:background:27] Health check [2022-04-15 00:05:14] [index:background:27] Health check [2022-04-15 00:09:14] [indexer:background:27] Health check [2022-04-15 00:10:09] [index:background:27] Health check [2022-04-15 00:14:13] [indexer:background:27] Health check [2022-04-15 00:14:45] [index:background:27] Health check [2022-04-15 00:18:36] [indexer:background:27] Health check [2022-04-15 00:20:04] [index:background:27] Health check [2022-04-15 00:23:32] [indexer:background:27] Health check [2022-04-15 00:24:48] [index:background:27] Health check [2022-04-15 00:30:29] [indexer:background:27] Health check [2022-04-15 00:30:29] [index:background:27] Health check [2022-04-15 00:33:35] [indexer:background:27] Health check [2022-04-15 00:35:36] [index:background:27] Health check [2022-04-15 00:41:04] [indexer:background:27] Health check [2022-04-15 00:41:04] [index:background:27] Health check [2022-04-15 00:44:36] [indexer:background:27] Health check [2022-04-15 00:45:01] [index:background:27] Health check [2022-04-15 00:49:21] [indexer:background:27] Health check [2022-04-15 00:49:42] [index:background:27] Health check [2022-04-15 00:53:36] [indexer:background:27] Health check [2022-04-15 00:55:48] [index:background:27] Health check [2022-04-15 00:58:40] [indexer:background:27] Health check [2022-04-15 01:00:13] [index:background:27] Health check [2022-04-15 01:03:57] [indexer:background:27] Health check [2022-04-15 01:05:53] [index:background:27] Health check [2022-04-15 01:08:58] [indexer:background:27] Health check [2022-04-15 01:09:48] [index:background:27] Health check [2022-04-15 01:14:03] [indexer:background:27] Health check [2022-04-15 01:15:44] [index:background:27] Health check [2022-04-15 01:18:49] [indexer:background:27] Health check [2022-04-15 01:19:41] [index:background:27] Health check [2022-04-15 01:23:50] [indexer:background:27] Health check [2022-04-15 01:25:06] [index:background:27] Health check [2022-04-15 01:29:06] [indexer:background:27] Health check [2022-04-15 01:30:00] [index:background:27] Health check [2022-04-15 01:34:09] [indexer:background:27] Health check [2022-04-15 01:34:46] [index:background:27] Health check [2022-04-15 01:38:41] [indexer:background:27] Health check [2022-04-15 01:40:20] [index:background:27] Health check [2022-04-15 01:44:27] [indexer:background:27] Health check [2022-04-15 01:46:10] [index:background:27] Health check [2022-04-15 01:48:35] [indexer:background:27] Health check [2022-04-15 01:49:41] [index:background:27] Health check [2022-04-15 01:53:42] [indexer:background:27] Health check [2022-04-15 01:57:09] [index:background:27] Health check [2022-04-15 01:58:57] [indexer:background:27] Health check [2022-04-15 01:59:58] [index:background:27] Health check [2022-04-15 02:03:41] [indexer:background:27] Health check [2022-04-15 02:04:43] [index:background:27] Health check [2022-04-15 02:10:19] [indexer:background:27] Health check [2022-04-15 02:10:19] [index:background:27] Health check [2022-04-15 02:14:21] [indexer:background:27] Health check [2022-04-15 02:15:03] [index:background:27] Health check [2022-04-15 02:19:12] [indexer:background:27] Health check [2022-04-15 02:19:57] [index:background:27] Health check [2022-04-15 02:23:47] [indexer:background:27] Health check [2022-04-15 02:24:50] [index:background:27] Health check [2022-04-15 02:29:54] [indexer:background:27] Health check [2022-04-15 02:29:54] [index:background:27] Health check [2022-04-15 02:34:36] [indexer:background:27] Health check [2022-04-15 02:34:43] [index:background:27] Health check [2022-04-15 02:38:58] [indexer:background:27] Health check [2022-04-15 02:40:30] [index:background:27] Health check [2022-04-15 02:46:02] [indexer:background:27] Health check [2022-04-15 02:46:02] [index:background:27] Health check [2022-04-15 02:48:32] [indexer:background:27] Health check [2022-04-15 02:49:52] [index:background:27] Health check [2022-04-15 02:53:50] [indexer:background:27] Health check [2022-04-15 02:55:36] [index:background:27] Health check [2022-04-15 03:00:29] [indexer:background:27] Health check [2022-04-15 03:00:29] [index:background:27] Health check [2022-04-15 03:03:56] [indexer:background:27] Health check [2022-04-15 03:05:25] [index:background:27] Health check [2022-04-15 03:09:36] [indexer:background:27] Health check [2022-04-15 03:10:59] [index:background:27] Health check [2022-04-15 03:13:31] [indexer:background:27] Health check [2022-04-15 03:14:56] [index:background:27] Health check [2022-04-15 03:19:39] [indexer:background:27] Health check [2022-04-15 03:20:40] [index:background:27] Health check [2022-04-15 03:24:54] [indexer:background:27] Health check [2022-04-15 03:24:54] [index:background:27] Health check [2022-04-15 03:28:55] [indexer:background:27] Health check [2022-04-15 03:30:26] [index:background:27] Health check [2022-04-15 03:33:55] [indexer:background:27] Health check [2022-04-15 03:36:17] [index:background:27] Health check [2022-04-15 03:39:03] [indexer:background:27] Health check [2022-04-15 03:39:40] [index:background:27] Health check [2022-04-15 03:43:45] [indexer:background:27] Health check [2022-04-15 03:45:20] [index:background:27] Health check [2022-04-15 03:48:55] [indexer:background:27] Health check [2022-04-15 03:50:26] [index:background:27] Health check [2022-04-15 03:53:44] [indexer:background:27] Health check [2022-04-15 03:54:43] [index:background:27] Health check [2022-04-15 04:01:17] [indexer:background:27] Health check [2022-04-15 04:01:17] [index:background:27] Health check [2022-04-15 04:03:34] [indexer:background:27] Health check [2022-04-15 04:05:02] [index:background:27] Health check [2022-04-15 04:08:32] [indexer:background:27] Health check [2022-04-15 04:12:49] [index:background:27] Health check [2022-04-15 04:14:13] [indexer:background:27] Health check [2022-04-15 04:14:51] [index:background:27] Health check [2022-04-15 04:19:05] [indexer:background:27] Health check [2022-04-15 04:19:41] [index:background:27] Health check [2022-04-15 04:24:25] [indexer:background:27] Health check [2022-04-15 04:24:41] [index:background:27] Health check [2022-04-15 04:29:05] [indexer:background:27] Health check [2022-04-15 04:29:45] [index:background:27] Health check [2022-04-15 04:35:23] [indexer:background:27] Health check [2022-04-15 04:35:23] [index:background:27] Health check [2022-04-15 04:40:45] [indexer:background:27] Health check [2022-04-15 04:40:45] [index:background:27] Health check [2022-04-15 04:45:38] [indexer:background:27] Health check [2022-04-15 04:45:38] [index:background:27] Health check [2022-04-15 04:48:39] [indexer:background:27] Health check [2022-04-15 04:50:04] [index:background:27] Health check [2022-04-15 04:54:15] [indexer:background:27] Health check [2022-04-15 04:57:43] [index:background:27] Health check [2022-04-15 04:59:57] [indexer:background:27] Health check [2022-04-15 04:59:57] [index:background:27] Health check [2022-04-15 05:04:25] [indexer:background:27] Health check [2022-04-15 05:05:30] [index:background:27] Health check [2022-04-15 05:09:33] [indexer:background:27] Health check [2022-04-15 05:11:56] [index:background:27] Health check [2022-04-15 05:14:33] [indexer:background:27] Health check [2022-04-15 05:16:53] [index:background:27] Health check [2022-04-15 05:19:18] [indexer:background:27] Health check [2022-04-15 05:21:53] [index:background:27] Health check [2022-04-15 05:24:25] [indexer:background:27] Health check [2022-04-15 05:26:22] [index:background:27] Health check [2022-04-15 05:30:01] [indexer:background:27] Health check [2022-04-15 05:30:02] [index:background:27] Health check [2022-04-15 05:33:38] [indexer:background:27] Health check [2022-04-15 05:35:10] [index:background:27] Health check [2022-04-15 05:39:04] [indexer:background:27] Health check [2022-04-15 05:40:18] [index:background:27] Health check [2022-04-15 05:43:34] [indexer:background:27] Health check [2022-04-15 05:46:23] [index:background:27] Health check [2022-04-15 05:49:50] [indexer:background:27] Health check [2022-04-15 05:49:50] [index:background:27] Health check [2022-04-15 05:53:52] [indexer:background:27] Health check [2022-04-15 05:56:16] [index:background:27] Health check [2022-04-15 05:58:32] [indexer:background:27] Health check [2022-04-15 05:59:58] [index:background:27] Health check [2022-04-15 06:03:39] [indexer:background:27] Health check [2022-04-15 06:05:06] [index:background:27] Health check [2022-04-15 06:09:03] [indexer:background:27] Health check [2022-04-15 06:09:52] [index:background:27] Health check [2022-04-15 06:14:14] [indexer:background:27] Health check [2022-04-15 06:14:42] [index:background:27] Health check [2022-04-15 06:19:50] [indexer:background:27] Health check [2022-04-15 06:19:50] [index:background:27] Health check [2022-04-15 06:23:32] [indexer:background:27] Health check [2022-04-15 06:24:53] [index:background:27] Health check [2022-04-15 06:29:33] [indexer:background:27] Health check [2022-04-15 06:29:54] [index:background:27] Health check [2022-04-15 06:34:31] [indexer:background:27] Health check [2022-04-15 06:35:45] [index:background:27] Health check [2022-04-15 06:38:36] [indexer:background:27] Health check [2022-04-15 06:40:04] [index:background:27] Health check [2022-04-15 06:44:35] [indexer:background:27] Health check [2022-04-15 06:45:56] [index:background:27] Health check [2022-04-15 06:48:33] [indexer:background:27] Health check [2022-04-15 06:50:49] [index:background:27] Health check [2022-04-15 06:54:29] [indexer:background:27] Health check [2022-04-15 06:54:58] [index:background:27] Health check [2022-04-15 06:59:40] [indexer:background:27] Health check [2022-04-15 06:59:40] [index:background:27] Health check [2022-04-15 07:04:36] [indexer:background:27] Health check [2022-04-15 07:04:50] [index:background:27] Health check [2022-04-15 07:09:26] [indexer:background:27] Health check [2022-04-15 07:12:00] [index:background:27] Health check [2022-04-15 07:13:33] [indexer:background:27] Health check [2022-04-15 07:15:27] [index:background:27] Health check [2022-04-15 07:19:18] [indexer:background:27] Health check [2022-04-15 07:19:42] [index:background:27] Health check [2022-04-15 07:23:33] [indexer:background:27] Health check [2022-04-15 07:24:45] [index:background:27] Health check [2022-04-15 07:28:50] [indexer:background:27] Health check [2022-04-15 07:30:42] [index:background:27] Health check [2022-04-15 07:34:23] [indexer:background:27] Health check [2022-04-15 07:36:32] [index:background:27] Health check [2022-04-15 07:40:08] [indexer:background:27] Health check [2022-04-15 07:40:08] [index:background:27] Health check [2022-04-15 07:44:06] [indexer:background:27] Health check [2022-04-15 07:45:42] [index:background:27] Health check [2022-04-15 07:48:42] [indexer:background:27] Health check [2022-04-15 07:50:21] [index:background:27] Health check [2022-04-15 07:53:43] [indexer:background:27] Health check [2022-04-15 07:54:50] [index:background:27] Health check [2022-04-15 07:58:33] [indexer:background:27] Health check [2022-04-15 07:59:15] [index:27] Marking post.post 8556 to be dropped [2022-04-15 07:59:17] [index:27] Dropping post.post 8556 [2022-04-15 07:59:17] [indexer:27] Queued next batch (1) [2022-04-15 07:59:17] [indexer:27] Processing batch (1) [2022-04-15 07:59:17] [indexer:27] Indexing post.post:8556 [2022-04-15 07:59:17] [index:27] Marking [27] post.post 8556 as indexed [2022-04-15 07:59:17] [indexer:27] Queued next batch (1) [2022-04-15 07:59:18] [indexer:27] Processing batch (1) [2022-04-15 07:59:18] [indexer:27] Indexing post.attachment:10453 [2022-04-15 07:59:18] [index:27] Marking [27] post.attachment 10453 as indexed [2022-04-15 07:59:18] [indexer:27] Index built [2022-04-15 07:59:51] [index:background:27] Health check [2022-04-15 08:03:36] [indexer:background:27] Health check [2022-04-15 08:04:51] [index:background:27] Health check [2022-04-15 08:07:53] [index:27] Marking post.post 8556 to be dropped [2022-04-15 08:07:55] [index:27] Dropping post.post 8556 [2022-04-15 08:07:55] [indexer:27] Queued next batch (1) [2022-04-15 08:07:55] [indexer:27] Processing batch (1) [2022-04-15 08:07:55] [indexer:27] Indexing post.post:8556 [2022-04-15 08:07:55] [index:27] Marking [27] post.post 8556 as indexed [2022-04-15 08:07:55] [indexer:27] Index built [2022-04-15 08:08:40] [indexer:background:27] Health check [2022-04-15 08:10:13] [index:background:27] Health check [2022-04-15 08:13:42] [indexer:background:27] Health check [2022-04-15 08:14:57] [index:background:27] Health check [2022-04-15 08:18:32] [indexer:background:27] Health check [2022-04-15 08:19:42] [index:background:27] Health check [2022-04-15 08:23:35] [indexer:background:27] Health check [2022-04-15 08:25:40] [index:background:27] Health check [2022-04-15 08:28:51] [indexer:background:27] Health check [2022-04-15 08:29:51] [index:background:27] Health check [2022-04-15 08:33:52] [indexer:background:27] Health check [2022-04-15 08:35:52] [index:background:27] Health check [2022-04-15 08:38:43] [indexer:background:27] Health check [2022-04-15 08:39:43] [index:background:27] Health check [2022-04-15 08:44:27] [indexer:background:27] Health check [2022-04-15 08:44:58] [index:background:27] Health check [2022-04-15 08:48:58] [indexer:background:27] Health check [2022-04-15 08:50:06] [index:background:27] Health check [2022-04-15 08:53:37] [indexer:background:27] Health check [2022-04-15 08:54:53] [index:background:27] Health check [2022-04-15 08:58:47] [indexer:background:27] Health check [2022-04-15 08:59:43] [index:background:27] Health check [2022-04-15 09:03:48] [indexer:background:27] Health check [2022-04-15 09:05:42] [index:background:27] Health check [2022-04-15 09:08:49] [indexer:background:27] Health check [2022-04-15 09:09:43] [index:background:27] Health check [2022-04-15 09:14:15] [indexer:background:27] Health check [2022-04-15 09:15:32] [index:background:27] Health check [2022-04-15 09:19:26] [indexer:background:27] Health check [2022-04-15 09:19:42] [index:background:27] Health check [2022-04-15 09:25:43] [indexer:background:27] Health check [2022-04-15 09:25:43] [index:background:27] Health check [2022-04-15 09:28:43] [indexer:background:27] Health check [2022-04-15 09:29:58] [index:background:27] Health check [2022-04-15 09:33:58] [indexer:background:27] Health check [2022-04-15 09:35:58] [index:background:27] Health check [2022-04-15 09:38:38] [indexer:background:27] Health check [2022-04-15 09:39:41] [index:background:27] Health check [2022-04-15 09:44:00] [indexer:background:27] Health check [2022-04-15 09:44:48] [index:background:27] Health check [2022-04-15 09:49:49] [indexer:background:27] Health check [2022-04-15 09:49:49] [index:background:27] Health check [2022-04-15 09:53:50] [indexer:background:27] Health check [2022-04-15 09:54:40] [index:background:27] Health check [2022-04-15 09:59:00] [indexer:background:27] Health check [2022-04-15 10:00:42] [index:background:27] Health check [2022-04-15 10:03:53] [indexer:background:27] Health check [2022-04-15 10:05:19] [index:background:27] Health check [2022-04-15 10:08:34] [indexer:background:27] Health check [2022-04-15 10:09:54] [index:background:27] Health check [2022-04-15 10:13:52] [indexer:background:27] Health check [2022-04-15 10:15:16] [index:background:27] Health check [2022-04-15 10:18:39] [indexer:background:27] Health check [2022-04-15 10:18:46] [query:27] Query for: textbooks [2022-04-15 10:18:46] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 10:18:46] [query:27] Engine: default [2022-04-15 10:18:46] [query:27] Tokens: textbooks, textbook [2022-04-15 10:18:46] [query:27] Mods: 2 [2022-04-15 10:18:46] [query:27] Using OR logic [2022-04-15 10:18:46] [query:27] Found results using: and logic [2022-04-15 10:18:46] [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 (3061,29375) 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-04-15 10:18:46] [query:27] Results: 14 Pages of results: 3 [2022-04-15 10:18:46] [query:27] Execution time: 0.12481 [2022-04-15 10:19:47] [index:background:27] Health check [2022-04-15 10:23:33] [indexer:background:27] Health check [2022-04-15 10:24:41] [index:background:27] Health check [2022-04-15 10:28:37] [indexer:background:27] Health check [2022-04-15 10:30:09] [index:background:27] Health check [2022-04-15 10:33:47] [indexer:background:27] Health check [2022-04-15 10:34:43] [index:background:27] Health check [2022-04-15 10:38:48] [indexer:background:27] Health check [2022-04-15 10:39:41] [index:background:27] Health check [2022-04-15 10:43:46] [indexer:background:27] Health check [2022-04-15 10:45:01] [index:background:27] Health check [2022-04-15 10:48:33] [indexer:background:27] Health check [2022-04-15 10:50:31] [index:background:27] Health check [2022-04-15 10:53:48] [indexer:background:27] Health check [2022-04-15 10:54:50] [index:background:27] Health check [2022-04-15 10:58:35] [indexer:background:27] Health check [2022-04-15 10:59:51] [index:background:27] Health check [2022-04-15 11:05:39] [indexer:background:27] Health check [2022-04-15 11:05:39] [index:background:27] Health check [2022-04-15 11:09:13] [indexer:background:27] Health check [2022-04-15 11:10:28] [index:background:27] Health check [2022-04-15 11:14:28] [indexer:background:27] Health check [2022-04-15 11:16:28] [index:background:27] Health check [2022-04-15 11:18:39] [indexer:background:27] Health check [2022-04-15 11:19:41] [index:background:27] Health check [2022-04-15 11:23:41] [indexer:background:27] Health check [2022-04-15 11:24:41] [index:background:27] Health check [2022-04-15 11:27:10] [query:27] Query for: allocation [2022-04-15 11:27:10] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 11:27:10] [query:27] Engine: default [2022-04-15 11:27:10] [query:27] Tokens: allocation, allocations, allocated, allocate, allocating, allocates, alloc [2022-04-15 11:27:10] [query:27] Mods: 2 [2022-04-15 11:27:10] [query:27] Using OR logic [2022-04-15 11:27:10] [query:27] Found results using: and logic [2022-04-15 11:27:10] [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 (423,442,548,762,5574,9763,26593) 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-04-15 11:27:10] [query:27] Results: 81 Pages of results: 17 [2022-04-15 11:27:10] [query:27] Execution time: 0.04680 [2022-04-15 11:29:20] [indexer:background:27] Health check [2022-04-15 11:30:20] [index:background:27] Health check [2022-04-15 11:30:37] [query:27] Query for: cobiable [2022-04-15 11:30:37] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 11:30:37] [query:27] Engine: default [2022-04-15 11:30:37] [query:27] Tokens: copiable [2022-04-15 11:30:37] [query:27] Mods: 2 [2022-04-15 11:30:37] [query:27] Found results using: or logic [2022-04-15 11:30:37] [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 (5392) 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-04-15 11:30:37] [query:27] Results: 1 Pages of results: 1 [2022-04-15 11:30:37] [query:27] Execution time: 0.28082 [2022-04-15 11:30:37] [core:27] Render suggested search: copiable [2022-04-15 11:34:07] [indexer:background:27] Health check [2022-04-15 11:34:57] [index:background:27] Health check [2022-04-15 11:38:45] [indexer:background:27] Health check [2022-04-15 11:40:43] [index:background:27] Health check [2022-04-15 11:44:08] [indexer:background:27] Health check [2022-04-15 11:44:44] [index:background:27] Health check [2022-04-15 11:49:51] [indexer:background:27] Health check [2022-04-15 11:49:51] [index:background:27] Health check [2022-04-15 11:53:49] [indexer:background:27] Health check [2022-04-15 11:55:19] [index:background:27] Health check [2022-04-15 11:58:44] [indexer:background:27] Health check [2022-04-15 12:00:12] [index:background:27] Health check [2022-04-15 12:04:24] [indexer:background:27] Health check [2022-04-15 12:06:06] [index:background:27] Health check [2022-04-15 12:09:05] [indexer:background:27] Health check [2022-04-15 12:09:41] [index:background:27] Health check [2022-04-15 12:14:17] [indexer:background:27] Health check [2022-04-15 12:15:30] [index:background:27] Health check [2022-04-15 12:20:21] [indexer:background:27] Health check [2022-04-15 12:20:21] [index:background:27] Health check [2022-04-15 12:23:56] [indexer:background:27] Health check [2022-04-15 12:25:03] [index:background:27] Health check [2022-04-15 12:29:06] [indexer:background:27] Health check [2022-04-15 12:32:48] [index:background:27] Health check [2022-04-15 12:34:19] [indexer:background:27] Health check [2022-04-15 12:34:47] [index:background:27] Health check [2022-04-15 12:39:15] [indexer:background:27] Health check [2022-04-15 12:40:25] [index:background:27] Health check [2022-04-15 12:44:27] [indexer:background:27] Health check [2022-04-15 12:44:40] [index:background:27] Health check [2022-04-15 12:48:43] [indexer:background:27] Health check [2022-04-15 12:49:58] [index:background:27] Health check [2022-04-15 12:53:31] [indexer:background:27] Health check [2022-04-15 12:54:40] [index:background:27] Health check [2022-04-15 12:58:32] [indexer:background:27] Health check [2022-04-15 12:59:40] [index:background:27] Health check [2022-04-15 13:04:10] [indexer:background:27] Health check [2022-04-15 13:04:46] [index:background:27] Health check [2022-04-15 13:09:16] [indexer:background:27] Health check [2022-04-15 13:10:05] [index:background:27] Health check [2022-04-15 13:13:32] [indexer:background:27] Health check [2022-04-15 13:14:59] [index:background:27] Health check [2022-04-15 13:19:48] [indexer:background:27] Health check [2022-04-15 13:19:48] [index:background:27] Health check [2022-04-15 13:24:10] [indexer:background:27] Health check [2022-04-15 13:25:31] [index:background:27] Health check [2022-04-15 13:26:01] [query:27] Query for: finance [2022-04-15 13:26:01] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 13:26:01] [query:27] Engine: default [2022-04-15 13:26:01] [query:27] Tokens: finance, financed, financi [2022-04-15 13:26:01] [query:27] Mods: 2 [2022-04-15 13:26:01] [query:27] Using OR logic [2022-04-15 13:26:01] [query:27] Found results using: and logic [2022-04-15 13:26:01] [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 (545,47254,48075) 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-04-15 13:26:01] [query:27] Results: 31 Pages of results: 7 [2022-04-15 13:26:01] [query:27] Execution time: 0.07801 [2022-04-15 13:29:13] [indexer:background:27] Health check [2022-04-15 13:30:16] [index:background:27] Health check [2022-04-15 13:36:28] [indexer:background:27] Health check [2022-04-15 13:36:28] [index:background:27] Health check [2022-04-15 13:39:40] [indexer:background:27] Health check [2022-04-15 13:39:40] [index:background:27] Health check [2022-04-15 13:47:38] [indexer:background:27] Health check [2022-04-15 13:47:38] [index:background:27] Health check [2022-04-15 13:49:49] [indexer:background:27] Health check [2022-04-15 13:49:49] [index:background:27] Health check [2022-04-15 13:54:19] [indexer:background:27] Health check [2022-04-15 13:55:31] [index:background:27] Health check [2022-04-15 14:00:19] [indexer:background:27] Health check [2022-04-15 14:00:19] [index:background:27] Health check [2022-04-15 14:04:52] [indexer:background:27] Health check [2022-04-15 14:04:52] [index:background:27] Health check [2022-04-15 14:08:37] [indexer:background:27] Health check [2022-04-15 14:11:07] [index:background:27] Health check [2022-04-15 14:15:07] [indexer:background:27] Health check [2022-04-15 14:15:07] [index:background:27] Health check [2022-04-15 14:22:31] [indexer:background:27] Health check [2022-04-15 14:22:31] [index:background:27] Health check [2022-04-15 14:25:02] [indexer:background:27] Health check [2022-04-15 14:25:02] [index:background:27] Health check [2022-04-15 14:30:30] [indexer:background:27] Health check [2022-04-15 14:30:30] [index:background:27] Health check [2022-04-15 14:32:10] [query:27] Query for: reference [2022-04-15 14:32:10] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 14:32:10] [query:27] Engine: default [2022-04-15 14:32:10] [query:27] Tokens: referred, refers, reference, references, referring, refer [2022-04-15 14:32:10] [query:27] Mods: 2 [2022-04-15 14:32:10] [query:27] Using OR logic [2022-04-15 14:32:10] [query:27] Found results using: and logic [2022-04-15 14:32:10] [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 (388,428,1247,4422,10425,809) 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-04-15 14:32:10] [query:27] Results: 142 Pages of results: 29 [2022-04-15 14:32:10] [query:27] Execution time: 0.07801 [2022-04-15 14:33:48] [indexer:background:27] Health check [2022-04-15 14:34:30] [query:27] Query for: reference [2022-04-15 14:34:30] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 14:34:30] [query:27] Engine: default [2022-04-15 14:34:30] [query:27] Tokens: referred, refers, reference, references, referring, refer [2022-04-15 14:34:30] [query:27] Mods: 2 [2022-04-15 14:34:30] [query:27] Using OR logic [2022-04-15 14:34:30] [query:27] Found results using: and logic [2022-04-15 14:34:30] [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 (388,428,1247,4422,10425,809) 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-04-15 14:34:30] [query:27] Results: 142 Pages of results: 29 [2022-04-15 14:34:30] [query:27] Execution time: 0.09361 [2022-04-15 14:35:01] [index:background:27] Health check [2022-04-15 14:35:01] [query:27] Query for: studnet reference [2022-04-15 14:35:01] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 14:35:01] [query:27] Engine: default [2022-04-15 14:35:01] [query:27] Tokens: referred, referenced, referencing_styles, referrals, referring, referencing, references, reference, referral, refers, referrer, refer, referr, referen [2022-04-15 14:35:01] [query:27] Mods: 3 [2022-04-15 14:35:01] [query:27] Using OR logic [2022-04-15 14:35:01] [query:27] Found results using: and logic [2022-04-15 14:35:01] [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,( SELECT SUM(med_searchwp_index.occurrences) FROM med_searchwp_index WHERE med_searchwp_index.id = s.id AND med_searchwp_index.site = s.site AND med_searchwp_index.source = s.source AND med_searchwp_index.token IN(1247) GROUP BY med_searchwp_index.id ) AS searchwp_exacts 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 (388,25845,22644,18150,10425,10379,4422,1247,484,428,34450,809,23287,22609) 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 searchwp_exacts+0 DESC, relevance DESC LIMIT 0, 5 [2022-04-15 14:35:01] [query:27] Results: 146 Pages of results: 30 [2022-04-15 14:35:01] [query:27] Execution time: 0.17161 [2022-04-15 14:37:34] [query:27] Query for: Sim patient [2022-04-15 14:37:34] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 14:37:34] [query:27] Engine: default [2022-04-15 14:37:34] [query:27] Tokens: patients, patient's, sim, patient [2022-04-15 14:37:34] [query:27] Mods: 2 [2022-04-15 14:37:34] [query:27] Trying AND logic [2022-04-15 14:37:34] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-15 14:37:34] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-04-15 14:37:34] [query:27] Found results using: and logic [2022-04-15 14:37:34] [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 (296,41103,1790,243) 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 ('10077', '1829', '2418', '5985', '6149') 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-15 14:37:34] [query:27] Results: 5 Pages of results: 1 [2022-04-15 14:37:34] [query:27] Execution time: 0.04680 [2022-04-15 14:39:14] [indexer:background:27] Health check [2022-04-15 14:39:47] [index:background:27] Health check [2022-04-15 14:44:05] [indexer:background:27] Health check [2022-04-15 14:45:24] [index:background:27] Health check [2022-04-15 14:49:24] [indexer:background:27] Health check [2022-04-15 14:51:24] [index:background:27] Health check [2022-04-15 14:57:42] [indexer:background:27] Health check [2022-04-15 14:57:42] [index:background:27] Health check [2022-04-15 14:58:58] [indexer:background:27] Health check [2022-04-15 14:59:44] [index:background:27] Health check [2022-04-15 15:02:40] [query:27] Query for: management [2022-04-15 15:02:40] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 15:02:40] [query:27] Engine: default [2022-04-15 15:02:40] [query:27] Tokens: management, managed, manages, manage, managing, manager, managers, managment, manag [2022-04-15 15:02:40] [query:27] Mods: 2 [2022-04-15 15:02:40] [query:27] Using OR logic [2022-04-15 15:02:40] [query:27] Found results using: and logic [2022-04-15 15:02:40] [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 (244,550,553,938,1049,3413,14394,23724,23881) 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-04-15 15:02:40] [query:27] Results: 434 Pages of results: 87 [2022-04-15 15:02:40] [query:27] Execution time: 0.06241 [2022-04-15 15:02:55] [query:27] Query for: committees [2022-04-15 15:02:55] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 15:02:55] [query:27] Engine: default [2022-04-15 15:02:55] [query:27] Tokens: committee, committees [2022-04-15 15:02:55] [query:27] Mods: 2 [2022-04-15 15:02:55] [query:27] Using OR logic [2022-04-15 15:02:55] [query:27] Found results using: and logic [2022-04-15 15:02: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 ('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 (439,1089) 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-04-15 15:02:55] [query:27] Results: 162 Pages of results: 33 [2022-04-15 15:02:55] [query:27] Execution time: 0.03120 [2022-04-15 15:07:39] [indexer:background:27] Health check [2022-04-15 15:07:39] [index:background:27] Health check [2022-04-15 15:14:19] [indexer:background:27] Health check [2022-04-15 15:14:19] [index:background:27] Health check [2022-04-15 15:15:32] [index:background:27] Health check [2022-04-15 15:18:42] [indexer:background:27] Health check [2022-04-15 15:25:56] [index:background:27] Health check [2022-04-15 15:25:56] [indexer:background:27] Health check [2022-04-15 15:25:56] [indexer:background:27] Health check [2022-04-15 15:26:31] [query:27] Query for: essential [2022-04-15 15:26:31] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 15:26:31] [query:27] Engine: default [2022-04-15 15:26:31] [query:27] Tokens: essential, essentially, essentials [2022-04-15 15:26:31] [query:27] Mods: 2 [2022-04-15 15:26:31] [query:27] Using OR logic [2022-04-15 15:26:31] [query:27] Found results using: and logic [2022-04-15 15:26: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 ('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 (348,2290,29702) 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-04-15 15:26:31] [query:27] Results: 48 Pages of results: 10 [2022-04-15 15:26:31] [query:27] Execution time: 0.20282 [2022-04-15 15:27:04] [index:27] Marking post.post 9571 to be dropped [2022-04-15 15:27:05] [index:27] Dropping post.post 9571 [2022-04-15 15:27:05] [indexer:27] Index built [2022-04-15 15:27:54] [query:27] Query for: essential [2022-04-15 15:27:54] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 15:27:54] [query:27] Engine: default [2022-04-15 15:27:54] [query:27] Tokens: essential, essentially, essentials [2022-04-15 15:27:54] [query:27] Mods: 2 [2022-04-15 15:27:54] [query:27] Using OR logic [2022-04-15 15:27:54] [query:27] Found results using: and logic [2022-04-15 15:27:54] [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 (348,2290,29702) 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-04-15 15:27:54] [query:27] Results: 47 Pages of results: 10 [2022-04-15 15:27:54] [query:27] Execution time: 0.21842 [2022-04-15 15:28:44] [indexer:background:27] Health check [2022-04-15 15:29:43] [index:background:27] Health check [2022-04-15 15:33:53] [indexer:background:27] Health check [2022-04-15 15:37:36] [index:background:27] Health check [2022-04-15 15:42:26] [indexer:background:27] Health check [2022-04-15 15:42:26] [index:background:27] Health check [2022-04-15 15:46:42] [indexer:background:27] Health check [2022-04-15 15:46:42] [index:background:27] Health check [2022-04-15 16:19:49] [indexer:background:27] Health check [2022-04-15 16:19:49] [index:background:27] Health check [2022-04-15 16:25:33] [indexer:background:27] Health check [2022-04-15 16:25:33] [index:background:27] Health check [2022-04-15 16:43:20] [indexer:background:27] Health check [2022-04-15 16:43:20] [index:background:27] Health check [2022-04-15 16:56:51] [indexer:background:27] Health check [2022-04-15 16:56:51] [index:background:27] Health check [2022-04-15 17:01:02] [indexer:background:27] Health check [2022-04-15 17:01:02] [index:background:27] Health check [2022-04-15 17:05:20] [indexer:background:27] Health check [2022-04-15 17:05:20] [index:background:27] Health check [2022-04-15 17:16:30] [indexer:background:27] Health check [2022-04-15 17:16:30] [index:background:27] Health check [2022-04-15 17:24:20] [indexer:background:27] Health check [2022-04-15 17:24:20] [index:background:27] Health check [2022-04-15 17:24:59] [index:background:27] Health check [2022-04-15 17:28:45] [indexer:background:27] Health check [2022-04-15 17:31:52] [index:background:27] Health check [2022-04-15 17:34:02] [indexer:background:27] Health check [2022-04-15 17:34:41] [index:background:27] Health check [2022-04-15 17:38:32] [indexer:background:27] Health check [2022-04-15 17:39:41] [index:background:27] Health check [2022-04-15 17:43:31] [indexer:background:27] Health check [2022-04-15 17:44:40] [index:background:27] Health check [2022-04-15 17:48:32] [indexer:background:27] Health check [2022-04-15 17:49:40] [index:background:27] Health check [2022-04-15 17:53:32] [indexer:background:27] Health check [2022-04-15 17:54:40] [index:background:27] Health check [2022-04-15 17:58:33] [indexer:background:27] Health check [2022-04-15 17:59:41] [index:background:27] Health check [2022-04-15 18:03:32] [indexer:background:27] Health check [2022-04-15 18:04:41] [index:background:27] Health check [2022-04-15 18:08:32] [indexer:background:27] Health check [2022-04-15 18:09:41] [index:background:27] Health check [2022-04-15 18:13:31] [indexer:background:27] Health check [2022-04-15 18:14:41] [index:background:27] Health check [2022-04-15 18:18:32] [indexer:background:27] Health check [2022-04-15 18:19:41] [index:background:27] Health check [2022-04-15 18:23:32] [indexer:background:27] Health check [2022-04-15 18:24:40] [index:background:27] Health check [2022-04-15 18:28:32] [indexer:background:27] Health check [2022-04-15 18:29:41] [index:background:27] Health check [2022-04-15 18:33:31] [indexer:background:27] Health check [2022-04-15 18:34:40] [index:background:27] Health check [2022-04-15 18:38:32] [indexer:background:27] Health check [2022-04-15 18:39:41] [index:background:27] Health check [2022-04-15 18:43:31] [indexer:background:27] Health check [2022-04-15 18:44:40] [index:background:27] Health check [2022-04-15 18:48:31] [indexer:background:27] Health check [2022-04-15 18:49:41] [index:background:27] Health check [2022-04-15 18:53:32] [indexer:background:27] Health check [2022-04-15 18:54:41] [index:background:27] Health check [2022-04-15 18:58:31] [indexer:background:27] Health check [2022-04-15 18:59:41] [index:background:27] Health check [2022-04-15 19:03:32] [indexer:background:27] Health check [2022-04-15 19:04:41] [index:background:27] Health check [2022-04-15 19:08:32] [indexer:background:27] Health check [2022-04-15 19:09:41] [index:background:27] Health check [2022-04-15 19:13:32] [indexer:background:27] Health check [2022-04-15 19:14:41] [index:background:27] Health check [2022-04-15 19:18:31] [indexer:background:27] Health check [2022-04-15 19:19:40] [index:background:27] Health check [2022-04-15 19:25:13] [indexer:background:27] Health check [2022-04-15 19:25:13] [index:background:27] Health check [2022-04-15 19:35:03] [indexer:background:27] Health check [2022-04-15 19:35:03] [index:background:27] Health check [2022-04-15 19:40:44] [indexer:background:27] Health check [2022-04-15 19:40:44] [index:background:27] Health check [2022-04-15 19:47:16] [indexer:background:27] Health check [2022-04-15 19:47:16] [index:background:27] Health check [2022-04-15 19:49:44] [indexer:background:27] Health check [2022-04-15 19:49:44] [index:background:27] Health check [2022-04-15 20:01:04] [indexer:background:27] Health check [2022-04-15 20:01:04] [index:background:27] Health check [2022-04-15 20:10:12] [indexer:background:27] Health check [2022-04-15 20:10:12] [index:background:27] Health check [2022-04-15 20:14:00] [indexer:background:27] Health check [2022-04-15 20:14:47] [index:background:27] Health check [2022-04-15 20:31:54] [indexer:background:27] Health check [2022-04-15 20:31:55] [index:background:27] Health check [2022-04-15 20:40:36] [indexer:background:27] Health check [2022-04-15 20:40:37] [index:background:27] Health check [2022-04-15 20:40:57] [query:27] Query for: scotgem [2022-04-15 20:40:57] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-04-15 20:40:57] [query:27] Engine: default [2022-04-15 20:40:57] [query:27] Tokens: scotgem [2022-04-15 20:40:57] [query:27] Mods: 2 [2022-04-15 20:40:57] [query:27] Found results using: or logic [2022-04-15 20:40:57] [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 (458) 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-04-15 20:40:57] [query:27] Results: 85 Pages of results: 17 [2022-04-15 20:40:57] [query:27] Execution time: 0.04680 [2022-04-15 20:43:32] [indexer:background:27] Health check [2022-04-15 20:45:23] [index:background:27] Health check [2022-04-15 20:48:46] [indexer:background:27] Health check [2022-04-15 20:50:20] [index:background:27] Health check [2022-04-15 20:54:52] [indexer:background:27] Health check [2022-04-15 20:54:52] [index:background:27] Health check [2022-04-15 21:01:02] [indexer:background:27] Health check [2022-04-15 21:01:02] [index:background:27] Health check [2022-04-15 21:07:01] [indexer:background:27] Health check [2022-04-15 21:07:01] [index:background:27] Health check [2022-04-15 21:14:01] [indexer:background:27] Health check [2022-04-15 21:14:01] [index:background:27] Health check [2022-04-15 21:19:23] [index:background:27] Health check [2022-04-15 21:19:23] [indexer:background:27] Health check [2022-04-15 21:19:23] [indexer:background:27] Health check [2022-04-15 21:19:58] [index:background:27] Health check [2022-04-15 21:30:44] [indexer:background:27] Health check [2022-04-15 21:30:44] [index:background:27] Health check [2022-04-15 21:35:13] [indexer:background:27] Health check [2022-04-15 21:35:13] [index:background:27] Health check [2022-04-15 21:43:34] [indexer:background:27] Health check [2022-04-15 21:43:34] [index:background:27] Health check [2022-04-15 21:51:59] [index:background:27] Health check [2022-04-15 21:52:00] [indexer:background:27] Health check [2022-04-15 21:52:00] [indexer:background:27] Health check [2022-04-15 22:00:27] [indexer:background:27] Health check [2022-04-15 22:00:27] [index:background:27] Health check [2022-04-15 22:16:17] [indexer:background:27] Health check [2022-04-15 22:16:17] [index:background:27] Health check [2022-04-15 22:18:39] [indexer:background:27] Health check [2022-04-15 22:19:51] [index:background:27] Health check [2022-04-15 22:25:37] [indexer:background:27] Health check [2022-04-15 22:25:37] [index:background:27] Health check [2022-04-15 22:29:38] [indexer:background:27] Health check [2022-04-15 22:38:50] [index:background:27] Health check [2022-04-15 22:38:50] [indexer:background:27] Health check [2022-04-15 22:38:50] [indexer:background:27] Health check [2022-04-15 22:40:01] [index:background:27] Health check [2022-04-15 22:53:04] [indexer:background:27] Health check [2022-04-15 22:53:04] [index:background:27] Health check [2022-04-15 23:04:13] [indexer:background:27] Health check [2022-04-15 23:04:13] [index:background:27] Health check [2022-04-15 23:10:11] [index:background:27] Health check [2022-04-15 23:10:11] [indexer:background:27] Health check [2022-04-15 23:10:11] [indexer:background:27] Health check [2022-04-15 23:18:07] [indexer:background:27] Health check [2022-04-15 23:18:07] [index:background:27] Health check [2022-04-15 23:20:59] [indexer:background:27] Health check [2022-04-15 23:20:59] [index:background:27] Health check [2022-04-15 23:24:04] [indexer:background:27] Health check [2022-04-15 23:26:44] [index:background:27] Health check [2022-04-15 23:28:56] [indexer:background:27] Health check [2022-04-15 23:32:08] [index:background:27] Health check [2022-04-15 23:52:22] [indexer:background:27] Health check [2022-04-15 23:52:22] [index:background:27] Health check