Defect #41965: Redmine 5.1.3 and MariaDB 10.6.18 - Queries are slow - Redmine

Actions

Copy link

Defect #41965

open

Redmine 5.1.3 and MariaDB 10.6.18 - Queries are slow

Added by Aleksandar Surbanoski 11 days ago. Updated 8 days ago.

Status:

Needs feedback

Priority:

Normal

Assignee:

Category:

UI - Responsive

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Affected version:

5.1.3

Description

Hi all,

Our queries are slow and when we got results moving between pages are also super slow. Please help us or give us some directions

sh: 1: svn: not found
sh: 1: hg: not found
sh: 1: cvs: not found
sh: 1: bzr: not found
Environment:
Redmine version 5.1.3.stable
Ruby version 3.0.2-p107 (2021-07-07) [x86_64-linux-gnu]
Rails version 6.1.7.8
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
Redmine settings:
Redmine theme Circle (includes JavaScript)
SCM:
Git 2.34.1
Filesystem
Redmine plugins:
no plugin installed

Thanks,

Actions

Copy link

Updated by Holger Just 11 days ago

Status changed from New to Needs feedback

Please provide much more details to allow us to reproduce your issue. See Submissions.

Please also provide reproducible details about your queries:

Which queries are you performing exactly?
How are they "slow"? Are you observing slow SQL queries, or general web responses, or some other component? Please try to debug this yourself and try to find the component which causes your issue within your server infrastructure. * Your issue may be caused by an overload of your SQL server, or webserver * It may also be caused by network issues between your computer and server. * It may also be caused by inefficient SQL queries with your specific set of data. * ...or a number of other possible issues.
Provide debug logs showing the queries (you may have to increase the log level by setting config.log_level = :debug in config/environments/production.rb and restarting Redmine).
If you see slow SQL queries, show the EXPLAIN output of the slow SQL query / queries. See https://mariadb.com/kb/en/explain/

Actions

Copy link

Updated by Aleksandar Surbanoski 11 days ago

Query - I should mention searching for text in search bar. I will check your suggestions and get back

Thanks,

Actions

Copy link

Updated by Aleksandar Surbanoski 9 days ago

Holger Just wrote in #note-1:

Please provide much more details to allow us to reproduce your issue. See Submissions.

Please also provide reproducible details about your queries:

Which queries are you performing exactly?

How are they "slow"? Are you observing slow SQL queries, or general web responses, or some other component? Please try to debug this yourself and try to find the component which causes your issue within your server infrastructure.

Your issue may be caused by an overload of your SQL server, or webserver

It may also be caused by network issues between your computer and server.

It may also be caused by inefficient SQL queries with your specific set of data.

...or a number of other possible issues.

Provide debug logs showing the queries (you may have to increase the log level by setting config.log_level = :debug in config/environments/production.rb and restarting Redmine).

If you see slow SQL queries, show the EXPLAIN output of the slow SQL query / queries. See https://mariadb.com/kb/en/explain/

DEBUG LOGS:

root@redminenew:/var/www/html/redmine/log# tail -f production.log
D, [2024-12-11T19:00:02.776985 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.777539 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.778194 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:02.778790 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.779568 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.780055 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.780663 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:02.781372 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.782129 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:02.782844 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:17.778155 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (14993.4ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `custom_values` ON `custom_values`.`customized_type` = 'Issue' AND `custom_values`.`customized_id` = `issues`.`id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND ((custom_values.custom_field_id IN (1,8,9,10,11,12,13,14,15,18,19,21,22,27,31,37,39,41,45,46,47,51,52,59,60,61) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = custom_values.custom_field_id)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = custom_values.custom_field_id) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = custom_values.custom_field_id)) AND (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))))))) AND (((custom_values.value LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:00:17.783810 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:17.784995 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:17.785755 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:17.786349 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
I, [2024-12-11T19:00:49.309432 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5] Started GET "/projects?jump=welcome" for 10.1.0.5 at 2024-12-11 19:00:49 +0100
I, [2024-12-11T19:00:49.310756 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5] Processing by ProjectsController#index as HTML
I, [2024-12-11T19:00:49.310820 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Parameters: {"jump"=>"welcome"}
D, [2024-12-11T19:00:49.314474 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]    (1.6ms)  SELECT MAX(`tokens`.`updated_on`) FROM `tokens` WHERE `tokens`.`user_id` = 374 AND `tokens`.`value` = '9aa69e28da6fe8ecc40a43aa5cda51dc2e48a4de' AND `tokens`.`action` = 'session'
D, [2024-12-11T19:00:49.317309 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Token Update All (1.2ms)  UPDATE `tokens` SET `tokens`.`updated_on` = '2024-12-11 19:00:49' WHERE `tokens`.`user_id` = 374 AND `tokens`.`value` = '9aa69e28da6fe8ecc40a43aa5cda51dc2e48a4de' AND `tokens`.`action` = 'session'
D, [2024-12-11T19:00:49.318262 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]    (0.5ms)  SELECT MAX(`settings`.`updated_on`) FROM `settings`
D, [2024-12-11T19:00:49.319875 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   User Load (0.7ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND `users`.`id` = 374 LIMIT 1
I, [2024-12-11T19:00:49.320184 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Current user: surbanoski.aleksandar (id=374)
D, [2024-12-11T19:00:49.322232 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   UserPreference Load (1.0ms)  SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 374 LIMIT 1
D, [2024-12-11T19:00:49.324072 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'default_project_query' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:49.351769 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Member Exists? (2.5ms)  SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 LIMIT 1
D, [2024-12-11T19:00:49.353472 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   ProjectCustomField Load (0.7ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'ProjectCustomField' AND (custom_fields.visible = TRUE OR custom_fields.id IN (SELECT DISTINCT cfr.custom_field_id FROM members m INNER JOIN member_roles mr ON mr.member_id = m.id INNER JOIN custom_fields_roles cfr ON cfr.role_id = mr.role_id WHERE m.user_id = 374)) AND `custom_fields`.`is_filter` = TRUE ORDER BY `custom_fields`.`position` ASC
D, [2024-12-11T19:00:49.354528 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'project_list_display_type' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:49.355556 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE Member Exists? (0.0ms)  SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 LIMIT 1
D, [2024-12-11T19:00:49.356381 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   ProjectCustomField Load (0.4ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'ProjectCustomField' AND (custom_fields.visible = TRUE OR custom_fields.id IN (SELECT DISTINCT cfr.custom_field_id FROM members m INNER JOIN member_roles mr ON mr.member_id = m.id INNER JOIN custom_fields_roles cfr ON cfr.role_id = mr.role_id WHERE m.user_id = 374)) ORDER BY `custom_fields`.`position` ASC
D, [2024-12-11T19:00:49.357644 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Role Load (0.5ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1
D, [2024-12-11T19:00:49.359570 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   GroupNonMember Load (0.8ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.360568 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]    (0.2ms)  SELECT `users`.`id` FROM `users` WHERE `users`.`type` = 'GroupNonMember' LIMIT 1
D, [2024-12-11T19:00:49.368794 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]    (7.1ms)  SELECT `members`.`user_id`, `role_id`, `members`.`project_id` FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` INNER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` WHERE (projects.status <> 9) AND (members.user_id = 374 OR (projects.is_public = TRUE AND members.user_id = 124))
D, [2024-12-11T19:00:49.369800 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Role Load (0.2ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`id` IN (10, 3)
D, [2024-12-11T19:00:49.373560 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Setting Load (0.3ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'project_list_defaults' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:49.375661 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Project Load (0.8ms)  SELECT `projects`.* FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND ((projects.status IN ('1'))) ORDER BY projects.lft ASC
D, [2024-12-11T19:00:49.379295 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendering layout layouts/base.html.erb
D, [2024-12-11T19:00:49.379458 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendering projects/index.html.erb within layouts/base
D, [2024-12-11T19:00:49.388930 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Role Load (4.1ms)  SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `member_roles` ON `member_roles`.`role_id` = `roles`.`id` INNER JOIN `members` ON `members`.`id` = `member_roles`.`member_id` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE (projects.status <> 9) AND `members`.`user_id` = 374
D, [2024-12-11T19:00:49.399407 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'start_of_week' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:49.400309 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered queries/_filters.html.erb (Duration: 7.0ms | Allocations: 4152)
D, [2024-12-11T19:00:49.403889 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered queries/_columns.html.erb (Duration: 2.4ms | Allocations: 1122)
D, [2024-12-11T19:00:49.405193 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered queries/_query_form.html.erb (Duration: 14.4ms | Allocations: 7575)
D, [2024-12-11T19:00:49.409493 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]    (0.5ms)  SELECT `projects`.`id` FROM `projects` INNER JOIN `members` ON `projects`.`id` = `members`.`project_id` INNER JOIN `projects` `projects_members` ON `projects_members`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9
D, [2024-12-11T19:00:49.411003 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Setting Load (0.3ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'text_formatting' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:49.411816 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'cache_formatted_text' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:49.422116 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered projects/_board.html.erb (Duration: 16.0ms | Allocations: 9128)
D, [2024-12-11T19:00:49.424315 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.425484 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE Member Exists? (0.0ms)  SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 LIMIT 1
D, [2024-12-11T19:00:49.430120 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   ProjectQuery Load (3.7ms)  SELECT `queries`.* FROM `queries` LEFT OUTER JOIN projects ON queries.project_id = projects.id WHERE `queries`.`type` = 'ProjectQuery' AND (queries.project_id IS NULL OR (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND (queries.visibility = 2 OR (queries.visibility = 1 AND queries.id IN (SELECT DISTINCT q.id FROM queries q INNER JOIN queries_roles qr on qr.query_id = q.id INNER JOIN member_roles mr ON mr.role_id = qr.role_id INNER JOIN members m ON m.id = mr.member_id AND m.user_id = 374 INNER JOIN projects p ON p.id = m.project_id AND p.status <> 9 WHERE q.project_id IS NULL OR q.project_id = m.project_id)) OR queries.user_id = 374) AND `queries`.`project_id` IS NULL ORDER BY `queries`.`name` ASC, `queries`.`id` ASC
D, [2024-12-11T19:00:49.430503 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered projects/_sidebar.html.erb (Duration: 7.7ms | Allocations: 1236)
D, [2024-12-11T19:00:49.432730 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Token Load (1.0ms)  SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`user_id` = 374 AND (action='feeds') LIMIT 1
I, [2024-12-11T19:00:49.433266 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered projects/index.html.erb within layouts/base (Duration: 53.7ms | Allocations: 21161)
D, [2024-12-11T19:00:49.437874 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Project Load (0.5ms)  SELECT `projects`.`id`, `projects`.`name`, `projects`.`identifier`, `projects`.`lft`, `projects`.`rgt` FROM `projects` INNER JOIN `members` ON `projects`.`id` = `members`.`project_id` INNER JOIN `projects` `projects_members` ON `projects_members`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 AND `projects`.`status` = 1
D, [2024-12-11T19:00:49.439227 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.440045 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.440952 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Project Load (0.3ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (13, 48, 79) AND (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))
D, [2024-12-11T19:00:49.449422 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.458074 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   EnabledModule Exists? (2.1ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'issue_tracking' LIMIT 1
D, [2024-12-11T19:00:49.458985 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.460332 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'time_tracking' LIMIT 1
D, [2024-12-11T19:00:49.461158 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.462587 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'gantt' LIMIT 1
D, [2024-12-11T19:00:49.463347 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.464798 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   EnabledModule Exists? (0.7ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'calendar' LIMIT 1
D, [2024-12-11T19:00:49.465565 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:49.466909 #1398969] DEBUG -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'news' LIMIT 1
I, [2024-12-11T19:00:49.467530 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5]   Rendered layout layouts/base.html.erb (Duration: 88.1ms | Allocations: 36104)
I, [2024-12-11T19:00:49.467897 #1398969]  INFO -- : [7a5ced73-6e6f-462a-a102-4b7854ae19b5] Completed 200 OK in 157ms (Views: 70.6ms | ActiveRecord: 46.3ms | Allocations: 56228)
I, [2024-12-11T19:00:54.488696 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa] Started GET "/search?utf8=%E2%9C%93&scope=&q=test" for 10.1.0.5 at 2024-12-11 19:00:54 +0100
I, [2024-12-11T19:00:54.489630 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa] Processing by SearchController#index as HTML
I, [2024-12-11T19:00:54.489692 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Parameters: {"utf8"=>"✓", "scope"=>"", "q"=>"test"}
D, [2024-12-11T19:00:54.492530 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (1.2ms)  SELECT MAX(`tokens`.`updated_on`) FROM `tokens` WHERE `tokens`.`user_id` = 374 AND `tokens`.`value` = '9aa69e28da6fe8ecc40a43aa5cda51dc2e48a4de' AND `tokens`.`action` = 'session'
D, [2024-12-11T19:00:54.493583 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (0.5ms)  SELECT MAX(`settings`.`updated_on`) FROM `settings`
D, [2024-12-11T19:00:54.495056 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   User Load (0.7ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND `users`.`id` = 374 LIMIT 1
I, [2024-12-11T19:00:54.495316 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Current user: surbanoski.aleksandar (id=374)
D, [2024-12-11T19:00:54.509103 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Role Load (12.8ms)  SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `member_roles` ON `member_roles`.`role_id` = `roles`.`id` INNER JOIN `members` ON `members`.`id` = `member_roles`.`member_id` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE (projects.status <> 9) AND `members`.`user_id` = 374
D, [2024-12-11T19:00:54.509968 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Role Load (0.2ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1
D, [2024-12-11T19:00:54.511567 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Setting Load (0.5ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'search_results_per_page' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:00:54.514025 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   GroupNonMember Load (0.8ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:00:54.514766 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (0.2ms)  SELECT `users`.`id` FROM `users` WHERE `users`.`type` = 'GroupNonMember' LIMIT 1
D, [2024-12-11T19:00:54.517187 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (1.6ms)  SELECT `members`.`user_id`, `role_id`, `members`.`project_id` FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` INNER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` WHERE (projects.status <> 9) AND (members.user_id = 374 OR (projects.is_public = TRUE AND members.user_id = 124))
D, [2024-12-11T19:00:54.518040 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Role Load (0.2ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`id` IN (10, 3)
D, [2024-12-11T19:00:54.525280 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (0.6ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:54.526103 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:00:54.527067 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.841095 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (9307.4ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND (((subject LIKE '%test%') OR (issues.description LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:01:03.897573 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CustomField Load (0.9ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'IssueCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:01:03.920286 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.921479 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.922092 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.922600 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.923132 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.923740 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.924256 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.924737 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.925218 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.925998 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.926487 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.926958 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.927422 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.928036 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.928534 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.929008 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.929501 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.930264 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.930747 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.931221 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.931682 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.932249 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.932726 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.933206 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.933661 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.934453 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.934959 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.935443 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.935930 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.936524 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.937007 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.937471 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.937952 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.938539 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.939169 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.939642 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.940095 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.940668 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.941156 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.941640 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.942131 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.942855 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.943354 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.943852 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.944308 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.944869 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.945343 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.945845 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.946318 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.946896 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.947598 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.948072 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.948523 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.949113 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.949586 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.950074 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.950529 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.951103 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.951770 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.952250 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.952700 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.953275 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.953750 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.954229 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.954674 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.955266 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.955930 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.956409 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.956867 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.957434 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.957906 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.958390 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.958836 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.959400 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.960052 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.960530 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.960985 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.961564 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.962206 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.962693 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.963165 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.963740 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.964394 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.964884 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.965349 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.965945 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.966429 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.966901 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.967356 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.967930 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.968587 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.969070 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.969525 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.970111 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.970595 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.971062 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.971522 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.972106 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.972717 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.973208 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.973669 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.974261 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.974746 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.975242 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.975865 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:03.976448 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.977093 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:03.977578 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:07.978980 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (50184.6ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `journals` ON `journals`.`journalized_type` = 'Issue' AND `journals`.`journalized_id` = `issues`.`id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND (journals.private_notes = FALSE OR (1=0)) AND (((journals.notes LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:01:08.077756 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.088376 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (3.4ms)  SELECT DISTINCT `news`.`created_on`, `news`.`id` FROM `news` INNER JOIN `projects` ON `projects`.`id` = `news`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='news')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (summary LIKE '%test%') OR (news.description LIKE '%test%'))) ORDER BY `news`.`created_on` DESC, `news`.`id` DESC
D, [2024-12-11T19:01:08.089596 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.100240 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (4.7ms)  SELECT DISTINCT `documents`.`created_on`, `documents`.`id` FROM `documents` INNER JOIN `projects` ON `projects`.`id` = `documents`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='documents')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (documents.description LIKE '%test%'))) ORDER BY `documents`.`created_on` DESC, `documents`.`id` DESC
D, [2024-12-11T19:01:08.101553 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CustomField Load (0.6ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'DocumentCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:01:08.102508 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.109995 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (0.9ms)  SELECT DISTINCT `changesets`.`committed_on`, `changesets`.`id` FROM `changesets` INNER JOIN `repositories` ON `repositories`.`id` = `changesets`.`repository_id` INNER JOIN `projects` ON `projects`.`id` = `repositories`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='repository')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124)))))) AND (((comments LIKE '%test%'))) ORDER BY `changesets`.`committed_on` DESC, `changesets`.`id` DESC
D, [2024-12-11T19:01:08.110726 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.121193 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (3.9ms)  SELECT DISTINCT `wiki_pages`.`created_on`, `wiki_pages`.`id` FROM `wiki_pages` INNER JOIN `wiki_contents` ON `wiki_contents`.`page_id` = `wiki_pages`.`id` INNER JOIN `wikis` ON `wikis`.`id` = `wiki_pages`.`wiki_id` INNER JOIN `projects` ON `projects`.`id` = `wikis`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='wiki')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (wiki_contents.text LIKE '%test%'))) ORDER BY `wiki_pages`.`created_on` DESC, `wiki_pages`.`id` DESC
D, [2024-12-11T19:01:08.122339 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.130777 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (1.0ms)  SELECT DISTINCT `messages`.`created_on`, `messages`.`id` FROM `messages` INNER JOIN `boards` ON `boards`.`id` = `messages`.`board_id` INNER JOIN `projects` ON `projects`.`id` = `boards`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='boards')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((subject LIKE '%test%') OR (content LIKE '%test%'))) ORDER BY `messages`.`created_on` DESC, `messages`.`id` DESC
D, [2024-12-11T19:01:08.131497 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.133467 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]    (1.2ms)  SELECT DISTINCT `projects`.`created_on`, `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((name LIKE '%test%') OR (identifier LIKE '%test%') OR (description LIKE '%test%'))) ORDER BY `projects`.`created_on` DESC, `projects`.`id` DESC
D, [2024-12-11T19:01:08.134335 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CustomField Load (0.3ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'ProjectCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:01:08.182143 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Issue Load (1.4ms)  SELECT `issues`.* FROM `issues` WHERE `issues`.`id` IN (232498, 232485, 232450, 232423, 232410, 232283, 232244, 232225, 232190, 232116)
D, [2024-12-11T19:01:08.183459 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Project Load (0.3ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (301, 117, 287, 65, 126, 143)
D, [2024-12-11T19:01:08.184792 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   IssueStatus Load (0.6ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (6, 5, 2)
D, [2024-12-11T19:01:08.185953 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Tracker Load (0.6ms)  SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` IN (7, 9, 5, 4)
D, [2024-12-11T19:01:08.188452 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Rendering layout layouts/base.html.erb
D, [2024-12-11T19:01:08.188551 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Rendering search/index.html.erb within layouts/base
D, [2024-12-11T19:01:08.194250 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Member Exists? (0.4ms)  SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 LIMIT 1
D, [2024-12-11T19:01:08.196250 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   UserPreference Load (1.2ms)  SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 374 LIMIT 1
D, [2024-12-11T19:01:08.201588 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Setting Load (0.9ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'time_format' ORDER BY `settings`.`id` DESC LIMIT 1
I, [2024-12-11T19:01:08.206476 #1398950]  INFO -- : [be701bc2-382d-4e31-8c96-f23888973281]   Rendered search/index.html.erb within layouts/base (Duration: 17.9ms | Allocations: 9495)
D, [2024-12-11T19:01:08.212034 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Project Load (0.7ms)  SELECT `projects`.`id`, `projects`.`name`, `projects`.`identifier`, `projects`.`lft`, `projects`.`rgt` FROM `projects` INNER JOIN `members` ON `projects`.`id` = `members`.`project_id` INNER JOIN `projects` `projects_members` ON `projects_members`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 AND `projects`.`status` = 1
D, [2024-12-11T19:01:08.213457 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.214203 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.215162 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   Project Load (0.5ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (13, 48, 79) AND (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))
D, [2024-12-11T19:01:08.221383 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.223545 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   EnabledModule Exists? (0.9ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'issue_tracking' LIMIT 1
D, [2024-12-11T19:01:08.224194 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.225372 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'time_tracking' LIMIT 1
D, [2024-12-11T19:01:08.235282 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.245414 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   EnabledModule Exists? (0.7ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'gantt' LIMIT 1
D, [2024-12-11T19:01:08.246382 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.255317 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   EnabledModule Exists? (0.6ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'calendar' LIMIT 1
D, [2024-12-11T19:01:08.262906 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:08.264443 #1398950] DEBUG -- : [be701bc2-382d-4e31-8c96-f23888973281]   EnabledModule Exists? (0.6ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'news' LIMIT 1
I, [2024-12-11T19:01:08.268705 #1398950]  INFO -- : [be701bc2-382d-4e31-8c96-f23888973281]   Rendered layout layouts/base.html.erb (Duration: 80.2ms | Allocations: 24692)
I, [2024-12-11T19:01:08.269043 #1398950]  INFO -- : [be701bc2-382d-4e31-8c96-f23888973281] Completed 200 OK in 74117ms (Views: 74.7ms | ActiveRecord: 73756.9ms | Allocations: 230075)
D, [2024-12-11T19:01:19.954889 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (15969.2ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `custom_values` ON `custom_values`.`customized_type` = 'Issue' AND `custom_values`.`customized_id` = `issues`.`id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND ((custom_values.custom_field_id IN (1,8,9,10,11,12,13,14,15,18,19,21,22,27,31,37,39,41,45,46,47,51,52,59,60,61) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = custom_values.custom_field_id)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = custom_values.custom_field_id) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = custom_values.custom_field_id)) AND (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))))))) AND (((custom_values.value LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:01:19.960719 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:01:19.961622 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:19.962211 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:01:19.963029 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:07.918478 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (47948.6ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `journals` ON `journals`.`journalized_type` = 'Issue' AND `journals`.`journalized_id` = `issues`.`id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND (journals.private_notes = FALSE OR (1=0)) AND (((journals.notes LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:02:08.074563 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.099932 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (3.7ms)  SELECT DISTINCT `news`.`created_on`, `news`.`id` FROM `news` INNER JOIN `projects` ON `projects`.`id` = `news`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='news')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (summary LIKE '%test%') OR (news.description LIKE '%test%'))) ORDER BY `news`.`created_on` DESC, `news`.`id` DESC
D, [2024-12-11T19:02:08.101247 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.122306 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (5.4ms)  SELECT DISTINCT `documents`.`created_on`, `documents`.`id` FROM `documents` INNER JOIN `projects` ON `projects`.`id` = `documents`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='documents')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (documents.description LIKE '%test%'))) ORDER BY `documents`.`created_on` DESC, `documents`.`id` DESC
D, [2024-12-11T19:02:08.124248 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CustomField Load (1.1ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'DocumentCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:02:08.131724 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.147650 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (1.1ms)  SELECT DISTINCT `changesets`.`committed_on`, `changesets`.`id` FROM `changesets` INNER JOIN `repositories` ON `repositories`.`id` = `changesets`.`repository_id` INNER JOIN `projects` ON `projects`.`id` = `repositories`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='repository')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124)))))) AND (((comments LIKE '%test%'))) ORDER BY `changesets`.`committed_on` DESC, `changesets`.`id` DESC
D, [2024-12-11T19:02:08.148575 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.167192 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (4.3ms)  SELECT DISTINCT `wiki_pages`.`created_on`, `wiki_pages`.`id` FROM `wiki_pages` INNER JOIN `wiki_contents` ON `wiki_contents`.`page_id` = `wiki_pages`.`id` INNER JOIN `wikis` ON `wikis`.`id` = `wiki_pages`.`wiki_id` INNER JOIN `projects` ON `projects`.`id` = `wikis`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='wiki')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (wiki_contents.text LIKE '%test%'))) ORDER BY `wiki_pages`.`created_on` DESC, `wiki_pages`.`id` DESC
D, [2024-12-11T19:02:08.170120 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.184065 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (1.2ms)  SELECT DISTINCT `messages`.`created_on`, `messages`.`id` FROM `messages` INNER JOIN `boards` ON `boards`.`id` = `messages`.`board_id` INNER JOIN `projects` ON `projects`.`id` = `boards`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='boards')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((subject LIKE '%test%') OR (content LIKE '%test%'))) ORDER BY `messages`.`created_on` DESC, `messages`.`id` DESC
D, [2024-12-11T19:02:08.184845 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.189568 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]    (1.5ms)  SELECT DISTINCT `projects`.`created_on`, `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((name LIKE '%test%') OR (identifier LIKE '%test%') OR (description LIKE '%test%'))) ORDER BY `projects`.`created_on` DESC, `projects`.`id` DESC
D, [2024-12-11T19:02:08.190448 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CustomField Load (0.3ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'ProjectCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:02:08.310450 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Issue Load (1.8ms)  SELECT `issues`.* FROM `issues` WHERE `issues`.`id` IN (232498, 232485, 232450, 232423, 232410, 232283, 232244, 232225, 232190, 232116)
D, [2024-12-11T19:02:08.324188 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Project Load (0.6ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (301, 117, 287, 65, 126, 143)
D, [2024-12-11T19:02:08.331256 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   IssueStatus Load (0.7ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (6, 5, 2)
D, [2024-12-11T19:02:08.340516 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Tracker Load (0.7ms)  SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` IN (7, 9, 5, 4)
D, [2024-12-11T19:02:08.346278 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Rendering layout layouts/base.html.erb
D, [2024-12-11T19:02:08.346386 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Rendering search/index.html.erb within layouts/base
D, [2024-12-11T19:02:08.350401 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Member Exists? (0.4ms)  SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 LIMIT 1
D, [2024-12-11T19:02:08.352215 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   UserPreference Load (1.1ms)  SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 374 LIMIT 1
D, [2024-12-11T19:02:08.357580 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Setting Load (1.0ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'time_format' ORDER BY `settings`.`id` DESC LIMIT 1
D, [2024-12-11T19:02:08.360843 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Setting Load (0.2ms)  SELECT `settings`.* FROM `settings` WHERE `settings`.`name` = 'date_format' ORDER BY `settings`.`id` DESC LIMIT 1
I, [2024-12-11T19:02:08.365573 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Rendered search/index.html.erb within layouts/base (Duration: 19.1ms | Allocations: 12171)
D, [2024-12-11T19:02:08.370691 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Project Load (0.6ms)  SELECT `projects`.`id`, `projects`.`name`, `projects`.`identifier`, `projects`.`lft`, `projects`.`rgt` FROM `projects` INNER JOIN `members` ON `projects`.`id` = `members`.`project_id` INNER JOIN `projects` `projects_members` ON `projects_members`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 AND `projects`.`status` = 1
D, [2024-12-11T19:02:08.372201 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.372893 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.373845 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Project Load (0.4ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (13, 48, 79) AND (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))
D, [2024-12-11T19:02:08.380124 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.382022 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   EnabledModule Exists? (1.0ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'issue_tracking' LIMIT 1
D, [2024-12-11T19:02:08.382807 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.384025 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'time_tracking' LIMIT 1
D, [2024-12-11T19:02:08.384705 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.385853 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   EnabledModule Exists? (0.4ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'gantt' LIMIT 1
D, [2024-12-11T19:02:08.386477 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.387572 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   EnabledModule Exists? (0.4ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'calendar' LIMIT 1
D, [2024-12-11T19:02:08.388263 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:08.389329 #1398969] DEBUG -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   EnabledModule Exists? (0.4ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'news' LIMIT 1
I, [2024-12-11T19:02:08.389763 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa]   Rendered layout layouts/base.html.erb (Duration: 43.4ms | Allocations: 27173)
I, [2024-12-11T19:02:08.390103 #1398969]  INFO -- : [f3230e9e-73b6-497f-be20-3b2155c723fa] Completed 200 OK in 73900ms (Views: 38.3ms | ActiveRecord: 73326.5ms | Allocations: 266504)
I, [2024-12-11T19:02:15.385370 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd] Started GET "/search?page=2&q=test&scope=&utf8=%E2%9C%93" for 10.1.0.5 at 2024-12-11 19:02:15 +0100
I, [2024-12-11T19:02:15.386589 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd] Processing by SearchController#index as HTML
I, [2024-12-11T19:02:15.386671 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Parameters: {"page"=>"2", "q"=>"test", "scope"=>"", "utf8"=>"✓"}
D, [2024-12-11T19:02:15.398722 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (1.8ms)  SELECT MAX(`tokens`.`updated_on`) FROM `tokens` WHERE `tokens`.`user_id` = 374 AND `tokens`.`value` = '9aa69e28da6fe8ecc40a43aa5cda51dc2e48a4de' AND `tokens`.`action` = 'session'
D, [2024-12-11T19:02:15.408269 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Token Update All (2.6ms)  UPDATE `tokens` SET `tokens`.`updated_on` = '2024-12-11 19:02:15' WHERE `tokens`.`user_id` = 374 AND `tokens`.`value` = '9aa69e28da6fe8ecc40a43aa5cda51dc2e48a4de' AND `tokens`.`action` = 'session'
D, [2024-12-11T19:02:15.409071 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (0.3ms)  SELECT MAX(`settings`.`updated_on`) FROM `settings`
D, [2024-12-11T19:02:15.415350 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   User Load (0.9ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND `users`.`id` = 374 LIMIT 1
I, [2024-12-11T19:02:15.415670 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Current user: surbanoski.aleksandar (id=374)
D, [2024-12-11T19:02:15.437839 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Role Load (11.7ms)  SELECT DISTINCT `roles`.* FROM `roles` INNER JOIN `member_roles` ON `member_roles`.`role_id` = `roles`.`id` INNER JOIN `members` ON `members`.`id` = `member_roles`.`member_id` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE (projects.status <> 9) AND `members`.`user_id` = 374
D, [2024-12-11T19:02:15.438766 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Role Load (0.2ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1
D, [2024-12-11T19:02:15.447612 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   GroupNonMember Load (1.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:15.448539 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (0.2ms)  SELECT `users`.`id` FROM `users` WHERE `users`.`type` = 'GroupNonMember' LIMIT 1
D, [2024-12-11T19:02:15.454137 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (0.8ms)  SELECT `members`.`user_id`, `role_id`, `members`.`project_id` FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` INNER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` WHERE (projects.status <> 9) AND (members.user_id = 374 OR (projects.is_public = TRUE AND members.user_id = 124))
D, [2024-12-11T19:02:15.455159 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Role Load (0.3ms)  SELECT `roles`.* FROM `roles` WHERE `roles`.`id` IN (10, 3)
D, [2024-12-11T19:02:15.476805 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (0.9ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:15.477681 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:15.485468 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.842398 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (9318.6ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND (((subject LIKE '%test%') OR (issues.description LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:02:24.875197 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CustomField Load (0.4ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'IssueCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:02:24.877049 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.878066 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.878810 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.879445 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.880059 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.880807 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.881459 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.882096 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.882849 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.883626 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.884297 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.884914 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.885500 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.886266 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.886918 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.887540 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.888129 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.889040 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.889692 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.890326 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.890922 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.891659 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.892332 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.892953 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.893539 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.894514 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.895170 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.895787 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.896387 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.897129 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.897778 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.898415 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.899013 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.900138 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.900801 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.901439 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.902050 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.902792 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.903448 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.904069 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.904671 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.905580 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.906266 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.906894 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.907482 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.908221 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.908872 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.909512 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.910121 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.911026 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.911688 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.912314 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.912907 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.913646 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.914311 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.914938 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.915525 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.916276 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.917072 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.917700 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.918324 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.919071 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.919720 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.920342 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.920930 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.921669 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.922427 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.923057 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.923647 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.924406 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.925061 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.925685 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.926324 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.927084 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.927824 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.928457 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.929053 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.929799 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.930467 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.931096 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.931688 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.932434 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.933194 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.933828 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.934453 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.935200 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.935854 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.936478 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.937086 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.937827 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.938573 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.939204 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.939718 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.940227 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.940726 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.941191 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.941639 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.942169 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.942622 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.943051 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.943521 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.944030 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.944472 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.944895 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.945474 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:24.946073 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.946594 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:24.947056 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:40.812306 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (15863.8ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `custom_values` ON `custom_values`.`customized_type` = 'Issue' AND `custom_values`.`customized_id` = `issues`.`id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND ((custom_values.custom_field_id IN (1,8,9,10,11,12,13,14,15,18,19,21,22,27,31,37,39,41,45,46,47,51,52,59,60,61) AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = custom_values.custom_field_id)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = custom_values.custom_field_id) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = custom_values.custom_field_id)) AND (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))))))) AND (((custom_values.value LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:02:40.819556 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:02:40.820616 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:40.821325 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:02:40.821954 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE  (0.0ms)  SELECT `users`.`id` FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND `groups_users`.`user_id` = 374
D, [2024-12-11T19:03:28.068892 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (47245.3ms)  SELECT DISTINCT `issues`.`created_on`, `issues`.`id` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `journals` ON `journals`.`journalized_type` = 'Issue' AND `journals`.`journalized_id` = `issues`.`id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85)))) OR (projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303) AND ((issues.is_private = FALSE OR issues.author_id = 374 OR issues.assigned_to_id IN (374,85))))))) AND (journals.private_notes = FALSE OR (1=0)) AND (((journals.notes LIKE '%test%'))) ORDER BY `issues`.`created_on` DESC, `issues`.`id` DESC
D, [2024-12-11T19:03:28.195701 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.200609 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (3.4ms)  SELECT DISTINCT `news`.`created_on`, `news`.`id` FROM `news` INNER JOIN `projects` ON `projects`.`id` = `news`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='news')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (summary LIKE '%test%') OR (news.description LIKE '%test%'))) ORDER BY `news`.`created_on` DESC, `news`.`id` DESC
D, [2024-12-11T19:03:28.201714 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.207257 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (4.4ms)  SELECT DISTINCT `documents`.`created_on`, `documents`.`id` FROM `documents` INNER JOIN `projects` ON `projects`.`id` = `documents`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='documents')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (documents.description LIKE '%test%'))) ORDER BY `documents`.`created_on` DESC, `documents`.`id` DESC
D, [2024-12-11T19:03:28.208469 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CustomField Load (0.6ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'DocumentCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:03:28.209234 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.211095 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (0.8ms)  SELECT DISTINCT `changesets`.`committed_on`, `changesets`.`id` FROM `changesets` INNER JOIN `repositories` ON `repositories`.`id` = `changesets`.`repository_id` INNER JOIN `projects` ON `projects`.`id` = `repositories`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='repository')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124)))))) AND (((comments LIKE '%test%'))) ORDER BY `changesets`.`committed_on` DESC, `changesets`.`id` DESC
D, [2024-12-11T19:03:28.211745 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.216977 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (4.0ms)  SELECT DISTINCT `wiki_pages`.`created_on`, `wiki_pages`.`id` FROM `wiki_pages` INNER JOIN `wiki_contents` ON `wiki_contents`.`page_id` = `wiki_pages`.`id` INNER JOIN `wikis` ON `wikis`.`id` = `wiki_pages`.`wiki_id` INNER JOIN `projects` ON `projects`.`id` = `wikis`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='wiki')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((title LIKE '%test%') OR (wiki_contents.text LIKE '%test%'))) ORDER BY `wiki_pages`.`created_on` DESC, `wiki_pages`.`id` DESC
D, [2024-12-11T19:03:28.217596 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.219237 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (0.8ms)  SELECT DISTINCT `messages`.`created_on`, `messages`.`id` FROM `messages` INNER JOIN `boards` ON `boards`.`id` = `messages`.`board_id` INNER JOIN `projects` ON `projects`.`id` = `boards`.`project_id` WHERE (((projects.status <> 9 AND projects.status <> 10 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='boards')) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((subject LIKE '%test%') OR (content LIKE '%test%'))) ORDER BY `messages`.`created_on` DESC, `messages`.`id` DESC
D, [2024-12-11T19:03:28.219741 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.221459 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]    (1.1ms)  SELECT DISTINCT `projects`.`created_on`, `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303)))) AND (((name LIKE '%test%') OR (identifier LIKE '%test%') OR (description LIKE '%test%'))) ORDER BY `projects`.`created_on` DESC, `projects`.`id` DESC
D, [2024-12-11T19:03:28.222125 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CustomField Load (0.3ms)  SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` = 'ProjectCustomField' AND `custom_fields`.`searchable` = TRUE
D, [2024-12-11T19:03:28.264854 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Issue Load (1.9ms)  SELECT `issues`.* FROM `issues` WHERE `issues`.`id` IN (232101, 232088, 232011, 232004, 231895, 231821, 231787, 231783, 231780, 231763)
D, [2024-12-11T19:03:28.266045 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Project Load (0.2ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (90, 301, 13, 92, 117)
D, [2024-12-11T19:03:28.267264 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   IssueStatus Load (0.5ms)  SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (3, 5, 2)
D, [2024-12-11T19:03:28.268313 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Tracker Load (0.5ms)  SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` IN (9, 7)
D, [2024-12-11T19:03:28.269169 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Rendering layout layouts/base.html.erb
D, [2024-12-11T19:03:28.269241 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Rendering search/index.html.erb within layouts/base
D, [2024-12-11T19:03:28.271258 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Member Exists? (0.3ms)  SELECT 1 AS one FROM `members` INNER JOIN `projects` ON `projects`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 LIMIT 1
D, [2024-12-11T19:03:28.272762 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   UserPreference Load (1.0ms)  SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 374 LIMIT 1
I, [2024-12-11T19:03:28.279413 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Rendered search/index.html.erb within layouts/base (Duration: 10.1ms | Allocations: 7680)
D, [2024-12-11T19:03:28.283395 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Project Load (0.4ms)  SELECT `projects`.`id`, `projects`.`name`, `projects`.`identifier`, `projects`.`lft`, `projects`.`rgt` FROM `projects` INNER JOIN `members` ON `projects`.`id` = `members`.`project_id` INNER JOIN `projects` `projects_members` ON `projects_members`.`id` = `members`.`project_id` WHERE `members`.`user_id` = 374 AND `projects`.`status` != 9 AND `projects`.`status` = 1
D, [2024-12-11T19:03:28.284376 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.284986 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.285720 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Project Load (0.3ms)  SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (13, 48, 79) AND (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))
D, [2024-12-11T19:03:28.291304 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.292904 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   EnabledModule Exists? (0.8ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'issue_tracking' LIMIT 1
D, [2024-12-11T19:03:28.293455 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.294686 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'time_tracking' LIMIT 1
D, [2024-12-11T19:03:28.295326 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.296464 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'gantt' LIMIT 1
D, [2024-12-11T19:03:28.297025 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.298241 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'calendar' LIMIT 1
D, [2024-12-11T19:03:28.298825 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   CACHE GroupNonMember Load (0.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`type` = 'GroupNonMember' ORDER BY id LIMIT 1
D, [2024-12-11T19:03:28.299974 #1398950] DEBUG -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   EnabledModule Exists? (0.5ms)  SELECT 1 AS one FROM `enabled_modules` WHERE `enabled_modules`.`project_id` IN (SELECT `projects`.`id` FROM `projects` WHERE (((projects.status <> 9 AND projects.status <> 10) AND ((projects.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (374,124))) OR projects.id IN (13,19,31,43,48,64,65,67,71,76,85,87,90,92,94,97,114,117,123,126,143,144,145,146,147,150,151,155,158,169,170,179,183,184,185,187,199,200,203,209,217,218,219,220,221,222,223,224,225,226,233,235,262,287,301,303,308) OR projects.id IN (15,19,31,48,65,71,76,79,85,92,97,155,179,183,184,185,199,200,303))))) AND `enabled_modules`.`name` = 'news' LIMIT 1
I, [2024-12-11T19:03:28.300382 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd]   Rendered layout layouts/base.html.erb (Duration: 31.1ms | Allocations: 22339)
I, [2024-12-11T19:03:28.300639 #1398950]  INFO -- : [99de4256-9c1e-4ea5-985c-b7af3c1daccd] Completed 200 OK in 72914ms (Views: 26.7ms | ActiveRecord: 72474.1ms | Allocations: 222404)

Above is just searching for test in search bar and selecting page 2 from results

Actions

Copy link

Updated by Aleksandar Surbanoski 8 days ago

Should I add indexes for example project.status?

Actions

Copy link

Also available in: Atom PDF

Project

General

Profile

Redmine

Custom queries

Defect #41965

Redmine 5.1.3 and MariaDB 10.6.18 - Queries are slow

Updated by Holger Just 11 days ago

Updated by Aleksandar Surbanoski 11 days ago

Updated by Aleksandar Surbanoski 9 days ago

Updated by Aleksandar Surbanoski 8 days ago