| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `OperationSetting`.`id`, `OperationSetting`.`code`, `OperationSetting`.`controller`, `OperationSetting`.`value`, `OperationSetting`.`created_user`, `OperationSetting`.`created`, `OperationSetting`.`modified_user`, `OperationSetting`.`modified`, `OperationSetting`.`delete_flg` FROM `nhk_sumo`.`operation_settings` AS `OperationSetting` WHERE `OperationSetting`.`delete_flg` = '0' | 167 | 167 | 1 | |
| SELECT max(nendo_place_date) as code_max FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `Effort`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 19 | maybe slow |
| SELECT `ReplaceWord`.`id`, `ReplaceWord`.`replace_div`, `ReplaceWord`.`before_name`, `ReplaceWord`.`after_name`, `ReplaceWord`.`label_div`, `ReplaceWord`.`memo`, `ReplaceWord`.`created_user`, `ReplaceWord`.`created`, `ReplaceWord`.`modified_user`, `ReplaceWord`.`modified`, `ReplaceWord`.`delete_flg` FROM `nhk_sumo`.`replace_words` AS `ReplaceWord` WHERE `ReplaceWord`.`delete_flg` = '0' | 268 | 268 | 1 | |
| SELECT min(nendo_place_date) as code_max FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `confirm_div` = 1 AND `Effort`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT max(nendo_place_date) as code_max FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `Effort`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 19 | maybe slow |
| SELECT `NendoPlace`.`id`, `NendoPlace`.`code`, `NendoPlace`.`nendo`, `NendoPlace`.`place`, `NendoPlace`.`event_start_date`, `NendoPlace`.`event_end_date`, `NendoPlace`.`pc_image`, `NendoPlace`.`sp_image`, `NendoPlace`.`alt`, `NendoPlace`.`change_date`, `NendoPlace`.`label_div`, `NendoPlace`.`memo`, `NendoPlace`.`created_user`, `NendoPlace`.`created`, `NendoPlace`.`modified_user`, `NendoPlace`.`modified`, `NendoPlace`.`delete_flg`, `NendoPlace`.`url_day1`, `NendoPlace`.`url_day2`, `NendoPlace`.`url_day3`, `NendoPlace`.`url_day4`, `NendoPlace`.`url_day5`, `NendoPlace`.`url_day6`, `NendoPlace`.`url_day7`, `NendoPlace`.`url_day8`, `NendoPlace`.`url_day9`, `NendoPlace`.`url_day10`, `NendoPlace`.`url_day11`, `NendoPlace`.`url_day12`, `NendoPlace`.`url_day13`, `NendoPlace`.`url_day14`, `NendoPlace`.`url_day15`, `NendoPlace`.`finished_code` FROM `nhk_sumo`.`nendo_places` AS `NendoPlace` WHERE `nendo` = 2021 AND `place` = '春場所' AND `NendoPlace`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Effort`.`id`, `Effort`.`effort_code`, `Effort`.`nendo_place_date`, `Effort`.`kind_div`, `Effort`.`effort_date`, `Effort`.`confirm_div`, `Effort`.`e_wrestler_id`, `Effort`.`e_wrestler_data_id`, `Effort`.`e_win_div`, `Effort`.`w_wrestler_id`, `Effort`.`w_wrestler_data_id`, `Effort`.`w_win_div`, `Effort`.`winning_trick`, `Effort`.`movie_div`, `Effort`.`movie_info`, `Effort`.`thumbnail`, `Effort`.`thumbnail_created`, `Effort`.`movie_title`, `Effort`.`posted_date`, `Effort`.`priority_flg`, `Effort`.`prod_up_flg`, `Effort`.`label_div`, `Effort`.`memo`, `Effort`.`created_user`, `Effort`.`created`, `Effort`.`modified_user`, `Effort`.`modified`, `Effort`.`delete_flg`, `Effort`.`tags`, `EWrestler`.`id`, `EWrestler`.`code`, `EWrestler`.`nendo_place`, `EWrestler`.`name`, `EWrestler`.`kind_div`, `EWrestler`.`direction_div`, `EWrestler`.`rank`, `EWrestler`.`win`, `EWrestler`.`lose`, `EWrestler`.`rest`, `EWrestler`.`win00`, `EWrestler`.`lose00`, `EWrestler`.`rest00`, `EWrestler`.`win01`, `EWrestler`.`lose01`, `EWrestler`.`rest01`, `EWrestler`.`win02`, `EWrestler`.`lose02`, `EWrestler`.`rest02`, `EWrestler`.`win03`, `EWrestler`.`lose03`, `EWrestler`.`rest03`, `EWrestler`.`win04`, `EWrestler`.`lose04`, `EWrestler`.`rest04`, `EWrestler`.`win05`, `EWrestler`.`lose05`, `EWrestler`.`rest05`, `EWrestler`.`win06`, `EWrestler`.`lose06`, `EWrestler`.`rest06`, `EWrestler`.`win07`, `EWrestler`.`lose07`, `EWrestler`.`rest07`, `EWrestler`.`win08`, `EWrestler`.`lose08`, `EWrestler`.`rest08`, `EWrestler`.`win09`, `EWrestler`.`lose09`, `EWrestler`.`rest09`, `EWrestler`.`win10`, `EWrestler`.`lose10`, `EWrestler`.`rest10`, `EWrestler`.`win11`, `EWrestler`.`lose11`, `EWrestler`.`rest11`, `EWrestler`.`win12`, `EWrestler`.`lose12`, `EWrestler`.`rest12`, `EWrestler`.`win13`, `EWrestler`.`lose13`, `EWrestler`.`rest13`, `EWrestler`.`win14`, `EWrestler`.`lose14`, `EWrestler`.`rest14`, `EWrestler`.`win15`, `EWrestler`.`lose15`, `EWrestler`.`rest15`, `EWrestler`.`image`, `EWrestler`.`image_name`, `EWrestler`.`image_all`, `EWrestler`.`image_movie`, `EWrestler`.`display_order`, `EWrestler`.`label_div`, `EWrestler`.`memo`, `EWrestler`.`created_user`, `EWrestler`.`created`, `EWrestler`.`modified_user`, `EWrestler`.`modified`, `EWrestler`.`delete_flg`, `WWrestler`.`id`, `WWrestler`.`code`, `WWrestler`.`nendo_place`, `WWrestler`.`name`, `WWrestler`.`kind_div`, `WWrestler`.`direction_div`, `WWrestler`.`rank`, `WWrestler`.`win`, `WWrestler`.`lose`, `WWrestler`.`rest`, `WWrestler`.`win00`, `WWrestler`.`lose00`, `WWrestler`.`rest00`, `WWrestler`.`win01`, `WWrestler`.`lose01`, `WWrestler`.`rest01`, `WWrestler`.`win02`, `WWrestler`.`lose02`, `WWrestler`.`rest02`, `WWrestler`.`win03`, `WWrestler`.`lose03`, `WWrestler`.`rest03`, `WWrestler`.`win04`, `WWrestler`.`lose04`, `WWrestler`.`rest04`, `WWrestler`.`win05`, `WWrestler`.`lose05`, `WWrestler`.`rest05`, `WWrestler`.`win06`, `WWrestler`.`lose06`, `WWrestler`.`rest06`, `WWrestler`.`win07`, `WWrestler`.`lose07`, `WWrestler`.`rest07`, `WWrestler`.`win08`, `WWrestler`.`lose08`, `WWrestler`.`rest08`, `WWrestler`.`win09`, `WWrestler`.`lose09`, `WWrestler`.`rest09`, `WWrestler`.`win10`, `WWrestler`.`lose10`, `WWrestler`.`rest10`, `WWrestler`.`win11`, `WWrestler`.`lose11`, `WWrestler`.`rest11`, `WWrestler`.`win12`, `WWrestler`.`lose12`, `WWrestler`.`rest12`, `WWrestler`.`win13`, `WWrestler`.`lose13`, `WWrestler`.`rest13`, `WWrestler`.`win14`, `WWrestler`.`lose14`, `WWrestler`.`rest14`, `WWrestler`.`win15`, `WWrestler`.`lose15`, `WWrestler`.`rest15`, `WWrestler`.`image`, `WWrestler`.`image_name`, `WWrestler`.`image_all`, `WWrestler`.`image_movie`, `WWrestler`.`display_order`, `WWrestler`.`label_div`, `WWrestler`.`memo`, `WWrestler`.`created_user`, `WWrestler`.`created`, `WWrestler`.`modified_user`, `WWrestler`.`modified`, `WWrestler`.`delete_flg` FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `Effort`.`kind_div` IN (1, 3) AND `Effort`.`nendo_place_date` = 2021215 AND `Effort`.`delete_flg` = '0' ORDER BY `Effort`.`effort_code` ASC | 19 | 19 | 4 | maybe slow |
| SELECT `Effort`.`id`, `Effort`.`effort_code`, `Effort`.`nendo_place_date`, `Effort`.`kind_div`, `Effort`.`effort_date`, `Effort`.`confirm_div`, `Effort`.`e_wrestler_id`, `Effort`.`e_wrestler_data_id`, `Effort`.`e_win_div`, `Effort`.`w_wrestler_id`, `Effort`.`w_wrestler_data_id`, `Effort`.`w_win_div`, `Effort`.`winning_trick`, `Effort`.`movie_div`, `Effort`.`movie_info`, `Effort`.`thumbnail`, `Effort`.`thumbnail_created`, `Effort`.`movie_title`, `Effort`.`posted_date`, `Effort`.`priority_flg`, `Effort`.`prod_up_flg`, `Effort`.`label_div`, `Effort`.`memo`, `Effort`.`created_user`, `Effort`.`created`, `Effort`.`modified_user`, `Effort`.`modified`, `Effort`.`delete_flg`, `Effort`.`tags`, `EWrestler`.`id`, `EWrestler`.`code`, `EWrestler`.`nendo_place`, `EWrestler`.`name`, `EWrestler`.`kind_div`, `EWrestler`.`direction_div`, `EWrestler`.`rank`, `EWrestler`.`win`, `EWrestler`.`lose`, `EWrestler`.`rest`, `EWrestler`.`win00`, `EWrestler`.`lose00`, `EWrestler`.`rest00`, `EWrestler`.`win01`, `EWrestler`.`lose01`, `EWrestler`.`rest01`, `EWrestler`.`win02`, `EWrestler`.`lose02`, `EWrestler`.`rest02`, `EWrestler`.`win03`, `EWrestler`.`lose03`, `EWrestler`.`rest03`, `EWrestler`.`win04`, `EWrestler`.`lose04`, `EWrestler`.`rest04`, `EWrestler`.`win05`, `EWrestler`.`lose05`, `EWrestler`.`rest05`, `EWrestler`.`win06`, `EWrestler`.`lose06`, `EWrestler`.`rest06`, `EWrestler`.`win07`, `EWrestler`.`lose07`, `EWrestler`.`rest07`, `EWrestler`.`win08`, `EWrestler`.`lose08`, `EWrestler`.`rest08`, `EWrestler`.`win09`, `EWrestler`.`lose09`, `EWrestler`.`rest09`, `EWrestler`.`win10`, `EWrestler`.`lose10`, `EWrestler`.`rest10`, `EWrestler`.`win11`, `EWrestler`.`lose11`, `EWrestler`.`rest11`, `EWrestler`.`win12`, `EWrestler`.`lose12`, `EWrestler`.`rest12`, `EWrestler`.`win13`, `EWrestler`.`lose13`, `EWrestler`.`rest13`, `EWrestler`.`win14`, `EWrestler`.`lose14`, `EWrestler`.`rest14`, `EWrestler`.`win15`, `EWrestler`.`lose15`, `EWrestler`.`rest15`, `EWrestler`.`image`, `EWrestler`.`image_name`, `EWrestler`.`image_all`, `EWrestler`.`image_movie`, `EWrestler`.`display_order`, `EWrestler`.`label_div`, `EWrestler`.`memo`, `EWrestler`.`created_user`, `EWrestler`.`created`, `EWrestler`.`modified_user`, `EWrestler`.`modified`, `EWrestler`.`delete_flg`, `WWrestler`.`id`, `WWrestler`.`code`, `WWrestler`.`nendo_place`, `WWrestler`.`name`, `WWrestler`.`kind_div`, `WWrestler`.`direction_div`, `WWrestler`.`rank`, `WWrestler`.`win`, `WWrestler`.`lose`, `WWrestler`.`rest`, `WWrestler`.`win00`, `WWrestler`.`lose00`, `WWrestler`.`rest00`, `WWrestler`.`win01`, `WWrestler`.`lose01`, `WWrestler`.`rest01`, `WWrestler`.`win02`, `WWrestler`.`lose02`, `WWrestler`.`rest02`, `WWrestler`.`win03`, `WWrestler`.`lose03`, `WWrestler`.`rest03`, `WWrestler`.`win04`, `WWrestler`.`lose04`, `WWrestler`.`rest04`, `WWrestler`.`win05`, `WWrestler`.`lose05`, `WWrestler`.`rest05`, `WWrestler`.`win06`, `WWrestler`.`lose06`, `WWrestler`.`rest06`, `WWrestler`.`win07`, `WWrestler`.`lose07`, `WWrestler`.`rest07`, `WWrestler`.`win08`, `WWrestler`.`lose08`, `WWrestler`.`rest08`, `WWrestler`.`win09`, `WWrestler`.`lose09`, `WWrestler`.`rest09`, `WWrestler`.`win10`, `WWrestler`.`lose10`, `WWrestler`.`rest10`, `WWrestler`.`win11`, `WWrestler`.`lose11`, `WWrestler`.`rest11`, `WWrestler`.`win12`, `WWrestler`.`lose12`, `WWrestler`.`rest12`, `WWrestler`.`win13`, `WWrestler`.`lose13`, `WWrestler`.`rest13`, `WWrestler`.`win14`, `WWrestler`.`lose14`, `WWrestler`.`rest14`, `WWrestler`.`win15`, `WWrestler`.`lose15`, `WWrestler`.`rest15`, `WWrestler`.`image`, `WWrestler`.`image_name`, `WWrestler`.`image_all`, `WWrestler`.`image_movie`, `WWrestler`.`display_order`, `WWrestler`.`label_div`, `WWrestler`.`memo`, `WWrestler`.`created_user`, `WWrestler`.`created`, `WWrestler`.`modified_user`, `WWrestler`.`modified`, `WWrestler`.`delete_flg` FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `Effort`.`posted_date` IS NOT NULL AND `Effort`.`movie_info` <> '' AND `Effort`.`thumbnail` LIKE 'http%' AND `Effort`.`prod_up_flg` = '1' AND `Effort`.`delete_flg` = '0' ORDER BY `Effort`.`posted_date` desc LIMIT 9 | 9 | 9 | 4 | maybe slow |
| SELECT `Effort`.`id`, `Effort`.`effort_code`, `Effort`.`nendo_place_date`, `Effort`.`kind_div`, `Effort`.`effort_date`, `Effort`.`confirm_div`, `Effort`.`e_wrestler_id`, `Effort`.`e_wrestler_data_id`, `Effort`.`e_win_div`, `Effort`.`w_wrestler_id`, `Effort`.`w_wrestler_data_id`, `Effort`.`w_win_div`, `Effort`.`winning_trick`, `Effort`.`movie_div`, `Effort`.`movie_info`, `Effort`.`thumbnail`, `Effort`.`thumbnail_created`, `Effort`.`movie_title`, `Effort`.`posted_date`, `Effort`.`priority_flg`, `Effort`.`prod_up_flg`, `Effort`.`label_div`, `Effort`.`memo`, `Effort`.`created_user`, `Effort`.`created`, `Effort`.`modified_user`, `Effort`.`modified`, `Effort`.`delete_flg`, `Effort`.`tags`, `EWrestler`.`id`, `EWrestler`.`code`, `EWrestler`.`nendo_place`, `EWrestler`.`name`, `EWrestler`.`kind_div`, `EWrestler`.`direction_div`, `EWrestler`.`rank`, `EWrestler`.`win`, `EWrestler`.`lose`, `EWrestler`.`rest`, `EWrestler`.`win00`, `EWrestler`.`lose00`, `EWrestler`.`rest00`, `EWrestler`.`win01`, `EWrestler`.`lose01`, `EWrestler`.`rest01`, `EWrestler`.`win02`, `EWrestler`.`lose02`, `EWrestler`.`rest02`, `EWrestler`.`win03`, `EWrestler`.`lose03`, `EWrestler`.`rest03`, `EWrestler`.`win04`, `EWrestler`.`lose04`, `EWrestler`.`rest04`, `EWrestler`.`win05`, `EWrestler`.`lose05`, `EWrestler`.`rest05`, `EWrestler`.`win06`, `EWrestler`.`lose06`, `EWrestler`.`rest06`, `EWrestler`.`win07`, `EWrestler`.`lose07`, `EWrestler`.`rest07`, `EWrestler`.`win08`, `EWrestler`.`lose08`, `EWrestler`.`rest08`, `EWrestler`.`win09`, `EWrestler`.`lose09`, `EWrestler`.`rest09`, `EWrestler`.`win10`, `EWrestler`.`lose10`, `EWrestler`.`rest10`, `EWrestler`.`win11`, `EWrestler`.`lose11`, `EWrestler`.`rest11`, `EWrestler`.`win12`, `EWrestler`.`lose12`, `EWrestler`.`rest12`, `EWrestler`.`win13`, `EWrestler`.`lose13`, `EWrestler`.`rest13`, `EWrestler`.`win14`, `EWrestler`.`lose14`, `EWrestler`.`rest14`, `EWrestler`.`win15`, `EWrestler`.`lose15`, `EWrestler`.`rest15`, `EWrestler`.`image`, `EWrestler`.`image_name`, `EWrestler`.`image_all`, `EWrestler`.`image_movie`, `EWrestler`.`display_order`, `EWrestler`.`label_div`, `EWrestler`.`memo`, `EWrestler`.`created_user`, `EWrestler`.`created`, `EWrestler`.`modified_user`, `EWrestler`.`modified`, `EWrestler`.`delete_flg`, `WWrestler`.`id`, `WWrestler`.`code`, `WWrestler`.`nendo_place`, `WWrestler`.`name`, `WWrestler`.`kind_div`, `WWrestler`.`direction_div`, `WWrestler`.`rank`, `WWrestler`.`win`, `WWrestler`.`lose`, `WWrestler`.`rest`, `WWrestler`.`win00`, `WWrestler`.`lose00`, `WWrestler`.`rest00`, `WWrestler`.`win01`, `WWrestler`.`lose01`, `WWrestler`.`rest01`, `WWrestler`.`win02`, `WWrestler`.`lose02`, `WWrestler`.`rest02`, `WWrestler`.`win03`, `WWrestler`.`lose03`, `WWrestler`.`rest03`, `WWrestler`.`win04`, `WWrestler`.`lose04`, `WWrestler`.`rest04`, `WWrestler`.`win05`, `WWrestler`.`lose05`, `WWrestler`.`rest05`, `WWrestler`.`win06`, `WWrestler`.`lose06`, `WWrestler`.`rest06`, `WWrestler`.`win07`, `WWrestler`.`lose07`, `WWrestler`.`rest07`, `WWrestler`.`win08`, `WWrestler`.`lose08`, `WWrestler`.`rest08`, `WWrestler`.`win09`, `WWrestler`.`lose09`, `WWrestler`.`rest09`, `WWrestler`.`win10`, `WWrestler`.`lose10`, `WWrestler`.`rest10`, `WWrestler`.`win11`, `WWrestler`.`lose11`, `WWrestler`.`rest11`, `WWrestler`.`win12`, `WWrestler`.`lose12`, `WWrestler`.`rest12`, `WWrestler`.`win13`, `WWrestler`.`lose13`, `WWrestler`.`rest13`, `WWrestler`.`win14`, `WWrestler`.`lose14`, `WWrestler`.`rest14`, `WWrestler`.`win15`, `WWrestler`.`lose15`, `WWrestler`.`rest15`, `WWrestler`.`image`, `WWrestler`.`image_name`, `WWrestler`.`image_all`, `WWrestler`.`image_movie`, `WWrestler`.`display_order`, `WWrestler`.`label_div`, `WWrestler`.`memo`, `WWrestler`.`created_user`, `WWrestler`.`created`, `WWrestler`.`modified_user`, `WWrestler`.`modified`, `WWrestler`.`delete_flg` FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `Effort`.`posted_date` IS NOT NULL AND `Effort`.`movie_info` <> '' AND `Effort`.`thumbnail` LIKE 'http%' AND `Effort`.`prod_up_flg` = '1' AND ((`Effort`.`movie_div` = 2) OR (((`Effort`.`movie_div` = 1) AND (`Effort`.`priority_flg` = '1')))) AND `Effort`.`delete_flg` = '0' ORDER BY `Effort`.`priority_flg` desc, `Effort`.`posted_date` desc LIMIT 9 | 9 | 9 | 4 | maybe slow |
| SELECT `Effort`.`id`, `Effort`.`effort_code`, `Effort`.`nendo_place_date`, `Effort`.`kind_div`, `Effort`.`effort_date`, `Effort`.`confirm_div`, `Effort`.`e_wrestler_id`, `Effort`.`e_wrestler_data_id`, `Effort`.`e_win_div`, `Effort`.`w_wrestler_id`, `Effort`.`w_wrestler_data_id`, `Effort`.`w_win_div`, `Effort`.`winning_trick`, `Effort`.`movie_div`, `Effort`.`movie_info`, `Effort`.`thumbnail`, `Effort`.`thumbnail_created`, `Effort`.`movie_title`, `Effort`.`posted_date`, `Effort`.`priority_flg`, `Effort`.`prod_up_flg`, `Effort`.`label_div`, `Effort`.`memo`, `Effort`.`created_user`, `Effort`.`created`, `Effort`.`modified_user`, `Effort`.`modified`, `Effort`.`delete_flg`, `Effort`.`tags`, `EWrestler`.`id`, `EWrestler`.`code`, `EWrestler`.`nendo_place`, `EWrestler`.`name`, `EWrestler`.`kind_div`, `EWrestler`.`direction_div`, `EWrestler`.`rank`, `EWrestler`.`win`, `EWrestler`.`lose`, `EWrestler`.`rest`, `EWrestler`.`win00`, `EWrestler`.`lose00`, `EWrestler`.`rest00`, `EWrestler`.`win01`, `EWrestler`.`lose01`, `EWrestler`.`rest01`, `EWrestler`.`win02`, `EWrestler`.`lose02`, `EWrestler`.`rest02`, `EWrestler`.`win03`, `EWrestler`.`lose03`, `EWrestler`.`rest03`, `EWrestler`.`win04`, `EWrestler`.`lose04`, `EWrestler`.`rest04`, `EWrestler`.`win05`, `EWrestler`.`lose05`, `EWrestler`.`rest05`, `EWrestler`.`win06`, `EWrestler`.`lose06`, `EWrestler`.`rest06`, `EWrestler`.`win07`, `EWrestler`.`lose07`, `EWrestler`.`rest07`, `EWrestler`.`win08`, `EWrestler`.`lose08`, `EWrestler`.`rest08`, `EWrestler`.`win09`, `EWrestler`.`lose09`, `EWrestler`.`rest09`, `EWrestler`.`win10`, `EWrestler`.`lose10`, `EWrestler`.`rest10`, `EWrestler`.`win11`, `EWrestler`.`lose11`, `EWrestler`.`rest11`, `EWrestler`.`win12`, `EWrestler`.`lose12`, `EWrestler`.`rest12`, `EWrestler`.`win13`, `EWrestler`.`lose13`, `EWrestler`.`rest13`, `EWrestler`.`win14`, `EWrestler`.`lose14`, `EWrestler`.`rest14`, `EWrestler`.`win15`, `EWrestler`.`lose15`, `EWrestler`.`rest15`, `EWrestler`.`image`, `EWrestler`.`image_name`, `EWrestler`.`image_all`, `EWrestler`.`image_movie`, `EWrestler`.`display_order`, `EWrestler`.`label_div`, `EWrestler`.`memo`, `EWrestler`.`created_user`, `EWrestler`.`created`, `EWrestler`.`modified_user`, `EWrestler`.`modified`, `EWrestler`.`delete_flg`, `WWrestler`.`id`, `WWrestler`.`code`, `WWrestler`.`nendo_place`, `WWrestler`.`name`, `WWrestler`.`kind_div`, `WWrestler`.`direction_div`, `WWrestler`.`rank`, `WWrestler`.`win`, `WWrestler`.`lose`, `WWrestler`.`rest`, `WWrestler`.`win00`, `WWrestler`.`lose00`, `WWrestler`.`rest00`, `WWrestler`.`win01`, `WWrestler`.`lose01`, `WWrestler`.`rest01`, `WWrestler`.`win02`, `WWrestler`.`lose02`, `WWrestler`.`rest02`, `WWrestler`.`win03`, `WWrestler`.`lose03`, `WWrestler`.`rest03`, `WWrestler`.`win04`, `WWrestler`.`lose04`, `WWrestler`.`rest04`, `WWrestler`.`win05`, `WWrestler`.`lose05`, `WWrestler`.`rest05`, `WWrestler`.`win06`, `WWrestler`.`lose06`, `WWrestler`.`rest06`, `WWrestler`.`win07`, `WWrestler`.`lose07`, `WWrestler`.`rest07`, `WWrestler`.`win08`, `WWrestler`.`lose08`, `WWrestler`.`rest08`, `WWrestler`.`win09`, `WWrestler`.`lose09`, `WWrestler`.`rest09`, `WWrestler`.`win10`, `WWrestler`.`lose10`, `WWrestler`.`rest10`, `WWrestler`.`win11`, `WWrestler`.`lose11`, `WWrestler`.`rest11`, `WWrestler`.`win12`, `WWrestler`.`lose12`, `WWrestler`.`rest12`, `WWrestler`.`win13`, `WWrestler`.`lose13`, `WWrestler`.`rest13`, `WWrestler`.`win14`, `WWrestler`.`lose14`, `WWrestler`.`rest14`, `WWrestler`.`win15`, `WWrestler`.`lose15`, `WWrestler`.`rest15`, `WWrestler`.`image`, `WWrestler`.`image_name`, `WWrestler`.`image_all`, `WWrestler`.`image_movie`, `WWrestler`.`display_order`, `WWrestler`.`label_div`, `WWrestler`.`memo`, `WWrestler`.`created_user`, `WWrestler`.`created`, `WWrestler`.`modified_user`, `WWrestler`.`modified`, `WWrestler`.`delete_flg` FROM `nhk_sumo`.`efforts` AS `Effort` LEFT JOIN `nhk_sumo`.`wrestlers` AS `EWrestler` ON (`Effort`.`e_wrestler_id` = `EWrestler`.`id`) LEFT JOIN `nhk_sumo`.`wrestlers` AS `WWrestler` ON (`Effort`.`w_wrestler_id` = `WWrestler`.`id`) WHERE `Effort`.`kind_div` = (1) AND `Effort`.`nendo_place_date` = 2021215 AND `Effort`.`delete_flg` = '0' ORDER BY `Effort`.`effort_code` ASC | 19 | 19 | 4 | maybe slow |
| SELECT `CompetitionResult`.`id`, `CompetitionResult`.`nendo_place_date`, `CompetitionResult`.`code`, `CompetitionResult`.`wrestler_id`, `CompetitionResult`.`wrestler_name`, `CompetitionResult`.`standing_class`, `CompetitionResult`.`standing_scope`, `CompetitionResult`.`award_kind`, `CompetitionResult`.`award_count`, `CompetitionResult`.`award_outcome`, `CompetitionResult`.`display_order`, `CompetitionResult`.`created_user`, `CompetitionResult`.`created`, `CompetitionResult`.`modified_user`, `CompetitionResult`.`modified`, `CompetitionResult`.`delete_flg`, `Wrestler`.`id`, `Wrestler`.`code`, `Wrestler`.`nendo_place`, `Wrestler`.`name`, `Wrestler`.`kind_div`, `Wrestler`.`direction_div`, `Wrestler`.`rank`, `Wrestler`.`win`, `Wrestler`.`lose`, `Wrestler`.`rest`, `Wrestler`.`win00`, `Wrestler`.`lose00`, `Wrestler`.`rest00`, `Wrestler`.`win01`, `Wrestler`.`lose01`, `Wrestler`.`rest01`, `Wrestler`.`win02`, `Wrestler`.`lose02`, `Wrestler`.`rest02`, `Wrestler`.`win03`, `Wrestler`.`lose03`, `Wrestler`.`rest03`, `Wrestler`.`win04`, `Wrestler`.`lose04`, `Wrestler`.`rest04`, `Wrestler`.`win05`, `Wrestler`.`lose05`, `Wrestler`.`rest05`, `Wrestler`.`win06`, `Wrestler`.`lose06`, `Wrestler`.`rest06`, `Wrestler`.`win07`, `Wrestler`.`lose07`, `Wrestler`.`rest07`, `Wrestler`.`win08`, `Wrestler`.`lose08`, `Wrestler`.`rest08`, `Wrestler`.`win09`, `Wrestler`.`lose09`, `Wrestler`.`rest09`, `Wrestler`.`win10`, `Wrestler`.`lose10`, `Wrestler`.`rest10`, `Wrestler`.`win11`, `Wrestler`.`lose11`, `Wrestler`.`rest11`, `Wrestler`.`win12`, `Wrestler`.`lose12`, `Wrestler`.`rest12`, `Wrestler`.`win13`, `Wrestler`.`lose13`, `Wrestler`.`rest13`, `Wrestler`.`win14`, `Wrestler`.`lose14`, `Wrestler`.`rest14`, `Wrestler`.`win15`, `Wrestler`.`lose15`, `Wrestler`.`rest15`, `Wrestler`.`image`, `Wrestler`.`image_name`, `Wrestler`.`image_all`, `Wrestler`.`image_movie`, `Wrestler`.`display_order`, `Wrestler`.`label_div`, `Wrestler`.`memo`, `Wrestler`.`created_user`, `Wrestler`.`created`, `Wrestler`.`modified_user`, `Wrestler`.`modified`, `Wrestler`.`delete_flg` FROM `nhk_sumo`.`competition_results` AS `CompetitionResult` LEFT JOIN `nhk_sumo`.`wrestlers` AS `Wrestler` ON (`CompetitionResult`.`wrestler_id` = `Wrestler`.`id`) WHERE `CompetitionResult`.`nendo_place_date` = '2021215' AND `CompetitionResult`.`code` = 'OS17MU__YS' AND `CompetitionResult`.`delete_flg` = '0' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `CompetitionResult`.`id`, `CompetitionResult`.`nendo_place_date`, `CompetitionResult`.`code`, `CompetitionResult`.`wrestler_id`, `CompetitionResult`.`wrestler_name`, `CompetitionResult`.`standing_class`, `CompetitionResult`.`standing_scope`, `CompetitionResult`.`award_kind`, `CompetitionResult`.`award_count`, `CompetitionResult`.`award_outcome`, `CompetitionResult`.`display_order`, `CompetitionResult`.`created_user`, `CompetitionResult`.`created`, `CompetitionResult`.`modified_user`, `CompetitionResult`.`modified`, `CompetitionResult`.`delete_flg`, `Wrestler`.`id`, `Wrestler`.`code`, `Wrestler`.`nendo_place`, `Wrestler`.`name`, `Wrestler`.`kind_div`, `Wrestler`.`direction_div`, `Wrestler`.`rank`, `Wrestler`.`win`, `Wrestler`.`lose`, `Wrestler`.`rest`, `Wrestler`.`win00`, `Wrestler`.`lose00`, `Wrestler`.`rest00`, `Wrestler`.`win01`, `Wrestler`.`lose01`, `Wrestler`.`rest01`, `Wrestler`.`win02`, `Wrestler`.`lose02`, `Wrestler`.`rest02`, `Wrestler`.`win03`, `Wrestler`.`lose03`, `Wrestler`.`rest03`, `Wrestler`.`win04`, `Wrestler`.`lose04`, `Wrestler`.`rest04`, `Wrestler`.`win05`, `Wrestler`.`lose05`, `Wrestler`.`rest05`, `Wrestler`.`win06`, `Wrestler`.`lose06`, `Wrestler`.`rest06`, `Wrestler`.`win07`, `Wrestler`.`lose07`, `Wrestler`.`rest07`, `Wrestler`.`win08`, `Wrestler`.`lose08`, `Wrestler`.`rest08`, `Wrestler`.`win09`, `Wrestler`.`lose09`, `Wrestler`.`rest09`, `Wrestler`.`win10`, `Wrestler`.`lose10`, `Wrestler`.`rest10`, `Wrestler`.`win11`, `Wrestler`.`lose11`, `Wrestler`.`rest11`, `Wrestler`.`win12`, `Wrestler`.`lose12`, `Wrestler`.`rest12`, `Wrestler`.`win13`, `Wrestler`.`lose13`, `Wrestler`.`rest13`, `Wrestler`.`win14`, `Wrestler`.`lose14`, `Wrestler`.`rest14`, `Wrestler`.`win15`, `Wrestler`.`lose15`, `Wrestler`.`rest15`, `Wrestler`.`image`, `Wrestler`.`image_name`, `Wrestler`.`image_all`, `Wrestler`.`image_movie`, `Wrestler`.`display_order`, `Wrestler`.`label_div`, `Wrestler`.`memo`, `Wrestler`.`created_user`, `Wrestler`.`created`, `Wrestler`.`modified_user`, `Wrestler`.`modified`, `Wrestler`.`delete_flg` FROM `nhk_sumo`.`competition_results` AS `CompetitionResult` LEFT JOIN `nhk_sumo`.`wrestlers` AS `Wrestler` ON (`CompetitionResult`.`wrestler_id` = `Wrestler`.`id`) WHERE `CompetitionResult`.`nendo_place_date` = '2021215' AND `CompetitionResult`.`code` = 'OS17MU__SK' AND `CompetitionResult`.`delete_flg` = '0' | 1 | 1 | 0 | |
| SELECT `CompetitionResult`.`id`, `CompetitionResult`.`nendo_place_date`, `CompetitionResult`.`code`, `CompetitionResult`.`wrestler_id`, `CompetitionResult`.`wrestler_name`, `CompetitionResult`.`standing_class`, `CompetitionResult`.`standing_scope`, `CompetitionResult`.`award_kind`, `CompetitionResult`.`award_count`, `CompetitionResult`.`award_outcome`, `CompetitionResult`.`display_order`, `CompetitionResult`.`created_user`, `CompetitionResult`.`created`, `CompetitionResult`.`modified_user`, `CompetitionResult`.`modified`, `CompetitionResult`.`delete_flg`, `Wrestler`.`id`, `Wrestler`.`code`, `Wrestler`.`nendo_place`, `Wrestler`.`name`, `Wrestler`.`kind_div`, `Wrestler`.`direction_div`, `Wrestler`.`rank`, `Wrestler`.`win`, `Wrestler`.`lose`, `Wrestler`.`rest`, `Wrestler`.`win00`, `Wrestler`.`lose00`, `Wrestler`.`rest00`, `Wrestler`.`win01`, `Wrestler`.`lose01`, `Wrestler`.`rest01`, `Wrestler`.`win02`, `Wrestler`.`lose02`, `Wrestler`.`rest02`, `Wrestler`.`win03`, `Wrestler`.`lose03`, `Wrestler`.`rest03`, `Wrestler`.`win04`, `Wrestler`.`lose04`, `Wrestler`.`rest04`, `Wrestler`.`win05`, `Wrestler`.`lose05`, `Wrestler`.`rest05`, `Wrestler`.`win06`, `Wrestler`.`lose06`, `Wrestler`.`rest06`, `Wrestler`.`win07`, `Wrestler`.`lose07`, `Wrestler`.`rest07`, `Wrestler`.`win08`, `Wrestler`.`lose08`, `Wrestler`.`rest08`, `Wrestler`.`win09`, `Wrestler`.`lose09`, `Wrestler`.`rest09`, `Wrestler`.`win10`, `Wrestler`.`lose10`, `Wrestler`.`rest10`, `Wrestler`.`win11`, `Wrestler`.`lose11`, `Wrestler`.`rest11`, `Wrestler`.`win12`, `Wrestler`.`lose12`, `Wrestler`.`rest12`, `Wrestler`.`win13`, `Wrestler`.`lose13`, `Wrestler`.`rest13`, `Wrestler`.`win14`, `Wrestler`.`lose14`, `Wrestler`.`rest14`, `Wrestler`.`win15`, `Wrestler`.`lose15`, `Wrestler`.`rest15`, `Wrestler`.`image`, `Wrestler`.`image_name`, `Wrestler`.`image_all`, `Wrestler`.`image_movie`, `Wrestler`.`display_order`, `Wrestler`.`label_div`, `Wrestler`.`memo`, `Wrestler`.`created_user`, `Wrestler`.`created`, `Wrestler`.`modified_user`, `Wrestler`.`modified`, `Wrestler`.`delete_flg` FROM `nhk_sumo`.`competition_results` AS `CompetitionResult` LEFT JOIN `nhk_sumo`.`wrestlers` AS `Wrestler` ON (`CompetitionResult`.`wrestler_id` = `Wrestler`.`id`) WHERE `CompetitionResult`.`nendo_place_date` = '2021215' AND `CompetitionResult`.`code` = 'OS17MU__KN' AND `CompetitionResult`.`delete_flg` = '0' | 2 | 2 | 0 | |
| SELECT `CompetitionResult`.`id`, `CompetitionResult`.`nendo_place_date`, `CompetitionResult`.`code`, `CompetitionResult`.`wrestler_id`, `CompetitionResult`.`wrestler_name`, `CompetitionResult`.`standing_class`, `CompetitionResult`.`standing_scope`, `CompetitionResult`.`award_kind`, `CompetitionResult`.`award_count`, `CompetitionResult`.`award_outcome`, `CompetitionResult`.`display_order`, `CompetitionResult`.`created_user`, `CompetitionResult`.`created`, `CompetitionResult`.`modified_user`, `CompetitionResult`.`modified`, `CompetitionResult`.`delete_flg`, `Wrestler`.`id`, `Wrestler`.`code`, `Wrestler`.`nendo_place`, `Wrestler`.`name`, `Wrestler`.`kind_div`, `Wrestler`.`direction_div`, `Wrestler`.`rank`, `Wrestler`.`win`, `Wrestler`.`lose`, `Wrestler`.`rest`, `Wrestler`.`win00`, `Wrestler`.`lose00`, `Wrestler`.`rest00`, `Wrestler`.`win01`, `Wrestler`.`lose01`, `Wrestler`.`rest01`, `Wrestler`.`win02`, `Wrestler`.`lose02`, `Wrestler`.`rest02`, `Wrestler`.`win03`, `Wrestler`.`lose03`, `Wrestler`.`rest03`, `Wrestler`.`win04`, `Wrestler`.`lose04`, `Wrestler`.`rest04`, `Wrestler`.`win05`, `Wrestler`.`lose05`, `Wrestler`.`rest05`, `Wrestler`.`win06`, `Wrestler`.`lose06`, `Wrestler`.`rest06`, `Wrestler`.`win07`, `Wrestler`.`lose07`, `Wrestler`.`rest07`, `Wrestler`.`win08`, `Wrestler`.`lose08`, `Wrestler`.`rest08`, `Wrestler`.`win09`, `Wrestler`.`lose09`, `Wrestler`.`rest09`, `Wrestler`.`win10`, `Wrestler`.`lose10`, `Wrestler`.`rest10`, `Wrestler`.`win11`, `Wrestler`.`lose11`, `Wrestler`.`rest11`, `Wrestler`.`win12`, `Wrestler`.`lose12`, `Wrestler`.`rest12`, `Wrestler`.`win13`, `Wrestler`.`lose13`, `Wrestler`.`rest13`, `Wrestler`.`win14`, `Wrestler`.`lose14`, `Wrestler`.`rest14`, `Wrestler`.`win15`, `Wrestler`.`lose15`, `Wrestler`.`rest15`, `Wrestler`.`image`, `Wrestler`.`image_name`, `Wrestler`.`image_all`, `Wrestler`.`image_movie`, `Wrestler`.`display_order`, `Wrestler`.`label_div`, `Wrestler`.`memo`, `Wrestler`.`created_user`, `Wrestler`.`created`, `Wrestler`.`modified_user`, `Wrestler`.`modified`, `Wrestler`.`delete_flg` FROM `nhk_sumo`.`competition_results` AS `CompetitionResult` LEFT JOIN `nhk_sumo`.`wrestlers` AS `Wrestler` ON (`CompetitionResult`.`wrestler_id` = `Wrestler`.`id`) WHERE `CompetitionResult`.`nendo_place_date` = '2021215' AND `CompetitionResult`.`code` = 'OS17MU__GN' AND `CompetitionResult`.`delete_flg` = '0' | 1 | 1 | 0 | |
1 duplicate queries run.
