徜徉于平拱及卷拱之窗,矩形和半圆形之阳台,还有草木葱茏,四季花香之广阔花园。更妙的是此地所供之馔,乃中西合璧之怀旧佳肴。
上海熏鱼,冷菜热吃,老派上海菜,用青鱼制成,甜咸适度。脆皮咸鸡其实只有鸡皮,里面则是海蜇头,两种脆不一样。莴苣寡味,沃以(花)椒油,不麻却香。鸡汁百页包太细长,鸡味已入百页中。百页包外有海带圈,养眼。汤是松茸炖野生竹荪,是菌炖菌,菌味够浓,非常清口。主菜辣酱明虾伴雪茄馒头其实就是干烧明虾,雪茄形的馒头很好玩,而且可以蘸汁吃。酸胶赛螃蟹烤鳕鱼是烤鳕鱼配蟹粉蛋,味道比较和谐。手撕豆腐是盐卤点的自制老豆腐,用以烩虾干、火腿,非常原味。火丁豌豆,也有人称之为“火末甜豆”。以前我也剥过甜豆,5斤豆剥半天,却只有一小碗,当然比豌豆要嫩而可爱。加之火末提味,小女生最爱。主食黄鱼馄饨,黄鱼肉为馅,汤中有雪菜。甜品豆浆油条可不是“四大金刚”压缩版,而是做成冰淇淋的豆腐伴着老油条,有创意。
人均RMB 800
No post data.
No querystring data.
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` = '福1015' AND `Place`.`status` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `atd_cn`.`places` AS `Place` WHERE `Place`.`id` = 217 | 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` = 217 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` = 220 | 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 | 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` = (217) 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` = (220) 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` = (217) | 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` = (217) | 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` = 217 AND `PlaceRelationship`.`related_place_id` = `RelatedPlace`.`id`) LIMIT 10 | 3 | 3 | 6 | 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` = 217 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` = 217 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` = 217 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` = 217 | 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 | 4 | maybe slow |
SELECT * , ( 6371 * ACOS( COS( RADIANS( 31.21871 ) ) * COS( RADIANS( geo_lat ) ) * COS( RADIANS( geo_lng ) - RADIANS( 121.43009400000005 ) ) + SIN( RADIANS( 31.21871 ) ) * 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` != 217 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` = 217)) 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 | 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` = (217))) 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 | 100 | 100 | 9 | 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 (327, 535, 676, 483, 375, 542, 315, 272, 300, 211, 245, 453, 304, 228, 374, 338, 332, 218, 262, 363, 463, 267, 380, 204, 161, 398, 334, 387, 205, 522, 316, 386, 455, 212, 241, 306, 287, 364, 325, 539, 251, 231, 281, 293, 221, 216, 461, 554, 381, 344, 362, 271, 371, 368, 470, 229, 340, 405, 234, 683, 555, 280, 469, 240, 275, 203, 531, 311, 384, 170, 388, 318, 227, 457, 213, 289, 538, 559, 454, 536, 274, 525, 533, 345, 339, 376, 223, 529, 528, 328, 632, 385, 168, 276, 254, 553, 377, 472, 745, 452) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 259 | 259 | 5 | |
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 (327, 535, 676, 483, 375, 542, 315, 272, 300, 211, 245, 453, 304, 228, 374, 338, 332, 218, 262, 363, 463, 267, 380, 204, 161, 398, 334, 387, 205, 522, 316, 386, 455, 212, 241, 306, 287, 364, 325, 539, 251, 231, 281, 293, 221, 216, 461, 554, 381, 344, 362, 271, 371, 368, 470, 229, 340, 405, 234, 683, 555, 280, 469, 240, 275, 203, 531, 311, 384, 170, 388, 318, 227, 457, 213, 289, 538, 559, 454, 536, 274, 525, 533, 345, 339, 376, 223, 529, 528, 328, 632, 385, 168, 276, 254, 553, 377, 472, 745, 452) | 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` = 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` = 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` = 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` = 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` = 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 | |
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` = 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` = 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` = 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 | 2 | 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` = 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` = 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` = 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` = 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 | |
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` = 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` = 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` = 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` = 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` = 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` = 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 | |
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 | |
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 | |
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 |
Peak Memory Use 18.82 MB
Message | Memory use |
---|---|
Component initialization | 2.36 MB |
Controller action start | 2.66 MB |
Controller render start | 8.57 MB |
View render complete | 9.75 MB |
Total Request Time: 494 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 59.35 | |
Event: Controller.initialize | 25.10 | |
Event: Controller.startup | 1.05 | |
Controller action | 273.48 | |
Event: Controller.beforeRender | 25.84 | |
» Processing toolbar data | 25.69 | |
Rendering View | 29.74 | |
» Rendering APP/View/Themed/Tatler/Restaurants/view.ctp | 21.90 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_content_details_places.ctp | 21.43 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_breadcrumb.ctp | 0.19 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp | 0.10 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_content_places_detail.ctp | 2.08 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #2 | 0.10 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #3 | 0.08 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #4 | 0.08 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_aside_places_archives.ctp | 0.07 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #5 | 0.08 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #6 | 0.07 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_content_places_detail_nearby.ctp | 18.10 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp | 0.12 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_breadcrumb.ctp #2 | 0.15 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_sticky_social_footer.ctp | 0.10 | |
» Rendering APP/View/Themed/Tatler/Layouts/site_new.ctp | 7.23 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_meta.ctp | 0.20 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_fbmeta.ctp | 0.11 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_stylesheets.ctp | 0.33 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_javascripts.ctp | 0.62 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_facebook.ctp | 0.11 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_twitter.ctp | 0.08 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_javascript_after.ctp | 0.39 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_google.ctp | 0.11 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #7 | 0.08 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #8 | 0.08 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #9 | 0.09 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_header.ctp | 2.56 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_header_holder.ctp | 0.57 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_tatler_countries.ctp | 0.12 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_social_icons.ctp | 0.09 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_sticky_menu.ctp | 1.19 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_search_box_header.ctp | 0.21 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_page_heading.ctp | 0.10 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_sub_menu.ctp | 0.31 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_main.ctp | 0.11 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_footer.ctp | 0.81 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_social_icons.ctp #2 | 0.10 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_tatler_countries.ctp #2 | 0.12 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_openx.ctp | 0.10 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #10 | 0.08 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp #2 | 0.12 |
Constant | Value |
---|---|
APP | /var/www/html/tatler-cn-dining-3-2/app/ |
APP_DIR | app |
APPLIBS | /var/www/html/tatler-cn-dining-3-2/app/Lib/ |
CACHE | /var/www/html/tatler-cn-dining-3-2/app/tmp/cache/ |
CAKE | /var/www/html/tatler-cn-dining-3-2/lib/Cake/ |
CAKE_CORE_INCLUDE_PATH | /var/www/html/tatler-cn-dining-3-2/lib |
CORE_PATH | /var/www/html/tatler-cn-dining-3-2/lib/ |
CAKE_VERSION | 2.1.0 |
CSS | /var/www/html/tatler-cn-dining-3-2/app/webroot/css/ |
CSS_URL | css/ |
DS | / |
FULL_BASE_URL | http://ads.shangliutatler.com:8080 |
IMAGES | /var/www/html/tatler-cn-dining-3-2/app/webroot/img/ |
IMAGES_URL | img/ |
JS | /var/www/html/tatler-cn-dining-3-2/app/webroot/js/ |
JS_URL | js/ |
LOGS | /var/www/html/tatler-cn-dining-3-2/app/tmp/logs/ |
ROOT | /var/www/html/tatler-cn-dining-3-2 |
TESTS | /var/www/html/tatler-cn-dining-3-2/app/Test/ |
TMP | /var/www/html/tatler-cn-dining-3-2/app/tmp/ |
VENDORS | /var/www/html/tatler-cn-dining-3-2/vendors/ |
WEBROOT_DIR | webroot |
WWW_ROOT | /var/www/html/tatler-cn-dining-3-2/app/webroot/ |
Environment Variable | Value |
---|---|
Php Version | 5.5.9-1ubuntu4.14 |
Redirect Redirect Cake Site | asiatatlerdining |
Redirect Redirect Cake Region | CN |
Redirect Redirect Cake Lang | zh-CN |
Redirect Redirect Cake Env | debug |
Redirect Redirect Status | 200 |
Redirect Cake Site | asiatatlerdining |
Redirect Cake Region | CN |
Redirect Cake Lang | zh-CN |
Redirect Cake Env | debug |
Redirect Status | 200 |
Cake Site | asiatatlerdining |
Cake Region | CN |
Cake Lang | zh-CN |
Cake Env | debug |
Http Accept | */* |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Accept Encoding | gzip, br, zstd, deflate |
Http Host | ads.shangliutatler.com:8080 |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
Server Signature | Apache/2.4.7 (Ubuntu) Server at ads.shangliutatler.com Port 8080 |
Server Software | Apache/2.4.7 (Ubuntu) |
Server Name | ads.shangliutatler.com |
Server Addr | 10.46.22.148 |
Server Port | 8080 |
Remote Addr | 3.148.185.226 |
Document Root | /var/www/html/tatler-cn-dining-3-2 |
Request Scheme | http |
Context Prefix | |
Context Document Root | /var/www/html/tatler-cn-dining-3-2 |
Server Admin | [no address given] |
Script Filename | /var/www/html/tatler-cn-dining-3-2/app/webroot/index.php |
Remote Port | 30615 |
Redirect Query String | /restaurants/福1015 |
Redirect Url | /app/webroot/restaurants/福1015 |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | /restaurants/福1015 |
Request Uri | /restaurants/%E7%A6%8F1015 |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1745467371.5 |
Request Time | 1745467371 |