[2022-04-18 00:03:41] [indexer:background:27] Health check
[2022-04-18 00:06:17] [index:background:27] Health check
[2022-04-18 00:08:49] [indexer:background:27] Health check
[2022-04-18 00:09:45] [index:background:27] Health check
[2022-04-18 00:13:33] [indexer:background:27] Health check
[2022-04-18 00:16:25] [index:background:27] Health check
[2022-04-18 00:19:20] [indexer:background:27] Health check
[2022-04-18 00:25:15] [index:background:27] Health check
[2022-04-18 00:25:15] [indexer:background:27] Health check
[2022-04-18 00:25:15] [indexer:background:27] Health check
[2022-04-18 00:28:31] [indexer:background:27] Health check
[2022-04-18 00:31:58] [index:background:27] Health check
[2022-04-18 00:39:05] [indexer:background:27] Health check
[2022-04-18 00:39:05] [index:background:27] Health check
[2022-04-18 00:44:57] [index:background:27] Health check
[2022-04-18 00:44:57] [indexer:background:27] Health check
[2022-04-18 00:44:57] [indexer:background:27] Health check
[2022-04-18 00:52:31] [indexer:background:27] Health check
[2022-04-18 00:52:31] [index:background:27] Health check
[2022-04-18 00:55:39] [indexer:background:27] Health check
[2022-04-18 00:55:39] [index:background:27] Health check
[2022-04-18 00:59:22] [indexer:background:27] Health check
[2022-04-18 01:04:25] [index:background:27] Health check
[2022-04-18 01:04:25] [indexer:background:27] Health check
[2022-04-18 01:04:25] [indexer:background:27] Health check
[2022-04-18 01:04:44] [index:background:27] Health check
[2022-04-18 01:08:36] [indexer:background:27] Health check
[2022-04-18 01:10:47] [index:background:27] Health check
[2022-04-18 01:13:37] [indexer:background:27] Health check
[2022-04-18 01:17:13] [index:background:27] Health check
[2022-04-18 01:20:13] [indexer:background:27] Health check
[2022-04-18 01:20:13] [index:background:27] Health check
[2022-04-18 01:25:23] [indexer:background:27] Health check
[2022-04-18 01:25:23] [index:background:27] Health check
[2022-04-18 01:29:38] [indexer:background:27] Health check
[2022-04-18 01:32:40] [index:background:27] Health check
[2022-04-18 01:33:58] [indexer:background:27] Health check
[2022-04-18 01:34:47] [index:background:27] Health check
[2022-04-18 01:41:17] [indexer:background:27] Health check
[2022-04-18 01:41:17] [index:background:27] Health check
[2022-04-18 01:48:23] [indexer:background:27] Health check
[2022-04-18 01:48:23] [index:background:27] Health check
[2022-04-18 01:48:49] [indexer:background:27] Health check
[2022-04-18 01:54:53] [index:background:27] Health check
[2022-04-18 01:54:53] [indexer:background:27] Health check
[2022-04-18 01:54:53] [indexer:background:27] Health check
[2022-04-18 02:02:45] [indexer:background:27] Health check
[2022-04-18 02:02:45] [index:background:27] Health check
[2022-04-18 02:03:35] [indexer:background:27] Health check
[2022-04-18 02:06:05] [index:background:27] Health check
[2022-04-18 02:09:40] [indexer:background:27] Health check
[2022-04-18 02:09:40] [index:background:27] Health check
[2022-04-18 02:15:08] [indexer:background:27] Health check
[2022-04-18 02:15:08] [index:background:27] Health check
[2022-04-18 02:23:42] [indexer:background:27] Health check
[2022-04-18 02:23:42] [index:background:27] Health check
[2022-04-18 02:25:44] [index:background:27] Health check
[2022-04-18 02:31:21] [indexer:background:27] Health check
[2022-04-18 02:31:21] [index:background:27] Health check
[2022-04-18 02:37:43] [indexer:background:27] Health check
[2022-04-18 02:37:43] [index:background:27] Health check
[2022-04-18 02:39:10] [indexer:background:27] Health check
[2022-04-18 02:42:35] [index:background:27] Health check
[2022-04-18 02:46:12] [indexer:background:27] Health check
[2022-04-18 02:46:12] [index:background:27] Health check
[2022-04-18 02:49:41] [indexer:background:27] Health check
[2022-04-18 02:49:41] [index:background:27] Health check
[2022-04-18 03:00:00] [indexer:background:27] Health check
[2022-04-18 03:00:00] [index:background:27] Health check
[2022-04-18 03:08:17] [indexer:background:27] Health check
[2022-04-18 03:08:18] [index:background:27] Health check
[2022-04-18 03:15:26] [indexer:background:27] Health check
[2022-04-18 03:15:26] [index:background:27] Health check
[2022-04-18 03:23:11] [indexer:background:27] Health check
[2022-04-18 03:23:11] [index:background:27] Health check
[2022-04-18 03:24:48] [indexer:background:27] Health check
[2022-04-18 03:24:48] [index:background:27] Health check
[2022-04-18 03:28:46] [indexer:background:27] Health check
[2022-04-18 03:32:48] [index:background:27] Health check
[2022-04-18 03:36:20] [indexer:background:27] Health check
[2022-04-18 03:36:20] [index:background:27] Health check
[2022-04-18 03:43:30] [indexer:background:27] Health check
[2022-04-18 03:43:30] [index:background:27] Health check
[2022-04-18 03:44:09] [indexer:background:27] Health check
[2022-04-18 03:48:25] [index:background:27] Health check
[2022-04-18 03:50:15] [indexer:background:27] Health check
[2022-04-18 03:50:15] [index:background:27] Health check
[2022-04-18 03:56:38] [indexer:background:27] Health check
[2022-04-18 03:56:38] [index:background:27] Health check
[2022-04-18 04:02:41] [indexer:background:27] Health check
[2022-04-18 04:02:41] [index:background:27] Health check
[2022-04-18 04:08:08] [indexer:background:27] Health check
[2022-04-18 04:08:08] [index:background:27] Health check
[2022-04-18 04:09:02] [indexer:background:27] Health check
[2022-04-18 04:11:22] [index:background:27] Health check
[2022-04-18 04:13:56] [indexer:background:27] Health check
[2022-04-18 04:16:55] [index:background:27] Health check
[2022-04-18 04:19:28] [indexer:background:27] Health check
[2022-04-18 04:20:13] [index:background:27] Health check
[2022-04-18 04:24:44] [indexer:background:27] Health check
[2022-04-18 04:24:44] [index:background:27] Health check
[2022-04-18 04:30:11] [indexer:background:27] Health check
[2022-04-18 04:30:11] [index:background:27] Health check
[2022-04-18 04:35:08] [indexer:background:27] Health check
[2022-04-18 04:35:08] [index:background:27] Health check
[2022-04-18 04:40:21] [indexer:background:27] Health check
[2022-04-18 04:40:21] [index:background:27] Health check
[2022-04-18 04:44:50] [indexer:background:27] Health check
[2022-04-18 04:44:50] [index:background:27] Health check
[2022-04-18 04:49:43] [indexer:background:27] Health check
[2022-04-18 04:49:43] [index:background:27] Health check
[2022-04-18 04:54:28] [indexer:background:27] Health check
[2022-04-18 04:57:05] [index:background:27] Health check
[2022-04-18 04:59:23] [indexer:background:27] Health check
[2022-04-18 05:02:12] [index:background:27] Health check
[2022-04-18 05:03:48] [indexer:background:27] Health check
[2022-04-18 05:06:17] [index:background:27] Health check
[2022-04-18 05:08:44] [indexer:background:27] Health check
[2022-04-18 05:12:44] [index:background:27] Health check
[2022-04-18 05:17:24] [indexer:background:27] Health check
[2022-04-18 05:17:24] [index:background:27] Health check
[2022-04-18 05:18:57] [indexer:background:27] Health check
[2022-04-18 05:22:18] [index:background:27] Health check
[2022-04-18 05:26:51] [indexer:background:27] Health check
[2022-04-18 05:26:51] [index:background:27] Health check
[2022-04-18 05:30:22] [indexer:background:27] Health check
[2022-04-18 05:30:22] [index:background:27] Health check
[2022-04-18 05:35:53] [indexer:background:27] Health check
[2022-04-18 05:35:53] [index:background:27] Health check
[2022-04-18 05:40:30] [indexer:background:27] Health check
[2022-04-18 05:40:30] [index:background:27] Health check
[2022-04-18 05:45:13] [indexer:background:27] Health check
[2022-04-18 05:45:13] [index:background:27] Health check
[2022-04-18 05:50:06] [indexer:background:27] Health check
[2022-04-18 05:50:06] [index:background:27] Health check
[2022-04-18 05:54:56] [indexer:background:27] Health check
[2022-04-18 05:54:56] [index:background:27] Health check
[2022-04-18 05:58:59] [indexer:background:27] Health check
[2022-04-18 06:04:10] [index:background:27] Health check
[2022-04-18 06:04:10] [indexer:background:27] Health check
[2022-04-18 06:04:10] [indexer:background:27] Health check
[2022-04-18 06:08:42] [index:background:27] Health check
[2022-04-18 06:08:42] [indexer:background:27] Health check
[2022-04-18 06:08:42] [indexer:background:27] Health check
[2022-04-18 06:11:06] [index:background:27] Health check
[2022-04-18 06:16:21] [indexer:background:27] Health check
[2022-04-18 06:16:21] [index:background:27] Health check
[2022-04-18 06:22:38] [indexer:background:27] Health check
[2022-04-18 06:22:38] [index:background:27] Health check
[2022-04-18 06:27:19] [indexer:background:27] Health check
[2022-04-18 06:27:19] [index:background:27] Health check
[2022-04-18 06:30:33] [indexer:background:27] Health check
[2022-04-18 06:30:33] [index:background:27] Health check
[2022-04-18 06:36:28] [indexer:background:27] Health check
[2022-04-18 06:36:28] [index:background:27] Health check
[2022-04-18 06:38:52] [indexer:background:27] Health check
[2022-04-18 06:40:11] [index:background:27] Health check
[2022-04-18 06:46:03] [indexer:background:27] Health check
[2022-04-18 06:46:03] [index:background:27] Health check
[2022-04-18 06:50:50] [indexer:background:27] Health check
[2022-04-18 06:50:50] [index:background:27] Health check
[2022-04-18 06:55:27] [indexer:background:27] Health check
[2022-04-18 06:55:27] [index:background:27] Health check
[2022-04-18 06:59:40] [indexer:background:27] Health check
[2022-04-18 06:59:40] [index:background:27] Health check
[2022-04-18 07:03:37] [indexer:background:27] Health check
[2022-04-18 07:04:44] [index:background:27] Health check
[2022-04-18 07:09:45] [indexer:background:27] Health check
[2022-04-18 07:09:45] [index:background:27] Health check
[2022-04-18 07:14:38] [indexer:background:27] Health check
[2022-04-18 07:17:24] [index:background:27] Health check
[2022-04-18 07:19:05] [indexer:background:27] Health check
[2022-04-18 07:23:52] [index:background:27] Health check
[2022-04-18 07:23:53] [indexer:background:27] Health check
[2022-04-18 07:23:53] [indexer:background:27] Health check
[2022-04-18 07:24:54] [index:background:27] Health check
[2022-04-18 07:29:04] [indexer:background:27] Health check
[2022-04-18 07:33:56] [index:background:27] Health check
[2022-04-18 07:33:56] [indexer:background:27] Health check
[2022-04-18 07:33:56] [indexer:background:27] Health check
[2022-04-18 07:36:16] [index:background:27] Health check
[2022-04-18 07:38:42] [indexer:background:27] Health check
[2022-04-18 07:39:53] [index:background:27] Health check
[2022-04-18 07:44:04] [indexer:background:27] Health check
[2022-04-18 07:46:42] [index:background:27] Health check
[2022-04-18 07:48:37] [indexer:background:27] Health check
[2022-04-18 07:53:33] [index:background:27] Health check
[2022-04-18 07:53:33] [indexer:background:27] Health check
[2022-04-18 07:53:33] [indexer:background:27] Health check
[2022-04-18 07:55:44] [index:background:27] Health check
[2022-04-18 07:59:18] [indexer:background:27] Health check
[2022-04-18 08:03:13] [index:background:27] Health check
[2022-04-18 08:08:38] [indexer:background:27] Health check
[2022-04-18 08:08:38] [index:background:27] Health check
[2022-04-18 08:12:34] [index:background:27] Health check
[2022-04-18 08:13:33] [indexer:background:27] Health check
[2022-04-18 08:16:23] [index:background:27] Health check
[2022-04-18 08:20:09] [indexer:background:27] Health check
[2022-04-18 08:20:09] [index:background:27] Health check
[2022-04-18 08:23:54] [indexer:background:27] Health check
[2022-04-18 08:26:40] [index:background:27] Health check
[2022-04-18 08:33:27] [indexer:background:27] Health check
[2022-04-18 08:33:27] [index:background:27] Health check
[2022-04-18 08:33:42] [indexer:background:27] Health check
[2022-04-18 08:38:45] [index:background:27] Health check
[2022-04-18 08:38:45] [indexer:background:27] Health check
[2022-04-18 08:38:45] [indexer:background:27] Health check
[2022-04-18 08:43:36] [index:background:27] Health check
[2022-04-18 08:43:36] [indexer:background:27] Health check
[2022-04-18 08:43:36] [indexer:background:27] Health check
[2022-04-18 08:48:54] [index:background:27] Health check
[2022-04-18 08:48:54] [indexer:background:27] Health check
[2022-04-18 08:48:54] [indexer:background:27] Health check
[2022-04-18 08:52:54] [index:background:27] Health check
[2022-04-18 08:54:04] [indexer:background:27] Health check
[2022-04-18 08:54:46] [index:background:27] Health check
[2022-04-18 08:59:13] [indexer:background:27] Health check
[2022-04-18 09:00:16] [index:background:27] Health check
[2022-04-18 09:03:32] [indexer:background:27] Health check
[2022-04-18 09:05:10] [index:background:27] Health check
[2022-04-18 09:09:07] [indexer:background:27] Health check
[2022-04-18 09:09:43] [index:background:27] Health check
[2022-04-18 09:13:48] [indexer:background:27] Health check
[2022-04-18 09:15:03] [index:background:27] Health check
[2022-04-18 09:18:41] [indexer:background:27] Health check
[2022-04-18 09:19:51] [index:background:27] Health check
[2022-04-18 09:24:37] [indexer:background:27] Health check
[2022-04-18 09:24:41] [index:background:27] Health check
[2022-04-18 09:28:42] [indexer:background:27] Health check
[2022-04-18 09:29:51] [index:background:27] Health check
[2022-04-18 09:33:42] [indexer:background:27] Health check
[2022-04-18 09:34:40] [index:background:27] Health check
[2022-04-18 09:36:30] [query:27] Query for: essential
[2022-04-18 09:36:30] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 09:36:30] [query:27] Engine: default
[2022-04-18 09:36:30] [query:27] Tokens: essential, essentially, essentials
[2022-04-18 09:36:30] [query:27] Mods: 2
[2022-04-18 09:36:30] [query:27] Using OR logic
[2022-04-18 09:36:30] [query:27] Found results using: and logic
[2022-04-18 09:36: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 (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-18 09:36:30] [query:27] Results: 47 Pages of results: 10
[2022-04-18 09:36:30] [query:27] Execution time: 0.21842
[2022-04-18 09:37:04] [index:27] Marking post.post 6196 to be dropped
[2022-04-18 09:37:07] [index:27] Dropping post.post 6196
[2022-04-18 09:37:07] [indexer:27] Queued next batch (1)
[2022-04-18 09:37:07] [indexer:27] Processing batch (1)
[2022-04-18 09:37:07] [indexer:27] Indexing post.post:6196
[2022-04-18 09:37:07] [index:27] Marking [27] post.post 6196 as indexed
[2022-04-18 09:37:07] [indexer:27] Index built
[2022-04-18 09:38:33] [indexer:background:27] Health check
[2022-04-18 09:39:43] [index:background:27] Health check
[2022-04-18 09:39:43] [query:27] Query for: christmas
[2022-04-18 09:39:43] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 09:39:43] [query:27] Engine: default
[2022-04-18 09:39:43] [query:27] Tokens: christmas
[2022-04-18 09:39:43] [query:27] Mods: 2
[2022-04-18 09:39:43] [query:27] Found results using: or logic
[2022-04-18 09:39:43] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (5520) 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-18 09:39:43] [query:27] Results: 13 Pages of results: 3
[2022-04-18 09:39:43] [query:27] Execution time: 0.06240
[2022-04-18 09:39:48] [query:27] Query for: christmas
[2022-04-18 09:39:48] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 2 offset: 0 fields: all
[2022-04-18 09:39:48] [query:27] Engine: default
[2022-04-18 09:39:48] [query:27] Tokens: christmas
[2022-04-18 09:39:48] [query:27] Mods: 2
[2022-04-18 09:39:48] [query:27] Found results using: or logic
[2022-04-18 09:39: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 ('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 (5520) 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 5, 5
[2022-04-18 09:39:48] [query:27] Results: 13 Pages of results: 3
[2022-04-18 09:39:48] [query:27] Execution time: 0.04680
[2022-04-18 09:40:56] [index:27] Marking post.post 6196 to be dropped
[2022-04-18 09:40:58] [index:27] Dropping post.post 6196
[2022-04-18 09:40:58] [indexer:27] Queued next batch (1)
[2022-04-18 09:40:58] [indexer:27] Processing batch (1)
[2022-04-18 09:40:58] [indexer:27] Indexing post.post:6196
[2022-04-18 09:40:58] [index:27] Marking [27] post.post 6196 as indexed
[2022-04-18 09:40:58] [indexer:27] Index built
[2022-04-18 09:43:44] [indexer:background:27] Health check
[2022-04-18 09:44:43] [index:background:27] Health check
[2022-04-18 09:46:53] [query:27] Query for: UK policy framework
[2022-04-18 09:46:53] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 09:46:53] [query:27] Engine: default
[2022-04-18 09:46:53] [query:27] Tokens: frameworks, policy, policies, policys, polici, framework
[2022-04-18 09:46:53] [query:27] Mods: 2
[2022-04-18 09:46:53] [query:27] Trying AND logic
[2022-04-18 09:46:53] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 09:46:53] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 09:46:53] [query:27] Found results using: and logic
[2022-04-18 09:46:53] [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 (15710,46,264,23873,37793,3326) 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 ('10184', '10356', '1897', '3310', '3395', '5332', '5363', '6365', '6747', '6818', '6918', '7068', '7296', '7375', '7389', '7446', '9675', '9901', '9909', '9977') 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-18 09:46:53] [query:27] Results: 20 Pages of results: 4
[2022-04-18 09:46:53] [query:27] Execution time: 0.17161
[2022-04-18 09:48:36] [indexer:background:27] Health check
[2022-04-18 09:49:06] [index:27] Marking post.post 6818 to be dropped
[2022-04-18 09:49:07] [index:27] Dropping post.post 6818
[2022-04-18 09:49:07] [indexer:27] Queued next batch (1)
[2022-04-18 09:49:07] [indexer:27] Processing batch (1)
[2022-04-18 09:49:07] [indexer:27] Indexing post.post:6818
[2022-04-18 09:49:07] [index:27] Marking [27] post.post 6818 as indexed
[2022-04-18 09:49:07] [indexer:27] Index built
[2022-04-18 09:50:01] [index:background:27] Health check
[2022-04-18 09:54:12] [indexer:background:27] Health check
[2022-04-18 09:55:13] [index:background:27] Health check
[2022-04-18 09:59:10] [indexer:background:27] Health check
[2022-04-18 09:59:42] [index:background:27] Health check
[2022-04-18 10:04:15] [indexer:background:27] Health check
[2022-04-18 10:04:49] [index:background:27] Health check
[2022-04-18 10:08:39] [indexer:background:27] Health check
[2022-04-18 10:10:09] [index:background:27] Health check
[2022-04-18 10:11:36] [query:27] Query for: module organisers
[2022-04-18 10:11:36] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 10:11:36] [query:27] Engine: default
[2022-04-18 10:11:36] [query:27] Tokens: module, organising, organised, organisational, organisers, organisations, organiser, organisation, organise, modules, organises, modul
[2022-04-18 10:11:36] [query:27] Mods: 2
[2022-04-18 10:11:36] [query:27] Trying AND logic
[2022-04-18 10:11:36] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:11:36] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:11:36] [query:27] Found results using: and logic
[2022-04-18 10:11:36] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (901,10557,6961,5509,3316,3058,2983,2388,1556,2273,24538,47463) 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 ('10356', '10396', '10406', '2219', '2234', '2430', '2431', '2692', '3286', '3310', '3402', '4578', '5141', '5363', '6094', '6147', '6191', '6227', '7187', '7227', '7296', '7375', '7389', '8416', '8423', '8632', '8638', '8652', '8701', '8704', '8705', '9009', '9083', '9148', '9160', '9184', '9185', '9198', '9349', '9350', '9505', '9506', '9507', '9669', '9707', '9859', '9873', '9901', '9914') 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-18 10:11:36] [query:27] Results: 49 Pages of results: 10
[2022-04-18 10:11:36] [query:27] Execution time: 0.09363
[2022-04-18 10:11:38] [query:27] Query for: module organisers
[2022-04-18 10:11:38] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 10:11:38] [query:27] Engine: default
[2022-04-18 10:11:38] [query:27] Tokens: module, organising, organised, organisational, organisers, organisations, organiser, organisation, organise, modules, organises, modul
[2022-04-18 10:11:38] [query:27] Mods: 2
[2022-04-18 10:11:38] [query:27] Trying AND logic
[2022-04-18 10:11:38] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:11:38] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:11:38] [query:27] Found results using: and logic
[2022-04-18 10:11:38] [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 (901,10557,6961,5509,3316,3058,2983,2388,1556,2273,24538,47463) 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 ('10356', '10396', '10406', '2219', '2234', '2430', '2431', '2692', '3286', '3310', '3402', '4578', '5141', '5363', '6094', '6147', '6191', '6227', '7187', '7227', '7296', '7375', '7389', '8416', '8423', '8632', '8638', '8652', '8701', '8704', '8705', '9009', '9083', '9148', '9160', '9184', '9185', '9198', '9349', '9350', '9505', '9506', '9507', '9669', '9707', '9859', '9873', '9901', '9914') 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-18 10:11:38] [query:27] Results: 49 Pages of results: 10
[2022-04-18 10:11:38] [query:27] Execution time: 0.07803
[2022-04-18 10:13:42] [indexer:background:27] Health check
[2022-04-18 10:13:42] [query:27] Query for: module organisers
[2022-04-18 10:13:42] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 2 offset: 0 fields: all
[2022-04-18 10:13:42] [query:27] Engine: default
[2022-04-18 10:13:42] [query:27] Tokens: module, organising, organised, organisational, organisers, organisations, organiser, organisation, organise, modules, organises, modul
[2022-04-18 10:13:42] [query:27] Mods: 2
[2022-04-18 10:13:42] [query:27] Trying AND logic
[2022-04-18 10:13:42] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:13:42] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:13:42] [query:27] Found results using: and logic
[2022-04-18 10:13:42] [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 (901,10557,6961,5509,3316,3058,2983,2388,1556,2273,24538,47463) 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 ('10356', '10396', '10406', '2219', '2234', '2430', '2431', '2692', '3286', '3310', '3402', '4578', '5141', '5363', '6094', '6147', '6191', '6227', '7187', '7227', '7296', '7375', '7389', '8416', '8423', '8632', '8638', '8652', '8701', '8704', '8705', '9009', '9083', '9148', '9160', '9184', '9185', '9198', '9349', '9350', '9505', '9506', '9507', '9669', '9707', '9859', '9873', '9901', '9914') 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-18 10:13:42] [query:27] Results: 49 Pages of results: 10
[2022-04-18 10:13:42] [query:27] Execution time: 0.09362
[2022-04-18 10:13:49] [query:27] Query for: module organisers
[2022-04-18 10:13:49] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 10:13:49] [query:27] Engine: default
[2022-04-18 10:13:49] [query:27] Tokens: module, organising, organised, organisational, organisers, organisations, organiser, organisation, organise, modules, organises, modul
[2022-04-18 10:13:49] [query:27] Mods: 2
[2022-04-18 10:13:49] [query:27] Trying AND logic
[2022-04-18 10:13:49] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:13:49] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:13:49] [query:27] Found results using: and logic
[2022-04-18 10:13: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 ('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 (901,10557,6961,5509,3316,3058,2983,2388,1556,2273,24538,47463) 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 ('10356', '10396', '10406', '2219', '2234', '2430', '2431', '2692', '3286', '3310', '3402', '4578', '5141', '5363', '6094', '6147', '6191', '6227', '7187', '7227', '7296', '7375', '7389', '8416', '8423', '8632', '8638', '8652', '8701', '8704', '8705', '9009', '9083', '9148', '9160', '9184', '9185', '9198', '9349', '9350', '9505', '9506', '9507', '9669', '9707', '9859', '9873', '9901', '9914') 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-18 10:13:49] [query:27] Results: 49 Pages of results: 10
[2022-04-18 10:13:49] [query:27] Execution time: 0.07801
[2022-04-18 10:14:58] [index:background:27] Health check
[2022-04-18 10:15:14] [query:27] Query for: email
[2022-04-18 10:15:14] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 10:15:14] [query:27] Engine: default
[2022-04-18 10:15:14] [query:27] Tokens: emailed, emailing, emails, email
[2022-04-18 10:15:14] [query:27] Mods: 2
[2022-04-18 10:15:14] [query:27] Using OR logic
[2022-04-18 10:15:14] [query:27] Found results using: and logic
[2022-04-18 10:15:14] [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 (900,1663,3096,739) 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-18 10:15:14] [query:27] Results: 138 Pages of results: 28
[2022-04-18 10:15:14] [query:27] Execution time: 0.04681
[2022-04-18 10:19:25] [indexer:background:27] Health check
[2022-04-18 10:20:19] [index:background:27] Health check
[2022-04-18 10:24:20] [indexer:background:27] Health check
[2022-04-18 10:25:10] [index:background:27] Health check
[2022-04-18 10:25:40] [query:27] Query for: essential
[2022-04-18 10:25:40] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 10:25:40] [query:27] Engine: default
[2022-04-18 10:25:40] [query:27] Tokens: essential, essentially, essentials
[2022-04-18 10:25:40] [query:27] Mods: 2
[2022-04-18 10:25:40] [query:27] Using OR logic
[2022-04-18 10:25:40] [query:27] Found results using: and logic
[2022-04-18 10:25:41] [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-18 10:25:41] [query:27] Results: 47 Pages of results: 10
[2022-04-18 10:25:41] [query:27] Execution time: 0.20282
[2022-04-18 10:25:51] [query:27] Query for: essential
[2022-04-18 10:25:51] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 2 offset: 0 fields: all
[2022-04-18 10:25:51] [query:27] Engine: default
[2022-04-18 10:25:51] [query:27] Tokens: essential, essentially, essentials
[2022-04-18 10:25:51] [query:27] Mods: 2
[2022-04-18 10:25:51] [query:27] Using OR logic
[2022-04-18 10:25:51] [query:27] Found results using: and logic
[2022-04-18 10:25:51] [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 5, 5
[2022-04-18 10:25:51] [query:27] Results: 47 Pages of results: 10
[2022-04-18 10:25:51] [query:27] Execution time: 0.14041
[2022-04-18 10:28:36] [indexer:background:27] Health check
[2022-04-18 10:30:37] [index:background:27] Health check
[2022-04-18 10:33:30] [query:27] Query for: covid 19
[2022-04-18 10:33:30] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 10:33:30] [query:27] Engine: default
[2022-04-18 10:33:30] [query:27] Tokens: covid, covid 19
[2022-04-18 10:33:30] [query:27] Mods: 2
[2022-04-18 10:33:30] [query:27] Trying AND logic
[2022-04-18 10:33:30] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:33:30] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 10:33:30] [query:27] Found results using: and logic
[2022-04-18 10:33: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 (498,4059) 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 ('10199', '8972', '8977', '8989', '8992', '8996', '9003', '9013', '9017', '9057', '9075', '9079', '9087', '9097', '9133', '9206', '9208', '9212', '9221', '9228', '9231', '9312', '9364', '9379', '9382', '9388', '9400') 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-18 10:33:30] [query:27] Results: 27 Pages of results: 6
[2022-04-18 10:33:30] [query:27] Execution time: 0.12481
[2022-04-18 10:33:32] [indexer:background:27] Health check
[2022-04-18 10:35:16] [index:background:27] Health check
[2022-04-18 10:38:51] [indexer:background:27] Health check
[2022-04-18 10:45:18] [index:background:27] Health check
[2022-04-18 10:45:18] [indexer:background:27] Health check
[2022-04-18 10:45:18] [indexer:background:27] Health check
[2022-04-18 10:48:37] [indexer:background:27] Health check
[2022-04-18 10:49:40] [index:background:27] Health check
[2022-04-18 10:54:55] [indexer:background:27] Health check
[2022-04-18 10:54:55] [index:background:27] Health check
[2022-04-18 10:56:34] [index:27] Marking post.post 3161 to be dropped
[2022-04-18 10:56:37] [index:27] Dropping post.post 3161
[2022-04-18 10:56:37] [indexer:27] Queued next batch (1)
[2022-04-18 10:56:37] [indexer:27] Processing batch (1)
[2022-04-18 10:56:37] [indexer:27] Indexing post.post:3161
[2022-04-18 10:56:37] [index:27] Marking [27] post.post 3161 as indexed
[2022-04-18 10:56:37] [indexer:27] Index built
[2022-04-18 10:58:46] [indexer:background:27] Health check
[2022-04-18 10:59:16] [index:27] Marking post.post 3161 to be dropped
[2022-04-18 10:59:18] [index:27] Dropping post.post 3161
[2022-04-18 10:59:18] [indexer:27] Queued next batch (1)
[2022-04-18 10:59:18] [indexer:27] Processing batch (1)
[2022-04-18 10:59:18] [indexer:27] Indexing post.post:3161
[2022-04-18 10:59:18] [index:27] Marking [27] post.post 3161 as indexed
[2022-04-18 10:59:18] [indexer:27] Index built
[2022-04-18 10:59:55] [index:background:27] Health check
[2022-04-18 11:03:29] [index:27] Marking post.post 9021 to be dropped
[2022-04-18 11:03:30] [index:27] Dropping post.post 9021
[2022-04-18 11:03:30] [indexer:27] Index built
[2022-04-18 11:03:31] [indexer:background:27] Health check
[2022-04-18 11:04:50] [index:background:27] Health check
[2022-04-18 11:04:56] [index:27] Marking post.post 9133 to be dropped
[2022-04-18 11:04:58] [index:27] Dropping post.post 9133
[2022-04-18 11:04:58] [indexer:27] Queued next batch (1)
[2022-04-18 11:04:59] [indexer:27] Processing batch (1)
[2022-04-18 11:04:59] [indexer:27] Indexing post.post:9133
[2022-04-18 11:04:59] [index:27] Marking [27] post.post 9133 as indexed
[2022-04-18 11:04:59] [indexer:27] Index built
[2022-04-18 11:08:06] [index:27] Marking post.post 8972 to be dropped
[2022-04-18 11:08:08] [index:27] Dropping post.post 8972
[2022-04-18 11:08:08] [indexer:27] Queued next batch (1)
[2022-04-18 11:08:08] [indexer:27] Processing batch (1)
[2022-04-18 11:08:08] [indexer:27] Indexing post.post:8972
[2022-04-18 11:08:08] [index:27] Marking [27] post.post 8972 as indexed
[2022-04-18 11:08:08] [indexer:27] Index built
[2022-04-18 11:08:32] [indexer:background:27] Health check
[2022-04-18 11:09:47] [index:background:27] Health check
[2022-04-18 11:13:47] [indexer:background:27] Health check
[2022-04-18 11:15:12] [index:background:27] Health check
[2022-04-18 11:19:10] [indexer:background:27] Health check
[2022-04-18 11:19:47] [index:background:27] Health check
[2022-04-18 11:23:47] [indexer:background:27] Health check
[2022-04-18 11:25:17] [index:background:27] Health check
[2022-04-18 11:29:11] [indexer:background:27] Health check
[2022-04-18 11:29:41] [index:background:27] Health check
[2022-04-18 11:32:42] [query:27] Query for: GMC
[2022-04-18 11:32:42] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 11:32:42] [query:27] Engine: default
[2022-04-18 11:32:42] [query:27] Tokens: gmc's, gmc
[2022-04-18 11:32:42] [query:27] Mods: 2
[2022-04-18 11:32:42] [query:27] Using OR logic
[2022-04-18 11:32:42] [query:27] Found results using: and logic
[2022-04-18 11:32:42] [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 (532,274) 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-18 11:32:42] [query:27] Results: 51 Pages of results: 11
[2022-04-18 11:32:42] [query:27] Execution time: 0.07801
[2022-04-18 11:34:13] [indexer:background:27] Health check
[2022-04-18 11:34:44] [index:background:27] Health check
[2022-04-18 11:34:45] [index:27] Marking post.post 4094 to be dropped
[2022-04-18 11:34:46] [index:background:27] Health check
[2022-04-18 11:34:46] [index:27] Dropping post.post 4094
[2022-04-18 11:34:46] [indexer:27] Queued next batch (1)
[2022-04-18 11:34:46] [indexer:27] Processing batch (1)
[2022-04-18 11:34:46] [indexer:27] Indexing post.post:4094
[2022-04-18 11:34:46] [index:27] Marking [27] post.post 4094 as indexed
[2022-04-18 11:34:46] [indexer:27] Index built
[2022-04-18 11:34:46] [indexer:27] Index built
[2022-04-18 11:35:41] [index:27] Marking post.post 4094 to be dropped
[2022-04-18 11:35:43] [index:27] Dropping post.post 4094
[2022-04-18 11:35:43] [indexer:27] Queued next batch (1)
[2022-04-18 11:35:43] [indexer:27] Processing batch (1)
[2022-04-18 11:35:43] [indexer:27] Indexing post.post:4094
[2022-04-18 11:35:43] [index:27] Marking [27] post.post 4094 as indexed
[2022-04-18 11:35:43] [indexer:27] Index built
[2022-04-18 11:37:55] [index:27] Marking post.post 4094 to be dropped
[2022-04-18 11:37:57] [index:27] Dropping post.post 4094
[2022-04-18 11:37:57] [indexer:27] Queued next batch (1)
[2022-04-18 11:37:57] [indexer:27] Processing batch (1)
[2022-04-18 11:37:57] [indexer:27] Indexing post.post:4094
[2022-04-18 11:37:57] [index:27] Marking [27] post.post 4094 as indexed
[2022-04-18 11:37:57] [indexer:27] Index built
[2022-04-18 11:38:35] [indexer:background:27] Health check
[2022-04-18 11:38:35] [query:27] Query for: GMC
[2022-04-18 11:38:35] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 11:38:35] [query:27] Engine: default
[2022-04-18 11:38:35] [query:27] Tokens: gmc's, gmc
[2022-04-18 11:38:35] [query:27] Mods: 2
[2022-04-18 11:38:35] [query:27] Using OR logic
[2022-04-18 11:38:35] [query:27] Found results using: and logic
[2022-04-18 11:38:35] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (532,274) 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-18 11:38:35] [query:27] Results: 51 Pages of results: 11
[2022-04-18 11:38:35] [query:27] Execution time: 0.04680
[2022-04-18 11:39:23] [query:27] Query for: student support
[2022-04-18 11:39:23] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 11:39:23] [query:27] Engine: default
[2022-04-18 11:39:23] [query:27] Tokens: students, supporter, supported, supports, supportive, supporting, student's, supporters, student, support
[2022-04-18 11:39:23] [query:27] Mods: 2
[2022-04-18 11:39:23] [query:27] Trying AND logic
[2022-04-18 11:39:23] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 11:39:23] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 11:39:23] [query:27] Found results using: and logic
[2022-04-18 11:39:23] [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 (145,25871,3401,2284,1119,386,398,26080,261,266) 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 ( SELECT id FROM ( SELECT id FROM med_searchwp_index s WHERE s.site IN(27) AND 1=1 AND token IN (145, 261, 398) AND id IN ( SELECT id FROM med_searchwp_index s WHERE s.site IN(27) AND 1=1 AND token IN (266, 386, 1119, 2284, 3401, 25871, 26080) GROUP BY id) GROUP BY id) AS a) 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-18 11:39:23] [query:27] Results: 169 Pages of results: 34
[2022-04-18 11:39:23] [query:27] Execution time: 0.04680
[2022-04-18 11:40:20] [index:background:27] Health check
[2022-04-18 11:43:44] [indexer:background:27] Health check
[2022-04-18 11:44:41] [index:background:27] Health check
[2022-04-18 11:49:19] [indexer:background:27] Health check
[2022-04-18 11:50:21] [index:background:27] Health check
[2022-04-18 11:51:34] [index:27] Marking post.post 1821 to be dropped
[2022-04-18 11:51:36] [index:27] Dropping post.post 1821
[2022-04-18 11:51:36] [indexer:27] Queued next batch (1)
[2022-04-18 11:51:37] [indexer:27] Processing batch (1)
[2022-04-18 11:51:37] [indexer:27] Indexing post.post:1821
[2022-04-18 11:51:37] [index:27] Marking [27] post.post 1821 as indexed
[2022-04-18 11:51:37] [indexer:27] Index built
[2022-04-18 11:53:06] [index:27] Marking post.post 1821 to be dropped
[2022-04-18 11:53:07] [index:27] Dropping post.post 1821
[2022-04-18 11:53:07] [indexer:27] Queued next batch (1)
[2022-04-18 11:53:07] [indexer:27] Processing batch (1)
[2022-04-18 11:53:07] [indexer:27] Indexing post.post:1821
[2022-04-18 11:53:07] [index:27] Marking [27] post.post 1821 as indexed
[2022-04-18 11:53:07] [indexer:27] Index built
[2022-04-18 11:53:39] [indexer:background:27] Health check
[2022-04-18 11:54:44] [index:background:27] Health check
[2022-04-18 11:58:39] [indexer:background:27] Health check
[2022-04-18 11:59:54] [index:background:27] Health check
[2022-04-18 12:03:40] [indexer:background:27] Health check
[2022-04-18 12:04:55] [index:background:27] Health check
[2022-04-18 12:08:40] [indexer:background:27] Health check
[2022-04-18 12:09:55] [index:background:27] Health check
[2022-04-18 12:13:40] [indexer:background:27] Health check
[2022-04-18 12:14:40] [index:background:27] Health check
[2022-04-18 12:18:40] [indexer:background:27] Health check
[2022-04-18 12:19:40] [index:background:27] Health check
[2022-04-18 12:24:48] [indexer:background:27] Health check
[2022-04-18 12:24:48] [index:background:27] Health check
[2022-04-18 12:29:09] [indexer:background:27] Health check
[2022-04-18 12:31:25] [index:background:27] Health check
[2022-04-18 12:33:31] [indexer:background:27] Health check
[2022-04-18 12:34:45] [index:background:27] Health check
[2022-04-18 12:38:53] [indexer:background:27] Health check
[2022-04-18 12:40:02] [index:background:27] Health check
[2022-04-18 12:44:02] [indexer:background:27] Health check
[2022-04-18 12:45:14] [index:background:27] Health check
[2022-04-18 12:48:40] [indexer:background:27] Health check
[2022-04-18 12:51:25] [index:background:27] Health check
[2022-04-18 12:55:02] [indexer:background:27] Health check
[2022-04-18 12:55:02] [index:background:27] Health check
[2022-04-18 12:58:40] [indexer:background:27] Health check
[2022-04-18 13:00:24] [index:background:27] Health check
[2022-04-18 13:05:17] [indexer:background:27] Health check
[2022-04-18 13:05:17] [index:background:27] Health check
[2022-04-18 13:08:39] [indexer:background:27] Health check
[2022-04-18 13:09:45] [index:background:27] Health check
[2022-04-18 13:13:33] [indexer:background:27] Health check
[2022-04-18 13:14:53] [index:background:27] Health check
[2022-04-18 13:16:36] [index:27] Marking post.post 1821 to be dropped
[2022-04-18 13:16:38] [index:27] Dropping post.post 1821
[2022-04-18 13:16:38] [indexer:27] Queued next batch (1)
[2022-04-18 13:16:39] [indexer:27] Processing batch (1)
[2022-04-18 13:16:39] [indexer:27] Indexing post.post:1821
[2022-04-18 13:16:39] [index:27] Marking [27] post.post 1821 as indexed
[2022-04-18 13:16:39] [indexer:27] Index built
[2022-04-18 13:18:31] [indexer:background:27] Health check
[2022-04-18 13:19:50] [index:background:27] Health check
[2022-04-18 13:21:26] [index:27] Marking post.post 1718 to be dropped
[2022-04-18 13:21:28] [index:27] Dropping post.post 1718
[2022-04-18 13:21:28] [indexer:27] Queued next batch (1)
[2022-04-18 13:21:28] [indexer:27] Processing batch (1)
[2022-04-18 13:21:28] [indexer:27] Indexing post.post:1718
[2022-04-18 13:21:28] [index:27] Marking [27] post.post 1718 as indexed
[2022-04-18 13:21:28] [indexer:27] Index built
[2022-04-18 13:23:33] [indexer:background:27] Health check
[2022-04-18 13:25:06] [index:background:27] Health check
[2022-04-18 13:28:47] [indexer:background:27] Health check
[2022-04-18 13:29:50] [index:background:27] Health check
[2022-04-18 13:31:42] [query:27] Query for: email list
[2022-04-18 13:31:42] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 13:31:42] [query:27] Engine: default
[2022-04-18 13:31:42] [query:27] Tokens: emailed, emailing, emails, listed, lists, listing, liste, email, list
[2022-04-18 13:31:42] [query:27] Mods: 2
[2022-04-18 13:31:42] [query:27] Trying AND logic
[2022-04-18 13:31:42] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 13:31:42] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 13:31:42] [query:27] Found results using: and logic
[2022-04-18 13:31:42] [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 (900,1663,3096,538,1077,10314,29233,739,322) 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 ('10020', '10067', '10069', '10089', '10184', '10356', '1897', '2161', '2185', '2224', '2234', '2692', '2764', '2950', '3310', '3402', '3647', '3724', '3767', '4435', '4578', '4610', '4711', '4806', '4845', '5332', '5363', '6094', '6097', '6191', '6219', '6227', '6747', '7162', '7212', '7223', '7296', '7327', '7343', '7446', '7466', '7609', '8416', '8423', '8635', '8652', '8686', '8966', '8977', '8989', '8996', '9006', '9083', '9093', '9145', '9212', '9228', '9231', '9291', '9312', '9340', '9353', '9374', '9453', '9691', '9914', '9922', '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-18 13:31:42] [query:27] Results: 67 Pages of results: 14
[2022-04-18 13:31:42] [query:27] Execution time: 0.09361
[2022-04-18 13:33:45] [indexer:background:27] Health check
[2022-04-18 13:34:50] [index:background:27] Health check
[2022-04-18 13:38:41] [indexer:background:27] Health check
[2022-04-18 13:40:04] [index:background:27] Health check
[2022-04-18 13:43:36] [indexer:background:27] Health check
[2022-04-18 13:44:44] [index:background:27] Health check
[2022-04-18 13:48:45] [indexer:background:27] Health check
[2022-04-18 13:49:46] [index:background:27] Health check
[2022-04-18 13:53:41] [indexer:background:27] Health check
[2022-04-18 13:54:47] [index:background:27] Health check
[2022-04-18 13:59:28] [indexer:background:27] Health check
[2022-04-18 13:59:40] [index:background:27] Health check
[2022-04-18 14:03:46] [indexer:background:27] Health check
[2022-04-18 14:04:42] [index:background:27] Health check
[2022-04-18 14:06:07] [query:27] Query for: library
[2022-04-18 14:06:07] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 14:06:07] [query:27] Engine: default
[2022-04-18 14:06:07] [query:27] Tokens: library, libraries, librarys
[2022-04-18 14:06:07] [query:27] Mods: 2
[2022-04-18 14:06:07] [query:27] Using OR logic
[2022-04-18 14:06:07] [query:27] Found results using: and logic
[2022-04-18 14:06:07] [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 (1232,2057,26742) 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-18 14:06:07] [query:27] Results: 47 Pages of results: 10
[2022-04-18 14:06:07] [query:27] Execution time: 0.12481
[2022-04-18 14:09:00] [indexer:background:27] Health check
[2022-04-18 14:09:46] [index:background:27] Health check
[2022-04-18 14:10:05] [query:27] Query for: ethics
[2022-04-18 14:10:05] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 7 page: 1 offset: 0 fields: ids
[2022-04-18 14:10:05] [query:27] Engine: default
[2022-04-18 14:10:05] [query:27] Tokens: ethics, ethical, ethically, ethic
[2022-04-18 14:10:05] [query:27] Mods: 2
[2022-04-18 14:10:05] [query:27] Using OR logic
[2022-04-18 14:10:05] [query:27] Found results using: and logic
[2022-04-18 14:10:05] [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 (2373,10221,24229,18380) 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, 7
[2022-04-18 14:10:05] [query:27] Results: 49 Pages of results: 7
[2022-04-18 14:10:05] [query:27] Execution time: 0.01560
[2022-04-18 14:10:16] [query:27] Query for: ethics
[2022-04-18 14:10:16] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 7 page: 1 offset: 0 fields: ids
[2022-04-18 14:10:16] [query:27] Engine: default
[2022-04-18 14:10:16] [query:27] Tokens: ethics, ethical, ethically, ethic
[2022-04-18 14:10:16] [query:27] Mods: 2
[2022-04-18 14:10:16] [query:27] Using OR logic
[2022-04-18 14:10:16] [query:27] Found results using: and logic
[2022-04-18 14:10: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 ('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 (2373,10221,24229,18380) 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, 7
[2022-04-18 14:10:16] [query:27] Results: 49 Pages of results: 7
[2022-04-18 14:10:16] [query:27] Execution time: 0.01560
[2022-04-18 14:10:20] [query:27] Query for: ethics
[2022-04-18 14:10:20] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 14:10:20] [query:27] Engine: default
[2022-04-18 14:10:20] [query:27] Tokens: ethics, ethical, ethically, ethic
[2022-04-18 14:10:20] [query:27] Mods: 2
[2022-04-18 14:10:20] [query:27] Using OR logic
[2022-04-18 14:10:20] [query:27] Found results using: and logic
[2022-04-18 14:10: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 ('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 (2373,10221,24229,18380) 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-18 14:10:20] [query:27] Results: 49 Pages of results: 10
[2022-04-18 14:10:20] [query:27] Execution time: 0.06241
[2022-04-18 14:10:51] [query:27] Query for: absence
[2022-04-18 14:10:51] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 14:10:51] [query:27] Engine: default
[2022-04-18 14:10:51] [query:27] Tokens: absences, absence
[2022-04-18 14:10:51] [query:27] Mods: 2
[2022-04-18 14:10:51] [query:27] Using OR logic
[2022-04-18 14:10:51] [query:27] Found results using: and logic
[2022-04-18 14:10:51] [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 (1853,3518) 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-18 14:10:51] [query:27] Results: 66 Pages of results: 14
[2022-04-18 14:10:51] [query:27] Execution time: 0.06241
[2022-04-18 14:13:46] [indexer:background:27] Health check
[2022-04-18 14:14:51] [index:background:27] Health check
[2022-04-18 14:17:14] [query:27] Query for: studnet support
[2022-04-18 14:17:14] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 14:17:14] [query:27] Engine: default
[2022-04-18 14:17:15] [query:27] Tokens: students, supporter, supported, supports, supportive, supporting, student's, supporters, student, support
[2022-04-18 14:17:15] [query:27] Mods: 2
[2022-04-18 14:17:15] [query:27] Using OR logic
[2022-04-18 14:17:15] [query:27] Found results using: and logic
[2022-04-18 14:17:15] [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 (145,25871,3401,2284,1119,386,398,26080,261,266) 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-18 14:17:15] [query:27] Results: 423 Pages of results: 85
[2022-04-18 14:17:15] [query:27] Execution time: 0.32763
[2022-04-18 14:17:15] [core:27] Render suggested search: student support
[2022-04-18 14:19:21] [indexer:background:27] Health check
[2022-04-18 14:20:27] [index:background:27] Health check
[2022-04-18 14:24:24] [indexer:background:27] Health check
[2022-04-18 14:24:24] [query:27] Query for: mitigating circumstances
[2022-04-18 14:24:24] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 14:24:24] [query:27] Engine: default
[2022-04-18 14:24:24] [query:27] Tokens: circumstances, circumstance, mitigating, mitigation, mitigate, mitigations, mitigated, mitig, circumst
[2022-04-18 14:24:24] [query:27] Mods: 2
[2022-04-18 14:24:24] [query:27] Trying AND logic
[2022-04-18 14:24:24] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 14:24:24] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 14:24:24] [query:27] Found results using: and logic
[2022-04-18 14:24:24] [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 (438,9934,15390,18046,21927,32829,43969,30132,50433) 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 ('3767', '4959', '5363', '6219', '7196', '8635', '9008', '9009', '9083', '9372') 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-18 14:24:24] [query:27] Results: 10 Pages of results: 2
[2022-04-18 14:24:24] [query:27] Execution time: 0.10921
[2022-04-18 14:25:15] [index:background:27] Health check
[2022-04-18 14:29:09] [indexer:background:27] Health check
[2022-04-18 14:30:45] [index:background:27] Health check
[2022-04-18 14:33:48] [indexer:background:27] Health check
[2022-04-18 14:35:44] [index:background:27] Health check
[2022-04-18 14:38:53] [indexer:background:27] Health check
[2022-04-18 14:40:10] [index:background:27] Health check
[2022-04-18 14:41:00] [query:27] Query for: student support
[2022-04-18 14:41:00] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 14:41:00] [query:27] Engine: default
[2022-04-18 14:41:00] [query:27] Tokens: students, supporter, supported, supports, supportive, supporting, student's, supporters, student, support
[2022-04-18 14:41:00] [query:27] Mods: 2
[2022-04-18 14:41:00] [query:27] Trying AND logic
[2022-04-18 14:41:00] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 14:41:00] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 14:41:00] [query:27] Found results using: and logic
[2022-04-18 14:41:00] [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 (145,25871,3401,2284,1119,386,398,26080,261,266) 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 ( SELECT id FROM ( SELECT id FROM med_searchwp_index s WHERE s.site IN(27) AND 1=1 AND token IN (145, 261, 398) AND id IN ( SELECT id FROM med_searchwp_index s WHERE s.site IN(27) AND 1=1 AND token IN (266, 386, 1119, 2284, 3401, 25871, 26080) GROUP BY id) GROUP BY id) AS a) 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-18 14:41:00] [query:27] Results: 169 Pages of results: 34
[2022-04-18 14:41:00] [query:27] Execution time: 0.06241
[2022-04-18 14:43:42] [indexer:background:27] Health check
[2022-04-18 14:44:41] [index:background:27] Health check
[2022-04-18 14:45:17] [index:27] Marking post.post 6196 to be dropped
[2022-04-18 14:45:19] [index:27] Dropping post.post 6196
[2022-04-18 14:45:19] [indexer:27] Queued next batch (1)
[2022-04-18 14:45:19] [indexer:27] Processing batch (1)
[2022-04-18 14:45:19] [indexer:27] Indexing post.post:6196
[2022-04-18 14:45:19] [index:27] Marking [27] post.post 6196 as indexed
[2022-04-18 14:45:19] [indexer:27] Index built
[2022-04-18 14:48:53] [indexer:background:27] Health check
[2022-04-18 14:49:42] [index:background:27] Health check
[2022-04-18 14:54:07] [indexer:background:27] Health check
[2022-04-18 14:54:48] [index:background:27] Health check
[2022-04-18 14:56:23] [index:27] Marking post.post 2279 to be dropped
[2022-04-18 14:56:25] [index:27] Dropping post.post 2279
[2022-04-18 14:56:25] [indexer:27] Queued next batch (1)
[2022-04-18 14:56:25] [indexer:27] Processing batch (1)
[2022-04-18 14:56:25] [indexer:27] Indexing post.post:2279
[2022-04-18 14:56:25] [index:27] Marking [27] post.post 2279 as indexed
[2022-04-18 14:56:25] [indexer:27] Index built
[2022-04-18 14:59:58] [indexer:background:27] Health check
[2022-04-18 14:59:58] [index:background:27] Health check
[2022-04-18 15:03:07] [index:27] Marking post.post 2279 to be dropped
[2022-04-18 15:03:09] [index:27] Dropping post.post 2279
[2022-04-18 15:03:09] [indexer:27] Queued next batch (1)
[2022-04-18 15:03:09] [indexer:27] Processing batch (1)
[2022-04-18 15:03:09] [indexer:27] Indexing post.post:2279
[2022-04-18 15:03:09] [index:27] Marking [27] post.post 2279 as indexed
[2022-04-18 15:03:09] [indexer:27] Index built
[2022-04-18 15:03:36] [indexer:background:27] Health check
[2022-04-18 15:04:42] [index:background:27] Health check
[2022-04-18 15:08:36] [indexer:background:27] Health check
[2022-04-18 15:09:59] [index:background:27] Health check
[2022-04-18 15:13:14] [index:27] Marking post.post 2279 to be dropped
[2022-04-18 15:13:16] [index:27] Dropping post.post 2279
[2022-04-18 15:13:16] [indexer:27] Queued next batch (1)
[2022-04-18 15:13:16] [indexer:27] Processing batch (1)
[2022-04-18 15:13:16] [indexer:27] Indexing post.post:2279
[2022-04-18 15:13:16] [index:27] Marking [27] post.post 2279 as indexed
[2022-04-18 15:13:16] [indexer:27] Index built
[2022-04-18 15:13:35] [indexer:background:27] Health check
[2022-04-18 15:15:50] [index:background:27] Health check
[2022-04-18 15:18:36] [indexer:background:27] Health check
[2022-04-18 15:19:59] [index:background:27] Health check
[2022-04-18 15:23:34] [indexer:background:27] Health check
[2022-04-18 15:24:26] [index:27] Marking post.post 1912 to be dropped
[2022-04-18 15:24:27] [index:27] Dropping post.post 1912
[2022-04-18 15:24:27] [indexer:27] Queued next batch (1)
[2022-04-18 15:24:27] [indexer:27] Processing batch (1)
[2022-04-18 15:24:27] [indexer:27] Indexing post.post:1912
[2022-04-18 15:24:27] [index:27] Marking [27] post.post 1912 as indexed
[2022-04-18 15:24:27] [indexer:27] Index built
[2022-04-18 15:24:44] [index:background:27] Health check
[2022-04-18 15:24:44] [index:27] Marking post.post 1912 to be dropped
[2022-04-18 15:24:45] [index:background:27] Health check
[2022-04-18 15:24:45] [index:27] Dropping post.post 1912
[2022-04-18 15:24:45] [indexer:27] Queued next batch (1)
[2022-04-18 15:24:46] [indexer:27] Processing batch (1)
[2022-04-18 15:24:46] [indexer:27] Indexing post.post:1912
[2022-04-18 15:24:46] [index:27] Marking [27] post.post 1912 as indexed
[2022-04-18 15:24:46] [indexer:27] Index built
[2022-04-18 15:24:46] [indexer:27] Index built
[2022-04-18 15:28:41] [indexer:background:27] Health check
[2022-04-18 15:32:20] [index:background:27] Health check
[2022-04-18 15:34:25] [indexer:background:27] Health check
[2022-04-18 15:34:41] [index:background:27] Health check
[2022-04-18 15:38:41] [indexer:background:27] Health check
[2022-04-18 15:39:49] [index:background:27] Health check
[2022-04-18 15:43:34] [indexer:background:27] Health check
[2022-04-18 15:45:14] [index:background:27] Health check
[2022-04-18 15:46:51] [query:27] Query for: statement of commitment
[2022-04-18 15:46:51] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-04-18 15:46:51] [query:27] Engine: default
[2022-04-18 15:46:51] [query:27] Tokens: committed, commitment, committing, commitments, commits, statements, statement, commit
[2022-04-18 15:46:51] [query:27] Mods: 2
[2022-04-18 15:46:51] [query:27] Trying AND logic
[2022-04-18 15:46:51] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 15:46:51] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-04-18 15:46:51] [query:27] Found results using: and logic
[2022-04-18 15:46:51] [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 (1968,3649,25852,26155,31927,1310,1245,3410) 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 ('2234', '3356', '3402', '3767', '4578', '4845', '4988', '5332', '6219', '6336', '6339', '6739', '7389', '8617', '9057', '9291', '9429', '9922', '9971') 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-18 15:46:51] [query:27] Results: 19 Pages of results: 4
[2022-04-18 15:46:51] [query:27] Execution time: 0.15601
[2022-04-18 15:48:47] [indexer:background:27] Health check
[2022-04-18 15:49:45] [index:background:27] Health check
[2022-04-18 15:53:52] [indexer:background:27] Health check
[2022-04-18 15:54:59] [index:background:27] Health check
[2022-04-18 15:58:53] [indexer:background:27] Health check
[2022-04-18 16:00:26] [index:background:27] Health check
[2022-04-18 16:03:33] [indexer:background:27] Health check
[2022-04-18 16:05:23] [index:background:27] Health check
[2022-04-18 16:09:02] [indexer:background:27] Health check
[2022-04-18 16:09:44] [index:background:27] Health check
[2022-04-18 16:15:16] [indexer:background:27] Health check
[2022-04-18 16:15:16] [index:background:27] Health check
[2022-04-18 16:18:42] [indexer:background:27] Health check
[2022-04-18 16:20:02] [index:background:27] Health check
[2022-04-18 16:24:04] [indexer:background:27] Health check
[2022-04-18 16:26:51] [index:background:27] Health check
[2022-04-18 16:30:08] [indexer:background:27] Health check
[2022-04-18 16:30:08] [index:background:27] Health check
[2022-04-18 16:34:28] [indexer:background:27] Health check
[2022-04-18 16:35:10] [index:background:27] Health check
[2022-04-18 16:38:38] [indexer:background:27] Health check
[2022-04-18 16:40:18] [index:background:27] Health check
[2022-04-18 16:43:43] [indexer:background:27] Health check
[2022-04-18 16:44:52] [index:background:27] Health check
[2022-04-18 16:49:21] [indexer:background:27] Health check
[2022-04-18 16:50:21] [index:background:27] Health check
[2022-04-18 16:53:51] [indexer:background:27] Health check
[2022-04-18 16:55:25] [index:background:27] Health check
[2022-04-18 16:58:43] [indexer:background:27] Health check
[2022-04-18 17:00:00] [index:background:27] Health check
[2022-04-18 17:03:44] [indexer:background:27] Health check
[2022-04-18 17:05:03] [index:background:27] Health check
[2022-04-18 17:08:32] [indexer:background:27] Health check
[2022-04-18 17:10:35] [index:background:27] Health check
[2022-04-18 17:13:34] [indexer:background:27] Health check
[2022-04-18 17:15:02] [index:background:27] Health check
[2022-04-18 17:18:31] [indexer:background:27] Health check
[2022-04-18 17:19:56] [index:background:27] Health check
[2022-04-18 17:24:09] [indexer:background:27] Health check
[2022-04-18 17:24:54] [index:background:27] Health check
[2022-04-18 17:29:39] [indexer:background:27] Health check
[2022-04-18 17:29:59] [index:background:27] Health check
[2022-04-18 17:34:52] [indexer:background:27] Health check
[2022-04-18 17:34:53] [index:background:27] Health check
[2022-04-18 17:39:56] [indexer:background:27] Health check
[2022-04-18 17:39:56] [index:background:27] Health check
[2022-04-18 17:43:33] [indexer:background:27] Health check
[2022-04-18 17:45:21] [index:background:27] Health check
[2022-04-18 17:50:52] [indexer:background:27] Health check
[2022-04-18 17:50:52] [index:background:27] Health check
[2022-04-18 17:53:47] [indexer:background:27] Health check
[2022-04-18 17:56:12] [index:background:27] Health check
[2022-04-18 17:59:23] [indexer:background:27] Health check
[2022-04-18 17:59:59] [index:background:27] Health check
[2022-04-18 18:03:45] [indexer:background:27] Health check
[2022-04-18 18:04:43] [index:background:27] Health check
[2022-04-18 18:08:42] [indexer:background:27] Health check
[2022-04-18 18:09:52] [index:background:27] Health check
[2022-04-18 18:14:16] [indexer:background:27] Health check
[2022-04-18 18:15:25] [index:background:27] Health check
[2022-04-18 18:18:47] [indexer:background:27] Health check
[2022-04-18 18:19:49] [index:background:27] Health check
[2022-04-18 18:23:44] [indexer:background:27] Health check
[2022-04-18 18:24:53] [index:background:27] Health check
[2022-04-18 18:28:36] [indexer:background:27] Health check
[2022-04-18 18:29:55] [index:background:27] Health check
[2022-04-18 18:34:13] [indexer:background:27] Health check
[2022-04-18 18:35:21] [index:background:27] Health check
[2022-04-18 18:38:31] [indexer:background:27] Health check
[2022-04-18 18:39:58] [index:background:27] Health check
[2022-04-18 18:43:34] [indexer:background:27] Health check
[2022-04-18 18:44:48] [index:background:27] Health check
[2022-04-18 18:48:36] [indexer:background:27] Health check
[2022-04-18 18:49:44] [index:background:27] Health check
[2022-04-18 18:54:26] [indexer:background:27] Health check
[2022-04-18 18:55:18] [index:background:27] Health check
[2022-04-18 18:59:29] [indexer:background:27] Health check
[2022-04-18 18:59:40] [index:background:27] Health check
[2022-04-18 19:05:08] [indexer:background:27] Health check
[2022-04-18 19:05:08] [index:background:27] Health check
[2022-04-18 19:08:55] [indexer:background:27] Health check
[2022-04-18 19:10:04] [index:background:27] Health check
[2022-04-18 19:13:43] [indexer:background:27] Health check
[2022-04-18 19:14:40] [index:background:27] Health check
[2022-04-18 19:18:59] [indexer:background:27] Health check
[2022-04-18 19:20:37] [index:background:27] Health check
[2022-04-18 19:23:42] [indexer:background:27] Health check
[2022-04-18 19:25:56] [index:background:27] Health check
[2022-04-18 19:28:36] [indexer:background:27] Health check
[2022-04-18 19:31:21] [index:background:27] Health check
[2022-04-18 19:34:15] [indexer:background:27] Health check
[2022-04-18 19:36:21] [index:background:27] Health check
[2022-04-18 19:40:12] [indexer:background:27] Health check
[2022-04-18 19:40:12] [index:background:27] Health check
[2022-04-18 19:45:32] [indexer:background:27] Health check
[2022-04-18 19:45:32] [index:background:27] Health check
[2022-04-18 19:48:43] [indexer:background:27] Health check
[2022-04-18 19:51:39] [index:background:27] Health check
[2022-04-18 19:53:39] [indexer:background:27] Health check
[2022-04-18 19:55:28] [index:background:27] Health check
[2022-04-18 19:59:12] [indexer:background:27] Health check
[2022-04-18 20:01:21] [index:background:27] Health check
[2022-04-18 20:03:32] [indexer:background:27] Health check
[2022-04-18 20:05:52] [index:background:27] Health check
[2022-04-18 20:08:37] [indexer:background:27] Health check
[2022-04-18 20:09:55] [index:background:27] Health check
[2022-04-18 20:13:58] [indexer:background:27] Health check
[2022-04-18 20:16:22] [index:background:27] Health check
[2022-04-18 20:18:44] [indexer:background:27] Health check
[2022-04-18 20:20:04] [index:background:27] Health check
[2022-04-18 20:23:36] [indexer:background:27] Health check
[2022-04-18 20:24:55] [index:background:27] Health check
[2022-04-18 20:28:51] [indexer:background:27] Health check
[2022-04-18 20:30:21] [index:background:27] Health check
[2022-04-18 20:33:48] [indexer:background:27] Health check
[2022-04-18 20:34:44] [index:background:27] Health check
[2022-04-18 20:38:32] [indexer:background:27] Health check
[2022-04-18 20:39:53] [index:background:27] Health check
[2022-04-18 20:43:45] [indexer:background:27] Health check
[2022-04-18 20:45:11] [index:background:27] Health check
[2022-04-18 20:49:13] [indexer:background:27] Health check
[2022-04-18 20:50:07] [index:background:27] Health check
[2022-04-18 20:53:57] [indexer:background:27] Health check
[2022-04-18 20:54:51] [index:background:27] Health check
[2022-04-18 20:59:23] [indexer:background:27] Health check
[2022-04-18 21:00:00] [index:background:27] Health check
[2022-04-18 21:03:32] [indexer:background:27] Health check
[2022-04-18 21:04:43] [index:background:27] Health check
[2022-04-18 21:09:37] [indexer:background:27] Health check
[2022-04-18 21:10:12] [index:background:27] Health check
[2022-04-18 21:14:26] [indexer:background:27] Health check
[2022-04-18 21:15:09] [index:background:27] Health check
[2022-04-18 21:20:39] [indexer:background:27] Health check
[2022-04-18 21:20:39] [index:background:27] Health check
[2022-04-18 21:25:36] [indexer:background:27] Health check
[2022-04-18 21:25:36] [index:background:27] Health check
[2022-04-18 21:31:08] [indexer:background:27] Health check
[2022-04-18 21:31:08] [index:background:27] Health check
[2022-04-18 21:33:53] [indexer:background:27] Health check
[2022-04-18 21:34:40] [index:background:27] Health check
[2022-04-18 21:38:31] [indexer:background:27] Health check
[2022-04-18 21:39:41] [index:background:27] Health check
[2022-04-18 21:43:31] [indexer:background:27] Health check
[2022-04-18 21:44:40] [index:background:27] Health check
[2022-04-18 21:48:31] [indexer:background:27] Health check
[2022-04-18 21:49:40] [index:background:27] Health check
[2022-04-18 21:53:31] [indexer:background:27] Health check
[2022-04-18 21:54:40] [index:background:27] Health check
[2022-04-18 21:58:32] [indexer:background:27] Health check
[2022-04-18 21:59:40] [index:background:27] Health check
[2022-04-18 22:03:32] [indexer:background:27] Health check
[2022-04-18 22:04:40] [index:background:27] Health check
[2022-04-18 22:08:31] [indexer:background:27] Health check
[2022-04-18 22:09:40] [index:background:27] Health check
[2022-04-18 22:13:31] [indexer:background:27] Health check
[2022-04-18 22:14:41] [index:background:27] Health check
[2022-04-18 22:18:31] [indexer:background:27] Health check
[2022-04-18 22:19:40] [index:background:27] Health check
[2022-04-18 22:23:31] [indexer:background:27] Health check
[2022-04-18 22:24:40] [index:background:27] Health check
[2022-04-18 22:28:32] [indexer:background:27] Health check
[2022-04-18 22:29:41] [index:background:27] Health check
[2022-04-18 22:33:32] [indexer:background:27] Health check
[2022-04-18 22:34:40] [index:background:27] Health check
[2022-04-18 22:38:31] [indexer:background:27] Health check
[2022-04-18 22:39:41] [index:background:27] Health check
[2022-04-18 22:43:31] [indexer:background:27] Health check
[2022-04-18 22:44:41] [index:background:27] Health check
[2022-04-18 22:48:32] [indexer:background:27] Health check
[2022-04-18 22:49:40] [index:background:27] Health check
[2022-04-18 22:53:32] [indexer:background:27] Health check
[2022-04-18 22:54:40] [index:background:27] Health check
[2022-04-18 22:58:31] [indexer:background:27] Health check
[2022-04-18 22:59:40] [index:background:27] Health check
[2022-04-18 23:05:12] [indexer:background:27] Health check
[2022-04-18 23:05:12] [index:background:27] Health check
[2022-04-18 23:10:10] [indexer:background:27] Health check
[2022-04-18 23:10:10] [index:background:27] Health check
[2022-04-18 23:13:47] [indexer:background:27] Health check
[2022-04-18 23:15:41] [index:background:27] Health check
[2022-04-18 23:18:41] [indexer:background:27] Health check
[2022-04-18 23:20:37] [index:background:27] Health check
[2022-04-18 23:25:26] [indexer:background:27] Health check
[2022-04-18 23:25:26] [index:background:27] Health check
[2022-04-18 23:29:21] [indexer:background:27] Health check
[2022-04-18 23:31:11] [index:background:27] Health check
[2022-04-18 23:36:39] [indexer:background:27] Health check
[2022-04-18 23:36:39] [index:background:27] Health check
[2022-04-18 23:38:45] [indexer:background:27] Health check
[2022-04-18 23:41:37] [index:background:27] Health check
[2022-04-18 23:43:36] [indexer:background:27] Health check
[2022-04-18 23:47:05] [index:background:27] Health check
[2022-04-18 23:48:45] [indexer:background:27] Health check
[2022-04-18 23:51:28] [index:background:27] Health check
[2022-04-18 23:54:04] [indexer:background:27] Health check
[2022-04-18 23:56:34] [index:background:27] Health check
[2022-04-18 23:59:35] [indexer:background:27] Health check
[2022-04-18 23:59:51] [index:background:27] Health check