- サンライズスタジオ
- 地図・特典
Campaign 特典
HOUSE LESSON☆スタート♪
- キャンペーン価格 1,500円
HOUSE LESSON
SEI先生
<時間>
月曜日20:15~21:30 HOUSE
<料金>
1回 一般1500円/学生1000円
★入会金無料★
ステップを中心としたストリートダンスの代表的なジャンルの一つです。
リズムやテンポに合わせるような「流れるような素早い足さばき」が、ハウスダンスの最大の特徴です。
Laulea Hula☆無料体験レッスン実施♪
- キャンペーン価格 4,800円
- 利用条件
- 初回限定♪
Laulea Hula
講師 田村理香先生
Esthetic Salon&Hula Laulea経営
ー豊島区 上池袋ー
<時間>
月3回 水曜日 am10:00~11:30
<料金>
★月3回 4800円★
♪初心者の方もお気軽にご体験下さいませ♪
JAZZ DANCE☆初心者大歓迎♪
- キャンペーン価格 500円
- 利用条件
- 初回限定です♪
HANA先生
<時間>
毎週土曜日18:15~19:45
(※第5土曜日は基本お休みです。)
<レッスン内容>
初級〜初中級レベルのジャズダンスクラスです。
幅広く色んなジャズ振りをやっていきます!
基礎からやっていくので初めての方大歓迎です!!
<料金>
1レッスン1500円
4回チケット4000円(6週間有効)
体験レッスン☆500円
☆難しくない基礎からのベリーダンスレッスン☆
- キャンペーン価格 1,000円
- 利用条件
- 初回限定です♪
Yurie先生
アラビアンナイトの世界で、楽しくキレイに女子力UP!
<時間>
月3回 火曜日(第2・3・4週)
13:00~14:30(90分)
<料金>
★月3回 5000円★
★体験レッスンは、1000円★
<服装>
★動きやすい服装★
(Tシャツやタンクトップ・スパッツ・あればヒップスカーフ)
※足元は裸足です。
☆HIPHOP JAZZ☆体験レッスン800円♪
- キャンペーン価格 800円
- 利用条件
- 初回限定です。
YUKI先生
第1,3,5土曜日16:00~17:30
第2,4土曜日 16:00〜17:00
HIPHOP JAZZ超入門
体験800円♪
☆フラ・タヒチアンレッスン☆無料体験レッスン実施中♪
- キャンペーン価格
- 無料
- 利用条件
- 初回限定です♪
毎週 火曜日 11:00~12:00 フラダンスイリマ
毎週 火曜日 16:30~17:30 フラダンスケイキ(親子クラス)
毎週 火曜日 17:30~18:30 タヒチアンダンスタマリィ
高柳友紀先生
TAP体験レッスン1000円キャンペーン実施中♪
- キャンペーン価格 1,000円
- 利用条件
- 初回限定です。
毎週水曜日
18:00~19:30(ALL LEVEL)
渡辺かずみ先生
初回に限り1レッスン1000円で受けられます♪
マリネラ体験レッスン1000円実施中♪
- キャンペーン価格 1,000円
- 利用条件
- 初回限定です。
福田千文先生
毎週日曜日10:15~11:45(子供クラス)
毎週日曜日14:15~15:45(大人クラス)
☆入会金無料☆1レッスン2000円☆
体験レッスン☆1000円♪
Access 地図・交通案内
サンライズスタジオの地図・交通案内
住所
〒1760005 東京都 練馬区 旭丘1-26-4 B1F
-
- History
-
Session +
Session
- _Token(array)
- key4ca81862a603748397b328b41c3353ff84997147
- allowedControllers(empty)
- allowedActions(empty)
- unlockedFields(empty)
- csrfTokens(array)
- 4b99b315cd5046c47307a39dba7a7a46390ee38e1764917198
- a5cb5a0e82dc9313ff3138868d25f0f2cf03ce551764917199
- 41b1ba7824aa9975d256fd2c8beb944f0980ff4e1764917199
- 67a6c205f20343457164605f140789bfc35c60fa1764917199
- 6686c163658ddda5e976ca4795ec171dbd1bbc251764917199
- 8c3cac5d98b19263149102819ca595162b946ead1764917199
- b8500e9138b01ff70a85ee943599c6406f364f011764917200
- d3bb901c6bcd1e9b30446348b50507be8217047e1764917200
- a397d9b5654293daf1b12c51211fc769be39a44c1764917200
- 4a995e91e38beda1d61e483f76064c9f7a4cd3151764917200
- 5b09a4cb193a05d56c14127abaca091ff06dcb081764917201
- c4b7c081ebfcd360243c108ebe9574a4d8050ff31764917201
- 1466593d8dd2abbf67e07d95b3812b34428e97331764917201
- 0790e14aa190a74956662c6f533289716abd8f7e1764917201
- f16fb5bf41f784323011478460e3d231769a43741764917202
- a1670202bfe8d8e6b0ffbc83576919d8d339a9cf1764917202
- cda5a6cf8b5b8a43b0f07aa95ca92d152c2249611764917202
- a1a198956f08cc79dea22a8c3e6537b4383c04b51764917202
- 9aadb77efec9b4c55448a8dc6817e3663a74f44a1764917203
- a6390b5ef199a77889b542b18ced7709718509b51764917203
- 163fec9cf6202ce6dcf0f5aba0c494802f8489a51764917203
- cdd74147ef93b8c6bc65461125e1c6ec351473aa1764917203
- 7b4894c4763154cc6a467ff1f9b8e8fe0656b3211764917204
- 50b8ffdf19be84c3b2d30de3cb4b4e1ca2821d0b1764917204
- 2bc25ce00b8cbfd34845adf80b0c67f212bf06de1764917204
- 102fb21fd19726c07deba9ca164ea4acf16cfcdd1764917205
- 75f19aadbe4263ce711a38f75cb9ee8e794ccdb71764917205
- 9f93ae65474f8c90faa6c7c68443c7c869300b641764917205
- f791a050664fa3b13e7c62a9482a799fc45231691764917205
- 5510f812fe98b3365bb2ab62e4109bf788b9c5071764917205
- 2948b167d32976a46fd46bf3d718ea5da8e782a21764917206
- 6e0fcdb2e8dd537cab3d7d110abcc1e8252f6b831764917206
- fecdd548809350bf2fd6ba0989ba311df3096f301764917206
- 2c31d1d27241d4dde98fd954c93e41cc9727a17f1764917207
- abf581bd58a2702d90d876e66297600e0bb63df51764917207
- 14101738a5a5b22016fd3f0c884f9fb27b8cddd81764917207
- 2ec8d9cbbb7b8391cbef411f9f7b4a744bed83c21764917207
- 136c607efd9e3618cd414d3ebbfc186b360ca1901764917208
- f2345821d8284d02910aa98e55811a60ba09bc711764917208
- d5f9e9935eff30ff453f299ec65588794a009a6f1764917208
- a96297729aae95a008d8aa816e949a9bb01122db1764917208
- ca6af89c8f28dc74781b97b8d7010fef150a829d1764917209
- 58224f32e53f1bc42eab857f13216aec75e73b251764917209
- 7222f783bdc7cd26fdd67c4f482df6a0f601c2231764917209
- ecf235b74ccf5114183c2210cfb7351b38d0bda21764917209
- 655a3d21bbf510cc00077c019c6dc744a2b88b971764917210
- fccd7f5f56c47c78a539667343fb3458674ee14d1764917210
- a928a6eb42acb5ace2c930c015f02185fd4d747a1764917210
- d21e269780796ce8c4eb7e77b25aee733384cae31764917210
- 7225b0ed02609ac3754e8d91502c31c44fc129cf1764917211
- cc642bd44ec92089a7ba0e6c98e7788de786bfc91764917211
- 81427b3f2a9e0d149ebbc6f4d78e7ada88fa4b9a1764917211
- 8a329ce86c9037d652a415cf04d94dda4980652d1764917211
- 719e4152c8a419e6f2aded8c34e1395b0c5e479d1764917211
- e2f5780a49e12f5f4cd2074c3228336d30916e861764917212
- 8bfecd4deea1a37c5cd9d5c7a5244b8db2152d001764917212
- f234bfa3651a362b25475619abe3c1ab4f73b1c51764917212
- 70a9e64fe4bbd06e2a735ec8e512ffa5195c11171764917212
- caac573fb85d6aee1c83f3b78fba22f56029acee1764917213
- 0be28517140dddb3e5501ccaef0925183dba5c651764917213
- 703236eeedb34042e38a90bcd8ceaf8d3a8b23ff1764917213
- 9dbe097ac91fdd1a37094b033516da81aead26e51764917214
- 31a3a3bf87bb8c18da22729fa08249ffad794f061764917214
- 8b3fc71b12d0b811319301302b5842d6be5541d01764917214
- d9f54bc27d9d3cec3fb4719ee6d1231a8f8097a51764917214
- bc862d20d9e91570c99ce79b108485edad81b52f1764917215
- 85c0bf12f23292794d0b15a6b640b9bd5f0f4f621764917215
- 8dab6303872393a6d30711f22c991cecb84a78641764917215
- e41f4e8240fd3b2b3c8af46e506dc86cab6bdf371764917216
- 23aec130a7afcdc81480f5b32bb438733ba420651764917216
- a1818b899ef750e73f038cf1bc3cf5ff690a534c1764917216
- b6abd868f429a513e5a92989b929395c66f585fa1764917216
- ac51a6800cef040dbe347b7d79c17b29ec5b23801764917217
- 0664848409c0081162a152f2fd2cbb03cb0ce2dc1764917217
- d2b1ebd8acfc548f66e934eabef742aaec5132f31764917217
- 39a279cdc5b381982971a0b46ee5cb4d6b3d06951764917217
- 7e6e2d98377533ed210bc5c18ddea9920d29a07b1764917218
- 77c20feeef22166bb6316e36e7f889f544dab6741764917218
- 604cd1ef7237206b279f670d32ae3a37995b21361764917218
- d395d86812a6c1f5a347472e09aa06784c6b615d1764917218
- 5e59612670b58f6f8e09fd6a6c7a98b10aeb737a1764917219
- 8925399177516e5ffdf1c6a5424eb8d3b91c5cef1764917219
- 35077c609d4759673693419032c7b7c34e9956131764917219
- 1459cba73ff7e8bbcded0f233ca34941a4193de61764917219
- 84a3646e6afbdf528b0e037f6464ae7c086cee881764917220
- 3a7ed329041b84690ccb32c07fe2d20cdf64b3e31764917220
- 8c9da53aa2c708728b8efc2a472a6cdd227a42811764917220
- e2e6e1f1744e9caad52a170bbc2ba84005f640a91764917220
- 0550f6880593f8286f469d0ff9d8703840f242751764917221
- 185b91ca5981af56c58b01354a3a6eba051eab871764917221
- 05ade482c2369a1f369d71954433c385a79943cf1764917221
- 8a7964736d21d9c95e43cab679e92f5fa5fbc61f1764917221
- e1837b5cc8acc0da8df89f9e3da9559283828a781764917222
- 763a231e3a1a84063db7862e838ac7dd93e13aa01764917222
- ce7a0004554edce023d36b63faaa47e1f2faa9561764917222
- ea57d8d1b62c67b5fe093b2f10210fbae21c09d31764917222
- 59e448ca6f948688589e2d09f82baa9ceaac63ed1764917223
- 499cb07e573610082f6eebdc4afd286f5215e2bc1764917223
- 003a49e5091316eb9b078ee0f4cf43ac05adbe3b1764917223
- 4ca81862a603748397b328b41c3353ff849971471764917223
==== - _Token(array)
-
Request +
Request
Cake Params
- plugin(null)
- controllerschool
- actionmap_and_coupon
- named(empty)
- pass(empty)
- schoolId3014459
- _Token(array)
- key4ca81862a603748397b328b41c3353ff84997147
- unlockedFields(empty)
Post data
No post data.
Query string
No querystring data.
Cookie
To view Cookies, add CookieComponent to Controller
Current Route
- keys(array)
- 0schoolId
- options(array)
- schoolId[0-9]+
- defaults(array)
- controllerschool
- actionmap_and_coupon
- plugin(null)
- template/detail/L_:schoolId/map_and_coupon
==== -
Sql Log +
Sql Logs
参考:explainの見方
- Host: mysql202.xbiz.ne.jp
- DB: jobikai_dance
- total: 55 queries / 0.045557 sec
No. time query 1 0.001887 connect2 0.000727 DESCRIBE `school`3 0.000547 SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3014459') AND (s.registration_status = 1) AND (s.is_opening = 1) LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY PRIMARY 4 const 1 4 0.000527 DESCRIBE `school_score`5 0.000397 SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3014459') AND (s_s.is_latest = 1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref school_id school_id 4 const 1 Using where 6 0.000497 DESCRIBE `access_log_school`7 0.003307 SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3014459') AND (timestamp_created >= '2025-12-04 15:17:03') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE access_log_school index_merge school_id,ix_ip_address_access_log_school ix_ip_address_access_log_school,school_id 767,4 2 Using intersect(ix_ip_address_access_log_school,school_id); Using where 8 0.000487 DESCRIBE `school_station`9 0.000417 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014459') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref school_id school_id 4 const 4 10 0.000377 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '4913')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref station_id station_id 4 const 1 11 0.000427 SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014459')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE Impossible WHERE noticed after reading const tables 12 0.000627 SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '764') AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref city_id city_id 5 const 35 Using where 13 0.000527 DESCRIBE `city`14 0.000387 SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '764') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 15 0.000677 SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '12')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ref prefecture_id prefecture_id 5 const 59 16 0.015837 SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '752', '753', '754', '755', '756', '757', '758', '759', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '780', '781', '782')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL city_id 4031 Using where 17 0.000527 DESCRIBE `prefecture`18 0.000407 SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '12') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE p const PRIMARY PRIMARY 4 const 1 19 0.000517 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014459') ORDER BY `distance` ASC LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref school_id school_id 4 const 4 Using index condition; Using filesort 20 0.000587 DESCRIBE `station`21 0.000357 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6779') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY PRIMARY 4 const 1 22 0.000467 DESCRIBE `station_unit`23 0.000377 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014459')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref school_id school_id 4 const 4 24 0.000447 DESCRIBE `station_station_unit`25 0.000357 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '4913')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s_s ref station_id station_id 4 const 1 26 0.000367 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '4914')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s_s ref station_id station_id 4 const 1 27 0.000347 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '4947')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s_s ref station_id station_id 4 const 1 28 0.000337 SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6779')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s_s ref station_id station_id 4 const 1 29 0.000307 SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE Impossible WHERE 30 0.000507 DESCRIBE `major_city`31 0.000507 DESCRIBE `city_major_city`32 0.000387 SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '764')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_m_c ref city_id city_id 4 const 1 33 0.000347 SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (false)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE Impossible WHERE 34 0.000867 DESCRIBE `summary_count_school`35 0.000597 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 36 0.000797 DESCRIBE `campaign_school`37 0.000697 SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3014459') AND (c_s.valid = 1) AND (c_s.expiration_date = "0000-00-00" || c_s.expiration_date IS NULL || c_s.expiration_date >= 2025-12-05) ORDER BY `timestamp_created` DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_s ref school_id,ix_expiration_date_campaign_school school_id 4 const 16 Using index condition; Using where; Using filesort 38 0.000497 SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014459') ORDER BY `time` ASC, `distance` ASC LIMIT 3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s_s ref school_id school_id 4 const 4 Using index condition; Using filesort 39 0.000407 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6779') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY PRIMARY 4 const 1 40 0.000387 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '4914') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY PRIMARY 4 const 1 41 0.000367 SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '4913') LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY PRIMARY 4 const 1 42 0.000657 DESCRIBE `category_school`43 0.000457 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014459') AND (c_s.valid = 1) LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_s ref school_id school_id 4 const 11 Using where 44 0.000437 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014459') AND (c_s.valid = 1) LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_s ref school_id school_id 4 const 11 Using where 45 0.000437 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014459') AND (c_s.valid = 1) LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_s ref school_id school_id 4 const 11 Using where 46 0.000447 SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014459') AND (c_s.valid = 1) LIMIT 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c_s ref school_id school_id 4 const 11 Using where 47 0.000637 DESCRIBE `dancer`48 0.000467 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 49 0.000477 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 50 0.000557 DESCRIBE `dancer_column`51 0.000437 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 52 0.000387 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 53 0.000347 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 54 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 55 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 9.02 MB
Message Memory use Component initialization 2.16 MB Controller action start 3.95 MB Controller render start 4.48 MB View render complete 5.58 MB Timers
Total Request Time: 2268 (ms)
Message Time in ms Graph Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 2117.34 Event: Controller.initialize 49.92 Event: Controller.startup 0.40 Controller action 0.14 Event: Controller.beforeRender 40.69 » Processing toolbar data 34.19 Rendering View 32.77 » Event: View.beforeRender 0.55 » Rendering APP/View/School/map_and_coupon.ctp 8.76 » » Rendering APP/View/Elements/adsense/336_288.ctp 0.06 » » Rendering APP/View/Elements/adsense/336_288.ctp #2 0.05 » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.18 » Event: View.afterRender 0.04 » Event: View.beforeLayout 0.03 » Rendering APP/View/Layouts/default.ctp 22.59 » » Rendering APP/View/Elements/header.ctp 0.36 » » Rendering APP/View/Elements/school/detailHeader.ctp 10.31 » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.15 » » » Rendering APP/View/Elements/breadcrumb.ctp 0.27 » » Rendering APP/View/Elements/menu.ctp 9.31 » » » Rendering APP/View/Elements/school/right-menu.ctp 9.06 » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.09 » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.08 » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 8.09 » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.06 » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.04 » » Rendering APP/View/Elements/rtt.ctp 0.08 » » Rendering APP/View/Elements/footer.ctp 0.81 » » Rendering APP/View/Elements/common/scoreEx.ctp 0.05 Event: View.afterLayout 0.00 ==== - Log
-
Variables +
View Variables
- breadcrumb(array)
- 0(array)
- nameスクール検索
- link(array)
- controllerschool_list
- actionindex
- 1(array)
- name東京
- link(array)
- controllerschool_list
- actionindex
- prefectureId12
- 2(array)
- name練馬区
- link(array)
- controllerschool_list
- actionindex
- prefectureId12
- cityId764
- 3(array)
- name新江古田駅
- link(array)
- controllerschool_list
- actionindex
- stationId6779
- 4(array)
- nameサンライズスタジオ
- link
- 0(array)
- ChargedNeighborSchoolSet(empty)
- SchoolScoreSet(object)
- School(object)
- id3014459
- nameサンライズスタジオ
- branch_name
- city_id764
- schoolgroup_id(null)
- mail_addresspepekoko0117@yahoo.co.jp
- lat35.7334932
- lon139.6762583
- telephone_number090-3918-3945
- homepage_urlhttp://sunrisestudio.jimdo.com/
- mobile_homepage_url
- blog_url
- open_hour
- holiday不定休
- post_code1760005
- town_address旭丘1-26-4 B1F
- building
- image_hashaa43ae9b91df860c
- image_extension_type2
- message_image_hash8cb84126bb24788a
- message_image_extension_type2
- is_registered_by_not_owner0
- is_opening1
- message_title初心者でも安心してレッスンが受けられるスタジオです♪
- message_body初心者大歓迎☆HIPHOP☆TAP☆フラダンス☆ベリーダンス☆ 全くダンスが初めての方を対象としたダンスレッスンです♪ 子供から大人まで、どなたでも楽しく踊れるレッスンです♪ レンタルスタジオ1時間500円~ご利用頂けます☆ ダンス教室を持ちたい方、個人練習でもご利用頂けます。 約30帖の広さがあるので、多人数での使用が可能です。 5名様でご利用した場合、1人あたり1時間100円☆ 詳しくは、090-3918-3945までお気軽にお問い合わせ下さい。 ☆ショートメールでも結構です☆ お待ちしております♪
- is_detail_address_opening1
- is_charged0
- registration_status1
- whole_staff_titleみぃー社長
- whole_staff_introductionスタジオレンタルは、1時間500円です!
- whole_staff_image_hash2b22ff0fc956964b
- whole_staff_image_extension_type2
- 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:24
- memo(null)
- adsenseCount0
- $request->data(empty)
- $this->validationErrors(empty)
- Loaded Helpers(array)
- 0Html
- 1Form
- 2Number
- 3SimpleGraph
- 4DebugTimer
- 5Toolbar
- 6HtmlToolbar
==== - breadcrumb(array)
-
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 216.73.216.35 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 /detail/L_3014459/map_and_coupon Query String Request Method GET Server Protocol HTTP/1.1 Gateway Interface CGI/1.1 Redirect Url /detail/L_3014459/map_and_coupon Remote Port 45374 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 216.73.216.35 Server Port 443 Server Addr 183.90.231.12 Server Name dance-schoolgv.net Server Software Apache Server Signature Http Cookie PHPSESSID=606scm16vrf24qelgle6diblcaeigsit 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 216.73.216.35 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 216.73.216.35 Http Host dance-schoolgv.net Ngx Cache Staticmode 1 Ngx Cache Normalfile 1 Failurecachetime 0 Https on Unique Id aTJ43ZfI-xFrYDdue2LUPAAAANU 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 aTJ43ZfI-xFrYDdue2LUPAAAANU Redirect Mef Proxy Addr 183.90.231.12 Fcgi Role RESPONDER Php Self /index.php Request Time Float 1764915421.7923 Request Time 1764915421 ==== -
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/SchoolController.php
- 1APP/Controller/AppController.php
- Other(array)
- 0APP/webroot/index.php
- 1APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
- 2APP/class/Sgv/Front/AttachableToDataSet/City.php
- 3APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
- 4APP/class/Sgv/Front/AttachableToDataSet/Station.php
- 5APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
- 6APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
- 7APP/class/Sgv/Front/SearchState/SchoolList.php
- 8APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
- 9APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
- 10APP/class/Sgv/Front/SearchCondition/SchoolList.php
- 11APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
- 12APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
- 13APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
- 14APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
- 15APP/class/Sgv/Front/InputForm/SchoolSearch.php
- 16APP/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)
====



