Actions
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:
0%
Estimated time:
Resolution:
Affected version:
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,
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 = :debuginconfig/environments/production.rband restarting Redmine). - If you see slow SQL queries, show the
EXPLAINoutput of the slow SQL query / queries. See https://mariadb.com/kb/en/explain/
Updated by Aleksandar Surbanoski 10 days ago
Query - I should mention searching for text in search bar. I will check your suggestions and get back
Thanks,
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 = :debuginconfig/environments/production.rband restarting Redmine).- If you see slow SQL queries, show the
EXPLAINoutput 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
Updated by Aleksandar Surbanoski 8 days ago
MariaDB [redmine]> EXPLAIN SELECT DISTINCT `issues`.`created_on`, `issues`.`id`
> FROM `issues`-------------+----------+------+-------------------+-------------------+---------+---------------------+------+------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
-> INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id`
-> WHERE (projects.status <> 9 AND projects.status <> 10)
-> AND ((subject LIKE '%test%') OR (issues.description LIKE '%test%'));
----------------------+----------+------+-------------------+-------------------+---------+---------------------+------+------------------------------+
| 1 | SIMPLE | projects | ALL | PRIMARY | NULL | NULL | NULL | 299 | Using where; Using temporary |
| 1 | SIMPLE | issues | ref | issues_project_id | issues_project_id | 4 | redmine.projects.id | 294 | Using where |-----------------+----------+------+-------------------+-------------------+---------+---------------------+------+------------------------------+
2 rows in set (0.002 sec)
Should I add indexes for example project.status?
Actions