Guest User

Untitled

a guest
Apr 19th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. Full table scan
  2. No index was used here. In this case, that meant scanning 5 rows.
  3.  
  4. SELECT SQL_NO_CACHE `users`.* FROM `users` INNER JOIN `memberships` ON `users`.id = `memberships`.user_id WHERE ((`memberships`.group_id = 18) AND ((`memberships`.`manager` = 1))) SELECT SQL_NO_CACHE `users`.* FROM `users` INNER JOIN `memberships` ON `users`.id = `memberships`.user_id WHERE ((`memberships`.group_id = N) AND ((`memberships`.`manager` = N)))
Add Comment
Please, Sign In to add comment