HOME
中古車トップ
チューブ　坂戸店　中部自動車販売（株）

チューブ　坂戸店　中部自動車販売（株）

チューブ　坂戸店　中部自動車販売（株）
チューブ坂戸店とカーセブン坂戸店が統合リニューアルオープンいたしました！看板もリニューアルしました！
陸運局指定工場完備です。わざわざ陸運局にお車を持ち込まなくても、自社で車検が取れます！安心ですね！
当店では、国産全メーカーの新車販売も行っております。お値段も頑張りますので、お気軽にご相談下さい。
４／２５リニューアルグランドオープンセール開催中！売り買いどちらもご来場くださいませ！
出ました！当社自慢の４つの約束！安心と信頼がそこにはある！あるんです！！
当社の保証は日本一！延長保証も併せてご利用くださいませ！

店舗名	チューブ　坂戸店　中部自動車販売（株）
住所	〒350-0219 埼玉県坂戸市片柳２２５４－１
TEL	0078-6048-9097530
FAX	049-283-0511
営業時間	１０：００〜２０：００
定休日	水曜日　(祝日の場合は営業　)２／１１（水）建国記念の日営業いたします！
コメント	グループ総在庫１０，０００台！オートオークション直営店ですので豊富な在庫車の中からお客様に最適な条件のお車をお探し致します。

チューブ　坂戸店　中部自動車販売（株）在庫情報

ホンダＮ－ＯＮＥ

　ホンダセンシング　キーフリー　プッシュスタート　前席シートヒーター　ブレーキホールド　アダプティブクルーズコントロール　ステアリングスイッチ　ＬＥＤヘッドライト　オートエアコン　ターボ

中古価格 228.3万円

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-12 01:25:06') 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 01:25:06') 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 01:25:06') 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 01:25:06') 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 01:25:06') 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-12 01:25:06') 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.79 MB
Controller render start	4.42 MB
View render complete	4.74 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	12.19
Rendering View	1433.32
» Event: Controller.initialize	8.09
» Event: Controller.startup	0.22
» Controller action	288.46
» Event: Controller.beforeRender	28.19
» » Processing toolbar data	28.11
Rendering View #2	0.00
» » Event: View.beforeRender	0.02
» » Rendering APP/View/Ucar/shop.ctp	4.26
» » » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.99
» » » 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	8.81
» » » Rendering APP/View/Elements/common_header.ctp	0.68
» » » Rendering APP/View/Elements/ucar/top_menu.ctp	0.66
» » » Rendering APP/View/Elements/common_footer.ctp	0.29
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/0551631
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/ucar/shop/0551631
Remote Port	31878
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=qjmqe6h872fcgeuamejgas27ds
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	airhYQOp138sOVq0TvbGAwAAAQI
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	airhYQOp138sOVq0TvbGAwAAAQI
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	airhYQOp138sOVq0TvbGAwAAAQI
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1781195105.8786
Request Time	1781195105

チューブ 坂戸店 中部自動車販売（株）

チューブ 坂戸店 中部自動車販売（株）在庫情報

ホンダ Ｎ－ＯＮＥ

スズキ ハスラー

日産 デイズ

日産 ノート

トヨタ ピクシスメガ

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

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

ホンダ バモス

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

スズキ アルトラパン

トヨタ ヴェルファイア

日産 モコ

スズキ アルトラパンＬＣ

日産 ルークス

日産 ルークス

三菱 デリカミニ

スズキ アルト

スズキ アルト

スズキ アルト

ダイハツ ムーヴ

スズキ スペーシア

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

ホンダ Ｎ－ＢＯＸ

ホンダ ＷＲ－Ｖ

ダイハツ コペン

三菱 デリカミニ

三菱 デリカミニ

スズキ ジムニーシエラ

三菱 アウトランダーＰＨＥＶ

日産 デイズ

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 4 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: 4 ms
Total Queries: 8 queries