Laravel Eloquent display query log

by

First you have to enable query log
it can be done using

DB::connection()->enableQueryLog();

then you can use below code to see the query log

$queries = DB::getQueryLog();

if you want to see the last executed query

$last_query = end($queries);

to know more about logging see this https://laravel.com/docs/5.0/database#query-logging

Example

public function show(Order $order){
    \DB::connection()->enableQueryLog();
    $data = $order->all();
    $queries = \DB::getQueryLog();
    return dd($queries);
}

More Related Contents:

  1. How to Convert string response to array laravel
  2. Difference between method calls $model->relation(); and $model->relation;
  3. Ajax LARAVEL 419 POST error
  4. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  5. Laravel 5.2 $errors not appearing in Blade
  6. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  7. Laravel 5.3 auth check in constructor returning false
  8. Composer killed while updating
  9. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  10. Laravel Advanced Wheres how to pass variable into function?
  11. How can I paginate a merged collection in Laravel 5?
  12. Laravel 4 removing public from URL
  13. ReflectionException: Class ClassName does not exist – Laravel
  14. Laravel 5.2 CORS, GET not working with preflight OPTIONS
  15. laravel model callbacks after save, before save, etc
  16. Laravel 5.1: keep uploaded file as old input
  17. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  18. How to Make Laravel Eloquent “IN” Query?
  19. How to store and retrieve image contents from the database using Laravel
  20. Route [login] not defined
  21. My Laravel 5.2.10 Sessions wont persist
  22. Composer: file_put_contents(./composer.json): failed to open stream: Permission denied
  23. Laravel Eager Loading – Load only specific columns
  24. Mysql InnoDB engine in Laravel
  25. Laravel catch Eloquent “Unique” field error
  26. ErrorException : implode(): Passing glue string after array is deprecated. Swap the parameters
  27. How should I serve an image with Laravel?
  28. Expected response code 250 but got code “”, with message “”
  29. How to get last insert id in Eloquent ORM laravel
  30. How Can I Remove “public/index.php” in the Laravel Url generated? [duplicate]

Leave a Comment