diff options
author | Jérémy Benoist <j0k3r@users.noreply.github.com> | 2019-08-08 15:27:49 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2019-08-08 15:27:49 +0200 |
commit | 97c678a0b26d748f9829d732910d5c402c609dc2 (patch) | |
tree | e82f95e192cd54e1094227c3987ae2af5215d2b4 /src/Wallabag/CoreBundle/Entity/Entry.php | |
parent | 1a6980dbd16fd75f7be2420feeb9cc72b46884ef (diff) | |
parent | 00567d9ccde71eba1aabf8fa0d547897f6870b28 (diff) | |
download | wallabag-97c678a0b26d748f9829d732910d5c402c609dc2.tar.gz wallabag-97c678a0b26d748f9829d732910d5c402c609dc2.tar.zst wallabag-97c678a0b26d748f9829d732910d5c402c609dc2.zip |
Merge pull request #4081 from shtrom/fix-slow-queries
Fix slow/unindexed queries
Diffstat (limited to 'src/Wallabag/CoreBundle/Entity/Entry.php')
-rw-r--r-- | src/Wallabag/CoreBundle/Entity/Entry.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/Wallabag/CoreBundle/Entity/Entry.php b/src/Wallabag/CoreBundle/Entity/Entry.php index 4d5e6fc9..4acec261 100644 --- a/src/Wallabag/CoreBundle/Entity/Entry.php +++ b/src/Wallabag/CoreBundle/Entity/Entry.php | |||
@@ -28,7 +28,11 @@ use Wallabag\UserBundle\Entity\User; | |||
28 | * @ORM\Index(name="created_at", columns={"created_at"}), | 28 | * @ORM\Index(name="created_at", columns={"created_at"}), |
29 | * @ORM\Index(name="uid", columns={"uid"}), | 29 | * @ORM\Index(name="uid", columns={"uid"}), |
30 | * @ORM\Index(name="hashed_url_user_id", columns={"user_id", "hashed_url"}, options={"lengths"={null, 40}}), | 30 | * @ORM\Index(name="hashed_url_user_id", columns={"user_id", "hashed_url"}, options={"lengths"={null, 40}}), |
31 | * @ORM\Index(name="hashed_given_url_user_id", columns={"user_id", "hashed_given_url"}, options={"lengths"={null, 40}}) | 31 | * @ORM\Index(name="hashed_given_url_user_id", columns={"user_id", "hashed_given_url"}, options={"lengths"={null, 40}}), |
32 | * @ORM\Index(name="user_language", columns={"language", "user_id"}), | ||
33 | * @ORM\Index(name="user_archived", columns={"user_id", "is_archived", "archived_at"}), | ||
34 | * @ORM\Index(name="user_created", columns={"user_id", "created_at"}), | ||
35 | * @ORM\Index(name="user_starred", columns={"user_id", "is_starred", "starred_at"}) | ||
32 | * } | 36 | * } |
33 | * ) | 37 | * ) |
34 | * @ORM\HasLifecycleCallbacks() | 38 | * @ORM\HasLifecycleCallbacks() |
@@ -221,7 +225,7 @@ class Entry | |||
221 | /** | 225 | /** |
222 | * @var string | 226 | * @var string |
223 | * | 227 | * |
224 | * @ORM\Column(name="language", type="text", nullable=true) | 228 | * @ORM\Column(name="language", type="string", length=20, nullable=true) |
225 | * | 229 | * |
226 | * @Groups({"entries_for_user", "export_all"}) | 230 | * @Groups({"entries_for_user", "export_all"}) |
227 | */ | 231 | */ |