dietercoopman/laravel-showsql

A Laravel package to output a specific sql to your favourite debugging tool. The supported log output is Laravel Telescope, Laravel Log, Ray, Clockwork, Laravel Debugbar and your browser.

Laravel showsql

A Laravel package to output a specific sql to your favourite debugging tool, your browser or your log file.

Use case

You often want to draw the attention and look into one single sql while you are developing. You can look up your sql in your favourite debugging tool in the sql tab , but most of the time your sql is not the only sql executed ... So the searching begins. With this package you can add showSql() to your QueryBuilder and the single sql will be outputted to the logging of your debug tool.

The supported log output is Laravel Telescope, Laravel Log, Ray, Clockwork, Laravel Debugbar and your browser. By default, showSql will try to log to Ray, Clockwork or the Laravel Debugbar if one of them is installed. If all installed it will be output to all. If you want your own log implementation you can pass a callback to showSql.

If you want to change this behaviour you can publish the config file and change it.

Compatibility

This package can be installed in Laravel 6,7,8,9 and 10

Installation

composer require dietercoopman/laravel-showsql --dev

Examples

# With the Eloquent Builder

Menu::showSql()->get();

Menu::whereId(1)->showSql()->get();

Menu::whereHas('status')->showSql()->get();

# With the Query Builder

DB::table('menus')->where('id', '=', 10)->showSql()->get();

DB::table('menus')->join('statuses', 'statuses.id', '=', 'menus.status_id')
                 ->showSql()
                 ->get();

# With a callback 

$callback = function(string $sql){
  Log::info($sql);
};

DB::table('products')->where('id', '=', 1)->showSql($callback)->get();

This is an example log output

Configuration

You can publish the config file with the following command

php artisan vendor:publish --tag=showsql-config 

Laravel showsql is default configured to output to ray,clockwork and laravel debugbar. If you want to change this you can do it in the published config file.

return [
    'to' => [
        'telescope' => false,
        'ray' => true,
        'clockwork' => true,
        'debugbar' => true,
        'log' => false,
        'browser' => false,
    ]
];

Why is this not available in the core of Laravel?

I've created a pull request to the framework that has been declined. It adds too much extra logic to the framework itself. The queries as generated in this code are actual not the real statements as passed to your database engines. The real sql never lives in the framework. The query and bindings are passed separately to the database engine and constructed there. So there might be some edge cases. You can see my pull request here

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Dieter Coopman
• All Contributors

License

The MIT License (MIT). Please see License File for more information.

laravel-showsql's Issues

minimum versions required

I can't see anywhere minimum version sequired, so I tried to install, but it seems PHP 7.4 is not enough :-(

"Problem 1
- dietercoopman/laravel-showsql v1.1 requires php ^8.0 -> your php version (7.4.26) does not satisfy that requirement."

Is this correct?

Incompatibility with Laravel ide-helper.

As you may be aware, this packages is widely use.
When I run ide-helper commands I get the following output

I highly advise adding support for this package.

Eager loading using with() not supported

Queries fired by using the with method are not logged. For example, the query below will not show any query related to fetching the users:

$post->comments()->with('users')->showSql()->get()

Discussion not working despite link in "New Issue" screen

This package does not count for the deleted_at column

The title.

Showsql need an arguments

Hello Dieter
I'm trying the package and this happens, am I doing something wrong !!

$res = Reservation::showSql()->get();

"message": "Too few arguments to function Illuminate\Database\Query\Builder::Dietercoopman\Showsql\{closure}(), 0 passed in vendor/laravel/framework/src/Illuminate/Macroable/Traits/Macroable.php on line 114 and exactly 1 expected",