用這個方法可以把「所有」使用到資料庫 query 的語句記錄下來。

// in app/Providers/AppServiceProvider.php

namespace App\\Providers;

use Illuminate\\Support\\Facades\\Log;
use Illuminate\\Support\\Facades\\DB;
use Illuminate\\Support\\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        DB::listen(function($query) {
            Log::info(
                $query->sql,
                [
                    'bindings' => $query->bindings,
                    'time' => $query->time
                ]
            );
        });
    }

    // ...
}

Resource

Laravel Eloquent display query log