r174:
The query() has been modified to count the queries and write them into a text file.
In the catalog, Parse time, Number of queries, and Query log are all independent of each other now and settable in admin.
- Settings_query_log.png (10.91 KiB) Viewed 61308 times
In the admin side, parse time must be enabled to activate the 2 query functions.
Parse time and number of queries are displayed in the footer.
- database_query.png (13.29 KiB) Viewed 61308 times
The file name (in the /logs/query_log directory) includes the controller and the file has the complete path included.
E.g.
Code: Select all
time: 19-03-19 13:25:19 (CET)
Path: /r170/?controller=home
1 - select * from (setting) where (type = 'catalog' or type = 'global')
2 - select value from session where session_id = '382582b08b27390079d0073cd89b52fc' and expire > '1363695919'
3 - select * from language
4 - select * from url_alias where alias = ''
5 - select * from user where user_id = '1'
6 - update user set ip = '127.0.0.1' where user_id = '1'
7 - select distinct ug.permission from user u left join user_group ug on u.user_group_id = ug.user_group_id where u.user_id = '1'
8 - select * from tpl_manager where tpl_controller = 'home' and tpl_status = '1'
9 - select location_id, location from tpl_location
- adds minor improvement on manufacturer link on product page
