Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`.`slug` = 'le-pain-de-palmier-202112' AND `News`.`status` = '1' LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `atd_cn`.`news` AS `News` WHERE `News`.`id` = 423 | 1 | 1 | 0 | |
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`.`id` = 423 LIMIT 1 | 1 | 1 | 0 | |
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` = 'news' AND `Image`.`object_id` = (423) ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC | 5 | 5 | 3 | maybe slow |
select RelatedPromotion.* from promotions RelatedPromotion, places_promotions PP, places_news PN where PP.place_id = PN.place_id and PN.news_id = 423 and RelatedPromotion.id = PP.promotion_id and PN.news_id = 423 and RelatedPromotion.status = 1 and RelatedPromotion.start_date <= NOW() and RelatedPromotion.end_date >= NOW() | 0 | 0 | 0 | |
select RelatedNews.* from news RelatedNews, places_news PN, places_news CurrentPN where RelatedNews.id = PN.news_id and PN.place_id = CurrentPN.place_id and CurrentPN.news_id = 423 and RelatedNews.status = 1 and RelatedNews.publish_at <= NOW() | 0 | 0 | 0 | |
select RelatedStory.* from stories RelatedStory, places_stories PS, places_news PN where RelatedStory.id = PS.story_id and PS.place_id = PN.place_id and PN.news_id = 423 and RelatedStory.status = 1 and RelatedStory.publish_at <= NOW() | 0 | 0 | 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`, `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places` AS `Place` JOIN `atd_cn`.`places_news` AS `PlacesNews` ON (`PlacesNews`.`news_id` = 423 AND `PlacesNews`.`place_id` = `Place`.`id`) WHERE `Place`.`status` = '1' | 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`.`publish_at` <= NOW() AND (`News`.`unpublish_at` IS NULL OR `News`.`unpublish_at` > NOW()) AND `News`.`category` = 'opening' AND `News`.`id` < 423 ORDER BY `News`.`id` DESC LIMIT 1 | 1 | 1 | 1 | |
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` = 'news' AND `Image`.`object_id` = (401) ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC | 10 | 10 | 3 | maybe slow |
SELECT `CoverImage`.`id`, `CoverImage`.`name`, `CoverImage`.`filesize`, `CoverImage`.`type`, `CoverImage`.`caption`, `CoverImage`.`object_type`, `CoverImage`.`object_id`, `CoverImage`.`source`, `CoverImage`.`image1_url`, `CoverImage`.`image2_url`, `CoverImage`.`image3_url`, `CoverImage`.`image4_url`, `CoverImage`.`image5_url`, `CoverImage`.`square_url`, `CoverImage`.`square300_url`, `CoverImage`.`thumb_url`, `CoverImage`.`banner_url`, `CoverImage`.`carousel_url`, `CoverImage`.`carousel_large_url`, `CoverImage`.`original_url`, `CoverImage`.`created`, `CoverImage`.`is_cover`, `CoverImage`.`carousel_fw_url`, `CoverImage`.`mobile_cover`, `CoverImage`.`sort` FROM `atd_cn`.`images` AS `CoverImage` WHERE `CoverImage`.`object_type` = 'story' AND `CoverImage`.`is_cover` = '1' AND `CoverImage`.`object_id` = (401) | 0 | 0 | 8 | maybe slow |
SELECT `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places_news` AS `PlacesNews` WHERE `PlacesNews`.`news_id` = (401) | 0 | 0 | 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`, `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places` AS `Place` JOIN `atd_cn`.`places_news` AS `PlacesNews` ON (`PlacesNews`.`news_id` = 401 AND `PlacesNews`.`place_id` = `Place`.`id`) WHERE `Place`.`status` = '1' | 0 | 0 | 0 | |
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`.`publish_at` <= NOW() AND (`News`.`unpublish_at` IS NULL OR `News`.`unpublish_at` > NOW()) AND `News`.`category` = 'opening' AND `News`.`id` >= 401 AND `News`.`id` != 423 ORDER BY `News`.`id` ASC LIMIT 2 | 1 | 1 | 1 | |
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` = 'news' AND `Image`.`object_id` = (401) ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC | 10 | 10 | 3 | maybe slow |
SELECT `CoverImage`.`id`, `CoverImage`.`name`, `CoverImage`.`filesize`, `CoverImage`.`type`, `CoverImage`.`caption`, `CoverImage`.`object_type`, `CoverImage`.`object_id`, `CoverImage`.`source`, `CoverImage`.`image1_url`, `CoverImage`.`image2_url`, `CoverImage`.`image3_url`, `CoverImage`.`image4_url`, `CoverImage`.`image5_url`, `CoverImage`.`square_url`, `CoverImage`.`square300_url`, `CoverImage`.`thumb_url`, `CoverImage`.`banner_url`, `CoverImage`.`carousel_url`, `CoverImage`.`carousel_large_url`, `CoverImage`.`original_url`, `CoverImage`.`created`, `CoverImage`.`is_cover`, `CoverImage`.`carousel_fw_url`, `CoverImage`.`mobile_cover`, `CoverImage`.`sort` FROM `atd_cn`.`images` AS `CoverImage` WHERE `CoverImage`.`object_type` = 'story' AND `CoverImage`.`is_cover` = '1' AND `CoverImage`.`object_id` = (401) | 0 | 0 | 8 | maybe slow |
SELECT `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places_news` AS `PlacesNews` WHERE `PlacesNews`.`news_id` = (401) | 0 | 0 | 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`, `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places` AS `Place` JOIN `atd_cn`.`places_news` AS `PlacesNews` ON (`PlacesNews`.`news_id` = 401 AND `PlacesNews`.`place_id` = `Place`.`id`) WHERE `Place`.`status` = '1' | 0 | 0 | 0 | |
UPDATE `atd_cn`.`news` AS `News` SET `News`.`num_view` = News.num_view + 1 WHERE `News`.`id` = 423 | 1 | 1 | 2 | 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` >= '2025-04-27 23:51:27') OR (`News`.`unpublish_at` IS NULL)) AND `News`.`publish_at` <= '2025-04-27 23:51:27' AND NOT (`News`.`id` = 423) ORDER BY `News`.`publish_at` DESC, `News`.`id` DESC LIMIT 5 | 5 | 5 | 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 `Image`.`object_type` = 'news' AND `Image`.`object_id` IN (429, 428, 427, 426, 425) ORDER BY `Image`.`is_cover` DESC, `Image`.`sort` ASC, `Image`.`created` ASC | 72 | 72 | 4 | maybe slow |
SELECT `CoverImage`.`id`, `CoverImage`.`name`, `CoverImage`.`filesize`, `CoverImage`.`type`, `CoverImage`.`caption`, `CoverImage`.`object_type`, `CoverImage`.`object_id`, `CoverImage`.`source`, `CoverImage`.`image1_url`, `CoverImage`.`image2_url`, `CoverImage`.`image3_url`, `CoverImage`.`image4_url`, `CoverImage`.`image5_url`, `CoverImage`.`square_url`, `CoverImage`.`square300_url`, `CoverImage`.`thumb_url`, `CoverImage`.`banner_url`, `CoverImage`.`carousel_url`, `CoverImage`.`carousel_large_url`, `CoverImage`.`original_url`, `CoverImage`.`created`, `CoverImage`.`is_cover`, `CoverImage`.`carousel_fw_url`, `CoverImage`.`mobile_cover`, `CoverImage`.`sort` FROM `atd_cn`.`images` AS `CoverImage` WHERE `CoverImage`.`object_type` = 'story' AND `CoverImage`.`is_cover` = '1' AND `CoverImage`.`object_id` IN (429, 428, 427, 426, 425) | 0 | 0 | 8 | maybe slow |
SELECT `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places_news` AS `PlacesNews` WHERE `PlacesNews`.`news_id` IN (429, 428, 427, 426, 425) | 0 | 0 | 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`, `PlacesNews`.`id`, `PlacesNews`.`place_id`, `PlacesNews`.`news_id` FROM `atd_cn`.`places` AS `Place` JOIN `atd_cn`.`places_news` AS `PlacesNews` ON (`PlacesNews`.`news_id` IN (429, 428, 427, 426, 425) AND `PlacesNews`.`place_id` = `Place`.`id`) WHERE `Place`.`status` = '1' | 0 | 0 | 0 | |