select('id, name, login, email, privilege, data') ->andWhere(ApiUtil::getLimitSpec($offset, $limit)) ->addCalcRows() ->from('admins') ->execute(); $totalCount = (int) sqlFetchAssoc(sqlQuery('SELECT FOUND_ROWS() as total_count'))['total_count']; return (new AdminUserCollection(ApiUtil::wrapItems($admins, AdminUser::class))) ->setItemsTotalCount($totalCount) ->setLimit($limit) ->setOffset($offset); } }