一、在app\Providers\EventServiceProvider.php中添加一个触发
'App\Events\Event' => [ 'App\Listeners\EventListener',],'Illuminate\Database\Events\QueryExecuted' => [ 'App\Listeners\QueryListener']
然后在listenrs文件夹中创建一个文件app\Listeners\QueryListener.php
namespace App\Listeners;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
class QueryListener
{
/**
* Create the event listener.
*
* @return void
*/
public function __construct()
{
//
}
/**
* Handle the event.
*
* @param object $event
* @return void
*/
public function handle($event)
{
//
$sql = str_replace("?", "'%s'", $event->sql);
$log = vsprintf($sql, $event->bindings);
\Log::info($log);
}
}
