Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code`, `CmnPref`.`cmn_pref_image_path` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` WHERE `CmnPref`.`cmn_pref_code` = 'hokkaido' AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `KuchikomiRankNational`.`created` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'kuchikomi' AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `CarMaker`.`car_maker_code`, `CarMaker`.`id`, `CarMaker`.`car_maker_name` FROM `tabinfo_rentacar`.`car_makers` AS `CarMaker` WHERE `CarMaker`.`car_maker_code` = 'kuchikomi' AND FIND_IN_SET('1', CarMaker.cmn_pref_ids) AND `CarMaker`.`delete_type` = 0 AND `CarMaker`.`open_type` = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT `CarSpecial`.`id`, `CarSpecial`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`car_special_code` = 'kuchikomi' AND FIND_IN_SET('1', CarSpecial.cmn_pref_ids) AND `CarSpecial`.`national_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/hokkaido/kuchikomi/' AND `delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/*/kuchikomi/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` IS NULL)) LIMIT 1 | 1 | 1 | 0 | |
SELECT `KuchikomiRankNational`.`id`, `KuchikomiRankNational`.`kuchikomi_count`, `KuchikomiRankNational`.`rating_overall`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_code`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`national_open_type`, `CarBrand`.`id` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`KuchikomiRankNational`.`car_brand_id` = `CarBrand`.`id`) WHERE `KuchikomiRankNational`.`cmn_pref_id` = 1 AND `KuchikomiRankNational`.`is_delete` = 0 AND `CarBrand`.`national_open_type` = 1 | 2 | 2 | 2 | |
SELECT `KuchikomiRankNational`.`id`, `KuchikomiRankNational`.`cmn_pref_id`, `KuchikomiRankNational`.`ranking_no`, `KuchikomiRankNational`.`car_brand_id`, `KuchikomiRankNational`.`car_brand_code`, `KuchikomiRankNational`.`car_office_id`, `KuchikomiRankNational`.`helpful_count`, `KuchikomiRankNational`.`kuchikomi_count`, `KuchikomiRankNational`.`rating_overall`, `KuchikomiRankNational`.`rating_service`, `KuchikomiRankNational`.`rating_shop`, `KuchikomiRankNational`.`rating_car`, `KuchikomiRankNational`.`rating_cost`, `KuchikomiRankNational`.`rating_smooth`, `KuchikomiRankNational`.`is_delete`, `KuchikomiRankNational`.`created`, `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_name_en`, `CarBrand`.`car_brand_name_cnh`, `CarBrand`.`car_brand_name_cnk`, `CarBrand`.`car_brand_name_ko`, `CarBrand`.`car_brand_name_kana`, `CarBrand`.`car_brand_code`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`contact_tel`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`car_brand_image1_path`, `CarBrand`.`car_brand_image2_path`, `CarBrand`.`car_brand_movie_url`, `CarBrand`.`car_brand_movie_url_en`, `CarBrand`.`car_brand_movie_url_cnh`, `CarBrand`.`car_brand_movie_url_cnk`, `CarBrand`.`car_brand_movie_url_ko`, `CarBrand`.`car_brand_memo1`, `CarBrand`.`car_brand_cancel_policy`, `CarBrand`.`car_brand_guarantee_system`, `CarBrand`.`car_brand_memo1_en`, `CarBrand`.`car_brand_memo1_cnh`, `CarBrand`.`car_brand_memo1_cnk`, `CarBrand`.`car_brand_memo1_ko`, `CarBrand`.`car_brand_reservation_code`, `CarBrand`.`rensapo_type`, `CarBrand`.`rensapo_brand_id`, `CarBrand`.`rensapo_office_id`, `CarBrand`.`rensapo_url`, `CarBrand`.`linked_rensapo_M`, `CarBrand`.`has_communication_tool`, `CarBrand`.`point_give_type`, `CarBrand`.`search_open_type`, `CarBrand`.`sort`, `CarBrand`.`is_jtb`, `CarBrand`.`jtb_sort`, `CarBrand`.`jtb_open_type`, `CarBrand`.`national_open_type`, `CarBrand`.`open_type`, `CarBrand`.`delete_type`, `CarBrand`.`modified`, `CarBrand`.`created`, `CarBrand`.`editor`, `CarBrand`.`author` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`KuchikomiRankNational`.`car_brand_id` = `CarBrand`.`id`) WHERE `KuchikomiRankNational`.`cmn_pref_id` = 1 AND `KuchikomiRankNational`.`is_delete` = 0 AND `CarBrand`.`national_open_type` = 1 ORDER BY `KuchikomiRankNational`.`ranking_no` ASC | 2 | 2 | 1 | maybe slow |
SELECT `Kuchikomi`.`id`, `Kuchikomi`.`cmn_pref_id`, `Kuchikomi`.`area_div`, `Kuchikomi`.`car_office_id`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`car_reservation_no`, `Kuchikomi`.`car_plan_id`, `Kuchikomi`.`car_plan_name`, `Kuchikomi`.`car_class_id`, `Kuchikomi`.`car_class_name`, `Kuchikomi`.`car_plan_haiki`, `Kuchikomi`.`car_plan_ninzu`, `Kuchikomi`.`car_plan_cartype`, `Kuchikomi`.`rating_age`, `Kuchikomi`.`rating_gender`, `Kuchikomi`.`rating_overall`, `Kuchikomi`.`rating_service`, `Kuchikomi`.`rating_shop`, `Kuchikomi`.`rating_car`, `Kuchikomi`.`rating_cost`, `Kuchikomi`.`rating_smooth`, `Kuchikomi`.`rating_comment`, `Kuchikomi`.`rating_images`, `Kuchikomi`.`helpful_count`, `Kuchikomi`.`see_count`, `Kuchikomi`.`response_comment`, `Kuchikomi`.`response_date`, `Kuchikomi`.`admin_comment`, `Kuchikomi`.`is_display`, `Kuchikomi`.`created`, `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_name_en`, `CarBrand`.`car_brand_name_cnh`, `CarBrand`.`car_brand_name_cnk`, `CarBrand`.`car_brand_name_ko`, `CarBrand`.`car_brand_name_kana`, `CarBrand`.`car_brand_code`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`contact_tel`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`car_brand_image1_path`, `CarBrand`.`car_brand_image2_path`, `CarBrand`.`car_brand_movie_url`, `CarBrand`.`car_brand_movie_url_en`, `CarBrand`.`car_brand_movie_url_cnh`, `CarBrand`.`car_brand_movie_url_cnk`, `CarBrand`.`car_brand_movie_url_ko`, `CarBrand`.`car_brand_memo1`, `CarBrand`.`car_brand_cancel_policy`, `CarBrand`.`car_brand_guarantee_system`, `CarBrand`.`car_brand_memo1_en`, `CarBrand`.`car_brand_memo1_cnh`, `CarBrand`.`car_brand_memo1_cnk`, `CarBrand`.`car_brand_memo1_ko`, `CarBrand`.`car_brand_reservation_code`, `CarBrand`.`rensapo_type`, `CarBrand`.`rensapo_brand_id`, `CarBrand`.`rensapo_office_id`, `CarBrand`.`rensapo_url`, `CarBrand`.`linked_rensapo_M`, `CarBrand`.`has_communication_tool`, `CarBrand`.`point_give_type`, `CarBrand`.`search_open_type`, `CarBrand`.`sort`, `CarBrand`.`is_jtb`, `CarBrand`.`jtb_sort`, `CarBrand`.`jtb_open_type`, `CarBrand`.`national_open_type`, `CarBrand`.`open_type`, `CarBrand`.`delete_type`, `CarBrand`.`modified`, `CarBrand`.`created`, `CarBrand`.`editor`, `CarBrand`.`author`, `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code`, `CmnPref`.`sort`, `CmnPref`.`cmn_pref_image_path`, `CmnPref`.`open_type`, `CmnPref`.`delete_type`, `CmnPref`.`modified`, `CmnPref`.`created`, `CmnPref`.`editor`, `CmnPref`.`author` FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`Kuchikomi`.`car_brand_id` = `CarBrand`.`id`) LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`Kuchikomi`.`cmn_pref_id` = `CmnPref`.`id`) WHERE `Kuchikomi`.`cmn_pref_id` = 1 AND `Kuchikomi`.`is_display` = 1 AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`national_open_type` = 1 ORDER BY `Kuchikomi`.`helpful_count` DESC, `Kuchikomi`.`rating_overall` DESC LIMIT 5 | 1 | 1 | 3 | maybe slow |
SELECT `Kuchikomi`.`id`, `Kuchikomi`.`cmn_pref_id`, `Kuchikomi`.`area_div`, `Kuchikomi`.`car_office_id`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`car_reservation_no`, `Kuchikomi`.`car_plan_id`, `Kuchikomi`.`car_plan_name`, `Kuchikomi`.`car_class_id`, `Kuchikomi`.`car_class_name`, `Kuchikomi`.`car_plan_haiki`, `Kuchikomi`.`car_plan_ninzu`, `Kuchikomi`.`car_plan_cartype`, `Kuchikomi`.`rating_age`, `Kuchikomi`.`rating_gender`, `Kuchikomi`.`rating_overall`, `Kuchikomi`.`rating_service`, `Kuchikomi`.`rating_shop`, `Kuchikomi`.`rating_car`, `Kuchikomi`.`rating_cost`, `Kuchikomi`.`rating_smooth`, `Kuchikomi`.`rating_comment`, `Kuchikomi`.`rating_images`, `Kuchikomi`.`helpful_count`, `Kuchikomi`.`see_count`, `Kuchikomi`.`response_comment`, `Kuchikomi`.`response_date`, `Kuchikomi`.`admin_comment`, `Kuchikomi`.`is_display`, `Kuchikomi`.`created`, `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_name_en`, `CarBrand`.`car_brand_name_cnh`, `CarBrand`.`car_brand_name_cnk`, `CarBrand`.`car_brand_name_ko`, `CarBrand`.`car_brand_name_kana`, `CarBrand`.`car_brand_code`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`contact_tel`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`car_brand_image1_path`, `CarBrand`.`car_brand_image2_path`, `CarBrand`.`car_brand_movie_url`, `CarBrand`.`car_brand_movie_url_en`, `CarBrand`.`car_brand_movie_url_cnh`, `CarBrand`.`car_brand_movie_url_cnk`, `CarBrand`.`car_brand_movie_url_ko`, `CarBrand`.`car_brand_memo1`, `CarBrand`.`car_brand_cancel_policy`, `CarBrand`.`car_brand_guarantee_system`, `CarBrand`.`car_brand_memo1_en`, `CarBrand`.`car_brand_memo1_cnh`, `CarBrand`.`car_brand_memo1_cnk`, `CarBrand`.`car_brand_memo1_ko`, `CarBrand`.`car_brand_reservation_code`, `CarBrand`.`rensapo_type`, `CarBrand`.`rensapo_brand_id`, `CarBrand`.`rensapo_office_id`, `CarBrand`.`rensapo_url`, `CarBrand`.`linked_rensapo_M`, `CarBrand`.`has_communication_tool`, `CarBrand`.`point_give_type`, `CarBrand`.`search_open_type`, `CarBrand`.`sort`, `CarBrand`.`is_jtb`, `CarBrand`.`jtb_sort`, `CarBrand`.`jtb_open_type`, `CarBrand`.`national_open_type`, `CarBrand`.`open_type`, `CarBrand`.`delete_type`, `CarBrand`.`modified`, `CarBrand`.`created`, `CarBrand`.`editor`, `CarBrand`.`author`, `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code`, `CmnPref`.`sort`, `CmnPref`.`cmn_pref_image_path`, `CmnPref`.`open_type`, `CmnPref`.`delete_type`, `CmnPref`.`modified`, `CmnPref`.`created`, `CmnPref`.`editor`, `CmnPref`.`author` FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`Kuchikomi`.`car_brand_id` = `CarBrand`.`id`) LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`Kuchikomi`.`cmn_pref_id` = `CmnPref`.`id`) WHERE `Kuchikomi`.`cmn_pref_id` = 1 AND `Kuchikomi`.`is_display` = 1 AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`national_open_type` = 1 ORDER BY `Kuchikomi`.`created` DESC, `Kuchikomi`.`id` DESC LIMIT 5 | 1 | 1 | 6 | maybe slow |
SELECT `Kuchikomi`.`rating_images`, `Kuchikomi`.`id`, `Kuchikomi`.`created`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code` FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`Kuchikomi`.`car_brand_id` = `CarBrand`.`id`) LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`Kuchikomi`.`cmn_pref_id` = `CmnPref`.`id`) WHERE `Kuchikomi`.`cmn_pref_id` = 1 AND `Kuchikomi`.`is_display` = 1 AND `Kuchikomi`.`rating_images` IS NOT NULL AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`national_open_type` = 1 ORDER BY `Kuchikomi`.`created` DESC, `Kuchikomi`.`id` DESC LIMIT 10 | 0 | 0 | 3 | maybe slow |
SELECT DISTINCT `CmnAirportNational`.`id`, `CmnAirportNational`.`cmn_airport_name`, `CmnAirportNational`.`cmn_airport_code`, COUNT(DISTINCT CmnAirportNational.id) FROM `tabinfo_rentacar`.`cmn_airport_nationals` AS `CmnAirportNational` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (FIND_IN_SET(`CmnAirportNational`.`id`, `CarOffice`.`cmn_airport_ids`) <> 0) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CmnAirportNational`.`cmn_pref_id` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnAirportNational`.`delete_type` = 0 AND `CmnAirportNational`.`open_type` = 1 GROUP BY `CmnAirportNational`.`id` ORDER BY COUNT(*) DESC, `CmnAirportNational`.`id` ASC LIMIT 5 | 3 | 3 | 0 | |
SELECT DISTINCT `CmnStationNational`.`id`, `CmnStationNational`.`cmn_station_name`, `CmnStationNational`.`cmn_station_code`, COUNT(*) FROM `tabinfo_rentacar`.`cmn_station_nationals` AS `CmnStationNational` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (FIND_IN_SET(`CmnStationNational`.`id`, `CarOffice`.`cmn_station_ids`) <> 0) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CmnStationNational`.`cmn_pref_id` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnStationNational`.`delete_type` = 0 AND `CmnStationNational`.`open_type` = 1 GROUP BY `CmnStationNational`.`id` ORDER BY COUNT(*) DESC, `CmnStationNational`.`id` ASC LIMIT 5 | 3 | 3 | 0 | |
SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CmnPref`.`id` = `CarOffice`.`cmn_pref_id`) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 GROUP BY `CmnPref`.`cmn_pref_name` ORDER BY `CmnPref`.`id` ASC | 27 | 27 | 3 | maybe slow |