検索条件
- 利用日
- 2024年10月24日 ～ 2024年10月24日
- 店舗
- 鹿児島空港店 /
ご利用条件からレンタカーを検索
検索結果13件
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Office`.`id`, `Office`.`corp_id`, `Office`.`stock_office_id`, `Office`.`name`, `Office`.`kana`, `Office`.`code`, `Office`.`zip`, `Office`.`region_id`, `Office`.`prefecture_id`, `Office`.`area_id`, `Office`.`addr1`, `Office`.`addr2`, `Office`.`tel`, `Office`.`fax`, `Office`.`email`, `Office`.`considerations`, `Office`.`remarks`, `Office`.`0_is_open`, `Office`.`0_open`, `Office`.`0_closed`, `Office`.`1_is_open`, `Office`.`1_open`, `Office`.`1_closed`, `Office`.`2_is_open`, `Office`.`2_open`, `Office`.`2_closed`, `Office`.`3_is_open`, `Office`.`3_open`, `Office`.`3_closed`, `Office`.`4_is_open`, `Office`.`4_open`, `Office`.`4_closed`, `Office`.`5_is_open`, `Office`.`5_open`, `Office`.`5_closed`, `Office`.`6_is_open`, `Office`.`6_open`, `Office`.`6_closed`, `Office`.`9_is_open`, `Office`.`9_open`, `Office`.`9_closed`, `Office`.`order_num`, `Office`.`is_open`, `Office`.`is_hide`, `Office`.`is_delete`, `Office`.`editor_id`, `Office`.`creater_id`, `Office`.`modified`, `Office`.`created` FROM `rensapo_db`.`offices` AS `Office` WHERE `Office`.`is_open` = '1' AND `Office`.`is_delete` = '0' AND `Office`.`id` = 4 ORDER BY `Office`.`id` ASC | 1 | 1 | 0 | |
| SELECT `OfficeHoliday`.`id`, `OfficeHoliday`.`office_id`, `OfficeHoliday`.`start_day`, `OfficeHoliday`.`end_day`, `OfficeHoliday`.`is_delete`, `OfficeHoliday`.`modified`, `OfficeHoliday`.`created` FROM `rensapo_db`.`office_holidays` AS `OfficeHoliday` WHERE `OfficeHoliday`.`office_id` = (4) | 0 | 0 | 0 | |
| SELECT `OfficeOpen`.`id`, `OfficeOpen`.`office_id`, `OfficeOpen`.`start_day`, `OfficeOpen`.`end_day`, `OfficeOpen`.`start_time`, `OfficeOpen`.`end_time`, `OfficeOpen`.`is_delete`, `OfficeOpen`.`modified`, `OfficeOpen`.`created` FROM `rensapo_db`.`office_opens` AS `OfficeOpen` WHERE `OfficeOpen`.`office_id` = (4) | 0 | 0 | 0 | |
| SELECT `Office`.`stock_office_id` FROM `rensapo_db`.`offices` AS `Office` WHERE `id` = 4 AND `Office`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Office`.`id`, `Office`.`corp_id`, `Office`.`name` FROM `rensapo_db`.`offices` AS `Office` WHERE `Office`.`id` = (4) AND `Office`.`is_delete` = '0' ORDER BY `Office`.`id` ASC | 1 | 1 | 0 | |
| SELECT `Car`.`id`, `Car`.`car_class_id`, `Car`.`office_id` FROM `rensapo_db`.`cars` AS `Car` WHERE ((((`Car`.`period_start` <= '2024-10-24') AND (`Car`.`period_end` > '2024-10-24'))) OR (((`Car`.`period_start` < '2024-10-24') AND (`Car`.`period_end` >= '2024-10-24'))) OR (((`Car`.`period_start` >= '2024-10-24') AND (`Car`.`period_end` <= '2024-10-24')))) AND `Car`.`office_id` = (4) AND `Car`.`is_open` = '1' AND `Car`.`is_delete` = '0' ORDER BY `Car`.`id` ASC | 60 | 60 | 0 | |
| SELECT `CarOperation`.`id`, `CarOperation`.`car_class_id`, `CarOperation`.`car_id`, `CarOperation`.`start_date`, `CarOperation`.`end_date` FROM `rensapo_db`.`car_operations` AS `CarOperation` WHERE ((((`CarOperation`.`start_date` <= '2024-10-24') AND (`CarOperation`.`end_date` > '2024-10-23 23:00:00'))) OR (((`CarOperation`.`start_date` < '2024-10-25 03:00:00') AND (`CarOperation`.`end_date` >= '2024-10-24'))) OR (((`CarOperation`.`start_date` >= '2024-10-24') AND (`CarOperation`.`end_date` <= '2024-10-24')))) AND `CarOperation`.`car_id` IN (5, 10, 12, 13, 14, 19, 21, 22, 23, 24, 27, 30, 31, 32, 38, 39, 40, 42, 43, 44, 48, 60, 66, 86, 88, 89, 91, 99, 100, 101, 114, 118, 119, 126, 128, 129, 131, 133, 136, 139, 140, 141, 145, 152, 156, 158, 159, 163, 166, 169, 174, 178, 179, 180, 181, 183, 184, 185, 186, 187) AND `CarOperation`.`is_delete` = '0' ORDER BY `CarOperation`.`id` ASC | 40 | 40 | 16 | maybe slow |
| SELECT `CarClass`.`id`, `CarClass`.`name`, `CarClass`.`close_base`, `CarClass`.`close_time`, `CarClass`.`close_type` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `CarClass`.`id` IN (4, 20, 25, 15, 26, 23, 22, 14, 6, 21, 32, 34, 37, 43) AND `CarClass`.`is_delete` = '0' ORDER BY `CarClass`.`id` ASC | 14 | 14 | 0 | |
| SELECT `CarClass`.`id`, `CarClass`.`car_type_id`, `CarClass`.`corp_id`, `CarClass`.`office_id`, `CarClass`.`smoke_type`, `CarClass`.`name`, `CarClass`.`img_path1`, `CarClass`.`img_path2`, `CarClass`.`img_path3`, `CarClass`.`car_max_member`, `CarClass`.`reference_car_name`, `CarClass`.`rikuun_car_type`, `CarClass`.`close_base`, `CarClass`.`close_time`, `CarClass`.`close_type`, `CarClass`.`price_type`, `CarClass`.`indemnity_price`, `CarClass`.`remarks`, `CarClass`.`order_num`, `CarClass`.`is_open`, `CarClass`.`is_hide`, `CarClass`.`is_delete`, `CarClass`.`editor_id`, `CarClass`.`creater_id`, `CarClass`.`modified`, `CarClass`.`created` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `CarClass`.`id` IN (4, 6, 14, 15, 20, 21, 22, 23, 26, 32, 34, 37, 43) AND `CarClass`.`is_delete` = '0' ORDER BY `CarClass`.`id` ASC | 13 | 13 | 0 | |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 4 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 9 | 9 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 20 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 15 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 2 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 26 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 9 | 9 | 2 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 23 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 9 | 9 | 2 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 22 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 14 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 6 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 9 | 9 | 2 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 21 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 9 | 9 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 32 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 34 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 7 | 7 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 37 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `OptionHabtm`.`id`, `OptionHabtm`.`office_id`, `OptionHabtm`.`table_type`, `OptionHabtm`.`target_id`, `OptionHabtm`.`option_id`, `OptionHabtm`.`is_add`, `OptionHabtm`.`is_delete`, `OptionHabtm`.`editor_id`, `OptionHabtm`.`creater_id`, `OptionHabtm`.`modified`, `OptionHabtm`.`created` FROM `rensapo_db`.`option_habtms` AS `OptionHabtm` WHERE `OptionHabtm`.`table_type` = 2 AND `OptionHabtm`.`office_id` = 4 AND `OptionHabtm`.`target_id` = 43 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC | 8 | 8 | 1 | maybe slow |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '4' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 59 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '4' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 50 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 4 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '20' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 49 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '20' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 59 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 20 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '15' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 56 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '15' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 52 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 15 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '26' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 36 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '26' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 33 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 26 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '23' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 40 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '23' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 41 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 23 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '22' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 60 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '22' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 41 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 22 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '14' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 47 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '14' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 61 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 14 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '6' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 58 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '6' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 54 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 6 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '21' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 42 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '21' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 43 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 21 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '32' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 62 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '32' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 74 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 32 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '34' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 63 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '34' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 72 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 34 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '37' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 72 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '37' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 64 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 37 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `PriceSubject`.`id`, `PriceSubject`.`name` FROM `rensapo_db`.`price_subjects` AS `PriceSubject` WHERE `is_hide` = '0' AND `on_lending` = '1' AND `PriceSubject`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 14 | 14 | 0 | |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '43' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 76 | maybe slow |
| SELECT `PricePatternDay`.`id`, `PricePatternDay`.`sale_type_id`, `PricePatternDay`.`table_type`, `PricePatternDay`.`target_id`, `PricePatternDay`.`date`, `PricePatternDay`.`price_pattern_id`, `PricePatternDay`.`editor_id`, `PricePatternDay`.`creater_id`, `PricePatternDay`.`modified`, `PricePatternDay`.`created`, `PricePattern`.`id`, `PricePattern`.`sale_type_id`, `PricePattern`.`table_type`, `PricePattern`.`target_id`, `PricePattern`.`price_type`, `PricePattern`.`name`, `PricePattern`.`1h`, `PricePattern`.`2h`, `PricePattern`.`3h`, `PricePattern`.`4h`, `PricePattern`.`5h`, `PricePattern`.`6h`, `PricePattern`.`12h`, `PricePattern`.`24h`, `PricePattern`.`1d`, `PricePattern`.`2d`, `PricePattern`.`3d`, `PricePattern`.`4d`, `PricePattern`.`5d`, `PricePattern`.`6d`, `PricePattern`.`7d`, `PricePattern`.`8d`, `PricePattern`.`2w`, `PricePattern`.`3w`, `PricePattern`.`1m`, `PricePattern`.`plus_1h`, `PricePattern`.`plus_12h`, `PricePattern`.`plus_24h`, `PricePattern`.`plus_1d`, `PricePattern`.`is_open`, `PricePattern`.`is_delete`, `PricePattern`.`editor_id`, `PricePattern`.`creater_id`, `PricePattern`.`modified`, `PricePattern`.`created` FROM `rensapo_db`.`price_pattern_days` AS `PricePatternDay` LEFT JOIN `rensapo_db`.`price_patterns` AS `PricePattern` ON (`PricePatternDay`.`price_pattern_id` = `PricePattern`.`id`) WHERE `PricePatternDay`.`table_type` = 2 AND `PricePatternDay`.`target_id` = '43' AND `PricePatternDay`.`date` = '2024-10-24' LIMIT 1 | 1 | 1 | 69 | maybe slow |
| SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 43 AND `CarClass`.`is_delete` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarType`.`id`, `CarType`.`name` FROM `rensapo_db`.`car_types` AS `CarType` WHERE `CarType`.`is_delete` = '0' ORDER BY `CarType`.`id` ASC | 18 | 18 | 0 | |
| SELECT `Office`.`id`, `Office`.`0_open`, `Office`.`0_closed`, `Office`.`1_open`, `Office`.`1_closed`, `Office`.`2_open`, `Office`.`2_closed`, `Office`.`3_open`, `Office`.`3_closed`, `Office`.`4_open`, `Office`.`4_closed`, `Office`.`5_open`, `Office`.`5_closed`, `Office`.`6_open`, `Office`.`6_closed`, `Office`.`9_open`, `Office`.`9_closed` FROM `rensapo_db`.`offices` AS `Office` WHERE `Office`.`is_open` = '1' AND `Office`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 2 | 2 | 0 | |
| SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `rensapo_db`.`prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 43 AND `Prefecture`.`is_delete` = '0' ORDER BY `Prefecture`.`id` ASC | 1 | 1 | 0 | |
| SELECT `Option`.`id`, `Option`.`name` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`is_delete` = '0' | 10 | 10 | 0 | |
| SELECT `Office`.`id`, `Office`.`name` FROM `rensapo_db`.`offices` AS `Office` WHERE `Office`.`is_open` = '1' AND `Office`.`is_delete` = '0' ORDER BY `order_num` ASC, `id` DESC | 2 | 2 | 0 |
25 duplicate queries run.
Peak Memory Use 16.80 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.19 MB |
| Controller action start | 4.67 MB |
| Controller render start | 8.85 MB |
| View render complete | 10.32 MB |
Total Request Time: 1646 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 21.87 | |
| Event: Controller.initialize | 0.07 | |
| Event: Controller.startup | 0.71 | |
| Controller action | 1560.43 | |
| Event: Controller.beforeRender | 17.13 | |
| » Processing toolbar data | 17.02 | |
| Rendering View | 7.27 | |
| » Event: View.beforeRender | 0.02 | |
| » Rendering APP/View/Rentacars/plan.ctp | 6.36 | |
| » Event: View.afterRender | 0.02 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/View/Layouts/default_front.ctp | 0.20 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | /home/rct39-sys/cake_rensapo/app/Config/ |
| SITE_NAME | Rensapo |
| SITE_URL | https://rct39-sys.com/rsv/ |
| CORP_NAME | レンタカーテラス39 |
| SITE_TITLE | レンタカーテラス39 |
| SITE_URL_OFFICIAL | https://tokotonrenta.com/ |
| SITE_FRONT_URL | https://rct39-sys.com/rsv/rentacars/plan/ |
| FOR_SEND_MAIL | rensapo_info@rct39-sys.com |
| MANAGEMENT_BEGAN_DAY | 2020-06-01 |
| FRONT_WEB_SITE | 1 |
| DIGITAL_SIGN | |
| CRYPT_METHOD | AES-256-CBC |
| CRYPT_KEY | no3QmgV9n8sb |
| CRYPT_OPTION | 0 |
| FUNC_MEMBER | 1 |
| AIRPORT_FLIGHT_AREA_DISPLAY | 1 |
| AIRPORT_FLIGHT_AREA_AUTO_DISPLAY | |
| AIRPORT_FLIGHT_MAIN | 53 |
| AREA_PRICE_DETAIL_RETURN | |
| SALE_TYPE_PLAN_STATUS | 1 |
| SALE_TYPE_COUPON_STATUS | |
| PRICE_PATTERN_QUOTATION | 1 |
| CAR_LIST_PAGINATION_STATUS | 1 |
| SALE_TYPE_DELETE_FLG | |
| FUNC_DEALER_SONPO | 1 |
| BACK_MARGIN_BOOKING | |
| SALE_TYPE_INVOICE_FLG | 1 |
| PROBLEM_2038 | 2037-12-31 23:45:00 |
| CONTACT_DISPLAY | 1 |
| CONTACT_MAIL | |
| CONTACT_TEL | |
| CONTACT_URL | https://rct39-sys.com/rsv/contact/ |
| INVOICE_NON | 0 |
| INVOICE_EACH | 1 |
| INVOICE_MONTH | 2 |
| INVOICE_20DAYS_CLOSE | 3 |
| IMG_MAGIC | /usr/bin/convert |
| DIR_CAR | /home/rct39-sys/www/rsv/img/car/ |
| DIR_CAR_MAKER | /home/rct39-sys/www/rsv/img/car_maker/ |
| DIR_CAR_MODEL | /home/rct39-sys/www/rsv/img/car_model/ |
| DIR_CAR_CLASS | /home/rct39-sys/www/rsv/img/car_class/ |
| DIR_CREDIT | /home/rct39-sys/www/rsv/img/credit/ |
| AUTH_HEAD | 10 |
| AUTH_FC | 20 |
| AUTH_OFFICE | 30 |
| AUTH_STAFF | 40 |
| CAR_FREE | 0 |
| CAR_USE | 1 |
| CAR_MAINTE | 2 |
| CAR_RETURN | 3 |
| REIWA | 2018 |
| HEISEI | 1988 |
| SHOUWA | 1925 |
| WAREKI_REIWA | 20190501 |
| WAREKI_HEISEI | 19890108 |
| WAREKI_SHOUWA | 19261225 |
| LEASE_DAY | 1 |
| LEASE_NUM | 2 |
| LEASE_HOUR | 3 |
| SMOKE_UNASSIGN | 0 |
| SMOKE_NON | 1 |
| SMOKE_OK | 2 |
| CLOSE_BASE_DAY | 1 |
| CLOSE_BASE_TIME | 2 |
| CLOSE_TYPE_DAY | 1 |
| CLOSE_TYPE_TIME | 2 |
| PRICE_SEASON_TIME | 1 |
| PRICE_SEASON_DAY | 2 |
| PRICE_DAY | 3 |
| TABLE_TYPE_CAR | 1 |
| TABLE_TYPE_CLASS | 2 |
| TABLE_TYPE_PLAN | 3 |
| BOOKING_STATE_WAITING | 1 |
| BOOKING_STATE_IN_USE | 3 |
| BOOKING_STATE_RETURNED | 4 |
| BOOKING_STATE_CANCEL | 8 |
| BOOKING_STATE_NO_SHOW | 9 |
| OPE_TYPE_BOOKING | 1 |
| OPE_TYPE_MAINTE | 2 |
| OPE_TYPE_ONEWAY | 3 |
| OPE_START | 1 |
| OPE_END | 2 |
| BASE_START_DATE | start_date |
| BASE_END_DATE | end_date |
| BOOKING_ABLE_SPACE | 1 |
| OPEN_TYPE_OFF | 0 |
| OPEN_TYPE_ON | 1 |
| DELETE_TYPE_OFF | 0 |
| DELETE_TYPE_ON | 1 |
| WEB_UNRESERVED | 0 |
| WEB_RESERVATION | 1 |
| WEB_CANCEL | 2 |
| WEB_PENDING | 3 |
| WEB_SKY_TICKET | 8 |
| WEB_JARAN | 9 |
| WEB_RAKUTEN | 4 |
| WEB_RENNAVI | 10 |
| WEB_OKIRAKU | 11 |
| WEB_TABIPURAZA | 12 |
| WEB_TABIRAI | 14 |
| WEB_RENTCAR_COM | 13 |
| WEB_BEST_PRICE_RENTCAR | 15 |
| WEB_BOOKING_COM | 16 |
| WEB_CSV | 1 |
| CSV_DIR | /home/rct39-sys/cake_rensapo/csv/ |
| CONTACT_TYPE_CUSTOMER | 1 |
| CONTACT_TYPE_STORE | 2 |
| CONTACT_STATUS_DONE | 1 |
| CONTACT_STATUS_CONFIRM | 2 |
| CONTACT_STATUS_NONE | 3 |
| JOUYOUSHA | 1 |
| JOUYOUSHA_K | 2 |
| MICROBUS | 3 |
| TRUCK | 4 |
| TRUCK_K | 5 |
| SPECIAL_USE | 6 |
| SPECIAL_USE_K | 7 |
| MOTORCYCLE | 8 |
| MOTORCYCLE_K | 9 |
| Constant | Value |
|---|---|
| APP | /home/rct39-sys/cake_rensapo/app/ |
| APP_DIR | app |
| APPLIBS | /home/rct39-sys/cake_rensapo/app/Lib/ |
| CACHE | /home/rct39-sys/cake_rensapo/app/tmp/cache/ |
| CAKE | /home/rct39-sys/cake_rensapo/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /home/rct39-sys/cake_rensapo/lib |
| CORE_PATH | /home/rct39-sys/cake_rensapo/lib/ |
| CAKE_VERSION | 2.10.6 |
| CSS | /home/rct39-sys/www/rsv/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | https://rct39-sys.com |
| IMAGES | /home/rct39-sys/www/rsv/img/ |
| IMAGES_URL | img/ |
| JS | /home/rct39-sys/www/rsv/js/ |
| JS_URL | js/ |
| LOGS | /home/rct39-sys/cake_rensapo/app/tmp/logs/ |
| ROOT | /home/rct39-sys/cake_rensapo |
| TESTS | /home/rct39-sys/cake_rensapo/app/Test/ |
| TMP | /home/rct39-sys/cake_rensapo/app/tmp/ |
| VENDORS | /home/rct39-sys/cake_rensapo/vendors/ |
| WEBROOT_DIR | rsv |
| WWW_ROOT | /home/rct39-sys/www/rsv/ |
| Environment Variable | Value |
|---|---|
| Php Version | 5.6.40 |
| Redirect Https | on |
| Redirect Status | 200 |
| Https | on |
| Http Host | rct39-sys.com |
| Http X Real Ip | 18.222.164.225 |
| Http Listen Ipaddr | 153.127.114.220 |
| Http Accept | */* |
| Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Http Accept Encoding | gzip, br, zstd, deflate |
| Path | /sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin |
| Server Signature | |
| Server Software | Apache |
| Server Name | rct39-sys.com |
| Server Addr | 100.64.0.11 |
| Server Port | 443 |
| Remote Host | ec2-18-222-164-225.us-east-2.compute.amazonaws.com |
| Remote Addr | 18.222.164.225 |
| Document Root | /home/rct39-sys/www/ |
| Request Scheme | https |
| Context Prefix | |
| Context Document Root | /home/rct39-sys/www/ |
| Server Admin | [no address given] |
| Script Filename | /home/rct39-sys/www/rsv/index.php |
| Remote Port | 0 |
| Redirect Url | /rsv/rentacars/plan/ |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/1.1 |
| Request Method | GET |
| Query String | |
| Request Uri | /rsv/rentacars/plan/ |
| Script Name | /rsv/index.php |
| Php Self | /rsv/index.php |
| Request Time Float | 1729614011.979 |
| Request Time | 1729614011 |
| Argc | 0 |