How to exclude cache-related queries from the Queries tab in Laravel Debugbar?

[nekooee]

Hi,

I'm using Laravel Debugbar with Laravel 11, and I noticed that cache lookups (e.g. select * from cache where key in (?)) are now shown in the Queries tab.

In previous versions, cache reads (especially when using the file cache driver) were not listed as queries. But now, even if the cache driver is set to file, a cache lookup is shown as a query — which makes it hard to distinguish real database queries from internal cache checks.

This affects how I measure and optimize database usage, as the total number of queries shown is inflated by cache lookups.

Is there a way to exclude cache-related queries from being recorded or shown in the Debugbar's query tab?
If not, would it make sense to add an option like exclude_cache_queries in the config?

Thanks in advance for any guidance.

[erikn69]

Maybe you can exclude based on the file

laravel-debugbar/config/debugbar.php

Lines 220 to 222 in 0cd8c86

	'exclude_paths' => [ // Paths to exclude entirely from the collector
	// 'vendor/laravel/framework/src/Illuminate/Session', // Exclude sessions queries
	],

[nekooee]

Maybe you can exclude based on the file

laravel-debugbar/config/debugbar.php

Lines 220 to 222 in 0cd8c86

         'exclude_paths'     => [       // Paths to exclude entirely from the collector 

// 'vendor/laravel/framework/src/Illuminate/Session', // Exclude sessions queries
],

Thank you for getting back to me!

I excluded the vendor/laravel/framework/src/Illuminate/Cache path, but it doesn't seem to affect the query count. The queries from that path are no longer shown, but they're still being counted in the total number of queries.
Here's a screenshot to show what I mean:

[erikn69]

First activate the option to show the actual file that executes the query, so you can exclude the real file

Second, it seems to me that you are using database on SESSION DRIVER, so it would not be the cache, but the session, and in this case it would be correct for it to appear, because queries are being made to the db

[erikn69]

cache-related queries are no longer shown — but they are still being counted in the total number of queries.
cache-related queries are hidden with the exclude path, they’re still being counted in the total.

I understand now, I see that it is the expected behavior, all the executed queries are counted, because even if they are excluded, they were executed in the db
I don't think Barry wants to change that behavior, and adding more settings like exclude_and_not_count would be a bit overkill to me.

There is no configuration for that, the only option is to create a custom collector that works as you expect.

You could also use another cache manager.