Skip to content

Instantly share code, notes, and snippets.

@parndt
Created March 14, 2011 22:03
Show Gist options
  • Save parndt/869972 to your computer and use it in GitHub Desktop.
Save parndt/869972 to your computer and use it in GitHub Desktop.
RefineryCMS menu rendering in development mode (note globalize3 accessing attributes before eager load happens) (note the 49 SHOW TABLES commands)
Page Load (1.5ms) SELECT `pages`.* FROM `pages` WHERE `pages`.`show_in_menu` = 1 AND `pages`.`id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49) AND `pages`.`draft` = 0 ORDER BY lft ASC
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 1)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 3)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 4)
CACHE (0.0ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 5)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 6)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 7)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 8)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 9)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 10)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 11)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 12)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 13)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 14)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 15)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 16)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 17)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 18)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 19)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 20)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 21)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 22)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 23)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 24)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 25)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 26)
Page::Translation Load (0.4ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 27)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 28)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 29)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 30)
Page::Translation Load (0.4ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 31)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 32)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 33)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 34)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 35)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 36)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 37)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 38)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 39)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 40)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 41)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 42)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 43)
Page::Translation Load (0.2ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 44)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 45)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 46)
Page::Translation Load (0.4ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 47)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 48)
Page::Translation Load (0.3ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id = 49)
Page::Translation Load (0.9ms) SELECT `page_translations`.* FROM `page_translations` WHERE (`page_translations`.page_id IN (1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49))
Slug Load (1.2ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.`sluggable_id` IN (1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49) and `slugs`.`sluggable_type` = 'Page') ORDER BY id DESC
SQL (0.7ms) SHOW TABLES
SQL (0.8ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.7ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.9ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.8ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.6ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
SQL (0.5ms) SHOW TABLES
Rendered core/app/views/shared/_menu_branch.html.erb (365.5ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment