a表b表各有3万条数据,使用paginate一直转圈,网页刷新不了了
求解
$booksList = Db::name('Books')
->alias('a')
->join('books_cate_relationships b','b.books_id= a.id','LEFT')
->join('books_cate c','c.id= b.cate_id','LEFT')
->where($map)
->distinct(true)
->order('a.createtime desc')
->field('a.name,a.id,a.price,a.status,a.createtime,c.name as catename,c.id as cate_id,b.is_hot as is_hot,b.order_id as order_id')
->paginate(10); 最佳答案