Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%中%') AND (`c_absyou` like '%小%')) ORDER BY `c_ken_junban` asc | 14 | 14 | 7 | maybe slow |
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%中%') AND (`c_absyou` like '%A%')) ORDER BY `c_ken_junban` asc | 24 | 24 | 7 | maybe slow |
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%高%') AND (`c_absyou` like '%小%')) ORDER BY `c_ken_junban` asc | 12 | 12 | 6 | maybe slow |
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%高%') AND (`c_absyou` like '%A%')) ORDER BY `c_ken_junban` asc | 11 | 11 | 6 | maybe slow |
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%小%')) ORDER BY `c_ken_junban` asc | 1 | 1 | 6 | maybe slow |
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%大学%')) ORDER BY `c_ken_junban` asc | 3 | 3 | 6 | maybe slow |
SELECT `Con51till60`.`c_id`, `Con51till60`.`c_taikai_name`, `Con51till60`.`c_yo_date`, `Con51till60`.`c_yo_hall`, `Con51till60`.`c_yosen`, `Con51till60`.`c_ken_date`, `Con51till60`.`c_ken_hall`, `Con51till60`.`c_kentaikai`, `Con51till60`.`c_block`, `Con51till60`.`c_bumon1`, `Con51till60`.`c_absyou`, `Con51till60`.`c_yo_junban`, `Con51till60`.`c_ken_junban`, `Con51till60`.`c_name`, `Con51till60`.`c_number`, `Con51till60`.`c_kadaikyoku`, `Con51till60`.`c_jiyukyoku`, `Con51till60`.`c_jiyukyoku2`, `Con51till60`.`c_composer`, `Con51till60`.`c_arranger`, `Con51till60`.`c_conductor`, `Con51till60`.`c_conductor2`, `Con51till60`.`c_prize`, `Con51till60`.`c_prize_pref`, `Con51till60`.`c_prize_kansai`, `Con51till60`.`c_prize_zen`, `Con51till60`.`c_yo_shinsa1`, `Con51till60`.`c_yo_shinsa2`, `Con51till60`.`c_yo_shinsa3`, `Con51till60`.`c_yo_shinsa4`, `Con51till60`.`c_yo_shinsa5`, `Con51till60`.`c_ken_shinsa1`, `Con51till60`.`c_ken_shinsa2`, `Con51till60`.`c_ken_shinsa3`, `Con51till60`.`c_ken_shinsa4`, `Con51till60`.`c_ken_shinsa5`, `Con51till60`.`c_ken_shinsa6`, `Con51till60`.`c_ken_shinsa7` FROM `sigasuiren_data`.`contests` AS `Con51till60` WHERE ((`c_taikai_name` like '%第51回%') AND (`c_kentaikai` like '%県大会%') AND (`c_bumon1` like '%一般%')) ORDER BY `c_ken_junban` asc | 10 | 10 | 6 | maybe slow |