public function findAllByIds($ids) { $inQuery = implode(',', array_fill(0, count($ids), '?')); $query = (' select src.id as id, src.name as name, src.description as description, src.website as website from sources src where src.is_active = 1 and src.id in (' . $inQuery . ') '); $command = Yii::app()->db->createCommand($query); foreach ($ids as $k => $id) { $command->bindValue(($k+1), $id); } $result = $command->queryAll(); return $result; }