>I don't remember which software it was but one of them would show, in the footer, a count of MySQL queries run.
It might have been Simple Machine Forum (SMF). The footer has the number of queries and number of seconds it took to generate the page (in my case, their community forum index page used 9 queries and took ~0.3 seconds to generate).