PHP

How to Debug Sql Queries in Laravel2 min read

How to debug SQL queries in Laravel & Lumen. During development of an application, there may be times when we need to write large and complex queries. Laravel provides an awesome query builder and ORM (Eloquent) to do this task effortlessly. But sometimes we would like to see the actual SQL being generated.

In this tutorial, we are going to learn different ways to debug SQL queries in Laravel.

How to Debug SQL Queries in Laravel & Lumen




For better understanding, let’s take an eloquent query and then we try to generate the raw SQL query from that.

To generate the raw SQL query, we can simply use Laravel toSql() method. Let’s try it and see the result.

Laravel toSql() method is good for seeing the raw SQL query. But what about query bindings. How do we see the query bindings ? Let’s check the Laravel getBindings() method.

Enable and Print Query Log

In Laravel, query log is disabled by default we can enable it and print the query log.

Register Event Listener

Another option is to listen for query events on the DB object.

Using DB::listen we can print SQL query, parameter bindings and the time taken by the query to run.

1 Comment

  • Hello

    What is the procedure to publish a guest post here?

    Post regarding Any programming language.

Leave a Comment