Skip to content

Instantly share code, notes, and snippets.

@jparbros

jparbros/gist:8d25dd1876b727353aa9

Created January 6, 2015 02:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jparbros/8d25dd1876b727353aa9 to your computer and use it in GitHub Desktop.
Save jparbros/8d25dd1876b727353aa9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
(82.0ms) SELECT SUM("spree_payments"."amount") AS sum_id FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND "spree_payments"."state" = 'completed' [["order_id", 1044]]
(1.6ms) SELECT SUM(price * quantity) AS sum_id FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1 [["order_id", 1044]]
(6.7ms) SELECT SUM("spree_shipments"."cost") AS sum_id FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1 [["order_id", 1044]]
Spree::Adjustment Load (2.8ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE (order_id = 1044 OR (adjustable_id = 1044 AND adjustable_type = 'Spree::Order'))
(2.0ms) SELECT SUM("spree_line_items"."adjustment_total") AS sum_id FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1 [["order_id", 1044]]
(2.0ms) SELECT SUM("spree_shipments"."adjustment_total") AS sum_id FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1 [["order_id", 1044]]
(3.9ms) SELECT SUM("spree_adjustments"."amount") AS sum_id FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = $1 AND "spree_adjustments"."adjustable_type" = $2 AND "spree_adjustments"."eligible" = 't' [["adjustable_id", 1044], ["adjustable_type", "Spree::Order"]]
(4.7ms) SELECT SUM("spree_line_items"."included_tax_total") AS sum_id FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1 [["order_id", 1044]]
(4.4ms) SELECT SUM("spree_shipments"."included_tax_total") AS sum_id FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1 [["order_id", 1044]]
(2.5ms) SELECT SUM("spree_line_items"."additional_tax_total") AS sum_id FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1 [["order_id", 1044]]
(2.9ms) SELECT SUM("spree_shipments"."additional_tax_total") AS sum_id FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1 [["order_id", 1044]]
(3.3ms) SELECT SUM("spree_line_items"."promo_total") AS sum_id FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1 [["order_id", 1044]]
(2.6ms) SELECT SUM("spree_shipments"."promo_total") AS sum_id FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1 [["order_id", 1044]]
(3.0ms) SELECT SUM("spree_adjustments"."amount") AS sum_id FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = $1 AND "spree_adjustments"."adjustable_type" = $2 AND "spree_adjustments"."source_type" = 'Spree::PromotionAction' AND "spree_adjustments"."eligible" = 't' [["adjustable_id", 1044], ["adjustable_type", "Spree::Order"]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment