什么是PHP的MySQL调试工具？

Question

I'm looking for something like firebug but to monitor & log all the processed MySQL queries with the syntax, processing time, and fetched rows count and size. All that should be printed on the bottom of the page, so it should be something includable on the finish of the php code.

I'm not using any frameworks or libraries, just pure PHP and MySQL.

Any tools recommendations?

Thanks

Answer 1

Just use the mysql general log. Create an include file that runs these two queries and display the output of the 2nd one.

SET GLOBAL general_log = 'ON';

SELECT * FROM mysql.general_log;