Monitoring Database Queries in the Profiler (or something)

[eluser]zhanng[/eluser]
Hello. I am currently setting up my project in CodeIgniter and would like to get many of my foundation pieces in correctly. I am setting up the application so that when an admin logs in, the Profiler is activated. I am trying to hook he profiler into the root index.php file. Does anyone have any suggestions as to the best place to set the profiler code in order to get the broadest execution time range? I have, however, found a small hole, at least with respect to my past experiences.

Generally, when I do benchmarking in my systems, I track two things. Execution time, and Database Queries. I have looked around, but I can't seem to find any mention of tracking the DB queries made by a page. I would like to track the total number of queries done, as well as each individual query. Does CodeIgniter provide such functionality, or would I have to write custom code?

If I have to write custom code, I think the best route would be to extend the current DB functionality and log everything there. Maybe someone has a better idea?

Thanks in advance
Dan