The order list searches orders either for user_id = 1 or for status = 'paid'. The user side is already supported, but status is not. Add an index on status so the status side does not scan the whole order list.

SELECT * FROM orders WHERE user_id = 1 OR status = 'paid'