New - Pastie

Language:

## mark a section (Learn more)

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]