diff options
| author | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-21 12:31:56 +0900 |
|---|---|---|
| committer | syuilo <Syuilotan@yahoo.co.jp> | 2021-03-21 12:31:56 +0900 |
| commit | c52b50414094e2d44aaea3ab78ef17d04566db80 (patch) | |
| tree | 30d1e38584d49c344041700413fee7afa449adca /src/server/api/endpoints/notes/hybrid-timeline.ts | |
| parent | perf(server): Improve following/followers API performance (diff) | |
| download | sharkey-c52b50414094e2d44aaea3ab78ef17d04566db80.tar.gz sharkey-c52b50414094e2d44aaea3ab78ef17d04566db80.tar.bz2 sharkey-c52b50414094e2d44aaea3ab78ef17d04566db80.zip | |
Revert "fix(server): Use inner join"
This reverts commit d7e7848c9206b68ab86d2d566ec4247db87827c0.
Diffstat (limited to 'src/server/api/endpoints/notes/hybrid-timeline.ts')
| -rw-r--r-- | src/server/api/endpoints/notes/hybrid-timeline.ts | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/server/api/endpoints/notes/hybrid-timeline.ts b/src/server/api/endpoints/notes/hybrid-timeline.ts index aa09be23d2..69f2a7c107 100644 --- a/src/server/api/endpoints/notes/hybrid-timeline.ts +++ b/src/server/api/endpoints/notes/hybrid-timeline.ts @@ -127,11 +127,11 @@ export default define(meta, async (ps, user) => { qb.where(`((note.userId IN (${ followingQuery.getQuery() })) OR (note.userId = :meId))`, { meId: user.id }) .orWhere('(note.visibility = \'public\') AND (note.userHost IS NULL)'); })) - .innerJoinAndSelect('note.user', 'user') - .innerJoinAndSelect('note.reply', 'reply') - .innerJoinAndSelect('note.renote', 'renote') - .innerJoinAndSelect('reply.user', 'replyUser') - .innerJoinAndSelect('renote.user', 'renoteUser') + .leftJoinAndSelect('note.user', 'user') + .leftJoinAndSelect('note.reply', 'reply') + .leftJoinAndSelect('note.renote', 'renote') + .leftJoinAndSelect('reply.user', 'replyUser') + .leftJoinAndSelect('renote.user', 'renoteUser') .setParameters(followingQuery.getParameters()); generateChannelQuery(query, user); |