Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel : what is $query->time time unit?

According to the Laravel documentation, it is possible to add a listener that will log all SQL queries, and log the query duration.

    public function boot()
{
    DB::listen(function ($query) {
        // $query->sql
        // $query->bindings
        $query->time
    });
}

My problem is that I don't know the unit of $query->time, and I can't find this information in the documentation. By reproducing the queries in the Mysql cli client it seems that the result returned are in deciseconds which seems very strange. Because of that I think that I misunderstood something and that measured time might not represent what I am expecting (the Mysql time to answer).

What is the unit of this element ? Is there a better Laravel documentation that could explain what is measured ?

like image 282
bloub Avatar asked Jan 24 '26 09:01

bloub


1 Answers

The parameter you get there is of type

Illuminate/Database/Events/QueryExecuted

According to this

https://laravel.com/api/8.x/Illuminate/Database/Events/QueryExecuted.html

the time is "The number of milliseconds it took to execute the query."

like image 171
Vitalij Mik Avatar answered Jan 26 '26 22:01

Vitalij Mik



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!