HOME
中古車トップ
イデアル泉店　プジョー仙台泉／アルファロメオ仙台（株）イデアル

イデアル泉店　プジョー仙台泉／アルファロメオ仙台（株）イデアル

イデアル泉店　プジョー仙台泉／アルファロメオ仙台（株）イデアル
アルファロメオ、ＦＩＡＴ／ＡＢＡＲＴＨ、プジョー、フェラーリショールームを併設しております。
敷地内には東北で唯一のフェラーリ社認定整備工場を併設。アフターサービスもおまかせ下さい。
広大な敷地には世界各国の輸入中古車を常時１６０台以上展示。確かな目で選び抜かれた高品質車ばかりです。
万が一ご希望のお車が見当たらなくても、全国ネットワークであなたのご希望のお車をお探しいたします。
快適なショールームにて、お車選びのお手伝いから、ご購入後の整備待ちまで、ご対応致します。
国道４号線から見える、この大看板が目印です。

店舗名	イデアル泉店　プジョー仙台泉／アルファロメオ仙台（株）イデアル
住所	〒981-3131 宮城県仙台市泉区七北田字笹４２－１
TEL	0078-6047-9928530
営業時間	10：00〜18：30
定休日	火曜日、第２水曜日（※祝祭日を除く）
コメント	●ＦＩＡＴ・ＡＬＦＡＲＯＭＥＯ・ＡＢＡＲＴＨ●ＰＥＵＧＥＯＴ・ＣＩＴＲＯＥＮ●ＣＨＲＹＳＬＥＲ・Ｊｅｅｐ●フェラーリ社正規サービスディーラー

イデアル泉店　プジョー仙台泉／アルファロメオ仙台（株）イデアル在庫情報

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

シティカーバーリミテッドエディション　Ｓラインインテリアパッケージ　バーチャルコックピット　純正ナビシートヒーター　Ｂカメラ　ＡＣＣ　ＥＴＣ２．０　衝突軽減Ｂ　レーンキープ　前後ソナー　デュアルオ...

中古価格 234.4万円

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-22 03:29:21') 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-22 03:29:21') 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-22 03:29:21') 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-22 03:29:21') 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-22 03:29:21') 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=1015 AND ((News.public_date <= '2026-06-22 03:29:21') 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	1
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	1

Message	Memory use
Component initialization	783 KB
Controller action start	1.98 MB
Controller render start	2.51 MB
View render complete	2.80 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	3.43
Event: Controller.initialize	11.52
Event: Controller.startup	0.29
Controller action	285.16
Event: Controller.beforeRender	24.22
» Processing toolbar data	24.13
Rendering View	1.79
» Event: View.beforeRender	0.02
» Rendering APP/View/Ucar/shop.ctp	1.31
» » 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.04
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	0.04
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/0901317
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/app/webroot/ucar/shop/0901317
Remote Port	51691
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=f8b11v2gsvbt13ism5hgmit1bk
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	ajgtgcarJhu791n7J0pf2AAAANM
Redirect Status	200
Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Https	on
Redirect Unique Id	ajgtgcarJhu791n7J0pf2AAAANM
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	car-stg.motor-fan.jp
Redirect Redirect Https	on
Redirect Redirect Unique Id	ajgtgcarJhu791n7J0pf2AAAANM
Fcgi Role	RESPONDER
Php Self	/app/webroot/index.php
Request Time Float	1782066561.3868
Request Time	1782066561

イデアル泉店 プジョー仙台泉／アルファロメオ仙台（株）イデアル

イデアル泉店 プジョー仙台泉／アルファロメオ仙台（株）イデアル在庫情報

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

アウディ Ａ４アバント

ＢＭＷ Ｘ３

メルセデス・ベンツ Ａクラスセダン

ＢＭＷ Ｘ２

ランドローバー レンジローバーイヴォーク

フィアット ５００

ＢＭＷ ２シリーズ

ＢＭＷ Ｘ３

アルファロメオ ジュリア

メルセデス・ベンツ ＧＬＡクラス

アルファロメオ トナーレ

プジョー ３０８

プジョー ３０８

アルファロメオ ジュニア

アルファロメオ トナーレ

プジョー ４０８

アルファロメオ トナーレ

プジョー ３００８

プジョー ｅ－２０８

フィアット ６００ｅ

プジョー ３０８

アルファロメオ トナーレ

ＭＩＮＩ ＭＩＮＩ

プジョー リフター

プジョー ３０８

ＭＩＮＩ ＭＩＮＩ

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

アルファロメオ ジュリア

プジョー ２０８

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

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