/** * type list * @return view */ public function index() { //DB::enableQueryLog(); $list = Type::orderBy('id', 'desc')->leftJoin('attributes', 'types.id', '=', 'attributes.type_id')->select('types.*', DB::raw('count(it_attributes.id) as total'))->groupBy('types.id')->paginate(config('shop.pagesize')); //分页显示 //$query = DB::getQueryLog(); //$lastQuery = end($query); //p($lastQuery);die; return view('admin.type.index', compact('list')); }
function retrieveAllTypes() { return $queries = \App\models\Type::orderBy('id', 'asc')->get(); }