代码:
DB::connection()- enableQueryLog();
$query = DB::table('test')- orderBy('id', 'desc')- get();//需要执行的SQL语句
echo '<pre ';
print_r(DB::getQueryLog());
执行结果为:
Array
(
[0] = Array
(
[query] = select count(*) as aggregate from `sj_real` where `real_status` = ?
[bindings] = Array
(
[0] = 1
)
[time] = 225.01
)
[1] = Array
(
[query] = select * from `sj_real` where `real_status` = ? order by `real_id` desc limit 15 offset 0
[bindings] = Array
(
[0] = 1
)
[time] = 45
)
)
其中query所对应的为执行的SQL语句,?则表示参数值,即bindings中的值!
以上这篇laravel实现查询最后执行的一条sql语句的方法就是小编分享给大家的全部内容了,希望能给大家一个参考。