The dashboard often shows orders whose status is paid or pending, but lookups by status are too slow. Add an index on status so this list opens faster.

SELECT * FROM orders WHERE status IN ('paid','pending')