HOME
中古車トップ
エスティーエス　川越店

エスティーエス　川越店

エスティーエス　川越店
新店舗「川越店」ＯＰＥＮです！
感染症対策もバッチリです！人数制限も設けてる為、ご来店の際はお電話を！
撮影ブースも御座います！ご納車など特別な日の記念に撮影も！
休憩スペースもアウトドアをイメージ！素敵なひと時をお過ごしください！
お車の事なんでも相談して下さい！素敵な一台をご提案致します！
スタッフ一同心よりご来店お待ちしております！

店舗名	エスティーエス　川越店
住所	〒350-1162 埼玉県川越市南大塚４－１４－１１
TEL	0078-6044-6503530
FAX	049-291-3371
営業時間	10:00〜20:00
定休日	年中無休
コメント	2022年７月グランドオープン！エスティーエスは買取直販の中古車販売店です！店頭に並ぶ在庫のほとんどがユーザー様から直接仕入れさせて頂いている為、お車のコンディションを把握しております！もちろん在庫にないお車でもお気軽にお問い合わせ下さい！！

エスティーエス　川越店在庫情報

マツダＣＸ－３

２０Ｓ　プロアクティブ　ユーザー様直接仕入れ　純正ナビ　フルセグＴＶ　Ｂｌｕｅｔｏｏｔｈ　バックモニター　ＬＥＤヘッドライト　純正１８ＡＷ　ハーフレザーシート　パドルシフト　レーダークルーズ　ＨＵ...

中古価格 119.2万円

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-24 17:04:39') 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-24 17:04:39') 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-24 17:04:39') 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-24 17:04:39') 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-24 17:04:39') 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-24 17:04:39') 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	787 KB
Controller action start	2.08 MB
Controller render start	2.73 MB
View render complete	3.02 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.49
Event: Controller.initialize	11.18
Event: Controller.startup	0.43
Controller action	404.36
Event: Controller.beforeRender	25.02
» Processing toolbar data	24.93
Rendering View	1.92
» Event: View.beforeRender	0.01
» Rendering APP/View/Ucar/shop.ctp	1.49
» » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.56
» » Rendering APP/View/Elements/common/block_right_menu_service.ctp	0.03
» » Rendering APP/View/Elements/article/block_right_menu_ranking.ctp	0.06
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.06
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/0541530?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/0541530
Remote Port	59449
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.222
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=d9lsluo91l0goku42smli3ma8h
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	ajuPl12QCQ0dAr6b0qKgNgAAARc
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	ajuPl12QCQ0dAr6b0qKgNgAAARc
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	ajuPl12QCQ0dAr6b0qKgNgAAARc
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1782288279.4899
Request Time	1782288279

エスティーエス 川越店

エスティーエス 川越店在庫情報

マツダ ＣＸ－３

ルノー メガーヌ

三菱 デリカＤ：５

スバル フォレスター

レクサス ＲＸ

トヨタ シエンタ

ＭＩＮＩ ＭＩＮＩ

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

日産 スカイライン

スバル ＷＲＸ Ｓ４

レクサス ＧＳ

ホンダ アコードハイブリッド

トヨタ アルファード

ダイハツ タント

日産 スカイライン

日産 スカイライン

スバル ＢＲＺ

スバル ＸＶ

マツダ アクセラハイブリッド

トヨタ エスティマ

スバル フォレスター

スバル フォレスター

トヨタ ８６

マツダ ＲＸ－８

トヨタ カローラルミオン

スバル ディアスワゴン

ホンダ クロスロード

トヨタ クラウン

トヨタ ハイラックスサーフ

三菱 デリカスペースギア

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 5 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: 5 ms
Total Queries: 9 queries