ADDED orders.idx_p10_orders_hotel_created (hotel_id,created_at)
ADDED orders.idx_p10_orders_service_created (service_type,created_at)
ADDED payments.idx_p10_payments_hotel_paid (hotel_id,paid_at,status)
ADDED restaurant_reservations.idx_p10_reservation_hotel_start (hotel_id,start_at,status)
ADDED audit_logs.idx_p10_audit_action_created (action,created_at)
ADDED notifications.idx_p10_notifications_status_created (status,created_at)
ADDED runtime_job_runs.idx_p10_job_finished (finished_at,status)
Optimization complete. Run EXPLAIN on production report queries before adding further indexes.