RentacarsController::getStockOneData() - APP/Controller/RentacarsController.php, line 2291
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
Notice (8): Undefined index: CarClass [APP/Controller/RentacarsController.php, line 2294]
RentacarsController::getStockOneData() - APP/Controller/RentacarsController.php, line 2294
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
Notice (8): Undefined index: CarClass [APP/Controller/RentacarsController.php, line 2300]
RentacarsController::getStockOneData() - APP/Controller/RentacarsController.php, line 2300
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
Notice (8): Undefined index: CarClass [APP/Controller/RentacarsController.php, line 2303]
RentacarsController::getStockOneData() - APP/Controller/RentacarsController.php, line 2303
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
Notice (8): Undefined variable: tagetCloseDate [APP/Controller/RentacarsController.php, line 2307]
RentacarsController::getStockOneData() - APP/Controller/RentacarsController.php, line 2307
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
Notice (8): Undefined variable: adjustTime [APP/Controller/RentacarsController.php, line 2307]
RentacarsController::getStockOneData() - APP/Controller/RentacarsController.php, line 2307
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 303
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
Notice (8): Undefined index: CarClass [APP/Controller/RentacarsController.php, line 2797]
RentacarsController::getViewData() - APP/Controller/RentacarsController.php, line 2797
RentacarsController::plan_detail() - APP/Controller/RentacarsController.php, line 325
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 491
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - /home/rct39-sys/www/rsv/index.php, line 122
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 `CarClass`.`id`, `CarClass`.`name`, `CarClass`.`close_base`, `CarClass`.`close_time`, `CarClass`.`close_type` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `CarClass`.`id` = 17 AND `CarClass`.`is_delete` = '0' ORDER BY `CarClass`.`id` ASC LIMIT 1
0
0
0
SELECT `Office`.`id`, `Office`.`corp_id`, `Office`.`area_id`, `Office`.`name`, `Office`.`prefecture_id`, `Office`.`addr1`, `Office`.`addr2`, `Office`.`considerations`, `Office`.`tel`, `Office`.`email`, `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`.`id` = 4 AND `Office`.`is_delete` = '0' ORDER BY `Office`.`id` ASC LIMIT 1
1
1
0
SELECT `Prefecture`.`id`, `Prefecture`.`region_id`, `Prefecture`.`name`, `Prefecture`.`kana`, `Prefecture`.`code`, `Prefecture`.`order_num`, `Prefecture`.`is_open`, `Prefecture`.`is_hide`, `Prefecture`.`is_delete`, `Prefecture`.`editor_id`, `Prefecture`.`creater_id`, `Prefecture`.`modified`, `Prefecture`.`created` FROM `rensapo_db`.`prefectures` AS `Prefecture` WHERE `Prefecture`.`id` = 46 AND `Prefecture`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `Area`.`id`, `Area`.`region_id`, `Area`.`prefecture_id`, `Area`.`name`, `Area`.`kana`, `Area`.`code`, `Area`.`order_num`, `Area`.`is_open`, `Area`.`is_hide`, `Area`.`is_delete`, `Area`.`editor_id`, `Area`.`creater_id`, `Area`.`modified`, `Area`.`created` FROM `rensapo_db`.`areas` AS `Area` WHERE `Area`.`id` = 1669 AND `Area`.`is_delete` = '0' LIMIT 1
1
1
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` = 17 AND `CarClass`.`is_delete` = '0' ORDER BY `CarClass`.`id` ASC LIMIT 1
0
0
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` = 17 AND `OptionHabtm`.`is_delete` = '0' ORDER BY `OptionHabtm`.`id` ASC
8
8
2
maybe slow
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 34 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 31 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 42 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 41 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 16 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 44 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 46 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `OptionStock`.`option_id`, MIN(OptionStock.stock - OptionStock.reserve + OptionStock.cancel) as OptionStock__min_rest FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = 45 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2025-07-03' AND '2025-07-03' AND `OptionStock`.`is_delete` = '0' GROUP BY `OptionStock`.`option_id` LIMIT 1
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 34 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (34)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 31 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (31)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 42 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (42)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 41 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (41)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 16 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (16)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 44 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (44)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 46 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (46)
0
0
0
SELECT `Option`.`id`, `Option`.`corp_id`, `Option`.`office_id`, `Option`.`name`, `Option`.`abbreviation`, `Option`.`remarks`, `Option`.`lease_type`, `Option`.`price1`, `Option`.`price2`, `Option`.`price3`, `Option`.`price4`, `Option`.`price5`, `Option`.`price6`, `Option`.`price_add`, `Option`.`unit`, `Option`.`max_lease`, `Option`.`is_stock`, `Option`.`order_num`, `Option`.`is_open`, `Option`.`is_hide`, `Option`.`is_delete`, `Option`.`editor_id`, `Option`.`creater_id`, `Option`.`modified`, `Option`.`created` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`id` = 45 AND `Option`.`is_delete` = '0' LIMIT 1
1
1
0
SELECT `OptionStock`.`id`, `OptionStock`.`option_id`, `OptionStock`.`office_id`, `OptionStock`.`date`, `OptionStock`.`stock`, `OptionStock`.`reserve`, `OptionStock`.`cancel`, `OptionStock`.`is_stop`, `OptionStock`.`is_delete`, `OptionStock`.`editor_id`, `OptionStock`.`creater_id`, `OptionStock`.`modified`, `OptionStock`.`created`, (`OptionStock`.`stock` - `OptionStock`.`reserve` + `OptionStock`.`cancel`) AS `OptionStock__rest`, (0) AS `OptionStock__min_rest` FROM `rensapo_db`.`option_stocks` AS `OptionStock` WHERE `OptionStock`.`option_id` = (45)
0
0
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` = '17' AND `PricePatternDay`.`date` = '2025-07-03' LIMIT 1
1
1
52
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` = '17' AND `PricePatternDay`.`date` = '2025-07-03' LIMIT 1
1
1
45
maybe slow
SELECT `CarClass`.`indemnity_price` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `id` = 17 AND `CarClass`.`is_delete` = '0' LIMIT 1
0
0
0
SELECT `Option`.`id`, `Option`.`name` FROM `rensapo_db`.`options` AS `Option` WHERE `Option`.`is_delete` = '0' ORDER BY `Option`.`order_num` ASC
10
10
0
SELECT `CarType`.`id`, `CarType`.`name` FROM `rensapo_db`.`car_types` AS `CarType` WHERE `CarType`.`is_delete` = '0' ORDER BY `CarType`.`id` ASC
20
20
0
SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `rensapo_db`.`prefectures` AS `Prefecture` WHERE `Prefecture`.`is_delete` = '0' ORDER BY `Prefecture`.`id` ASC
47
47
0
1 duplicate queries run.
Query Explain:
Click an "Explain" link above, to see the query explanation.