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` = 'fukuoka' 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 | 0 | |
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` = 40 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 | 1 | 1 | 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` = 40 | 1 | 1 | 0 | |
DELETE `KuchikomiRankNational` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`id` = (100726) | 1 | 1 | 3 | maybe slow |
INSERT INTO `tabinfo_rentacar`.`kuchikomi_rank_nationals` (`ranking_no`, `helpful_count`, `kuchikomi_count`, `rating_overall`, `rating_service`, `rating_shop`, `rating_car`, `rating_cost`, `rating_smooth`, `is_delete`, `cmn_pref_id`, `car_brand_id`, `car_brand_code`, `car_office_id`, `created`) VALUES (1, 7, 1, 4.639999866485596, 4.599999904632568, 3.799999952316284, 5, 4.800000190734863, 5, 0, 40, 95, 'o_rental_sa', 414, '2025-04-11 13:58:00') | 1 | 1 | 3 | maybe slow |
SELECT `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'kuchikomi' AND FIND_IN_SET('40', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 0 | 0 | 1 | maybe slow |
SELECT `CarMaker`.`car_maker_code`, `CarMaker`.`id`, `CarMaker`.`car_maker_name` FROM `tabinfo_rentacar`.`car_makers` AS `CarMaker` WHERE `CarMaker`.`car_maker_code` = 'kuchikomi' AND FIND_IN_SET('40', CarMaker.cmn_pref_ids) AND `CarMaker`.`delete_type` = 0 AND `CarMaker`.`open_type` = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT `CarSpecial`.`id`, `CarSpecial`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`car_special_code` = 'kuchikomi' AND FIND_IN_SET('40', CarSpecial.cmn_pref_ids) AND `CarSpecial`.`national_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 LIMIT 1 | 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` = 'o_rental_sa' AND FIND_IN_SET('40', CarBrand.cmn_pref_ids) AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT `CarOffice`.`id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_office_name` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 414 AND `CarOffice`.`cmn_pref_id` = 40 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` = '/fukuoka/kuchikomi/o_rental_sa/414/' AND `delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/*/kuchikomi/*/*/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` IS NULL)) LIMIT 1 | 0 | 0 | 0 | |
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/rentacar-default/' AND `delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
SELECT `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`id` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`id` = 95 AND FIND_IN_SET('40', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CarOffice`.`car_office_name`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_office_image1_path` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 414 AND `CarOffice`.`car_brand_id` = (95) | 1 | 1 | 0 | |
SELECT `Kuchikomi`.`id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`rating_gender`, `Kuchikomi`.`rating_age`, `Kuchikomi`.`rating_comment`, `Kuchikomi`.`rating_overall`, `Kuchikomi`.`created`, `Kuchikomi`.`helpful_count`, `Kuchikomi`.`response_comment`, `Kuchikomi`.`rating_images`, `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` = 40 AND `Kuchikomi`.`car_brand_id` = 95 AND `Kuchikomi`.`car_office_id` = 414 AND `CarBrand`.`national_open_type` = 1 AND `Kuchikomi`.`is_display` = 1 LIMIT 20 | 1 | 1 | 4 | maybe slow |
SELECT COUNT(*) AS `count` 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` = 40 AND `Kuchikomi`.`car_brand_id` = 95 AND `Kuchikomi`.`car_office_id` = 414 AND `CarBrand`.`national_open_type` = 1 AND `Kuchikomi`.`is_display` = 1 | 1 | 1 | 2 | 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` = 95 AND `KuchikomiRankNational`.`car_office_id` = 414 AND `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1 | 1 | 1 | 0 | |
SELECT `CarBrand`.*, `CarBrand`.`id` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE NOT (`rensapo_type` = 0) AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 | 39 | 39 | 1 | |
SELECT `KuchikomiRankNational`.`rating_overall`, `KuchikomiRankNational`.`car_brand_id` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 2 | 2 | 0 | |
SELECT `CarDatabase`.`id`, `CarDatabase`.`car_brand_id`, `CarDatabase`.`type`, `CarDatabase`.`host`, `CarDatabase`.`database_name`, `CarDatabase`.`login_username`, `CarDatabase`.`login_password`, `CarDatabase`.`delete_type`, `CarDatabase`.`modified`, `CarDatabase`.`created`, `CarDatabase`.`editor`, `CarDatabase`.`author` FROM `tabinfo_rentacar`.`car_databases` AS `CarDatabase` WHERE `CarDatabase`.`delete_type` = 0 AND `CarDatabase`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 47 | 47 | 0 | |
SELECT `CarOffice`.`id`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`cmn_pref_id` = 40 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) | 9 | 9 | 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` = 64 AND `CarNationalSearchPlan`.`car_office_id` = 406 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` = 64 AND `CarNationalSearchPlan`.`car_office_id` = 448 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` = 95 AND `CarNationalSearchPlan`.`car_office_id` = 414 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` = 116 AND `CarNationalSearchPlan`.`car_office_id` = 289 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` = 116 AND `CarNationalSearchPlan`.`car_office_id` = 290 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 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` = 142 AND `CarNationalSearchPlan`.`car_office_id` = 395 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` = 142 AND `CarNationalSearchPlan`.`car_office_id` = 396 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` = 154 AND `CarNationalSearchPlan`.`car_office_id` = 423 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` = 154 AND `CarNationalSearchPlan`.`car_office_id` = 424 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` = 95 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
SELECT COUNT(`Kuchikomi`.`id`) as Kuchikomi__count, `CarNationalSearchPlan`.* FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` INNER JOIN `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` ON (`CarNationalSearchPlan`.`rensapo_plan_id` = `Kuchikomi`.`car_plan_id` AND `CarNationalSearchPlan`.`car_office_id` = `Kuchikomi`.`car_office_id` AND `CarNationalSearchPlan`.`car_brand_id` = `Kuchikomi`.`car_brand_id` AND `CarNationalSearchPlan`.`rensapo_class_id` = `Kuchikomi`.`car_class_id`) INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) 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`.`car_plan_id` = 6577 AND `Kuchikomi`.`cmn_pref_id` = 40 AND `Kuchikomi`.`car_office_id` = 414 AND `Kuchikomi`.`is_display` = 1 AND `CarNationalSearchPlan`.`car_brand_id` = 95 AND `CarNationalSearchPlan`.`rensapo_plan_id` = '6577' AND `CarNationalSearchPlan`.`rensapo_office_id` = '279' AND `CarNationalSearchPlan`.`rensapo_class_id` = '2200' AND `CarNationalSearchPlan`.`rensapo_car_type_id` = '2' AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 40 GROUP BY `Kuchikomi`.`car_plan_id`, `Kuchikomi`.`car_office_id`, `Kuchikomi`.`car_brand_id`, `CarNationalSearchPlan`.`id` ORDER BY `Kuchikomi`.`created` DESC, `Kuchikomi`.`id` DESC LIMIT 5 | 0 | 0 | 3 | maybe slow |
SELECT COUNT(`Kuchikomi`.`id`) as Kuchikomi__count, `CarNationalSearchPlan`.* FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` INNER JOIN `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` ON (`CarNationalSearchPlan`.`rensapo_plan_id` = `Kuchikomi`.`car_plan_id` AND `CarNationalSearchPlan`.`car_office_id` = `Kuchikomi`.`car_office_id` AND `CarNationalSearchPlan`.`car_brand_id` = `Kuchikomi`.`car_brand_id` AND `CarNationalSearchPlan`.`rensapo_class_id` = `Kuchikomi`.`car_class_id`) INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) 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`.`car_plan_id` = 6578 AND `Kuchikomi`.`cmn_pref_id` = 40 AND `Kuchikomi`.`car_office_id` = 414 AND `Kuchikomi`.`is_display` = 1 AND `CarNationalSearchPlan`.`car_brand_id` = 95 AND `CarNationalSearchPlan`.`rensapo_plan_id` = '6578' AND `CarNationalSearchPlan`.`rensapo_office_id` = '279' AND `CarNationalSearchPlan`.`rensapo_class_id` = '2201' AND `CarNationalSearchPlan`.`rensapo_car_type_id` = '2' AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`cmn_pref_id` = 40 GROUP BY `Kuchikomi`.`car_plan_id`, `Kuchikomi`.`car_office_id`, `Kuchikomi`.`car_brand_id`, `CarNationalSearchPlan`.`id` ORDER BY `Kuchikomi`.`created` DESC, `Kuchikomi`.`id` DESC LIMIT 5 | 0 | 0 | 3 | maybe slow |
SELECT COUNT(`Kuchikomi`.`id`) as Kuchikomi__count, `CarNationalSearchPlan`.* FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` INNER JOIN `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` ON (`CarNationalSearchPlan`.`rensapo_plan_id` = `Kuchikomi`.`car_plan_id` AND `CarNationalSearchPlan`.`car_office_id` = `Kuchikomi`.`car_office_id` AND `CarNationalSearchPlan`.`car_brand_id` = `Kuchikomi`.`car_brand_id` AND `CarNationalSearchPlan`.`rensapo_class_id` = `Kuchikomi`.`car_class_id`) INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) 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`.`car_plan_id` = 7093 AND `Kuchikomi`.`cmn_pref_id` = 40 AND `Kuchikomi`.`car_office_id` = 414 AND `Kuchikomi`.`is_display` = 1 AND `CarNationalSearchPlan`.`car_brand_id` = 95 AND `CarNationalSearchPlan`.`rensapo_plan_id` = '7093' AND `CarNationalSearchPlan`.`rensapo_office_id` = '279' AND `CarNationalSearchPlan`.`rensapo_class_id` = '2400' 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` = 40 GROUP BY `Kuchikomi`.`car_plan_id`, `Kuchikomi`.`car_office_id`, `Kuchikomi`.`car_brand_id`, `CarNationalSearchPlan`.`id` ORDER BY `Kuchikomi`.`created` DESC, `Kuchikomi`.`id` DESC LIMIT 5 | 0 | 0 | 3 | maybe slow |
SELECT COUNT(`Kuchikomi`.`id`) as Kuchikomi__count, `CarNationalSearchPlan`.* FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` INNER JOIN `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` ON (`CarNationalSearchPlan`.`rensapo_plan_id` = `Kuchikomi`.`car_plan_id` AND `CarNationalSearchPlan`.`car_office_id` = `Kuchikomi`.`car_office_id` AND `CarNationalSearchPlan`.`car_brand_id` = `Kuchikomi`.`car_brand_id` AND `CarNationalSearchPlan`.`rensapo_class_id` = `Kuchikomi`.`car_class_id`) INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarOffice`.`id` = `CarNationalSearchPlan`.`car_office_id`) 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`.`car_plan_id` = 6778 AND `Kuchikomi`.`cmn_pref_id` = 40 AND `Kuchikomi`.`car_office_id` = 414 AND `Kuchikomi`.`is_display` = 1 AND `CarNationalSearchPlan`.`car_brand_id` = 95 AND `CarNationalSearchPlan`.`rensapo_plan_id` = '6778' AND `CarNationalSearchPlan`.`rensapo_office_id` = '414' AND `CarNationalSearchPlan`.`rensapo_class_id` = '2107' 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` = 40 GROUP BY `Kuchikomi`.`car_plan_id`, `Kuchikomi`.`car_office_id`, `Kuchikomi`.`car_brand_id`, `CarNationalSearchPlan`.`id` ORDER BY `Kuchikomi`.`created` DESC, `Kuchikomi`.`id` DESC LIMIT 5 | 1 | 1 | 5 | 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` = 40 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 | 2 | 2 | 2 | |
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` = 40 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 | 2 | 2 | 3 | maybe slow |
SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CmnPref`.`id` = `CarOffice`.`cmn_pref_id`) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 GROUP BY `CmnPref`.`cmn_pref_name` ORDER BY `CmnPref`.`id` ASC | 27 | 27 | 0 | |