GROUP BY needs ORDER BY NULL to avoid filesort
MySQL 5.7 Reference Manual  /  ...  /  SELECT Syntax


  If you use GROUP BY, output rows are sorted according to the GROUP BY columns as if you had an ORDER BY for the same columns. To avoid the overhead of sorting that GROUP BY produces, add ORDER BY NULL