Breaking News: Grepper is joining You.com. Read the official announcement!

query log laravel

Add Answer

Kriss Sachintha answered on April 29, 2020 Popularity 9/10 Helpfulness 1/10

answer query log laravel

related How to Log Query in Laravel

related eloquent get query log

related laravel enable query log

related How to Log Query in Laravel

related laravel log all queries

related how get query logs in laravel

related query log laravel

related laravel log query for model (full)

related larave log all query

related enable query log laravel

query log laravel

Comment

check whethe the serviceprovider is added in the providers array in config/app.php
 if no then check whether the service provider class is the correct location and 
   include the serivce provider in the providers array in config.app.php

Popularity 9/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Kriss Sachintha

0 Answers Avg Quality 2/10

Closely Related Answers

How to Log Query in Laravel

Comment

DB::enableQueryLog();
$arr_user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());

Popularity 10/10 Helpfulness 10/10 Language php

Source: artisansweb.net

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Apr 29 2020

Indian Gooner

0 Answers Avg Quality 2/10

eloquent get query log

Comment

 DB::connection()->enableQueryLog(); //enable query log
 $data = $order->all(); //query execute
 $queries = DB::getQueryLog(); //get query
 return dd($queries); //show query

Popularity 8/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: eloquent eloquen

Link to this answer
Share Copy Link

Contributed on Dec 11 2020

badb0y

0 Answers Avg Quality 2/10

laravel enable query log

Comment

use Illuminate\Support\Facades\DB;
...
...
 
public function UserController()
{
    DB::enableQueryLog();
    $arr_user = DB::table('users')->select('name', 'email as user_email')->get();
    dd(DB::getQueryLog());
}

Popularity 9/10 Helpfulness 7/10 Language php

Source: artisansweb.net

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jul 20 2022

xcv

0 Answers Avg Quality 2/10

How to Log Query in Laravel

Comment

DB::enableQueryLog();
$user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());

Popularity 10/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

Tyagi420

0 Answers Avg Quality 2/10

laravel log all queries

Comment

//AppServiceProvider add boot function
if (config('app.debug')) {
   DB::connection()->enableQueryLog();
}
//function formatSize
public static function formatSize(int $bytes): string
{
    if ($bytes < 1000 * 1024) {
         return number_format($bytes / 1024, 2).' KB';
    }
    if ($bytes < 1000 * 1048576) {
        return number_format($bytes / 1048576, 2).' MB';
    }
    if ($bytes < 1000 * 1073741824) {
        return number_format($bytes / 1073741824, 2).' GB';
    }
  return number_format($bytes / 1099511627776, 2).' TB';
}

//debug.blade.php
@php
    /** @var \App\Models\User $user */
        $user = auth()->user();
        $queries = ($user->id === 1 && auth()->check()) ? Illuminate\Support\Facades\DB::getQueryLog() : [];
@endphp
@if(count($queries) > 0)
    <div class="btn" data-bs-toggle="modal" data-bs-target="#sqlQueryLogModal">
        <a href="#" data-toggle="modal" data-target=".query_log_modal">SQL: <?= count($queries) ?></a>,
        {{ \App\Services\AdminService::formatSize(memory_get_usage()) }} {{ round(microtime(true) - LARAVEL_START, 2) }} sec.
    </div>
    @if(!empty($queries))
        <div class="modal fade" id="sqlQueryLogModal" tabindex="-1" aria-labelledby="sqlQueryLogModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-xl" role="document">
                <div class="modal-content">
                    <div class="modal-header align-items-center">
                        <h4 class="modal-title">System Sql query log</h4>
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                    </div>
                    <div class="modal-body p-2">
                        <table class="table table-sm table-bordered">
                            <thead>
                            <tr class="bg-light">
                                <th scope="col" class="border-top-0">#</th>
                                <th scope="col" class="border-top-0">Query</th>
                                <th scope="col" class="border-top-0 text-center">Bindings</th>
                                <th scope="col" class="border-top-0 text-center">Time</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach($queries as $k => $query)
                                <tr>
                                    <th scope="row">{{ $k + 1 }}</th>
                                    <td style=" text-align: left; ">
                                        <code style="white-space: pre-wrap; word-wrap: break-word; margin: 0; ">{{ $query['query'] }}</code>
                                    </td>
                                    <td class="text-center">
                                        @if(!empty($query['bindings']))
                                            @foreach($query['bindings'] as $binding)
                                                <span class="badge bg-secondary">{{ $binding }}</span>
                                            @endforeach
                                        @endif
                                    </td>
                                    <td class="text-center"><span class="badge bg-secondary">{{ $query['time'] }} ms</span></td>
                                </tr>
                            @endforeach
                            <tr>
                                <th scope="row" colspan="3">Total time</th>
                                <td><span class="badge bg-secondary">{{ round(microtime(true) - LARAVEL_START, 2) }} sec.</span></td>
                            </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    @endif
@endif

Popularity 7/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Oct 10 2023

Shadow

0 Answers Avg Quality 2/10

how get query logs in laravel

Comment

Method #1
instead of ->get use ->toSql() on query 
$users = User::orderBy('name', 'asc')->toSql();

echo $users;

// Outputs the string:
'select * from `users` order by `name` asc'
Method # 2

DB::enableQueryLog();

// and then you can get query log

dd(DB::getQueryLog());

Popularity 9/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: get

Link to this answer
Share Copy Link

Contributed on Nov 30 2021

shafeeque

0 Answers Avg Quality 2/10

query log laravel

Comment

import DB with this line first, 
use Illuminate\Support\Facades\DB;

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Sep 07 2022

Kriss Sachintha

0 Answers Avg Quality 2/10

laravel log query for model (full)

Comment

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

    // ...
}

Popularity 7/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: laravel model php

Link to this answer
Share Copy Link

Contributed on Jan 20 2022

Tough Turkey

0 Answers Avg Quality 2/10

larave log all query

Comment

DB::listen(function ($query) {
    var_dump([
        $query->sql,
        $query->bindings,
        $query->time
    ]);
});

Popularity 8/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: php

Link to this answer
Share Copy Link

Contributed on Oct 07 2022

Anzal PA

0 Answers Avg Quality 2/10

enable query log laravel

Comment

DB::enableQueryLog();
$arr_user = DB::table('users')->select('name', 'email as user_email')->get();
dd(DB::getQueryLog());

Popularity 8/10 Helpfulness 2/10 Language php

Source: Grepper

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Mar 25 2023

Angry Albatross

0 Answers Avg Quality 2/10

query log laravel

Contents

More Related Answers

query log laravel

Closely Related Answers

How to Log Query in Laravel

eloquent get query log

laravel enable query log

How to Log Query in Laravel

laravel log all queries

how get query logs in laravel

query log laravel

laravel log query for model (full)

larave log all query

enable query log laravel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.