This will log all db queries that are called when a page is refreshed like this:
Code: Select all
--- PAGE URL: route=checkout/cart ---
[index.php]
Query Time: 0.0078 :: SELECT * FROM setting
Aggregate: 0.0078
[index.php]
Query Time: 0.0016 :: SELECT * FROM language
Aggregate: 0.0108
[system/library/currency.php]
Query Time: 0.0019 :: SELECT * FROM currency
Aggregate: 0.0127
Code: Select all
http://yoursite.com/query_time.txt