获取sql语句
getLastSql

1. $res = Db::table(‘staff’)->field(‘id,salary’)->where(‘id’,’>’,1)
2.                 ->group(‘salary’)->having(‘salary > 5000’)->select();
3.     $sql = Db::table(‘staff’)->getLastSql();
4.     halt($sql);

复制代码select(false)

1. $res = Db::table(‘staff’)->field(‘id,salary’)->where(‘id’,’>’,1)
2.             ->group(‘salary’)->having(‘salary > 5000’)->select(false);
3. halt($res);

复制代码fetchSql

1. $res = Db::table(‘staff’)->field(‘id,salary’)->where(‘id’,’>’,1)
2.             ->group(‘salary’)->having(‘salary > 5000’)->fetchSql()->select();
3. halt($res);

复制代码buildSql

1. $res = Db::table(‘staff’)->field(‘id,salary’)->where(‘id’,’>’,1)
2.             ->group(‘salary’)->having(‘salary > 5000’)->buildSql();
3. halt($res);

复制代码监听sql

1. Db::listen(function($sql, $time, $explain){
2.     // 记录SQL
3.     echo $sql. ‘ [‘.$time.’s]’;
4.     // 查看性能分析结果
5.     dump($explain);
6. });

复制代码sql级日志记录