Created
February 24, 2015 15:35
-
-
Save gmacdougall/d9c3145884fa5c2146fd to your computer and use it in GitHub Desktop.
This file contains 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 | |
| ActiveRecord::SchemaMigration Load (0.6ms) SELECT "schema_migrations".* FROM "schema_migrations" | |
| Processing by Spree::Api::ProductsController#index as JSON | |
| Parameters: {"token"=>"e3b20b6dad8521135961c839e4a27877567c303b9460470a"} | |
| Spree::User Load (0.9ms) 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"]] | |
| (0.9ms) SELECT "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 [["user_id", 1]] | |
| (0.8ms) 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"]] | |
| (1.4ms) SELECT 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 | |
| (1.1ms) 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') | |
| Spree::Product Load (1.4ms) SELECT 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 | |
| Spree::ProductOptionType Load (1.3ms) 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) | |
| Spree::OptionType Load (1.2ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" IN (1, 2) ORDER BY spree_option_types.position | |
| Spree::Classification Load (1.2ms) 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) | |
| Spree::Taxon Load (1.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" IN (6, 10, 4, 11, 7, 3, 9, 8) | |
| Spree::ProductProperty Load (1.4ms) 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 | |
| Spree::Property Load (1.3ms) SELECT "spree_properties".* FROM "spree_properties" WHERE "spree_properties"."id" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11) | |
| Spree::Variant Load (1.5ms) 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 | |
| HABTM_OptionValues Load (1.3ms) SELECT "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) | |
| Spree::OptionValue Load (1.3ms) SELECT "spree_option_values".* FROM "spree_option_values" WHERE "spree_option_values"."id" IN (1, 5, 7, 6, 2, 3, 4) | |
| CACHE (0.0ms) SELECT "spree_option_types".* FROM "spree_option_types" WHERE "spree_option_types"."id" IN (1, 2) ORDER BY spree_option_types.position | |
| Spree::Price Load (1.3ms) 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"]] | |
| Spree::Image Load (1.5ms) 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 (17, 18, 19, 20, 21, 22, 23, 24, 25, 26) ORDER BY "spree_assets"."position" ASC | |
| Spree::Variant Load (1.3ms) 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) | |
| HABTM_OptionValues Load (1.2ms) SELECT "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) | |
| Spree::Price Load (1.2ms) 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"]] | |
| Spree::Image Load (1.4ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."viewable_type" = 'Spree::Variant' AND "spree_assets"."viewable_id" IN (1, 2, 3, 4, 13, 5, 14, 7, 6, 12, 11, 10, 9, 8, 15, 16) ORDER BY "spree_assets"."position" ASC | |
| (1.0ms) 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]] | |
| (1.4ms) 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", 9]] | |
| Spree::StockItem Load (1.3ms) 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' | |
| (1.5ms) 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" = 9 AND "spree_stock_locations"."active" = 't' | |
| Spree::Taxon Load (1.4ms) 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" | |
| Spree::Taxon Load (1.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 6]] | |
| Spree::Taxon Load (1.3ms) 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" | |
| Spree::Taxon Load (1.6ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 10]] | |
| (1.9ms) 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]] | |
| (1.9ms) 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", 13]] | |
| Spree::StockItem Load (2.1ms) 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' | |
| (2.1ms) 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" = 13 AND "spree_stock_locations"."active" = 't' | |
| Spree::Taxon Load (1.4ms) 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" | |
| Spree::Taxon Load (1.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 4]] | |
| Spree::Taxon Load (1.3ms) 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" | |
| Spree::Taxon Load (1.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 11]] | |
| (1.1ms) 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]] | |
| (1.1ms) 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", 15]] | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.3ms) 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" = 15 AND "spree_stock_locations"."active" = 't' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.2ms) 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]] | |
| (1.3ms) 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", 3]] | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.4ms) 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" = 3 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.3ms) 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' | |
| (1.3ms) 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" = 17 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.2ms) 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" = 18 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.3ms) 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" = 19 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.5ms) 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' | |
| (1.3ms) 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" = 20 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (2.9ms) 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' | |
| (1.6ms) 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" = 21 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.4ms) 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" = 22 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.5ms) 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' | |
| (1.4ms) 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" = 23 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.4ms) 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" = 24 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.3ms) 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" = 25 AND "spree_stock_locations"."active" = 't' | |
| Spree::StockItem Load (1.5ms) 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' | |
| (1.3ms) 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" = 26 AND "spree_stock_locations"."active" = 't' | |
| Spree::Taxon Load (1.2ms) 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" | |
| Spree::Taxon Load (1.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 7]] | |
| CACHE (0.0ms) 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" | |
| (1.2ms) 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", 4]] | |
| (1.4ms) 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]] | |
| Spree::StockItem Load (1.4ms) 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" = 4 AND "spree_stock_locations"."active" = 't' | |
| (1.3ms) 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' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.1ms) 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", 11]] | |
| (1.2ms) 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]] | |
| Spree::StockItem Load (1.4ms) 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" = 11 AND "spree_stock_locations"."active" = 't' | |
| (1.3ms) 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' | |
| Spree::Taxon Load (1.3ms) 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" | |
| Spree::Taxon Load (1.5ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 3]] | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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]] | |
| (0.9ms) 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", 8]] | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.3ms) 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" = 8 AND "spree_stock_locations"."active" = 't' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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]] | |
| (0.9ms) 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", 7]] | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.3ms) 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" = 7 AND "spree_stock_locations"."active" = 't' | |
| CACHE (0.0ms) 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" | |
| Spree::Taxon Load (1.3ms) SELECT "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" | |
| Spree::Taxon Load (1.1ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 9]] | |
| (0.9ms) 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", 10]] | |
| (0.9ms) 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]] | |
| Spree::StockItem Load (1.3ms) 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" = 10 AND "spree_stock_locations"."active" = 't' | |
| (1.2ms) 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' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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", 1]] | |
| (0.9ms) 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]] | |
| Spree::StockItem Load (1.3ms) 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" = 1 AND "spree_stock_locations"."active" = 't' | |
| (1.2ms) 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' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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", 5]] | |
| (0.9ms) 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]] | |
| Spree::StockItem Load (1.4ms) 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" = 5 AND "spree_stock_locations"."active" = 't' | |
| (1.3ms) 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' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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", 14]] | |
| (1.0ms) 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]] | |
| Spree::StockItem Load (1.4ms) 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" = 14 AND "spree_stock_locations"."active" = 't' | |
| (1.3ms) 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' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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", 6]] | |
| (1.0ms) 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]] | |
| Spree::StockItem Load (1.8ms) 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" = 6 AND "spree_stock_locations"."active" = 't' | |
| (1.3ms) 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' | |
| CACHE (0.0ms) 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" | |
| Spree::Taxon Load (1.3ms) 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" | |
| Spree::Taxon Load (1.1ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "lft" [["parent_id", 8]] | |
| (1.0ms) 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]] | |
| (0.9ms) 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", 12]] | |
| Spree::StockItem Load (1.3ms) 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' | |
| (1.2ms) 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" = 12 AND "spree_stock_locations"."active" = 't' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (0.9ms) 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]] | |
| (0.9ms) 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", 2]] | |
| Spree::StockItem Load (2.0ms) 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' | |
| (1.3ms) 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" = 2 AND "spree_stock_locations"."active" = 't' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| (1.0ms) 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]] | |
| (1.0ms) 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", 16]] | |
| Spree::StockItem Load (1.4ms) 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' | |
| (1.7ms) 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" = 16 AND "spree_stock_locations"."active" = 't' | |
| CACHE (0.0ms) 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" | |
| CACHE (0.0ms) 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" | |
| 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