HOME
中古車トップ
バルコムスクエア　マリーナベイ｜Ｂａｌｃｏｍ　Ｓｑｕａｒｅ　Ｍａｒｉｎａ　Ｂａｙ

バルコムスクエア　マリーナベイ｜Ｂａｌｃｏｍ　Ｓｑｕａｒｅ　Ｍａｒｉｎａ　Ｂａｙ

バルコムスクエア　マリーナベイ｜Ｂａｌｃｏｍ　Ｓｑｕａｒｅ　Ｍａｒｉｎａ　Ｂａｙ
◆クルマ・バイクの事ならなんでも、私たちバルコムグループにお任せください！
◆国土交通省　中国運輸局指定民間車検場（自社工場）をグループ内に複数完備しております！
◆車両販売・買取り・板金修理・コーティング・フイルム・保険・車点検・レンタカー手配等何でも一括対応！
◆大事なお客様に安心してご利用いただく為に、常に換気を心掛け清潔な店舗を保つ様に徹底管理！
◆敷地内にはＢＭＷ指定自社板金塗装工場とＪネットレンタカーを併設しております！
◆輸入車・国産車どんな車両でも私たちにお任せください！誠心誠意お手伝い致します！

店舗名	バルコムスクエア　マリーナベイ｜Ｂａｌｃｏｍ　Ｓｑｕａｒｅ　Ｍａｒｉｎａ　Ｂａｙ
住所	〒733-0036 広島県広島市西区観音新町４ー９ー４
TEL	0078-6042-3352530
FAX	082-293-3411
営業時間	10：00〜18：00
定休日	火曜日・第２水曜日・ゴールデンウィーク・お盆・年末年始
コメント	「Balcomグループ」が自信をもってお勧めする、良質な輸入車と国産車展示場！

バルコムスクエア　マリーナベイ｜Ｂａｌｃｏｍ　Ｓｑｕａｒｅ　Ｍａｒｉｎａ　Ｂａｙ在庫情報

プジョー３０８

ＧＴ　ブルーＨＤｉ　ブルーナッパエディション　特別仕様車　パノラミックサンルーフ　アクティブセーフティブレーキ　レーンポジショニングアシスト　レーンキープアシスト　アクティブクルーズコントロール　...

中古価格 355.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	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-21 15:19:48') 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 15:19:48') 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-21 15:19:48') 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-21 15:19:48') 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 15:19:48') 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 15:19:48') 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	783 KB
Controller action start	2.01 MB
Controller render start	2.61 MB
View render complete	2.90 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	2.13
Event: Controller.initialize	7.30
Event: Controller.startup	0.22
Controller action	635.26
Event: Controller.beforeRender	21.98
» Processing toolbar data	21.90
Rendering View	2.16
» Event: View.beforeRender	0.02
» Rendering APP/View/Ucar/shop.ctp	1.70
» » Rendering APP/View/Elements/daisharin/block_outline.ctp	0.59
» » 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/1001974
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/ucar/shop/1001974
Remote Port	61341
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=ss3dcav4o4g42g5ua637h8bao1
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	ajeChJxyY2vDMw3RwHOD4AAAApU
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	ajeChJxyY2vDMw3RwHOD4AAAApU
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	ajeChJxyY2vDMw3RwHOD4AAAApU
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1782022788.3652
Request Time	1782022788

バルコムスクエア マリーナベイ｜Ｂａｌｃｏｍ Ｓｑｕａｒｅ Ｍａｒｉｎａ Ｂａｙ

バルコムスクエア マリーナベイ｜Ｂａｌｃｏｍ Ｓｑｕａｒｅ Ｍａｒｉｎａ Ｂａｙ在庫情報

プジョー ３０８

フォルクスワーゲン ゴルフＲ

マツダ ＣＸ－３０

フォルクスワーゲン Ｔ－ロック

メルセデス・ベンツ Ｅクラスオールテレイン

スズキ ソリオバンディット

アウディ Ａ３

フォルクスワーゲン ポロ

トヨタ アクア

フォルクスワーゲン ゴルフＧＴＩ

レクサス ＮＸ

メルセデス・ベンツ Ｂクラス

フォルクスワーゲン ゴルフヴァリアント

ルノー トゥインゴ

アウディ Ａ３セダン

メルセデス・ベンツ Ｃクラス

マツダ ＭＡＺＤＡ３セダン

ルノー キャプチャー

フォルクスワーゲン ゴルフ

フィアット ５００

シトロエン ベルランゴ

ボルボ ＸＣ４０

プジョー ５００８

アルファロメオ ステルヴィオ

ルノー メガーヌ

シトロエン Ｃ３

ルノー トゥインゴ

アウディ Ａ１スポーツバック

プジョー ３００８

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

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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