# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 32023
SELECT id FROM entries WHERE active='1' AND preview='0' ORDER BY posted DESC LIMIT 10,1;
If the query is limited to 10 results, why does it examine all rows? Is there any way to make the query stop once it's got enough rows? (This is literally killing my website.)
posted is a date field, every field that's used with = is indexed
What can I do?