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

laravel enable query log

Add Answer

xcv answered on April 29, 2020 Popularity 9/10 Helpfulness 2/10

answer laravel enable query log

related How to Log Query in Laravel

related laravel enable query log

related How to Log Query in Laravel

related laravel log all queries

related query log laravel

related larave log all query

related enable query log laravel

related query log laravel

related laravel log query for model

laravel enable query log

Comment

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

Popularity 9/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Jul 20 2022

xcv

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

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

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

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

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

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

Comment

-1

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

Popularity 9/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jan 20 2022

Tough Turkey

0 Answers Avg Quality 2/10

laravel enable query log

Contents

More Related Answers

laravel enable query log

Closely Related Answers

How to Log Query in Laravel

laravel enable query log

How to Log Query in Laravel

laravel log all queries

query log laravel

larave log all query

enable query log laravel

query log laravel

laravel log query for model

Grepper

Documentation

Social

Legal

Contact

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