Be part of the in-crowd and receive exclusive party invitations and fabulous offers.
SIGN UP WITH TATLER© 2025 Tatler Asia Limited. All rights reserved.
沪ICP备10210439号-2
Be part of the in-crowd and
receive exclusive party invitations and fabulous offers.
Sign up with Tatler
Thank you
for your subscription!
Be part of the in-crowd and receive exclusive party invitations and fabulous offers.
Sign up with Tatler
Thank you
for your subscription!
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
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`.`status` = '1' AND `Review`.`status` = '1' AND ((`Place`.`unpublish_at` >= NOW()) OR (`Place`.`unpublish_at` IS NULL)) AND `Review`.`publish_at` BETWEEN NOW() - INTERVAL 2 YEAR AND NOW() AND `Review`.`publish_at` <= NOW() AND NOT (`Review`.`id` IS NULL) AND `Place`.`type` IN ('restaurant', 'bars', 'cafes') ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 3 | 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` FROM `atd_cn`.`stories` AS `Story` WHERE `Story`.`status` = '1' AND ((`Story`.`unpublish_at` >= NOW()) OR (`Story`.`unpublish_at` IS NULL)) AND `Story`.`publish_at` <= NOW() AND `Story`.`stick_to_top_panel` = '1' AND (`Story`.`stick_to_top_panel_until` IS NOT NULL AND `Story`.`stick_to_top_panel_until` > NOW()) ORDER BY `Story`.`publish_at` DESC LIMIT 3 | 0 | 0 | 1 | maybe slow |
SELECT `News`.`id`, `News`.`num_view`, `News`.`status`, `News`.`author`, `News`.`publish_at`, `News`.`unpublish_at`, `News`.`type`, `News`.`category`, `News`.`place_id`, `News`.`title`, `News`.`title_2`, `News`.`deck`, `News`.`deck_2`, `News`.`content`, `News`.`content_2`, `News`.`tagging`, `News`.`tagging_2`, `News`.`stick_top_panel`, `News`.`stick_top_panel_until`, `News`.`stick_landing_top`, `News`.`stick_landing_top_until`, `News`.`seo_meta_keywords`, `News`.`seo_meta_keywords_2`, `News`.`seo_meta_description`, `News`.`seo_meta_description_2`, `News`.`slug`, `News`.`created`, `News`.`modified`, `News`.`display_type`, `News`.`rss`, `News`.`source`, `News`.`brg` FROM `atd_cn`.`news` AS `News` WHERE `News`.`status` = '1' AND ((`News`.`unpublish_at` >= NOW()) OR (`News`.`unpublish_at` IS NULL)) AND `News`.`publish_at` <= NOW() AND `News`.`stick_top_panel` = '1' AND (`News`.`stick_top_panel_until` IS NOT NULL AND `News`.`stick_top_panel_until` > NOW()) ORDER BY `News`.`publish_at` DESC LIMIT 3 | 0 | 0 | 1 | maybe slow |
SELECT `Promotion`.`id`, `Promotion`.`num_view`, `Promotion`.`status`, `Promotion`.`publish_at`, `Promotion`.`unpublish_at`, `Promotion`.`type`, `Promotion`.`client_promotion`, `Promotion`.`category`, `Promotion`.`place_id`, `Promotion`.`title`, `Promotion`.`title_2`, `Promotion`.`deck`, `Promotion`.`deck_2`, `Promotion`.`content`, `Promotion`.`content_2`, `Promotion`.`tagging`, `Promotion`.`tagging_2`, `Promotion`.`start_date`, `Promotion`.`end_date`, `Promotion`.`stick_top_panel`, `Promotion`.`stick_top_panel_until`, `Promotion`.`stick_landing_top`, `Promotion`.`stick_landing_top_until`, `Promotion`.`seo_meta_keywords`, `Promotion`.`seo_meta_keywords_2`, `Promotion`.`seo_meta_description`, `Promotion`.`seo_meta_description_2`, `Promotion`.`slug`, `Promotion`.`created`, `Promotion`.`modified`, `Promotion`.`display_type`, `Promotion`.`rss` FROM `atd_cn`.`promotions` AS `Promotion` WHERE `Promotion`.`status` = '1' AND ((`Promotion`.`unpublish_at` >= NOW()) OR (`Promotion`.`unpublish_at` IS NULL)) AND `Promotion`.`publish_at` <= NOW() AND `Promotion`.`stick_top_panel` = '1' AND (`Promotion`.`stick_top_panel_until` IS NOT NULL AND `Promotion`.`stick_top_panel_until` > NOW()) AND `Promotion`.`end_date` >= NOW() ORDER BY `Promotion`.`publish_at` DESC LIMIT 3 | 0 | 0 | 1 | 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 `Review`.`status` = '1' AND ((`Place`.`close_at` >= NOW()) OR (`Place`.`close_at` IS NULL)) AND `Place`.`status` = '1' AND `Review`.`publish_at` <= NOW() AND `Review`.`stick_to_top_panel` = '1' AND (`Review`.`stick_to_top_panel_until` IS NOT NULL AND `Review`.`stick_to_top_panel_until` > NOW()) ORDER BY `Review`.`publish_at` DESC LIMIT 3 | 0 | 0 | 1 | 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 `object_id` = 304 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 302 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 301 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 300 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 298 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 297 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 296 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 295 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 294 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 293 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 292 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | 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 `object_id` = 291 AND `object_type` = 'story' ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Promotion`.`id`, `Promotion`.`num_view`, `Promotion`.`status`, `Promotion`.`publish_at`, `Promotion`.`unpublish_at`, `Promotion`.`type`, `Promotion`.`client_promotion`, `Promotion`.`category`, `Promotion`.`place_id`, `Promotion`.`title`, `Promotion`.`title_2`, `Promotion`.`deck`, `Promotion`.`deck_2`, `Promotion`.`content`, `Promotion`.`content_2`, `Promotion`.`tagging`, `Promotion`.`tagging_2`, `Promotion`.`start_date`, `Promotion`.`end_date`, `Promotion`.`stick_top_panel`, `Promotion`.`stick_top_panel_until`, `Promotion`.`stick_landing_top`, `Promotion`.`stick_landing_top_until`, `Promotion`.`seo_meta_keywords`, `Promotion`.`seo_meta_keywords_2`, `Promotion`.`seo_meta_description`, `Promotion`.`seo_meta_description_2`, `Promotion`.`slug`, `Promotion`.`created`, `Promotion`.`modified`, `Promotion`.`display_type`, `Promotion`.`rss` FROM `atd_cn`.`promotions` AS `Promotion` WHERE `Promotion`.`status` = '1' AND ((`Promotion`.`unpublish_at` >= NOW()) OR (`Promotion`.`unpublish_at` IS NULL)) AND `Promotion`.`publish_at` <= NOW() AND `Promotion`.`end_date` >= NOW() ORDER BY `Promotion`.`publish_at` DESC LIMIT 12 | 0 | 0 | 1 | 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`.`status` = '1' AND `Review`.`status` = '1' AND `Place`.`close_at` >= NOW() ORDER BY rand() ASC LIMIT 3 | 0 | 0 | 7 | 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 `Review`.`status` = '1' AND ((`Place`.`close_at` >= NOW()) OR (`Place`.`close_at` IS NULL)) AND `Place`.`status` = '1' AND `Review`.`publish_at` <= NOW() AND ((`Place`.`paid_period_end_at` >= NOW()) AND (`Place`.`paid_period_end_at` IS NOT NULL)) ORDER BY rand() ASC LIMIT 3 | 0 | 0 | 7 | maybe slow |
Peak Memory Use 86.34 MB
Message | Memory use |
---|---|
Component initialization | 1.58 MB |
Controller action start | 1.88 MB |
Controller render start | 4.01 MB |
View render complete | 4.97 MB |
Total Request Time: 1074 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.90 | |
Event: Controller.initialize | 19.23 | |
Event: Controller.startup | 1.32 | |
Controller action | 182.48 | |
Event: Controller.beforeRender | 461.61 | |
» Processing toolbar data | 461.45 | |
Rendering View | 11.87 | |
» Rendering APP/View/Themed/Tatler/Pages/index.ctp | 4.15 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_content_home.ctp | 3.85 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_main_slick_slider.ctp | 0.49 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp | 0.11 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_content_home_landing.ctp | 1.25 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #2 | 0.08 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_aside_search_box.ctp | 0.10 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_content_home_reviews.ctp | 0.11 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp | 0.09 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #3 | 0.06 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_content_home_news.ctp | 0.37 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp #2 | 0.07 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_breadcrumb.ctp | 0.13 | |
» Rendering APP/View/Themed/Tatler/Layouts/site_new.ctp | 7.05 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_meta.ctp | 0.19 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_fbmeta.ctp | 0.10 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_stylesheets.ctp | 0.35 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_javascripts.ctp | 0.60 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_facebook.ctp | 0.09 | |
» » » 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.10 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #4 | 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.06 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_header.ctp | 2.75 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_header_holder.ctp | 0.51 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_tatler_countries.ctp | 0.10 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_social_icons.ctp | 0.08 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_sticky_menu.ctp | 1.41 | |
» » » » Rendering APP/View/Themed/Tatler/Elements/site_search_box_header.ctp | 0.20 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_page_heading.ctp | 0.10 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_sub_menu.ctp | 0.35 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_main.ctp | 0.09 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_footer.ctp | 0.77 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_social_icons.ctp #2 | 0.08 | |
» » » Rendering APP/View/Themed/Tatler/Elements/site_tatler_countries.ctp #2 | 0.11 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_javascripts_openx.ctp | 0.09 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_ads_2.ctp #7 | 0.07 | |
» » Rendering APP/View/Themed/Tatler/Elements/site_subscribe_letter.ctp #3 | 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://dining.shangliutatler.com:8081 |
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 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 Host | dining.shangliutatler.com:8081 |
Http Pragma | no-cache |
Http Upgrade Insecure Requests | 1 |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 |
Http Accept Encoding | gzip, deflate |
Http Via | 1.1 squid-proxy-5b5d847c96-ktb98 (squid/6.10) |
Http X Forwarded For | 10.3.13.125 |
Http Cache Control | no-cache |
Http Connection | keep-alive |
Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
Server Signature | Apache/2.4.7 (Ubuntu) Server at dining.shangliutatler.com Port 8081 |
Server Software | Apache/2.4.7 (Ubuntu) |
Server Name | dining.shangliutatler.com |
Server Addr | 10.46.22.148 |
Server Port | 8081 |
Remote Addr | 216.73.216.7 |
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 | 23279 |
Redirect Url | /index.php |
Gateway Interface | CGI/1.1 |
Server Protocol | HTTP/1.1 |
Request Method | GET |
Query String | |
Request Uri | / |
Script Name | /app/webroot/index.php |
Php Self | /app/webroot/index.php |
Request Time Float | 1752163901.154 |
Request Time | 1752163901 |