Laravel5.5直近のクエリ分を出力確認

・文字列として出力する。

$sql = User::orderBy('id', 'desc')->toSql();
var_dump($sql);

出力結果

'select * from `users` where `users`.`deleted_at` is null order by `id` desc' (length=75)

・詳細を出力する。

DB::enableQueryLog();
$users = User::orderBy('id', 'desc')->paginate(30);
dd(DB::getQueryLog());

出力結果

array:2 [▼
  0 => array:3 [▼
    "query" => "select count(*) as aggregate from `users` where `users`.`deleted_at` is null"
    "bindings" => []
    "time" => 0.43
  ]
  1 => array:3 [▼
    "query" => "select * from `users` where `users`.`deleted_at` is null order by `id` desc limit 20 offset 0"
    "bindings" => []
    "time" => 0.51
  ]
]