Laravel Eloquent display query log

Question

use App\Order;
 
public function show(Order $order) {
    $data = $order->all();
    return dd($order->getQueryLog());

Is there any way to display the query built by Eloquent in Laravel?

I tried getQueryLog(); but its not working

Possible duplicate of [How to get the query executed in Laravel 5 ? DB::getQueryLog returning empty array](http://stackoverflow.com/questions/27753868/how-to-get-the-query-executed-in-laravel-5-dbgetquerylog-returning-empty-arr) — Raunak Gupta, Dec 14 '16 at 13:23

score 146 · Accepted Answer · edited Apr 01 '21 at 11:19

146

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);
}

edited Apr 01 '21 at 11:19

julianstark999

3,225
1
28
38

answered Dec 14 '16 at 11:05

kapilpatwa93

3,583
1
12
22

is this only for DB query? I'm using eloquent, and I want to see laravel's query – Benjamin W Dec 14 '16 at 11:11
it will work for eloquent as well, check the updated answer I have shown in the example – kapilpatwa93 Dec 14 '16 at 11:12
oh i didnt know I need to put enableQueryLog(); before my query, i put it behind lol, thx a lot! – Benjamin W Dec 14 '16 at 11:15

Muhammad · Answer 2 · 2021-10-27T15:46:16.787

51

To see the query logs in laravel.log file you can do it as below.

namespace App\Providers;

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

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
            );
        });
    }

    // ...
}

edited Oct 27 '21 at 15:46

answered Aug 16 '19 at 06:36

Muhammad

5,693
4
39
54

4

Wow, I wish I knew about this years ago. So helpful! Thanks. – Ryan Feb 19 '20 at 19:18

score 22 · Answer 3 · answered Dec 14 '16 at 11:03

To use getQueryLog() you need to enable it first:

DB::enableQueryLog();
DB::getQueryLog();

If you want to see real queries, you can use Laravel Debugbar, it will show all real queries Laravel created during current request.

Sometimes ->toSql() is also useful.

markdwhite · Answer 4 · 2018-11-02T10:36:46.633

Working on 5.6, something like this in AppServiceProvider::boot()

    // Log all DB SELECT statements
    // @codeCoverageIgnoreStart
    if (!app()->environment('testing') && config('app.log_sql')) {
        DB::listen(function ($query) {
            if (preg_match('/^select/', $query->sql)) {
                Log::info('sql: ' .  $query->sql);
                // Also available are $query->bindings and $query->time.
            }
        });
    }

Then in config/app.php, just so it's easy to enable/disable from amending the .env

    'log_sql' => env('LOG_SQL'),

All credit to: https://arjunphp.com/laravel-5-5-log-eloquent-queries/

And this can be parsed for unique queries with:

    grep ") sql:" laravel.log | sed -e "s#.*select\(.*\)\[\]#select\1#" | sort -u

score 3 · Answer 5 · answered Sep 12 '18 at 20:19

I know it's an old question, but it might help others that had the same issue I had.

If you use other connection than the default one, you should specify it to get the query log properly.

\DB::connection('YourConnection')->enableQueryLog();
$test = MyModel::all();
$queries = \DB::connection('YourConnection')->getQueryLog();
dd($queries);

score 3 · Answer 6 · edited Jan 14 '21 at 14:04

3

write this before the query DB::enableQueryLog();

DB::enableQueryLog();

$data = $order->all();

$query = DB::getQueryLog();

dd($query);

edited Jan 14 '21 at 14:04

Code Lღver

15,434
16
54
74

answered Aug 24 '20 at 07:33

Abid Shah

245
2
3

score 3 · Answer 7 · answered Mar 14 '21 at 08:11

Query Execution

\Event::listen('Illuminate\Database\Events\QueryExecuted', function ($query) {          
            $sql = $query->sql; 
            $time = $query->time;
            $connection = $query->connection->getName();
 
            Log::debug('query : '.$sql);
            Log::debug('time '.$time);
            Log::debug('connection '.$connection);
        });

Query

StaffRegister::all();

Output

[2021-03-14 08:00:57] local.DEBUG: query : select * from `staff_registers`  
[2021-03-14 08:00:57] local.DEBUG: time 0.93  
[2021-03-14 08:00:57] local.DEBUG: connection mysql

complete structure

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Log;
use App\Models\StaffRegister;

class AuthController extends Controller
{
   public function index(){
   
       \Event::listen('Illuminate\Database\Events\QueryExecuted', function ($query) {
      
           $sql = $query->sql; 
           $time = $query->time;
           $connection = $query->connection->getName();

           Log::debug('query : '.$sql);
           Log::debug('time '.$time);
           Log::debug('connection '.$connection);
       });

       $obj = StaffRegister::all(); 
    
       return $obj;
   }
}

Accurate Method

score 2 · Answer 8 · answered Aug 12 '20 at 17:48

2

You can use this package https://github.com/supliu/laravel-query-monitor

Após instalar, abra o terminal e execute o comando:

php artisan laravel-query-monitor

All queries executed by Eloquent will be displayed in real time

answered Aug 12 '20 at 17:48

Jansen Felipe

76
9

Elisha Senoo · Answer 9 · 2018-11-02T11:11:34.960

1

You can use ::toSql() or ->toSql() as demonstrated below:

use App\Order;

public function show(Order $order){

    return $order::toSql();

Or

use App\Order;

public function show(Order $order){

    return $order::where("id", "<>", 0)->toSql();

You might have to enable query log:

DB::enableQueryLog();

edited Nov 02 '18 at 11:11

answered Nov 02 '18 at 11:00

Elisha Senoo

3,321
2
23
29

score 1 · Answer 10 · answered Jul 21 '20 at 12:14

You can use my Laravel package which is work perfectly in Larave 6 and 7. (Not sure about laravel 5 or less.)

For use Install the package via composer: by following command

composer require dipenparmar12/laravel-query-log

restart server. after this you will see

storage/logs/db-query.log file containing your query logs.

For more details visit Laravel-query-log

Thanks

score 0 · Answer 11 · answered Mar 22 '22 at 11:56

If you are using Laravel 6+ (i have not checked below 6), you can use

// show sql and bindings  +  stop execution
DB::table('your_table')->dd();   

// show sql and bindings
DB::table('your_table')->dump();

https://laravel.com/docs/7.x/queries#debugging

Laravel Eloquent display query log

11 Answers11

Linked