Laravel返回SQL语句中间件

<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Database\Events\QueryExecuted;
use Illuminate\Support\Facades\DB;

class AppendSqlToResponse
{
    private $sql = [];
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        if (!env('APP_DEBUG')) {
            return $next($request);
        }
        // inject
        DB::listen(function (QueryExecuted $query) {
            if (count($this->sql) < 10) {
                $sql = $query->sql;
                if (!empty($query->bindings)) {
                    foreach ($query->bindings as $key => $binding) {
                        // This regex matches placeholders only, not the question marks,
                        // nested in quotes, while we iterate through the bindings