Thinkphp6经常需要查看 SQL 原生语句,这里有两种方式获取:

1、getLastSql(), 获取方法前最后一条 SQL 原生语句

$cartInfo = StoreOrderCartInfo::whereIn('cart_id', 24)->field('cart_info')->select();

echo StoreOrderCartInfo::getLastSql();  

结果为:

SELECT `cart_info` FROM `store_order_cart_info` WHERE  `cart_id` = 24

2、fetchSql(),获取当前执行sql语句

DB::name("cart_info")->where('cart_id', 24)->fetchSql(true)->find();

结果为:

SELECT * FROM `cart_info` WHERE  `cart_id` = 124 LIMIT 1