Skip to content

Instantly share code, notes, and snippets.

@amoslanka
Created May 1, 2012 22:52
Show Gist options
  • Save amoslanka/2572124 to your computer and use it in GitHub Desktop.
Save amoslanka/2572124 to your computer and use it in GitHub Desktop.
Getting flickr thumbs for 'tcby'
Found 13 flickr thumbs
Started GET "/work/tcby-store-design" for 192.168.0.24 at 2012-05-01 15:51:49 -0700
Processing by WorkDetailController#index as HTML
Parameters: {"id"=>"tcby-store-design"}
Category Load (0.3ms) SELECT `categories`.* FROM `categories` ORDER BY name asc
Industry Load (0.3ms) SELECT `industries`.* FROM `industries` ORDER BY name asc
Campaign Load (0.4ms) SELECT `campaigns`.* FROM `campaigns` WHERE `campaigns`.`live` = 1 AND `campaigns`.`slug` = 'tcby-store-design' LIMIT 1
SQL (0.6ms) SELECT COUNT(*) FROM `flickr_medias` WHERE (tags LIKE ('%tcby%'))
CACHE (0.0ms) SELECT COUNT(*) FROM `flickr_medias` WHERE (tags LIKE ('%tcby%'))
FlickrMedia Load (0.9ms) SELECT `flickr_medias`.* FROM `flickr_medias` WHERE (tags LIKE ('%tcby%'))
BlogPost Load (0.4ms) SELECT `blog_posts`.* FROM `blog_posts` WHERE `blog_posts`.`id` = 1197 ORDER BY postDate DESC LIMIT 1
BlogPost Load (0.2ms) SELECT `blog_posts`.* FROM `blog_posts` WHERE `blog_posts`.`id` = 1185 ORDER BY postDate DESC LIMIT 1
Media Load (0.8ms) SELECT `medias`.* FROM `medias` WHERE (`medias`.campaign_id = 49) AND (medias.role='Detail')
Media Load (0.8ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeSml' AND `medias`.`campaign_id` = 49 LIMIT 1
Rendered shared/_filter.html.haml (6.8ms)
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 49)) ORDER BY name asc LIMIT 1
Industry Load (8.4ms) SELECT `industries`.* FROM `industries` INNER JOIN `industry_relationships` ON `industries`.id = `industry_relationships`.industry_id WHERE ((`industry_relationships`.campaign_id = 49)) ORDER BY name asc LIMIT 1
Client Load (0.2ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 22 ORDER BY name asc LIMIT 1
Rendered shared/_flickr_cell.haml (11.2ms)
Rendered shared/video/_vimeo.html.haml (2.0ms)
SQL (1.2ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 49) AND (medias.role='Detail')
Rendered shared/_footer.haml (14.3ms)
Rendered work_detail/index.html.haml within layouts/application (197.8ms)
Completed 200 OK in 325ms (Views: 191.8ms | ActiveRecord: 15.0ms)
Started POST "/fetch-grid" for 192.168.0.24 at 2012-05-01 15:51:50 -0700
Processing by SiteController#fetchGrid as JS
Parameters: {"nextGrid"=>"style-d", "pointer"=>"undefined", "blogPointer"=>"undefined", "grid_pointer"=>"undefined"}
SQL (0.4ms) SELECT COUNT(*) FROM `campaigns` WHERE `campaigns`.`live` = 1
Campaign Load (1.1ms) SELECT `campaigns`.* FROM `campaigns` WHERE `campaigns`.`live` = 1 ORDER BY priority asc
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 16) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 5) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 30) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 11) AND (role='HomeLrg' OR role='HomeSml')
SQL (1.0ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 15) AND (role='HomeLrg' OR role='HomeSml')
SQL (1.0ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 48) AND (role='HomeLrg' OR role='HomeSml')
SQL (1.1ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 55) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.9ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 3) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 31) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 43) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 52) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 42) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 39) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 33) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 44) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 37) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 27) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 25) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 22) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 59) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 62) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 4) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 56) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 57) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 24) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 45) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 34) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 58) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 28) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 47) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 64) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 2) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 50) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 8) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 60) AND (role='HomeLrg' OR role='HomeSml')
SQL (1.1ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 46) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 51) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 61) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 40) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 41) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 9) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 13) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 26) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 32) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 7) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 10) AND (role='HomeLrg' OR role='HomeSml')
BlogPost Load (1.9ms) SELECT `blog_posts`.* FROM `blog_posts` ORDER BY postDate DESC
SQL (0.6ms) SELECT COUNT(*) FROM `flickr_medias` WHERE (tags LIKE('%featured%'))
FlickrMedia Load (1.0ms) SELECT `flickr_medias`.* FROM `flickr_medias` WHERE (tags LIKE('%featured%'))
Category Load (0.5ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 16)) ORDER BY name asc LIMIT 1
Media Load (1.0ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 16) LIMIT 1
Rendered grid/_campaign_large.html.haml (232.8ms)
Rendered grid/_branding.html.haml (1.8ms)
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 5)) ORDER BY name asc LIMIT 1
Media Load (0.3ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 5) LIMIT 1
Rendered grid/_campaign_large.html.haml (5.3ms)
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 11)) ORDER BY name asc LIMIT 1
Media Load (0.3ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeSml' AND (`medias`.campaign_id = 11) LIMIT 1
Rendered grid/_campaign_small.html.haml (5.1ms)
Rendered grid/_blog.html.haml (56.6ms)
Rendered grid/_flickr.html.haml (7.8ms)
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 30)) ORDER BY name asc LIMIT 1
Media Load (0.3ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 30) LIMIT 1
Rendered grid/_campaign_large.html.haml (5.3ms)
Rendered grid/_blog_flush_left.html.haml (3.7ms)
Rendered grid/_blog.html.haml (3.0ms)
Rendered grid/_grid_c.html.haml (332.2ms)
Rendered grid/_empty_grid_a.html.haml (1.0ms)
Rendered shared/_app_js.html.haml (1.3ms)
Rendered site/fetchGrid.js.haml (342.1ms)
Completed 200 OK in 776ms (Views: 352.5ms | ActiveRecord: 31.2ms)
Started POST "/fetch-grid" for 192.168.0.24 at 2012-05-01 15:52:04 -0700
Processing by SiteController#fetchGrid as JS
Parameters: {"nextGrid"=>"style-d", "pointer"=>"undefined", "blogPointer"=>"undefined", "grid_pointer"=>"undefined"}
SQL (0.4ms) SELECT COUNT(*) FROM `campaigns` WHERE `campaigns`.`live` = 1
Campaign Load (28.1ms) SELECT `campaigns`.* FROM `campaigns` WHERE `campaigns`.`live` = 1 ORDER BY priority asc
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 16) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 5) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 30) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 11) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.8ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 15) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 48) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 55) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 3) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 31) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 43) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 52) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 42) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 39) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 33) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 44) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 37) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 27) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 25) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 22) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 59) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 62) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 4) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 56) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 57) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 24) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 45) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 34) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 58) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 28) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 47) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 64) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 2) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 50) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 8) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 60) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 46) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 51) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 61) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 40) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 41) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 9) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 13) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 26) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 32) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 7) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 10) AND (role='HomeLrg' OR role='HomeSml')
BlogPost Load (1.8ms) SELECT `blog_posts`.* FROM `blog_posts` ORDER BY postDate DESC
SQL (0.6ms) SELECT COUNT(*) FROM `flickr_medias` WHERE (tags LIKE('%featured%'))
FlickrMedia Load (1.0ms) SELECT `flickr_medias`.* FROM `flickr_medias` WHERE (tags LIKE('%featured%'))
Category Load (0.5ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 16)) ORDER BY name asc LIMIT 1
Media Load (0.5ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 16) LIMIT 1
Rendered grid/_campaign_large.html.haml (81.2ms)
Rendered grid/_branding.html.haml (1.8ms)
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 5)) ORDER BY name asc LIMIT 1
Media Load (0.2ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 5) LIMIT 1
Rendered grid/_campaign_large.html.haml (5.3ms)
Category Load (0.5ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 11)) ORDER BY name asc LIMIT 1
Media Load (0.5ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeSml' AND (`medias`.campaign_id = 11) LIMIT 1
Rendered grid/_campaign_small.html.haml (7.0ms)
Rendered grid/_blog.html.haml (13.1ms)
Rendered grid/_flickr.html.haml (8.5ms)
Category Load (20.8ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 30)) ORDER BY name asc LIMIT 1
Media Load (0.6ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 30) LIMIT 1
Rendered grid/_campaign_large.html.haml (27.2ms)
Rendered grid/_blog_flush_left.html.haml (3.6ms)
Rendered grid/_blog.html.haml (3.4ms)
Rendered grid/_grid_c.html.haml (163.4ms)
Rendered grid/_empty_grid_a.html.haml (1.4ms)
Rendered shared/_app_js.html.haml (1.8ms)
Rendered site/fetchGrid.js.haml (175.0ms)
Completed 200 OK in 421ms (Views: 160.2ms | ActiveRecord: 76.7ms)
Started POST "/fetch-grid" for 192.168.0.24 at 2012-05-01 15:52:06 -0700
Processing by SiteController#fetchGrid as JS
Parameters: {"nextGrid"=>"style-d", "pointer"=>"undefined", "blogPointer"=>"undefined", "grid_pointer"=>"undefined"}
SQL (0.4ms) SELECT COUNT(*) FROM `campaigns` WHERE `campaigns`.`live` = 1
Campaign Load (1.0ms) SELECT `campaigns`.* FROM `campaigns` WHERE `campaigns`.`live` = 1 ORDER BY priority asc
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 16) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 5) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 30) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 11) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.8ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 15) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 48) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 55) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 3) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 31) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.8ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 43) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 52) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 42) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 39) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 33) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 44) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 37) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 27) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 25) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 22) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 59) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 62) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 4) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 56) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.8ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 57) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.8ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 24) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 45) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 34) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 58) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 28) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 47) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 64) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 2) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 50) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 8) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 60) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 46) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 51) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 61) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 40) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.7ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 41) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 9) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.6ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 13) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.5ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 26) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 32) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 7) AND (role='HomeLrg' OR role='HomeSml')
SQL (0.4ms) SELECT COUNT(*) FROM `medias` WHERE (`medias`.campaign_id = 10) AND (role='HomeLrg' OR role='HomeSml')
BlogPost Load (1.8ms) SELECT `blog_posts`.* FROM `blog_posts` ORDER BY postDate DESC
SQL (0.9ms) SELECT COUNT(*) FROM `flickr_medias` WHERE (tags LIKE('%featured%'))
FlickrMedia Load (1.7ms) SELECT `flickr_medias`.* FROM `flickr_medias` WHERE (tags LIKE('%featured%'))
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 16)) ORDER BY name asc LIMIT 1
Media Load (1.0ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 16) LIMIT 1
Rendered grid/_campaign_large.html.haml (76.5ms)
Rendered grid/_branding.html.haml (2.1ms)
Category Load (0.6ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 5)) ORDER BY name asc LIMIT 1
Media Load (0.3ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 5) LIMIT 1
Rendered grid/_campaign_large.html.haml (6.4ms)
Category Load (0.5ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 11)) ORDER BY name asc LIMIT 1
Media Load (0.4ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeSml' AND (`medias`.campaign_id = 11) LIMIT 1
Rendered grid/_campaign_small.html.haml (6.2ms)
Rendered grid/_blog.html.haml (14.6ms)
Rendered grid/_flickr.html.haml (9.2ms)
Category Load (0.4ms) SELECT `categories`.* FROM `categories` INNER JOIN `categorizations` ON `categories`.id = `categorizations`.category_id WHERE ((`categorizations`.campaign_id = 30)) ORDER BY name asc LIMIT 1
Media Load (0.5ms) SELECT `medias`.* FROM `medias` WHERE `medias`.`role` = 'HomeLrg' AND (`medias`.campaign_id = 30) LIMIT 1
Rendered grid/_campaign_large.html.haml (7.2ms)
Rendered grid/_blog_flush_left.html.haml (3.9ms)
Rendered grid/_blog.html.haml (3.0ms)
Rendered grid/_grid_c.html.haml (143.6ms)
Rendered grid/_empty_grid_a.html.haml (0.9ms)
Rendered shared/_app_js.html.haml (1.3ms)
Rendered site/fetchGrid.js.haml (152.9ms)
Completed 200 OK in 343ms (Views: 157.4ms | ActiveRecord: 35.6ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment