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