[2022-02-11 00:03:40] [indexer:background:27] Health check [2022-02-11 00:03:40] [index:background:27] Health check [2022-02-11 00:05:47] [indexer:background:27] Health check [2022-02-11 00:17:16] [index:background:27] Health check [2022-02-11 00:17:16] [indexer:background:27] Health check [2022-02-11 00:17:16] [indexer:background:27] Health check [2022-02-11 00:38:29] [index:background:27] Health check [2022-02-11 00:38:30] [indexer:background:27] Health check [2022-02-11 00:38:30] [indexer:background:27] Health check [2022-02-11 00:43:05] [indexer:background:27] Health check [2022-02-11 00:43:05] [index:background:27] Health check [2022-02-11 00:58:36] [indexer:background:27] Health check [2022-02-11 00:58:37] [index:background:27] Health check [2022-02-11 00:59:05] [indexer:background:27] Health check [2022-02-11 01:05:34] [index:background:27] Health check [2022-02-11 01:05:34] [indexer:background:27] Health check [2022-02-11 01:05:34] [indexer:background:27] Health check [2022-02-11 01:12:44] [index:background:27] Health check [2022-02-11 01:12:44] [indexer:background:27] Health check [2022-02-11 01:12:44] [indexer:background:27] Health check [2022-02-11 01:24:37] [indexer:background:27] Health check [2022-02-11 01:24:37] [index:background:27] Health check [2022-02-11 01:33:40] [index:background:27] Health check [2022-02-11 01:33:40] [indexer:background:27] Health check [2022-02-11 01:33:40] [indexer:background:27] Health check [2022-02-11 01:35:58] [indexer:background:27] Health check [2022-02-11 01:47:17] [index:background:27] Health check [2022-02-11 01:47:17] [indexer:background:27] Health check [2022-02-11 01:47:17] [indexer:background:27] Health check [2022-02-11 02:03:40] [index:background:27] Health check [2022-02-11 02:03:40] [indexer:background:27] Health check [2022-02-11 02:03:40] [indexer:background:27] Health check [2022-02-11 02:04:45] [indexer:background:27] Health check [2022-02-11 02:10:20] [index:background:27] Health check [2022-02-11 02:10:20] [indexer:background:27] Health check [2022-02-11 02:10:20] [indexer:background:27] Health check [2022-02-11 02:16:25] [index:background:27] Health check [2022-02-11 02:16:25] [indexer:background:27] Health check [2022-02-11 02:16:25] [indexer:background:27] Health check [2022-02-11 02:29:26] [index:background:27] Health check [2022-02-11 02:29:27] [indexer:background:27] Health check [2022-02-11 02:29:27] [indexer:background:27] Health check [2022-02-11 02:34:09] [index:background:27] Health check [2022-02-11 02:34:09] [indexer:background:27] Health check [2022-02-11 02:34:09] [indexer:background:27] Health check [2022-02-11 02:42:25] [index:background:27] Health check [2022-02-11 02:42:25] [indexer:background:27] Health check [2022-02-11 02:42:25] [indexer:background:27] Health check [2022-02-11 03:02:07] [index:background:27] Health check [2022-02-11 03:02:07] [indexer:background:27] Health check [2022-02-11 03:02:07] [indexer:background:27] Health check [2022-02-11 03:04:37] [index:background:27] Health check [2022-02-11 03:04:37] [indexer:background:27] Health check [2022-02-11 03:04:37] [indexer:background:27] Health check [2022-02-11 03:07:52] [index:background:27] Health check [2022-02-11 03:08:52] [indexer:background:27] Health check [2022-02-11 03:12:45] [index:background:27] Health check [2022-02-11 03:27:19] [indexer:background:27] Health check [2022-02-11 03:27:19] [index:background:27] Health check [2022-02-11 03:28:40] [index:background:27] Health check [2022-02-11 03:43:02] [indexer:background:27] Health check [2022-02-11 03:43:02] [index:background:27] Health check [2022-02-11 03:47:09] [indexer:background:27] Health check [2022-02-11 03:51:59] [index:background:27] Health check [2022-02-11 03:51:59] [indexer:background:27] Health check [2022-02-11 03:51:59] [indexer:background:27] Health check [2022-02-11 03:57:53] [index:background:27] Health check [2022-02-11 03:57:53] [indexer:background:27] Health check [2022-02-11 03:57:53] [indexer:background:27] Health check [2022-02-11 04:01:20] [indexer:background:27] Health check [2022-02-11 04:03:05] [index:background:27] Health check [2022-02-11 04:13:40] [indexer:background:27] Health check [2022-02-11 04:13:40] [index:background:27] Health check [2022-02-11 04:15:02] [indexer:background:27] Health check [2022-02-11 04:36:02] [index:background:27] Health check [2022-02-11 04:36:02] [indexer:background:27] Health check [2022-02-11 04:36:02] [indexer:background:27] Health check [2022-02-11 04:42:13] [index:background:27] Health check [2022-02-11 04:42:13] [indexer:background:27] Health check [2022-02-11 04:42:13] [indexer:background:27] Health check [2022-02-11 04:53:40] [index:background:27] Health check [2022-02-11 04:53:40] [indexer:background:27] Health check [2022-02-11 04:53:40] [indexer:background:27] Health check [2022-02-11 05:06:57] [indexer:background:27] Health check [2022-02-11 05:06:57] [index:background:27] Health check [2022-02-11 05:07:36] [index:background:27] Health check [2022-02-11 05:08:52] [indexer:background:27] Health check [2022-02-11 05:12:36] [index:background:27] Health check [2022-02-11 05:13:52] [indexer:background:27] Health check [2022-02-11 05:17:35] [index:background:27] Health check [2022-02-11 05:18:53] [indexer:background:27] Health check [2022-02-11 05:22:35] [index:background:27] Health check [2022-02-11 05:23:54] [indexer:background:27] Health check [2022-02-11 05:27:37] [index:background:27] Health check [2022-02-11 05:28:52] [indexer:background:27] Health check [2022-02-11 05:32:36] [index:background:27] Health check [2022-02-11 05:37:07] [indexer:background:27] Health check [2022-02-11 05:38:39] [index:background:27] Health check [2022-02-11 05:47:13] [indexer:background:27] Health check [2022-02-11 05:47:13] [index:background:27] Health check [2022-02-11 05:53:40] [index:background:27] Health check [2022-02-11 05:53:40] [indexer:background:27] Health check [2022-02-11 05:53:40] [indexer:background:27] Health check [2022-02-11 05:54:13] [indexer:background:27] Health check [2022-02-11 05:58:47] [index:background:27] Health check [2022-02-11 06:10:19] [indexer:background:27] Health check [2022-02-11 06:10:19] [index:background:27] Health check [2022-02-11 06:30:25] [index:background:27] Health check [2022-02-11 06:30:26] [indexer:background:27] Health check [2022-02-11 06:30:26] [indexer:background:27] Health check [2022-02-11 06:52:43] [index:background:27] Health check [2022-02-11 06:52:43] [indexer:background:27] Health check [2022-02-11 06:52:43] [indexer:background:27] Health check [2022-02-11 06:58:45] [indexer:background:27] Health check [2022-02-11 06:58:45] [index:background:27] Health check [2022-02-11 06:59:58] [indexer:background:27] Health check [2022-02-11 07:04:28] [index:background:27] Health check [2022-02-11 07:04:28] [indexer:background:27] Health check [2022-02-11 07:04:28] [indexer:background:27] Health check [2022-02-11 07:07:48] [index:background:27] Health check [2022-02-11 07:11:40] [indexer:background:27] Health check [2022-02-11 07:20:28] [index:background:27] Health check [2022-02-11 07:20:28] [indexer:background:27] Health check [2022-02-11 07:20:28] [indexer:background:27] Health check [2022-02-11 07:35:40] [index:background:27] Health check [2022-02-11 07:35:40] [indexer:background:27] Health check [2022-02-11 07:35:40] [indexer:background:27] Health check [2022-02-11 07:43:35] [index:background:27] Health check [2022-02-11 07:43:35] [indexer:background:27] Health check [2022-02-11 07:43:35] [indexer:background:27] Health check [2022-02-11 07:45:46] [indexer:background:27] Health check [2022-02-11 07:52:07] [index:background:27] Health check [2022-02-11 07:52:07] [indexer:background:27] Health check [2022-02-11 07:52:07] [indexer:background:27] Health check [2022-02-11 08:01:59] [index:background:27] Health check [2022-02-11 08:01:59] [indexer:background:27] Health check [2022-02-11 08:01:59] [indexer:background:27] Health check [2022-02-11 08:07:52] [index:background:27] Health check [2022-02-11 08:07:52] [indexer:background:27] Health check [2022-02-11 08:07:52] [indexer:background:27] Health check [2022-02-11 08:11:40] [indexer:background:27] Health check [2022-02-11 08:25:18] [index:background:27] Health check [2022-02-11 08:25:18] [indexer:background:27] Health check [2022-02-11 08:25:18] [indexer:background:27] Health check [2022-02-11 08:32:51] [index:background:27] Health check [2022-02-11 08:32:51] [indexer:background:27] Health check [2022-02-11 08:32:51] [indexer:background:27] Health check [2022-02-11 08:37:59] [indexer:background:27] Health check [2022-02-11 08:37:59] [index:background:27] Health check [2022-02-11 08:46:21] [indexer:background:27] Health check [2022-02-11 08:46:21] [index:background:27] Health check [2022-02-11 08:49:14] [index:background:27] Health check [2022-02-11 08:49:14] [indexer:background:27] Health check [2022-02-11 08:49:14] [indexer:background:27] Health check [2022-02-11 08:53:23] [index:background:27] Health check [2022-02-11 08:54:02] [indexer:background:27] Health check [2022-02-11 08:59:12] [index:background:27] Health check [2022-02-11 08:59:12] [indexer:background:27] Health check [2022-02-11 08:59:12] [indexer:background:27] Health check [2022-02-11 09:02:50] [index:background:27] Health check [2022-02-11 09:06:46] [indexer:background:27] Health check [2022-02-11 09:15:36] [index:background:27] Health check [2022-02-11 09:15:36] [indexer:background:27] Health check [2022-02-11 09:15:36] [indexer:background:27] Health check [2022-02-11 09:18:38] [index:background:27] Health check [2022-02-11 09:25:52] [indexer:background:27] Health check [2022-02-11 09:25:52] [index:background:27] Health check [2022-02-11 09:31:03] [index:background:27] Health check [2022-02-11 09:31:03] [indexer:background:27] Health check [2022-02-11 09:31:03] [indexer:background:27] Health check [2022-02-11 09:33:09] [index:background:27] Health check [2022-02-11 09:47:06] [indexer:background:27] Health check [2022-02-11 09:47:06] [index:background:27] Health check [2022-02-11 09:52:43] [index:background:27] Health check [2022-02-11 09:52:43] [indexer:background:27] Health check [2022-02-11 09:52:43] [indexer:background:27] Health check [2022-02-11 09:55:25] [indexer:background:27] Health check [2022-02-11 09:59:46] [index:background:27] Health check [2022-02-11 09:59:46] [indexer:background:27] Health check [2022-02-11 09:59:46] [indexer:background:27] Health check [2022-02-11 10:04:03] [index:background:27] Health check [2022-02-11 10:04:03] [indexer:background:27] Health check [2022-02-11 10:04:03] [indexer:background:27] Health check [2022-02-11 10:09:08] [index:background:27] Health check [2022-02-11 10:09:08] [indexer:background:27] Health check [2022-02-11 10:09:08] [indexer:background:27] Health check [2022-02-11 10:12:58] [index:background:27] Health check [2022-02-11 10:13:54] [indexer:background:27] Health check [2022-02-11 10:22:46] [index:background:27] Health check [2022-02-11 10:22:46] [indexer:background:27] Health check [2022-02-11 10:22:46] [indexer:background:27] Health check [2022-02-11 10:24:53] [indexer:background:27] Health check [2022-02-11 10:25:20] [query:27] Query for: finance guide [2022-02-11 10:25:20] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-11 10:25:20] [query:27] Engine: default [2022-02-11 10:25:20] [query:27] Tokens: finance, financed, financi, guide, guides, guiding, guided, guideli, guid [2022-02-11 10:25:20] [query:27] Mods: 2 [2022-02-11 10:25:20] [query:27] Trying AND logic [2022-02-11 10:25:20] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-11 10:25:20] [query:27] Skipping AND logic Source Attribute consideration (single Engine) [2022-02-11 10:25:20] [query:27] Found results using: and logic [2022-02-11 10:25:20] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (545,47254,48075,51,387,1122,2977,18500,18345) 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 ('4435', '4578', '9093', '9291', '9340', '9374', '9901', '9909') 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-11 10:25:20] [query:27] Results: 8 Pages of results: 2 [2022-02-11 10:25:20] [query:27] Execution time: 0.10921 [2022-02-11 10:25:31] [query:27] Query for: finance [2022-02-11 10:25:31] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-11 10:25:31] [query:27] Engine: default [2022-02-11 10:25:31] [query:27] Tokens: finance, financed, financi [2022-02-11 10:25:31] [query:27] Mods: 2 [2022-02-11 10:25:31] [query:27] Using OR logic [2022-02-11 10:25:31] [query:27] Found results using: and logic [2022-02-11 10:25: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 (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-11 10:25:31] [query:27] Results: 30 Pages of results: 6 [2022-02-11 10:25:31] [query:27] Execution time: 0.09361 [2022-02-11 10:30:07] [index:background:27] Health check [2022-02-11 10:30:07] [indexer:background:27] Health check [2022-02-11 10:30:07] [indexer:background:27] Health check [2022-02-11 10:36:05] [index:background:27] Health check [2022-02-11 10:36:05] [indexer:background:27] Health check [2022-02-11 10:36:05] [indexer:background:27] Health check [2022-02-11 10:43:31] [index:background:27] Health check [2022-02-11 10:43:31] [indexer:background:27] Health check [2022-02-11 10:43:31] [indexer:background:27] Health check [2022-02-11 10:46:02] [indexer:background:27] Health check [2022-02-11 10:47:40] [index:background:27] Health check [2022-02-11 10:53:27] [indexer:background:27] Health check [2022-02-11 10:53:27] [index:background:27] Health check [2022-02-11 10:55:43] [indexer:background:27] Health check [2022-02-11 10:58:44] [index:background:27] Health check [2022-02-11 11:01:21] [indexer:background:27] Health check [2022-02-11 11:04:18] [index:background:27] Health check [2022-02-11 11:04:18] [indexer:background:27] Health check [2022-02-11 11:04:18] [indexer:background:27] Health check [2022-02-11 11:10:24] [index:background:27] Health check [2022-02-11 11:10:24] [indexer:background:27] Health check [2022-02-11 11:10:24] [indexer:background:27] Health check [2022-02-11 11:23:58] [index:background:27] Health check [2022-02-11 11:23:58] [indexer:background:27] Health check [2022-02-11 11:23:58] [indexer:background:27] Health check [2022-02-11 11:34:56] [index:background:27] Health check [2022-02-11 11:34:56] [indexer:background:27] Health check [2022-02-11 11:34:56] [indexer:background:27] Health check [2022-02-11 11:38:30] [index:background:27] Health check [2022-02-11 11:40:30] [indexer:background:27] Health check [2022-02-11 11:41:33] [settings:27] Displaying options page [2022-02-11 11:41:48] [settings:27] Displaying options page [2022-02-11 11:42:52] [index:background:27] Health check [2022-02-11 11:44:24] [indexer:background:27] Health check [2022-02-11 11:47:41] [index:background:27] Health check [2022-02-11 11:49:24] [indexer:background:27] Health check [2022-02-11 11:52:40] [index:background:27] Health check [2022-02-11 11:54:20] [indexer:background:27] Health check [2022-02-11 11:59:24] [index:background:27] Health check [2022-02-11 11:59:24] [indexer:background:27] Health check [2022-02-11 11:59:24] [indexer:background:27] Health check [2022-02-11 12:11:59] [index:background:27] Health check [2022-02-11 12:11:59] [indexer:background:27] Health check [2022-02-11 12:11:59] [indexer:background:27] Health check [2022-02-11 12:16:55] [index:background:27] Health check [2022-02-11 12:16:55] [indexer:background:27] Health check [2022-02-11 12:16:56] [indexer:background:27] Health check [2022-02-11 12:19:53] [index:background:27] Health check [2022-02-11 12:19:53] [indexer:background:27] Health check [2022-02-11 12:19:53] [indexer:background:27] Health check [2022-02-11 12:24:57] [index:background:27] Health check [2022-02-11 12:24:57] [indexer:background:27] Health check [2022-02-11 12:24:57] [indexer:background:27] Health check [2022-02-11 12:27:52] [index:background:27] Health check [2022-02-11 12:32:02] [indexer:background:27] Health check [2022-02-11 12:36:03] [index:background:27] Health check [2022-02-11 12:36:03] [indexer:background:27] Health check [2022-02-11 12:36:04] [indexer:background:27] Health check [2022-02-11 12:39:11] [index:background:27] Health check [2022-02-11 12:39:11] [indexer:background:27] Health check [2022-02-11 12:39:11] [indexer:background:27] Health check [2022-02-11 12:39:30] [query:27] Query for: Absence [2022-02-11 12:39:30] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 7 page: 1 offset: 0 fields: ids [2022-02-11 12:39:30] [query:27] Engine: default [2022-02-11 12:39:30] [query:27] Tokens: absences, absence [2022-02-11 12:39:30] [query:27] Mods: 2 [2022-02-11 12:39:30] [query:27] Using OR logic [2022-02-11 12:39:30] [query:27] Found results using: and logic [2022-02-11 12:39:30] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (1853,3518) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 7 [2022-02-11 12:39:30] [query:27] Results: 65 Pages of results: 10 [2022-02-11 12:39:30] [query:27] Execution time: 0.01560 [2022-02-11 12:40:34] [query:27] Query for: Absences [2022-02-11 12:40:34] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 7 page: 1 offset: 0 fields: ids [2022-02-11 12:40:34] [query:27] Engine: default [2022-02-11 12:40:35] [query:27] Tokens: absences, absence [2022-02-11 12:40:35] [query:27] Mods: 2 [2022-02-11 12:40:35] [query:27] Using OR logic [2022-02-11 12:40:35] [query:27] Found results using: and logic [2022-02-11 12:40: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 (1853,3518) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 7 [2022-02-11 12:40:35] [query:27] Results: 65 Pages of results: 10 [2022-02-11 12:40:35] [query:27] Execution time: 0.03120 [2022-02-11 12:40:51] [query:27] Query for: Absences [2022-02-11 12:40:51] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 7 page: 1 offset: 0 fields: ids [2022-02-11 12:40:51] [query:27] Engine: default [2022-02-11 12:40:51] [query:27] Tokens: absences, absence [2022-02-11 12:40:51] [query:27] Mods: 2 [2022-02-11 12:40:51] [query:27] Using OR logic [2022-02-11 12:40:51] [query:27] Found results using: and logic [2022-02-11 12:40:51] [query:27] Request: SELECT SQL_CALC_FOUND_ROWS s.id,s.source,s.site,SUM(relevance) AS relevance FROM (SELECT s.id,s.source,s.site,s.attribute,((SUM(s.occurrences) * CASE WHEN ( (s.source IN ('post.post','post.attachment') AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) ) THEN 1 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('title'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) ) THEN 150 END) ) AS relevance FROM med_searchwp_index s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND s.site IN(27) AND s.token IN (1853,3518) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content','title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'attachment' ) AND ( `s1`.`post_status` = 'inherit' ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN med_27_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND (SUBSTRING(s.source, 1, 5) != 'post.' OR (SUBSTRING(s.source, 1, 5) = 'post.' AND s.id != '0')) GROUP BY s.site, s.source, s.id HAVING relevance > 0 ORDER BY relevance DESC LIMIT 0, 7 [2022-02-11 12:40:51] [query:27] Results: 65 Pages of results: 10 [2022-02-11 12:40:51] [query:27] Execution time: 0.01560 [2022-02-11 12:42:43] [index:background:27] Health check [2022-02-11 12:46:04] [indexer:background:27] Health check [2022-02-11 13:01:59] [index:background:27] Health check [2022-02-11 13:01:59] [indexer:background:27] Health check [2022-02-11 13:01:59] [indexer:background:27] Health check [2022-02-11 13:06:53] [index:background:27] Health check [2022-02-11 13:06:53] [indexer:background:27] Health check [2022-02-11 13:06:53] [indexer:background:27] Health check [2022-02-11 13:15:22] [index:background:27] Health check [2022-02-11 13:15:23] [indexer:background:27] Health check [2022-02-11 13:15:23] [indexer:background:27] Health check [2022-02-11 13:20:50] [index:background:27] Health check [2022-02-11 13:20:50] [indexer:background:27] Health check [2022-02-11 13:20:50] [indexer:background:27] Health check [2022-02-11 13:23:31] [index:background:27] Health check [2022-02-11 13:24:59] [indexer:background:27] Health check [2022-02-11 13:34:54] [index:background:27] Health check [2022-02-11 13:34:54] [indexer:background:27] Health check [2022-02-11 13:34:54] [indexer:background:27] Health check [2022-02-11 13:46:06] [index:background:27] Health check [2022-02-11 13:46:06] [indexer:background:27] Health check [2022-02-11 13:46:06] [indexer:background:27] Health check [2022-02-11 13:50:12] [index:background:27] Health check [2022-02-11 13:50:12] [indexer:background:27] Health check [2022-02-11 13:50:12] [indexer:background:27] Health check [2022-02-11 14:05:17] [index:background:27] Health check [2022-02-11 14:05:17] [indexer:background:27] Health check [2022-02-11 14:05:17] [indexer:background:27] Health check [2022-02-11 14:05:37] [query:27] Query for: LT [2022-02-11 14:05:37] [query:27] Arguments: engine: default (previously instantiated) mods: 0 site: 27 per_page: 5 page: 1 offset: 0 fields: all [2022-02-11 14:05:37] [query:27] Engine: default [2022-02-11 14:05:37] [query:27] Tokens: [2022-02-11 14:05:37] [query:27] Mods: 2 [2022-02-11 14:05:37] [query:27] Request: [2022-02-11 14:05:37] [query:27] Results: 0 Pages of results: 1 [2022-02-11 14:05:37] [query:27] Execution time: 0.00000 [2022-02-11 14:07:38] [index:background:27] Health check [2022-02-11 14:10:28] [indexer:background:27] Health check [2022-02-11 14:14:46] [index:background:27] Health check [2022-02-11 14:14:46] [indexer:background:27] Health check [2022-02-11 14:14:46] [indexer:background:27] Health check [2022-02-11 14:18:40] [index:background:27] Health check [2022-02-11 14:23:10] [indexer:background:27] Health check [2022-02-11 14:23:11] [index:background:27] Health check [2022-02-11 14:25:19] [indexer:background:27] Health check [2022-02-11 14:31:14] [index:background:27] Health check [2022-02-11 14:31:14] [indexer:background:27] Health check [2022-02-11 14:31:14] [indexer:background:27] Health check [2022-02-11 14:35:35] [index:background:27] Health check [2022-02-11 14:35:35] [indexer:background:27] Health check [2022-02-11 14:35:35] [indexer:background:27] Health check [2022-02-11 14:42:45] [index:background:27] Health check [2022-02-11 14:42:46] [indexer:background:27] Health check [2022-02-11 14:42:46] [indexer:background:27] Health check [2022-02-11 14:44:40] [indexer:background:27] Health check [2022-02-11 14:45:55] [index:27] Marking post.post 10227 to be dropped [2022-02-11 14:45:57] [index:27] Dropping post.post 10227 [2022-02-11 14:45:57] [indexer:27] Queued next batch (1) [2022-02-11 14:45:57] [indexer:27] Processing batch (1) [2022-02-11 14:45:57] [indexer:27] Indexing post.post:10227 [2022-02-11 14:45:57] [index:27] Marking [27] post.post 10227 as indexed [2022-02-11 14:45:57] [indexer:27] Index built [2022-02-11 14:57:54] [index:background:27] Health check [2022-02-11 14:57:54] [indexer:background:27] Health check [2022-02-11 14:57:54] [indexer:background:27] Health check [2022-02-11 14:59:15] [indexer:background:27] Health check [2022-02-11 15:05:05] [index:background:27] Health check [2022-02-11 15:05:05] [indexer:background:27] Health check [2022-02-11 15:05:05] [indexer:background:27] Health check [2022-02-11 15:25:21] [index:background:27] Health check [2022-02-11 15:25:21] [indexer:background:27] Health check [2022-02-11 15:25:21] [indexer:background:27] Health check [2022-02-11 15:27:40] [index:background:27] Health check [2022-02-11 15:33:17] [indexer:background:27] Health check [2022-02-11 15:33:17] [index:background:27] Health check [2022-02-11 15:33:52] [indexer:background:27] Health check [2022-02-11 15:38:38] [index:background:27] Health check [2022-02-11 15:39:28] [indexer:background:27] Health check [2022-02-11 15:50:47] [index:background:27] Health check [2022-02-11 15:50:47] [indexer:background:27] Health check [2022-02-11 15:50:47] [indexer:background:27] Health check [2022-02-11 15:54:06] [index:background:27] Health check [2022-02-11 15:54:06] [indexer:background:27] Health check [2022-02-11 15:54:06] [indexer:background:27] Health check [2022-02-11 15:59:10] [index:background:27] Health check [2022-02-11 15:59:10] [indexer:background:27] Health check [2022-02-11 15:59:10] [indexer:background:27] Health check [2022-02-11 16:02:35] [index:background:27] Health check [2022-02-11 16:03:52] [indexer:background:27] Health check [2022-02-11 16:11:38] [index:background:27] Health check [2022-02-11 16:11:38] [indexer:background:27] Health check [2022-02-11 16:11:38] [indexer:background:27] Health check [2022-02-11 16:15:14] [index:background:27] Health check [2022-02-11 16:15:15] [indexer:background:27] Health check [2022-02-11 16:15:15] [indexer:background:27] Health check [2022-02-11 16:24:52] [index:background:27] Health check [2022-02-11 16:24:52] [indexer:background:27] Health check [2022-02-11 16:24:52] [indexer:background:27] Health check [2022-02-11 16:31:14] [index:background:27] Health check [2022-02-11 16:31:14] [indexer:background:27] Health check [2022-02-11 16:31:14] [indexer:background:27] Health check [2022-02-11 16:36:10] [index:background:27] Health check [2022-02-11 16:36:10] [indexer:background:27] Health check [2022-02-11 16:36:10] [indexer:background:27] Health check [2022-02-11 16:51:39] [index:background:27] Health check [2022-02-11 16:51:39] [indexer:background:27] Health check [2022-02-11 16:51:39] [indexer:background:27] Health check [2022-02-11 16:53:15] [index:background:27] Health check [2022-02-11 17:08:42] [indexer:background:27] Health check [2022-02-11 17:08:42] [index:background:27] Health check [2022-02-11 17:09:48] [indexer:background:27] Health check [2022-02-11 17:12:51] [index:background:27] Health check [2022-02-11 17:14:18] [indexer:background:27] Health check [2022-02-11 17:24:44] [index:background:27] Health check [2022-02-11 17:24:44] [indexer:background:27] Health check [2022-02-11 17:24:44] [indexer:background:27] Health check [2022-02-11 17:33:09] [index:background:27] Health check [2022-02-11 17:33:09] [indexer:background:27] Health check [2022-02-11 17:33:09] [indexer:background:27] Health check [2022-02-11 17:39:24] [indexer:background:27] Health check [2022-02-11 17:39:24] [index:background:27] Health check [2022-02-11 17:42:48] [index:background:27] Health check [2022-02-11 17:44:23] [indexer:background:27] Health check [2022-02-11 17:56:21] [index:background:27] Health check [2022-02-11 17:56:21] [indexer:background:27] Health check [2022-02-11 17:56:21] [indexer:background:27] Health check [2022-02-11 18:01:59] [index:background:27] Health check [2022-02-11 18:01:59] [indexer:background:27] Health check [2022-02-11 18:01:59] [indexer:background:27] Health check [2022-02-11 18:10:50] [index:background:27] Health check [2022-02-11 18:10:50] [indexer:background:27] Health check [2022-02-11 18:10:50] [indexer:background:27] Health check [2022-02-11 18:15:31] [index:background:27] Health check [2022-02-11 18:15:31] [indexer:background:27] Health check [2022-02-11 18:15:31] [indexer:background:27] Health check [2022-02-11 18:17:42] [index:background:27] Health check [2022-02-11 18:29:35] [indexer:background:27] Health check [2022-02-11 18:29:35] [index:background:27] Health check [2022-02-11 18:32:35] [index:background:27] Health check [2022-02-11 18:33:52] [indexer:background:27] Health check [2022-02-11 18:37:35] [index:background:27] Health check [2022-02-11 18:38:52] [indexer:background:27] Health check [2022-02-11 18:48:30] [index:background:27] Health check [2022-02-11 18:48:30] [indexer:background:27] Health check [2022-02-11 18:48:30] [indexer:background:27] Health check [2022-02-11 19:11:11] [indexer:background:27] Health check [2022-02-11 19:11:11] [index:background:27] Health check [2022-02-11 19:12:47] [index:background:27] Health check [2022-02-11 19:15:36] [indexer:background:27] Health check [2022-02-11 19:21:32] [index:background:27] Health check [2022-02-11 19:21:32] [indexer:background:27] Health check [2022-02-11 19:21:32] [indexer:background:27] Health check [2022-02-11 19:25:55] [index:background:27] Health check [2022-02-11 19:25:56] [indexer:background:27] Health check [2022-02-11 19:25:56] [indexer:background:27] Health check [2022-02-11 19:30:04] [index:background:27] Health check [2022-02-11 19:30:04] [indexer:background:27] Health check [2022-02-11 19:30:04] [indexer:background:27] Health check [2022-02-11 19:35:08] [index:background:27] Health check [2022-02-11 19:35:09] [indexer:background:27] Health check [2022-02-11 19:35:09] [indexer:background:27] Health check [2022-02-11 19:44:51] [index:background:27] Health check [2022-02-11 19:44:51] [indexer:background:27] Health check [2022-02-11 19:44:51] [indexer:background:27] Health check [2022-02-11 19:49:46] [index:background:27] Health check [2022-02-11 19:49:46] [indexer:background:27] Health check [2022-02-11 19:49:46] [indexer:background:27] Health check [2022-02-11 19:53:28] [index:background:27] Health check [2022-02-11 20:09:54] [indexer:background:27] Health check [2022-02-11 20:09:54] [index:background:27] Health check [2022-02-11 20:14:51] [index:background:27] Health check [2022-02-11 20:14:51] [indexer:background:27] Health check [2022-02-11 20:14:51] [indexer:background:27] Health check [2022-02-11 20:21:18] [index:background:27] Health check [2022-02-11 20:21:18] [indexer:background:27] Health check [2022-02-11 20:21:18] [indexer:background:27] Health check [2022-02-11 20:28:41] [index:background:27] Health check [2022-02-11 20:28:41] [indexer:background:27] Health check [2022-02-11 20:28:41] [indexer:background:27] Health check [2022-02-11 20:32:53] [indexer:background:27] Health check [2022-02-11 20:32:53] [index:background:27] Health check [2022-02-11 20:41:13] [indexer:background:27] Health check [2022-02-11 20:41:13] [index:background:27] Health check [2022-02-11 20:49:00] [index:background:27] Health check [2022-02-11 20:49:00] [indexer:background:27] Health check [2022-02-11 20:49:00] [indexer:background:27] Health check [2022-02-11 20:54:31] [index:background:27] Health check [2022-02-11 20:54:31] [indexer:background:27] Health check [2022-02-11 20:54:31] [indexer:background:27] Health check [2022-02-11 20:59:25] [index:background:27] Health check [2022-02-11 20:59:25] [indexer:background:27] Health check [2022-02-11 20:59:25] [indexer:background:27] Health check [2022-02-11 21:08:56] [index:background:27] Health check [2022-02-11 21:08:56] [indexer:background:27] Health check [2022-02-11 21:08:56] [indexer:background:27] Health check [2022-02-11 21:15:49] [index:background:27] Health check [2022-02-11 21:15:49] [indexer:background:27] Health check [2022-02-11 21:15:49] [indexer:background:27] Health check [2022-02-11 21:17:44] [index:background:27] Health check [2022-02-11 21:22:38] [indexer:background:27] Health check [2022-02-11 21:22:38] [index:background:27] Health check [2022-02-11 21:31:09] [indexer:background:27] Health check [2022-02-11 21:31:09] [index:background:27] Health check [2022-02-11 21:34:51] [index:background:27] Health check [2022-02-11 21:34:51] [indexer:background:27] Health check [2022-02-11 21:34:51] [indexer:background:27] Health check [2022-02-11 21:39:03] [index:background:27] Health check [2022-02-11 21:39:03] [indexer:background:27] Health check [2022-02-11 21:39:03] [indexer:background:27] Health check [2022-02-11 21:43:17] [index:background:27] Health check [2022-02-11 21:45:24] [indexer:background:27] Health check [2022-02-11 21:52:42] [index:background:27] Health check [2022-02-11 21:52:42] [indexer:background:27] Health check [2022-02-11 21:52:42] [indexer:background:27] Health check [2022-02-11 21:54:51] [indexer:background:27] Health check [2022-02-11 22:01:59] [index:background:27] Health check [2022-02-11 22:01:59] [indexer:background:27] Health check [2022-02-11 22:01:59] [indexer:background:27] Health check [2022-02-11 22:02:43] [index:background:27] Health check [2022-02-11 22:04:49] [indexer:background:27] Health check [2022-02-11 22:12:09] [index:background:27] Health check [2022-02-11 22:12:09] [indexer:background:27] Health check [2022-02-11 22:12:09] [indexer:background:27] Health check [2022-02-11 22:14:51] [index:background:27] Health check [2022-02-11 22:14:51] [indexer:background:27] Health check [2022-02-11 22:14:51] [indexer:background:27] Health check [2022-02-11 22:23:06] [index:background:27] Health check [2022-02-11 22:23:06] [indexer:background:27] Health check [2022-02-11 22:23:06] [indexer:background:27] Health check [2022-02-11 22:36:13] [indexer:background:27] Health check [2022-02-11 22:36:13] [index:background:27] Health check [2022-02-11 22:40:37] [index:background:27] Health check [2022-02-11 22:40:37] [indexer:background:27] Health check [2022-02-11 22:40:37] [indexer:background:27] Health check [2022-02-11 22:54:05] [index:background:27] Health check [2022-02-11 22:54:05] [indexer:background:27] Health check [2022-02-11 22:54:05] [indexer:background:27] Health check [2022-02-11 23:01:27] [index:background:27] Health check [2022-02-11 23:01:27] [indexer:background:27] Health check [2022-02-11 23:01:27] [indexer:background:27] Health check [2022-02-11 23:12:47] [index:background:27] Health check [2022-02-11 23:12:47] [indexer:background:27] Health check [2022-02-11 23:12:47] [indexer:background:27] Health check [2022-02-11 23:28:55] [indexer:background:27] Health check [2022-02-11 23:28:55] [index:background:27] Health check [2022-02-11 23:34:51] [index:background:27] Health check [2022-02-11 23:34:51] [indexer:background:27] Health check [2022-02-11 23:34:51] [indexer:background:27] Health check [2022-02-11 23:42:56] [index:background:27] Health check [2022-02-11 23:42:56] [indexer:background:27] Health check [2022-02-11 23:42:56] [indexer:background:27] Health check [2022-02-11 23:46:06] [indexer:background:27] Health check [2022-02-11 23:48:45] [index:background:27] Health check