$list = Db::view('shop', 'id,nav_id')
->view('seller', 'type', 'seller.id = shop.seller_id')
->view('coupon', 'favorable', 'coupon.id = shop.coupon_id')
->cache(true)
->paginate(20);采用视图查询时发现数据已经缓存了,但是在次调用时还会在次查询数据库,如果设置查询键值那就呵呵了用join却没这样问题.
$join = [
['__SELLER__ seller','seller.id = shop.seller_id'],
['__COUPON__ coupon','coupon.id = shop.coupon_id'],
];
db('shop')->alias('shop')->join($join)->cache(true)->paginate(20); 最佳答案
