diff options
| author | Chocobozzz <me@florianbigard.com> | 2021-03-03 11:24:16 +0100 |
|---|---|---|
| committer | Chocobozzz <me@florianbigard.com> | 2021-03-03 11:24:16 +0100 |
| commit | 534556052ed4aab539325dccaa16c6dd2acecf73 (patch) | |
| tree | 19e6c0a0729196e13eeab66398b6963e424b0181 /server/models/video/video.ts | |
| parent | 6c9c3b7b14411a854c8dcf8583d56b314e45a4ce (diff) | |
| download | PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.tar.gz PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.tar.zst PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.zip | |
Optimize views sort sql query
Diffstat (limited to 'server/models/video/video.ts')
| -rw-r--r-- | server/models/video/video.ts | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/server/models/video/video.ts b/server/models/video/video.ts index b4c7da655..b3543ddf2 100644 --- a/server/models/video/video.ts +++ b/server/models/video/video.ts | |||
| @@ -426,7 +426,12 @@ export type AvailableForListIDsOptions = { | |||
| 426 | ] | 426 | ] |
| 427 | }, | 427 | }, |
| 428 | { fields: [ 'duration' ] }, | 428 | { fields: [ 'duration' ] }, |
| 429 | { fields: [ 'views' ] }, | 429 | { |
| 430 | fields: [ | ||
| 431 | { name: 'views', order: 'DESC' }, | ||
| 432 | { name: 'id', order: 'ASC' } | ||
| 433 | ] | ||
| 434 | }, | ||
| 430 | { fields: [ 'channelId' ] }, | 435 | { fields: [ 'channelId' ] }, |
| 431 | { | 436 | { |
| 432 | fields: [ 'originallyPublishedAt' ], | 437 | fields: [ 'originallyPublishedAt' ], |