How to Optimizing Query Performance in Laravel

In this article, we will explore the process of checking the execution time of queries in Laravel. By the end, you will clearly understand how to obtain the query execution time in Laravel. Additionally, we will provide practical examples, ensuring you grasp the concept effectively.

This tutorial is applicable to various versions of Laravel, including 6, 7, 8, 9, and 10.

If you're specifically interested in obtaining the SQL query execution time in Laravel, we will present two examples for your convenience. We will use the 'microtime()' function and the 'enableQueryLog()' feature to accurately calculate the query execution time in Laravel.

 so, let's see the simple example code:

Demonstration: 1

TestController.php

<?php

     

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

class TestController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return \Illuminate\Http\Response

     */

    public function index(Request $request)

    {

        $startTime = microtime(true);

        $users = User::get();

        $endTime = microtime(true);   

        $executionTime = $endTime - $startTime;

        dd("Query excutionTime :-  " . $executionTime );

    }

}

Output:

Query ExcutionTime:-  0.0032229423522949

Demonstration: 2 

TestController.php

<?php

     

namespace App\Http\Controllers;

    

use Illuminate\Http\Request;

use App\Models\User;

use DB;

    

class TestController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return \Illuminate\Http\Response

     */

    public function index(Request $request)

    {

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

        $users = User::get();

        $queries = DB::getQueryLog();

        dd($queries);

    }

}

Output:

array:1 [ // app/Http/Controllers/TestController.php

  0 => array:3 [

    "query" => "select * from `users`"

    "bindings" => []

    "time" => 1.79

  ]

]

If you like this blog please add a comment I will create more blogs regarding your requirements.

Thank you :)