Connecting to database specified by database.yml Started GET "/" for 127.0.0.1 at 2013-01-17 21:19:25 +0000 Processing by Blogit::PostsController#index as HTML Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (20.9ms) Completed 500 Internal Server Error in 33ms ActionView::Template::Error (Could not find table 'users'): 1: <%= login_required class: "actions", id: "new_blog_post_link" do %> 2: <%= link_to t(:new_blog_post, scope: 'blogit.posts'), new_post_path %> 3: <% end %> 4: app/controllers/application_controller.rb:9:in `current_user' Rendered /Users/Gavin/.rvm/gems/ruby-1.9.3-p194@KatanaCode/gems/actionpack-3.2.11/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.4ms) Rendered /Users/Gavin/.rvm/gems/ruby-1.9.3-p194@KatanaCode/gems/actionpack-3.2.11/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (0.9ms) Rendered /Users/Gavin/.rvm/gems/ruby-1.9.3-p194@KatanaCode/gems/actionpack-3.2.11/lib/action_dispatch/middleware/templates/rescues/template_error.erb within rescues/layout (10.2ms) Connecting to database specified by database.yml  (0.1ms) select sqlite_version(*)  (2.9ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)  (2.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" Migrating to CreateUsers (20110814091304)  (0.0ms) begin transaction  (0.4ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "password" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110814091304')  (10.3ms) commit transaction Migrating to CreateBlogPosts (20110814091434)  (0.1ms) begin transaction  (0.4ms) CREATE TABLE "blog_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "body" text NOT NULL, "blogger_id" integer, "blogger_type" varchar(255), "comments_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  (0.1ms) CREATE INDEX "index_blog_posts_on_blogger_type_and_blogger_id" ON "blog_posts" ("blogger_type", "blogger_id")  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110814091434')  (2.5ms) commit transaction Migrating to CreateBlogComments (20110814093229)  (0.0ms) begin transaction  (0.4ms) CREATE TABLE "blog_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "email" varchar(255) NOT NULL, "website" varchar(255), "body" text NOT NULL, "post_id" integer NOT NULL, "state" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) CREATE INDEX "index_blog_comments_on_post_id" ON "blog_comments" ("post_id")  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110814093229')  (7.7ms) commit transaction Migrating to ActsAsTaggableOnMigration (20110814103306)  (0.0ms) begin transaction  (0.3ms) CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))  (0.1ms) CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(255), "created_at" datetime)   (0.1ms) CREATE INDEX "index_taggings_on_tag_id" ON "taggings" ("tag_id")  (0.1ms) CREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")  (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110814103306')  (3.7ms) commit transaction Migrating to CreatePeople (20110819103335)  (0.0ms) begin transaction  (0.8ms) CREATE TABLE "people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110819103335')  (5.0ms) commit transaction  (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" Connecting to database specified by database.yml Started GET "/" for 127.0.0.1 at 2013-01-17 21:19:56 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_empty.html.erb (9.2ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts"  Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (20.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (90.9ms) Compiled blogit/index.css (0ms) (pid 36676) Compiled application.css (0ms) (pid 36676) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1 Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Compiled jquery.js (2ms) (pid 36676) Compiled jquery_ujs.js (1ms) (pid 36676) Compiled application.js (112ms) (pid 36676) Compiled blogit/archive.js (0ms) (pid 36676) Compiled blogit/index.js (20ms) (pid 36676) Completed 200 OK in 517ms (Views: 514.3ms | ActiveRecord: 1.4ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /jquery.js - 304 Not Modified (37ms) Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /application.js - 200 OK (7ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /jquery_ujs.js - 304 Not Modified (2ms) Started GET "/assets/blogit/index.css?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /blogit/index.css - 200 OK (2ms) Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /application.css - 200 OK (3ms) Started GET "/assets/blogit/archive.js?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /blogit/archive.js - 200 OK (8ms) Started GET "/assets/blogit/index.js?body=1" for 127.0.0.1 at 2013-01-17 21:19:57 +0000 Served asset /blogit/index.js - 200 OK (16ms) Started GET "/session/new" for 127.0.0.1 at 2013-01-17 21:20:02 +0000 Processing by SessionsController#new as HTML Rendered sessions/new.html.erb within layouts/application (9.2ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1 Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 35ms (Views: 34.3ms | ActiveRecord: 0.3ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:20:02 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:20:02 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Connecting to database specified by database.yml Connecting to database specified by database.yml Started GET "/session" for 127.0.0.1 at 2013-01-17 21:21:08 +0000 ActionController::RoutingError (No route matches [GET] "/session"): actionpack (3.2.11) lib/action_dispatch/middleware/debug_exceptions.rb:21:in `call' actionpack (3.2.11) lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' railties (3.2.11) lib/rails/rack/logger.rb:32:in `call_app' railties (3.2.11) lib/rails/rack/logger.rb:16:in `block in call' activesupport (3.2.11) lib/active_support/tagged_logging.rb:22:in `tagged' railties (3.2.11) lib/rails/rack/logger.rb:16:in `call' actionpack (3.2.11) lib/action_dispatch/middleware/request_id.rb:22:in `call' rack (1.4.4) lib/rack/methodoverride.rb:21:in `call' rack (1.4.4) lib/rack/runtime.rb:17:in `call' activesupport (3.2.11) lib/active_support/cache/strategy/local_cache.rb:72:in `call' rack (1.4.4) lib/rack/lock.rb:15:in `call' actionpack (3.2.11) lib/action_dispatch/middleware/static.rb:62:in `call' railties (3.2.11) lib/rails/engine.rb:479:in `call' railties (3.2.11) lib/rails/application.rb:223:in `call' rack (1.4.4) lib/rack/content_length.rb:14:in `call' railties (3.2.11) lib/rails/rack/log_tailer.rb:17:in `call' rack (1.4.4) lib/rack/handler/webrick.rb:59:in `service' /Users/Gavin/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:138:in `service' /Users/Gavin/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/httpserver.rb:94:in `run' /Users/Gavin/.rvm/rubies/ruby-1.9.3-p194/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' Rendered /Users/Gavin/.rvm/gems/ruby-1.9.3-p194@KatanaCode/gems/actionpack-3.2.11/lib/action_dispatch/middleware/templates/rescues/routing_error.erb within rescues/layout (6.0ms) Started GET "/" for 127.0.0.1 at 2013-01-17 21:21:13 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_empty.html.erb (8.8ms)  (0.1ms) SELECT COUNT(*) FROM "blog_posts"  Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (3.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (35.6ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1 Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 98ms (Views: 95.3ms | ActiveRecord: 1.3ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:13 +0000 Served asset /jquery_ujs.js - 304 Not Modified (3ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:13 +0000 Served asset /jquery.js - 304 Not Modified (2ms) Started GET "/session/new" for 127.0.0.1 at 2013-01-17 21:21:15 +0000 Processing by SessionsController#new as HTML Rendered sessions/new.html.erb within layouts/application (2.7ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" IS NULL LIMIT 1 Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 16ms (Views: 15.2ms | ActiveRecord: 0.3ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:15 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:15 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started POST "/session" for 127.0.0.1 at 2013-01-17 21:21:18 +0000 Processing by SessionsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "session"=>{"username"=>"gavinmorrice", "password"=>"[FILTERED]"}, "commit"=>"Log in"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."username" = 'gavinmorrice' AND "users"."password" = 'password' LIMIT 1 Redirected to http://localhost:3000/ Completed 302 Found in 10ms (ActiveRecord: 0.2ms) Started GET "/" for 127.0.0.1 at 2013-01-17 21:21:18 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_empty.html.erb (0.1ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts"  Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (24.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (29.1ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 41ms (Views: 39.5ms | ActiveRecord: 0.7ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:18 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:18 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/new" for 127.0.0.1 at 2013-01-17 21:21:21 +0000 Processing by Blogit::PostsController#new as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (69.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (84.2ms) Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 170ms (Views: 91.0ms | ActiveRecord: 1.0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:21 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:21 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:21:33 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"Test Blog Post", "body"=>"osfjaos fjasofdja osfjd aosidfj aosidfj aoisj", "tag_list"=>"one, two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.0ms) begin transaction SQL (10.1ms) INSERT INTO "blog_posts" ("blogger_id", "blogger_type", "body", "comments_count", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["blogger_id", 1], ["blogger_type", "User"], ["body", "osfjaos fjasofdja osfjd aosidfj aosidfj aoisj"], ["comments_count", 0], ["created_at", Thu, 17 Jan 2013 21:21:33 UTC +00:00], ["title", "Test Blog Post"], ["updated_at", Thu, 17 Jan 2013 21:21:33 UTC +00:00]] ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one' OR lower(name) = 'two' OR lower(name) = 'three') ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'one' LIMIT 1 SQL (0.1ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "one"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'two' LIMIT 1 SQL (0.0ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "two"]] ActsAsTaggableOn::Tag Exists (0.1ms) SELECT 1 AS one FROM "tags" WHERE "tags"."name" = 'three' LIMIT 1 SQL (0.0ms) INSERT INTO "tags" ("name") VALUES (?) [["name", "three"]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:21:33 UTC +00:00], ["tag_id", 1], ["taggable_id", 1], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:21:33 UTC +00:00], ["tag_id", 2], ["taggable_id", 1], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 1 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:21:33 UTC +00:00], ["tag_id", 3], ["taggable_id", 1], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts"  (3.1ms) commit transaction Redirected to http://localhost:3000/blog/posts/1-test-blog-post Completed 302 Found in 183ms (ActiveRecord: 15.3ms) Started GET "/blog/posts/1-test-blog-post" for 127.0.0.1 at 2013-01-17 21:21:33 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"1-test-blog-post"} Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "1-test-blog-post"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (1.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (1.0ms) User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (3.3ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (2.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (35.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.9ms) ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.2ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 1 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('one','two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (5.9ms) Rendered blogit/posts/_post_footer.html.erb (7.7ms) Blogit::Comment Load (0.2ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 1 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (5.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (10.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (107.2ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 116ms (Views: 113.7ms | ActiveRecord: 1.5ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:34 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:34 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/tagged/one" for 127.0.0.1 at 2013-01-17 21:21:47 +0000 Processing by Blogit::PostsController#tagged as HTML Parameters: {"tag"=>"one"} ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one') User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" JOIN taggings posts_taggings_3b091e3 ON posts_taggings_3b091e3.taggable_id = blog_posts.id AND posts_taggings_3b091e3.taggable_type = 'Blogit::Post' AND posts_taggings_3b091e3.tag_id = 1 LIMIT 5 OFFSET 0) subquery_for_count Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" JOIN taggings posts_taggings_3b091e3 ON posts_taggings_3b091e3.taggable_id = blog_posts.id AND posts_taggings_3b091e3.taggable_type = 'Blogit::Post' AND posts_taggings_3b091e3.tag_id = 1 ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.1ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (21.7ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts" JOIN taggings posts_taggings_3b091e3 ON posts_taggings_3b091e3.taggable_id = blog_posts.id AND posts_taggings_3b091e3.taggable_type = 'Blogit::Post' AND posts_taggings_3b091e3.tag_id = 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (2.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (30.1ms) Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 95ms (Views: 37.0ms | ActiveRecord: 1.1ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:47 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:21:47 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Connecting to database specified by database.yml Started GET "/blog/posts/tagged/one" for 127.0.0.1 at 2013-01-17 21:24:00 +0000 Processing by Blogit::PostsController#tagged as HTML Parameters: {"tag"=>"one"} ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one') User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" JOIN taggings posts_taggings_95370d8 ON posts_taggings_95370d8.taggable_id = blog_posts.id AND posts_taggings_95370d8.taggable_type = 'Blogit::Post' AND posts_taggings_95370d8.tag_id = 1 LIMIT 5 OFFSET 0) subquery_for_count  Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" JOIN taggings posts_taggings_95370d8 ON posts_taggings_95370d8.taggable_id = blog_posts.id AND posts_taggings_95370d8.taggable_type = 'Blogit::Post' AND posts_taggings_95370d8.tag_id = 1 ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (2.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.7ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (15.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (26.4ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts" JOIN taggings posts_taggings_95370d8 ON posts_taggings_95370d8.taggable_id = blog_posts.id AND posts_taggings_95370d8.taggable_type = 'Blogit::Post' AND posts_taggings_95370d8.tag_id = 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (4.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (142.5ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 326ms (Views: 207.0ms | ActiveRecord: 2.1ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:01 +0000 Served asset /jquery_ujs.js - 304 Not Modified (1ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:01 +0000 Served asset /jquery.js - 304 Not Modified (2ms) Started GET "/blog/posts/1-test-blog-post" for 127.0.0.1 at 2013-01-17 21:24:05 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"1-test-blog-post"} Blogit::Post Load (0.4ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "1-test-blog-post"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (2.6ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (6.1ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (8.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (33.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.9ms) ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.3ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 1 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('one','two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (60.3ms) Rendered blogit/posts/_post_footer.html.erb (73.1ms) Blogit::Comment Load (0.2ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 1 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (5.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (13.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (171.3ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 183ms (Views: 180.0ms | ActiveRecord: 1.8ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:05 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:05 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/" for 127.0.0.1 at 2013-01-17 21:24:30 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count  Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (2.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (16.9ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts" Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (2.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (31.8ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 48ms (Views: 43.5ms | ActiveRecord: 0.8ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:30 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:30 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/new" for 127.0.0.1 at 2013-01-17 21:24:32 +0000 Processing by Blogit::PostsController#new as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (12.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (29.1ms) Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 42ms (Views: 38.1ms | ActiveRecord: 0.6ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:32 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:32 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:24:45 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"sadfiasjf oasijfd", "body"=>"oijsafo iajsodf ijaosidfj", "tag_list"=>"one, two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.0ms) begin transaction SQL (0.8ms) INSERT INTO "blog_posts" ("blogger_id", "blogger_type", "body", "comments_count", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["blogger_id", 1], ["blogger_type", "User"], ["body", "oijsafo iajsodf ijaosidfj"], ["comments_count", 0], ["created_at", Thu, 17 Jan 2013 21:24:45 UTC +00:00], ["title", "sadfiasjf oasijfd"], ["updated_at", Thu, 17 Jan 2013 21:24:45 UTC +00:00]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one' OR lower(name) = 'two' OR lower(name) = 'three') ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.4ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:24:45 UTC +00:00], ["tag_id", 1], ["taggable_id", 2], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:24:45 UTC +00:00], ["tag_id", 2], ["taggable_id", 2], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 2 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:24:45 UTC +00:00], ["tag_id", 3], ["taggable_id", 2], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts"   (4.9ms) commit transaction Redirected to http://localhost:3000/blog/posts/2-sadfiasjf-oasijfd Completed 302 Found in 90ms (ActiveRecord: 7.3ms) Started GET "/blog/posts/2-sadfiasjf-oasijfd" for 127.0.0.1 at 2013-01-17 21:24:45 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"2-sadfiasjf-oasijfd"} Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "2-sadfiasjf-oasijfd"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (2.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (8.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.2ms) ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.3ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 2 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('one','two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (5.8ms) Rendered blogit/posts/_post_footer.html.erb (6.6ms) Blogit::Comment Load (0.1ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 2 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (3.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (5.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (24.3ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 34ms (Views: 31.7ms | ActiveRecord: 1.2ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:45 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:45 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/" for 127.0.0.1 at 2013-01-17 21:24:46 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (1.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.9ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.4ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (5.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (25.2ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts" Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (5.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (35.7ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 46ms (Views: 44.3ms | ActiveRecord: 0.9ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:46 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:46 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/new" for 127.0.0.1 at 2013-01-17 21:24:47 +0000 Processing by Blogit::PostsController#new as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (5.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (9.4ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 23ms (Views: 20.4ms | ActiveRecord: 0.6ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:47 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:47 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:24:58 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"ASDfpasf kapsodfk apsodfka", "body"=>"pokfaspdfo kaspod fkapsdfk apsdfok apsdfkapsdofk paodkf psodkf apsodkfa posdkf", "tag_list"=>"one, two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.0ms) begin transaction SQL (2.4ms) INSERT INTO "blog_posts" ("blogger_id", "blogger_type", "body", "comments_count", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["blogger_id", 1], ["blogger_type", "User"], ["body", "pokfaspdfo kaspod fkapsdfk apsdfok apsdfkapsdofk paodkf psodkf apsodkfa posdkf"], ["comments_count", 0], ["created_at", Thu, 17 Jan 2013 21:24:58 UTC +00:00], ["title", "ASDfpasf kapsodfk apsodfka"], ["updated_at", Thu, 17 Jan 2013 21:24:58 UTC +00:00]] ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one' OR lower(name) = 'two' OR lower(name) = 'three') ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 3 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:24:58 UTC +00:00], ["tag_id", 1], ["taggable_id", 3], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 3 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:24:58 UTC +00:00], ["tag_id", 2], ["taggable_id", 3], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (2.8ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 3 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:24:58 UTC +00:00], ["tag_id", 3], ["taggable_id", 3], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts"   (62.0ms) commit transaction Redirected to http://localhost:3000/blog/posts/3-asdfpasf-kapsodfk-apsodfka Completed 302 Found in 100ms (ActiveRecord: 68.7ms) Started GET "/blog/posts/3-asdfpasf-kapsodfk-apsodfka" for 127.0.0.1 at 2013-01-17 21:24:59 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"3-asdfpasf-kapsodfk-apsodfka"} Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "3-asdfpasf-kapsodfk-apsodfka"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (2.3ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (8.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.2ms) ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.3ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 3 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('one','two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (5.3ms) Rendered blogit/posts/_post_footer.html.erb (6.1ms) Blogit::Comment Load (0.1ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 3 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (3.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (5.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (22.8ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 33ms (Views: 31.5ms | ActiveRecord: 1.1ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:59 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:24:59 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/" for 127.0.0.1 at 2013-01-17 21:25:12 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count Blogit::Post Load (0.4ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.9ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (2.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (3.7ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (33.4ms)  (0.1ms) SELECT COUNT(*) FROM "blog_posts"  Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (3.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (44.0ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 55ms (Views: 53.0ms | ActiveRecord: 1.2ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:12 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:12 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/new" for 127.0.0.1 at 2013-01-17 21:25:18 +0000 Processing by Blogit::PostsController#new as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (7.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (8.4ms) Blogit::Post Load (0.3ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 27ms (Views: 24.6ms | ActiveRecord: 0.7ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:18 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:18 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:25:28 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"Afo aisdjf oasijdfao sidfjasdf ", "body"=>"aosdfj aosdifj asoidfj aosidfj aosdfija osfjweoifjao widjf oasijfd asd", "tag_list"=>"one, two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.3ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.1ms) begin transaction SQL (0.6ms) INSERT INTO "blog_posts" ("blogger_id", "blogger_type", "body", "comments_count", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["blogger_id", 1], ["blogger_type", "User"], ["body", "aosdfj aosdifj asoidfj aosidfj aosdfija osfjweoifjao widjf oasijfd asd"], ["comments_count", 0], ["created_at", Thu, 17 Jan 2013 21:25:28 UTC +00:00], ["title", "Afo aisdjf oasijdfao sidfjasdf "], ["updated_at", Thu, 17 Jan 2013 21:25:28 UTC +00:00]] ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one' OR lower(name) = 'two' OR lower(name) = 'three') ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 4 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 4 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:25:28 UTC +00:00], ["tag_id", 1], ["taggable_id", 4], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 4 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:25:28 UTC +00:00], ["tag_id", 2], ["taggable_id", 4], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 4 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:25:28 UTC +00:00], ["tag_id", 3], ["taggable_id", 4], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts"  (6.4ms) commit transaction Redirected to http://localhost:3000/blog/posts/4-afo-aisdjf-oasijdfao-sidfjasdf Completed 302 Found in 30ms (ActiveRecord: 8.7ms) Started GET "/blog/posts/4-afo-aisdjf-oasijdfao-sidfjasdf" for 127.0.0.1 at 2013-01-17 21:25:28 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"4-afo-aisdjf-oasijdfao-sidfjasdf"} Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "4-afo-aisdjf-oasijdfao-sidfjasdf"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (2.7ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (8.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.2ms) ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 4 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 4 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.4ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 4 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('one','two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (6.8ms) Rendered blogit/posts/_post_footer.html.erb (7.6ms) Blogit::Comment Load (0.2ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 4 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (3.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (6.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (26.3ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 36ms (Views: 34.0ms | ActiveRecord: 1.3ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:28 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:28 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/" for 127.0.0.1 at 2013-01-17 21:25:29 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.3ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count  Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (3.6ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (5.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (1.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (3.4ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.3ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (2.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.9ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (53.6ms)  (0.1ms) SELECT COUNT(*) FROM "blog_posts"  Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (2.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (61.6ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 119ms (Views: 117.1ms | ActiveRecord: 1.0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:29 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:29 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/new" for 127.0.0.1 at 2013-01-17 21:25:31 +0000 Processing by Blogit::PostsController#new as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.3ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (5.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (6.4ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 19ms (Views: 16.1ms | ActiveRecord: 0.7ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:31 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:31 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:25:48 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"Lorem ipsum", "body"=>"lorem oiasjf oasjdfs aoidfjs aoidjf aosidjf aosidjfa osidjfasodifj asodi jfaosidf", "tag_list"=>"one, two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.0ms) begin transaction SQL (0.6ms) INSERT INTO "blog_posts" ("blogger_id", "blogger_type", "body", "comments_count", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["blogger_id", 1], ["blogger_type", "User"], ["body", "lorem oiasjf oasjdfs aoidfjs aoidjf aosidjf aosidjfa osidjfasodifj asodi jfaosidf"], ["comments_count", 0], ["created_at", Thu, 17 Jan 2013 21:25:48 UTC +00:00], ["title", "Lorem ipsum"], ["updated_at", Thu, 17 Jan 2013 21:25:48 UTC +00:00]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'one' OR lower(name) = 'two' OR lower(name) = 'three') ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 5 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 1 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 5 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:25:48 UTC +00:00], ["tag_id", 1], ["taggable_id", 5], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 5 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.1ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:25:48 UTC +00:00], ["tag_id", 2], ["taggable_id", 5], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 5 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (1.7ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:25:48 UTC +00:00], ["tag_id", 3], ["taggable_id", 5], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts"  (3.1ms) commit transaction Redirected to http://localhost:3000/blog/posts/5-lorem-ipsum Completed 302 Found in 32ms (ActiveRecord: 6.7ms) Started GET "/blog/posts/5-lorem-ipsum" for 127.0.0.1 at 2013-01-17 21:25:48 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"5-lorem-ipsum"} Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "5-lorem-ipsum"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (2.0ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (7.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.2ms) ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 5 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 5 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.3ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 5 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('one','two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (6.3ms) Rendered blogit/posts/_post_footer.html.erb (7.6ms) Blogit::Comment Load (0.1ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 5 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (3.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (4.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (23.6ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 34ms (Views: 31.9ms | ActiveRecord: 1.1ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:48 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:48 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/blog/" for 127.0.0.1 at 2013-01-17 21:25:51 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count  Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (1.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (4.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (4.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.8ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.5ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (3.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (1.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.4ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.3ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (60.2ms)  (0.2ms) SELECT COUNT(*) FROM "blog_posts" Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (2.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (67.8ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 78ms (Views: 76.6ms | ActiveRecord: 0.9ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:52 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:52 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/new" for 127.0.0.1 at 2013-01-17 21:25:53 +0000 Processing by Blogit::PostsController#new as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.3ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (5.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (6.1ms) Blogit::Post Load (0.3ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 22ms (Views: 19.4ms | ActiveRecord: 0.7ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:53 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:25:53 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:26:06 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"aosdifj aosidfjaoiejfw oaijrf oisjfoasifdj aosidfjoasdfj aosdifjaosidfjaosi dfj", "body"=>"ASfd oaijdfo asdijfas oidfj aoijfa sodifj asodifj saodif jasoidfj", "tag_list"=>"two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.0ms) begin transaction  (0.0ms) rollback transaction Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_form.html.erb (5.1ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/new.html.erb within layouts/application (6.7ms) Blogit::Post Load (0.6ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 34ms (Views: 27.0ms | ActiveRecord: 1.0ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:06 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:06 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started POST "/blog/posts" for 127.0.0.1 at 2013-01-17 21:26:10 +0000 Processing by Blogit::PostsController#create as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"dGyZ8iVO5GJw2ZCrtka6SKgx2EigsKtjCY8+sKz7YWY=", "post"=>{"title"=>"aosdifj aosidfjaoiejfw oaijrf oisjfoasifdj aosidfjoasdfj", "body"=>"ASfd oaijdfo asdijfas oidfj aoijfa sodifj asodifj saodif jasoidfj", "tag_list"=>"two, three"}, "commit"=>"Create Post"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" IS NULL AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)  (0.0ms) begin transaction SQL (0.5ms) INSERT INTO "blog_posts" ("blogger_id", "blogger_type", "body", "comments_count", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?, ?, ?) [["blogger_id", 1], ["blogger_type", "User"], ["body", "ASfd oaijdfo asdijfas oidfj aoijfa sodifj asodifj saodif jasoidfj"], ["comments_count", 0], ["created_at", Thu, 17 Jan 2013 21:26:10 UTC +00:00], ["title", "aosdifj aosidfjaoiejfw oaijrf oisjfoasifdj aosidfjoasdfj"], ["updated_at", Thu, 17 Jan 2013 21:26:10 UTC +00:00]] ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" WHERE (lower(name) = 'two' OR lower(name) = 'three') ActsAsTaggableOn::Tag Load (0.1ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 6 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) ActsAsTaggableOn::Tagging Exists (0.1ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 2 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 6 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.3ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:26:10 UTC +00:00], ["tag_id", 2], ["taggable_id", 6], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] ActsAsTaggableOn::Tagging Exists (0.2ms) SELECT 1 AS one FROM "taggings" WHERE ("taggings"."tag_id" = 3 AND "taggings"."taggable_type" = 'Blogit::Post' AND "taggings"."taggable_id" = 6 AND "taggings"."context" = 'tags' AND "taggings"."tagger_id" IS NULL AND "taggings"."tagger_type" IS NULL) LIMIT 1 SQL (0.2ms) INSERT INTO "taggings" ("context", "created_at", "tag_id", "taggable_id", "taggable_type", "tagger_id", "tagger_type") VALUES (?, ?, ?, ?, ?, ?, ?) [["context", "tags"], ["created_at", Thu, 17 Jan 2013 21:26:10 UTC +00:00], ["tag_id", 3], ["taggable_id", 6], ["taggable_type", "Blogit::Post"], ["tagger_id", nil], ["tagger_type", nil]] Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts"  (3.0ms) commit transaction Redirected to http://localhost:3000/blog/posts/6-aosdifj-aosidfjaoiejfw-oaijrf-oisjfoasifdj-aosidfjoasdfj Completed 302 Found in 32ms (ActiveRecord: 4.9ms) Started GET "/blog/posts/6-aosdifj-aosidfjaoiejfw-oaijrf-oisjfoasifdj-aosidfjoasdfj" for 127.0.0.1 at 2013-01-17 21:26:10 +0000 Processing by Blogit::PostsController#show as HTML Parameters: {"id"=>"6-aosdifj-aosidfjaoiejfw-oaijrf-oisjfoasifdj-aosidfjoasdfj"} Blogit::Post Load (0.1ms) SELECT "blog_posts".* FROM "blog_posts" WHERE "blog_posts"."id" = ? LIMIT 1 [["id", "6-aosdifj-aosidfjaoiejfw-oaijrf-oisjfoasifdj-aosidfjoasdfj"]] Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (10.3ms) User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (2.9ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (20.2ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_share_bar.html.erb (0.2ms) ActsAsTaggableOn::Tag Load (0.2ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 6 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) CACHE (0.0ms) SELECT "tags".* FROM "tags" INNER JOIN "taggings" ON "tags"."id" = "taggings"."tag_id" WHERE "taggings"."taggable_id" = 6 AND "taggings"."taggable_type" = 'Blogit::Post' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL) Blogit::Post Load (0.3ms) SELECT blog_posts.*, COUNT(tags.id) AS count FROM blog_posts, tags, taggings WHERE (blog_posts.id != 6 AND blog_posts.id = taggings.taggable_id AND taggings.taggable_type = 'Blogit::Post' AND taggings.tag_id = tags.id AND tags.name IN ('two','three')) GROUP BY blog_posts.id ORDER BY count DESC Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_related.html.erb (6.5ms) Rendered blogit/posts/_post_footer.html.erb (9.7ms) Blogit::Comment Load (0.1ms) SELECT "blog_comments".* FROM "blog_comments" WHERE "blog_comments"."post_id" = 6 Rendered collection (0.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/comments/_form.html.erb (3.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_active_record_comments.html.erb (4.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/show.html.erb within layouts/application (41.5ms) Blogit::Post Load (0.3ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 55ms (Views: 52.8ms | ActiveRecord: 1.2ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:11 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:11 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/" for 127.0.0.1 at 2013-01-17 21:26:14 +0000 Processing by Blogit::PostsController#index as HTML User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 0) subquery_for_count  Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 0 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.9ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.4ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (2.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.3ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.3ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.2ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (2.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (40.6ms)  (0.1ms) SELECT COUNT(*) FROM "blog_posts" Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (14.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (131.1ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 142ms (Views: 140.6ms | ActiveRecord: 0.9ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:14 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:14 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/page/2" for 127.0.0.1 at 2013-01-17 21:26:17 +0000 Processing by Blogit::PostsController#index as HTML Parameters: {"page"=>"2"} User Load (1.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 5) subquery_for_count  Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 5 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (2.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.4ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.8ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (21.9ms)  (0.1ms) SELECT COUNT(*) FROM "blog_posts" Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (201.8ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (232.5ms) Blogit::Post Load (0.3ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 246ms (Views: 242.9ms | ActiveRecord: 2.2ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:17 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:26:17 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/blog/posts/page/2" for 127.0.0.1 at 2013-01-17 21:30:06 +0000 Processing by Blogit::PostsController#index as HTML Parameters: {"page"=>"2"} User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1  (0.2ms) SELECT COUNT(count_column) FROM (SELECT 1 AS count_column FROM "blog_posts" LIMIT 5 OFFSET 5) subquery_for_count  Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC LIMIT 5 OFFSET 5 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_head.html.erb (0.7ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_body.html.erb (0.6ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post_links.html.erb (1.3ms) CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_blogger_information.html.erb (1.5ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_post.html.erb (11.7ms)  (0.1ms) SELECT COUNT(*) FROM "blog_posts" Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/_pagination.html.erb (9.0ms) Rendered /Users/Gavin/Gems/blogit/app/views/blogit/posts/index.html.erb within layouts/application (25.8ms) Blogit::Post Load (0.2ms) SELECT "blog_posts".* FROM "blog_posts" ORDER BY created_at DESC Completed 200 OK in 47ms (Views: 42.5ms | ActiveRecord: 0.9ms) Started GET "/assets/blogit/index.css?body=1" for 127.0.0.1 at 2013-01-17 21:30:06 +0000 Served asset /blogit/index.css - 304 Not Modified (16ms) Started GET "/assets/blogit/archive.js?body=1" for 127.0.0.1 at 2013-01-17 21:30:07 +0000 Served asset /blogit/archive.js - 304 Not Modified (4ms) Started GET "/assets/jquery.js?body=1" for 127.0.0.1 at 2013-01-17 21:30:07 +0000 Served asset /jquery.js - 304 Not Modified (0ms) Started GET "/assets/jquery_ujs.js?body=1" for 127.0.0.1 at 2013-01-17 21:30:07 +0000 Served asset /jquery_ujs.js - 304 Not Modified (0ms) Started GET "/assets/application.js?body=1" for 127.0.0.1 at 2013-01-17 21:30:07 +0000 Served asset /application.js - 304 Not Modified (4ms) Started GET "/assets/application.css?body=1" for 127.0.0.1 at 2013-01-17 21:30:07 +0000 Served asset /application.css - 304 Not Modified (5ms) Started GET "/assets/blogit/index.js?body=1" for 127.0.0.1 at 2013-01-17 21:30:07 +0000 Served asset /blogit/index.js - 304 Not Modified (4ms)