How to Get Last Executed Query in Laravel?

How to Get Last Executed Query in Laravel?

In this post we will give you information about How to Get Last Executed Query in Laravel?. Hear we will give you detail about How to Get Last Executed Query in Laravel?And how to use it also give you demo for it if it is necessary.

We have been many time need to get executed query log or you want to get last executed query or maybe if you want to diaplsy sql query from laravel query builder then you can do it that. so i have three example for display executed query in Laravel 5. when you are working on laravel application at that times , i think you need many time to print last run query or if you want to check direct from phpmyadmin sql box, so at that time you have to follow this three example. so, let’s see three example of getting sql query from Laravel Query Builder.

Example 1:

In this example we can get directly get current sql query using toSql() of laravel query builder. In this example you don’t need to enable query log or something you can directly query like bellow example:

$user = User::where('id',1)->toSql();

print_r($user);

Example 2:

Ok, In this example we must need to enable query log using DB::enableQueryLog() of Laravel Query builder. enableQueryLog() will give access to store all execute query in cache and we can get that query using DB::getQueryLog(). In this example you will get all query log not last only. bellow example how to use it together.

DB::enableQueryLog();

$user = User::get();

$query = DB::getQueryLog();

print_r($query);

Example 3:

In this example i make the same as example 2, but you can get exactly last query using end(). so let’s see how to use.

DB::enableQueryLog();

$user = User::get();

$query = DB::getQueryLog();

$query = end($query);

print_r($query);

You can try any one….

Hope this code and post will helped you for implement How to Get Last Executed Query in Laravel?. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

47  +    =  48

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US