HOME
中古車トップ
ジェイカーズ

ジェイカーズ

ジェイカーズ
ジェイカーズです。お車のことならお任せ下さい。
全国から厳選した状態の良い車両で取り揃えております！もちろん機関系も入念なチェックをしております。
在庫続々入庫中！ご来店心からお待ちしております　。

店舗名	ジェイカーズ
住所	〒984-0033 宮城県仙台市若林区荒浜一本杉北　１－１
TEL	0078-6049-0865530
営業時間	10：00〜17：30
定休日	年中無休
コメント	在庫車両続々入庫中！欲しい車や売りたい車のことまで幅広くご対応いたします。お車のことならお任せください！詳しくは店舗スタッフまでお気軽にお問合せください！

ジェイカーズ在庫情報

ホンダＮ－ＢＯＸ

Ｇ・Ｌパッケージ　《後期モデル》《車検２年》《ＳＤナビＴＶワンセグＢｌｕｅｔｏｏｔｈバックカメラ》ＨＩＤオートライト／両側パワースライドドア／１４インチＡＷ／衝突軽減ブレーキシステム／スマートキー...

中古価格 33万円

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 03:58:43') 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 03:58:43') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	2	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 03:58:43') 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-12 03:58:43') 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-12 03:58:43') 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 03:58:43') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6	6	6	1	maybe slow
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.51 MB
Controller action start	3.70 MB
Controller render start	4.28 MB
View render complete	4.60 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	12.67
Rendering View	1509.88
» Event: Controller.initialize	9.38
» Event: Controller.startup	0.25
» Controller action	299.22
» Event: Controller.beforeRender	19.10
» » Processing toolbar data	19.01
Rendering View #2	0.00
» » Event: View.beforeRender	0.02
» » Rendering APP/View/Ucar/shop.ctp	2.15
» » » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.64
» » » Rendering APP/View/Elements/common/block_right_menu_service.ctp	0.08
» » » 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	7.33
» » » Rendering APP/View/Elements/common_header.ctp	0.60
» » » Rendering APP/View/Elements/ucar/top_menu.ctp	0.66
» » » Rendering APP/View/Elements/common_footer.ctp	0.26
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/0900605?page=3
Query String	page=3
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Query String	page=3
Redirect Url	/app/webroot/ucar/shop/0900605
Remote Port	25898
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=f51jgho32adsoorkmohpd1s19q
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	aisFYgOp138sOVq0TvZ_sAAAARQ
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	aisFYgOp138sOVq0TvZ_sAAAARQ
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	aisFYgOp138sOVq0TvZ_sAAAARQ
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1781204322.654
Request Time	1781204322

ジェイカーズ

ジェイカーズ在庫情報

ホンダ Ｎ－ＢＯＸ

日産 セレナ

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

ホンダ Ｎ－ＢＯＸ

日産 セレナ

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

ホンダ Ｎ－ＢＯＸ

日産 セレナ

日産 セレナ

日産 セレナ

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

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

日産 セレナ

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

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

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

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

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

ホンダ Ｎ－ＢＯＸ

日産 セレナ

ダイハツ タント

ホンダ Ｎ－ＷＧＮ

ダイハツ タント

ホンダ Ｎ－ＢＯＸ

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

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

ダイハツ タント

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

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

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

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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