diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-22 21:39:39 +0100 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-22 21:39:39 +0100 |
commit | f9107664b01ba6f9cb3283a08a9ae4baf6026215 (patch) | |
tree | c3d783e4de04c65ec4bbaf6d86acde5ab8199f0f /db/foldermapper.php | |
parent | 91a327f5c687014fe20b531b9a42b98fe151d017 (diff) |
made mappers faster by only joining the relevant rows for each user
Diffstat (limited to 'db/foldermapper.php')
-rw-r--r-- | db/foldermapper.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/db/foldermapper.php b/db/foldermapper.php index ef2f31f2d..82739df1b 100644 --- a/db/foldermapper.php +++ b/db/foldermapper.php @@ -36,11 +36,11 @@ class FolderMapper extends Mapper implements IMapper { } public function find($id, $userId){ - $sql = 'SELECT * FROM `*dbprefix*news_folders` ' . + $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . 'WHERE `id` = ? ' . 'AND `user_id` = ?'; - $row = $this->findQuery($sql, array($id, $userId)); + $row = $this->findOneQuery($sql, array($id, $userId)); $folder = new Folder(); $folder->fromRow($row); @@ -63,7 +63,7 @@ class FolderMapper extends Mapper implements IMapper { public function findAllFromUser($userId){ - $sql = 'SELECT * FROM `*dbprefix*news_folders` ' . + $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . 'WHERE `user_id` = ?'; $params = array($userId); @@ -72,7 +72,7 @@ class FolderMapper extends Mapper implements IMapper { public function findByName($folderName, $userId){ - $sql = 'SELECT * FROM `*dbprefix*news_folders` ' . + $sql = 'SELECT * FROM `*PREFIX*news_folders` ' . 'WHERE `name` = ?' . 'AND `user_id` = ?'; $params = array($folderName, $userId); |