[2022-02-14 00:02:35] [index:background:27] Health check
[2022-02-14 00:03:52] [indexer:background:27] Health check
[2022-02-14 00:07:35] [index:background:27] Health check
[2022-02-14 00:08:52] [indexer:background:27] Health check
[2022-02-14 00:12:35] [index:background:27] Health check
[2022-02-14 00:13:52] [indexer:background:27] Health check
[2022-02-14 00:17:35] [index:background:27] Health check
[2022-02-14 00:18:52] [indexer:background:27] Health check
[2022-02-14 00:31:40] [index:background:27] Health check
[2022-02-14 00:31:40] [indexer:background:27] Health check
[2022-02-14 00:31:40] [indexer:background:27] Health check
[2022-02-14 00:46:22] [index:background:27] Health check
[2022-02-14 00:46:22] [indexer:background:27] Health check
[2022-02-14 00:46:22] [indexer:background:27] Health check
[2022-02-14 00:52:55] [index:background:27] Health check
[2022-02-14 00:52:55] [indexer:background:27] Health check
[2022-02-14 00:52:55] [indexer:background:27] Health check
[2022-02-14 01:19:36] [indexer:background:27] Health check
[2022-02-14 01:19:36] [index:background:27] Health check
[2022-02-14 01:25:06] [index:background:27] Health check
[2022-02-14 01:25:06] [indexer:background:27] Health check
[2022-02-14 01:25:06] [indexer:background:27] Health check
[2022-02-14 01:37:05] [index:background:27] Health check
[2022-02-14 01:37:05] [indexer:background:27] Health check
[2022-02-14 01:37:05] [indexer:background:27] Health check
[2022-02-14 01:37:57] [index:background:27] Health check
[2022-02-14 01:55:05] [indexer:background:27] Health check
[2022-02-14 01:55:05] [index:background:27] Health check
[2022-02-14 02:06:48] [index:background:27] Health check
[2022-02-14 02:06:48] [indexer:background:27] Health check
[2022-02-14 02:06:48] [indexer:background:27] Health check
[2022-02-14 02:08:19] [index:background:27] Health check
[2022-02-14 02:11:16] [indexer:background:27] Health check
[2022-02-14 02:29:06] [index:background:27] Health check
[2022-02-14 02:29:06] [indexer:background:27] Health check
[2022-02-14 02:29:06] [indexer:background:27] Health check
[2022-02-14 02:35:19] [index:background:27] Health check
[2022-02-14 02:35:19] [indexer:background:27] Health check
[2022-02-14 02:35:19] [indexer:background:27] Health check
[2022-02-14 02:51:38] [index:background:27] Health check
[2022-02-14 02:51:38] [indexer:background:27] Health check
[2022-02-14 02:51:38] [indexer:background:27] Health check
[2022-02-14 02:52:37] [index:background:27] Health check
[2022-02-14 02:55:50] [indexer:background:27] Health check
[2022-02-14 02:58:08] [index:background:27] Health check
[2022-02-14 03:08:16] [indexer:background:27] Health check
[2022-02-14 03:08:16] [index:background:27] Health check
[2022-02-14 03:21:38] [indexer:background:27] Health check
[2022-02-14 03:21:38] [index:background:27] Health check
[2022-02-14 03:40:59] [index:background:27] Health check
[2022-02-14 03:40:59] [indexer:background:27] Health check
[2022-02-14 03:40:59] [indexer:background:27] Health check
[2022-02-14 03:46:26] [index:background:27] Health check
[2022-02-14 03:46:26] [indexer:background:27] Health check
[2022-02-14 03:46:26] [indexer:background:27] Health check
[2022-02-14 03:48:04] [index:background:27] Health check
[2022-02-14 03:51:38] [indexer:background:27] Health check
[2022-02-14 03:59:57] [index:background:27] Health check
[2022-02-14 03:59:57] [indexer:background:27] Health check
[2022-02-14 03:59:57] [indexer:background:27] Health check
[2022-02-14 04:08:08] [index:background:27] Health check
[2022-02-14 04:08:08] [indexer:background:27] Health check
[2022-02-14 04:08:08] [indexer:background:27] Health check
[2022-02-14 04:10:03] [indexer:background:27] Health check
[2022-02-14 04:13:07] [index:background:27] Health check
[2022-02-14 04:15:47] [indexer:background:27] Health check
[2022-02-14 04:19:07] [index:background:27] Health check
[2022-02-14 04:19:07] [indexer:background:27] Health check
[2022-02-14 04:19:07] [indexer:background:27] Health check
[2022-02-14 04:31:15] [index:background:27] Health check
[2022-02-14 04:31:15] [indexer:background:27] Health check
[2022-02-14 04:31:15] [indexer:background:27] Health check
[2022-02-14 04:35:16] [index:background:27] Health check
[2022-02-14 04:35:16] [indexer:background:27] Health check
[2022-02-14 04:35:16] [indexer:background:27] Health check
[2022-02-14 04:38:00] [index:background:27] Health check
[2022-02-14 04:40:59] [indexer:background:27] Health check
[2022-02-14 04:48:08] [index:background:27] Health check
[2022-02-14 04:48:08] [indexer:background:27] Health check
[2022-02-14 04:48:08] [indexer:background:27] Health check
[2022-02-14 05:01:32] [indexer:background:27] Health check
[2022-02-14 05:01:32] [index:background:27] Health check
[2022-02-14 05:08:08] [index:background:27] Health check
[2022-02-14 05:08:08] [indexer:background:27] Health check
[2022-02-14 05:08:08] [indexer:background:27] Health check
[2022-02-14 05:36:34] [indexer:background:27] Health check
[2022-02-14 05:36:34] [index:background:27] Health check
[2022-02-14 05:38:08] [index:background:27] Health check
[2022-02-14 05:48:08] [indexer:background:27] Health check
[2022-02-14 05:48:08] [index:background:27] Health check
[2022-02-14 06:03:30] [indexer:background:27] Health check
[2022-02-14 06:03:30] [index:background:27] Health check
[2022-02-14 06:06:35] [indexer:background:27] Health check
[2022-02-14 06:10:17] [index:background:27] Health check
[2022-02-14 06:10:17] [indexer:background:27] Health check
[2022-02-14 06:10:17] [indexer:background:27] Health check
[2022-02-14 06:18:08] [index:background:27] Health check
[2022-02-14 06:18:08] [indexer:background:27] Health check
[2022-02-14 06:18:08] [indexer:background:27] Health check
[2022-02-14 06:28:25] [indexer:background:27] Health check
[2022-02-14 06:28:25] [index:background:27] Health check
[2022-02-14 06:36:28] [indexer:background:27] Health check
[2022-02-14 06:36:28] [index:background:27] Health check
[2022-02-14 06:48:08] [index:background:27] Health check
[2022-02-14 06:48:08] [indexer:background:27] Health check
[2022-02-14 06:48:08] [indexer:background:27] Health check
[2022-02-14 07:01:50] [indexer:background:27] Health check
[2022-02-14 07:01:50] [index:background:27] Health check
[2022-02-14 07:24:01] [index:background:27] Health check
[2022-02-14 07:24:01] [indexer:background:27] Health check
[2022-02-14 07:24:01] [indexer:background:27] Health check
[2022-02-14 07:37:09] [index:background:27] Health check
[2022-02-14 07:37:09] [indexer:background:27] Health check
[2022-02-14 07:37:09] [indexer:background:27] Health check
[2022-02-14 07:38:02] [index:background:27] Health check
[2022-02-14 07:42:07] [indexer:background:27] Health check
[2022-02-14 07:48:04] [index:background:27] Health check
[2022-02-14 07:48:04] [indexer:background:27] Health check
[2022-02-14 07:48:04] [indexer:background:27] Health check
[2022-02-14 07:51:37] [indexer:background:27] Health check
[2022-02-14 07:58:08] [index:background:27] Health check
[2022-02-14 07:58:08] [indexer:background:27] Health check
[2022-02-14 07:58:08] [indexer:background:27] Health check
[2022-02-14 08:01:44] [indexer:background:27] Health check
[2022-02-14 08:06:18] [index:background:27] Health check
[2022-02-14 08:06:18] [indexer:background:27] Health check
[2022-02-14 08:06:18] [indexer:background:27] Health check
[2022-02-14 08:07:56] [index:background:27] Health check
[2022-02-14 08:09:55] [indexer:background:27] Health check
[2022-02-14 08:13:29] [index:background:27] Health check
[2022-02-14 08:18:08] [indexer:background:27] Health check
[2022-02-14 08:18:08] [index:background:27] Health check
[2022-02-14 08:25:54] [indexer:background:27] Health check
[2022-02-14 08:25:54] [index:background:27] Health check
[2022-02-14 08:33:15] [index:background:27] Health check
[2022-02-14 08:33:15] [indexer:background:27] Health check
[2022-02-14 08:33:15] [indexer:background:27] Health check
[2022-02-14 08:35:06] [indexer:background:27] Health check
[2022-02-14 08:38:08] [index:background:27] Health check
[2022-02-14 08:42:57] [indexer:background:27] Health check
[2022-02-14 08:42:57] [index:background:27] Health check
[2022-02-14 08:43:56] [indexer:background:27] Health check
[2022-02-14 08:43:56] [query:27] Query for: Sim patient
[2022-02-14 08:43:56] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 08:43:56] [query:27] Engine: default
[2022-02-14 08:43:56] [query:27] Tokens: patients, patient's, sim, patient
[2022-02-14 08:43:56] [query:27] Mods: 2
[2022-02-14 08:43:56] [query:27] Trying AND logic
[2022-02-14 08:43:56] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 08:43:56] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 08:43:56] [query:27] Found results using: and logic
[2022-02-14 08:43:56] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (296,41103,1790,243) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) AND s.id IN ('10077', '1829', '2418', '5985', '6149') GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 5
[2022-02-14 08:43:56] [query:27] Results: 5 Pages of results: 1
[2022-02-14 08:43:56] [query:27] Execution time: 0.06240
[2022-02-14 08:48:59] [index:background:27] Health check
[2022-02-14 08:48:59] [indexer:background:27] Health check
[2022-02-14 08:48:59] [indexer:background:27] Health check
[2022-02-14 08:53:27] [index:background:27] Health check
[2022-02-14 08:55:59] [indexer:background:27] Health check
[2022-02-14 09:06:14] [index:background:27] Health check
[2022-02-14 09:06:14] [indexer:background:27] Health check
[2022-02-14 09:06:14] [indexer:background:27] Health check
[2022-02-14 09:09:18] [index:background:27] Health check
[2022-02-14 09:09:18] [indexer:background:27] Health check
[2022-02-14 09:09:18] [indexer:background:27] Health check
[2022-02-14 09:13:18] [index:background:27] Health check
[2022-02-14 09:20:42] [indexer:background:27] Health check
[2022-02-14 09:20:43] [index:background:27] Health check
[2022-02-14 09:24:59] [index:background:27] Health check
[2022-02-14 09:24:59] [indexer:background:27] Health check
[2022-02-14 09:24:59] [indexer:background:27] Health check
[2022-02-14 09:31:07] [index:background:27] Health check
[2022-02-14 09:31:07] [indexer:background:27] Health check
[2022-02-14 09:31:07] [indexer:background:27] Health check
[2022-02-14 09:31:31] [query:27] Query for: memorial
[2022-02-14 09:31:31] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 09:31:31] [query:27] Engine: default
[2022-02-14 09:31:31] [query:27] Tokens: memory, memorial, memories
[2022-02-14 09:31:31] [query:27] Mods: 2
[2022-02-14 09:31:31] [query:27] Using OR logic
[2022-02-14 09:31:31] [query:27] Found results using: and logic
[2022-02-14 09:31:31] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (4131,5266,28518) 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-14 09:31:31] [query:27] Results: 14 Pages of results: 3
[2022-02-14 09:31:31] [query:27] Execution time: 0.04680
[2022-02-14 09:31:39] [query:27] Query for: memmorial service
[2022-02-14 09:31:39] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 09:31:39] [query:27] Engine: default
[2022-02-14 09:31:39] [query:27] Tokens: services, serviceable, serviced, servicing, servicelearning, service-learning, service, servic, service_portfolio_diagram, serviceportfoliodiagram, service 80
[2022-02-14 09:31:39] [query:27] Mods: 3
[2022-02-14 09:31:39] [query:27] Using OR logic
[2022-02-14 09:31:40] [query:27] Found results using: and logic
[2022-02-14 09:31:40] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance,( SELECT SUM(med_searchwp_index.occurrences) FROM med_searchwp_index WHERE med_searchwp_index.id = s.id AND med_searchwp_index.site = s.site AND med_searchwp_index.source = s.source AND med_searchwp_index.token IN(842) GROUP BY med_searchwp_index.id ) AS searchwp_exacts FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (724,22988,13631,13118,8814,8813,842,28960,19912,19913,34100) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY searchwp_exacts+0 DESC, relevance DESC LIMIT 0, 5
[2022-02-14 09:31:40] [query:27] Results: 153 Pages of results: 31
[2022-02-14 09:31:40] [query:27] Execution time: 0.62405
[2022-02-14 09:35:12] [index:background:27] Health check
[2022-02-14 09:35:12] [indexer:background:27] Health check
[2022-02-14 09:35:12] [indexer:background:27] Health check
[2022-02-14 09:38:08] [index:background:27] Health check
[2022-02-14 09:47:15] [indexer:background:27] Health check
[2022-02-14 09:47:15] [index:background:27] Health check
[2022-02-14 09:52:37] [index:background:27] Health check
[2022-02-14 09:52:37] [indexer:background:27] Health check
[2022-02-14 09:52:37] [indexer:background:27] Health check
[2022-02-14 09:54:01] [indexer:background:27] Health check
[2022-02-14 09:58:26] [index:background:27] Health check
[2022-02-14 10:08:08] [indexer:background:27] Health check
[2022-02-14 10:08:08] [index:background:27] Health check
[2022-02-14 10:09:06] [indexer:background:27] Health check
[2022-02-14 10:17:41] [index:background:27] Health check
[2022-02-14 10:17:41] [indexer:background:27] Health check
[2022-02-14 10:17:41] [indexer:background:27] Health check
[2022-02-14 10:22:50] [indexer:background:27] Health check
[2022-02-14 10:22:50] [index:background:27] Health check
[2022-02-14 10:25:37] [indexer:background:27] Health check
[2022-02-14 10:37:18] [index:background:27] Health check
[2022-02-14 10:37:18] [indexer:background:27] Health check
[2022-02-14 10:37:18] [indexer:background:27] Health check
[2022-02-14 10:38:08] [index:background:27] Health check
[2022-02-14 10:44:21] [indexer:background:27] Health check
[2022-02-14 10:44:21] [index:background:27] Health check
[2022-02-14 10:48:34] [index:background:27] Health check
[2022-02-14 10:49:25] [indexer:background:27] Health check
[2022-02-14 10:54:39] [index:background:27] Health check
[2022-02-14 10:54:39] [indexer:background:27] Health check
[2022-02-14 10:54:39] [indexer:background:27] Health check
[2022-02-14 10:59:19] [index:background:27] Health check
[2022-02-14 10:59:19] [indexer:background:27] Health check
[2022-02-14 10:59:19] [indexer:background:27] Health check
[2022-02-14 11:03:48] [index:background:27] Health check
[2022-02-14 11:03:58] [indexer:background:27] Health check
[2022-02-14 11:08:08] [index:background:27] Health check
[2022-02-14 11:09:52] [indexer:background:27] Health check
[2022-02-14 11:14:14] [index:background:27] Health check
[2022-02-14 11:14:14] [indexer:background:27] Health check
[2022-02-14 11:14:14] [indexer:background:27] Health check
[2022-02-14 11:22:56] [index:background:27] Health check
[2022-02-14 11:22:56] [indexer:background:27] Health check
[2022-02-14 11:22:56] [indexer:background:27] Health check
[2022-02-14 11:22:56] [query:27] Query for: copiable e-mail
[2022-02-14 11:22:56] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 11:22:56] [query:27] Engine: default
[2022-02-14 11:22:56] [query:27] Tokens: copiable, e-mails, e-mailed, e-mailing, mails, mailed, mailing, mail, e-mail
[2022-02-14 11:22:56] [query:27] Mods: 2
[2022-02-14 11:22:56] [query:27] Trying AND logic
[2022-02-14 11:22:56] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 11:22:56] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 11:22:56] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 11:22:56] [query:27] Using OR logic
[2022-02-14 11:22:56] [query:27] Found results using: or logic
[2022-02-14 11:22:56] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (5392,4361,9637,27071,4359,9409,26810,1176,10626) 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-14 11:22:56] [query:27] Results: 24 Pages of results: 5
[2022-02-14 11:22:56] [query:27] Execution time: 0.07801
[2022-02-14 11:23:27] [query:27] Query for: copiable e-mail
[2022-02-14 11:23:27] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 11:23:27] [query:27] Engine: default
[2022-02-14 11:23:27] [query:27] Tokens: copiable, e-mails, e-mailed, e-mailing, mails, mailed, mailing, mail, e-mail
[2022-02-14 11:23:27] [query:27] Mods: 2
[2022-02-14 11:23:27] [query:27] Trying AND logic
[2022-02-14 11:23:27] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 11:23:27] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 11:23:27] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 11:23:27] [query:27] Using OR logic
[2022-02-14 11:23:27] [query:27] Found results using: or logic
[2022-02-14 11:23:27] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance)  AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END)  ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (5392,4361,9637,27071,4359,9409,26810,1176,10626) 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-14 11:23:27] [query:27] Results: 24 Pages of results: 5
[2022-02-14 11:23:27] [query:27] Execution time: 0.06241
[2022-02-14 11:24:01] [indexer:background:27] Health check
[2022-02-14 11:31:34] [index:background:27] Health check
[2022-02-14 11:31:34] [indexer:background:27] Health check
[2022-02-14 11:31:34] [indexer:background:27] Health check
[2022-02-14 11:36:59] [index:background:27] Health check
[2022-02-14 11:37:00] [indexer:background:27] Health check
[2022-02-14 11:37:00] [indexer:background:27] Health check
[2022-02-14 11:38:08] [index:background:27] Health check
[2022-02-14 11:46:29] [indexer:background:27] Health check
[2022-02-14 11:46:29] [index:background:27] Health check
[2022-02-14 11:55:09] [index:background:27] Health check
[2022-02-14 11:55:09] [indexer:background:27] Health check
[2022-02-14 11:55:09] [indexer:background:27] Health check
[2022-02-14 11:59:16] [index:background:27] Health check
[2022-02-14 11:59:16] [indexer:background:27] Health check
[2022-02-14 11:59:16] [indexer:background:27] Health check
[2022-02-14 12:06:19] [index:background:27] Health check
[2022-02-14 12:06:19] [indexer:background:27] Health check
[2022-02-14 12:06:19] [indexer:background:27] Health check
[2022-02-14 12:06:38] [query:27] Query for: Sim patient#
[2022-02-14 12:06:38] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 12:06:38] [query:27] Engine: default
[2022-02-14 12:06:38] [query:27] Tokens: patients, patient's, sim, patient
[2022-02-14 12:06:38] [query:27] Mods: 2
[2022-02-14 12:06:38] [query:27] Trying AND logic
[2022-02-14 12:06:38] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 12:06:38] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 12:06:38] [query:27] Found results using: and logic
[2022-02-14 12:06: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 (296,41103,1790,243) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) AND s.id IN ('10077', '1829', '2418', '5985', '6149') GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 5
[2022-02-14 12:06:38] [query:27] Results: 5 Pages of results: 1
[2022-02-14 12:06:38] [query:27] Execution time: 0.04680
[2022-02-14 12:23:09] [index:background:27] Health check
[2022-02-14 12:23:09] [indexer:background:27] Health check
[2022-02-14 12:23:09] [indexer:background:27] Health check
[2022-02-14 12:27:53] [indexer:background:27] Health check
[2022-02-14 12:27:53] [index:background:27] Health check
[2022-02-14 12:35:45] [indexer:background:27] Health check
[2022-02-14 12:35:45] [index:background:27] Health check
[2022-02-14 12:38:10] [index:background:27] Health check
[2022-02-14 12:40:22] [indexer:background:27] Health check
[2022-02-14 12:43:50] [index:background:27] Health check
[2022-02-14 12:49:44] [indexer:background:27] Health check
[2022-02-14 12:49:44] [index:background:27] Health check
[2022-02-14 12:53:08] [index:background:27] Health check
[2022-02-14 12:54:47] [indexer:background:27] Health check
[2022-02-14 12:59:32] [index:background:27] Health check
[2022-02-14 12:59:33] [indexer:background:27] Health check
[2022-02-14 12:59:33] [indexer:background:27] Health check
[2022-02-14 13:03:39] [index:background:27] Health check
[2022-02-14 13:17:27] [indexer:background:27] Health check
[2022-02-14 13:17:27] [index:background:27] Health check
[2022-02-14 13:26:13] [index:background:27] Health check
[2022-02-14 13:26:13] [indexer:background:27] Health check
[2022-02-14 13:26:13] [indexer:background:27] Health check
[2022-02-14 13:27:39] [index:background:27] Health check
[2022-02-14 13:31:12] [indexer:background:27] Health check
[2022-02-14 13:35:58] [index:background:27] Health check
[2022-02-14 13:35:58] [indexer:background:27] Health check
[2022-02-14 13:35:58] [indexer:background:27] Health check
[2022-02-14 13:38:08] [index:background:27] Health check
[2022-02-14 13:42:28] [indexer:background:27] Health check
[2022-02-14 13:42:38] [index:background:27] Health check
[2022-02-14 13:43:54] [indexer:background:27] Health check
[2022-02-14 13:45:18] [query:27] Query for: CPD fund
[2022-02-14 13:45:18] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 13:45:18] [query:27] Engine: default
[2022-02-14 13:45:18] [query:27] Tokens: funded, funds, funding, funde, cpd, fund
[2022-02-14 13:45:18] [query:27] Mods: 2
[2022-02-14 13:45:18] [query:27] Trying AND logic
[2022-02-14 13:45:18] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 13:45:18] [query:27] Skipping AND logic Source Attribute consideration (single Engine)
[2022-02-14 13:45:18] [query:27] Found results using: and logic
[2022-02-14 13:45:18] [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 (941,948,3734,44308,4487,5208) 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 ('3527', '4988', '7389', '9553', '9891') 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-14 13:45:18] [query:27] Results: 5 Pages of results: 1
[2022-02-14 13:45:18] [query:27] Execution time: 0.14041
[2022-02-14 13:48:20] [index:background:27] Health check
[2022-02-14 13:54:09] [indexer:background:27] Health check
[2022-02-14 13:54:09] [index:background:27] Health check
[2022-02-14 13:58:08] [index:background:27] Health check
[2022-02-14 14:01:51] [indexer:background:27] Health check
[2022-02-14 14:20:29] [index:background:27] Health check
[2022-02-14 14:20:29] [indexer:background:27] Health check
[2022-02-14 14:20:29] [indexer:background:27] Health check
[2022-02-14 14:35:38] [index:background:27] Health check
[2022-02-14 14:35:38] [indexer:background:27] Health check
[2022-02-14 14:35:38] [indexer:background:27] Health check
[2022-02-14 14:41:56] [index:background:27] Health check
[2022-02-14 14:41:57] [indexer:background:27] Health check
[2022-02-14 14:41:57] [indexer:background:27] Health check
[2022-02-14 14:43:20] [index:background:27] Health check
[2022-02-14 14:44:07] [indexer:background:27] Health check
[2022-02-14 14:49:29] [index:background:27] Health check
[2022-02-14 14:49:29] [indexer:background:27] Health check
[2022-02-14 14:49:29] [indexer:background:27] Health check
[2022-02-14 14:52:42] [index:background:27] Health check
[2022-02-14 14:57:28] [indexer:background:27] Health check
[2022-02-14 14:57:35] [index:background:27] Health check
[2022-02-14 14:58:59] [indexer:background:27] Health check
[2022-02-14 15:02:37] [index:background:27] Health check
[2022-02-14 15:03:53] [indexer:background:27] Health check
[2022-02-14 15:05:50] [query:27] Query for: travel
[2022-02-14 15:05:50] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 15:05:50] [query:27] Engine: default
[2022-02-14 15:05:50] [query:27] Tokens: travelling, traveling, travellers, travelled, traveller, travel
[2022-02-14 15:05:50] [query:27] Mods: 2
[2022-02-14 15:05:50] [query:27] Using OR logic
[2022-02-14 15:05:50] [query:27] Found results using: and logic
[2022-02-14 15:05:50] [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 (493,4492,16291,29968,46286,2045) 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-14 15:05:50] [query:27] Results: 46 Pages of results: 10
[2022-02-14 15:05:50] [query:27] Execution time: 0.06241
[2022-02-14 15:07:40] [index:background:27] Health check
[2022-02-14 15:09:27] [indexer:background:27] Health check
[2022-02-14 15:12:38] [index:background:27] Health check
[2022-02-14 15:13:56] [indexer:background:27] Health check
[2022-02-14 15:17:38] [index:background:27] Health check
[2022-02-14 15:17:38] [query:27] Query for: cpd
[2022-02-14 15:17:38] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 15:17:38] [query:27] Engine: default
[2022-02-14 15:17:38] [query:27] Tokens: cpd
[2022-02-14 15:17:38] [query:27] Mods: 2
[2022-02-14 15:17:38] [query:27] Found results using: or logic
[2022-02-14 15:17: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 (4487) 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-14 15:17:38] [query:27] Results: 8 Pages of results: 2
[2022-02-14 15:17:38] [query:27] Execution time: 0.06241
[2022-02-14 15:19:18] [indexer:background:27] Health check
[2022-02-14 15:36:36] [index:background:27] Health check
[2022-02-14 15:36:36] [indexer:background:27] Health check
[2022-02-14 15:36:36] [indexer:background:27] Health check
[2022-02-14 15:37:39] [index:background:27] Health check
[2022-02-14 15:43:13] [indexer:background:27] Health check
[2022-02-14 15:43:13] [index:background:27] Health check
[2022-02-14 15:45:52] [indexer:background:27] Health check
[2022-02-14 15:49:35] [index:background:27] Health check
[2022-02-14 15:49:35] [indexer:background:27] Health check
[2022-02-14 15:49:35] [indexer:background:27] Health check
[2022-02-14 15:57:36] [index:background:27] Health check
[2022-02-14 15:57:36] [indexer:background:27] Health check
[2022-02-14 15:57:36] [indexer:background:27] Health check
[2022-02-14 15:57:41] [query:27] Query for: email
[2022-02-14 15:57:41] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 15:57:41] [query:27] Engine: default
[2022-02-14 15:57:41] [query:27] Tokens: emailed, emailing, emails, email
[2022-02-14 15:57:41] [query:27] Mods: 2
[2022-02-14 15:57:41] [query:27] Using OR logic
[2022-02-14 15:57:41] [query:27] Found results using: and logic
[2022-02-14 15:57: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 (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-14 15:57:41] [query:27] Results: 135 Pages of results: 27
[2022-02-14 15:57:41] [query:27] Execution time: 0.04680
[2022-02-14 15:58:00] [query:27] Query for: email
[2022-02-14 15:58:00] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 15:58:00] [query:27] Engine: default
[2022-02-14 15:58:00] [query:27] Tokens: emailed, emailing, emails, email
[2022-02-14 15:58:00] [query:27] Mods: 2
[2022-02-14 15:58:00] [query:27] Using OR logic
[2022-02-14 15:58:00] [query:27] Found results using: and logic
[2022-02-14 15:58: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 (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-14 15:58:00] [query:27] Results: 135 Pages of results: 27
[2022-02-14 15:58:00] [query:27] Execution time: 0.04680
[2022-02-14 15:59:01] [indexer:background:27] Health check
[2022-02-14 16:02:37] [index:background:27] Health check
[2022-02-14 16:03:52] [indexer:background:27] Health check
[2022-02-14 16:07:46] [index:background:27] Health check
[2022-02-14 16:08:56] [indexer:background:27] Health check
[2022-02-14 16:13:19] [index:background:27] Health check
[2022-02-14 16:14:19] [indexer:background:27] Health check
[2022-02-14 16:17:49] [index:background:27] Health check
[2022-02-14 16:19:05] [indexer:background:27] Health check
[2022-02-14 16:22:44] [index:background:27] Health check
[2022-02-14 16:24:12] [indexer:background:27] Health check
[2022-02-14 16:28:14] [index:background:27] Health check
[2022-02-14 16:30:15] [indexer:background:27] Health check
[2022-02-14 16:34:17] [index:background:27] Health check
[2022-02-14 16:34:17] [indexer:background:27] Health check
[2022-02-14 16:34:17] [indexer:background:27] Health check
[2022-02-14 16:37:51] [index:background:27] Health check
[2022-02-14 16:40:37] [indexer:background:27] Health check
[2022-02-14 16:42:37] [index:background:27] Health check
[2022-02-14 16:43:03] [query:27] Query for: finance
[2022-02-14 16:43:03] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all
[2022-02-14 16:43:03] [query:27] Engine: default
[2022-02-14 16:43:03] [query:27] Tokens: finance, financed, financi
[2022-02-14 16:43:03] [query:27] Mods: 2
[2022-02-14 16:43:03] [query:27] Using OR logic
[2022-02-14 16:43:03] [query:27] Found results using: and logic
[2022-02-14 16:43:03] [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-14 16:43:03] [query:27] Results: 30 Pages of results: 6
[2022-02-14 16:43:03] [query:27] Execution time: 0.09367
[2022-02-14 16:44:38] [indexer:background:27] Health check
[2022-02-14 16:48:40] [index:background:27] Health check
[2022-02-14 16:50:41] [indexer:background:27] Health check
[2022-02-14 16:53:08] [index:background:27] Health check
[2022-02-14 16:55:09] [indexer:background:27] Health check
[2022-02-14 16:57:53] [index:background:27] Health check
[2022-02-14 16:59:11] [indexer:background:27] Health check
[2022-02-14 17:02:36] [index:background:27] Health check
[2022-02-14 17:15:54] [indexer:background:27] Health check
[2022-02-14 17:15:54] [index:background:27] Health check
[2022-02-14 17:18:42] [index:background:27] Health check
[2022-02-14 17:18:53] [indexer:background:27] Health check
[2022-02-14 17:27:25] [index:background:27] Health check
[2022-02-14 17:27:25] [indexer:background:27] Health check
[2022-02-14 17:27:25] [indexer:background:27] Health check
[2022-02-14 17:34:53] [index:background:27] Health check
[2022-02-14 17:34:53] [indexer:background:27] Health check
[2022-02-14 17:34:53] [indexer:background:27] Health check
[2022-02-14 17:41:37] [index:background:27] Health check
[2022-02-14 17:41:37] [indexer:background:27] Health check
[2022-02-14 17:41:37] [indexer:background:27] Health check
[2022-02-14 17:52:00] [index:background:27] Health check
[2022-02-14 17:52:00] [indexer:background:27] Health check
[2022-02-14 17:52:00] [indexer:background:27] Health check
[2022-02-14 17:55:06] [index:background:27] Health check
[2022-02-14 17:55:06] [indexer:background:27] Health check
[2022-02-14 17:55:06] [indexer:background:27] Health check
[2022-02-14 18:00:03] [index:background:27] Health check
[2022-02-14 18:00:03] [indexer:background:27] Health check
[2022-02-14 18:00:03] [indexer:background:27] Health check
[2022-02-14 18:10:47] [index:background:27] Health check
[2022-02-14 18:10:47] [indexer:background:27] Health check
[2022-02-14 18:10:47] [indexer:background:27] Health check
[2022-02-14 18:27:39] [index:background:27] Health check
[2022-02-14 18:27:39] [indexer:background:27] Health check
[2022-02-14 18:27:39] [indexer:background:27] Health check
[2022-02-14 18:31:20] [indexer:background:27] Health check
[2022-02-14 18:35:34] [index:background:27] Health check
[2022-02-14 18:35:34] [indexer:background:27] Health check
[2022-02-14 18:35:34] [indexer:background:27] Health check
[2022-02-14 18:56:35] [index:background:27] Health check
[2022-02-14 18:56:35] [indexer:background:27] Health check
[2022-02-14 18:56:35] [indexer:background:27] Health check
[2022-02-14 19:01:30] [index:background:27] Health check
[2022-02-14 19:01:30] [indexer:background:27] Health check
[2022-02-14 19:01:30] [indexer:background:27] Health check
[2022-02-14 19:06:53] [index:background:27] Health check
[2022-02-14 19:06:53] [indexer:background:27] Health check
[2022-02-14 19:06:53] [indexer:background:27] Health check
[2022-02-14 19:07:51] [index:background:27] Health check
[2022-02-14 19:17:44] [indexer:background:27] Health check
[2022-02-14 19:17:44] [index:background:27] Health check
[2022-02-14 19:27:26] [indexer:background:27] Health check
[2022-02-14 19:27:26] [index:background:27] Health check
[2022-02-14 19:38:10] [index:background:27] Health check
[2022-02-14 19:38:10] [indexer:background:27] Health check
[2022-02-14 19:38:10] [indexer:background:27] Health check
[2022-02-14 19:38:59] [indexer:background:27] Health check
[2022-02-14 19:48:46] [index:background:27] Health check
[2022-02-14 19:48:46] [indexer:background:27] Health check
[2022-02-14 19:48:46] [indexer:background:27] Health check
[2022-02-14 19:49:34] [indexer:background:27] Health check
[2022-02-14 20:08:44] [index:background:27] Health check
[2022-02-14 20:08:44] [indexer:background:27] Health check
[2022-02-14 20:08:44] [indexer:background:27] Health check
[2022-02-14 20:10:53] [indexer:background:27] Health check
[2022-02-14 20:12:39] [index:background:27] Health check
[2022-02-14 20:14:26] [indexer:background:27] Health check
[2022-02-14 20:35:30] [index:background:27] Health check
[2022-02-14 20:35:30] [indexer:background:27] Health check
[2022-02-14 20:35:30] [indexer:background:27] Health check
[2022-02-14 20:41:39] [index:background:27] Health check
[2022-02-14 20:41:39] [indexer:background:27] Health check
[2022-02-14 20:41:39] [indexer:background:27] Health check
[2022-02-14 20:42:48] [index:background:27] Health check
[2022-02-14 20:45:53] [indexer:background:27] Health check
[2022-02-14 21:00:33] [index:background:27] Health check
[2022-02-14 21:00:33] [indexer:background:27] Health check
[2022-02-14 21:00:33] [indexer:background:27] Health check
[2022-02-14 21:07:17] [index:background:27] Health check
[2022-02-14 21:07:17] [indexer:background:27] Health check
[2022-02-14 21:07:17] [indexer:background:27] Health check
[2022-02-14 21:21:07] [index:background:27] Health check
[2022-02-14 21:21:07] [indexer:background:27] Health check
[2022-02-14 21:21:07] [indexer:background:27] Health check
[2022-02-14 21:23:39] [index:background:27] Health check
[2022-02-14 21:34:54] [indexer:background:27] Health check
[2022-02-14 21:34:54] [index:background:27] Health check
[2022-02-14 21:55:10] [index:background:27] Health check
[2022-02-14 21:55:10] [indexer:background:27] Health check
[2022-02-14 21:55:10] [indexer:background:27] Health check
[2022-02-14 21:57:53] [index:background:27] Health check
[2022-02-14 22:00:37] [indexer:background:27] Health check
[2022-02-14 22:11:46] [index:background:27] Health check
[2022-02-14 22:11:46] [indexer:background:27] Health check
[2022-02-14 22:11:46] [indexer:background:27] Health check
[2022-02-14 22:12:40] [index:background:27] Health check
[2022-02-14 22:29:11] [indexer:background:27] Health check
[2022-02-14 22:29:11] [index:background:27] Health check
[2022-02-14 22:35:54] [index:background:27] Health check
[2022-02-14 22:35:54] [indexer:background:27] Health check
[2022-02-14 22:35:54] [indexer:background:27] Health check
[2022-02-14 22:38:22] [index:background:27] Health check
[2022-02-14 22:39:13] [indexer:background:27] Health check
[2022-02-14 22:46:49] [index:background:27] Health check
[2022-02-14 22:46:49] [indexer:background:27] Health check
[2022-02-14 22:46:49] [indexer:background:27] Health check
[2022-02-14 22:48:28] [index:background:27] Health check
[2022-02-14 23:03:05] [indexer:background:27] Health check
[2022-02-14 23:03:05] [index:background:27] Health check
[2022-02-14 23:04:29] [indexer:background:27] Health check
[2022-02-14 23:35:18] [index:background:27] Health check
[2022-02-14 23:35:18] [indexer:background:27] Health check
[2022-02-14 23:35:18] [indexer:background:27] Health check