huoxito · August 6, 2014 03:27
diff --git a/product.destroy.sql b/product.destroy.sql
  FriendlyId::Slug Load (0.8ms)  SELECT "friendly_id_slugs".* FROM "friendly_id_slugs"  WHERE "friendly_id_slugs"."sluggable_id" = $1 AND "friendly_id_slugs"."sluggable_type" = $2  ORDER BY "friendly_id_slugs".id DESC  [["sluggable_id", 1], ["sluggable_type", "Spree::Product"]]
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."id" = $1  [["id", 17]]
  SQL (0.2ms)  DELETE FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."id" = $1  [["id", 1]]
   (0.4ms)  COMMIT
  Spree::ProductOptionType Load (0.6ms)  SELECT "spree_product_option_types".* FROM "spree_product_option_types"  WHERE "spree_product_option_types"."product_id" = $1  [["product_id", 1]]
  Spree::ProductProperty Load (0.6ms)  SELECT "spree_product_properties".* FROM "spree_product_properties"  WHERE "spree_product_properties"."product_id" = $1  ORDER BY spree_product_properties.position  [["product_id", 1]]
   (0.1ms)  BEGIN
  SQL (0.2ms)  DELETE FROM "spree_product_properties" WHERE "spree_product_properties"."id" = $1  [["id", 25]]
  SQL (0.3ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.046239' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.9ms)  SELECT "spree_taxons".* FROM "spree_taxons" INNER JOIN "spree_products_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products_taxons"."product_id" = $1  [["product_id", 1]]
  Spree::Taxon Load (0.5ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.3ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.076032' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.5ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.079290' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.2ms)  DELETE FROM "spree_product_properties" WHERE "spree_product_properties"."id" = $1  [["id", 26]]
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.082585' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.2ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.085028' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.085780' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.2ms)  DELETE FROM "spree_product_properties" WHERE "spree_product_properties"."id" = $1  [["id", 27]]
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.087082' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.2ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.089248' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.089966' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
   (0.4ms)  COMMIT
  SQL (0.4ms)  DELETE FROM "spree_products_taxons" WHERE "spree_products_taxons"."product_id" = $1  [["product_id", 1]]
   (0.1ms)  BEGIN
  Spree::StockItem Load (0.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", 1]]
  SQL (0.5ms)  UPDATE "spree_stock_items" SET "updated_at" = '2014-08-06 03:24:42.106443', "deleted_at" = '2014-08-06 03:24:42.106443' WHERE "spree_stock_items"."id" = 1
  SQL (0.3ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.107888' WHERE "spree_variants"."id" = 1
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.108805' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.111143' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.111950' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  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", 1], ["viewable_type", "Spree::Variant"]]
  Spree::Image Load (0.3ms)  SELECT  "spree_assets".* FROM "spree_assets"  WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1 LIMIT 1  [["id", 21]]
  SQL (0.3ms)  DELETE FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1  [["id", 21]]
  Spree::Variant Load (0.3ms)  SELECT  "spree_variants".* FROM "spree_variants"  WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."id" = $1 LIMIT 1  [["id", 1]]
  SQL (0.4ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.140948' WHERE "spree_variants"."id" = 1
  Spree::Product Load (0.2ms)  SELECT  "spree_products".* FROM "spree_products"  WHERE "spree_products"."id" = $1 LIMIT 1  [["id", 1]]
  SQL (0.3ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.143835' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.4ms)  SELECT "spree_taxons".* FROM "spree_taxons" INNER JOIN "spree_products_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products_taxons"."product_id" = $1  [["product_id", 1]]
  SQL (0.3ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.146653' WHERE 1=0
  SQL (0.4ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.147722' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE 1=0  ORDER BY spree_taxonomies.position)
  SQL (0.3ms)  UPDATE "spree_assets" SET position = (position - 1) WHERE ("spree_assets"."viewable_id" = 1 AND position > 1)
  Spree::Image Load (0.2ms)  SELECT  "spree_assets".* FROM "spree_assets"  WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1 LIMIT 1  [["id", 22]]
  SQL (0.2ms)  DELETE FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1  [["id", 22]]
  Spree::Variant Load (0.3ms)  SELECT  "spree_variants".* FROM "spree_variants"  WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."id" = $1 LIMIT 1  [["id", 1]]
  SQL (0.2ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.155311' WHERE "spree_variants"."id" = 1
  Spree::Product Load (0.2ms)  SELECT  "spree_products".* FROM "spree_products"  WHERE "spree_products"."id" = $1 LIMIT 1  [["id", 1]]
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.157061' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons" INNER JOIN "spree_products_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products_taxons"."product_id" = $1  [["product_id", 1]]
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.158945' WHERE 1=0
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.159698' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE 1=0  ORDER BY spree_taxonomies.position)
  SQL (0.2ms)  UPDATE "spree_assets" SET position = (position - 1) WHERE ("spree_assets"."viewable_id" = 1 AND position > 1)
  Spree::Price Load (0.7ms)  SELECT "spree_prices".* FROM "spree_prices"  WHERE "spree_prices"."deleted_at" IS NULL AND "spree_prices"."variant_id" = $1  [["variant_id", 1]]
  SQL (0.4ms)  UPDATE "spree_prices" SET "deleted_at" = '2014-08-06 03:24:42.174559' WHERE "spree_prices"."id" = 1
  SQL (0.3ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.175750' WHERE "spree_variants"."id" = 1
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.176676' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.2ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.179263' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.180063' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.2ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.180945' WHERE "spree_variants"."id" = 1
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.181630' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.2ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.183830' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.184544' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.5ms)  UPDATE "spree_prices" SET "deleted_at" = '2014-08-06 03:24:42.185357' WHERE "spree_prices"."id" = 2
  SQL (0.3ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.186665' WHERE "spree_variants"."id" = 1
  SQL (0.3ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.187770' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.3ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.190784' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.4ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.191762' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.3ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.192884' WHERE "spree_variants"."id" = 1
  SQL (0.3ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.193825' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.196476' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.7ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.197294' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.5ms)  UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.198917', "deleted_at" = '2014-08-06 03:24:42.198917' WHERE "spree_variants"."id" = 1
  SQL (0.5ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.200749' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.5ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.3ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.204685' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.205708' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
  SQL (0.2ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.206568' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.3ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.2ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.2ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.208711' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.209441' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
   (8.6ms)  COMMIT
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/original/ror_tote.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/mini/ror_tote.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/small/ror_tote.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/product/ror_tote.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/large/ror_tote.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/original/ror_tote_back.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/mini/ror_tote_back.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/small/ror_tote_back.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/product/ror_tote_back.jpeg
 [paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/large/ror_tote_back.jpeg
   (0.1ms)  BEGIN
  SQL (0.4ms)  UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.222851', "deleted_at" = '2014-08-06 03:24:42.222851' WHERE "spree_products"."id" = 1
  Spree::Taxon Load (0.5ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3)  ORDER BY "spree_taxons"."lft"
  Spree::Taxon Load (0.2ms)  SELECT "spree_taxons".* FROM "spree_taxons"  WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21)  ORDER BY "spree_taxons"."lft"
  SQL (0.3ms)  UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.226030' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
  SQL (0.3ms)  UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.226891' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies"  WHERE "spree_taxonomies"."id" IN (1, 2)  ORDER BY spree_taxonomies.position)
   (6.1ms)  COMMIT
  SQL (6.5ms)  UPDATE "spree_products" SET "slug" = '1407295482_ruby-on-rails-tote' WHERE "spree_products"."id" = 1
	FriendlyId::Slug Load (0.8ms) SELECT "friendly_id_slugs".* FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."sluggable_id" = $1 AND "friendly_id_slugs"."sluggable_type" = $2 ORDER BY "friendly_id_slugs".id DESC [["sluggable_id", 1], ["sluggable_type", "Spree::Product"]]
	(0.1ms) BEGIN
	SQL (0.2ms) DELETE FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."id" = $1 [["id", 17]]
	SQL (0.2ms) DELETE FROM "friendly_id_slugs" WHERE "friendly_id_slugs"."id" = $1 [["id", 1]]
	(0.4ms) COMMIT
	Spree::ProductOptionType Load (0.6ms) SELECT "spree_product_option_types".* FROM "spree_product_option_types" WHERE "spree_product_option_types"."product_id" = $1 [["product_id", 1]]
	Spree::ProductProperty Load (0.6ms) SELECT "spree_product_properties".* FROM "spree_product_properties" WHERE "spree_product_properties"."product_id" = $1 ORDER BY spree_product_properties.position [["product_id", 1]]
	(0.1ms) BEGIN
	SQL (0.2ms) DELETE FROM "spree_product_properties" WHERE "spree_product_properties"."id" = $1 [["id", 25]]
	SQL (0.3ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.046239' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.9ms) SELECT "spree_taxons".* FROM "spree_taxons" INNER JOIN "spree_products_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products_taxons"."product_id" = $1 [["product_id", 1]]
	Spree::Taxon Load (0.5ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.3ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.076032' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.5ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.079290' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.2ms) DELETE FROM "spree_product_properties" WHERE "spree_product_properties"."id" = $1 [["id", 26]]
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.082585' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.085028' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.085780' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.2ms) DELETE FROM "spree_product_properties" WHERE "spree_product_properties"."id" = $1 [["id", 27]]
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.087082' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.089248' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.089966' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	(0.4ms) COMMIT
	SQL (0.4ms) DELETE FROM "spree_products_taxons" WHERE "spree_products_taxons"."product_id" = $1 [["product_id", 1]]
	(0.1ms) BEGIN
	Spree::StockItem Load (0.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", 1]]
	SQL (0.5ms) UPDATE "spree_stock_items" SET "updated_at" = '2014-08-06 03:24:42.106443', "deleted_at" = '2014-08-06 03:24:42.106443' WHERE "spree_stock_items"."id" = 1
	SQL (0.3ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.107888' WHERE "spree_variants"."id" = 1
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.108805' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.111143' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.111950' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	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", 1], ["viewable_type", "Spree::Variant"]]
	Spree::Image Load (0.3ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1 LIMIT 1 [["id", 21]]
	SQL (0.3ms) DELETE FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1 [["id", 21]]
	Spree::Variant Load (0.3ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."id" = $1 LIMIT 1 [["id", 1]]
	SQL (0.4ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.140948' WHERE "spree_variants"."id" = 1
	Spree::Product Load (0.2ms) SELECT "spree_products".* FROM "spree_products" WHERE "spree_products"."id" = $1 LIMIT 1 [["id", 1]]
	SQL (0.3ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.143835' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.4ms) SELECT "spree_taxons".* FROM "spree_taxons" INNER JOIN "spree_products_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products_taxons"."product_id" = $1 [["product_id", 1]]
	SQL (0.3ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.146653' WHERE 1=0
	SQL (0.4ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.147722' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE 1=0 ORDER BY spree_taxonomies.position)
	SQL (0.3ms) UPDATE "spree_assets" SET position = (position - 1) WHERE ("spree_assets"."viewable_id" = 1 AND position > 1)
	Spree::Image Load (0.2ms) SELECT "spree_assets".* FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1 LIMIT 1 [["id", 22]]
	SQL (0.2ms) DELETE FROM "spree_assets" WHERE "spree_assets"."type" IN ('Spree::Image') AND "spree_assets"."id" = $1 [["id", 22]]
	Spree::Variant Load (0.3ms) SELECT "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."deleted_at" IS NULL AND "spree_variants"."id" = $1 LIMIT 1 [["id", 1]]
	SQL (0.2ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.155311' WHERE "spree_variants"."id" = 1
	Spree::Product Load (0.2ms) SELECT "spree_products".* FROM "spree_products" WHERE "spree_products"."id" = $1 LIMIT 1 [["id", 1]]
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.157061' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" INNER JOIN "spree_products_taxons" ON "spree_taxons"."id" = "spree_products_taxons"."taxon_id" WHERE "spree_products_taxons"."product_id" = $1 [["product_id", 1]]
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.158945' WHERE 1=0
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.159698' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE 1=0 ORDER BY spree_taxonomies.position)
	SQL (0.2ms) UPDATE "spree_assets" SET position = (position - 1) WHERE ("spree_assets"."viewable_id" = 1 AND position > 1)
	Spree::Price Load (0.7ms) SELECT "spree_prices".* FROM "spree_prices" WHERE "spree_prices"."deleted_at" IS NULL AND "spree_prices"."variant_id" = $1 [["variant_id", 1]]
	SQL (0.4ms) UPDATE "spree_prices" SET "deleted_at" = '2014-08-06 03:24:42.174559' WHERE "spree_prices"."id" = 1
	SQL (0.3ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.175750' WHERE "spree_variants"."id" = 1
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.176676' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.179263' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.180063' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.2ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.180945' WHERE "spree_variants"."id" = 1
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.181630' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.183830' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.184544' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.5ms) UPDATE "spree_prices" SET "deleted_at" = '2014-08-06 03:24:42.185357' WHERE "spree_prices"."id" = 2
	SQL (0.3ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.186665' WHERE "spree_variants"."id" = 1
	SQL (0.3ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.187770' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.3ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.190784' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.4ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.191762' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.3ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.192884' WHERE "spree_variants"."id" = 1
	SQL (0.3ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.193825' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.196476' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.7ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.197294' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.5ms) UPDATE "spree_variants" SET "updated_at" = '2014-08-06 03:24:42.198917', "deleted_at" = '2014-08-06 03:24:42.198917' WHERE "spree_variants"."id" = 1
	SQL (0.5ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.200749' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.5ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.3ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.204685' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.205708' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	SQL (0.2ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.206568' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.3ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.2ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.208711' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.209441' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	(8.6ms) COMMIT
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/original/ror_tote.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/mini/ror_tote.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/small/ror_tote.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/product/ror_tote.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/21/large/ror_tote.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/original/ror_tote_back.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/mini/ror_tote_back.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/small/ror_tote_back.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/product/ror_tote_back.jpeg
	[paperclip] deleting /Users/huoxito/coding/spree-sandbox-edge/public/spree/products/22/large/ror_tote_back.jpeg
	(0.1ms) BEGIN
	SQL (0.4ms) UPDATE "spree_products" SET "updated_at" = '2014-08-06 03:24:42.222851', "deleted_at" = '2014-08-06 03:24:42.222851' WHERE "spree_products"."id" = 1
	Spree::Taxon Load (0.5ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 2) AND ("spree_taxons"."rgt" >= 3) ORDER BY "spree_taxons"."lft"
	Spree::Taxon Load (0.2ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 20) AND ("spree_taxons"."rgt" >= 21) ORDER BY "spree_taxons"."lft"
	SQL (0.3ms) UPDATE "spree_taxons" SET "updated_at" = '2014-08-06 03:24:42.226030' WHERE "spree_taxons"."id" IN (1, 3, 2, 11)
	SQL (0.3ms) UPDATE "spree_taxonomies" SET "updated_at" = '2014-08-06 03:24:42.226891' WHERE "spree_taxonomies"."id" IN (SELECT "spree_taxonomies"."id" FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" IN (1, 2) ORDER BY spree_taxonomies.position)
	(6.1ms) COMMIT
	SQL (6.5ms) UPDATE "spree_products" SET "slug" = '1407295482_ruby-on-rails-tote' WHERE "spree_products"."id" = 1