アルファードS"Cパッケージ｜禁煙｜那覇空港より無料送迎あり！【キャッシュレス限定/現金不可】

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

ETC車載器
カーナビ
禁煙車
Bluetooth
バックモニター
ドライブレコーダー
SDカード

■乗車定員：７名

■推奨人数：４～６名

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

■排気量：２,５００ｃｃ

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

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

【那覇空港→店舗】

お迎えは8:00～19:00まで到着のフライトとさせていただきます。

ご予約の際は必ずご利用便名をご入力ください。

未定の場合は、決まり次第ご連絡くださいますようお願いいたします。

※19:00以降の到着の場合お迎えはできかねます。予めご了承くださいませ。

【店舗→那覇空港】

毎時15分と45分発でお送りさせていただきます。（始発8:15、最終19:45）

◎那覇空港の他、沖縄都市モノレール線の赤嶺駅までの送迎も行なっております。

　詳細は店舗までお問い合わせください。

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

レンタカーご予約内容

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

出発

出発日時

出発場所

アップルレンタカー那覇空港店

返却

返却日時

返却場所

アップルレンタカー那覇空港店

台数

車両クラス：WFA[定員7名] 禁煙車
代表車種：アルファードなど

1台

オプション選択

免責補償 (ワンボックス/RV/SUV) (1,980円): 在庫なし

ジュニアシート (1,100円): 在庫なし

チャイルドシート (1,100円): 在庫なし

ベビーシート (1,100円): 在庫なし

ETC車載器: 標準装備

カーナビ: 標準装備

禁煙車: 標準装備

Bluetooth: 標準装備

バックモニター: 標準装備

ドライブレコーダー: 標準装備

SDカード: 標準装備

NOC補償(ワンボックス/RV/SUV) (990円): 在庫なし

予約に関するご案内

キャンセルポリシー

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

補償制度

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

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

ご予約お見積り

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

台数: 1台 ---円

免責補償 (ワンボックス/RV/SUV): -- 台/ ---円
ジュニアシート: -- 台/ ---円
チャイルドシート: -- 台/ ---円
ベビーシート: -- 台/ ---円
ETC車載器: -- 台/ ---円
カーナビ: -- 台/ ---円
禁煙車: -- 台/ ---円
Bluetooth: -- 台/ ---円
バックモニター: -- 台/ ---円
ドライブレコーダー: -- 台/ ---円
SDカード: -- 台/ ---円
NOC補償(ワンボックス/RV/SUV): -- 台/ ---円

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

History
+
Request History
1 previous requests available
- Restore to current request
- okinawa/apple_naha/plan/290
====
Session
+
Session
- Config
  userAgentaf109b8469d612bfcc3d94a521fbc15f
  time1745480777
  countdown10
- uniqid_token6809b40a0b930
- 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> <p>※1　搭乗者の自動車事故によるケガ（死亡・後遺症を含む）につき、運転者の過失割合に関わらず、損害額を補償いたします。（限度額3,000万円：治療費を含む損害額は保険約款に定める基準に従い算出します。）</p>
  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_id984
  rensapo_plan_id289
  pickup_flags
  flg_pickup_airport_national1
  plan_nameアルファードS"Cパッケージ｜禁煙｜那覇空港より無料送迎あり！【キャッシュレス限定/現金不可】
  car_plan_memo<p>■乗車定員：７名<br /> ■推奨人数：４～６名<br /> ■チャイルドシート設置可能数：４台<br /> ■排気量：２,５００ｃｃ<br /> ■燃料消費率：１１.４ｋｍ/Ｌ</p> <p><br /> ◎色はお選びいただけません。<br /> <br /> 【那覇空港→店舗】<br /> お迎えは8:00～19:00まで到着のフライトとさせていただきます。<br /> ご予約の際は必ずご利用便名をご入力ください。<br /> 未定の場合は、決まり次第ご連絡くださいますようお願いいたします。<br /> ※19:00以降の到着の場合お迎えはできかねます。予めご了承くださいませ。<br /> <br /> 【店舗→那覇空港】<br /> 毎時15分と45分発でお送りさせていただきます。（始発8:15、最終19:45）<br /> <br /> ◎那覇空港の他、沖縄都市モノレール線の赤嶺駅までの送迎も行なっております。<br /> 　詳細は店舗までお問い合わせください。</p> <p> </p> <p>※お支払いに現金は使用できません。</p>
  class_nameWFA
  office_nameアップルレンタカー那覇空港店
  car_max_member7
  reference_car_nameアルファード
  smoke_type1
  plan_imghttps://car-rental.jp/img/upload/car_plan/289_detail.jpg
  car_brand_logo_image_pathhttps://tabinfo.jp/img/upload/car_brand/apple_naha.png
  car_type_id8
  car_type_nameワンボックス
  hito6
  bag3
  listOffice
  営業所
  214_245アップルレンタカー那覇空港店
  start_time08:00:00
  listOfficeE
  営業所
  214_245_125211アップルレンタカー那覇空港店
  end_time20:00:00
  CarPlanOption
  508
  CarPlanOption
  id12062
  car_plan_id289
  car_option_id508
  car_plan_option_type1
  sort12
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id508
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_name免責補償 (ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price11980
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price1980
  car_option_unit個
  car_option_max_lease1
  car_option_stock_type2
  sort7
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:52:30
  editor164
  author164
  Option
  id508
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_name免責補償 (ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price11980
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price1980
  car_option_unit個
  car_option_max_lease1
  car_option_stock_type2
  sort7
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:52:30
  editor164
  author164
  506
  CarPlanOption
  id12063
  car_plan_id289
  car_option_id506
  car_plan_option_type1
  sort9
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id506
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id21
  car_option_nameジュニアシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort5
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:58
  editor(null)
  author164
  Option
  id506
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id21
  car_option_nameジュニアシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort5
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:58
  editor(null)
  author164
  505
  CarPlanOption
  id12064
  car_plan_id289
  car_option_id505
  car_plan_option_type1
  sort10
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id505
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id4
  car_option_nameチャイルドシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort4
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:27
  editor(null)
  author164
  Option
  id505
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id4
  car_option_nameチャイルドシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort4
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:27
  editor(null)
  author164
  504
  CarPlanOption
  id12065
  car_plan_id289
  car_option_id504
  car_plan_option_type1
  sort8
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id504
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id17
  car_option_nameベビーシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort3
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:36:21
  editor164
  author164
  Option
  id504
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id17
  car_option_nameベビーシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort3
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:36:21
  editor164
  author164
  503
  CarPlanOption
  id12066
  car_plan_id289
  car_option_id503
  car_plan_option_type2
  sort7
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id503
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id3
  car_option_nameETC車載器
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price10
  car_option_price20
  car_option_price30
  car_option_price40
  car_option_price50
  car_option_price60
  car_option_plus_price0
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort2
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:34:28
  editor(null)
  author164
  Option
  id503
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id3
  car_option_nameETC車載器
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price10
  car_option_price20
  car_option_price30
  car_option_price40
  car_option_price50
  car_option_price60
  car_option_plus_price0
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort2
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:34:28
  editor(null)
  author164
  499
  CarPlanOption
  id12067
  car_plan_id289
  car_option_id499
  car_plan_option_type2
  sort6
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id499
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameカーナビ
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  modified2024-06-15 20:20:12
  created2019-09-20 15:55:20
  editor164
  author164
  Option
  id499
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameカーナビ
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  modified2024-06-15 20:20:12
  created2019-09-20 15:55:20
  editor164
  author164
  510
  CarPlanOption
  id12295
  car_plan_id289
  car_option_id510
  car_plan_option_type2
  sort4
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-25 18:54:20
  editor164
  author164
  CarOption
  id510
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id6
  car_option_name禁煙車
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort8
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-25 18:52:12
  editor(null)
  author164
  Option
  id510
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id6
  car_option_name禁煙車
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort8
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-25 18:52:12
  editor(null)
  author164
  516
  CarPlanOption
  id37154
  car_plan_id289
  car_option_id516
  car_plan_option_type2
  sort5
  delete_type0
  modified2024-06-15 20:30:51
  created2020-01-23 16:32:50
  editor164
  author164
  CarOption
  id516
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameBluetooth
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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_lease0
  car_option_stock_type2
  sort9
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-01-23 16:29:41
  editor(null)
  author164
  Option
  id516
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameBluetooth
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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_lease0
  car_option_stock_type2
  sort9
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-01-23 16:29:41
  editor(null)
  author164
  674
  CarPlanOption
  id40277
  car_plan_id289
  car_option_id674
  car_plan_option_type2
  sort3
  delete_type0
  modified2024-06-15 20:30:51
  created2022-03-24 16:37:45
  editor164
  author164
  CarOption
  id674
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameバックモニター
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort24
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:19
  editor(null)
  author164
  Option
  id674
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameバックモニター
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort24
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:19
  editor(null)
  author164
  673
  CarPlanOption
  id40278
  car_plan_id289
  car_option_id673
  car_plan_option_type2
  sort2
  delete_type0
  modified2024-06-15 20:30:51
  created2022-03-24 16:37:45
  editor164
  author164
  CarOption
  id673
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameドライブレコーダー
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort23
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:04
  editor(null)
  author164
  Option
  id673
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameドライブレコーダー
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort23
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:04
  editor(null)
  author164
  670
  CarPlanOption
  id40279
  car_plan_id289
  car_option_id670
  car_plan_option_type2
  sort1
  delete_type0
  modified2024-06-15 20:30:51
  created2022-03-24 16:37:45
  editor164
  author164
  CarOption
  id670
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameSDカード
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort20
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:13:05
  editor(null)
  author164
  Option
  id670
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameSDカード
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort20
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:13:05
  editor(null)
  author164
  519
  CarPlanOption
  id47732
  car_plan_id289
  car_option_id519
  car_plan_option_type1
  sort11
  delete_type0
  modified2024-06-15 20:30:51
  created2024-06-15 20:30:51
  editor164
  author164
  CarOption
  id519
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_nameNOC補償(ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price1990
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price990
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort11
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-03-04 08:33:23
  editor164
  author164
  Option
  id519
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_nameNOC補償(ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price1990
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price990
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort11
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-03-04 08:33:23
  editor164
  author164
====
Request
+
Request

Cake Params
- plugin(null)
- controllerPrefectures
- actionindex
- named(empty)
- pass
  0okinawa
  1apple_naha
  2plan
  3290
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: 11 ms
Total Queries: 62 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` = 290 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/290/' 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` = 290 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 `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` = 93	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` = (508)	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` = 93	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` = (506)	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` = 93	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` = (505)	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` = 93	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` = (504)	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` = 93	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` = (503)	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` = 93	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` = (499)	427	427	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` = 93	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` = (510)	884	884	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` = 93	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` = (516)	397	397	5
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` = 93	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` = (674)	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` = 93	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` = (673)	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` = 93	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` = (670)	0	0	1	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` = 93	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` = (519)	397	397	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	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/290/' 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: 4 ms
Total Queries: 14 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` = 984 AND `RsrCarClass`.`delete_type` = 0 ORDER BY `RsrCarClass`.`id` ASC LIMIT 1	1	1	0
SELECT `RsrCarPlanOption`.`id`, `RsrCarPlanOption`.`car_plan_id`, `RsrCarPlanOption`.`car_option_id`, `RsrCarPlanOption`.`car_plan_option_type`, `RsrCarPlanOption`.`sort`, `RsrCarPlanOption`.`delete_type`, `RsrCarPlanOption`.`modified`, `RsrCarPlanOption`.`created`, `RsrCarPlanOption`.`editor`, `RsrCarPlanOption`.`author`, `RsrCarOption`.`id`, `RsrCarOption`.`car_brand_id`, `RsrCarOption`.`car_group_id`, `RsrCarOption`.`car_office_id`, `RsrCarOption`.`car_option_type_id`, `RsrCarOption`.`car_option_name`, `RsrCarOption`.`car_option_name_en`, `RsrCarOption`.`car_option_name_cnh`, `RsrCarOption`.`car_option_name_cnk`, `RsrCarOption`.`car_option_name_ko`, `RsrCarOption`.`car_option_sub_name`, `RsrCarOption`.`car_option_sub_name_en`, `RsrCarOption`.`car_option_sub_name_cnh`, `RsrCarOption`.`car_option_sub_name_cnk`, `RsrCarOption`.`car_option_sub_name_ko`, `RsrCarOption`.`car_option_lease_type`, `RsrCarOption`.`car_option_price1`, `RsrCarOption`.`car_option_price2`, `RsrCarOption`.`car_option_price3`, `RsrCarOption`.`car_option_price4`, `RsrCarOption`.`car_option_price5`, `RsrCarOption`.`car_option_price6`, `RsrCarOption`.`car_option_plus_price`, `RsrCarOption`.`car_option_unit`, `RsrCarOption`.`car_option_max_lease`, `RsrCarOption`.`car_option_stock_type`, `RsrCarOption`.`sort`, `RsrCarOption`.`open_type`, `RsrCarOption`.`is_jtb`, `RsrCarOption`.`jtb_sort`, `RsrCarOption`.`jtb_open_type`, `RsrCarOption`.`delete_type`, `RsrCarOption`.`modified`, `RsrCarOption`.`created`, `RsrCarOption`.`editor`, `RsrCarOption`.`author` FROM `car_rental_rrs`.`car_plan_options` AS `RsrCarPlanOption` LEFT JOIN `car_rental_rrs`.`car_options` AS `RsrCarOption` ON (`RsrCarPlanOption`.`car_option_id` = `RsrCarOption`.`id`) WHERE `RsrCarPlanOption`.`car_plan_id` = 289 AND `RsrCarPlanOption`.`delete_type` = 0 ORDER BY `RsrCarPlanOption`.`id` ASC	12	12	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` = 508 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` = 506 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` = 505 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` = 504 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` = 503 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` = 499 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` = 510 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` = 516 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	1
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` = 674 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` = 673 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	1
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` = 670 AND `RsrCarOption`.`delete_type` = 0 LIMIT 1	1	1	1
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` = 519 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.24 MB

Message	Memory use
Component initialization	4.20 MB
Controller action start	4.60 MB
Controller render start	10.75 MB
View render complete	12.51 MB

Timers

Total Request Time: 341 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	26.36
Event: Controller.initialize	0.05
Event: Controller.startup	0.21
Controller action	266.16
Event: Controller.beforeRender	3.42
» Processing toolbar data	3.33
Rendering View	7.77
» Event: View.beforeRender	0.02
» Rendering APP/View/Prefectures/plan.ctp	6.17
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	1.02
» » 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アップルレンタカー那覇の「アルファードS"Cパッケージ｜禁煙｜那覇空港より無料送迎あり！【キャッシュレス限定/現金不可】」（アップルレンタカー那覇空港店）｜たびんふぉ
  keywords
  descriptionアップルレンタカー那覇の「アルファードS"Cパッケージ｜禁煙｜那覇空港より無料送迎あり！【キャッシュレス限定/現金不可】」（アップルレンタカー那覇空港店）の詳細ページ。沖縄県のレンタカーを比較・予約するなら【たびんふぉ】で。
  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> <p>※1　搭乗者の自動車事故によるケガ（死亡・後遺症を含む）につき、運転者の過失割合に関わらず、損害額を補償いたします。（限度額3,000万円：治療費を含む損害額は保険約款に定める基準に従い算出します。）</p>
  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_id984
  rensapo_plan_id289
  pickup_flags
  flg_pickup_airport_national1
  plan_nameアルファードS"Cパッケージ｜禁煙｜那覇空港より無料送迎あり！【キャッシュレス限定/現金不可】
  car_plan_memo<p>■乗車定員：７名<br /> ■推奨人数：４～６名<br /> ■チャイルドシート設置可能数：４台<br /> ■排気量：２,５００ｃｃ<br /> ■燃料消費率：１１.４ｋｍ/Ｌ</p> <p><br /> ◎色はお選びいただけません。<br /> <br /> 【那覇空港→店舗】<br /> お迎えは8:00～19:00まで到着のフライトとさせていただきます。<br /> ご予約の際は必ずご利用便名をご入力ください。<br /> 未定の場合は、決まり次第ご連絡くださいますようお願いいたします。<br /> ※19:00以降の到着の場合お迎えはできかねます。予めご了承くださいませ。<br /> <br /> 【店舗→那覇空港】<br /> 毎時15分と45分発でお送りさせていただきます。（始発8:15、最終19:45）<br /> <br /> ◎那覇空港の他、沖縄都市モノレール線の赤嶺駅までの送迎も行なっております。<br /> 　詳細は店舗までお問い合わせください。</p> <p> </p> <p>※お支払いに現金は使用できません。</p>
  class_nameWFA
  office_nameアップルレンタカー那覇空港店
  car_max_member7
  reference_car_nameアルファード
  smoke_type1
  plan_imghttps://car-rental.jp/img/upload/car_plan/289_detail.jpg
  car_brand_logo_image_pathhttps://tabinfo.jp/img/upload/car_brand/apple_naha.png
  car_type_id8
  car_type_nameワンボックス
  hito6
  bag3
  listOffice
  営業所
  214_245アップルレンタカー那覇空港店
  start_time08:00:00
  listOfficeE
  営業所
  214_245_125211アップルレンタカー那覇空港店
  end_time20:00:00
  CarPlanOption
  508
  CarPlanOption
  id12062
  car_plan_id289
  car_option_id508
  car_plan_option_type1
  sort12
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id508
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_name免責補償 (ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price11980
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price1980
  car_option_unit個
  car_option_max_lease1
  car_option_stock_type2
  sort7
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:52:30
  editor164
  author164
  Option
  id508
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_name免責補償 (ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price11980
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price1980
  car_option_unit個
  car_option_max_lease1
  car_option_stock_type2
  sort7
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:52:30
  editor164
  author164
  506
  CarPlanOption
  id12063
  car_plan_id289
  car_option_id506
  car_plan_option_type1
  sort9
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id506
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id21
  car_option_nameジュニアシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort5
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:58
  editor(null)
  author164
  Option
  id506
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id21
  car_option_nameジュニアシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort5
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:58
  editor(null)
  author164
  505
  CarPlanOption
  id12064
  car_plan_id289
  car_option_id505
  car_plan_option_type1
  sort10
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id505
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id4
  car_option_nameチャイルドシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort4
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:27
  editor(null)
  author164
  Option
  id505
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id4
  car_option_nameチャイルドシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort4
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:37:27
  editor(null)
  author164
  504
  CarPlanOption
  id12065
  car_plan_id289
  car_option_id504
  car_plan_option_type1
  sort8
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id504
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id17
  car_option_nameベビーシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort3
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:36:21
  editor164
  author164
  Option
  id504
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id17
  car_option_nameベビーシート
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type2
  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_lease5
  car_option_stock_type2
  sort3
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:36:21
  editor164
  author164
  503
  CarPlanOption
  id12066
  car_plan_id289
  car_option_id503
  car_plan_option_type2
  sort7
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id503
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id3
  car_option_nameETC車載器
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price10
  car_option_price20
  car_option_price30
  car_option_price40
  car_option_price50
  car_option_price60
  car_option_plus_price0
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort2
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:34:28
  editor(null)
  author164
  Option
  id503
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id3
  car_option_nameETC車載器
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price10
  car_option_price20
  car_option_price30
  car_option_price40
  car_option_price50
  car_option_price60
  car_option_plus_price0
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort2
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-08 18:34:28
  editor(null)
  author164
  499
  CarPlanOption
  id12067
  car_plan_id289
  car_option_id499
  car_plan_option_type2
  sort6
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-24 18:02:30
  editor164
  author164
  CarOption
  id499
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameカーナビ
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  modified2024-06-15 20:20:12
  created2019-09-20 15:55:20
  editor164
  author164
  Option
  id499
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameカーナビ
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  modified2024-06-15 20:20:12
  created2019-09-20 15:55:20
  editor164
  author164
  510
  CarPlanOption
  id12295
  car_plan_id289
  car_option_id510
  car_plan_option_type2
  sort4
  delete_type0
  modified2024-06-15 20:30:51
  created2019-10-25 18:54:20
  editor164
  author164
  CarOption
  id510
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id6
  car_option_name禁煙車
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort8
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-25 18:52:12
  editor(null)
  author164
  Option
  id510
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id6
  car_option_name禁煙車
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort8
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2019-10-25 18:52:12
  editor(null)
  author164
  516
  CarPlanOption
  id37154
  car_plan_id289
  car_option_id516
  car_plan_option_type2
  sort5
  delete_type0
  modified2024-06-15 20:30:51
  created2020-01-23 16:32:50
  editor164
  author164
  CarOption
  id516
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameBluetooth
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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_lease0
  car_option_stock_type2
  sort9
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-01-23 16:29:41
  editor(null)
  author164
  Option
  id516
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id2
  car_option_nameBluetooth
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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_lease0
  car_option_stock_type2
  sort9
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-01-23 16:29:41
  editor(null)
  author164
  674
  CarPlanOption
  id40277
  car_plan_id289
  car_option_id674
  car_plan_option_type2
  sort3
  delete_type0
  modified2024-06-15 20:30:51
  created2022-03-24 16:37:45
  editor164
  author164
  CarOption
  id674
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameバックモニター
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort24
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:19
  editor(null)
  author164
  Option
  id674
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameバックモニター
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort24
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:19
  editor(null)
  author164
  673
  CarPlanOption
  id40278
  car_plan_id289
  car_option_id673
  car_plan_option_type2
  sort2
  delete_type0
  modified2024-06-15 20:30:51
  created2022-03-24 16:37:45
  editor164
  author164
  CarOption
  id673
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameドライブレコーダー
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort23
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:04
  editor(null)
  author164
  Option
  id673
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameドライブレコーダー
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort23
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:15:04
  editor(null)
  author164
  670
  CarPlanOption
  id40279
  car_plan_id289
  car_option_id670
  car_plan_option_type2
  sort1
  delete_type0
  modified2024-06-15 20:30:51
  created2022-03-24 16:37:45
  editor164
  author164
  CarOption
  id670
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameSDカード
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort20
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:13:05
  editor(null)
  author164
  Option
  id670
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id19
  car_option_nameSDカード
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  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
  sort20
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2022-03-24 16:13:05
  editor(null)
  author164
  519
  CarPlanOption
  id47732
  car_plan_id289
  car_option_id519
  car_plan_option_type1
  sort11
  delete_type0
  modified2024-06-15 20:30:51
  created2024-06-15 20:30:51
  editor164
  author164
  CarOption
  id519
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_nameNOC補償(ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price1990
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price990
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort11
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-03-04 08:33:23
  editor164
  author164
  Option
  id519
  car_brand_id69
  car_group_id93
  car_office_id(null)
  car_option_type_id33
  car_option_nameNOC補償(ワンボックス/RV/SUV)
  car_option_name_en(null)
  car_option_name_cnh(null)
  car_option_name_cnk(null)
  car_option_name_ko(null)
  car_option_sub_name
  car_option_sub_name_en(null)
  car_option_sub_name_cnh(null)
  car_option_sub_name_cnk(null)
  car_option_sub_name_ko(null)
  car_option_lease_type1
  car_option_price1990
  car_option_price2(null)
  car_option_price3(null)
  car_option_price4(null)
  car_option_price5(null)
  car_option_price6(null)
  car_option_plus_price990
  car_option_unit台
  car_option_max_lease1
  car_option_stock_type2
  sort11
  open_type1
  is_jtb(null)
  jtb_sort1
  jtb_open_type0
  delete_type0
  modified2024-06-15 20:20:12
  created2020-03-04 08:33:23
  editor164
  author164
- office_time_list
  08:0008:00
  08:3008:30
  09:0009:00
  09:3009:30
  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
  18:3018:30
  19:0019:00
  19:3019:30
  20:0020:00
- rensapo_brand_id69
- uniqid_token6809b40a0b930
- 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
  3290
- $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)
  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://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	aAm0CTthHiGd2RiupKzBzAAADhw
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	3107318-24818-5
Redirect Status	200
Unique Id	aAm0CTthHiGd2RiupKzBzAAADhw
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	eed9edf46c034556c852f9145d6a44428e65d0e82d064eb40e108ba4bd5fa875
Ssl Session Resumed	Initial
Http2	on
H2push	off
H2 Push	off
H2 Pushed
H2 Pushed On
H2 Stream Id	5
H2 Stream Tag	3107318-24818-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/290
Http Cookie	CAKEPHP=991tks8p9hoae4ri7jo0eep6q1
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	18.191.212.175
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	4300
Redirect Url	/okinawa/apple_naha/plan/290/
Gateway Interface	CGI/1.1
Server Protocol	HTTP/2.0
Request Method	GET
Query String
Request Uri	/okinawa/apple_naha/plan/290/
Script Name	/index.php
Php Self	/index.php
Request Time Float	1745466377.7548
Request Time	1745466377

====

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

アルファードS"Cパッケージ｜禁煙｜那覇空港より無料送迎あり！【キャッシュレス限定/現金不可】

レンタカーご予約内容

オプション選択

予約に関するご案内

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 11 ms Total Queries: 62 queries

Query Explain:

change_rensapo_reserve_db

Total Time: 4 ms Total Queries: 14 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 11 ms
Total Queries: 62 queries

Total Time: 4 ms
Total Queries: 14 queries