Created
June 25, 2011 06:45
-
-
Save tjmcewan/1046244 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ruby-1.9.2-p180 :007 > Team.all.count | |
Team Load (1.6ms) SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` = 'Team' ORDER BY nodes.name DESC | |
=> 13 | |
ruby-1.9.2-p180 :008 > Zone.all.count | |
Zone Load (2.2ms) SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` = 'Zone' ORDER BY nodes.name DESC | |
League Load (0.5ms) SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` = 'League' AND `nodes`.`id` = 1 ORDER BY nodes.name DESC LIMIT 1 | |
Round Load (0.5ms) SELECT `rounds`.* FROM `rounds` WHERE (`rounds`.league_id = 1) ORDER BY rounds.starts_at DESC | |
SQL (0.4ms) SELECT COUNT(*) FROM `zone_configurations` WHERE (`zone_configurations`.zone_id = 5) | |
League Load (0.4ms) SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` = 'League' AND `nodes`.`id` = 1 ORDER BY nodes.name DESC LIMIT 1 | |
Round Load (0.4ms) SELECT `rounds`.* FROM `rounds` WHERE (`rounds`.league_id = 1) ORDER BY rounds.starts_at DESC | |
SQL (0.2ms) SELECT COUNT(*) FROM `zone_configurations` WHERE (`zone_configurations`.zone_id = 182) | |
League Load (0.3ms) SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` = 'League' AND `nodes`.`id` = 1 ORDER BY nodes.name DESC LIMIT 1 | |
Round Load (0.2ms) SELECT `rounds`.* FROM `rounds` WHERE (`rounds`.league_id = 1) ORDER BY rounds.starts_at DESC | |
SQL (0.2ms) SELECT COUNT(*) FROM `zone_configurations` WHERE (`zone_configurations`.zone_id = 2) | |
League Load (0.2ms) SELECT `nodes`.* FROM `nodes` WHERE `nodes`.`type` = 'League' AND `nodes`.`id` = 1 ORDER BY nodes.name DESC LIMIT 1 | |
Round Load (0.2ms) SELECT `rounds`.* FROM `rounds` WHERE (`rounds`.league_id = 1) ORDER BY rounds.starts_at DESC | |
SQL (0.2ms) SELECT COUNT(*) FROM `zone_configurations` WHERE (`zone_configurations`.zone_id = 177) | |
=> 4 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment