Skip to content

Instantly share code, notes, and snippets.

@padi

padi/development.log

Last active December 6, 2017 06:45
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 padi/0938fc9dffa6b70f6d8ea45fe57b0187 to your computer and use it in GitHub Desktop.
Save padi/0938fc9dffa6b70f6d8ea45fe57b0187 to your computer and use it in GitHub Desktop.
Download ZIP
chaos-app: GET /products on first load (development environment)
Raw
development.log
Started GET "/products" for 127.0.0.1 at 2017-12-06 14:29:33 +0800
Processing by ProductsController#index as HTML
User Load (1.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]]
Spree::Preference Load (4.0ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1 LIMIT $2 [["key", "spree/app_configuration/currency"], ["LIMIT", 1]]
Spree::Store Load (5.3ms) SELECT "spree_stores".* FROM "spree_stores" WHERE (url like '%tsi.lvh.me%') ORDER BY "spree_stores"."id" ASC LIMIT $1 [["LIMIT", 1]]
Spree::Store Load (6.3ms) SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = $1 ORDER BY "spree_stores"."id" ASC LIMIT $2 [["default", "t"], ["LIMIT", 1]]
Spree::Order Load (2.8ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = $1 AND "spree_orders"."guest_token" = $2 AND "spree_orders"."store_id" = $3 LIMIT $4 [["currency", "USD"], ["guest_token", "Xhm5PlNsQ2IhbFbnCK4u8g1512355822241"], ["store_id", 1], ["LIMIT", 1]]
Spree::Order Load (4.8ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."store_id" = 1 AND "spree_orders"."completed_at" IS NULL ORDER BY created_at DESC LIMIT $2 [["user_id", 2], ["LIMIT", 1]]
Dealer Load (3.2ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
Rendering products/index.html.erb within layouts/express_ui/content_and_sidebar_fixed
(3.8ms) SELECT COUNT(*) FROM "products" WHERE (skus <> '{}')
Product Load (3.6ms) SELECT "products"."id", "products"."name", "products"."description", "products"."style_num", "products"."brand", "products"."skus", "products"."msrps", "products"."categories", "products"."supplier_id", "products"."colors", "products"."sizes" FROM "products" WHERE (skus <> '{}') LIMIT $1 OFFSET $2 [["LIMIT", 16], ["OFFSET", 0]]
Products::Photo Load (2.0ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 12], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
Dealers::Bag Load (1.1ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (1.5ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 12 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black/Orange') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (2.0ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 12], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (717.9ms)
Rendered products/_photo_swatch.html.erb (826.1ms)
Rendered products/_photo_swatch.html.erb (714.5ms)
Rendered products/_photo_swatch.html.erb (717.5ms)
Rendered products/_photo_swatch.html.erb (715.7ms)
(1.4ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 12], ["OFFSET", 5]]
Products::Photo Load (1.5ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 12], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (763.7ms)
Rendered products/_photo_swatch.html.erb (721.8ms)
Rendered products/_photo_swatch.html.erb (721.0ms)
Rendered products/_photo_swatch.html.erb (718.2ms)
Rendered products/_photo_swatches.html.erb (6662.7ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (7862.3ms)
Products::Photo Load (6.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.1ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (5.0ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 1 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Dark Fuchsia') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 1], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (718.3ms)
Rendered products/_photo_swatch.html.erb (716.9ms)
Rendered products/_photo_swatch.html.erb (728.4ms)
(1.6ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 1], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (2183.9ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (2968.6ms)
Products::Photo Load (1.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 2], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.1ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 2 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'White') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 2], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (717.9ms)
(1.3ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 2], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (732.9ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (1511.6ms)
Products::Photo Load (2.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 13], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (6.2ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 13 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (2.0ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 13], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (717.0ms)
Rendered products/_photo_swatch.html.erb (752.1ms)
Rendered products/_photo_swatch.html.erb (719.7ms)
Rendered products/_photo_swatch.html.erb (719.5ms)
Rendered products/_photo_swatch.html.erb (805.9ms)
(2.0ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 13], ["OFFSET", 5]]
Products::Photo Load (1.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 13], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (723.8ms)
Rendered products/_photo_swatch.html.erb (734.0ms)
Rendered products/_photo_swatch.html.erb (725.7ms)
Rendered products/_photo_swatches.html.erb (5938.7ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (6725.0ms)
Products::Photo Load (3.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 3], ["LIMIT", 1]]
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.5ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 3 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 3], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (721.4ms)
Rendered products/_photo_swatch.html.erb (721.7ms)
Rendered products/_photo_swatch.html.erb (767.3ms)
Rendered products/_photo_swatch.html.erb (736.8ms)
Rendered products/_photo_swatch.html.erb (832.0ms)
(2.2ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 3], ["OFFSET", 5]]
Products::Photo Load (1.7ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 3], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (810.6ms)
Rendered products/_photo_swatch.html.erb (737.7ms)
Rendered products/_photo_swatch.html.erb (741.0ms)
Rendered products/_photo_swatch.html.erb (761.8ms)
Rendered products/_photo_swatch.html.erb (733.4ms)
Rendered products/_photo_swatch.html.erb (735.4ms)
Rendered products/_photo_swatches.html.erb (8346.0ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (9129.9ms)
Products::Photo Load (1.6ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 4], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.1ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.9ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 4 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (2.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 4], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (728.0ms)
Rendered products/_photo_swatch.html.erb (736.3ms)
Rendered products/_photo_swatch.html.erb (762.5ms)
Rendered products/_photo_swatch.html.erb (813.0ms)
Rendered products/_photo_swatch.html.erb (725.7ms)
(1.4ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 4], ["OFFSET", 5]]
Products::Photo Load (1.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 4], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (734.3ms)
Rendered products/_photo_swatch.html.erb (719.7ms)
Rendered products/_photo_swatch.html.erb (716.3ms)
Rendered products/_photo_swatch.html.erb (717.7ms)
Rendered products/_photo_swatch.html.erb (749.0ms)
Rendered products/_photo_swatch.html.erb (823.4ms)
Rendered products/_photo_swatches.html.erb (8271.2ms)
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (9057.8ms)
Products::Photo Load (2.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 5], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.1ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 5 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (2.5ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 5], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (718.1ms)
Rendered products/_photo_swatch.html.erb (802.6ms)
Rendered products/_photo_swatch.html.erb (718.7ms)
(1.8ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 5], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (2263.1ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.1ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (3051.4ms)
Products::Photo Load (1.6ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 6], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.1ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.1ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 6 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Athletic Gold') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (1.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 6], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (718.2ms)
Rendered products/_photo_swatch.html.erb (736.5ms)
Rendered products/_photo_swatch.html.erb (725.0ms)
Rendered products/_photo_swatch.html.erb (723.2ms)
Rendered products/_photo_swatch.html.erb (824.5ms)
(2.2ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 6], ["OFFSET", 5]]
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 6], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (716.9ms)
Rendered products/_photo_swatch.html.erb (1283.7ms)
Rendered products/_photo_swatch.html.erb (719.1ms)
Rendered products/_photo_swatch.html.erb (740.1ms)
Rendered products/_photo_swatch.html.erb (817.5ms)
Rendered products/_photo_swatch.html.erb (725.1ms)
Rendered products/_photo_swatch.html.erb (730.9ms)
Rendered products/_photo_swatch.html.erb (787.5ms)
Rendered products/_photo_swatch.html.erb (825.0ms)
Rendered products/_photo_swatch.html.erb (716.8ms)
Rendered products/_photo_swatch.html.erb (746.9ms)
Rendered products/_photo_swatch.html.erb (719.9ms)
Rendered products/_photo_swatches.html.erb (13317.9ms)
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.1ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (14089.1ms)
Products::Photo Load (2.7ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 8], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.1ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 8 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Athletic Gold') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (2.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 8], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (722.2ms)
Rendered products/_photo_swatch.html.erb (771.4ms)
Rendered products/_photo_swatch.html.erb (717.3ms)
Rendered products/_photo_swatch.html.erb (739.9ms)
Rendered products/_photo_swatch.html.erb (813.8ms)
(2.2ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 8], ["OFFSET", 5]]
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 8], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (726.5ms)
Started GET "/products" for 127.0.0.1 at 2017-12-06 14:30:33 +0800
Processing by ProductsController#index as HTML
User Load (3.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 [["id", 2], ["LIMIT", 1]]
Spree::Preference Load (11.7ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1 LIMIT $2 [["key", "spree/app_configuration/currency"], ["LIMIT", 1]]
Spree::Store Load (17.4ms) SELECT "spree_stores".* FROM "spree_stores" WHERE (url like '%tsi.lvh.me%') ORDER BY "spree_stores"."id" ASC LIMIT $1 [["LIMIT", 1]]
Spree::Store Load (6.8ms) SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = $1 ORDER BY "spree_stores"."id" ASC LIMIT $2 [["default", "t"], ["LIMIT", 1]]
Spree::Order Load (4.4ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = $1 AND "spree_orders"."guest_token" = $2 AND "spree_orders"."store_id" = $3 LIMIT $4 [["currency", "USD"], ["guest_token", "Xhm5PlNsQ2IhbFbnCK4u8g1512355822241"], ["store_id", 1], ["LIMIT", 1]]
Spree::Order Load (4.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."store_id" = 1 AND "spree_orders"."completed_at" IS NULL ORDER BY created_at DESC LIMIT $2 [["user_id", 2], ["LIMIT", 1]]
Dealer Load (2.7ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
Rendering products/index.html.erb within layouts/express_ui/content_and_sidebar_fixed
(3.1ms) SELECT COUNT(*) FROM "products" WHERE (skus <> '{}')
Product Load (1.9ms) SELECT "products"."id", "products"."name", "products"."description", "products"."style_num", "products"."brand", "products"."skus", "products"."msrps", "products"."categories", "products"."supplier_id", "products"."colors", "products"."sizes" FROM "products" WHERE (skus <> '{}') LIMIT $1 OFFSET $2 [["LIMIT", 16], ["OFFSET", 0]]
Products::Photo Load (1.8ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 12], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
Dealers::Bag Load (1.2ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (2.4ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 12 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black/Orange') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (734.3ms)
Products::Photo Load (8.6ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 12], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (721.7ms)
Rendered products/_photo_swatch.html.erb (721.1ms)
Rendered products/_photo_swatch.html.erb (716.6ms)
Rendered products/_photo_swatch.html.erb (716.7ms)
Rendered products/_photo_swatch.html.erb (714.6ms)
Rendered products/_photo_swatch.html.erb (716.8ms)
Rendered products/_photo_swatch.html.erb (715.7ms)
Rendered products/_photo_swatch.html.erb (724.7ms)
Rendered products/_photo_swatch.html.erb (714.5ms)
Rendered products/_photo_swatch.html.erb (728.3ms)
(2.2ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 12], ["OFFSET", 5]]
Products::Photo Load (1.8ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 12], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (717.9ms)
Rendered products/_photo_swatch.html.erb (733.3ms)
Rendered products/_photo_swatch.html.erb (719.5ms)
Rendered products/_photo_swatches.html.erb (10303.1ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (11068.6ms)
Products::Photo Load (1.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 7], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (5.9ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 7 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Athletic Gold') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (721.4ms)
Products::Photo Load (1.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 7], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (720.1ms)
Rendered products/_photo_swatch.html.erb (720.5ms)
Rendered products/_photo_swatch.html.erb (744.7ms)
Rendered products/_photo_swatches.html.erb (6594.7ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (1.9ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (7403.1ms)
Products::Photo Load (4.7ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (6.0ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 1 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Dark Fuchsia') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (721.6ms)
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 1], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (727.9ms)
Rendered products/_photo_swatch.html.erb (718.0ms)
Rendered products/_photo_swatch.html.erb (729.7ms)
Rendered products/_photo_swatch.html.erb (1658.8ms)
Rendered products/_photo_swatch.html.erb (900.5ms)
(1.8ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 1], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (2373.6ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (3192.0ms)
Rendered products/_photo_swatch.html.erb (726.8ms)
Products::Photo Load (3.0ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 2], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
(17.2ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 7], ["OFFSET", 5]]
Dealers::BagItem Load (14.8ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 2 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'White') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Products::Photo Load (20.8ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 7], ["OFFSET", 5]]
Products::Photo Load (1.8ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 2], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (742.2ms)
Rendered products/_photo_swatch.html.erb (714.8ms)
(1.3ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 2], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (731.0ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (726.0ms)
Rendered products/_list_item.html.erb (1576.1ms)
Products::Photo Load (1.6ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 13], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (7.1ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 13 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (731.5ms)
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 13], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (716.6ms)
Rendered products/_photo_swatch.html.erb (732.9ms)
Rendered products/_photo_swatch.html.erb (765.1ms)
Rendered products/_photo_swatch.html.erb (1250.9ms)
Rendered products/_photo_swatch.html.erb (720.5ms)
Rendered products/_photo_swatch.html.erb (718.1ms)
Rendered products/_photo_swatch.html.erb (718.1ms)
Rendered products/_photo_swatch.html.erb (720.4ms)
Rendered products/_photo_swatch.html.erb (730.5ms)
(1.5ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 13], ["OFFSET", 5]]
Products::Photo Load (1.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 13], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (717.5ms)
Rendered products/_photo_swatch.html.erb (720.1ms)
Rendered products/_photo_swatch.html.erb (719.8ms)
Rendered products/_photo_swatch.html.erb (722.2ms)
Rendered products/_photo_swatch.html.erb (719.1ms)
Rendered products/_photo_swatch.html.erb (720.7ms)
Rendered products/_photo_swatches.html.erb (5871.2ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (6666.9ms)
Products::Photo Load (1.5ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 3], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (6.4ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 3 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (727.4ms)
Products::Photo Load (1.4ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 3], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (715.1ms)
Rendered products/_photo_swatches.html.erb (13919.8ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (14697.4ms)
Products::Photo Load (1.5ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 9], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (4.8ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 9 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Athletic Gold') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (742.2ms)
Products::Photo Load (1.6ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 9], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (771.9ms)
Rendered products/_photo_swatch.html.erb (722.4ms)
Rendered products/_photo_swatch.html.erb (716.0ms)
Rendered products/_photo_swatch.html.erb (716.6ms)
Rendered products/_photo_swatch.html.erb (771.5ms)
Rendered products/_photo_swatch.html.erb (720.4ms)
Rendered products/_photo_swatch.html.erb (719.8ms)
(2.0ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 3], ["OFFSET", 5]]
Products::Photo Load (3.8ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 3], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (718.7ms)
Rendered products/_photo_swatch.html.erb (738.7ms)
Rendered products/_photo_swatch.html.erb (725.0ms)
(1.4ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 9], ["OFFSET", 5]]
Products::Photo Load (2.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 9], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (723.9ms)
Rendered products/_photo_swatch.html.erb (723.3ms)
Rendered products/_photo_swatch.html.erb (724.9ms)
Rendered products/_photo_swatch.html.erb (721.1ms)
Rendered products/_photo_swatch.html.erb (718.2ms)
Rendered products/_photo_swatch.html.erb (725.5ms)
Rendered products/_photo_swatch.html.erb (725.5ms)
Rendered products/_photo_swatch.html.erb (719.0ms)
Rendered products/_photo_swatch.html.erb (812.6ms)
Rendered products/_photo_swatches.html.erb (8226.9ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (9000.7ms)
Products::Photo Load (1.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 4], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (3.3ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 4 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (715.3ms)
Products::Photo Load (1.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 4], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (715.2ms)
Rendered products/_photo_swatch.html.erb (716.3ms)
Rendered products/_photo_swatch.html.erb (718.4ms)
Rendered products/_photo_swatch.html.erb (714.5ms)
Rendered products/_photo_swatch.html.erb (731.1ms)
Rendered products/_photo_swatch.html.erb (716.9ms)
Rendered products/_photo_swatch.html.erb (714.6ms)
Rendered products/_photo_swatches.html.erb (10156.2ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.3ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (10951.8ms)
Products::Photo Load (2.9ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 10], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (8.2ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 10 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'White/Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (720.6ms)
Products::Photo Load (2.1ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 10], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (717.4ms)
(2.2ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 4], ["OFFSET", 5]]
Products::Photo Load (2.1ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2 [["product_id", 4], ["OFFSET", 5]]
Rendered products/_photo_swatch.html.erb (814.7ms)
Rendered products/_photo_swatch.html.erb (729.5ms)
Rendered products/_photo_swatch.html.erb (726.9ms)
Rendered products/_photo_swatch.html.erb (722.3ms)
Rendered products/_photo_swatch.html.erb (714.9ms)
Rendered products/_photo_swatch.html.erb (755.8ms)
Rendered products/_photo_swatch.html.erb (735.0ms)
Rendered products/_photo_swatch.html.erb (739.3ms)
Rendered products/_photo_swatch.html.erb (738.5ms)
(1.3ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 10], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (3763.5ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (4583.0ms)
Products::Photo Load (4.0ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 11], ["LIMIT", 1]]
CACHE Dealer Load (0.2ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (6.3ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 11 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Navy') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (749.5ms)
Products::Photo Load (2.9ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 11], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (865.2ms)
Rendered products/_photo_swatches.html.erb (8196.9ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (8989.7ms)
Products::Photo Load (2.2ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 5], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Dealers::BagItem Load (13.4ms) SELECT "dealers_bag_items".* FROM "dealers_bag_items" WHERE "dealers_bag_items"."product_id" = 5 AND "dealers_bag_items"."bag_id" = 1 AND (variants->>'color' = 'Black') ORDER BY "dealers_bag_items"."id" ASC LIMIT $1 [["LIMIT", 1]]
Rendered products/_photo_swatch.html.erb (757.0ms)
Products::Photo Load (2.3ms) SELECT "products_photos".* FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC LIMIT $2 [["product_id", 5], ["LIMIT", 5]]
Rendered products/_photo_swatch.html.erb (746.3ms)
Rendered products/_photo_swatch.html.erb (740.7ms)
Rendered products/_photo_swatch.html.erb (733.1ms)
(1.3ms) SELECT COUNT(*) FROM (SELECT 1 FROM "products_photos" WHERE "products_photos"."product_id" = $1 ORDER BY "products_photos"."color_name" ASC OFFSET $2) subquery_for_count [["product_id", 11], ["OFFSET", 5]]
Rendered products/_photo_swatches.html.erb (2261.1ms)
CACHE Dealer Load (0.1ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
Rendered products/_list_item.html.erb (3109.0ms)
Rendered shared/_left_sidebar_toggle.html.erb (0.4ms)
Spree::Role Load (1.2ms) SELECT "spree_roles".* FROM "spree_roles" INNER JOIN "spree_role_users" ON "spree_roles"."id" = "spree_role_users"."role_id" WHERE "spree_role_users"."user_id" = $1 [["user_id", 2]]
Rendered products/_filter_category.html.erb (0.5ms)
Rendered products/_filter_all_categories.html.erb (1.2ms)
Rendered products/_filter_brand.html.erb (0.6ms)
Rendered products/_filter_all_brands.html.erb (0.4ms)
Rendered products/_filter_sport.html.erb (0.6ms)
Rendered products/_filter_gender.html.erb (0.5ms)
Rendered products/_filter_color.html.erb (0.4ms)
Rendered products/_filter_price_range.html.erb (1.3ms)
Rendered products/_filter_size.html.erb (0.5ms)
Rendered products/_sidebar.html.erb (49.0ms)
Rendered products/index.html.erb within layouts/express_ui/content_and_sidebar_fixed (98981.8ms)
Rendered engines/express_ui/app/views/layouts/express_ui/_head.html.erb (339.5ms)
CACHE Dealer Load (0.0ms) SELECT "dealers".* FROM "dealers" WHERE "dealers"."slug" = $1 LIMIT $2 [["slug", "tsi"], ["LIMIT", 1]]
CACHE Dealers::Bag Load (0.0ms) SELECT "dealers_bags".* FROM "dealers_bags" WHERE "dealers_bags"."dealer_id" = $1 LIMIT $2 [["dealer_id", 1], ["LIMIT", 1]]
(3.4ms) SELECT COUNT(*) FROM "dealers_bag_items" WHERE "dealers_bag_items"."bag_id" = $1 [["bag_id", 1]]
Rendered shared/_header.html.erb (15.9ms)
Rendered search/_input.html.erb (2.9ms)
Rendered shared/_flash_messages.html.erb (0.9ms)
Rendered shared/_footer.html.erb (6.9ms)
Rendered engines/express_ui/app/views/layouts/express_ui/_doctype_html.html.erb (377.3ms)
Completed 200 OK in 99469ms (Views: 99161.9ms | ActiveRecord: 244.4ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment