PhotoPost Community - View Single Post - Findout Individual Queries and their loading time

mihirp · February 23rd, 2007, 07:57 AM

How do I findout individual queries and their loading time.

For eg:

Page generated in 2.43096 seconds with 14 queries
1: SELECT timestamp,statscache,catcache,catprops FROM cache WHERE id=1 (0.41623 sec)
2: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid=1 (0.00276 sec)

I picked up the following from one post. I would also like to know which softwares are good to debug php/mysql queries and provide suggestions.

February 23rd, 2007, 07:57 AM	#1 (permalink)
mihirp Member Join Date: Jan 2007 Posts: 86	Findout Individual Queries and their loading time How do I findout individual queries and their loading time. For eg: Page generated in 2.43096 seconds with 14 queries 1: SELECT timestamp,statscache,catcache,catprops FROM cache WHERE id=1 (0.41623 sec) 2: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid=1 (0.00276 sec) I picked up the following from one post. I would also like to know which softwares are good to debug php/mysql queries and provide suggestions.