HOME
中古車トップ
ＺＥＲＯ　ＭＯＴＯＲＳ上尾　コンパクトカー＆軽自動車専門店

ＺＥＲＯ　ＭＯＴＯＲＳ上尾　コンパクトカー＆軽自動車専門店

ＺＥＲＯ　ＭＯＴＯＲＳ上尾　コンパクトカー＆軽自動車専門店
上尾店はコンパクトカーと軽自動車の専門店です！店頭在庫４００台以上の中からお選び頂ける大展示場です。
下取りはもちろん、買取も強化キャンペーン中ですのでお気軽にお声掛け下さい。
各種オートローン取扱！最長〜１２０回払まで！ローンに不安な方もお気軽に相談下さい。
有料保証もご用意しています。大手保証会社様と提携しています。「ロードサービス」「選べる保証」など
全国納車可能です！遠方の方もお気軽にご連絡下さい。ご納車方法などご提案させて頂きます。
埼玉県下に３店舗で営業中しています。グループ総在庫７００台以上を自店各展示場でご覧になって頂けます。

店舗名	ＺＥＲＯ　ＭＯＴＯＲＳ上尾　コンパクトカー＆軽自動車専門店
住所	〒362-0031 埼玉県上尾市東町３－１５５８－１
TEL	0078-6048-2229530
FAX	048-778-7946
営業時間	9:00〜19:00
定休日	年中無休　（１２月３１日　１月１日はお休みになります）
コメント	上尾店はコンパクトカーと軽自動車を400台以上展示しており、選べる展示場が自慢です。格安から現行モデルまで！乗り出し価格１０万円・乗り出し価格３０万円・乗り出し価格５０万円・乗り出し１００万円・乗り出し１５０万円中心の中古軽自動車・コンパクトカー専門店。

ＺＥＲＯ　ＭＯＴＯＲＳ上尾　コンパクトカー＆軽自動車専門店在庫情報

スズキスペーシアカスタム

ハイブリッドＸＳ　ブレーキサポート　令和６年式　９インチナビ　フルセグＴＶ　ブルートゥース対応　全周囲カメラ　両側パワースライドドア　アダプティブクルーズコントロール　ハーフレザーシート　ＬＥＤヘ...

中古価格 150万円

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-13 02:06:51') 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-13 02:06:51') 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=1026 AND ((News.public_date <= '2026-06-13 02:06:51') 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-13 02:06:51') 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-13 02:06:51') 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-13 02:06:51') 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.67 MB
Controller action start	3.80 MB
Controller render start	4.47 MB
View render complete	4.80 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	16.44
Rendering View	319.81
» Event: Controller.initialize	7.48
» Event: Controller.startup	0.21
» Controller action	190.95
» Event: Controller.beforeRender	19.31
» » Processing toolbar data	19.25
Rendering View #2	0.00
» » Event: View.beforeRender	0.01
» » Rendering APP/View/Ucar/shop.ctp	2.06
» » » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.61
» » » 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.43
» » » Rendering APP/View/Elements/common_header.ctp	0.63
» » » Rendering APP/View/Elements/ucar/top_menu.ctp	0.54
» » » Rendering APP/View/Elements/common_footer.ctp	0.24
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/0509023?page=7
Query String	page=7
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Query String	page=7
Redirect Url	/app/webroot/ucar/shop/0509023
Remote Port	21072
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 Cookie	car_mf_app=f1ou129n0ttm4goq707sbb01lr
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	aiw8qzbBn_8aDy2kFORCKAAAAIk
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	aiw8qzbBn_8aDy2kFORCKAAAAIk
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	aiw8qzbBn_8aDy2kFORCKAAAAIk
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1781284011.4079
Request Time	1781284011

ＺＥＲＯ ＭＯＴＯＲＳ上尾 コンパクトカー＆軽自動車専門店

ＺＥＲＯ ＭＯＴＯＲＳ上尾 コンパクトカー＆軽自動車専門店在庫情報

スズキ スペーシアカスタム

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

スズキ エブリイ

スズキ エブリイ

ダイハツ ハイゼットカーゴ

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

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

マツダ フレアクロスオーバー

ホンダ Ｎ－ＢＯＸ

スズキ スペーシアカスタム

ダイハツ タント

ダイハツ タント

スズキ エブリイワゴン

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

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

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

日産 ルークス

スズキ ソリオ

日産 ＮＶ１００クリッパーリオ

ダイハツ タント

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

ダイハツ タント

トヨタ アクア

ホンダ Ｎ－ＶＡＮ

ホンダ Ｎ－ＶＡＮ

スズキ エブリイ

ダイハツ タント

スズキ スペーシア

ダイハツ ハイゼットカーゴ

ホンダ Ｎ－ＯＮＥ

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