Last active
December 15, 2018 11:21
-
-
Save kennyadsl/6546eb5535157a4537474f57ab4472c9 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/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) |
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/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