| 1 | DESCRIBE `dishes` | | 20 | 20 | 1 |
| 2 | DESCRIBE `users` | | 23 | 23 | 1 |
| 3 | DESCRIBE `profiles` | | 68 | 68 | 2 |
| 4 | SET NAMES 'UTF8' | | 0 | | 0 |
| 5 | DESCRIBE `facebook_connect` | | 7 | 7 | 1 |
| 6 | DESCRIBE `reviews` | | 11 | 11 | 1 |
| 7 | DESCRIBE `reviewsvotes` | | 8 | 8 | 1 |
| 8 | DESCRIBE `images` | | 11 | 11 | 1 |
| 9 | DESCRIBE `tokens` | | 7 | 7 | 1 |
| 10 | DESCRIBE `user_friends` | | 5 | 5 | 1 |
| 11 | DESCRIBE `bookmarks` | | 5 | 5 | 1 |
| 12 | DESCRIBE `safaris` | | 8 | 8 | 1 |
| 13 | DESCRIBE `dishes_safaris` | | 3 | 3 | 0 |
| 14 | DESCRIBE `safaris_users` | | 3 | 3 | 1 |
| 15 | DESCRIBE `sets` | | 16 | 16 | 1 |
| 16 | DESCRIBE `sets_dishes` | | 6 | 6 | 1 |
| 17 | DESCRIBE `sets_users` | | 7 | 7 | 1 |
| 18 | DESCRIBE `restaurant_locations` | | 21 | 21 | 1 |
| 19 | DESCRIBE `restaurants` | | 7 | 7 | 1 |
| 20 | DESCRIBE `featured_dishes` | | 10 | 10 | 1 |
| 21 | DESCRIBE `dish_images` | | 7 | 7 | 1 |
| 22 | DESCRIBE `dish_image_votes` | | 8 | 8 | 1 |
| 23 | DESCRIBE `tags` | | 2 | 2 | 0 |
| 24 | DESCRIBE `dishes_tags` | | 3 | 3 | 1 |
| 25 | DESCRIBE `dish_wanteds` | | 8 | 8 | 1 |
| 26 | DESCRIBE `dish_wanteds_tags` | | 3 | 3 | 1 |
| 27 | DESCRIBE `dish_wanteds_dishes` | | 3 | 3 | 1 |
| 28 | DESCRIBE `blogbuzz` | | 25 | 25 | 1 |
| 29 | DESCRIBE `blogbuzz_votes` | | 5 | 5 | 1 |
| 30 | DESCRIBE `blogbuzz_comments` | | 6 | 6 | 1 |
| 31 | DESCRIBE `blogbuzz_dishes` | | 3 | 3 | 1 |
| 32 | SELECT `Dish`.*, `Location`.*, `User`.*, `Restaurant`.`name`, (((acos(sin((37.5149*pi()/180)) * sin((Location.latitude*pi()/180)) + cos((37.5149*pi()/180)) * cos((Location.latitude*pi()/180)) * cos(((-122.5033 - Location.longitude) * pi()/180)))) * 180/pi()) * 60 * 1.1515) as distance_from_user FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) LEFT JOIN `users` AS `User` ON (`Dish`.`user_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`longitude` BETWEEN -122.937001498 AND -122.069598502 AND `Location`.`latitude` BETWEEN 37.0811985023 AND 37.9486014977 AND `Dish`.`disabled`=0 ORDER BY `last_review_date` DESC LIMIT 5 | | 5 | 5 | 29 |
| 33 | SELECT `Tag`.`id`, `Tag`.`tag`, `DishesTag`.`id`, `DishesTag`.`dish_id`, `DishesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `dishes_tags` AS `DishesTag` ON (`DishesTag`.`dish_id` IN (3830, 3829, 3822, 3821, 3764) AND `DishesTag`.`tag_id` = `Tag`.`id`) WHERE 1 = 1 ORDER BY `DishesTag`.`id` ASC | | 9 | 9 | 0 |
| 34 | SELECT `DishSet`.`id`, `DishSet`.`user_id`, `DishSet`.`name`, `DishSet`.`description`, `DishSet`.`private`, `DishSet`.`location`, `DishSet`.`country_name_code`, `DishSet`.`administrative_area`, `DishSet`.`locality_name`, `DishSet`.`postal_code`, `DishSet`.`latitude`, `DishSet`.`longitude`, `DishSet`.`count_users`, `DishSet`.`count_dishes`, `DishSet`.`created`, `DishSet`.`modified`, `SetsDish`.`id`, `SetsDish`.`set_id`, `SetsDish`.`dish_id`, `SetsDish`.`order`, `SetsDish`.`created`, `SetsDish`.`modified` FROM `sets` AS `DishSet` JOIN `sets_dishes` AS `SetsDish` ON (`SetsDish`.`dish_id` IN (3830, 3829, 3822, 3821, 3764) AND `SetsDish`.`set_id` = `DishSet`.`id`) WHERE 1 = 1 | | 0 | 0 | 0 |
| 35 | SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1661' LIMIT 1 | | 1 | 1 | 0 |
| 36 | SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (1661) | | 4 | 4 | 0 |
| 37 | SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3830' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1 | | 1 | 1 | 0 |
| 38 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3830' | | 1 | 1 | 0 |
| 39 | SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3830 ORDER BY `Image`.`created` DESC LIMIT 1 | | 0 | 0 | 0 |
| 40 | SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1661' LIMIT 1 | | 1 | 1 | 0 |
| 41 | SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (1661) | | 4 | 4 | 0 |
| 42 | SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3829' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1 | | 1 | 1 | 0 |
| 43 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3829' | | 1 | 1 | 0 |
| 44 | SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3829 ORDER BY `Image`.`created` DESC LIMIT 1 | | 0 | 0 | 0 |
| 45 | SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='1808' LIMIT 1 | | 1 | 1 | 0 |
| 46 | SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (1808) | | 3 | 3 | 0 |
| 47 | SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3822' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1 | | 1 | 1 | 0 |
| 48 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3822' | | 1 | 1 | 0 |
| 49 | SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3822 ORDER BY `Image`.`created` DESC LIMIT 1 | | 0 | 0 | 0 |
| 50 | SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2412' LIMIT 1 | | 1 | 1 | 0 |
| 51 | SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2412) | | 1 | 1 | 0 |
| 52 | SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3821' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1 | | 1 | 1 | 0 |
| 53 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3821' | | 1 | 1 | 0 |
| 54 | SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3821 ORDER BY `Image`.`created` DESC LIMIT 1 | | 0 | 0 | 0 |
| 55 | SELECT `Restaurant`.*, `Location`.`id` FROM `restaurant_locations` AS `Location` LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`id`='2380' LIMIT 1 | | 1 | 1 | 0 |
| 56 | SELECT `Dish`.`id`, `Dish`.`user_id`, `Dish`.`name`, `Dish`.`location_id`, `Dish`.`disabled`, `Dish`.`created`, `Dish`.`modified`, `Dish`.`vote_avg`, `Dish`.`vote_count`, `Dish`.`members_vote_avg`, `Dish`.`members_vote_count`, `Dish`.`industry_vote_avg`, `Dish`.`industry_vote_count`, `Dish`.`critics_vote_avg`, `Dish`.`critics_vote_count`, `Dish`.`last_review_date`, `Dish`.`review_count`, `Dish`.`is_divine`, `Dish`.`dish_image_filepath`, `Dish`.`dish_image_created` FROM `dishes` AS `Dish` WHERE `Dish`.`location_id` = (2380) | | 1 | 1 | 0 |
| 57 | SELECT dishes.vote_avg, reviews.*, users.*, profiles.image, profiles.image_small FROM dishes LEFT JOIN reviews ON dishes.id=reviews.dish_id LEFT JOIN users ON reviews.user_id=users.id LEFT JOIN profiles ON users.id=profiles.user_id WHERE dishes.id='3764' AND reviews.disabled=0 ORDER BY reviews.created DESC LIMIT 0,1 | | 1 | 1 | 0 |
| 58 | SELECT COUNT(*) AS `count` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON (`Review`.`user_id` = `User`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Review`.`dish_id` = `Dish`.`id`) WHERE dish_id='3764' | | 1 | 1 | 0 |
| 59 | SELECT `Image`.*, `OriginalImage`.*, `DishImage`.`id` FROM `dish_images` AS `DishImage` LEFT JOIN `dishes` AS `Dish` ON (`DishImage`.`dish_id` = `Dish`.`id`) LEFT JOIN `images` AS `Image` ON (`DishImage`.`image_id` = `Image`.`id`) LEFT JOIN `images` AS `OriginalImage` ON (`DishImage`.`original_image_id` = `OriginalImage`.`id`) WHERE dish_id=3764 ORDER BY `Image`.`created` DESC LIMIT 1 | | 1 | 1 | 0 |
| 60 | SELECT COUNT(*) AS `count` FROM `dishes` AS `Dish` LEFT JOIN `restaurant_locations` AS `Location` ON (`Dish`.`location_id` = `Location`.`id`) LEFT JOIN `users` AS `User` ON (`Dish`.`user_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Location`.`restaurant_id` = `Restaurant`.`id`) WHERE `Location`.`longitude` BETWEEN -122.937001498 AND -122.069598502 AND `Location`.`latitude` BETWEEN 37.0811985023 AND 37.9486014977 AND `Dish`.`disabled`=0 | | 1 | 1 | 8 |
| 61 | SELECT `DishSet`.*, `DishSet`.`id` FROM `sets` AS `DishSet` LEFT JOIN `users` AS `User` ON (`DishSet`.`user_id` = `User`.`id`) WHERE `DishSet`.`name` <> "Must Try" AND `DishSet`.`count_dishes` > 0 ORDER BY `DishSet`.`modified` DESC LIMIT 5 | | 5 | 5 | 0 |
