1
|
# Logfile created on Thu Apr 01 09:31:43 +0200 2010 [4;36;1mSQL (0.1ms)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m
|
2
|
[4;35;1mSQL (0.1ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m
|
3
|
|
4
|
|
5
|
Processing ProjectsController#show (for 213.220.223.252 at 2010-04-01 09:31:59) [GET]
|
6
|
Parameters: {"action"=>"show", "id"=>"test1", "controller"=>"projects"}
|
7
|
[4;36;1mSetting Columns (0.8ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
8
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
9
|
[4;36;1mUser Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
10
|
[4;35;1mUser Load (0.1ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 28) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
11
|
[4;36;1mProject Columns (0.8ms)[0m [0;1mSHOW FIELDS FROM `projects`[0m
|
12
|
[4;35;1mProject Load (0.1ms)[0m [0mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'test1') LIMIT 1[0m
|
13
|
[4;36;1mEnabledModule Load (0.1ms)[0m [0;1mSELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 1) [0m
|
14
|
[4;35;1mEnabledModule Columns (0.4ms)[0m [0mSHOW FIELDS FROM `enabled_modules`[0m
|
15
|
[4;36;1mMember Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `members`[0m
|
16
|
[4;35;1mRole Columns (0.5ms)[0m [0mSHOW FIELDS FROM `roles`[0m
|
17
|
[4;36;1mMember Load Including Associations (1.3ms)[0m [0;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`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5, `roles`.`default_cost` AS t2_r6 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.project_id = 1 AND (users.type='User' AND users.status=1)) [0m
|
18
|
[4;35;1mNews Load (0.1ms)[0m [0mSELECT * FROM `news` WHERE (`news`.project_id = 1) ORDER BY news.created_on DESC LIMIT 5[0m
|
19
|
[4;36;1mNews Columns (0.6ms)[0m [0;1mSHOW FIELDS FROM `news`[0m
|
20
|
[4;35;1mUser Load (0.2ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
21
|
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (`projects`.`id` = 1) [0m
|
22
|
[4;35;1mTracker Columns (0.5ms)[0m [0mSHOW FIELDS FROM `trackers`[0m
|
23
|
[4;36;1mTracker Load Including Associations (0.1ms)[0m [0;1mSELECT `trackers`.`id` AS t0_r0, `trackers`.`name` AS t0_r1, `trackers`.`is_in_chlog` AS t0_r2, `trackers`.`position` AS t0_r3, `trackers`.`is_in_roadmap` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`predicted_cost` AS t1_r10, `projects`.`currency` AS t1_r11, `projects`.`lft` AS t1_r12, `projects`.`rgt` AS t1_r13, `projects`.`is_easy_template` AS t1_r14 FROM `trackers` LEFT OUTER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id LEFT OUTER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 13 AND projects.rgt <= 14 AND projects.status = 1) ORDER BY trackers.position[0m
|
24
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'display_subprojects_issues') LIMIT 1[0m
|
25
|
[4;36;1mIssue Columns (1.0ms)[0m [0;1mSHOW FIELDS FROM `issues`[0m
|
26
|
[4;35;1mSQL (1.3ms)[0m [0mSELECT count(DISTINCT `issues`.id) AS count_all, tracker_id AS tracker_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 `trackers` ON `trackers`.id = `issues`.tracker_id WHERE (((projects.id = 1 OR (projects.lft > 13 AND projects.rgt < 14))) AND issue_statuses.is_closed=0) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) GROUP BY tracker_id [0m
|
27
|
[4;36;1mTracker Load (0.0ms)[0m [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` IN (4,5,7,9)) [0m
|
28
|
[4;35;1mSQL (0.6ms)[0m [0mSELECT count(DISTINCT `issues`.id) AS count_all, tracker_id AS tracker_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 `trackers` ON `trackers`.id = `issues`.tracker_id WHERE ((projects.id = 1 OR (projects.lft > 13 AND projects.rgt < 14))) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) GROUP BY tracker_id [0m
|
29
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `trackers` WHERE (`trackers`.`id` IN (4,5,7,9)) [0m
|
30
|
[4;35;1mTimeEntry Columns (0.9ms)[0m [0mSHOW FIELDS FROM `time_entries`[0m
|
31
|
[4;36;1mSQL (1.5ms)[0m [0;1mSELECT sum(`time_entries`.hours) AS sum_hours FROM `time_entries` LEFT OUTER JOIN `projects` ON `projects`.id = `time_entries`.project_id WHERE ((projects.id = 1 OR (projects.lft > 13 AND projects.rgt < 14))) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) [0m
|
32
|
[4;35;1mToken Load (0.1ms)[0m [0mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 28 AND (action='feeds')) LIMIT 1[0m
|
33
|
[4;36;1mToken Columns (0.6ms)[0m [0;1mSHOW FIELDS FROM `tokens`[0m
|
34
|
Rendering template within layouts/base
|
35
|
Rendering projects/show
|
36
|
[4;35;1mSetting Load (0.1ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
37
|
[4;36;1mSetting Load (0.1ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'cache_formatted_text') LIMIT 1[0m
|
38
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT count(*) AS count_all FROM `projects` WHERE ((projects.status=1) AND (`projects`.`parent_id` = 1)) [0m
|
39
|
[4;36;1mCustomValue Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `custom_values`[0m
|
40
|
[4;35;1mCustomField Columns (0.8ms)[0m [0mSHOW FIELDS FROM `custom_fields`[0m
|
41
|
[4;36;1mCustomValue Load Including Associations (0.1ms)[0m [0;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 FROM `custom_values` LEFT OUTER JOIN `custom_fields` ON `custom_fields`.id = `custom_values`.custom_field_id WHERE (`custom_values`.customized_id = 1 AND `custom_values`.customized_type = 'Project') ORDER BY custom_fields.position[0m
|
42
|
[4;35;1mProjectCustomField Columns (0.7ms)[0m [0mSHOW FIELDS FROM `custom_fields`[0m
|
43
|
[4;36;1mSetting Load (0.1ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'date_format') LIMIT 1[0m
|
44
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
|
45
|
[4;36;1mUserPreference Load (0.1ms)[0m [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 28) LIMIT 1[0m
|
46
|
[4;35;1mUserPreference Columns (0.6ms)[0m [0mSHOW FIELDS FROM `user_preferences`[0m
|
47
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
|
48
|
Rendered news/_news (15.8ms)
|
49
|
Rendered news/_news (1.3ms)
|
50
|
[4;35;1mSetting Load (0.1ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
51
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
52
|
[4;35;1mProject Load (0.1ms)[0m [0mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 28) AND ((projects.status=1))) [0m
|
53
|
[4;36;1mProject Load (0.1ms)[0m [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 13 AND projects.`rgt` >= 14) ORDER BY `lft` LIMIT 1[0m
|
54
|
[4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 13 AND projects.`rgt` >= 14) ORDER BY `lft` LIMIT 1[0m
|
55
|
[4;36;1mVersion Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `versions`[0m
|
56
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 13 AND projects.rgt <= 14 AND versions.sharing = 'tree') OR (projects.lft < 13 AND projects.rgt > 14 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 13 AND projects.rgt < 14 AND versions.sharing = 'hierarchy')))) [0m
|
57
|
[4;36;1mWiki Load (0.0ms)[0m [0;1mSELECT * FROM `wikis` WHERE (`wikis`.project_id = 1) LIMIT 1[0m
|
58
|
[4;35;1mBoard Columns (0.7ms)[0m [0mSHOW FIELDS FROM `boards`[0m
|
59
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 1) [0m
|
60
|
[4;35;1mRepository Load (0.1ms)[0m [0mSELECT * FROM `repositories` WHERE (`repositories`.project_id = 1) LIMIT 1[0m
|
61
|
[4;36;1mRepository Columns (0.6ms)[0m [0;1mSHOW FIELDS FROM `repositories`[0m
|
62
|
Completed in 819ms (View: 629, DB: 19) | 200 OK [http://vendor.easyproject.cz/projects/test1]
|
63
|
[4;35;1mSQL (0.1ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m
|
64
|
|
65
|
|
66
|
Processing IssuesController#index (for 213.220.223.252 at 2010-04-01 09:32:03) [GET]
|
67
|
Parameters: {"project_id"=>"test1", "action"=>"index", "controller"=>"issues"}
|
68
|
[4;36;1mSetting Columns (0.6ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
69
|
[4;35;1mSQL (0.1ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
70
|
[4;36;1mUser Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
71
|
[4;35;1mUser Load (0.1ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 28) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
72
|
[4;36;1mProject Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `projects`[0m
|
73
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'test1') LIMIT 1[0m
|
74
|
[4;36;1mEnabledModule Load (0.1ms)[0m [0;1mSELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 1) [0m
|
75
|
[4;35;1mEnabledModule Columns (0.4ms)[0m [0mSHOW FIELDS FROM `enabled_modules`[0m
|
76
|
[4;36;1mQuery Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `queries`[0m
|
77
|
[4;35;1mTracker Columns (0.4ms)[0m [0mSHOW FIELDS FROM `trackers`[0m
|
78
|
[4;36;1mTracker Load Including Associations (0.1ms)[0m [0;1mSELECT `trackers`.`id` AS t0_r0, `trackers`.`name` AS t0_r1, `trackers`.`is_in_chlog` AS t0_r2, `trackers`.`position` AS t0_r3, `trackers`.`is_in_roadmap` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`predicted_cost` AS t1_r10, `projects`.`currency` AS t1_r11, `projects`.`lft` AS t1_r12, `projects`.`rgt` AS t1_r13, `projects`.`is_easy_template` AS t1_r14 FROM `trackers` LEFT OUTER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id LEFT OUTER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 13 AND projects.rgt <= 14 AND projects.status = 1) ORDER BY trackers.position[0m
|
79
|
[4;35;1mIssueStatus Load (0.1ms)[0m [0mSELECT * FROM `issue_statuses` ORDER BY position[0m
|
80
|
[4;36;1mIssueStatus Columns (0.4ms)[0m [0;1mSHOW FIELDS FROM `issue_statuses`[0m
|
81
|
[4;35;1mIssuePriority Columns (0.6ms)[0m [0mSHOW FIELDS FROM `enumerations`[0m
|
82
|
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
|
83
|
[4;35;1mUser Load (0.5ms)[0m [0mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 1) AND ((users.type='User' AND users.status=1))) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
84
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
|
85
|
[4;35;1mIssueCategory Columns (0.7ms)[0m [0mSHOW FIELDS FROM `issue_categories`[0m
|
86
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 1) [0m
|
87
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 13 AND projects.`rgt` >= 14) ORDER BY `lft` LIMIT 1[0m
|
88
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 13 AND projects.`rgt` >= 14) ORDER BY `lft` LIMIT 1[0m
|
89
|
[4;35;1mVersion Columns (0.6ms)[0m [0mSHOW FIELDS FROM `versions`[0m
|
90
|
[4;36;1mSQL (0.1ms)[0m [0;1mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 13 AND projects.rgt <= 14 AND versions.sharing = 'tree') OR (projects.lft < 13 AND projects.rgt > 14 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 13 AND projects.rgt < 14 AND versions.sharing = 'hierarchy')))) [0m
|
91
|
[4;35;1mVersion Load Including Associations (0.1ms)[0m [0mSELECT `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`.`predicted_cost` AS t1_r10, `projects`.`currency` AS t1_r11, `projects`.`lft` AS t1_r12, `projects`.`rgt` AS t1_r13, `projects`.`is_easy_template` AS t1_r14 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 13 AND projects.rgt <= 14 AND versions.sharing = 'tree') OR (projects.lft < 13 AND projects.rgt > 14 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 13 AND projects.rgt < 14 AND versions.sharing = 'hierarchy')))) [0m
|
92
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
93
|
[4;35;1mIssueCustomField Columns (0.8ms)[0m [0mSHOW FIELDS FROM `custom_fields`[0m
|
94
|
[4;36;1mIssueCustomField Load (0.0ms)[0m [0;1mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
|
95
|
[4;35;1mcustom_fields_projects Columns (0.4ms)[0m [0mSHOW FIELDS FROM `custom_fields_projects`[0m
|
96
|
[4;36;1mIssueCustomField Load (0.1ms)[0m [0;1mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
|
97
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1[0m
|
98
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
99
|
[4;35;1mIssue Columns (0.9ms)[0m [0mSHOW FIELDS FROM `issues`[0m
|
100
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issue_statuses.is_closed=0) AND projects.id = 1 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) [0m
|
101
|
[4;35;1mCACHE (0.0ms)[0m [0mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
102
|
[4;36;1mIssue Load Including Associations (2.1ms)[0m [0;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`.`predicted_cost` AS t0_r18, `issues`.`due_time` AS t0_r19, `issues`.`is_easy_template` AS t0_r20, `issues`.`parent_id` AS t0_r21, `issues`.`root_id` AS t0_r22, `issues`.`lft` AS t0_r23, `issues`.`rgt` AS t0_r24, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2, `issue_statuses`.`is_default` AS t1_r3, `issue_statuses`.`position` AS t1_r4, `issue_statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`predicted_cost` AS t2_r10, `projects`.`currency` AS t2_r11, `projects`.`lft` AS t2_r12, `projects`.`rgt` AS t2_r13, `projects`.`is_easy_template` AS t2_r14, `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`.`mail_notification` AS t3_r6, `users`.`admin` AS t3_r7, `users`.`status` AS t3_r8, `users`.`last_login_on` AS t3_r9, `users`.`language` AS t3_r10, `users`.`auth_source_id` AS t3_r11, `users`.`created_on` AS t3_r12, `users`.`updated_on` AS t3_r13, `users`.`type` AS t3_r14, `users`.`identity_url` AS t3_r15, `trackers`.`id` AS t4_r0, `trackers`.`name` AS t4_r1, `trackers`.`is_in_chlog` AS t4_r2, `trackers`.`position` AS t4_r3, `trackers`.`is_in_roadmap` AS t4_r4, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`default_cost` AS t5_r4, `enumerations`.`type` AS t5_r5, `enumerations`.`active` AS t5_r6, `enumerations`.`project_id` AS t5_r7, `enumerations`.`parent_id` AS t5_r8, `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 `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `issues`.priority_id AND (`enumerations`.`type` = 'IssuePriority' ) LEFT OUTER JOIN `issue_categories` ON `issue_categories`.id = `issues`.category_id LEFT OUTER JOIN `versions` ON `versions`.id = `issues`.fixed_version_id WHERE (((issue_statuses.is_closed=0) AND projects.id = 1 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) ORDER BY issues.id DESC LIMIT 0, 5[0m
|
103
|
Rendering template within layouts/base
|
104
|
Rendering issues/index.rhtml
|
105
|
Rendered queries/_filters (37.6ms)
|
106
|
[4;35;1mSetting Load (0.1ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1[0m
|
107
|
Rendered queries/_columns (9.8ms)
|
108
|
[4;36;1mUserPreference Load (0.1ms)[0m [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 28) LIMIT 1[0m
|
109
|
[4;35;1mUserPreference Columns (0.6ms)[0m [0mSHOW FIELDS FROM `user_preferences`[0m
|
110
|
[4;36;1mSetting Load (0.1ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
|
111
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'date_format') LIMIT 1[0m
|
112
|
Rendered issues/_list (45.4ms)
|
113
|
[4;36;1mToken Load (0.1ms)[0m [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 28 AND (action='feeds')) LIMIT 1[0m
|
114
|
[4;35;1mToken Columns (0.5ms)[0m [0mSHOW FIELDS FROM `tokens`[0m
|
115
|
[4;36;1mQuery Load (0.1ms)[0m [0;1mSELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 28) AND (project_id IS NULL OR project_id = 1)) ORDER BY name ASC[0m
|
116
|
Rendered issues/_sidebar (64.6ms)
|
117
|
[4;35;1mSetting Load (0.1ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
118
|
[4;36;1mSetting Load (0.1ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
119
|
[4;35;1mSetting Load (0.1ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
120
|
[4;36;1mProject Load (0.1ms)[0m [0;1mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 28) AND ((projects.status=1))) [0m
|
121
|
[4;35;1mWiki Load (0.1ms)[0m [0mSELECT * FROM `wikis` WHERE (`wikis`.project_id = 1) LIMIT 1[0m
|
122
|
[4;36;1mBoard Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `boards`[0m
|
123
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT count(*) AS count_all FROM `boards` WHERE (`boards`.project_id = 1) [0m
|
124
|
[4;36;1mRepository Load (0.0ms)[0m [0;1mSELECT * FROM `repositories` WHERE (`repositories`.project_id = 1) LIMIT 1[0m
|
125
|
[4;35;1mRepository Columns (0.5ms)[0m [0mSHOW FIELDS FROM `repositories`[0m
|
126
|
Completed in 735ms (View: 266, DB: 15) | 200 OK [http://vendor.easyproject.cz/projects/test1/issues]
|
127
|
[4;36;1mSQL (0.1ms)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m
|
128
|
|
129
|
|
130
|
Processing IssuesController#index to pdf (for 213.220.223.252 at 2010-04-01 09:32:06) [GET]
|
131
|
Parameters: {"format"=>"pdf", "project_id"=>"test1", "action"=>"index", "controller"=>"issues"}
|
132
|
[4;35;1mSetting Columns (0.6ms)[0m [0mSHOW FIELDS FROM `settings`[0m
|
133
|
[4;36;1mSQL (0.1ms)[0m [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
134
|
[4;35;1mUser Columns (0.7ms)[0m [0mSHOW FIELDS FROM `users`[0m
|
135
|
[4;36;1mUser Load (0.0ms)[0m [0;1mSELECT * FROM `users` WHERE (`users`.`id` = 28) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
136
|
[4;35;1mProject Columns (0.7ms)[0m [0mSHOW FIELDS FROM `projects`[0m
|
137
|
[4;36;1mProject Load (0.1ms)[0m [0;1mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'test1') LIMIT 1[0m
|
138
|
[4;35;1mEnabledModule Load (0.0ms)[0m [0mSELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 1) [0m
|
139
|
[4;36;1mEnabledModule Columns (0.4ms)[0m [0;1mSHOW FIELDS FROM `enabled_modules`[0m
|
140
|
[4;35;1mQuery Columns (0.6ms)[0m [0mSHOW FIELDS FROM `queries`[0m
|
141
|
[4;36;1mIssueCustomField Columns (0.8ms)[0m [0;1mSHOW FIELDS FROM `custom_fields`[0m
|
142
|
[4;35;1mIssueCustomField Load (0.0ms)[0m [0mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
|
143
|
[4;36;1mcustom_fields_projects Columns (0.3ms)[0m [0;1mSHOW FIELDS FROM `custom_fields_projects`[0m
|
144
|
[4;35;1mIssueCustomField Load (0.1ms)[0m [0mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
|
145
|
[4;36;1mSetting Load (0.1ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issues_export_limit') LIMIT 1[0m
|
146
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
147
|
[4;36;1mIssue Columns (0.9ms)[0m [0;1mSHOW FIELDS FROM `issues`[0m
|
148
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issue_statuses.is_closed=0) AND projects.id = 1 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) [0m
|
149
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
150
|
[4;35;1mIssueStatus Columns (0.5ms)[0m [0mSHOW FIELDS FROM `issue_statuses`[0m
|
151
|
[4;36;1mTracker Columns (0.4ms)[0m [0;1mSHOW FIELDS FROM `trackers`[0m
|
152
|
[4;35;1mIssuePriority Columns (0.5ms)[0m [0mSHOW FIELDS FROM `enumerations`[0m
|
153
|
[4;36;1mIssueCategory Columns (0.4ms)[0m [0;1mSHOW FIELDS FROM `issue_categories`[0m
|
154
|
[4;35;1mVersion Columns (0.5ms)[0m [0mSHOW FIELDS FROM `versions`[0m
|
155
|
[4;36;1mIssue Load Including Associations (2.0ms)[0m [0;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`.`predicted_cost` AS t0_r18, `issues`.`due_time` AS t0_r19, `issues`.`is_easy_template` AS t0_r20, `issues`.`parent_id` AS t0_r21, `issues`.`root_id` AS t0_r22, `issues`.`lft` AS t0_r23, `issues`.`rgt` AS t0_r24, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2, `issue_statuses`.`is_default` AS t1_r3, `issue_statuses`.`position` AS t1_r4, `issue_statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`predicted_cost` AS t2_r10, `projects`.`currency` AS t2_r11, `projects`.`lft` AS t2_r12, `projects`.`rgt` AS t2_r13, `projects`.`is_easy_template` AS t2_r14, `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`.`mail_notification` AS t3_r6, `users`.`admin` AS t3_r7, `users`.`status` AS t3_r8, `users`.`last_login_on` AS t3_r9, `users`.`language` AS t3_r10, `users`.`auth_source_id` AS t3_r11, `users`.`created_on` AS t3_r12, `users`.`updated_on` AS t3_r13, `users`.`type` AS t3_r14, `users`.`identity_url` AS t3_r15, `trackers`.`id` AS t4_r0, `trackers`.`name` AS t4_r1, `trackers`.`is_in_chlog` AS t4_r2, `trackers`.`position` AS t4_r3, `trackers`.`is_in_roadmap` AS t4_r4, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`default_cost` AS t5_r4, `enumerations`.`type` AS t5_r5, `enumerations`.`active` AS t5_r6, `enumerations`.`project_id` AS t5_r7, `enumerations`.`parent_id` AS t5_r8, `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 `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `issues`.priority_id AND (`enumerations`.`type` = 'IssuePriority' ) LEFT OUTER JOIN `issue_categories` ON `issue_categories`.id = `issues`.category_id LEFT OUTER JOIN `versions` ON `versions`.id = `issues`.fixed_version_id WHERE (((issue_statuses.is_closed=0) AND projects.id = 1 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) ORDER BY issues.id DESC LIMIT 0, 500[0m
|
156
|
[4;35;1mSetting Load (0.1ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'date_format') LIMIT 1[0m
|
157
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1[0m
|
158
|
[4;35;1mUserPreference Load (0.1ms)[0m [0mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 28) LIMIT 1[0m
|
159
|
[4;36;1mUserPreference Columns (0.5ms)[0m [0;1mSHOW FIELDS FROM `user_preferences`[0m
|
160
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
|
161
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
|
162
|
Sending data export.pdf
|
163
|
Completed in 431ms (View: 24, DB: 11) | 200 OK [http://vendor.easyproject.cz/projects/test1/issues.pdf]
|
164
|
[4;35;1mSQL (0.1ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m
|
165
|
|
166
|
|
167
|
Processing IssuesController#index (for 213.220.223.252 at 2010-04-01 09:32:26) [POST]
|
168
|
Parameters: {"group_by"=>"", "set_filter"=>"1", "project_id"=>"test1", "action"=>"index", "authenticity_token"=>"NRVPYb6MZla5AkQUarePXNTtqDrbA1F6eoKWTSoVFG0=", "fields"=>["status_id", "priority_id"], "operators"=>{"start_date"=>"<t+", "watcher_id"=>"=", "estimated_hours"=>"=", "created_on"=>">t-", "priority_id"=>"=", "fixed_version_id"=>"=", "done_ratio"=>"=", "updated_on"=>">t-", "subject"=>"~", "assigned_to_id"=>"=", "tracker_id"=>"=", "due_date"=>"<t+", "author_id"=>"=", "status_id"=>"o"}, "values"=>{"start_date"=>[""], "watcher_id"=>["me"], "estimated_hours"=>[""], "created_on"=>[""], "priority_id"=>["5"], "fixed_version_id"=>["3"], "done_ratio"=>[""], "updated_on"=>[""], "subject"=>[""], "assigned_to_id"=>["me"], "tracker_id"=>["4"], "due_date"=>[""], "author_id"=>["me"], "status_id"=>["1"]}, "controller"=>"issues", "query"=>{"column_names"=>["tracker", "status", "priority", "subject", "assigned_to", "updated_on"]}}
|
169
|
[4;36;1mSetting Columns (0.6ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
170
|
[4;35;1mSQL (0.1ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
171
|
[4;36;1mUser Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
172
|
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 28) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
173
|
[4;36;1mProject Columns (0.7ms)[0m [0;1mSHOW FIELDS FROM `projects`[0m
|
174
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (`projects`.`identifier` = 'test1') LIMIT 1[0m
|
175
|
[4;36;1mEnabledModule Load (0.0ms)[0m [0;1mSELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 1) [0m
|
176
|
[4;35;1mEnabledModule Columns (0.4ms)[0m [0mSHOW FIELDS FROM `enabled_modules`[0m
|
177
|
[4;36;1mQuery Columns (0.5ms)[0m [0;1mSHOW FIELDS FROM `queries`[0m
|
178
|
[4;35;1mTracker Columns (0.6ms)[0m [0mSHOW FIELDS FROM `trackers`[0m
|
179
|
[4;36;1mTracker Load Including Associations (0.1ms)[0m [0;1mSELECT `trackers`.`id` AS t0_r0, `trackers`.`name` AS t0_r1, `trackers`.`is_in_chlog` AS t0_r2, `trackers`.`position` AS t0_r3, `trackers`.`is_in_roadmap` AS t0_r4, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`predicted_cost` AS t1_r10, `projects`.`currency` AS t1_r11, `projects`.`lft` AS t1_r12, `projects`.`rgt` AS t1_r13, `projects`.`is_easy_template` AS t1_r14 FROM `trackers` LEFT OUTER JOIN `projects_trackers` ON `projects_trackers`.tracker_id = `trackers`.id LEFT OUTER JOIN `projects` ON `projects`.id = `projects_trackers`.project_id WHERE (projects.lft >= 13 AND projects.rgt <= 14 AND projects.status = 1) ORDER BY trackers.position[0m
|
180
|
[4;35;1mIssueStatus Load (0.0ms)[0m [0mSELECT * FROM `issue_statuses` ORDER BY position[0m
|
181
|
[4;36;1mIssueStatus Columns (0.6ms)[0m [0;1mSHOW FIELDS FROM `issue_statuses`[0m
|
182
|
[4;35;1mIssuePriority Columns (0.5ms)[0m [0mSHOW FIELDS FROM `enumerations`[0m
|
183
|
[4;36;1mIssuePriority Load (0.0ms)[0m [0;1mSELECT * FROM `enumerations` WHERE ( (`enumerations`.`type` = 'IssuePriority' ) ) ORDER BY enumerations.position ASC[0m
|
184
|
[4;35;1mUser Load (0.1ms)[0m [0mSELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 1) AND ((users.type='User' AND users.status=1))) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
185
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1[0m
|
186
|
[4;35;1mIssueCategory Columns (0.5ms)[0m [0mSHOW FIELDS FROM `issue_categories`[0m
|
187
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `issue_categories` WHERE (`issue_categories`.project_id = 1) [0m
|
188
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.`lft` <= 13 AND projects.`rgt` >= 14) ORDER BY `lft` LIMIT 1[0m
|
189
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `projects` WHERE (projects.`lft` <= 13 AND projects.`rgt` >= 14) ORDER BY `lft` LIMIT 1[0m
|
190
|
[4;35;1mVersion Columns (0.5ms)[0m [0mSHOW FIELDS FROM `versions`[0m
|
191
|
[4;36;1mSQL (0.1ms)[0m [0;1mSELECT count(DISTINCT `versions`.id) AS count_all FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 13 AND projects.rgt <= 14 AND versions.sharing = 'tree') OR (projects.lft < 13 AND projects.rgt > 14 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 13 AND projects.rgt < 14 AND versions.sharing = 'hierarchy')))) [0m
|
192
|
[4;35;1mVersion Load Including Associations (0.1ms)[0m [0mSELECT `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`.`predicted_cost` AS t1_r10, `projects`.`currency` AS t1_r11, `projects`.`lft` AS t1_r12, `projects`.`rgt` AS t1_r13, `projects`.`is_easy_template` AS t1_r14 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id = `versions`.project_id WHERE (projects.id = 1 OR (projects.status = 1 AND ( versions.sharing = 'system' OR (projects.lft >= 13 AND projects.rgt <= 14 AND versions.sharing = 'tree') OR (projects.lft < 13 AND projects.rgt > 14 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 13 AND projects.rgt < 14 AND versions.sharing = 'hierarchy')))) [0m
|
193
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
194
|
[4;35;1mIssueCustomField Columns (0.7ms)[0m [0mSHOW FIELDS FROM `custom_fields`[0m
|
195
|
[4;36;1mIssueCustomField Load (0.1ms)[0m [0;1mSELECT * FROM `custom_fields` WHERE (is_for_all=1) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY position[0m
|
196
|
[4;35;1mcustom_fields_projects Columns (0.5ms)[0m [0mSHOW FIELDS FROM `custom_fields_projects`[0m
|
197
|
[4;36;1mIssueCustomField Load (0.1ms)[0m [0;1mSELECT * FROM `custom_fields` INNER JOIN `custom_fields_projects` ON `custom_fields`.id = `custom_fields_projects`.custom_field_id WHERE (`custom_fields_projects`.project_id = 1 ) AND ( (`custom_fields`.`type` = 'IssueCustomField' ) ) ORDER BY custom_fields.position[0m
|
198
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'issue_list_default_columns') LIMIT 1[0m
|
199
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'per_page_options') LIMIT 1[0m
|
200
|
[4;35;1mCACHE (0.0ms)[0m [0mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
201
|
[4;36;1mIssue Columns (1.0ms)[0m [0;1mSHOW FIELDS FROM `issues`[0m
|
202
|
[4;35;1mSQL (0.6ms)[0m [0mSELECT count(DISTINCT `issues`.id) AS count_all FROM `issues` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id WHERE ((issues.priority_id IN ('5')) AND (issue_statuses.is_closed=0) AND projects.id = 1 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) [0m
|
203
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT count(*) AS count_all FROM `projects` WHERE (((projects.status = 1) AND (projects.id != 1)) AND (projects.`lft` >= 13 AND projects.`rgt` <= 14)) [0m
|
204
|
[4;35;1mIssue Load Including Associations (1.9ms)[0m [0mSELECT `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`.`predicted_cost` AS t0_r18, `issues`.`due_time` AS t0_r19, `issues`.`is_easy_template` AS t0_r20, `issues`.`parent_id` AS t0_r21, `issues`.`root_id` AS t0_r22, `issues`.`lft` AS t0_r23, `issues`.`rgt` AS t0_r24, `issue_statuses`.`id` AS t1_r0, `issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2, `issue_statuses`.`is_default` AS t1_r3, `issue_statuses`.`position` AS t1_r4, `issue_statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`predicted_cost` AS t2_r10, `projects`.`currency` AS t2_r11, `projects`.`lft` AS t2_r12, `projects`.`rgt` AS t2_r13, `projects`.`is_easy_template` AS t2_r14, `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`.`mail_notification` AS t3_r6, `users`.`admin` AS t3_r7, `users`.`status` AS t3_r8, `users`.`last_login_on` AS t3_r9, `users`.`language` AS t3_r10, `users`.`auth_source_id` AS t3_r11, `users`.`created_on` AS t3_r12, `users`.`updated_on` AS t3_r13, `users`.`type` AS t3_r14, `users`.`identity_url` AS t3_r15, `trackers`.`id` AS t4_r0, `trackers`.`name` AS t4_r1, `trackers`.`is_in_chlog` AS t4_r2, `trackers`.`position` AS t4_r3, `trackers`.`is_in_roadmap` AS t4_r4, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`default_cost` AS t5_r4, `enumerations`.`type` AS t5_r5, `enumerations`.`active` AS t5_r6, `enumerations`.`project_id` AS t5_r7, `enumerations`.`parent_id` AS t5_r8, `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 `issue_statuses` ON `issue_statuses`.id = `issues`.status_id LEFT OUTER JOIN `projects` ON `projects`.id = `issues`.project_id LEFT OUTER JOIN `users` ON `users`.id = `issues`.assigned_to_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `issues`.priority_id AND (`enumerations`.`type` = 'IssuePriority' ) LEFT OUTER JOIN `issue_categories` ON `issue_categories`.id = `issues`.category_id LEFT OUTER JOIN `versions` ON `versions`.id = `issues`.fixed_version_id WHERE (((issues.priority_id IN ('5')) AND (issue_statuses.is_closed=0) AND projects.id = 1 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) ORDER BY issues.id DESC LIMIT 0, 5[0m
|
205
|
Rendering issues/index.rhtml
|
206
|
Rendered queries/_filters (23.5ms)
|
207
|
Rendered queries/_columns (1.8ms)
|
208
|
[4;36;1mUserPreference Load (0.1ms)[0m [0;1mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 28) LIMIT 1[0m
|
209
|
[4;35;1mUserPreference Columns (0.5ms)[0m [0mSHOW FIELDS FROM `user_preferences`[0m
|
210
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
|
211
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'date_format') LIMIT 1[0m
|
212
|
Rendered issues/_list (40.9ms)
|
213
|
[4;36;1mToken Load (0.1ms)[0m [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 28 AND (action='feeds')) LIMIT 1[0m
|
214
|
[4;35;1mToken Columns (0.5ms)[0m [0mSHOW FIELDS FROM `tokens`[0m
|
215
|
[4;36;1mQuery Load (0.1ms)[0m [0;1mSELECT id, name FROM `queries` WHERE (1=1 AND (is_public = 1 OR user_id = 28) AND (project_id IS NULL OR project_id = 1)) ORDER BY name ASC[0m
|
216
|
Rendered issues/_sidebar (5.1ms)
|
217
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
218
|
Completed in 592ms (View: 132, DB: 13) | 200 OK [http://vendor.easyproject.cz/issues?set_filter=1]
|