Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Location`.`id`, `Location`.`name` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`level` = 2 | 2 | 2 | 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`, `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` <= NOW() AND NOT (`Review`.`id` IS NULL) AND `Place`.`type` = 'restaurant' AND `Place`.`restaurant_type` IN ('U', 'B') ORDER BY `Review`.`publish_at` DESC, `Review`.`id` DESC LIMIT 6 | 6 | 6 | 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` IN (939, 938, 937, 936, 935, 934) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 17 | 17 | 4 | maybe slow |
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 (939, 938, 937, 936, 935, 934) | 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` = 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 | 3 | maybe slow |
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Location`.`id`, `Location`.`parent_id`, `Location`.`name`, `Location`.`level`, `Location`.`code`, `Location`.`name_2`, `Location`.`status`, `Location`.`sort` FROM `atd_cn`.`locations` AS `Location` WHERE `Location`.`id` = 4 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Place`.`latest_review_id`, `Place`.`num_view`, `Place`.`id` 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`.`type` = 'restaurant' AND `Place`.`close_at` IS NULL AND `Place`.`restaurant_type` IN ('U', 'B') ORDER BY `Place`.`num_view` DESC LIMIT 3 | 3 | 3 | 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`.`id` IN (595, 824, 792) | 3 | 3 | 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` = 'review' AND `Image`.`object_id` IN (595, 792, 824) ORDER BY `Image`.`sort` ASC, `Image`.`created` ASC | 8 | 8 | 4 | maybe slow |
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 (595, 792, 824) | 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` = 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 | |