HOME
中古車トップ
埼玉スバル（株）　カースポット北本

埼玉スバル（株）　カースポット北本

埼玉スバル（株）　カースポット北本
大宮方面からは国道１７号を熊谷方面へ♪北本市『宮内』交差点手前右側です♪お電話でもご案内致します♪
熊谷方面からは国道１７号を大宮方面へ♪北本市『宮内』交差点先左側です♪お電話でもご案内致します♪
電車でのご来店は最寄駅ＪＲ高崎線　北本駅東口　より♪熊通（クマツウ）タクシーをご利用ください。無料♪
ショールームに商品車展示中！観葉植物多数を設置！くつろぎ空間ご提供を心がけてご来店をお待ちしてます♪
ウエルカムドリンクご用意しております！コーヒー紅茶コーラＣＣレモンイチゴオレコーンスープがございます
お子様連れのお客様専用スペースはキッズコーナーがございます！テレビ♪ＤＶＤもご覧いただけます♪

店舗名	埼玉スバル（株）　カースポット北本
住所	〒364-0002 埼玉県北本市宮内５－２６
TEL	0078-6048-6562530
FAX	048-590-7111
営業時間	10:00〜19:00
定休日	月曜日・火曜日　詳しくは当社HPの営業日カレンダーをご確認ください。
コメント	国道１７号線上り車線側の白い建物とＳＵＢＡＲＵの看板が目印です！スバル車を多数展示しております！お客様満足度向上促進店です！アフターも強力にサポートさせて頂きます！

埼玉スバル（株）　カースポット北本在庫情報

スバルＢＲＺ

Ｓ　１０ｈｔ　Ａｎｎｉｖｅｒｓａｒｙ　Ｌｉｍｉｔｅｄ　６ＭＴ　社外カロッツェリアメモリーナビ　バックカメラ　前席シートヒーター　ウルトラスエードシート　ＬＥＤヘッドライト　オートライト　スマートキ...

中古価格 307.5万円

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	1
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-21 11:56:58') 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-21 11:56:58') 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-21 11:56:58') 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-21 11:56:58') 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-21 11:56:58') 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-21 11:56:58') 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
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	782 KB
Controller action start	1.91 MB
Controller render start	2.49 MB
View render complete	2.77 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.08
Event: Controller.initialize	10.81
Event: Controller.startup	0.41
Controller action	305.41
Event: Controller.beforeRender	38.63
» Processing toolbar data	38.53
Rendering View	1.86
» Event: View.beforeRender	0.02
» Rendering APP/View/Ucar/shop.ctp	1.46
» » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.60
» » Rendering APP/View/Elements/common/block_right_menu_service.ctp	0.02
» » Rendering APP/View/Elements/article/block_right_menu_ranking.ctp	0.05
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.05
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/0560845
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/ucar/shop/0560845
Remote Port	21834
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.144
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=h39lgrh1lfpcn7sh376qs7udt6
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	ajdS-jmXivZCLguN3bUiOQAAAMY
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	ajdS-jmXivZCLguN3bUiOQAAAMY
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	ajdS-jmXivZCLguN3bUiOQAAAMY
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1782010618.209
Request Time	1782010618

埼玉スバル（株） カースポット北本

埼玉スバル（株） カースポット北本在庫情報

スバル ＢＲＺ

スバル フォレスター

スバル フォレスター

スバル フォレスター

トヨタ Ｃ－ＨＲ

ホンダ ジェイド

スバル クロストレック

スバル フォレスター

スバル レヴォーグ レイバック

スバル ソルテラ

スバル ＷＲＸ Ｓ４

スズキ ジムニーシエラ

スバル レヴォーグ レイバック

スバル ＷＲＸ Ｓ４

ホンダ シビック

スバル フォレスター

スバル フォレスター

スバル レガシィアウトバック

スバル ＸＶ

スバル フォレスター

スズキ ジムニーシエラ

スバル フォレスター

スズキ クロスビー

スバル ＸＶ

スズキ ジムニー

トヨタ マークＸ

マツダ ＣＸ－３

スバル フォレスター

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 4 ms Total Queries: 9 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

埼玉スバル（株）　カースポット北本

埼玉スバル（株）　カースポット北本在庫情報

スバルＢＲＺ

スバルフォレスター

スバルフォレスター

スバルフォレスター

トヨタＣ－ＨＲ

ホンダジェイド

スバルクロストレック

スバルフォレスター

スバルレヴォーグレイバック

スバルソルテラ

スバルＷＲＸＳ４

スズキジムニーシエラ

スバルレヴォーグレイバック

スバルＷＲＸＳ４

ホンダシビック

スバルフォレスター

スバルフォレスター

スバルレガシィアウトバック

スバルＸＶ

スバルフォレスター

スズキジムニーシエラ

スバルフォレスター

スズキクロスビー

スバルＸＶ

スズキジムニー

トヨタマークＸ

マツダＣＸ－３

スバルフォレスター

Total Time: 4 ms
Total Queries: 9 queries