laravel中把查询数据库的sql写入日志中

1、在app\Providers\EventServiceProvider.php中添加一个触发

<pre name="code" class="html">protected $listen = [        'App\Events\SomeEvent' => [            'App\Listeners\EventListener',        ],        'Illuminate\Database\Events\QueryExecuted' => [            'App\Listeners\QueryListener'        ]];

然后在listenrs文件夹中创建一个文件app\Listeners\QueryListener.php

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 = vsprintf($sql, $event->bindings);        Log::info($log);    }}

然后你就能到

storage\logs\laravel.log 查询你的sql了，优化sql合查询bug有很大的帮助。