[2024-02-05 00:01:01] [indexer:background] Health check
[2024-02-05 00:01:01] [index:background] Health check
[2024-02-05 00:05:15] [indexer:background] Health check
[2024-02-05 00:05:33] [index:background] Health check
[2024-02-05 00:10:02] [indexer:background] Health check
[2024-02-05 00:10:36] [index:background] Health check
[2024-02-05 00:15:06] [indexer:background] Health check
[2024-02-05 00:17:27] [index:background] Health check
[2024-02-05 00:20:42] [indexer:background] Health check
[2024-02-05 00:20:42] [index:background] Health check
[2024-02-05 00:25:06] [indexer:background] Health check
[2024-02-05 00:25:34] [index:background] Health check
[2024-02-05 00:30:32] [indexer:background] Health check
[2024-02-05 00:30:32] [index:background] Health check
[2024-02-05 00:35:28] [indexer:background] Health check
[2024-02-05 00:35:28] [index:background] Health check
[2024-02-05 00:41:40] [indexer:background] Health check
[2024-02-05 00:41:40] [index:background] Health check
[2024-02-05 00:46:21] [indexer:background] Health check
[2024-02-05 00:46:21] [index:background] Health check
[2024-02-05 00:50:06] [indexer:background] Health check
[2024-02-05 00:50:29] [index:background] Health check
[2024-02-05 00:56:20] [indexer:background] Health check
[2024-02-05 00:56:20] [index:background] Health check
[2024-02-05 01:00:48] [indexer:background] Health check
[2024-02-05 01:00:54] [index:background] Health check
[2024-02-05 01:06:40] [indexer:background] Health check
[2024-02-05 01:06:40] [index:background] Health check
[2024-02-05 01:12:29] [indexer:background] Health check
[2024-02-05 01:12:29] [index:background] Health check
[2024-02-05 01:15:17] [indexer:background] Health check
[2024-02-05 01:16:37] [index:background] Health check
[2024-02-05 01:20:50] [indexer:background] Health check
[2024-02-05 01:20:50] [index:background] Health check
[2024-02-05 01:25:09] [indexer:background] Health check
[2024-02-05 01:26:26] [index:background] Health check
[2024-02-05 01:30:38] [indexer:background] Health check
[2024-02-05 01:30:38] [index:background] Health check
[2024-02-05 01:36:42] [indexer:background] Health check
[2024-02-05 01:36:42] [index:background] Health check
[2024-02-05 01:41:01] [indexer:background] Health check
[2024-02-05 01:41:01] [index:background] Health check
[2024-02-05 01:45:07] [indexer:background] Health check
[2024-02-05 01:46:01] [index:background] Health check
[2024-02-05 01:52:04] [indexer:background] Health check
[2024-02-05 01:52:05] [index:background] Health check
[2024-02-05 01:56:17] [indexer:background] Health check
[2024-02-05 01:56:17] [index:background] Health check
[2024-02-05 02:00:43] [indexer:background] Health check
[2024-02-05 02:00:43] [index:background] Health check
[2024-02-05 02:06:18] [indexer:background] Health check
[2024-02-05 02:06:18] [index:background] Health check
[2024-02-05 02:10:11] [indexer:background] Health check
[2024-02-05 02:12:05] [index:background] Health check
[2024-02-05 02:18:27] [indexer:background] Health check
[2024-02-05 02:18:27] [index:background] Health check
[2024-02-05 02:21:06] [indexer:background] Health check
[2024-02-05 02:21:06] [index:background] Health check
[2024-02-05 02:25:12] [indexer:background] Health check
[2024-02-05 02:26:15] [index:background] Health check
[2024-02-05 02:30:16] [indexer:background] Health check
[2024-02-05 02:30:50] [index:background] Health check
[2024-02-05 02:41:35] [indexer:background] Health check
[2024-02-05 02:41:35] [index:background] Health check
[2024-02-05 02:47:15] [indexer:background] Health check
[2024-02-05 02:47:15] [indexer:background] CPU load threshold (3) breached: 3.06 [waiting 2]
[2024-02-05 02:47:17] [index:background] Health check
[2024-02-05 02:51:23] [indexer:background] Health check
[2024-02-05 02:51:24] [indexer:background] CPU load threshold (3) breached: 3.47 [waiting 2]
[2024-02-05 02:51:26] [index:background] Health check
[2024-02-05 02:51:26] [index:background] CPU load threshold (3) breached: 3.47 [waiting 2]
[2024-02-05 02:51:28] [indexer:background] CPU load threshold (3) breached: 3.44 [waiting 2]
[2024-02-05 02:55:33] [indexer:background] Health check
[2024-02-05 02:55:33] [index:background] Health check
[2024-02-05 03:01:07] [indexer:background] Health check
[2024-02-05 03:01:07] [index:background] Health check
[2024-02-05 03:05:32] [indexer:background] Health check
[2024-02-05 03:05:32] [indexer:background] CPU load threshold (3) breached: 3.85 [waiting 2]
[2024-02-05 03:05:34] [index:background] Health check
[2024-02-05 03:05:34] [index:background] CPU load threshold (3) breached: 3.85 [waiting 2]
[2024-02-05 03:05:36] [indexer:background] CPU load threshold (3) breached: 3.85 [waiting 2]
[2024-02-05 03:12:10] [indexer:background] Health check
[2024-02-05 03:12:10] [indexer:background] CPU load threshold (3) breached: 3.21 [waiting 2]
[2024-02-05 03:12:12] [index:background] Health check
[2024-02-05 03:12:12] [index:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2024-02-05 03:12:14] [indexer:background] CPU load threshold (3) breached: 3.04 [waiting 2]
[2024-02-05 03:15:05] [indexer:background] Health check
[2024-02-05 03:15:05] [indexer:background] CPU load threshold (3) breached: 3.2 [waiting 2]
[2024-02-05 03:16:39] [index:background] Health check
[2024-02-05 03:20:07] [indexer:background] Health check
[2024-02-05 03:20:07] [indexer:background] CPU load threshold (3) breached: 3.6 [waiting 2]
[2024-02-05 03:21:13] [index:background] Health check
[2024-02-05 03:21:13] [index:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-02-05 03:21:15] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-02-05 03:25:26] [indexer:background] Health check
[2024-02-05 03:25:26] [indexer:background] CPU load threshold (3) breached: 3.4 [waiting 2]
[2024-02-05 03:25:28] [index:background] Health check
[2024-02-05 03:25:28] [index:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2024-02-05 03:25:30] [indexer:background] CPU load threshold (3) breached: 3.29 [waiting 2]
[2024-02-05 03:30:45] [indexer:background] Health check
[2024-02-05 03:30:45] [indexer:background] CPU load threshold (3) breached: 4.28 [waiting 2]
[2024-02-05 03:30:47] [index:background] Health check
[2024-02-05 03:30:47] [index:background] CPU load threshold (3) breached: 4.28 [waiting 2]
[2024-02-05 03:30:49] [indexer:background] CPU load threshold (3) breached: 4.1 [waiting 2]
[2024-02-05 03:35:28] [indexer:background] Health check
[2024-02-05 03:35:28] [indexer:background] CPU load threshold (3) breached: 3.37 [waiting 2]
[2024-02-05 03:35:30] [index:background] Health check
[2024-02-05 03:35:30] [index:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-02-05 03:35:32] [indexer:background] CPU load threshold (3) breached: 3.26 [waiting 2]
[2024-02-05 03:40:50] [indexer:background] Health check
[2024-02-05 03:40:50] [indexer:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-02-05 03:40:52] [index:background] Health check
[2024-02-05 03:40:52] [index:background] CPU load threshold (3) breached: 3.23 [waiting 2]
[2024-02-05 03:40:55] [indexer:background] CPU load threshold (3) breached: 3.54 [waiting 2]
[2024-02-05 03:46:01] [indexer:background] Health check
[2024-02-05 03:46:01] [index:background] Health check
[2024-02-05 03:51:15] [indexer:background] Health check
[2024-02-05 03:51:15] [indexer:background] CPU load threshold (3) breached: 3.78 [waiting 2]
[2024-02-05 03:51:17] [index:background] Health check
[2024-02-05 03:51:17] [index:background] CPU load threshold (3) breached: 3.78 [waiting 2]
[2024-02-05 03:51:19] [indexer:background] CPU load threshold (3) breached: 3.56 [waiting 2]
[2024-02-05 03:55:35] [indexer:background] Health check
[2024-02-05 03:55:35] [index:background] Health check
[2024-02-05 04:00:27] [indexer:background] Health check
[2024-02-05 04:00:27] [index:background] Health check
[2024-02-05 04:05:02] [indexer:background] Health check
[2024-02-05 04:09:02] [index:background] Health check
[2024-02-05 04:10:10] [indexer:background] Health check
[2024-02-05 04:10:45] [index:background] Health check
[2024-02-05 04:15:34] [indexer:background] Health check
[2024-02-05 04:15:35] [index:background] Health check
[2024-02-05 04:21:23] [indexer:background] Health check
[2024-02-05 04:21:24] [index:background] Health check
[2024-02-05 04:25:16] [indexer:background] Health check
[2024-02-05 04:25:26] [index:background] Health check
[2024-02-05 04:32:18] [indexer:background] Health check
[2024-02-05 04:32:18] [index:background] Health check
[2024-02-05 04:35:15] [indexer:background] Health check
[2024-02-05 04:35:36] [index:background] Health check
[2024-02-05 04:40:00] [indexer:background] Health check
[2024-02-05 04:42:30] [index:background] Health check
[2024-02-05 04:48:15] [indexer:background] Health check
[2024-02-05 04:48:15] [index:background] Health check
[2024-02-05 04:52:55] [indexer:background] Health check
[2024-02-05 04:52:55] [index:background] Health check
[2024-02-05 04:56:59] [indexer:background] Health check
[2024-02-05 04:56:59] [index:background] Health check
[2024-02-05 05:03:11] [indexer:background] Health check
[2024-02-05 05:03:11] [index:background] Health check
[2024-02-05 05:06:16] [indexer:background] Health check
[2024-02-05 05:06:16] [index:background] Health check
[2024-02-05 05:11:21] [indexer:background] Health check
[2024-02-05 05:11:21] [index:background] Health check
[2024-02-05 05:15:35] [indexer:background] Health check
[2024-02-05 05:15:36] [index:background] Health check
[2024-02-05 05:21:01] [indexer:background] Health check
[2024-02-05 05:21:01] [index:background] Health check
[2024-02-05 05:25:23] [indexer:background] Health check
[2024-02-05 05:25:23] [index:background] Health check
[2024-02-05 05:30:33] [indexer:background] Health check
[2024-02-05 05:30:33] [index:background] Health check
[2024-02-05 05:35:14] [indexer:background] Health check
[2024-02-05 05:36:21] [index:background] Health check
[2024-02-05 05:40:44] [indexer:background] Health check
[2024-02-05 05:40:44] [index:background] Health check
[2024-02-05 05:44:57] [indexer:background] Health check
[2024-02-05 05:45:43] [index:background] Health check
[2024-02-05 05:49:58] [indexer:background] Health check
[2024-02-05 05:50:34] [index:background] Health check
[2024-02-05 05:56:05] [indexer:background] Health check
[2024-02-05 05:56:05] [index:background] Health check
[2024-02-05 06:00:01] [indexer:background] Health check
[2024-02-05 06:01:12] [index:background] Health check
[2024-02-05 06:05:34] [indexer:background] Health check
[2024-02-05 06:05:34] [index:background] Health check
[2024-02-05 06:10:11] [indexer:background] Health check
[2024-02-05 06:11:06] [index:background] Health check
[2024-02-05 06:18:57] [indexer:background] Health check
[2024-02-05 06:18:57] [index:background] Health check
[2024-02-05 06:20:22] [indexer:background] Health check
[2024-02-05 06:20:44] [index:background] Health check
[2024-02-05 06:25:21] [indexer:background] Health check
[2024-02-05 06:27:56] [index:background] Health check
[2024-02-05 06:32:27] [indexer:background] Health check
[2024-02-05 06:32:27] [index:background] Health check
[2024-02-05 06:35:08] [indexer:background] Health check
[2024-02-05 06:35:25] [index:background] Health check
[2024-02-05 06:42:57] [indexer:background] Health check
[2024-02-05 06:42:58] [index:background] Health check
[2024-02-05 06:45:33] [indexer:background] Health check
[2024-02-05 06:45:34] [index:background] Health check
[2024-02-05 06:52:49] [indexer:background] Health check
[2024-02-05 06:52:49] [index:background] Health check
[2024-02-05 06:54:58] [indexer:background] Health check
[2024-02-05 06:55:37] [index:background] Health check
[2024-02-05 07:01:37] [indexer:background] Health check
[2024-02-05 07:01:38] [index:background] Health check
[2024-02-05 07:05:23] [indexer:background] Health check
[2024-02-05 07:05:23] [index:background] Health check
[2024-02-05 07:10:13] [indexer:background] Health check
[2024-02-05 07:10:27] [index:background] Health check
[2024-02-05 07:15:13] [indexer:background] Health check
[2024-02-05 07:15:26] [index:background] Health check
[2024-02-05 07:20:06] [indexer:background] Health check
[2024-02-05 07:21:36] [index:background] Health check
[2024-02-05 07:25:03] [indexer:background] Health check
[2024-02-05 07:26:29] [index:background] Health check
[2024-02-05 07:30:07] [indexer:background] Health check
[2024-02-05 07:30:26] [index:background] Health check
[2024-02-05 07:35:03] [indexer:background] Health check
[2024-02-05 07:36:38] [index:background] Health check
[2024-02-05 07:41:47] [indexer:background] Health check
[2024-02-05 07:41:47] [index:background] Health check
[2024-02-05 07:45:35] [indexer:background] Health check
[2024-02-05 07:45:35] [index:background] Health check
[2024-02-05 07:50:03] [indexer:background] Health check
[2024-02-05 07:51:11] [index:background] Health check
[2024-02-05 07:55:58] [indexer:background] Health check
[2024-02-05 07:55:58] [index:background] Health check
[2024-02-05 08:00:11] [indexer:background] Health check
[2024-02-05 08:00:28] [index:background] Health check
[2024-02-05 08:05:35] [indexer:background] Health check
[2024-02-05 08:05:35] [index:background] Health check
[2024-02-05 08:10:13] [indexer:background] Health check
[2024-02-05 08:11:05] [index:background] Health check
[2024-02-05 08:15:03] [indexer:background] Health check
[2024-02-05 08:15:24] [index:background] Health check
[2024-02-05 08:20:03] [indexer:background] Health check
[2024-02-05 08:20:41] [index:background] Health check
[2024-02-05 08:24:02] [query] Query for: wir machen c_s4ewm_1909 leichter zu bestehen! ☃ suchen sie jetzt auf ▶ www.itzert.com ◀ nach ➤ ⮘ um den kostenlosen download erhalten 🍨c_s4ewm_1909 fragen antworten
[2024-02-05 08:24:02] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 08:24:02] [query] Engine: default
[2024-02-05 08:24:03] [query] Tokens: sie, sier, sia, sies, sias, sié, siai, wire, 1909, machen s4ewm leicht bestehen ☃ suchen jetzt
[2024-02-05 08:24:03] [query] Mods: 6
[2024-02-05 08:24:03] [query] Using OR logic
[2024-02-05 08:24:03] [query] Found results using: or logic
[2024-02-05 08:24:03] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (10222,14664,24199,31685,232808,439470,739977,84235,70245,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 08:24:03] [query] Results: 201 Pages of results: 21
[2024-02-05 08:24:03] [query] Execution time: 1.33197
[2024-02-05 08:25:09] [indexer:background] Health check
[2024-02-05 08:25:33] [index:background] Health check
[2024-02-05 08:30:29] [indexer:background] Health check
[2024-02-05 08:30:29] [index:background] Health check
[2024-02-05 08:35:20] [indexer:background] Health check
[2024-02-05 08:35:24] [index:background] Health check
[2024-02-05 08:35:36] [query] Query for: wir machen c_s4ewm_1909 leichter zu bestehen! ☃ suchen sie jetzt auf ▶ www.itzert.com ◀ nach ➤ ⮘ um den kostenlosen download erhalten 🍨c_s4ewm_1909 fragen antworten
[2024-02-05 08:35:36] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 08:35:36] [query] Engine: default
[2024-02-05 08:35:36] [query] Tokens: sie, sier, sia, sies, sias, sié, siai, wire, 1909, machen s4ewm leicht bestehen ☃ suchen jetzt
[2024-02-05 08:35:36] [query] Mods: 6
[2024-02-05 08:35:36] [query] Using OR logic
[2024-02-05 08:35:36] [query] Found results using: or logic
[2024-02-05 08:35:37] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (10222,14664,24199,31685,232808,439470,739977,84235,70245,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 08:35:37] [query] Results: 201 Pages of results: 21
[2024-02-05 08:35:37] [query] Execution time: 0.04752
[2024-02-05 08:40:05] [indexer:background] Health check
[2024-02-05 08:40:28] [index:background] Health check
[2024-02-05 08:46:07] [indexer:background] Health check
[2024-02-05 08:46:07] [index:background] Health check
[2024-02-05 08:50:01] [indexer:background] Health check
[2024-02-05 08:50:41] [index:background] Health check
[2024-02-05 08:55:22] [indexer:background] Health check
[2024-02-05 08:56:39] [index:background] Health check
[2024-02-05 09:00:14] [indexer:background] Health check
[2024-02-05 09:01:38] [index:background] Health check
[2024-02-05 09:05:00] [indexer:background] Health check
[2024-02-05 09:05:40] [index:background] Health check
[2024-02-05 09:10:09] [indexer:background] Health check
[2024-02-05 09:11:45] [index:background] Health check
[2024-02-05 09:16:58] [indexer:background] Health check
[2024-02-05 09:16:58] [index:background] Health check
[2024-02-05 09:20:06] [indexer:background] Health check
[2024-02-05 09:20:47] [index:background] Health check
[2024-02-05 09:25:54] [indexer:background] Health check
[2024-02-05 09:25:54] [index:background] Health check
[2024-02-05 09:31:08] [indexer:background] Health check
[2024-02-05 09:31:08] [index:background] Health check
[2024-02-05 09:35:14] [indexer:background] Health check
[2024-02-05 09:36:39] [index:background] Health check
[2024-02-05 09:40:00] [indexer:background] Health check
[2024-02-05 09:40:30] [index:background] Health check
[2024-02-05 09:45:06] [indexer:background] Health check
[2024-02-05 09:45:06] [indexer:background] CPU load threshold (3) breached: 3.22 [waiting 2]
[2024-02-05 09:46:06] [index:background] Health check
[2024-02-05 09:50:12] [indexer:background] Health check
[2024-02-05 09:50:28] [index:background] Health check
[2024-02-05 09:55:29] [indexer:background] Health check
[2024-02-05 09:55:29] [index:background] Health check
[2024-02-05 10:00:18] [indexer:background] Health check
[2024-02-05 10:01:51] [index:background] Health check
[2024-02-05 10:05:18] [indexer:background] Health check
[2024-02-05 10:05:53] [index:background] Health check
[2024-02-05 10:12:46] [indexer:background] Health check
[2024-02-05 10:12:46] [index:background] Health check
[2024-02-05 10:16:01] [indexer:background] Health check
[2024-02-05 10:16:01] [index:background] Health check
[2024-02-05 10:21:30] [indexer:background] Health check
[2024-02-05 10:21:30] [index:background] Health check
[2024-02-05 10:25:10] [indexer:background] Health check
[2024-02-05 10:25:24] [index:background] Health check
[2024-02-05 10:31:32] [indexer:background] Health check
[2024-02-05 10:31:32] [index:background] Health check
[2024-02-05 10:35:38] [indexer:background] Health check
[2024-02-05 10:35:38] [index:background] Health check
[2024-02-05 10:40:18] [indexer:background] Health check
[2024-02-05 10:40:24] [index:background] Health check
[2024-02-05 10:45:18] [indexer:background] Health check
[2024-02-05 10:45:53] [index:background] Health check
[2024-02-05 10:50:10] [indexer:background] Health check
[2024-02-05 10:52:56] [index:background] Health check
[2024-02-05 10:53:00] [query] Query for: 2024
[2024-02-05 10:53:00] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 10:53:00] [query] Engine: default
[2024-02-05 10:53:01] [query] Tokens: 2024
[2024-02-05 10:53:01] [query] Mods: 6
[2024-02-05 10:53:01] [query] Found results using: or logic
[2024-02-05 10:53:01] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 10:53:01] [query] Results: 136 Pages of results: 14
[2024-02-05 10:53:01] [query] Execution time: 0.84361
[2024-02-05 10:55:43] [indexer:background] Health check
[2024-02-05 10:55:44] [index:background] Health check
[2024-02-05 11:00:07] [indexer:background] Health check
[2024-02-05 11:00:58] [index:background] Health check
[2024-02-05 11:04:59] [indexer:background] Health check
[2024-02-05 11:04:59] [indexer:background] CPU load threshold (3) breached: 3.09 [waiting 2]
[2024-02-05 11:05:31] [index:background] Health check
[2024-02-05 11:10:16] [indexer:background] Health check
[2024-02-05 11:10:36] [index:background] Health check
[2024-02-05 11:15:11] [indexer:background] Health check
[2024-02-05 11:15:23] [index:background] Health check
[2024-02-05 11:18:57] [query] Query for: 2024
[2024-02-05 11:18:57] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 11:18:57] [query] Engine: default
[2024-02-05 11:18:57] [query] Tokens: 2024
[2024-02-05 11:18:57] [query] Mods: 6
[2024-02-05 11:18:57] [query] Found results using: or logic
[2024-02-05 11:18:57] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 11:18:57] [query] Results: 136 Pages of results: 14
[2024-02-05 11:18:57] [query] Execution time: 0.03759
[2024-02-05 11:20:35] [indexer:background] Health check
[2024-02-05 11:20:35] [index:background] Health check
[2024-02-05 11:25:03] [indexer:background] Health check
[2024-02-05 11:26:26] [index:background] Health check
[2024-02-05 11:30:50] [indexer:background] Health check
[2024-02-05 11:30:50] [index:background] Health check
[2024-02-05 11:34:59] [indexer:background] Health check
[2024-02-05 11:35:23] [index:background] Health check
[2024-02-05 11:40:28] [indexer:background] Health check
[2024-02-05 11:40:28] [index:background] Health check
[2024-02-05 11:45:01] [indexer:background] Health check
[2024-02-05 11:45:52] [index:background] Health check
[2024-02-05 11:50:02] [indexer:background] Health check
[2024-02-05 11:50:55] [index:background] Health check
[2024-02-05 11:55:46] [indexer:background] Health check
[2024-02-05 11:55:46] [index:background] Health check
[2024-02-05 12:00:00] [indexer:background] Health check
[2024-02-05 12:00:49] [index:background] Health check
[2024-02-05 12:05:12] [indexer:background] Health check
[2024-02-05 12:05:34] [index:background] Health check
[2024-02-05 12:10:21] [indexer:background] Health check
[2024-02-05 12:11:08] [index:background] Health check
[2024-02-05 12:15:14] [indexer:background] Health check
[2024-02-05 12:16:24] [index:background] Health check
[2024-02-05 12:21:00] [indexer:background] Health check
[2024-02-05 12:21:00] [index:background] Health check
[2024-02-05 12:26:59] [indexer:background] Health check
[2024-02-05 12:26:59] [index:background] Health check
[2024-02-05 12:30:13] [indexer:background] Health check
[2024-02-05 12:30:25] [index:background] Health check
[2024-02-05 12:35:13] [indexer:background] Health check
[2024-02-05 12:36:10] [index:background] Health check
[2024-02-05 12:40:02] [indexer:background] Health check
[2024-02-05 12:43:13] [index:background] Health check
[2024-02-05 12:45:01] [indexer:background] Health check
[2024-02-05 12:48:42] [index:background] Health check
[2024-02-05 12:50:22] [indexer:background] Health check
[2024-02-05 12:51:38] [index:background] Health check
[2024-02-05 12:55:25] [indexer:background] Health check
[2024-02-05 12:55:25] [index:background] Health check
[2024-02-05 13:01:11] [indexer:background] Health check
[2024-02-05 13:01:11] [index:background] Health check
[2024-02-05 13:05:30] [indexer:background] Health check
[2024-02-05 13:05:30] [index:background] Health check
[2024-02-05 13:10:11] [indexer:background] Health check
[2024-02-05 13:11:02] [index:background] Health check
[2024-02-05 13:15:33] [indexer:background] Health check
[2024-02-05 13:15:33] [index:background] Health check
[2024-02-05 13:20:48] [indexer:background] Health check
[2024-02-05 13:20:48] [index:background] Health check
[2024-02-05 13:26:59] [indexer:background] Health check
[2024-02-05 13:26:59] [index:background] Health check
[2024-02-05 13:31:32] [indexer:background] Health check
[2024-02-05 13:31:33] [index:background] Health check
[2024-02-05 13:35:06] [indexer:background] Health check
[2024-02-05 13:36:29] [index:background] Health check
[2024-02-05 13:40:37] [indexer:background] Health check
[2024-02-05 13:40:37] [index:background] Health check
[2024-02-05 13:44:59] [indexer:background] Health check
[2024-02-05 13:46:07] [index:background] Health check
[2024-02-05 13:50:10] [indexer:background] Health check
[2024-02-05 13:50:47] [index:background] Health check
[2024-02-05 13:55:03] [indexer:background] Health check
[2024-02-05 13:55:59] [index:background] Health check
[2024-02-05 14:00:34] [indexer:background] Health check
[2024-02-05 14:00:35] [index:background] Health check
[2024-02-05 14:05:02] [indexer:background] Health check
[2024-02-05 14:05:37] [index:background] Health check
[2024-02-05 14:10:02] [indexer:background] Health check
[2024-02-05 14:10:37] [index:background] Health check
[2024-02-05 14:15:03] [indexer:background] Health check
[2024-02-05 14:15:26] [index:background] Health check
[2024-02-05 14:20:04] [indexer:background] Health check
[2024-02-05 14:21:00] [index:background] Health check
[2024-02-05 14:25:22] [indexer:background] Health check
[2024-02-05 14:25:37] [index:background] Health check
[2024-02-05 14:30:24] [indexer:background] Health check
[2024-02-05 14:30:24] [index:background] Health check
[2024-02-05 14:35:10] [indexer:background] Health check
[2024-02-05 14:35:25] [index:background] Health check
[2024-02-05 14:35:25] [index:background] CPU load threshold (3) breached: 4.05 [waiting 2]
[2024-02-05 14:35:27] [indexer:background] CPU load threshold (3) breached: 4.05 [waiting 2]
[2024-02-05 14:40:06] [indexer:background] Health check
[2024-02-05 14:40:06] [indexer:background] CPU load threshold (3) breached: 3.42 [waiting 2]
[2024-02-05 14:40:28] [index:background] Health check
[2024-02-05 14:40:28] [index:background] CPU load threshold (3) breached: 3.57 [waiting 2]
[2024-02-05 14:40:30] [indexer:background] CPU load threshold (3) breached: 3.61 [waiting 2]
[2024-02-05 14:45:01] [indexer:background] Health check
[2024-02-05 14:45:52] [index:background] Health check
[2024-02-05 14:47:45] [query] Query for: arrete-n�-12914_2014_finance-publique-impots-et-douanes_tresorerie-paierie-generale.pdf
[2024-02-05 14:47:45] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 14:47:45] [query] Engine: default
[2024-02-05 14:47:47] [query] Tokens: paierie, finances, finance, financer, financa, financée, financé, finançant, financant, financez, financera, financeront, financie, financs, financi, impots, financements, paieries, paieri, publiques, publique, publication, publications, publiquea, publicité, publicités, publiquement, publiqua, publiqui, publicateur, tresorerie, tresoreries, arrete, arrets, arreta, arrété, arreté, arretera, arreteront, arrèté, arretant, arrétées, arretea, arrète, financement, arreter, arréter, arretie, arrèt, arréte, douanes, douane, douanement, douani, douanies, arretes, douans, douana, financées, financés, arret, n�, 12914, 2014, financ, publiqu, impot, douan
[2024-02-05 14:47:47] [query] Mods: 6
[2024-02-05 14:47:48] [query] Skipping AND logic pass, too many token groups (10) use searchwp\query\logic\and\token_threshold filter to override current threshold (5)
[2024-02-05 14:47:48] [query] Using OR logic
[2024-02-05 14:47:55] [query] Found results using: or logic
[2024-02-05 14:47:55] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (108725,922,1221,8804,10800,15019,27032,27653,28790,34790,38664,147650,178508,418789,507839,4762,8009,473752,751413,866,1043,4943,5187,10823,13418,49505,77759,711996,763135,784579,17134,376646,17551,45128,51347,69901,69934,130628,219790,353841,376604,478327,503204,514969,858,28780,575556,586210,689535,799275,526,636,22019,245023,700272,4766,737898,804431,221,799,2865,770525,484734,1361,690302,692852,16968,709775) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 14:47:55] [query] Results: 3812 Pages of results: 382
[2024-02-05 14:47:55] [query] Execution time: 9.51618
[2024-02-05 14:50:23] [indexer:background] Health check
[2024-02-05 14:50:23] [index:background] Health check
[2024-02-05 14:55:07] [indexer:background] Health check
[2024-02-05 14:55:31] [index:background] Health check
[2024-02-05 15:00:16] [indexer:background] Health check
[2024-02-05 15:00:48] [index:background] Health check
[2024-02-05 15:04:59] [indexer:background] Health check
[2024-02-05 15:05:29] [index:background] Health check
[2024-02-05 15:10:03] [indexer:background] Health check
[2024-02-05 15:10:28] [index:background] Health check
[2024-02-05 15:15:09] [indexer:background] Health check
[2024-02-05 15:15:31] [index:background] Health check
[2024-02-05 15:15:31] [index:background] CPU load threshold (3) breached: 3.55 [waiting 2]
[2024-02-05 15:15:34] [indexer:background] CPU load threshold (3) breached: 4.23 [waiting 2]
[2024-02-05 15:20:02] [indexer:background] Health check
[2024-02-05 15:21:12] [index:background] Health check
[2024-02-05 15:25:05] [indexer:background] Health check
[2024-02-05 15:27:15] [index:background] Health check
[2024-02-05 15:31:18] [indexer:background] Health check
[2024-02-05 15:31:18] [index:background] Health check
[2024-02-05 15:35:05] [indexer:background] Health check
[2024-02-05 15:36:37] [index:background] Health check
[2024-02-05 15:40:07] [indexer:background] Health check
[2024-02-05 15:40:30] [index:background] Health check
[2024-02-05 15:44:59] [indexer:background] Health check
[2024-02-05 15:46:25] [index:background] Health check
[2024-02-05 15:50:37] [indexer:background] Health check
[2024-02-05 15:50:37] [index:background] Health check
[2024-02-05 15:55:49] [indexer:background] Health check
[2024-02-05 15:55:49] [index:background] Health check
[2024-02-05 16:00:08] [indexer:background] Health check
[2024-02-05 16:00:26] [index:background] Health check
[2024-02-05 16:05:16] [indexer:background] Health check
[2024-02-05 16:05:48] [index:background] Health check
[2024-02-05 16:10:29] [indexer:background] Health check
[2024-02-05 16:10:29] [index:background] Health check
[2024-02-05 16:15:01] [indexer:background] Health check
[2024-02-05 16:15:44] [index:background] Health check
[2024-02-05 16:20:26] [indexer:background] Health check
[2024-02-05 16:20:26] [index:background] Health check
[2024-02-05 16:25:06] [indexer:background] Health check
[2024-02-05 16:25:45] [index:background] Health check
[2024-02-05 16:29:59] [indexer:background] Health check
[2024-02-05 16:30:24] [index:background] Health check
[2024-02-05 16:34:59] [indexer:background] Health check
[2024-02-05 16:35:34] [index:background] Health check
[2024-02-05 16:39:58] [indexer:background] Health check
[2024-02-05 16:40:51] [index:background] Health check
[2024-02-05 16:45:14] [indexer:background] Health check
[2024-02-05 16:45:29] [index:background] Health check
[2024-02-05 16:50:04] [indexer:background] Health check
[2024-02-05 16:51:04] [index:background] Health check
[2024-02-05 16:55:02] [indexer:background] Health check
[2024-02-05 16:56:54] [index:background] Health check
[2024-02-05 17:00:51] [indexer:background] Health check
[2024-02-05 17:00:51] [index:background] Health check
[2024-02-05 17:05:07] [indexer:background] Health check
[2024-02-05 17:05:37] [index:background] Health check
[2024-02-05 17:10:37] [indexer:background] Health check
[2024-02-05 17:10:37] [index:background] Health check
[2024-02-05 17:15:07] [indexer:background] Health check
[2024-02-05 17:15:32] [index:background] Health check
[2024-02-05 17:20:07] [indexer:background] Health check
[2024-02-05 17:20:36] [index:background] Health check
[2024-02-05 17:25:06] [indexer:background] Health check
[2024-02-05 17:25:32] [index:background] Health check
[2024-02-05 17:29:04] [index] Marking post.page 14700 to be dropped
[2024-02-05 17:29:08] [index] Dropping post.page 14700
[2024-02-05 17:29:08] [indexer] Index built
[2024-02-05 17:29:10] [index] Marking post.page 14700 to be dropped
[2024-02-05 17:31:02] [indexer:background] Health check
[2024-02-05 17:31:02] [index:background] Health check
[2024-02-05 17:31:03] [index] Dropping post.page 14700
[2024-02-05 17:32:35] [query] Query for: search_term_string
[2024-02-05 17:32:35] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 17:32:35] [query] Engine: default
[2024-02-05 17:32:36] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-02-05 17:32:36] [query] Mods: 6
[2024-02-05 17:32:36] [query] Using OR logic
[2024-02-05 17:32:36] [query] Found results using: or logic
[2024-02-05 17:32:36] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 17:32:36] [query] Results: 1349 Pages of results: 135
[2024-02-05 17:32:36] [query] Execution time: 1.03373
[2024-02-05 17:35:35] [indexer:background] Health check
[2024-02-05 17:35:35] [index:background] Health check
[2024-02-05 17:40:38] [indexer:background] Health check
[2024-02-05 17:40:38] [index:background] Health check
[2024-02-05 17:45:11] [indexer:background] Health check
[2024-02-05 17:46:22] [index:background] Health check
[2024-02-05 17:49:43] [query] Query for: search_term_string
[2024-02-05 17:49:43] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 17:49:43] [query] Engine: default
[2024-02-05 17:49:43] [query] Tokens: terme, termes, termi, termea, terms, termis, search, term, string search_term_string
[2024-02-05 17:49:43] [query] Mods: 6
[2024-02-05 17:49:43] [query] Using OR logic
[2024-02-05 17:49:43] [query] Found results using: or logic
[2024-02-05 17:49:43] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (1065,1070,21699,55042,332977,353675,5265,333116,0) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 17:49:43] [query] Results: 1349 Pages of results: 135
[2024-02-05 17:49:43] [query] Execution time: 0.04536
[2024-02-05 17:50:15] [indexer:background] Health check
[2024-02-05 17:50:24] [index:background] Health check
[2024-02-05 17:51:34] [index] Marking post.attachment 14715 to be dropped
[2024-02-05 17:51:45] [index] Dropping post.attachment 14715
[2024-02-05 17:51:45] [indexer] Index built
[2024-02-05 17:52:08] [index] Marking post.attachment 14716 to be dropped
[2024-02-05 17:52:15] [index] Dropping post.attachment 14716
[2024-02-05 17:52:16] [indexer] Index built
[2024-02-05 17:53:04] [index] Marking post.attachment 14716 to be dropped
[2024-02-05 17:53:07] [index] Dropping post.attachment 14716
[2024-02-05 17:53:07] [indexer] Index built
[2024-02-05 17:53:46] [index] Marking post.page 14717 to be dropped
[2024-02-05 17:53:46] [index] Marking post.page 14718 to be dropped
[2024-02-05 17:53:49] [index] Dropping post.page 14717
[2024-02-05 17:53:49] [index] Dropping post.page 14718
[2024-02-05 17:53:49] [indexer] Queued next batch (2)
[2024-02-05 17:53:50] [indexer] Processing batch (2)
[2024-02-05 17:53:50] [indexer] Indexing post.page:14717
[2024-02-05 17:53:50] [index] Marking [1] post.page 14717 as indexed
[2024-02-05 17:53:50] [indexer] Indexing post.page:14718
[2024-02-05 17:53:50] [index] Marking [1] post.page 14718 as indexed
[2024-02-05 17:53:51] [indexer] Index built
[2024-02-05 17:55:11] [indexer:background] Health check
[2024-02-05 17:55:29] [index:background] Health check
[2024-02-05 17:59:58] [indexer:background] Health check
[2024-02-05 18:00:24] [index:background] Health check
[2024-02-05 18:05:02] [indexer:background] Health check
[2024-02-05 18:05:28] [index:background] Health check
[2024-02-05 18:08:08] [index] Marking post.attachment 14722 to be dropped
[2024-02-05 18:08:11] [index] Dropping post.attachment 14722
[2024-02-05 18:08:11] [indexer] Queued next batch (1)
[2024-02-05 18:08:12] [indexer] Processing batch (1)
[2024-02-05 18:08:12] [indexer] Indexing post.attachment:14722
[2024-02-05 18:08:35] [index] Marking [1] post.attachment 14722 as indexed
[2024-02-05 18:08:35] [indexer] Index built
[2024-02-05 18:08:35] [indexer:background] CPU load threshold (3) breached: 3.08 [waiting 2]
[2024-02-05 18:10:01] [indexer:background] Health check
[2024-02-05 18:10:26] [index:background] Health check
[2024-02-05 18:15:19] [indexer:background] Health check
[2024-02-05 18:15:24] [index:background] Health check
[2024-02-05 18:20:33] [indexer:background] Health check
[2024-02-05 18:20:33] [index:background] Health check
[2024-02-05 18:25:05] [indexer:background] Health check
[2024-02-05 18:26:23] [index:background] Health check
[2024-02-05 18:30:15] [indexer:background] Health check
[2024-02-05 18:30:39] [index:background] Health check
[2024-02-05 18:36:05] [indexer:background] Health check
[2024-02-05 18:36:05] [index:background] Health check
[2024-02-05 18:40:28] [indexer:background] Health check
[2024-02-05 18:40:28] [index:background] Health check
[2024-02-05 18:45:03] [indexer:background] Health check
[2024-02-05 18:45:45] [index:background] Health check
[2024-02-05 18:51:55] [indexer:background] Health check
[2024-02-05 18:51:55] [index:background] Health check
[2024-02-05 18:56:19] [indexer:background] Health check
[2024-02-05 18:56:20] [index:background] Health check
[2024-02-05 19:00:08] [indexer:background] Health check
[2024-02-05 19:00:39] [index:background] Health check
[2024-02-05 19:05:35] [indexer:background] Health check
[2024-02-05 19:05:35] [index:background] Health check
[2024-02-05 19:10:27] [indexer:background] Health check
[2024-02-05 19:10:27] [index:background] Health check
[2024-02-05 19:15:23] [indexer:background] Health check
[2024-02-05 19:15:23] [index:background] Health check
[2024-02-05 19:19:58] [indexer:background] Health check
[2024-02-05 19:20:34] [index:background] Health check
[2024-02-05 19:25:20] [indexer:background] Health check
[2024-02-05 19:26:26] [index:background] Health check
[2024-02-05 19:30:17] [indexer:background] Health check
[2024-02-05 19:30:36] [index:background] Health check
[2024-02-05 19:35:14] [indexer:background] Health check
[2024-02-05 19:35:51] [index:background] Health check
[2024-02-05 19:37:49] [query] Query for: 2024
[2024-02-05 19:37:49] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 19:37:49] [query] Engine: default
[2024-02-05 19:37:50] [query] Tokens: 2024
[2024-02-05 19:37:50] [query] Mods: 6
[2024-02-05 19:37:50] [query] Found results using: or logic
[2024-02-05 19:37:50] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 19:37:50] [query] Results: 136 Pages of results: 14
[2024-02-05 19:37:50] [query] Execution time: 0.56398
[2024-02-05 19:37:50] [query] Query for: 2024
[2024-02-05 19:37:50] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 100 page: 1 offset: 0 fields: all
[2024-02-05 19:37:50] [query] Engine: default
[2024-02-05 19:37:50] [query] Tokens: 2024
[2024-02-05 19:37:50] [query] Mods: 6
[2024-02-05 19:37:50] [query] Found results using: or logic
[2024-02-05 19:37:50] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 100
[2024-02-05 19:37:50] [query] Results: 136 Pages of results: 2
[2024-02-05 19:37:50] [query] Execution time: 0.09788
[2024-02-05 19:41:10] [indexer:background] Health check
[2024-02-05 19:41:10] [index:background] Health check
[2024-02-05 19:45:19] [indexer:background] Health check
[2024-02-05 19:45:57] [index:background] Health check
[2024-02-05 19:50:42] [indexer:background] Health check
[2024-02-05 19:50:42] [index:background] Health check
[2024-02-05 19:55:23] [indexer:background] Health check
[2024-02-05 19:55:23] [index:background] Health check
[2024-02-05 19:59:58] [indexer:background] Health check
[2024-02-05 20:00:39] [index:background] Health check
[2024-02-05 20:04:58] [indexer:background] Health check
[2024-02-05 20:07:15] [index:background] Health check
[2024-02-05 20:10:02] [indexer:background] Health check
[2024-02-05 20:10:24] [index:background] Health check
[2024-02-05 20:15:37] [indexer:background] Health check
[2024-02-05 20:15:37] [index:background] Health check
[2024-02-05 20:20:06] [indexer:background] Health check
[2024-02-05 20:20:40] [index:background] Health check
[2024-02-05 20:25:50] [indexer:background] Health check
[2024-02-05 20:25:50] [index:background] Health check
[2024-02-05 20:28:46] [query] Query for: 2024
[2024-02-05 20:28:46] [query] Arguments: engine: default (previously instantiated) mods: 0 site: all per_page: 10 page: 1 offset: 0 fields: all
[2024-02-05 20:28:46] [query] Engine: default
[2024-02-05 20:28:46] [query] Tokens: 2024
[2024-02-05 20:28:46] [query] Mods: 6
[2024-02-05 20:28:46] [query] Found results using: or logic
[2024-02-05 20:28:46] [query] 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 = 'post.post' AND (s.attribute IN ('title'))) OR (s.source = 'post.post' AND (s.attribute IN ('slug'))) OR (s.source = 'post.page' AND (s.attribute IN ('title'))) OR (s.source = 'post.page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('title'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('slug'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('slug'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('taxonomy.doc_categories'))) ) THEN 300 WHEN ( (s.source = 'post.post' AND (s.attribute IN ('content'))) OR (s.source = 'post.post' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.page' AND (s.attribute IN ('content'))) OR (s.source = 'post.page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('document_content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('content'))) OR (s.source = 'post.attachment' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('content'))) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('content'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('excerpt'))) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('meta.dlp_document_download'))) ) THEN 1 END)  ) AS relevance FROM mod441_searchwp_index s LEFT JOIN mod441_posts s1 ON (s1.ID = s.id) WHERE 1=1 AND 1=1 AND s.token IN (38018) AND 1=1 AND ((s.source = 'post.post' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'post' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'page' ) 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' ) )) OR (s.source = 'post.e-landing-page' AND (s.attribute IN ('title','content','slug','excerpt')) AND ( ( `s1`.`post_type` = 'e-landing-page' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) )) OR (s.source = 'post.dlp_document' AND (s.attribute IN ('title','content','slug','excerpt','meta.dlp_document_download','taxonomy.doc_categories')) AND ( ( `s1`.`post_type` = 'dlp_document' ) AND ( `s1`.`post_status` IN ( 'publish' ) ) ))) GROUP BY s.site,s.source,s.attribute,s.id) AS s LEFT JOIN mod441_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, 10
[2024-02-05 20:28:46] [query] Results: 136 Pages of results: 14
[2024-02-05 20:28:46] [query] Execution time: 0.04085
[2024-02-05 20:31:12] [indexer:background] Health check
[2024-02-05 20:31:12] [index:background] Health check
[2024-02-05 20:35:57] [indexer:background] Health check
[2024-02-05 20:35:57] [index:background] Health check
[2024-02-05 20:40:11] [indexer:background] Health check
[2024-02-05 20:40:31] [index:background] Health check
[2024-02-05 20:44:59] [indexer:background] Health check
[2024-02-05 20:45:56] [index:background] Health check
[2024-02-05 20:50:00] [indexer:background] Health check
[2024-02-05 20:51:49] [index:background] Health check
[2024-02-05 20:55:16] [indexer:background] Health check
[2024-02-05 20:56:08] [index:background] Health check
[2024-02-05 21:00:28] [indexer:background] Health check
[2024-02-05 21:00:28] [index:background] Health check
[2024-02-05 21:06:16] [indexer:background] Health check
[2024-02-05 21:06:16] [index:background] Health check
[2024-02-05 21:10:30] [indexer:background] Health check
[2024-02-05 21:10:30] [index:background] Health check
[2024-02-05 21:15:02] [indexer:background] Health check
[2024-02-05 21:15:51] [index:background] Health check
[2024-02-05 21:20:34] [indexer:background] Health check
[2024-02-05 21:20:34] [index:background] Health check
[2024-02-05 21:25:09] [indexer:background] Health check
[2024-02-05 21:28:32] [index:background] Health check
[2024-02-05 21:30:14] [indexer:background] Health check
[2024-02-05 21:30:59] [index:background] Health check
[2024-02-05 21:35:07] [indexer:background] Health check
[2024-02-05 21:36:36] [index:background] Health check
[2024-02-05 21:40:18] [indexer:background] Health check
[2024-02-05 21:40:43] [index:background] Health check
[2024-02-05 21:45:35] [indexer:background] Health check
[2024-02-05 21:45:35] [index:background] Health check
[2024-02-05 21:50:07] [indexer:background] Health check
[2024-02-05 21:51:26] [index:background] Health check
[2024-02-05 21:55:18] [indexer:background] Health check
[2024-02-05 21:55:26] [index:background] Health check
[2024-02-05 22:01:12] [indexer:background] Health check
[2024-02-05 22:01:12] [index:background] Health check
[2024-02-05 22:06:10] [indexer:background] Health check
[2024-02-05 22:06:10] [index:background] Health check
[2024-02-05 22:10:31] [indexer:background] Health check
[2024-02-05 22:10:31] [index:background] Health check
[2024-02-05 22:15:54] [indexer:background] Health check
[2024-02-05 22:15:54] [index:background] Health check
[2024-02-05 22:21:24] [indexer:background] Health check
[2024-02-05 22:21:24] [index:background] Health check
[2024-02-05 22:27:45] [indexer:background] Health check
[2024-02-05 22:27:45] [index:background] Health check
[2024-02-05 22:30:01] [indexer:background] Health check
[2024-02-05 22:31:41] [index:background] Health check
[2024-02-05 22:35:01] [indexer:background] Health check
[2024-02-05 22:36:44] [index:background] Health check
[2024-02-05 22:40:37] [indexer:background] Health check
[2024-02-05 22:40:37] [index:background] Health check
[2024-02-05 22:45:03] [indexer:background] Health check
[2024-02-05 22:47:03] [index:background] Health check
[2024-02-05 22:50:48] [indexer:background] Health check
[2024-02-05 22:50:48] [index:background] Health check
[2024-02-05 22:54:58] [indexer:background] Health check
[2024-02-05 22:56:30] [index:background] Health check
[2024-02-05 23:01:19] [indexer:background] Health check
[2024-02-05 23:01:19] [index:background] Health check
[2024-02-05 23:06:29] [indexer:background] Health check
[2024-02-05 23:06:29] [index:background] Health check
[2024-02-05 23:10:00] [indexer:background] Health check
[2024-02-05 23:10:26] [index:background] Health check
[2024-02-05 23:15:37] [indexer:background] Health check
[2024-02-05 23:15:37] [index:background] Health check
[2024-02-05 23:20:02] [indexer:background] Health check
[2024-02-05 23:20:30] [index:background] Health check
[2024-02-05 23:25:06] [indexer:background] Health check
[2024-02-05 23:25:36] [index:background] Health check
[2024-02-05 23:31:27] [indexer:background] Health check
[2024-02-05 23:31:27] [index:background] Health check
[2024-02-05 23:36:53] [indexer:background] Health check
[2024-02-05 23:36:53] [index:background] Health check
[2024-02-05 23:41:02] [indexer:background] Health check
[2024-02-05 23:41:02] [index:background] Health check
[2024-02-05 23:45:16] [indexer:background] Health check
[2024-02-05 23:45:32] [index:background] Health check
[2024-02-05 23:50:05] [indexer:background] Health check
[2024-02-05 23:50:52] [index:background] Health check
[2024-02-05 23:55:24] [indexer:background] Health check
[2024-02-05 23:55:24] [index:background] Health check