Project

General

Profile

Defect #9797 » DEBUG-Logs.txt

Logs (Debug), starting from click on 'Move" - Salim B, 2011-12-14 17:31

 
1
Processing IssueMovesController#new (for 195.5.222.154 at 2011-12-14 17:27:00) [GET]
2
  Parameters: {"ids"=>["18406"], "action"=>"new", "controller"=>"issue_moves"}
3
  SQL (0.2ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`
4
  User Load (0.2ms)   SELECT * FROM `users` WHERE (`users`.`id` = 7) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
5
  Issue Load (0.1ms)   SELECT * FROM `issues` WHERE (`issues`.`id` IN ('18406'))
6
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 22)
7
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 22)
8
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (projects.status=1)
9
  Member Load Including Associations (0.9ms)   SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 7 AND (projects.status=1)) ORDER BY projects.name
10
  Workflow Load (0.2ms)   SELECT * FROM `workflows` WHERE (`workflows`.`role_id` IN (10))
11
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (16,17,1,5))
12
Rendering template within layouts/base
13
Rendering issue_moves/new
14
  Tracker Load (0.1ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 13)
15
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1)
16
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
17
  Tracker Load (0.2ms)   SELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 22 ) ORDER BY trackers.position
18
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
19
  Member Load Including Associations (0.4ms)   SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`admin` AS t1_r6, `users`.`status` AS t1_r7, `users`.`last_login_on` AS t1_r8, `users`.`language` AS t1_r9, `users`.`auth_source_id` AS t1_r10, `users`.`created_on` AS t1_r11, `users`.`updated_on` AS t1_r12, `users`.`type` AS t1_r13, `users`.`identity_url` AS t1_r14, `users`.`mail_notification` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 22 AND (users.type='User' AND users.status=1))
20
  Project Load (0.3ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 7) AND ((projects.status=1)))
21
  SQL (0.2ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status=1) AND (projects.id != 22)) AND (projects.`lft` <= 34 AND projects.`rgt` >= 35))
22
  Project Load (0.2ms)   SELECT * FROM `projects` WHERE (((projects.status=1) AND (projects.id != 22)) AND (projects.`lft` <= 34 AND projects.`rgt` >= 35)) ORDER BY `lft`
23
  Project Load (0.2ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 34 AND projects.`rgt` >= 35) ORDER BY `lft` LIMIT 1
24
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 34 AND projects.`rgt` >= 35) ORDER BY `lft` LIMIT 1
25
  SQL (0.3ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 22 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 31 AND projects.rgt <= 40 AND versions.sharing = 'tree') OR (projects.lft < 34 AND projects.rgt > 35 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 34 AND projects.rgt < 35 AND versions.sharing = 'hierarchy'))))
26
  Wiki Load (0.1ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 22) LIMIT 1
27
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 22)
28
  Repository Load (0.1ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 22) LIMIT 1
29
Completed in 112ms (View: 98, DB: 5) | 200 OK [http://sb01vmlx/issues/move/new?ids%5B%5D=18406]
30

    
31

    
32
Processing IssueMovesController#new (for 195.5.222.154 at 2011-12-14 17:27:09) [GET]
33
  Parameters: {"start_date"=>"", "new_tracker_id"=>"", "commit"=>"Déplacer", "ids"=>["18406"], "new_project_id"=>"3", "priority_id"=>"", "notes"=>"", "action"=>"new", "authenticity_token"=>"owcybftNJq0xDJAorwikQ0YHZXaPv6FU5/seYJUqnac=", "assigned_to_id"=>"", "due_date"=>"", "controller"=>"issue_moves", "status_id"=>""}
34
  SQL (0.2ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`
35
  User Load (0.2ms)   SELECT * FROM `users` WHERE (`users`.`id` = 7) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
36
  Issue Load (0.1ms)   SELECT * FROM `issues` WHERE (`issues`.`id` IN ('18406'))
37
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 22)
38
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 22)
39
  Project Load (0.2ms)   SELECT * FROM `projects` WHERE (projects.status=1)
40
  Member Load Including Associations (0.7ms)   SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 7 AND (projects.status=1)) ORDER BY projects.name
41
  Workflow Load (0.2ms)   SELECT * FROM `workflows` WHERE (`workflows`.`role_id` IN (10))
42
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (16,17,1,5))
43
Rendering issue_moves/new
44
  Tracker Load (0.1ms)   SELECT * FROM `trackers` WHERE (`trackers`.`id` = 13)
45
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1)
46
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
47
  Tracker Load (0.2ms)   SELECT * FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`projects_trackers`.project_id = 3 ) ORDER BY trackers.position
48
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
49
  Member Load Including Associations (0.6ms)   SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`admin` AS t1_r6, `users`.`status` AS t1_r7, `users`.`last_login_on` AS t1_r8, `users`.`language` AS t1_r9, `users`.`auth_source_id` AS t1_r10, `users`.`created_on` AS t1_r11, `users`.`updated_on` AS t1_r12, `users`.`type` AS t1_r13, `users`.`identity_url` AS t1_r14, `users`.`mail_notification` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 3 AND (users.type='User' AND users.status=1))
50
Completed in 29ms (View: 17, DB: 3) | 200 OK [http://sb01vmlx/issues/move/new?authenticity_token=owcybftNJq0xDJAorwikQ0YHZXaPv6FU5%2FseYJUqnac%3D&authenticity_token=owcybftNJq0xDJAorwikQ0YHZXaPv6FU5%2FseYJUqnac%3D&ids%5B%5D=18406&new_project_id=3&new_tracker_id=&status_id=&priority_id=&assigned_to_id=&start_date=&due_date=&notes=&commit=D%C3%A9placer]
51

    
52

    
53
Processing IssueMovesController#create (for 195.5.222.154 at 2011-12-14 17:27:12) [POST]
54
  Parameters: {"start_date"=>"", "new_tracker_id"=>"14", "commit"=>"Déplacer", "ids"=>["18406"], "new_project_id"=>"3", "priority_id"=>"", "notes"=>"", "action"=>"create", "authenticity_token"=>"owcybftNJq0xDJAorwikQ0YHZXaPv6FU5/seYJUqnac=", "assigned_to_id"=>"", "due_date"=>"", "controller"=>"issue_moves", "status_id"=>""}
55
  SQL (0.2ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`
56
  User Load (0.2ms)   SELECT * FROM `users` WHERE (`users`.`id` = 7) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
57
  Issue Load (0.1ms)   SELECT * FROM `issues` WHERE (`issues`.`id` IN ('18406'))
58
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`id` = 22)
59
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 22)
60
  Project Load (0.2ms)   SELECT * FROM `projects` WHERE (projects.status=1)
61
  Member Load Including Associations (0.7ms)   SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`created_on` AS t0_r3, `members`.`mail_notification` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 7 AND (projects.status=1)) ORDER BY projects.name
62
  Workflow Load (0.1ms)   SELECT * FROM `workflows` WHERE (`workflows`.`role_id` IN (10))
63
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` IN (16,17,1,5))
64
  Tracker Load (0.1ms)   SELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = '14') AND (`projects_trackers`.project_id = 3 ) ORDER BY trackers.position LIMIT 1
65
  Issue Load (0.1ms)   SELECT * FROM `issues` WHERE (`issues`.`id` = 18406)
66
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 0)
67
  IssueStatus Load (0.2ms)   SELECT * FROM `issue_statuses` WHERE (is_default=1) LIMIT 1
68
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 0) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
69
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`is_default` = 1) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC LIMIT 1
70
  IssueStatus Load (0.1ms)   SELECT * FROM `issue_statuses` WHERE (`issue_statuses`.`id` = 1)
71
  CustomValue Load Including Associations (0.5ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18406 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
72
  SQL (0.0ms)   BEGIN
73
  Project Load (0.2ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 38 AND projects.`rgt` >= 39) ORDER BY `lft` LIMIT 1
74
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 38 AND projects.`rgt` >= 39) ORDER BY `lft` LIMIT 1
75
  Version Load (0.1ms)   SELECT * FROM `versions` WHERE (`versions`.`id` = 53)
76
  Version Load Including Associations (0.4ms)   SELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `versions`.`duration` AS t0_r10, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 3 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 31 AND projects.rgt <= 40 AND versions.sharing = 'tree') OR (projects.lft < 38 AND projects.rgt > 39 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 38 AND projects.rgt < 39 AND versions.sharing = 'hierarchy'))))
77
  IssueCustomField Load (0.2ms)   SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
78
  IssueCustomField Load (0.3ms)   SELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 3 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
79
  IssueCustomField Load (0.2ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 2) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
80
  IssueCustomField Load (0.1ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 12) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
81
  IssueCustomField Load (0.1ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 5) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
82
  IssueCustomField Load (0.1ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 11) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
83
  IssueCustomField Load (0.1ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 17) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
84
  IssueCustomField Load (0.1ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 28) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
85
  IssueCustomField Load (0.1ms)   SELECT `custom_fields`.id FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.id = `custom_fields_trackers`.custom_field_id WHERE (`custom_fields`.`id` = 29) AND (`custom_fields_trackers`.tracker_id = 14 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) LIMIT 1
86
  IssuePriority Load (0.1ms)   SELECT * FROM `enumerations` WHERE (`enumerations`.`id` = 4) AND ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
87
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
88
  IssueRelation Load (0.1ms)   SELECT * FROM `issue_relations` WHERE (`issue_relations`.issue_to_id = 18406)
89
  Issue Load (0.4ms)   SELECT * FROM `issues` WHERE (((issues.id != 18406) AND (issues.`lft` <= 1 AND issues.`rgt` >= 2)) AND (`issues`.`root_id` = 18406)) ORDER BY `lft`
90
  Version Load (0.1ms)   SELECT * FROM `versions` WHERE (`versions`.`id` = 53) LIMIT 1
91
  Version Load Including Associations (0.4ms)   SELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `versions`.`duration` AS t0_r10, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE ((`versions`.`status` = 'open') AND (projects.id = 3 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 31 AND projects.rgt <= 40 AND versions.sharing = 'tree') OR (projects.lft < 38 AND projects.rgt > 39 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 38 AND projects.rgt < 39 AND versions.sharing = 'hierarchy')))))
92
  Tracker Load (0.1ms)   SELECT `trackers`.id FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.id = `projects_trackers`.tracker_id WHERE (`trackers`.`id` = 14) AND (`projects_trackers`.project_id = 3 ) ORDER BY trackers.position LIMIT 1
93
  SQL (0.1ms)   ROLLBACK
94
Redirected to http://sb01vmlx/projects/servicedesk/issues
95
Completed in 39ms (DB: 7) | 302 Found [http://sb01vmlx/issues/move]
96

    
97

    
98
Processing IssuesController#index (for 195.5.222.154 at 2011-12-14 17:27:12) [GET]
99
  Parameters: {"project_id"=>"servicedesk", "action"=>"index", "controller"=>"issues"}
100
  SQL (0.2ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`
101
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 7) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
102
  Project Load (0.1ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'servicedesk') LIMIT 1
103
  EnabledModule Load (0.1ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 22)
104
  IssueCustomField Load (0.2ms)   SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
105
  IssueCustomField Load (0.3ms)   SELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 22 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
106
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 22)) AND (projects.`lft` >= 34 AND projects.`rgt` <= 35))
107
  SQL (55.6ms)   SELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issue_statuses.is_closed=0) AND projects.id = 22 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))
108
  CACHE (0.0ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 22)) AND (projects.`lft` >= 34 AND projects.`rgt` <= 35))
109
  Issue Load Including Associations (58.6ms)   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`.`user_story_id` AS t0_r18, `issues`.`parent_id` AS t0_r19, `issues`.`root_id` AS t0_r20, `issues`.`lft` AS t0_r21, `issues`.`rgt` AS t0_r22, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2, `issue_statuses`.`is_default` 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, `users`.`id` AS t3_r0, `users`.`login` AS t3_r1, `users`.`hashed_password` AS t3_r2, `users`.`firstname` AS t3_r3, `users`.`lastname` AS t3_r4, `users`.`mail` AS t3_r5, `users`.`admin` AS t3_r6, `users`.`status` AS t3_r7, `users`.`last_login_on` AS t3_r8, `users`.`language` AS t3_r9, `users`.`auth_source_id` AS t3_r10, `users`.`created_on` AS t3_r11, `users`.`updated_on` AS t3_r12, `users`.`type` AS t3_r13, `users`.`identity_url` AS t3_r14, `users`.`mail_notification` AS t3_r15, `trackers`.`id` AS t4_r0, `trackers`.`name` AS t4_r1, `trackers`.`is_in_chlog` AS t4_r2, `trackers`.`position` AS t4_r3, `trackers`.`is_in_roadmap` AS t4_r4, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`type` AS t5_r4, `enumerations`.`active` AS t5_r5, `enumerations`.`project_id` AS t5_r6, `enumerations`.`parent_id` AS t5_r7, `issue_categories`.`id` AS t6_r0, `issue_categories`.`project_id` AS t6_r1, `issue_categories`.`name` AS t6_r2, `issue_categories`.`assigned_to_id` AS t6_r3, `versions`.`id` AS t7_r0, `versions`.`project_id` AS t7_r1, `versions`.`name` AS t7_r2, `versions`.`description` AS t7_r3, `versions`.`effective_date` AS t7_r4, `versions`.`created_on` AS t7_r5, `versions`.`updated_on` AS t7_r6, `versions`.`wiki_page_title` AS t7_r7, `versions`.`status` AS t7_r8, `versions`.`sharing` AS t7_r9, `versions`.`duration` AS t7_r10 FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `issues`.priority_id AND (`enumerations`.`type` = 'IssuePriority' ) LEFT OUTER JOIN `issue_categories` ON `issue_categories`.id = `issues`.category_id LEFT OUTER JOIN `versions` ON `versions`.id = `issues`.fixed_version_id WHERE (((issue_statuses.is_closed=0) AND projects.id = 22 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) ORDER BY enumerations.position DESC LIMIT 0, 25
110
Rendering template within layouts/base
111
Rendering issues/index.rhtml
112
  Tracker Load Including Associations (0.7ms)   SELECT `trackers`.`id` AS t0_r0, `trackers`.`name` AS t0_r1, `trackers`.`is_in_chlog` AS t0_r2, `trackers`.`position` AS t0_r3, `trackers`.`is_in_roadmap` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11 FROM `trackers` LEFT OUTER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id LEFT OUTER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 34 AND projects.rgt <= 35 AND projects.status = 1) ORDER BY trackers.position
113
  IssueStatus Load (0.2ms)   SELECT * FROM `issue_statuses` ORDER BY position
114
  IssuePriority Load (0.2ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
115
  User Load (0.5ms)   SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 22) AND ((users.type='User' AND users.status=1))) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
116
  Group Load (0.2ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'Group' ) )
117
  Role Load (0.2ms)   SELECT * FROM `roles` WHERE (builtin = 0) ORDER BY position
118
  SQL (0.2ms)   SELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 22)
119
  Project Load (0.2ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 34 AND projects.`rgt` >= 35) ORDER BY `lft` LIMIT 1
120
  CACHE (0.0ms)   SELECT * FROM `projects` WHERE (projects.`lft` <= 34 AND projects.`rgt` >= 35) ORDER BY `lft` LIMIT 1
121
  SQL (0.4ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 22 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 31 AND projects.rgt <= 40 AND versions.sharing = 'tree') OR (projects.lft < 34 AND projects.rgt > 35 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 34 AND projects.rgt < 35 AND versions.sharing = 'hierarchy'))))
122
  Version Load Including Associations (0.4ms)   SELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2, `versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5, `versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `versions`.`status` AS t0_r8, `versions`.`sharing` AS t0_r9, `versions`.`duration` AS t0_r10, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 22 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 31 AND projects.rgt <= 40 AND versions.sharing = 'tree') OR (projects.lft < 34 AND projects.rgt > 35 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 34 AND projects.rgt < 35 AND versions.sharing = 'hierarchy'))))
123
  CACHE (0.0ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 22)) AND (projects.`lft` >= 34 AND projects.`rgt` <= 35))
124
Rendered queries/_filters (95.0ms)
125
Rendered queries/_columns (1.4ms)
126
  User Load (0.2ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
127
  CustomValue Load Including Associations (0.8ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 17897 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
128
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
129
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 17922 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
130
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
131
  CustomValue Load Including Associations (0.5ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18058 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
132
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
133
  CustomValue Load Including Associations (0.5ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18299 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
134
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
135
  CustomValue Load Including Associations (0.5ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18321 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
136
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
137
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18366 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
138
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
139
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18367 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
140
  User Load (0.1ms)   SELECT * FROM `users` WHERE (`users`.`id` = 7) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
141
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18381 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
142
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
143
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18403 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
144
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
145
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18406 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
146
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
147
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18407 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
148
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
149
  CustomValue Load Including Associations (0.5ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18415 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
150
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
151
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18416 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
152
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
153
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18418 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
154
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
155
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18420 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
156
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
157
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18423 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
158
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
159
  CustomValue Load Including Associations (0.7ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18424 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
160
  CACHE (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 2) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
161
  CustomValue Load Including Associations (0.4ms)   SELECT `custom_values`.`id` AS t0_r0, `custom_values`.`customized_type` AS t0_r1, `custom_values`.`customized_id` AS t0_r2, `custom_values`.`custom_field_id` AS t0_r3, `custom_values`.`value` AS t0_r4, `custom_fields`.`id` AS t1_r0, `custom_fields`.`type` AS t1_r1, `custom_fields`.`name` AS t1_r2, `custom_fields`.`field_format` AS t1_r3, `custom_fields`.`possible_values` AS t1_r4, `custom_fields`.`regexp` AS t1_r5, `custom_fields`.`min_length` AS t1_r6, `custom_fields`.`max_length` AS t1_r7, `custom_fields`.`is_required` AS t1_r8, `custom_fields`.`is_for_all` AS t1_r9, `custom_fields`.`is_filter` AS t1_r10, `custom_fields`.`position` AS t1_r11, `custom_fields`.`searchable` AS t1_r12, `custom_fields`.`default_value` AS t1_r13, `custom_fields`.`editable` AS t1_r14, `custom_fields`.`visible` AS t1_r15 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 18425 AND `custom_values`.customized_type = 'Issue') ORDER BY custom_fields.position
162
Rendered issues/_list (80.3ms)
163
  Token Load (0.3ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 7 AND (action='feeds')) LIMIT 1
164
  Query Load (0.3ms)   SELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 7) AND (project_id IS NULL OR project_id = 22)) ORDER BY name ASC
165
Rendered issues/_sidebar (2.3ms)
166
  Project Load (0.3ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 7) AND ((projects.status=1)))
167
  SQL (0.3ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status=1) AND (projects.id != 22)) AND (projects.`lft` <= 34 AND projects.`rgt` >= 35))
168
  Project Load (0.4ms)   SELECT * FROM `projects` WHERE (((projects.status=1) AND (projects.id != 22)) AND (projects.`lft` <= 34 AND projects.`rgt` >= 35)) ORDER BY `lft`
169
  Wiki Load (0.2ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 22) LIMIT 1
170
  SQL (0.1ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 22)
171
  Repository Load (0.2ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 22) LIMIT 1
172
Completed in 400ms (View: 255, DB: 129) | 200 OK [http://sb01vmlx/projects/servicedesk/issues]
173

    
174

    
(1-1/2)