Yii2 Debug How many database requests?

Question

Yii

I make a request in the controller:

$user = User::find(
            ['status' => 10],
            ['username' => Yii::$app->request->get('id')])
            ->one();

Debug issues DB 3 20ms
If I understand correctly, this means 3 queries to the database in 20ms Why???
Or Yii2 in some tricky way fulfills this request 3?

Answer 1

when executing a query in a model, the following happens:
1. A query to get the table structure
2. A query to get the number of table records
3. A query to get data for the specified selection To
avoid this (in production), you should use the database schema caching, for this it is enough to register the connection to the database in the config, for example:
enableSchemaCache' => true,
'schemaCacheDuration' => 180000,
'schemaCache' => 'cache'