Skip to content

Instantly share code, notes, and snippets.

@kalupa
Created May 7, 2013 01:13
Show Gist options
  • Save kalupa/5529606 to your computer and use it in GitHub Desktop.
Save kalupa/5529606 to your computer and use it in GitHub Desktop.
Started PUT "/orders/161c9a7d55d" for 127.0.0.1 at 2013-05-06 21:11:33 -0400
Processing by OrdersController#update as */*
Parameters: {"order"=>{"line_items_attributes"=>{"0"=>{"id"=>"455", "quantity"=>"2", "variant_id"=>"173"}}}, "id"=>"161c9a7d55d"}
Order Load (0.4ms) SELECT "orders".* FROM "orders" WHERE "orders"."token" = '161c9a7d55d' LIMIT 1
(0.1ms) BEGIN
LineItem Load (0.2ms) SELECT "line_items".* FROM "line_items" WHERE "line_items"."order_id" = 216 AND "line_items"."id" IN (455)
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1
Product Load (0.5ms) SELECT "products".* FROM "products" WHERE "products"."id" = 9 LIMIT 1
CACHE (0.0ms) SELECT "products".* FROM "products" WHERE "products"."id" = 9 LIMIT 1
Image Load (0.2ms) SELECT "images".* FROM "images" WHERE "images"."product_id" = 9 ORDER BY ordering ASC
CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1
User Exists (0.2ms) SELECT 1 AS one FROM "users" WHERE (LOWER("users"."email") = LOWER('[email protected]') AND "users"."id" != 4) LIMIT 1
Product Load (0.4ms) SELECT "products".* FROM "products" WHERE "products"."user_id" = 4 AND "products"."state" = 'published'
CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1
Variant Load (0.3ms) SELECT "variants".* FROM "variants" WHERE "variants"."id" = 173 LIMIT 1
(0.4ms) UPDATE "orders" SET "updated_at" = '2013-05-07 01:11:33.539667', "custom_checkout_values" = '---
...
', "stripe_customer_details" = '---
...
', "variant_options" = '---
...
' WHERE "orders"."id" = 216
Order Load (0.4ms) SELECT "orders".* FROM "orders" WHERE "orders"."id" = 216 LIMIT 1
Variant Load (0.2ms) SELECT "variants".* FROM "variants" WHERE "variants"."id" = 173 LIMIT 1
Product Load (0.3ms) SELECT "products".* FROM "products" WHERE "products"."id" = 9 LIMIT 1
Address Load (0.2ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."order_id" = 216 LIMIT 1
Country Load (0.3ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = 189 ORDER BY position LIMIT 1
TaxRate Exists (0.3ms) SELECT 1 AS one FROM "tax_rates" WHERE "tax_rates"."product_id" = 9 AND "tax_rates"."country_id" = 189 AND "tax_rates"."state_id" IS NULL LIMIT 1
(0.2ms) SELECT COUNT(*) FROM "shipping_rates" WHERE "shipping_rates"."product_id" = 9
ShippingRate Load (0.2ms) SELECT "shipping_rates".* FROM "shipping_rates" WHERE "shipping_rates"."product_id" = 9 AND "shipping_rates"."allowed" = 't' AND "shipping_rates"."country_id" = 189 LIMIT 1
ShippingRate Load (0.3ms) SELECT "shipping_rates".* FROM "shipping_rates" WHERE "shipping_rates"."product_id" = 9 AND "shipping_rates"."default" = 't' AND "shipping_rates"."allowed" = 't' LIMIT 1
VariantValue Load (0.4ms) SELECT DISTINCT "variant_values".* FROM "variant_values" INNER JOIN "variant_values_variants" ON "variant_values"."id" = "variant_values_variants"."variant_value_id" WHERE "variant_values_variants"."variant_id" = 173
VariantCategory Load (0.1ms) SELECT "variant_categories".* FROM "variant_categories" WHERE "variant_categories"."id" = $1 LIMIT 1 [["id", 72]]
(0.2ms) UPDATE "line_items" SET "quantity" = 2, "subtotal" = 4.0, "total" = 5.0, "variant_options" = '---
Color: Yellow
', "updated_at" = '2013-05-07 01:11:33.556559' WHERE "line_items"."id" = 455
Expire fragment views/localhost:3000/products/DsymC-a-banana/embed (0.1ms)
LineItem Load (0.2ms) SELECT "line_items".* FROM "line_items" WHERE "line_items"."order_id" = 216
(0.2ms) SELECT COUNT(*) FROM "line_items" WHERE "line_items"."order_id" = 216
TaxRate Exists (0.3ms) SELECT 1 AS one FROM "tax_rates" WHERE "tax_rates"."product_id" = 9 AND "tax_rates"."country_id" = 189 AND "tax_rates"."state_id" IS NULL LIMIT 1
VariantCategory Load (0.2ms) SELECT "variant_categories".* FROM "variant_categories" WHERE "variant_categories"."id" = $1 LIMIT 1 [["id", 72]]
(0.2ms) UPDATE "line_items" SET "quantity" = 1, "subtotal" = 2.0, "total" = 3.0, "updated_at" = '2013-05-07 01:11:33.566409' WHERE "line_items"."id" = 455
(0.3ms) COMMIT
Address Load (0.2ms) SELECT "addresses".* FROM "addresses" WHERE "addresses"."order_id" = 216 LIMIT 1
Country Load (0.3ms) SELECT "countries".* FROM "countries" WHERE "countries"."id" = 189 ORDER BY position LIMIT 1
User Load (0.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = 4 LIMIT 1
Image Load (0.2ms) SELECT "images".* FROM "images" WHERE "images"."product_id" = 9 ORDER BY ordering ASC
Style Load (0.2ms) SELECT "styles".* FROM "styles" WHERE "styles"."id" = 9 LIMIT 1
Completed 200 OK in 59ms (Views: 10.5ms | ActiveRecord: 9.1ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment