How to find out which database requests are sent to when generating a page?

Question

PHP

To increase page loading speed, I want to reduce the number of queries to the database. How to find out which databases are being sent requests when generating a page?

Answer 1

search by code for connection parameters to the database.
ps to "increase download speed" first look at the timings in the browser, and then, if necessary, profile the actual scripts. xhprof suits me perfectly. if profiling shows that requests are slowing down, then we take requests and look at their plan. I also advise you to google and set up mysql slow query log on the muscle