Active Record: viewing the resulting queries?

[eluser]degu[/eluser]
Hello,

is there a way to view/log the queries that the active record methods build? I need to analyze some of my more complex queries for debugging purposes. Thanks!

[eluser]simshaun[/eluser]
Try enabling the profiler. It should show the queries at the bottom.

[eluser]fesweb[/eluser]
To be more specific for new people...

At the top of your function (or inside the controller's __construct() function):

Code:

$this->output->enable_profiler();

[eluser]Armchair Samurai[/eluser]
You can also echo out the query with $this->db->last_query()