缓存依赖

最新推荐文章于 2019-08-09 18:44:04 发布

LiErDan

最新推荐文章于 2019-08-09 18:44:04 发布

阅读量287

点赞数

分类专栏： yii

本文链接：https://blog.csdn.net/LiErDan/article/details/80220889

版权

yii 专栏收录该内容

27 篇文章 1 订阅

订阅专栏

DB依赖, 数据缓存
$cache->set('CategoryCache', Category::CategoryList(),3600 * 24 * 365,  new DbDependency(['sql' => "SELECT `TABLE_NAME`, `UPDATE_TIME` FROM `information_schema`.`TABLES` WHERE `information_schema`.`TABLES`.`TABLE_SCHEMA` = 'shop' AND`information_schema`.`TABLES`.`TABLE_NAME` = 'category'"]));
var_dump($cache['CategoryCache']);

DB依赖, 查询缓存
$cat = Category::getDb()->cache(function()use($id, $key){
            return Category::find()->where(['id' => $id])->asArray()->all();
        }, 3600 * 24 * 365, new DbDependency(['sql' => "SELECT `TABLE_NAME`, `UPDATE_TIME` FROM `information_schema`.`TABLES` WHERE `information_schema`.`TABLES`.`TABLE_SCHEMA` = 'shop' AND    `information_schema`.`TABLES`.`TABLE_NAME` = 'category'"]));
<?php
    if($this->beginCache("cache_div54", [
        'duration' => 3600 * 3600 * 3600,
        'dependency' => [
            'class' => yii\caching\DbDependency::className(),
            'sql' => "SELECT `TABLE_NAME`, `UPDATE_TIME` FROM `information_schema`.`TABLES` WHERE `information_schema`.`TABLES`.`TABLE_SCHEMA` = 'shop' AND    `information_schema`.`TABLES`.`TABLE_NAME` = 'category'",
        ],
    ])):
?>
        <h1>someOne</h1>
<?php $this->endCache();
endif;
\YII::$app->end();?>
片段缓存依赖