SELECT `A`.`idx`, `A`.`battletag`, `A`.`level`, `A`.`portrait`, `A`.`region`, `C`.`EliminationsperLife` AS `kda`, `C`.`eliminations`, `D`.`deaths`, `E`.`score`, `E`.`timeplayed`, `E`.`timespentonfire`, `E`.`gamesplayed`, `E`.`gameswon`, `E`.`rating`,
(SELECT group_concat(`herocode` ORDER BY `data` DESC SEPARATOR ',') FROM `tophero` AS `most_hero` WHERE `most_hero`.`profileidx` = `A`.`idx` AND `datatype` = 0) AS `most`
FROM `profile` AS `A`
JOIN `all_stat_average` AS `B` ON `A`.`idx` = `B`.`profileidx`
JOIN `all_stat_combat` AS `C` ON `A`.`idx` = `C`.`profileidx`
JOIN `all_stat_deaths` AS `D` ON `A`.`idx` = `D`.`profileidx`
JOIN `all_stat_game` AS `E` ON `A`.`idx` = `E`.`profileidx`
WHERE `A`.`idx` IN (6386,13000,15991,12856,15990,15998,11877,15999,10878,10979,2543,182524,183113,8124,124531,72822,31,154942,153158,116360);
 

----------------------------------------------------------------------------------------------------

상기 쿼리의 성능 개선을 한다면 어떤식으로 하면 좋을지 고수님들 의견 부탁드립니다~