New Grocery List


Seperate multiple items with commas
Send To PhoneClear
(default) 15 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `tags`441
5DESCRIBE `recipes`12121
6DESCRIBE `users`991
7DESCRIBE `groups`441
8DESCRIBE `grocery_lists`441
9DESCRIBE `recipes_tags`221
10DESCRIBE `votes`221
11SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'Pork' LIMIT 1111
12SELECT `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` = 13 AND `RecipesTag`.`recipe_id` = `Recipe`.`id`) WHERE 1 = 1 000
13SELECT `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
14SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE 1 = 1 13130
15SELECT `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