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 | 15 | 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 | 41 | 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 | 36 | 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 | 37 | 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 | 19 | 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 | 26 | 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 | 14 | 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 | 25 | 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 | 11 | 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 | 25 | 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 | 24 | 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 | 12 | 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 | 4 | 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 | 21 | 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 | 10 | 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 | 13 | 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 | 15 | 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 | 13 | 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 | 47 | 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 | 21 | maybe slow |