SQL (0.1ms)   SET NAMES 'utf8'
  SQL (0.2ms)   SET SQL_AUTO_IS_NULL=0


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