summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorsyuilo <Syuilotan@yahoo.co.jp>2021-03-22 12:41:38 +0900
committersyuilo <Syuilotan@yahoo.co.jp>2021-03-22 12:41:38 +0900
commit967fae142b119de82dd6603f0e56b7e88fbb8c58 (patch)
tree4e80824fac5ad1f42c13e3da6a12eaafb60e4d13 /src
parentperf(server): Reduce database query (diff)
downloadsharkey-967fae142b119de82dd6603f0e56b7e88fbb8c58.tar.gz
sharkey-967fae142b119de82dd6603f0e56b7e88fbb8c58.tar.bz2
sharkey-967fae142b119de82dd6603f0e56b7e88fbb8c58.zip
fix bug
Diffstat (limited to 'src')
-rw-r--r--src/models/repositories/user.ts2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/models/repositories/user.ts b/src/models/repositories/user.ts
index 267e443cff..53c06f3f16 100644
--- a/src/models/repositories/user.ts
+++ b/src/models/repositories/user.ts
@@ -164,7 +164,7 @@ export class UserRepository extends Repository<User> {
const pins = opts.detail ? await UserNotePinings.createQueryBuilder('pin')
.where('pin.userId = :userId', { userId: user.id })
.innerJoinAndSelect('pin.note', 'note')
- .orderBy('id', 'DESC')
+ .orderBy('pin.id', 'DESC')
.getMany() : [];
const profile = opts.detail ? await UserProfiles.findOneOrFail(user.id) : null;