[2022-02-07 00:03:03] [index:background:27] Health check [2022-02-07 00:04:03] [indexer:background:27] Health check [2022-02-07 00:07:42] [index:background:27] Health check [2022-02-07 00:09:03] [indexer:background:27] Health check [2022-02-07 00:13:07] [index:background:27] Health check [2022-02-07 00:13:56] [indexer:background:27] Health check [2022-02-07 00:18:21] [index:background:27] Health check [2022-02-07 00:20:14] [indexer:background:27] Health check [2022-02-07 00:22:40] [index:background:27] Health check [2022-02-07 00:24:44] [indexer:background:27] Health check [2022-02-07 00:27:44] [index:background:27] Health check [2022-02-07 00:28:57] [indexer:background:27] Health check [2022-02-07 00:33:18] [index:background:27] Health check [2022-02-07 00:35:38] [indexer:background:27] Health check [2022-02-07 00:37:39] [index:background:27] Health check [2022-02-07 00:39:01] [indexer:background:27] Health check [2022-02-07 00:42:36] [index:background:27] Health check [2022-02-07 00:43:59] [indexer:background:27] Health check [2022-02-07 00:48:39] [index:background:27] Health check [2022-02-07 00:49:43] [indexer:background:27] Health check [2022-02-07 00:52:44] [index:background:27] Health check [2022-02-07 00:53:57] [indexer:background:27] Health check [2022-02-07 00:57:57] [index:background:27] Health check [2022-02-07 00:57:57] [query:27] Query for: mobile phone use [2022-02-07 00:57:57] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 00:57:57] [query:27] Engine: default [2022-02-07 00:57:57] [query:27] Tokens: mobile, using, uses, used, phoning, phones, mobility, useful, phone, use [2022-02-07 00:57:57] [query:27] Mods: 2 [2022-02-07 00:57:57] [query:27] Trying AND logic [2022-02-07 00:57:57] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 00:57:57] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 00:57:57] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 00:57:57] [query:27] Found results using: and logic [2022-02-07 00:57:58] [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 (625,817,509,17,10549,9048,26954,1523,544,182) 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 ('1829', '1897', '2234', '2698', '3402', '3663', '4578', '5332', '6747', '7319', '7448', '8966') 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-02-07 00:57:58] [query:27] Results: 12 Pages of results: 3 [2022-02-07 00:57:58] [query:27] Execution time: 0.23402 [2022-02-07 00:59:06] [indexer:background:27] Health check [2022-02-07 01:03:26] [index:background:27] Health check [2022-02-07 01:05:01] [indexer:background:27] Health check [2022-02-07 01:08:02] [index:background:27] Health check [2022-02-07 01:10:14] [indexer:background:27] Health check [2022-02-07 01:12:38] [index:background:27] Health check [2022-02-07 01:14:39] [indexer:background:27] Health check [2022-02-07 01:18:44] [index:background:27] Health check [2022-02-07 01:20:17] [indexer:background:27] Health check [2022-02-07 01:22:57] [index:background:27] Health check [2022-02-07 01:23:53] [indexer:background:27] Health check [2022-02-07 01:28:03] [index:background:27] Health check [2022-02-07 01:29:39] [indexer:background:27] Health check [2022-02-07 01:33:00] [index:background:27] Health check [2022-02-07 01:33:56] [indexer:background:27] Health check [2022-02-07 01:38:00] [index:background:27] Health check [2022-02-07 01:39:11] [indexer:background:27] Health check [2022-02-07 01:42:37] [index:background:27] Health check [2022-02-07 01:44:12] [indexer:background:27] Health check [2022-02-07 01:47:59] [index:background:27] Health check [2022-02-07 01:49:01] [indexer:background:27] Health check [2022-02-07 01:52:49] [index:background:27] Health check [2022-02-07 01:54:09] [indexer:background:27] Health check [2022-02-07 01:59:20] [index:background:27] Health check [2022-02-07 01:59:20] [indexer:background:27] Health check [2022-02-07 01:59:20] [indexer:background:27] Health check [2022-02-07 02:03:42] [index:background:27] Health check [2022-02-07 02:05:47] [indexer:background:27] Health check [2022-02-07 02:07:54] [index:background:27] Health check [2022-02-07 02:10:01] [indexer:background:27] Health check [2022-02-07 02:13:09] [index:background:27] Health check [2022-02-07 02:14:25] [indexer:background:27] Health check [2022-02-07 02:17:51] [index:background:27] Health check [2022-02-07 02:19:54] [indexer:background:27] Health check [2022-02-07 02:22:45] [index:background:27] Health check [2022-02-07 02:25:08] [indexer:background:27] Health check [2022-02-07 02:27:35] [index:background:27] Health check [2022-02-07 02:28:56] [indexer:background:27] Health check [2022-02-07 02:33:46] [index:background:27] Health check [2022-02-07 02:34:25] [indexer:background:27] Health check [2022-02-07 02:37:55] [index:background:27] Health check [2022-02-07 02:39:37] [indexer:background:27] Health check [2022-02-07 02:42:37] [index:background:27] Health check [2022-02-07 02:44:31] [indexer:background:27] Health check [2022-02-07 02:48:07] [index:background:27] Health check [2022-02-07 02:50:49] [indexer:background:27] Health check [2022-02-07 02:52:57] [index:background:27] Health check [2022-02-07 02:55:06] [indexer:background:27] Health check [2022-02-07 02:58:54] [index:background:27] Health check [2022-02-07 02:58:54] [indexer:background:27] Health check [2022-02-07 02:58:54] [indexer:background:27] Health check [2022-02-07 03:03:47] [index:background:27] Health check [2022-02-07 03:04:41] [indexer:background:27] Health check [2022-02-07 03:07:44] [index:background:27] Health check [2022-02-07 03:10:07] [indexer:background:27] Health check [2022-02-07 03:12:38] [index:background:27] Health check [2022-02-07 03:14:39] [indexer:background:27] Health check [2022-02-07 03:17:48] [index:background:27] Health check [2022-02-07 03:20:50] [indexer:background:27] Health check [2022-02-07 03:22:54] [index:background:27] Health check [2022-02-07 03:24:12] [indexer:background:27] Health check [2022-02-07 03:29:16] [index:background:27] Health check [2022-02-07 03:29:16] [indexer:background:27] Health check [2022-02-07 03:29:16] [indexer:background:27] Health check [2022-02-07 03:33:42] [index:background:27] Health check [2022-02-07 03:33:58] [indexer:background:27] Health check [2022-02-07 03:37:53] [index:background:27] Health check [2022-02-07 03:39:19] [indexer:background:27] Health check [2022-02-07 03:42:52] [index:background:27] Health check [2022-02-07 03:44:39] [indexer:background:27] Health check [2022-02-07 03:48:09] [index:background:27] Health check [2022-02-07 03:50:19] [indexer:background:27] Health check [2022-02-07 03:52:46] [index:background:27] Health check [2022-02-07 03:54:53] [indexer:background:27] Health check [2022-02-07 03:57:50] [index:background:27] Health check [2022-02-07 03:59:11] [indexer:background:27] Health check [2022-02-07 04:02:39] [index:background:27] Health check [2022-02-07 04:04:33] [indexer:background:27] Health check [2022-02-07 04:07:47] [index:background:27] Health check [2022-02-07 04:09:54] [indexer:background:27] Health check [2022-02-07 04:13:07] [index:background:27] Health check [2022-02-07 04:14:14] [indexer:background:27] Health check [2022-02-07 04:18:11] [index:background:27] Health check [2022-02-07 04:19:02] [indexer:background:27] Health check [2022-02-07 04:23:22] [index:background:27] Health check [2022-02-07 04:25:39] [indexer:background:27] Health check [2022-02-07 04:27:51] [index:background:27] Health check [2022-02-07 04:29:19] [indexer:background:27] Health check [2022-02-07 04:34:19] [index:background:27] Health check [2022-02-07 04:34:19] [indexer:background:27] Health check [2022-02-07 04:34:19] [indexer:background:27] Health check [2022-02-07 04:38:42] [index:background:27] Health check [2022-02-07 04:38:59] [indexer:background:27] Health check [2022-02-07 04:42:52] [index:background:27] Health check [2022-02-07 04:45:01] [indexer:background:27] Health check [2022-02-07 04:47:45] [index:background:27] Health check [2022-02-07 04:49:36] [indexer:background:27] Health check [2022-02-07 04:53:03] [index:background:27] Health check [2022-02-07 04:55:09] [indexer:background:27] Health check [2022-02-07 04:57:49] [index:background:27] Health check [2022-02-07 04:59:56] [indexer:background:27] Health check [2022-02-07 05:02:39] [index:background:27] Health check [2022-02-07 05:04:01] [indexer:background:27] Health check [2022-02-07 05:08:40] [index:background:27] Health check [2022-02-07 05:09:17] [indexer:background:27] Health check [2022-02-07 05:12:54] [index:background:27] Health check [2022-02-07 05:14:55] [indexer:background:27] Health check [2022-02-07 05:17:55] [index:background:27] Health check [2022-02-07 05:18:58] [indexer:background:27] Health check [2022-02-07 05:23:02] [index:background:27] Health check [2022-02-07 05:25:39] [indexer:background:27] Health check [2022-02-07 05:27:44] [index:background:27] Health check [2022-02-07 05:30:01] [indexer:background:27] Health check [2022-02-07 05:32:37] [index:background:27] Health check [2022-02-07 05:34:17] [indexer:background:27] Health check [2022-02-07 05:38:42] [index:background:27] Health check [2022-02-07 05:40:07] [indexer:background:27] Health check [2022-02-07 05:42:52] [index:background:27] Health check [2022-02-07 05:44:08] [indexer:background:27] Health check [2022-02-07 05:47:38] [index:background:27] Health check [2022-02-07 05:49:36] [indexer:background:27] Health check [2022-02-07 05:53:02] [index:background:27] Health check [2022-02-07 05:53:53] [indexer:background:27] Health check [2022-02-07 05:57:46] [index:background:27] Health check [2022-02-07 05:59:53] [indexer:background:27] Health check [2022-02-07 06:02:37] [index:background:27] Health check [2022-02-07 06:03:57] [indexer:background:27] Health check [2022-02-07 06:08:09] [index:background:27] Health check [2022-02-07 06:09:27] [indexer:background:27] Health check [2022-02-07 06:12:47] [index:background:27] Health check [2022-02-07 06:14:22] [indexer:background:27] Health check [2022-02-07 06:17:37] [index:background:27] Health check [2022-02-07 06:19:14] [indexer:background:27] Health check [2022-02-07 06:23:38] [index:background:27] Health check [2022-02-07 06:24:02] [indexer:background:27] Health check [2022-02-07 06:27:44] [index:background:27] Health check [2022-02-07 06:28:54] [indexer:background:27] Health check [2022-02-07 06:32:49] [index:background:27] Health check [2022-02-07 06:34:06] [indexer:background:27] Health check [2022-02-07 06:37:55] [index:background:27] Health check [2022-02-07 06:39:19] [indexer:background:27] Health check [2022-02-07 06:42:46] [index:background:27] Health check [2022-02-07 06:44:35] [indexer:background:27] Health check [2022-02-07 06:47:53] [index:background:27] Health check [2022-02-07 06:49:14] [indexer:background:27] Health check [2022-02-07 06:52:37] [index:background:27] Health check [2022-02-07 06:53:57] [indexer:background:27] Health check [2022-02-07 06:57:57] [index:background:27] Health check [2022-02-07 06:58:52] [indexer:background:27] Health check [2022-02-07 07:02:35] [index:background:27] Health check [2022-02-07 07:04:36] [indexer:background:27] Health check [2022-02-07 07:07:36] [index:background:27] Health check [2022-02-07 07:09:39] [indexer:background:27] Health check [2022-02-07 07:13:00] [index:background:27] Health check [2022-02-07 07:13:55] [indexer:background:27] Health check [2022-02-07 07:17:37] [index:background:27] Health check [2022-02-07 07:19:29] [indexer:background:27] Health check [2022-02-07 07:23:44] [index:background:27] Health check [2022-02-07 07:24:38] [indexer:background:27] Health check [2022-02-07 07:27:54] [index:background:27] Health check [2022-02-07 07:30:04] [indexer:background:27] Health check [2022-02-07 07:33:11] [index:background:27] Health check [2022-02-07 07:34:38] [indexer:background:27] Health check [2022-02-07 07:37:38] [index:background:27] Health check [2022-02-07 07:39:15] [indexer:background:27] Health check [2022-02-07 07:42:56] [index:background:27] Health check [2022-02-07 07:45:05] [indexer:background:27] Health check [2022-02-07 07:48:10] [index:background:27] Health check [2022-02-07 07:49:08] [indexer:background:27] Health check [2022-02-07 07:52:40] [index:background:27] Health check [2022-02-07 07:54:35] [indexer:background:27] Health check [2022-02-07 07:57:59] [index:background:27] Health check [2022-02-07 07:58:54] [indexer:background:27] Health check [2022-02-07 08:02:37] [index:background:27] Health check [2022-02-07 08:04:27] [indexer:background:27] Health check [2022-02-07 08:07:40] [index:background:27] Health check [2022-02-07 08:08:55] [indexer:background:27] Health check [2022-02-07 08:12:54] [index:background:27] Health check [2022-02-07 08:13:56] [indexer:background:27] Health check [2022-02-07 08:17:51] [index:background:27] Health check [2022-02-07 08:19:37] [indexer:background:27] Health check [2022-02-07 08:22:36] [index:background:27] Health check [2022-02-07 08:23:57] [indexer:background:27] Health check [2022-02-07 08:28:03] [index:background:27] Health check [2022-02-07 08:28:56] [indexer:background:27] Health check [2022-02-07 08:32:37] [index:background:27] Health check [2022-02-07 08:34:33] [indexer:background:27] Health check [2022-02-07 08:37:41] [index:background:27] Health check [2022-02-07 08:38:55] [indexer:background:27] Health check [2022-02-07 08:42:56] [index:background:27] Health check [2022-02-07 08:43:53] [indexer:background:27] Health check [2022-02-07 08:47:57] [index:background:27] Health check [2022-02-07 08:49:36] [indexer:background:27] Health check [2022-02-07 08:52:48] [index:background:27] Health check [2022-02-07 08:54:55] [indexer:background:27] Health check [2022-02-07 08:55:57] [query:27] Query for: FtP [2022-02-07 08:55:57] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 08:55:57] [query:27] Engine: default [2022-02-07 08:55:57] [query:27] Tokens: ftp [2022-02-07 08:55:57] [query:27] Mods: 2 [2022-02-07 08:55:57] [query:27] Found results using: or logic [2022-02-07 08:55:57] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (273) 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-02-07 08:55:57] [query:27] Results: 16 Pages of results: 4 [2022-02-07 08:55:57] [query:27] Execution time: 0.10921 [2022-02-07 08:57:39] [index:background:27] Health check [2022-02-07 08:59:16] [indexer:background:27] Health check [2022-02-07 09:02:37] [index:background:27] Health check [2022-02-07 09:04:40] [indexer:background:27] Health check [2022-02-07 09:07:49] [index:background:27] Health check [2022-02-07 09:09:56] [indexer:background:27] Health check [2022-02-07 09:13:05] [index:background:27] Health check [2022-02-07 09:14:19] [indexer:background:27] Health check [2022-02-07 09:17:38] [index:background:27] Health check [2022-02-07 09:19:30] [indexer:background:27] Health check [2022-02-07 09:22:50] [index:background:27] Health check [2022-02-07 09:24:09] [indexer:background:27] Health check [2022-02-07 09:27:39] [index:background:27] Health check [2022-02-07 09:29:36] [indexer:background:27] Health check [2022-02-07 09:32:48] [index:background:27] Health check [2022-02-07 09:35:04] [indexer:background:27] Health check [2022-02-07 09:38:06] [index:background:27] Health check [2022-02-07 09:39:40] [indexer:background:27] Health check [2022-02-07 09:42:38] [index:background:27] Health check [2022-02-07 09:44:29] [indexer:background:27] Health check [2022-02-07 09:48:22] [index:background:27] Health check [2022-02-07 09:50:24] [indexer:background:27] Health check [2022-02-07 09:52:44] [index:background:27] Health check [2022-02-07 09:54:49] [indexer:background:27] Health check [2022-02-07 09:57:39] [index:background:27] Health check [2022-02-07 09:59:05] [indexer:background:27] Health check [2022-02-07 10:03:39] [index:background:27] Health check [2022-02-07 10:04:55] [indexer:background:27] Health check [2022-02-07 10:07:49] [index:background:27] Health check [2022-02-07 10:10:00] [indexer:background:27] Health check [2022-02-07 10:12:39] [index:background:27] Health check [2022-02-07 10:14:02] [indexer:background:27] Health check [2022-02-07 10:14:02] [query:27] Query for: allocation [2022-02-07 10:14:02] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:14:02] [query:27] Engine: default [2022-02-07 10:14:02] [query:27] Tokens: allocation, allocations, allocated, allocate, allocating, allocates, alloc [2022-02-07 10:14:02] [query:27] Mods: 2 [2022-02-07 10:14:02] [query:27] Using OR logic [2022-02-07 10:14:02] [query:27] Found results using: and logic [2022-02-07 10:14:02] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (423,442,548,762,5574,9763,26593) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 5 [2022-02-07 10:14:02] [query:27] Results: 81 Pages of results: 17 [2022-02-07 10:14:02] [query:27] Execution time: 0.06241 [2022-02-07 10:18:20] [index:background:27] Health check [2022-02-07 10:19:52] [indexer:background:27] Health check [2022-02-07 10:23:48] [index:background:27] Health check [2022-02-07 10:24:28] [indexer:background:27] Health check [2022-02-07 10:28:36] [index:background:27] Health check [2022-02-07 10:30:38] [indexer:background:27] Health check [2022-02-07 10:32:41] [index:background:27] Health check [2022-02-07 10:34:46] [indexer:background:27] Health check [2022-02-07 10:38:56] [index:background:27] Health check [2022-02-07 10:38:56] [indexer:background:27] Health check [2022-02-07 10:38:56] [indexer:background:27] Health check [2022-02-07 10:42:48] [index:background:27] Health check [2022-02-07 10:44:17] [indexer:background:27] Health check [2022-02-07 10:46:14] [query:27] Query for: pregnant [2022-02-07 10:46:14] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:46:14] [query:27] Engine: default [2022-02-07 10:46:14] [query:27] Tokens: pregnant [2022-02-07 10:46:14] [query:27] Mods: 2 [2022-02-07 10:46:14] [query:27] Found results using: or logic [2022-02-07 10:46: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 (15947) 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-02-07 10:46:14] [query:27] Results: 5 Pages of results: 1 [2022-02-07 10:46:14] [query:27] Execution time: 0.15601 [2022-02-07 10:46:35] [query:27] Query for: pregnancy [2022-02-07 10:46:35] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:46:35] [query:27] Engine: default [2022-02-07 10:46:35] [query:27] Tokens: pregnancy [2022-02-07 10:46:35] [query:27] Mods: 2 [2022-02-07 10:46:35] [query:27] Found results using: or logic [2022-02-07 10:46: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 (486) 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-02-07 10:46:35] [query:27] Results: 13 Pages of results: 3 [2022-02-07 10:46:35] [query:27] Execution time: 0.06241 [2022-02-07 10:47:42] [index:background:27] Health check [2022-02-07 10:48:22] [query:27] Query for: expectant mothers [2022-02-07 10:48:22] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:48:22] [query:27] Engine: default [2022-02-07 10:48:22] [query:27] Tokens: expected, mothers, expecte, expecting, expectancy, expects, expectations, expectant, expectation, expect, mother [2022-02-07 10:48:22] [query:27] Mods: 2 [2022-02-07 10:48:22] [query:27] Trying AND logic [2022-02-07 10:48:22] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:48:22] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:48:22] [query:27] Found results using: and logic [2022-02-07 10:48:22] [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 (529,1286,51062,30221,24352,9889,1978,1285,950,2253,4178) 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 ('10054', '2741') 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-02-07 10:48:22] [query:27] Results: 2 Pages of results: 1 [2022-02-07 10:48:22] [query:27] Execution time: 0.06240 [2022-02-07 10:49:46] [indexer:background:27] Health check [2022-02-07 10:50:45] [query:27] Query for: risk assessment preg [2022-02-07 10:50:45] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:50:45] [query:27] Engine: default [2022-02-07 10:50:45] [query:27] Tokens: assessment, assessable, assessing, assessement, assesses, assessments, assessed, risks, risk, assess, preg [2022-02-07 10:50:45] [query:27] Mods: 2 [2022-02-07 10:50:45] [query:27] Trying AND logic [2022-02-07 10:50:45] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:50:45] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:50:45] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:50:46] [query:27] Found results using: and logic [2022-02-07 10:50:46] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (716,19992,9965,5897,3715,2408,884,4102,298,992,29764) 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 ('7463') 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-02-07 10:50:46] [query:27] Results: 1 Pages of results: 1 [2022-02-07 10:50:46] [query:27] Execution time: 0.06240 [2022-02-07 10:51:32] [query:27] Query for: risk assessment [2022-02-07 10:51:32] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:51:32] [query:27] Engine: default [2022-02-07 10:51:32] [query:27] Tokens: assessment, assessable, assessing, assessement, assesses, assessments, assessed, risks, risk, assess [2022-02-07 10:51:32] [query:27] Mods: 2 [2022-02-07 10:51:32] [query:27] Trying AND logic [2022-02-07 10:51:32] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:51:32] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 10:51:32] [query:27] Found results using: and logic [2022-02-07 10:51:32] [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 (716,19992,9965,5897,3715,2408,884,4102,298,992) 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 (298, 4102) AND id IN ( SELECT id FROM med_searchwp_index s WHERE s.site IN(27) AND 1=1 AND token IN (716, 884, 992, 2408, 3715, 5897, 9965, 19992) 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-02-07 10:51:32] [query:27] Results: 285 Pages of results: 57 [2022-02-07 10:51:32] [query:27] Execution time: 0.26522 [2022-02-07 10:54:00] [index:background:27] Health check [2022-02-07 10:54:00] [indexer:background:27] Health check [2022-02-07 10:54:00] [indexer:background:27] Health check [2022-02-07 10:57:52] [index:background:27] Health check [2022-02-07 10:58:08] [query:27] Query for: pregnant [2022-02-07 10:58:08] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 10:58:08] [query:27] Engine: default [2022-02-07 10:58:08] [query:27] Tokens: pregnant [2022-02-07 10:58:08] [query:27] Mods: 2 [2022-02-07 10:58:08] [query:27] Found results using: or logic [2022-02-07 10:58:08] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('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 (15947) 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-02-07 10:58:08] [query:27] Results: 5 Pages of results: 1 [2022-02-07 10:58:08] [query:27] Execution time: 0.14041 [2022-02-07 11:00:36] [indexer:background:27] Health check [2022-02-07 11:02:43] [index:background:27] Health check [2022-02-07 11:04:54] [indexer:background:27] Health check [2022-02-07 11:09:34] [index:background:27] Health check [2022-02-07 11:09:34] [indexer:background:27] Health check [2022-02-07 11:09:34] [indexer:background:27] Health check [2022-02-07 11:13:20] [index:background:27] Health check [2022-02-07 11:14:07] [indexer:background:27] Health check [2022-02-07 11:17:37] [index:background:27] Health check [2022-02-07 11:18:52] [indexer:background:27] Health check [2022-02-07 11:19:50] [index:27] Marking post.post 10229 to be dropped [2022-02-07 11:19:53] [index:27] Dropping post.post 10229 [2022-02-07 11:19:53] [indexer:27] Queued next batch (1) [2022-02-07 11:19:53] [indexer:27] Processing batch (1) [2022-02-07 11:19:53] [indexer:27] Indexing post.post:10229 [2022-02-07 11:19:53] [index:27] Marking [27] post.post 10229 as indexed [2022-02-07 11:19:53] [indexer:27] Queued next batch (1) [2022-02-07 11:19:54] [indexer:27] Processing batch (1) [2022-02-07 11:19:54] [indexer:27] Indexing post.attachment:10267 [2022-02-07 11:19:54] [index:27] Marking [27] post.attachment 10267 as indexed [2022-02-07 11:19:54] [indexer:27] Index built [2022-02-07 11:21:44] [index:27] Marking post.attachment 10267 to be dropped [2022-02-07 11:21:45] [index:27] Dropping post.attachment 10267 [2022-02-07 11:21:45] [indexer:27] Queued next batch (1) [2022-02-07 11:21:45] [indexer:27] Processing batch (1) [2022-02-07 11:21:45] [indexer:27] Indexing post.attachment:10267 [2022-02-07 11:21:45] [index:27] Marking [27] post.attachment 10267 as indexed [2022-02-07 11:21:45] [indexer:27] Index built [2022-02-07 11:23:04] [index:background:27] Health check [2022-02-07 11:23:53] [indexer:background:27] Health check [2022-02-07 11:28:30] [index:background:27] Health check [2022-02-07 11:29:00] [indexer:background:27] Health check [2022-02-07 11:32:36] [index:background:27] Health check [2022-02-07 11:34:39] [indexer:background:27] Health check [2022-02-07 11:38:53] [index:background:27] Health check [2022-02-07 11:38:53] [indexer:background:27] Health check [2022-02-07 11:38:53] [indexer:background:27] Health check [2022-02-07 11:42:39] [index:background:27] Health check [2022-02-07 11:45:20] [indexer:background:27] Health check [2022-02-07 11:49:26] [index:background:27] Health check [2022-02-07 11:49:26] [indexer:background:27] Health check [2022-02-07 11:49:26] [indexer:background:27] Health check [2022-02-07 11:52:39] [index:background:27] Health check [2022-02-07 11:53:56] [indexer:background:27] Health check [2022-02-07 11:57:49] [index:background:27] Health check [2022-02-07 12:00:00] [indexer:background:27] Health check [2022-02-07 12:02:35] [index:background:27] Health check [2022-02-07 12:04:05] [indexer:background:27] Health check [2022-02-07 12:07:39] [index:background:27] Health check [2022-02-07 12:10:42] [indexer:background:27] Health check [2022-02-07 12:12:46] [index:background:27] Health check [2022-02-07 12:14:52] [indexer:background:27] Health check [2022-02-07 12:17:48] [index:background:27] Health check [2022-02-07 12:19:11] [indexer:background:27] Health check [2022-02-07 12:23:42] [index:background:27] Health check [2022-02-07 12:25:46] [indexer:background:27] Health check [2022-02-07 12:27:53] [index:background:27] Health check [2022-02-07 12:30:01] [indexer:background:27] Health check [2022-02-07 12:33:18] [index:background:27] Health check [2022-02-07 12:34:22] [indexer:background:27] Health check [2022-02-07 12:38:39] [index:background:27] Health check [2022-02-07 12:40:43] [indexer:background:27] Health check [2022-02-07 12:42:39] [index:background:27] Health check [2022-02-07 12:43:53] [indexer:background:27] Health check [2022-02-07 12:48:47] [index:background:27] Health check [2022-02-07 12:49:19] [indexer:background:27] Health check [2022-02-07 12:53:41] [index:background:27] Health check [2022-02-07 12:54:17] [indexer:background:27] Health check [2022-02-07 12:57:39] [index:background:27] Health check [2022-02-07 13:00:02] [indexer:background:27] Health check [2022-02-07 13:02:40] [index:background:27] Health check [2022-02-07 13:04:18] [indexer:background:27] Health check [2022-02-07 13:08:27] [index:background:27] Health check [2022-02-07 13:10:43] [indexer:background:27] Health check [2022-02-07 13:12:46] [index:background:27] Health check [2022-02-07 13:14:52] [indexer:background:27] Health check [2022-02-07 13:17:50] [index:background:27] Health check [2022-02-07 13:19:11] [indexer:background:27] Health check [2022-02-07 13:23:37] [index:background:27] Health check [2022-02-07 13:24:50] [indexer:background:27] Health check [2022-02-07 13:27:39] [index:background:27] Health check [2022-02-07 13:29:41] [indexer:background:27] Health check [2022-02-07 13:34:38] [index:background:27] Health check [2022-02-07 13:34:38] [indexer:background:27] Health check [2022-02-07 13:34:38] [indexer:background:27] Health check [2022-02-07 13:38:40] [index:background:27] Health check [2022-02-07 13:40:43] [indexer:background:27] Health check [2022-02-07 13:42:39] [index:background:27] Health check [2022-02-07 13:45:05] [indexer:background:27] Health check [2022-02-07 13:48:25] [index:background:27] Health check [2022-02-07 13:48:57] [indexer:background:27] Health check [2022-02-07 13:52:38] [index:background:27] Health check [2022-02-07 13:55:53] [indexer:background:27] Health check [2022-02-07 13:58:01] [index:background:27] Health check [2022-02-07 14:00:06] [indexer:background:27] Health check [2022-02-07 14:04:40] [index:background:27] Health check [2022-02-07 14:04:40] [indexer:background:27] Health check [2022-02-07 14:04:40] [indexer:background:27] Health check [2022-02-07 14:07:54] [index:background:27] Health check [2022-02-07 14:10:41] [indexer:background:27] Health check [2022-02-07 14:13:03] [index:background:27] Health check [2022-02-07 14:15:21] [indexer:background:27] Health check [2022-02-07 14:17:39] [index:background:27] Health check [2022-02-07 14:19:44] [indexer:background:27] Health check [2022-02-07 14:22:01] [query:27] Query for: finance [2022-02-07 14:22:01] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 14:22:01] [query:27] Engine: default [2022-02-07 14:22:01] [query:27] Tokens: finance, financed, financi [2022-02-07 14:22:01] [query:27] Mods: 2 [2022-02-07 14:22:01] [query:27] Using OR logic [2022-02-07 14:22:01] [query:27] Found results using: and logic [2022-02-07 14:22:01] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (545,47254,48075) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 5 [2022-02-07 14:22:01] [query:27] Results: 30 Pages of results: 6 [2022-02-07 14:22:01] [query:27] Execution time: 0.09361 [2022-02-07 14:22:39] [index:background:27] Health check [2022-02-07 14:25:56] [indexer:background:27] Health check [2022-02-07 14:28:05] [index:background:27] Health check [2022-02-07 14:30:19] [indexer:background:27] Health check [2022-02-07 14:32:38] [index:background:27] Health check [2022-02-07 14:33:56] [indexer:background:27] Health check [2022-02-07 14:34:55] [index:27] Marking post.post 4565 to be dropped [2022-02-07 14:34:56] [index:27] Dropping post.post 4565 [2022-02-07 14:34:56] [indexer:27] Index built [2022-02-07 14:34:57] [index:27] Marking post.post 4565 to be dropped [2022-02-07 14:34:59] [index:27] Dropping post.post 4565 [2022-02-07 14:34:59] [indexer:27] Queued next batch (1) [2022-02-07 14:34:59] [indexer:27] Processing batch (1) [2022-02-07 14:34:59] [indexer:27] Indexing post.post:4565 [2022-02-07 14:34:59] [index:27] Marking [27] post.post 4565 as indexed [2022-02-07 14:34:59] [indexer:27] Index built [2022-02-07 14:35:07] [index:27] Marking post.post 4565 to be dropped [2022-02-07 14:35:08] [index:27] Dropping post.post 4565 [2022-02-07 14:35:08] [indexer:27] Queued next batch (1) [2022-02-07 14:35:08] [indexer:27] Processing batch (1) [2022-02-07 14:35:08] [indexer:27] Indexing post.post:4565 [2022-02-07 14:35:09] [index:27] Marking [27] post.post 4565 as indexed [2022-02-07 14:35:09] [indexer:27] Index built [2022-02-07 14:36:01] [index:27] Marking post.post 4605 to be dropped [2022-02-07 14:36:01] [index:27] Dropping post.post 4605 [2022-02-07 14:36:01] [indexer:27] Index built [2022-02-07 14:36:09] [index:27] Marking post.post 4565 to be dropped [2022-02-07 14:36:10] [index:27] Dropping post.post 4565 [2022-02-07 14:36:10] [indexer:27] Index built [2022-02-07 14:38:28] [index:background:27] Health check [2022-02-07 14:39:06] [indexer:background:27] Health check [2022-02-07 14:43:10] [index:background:27] Health check [2022-02-07 14:43:49] [query:27] Query for: ScotGEM [2022-02-07 14:43:49] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 14:43:49] [query:27] Engine: default [2022-02-07 14:43:49] [query:27] Tokens: scotgem [2022-02-07 14:43:49] [query:27] Mods: 2 [2022-02-07 14:43:49] [query:27] Found results using: or logic [2022-02-07 14:43: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 (458) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 5 [2022-02-07 14:43:49] [query:27] Results: 84 Pages of results: 17 [2022-02-07 14:43:49] [query:27] Execution time: 0.03120 [2022-02-07 14:44:05] [indexer:background:27] Health check [2022-02-07 14:44:35] [query:27] Query for: ScotGEM handbook [2022-02-07 14:44:35] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 14:44:35] [query:27] Engine: default [2022-02-07 14:44:35] [query:27] Tokens: handbooks, scotgem, handbook [2022-02-07 14:44:35] [query:27] Mods: 2 [2022-02-07 14:44:35] [query:27] Trying AND logic [2022-02-07 14:44:35] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 14:44:35] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-07 14:44:35] [query:27] Found results using: and logic [2022-02-07 14:44:35] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (3943,458,1249) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) AND s.id IN ('10067', '10069', '10184', '10185', '2749', '5332', '6028', '6094', '6147', '6230', '6424', '6882', '7099', '7138', '7153', '7175', '7187', '7223', '7233', '7294', '7298', '7316', '7319', '7343', '7389', '7446', '7448', '7449', '7463', '8319', '8484', '8617', '8638', '8652', '8907', '8947', '8966', '9184', '9185', '9228', '9291', '9353', '9429', '9453', '9592', '9669', '9901', '9918') 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-02-07 14:44:35] [query:27] Results: 48 Pages of results: 10 [2022-02-07 14:44:35] [query:27] Execution time: 0.10921 [2022-02-07 14:47:38] [index:background:27] Health check [2022-02-07 14:49:42] [indexer:background:27] Health check [2022-02-07 14:52:39] [index:background:27] Health check [2022-02-07 14:54:34] [indexer:background:27] Health check [2022-02-07 14:54:53] [query:27] Query for: email [2022-02-07 14:54:53] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 14:54:53] [query:27] Engine: default [2022-02-07 14:54:53] [query:27] Tokens: emailed, emailing, emails, email [2022-02-07 14:54:53] [query:27] Mods: 2 [2022-02-07 14:54:53] [query:27] Using OR logic [2022-02-07 14:54:53] [query:27] Found results using: and logic [2022-02-07 14:54: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 (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-02-07 14:54:53] [query:27] Results: 135 Pages of results: 27 [2022-02-07 14:54:53] [query:27] Execution time: 0.06241 [2022-02-07 14:55:22] [query:27] Query for: email [2022-02-07 14:55:22] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 14:55:22] [query:27] Engine: default [2022-02-07 14:55:22] [query:27] Tokens: emailed, emailing, emails, email [2022-02-07 14:55:22] [query:27] Mods: 2 [2022-02-07 14:55:22] [query:27] Using OR logic [2022-02-07 14:55:22] [query:27] Found results using: and logic [2022-02-07 14:55:22] [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-02-07 14:55:22] [query:27] Results: 135 Pages of results: 27 [2022-02-07 14:55:22] [query:27] Execution time: 0.04680 [2022-02-07 14:58:11] [index:background:27] Health check [2022-02-07 14:59:52] [indexer:background:27] Health check [2022-02-07 15:02:36] [index:background:27] Health check [2022-02-07 15:04:38] [indexer:background:27] Health check [2022-02-07 15:08:01] [index:background:27] Health check [2022-02-07 15:09:46] [indexer:background:27] Health check [2022-02-07 15:12:56] [index:background:27] Health check [2022-02-07 15:14:38] [indexer:background:27] Health check [2022-02-07 15:14:47] [query:27] Query for: pregnant [2022-02-07 15:14:47] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 15:14:47] [query:27] Engine: default [2022-02-07 15:14:47] [query:27] Tokens: pregnant [2022-02-07 15:14:47] [query:27] Mods: 2 [2022-02-07 15:14:47] [query:27] Found results using: or logic [2022-02-07 15:14:47] [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 (15947) 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-02-07 15:14:47] [query:27] Results: 5 Pages of results: 1 [2022-02-07 15:14:47] [query:27] Execution time: 0.15601 [2022-02-07 15:15:08] [query:27] Query for: pregnant [2022-02-07 15:15:08] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 15:15:08] [query:27] Engine: default [2022-02-07 15:15:08] [query:27] Tokens: pregnant [2022-02-07 15:15:08] [query:27] Mods: 2 [2022-02-07 15:15:08] [query:27] Found results using: or logic [2022-02-07 15:15:08] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('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 (15947) 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-02-07 15:15:08] [query:27] Results: 5 Pages of results: 1 [2022-02-07 15:15:08] [query:27] Execution time: 0.14041 [2022-02-07 15:17:39] [index:background:27] Health check [2022-02-07 15:19:17] [indexer:background:27] Health check [2022-02-07 15:23:45] [index:background:27] Health check [2022-02-07 15:25:49] [indexer:background:27] Health check [2022-02-07 15:27:57] [index:background:27] Health check [2022-02-07 15:30:11] [indexer:background:27] Health check [2022-02-07 15:32:39] [index:background:27] Health check [2022-02-07 15:34:37] [indexer:background:27] Health check [2022-02-07 15:37:39] [index:background:27] Health check [2022-02-07 15:40:54] [indexer:background:27] Health check [2022-02-07 15:42:39] [index:background:27] Health check [2022-02-07 15:43:58] [indexer:background:27] Health check [2022-02-07 15:47:37] [index:background:27] Health check [2022-02-07 15:49:39] [indexer:background:27] Health check [2022-02-07 15:53:46] [index:background:27] Health check [2022-02-07 15:53:53] [indexer:background:27] Health check [2022-02-07 15:58:01] [index:background:27] Health check [2022-02-07 15:59:57] [indexer:background:27] Health check [2022-02-07 16:02:39] [index:background:27] Health check [2022-02-07 16:04:32] [indexer:background:27] Health check [2022-02-07 16:08:54] [index:background:27] Health check [2022-02-07 16:08:54] [indexer:background:27] Health check [2022-02-07 16:08:54] [indexer:background:27] Health check [2022-02-07 16:13:13] [index:background:27] Health check [2022-02-07 16:14:42] [indexer:background:27] Health check [2022-02-07 16:17:38] [index:background:27] Health check [2022-02-07 16:19:40] [indexer:background:27] Health check [2022-02-07 16:23:25] [index:background:27] Health check [2022-02-07 16:24:00] [indexer:background:27] Health check [2022-02-07 16:28:30] [index:background:27] Health check [2022-02-07 16:30:39] [indexer:background:27] Health check [2022-02-07 16:32:39] [index:background:27] Health check [2022-02-07 16:34:48] [indexer:background:27] Health check [2022-02-07 16:39:14] [index:background:27] Health check [2022-02-07 16:39:14] [indexer:background:27] Health check [2022-02-07 16:39:14] [indexer:background:27] Health check [2022-02-07 16:43:33] [index:background:27] Health check [2022-02-07 16:43:59] [indexer:background:27] Health check [2022-02-07 16:47:58] [index:background:27] Health check [2022-02-07 16:50:14] [indexer:background:27] Health check [2022-02-07 16:52:37] [index:background:27] Health check [2022-02-07 16:54:39] [indexer:background:27] Health check [2022-02-07 16:58:49] [index:background:27] Health check [2022-02-07 17:00:27] [indexer:background:27] Health check [2022-02-07 17:03:05] [index:background:27] Health check [2022-02-07 17:05:18] [indexer:background:27] Health check [2022-02-07 17:07:38] [index:background:27] Health check [2022-02-07 17:09:41] [indexer:background:27] Health check [2022-02-07 17:13:52] [index:background:27] Health check [2022-02-07 17:13:52] [indexer:background:27] Health check [2022-02-07 17:13:52] [indexer:background:27] Health check [2022-02-07 17:17:37] [index:background:27] Health check [2022-02-07 17:20:20] [indexer:background:27] Health check [2022-02-07 17:22:38] [index:background:27] Health check [2022-02-07 17:24:41] [indexer:background:27] Health check [2022-02-07 17:28:52] [index:background:27] Health check [2022-02-07 17:28:52] [indexer:background:27] Health check [2022-02-07 17:28:52] [indexer:background:27] Health check [2022-02-07 17:33:15] [index:background:27] Health check [2022-02-07 17:35:37] [indexer:background:27] Health check [2022-02-07 17:37:39] [index:background:27] Health check [2022-02-07 17:39:42] [indexer:background:27] Health check [2022-02-07 17:43:55] [index:background:27] Health check [2022-02-07 17:43:55] [indexer:background:27] Health check [2022-02-07 17:43:55] [indexer:background:27] Health check [2022-02-07 17:48:13] [index:background:27] Health check [2022-02-07 17:48:44] [query:27] Query for: pregnant [2022-02-07 17:48:44] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 17:48:44] [query:27] Engine: default [2022-02-07 17:48:44] [query:27] Tokens: pregnant [2022-02-07 17:48:44] [query:27] Mods: 2 [2022-02-07 17:48:44] [query:27] Found results using: or logic [2022-02-07 17:48:44] [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 (15947) 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-02-07 17:48:44] [query:27] Results: 5 Pages of results: 1 [2022-02-07 17:48:44] [query:27] Execution time: 0.14041 [2022-02-07 17:49:03] [indexer:background:27] Health check [2022-02-07 17:51:24] [query:27] Query for: email [2022-02-07 17:51:24] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-07 17:51:24] [query:27] Engine: default [2022-02-07 17:51:24] [query:27] Tokens: emailed, emailing, emails, email [2022-02-07 17:51:24] [query:27] Mods: 2 [2022-02-07 17:51:24] [query:27] Using OR logic [2022-02-07 17:51:24] [query:27] Found results using: and logic [2022-02-07 17:51: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 (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-02-07 17:51:24] [query:27] Results: 135 Pages of results: 27 [2022-02-07 17:51:24] [query:27] Execution time: 0.06241 [2022-02-07 17:52:37] [index:background:27] Health check [2022-02-07 17:54:41] [indexer:background:27] Health check [2022-02-07 17:57:43] [index:background:27] Health check [2022-02-07 17:59:55] [indexer:background:27] Health check [2022-02-07 18:02:39] [index:background:27] Health check [2022-02-07 18:03:54] [indexer:background:27] Health check [2022-02-07 18:09:35] [index:background:27] Health check [2022-02-07 18:09:35] [indexer:background:27] Health check [2022-02-07 18:09:35] [indexer:background:27] Health check [2022-02-07 18:13:37] [index:background:27] Health check [2022-02-07 18:15:18] [indexer:background:27] Health check [2022-02-07 18:17:46] [index:background:27] Health check [2022-02-07 18:19:52] [indexer:background:27] Health check [2022-02-07 18:23:53] [index:background:27] Health check [2022-02-07 18:23:53] [indexer:background:27] Health check [2022-02-07 18:23:53] [indexer:background:27] Health check [2022-02-07 18:28:37] [index:background:27] Health check [2022-02-07 18:30:40] [indexer:background:27] Health check [2022-02-07 18:32:39] [index:background:27] Health check [2022-02-07 18:34:07] [indexer:background:27] Health check [2022-02-07 18:39:14] [index:background:27] Health check [2022-02-07 18:39:14] [indexer:background:27] Health check [2022-02-07 18:39:14] [indexer:background:27] Health check [2022-02-07 18:43:37] [index:background:27] Health check [2022-02-07 18:45:41] [indexer:background:27] Health check [2022-02-07 18:47:39] [index:background:27] Health check [2022-02-07 18:49:52] [indexer:background:27] Health check [2022-02-07 18:54:14] [index:background:27] Health check [2022-02-07 18:54:14] [indexer:background:27] Health check [2022-02-07 18:54:14] [indexer:background:27] Health check [2022-02-07 18:58:39] [index:background:27] Health check [2022-02-07 19:00:40] [indexer:background:27] Health check [2022-02-07 19:02:45] [index:background:27] Health check [2022-02-07 19:04:52] [indexer:background:27] Health check [2022-02-07 19:07:57] [index:background:27] Health check [2022-02-07 19:09:14] [indexer:background:27] Health check [2022-02-07 19:13:37] [index:background:27] Health check [2022-02-07 19:15:40] [indexer:background:27] Health check [2022-02-07 19:17:45] [index:background:27] Health check [2022-02-07 19:19:52] [indexer:background:27] Health check [2022-02-07 19:24:14] [index:background:27] Health check [2022-02-07 19:24:14] [indexer:background:27] Health check [2022-02-07 19:24:14] [indexer:background:27] Health check [2022-02-07 19:28:25] [index:background:27] Health check [2022-02-07 19:30:42] [indexer:background:27] Health check [2022-02-07 19:32:48] [index:background:27] Health check [2022-02-07 19:34:54] [indexer:background:27] Health check [2022-02-07 19:39:18] [index:background:27] Health check [2022-02-07 19:39:18] [indexer:background:27] Health check [2022-02-07 19:39:18] [indexer:background:27] Health check [2022-02-07 19:43:40] [index:background:27] Health check [2022-02-07 19:45:45] [indexer:background:27] Health check [2022-02-07 19:47:52] [index:background:27] Health check [2022-02-07 19:50:02] [indexer:background:27] Health check [2022-02-07 19:52:51] [index:background:27] Health check [2022-02-07 19:54:36] [indexer:background:27] Health check [2022-02-07 19:58:42] [index:background:27] Health check [2022-02-07 20:00:48] [indexer:background:27] Health check [2022-02-07 20:02:54] [index:background:27] Health check [2022-02-07 20:05:04] [indexer:background:27] Health check [2022-02-07 20:07:36] [index:background:27] Health check [2022-02-07 20:09:37] [indexer:background:27] Health check [2022-02-07 20:13:45] [index:background:27] Health check [2022-02-07 20:15:52] [indexer:background:27] Health check [2022-02-07 20:18:01] [index:background:27] Health check [2022-02-07 20:20:14] [indexer:background:27] Health check [2022-02-07 20:22:36] [index:background:27] Health check [2022-02-07 20:24:38] [indexer:background:27] Health check [2022-02-07 20:28:10] [index:background:27] Health check [2022-02-07 20:31:29] [indexer:background:27] Health check [2022-02-07 20:33:24] [index:background:27] Health check [2022-02-07 20:35:35] [indexer:background:27] Health check [2022-02-07 20:37:35] [index:background:27] Health check [2022-02-07 20:39:37] [indexer:background:27] Health check [2022-02-07 20:43:08] [index:background:27] Health check [2022-02-07 20:44:04] [indexer:background:27] Health check [2022-02-07 20:48:01] [index:background:27] Health check [2022-02-07 20:50:14] [indexer:background:27] Health check [2022-02-07 20:52:36] [index:background:27] Health check [2022-02-07 20:53:52] [indexer:background:27] Health check [2022-02-07 20:58:48] [index:background:27] Health check [2022-02-07 20:59:14] [indexer:background:27] Health check [2022-02-07 21:03:11] [index:background:27] Health check [2022-02-07 21:05:27] [indexer:background:27] Health check [2022-02-07 21:07:38] [index:background:27] Health check [2022-02-07 21:09:40] [indexer:background:27] Health check [2022-02-07 21:13:52] [index:background:27] Health check [2022-02-07 21:13:52] [indexer:background:27] Health check [2022-02-07 21:13:52] [indexer:background:27] Health check [2022-02-07 21:18:14] [index:background:27] Health check [2022-02-07 21:18:57] [indexer:background:27] Health check [2022-02-07 21:22:39] [index:background:27] Health check [2022-02-07 21:24:42] [indexer:background:27] Health check [2022-02-07 21:28:55] [index:background:27] Health check [2022-02-07 21:28:55] [indexer:background:27] Health check [2022-02-07 21:28:55] [indexer:background:27] Health check [2022-02-07 21:33:10] [index:background:27] Health check [2022-02-07 21:33:52] [indexer:background:27] Health check [2022-02-07 21:37:38] [index:background:27] Health check [2022-02-07 21:39:42] [indexer:background:27] Health check [2022-02-07 21:42:37] [index:background:27] Health check [2022-02-07 21:43:55] [indexer:background:27] Health check [2022-02-07 21:48:09] [index:background:27] Health check [2022-02-07 21:48:52] [indexer:background:27] Health check [2022-02-07 21:52:40] [index:background:27] Health check [2022-02-07 21:54:45] [indexer:background:27] Health check [2022-02-07 21:57:39] [index:background:27] Health check [2022-02-07 21:59:02] [indexer:background:27] Health check [2022-02-07 22:03:37] [index:background:27] Health check [2022-02-07 22:03:55] [indexer:background:27] Health check [2022-02-07 22:07:42] [index:background:27] Health check [2022-02-07 22:09:45] [indexer:background:27] Health check [2022-02-07 22:12:37] [index:background:27] Health check [2022-02-07 22:14:00] [indexer:background:27] Health check [2022-02-07 22:18:34] [index:background:27] Health check [2022-02-07 22:18:52] [indexer:background:27] Health check [2022-02-07 22:22:40] [index:background:27] Health check [2022-02-07 22:24:45] [indexer:background:27] Health check [2022-02-07 22:27:39] [index:background:27] Health check [2022-02-07 22:29:09] [indexer:background:27] Health check [2022-02-07 22:33:37] [index:background:27] Health check [2022-02-07 22:33:53] [indexer:background:27] Health check [2022-02-07 22:37:45] [index:background:27] Health check [2022-02-07 22:39:52] [indexer:background:27] Health check [2022-02-07 22:42:37] [index:background:27] Health check [2022-02-07 22:44:10] [indexer:background:27] Health check [2022-02-07 22:48:37] [index:background:27] Health check [2022-02-07 22:49:50] [indexer:background:27] Health check [2022-02-07 22:52:45] [index:background:27] Health check [2022-02-07 22:54:49] [indexer:background:27] Health check [2022-02-07 22:57:35] [index:background:27] Health check [2022-02-07 22:59:08] [indexer:background:27] Health check [2022-02-07 23:03:36] [index:background:27] Health check [2022-02-07 23:05:37] [indexer:background:27] Health check [2022-02-07 23:07:39] [index:background:27] Health check [2022-02-07 23:09:42] [indexer:background:27] Health check [2022-02-07 23:12:36] [index:background:27] Health check [2022-02-07 23:13:54] [indexer:background:27] Health check [2022-02-07 23:17:48] [index:background:27] Health check [2022-02-07 23:20:37] [indexer:background:27] Health check [2022-02-07 23:22:40] [index:background:27] Health check [2022-02-07 23:24:45] [indexer:background:27] Health check [2022-02-07 23:27:37] [index:background:27] Health check [2022-02-07 23:29:01] [indexer:background:27] Health check [2022-02-07 23:33:36] [index:background:27] Health check [2022-02-07 23:35:39] [indexer:background:27] Health check [2022-02-07 23:37:42] [index:background:27] Health check [2022-02-07 23:39:48] [indexer:background:27] Health check [2022-02-07 23:42:38] [index:background:27] Health check [2022-02-07 23:44:04] [indexer:background:27] Health check [2022-02-07 23:48:37] [index:background:27] Health check [2022-02-07 23:48:54] [indexer:background:27] Health check [2022-02-07 23:52:45] [index:background:27] Health check [2022-02-07 23:54:52] [indexer:background:27] Health check [2022-02-07 23:57:40] [index:background:27] Health check [2022-02-07 23:59:12] [indexer:background:27] Health check