From 2d4cb5ed1c0fba33be5dcfc837a4af41e3d948c4 Mon Sep 17 00:00:00 2001
From: Daniel Starzmann <daniel@starze.de>
Date: Wed, 12 Apr 2023 16:18:05 +0200
Subject: Improve sql query performance by removing unused payload

Signed-off-by: Daniel Starzmann <daniel@starze.de>
---
 lib/Db/ItemMapperV2.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/Db/ItemMapperV2.php b/lib/Db/ItemMapperV2.php
index d8b36723d..972295ee3 100644
--- a/lib/Db/ItemMapperV2.php
+++ b/lib/Db/ItemMapperV2.php
@@ -314,7 +314,7 @@ class ItemMapperV2 extends NewsMapperV2
     {
         $builder = $this->db->getQueryBuilder();
 
-        $builder->select('items.*')
+        $builder->select('items.id')
                 ->from($this->tableName, 'items')
                 ->innerJoin('items', FeedMapperV2::TABLE_NAME, 'feeds', 'items.feed_id = feeds.id')
                 ->where('feeds.user_id = :userId')
-- 
cgit v1.2.3