[Bug] 条目查询接口性能优化

[chivehao]

提问前查询

• [X] 我已经在 issues 列表 里查询过，并且没找到类似的问题。

组件

服务端 (server)

运行环境

git.branch:main git.commit.id:b2448e2 git.commit.time:2024-10-15T20:42:06Z build.artifact:server build.name:server build.time:2024-10-15T20:43:48.779Z build.version:0.16.2 build.group:run.ikaros.server java.version:17.0.12 java.vendor.name:Eclipse Adoptium java.vendor.version:Temurin-17.0.12+7 java.runtime.name:OpenJDK Runtime Environment java.runtime.version:17.0.12+7 java.jvm.name:OpenJDK 64-Bit Server VM java.jvm.vendor:Eclipse Adoptium java.jvm.version:17.0.12+7 os.name:Linux os.version:6.8.0-45-generic os.arch:amd64 subjectCollection.wish:7 subjectCollection.discard:1 subjectCollection.total:139 subjectCollection.doing:6 subjectCollection.done:113 subjectCollection.shelve:12 character.total:0 attachment.total:22324 attachment.file:19796 attachment.folder:2528 subject.total:378 subject.game:5 subject.other:0 subject.music:19 subject.real:7 subject.comic:0 subject.anime:347 subject.novel:0 person.total:0

报错相关的日志

No response

发生了什么

条目接口太重了，条件查询接口极其耗时：

预期是怎样

单个接口响应的延迟，最高不能超高500ms，目标延迟是在300ms左右或者更小。

待优化接口

• [ ] GET /attachments/condition?...
• [ ] GET /subject/{id}