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: stackoverflow.com/questions/19131731/… — Collin James
– Collin James, Commented Dec 6, 2013 at 20:05

Antonio Carlos Ribeiro · Accepted Answer · 2013-12-06 18:17:37Z

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 6, 2013 at 18:17

Antonio Carlos Ribeiro

87.9k22 gold badges220 silver badges205 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Its Aafrin · Accepted Answer · 2013-12-12 00:00:29Z

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, 2013 at 0:00

Its Aafrin

592 bronze badges

Collectives™ on Stack Overflow

Laravel how to see executed queries from terminal

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related