- まちかどフィットネスOHANA ジュニア教室
- 地図・特典
Campaign 特典
キャンペーンは実施しておりません
Access まちかどフィットネスOHANA ジュニア教室の地図・交通案内
- History
-
Session +
Session
- _Token(array)
- key91064862976bc35d156871470750ab7283aac070
- allowedControllers(empty)
- allowedActions(empty)
- unlockedFields(empty)
- csrfTokens(array)
- 91064862976bc35d156871470750ab7283aac0701732221103
==== - _Token(array)
-
Request +
Request
Cake Params
- plugin(null)
- controllerschoolgroup
- actionmap_and_coupon
- named(empty)
- pass(empty)
- schoolgroupId59
- _Token(array)
- key91064862976bc35d156871470750ab7283aac070
- unlockedFields(empty)
Post data
No post data.
Query string
No querystring data.
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
- keys(array)
- 0schoolgroupId
- options(array)
- schoolgroupId[0-9]+
- defaults(array)
- controllerschoolgroup
- actionmap_and_coupon
- plugin(null)
- template/group/LG_:schoolgroupId/map_and_coupon
==== -
Sql Log +
Sql Logs
参考:explainの見方
- Host: mysql202.xbiz.ne.jp
- DB: jobikai_dance
- total: 26 queries / 0.024157 sec
No. time query 1 0.010997 connect2 0.000847 DESCRIBE `schoolgroup`3 0.000487 SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '59') AND (sg.registration_status = 1) LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE sg const PRIMARY PRIMARY 4 const 1 4 0.000957 DESCRIBE `school`5 0.000457 SELECT COUNT(*) AS `cnt` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.schoolgroup_id = '59') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref ix_schoolgroup_id_school ix_schoolgroup_id_school 5 const 1 Using where 6 0.000677 DESCRIBE `schoolgroup_score`7 0.000387 SELECT `s_s`.* FROM `schoolgroup_score` AS `s_s` WHERE (s_s.schoolgroup_id = '59') AND (s_s.is_latest = 1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref schoolgroup_id schoolgroup_id 4 const 1 Using where 8 0.000647 SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '59') AND (s.is_detail_address_opening = 1) AND (s.lat IS NOT NULL) AND (s.lon IS NOT NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref ix_schoolgroup_id_school ix_schoolgroup_id_school 5 const 1 Using where 9 0.000747 DESCRIBE `summary_count_school`10 0.000517 SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 0) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_c_s ref multi multi 28 const,const,const,const,const,const,const 1 11 0.000857 DESCRIBE `campaign_schoolgroup`12 0.000457 SELECT `c_sg`.* FROM `campaign_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '59') AND (c_sg.valid = 1) AND (c_sg.expiration_date = "0000-00-00" || c_sg.expiration_date IS NULL || c_sg.expiration_date >= 2024-11-22) ORDER BY `timestamp_created` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_sg ref schoolgroup_id,ix_expiration_date_campaign_schoolgroup schoolgroup_id 4 const 1 Using index condition; Using where; Using filesort 13 0.000697 SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '59') AND (s.is_detail_address_opening = 1) AND (s.lat IS NOT NULL) AND (s.lon IS NOT NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref ix_schoolgroup_id_school ix_schoolgroup_id_school 5 const 1 Using where 14 0.000537 DESCRIBE `city`15 0.000357 SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '1496') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 16 0.000487 DESCRIBE `prefecture`17 0.000337 SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '27') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p const PRIMARY PRIMARY 4 const 1 18 0.000567 DESCRIBE `dancer`19 0.000447 SELECT `c`.`id` FROM `dancer` AS `c` INNER JOIN `dancer_column` AS `d_c` ON c.id = d_c.dancer_id AND d_c.valid = 1 ORDER BY `d_c`.`timestamp_created` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE d_c ALL ix_dancer_id_dancer_column 29 Using where; Using filesort 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 jobikai_dance.d_c.dancer_id 1 Using index 20 0.000427 SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range PRIMARY PRIMARY 4 5 Using where 21 0.000487 DESCRIBE `dancer_column`22 0.000427 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ix_dancer_id_dancer_column ix_dancer_id_dancer_column 5 const 2 Using index condition; Using where; Using filesort 23 0.000367 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ix_dancer_id_dancer_column ix_dancer_id_dancer_column 5 const 2 Using index condition; Using where; Using filesort 24 0.000407 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ix_dancer_id_dancer_column ix_dancer_id_dancer_column 5 const 2 Using index condition; Using where; Using filesort 25 0.000377 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ix_dancer_id_dancer_column ix_dancer_id_dancer_column 5 const 2 Using index condition; Using where; Using filesort 26 0.000397 SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref ix_dancer_id_dancer_column ix_dancer_id_dancer_column 5 const 1 Using index condition; Using where; Using filesort ==== -
Timer +
Memory
Peak Memory Use 11.91 MB
Message Memory use Component initialization 2.14 MB Controller action start 3.78 MB Controller render start 4.49 MB View render complete 5.36 MB Timers
Total Request Time: 3678 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 3534.84 Event: Controller.initialize 26.43 Event: Controller.startup 0.37 Controller action 1.25 Event: Controller.beforeRender 49.34 » Processing toolbar data 42.79 Rendering View 40.28 » Event: View.beforeRender 20.13 » Rendering APP/View/Schoolgroup/map_and_coupon.ctp 7.01 » » Rendering APP/View/Elements/schoolgroup/google_map_place_js.ctp 2.95 » » Rendering APP/View/Elements/adsense/336_288.ctp 0.06 » Event: View.afterRender 0.03 » Event: View.beforeLayout 0.03 » Rendering APP/View/Layouts/default.ctp 12.22 » » Rendering APP/View/Elements/header.ctp 0.35 » » Rendering APP/View/Elements/schoolgroup/detailHeader.ctp 1.27 » » » Rendering APP/View/Elements/breadcrumb.ctp 0.21 » » Rendering APP/View/Elements/menu.ctp 7.84 » » » Rendering APP/View/Elements/schoolgroup/right-menu.ctp 7.67 » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.06 » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.05 » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 7.02 » » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp 0.06 » » Rendering APP/View/Elements/rtt.ctp 0.10 » » Rendering APP/View/Elements/footer.ctp 1.27 » » Rendering APP/View/Elements/common/scoreEx.ctp 0.06 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- zoomlv11
- midLon135.616445
- midLat34.663113
- SchoolSet(object)
- 0(object)
- id3014289
- nameまちかどフィットネスOHANA ジュニア教室
- branch_name
- city_id1496
- schoolgroup_id59
- mail_addressohana@pttcorp.com
- lat34.663113000000
- lon135.616445000000
- telephone_number072-961-0087
- homepage_urlwww.pttcorp.com/ohana.html
- mobile_homepage_url
- blog_url
- open_hour平日9:30~21:30 土・祝9:00~18:00
- holiday日曜日
- post_code5780925
- town_address稲葉3-11-10
- buildingピアザ花園2F
- image_hashf8d00d969102a51a
- image_extension_type2
- message_image_hash(null)
- message_image_extension_type(null)
- is_registered_by_not_owner0
- is_opening1
- message_title河内花園駅前。初心者大歓迎!無料体験受付中! フィットネスクラブ内にあるジュニアダンス教室です。コンパクトなスタジオならではの先生との一体感を味わって下さい。楽しくなければダンスじゃない!楽しまなければ、OHANAじゃない! JAZZ 毎週火曜日
- message_bodyプロのダンサーになりたい、ダンスを極めたい、そんな子供たちより、ダンスが好き!踊るのが楽しい!そんな子供たちを応援するためにOHANAのダンス教室は開講しました。 OHANAのジュニア教室は、みんなの「出来る喜び」を応援しています。楽しくダンスをしたい子供達、あつまれ! まずは、御問合せ下さい。見学・体験随時受付中です。
- is_detail_address_opening1
- is_charged0
- registration_status1
- whole_staff_title(null)
- whole_staff_introduction(null)
- whole_staff_image_hash(null)
- whole_staff_image_extension_type(null)
- is_kuchikomi_notice_mail_receiving1
- banner_image_hash(null)
- banner_image_extension_type(null)
- school_type1
- has_kids_course1
- has_beginner_course1
- score0.00
- kuchikomi_count0
- timestamp_created0000-00-00 00:00:00
- timestamp_modified2021-08-03 15:06:14
- memo(null)
- 0(object)
- metaKeywordString(null)
- headString(null)
- metaDescription(null)
- title_for_layout(null)
- SchoolgroupScoreSet(object)
- SchoolCount1
- breadcrumb(array)
- 0(array)
- nameスクール検索
- link(array)
- controllerschool_list
- actionindex
- 1(array)
- nameまちかどフィットネスOHANA ジュニア教室
- link
- 0(array)
- Schoolgroup(object)
- id59
- nameまちかどフィットネスOHANA ジュニア教室
- admin_member_id398
- mail_addressohana@pttcorp.com
- telephone_number(null)
- homepage_url(null)
- mobile_homepage_url(null)
- summary(null)
- message_title(null)
- message_body(null)
- registration_status1
- image_hash(null)
- image_extension_type(null)
- message_image_hash(null)
- message_image_extension_type(null)
- whole_staff_title(null)
- whole_staff_introduction(null)
- whole_staff_image_hash(null)
- whole_staff_image_extension_type(null)
- score0.00
- kuchikomi_count0
- timestamp_created0000-00-00 00:00:00
- timestamp_modified2021-08-03 15:10:03
- adsenseCount0
- $request->data(empty)
- $this->validationErrors(empty)
- Loaded Helpers(array)
- 0Html
- 1Form
- 2Number
- 3SimpleGraph
- 4DebugTimer
- 5Toolbar
- 6HtmlToolbar
==== -
Environment +
App Constants
Notice (8): Undefined offset: 1 [CORE/Cake/View/Helper/HtmlHelper.php, line 867]
Constant Value SGV_ENV development DEBUGKIT_ON 1 MENTE_FLAG SGV_APP_BASE_PATH /home/jobikai/dance-schoolgv.net/cakephp/ CONFIG_DIR /home/jobikai/dance-schoolgv.net/cakephp/Config/ LIB_DIR /home/jobikai/dance-schoolgv.net/cakephp/lib/ MODEL_DIR /home/jobikai/dance-schoolgv.net/cakephp/Model/ CLASS_DIR /home/jobikai/dance-schoolgv.net/cakephp/class/ THUMBLIB_BASE_PATH /home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb THUMBLIB_PLUGIN_PATH /home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/ DEFAULT_THUMBLIB_IMPLEMENTATION gd USER_STATIC_SALT Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z SITE_TITLE ダンススクール・ダンス教室口コミ検索ネット OPERATOR_MAIL_ADDRESS info@kuchi.info NO_REPLY_MAIL_ADDRESS no-reply@kuchi.info RETURN_PATH__MAIL_ADDRESS errors@kuchi.info GOOGLE_API_KEY AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0 QWINTET_IP 122.216.11.82 ADSENSE_ID ca-pub-7408087519812416 CLIENT_IP 3.15.143.18 CakePHP Constants
Constant Value APP /home/jobikai/dance-schoolgv.net/cakephp/app/ APP_DIR app APPLIBS /home/jobikai/dance-schoolgv.net/cakephp/app/Lib/ CACHE /home/jobikai/dance-schoolgv.net/cakephp/app/tmp/cache/ CAKE /home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/ CAKE_CORE_INCLUDE_PATH /home/jobikai/dance-schoolgv.net/cakephp/lib CORE_PATH /home/jobikai/dance-schoolgv.net/cakephp/lib/ CAKE_VERSION 2.3.1 CSS /home/jobikai/dance-schoolgv.net/cakephp/app/webroot/css/ CSS_URL css/ DS / FULL_BASE_URL https://dance-schoolgv.net IMAGES /home/jobikai/dance-schoolgv.net/cakephp/app/webroot/img/ IMAGES_URL img/ JS /home/jobikai/dance-schoolgv.net/cakephp/app/webroot/js/ JS_URL js/ LOGS /home/jobikai/dance-schoolgv.net/cakephp/app/tmp/logs/ ROOT /home/jobikai/dance-schoolgv.net/cakephp TESTS /home/jobikai/dance-schoolgv.net/cakephp/app/Test/ TMP /home/jobikai/dance-schoolgv.net/cakephp/app/tmp/ VENDORS /home/jobikai/dance-schoolgv.net/cakephp/vendors/ WEBROOT_DIR webroot WWW_ROOT /home/jobikai/dance-schoolgv.net/cakephp/app/webroot/ PHP Environment
Environment Variable Value Php Version 5.6.40 Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin Pwd /home/userfastcgi/jobikai/dance-schoolgv.net Shlvl 0 Script Name /index.php Request Uri /group/LG_59/map_and_coupon Query String Request Method GET Server Protocol HTTP/1.1 Gateway Interface CGI/1.1 Redirect Url /group/LG_59/map_and_coupon Remote Port 49762 Script Filename /home/jobikai/dance-schoolgv.net/public_html/index.php Server Admin webmaster@dance-schoolgv.net Context Document Root /home/jobikai/dance-schoolgv.net/public_html Context Prefix Request Scheme https Document Root /home/jobikai/dance-schoolgv.net/public_html Remote Addr 3.15.143.18 Server Port 443 Server Addr 183.90.231.12 Server Name dance-schoolgv.net Server Software Apache Server Signature Http User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) Http Accept */* Http Connection close Http X File Type normal Http X Ua Device pc Http X Failure Cache Time 0 Http X Accel Expires 60 Http X Wp Access 0 Http X Server Address 183.90.231.12 Http X Real Ip 3.15.143.18 Http X Forwarded Ssl on Http X Forwarded Port 443 Http X Forwarded Host dance-schoolgv.net Http X Forwarded Proto https Http X Forwarded For 3.15.143.18 Http Host dance-schoolgv.net Ngx Cache Staticmode 1 Ngx Cache Normalfile 1 Failurecachetime 0 Https on Unique Id Zz-RpA4x71zy3BTSU-7YNAAAAKc Mef Proxy Addr 183.90.231.12 Redirect Status 200 Redirect Ngx Cache Staticmode 1 Redirect Ngx Cache Normalfile 1 Redirect Failurecachetime 0 Redirect Https on Redirect Unique Id Zz-RpA4x71zy3BTSU-7YNAAAAKc Redirect Mef Proxy Addr 183.90.231.12 Fcgi Role RESPONDER Php Self /index.php Request Time Float 1732219300.0733 Request Time 1732219300 ==== -
Include +
Included Files
Include Paths
- 0/home/jobikai/dance-schoolgv.net/cakephp/lib/ZendFramework/library/
- 1/home/jobikai/dance-schoolgv.net/vendor/phpunit/dbunit
- 6/home/jobikai/dance-schoolgv.net/vendor/symfony/yaml
- 3/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-code-coverage
- 4/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-token-stream
- 5/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit
- 7/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-mock-objects
- 8/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-selenium
- 9/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-story
- 10/home/jobikai/dance-schoolgv.net/cakephp/lib
- 12/opt/php-5.6.40-3/data/pear
- 13-> /home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
Included Files
- core(array)
- Cache(array)
- 0CORE/Cache/Cache.php
- 1CORE/Cache/Engine/FileEngine.php
- 2CORE/Cache/CacheEngine.php
- Component(array)
- 0CORE/Controller/Component/SecurityComponent.php
- 1CORE/Controller/Component/SessionComponent.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
- 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/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/Security.php
- View(array)
- 0CORE/View/HelperCollection.php
- Cache(array)
- app(array)
- Config(array)
- 0APP/Config/core.php
- 1APP/Config/bootstrap.php
- 2APP/Config/routes.php
- 3APP/Config/database.php
- Controller(array)
- 0APP/Controller/SchoolgroupController.php
- 1APP/Controller/AppController.php
- Other(array)
- 0APP/webroot/index.php
- 1APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
- 2APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
- 3APP/class/Sgv/Front/SearchState/SchoolList.php
- 4APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
- 5APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
- 6APP/class/Sgv/Front/SearchCondition/SchoolList.php
- 7APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
- 8APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
- 9APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
- 10APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
- 11APP/class/Sgv/Front/InputForm/SchoolSearch.php
- 12APP/class/Sgv/Front/InputItem/SchoolSearch.php
- Config(array)
- 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
- Component(array)
- DebugKit(array)
====