• 4.00/5
4.00/51 vote
(default) 14 queries took 13 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `recipes`12121
5DESCRIBE `users`991
6DESCRIBE `groups`441
7DESCRIBE `grocery_lists`441
8DESCRIBE `tags`441
9DESCRIBE `recipes_tags`221
10DESCRIBE `votes`221
11SELECT `Recipe`.`votes`, `Recipe`.`rating` FROM `recipes` AS `Recipe` LEFT JOIN `users` AS `User` ON (`Recipe`.`user_id` = `User`.`id`) WHERE `Recipe`.`id` = 18 LIMIT 1111
12SELECT `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
13SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`created`, `Tag`.`modified` FROM `tags` AS `Tag` WHERE 1 = 1 13131
14SELECT `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