HOME
中古車トップ
（株）ホンダカーズ大分中央　花園店

（株）ホンダカーズ大分中央　花園店

（株）ホンダカーズ大分中央　花園店
ミニバン・ＳＵＶを中心に、新しく高品質な車両を展示してます。
開放感のある店内でごゆっくりお寛ぎ頂けます。お車のお悩みやご相談など何でも承ります。
こちらはキッズスペースとなっております。お子様連れの方でも安心してゆっくりと車選びが可能です。
ディーラーならではの品質と安心でお客様にご満足頂けるよう努力致します。是非ご来店ください。
車検や一般整備も承っております。ご購入後のアフターサービスが充実しておりますのでお尋ねください。

店舗名	（株）ホンダカーズ大分中央　花園店
住所	〒870-0846 大分県大分市花園２－１０－７
TEL	0078-6044-8701530
FAX	097-535-9888
営業時間	10:00〜18:00
定休日	毎週火・水曜日
コメント	広々とした開放感あふれ、ゆったりとお寛ぎいただけるショールーム。私たちが目指したのは、お車選びの時間そのものが「楽しみ」になるような場所です。

（株）ホンダカーズ大分中央　花園店在庫情報

ホンダＺＲ－Ｖ

ｅ：ＨＥＶＺ　純正ナビ／ＥＴＣ／マルチビュー／本革シート　衝突安全ボディ　ＥＳＣ　車線逸脱防止　シートＨ　スマ－トキ－　ＬＥＤライト　レザー　Ｂカメラ　運転席パワーシート　ＥＴＣ車載器　パワーステ...

中古価格 387.3万円

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-06-12') 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	56	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	0
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 (10552002, 10452019, 35201531, 10052002, 10201018)	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-06-12 13:47:40') 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-06-12 13:47:40') 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-06-12 13:47:40') 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-06-12 13:47:40') 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=1014 AND ((News.public_date <= '2026-06-12 13:47:40') 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-06-12 13:47:40') 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	2.49 MB
Controller action start	3.81 MB
Controller render start	4.32 MB
View render complete	4.72 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	13.14
Rendering View	432.29
» Event: Controller.initialize	116.93
» Event: Controller.startup	0.31
» Controller action	286.47
» Event: Controller.beforeRender	17.00
» » Processing toolbar data	16.91
Rendering View #2	0.00
» » Event: View.beforeRender	0.01
» » Rendering APP/View/Ucar/shop.ctp	2.17
» » » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.65
» » » Rendering APP/View/Elements/common/block_right_menu_service.ctp	0.07
» » » Rendering APP/View/Elements/article/block_right_menu_ranking.ctp	0.18
» » Event: View.afterRender	0.01
» » Event: View.beforeLayout	0.01
» » Rendering APP/View/Layouts/default.ctp	4.91
» » » Rendering APP/View/Elements/common_header.ctp	1.01
» » » Rendering APP/View/Elements/ucar/top_menu.ctp	0.60
» » » Rendering APP/View/Elements/common_footer.ctp	0.32
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/0803627
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/ucar/shop/0803627
Remote Port	38445
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.54
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	aiuPbMF7XqbIM-YvcszphQAAAEc
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	aiuPbMF7XqbIM-YvcszphQAAAEc
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	aiuPbMF7XqbIM-YvcszphQAAAEc
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1781239660.4679
Request Time	1781239660

（株）ホンダカーズ大分中央 花園店

（株）ホンダカーズ大分中央 花園店在庫情報

ホンダ ＺＲ－Ｖ

ホンダ Ｎ－ＢＯＸ

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

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

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ アコード

ホンダ Ｎ－ＯＮＥ

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ＺＲ－Ｖ

ホンダ ＺＲ－Ｖ

ホンダ Ｎ－ＶＡＮ＋スタイル

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ Ｎ－ＢＯＸ

ホンダ Ｎ－ＢＯＸ

ホンダ Ｎ－ＢＯＸ

ホンダ Ｎ－ＢＯＸ

ホンダ フリード

ホンダ フィット

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ヴェゼル

ホンダ ステップワゴンスパーダ

ホンダ オデッセイ

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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