Display SQL queries/debug

[eluser]jonnyjon[/eluser]
Is there a way to display SQL queries as they are made? Or some kind of similar debug message?

Cake does this really well and I was wondering if CI has got something similar.

[eluser]Michael Wales[/eluser]

Code:

$this->output->enable_profiler(TRUE);

[eluser]soupdragon[/eluser]
and where shoud i use that ?

in the model by the query or in the view ?

[eluser]jonnyjon[/eluser]
You can put it in the constructor of the model, or best in the constructor of the controller. Least thats how I use it.

class Users extends Controller {

function __construct()
{
parent::Controller();
$this->output->enable_profiler(TRUE);
}

}

[eluser]soupdragon[/eluser]
okay done that thanks !