hyapp-server/scripts/mysql/049_external_recharge_reconcile_index.sql

ALTER TABLE external_recharge_orders
  ADD INDEX idx_external_recharge_orders_reconcile (app_code, status, provider_code, updated_at_ms, created_at_ms);