-
-
Save stabenfeldt/66bc60cd70107ab63d92 to your computer and use it in GitHub Desktop.
This file contains hidden or 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
| 2016-01-27T14:29:22.477532+00:00 heroku[router]: at=info method=POST path="/api/taxonomies/5/taxons" host=my-beta.herokuapp.com request_id=e95122b8-6482-4310-96bf-a1df781fde5b fwd="84.215.77.255" dyno= | |
| web.1 connect=0ms service=62ms status=201 bytes=1231 | |
| 2016-01-27T14:29:22.399995+00:00 app[web.1]: Started POST "/api/taxonomies/5/taxons" for 84.215.77.255 at 2016-01-27 14:29:22 +0000 | |
| 2016-01-27T14:29:22.409944+00:00 app[web.1]: (0.9ms) SELECT "spree_roles"."name" FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_ro | |
| les_users"."user_id" = $1 [["user_id", 1]] | |
| 2016-01-27T14:29:22.416062+00:00 app[web.1]: Spree::Taxonomy Load (2.1ms) SELECT "spree_taxonomies".* FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" = $1 ORDER BY "spree_taxonomies"."position" | |
| ASC LIMIT 1 [["id", 5]] | |
| 2016-01-27T14:29:22.419183+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" ORDER BY "spree_taxons"."rgt" desc LIMIT 1 | |
| 2016-01-27T14:29:22.422123+00:00 app[web.1]: Spree::Taxon Load (0.7ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 [["id", 5]] | |
| 2016-01-27T14:29:22.426346+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 ORDER BY "spree_taxons"."lft" LIMIT 1 [["id", 5]] | |
| 2016-01-27T14:29:22.431817+00:00 app[web.1]: SQL (2.7ms) UPDATE "spree_taxons" SET "lft" = CASE WHEN "lft" BETWEEN 57 AND 148 THEN "lft" + 150 - 148 WHEN "lft" BETWEEN 149 AND 150 THEN "lft" + 57 - 149 | |
| ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 57 AND 148 THEN "rgt" + 150 - 148 WHEN "rgt" BETWEEN 149 AND 150 THEN "rgt" + 57 - 149 ELSE "rgt" END, "parent_id" = CASE WHEN "id" = 127 THEN 5 ELSE "pare | |
| nt_id" END, updated_at = '2016-01-27 14:29:22.428404' WHERE "spree_taxons"."id" IN (SELECT "spree_taxons"."id" FROM "spree_taxons" WHERE ("spree_taxons"."lft" BETWEEN 57 AND 150 OR "spree_taxons"."rgt" BE | |
| TWEEN 57 AND 150) ORDER BY "spree_taxons"."lft") | |
| 2016-01-27T14:29:22.434402+00:00 app[web.1]: Spree::Taxon Load (0.7ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 [["id", 127]] | |
| 2016-01-27T14:29:22.437928+00:00 app[web.1]: SQL (1.1ms) UPDATE "spree_taxons" SET "depth" = 2 WHERE "spree_taxons"."id" IN (SELECT "spree_taxons"."id" FROM "spree_taxons" WHERE "spree_taxons"."id" = 1 | |
| 27 ORDER BY "spree_taxons"."lft") | |
| 2016-01-27T14:29:22.440521+00:00 app[web.1]: Spree::Taxon Load (0.7ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 [["id", 127]] | |
| 2016-01-27T14:29:22.443877+00:00 app[web.1]: SQL (1.1ms) UPDATE "spree_taxons" SET "depth" = 2 WHERE "spree_taxons"."id" IN (SELECT "spree_taxons"."id" FROM "spree_taxons" WHERE "spree_taxons"."id" = 1 | |
| 27 ORDER BY "spree_taxons"."lft") | |
| 2016-01-27T14:29:22.446668+00:00 app[web.1]: SQL (0.9ms) UPDATE "spree_taxons" SET "updated_at" = '2016-01-27 14:29:22.445417' WHERE "spree_taxons"."id" IN (1, 5) | |
| 2016-01-27T14:29:22.450688+00:00 app[web.1]: SQL (0.7ms) UPDATE "spree_taxonomies" SET "updated_at" = '2016-01-27 14:29:22.448583' WHERE "spree_taxonomies"."id" = $1 [["id", 5]] | |
| 2016-01-27T14:29:22.455672+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 57) AND ("spree_taxons"."rgt" >= 58) AND ("spree_taxons | |
| "."id" != 127) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.458094+00:00 app[web.1]: Rendered vendor/bundle/ruby/2.2.0/bundler/gems/solidus-88f2f96346b0/api/app/views/spree/api/taxons/show.v1.rabl (4.5ms) | |
| 2016-01-27T14:29:22.539147+00:00 app[web.1]: Started GET "/api/taxonomies/5?set=nested" for 84.215.77.255 at 2016-01-27 14:29:22 +0000 | |
| 2016-01-27T14:29:22.546052+00:00 app[web.1]: (0.9ms) SELECT "spree_roles"."name" FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_ro | |
| les_users"."user_id" = $1 [["user_id", 1]] | |
| 2016-01-27T14:29:22.549772+00:00 app[web.1]: Spree::Taxonomy Load (0.8ms) SELECT "spree_taxonomies".* FROM "spree_taxonomies" WHERE ('t'='t') AND "spree_taxonomies"."id" = $1 ORDER BY "spree_taxonomi | |
| es"."position" ASC LIMIT 1 [["id", 5]] | |
| 2016-01-27T14:29:22.555102+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 63) AND ("spree_taxons"."rgt" >= 80) AND ("spree_taxons | |
| "."id" != 34) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.560673+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 64) AND ("spree_taxons"."rgt" >= 65) AND ("spree_taxons | |
| "."id" != 66) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.564346+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 66) AND ("spree_taxons"."rgt" >= 67) AND ("spree_taxons | |
| "."id" != 67) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.567889+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 68) AND ("spree_taxons"."rgt" >= 69) AND ("spree_taxons | |
| "."id" != 69) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.571348+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 70) AND ("spree_taxons"."rgt" >= 71) AND ("spree_taxons | |
| "."id" != 70) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.574779+00:00 app[web.1]: Spree::Taxon Load (0.9ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 72) AND ("spree_taxons"."rgt" >= 73) AND ("spree_taxons | |
| "."id" != 68) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.578275+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 74) AND ("spree_taxons"."rgt" >= 75) AND ("spree_taxons | |
| "."id" != 71) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.581700+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 76) AND ("spree_taxons"."rgt" >= 77) AND ("spree_taxons | |
| "."id" != 72) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.585202+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 78) AND ("spree_taxons"."rgt" >= 79) AND ("spree_taxons | |
| "."id" != 73) ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.587924+00:00 app[web.1]: Rendered vendor/bundle/ruby/2.2.0/bundler/gems/solidus-88f2f96346b0/api/app/views/spree/api/taxonomies/show.v1.rabl (37.4ms) | |
| 2016-01-27T14:29:22.402562+00:00 app[web.1]: Processing by Spree::Api::TaxonsController#create as JSON" "") " "") " "") " "") " "") " "") " "") " "") " "") "]] "" "]] "" " "") " ") " ") " "" "]] "" | |
| 2016-01-27T14:29:22.402585+00:00 app[web.1]: Parameters: {"taxon"=>{"name"=>"New node", "parent_id"=>"5", "child_index"=>"0"}, "taxonomy_id"=>"5"} | |
| 2016-01-27T14:29:22.406722+00:00 app[web.1]: Spree::User Load (1.8ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."spree_api_key" = $1 LIMIT 1 | |
| [["spree_api_key", "f720b1f19e548b0171883e3cd525d6008719e02848dcecd9"]] | |
| 2016-01-27T14:29:22.411449+00:00 app[web.1]: Spree::Role Load (0.9ms) SELECT "spree_roles".* FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHER | |
| E "spree_roles_users"."user_id" = $1 [["user_id", 1]] | |
| 2016-01-27T14:29:22.417004+00:00 app[web.1]: (0.6ms) BEGIN | |
| 2016-01-27T14:29:22.420675+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 FOR UPDATE [["id", 79]] | |
| 2016-01-27T14:29:22.424873+00:00 app[web.1]: SQL (0.9ms) INSERT INTO "spree_taxons" ("name", "parent_id", "taxonomy_id", "created_at", "updated_at", "lft", "rgt", "permalink") VALUES ($1, $2, $3, $4, $ | |
| 5, $6, $7, $8) RETURNING "id" [["name", "New node"], ["parent_id", 5], ["taxonomy_id", 5], ["created_at", "2016-01-27 14:29:22.417572"], ["updated_at", "2016-01-27 14:29:22.417572"], ["lft", 149], ["rgt", 150], ["permalink", "innendors/soverom/new-node"]] | |
| 2016-01-27T14:29:22.427729+00:00 app[web.1]: Spree::Taxon Load (0.7ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 FOR UPDATE [["id", 127]] | |
| 2016-01-27T14:29:22.433018+00:00 app[web.1]: Spree::Taxon Load (0.7ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 FOR UPDATE [["id", 5]] | |
| 2016-01-27T14:29:22.436368+00:00 app[web.1]: (0.9ms) SELECT COUNT(*) FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 57) AND ("spree_taxons"."rgt" >= 58) AND ("spree_taxons"."id" != 127) | |
| 2016-01-27T14:29:22.439131+00:00 app[web.1]: Spree::Taxon Load (0.7ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."id" = $1 LIMIT 1 FOR UPDATE [["id", 127]] | |
| 2016-01-27T14:29:22.442251+00:00 app[web.1]: (0.9ms) SELECT COUNT(*) FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 57) AND ("spree_taxons"."rgt" >= 58) AND ("spree_taxons"."id" != 127) | |
| 2016-01-27T14:29:22.445272+00:00 app[web.1]: (0.9ms) SELECT "spree_taxons"."id" FROM "spree_taxons" WHERE ("spree_taxons"."lft" <= 57) AND ("spree_taxons"."rgt" >= 58) AND ("spree_taxons"."id" != 127) | |
| ORDER BY "spree_taxons"."lft" | |
| 2016-01-27T14:29:22.448286+00:00 app[web.1]: Spree::Taxonomy Load (0.8ms) SELECT "spree_taxonomies".* FROM "spree_taxonomies" WHERE "spree_taxonomies"."id" = $1 ORDER BY "spree_taxonomies"."position" | |
| ASC LIMIT 1 [["id", 5]] | |
| 2016-01-27T14:29:22.452638+00:00 app[web.1]: (1.4ms) COMMIT | |
| 2016-01-27T14:29:22.457720+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 1 | |
| 27]] | |
| 2016-01-27T14:29:22.458331+00:00 app[web.1]: Completed 201 Created in 56ms (Views: 3.3ms | ActiveRecord: 27.5ms) | |
| 2016-01-27T14:29:22.541342+00:00 app[web.1]: Processing by Spree::Api::TaxonomiesController#show as JSON | |
| 2016-01-27T14:29:22.541347+00:00 app[web.1]: Parameters: {"set"=>"nested", "id"=>"5"} | |
| 2016-01-27T14:29:22.543743+00:00 app[web.1]: Spree::User Load (1.0ms) SELECT "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."spree_api_key" = $1 LIMIT 1 | |
| [["spree_api_key", "f720b1f19e548b0171883e3cd525d6008719e02848dcecd9"]] | |
| 2016-01-27T14:29:22.547369+00:00 app[web.1]: Spree::Role Load (0.9ms) 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" = $1 [["user_id", 1]] | |
| 2016-01-27T14:29:22.553107+00:00 app[web.1]: Spree::Taxon Load (0.9ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."taxonomy_id" = $1 AND "spree_taxons"."parent_id" IS NULL LIMIT | |
| 1 [["taxonomy_id", 5]] | |
| 2016-01-27T14:29:22.557111+00:00 app[web.1]: Spree::Taxon Load (1.0ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 3 | |
| 4]] | |
| 2016-01-27T14:29:22.562710+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 66]] | |
| 2016-01-27T14:29:22.566260+00:00 app[web.1]: Spree::Taxon Load (0.9ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 6 | |
| 7]] | |
| 2016-01-27T14:29:22.569768+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 6 | |
| 9]] | |
| 2016-01-27T14:29:22.573186+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 70]] | |
| 2016-01-27T14:29:22.576666+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 6 | |
| 8]] | |
| 2016-01-27T14:29:22.580121+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 7 | |
| 1]] | |
| 2016-01-27T14:29:22.583592+00:00 app[web.1]: Spree::Taxon Load (0.9ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id", 7 | |
| 2]] | |
| 2016-01-27T14:29:22.587047+00:00 app[web.1]: Spree::Taxon Load (0.8ms) SELECT "spree_taxons".* FROM "spree_taxons" WHERE "spree_taxons"."parent_id" = $1 ORDER BY "spree_taxons"."lft" [["parent_id",]] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment