test/dummy/log/development.log in query_report-1.0.12 vs test/dummy/log/development.log in query_report-1.0.13
- old
+ new
@@ -46174,5 +46174,349 @@
[1m[35m (0.0ms)[0m commit transaction
[1m[36m (0.0ms)[0m [1mbegin transaction[0m
[1m[35mSQL (0.1ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 09 Oct 2013 17:02:50 UTC +00:00], ["dob", Tue, 09 Oct 1979 17:02:50 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 09 Oct 2013 17:02:50 UTC +00:00]]
[1m[36m (0.0ms)[0m [1mcommit transaction[0m
[1m[35mUser Load (0.1ms)[0m SELECT "users".* FROM "users"
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+ [1m[36m (1.7ms)[0m [1mselect sqlite_version(*)[0m
+ [1m[35m (0.3ms)[0m CREATE TABLE "gem_defined_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer)
+ [1m[36m (0.1ms)[0m [1mCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer, "dob" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) [0m
+ [1m[35m (0.1ms)[0m CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
+ [1m[36m (0.1ms)[0m [1mCREATE TABLE "readerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer) [0m
+ [1m[35m (0.1ms)[0m CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer)
+ [1m[36m (0.1ms)[0m [1mCREATE TABLE "user_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255), "user_id" integer) [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (48.4ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 30], ["created_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00], ["dob", nil], ["name", "Jitu"], ["updated_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "readerships" ("book_id", "user_id") VALUES (?, ?) [["book_id", nil], ["user_id", 1]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.3ms)[0m SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.2ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 1]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:19 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.4ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:19 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00], ["dob", Tue, 30 Oct 1979 05:28:19 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:19 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 2]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 3]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 4]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:20 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:20 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:20 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:20 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:20 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:20 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:20 UTC +00:00], ["dob", Tue, 30 Oct 1979 05:28:20 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:20 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.2ms)[0m SELECT AVG("users"."age") AS avg_id FROM "users"
+ [1m[36m (0.1ms)[0m [1mSELECT AVG("users"."age") AS avg_id FROM "users" [0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 5]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 6]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 7]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:23 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:23 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Tue, 30 Oct 1979 05:28:23 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 8]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 9]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 10]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.5ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:23 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:23 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (79.9ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.3ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.3ms)[0m SELECT "users".* FROM "users" LIMIT 25 OFFSET 0
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 11]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 12]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 13]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:23 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.4ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:23 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.2ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 14]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 15]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 16]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:23 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.4ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:23 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.3ms)[0m SELECT "users".* FROM "users" WHERE (("users"."dob" >= '1992-10-30 05:28:23.000000' AND "users"."dob" <= '2013-11-30 05:28:23.000000')) LIMIT 25 OFFSET 0
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 17]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 18]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 19]]
+ [1m[35m (0.2ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:28:23 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:28:23 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:28:23 UTC +00:00]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.3ms)[0m SELECT "users".* FROM "users" WHERE "users"."age" = 34 LIMIT 25 OFFSET 0
+Connecting to database specified by database.yml
+ [1m[36m (3.3ms)[0m [1mselect sqlite_version(*)[0m
+ [1m[35m (0.5ms)[0m CREATE TABLE "gem_defined_models" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer)
+ [1m[36m (0.3ms)[0m [1mCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "age" integer, "dob" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) [0m
+ [1m[35m (0.2ms)[0m CREATE TABLE "books" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255))
+ [1m[36m (0.3ms)[0m [1mCREATE TABLE "readerships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer) [0m
+ [1m[35m (0.3ms)[0m CREATE TABLE "authorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "book_id" integer)
+ [1m[36m (0.3ms)[0m [1mCREATE TABLE "user_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "street" varchar(255), "user_id" integer) [0m
+ [1m[35mUser Load (2.8ms)[0m SELECT "users".* FROM "users"
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (45.7ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:03 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.4ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:03 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.3ms)[0m SELECT "users".* FROM "users" LIMIT 25 OFFSET 0
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.2ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 1]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 2]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 3]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:03 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.4ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:03 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 4]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 5]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 6]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:03 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.5ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:03 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.3ms)[0m SELECT "users".* FROM "users" WHERE (("users"."dob" >= '1992-10-30 05:32:03.000000' AND "users"."dob" <= '2013-11-30 05:32:03.000000')) LIMIT 25 OFFSET 0
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.2ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 7]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 8]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 9]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.5ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:03 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:03 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", nil], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users" WHERE "users"."age" = 34 LIMIT 25 OFFSET 0
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 10]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.1ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 11]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 12]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.4ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:03 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.2ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.3ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:03 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[35m (0.1ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Tue, 30 Oct 1979 05:32:03 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.2ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 13]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.0ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 14]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.0ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 15]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:03 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.2ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:03 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00], ["dob", Tue, 30 Oct 1979 05:32:03 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:03 UTC +00:00]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.1ms)[0m SELECT AVG("users"."age") AS avg_id FROM "users"
+ [1m[36m (0.1ms)[0m [1mSELECT AVG("users"."age") AS avg_id FROM "users" [0m
+ [1m[35mUser Load (0.1ms)[0m SELECT "users".* FROM "users"
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" [0m
+ [1m[35m (0.1ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 16]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.0ms)[0m DELETE FROM "users" WHERE "users"."id" = ? [["id", 17]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.0ms)[0m [1mDELETE FROM "users" WHERE "users"."id" = ?[0m [["id", 18]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 10], ["created_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00], ["dob", Thu, 30 Oct 2003 05:32:06 UTC +00:00], ["name", "User#1"], ["updated_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00]]
+ [1m[36m (0.0ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.2ms)[0m [1mINSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?)[0m [["age", 20], ["created_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00], ["dob", Sat, 30 Oct 1993 05:32:06 UTC +00:00], ["name", "User#2"], ["updated_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36m (0.0ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.2ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 34], ["created_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00], ["dob", Tue, 30 Oct 1979 05:32:06 UTC +00:00], ["name", "User#3"], ["updated_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35mUser Load (0.2ms)[0m SELECT "users".* FROM "users"
+ [1m[36m (0.1ms)[0m [1mbegin transaction[0m
+ [1m[35mSQL (0.3ms)[0m INSERT INTO "users" ("age", "created_at", "dob", "name", "updated_at") VALUES (?, ?, ?, ?, ?) [["age", 30], ["created_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00], ["dob", nil], ["name", "Jitu"], ["updated_at", Wed, 30 Oct 2013 05:32:06 UTC +00:00]]
+ [1m[36m (0.1ms)[0m [1mcommit transaction[0m
+ [1m[35m (0.0ms)[0m begin transaction
+ [1m[36mSQL (0.1ms)[0m [1mINSERT INTO "readerships" ("book_id", "user_id") VALUES (?, ?)[0m [["book_id", nil], ["user_id", 22]]
+ [1m[35m (0.0ms)[0m commit transaction
+ [1m[36mUser Load (0.3ms)[0m [1mSELECT "users".* FROM "users" WHERE "users"."id" = 22 LIMIT 1[0m