How to cache a request by timer?

Question

Yii

I have a costly new Query() query that counts a large amount of data that changes very quickly, therefore, when the query is called, it takes a long time to count, I would like it to remember it at the time of the response and be in the cache for 3 minutes then work again. How can this be implemented, can anyone give examples?

Answer 1

$query = Model::find()->where(['field' => 5, 'field2' => 777]);

$other = Yii::$app->db->cache(function ($db) use ($query) {
    /** @var Connection $db */
    return $db->createCommand($query->createCommand()->rawSql)->queryOne();
}, 120);

at the end time in seconds, how long to cache the request