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.
- Download the module files and copy them to the root of your Magento install folder.
- Open your app/etc/local.xml and add
<profiler>1</profiler>inside the<connection>node. - Login to admin and enable the module in System -> Configuration -> Advanced -> Developer -> LDusan QueryTrace.
- Clear cache.
- Better styling and UI
- Eliminate XDebug dependency with debug_backtrace()
- Composer installer
- Shell script that enables the module