現在の教室登録院数 2603 件

Stage Art Company 三宮支店の地図・アクセス・最寄駅・特典

メンバー登録   ログイン

ダンススクール

Stage Art Company 三宮支店

口コミを書く

Campaign 特典

「コロナに負けるな」キャンペーン

  • 有効期限
  • 2020-09-30
  • 利用条件
  • 新規お客様限定

「コロナに負けるな」キャンペーンを実施中

2020年9月30日まで

新規会員様 入会金 ￥7,000 off（税込）！

Access 地図・交通案内

Stage Art Company 三宮支店の地図・交通案内

住所

〒650-0001 兵庫県 神戸市中央区 加納町3-13-3 マツモトビル２F

最寄駅

  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    ====
  • Session
    +

    Session

    • _Token(array)
      • key975a04ee06b5d911e9ea9fa68a9be35ee29a1c23
      • allowedControllers(empty)
      • allowedActions(empty)
      • unlockedFields(empty)
      • csrfTokens(array)
        • 4eeb2c25418635f778e44d99f29e85ad2c6ec3cf1764929548
        • 9cd562071bfaff90578cf5f0d8834353493b34911764929549
        • d1c6ab81fad83eadd0a03c468a3b88e54e6daa2d1764929549
        • 192360159ea1003489ffd55e70a0af3566e0c23d1764929549
        • 1a21b79cdc6828dfa300015758e652227117f2f51764929549
        • 5088b40fd8b34652d1c97a106090959ed002a6ef1764929549
        • bde2ff46050a2f429344fff62f56502c02885d361764929549
        • a81995ac52c1f545f894ad6bdae4fb3a5c83833a1764929550
        • 5cf891721a54e86d3189fd664139745ac7fa6c491764929550
        • cb5102166187584208d7defee52af8d008f6b0751764929550
        • f0dcd6c0d446aba1229abfe54284038a252d29931764929551
        • 8f42221432a8e3285e48decea325d09225cb1e971764929551
        • 6f6bea32fc8f3e96592d9cfec74066dfeb78be171764929551
        • a489c45c5f41d4a5d2cee844da3e901d104b804b1764929551
        • 47b4357d8ac6a3888e5447099650d08ff377edfd1764929552
        • b77a8c225737e623e09de5b5f947571f00ebb3291764929552
        • 3e91beca1e9e55417fab3984e71d0d3560a014491764929552
        • 9b0241e9f95a6aac975549d1df3c2099d49a4dfc1764929552
        • 356489e16ad9219ae4727f5db519ce0afc8b8fb31764929553
        • 1a86cb2842b39159c06e3eef8f0872478fa09e391764929553
        • 13c8f9228f4e1d8ec1907dbb9b136b93d937475e1764929553
        • b695ba140ba44ad145efff8a29c620c75a1e84821764929553
        • 1c2fcda501afdff869f063ddd7e0dd55b6ac491c1764929554
        • 741bd40ca0983ec2865e8a81ac069e02b57b84b11764929554
        • feeded61008438de04b3028346b4b905bb80bf001764929554
        • c27ffeb35405fb1caa3542313e51a4ee7d2d6d591764929554
        • 4fab2fd242762df4debf7ce6877ad5129fe124761764929555
        • 2fb99fd627ed3da29a5a29b4f986603553dd6db81764929555
        • ced0e5ec8dad26188a1aa07a6b92135001c8f2a81764929555
        • 442d85e36ba3f22aa7ea9a6dcee91406163399071764929555
        • 18b78b9426d70527ad1832cf7130a96dc2bae1a01764929555
        • 9e4db9262c4db422a8728bd8ab9addde40c070da1764929556
        • 8ff4be0698034bbd9eb99a73d6bbcd15b7be86d11764929556
        • 86dacc5bf09f1d36c79b2540af5f95d208b177561764929556
        • bf85743d598306d1363958a704783dd9c431655e1764929556
        • 68b70e300b4c4e8d9ab380182e3079d1c9a0ef541764929557
        • 3d5e8515ff4e649cebe89ceaa60c70ca5d499b5e1764929557
        • 1c3ca28645fb3fdd5fd1de302ac11d776dbb12ac1764929557
        • 04036698bf5373346e70a6e40110a3eeba6101271764929557
        • 189d2926f3a8a0a5b740848c8576893c615283251764929558
        • 4bfb457472b2994bc515f79fcfdee28d08108ffb1764929558
        • 6d84796194ad68f8ab0c4196e5e57403e1ec38981764929558
        • a04458f47d2f41177b77de7d513048f5af9da3e61764929558
        • 14f9c20774f421c8cc1f51a036d4f915f31f0cd71764929559
        • 4cb69ed4d9fb04465170d574f1f207a5b5dd64e31764929559
        • 9803dac54ba36aa77b3026b892a7594266b869af1764929559
        • 1484ed646671d5876804cb5d6028f6c5aa030cdc1764929559
        • 25ce11c89767fa0b777ab3a9cfbaffb24f6203ba1764929559
        • 36560aafb2e4dc36f1f720c78a23d499675ae7f41764929560
        • 9438ab574d3b0c4b22c6cf85d0e4e9014e5158ef1764929560
        • 980b14e3b5a873a3b30775f88e884cd907f39e3e1764929560
        • 2107d9234d1caa8d1727e6ce1d265f1d742aea321764929561
        • aadb65305a0341bf3cc8cf445702ca63780792ee1764929561
        • b73aa97bef0d79c2799bc6b9215e94afa34192701764929561
        • 1107494cfadab791b379822fa9e9973f383fc6161764929562
        • 85ae71ba5649ceb52347fcf5fc91863846834df71764929562
        • 9f447fa94cd2dedadb9543b85485d3b7340ee02c1764929562
        • e3ca47394b64fb9dbbea49679c29b8667c76f72f1764929562
        • 4feb4f8cf310324b1aad89a8d6b67a2cb7db444f1764929563
        • 83afaf762ddfd28e9b7783a5d7b92c99392b0ebb1764929563
        • c83d801315707a2f0f956a51479da6dfb662b8d01764929563
        • 7d33e3f2487b1bad1d181637f97ac065802751991764929563
        • 4e8386e023dde6f8dc6849fe232a62a6b14458211764929563
        • c84c516bf42f83ce3ae0d4a32b7b6e6526cdca071764929564
        • f75cac3a418ffff93042d799e3d9fe9637cdb73e1764929564
        • 321901aae16c6a0cbb962fe16b55e55c599188e81764929564
        • 6658d4af0f471c48070ded5120d1da3bdcf6477e1764929564
        • 3cb91652ed817adb112f82b99de3d9cbde53d39b1764929565
        • 6f51043d7af73c76d3c123589b230285d98dda171764929565
        • c9091b50dc80aedfdf40edb46e8a53cded2374941764929565
        • 02474e6f16174b009db8f1cd70be5fcbbaf440de1764929566
        • c686e3a14cd8554fbe82f7f5867d821712a8fdad1764929566
        • b1f28cf50cca86d718744ae89b87146a4ae222771764929566
        • f039d2474df0852a48614cc72f2768e56ead906a1764929566
        • 682c75e1b6839983000f1f7a126fe06dd9e9c1ad1764929567
        • 31828ae441cc688b841aa730dc540c7a13d3e1571764929567
        • f76dd3591c99bec730c9bc85f8a02c4fe7b627af1764929567
        • fec3eeb8bd368caa89cdf844d5f1ca0d642fa4161764929568
        • 125fe3178db11b337357841fb842d254b1f71d3c1764929568
        • db1e0d12eaede3f38c8a3f12431e6003a6a518501764929568
        • 9874a781f1de19a9ad967120bfaed6bf00d266521764929569
        • c42e6c7ead72293ccdeb10cd05450b3cdf7f8df51764929569
        • b3ff710318d56b6204a3efd981998e2f6b7551fb1764929569
        • 9e051183cfcef7aff5e0bf5f722089b8dafb321c1764929569
        • ba2d5990f76a9a61c78b05d2599052a2f5cc41251764929570
        • f47572172bd731ee6b08cebcf48b9caa0b798b781764929570
        • 55338db5f6c70bbeee2691a1d1db48bf3aacec731764929570
        • 17136ce087c9f0488c4aa1815ae077b47d53e6191764929570
        • d8976c16abbb32219f3343cd0df4d4b93360f9041764929571
        • edd10138c9770c075a10e3a93e215004a8017f281764929571
        • 9b09be58900631b1f52d36fffaebe55b26df5dee1764929571
        • 0ca33b832da48725926cef27278643835df868281764929571
        • 1201090923d0ec6c984dbadead416a56991b3e1c1764929572
        • c8cadeebb3423047cffe24f8094a66713e4ce9741764929572
        • 431181d87efc9d2fdd739a4caccf3eefcc5a05db1764929572
        • 7c7cf7a1a3271d82c60bb561bc871f2c6180daf51764929572
        • 1ae52ab9d5f9f5fead70a99522de7f5a8b91dc891764929573
        • 517369fe404e0554cf078bc27270366dac7a4c4e1764929573
        • 1b4399e006b51ced6144188697f8a10e64fede191764929573
        • 975a04ee06b5d911e9ea9fa68a9be35ee29a1c231764929573
    ====
  • Request
    +

    Request

    Cake Params

    • plugin(null)
    • controllerschool
    • actionmap_and_coupon
    • named(empty)
    • pass(empty)
    • schoolId3016255
    • _Token(array)
      • key975a04ee06b5d911e9ea9fa68a9be35ee29a1c23
      • 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: 59 queries / 0.058157 sec
    No. time query
    1 0.002217
    connect
    2 0.001017
    DESCRIBE `school`
    3 0.000577
    SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3016255') 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.000617
    DESCRIBE `school_score`
    5 0.000427
    SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3016255') 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.000547
    DESCRIBE `access_log_school`
    7 0.001947
    SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3016255') AND (timestamp_created >= '2025-12-04 18:42:53') 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.000567
    DESCRIBE `school_station`
    9 0.000497
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016255') 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 8
    10 0.000527
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '2863')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s ref station_id station_id 4 const 21
    11 0.000747
    SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3013829', '3014632', '3013830', '3014856', '3014035', '3013836', '3013835', '3014103', '3013927', '3013928', '3013831', '3014845', '3014769', '3015616', '3015813', '3015783', '3015925', '3015386', '3016255', '3014308', '3016280')) 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 21 Using where
    12 0.000697
    SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '1534') 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 56 Using where
    13 0.000537
    DESCRIBE `city`
    14 0.000367
    SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '1534') 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.000557
    SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '28')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE c ref prefecture_id prefecture_id 5 const 48
    16 0.002107
    SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1507', '1508', '1509', '1510', '1511', '1512', '1513', '1514', '1515', '1516', '1517', '1518', '1519', '1521', '1522', '1525', '1526', '1531', '1532', '1533', '1534', '1535', '1536', '1537', '1538', '1539', '1540', '1541', '1542', '1543', '1545', '1546', '1547', '1548', '1549', '1550', '1551', '1552', '1553', '1554', '1555', '1556', '1557', '1558', '1560', '1561', '1562', '2307')) 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 341 Using index condition; Using where
    17 0.000567
    DESCRIBE `prefecture`
    18 0.008017
    SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '28') 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.000477
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016255') 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 8 Using index condition; Using filesort
    20 0.000657
    DESCRIBE `station`
    21 0.000397
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '2863') 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.000597
    DESCRIBE `station_unit`
    23 0.000437
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016255')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s ref school_id school_id 4 const 8
    24 0.000577
    DESCRIBE `station_station_unit`
    25 0.000417
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2863')
    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.000407
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2864')
    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.000387
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2865')
    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.000417
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '2866')
    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 = '8308')
    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.000397
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8385')
    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.000397
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8394')
    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.000407
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8395')
    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`.* 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
    34 0.000637
    DESCRIBE `major_city`
    35 0.000517
    DESCRIBE `city_major_city`
    36 0.000397
    SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '1534')
    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
    37 0.000447
    SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('8'))
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE m_c const PRIMARY PRIMARY 4 const 1
    38 0.000717
    DESCRIBE `summary_count_school`
    39 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
    40 0.000887
    DESCRIBE `campaign_school`
    41 0.000597
    SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3016255') 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
    42 0.000457
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016255') 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 8 Using index condition; Using filesort
    43 0.000747
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '2863') 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.000757
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '2864') 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.000417
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '2865') 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.006237
    DESCRIBE `category_school`
    47 0.000457
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016255') 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 7 Using where
    48 0.006507
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016255') 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 7 Using where
    49 0.003547
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016255') 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 7 Using where
    50 0.000477
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016255') 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 7 Using where
    51 0.000627
    DESCRIBE `dancer`
    52 0.000497
    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
    53 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
    54 0.000627
    DESCRIBE `dancer_column`
    55 0.000457
    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
    56 0.000987
    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
    57 0.000457
    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
    58 0.000447
    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
    59 0.000447
    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.16 MB

    Message Memory use
    Component initialization 2.16 MB
    Controller action start 3.96 MB
    Controller render start 4.10 MB
    View render complete 5.16 MB

    Timers

    Total Request Time: 1966 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 1779.66
    Event: Controller.initialize 53.58
    Event: Controller.startup 0.71
    Controller action 0.70
    Event: Controller.beforeRender 32.82
    » Processing toolbar data 24.76
    Rendering View 64.82
    » Event: View.beforeRender 13.59
    » Rendering APP/View/School/map_and_coupon.ctp 11.13
    » » 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.20
    » Event: View.afterRender 0.04
    » Event: View.beforeLayout 0.03
    » Rendering APP/View/Layouts/default.ctp 38.95
    » » Rendering APP/View/Elements/header.ctp 0.44
    » » Rendering APP/View/Elements/school/detailHeader.ctp 25.95
    » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.13
    » » » Rendering APP/View/Elements/breadcrumb.ctp 0.33
    » » Rendering APP/View/Elements/menu.ctp 9.42
    » » » Rendering APP/View/Elements/school/right-menu.ctp 9.23
    » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.06
    » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.05
    » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 8.35
    » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.07
    » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.06
    » » Rendering APP/View/Elements/rtt.ctp 0.10
    » » Rendering APP/View/Elements/footer.ctp 1.20
    » » 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
          • prefectureId28
      • 2(array)
        • name神戸・三宮
        • link(array)
          • controllerschool_list
          • actionindex
          • prefectureId28
          • majorCityId8
      • 3(array)
        • name神戸市中央区
        • link(array)
          • controllerschool_list
          • actionindex
          • prefectureId28
          • cityId1534
      • 4(array)
        • name三ノ宮駅
        • link(array)
          • controllerschool_list
          • actionindex
          • stationId2863
      • 5(array)
        • nameStage Art Company 三宮支店
        • link
    • ChargedNeighborSchoolSet(empty)
    • SchoolScoreSet(object)
      • School(object)
        • id3016255
        • nameStage Art Company
        • branch_name三宮支店
        • city_id1534
        • schoolgroup_id(null)
        • mail_addressinfo@stageart.org
        • lat34.69781983463597
        • lon135.19286289811134
        • telephone_number0788553328
        • homepage_urlhttps://stageart.org
        • mobile_homepage_urlhttps://stageart.org
        • blog_urlhttps://stageart.org/news/
        • open_hour12:00~20:00
        • holiday
        • post_code650-0001
        • town_address加納町3-13-3
        • buildingマツモトビル２F
        • image_hashaa3855b1eb57c68a
        • image_extension_type2
        • message_image_hash52fd16bf34a6f3be
        • message_image_extension_type3
        • is_registered_by_not_owner0
        • is_opening1
        • message_title舞台をメインにしたダンススクール
        • message_bodyStage Art Companyはエンターテイナーを育成し、ストリートダンス、バレエ、演技、歌唱をコンテンツとして共に活動していく舞台芸術スクールです。 近い年齢を基準としたクラス編成で、自由選択制のレッスンを行っています。 レッスンは、ダンス、バレエ、演技・芝居、歌唱・ボイトレ、テーマパーク、ミュージカルなど、幅広く対応しています。 スキルだけではなく、社会性を持つことも目的としています。専門技術を取得する傍ら、より協調性を求められる舞台への出演経験を積むことで、エンターテイナーとしての総合的な育成を目指しています。 教育方針としては、あいさつを始め、チームワークで思いやりを育くむこと、社会のマナーを遵守する人間性を育てることを重視しています。 そして、ダンス、バレエ、演技、歌唱のプロ経歴を持った大手テーマパーク、大手劇団出身者が講師として在籍し、皆さんの活動をサポートします。 さらにStage Art Companyは１年を通じて、４月の発表会、８月の舞台、１２月のパーティーイベントを中心に活動し、人前で表現する場を数多く提供しています。
        • is_detail_address_opening1
        • is_charged0
        • registration_status1
        • whole_staff_title実績ある講師陣が皆様の活動をサポート致します！
        • whole_staff_introductionテーマパークや劇団に所属している、 或いは所属していた実績のある講師が勢ぞろい♪ ダンス、バレエ、演技、歌唱などの、 それぞれの分野で活躍するプロによる 丁寧な指導が好評です◎ 未経験の方でも、目的に合わせて しっかり指導いたしますので、 成長していく自分を実感できるはず♪ もっと深く学びたい！という方には 専門的なスクール環境をお作りしますので 安心してお越しください。
        • whole_staff_image_hash5db3fb09084facd9
        • whole_staff_image_extension_type2
        • is_kuchikomi_notice_mail_receiving1
        • banner_image_hash(null)
        • banner_image_extension_type(null)
        • school_type1
        • has_kids_course1
        • has_beginner_course1
        • score0.00
        • kuchikomi_count0
        • timestamp_created2020-08-15 02:01:52
        • timestamp_modified2021-08-03 15:08:24
        • 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_3016255/map_and_coupon
      Query String
      Request Method GET
      Server Protocol HTTP/1.1
      Gateway Interface CGI/1.1
      Redirect Url /detail/L_3016255/map_and_coupon
      Remote Port 42454
      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=lvh9b6fju9ce1md4jqrm828ame4j5dvo
      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 aTKpG9fyCEp5VdikckLRtgAAAh8
      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 aTKpG9fyCEp5VdikckLRtgAAAh8
      Redirect Mef Proxy Addr 183.90.231.12
      Fcgi Role RESPONDER
      Php Self /index.php
      Request Time Float 1764927771.8804
      Request Time 1764927771
      ====
    • 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

    ページの先頭へ戻る