gtstudio / module-querylog
Show the slowest SQL queries on the storefront.
Installs: 50
Dependents: 0
Suggesters: 0
Security: 0
Stars: 25
Watchers: 2
Forks: 6
Open Issues: 0
Type:magento2-module
Requires
- php: ^7.2||^8.1
- magento/framework: *
README
gtstudio/module-querylog
Main Functionalities
This module helps you to debug and find database query bottlenecks. You will be able to see the query execution time, stack trace through the front end of the store in real time.
Installation
* = in production please use the --keep-generated
option
Type 1: Zip file
- Unzip the zip file in
app/code/Gtstudio
- Enable the module by running
php bin/magento module:enable Gtstudio_QueryLog
- Apply database updates by running
php bin/magento setup:upgrade
* - Flush the cache by running
php bin/magento cache:flush
Type 2: Composer
- Install the module composer by running
composer require gtstudio/module-querylog
- enable the module by running
php bin/magento module:enable Gtstudio_QueryLog
- apply database updates by running
php bin/magento setup:upgrade
* - Flush the cache by running
php bin/magento cache:flush
Specifications
-
Console Command
- dev:query-view:enable
-
Console Command
- dev:query-view:disable
Usage
To enable you just need to run the following command :
bin/magento dev:query-view:enable --include-all-queries=1 --query-time-threshold=0.001 --include-call-stack=1
.
To disable you must run the following command :
bin/magento dev:query-view:disable
.