| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Place`.`id`, `Place`.`review_count`, `Place`.`latest_review_id`, `Place`.`latest_review_year`, `Place`.`location_id`, `Place`.`name`, `Place`.`name_2`, `Place`.`num_view`, `Place`.`address`, `Place`.`address_2`, `Place`.`type`, `Place`.`telephone`, `Place`.`telephone_2`, `Place`.`geo_lat`, `Place`.`geo_lng`, `Place`.`geo_zoom`, `Place`.`created`, `Place`.`modified`, `Place`.`status`, `Place`.`publish_at`, `Place`.`unpublish_at`, `Place`.`close_at`, `Place`.`paid_period_start_at`, `Place`.`paid_period_end_at`, `Place`.`brg`, `Place`.`group`, `Place`.`group_2`, `Place`.`branch`, `Place`.`branch_2`, `Place`.`deck`, `Place`.`deck_2`, `Place`.`author`, `Place`.`author_2`, `Place`.`cuisine`, `Place`.`cuisine_2`, `Place`.`sub_cusine`, `Place`.`sub_cusine_2`, `Place`.`overview_website`, `Place`.`reservation`, `Place`.`reservation_tel`, `Place`.`overview_email`, `Place`.`year_established`, `Place`.`opening_hours`, `Place`.`opening_hours_2`, `Place`.`lunch_hours`, `Place`.`lunch_hours_2`, `Place`.`dinner_hours`, `Place`.`dinner_hours_2`, `Place`.`happy_hours`, `Place`.`happy_hours_2`, `Place`.`music_hours`, `Place`.`food_hours`, `Place`.`food`, `Place`.`food_2`, `Place`.`type_of_music`, `Place`.`type_of_music_2`, `Place`.`dress_code`, `Place`.`dress_code_2`, `Place`.`buffet`, `Place`.`buffet_description`, `Place`.`buffet_description_2`, `Place`.`vegetarian_dish`, `Place`.`vegetarian_dish_2`, `Place`.`own_wine`, `Place`.`corkage_charge`, `Place`.`corkage_charge_2`, `Place`.`private_room`, `Place`.`private_room_description`, `Place`.`private_room_description_2`, `Place`.`car_valet`, `Place`.`smoking_area`, `Place`.`smoking_area_2`, `Place`.`accept_credit_card`, `Place`.`amex_accept`, `Place`.`amex_selects_until`, `Place`.`amex_selects_content`, `Place`.`amex_1_for_1_until`, `Place`.`amex_1_for_1_content`, `Place`.`amex_top_10`, `Place`.`seo_meta_keywords`, `Place`.`seo_meta_keywords_2`, `Place`.`seo_meta_description`, `Place`.`seo_meta_description_2`, `Place`.`slug`, `Place`.`reserve_table`, `Place`.`alcoholic_beverage`, `Place`.`no_of_seats`, `Place`.`delivery`, `Place`.`payment`, `Place`.`display_type`, `Place`.`rss`, `Place`.`restaurant_type`, `Place`.`awards` FROM `atd_cn`.`places` AS `Place` WHERE `Place`.`slug` = 'Kennys-Burgers-2017' AND `Place`.`status` = '1' LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `atd_cn`.`places` AS `Place` WHERE `Place`.`id` = 681 | 1 | 1 | 0 | |
| SELECT `Place`.`id`, `Place`.`review_count`, `Place`.`latest_review_id`, `Place`.`latest_review_year`, `Place`.`location_id`, `Place`.`name`, `Place`.`name_2`, `Place`.`num_view`, `Place`.`address`, `Place`.`address_2`, `Place`.`type`, `Place`.`telephone`, `Place`.`telephone_2`, `Place`.`geo_lat`, `Place`.`geo_lng`, `Place`.`geo_zoom`, `Place`.`created`, `Place`.`modified`, `Place`.`status`, `Place`.`publish_at`, `Place`.`unpublish_at`, `Place`.`close_at`, `Place`.`paid_period_start_at`, `Place`.`paid_period_end_at`, `Place`.`brg`, `Place`.`group`, `Place`.`group_2`, `Place`.`branch`, `Place`.`branch_2`, `Place`.`deck`, `Place`.`deck_2`, `Place`.`author`, `Place`.`author_2`, `Place`.`cuisine`, `Place`.`cuisine_2`, `Place`.`sub_cusine`, `Place`.`sub_cusine_2`, `Place`.`overview_website`, `Place`.`reservation`, `Place`.`reservation_tel`, `Place`.`overview_email`, `Place`.`year_established`, `Place`.`opening_hours`, `Place`.`opening_hours_2`, `Place`.`lunch_hours`, `Place`.`lunch_hours_2`, `Place`.`dinner_hours`, `Place`.`dinner_hours_2`, `Place`.`happy_hours`, `Place`.`happy_hours_2`, `Place`.`music_hours`, `Place`.`food_hours`, `Place`.`food`, `Place`.`food_2`, `Place`.`type_of_music`, `Place`.`type_of_music_2`, `Place`.`dress_code`, `Place`.`dress_code_2`, `Place`.`buffet`, `Place`.`buffet_description`, `Place`.`buffet_description_2`, `Place`.`vegetarian_dish`, `Place`.`vegetarian_dish_2`, `Place`.`own_wine`, `Place`.`corkage_charge`, `Place`.`corkage_charge_2`, `Place`.`private_room`, `Place`.`private_room_description`, `Place`.`private_room_description_2`, `Place`.`car_valet`, `Place`.`smoking_area`, `Place`.`smoking_area_2`, `Place`.`accept_credit_card`, `Place`.`amex_accept`, `Place`.`amex_selects_until`, `Place`.`amex_selects_content`, `Place`.`amex_1_for_1_until`, `Place`.`amex_1_for_1_content`, `Place`.`amex_top_10`, `Place`.`seo_meta_keywords`, `Place`.`seo_meta_keywords_2`, `Place`.`seo_meta_description`, `Place`.`seo_meta_description_2`, `Place`.`slug`, `Place`.`reserve_table`, `Place`.`alcoholic_beverage`, `Place`.`no_of_seats`, `Place`.`delivery`, `Place`.`payment`, `Place`.`display_type`, `Place`.`rss`, `Place`.`restaurant_type`, `Place`.`awards`, `LatestReview`.`id`, `LatestReview`.`place_id`, `LatestReview`.`year`, `LatestReview`.`created`, `LatestReview`.`modified`, `LatestReview`.`status`, `LatestReview`.`publish_at`, `LatestReview`.`unpublish_at`, `LatestReview`.`review_setting`, `LatestReview`.`review_setting_2`, `LatestReview`.`review_setting_rating`, `LatestReview`.`review_food`, `LatestReview`.`review_food_2`, `LatestReview`.`review_food_rating`, `LatestReview`.`review_wine`, `LatestReview`.`review_wine_2`, `LatestReview`.`review_wine_rating`, `LatestReview`.`review_service`, `LatestReview`.`review_service_2`, `LatestReview`.`review_service_rating`, `LatestReview`.`review_price`, `LatestReview`.`review_price_2`, `LatestReview`.`review_price_rating`, `LatestReview`.`review_why_go`, `LatestReview`.`review_what_to_order`, `LatestReview`.`review_general`, `LatestReview`.`review_general_2`, `LatestReview`.`tagging`, `LatestReview`.`stick_to_top_panel`, `LatestReview`.`stick_to_top_panel_until`, `LatestReview`.`stick_to_landing_top`, `LatestReview`.`stick_to_landing_top_until`, `LatestReview`.`stick_to_right_column`, `LatestReview`.`stick_to_right_column_until`, `LatestReview`.`seo_meta_keywords`, `LatestReview`.`seo_meta_description`, `LatestReview`.`slug`, `LatestReview`.`old_id`, `LatestReview`.`author`, `LatestReview`.`author_2`, `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`places` AS `Place` LEFT JOIN `atd_cn`.`reviews` AS `LatestReview` ON (`Place`.`latest_review_id` = `LatestReview`.`id`) LEFT JOIN `atd_cn`.`locations` AS `Location` ON (`Place`.`location_id` = `Location`.`id`) WHERE `Place`.`id` = 681 AND `Place`.`status` = '1' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `LatestReview`.`id`, `LatestReview`.`place_id`, `LatestReview`.`year`, `LatestReview`.`created`, `LatestReview`.`modified`, `LatestReview`.`status`, `LatestReview`.`publish_at`, `LatestReview`.`unpublish_at`, `LatestReview`.`review_setting`, `LatestReview`.`review_setting_2`, `LatestReview`.`review_setting_rating`, `LatestReview`.`review_food`, `LatestReview`.`review_food_2`, `LatestReview`.`review_food_rating`, `LatestReview`.`review_wine`, `LatestReview`.`review_wine_2`, `LatestReview`.`review_wine_rating`, `LatestReview`.`review_service`, `LatestReview`.`review_service_2`, `LatestReview`.`review_service_rating`, `LatestReview`.`review_price`, `LatestReview`.`review_price_2`, `LatestReview`.`review_price_rating`, `LatestReview`.`review_why_go`, `LatestReview`.`review_what_to_order`, `LatestReview`.`review_general`, `LatestReview`.`review_general_2`, `LatestReview`.`tagging`, `LatestReview`.`stick_to_top_panel`, `LatestReview`.`stick_to_top_panel_until`, `LatestReview`.`stick_to_landing_top`, `LatestReview`.`stick_to_landing_top_until`, `LatestReview`.`stick_to_right_column`, `LatestReview`.`stick_to_right_column_until`, `LatestReview`.`seo_meta_keywords`, `LatestReview`.`seo_meta_description`, `LatestReview`.`slug`, `LatestReview`.`old_id`, `LatestReview`.`author`, `LatestReview`.`author_2` FROM `atd_cn`.`reviews` AS `LatestReview` WHERE `LatestReview`.`id` = 684 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 | 1 | 1 | 0 | |
| SELECT `Review`.`id`, `Review`.`place_id`, `Review`.`year`, `Review`.`created`, `Review`.`modified`, `Review`.`status`, `Review`.`publish_at`, `Review`.`unpublish_at`, `Review`.`review_setting`, `Review`.`review_setting_2`, `Review`.`review_setting_rating`, `Review`.`review_food`, `Review`.`review_food_2`, `Review`.`review_food_rating`, `Review`.`review_wine`, `Review`.`review_wine_2`, `Review`.`review_wine_rating`, `Review`.`review_service`, `Review`.`review_service_2`, `Review`.`review_service_rating`, `Review`.`review_price`, `Review`.`review_price_2`, `Review`.`review_price_rating`, `Review`.`review_why_go`, `Review`.`review_what_to_order`, `Review`.`review_general`, `Review`.`review_general_2`, `Review`.`tagging`, `Review`.`stick_to_top_panel`, `Review`.`stick_to_top_panel_until`, `Review`.`stick_to_landing_top`, `Review`.`stick_to_landing_top_until`, `Review`.`stick_to_right_column`, `Review`.`stick_to_right_column_until`, `Review`.`seo_meta_keywords`, `Review`.`seo_meta_description`, `Review`.`slug`, `Review`.`old_id`, `Review`.`author`, `Review`.`author_2` FROM `atd_cn`.`reviews` AS `Review` WHERE `Review`.`status` = '1' AND `Review`.`place_id` = (681) ORDER BY `Review`.`id` DESC | 1 | 1 | 2 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`image1_url`, `Image`.`image2_url`, `Image`.`image3_url`, `Image`.`image4_url`, `Image`.`image5_url`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`carousel_url`, `Image`.`carousel_large_url`, `Image`.`original_url`, `Image`.`created`, `Image`.`is_cover`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover`, `Image`.`sort` FROM `atd_cn`.`images` AS `Image` WHERE `Image`.`object_type` = 'review' AND `Image`.`object_id` = (684) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 2 | 2 | 3 | maybe slow |
| SELECT `Dish`.`id`, `Dish`.`place_id`, `Dish`.`name`, `Dish`.`name_2` FROM `atd_cn`.`dishes` AS `Dish` WHERE `Dish`.`place_id` = (681) | 3 | 3 | 1 | maybe slow |
| SELECT `PlacesMenu`.`id`, `PlacesMenu`.`place_id`, `PlacesMenu`.`source`, `PlacesMenu`.`name`, `PlacesMenu`.`title`, `PlacesMenu`.`url`, `PlacesMenu`.`usage`, `PlacesMenu`.`ext`, `PlacesMenu`.`type`, `PlacesMenu`.`filesize`, `PlacesMenu`.`created` FROM `atd_cn`.`places_menus` AS `PlacesMenu` WHERE `PlacesMenu`.`place_id` = (681) | 0 | 0 | 0 | |
| SELECT `RelatedPlace`.`id`, `RelatedPlace`.`review_count`, `RelatedPlace`.`latest_review_id`, `RelatedPlace`.`latest_review_year`, `RelatedPlace`.`location_id`, `RelatedPlace`.`name`, `RelatedPlace`.`name_2`, `RelatedPlace`.`num_view`, `RelatedPlace`.`address`, `RelatedPlace`.`address_2`, `RelatedPlace`.`type`, `RelatedPlace`.`telephone`, `RelatedPlace`.`telephone_2`, `RelatedPlace`.`geo_lat`, `RelatedPlace`.`geo_lng`, `RelatedPlace`.`geo_zoom`, `RelatedPlace`.`created`, `RelatedPlace`.`modified`, `RelatedPlace`.`status`, `RelatedPlace`.`publish_at`, `RelatedPlace`.`unpublish_at`, `RelatedPlace`.`close_at`, `RelatedPlace`.`paid_period_start_at`, `RelatedPlace`.`paid_period_end_at`, `RelatedPlace`.`brg`, `RelatedPlace`.`group`, `RelatedPlace`.`group_2`, `RelatedPlace`.`branch`, `RelatedPlace`.`branch_2`, `RelatedPlace`.`deck`, `RelatedPlace`.`deck_2`, `RelatedPlace`.`author`, `RelatedPlace`.`author_2`, `RelatedPlace`.`cuisine`, `RelatedPlace`.`cuisine_2`, `RelatedPlace`.`sub_cusine`, `RelatedPlace`.`sub_cusine_2`, `RelatedPlace`.`overview_website`, `RelatedPlace`.`reservation`, `RelatedPlace`.`reservation_tel`, `RelatedPlace`.`overview_email`, `RelatedPlace`.`year_established`, `RelatedPlace`.`opening_hours`, `RelatedPlace`.`opening_hours_2`, `RelatedPlace`.`lunch_hours`, `RelatedPlace`.`lunch_hours_2`, `RelatedPlace`.`dinner_hours`, `RelatedPlace`.`dinner_hours_2`, `RelatedPlace`.`happy_hours`, `RelatedPlace`.`happy_hours_2`, `RelatedPlace`.`music_hours`, `RelatedPlace`.`food_hours`, `RelatedPlace`.`food`, `RelatedPlace`.`food_2`, `RelatedPlace`.`type_of_music`, `RelatedPlace`.`type_of_music_2`, `RelatedPlace`.`dress_code`, `RelatedPlace`.`dress_code_2`, `RelatedPlace`.`buffet`, `RelatedPlace`.`buffet_description`, `RelatedPlace`.`buffet_description_2`, `RelatedPlace`.`vegetarian_dish`, `RelatedPlace`.`vegetarian_dish_2`, `RelatedPlace`.`own_wine`, `RelatedPlace`.`corkage_charge`, `RelatedPlace`.`corkage_charge_2`, `RelatedPlace`.`private_room`, `RelatedPlace`.`private_room_description`, `RelatedPlace`.`private_room_description_2`, `RelatedPlace`.`car_valet`, `RelatedPlace`.`smoking_area`, `RelatedPlace`.`smoking_area_2`, `RelatedPlace`.`accept_credit_card`, `RelatedPlace`.`amex_accept`, `RelatedPlace`.`amex_selects_until`, `RelatedPlace`.`amex_selects_content`, `RelatedPlace`.`amex_1_for_1_until`, `RelatedPlace`.`amex_1_for_1_content`, `RelatedPlace`.`amex_top_10`, `RelatedPlace`.`seo_meta_keywords`, `RelatedPlace`.`seo_meta_keywords_2`, `RelatedPlace`.`seo_meta_description`, `RelatedPlace`.`seo_meta_description_2`, `RelatedPlace`.`slug`, `RelatedPlace`.`reserve_table`, `RelatedPlace`.`alcoholic_beverage`, `RelatedPlace`.`no_of_seats`, `RelatedPlace`.`delivery`, `RelatedPlace`.`payment`, `RelatedPlace`.`display_type`, `RelatedPlace`.`rss`, `RelatedPlace`.`restaurant_type`, `RelatedPlace`.`awards`, `PlaceRelationship`.`id`, `PlaceRelationship`.`place_id`, `PlaceRelationship`.`related_place_id` FROM `atd_cn`.`places` AS `RelatedPlace` JOIN `atd_cn`.`place_relationships` AS `PlaceRelationship` ON (`PlaceRelationship`.`place_id` = 681 AND `PlaceRelationship`.`related_place_id` = `RelatedPlace`.`id`) LIMIT 10 | 5 | 5 | 1 | maybe slow |
| SELECT `RelatedNews`.`id`, `RelatedNews`.`num_view`, `RelatedNews`.`status`, `RelatedNews`.`author`, `RelatedNews`.`publish_at`, `RelatedNews`.`unpublish_at`, `RelatedNews`.`type`, `RelatedNews`.`category`, `RelatedNews`.`place_id`, `RelatedNews`.`title`, `RelatedNews`.`title_2`, `RelatedNews`.`deck`, `RelatedNews`.`deck_2`, `RelatedNews`.`content`, `RelatedNews`.`content_2`, `RelatedNews`.`tagging`, `RelatedNews`.`tagging_2`, `RelatedNews`.`stick_top_panel`, `RelatedNews`.`stick_top_panel_until`, `RelatedNews`.`stick_landing_top`, `RelatedNews`.`stick_landing_top_until`, `RelatedNews`.`seo_meta_keywords`, `RelatedNews`.`seo_meta_keywords_2`, `RelatedNews`.`seo_meta_description`, `RelatedNews`.`seo_meta_description_2`, `RelatedNews`.`slug`, `RelatedNews`.`created`, `RelatedNews`.`modified`, `RelatedNews`.`display_type`, `RelatedNews`.`rss`, `RelatedNews`.`source`, `RelatedNews`.`brg`, `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`news` AS `RelatedNews` JOIN `atd_cn`.`places_news` AS `PlacesNews` ON (`PlacesNews`.`place_id` = 681 AND `PlacesNews`.`news_id` = `RelatedNews`.`id`) WHERE `RelatedNews`.`status` = '1' AND `RelatedNews`.`publish_at` <= NOW() AND ((`RelatedNews`.`unpublish_at` > NOW()) OR (`RelatedNews`.`unpublish_at` = '0000-00-00') OR (`RelatedNews`.`unpublish_at` IS NULL)) AND ((NOT (`RelatedNews`.`category` IN ('event', 'closing', 'relocation'))) OR (((`RelatedNews`.`category` = 'event') AND (DATE_ADD(`RelatedNews`.`publish_at`, INTERVAL 3 MONTH) > NOW()))) OR (((`RelatedNews`.`category` IN ('closing', 'relocation')) AND (DATE_ADD(`RelatedNews`.`publish_at`, INTERVAL 12 MONTH) > NOW())))) | 0 | 0 | 1 | maybe slow |
| SELECT `RelatedPromotion`.`id`, `RelatedPromotion`.`num_view`, `RelatedPromotion`.`status`, `RelatedPromotion`.`publish_at`, `RelatedPromotion`.`unpublish_at`, `RelatedPromotion`.`type`, `RelatedPromotion`.`client_promotion`, `RelatedPromotion`.`category`, `RelatedPromotion`.`place_id`, `RelatedPromotion`.`title`, `RelatedPromotion`.`title_2`, `RelatedPromotion`.`deck`, `RelatedPromotion`.`deck_2`, `RelatedPromotion`.`content`, `RelatedPromotion`.`content_2`, `RelatedPromotion`.`tagging`, `RelatedPromotion`.`tagging_2`, `RelatedPromotion`.`start_date`, `RelatedPromotion`.`end_date`, `RelatedPromotion`.`stick_top_panel`, `RelatedPromotion`.`stick_top_panel_until`, `RelatedPromotion`.`stick_landing_top`, `RelatedPromotion`.`stick_landing_top_until`, `RelatedPromotion`.`seo_meta_keywords`, `RelatedPromotion`.`seo_meta_keywords_2`, `RelatedPromotion`.`seo_meta_description`, `RelatedPromotion`.`seo_meta_description_2`, `RelatedPromotion`.`slug`, `RelatedPromotion`.`created`, `RelatedPromotion`.`modified`, `RelatedPromotion`.`display_type`, `RelatedPromotion`.`rss`, `PlacesPromotion`.`id`, `PlacesPromotion`.`place_id`, `PlacesPromotion`.`promotion_id` FROM `atd_cn`.`promotions` AS `RelatedPromotion` JOIN `atd_cn`.`places_promotions` AS `PlacesPromotion` ON (`PlacesPromotion`.`place_id` = 681 AND `PlacesPromotion`.`promotion_id` = `RelatedPromotion`.`id`) WHERE `RelatedPromotion`.`status` = '1' AND `RelatedPromotion`.`publish_at` <= NOW() AND DATE_ADD(`RelatedPromotion`.`start_date`, INTERVAL 6 MONTH) > NOW() AND ((`RelatedPromotion`.`unpublish_at` > NOW()) OR (`RelatedPromotion`.`unpublish_at` = '0000-00-00') OR (`RelatedPromotion`.`unpublish_at` IS NULL)) AND ((`RelatedPromotion`.`end_date` >= NOW()) OR (`RelatedPromotion`.`end_date` = '0000-00-00') OR (`RelatedPromotion`.`end_date` IS NULL)) ORDER BY `RelatedPromotion`.`start_date` DESC LIMIT 5 | 0 | 0 | 1 | maybe slow |
| SELECT `Story`.`id`, `Story`.`num_view`, `Story`.`created`, `Story`.`modified`, `Story`.`status`, `Story`.`publish_at`, `Story`.`unpublish_at`, `Story`.`type`, `Story`.`advertorial`, `Story`.`top_list`, `Story`.`from_tatler`, `Story`.`title`, `Story`.`title_2`, `Story`.`deck`, `Story`.`deck_2`, `Story`.`author`, `Story`.`author_2`, `Story`.`content`, `Story`.`content_2`, `Story`.`video_link`, `Story`.`tagging`, `Story`.`tagging_2`, `Story`.`stick_to_top_panel`, `Story`.`stick_to_top_panel_until`, `Story`.`stick_to_landing_top`, `Story`.`stick_to_landing_top_until`, `Story`.`stick_to_top5_news_top`, `Story`.`seo_meta_keywords`, `Story`.`seo_meta_keywords_2`, `Story`.`seo_meta_description`, `Story`.`seo_meta_description_2`, `Story`.`slug`, `Story`.`blogger_id`, `Story`.`display_type`, `Story`.`rss`, `Story`.`source`, `Story`.`full_advertorial`, `Story`.`to_tatler_tv`, `Story`.`author_id`, `Story`.`brg`, `PlacesStory`.`id`, `PlacesStory`.`place_id`, `PlacesStory`.`story_id` FROM `atd_cn`.`stories` AS `Story` JOIN `atd_cn`.`places_stories` AS `PlacesStory` ON (`PlacesStory`.`place_id` = 681 AND `PlacesStory`.`story_id` = `Story`.`id`) WHERE `Story`.`status` = '1' AND `Story`.`publish_at` <= NOW() AND ((`Story`.`unpublish_at` > NOW()) OR (`Story`.`unpublish_at` = '0000-00-00') OR (`Story`.`unpublish_at` IS NULL)) AND ((`Story`.`type` <> 'wine_news') OR (((`Story`.`type` = 'wine_news') AND (DATE_ADD(`Story`.`publish_at`, INTERVAL 3 MONTH) > NOW())))) LIMIT 5 | 0 | 0 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `id` = 2 LIMIT 1 | 1 | 1 | 0 | |
| UPDATE `atd_cn`.`places` AS `Place` LEFT JOIN `atd_cn`.`reviews` AS `LatestReview` ON (`Place`.`latest_review_id` = `LatestReview`.`id`) LEFT JOIN `atd_cn`.`locations` AS `Location` ON (`Place`.`location_id` = `Location`.`id`) SET `Place`.`num_view` = Place.num_view + 1 WHERE `Place`.`id` = 681 | 1 | 1 | 2 | maybe slow |
| SELECT `Review`.`id`, `Review`.`place_id`, `Review`.`year`, `Review`.`created`, `Review`.`modified`, `Review`.`status`, `Review`.`publish_at`, `Review`.`unpublish_at`, `Review`.`review_setting`, `Review`.`review_setting_2`, `Review`.`review_setting_rating`, `Review`.`review_food`, `Review`.`review_food_2`, `Review`.`review_food_rating`, `Review`.`review_wine`, `Review`.`review_wine_2`, `Review`.`review_wine_rating`, `Review`.`review_service`, `Review`.`review_service_2`, `Review`.`review_service_rating`, `Review`.`review_price`, `Review`.`review_price_2`, `Review`.`review_price_rating`, `Review`.`review_why_go`, `Review`.`review_what_to_order`, `Review`.`review_general`, `Review`.`review_general_2`, `Review`.`tagging`, `Review`.`stick_to_top_panel`, `Review`.`stick_to_top_panel_until`, `Review`.`stick_to_landing_top`, `Review`.`stick_to_landing_top_until`, `Review`.`stick_to_right_column`, `Review`.`stick_to_right_column_until`, `Review`.`seo_meta_keywords`, `Review`.`seo_meta_description`, `Review`.`slug`, `Review`.`old_id`, `Review`.`author`, `Review`.`author_2`, `Place`.`id`, `Place`.`review_count`, `Place`.`latest_review_id`, `Place`.`latest_review_year`, `Place`.`location_id`, `Place`.`name`, `Place`.`name_2`, `Place`.`num_view`, `Place`.`address`, `Place`.`address_2`, `Place`.`type`, `Place`.`telephone`, `Place`.`telephone_2`, `Place`.`geo_lat`, `Place`.`geo_lng`, `Place`.`geo_zoom`, `Place`.`created`, `Place`.`modified`, `Place`.`status`, `Place`.`publish_at`, `Place`.`unpublish_at`, `Place`.`close_at`, `Place`.`paid_period_start_at`, `Place`.`paid_period_end_at`, `Place`.`brg`, `Place`.`group`, `Place`.`group_2`, `Place`.`branch`, `Place`.`branch_2`, `Place`.`deck`, `Place`.`deck_2`, `Place`.`author`, `Place`.`author_2`, `Place`.`cuisine`, `Place`.`cuisine_2`, `Place`.`sub_cusine`, `Place`.`sub_cusine_2`, `Place`.`overview_website`, `Place`.`reservation`, `Place`.`reservation_tel`, `Place`.`overview_email`, `Place`.`year_established`, `Place`.`opening_hours`, `Place`.`opening_hours_2`, `Place`.`lunch_hours`, `Place`.`lunch_hours_2`, `Place`.`dinner_hours`, `Place`.`dinner_hours_2`, `Place`.`happy_hours`, `Place`.`happy_hours_2`, `Place`.`music_hours`, `Place`.`food_hours`, `Place`.`food`, `Place`.`food_2`, `Place`.`type_of_music`, `Place`.`type_of_music_2`, `Place`.`dress_code`, `Place`.`dress_code_2`, `Place`.`buffet`, `Place`.`buffet_description`, `Place`.`buffet_description_2`, `Place`.`vegetarian_dish`, `Place`.`vegetarian_dish_2`, `Place`.`own_wine`, `Place`.`corkage_charge`, `Place`.`corkage_charge_2`, `Place`.`private_room`, `Place`.`private_room_description`, `Place`.`private_room_description_2`, `Place`.`car_valet`, `Place`.`smoking_area`, `Place`.`smoking_area_2`, `Place`.`accept_credit_card`, `Place`.`amex_accept`, `Place`.`amex_selects_until`, `Place`.`amex_selects_content`, `Place`.`amex_1_for_1_until`, `Place`.`amex_1_for_1_content`, `Place`.`amex_top_10`, `Place`.`seo_meta_keywords`, `Place`.`seo_meta_keywords_2`, `Place`.`seo_meta_description`, `Place`.`seo_meta_description_2`, `Place`.`slug`, `Place`.`reserve_table`, `Place`.`alcoholic_beverage`, `Place`.`no_of_seats`, `Place`.`delivery`, `Place`.`payment`, `Place`.`display_type`, `Place`.`rss`, `Place`.`restaurant_type`, `Place`.`awards` FROM `atd_cn`.`reviews` AS `Review` LEFT JOIN `atd_cn`.`places` AS `Place` ON (`Review`.`place_id` = `Place`.`id`) WHERE ((`Place`.`latest_review_id` = `Review`.`id`) AND (((`Place`.`close_at` IS NULL) OR (`Place`.`close_at` > NOW()))) AND (NOT (`Place`.`id` IS NULL)) AND (`Place`.`status` = '1') AND (`Place`.`type` = 'restaurant') AND (`Review`.`publish_at` <= NOW()) AND (((`Place`.`paid_period_start_at` <= NOW()) AND (`Place`.`paid_period_end_at` >= NOW())))) GROUP BY `Review`.`place_id` ORDER BY rand() ASC LIMIT 3 | 0 | 0 | 5 | maybe slow |
| SELECT * , ( 6371 * ACOS( COS( RADIANS( 39.935886 ) ) * COS( RADIANS( geo_lat ) ) * COS( RADIANS( geo_lng ) - RADIANS( 116.455419 ) ) + SIN( RADIANS( 39.935886 ) ) * SIN( RADIANS( geo_lat ) ) ) ) AS distance FROM `places` WHERE `status` = 1 AND (`close_at` >= NOW() OR `close_at` IS NULL) AND `paid_period_end_at` >= NOW() AND `type` = "restaurant" AND `id` != 681 HAVING distance < 20 ORDER BY rand() LIMIT 0 , 3 | 0 | 0 | 4 | maybe slow |
| SELECT `Review`.`id`, `Review`.`place_id`, `Review`.`year`, `Review`.`created`, `Review`.`modified`, `Review`.`status`, `Review`.`publish_at`, `Review`.`unpublish_at`, `Review`.`review_setting`, `Review`.`review_setting_2`, `Review`.`review_setting_rating`, `Review`.`review_food`, `Review`.`review_food_2`, `Review`.`review_food_rating`, `Review`.`review_wine`, `Review`.`review_wine_2`, `Review`.`review_wine_rating`, `Review`.`review_service`, `Review`.`review_service_2`, `Review`.`review_service_rating`, `Review`.`review_price`, `Review`.`review_price_2`, `Review`.`review_price_rating`, `Review`.`review_why_go`, `Review`.`review_what_to_order`, `Review`.`review_general`, `Review`.`review_general_2`, `Review`.`tagging`, `Review`.`stick_to_top_panel`, `Review`.`stick_to_top_panel_until`, `Review`.`stick_to_landing_top`, `Review`.`stick_to_landing_top_until`, `Review`.`stick_to_right_column`, `Review`.`stick_to_right_column_until`, `Review`.`seo_meta_keywords`, `Review`.`seo_meta_description`, `Review`.`slug`, `Review`.`old_id`, `Review`.`author`, `Review`.`author_2`, `Place`.`id`, `Place`.`review_count`, `Place`.`latest_review_id`, `Place`.`latest_review_year`, `Place`.`location_id`, `Place`.`name`, `Place`.`name_2`, `Place`.`num_view`, `Place`.`address`, `Place`.`address_2`, `Place`.`type`, `Place`.`telephone`, `Place`.`telephone_2`, `Place`.`geo_lat`, `Place`.`geo_lng`, `Place`.`geo_zoom`, `Place`.`created`, `Place`.`modified`, `Place`.`status`, `Place`.`publish_at`, `Place`.`unpublish_at`, `Place`.`close_at`, `Place`.`paid_period_start_at`, `Place`.`paid_period_end_at`, `Place`.`brg`, `Place`.`group`, `Place`.`group_2`, `Place`.`branch`, `Place`.`branch_2`, `Place`.`deck`, `Place`.`deck_2`, `Place`.`author`, `Place`.`author_2`, `Place`.`cuisine`, `Place`.`cuisine_2`, `Place`.`sub_cusine`, `Place`.`sub_cusine_2`, `Place`.`overview_website`, `Place`.`reservation`, `Place`.`reservation_tel`, `Place`.`overview_email`, `Place`.`year_established`, `Place`.`opening_hours`, `Place`.`opening_hours_2`, `Place`.`lunch_hours`, `Place`.`lunch_hours_2`, `Place`.`dinner_hours`, `Place`.`dinner_hours_2`, `Place`.`happy_hours`, `Place`.`happy_hours_2`, `Place`.`music_hours`, `Place`.`food_hours`, `Place`.`food`, `Place`.`food_2`, `Place`.`type_of_music`, `Place`.`type_of_music_2`, `Place`.`dress_code`, `Place`.`dress_code_2`, `Place`.`buffet`, `Place`.`buffet_description`, `Place`.`buffet_description_2`, `Place`.`vegetarian_dish`, `Place`.`vegetarian_dish_2`, `Place`.`own_wine`, `Place`.`corkage_charge`, `Place`.`corkage_charge_2`, `Place`.`private_room`, `Place`.`private_room_description`, `Place`.`private_room_description_2`, `Place`.`car_valet`, `Place`.`smoking_area`, `Place`.`smoking_area_2`, `Place`.`accept_credit_card`, `Place`.`amex_accept`, `Place`.`amex_selects_until`, `Place`.`amex_selects_content`, `Place`.`amex_1_for_1_until`, `Place`.`amex_1_for_1_content`, `Place`.`amex_top_10`, `Place`.`seo_meta_keywords`, `Place`.`seo_meta_keywords_2`, `Place`.`seo_meta_description`, `Place`.`seo_meta_description_2`, `Place`.`slug`, `Place`.`reserve_table`, `Place`.`alcoholic_beverage`, `Place`.`no_of_seats`, `Place`.`delivery`, `Place`.`payment`, `Place`.`display_type`, `Place`.`rss`, `Place`.`restaurant_type`, `Place`.`awards` FROM `atd_cn`.`reviews` AS `Review` LEFT JOIN `atd_cn`.`places` AS `Place` ON (`Review`.`place_id` = `Place`.`id`) WHERE ((`Place`.`latest_review_id` = `Review`.`id`) AND (((`Place`.`close_at` IS NULL) OR (`Place`.`close_at` > NOW()))) AND (NOT (`Place`.`id` = 681)) AND (`Place`.`status` = '1') AND (`Place`.`type` = 'restaurant') AND (`Review`.`publish_at` <= NOW()) AND (`Place`.`cuisine` = '西餐') AND (((`Place`.`paid_period_start_at` <= NOW()) AND (`Place`.`paid_period_end_at` >= NOW())))) GROUP BY `Review`.`place_id` ORDER BY rand() ASC | 0 | 0 | 5 | maybe slow |
| SELECT `Review`.`id`, `Review`.`place_id`, `Review`.`year`, `Review`.`created`, `Review`.`modified`, `Review`.`status`, `Review`.`publish_at`, `Review`.`unpublish_at`, `Review`.`review_setting`, `Review`.`review_setting_2`, `Review`.`review_setting_rating`, `Review`.`review_food`, `Review`.`review_food_2`, `Review`.`review_food_rating`, `Review`.`review_wine`, `Review`.`review_wine_2`, `Review`.`review_wine_rating`, `Review`.`review_service`, `Review`.`review_service_2`, `Review`.`review_service_rating`, `Review`.`review_price`, `Review`.`review_price_2`, `Review`.`review_price_rating`, `Review`.`review_why_go`, `Review`.`review_what_to_order`, `Review`.`review_general`, `Review`.`review_general_2`, `Review`.`tagging`, `Review`.`stick_to_top_panel`, `Review`.`stick_to_top_panel_until`, `Review`.`stick_to_landing_top`, `Review`.`stick_to_landing_top_until`, `Review`.`stick_to_right_column`, `Review`.`stick_to_right_column_until`, `Review`.`seo_meta_keywords`, `Review`.`seo_meta_description`, `Review`.`slug`, `Review`.`old_id`, `Review`.`author`, `Review`.`author_2`, `Place`.`id`, `Place`.`review_count`, `Place`.`latest_review_id`, `Place`.`latest_review_year`, `Place`.`location_id`, `Place`.`name`, `Place`.`name_2`, `Place`.`num_view`, `Place`.`address`, `Place`.`address_2`, `Place`.`type`, `Place`.`telephone`, `Place`.`telephone_2`, `Place`.`geo_lat`, `Place`.`geo_lng`, `Place`.`geo_zoom`, `Place`.`created`, `Place`.`modified`, `Place`.`status`, `Place`.`publish_at`, `Place`.`unpublish_at`, `Place`.`close_at`, `Place`.`paid_period_start_at`, `Place`.`paid_period_end_at`, `Place`.`brg`, `Place`.`group`, `Place`.`group_2`, `Place`.`branch`, `Place`.`branch_2`, `Place`.`deck`, `Place`.`deck_2`, `Place`.`author`, `Place`.`author_2`, `Place`.`cuisine`, `Place`.`cuisine_2`, `Place`.`sub_cusine`, `Place`.`sub_cusine_2`, `Place`.`overview_website`, `Place`.`reservation`, `Place`.`reservation_tel`, `Place`.`overview_email`, `Place`.`year_established`, `Place`.`opening_hours`, `Place`.`opening_hours_2`, `Place`.`lunch_hours`, `Place`.`lunch_hours_2`, `Place`.`dinner_hours`, `Place`.`dinner_hours_2`, `Place`.`happy_hours`, `Place`.`happy_hours_2`, `Place`.`music_hours`, `Place`.`food_hours`, `Place`.`food`, `Place`.`food_2`, `Place`.`type_of_music`, `Place`.`type_of_music_2`, `Place`.`dress_code`, `Place`.`dress_code_2`, `Place`.`buffet`, `Place`.`buffet_description`, `Place`.`buffet_description_2`, `Place`.`vegetarian_dish`, `Place`.`vegetarian_dish_2`, `Place`.`own_wine`, `Place`.`corkage_charge`, `Place`.`corkage_charge_2`, `Place`.`private_room`, `Place`.`private_room_description`, `Place`.`private_room_description_2`, `Place`.`car_valet`, `Place`.`smoking_area`, `Place`.`smoking_area_2`, `Place`.`accept_credit_card`, `Place`.`amex_accept`, `Place`.`amex_selects_until`, `Place`.`amex_selects_content`, `Place`.`amex_1_for_1_until`, `Place`.`amex_1_for_1_content`, `Place`.`amex_top_10`, `Place`.`seo_meta_keywords`, `Place`.`seo_meta_keywords_2`, `Place`.`seo_meta_description`, `Place`.`seo_meta_description_2`, `Place`.`slug`, `Place`.`reserve_table`, `Place`.`alcoholic_beverage`, `Place`.`no_of_seats`, `Place`.`delivery`, `Place`.`payment`, `Place`.`display_type`, `Place`.`rss`, `Place`.`restaurant_type`, `Place`.`awards` FROM `atd_cn`.`reviews` AS `Review` LEFT JOIN `atd_cn`.`places` AS `Place` ON (`Review`.`place_id` = `Place`.`id`) WHERE ((`Place`.`latest_review_id` = `Review`.`id`) AND (((`Place`.`close_at` IS NULL) OR (`Place`.`close_at` > NOW()))) AND (NOT (`Place`.`id` = (681))) AND (`Place`.`status` = '1') AND (`Place`.`type` = 'restaurant') AND (`Review`.`publish_at` <= NOW()) AND (`Place`.`cuisine` = '西餐')) GROUP BY `Review`.`place_id` ORDER BY rand() ASC | 25 | 25 | 5 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `Image`.`filesize`, `Image`.`type`, `Image`.`caption`, `Image`.`object_type`, `Image`.`object_id`, `Image`.`source`, `Image`.`image1_url`, `Image`.`image2_url`, `Image`.`image3_url`, `Image`.`image4_url`, `Image`.`image5_url`, `Image`.`square_url`, `Image`.`square300_url`, `Image`.`thumb_url`, `Image`.`banner_url`, `Image`.`carousel_url`, `Image`.`carousel_large_url`, `Image`.`original_url`, `Image`.`created`, `Image`.`is_cover`, `Image`.`carousel_fw_url`, `Image`.`mobile_cover`, `Image`.`sort` FROM `atd_cn`.`images` AS `Image` WHERE `Image`.`object_type` = 'review' AND `Image`.`object_id` IN (778, 851, 795, 847, 936, 521, 809, 825, 495, 492, 820, 914, 496, 881, 494, 801, 561, 534, 549, 933, 931, 474, 526, 822, 688) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 82 | 82 | 4 | |
| SELECT `Video`.`id`, `Video`.`source`, `Video`.`name`, `Video`.`object_type`, `Video`.`object_id`, `Video`.`title`, `Video`.`url`, `Video`.`usage`, `Video`.`ext`, `Video`.`type`, `Video`.`width`, `Video`.`height`, `Video`.`created`, `Video`.`filesize`, `Video`.`youtube` FROM `atd_cn`.`videos` AS `Video` WHERE `Video`.`object_type` = 'review' AND `Video`.`object_id` IN (778, 851, 795, 847, 936, 521, 809, 825, 495, 492, 820, 914, 496, 881, 494, 801, 561, 534, 549, 933, 931, 474, 526, 822, 688) | 0 | 0 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 4 | maybe slow |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 3 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
