| 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` = 'tokyo' 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 | 1 | |
| SELECT `Kuchikomi`.`cmn_pref_id`, `Kuchikomi`.`area_div`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`car_office_id`, AVG(`Kuchikomi`.`rating_overall`) as Kuchikomi__avg_rating_overall, AVG(`Kuchikomi`.`rating_service`) as Kuchikomi__avg_rating_service, AVG(`Kuchikomi`.`rating_shop`) as Kuchikomi__avg_rating_shop, AVG(`Kuchikomi`.`rating_car`) as Kuchikomi__avg_rating_car, AVG(`Kuchikomi`.`rating_cost`) as Kuchikomi__avg_rating_cost, AVG(`Kuchikomi`.`rating_smooth`) as Kuchikomi__avg_rating_smooth, SUM(`Kuchikomi`.`helpful_count`) as Kuchikomi__sum_helpful_count, COUNT(`Kuchikomi`.`id`) as Kuchikomi__count_kuchikomi_count 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`.`is_display` = 1 AND `Kuchikomi`.`cmn_pref_id` = 13 AND `CarBrand`.`national_open_type` = 1 GROUP BY `Kuchikomi`.`cmn_pref_id`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code` ORDER BY `Kuchikomi__avg_rating_overall` DESC | 0 | 0 | 4 | maybe slow |
| SELECT `KuchikomiRankNational`.`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`.`is_delete` = 0 AND `KuchikomiRankNational`.`cmn_pref_id` = 13 | 0 | 0 | 0 | |
| SELECT `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'japan_road_trip' AND FIND_IN_SET('13', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CarMaker`.`car_maker_code`, `CarMaker`.`id`, `CarMaker`.`car_maker_name` FROM `tabinfo_rentacar`.`car_makers` AS `CarMaker` WHERE `CarMaker`.`car_maker_code` = 'japan_road_trip' AND FIND_IN_SET('13', 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` = 'japan_road_trip' AND FIND_IN_SET('13', CarSpecial.cmn_pref_ids) AND `CarSpecial`.`national_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CarOffice`.`id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_office_name` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 420 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/tokyo/japan_road_trip/420/' 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` = '/*/*/*/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` = 'pref_office')) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`id` = 151 AND FIND_IN_SET('13', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CarOffice`.`id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`address`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CmnStationNational`.`cmn_station_name`, `CmnPref`.`cmn_pref_name`, `CmnCity`.`cmn_city_name` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` LEFT JOIN `tabinfo_rentacar`.`cmn_station_nationals` AS `CmnStationNational` ON (FIND_IN_SET(`CmnStationNational`.`id`, `CarOffice`.`cmn_station_ids`) <> 0 AND `CmnStationNational`.`open_type` = 1 AND `CmnStationNational`.`delete_type` = 0) LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`CmnPref`.`id` = `CarOffice`.`cmn_pref_id` AND `CmnPref`.`open_type` = 1 AND `CmnPref`.`delete_type` = 0) LEFT JOIN `tabinfo_rentacar`.`cmn_cities` AS `CmnCity` ON (`CmnCity`.`id` = `CarOffice`.`cmn_city_id` AND `CmnCity`.`open_type` = 1 AND `CmnCity`.`delete_type` = 0) WHERE `CarOffice`.`id` = 420 AND `CarOffice`.`car_brand_id` = 151 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 LIMIT 1 | 1 | 1 | 10 | maybe slow |
| SELECT `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 420 AND `CarOffice`.`car_brand_id` = 151 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 | 1 | 1 | 0 | |
| SELECT `CarOfficeHoliday`.`start_day`, `CarOfficeHoliday`.`end_day`, `CarOfficeHoliday`.`car_office_id` FROM `tabinfo_rentacar`.`car_office_holidays` AS `CarOfficeHoliday` WHERE `CarOfficeHoliday`.`is_delete` = '0' AND `CarOfficeHoliday`.`car_office_id` = (420) | 0 | 0 | 1 | maybe slow |
| SELECT `CarOfficeOpen`.`start_day`, `CarOfficeOpen`.`start_time`, `CarOfficeOpen`.`end_day`, `CarOfficeOpen`.`end_time`, `CarOfficeOpen`.`car_office_id` FROM `tabinfo_rentacar`.`car_office_opens` AS `CarOfficeOpen` WHERE `CarOfficeOpen`.`is_delete` = '0' AND `CarOfficeOpen`.`car_office_id` = (420) | 0 | 0 | 0 | |
| SELECT `Kuchikomi`.`id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`rating_gender`, `Kuchikomi`.`rating_age`, `Kuchikomi`.`rating_comment`, `Kuchikomi`.`rating_overall`, `Kuchikomi`.`created`, `CarBrand`.`car_brand_name`, `CarBrand`.`id` FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`Kuchikomi`.`car_brand_id` = `CarBrand`.`id`) WHERE `Kuchikomi`.`cmn_pref_id` = 13 AND `Kuchikomi`.`car_brand_id` = 151 AND `Kuchikomi`.`car_office_id` = 420 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `Kuchikomi`.`is_display` = 1 ORDER BY `Kuchikomi`.`id` DESC LIMIT 10 | 0 | 0 | 11 | maybe slow |
| SELECT `KuchikomiRankNational`.`rating_overall`, `KuchikomiRankNational`.`rating_service`, `KuchikomiRankNational`.`rating_shop`, `KuchikomiRankNational`.`rating_car`, `KuchikomiRankNational`.`rating_cost`, `KuchikomiRankNational`.`rating_smooth`, `KuchikomiRankNational`.`kuchikomi_count` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`car_brand_id` = 151 AND `KuchikomiRankNational`.`car_office_id` = 420 AND `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1 | 0 | 0 | 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('13', 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("13", `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 | 1 | maybe slow |
| 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 | 1 | |
| 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` = 13 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) | 5 | 5 | 0 | |
| 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` = 123 AND `CarNationalSearchPlan`.`car_office_id` = 338 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 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` = 128 AND `CarNationalSearchPlan`.`car_office_id` = 351 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 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` = 128 AND `CarNationalSearchPlan`.`car_office_id` = 352 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 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` = 144 AND `CarNationalSearchPlan`.`car_office_id` = 410 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 0 | 0 | 1 | maybe slow |
| 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` = 151 AND `CarNationalSearchPlan`.`car_office_id` = 420 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 5 | maybe slow |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 3 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 65 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 24 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 25 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 39 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 24 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 1 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 71 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 70 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 24 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 15 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 37 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 19 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 50 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 22 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 40 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 35 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 69 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 36 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 30 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 38 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 41 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 59 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 31 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 2 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 229 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 75767797 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 4 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 3 | maybe slow |
| SELECT `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`.`car_brands` AS `CarBrand` WHERE `id` = 151 AND `delete_type` = 0 LIMIT 1 | 1 | 1 | 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` = (151) | 2 | 2 | 0 | |
| SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (151) | 6 | 6 | 0 | |
| SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` 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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 62 | 62 | 1 | |
| SELECT `CarNationalSearchPlan`.*, `CarOffice`.`id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_ids` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 151 AND `CarNationalSearchPlan`.`rensapo_plan_id` = 62 AND `CarNationalSearchPlan`.`rensapo_office_id` = 1 AND `CarNationalSearchPlan`.`rensapo_class_id` = 68 AND `CarNationalSearchPlan`.`rensapo_car_type_id` = 23 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 13 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 | 1 | 1 | 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` = 13 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 | 1 | 1 | 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` = 13 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 | 5 | 5 | 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 | 0 | |
