Skip to content

Instantly share code, notes, and snippets.

@gmacdougall

gmacdougall/product-show.log

Created July 2, 2015 19:09
Show Gist options
  • Save gmacdougall/50a5479ae77dda16449f to your computer and use it in GitHub Desktop.
Save gmacdougall/50a5479ae77dda16449f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
product-show.log
Started GET "/products/second-skin-platinum-trunk" for 127.0.0.1 at 2015-07-02 15:07:31 -0400
Spree::Page Exists (0.4ms) SELECT 1 AS one FROM `spree_pages` WHERE `spree_pages`.`visible` = 1 AND ((`spree_pages`.`slug` = 'products/second-skin-platinum-trunk' OR `spree_pages`.`slug` = '/products/second-skin-platinum-trunk')) ORDER BY position ASC LIMIT 1
Processing by Spree::ProductsController#show as HTML
Parameters: {"id"=>"second-skin-platinum-trunk"}
Spree::Order Load (0.4ms) SELECT `spree_orders`.* FROM `spree_orders` WHERE `spree_orders`.`id` = 5360423 AND `spree_orders`.`currency` = 'USD' LIMIT 1
Spree::Adjustment Load (0.3ms) SELECT `spree_adjustments`.* FROM `spree_adjustments` WHERE `spree_adjustments`.`adjustable_type` = 'Spree::Order' AND `spree_adjustments`.`adjustable_id` IN (5360423) ORDER BY spree_adjustments.created_at ASC
Spree::Preference Load (0.2ms) SELECT `spree_preferences`.* FROM `spree_preferences` WHERE `spree_preferences`.`key` = 'spree/frontend_configuration/locale' LIMIT 1
page slug: products/second-skin-platinum-trunk
Spree::Page Load (0.3ms) SELECT `spree_pages`.* FROM `spree_pages` WHERE `spree_pages`.`slug` = 'products/second-skin-platinum-trunk' ORDER BY position ASC LIMIT 1
 (0.3ms) SELECT COUNT(*) FROM `spree_adjustments` WHERE `spree_adjustments`.`adjustable_id` = 5360423 AND `spree_adjustments`.`adjustable_type` = 'Spree::Order' AND `spree_adjustments`.`originator_type` = 'Spree::PromotionAction' AND `spree_adjustments`.`eligible` = 1
 (0.6ms) SELECT `spree_products`.`id` FROM `spree_products` WHERE `spree_products`.`deleted_at` IS NULL AND (`spree_products`.`available_on` < '2015-07-02 19:07:31.802110')
Spree::Product Load (0.3ms) SELECT `spree_products`.* FROM `spree_products` WHERE `spree_products`.`id` IN (98683658, 158095921, 300709750, 338290009, 633131037, 871397402, 969162690, 1028197832, 1028197834, 1028197835, 1028197836, 1028197837, 1028197838, 1028197847, 1028197865, 1028197882, 1028197884, 1028197885, 1028197898, 1028197905, 1028197909, 1028197911, 1028197917, 1028197935, 1028197938, 1028197939, 1028197963, 1028197964, 1028197965, 1028197972, 1028197973, 1028197976, 1028197977, 1028197982, 1028197983, 1028197985, 1028197987, 1028197988, 1028197989, 1028197990, 1028197992, 1028197993, 1028197995, 1028197996, 1028197997, 1028197998, 1028198009, 1028198010, 1028198011, 1028198012, 1028198013) AND `spree_products`.`deleted_at` IS NULL AND `spree_products`.`permalink` = 'second-skin-platinum-trunk' LIMIT 1
Spree::Variant Load (0.4ms) SELECT `spree_variants`.* FROM `spree_variants` WHERE `spree_variants`.`deleted_at` IS NULL AND `spree_variants`.`is_master` = 0 AND `spree_variants`.`product_id` IN (1028197938) ORDER BY `spree_variants`.position ASC
Spree::Price Load (0.4ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`deleted_at` IS NULL AND `spree_prices`.`variant_id` IN (1069124546, 1069124547, 1069124548, 1069124549, 1069124550, 1069124562, 1069124563, 1069124564, 1069124565, 1069124566, 1069124938, 1069124939, 1069124940, 1069124941, 1069124942, 1069124943, 1069124944, 1069124945)
Spree::StockItem Load (0.9ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` IN (1069124546, 1069124547, 1069124548, 1069124549, 1069124550, 1069124562, 1069124563, 1069124564, 1069124565, 1069124566, 1069124938, 1069124939, 1069124940, 1069124941, 1069124942, 1069124943, 1069124944, 1069124945)
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`viewable_id` IN (1069124546, 1069124547, 1069124548, 1069124549, 1069124550, 1069124562, 1069124563, 1069124564, 1069124565, 1069124566, 1069124938, 1069124939, 1069124940, 1069124941, 1069124942, 1069124943, 1069124944, 1069124945) ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC
TommyJohn::Color Load (0.3ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` IN (99, 100, 143, 142)
 (0.3ms) SELECT `spree_taxons`.`permalink` FROM `spree_taxons` INNER JOIN `spree_products_taxons` ON `spree_taxons`.`id` = `spree_products_taxons`.`taxon_id` WHERE `spree_products_taxons`.`product_id` = 1028197938
Spree::Review Load (1.2ms) SELECT `spree_reviews`.* FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 AND (created_at >= '2015-04-03 19:07:31.821733') ORDER BY rating DESC, created_at DESC LIMIT 3
 (1.0ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 AND (created_at >= '2015-04-03 19:07:31.821733') LIMIT 3) subquery_for_count
Deface: 1 overrides found for 'spree/products/show'
Deface: 'converted_product_properties_767643482' matched 0 times with '[data-hook='product_properties']'
Rendered legacy/spree/products/show/_meta_params.haml (1.4ms)
Spree::Variant Load (0.3ms) SELECT `spree_variants`.* FROM `spree_variants` WHERE `spree_variants`.`deleted_at` IS NULL AND `spree_variants`.`product_id` = 1028197938 AND `spree_variants`.`is_master` = 1 LIMIT 1
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`default` = 1 ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC LIMIT 1
opengraph product show cache key: opengraph_meta_tags-second-skin-platinum-trunk-ac2f36a4839c645a884aa466ed5466fa
Read fragment views/opengraph_meta_tags-second-skin-platinum-trunk-ac2f36a4839c645a884aa466ed5466fa/966b78ca316755143227542ac1efd652 (0.2ms)
Rendered legacy/spree/products/show/_opengraph.haml (9.3ms)
Spree::Variant Load (0.5ms) SELECT `spree_variants`.* FROM `spree_variants` INNER JOIN `spree_prices` ON `spree_prices`.`variant_id` = `spree_variants`.`id` AND `spree_prices`.`deleted_at` IS NULL WHERE `spree_variants`.`product_id` = 1028197938 AND `spree_variants`.`is_master` = 0 AND `spree_variants`.`deleted_at` IS NULL AND `spree_prices`.`currency` = 'USD' AND (spree_prices.amount IS NOT NULL) AND (`spree_variants`.`not_for_sale` != 1) AND `spree_variants`.`visible` = 1 ORDER BY `spree_variants`.position ASC
TommyJohn::Color Load (0.3ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` IN (100, 143, 142)
 (0.4ms) SELECT COUNT(*) FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` = 100
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` = 100 ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` IS NULL ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC
 (0.4ms) SELECT COUNT(*) FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` = 143
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` = 143 ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC
CACHE (0.0ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` IS NULL ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC [["viewable_id", 1069124299], ["viewable_type", "Spree::Variant"]]
 (0.5ms) SELECT COUNT(*) FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` = 142
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` = 142 ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC
CACHE (0.0ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`color_id` IS NULL ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC [["viewable_id", 1069124299], ["viewable_type", "Spree::Variant"]]
CACHE (0.0ms) SELECT `spree_variants`.* FROM `spree_variants` INNER JOIN `spree_prices` ON `spree_prices`.`variant_id` = `spree_variants`.`id` AND `spree_prices`.`deleted_at` IS NULL WHERE `spree_variants`.`product_id` = 1028197938 AND `spree_variants`.`is_master` = 0 AND `spree_variants`.`deleted_at` IS NULL AND `spree_prices`.`currency` = 'USD' AND (spree_prices.amount IS NOT NULL) AND (`spree_variants`.`not_for_sale` != 1) AND `spree_variants`.`visible` = 1 ORDER BY `spree_variants`.position ASC [["product_id", 1028197938]]
TommyJohn::Color Load (0.2ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` = 100 LIMIT 1
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124562 AND `spree_prices`.`currency` = 'USD' LIMIT 1
Spree::StockItem Load (0.8ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` = 1069124562
CACHE (0.0ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` = 100 LIMIT 1 [["id", 100]]
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124566 AND `spree_prices`.`currency` = 'USD' LIMIT 1
Spree::StockItem Load (0.8ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` = 1069124566
TommyJohn::Color Load (0.2ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` = 143 LIMIT 1
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124939 AND `spree_prices`.`currency` = 'USD' LIMIT 1
Spree::StockItem Load (0.8ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` = 1069124939
TommyJohn::Color Load (0.2ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` = 142 LIMIT 1
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124942 AND `spree_prices`.`currency` = 'USD' LIMIT 1
Spree::StockItem Load (0.8ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` = 1069124942
CACHE (0.0ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` = 142 LIMIT 1 [["id", 142]]
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124943 AND `spree_prices`.`currency` = 'USD' LIMIT 1
Spree::StockItem Load (0.8ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` = 1069124943
CACHE (0.0ms) SELECT `tommy_john_colors`.* FROM `tommy_john_colors` WHERE `tommy_john_colors`.`id` = 142 LIMIT 1 [["id", 142]]
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124945 AND `spree_prices`.`currency` = 'USD' LIMIT 1
Spree::StockItem Load (0.8ms) SELECT `spree_stock_items`.* FROM `spree_stock_items` WHERE `spree_stock_items`.`deleted_at` IS NULL AND `spree_stock_items`.`variant_id` = 1069124945
Rendered legacy/spree/products/_breadcrumb.html.haml (2.4ms)
Spree::Image Load (0.4ms) SELECT `spree_assets`.* FROM `spree_assets` WHERE `spree_assets`.`type` IN ('Spree::Image') AND `spree_assets`.`viewable_id` = 1069124299 AND `spree_assets`.`viewable_type` = 'Spree::Variant' AND `spree_assets`.`default` = 1 ORDER BY spree_assets.color_id, spree_assets.position, `spree_assets`.`position` ASC
product images partial cache key: second-skin-platinum-trunk-https:///assets/spree/images/attachments/1061023033/original/2211PT_DKSFM_ECOM_14327470.jpg?1432747074-https:///assets/spree/images/attachments/1061023034/original/2211PT_MJCLA_ECOM_14327470.jpg?1432747089
Read fragment views/second-skin-platinum-trunk-https:///assets/spree/images/attachments/1061023033/original/2211PT_DKSFM_ECOM_14327470.jpg?1432747074-https:///assets/spree/images/attachments/1061023034/original/2211PT_MJCLA_ECOM_14327470.jpg?1432747089/a1e7f9aeef2771a30b2e17eb146972d9 (0.2ms)
Rendered legacy/spree/products/show/_images.haml (9.6ms)
Spree::Taxon Load (0.3ms) SELECT `spree_taxons`.* FROM `spree_taxons` INNER JOIN `spree_products_taxons` ON `spree_taxons`.`id` = `spree_products_taxons`.`taxon_id` WHERE `spree_products_taxons`.`product_id` = 1028197938
Spree::Price Load (0.3ms) SELECT `spree_prices`.* FROM `spree_prices` WHERE `spree_prices`.`variant_id` = 1069124299 AND `spree_prices`.`currency` = 'USD' LIMIT 1
 (1.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
 (1.0ms) SELECT SUM(`spree_reviews`.`rating`) AS sum_id FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
Rendered legacy/shared/_stars.html.haml (1.6ms)
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
Rendered legacy/spree/products/show/form/_header.haml (18.2ms)
CACHE (0.0ms) SELECT `spree_variants`.* FROM `spree_variants` INNER JOIN `spree_prices` ON `spree_prices`.`variant_id` = `spree_variants`.`id` AND `spree_prices`.`deleted_at` IS NULL WHERE `spree_variants`.`product_id` = 1028197938 AND `spree_variants`.`is_master` = 0 AND `spree_variants`.`deleted_at` IS NULL AND `spree_prices`.`currency` = 'USD' AND (spree_prices.amount IS NOT NULL) AND (`spree_variants`.`not_for_sale` != 1) AND `spree_variants`.`visible` = 1 ORDER BY `spree_variants`.position ASC [["product_id", 1028197938]]
product show form size cache key: product-form-size-underwear-S-XXL-M-XL
Read fragment views/product-form-size-underwear-S-XXL-M-XL/4ac464bf7a79329e1df5bdcec314aa57 (0.2ms)
Rendered legacy/spree/products/show/form/options/_size.haml (5.9ms)
Rendered legacy/spree/products/show/form/options/_color.haml (5.2ms)
Rendered legacy/spree/products/show/form/options/_quantity.haml (3.4ms)
product show form buttons cache key: product-form-buttons-true-false-1069124299
Read fragment views/product-form-buttons-true-false-1069124299/aa37b885cb7e654a63b31138c58ecc4a (0.2ms)
Rendered legacy/spree/products/show/form/options/_buttons.haml (3.5ms)
Rendered legacy/spree/products/show/form/_options.haml (22.8ms)
 (0.9ms) SELECT `spree_taxons`.`description` FROM `spree_taxons` INNER JOIN `spree_taxonomies` ON `spree_taxonomies`.`id` = `spree_taxons`.`taxonomy_id` INNER JOIN `spree_products_taxons` ON `spree_taxons`.`id` = `spree_products_taxons`.`taxon_id` WHERE `spree_products_taxons`.`product_id` = 1028197938 AND `spree_taxonomies`.`name` = 'Product Descriptions' ORDER BY `spree_taxons`.`position` ASC
 (0.8ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
CACHE (0.0ms) SELECT SUM(`spree_reviews`.`rating`) AS sum_id FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
Rendered legacy/shared/_stars.html.haml (8.9ms)
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
Rendered legacy/spree/products/show/form/_description.haml (19.6ms)
Rendered legacy/spree/products/show/_form.haml (64.2ms)
 (0.9ms) SELECT `spree_taxons`.`description` FROM `spree_taxons` INNER JOIN `spree_taxonomies` ON `spree_taxonomies`.`id` = `spree_taxons`.`taxonomy_id` INNER JOIN `spree_products_taxons` ON `spree_taxons`.`id` = `spree_products_taxons`.`taxon_id` WHERE `spree_products_taxons`.`product_id` = 1028197938 AND `spree_taxonomies`.`name` = 'Product Page Fabrics' ORDER BY `spree_taxons`.`position` ASC
Rendered legacy/spree/products/show/_fabric.haml (3.5ms)
Rendered legacy/shared/_phone_number.haml (1.0ms)
Rendered legacy/shared/_contact_us.haml (1.1ms)
Rendered legacy/spree/products/show/features/_other_info.haml (5.4ms)
Rendered legacy/spree/products/_underwear_second_skin.html.haml (4.4ms)
Rendered legacy/spree/products/show/_features.haml (18.3ms)
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
CACHE (0.0ms) SELECT SUM(`spree_reviews`.`rating`) AS sum_id FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
CACHE (0.0ms) SELECT COUNT(*) FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 [["product_id", 1028197938]]
Rendered legacy/shared/_stars.html.haml (9.8ms)
Rendered legacy/spree/products/_reviews_header.html.haml (13.8ms)
 (1.1ms) SELECT `spree_reviews`.`id` FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 AND (created_at >= '2015-04-03 19:07:31.821733') ORDER BY rating DESC, created_at DESC LIMIT 3
CACHE (0.0ms) SELECT `spree_reviews`.* FROM `spree_reviews` WHERE `spree_reviews`.`product_id` = 1028197938 AND `spree_reviews`.`hide` = 0 AND (created_at >= '2015-04-03 19:07:31.821733') ORDER BY rating DESC, created_at DESC LIMIT 3 [["product_id", 1028197938]]
Spree::OfficialResponse Load (0.3ms) SELECT `spree_official_responses`.* FROM `spree_official_responses` WHERE `spree_official_responses`.`review_id` = 2245 LIMIT 1
Spree::OfficialResponse Load (0.3ms) SELECT `spree_official_responses`.* FROM `spree_official_responses` WHERE `spree_official_responses`.`review_id` = 2228 LIMIT 1
Spree::OfficialResponse Load (0.3ms) SELECT `spree_official_responses`.* FROM `spree_official_responses` WHERE `spree_official_responses`.`review_id` = 2235 LIMIT 1
product reviews partial cache key: reviews-second-skin-platinum-trunk-2245-2228-2235-d41d8cd98f00b204e9800998ecf8427e-d41d8cd98f00b204e9800998ecf8427e-d41d8cd98f00b204e9800998ecf8427e
Read fragment views/reviews-second-skin-platinum-trunk-2245-2228-2235-d41d8cd98f00b204e9800998ecf8427e-d41d8cd98f00b204e9800998ecf8427e-d41d8cd98f00b204e9800998ecf8427e/8d2b610356acc1c017c718ba628eb033 (0.2ms)
Rendered legacy/spree/products/_reviews_footer.html.haml (2.0ms)
Rendered legacy/spree/products/_reviews.html.haml (27.3ms)
Rendered legacy/shared/_product_modals.html.haml (2.9ms)
Rendered legacy/spree/products/show.html.haml within layouts/tommyjohn (206.4ms)
Rendered legacy/layouts/_ios_homescreen.html.erb (0.9ms)
Rendered legacy/vendor/google/trusted_stores/badge/_setup.html.erb (0.5ms)
Rendered legacy/vendor/monetate/_base.html.erb (0.5ms)
Rendered vendor/bundle/bundler/gems/spree-262061f8d232/core/app/views/spree/shared/_routes.html.erb (9.6ms)
Spree::TokenizedPermission Load (0.3ms) SELECT `spree_tokenized_permissions`.* FROM `spree_tokenized_permissions` WHERE `spree_tokenized_permissions`.`permissable_id` = 5360423 AND `spree_tokenized_permissions`.`permissable_type` = 'Spree::Order' LIMIT 1
Rendered legacy/spree/shared/_head_javascript.haml (14.1ms)
Rendered legacy/vendor/google/analytics/_create_tracking.html.erb (0.7ms)
Rendered legacy/vendor/google/analytics/_user_id_tracking.html.erb (0.6ms)
Rendered legacy/vendor/bronto/_click_tracking.html.erb (0.6ms)
Rendered legacy/vendor/facebook/_sdk.html.erb (0.8ms)
Rendered legacy/vendor/facebook/_mobile_tracking.html.erb (0.7ms)
Rendered legacy/layouts/_mobile_nav.html.haml (4.6ms)
Rendered legacy/layouts/_mobile_cart.html.haml (1.7ms)
Rendered legacy/layouts/_primary_nav.haml (6.4ms)
Rendered legacy/layouts/_header.html.haml (19.3ms)
Rendered legacy/tommy_john/promos/_mailing_list_sign_up.haml (2.0ms)
Rendered legacy/shared/_phone_number.haml (9.1ms)
Rendered legacy/shared/_contact_us.haml (9.8ms)
Rendered legacy/mailing_list_subscriptions/_form.html.haml (2.1ms)
Rendered legacy/layouts/_footer.html.haml (28.8ms)
Rendered legacy/spree/user_sessions/_form.html.haml (2.6ms)
Rendered legacy/spree/shared/_error_messages.html.haml (1.5ms)
Rendered legacy/spree/user_registrations/_form.html.haml (5.9ms)
Rendered legacy/shared/_login_for_wishlist_signup_modal.html.haml (13.7ms)
Rendered legacy/page/homepage/_mobile_interstitial.html.haml (5.0ms)
Rendered legacy/shared/_modals.html.haml (23.6ms)
Rendered legacy/layouts/_flash.html.haml (1.3ms)
Rendered legacy/vendor/google/tag_manager/_setup_data_layer.html.haml (2.2ms)
Rendered legacy/vendor/google/tag_manager/_tag_manager.html.erb (0.6ms)
Rendered legacy/vendor/olark_chat/_chat.html.erb (0.6ms)
Rendered legacy/vendor/canopy_labs/_track_visits.haml (1.5ms)
Rendered legacy/vendor/google/trusted_stores/badge/_invoke.html (0.6ms)
Rendered legacy/vendor/impact_radius/_impact_radius_url_tracking.haml (2.6ms)
Rendered legacy/vendor/bronto/_cart_recovery.html.erb (1.1ms)
Completed 200 OK in 399ms (Views: 343.3ms | ActiveRecord: 27.1ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment