ながの子育て家庭優待パスポート事業協賛店舗検索

豊丘村
全国共通展開

㈲イワサキ自動車

【ながの子育て家庭優待パスポート特典】

●新車・中古車購入時オイル交換無料券進呈
●車検、点検、一般修理時の修理代５％割引
（自賠責保険料と重量税・印紙代を除く）

【全国展開特典】

●新車・中古車購入時オイル交換無料券進呈
●車検、点検、一般修理時の修理代５％割引
（自賠責保険料と重量税・印紙代を除く）

お店からのPR

車の購入、車検鈑金、自動車保険等
メーカーを問わず、車のことなら何でもご相談ください。

フレンドリー・メニュー

店舗情報

㈲イワサキ自動車

住所

長野県豊丘村神稲3056-1

電話

0265-35-2741

FAX

0265-35-6293

メールアドレス

iwskj@sa3.gyao.ne.jp

URL

営業時間

8:00～18:00

定休日

日曜日･祝日

地図

検索一覧に戻る

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllershops
- actiondetails
- named(empty)
- pass(array)
  020000
  14209
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 14 ms
Total Queries: 5 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Shop`.`id`, `Shop`.`name`, `Shop`.`furigana`, `Shop`.`nationwide`, `Shop`.`citytown_id`, `Shop`.`address`, `Shop`.`tel`, `Shop`.`fax`, `Shop`.`url`, `Shop`.`email`, `Shop`.`business_hours`, `Shop`.`regular_holiday`, `Shop`.`latitude`, `Shop`.`longitude`, `Shop`.`pr_message`, `Shop`.`image1_file_name`, `Shop`.`image2_file_name`, `Shop`.`publish_date_start`, `Shop`.`publish_date_end`, `Shop`.`created`, `Shop`.`modified`, `Shop`.`privilege`, `Shop`.`premium_privilege`, `Shop`.`nationwide_privilege`, `Shop`.`same_privilege`, `Shop`.`friendly_menu_etc`, `Shop`.`shichoson_code1`, `Shop`.`shichoson_code2`, `Shop`.`cache_full_address`, `Shop`.`cache_search_words`, `Shop`.`deleted`, (if(isnull(`Shop`.`image1_file_name`), NULL, CONCAT('http://pass.nagano-kosodate.net/ksearch/upload/shops/', `Shop`.`shichoson_code1`, '_', `Shop`.`shichoson_code2`, '/', '1_sp.jpg'))) AS `Shop__image1_url_sp`, (if(isnull(`Shop`.`image2_file_name`), NULL, CONCAT('http://pass.nagano-kosodate.net/ksearch/upload/shops/', `Shop`.`shichoson_code1`, '_', `Shop`.`shichoson_code2`, '/', '2_sp.jpg'))) AS `Shop__image2_url_sp`, `Citytown`.`id`, `Citytown`.`name`, `Citytown`.`area_id`, `Citytown`.`display_order`, `Citytown`.`created`, `Citytown`.`modified`, `ShopGeometry`.`id`, `ShopGeometry`.`latlon`, (X(latlon)) AS `ShopGeometry__longitude`, (Y(latlon)) AS `ShopGeometry__latitude` FROM `db1036330_kosodate_search`.`shops` AS `Shop` LEFT JOIN `db1036330_kosodate_search`.`citytowns` AS `Citytown` ON (`Shop`.`citytown_id` = `Citytown`.`id`) LEFT JOIN `db1036330_kosodate_search`.`shop_geometries` AS `ShopGeometry` ON (`ShopGeometry`.`id` = `Shop`.`id`) WHERE `Shop`.`shichoson_code1` = 20000 AND `Shop`.`shichoson_code2` = 4209 LIMIT 1	1	1	11	maybe slow
SELECT `FriendlyMenu`.`id`, `FriendlyMenu`.`name`, `FriendlyMenu`.`display_order`, `FriendlyMenu`.`created`, `FriendlyMenu`.`modified`, `ShopsFriendlyMenu`.`id`, `ShopsFriendlyMenu`.`shop_id`, `ShopsFriendlyMenu`.`friendly_menu_id`, `ShopsFriendlyMenu`.`created`, `ShopsFriendlyMenu`.`modified` FROM `db1036330_kosodate_search`.`friendly_menus` AS `FriendlyMenu` JOIN `db1036330_kosodate_search`.`shops_friendly_menus` AS `ShopsFriendlyMenu` ON (`ShopsFriendlyMenu`.`shop_id` = 4209 AND `ShopsFriendlyMenu`.`friendly_menu_id` = `FriendlyMenu`.`id`)	3	3	1	maybe slow
SELECT `ServiceCategory`.`id`, `ServiceCategory`.`name`, `ServiceCategory`.`service_field_id`, `ServiceCategory`.`display_order`, `ServiceCategory`.`created`, `ServiceCategory`.`modified`, `ShopsServiceCategory`.`id`, `ShopsServiceCategory`.`shop_id`, `ShopsServiceCategory`.`service_category_id`, `ShopsServiceCategory`.`created`, `ShopsServiceCategory`.`modified` FROM `db1036330_kosodate_search`.`service_categories` AS `ServiceCategory` JOIN `db1036330_kosodate_search`.`shops_service_categories` AS `ShopsServiceCategory` ON (`ShopsServiceCategory`.`shop_id` = 4209 AND `ShopsServiceCategory`.`service_category_id` = `ServiceCategory`.`id`)	1	1	1
SELECT `Passport`.`id`, `Passport`.`name`, `Passport`.`created`, `Passport`.`modified`, `ShopsPassport`.`id`, `ShopsPassport`.`shop_id`, `ShopsPassport`.`passport_id`, `ShopsPassport`.`created`, `ShopsPassport`.`modified` FROM `db1036330_kosodate_search`.`passports` AS `Passport` JOIN `db1036330_kosodate_search`.`shops_passports` AS `ShopsPassport` ON (`ShopsPassport`.`shop_id` = 4209 AND `ShopsPassport`.`passport_id` = `Passport`.`id`)	1	1	1
SELECT `Banner`.`id`, `Banner`.`title`, `Banner`.`banner_file_name`, `Banner`.`url`, `Banner`.`publish_date_start`, `Banner`.`publish_date_end`, `Banner`.`created`, `Banner`.`modified` FROM `db1036330_kosodate_search`.`banners` AS `Banner` WHERE curdate() >= `Banner`.`publish_date_start` and (isnull(`Banner`.`publish_date_end`) or `Banner`.`publish_date_end` >= curdate())	0	0	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 14.97 MB

Message	Memory use
Component initialization	6.16 MB
Controller action start	6.44 MB
Controller render start	10.98 MB
View render complete	12.48 MB

Timers

Total Request Time: 183 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	50.25
Event: Controller.initialize	0.40
Event: Controller.startup	0.86
Controller action	79.05
Event: Controller.beforeRender	14.48
» Processing toolbar data	13.95
Rendering View	4.39
» Event: View.beforeRender	0.07
» Rendering APP/View/Shops/details.ctp	1.22
» » Rendering APP/View/Elements/pc/footer_banner.ctp	0.29
» Event: View.afterRender	0.05
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/kosodate.ctp	1.08
» » Rendering APP/View/Elements/analyticstracking.ctp	0.25
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- banners(empty)
- shop(array)
  Shop(array)
  id4209
  name㈲イワサキ自動車
  furiganaいわさきじどうしゃ
  nationwide1
  citytown_id40
  address神稲3056-1
  tel0265-35-2741
  fax0265-35-6293
  url
  emailiwskj@sa3.gyao.ne.jp
  business_hours8:00～18:00
  regular_holiday日曜日･祝日
  latitude35.5507850
  longitude137.8942280
  pr_message車の購入、車検鈑金、自動車保険等メーカーを問わず、車のことなら何でもご相談ください。
  image1_file_name(null)
  image2_file_name(null)
  publish_date_start2015-06-05
  publish_date_end(null)
  created2017-10-02 09:12:32
  modified2018-11-20 16:32:47
  privilege●新車・中古車購入時オイル交換無料券進呈 ●車検、点検、一般修理時の修理代５％割引（自賠責保険料と重量税・印紙代を除く）
  premium_privilege
  nationwide_privilege
  same_privilege1
  friendly_menu_etc
  shichoson_code120000
  shichoson_code24209
  cache_full_address長野県豊丘村神稲3056-1
  cache_search_words㈲イワサキ自動車|いわさきじどうしゃ|長野県豊丘村神稲3056-1|●新車・中古車購入時オイル交換無料券進呈 ●車検、点検、一般修理時の修理代５％割引（自賠責保険料と重量税・印紙代を除く）|||0265-35-2741|ながの子育て家庭優待パスポート|自動車・ガソリンスタンド|粉ミルクのお湯の提供,おむつ替えスペースあり,ベビーカー入店可能
  deleted0
  image1_url_sp(null)
  image2_url_sp(null)
  Citytown(array)
  id40
  name豊丘村
  area_id5
  display_order11
  created(null)
  modified(null)
  ShopGeometry(array)
  id4209
  latlon
  longitude137.894228
  latitude35.550785
  FriendlyMenu(array)
  0(array)
  id1
  name粉ミルクのお湯の提供
  display_order1
  created(null)
  modified(null)
  ShopsFriendlyMenu(array)
  id964616
  shop_id4209
  friendly_menu_id1
  created(null)
  modified(null)
  1(array)
  id2
  nameおむつ替えスペースあり
  display_order2
  created(null)
  modified(null)
  ShopsFriendlyMenu(array)
  id965580
  shop_id4209
  friendly_menu_id2
  created(null)
  modified(null)
  2(array)
  id6
  nameベビーカー入店可能
  display_order6
  created(null)
  modified(null)
  ShopsFriendlyMenu(array)
  id968078
  shop_id4209
  friendly_menu_id6
  created(null)
  modified(null)
  ServiceCategory(array)
  0(array)
  id22
  name自動車・ガソリンスタンド
  service_field_id3
  display_order5
  created(null)
  modified(null)
  ShopsServiceCategory(array)
  id2589407
  shop_id4209
  service_category_id22
  created(null)
  modified(null)
  Passport(array)
  0(array)
  id1
  nameながの子育て家庭優待パスポート
  created2016-02-29 16:15:21
  modified2016-02-29 16:15:21
  ShopsPassport(array)
  id2185152
  shop_id4209
  passport_id1
  created(null)
  modified(null)
- uri/
- $request->data(empty)
- $this->validationErrors(array)
  Shop(empty)
  Citytown(empty)
  ShopGeometry(empty)
  FriendlyMenu(empty)
  ShopsFriendlyMenu(empty)
  ServiceCategory(empty)
  ShopsServiceCategory(empty)
  Passport(empty)
  ShopsPassport(empty)
  Banner(empty)
- Loaded Helpers(array)
  0Html
  1Upload
  2ShopImageUpload
  3Number
  4SimpleGraph
  5DebugTimer
  6Toolbar
  7Session
  8HtmlToolbar
  9Form
====

Environment

App Constants

No application environment available.

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/Lib/
CACHE	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/tmp/cache/
CAKE	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/lib
CORE_PATH	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/lib/
CAKE_VERSION	2.6.13
CSS	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://pass.nagano-kosodate.net
IMAGES	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/tmp/logs/
ROOT	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch
TESTS	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/Test/
TMP	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/tmp/
VENDORS	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.3.3
Path	/usr/local/bin:/usr/bin:/bin
Redirect Handler	php-cgi-script
Redirect Status	200
Unique Id	W-QZR3dSHmYADipM40AAAADo
Script Url	/ksearch/shops/details/20000/4209
Script Uri	http://pass.nagano-kosodate.net/ksearch/shops/details/20000/4209
Phprc	/var/www/vhosts/13/105534/php
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http If Modified Since	Fri, 21 Sep 2018 08:41:43 GMT
Http Host	pass.nagano-kosodate.net
Http Connection	Keep-Alive
Http Accept Encoding	gzip
Server Signature
Server Software	Apache
Server Name	pass.nagano-kosodate.net
Server Addr	203.83.243.244
Server Port	80
Remote Addr	54.163.22.209
Document Root	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net
Server Admin	you@example.com
Script Filename	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/webroot/index.php
Remote Port	55426
Redirect Url	/ksearch/app/webroot/index.php
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/ksearch/shops/details/20000/4209
Script Name	/ksearch/app/webroot/index.php
Orig Script Filename	/usr/bin/php-cgi
Orig Path Info	/ksearch/app/webroot/index.php
Orig Path Translated	/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/app/webroot/index.php
Orig Script Name	/cgi-php/php-cgi
Php Self	/ksearch/app/webroot/index.php
Request Time	1542723911
Argc	0

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/lib
- 2/php/includes
- 3/usr/share/pear
- 4/usr/libexec/php4-cgi/share/pear
- 5/usr/share/aps/php
- 6-> /var/www/vhosts/13/105534/webspace/httpdocs/pass.nagano-kosodate.net/ksearch/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/PaginatorComponent.php
  2CORE/Controller/Component/RequestHandlerComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/ShopImageUploadBehavior.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/Extension/unicodeEncode.php
  3APP/Config/routes.php
  4APP/Config/database.php
  Controller(array)
  0APP/Controller/ShopsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Shop.php
  1APP/Model/AppModel.php
  2APP/Model/Citytown.php
  3APP/Model/ShopGeometry.php
  4APP/Model/FriendlyMenu.php
  5APP/Model/ShopsFriendlyMenu.php
  6APP/Model/ServiceCategory.php
  7APP/Model/ShopsServiceCategory.php
  8APP/Model/Passport.php
  9APP/Model/ShopsPassport.php
  10APP/Model/Banner.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Other(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Panel/VariablesPanel.php
  9DebugKit/Lib/Panel/EnvironmentPanel.php
  10DebugKit/Lib/Panel/IncludePanel.php
  11DebugKit/Lib/DebugTimer.php
  Log(array)
  0DebugKit/Lib/Log/Engine/DebugKitLog.php
  Search(array)
  Component(array)
  0Search/Controller/Component/PrgComponent.php
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  UploadPack(array)
  Behavior(array)
  0UploadPack/Model/Behavior/UploadBehavior.php
====

㈲イワサキ自動車

【ながの子育て家庭優待パスポート特典】

【全国展開特典】

お店からのPR

㈲イワサキ自動車

住所

電話

FAX

メールアドレス

URL

営業時間

定休日

地図

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 14 ms Total Queries: 5 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 14 ms
Total Queries: 5 queries