(0.5ms)  begin transaction
  Fixture Delete (0.5ms)  DELETE FROM "magazines"
  Fixture Insert (0.3ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.3ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.3ms)  DELETE FROM "posts"
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.0ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.1ms)  commit transaction
   (0.0ms)  begin transaction
  Tag Load (0.4ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.2ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'None' WHERE "posts"."id" = 558545905
  Tagging Load (0.3ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371, 836272809)
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371, 836272809)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 402210157]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'None') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'None' LIMIT 1
  SQL (0.2ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "None"]]
  SQL (1.3ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:43 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.6ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (2.4ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "one"], ["text", "Test"], ["type", nil], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'one') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'one' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "one"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:43 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "One"], ["text", "Test"], ["type", nil], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079735 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'One') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:43 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079735], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature'))
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'nature'))
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.2ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.3ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'CRAZY ANIMAL') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:43 UTC +00:00], ["tag_id", 715858720], ["taggable_id", 901494828], ["taggable_type", "Photo"]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'QUESTION') LIMIT 1
  SQL (0.1ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:43 UTC +00:00], ["tag_id", 922175824], ["taggable_id", 901494828], ["taggable_type", "Photo"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.5ms)  rollback transaction
   (0.1ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (1.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (3.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = '' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371, 836272809)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371, 836272809)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 402210157]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (3.6ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND "tags"."name" IN ('Very good', 'Nature') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, One, Two' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'One') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'One' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "One"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Two') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Two' LIMIT 1
  SQL (0.0ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Two"]]
  SQL (0.1ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 922175826], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 11720439]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 11720439 AND "taggings"."taggable_type" = 'Post'
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 11720439 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (836272809, 922175824)
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature, Question' WHERE "posts"."id" = 11720439
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (1.7ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.5ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'nature')
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good')
  Tag Load (0.5ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very Good' OR "tags"."name" LIKE 'Nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good' AND "tags"."name" NOT LIKE 'nature')
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good' OR "tags"."name" LIKE 'Nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good' AND "tags"."name" NOT LIKE 'nature')
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'ABCDEFG')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'abcdefg')
  Tag Load (0.3ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'HIJKLM')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'hijklm')
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE (1=0)
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE (1=0)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature, Beautiful' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Beautiful') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Beautiful' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Beautiful"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (2.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) GROUP BY tags.id, tags.name
  User Load (0.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 638797851]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 638797851)) GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE "photos"."user_id" = 992924717)) GROUP BY tags.id, tags.name
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE "photos"."user_id" = 638797851)) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) AND (1=0) GROUP BY tags.id, tags.name
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) GROUP BY tags.id, tags.name HAVING COUNT("tags".id) <= 2
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at >= '2006-08-04') GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at <= '2006-08-06') GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at >= '2006-08-05') AND ("taggings".created_at <= '2006-08-10') GROUP BY tags.id, tags.name
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".created_at >= '2006-08-12') AND ("taggings".created_at <= '2006-08-19') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 2
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) <= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND (1=1) GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Magazine' AND ("taggings".taggable_id IN (SELECT "magazines".id FROM "magazines" INNER JOIN "subscriptions" ON "magazines"."id" = "subscriptions"."magazine_id" WHERE "subscriptions"."user_id" = 992924717)) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 641791613 AND "taggings"."taggable_type" = 'Photo'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature', 'Crazy animal') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 641791613 AND "taggings"."taggable_type" = 'Photo'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature', 'Crazy animal') AND (tags.name = 'Crazy animal') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "photos" ("title", "user_id") VALUES (?, ?)  [["title", nil], ["user_id", nil]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1032490824 AND "taggings"."taggable_type" = 'Photo'
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.6ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE (tags.id = 715858720))) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "Nature"], ["text", "Test"], ["type", "SpecialPost"], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Nature') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 836272809], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" INNER JOIN "posts" ON "posts".id = "taggings".taggable_id WHERE "taggings"."taggable_type" = 'Post' AND "posts"."type" IN ('SpecialPost') GROUP BY tags.id, tags.name
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name LIMIT 2
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 4 LIMIT 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name ORDER BY count desc LIMIT 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, Random' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (922175825)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (922175825)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 1025864786]]
   (0.1ms)  SELECT COUNT(*) FROM "taggings" WHERE "taggings"."tag_id" = 922175825
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."tag_id" = 922175825
  SQL (0.1ms)  DELETE FROM "tags" WHERE "tags"."id" = ?  [["id", 922175825]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (6.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 155709414 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, Random' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (922175825)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (922175825)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 1025864786]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 864784826]]
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 1032490823]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 149932228]]
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Crazy animal' OR "tags"."name" LIKE 'Bad'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good' OR "tags"."name" LIKE 'Nature')) AND (1=0)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Photo Load (0.3ms)  SELECT "photos".* FROM "photos" WHERE ("photos".id NOT IN (SELECT taggings.taggable_id FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature')))
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 986552065]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 11720439]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 871620845]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 465126566]]
  Post Load (0.3ms)  SELECT "posts".* FROM "posts" WHERE ("posts".id NOT IN (SELECT taggings.taggable_id FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_type" = 'Post' AND "tags"."name" IN ('Very good', 'Bad')))
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 149932228]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 1032490823]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.3ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature')) ORDER BY photos.title DESC
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IN (638797851, 992924717)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.4ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" AS "taggings_0" ON "taggings_0".taggable_id = "photos".id AND "taggings_0".taggable_type = 'Photo' INNER JOIN "tags" AS "tags_0" ON "tags_0".id = "taggings_0".tag_id AND "tags_0".name LIKE 'Nature' INNER JOIN "taggings" AS "taggings_1" ON "taggings_1".taggable_id = "photos".id AND "taggings_1".taggable_type = 'Photo' INNER JOIN "tags" AS "tags_1" ON "tags_1".id = "taggings_1".tag_id AND "tags_1".name LIKE 'Crazy animal'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 864784826]]
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" AS "taggings_0" ON "taggings_0".taggable_id = "posts".id AND "taggings_0".taggable_type = 'Post' INNER JOIN "tags" AS "tags_0" ON "tags_0".id = "taggings_0".tag_id AND "tags_0".name LIKE 'Very good' INNER JOIN "taggings" AS "taggings_1" ON "taggings_1".taggable_id = "posts".id AND "taggings_1".taggable_type = 'Post' INNER JOIN "tags" AS "tags_1" ON "tags_1".id = "taggings_1".tag_id AND "tags_1".name LIKE 'Nature'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'ABCDEFG'))
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'HIJKLM'))
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'unsaved tag'))
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "Random"], ["text", "Test"], ["type", "SpecialPost"], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 08:51:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  SpecialPost Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "posts"."type" IN ('SpecialPost') AND (("tags"."name" LIKE 'Random'))
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Random'))
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.1ms)  ROLLBACK TO SAVEPOINT active_record_1
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.1ms)  rollback transaction
   (0.5ms)  begin transaction
  Fixture Delete (0.3ms)  DELETE FROM "magazines"
  Fixture Insert (0.2ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.1ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.3ms)  DELETE FROM "posts"
  Fixture Insert (0.4ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.1ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.2ms)  commit transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE (taggings.created_at >= '2006-08-15') GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE ("taggings"."created_at" BETWEEN '2006-08-14 23:59:00' AND '4000-01-01 00:00:00') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE (taggings.created_at >= '2006-08-15') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.2ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = '' LIMIT 1
   (0.0ms)  ROLLBACK TO SAVEPOINT active_record_1
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.2ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'My tag' LIMIT 1
  SQL (0.7ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "My tag"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'My tag' LIMIT 1
   (0.0ms)  ROLLBACK TO SAVEPOINT active_record_1
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 72034900]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 671271512]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 460040280]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."tag_id" = 746868371
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 601248253]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 403621919]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."tag_id" = 36387325
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.1ms)  SELECT COUNT(*) FROM "taggings" WHERE "taggings"."tag_id" = 746868371
   (0.1ms)  SELECT COUNT(*) FROM "taggings" 
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  DELETE FROM "taggings" WHERE "taggings"."tag_id" = 746868371
  SQL (0.1ms)  DELETE FROM "tags" WHERE "tags"."id" = ?  [["id", 746868371]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "taggings" 
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.0ms)  rollback transaction
   (0.5ms)  begin transaction
  Fixture Delete (0.8ms)  DELETE FROM "magazines"
  Fixture Insert (0.2ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.1ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "posts"
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.1ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.1ms)  commit transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.6ms)  begin transaction
  Fixture Delete (0.3ms)  DELETE FROM "magazines"
  Fixture Insert (0.2ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.1ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "posts"
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.1ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.0ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.1ms)  commit transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = 746868371 LIMIT 1
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.2ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = 558545905 LIMIT 1
   (0.0ms)  rollback transaction
   (0.5ms)  begin transaction
  Fixture Delete (0.3ms)  DELETE FROM "magazines"
  Fixture Insert (0.2ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.1ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "posts"
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.1ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.1ms)  commit transaction
   (0.0ms)  begin transaction
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" INNER JOIN "posts" ON "posts".id = "taggings".taggable_id WHERE "taggings"."taggable_type" = 'Post' AND "posts"."type" IN ('SpecialPost') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.5ms)  begin transaction
  Fixture Delete (0.3ms)  DELETE FROM "magazines"
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.1ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "posts"
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.1ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.1ms)  commit transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.2ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'None' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371, 836272809)
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371, 836272809)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 402210157]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'None') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'None' LIMIT 1
  SQL (0.2ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "None"]]
  SQL (30.8ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.7ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (15.4ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "one"], ["text", "Test"], ["type", nil], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'one') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'one' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "one"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "One"], ["text", "Test"], ["type", nil], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079735 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'One') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079735], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature'))
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'nature'))
   (0.6ms)  rollback transaction
   (0.1ms)  begin transaction
  Photo Load (0.3ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'CRAZY ANIMAL') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 715858720], ["taggable_id", 901494828], ["taggable_type", "Photo"]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'QUESTION') LIMIT 1
  SQL (0.1ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175824], ["taggable_id", 901494828], ["taggable_type", "Photo"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.3ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (2.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = '' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371, 836272809)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371, 836272809)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 402210157]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (2.9ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND "tags"."name" IN ('Very good', 'Nature') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, One, Two' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'One') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'One' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "One"]]
  SQL (0.3ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Two') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Two' LIMIT 1
  SQL (0.0ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Two"]]
  SQL (0.1ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175826], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 11720439]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 11720439 AND "taggings"."taggable_type" = 'Post'
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 11720439 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (836272809, 922175824)
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature, Question' WHERE "posts"."id" = 11720439
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.9ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.5ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'nature')
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good')
  Tag Load (0.6ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very Good' OR "tags"."name" LIKE 'Nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good' AND "tags"."name" NOT LIKE 'nature')
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good' OR "tags"."name" LIKE 'Nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good' AND "tags"."name" NOT LIKE 'nature')
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'ABCDEFG')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'abcdefg')
  Tag Load (0.3ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'HIJKLM')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'hijklm')
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE (1=0)
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE (1=0)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature, Beautiful' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Beautiful') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Beautiful' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Beautiful"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (1.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) GROUP BY tags.id, tags.name
  User Load (0.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 638797851]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 638797851)) GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE "photos"."user_id" = 992924717)) GROUP BY tags.id, tags.name
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE "photos"."user_id" = 638797851)) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) AND (1=0) GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) GROUP BY tags.id, tags.name HAVING COUNT("tags".id) <= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at >= '2006-08-04') GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at <= '2006-08-06') GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at >= '2006-08-05') AND ("taggings".created_at <= '2006-08-10') GROUP BY tags.id, tags.name
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".created_at >= '2006-08-12') AND ("taggings".created_at <= '2006-08-19') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 2
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) <= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND (1=1) GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Magazine' AND ("taggings".taggable_id IN (SELECT "magazines".id FROM "magazines" INNER JOIN "subscriptions" ON "magazines"."id" = "subscriptions"."magazine_id" WHERE "subscriptions"."user_id" = 992924717)) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 641791613 AND "taggings"."taggable_type" = 'Photo'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature', 'Crazy animal') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 641791613 AND "taggings"."taggable_type" = 'Photo'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature', 'Crazy animal') AND (tags.name = 'Crazy animal') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "photos" ("title", "user_id") VALUES (?, ?)  [["title", nil], ["user_id", nil]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1032490824 AND "taggings"."taggable_type" = 'Photo'
   (0.5ms)  rollback transaction
   (0.1ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.6ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE (tags.id = 715858720))) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "Nature"], ["text", "Test"], ["type", "SpecialPost"], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Nature') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 836272809], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" INNER JOIN "posts" ON "posts".id = "taggings".taggable_id WHERE "taggings"."taggable_type" = 'Post' AND "posts"."type" IN ('SpecialPost') GROUP BY tags.id, tags.name
   (0.5ms)  rollback transaction
   (0.1ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name LIMIT 2
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 4 LIMIT 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name ORDER BY count desc LIMIT 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, Random' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (922175825)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (922175825)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 1025864786]]
   (0.1ms)  SELECT COUNT(*) FROM "taggings" WHERE "taggings"."tag_id" = 922175825
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."tag_id" = 922175825
  SQL (0.1ms)  DELETE FROM "tags" WHERE "tags"."id" = ?  [["id", 922175825]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (2.6ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 155709414 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, Random' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (922175825)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (922175825)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 1025864786]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 864784826]]
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 1032490823]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 149932228]]
  Photo Load (0.3ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature'))
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Photo Load (0.3ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Crazy animal' OR "tags"."name" LIKE 'Bad'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good' OR "tags"."name" LIKE 'Nature')) AND (1=0)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Photo Load (0.3ms)  SELECT "photos".* FROM "photos" WHERE ("photos".id NOT IN (SELECT taggings.taggable_id FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature')))
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 986552065]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 11720439]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 871620845]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 465126566]]
  Post Load (0.4ms)  SELECT "posts".* FROM "posts" WHERE ("posts".id NOT IN (SELECT taggings.taggable_id FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_type" = 'Post' AND "tags"."name" IN ('Very good', 'Bad')))
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 149932228]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 1032490823]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.3ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature')) ORDER BY photos.title DESC
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" IN (638797851, 992924717)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.3ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" AS "taggings_0" ON "taggings_0".taggable_id = "photos".id AND "taggings_0".taggable_type = 'Photo' INNER JOIN "tags" AS "tags_0" ON "tags_0".id = "taggings_0".tag_id AND "tags_0".name LIKE 'Nature' INNER JOIN "taggings" AS "taggings_1" ON "taggings_1".taggable_id = "photos".id AND "taggings_1".taggable_type = 'Photo' INNER JOIN "tags" AS "tags_1" ON "tags_1".id = "taggings_1".tag_id AND "tags_1".name LIKE 'Crazy animal'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 864784826]]
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" AS "taggings_0" ON "taggings_0".taggable_id = "posts".id AND "taggings_0".taggable_type = 'Post' INNER JOIN "tags" AS "tags_0" ON "tags_0".id = "taggings_0".tag_id AND "tags_0".name LIKE 'Very good' INNER JOIN "taggings" AS "taggings_1" ON "taggings_1".taggable_id = "posts".id AND "taggings_1".taggable_type = 'Post' INNER JOIN "tags" AS "tags_1" ON "tags_1".id = "taggings_1".tag_id AND "tags_1".name LIKE 'Nature'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'ABCDEFG'))
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'HIJKLM'))
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'unsaved tag'))
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "Random"], ["text", "Test"], ["type", "SpecialPost"], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:03:44 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  SpecialPost Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "posts"."type" IN ('SpecialPost') AND (("tags"."name" LIKE 'Random'))
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Random'))
   (0.6ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.3ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.1ms)  ROLLBACK TO SAVEPOINT active_record_1
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE (taggings.created_at >= '2006-08-15') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE ("taggings"."created_at" BETWEEN '2006-08-14 23:59:00' AND '4000-01-01 00:00:00') GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE (taggings.created_at >= '2006-08-15') GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = '' LIMIT 1
   (0.0ms)  ROLLBACK TO SAVEPOINT active_record_1
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'My tag' LIMIT 1
  SQL (0.2ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "My tag"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'My tag' LIMIT 1
   (0.0ms)  ROLLBACK TO SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 72034900]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 671271512]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 460040280]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."tag_id" = 746868371
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 601248253]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 403621919]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."tag_id" = 36387325
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.1ms)  SELECT COUNT(*) FROM "taggings" WHERE "taggings"."tag_id" = 746868371
   (0.1ms)  SELECT COUNT(*) FROM "taggings" 
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."tag_id" = 746868371
  SQL (0.1ms)  DELETE FROM "tags" WHERE "tags"."id" = ?  [["id", 746868371]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "taggings" 
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = 746868371 LIMIT 1
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = 558545905 LIMIT 1
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" INNER JOIN "posts" ON "posts".id = "taggings".taggable_id WHERE "taggings"."taggable_type" = 'Post' AND "posts"."type" IN ('SpecialPost') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.5ms)  begin transaction
  Fixture Delete (0.3ms)  DELETE FROM "magazines"
  Fixture Insert (0.2ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Ruby', 207281424)
  Fixture Insert (0.1ms)  INSERT INTO "magazines" ("name", "id") VALUES ('Rails', 31989848)
  Fixture Delete (0.1ms)  DELETE FROM "photos"
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('A small dog', 641791613, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('What does this dog want?', 901494828, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Bad cat', 155709414, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Flower', 1032490823, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "photos" ("title", "id", "user_id") VALUES ('Sky', 149932228, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "posts"
  Fixture Insert (0.6ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The sky is particularly blue today', 558545905, 992924717)
  Fixture Insert (0.3ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The grass seems very green', 986552065, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why does the rain fall?', 11720439, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it cloudy?', 871620845, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Is it still cloudy?', 465126566, 992924717)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('The ground is looking too brown', 1034079733, 638797851)
  Fixture Insert (0.1ms)  INSERT INTO "posts" ("text", "id", "user_id") VALUES ('Why are the flowers dead?', 864784826, 638797851)
  Fixture Delete (0.1ms)  DELETE FROM "subscriptions"
  Fixture Insert (0.1ms)  INSERT INTO "subscriptions" ("id", "user_id", "magazine_id") VALUES (321399132, 992924717, 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "taggings"
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-01', 375276568, 746868371, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-02', 402210157, 836272809, 'Post', 558545905)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-03', 849893599, 836272809, 'Post', 986552065)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-04', 895328542, 922175824, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-05', 16200110, 836272809, 'Post', 11720439)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-06', 749836093, 836272809, 'Post', 871620845)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-07', 407951075, 836272809, 'Post', 465126566)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-08', 461214141, 836272809, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-09', 601248253, 36387325, 'Post', 1034079733)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-10', 72034900, 746868371, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-11', 702998822, 836272809, 'Post', 864784826)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-12', 1025864785, 715858720, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-13', 643225068, 836272809, 'Photo', 641791613)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-14', 58176764, 715858720, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-15', 579752096, 922175824, 'Photo', 901494828)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-16', 403621919, 36387325, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-17', 52507959, 715858720, 'Photo', 155709414)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-18', 532021396, 836272809, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-19', 671271512, 746868371, 'Photo', 1032490823)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2006-08-20', 750500230, 836272809, 'Photo', 149932228)
  Fixture Insert (0.1ms)  INSERT INTO "taggings" ("created_at", "id", "tag_id", "taggable_type", "taggable_id") VALUES ('2007-08-25', 460040280, 746868371, 'Magazine', 207281424)
  Fixture Delete (0.1ms)  DELETE FROM "tags"
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Very good', 746868371)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Bad', 36387325)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Nature', 836272809)
  Fixture Insert (0.1ms)  INSERT INTO "tags" ("name", "id") VALUES ('Question', 922175824)
  Fixture Insert (0.0ms)  INSERT INTO "tags" ("name", "id") VALUES ('Crazy animal', 715858720)
  Fixture Delete (0.1ms)  DELETE FROM "users"
  Fixture Insert (0.1ms)  INSERT INTO "users" ("name", "id") VALUES ('Jonathan', 992924717)
  Fixture Insert (0.0ms)  INSERT INTO "users" ("name", "id") VALUES ('Sam', 638797851)
   (1.1ms)  commit transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.2ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'None' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371, 836272809)
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371, 836272809)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 402210157]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'None') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'None' LIMIT 1
  SQL (0.2ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "None"]]
  SQL (30.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (8.3ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.4ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "one"], ["text", "Test"], ["type", nil], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'one') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'one' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "one"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "One"], ["text", "Test"], ["type", nil], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079735 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'One') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079735], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature'))
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'nature'))
   (20.6ms)  rollback transaction
   (0.1ms)  begin transaction
  Photo Load (0.2ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'CRAZY ANIMAL') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 715858720], ["taggable_id", 901494828], ["taggable_type", "Photo"]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'QUESTION') LIMIT 1
  SQL (0.1ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175824], ["taggable_id", 901494828], ["taggable_type", "Photo"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (1.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (3.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  SAVEPOINT active_record_1
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo' AND "taggings"."tag_id" IN (715858720, 922175824)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (715858720, 922175824)
  SQL (0.2ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 58176764]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 579752096]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (2.7ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = '' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371, 836272809)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371, 836272809)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  SQL (0.0ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 402210157]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (2.9ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND "tags"."name" IN ('Very good', 'Nature') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, One, Two' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'One') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'One' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "One"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Two') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Two' LIMIT 1
  SQL (0.0ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Two"]]
  SQL (0.1ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175826], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 11720439]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 11720439 AND "taggings"."taggable_type" = 'Post'
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 11720439 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.2ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (836272809, 922175824)
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature, Question' WHERE "posts"."id" = 11720439
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (2.3ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.5ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'nature')
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good')
  Tag Load (0.5ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very Good' OR "tags"."name" LIKE 'Nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good' AND "tags"."name" NOT LIKE 'nature')
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good' OR "tags"."name" LIKE 'Nature')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'very good' AND "tags"."name" NOT LIKE 'nature')
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'ABCDEFG')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'abcdefg')
  Tag Load (0.4ms)  SELECT "tags".*, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'HIJKLM')))) GROUP BY "tags".name HAVING ("tags"."name" NOT LIKE 'hijklm')
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE (1=0)
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE (1=0)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature, Beautiful' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Beautiful') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Beautiful' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Beautiful"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (746868371)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (746868371)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 375276568]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
   (1.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) GROUP BY tags.id, tags.name
  User Load (0.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 638797851]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 638797851)) GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE "photos"."user_id" = 992924717)) GROUP BY tags.id, tags.name
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE "photos"."user_id" = 638797851)) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) AND (1=0) GROUP BY tags.id, tags.name
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".taggable_id IN (SELECT "posts".id FROM "posts" WHERE "posts"."user_id" = 992924717)) GROUP BY tags.id, tags.name HAVING COUNT("tags".id) <= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at >= '2006-08-04') GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at <= '2006-08-06') GROUP BY tags.id, tags.name
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' AND ("taggings".created_at >= '2006-08-05') AND ("taggings".created_at <= '2006-08-10') GROUP BY tags.id, tags.name
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".created_at >= '2006-08-12') AND ("taggings".created_at <= '2006-08-19') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 2
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) <= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND (1=1) GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  User Load (0.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 992924717]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.4ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Magazine' AND ("taggings".taggable_id IN (SELECT "magazines".id FROM "magazines" INNER JOIN "subscriptions" ON "magazines"."id" = "subscriptions"."magazine_id" WHERE "subscriptions"."user_id" = 992924717)) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 641791613 AND "taggings"."taggable_type" = 'Photo'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature', 'Crazy animal') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 641791613 AND "taggings"."taggable_type" = 'Photo'
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature', 'Crazy animal') AND (tags.name = 'Crazy animal') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "photos" ("title", "user_id") VALUES (?, ?)  [["title", nil], ["user_id", nil]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1032490824 AND "taggings"."taggable_type" = 'Photo'
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.6ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' AND ("taggings".taggable_id IN (SELECT "photos".id FROM "photos" WHERE (tags.id = 715858720))) GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "Nature"], ["text", "Test"], ["type", "SpecialPost"], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Nature') LIMIT 1
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 836272809], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.1ms)  RELEASE SAVEPOINT active_record_1
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" INNER JOIN "posts" ON "posts".id = "taggings".taggable_id WHERE "taggings"."taggable_type" = 'Post' AND "posts"."type" IN ('SpecialPost') GROUP BY tags.id, tags.name
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Photo' GROUP BY tags.id, tags.name LIMIT 2
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name HAVING COUNT("tags".id) >= 4 LIMIT 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name ORDER BY count desc LIMIT 2
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, Random' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (922175825)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (922175825)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 1025864786]]
   (0.1ms)  SELECT COUNT(*) FROM "taggings" WHERE "taggings"."tag_id" = 922175825
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."tag_id" = 922175825
  SQL (0.1ms)  DELETE FROM "tags" WHERE "tags"."id" = ?  [["id", 922175825]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.5ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
   (0.0ms)  SAVEPOINT active_record_1
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.2ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (2.9ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 155709414 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 901494828 AND "taggings"."taggable_type" = 'Photo'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature, Random' WHERE "posts"."id" = 558545905
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:07 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 558545905], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.0ms)  SAVEPOINT active_record_1
   (0.3ms)  UPDATE "posts" SET "cached_tag_list" = 'Very good, Nature' WHERE "posts"."id" = 558545905
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post' AND "taggings"."tag_id" IN (922175825)
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" IN (922175825)
  SQL (0.1ms)  DELETE FROM "taggings" WHERE "taggings"."id" = ?  [["id", 1025864786]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "tags" 
   (0.5ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 864784826]]
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 1032490823]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 149932228]]
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Photo Load (0.3ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Crazy animal' OR "tags"."name" LIKE 'Bad'))
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Very good' OR "tags"."name" LIKE 'Nature')) AND (1=0)
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 901494828]]
  Photo Load (0.2ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 155709414]]
  Photo Load (0.3ms)  SELECT "photos".* FROM "photos" WHERE ("photos".id NOT IN (SELECT taggings.taggable_id FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_type" = 'Photo' AND "tags"."name" IN ('Nature')))
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 986552065]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 11720439]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 871620845]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 465126566]]
  Post Load (0.4ms)  SELECT "posts".* FROM "posts" WHERE ("posts".id NOT IN (SELECT taggings.taggable_id FROM "taggings" INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_type" = 'Post' AND "tags"."name" IN ('Very good', 'Bad')))
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 149932228]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 1032490823]]
  Photo Load (0.0ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.4ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Nature')) ORDER BY photos.title DESC
  User Load (0.2ms)  SELECT "users".* FROM "users" WHERE "users"."id" IN (638797851, 992924717)
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Photo Load (0.1ms)  SELECT "photos".* FROM "photos" WHERE "photos"."id" = ? LIMIT 1  [["id", 641791613]]
  Photo Load (0.4ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" AS "taggings_0" ON "taggings_0".taggable_id = "photos".id AND "taggings_0".taggable_type = 'Photo' INNER JOIN "tags" AS "tags_0" ON "tags_0".id = "taggings_0".tag_id AND "tags_0".name LIKE 'Nature' INNER JOIN "taggings" AS "taggings_1" ON "taggings_1".taggable_id = "photos".id AND "taggings_1".taggable_type = 'Photo' INNER JOIN "tags" AS "tags_1" ON "tags_1".id = "taggings_1".tag_id AND "tags_1".name LIKE 'Crazy animal'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Post Load (0.0ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 864784826]]
  Post Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" AS "taggings_0" ON "taggings_0".taggable_id = "posts".id AND "taggings_0".taggable_type = 'Post' INNER JOIN "tags" AS "tags_0" ON "tags_0".id = "taggings_0".tag_id AND "tags_0".name LIKE 'Very good' INNER JOIN "taggings" AS "taggings_1" ON "taggings_1".taggable_id = "posts".id AND "taggings_1".taggable_type = 'Post' INNER JOIN "tags" AS "tags_1" ON "tags_1".id = "taggings_1".tag_id AND "tags_1".name LIKE 'Nature'
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'ABCDEFG'))
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'HIJKLM'))
  Photo Load (0.2ms)  SELECT DISTINCT "photos".* FROM "photos" INNER JOIN "taggings" ON "taggings"."taggable_id" = "photos"."id" AND "taggings"."taggable_type" = 'Photo' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'unsaved tag'))
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  INSERT INTO "posts" ("cached_tag_list", "text", "type", "user_id") VALUES (?, ?, ?, ?)  [["cached_tag_list", "Random"], ["text", "Test"], ["type", "SpecialPost"], ["user_id", nil]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1034079734 AND "taggings"."taggable_type" = 'Post'
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE ("tags"."name" LIKE 'Random') LIMIT 1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'Random' LIMIT 1
  SQL (0.1ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "Random"]]
  SQL (0.2ms)  INSERT INTO "taggings" ("created_at", "tag_id", "taggable_id", "taggable_type") VALUES (?, ?, ?, ?)  [["created_at", Sun, 11 Mar 2012 09:05:08 UTC +00:00], ["tag_id", 922175825], ["taggable_id", 1034079734], ["taggable_type", "Post"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
  SpecialPost Load (0.3ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE "posts"."type" IN ('SpecialPost') AND (("tags"."name" LIKE 'Random'))
  Post Load (0.2ms)  SELECT DISTINCT "posts".* FROM "posts" INNER JOIN "taggings" ON "taggings"."taggable_id" = "posts"."id" AND "taggings"."taggable_type" = 'Post' INNER JOIN "tags" ON "tags"."id" = "taggings"."tag_id" WHERE (("tags"."name" LIKE 'Random'))
   (0.5ms)  rollback transaction
   (0.1ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  SAVEPOINT active_record_1
   (0.1ms)  ROLLBACK TO SAVEPOINT active_record_1
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 558545905 AND "taggings"."taggable_type" = 'Post'
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.2ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE (taggings.created_at >= '2006-08-15') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE ("taggings"."created_at" BETWEEN '2006-08-14 23:59:00' AND '4000-01-01 00:00:00') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 715858720]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE (taggings.created_at >= '2006-08-15') GROUP BY tags.id, tags.name
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.0ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = '' LIMIT 1
   (0.0ms)  ROLLBACK TO SAVEPOINT active_record_1
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'My tag' LIMIT 1
  SQL (0.3ms)  INSERT INTO "tags" ("name") VALUES (?)  [["name", "My tag"]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.0ms)  SAVEPOINT active_record_1
  Tag Exists (0.1ms)  SELECT 1 FROM "tags" WHERE "tags"."name" = 'My tag' LIMIT 1
   (0.0ms)  ROLLBACK TO SAVEPOINT active_record_1
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Tagging Load (0.2ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 72034900]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 671271512]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 460040280]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."tag_id" = 746868371
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 601248253]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 403621919]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."tag_id" = 36387325
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.1ms)  SELECT COUNT(*) FROM "taggings" WHERE "taggings"."tag_id" = 746868371
   (0.1ms)  SELECT COUNT(*) FROM "taggings" 
   (0.0ms)  SAVEPOINT active_record_1
  SQL (0.3ms)  DELETE FROM "taggings" WHERE "taggings"."tag_id" = 746868371
  SQL (0.1ms)  DELETE FROM "tags" WHERE "tags"."id" = ?  [["id", 746868371]]
   (0.0ms)  RELEASE SAVEPOINT active_record_1
   (0.1ms)  SELECT COUNT(*) FROM "taggings" 
   (0.4ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tagging Load (0.1ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = 746868371 LIMIT 1
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? LIMIT 1  [["id", 558545905]]
  Tagging Load (0.0ms)  SELECT "taggings".* FROM "taggings" WHERE "taggings"."id" = ? LIMIT 1  [["id", 375276568]]
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = 558545905 LIMIT 1
   (0.0ms)  rollback transaction
   (0.1ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" WHERE "taggings"."taggable_type" = 'Post' GROUP BY tags.id, tags.name
  Tag Load (0.1ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 746868371]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 36387325]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 836272809]]
  Tag Load (0.0ms)  SELECT "tags".* FROM "tags" WHERE "tags"."id" = ? LIMIT 1  [["id", 922175824]]
   (0.1ms)  rollback transaction
   (0.0ms)  begin transaction
  Tag Load (0.3ms)  SELECT "tags".id, "tags".name, COUNT("tags".id) AS count FROM "tags" INNER JOIN "taggings" ON "taggings"."tag_id" = "tags"."id" INNER JOIN "posts" ON "posts".id = "taggings".taggable_id WHERE "taggings"."taggable_type" = 'Post' AND "posts"."type" IN ('SpecialPost') GROUP BY tags.id, tags.name
   (0.0ms)  rollback transaction