JAPAN ROAD TRIP
北海道エリア
- 住所
- 北海道苫小牧市美沢261-56
- 電話番号
- 03-6777-6565
- 営業時間
-
- 月10:00～19:00
- 火10:00～19:00
- 水10:00～19:00
- 木10:00～19:00
- 金10:00～19:00
- 土10:00～19:00
- 日10:00～19:00
JAPAN ROAD TRIP 北海道エリア出発のプラン
現在、ご予約いただけるプランはございません。
JAPAN ROAD TRIP
現在、ご予約いただけるプランはございません。
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code`, `CmnPref`.`cmn_pref_image_path` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` WHERE `CmnPref`.`cmn_pref_code` = 'hokkaido' AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `KuchikomiRankNational`.`created` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarBrand`.`id`, `CarBrand`.`cmn_pref_ids`, `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`car_brand_code` = 'japan_road_trip' AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `CarMaker`.`car_maker_code`, `CarMaker`.`id`, `CarMaker`.`car_maker_name` FROM `tabinfo_rentacar`.`car_makers` AS `CarMaker` WHERE `CarMaker`.`car_maker_code` = 'japan_road_trip' AND FIND_IN_SET('1', CarMaker.cmn_pref_ids) AND `CarMaker`.`delete_type` = 0 AND `CarMaker`.`open_type` = 1 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CarSpecial`.`id`, `CarSpecial`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_specials` AS `CarSpecial` WHERE `CarSpecial`.`car_special_code` = 'japan_road_trip' AND FIND_IN_SET('1', CarSpecial.cmn_pref_ids) AND `CarSpecial`.`national_open_type` = 1 AND `CarSpecial`.`delete_type` = 0 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CarOffice`.`id`, `CarOffice`.`car_brand_id`, `CarOffice`.`car_office_name` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 429 AND `CarOffice`.`cmn_pref_id` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CmnSeoNational`.`title`, `CmnSeoNational`.`keywords`, `CmnSeoNational`.`description`, `CmnSeoNational`.`h1`, `CmnSeoNational`.`p` FROM `tabinfo_rentacar`.`cmn_seo_nationals` AS `CmnSeoNational` WHERE `url` = '/hokkaido/japan_road_trip/429/' 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` = '/*/*/*/' AND `delete_type` = 0 AND ((`page_type` = '') OR (`page_type` = 'pref_office')) LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarBrand`.`car_brand_name` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE `CarBrand`.`id` = 151 AND FIND_IN_SET('1', CarBrand.cmn_pref_ids) AND `CarBrand`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarOffice`.`id`, `CarOffice`.`car_office_name`, `CarOffice`.`car_office_image1_path`, `CarOffice`.`car_office_image2_path`, `CarOffice`.`car_office_image3_path`, `CarOffice`.`car_office_image4_path`, `CarOffice`.`car_office_image5_path`, `CarOffice`.`address`, `CarOffice`.`phone1`, `CarOffice`.`phone2`, `CarOffice`.`phone3`, `CarOffice`.`car_office_memo1`, `CarOffice`.`car_office_memo2`, `CarOffice`.`car_office_memo3`, `CarOffice`.`car_office_memo4`, `CarOffice`.`car_office_map_latitude`, `CarOffice`.`car_office_map_longitude`, `CarOffice`.`0_is_open`, `CarOffice`.`0_open`, `CarOffice`.`0_closed`, `CarOffice`.`1_is_open`, `CarOffice`.`1_open`, `CarOffice`.`1_closed`, `CarOffice`.`2_is_open`, `CarOffice`.`2_open`, `CarOffice`.`2_closed`, `CarOffice`.`3_is_open`, `CarOffice`.`3_open`, `CarOffice`.`3_closed`, `CarOffice`.`4_is_open`, `CarOffice`.`4_open`, `CarOffice`.`4_closed`, `CarOffice`.`5_is_open`, `CarOffice`.`5_open`, `CarOffice`.`5_closed`, `CarOffice`.`6_is_open`, `CarOffice`.`6_open`, `CarOffice`.`6_closed`, `CmnStationNational`.`cmn_station_name`, `CmnPref`.`cmn_pref_name`, `CmnCity`.`cmn_city_name` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` LEFT JOIN `tabinfo_rentacar`.`cmn_station_nationals` AS `CmnStationNational` ON (FIND_IN_SET(`CmnStationNational`.`id`, `CarOffice`.`cmn_station_ids`) <> 0 AND `CmnStationNational`.`open_type` = 1 AND `CmnStationNational`.`delete_type` = 0) LEFT JOIN `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` ON (`CmnPref`.`id` = `CarOffice`.`cmn_pref_id` AND `CmnPref`.`open_type` = 1 AND `CmnPref`.`delete_type` = 0) LEFT JOIN `tabinfo_rentacar`.`cmn_cities` AS `CmnCity` ON (`CmnCity`.`id` = `CarOffice`.`cmn_city_id` AND `CmnCity`.`open_type` = 1 AND `CmnCity`.`delete_type` = 0) WHERE `CarOffice`.`id` = 429 AND `CarOffice`.`car_brand_id` = 151 AND `CarOffice`.`cmn_pref_id` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 LIMIT 1 | 1 | 1 | 5 | maybe slow |
| SELECT `CarOffice`.`car_office_start_time`, `CarOffice`.`car_office_end_time`, `CarOffice`.`id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`id` = 429 AND `CarOffice`.`car_brand_id` = 151 AND `CarOffice`.`cmn_pref_id` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarOffice`.`open_type` = 1 | 1 | 1 | 0 | |
| SELECT `CarOfficeHoliday`.`start_day`, `CarOfficeHoliday`.`end_day`, `CarOfficeHoliday`.`car_office_id` FROM `tabinfo_rentacar`.`car_office_holidays` AS `CarOfficeHoliday` WHERE `CarOfficeHoliday`.`is_delete` = '0' AND `CarOfficeHoliday`.`car_office_id` = (429) | 0 | 0 | 0 | |
| SELECT `CarOfficeOpen`.`start_day`, `CarOfficeOpen`.`start_time`, `CarOfficeOpen`.`end_day`, `CarOfficeOpen`.`end_time`, `CarOfficeOpen`.`car_office_id` FROM `tabinfo_rentacar`.`car_office_opens` AS `CarOfficeOpen` WHERE `CarOfficeOpen`.`is_delete` = '0' AND `CarOfficeOpen`.`car_office_id` = (429) | 0 | 0 | 0 | |
| SELECT `Kuchikomi`.`id`, `Kuchikomi`.`car_brand_code`, `Kuchikomi`.`rating_gender`, `Kuchikomi`.`rating_age`, `Kuchikomi`.`rating_comment`, `Kuchikomi`.`rating_overall`, `Kuchikomi`.`created`, `CarBrand`.`car_brand_name`, `CarBrand`.`id` FROM `tabinfo_rentacar`.`kuchikomis` AS `Kuchikomi` LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`Kuchikomi`.`car_brand_id` = `CarBrand`.`id`) WHERE `Kuchikomi`.`cmn_pref_id` = 1 AND `Kuchikomi`.`car_brand_id` = 151 AND `Kuchikomi`.`car_office_id` = 429 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `Kuchikomi`.`is_display` = 1 ORDER BY `Kuchikomi`.`id` DESC LIMIT 10 | 0 | 0 | 4 | maybe slow |
| SELECT `KuchikomiRankNational`.`rating_overall`, `KuchikomiRankNational`.`rating_service`, `KuchikomiRankNational`.`rating_shop`, `KuchikomiRankNational`.`rating_car`, `KuchikomiRankNational`.`rating_cost`, `KuchikomiRankNational`.`rating_smooth`, `KuchikomiRankNational`.`kuchikomi_count` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`car_brand_id` = 151 AND `KuchikomiRankNational`.`car_office_id` = 429 AND `KuchikomiRankNational`.`is_delete` = 0 LIMIT 1 | 0 | 0 | 15 | maybe slow |
| SELECT `CarFaqNational`.`id`, `CarFaqNational`.`car_faq_title`, `CarFaqNational`.`top_open_type`, `CarFaqNational`.`pref_open_type`, `CarFaqNational`.`cmn_pref_ids` FROM `tabinfo_rentacar`.`car_faq_nationals` AS `CarFaqNational` WHERE ((((`CarFaqNational`.`top_open_type` = 1) AND (`CarFaqNational`.`pref_open_type` = 1) AND (FIND_IN_SET('1', CarFaqNational.cmn_pref_ids)))) OR (((`CarFaqNational`.`top_open_type` = 1) AND (`CarFaqNational`.`pref_open_type` = 0) AND (((`CarFaqNational`.`cmn_pref_ids` = '') OR (`CarFaqNational`.`cmn_pref_ids` IS NULL)))))) AND `CarFaqNational`.`delete_type` = 0 AND `CarFaqNational`.`open_type` = 1 ORDER BY ( CASE WHEN `CarFaqNational`.`top_open_type` = 1 AND `CarFaqNational`.`pref_open_type` = 1 AND FIND_IN_SET("1", `CarFaqNational`.`cmn_pref_ids`) THEN 1 WHEN `CarFaqNational`.`top_open_type` = 1 AND `CarFaqNational`.`pref_open_type` = 0 AND (`CarFaqNational`.`cmn_pref_ids` = "" OR `CarFaqNational`.`cmn_pref_ids` IS NULL) THEN 2 ELSE 3 END ) ASC, `sort` DESC LIMIT 10 | 7 | 7 | 0 | |
| SELECT `CarBrand`.*, `CarBrand`.`id` FROM `tabinfo_rentacar`.`car_brands` AS `CarBrand` WHERE NOT (`rensapo_type` = 0) AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 | 39 | 39 | 8 | maybe slow |
| SELECT `KuchikomiRankNational`.`rating_overall`, `KuchikomiRankNational`.`car_brand_id` FROM `tabinfo_rentacar`.`kuchikomi_rank_nationals` AS `KuchikomiRankNational` WHERE `KuchikomiRankNational`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 2 | 2 | 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 (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 47 | 47 | 0 | |
| SELECT `CarOffice`.`id`, `CarOffice`.`cmn_pref_id`, `CarOffice`.`rensapo_office_id`, `CarOffice`.`car_brand_id` FROM `tabinfo_rentacar`.`car_offices` AS `CarOffice` WHERE `CarOffice`.`cmn_pref_id` = 1 AND `CarOffice`.`car_brand_id` IN (64, 87, 95, 99, 102, 103, 104, 105, 106, 107, 108, 109, 116, 117, 118, 119, 120, 122, 123, 124, 127, 128, 134, 132, 135, 136, 137, 138, 139, 140, 142, 144, 145, 146, 150, 151, 153, 154, 163) | 12 | 12 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 99 AND `CarNationalSearchPlan`.`car_office_id` = 404 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 102 AND `CarNationalSearchPlan`.`car_office_id` = 330 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 102 AND `CarNationalSearchPlan`.`car_office_id` = 331 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 103 AND `CarNationalSearchPlan`.`car_office_id` = 400 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_brand_id` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 104 AND `CarNationalSearchPlan`.`car_office_id` = 385 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 106 AND `CarNationalSearchPlan`.`car_office_id` = 384 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 134 AND `CarNationalSearchPlan`.`car_office_id` = 337 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 138 AND `CarNationalSearchPlan`.`car_office_id` = 387 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_brand_id` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 140 AND `CarNationalSearchPlan`.`car_office_id` = 393 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_brand_id` FROM `tabinfo_rentacar`.`car_national_search_plans` AS `CarNationalSearchPlan` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CarNationalSearchPlan`.`car_office_id` = `CarOffice`.`id`) WHERE `CarNationalSearchPlan`.`car_brand_id` = 140 AND `CarNationalSearchPlan`.`car_office_id` = 394 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 150 AND `CarNationalSearchPlan`.`car_office_id` = 419 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 0 | 0 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 151 AND `CarNationalSearchPlan`.`car_office_id` = 429 AND `CarNationalSearchPlan`.`plan_open_type` = 1 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CarNationalSearchPlan`.`rensapo_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` = 151 AND `CarNationalSearchPlan`.`delete_type` = 0 AND `CarNationalSearchPlan`.`open_type` = 1 LIMIT 1 | 1 | 1 | 3 | maybe slow |
| SELECT DISTINCT `CmnAirportNational`.`id`, `CmnAirportNational`.`cmn_airport_name`, `CmnAirportNational`.`cmn_airport_code`, COUNT(DISTINCT CmnAirportNational.id) FROM `tabinfo_rentacar`.`cmn_airport_nationals` AS `CmnAirportNational` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (FIND_IN_SET(`CmnAirportNational`.`id`, `CarOffice`.`cmn_airport_ids`) <> 0) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CmnAirportNational`.`cmn_pref_id` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnAirportNational`.`delete_type` = 0 AND `CmnAirportNational`.`open_type` = 1 GROUP BY `CmnAirportNational`.`id` ORDER BY COUNT(*) DESC, `CmnAirportNational`.`id` ASC LIMIT 5 | 3 | 3 | 7 | maybe slow |
| SELECT DISTINCT `CmnStationNational`.`id`, `CmnStationNational`.`cmn_station_name`, `CmnStationNational`.`cmn_station_code`, COUNT(*) FROM `tabinfo_rentacar`.`cmn_station_nationals` AS `CmnStationNational` LEFT JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (FIND_IN_SET(`CmnStationNational`.`id`, `CarOffice`.`cmn_station_ids`) <> 0) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CmnStationNational`.`cmn_pref_id` = 1 AND `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnStationNational`.`delete_type` = 0 AND `CmnStationNational`.`open_type` = 1 GROUP BY `CmnStationNational`.`id` ORDER BY COUNT(*) DESC, `CmnStationNational`.`id` ASC LIMIT 5 | 3 | 3 | 0 | |
| SELECT `CmnPref`.`id`, `CmnPref`.`cmn_pref_name`, `CmnPref`.`cmn_pref_code` FROM `tabinfo_rentacar`.`cmn_prefs` AS `CmnPref` INNER JOIN `tabinfo_rentacar`.`car_offices` AS `CarOffice` ON (`CmnPref`.`id` = `CarOffice`.`cmn_pref_id`) LEFT JOIN `tabinfo_rentacar`.`car_brands` AS `CarBrand` ON (`CarBrand`.`id` = `CarOffice`.`car_brand_id`) WHERE `CarOffice`.`open_type` = 1 AND `CarOffice`.`delete_type` = 0 AND `CarBrand`.`national_open_type` = 1 AND `CarBrand`.`delete_type` = 0 AND `CmnPref`.`delete_type` = 0 AND `CmnPref`.`open_type` = 1 GROUP BY `CmnPref`.`cmn_pref_name` ORDER BY `CmnPref`.`id` ASC | 27 | 27 | 0 |
Peak Memory Use 16.39 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.20 MB |
| Controller action start | 4.60 MB |
| Controller render start | 9.87 MB |
| View render complete | 11.45 MB |
Total Request Time: 1610 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 1214.44 | |
| Event: Controller.initialize | 0.08 | |
| Event: Controller.startup | 0.33 | |
| Controller action | 352.07 | |
| Event: Controller.beforeRender | 6.84 | |
| » Processing toolbar data | 6.73 | |
| Rendering View | 14.88 | |
| » Event: View.beforeRender | 0.02 | |
| » Rendering APP/View/Prefectures/office.ctp | 13.24 | |
| » » Rendering APP/View/Elements/guide.ctp | 0.09 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/View/Layouts/default.ctp | 1.08 | |
| » » Rendering APP/View/Elements/analytics.ctp | 0.11 | |
| » » Rendering APP/View/Elements/pankuzu.ctp | 0.19 | |
| Event: View.afterLayout | 0.00 |
| 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 |
| 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/ |
| Environment Variable | Value |
|---|---|
| Php Version | 5.6.40 |
| User | apache |
| Home | /usr/share/httpd |
| Fcgi Role | RESPONDER |
| Redirect Unique Id | Z-4YCG91Kr1nSpv2SypsBwABFx4 |
| 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 | 1139794-27416-5 |
| Redirect Status | 200 |
| Unique Id | Z-4YCG91Kr1nSpv2SypsBwABFx4 |
| 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 | 55b80e69839c6325c44f1ea2bd734647223883603f8388ac24f388ab7d17ae08 |
| Ssl Session Resumed | Initial |
| Http2 | on |
| H2push | off |
| H2 Push | off |
| H2 Pushed | |
| H2 Pushed On | |
| H2 Stream Id | 5 |
| H2 Stream Tag | 1139794-27416-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/hokkaido/japan_road_trip/429 |
| Http Cookie | CAKEPHP=25d5djlinhvqt99p5hgug3lvg5 |
| Http Host | tabinfo.jp |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
| Server Signature | |
| Server Software | Apache |
| Server Name | tabinfo.jp |
| Server Addr | 10.0.0.184 |
| Server Port | 443 |
| Remote Addr | 3.14.251.87 |
| 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 | 27322 |
| Redirect Url | /hokkaido/japan_road_trip/429/ |
| Gateway Interface | CGI/1.1 |
| Server Protocol | HTTP/2.0 |
| Request Method | GET |
| Query String | |
| Request Uri | /hokkaido/japan_road_trip/429/ |
| Script Name | /index.php |
| Php Self | /index.php |
| Request Time Float | 1743656968.6258 |
| Request Time | 1743656968 |