gistfile1.txt

Started GET "/dashboard" for 127.0.0.1 at Fri Jun 15 16:00:51 -0700 2012
Processing by DashboardController#index as HTML
  User Load (0.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1
  Project Load (0.5ms)  SELECT "projects".* FROM "projects" 
  Project Load (2.5ms)  SELECT "projects".* FROM "projects" INNER JOIN "project_revisions" ON "project_revisions"."project_id" = "projects"."id" INNER JOIN "reviews" ON "reviews"."project_revision_id" = "project_revisions"."id" WHERE "projects"."user_id" = 2 GROUP BY projects.id, projects.user_id, projects.created_at, projects.updated_at, projects.private, projects.slots, projects.title, projects.description
  Rendered dashboard/_submitter.html.erb (213.0ms)
  Project Load (0.4ms)  SELECT "projects".* FROM "projects" INNER JOIN "project_revisions" ON "project_revisions"."project_id" = "projects"."id" INNER JOIN "reviews" ON "reviews"."project_revision_id" = "project_revisions"."id" WHERE "reviews"."user_id" = 2
  Project Load (1.0ms)  SELECT projects.id, projects.title, projects.user_id, count(reviews.id) as review_count FROM "projects" INNER JOIN "project_revisions" ON "project_revisions"."project_id" = "projects"."id" LEFT JOIN reviews ON reviews.project_revision_id = project_revisions.id WHERE (projects.user_id != 2 AND project_revisions.id NOT IN ( select reviews.project_revision_id from reviews where reviews.user_id = 2 )) GROUP BY projects.id, projects.title, projects.user_id ORDER BY review_count ASC
  ProjectRevision Load (0.6ms)  SELECT "project_revisions".* FROM "project_revisions" WHERE "project_revisions"."project_id" = 3 ORDER BY "project_revisions"."id" DESC LIMIT 1
  Asset Load (0.4ms)  SELECT "assets".* FROM "assets" WHERE "assets"."id" = 3 LIMIT 1
  User Load (0.9ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 11 LIMIT 1
  Rendered dashboard/_project_thumbnail.html.erb (2310.2ms)
  ProjectRevision Load (0.4ms)  SELECT "project_revisions".* FROM "project_revisions" WHERE "project_revisions"."project_id" = 4 ORDER BY "project_revisions"."id" DESC LIMIT 1
  Asset Load (0.3ms)  SELECT "assets".* FROM "assets" WHERE "assets"."id" = 4 LIMIT 1
  CACHE (0.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 11 LIMIT 1
  Rendered dashboard/_project_thumbnail.html.erb (2186.2ms)
  ProjectRevision Load (0.6ms)  SELECT "project_revisions".* FROM "project_revisions" WHERE "project_revisions"."project_id" = 2 ORDER BY "project_revisions"."id" DESC LIMIT 1
  Asset Load (0.3ms)  SELECT "assets".* FROM "assets" WHERE "assets"."id" = 2 LIMIT 1
  User Load (0.7ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 10 LIMIT 1
  Rendered dashboard/_project_thumbnail.html.erb (2183.3ms)
  ProjectRevision Load (0.4ms)  SELECT "project_revisions".* FROM "project_revisions" WHERE "project_revisions"."project_id" = 1 ORDER BY "project_revisions"."id" DESC LIMIT 1
  Asset Load (0.3ms)  SELECT "assets".* FROM "assets" WHERE "assets"."id" = 1 LIMIT 1
  CACHE (0.0ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 10 LIMIT 1
  Rendered dashboard/_project_thumbnail.html.erb (2146.7ms)
  Rendered dashboard/_reviewer.html.erb (9048.6ms)
  Rendered dashboard/index.html.erb within layouts/application (9053.1ms)
  Rendered layouts/_profile_menu.html.erb (2232.1ms)
Completed 200 OK in 11438ms (Views: 11279.8ms | ActiveRecord: 23.5ms)


Started GET "/assets/project_thumbnail.css" for 127.0.0.1 at Fri Jun 15 16:01:03 -0700 2012
RailsDevTweaks: Skipping ActionDispatch::Reloader hooks for this request.
Served asset /project_thumbnail.css - 200 OK (4ms)