How to get last executed mysql query in laravel ?

By Hardik Savani | January 11, 2016 | | 1829 Viewer | Category : Laravel MySql


If you are working on laravel framwork and you use query builder of laravel 5. but you want to get last executed mysql query from laravel. If you are working on laravel 5 then you have to first enable query log that way it can be store query log. At last getQueryLog() through you can get last executed query.

I give you example of how to get last executed mysql query. you can use example as following example.

public function querylog()

{

DB::enableQueryLog();

$item = Item::find(2);

$last_query = DB::getQueryLog();

print_r($last_query);

}

Try this.............