Laravel - how to see source of queries?

Question

I know you can log queries in Laravel. But I'm wondering if there's a way to also log the name of the script that ran the query. So for instance, if an update query was logged, I'd like to also know that it was initiated by PostController.php.

I'm working on a very large application that uses hundreds of queries, and when I need to remove one, it's very difficult to locate where that query is coming from.

Any ideas?

I think of make an syntax error with my SQL, to identify the caller from exception stack, kind of debugging — Abdelrahman M. Allam
– Abdelrahman M. Allam, Commented Mar 3, 2018 at 0:03

Gras Double · Accepted Answer · 2018-03-03 00:24:58Z

2

As you can see in Connection::logQuery(), each database query triggers a QueryExecuted event.

You could listen to this event, and use debug_backtrace() to crawl up the function calls.

use Illuminate\Support\Facades\DB;

DB::listen(function ($query) {

    // send this to a log or whatever
    $backtrace = debug_backtrace();

    // also, you can read $query to get the SQL string, bindings...
});

The main work will probably be to filter the data, to isolate what you are looking for.

edited Mar 3, 2018 at 0:24

answered Mar 3, 2018 at 0:16

Gras Double

16.5k9 gold badges61 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Laravel - how to see source of queries?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related