New Grocery List


Seperate multiple items with commas

alockerby_wt@yahoo.com's Profile

Member Since 2009-11-13 22:12:59

Contributed 1 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 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `users`992
5DESCRIBE `groups`441
6DESCRIBE `grocery_lists`441
7DESCRIBE `recipes`12121
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` = 23 LIMIT 1111
12SELECT `GroceryLists`.`id`, `GroceryLists`.`user_id`, `GroceryLists`.`name`, `GroceryLists`.`items` FROM `grocery_lists` AS `GroceryLists` WHERE `GroceryLists`.`user_id` = (23) 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` = (23) 110
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 1000
15SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE 1 = 1 13130
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