Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/faq WARNING: You're using the Ruby-based MySQL library that ships with Rails. This library is not suited for production. Please install the C-based MySQL library instead (gem install mysql). SQL (0.000143) SET SQL_AUTO_IS_NULL=0 Faq Columns (0.002573) SHOW FIELDS FROM `faqs` default field list: [:bio, :magazines, :books, :user_id, :music, :companies, :television, :skillz, :movies, :schools] Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/user default field list: ["screen_name", "email"] Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/spec Spec Columns (0.002693) SHOW FIELDS FROM `specs` default field list: [:state, :occupation, :zip_code, :user_id, :gender, :first_name, :last_name, :birthdate, :city] SQL (0.000166) BEGIN SQL (0.000164) ROLLBACK SQL (0.000127) BEGIN SQL (0.000126) ROLLBACK SQL (0.000163) BEGIN Faq Load (0.001327) SELECT * FROM `faqs` WHERE (`faqs`.`id` = 1)  SQL (0.000223) ROLLBACK SQL (0.000367) BEGIN User Load (0.000915) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000728) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Friendship Columns (0.002703) SHOW FIELDS FROM `friendships` Friendship Load (0.000745) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Create (0.000308) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'pending', 1, '2008-01-16 10:33:01', 4) Friendship Create (0.000228) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'requested', 4, '2008-01-16 10:33:01', 1) Friendship Load (0.000718) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Update (0.000330) UPDATE `friendships` SET `created_at` = '2008-01-16 10:33:01', `status` = 'accepted', `friend_id` = 4, `user_id` = 1, `accepted_at` = '2008-01-16 10:33:01' WHERE `id` = 1 Friendship Load (0.000701) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 1 AND `friendships`.`user_id` = 4) LIMIT 1 Friendship Update (0.000291) UPDATE `friendships` SET `created_at` = '2008-01-16 10:33:01', `status` = 'accepted', `friend_id` = 1, `user_id` = 4, `accepted_at` = '2008-01-16 10:33:01' WHERE `id` = 2 Friendship Load (0.000696) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Load (0.000776) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Load (0.088827) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 1 AND `friendships`.`user_id` = 4) LIMIT 1 SQL (0.002275) ROLLBACK SQL (0.000164) BEGIN User Load (0.000936) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000744) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Friendship Load (0.000676) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Create (0.000297) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'pending', 1, '2008-01-16 10:33:02', 4) Friendship Create (0.000232) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'requested', 4, '2008-01-16 10:33:02', 1) Friendship Load (0.000692) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Load (0.000645) SELECT * FROM `friendships` WHERE (`friendships`.`id` = 3)  Friendship Destroy (0.000242)  DELETE FROM `friendships` WHERE `id` = 3  Friendship Load (0.000648) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 1 AND `friendships`.`user_id` = 4) LIMIT 1 Friendship Load (0.000638) SELECT * FROM `friendships` WHERE (`friendships`.`id` = 4)  Friendship Destroy (0.000220)  DELETE FROM `friendships` WHERE `id` = 4  Friendship Load (0.000626) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 SQL (0.001019) ROLLBACK SQL (0.000137) BEGIN User Load (0.000753) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000703) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Friendship Load (0.000614) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Create (0.000256) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'pending', 1, '2008-01-16 10:33:02', 4) Friendship Create (0.000224) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'requested', 4, '2008-01-16 10:33:02', 1) Friendship Load (0.000656) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Load (0.000732) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Load (0.000691) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 1 AND `friendships`.`user_id` = 4) LIMIT 1 SQL (0.000994) ROLLBACK SQL (0.000162) BEGIN SQL (0.000158) ROLLBACK SQL (0.000126) BEGIN Spec Load (0.000976) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  Spec Create (0.000283) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 1, '', '') ferret_create/update: Spec : 4 creating doc for class: Spec, id: 4 Adding field state with value '' to index Adding field occupation with value '' to index Adding field zip_code with value '' to index Adding field user_id with value '1' to index Adding field gender with value '' to index Adding field first_name with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Adding field city with value '' to index SQL (0.004334) ROLLBACK SQL (0.000116) BEGIN Spec Load (0.000838) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  SQL (0.000141) ROLLBACK SQL (0.000096) BEGIN Spec Load (0.000690) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  SQL (0.000810) ROLLBACK SQL (0.000108) BEGIN Spec Load (0.000702) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  SQL (0.000210) ROLLBACK SQL (0.000098) BEGIN Spec Load (0.000675) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  SQL (0.000186) ROLLBACK SQL (0.000099) BEGIN Spec Load (0.000723) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  SQL (0.000126) ROLLBACK SQL (0.000097) BEGIN Spec Load (0.000670) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  SQL (0.000127) ROLLBACK SQL (0.000099) BEGIN User Load (0.000535) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000512) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Spec Load (0.000805) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 SQL (0.000159) ROLLBACK SQL (0.000101) BEGIN User Load (0.000568) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000514) SELECT * FROM `users` WHERE (`users`.`id` = 4)  SQL (0.000147) ROLLBACK SQL (0.000104) BEGIN User Load (0.000560) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000515) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000679) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000589) SELECT * FROM `users` WHERE (users.email = 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaram@example.com' AND users.id <> 1) LIMIT 1 SQL (0.000609) ROLLBACK SQL (0.000101) BEGIN User Load (0.000543) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000508) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000743) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000568) SELECT * FROM `users` WHERE (users.email = 'foobar@example.c' AND users.id <> 1) LIMIT 1 User Load (0.000568) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000560) SELECT * FROM `users` WHERE (users.email = '@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000702) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000567) SELECT * FROM `users` WHERE (users.email = 'f@com' AND users.id <> 1) LIMIT 1 User Load (0.000587) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.002403) SELECT * FROM `users` WHERE (users.email = 'foo@bar..com' AND users.id <> 1) LIMIT 1 User Load (0.000601) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000561) SELECT * FROM `users` WHERE (users.email = 'foobar@example.infod' AND users.id <> 1) LIMIT 1 User Load (0.000573) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000563) SELECT * FROM `users` WHERE (users.email = 'foobar.example.com' AND users.id <> 1) LIMIT 1 User Load (0.000574) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000702) SELECT * FROM `users` WHERE (users.email = 'foo,@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000576) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000575) SELECT * FROM `users` WHERE (users.email = 'foo@ex(ample.com' AND users.id <> 1) LIMIT 1 User Load (0.000615) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000563) SELECT * FROM `users` WHERE (users.email = 'foo@example,com' AND users.id <> 1) LIMIT 1 SQL (0.000123) ROLLBACK SQL (0.000097) BEGIN User Load (0.000517) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000513) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000609) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000561) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.com' AND users.id <> 1) LIMIT 1 User Load (0.000568) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000723) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.org' AND users.id <> 1) LIMIT 1 User Load (0.000590) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000587) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.net' AND users.id <> 1) LIMIT 1 User Load (0.000573) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000559) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.edu' AND users.id <> 1) LIMIT 1 User Load (0.000581) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000573) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.es' AND users.id <> 1) LIMIT 1 User Load (0.000567) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000613) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.jp' AND users.id <> 1) LIMIT 1 User Load (0.000560) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000566) SELECT * FROM `users` WHERE (users.email = 'foo.bar_1-9@baz-quux0.example.info' AND users.id <> 1) LIMIT 1 SQL (0.000120) ROLLBACK SQL (0.000097) BEGIN User Load (0.000524) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000506) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000639) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000597) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000581) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000563) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000600) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000568) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000575) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000572) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 SQL (0.000120) ROLLBACK SQL (0.000097) BEGIN User Load (0.000518) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000506) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000782) SELECT * FROM `users` WHERE (users.screen_name = 'aaa' AND users.id <> 1) LIMIT 1 User Load (0.000650) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000643) SELECT * FROM `users` WHERE (users.screen_name = 'aaaa' AND users.id <> 1) LIMIT 1 User Load (0.000571) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000569) SELECT * FROM `users` WHERE (users.screen_name = 'aaaaaaaaaaaaaaaaaaaaa' AND users.id <> 1) LIMIT 1 User Load (0.000580) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000576) SELECT * FROM `users` WHERE (users.screen_name = 'aaaaaaaaaaaaaaaaaaaa' AND users.id <> 1) LIMIT 1 User Load (0.000571) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 SQL (0.000114) ROLLBACK SQL (0.000099) BEGIN User Load (0.000536) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000509) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000568) SELECT * FROM `users` WHERE (users.screen_name = 'rails/rocks' AND users.id <> 1) LIMIT 1 User Load (0.002096) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000649) SELECT * FROM `users` WHERE (users.screen_name = 'web2.0' AND users.id <> 1) LIMIT 1 User Load (0.000587) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000596) SELECT * FROM `users` WHERE (users.screen_name = 'javscript:something' AND users.id <> 1) LIMIT 1 User Load (0.000576) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 SQL (0.000116) ROLLBACK SQL (0.000099) BEGIN User Load (0.000559) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000532) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000597) SELECT * FROM `users` WHERE (users.screen_name = 'aure' AND users.id <> 1) LIMIT 1 User Load (0.000568) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000756) SELECT * FROM `users` WHERE (users.screen_name = 'michael' AND users.id <> 1) LIMIT 1 User Load (0.000583) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Load (0.000565) SELECT * FROM `users` WHERE (users.screen_name = 'web_20' AND users.id <> 1) LIMIT 1 User Load (0.000562) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 SQL (0.000113) ROLLBACK SQL (0.000105) BEGIN User Load (0.000540) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000515) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000542) SELECT * FROM `users` WHERE (users.screen_name = 'millikan') LIMIT 1 User Load (0.000499) SELECT * FROM `users` WHERE (users.email = 'ram@example.com') LIMIT 1 SQL (0.000112) ROLLBACK SQL (0.000082) BEGIN User Load (0.000531) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000577) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000620) SELECT * FROM `users` WHERE (users.screen_name = 'aa/noyes' AND users.id <> 2) LIMIT 1 User Load (0.000572) SELECT * FROM `users` WHERE (users.email = 'anoyes@example,com' AND users.id <> 2) LIMIT 1 SQL (0.000126) ROLLBACK SQL (0.000100) BEGIN User Load (0.000539) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000517) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000588) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000706) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 SQL (0.000110) ROLLBACK Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/user default field list: ["screen_name", "email"] Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/spec WARNING: You're using the Ruby-based MySQL library that ships with Rails. This library is not suited for production. Please install the C-based MySQL library instead (gem install mysql). SQL (0.000168) SET SQL_AUTO_IS_NULL=0 Spec Columns (0.003674) SHOW FIELDS FROM `specs` default field list: [:zip_code, :user_id, :state, :first_name, :city, :occupation, :gender, :last_name, :birthdate] Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/faq Faq Columns (0.003878) SHOW FIELDS FROM `faqs` default field list: [:music, :user_id, :companies, :television, :skillz, :movies, :schools, :bio, :magazines, :books] SQL (0.000170) BEGIN User Load (0.000911) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing AvatarController#upload (for 0.0.0.0 at 2008-01-16 10:33:04) [POST] Session ID: Parameters: {"action"=>"upload", "controller"=>"avatar", "avatar"=>{"image"=>#}} User Load (0.000900) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Redirected to http://test.host/user Completed in 0.07967 (12 reqs/sec) | DB: 0.00970 (12%) | 302 Found [http://test.host/avatar/upload?avatar%5Bimage%5D=%23%3CFile%3A0x36a937c%3E] Processing AvatarController#delete (for 0.0.0.0 at 2008-01-16 10:33:04) [POST] Session ID: Parameters: {"action"=>"delete", "controller"=>"avatar"} User Load (0.000796) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Redirected to http://test.host/user Completed in 0.00162 (617 reqs/sec) | DB: 0.00080 (49%) | 302 Found [http://test.host/avatar/upload?avatar%5Bimage%5D=%23%3CFile%3A0x36a937c%3E] SQL (0.000142) ROLLBACK SQL (0.000140) BEGIN SQL (0.000130) ROLLBACK SQL (0.000134) BEGIN User Load (0.000878) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Comment Load (0.000655) SELECT * FROM `comments` WHERE (`comments`.`id` = 1)  Post Load (0.000674) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  SQL (0.000334) SELECT count(*) AS count_all FROM `comments`  Blog Load (0.000403) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing CommentsController#create (for 0.0.0.0 at 2008-01-16 10:33:04) [POST] Session ID: Parameters: {"action"=>"create", "post_id"=>#, "blog_id"=>#, "controller"=>"comments", "comment"=>{"body"=>"Comment Body", "post_id"=>#, "user_id"=>#}} Post Load (0.000803) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  User Load (0.000811) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Comment Load (0.000737) SELECT * FROM `comments` WHERE (`comments`.`user_id` = 1 AND `comments`.`post_id` = 1 AND `comments`.`body` = 'Comment Body') LIMIT 1 Comment Load (0.000701) SELECT * FROM `comments` WHERE (comments.body = 'Comment Body' AND comments.post_id = 1 AND comments.user_id = 1) LIMIT 1 Comment Create (0.000279) INSERT INTO `comments` (`body`, `post_id`, `user_id`, `created_at`) VALUES('Comment Body', 1, 1, '2008-01-16 10:33:04') Rendering comments/create Comment Load (0.000937) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at User Load (0.000864) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000999) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000428) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000966) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.01199) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00257) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00245) Completed in 0.04011 (24 reqs/sec) | Rendering: 0.02256 (56%) | DB: 0.01102 (27%) | 200 OK [http://test.host/blogs/1/posts/1/comments?comment%5Bbody%5D=Comment+Body&comment%5Bpost_id%5D=1&comment%5Buser_id%5D=1] SQL (0.000444) SELECT count(*) AS count_all FROM `comments`  SQL (0.001086) ROLLBACK SQL (0.000223) BEGIN User Load (0.001092) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Comment Load (0.000697) SELECT * FROM `comments` WHERE (`comments`.`id` = 1)  Post Load (0.000782) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  SQL (0.000373) SELECT count(*) AS count_all FROM `comments`  Post Load (0.000686) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000391) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing CommentsController#destroy (for 0.0.0.0 at 2008-01-16 10:33:04) [DELETE] Session ID: Parameters: {"action"=>"destroy", "post_id"=>#, "id"=>#, "blog_id"=>#, "controller"=>"comments"} Post Load (0.000811) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Comment Load (0.000758) SELECT * FROM `comments` WHERE (`comments`.`id` = 1)  User Load (0.000767) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000410) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Comment Destroy (0.000265)  DELETE FROM `comments` WHERE `id` = 1  Rendering comments/destroy Completed in 0.01202 (83 reqs/sec) | Rendering: 0.00597 (49%) | DB: 0.00878 (73%) | 200 OK [http://test.host/blogs/1/posts/1/comments/1] SQL (0.000448) SELECT count(*) AS count_all FROM `comments`  SQL (0.001031) ROLLBACK SQL (0.000215) BEGIN User Load (0.000947) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Comment Load (0.000652) SELECT * FROM `comments` WHERE (`comments`.`id` = 1)  Post Load (0.000805) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000399) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing CommentsController#new (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"new", "post_id"=>#, "blog_id"=>#, "controller"=>"comments"} Post Load (0.000745) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Rendering comments/new Comment Load (0.000887) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at User Load (0.000753) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000442) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000972) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00575) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00258) Rendered comments/_new (0.00778) Completed in 0.02269 (44 reqs/sec) | Rendering: 0.01797 (79%) | DB: 0.00830 (36%) | 200 OK [http://test.host/blogs/1/posts/1/comments/new] SQL (0.000228) ROLLBACK SQL (0.000144) BEGIN User Load (0.000896) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Comment Load (0.000655) SELECT * FROM `comments` WHERE (`comments`.`id` = 1)  Post Load (0.000716) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Post Load (0.000591) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.002025) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing CommentsController#destroy (for 0.0.0.0 at 2008-01-16 10:33:04) [DELETE] Session ID: Parameters: {"action"=>"destroy", "post_id"=>#, "id"=>#, "blog_id"=>#, "controller"=>"comments"} Post Load (0.000556) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Comment Load (0.000469) SELECT * FROM `comments` WHERE (`comments`.`id` = 1)  User Load (0.000541) SELECT * FROM `users` WHERE (`users`.`id` = 2)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000291) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000522) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Redirected to http://test.host/user Completed in 0.00428 (233 reqs/sec) | DB: 0.00763 (178%) | 302 Found [http://test.host/blogs/1/posts/1/comments/1] SQL (0.000590) ROLLBACK SQL (0.000094) BEGIN Processing CommunityController#browse (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"browse", "controller"=>"community"} Rendering template within layouts/application Rendering community/browse Rendered community/_browse_form (0.00278) Rendered community/_result_summary (0.00150) Rendered community/_user_table (0.00183) Completed in 0.01723 (58 reqs/sec) | Rendering: 0.01490 (86%) | DB: 0.00068 (3%) | 200 OK [http://test.host/community/browse] SQL (0.000159) ROLLBACK SQL (0.000111) BEGIN Processing CommunityController#browse (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"commit"=>"Browse", "action"=>"browse", "gender"=>"Female", "controller"=>"community"} GeoDatum Load (0.001228) SELECT * FROM `geo_data` WHERE (`geo_data`.`zip_code` IS NULL) LIMIT 1 Spec Load (0.000811) SELECT `specs`.* FROM `specs` LEFT JOIN geo_data ON geo_data.zip_code = specs.zip_code WHERE (gender = 'Female') ORDER BY last_name, first_name Rendering template within layouts/application Rendering community/browse Rendered community/_browse_form (0.00083) Rendered community/_result_summary (0.00014) Rendered community/_user_table (0.00008) Completed in 0.00705 (141 reqs/sec) | Rendering: 0.00369 (52%) | DB: 0.00231 (32%) | 200 OK [http://test.host/community/browse?commit=Browse&gender=Female] SQL (0.000200) ROLLBACK SQL (0.000104) BEGIN Processing CommunityController#browse (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"min_age"=>"60", "commit"=>"Browse", "action"=>"browse", "zip_code"=>"91125", "gender"=>"Male", "controller"=>"community", "miles"=>"1", "max_age"=>"80"} GeoDatum Load (0.000767) SELECT * FROM `geo_data` WHERE (`geo_data`.`zip_code` = '91125') LIMIT 1 CACHE (0.000000) SELECT * FROM `geo_data` WHERE (`geo_data`.`zip_code` = '91125') LIMIT 1 Spec Load (0.001354) SELECT `specs`.* FROM `specs` LEFT JOIN geo_data ON geo_data.zip_code = specs.zip_code WHERE (ADDDATE(birthdate, INTERVAL '60' YEAR) < CURDATE() AND ADDDATE(birthdate, INTERVAL '80'+1 YEAR) > CURDATE() AND gender = 'Male' AND 2 * 3956 * ASIN(SQRT(POWER(SIN((RADIANS(latitude - 33.7866))/2.0),2) + COS(RADIANS(33.7866)) * COS(RADIANS(latitude)) * POWER(SIN((RADIANS(longitude - -118.299))/2.0),2))) <= '1') ORDER BY last_name, first_name User Load (0.000678) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Rendering template within layouts/application Rendering community/browse Rendered community/_browse_form (0.00081) Rendered community/_result_summary (0.00009) Spec Load (0.000838) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered community/_user_table (0.00193) Completed in 0.01106 (90 reqs/sec) | Rendering: 0.00472 (42%) | DB: 0.00394 (35%) | 200 OK [http://test.host/community/browse?commit=Browse&gender=Male&max_age=80&miles=1&min_age=60&zip_code=91125] SQL (0.000183) ROLLBACK SQL (0.000101) BEGIN Processing CommunityController#index (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"community"} Rendering template within layouts/application Rendering community/index Rendered community/_result_summary (0.00009) Rendered community/_user_table (0.00007) Rendered community/_browse_form (0.00094) Rendered community/_search_form (0.00210) Completed in 0.01151 (86 reqs/sec) | Rendering: 0.01124 (97%) | DB: 0.00028 (2%) | 200 OK [http://test.host/community] SQL (0.000152) ROLLBACK SQL (0.000102) BEGIN Processing CommunityController#search (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"search", "q"=>"foobar", "controller"=>"community"} Query: foobar total hits: 0, results delivered: 0 Query: foobar total hits: 0, results delivered: 0 Query: foobar total hits: 0, results delivered: 0 Rendering template within layouts/application Rendering community/search Rendered community/_search_form (0.00060) Rendered community/_result_summary (0.00014) Rendered community/_user_table (0.00008) Completed in 0.05078 (19 reqs/sec) | Rendering: 0.00466 (9%) | DB: 0.00025 (0%) | 200 OK [http://test.host/community/search?q=foobar] SQL (0.000170) ROLLBACK SQL (0.000110) BEGIN Processing CommunityController#search (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"search", "controller"=>"community"} Rendering template within layouts/application Rendering community/search Rendered community/_search_form (0.00059) Rendered community/_result_summary (0.00007) Rendered community/_user_table (0.00007) Completed in 0.00338 (296 reqs/sec) | Rendering: 0.00326 (96%) | DB: 0.00028 (8%) | 200 OK [http://test.host/community/search] SQL (0.000137) ROLLBACK SQL (0.000107) BEGIN Processing CommunityController#search (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"search", "q"=>"unlikely_search_string", "controller"=>"community"} Query: unlikely_search_string total hits: 0, results delivered: 0 Query: unlikely_search_string total hits: 0, results delivered: 0 Query: unlikely_search_string total hits: 0, results delivered: 0 Rendering template within layouts/application Rendering community/search Rendered community/_search_form (0.07312) Rendered community/_result_summary (0.00018) Rendered community/_user_table (0.00007) Completed in 0.07903 (12 reqs/sec) | Rendering: 0.07583 (95%) | DB: 0.00024 (0%) | 200 OK [http://test.host/community/search?q=unlikely_search_string] SQL (0.000193) ROLLBACK SQL (0.000082) BEGIN Processing CommunityController#search (for 0.0.0.0 at 2008-01-16 10:33:04) [GET] Session ID: Parameters: {"action"=>"search", "q"=>"*", "controller"=>"community"} User Load (0.001313) SELECT * FROM `users` WHERE (users.id in ('11','6','12','7','13','8','14','9','15','16','1','2','3','10','4','5'))  Query: * total hits: 16, results delivered: 14 Spec Load (0.000872) SELECT * FROM `specs` WHERE (specs.id in ('11','6','12','7','13','8','14','9','15','1','2','3','4','10','5'))  Query: * total hits: 15, results delivered: 3 Faq Load (0.000779) SELECT * FROM `faqs` WHERE (faqs.id in ('1'))  Query: * total hits: 1, results delivered: 1 User Load (0.000583) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000529) SELECT * FROM `users` WHERE (`users`.`id` = 4)  User Load (0.000526) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000679) SELECT * FROM `specs` WHERE (specs.user_id = 2) LIMIT 1 Spec Load (0.000712) SELECT * FROM `specs` WHERE (specs.user_id = 3) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 3) LIMIT 1 Spec Create (0.000247) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 3, '', '') ferret_create/update: Spec : 5 creating doc for class: Spec, id: 5 Adding field zip_code with value '' to index Adding field user_id with value '3' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.000821) SELECT * FROM `specs` WHERE (specs.user_id = 4) LIMIT 1 Spec Load (0.000652) SELECT * FROM `specs` WHERE (specs.user_id = 5) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 5) LIMIT 1 Spec Create (0.000238) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 5, '', '') ferret_create/update: Spec : 6 creating doc for class: Spec, id: 6 Adding field zip_code with value '' to index Adding field user_id with value '5' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.000991) SELECT * FROM `specs` WHERE (specs.user_id = 6) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 6) LIMIT 1 Spec Create (0.000273) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 6, '', '') ferret_create/update: Spec : 7 creating doc for class: Spec, id: 7 Adding field zip_code with value '' to index Adding field user_id with value '6' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001290) SELECT * FROM `specs` WHERE (specs.user_id = 7) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 7) LIMIT 1 Spec Create (0.000337) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 7, '', '') ferret_create/update: Spec : 8 creating doc for class: Spec, id: 8 Adding field zip_code with value '' to index Adding field user_id with value '7' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001090) SELECT * FROM `specs` WHERE (specs.user_id = 8) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 8) LIMIT 1 Spec Create (0.000305) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 8, '', '') ferret_create/update: Spec : 9 creating doc for class: Spec, id: 9 Adding field zip_code with value '' to index Adding field user_id with value '8' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001015) SELECT * FROM `specs` WHERE (specs.user_id = 9) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 9) LIMIT 1 Spec Create (0.000287) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 9, '', '') ferret_create/update: Spec : 10 creating doc for class: Spec, id: 10 Adding field zip_code with value '' to index Adding field user_id with value '9' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001158) SELECT * FROM `specs` WHERE (specs.user_id = 10) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 10) LIMIT 1 Spec Create (0.000290) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 10, '', '') ferret_create/update: Spec : 11 creating doc for class: Spec, id: 11 Adding field zip_code with value '' to index Adding field user_id with value '10' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001006) SELECT * FROM `specs` WHERE (specs.user_id = 11) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 11) LIMIT 1 Spec Create (0.000351) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 11, '', '') ferret_create/update: Spec : 12 creating doc for class: Spec, id: 12 Adding field zip_code with value '' to index Adding field user_id with value '11' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001146) SELECT * FROM `specs` WHERE (specs.user_id = 12) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 12) LIMIT 1 Spec Create (0.000291) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 12, '', '') ferret_create/update: Spec : 13 creating doc for class: Spec, id: 13 Adding field zip_code with value '' to index Adding field user_id with value '12' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001008) SELECT * FROM `specs` WHERE (specs.user_id = 13) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 13) LIMIT 1 Spec Create (0.000304) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 13, '', '') ferret_create/update: Spec : 14 creating doc for class: Spec, id: 14 Adding field zip_code with value '' to index Adding field user_id with value '13' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001017) SELECT * FROM `specs` WHERE (specs.user_id = 14) LIMIT 1 CACHE (0.000000) SELECT * FROM `specs` WHERE (specs.user_id = 14) LIMIT 1 Spec Create (0.000306) INSERT INTO `specs` (`city`, `occupation`, `birthdate`, `zip_code`, `gender`, `first_name`, `user_id`, `last_name`, `state`) VALUES('', '', NULL, '', NULL, '', 14, '', '') ferret_create/update: Spec : 15 creating doc for class: Spec, id: 15 Adding field zip_code with value '' to index Adding field user_id with value '14' to index Adding field state with value '' to index Adding field first_name with value '' to index Adding field city with value '' to index Adding field occupation with value '' to index Adding field gender with value '' to index Adding field last_name with value '' to index Adding field birthdate with value '' to index Spec Load (0.001012) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendering template within layouts/application Rendering community/search Rendered community/_search_form (0.00060) Rendered community/_result_summary (0.00020) Rendered community/_user_table (0.00283) Completed in 0.26128 (3 reqs/sec) | Rendering: 0.00666 (2%) | DB: 0.02170 (8%) | 200 OK [http://test.host/community/search?q=%2A] SQL (0.001152) ROLLBACK SQL (0.000166) BEGIN User Load (0.000882) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000721) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Processing EmailController#correspond (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"message"=>{"body"=>"Dude, this is totally rad!", "subject"=>"Test message"}, "action"=>"correspond", "id"=>"amigo", "controller"=>"email"} User Load (0.000786) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000771) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'amigo') LIMIT 1 Spec Load (0.001142) SELECT * FROM `specs` WHERE (specs.user_id = 4) LIMIT 1 Spec Load (0.000821) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Sent mail: From: RailsSpace To: ami@example.com Subject: Test message Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Kip Thorne at RailsSpace (http://test.host/profile/millikan) writes: Dude, this is totally rad! To reply to this message, go to: http://test.host/email/correspond/millikan Redirected to http://test.host/profile/amigo Completed in 0.03444 (29 reqs/sec) | DB: 0.00644 (18%) | 302 Found [http://test.host/email/correspond/amigo?message%5Bbody%5D=Dude%2C+this+is+totally+rad%21&message%5Bsubject%5D=Test+message] SQL (0.000173) ROLLBACK SQL (0.000086) BEGIN User Load (0.000592) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000515) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Processing EmailController#remind (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"email"=>"ram@example.com"}, "action"=>"remind", "controller"=>"email"} User Load (0.000582) SELECT * FROM `users` WHERE (`users`.`email` = 'ram@example.com') LIMIT 1 Sent mail: From: RailsSpace To: ram@example.com Subject: Your login information at RailsSpace.com Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Hello, Your login information is: Screen name: millikan Password: electron --The RailsSpace team Redirected to http://test.host/ Completed in 0.00380 (263 reqs/sec) | DB: 0.00195 (51%) | 302 Found [http://test.host/email/remind?user%5Bemail%5D=ram%40example.com] SQL (0.000180) ROLLBACK SQL (0.000086) BEGIN SQL (0.000096) ROLLBACK SQL (0.000097) BEGIN User Load (0.000578) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000517) SELECT * FROM `users` WHERE (`users`.`id` = 4)  Processing FriendshipController#create (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"create", "id"=>"amigo", "controller"=>"friendship"} User Load (0.000535) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000539) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'amigo') LIMIT 1 Friendship Columns (0.003080) SHOW FIELDS FROM `friendships` Friendship Load (0.000748) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Create (0.000269) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'pending', 1, '2008-01-16 10:33:05', 4) Friendship Create (0.000225) INSERT INTO `friendships` (`accepted_at`, `status`, `user_id`, `created_at`, `friend_id`) VALUES(NULL, 'requested', 4, '2008-01-16 10:33:05', 1) Spec Load (0.001172) SELECT * FROM `specs` WHERE (specs.user_id = 4) LIMIT 1 Spec Load (0.000892) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Sent mail: From: RailsSpace To: ami@example.com Subject: New friend request at RailsSpace.com Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Hello Dude Dude, You have a new RailsSpace friend request from Kip Thorne. View Kip Thorne's profile: http://test.host/profile/millikan Accept: http://test.host/friendship/accept/millikan Decline: http://test.host/friendship/decline/millikan --The RailsSpace team Redirected to http://test.host/profile/amigo Completed in 0.05316 (18 reqs/sec) | DB: 0.00901 (16%) | 302 Found [http://test.host/friendship/create/amigo] Processing FriendshipController#accept (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"accept", "id"=>"millikan", "controller"=>"friendship"} User Load (0.000763) SELECT * FROM `users` WHERE (`users`.`id` = 4)  User Load (0.000719) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'millikan') LIMIT 1 User Load (0.000951) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 4) AND ((status = 'requested'))) ORDER BY created_at Friendship Load (0.000694) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 1 AND `friendships`.`user_id` = 4) LIMIT 1 Friendship Update (0.000329) UPDATE `friendships` SET `created_at` = '2008-01-16 10:33:05', `status` = 'accepted', `friend_id` = 1, `user_id` = 4, `accepted_at` = '2008-01-16 10:33:05' WHERE `id` = 8 Friendship Load (0.000739) SELECT * FROM `friendships` WHERE (`friendships`.`friend_id` = 4 AND `friendships`.`user_id` = 1) LIMIT 1 Friendship Update (0.000307) UPDATE `friendships` SET `created_at` = '2008-01-16 10:33:05', `status` = 'accepted', `friend_id` = 4, `user_id` = 1, `accepted_at` = '2008-01-16 10:33:05' WHERE `id` = 7 Redirected to http://test.host/user Completed in 0.00926 (108 reqs/sec) | DB: 0.00450 (48%) | 302 Found [http://test.host/friendship/create/amigo] SQL (0.000949) ROLLBACK SQL (0.000134) BEGIN User Load (0.000737) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000644) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000392) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#update (for 0.0.0.0 at 2008-01-16 10:33:05) [PUT] Session ID: Parameters: {"action"=>"update", "post"=>{"body"=>"New body", "title"=>"New title"}, "id"=>#, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000426) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000699) SELECT * FROM `users` WHERE (`users`.`id` = 2)  User Load (0.000699) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Redirected to http://test.host/user Filter chain halted as [#] rendered_or_redirected. Completed in 0.00340 (294 reqs/sec) | DB: 0.00468 (137%) | 302 Found [http://test.host/blogs/1/posts/1?post%5Bbody%5D=New+body&post%5Btitle%5D=New+title] SQL (0.000162) ROLLBACK SQL (0.000117) BEGIN User Load (0.000713) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000610) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  SQL (0.000323) SELECT count(*) AS count_all FROM `posts`  Blog Load (0.000412) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#create (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"action"=>"create", "post"=>{"body"=>"New body", "title"=>"New title"}, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000435) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000747) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000683) SELECT * FROM `posts` WHERE (`posts`.`title` = 'New title' AND `posts`.`blog_id` = 1 AND `posts`.`body` = 'New body') LIMIT 1 Post Load (0.000737) SELECT * FROM `posts` WHERE (posts.body = 'New body' AND posts.title = 'New title' AND posts.blog_id = 1) LIMIT 1 Post Create (0.000278) INSERT INTO `posts` (`updated_at`, `body`, `title`, `blog_id`, `created_at`) VALUES('2008-01-16 10:33:05', 'New body', 'New title', 1, '2008-01-16 10:33:05') Redirected to http://test.host/blogs/1/posts/3 Completed in 0.01048 (95 reqs/sec) | DB: 0.00522 (49%) | 302 Found [http://test.host/blogs/1/posts?post%5Bbody%5D=New+body&post%5Btitle%5D=New+title] SQL (0.000374) SELECT count(*) AS count_all FROM `posts`  SQL (0.000872) ROLLBACK SQL (0.000225) BEGIN User Load (0.001010) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000734) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  SQL (0.000369) SELECT count(*) AS count_all FROM `posts`  Blog Load (0.000444) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#destroy (for 0.0.0.0 at 2008-01-16 10:33:05) [DELETE] Session ID: Parameters: {"action"=>"destroy", "id"=>#, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000421) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000699) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000637) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Comment Load (0.000711) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at Comment Destroy (0.000253)  DELETE FROM `comments` WHERE `id` = 1  Comment Destroy (0.000203)  DELETE FROM `comments` WHERE `id` = 2  Post Destroy (0.000251)  DELETE FROM `posts` WHERE `id` = 1  Redirected to http://test.host/blogs/1/posts Completed in 0.00729 (137 reqs/sec) | DB: 0.00720 (98%) | 302 Found [http://test.host/blogs/1/posts/1] SQL (0.000348) SELECT count(*) AS count_all FROM `posts`  SQL (0.000869) ROLLBACK SQL (0.000172) BEGIN User Load (0.001077) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000641) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000406) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"edit", "id"=>#, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000463) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000705) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000658) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Rendering template within layouts/application Rendering posts/edit CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Comment Load (0.000852) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000946) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00354) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00225) Rendered posts/_post (0.01277) Rendered posts/_form (0.00236) Completed in 0.04585 (21 reqs/sec) | Rendering: 0.04022 (87%) | DB: 0.00714 (15%) | 200 OK [http://test.host/blogs/1/posts/1/edit] SQL (0.000233) ROLLBACK SQL (0.000133) BEGIN User Load (0.000765) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000647) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000391) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000426) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000695) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000719) SELECT * FROM `posts` WHERE (posts.blog_id = 1) ORDER BY created_at DESC Rendering template within layouts/application Rendering posts/index CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Comment Load (0.000711) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000547) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000704) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00341) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00199) Rendered posts/_post (0.00825) Completed in 0.07012 (14 reqs/sec) | Rendering: 0.06456 (92%) | DB: 0.00597 (8%) | 200 OK [http://test.host/blogs/1/posts] SQL (0.000202) ROLLBACK SQL (0.000106) BEGIN User Load (0.000621) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000504) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000280) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#new (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"new", "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000323) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000534) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Rendering template within layouts/application Rendering posts/new Rendered posts/_form (0.00059) Completed in 0.00750 (133 reqs/sec) | Rendering: 0.00572 (76%) | DB: 0.00257 (34%) | 200 OK [http://test.host/blogs/1/posts/new] SQL (0.000226) ROLLBACK SQL (0.000132) BEGIN User Load (0.000764) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000652) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Post Load (0.000621) SELECT * FROM `posts` WHERE (`posts`.`id` = 2)  Blog Load (0.000394) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"edit", "id"=>#, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000412) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000703) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000650) SELECT * FROM `posts` WHERE (`posts`.`id` = 2)  Blog Load (0.000388) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 2)  Redirected to http://test.host/user Filter chain halted as [#] rendered_or_redirected. Completed in 0.00401 (249 reqs/sec) | DB: 0.00494 (123%) | 302 Found [http://test.host/blogs/1/posts/2/edit] SQL (0.000184) ROLLBACK SQL (0.000112) BEGIN User Load (0.000722) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000651) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000388) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#show (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"show", "id"=>#, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000500) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000725) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000659) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Rendering template within layouts/application Rendering posts/show CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Comment Load (0.000768) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000942) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00367) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00256) Rendered posts/_post (0.00916) Completed in 0.01793 (55 reqs/sec) | Rendering: 0.01204 (67%) | DB: 0.00565 (31%) | 200 OK [http://test.host/blogs/1/posts/1] SQL (0.000265) ROLLBACK SQL (0.000148) BEGIN User Load (0.000835) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000663) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Processing PostsController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"posts"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00051 (1976 reqs/sec) | DB: 0.00191 (377%) | 302 Found [http://test.host/posts] Processing PostsController#new (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"new", "controller"=>"posts"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00036 (2809 reqs/sec) | DB: 0.00000 (0%) | 302 Found [http://test.host/posts] Processing PostsController#show (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"show", "controller"=>"posts"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00034 (2974 reqs/sec) | DB: 0.00000 (0%) | 302 Found [http://test.host/posts] Processing PostsController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"edit", "controller"=>"posts"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00034 (2957 reqs/sec) | DB: 0.00000 (0%) | 302 Found [http://test.host/posts] SQL (0.000251) ROLLBACK SQL (0.000116) BEGIN User Load (0.000763) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000706) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  Blog Load (0.000399) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Processing PostsController#update (for 0.0.0.0 at 2008-01-16 10:33:05) [PUT] Session ID: Parameters: {"action"=>"update", "post"=>{"body"=>"New body", "title"=>"New title"}, "id"=>#, "blog_id"=>#, "controller"=>"posts"} Blog Load (0.000435) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  User Load (0.000707) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000614) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Post Load (0.000762) SELECT * FROM `posts` WHERE (posts.body = 'New body' AND posts.title = 'New title' AND posts.blog_id = 1 AND posts.id <> 1) LIMIT 1 Post Update (0.000321) UPDATE `posts` SET `created_at` = '2007-01-16 15:34:32', `title` = 'New title', `body` = 'New body', `blog_id` = 1, `updated_at` = '2008-01-16 10:33:05' WHERE `id` = 1 Redirected to http://test.host/blogs/1/posts/1 Completed in 0.00715 (139 reqs/sec) | DB: 0.00507 (70%) | 302 Found [http://test.host/blogs/1/posts/1?post%5Bbody%5D=New+body&post%5Btitle%5D=New+title] SQL (0.001017) ROLLBACK SQL (0.000141) BEGIN SQL (0.000128) ROLLBACK SQL (0.000137) BEGIN Processing SiteController#about (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"about", "controller"=>"site"} Rendering template within layouts/application Rendering site/about Completed in 0.00739 (135 reqs/sec) | Rendering: 0.00468 (63%) | DB: 0.00142 (19%) | 200 OK [http://test.host/site/about] SQL (0.000204) ROLLBACK SQL (0.000114) BEGIN Processing SiteController#help (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"help", "controller"=>"site"} Rendering template within layouts/application Rendering site/help Completed in 0.00445 (224 reqs/sec) | Rendering: 0.00433 (97%) | DB: 0.00032 (7%) | 200 OK [http://test.host/site/help] SQL (0.000288) ROLLBACK SQL (0.000114) BEGIN Processing SiteController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"site"} Rendering template within layouts/application Rendering site/index Completed in 0.00363 (275 reqs/sec) | Rendering: 0.00351 (96%) | DB: 0.00040 (11%) | 200 OK [http://test.host/] SQL (0.000176) ROLLBACK SQL (0.000129) BEGIN Processing SiteController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"site"} Rendering template within layouts/application Rendering site/index Completed in 0.00236 (423 reqs/sec) | Rendering: 0.00226 (95%) | DB: 0.00030 (12%) | 200 OK [http://test.host/] SQL (0.000159) ROLLBACK SQL (0.000086) BEGIN User Load (0.000617) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000653) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  Processing SpecController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"action"=>"edit", "spec"=>{"occupation"=>"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa", "city"=>"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa", "zip_code"=>"bad", "gender"=>"Hermaphrodite", "first_name"=>"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa", "last_name"=>"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa", "state"=>"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"}, "controller"=>"spec"} User Load (0.000572) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000667) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendering template within layouts/application Rendering spec/edit Completed in 0.01209 (82 reqs/sec) | Rendering: 0.00689 (57%) | DB: 0.00275 (22%) | 200 OK [http://test.host/spec/edit?spec%5Bcity%5D=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&spec%5Bfirst_name%5D=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&spec%5Bgender%5D=Hermaphrodite&spec%5Blast_name%5D=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&spec%5Boccupation%5D=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&spec%5Bstate%5D=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa&spec%5Bzip_code%5D=bad] SQL (0.000217) ROLLBACK SQL (0.000081) BEGIN User Load (0.000740) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000673) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  Processing SpecController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"edit", "controller"=>"spec"} User Load (0.000550) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000714) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendering template within layouts/application Rendering spec/edit Completed in 0.00609 (164 reqs/sec) | Rendering: 0.00417 (68%) | DB: 0.00297 (48%) | 200 OK [http://test.host/spec/edit] SQL (0.000216) ROLLBACK SQL (0.000084) BEGIN User Load (0.000639) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000669) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  Processing SpecController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"action"=>"edit", "spec"=>{"occupation"=>"new job", "zip_code"=>"91125", "gender"=>"Male", "first_name"=>"new first name", "last_name"=>"new last name"}, "controller"=>"spec"} User Load (0.000573) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000691) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Spec Update (0.000296) UPDATE `specs` SET `gender` = 'Male', `zip_code` = '91125', `city` = 'Pasadena', `last_name` = 'new last name', `user_id` = 1, `first_name` = 'new first name', `state` = 'CA', `birthdate` = '1940-06-01', `occupation` = 'new job' WHERE `id` = 1 ferret_create/update: Spec : 1 creating doc for class: Spec, id: 1 Adding field zip_code with value '91125' to index Adding field user_id with value '1' to index Adding field state with value 'CA' to index Adding field first_name with value 'new first name' to index Adding field city with value 'Pasadena' to index Adding field occupation with value 'new job' to index Adding field gender with value 'Male' to index Adding field last_name with value 'new last name' to index Adding field birthdate with value '1940-06-01' to index Redirected to http://test.host/user Completed in 0.01771 (56 reqs/sec) | DB: 0.00317 (17%) | 302 Found [http://test.host/spec/edit?spec%5Bfirst_name%5D=new+first+name&spec%5Bgender%5D=Male&spec%5Blast_name%5D=new+last+name&spec%5Boccupation%5D=new+job&spec%5Bzip_code%5D=91125] User Load (0.001076) SELECT * FROM `users` WHERE (`users`.`id` = 1)  User Load (0.000746) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000975) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 SQL (0.031809) ROLLBACK SQL (0.000239) BEGIN User Load (0.001067) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.001256) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  Processing SpecController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"spec"} Redirected to http://test.host/user Completed in 0.00033 (3050 reqs/sec) | DB: 0.03717 (11337%) | 302 Found [http://test.host/spec] SQL (0.000242) ROLLBACK SQL (0.000132) BEGIN User Load (0.000821) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000963) SELECT * FROM `specs` WHERE (`specs`.`id` = 1)  Processing SpecController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"spec"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00038 (2639 reqs/sec) | DB: 0.00216 (569%) | 302 Found [http://test.host/spec] SQL (0.001506) ROLLBACK SQL (0.003353) BEGIN User Load (0.003419) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#edit (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"edit", "controller"=>"user"} User Load (0.018852) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Rendering template within layouts/application Rendering user/edit Rendered user/_email_field_row (0.00129) Rendered user/_password_field_row (0.00142) Rendered user/_password_field_row (0.00066) Rendered user/_password_field_row (0.00019) Completed in 0.05766 (17 reqs/sec) | Rendering: 0.00994 (17%) | DB: 0.02713 (47%) | 200 OK [http://test.host/user/edit] SQL (0.000190) ROLLBACK SQL (0.000125) BEGIN User Load (0.000606) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"user"} User Load (0.000564) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000678) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Faq Load (0.000717) SELECT * FROM `faqs` WHERE (faqs.user_id = 1) LIMIT 1 Blog Load (0.000292) SELECT * FROM `blogs` WHERE (blogs.user_id = 1) LIMIT 1 Post Load (0.000534) SELECT * FROM `posts` WHERE (posts.blog_id = 1) ORDER BY created_at DESC Rendering template within layouts/application Rendering user/index Rendered spec/_field_row (0.00131) Rendered spec/_field_row (0.00012) Rendered spec/_field_row (0.00010) Rendered spec/_field_row (0.00009) Rendered spec/_field_row (0.00032) Rendered spec/_field_row (0.00010) Rendered spec/_field_row (0.00009) Rendered spec/_field_row (0.00010) Rendered avatar/_sidebar_box (0.00207) Rendered faq/_sidebar_box (0.00178) Rendered faq/_sidebar_box (0.00021) Rendered faq/_sidebar_box (0.00021) Rendered faq/_sidebar_box (0.00019) Rendered faq/_sidebar_box (0.00019) Rendered faq/_sidebar_box (0.00019) Rendered faq/_sidebar_box (0.00020) Rendered faq/_sidebar_box (0.00019) SQL (0.000457) SELECT count(*) AS count_all FROM `users` INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'accepted')))  User Load (0.000609) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'accepted'))) ORDER BY screen_name User Load (0.000580) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'requested'))) ORDER BY created_at User Load (0.000573) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'pending'))) ORDER BY created_at Rendered friendship/_friends (0.00757) SQL (0.000346) SELECT count(*) AS count_all FROM `posts` WHERE (posts.blog_id = 1)  Blog Load (0.000312) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Comment Load (0.000548) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000533) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00250) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00167) Rendered posts/_post (0.00693) Rendered profile/_blog (0.00973) Completed in 0.03954 (25 reqs/sec) | Rendering: 0.03104 (78%) | DB: 0.00766 (19%) | 200 OK [http://test.host/user] SQL (0.000175) ROLLBACK SQL (0.000100) BEGIN User Load (0.000576) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"user"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00034 (2976 reqs/sec) | DB: 0.00085 (253%) | 302 Found [http://test.host/user] SQL (0.000148) ROLLBACK SQL (0.000098) BEGIN User Load (0.000541) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#login (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"no such user", "password"=>"electron"}, "action"=>"login", "controller"=>"user"} User Load (0.000593) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'no such user' AND `users`.`password` = 'electron') LIMIT 1 Rendering template within layouts/application Rendering user/login Rendered user/_screen_name_field_row (0.00140) Rendered user/_password_field_row (0.00022) Completed in 0.00814 (122 reqs/sec) | Rendering: 0.00682 (83%) | DB: 0.00138 (16%) | 200 OK [http://test.host/user/login?user%5Bpassword%5D=electron&user%5Bscreen_name%5D=no+such+user] SQL (0.000171) ROLLBACK SQL (0.000105) BEGIN User Load (0.000586) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#login (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"millikan", "password"=>"electronbaz"}, "action"=>"login", "controller"=>"user"} User Load (0.000619) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'millikan' AND `users`.`password` = 'electronbaz') LIMIT 1 Rendering template within layouts/application Rendering user/login Rendered user/_screen_name_field_row (0.00023) Rendered user/_password_field_row (0.00020) Completed in 0.00467 (213 reqs/sec) | Rendering: 0.00349 (74%) | DB: 0.00148 (31%) | 200 OK [http://test.host/user/login?user%5Bpassword%5D=electronbaz&user%5Bscreen_name%5D=millikan] SQL (0.000170) ROLLBACK SQL (0.000100) BEGIN User Load (0.000586) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"user"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00026 (3788 reqs/sec) | DB: 0.00086 (324%) | 302 Found [http://test.host/user] Processing UserController#login (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"millikan", "password"=>"electron"}, "action"=>"login", "controller"=>"user"} User Load (0.000602) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'millikan' AND `users`.`password` = 'electron') LIMIT 1 Cookie set: remember_me=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Cookie set: authorization_token=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Redirected to http://test.host/user Completed in 0.00135 (739 reqs/sec) | DB: 0.00060 (44%) | 302 Found [http://test.host/user] SQL (0.000140) ROLLBACK SQL (0.000099) BEGIN User Load (0.000544) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#login (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"login", "controller"=>"user"} Rendering template within layouts/application Rendering user/login Rendered user/_screen_name_field_row (0.00023) Rendered user/_password_field_row (0.00020) Completed in 0.00336 (298 reqs/sec) | Rendering: 0.00315 (93%) | DB: 0.00078 (23%) | 200 OK [http://test.host/user/login] SQL (0.000651) ROLLBACK SQL (0.000103) BEGIN User Load (0.000580) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#login (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"millikan", "password"=>"electron", "remember_me"=>"0"}, "action"=>"login", "controller"=>"user"} User Load (0.000595) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'millikan' AND `users`.`password` = 'electron') LIMIT 1 Cookie set: remember_me=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Cookie set: authorization_token=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Redirected to http://test.host/user Completed in 0.00146 (685 reqs/sec) | DB: 0.00193 (132%) | 302 Found [http://test.host/user/login?user%5Bpassword%5D=electron&user%5Bremember_me%5D=0&user%5Bscreen_name%5D=millikan] SQL (0.000133) ROLLBACK SQL (0.000100) BEGIN User Load (0.000537) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#login (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"millikan", "password"=>"electron"}, "action"=>"login", "controller"=>"user"} User Load (0.000579) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'millikan' AND `users`.`password` = 'electron') LIMIT 1 Cookie set: remember_me=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Cookie set: authorization_token=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Redirected to http://test.host/user Completed in 0.00139 (721 reqs/sec) | DB: 0.00135 (97%) | 302 Found [http://test.host/user/login?user%5Bpassword%5D=electron&user%5Bscreen_name%5D=millikan] Processing UserController#logout (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"logout", "controller"=>"user"} Cookie set: authorization_token=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT Redirected to http://test.host/ Completed in 0.00029 (3426 reqs/sec) | DB: 0.00000 (0%) | 302 Found [http://test.host/user/login?user%5Bpassword%5D=electron&user%5Bscreen_name%5D=millikan] SQL (0.000158) ROLLBACK SQL (0.000104) BEGIN User Load (0.000811) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"user"} User Load (0.000812) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Spec Load (0.000756) SELECT * FROM `specs` WHERE (specs.user_id = 1) LIMIT 1 Faq Load (0.000803) SELECT * FROM `faqs` WHERE (faqs.user_id = 1) LIMIT 1 Blog Load (0.000316) SELECT * FROM `blogs` WHERE (blogs.user_id = 1) LIMIT 1 Post Load (0.000554) SELECT * FROM `posts` WHERE (posts.blog_id = 1) ORDER BY created_at DESC Rendering template within layouts/application Rendering user/index Rendered spec/_field_row (0.00015) Rendered spec/_field_row (0.00010) Rendered spec/_field_row (0.00009) Rendered spec/_field_row (0.00009) Rendered spec/_field_row (0.00034) Rendered spec/_field_row (0.00010) Rendered spec/_field_row (0.00009) Rendered spec/_field_row (0.00009) Rendered avatar/_sidebar_box (0.00038) Rendered faq/_sidebar_box (0.00033) Rendered faq/_sidebar_box (0.00021) Rendered faq/_sidebar_box (0.00021) Rendered faq/_sidebar_box (0.00021) Rendered faq/_sidebar_box (0.00019) Rendered faq/_sidebar_box (0.00019) Rendered faq/_sidebar_box (0.00021) Rendered faq/_sidebar_box (0.00020) SQL (0.000427) SELECT count(*) AS count_all FROM `users` INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'accepted')))  User Load (0.000648) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'accepted'))) ORDER BY screen_name User Load (0.000610) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'requested'))) ORDER BY created_at User Load (0.000768) SELECT users.* FROM users INNER JOIN friendships ON users.id = friendships.friend_id WHERE ((friendships.user_id = 1) AND ((status = 'pending'))) ORDER BY created_at Rendered friendship/_friends (0.00447) SQL (0.000259) SELECT count(*) AS count_all FROM `posts` WHERE (posts.blog_id = 1)  Blog Load (0.000296) SELECT * FROM `blogs` WHERE (`blogs`.`id` = 1)  Comment Load (0.000706) SELECT * FROM `comments` WHERE (comments.post_id = 1) ORDER BY created_at CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Post Load (0.000538) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00254) CACHE (0.000000) SELECT * FROM `users` WHERE (`users`.`id` = 1)  CACHE (0.000000) SELECT * FROM `posts` WHERE (`posts`.`id` = 1)  CACHE (0.000000) SELECT * FROM `blogs` WHERE (`blogs`.`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 `specs` WHERE (specs.user_id = 1) LIMIT 1 Rendered comments/_comment (0.00181) Rendered posts/_post (0.00713) Rendered profile/_blog (0.00795) Completed in 0.02613 (38 reqs/sec) | Rendering: 0.01665 (63%) | DB: 0.00857 (32%) | 200 OK [http://test.host/user] SQL (0.000217) ROLLBACK SQL (0.000083) BEGIN User Load (0.000604) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#index (for 0.0.0.0 at 2008-01-16 10:33:05) [GET] Session ID: Parameters: {"action"=>"index", "controller"=>"user"} Redirected to http://test.host/user/login Filter chain halted as [#] rendered_or_redirected. Completed in 0.00027 (3688 reqs/sec) | DB: 0.00090 (333%) | 302 Found [http://test.host/user] Processing UserController#register (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"new_screen_name", "password"=>"long_enough_password", "email"=>"valid@example.com"}, "action"=>"register", "controller"=>"user"} User Load (0.000588) SELECT * FROM `users` WHERE (users.screen_name = 'new_screen_name') LIMIT 1 User Load (0.000508) SELECT * FROM `users` WHERE (users.email = 'valid@example.com') LIMIT 1 User Create (0.000208) INSERT INTO `users` (`authorization_token`, `updated_at`, `screen_name`, `password`, `created_at`, `email`) VALUES(NULL, '2008-01-16 10:33:05', 'new_screen_name', 'long_enough_password', '2008-01-16 10:33:05', 'valid@example.com') ferret_create/update: User : 15 creating doc for class: User, id: 15 Adding field screen_name with value 'new_screen_name' to index Adding field email with value 'valid@example.com' to index Redirected to http://test.host/user Completed in 0.01074 (93 reqs/sec) | DB: 0.00130 (12%) | 302 Found [http://test.host/user] SQL (0.001080) ROLLBACK SQL (0.000198) BEGIN User Load (0.000952) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#register (for 0.0.0.0 at 2008-01-16 10:33:05) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"aa/noyes", "password"=>"sun", "email"=>"anoyes@example,com"}, "action"=>"register", "controller"=>"user"} User Load (0.000837) SELECT * FROM `users` WHERE (users.screen_name = 'aa/noyes') LIMIT 1 User Load (0.001252) SELECT * FROM `users` WHERE (users.email = 'anoyes@example,com') LIMIT 1 Rendering template within layouts/application Rendering user/register Rendered user/_screen_name_field_row (0.00032) Rendered user/_email_field_row (0.00027) Rendered user/_password_field_row (0.00027) Rendered user/_password_field_row (0.00025) Completed in 0.01175 (85 reqs/sec) | Rendering: 0.00783 (66%) | DB: 0.00432 (36%) | 200 OK [http://test.host/user/register?user%5Bemail%5D=anoyes%40example%2Ccom&user%5Bpassword%5D=sun&user%5Bscreen_name%5D=aa%2Fnoyes] SQL (0.000215) ROLLBACK SQL (0.000100) BEGIN User Load (0.000687) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#register (for 0.0.0.0 at 2008-01-16 10:33:06) [GET] Session ID: Parameters: {"action"=>"register", "controller"=>"user"} Rendering template within layouts/application Rendering user/register Rendered user/_screen_name_field_row (0.00020) Rendered user/_email_field_row (0.00018) Rendered user/_password_field_row (0.00018) Rendered user/_password_field_row (0.00016) Completed in 0.00376 (265 reqs/sec) | Rendering: 0.00365 (97%) | DB: 0.00100 (26%) | 200 OK [http://test.host/user/register] SQL (0.000198) ROLLBACK SQL (0.000100) BEGIN User Load (0.000614) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#register (for 0.0.0.0 at 2008-01-16 10:33:06) [POST] Session ID: Parameters: {"user"=>{"screen_name"=>"new_screen_name", "password"=>"long_enough_password", "email"=>"valid@example.com"}, "action"=>"register", "controller"=>"user"} User Load (0.000595) SELECT * FROM `users` WHERE (users.screen_name = 'new_screen_name') LIMIT 1 User Load (0.000584) SELECT * FROM `users` WHERE (users.email = 'valid@example.com') LIMIT 1 User Create (0.000244) INSERT INTO `users` (`authorization_token`, `updated_at`, `screen_name`, `password`, `created_at`, `email`) VALUES(NULL, '2008-01-16 10:33:06', 'new_screen_name', 'long_enough_password', '2008-01-16 10:33:06', 'valid@example.com') ferret_create/update: User : 16 creating doc for class: User, id: 16 Adding field screen_name with value 'new_screen_name' to index Adding field email with value 'valid@example.com' to index Redirected to http://test.host/user Completed in 0.01373 (72 reqs/sec) | DB: 0.00234 (17%) | 302 Found [http://test.host/user/register?user%5Bemail%5D=valid%40example.com&user%5Bpassword%5D=long_enough_password&user%5Bscreen_name%5D=new_screen_name] User Load (0.000980) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'new_screen_name' AND `users`.`password` = 'long_enough_password') LIMIT 1 SQL (0.001007) ROLLBACK Asked for a remote server ? nil, ENV["FERRET_USE_LOCAL_INDEX"] is nil, looks like we are not the server Will use local index. using index in /Users/mhartl/Development/websites/rails/rails_space_sites/rails_space_2_0/index/test/user default field list: ["screen_name", "email"] WARNING: You're using the Ruby-based MySQL library that ships with Rails. This library is not suited for production. Please install the C-based MySQL library instead (gem install mysql). SQL (0.001583) SET SQL_AUTO_IS_NULL=0 SQL (0.000096) BEGIN User Load (0.002811) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Processing UserController#login (for 127.0.0.1 at 2008-01-16 10:33:07) [POST] Session ID: 0dc0ecd3f66e394123a69c12574f4f74 Parameters: {"user"=>{"screen_name"=>"millikan", "password"=>"electron", "remember_me"=>"1"}, "action"=>"login", "controller"=>"user"} User Load (0.000670) SELECT * FROM `users` WHERE (`users`.`screen_name` = 'millikan' AND `users`.`password` = 'electron') LIMIT 1 Cookie set: remember_me=1; path=/; expires=Tue, 16 Jan 2018 18:33:07 GMT User Load (0.000645) SELECT * FROM `users` WHERE (users.screen_name = 'millikan' AND users.id <> 1) LIMIT 1 User Load (0.000565) SELECT * FROM `users` WHERE (users.email = 'ram@example.com' AND users.id <> 1) LIMIT 1 User Update (0.000286) UPDATE `users` SET `created_at` = '2008-01-16 10:33:07', `screen_name` = 'millikan', `authorization_token` = '56d1799d501a6ea5f0e612d22ddba211dc4066ae', `email` = 'ram@example.com', `password` = 'electron', `updated_at` = '2008-01-16 10:33:07' WHERE `id` = 1 ferret_create/update: User : 1 creating doc for class: User, id: 1 Adding field screen_name with value 'millikan' to index Adding field email with value 'ram@example.com' to index Cookie set: authorization_token=56d1799d501a6ea5f0e612d22ddba211dc4066ae; path=/; expires=Tue, 16 Jan 2018 18:33:07 GMT Redirected to http://www.example.com/user Completed in 0.01849 (54 reqs/sec) | DB: 0.00666 (35%) | 302 Found [http://www.example.com/user/login] Processing SiteController#index (for 127.0.0.1 at 2008-01-16 10:33:07) [GET] Session ID: 0dc0ecd3f66e394123a69c12574f4f74 Parameters: {"action"=>"index", "controller"=>"site"} Rendering template within layouts/application Rendering site/index Completed in 0.01248 (80 reqs/sec) | Rendering: 0.00963 (77%) | DB: 0.00000 (0%) | 200 OK [http://www.example.com/site/index] SQL (0.000987) ROLLBACK