- getLastSql() 输出上次执行的sql语句
User::get(1);
echo User::getLastSql();
输出结果是 SELECT * FROM 'think_user' WHERE 'id' = '1'
- fetchSql() 打印sql,不执行
$tmp_list = Db::name('have_card')
->field('id , iccid, msisdn')
->where([
'user_id' => $uid,
'msisdn' => ['IN', $list]
])
->fetchSql()
->select();
halt($res);
打印后结果:
SELECT `id`,`iccid`,`msisdn` FROM `have_card` WHERE `user_id` = 4299 AND `msisdn` IN ('13153725111')
- buildSql() 不会进行实际查询,只生成sql,未避免混淆,会在两边加括号
$subQuery = Db::table('think_user')
->field('id,name')
->where('id', '>', 10)
->buildSql();
生成的subQuery结果为:
( SELECT `id`,`name` FROM `think_user` WHERE `id` > 10 )
- 监听sql 开启数据库调试模式
Db::listen(function ($sql, $time, $explain) {
echo $sql . ' [' . $time . 's]';
dump($explain);
});