How to enable the query logs in laravel 5

Question

I have been searching from a while how can I log the sql queries executed in "laravel/framework": "5.0.*"

But everything I found is about the version 4 , have not found any working solution for 5.0 like these: Get the query executed in Laravel 3/4 and How to get the query executed in Laravel 5 ? DB::getQueryLog returning empty array and http://laravelsnippets.com/snippets/log-db-queries

Some are describe how to use it in laravel 5 but it doesn't seems to be working for me. I just want to write the sql logs in file. That's all, can any one tell me how can I do it.

Many thanks in advance.

I have followed this one also. http://www.techigniter.in/tutorials/query-logging-in-laravel-5/ — User, May 25 '15 at 10:06
If you are using ubuntu, have you given the write permission to your log file ? — Sulthan Allaudeen, May 25 '15 at 10:13
I think i found the solution it was just about that middle ware should load with application starts like this https://mattstauffer.co/blog/laravel-5.0-middleware-filter-style — User, May 25 '15 at 10:29
Yes ofcourse, this [image](http://stackphp.com/img/onion.png) explains a lot :) and i referred initially .. You able to retrieve query after the middleware ? — Sulthan Allaudeen, May 25 '15 at 10:30
You're welcome, I have posted an answer for the future readers :) — Sulthan Allaudeen, May 25 '15 at 10:33

score 1 · Accepted Answer · answered May 25 '15 at 10:33

1

You should enable DB::enableQueryLog(); and you should able to get the query after your middle ware.

Here is the image which explains soundly enter image description here

Thanks to Mattstauffer

answered May 25 '15 at 10:33

Sulthan Allaudeen

11,330
12
48
63

How to enable the query logs in laravel 5

1 Answers1