Project

General

Profile

Forums » Help »

Slow queries for some users

Added by Mohamed Ghazi 22 days ago

Hello,

I recently migrated from Redmine 3 to 6.1 using Docker, and I’m experiencing performance issues for some users. When they try to open certain tickets or pages, the queries are very slow.

I checked the MySQL processlist, and some queries can take more than 5 minutes for those users, while for others (including myself) everything loads instantly.

We already tried to optimize the database by adding indexes and increasing performance-related settings, but the issue persists.

We are using three plugins: Agile, OAuth, and Resources.

Has anyone else experienced this issue? Thanks for your help.


Replies (2)

RE: Slow queries for some users - Added by Holger Just 22 days ago

Please provide more details. At least, please show which queries exactly are slow. You can get them either the database logs (e.g. MySQL's slow query log) or from Redmine's logs after increasing the log level.

RE: Slow queries for some users - Added by Mohamed Ghazi about 20 hours ago

Hi Holger,

Sorry for the delayed response.

Thank you for your message. After further investigation, we were able to identify the queries involved.
We use Redmine Agile Plugin Pro, version 1.6.12.
Please find below the two queries that appear to be slow:

Additionally, we noticed that once users are switched to Redmine administrators, the performance issues disappear, and there are no longer any slowdowns.

Query 1:

SELECT COUNT AS `count_all`, COALESCE AS `coalesce_cf_68_value` FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` LEFT OUTER JOIN custom_values cf_68 ON cf_68.customized_type = 'Issue' AND cf_68.customized_id = issues.id AND cf_68.custom_field_id = 68 AND (((issues.project_id IN (SELECT DISTINCT m.project_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 = 595 AND cfr.custom_field_id = 68)) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 68)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 68) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 68)) AND (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596))))))))) AND cf_68.value <> '' AND cf_68.id = (SELECT max(cf_68_2.id) FROM custom_values cf_68_2 WHERE cf_68_2.customized_type = cf_68.customized_type AND cf_68_2.customized_id = cf_68.customized_id AND cf_68_2.custom_field_id = cf_68.custom_field_id) WHERE (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596))))))) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND (issues.fixed_version_id IN ('332')) AND EXISTS (SELECT ct.id FROM issues ct LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=ct.id AND custom_values.custom_field_id=68 WHERE issues.id = ct.id AND (custom_values.value IN ('Incident','DDS','Partenaires','Evolutions')) AND (((issues.project_id IN (SELECT DISTINCT m.project_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 = 595 AND cfr.custom_field_id = 68)) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 68)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 68) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 68)) AND (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))))))))) AND ((issues.project_id IN (SELECT DISTINCT m.project_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 = 595 AND cfr.custom_field_id = 68)) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 68)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 68) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 68)) AND (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))))))) AND projects.id IN (118,154,156,148,173,152,159,255,170,158,243,254,147,336,134,335,124,153,128,122,123,127,126,125,187,258,268,233,261,308,257,264,316,317,333,262,334,307,338,312,306,263,260,271,265,323,324,325,326,327,322,328,329,330,331,315,337,292,276,314,286,281,303,284,299,304,293,298,301,294,18,178,241,169,140,180,164,142,163,162,190,191,166,157,149,182,192,195,198,199,197,209,217,219,236,253,246,247,248,249,250,251,204,200,201,202,205,206,208,211,213,215,216,218,221,222,225,223,224,226,227,230,231,234,238,239,210,229,228,212,161,321,203,309,220,245,232,252,256,313,242,318,332,320,138,130,188,194,146,150,185,193,141,183,171,176,196,144,155,145,175,184,143,165,339,174,207,340,167,172,129,168,179)) GROUP BY COALESCE

Query 2:

SELECT `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1, `issues`.`project_id` AS t0_r2, `issues`.`subject` AS t0_r3, `issues`.`description` AS t0_r4, `issues`.`due_date` AS t0_r5, `issues`.`category_id` AS t0_r6, `issues`.`status_id` AS t0_r7, `issues`.`assigned_to_id` AS t0_r8, `issues`.`priority_id` AS t0_r9, `issues`.`fixed_version_id` AS t0_r10, `issues`.`author_id` AS t0_r11, `issues`.`lock_version` AS t0_r12, `issues`.`created_on` AS t0_r13, `issues`.`updated_on` AS t0_r14, `issues`.`start_date` AS t0_r15, `issues`.`done_ratio` AS t0_r16, `issues`.`estimated_hours` AS t0_r17, `issues`.`parent_id` AS t0_r18, `issues`.`root_id` AS t0_r19, `issues`.`lft` AS t0_r20, `issues`.`rgt` AS t0_r21, `issues`.`is_private` AS t0_r22, `issues`.`closed_on` AS t0_r23, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`description` AS t1_r2, `issue_statuses`.`is_closed` AS t1_r3, `issue_statuses`.`position` AS t1_r4, `issue_statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11, `projects`.`inherit_members` AS t2_r12, `projects`.`default_version_id` AS t2_r13, `projects`.`default_assigned_to_id` AS t2_r14, `projects`.`default_issue_query_id` AS t2_r15, `agile_data`.`id` AS t3_r0, `agile_data`.`issue_id` AS t3_r1, `agile_data`.`position` AS t3_r2, `agile_data`.`story_points` AS t3_r3, `agile_data`.`agile_sprint_id` AS t3_r4, `agile_colors`.`id` AS t4_r0, `agile_colors`.`container_id` AS t4_r1, `agile_colors`.`container_type` AS t4_r2, `agile_colors`.`color` AS t4_r3 FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` LEFT OUTER JOIN `agile_data` ON `agile_data`.`issue_id` = `issues`.`id` LEFT OUTER JOIN `agile_colors` ON `agile_colors`.`container_type` = 'Issue' AND `agile_colors`.`container_id` = `issues`.`id` LEFT OUTER JOIN custom_values cf_68 ON cf_68.customized_type = 'Issue' AND cf_68.customized_id = issues.id AND cf_68.custom_field_id = 68 AND (((issues.project_id IN (SELECT DISTINCT m.project_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 = 595 AND cfr.custom_field_id = 68)) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 68)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 68) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 68)) AND (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596))))))))) AND cf_68.value <> '' AND cf_68.id = (SELECT max(cf_68_2.id) FROM custom_values cf_68_2 WHERE cf_68_2.customized_type = cf_68.customized_type AND cf_68_2.customized_id = cf_68.customized_id AND cf_68_2.custom_field_id = cf_68.custom_field_id) LEFT OUTER JOIN enumerations ON enumerations.id = issues.priority_id WHERE (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596))))))) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND (issues.fixed_version_id IN ('332')) AND EXISTS (SELECT ct.id FROM issues ct LEFT OUTER JOIN custom_values ON custom_values.customized_type='Issue' AND custom_values.customized_id=ct.id AND custom_values.custom_field_id=68 WHERE issues.id = ct.id AND (custom_values.value IN ('Incident','DDS','Partenaires','Evolutions')) AND (((issues.project_id IN (SELECT DISTINCT m.project_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 = 595 AND cfr.custom_field_id = 68)) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 68)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 68) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 68)) AND (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))))))))) AND ((issues.project_id IN (SELECT DISTINCT m.project_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 = 595 AND cfr.custom_field_id = 68)) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 68)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = TRUE AND ifa.id = 68) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 68)) AND (((projects.status IN (1, 5) 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 (595,144))) AND (1=1)) OR (projects.id IN (233,260,265,271,276,281,284,286,292,293,294,298,299,301,303,304,314,315,323,324,325,326,327,328,329,330,331,337) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,26,30,32,35,41,42,44,45,47,61,63,70,72,84,86,107,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (4,15,25,26,30,32,35,41,42,44,45,47,61,63,64,65,70,72,84,86,107,332) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))) OR (projects.id IN (109,118,122,123,124,125,126,127,128,129,130,134,138,140,141,142,143,144,145,146,147,148,149,150,153,154,155,157,158,159,161,162,163,164,165,166,167,169,170,171,172,173,174,175,176,179,180,182,183,184,185,187,188,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,234,236,238,239,242,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,261,262,263,264,268,306,307,308,309,312,313,316,317,318,320,321,332,333,334,335,336,339,340) AND ((issues.is_private = FALSE OR issues.author_id = 595 OR issues.assigned_to_id IN (595,61,596)))))))) AND projects.id IN (118,154,156,148,173,152,159,255,170,158,243,254,147,336,134,335,124,153,128,122,123,127,126,125,187,258,268,233,261,308,257,264,316,317,333,262,334,307,338,312,306,263,260,271,265,323,324,325,326,327,322,328,329,330,331,315,337,292,276,314,286,281,303,284,299,304,293,298,301,294,18,178,241,169,140,180,164,142,163,162,190,191,166,157,149,182,192,195,198,199,197,209,217,219,236,253,246,247,248,249,250,251,204,200,201,202,205,206,208,211,213,215,216,218,221,222,225,223,224,226,227,230,231,234,238,239,210,229,228,212,161,321,203,309,220,245,232,252,256,313,242,318,332,320,138,130,188,194,146,150,185,193,141,183,171,176,196,144,155,145,175,184,143,165,339,174,207,340,167,172,129,168,179)) ORDER BY COALESCE ASC, enumerations.position DESC, issues.created_on ASC, issues.id DESC LIMIT 100 OFFSET 0

Please let us know if you need any additional information or further details from our side.

Best regards,

Mohamed.

    (1-2/2)