Notice (8): Undefined index: RsrCarClass [APP/Controller/PrefecturesController.php, line 1274]Code Context        $this->RsrCarClass->dbConnManualSwitchRensapo($db_list[T_DB_TYPE_RENSAPO_RESERVE]);
        $dataCarClass = $this->RsrCarClass->find('first', $condition);
        $RsrCarClass = $dataCarClass['RsrCarClass'];
$plan_id = '1186'
$class_id = '1190'
$car_national_search_plan = array(
	'CarNationalSearchPlan' => array(
		'id' => '621',
		'rensapo_office_id' => '266',
		'rensapo_class_id' => '1190',
		'rensapo_car_type_id' => '17',
		'rensapo_plan_id' => '1186',
		'rensapo_brand_id' => '80',
		'car_brand_id' => '140',
		'car_office_id' => '393',
		'tabinfo_id' => '5',
		'car_brand_name' => 'ホンダレンタリース北海道',
		'car_brand_code' => 'hodarent_hokkaido',
		'class_name' => 'グレイスハイブリッド【トップシーズン】',
		'car_type_name' => 'ハイブリッド',
		'plan_name' => '【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド',
		'car_max_member' => null,
		'reference_car_name' => null,
		'car_plan_price_type' => '1',
		'smoke_type' => '1',
		'car_plan_memo' => '<p>基本料金に「免責補償」と「JAFサポート」が込！万が一のリスクは極力避けたい、我こそは慎重派！という方へおすすめ。</p>
',
		'car_plan_image_path' => '/img/upload/car_plan/1186_detail.jpg',
		'sales_start_date' => null,
		'sales_end_date' => null,
		'close_reservation_type' => '1',
		'close_reservation_time' => '0',
		'rensapo_office_name' => '札幌駅前ANAクラウンプラザホテル札幌店',
		'has_stock_office' => '0',
		'stock_office_id' => null,
		'rensapo_office_tel' => '011-241-4500',
		'cmn_pref_id' => '1',
		'car_area_id' => '-1',
		'car_class_cc' => '1500',
		'car_special_ids' => null,
		'car_option_search_ids' => null,
		'car_class_model_memo' => 'グレイスハイブリッド',
		'car_designation_type' => '1',
		'plan_open_type' => '1',
		'open_type' => '1',
		'delete_type' => '0',
		'created' => '2024-02-02 19:20:19',
		'modified' => '2024-08-29 15:40:28',
		'author' => null,
		'editor' => null
	)
)
$search = array(
	'prefecture_id' => '',
	'dep_date' => '2025-07-03',
	'arv_date' => '2025-07-03',
	'dep_time' => '09:00',
	'arv_time' => '17:00',
	'type_id' => ''
)
$data = array(
	'CarBrand' => array(
		'id' => '140',
		'car_brand_name' => 'ホンダレンタリース北海道',
		'car_brand_name_en' => null,
		'car_brand_name_cnh' => null,
		'car_brand_name_cnk' => null,
		'car_brand_name_ko' => null,
		'car_brand_name_kana' => 'ほんだれんたりーすほっかいどう',
		'car_brand_code' => 'hodarent_hokkaido',
		'cmn_pref_ids' => '1',
		'contact_tel' => '',
		'car_brand_logo_image_path' => '/img/upload/car_brand/hodarent_hokkaido.png',
		'car_brand_image1_path' => '',
		'car_brand_image2_path' => '',
		'car_brand_movie_url' => '',
		'car_brand_movie_url_en' => null,
		'car_brand_movie_url_cnh' => null,
		'car_brand_movie_url_cnk' => null,
		'car_brand_movie_url_ko' => null,
		'car_brand_memo1' => 'ホンダレンタリース北海道です。',
		'car_brand_cancel_policy' => '<table class="table">
<tbody><tr>
<th>ご利用日の7日前</th>
<td>無 料</td>
</tr>
<tr>
<th>3～6日前</th>
<td>基本料金の20%</td>
</tr>
<tr>
<th>2日前～前日</th>
<td>基本料金の30%</td>
</tr>
<tr>
<th>当日</th>
<td>基本料金の50%</td>
</tr>
</tbody></table>',
		'car_brand_guarantee_system' => '<table class="table">
<tbody><tr>
<th>対人補償</th>
<td>無制限（1名限度額）</td>
</tr>
<tr>
<th>対物補償</th>
<td>無制限（免責15万円）</td>
</tr>
<tr>
<th>車両補償</th>
<td>時価額（免責10万円）</td>
</tr>
<tr>
<th>人身傷害</th>
<td>1名につき3,000万円</td>
</tr>
</tbody></table>
<p>※保険の免責金額および給付される保険金を超える損害額はお客様のご負担となります。<br>
※保険契約の免責事項に該当する事故の場合、保険金は給付されません。また、警察の事故証明がない場合、保険金が給付されない場合もございます。</p>',
		'car_brand_memo1_en' => null,
		'car_brand_memo1_cnh' => null,
		'car_brand_memo1_cnk' => null,
		'car_brand_memo1_ko' => null,
		'car_brand_reservation_code' => 'HRH',
		'rensapo_type' => '2',
		'rensapo_brand_id' => '80',
		'rensapo_office_id' => '0',
		'rensapo_url' => '',
		'linked_rensapo_M' => '1',
		'has_communication_tool' => '1',
		'point_give_type' => '2',
		'search_open_type' => '0',
		'sort' => '127',
		'is_jtb' => null,
		'jtb_sort' => '1',
		'jtb_open_type' => '1',
		'national_open_type' => '1',
		'open_type' => '0',
		'delete_type' => '0',
		'modified' => '2025-06-05 18:20:06',
		'created' => '2023-12-26 10:53:13',
		'editor' => '1',
		'author' => '1'
	),
	'ViewPlan' => array(
		'rensapo_office_id' => '266',
		'rensapo_class_id' => '1190',
		'rensapo_plan_id' => '1186',
		'pickup_flags' => array(
			'flg_pickup_airport_national' => '0'
		)
	)
)
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$national_search_plan = array(
	'id' => '621',
	'rensapo_office_id' => '266',
	'rensapo_class_id' => '1190',
	'rensapo_car_type_id' => '17',
	'rensapo_plan_id' => '1186',
	'rensapo_brand_id' => '80',
	'car_brand_id' => '140',
	'car_office_id' => '393',
	'tabinfo_id' => '5',
	'car_brand_name' => 'ホンダレンタリース北海道',
	'car_brand_code' => 'hodarent_hokkaido',
	'class_name' => 'グレイスハイブリッド【トップシーズン】',
	'car_type_name' => 'ハイブリッド',
	'plan_name' => '【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド',
	'car_max_member' => null,
	'reference_car_name' => null,
	'car_plan_price_type' => '1',
	'smoke_type' => '1',
	'car_plan_memo' => '<p>基本料金に「免責補償」と「JAFサポート」が込！万が一のリスクは極力避けたい、我こそは慎重派！という方へおすすめ。</p>
',
	'car_plan_image_path' => '/img/upload/car_plan/1186_detail.jpg',
	'sales_start_date' => null,
	'sales_end_date' => null,
	'close_reservation_type' => '1',
	'close_reservation_time' => '0',
	'rensapo_office_name' => '札幌駅前ANAクラウンプラザホテル札幌店',
	'has_stock_office' => '0',
	'stock_office_id' => null,
	'rensapo_office_tel' => '011-241-4500',
	'cmn_pref_id' => '1',
	'car_area_id' => '-1',
	'car_class_cc' => '1500',
	'car_special_ids' => null,
	'car_option_search_ids' => null,
	'car_class_model_memo' => 'グレイスハイブリッド',
	'car_designation_type' => '1',
	'plan_open_type' => '1',
	'open_type' => '1',
	'delete_type' => '0',
	'created' => '2024-02-02 19:20:19',
	'modified' => '2024-08-29 15:40:28',
	'author' => null,
	'editor' => null
)
$condition = array(
	'fields' => array(
		(int) 0 => 'RsrCarClass.car_class_name',
		(int) 1 => 'RsrCarClass.car_max_member',
		(int) 2 => 'RsrCarClass.car_type_id',
		(int) 3 => 'RsrCarClass.car_smoke_type',
		(int) 4 => 'RsrCarClass.car_class_model_memo'
	),
	'conditions' => array(
		'RsrCarClass.id' => '1190',
		'RsrCarClass.delete_type' => (int) 0
	),
	'order' => array(
		(int) 0 => 'RsrCarClass.id ASC'
	),
	'contain' => false
)
$dataCarClass = array()
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1274
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

Notice (8): Undefined index: RsrCarPlanLocation [APP/Controller/PrefecturesController.php, line 1700]Code Context                ,'RsrCarPlanLocation.delete_type'=>DELETE_TYPE_OFF)
        ));
        $car_location_start_id = $car_plan_locations['RsrCarPlanLocation']['car_location_start'];
$car_plan_id = '1186'
$brand_id = '140'
$office_id = '266'
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$car_plan_locations = array()
PrefecturesController::get_car_location() - APP/Controller/PrefecturesController.php, line 1700
PrefecturesController::getOfficeList() - APP/Controller/PrefecturesController.php, line 1623
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1326
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

Notice (8): Undefined index: RsrCarPlanLocation [APP/Controller/PrefecturesController.php, line 1721]Code Context            ,'order'=>'RsrCarLocation.car_location_office_type, RsrCarOffice.id, RsrCarOffice.sort, RsrCarOffice.car_office_name, RsrCarLocation.car_location_name'
        ));
        $car_plan_location_id = $car_plan_locations['RsrCarPlanLocation']['id'];
$car_plan_id = '1186'
$brand_id = '140'
$office_id = '266'
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$car_plan_locations = array()
$car_location_start_id = null
$car_start_locations = array()
PrefecturesController::get_car_location() - APP/Controller/PrefecturesController.php, line 1721
PrefecturesController::getOfficeList() - APP/Controller/PrefecturesController.php, line 1623
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1326
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

Notice (8): Undefined index: RsrCarLocation [APP/Controller/PrefecturesController.php, line 1722]Code Context        ));
        $car_plan_location_id = $car_plan_locations['RsrCarPlanLocation']['id'];
        $car_location_start_id = $car_start_locations['RsrCarLocation']['id'];
$car_plan_id = '1186'
$brand_id = '140'
$office_id = '266'
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$car_plan_locations = array()
$car_location_start_id = null
$car_start_locations = array()
$car_plan_location_id = null
PrefecturesController::get_car_location() - APP/Controller/PrefecturesController.php, line 1722
PrefecturesController::getOfficeList() - APP/Controller/PrefecturesController.php, line 1623
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1326
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

Notice (8): Undefined index: RsrCarOffice [APP/Controller/PrefecturesController.php, line 1723]Code Context        $car_plan_location_id = $car_plan_locations['RsrCarPlanLocation']['id'];
        $car_location_start_id = $car_start_locations['RsrCarLocation']['id'];
        $car_location_start_office_id = $car_start_locations['RsrCarOffice']['id'];
$car_plan_id = '1186'
$brand_id = '140'
$office_id = '266'
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$car_plan_locations = array()
$car_location_start_id = null
$car_start_locations = array()
$car_plan_location_id = null
PrefecturesController::get_car_location() - APP/Controller/PrefecturesController.php, line 1723
PrefecturesController::getOfficeList() - APP/Controller/PrefecturesController.php, line 1623
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1326
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

Notice (8): Undefined index: RsrCarOffice [APP/Controller/PrefecturesController.php, line 1726]Code Context        $listShop=array();
        $listShopE = array();
        $listShop['営業所'][$car_location_start_id.'_'.$car_location_start_office_id] = $car_start_locations['RsrCarOffice']['car_office_name'];
$car_plan_id = '1186'
$brand_id = '140'
$office_id = '266'
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$car_plan_locations = array()
$car_location_start_id = null
$car_start_locations = array()
$car_plan_location_id = null
$car_location_start_office_id = null
$listShop = array()
$listShopE = array()
PrefecturesController::get_car_location() - APP/Controller/PrefecturesController.php, line 1726
PrefecturesController::getOfficeList() - APP/Controller/PrefecturesController.php, line 1623
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1326
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

Notice (8): Undefined index: RsrCarOffice [APP/Controller/PrefecturesController.php, line 1728]Code Context        $listShop['営業所'][$car_location_start_id.'_'.$car_location_start_office_id] = $car_start_locations['RsrCarOffice']['car_office_name'];
        // 現状、返却場所は出発場所と同じ
        $listShopE['営業所'][$car_location_start_id.'_'.$car_location_start_office_id.'_'.$car_plan_location_id] = $car_start_locations['RsrCarOffice']['car_office_name'];
$car_plan_id = '1186'
$brand_id = '140'
$office_id = '266'
$db_list = array(
	(int) 2 => array(
		'password' => '*****',
		'login' => '*****',
		'host' => '*****',
		'database' => '*****',
		'type' => '2'
	)
)
$car_plan_locations = array()
$car_location_start_id = null
$car_start_locations = array()
$car_plan_location_id = null
$car_location_start_office_id = null
$listShop = array(
	'営業所' => array(
		'_' => null
	)
)
$listShopE = array()
PrefecturesController::get_car_location() - APP/Controller/PrefecturesController.php, line 1728
PrefecturesController::getOfficeList() - APP/Controller/PrefecturesController.php, line 1623
PrefecturesController::detail_reserve_set_plan_data() - APP/Controller/PrefecturesController.php, line 1326
PrefecturesController::plan() - APP/Controller/PrefecturesController.php, line 1173
PrefecturesController::index() - APP/Controller/PrefecturesController.php, line 151
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - /home/web-staff/public_html/index.php, line 210

ホンダレンタリース北海道の「【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド」（札幌駅前ANAクラウンプラザホテル札幌店）｜たびんふぉ

【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド

車両タイプ：ハイブリッド
車両クラス：[定員名]
代表車種：など

基本料金に「免責補償」と「JAFサポート」が込！万が一のリスクは極力避けたい、我こそは慎重派！という方へおすすめ。

レンタカーご予約内容

レンタカー会社: ホンダレンタリース北海道

出発

出発日時

出発場所

返却

返却日時

返却場所

台数

車両クラス：[定員名]
代表車種：など

1台

予約に関するご案内

キャンセルポリシー

ご利用日の7日前	無料
3～6日前	基本料金の20%
2日前～前日	基本料金の30%
当日	基本料金の50%

補償制度

対人補償	無制限（1名限度額）
対物補償	無制限（免責15万円）
車両補償	時価額（免責10万円）
人身傷害	1名につき3,000万円

※保険の免責金額および給付される保険金を超える損害額はお客様のご負担となります。
※保険契約の免責事項に該当する事故の場合、保険金は給付されません。また、警察の事故証明がない場合、保険金が給付されない場合もございます。

ご予約お見積り

レンタカー会社: ホンダレンタリース北海道
出発
返却

台数: 1台 ---円

合計料金: ---円 (税込)

History
+
Request History
1 previous requests available
- Restore to current request
- hokkaido/hodarent_hokkaido/plan/621
====
Session
+
Session
- Config
  userAgentaf109b8469d612bfcc3d94a521fbc15f
  time1751278028
  countdown10
- uniqid_token6862298cc04bb
- plan_info
  CarBrand
  id140
  car_brand_nameホンダレンタリース北海道
  car_brand_name_en(null)
  car_brand_name_cnh(null)
  car_brand_name_cnk(null)
  car_brand_name_ko(null)
  car_brand_name_kanaほんだれんたりーすほっかいどう
  car_brand_codehodarent_hokkaido
  cmn_pref_ids1
  contact_tel
  car_brand_logo_image_path/img/upload/car_brand/hodarent_hokkaido.png
  car_brand_image1_path
  car_brand_image2_path
  car_brand_movie_url
  car_brand_movie_url_en(null)
  car_brand_movie_url_cnh(null)
  car_brand_movie_url_cnk(null)
  car_brand_movie_url_ko(null)
  car_brand_memo1ホンダレンタリース北海道です。
  car_brand_cancel_policy<table class="table"> <tbody><tr> <th>ご利用日の7日前</th> <td>無料</td> </tr> <tr> <th>3～6日前</th> <td>基本料金の20%</td> </tr> <tr> <th>2日前～前日</th> <td>基本料金の30%</td> </tr> <tr> <th>当日</th> <td>基本料金の50%</td> </tr> </tbody></table>
  car_brand_guarantee_system<table class="table"> <tbody><tr> <th>対人補償</th> <td>無制限（1名限度額）</td> </tr> <tr> <th>対物補償</th> <td>無制限（免責15万円）</td> </tr> <tr> <th>車両補償</th> <td>時価額（免責10万円）</td> </tr> <tr> <th>人身傷害</th> <td>1名につき3,000万円</td> </tr> </tbody></table> <p>※保険の免責金額および給付される保険金を超える損害額はお客様のご負担となります。<br> ※保険契約の免責事項に該当する事故の場合、保険金は給付されません。また、警察の事故証明がない場合、保険金が給付されない場合もございます。</p>
  car_brand_memo1_en(null)
  car_brand_memo1_cnh(null)
  car_brand_memo1_cnk(null)
  car_brand_memo1_ko(null)
  car_brand_reservation_codeHRH
  rensapo_type2
  rensapo_brand_id80
  rensapo_office_id0
  rensapo_url
  linked_rensapo_M1
  has_communication_tool1
  point_give_type2
  search_open_type0
  sort127
  is_jtb(null)
  jtb_sort1
  jtb_open_type1
  national_open_type1
  open_type0
  delete_type0
  modified2025-06-05 18:20:06
  created2023-12-26 10:53:13
  editor1
  author1
  ViewPlan
  rensapo_office_id266
  rensapo_class_id1190
  rensapo_plan_id1186
  pickup_flags
  flg_pickup_airport_national0
  plan_name【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド
  car_plan_memo<p>基本料金に「免責補償」と「JAFサポート」が込！万が一のリスクは極力避けたい、我こそは慎重派！という方へおすすめ。</p>
  class_name(null)
  office_name札幌駅前ANAクラウンプラザホテル札幌店
  car_max_member(null)
  reference_car_name(null)
  smoke_type(null)
  plan_imghttps://car-rental.jp/img/upload/car_plan/1186_detail.jpg
  car_brand_logo_image_pathhttps://www.tabinfo.jp/img/upload/car_brand/hodarent_hokkaido.png
  car_type_id17
  car_type_nameハイブリッド
  hito2
  bag2
  listOffice
  営業所
  _(null)
  listOfficeE
  営業所
  __(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerPrefectures
- actionindex
- named(empty)
- pass
  0hokkaido
  1hodarent_hokkaido
  2plan
  3621
Post data
- Action
  prefecture_id
  dep_date2025-07-03
  arv_date2025-07-03
  dep_time09:00
  arv_time17:00
  type_id
Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults
  controllerPrefectures
  actionindex
  plugin(null)
- template/*
====

Sqllog

Sql Logs

default

Total Time: 12 ms
Total Queries: 34 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code`, `CmnPref`.`cmn_pref_image_path` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` WHERE `CmnPref`.`cmn_pref_code` = 'hokkaido' AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 LIMIT 1	1	1	0
SELECT `KuchikomiRankNational`.`created` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1	1	1	0
SELECT `Kuchikomi`.`cmn_pref_id`, `Kuchikomi`.`area_div`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`car_office_id`, AVG(`Kuchikomi`.`rating_overall`) as Kuchikomi__avg_rating_overall, AVG(`Kuchikomi`.`rating_service`) as Kuchikomi__avg_rating_service, AVG(`Kuchikomi`.`rating_shop`) as Kuchikomi__avg_rating_shop, AVG(`Kuchikomi`.`rating_car`) as Kuchikomi__avg_rating_car, AVG(`Kuchikomi`.`rating_cost`) as Kuchikomi__avg_rating_cost, AVG(`Kuchikomi`.`rating_smooth`) as Kuchikomi__avg_rating_smooth, SUM(`Kuchikomi`.`helpful_count`) as Kuchikomi__sum_helpful_count, COUNT(`Kuchikomi`.`id`) as Kuchikomi__count_kuchikomi_count FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`Kuchikomi`.`car_brand_id` = `CarBrand`.`id`) LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`Kuchikomi`.`cmn_pref_id` = `CmnPref`.`id`) WHERE `Kuchikomi`.`is_display` = 1 AND `Kuchikomi`.`cmn_pref_id` = 1 AND `CarBrand`.`national_open_type` = 1 GROUP BY `Kuchikomi`.`cmn_pref_id`, `Kuchikomi`.`car_brand_id`, `Kuchikomi`.`car_brand_code` ORDER BY `Kuchikomi__avg_rating_overall` DESC	1	1	0
SELECT `KuchikomiRankNational`.`id` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`KuchikomiRankNational`.`car_brand_id` = `CarBrand`.`id`) WHERE `KuchikomiRankNational`.`is_delete` = 0 AND `KuchikomiRankNational`.`cmn_pref_id` = 1	1	1	0
DELETE `KuchikomiRankNational` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`id` = (138718)	1	1	4	maybe slow
INSERT INTO `tabinfo_rentacar`.`kuchikomi_rank_nationals` (`ranking_no`, `helpful_count`, `kuchikomi_count`, `rating_overall`, `rating_service`, `rating_shop`, `rating_car`, `rating_cost`, `rating_smooth`, `is_delete`, `cmn_pref_id`, `car_brand_id`, `car_brand_code`, `car_office_id`, `created`) VALUES (1, 39, 1, 4.119999885559082, 4, 3, 4.400000095367432, 4.599999904632568, 4.599999904632568, 0, 1, 102, 'hdcrentacar', 330, '2025-06-30 15:07:00')	1	1	3	maybe slow
SELECT `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'hodarent_hokkaido' AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1	1	1	0
SELECT `CarMaker`.`car_maker_code`, `CarMaker`.`id`, `CarMaker`.`car_maker_name` FROM `tabinfo_rentacar`.`car_makers` AS `CarMaker` WHERE `CarMaker`.`car_maker_code` = 'hodarent_hokkaido' AND FIND_IN_SET('1', CarMaker.cmn_pref_ids) AND `CarMaker`.`delete_type` = 0 AND `CarMaker`.`open_type` = 1 LIMIT 1	0	0	0
SELECT `CarSpecial`.`id`, `CarSpecial`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`car_special_code` = 'hodarent_hokkaido' AND FIND_IN_SET('1', CarSpecial.cmn_pref_ids) AND `CarSpecial`.`national_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 LIMIT 1	0	0	0
SELECT `CarNationalSearchPlan`.`id` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`id` = 621 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1	1	1	0
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/hokkaido/hodarent_hokkaido/plan/621/' AND `delete_type` = 0 LIMIT 1	0	0	0
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '///plan/*/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` IS NULL)) LIMIT 1	1	1	0
SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_name_en`, `CarBrand`.`car_brand_name_cnh`, `CarBrand`.`car_brand_name_cnk`, `CarBrand`.`car_brand_name_ko`, `CarBrand`.`car_brand_name_kana`, `CarBrand`.`car_brand_code`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`contact_tel`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`car_brand_image1_path`, `CarBrand`.`car_brand_image2_path`, `CarBrand`.`car_brand_movie_url`, `CarBrand`.`car_brand_movie_url_en`, `CarBrand`.`car_brand_movie_url_cnh`, `CarBrand`.`car_brand_movie_url_cnk`, `CarBrand`.`car_brand_movie_url_ko`, `CarBrand`.`car_brand_memo1`, `CarBrand`.`car_brand_cancel_policy`, `CarBrand`.`car_brand_guarantee_system`, `CarBrand`.`car_brand_memo1_en`, `CarBrand`.`car_brand_memo1_cnh`, `CarBrand`.`car_brand_memo1_cnk`, `CarBrand`.`car_brand_memo1_ko`, `CarBrand`.`car_brand_reservation_code`, `CarBrand`.`rensapo_type`, `CarBrand`.`rensapo_brand_id`, `CarBrand`.`rensapo_office_id`, `CarBrand`.`rensapo_url`, `CarBrand`.`linked_rensapo_M`, `CarBrand`.`has_communication_tool`, `CarBrand`.`point_give_type`, `CarBrand`.`search_open_type`, `CarBrand`.`sort`, `CarBrand`.`is_jtb`, `CarBrand`.`jtb_sort`, `CarBrand`.`jtb_open_type`, `CarBrand`.`national_open_type`, `CarBrand`.`open_type`, `CarBrand`.`delete_type`, `CarBrand`.`modified`, `CarBrand`.`created`, `CarBrand`.`editor`, `CarBrand`.`author` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'hodarent_hokkaido' AND NOT (`CarBrand`.`rensapo_type` = 0) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1	1	1	0
SELECT `CarDatabase`.`id`, `CarDatabase`.`car_brand_id`, `CarDatabase`.`type`, `CarDatabase`.`host`, `CarDatabase`.`database_name`, `CarDatabase`.`login_username`, `CarDatabase`.`login_password`, `CarDatabase`.`delete_type`, `CarDatabase`.`modified`, `CarDatabase`.`created`, `CarDatabase`.`editor`, `CarDatabase`.`author` FROM `tabinfo_rentacar`.`car_databases` AS `CarDatabase` WHERE `CarDatabase`.`delete_type` = 0 AND `CarDatabase`.`car_brand_id` = (140)	1	1	0
SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` WHERE `id` = 621 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1	1	1	0
SELECT `CarOffice`.`flg_pickup_airport_national` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 393 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 LIMIT 1	1	1	0
SELECT `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 140 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1	1	1	0
SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_name_en`, `CarBrand`.`car_brand_name_cnh`, `CarBrand`.`car_brand_name_cnk`, `CarBrand`.`car_brand_name_ko`, `CarBrand`.`car_brand_name_kana`, `CarBrand`.`car_brand_code`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`contact_tel`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`car_brand_image1_path`, `CarBrand`.`car_brand_image2_path`, `CarBrand`.`car_brand_movie_url`, `CarBrand`.`car_brand_movie_url_en`, `CarBrand`.`car_brand_movie_url_cnh`, `CarBrand`.`car_brand_movie_url_cnk`, `CarBrand`.`car_brand_movie_url_ko`, `CarBrand`.`car_brand_memo1`, `CarBrand`.`car_brand_cancel_policy`, `CarBrand`.`car_brand_guarantee_system`, `CarBrand`.`car_brand_memo1_en`, `CarBrand`.`car_brand_memo1_cnh`, `CarBrand`.`car_brand_memo1_cnk`, `CarBrand`.`car_brand_memo1_ko`, `CarBrand`.`car_brand_reservation_code`, `CarBrand`.`rensapo_type`, `CarBrand`.`rensapo_brand_id`, `CarBrand`.`rensapo_office_id`, `CarBrand`.`rensapo_url`, `CarBrand`.`linked_rensapo_M`, `CarBrand`.`has_communication_tool`, `CarBrand`.`point_give_type`, `CarBrand`.`search_open_type`, `CarBrand`.`sort`, `CarBrand`.`is_jtb`, `CarBrand`.`jtb_sort`, `CarBrand`.`jtb_open_type`, `CarBrand`.`national_open_type`, `CarBrand`.`open_type`, `CarBrand`.`delete_type`, `CarBrand`.`modified`, `CarBrand`.`created`, `CarBrand`.`editor`, `CarBrand`.`author` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `id` = 140 AND `delete_type` = 0 LIMIT 1	1	1	0
SELECT `CarDatabase`.`id`, `CarDatabase`.`car_brand_id`, `CarDatabase`.`type`, `CarDatabase`.`host`, `CarDatabase`.`database_name`, `CarDatabase`.`login_username`, `CarDatabase`.`login_password`, `CarDatabase`.`delete_type`, `CarDatabase`.`modified`, `CarDatabase`.`created`, `CarDatabase`.`editor`, `CarDatabase`.`author` FROM `tabinfo_rentacar`.`car_databases` AS `CarDatabase` WHERE `CarDatabase`.`delete_type` = 0 AND `CarDatabase`.`car_brand_id` = (140)	1	1	0
SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (140)	2	2	0
SELECT `CarNationalSearchPlan`.`id`, `CarNationalSearchPlan`.`rensapo_office_id`, `CarNationalSearchPlan`.`rensapo_class_id`, `CarNationalSearchPlan`.`rensapo_car_type_id`, `CarNationalSearchPlan`.`rensapo_plan_id`, `CarNationalSearchPlan`.`rensapo_brand_id`, `CarNationalSearchPlan`.`car_brand_id`, `CarNationalSearchPlan`.`car_office_id`, `CarNationalSearchPlan`.`tabinfo_id`, `CarNationalSearchPlan`.`car_brand_name`, `CarNationalSearchPlan`.`car_brand_code`, `CarNationalSearchPlan`.`class_name`, `CarNationalSearchPlan`.`car_type_name`, `CarNationalSearchPlan`.`plan_name`, `CarNationalSearchPlan`.`car_max_member`, `CarNationalSearchPlan`.`reference_car_name`, `CarNationalSearchPlan`.`car_plan_price_type`, `CarNationalSearchPlan`.`smoke_type`, `CarNationalSearchPlan`.`car_plan_memo`, `CarNationalSearchPlan`.`car_plan_image_path`, `CarNationalSearchPlan`.`sales_start_date`, `CarNationalSearchPlan`.`sales_end_date`, `CarNationalSearchPlan`.`close_reservation_type`, `CarNationalSearchPlan`.`close_reservation_time`, `CarNationalSearchPlan`.`rensapo_office_name`, `CarNationalSearchPlan`.`has_stock_office`, `CarNationalSearchPlan`.`stock_office_id`, `CarNationalSearchPlan`.`rensapo_office_tel`, `CarNationalSearchPlan`.`cmn_pref_id`, `CarNationalSearchPlan`.`car_area_id`, `CarNationalSearchPlan`.`car_class_cc`, `CarNationalSearchPlan`.`car_special_ids`, `CarNationalSearchPlan`.`car_option_search_ids`, `CarNationalSearchPlan`.`car_class_model_memo`, `CarNationalSearchPlan`.`car_designation_type`, `CarNationalSearchPlan`.`plan_open_type`, `CarNationalSearchPlan`.`open_type`, `CarNationalSearchPlan`.`delete_type`, `CarNationalSearchPlan`.`created`, `CarNationalSearchPlan`.`modified`, `CarNationalSearchPlan`.`author`, `CarNationalSearchPlan`.`editor`, `CarOffice`.`id`, `CarOffice`.`car_office_car489_id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_group_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_name_en`, `CarOffice`.`car_office_name_cnh`, `CarOffice`.`car_office_name_cnk`, `CarOffice`.`car_office_name_ko`, `CarOffice`.`car_office_code`, `CarOffice`.`stock_office`, `CarOffice`.`post1`, `CarOffice`.`post2`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`cmn_city_id`, `CarOffice`.`address`, `CarOffice`.`address_en`, `CarOffice`.`address_cnh`, `CarOffice`.`address_cnk`, `CarOffice`.`address_ko`, `CarOffice`.`car_area_id`, `CarOffice`.`distance_airport`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`fax1`, `CarOffice`.`fax2`, `CarOffice`.`fax3`, `CarOffice`.`email`, `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`car_office_map_zoom`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo1_en`, `CarOffice`.`car_office_memo1_cnh`, `CarOffice`.`car_office_memo1_cnk`, `CarOffice`.`car_office_memo1_ko`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo2_en`, `CarOffice`.`car_office_memo2_cnh`, `CarOffice`.`car_office_memo2_cnk`, `CarOffice`.`car_office_memo2_ko`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo3_en`, `CarOffice`.`car_office_memo3_cnh`, `CarOffice`.`car_office_memo3_cnk`, `CarOffice`.`car_office_memo3_ko`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_memo4_en`, `CarOffice`.`car_office_memo4_cnh`, `CarOffice`.`car_office_memo4_cnk`, `CarOffice`.`car_office_memo4_ko`, `CarOffice`.`car_office_memo5`, `CarOffice`.`car_office_memo5_en`, `CarOffice`.`car_office_memo5_cnh`, `CarOffice`.`car_office_memo5_cnk`, `CarOffice`.`car_office_memo5_ko`, `CarOffice`.`car_office_memo6`, `CarOffice`.`car_office_memo6_en`, `CarOffice`.`car_office_memo6_cnh`, `CarOffice`.`car_office_memo6_cnk`, `CarOffice`.`car_office_memo6_ko`, `CarOffice`.`car_office_point1`, `CarOffice`.`car_office_point1_en`, `CarOffice`.`car_office_point1_cnh`, `CarOffice`.`car_office_point1_cnk`, `CarOffice`.`car_office_point1_ko`, `CarOffice`.`car_office_point2`, `CarOffice`.`car_office_point2_en`, `CarOffice`.`car_office_point2_cnh`, `CarOffice`.`car_office_point2_cnk`, `CarOffice`.`car_office_point2_ko`, `CarOffice`.`car_office_point3`, `CarOffice`.`car_office_point3_en`, `CarOffice`.`car_office_point3_cnh`, `CarOffice`.`car_office_point3_cnk`, `CarOffice`.`car_office_point3_ko`, `CarOffice`.`car_office_point4`, `CarOffice`.`car_office_point4_en`, `CarOffice`.`car_office_point4_cnh`, `CarOffice`.`car_office_point4_cnk`, `CarOffice`.`car_office_point4_ko`, `CarOffice`.`cmn_airport_id`, `CarOffice`.`cmn_airport_ids`, `CarOffice`.`cmn_station_id`, `CarOffice`.`cmn_station_ids`, `CarOffice`.`car_office_movie_url`, `CarOffice`.`car_office_movie_url_en`, `CarOffice`.`car_office_movie_url_cnh`, `CarOffice`.`car_office_movie_url_cnk`, `CarOffice`.`car_office_movie_url_ko`, `CarOffice`.`flg_pickup_airport`, `CarOffice`.`flg_pickup_hotel`, `CarOffice`.`flg_pickup_station`, `CarOffice`.`selects_pickup_station`, `CarOffice`.`flg_pickup_harbor`, `CarOffice`.`selects_pickup_harbor`, `CarOffice`.`flg_pickup_airport_national`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CarOffice`.`sort`, `CarOffice`.`open_type`, `CarOffice`.`jtb_sort`, `CarOffice`.`jtb_open_type`, `CarOffice`.`delete_type`, `CarOffice`.`modified`, `CarOffice`.`created`, `CarOffice`.`editor`, `CarOffice`.`author` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 140 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1	629	629	5
SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_code`, `CarBrand`.`car_brand_logo_image_path` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 ORDER BY `sort` DESC LIMIT 5	5	5	0
SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE NOT (`CarBrand`.`rensapo_type` = 0) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 ORDER BY `sort` DESC	38	38	0
SELECT `CarDatabase`.`id`, `CarDatabase`.`car_brand_id`, `CarDatabase`.`type`, `CarDatabase`.`host`, `CarDatabase`.`database_name`, `CarDatabase`.`login_username`, `CarDatabase`.`login_password`, `CarDatabase`.`delete_type`, `CarDatabase`.`modified`, `CarDatabase`.`created`, `CarDatabase`.`editor`, `CarDatabase`.`author` FROM `tabinfo_rentacar`.`car_databases` AS `CarDatabase` WHERE `CarDatabase`.`delete_type` = 0 AND `CarDatabase`.`car_brand_id` IN (163, 117, 118, 145, 120, 144, 142, 140, 139, 128, 116, 150, 151, 154, 153, 99, 102, 103, 104, 105, 106, 107, 135, 64, 134, 136, 127, 124, 137, 138, 87, 95, 123, 122, 109, 119, 108, 132)	46	46	0
SELECT `CarType`.`id`, `CarType`.`car_type_name`, `CarType`.`car_type_code`, `CarType`.`car_type_memo2` FROM `tabinfo_rentacar`.`car_types` AS `CarType` WHERE `CarType`.`delete_type` = 0 AND `CarType`.`open_type` = 1	11	11	0
SELECT `CarOptionSearch`.`id`, `CarOptionSearch`.`car_option_search_name` FROM `tabinfo_rentacar`.`car_option_searches` AS `CarOptionSearch` WHERE `CarOptionSearch`.`open_type` = 1 AND `CarOptionSearch`.`delete_type` = 0 ORDER BY `CarOptionSearch`.`sort` DESC	1	1	0
SELECT `CarSpecial`.`id`, `CarSpecial`.`car_special_search_name` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`national_search_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 ORDER BY `CarSpecial`.`sort` DESC	0	0	0
SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` WHERE `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 ORDER BY `sort` DESC	47	47	0
SELECT `CmnAirportNational`.`id`, `CmnAirportNational`.`cmn_airport_name`, `CmnAirportNational`.`cmn_pref_id` FROM `tabinfo_rentacar`.`cmn_airport_nationals` AS `CmnAirportNational` WHERE `CmnAirportNational`.`delete_type` = 0 AND `CmnAirportNational`.`open_type` = 1 ORDER BY `sort` DESC	74	74	0
SELECT DISTINCT `CmnAirportNational`.`id`, `CmnAirportNational`.`cmn_airport_name`, `CmnAirportNational`.`cmn_airport_code`, COUNT(DISTINCT CmnAirportNational.id) FROM `tabinfo_rentacar`.`cmn_airport_nationals` AS `CmnAirportNational` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (FIND_IN_SET(`CmnAirportNational`.`id`, `CarOffice`.`cmn_airport_ids`) <> 0) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CmnAirportNational`.`cmn_pref_id` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnAirportNational`.`delete_type` = 0 AND `CmnAirportNational`.`open_type` = 1 GROUP BY `CmnAirportNational`.`id` ORDER BY COUNT(*) DESC, `CmnAirportNational`.`id` ASC LIMIT 5	3	3	0
SELECT DISTINCT `CmnStationNational`.`id`, `CmnStationNational`.`cmn_station_name`, `CmnStationNational`.`cmn_station_code`, COUNT() FROM `tabinfo_rentacar`.`cmn_station_nationals` AS `CmnStationNational` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (FIND_IN_SET(`CmnStationNational`.`id`, `CarOffice`.`cmn_station_ids`) <> 0) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CmnStationNational`.`cmn_pref_id` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnStationNational`.`delete_type` = 0 AND `CmnStationNational`.`open_type` = 1 GROUP BY `CmnStationNational`.`id` ORDER BY COUNT() DESC, `CmnStationNational`.`id` ASC LIMIT 5	3	3	0
SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CmnPref`.`id` = `CarOffice`.`cmn_pref_id`) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 GROUP BY `CmnPref`.`cmn_pref_name` ORDER BY `CmnPref`.`id` ASC	27	27	0
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/hokkaido/hodarent_hokkaido/plan/621/' AND `delete_type` = 0 LIMIT 1	0	0	0
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '///plan/*/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` IS NULL)) LIMIT 1	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

change_rensapo_reserve_db

Total Time: 2 ms
Total Queries: 4 queries

Query	Took (ms)	Actions
SELECT `RsrCarClass`.`car_class_name`, `RsrCarClass`.`car_max_member`, `RsrCarClass`.`car_type_id`, `RsrCarClass`.`car_smoke_type`, `RsrCarClass`.`car_class_model_memo` FROM `car_rental_rrs`.`car_classes` AS `RsrCarClass` WHERE `RsrCarClass`.`id` = 1190 AND `RsrCarClass`.`delete_type` = 0 ORDER BY `RsrCarClass`.`id` ASC LIMIT 1	0
SELECT `RsrCarPlanLocation`.`id`, `RsrCarPlanLocation`.`car_location_start` FROM `car_rental_rrs`.`car_plan_locations` AS `RsrCarPlanLocation` WHERE `RsrCarPlanLocation`.`car_plan_id` = 1186 AND `RsrCarPlanLocation`.`car_location_start` = 266 AND `RsrCarPlanLocation`.`car_location_end` = 266 AND NOT (`RsrCarPlanLocation`.`car_location_price` IS NULL) AND `RsrCarPlanLocation`.`delete_type` = 0 LIMIT 1	1	maybe slow
SELECT `RsrCarLocation`.`id`, `RsrCarOffice`.`id`, `RsrCarOffice`.`car_office_name`, `RsrCarOffice`.`car_office_start_time`, `RsrCarOffice`.`car_office_end_time`, `RsrCarOffice`.`stock_office` FROM `car_rental_rrs`.`car_locations` AS `RsrCarLocation` LEFT JOIN `car_rental_rrs`.`car_offices` AS `RsrCarOffice` ON (`RsrCarLocation`.`car_office_id` = `RsrCarOffice`.`id`) WHERE `RsrCarLocation`.`id` IS NULL AND `RsrCarLocation`.`open_type` = 1 AND `RsrCarLocation`.`delete_type` = 0 ORDER BY `RsrCarLocation`.`car_location_office_type` ASC, `RsrCarOffice`.`id` ASC, `RsrCarOffice`.`sort` ASC, `RsrCarOffice`.`car_office_name` ASC, `RsrCarLocation`.`car_location_name` ASC LIMIT 1	0
SELECT `RsrCarPlanOption`.`id`, `RsrCarPlanOption`.`car_plan_id`, `RsrCarPlanOption`.`car_option_id`, `RsrCarPlanOption`.`car_plan_option_type`, `RsrCarPlanOption`.`sort`, `RsrCarPlanOption`.`delete_type`, `RsrCarPlanOption`.`modified`, `RsrCarPlanOption`.`created`, `RsrCarPlanOption`.`editor`, `RsrCarPlanOption`.`author`, `RsrCarOption`.`id`, `RsrCarOption`.`car_brand_id`, `RsrCarOption`.`car_group_id`, `RsrCarOption`.`car_office_id`, `RsrCarOption`.`car_option_type_id`, `RsrCarOption`.`car_option_name`, `RsrCarOption`.`car_option_name_en`, `RsrCarOption`.`car_option_name_cnh`, `RsrCarOption`.`car_option_name_cnk`, `RsrCarOption`.`car_option_name_ko`, `RsrCarOption`.`car_option_sub_name`, `RsrCarOption`.`car_option_sub_name_en`, `RsrCarOption`.`car_option_sub_name_cnh`, `RsrCarOption`.`car_option_sub_name_cnk`, `RsrCarOption`.`car_option_sub_name_ko`, `RsrCarOption`.`car_option_lease_type`, `RsrCarOption`.`car_option_price1`, `RsrCarOption`.`car_option_price2`, `RsrCarOption`.`car_option_price3`, `RsrCarOption`.`car_option_price4`, `RsrCarOption`.`car_option_price5`, `RsrCarOption`.`car_option_price6`, `RsrCarOption`.`car_option_plus_price`, `RsrCarOption`.`car_option_unit`, `RsrCarOption`.`car_option_max_lease`, `RsrCarOption`.`car_option_stock_type`, `RsrCarOption`.`sort`, `RsrCarOption`.`open_type`, `RsrCarOption`.`is_jtb`, `RsrCarOption`.`jtb_sort`, `RsrCarOption`.`jtb_open_type`, `RsrCarOption`.`delete_type`, `RsrCarOption`.`modified`, `RsrCarOption`.`created`, `RsrCarOption`.`editor`, `RsrCarOption`.`author` FROM `car_rental_rrs`.`car_plan_options` AS `RsrCarPlanOption` LEFT JOIN `car_rental_rrs`.`car_options` AS `RsrCarOption` ON (`RsrCarPlanOption`.`car_option_id` = `RsrCarOption`.`id`) WHERE `RsrCarPlanOption`.`car_plan_id` = 1186 AND `RsrCarPlanOption`.`delete_type` = 0 ORDER BY `RsrCarPlanOption`.`id` ASC	1	maybe slow

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 37.18 MB

Message	Memory use
Component initialization	4.20 MB
Controller action start	4.59 MB
Controller render start	10.79 MB
View render complete	12.37 MB

Timers

Total Request Time: 272 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	16.52
Event: Controller.initialize	0.05
Event: Controller.startup	0.18
Controller action	231.09
Event: Controller.beforeRender	2.24
» Processing toolbar data	2.15
Rendering View	5.40
» Event: View.beforeRender	0.04
» Rendering APP/View/Prefectures/plan.ctp	3.89
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.94
» » Rendering APP/View/Elements/analytics.ctp	0.07
» » Rendering APP/View/Elements/pankuzu.ctp	0.16
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- seo
  titleホンダレンタリース北海道の「【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド」（札幌駅前ANAクラウンプラザホテル札幌店）｜たびんふぉ
  keywords
  descriptionホンダレンタリース北海道の「【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド」（札幌駅前ANAクラウンプラザホテル札幌店）の詳細ページ。北海道のレンタカーを比較・予約するなら【たびんふぉ】で。
  h1
  p
- data
  CarBrand
  id140
  car_brand_nameホンダレンタリース北海道
  car_brand_name_en(null)
  car_brand_name_cnh(null)
  car_brand_name_cnk(null)
  car_brand_name_ko(null)
  car_brand_name_kanaほんだれんたりーすほっかいどう
  car_brand_codehodarent_hokkaido
  cmn_pref_ids1
  contact_tel
  car_brand_logo_image_path/img/upload/car_brand/hodarent_hokkaido.png
  car_brand_image1_path
  car_brand_image2_path
  car_brand_movie_url
  car_brand_movie_url_en(null)
  car_brand_movie_url_cnh(null)
  car_brand_movie_url_cnk(null)
  car_brand_movie_url_ko(null)
  car_brand_memo1ホンダレンタリース北海道です。
  car_brand_cancel_policy<table class="table"> <tbody><tr> <th>ご利用日の7日前</th> <td>無料</td> </tr> <tr> <th>3～6日前</th> <td>基本料金の20%</td> </tr> <tr> <th>2日前～前日</th> <td>基本料金の30%</td> </tr> <tr> <th>当日</th> <td>基本料金の50%</td> </tr> </tbody></table>
  car_brand_guarantee_system<table class="table"> <tbody><tr> <th>対人補償</th> <td>無制限（1名限度額）</td> </tr> <tr> <th>対物補償</th> <td>無制限（免責15万円）</td> </tr> <tr> <th>車両補償</th> <td>時価額（免責10万円）</td> </tr> <tr> <th>人身傷害</th> <td>1名につき3,000万円</td> </tr> </tbody></table> <p>※保険の免責金額および給付される保険金を超える損害額はお客様のご負担となります。<br> ※保険契約の免責事項に該当する事故の場合、保険金は給付されません。また、警察の事故証明がない場合、保険金が給付されない場合もございます。</p>
  car_brand_memo1_en(null)
  car_brand_memo1_cnh(null)
  car_brand_memo1_cnk(null)
  car_brand_memo1_ko(null)
  car_brand_reservation_codeHRH
  rensapo_type2
  rensapo_brand_id80
  rensapo_office_id0
  rensapo_url
  linked_rensapo_M1
  has_communication_tool1
  point_give_type2
  search_open_type0
  sort127
  is_jtb(null)
  jtb_sort1
  jtb_open_type1
  national_open_type1
  open_type0
  delete_type0
  modified2025-06-05 18:20:06
  created2023-12-26 10:53:13
  editor1
  author1
  ViewPlan
  rensapo_office_id266
  rensapo_class_id1190
  rensapo_plan_id1186
  pickup_flags
  flg_pickup_airport_national0
  plan_name【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド
  car_plan_memo<p>基本料金に「免責補償」と「JAFサポート」が込！万が一のリスクは極力避けたい、我こそは慎重派！という方へおすすめ。</p>
  class_name(null)
  office_name札幌駅前ANAクラウンプラザホテル札幌店
  car_max_member(null)
  reference_car_name(null)
  smoke_type(null)
  plan_imghttps://car-rental.jp/img/upload/car_plan/1186_detail.jpg
  car_brand_logo_image_pathhttps://www.tabinfo.jp/img/upload/car_brand/hodarent_hokkaido.png
  car_type_id17
  car_type_nameハイブリッド
  hito2
  bag2
  listOffice
  営業所
  _(null)
  listOfficeE
  営業所
  __(null)
- office_time_list
  10:0010:00
  10:3010:30
  11:0011:00
  11:3011:30
  12:0012:00
  12:3012:30
  13:0013:00
  13:3013:30
  14:0014:00
  14:3014:30
  15:0015:00
  15:3015:30
  16:0016:00
  16:3016:30
  17:0017:00
  17:3017:30
  18:0018:00
- rensapo_brand_id80
- uniqid_token6862298cc04bb
- data_airport
  0
  CmnAirportNational
  id11014
  cmn_airport_name新千歳空港
  cmn_airport_codechitose-ap
  0
  COUNT(DISTINCT CmnAirportNational.id)1
  1
  CmnAirportNational
  id11017
  cmn_airport_name函館空港
  cmn_airport_codehakodate-ap
  0
  COUNT(DISTINCT CmnAirportNational.id)1
  2
  CmnAirportNational
  id11018
  cmn_airport_name旭川空港
  cmn_airport_codeasahikawa-ap
  0
  COUNT(DISTINCT CmnAirportNational.id)1
- data_station
  0
  CmnStationNational
  id19747
  cmn_station_name札幌駅
  cmn_station_codesapporo-st
  0
  COUNT(*)1
  1
  CmnStationNational
  id19748
  cmn_station_name函館駅
  cmn_station_codehakodate-st
  0
  COUNT(*)1
  2
  CmnStationNational
  id19840
  cmn_station_name旭川駅
  cmn_station_codeasahikawa-st
  0
  COUNT(*)1
- pref_offices
  0
  CmnPref
  id1
  cmn_pref_name北海道
  cmn_pref_codehokkaido
  1
  CmnPref
  id3
  cmn_pref_name岩手県
  cmn_pref_codeiwate
  2
  CmnPref
  id7
  cmn_pref_name福島県
  cmn_pref_codefukushima
  3
  CmnPref
  id8
  cmn_pref_name茨城県
  cmn_pref_codeibaraki
  4
  CmnPref
  id12
  cmn_pref_name千葉県
  cmn_pref_codechiba
  5
  CmnPref
  id13
  cmn_pref_name東京都
  cmn_pref_codetokyo
  6
  CmnPref
  id14
  cmn_pref_name神奈川県
  cmn_pref_codekanagawa
  7
  CmnPref
  id16
  cmn_pref_name富山県
  cmn_pref_codetoyama
  8
  CmnPref
  id20
  cmn_pref_name長野県
  cmn_pref_codenagano
  9
  CmnPref
  id21
  cmn_pref_name岐阜県
  cmn_pref_codegifu
  10
  CmnPref
  id22
  cmn_pref_name静岡県
  cmn_pref_codeshizuoka
  11
  CmnPref
  id23
  cmn_pref_name愛知県
  cmn_pref_codeaichi
  12
  CmnPref
  id24
  cmn_pref_name三重県
  cmn_pref_codemie
  13
  CmnPref
  id27
  cmn_pref_name大阪府
  cmn_pref_codeosaka
  14
  CmnPref
  id28
  cmn_pref_name兵庫県
  cmn_pref_codehyogo
  15
  CmnPref
  id31
  cmn_pref_name鳥取県
  cmn_pref_codetottori
  16
  CmnPref
  id32
  cmn_pref_name島根県
  cmn_pref_codeshimane
  17
  CmnPref
  id34
  cmn_pref_name広島県
  cmn_pref_codehiroshima
  18
  CmnPref
  id35
  cmn_pref_name山口県
  cmn_pref_codeyamaguchi
  19
  CmnPref
  id38
  cmn_pref_name愛媛県
  cmn_pref_codeehime
  20
  CmnPref
  id40
  cmn_pref_name福岡県
  cmn_pref_codefukuoka
  21
  CmnPref
  id41
  cmn_pref_name佐賀県
  cmn_pref_codesaga
  22
  CmnPref
  id42
  cmn_pref_name長崎県
  cmn_pref_codenagasaki
  23
  CmnPref
  id43
  cmn_pref_name熊本県
  cmn_pref_codekumamoto
  24
  CmnPref
  id44
  cmn_pref_name大分県
  cmn_pref_codeoita
  25
  CmnPref
  id46
  cmn_pref_name鹿児島県
  cmn_pref_codekagoshima
  26
  CmnPref
  id47
  cmn_pref_name沖縄県
  cmn_pref_codeokinawa
- rensapo_type2
- linked_rensapo_M1
- prefName北海道
- prefImg/img/upload/cmn_pref/hokkaido.png
- url_pref_id1
- path
  0hokkaido
  1hodarent_hokkaido
  2plan
  3621
- $request->data
  Action
  prefecture_id
  dep_date2025-07-03
  arv_date2025-07-03
  dep_time09:00
  arv_time17:00
  type_id
- $this->validationErrors
  CmnPref(empty)
  CarBrand(empty)
  CarMaker(empty)
  CarOffice(empty)
  CarNationalSearchPlan(empty)
  CarClass(empty)
  CarModel(empty)
  CarType(empty)
  Kuchikomi(empty)
  KuchikomiRankNational(empty)
  CmnCity(empty)
  CmnStationNational(empty)
  CmnAirportNational(empty)
  CarSpecial(empty)
  CarOptionType(empty)
  CarFaqNational(empty)
  CmnSeoNational(empty)
  CarPlan(empty)
  RsOffice(empty)
  RsCarClass(empty)
  RsOptionHabtm(empty)
  RsOptionStock(empty)
  RsOption(empty)
  RsCar(empty)
  RsrCarPlan(empty)
  RsrCarPlanPriceType(empty)
  RsrCarClass(empty)
  RsrCarOffice(empty)
  RsrCarOption(empty)
  RsrCarOptionStock(empty)
  RsrCarPlanOption(empty)
  CarDatabase(empty)
  RsrCarPlanLocation(empty)
  RsrCarLocation(empty)
  RsrCarLocationPlace(empty)
  CarOptionSearch(empty)
- Loaded Helpers
  0Paginator
  1Number
  2SimpleGraph
  3DebugTimer
  4Toolbar
  5Html
  6Form
  7HtmlToolbar
====

Environment

App Constants

Constant	Value
NON_COMMENT_MSG	... 採点だけの口コミ。
PAGE_ISHIGAKI	ishigaki
PAGE_MIYAKO	miyako
START_DAY_OF_WEEK_INDEX	0
END_DAY_OF_WEEK_INDEX	6
CARRENTAL_API_HOST	http://www.car-rental.jp
CARRENTAL_API_HOST_TEST	http://www.car-rental.jp/dev
GET_CARRENTAL_PLAN_LIST_ENDPOINT_PATH	/tabinfo_national/get_national_data/
GET_CARRENTAL_SINGLE_PLAN_ENDPOINT_PATH	/tabinfo_national/get_national_data/detail/
CAR489_API_HOST	https://www.tabinfo.jp
GET_CAR489_PLAN_LIST_ENDPOINT_PATH	/tabinfo_national/get_national_data/
GET_CAR489_SINGLE_PLAN_ENDPOINT_PATH	/tabinfo_national/get_national_data/detail/
GET_PLAN_LIST_ENDPOINT_PATH	/tabinfo_apis/tapi_get_plan_list/
GET_STOCK_ENDPOINT_PATH	/rentacars/ajax_stock/
GET_PRICE_ENDPOINT_PATH	/rentacars/ajax_price/
GET_RESERVE_PLAN_LIST_ENDPOINT_PATH	/tabinfo_national/get_national_data/
GET_RESERVE_SINGLE_PLAN_ENDPOINT_PATH	/tabinfo_national/get_national_data/detail/
GET_RESERVE_SINGLE_PLAN_DATA_ENDPOINT_PATH	/tabinfo_national/get_national_data/get_plan_data/
CHECK_CLASS_STOCK_ENDPOINT_PATH	/rsv/apis/get_data/stock_check/
CHECK_SINGLE_CLASS_STOCK_ENDPOINT_PATH	/rsv/apis/get_data/stock_check_one/
DEFAULT_START_PLUS_DAY	2
DEFAULT_END_PLUS_DAY	3
DEFAULT_START_PLUS_TIME	09:00
DEFAULT_END_PLUS_TIME	18:00
DEFAULT_CAR_RENTAL	1
PLAN_SORT_TYPE_LOWPRICE	1
PLAN_SORT_TYPE_NEW	2
PLAN_SORT_TYPE_HIRENTAL	3
IS_DEVELOPING
MAIL_FROM	infomail@tabinfo.jp
LOG_SES	log_ses
LOG_APPLICATION_ERROR	log_application_error
LOG_EMAIL_ERROR	log_email_error
LOG_CRON_NATIONAL	log_cron_national
SITE_TITLE	沖縄たびんふぉ
SITE_URL	https://tabinfo.jp/
OPEN_TYPE_OFF	0
OPEN_TYPE_ON	1
DELETE_TYPE_OFF	0
DELETE_TYPE_ON	1
ENABLE_TYPE_OFF	0
ENABLE_TYPE_ON	1
CARRIER_TYPE_PC	1
CARRIER_TYPE_SP	2
MAIL_MAGAZINE_TYPE_OFF	1
MAIL_MAGAZINE_TYPE_ON	2
MAIL_SERVICE_TYPE_ON	1
MAIL_SERVICE_TYPE_OFF	2
SEX_MAN	1
SEX_WOMAN	2
CMN_POINT_PORTAL_TYPE_CAR	1
CMN_POINT_PORTAL_TYPE_OPT	2
CMN_POINT_PORTAL_TYPE_REVIEWS	3
CMN_POINT_STATUS_RESERVE	1
CMN_POINT_STATUS_GET	2
CMN_POINT_STATUS_RETURN	3
CMN_POINT_STATUS_USE	50
CMN_POINT_STATUS_CANCEL	51
CMN_POINT_STATUS_LOSE	52
CMN_POINT_STATUS_NOSHOW	53
CAR_SMOKE_TYPE_OFF	1
CAR_SMOKE_TYPE_ON	2
CAR_MODEL_TM_TYPE_AT	1
CAR_MODEL_TM_TYPE_MT	2
CAR_OPTION_LEASE_TYPE_DAY	1
CAR_OPTION_LEASE_TYPE_NUM	2
CAR_PLAN_PRICE_TYPE_DAY	1
CAR_PLAN_PRICE_TYPE_TIME	2
INDEMNITY_PRICE_TYPE_OFF	1
INDEMNITY_PRICE_TYPE_ON	2
INDEMNITY_PRICE_SELECT_TYPE_OFF	1
INDEMNITY_PRICE_SELECT_TYPE_ON	2
CAR_PLAN_DROP_TYPE_ON	1
CAR_PLAN_DROP_TYPE_OFF	2
CAR_PLAN_OPTION_TYPE_SEL	1
CAR_PLAN_OPTION_TYPE_DEF	2
CAR_PLAN_OPTION_TYPE_DEL	3
CAR_RESERVATION_TYPE_RESERVE	1
CAR_RESERVATION_TYPE_CANCEL	8
CAR_RESERVATION_TYPE_NOSHOW	9
RESERVATION_CONTACT_TYPE_DONE	1
RESERVATION_CONTACT_TYPE_CONFIRM	2
RESERVATION_CONTACT_TYPE_NONE	3
CAR_RESERVATION_CONTACT_TYPE_MEMBER	1
CAR_RESERVATION_CONTACT_TYPE_CAR	2
DISCONTINUE_TYPE_OFF	1
DISCONTINUE_TYPE_ON	2
CAR_LOCATION_OFFICE_TYPE_OFFICE	1
CAR_LOCATION_OFFICE_TYPE_OTHER	2
CAR_OPTION_STOCK_TYPE_ON	1
CAR_OPTION_STOCK_TYPE_OFF	2
CAR_DESIGNATION_TYPE_ON	1
CAR_DESIGNATION_TYPE_OFF	2
POINT_GIVE_TYPE_ON	1
POINT_GIVE_TYPE_OFF	2
CAR_LOCATION_PLACE_TYPE_ON	1
CAR_LOCATION_PLACE_TYPE_OFF	2
CAR_RESERVATION_SITE_TYPE_TABINFO	1
CAR_RESERVATION_SITE_TYPE_CAR489	2
CAR_RESERVATION_SITE_TYPE_OFFICIAL	3
CAR_RESERVATION_SITE_TYPE_TRAVELNAVI	4
CAR_RESERVATION_SITE_TYPE_TRAVELKO	5
CAR_RESERVATION_SITE_TYPE_TABINFO_NATIONAL	100
CAR_PLAN_DISPLAY_SITES_TABINFO	1
CAR_PLAN_DISPLAY_SITES_OFFICIAL	2
CAR_PLAN_DISPLAY_SITES_TRANAVI	4
CAR_PLAN_DISPLAY_SITES_NATIONAL	8
CAR_CLOSE_RESERVATION_TYPE_TIME	1
CAR_CLOSE_RESERVATION_TYPE_DAY	2
CAR_SPECIAL_TYPE_CAMPAIGN	1
CAR_SPECIAL_TYPE_PICKUP	2
CAR_SPECIAL_TYPE_CARBRAND	3
NAHA_AIRPORT	1
TGALLERIA	2
IALAND_NAHA	3
IALAND_CHUBU	4
IALAND_HOKUBU	5
IALAND_ISHIAGAKI	6
IALAND_MIYAKO	7
IALAND_KUME	8
PAY_JP_PUBLIC_KEY_203	pk_live_cb2e3d8a735237bcd645273a
PAY_JP_SECRET_KEY_203	sk_live_50e627bb2e3ecb550dc8e85a9a5f53f3e745d31484af1c01ca59a1cc
PAY_JP_PUBLIC_KEY_240	pk_test_e7343b1e699f1536206f5f5e
PAY_JP_SECRET_KEY_240	sk_test_446ae9021fabe008dba0ead8
OST_QUESTION_STATUS_TYPE_ACCEPT	1
OST_QUESTION_STATUS_TYPE_SOLVE	2
OST_QUESTION_BEST_ANSWER_TYPE_EXIST	1
OST_QUESTION_BEST_ANSWER_TYPE_NONE	0
OST_QUESTION_ANSWER_TYPE_EXIST	1
OST_QUESTION_ANSWER_TYPE_NONE	0
OST_AREA_DEFAULT	1
OST_AREA_ISHIGAKI	2
OST_AREA_MIYAKO	3
SITE_TITLE_NATIONAL	たびんふぉ
SALES_TYPE_CATEGORY_WEB	2
SALES_TYPE_TABINFO_NATIONAL	1000
T_USE_RENSAPO_NOTSET	0
T_USE_RENSAPO_RESERVE_TABINFO	1
T_USE_RENSAPO_RESERVE_CARRENTAL	2
T_USE_RENSAPO_MASTER	3
T_USE_RENSAPO_PREMIUM	4
T_USE_RENSAPO_MASTER_RESERVE	5
T_DB_TYPE_RENSAPO	1
T_DB_TYPE_RENSAPO_RESERVE	2
T_CAR_SMOKE_TYPE_NONE	0
T_CAR_SMOKE_TYPE_NOSMOKING	1
T_CAR_SMOKE_TYPE_SMOKING	2
TYPE_RENSAPO_RESERVE	1
TYPE_RENSAPO_MASTER	2
HOST_TABINFO	https://www.tabinfo.jp
HOST_CARRENTAL	https://car-rental.jp
LINKED_RENSAPO_M	1
NOT_LINKED_RENSAPO_M	0
HAS_COMMUNICATION_TOOL	1
HAS_NOT_COMMUNICATION_TOOL	0
CANCEL_EXPIRED_DATE	10
PICKUP_TYPE_DIRECT_VISIT	1
PICKUP_TYPE_AIRPORT	2
OPT_SUPPLIER_ASSIGN_TYPE_IMOVE	1
OPT_SUPPLIER_ASSIGN_TYPE_WMT	2
OPT_SUPPLIER_ASSIGN_TYPE_YNM	3
OPT_FIELD_RESERVE_TYPE_TEXT	1
OPT_FIELD_RESERVE_TYPE_TEXTAREA	2
OPT_FIELD_RESERVE_TYPE_SELECT	3
OPT_FIELD_RESERVE_TYPE_RADIO	4
OPT_FIELD_RESERVE_TYPE_CHECKBOX	5
OPT_RESERVATION_TYPE_RESERVE	1
OPT_RESERVATION_TYPE_DONE	2
OPT_RESERVATION_TYPE_CANCEL	8
OPT_RESERVATION_TYPE_STOP	9
OPT_RESERVATION_SITE_TYPE_TABINFO	1
OPT_RESERVATION_SITE_TYPE_SAMTOUR	2
OPT_RESERVATION_SITE_TYPE_PARASAILING	3
OPT_RESERVATION_SITE_TYPE_SEAWALKER	4
OPT_RESERVATION_SITE_TYPE_DIVING	5
OPT_RESERVATION_SITE_TYPE_WHALE	6
OPT_MAIN_GENRE_DIVING	1
OPT_MAIN_GENRE_MARINE	2
OPT_MAIN_GENRE_TAIKEN	3
OPT_MAIN_GENRE_BEAUTY	4
OPT_MAIN_GENRE_TOUR	5
OPT_MAIN_GENRE_OTHER	6
OPT_GENRE_SUB_NAME_ALL	0
OPT_GENRE_SUB_NAME_DIVING	1
OPT_GENRE_SUB_NAME_SNORKEL	2
OPT_GENRE_SUB_NAME_FUN	3
OPT_GENRE_SUB_NAME_LICENSE	23
OPT_GENRE_SUB_NAME_TAIKEN	24
OPT_GENRE_SUB_NAME_PARASAILING	4
OPT_GENRE_SUB_NAME_CANOU	5
OPT_GENRE_SUB_NAME_SEAWALKER	6
OPT_GENRE_SUB_NAME_SURFING	7
OPT_GENRE_SUB_NAME_GLASSBOAT	8
OPT_GENRE_SUB_NAME_FISHING	9
OPT_GENRE_SUB_NAME_WHALEWATCHING	22
OPT_GENRE_SUB_NAME_WAKEBOARD	25
OPT_GENRE_SUB_NAME_KAITOBOARD	26
OPT_GENRE_SUB_NAME_MARINEBOARD	27
OPT_GENRE_SUB_NAME_PADDLEBOARD	28
OPT_GENRE_SUB_NAME_BANANA	38
OPT_GENRE_SUB_NAME_MARINEOTHER	39
OPT_GENRE_SUB_NAME_LICENSBOATS	40
FISH_BOOK_VIVID_ONE	1
FISH_BOOK_VIVID_TWO	2
FISH_BOOK_VIVID_THREE	3
FISH_BOOK_VIVID_FOUR	4
FISH_BOOK_VIVID_FIVE	5
FISH_BOOK_DANGER_ONE	1
FISH_BOOK_DANGER_TWO	2
FISH_BOOK_DANGER_THREE	3
FISH_BOOK_DANGER_FOUR	4
FISH_BOOK_DANGER_FIVE	5
OPT_MAIL_TEMPLATE_SUBJECT	【[%site_name%](予約番号:[%reservation_no%])】ご予約ありがとうございました
OPT_MAIL_TEMPLATE_BODY	[%client_name%]　様この度は、［[%site_name%]］へご予約いただき誠にありがとうございます。 ※本メールは送信専用メールアドレスから配信されています。　ご返信いただいてもお答えできませんので、ご了承ください。　変更・取消・お問合せは下記催行ショップへ直接ご連絡ください。以下のご予約内容をご確認ください。 ------------------------------------------------------------ [%reserve_info%] ------------------------------------------------------------ 当日のご来店を心よりお待ちしております。
OPT_MAIL_TEMPLATE_FOOTER	＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ ※変更・キャンセル・お問合せは、催行ショップへ直接ご連絡ください。 ----------------------------------------------------------------------- 【催行ショップ】 [%shop_name%] [%shop_address%] [%shop_tel%] [%shop_email%] ＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ [%site_name%] [%site_url%]
INPUT_REQUIRED	1
INPUT_EMPTY	-1
NAHA	1
SAPPORO	2
SENDAI	3
NIIGATA	4
KOMATSU	5
CHUBU	6
SHIZUOKA	7
NARITA	8
HANEDA	9
ITAMI	10
KANSAI	11
KOBE	12
OKAYAMA	13
HIROSHIMA	14
TAKAMATSU	15
MATSUYAMA	16
FUKUOKA	17
NAGASAKI	18
KUMAMOTO	19
MIYAZAKI	20
KAGOSHIMA	21
AMAMI	22
YORON	23
KITADAITO	24
MINAMIDAITO	25
KUME	26
MIYAKO	27
ISHIGAKI	28
YONAGUNI	29
CATEGORY_GROUP_RESERVATIONS_BEFORE	1
OPEN_TYPE_ON_AVAILABLE	2
OPEN_TYPE_OTHER	3
YOYAKU_AGENT_1	1
YOYAKU_AGENT_2	2
YOYAKU_AGENT_3	3
YOYAKU_AGENT_4	4
YOYAKU_AGENT_5	5
YOYAKU_AGENT_6	6
YOYAKU_AGENT_7	7
YOYAKU_AGENT_8	8
YOYAKU_AGENT_9	9
YOYAKU_AGENT_10	10
YOYAKU_AGENT_11	11
YOYAKU_AGENT_12	12
YOYAKU_AGENT_13	13
YOYAKU_AGENT_14	14
YOYAKU_AGENT_15	15
YOYAKU_AGENT_16	16
YOYAKU_AGENT_CODE_1	LT
YOYAKU_AGENT_CODE_2	UPL
YOYAKU_AGENT_CODE_3	EZT
YOYAKU_AGENT_CODE_4	LIF
YOYAKU_AGENT_CODE_5	SET
YOYAKU_AGENT_CODE_6	BWT
YOYAKU_AGENT_CODE_7	FLY
YOYAKU_AGENT_CODE_8	FTT
YOYAKU_AGENT_CODE_9	RCH
YOYAKU_AGENT_CODE_10	STR
YOYAKU_AGENT_CODE_11	PHX
YOYAKU_AGENT_CODE_12	KIT
YOYAKU_AGENT_CODE_13	GGO
YOYAKU_AGENT_CODE_14	COL
YOYAKU_AGENT_CODE_15	SUN
YOYAKU_AGENT_CODE_16	ETH
YOYAKU_AGENT_NAME_1	ライオントラベル
YOYAKU_AGENT_NAME_2	リョテンカ
YOYAKU_AGENT_NAME_3	イージーティ
YOYAKU_AGENT_NAME_4	ライフツアー
YOYAKU_AGENT_NAME_5	トウナン
YOYAKU_AGENT_NAME_6	ベストウェイ
YOYAKU_AGENT_NAME_7	イージーフライ
YOYAKU_AGENT_NAME_8	エフティーティー
YOYAKU_AGENT_NAME_9	リッチモンドツアー
YOYAKU_AGENT_NAME_10	スタートラベル
YOYAKU_AGENT_NAME_11	フィーニックスツアー
YOYAKU_AGENT_NAME_12	キタヤツアー
YOYAKU_AGENT_NAME_13	ジージーオー
YOYAKU_AGENT_NAME_14	コーラ
YOYAKU_AGENT_NAME_15	サンシャイン
YOYAKU_AGENT_NAME_16	イーティー　ホリデー
ENJOY_API_AUTH_TOKEN	f18b2c9d898390a251685d11a879db96

CakePHP Constants

Constant	Value
APP	/home/web-staff/apps/front_www/
APP_DIR	front_www
APPLIBS	/home/web-staff/apps/front_www/Lib/
CACHE	/home/web-staff/apps/front_www/tmp/cache/
CAKE	/home/web-staff/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/web-staff/lib
CORE_PATH	/home/web-staff/lib/
CAKE_VERSION	2.3.5
CSS	/home/web-staff/public_html/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.tabinfo.jp
IMAGES	/home/web-staff/public_html/img/
IMAGES_URL	img/
JS	/home/web-staff/public_html/js/
JS_URL	js/
LOGS	/home/web-staff/apps/front_www/tmp/logs/
ROOT	/home/web-staff/apps
TESTS	/home/web-staff/apps/front_www/Test/
TMP	/home/web-staff/apps/front_www/tmp/
VENDORS	/home/web-staff/apps/vendors/
WEBROOT_DIR	public_html
WWW_ROOT	/home/web-staff/public_html/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
User	apache
Home	/usr/share/httpd
Fcgi Role	RESPONDER
Redirect Unique Id	aGIpjDAwRwbQmYKFaeeeXgAAAMw
Redirect Http Authorization
Redirect Https	on
Redirect Ssl Tls Sni	www.tabinfo.jp
Redirect Status	200
Unique Id	aGIpjDAwRwbQmYKFaeeeXgAAAMw
Http Authorization
Https	on
Ssl Tls Sni	www.tabinfo.jp
Ssl Server S Dn Cn	www.tabinfo.jp
Ssl Server I Dn C	JP
Ssl Server I Dn O	SECOM Trust Systems CO.,LTD.
Ssl Server I Dn Cn	FujiSSL Public Validation Authority - G3
Ssl Server San Dns 0	www.tabinfo.jp
Ssl Server San Dns 1	tabinfo.jp
Ssl Version Interface	mod_ssl/2.4.62
Ssl Version Library	OpenSSL/3.0.14
Ssl Protocol	TLSv1.3
Ssl Secure Reneg	true
Ssl Compress Method	NULL
Ssl Cipher	TLS_AES_256_GCM_SHA384
Ssl Cipher Export	false
Ssl Cipher Usekeysize	256
Ssl Cipher Algkeysize	256
Ssl Client Verify	NONE
Ssl Server M Version	3
Ssl Server M Serial	3D54047B15D8DA7DB777B451541094D3
Ssl Server V Start	Jul 4 04:18:11 2024 GMT
Ssl Server V End	Jul 25 14:59:59 2025 GMT
Ssl Server S Dn	CN=www.tabinfo.jp
Ssl Server I Dn	CN=FujiSSL Public Validation Authority - G3,O=SECOM Trust Systems CO.\,LTD.,C=JP
Ssl Server A Key	rsaEncryption
Ssl Server A Sig	sha256WithRSAEncryption
Ssl Session Id	c78e8eaba99b20e2de9501b5f18faeebf08f48faf3f87bb7e031337d1535e1b5
Ssl Session Resumed	Initial
Proxy-nokeepalive	1
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
Http Referer	https://www.tabinfo.jp/hokkaido/hodarent_hokkaido/plan/621
Http Cookie	CAKEPHP=u9e00mup0prit7el988kb8ltd4
Http Host	www.tabinfo.jp
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.tabinfo.jp
Server Addr	10.0.0.184
Server Port	443
Remote Addr	216.73.216.9
Document Root	/home/web-staff/public_html
Request Scheme	https
Context Prefix
Context Document Root	/home/web-staff/public_html
Server Admin	webmaster@tabinfo.jp
Script Filename	/home/web-staff/public_html/index.php
Remote Port	59945
Redirect Url	/hokkaido/hodarent_hokkaido/plan/621/
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/hokkaido/hodarent_hokkaido/plan/621/
Script Name	/index.php
Php Self	/index.php
Request Time Float	1751263628.5402
Request Time	1751263628

====

Include
+
Included Files

Include Paths
- 1/opt/remi/php56/root/usr/share/pear
- 2/opt/remi/php56/root/usr/share/php
- 3/usr/share/pear
- 4/usr/share/php
- 5-> /home/web-staff/lib/Cake/
Included Files
- core
  Behavior
  0CORE/Model/BehaviorCollection.php
  1CORE/Model/Behavior/ContainableBehavior.php
  2CORE/Model/ModelBehavior.php
  Cache
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  3CORE/Routing/Filter/CacheDispatcher.php
  Component
  0CORE/Controller/ComponentCollection.php
  1CORE/Controller/Component.php
  2CORE/Controller/Component/SessionComponent.php
  3CORE/Controller/Component/CookieComponent.php
  4CORE/Controller/Component/PaginatorComponent.php
  Config
  0CORE/Core/Configure.php
  1CORE/Config/routes.php
  2CORE/Config/config.php
  Controller
  0CORE/Controller/Controller.php
  Datasource
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model
  0CORE/Model/Model.php
  1CORE/Model/ConnectionManager.php
  Network
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  2CORE/Network/Http/HttpSocket.php
  3CORE/Network/CakeSocket.php
  4CORE/Network/Http/HttpSocketResponse.php
  Other
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/const.php
  4CORE/Event/CakeEventListener.php
  5CORE/Event/CakeEvent.php
  6CORE/Event/CakeEventManager.php
  7CORE/Core/Object.php
  Plugin
  0CORE/Core/CakePlugin.php
  1CORE/Routing/Route/PluginShortRoute.php
  Routing
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Router.php
  4CORE/Routing/Route/CakeRoute.php
  Utility
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  View
  0CORE/View/HelperCollection.php
- app
  Component
  0APP/Controller/Component/CmnComponent.php
  Config
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/const.php
  3APP/Config/bootstrap_function.php
  4APP/Config/routes.php
  5APP/Config/database.php
  Controller
  0APP/Controller/PrefecturesController.php
  1APP/Controller/AppController.php
  2APP/Controller/SitesController.php
  Model
  0APP/Model/CmnPref.php
  1APP/Model/AppModel.php
  2APP/Model/CarBrand.php
  3APP/Model/CarMaker.php
  4APP/Model/CarOffice.php
  5APP/Model/CarNationalSearchPlan.php
  6APP/Model/CarClass.php
  7APP/Model/CarModel.php
  8APP/Model/CarType.php
  9APP/Model/Kuchikomi.php
  10APP/Model/KuchikomiRankNational.php
  11APP/Model/CmnCity.php
  12APP/Model/CmnStationNational.php
  13APP/Model/CmnAirportNational.php
  14APP/Model/CarSpecial.php
  15APP/Model/CarOptionType.php
  16APP/Model/CarFaqNational.php
  17APP/Model/CarPlan.php
  18APP/Model/RsOffice.php
  19APP/Model/RsCarClass.php
  20APP/Model/RsOptionHabtm.php
  21APP/Model/RsOptionStock.php
  22APP/Model/RsOption.php
  23APP/Model/RsCar.php
  24APP/Model/RsrCarPlan.php
  25APP/Model/RsrCarPlanPriceType.php
  26APP/Model/RsrCarClass.php
  27APP/Model/RsrCarOffice.php
  28APP/Model/RsrCarOption.php
  29APP/Model/RsrCarOptionStock.php
  30APP/Model/RsrCarPlanOption.php
  31APP/Model/RsrCarPlanLocation.php
  32APP/Model/RsrCarLocation.php
  33APP/Model/RsrCarLocationPlace.php
  34APP/Model/CarOptionSearch.php
- plugins
  DebugKit
  Component
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLogListener.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

【公式サイト最安値保証】夏のドライブキャンペーン◇◇免責補償･JAFサポート付◇◇グレイスハイブリッド

レンタカーご予約内容

オプション選択

予約に関するご案内

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 12 ms Total Queries: 34 queries

Query Explain:

change_rensapo_reserve_db

Total Time: 2 ms Total Queries: 4 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 12 ms
Total Queries: 34 queries

Total Time: 2 ms
Total Queries: 4 queries