Laravel框架实现利用监听器进行sql语句记录功能

# 监听sqlmake:listener QueryListener --event=Illuminate/Database/Events/QueryExecuted

<?phpnamespace App/Listeners;use Illuminate/Database/Events/QueryExecuted;use Illuminate/Queue/InteractsWithQueue;use Illuminate/Contracts/Queue/ShouldQueue;use App/Http/Models/OperationLog;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);    # 此处$uid定义是依赖于中间件记录操作日志代码    $uid = isset($_SERVER['admin_uid']) ? $_SERVER['admin_uid'] : 0;    if('select' != substr($log , 0 , 6)){      if('insert into `operationLog`' != substr($log , 0 , 26)){        $OperationLog = new OperationLog();        $OperationLog->uid = $uid;        $OperationLog->sql = $log;        $OperationLog->input = '';        $OperationLog->save();      }    }  }}

protected $listen = [    ...    /Illuminate/Database/Events/QueryExecuted::class => [      'App/Listeners/QueryListener'    ],    ...  ];