Why does count return the same data regardless of conditions?

Question

MySQL

There are 6 records in the table. Here is the action:

public function actionAddMoreGroupPosts($id,$page){
        $offset = ($page-1) * 20;
        $query = GroupPost::find()->with(['author'])->where(['group_id'=>$id])->orderBy('status_id DESC, id DESC')->offset($offset);
        return $query->count();
    }

returns 6 regardless of $page.
The most interesting thing is that this bike wrote because the standard for Yii - Pagination returned the same thing.
Where am I fool?
In debug I look at the request:

SELECT COUNT(*) FROM `group_post` WHERE `group_id`='2' ORDER BY `status_id` DESC, `id` DESC

i.e. offset($offset) doesn't work at all

Answer 1

а полученный запрос после конструктора не смотрели? Иногда помогает - визуально оценить что наваяли если все мысли кончились )

Answer 2

Try writing: return $query->count([0]); In general, I can’t understand what Count should be returned, id or some other field.

Answer 3

Может нужно указать ->limit()?