spree/spree — pull request #5721 by BenMorganIO (2014-12-05 22:44:53+00:00)
Title: Sock items n+1 fix

When visiting http://localhost:3000/admin/products/:product_id/stock this was the before:

```sql
14:43:06 web.1 | Processing by Spree::Admin::ProductsController#stock as HTML
14:43:06 web.1 | Parameters: {"id"=>"the-girls-short-sleeve-t-shirt"}
14:43:06 web.1 | Spree::Preference Load (0.8ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/backend_configuration/locale' LIMIT 1
14:43:06 web.1 | Spree::User Load (0.8ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."id" = 1 ORDER BY "spree_users"."id" ASC LIMIT 1
14:43:06 web.1 | Spree::Store Load (0.5ms) SELECT "spree_stores".* FROM "spree_stores" WHERE (url like '%localhost%') ORDER BY "spree_stores"."id" ASC LIMIT 1
14:43:06 web.1 | Spree::Store Load (0.6ms) SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = 't' ORDER BY "spree_stores"."id" ASC LIMIT 1
14:43:06 web.1 | Spree::Order Load (0.9ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = 'USD' AND "spree_orders"."guest_token" = 'I1834Yp4JKcP8v1JXl7V_g' AND "spree_orders"."store_id" = 1 AND "spree_orders"."user_id" = 1 LIMIT 1
14:43:06 web.1 | Spree::Order Load (0.4ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."completed_at" IS NULL AND "spree_orders"."user_id" = 1 ORDER BY created_at DESC LIMIT 1 [["user_id", 1]]
14:43:06 web.1 | Spree::Order Load (0.3ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."completed_at" IS NULL AND (id != 2) [["user_id", 1]]
14:43:06 web.1 | (0.3ms) SELECT COUNT(*) FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = $1 AND "spree_roles"."name" = 'admin' [["user_id", 1]]
14:43:06 web.1 | Spree::Product Load (0.7ms) SELECT "spree_products".* FROM "spree_products" WHERE "spree_products"."slug" = 'the-girls-short-sleeve-t-shirt' ORDER BY "spree_products"."id" ASC LIMIT 1
14:43:06 web.1 | Spree::Variant Exists (0.4ms) SELECT 1 AS one FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 'f' LIMIT 1 [["product_id", 8]]
14:43:06 web.1 | (0.4ms) SELECT COUNT(*) FROM "spree_stock_locations"
14:43:06 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/shared/_product_sub_menu.html.erb (23.3ms)
14:43:06 web.1 | Spree::Variant Load (0.4ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 't' LIMIT 1 [["product_id", 8]]
14:43:06 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/shared/_product_tabs.html.erb (46.5ms)
14:43:06 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/core/app/views/spree/shared/_error_messages.html.erb (0.6ms)
14:43:06 web.1 | Spree::StockLocation Load (0.5ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations"
14:43:06 web.1 | Spree::Variant Load (0.6ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 'f' ORDER BY "spree_variants".position ASC [["product_id", 8]]
14:43:06 web.1 | Spree::OptionValue Load (0.3ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 311]]
14:43:06 web.1 | Spree::OptionType Load (0.3ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | Spree::OptionType Load (0.3ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 312]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 313]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.3ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 314]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.5ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 315]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 316]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 317]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.5ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 318]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 319]]
14:43:06 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 320]]
14:43:06 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:06 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 321]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:06 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 322]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.6ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 287]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 288]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 289]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 290]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 291]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 292]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 293]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 294]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.6ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 295]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (1.2ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 296]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 297]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 298]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 299]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 300]]
14:43:07 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 301]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.3ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 302]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.5ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 303]]
14:43:07 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.7ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 304]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 305]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 306]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 307]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 308]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.5ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 309]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 310]]
14:43:07 web.1 | CACHE (0.1ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.3ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 323]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 324]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:07 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 325]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:07 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:08 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 326]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:08 web.1 | Spree::OptionValue Load (0.4ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 327]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:08 web.1 | Spree::OptionValue Load (0.5ms) SELECT "spree_option_values".* FROM "spree_option_values" INNER JOIN "spree_option_values_variants" ON "spree_option_values"."id" = "spree_option_values_variants"."option_value_id" WHERE "spree_option_values_variants"."variant_id" = $1 [["variant_id", 328]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" = $1 ORDER BY spree_option_types.position LIMIT 1 [["id", 2]]
14:43:08 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/products/_add_stock_form.html.erb (1447.4ms)
14:43:08 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 311]]
14:43:08 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 311], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | Spree::StockLocation Load (0.3ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | Spree::StockLocation Load (0.3ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | Spree::StockLocation Load (0.5ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 312]]
14:43:08 web.1 | Spree::Image Load (0.5ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 312], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 313]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 313], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (2.3ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 314]]
14:43:08 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 314], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 315]]
14:43:08 web.1 | Spree::Image Load (0.7ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 315], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 316]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 316], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 317]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 317], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.9ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 318]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 318], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 319]]
14:43:08 web.1 | Spree::Image Load (0.6ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 319], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 320]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 320], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 321]]
14:43:08 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 321], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.8ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 322]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 322], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 287]]
14:43:08 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 287], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.2ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 288]]
14:43:08 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 288], ["viewable_type", "Spree::Variant"]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:08 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:08 web.1 | Spree::StockItem Load (1.6ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 289]]
14:43:09 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 289], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (2.1ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 290]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 290], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.8ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 291]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 291], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.9ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 292]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 292], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 293]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 293], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.9ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 294]]
14:43:09 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 294], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.9ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 295]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 295], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.6ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 296]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 296], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 297]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 297], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 298]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 298], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 299]]
14:43:09 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 299], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 300]]
14:43:09 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 300], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (2.2ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 301]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 301], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (2.0ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 302]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 302], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (2.1ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 303]]
14:43:09 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 303], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.8ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 304]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 304], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:09 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 305]]
14:43:09 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 305], ["viewable_type", "Spree::Variant"]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:09 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 306]]
14:43:10 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 306], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.5ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 307]]
14:43:10 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 307], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 308]]
14:43:10 web.1 | Spree::Image Load (0.6ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 308], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 309]]
14:43:10 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 309], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.7ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 310]]
14:43:10 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 310], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (2.9ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 323]]
14:43:10 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 323], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (2.3ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 324]]
14:43:10 web.1 | Spree::Image Load (0.6ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 324], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (2.3ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 325]]
14:43:10 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 325], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.6ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 326]]
14:43:10 web.1 | Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 326], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.4ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 327]]
14:43:10 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 327], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Spree::StockItem Load (1.8ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = $1 [["variant_id", 328]]
14:43:10 web.1 | Spree::Image Load (0.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_id" = $1 AND "spree_assets"."viewable_type" = $2 ORDER BY "spree_assets"."position" ASC [["viewable_id", 328], ["viewable_type", "Spree::Variant"]]
14:43:10 web.1 | CACHE (0.1ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 1]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 7]]
14:43:10 web.1 | CACHE (0.0ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" = $1 LIMIT 1 [["id", 8]]
14:43:10 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/products/stock.html.erb within spree/layouts/admin (4122.7ms)
14:43:12 web.1 | Completed 200 OK in 6269ms (Views: 5782.3ms | ActiveRecord: 167.7ms)
```

After:

```sql
14:44:19 web.1 | Processing by Spree::Admin::ProductsController#stock as HTML
14:44:19 web.1 | Parameters: {"id"=>"the-girls-short-sleeve-t-shirt"}
14:44:19 web.1 | Spree::Preference Load (0.6ms) SELECT "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/backend_configuration/locale' LIMIT 1
14:44:19 web.1 | Spree::User Load (1.0ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."id" = 1 ORDER BY "spree_users"."id" ASC LIMIT 1
14:44:19 web.1 | Spree::Store Load (0.5ms) SELECT "spree_stores".* FROM "spree_stores" WHERE (url like '%localhost%') ORDER BY "spree_stores"."id" ASC LIMIT 1
14:44:19 web.1 | Spree::Store Load (0.5ms) SELECT "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = 't' ORDER BY "spree_stores"."id" ASC LIMIT 1
14:44:19 web.1 | Spree::Order Load (0.9ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = 'USD' AND "spree_orders"."guest_token" = 'I1834Yp4JKcP8v1JXl7V_g' AND "spree_orders"."store_id" = 1 AND "spree_orders"."user_id" = 1 LIMIT 1
14:44:19 web.1 | Spree::Order Load (0.4ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."completed_at" IS NULL AND "spree_orders"."user_id" = 1 ORDER BY created_at DESC LIMIT 1 [["user_id", 1]]
14:44:19 web.1 | Spree::Order Load (0.4ms) SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."completed_at" IS NULL AND (id != 2) [["user_id", 1]]
14:44:19 web.1 | (0.3ms) SELECT COUNT(*) FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = $1 AND "spree_roles"."name" = 'admin' [["user_id", 1]]
14:44:19 web.1 | Spree::Product Load (0.7ms) SELECT "spree_products".* FROM "spree_products" WHERE "spree_products"."slug" = 'the-girls-short-sleeve-t-shirt' ORDER BY "spree_products"."id" ASC LIMIT 1
14:44:19 web.1 | (0.4ms) SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 'f' [["product_id", 8]]
14:44:19 web.1 | (0.4ms) SELECT COUNT(*) FROM "spree_stock_locations"
14:44:19 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/shared/_product_sub_menu.html.erb (29.4ms)
14:44:19 web.1 | Spree::Variant Load (0.4ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 't' LIMIT 1 [["product_id", 8]]
14:44:19 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/shared/_product_tabs.html.erb (49.4ms)
14:44:19 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/core/app/views/spree/shared/_error_messages.html.erb (0.3ms)
14:44:19 web.1 | Spree::StockLocation Load (0.5ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations"
14:44:19 web.1 | Spree::Variant Load (0.5ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."is_master" = 'f' ORDER BY "spree_variants".position ASC [["product_id", 8]]
14:44:19 web.1 | Spree::Image Load (1.2ms) 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 (311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 323, 324, 325, 326, 327, 328) ORDER BY "spree_assets"."position" ASC
14:44:19 web.1 | Spree::StockItem Load (6.1ms) SELECT "spree_stock_items".* FROM "spree_stock_items" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" IN (311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 323, 324, 325, 326, 327, 328)
14:44:20 web.1 | Spree::StockLocation Load (0.7ms) SELECT "spree_stock_locations".* FROM "spree_stock_locations" WHERE "spree_stock_locations"."id" IN (1, 7, 8)
14:44:20 web.1 | HABTM_OptionValues Load (1.0ms) SELECT "spree_option_values_variants".* FROM "spree_option_values_variants" WHERE "spree_option_values_variants"."variant_id" IN (311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 323, 324, 325, 326, 327, 328)
14:44:20 web.1 | Spree::OptionValue Load (0.6ms) SELECT "spree_option_values".* FROM "spree_option_values" WHERE "spree_option_values"."id" IN (26, 4, 27, 28, 29, 14, 5, 16, 25, 6, 1, 2, 3)
14:44:20 web.1 | Spree::OptionType Load (0.6ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" IN (1, 2) ORDER BY spree_option_types.position
14:44:20 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/products/_add_stock_form.html.erb (585.1ms)
14:44:20 web.1 | Rendered /Users/benmorgan/.rvm/gems/ruby-2.1.5/bundler/gems/spree-2199541a7ee0/backend/app/views/spree/admin/products/stock.html.erb within spree/layouts/admin (1354.9ms)
14:44:22 web.1 | Completed 200 OK in 3343ms (Views: 2946.4ms | ActiveRecord: 67.7ms)
```