Video get SQL optimization

1 files changed, 13 insertions, 5 deletions

diff --git a/server/models/video/video.ts b/server/models/video/video.ts
index 7af68b20b..71e37e147 100644
--- a/server/models/video/video.ts
+++ b/server/models/video/video.ts
@@ -127,22 +127,30 @@ enum ScopeNames {
             attributes: {
               exclude: [ 'privateKey', 'publicKey' ]
             },
-            model: () => ActorModel,
-            required: true
+            model: () => ActorModel.unscoped(),
+            required: true,
+            include: [
+              {
+                attributes: [ 'host' ],
+                model: () => ServerModel.unscoped(),
+                required: false
+              }
+            ]
           },
           {
-            model: () => AccountModel,
+            model: () => AccountModel.unscoped(),
             required: true,
             include: [
               {
-                model: () => ActorModel,
+                model: () => ActorModel.unscoped(),
                 attributes: {
                   exclude: [ 'privateKey', 'publicKey' ]
                 },
                 required: true,
                 include: [
                   {
-                    model: () => ServerModel,
+                    attributes: [ 'host' ],
+                    model: () => ServerModel.unscoped(),
                     required: false
                   }
                 ]