| 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` = 'iwate' AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `KuchikomiRankNational`.`created` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'ichinoseki-shi' AND FIND_IN_SET('3', 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` = 'ichinoseki-shi' AND FIND_IN_SET('3', CarMaker.cmn_pref_ids) AND `CarMaker`.`delete_type` = 0 AND `CarMaker`.`open_type` = 1 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `CarSpecial`.`id`, `CarSpecial`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`car_special_code` = 'ichinoseki-shi' AND FIND_IN_SET('3', CarSpecial.cmn_pref_ids) AND `CarSpecial`.`national_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CmnCity`.`cmn_city_code`, `CmnCity`.`id`, `CmnCity`.`cmn_city_name` FROM `tabinfo_rentacar`.`cmn_cities` AS `CmnCity` WHERE `CmnCity`.`cmn_city_code` = 'ichinoseki-shi' AND `CmnCity`.`cmn_pref_id` = 3 AND `CmnCity`.`delete_type` = 0 AND `CmnCity`.`open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CmnCity`.`cmn_city_name`, `CmnCity`.`id` FROM `tabinfo_rentacar`.`cmn_cities` AS `CmnCity` WHERE `CmnCity`.`id` = 2204 AND `CmnCity`.`delete_type` = 0 AND `CmnCity`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarFaqNational`.`id`, `CarFaqNational`.`car_faq_title`, `CarFaqNational`.`top_open_type`, `CarFaqNational`.`pref_open_type`, `CarFaqNational`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_faq_nationals` AS `CarFaqNational` WHERE ((((`CarFaqNational`.`top_open_type` = 1) AND (`CarFaqNational`.`pref_open_type` = 1) AND (FIND_IN_SET('3', CarFaqNational.cmn_pref_ids)))) OR (((`CarFaqNational`.`top_open_type` = 1) AND (`CarFaqNational`.`pref_open_type` = 0) AND (((`CarFaqNational`.`cmn_pref_ids` = '') OR (`CarFaqNational`.`cmn_pref_ids` IS NULL)))))) AND `CarFaqNational`.`delete_type` = 0 AND `CarFaqNational`.`open_type` = 1 ORDER BY (
CASE
WHEN `CarFaqNational`.`top_open_type` = 1 AND `CarFaqNational`.`pref_open_type` = 1 AND FIND_IN_SET("3", `CarFaqNational`.`cmn_pref_ids`)
THEN 1
WHEN `CarFaqNational`.`top_open_type` = 1 AND `CarFaqNational`.`pref_open_type` = 0 AND (`CarFaqNational`.`cmn_pref_ids` = "" OR `CarFaqNational`.`cmn_pref_ids` IS NULL)
THEN 2
ELSE 3
END
) ASC, `sort` DESC LIMIT 10 | 7 | 7 | 2 | 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` = 3 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 | 0 | 0 | 2 | maybe slow |
| 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` = 3 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 | 1 | 1 | 4 | maybe slow |
| 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 | 0 | |
| SELECT `CmnPref`.`id` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` WHERE `cmn_pref_code` = 'iwate' AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_code`, `CarBrand`.`car_brand_logo_image_path` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 ORDER BY `sort` DESC LIMIT 5 | 5 | 5 | 0 | |
| SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE NOT (`CarBrand`.`rensapo_type` = 0) AND FIND_IN_SET('3', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 ORDER BY `sort` DESC | 1 | 1 | 1 | |
| SELECT `CarDatabase`.`id`, `CarDatabase`.`car_brand_id`, `CarDatabase`.`type`, `CarDatabase`.`host`, `CarDatabase`.`database_name`, `CarDatabase`.`login_username`, `CarDatabase`.`login_password`, `CarDatabase`.`delete_type`, `CarDatabase`.`modified`, `CarDatabase`.`created`, `CarDatabase`.`editor`, `CarDatabase`.`author` FROM `tabinfo_rentacar`.`car_databases` AS `CarDatabase` WHERE `CarDatabase`.`delete_type` = 0 AND `CarDatabase`.`car_brand_id` = (122) | 1 | 1 | 0 | |
| SELECT `CarType`.`id`, `CarType`.`car_type_name`, `CarType`.`car_type_code`, `CarType`.`car_type_memo2` FROM `tabinfo_rentacar`.`car_types` AS `CarType` WHERE `CarType`.`delete_type` = 0 AND `CarType`.`open_type` = 1 | 11 | 11 | 2 | maybe slow |
| SELECT `CarOptionSearch`.`id`, `CarOptionSearch`.`car_option_search_name` FROM `tabinfo_rentacar`.`car_option_searches` AS `CarOptionSearch` WHERE `CarOptionSearch`.`open_type` = 1 AND `CarOptionSearch`.`delete_type` = 0 ORDER BY `CarOptionSearch`.`sort` DESC | 1 | 1 | 0 | |
| SELECT `CarSpecial`.`id`, `CarSpecial`.`car_special_search_name` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`national_search_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 ORDER BY `CarSpecial`.`sort` DESC | 0 | 0 | 0 | |
| SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` WHERE `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 ORDER BY `sort` DESC | 47 | 47 | 0 | |
| SELECT `CmnAirportNational`.`id`, `CmnAirportNational`.`cmn_airport_name`, `CmnAirportNational`.`cmn_pref_id` FROM `tabinfo_rentacar`.`cmn_airport_nationals` AS `CmnAirportNational` WHERE `CmnAirportNational`.`delete_type` = 0 AND `CmnAirportNational`.`open_type` = 1 ORDER BY `sort` DESC | 74 | 74 | 0 | |
| SELECT `CmnCity`.`cmn_city_name`, `CmnCity`.`cmn_city_code` FROM `tabinfo_rentacar`.`cmn_cities` AS `CmnCity` LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`CmnCity`.`cmn_pref_id` = `CmnPref`.`id`) WHERE `CmnCity`.`id` = 2204 AND `CmnCity`.`delete_type` = 0 AND `CmnCity`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarBrand`.*, `CarBrand`.`id` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE NOT (`rensapo_type` = 0) AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 | 39 | 39 | 1 | |
| SELECT `KuchikomiRankNational`.`rating_overall`, `KuchikomiRankNational`.`car_brand_id` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 2 | 2 | 0 | |
| SELECT `CarDatabase`.`id`, `CarDatabase`.`car_brand_id`, `CarDatabase`.`type`, `CarDatabase`.`host`, `CarDatabase`.`database_name`, `CarDatabase`.`login_username`, `CarDatabase`.`login_password`, `CarDatabase`.`delete_type`, `CarDatabase`.`modified`, `CarDatabase`.`created`, `CarDatabase`.`editor`, `CarDatabase`.`author` FROM `tabinfo_rentacar`.`car_databases` AS `CarDatabase` WHERE `CarDatabase`.`delete_type` = 0 AND `CarDatabase`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 47 | 47 | 0 | |
| SELECT `CarOffice`.`id`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`cmn_pref_id` = 3 AND `CarOffice`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 1 | 1 | 1 | |
| SELECT `CarNationalSearchPlan`.`rensapo_brand_id` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 122 AND `CarNationalSearchPlan`.`car_office_id` = 334 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
