現在の教室登録院数 2603 件

藤間綾由貴 綾扇会 王子稽古場の地図・アクセス・最寄駅・特典

メンバー登録   ログイン

ダンススクール

藤間綾由貴 綾扇会 王子稽古場

  • 地域
  • 東京都
    • |
  • 北区

    • 口コミを書く

    Campaign 特典

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

    Access 地図・交通案内

    藤間綾由貴 綾扇会 王子稽古場の地図・交通案内

    住所

    〒114-0005 東京都 北区 栄町48-26

    最寄駅

    • CakePHP
    • History
      +

      Request History

      4 previous requests available
      ====
    • Session
      +

      Session

      • _Token(array)
        • keyc5ae09a9c6192ba867ef2c8c5adfe8bffd1f3a84
        • allowedControllers(empty)
        • allowedActions(empty)
        • unlockedFields(empty)
        • csrfTokens(array)
          • 1066f7d5214f3385e8cccd99177566381ccfe1131764917074
          • bd90d9893a35a8e6babe0142984e5da46f41ad971764917074
          • 79ffe54113390437fcd534827b92e835aa94c7b41764917075
          • c6bc657e6adfdbaa7e3d3dbbb438fb9dbcc72f411764917075
          • d8ab7fe881bab0bc2d60f91f9569b0902b13f2bc1764917075
          • 74b9d996ae53f2cb74172aa869a6e9d60c154fea1764917076
          • 9b312519dd7161c9bc21019a6c740732748db3c81764917076
          • d6a341d97888e3b1cc8bbcc90d631eb364f5d4ff1764917076
          • 28c5ee99dd0bc1ac020813d07a30bd0ac73301961764917077
          • c784db7c4c298e094ce6feb011d19d4094c1e0c01764917077
          • beba8962359658586b5a650b5c6e06c17653a2c01764917077
          • 6640066ec1f1f0ef74e3d056b7a2206d9e7b69091764917078
          • ec0f1d7e4891d1543dab9a727e1885d3a9be4f2c1764917078
          • 691d61044eab91a3bff0e4f70b0b82453e5828f71764917078
          • 128fd187b4f5f4224eb6d81e73477f48bf32948c1764917079
          • 9857d619c54ff6e89eee50772e493385d51d9e581764917079
          • 0284295bec1b2527ebfd0cd24aef6a7328ec78d31764917079
          • 077c47d937fde8381e43015ffa871507a20510a61764917080
          • 07dc6e639a3cf3003b9bdcf9b5200c0dcffa84411764917080
          • 0bae6d541fdcb6ce347bfa10ef8e965be17f50041764917080
          • 0451f6e53f88a349d161c0133a7b61488904930b1764917081
          • cbdd8e2885f5112336e8a6577049f5e1182459261764917081
          • 102dc2b8b633ab4351a2c7a580185ba9b080109e1764917081
          • 83b83a471f2d47097a43fe2c9832bd01efab7ed51764917081
          • 0944c418e4292c3741676fd00176452cb27f35cc1764917082
          • a487f70fc0d96fdfc9ddef5e2d38ee2732de662e1764917082
          • e981a4018d77168c27f72bcb9797f049eeba3c3f1764917083
          • 86c14537e95dd8af3608658783e626b22b53f0791764917083
          • 96f72666cf0b68f65501e9ba75e91eae1f3ddeb31764917149
          • 1d4820c4212e0b1ffa2df62078296a1caa0542aa1764917149
          • 216d691abbb64e2af8af933c7bc926e12f95e6431764917150
          • e24202693baa4086ae909c30d4b304566a1760061764917150
          • a22a0ee29072845eb4d69bd0a6a79cb40b7df68b1764917150
          • c304c9385da0e6960538e11683ea81f4a793b3ef1764917151
          • 1930a1cae6389a3505632149706e6ba363be83e41764917151
          • bb4c3da7de5f31fca9e20f55cd8932916fcf426e1764917151
          • af490dcfa41bd325dc86d672083cd3952db595b01764917151
          • aae2153971875175481bc4fc07d4ff41c16038d51764917152
          • 7225a484379efb93868839ec0c6d991807f3e7821764917152
          • 65caa27b5e756df89df4a3d9eefc7a427cb09c4e1764917152
          • 4e0cea036b238bc157757a90fb1d46171071bd8c1764917153
          • 8d0a243b3f0be42e333b56804e3faa2b157cb02f1764917153
          • 2e24338c2a1ec1d199fce9b47f6aa3504a771af21764917153
          • d4dc7cc99ca44a45fa192d7eca505537846b54781764917154
          • 2e9ffb52e692ccb86dbc0d93f94f11d96d5c68b81764917154
          • 38baaf6de73827f9c61aa1b801c7c107cce966951764917154
          • eaed185ff70aa90976e846de661618a3272aebe81764917155
          • fef2cdb6fdce07114da31ae842aecf25066e2b501764917155
          • 6b69fc2138811a44929ce4bbbb681d030591f3311764917155
          • e4ab841487b2c528a9f02443323537296502acc11764917155
          • 6db201660e0acfb4f06812fe7f2511a1cf0f45111764917156
          • 9c72cd053801643d31f36e1d31e1ab8a5e8591ed1764917156
          • dfa7fb47360d2404697445c324d416aed405dc3c1764917156
          • 39df429a7c74a3fe7745e6e046f332909f5d8df01764917156
          • 097f580f4aa2c0afbfc6bf2b27a8c2e3b5f19c791764917157
          • 569c5a6d8a86cec060c28d020b70b56cbb85ee721764917157
          • ba60aecbb1d3a36980f9bcd1f18c7c521171ab5d1764917157
          • cfb9e4906b94ac420ba9b1dd98201a13a94c09e91764917158
          • 8edda01ff7faad56590dd5f6edf04061c2a91dbc1764917158
          • 1f3876f2db931416d9e1c8196188e55fc265cba91764917158
          • 9948b0a07c391973c6b23bf4ebe533ce1aa652411764917158
          • ce01fb5d29e99a0a98c1ba868be561291aeee1a21764917159
          • 66e2cc61c28950fc1df4bda2c39f02c2aab1f3d31764917159
          • 485d8a3a66924d102d09bc9c7848f5412bcb6ddf1764917159
          • e126397e9054ad41f850079f9e803f8c9c18ddcb1764917159
          • d97b903e049f5745e5c5aa71ddb5bd91f59ce49d1764917160
          • 30ef62e0ec0d1bc3919113caae8331ae1714cb011764917160
          • 6a062e2471ce9b249e81d75e90e025310a2854101764917160
          • 96b5d907beae4cdc74f6ff61e00cca1568a057071764917160
          • 7a83daa44896ced2fcb54e859c57c9b61766b3e71764917161
          • 33337aa8783cb508a926c1cf990631c83b8682961764917161
          • 651d68692d131218f30b59429f8526316520ca3a1764917161
          • 1f46495e088760180f5c8609ebb14c387d651dad1764917162
          • fceddfaffab16ccc9d4a946afdea1a32c072ea221764917162
          • 12eae79ba8b8740d6d3a87a72dbb224ed23eb03c1764917162
          • 8679ff2f0cdaec2be93427aec24e71eb9c94eff91764917163
          • 7e4470b5cdd867abb863f080feb53c87baff00481764917163
          • 7c0c2b710c77c79dea6963156c93c18462ffa3ed1764917163
          • b05c3e87526b640cd5a6850f267c8f12bb5f8aa81764917163
          • bcdbaff408cb402bd8699ec38f0f170de77519331764917164
          • 4362f43f0bfdaf1c48f92561373775bd002972a31764917164
          • 7fea6aae9a7b5a515c866658b5892a84628d01181764917164
          • ce5a3d0dbbff6065e8068a52c6364a8a0d66b2831764917164
          • 5c93b69cf8c7d8aefe4dc167389511c36d9983b21764917165
          • c9babb93582e12db175c7e05d03aa5ac4db788891764917165
          • 5900577f937c43ab2f7791401812184d540e922f1764917165
          • 3e0f3d1af7bd8d435df8894c61dbe850461cbe971764917166
          • f9fae784d2098618ce097064a5634fd61598439d1764917166
          • e6c220d47c82ae476ecf401b6d38ca9be52fb7ce1764917166
          • b9a186f3039dca9cf0f79521f6569d15ac398f881764917167
          • 56c4822106298ccae4c81d6c2a54acb20a412c8a1764917167
          • 025d761a697fda9b88cc2a232105dd6c4080b46c1764917167
          • 5cecc318fe2c32f18e0df7fbd2156d3065a26a051764917168
          • ee9236177fcd4df9ab76bb34fab57ee4956031e21764917168
          • a491cb55f25bea8311d60f51fd18d25dc63da94a1764917168
          • 3dd12eee3153dae028694b821f2a81491c4354c51764917169
          • b362859d28058390be0a5dbb17cfdfb0ef7ae6d91764917169
          • f15a203c7f8740ad0c4f290145ca899080f047771764917169
          • 4483f2b521828f4da2db9a6da8fa4b64d368dc0a1764917169
          • c5ae09a9c6192ba867ef2c8c5adfe8bffd1f3a841764917170
      ====
    • Request
      +

      Request

      Cake Params

      • plugin(null)
      • controllerschool
      • actionmap_and_coupon
      • named(empty)
      • pass(empty)
      • schoolId3016028
      • _Token(array)
        • keyc5ae09a9c6192ba867ef2c8c5adfe8bffd1f3a84
        • 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: 61 queries / 0.039927 sec
      No. time query
      1 0.001927
      connect
      2 0.000677
      DESCRIBE `school`
      3 0.000427
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3016028') 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.000487
      DESCRIBE `school_score`
      5 0.000447
      SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3016028') 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.000487
      DESCRIBE `access_log_school`
      7 0.001397
      SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.35') AND (school_id = '3016028') AND (timestamp_created >= '2025-12-04 15:16:10') 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.000497
      DESCRIBE `school_station`
      9 0.000377
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016028') 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
      10 0.000347
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '1624')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s ref station_id station_id 4 const 4
      11 0.000427
      SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3015607', '3015785', '3015991', '3016028')) 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 4 Using where
      12 0.000527
      SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '734') 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 23 Using where
      13 0.000447
      DESCRIBE `city`
      14 0.000317
      SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '734') 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.000527
      SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '12')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE c ref prefecture_id prefecture_id 5 const 59
      16 0.011967
      SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '752', '753', '754', '755', '756', '757', '758', '759', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '780', '781', '782')) 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 ALL city_id 4031 Using where
      17 0.000537
      DESCRIBE `prefecture`
      18 0.000357
      SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '12') 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.000507
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016028') 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
      20 0.000497
      DESCRIBE `station`
      21 0.000377
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6828') 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.000467
      DESCRIBE `station_unit`
      23 0.000377
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016028')
      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
      24 0.000517
      DESCRIBE `station_station_unit`
      25 0.000347
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1624')
      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.000357
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1828')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s_s ref station_id station_id 4 const 1
      27 0.000377
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1829')
      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 = '1830')
      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.000357
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5423')
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s_s_s ref station_id station_id 4 const 1
      30 0.000317
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6826')
      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.000317
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6827')
      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.000337
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6828')
      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.000337
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6829')
      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.000377
      SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6830')
      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.000317
      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
      36 0.000487
      DESCRIBE `major_city`
      37 0.000417
      DESCRIBE `city_major_city`
      38 0.000337
      SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '734')
      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
      39 0.000307
      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
      40 0.000607
      DESCRIBE `summary_count_school`
      41 0.000417
      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
      42 0.000647
      DESCRIBE `campaign_school`
      43 0.000487
      SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3016028') 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
      44 0.000427
      SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016028') 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
      45 0.000387
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6828') 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.000357
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6827') 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.000367
      SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '1830') LIMIT 1
      id select_type table type possible_keys key key_len ref rows Extra
      1 SIMPLE s const PRIMARY PRIMARY 4 const 1
      48 0.000657
      DESCRIBE `category_school`
      49 0.000537
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016028') 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.000397
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016028') 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.000437
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016028') 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
      52 0.000417
      SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016028') 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
      53 0.000607
      DESCRIBE `dancer`
      54 0.000447
      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
      55 0.000397
      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
      56 0.000467
      DESCRIBE `dancer_column`
      57 0.000437
      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
      58 0.000457
      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
      59 0.000367
      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
      60 0.000367
      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
      61 0.000347
      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 10.46 MB

      Message Memory use
      Component initialization 2.16 MB
      Controller action start 3.96 MB
      Controller render start 4.55 MB
      View render complete 5.57 MB

      Timers

      Total Request Time: 2486 (ms)

      Message Time in ms Graph
      Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 2341.23
      Event: Controller.initialize 47.21
      Event: Controller.startup 0.54
      Controller action 0.16
      Event: Controller.beforeRender 42.85
      » Processing toolbar data 35.96
      Rendering View 28.13
      » Event: View.beforeRender 0.78
      » Rendering APP/View/School/map_and_coupon.ctp 7.10
      » » Rendering APP/View/Elements/school/google_map_place_js.ctp 0.17
      » » Rendering APP/View/Elements/adsense/336_288.ctp 0.07
      » Event: View.afterRender 0.03
      » Event: View.beforeLayout 0.02
      » Rendering APP/View/Layouts/default.ctp 19.33
      » » Rendering APP/View/Elements/header.ctp 0.62
      » » Rendering APP/View/Elements/school/detailHeader.ctp 7.20
      » » » Rendering APP/View/Elements/common/bookmark_school.ctp 0.13
      » » » Rendering APP/View/Elements/breadcrumb.ctp 0.19
      » » Rendering APP/View/Elements/menu.ctp 8.69
      » » » Rendering APP/View/Elements/school/right-menu.ctp 8.49
      » » » » Rendering APP/View/Elements/common/menu_twitter.ctp 0.16
      » » » » Rendering APP/View/Elements/common/menu_danceClip.ctp 0.07
      » » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp 7.47
      » » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp 0.09
      » » » » Rendering APP/View/Elements/adsense/300_250.ctp 0.07
      » » Rendering APP/View/Elements/rtt.ctp 0.16
      » » Rendering APP/View/Elements/footer.ctp 1.00
      » » Rendering APP/View/Elements/common/scoreEx.ctp 0.08
      Event: View.afterLayout 0.00
      ====
    • Log
      +

      Logs

      There were no log entries made this request

      ====
    • Variables
      +

      View Variables

      • breadcrumb(array)
        • 0(array)
          • nameスクール検索
          • link(array)
            • controllerschool_list
            • actionindex
        • 1(array)
          • name東京
          • link(array)
            • controllerschool_list
            • actionindex
            • prefectureId12
        • 2(array)
          • name北区
          • link(array)
            • controllerschool_list
            • actionindex
            • prefectureId12
            • cityId734
        • 3(array)
          • name栄町駅
          • link(array)
            • controllerschool_list
            • actionindex
            • stationId6828
        • 4(array)
          • name藤間綾由貴 綾扇会 王子稽古場
          • link
      • ChargedNeighborSchoolSet(empty)
      • SchoolScoreSet(object)
        • School(object)
          • id3016028
          • name藤間綾由貴 綾扇会
          • branch_name王子稽古場
          • city_id734
          • schoolgroup_id(null)
          • mail_addressayayuki.info@gmail.com
          • lat35.75116143632142
          • lon139.7441465405563
          • telephone_number090-9671-7671
          • homepage_urlhttp://www.fujima-ayayuki.com/
          • mobile_homepage_urlhttp://www.fujima-ayayuki.com/
          • blog_url
          • open_hour毎週水・金　10:00～21:00
          • holiday
          • post_code114-0005
          • town_address栄町48-26
          • building
          • image_hash9bf05e42baa60938
          • image_extension_type2
          • message_image_hashd9be335c758ecab7
          • message_image_extension_type2
          • is_registered_by_not_owner0
          • is_opening1
          • message_title日本舞踊で和の世界にふれてみませんか？
          • message_body日本舞踊で和の世界にふれてみませんか？ 日本舞踊はとっつきにくい、難しそうと思っているあなたにも気軽にレッスンが受けられる教室です。 着物を着ての立居振舞い、日本の伝統芸術・伝統芸能の体験、健康・ダイエットにも役立つ正しい姿勢を作る姿勢矯正など、日本舞踊には素敵な魅力がたくさんあります。 当教室では、藤間流の日本舞踊をお稽古しています。 初心者の方も経験者の方も大歓迎！
          • is_detail_address_opening1
          • is_charged0
          • registration_status1
          • whole_staff_title藤間 綾由貴
          • whole_staff_introduction藤間流師範 日本大学芸術学部演劇学科 日本舞踊コース卒業 (社)日本舞踊協会会員 日本舞踊のお稽古場「綾扇会」主催 伝統文化こども教室「音鼓の会」主催
          • whole_staff_image_hashe4497c197312b443
          • whole_staff_image_extension_type2
          • is_kuchikomi_notice_mail_receiving0
          • banner_image_hash(null)
          • banner_image_extension_type(null)
          • school_type1
          • has_kids_course1
          • has_beginner_course1
          • score0.00
          • kuchikomi_count0
          • timestamp_created2016-05-31 05:29:43
          • timestamp_modified2025-11-02 20:43:06
          • 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_3016028/map_and_coupon
        Query String
        Request Method GET
        Server Protocol HTTP/1.1
        Gateway Interface CGI/1.1
        Redirect Url /detail/L_3016028/map_and_coupon
        Remote Port 50818
        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=606scm16vrf24qelgle6diblcaeigsit
        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 aTJ4pzFqJlfOLzpUUoUMLgAAAZE
        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 aTJ4pzFqJlfOLzpUUoUMLgAAAZE
        Redirect Mef Proxy Addr 183.90.231.12
        Fcgi Role RESPONDER
        Php Self /index.php
        Request Time Float 1764915367.8182
        Request Time 1764915367
        ====
      • 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/ToMajorCityPage.php
            • 6APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.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/SchoolListPageLink/ToCategoryPage.php
            • 12APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
            • 13APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
            • 14APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
            • 15APP/class/Sgv/Front/InputForm/SchoolSearch.php
            • 16APP/class/Sgv/Front/InputItem/SchoolSearch.php
            • 17APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
            • 18APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.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

      ページの先頭へ戻る