Bind variable acting as hard-coded SQL

Yii 2.0
1

I have this query:

'query' => Table1::find()->innerjoin('table2', 'table1.id = table2.tr_id')
                     ->andWhere('table2.user_id = :vuser_id')
                     ->params([':vuser_id' => 1]),

But when I look at the Yii database debug logs as well as MariaDB performance logs it shows the user_id = 1 as hardcoded SQL. Can anyone please confirm that my above statement would use SQL with bind variables? Or am I doing something wrong?

2

Yes, it will use parameter binding. Log is just makes it a bit more clear about which data was actually used for queries.

3

Awesome, thanks for confirming.