Skip to content

Magento SQL profiler that shows SQL queries that were executed with stack traces.

Notifications You must be signed in to change notification settings

ldusan84/LDusan_QueryTrace

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 

Repository files navigation

Description

Simple Magento SQL query profiler that shows SQL statements executed during a request along with stack traces.

If you inherit a legacy project or install a Magento theme, chances are that your Magento website might get slow because of unnecessary SQL queries being executed. I have tried a few profiling tools, but they weren't as simple and concise as I wanted, so I built a quick tool for a project I worked on. It just shows all the queries in a table and you can easily track where are they coming from.

Note: Requres XDebug at the moment.

Installation

  1. Download the module files and copy them to the root of your Magento install folder.
  2. Open your app/etc/local.xml and add <profiler>1</profiler> inside the <connection> node.
  3. Login to admin and enable the module in System -> Configuration -> Advanced -> Developer -> LDusan QueryTrace.
  4. Clear cache.

Screenshots

Screenshot 1 Screenshot 2

TODO

  • Better styling and UI
  • Eliminate XDebug dependency with debug_backtrace()
  • Composer installer
  • Shell script that enables the module

About

Magento SQL profiler that shows SQL queries that were executed with stack traces.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published