This mod adds a time check around the db query call to show exactly how long database queries are taking so you can track down potential slow queries on your server. This should create a file in the root of your store called "query_time.txt"

This will log all db queries that are called when a page is refreshed like this:

Xsecrets wrote:looks like yes he has alot of categories, but also LOTS of products. I think you need to look at my performance optimization thread. http://forum.opencart.com/viewtopic.php?f=24&t=24391 I think those changes would help you quite a bit as the product query is taking over 4 seconds.

How can i use it for track queries when i click on checkout confirm button.
My site is now very fast except the last step when i click on confirm button it take about 25second to reach the payment gateway it's not good at all im losing order because of this so if i can track what take this much time it would be fantastic