successful issue listing

Processing IssuesController#index (for 192.168.100.23 at 2012-04-23 09:11:04) [GET]
  Parameters: {"action"=>"index", "controller"=>"issues", "project_id"=>"desktopissues"}
  Setting Columns (2.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.4ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`
  User Columns (1.6ms)   SHOW FIELDS FROM `users`
  User Load (0.5ms)   SELECT * FROM `users` WHERE (`users`.`id` = 4) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
  Project Columns (1.4ms)   SHOW FIELDS FROM `projects`
  Project Load (0.5ms)   SELECT * FROM `projects` WHERE (`projects`.`identifier` = 'desktopissues') LIMIT 1
  EnabledModule Load (0.5ms)   SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 5)
  EnabledModule Columns (1.0ms)   SHOW FIELDS FROM `enabled_modules`
  Query Columns (1.3ms)   SHOW FIELDS FROM `queries`
  IssueCustomField Columns (1.6ms)   SHOW FIELDS FROM `custom_fields`
  IssueCustomField Load (0.5ms)   SELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position
  custom_fields_projects Columns (0.9ms)   SHOW FIELDS FROM `custom_fields_projects`
  IssueCustomField Load (0.5ms)   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 = 5 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
  Tracker Load (0.8ms)   SELECT DISTINCT trackers.* FROM `trackers` INNER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id INNER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 7 AND projects.rgt <= 8 AND projects.status = 1) ORDER BY trackers.position
  IssueStatus Load (0.4ms)   SELECT * FROM `issue_statuses` ORDER BY position
  IssueStatus Columns (1.1ms)   SHOW FIELDS FROM `issue_statuses`
  Tracker Columns (1.1ms)   SHOW FIELDS FROM `trackers`
  IssuePriority Columns (1.2ms)   SHOW FIELDS FROM `enumerations`
  IssuePriority Load (0.5ms)   SELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC
  Principal Load (0.9ms)   SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 5) AND ((users.type='Group' OR (users.type='User' AND users.status=1))))
  Principal Columns (17.4ms)   SHOW FIELDS FROM `users`
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_group_assignment') LIMIT 1
  Group Columns (1.5ms)   SHOW FIELDS FROM `users`
  Group Load (0.4ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'Group' ) )
  Role Load (0.5ms)   SELECT * FROM `roles` WHERE (builtin = 0) ORDER BY position
  Role Columns (1.1ms)   SHOW FIELDS FROM `roles`
  IssueCategory Load (0.6ms)   SELECT * FROM `issue_categories` WHERE (`issue_categories`.project_id = 5) ORDER BY issue_categories.name
  IssueCategory Columns (1.0ms)   SHOW FIELDS FROM `issue_categories`
  Version Columns (1.3ms)   SHOW FIELDS FROM `versions`
  Version Load Including Associations (0.9ms)   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, `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 = 5 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 8 AND versions.sharing = 'tree') OR (projects.lft < 7 AND projects.rgt > 8 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 7 AND projects.rgt < 8 AND versions.sharing = 'hierarchy'))))
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1
  SQL (0.6ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 5)) AND (projects.`lft` >= 7 AND projects.`rgt` <= 8))
  Issue Columns (1.8ms)   SHOW FIELDS FROM `issues`
  SQL (1.8ms)   SELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id WHERE ((issue_statuses.is_closed=0) AND projects.id = 5) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))
  CACHE (0.0ms)   SELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 5)) AND (projects.`lft` >= 7 AND projects.`rgt` <= 8))
  Issue Load Including Associations (8.8ms)   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, `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, `issue_statuses`.`id` AS t2_r0, `issue_statuses`.`name` AS t2_r1, `issue_statuses`.`is_closed` AS t2_r2, `issue_statuses`.`is_default` AS t2_r3, `issue_statuses`.`position` AS t2_r4, `issue_statuses`.`default_done_ratio` AS t2_r5, `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, `users`.`salt` AS t3_r16, `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 FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id 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 = 5) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) ORDER BY issues.id DESC LIMIT 0, 25
Rendering template within layouts/base
Rendering issues/index
  Setting Load (0.5ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'start_of_week') LIMIT 1
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
Rendered queries/_filters (72.4ms)
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1
Rendered queries/_columns (9.4ms)
  UserPreference Load (0.4ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 4) LIMIT 1
  UserPreference Columns (1.1ms)   SHOW FIELDS FROM `user_preferences`
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'date_format') LIMIT 1
  Setting Load (0.4ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
Rendered issues/_list (66.7ms)
  Token Load (0.5ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 4 AND (action='feeds')) LIMIT 1
  Token Columns (1.1ms)   SHOW FIELDS FROM `tokens`
  Query Load (0.7ms)   SELECT id, name, is_public FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 4) AND (project_id IS NULL OR project_id = 5)) ORDER BY name ASC
Rendered issues/_sidebar (15.0ms)
  Setting Load (0.5ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
  Member Columns (1.1ms)   SHOW FIELDS FROM `members`
  Member Load Including Associations (2.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, `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, `roles`.`issues_visibility` AS t2_r6 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 = 4 AND (projects.status=1)) ORDER BY projects.name
  SQL (0.8ms)   SELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 5 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 7 AND projects.rgt <= 8 AND versions.sharing = 'tree') OR (projects.lft < 7 AND projects.rgt > 8 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 7 AND projects.rgt < 8 AND versions.sharing = 'hierarchy'))))
  Wiki Load (0.4ms)   SELECT * FROM `wikis` WHERE (`wikis`.project_id = 5) LIMIT 1
  Board Columns (1.2ms)   SHOW FIELDS FROM `boards`
  SQL (0.4ms)   SELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 5)
  Repository Load (0.4ms)   SELECT * FROM `repositories` WHERE (`repositories`.project_id = 5) LIMIT 1
Completed in 617ms (View: 295, DB: 71) | 200 OK [https://redmine/projects/desktopissues/issues]