現在の教室登録院数 2603 件

Tropical NY　あおちゃんのスタジオの地図・アクセス・最寄駅・特典

メンバー登録   ログイン

ダンススクール

Tropical NY　あおちゃんのスタジオ

  • 地域
  • 東京都
    • |
  • 台東区
    • 満足度
    • 4.83
    • 講師の質 ： 4.83
    • 設備・機材 ： 3.83
    • レッスン内容 ： 5.00
    • 立地・雰囲気 ： 3.83
    • サポート対応 ： 4.17
    • 料金 ： 4.83

    口コミを書く

    Campaign 特典

    入会金無料キャンペーン中！

    • 有効期限
    • 2013-12-31

    体験レッスン後１ヶ月以内に入会の場合、
    入会金8,000円→無料

    プライベート体験レッスン5000円

    • 有効期限
    • 2013-12-31

    グループレッスンが不安な方、スケジュールが合わない方も安心！
    お好きな時間に、マイペースでできるマンツーマンのレッスンが期間限定で１時間3000円。
    お二人まで同じ料金（お二人で5000円）です！
    お友達、ご家族、カップル等で是非ご一緒にどうぞ。
    小学生から６０歳までご予約受付中。

    体験レッスン　キャンペーン中

    • 有効期限
    • 2013-12-31

    通常価格2000円→お二人以上の参加で1000円
    お友達、ご家族、カップル等でご一緒にどうぞ☆

    サルサ＆ブラジリアン・ワールドダンスクラス
    http://aochanstudio.com/contents/tlsn.html

    Access 地図・交通案内

    Tropical NY　あおちゃんのスタジオの地図・交通案内

    住所

    東京都 台東区 根岸５－１４－１７ 1階

    最寄駅

    • CakePHP
    • History
      +

      Request History

      4 previous requests available
      ====
    • Session
      +

      Session

      • _Token(array)
        • key09120bea15f4a1162e1d42779977a520f2ed69bf
        • allowedControllers(empty)
        • allowedActions(empty)
        • unlockedFields(empty)
        • csrfTokens(array)
          • f319de278ac2c762cb1dca9336690a3700e83ed91785988823
          • 1bf6b41bcc5b52d563324fab479386e86659853e1785988824
          • 7377c79b1e87898f80e9af62bd75b1acc70606731785988824
          • 4079d99e5b4856007c9d8b08dabcda310b1d3dd91785988824
          • 74598a590edb506d5b47fa380a4dc0aad1a050601785988824
          • 9f805345a6f3a82b7dfdec8deaef6b5b0eab9d0a1785988825
          • 2b18a8b8c197358114097dab5ead284ca1ee10ce1785988825
          • 90c9c07a34689dd887dc0e373234dc0561ddac901785988825
          • 19854278b145038ecef353d9050634140af494991785988825
          • 172e719a796cfc56ffc9608066a45e362d564d961785988826
          • 98d711a70bc36de1d8874a82618d371dbaeb5c4c1785988826
          • fa593296f806efaec787c9e1bfd0b6cbb60c316e1785988826
          • a28f53d549bb4933b6845637c8c4a9d158b485e01785988827
          • cb04e11566b270b7db1c898e2a752a8ca69eac821785988827
          • e2e11a1ea401cbb2075afa5c4ecd8835b23bf8161785988827
          • 4c2a755a9b075331e513d869ce7451983db5b4201785988827
          • 2043f26b98183644f9c872cc55649ae7263af9391785988828
          • 90f661ecf57a7cb968b0130ce3d8d31e3808fd6f1785988828
          • a2424ab4304b5cb17c1497f691e875ab611c2bf31785988828
          • 86ec7e60ec7646d4c06648cff660fe7f8b6bb6a71785988828
          • 7b3ab4ce9c1f370a2b4935f5f01a2b27b06d6af21785988829
          • 49eec77b7fb31694deda0225b02df6f2d96020b81785988829
          • a738eff9017e9f4220c19eff82c098206704a8751785988829
          • f2e7f1b520e41eb30f4ea518c9ae28e9b556cccd1785988829
          • 65a8b592e465f71ed76191148284c52e979c05841785988830
          • 97f64ad408ec31cf2e56f5283e3278c51ff2979d1785988830
          • 1681d85c81dfd44d7367bcee81f9ff3958469f041785988830
          • d6ab1ea53cb1a5de7b9fadb4d61cb1697a6f9fac1785988831
          • 7166e40c7461baafc83ac922461f2d868f6c21141785988831
          • f6cd013ff0ab779446b865c534cf1dca92cc95621785988831
          • 1c923803c595a4956a686337a9f4a30595cc820b1785988831
          • de49bcfa1a1ccda489861ecc6d1d85a5c653910a1785988832
          • f94bce6b4ff581f2f786d00d75f98d1c6816c2551785988832
          • a27f21429dae213fa1a7e4f14c3663ca4cacb1561785988832
          • ce6c34df4c4e304aec2bfe24f066778c7e54cbfc1785988833
          • 8f45d90af41da8c32e459d797bad8f867ef204061785988833
          • ed68458571e3114d4bf813d89b281c59540099b91785988833
          • a399179a8adeef12ee01b9853de21b984871a67a1785988833
          • 66663d08cde73cbe392bf977cd2ff3e72cc1a7481785988834
          • 4e3a92425736b6f7e6e008332677bbc3f347070a1785988834
          • 944a26ddd6a43d0d2c18625f11330d870a8694861785988834
          • 1efba221b38d7176b688cc252d75c086cfd7deaf1785988835
          • 56a5a2826c03151d35c8368f062468e32d0c12021785988835
          • e788bf33260a600b7aa1451291ee31b439986a691785988835
          • 57cbe73642913f18579d1b605cfd3be6cf817aab1785988835
          • 18bb6194472dc39290246c52b0af24a3502c2ded1785988836
          • 8567482d4143de4fa79af1d07af9652b770a9ee31785988836
          • 69ec141d16b5eaf8e1fd3b7ea7a5ff837110f41b1785988836
          • c35c1e806a3128b7e2d18fd94718f1811afe2fd81785988836
          • 6ce2116bb147c164b597389e97cee417078530851785988837
          • 4e49ede1bfac4e218435d7a3ab033b1dd230f6dd1785988837
          • 6a60115fa0ad17d5bb35b21ae87baf1fa2690aa01785988837
          • 163cc04bb0aa3e3752ea7934b0bab223972081c81785988837
          • 9001b1a256d51e7327cafa892ac09d761f96cb941785988837
          • d678496f1e68743cadf6d91899515b4a5d7fb9781785988838
          • ccd2c9245a10000a9ecde725f42128dad8e5c0f91785988838
          • 91cb0c0ef824677cddf43da07443bc2ffb2d3ca51785988838
          • 4aac3f78aab471e4d8a9c9958d44c5ac5159ec2d1785988839
          • e617eb2a2f73861132ce0dc15be63d03a47ab8e71785988839
          • 1c10362905af40221868ab3ef0b3acb7a408e0191785988839
          • 4d19c2dad6234ac7e3e22c5d772ba6ca5073b8761785988840
          • 0b592d1755b02bf1a4fedf1d1b09fa8f3961a97d1785988840
          • bf5b9a30f418b6db3650dd4df50146578a08f6771785988840
          • 3cb642cf6bae6dba9fc0ba39abff5ec69e549ffa1785988840
          • 158e8e7d235041cbb711765b45f54988e09af05a1785988841
          • 8d1d5d486c58749666c20cb25187acfc6f56958b1785988841
          • 4969ef001bc8181eaf58f13cfd2e671c4105b6b51785988841
          • b3651e50d1ca8278d6a1464cef283b48883108351785988841
          • 7b1f4e01138da1c5619f335148445e9e7a4105181785988841
          • fd5f8b3ca607db28463963542fd7b36c12cd46a41785988841
          • 1de35ebbf6be86c295104636e5fffffa3d8690ae1785988842
          • 4c66c1a2ff65ce6d9f6c2f12a19aeaeb2bd5c4221785988842
          • c036f6fa645857a59476e8b3d76d76ac8f036c951785988842
          • 8e768e926d006ad406585f3c3c7917e5fa74cd061785988842
          • 9ca5a286af435388d72df581f5f2c5e80263ead41785988842
          • ddbe710a7a1567c86e82cddacef771875cffa57d1785988843
          • 302a4fae7f6f389f5dee483ff1a7f02bea933f491785988843
          • 8c298aa3e44a882834287f3796e8ebbaf30f1a8b1785988843
          • e6a50b7517c8255281e74776ae1bdf507cb813dc1785988843
          • 88eecdc43c3d98b3eb00f58c95ad99db91c8993e1785988843
          • 898f427f179c832fb404bfe7d64ab1c59bb0beca1785988844
          • 4dafecda6033bc5bb2139df56545a9aae90112a91785988844
          • 8219df8b1c4e7875eb4a1ea2aed20413937b26061785988844
          • 1a77c25a4fb684f58fc1879ff3cf2b71c09bace21785988844
          • 6cdf3243148a7c25c34f5eba0f553f80674d641e1785988844
          • c8fc8de9693d7b0f0385e30382dea6dae8eb44491785988844
          • 315140a1ec9fa08365637d876262193fc87a35c91785988845
          • 98fda7fc6a4d0fb1d6e9a7aff94cccd0817145151785988845
          • f9a1da9128d7bf2141a66819ad46a235ef5638921785988845
          • a2d9db9f99fafcca19efc2b157e1567c9e2a861f1785988845
          • f823cfd184a13ae227ba4ae9ad7e8b91ff9c570b1785988845
          • a46dfb767c35df81ccaf37eb4959ab22926a09be1785988846
          • 4610fd34cd7a3f9e84e003aa9705fd37375a12b71785988846
          • 203c7f557627bbe71660002b4da0d73ccf2571381785988846
          • c0788f4cd970f6a904a02ba5428b50aee097728b1785988846
          • 352fb6ba95f109abaf6fa455b13877e422d54eab1785988846
          • 10308c38217cf8f9a36d5fcec08e2703236fdd5c1785988846
          • 4463d890d05262966a7d5095f1c71f8414b398981785988847
          • ed52bf0403d1ffed87b53de9b82b563d6e9d4e161785988847
          • 09120bea15f4a1162e1d42779977a520f2ed69bf1785988847
      ====
    • Request
      +

      Request

      Cake Params

      • plugin(null)
      • controllerschool
      • actionmap_and_coupon
      • named(empty)
      • pass(empty)
      • schoolId3014782
      • _Token(array)
        • key09120bea15f4a1162e1d42779977a520f2ed69bf
        • 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: 58 queries / 0.107457 sec
      No. time query
      1 0.001967
      connect
      2 0.000997
      DESCRIBE `school`
      3 0.000477
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3014782') AND (s.registration_status = 1) AND (s.is_opening = 1) LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      4 0.000647
      DESCRIBE `school_score`
      5 0.037017
      SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3014782') 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 32162 Using where
      6 0.002877
      DESCRIBE `access_log_school`
      7 0.008507
      SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.217.54') AND (school_id = '3014782') AND (timestamp_created >= '2026-08-05 12:30:47') LIMIT 1
      id 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 4 Using intersect(ix_ip_address_access_log_school,school_id); Using where
      8 0.000657
      DESCRIBE `school_station`
      9 0.000427
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014782') LIMIT 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 7
      10 0.000467
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '1313')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref station_id station_id 4 const 11
      11 0.000677
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3013459', '3015096', '3014531', '3014531', '3014782', '3015756', '3015839', '3015911', '3016194', '3016285', '3016070')) 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 range PRIMARY PRIMARY 4 10 Using where
      12 0.000857
      SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '749') 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 55 Using where
      13 0.000587
      DESCRIBE `city`
      14 0.000707
      SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '749') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c const PRIMARY PRIMARY 4 const 1
      15 0.000637
      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.020477
      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.000667
      DESCRIBE `prefecture`
      18 0.000417
      SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '12') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE p const PRIMARY PRIMARY 4 const 1
      19 0.001447
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014782') ORDER BY `distance` ASC LIMIT 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 7 Using index condition; Using filesort
      20 0.000677
      DESCRIBE `station`
      21 0.000417
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5366') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      22 0.000727
      DESCRIBE `station_unit`
      23 0.000477
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014782')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref school_id school_id 4 const 7
      24 0.000677
      DESCRIBE `station_station_unit`
      25 0.000407
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1313')
      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.000347
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1656')
      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.000367
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5366')
      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 = '5367')
      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.004857
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6815')
      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
      30 0.000377
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6816')
      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
      31 0.000277
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6817')
      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
      32 0.000367
      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
      33 0.000557
      DESCRIBE `major_city`
      34 0.000607
      DESCRIBE `city_major_city`
      35 0.000607
      SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '749')
      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
      36 0.000627
      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
      37 0.000737
      DESCRIBE `summary_count_school`
      38 0.000507
      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 1
      id 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
      39 0.000817
      DESCRIBE `campaign_school`
      40 0.000567
      SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3014782') AND (c_s.valid = 1) AND (c_s.expiration_date = "0000-00-00" || c_s.expiration_date IS NULL || c_s.expiration_date >= 2026-08-06) ORDER BY `timestamp_created` DESC
      id 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 3 Using index condition; Using where; Using filesort
      41 0.000457
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014782') ORDER BY `time` ASC, `distance` ASC LIMIT 3
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref school_id school_id 4 const 7 Using index condition; Using filesort
      42 0.000517
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5366') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      43 0.000417
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6815') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      44 0.000377
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6816') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      45 0.000677
      DESCRIBE `category_school`
      46 0.000467
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014782') AND (c_s.valid = 1) LIMIT 5
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c_s ref school_id school_id 4 const 5 Using where
      47 0.000447
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014782') AND (c_s.valid = 1) LIMIT 5
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c_s ref school_id school_id 4 const 5 Using where
      48 0.000497
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014782') AND (c_s.valid = 1) LIMIT 5
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c_s ref school_id school_id 4 const 5 Using where
      49 0.000467
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014782') AND (c_s.valid = 1) LIMIT 6
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c_s ref school_id school_id 4 const 5 Using where
      50 0.002367
      DESCRIBE `dancer`
      51 0.000537
      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` DESC
      id 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
      52 0.001427
      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
      53 0.000587
      DESCRIBE `dancer_column`
      54 0.000497
      SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC
      id 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.000667
      SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC
      id 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
      56 0.000647
      SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC
      id 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
      57 0.000477
      SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC
      id 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
      58 0.000517
      SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC
      id 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 5.93 MB

      Message Memory use
      Component initialization 2.16 MB
      Controller action start 3.97 MB
      Controller render start 4.39 MB
      View render complete 5.48 MB

      Timers

      Total Request Time: 870 (ms)

      Message Time in ms Graph
      Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 671.83
      Event: Controller.initialize 109.51
      Event: Controller.startup 0.49
      Controller action 0.14
      Event: Controller.beforeRender 17.65
      » Processing toolbar data 10.77
      Rendering View 36.97
      » Event: View.beforeRender 1.42
      » Rendering APP/View/School/map_and_coupon.ctp 9.39
      » » Rendering APP/View/Elements/adsense/336_288.ctp 0.23
      » » Rendering APP/View/Elements/adsense/336_288.ctp #2 0.08
      » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.19
      » Event: View.afterRender 0.03
      » Event: View.beforeLayout 0.03
      » Rendering APP/View/Layouts/default.ctp 25.16
      » » Rendering APP/View/Elements/header.ctp 0.37
      » » Rendering APP/View/Elements/school/detailHeader.ctp 8.55
      » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.11
      » » » Rendering APP/View/Elements/breadcrumb.ctp 0.21
      » » Rendering APP/View/Elements/menu.ctp 13.29
      » » » Rendering APP/View/Elements/school/right-menu.ctp 13.10
      » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.07
      » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.06
      » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 11.32
      » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.09
      » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.87
      » » Rendering APP/View/Elements/rtt.ctp 0.20
      » » Rendering APP/View/Elements/footer.ctp 1.16
      » » Rendering APP/View/Elements/common/scoreEx.ctp 0.07
      Event: View.afterLayout 0.00
      ====
    • Log
      +

      Logs

      There were no log entries made this request

      ====
    • 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
            • cityId749
        • 3(array)
          • name三ノ輪駅
          • link(array)
            • controllerschool_list
            • actionindex
            • stationId5366
        • 4(array)
          • nameTropical NY　あおちゃんのスタジオ
          • link
      • ChargedNeighborSchoolSet(empty)
      • SchoolScoreSet(object)
        • 0(object)
          • id3805811
          • school_id3014782
          • kuchikomi_questionnaire_item_id1
          • score4.83
          • is_latest1
          • timestamp_created2021-08-03 15:06:46
          • timestamp_modified2021-08-03 15:06:46
        • 1(object)
          • id3805812
          • school_id3014782
          • kuchikomi_questionnaire_item_id2
          • score3.83
          • is_latest1
          • timestamp_created2021-08-03 15:06:46
          • timestamp_modified2021-08-03 15:06:46
        • 2(object)
          • id3805813
          • school_id3014782
          • kuchikomi_questionnaire_item_id3
          • score5.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:46
          • timestamp_modified2021-08-03 15:06:46
        • 3(object)
          • id3805814
          • school_id3014782
          • kuchikomi_questionnaire_item_id4
          • score3.83
          • is_latest1
          • timestamp_created2021-08-03 15:06:46
          • timestamp_modified2021-08-03 15:06:46
        • 4(object)
          • id3805815
          • school_id3014782
          • kuchikomi_questionnaire_item_id5
          • score4.17
          • is_latest1
          • timestamp_created2021-08-03 15:06:46
          • timestamp_modified2021-08-03 15:06:46
        • 5(object)
          • id3805816
          • school_id3014782
          • kuchikomi_questionnaire_item_id6
          • score4.83
          • is_latest1
          • timestamp_created2021-08-03 15:06:46
          • timestamp_modified2021-08-03 15:06:46
      • School(object)
        • id3014782
        • nameTropical NY　あおちゃんのスタジオ
        • branch_name
        • city_id749
        • schoolgroup_id(null)
        • mail_addresstropicalny@hotmail.com
        • lat35.7273727
        • lon139.7885774
        • telephone_number080-1253-1003
        • homepage_urlhttp://www.danceclub.jp
        • mobile_homepage_urlhttp://www.aochanstudio.com/
        • blog_urlhttp://blog.goo.ne.jp/tropicalny/
        • open_hour
        • holiday
        • post_code
        • town_address根岸５－１４－１７
        • building1階
        • image_hashd6ba53edc6e62e27
        • image_extension_type2
        • message_image_hashf7b1143ae914a026
        • message_image_extension_type2
        • is_registered_by_not_owner0
        • is_opening1
        • message_title誰でも気持ち良く踊れる魔法のスタジオ！
        • message_body子供から、学生、ＯＬ、サラリーマン、主婦の方。 男性も安心してお越しください。 スタジオ代表「あおちゃん」は男性インストラクターです。 ★ニューヨーク、ブエノスアイレス、バンコク、イスラエルに支部あり。 社会人、学生、外国人まで幅広い層の方との出会いがあります。 「ダンスと音楽は最高のコミュニケーション」 面白い人生を送りたい方、送っている方、お待ちしています！
        • is_detail_address_opening1
        • is_charged0
        • registration_status1
        • whole_staff_title主宰あおちゃん
        • whole_staff_introduction日本のサルサ＆ブラジリアンダンスのパイオニアとして活躍後、１９９６年活動拠点をニューヨークに移し、Tropical NYを設立、レッスンやパフォーマンスを行う。また海外、国内で多数のワークショップを行う。音楽の気持ち良さを表現した踊りは、海外にもファンが多い。 ２００４年帰国後、東京を中心に現在活動中。 浅草サンバカーニバルのダンス審査員も務める。 ２０年以上の実績と経験をいかし、日本人にあったプログラムで、バラエティーに富んだレッスンを行っています。生徒は楽しんでいるだけで、いつの間にか自然に踊れるようになっています。そのレッスン方法は、大学でも高い評価を受け、身体コミュニケーションの講義にも採用されています。
        • whole_staff_image_hash6bd46f39f072d200
        • whole_staff_image_extension_type1
        • is_kuchikomi_notice_mail_receiving1
        • banner_image_hash(null)
        • banner_image_extension_type(null)
        • school_type1
        • has_kids_course1
        • has_beginner_course1
        • score4.83
        • kuchikomi_count6
        • timestamp_created0000-00-00 00:00:00
        • timestamp_modified2021-08-03 15:06:46
        • memo(null)
      • 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 216.73.217.54

      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_3014782/map_and_coupon
      Query String
      Request Method GET
      Server Protocol HTTP/1.1
      Gateway Interface CGI/1.1
      Redirect Url /detail/L_3014782/map_and_coupon
      Remote Port 44250
      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.217.54
      Server Port 443
      Server Addr 183.90.231.12
      Server Name dance-schoolgv.net
      Server Software Apache
      Server Signature
      Http Cookie PHPSESSID=brt11se55sj8camjh4pkr24rg563ntmm
      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.217.54
      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.217.54
      Http Host dance-schoolgv.net
      Ngx Cache Staticmode 1
      Ngx Cache Normalfile 1
      Failurecachetime 0
      Https on
      Mmdb Addr 216.73.217.54
      Unique Id anP_5lz3i20-K79y8XgwQgAAALM
      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 Mmdb Addr 216.73.217.54
      Redirect Unique Id anP_5lz3i20-K79y8XgwQgAAALM
      Redirect Mef Proxy Addr 183.90.231.12
      Fcgi Role RESPONDER
      Php Self /index.php
      Request Time Float 1785987046.8084
      Request Time 1785987046
      ====
    • 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
      • 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/InputForm/Auth/Login.php
          • 6APP/class/Sgv/Front/InputItem/Auth/Login.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
      ====

    Special Column

    ページの先頭へ戻る