Yii2 - andFilterWhere

andFilterWhere - Appends WHERE condition to the existing one.
$model = Book::find()->where(['status' => 1])->andWhere(['<', 'price', 100])->one();
// generated sql query
// SELECT * FROM `book` WHERE (`status` = 1) AND (`price` < 100)