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 = '290'
$brand_id = '135'
$office_id = '245'
$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 = '290'
$brand_id = '135'
$office_id = '245'
$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 = '290'
$brand_id = '135'
$office_id = '245'
$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 = '290'
$brand_id = '135'
$office_id = '245'
$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 = '290'
$brand_id = '135'
$office_id = '245'
$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 = '290'
$brand_id = '135'
$office_id = '245'
$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

アップルレンタカー那覇の「【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】」（アップルレンタカー那覇空港店）｜たびんふぉ

【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】

車両タイプ：軽自動車
車両クラス：KHV[定員4名] 禁煙車
代表車種：ワゴンR　ハイブリッドFX など

■乗車定員：４名

■推奨人数：１～２名

■チャイルドシート設置可能数：２台

■排気量：６６０ｃｃ

■燃料消費率：３３.４ｋｍ/Ｌ

＼安心の免責補償とNOC補償込みプラン♪／

本プランで貸出しする車両は、年式がやや古い、走行距離が多い、カーナビが古い、Bluetooth接続不可、

車体にキズがあるなど、少々ワケありなクルマとなっておりますが走行には全く問題ありません◎

安心安全＆コスパ重視のお客様は是非ご利用ください！

◎色はお選びいただけません。

◎店舗⇒空港へのお送りは19:45発が最終となります。

※お支払いに現金は使用できません。

レンタカーご予約内容

レンタカー会社: アップルレンタカー那覇

出発

出発日時

出発場所

返却

返却日時

返却場所

台数

車両クラス：KHV[定員4名] 禁煙車
代表車種：ワゴンR　ハイブリッドFX など

1台

予約に関するご案内

キャンセルポリシー

乗車日の7日以前	無料
乗車日の6～3日前	基本料金の20%
乗車日の2日前および前日	基本料料金の30%
乗車日当日以降	基本料金の50%

補償制度

対人補償	無制限
対物補償	無制限（免責額５万円）
車両補償	車両時価（免責額５万円）
人身傷害補償	3,000万円まで（一名につき　※1）

※1　搭乗者の自動車事故によるケガ（死亡・後遺症を含む）につき、運転者の過失割合に関わらず、損害額を補償いたします。（限度額3,000万円：治療費を含む損害額は保険約款に定める基準に従い算出します。）

ご予約お見積り

レンタカー会社: アップルレンタカー那覇
出発
返却

台数: 1台 ---円

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

History
+
Request History
1 previous requests available
- Restore to current request
- okinawa/apple_naha/plan/291
====
Session
+
Session
- Config
 userAgentaf109b8469d612bfcc3d94a521fbc15f
 time1745484390
 countdown10
- uniqid_token6809c226ea745
- plan_info
 CarBrand
 id135
 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_codeapple_naha
 cmn_pref_ids47
 contact_tel
 car_brand_logo_image_path/img/upload/car_brand/apple_naha.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アップルレンタカーは、オリコン顧客満足度調査No.1※を獲得した車買取専門会社の老舗、アップルが提供するレンタカーサービスです！那覇空港より無料送迎を行っています。
 car_brand_cancel_policy<table class="table"> <tbody> <tr> <th>乗車日の7日以前</th> <td>無料</td> </tr> <tr> <th>乗車日の6～3日前</th> <td>基本料金の20%</td> </tr> <tr> <th>乗車日の2日前および前日</th> <td>基本料料金の30%</td> </tr> <tr> <th>乗車日当日以降</th> <td>基本料金の50%</td> </tr> </tbody> </table>
 car_brand_guarantee_system<table class="table"> <tbody><tr> <th>対人補償</th> <td>無制限</td> </tr> <tr> <th>対物補償</th> <td>無制限（免責額５万円）</td> </tr> <tr> <th>車両補償</th> <td>車両時価（免責額５万円）</td> </tr> <tr> <th>人身傷害補償</th> <td>3,000万円まで（一名につき　※1）</td> </tr> </tbody> </table> ※1　搭乗者の自動車事故によるケガ（死亡・後遺症を含む）につき、運転者の過失割合に関わらず、損害額を補償いたします。（限度額3,000万円：治療費を含む損害額は保険約款に定める基準に従い算出します。）
 car_brand_memo1_en(null)
 car_brand_memo1_cnh(null)
 car_brand_memo1_cnk(null)
 car_brand_memo1_ko(null)
 car_brand_reservation_codemc
 rensapo_type2
 rensapo_brand_id69
 rensapo_office_id0
 rensapo_url
 linked_rensapo_M1
 has_communication_tool1
 point_give_type2
 search_open_type0
 sort127
 is_jtb(null)
 jtb_sort1
 jtb_open_type1
 national_open_type1
 open_type0
 delete_type0
 modified2025-04-02 11:13:25
 created2023-12-25 19:05:36
 editor1
 author1
 ViewPlan
 rensapo_office_id245
 rensapo_class_id978
 rensapo_plan_id290
 pickup_flags
 flg_pickup_airport_national1
 plan_name【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】
 car_plan_memo■乗車定員：４名 ■推奨人数：１～２名 ■チャイルドシート設置可能数：２台 ■排気量：６６０ｃｃ ■燃料消費率：３３.４ｋｍ/Ｌ ＼安心の免責補償とNOC補償込みプラン♪／ 本プランで貸出しする車両は、年式がやや古い、走行距離が多い、カーナビが古い、Bluetooth接続不可、 車体にキズがあるなど、少々ワケありなクルマとなっておりますが走行には全く問題ありません◎ 安心安全＆コスパ重視のお客様は是非ご利用ください！ ◎色はお選びいただけません。 ◎店舗⇒空港へのお送りは19:45発が最終となります。 ※お支払いに現金は使用できません。 
 class_nameKHV
 office_nameアップルレンタカー那覇空港店
 car_max_member4
 reference_car_nameワゴンR　ハイブリッドFX
 smoke_type1
 plan_imghttps://car-rental.jp/img/upload/car_plan/290_detail.jpg
 car_brand_logo_image_pathhttps://tabinfo.jp/img/upload/car_brand/apple_naha.png
 car_type_id1
 car_type_name軽自動車
 hito2
 bag2
 listOffice
 営業所
 _(null)
 listOfficeE
 営業所
 __(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerPrefectures
- actionindex
- named(empty)
- pass
  0okinawa
  1apple_naha
  2plan
  3291
Post data
- Action
  prefecture_id
  dep_date2025-04-27
  arv_date2025-04-27
  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: 6 ms
Total Queries: 30 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` = 'okinawa' 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 `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'apple_naha' AND FIND_IN_SET('47', 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` = 'apple_naha' AND FIND_IN_SET('47', 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` = 'apple_naha' AND FIND_IN_SET('47', 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` = 291 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1	1	1	1
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/okinawa/apple_naha/plan/291/' AND `delete_type` = 0 LIMIT 1	0	0	0
SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '///plan/*/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` IS NULL)) LIMIT 1	1	1	0
SELECT `CarBrand`.`id`, `CarBrand`.`car_brand_name`, `CarBrand`.`car_brand_name_en`, `CarBrand`.`car_brand_name_cnh`, `CarBrand`.`car_brand_name_cnk`, `CarBrand`.`car_brand_name_ko`, `CarBrand`.`car_brand_name_kana`, `CarBrand`.`car_brand_code`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`contact_tel`, `CarBrand`.`car_brand_logo_image_path`, `CarBrand`.`car_brand_image1_path`, `CarBrand`.`car_brand_image2_path`, `CarBrand`.`car_brand_movie_url`, `CarBrand`.`car_brand_movie_url_en`, `CarBrand`.`car_brand_movie_url_cnh`, `CarBrand`.`car_brand_movie_url_cnk`, `CarBrand`.`car_brand_movie_url_ko`, `CarBrand`.`car_brand_memo1`, `CarBrand`.`car_brand_cancel_policy`, `CarBrand`.`car_brand_guarantee_system`, `CarBrand`.`car_brand_memo1_en`, `CarBrand`.`car_brand_memo1_cnh`, `CarBrand`.`car_brand_memo1_cnk`, `CarBrand`.`car_brand_memo1_ko`, `CarBrand`.`car_brand_reservation_code`, `CarBrand`.`rensapo_type`, `CarBrand`.`rensapo_brand_id`, `CarBrand`.`rensapo_office_id`, `CarBrand`.`rensapo_url`, `CarBrand`.`linked_rensapo_M`, `CarBrand`.`has_communication_tool`, `CarBrand`.`point_give_type`, `CarBrand`.`search_open_type`, `CarBrand`.`sort`, `CarBrand`.`is_jtb`, `CarBrand`.`jtb_sort`, `CarBrand`.`jtb_open_type`, `CarBrand`.`national_open_type`, `CarBrand`.`open_type`, `CarBrand`.`delete_type`, `CarBrand`.`modified`, `CarBrand`.`created`, `CarBrand`.`editor`, `CarBrand`.`author` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'apple_naha' 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` = (135)	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` = 291 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` = 336 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` = 135 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` = 135 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` = (135)	1	1	0
SELECT `CarOffice`.`email`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`car_brand_id` = (135)	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` = 135 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1	19	19	4	maybe slow
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	39	39	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, 146)	47	47	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` = 47 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	4	4	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` = 47 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	1	1	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` = '/okinawa/apple_naha/plan/291/' 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: 1 ms
Total Queries: 4 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` = 978 AND `RsrCarClass`.`delete_type` = 0 ORDER BY `RsrCarClass`.`id` ASC LIMIT 1	1	1	0
SELECT `RsrCarPlanLocation`.`id`, `RsrCarPlanLocation`.`car_location_start` FROM `car_rental_rrs`.`car_plan_locations` AS `RsrCarPlanLocation` WHERE `RsrCarPlanLocation`.`car_plan_id` = 290 AND `RsrCarPlanLocation`.`car_location_start` = 245 AND `RsrCarPlanLocation`.`car_location_end` = 245 AND NOT (`RsrCarPlanLocation`.`car_location_price` IS NULL) AND `RsrCarPlanLocation`.`delete_type` = 0 LIMIT 1	0	0	0
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` = 290 AND `RsrCarPlanOption`.`delete_type` = 0 ORDER BY `RsrCarPlanOption`.`id` ASC	0	0	1	maybe slow

Query Explain:

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

====

Timer

Memory

Peak Memory Use 13.74 MB

Message	Memory use
Component initialization	4.20 MB
Controller action start	4.60 MB
Controller render start	10.71 MB
View render complete	12.29 MB

Timers

Total Request Time: 191 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	23.28
Event: Controller.initialize	0.07
Event: Controller.startup	0.30
Controller action	143.57
Event: Controller.beforeRender	2.21
» Processing toolbar data	2.12
Rendering View	5.50
» Event: View.beforeRender	0.02
» Rendering APP/View/Prefectures/plan.ctp	4.00
» Event: View.afterRender	0.02
» 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.17
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- seo
 titleアップルレンタカー那覇の「【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】」（アップルレンタカー那覇空港店）｜たびんふぉ
 keywords
 descriptionアップルレンタカー那覇の「【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】」（アップルレンタカー那覇空港店）の詳細ページ。沖縄県のレンタカーを比較・予約するなら【たびんふぉ】で。
 h1
 p
- data
 CarBrand
 id135
 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_codeapple_naha
 cmn_pref_ids47
 contact_tel
 car_brand_logo_image_path/img/upload/car_brand/apple_naha.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アップルレンタカーは、オリコン顧客満足度調査No.1※を獲得した車買取専門会社の老舗、アップルが提供するレンタカーサービスです！那覇空港より無料送迎を行っています。
 car_brand_cancel_policy<table class="table"> <tbody> <tr> <th>乗車日の7日以前</th> <td>無料</td> </tr> <tr> <th>乗車日の6～3日前</th> <td>基本料金の20%</td> </tr> <tr> <th>乗車日の2日前および前日</th> <td>基本料料金の30%</td> </tr> <tr> <th>乗車日当日以降</th> <td>基本料金の50%</td> </tr> </tbody> </table>
 car_brand_guarantee_system<table class="table"> <tbody><tr> <th>対人補償</th> <td>無制限</td> </tr> <tr> <th>対物補償</th> <td>無制限（免責額５万円）</td> </tr> <tr> <th>車両補償</th> <td>車両時価（免責額５万円）</td> </tr> <tr> <th>人身傷害補償</th> <td>3,000万円まで（一名につき　※1）</td> </tr> </tbody> </table> ※1　搭乗者の自動車事故によるケガ（死亡・後遺症を含む）につき、運転者の過失割合に関わらず、損害額を補償いたします。（限度額3,000万円：治療費を含む損害額は保険約款に定める基準に従い算出します。）
 car_brand_memo1_en(null)
 car_brand_memo1_cnh(null)
 car_brand_memo1_cnk(null)
 car_brand_memo1_ko(null)
 car_brand_reservation_codemc
 rensapo_type2
 rensapo_brand_id69
 rensapo_office_id0
 rensapo_url
 linked_rensapo_M1
 has_communication_tool1
 point_give_type2
 search_open_type0
 sort127
 is_jtb(null)
 jtb_sort1
 jtb_open_type1
 national_open_type1
 open_type0
 delete_type0
 modified2025-04-02 11:13:25
 created2023-12-25 19:05:36
 editor1
 author1
 ViewPlan
 rensapo_office_id245
 rensapo_class_id978
 rensapo_plan_id290
 pickup_flags
 flg_pickup_airport_national1
 plan_name【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】
 car_plan_memo■乗車定員：４名 ■推奨人数：１～２名 ■チャイルドシート設置可能数：２台 ■排気量：６６０ｃｃ ■燃料消費率：３３.４ｋｍ/Ｌ ＼安心の免責補償とNOC補償込みプラン♪／ 本プランで貸出しする車両は、年式がやや古い、走行距離が多い、カーナビが古い、Bluetooth接続不可、 車体にキズがあるなど、少々ワケありなクルマとなっておりますが走行には全く問題ありません◎ 安心安全＆コスパ重視のお客様は是非ご利用ください！ ◎色はお選びいただけません。 ◎店舗⇒空港へのお送りは19:45発が最終となります。 ※お支払いに現金は使用できません。 
 class_nameKHV
 office_nameアップルレンタカー那覇空港店
 car_max_member4
 reference_car_nameワゴンR　ハイブリッドFX
 smoke_type1
 plan_imghttps://car-rental.jp/img/upload/car_plan/290_detail.jpg
 car_brand_logo_image_pathhttps://tabinfo.jp/img/upload/car_brand/apple_naha.png
 car_type_id1
 car_type_name軽自動車
 hito2
 bag2
 listOffice
 営業所
 _(null)
 listOfficeE
 営業所
 __(null)
- office_time_list
 10:0010:00
 10:3010:30
 11:0011:00
 11:3011:30
 12:0012:00
 12:3012:30
 13:0013:00
 13:3013:30
 14:0014:00
 14:3014:30
 15:0015:00
 15:3015:30
 16:0016:00
 16:3016:30
 17:0017:00
 17:3017:30
 18:0018:00
- rensapo_brand_id69
- uniqid_token6809c226ea745
- data_airport
 0
 CmnAirportNational
 id11098
 cmn_airport_name那覇空港
 cmn_airport_codenaha-ap
 0
 COUNT(DISTINCT CmnAirportNational.id)1
 1
 CmnAirportNational
 id11105
 cmn_airport_name宮古空港
 cmn_airport_codemiyako-ap
 0
 COUNT(DISTINCT CmnAirportNational.id)1
 2
 CmnAirportNational
 id11106
 cmn_airport_name下地島空港
 cmn_airport_codeshimojishima-ap
 0
 COUNT(DISTINCT CmnAirportNational.id)1
 3
 CmnAirportNational
 id11108
 cmn_airport_name新石垣空港
 cmn_airport_codeishigaki-ap
 0
 COUNT(DISTINCT CmnAirportNational.id)1
- data_station
 0
 CmnStationNational
 id11047
 cmn_station_name赤嶺駅
 cmn_station_codeakamine-st
 0
 COUNT(*)2
- 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/okinawa.png
- url_pref_id47
- path
 0okinawa
 1apple_naha
 2plan
 3291
- $request->data
 Action
 prefecture_id
 dep_date2025-04-27
 arv_date2025-04-27
 dep_time09:00
 arv_time17:00
 type_id
- $this->validationErrors
 CmnPref(empty)
 CarBrand(empty)
 CarMaker(empty)
 CarOffice(empty)
 CarNationalSearchPlan(empty)
 CarClass(empty)
 CarModel(empty)
 CarType(empty)
 Kuchikomi(empty)
 KuchikomiRankNational(empty)
 CmnCity(empty)
 CmnStationNational(empty)
 CmnAirportNational(empty)
 CarSpecial(empty)
 CarOptionType(empty)
 CarFaqNational(empty)
 CmnSeoNational(empty)
 CarPlan(empty)
 RsOffice(empty)
 RsCarClass(empty)
 RsOptionHabtm(empty)
 RsOptionStock(empty)
 RsOption(empty)
 RsCar(empty)
 RsrCarPlan(empty)
 RsrCarPlanPriceType(empty)
 RsrCarClass(empty)
 RsrCarOffice(empty)
 RsrCarOption(empty)
 RsrCarOptionStock(empty)
 RsrCarPlanOption(empty)
 CarDatabase(empty)
 RsrCarPlanLocation(empty)
 RsrCarLocation(empty)
 RsrCarLocationPlace(empty)
 CarOptionSearch(empty)
- Loaded Helpers
 0Paginator
 1Number
 2SimpleGraph
 3DebugTimer
 4Toolbar
 5Html
 6Form
 7HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

Constant	Value
APP	/home/web-staff/apps/front_www/
APP_DIR	front_www
APPLIBS	/home/web-staff/apps/front_www/Lib/
CACHE	/home/web-staff/apps/front_www/tmp/cache/
CAKE	/home/web-staff/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/web-staff/lib
CORE_PATH	/home/web-staff/lib/
CAKE_VERSION	2.3.5
CSS	/home/web-staff/public_html/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://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	aAnCJk5fDtHJ7QihecVbvQABhRc
Redirect Http Authorization
Redirect Https	on
Redirect Ssl Tls Sni	tabinfo.jp
Redirect Http2	on
Redirect H2push	off
Redirect H2 Push	off
Redirect H2 Pushed
Redirect H2 Pushed On
Redirect H2 Stream Id	5
Redirect H2 Stream Tag	4108968-1573-5
Redirect Status	200
Unique Id	aAnCJk5fDtHJ7QihecVbvQABhRc
Http Authorization
Https	on
Ssl Tls Sni	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	d89646b8f0f64ea840871bd9d77ce5e6658d9b12e15e9f51464933a4d87288e2
Ssl Session Resumed	Initial
Http2	on
H2push	off
H2 Push	off
H2 Pushed
H2 Pushed On
H2 Stream Id	5
H2 Stream Tag	4108968-1573-5
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://tabinfo.jp/okinawa/apple_naha/plan/291
Http Cookie	CAKEPHP=s1mnsooupfje4r5tevl2mcn5k6
Http Host	tabinfo.jp
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	tabinfo.jp
Server Addr	10.0.0.184
Server Port	443
Remote Addr	3.22.208.84
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	60093
Redirect Url	/okinawa/apple_naha/plan/291/
Gateway Interface	CGI/1.1
Server Protocol	HTTP/2.0
Request Method	GET
Query String
Request Uri	/okinawa/apple_naha/plan/291/
Script Name	/index.php
Php Self	/index.php
Request Time Float	1745469990.7935
Request Time	1745469990

====

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

【免責/NOC込】ワケありだからお得◎ワゴンRハイブリッド｜禁煙｜那覇空港無料送迎あり！【キャッシュレス限定/現金不可】

レンタカーご予約内容

オプション選択

予約に関するご案内

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 6 ms Total Queries: 30 queries

Query Explain:

change_rensapo_reserve_db

Total Time: 1 ms Total Queries: 4 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 6 ms
Total Queries: 30 queries

Total Time: 1 ms
Total Queries: 4 queries