A REDE ASSOCIADOS RECEITAS AGENDA DA REDE FALE CONOSCO
 
(default) 23 queries took 157 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `recipes`10106
2DESCRIBE `recipe_types`665
3DESCRIBE `users`887
4DESCRIBE `groups`779
5DESCRIBE `menus`9911
6DESCRIBE `group_menus`335
7DESCRIBE `recipe_photos`773
8DESCRIBE `contents`885
9DESCRIBE `content_photos`775
10DESCRIBE `news`884
11DESCRIBE `news_photos`774
12DESCRIBE `restaurant_types`667
13DESCRIBE `restaurants`18187
14DESCRIBE `photos`775
15DESCRIBE `restaurants_restaurant_types`777
16SELECT `RestaurantType`.`id`, `RestaurantType`.`name`, `RestaurantType`.`created`, `RestaurantType`.`createdby`, `RestaurantType`.`modified`, `RestaurantType`.`modifiedby`, `Created`.`id`, `Created`.`username`, `Created`.`password`, `Created`.`group_id`, `Created`.`created`, `Created`.`createdby`, `Created`.`modified`, `Created`.`modifiedby`, `Modified`.`id`, `Modified`.`username`, `Modified`.`password`, `Modified`.`group_id`, `Modified`.`created`, `Modified`.`createdby`, `Modified`.`modified`, `Modified`.`modifiedby` FROM `restaurant_types` AS `RestaurantType` LEFT JOIN `users` AS `Created` ON (`RestaurantType`.`createdby` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`RestaurantType`.`modifiedby` = `Modified`.`id`) WHERE 1 = 1 ORDER BY RAND() ASC 667
17SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`logo`, `Restaurant`.`website`, `Restaurant`.`email`, `Restaurant`.`address`, `Restaurant`.`telephone`, `Restaurant`.`working_hours`, `Restaurant`.`title1`, `Restaurant`.`text1`, `Restaurant`.`title2`, `Restaurant`.`text2`, `Restaurant`.`title3`, `Restaurant`.`text3`, `Restaurant`.`created`, `Restaurant`.`createdby`, `Restaurant`.`modified`, `Restaurant`.`modifiedby`, `RestaurantsRestaurantType`.`id`, `RestaurantsRestaurantType`.`restaurant_id`, `RestaurantsRestaurantType`.`restaurant_type_id`, `RestaurantsRestaurantType`.`created`, `RestaurantsRestaurantType`.`createdby`, `RestaurantsRestaurantType`.`modified`, `RestaurantsRestaurantType`.`modifiedby` FROM `restaurants` AS `Restaurant` JOIN `restaurants_restaurant_types` AS `RestaurantsRestaurantType` ON (`RestaurantsRestaurantType`.`restaurant_type_id` IN (1, 5, 2, 3, 7, 4) AND `RestaurantsRestaurantType`.`restaurant_id` = `Restaurant`.`id`) WHERE `Restaurant`.`id` > 0 ORDER BY `Restaurant`.`name` ASC 323232
18SELECT `RecipeType`.`id`, `RecipeType`.`name`, `RecipeType`.`created`, `RecipeType`.`createdby`, `RecipeType`.`modified`, `RecipeType`.`modifiedby`, `Created`.`id`, `Created`.`username`, `Created`.`password`, `Created`.`group_id`, `Created`.`created`, `Created`.`createdby`, `Created`.`modified`, `Created`.`modifiedby`, `Modified`.`id`, `Modified`.`username`, `Modified`.`password`, `Modified`.`group_id`, `Modified`.`created`, `Modified`.`createdby`, `Modified`.`modified`, `Modified`.`modifiedby` FROM `recipe_types` AS `RecipeType` LEFT JOIN `users` AS `Created` ON (`RecipeType`.`createdby` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`RecipeType`.`modifiedby` = `Modified`.`id`) WHERE 1 = 1 ORDER BY `RecipeType`.`name` ASC 10105
19SELECT `Recipe`.`id`, `Recipe`.`recipe_type_id`, `Recipe`.`name`, `Recipe`.`ingredients`, `Recipe`.`method`, `Recipe`.`makes`, `Recipe`.`created`, `Recipe`.`createdby`, `Recipe`.`modified`, `Recipe`.`modifiedby` FROM `recipes` AS `Recipe` WHERE `Recipe`.`recipe_type_id` IN (7, 3, 1, 6, 9, 4, 10, 2, 8, 5) ORDER BY RAND() ASC 262610
20SELECT `RecipeType`.`id`, `RecipeType`.`name`, `RecipeType`.`created`, `RecipeType`.`createdby`, `RecipeType`.`modified`, `RecipeType`.`modifiedby`, `Created`.`id`, `Created`.`username`, `Created`.`password`, `Created`.`group_id`, `Created`.`created`, `Created`.`createdby`, `Created`.`modified`, `Created`.`modifiedby`, `Modified`.`id`, `Modified`.`username`, `Modified`.`password`, `Modified`.`group_id`, `Modified`.`created`, `Modified`.`createdby`, `Modified`.`modified`, `Modified`.`modifiedby` FROM `recipe_types` AS `RecipeType` LEFT JOIN `users` AS `Created` ON (`RecipeType`.`createdby` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`RecipeType`.`modifiedby` = `Modified`.`id`) WHERE `RecipeType`.`id` = 9 ORDER BY `RecipeType`.`name` ASC LIMIT 1115
21SELECT `Recipe`.`id`, `Recipe`.`recipe_type_id`, `Recipe`.`name`, `Recipe`.`ingredients`, `Recipe`.`method`, `Recipe`.`makes`, `Recipe`.`created`, `Recipe`.`createdby`, `Recipe`.`modified`, `Recipe`.`modifiedby` FROM `recipes` AS `Recipe` WHERE `Recipe`.`recipe_type_id` = (9) ORDER BY RAND() ASC 443
22SELECT `Recipe`.`id`, `Recipe`.`recipe_type_id`, `Recipe`.`name`, `Recipe`.`ingredients`, `Recipe`.`method`, `Recipe`.`makes`, `Recipe`.`created`, `Recipe`.`createdby`, `Recipe`.`modified`, `Recipe`.`modifiedby`, `RecipeType`.`id`, `RecipeType`.`name`, `RecipeType`.`created`, `RecipeType`.`createdby`, `RecipeType`.`modified`, `RecipeType`.`modifiedby`, `Created`.`id`, `Created`.`username`, `Created`.`password`, `Created`.`group_id`, `Created`.`created`, `Created`.`createdby`, `Created`.`modified`, `Created`.`modifiedby`, `Modified`.`id`, `Modified`.`username`, `Modified`.`password`, `Modified`.`group_id`, `Modified`.`created`, `Modified`.`createdby`, `Modified`.`modified`, `Modified`.`modifiedby` FROM `recipes` AS `Recipe` LEFT JOIN `recipe_types` AS `RecipeType` ON (`Recipe`.`recipe_type_id` = `RecipeType`.`id`) LEFT JOIN `users` AS `Created` ON (`Recipe`.`createdby` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`Recipe`.`modifiedby` = `Modified`.`id`) WHERE 1 = 1 ORDER BY `Recipe`.`id` DESC LIMIT 5553
23SELECT `RecipePhoto`.`id`, `RecipePhoto`.`recipe_id`, `RecipePhoto`.`path`, `RecipePhoto`.`created`, `RecipePhoto`.`createdby`, `RecipePhoto`.`modified`, `RecipePhoto`.`modifiedby` FROM `recipe_photos` AS `RecipePhoto` WHERE `RecipePhoto`.`recipe_id` IN (26, 25, 24, 23, 22) 442