I'm using the following query and it's getting logged to the slow queries log. Is there a more efficient way of retrieving the data.

select SQL_CACHE code,minprice from thetable where code in ('a','b','c','d','e','f') order by minprice