|
1
|
SQL (0.1ms) SET NAMES 'utf8'
|
|
2
|
SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
|
|
3
|
|
|
4
|
|
|
5
|
Processing WatchersController#new (for 127.0.0.1 at 2011-10-24 21:12:23) [POST]
|
|
6
|
Parameters: {"action"=>"new", "authenticity_token"=>"Qlt2g8mrsZbc3OPuZdjOqr+plAIEzN1U7XOKe+F2rt8=", "controller"=>"watchers", "object_id"=>"6883",
|
|
7
|
"object_type"=>"issue"}
|
|
8
|
Setting Columns (1.8ms) SHOW FIELDS FROM `settings`
|
|
9
|
SQL (0.3ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings`
|
|
10
|
User Columns (0.8ms) SHOW FIELDS FROM `users`
|
|
11
|
User Load (1.8ms) SELECT * FROM `users` WHERE (`users`.`id` = 69) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` =
|
|
12
|
'AnonymousUser' ) )
|
|
13
|
Issue Columns (1.6ms) SHOW FIELDS FROM `issues`
|
|
14
|
Issue Load (1.5ms) SELECT * FROM `issues` WHERE (`issues`.`id` = 6883)
|
|
15
|
Project Columns (0.6ms) SHOW FIELDS FROM `projects`
|
|
16
|
Project Load (0.3ms) SELECT * FROM `projects` WHERE (`projects`.`id` = 1567)
|
|
17
|
EnabledModule Load (2.2ms) SELECT name FROM `enabled_modules` WHERE (`enabled_modules`.project_id = 1567)
|
|
18
|
EnabledModule Columns (1.7ms) SHOW FIELDS FROM `enabled_modules`
|
|
19
|
Watcher Columns (0.6ms) SHOW FIELDS FROM `watchers`
|
|
20
|
SQL (0.1ms) BEGIN
|
|
21
|
Watcher Load (2.0ms) SELECT `watchers`.id FROM `watchers` WHERE (`watchers`.`user_id` IS NULL AND `watchers`.`watchable_type` = 'Issue' AND
|
|
22
|
`watchers`.`watchable_id` = 6883) LIMIT 1
|
|
23
|
SQL (0.1ms) ROLLBACK
|
|
24
|
SQL (2.1ms) SELECT count(*) AS count_all FROM `users` INNER JOIN `watchers` ON `users`.id = `watchers`.user_id WHERE ((`watchers`.watchable_id =
|
|
25
|
6883) AND (`watchers`.watchable_type = 'Issue')) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
|
|
26
|
User Load (11.0ms) SELECT `users`.* FROM `users` INNER JOIN `members` ON `users`.id = `members`.user_id WHERE ((`members`.project_id = 1567) AND
|
|
27
|
((users.type='User' AND users.status=1))) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
|
|
28
|
Setting Load (0.3ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'user_format') LIMIT 1
|
|
29
|
User Load (0.4ms) SELECT `users`.* FROM `users` INNER JOIN `watchers` ON `users`.id = `watchers`.user_id WHERE ((`watchers`.watchable_id = 6883)
|
|
30
|
AND (`watchers`.watchable_type = 'Issue')) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) )
|
|
31
|
Setting Load (0.2ms) SELECT * FROM `settings` WHERE (`settings`.`name` = 'gravatar_enabled') LIMIT 1
|
|
32
|
Rendered watchers/_watchers (536.7ms)
|
|
33
|
Completed in 601ms (View: 532, DB: 30) | 200 OK [http://localhost/watchers/new?object_id=6883&object_type=issue]
|