add LIMITs to (maybe) speedup queries

Signed-off-by: Florian Pritz <bluewind@xssn.at>

2 files changed, 7 insertions, 4 deletions

diff --git a/system/application/controllers/file.php b/system/application/controllers/file.php
index 96165eb55..ac8f15452 100644
--- a/system/application/controllers/file.php
+++ b/system/application/controllers/file.php
@@ -218,7 +218,7 @@ class File extends Controller {
         unlink($file);
         $this->db->query('DELETE FROM files WHERE hash = ?', array($row['hash']));
       } else {
-        $this->db->query('DELETE FROM files WHERE id = ?', array($row['id']));
+        $this->db->query('DELETE FROM files WHERE id = ? LIMIT 1', array($row['id']));
       }
     }
   }
diff --git a/system/application/models/file_mod.php b/system/application/models/file_mod.php
index 23c3002af..769273f2f 100644
--- a/system/application/models/file_mod.php
+++ b/system/application/models/file_mod.php
@@ -30,7 +30,8 @@ class File_mod extends Model {
     $sql = '
       SELECT id
       FROM `files`
-      WHERE `id` = ?';
+      WHERE `id` = ?
+      LIMIT 1';
     $query = $this->db->query($sql, array($id));
 
     if ($query->num_rows() == 1) {
@@ -45,7 +46,8 @@ class File_mod extends Model {
     $sql = '
       SELECT hash,filename
       FROM `files`
-      WHERE `id` = ?';
+      WHERE `id` = ?
+      LIMIT 1';
     $query = $this->db->query($sql, array($id));
 
     if ($query->num_rows() == 1) {
@@ -74,7 +76,8 @@ class File_mod extends Model {
     $sql = '
       SELECT id
       FROM `files`
-      WHERE `hash` = ?';
+      WHERE `hash` = ?
+      LIMIT 1';
     $query = $this->db->query($sql, array($hash));
 
     if ($query->num_rows() == 0) {