Yii2 how to make a selection from a database?

Question

MySQL

I'm writing a chat. Through ajax I check whether a new message has arrived from the interlocutor. To do this, I call the function for receiving new messages and pass it the id of the last message that is visible in my chat window and the number of the chat room.

public function getNew($lastId, $chatRoom){
        $list = self::find()->where('id > :lastId and chat_room_id = :chat_room_id',[':lastId'=>$lastId, ':chat_room_id'=>$chatRoom])->orderBy('id')->asArray()->all();
        if(isset($list[0])){
            echo Json::encode($list);
        }
    }

In the request, I want to remove all messages whose id is greater than the id of the last message in my chat window.
However, I do not receive any records, apparently, the request is not correctly composed. What am I doing wrong?

Upd. Sam kosyachnik, the question is removed.

Answer 1

Check incoming parameters
Look in debug mode query to the database