-- /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);