Skip to content

Instantly share code, notes, and snippets.

@IdahoEv

IdahoEv/development.log

Created May 21, 2013 23:36
Show Gist options
  • Save IdahoEv/5624149 to your computer and use it in GitHub Desktop.
Save IdahoEv/5624149 to your computer and use it in GitHub Desktop.
Download ZIP
log of rake db:test:prepare
Raw
development.log
Connecting to database specified by database.yml
(0.9ms) SELECT * FROM geometry_columns WHERE f_table_name='schema_migrations'
(0.3ms) SELECT "schema_migrations"."version" FROM "schema_migrations"
(119.4ms) DROP DATABASE IF EXISTS "lvs_test"
(359.1ms) CREATE DATABASE "lvs_test" ENCODING = 'utf8' TEMPLATE = "template_postgis"
(14.8ms) CREATE TABLE "buyers" ("id" serial primary key, "street_address_1" character varying(255), "street_address_2" character varying(255), "city" character varying(255), "state" character varying(255), "zip" character varying(255), "description" text, "company" character varying(255), "phone_number" character varying(255), "buyer_type" character varying(255), "purchases_per_month" character varying(255), "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "default_image_id" integer, "geocoded_street_address" character varying(255), "geocoded_city_address" character varying(255), "geocoded_zip" character varying(255), "geocoded_coordinates" geometry)
(0.5ms) SELECT opcname FROM pg_opclass
(1.7ms) CREATE INDEX "index_buyers_on_company" ON "buyers"("company" )
(6.8ms) CREATE INDEX "index_buyers_on_default_image_id" ON "buyers"("default_image_id" )
(17.8ms) CREATE TABLE "documents" ("id" serial primary key, "data_file_name" character varying(255), "data_file_size" integer, "data_content_type" character varying(255), "data_updated_at" timestamp, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(17.6ms) CREATE TABLE "farmers" ("id" serial primary key, "street_address_1" character varying(255), "street_address_2" character varying(255), "city" character varying(255), "state" character varying(255), "zip" character varying(255), "description" text, "company" character varying(255), "phone_number" character varying(255), "growing_practices" character varying(255)[] DEFAULT '{}', "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "default_image_id" integer, "geocoded_street_address" character varying(255), "geocoded_city_address" character varying(255), "geocoded_zip" character varying(255), "geocoded_coordinates" geometry)
(8.3ms) CREATE INDEX "index_farmers_on_company" ON "farmers"("company" )
(8.4ms) CREATE INDEX "index_farmers_on_default_image_id" ON "farmers"("default_image_id" )
(16.2ms) CREATE TABLE "images" ("id" serial primary key, "image_file_name" character varying(255), "image_file_size" integer, "image_content_type" character varying(255), "image_updated_at" timestamp, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(17.6ms) CREATE TABLE "inventory_items" ("id" serial primary key, "quantity_available" integer, "price" decimal, "case_weight" integer, "comments" text, "variety_id" integer, "farmer_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(18.3ms) CREATE TABLE "locations" ("id" serial primary key, "name" character varying(255), "path" character varying(255), "parent_id" integer, "lft" integer, "rgt" integer, "page_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(12.5ms) CREATE TABLE "pages" ("id" serial primary key, "title" character varying(255), "headline" character varying(255), "permalink" character varying(255), "content" text, "css" text, "published" boolean DEFAULT 't' NOT NULL, "keywords" text, "description" text, "edited_at" timestamp, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(17.4ms) CREATE TABLE "profile_images" ("id" serial primary key, "profile_id" integer, "profile_type" character varying(255), "position" integer, "image" character varying(255), "description" text, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(6.9ms) CREATE INDEX "index_profile_images_on_profile_id" ON "profile_images"("profile_id" )
(8.8ms) CREATE TABLE "ship_dates" ("id" serial primary key, "date" date, "inventory_item_id" integer, "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL)
(8.4ms) CREATE INDEX "index_ship_dates_on_date" ON "ship_dates"("date" )
(18.6ms) CREATE TABLE "users" ("id" serial primary key, "email" character varying(255), "first_name" character varying(60), "last_name" character varying(60), "sign_in_count" integer DEFAULT 0 NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "last_request_at" timestamp, "current_sign_in_at" timestamp, "last_sign_in_at" timestamp, "current_sign_in_ip" character varying(255), "last_sign_in_ip" character varying(255), "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "encrypted_password" character varying(255), "confirmation_token" character varying(255), "confirmed_at" timestamp, "confirmation_sent_at" timestamp, "reset_password_token" character varying(255), "reset_password_sent_at" timestamp, "remember_token" character varying(255), "remember_created_at" timestamp, "unlock_token" character varying(255), "locked_at" timestamp, "unconfirmed_email" character varying(255), "profile_id" integer, "profile_type" character varying(255))
(16.4ms) CREATE TABLE "varieties" ("id" serial primary key, "name" character varying(255), "parent_id" integer, "lft" integer, "rgt" integer, "depth" integer, "image" character varying(255), "created_at" timestamp NOT NULL, "updated_at" timestamp NOT NULL, "full_name" character varying(255))
(8.0ms) CREATE INDEX "index_varieties_on_full_name" ON "varieties"("full_name" )
(5.9ms) CREATE INDEX "index_varieties_on_lft" ON "varieties"("lft" )
(5.6ms) CREATE INDEX "index_varieties_on_name" ON "varieties"("name" )
(4.4ms) CREATE INDEX "index_varieties_on_parent_id" ON "varieties"("parent_id" )
(4.5ms) CREATE INDEX "index_varieties_on_rgt" ON "varieties"("rgt" )
(0.6ms) CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
(7.2ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations"("version" )
(0.3ms) SELECT version FROM "schema_migrations"
(0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20130516212531')
(0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('1')
(0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20130417213239')
(0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20130417223835')
(0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20130424200920')
(0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20130424233514')
(0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20130424234724')
(0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20130504001414')
(0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20130508173847')
(0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20130510042424')
(0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20130510213849')
(0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20130514002235')
(0.7ms) SELECT * FROM geometry_columns WHERE f_table_name='users'
User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."email" = 'admin@locaverse.com' LIMIT 1
(0.8ms) BEGIN
User Exists (0.6ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = 'admin@locaverse.com' LIMIT 1
SQL (27.0ms) INSERT INTO "users" ("confirmation_sent_at", "confirmation_token", "confirmed_at", "created_at", "current_sign_in_at", "current_sign_in_ip", "email", "encrypted_password", "failed_attempts", "first_name", "last_name", "last_request_at", "last_sign_in_at", "last_sign_in_ip", "locked_at", "profile_id", "profile_type", "remember_created_at", "remember_token", "reset_password_sent_at", "reset_password_token", "sign_in_count", "unconfirmed_email", "unlock_token", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) RETURNING "id" [["confirmation_sent_at", nil], ["confirmation_token", nil], ["confirmed_at", Tue, 21 May 2013 23:21:49 UTC +00:00], ["created_at", Tue, 21 May 2013 23:31:49 UTC +00:00], ["current_sign_in_at", nil], ["current_sign_in_ip", nil], ["email", "admin@locaverse.com"], ["encrypted_password", "$2a$10$c/.FD90DcUjnMpVx.WLe4Ovf96sdssJwMjE4/Ri61AZEW/fwseMDq"], ["failed_attempts", 0], ["first_name", "Joe"], ["last_name", "Admin"], ["last_request_at", nil], ["last_sign_in_at", nil], ["last_sign_in_ip", nil], ["locked_at", nil], ["profile_id", nil], ["profile_type", "admin"], ["remember_created_at", nil], ["remember_token", nil], ["reset_password_sent_at", nil], ["reset_password_token", nil], ["sign_in_count", 0], ["unconfirmed_email", nil], ["unlock_token", nil], ["updated_at", Tue, 21 May 2013 23:31:49 UTC +00:00]]
(0.5ms) COMMIT
(0.6ms) SELECT * FROM geometry_columns WHERE f_table_name='varieties'
(0.5ms) BEGIN
Variety Load (1.0ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (1.2ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:49 UTC +00:00], ["depth", nil], ["full_name", "Apples"], ["image", nil], ["lft", 1], ["name", "Apples"], ["parent_id", nil], ["rgt", 2], ["updated_at", Tue, 21 May 2013 23:31:49 UTC +00:00]]
Variety Load (0.8ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 1]]
SQL (0.6ms) UPDATE "varieties" SET "depth" = 0 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 1 ORDER BY "varieties"."lft")
(0.2ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 1]]
(0.8ms) UPDATE "varieties" SET "image" = 'apples.jpeg', "updated_at" = '2013-05-21 23:31:50.048083' WHERE "varieties"."id" = 1
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 1]]
SQL (0.7ms) UPDATE "varieties" SET "depth" = 0 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 1 ORDER BY "varieties"."lft")
(0.5ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.6ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:50 UTC +00:00], ["depth", nil], ["full_name", "Apples, Braeburn"], ["image", nil], ["lft", 3], ["name", "Braeburn"], ["parent_id", 1], ["rgt", 4], ["updated_at", Tue, 21 May 2013 23:31:50 UTC +00:00]]
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.7ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 2]]
SQL (0.9ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 2 AND 2 THEN "lft" + 4 - 2 WHEN "lft" BETWEEN 3 AND 4 THEN "lft" + 2 - 3 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 2 AND 2 THEN "rgt" + 4 - 2 WHEN "rgt" BETWEEN 3 AND 4 THEN "rgt" + 2 - 3 ELSE "rgt" END, "parent_id" = CASE WHEN id = 2 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 2 AND 2 THEN "lft" + 4 - 2 WHEN "lft" BETWEEN 3 AND 4 THEN "lft" + 2 - 3 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 2 AND 2 THEN "rgt" + 4 - 2 WHEN "rgt" BETWEEN 3 AND 4 THEN "rgt" + 2 - 3 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 2 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 2]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 2 AND "varieties"."rgt" >= 3) AND ("varieties".id != 2)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 2 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 2 AND "varieties"."rgt" >= 3) AND ("varieties".id != 2)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 2 AND "varieties"."lft" < 3) AND ("varieties".id != 2) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 2]]
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 2]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 2 AND "varieties"."rgt" >= 3) AND ("varieties".id != 2)
SQL (0.6ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 2 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 2 AND "varieties"."rgt" >= 3) AND ("varieties".id != 2)
(0.3ms) COMMIT
(0.4ms) BEGIN
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 2]]
(0.4ms) UPDATE "varieties" SET "image" = 'braeburn.jpeg', "updated_at" = '2013-05-21 23:31:50.657224' WHERE "varieties"."id" = 2
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 2]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 2 AND "varieties"."rgt" >= 3) AND ("varieties".id != 2)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 2 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 2 AND "varieties"."rgt" >= 3) AND ("varieties".id != 2)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:50 UTC +00:00], ["depth", nil], ["full_name", "Apples, Fuji"], ["image", nil], ["lft", 5], ["name", "Fuji"], ["parent_id", 1], ["rgt", 6], ["updated_at", Tue, 21 May 2013 23:31:50 UTC +00:00]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 3]]
SQL (0.7ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 4 AND 4 THEN "lft" + 6 - 4 WHEN "lft" BETWEEN 5 AND 6 THEN "lft" + 4 - 5 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 4 AND 4 THEN "rgt" + 6 - 4 WHEN "rgt" BETWEEN 5 AND 6 THEN "rgt" + 4 - 5 ELSE "rgt" END, "parent_id" = CASE WHEN id = 3 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 4 AND 4 THEN "lft" + 6 - 4 WHEN "lft" BETWEEN 5 AND 6 THEN "lft" + 4 - 5 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 4 AND 4 THEN "rgt" + 6 - 4 WHEN "rgt" BETWEEN 5 AND 6 THEN "rgt" + 4 - 5 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 3 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 3]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 4 AND "varieties"."rgt" >= 5) AND ("varieties".id != 3)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 3 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 4 AND "varieties"."rgt" >= 5) AND ("varieties".id != 3)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 4 AND "varieties"."lft" < 5) AND ("varieties".id != 3) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 3]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 3]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 4 AND "varieties"."rgt" >= 5) AND ("varieties".id != 3)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 3 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 4 AND "varieties"."rgt" >= 5) AND ("varieties".id != 3)
(0.2ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 3]]
(0.4ms) UPDATE "varieties" SET "image" = 'fuji.jpeg', "updated_at" = '2013-05-21 23:31:51.481278' WHERE "varieties"."id" = 3
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 3]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 4 AND "varieties"."rgt" >= 5) AND ("varieties".id != 3)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 3 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 4 AND "varieties"."rgt" >= 5) AND ("varieties".id != 3)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:51 UTC +00:00], ["depth", nil], ["full_name", "Apples, Gala"], ["image", nil], ["lft", 7], ["name", "Gala"], ["parent_id", 1], ["rgt", 8], ["updated_at", Tue, 21 May 2013 23:31:51 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 4]]
SQL (1.4ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 6 AND 6 THEN "lft" + 8 - 6 WHEN "lft" BETWEEN 7 AND 8 THEN "lft" + 6 - 7 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 6 AND 6 THEN "rgt" + 8 - 6 WHEN "rgt" BETWEEN 7 AND 8 THEN "rgt" + 6 - 7 ELSE "rgt" END, "parent_id" = CASE WHEN id = 4 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 6 AND 6 THEN "lft" + 8 - 6 WHEN "lft" BETWEEN 7 AND 8 THEN "lft" + 6 - 7 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 6 AND 6 THEN "rgt" + 8 - 6 WHEN "rgt" BETWEEN 7 AND 8 THEN "rgt" + 6 - 7 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 4 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 4]]
(0.7ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 6 AND "varieties"."rgt" >= 7) AND ("varieties".id != 4)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 4 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 6 AND "varieties"."rgt" >= 7) AND ("varieties".id != 4)
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 6 AND "varieties"."lft" < 7) AND ("varieties".id != 4) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 4]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 4]]
(1.9ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 6 AND "varieties"."rgt" >= 7) AND ("varieties".id != 4)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 4 ORDER BY "varieties"."lft")
(0.6ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 6 AND "varieties"."rgt" >= 7) AND ("varieties".id != 4)
(0.3ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 4]]
(0.5ms) UPDATE "varieties" SET "image" = 'gala.jpeg', "updated_at" = '2013-05-21 23:31:52.064214' WHERE "varieties"."id" = 4
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 4]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 6 AND "varieties"."rgt" >= 7) AND ("varieties".id != 4)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 4 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 6 AND "varieties"."rgt" >= 7) AND ("varieties".id != 4)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.4ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:52 UTC +00:00], ["depth", nil], ["full_name", "Apples, Green Delicious"], ["image", nil], ["lft", 9], ["name", "Green Delicious"], ["parent_id", 1], ["rgt", 10], ["updated_at", Tue, 21 May 2013 23:31:52 UTC +00:00]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 5]]
SQL (0.8ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 8 AND 8 THEN "lft" + 10 - 8 WHEN "lft" BETWEEN 9 AND 10 THEN "lft" + 8 - 9 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 8 AND 8 THEN "rgt" + 10 - 8 WHEN "rgt" BETWEEN 9 AND 10 THEN "rgt" + 8 - 9 ELSE "rgt" END, "parent_id" = CASE WHEN id = 5 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 8 AND 8 THEN "lft" + 10 - 8 WHEN "lft" BETWEEN 9 AND 10 THEN "lft" + 8 - 9 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 8 AND 8 THEN "rgt" + 10 - 8 WHEN "rgt" BETWEEN 9 AND 10 THEN "rgt" + 8 - 9 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 5 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 5]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 8 AND "varieties"."rgt" >= 9) AND ("varieties".id != 5)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 5 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 8 AND "varieties"."rgt" >= 9) AND ("varieties".id != 5)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 8 AND "varieties"."lft" < 9) AND ("varieties".id != 5) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 5]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 5]]
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 8 AND "varieties"."rgt" >= 9) AND ("varieties".id != 5)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 5 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 8 AND "varieties"."rgt" >= 9) AND ("varieties".id != 5)
(0.3ms) COMMIT
(0.4ms) BEGIN
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 5]]
(0.4ms) UPDATE "varieties" SET "image" = 'green_delicious.jpeg', "updated_at" = '2013-05-21 23:31:52.557538' WHERE "varieties"."id" = 5
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 5]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 8 AND "varieties"."rgt" >= 9) AND ("varieties".id != 5)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 5 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 8 AND "varieties"."rgt" >= 9) AND ("varieties".id != 5)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:52 UTC +00:00], ["depth", nil], ["full_name", "Apples, Honeycrisp"], ["image", nil], ["lft", 11], ["name", "Honeycrisp"], ["parent_id", 1], ["rgt", 12], ["updated_at", Tue, 21 May 2013 23:31:52 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 6]]
SQL (0.7ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 10 AND 10 THEN "lft" + 12 - 10 WHEN "lft" BETWEEN 11 AND 12 THEN "lft" + 10 - 11 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 10 AND 10 THEN "rgt" + 12 - 10 WHEN "rgt" BETWEEN 11 AND 12 THEN "rgt" + 10 - 11 ELSE "rgt" END, "parent_id" = CASE WHEN id = 6 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 10 AND 10 THEN "lft" + 12 - 10 WHEN "lft" BETWEEN 11 AND 12 THEN "lft" + 10 - 11 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 10 AND 10 THEN "rgt" + 12 - 10 WHEN "rgt" BETWEEN 11 AND 12 THEN "rgt" + 10 - 11 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 6 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 6]]
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 10 AND "varieties"."rgt" >= 11) AND ("varieties".id != 6)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 6 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 10 AND "varieties"."rgt" >= 11) AND ("varieties".id != 6)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 10 AND "varieties"."lft" < 11) AND ("varieties".id != 6) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 6]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 6]]
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 10 AND "varieties"."rgt" >= 11) AND ("varieties".id != 6)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 6 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 10 AND "varieties"."rgt" >= 11) AND ("varieties".id != 6)
(0.3ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 6]]
(0.7ms) UPDATE "varieties" SET "image" = 'honeycrisp.jpeg', "updated_at" = '2013-05-21 23:31:53.119805' WHERE "varieties"."id" = 6
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 6]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 10 AND "varieties"."rgt" >= 11) AND ("varieties".id != 6)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 6 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 10 AND "varieties"."rgt" >= 11) AND ("varieties".id != 6)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:53 UTC +00:00], ["depth", nil], ["full_name", "Apples, McIntosh"], ["image", nil], ["lft", 13], ["name", "McIntosh"], ["parent_id", 1], ["rgt", 14], ["updated_at", Tue, 21 May 2013 23:31:53 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 7]]
SQL (1.0ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 12 AND 12 THEN "lft" + 14 - 12 WHEN "lft" BETWEEN 13 AND 14 THEN "lft" + 12 - 13 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 12 AND 12 THEN "rgt" + 14 - 12 WHEN "rgt" BETWEEN 13 AND 14 THEN "rgt" + 12 - 13 ELSE "rgt" END, "parent_id" = CASE WHEN id = 7 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 12 AND 12 THEN "lft" + 14 - 12 WHEN "lft" BETWEEN 13 AND 14 THEN "lft" + 12 - 13 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 12 AND 12 THEN "rgt" + 14 - 12 WHEN "rgt" BETWEEN 13 AND 14 THEN "rgt" + 12 - 13 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 7 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 7]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 12 AND "varieties"."rgt" >= 13) AND ("varieties".id != 7)
SQL (0.6ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 7 ORDER BY "varieties"."lft")
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 12 AND "varieties"."rgt" >= 13) AND ("varieties".id != 7)
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 12 AND "varieties"."lft" < 13) AND ("varieties".id != 7) ORDER BY "varieties"."lft"
Variety Load (0.4ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 7]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 7]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 12 AND "varieties"."rgt" >= 13) AND ("varieties".id != 7)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 7 ORDER BY "varieties"."lft")
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 12 AND "varieties"."rgt" >= 13) AND ("varieties".id != 7)
(0.3ms) COMMIT
(0.4ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 7]]
(0.4ms) UPDATE "varieties" SET "image" = 'mcintosh.jpeg', "updated_at" = '2013-05-21 23:31:53.586263' WHERE "varieties"."id" = 7
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 7]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 12 AND "varieties"."rgt" >= 13) AND ("varieties".id != 7)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 7 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 12 AND "varieties"."rgt" >= 13) AND ("varieties".id != 7)
(0.2ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:53 UTC +00:00], ["depth", nil], ["full_name", "Apples, Red Delicious"], ["image", nil], ["lft", 15], ["name", "Red Delicious"], ["parent_id", 1], ["rgt", 16], ["updated_at", Tue, 21 May 2013 23:31:53 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 1]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 8]]
SQL (0.8ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 14 AND 14 THEN "lft" + 16 - 14 WHEN "lft" BETWEEN 15 AND 16 THEN "lft" + 14 - 15 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 14 AND 14 THEN "rgt" + 16 - 14 WHEN "rgt" BETWEEN 15 AND 16 THEN "rgt" + 14 - 15 ELSE "rgt" END, "parent_id" = CASE WHEN id = 8 THEN 1 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 14 AND 14 THEN "lft" + 16 - 14 WHEN "lft" BETWEEN 15 AND 16 THEN "lft" + 14 - 15 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 14 AND 14 THEN "rgt" + 16 - 14 WHEN "rgt" BETWEEN 15 AND 16 THEN "rgt" + 14 - 15 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 8 THEN 1 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 1]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 8]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 14 AND "varieties"."rgt" >= 15) AND ("varieties".id != 8)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 8 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 14 AND "varieties"."rgt" >= 15) AND ("varieties".id != 8)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 14 AND "varieties"."lft" < 15) AND ("varieties".id != 8) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 8]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 8]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 14 AND "varieties"."rgt" >= 15) AND ("varieties".id != 8)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 8 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 14 AND "varieties"."rgt" >= 15) AND ("varieties".id != 8)
(0.2ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 1 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 8]]
(0.4ms) UPDATE "varieties" SET "image" = 'red_delicious.jpeg', "updated_at" = '2013-05-21 23:31:54.037647' WHERE "varieties"."id" = 8
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 8]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 14 AND "varieties"."rgt" >= 15) AND ("varieties".id != 8)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 8 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 14 AND "varieties"."rgt" >= 15) AND ("varieties".id != 8)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.7ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:54 UTC +00:00], ["depth", nil], ["full_name", "Oranges"], ["image", nil], ["lft", 17], ["name", "Oranges"], ["parent_id", nil], ["rgt", 18], ["updated_at", Tue, 21 May 2013 23:31:54 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 9]]
SQL (0.6ms) UPDATE "varieties" SET "depth" = 0 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 9 ORDER BY "varieties"."lft")
(0.2ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 9]]
(0.5ms) UPDATE "varieties" SET "image" = 'oranges.jpeg', "updated_at" = '2013-05-21 23:31:54.522887' WHERE "varieties"."id" = 9
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 9]]
SQL (0.6ms) UPDATE "varieties" SET "depth" = 0 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 9 ORDER BY "varieties"."lft")
(0.2ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.6ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:54 UTC +00:00], ["depth", nil], ["full_name", "Oranges, Blood"], ["image", nil], ["lft", 19], ["name", "Blood"], ["parent_id", 9], ["rgt", 20], ["updated_at", Tue, 21 May 2013 23:31:54 UTC +00:00]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 9]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 10]]
SQL (0.8ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 18 AND 18 THEN "lft" + 20 - 18 WHEN "lft" BETWEEN 19 AND 20 THEN "lft" + 18 - 19 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 18 AND 18 THEN "rgt" + 20 - 18 WHEN "rgt" BETWEEN 19 AND 20 THEN "rgt" + 18 - 19 ELSE "rgt" END, "parent_id" = CASE WHEN id = 10 THEN 9 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 18 AND 18 THEN "lft" + 20 - 18 WHEN "lft" BETWEEN 19 AND 20 THEN "lft" + 18 - 19 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 18 AND 18 THEN "rgt" + 20 - 18 WHEN "rgt" BETWEEN 19 AND 20 THEN "rgt" + 18 - 19 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 10 THEN 9 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 9]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 10]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 18 AND "varieties"."rgt" >= 19) AND ("varieties".id != 10)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 10 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 18 AND "varieties"."rgt" >= 19) AND ("varieties".id != 10)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 18 AND "varieties"."lft" < 19) AND ("varieties".id != 10) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 10]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 10]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 18 AND "varieties"."rgt" >= 19) AND ("varieties".id != 10)
SQL (0.6ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 10 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 18 AND "varieties"."rgt" >= 19) AND ("varieties".id != 10)
(0.3ms) COMMIT
(0.4ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 9 LIMIT 1
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 10]]
(0.5ms) UPDATE "varieties" SET "image" = 'blood.jpeg', "updated_at" = '2013-05-21 23:31:55.101930' WHERE "varieties"."id" = 10
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 10]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 18 AND "varieties"."rgt" >= 19) AND ("varieties".id != 10)
SQL (0.6ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 10 ORDER BY "varieties"."lft")
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 18 AND "varieties"."rgt" >= 19) AND ("varieties".id != 10)
(0.5ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:55 UTC +00:00], ["depth", nil], ["full_name", "Oranges, Cara Cara"], ["image", nil], ["lft", 21], ["name", "Cara Cara"], ["parent_id", 9], ["rgt", 22], ["updated_at", Tue, 21 May 2013 23:31:55 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 9]]
Variety Load (0.4ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 11]]
SQL (0.9ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 20 AND 20 THEN "lft" + 22 - 20 WHEN "lft" BETWEEN 21 AND 22 THEN "lft" + 20 - 21 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 20 AND 20 THEN "rgt" + 22 - 20 WHEN "rgt" BETWEEN 21 AND 22 THEN "rgt" + 20 - 21 ELSE "rgt" END, "parent_id" = CASE WHEN id = 11 THEN 9 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 20 AND 20 THEN "lft" + 22 - 20 WHEN "lft" BETWEEN 21 AND 22 THEN "lft" + 20 - 21 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 20 AND 20 THEN "rgt" + 22 - 20 WHEN "rgt" BETWEEN 21 AND 22 THEN "rgt" + 20 - 21 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 11 THEN 9 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 9]]
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 11]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 20 AND "varieties"."rgt" >= 21) AND ("varieties".id != 11)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 11 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 20 AND "varieties"."rgt" >= 21) AND ("varieties".id != 11)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 20 AND "varieties"."lft" < 21) AND ("varieties".id != 11) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 11]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 11]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 20 AND "varieties"."rgt" >= 21) AND ("varieties".id != 11)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 11 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 20 AND "varieties"."rgt" >= 21) AND ("varieties".id != 11)
(0.3ms) COMMIT
(0.4ms) BEGIN
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 9 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 11]]
(0.4ms) UPDATE "varieties" SET "image" = 'cara_cara.jpeg', "updated_at" = '2013-05-21 23:31:55.704320' WHERE "varieties"."id" = 11
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 11]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 20 AND "varieties"."rgt" >= 21) AND ("varieties".id != 11)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 11 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 20 AND "varieties"."rgt" >= 21) AND ("varieties".id != 11)
(0.3ms) COMMIT
(1.0ms) BEGIN
Variety Load (0.5ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.5ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:55 UTC +00:00], ["depth", nil], ["full_name", "Oranges, Navel"], ["image", nil], ["lft", 23], ["name", "Navel"], ["parent_id", 9], ["rgt", 24], ["updated_at", Tue, 21 May 2013 23:31:55 UTC +00:00]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 9]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 12]]
SQL (0.8ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 22 AND 22 THEN "lft" + 24 - 22 WHEN "lft" BETWEEN 23 AND 24 THEN "lft" + 22 - 23 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 22 AND 22 THEN "rgt" + 24 - 22 WHEN "rgt" BETWEEN 23 AND 24 THEN "rgt" + 22 - 23 ELSE "rgt" END, "parent_id" = CASE WHEN id = 12 THEN 9 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 22 AND 22 THEN "lft" + 24 - 22 WHEN "lft" BETWEEN 23 AND 24 THEN "lft" + 22 - 23 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 22 AND 22 THEN "rgt" + 24 - 22 WHEN "rgt" BETWEEN 23 AND 24 THEN "rgt" + 22 - 23 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 12 THEN 9 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 9]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 12]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 22 AND "varieties"."rgt" >= 23) AND ("varieties".id != 12)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 12 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 22 AND "varieties"."rgt" >= 23) AND ("varieties".id != 12)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 22 AND "varieties"."lft" < 23) AND ("varieties".id != 12) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 12]]
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 12]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 22 AND "varieties"."rgt" >= 23) AND ("varieties".id != 12)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 12 ORDER BY "varieties"."lft")
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 22 AND "varieties"."rgt" >= 23) AND ("varieties".id != 12)
(0.3ms) COMMIT
(0.5ms) BEGIN
Variety Load (0.7ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 9 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 12]]
(0.4ms) UPDATE "varieties" SET "image" = 'navel.jpeg', "updated_at" = '2013-05-21 23:31:56.219087' WHERE "varieties"."id" = 12
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 12]]
(0.5ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 22 AND "varieties"."rgt" >= 23) AND ("varieties".id != 12)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 12 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 22 AND "varieties"."rgt" >= 23) AND ("varieties".id != 12)
(0.3ms) COMMIT
(0.2ms) BEGIN
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" ORDER BY "varieties"."rgt" desc LIMIT 1 FOR UPDATE
SQL (0.7ms) INSERT INTO "varieties" ("created_at", "depth", "full_name", "image", "lft", "name", "parent_id", "rgt", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id" [["created_at", Tue, 21 May 2013 23:31:56 UTC +00:00], ["depth", nil], ["full_name", "Oranges, Valencia"], ["image", nil], ["lft", 25], ["name", "Valencia"], ["parent_id", 9], ["rgt", 26], ["updated_at", Tue, 21 May 2013 23:31:56 UTC +00:00]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 ORDER BY "varieties"."lft" LIMIT 1 [["id", 9]]
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 13]]
SQL (0.8ms) UPDATE "varieties" SET "lft" = CASE WHEN "lft" BETWEEN 24 AND 24 THEN "lft" + 26 - 24 WHEN "lft" BETWEEN 25 AND 26 THEN "lft" + 24 - 25 ELSE "lft" END, "rgt" = CASE WHEN "rgt" BETWEEN 24 AND 24 THEN "rgt" + 26 - 24 WHEN "rgt" BETWEEN 25 AND 26 THEN "rgt" + 24 - 25 ELSE "rgt" END, "parent_id" = CASE WHEN id = 13 THEN 9 ELSE "parent_id" END WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE (not ("lft" = CASE WHEN "lft" BETWEEN 24 AND 24 THEN "lft" + 26 - 24 WHEN "lft" BETWEEN 25 AND 26 THEN "lft" + 24 - 25 ELSE "lft" END AND "rgt" = CASE WHEN "rgt" BETWEEN 24 AND 24 THEN "rgt" + 26 - 24 WHEN "rgt" BETWEEN 25 AND 26 THEN "rgt" + 24 - 25 ELSE "rgt" END AND "parent_id" = CASE WHEN id = 13 THEN 9 ELSE "parent_id" END)) ORDER BY "varieties"."lft")
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 9]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 13]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 24 AND "varieties"."rgt" >= 25) AND ("varieties".id != 13)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 13 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 24 AND "varieties"."rgt" >= 25) AND ("varieties".id != 13)
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE ("varieties"."lft" >= 24 AND "varieties"."lft" < 25) AND ("varieties".id != 13) ORDER BY "varieties"."lft"
Variety Load (0.3ms) SELECT "varieties"."lft", "varieties"."rgt", "varieties"."parent_id" FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 FOR UPDATE [["id", 13]]
Variety Load (0.3ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 13]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 24 AND "varieties"."rgt" >= 25) AND ("varieties".id != 13)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 13 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 24 AND "varieties"."rgt" >= 25) AND ("varieties".id != 13)
(0.3ms) COMMIT
(0.4ms) BEGIN
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = 9 LIMIT 1
Variety Load (0.4ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 13]]
(0.4ms) UPDATE "varieties" SET "image" = 'valencia.jpeg', "updated_at" = '2013-05-21 23:31:56.695936' WHERE "varieties"."id" = 13
Variety Load (0.6ms) SELECT "varieties".* FROM "varieties" WHERE "varieties"."id" = $1 LIMIT 1 [["id", 13]]
(0.4ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 24 AND "varieties"."rgt" >= 25) AND ("varieties".id != 13)
SQL (0.5ms) UPDATE "varieties" SET "depth" = 1 WHERE "varieties"."id" IN (SELECT "varieties"."id" FROM "varieties" WHERE "varieties"."id" = 13 ORDER BY "varieties"."lft")
(0.3ms) SELECT COUNT(*) FROM "varieties" WHERE ("varieties"."lft" <= 24 AND "varieties"."rgt" >= 25) AND ("varieties".id != 13)
(0.2ms) COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment