mtsd/backend/scripts/add_api_request_logs_perf_indexes.sql

-- /api/web/admin/api-request-logs 列表性能索引补强
-- 典型查询：
--   WHERE is_del=0 [AND http_method=?] [AND status_code=?]
--   [AND create_at between ? and ?]
--   ORDER BY create_at DESC

-- 默认列表 + 时间倒序分页
ALTER TABLE sys_api_request_log
  ADD INDEX idx_arl_isdel_createat (is_del, create_at);

-- 按方法过滤
ALTER TABLE sys_api_request_log
  ADD INDEX idx_arl_isdel_method_createat (is_del, http_method, create_at);

-- 按状态码过滤
ALTER TABLE sys_api_request_log
  ADD INDEX idx_arl_isdel_status_createat (is_del, status_code, create_at);