logs.sql

Started GET "/h/ajax_notifications?time=1315099321571" for 127.0.0.1 at 2011-09-03 22:22:01 -0300
  Processing by HomeController#ajax_notifications as HTML
  Parameters: {"time"=>"1315099321571"}
  User Load (3.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 3 LIMIT 1
  SQL (1.8ms)  SELECT COUNT(*) FROM "post_user_news" WHERE "post_user_news"."is_read" = 'f' AND ("post_user_news".user_id = 3)
  PostUserNews Load (2.2ms)  SELECT post_id, reason_why, reason_trigger, max(user_id_from) as user_id_from, max(created_at) as created_at, count(*) FROM "post_user_news" WHERE ("post_user_news".user_id = 3) AND (post_id IS NOT NULL) GROUP BY post_id, reason_why, reason_trigger ORDER BY created_at DESC LIMIT 6
Exist fragment? views/ajax_news/unread/0/md5/f11abefe3abe360db37213db1fa93b0c (0.3ms)
Read fragment views/ajax_news/unread/0/md5/f11abefe3abe360db37213db1fa93b0c (0.1ms)
Rendered home/ajax_notifications.html.erb (5.0ms)
Completed 200 OK in 644ms (Views: 9.2ms | ActiveRecord: 20.0ms)


Started GET "/h/ajax_news_button" for 127.0.0.1 at 2011-09-03 22:22:12 -0300
  Processing by HomeController#ajax_news_button as HTML
  User Load (3.9ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 3 LIMIT 1
  Relation Load (1.5ms)  SELECT user2_id FROM "relations" WHERE ("relations".user_id = 3 AND ("relations"."is_follower" = 't'))
  SQL (2.1ms)  SELECT COUNT(*) FROM "posts" WHERE "posts"."user_id" IN (2, 1, 6, 10, 5, 29, 23, 22, 33, 32, 54, 268, 1210, 1871, 1552, 1044, 404, 1908, 2099, 1999, 2505, 2555, 1680, 469, 2713, 3682, 3668, 2786, 3909, 3202, 2985, 3074, 3098, 3329, 4149, 1541, 69, 3) AND (on_timeline = 't') AND (posts.id > 150970) LIMIT 10
Rendered home/ajax_news_button.html.erb (2.3ms)
Completed 200 OK in 783ms (Views: 7.1ms | ActiveRecord: 23.3ms)

schema.rb

  create_table "users", :force => true do |t|
    t.string   "email"
    t.string   "username"
    t.boolean  "email_confirmed",        :default => false
    t.boolean  "username_confirmed",     :default => false
    t.string   "password_digest"
    t.string   "password_salt"
    t.string   "authentication_token"
    t.integer  "user_photo_id"
    t.integer  "user_theme_id"
    t.string   "privileges_string"
    t.string   "relations_count_string"
    t.string   "posts_count_string"
    t.integer  "likes_count",            :default => 0
    t.string   "bio"
    t.string   "website"
    t.string   "first_name"
    t.string   "last_name"
    t.integer  "sex",                    :default => 0
    t.date     "born_at"
    t.boolean  "likes_male",             :default => false
    t.boolean  "likes_female",           :default => false
    t.string   "locale"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "cached_photo_url"
    t.integer  "last_read_post_id"
    t.integer  "born_city_id"
    t.integer  "living_city_id"
  end

  add_index "users", ["email"], :name => "index_users_on_email"
  add_index "users", ["id", "email"], :name => "index_users_on_id_and_email"
  add_index "users", ["id", "username"], :name => "index_users_on_id_and_username"
  add_index "users", ["id"], :name => "index_users_on_id"
  add_index "users", ["username"], :name => "index_users_on_username"