Created
February 24, 2015 15:35
-
-
Save gmacdougall/c97c5836ed65b1c25769 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Started GET "/api/products?token=e3b20b6dad8521135961c839e4a27877567c303b9460470a" for 10.0.0.231 at 2015-02-24 10:34:43 -0500 | |
| [1m[36mActiveRecord::SchemaMigration Load (0.6ms)[0m [1mSELECT "schema_migrations".* FROM "schema_migrations"[0m | |
| Processing by Spree::Api::ProductsController#index as JSON | |
| Parameters: {"token"=>"e3b20b6dad8521135961c839e4a27877567c303b9460470a"} | |
| [1m[35mSpree::User Load (0.9ms)[0m SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."spree_api_key" = $1 LIMIT 1 [["spree_api_key", "e3b20b6dad8521135961c839e4a27877567c303b9460470a"]] | |
| [1m[36m (0.9ms)[0m [1mSELECT "spree_roles"."name" FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = $1[0m [["user_id", 1]] | |
| [1m[35m (0.8ms)[0m 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" = $2 [["user_id", 1], ["name", "admin"]] | |
| [1m[36m (1.4ms)[0m [1mSELECT COUNT(DISTINCT count_column) FROM (SELECT DISTINCT "spree_products"."id" AS count_column FROM "spree_products" WHERE ("spree_products".deleted_at IS NULL or "spree_products".deleted_at >= '2015-02-24 15:34:43.709068') LIMIT 25 OFFSET 0) subquery_for_count[0m | |
| [1m[35m (1.1ms)[0m SELECT DISTINCT COUNT(DISTINCT "spree_products"."id") FROM "spree_products" WHERE ("spree_products".deleted_at IS NULL or "spree_products".deleted_at >= '2015-02-24 15:34:43.709068') | |
| [1m[36mSpree::Product Load (1.4ms)[0m [1mSELECT DISTINCT "spree_products".* FROM "spree_products" WHERE ("spree_products".deleted_at IS NULL or "spree_products".deleted_at >= '2015-02-24 15:34:43.709068') LIMIT 25 OFFSET 0[0m | |
| [1m[35mSpree::ProductOptionType Load (1.3ms)[0m SELECT "spree_product_option_types".* FROM "spree_product_option_types" WHERE "spree_product_option_types"."product_id" IN (9, 13, 15, 3, 4, 11, 8, 7, 10, 1, 5, 14, 6, 12, 2, 16) | |
| [1m[36mSpree::OptionType Load (1.2ms)[0m [1mSELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" IN (1, 2) ORDER BY spree_option_types.position[0m | |
| [1m[35mSpree::Classification Load (1.2ms)[0m SELECT "spree_products_taxons".* FROM "spree_products_taxons" WHERE "spree_products_taxons"."product_id" IN (9, 13, 15, 3, 4, 11, 8, 7, 10, 1, 5, 14, 6, 12, 2, 16) | |
| [1m[36mSpree::Taxon Load (1.3ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" IN (6, 10, 4, 11, 7, 3, 9, 8)[0m | |
| [1m[35mSpree::ProductProperty Load (1.4ms)[0m SELECT "spree_product_properties".* FROM "spree_product_properties" WHERE "spree_product_properties"."product_id" IN (9, 13, 15, 3, 4, 11, 8, 7, 10, 1, 5, 14, 6, 12, 2, 16) ORDER BY spree_product_properties.position | |
| [1m[36mSpree::Property Load (1.3ms)[0m [1mSELECT "spree_properties".* FROM "spree_properties" WHERE "spree_properties"."id" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)[0m | |
| [1m[35mSpree::Variant Load (1.5ms)[0m SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = 'f' AND "spree_variants"."product_id" IN (9, 13, 15, 3, 4, 11, 8, 7, 10, 1, 5, 14, 6, 12, 2, 16) ORDER BY "spree_variants".position ASC | |
| [1m[36mHABTM_OptionValues Load (1.3ms)[0m [1mSELECT "spree_option_values_variants".* FROM "spree_option_values_variants" WHERE "spree_option_values_variants"."variant_id" IN (17, 18, 19, 20, 21, 22, 23, 24, 25, 26)[0m | |
| [1m[35mSpree::OptionValue Load (1.3ms)[0m SELECT "spree_option_values".* FROM "spree_option_values" WHERE "spree_option_values"."id" IN (1, 5, 7, 6, 2, 3, 4) | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" IN (1, 2) ORDER BY spree_option_types.position[0m | |
| [1m[35mSpree::Price Load (1.3ms)[0m SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."deleted_at" IS NULL AND "spree_prices"."currency" = $1 AND "spree_prices"."variant_id" IN (17, 18, 19, 20, 21, 22, 23, 24, 25, 26) [["currency", "USD"]] | |
| [1m[36mSpree::Image Load (1.5ms)[0m [1mSELECT "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 (17, 18, 19, 20, 21, 22, 23, 24, 25, 26) ORDER BY "spree_assets"."position" ASC[0m | |
| [1m[35mSpree::Variant Load (1.3ms)[0m SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."is_master" = 't' AND "spree_variants"."product_id" IN (9, 13, 15, 3, 4, 11, 8, 7, 10, 1, 5, 14, 6, 12, 2, 16) | |
| [1m[36mHABTM_OptionValues Load (1.2ms)[0m [1mSELECT "spree_option_values_variants".* FROM "spree_option_values_variants" WHERE "spree_option_values_variants"."variant_id" IN (1, 2, 3, 4, 13, 5, 14, 7, 6, 12, 11, 10, 9, 8, 15, 16)[0m | |
| [1m[35mSpree::Price Load (1.2ms)[0m SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."deleted_at" IS NULL AND "spree_prices"."currency" = $1 AND "spree_prices"."variant_id" IN (1, 2, 3, 4, 13, 5, 14, 7, 6, 12, 11, 10, 9, 8, 15, 16) [["currency", "USD"]] | |
| [1m[36mSpree::Image Load (1.4ms)[0m [1mSELECT "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 (1, 2, 3, 4, 13, 5, 14, 7, 6, 12, 11, 10, 9, 8, 15, 16) ORDER BY "spree_assets"."position" ASC[0m | |
| [1m[35m (1.0ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 9]] | |
| [1m[36m (1.4ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 9]] | |
| [1m[35mSpree::StockItem Load (1.3ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 9 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.5ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 9 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::Taxon Load (1.4ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 7) AND ("spree_taxons"."rgt" >= 8) AND ("spree_taxons"."id" != 6) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.2ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft"[0m [["parent_id", 6]] | |
| [1m[35mSpree::Taxon Load (1.3ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.6ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft"[0m [["parent_id", 10]] | |
| [1m[35m (1.9ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 13]] | |
| [1m[36m (1.9ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 13]] | |
| [1m[35mSpree::StockItem Load (2.1ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 13 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (2.1ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 13 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::Taxon Load (1.4ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 4) AND ("spree_taxons"."rgt" >= 5) AND ("spree_taxons"."id" != 4) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.2ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft"[0m [["parent_id", 4]] | |
| [1m[35mSpree::Taxon Load (1.3ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.2ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft"[0m [["parent_id", 11]] | |
| [1m[35m (1.1ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 15]] | |
| [1m[36m (1.1ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 15]] | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 15 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 15 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 4) AND ("spree_taxons"."rgt" >= 5) AND ("spree_taxons"."id" != 4) ORDER BY "spree_taxons"."lft" | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35m (1.2ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 3]] | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 3]] | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 3 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.4ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 3 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.3ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 17 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 17 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 18 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.2ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 18 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 19 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 19 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.5ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 20 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 20 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (2.9ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 21 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.6ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 21 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 22 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.4ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 22 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.5ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 23 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.4ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 23 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 24 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.4ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 24 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 25 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 25 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::StockItem Load (1.5ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 26 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 26 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mSpree::Taxon Load (1.2ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 9) AND ("spree_taxons"."rgt" >= 10) AND ("spree_taxons"."id" != 7) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.2ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft"[0m [["parent_id", 7]] | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft" | |
| [1m[36m (1.2ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 4]] | |
| [1m[35m (1.4ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 4]] | |
| [1m[36mSpree::StockItem Load (1.4ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 4 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.3ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 4 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 7) AND ("spree_taxons"."rgt" >= 8) AND ("spree_taxons"."id" != 6) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft" | |
| [1m[36m (1.1ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 11]] | |
| [1m[35m (1.2ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 11]] | |
| [1m[36mSpree::StockItem Load (1.4ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 11 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.3ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 11 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mSpree::Taxon Load (1.3ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) AND ("spree_taxons"."id" != 3) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mSpree::Taxon Load (1.5ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 3]] | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35m (1.0ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 8]] | |
| [1m[36m (0.9ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 8]] | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 8 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 8 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 9) AND ("spree_taxons"."rgt" >= 10) AND ("spree_taxons"."id" != 7) ORDER BY "spree_taxons"."lft" | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35m (1.0ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 7]] | |
| [1m[36m (0.9ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 7]] | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 7 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 7 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 9) AND ("spree_taxons"."rgt" >= 10) AND ("spree_taxons"."id" != 7) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.3ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 16) AND ("spree_taxons"."rgt" >= 17) AND ("spree_taxons"."id" != 9) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mSpree::Taxon Load (1.1ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 9]] | |
| [1m[36m (0.9ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 10]] | |
| [1m[35m (0.9ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 10]] | |
| [1m[36mSpree::StockItem Load (1.3ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 10 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.2ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 10 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 9) AND ("spree_taxons"."rgt" >= 10) AND ("spree_taxons"."id" != 7) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft" | |
| [1m[36m (1.0ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 1]] | |
| [1m[35m (0.9ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 1]] | |
| [1m[36mSpree::StockItem Load (1.3ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 1 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.2ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 1 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) AND ("spree_taxons"."id" != 3) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft" | |
| [1m[36m (1.0ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 5]] | |
| [1m[35m (0.9ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 5]] | |
| [1m[36mSpree::StockItem Load (1.4ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 5 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.3ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 5 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 9) AND ("spree_taxons"."rgt" >= 10) AND ("spree_taxons"."id" != 7) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft" | |
| [1m[36m (1.0ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 14]] | |
| [1m[35m (1.0ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 14]] | |
| [1m[36mSpree::StockItem Load (1.4ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 14 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.3ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 14 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 4) AND ("spree_taxons"."rgt" >= 5) AND ("spree_taxons"."id" != 4) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft" | |
| [1m[36m (1.0ms)[0m [1mSELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f'[0m [["product_id", 6]] | |
| [1m[35m (1.0ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 [["product_id", 6]] | |
| [1m[36mSpree::StockItem Load (1.8ms)[0m [1mSELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 6 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35m (1.3ms)[0m SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 6 AND "spree_stock_locations"."active" = 't' | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 9) AND ("spree_taxons"."rgt" >= 10) AND ("spree_taxons"."id" != 7) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35mSpree::Taxon Load (1.3ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 14) AND ("spree_taxons"."rgt" >= 15) AND ("spree_taxons"."id" != 8) ORDER BY "spree_taxons"."lft" | |
| [1m[36mSpree::Taxon Load (1.1ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft"[0m [["parent_id", 8]] | |
| [1m[35m (1.0ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 12]] | |
| [1m[36m (0.9ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 12]] | |
| [1m[35mSpree::StockItem Load (1.3ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 12 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.2ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 12 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) AND ("spree_taxons"."id" != 3) ORDER BY "spree_taxons"."lft" | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35m (0.9ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 2]] | |
| [1m[36m (0.9ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 2]] | |
| [1m[35mSpree::StockItem Load (2.0ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 2 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.3ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 2 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) AND ("spree_taxons"."id" != 3) ORDER BY "spree_taxons"."lft" | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) AND ("spree_taxons"."id" != 11) ORDER BY "spree_taxons"."lft"[0m | |
| [1m[35m (1.0ms)[0m SELECT COUNT(*) FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1 AND "spree_variants"."track_inventory" = 'f' [["product_id", 16]] | |
| [1m[36m (1.0ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_variants" ON "spree_stock_items"."variant_id" = "spree_variants"."id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_variants"."deleted_at" IS NULL AND "spree_variants"."product_id" = $1[0m [["product_id", 16]] | |
| [1m[35mSpree::StockItem Load (1.4ms)[0m SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 16 AND "spree_stock_locations"."active" = 't' | |
| [1m[36m (1.7ms)[0m [1mSELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 16 AND "spree_stock_locations"."active" = 't'[0m | |
| [1m[35mCACHE (0.0ms)[0m SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 4) AND ("spree_taxons"."rgt" >= 5) AND ("spree_taxons"."id" != 4) ORDER BY "spree_taxons"."lft" | |
| [1m[36mCACHE (0.0ms)[0m [1mSELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 18) AND ("spree_taxons"."rgt" >= 19) AND ("spree_taxons"."id" != 10) ORDER BY "spree_taxons"."lft"[0m | |
| Rendered /home/gregor/dev/spree/api/app/views/spree/api/products/index.v1.rabl (2635.5ms) | |
| Completed 200 OK in 2838ms (Views: 2560.2ms | ActiveRecord: 203.1ms) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment