New Grocery List


Seperate multiple items with commas

armware@gmail.com's Profile

Member Since 2009-09-09 20:47:45

Contributed 3 Recipes

Notice (8): Undefined index:  RatingInfo [APP/views/elements/recipes/box/list_recipe.ctp, line 4]
  • /
/ votes

Add To Grocery List
(default) 16 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`772
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `users`992
5DESCRIBE `groups`441
6DESCRIBE `grocery_lists`441
7DESCRIBE `recipes`12122
8DESCRIBE `tags`441
9DESCRIBE `recipes_tags`221
10DESCRIBE `votes`221
11SELECT `User`.`id`, `User`.`username`, `User`.`phone_number`, `User`.`phone_carrier`, `User`.`password`, `User`.`group_id`, `User`.`active`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`id` = 20 LIMIT 1111
12SELECT `GroceryLists`.`id`, `GroceryLists`.`user_id`, `GroceryLists`.`name`, `GroceryLists`.`items` FROM `grocery_lists` AS `GroceryLists` WHERE `GroceryLists`.`user_id` = (20) 000
13SELECT `Recipes`.`id`, `Recipes`.`user_id`, `Recipes`.`name`, `Recipes`.`servings`, `Recipes`.`description`, `Recipes`.`directions`, `Recipes`.`ingredients`, `Recipes`.`tags`, `Recipes`.`created`, `Recipes`.`updated`, `Recipes`.`votes`, `Recipes`.`rating` FROM `recipes` AS `Recipes` WHERE `Recipes`.`user_id` = (20) 330
14SELECT `User`.`id`, `User`.`username`, `User`.`phone_number`, `User`.`phone_carrier`, `User`.`password`, `User`.`group_id`, `User`.`active`, `User`.`created`, `User`.`modified`, `Group`.`id`, `Group`.`name`, `Group`.`created`, `Group`.`modified` FROM `users` AS `User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` = `Group`.`id`) WHERE `User`.`id` IS NULL LIMIT 1001
15SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE 1 = 1 13131
16SELECT `Recipe`.`id`, `Recipe`.`user_id`, `Recipe`.`name`, `Recipe`.`servings`, `Recipe`.`description`, `Recipe`.`directions`, `Recipe`.`ingredients`, `Recipe`.`tags`, `Recipe`.`created`, `Recipe`.`updated`, `Recipe`.`votes`, `Recipe`.`rating`, `RecipesTag`.`recipe_id`, `RecipesTag`.`tag_id` FROM `recipes` AS `Recipe` JOIN `recipes_tags` AS `RecipesTag` ON (`RecipesTag`.`tag_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13) AND `RecipesTag`.`recipe_id` = `Recipe`.`id`) WHERE 1 = 1 551