現在の教室登録院数 2603 件

ソウルアンドモーション 大阪梅田ダンススタジオの地図・アクセス・最寄駅・特典

メンバー登録   ログイン

ダンススクール

ソウルアンドモーション 大阪梅田ダンススタジオ

  • 満足度
  • 5.00
  • 講師の質 ： 5.00
  • 設備・機材 ： 5.00
  • レッスン内容 ： 5.00
  • 立地・雰囲気 ： 5.00
  • サポート対応 ： 5.00
  • 料金 ： 5.00

口コミを書く

Campaign 特典

大阪スタジオ５周年☆期間中にレッスン受講で入会金無料！

2011年9月を持ちましてソウルアンドモーション大阪スタジオは5周年を迎える事となりました。これもひとえに皆々様のご支援ご厚情の賜物と厚く御礼申し上げます。
そこでスタジオオープン始まって以来、初となる“入会金無料キャンペーン”を開催する事となりました。期間は9月末まで開催いたします。期間中にレッスンを受講していただくと無料で会員証を発行いたします。この会員証は大阪スタジオはもちろん、全国の提携スタジオ（東京・尼崎・広島）どこでも使用できます。この機会に是非、お誘い合わせください。

期間：2011年9月末まで
割引対象：レッスンを受講された方。
※ソウルアンドモーション大阪スタジオのみの開催になります。

Access 地図・交通案内

ソウルアンドモーション 大阪梅田ダンススタジオの地図・交通案内

住所

〒5300026 大阪府 大阪市北区 神山町1-15 トラストビル1階

最寄駅

  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    ====
  • Session
    +

    Session

    • _Token(array)
      • key92321b9819370ef58c10c525e98a44d2173c8878
      • allowedControllers(empty)
      • allowedActions(empty)
      • unlockedFields(empty)
      • csrfTokens(array)
        • ee28402872613aa4be365cc7a1a067014340ee041764942679
        • 5c51ec8a6f55381a25e7cb95d27f6255282cc9871764942679
        • cf379245cb982f21be4830ff29882930059558da1764942680
        • ace3faeddab4b05dae1f19b4097a826a4c97fed01764942680
        • b831882802459d9b90b05cd96df2d7dcc5dede691764942680
        • c6a4d6a024cbf5770ce28950366179dabe2e1aab1764942680
        • ff5a3067aa9d491ba12f5526e5f28ed5b9f346411764942681
        • 2750826f0130e2b676d0be773773604a7c6b03e91764942681
        • be442901de7dfacacc3d510b9c3ea907e9782dd81764942681
        • f17b44641c621d2dbfb2fa398e3c9d9489d81a7f1764942681
        • a2600fabc06bd713c8162689f1a4ebd8fa65608f1764942682
        • 9693525833256da9082687d7e1e0fb87578b96c31764942682
        • cf410dd6f99225cca600a9e1a2783bfadfafd2981764942682
        • 2a5517190006e5ba5b6a344f3e95d458f63e76d01764942683
        • bc577c0103d023251ad722d17edc41a9843f21301764942683
        • 9e5a5402da3d90a8bd05519e3f00f2d3c091a90c1764942683
        • afdd0442d9c8c24454646d8aad89ac4c982f0ccb1764942683
        • 7366f273cf315cd1f218b2c7a425a0c10db2da1d1764942684
        • bbc0ac46d96b39fb97363da4d9566df70065951b1764942684
        • 8cb11cca0987e5a27ca495f62ac1f26c846dd11c1764942684
        • 4f99303faa4b6d64a8c6a4dbaf458f21bc56be011764942684
        • 7adf5d4ddd8929fba3c9fc1f461ba05926a4c5051764942684
        • 0c53f2a48201552e67653e14fb123498622413161764942684
        • 8d9a98a9b6f34406b773f48e19fda26d46ce60dd1764942685
        • 51fe935196019791d377ec1a95127be0c417b1e41764942685
        • a95becc9e050d7fb166616c2a46e9ba7356d2bb81764942685
        • f28d833d109912e883f4ca0f0b8cead6db737f2d1764942685
        • 38bb35e9ff87dd860aaa3f4618d9e5cd3fc7f8921764942686
        • 0f8241e36ceafe0f792422509f66cd4035f8025c1764942686
        • ea5063ae6b55d201c428f6838cdf8b1adffac1581764942686
        • 0705d27f9d76ad64f414770eca1a74bcb78517031764942686
        • dc294640bfcfc52f5e55e015f8f264bcfc3f9ecc1764942687
        • 07747a2d5d578704e1df8f71518e0309ab0116fc1764942687
        • d4725c0fb3af21c6ade869d50be8dc6e51b4a71d1764942687
        • c8bc5fb5d5bc4ebfbf4e0255ea72018ebd9ef2ca1764942687
        • 59199b6cb1d2a57f23272421f7617991b89aa4871764942688
        • dec6bfcd97283acd0ca63289b0e3b0acbc44c3c81764942688
        • 89479afe758bd34aaa7eff0629ad2cd64a39af391764942688
        • 0b32554edcdfdd3700825826c3f876ec1fb2af491764942688
        • 50416250ce4245d79115e8937691c82a8be946581764942689
        • 05b452f13ec9aee8d787cc968fcb25a875c1ca0f1764942689
        • ea069086f78f04ad309abeb745d19665f0da85461764942689
        • db523c5de077c46ce8945e4308c23c165607870c1764942689
        • 61567ca409872c13393bde590ff452f7715711571764942690
        • 02543aa1c35e0e4a6d7474039b76c709652952171764942690
        • 2d409c9e86c9d644a67c0cef9a470f054f36d7901764942690
        • a977bce7aa8d7b74e10aff61be5e9e2369eb45c41764942690
        • d218976559507e2d8a81ec64ed2d154a99f617881764942691
        • a27ffdbdd8195ae588b23d4f62702e62e96cb0471764942691
        • 6a427b4e74b1044a30b7d0a9a421261ef723b7d91764942691
        • 3e01952c46a89c5ac5b02385b0eb7140380b08031764942691
        • 08007e721333ae5c62bd5058b20e1f988cc1e3b11764942692
        • 41f22405439622957f1815377e790c433ae161bd1764942692
        • 55a2c59fc6fa6a350222948664ed93cf823d4d431764942692
        • a919620daa1af1efb46df668bf85eb4913e27ac81764942692
        • 52826ed21c134557178c3d70aa67b323e40df2241764942692
        • b07d1009ee70384a51faf66be6ec4f70dc2bf3121764942693
        • de370c3d9b21f11f8216b870acc11d7f6d9986431764942693
        • fbd2f0c3514809a99da3fe740a8730525cc75de11764942693
        • 3cadfec42c6f54dd85adf31d9242f10a195c20dd1764942694
        • da6aca6713f3ffa7f21adb7d392521695030644d1764942694
        • 0dcfbcd1cbd3be23ab16cb3110437095e5864e151764942694
        • 5c1b67068d59d98193aa4400328f7e56a73e857c1764942694
        • 0798c7572e46fe4d9c1051eddd4f2312a5532c361764942694
        • e18ebfc64af37056fc0ce86246fae56c9f200d041764942695
        • 23959f4a7b1cf9a716c45057463992abbdd50d541764942695
        • 254348bcc60b035758739c960ca9a9b40d4e58a51764942695
        • 190dfaf85e2d449c1cc507d33ca3e39b0044e7371764942695
        • 4246027e7dfac5a971de65846179d4b6f9456d721764942696
        • f1949651e7e79889edcc1b7f6a75f21889bc56fd1764942696
        • 66c3c321422116355b9faca559e4267f6f27df4c1764942696
        • 8bbcddf2412ae0c7afbb96e817da5db84fd3cf471764942696
        • 6ef8565ddfe355c26b9b5e4bd9e576563feba8641764942697
        • 55e1d30d597a61e0c0ec06ff3e521ac86f9208cf1764942697
        • 68e9daf33373f910acd55342ce4da8391d1801691764942697
        • 5c0f2699e4b73b88a1252f7a69c4fcf7b930c8201764942697
        • 84f3f143d63e0332452194e152ed37b0a6bbefc71764942698
        • 72cde762fe23bb982040ec108f69471badbd485c1764942698
        • f2f4ccdfb50914e03c66bfcd4cc527796d0290491764942698
        • b81d5d2b1a31a3aa5138b2d08b1cf12d68bd990c1764942698
        • 5cc2446153ce5fc92392d9fad9382480143a26041764942699
        • f63423521122915eee8e54241768f3b128c18f091764942699
        • dd5972a3e8201ab321b38980b8fe2b99851661161764942699
        • 4883f3de68dd72e42c7c367fb02e1103e4febe0f1764942699
        • 723f5dabe6b356b23423a3e3e36cafd85b1596491764942699
        • 4928ee01f64608f82e83b46b1e878a34821175e21764942700
        • 353e0aee5db83f619adabbf1727a2154fc44ad111764942700
        • b8ce91d99e5a86e557c0dee80cf04d6d48800d561764942700
        • 1e4973a9cd7fbe24e16d7082165a0803e7f59b731764942700
        • 2b75eed5b63f35c7907fb1f9779bf361a8a86ba31764942701
        • fee8310f5f04854216d6b183cfe2db5de79ab7141764942701
        • c1a457990b9bc4e14a0e09c83a38e9225ee668ad1764942701
        • e71e41188111b6e7e36b93c49e48dedd8df494ef1764942702
        • c91578c493d1c2239ee1d2ba08928d85d65378851764942702
        • decf0f5e77259ccdf632e314cfffcf0a080427fe1764942702
        • f9b8099dba9274596a0a32472a3b79bf47d3787a1764942702
        • 456133db7cf59b120765f450d22e46f0bf83e9fe1764942702
        • e99da0d815c6bf81902bee4eb7bb34b4262b401b1764942703
        • daffb690832fa2f3ffa9c63fc6156484927981221764942703
        • 92321b9819370ef58c10c525e98a44d2173c88781764942703
    ====
  • Request
    +

    Request

    Cake Params

    • plugin(null)
    • controllerschool
    • actionmap_and_coupon
    • named(empty)
    • pass(empty)
    • schoolId3014570
    • _Token(array)
      • key92321b9819370ef58c10c525e98a44d2173c8878
      • 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.058767 sec
    No. time query
    1 0.001737
    connect
    2 0.000797
    DESCRIBE `school`
    3 0.000567
    SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3014570') 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.000547
    DESCRIBE `school_score`
    5 0.021737
    SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3014570') 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 32190 Using where
    6 0.000577
    DESCRIBE `access_log_school`
    7 0.007277
    SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3014570') AND (timestamp_created >= '2025-12-04 22:21:43') 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 12 Using intersect(ix_ip_address_access_log_school,school_id); Using where
    8 0.000657
    DESCRIBE `school_station`
    9 0.000407
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014570') 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 13
    10 0.000477
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '2845')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s ref station_id station_id 4 const 12
    11 0.000547
    SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014416', '3014416', '3013754', '3013265', '3014595', '3013755', '3014570', '3015684', '3015878', '3015880', '3016083', '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 11 Using where
    12 0.000777
    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.000597
    DESCRIBE `city`
    14 0.000357
    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.000547
    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.003477
    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.000537
    DESCRIBE `prefecture`
    18 0.000347
    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.000417
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014570') 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 13 Using index condition; Using filesort
    20 0.000477
    DESCRIBE `station`
    21 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
    22 0.000477
    DESCRIBE `station_unit`
    23 0.000427
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014570')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s ref school_id school_id 4 const 13
    24 0.000567
    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 = '2845')
    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.000337
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2847')
    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.000327
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2848')
    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.000357
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2849')
    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.000347
    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.000317
    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
    31 0.000307
    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
    32 0.000317
    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
    33 0.000317
    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_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6217')
    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
    35 0.000377
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6299')
    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
    36 0.000337
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8144')
    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
    37 0.000357
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8160')
    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
    38 0.000347
    SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.id IN ('12'))
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s const PRIMARY PRIMARY 4 const 1
    39 0.000627
    DESCRIBE `summary_count_school`
    40 0.000457
    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.000597
    DESCRIBE `campaign_school`
    42 0.000497
    SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3014570') 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.000417
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014570') 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 13 Using index condition; Using filesort
    44 0.000317
    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
    45 0.000317
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '8160') 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.000287
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '3192') 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.000597
    DESCRIBE `category_school`
    48 0.000407
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014570') 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 6 Using where
    49 0.000457
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014570') 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 6 Using where
    50 0.000427
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014570') 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 6 Using where
    51 0.000387
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014570') 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 6 Using where
    52 0.000627
    DESCRIBE `dancer`
    53 0.000407
    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.000387
    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.000517
    DESCRIBE `dancer_column`
    56 0.000447
    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.000407
    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.000387
    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.000337
    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 5.52 MB

    Message Memory use
    Component initialization 2.16 MB
    Controller action start 3.89 MB
    Controller render start 3.98 MB
    View render complete 5.05 MB

    Timers

    Total Request Time: 647 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 501.39
    Event: Controller.initialize 66.72
    Event: Controller.startup 0.49
    Controller action 0.16
    Event: Controller.beforeRender 19.39
    » Processing toolbar data 12.04
    Rendering View 30.69
    » Event: View.beforeRender 0.68
    » Rendering APP/View/School/map_and_coupon.ctp 7.61
    » » Rendering APP/View/Elements/adsense/336_288.ctp 0.10
    » » Rendering APP/View/Elements/adsense/336_288.ctp #2 0.06
    » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.17
    » Event: View.afterRender 0.03
    » Event: View.beforeLayout 0.03
    » Rendering APP/View/Layouts/default.ctp 21.39
    » » Rendering APP/View/Elements/header.ctp 0.44
    » » Rendering APP/View/Elements/school/detailHeader.ctp 8.81
    » » » 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.15
    » » » Rendering APP/View/Elements/school/right-menu.ctp 8.94
    » » » » 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 7.87
    » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.09
    » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.08
    » » Rendering APP/View/Elements/rtt.ctp 0.15
    » » Rendering APP/View/Elements/footer.ctp 1.09
    » » Rendering APP/View/Elements/common/scoreEx.ctp 0.09
    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
          • prefectureId27
          • stationUnitId12
      • 4(array)
        • name扇町駅
        • link(array)
          • controllerschool_list
          • actionindex
          • stationId3193
      • 5(array)
        • nameソウルアンドモーション 大阪梅田ダンススタジオ
        • link
    • ChargedNeighborSchoolSet(empty)
    • SchoolScoreSet(object)
      • 0(object)
        • id3805613
        • school_id3014570
        • kuchikomi_questionnaire_item_id1
        • score5.00
        • is_latest1
        • timestamp_created2021-08-03 15:06:31
        • timestamp_modified2021-08-03 15:06:31
      • 1(object)
        • id3805614
        • school_id3014570
        • kuchikomi_questionnaire_item_id2
        • score5.00
        • is_latest1
        • timestamp_created2021-08-03 15:06:31
        • timestamp_modified2021-08-03 15:06:31
      • 2(object)
        • id3805615
        • school_id3014570
        • kuchikomi_questionnaire_item_id3
        • score5.00
        • is_latest1
        • timestamp_created2021-08-03 15:06:31
        • timestamp_modified2021-08-03 15:06:31
      • 3(object)
        • id3805616
        • school_id3014570
        • kuchikomi_questionnaire_item_id4
        • score5.00
        • is_latest1
        • timestamp_created2021-08-03 15:06:31
        • timestamp_modified2021-08-03 15:06:31
      • 4(object)
        • id3805617
        • school_id3014570
        • kuchikomi_questionnaire_item_id5
        • score5.00
        • is_latest1
        • timestamp_created2021-08-03 15:06:31
        • timestamp_modified2021-08-03 15:06:31
      • 5(object)
        • id3805618
        • school_id3014570
        • kuchikomi_questionnaire_item_id6
        • score5.00
        • is_latest1
        • timestamp_created2021-08-03 15:06:31
        • timestamp_modified2021-08-03 15:06:31
    • School(object)
      • id3014570
      • nameソウルアンドモーション
      • branch_name大阪梅田ダンススタジオ
      • city_id1450
      • schoolgroup_id(null)
      • mail_addressinfo@soulandmotionosaka.com
      • lat34.7029008
      • lon135.5063339
      • telephone_number06-6365-6288
      • homepage_urlhttp://www.soulandmotionosaka.com/
      • mobile_homepage_urlhttp://www.soulandmotionosaka.com
      • blog_urlhttp://ameblo.jp/muscle3/
      • open_hour平日15:00～23:00　土13:30～23:00
      • holidayなし
      • post_code5300026
      • town_address神山町1-15
      • buildingトラストビル1階
      • image_hash9207f50551a762a5
      • image_extension_type2
      • message_image_hash
      • message_image_extension_type0
      • is_registered_by_not_owner0
      • is_opening1
      • message_titleTRFのSAM主宰ダンススクールの大阪スタジオ。初心者大歓迎
      • message_body大阪・梅田にSAM主宰のダンススタジオ『ソウルアンドモーション』 3つのダンススタジオにシャワールーム。本格レコーディングも可能なボーカルルームに女性専用ドレッサールームからキッズルームまで。 レンタルスタジオも大阪最安値。最高設備でダンスの練習やリハーサルにご利用ください。 タピオカ＆クレープのカフェも併設。 ダンスをはじめたい方からプロを目指す方まで、満足のクラス内容！!大手芸能プロダクション“スターダストプロモーション”が審査協力のエンターテインメントコースまで。 全国のソウルアンドモーションによる様々なイベントや発表会など、 より充実したダンスライフを皆さまに提供し続けていきます。 ダンスの楽しさをより多くの人に。 ダンススタジオ http://soulandmotionosaka.com/ Facebook https://www.facebook.com/soulandmotion.osaka エンターテイメントコース 芸能プロダクション「スターダストプロモーション」と提携 http://star.soulandmotionosaka.com/ 日本最大のキッズタッグダンスバトルイベント“SPROUT” http://www.sprout-ent.com/
      • is_detail_address_opening1
      • is_charged0
      • registration_status1
      • whole_staff_title(null)
      • whole_staff_introduction(null)
      • whole_staff_image_hash(null)
      • whole_staff_image_extension_type(null)
      • is_kuchikomi_notice_mail_receiving1
      • banner_image_hash(null)
      • banner_image_extension_type(null)
      • school_type1
      • has_kids_course1
      • has_beginner_course1
      • score5.00
      • kuchikomi_count2
      • timestamp_created0000-00-00 00:00:00
      • timestamp_modified2021-08-03 15:06:31
      • memo
    • 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://www.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_3014570/map_and_coupon
    Query String
    Request Method GET
    Server Protocol HTTP/1.1
    Gateway Interface CGI/1.1
    Redirect Url /detail/L_3014570/map_and_coupon
    Remote Port 53142
    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 www.dance-schoolgv.net
    Server Software Apache
    Server Signature
    Http Cookie PHPSESSID=6ost44kn0qj8vgatrsah1386f5qm4bff
    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 www.dance-schoolgv.net
    Http X Forwarded Proto https
    Http X Forwarded For 216.73.216.35
    Http Host www.dance-schoolgv.net
    Ngx Cache Staticmode 1
    Ngx Cache Normalfile 1
    Failurecachetime 0
    Https on
    Unique Id aTLcZsYrfCQBzEgkAc8otAAAAO8
    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 aTLcZsYrfCQBzEgkAc8otAAAAO8
    Redirect Mef Proxy Addr 183.90.231.12
    Fcgi Role RESPONDER
    Php Self /index.php
    Request Time Float 1764940902.734
    Request Time 1764940902
    ====
  • 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
      • 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
      • 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
    • 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

ページの先頭へ戻る