HOME
中古車トップ
（株）ホンダカーズ帯広　西２１条店

（株）ホンダカーズ帯広　西２１条店

（株）ホンダカーズ帯広　西２１条店
☆ゴールデンウィーク休業のお知らせ☆２０２３／０４／２９〜２０２３／０５／０５まで、休業となります。
【展示場】カーセブン帯広店と合同展示しています！グループ会社なので、同じ価格でお買い求め頂けます♪
【サービス工場】安心の指定整備工場！ご購入後のアフターケアもお任せ下さい！！

店舗名	（株）ホンダカーズ帯広　西２１条店
住所	〒080-2471 北海道帯広市西二十一条南１丁目１５－１３
TEL	0078-6048-0776530
FAX	0155-36-3461
営業時間	９：３０〜１８：００
定休日	火曜日・水曜日
コメント	ディーラーならではの高品質車♪Ｈｏｎｄａ車のことは、当店にお任せ下さい！豊富な在庫の中から、あなたにピッタリの１台を見つけて下さい！

（株）ホンダカーズ帯広　西２１条店在庫情報

ホンダフィット

ｅ：ＨＥＶホーム　Ｒカメ　レーンキープアシスト　スマートキー＆プッシュスタート　パワーステアリング　ＬＥＤヘットライト　キーレスエントリー　サイドエアバック　フルセグＴＶ　パワーウインドウ　ナビＴ...

中古価格 218.5万円

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `KeywordDictionary`.`id`, `KeywordDictionary`.`title`, `KeywordDictionary`.`body_text` FROM `mfdb`.`tb_keyword_dictionary` AS `KeywordDictionary` WHERE `KeywordDictionary`.`delete_flg` = '0' AND `KeywordDictionary`.`public_flag` = '1' AND `KeywordDictionary`.`status` = 2 AND ((`KeywordDictionary`.`public_date` <= '2026-05-22') OR (`KeywordDictionary`.`public_date` IS NULL)) AND `KeywordDictionary`.`id` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` = 3) ORDER BY RAND() ASC LIMIT 3	3	3	1	maybe slow
SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`main_image_file_name`, `News`.`public_date`, `Group`.`group_name`, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', `ParentCategory`.`category_name` FROM `mfdb`.`tb_news` AS `News` LEFT JOIN `mfdb`.`tb_news_category` AS `ParentCategory` ON (`News`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`News`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`News`.`request_group_id` = `Group`.`id`) WHERE `News`.`delete_flg` = '0' AND `News`.`tech_flag` = '0' AND `News`.`public_flag` = '1' AND `News`.`status` = 2 AND `News`.`show_rank_flag` = 1 AND `News`.`public_status` = '1' ORDER BY `News`.`current_day_pv` DESC LIMIT 5	5	5	41	maybe slow
SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`tech_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`public_date`, `News`.`category_id`, `Group`.`group_name`, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', `ParentCategory`.`category_name`, `Category`.`category_name` FROM `mfdb`.`tb_news` AS `News` LEFT JOIN `mfdb`.`tb_news_category` AS `ParentCategory` ON (`News`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `mfdb`.`tb_news_category` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`News`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`News`.`request_group_id` = `Group`.`id`) WHERE `News`.`delete_flg` = '0' AND `News`.`public_flag` = '1' AND `News`.`status` = 2 AND `News`.`public_status` = '1' AND `News`.`id` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site` IN (1,2)) ORDER BY `News`.`current_day_pv` DESC LIMIT 10	10	10	1	maybe slow
SELECT DISTINCT `Catalog`.`brand_name`, `Catalog`.`car_name`, `Catalog`.`cat_id`, `Catalog`.`car_cd`, `Catalog`.`brand_name_en`, `Catalog`.`price`, `Catalog`.`photo_main` FROM `mfdb`.`tb_catalog_master` AS `Catalog` WHERE 1 = 1 ORDER BY `Catalog`.`year_cd` DESC LIMIT 8	8	8	2	maybe slow
SELECT `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `Car`.`car_nm`, `CarOther`.`min_price`, `CarOther`.`max_price`, `CarOther`.`image_path`, `Car`.`car_cd` FROM `mfdb`.`tb_car_master` AS `Car` LEFT JOIN `mfdb`.`tb_car_other` AS `CarOther` ON (`Car`.`car_cd` = `CarOther`.`car_cd`) LEFT JOIN `mfdb`.`tb_brand_master` AS `Brand` ON (`Car`.`brand_cd` = `Brand`.`brand_cd`) WHERE `Car`.`car_cd` IN (SELECT `tb_pickup`.`news_id` FROM tb_pickup WHERE `tb_pickup`.`delete_flg` = 0 AND `tb_pickup`.`site`=6) ORDER BY RAND() ASC LIMIT 8	5	5	1	maybe slow
SELECT `CarImage`.`id`, `CarImage`.`car_image_file_name`, `CarImage`.`car_cd` FROM `mfdb`.`tb_car_images` AS `CarImage` WHERE `CarImage`.`car_cd` IN (10452019, 10201018, 10052002, 10552002, 35201531)	26	26	0
SELECT `SerialStory`.`id`, `SerialStory`.`title`, `SerialStory`.`url_text`, `SerialStory`.`description`, `SerialStory`.`main_image_file_name`, `SerialStory`.`article_top_flag`, `SerialStory`.`article_detail_flag`, `SerialStory`.`tech_top_flag`, `SerialStory`.`tech_detail_flag`, `SerialStory`.`bikes_top_flag`, `SerialStory`.`bikes_detail_flag`, `SerialStory`.`sort_no`, `SerialStory`.`delete_flg`, `SerialStory`.`created`, `SerialStory`.`creator`, `SerialStory`.`modified`, `SerialStory`.`modifier` FROM `mfdb`.`tb_serial_stories` AS `SerialStory` WHERE `SerialStory`.`delete_flg` = '0' ORDER BY `SerialStory`.`sort_no` asc	28	28	0
SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1019 AND ((News.public_date <= '2026-05-22 22:31:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	1	maybe slow
SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1032 AND ((News.public_date <= '2026-05-22 22:31:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	1	maybe slow
SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1026 AND ((News.public_date <= '2026-05-22 22:31:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	0
SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1013 AND ((News.public_date <= '2026-05-22 22:31:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	0
SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1014 AND ((News.public_date <= '2026-05-22 22:31:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	1	maybe slow
SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1015 AND ((News.public_date <= '2026-05-22 22:31:12') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	0
SELECT `Brand`.`brand_cd`, `Brand`.`brand_nm`, `Brand`.`brand_nm_eng`, `BrandImage`.`brand_image_file_name` FROM `mfdb`.`tb_brand_master` AS `Brand` LEFT JOIN `mfdb`.`tb_brand_images` AS `BrandImage` ON (`Brand`.`brand_cd` = `BrandImage`.`id`) WHERE 1 = 1 ORDER BY `Brand`.`brand_cd` ASC	78	78	1

Message	Memory use
Component initialization	1.33 MB
Controller action start	2.65 MB
Controller render start	3.09 MB
View render complete	3.49 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	12.21
Event: Controller.initialize	130.93
Event: Controller.startup	0.66
Controller action	549.94
Event: Controller.beforeRender	30.13
» Processing toolbar data	30.06
Rendering View	11.11
» Event: View.beforeRender	0.02
» Rendering APP/View/Ucar/shop.ctp	2.75
» » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.97
» » Rendering APP/View/Elements/common/block_right_menu_service.ctp	0.11
» » Rendering APP/View/Elements/article/block_right_menu_ranking.ctp	0.20
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	5.12
» » Rendering APP/View/Elements/common_header.ctp	0.72
» » Rendering APP/View/Elements/ucar/top_menu.ctp	0.64
» » Rendering APP/View/Elements/common_footer.ctp	0.31
Event: View.afterLayout	0.00

Constant	Value
CONFIG	/var/www/html/staging/app/Config/
HISTORY_LOG	history_log

Constant	Value
APP	/var/www/html/staging/app/
APP_DIR	app
APPLIBS	/var/www/html/staging/app/Lib/
CACHE	/var/www/html/staging/app/tmp/cache/
CAKE	/var/www/html/staging/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/html/staging/lib
CORE_PATH	/var/www/html/staging/lib/
CAKE_VERSION	2.10.24
CSS	/var/www/html/staging/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://car-stg.motor-fan.jp
IMAGES	/var/www/html/staging/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/html/staging/app/webroot/js/
JS_URL	js/
LOGS	/var/www/html/staging/app/tmp/logs/
ROOT	/var/www/html/staging
TESTS	/var/www/html/staging/app/Test/
TMP	/var/www/html/staging/app/tmp/
VENDORS	/var/www/html/staging/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/html/staging/app/webroot/

Environment Variable	Value
Php Version	7.4.33
User	apache
Home	/usr/share/httpd
Script Name	/app/webroot/index.php
Request Uri	/ucar/shop/0300890
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/ucar/shop/0300890
Remote Port	50808
Script Filename	/var/www/html/staging/app/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/html/staging
Context Prefix
Request Scheme	https
Document Root	/var/www/html/staging
Remote Addr	216.73.216.60
Server Port	443
Server Addr	160.251.200.204
Server Name	car-stg.motor-fan.jp
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Host	car-stg.motor-fan.jp
Http Accept Encoding	gzip, br, zstd, deflate
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Proxy-nokeepalive	1
Ssl Tls Sni	car-stg.motor-fan.jp
Https	on
Unique Id	ahBaoDymCURKqRRMUlWxMgAAAQM
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	ahBaoDymCURKqRRMUlWxMgAAAQM
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	ahBaoDymCURKqRRMUlWxMgAAAQM
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1779456672.0526
Request Time	1779456672

（株）ホンダカーズ帯広 西２１条店

（株）ホンダカーズ帯広 西２１条店在庫情報

ホンダ フィット

ホンダ Ｎ－ＷＧＮ

スバル インプレッサスポーツハイブリッド

ホンダ フィットハイブリッド

スズキ アルト

ホンダ Ｎ－ＢＯＸカスタム

ホンダ Ｎ－ＢＯＸカスタム

ホンダ Ｎ－ＢＯＸカスタム

ホンダ Ｎ－ＢＯＸカスタム

ホンダ Ｎ－ＢＯＸカスタム

ホンダ フィット

ホンダ ＺＲ－Ｖ

ホンダ Ｎ－ＷＧＮカスタム

ホンダ フィット

ホンダ シビック

ダイハツ ムーヴキャンバス

ホンダ Ｎ－ＢＯＸ

ホンダ Ｎ－ＢＯＸカスタム

ホンダ フィット

ホンダ シビック

日産 ジューク

ホンダ フィットハイブリッド

ホンダ ライフ

ホンダ ライフ

ダイハツ タント

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 50 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: 50 ms
Total Queries: 14 queries