現在の教室登録院数 2603 件

スタジオ プランニング遊 南森町の地図・アクセス・最寄駅・特典

ダンススクール

スタジオ プランニング遊 南森町

  • 地域
  • 大阪府
  • |
  • 大阪市北区
  • Campaign 特典

    入会金無料キャンペーン

    • 有効期限
    • 2012-10-31

    普段なら8000円の入会金が必要なところが
    なんと只今入会金無料キャンペーン中!ということで
    小さな子供から大きな大人まで誰でも0円です!
    ダンス習うなら今がチャンス!
    YUKI先生(女性)が丁寧に指導してくれます。
    体験レッスンもできますのでお気軽にお問い合わせください。

    詳しくはホームページへゴー!ゴー!
    一緒にダンスを楽しみましょう!

    Access 地図・交通案内

    スタジオ プランニング遊 南森町の地図・交通案内

    住所

    大阪府 大阪市北区 天神橋2丁目北2-26 マルサンビル501

    最寄駅

    • CakePHP
    • History
    • Session
      +

      Session

      • _Token(array)
        • key0d0dc22ba0efc666b38e746d3fd2759329a1a10f
        • allowedControllers(empty)
        • allowedActions(empty)
        • unlockedFields(empty)
        • csrfTokens(array)
          • 455115939eae0bbc2d1c94752ae6538c408accde1764912161
          • e6c331ae4e1590dd5ddaf0d32db3eeed46efe1c91764912161
          • f280a254f4f13666c782c5e70b8d8c33c8388b621764912161
          • 20001b584bca2d0d14857a545c7335eea907e7de1764912161
          • 85b3299a1f70ccfb3d3036c1e05a817ea1b65ce81764912161
          • abd82e974ec32772b9d0e9d061f5070b2b82a43e1764912161
          • 119fae0a45e128b81aa67254f000e0a62b63d75d1764912162
          • 8dc49fe7d443e801db85363f080ff7f4f46294f01764912162
          • 8bc31e7e5f75c5ba3b140c818dabac8127573f9d1764912162
          • 1e50413ac2d671d3918ff27847ce0d28d28bb1621764912163
          • 84705de227d0ed49bd0d6f99843040d0c135669a1764912163
          • f69d6f21d4f393b1c80f422c97dee41a72d74c0d1764912163
          • d49e360cdd0b03b7c9893115f31e7a959ce905dc1764912163
          • 949a5edd5ab1586910fd1700782d960f1ec8a3181764912164
          • 19665f44e39feffa38681ce23355a9b89dbd6c061764912164
          • c66f8d8bd319936d9ccf378ce99508eb1029e7f01764912164
          • 8b17117fb9a460e58ac8a26820742f9cc2d90f0c1764912164
          • 0e4cbd2a9c644f8dddfdf6faba91e28bfe8f676c1764912164
          • cd455db4037a1cefcf00f7ba68f30662afd903a01764912164
          • ac20ea28fc9a218db7375a1c8d190c69b6395d211764912165
          • 6533aff3521beddd64117475fb934ac4150a43571764912165
          • c6b98b6e1f8ac974748f2150b93b8acd7c034da21764912165
          • 1b105f28e6b235515b5e437aa6afb2c3120b54211764912165
          • 25fc6b7682f6b628691368b00231a339d22a7c131764912166
          • 8f66372e9a85595998c7bc4e8ddbc2caa0e76b761764912166
          • 6afe2aa59b61f62e924d7e5b55ddbfb2223a5e641764912166
          • b5c19cd3350550547feb0ef9124c7937c31906161764912166
          • 8cb011ba6c7908f478bff37e38a424ce47abc5b21764912167
          • fe4fdf9806023815f831a610c9e41f40addc6f911764912167
          • 5abfa8e086f0c8b4e7951577cd73b207d1f940f21764912167
          • ad075b4ab8a3c80d83e8a34cc4001bb0ba2b3a2c1764912167
          • 0fba66f8d01ce86727daabf5174a93332a1140471764912167
          • 33c592fb21e5a55c286b4c9707e0bec75c994c1f1764912167
          • 92b3cf6ad69675737a80afd7861d672b993748bc1764912168
          • f3c20a769d51dfcad2f0ff92cece86872e3e69cc1764912168
          • 459ac27ddca86432b7e7713fa625a2244fcf11b71764912168
          • 0f64c86f77fe397b3d48b330ce353b243c4bf2fa1764912168
          • 9e3e93439c54aeba2ce714139e0aeae8d909c09c1764912168
          • 4653fd47fb75075be725e8ddbd0c113cb523ebde1764912168
          • 0b2dbb83a937babf2ea277b00b4569c580adf66c1764912169
          • 2b7bd350a777d97871a35542e237936ac26201e91764912169
          • d2439457e5202fc5db29c2427275137960c2fa751764912169
          • f7c9990db225c8f04996981309ff1cb54561bb301764912169
          • 6df79b8f513e1bbc555a0c8a087bf19caca3db691764912170
          • d725df4f775ad6f030d8e75f011033a576160c541764912170
          • 64416b0e437e02bac6e59a5fc34f4c60d0ef2eb61764912170
          • 7afdbe5301326457f7e0d457bbad224c51942e0e1764912170
          • e7c093d55ec43407f8f014ebf95f58c3fc7009fd1764912170
          • 8648957ac1e68dd56aee324b38bf22e5dd8087661764912171
          • b8de3b6b8d502c8315210b654edbba66fa11fac61764912171
          • 2844f0fda09054545b9ae110de71fa8f36b9dfd31764912171
          • bad64d7736b1b4ea0fc32dc42385518bdea5fd801764912171
          • 8beda1fead145689f7e3b4b780585fa9e869a46f1764912172
          • f6d8714e477fb9f3a40f6d3a83578f49ba1e56f01764912172
          • d55340e13f2517c2d1af7c8c121e8da19d7b660b1764912172
          • d87b798f6a5ee139440bcfcb7aeccc033aea09711764912172
          • 00caa0aba8e2c8b99467684a74398e48412606471764912173
          • b6605739aba4ab02f90d17897b66b93c6faea94c1764912173
          • 4595539ca4fa9d105e3e6b378d3adc78c4b854391764912173
          • d5cdacf1061b0dff95bd3ab0cff57f13ee700e031764912173
          • fab51494230a58ccc953bb0997cd5aa5d0531bf51764912173
          • 13e54a9a37f4f175bd310d0d1f39446c4088a7ea1764912174
          • 5a6e4f8818117d64ddadea6410956651bab975c91764912174
          • 6f4f568350046d316112ab8faee02ed29bf649a11764912174
          • ff3c443a4732ada4382a94715cedf50bcc4bd0831764912174
          • 8eb4f1c21c456000f761461a038b0a2efc93278c1764912175
          • 31532f9a7d8388a90c4252f79051cc2ed5c353561764912175
          • d3182ed916e1409ea4809cd78976ffcbf42928251764912175
          • dc8d77fa0f831e215a1a6cf4b9adb94ec1fee9b91764912175
          • 80cd98c6ddb03cd0f13e140ae6140fc73d2dc9fd1764912175
          • 887f74c68a2442f6bf2f285f24568d55adbc58ea1764912176
          • ac9a36a989d529a23107c05dd1c5375dff1e5be31764912176
          • 831b7804911b93bc5f54142208a58e82b324148c1764912176
          • 6f26fd6293c61a193689f007100078395f02ae8b1764912176
          • 5823b6791690b77c0b1a379df71fd7d8b3732b761764912176
          • 83e11c00ceac607792de60b014ebf92cdd936a431764912177
          • 48e2f3b9bcb26fc85885af7428dbdd03290a15971764912177
          • cae5aa72b16f899971ce0ff698bd476295c35cc81764912177
          • 054edcc8a33b42c2406a73df5f9c77739c362ec81764912177
          • a8b1939537c23178b4f8ecab08692689607606f71764912177
          • 55f89348beb041cddcd8d7e01b00fad3b7ff478f1764912177
          • b8639c5b8ab002b61fc29dc0a8790826192a5e1b1764912178
          • 248e8fc2cff2f9ffb74b10a596909de97594e0b81764912178
          • afd6015555a1b83e9d45f0e3a2bff3dd45498f581764912178
          • 235abb051a5abb80c7a6b4f68a2d9086870b9fcb1764912178
          • 9b79a58eef02243707f51f9b8f971e31afc6defc1764912178
          • 80a9f1b3a824bcb8bab10a9e63d727acc06e604f1764912178
          • c0305315638019d74bb1969771f5eb94e81383a31764912179
          • 46e28547b0ea1636127d84dc8f30450dc3b9be1e1764912179
          • d1a162c7bfb2b271b166c6bdb32dac1ef4b0bb291764912179
          • d621434ffd6abb3d4fc2aff2431169192eec23eb1764912179
          • 1db6e4d638520ea341f1ebb34abea2daad0fd2331764912179
          • c0fc793d734b546012d0ef1a78ec4cb738f564c11764912180
          • bd45b7461f2f5433dfed3c650aaaf6ce0d63be231764912180
          • 94f4bba5d7023c4412a5748c2a0dc24bd763c04f1764912180
          • e8c77e02c51fb202dc9551c4110b37736c60aefb1764912180
          • 24e6a6159f1a7b3d0f9d88cf9194c5c78b5cc2041764912181
          • 70d725471de605083d915f1f997761872d5a4d551764912181
          • 120dfcfc065c7350648e849a0f05475b681f48471764912181
          • 06da47e96be62d58a2a202db9f3e9a6547a0cb5c1764912182
          • 0d0dc22ba0efc666b38e746d3fd2759329a1a10f1764912182
      ====
    • Request
      +

      Request

      Cake Params

      • plugin(null)
      • controllerschool
      • actionmap_and_coupon
      • named(empty)
      • pass(empty)
      • schoolId3014970
      • _Token(array)
        • key0d0dc22ba0efc666b38e746d3fd2759329a1a10f
        • 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: 60 queries / 0.070267 sec
      No. time query
      1 0.004627
      connect
      2 0.000777
      DESCRIBE `school`
      3 0.001717
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3014970') 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.000727
      DESCRIBE `school_score`
      5 0.004757
      SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3014970') 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.000617
      DESCRIBE `access_log_school`
      7 0.006427
      SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3014970') AND (timestamp_created >= '2025-12-04 13:53:02') 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 1 Using intersect(ix_ip_address_access_log_school,school_id); Using where
      8 0.007257
      DESCRIBE `school_station`
      9 0.000457
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014970') 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 9
      10 0.006037
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '3205')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref station_id station_id 4 const 24
      11 0.000967
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014473', '3014970', '3013182', '3015116', '3014838', '3015118', '3015117', '3014595', '3014570', '3015355', '3015416', '3015128', '3015684', '3015720', '3015878', '3015880', '3015759', '3015850', '3016083', '3016103', '3015539', '3016186', '3016211', '3015985')) 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 24 Using where
      12 0.000857
      SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '1450') 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 73 Using where
      13 0.000547
      DESCRIBE `city`
      14 0.000417
      SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '1450') 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.000577
      SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '27')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c ref prefecture_id prefecture_id 5 const 61
      16 0.003537
      SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1277', '1441', '1442', '1443', '1444', '1445', '1446', '1447', '1448', '1449', '1450', '1451', '1452', '1453', '1454', '1455', '1456', '1457', '1458', '1459', '1460', '1461', '1462', '1463', '1464', '1465', '1466', '1467', '1468', '1469', '1470', '1471', '1472', '1473', '1474', '1475', '1476', '1477', '1478', '1479', '1480', '1481', '1484', '1485', '1486', '1487', '1488', '1489', '1490', '1492', '1493', '1494', '1495', '1496', '1497', '1498', '1499', '1501', '1504', '1505', '1506')) 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 city_id city_id 5 665 Using index condition; Using where
      17 0.000597
      DESCRIBE `prefecture`
      18 0.000467
      SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '27') 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.000437
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014970') 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 9 Using index condition; Using filesort
      20 0.000767
      DESCRIBE `station`
      21 0.000437
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '3205') 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.000527
      DESCRIBE `station_unit`
      23 0.001857
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014970')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref school_id school_id 4 const 9
      24 0.000527
      DESCRIBE `station_station_unit`
      25 0.000387
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '3205')
      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.000377
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '3206')
      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.000377
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '3193')
      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.000397
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6175')
      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.000397
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '3192')
      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.000417
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6176')
      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.000467
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6174')
      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.000347
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6178')
      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
      33 0.000347
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6177')
      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
      34 0.000347
      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
      35 0.000567
      DESCRIBE `major_city`
      36 0.000497
      DESCRIBE `city_major_city`
      37 0.000457
      SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '1450')
      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
      38 0.000337
      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
      39 0.000647
      DESCRIBE `summary_count_school`
      40 0.000497
      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
      41 0.000747
      DESCRIBE `campaign_school`
      42 0.000587
      SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3014970') 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` 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 1 Using index condition; Using where; Using filesort
      43 0.000477
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014970') 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 9 Using index condition; Using filesort
      44 0.000357
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '3205') 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.000397
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '3206') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      46 0.000337
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '3193') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      47 0.007417
      DESCRIBE `category_school`
      48 0.000477
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014970') 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 1 Using where
      49 0.000417
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014970') 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 1 Using where
      50 0.000367
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014970') 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 1 Using where
      51 0.000427
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014970') 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 1 Using where
      52 0.000587
      DESCRIBE `dancer`
      53 0.000547
      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
      54 0.000447
      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
      55 0.000507
      DESCRIBE `dancer_column`
      56 0.000877
      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
      57 0.001667
      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
      58 0.000447
      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
      59 0.000427
      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
      60 0.000437
      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 7.43 MB

      Message Memory use
      Component initialization 2.16 MB
      Controller action start 3.96 MB
      Controller render start 4.47 MB
      View render complete 5.51 MB

      Timers

      Total Request Time: 1828 (ms)

      Message Time in ms Graph
      Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 1610.61
      Event: Controller.initialize 72.68
      Event: Controller.startup 0.52
      Controller action 0.18
      Event: Controller.beforeRender 35.55
      » Processing toolbar data 27.02
      Rendering View 45.73
      » Event: View.beforeRender 1.94
      » Rendering APP/View/School/map_and_coupon.ctp 9.50
      » » Rendering APP/View/Elements/adsense/336_288.ctp 0.09
      » » Rendering APP/View/Elements/adsense/336_288.ctp #2 0.06
      » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.21
      » Event: View.afterRender 0.04
      » Event: View.beforeLayout 0.18
      » Rendering APP/View/Layouts/default.ctp 32.88
      » » Rendering APP/View/Elements/header.ctp 0.45
      » » Rendering APP/View/Elements/school/detailHeader.ctp 16.69
      » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.13
      » » » Rendering APP/View/Elements/breadcrumb.ctp 0.29
      » » Rendering APP/View/Elements/menu.ctp 12.21
      » » » Rendering APP/View/Elements/school/right-menu.ctp 11.97
      » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.08
      » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.07
      » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 10.84
      » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.10
      » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.08
      » » Rendering APP/View/Elements/rtt.ctp 0.13
      » » Rendering APP/View/Elements/footer.ctp 1.31
      » » Rendering APP/View/Elements/common/scoreEx.ctp 0.08
      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
            • prefectureId27
        • 2(array)
          • name大阪市北区
          • link(array)
            • controllerschool_list
            • actionindex
            • prefectureId27
            • cityId1450
        • 3(array)
          • name南森町駅
          • link(array)
            • controllerschool_list
            • actionindex
            • stationId3205
        • 4(array)
          • nameスタジオ プランニング遊 南森町
          • link
      • ChargedNeighborSchoolSet(empty)
      • SchoolScoreSet(object)
        • School(object)
          • id3014970
          • nameスタジオ プランニング遊
          • branch_name南森町
          • city_id1450
          • schoolgroup_id(null)
          • mail_addressyuya-ogawa@planning-you.co.jp
          • lat34.697993100000
          • lon135.511461300000
          • telephone_number06-6882-0525
          • homepage_urlhttp://locoplace.jp/t000187971/contents/
          • mobile_homepage_url
          • blog_url
          • open_hour9:00~19:00※問い合わせ営業時間
          • holiday無し
          • post_code(null)
          • town_address天神橋2丁目北2-26
          • buildingマルサンビル501
          • image_hash34a16795003c02f1
          • image_extension_type2
          • message_image_hashf70584b5dbdec998
          • message_image_extension_type2
          • is_registered_by_not_owner0
          • is_opening1
          • message_title丁寧さはどこにも負けません!体験すればわかります!
          • message_body丁寧なのには理由があります。 まず有名なダンススクールなどに通ってみた人の辞めた理由でうまくなれず皆についていけなくなり楽しくなくなると言う理由がよく聞かれます。 やはり有名なところでは生徒も多くなる分一人一人を指導する時間が無くなってしまいがちです。 ですが当ダンススクールはそうなる事を一番嫌っています、やっぱりダンスは楽しく踊らないと♪ 楽しく♪厳しく!丁寧に‼をもっとうに指導しておりますので、全くの未経験者でも、お子様でも必ず踊るのが楽しくなる様務めさせて頂きます! インストラクターは『 YUKI 』、3歳よりクラシックバレエを学びその後ヒップホップミュージックにひかれ、ヒップホップの世界へ。 現在TV出演、バックダンス、他多数イベント出演、コレオグラファー、プロデューサとしてコンテスト入賞、『天満・天神ダンスフェスティバル』 レギュラー出演などまさに大活躍中のインストラクターです。
          • is_detail_address_opening1
          • is_charged0
          • registration_status1
          • whole_staff_titleご挨拶
          • whole_staff_introductionスタジオの管理人です! 3月12日より空手教室が始めます! ダンスとは違いますが、子供たちの心・技・体を養える最高の習い事です! よろしければご兄弟、友人などお誘いあわせの上、無料見学・体験に来てください! 毎週火曜日19:00~21:00、宜しくお願いします! 押忍っ!! まだまだダンスのみならず色んな教室を開きたい方! もしくはそういう人を紹介できる方! 情熱がある方! 是非ご連絡ください!! お待ちしております!(^_^) ※教室開校時はスタジオ料金など要相談になります。
          • whole_staff_image_hashfc8311a5a1ad7358
          • whole_staff_image_extension_type2
          • is_kuchikomi_notice_mail_receiving1
          • banner_image_hash(null)
          • banner_image_extension_type(null)
          • school_type1
          • has_kids_course0
          • has_beginner_course1
          • score0.00
          • kuchikomi_count0
          • timestamp_created0000-00-00 00:00:00
          • timestamp_modified2021-08-03 15:06:59
          • 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.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_3014970/map_and_coupon
        Query String
        Request Method GET
        Server Protocol HTTP/1.1
        Gateway Interface CGI/1.1
        Redirect Url /detail/L_3014970/map_and_coupon
        Remote Port 38658
        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=gru449de3k2lf0olfj78suqn314n4f63
        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 aTJlLIZ9cPIOh45bKmDxXwAAAjU
        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 aTJlLIZ9cPIOh45bKmDxXwAAAjU
        Redirect Mef Proxy Addr 183.90.231.12
        Fcgi Role RESPONDER
        Php Self /index.php
        Request Time Float 1764910380.7401
        Request Time 1764910380
        ====
      • 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/SchoolListPageLink/ToCategoryPage.php
            • 6APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.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/TransitionalLinkShower/SchoolList.php
            • 12APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
            • 13APP/class/Sgv/Front/InputForm/SchoolSearch.php
            • 14APP/class/Sgv/Front/InputItem/SchoolSearch.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
        ====
      ページの先頭へ戻る