Skip to content

Instantly share code, notes, and snippets.

@kennyadsl
Last active December 15, 2018 11:21
Show Gist options
  • Save kennyadsl/6546eb5535157a4537474f57ab4472c9 to your computer and use it in GitHub Desktop.
Save kennyadsl/6546eb5535157a4537474f57ab4472c9 to your computer and use it in GitHub Desktop.
Started GET "/api/orders" for 127.0.0.1 at 2018-12-15 12:15:07 +0100
Processing by Spree::Api::OrdersController#index as JSON
Spree::User Load (0.4ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."spree_api_key" = ? LIMIT ? [["spree_api_key", "3ce7a74a880861657c1e8586e7d7516aee7808467660e71b"], ["LIMIT", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/controllers/spree/api/base_controller.rb:46
(0.2ms) 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" = ? [["user_id", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/controllers/spree/api/base_controller.rb:61
Spree::Role Load (0.2ms) SELECT "spree_roles".* FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = ? [["user_id", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/lib/spree/core/role_configuration.rb:57
Rendering /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder
Spree::Order Load (0.7ms) SELECT "spree_orders".* FROM "spree_orders" LIMIT ? OFFSET ? [["LIMIT", 25], ["OFFSET", 0]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder:3
Spree::Payment Load (0.4ms) SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY "spree_payments"."created_at" ASC [["order_id", 1], ["order_id", 2], ["order_id", 3], ["order_id", 4], ["order_id", 5], ["order_id", 6], ["order_id", 7], ["order_id", 8], ["order_id", 9], ["order_id", 10], ["order_id", 11], ["order_id", 12], ["order_id", 13], ["order_id", 14], ["order_id", 15], ["order_id", 16], ["order_id", 17], ["order_id", 18], ["order_id", 19], ["order_id", 20], ["order_id", 21], ["order_id", 22], ["order_id", 23], ["order_id", 24], ["order_id", 25]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder:3
Spree::Adjustment Load (0.5ms) SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = ? AND "spree_adjustments"."adjustable_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY "spree_adjustments"."created_at" ASC [["adjustable_type", "Spree::Order"], ["adjustable_id", 1], ["adjustable_id", 2], ["adjustable_id", 3], ["adjustable_id", 4], ["adjustable_id", 5], ["adjustable_id", 6], ["adjustable_id", 7], ["adjustable_id", 8], ["adjustable_id", 9], ["adjustable_id", 10], ["adjustable_id", 11], ["adjustable_id", 12], ["adjustable_id", 13], ["adjustable_id", 14], ["adjustable_id", 15], ["adjustable_id", 16], ["adjustable_id", 17], ["adjustable_id", 18], ["adjustable_id", 19], ["adjustable_id", 20], ["adjustable_id", 21], ["adjustable_id", 22], ["adjustable_id", 23], ["adjustable_id", 24], ["adjustable_id", 25]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder:3
Spree::LineItem Load (0.4ms) SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY "spree_line_items"."created_at" ASC, "spree_line_items"."id" ASC [["order_id", 1], ["order_id", 2], ["order_id", 3], ["order_id", 4], ["order_id", 5], ["order_id", 6], ["order_id", 7], ["order_id", 8], ["order_id", 9], ["order_id", 10], ["order_id", 11], ["order_id", 12], ["order_id", 13], ["order_id", 14], ["order_id", 15], ["order_id", 16], ["order_id", 17], ["order_id", 18], ["order_id", 19], ["order_id", 20], ["order_id", 21], ["order_id", 22], ["order_id", 23], ["order_id", 24], ["order_id", 25]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder:3
(0.2ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.1ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.1ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
(0.3ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (62.0ms)
(0.2ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
(0.5ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 2]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (73.6ms)
(0.3ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 3]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (9.4ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 4]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (5.1ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 5]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 6]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 7]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (54.7ms)
(0.3ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 8]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 9]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.7ms)
(0.3ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 10]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.6ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 11]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 12]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.5ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 13]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.4ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 14]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 15]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.6ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 16]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 17]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (28.1ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 18]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 19]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.5ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 20]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.5ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 21]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.4ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 22]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 23]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (32.0ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 24]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 25]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.2ms)
(0.2ms) SELECT COUNT(*) FROM (SELECT 1 AS one FROM "spree_orders" LIMIT ? OFFSET ?) subquery_for_count [["LIMIT", 25], ["OFFSET", 0]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/shared/_pagination.json.jbuilder:3
(0.1ms) SELECT COUNT(*) FROM "spree_orders"
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/shared/_pagination.json.jbuilder:4
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/shared/_pagination.json.jbuilder (2.1ms)
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder (569.5ms)
Completed 200 OK in 669ms (Views: 653.4ms | ActiveRecord: 9.4ms)
Started GET "/api/orders" for 127.0.0.1 at 2018-12-15 12:16:13 +0100
Processing by Spree::Api::OrdersController#index as JSON
Spree::User Load (0.3ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."spree_api_key" = ? LIMIT ? [["spree_api_key", "3ce7a74a880861657c1e8586e7d7516aee7808467660e71b"], ["LIMIT", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/controllers/spree/api/base_controller.rb:46
(0.1ms) 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" = ? [["user_id", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/controllers/spree/api/base_controller.rb:61
Spree::Role Load (0.2ms) SELECT "spree_roles".* FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = ? [["user_id", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/lib/spree/core/role_configuration.rb:57
Rendering /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder
Spree::Order Load (1.9ms) SELECT "spree_orders".* FROM "spree_orders" LIMIT ? OFFSET ? [["LIMIT", 25], ["OFFSET", 0]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder:3
(0.2ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 1], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 1]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (17.3ms)
(0.2ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 2], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 2]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (14.5ms)
(0.2ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
CACHE (0.0ms) SELECT SUM("spree_payments"."amount") FROM "spree_payments" WHERE "spree_payments"."order_id" = ? AND "spree_payments"."source_type" = ? AND "spree_payments"."state" NOT IN (?, ?) [["order_id", 3], ["source_type", "Spree::StoreCredit"], ["state", "failed"], ["state", "invalid"]]
↳ /Users/kennyadsl/Code/nebulab/solidus/core/app/models/spree/order.rb:698
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 3]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (71.0ms)
(0.3ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 4]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (5.0ms)
(0.3ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 5]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.9ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 6]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.6ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 7]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.4ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 8]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (46.3ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 9]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.7ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 10]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 11]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 12]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.2ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 13]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.1ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 14]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.2ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 15]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (43.1ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 16]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.6ms)
(0.7ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 17]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (5.5ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 18]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.7ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 19]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 20]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.3ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 21]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.7ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 22]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (6.7ms)
(0.2ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 23]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (3.4ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 24]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.2ms)
(0.1ms) SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = ? [["order_id", 25]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder:6
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/_order.json.jbuilder (2.2ms)
(0.1ms) SELECT COUNT(*) FROM (SELECT 1 AS one FROM "spree_orders" LIMIT ? OFFSET ?) subquery_for_count [["LIMIT", 25], ["OFFSET", 0]]
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/shared/_pagination.json.jbuilder:3
(0.1ms) SELECT COUNT(*) FROM "spree_orders"
↳ /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/shared/_pagination.json.jbuilder:4
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/shared/_pagination.json.jbuilder (28.2ms)
Rendered /Users/kennyadsl/Code/nebulab/solidus/api/app/views/spree/api/orders/index.json.jbuilder (471.4ms)
Completed 200 OK in 826ms (Views: 525.8ms | ActiveRecord: 11.0ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment