現在の教室登録院数 2603 件

大阪タンゴの地図・アクセス・最寄駅・特典

メンバー登録   ログイン

ダンススクール

大阪タンゴ

  • 地域
  • 大阪府
    • |
  • 大阪市北区
    • 満足度
    • 4.00
    • 講師の質 ： 5.00
    • 設備・機材 ： 4.00
    • レッスン内容 ： 4.00
    • 立地・雰囲気 ： 4.00
    • サポート対応 ： 4.00
    • 料金 ： 4.00

    口コミを書く

    Campaign 特典

    キャンペーンは実施しておりません

    Access 地図・交通案内

    大阪タンゴの地図・交通案内

    住所

    〒5300047 大阪府 大阪市北区 西天満4-12-22 第3青山ビルB02号

    最寄駅

    • CakePHP
    • History
      +

      Request History

      4 previous requests available
      ====
    • Session
      +

      Session

      • _Token(array)
        • key5be783eec4ec4c59b3ae228a01944b34fb8a8930
        • allowedControllers(empty)
        • allowedActions(empty)
        • unlockedFields(empty)
        • csrfTokens(array)
          • b4088bab5d2c44b853b985f84b96278b32a4bcd81764922141
          • 36e796a2b00c9d52bccf92814e243e6b278a6d451764922141
          • 87846ba2e648cdb883b402931d745aeb0fb5ebde1764922141
          • fc8fde8c163405264fd541d1e05c8183cfc7e2801764922142
          • d4cf84917cd3668a409d55f0a79e4fcc2eb9f0581764922142
          • 20b8fd2926ef6644e036d1da45be87c887bc0a611764922142
          • f9847318c6f88667832820d5eddd0865c08999131764922143
          • 5a5b9ed2917de8becf80d8c9529c4247485291c21764922143
          • 1fdf322d394afcf5870a3ff8d78efb52031344181764922143
          • 82ccc517c6b32eecc6d844ffb5ff45565de14ac51764922143
          • 13abf2896d5a057709a42988699050d8cc0b97cd1764922144
          • da608d19aeec0967849c5dc94dfe7bc5e23f7b551764922144
          • 9ca5ef9e0d02de4635dd6fd49f83bf73581d7cbe1764922144
          • a19079082e533ff80e14b67ac2038ab65392665b1764922145
          • 3e008e21536dc5dc793c285261cfd2a976d854621764922145
          • 70874c9950d35d3947e49166edd8bee3778e2b981764922145
          • a6b88ae45d1d2dd85149ce73445f65d7c355bc731764922145
          • 43698c8fe59a4c0382ac7d268a0787e22ff0c3f81764922146
          • b15be27b34a51274d3003e9828228cdb6cee32b01764922146
          • b6b27725ed4f689768e94e84b2a0c9a3a166dd861764922146
          • e919d3cfef719f13da124edade2bfad0a85e94931764922146
          • bb6aaddc57760dcf6745e54113fb35e9491445d51764922147
          • 5c5e74b97a65935c12540e0f1b9c6732f3a9db4e1764922147
          • 98bca18b1b5976b6c36e9502ed3698260501a4d21764922147
          • 0aab447309d6053761e00c3db86c41244ce397a71764922147
          • 437ccba088120c97fa9f36027b3b4c5fd17b71e81764922148
          • b0f67adaff86c48d95212cebf876fd632d9f867b1764922148
          • 9b5e5527e127807bc6a54a6ca2a1e6d1b13aa9ee1764922148
          • f93905182ebd3390cddeb2187f64b3baa80cba8b1764922148
          • 2d737b17179f15161a2e54e404a79c277c56a8881764922148
          • f81f2aab763b1ec7a6c0228541b7d6690dbdd07e1764922149
          • 4873442af950db390cd66db6b4a0f5da407352521764922149
          • 2181cd06583e616550080feb88d5b6657527c51e1764922149
          • e091cd92f8a4c7cf9b8cbf985019e77388e1661a1764922150
          • 942f05baa55344c04c3d0b7db67ef78eaa0f708e1764922150
          • 4c373afd690eb43588e6b2d3defd3ab7d04407e61764922150
          • c10bc123da4cb83caceabcfeb5abc32f936c0b851764922150
          • 2464347a64c2e16da81f20e16aed077832d7f8151764922151
          • 1edd1e16081dc37bddadabf2512e11ed37b0351a1764922151
          • 817fb2279e1a62c84c5ad0350ead2fdc9e683efb1764922151
          • 42a80228fb37d34171cf4240f0da1ea1555296621764922151
          • 2541121ae196b1aae7652d40997e426710600d901764922152
          • a52fd6a9084792d9938587ff5d102f6c8f03790e1764922152
          • fe94d43b0d44d526f3a0b3cc922dd865df87fb5f1764922152
          • b4f49d1ffe862898dce771247a59660b849dfc5d1764922152
          • a49aaeb416c62069979e723aa19067304561f5761764922153
          • b1e75ffad9030c8917eb6e7f2cda56ad33eef5ca1764922153
          • 46da9fc8b79dc99cb4fd166439f1eb27aa7c1a8a1764922153
          • 70067c783cac7c0a481cbf211209d3ba4d9fc19a1764922153
          • 9cd854a57d5da24aab83dcfdb9f7206b4d51565b1764922153
          • f568639c7a2c5e4a9153a9b3f45f9c264014c6051764922154
          • db4111fa3ff8b1c9b37f4c4b5867dafa6ae48bf91764922154
          • 3591a26e8d258fbf07b332561f5a584285b36ab91764922154
          • 3a240efaed87bd6e57237735abf6f06c63a4d76d1764922154
          • fddf27321519faf7c211395ed552621e34327e0f1764922155
          • 3a88080d67df7d0e0c7e2ebb2a720b4e410d29231764922155
          • 40690a8fe45a4770711f6693407ae5e99a2dc2061764922155
          • 11be8217731fc3da390d9e13e409c2f52f7bf2041764922155
          • a7e37e260f09792851f3cbfb64b9b03cfd616d221764922156
          • 9b79d2e29b7d8d9ee28e9259c580e397edaf200e1764922156
          • 4783e5b3b138cdf542597b2480bdbdd6a257e8e21764922156
          • c6f839bf829689b47491e0815d4013bf1cc135b91764922157
          • c886859584165b2d40f8d06f1052444162301e571764922157
          • ff20b6a9bbf22db2741af94f06bf249a0905e0dc1764922157
          • fef70c596be0f1f0e817f74f6aa3eb5204c944151764922157
          • dbc7599aac5bc984a80d8c3d41f423ce84b389af1764922157
          • e93775c7511fc42ddec8e3812eaff2ff1e0549421764922158
          • ffe335d3ba763d3f40412c5ea554aa31ec2bdbec1764922158
          • 7a5b8639b3d112862aad248700d2634af876a2621764922158
          • 6a73fb08a4ff02bdabe5f6471c5b5c26776a514b1764922158
          • db3c729d2aff71bc90ef8400ca61ba0f0fe2da061764922159
          • 77cdb40d7a041defea70d8a6f0bd4ce9765d3ea21764922159
          • 1a7946e1e1c98aadd81ca6216f975c166b7e739f1764922159
          • 8f98464d3e845c2ee19018b6e63ac11733af5f9f1764922160
          • 0d77661cc1c2190dd6d74d42faa2dc9b9fd517601764922160
          • b397013c80ff4bf30cff449d90e920e608cd92091764922160
          • b83399702a3ed8ec0c3124700832a52a00db7a921764922160
          • dcc18b877f1b6bd6ccf1171a31bb33106c8543c21764922161
          • 6e93fc57235cc73e57ff76a585fab30f91a78ae21764922161
          • 5990c93e3d4b77b0d5b8c50d2acd2b18e0a9fed11764922161
          • f66b0bc05472612637c0a0ddbce56b3b2f032b4b1764922161
          • 758b30f38ba2e81cf9082711b6a67ca5eb9c9cea1764922162
          • 15069a9c630bdc22e542b5c9b0c8684ee31af8511764922162
          • 6d385ada233d6a074790a33e53884c62954338891764922162
          • a71465734801446f1565491e8bec94a933e1d1b21764922162
          • 4be54d4087368f9b33ad0d666a78fdb5a99262921764922163
          • eb3f4dfa0dad11f498e94f247e26ab40a9621e3e1764922163
          • 6cac0a382759ebec4045b67ea9c4fad5cf3e2ee51764922163
          • 960bb660a71953b5aeaa4296939fe4163845ec241764922163
          • 94b14cb3367c1a2dbd212aaff3f2344b0ceeb6451764922164
          • 10297f25204ff953f32300884c4f258f50e3b9371764922164
          • 4297d394f66f9f25a98b7d85cea2c53deed20c611764922164
          • 04dfb769e7756b22203d7b0fa215beec820520e11764922164
          • 7e58831a1a7bedab75b666099102728b26aab94b1764922164
          • 27272b674342a5b57ecbf9d1fc6c6056385825a91764922165
          • ab702367eee32893019d829969d932b89be187f31764922165
          • cfeb8eaeef113a5ecb3e61db054ed00840a7e23a1764922165
          • ea28d14eb63a3178ff0b67be4ec4195e2c6a24db1764922166
          • aa58e1dd10dc7baaac93569781fedad6fd1a747c1764922166
          • 9461b26f7b1be2000d7c3304ef7795af89da05401764922166
          • 5be783eec4ec4c59b3ae228a01944b34fb8a89301764922166
      ====
    • Request
      +

      Request

      Cake Params

      • plugin(null)
      • controllerschool
      • actionmap_and_coupon
      • named(empty)
      • pass(empty)
      • schoolId3014595
      • _Token(array)
        • key5be783eec4ec4c59b3ae228a01944b34fb8a8930
        • 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.058967 sec
      No. time query
      1 0.002077
      connect
      2 0.000677
      DESCRIBE `school`
      3 0.000537
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3014595') 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.001377
      DESCRIBE `school_score`
      5 0.017357
      SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3014595') 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 22350 Using where
      6 0.000607
      DESCRIBE `access_log_school`
      7 0.003407
      SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3014595') AND (timestamp_created >= '2025-12-04 16:39:26') 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 2 Using intersect(ix_ip_address_access_log_school,school_id); Using where
      8 0.000567
      DESCRIBE `school_station`
      9 0.000657
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') 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.000437
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '6177')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref station_id station_id 4 const 17
      11 0.000947
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014416', '3014416', '3014595', '3013265', '3013755', '3014619', '3015284', '3014850', '3014970', '3014570', '3015355', '3015684', '3015137', '3015880', '3015961', '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 16 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.000557
      DESCRIBE `city`
      14 0.000377
      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.000557
      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.003527
      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.000567
      DESCRIBE `prefecture`
      18 0.000367
      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.000457
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') 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.000507
      DESCRIBE `station`
      21 0.000367
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6177') 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.000377
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595')
      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.000497
      DESCRIBE `station_station_unit`
      25 0.000367
      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
      26 0.000367
      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.000367
      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
      28 0.000347
      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
      29 0.000617
      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
      30 0.001017
      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.000917
      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
      32 0.000627
      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
      33 0.000367
      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
      34 0.000337
      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.000607
      DESCRIBE `major_city`
      36 0.000547
      DESCRIBE `city_major_city`
      37 0.000407
      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.000357
      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.000797
      DESCRIBE `summary_count_school`
      40 0.001547
      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.000837
      DESCRIBE `campaign_school`
      42 0.000547
      SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3014595') 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.000427
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014595') 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.000437
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6177') 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.000347
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '2847') 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.000367
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6178') 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.000867
      DESCRIBE `category_school`
      48 0.001107
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') 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.000387
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') 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.000387
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') 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.000407
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3014595') 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.000597
      DESCRIBE `dancer`
      53 0.000367
      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.000427
      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.000527
      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.000417
      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.000377
      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.001077
      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.001407
      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 12.75 MB

      Message Memory use
      Component initialization 2.16 MB
      Controller action start 3.97 MB
      Controller render start 4.67 MB
      View render complete 5.65 MB

      Timers

      Total Request Time: 2255 (ms)

      Message Time in ms Graph
      Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 2084.51
      Event: Controller.initialize 61.35
      Event: Controller.startup 0.63
      Controller action 0.27
      Event: Controller.beforeRender 54.94
      » Processing toolbar data 48.13
      Rendering View 27.45
      » Event: View.beforeRender 0.54
      » Rendering APP/View/School/map_and_coupon.ctp 6.24
      » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.13
      » » Rendering APP/View/Elements/adsense/336_288.ctp 0.05
      » Event: View.afterRender 0.02
      » Event: View.beforeLayout 0.02
      » Rendering APP/View/Layouts/default.ctp 19.88
      » » Rendering APP/View/Elements/header.ctp 0.31
      » » Rendering APP/View/Elements/school/detailHeader.ctp 7.87
      » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.09
      » » » Rendering APP/View/Elements/breadcrumb.ctp 0.18
      » » Rendering APP/View/Elements/menu.ctp 9.39
      » » » 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.48
      » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.06
      » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.05
      » » Rendering APP/View/Elements/rtt.ctp 0.08
      » » Rendering APP/View/Elements/footer.ctp 0.81
      » » Rendering APP/View/Elements/common/scoreEx.ctp 0.05
      Event: View.afterLayout 0.00
      ====
    • Log
      +

      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
            • stationId6177
        • 4(array)
          • name大阪タンゴ
          • link
      • ChargedNeighborSchoolSet(empty)
      • SchoolScoreSet(object)
        • 0(object)
          • id3805637
          • school_id3014595
          • kuchikomi_questionnaire_item_id1
          • score5.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:33
          • timestamp_modified2021-08-03 15:06:33
        • 1(object)
          • id3805638
          • school_id3014595
          • kuchikomi_questionnaire_item_id2
          • score4.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:33
          • timestamp_modified2021-08-03 15:06:33
        • 2(object)
          • id3805639
          • school_id3014595
          • kuchikomi_questionnaire_item_id3
          • score4.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:33
          • timestamp_modified2021-08-03 15:06:33
        • 3(object)
          • id3805640
          • school_id3014595
          • kuchikomi_questionnaire_item_id4
          • score4.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:33
          • timestamp_modified2021-08-03 15:06:33
        • 4(object)
          • id3805641
          • school_id3014595
          • kuchikomi_questionnaire_item_id5
          • score4.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:33
          • timestamp_modified2021-08-03 15:06:33
        • 5(object)
          • id3805642
          • school_id3014595
          • kuchikomi_questionnaire_item_id6
          • score4.00
          • is_latest1
          • timestamp_created2021-08-03 15:06:33
          • timestamp_modified2021-08-03 15:06:33
      • School(object)
        • id3014595
        • name大阪タンゴ
        • branch_name
        • city_id1450
        • schoolgroup_id(null)
        • mail_addressosakatango@gmail.com
        • lat34.697199000000
        • lon135.502893000000
        • telephone_number06-6365-5708
        • homepage_urlhttp://www.osakatango.com
        • mobile_homepage_url
        • blog_url
        • open_hour平日、日、祝19:00~24:00 　金、土19:00~26:00
        • holiday
        • post_code5300047
        • town_address西天満4-12-22
        • building第3青山ビルB02号
        • image_hash(null)
        • image_extension_type(null)
        • message_image_hash(null)
        • message_image_extension_type(null)
        • is_registered_by_not_owner0
        • is_opening1
        • message_title大阪でアルゼンチンタンゴ 全くの初心者大歓迎、楽しく 親切、丁寧に指導致します。お一人の参加もOKです 特別に用意するものもありません。お気軽にお越し下さい
        • message_body関西で一つしかないアルゼンチンタンゴバーのフロアで 本場の雰囲気さながらアルゼンチン人講師が初心者むけ レッスン＆パーティーを開催しております 非日常の空間を是非体験しに来て下さい 体験レッスン2000円　（サルサ＆バチャータもあります）
        • 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_course0
        • has_beginner_course1
        • score4.00
        • kuchikomi_count1
        • timestamp_created0000-00-00 00:00:00
        • timestamp_modified2021-08-03 15:06:33
        • 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_3014595/map_and_coupon
      Query String
      Request Method GET
      Server Protocol HTTP/1.1
      Gateway Interface CGI/1.1
      Redirect Url /detail/L_3014595/map_and_coupon
      Remote Port 40818
      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=lqgil1d41m2m4jdigrtvo3u1ra09obst
      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 aTKMLLmS8BVLjqLd6h1z1QAAAio
      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 aTKMLLmS8BVLjqLd6h1z1QAAAio
      Redirect Mef Proxy Addr 183.90.231.12
      Fcgi Role RESPONDER
      Php Self /index.php
      Request Time Float 1764920364.7964
      Request Time 1764920364
      ====
    • 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/KuchikomiListPageLink/ToCityPage.php
          • 6APP/class/Sgv/Front/SearchTransitable/ToCityPage.php
          • 7APP/class/Sgv/Front/SearchState/KuchikomiList.php
          • 8APP/class/Sgv/Front/SearchStateExplainable/KuchikomiList.php
          • 9APP/class/Sgv/Front/SearchUrlParameter/KuchikomiList.php
          • 10APP/class/Sgv/Front/SearchCondition/KuchikomiList.php
          • 11APP/class/Sgv/Front/KuchikomiListPageLink/ToCategoryPage.php
          • 12APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
          • 13APP/class/Sgv/Front/TransitionalLinkShower/KuchikomiList.php
          • 14APP/class/Sgv/Front/TransitionalLinkShowDescidable/KuchikomiList.php
          • 15APP/class/Sgv/Front/InputForm/KuchikomiSearch.php
          • 16APP/class/Sgv/Front/InputItem/KuchikomiSearch.php
          • 17APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
          • 18APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.php
          • 19APP/class/Sgv/Front/SearchState/SchoolList.php
          • 20APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
          • 21APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
          • 22APP/class/Sgv/Front/SearchCondition/SchoolList.php
          • 23APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
          • 24APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
          • 25APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
          • 26APP/class/Sgv/Front/InputForm/SchoolSearch.php
          • 27APP/class/Sgv/Front/InputItem/SchoolSearch.php
          • 28APP/class/Sgv/Front/KuchikomiListPageLink/ToStationUnitPage.php
          • 29APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
          • 30APP/class/Sgv/Front/KuchikomiListPageLink/ToStationPage.php
          • 31APP/class/Sgv/Front/SearchTransitable/ToStationPage.php
          • 32APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
          • 33APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.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

    ページの先頭へ戻る