Database
SQL

How To Display Query Log In Laravel 7/6?

Sometime we need to print last executed query in laravel 7/6 application for debug. you want to see what last query run. i will give examples of how to print query login in laravel 7/6. you can simply print last eloquent query in laravel 7/6.

  • 4.5/5.0
  • Last updated 08 September, 2022
  • By Admin

I will print last sql query in laravel 7 using toSql(), DB::enableQueryLog() and DB::getQueryLog(). i will also show you output of print sql query.

So, let's see examples bellow and use as you want any one

Example 1:

Controller Code:

$query = User::select("*")->toSql();
dd($query);
Output:
select * from `users`
Example 2:

Controller Code:

DB::enableQueryLog();
$users = User::select("*")->get();
$quries = DB::getQueryLog();
dd($quries);
Output:
array:1 [▼
  0 => array:3 [▼
    "query" => "select * from `users`"
    "bindings" => []
    "time" => 4.25
  ]
]
Example 3:

Controller Code:

DB::enableQueryLog();
$users = User::select("*")->get();
$query = DB::getQueryLog();
$query = end($query);
dd($query);
Output:
array:3 [▼
  "query" => "select * from `users`"
  "bindings" => []
  "time" => 2.07
]

I hope it can help you...