Processing PostsController#show (for 127.0.0.1 at 2008-05-01 15:58:52) [GET]
  Session ID: BAh7CToMY3NyZl9pZCIlNDZkYTI4ZWY5MTgwOGM0YWM4MTA0ZTU5OGY4ZmE1%0AZGQ6CXVzZXJpBjoTc2ltcGxlX2NhcHRjaGEiLTQ5ZmEyMjA4MmUwYjI2MzY4%0AMWM4Mjg4NmZmZGI3OTk4YTk0Y2FhYTkiCmZsYXNoSUM6J0FjdGlvbkNvbnRy%0Ab2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7AAY6CkB1c2VkewA%3D--945a8769280097383019732e79112fbcac049e62
  Parameters: {"action"=>"show", "id"=>"1_jtlkjalkjdfljlkadsjflknnannsdakfjlkksadjlfkjjsalj", "controller"=>"posts"}
  Post Columns (0.001423)   SHOW FIELDS FROM `posts`
  User Columns (0.022780)   SHOW FIELDS FROM `users`
  Comment Columns (0.001472)   SHOW FIELDS FROM `comments`
  Post Load Including Associations (0.000241)   SELECT `posts`.`id` AS t0_r0, `posts`.`title` AS t0_r1, `posts`.`body` AS t0_r2, `posts`.`permalink` AS t0_r3, `posts`.`user_id` AS t0_r4, `posts`.`comments_count` AS t0_r5, `posts`.`created_at` AS t0_r6, `posts`.`updated_at` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`salt` AS t1_r3, `users`.`created_at` AS t1_r4, `users`.`updated_at` AS t1_r5, `comments`.`id` AS t2_r0, `comments`.`commentable_id` AS t2_r1, `comments`.`commentable_type` AS t2_r2, `comments`.`root_id` AS t2_r3, `comments`.`parent_id` AS t2_r4, `comments`.`lft` AS t2_r5, `comments`.`rgt` AS t2_r6, `comments`.`depth` AS t2_r7, `comments`.`user_id` AS t2_r8, `comments`.`body` AS t2_r9, `comments`.`deleted` AS t2_r10, `comments`.`votes_count` AS t2_r11, `comments`.`created_at` AS t2_r12, `comments`.`updated_at` AS t2_r13, `ratings`.`id` AS t3_r0, `ratings`.`rating` AS t3_r1, `ratings`.`rateable_type` AS t3_r2, `ratings`.`rateable_id` AS t3_r3, `ratings`.`user_id` AS t3_r4, `ratings`.`created_at` AS t3_r5, `ratings`.`updated_at` AS t3_r6 FROM `posts` LEFT OUTER JOIN `users` ON `users`.id = `posts`.user_id LEFT OUTER JOIN `comments` ON `comments`.commentable_id = `posts`.id AND `comments`.commentable_type = 'Post' LEFT OUTER JOIN `ratings` ON `ratings`.rateable_id = `posts`.id AND `ratings`.rateable_type = 'Post' WHERE (`posts`.`id` = 1) 
  Comment Load Including Associations (0.000224)   SELECT `comments`.`id` AS t0_r0, `comments`.`commentable_id` AS t0_r1, `comments`.`commentable_type` AS t0_r2, `comments`.`root_id` AS t0_r3, `comments`.`parent_id` AS t0_r4, `comments`.`lft` AS t0_r5, `comments`.`rgt` AS t0_r6, `comments`.`depth` AS t0_r7, `comments`.`user_id` AS t0_r8, `comments`.`body` AS t0_r9, `comments`.`deleted` AS t0_r10, `comments`.`votes_count` AS t0_r11, `comments`.`created_at` AS t0_r12, `comments`.`updated_at` AS t0_r13, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`salt` AS t1_r3, `users`.`created_at` AS t1_r4, `users`.`updated_at` AS t1_r5, `ratings`.`id` AS t2_r0, `ratings`.`rating` AS t2_r1, `ratings`.`rateable_type` AS t2_r2, `ratings`.`rateable_id` AS t2_r3, `ratings`.`user_id` AS t2_r4, `ratings`.`created_at` AS t2_r5, `ratings`.`updated_at` AS t2_r6 FROM `comments` LEFT OUTER JOIN `users` ON `users`.id = `comments`.user_id LEFT OUTER JOIN `ratings` ON `ratings`.rateable_id = `comments`.id AND `ratings`.rateable_type = 'Comment' WHERE (comments.commentable_id = 1 AND comments.commentable_type = 'Post') ORDER BY root_id DESC
Rendering template within layouts/application
Rendering posts/show
  User Load (0.000193)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
Rendered ratings/_rate (0.00463)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  Rating Load (0.000194)   SELECT * FROM `ratings` WHERE (( ratings.rateable_id = 1 AND ratings.rateable_type = 'Comment' ) AND ( `ratings`.`user_id` = 1 )) AND (rating > 0) LIMIT 1
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  Rating Load (0.000174)   SELECT * FROM `ratings` WHERE (( ratings.rateable_id = 1 AND ratings.rateable_type = 'Comment' ) AND ( `ratings`.`user_id` = 1 )) AND (rating < 0) LIMIT 1
Rendered ratings/_comment_rate (0.00635)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
Rendered comments/_reply_link (0.00103)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
Rendered comments/_comment (0.01568)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  Rating Load (0.000195)   SELECT * FROM `ratings` WHERE (( ratings.rateable_id = 2 AND ratings.rateable_type = 'Comment' ) AND ( `ratings`.`user_id` = 1 )) AND (rating > 0) LIMIT 1
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  Rating Load (0.000179)   SELECT * FROM `ratings` WHERE (( ratings.rateable_id = 2 AND ratings.rateable_type = 'Comment' ) AND ( `ratings`.`user_id` = 1 )) AND (rating < 0) LIMIT 1
Rendered ratings/_comment_rate (0.00621)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
Rendered comments/_reply_link (0.00095)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
Rendered comments/_edit_link (0.00091)
Rendered comments/_delete_link (0.00057)
Rendered comments/_comment (0.01232)
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
  CACHE (0.000000)   SELECT * FROM `users` WHERE (`users`.`id` = 1) 
Rendered layouts/_menu (0.00034)
Completed in 0.31803 (3 reqs/sec) | Rendering: 0.04165 (13%) | DB: 0.03321 (10%) | 200 OK [http://localhost/posts/1_jtlkjalkjdfljlkadsjflknnannsdakfjlkksadjlfkjjsalj]