How can I optimize DB query?

Question

My db query is taking 5 seconds instead of <1 second earlier and the culprit query is :

explain extended 
select A,B,C 
from table flow 
where 
(status in ('X' , 'Y' , 'Z')) 
 and priority=1 
 and created<=now() 
 order by id asc limit 10;

Output:

Indexed:

create index status_created on flow (status, created);

Primary Index on primary key Id.

What does filtered column telling me here with 61839 value?

Answer 1

INDEX(priority, status)  -- column tested with "=" comes first.

Are there really any rows with created >= NOW()? If so, perhaps "created" is a poor name for the column.