現在の教室登録院数 2603 件

アルゼンチンタンゴ札幌レネ＆ジュンコ 　　の地図・アクセス・最寄駅・特典

メンバー登録   ログイン

ダンススクール

アルゼンチンタンゴ札幌レネ＆ジュンコ 　　

口コミを書く

Campaign 特典

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

Access 地図・交通案内

アルゼンチンタンゴ札幌レネ＆ジュンコ 　　の地図・交通案内

住所

北海道 札幌市中央区 南5条東２丁目 シティビル南5条2F　スタジオ豊水SQ

最寄駅

  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    ====
  • Session
    +

    Session

    • _Token(array)
      • key0a42b679f14d1a19af3eba491ff29e5ccbdb5e58
      • allowedControllers(empty)
      • allowedActions(empty)
      • unlockedFields(empty)
      • csrfTokens(array)
        • a2778620f292292cf07d9d4aca7059725faee6011764929466
        • 45206287a8932a60cd0f4e9b3cf2be18a1c9f2231764929466
        • 2c1e8aedad7522ee587bf0da42dde2599048683d1764929467
        • 0725ef227aeb7d65cb885dbe3299bdd7982a0e301764929467
        • a3a9b2576950e12cf63ff96b81e55e0dd1860b0d1764929467
        • 57da78c38cda69e44809298c31596575beb7ca871764929468
        • d5b1125716cffbadca6e780860b5cf1e90bf56ff1764929468
        • 79c89ceb83a1e63d644897ae6de3eb89ac54cadb1764929468
        • c5b5e896fdfecb4a749566d5eca0655dbee87fdb1764929469
        • 5b32a69b54f79161f7f31592abc3a1b6c07fee7e1764929469
        • 606e98d8da083e307cc7b40cc7c14c4d0b1033341764929469
        • 1f0c3d8b318899c2b44c2f7ba13df2d45e35e26b1764929469
        • cf01d86e66841a14a04340eca3d8107068187e541764929470
        • f528e58ef4634c2a55dd27d68ba46d0ee64d63a01764929470
        • 5695eb4423552d879e50d8bbb7b9b3ff58cd244f1764929470
        • f16dfa778e8f6f346fb22fd8487332e6dab263d31764929470
        • f3539a72726b56b84715a21ccefad845cf4662321764929471
        • 30f41883c0421fb391b6095d8d388a9247deb55b1764929471
        • 7e39f61d28203c449ffcf0b8a3d3690f2328e0791764929471
        • 6d41b8faf93db0040cf79562511112c24e9a790d1764929471
        • 25c45100bd1dafc7f05b9b24e65b6d5386a484d91764929472
        • ac9f485427243ffa55e8af91bd74bb759b6afab71764929472
        • 852a24a28e61a5b0537a806f5b2e6efadad0f2841764929472
        • 6f5e2dc033a29dd81548bd65b99aa0070ebd12ae1764929472
        • 8bae25f870c670414b23028391fafacd2c946ca31764929473
        • 81b42a9b30e123d118b1479ef012d9c34a321c661764929473
        • c1c7f3b8feb77a75d7607a974cc32bb2e516605e1764929473
        • 9a0de9e149498b600fab6c4dd66ae14b92f310b51764929474
        • 6ac5769d7a8857f31e8fef229742bab8f4de1e051764929474
        • bc7575663415fdd0e00bf65ab9129456b91cc6db1764929474
        • 196c27789cefd287b4337068ff5a48896243ba6c1764929474
        • 12fcc8a39f1572086c2a49f0b5b6484eaa8ee1bb1764929475
        • 656762ca10cc34f408f57439cba64dd78859aa6c1764929475
        • 102e3e7a943a22b28f66cac472ac948ba5dddb761764929476
        • 88f691a16b361ab2f8e88feca085b1a019e135651764929476
        • c7738813753279ff6d659818d4e8bcb210aed9161764929476
        • 55a0fd1a7b6a0828fe62bbc02ba6a63731f61d221764929476
        • 9590a77826ce9248ef39b98c03a5af0dc3a104541764929476
        • c4b9613cd374593e502c61e869111e8983d232321764929477
        • 1971e07160734ca9c3ce24b97901a3d834dc517e1764929477
        • af5053ea6fd4e780782c92614c3b254b2c0c9c781764929477
        • 63d4261fd401b1f453634a9c39bfca66d3203c941764929477
        • 40f8478d1103ae1b59c88e3d2ebb5ae75a75e9be1764929478
        • 45858468215ff508bcd1288f2d86cca7686b92d21764929478
        • 61039a45148e1280f4f3784754f8cca9009f11421764929478
        • 8e7bf7e7fa8215ee97a3a155e383539f936ee0081764929478
        • e193b7f75e627ba51f3c545dd18b14644f89a4f71764929479
        • 368c86c196cfd84873ec15e9d280cd426c6a809c1764929479
        • 32815a4ab408e507e28160174cfcb9beed34c5471764929479
        • bde95003eab76556e5e786e474e8d3db8fcae0011764929479
        • b76bbbe1b04a6cc524b95a11c9b0be855ccb46e61764929479
        • 9afda7f8d17b473bdf96647cacb283f0a317e1f21764929480
        • 6b91e8721dde0d8aba3b4d7ab4ce4b90a5585a131764929480
        • f04a466d90641106cbdc2462041f7254ae0a086c1764929480
        • 8b5a53d79167b7927a3958d1449eaf3456694a4a1764929480
        • e4404bf0a9d2eb0b2132466c744e711770cfa2651764929481
        • 4f6a2f8d0d1adce90555f161f5c71bd2219318e31764929481
        • d3209dba8aa46250cbd50de049d3a191261024f41764929481
        • a25fd791772db162da294490705a6e2f394d6e9a1764929481
        • 34871f177d93e463ed5017ae1f5f4198ea8b4e501764929482
        • 4b573f40485dda47819d70ecf9d9e5cc27473ae11764929482
        • 5c18c17a5b756e08e21cf6280d4f3a5dca79dea51764929482
        • af1a1624cda747ffc2509d1a97d664e5e498f1581764929483
        • 1fbfcd6c296cfcd184c169faacb6b0c85a7a4b691764929483
        • a2d023de1a91cc84f6dc595f672f74c98b273c071764929483
        • c0de4981c2d9eba17b5d8286ae494ccf883042dd1764929483
        • ed73d6345e2ab679893b5087872908d6fd8ba2621764929484
        • 1049451748e5bfbc2423d77a8d87d87601e61c2f1764929484
        • f5cb3c058cc47af93209cbec07441b63a930e5161764929484
        • 8a2974a0b4913d0a5177baf4a817f95230e457e51764929484
        • 12c8d4ae23baa41e620011a3a11b21d93fe99a191764929485
        • 5c1bcdf06179ff3053f4cf87c1a37a8146e84fb21764929485
        • 71b075ce19843d095545ad5c6998258c168528561764929485
        • 8943a218b5618cf9fdbc30894fb58672a35018811764929486
        • 6ff76da0756414cc41fd7a98a5204be6b9ed7aee1764929486
        • 9928e6e5ef136ffaafcef9e798fccf0461f78e741764929486
        • aeb2bfb8149e1d1dba0be222e2a6edc67622af281764929487
        • c451596bbd6b1d0020b5ca416fdc4470ad2b87f01764929487
        • ceb2d017fec5a3016fd9934706b10f5b7a31581a1764929487
        • 423c550b58c08fc61c30076cea6bd25d843deedf1764929488
        • 4e8cc95f235c7b3f27d2e352a1e5c6b82e5efa0e1764929488
        • 1f6a193e3ac4efff2f4f4db5cdd3c3b6335312c41764929488
        • ce86e19ab888745408cd5dcc2acc9754f2ae3d511764929489
        • 20e2cebc889179b6f49252221e5c79208cf87cf41764929489
        • 8965c476416d3f1fda832d048ca4aead47aeea241764929489
        • eac439fb7759fa5d7e43d1c3437cce5689fbad911764929489
        • 100da44fcb080c1fc710bcb9d7c258c93340854e1764929490
        • 09963d850536aa70afc13e5c8b51923fbf2f7fb11764929490
        • 0ab61249f00d7bdd90a3bab5fb3edc4faa30432e1764929490
        • bb09c6a9af8631acdbfb75a7c943d99c85f54a0c1764929491
        • a3a4fb1d2278a7242a6a62d5d9bb7d39a99787291764929491
        • 7fb16ace27a45c60100b69073195ce58604304a41764929491
        • ceff1ce12f69779f226a4d1dcbb22caa3d6e50c41764929492
        • 7081d917cbc363be3eb768963861acabd93e97451764929492
        • 919cf860ac2e16b54ec289f29389fc6fe393ea051764929492
        • 4890496fdfb6401cb66ffe211074f10d10b33d8a1764929493
        • 5de588ed6f67b8781d9a700d090922f29b0b9f021764929493
        • ac6491033282e622e4fa2d923d949d3f6b11e9931764929493
        • 48dee0ef941510cfcc14ca11b5ea1cdc0d6101631764929493
        • 0a42b679f14d1a19af3eba491ff29e5ccbdb5e581764929494
    ====
  • Request
    +

    Request

    Cake Params

    • plugin(null)
    • controllerschool
    • actionmap_and_coupon
    • named(empty)
    • pass(empty)
    • schoolId3015793
    • _Token(array)
      • key0a42b679f14d1a19af3eba491ff29e5ccbdb5e58
      • 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: 64 queries / 0.060907 sec
    No. time query
    1 0.002007
    connect
    2 0.003727
    DESCRIBE `school`
    3 0.000707
    SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3015793') 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.000837
    DESCRIBE `schoolgroup`
    5 0.000547
    SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '179') AND (sg.registration_status = 1) LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE sg const PRIMARY PRIMARY 4 const 1
    6 0.000497
    SELECT COUNT(*) AS `cnt` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.schoolgroup_id = '179') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s ref ix_schoolgroup_id_school ix_schoolgroup_id_school 5 const 2 Using where
    7 0.000627
    DESCRIBE `school_score`
    8 0.000417
    SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3015793') 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
    9 0.000527
    DESCRIBE `access_log_school`
    10 0.003027
    SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3015793') AND (timestamp_created >= '2025-12-04 18:41:34') 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
    11 0.000577
    DESCRIBE `school_station`
    12 0.000477
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015793') 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 10
    13 0.000407
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '6424')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s ref station_id station_id 4 const 6
    14 0.000517
    SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3013282', '3013313', '3015159', '3015729', '3015793', '3015456')) 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 6 Using where
    15 0.000627
    SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '91') 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 21 Using where
    16 0.000577
    DESCRIBE `city`
    17 0.000347
    SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '91') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE c const PRIMARY PRIMARY 4 const 1
    18 0.000637
    SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '1')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE c ref prefecture_id prefecture_id 5 const 105
    19 0.001707
    SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1', '2', '3', '4', '5', '7', '9', '13', '14', '23', '25', '26', '27', '29', '30', '32', '33', '34', '40', '44', '45', '46', '47', '48', '49', '52', '56', '59', '62', '76', '78', '80', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '101', '102', '104', '105', '106', '107', '110', '111', '112', '114', '115', '116', '117', '125', '126', '127', '128', '132', '133', '139', '140', '143', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '164', '165', '166', '167', '169', '170', '171', '172', '174', '175', '176', '177', '178', '185', '186', '187', '190', '191', '197', '200', '202', '203', '204', '205')) 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 143 Using index condition; Using where
    20 0.000747
    DESCRIBE `prefecture`
    21 0.000397
    SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '1') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE p const PRIMARY PRIMARY 4 const 1
    22 0.000507
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015793') 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 10 Using index condition; Using filesort
    23 0.000617
    DESCRIBE `station`
    24 0.000397
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6454') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s const PRIMARY PRIMARY 4 const 1
    25 0.000547
    DESCRIBE `station_unit`
    26 0.000467
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015793')
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s_s ref school_id school_id 4 const 10
    27 0.003647
    DESCRIBE `station_station_unit`
    28 0.000437
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6424')
    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.000407
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6425')
    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.000367
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6439')
    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.000377
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6440')
    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.000387
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6454')
    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 = '6455')
    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.000357
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6460')
    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.000347
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6478')
    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.000367
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6479')
    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.000387
    SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6480')
    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 (false)
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE Impossible WHERE
    39 0.000637
    DESCRIBE `major_city`
    40 0.000597
    DESCRIBE `city_major_city`
    41 0.000407
    SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '91')
    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
    42 0.000377
    SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE m_c const PRIMARY PRIMARY 4 const 1
    43 0.000737
    DESCRIBE `summary_count_school`
    44 0.000537
    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
    45 0.003217
    DESCRIBE `campaign_school`
    46 0.007267
    SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3015793') 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
    47 0.000457
    SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015793') 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 10 Using index condition; Using filesort
    48 0.005157
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6454') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s const PRIMARY PRIMARY 4 const 1
    49 0.003607
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6425') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s const PRIMARY PRIMARY 4 const 1
    50 0.000467
    SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6439') LIMIT 1
    id select_type table type possible_keys key key_len ref rows Extra
    1 SIMPLE s const PRIMARY PRIMARY 4 const 1
    51 0.000727
    DESCRIBE `category_school`
    52 0.000667
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015793') 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
    53 0.000437
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015793') 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
    54 0.000417
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015793') 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
    55 0.000427
    SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015793') 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
    56 0.000637
    DESCRIBE `dancer`
    57 0.000517
    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
    58 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
    59 0.000617
    DESCRIBE `dancer_column`
    60 0.000677
    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
    61 0.000447
    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
    62 0.000437
    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
    63 0.000437
    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
    64 0.000737
    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.61 MB

    Message Memory use
    Component initialization 2.16 MB
    Controller action start 4.30 MB
    Controller render start 4.82 MB
    View render complete 5.85 MB

    Timers

    Total Request Time: 3086 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 2906.14
    Event: Controller.initialize 56.77
    Event: Controller.startup 0.47
    Controller action 0.15
    Event: Controller.beforeRender 33.45
    » Processing toolbar data 25.38
    Rendering View 50.87
    » Event: View.beforeRender 0.80
    » Rendering APP/View/School/map_and_coupon.ctp 25.75
    » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.20
    » » Rendering APP/View/Elements/adsense/336_288.ctp 0.09
    » Event: View.afterRender 0.04
    » Event: View.beforeLayout 0.03
    » Rendering APP/View/Layouts/default.ctp 23.21
    » » Rendering APP/View/Elements/header.ctp 0.45
    » » Rendering APP/View/Elements/school/detailHeader.ctp 8.87
    » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.15
    » » » Rendering APP/View/Elements/breadcrumb.ctp 0.31
    » » Rendering APP/View/Elements/menu.ctp 10.60
    » » » Rendering APP/View/Elements/school/right-menu.ctp 10.37
    » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.10
    » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.10
    » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 9.17
    » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.10
    » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.08
    » » Rendering APP/View/Elements/rtt.ctp 0.14
    » » Rendering APP/View/Elements/footer.ctp 1.25
    » » 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
          • prefectureId1
      • 2(array)
        • name札幌
        • link(array)
          • controllerschool_list
          • actionindex
          • prefectureId1
          • majorCityId9
      • 3(array)
        • name札幌市中央区
        • link(array)
          • controllerschool_list
          • actionindex
          • prefectureId1
          • cityId91
      • 4(array)
        • name豊水すすきの駅
        • link(array)
          • controllerschool_list
          • actionindex
          • stationId6454
      • 5(array)
        • nameアルゼンチンタンゴ札幌レネ＆ジュンコ 　　
        • link
    • ChargedNeighborSchoolSet(empty)
    • SchoolScoreSet(object)
      • SchoolCount1
      • Schoolgroup(object)
        • id179
        • nameレネ＆ジュンコ札幌タンゴミロンガWS
        • admin_member_id2062
        • mail_address(null)
        • telephone_number
        • homepage_urlhttp://jmty.jp/hokkaido/les-dan/article-1z388
        • mobile_homepage_urlhttps://www.dance-schoolgv.net/detail/L_3015793
        • summary札幌タンゴレッスン＆札幌ミロンガ 会場：スタジオ豊水すすきのSQホール 札幌市中央区南五条東2丁目シティビル南5条2F
        • message_title(null)
        • message_body(null)
        • registration_status1
        • image_hash0497284fa9098c2c
        • image_extension_type2
        • message_image_hash(null)
        • message_image_extension_type(null)
        • whole_staff_titleユキ先生
        • whole_staff_introductionアンドレス＆ユキ
        • whole_staff_image_hash6971db1a9cb53b0c
        • whole_staff_image_extension_type2
        • score0.00
        • kuchikomi_count0
        • timestamp_created2014-11-25 06:59:54
        • timestamp_modified2021-08-03 15:10:05
      • School(object)
        • id3015793
        • nameアルゼンチンタンゴ札幌レネ＆ジュンコ
        • branch_name　　
        • city_id91
        • schoolgroup_id179
        • mail_addresskin137lute@yahoo.co.jp
        • lat43.0558356
        • lon141.360179
        • telephone_number
        • homepage_urlhttp://www.dancegate.com/fellow/fellowship844.html
        • mobile_homepage_url
        • blog_urlhttp://ameblo.jp/tangosapporo/nt.php?event_id=8500
        • open_hour
        • holiday
        • post_code
        • town_address南5条東２丁目
        • buildingシティビル南5条2F　スタジオ豊水SQ
        • image_hashd991048f10a89ca0
        • image_extension_type2
        • message_image_hashf5ae5dc9fb8f6d69
        • message_image_extension_type2
        • is_registered_by_not_owner0
        • is_opening1
        • message_titleレネ＆ジュンコ札幌タンゴミロンガ
        • message_bodyレネ＆ジュンコ タンゴ札幌ミロンガ アルゼンチン、ブエノスアイレスで行われた権威あるタンゴ選手権大会メトロポリターノタンゴ選手権/準優勝の実力派カップル レネ & ジュンコ / Rene & Junkoによるデモ https://www.youtube.com/watch?v=cyTWLHQDAwc https://www.youtube.com/watch?v=ZcjJzyUJsrM ９月１７~１８日 札幌タンゴミロンガ 会場：スタジオ豊水すすきのSQホール 札幌市中央区南五条東2丁目 シティビル南5条2F http://studio-housuisusukino-sq.com/ ☆レネのママが作ったミロンガドレスの販売を行います！ 札幌タンゴWSスケジュール 9/17(土) グループレッスン ①18:30ー19:40 　ワルツとカデンシア ②19:50ー21:00　 心地良いアブラッソとコネクション 　　　　　 ボレオやボルカーダのための軸のコントロール 9/18(日) ③グループレッスン　　 18:00ー19:10 ミロンガ リズムの取り方とステップ/トラスピエ ミロンガタイム(デモ有り） 19:10ー22:00 グループレッスン 2,500円 ミロンガ 3,000円 レッスン +ミロンガ 5,000円 ☆無断撮影者の入場は固くお断りします。 札幌タンゴスクール　札幌タンゴワークショプ　札幌タンゴ練習会　札幌タンゴ 札幌ミロンガ情報　札幌タンゴ情報　札幌タンゴレッスン　札幌タンゴスタジオ　札幌タンゴ　札幌タンゴ教室　札幌ミロンガ　札幌タンゴスタジオ情報　札幌タンゴスタジオレッスン　札幌タンゴスタジオ　札幌ミロンガ　札幌アルゼンチンタンゴスタジオ　タンゴスタジオ札幌　札幌アルゼンチンタンゴ　
        • 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_course0
        • score0.00
        • kuchikomi_count0
        • timestamp_created2015-02-15 02:20:19
        • timestamp_modified2021-08-03 15:07:54
        • 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://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_3015793/map_and_coupon
      Query String
      Request Method GET
      Server Protocol HTTP/1.1
      Gateway Interface CGI/1.1
      Redirect Url /detail/L_3015793/map_and_coupon
      Remote Port 39804
      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=246ivqs4bqnf7k653jga30l93an5ibp2
      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 aTKoy9fyCEp5VdikckLPUwAAAio
      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 aTKoy9fyCEp5VdikckLPUwAAAio
      Redirect Mef Proxy Addr 183.90.231.12
      Fcgi Role RESPONDER
      Php Self /index.php
      Request Time Float 1764927691.3765
      Request Time 1764927691
      ====
    • Include
      +

      Included Files

      Include Paths

      • 0/home/jobikai/dance-schoolgv.net/cakephp/lib/ZendFramework/library/
      • 1/home/jobikai/dance-schoolgv.net/vendor/phpunit/dbunit
      • 6/home/jobikai/dance-schoolgv.net/vendor/symfony/yaml
      • 3/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-code-coverage
      • 4/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-token-stream
      • 5/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit
      • 7/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-mock-objects
      • 8/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-selenium
      • 9/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-story
      • 10/home/jobikai/dance-schoolgv.net/cakephp/lib
      • 12/opt/php-5.6.40-3/data/pear
      • 13-> /home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/

      Included Files

      • core(array)
        • Cache(array)
          • 0CORE/Cache/Cache.php
          • 1CORE/Cache/Engine/FileEngine.php
          • 2CORE/Cache/CacheEngine.php
        • Component(array)
          • 0CORE/Controller/Component/SecurityComponent.php
          • 1CORE/Controller/Component/SessionComponent.php
        • Config(array)
          • 0CORE/Config/routes.php
          • 1CORE/Config/config.php
        • Controller(array)
          • 0CORE/Controller/Controller.php
          • 1CORE/Controller/ComponentCollection.php
          • 2CORE/Controller/Component.php
        • Datasource(array)
          • 0CORE/Model/Datasource/CakeSession.php
        • Error(array)
          • 0CORE/Error/exceptions.php
          • 1CORE/Error/ErrorHandler.php
        • I18n(array)
          • 0CORE/I18n/I18n.php
          • 1CORE/I18n/L10n.php
        • Log(array)
          • 0CORE/Log/CakeLog.php
          • 1CORE/Log/LogEngineCollection.php
          • 2CORE/Log/Engine/FileLog.php
          • 3CORE/Log/Engine/BaseLog.php
          • 4CORE/Log/CakeLogInterface.php
        • Model(array)
          • 0CORE/Model/Model.php
          • 1CORE/Model/BehaviorCollection.php
          • 2CORE/Model/ConnectionManager.php
        • Network(array)
          • 0CORE/Network/CakeRequest.php
          • 1CORE/Network/CakeResponse.php
        • Other(array)
          • 0CORE/bootstrap.php
          • 1CORE/basics.php
          • 2CORE/Core/App.php
          • 3CORE/Core/Configure.php
          • 4CORE/Core/CakePlugin.php
          • 5CORE/Event/CakeEventListener.php
          • 6CORE/Event/CakeEvent.php
          • 7CORE/Event/CakeEventManager.php
          • 8CORE/Core/Object.php
        • Routing(array)
          • 0CORE/Routing/Dispatcher.php
          • 1CORE/Routing/Filter/AssetDispatcher.php
          • 2CORE/Routing/DispatcherFilter.php
          • 3CORE/Routing/Filter/CacheDispatcher.php
          • 4CORE/Routing/Router.php
          • 5CORE/Routing/Route/CakeRoute.php
          • 6CORE/Routing/Route/PluginShortRoute.php
        • Utility(array)
          • 0CORE/Utility/Hash.php
          • 1CORE/Utility/Inflector.php
          • 2CORE/Utility/ObjectCollection.php
          • 3CORE/Utility/Debugger.php
          • 4CORE/Utility/String.php
          • 5CORE/Utility/Security.php
        • View(array)
          • 0CORE/View/HelperCollection.php
      • app(array)
        • Config(array)
          • 0APP/Config/core.php
          • 1APP/Config/bootstrap.php
          • 2APP/Config/routes.php
          • 3APP/Config/database.php
        • Controller(array)
          • 0APP/Controller/SchoolController.php
          • 1APP/Controller/AppController.php
        • Other(array)
          • 0APP/webroot/index.php
          • 1APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
          • 2APP/class/Sgv/Front/AttachableToDataSet/City.php
          • 3APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
          • 4APP/class/Sgv/Front/AttachableToDataSet/Station.php
          • 5APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
          • 6APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
          • 7APP/class/Sgv/Front/SearchState/SchoolList.php
          • 8APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
          • 9APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
          • 10APP/class/Sgv/Front/SearchCondition/SchoolList.php
          • 11APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
          • 12APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
          • 13APP/class/Sgv/Front/InputForm/SchoolSearch.php
          • 14APP/class/Sgv/Front/InputItem/SchoolSearch.php
      • plugins(array)
        • DebugKit(array)
          • Component(array)
            • 0DebugKit/Controller/Component/ToolbarComponent.php
          • Other(array)
            • 0DebugKit/Lib/DebugMemory.php
            • 1DebugKit/Lib/Panel/HistoryPanel.php
            • 2DebugKit/Lib/DebugPanel.php
            • 3DebugKit/Lib/Panel/SessionPanel.php
            • 4DebugKit/Lib/Panel/RequestPanel.php
            • 5DebugKit/Lib/Panel/SqlLogPanel.php
            • 6DebugKit/Lib/Panel/TimerPanel.php
            • 7DebugKit/Lib/Panel/LogPanel.php
            • 8DebugKit/Lib/Panel/VariablesPanel.php
            • 9DebugKit/Lib/Panel/EnvironmentPanel.php
            • 10DebugKit/Lib/Panel/IncludePanel.php
            • 11DebugKit/Lib/DebugTimer.php
          • Log(array)
            • 0DebugKit/Lib/Log/Engine/DebugKitLog.php
      ====

    Special Column

    ページの先頭へ戻る