laravel 获取某个查询的查询SQL语句

最新推荐文章于 2024-08-13 22:39:55 发布

_________MAN

最新推荐文章于 2024-08-13 22:39:55 发布

阅读量1.6w

点赞数

分类专栏： PHP

PHP 专栏收录该内容

19 篇文章 1 订阅

订阅专栏

DB::connection()->enableQueryLog();#开启执行日志
$count = DB::table('test')     //执行查询
            ->whereNull('deleted_at')
            ->where('id', '=', 3)
            ->where('Name', '=', '测试')
            ->count();
print_r(DB::getQueryLog());   //获取查询语句、参数和执行时间

Array
(
    [0] => Array
        (
            [query] => select count(*) as aggregate from `test` where `deleted_at` is null and `id` = ? and `Name` = ?
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 测试
                )

            [time] => 1
        )

)