diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2022-03-26 18:22:55 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2022-03-26 18:22:55 +0900 |
| commit | 475cee9029ab5fd1271ddd14a03d9dd3e85e4109 (patch) | |
| tree | 2d58b0539ed255869dc6baed6e3517ad70202c65 /packages/backend/src/server/api | |
| parent | perf(server): improve deliver performance (diff) | |
| download | sharkey-475cee9029ab5fd1271ddd14a03d9dd3e85e4109.tar.gz sharkey-475cee9029ab5fd1271ddd14a03d9dd3e85e4109.tar.bz2 sharkey-475cee9029ab5fd1271ddd14a03d9dd3e85e4109.zip | |
perf(server): reduce db query when get notifications
Diffstat (limited to 'packages/backend/src/server/api')
| -rw-r--r-- | packages/backend/src/server/api/endpoints/i/notifications.ts | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/packages/backend/src/server/api/endpoints/i/notifications.ts b/packages/backend/src/server/api/endpoints/i/notifications.ts index 7d9bd44d1d..6ea8cb3574 100644 --- a/packages/backend/src/server/api/endpoints/i/notifications.ts +++ b/packages/backend/src/server/api/endpoints/i/notifications.ts @@ -70,6 +70,8 @@ export default define(meta, paramDef, async (ps, user) => { .andWhere(`notification.notifieeId = :meId`, { meId: user.id }) .leftJoinAndSelect('notification.notifier', 'notifier') .leftJoinAndSelect('notification.note', 'note') + .leftJoinAndSelect('notifier.avatar', 'notifierAvatar') + .leftJoinAndSelect('notifier.banner', 'notifierBanner') .leftJoinAndSelect('note.user', 'user') .leftJoinAndSelect('user.avatar', 'avatar') .leftJoinAndSelect('user.banner', 'banner') |