laravel 取sql语句

最新推荐文章于 2024-09-14 17:41:03 发布

weixin_30852367

最新推荐文章于 2024-09-14 17:41:03 发布

阅读量65

点赞数

文章标签： php

原文链接：http://www.cnblogs.com/fenle/p/5010149.html

版权

 \DB::connection()->enableQueryLog();

some sql action...

$query = \DB::getQueryLog();
$lastQuery = end($query);  

dd($lastQuery);

php artisan tinker

DB::listen(function($sql){ var_dump($sql);  });

Inside AppServiceProvider.php add the following to the boot method:

use DB;
use Event;

//..

public function boot()
{
    if (env('APP_ENV') === 'local') {
        DB::connection()->enableQueryLog();
    }
    if (env('APP_ENV') === 'local') {
        Event::listen('kernel.handled', function ($request, $response) {
            if ( $request->has('sql-debug') ) {
                $queries = DB::getQueryLog();
                dd($queries);
            }
        });
    }
}