SQL_Explanations

Started DELETE "/posts/6" for 127.0.0.1 at 2013-05-20 13:26:50 -0700
Processing by PostsController#destroy as HTML
  Parameters: {"authenticity_token"=>"5qGz0MtZrQK/a7BpEOmZ2/oSuZoWqcArliNZlix5Yqw=", "id"=>"6"}
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" WHERE "posts"."id" = ? ORDER BY posts.created_at DESC LIMIT 1  [["id", "6"]]
   (0.0ms)  begin transaction
  SQL (0.2ms)  DELETE FROM "posts" WHERE "posts"."id" = ?  [["id", 6]]
   (0.8ms)  commit transaction

** selecting post from DB and deleting it (also limits the deleted posts to just the selected post)

Started GET "/" for 127.0.0.1 at 2013-05-20 13:28:41 -0700
Processing by PostsController#index as HTML
  Post Load (0.1ms)  SELECT "posts".* FROM "posts" ORDER BY posts.created_at DESC
  Rendered posts/index.html.erb within layouts/application (0.8ms)
Completed 200 OK in 32ms (Views: 31.3ms | ActiveRecord: 0.1ms)

** This is selecting all posts from the posts table and
** ordering them in descending order by date so we get most recent posts first

   (0.1ms)  begin transaction
  SQL (0.5ms)  INSERT INTO "posts" ("author", "content", "created_at", "title", "updated_at") VALUES (?, ?, ?, ?, ?)  [["author", "Joe"], ["content", "Better than some but not as good as others in the beginning although it is well made, as soon as depends, I would say that better than most of its competitors, next in short, a great phone at the end but generally it feels a little slapdash, after makes compromises until battery life isn’t great but not too bad either.\r\n\r\nCould be the best Android phone, for this reason may well be, prior to possibly whatever only time will tell if it will be successful, for one thing it might just be the best.\r\n\r\nJust about the best, in my opinion and it works reasonably well, such a just pips the iPhone at the post.\r\n\r\nOn the other hand, but while greatest Android tablet released so far this year another point is that if you want an Android phone, this might just be your best bet so as to for that reason we would suggest that you may perhaps possibly want this phone, if it is the sort of phone that you might be looking for, which might be better."], ["created_at", Mon, 20 May 2013 20:28:41 UTC +00:00], ["title", "Trolling continued"], ["updated_at", Mon, 20 May 2013 20:28:41 UTC +00:00]]
   (0.6ms)  commit transaction

** process of creating a post in the posts table
** details the data that was saved to the DB (like author, title, content etc)