Skip to content

Instantly share code, notes, and snippets.

@jamescook

jamescook/gist:844676

Created February 25, 2011 22:59
Show Gist options
  • Save jamescook/844676 to your computer and use it in GitHub Desktop.
Save jamescook/844676 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
## My branch that fixes some n+1 madness
Started GET "/dashboard/project?id=219" for 127.0.0.1 at 2011-02-25 16:57:44 -0600
Processing by Dashboard::BaseController#project as JSON
Parameters: {"id"=>"219"}
SQL (0.4ms) describe `roles_users`
User Load (0.0ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` = 11) LIMIT 1
SQL (0.2ms) describe `roles_users`
Role Load (0.1ms) SELECT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.id = `roles_users`.role_id WHERE (`roles_users`.user_id = 11 ) AND (`roles`.`name` = 'admin') LIMIT 1
Role Load (0.0ms) SELECT `roles`.* FROM `roles` WHERE (name = 'admin' and authorizable_type IS NULL and authorizable_id IS NULL) LIMIT 1
Role Load (0.2ms) SELECT * FROM `roles` INNER JOIN `roles_users` ON `roles`.id = `roles_users`.role_id WHERE (`roles_users`.user_id = 11 )
Ticket Load (6.0ms) SELECT `tickets`.* FROM `tickets` INNER JOIN projects p ON p.id=tickets.project_id INNER JOIN roles r ON r.authorizable_type='Project' AND r.authorizable_id=p.id INNER JOIN roles_users ru ON ru.role_id = r.id WHERE (`tickets`.`project_id` = 219) AND (ru.user_id = 11 AND r.name = 'developer') ORDER BY name ASC
Completed 200 OK in 175ms (Views: 86.0ms | ActiveRecord: 6.0ms)
## master
Started GET "/dashboard/project?id=219" for 127.0.0.1 at 2011-02-25 16:58:47 -0600
Processing by Dashboard::BaseController#project as JSON
Parameters: {"id"=>"219"}
SiteSettings Load (0.1ms) SELECT `site_settings`.* FROM `site_settings` LIMIT 1
CACHE (0.0ms) SELECT `site_settings`.* FROM `site_settings` LIMIT 1
SQL (0.8ms) describe `roles_users`
User Load (0.1ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` = 11) LIMIT 1
Ticket Load (3.8ms) SELECT `tickets`.* FROM `tickets` WHERE (project_id = '219') ORDER BY name ASC
SQL (0.7ms) describe `roles_users`
Role Load (0.1ms) SELECT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.id = `roles_users`.role_id WHERE (`roles_users`.user_id = 11 ) AND (`roles`.`name` = 'admin') LIMIT 1
Role Load (0.1ms) SELECT `roles`.* FROM `roles` WHERE (name = 'admin' and authorizable_type IS NULL and authorizable_id IS NULL) LIMIT 1
Role Load (0.1ms) SELECT * FROM `roles` INNER JOIN `roles_users` ON `roles`.id = `roles_users`.role_id WHERE (`roles_users`.user_id = 11 )
Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 4) LIMIT 1
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 197) LIMIT 1
Project Load (0.1ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 263) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE (`projects`.`id` = 219) LIMIT 1
Completed 200 OK in 244ms (Views: 82.1ms | ActiveRecord: 0.0ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment