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 = '262'
$brand_id = '104'
$office_id = '235'
$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 = '262'
$brand_id = '104'
$office_id = '235'
$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 = '262'
$brand_id = '104'
$office_id = '235'
$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 = '262'
$brand_id = '104'
$office_id = '235'
$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 = '262'
$brand_id = '104'
$office_id = '235'
$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 = '262'
$brand_id = '104'
$office_id = '235'
$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

北海道トラベルレンタカーの「新型アルヴェルプラン。」（新千歳空港営業所）｜たびんふぉ

新型アルヴェルプラン。

車両タイプ：ワンボックス
車両クラス：WA-C[定員7名] 禁煙車
代表車種：アルファード・ヴェルファイアなど

禁煙車
カーナビ
ETC車載機
スタットレスタイヤ

プラン詳細

■現金・ＶＩＳＡ・MASTERカードでのお支払い可能

■免責補償選択可能

※免許証の色が緑色（初心者未更新）の方は補償の適用が出来ません。

※NOC・レッカー費用等はお客様のご負担になります。

■カーナビ・ＥＴＣ標準装備

※ETCカードはお客様各自ご持参下さい

■スマートフォンなどで音楽が楽しめるUSB又はBluetooth装置を

装備しております。

■禁煙車をご用意いたします。

■空港無料送迎あり（新千歳空港～営業所間のみ）

▼ペット同乗できません▼

▼スキー・スノーボード等の積載禁止▼

快適なドライブが楽しめる様、準備してスタッフ一同お待ちしております♪

レンタカーご予約内容

レンタカー会社: 北海道トラベルレンタカー

出発

出発日時

出発場所

返却

返却日時

返却場所

台数

車両クラス：WA-C[定員7名] 禁煙車
代表車種：アルファード・ヴェルファイアなど

1台

予約に関するご案内

キャンセルポリシー

予約変更・取消・払戻しについてはこちらをご覧ください。 https://r-hts.net/free/reserve

補償制度

対人補償	無制限(1名限度額)
対物補償	無制限（免責5万円）
車両補償	時価額（免責10万円）
人身傷害補償	1名につき3,000万円（乗車定員まで）

ご予約お見積り

レンタカー会社: 北海道トラベルレンタカー
出発
返却

台数: 1台 ---円

禁煙車: -- 台/ ---円
ジュニアシート: -- 台/ ---円
チャイルドシート: -- 台/ ---円
ベビーシート: -- 台/ ---円
カーナビ: -- 台/ ---円
ETC車載機: -- 台/ ---円
スタットレスタイヤ: -- 台/ ---円
免責補償大型: -- 台/ ---円

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

History
+
Request History
1 previous requests available
- Restore to current request
- hokkaido/hokkaidotravel/plan/46
====
Session
+
Session
- Config
 userAgentaf109b8469d612bfcc3d94a521fbc15f
 time1747906927
 countdown10
- uniqid_token682eb92fe1c06
- plan_info
 CarBrand
 id104
 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_codehokkaidotravel
 cmn_pref_ids1
 contact_tel
 car_brand_logo_image_path/img/upload/car_brand/hokkaidotravel.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新千歳空港の周辺で格安レンタカーを利用するなら、北海道トラベルレンタカーへお任せください！新千歳空港から無料送迎あり！（約10分）
 car_brand_cancel_policy予約変更・取消・払戻しについてはこちらをご覧ください。 https://r-hts.net/free/reserve
 car_brand_guarantee_system<table class="table"> <tbody><tr> <th>対人補償</th> <td>無制限(1名限度額)</td> </tr> <tr> <th>対物補償</th> <td>無制限（免責5万円）</td> </tr> <tr> <th>車両補償</th> <td>時価額（免責10万円）</td> </tr> <tr> <th>人身傷害補償</th> <td>1名につき3,000万円（乗車定員まで）</td> </tr> </tbody></table>
 car_brand_memo1_en(null)
 car_brand_memo1_cnh(null)
 car_brand_memo1_cnk(null)
 car_brand_memo1_ko(null)
 car_brand_reservation_codeHTS
 rensapo_type2
 rensapo_brand_id67
 rensapo_office_id0
 rensapo_url
 linked_rensapo_M1
 has_communication_tool0
 point_give_type2
 search_open_type0
 sort127
 is_jtb(null)
 jtb_sort1
 jtb_open_type1
 national_open_type1
 open_type0
 delete_type0
 modified2025-05-13 17:13:05
 created2023-10-26 20:47:51
 editor1
 author1
 ViewPlan
 rensapo_office_id235
 rensapo_class_id959
 rensapo_plan_id262
 pickup_flags
 flg_pickup_airport_national1
 plan_name新型アルヴェルプラン。
 car_plan_memo プラン詳細 ■現金・ＶＩＳＡ・MASTERカードでのお支払い可能 ■免責補償選択可能 ※免許証の色が緑色（初心者未更新）の方は補償の適用が出来ません。 ※NOC・レッカー費用等はお客様のご負担になります。 ■カーナビ・ＥＴＣ標準装備 ※ETCカードはお客様各自ご持参下さい ■スマートフォンなどで音楽が楽しめるUSB又はBluetooth装置を 装備しております。 ■禁煙車をご用意いたします。 ■空港無料送迎あり（新千歳空港～営業所間のみ） ▼ペット同乗できません▼ ▼スキー・スノーボード等の積載禁止▼ 快適なドライブが楽しめる様、準備してスタッフ一同お待ちしております♪ 
 class_nameWA-C
 office_name新千歳空港営業所
 car_max_member7
 reference_car_nameアルファード・ヴェルファイア
 smoke_type1
 plan_imghttps://car-rental.jp/img/upload/car_plan/262_detail.jpg
 car_brand_logo_image_pathhttps://www.tabinfo.jp/img/upload/car_brand/hokkaidotravel.png
 car_type_id8
 car_type_nameワンボックス
 hito6
 bag3
 listOffice
 営業所
 _(null)
 listOfficeE
 営業所
 __(null)
 CarPlanOption
 435
 CarPlanOption
 id11644
 car_plan_id262
 car_option_id435
 car_plan_option_type2
 sort8
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id435
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id6
 car_option_name禁煙車
 car_option_name_ennon-smoking car
 car_option_name_cnh禁煙車
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort8
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:17:38
 created2019-04-04 20:16:14
 editor162
 author162
 Option
 id435
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id6
 car_option_name禁煙車
 car_option_name_ennon-smoking car
 car_option_name_cnh禁煙車
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort8
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:17:38
 created2019-04-04 20:16:14
 editor162
 author162
 434
 CarPlanOption
 id11645
 car_plan_id262
 car_option_id434
 car_plan_option_type1
 sort7
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id434
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id21
 car_option_nameジュニアシート
 car_option_name_enJunior Seat (4-11 years)
 car_option_name_cnh兒童座椅(建議：4歲-11歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort7
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:29:42
 created2019-04-04 20:14:51
 editor162
 author162
 Option
 id434
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id21
 car_option_nameジュニアシート
 car_option_name_enJunior Seat (4-11 years)
 car_option_name_cnh兒童座椅(建議：4歲-11歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort7
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:29:42
 created2019-04-04 20:14:51
 editor162
 author162
 433
 CarPlanOption
 id11646
 car_plan_id262
 car_option_id433
 car_plan_option_type1
 sort6
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id433
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id4
 car_option_nameチャイルドシート
 car_option_name_enChild Seat (1-4 years)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort6
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:30:11
 created2019-04-04 20:13:05
 editor162
 author162
 Option
 id433
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id4
 car_option_nameチャイルドシート
 car_option_name_enChild Seat (1-4 years)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort6
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:30:11
 created2019-04-04 20:13:05
 editor162
 author162
 427
 CarPlanOption
 id11647
 car_plan_id262
 car_option_id427
 car_plan_option_type1
 sort5
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id427
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id17
 car_option_nameベビーシート
 car_option_name_enBaby Seat (0-12 months)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort2
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:31:21
 created2019-03-20 10:00:56
 editor162
 author162
 Option
 id427
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id17
 car_option_nameベビーシート
 car_option_name_enBaby Seat (0-12 months)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort2
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:31:21
 created2019-03-20 10:00:56
 editor162
 author162
 426
 CarPlanOption
 id11648
 car_plan_id262
 car_option_id426
 car_plan_option_type2
 sort4
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id426
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id2
 car_option_nameカーナビ
 car_option_name_enMultilingual GPS (ENG/JPN)
 car_option_name_cnh多語言GPS
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort5
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:45:52
 created2019-03-20 10:00:31
 editor162
 author162
 Option
 id426
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id2
 car_option_nameカーナビ
 car_option_name_enMultilingual GPS (ENG/JPN)
 car_option_name_cnh多語言GPS
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort5
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:45:52
 created2019-03-20 10:00:31
 editor162
 author162
 425
 CarPlanOption
 id11649
 car_plan_id262
 car_option_id425
 car_plan_option_type2
 sort3
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id425
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id3
 car_option_nameETC車載機
 car_option_name_enETC Card Reader Device
 car_option_name_cnhETC讀卡器
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort4
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2024-10-13 13:56:42
 created2019-03-20 10:00:09
 editor162
 author162
 Option
 id425
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id3
 car_option_nameETC車載機
 car_option_name_enETC Card Reader Device
 car_option_name_cnhETC讀卡器
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort4
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2024-10-13 13:56:42
 created2019-03-20 10:00:09
 editor162
 author162
 555
 CarPlanOption
 id46507
 car_plan_id262
 car_option_id555
 car_plan_option_type2
 sort2
 delete_type0
 modified2024-11-23 16:12:57
 created2023-12-30 16:23:13
 editor162
 author162
 CarOption
 id555
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id19
 car_option_nameスタットレスタイヤ
 car_option_name_en4WD＋Snow tires
 car_option_name_cnh 4WD+雪胎(11月~4月)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unitセット
 car_option_max_lease1
 car_option_stock_type2
 sort1
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:36:37
 created2020-11-09 17:05:35
 editor162
 author162
 Option
 id555
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id19
 car_option_nameスタットレスタイヤ
 car_option_name_en4WD＋Snow tires
 car_option_name_cnh 4WD+雪胎(11月~4月)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unitセット
 car_option_max_lease1
 car_option_stock_type2
 sort1
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:36:37
 created2020-11-09 17:05:35
 editor162
 author162
 524
 CarPlanOption
 id48356
 car_plan_id262
 car_option_id524
 car_plan_option_type1
 sort1
 delete_type0
 modified2024-11-23 16:12:57
 created2024-11-23 16:12:57
 editor162
 author162
 CarOption
 id524
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id33
 car_option_name免責補償大型
 car_option_name_enCompensation Coverage
 car_option_name_cnh免責輔助險
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price12000
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price2000
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort10
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:28:58
 created2020-04-17 14:16:34
 editor162
 author162
 Option
 id524
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id33
 car_option_name免責補償大型
 car_option_name_enCompensation Coverage
 car_option_name_cnh免責輔助險
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price12000
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price2000
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort10
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:28:58
 created2020-04-17 14:16:34
 editor162
 author162
====
Request
+
Request

Cake Params
- plugin(null)
- controllerPrefectures
- actionindex
- named(empty)
- pass
  0hokkaido
  1hokkaidotravel
  2plan
  346
Post data
- Action
  prefecture_id
  dep_date2025-05-25
  arv_date2025-05-25
  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: 21 ms
Total Queries: 58 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	4	maybe slow
SELECT `KuchikomiRankNational`.`id` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`KuchikomiRankNational`.`car_brand_id` = `CarBrand`.`id`) WHERE `KuchikomiRankNational`.`is_delete` = 0 AND `KuchikomiRankNational`.`cmn_pref_id` = 1	1	1	1
DELETE `KuchikomiRankNational` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`id` = (120420)	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, 36, 1, 4.119999885559082, 4, 3, 4.400000095367432, 4.599999904632568, 4.599999904632568, 0, 1, 102, 'hdcrentacar', 330, '2025-05-22 14:42: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` = 'hokkaidotravel' 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` = 'hokkaidotravel' 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` = 'hokkaidotravel' 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` = 46 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/hokkaidotravel/plan/46/' AND `delete_type` = 0 LIMIT 1	0	0	1	maybe slow
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` = 'hokkaidotravel' 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` = (104)	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` = 46 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1	1	1	1
SELECT `CarOffice`.`flg_pickup_airport_national` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 385 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` = 104 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` = 104 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` = (104)	1	1	0
SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (104)	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`, `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` = 104 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1	8	8	4	maybe slow
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 6	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (435)	578	578	1
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 21	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (434)	0	0	0
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 4	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (433)	122	122	0
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 17	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (427)	269	269	0
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 2	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (426)	245	245	0
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 3	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (425)	273	273	0
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 19	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (555)	245	245	1
SELECT `CarGroup`.`id`, `CarGroup`.`car_brand_id`, `CarGroup`.`car_group_name`, `CarGroup`.`car_group_name_en`, `CarGroup`.`car_group_name_cnh`, `CarGroup`.`car_group_name_cnk`, `CarGroup`.`car_group_name_ko`, `CarGroup`.`car_group_code`, `CarGroup`.`call_tel`, `CarGroup`.`call_time`, `CarGroup`.`commission_tabinfo`, `CarGroup`.`sort`, `CarGroup`.`open_type`, `CarGroup`.`jtb_sort`, `CarGroup`.`jtb_open_type`, `CarGroup`.`delete_type`, `CarGroup`.`modified`, `CarGroup`.`created`, `CarGroup`.`editor`, `CarGroup`.`author` FROM `tabinfo_rentacar`.`car_groups` AS `CarGroup` WHERE `CarGroup`.`id` = 91	1	1	0
SELECT `CarOptionType`.`id`, `CarOptionType`.`car_option_type_name`, `CarOptionType`.`car_option_type_name_en`, `CarOptionType`.`car_option_type_name_cnh`, `CarOptionType`.`car_option_type_name_cnk`, `CarOptionType`.`car_option_type_name_ko`, `CarOptionType`.`sort`, `CarOptionType`.`open_type`, `CarOptionType`.`delete_type`, `CarOptionType`.`modified`, `CarOptionType`.`created`, `CarOptionType`.`editor`, `CarOptionType`.`author` FROM `tabinfo_rentacar`.`car_option_types` AS `CarOptionType` WHERE `CarOptionType`.`id` = 33	1	1	0
SELECT `CarOptionStock`.`id`, `CarOptionStock`.`car_brand_id`, `CarOptionStock`.`car_group_id`, `CarOptionStock`.`car_office_id`, `CarOptionStock`.`car_option_id`, `CarOptionStock`.`car_option_stock_date`, `CarOptionStock`.`car_option_stock`, `CarOptionStock`.`reserve`, `CarOptionStock`.`cancel`, `CarOptionStock`.`discontinue_type`, `CarOptionStock`.`delete_type`, `CarOptionStock`.`modified`, `CarOptionStock`.`created`, `CarOptionStock`.`editor`, `CarOptionStock`.`author` FROM `tabinfo_rentacar`.`car_option_stocks` AS `CarOptionStock` WHERE `CarOptionStock`.`car_option_id` = (524)	885	885	1
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)	45	45	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/hokkaidotravel/plan/46/' 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: 3 ms
Total Queries: 12 queries

Query	Affected	Num. rows	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` = 959 AND `RsrCarClass`.`delete_type` = 0 ORDER BY `RsrCarClass`.`id` ASC LIMIT 1	1	1	1
SELECT `RsrCarPlanLocation`.`id`, `RsrCarPlanLocation`.`car_location_start` FROM `car_rental_rrs`.`car_plan_locations` AS `RsrCarPlanLocation` WHERE `RsrCarPlanLocation`.`car_plan_id` = 262 AND `RsrCarPlanLocation`.`car_location_start` = 235 AND `RsrCarPlanLocation`.`car_location_end` = 235 AND NOT (`RsrCarPlanLocation`.`car_location_price` IS NULL) AND `RsrCarPlanLocation`.`delete_type` = 0 LIMIT 1	0	0	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	0	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` = 262 AND `RsrCarPlanOption`.`delete_type` = 0 ORDER BY `RsrCarPlanOption`.`id` ASC	8	8	1	maybe slow
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 435 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 434 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 433 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 427 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 426 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 425 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 555 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0
SELECT `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_options` AS `RsrCarOption` WHERE `RsrCarOption`.`id` = 524 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 15.34 MB

Message	Memory use
Component initialization	4.22 MB
Controller action start	4.61 MB
Controller render start	11.22 MB
View render complete	12.92 MB

Timers

Total Request Time: 295 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	16.46
Event: Controller.initialize	0.04
Event: Controller.startup	0.17
Controller action	238.22
Event: Controller.beforeRender	2.90
» Processing toolbar data	2.81
Rendering View	6.89
» Event: View.beforeRender	0.02
» Rendering APP/View/Prefectures/plan.ctp	5.38
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.97
» » Rendering APP/View/Elements/analytics.ctp	0.08
» » Rendering APP/View/Elements/pankuzu.ctp	0.19
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- seo
 title北海道トラベルレンタカーの「新型アルヴェルプラン。」（新千歳空港営業所）｜たびんふぉ
 keywords
 description北海道トラベルレンタカーの「新型アルヴェルプラン。」（新千歳空港営業所）の詳細ページ。北海道のレンタカーを比較・予約するなら【たびんふぉ】で。
 h1
 p
- data
 CarBrand
 id104
 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_codehokkaidotravel
 cmn_pref_ids1
 contact_tel
 car_brand_logo_image_path/img/upload/car_brand/hokkaidotravel.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新千歳空港の周辺で格安レンタカーを利用するなら、北海道トラベルレンタカーへお任せください！新千歳空港から無料送迎あり！（約10分）
 car_brand_cancel_policy予約変更・取消・払戻しについてはこちらをご覧ください。 https://r-hts.net/free/reserve
 car_brand_guarantee_system<table class="table"> <tbody><tr> <th>対人補償</th> <td>無制限(1名限度額)</td> </tr> <tr> <th>対物補償</th> <td>無制限（免責5万円）</td> </tr> <tr> <th>車両補償</th> <td>時価額（免責10万円）</td> </tr> <tr> <th>人身傷害補償</th> <td>1名につき3,000万円（乗車定員まで）</td> </tr> </tbody></table>
 car_brand_memo1_en(null)
 car_brand_memo1_cnh(null)
 car_brand_memo1_cnk(null)
 car_brand_memo1_ko(null)
 car_brand_reservation_codeHTS
 rensapo_type2
 rensapo_brand_id67
 rensapo_office_id0
 rensapo_url
 linked_rensapo_M1
 has_communication_tool0
 point_give_type2
 search_open_type0
 sort127
 is_jtb(null)
 jtb_sort1
 jtb_open_type1
 national_open_type1
 open_type0
 delete_type0
 modified2025-05-13 17:13:05
 created2023-10-26 20:47:51
 editor1
 author1
 ViewPlan
 rensapo_office_id235
 rensapo_class_id959
 rensapo_plan_id262
 pickup_flags
 flg_pickup_airport_national1
 plan_name新型アルヴェルプラン。
 car_plan_memo プラン詳細 ■現金・ＶＩＳＡ・MASTERカードでのお支払い可能 ■免責補償選択可能 ※免許証の色が緑色（初心者未更新）の方は補償の適用が出来ません。 ※NOC・レッカー費用等はお客様のご負担になります。 ■カーナビ・ＥＴＣ標準装備 ※ETCカードはお客様各自ご持参下さい ■スマートフォンなどで音楽が楽しめるUSB又はBluetooth装置を 装備しております。 ■禁煙車をご用意いたします。 ■空港無料送迎あり（新千歳空港～営業所間のみ） ▼ペット同乗できません▼ ▼スキー・スノーボード等の積載禁止▼ 快適なドライブが楽しめる様、準備してスタッフ一同お待ちしております♪ 
 class_nameWA-C
 office_name新千歳空港営業所
 car_max_member7
 reference_car_nameアルファード・ヴェルファイア
 smoke_type1
 plan_imghttps://car-rental.jp/img/upload/car_plan/262_detail.jpg
 car_brand_logo_image_pathhttps://www.tabinfo.jp/img/upload/car_brand/hokkaidotravel.png
 car_type_id8
 car_type_nameワンボックス
 hito6
 bag3
 listOffice
 営業所
 _(null)
 listOfficeE
 営業所
 __(null)
 CarPlanOption
 435
 CarPlanOption
 id11644
 car_plan_id262
 car_option_id435
 car_plan_option_type2
 sort8
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id435
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id6
 car_option_name禁煙車
 car_option_name_ennon-smoking car
 car_option_name_cnh禁煙車
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort8
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:17:38
 created2019-04-04 20:16:14
 editor162
 author162
 Option
 id435
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id6
 car_option_name禁煙車
 car_option_name_ennon-smoking car
 car_option_name_cnh禁煙車
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort8
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:17:38
 created2019-04-04 20:16:14
 editor162
 author162
 434
 CarPlanOption
 id11645
 car_plan_id262
 car_option_id434
 car_plan_option_type1
 sort7
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id434
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id21
 car_option_nameジュニアシート
 car_option_name_enJunior Seat (4-11 years)
 car_option_name_cnh兒童座椅(建議：4歲-11歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort7
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:29:42
 created2019-04-04 20:14:51
 editor162
 author162
 Option
 id434
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id21
 car_option_nameジュニアシート
 car_option_name_enJunior Seat (4-11 years)
 car_option_name_cnh兒童座椅(建議：4歲-11歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort7
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:29:42
 created2019-04-04 20:14:51
 editor162
 author162
 433
 CarPlanOption
 id11646
 car_plan_id262
 car_option_id433
 car_plan_option_type1
 sort6
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id433
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id4
 car_option_nameチャイルドシート
 car_option_name_enChild Seat (1-4 years)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort6
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:30:11
 created2019-04-04 20:13:05
 editor162
 author162
 Option
 id433
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id4
 car_option_nameチャイルドシート
 car_option_name_enChild Seat (1-4 years)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort6
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:30:11
 created2019-04-04 20:13:05
 editor162
 author162
 427
 CarPlanOption
 id11647
 car_plan_id262
 car_option_id427
 car_plan_option_type1
 sort5
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id427
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id17
 car_option_nameベビーシート
 car_option_name_enBaby Seat (0-12 months)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort2
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:31:21
 created2019-03-20 10:00:56
 editor162
 author162
 Option
 id427
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id17
 car_option_nameベビーシート
 car_option_name_enBaby Seat (0-12 months)
 car_option_name_cnh幼兒座椅(建議：12個月-4歲)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price11100
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price1100
 car_option_unit台
 car_option_max_lease3
 car_option_stock_type2
 sort2
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:31:21
 created2019-03-20 10:00:56
 editor162
 author162
 426
 CarPlanOption
 id11648
 car_plan_id262
 car_option_id426
 car_plan_option_type2
 sort4
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id426
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id2
 car_option_nameカーナビ
 car_option_name_enMultilingual GPS (ENG/JPN)
 car_option_name_cnh多語言GPS
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort5
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:45:52
 created2019-03-20 10:00:31
 editor162
 author162
 Option
 id426
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id2
 car_option_nameカーナビ
 car_option_name_enMultilingual GPS (ENG/JPN)
 car_option_name_cnh多語言GPS
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort5
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:45:52
 created2019-03-20 10:00:31
 editor162
 author162
 425
 CarPlanOption
 id11649
 car_plan_id262
 car_option_id425
 car_plan_option_type2
 sort3
 delete_type0
 modified2024-11-23 16:12:57
 created2019-05-16 12:30:00
 editor162
 author162
 CarOption
 id425
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id3
 car_option_nameETC車載機
 car_option_name_enETC Card Reader Device
 car_option_name_cnhETC讀卡器
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort4
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2024-10-13 13:56:42
 created2019-03-20 10:00:09
 editor162
 author162
 Option
 id425
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id3
 car_option_nameETC車載機
 car_option_name_enETC Card Reader Device
 car_option_name_cnhETC讀卡器
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type2
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort4
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2024-10-13 13:56:42
 created2019-03-20 10:00:09
 editor162
 author162
 555
 CarPlanOption
 id46507
 car_plan_id262
 car_option_id555
 car_plan_option_type2
 sort2
 delete_type0
 modified2024-11-23 16:12:57
 created2023-12-30 16:23:13
 editor162
 author162
 CarOption
 id555
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id19
 car_option_nameスタットレスタイヤ
 car_option_name_en4WD＋Snow tires
 car_option_name_cnh 4WD+雪胎(11月~4月)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unitセット
 car_option_max_lease1
 car_option_stock_type2
 sort1
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:36:37
 created2020-11-09 17:05:35
 editor162
 author162
 Option
 id555
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id19
 car_option_nameスタットレスタイヤ
 car_option_name_en4WD＋Snow tires
 car_option_name_cnh 4WD+雪胎(11月~4月)
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price10
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price0
 car_option_unitセット
 car_option_max_lease1
 car_option_stock_type2
 sort1
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:36:37
 created2020-11-09 17:05:35
 editor162
 author162
 524
 CarPlanOption
 id48356
 car_plan_id262
 car_option_id524
 car_plan_option_type1
 sort1
 delete_type0
 modified2024-11-23 16:12:57
 created2024-11-23 16:12:57
 editor162
 author162
 CarOption
 id524
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id33
 car_option_name免責補償大型
 car_option_name_enCompensation Coverage
 car_option_name_cnh免責輔助險
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price12000
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price2000
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort10
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:28:58
 created2020-04-17 14:16:34
 editor162
 author162
 Option
 id524
 car_brand_id67
 car_group_id91
 car_office_id(null)
 car_option_type_id33
 car_option_name免責補償大型
 car_option_name_enCompensation Coverage
 car_option_name_cnh免責輔助險
 car_option_name_cnk(null)
 car_option_name_ko(null)
 car_option_sub_name
 car_option_sub_name_en
 car_option_sub_name_cnh
 car_option_sub_name_cnk(null)
 car_option_sub_name_ko(null)
 car_option_lease_type1
 car_option_price12000
 car_option_price2(null)
 car_option_price3(null)
 car_option_price4(null)
 car_option_price5(null)
 car_option_price6(null)
 car_option_plus_price2000
 car_option_unit台
 car_option_max_lease1
 car_option_stock_type2
 sort10
 open_type1
 is_jtb(null)
 jtb_sort1
 jtb_open_type0
 delete_type0
 modified2023-12-30 17:28:58
 created2020-04-17 14:16:34
 editor162
 author162
- 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_id67
- uniqid_token682eb92fe1c06
- 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
 1hokkaidotravel
 2plan
 346
- $request->data
 Action
 prefecture_id
 dep_date2025-05-25
 arv_date2025-05-25
 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)
 CarGroup(empty)
 CarOptionStock(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	aC65L34xgjOhOmlMZEz_GgAAAEQ
Redirect Http Authorization
Redirect Https	on
Redirect Ssl Tls Sni	www.tabinfo.jp
Redirect Status	200
Unique Id	aC65L34xgjOhOmlMZEz_GgAAAEQ
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	61aef5483254ca618e534a55dad57efd8cad06d35866d5a7e9d9f3256a250214
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/hokkaidotravel/plan/46
Http Cookie	CAKEPHP=su7anj3ot5f9tukgek5q7cb665
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.228
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	9172
Redirect Url	/hokkaido/hokkaidotravel/plan/46/
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/hokkaido/hokkaidotravel/plan/46/
Script Name	/index.php
Php Self	/index.php
Request Time Float	1747892527.6703
Request Time	1747892527

====

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
====

新型アルヴェルプラン。

レンタカーご予約内容

オプション選択

予約に関するご案内

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 21 ms Total Queries: 58 queries

Query Explain:

change_rensapo_reserve_db

Total Time: 3 ms Total Queries: 12 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 21 ms
Total Queries: 58 queries

Total Time: 3 ms
Total Queries: 12 queries