Laravel how to see executed queries from terminal

Question

I am new to Laravel PHP framework. Is there any way to see executed queries from terminal. The default log file only giving me exception error. I also tried with profiler which give the queries in the browser but I want to see it from terminal.

See my answer here: http://stackoverflow.com/questions/19131731/laravel-4-logging-sql-queries/19193395#19193395 — Collin James, Dec 06 '13 at 20:05

score 2 · Answer 1 · answered Dec 06 '13 at 18:17

2

You can add this to your app/start/global.php:

DB::listen(function($sql, $bindings, $time) { 
    Log::info($sql);
});

And then they will automatically appear in your log file.

answered Dec 06 '13 at 18:17

Antonio Carlos Ribeiro

86,191
22
213
204

score 0 · Answer 2 · answered Dec 12 '13 at 00:00

0

In Laravel 3 the profiler can be enabled to true at application/config/application.php and application/config/database.php. You will get a query log in the bottom of the page.

In Laravel 4, the DB::getQueryLog() can be used.

answered Dec 12 '13 at 00:00

Its Aafrin

59
2

Laravel how to see executed queries from terminal

2 Answers2