laravel方便调试打印sql日志查看
在实际开发中,我们需要查看拼装的sql是否是自己需要的,为了查看结果,我们直接打印sql.
用DB自带的getQueryLog方法直接打印:
use Illuminate\Support\Facades\DB;
DB::connection()->enableQueryLog(); // 开启QueryLog 2 \App\User::find(1); 3 dump(DB::getQueryLog());
exit;
得到下面的结果,不直观查看:
array:1 [
0 => array:3 [
"query" => "select * from `fook_platform_ordercode` where `fook_platform_ordercode`.`id` = ? limit 1"
"bindings" => array:1 [
0 => 1
]
"time" => 11.47
]
]
我们现在使用另外的一种方式,打印出完整的sql语句,可将以下代码复制到AppServiceProvider中的boot方法中:
代码如下:
\DB::listen( function ($sql) { foreach ($sql->bindings as $i => $binding) { if ($binding instanceof \DateTime) { $sql->bindings[$i] = $binding->format('\'Y-m-d H:i:s\''); } else { if (is_string($binding)) { $sql->bindings[$i] = "'$binding'"; } } } // Insert bindings into query $query = str_replace(array('%', '?'), array('%%', '%s'), $sql->sql); $query = vsprintf($query, $sql->bindings); // Save the query to file $logFile = fopen( storage_path('logs' . DIRECTORY_SEPARATOR . date('Y-m-d') . '_query.log'), 'a+' ); fwrite($logFile, date('Y-m-d H:i:s') . ': ' . $query . PHP_EOL); fclose($logFile); } );
那么打印的日志在