gtstudio/module-querylog

Show the slowest SQL queries on the storefront.

Maintainers

Details

github.com/gabrielgts/magento2-query-log

Source

Issues

Installs: 49

Dependents: 0

Suggesters: 0

Security: 0

Stars: 25

Watchers: 2

Forks: 6

Open Issues: 0

Type:magento2-module

1.0.1 2023-04-26 00:48 UTC

Requires

  • php: ^7.2||^8.1
  • magento/framework: *

MIT 1bcea66dd6ce5f6689dcc869fa43ebb7ab943b5c

  • Gabriel <gabrielt.gts.woop@gmail.com>

This package is auto-updated.

Last update: 2024-11-05 05:10:05 UTC

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.