Skip to content

Instantly share code, notes, and snippets.

@tjmcewan
Created June 25, 2011 06:45
Show Gist options
  • Save tjmcewan/1046244 to your computer and use it in GitHub Desktop.
Save tjmcewan/1046244 to your computer and use it in GitHub Desktop.
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