perf: limit results for fetch_optional queries

1 files changed, 18 insertions, 10 deletions

diff --git a/src/routes/user.rs b/src/routes/user.rs
index 04ab500..73eef04 100644
--- a/src/routes/user.rs
+++ b/src/routes/user.rs
@@ -18,11 +18,15 @@ impl UserUuid {
     /// Get a user with a specific `uuid`
     #[tracing::instrument]
     pub async fn get(self, State(state): State<Arc<AppState>>) -> impl IntoResponse {
-        sqlx::query_as!(UserSchema, "SELECT * FROM users WHERE uuid = $1", self.uuid)
-            .fetch_optional(&state.pool)
-            .await?
-            .ok_or_else(|| Error::UserNotFound)
-            .map(Json)
+        sqlx::query_as!(
+            UserSchema,
+            "SELECT * FROM users WHERE uuid = $1 LIMIT 1",
+            self.uuid
+        )
+        .fetch_optional(&state.pool)
+        .await?
+        .ok_or_else(|| Error::UserNotFound)
+        .map(Json)
     }
 }
 
@@ -37,11 +41,15 @@ impl User {
         State(state): State<Arc<AppState>>,
         Extension(Claims { sub, .. }): Extension<Claims>,
     ) -> Result<impl IntoResponse, Error> {
-        sqlx::query_as!(UserSchema, "SELECT * FROM users WHERE uuid = $1", sub)
-            .fetch_optional(&state.pool)
-            .await?
-            .ok_or_else(|| Error::UserNotFound)
-            .map(Json)
+        sqlx::query_as!(
+            UserSchema,
+            "SELECT * FROM users WHERE uuid = $1 LIMIT 1",
+            sub
+        )
+        .fetch_optional(&state.pool)
+        .await?
+        .ok_or_else(|| Error::UserNotFound)
+        .map(Json)
     }
 }