1
|
Started GET "/" for 10.162.2.71 at Mon Jul 02 14:11:56 +0400 2012
|
2
|
Processing by WelcomeController#index as HTML
|
3
|
[1m[35m (0.0ms)[0m SELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings`
|
4
|
[1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = ? AND (users.status = 1) LIMIT 1[0m [["id", 3]]
|
5
|
[1m[35mSQL (0.0ms)[0m SELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `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, `users`.`id` AS t2_r0, `users`.`login` AS t2_r1, `users`.`hashed_password` AS t2_r2, `users`.`firstname` AS t2_r3, `users`.`lastname` AS t2_r4, `users`.`mail` AS t2_r5, `users`.`admin` AS t2_r6, `users`.`status` AS t2_r7, `users`.`last_login_on` AS t2_r8, `users`.`language` AS t2_r9, `users`.`auth_source_id` AS t2_r10, `users`.`created_on` AS t2_r11, `users`.`updated_on` AS t2_r12, `users`.`type` AS t2_r13, `users`.`identity_url` AS t2_r14, `users`.`mail_notification` AS t2_r15, `users`.`salt` AS t2_r16 FROM `news` LEFT OUTER JOIN `projects` ON `projects`.`id` = `news`.`project_id` LEFT OUTER JOIN `users` ON `users`.`id` = `news`.`author_id` AND `users`.`type` IN ('User', 'AnonymousUser') WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5
|
6
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5[0m
|
7
|
[1m[35mUserPreference Load (0.0ms)[0m SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 3 LIMIT 1
|
8
|
[1m[36mToken Load (0.0ms)[0m [1mSELECT `tokens`.* FROM `tokens` WHERE `tokens`.`user_id` = 3 AND (action='feeds') LIMIT 1[0m
|
9
|
Rendered welcome/index.html.erb within layouts/base (0.0ms)
|
10
|
[1m[35mSQL (0.0ms)[0m 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 `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 3 AND (projects.status=1) ORDER BY projects.name
|
11
|
Completed 200 OK in 47ms (Views: 31.2ms | ActiveRecord: 0.0ms)
|
12
|
Connecting to database specified by database.yml
|
13
|
OpenIdAuthentication.store is nil. Using in-memory store.
|
14
|
Creating scope :active. Overwriting existing method User.active.
|
15
|
Creating scope :open. Overwriting existing method Version.open.
|
16
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at c:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
17
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at c:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
18
|
Creating scope :open. Overwriting existing method Issue.open.
|
19
|
|
20
|
|
21
|
Started PUT "/issues/312" for 10.162.2.71 at Wed Jul 04 09:13:14 +0400 2012
|
22
|
Processing by IssuesController#update as HTML
|
23
|
Parameters: {"commit"=>"Submit", "last_journal_id"=>"", "notes"=>"", "authenticity_token"=>"vHn3EJM+sEltJmEhavIiae4uuhUQpiIW1xNOKv2xA58=", "utf8"=>"✓", "id"=>"312", "issue"=>{"start_date"=>"2012-05-03 00:00:00", "estimated_hours"=>"", "custom_field_values"=>{"1"=>"S10-2794", "2"=>"Конин А.Ю."}, "priority_id"=>"4", "parent_issue_id"=>"", "is_private"=>"0", "project_id"=>"20", "lock_version"=>"0", "subject"=>"Задача «Исполнительный баланс»: Ошибка при попытке сохранить «Баланс по РП».", "assigned_to_id"=>"", "done_ratio"=>"0", "tracker_id"=>"1", "due_date"=>"", "description"=>"\r\nОшибка при попытке сохранить «Баланс по РП». Роль BALANCEEDITOR.\r\n\r\n-------------------------------------------------------------------\r\nORA-06550: line 4, column 15:\r\nPL/SQL: ORA-01031: insufficient privileges\r\nORA-06550: line 4, column 3:\r\nPL/SQL: SQL Statement ignored\r\nORA-06550: line 9, column 15:\r\nPL/SQL: ORA-01031: insufficient privileges\r\nORA-06550: line 9, column 3:\r\nPL/SQL: SQL Statement ignored\r\nORA-06550: line 14, column 15:\r\nPL/SQL: ORA-01031: insufficient privileges\r\nORA-06550: line 14, column 3:\r\nPL/SQL: SQL Statement ignored\r\nORA-06550: line 19, column 15:\r\nPL/SQL: ORA-01031: insufficient privileges\r\nORA-06550: line 19, column 3:\r\nPL/SQL: SQL Statement ignored\r\nОшибка в запросе \r\n==> BalanceRP; позиция 79\r\nТекущая схема данных ASKIDADM\r\n============ Текст запроса =============\r\nbegin\r\n\r\n -- удаление ВСЕХ записей для этого РП в этот период\r\n delete from BalanceRP\r\n where Period = :Old_Period\r\n and OperRpAkId = :Old_OperRpAkId;\r\n\r\n -- запись новых данных по всем статьям.\r\n insert into BalanceRP\r\n (Period, OperRpAkId, BalanceContentId, Vol)\r\n values\r\n (:Old_Period, :Old_OperRpAkId, 1000000031, :s11_2_1);\r\n\r\n insert into BalanceRP\r\n (Period, OperRpAkId, BalanceContentId, Vol)\r\n values\r\n (:Old_Period, :Old_OperRpAkId, 1000000032, :s11_2_2);\r\n\r\n insert into BalanceRP\r\n (Period, OperRpAkId, BalanceContentId, Vol)\r\n values\r\n (:Old_Period, :Old_OperRpAkId, 1000000034, :s11_2_3);\r\n\r\nend;\r\n\r\n========== Параметры запроса ===========\r\nOld_Period [DateTime] = 01.04.2012\r\nOld_OperRpAkId [Integer] = 157\r\ns11_2_1 [Float] = 12\r\ns11_2_2 [Float] = \r\ns11_2_3 [Float] = \r\n", "status_id"=>"1"}, "attachments"=>{"1"=>{"description"=>""}}}
|
24
|
[1m[36m (0.0ms)[0m [1mSELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings` [0m
|
25
|
[1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = ? AND (users.status = 1) LIMIT 1 [["id", 3]]
|
26
|
[1m[36mIssue Load (93.6ms)[0m [1mSELECT `issues`.* FROM `issues` WHERE `issues`.`id` = ? LIMIT 1[0m [["id", "312"]]
|
27
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (20)
|
28
|
[1m[36mTracker Load (0.0ms)[0m [1mSELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` IN (1)[0m
|
29
|
[1m[35mIssueStatus Load (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (1)
|
30
|
[1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` IN (4)[0m
|
31
|
[1m[35mIssuePriority Load (0.0ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` IN (4) ORDER BY enumerations.position ASC
|
32
|
[1m[36mEnabledModule Load (0.0ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 20[0m
|
33
|
[1m[35mTimeEntryActivity Load (0.0ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('TimeEntryActivity') AND `enumerations`.`is_default` = 1 ORDER BY enumerations.position ASC LIMIT 1
|
34
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
35
|
[1m[35mIssueCustomField Load (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 20 ORDER BY custom_fields.position
|
36
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.`id` = `custom_fields_trackers`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_trackers`.`tracker_id` = 1[0m
|
37
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 312 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
38
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))[0m
|
39
|
[1m[35mIssueStatus Load (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
40
|
[1m[36mRole Load (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
41
|
[1m[35mWorkflow Load (0.0ms)[0m SELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 1 AND ((author = 0 AND assignee = 0)))
|
42
|
[1m[36mIssueStatus Load (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 7, 8)[0m
|
43
|
[1m[35mIssueRelation Load (0.0ms)[0m SELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_to_id` = 312
|
44
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))[0m
|
45
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
46
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
47
|
[1m[35mTracker Load (0.0ms)[0m SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1
|
48
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 1 AND ((author = 0 AND assignee = 0)))[0m
|
49
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 7, 8)
|
50
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.`id` = `custom_fields_trackers`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_trackers`.`tracker_id` = 1[0m
|
51
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
52
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
53
|
[1m[35mCACHE (0.0ms)[0m SELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 1 AND ((author = 0 AND assignee = 0)))
|
54
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 7, 8)[0m
|
55
|
[1m[35mSQL (0.0ms)[0m BEGIN
|
56
|
[1m[36mIssuePriority Load (78.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 4 ORDER BY enumerations.position ASC LIMIT 1[0m
|
57
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
58
|
[1m[36mIssue Load (0.0ms)[0m [1mSELECT `issues`.* FROM `issues` WHERE `issues`.`root_id` = 312 AND (`issues`.`lft` <= 1 AND `issues`.`rgt` >= 2) AND (`issues`.id != 312) ORDER BY `issues`.`lft`[0m
|
59
|
[1m[35m (0.0ms)[0m UPDATE `issues` SET `updated_on` = '2012-07-04 09:13:14', `lock_version` = 1 WHERE (`issues`.`id` = 312 AND `issues`.`lock_version` = 0)
|
60
|
[1m[36m (0.0ms)[0m [1mUPDATE `custom_values` SET `value` = 'S10-2794' WHERE `custom_values`.`id` = 781[0m
|
61
|
[1m[35m (0.0ms)[0m UPDATE `custom_values` SET `value` = 'Конин А.Ю.' WHERE `custom_values`.`id` = 782
|
62
|
[1m[36mSQL (0.0ms)[0m [1mINSERT INTO `journals` (`created_on`, `journalized_id`, `journalized_type`, `notes`, `user_id`) VALUES (?, ?, ?, ?, ?)[0m [["created_on", Wed, 04 Jul 2012 05:13:14 UTC +00:00], ["journalized_id", 312], ["journalized_type", "Issue"], ["notes", ""], ["user_id", 3]]
|
63
|
[1m[35mSQL (0.0ms)[0m INSERT INTO `journal_details` (`journal_id`, `old_value`, `prop_key`, `property`, `value`) VALUES (?, ?, ?, ?, ?) [["journal_id", 782], ["old_value", ""], ["prop_key", 1], ["property", "cf"], ["value", "S10-2794"]]
|
64
|
[1m[36mSQL (0.0ms)[0m [1mINSERT INTO `journal_details` (`journal_id`, `old_value`, `prop_key`, `property`, `value`) VALUES (?, ?, ?, ?, ?)[0m [["journal_id", 782], ["old_value", ""], ["prop_key", 2], ["property", "cf"], ["value", "Конин А.Ю."]]
|
65
|
[1m[35mIssue Load (0.0ms)[0m SELECT `issues`.* FROM `issues` WHERE `issues`.`id` = ? LIMIT 1 [["id", 312]]
|
66
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 20 LIMIT 1[0m
|
67
|
[1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 4 LIMIT 1
|
68
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `users`.`salt` AS t1_r16, `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 `users` ON `users`.`id` = `members`.`user_id` AND `users`.`type` IN ('User', 'AnonymousUser') LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`project_id` = 20 AND (users.type='User' AND users.status=1)[0m
|
69
|
[1m[35mEnabledModule Load (0.0ms)[0m SELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 20
|
70
|
[1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 312 AND `watchers`.`watchable_type` = 'Issue' AND (users.status = 1)[0m
|
71
|
[1m[35mTracker Load (0.0ms)[0m SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 1 LIMIT 1
|
72
|
[1m[36mUserPreference Load (0.0ms)[0m [1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 3 LIMIT 1[0m
|
73
|
[1m[35mCustomField Load (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 1 LIMIT 1
|
74
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 1 LIMIT 1[0m
|
75
|
[1m[35mCustomField Load (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 2 LIMIT 1
|
76
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 2 LIMIT 1[0m
|
77
|
[1m[35mIssueStatus Load (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
78
|
[1m[36mIssuePriority Load (0.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 4 ORDER BY enumerations.position ASC LIMIT 1[0m
|
79
|
Rendered mailer/_issue.text.erb (0.0ms)
|
80
|
Rendered mailer/issue_edit.text.erb within layouts/mailer (0.0ms)
|
81
|
[1m[35mCACHE (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 1 LIMIT 1
|
82
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 1 LIMIT 1[0m
|
83
|
[1m[35mCACHE (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 2 LIMIT 1
|
84
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`id` = 2 LIMIT 1[0m
|
85
|
Rendered mailer/_issue.html.erb (15.6ms)
|
86
|
Rendered mailer/issue_edit.html.erb within layouts/mailer (15.6ms)
|
87
|
[1m[35m (0.0ms)[0m COMMIT
|
88
|
Redirected to http://as06-uht:8888/issues/312
|
89
|
Completed 302 Found in 655ms (ActiveRecord: 171.6ms)
|
90
|
Connecting to database specified by database.yml
|
91
|
OpenIdAuthentication.store is nil. Using in-memory store.
|
92
|
Creating scope :active. Overwriting existing method User.active.
|
93
|
Creating scope :open. Overwriting existing method Version.open.
|
94
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
95
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
96
|
Creating scope :open. Overwriting existing method Issue.open.
|
97
|
|
98
|
|
99
|
Started GET "/projects/gal/issues?query_id=1" for 10.162.1.24 at Mon Jul 09 13:38:17 +0400 2012
|
100
|
Processing by IssuesController#index as HTML
|
101
|
Parameters: {"project_id"=>"gal", "query_id"=>"1"}
|
102
|
[1m[36m (0.0ms)[0m [1mSELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings` [0m
|
103
|
[1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = ? AND (users.status = 1) LIMIT 1 [["id", 17]]
|
104
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`identifier` = 'gal' LIMIT 1[0m
|
105
|
[1m[35mEnabledModule Load (0.0ms)[0m SELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 19
|
106
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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 `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 17 AND (projects.status=1) ORDER BY projects.name[0m
|
107
|
[1m[35mQuery Load (0.0ms)[0m SELECT `queries`.* FROM `queries` WHERE `queries`.`id` = ? AND (project_id IS NULL OR project_id = 19) LIMIT 1 [["id", "1"]]
|
108
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
109
|
[1m[35mIssueCustomField Load (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 19 ORDER BY custom_fields.position
|
110
|
[1m[36mRole Load (78.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1[0m
|
111
|
[1m[35mGroup Load (0.0ms)[0m SELECT `users`.* FROM `users` INNER JOIN `groups_users` ON `users`.`id` = `groups_users`.`group_id` WHERE `users`.`type` IN ('Group') AND `groups_users`.`user_id` = 17
|
112
|
[1m[36m (0.0ms)[0m [1mSELECT COUNT(*) FROM `projects` WHERE (`projects`.`lft` >= 8 AND `projects`.`rgt` <= 15) AND (`projects`.id != 19) AND (projects.status = 1)[0m
|
113
|
[1m[35m (0.0ms)[0m SELECT COUNT(DISTINCT `issues`.`id`) 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 (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.is_public = 1 AND ((issues.is_private = 0 OR issues.author_id = 17 OR issues.assigned_to_id IN (17,15)))) OR (projects.id IN (38,19) AND ((issues.is_private = 0 OR issues.author_id = 17 OR issues.assigned_to_id IN (17,15))))))) AND (projects.id = 19)
|
114
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1[0m
|
115
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `projects` WHERE (`projects`.`lft` >= 8 AND `projects`.`rgt` <= 15) AND (`projects`.id != 19) AND (projects.status = 1)
|
116
|
[1m[36mSQL (15.6ms)[0m [1mSELECT `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` IN ('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 (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND ((projects.is_public = 1 AND ((issues.is_private = 0 OR issues.author_id = 17 OR issues.assigned_to_id IN (17,15)))) OR (projects.id IN (38,19) AND ((issues.is_private = 0 OR issues.author_id = 17 OR issues.assigned_to_id IN (17,15))))))) AND (projects.id = 19) ORDER BY issues.id DESC LIMIT 25 OFFSET 0[0m
|
117
|
[1m[35mTracker Load (0.0ms)[0m 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 >= 8 AND projects.rgt <= 15 AND projects.status = 1) ORDER BY trackers.position
|
118
|
[1m[36mIssueStatus Load (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` ORDER BY position[0m
|
119
|
[1m[35mIssuePriority Load (0.0ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') ORDER BY enumerations.position ASC
|
120
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.`id` = `members`.`user_id` WHERE `members`.`project_id` = 19 AND (users.type='Group' OR (users.type='User' AND users.status=1))[0m
|
121
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1
|
122
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (`projects`.`lft` >= 8 AND `projects`.`rgt` <= 15) AND (`projects`.id != 19) AND (((projects.status=1) AND (projects.is_public = 1 OR projects.id IN (38,19)))) ORDER BY `projects`.`lft`[0m
|
123
|
[1m[35mGroup Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('Group')
|
124
|
[1m[36mRole Load (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE (builtin = 0) ORDER BY position[0m
|
125
|
[1m[35mIssueCategory Load (15.6ms)[0m SELECT `issue_categories`.* FROM `issue_categories` WHERE `issue_categories`.`project_id` = 19 ORDER BY issue_categories.name
|
126
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 8 AND `projects`.`rgt` >= 15) ORDER BY `projects`.`lft` LIMIT 1[0m
|
127
|
[1m[35mSQL (0.0ms)[0m 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 = 19 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 3 AND projects.rgt <= 82 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 15 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 15 AND versions.sharing = 'hierarchy'))))
|
128
|
Rendered queries/_filters.html.erb (31.2ms)
|
129
|
Rendered queries/_columns.html.erb (0.0ms)
|
130
|
[1m[36mSQL (15.6ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 436 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
131
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 435 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
132
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 434 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
133
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 399 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
134
|
[1m[36mSQL (78.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 397 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
135
|
[1m[35mSQL (15.6ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 396 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
136
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 395 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
137
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 394 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
138
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 392 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
139
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 391 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
140
|
[1m[36mSQL (15.6ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 389 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
141
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 388 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
142
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 386 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
143
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 385 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
144
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 384 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
145
|
[1m[35mSQL (15.6ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 379 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
146
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 378 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
147
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 377 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
148
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 376 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
149
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 366 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
150
|
[1m[36mSQL (15.6ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 362 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
151
|
[1m[35mSQL (0.0ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 361 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
152
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 360 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
153
|
[1m[35mSQL (93.6ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 358 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
154
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 357 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position[0m
|
155
|
Rendered issues/_list.html.erb (390.0ms)
|
156
|
[1m[35mToken Load (0.0ms)[0m SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`user_id` = 17 AND (action='feeds') LIMIT 1
|
157
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1[0m
|
158
|
[1m[35mSQL (0.0ms)[0m SELECT `queries`.`id` AS t0_r0, `queries`.`project_id` AS t0_r1, `queries`.`name` AS t0_r2, `queries`.`filters` AS t0_r3, `queries`.`user_id` AS t0_r4, `queries`.`is_public` AS t0_r5, `queries`.`column_names` AS t0_r6, `queries`.`sort_criteria` AS t0_r7, `queries`.`group_by` AS t0_r8, `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 `queries` LEFT OUTER JOIN `projects` ON `projects`.`id` = `queries`.`project_id` WHERE ((queries.project_id IS NULL OR (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (projects.is_public = 1 OR projects.id IN (38,19))))) AND (queries.is_public = 1 OR queries.user_id = 17)) AND (project_id IS NULL OR project_id = 19) ORDER BY queries.name ASC
|
159
|
Rendered issues/_sidebar.html.erb (0.0ms)
|
160
|
Rendered issues/index.html.erb within layouts/base (452.4ms)
|
161
|
[1m[36mUserPreference Load (0.0ms)[0m [1mSELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 17 LIMIT 1[0m
|
162
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles` WHERE `roles`.`builtin` = 1 LIMIT 1
|
163
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (`projects`.`lft` <= 8 AND `projects`.`rgt` >= 15) AND (`projects`.id != 19) AND (((projects.status=1) AND (projects.is_public = 1 OR projects.id IN (38,19)))) ORDER BY `projects`.`lft`[0m
|
164
|
[1m[35mWiki Load (0.0ms)[0m SELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 19 LIMIT 1
|
165
|
[1m[36m (0.0ms)[0m [1mSELECT COUNT(*) FROM `boards` WHERE `boards`.`project_id` = 19[0m
|
166
|
[1m[35mRepository Load (0.0ms)[0m SELECT `repositories`.* FROM `repositories` WHERE `repositories`.`project_id` = 19 AND (is_default = 1) LIMIT 1
|
167
|
Completed 200 OK in 624ms (Views: 218.4ms | ActiveRecord: 358.8ms)
|
168
|
Connecting to database specified by database.yml
|
169
|
OpenIdAuthentication.store is nil. Using in-memory store.
|
170
|
Creating scope :active. Overwriting existing method User.active.
|
171
|
Creating scope :open. Overwriting existing method Version.open.
|
172
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
173
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
174
|
Creating scope :open. Overwriting existing method Issue.open.
|
175
|
|
176
|
|
177
|
Started GET "/projects/roprmn/issues/new" for 10.162.1.24 at Mon Jul 09 15:31:48 +0400 2012
|
178
|
Processing by IssuesController#new as HTML
|
179
|
Parameters: {"project_id"=>"roprmn"}
|
180
|
[1m[35m (0.0ms)[0m SELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings`
|
181
|
[1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = ? AND (users.status = 1) LIMIT 1[0m [["id", 10]]
|
182
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`identifier` = 'roprmn' LIMIT 1
|
183
|
[1m[36mEnabledModule Load (0.0ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 2[0m
|
184
|
[1m[35mIssueStatus Load (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE (is_default=1) LIMIT 1
|
185
|
[1m[36mIssueStatus Load (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 0 LIMIT 1[0m
|
186
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE (is_default=1) LIMIT 1
|
187
|
[1m[36mIssuePriority Load (0.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` = 0 ORDER BY enumerations.position ASC LIMIT 1[0m
|
188
|
[1m[35mIssuePriority Load (0.0ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`is_default` = 1 ORDER BY enumerations.position ASC LIMIT 1
|
189
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 0 LIMIT 1[0m
|
190
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 2 LIMIT 1
|
191
|
[1m[36mTracker Load (0.0ms)[0m [1mSELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` = 0 LIMIT 1[0m
|
192
|
[1m[35mTracker Load (0.0ms)[0m SELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 2 ORDER BY trackers.position LIMIT 1
|
193
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE (is_default=1) LIMIT 1[0m
|
194
|
[1m[35mRole Load (78.0ms)[0m SELECT `roles`.* FROM `roles`
|
195
|
[1m[36mWorkflow Load (15.6ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 1 AND ((author = 0 AND assignee = 0) OR author = 1))[0m
|
196
|
[1m[35mIssueStatus Load (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 7, 8)
|
197
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE (is_default=1) LIMIT 1[0m
|
198
|
[1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.`id` = `members`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `members`.`project_id` = 2 AND (users.type='User' AND users.status=1)
|
199
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE (is_default=1) LIMIT 1[0m
|
200
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles`
|
201
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 1 AND ((author = 0 AND assignee = 0) OR author = 1))[0m
|
202
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 7, 8)
|
203
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 2[0m
|
204
|
[1m[35mTracker Load (15.6ms)[0m SELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 2 ORDER BY trackers.position
|
205
|
[1m[36mIssuePriority Load (0.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`active` = 1 ORDER BY enumerations.position ASC[0m
|
206
|
[1m[35mSQL (0.0ms)[0m 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, `users`.`salt` AS t1_r16, `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 `users` ON `users`.`id` = `members`.`user_id` AND `users`.`type` IN ('User', 'AnonymousUser') LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`project_id` = 2 AND (users.type='User' AND users.status=1)
|
207
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 4 LIMIT 1[0m
|
208
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 5 LIMIT 1
|
209
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 9 LIMIT 1[0m
|
210
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 10 LIMIT 1
|
211
|
[1m[36m (0.0ms)[0m [1mSELECT COUNT(*) FROM `issue_categories` WHERE `issue_categories`.`project_id` = 2[0m
|
212
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 43 AND `projects`.`rgt` >= 54) ORDER BY `projects`.`lft` LIMIT 1
|
213
|
[1m[36mVersion Load (0.0ms)[0m [1mSELECT `versions`.* FROM `versions` WHERE `versions`.`id` IS NULL LIMIT 1[0m
|
214
|
[1m[35mSQL (0.0ms)[0m 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 `versions`.`status` = 'open' AND (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 3 AND projects.rgt <= 82 AND versions.sharing = 'tree') OR (projects.lft < 43 AND projects.rgt > 54 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 43 AND projects.rgt < 54 AND versions.sharing = 'hierarchy'))))
|
215
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
216
|
[1m[35mIssueCustomField Load (15.6ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 2 ORDER BY custom_fields.position
|
217
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.`id` = `custom_fields_trackers`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_trackers`.`tracker_id` = 1[0m
|
218
|
Rendered issues/_form_custom_fields.html.erb (15.6ms)
|
219
|
Rendered issues/_attributes.html.erb (31.2ms)
|
220
|
Rendered issues/_form.html.erb (46.8ms)
|
221
|
Rendered attachments/_form.html.erb (0.0ms)
|
222
|
Rendered issues/new.html.erb within layouts/base (46.8ms)
|
223
|
[1m[35mUserPreference Load (0.0ms)[0m SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 10 LIMIT 1
|
224
|
[1m[36mSQL (62.4ms)[0m [1mSELECT `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 `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 10 AND (projects.status=1) ORDER BY projects.name[0m
|
225
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE (`projects`.`lft` <= 43 AND `projects`.`rgt` >= 54) AND (`projects`.id != 2) AND (projects.status=1) ORDER BY `projects`.`lft`
|
226
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 43 AND `projects`.`rgt` >= 54) ORDER BY `projects`.`lft` LIMIT 1[0m
|
227
|
[1m[35m (0.0ms)[0m SELECT COUNT(DISTINCT `versions`.`id`) FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.`id` = `versions`.`project_id` WHERE (projects.id = 2 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 3 AND projects.rgt <= 82 AND versions.sharing = 'tree') OR (projects.lft < 43 AND projects.rgt > 54 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 43 AND projects.rgt < 54 AND versions.sharing = 'hierarchy'))))
|
228
|
[1m[36mWiki Load (0.0ms)[0m [1mSELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 2 LIMIT 1[0m
|
229
|
[1m[35m (0.0ms)[0m SELECT COUNT(*) FROM `boards` WHERE `boards`.`project_id` = 2
|
230
|
[1m[36mRepository Load (0.0ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`project_id` = 2 AND (is_default = 1) LIMIT 1[0m
|
231
|
Completed 200 OK in 265ms (Views: 62.4ms | ActiveRecord: 187.2ms)
|
232
|
Connecting to database specified by database.yml
|
233
|
OpenIdAuthentication.store is nil. Using in-memory store.
|
234
|
Creating scope :active. Overwriting existing method User.active.
|
235
|
Creating scope :open. Overwriting existing method Version.open.
|
236
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
237
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
238
|
Creating scope :open. Overwriting existing method Issue.open.
|
239
|
|
240
|
|
241
|
Started GET "/issues/434" for 10.162.2.155 at Tue Jul 10 10:22:52 +0400 2012
|
242
|
Processing by IssuesController#show as HTML
|
243
|
Parameters: {"id"=>"434"}
|
244
|
[1m[35m (0.0ms)[0m SELECT MAX(`settings`.`updated_on`) AS max_id FROM `settings`
|
245
|
[1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = ? AND (users.status = 1) LIMIT 1[0m [["id", 11]]
|
246
|
[1m[35mIssue Load (0.0ms)[0m SELECT `issues`.* FROM `issues` WHERE `issues`.`id` = ? LIMIT 1 [["id", "434"]]
|
247
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`id` IN (19)[0m
|
248
|
[1m[35mTracker Load (0.0ms)[0m SELECT `trackers`.* FROM `trackers` WHERE `trackers`.`id` IN (9)
|
249
|
[1m[36mIssueStatus Load (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (1)[0m
|
250
|
[1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` IN (12)
|
251
|
[1m[36mIssuePriority Load (0.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` IN (4) ORDER BY enumerations.position ASC[0m
|
252
|
[1m[35mEnabledModule Load (0.0ms)[0m SELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 19
|
253
|
[1m[36mJournal Load (15.6ms)[0m [1mSELECT `journals`.* FROM `journals` WHERE `journals`.`journalized_id` = 434 AND `journals`.`journalized_type` = 'Issue' ORDER BY journals.created_on ASC[0m
|
254
|
[1m[35mUserPreference Load (0.0ms)[0m SELECT `user_preferences`.* FROM `user_preferences` WHERE `user_preferences`.`user_id` = 11 LIMIT 1
|
255
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `changesets`.`id` AS t0_r0, `changesets`.`repository_id` AS t0_r1, `changesets`.`revision` AS t0_r2, `changesets`.`committer` AS t0_r3, `changesets`.`committed_on` AS t0_r4, `changesets`.`comments` AS t0_r5, `changesets`.`commit_date` AS t0_r6, `changesets`.`scmid` AS t0_r7, `changesets`.`user_id` AS t0_r8, `repositories`.`id` AS t1_r0, `repositories`.`project_id` AS t1_r1, `repositories`.`url` AS t1_r2, `repositories`.`login` AS t1_r3, `repositories`.`password` AS t1_r4, `repositories`.`root_url` AS t1_r5, `repositories`.`type` AS t1_r6, `repositories`.`path_encoding` AS t1_r7, `repositories`.`log_encoding` AS t1_r8, `repositories`.`extra_info` AS t1_r9, `repositories`.`identifier` AS t1_r10, `repositories`.`is_default` AS t1_r11, `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 FROM `changesets` LEFT OUTER JOIN `repositories` ON `repositories`.`id` = `changesets`.`repository_id` LEFT OUTER JOIN `projects` ON `projects`.`id` = `repositories`.`project_id` INNER JOIN `changesets_issues` ON `changesets`.`id` = `changesets_issues`.`changeset_id` WHERE `changesets_issues`.`issue_id` = 434 AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) ORDER BY changesets.committed_on ASC, changesets.id ASC[0m
|
256
|
[1m[35mIssueRelation Load (78.0ms)[0m SELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_from_id` = 434
|
257
|
[1m[36mIssueRelation Load (0.0ms)[0m [1mSELECT `issue_relations`.* FROM `issue_relations` WHERE `issue_relations`.`issue_to_id` = 434[0m
|
258
|
[1m[35mIssueStatus Load (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1
|
259
|
[1m[36mRole Load (0.0ms)[0m [1mSELECT `roles`.* FROM `roles` [0m
|
260
|
[1m[35mWorkflow Load (0.0ms)[0m SELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 9 AND ((author = 0 AND assignee = 0)))
|
261
|
[1m[36mIssueStatus Load (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 6)[0m
|
262
|
[1m[35mTimeEntryActivity Load (0.0ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('TimeEntryActivity') AND `enumerations`.`is_default` = 1 ORDER BY enumerations.position ASC LIMIT 1
|
263
|
[1m[36mQuery Load (0.0ms)[0m [1mSELECT `queries`.* FROM `queries` WHERE `queries`.`id` = 1 LIMIT 1[0m
|
264
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 19 LIMIT 1
|
265
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
266
|
[1m[35mIssueCustomField Load (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 19 ORDER BY custom_fields.position
|
267
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM `enabled_modules` WHERE `enabled_modules`.`project_id` = 19[0m
|
268
|
[1m[35m (0.0ms)[0m SELECT COUNT(*) FROM `projects` WHERE (`projects`.`lft` >= 8 AND `projects`.`rgt` <= 15) AND (`projects`.id != 19) AND (projects.status = 1)
|
269
|
[1m[36mSQL (0.0ms)[0m [1mSELECT issues.id 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` IN ('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 (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (projects.id = 19) ORDER BY issues.id DESC LIMIT 501[0m
|
270
|
[1m[35m (0.0ms)[0m SELECT `users`.id FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 434 AND `watchers`.`watchable_type` = 'Issue'
|
271
|
Rendered issues/_action_menu.html.erb (15.6ms)
|
272
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 14 LIMIT 1[0m
|
273
|
[1m[35m (0.0ms)[0m SELECT SUM(time_entries.hours) AS sum_id FROM `issues` LEFT JOIN time_entries ON time_entries.issue_id = issues.id WHERE `issues`.`root_id` = 434 AND (`issues`.`lft` >= 1 AND `issues`.`rgt` <= 2)
|
274
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND (is_for_all=1) ORDER BY position[0m
|
275
|
[1m[35mCACHE (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.`id` = `custom_fields_projects`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_projects`.`project_id` = 19 ORDER BY custom_fields.position
|
276
|
[1m[36mIssueCustomField Load (0.0ms)[0m [1mSELECT `custom_fields`.* FROM `custom_fields` INNER JOIN `custom_fields_trackers` ON `custom_fields`.`id` = `custom_fields_trackers`.`custom_field_id` WHERE `custom_fields`.`type` IN ('IssueCustomField') AND `custom_fields_trackers`.`tracker_id` = 9[0m
|
277
|
[1m[35mSQL (15.6ms)[0m 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, `custom_fields`.`multiple` AS t1_r16 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.`id` = `custom_values`.`custom_field_id` WHERE `custom_values`.`customized_id` = 434 AND `custom_values`.`customized_type` = 'Issue' ORDER BY custom_fields.position
|
278
|
[1m[36m (0.0ms)[0m [1mSELECT COUNT(*) FROM `attachments` WHERE `attachments`.`container_id` = 434 AND `attachments`.`container_type` = 'Issue'[0m
|
279
|
[1m[35mCACHE (0.0ms)[0m SELECT COUNT(*) FROM `attachments` WHERE `attachments`.`container_id` = 434 AND `attachments`.`container_type` = 'Issue'
|
280
|
[1m[36mAttachment Load (62.4ms)[0m [1mSELECT `attachments`.* FROM `attachments` WHERE `attachments`.`container_id` = 434 AND `attachments`.`container_type` = 'Issue' ORDER BY attachments.created_on[0m
|
281
|
[1m[35mUser Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`id` = 12 LIMIT 1
|
282
|
Rendered attachments/_links.html.erb (62.4ms)
|
283
|
Rendered issue_relations/_form.html.erb (15.6ms)
|
284
|
Rendered issues/_relations.html.erb (15.6ms)
|
285
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `users`.id FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 434 AND `watchers`.`watchable_type` = 'Issue'[0m
|
286
|
Rendered issues/_action_menu.html.erb (0.0ms)
|
287
|
[1m[35mProject Load (0.0ms)[0m SELECT `projects`.* FROM `projects` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))
|
288
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` = 1 LIMIT 1[0m
|
289
|
[1m[35mCACHE (0.0ms)[0m SELECT `roles`.* FROM `roles`
|
290
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `workflows`.* FROM `workflows` WHERE `workflows`.`old_status_id` = 1 AND (role_id IN (1,2,3,4,5) AND tracker_id = 9 AND ((author = 0 AND assignee = 0)))[0m
|
291
|
[1m[35mCACHE (0.0ms)[0m SELECT `issue_statuses`.* FROM `issue_statuses` WHERE `issue_statuses`.`id` IN (2, 3, 4, 5, 6)
|
292
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))[0m
|
293
|
[1m[35mTracker Load (0.0ms)[0m SELECT `trackers`.* FROM `trackers` INNER JOIN `projects_trackers` ON `trackers`.`id` = `projects_trackers`.`tracker_id` WHERE `projects_trackers`.`project_id` = 19 ORDER BY trackers.position
|
294
|
[1m[36mIssuePriority Load (0.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`active` = 1 ORDER BY enumerations.position ASC[0m
|
295
|
[1m[35mSQL (0.0ms)[0m 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, `users`.`salt` AS t1_r16, `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 `users` ON `users`.`id` = `members`.`user_id` AND `users`.`type` IN ('User', 'AnonymousUser') LEFT OUTER JOIN `member_roles` ON `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`project_id` = 19 AND (users.type='User' AND users.status=1)
|
296
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 8 LIMIT 1[0m
|
297
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 11 LIMIT 1
|
298
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 12 LIMIT 1[0m
|
299
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 13 LIMIT 1
|
300
|
[1m[36mCACHE (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 14 LIMIT 1[0m
|
301
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 16 LIMIT 1
|
302
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 17 LIMIT 1[0m
|
303
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 18 LIMIT 1
|
304
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 19 LIMIT 1[0m
|
305
|
[1m[35mPrincipal Load (0.0ms)[0m SELECT `users`.* FROM `users` WHERE `users`.`id` = 20 LIMIT 1
|
306
|
[1m[36mPrincipal Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` WHERE `users`.`id` = 21 LIMIT 1[0m
|
307
|
[1m[35m (0.0ms)[0m SELECT COUNT(*) FROM `issue_categories` WHERE `issue_categories`.`project_id` = 19
|
308
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE `projects`.`parent_id` IS NULL AND (`projects`.`lft` <= 8 AND `projects`.`rgt` >= 15) ORDER BY `projects`.`lft` LIMIT 1[0m
|
309
|
[1m[35mVersion Load (0.0ms)[0m SELECT `versions`.* FROM `versions` WHERE `versions`.`id` IS NULL LIMIT 1
|
310
|
[1m[36mSQL (78.0ms)[0m [1mSELECT `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 `versions`.`status` = 'open' AND (projects.id = 19 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 3 AND projects.rgt <= 82 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 15 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 15 AND versions.sharing = 'hierarchy'))))[0m
|
311
|
Rendered issues/_form_custom_fields.html.erb (0.0ms)
|
312
|
Rendered issues/_attributes.html.erb (109.2ms)
|
313
|
Rendered issues/_form.html.erb (124.8ms)
|
314
|
[1m[35mTimeEntryActivity Load (0.0ms)[0m SELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('TimeEntryActivity') AND `enumerations`.`project_id` = 19 ORDER BY enumerations.position ASC
|
315
|
[1m[36mTimeEntryActivity Load (0.0ms)[0m [1mSELECT `enumerations`.* FROM `enumerations` WHERE `enumerations`.`type` IN ('TimeEntryActivity') AND `enumerations`.`project_id` IS NULL AND `enumerations`.`active` = 1 ORDER BY enumerations.position ASC[0m
|
316
|
[1m[35mCustomField Load (0.0ms)[0m SELECT `custom_fields`.* FROM `custom_fields` WHERE (type = 'TimeEntryCustomField') ORDER BY position
|
317
|
Rendered attachments/_form.html.erb (15.6ms)
|
318
|
[1m[36mJournal Load (0.0ms)[0m [1mSELECT `journals`.* FROM `journals` WHERE `journals`.`journalized_id` = 434 AND `journals`.`journalized_type` = 'Issue' ORDER BY journals.id DESC LIMIT 1[0m
|
319
|
Rendered issues/_edit.html.erb (140.4ms)
|
320
|
[1m[35mToken Load (0.0ms)[0m SELECT `tokens`.* FROM `tokens` WHERE `tokens`.`user_id` = 11 AND (action='feeds') LIMIT 1
|
321
|
[1m[36mSQL (0.0ms)[0m [1mSELECT `queries`.`id` AS t0_r0, `queries`.`project_id` AS t0_r1, `queries`.`name` AS t0_r2, `queries`.`filters` AS t0_r3, `queries`.`user_id` AS t0_r4, `queries`.`is_public` AS t0_r5, `queries`.`column_names` AS t0_r6, `queries`.`sort_criteria` AS t0_r7, `queries`.`group_by` AS t0_r8, `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 `queries` LEFT OUTER JOIN `projects` ON `projects`.`id` = `queries`.`project_id` WHERE ((queries.project_id IS NULL OR (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND (queries.is_public = 1 OR queries.user_id = 11)) AND (project_id IS NULL OR project_id = 19) ORDER BY queries.name ASC[0m
|
322
|
Rendered issues/_sidebar.html.erb (0.0ms)
|
323
|
[1m[35m (0.0ms)[0m SELECT COUNT(*) FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 434 AND `watchers`.`watchable_type` = 'Issue'
|
324
|
[1m[36mUser Load (0.0ms)[0m [1mSELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.`id` = `watchers`.`user_id` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `watchers`.`watchable_id` = 434 AND `watchers`.`watchable_type` = 'Issue'[0m
|
325
|
Rendered watchers/_watchers.html.erb (0.0ms)
|
326
|
Rendered issues/show.html.erb within layouts/base (265.2ms)
|
327
|
[1m[35mSQL (0.0ms)[0m 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 `member_roles`.`member_id` = `members`.`id` LEFT OUTER JOIN `roles` ON `roles`.`id` = `member_roles`.`role_id` WHERE `members`.`user_id` = 11 AND (projects.status=1) ORDER BY projects.name
|
328
|
[1m[36mProject Load (0.0ms)[0m [1mSELECT `projects`.* FROM `projects` WHERE (`projects`.`lft` <= 8 AND `projects`.`rgt` >= 15) AND (`projects`.id != 19) AND (projects.status=1) ORDER BY `projects`.`lft`[0m
|
329
|
[1m[35m (0.0ms)[0m SELECT COUNT(DISTINCT `versions`.`id`) FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.`id` = `versions`.`project_id` WHERE (projects.id = 19 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 3 AND projects.rgt <= 82 AND versions.sharing = 'tree') OR (projects.lft < 8 AND projects.rgt > 15 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 8 AND projects.rgt < 15 AND versions.sharing = 'hierarchy'))))
|
330
|
[1m[36mWiki Load (0.0ms)[0m [1mSELECT `wikis`.* FROM `wikis` WHERE `wikis`.`project_id` = 19 LIMIT 1[0m
|
331
|
[1m[35m (0.0ms)[0m SELECT COUNT(*) FROM `boards` WHERE `boards`.`project_id` = 19
|
332
|
[1m[36mRepository Load (0.0ms)[0m [1mSELECT `repositories`.* FROM `repositories` WHERE `repositories`.`project_id` = 19 AND (is_default = 1) LIMIT 1[0m
|
333
|
Completed 200 OK in 390ms (Views: 124.8ms | ActiveRecord: 249.6ms)
|
334
|
Connecting to database specified by database.yml
|
335
|
OpenIdAuthentication.store is nil. Using in-memory store.
|
336
|
Creating scope :active. Overwriting existing method User.active.
|
337
|
Creating scope :open. Overwriting existing method Version.open.
|
338
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
339
|
DEPRECATION WARNING: The InstanceMethods module inside ActiveSupport::Concern will be no longer included automatically. Please define instance methods directly in CollectiveIdea::Acts::NestedSet::Model instead. (called from include at C:/Ruby187/apps/redmine/lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:58)
|
340
|
Creating scope :open. Overwriting existing method Issue.open.
|