A REDE ASSOCIADOS RECEITAS AGENDA DA REDE FALE CONOSCO
 
(default) 14 queries took 57 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `news`884
2DESCRIBE `users`884
3DESCRIBE `groups`773
4DESCRIBE `menus`993
5DESCRIBE `group_menus`334
6DESCRIBE `news_photos`773
7DESCRIBE `restaurant_types`663
8DESCRIBE `restaurants`18184
9DESCRIBE `photos`773
10DESCRIBE `restaurants_restaurant_types`774
11SELECT `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 662
12SELECT `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 (4, 2, 3, 5, 7, 1) AND `RestaurantsRestaurantType`.`restaurant_id` = `Restaurant`.`id`) WHERE `Restaurant`.`id` > 0 ORDER BY `Restaurant`.`name` ASC 323213
13SELECT COUNT(*) AS `count` FROM `news` AS `News` LEFT JOIN `users` AS `Created` ON (`News`.`createdby` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`News`.`modifiedby` = `Modified`.`id`) WHERE 1 = 1 112
14SELECT `News`.`id`, `News`.`title`, `News`.`release`, `News`.`news`, `News`.`created`, `News`.`createdby`, `News`.`modified`, `News`.`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 `news` AS `News` LEFT JOIN `users` AS `Created` ON (`News`.`createdby` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`News`.`modifiedby` = `Modified`.`id`) WHERE 1 = 1 ORDER BY `News`.`release` DESC LIMIT 20, 2020205