Guest User

Untitled

a guest
Oct 19th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. ## sem includes(:user)
  2.  
  3. Comment Load (0.9ms) SELECT user_id, count(*) as contributions FROM `comments` WHERE `comments`.`accepted` = 1 GROUP BY user_id ORDER BY contributions DESC LIMIT 10
  4. User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1
  5. SQL (0.4ms) SELECT COUNT(*) FROM `comments` WHERE `comments`.`accepted` = 1 AND (`comments`.user_id = 1)
  6. User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 2 LIMIT 1
  7. SQL (0.4ms) SELECT COUNT(*) FROM `comments` WHERE `comments`.`accepted` = 1 AND (`comments`.user_id = 2)
  8. User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 3 LIMIT 1
  9. SQL (0.4ms) SELECT COUNT(*) FROM `comments` WHERE `comments`.`accepted` = 1 AND (`comments`.user_id = 3)
  10.  
  11. ## com includes(:user)
  12.  
  13. Comment Load (0.6ms) SELECT `comments`.* FROM `comments` WHERE `comments`.`accepted` = 1 GROUP BY user_id ORDER BY updated_at DESC LIMIT 10
  14. User Load (0.8ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` IN (22,23,24))
  15. SQL (0.5ms) SELECT COUNT(*) FROM `comments` WHERE `comments`.`accepted` = 1 AND (`comments`.user_id = 22)
  16. SQL (0.4ms) SELECT COUNT(*) FROM `comments` WHERE `comments`.`accepted` = 1 AND (`comments`.user_id = 23)
  17. SQL (0.4ms) SELECT COUNT(*) FROM `comments` WHERE `comments`.`accepted` = 1 AND (`comments`.user_id = 24)
Add Comment
Please, Sign In to add comment