With mysqlreport you can analyze and profile all SQL queries created by
ConnectionPool and Doctrine QueryBuilder.
After installation, visit the extension configuration in the Extension Manager. Here you can activate logging for FE and/or BE queries. With an additional checkbox you can activate detailed profiling for each query. Be careful with this last checkbox: it may slow down your system drastically.
After saving the extension configuration you will find a new TYPO3 module in the backend. Switch between the different reports by selecting them with the select box at the top.
Happy reading and analyzing!
Please deactivate logging after analyzing. Otherwise, you will flood your database with a huge amount of profiling data. There is a new entry in the Clear Cache menu to truncate all profiling data.
Big THX goes to Blackfire.io