Easily capture full SQL queries in Laravel (tested in 5.2), useful for quickly inspecting queries inside controllers and scoping certain blocks of code

laravel-sql-capture.php

<?php

  \DB::enableQueryLog();
  
  // Code that triggers DB queries (User::create(), User::with('relation')->get(), etc)
  
  $pdo = \DB::getPdo();
  $queries = collect(\DB::getQueryLog())->map(function($log) use ($pdo) {
      $query = $log['query'];
      foreach($log['bindings'] as $binding) {
          $query = preg_replace('/\?/', $pdo->quote($binding), $query, 1);
      }
      return $query;
  });
  
  dd($queries); // or \Log::debug($queries);