| No. |
time |
query |
| 1 |
0.001907 |
connect
|
| 2 |
0.000667 |
DESCRIBE `school`
|
| 3 |
0.000467 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3016527') 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.000497 |
DESCRIBE `school_score`
|
| 5 |
0.000367 |
SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3016527') 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.000517 |
DESCRIBE `access_log_school`
|
| 7 |
0.000457 |
SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.27') AND (school_id = '3016527') AND (timestamp_created >= '2026-01-27 05:22:29') LIMIT 1
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
access_log_school |
ref |
school_id,ix_ip_address_access_log_school |
school_id |
4 |
const |
13 |
Using where |
|
| 8 |
0.000457 |
DESCRIBE `school_station`
|
| 9 |
0.000357 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016527') 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 |
1 |
|
|
| 10 |
0.001287 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '748') 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 |
168 |
Using where |
|
| 11 |
0.000497 |
DESCRIBE `city`
|
| 12 |
0.000337 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '748') LIMIT 1
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
c |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
|
| 13 |
0.000587 |
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 |
|
|
| 14 |
0.013457 |
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 |
|
|
|
4032 |
Using where |
|
| 15 |
0.000537 |
DESCRIBE `prefecture`
|
| 16 |
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 |
|
|
| 17 |
0.000447 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016527') 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 |
1 |
Using index condition; Using filesort |
|
| 18 |
0.000557 |
DESCRIBE `station_unit`
|
| 19 |
0.000297 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016527')
| 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 |
|
|
| 20 |
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 |
|
| 21 |
0.000457 |
DESCRIBE `major_city`
|
| 22 |
0.000457 |
DESCRIBE `city_major_city`
|
| 23 |
0.000367 |
SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '748')
| 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 |
|
|
| 24 |
0.000317 |
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 |
|
| 25 |
0.000547 |
DESCRIBE `summary_count_school`
|
| 26 |
0.000427 |
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 |
|
|
| 27 |
0.000677 |
DESCRIBE `category_school`
|
| 28 |
0.000437 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016527') AND (c_s.valid = 1)
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
c_s |
ref |
school_id |
school_id |
4 |
const |
4 |
Using where |
|
| 29 |
0.000527 |
DESCRIBE `menu_school`
|
| 30 |
0.000427 |
SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8257') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
m_s |
ref |
ix_category_school_id_menu_school |
ix_category_school_id_menu_school |
4 |
const |
1 |
Using index condition; Using where; Using filesort |
|
| 31 |
0.000387 |
SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8258') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
m_s |
ref |
ix_category_school_id_menu_school |
ix_category_school_id_menu_school |
4 |
const |
1 |
Using index condition; Using where; Using filesort |
|
| 32 |
0.000407 |
SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8259') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
m_s |
ref |
ix_category_school_id_menu_school |
ix_category_school_id_menu_school |
4 |
const |
2 |
Using index condition; Using where; Using filesort |
|
| 33 |
0.000427 |
SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8260') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
m_s |
ref |
ix_category_school_id_menu_school |
ix_category_school_id_menu_school |
4 |
const |
1 |
Using index condition; Using where; Using filesort |
|
| 34 |
0.000437 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016527') 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 |
4 |
Using where |
|
| 35 |
0.000377 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016527') 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 |
4 |
Using where |
|
| 36 |
0.000387 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016527') 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 |
4 |
Using where |
|
| 37 |
0.000357 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016527') 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 |
4 |
Using where |
|
| 38 |
0.000347 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016527') 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 |
1 |
Using index condition; Using filesort |
|
| 39 |
0.000467 |
DESCRIBE `dancer`
|
| 40 |
0.000437 |
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 |
|
| 41 |
0.000367 |
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 |
|
| 42 |
0.000477 |
DESCRIBE `dancer_column`
|
| 43 |
0.000417 |
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 |
|
| 44 |
0.000367 |
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 |
|
| 45 |
0.000347 |
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 |
|
| 46 |
0.000357 |
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 |
|
| 47 |
0.000387 |
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 |
|
振付家として1300本以上の有名CMや楽曲を手掛け、60代後半の今なお現役のアーティストとして活動する香瑠鼓（カオルコ）が、自身のダンステクニックを維持し続ける豊富なスキルによってダンス上達のテクニックを伝授するレッスンです。
振付家として1300本以上の有名CMや楽曲を手掛け、60代後半の今なお現役のアーティストとして活動する香瑠鼓（カオルコ）が、自身のダンステクニックを維持し続ける豊富なスキルによってダンス上達のテクニックを伝授するレッスンです。
香瑠鼓オリジナル「NVメソッド」にもとづく「即興」を中心にした表現ワークショップ。感性を豊かにし、論理性を鍛えるプログラムです。
香瑠鼓のオリジナルメソッド「ネイチャーバイブレーション（NV）」を用いたワークショップ。すべての関節を動かし身体を知る、水の流れる音でリラックスする呼吸などを組み合わせた「動く瞑想」。そうして身体・心・脳がリンクした状態で、自然界をイメージしながら自由に動いたり声を出すことで、あなたの潜在的な創造力を解放します。香瑠鼓の特別なアドバイスによって一人ひとり異なった表現や魅力を引き出すので、ダンス経験や表現のスキルは必要ありません。短時間の初級クラスもあります。 
