CodeIgniter Forums
How to display SQL queries used? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to display SQL queries used? (/showthread.php?tid=18553)



How to display SQL queries used? - El Forum - 05-10-2009

[eluser]IamPrototype[/eluser]
I know you can make these {command} by yourself and CodeIgniter already has the elapsed time command. But how can I display the number of SQL queries used? Smile


How to display SQL queries used? - El Forum - 05-10-2009

[eluser]davidbehler[/eluser]
Code:
echo $this->db->query_count;



How to display SQL queries used? - El Forum - 05-10-2009

[eluser]Colin Williams[/eluser]
Use the Profiler class


How to display SQL queries used? - El Forum - 05-11-2009

[eluser]IamPrototype[/eluser]
Thanks a lot. Smile

Edit: Waow, that's a pretty neat feature, Colin! I didn't know you could do it like that. Smile