Hi Lay, If I don't mistake, you can't eliminate "Using temporary" and "Using filesort" because you are using an "order by". Try the explain again removing order by and check the output. When you use an order by, MySQL needs to use filesort and spends some time sorting the result set. Also, create a temporary table with the rows prevously. This is the reason.
Regards, Antonio.
