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 '%第52回%') AND (`c_block` like '%北%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%B%')) ORDER BY `c_yo_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 '%第52回%') AND (`c_block` like '%北%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%小編成%')) ORDER BY `c_yo_junban` asc | 19 | 19 | 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 '%第52回%') AND (`c_block` like '%北%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%A%')) ORDER BY `c_yo_junban` asc | 14 | 14 | 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 '%第52回%') AND (`c_block` like '%北%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%B%')) ORDER BY `c_yo_junban` asc | 4 | 4 | 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 '%第52回%') AND (`c_block` like '%北%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%小編成%')) ORDER BY `c_yo_junban` asc | 7 | 7 | 5 | 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 '%第52回%') AND (`c_block` like '%北%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%A%')) ORDER BY `c_yo_junban` asc | 6 | 6 | 5 | 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 '%第52回%') AND (`c_block` like '中部') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%B%')) ORDER BY `c_yo_junban` asc | 3 | 3 | 5 | 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 '%第52回%') AND (`c_block` like '中部') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%小編成%')) ORDER BY `c_yo_junban` asc | 8 | 8 | 5 | 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 '%第52回%') AND (`c_block` like '中部') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%A%')) ORDER BY `c_yo_junban` asc | 21 | 21 | 5 | 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 '%第52回%') AND (`c_block` like '%中%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%B%')) ORDER BY `c_yo_junban` asc | 2 | 2 | 5 | 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 '%第52回%') AND (`c_block` like '%中%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%小編成%')) ORDER BY `c_yo_junban` asc | 8 | 8 | 5 | 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 '%第52回%') AND (`c_block` like '%中%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%A%')) ORDER BY `c_yo_junban` asc | 6 | 6 | 4 | 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 '%第52回%') AND (`c_block` like '%南%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%B%')) ORDER BY `c_yo_junban` asc | 3 | 3 | 5 | 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 '%第52回%') AND (`c_block` like '%南%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%小編成%')) ORDER BY `c_yo_junban` asc | 11 | 11 | 4 | 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 '%第52回%') AND (`c_block` like '%南%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%中学%') AND (`c_absyou` like '%A%')) ORDER BY `c_yo_junban` asc | 19 | 19 | 4 | 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 '%第52回%') AND (`c_block` like '%南%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%B%')) ORDER BY `c_yo_junban` asc | 2 | 2 | 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 '%第52回%') AND (`c_block` like '%南%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%小編成%')) ORDER BY `c_yo_junban` asc | 7 | 7 | 4 | 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 '%第52回%') AND (`c_block` like '%南%') AND (`c_yosen` like '%予選%') AND (`c_bumon1` like '%高等学校%') AND (`c_absyou` like '%A%')) ORDER BY `c_yo_junban` asc | 10 | 10 | 4 | maybe slow |