Skip to content

Instantly share code, notes, and snippets.

@radar
Created April 9, 2013 04:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save radar/3f4d46060369173bf591 to your computer and use it in GitHub Desktop.
Save radar/3f4d46060369173bf591 to your computer and use it in GitHub Desktop.
Started GET "/t/shoe-pads" for 127.0.0.1 at 2013-04-06 01:22:45 -0700
Spree::Page Exists (2.0ms) SELECT 1 AS one FROM "spree_pages" WHERE "spree_pages"."visible" = 't' AND (("spree_pages"."slug" = 'tshoe-pads' OR "
spree_pages"."slug" = '/tshoe-pads')) ORDER BY position ASC LIMIT 1
Processing by Spree::TaxonsController#show as HTML
Parameters: {"id"=>"shoe-pads"}
Spree::Taxon Load (2.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."permalink" = 'shoe-pads' LIMIT 1
Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 [["id", 34]]
Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" >= 47 AND "spree_taxons"."lft" < 48) ORDER
BY "spree_taxons"."lft"
Deface: 1 overrides found for 'spree/layouts/spree_application'
Deface: 'add_analytics_header' matched 1 times with 'head'
Deface: 1 overrides found for 'spree/shared/_taxonomies'
Deface: 'siderbar' matched 1 times with 'nav#taxonomies'
Deface: [WARNING] No :original defined for 'siderbar', you should change its definition to include:
:original => 'e8fa8dd2075817aa3ddced3ee631b900ce48e5c5'
Spree::Taxon Load (2.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IS NULL AND ("spree_taxons"."lft" <= 47 A
ND "spree_taxons"."rgt" >= 48) ORDER BY "spree_taxons"."lft" LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = 34
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_taxonomies.html.erb (13.0ms)
CACHE (0.0ms) SELECT COUNT(*) FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = 34
Spree::Property Load (1.0ms) SELECT "spree_properties".* FROM "spree_properties" WHERE "spree_properties"."name" = 'brand' LIMIT 1
 (1.0ms) SELECT value FROM "spree_product_properties" WHERE "spree_product_properties"."property_id" IS NULL
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_filters.html.erb (24.0ms)
 (3.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "spree_products" INNER JOIN "spree_products_taxons" ON "spree_produc
ts_taxons"."product_id" = "spree_products"."id" INNER JOIN "spree_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products"."de
leted_at" IS NULL AND "spree_taxons"."id" IN (34) AND ("spree_products".available_on <= '2013-04-06 08:22:46.423952') LIMIT 12 OFFSET 0) subquery_for_count 
CACHE (0.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "spree_products" INNER JOIN "spree_products_taxons" ON "spree_produ
cts_taxons"."product_id" = "spree_products"."id" INNER JOIN "spree_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products"."d
eleted_at" IS NULL AND "spree_taxons"."id" IN (34) AND ("spree_products".available_on <= '2013-04-06 08:22:46.423952') LIMIT 12 OFFSET 0) subquery_for_count
Spree::Product Load (4.0ms) SELECT DISTINCT(spree_products.id), spree_products.* FROM "spree_products" INNER JOIN "spree_products_taxons" ON
"spree_products_taxons"."product_id" = "spree_products"."id" INNER JOIN "spree_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree
_products"."deleted_at" IS NULL AND "spree_taxons"."id" IN (34) AND ("spree_products".available_on <= '2013-04-06 08:22:46.423952') LIMIT 12 OFFSET 0
Spree::Variant Load (2.0ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."is_master" = 't' AND "spree_variants"."produ
ct_id" IN (100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111)
 (3.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 100 AND "spree_variants"."is_master" = 'f' AND "spree_v
ariants"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 308 AND "spree_a
ssets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (1.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."vi
ewable_id" = 308 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 101 AND "spree_variants"."is_master" = 'f' AND "spree_varia
nts"."deleted_at" IS NULL
 (2.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 309 AND "spr
ee_assets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (2.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewab
le_id" = 309 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (5.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 102 AND "spree_variants"."is_master" = 'f' AND "spree_v
ariants"."deleted_at" IS NULL
 (2.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 310 AND "spree_a
ssets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (2.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."vi
ewable_id" = 310 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 103 AND "spree_variants"."is_master" = 'f' AND "spree_varia
nts"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 311 AND "spr
ee_assets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (1.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewab
le_id" = 311 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (2.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 104 AND "spree_variants"."is_master" = 'f' AND "spree_v
ariants"."deleted_at" IS NULL
 (2.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 312 AND "spree_a
ssets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (2.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."vi
ewable_id" = 312 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 105 AND "spree_variants"."is_master" = 'f' AND "spree_varia
nts"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 313 AND "spr
ee_assets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (1.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewab
le_id" = 313 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 106 AND "spree_variants"."is_master" = 'f' AND "spree_v
ariants"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 314 AND "spree_a
ssets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (1.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."vi
ewable_id" = 314 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (2.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 107 AND "spree_variants"."is_master" = 'f' AND "spree_varia
nts"."deleted_at" IS NULL
 (2.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 315 AND "spr
ee_assets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (2.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewab
le_id" = 315 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 108 AND "spree_variants"."is_master" = 'f' AND "spree_v
ariants"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 316 AND "spree_a
ssets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (2.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."vi
ewable_id" = 316 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (3.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 109 AND "spree_variants"."is_master" = 'f' AND "spree_varia
nts"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 317 AND "spr
ee_assets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (1.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewab
le_id" = 317 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (2.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 110 AND "spree_variants"."is_master" = 'f' AND "spree_v
ariants"."deleted_at" IS NULL
 (1.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 318 AND "spree_a
ssets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (4.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."vi
ewable_id" = 318 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
 (2.0ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."product_id" = 111 AND "spree_variants"."is_master" = 'f' AND "spree_varia
nts"."deleted_at" IS NULL
 (5.0ms) SELECT COUNT(*) FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = 319 AND "spr
ee_assets"."viewable_type" = 'Spree::Variant'
Spree::Image Load (2.0ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewab
le_id" = 319 AND "spree_assets"."viewable_type" = 'Spree::Variant' ORDER BY position LIMIT 1
Spree::Product Load (5.0ms) SELECT DISTINCT(spree_products.id), spree_products.* FROM "spree_products" INNER JOIN "spree_products_taxons" ON
"spree_products_taxons"."product_id" = "spree_products"."id" INNER JOIN "spree_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree
_products"."deleted_at" IS NULL AND "spree_taxons"."id" IN (34) AND ("spree_products".available_on <= '2013-04-06 08:22:46.423952')
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_products.html.erb (528.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/taxons/_taxon.html.erb (0.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/taxons/show.html.erb within spree/layouts/spree_application (673.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_head.html.erb (72.0ms)
Deface: 2 overrides found for 'spree/shared/_nav_bar'
Deface: 'auth_shared_login_bar' matched 1 times with 'li#search-bar'
Deface: 'promotion' matched 1 times with 'ul#nav-bar'
Deface: [WARNING] No :original defined for 'promotion', you should change its definition to include:
:original => '3119fec2949d16fb7cdc6fb4dda4ac5ad0d070ff'
Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" IS NULL ORDER BY "spree_taxons"."lft"
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_search.html.erb (8.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_nav_bar.html.erb (43.0ms)
Deface: 2 overrides found for 'spree/shared/_main_nav_bar'
Deface: 'pages_in_header' matched 1 times with '#main-nav-bar'
Deface: [WARNING] No :original defined for 'pages_in_header', you should change its definition to include:
:original => '15105806bbc6b7c3ee31d7f944c31054c4e3962b'
Deface: 'mainnav' matched 1 times with 'li#home-link'
Deface: [WARNING] No :original defined for 'mainnav', you should change its definition to include:
:original => '05c6495f8760e58eb68e2cce67433cf7f5299fa4'
Spree::Taxon Load (2.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 47 AND "spree_taxons"."rgt" >= 48) ORDE
R BY "spree_taxons"."lft"
CACHE (0.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 47 AND "spree_taxons"."rgt" >= 48) ORDER BY "spree_taxo
ns"."lft"
CACHE (0.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 47 AND "spree_taxons"."rgt" >= 48) ORDER BY "spree_
taxons"."lft"
CACHE (0.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 47 AND "spree_taxons"."rgt" >= 48) ORDER BY "spree_taxo
ns"."lft"
CACHE (0.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 47 AND "spree_taxons"."rgt" >= 48) ORDER BY "spree_
taxons"."lft"
Spree::Page Load (1.0ms) SELECT "spree_pages".* FROM "spree_pages" WHERE "spree_pages"."show_in_header" = 't' AND "spree_pages"."visible" = 't'
ORDER BY position ASC
Rendered C:/ruby193/lib/ruby/gems/1.9.1/bundler/gems/spree_static_content-22fcacc88736/app/views/spree/static_content/_static_content_list.html.erb (0.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_main_nav_bar.html.erb (138.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_header.html.erb (294.0ms)
 (2.0ms) SELECT COUNT(*) FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 47 AND "spree_taxons"."rgt" >= 48) AND ("spree_taxons".id != 34)

Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_sidebar.html.erb (0.0ms)
Deface: 2 overrides found for 'spree/shared/_footer'
Deface: 'pages_in_footer' matched 1 times with '#footer-right'
Deface: [WARNING] No :original defined for 'pages_in_footer', you should change its definition to include:
:original => '0e70b64f6d6eb3161e2de39b8253df9c0a201c63'
Deface: 'footer-left' matched 1 times with '#footer-left'
Deface: [WARNING] No :original defined for 'footer-left', you should change its definition to include:
:original => '6ae1a223848ff1a260221748a0206fc84597003c'
Spree::Page Load (2.0ms) SELECT "spree_pages".* FROM "spree_pages" WHERE "spree_pages"."show_in_footer" = 't' AND "spree_pages"."visible" = 't'
ORDER BY position ASC
Rendered C:/ruby193/lib/ruby/gems/1.9.1/bundler/gems/spree_static_content-22fcacc88736/app/views/spree/static_content/_static_content_list.html.erb (2.0ms)
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_footer.html.erb (22.0ms)
Spree::Tracker Load (2.0ms) SELECT "spree_trackers".* FROM "spree_trackers" WHERE "spree_trackers"."active" = 't' AND "spree_trackers"."envi
ronment" = 'development' LIMIT 1
Rendered C:/ruby193/lib/ruby/gems/1.9.1/gems/spree_core-1.2.4/app/views/spree/shared/_google_analytics.html.erb (3.0ms)
Completed 200 OK in 1413ms (Views: 1301.1ms | ActiveRecord: 98.0ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment