``` $mysql = Db::getInstance()->init('pool'); ``` #### query 執行原生語句，$sql SQL語句，$pre 預加載數據，必須是數組 ``` $data = $mysql->query($sql,$pre=[]); ``` #### select($buildSql=false)查詢，返回二維數組，$buildSql=true返回查詢語句 ``` $data = $mysql->table('table')->field('f1,f2')->where('f1', 'between', '1,5')->order('f1', 'desc')->limit(0, 1)->select(); ``` #### find($buildSql=false) 查詢 ，返回一維數組 ``` $data = $mysql->table('table')->field('f1,f2')->where('f1', 5)->find(); ``` #### column($field, $index = '', $buildSql = false) 列查詢，$field查詢字段，$index索引 ``` $data = $mysql->table('table')->field('f1,f2')->where('f1', 'between', '1,5')->order('f1', 'desc')->limit(0, 1)->select(); ``` #### value($field, $buildSql = false) 值查詢，$field字段名 ``` $data = $mysql->table('table')->where('id',5)->find('name'); ``` #### count、sum、max、min、avg聚合查詢 ``` $data = $mysql->table('table')->count('id'); ``` #### paginate($page = 1, $limit = 10, $buildSql = false) 分頁，$page頁碼，$limit單頁條數 ``` paginate($page = 1, $limit = 10, $buildSql = false) ``` #### 高級查詢 ``` $mysql->table('table1 a')->field('a.id,b.name,c.age,')->join('table b','a.id=b.id','left')->join('table c','a.id=c.id','right')->whereOr('a.id','in','1,2,3')->where('c.age','in',[11,12])->group('a.name')->having('c.age','>',11)->order('a.id','desc')->limit(10)->select(); ```