优化'GROUP BY' - 查询，消除'使用位置;使用临时;使用filesort'

I'm faced with a MySQL issue I cannot seem to resolve. In order to be able quickly execute a I'm faced with a MySQL issue I cannot seem to r