gistfile1.txt

rocessing RecipesController#show (for 127.0.0.1 at 2009-03-12 14:19:55) [GET]
  Session ID: 34efed253de0dc37b0abe6683682c66e
  Parameters: {"action"=>"show", "id"=>"1764", "controller"=>"recipes"}
  ^[[4;35;1mCategory Load (4.8ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE categories.id, categories.name, COUNT(*) AS count FROM `categories` LEFT OUTER JOIN categories_recipes ON categories.id = categories_recipes.category_id GROUP BY categori$
  ^[[4;36;1mCategory Columns (0.6ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `categories`^[[0m
  ^[[4;35;1mRecipe Load (56.3ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `recipes`.*, t0.category_id as the_parent_record_id FROM `recipes` INNER JOIN `categories_recipes` as t0 ON `recipes`.id = t0.recipe_id WHERE (t0.category_id IN (35,12,5,2$
  ^[[4;36;1mRecipe Columns (1.0ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `recipes`^[[0m
  ^[[4;35;1mUser Columns (0.9ms)^[[0m   ^[[0mSHOW FIELDS FROM `users`^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` = 7) LIMIT 1^[[0m
  ^[[4;35;1mPlanning Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `plannings` WHERE (week = 11 and year = 2009) AND (`plannings`.user_id = 7) ORDER BY updated_at DESC LIMIT 1^[[0m
  ^[[4;36;1mImage Columns (0.8ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `images`^[[0m
  ^[[4;35;1mFlickrphoto Columns (0.5ms)^[[0m   ^[[0mSHOW FIELDS FROM `flickrphotos`^[[0m
  ^[[4;36;1mNewsfeed Columns (0.5ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `newsfeeds`^[[0m
  ^[[4;35;1mAvatar Columns (0.6ms)^[[0m   ^[[0mSHOW FIELDS FROM `avatars`^[[0m
  ^[[4;36;1mPlanning Columns (0.5ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `plannings`^[[0m
  ^[[4;35;1mFavorite Columns (0.5ms)^[[0m   ^[[0mSHOW FIELDS FROM `favorites`^[[0m
  ^[[4;36;1mRecipe Load IDs For Limited Eager Loading (0.3ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE DISTINCT `recipes`.id FROM `recipes` INNER JOIN `slugs` ON `slugs`.sluggable_id = `recipes`.id AND `slugs`.sluggable_type = 'Recipe' WHERE ($
  ^[[4;35;1mRecipe Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `recipes` WHERE (`recipes`.`id` = 1764) LIMIT 1^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` = 1) ^[[0m
  ^[[4;35;1mComment Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `comments`.* FROM `comments` WHERE (`comments`.`commentable_id` = 1764 and `comments`.`commentable_type` = 'Recipe') ORDER BY created_at ASC^[[0m
  ^[[4;36;1mImage Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE `images`.* FROM `images` WHERE (`images`.`asset_id` = 1764 and `images`.`asset_type` = 'Recipe') ^[[0m
  ^[[4;35;1mFlickrphoto Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `flickrphotos`.* FROM `flickrphotos` WHERE (`flickrphotos`.recipe_id = 1764) ^[[0m

  ^[[4;36;1mImage Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE `images`.* FROM `images` WHERE (`images`.`asset_id` = 1764 and `images`.`asset_type` = 'Recipe') ^[[0m
  ^[[4;35;1mFlickrphoto Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `flickrphotos`.* FROM `flickrphotos` WHERE (`flickrphotos`.recipe_id = 1764) ^[[0m
  ^[[4;36;1mNewsfeed Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE `newsfeeds`.* FROM `newsfeeds` WHERE (`newsfeeds`.`newsfeedable_id` = 1764 and `newsfeeds`.`newsfeedable_type` = 'Recipe') ORDER BY created_at DESC^[[0m
  ^[[4;35;1mAvatar Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `avatars`.* FROM `avatars` WHERE (`avatars`.`asset_id` = 1 and `avatars`.`asset_type` = 'User') ^[[0m
  ^[[4;36;1mPlanning Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE `plannings`.*, t0.recipe_id as the_parent_record_id FROM `plannings` INNER JOIN `plannings_recipes` as t0 ON `plannings`.id = t0.planning_id WHERE (t0.recipe_id = 1764)$
  ^[[4;35;1mFavorite Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `favorites`.* FROM `favorites` WHERE (`favorites`.`favorable_id` = 1764 and `favorites`.`favorable_type` = 'Recipe') ^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` = 7) ^[[0m
  ^[[4;35;1mSQL (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE count(*) AS count_all FROM `users` INNER JOIN favorites ON users.id = favorites.user_id WHERE ((`favorites`.favorable_type = 'Recipe') AND (`favorites`.favorable_id = 1764)) ^[[0m
  ^[[4;36;1mSQL (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE count(*) AS count_all FROM `plannings` INNER JOIN `plannings_recipes` ON `plannings`.id = `plannings_recipes`.planning_id WHERE (`plannings_recipes`.recipe_id = 1764 ) ^[[0m
  ^[[4;35;1mVisit Columns (0.5ms)^[[0m   ^[[0mSHOW FIELDS FROM `visits`^[[0m
  ^[[4;36;1mVisit Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `visits` WHERE (`visits`.`recipe_id` = 1764 AND `visits`.`user_id` = 7) LIMIT 1^[[0m
  ^[[4;35;1mSQL (0.1ms)^[[0m   ^[[0mBEGIN^[[0m
  ^[[4;36;1mVisit Update (0.2ms)^[[0m   ^[[0;1mUPDATE `visits` SET `updated_at` = '2009-03-12 14:19:56' WHERE `id` = 54^[[0m
  ^[[4;35;1mSQL (8.1ms)^[[0m   ^[[0mCOMMIT^[[0m
  ^[[4;36;1mSQL (0.1ms)^[[0m   ^[[0;1mBEGIN^[[0m
  ^[[4;35;1mSQL (0.1ms)^[[0m   ^[[0mCOMMIT^[[0m
Rendering template within layouts/app_save
Rendering recipes/show
  ^[[4;36;1mFavorite Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `favorites` WHERE (user_id = 7 AND favorable_type = 'User' AND favorable_id = 1) LIMIT 1^[[0m
  ^[[4;35;1mRecipe Exists (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `recipes`.id FROM `recipes` INNER JOIN `plannings_recipes` ON `recipes`.id = `plannings_recipes`.recipe_id WHERE (`recipes`.`id` = 1764) AND (`plannings_recipes`.planning$
  ^[[4;36;1mJoin Table Columns (0.6ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `plannings_recipes`^[[0m
  ^[[4;35;1mRecipe Load (0.3ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `recipes` INNER JOIN `plannings_recipes` ON `recipes`.id = `plannings_recipes`.recipe_id WHERE (`plannings_recipes`.planning_id = 7 ) ^[[0m
  ^[[4;36;1mRating Columns (0.5ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `ratings`^[[0m
  ^[[4;35;1mSQL (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE count(*) AS count_all FROM `ratings` WHERE (rater_id = 7) AND (`ratings`.rated_id = 1764 AND `ratings`.rated_type = 'Recipe') ^[[0m
  ^[[4;36;1mSQL (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE count(*) AS count_all FROM `comments` WHERE (`comments`.commentable_id = 1764 AND `comments`.commentable_type = 'Recipe') ^[[0m
  ^[[4;35;1mSlug Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `slugs` WHERE (`slugs`.sluggable_id = 1764 AND `slugs`.sluggable_type = 'Recipe') ORDER BY id DESC LIMIT 1^[[0m
  ^[[4;36;1mSQL (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE count(*) AS count_all FROM `ratings` WHERE (rater_id = 7) AND (`ratings`.rated_id = 1764 AND `ratings`.rated_type = 'Recipe') ^[[0m
Rendered comments/_new (4.0ms)
  ^[[4;35;1mSearch Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `searches` ORDER BY created_at DESC LIMIT 5^[[0m
  ^[[4;36;1mSearch Columns (0.5ms)^[[0m   ^[[0;1mSHOW FIELDS FROM `searches`^[[0m
Rendered common/_searchbox (5.8ms)
Rendered common/_mainmenu (0.6ms)
Rendered common/_myaccount (0.1ms)
  ^[[4;35;1mImage Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `images` WHERE (`images`.asset_id = 1764 AND `images`.asset_type = 'Recipe') LIMIT 1^[[0m
  ^[[4;36;1mFlickrphoto Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `flickrphotos` WHERE (`flickrphotos`.recipe_id = 1764) LIMIT 1^[[0m
  ^[[4;35;1mFlickrphoto Load (1.1ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `flickrphotos` WHERE (`flickrphotos`.recipe_id = 1764) LIMIT 1^[[0m
  ^[[4;36;1mImage Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `images` WHERE (`images`.asset_id = 1764 AND `images`.asset_type = 'Recipe') LIMIT 1^[[0m
  ^[[4;35;1mSlug Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `slugs` WHERE (`slugs`.sluggable_id = 1764 AND `slugs`.sluggable_type = 'Recipe') ORDER BY id DESC LIMIT 1^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` = 1) ^[[0m
  ^[[4;35;1mImage Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `images` WHERE (`images`.asset_id = 8317 AND `images`.asset_type = 'Recipe') LIMIT 1^[[0m
  ^[[4;36;1mImage Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `images` WHERE (`images`.asset_id = 8317 AND `images`.asset_type = 'Recipe') LIMIT 1^[[0m
  ^[[4;35;1mSlug Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `slugs` WHERE (`slugs`.sluggable_id = 8317 AND `slugs`.sluggable_type = 'Recipe') ORDER BY id DESC LIMIT 1^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` = 3) ^[[0m
Rendered plannings/_sidebar (187.8ms)
  ^[[4;35;1mVisit Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `visits` WHERE (`visits`.user_id = 7) ORDER BY updated_at DESC LIMIT 5^[[0m
  ^[[4;36;1mRecipe Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `recipes` WHERE (`recipes`.`id` IN (8317,1764)) ^[[0m
  ^[[4;35;1mImage Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `images`.* FROM `images` WHERE (`images`.`asset_id` IN (1764,8317) and `images`.`asset_type` = 'Recipe') ^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` = 7) ^[[0m
  ^[[4;35;1mFlickrphoto Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE `flickrphotos`.* FROM `flickrphotos` WHERE (`flickrphotos`.recipe_id IN (1764,8317)) ^[[0m
  ^[[4;36;1mUser Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `users` WHERE (`users`.`id` IN (1,3)) ^[[0m
  ^[[4;35;1mSlug Load (0.2ms)^[[0m   ^[[0mSELECT SQL_NO_CACHE * FROM `slugs` WHERE (`slugs`.sluggable_id = 1764 AND `slugs`.sluggable_type = 'Recipe') ORDER BY id DESC LIMIT 1^[[0m
  ^[[4;36;1mSlug Load (0.2ms)^[[0m   ^[[0;1mSELECT SQL_NO_CACHE * FROM `slugs` WHERE (`slugs`.sluggable_id = 8317 AND `slugs`.sluggable_type = 'Recipe') ORDER BY id DESC LIMIT 1^[[0m
Rendered visits/_visit (34.5ms)
Rendered visits/_listed (0.2ms)
Completed in 828ms (View: 267, DB: 99) | 200 OK [http://127.0.0.1/recipes/1764]