This extension shows sql queries and execution time in simple table view. You can see which of the SQL process take a lot of time and optimize your code.
- Magento v2.4.1 (Should work on previous versions. Not tested)
composer require ityetti/database-profiler
- Open project config file
app/etc/env.php
and add profiler class to your configuration:
'db' => [
'connection' => [
'default' => [
'profiler' => [
'class' => '\Magento\Framework\DB\Profiler',
'enabled' => true
]
]
]
]
bin/magento module:enable ITYetti_DatabaseProfiler
bin/magento setup:upgrade
- Go to Admin - Store - Configuration - ITYetti - Database Profiler
Enable On Frontend
- YesEnable On Backend
- Yes
composer remove ityetti/database-profiler
If you have any issues with this extension, open an issue on GitHub.
Any contribution is highly appreciated. The best way to contribute code is to open a pull request on GitHub.
Oleksii Borovyk
https://github.com/ityetti