providers

EventServiceProvider.php 添加
protected $listen = [
        'Illuminate\Database\Events\QueryExecuted' => [
            'App\Listeners\QueryListener'
        ] ,
    ];

　　执行php artisan event:generate

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

会生成 

QueryListener.php文件
<?php

namespace App\Listeners;

use Illuminate\Database\Events\QueryExecuted;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Support\Facades\Log;

class QueryListener
{
    /**
     * Create the event listener.
     *
     * @return void
     */
    public function __construct()
    {
        //
    }

    /**
     * Handle the event.
     *
     * @param  QueryExecuted  $event
     * @return void
     */
    public function handle(QueryExecuted $event)
    {

        $sql = str_replace("?", "'%s'", $event->sql);
        $log['sql'] = vsprintf($sql, $event->bindings);
        Log::info(date("Y-m-d H:i:s")."(". $log['sql']).")";
    }
}

　　bootstrap文件添加

$app->register(App\Providers\EventServiceProvider::class);
扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄