To enable database monitoring for Laravel Telescope, first install the extension and confirm the configuration. 1. Install with Composer: composer requires laravel/telescope; 2. Release configuration: php artisan telescope:install; 3. Make sure that the QueryWatcher in config/telescope.php is set to true; 4. Access the /telescope page in the local development environment, enter the Queries tag to view SQL statements, binding parameters, execution time and call location; 5. Slow queries can be identified by time-consuming order, or duplicate queries can be found to optimize performance; 6. Note that Telescope is only effective in non-production environments by default to avoid sensitive data leakage.

Laravel Telescope is a powerful debugging tool, especially when debugging database queries. It allows you to intuitively see all SQL statements, binding parameters, execution time and other information executed during the request, helping you quickly locate slow queries or error logic.

How to enable Telescope's database monitoring

First make sure you have Laravel Telescope installed and enabled. If you haven't installed it yet, you can install it with Composer:

 composer requires laravel/telescope

Then run the Publish command:

 php artisan telescope:install

By default, Telescope has enabled database-related listeners. You can check watchers configuration item in config/telescope.php :

 'watchers' => [
    ...
    Laravel\Telescope\Watchers\QueryWatcher::class => true,
],

As long as this configuration is true , all database queries will be recorded in Telescope.

Check the specific database query information

Open the browser to access /telescope page (provided that your environment is a local development environment) and enter the Queries tab. You will see all database queries executed in each request.

Each record contains the following key information:

• Executed SQL original statement
• Bind parameters (with placeholder replacement)
• Time-consuming inquiry
• The file and line number that triggered the query (this is especially useful for positioning issues)

For example, you will find that a query uses where('id', '1') , but the actual generated SQL is where id = ? , and the binding value is displayed as [1] , which means that the parameter binding is normal and can also confirm whether the correct value has been passed in.

Tips: If you see that a query takes a lot of time, you can copy SQL to the database client and execute it manually to see if the index is missing or there is a problem with the statement structure.

Analyze slow queries and duplicate queries

During debugging, there are two common performance problems that can be quickly identified through Telescope:

• Slow query : On the Queries page, you can sort by "Duration" to find the most time-consuming queries.
• Repeat query : Some code may execute the same SQL multiple times in a request, such as calling a model query in a loop. Telescope will record them all to make it easier for you to find this inefficient writing method.

For example, suppose you write this in a Blade template:

 @foreach ($users as $user)
    {{ $user->profile->name }}
@endforeach

If no preloading is done, Telescope will display multiple queries select * from profiles where user_id = ? , which is a typical N 1 problem.

The solution is also very simple, use Eloquent's with() method to preload the associated data:

 $users = User::with('profile')->get();

After refreshing the page, you will find that only one profile query was executed, which greatly improves efficiency.

Notes and tips

• Telescope is only effective in non-production environments by default, so there is no need to worry about exposing sensitive data.
• If you find that Telescope does not record queries, check whether Query Watcher is enabled, and make sure DB::disableQueryLog() is not used in the code.
• For complex query builder operations, Telescope and log output can also be combined to assist in analysis.

Basically that's it. Using Laravel Telescope rationally can save a lot of time in printing logs and debugging variables, especially when troubleshooting database-related problems, the efficiency improvement is very obvious.

The above is the detailed content of Debugging Database Queries using Laravel Telescope?. For more information, please follow other related articles on the PHP Chinese website!