laravel 杂项

1、laravel5.2输出sql

把下面的代码放到 app/Providers/AppServiceProvider.php中的boot方法里 :

DB::listen(function($sql) {  
            foreach ($sql->bindings as $i => $binding) {  
                if ($binding instanceof \DateTime) {  
                    $sql->bindings[$i] = $binding->format('\'Y-m-d H:i:s\'');  
                } else {  
                    if (is_string($binding)) {  
                        $sql->bindings[$i] = "'$binding'";  
                    }  
                }  
            }  
            $query = str_replace(array('%', '?'), array('%%', '%s'), $sql->sql);  
            $query = vsprintf($query, $sql->bindings); var_dump($query);  
        });