Yii2 ActiveRecord problem with SQL queries?

Question

Yii

Hello!!! I make queries with counting the number of rows, and I noticed that the SQL queries seem to be connected.
For example I created

$query=Custum::find()->joinWith('order')->where(['id'=>101])
$count_custom=$query->count();

If I need to add a condition accordingly, I simply add andWhere()->count();
But I noticed that if I enter a new parameter with the same $query, for some reason it displays the added andWhere, so my calculations are wrong. What is the problem?

Answer 1

$query = Custum::find()->joinWith('order')->where(['id'=>101]); // возвращает ActiveRecord с условием where
$count_custom = $query->count(); // считает с условием where
$query->andWhere(условие); // добавляет $query условие andWhere, теперь в нем два условия: where и andWhere

Are you asking about this?
UPD:
$query->andWhere()changes the $query object. If you need to apply different conditions, use the (clone $query)->andWhere().