Why doesn't limit() work in yii2?

Question

MySQL

Good afternoon! Here's a simple query:
$query->andWhere(['online' => 1, 'rooms' => 1])->limit(2);
I receive sampling - the limit does not work. offset - similar.
What am I doing wrong?
Thanks in advance!

Answer 1

Your code is correct. The problem is elsewhere. Show all code.

Answer 2

Most likely you change this limit somewhere. For example, in the DataProvider - it automatically sets its values ​​to limit and offset depending on the pagination settings

Answer 3

Try to see the resulting sql

var_dump($query->prepare(Yii::$app->db->queryBuilder)->createCommand()->rawSql);
exit();

before return $query;