I've noticed at the bottom of sites stuff like " site loaded with 15 queries" and I want to know how to get the number of queries done by a page.

You could probably just set a session variable, and every time a query is executed, increment the session variable. (while loops do multiple queries)

I've never really done this before, so I might be mistaken.

also, while we're in here, maybe somebody can tell me how to check how efficient the queries are running or whatnot. The time it takes to query, etc. All the stuff you would want to know.

Well as far as I know you should only get the fields you need and just reduce your queries to the bare minium.
Check out:
http://www.devshed.com/c/a/MySQL/Enhancing-MySQL-Query-Efficiency/3/

http://www.informit.com/articles/article.aspx?p=377652

I know this is an older thread, but I've read a few requests for something like this, so I wrote an article and put it up on my site. I hope this helps you: http://www.teratask.com/index.php?pa...-count-queries