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`.`id` = 4 AND `Office`.`is_delete` = '0' ORDER BY `Office`.`id` ASC LIMIT 1 | 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 `CarClass`.`id`, `CarClass`.`name`, `CarClass`.`close_base`, `CarClass`.`close_time`, `CarClass`.`close_type` FROM `rensapo_db`.`car_classes` AS `CarClass` WHERE `CarClass`.`id` = 37 AND `CarClass`.`is_delete` = '0' ORDER BY `CarClass`.`id` ASC LIMIT 1 | 1 | 1 | 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 `Car`.`id`, `Car`.`car_class_id`, `Car`.`office_id` FROM `rensapo_db`.`cars` AS `Car` WHERE ((((`Car`.`period_start` <= '2024-11-22') AND (`Car`.`period_end` > '2024-11-22'))) OR (((`Car`.`period_start` < '2024-11-22') AND (`Car`.`period_end` >= '2024-11-22'))) OR (((`Car`.`period_start` >= '2024-11-22') AND (`Car`.`period_end` <= '2024-11-22')))) AND `Car`.`office_id` = 4 AND `Car`.`car_class_id` = 37 AND `Car`.`is_open` = '1' AND `Car`.`is_delete` = '0' ORDER BY `Car`.`order_num` ASC | 1 | 1 | 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-11-22') AND (`CarOperation`.`end_date` > '2024-11-21 23:00:00'))) OR (((`CarOperation`.`start_date` < '2024-11-23 03:00:00') AND (`CarOperation`.`end_date` >= '2024-11-22'))) OR (((`CarOperation`.`start_date` >= '2024-11-22') AND (`CarOperation`.`end_date` <= '2024-11-22')))) AND `CarOperation`.`car_id` = (166) AND `CarOperation`.`is_delete` = '0' ORDER BY `CarOperation`.`id` ASC | 1 | 1 | 1 | |
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` = 37 AND `CarClass`.`is_delete` = '0' ORDER BY `CarClass`.`id` ASC LIMIT 1 | 1 | 1 | 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` = 37 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` = 46 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2024-11-22' AND '2024-11-22' 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 '2024-11-22' AND '2024-11-22' 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` = 47 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2024-11-22' AND '2024-11-22' 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 '2024-11-22' AND '2024-11-22' 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 '2024-11-22' AND '2024-11-22' 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 '2024-11-22' AND '2024-11-22' 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` = 34 AND `OptionStock`.`office_id` = 4 AND `OptionStock`.`date` BETWEEN '2024-11-22' AND '2024-11-22' 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 '2024-11-22' AND '2024-11-22' 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` = 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 `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` = 47 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` = (47) | 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` = 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` = 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` = 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 `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-11-22' LIMIT 1 | 1 | 1 | 71 | 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-11-22' LIMIT 1 | 1 | 1 | 65 | 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 `Car`.`id`, `Car`.`car_class_id`, `Car`.`img_path1`, `Car`.`img_path2`, `Car`.`img_path3` FROM `rensapo_db`.`cars` AS `Car` WHERE ((`Car`.`img_path1` <> '') OR (`Car`.`img_path2` <> '') OR (`Car`.`img_path3` <> '')) AND `Car`.`car_class_id` = 37 AND `Car`.`is_open` = '1' AND `Car`.`is_hide` = '0' AND `Car`.`is_delete` = '0' ORDER BY `Car`.`id` DESC | 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 | 19 | 19 | 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.