laravel中的一些简单实用功能

composer require symfony/var-dumper 

 public function index()
 {
  DB::connection()->enableQueryLog(); // 开启查询日志
  
  DB::table(\'posts\')->paginate(5); //要查看的sql

  $queries = DB::getQueryLog(); // 获取查询日志

  dd($queries); // 即可查看执行的sql，执行的时间，传入的参数等等
 }

DB::table(\'posts\')->toSql();

<?php

namespace App\\Providers;

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

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

 /**
  * Register any application services.
  *
  * @return void
  */
 public function register()
 {
  //
 }
}

Issue::saving(function(Issue $issue){
 if ($issue->isDirty(\' \')) {
  $user = Auth::user()->username;
  $old  = $issue->getOriginal(\' \'); // 原始值
  $new  = $issue-> ;    // 新值
  ActionLog::log(\"$user 把标题 $old  修改为 $new \");
 }
});