HOME
中古車トップ
（株）ヤリミズ自動車　ＪＵ適正販売店

（株）ヤリミズ自動車　ＪＵ適正販売店

（株）ヤリミズ自動車　ＪＵ適正販売店
常時７０台以上の特選車をご用意しております。広い展示場でゆっくりとお車をご覧になれます。
認証整備工場も完備。急な修理も迅速に対応致します。
新車月々１万円リースや、新車まずは半額ハーフマックスなど、新車の購入方法も充実しております！
保険（ＡＩＧ）でも東北地区Ｎｏ１の実績があります！何でもご相談下さい。
お子様連れのお客様でも安心のキッズルーム完備。
スタッフ一同お客様のご来店を心よりお待ちいたしております。

店舗名	（株）ヤリミズ自動車　ＪＵ適正販売店
住所	〒992-1125 山形県米沢市万世町片子４３７２
TEL	0078-6049-0220530
FAX	0238-21-5504
営業時間	平日9:00〜18:30　土日祝9:00〜18:00
定休日	年中無休(年末年始・GW・お盆は休業)
コメント	お車のことならすべてお任せ！自社工場完備でアフターサービスも万全！

（株）ヤリミズ自動車　ＪＵ適正販売店在庫情報

ホンダＮ－ＢＯＸ

Ｇ・Ｌホンダセンシング　４ＷＤ　左側電動スライドドア　ナビ　フルセグＴＶ　Ｂｌｕｅｔｏｏｔｈオーディオ　ＣＤ＆ＤＶＤ再生機能　バックカメラ　ＥＴＣ　ＬＥＤヘッドランプ　クルーズコントロール　シート...

中古価格 112万円

Query	Affected	Num. rows	Took (ms)	Actions
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-18 09:09:37') 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-18 09:09:37') 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-18 09:09:37') 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=1013 AND ((News.public_date <= '2026-06-18 09:09:37') 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-06-18 09:09:37') 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=1015 AND ((News.public_date <= '2026-06-18 09:09:37') 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	0

Message	Memory use
Component initialization	2.61 MB
Controller action start	3.72 MB
Controller render start	4.35 MB
View render complete	4.68 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	20.89
Rendering View	472.54
» Event: Controller.initialize	11.24
» Event: Controller.startup	0.44
» Controller action	221.44
» Event: Controller.beforeRender	28.07
» » Processing toolbar data	27.97
Rendering View #2	0.00
» » Event: View.beforeRender	0.02
» » Rendering APP/View/Ucar/shop.ctp	2.86
» » » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.81
» » » Rendering APP/View/Elements/common/block_right_menu_service.ctp	0.09
» » » Rendering APP/View/Elements/article/block_right_menu_ranking.ctp	0.21
» » Event: View.afterRender	0.01
» » Event: View.beforeLayout	0.01
» » Rendering APP/View/Layouts/default.ctp	6.33
» » » Rendering APP/View/Elements/common_header.ctp	1.35
» » » Rendering APP/View/Elements/ucar/top_menu.ctp	0.94
» » » Rendering APP/View/Elements/common_footer.ctp	0.33
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/0900731?page=2
Query String	page=2
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Query String	page=2
Redirect Url	/app/webroot/ucar/shop/0900731
Remote Port	32016
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.169
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 Cookie	car_mf_app=l5cj05jbrau55bd0nijlcorc6h
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	ajM3Qbk1JB1b36v9GuGdfAAAAk8
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	ajM3Qbk1JB1b36v9GuGdfAAAAk8
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	ajM3Qbk1JB1b36v9GuGdfAAAAk8
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1781741377.331
Request Time	1781741377

（株）ヤリミズ自動車 ＪＵ適正販売店

（株）ヤリミズ自動車 ＪＵ適正販売店在庫情報

ホンダ Ｎ－ＢＯＸ

ポルシェ カイエン

ダイハツ ミライース

日産 ＮＶ１００クリッパーバン

ダイハツ キャスト

ダイハツ ミライース

ホンダ Ｎ－ＢＯＸ

トヨタ Ｃ－ＨＲ

ホンダ フリード

ホンダ フリード＋ハイブリッド

マツダ デミオ

マツダ デミオ

ダイハツ ウェイク

スバル プレオ

トヨタ ヴィッツ

クライスラー・ジープ ジープ・レネゲード

トヨタ クラウンハイブリッド

ダイハツ ムーヴ

トヨタ アクア

メルセデス・ベンツ Ｅクラス

三菱 ｅＫカスタム

ホンダ Ｎ－ＯＮＥ

レクサス ＩＳ

スズキ ジムニー

スズキ クロスビー

スズキ ハスラー

スズキ ハスラー

ダイハツ タフト

ダイハツ タフト

スズキ ワゴンＲスマイル

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 3 ms Total Queries: 8 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

（株）ヤリミズ自動車　ＪＵ適正販売店

（株）ヤリミズ自動車　ＪＵ適正販売店在庫情報

ホンダＮ－ＢＯＸ

ポルシェカイエン

ダイハツミライース

日産ＮＶ１００クリッパーバン

ダイハツキャスト

ダイハツミライース

ホンダＮ－ＢＯＸ

トヨタＣ－ＨＲ

ホンダフリード

ホンダフリード＋ハイブリッド

マツダデミオ

マツダデミオ

ダイハツウェイク

スバルプレオ

トヨタヴィッツ

クライスラー・ジープジープ・レネゲード

トヨタクラウンハイブリッド

ダイハツムーヴ

トヨタアクア

メルセデス・ベンツＥクラス

三菱ｅＫカスタム

ホンダＮ－ＯＮＥ

レクサスＩＳ

スズキジムニー

スズキクロスビー

スズキハスラー

スズキハスラー

ダイハツタフト

ダイハツタフト

スズキワゴンＲスマイル

Total Time: 3 ms
Total Queries: 8 queries