ActiveRecord - print query before run (CI 2.0.2)

[eluser]toopay[/eluser]
The other way to see what the queries which exist in DB object is using

Code:

// Here you can see what queries has been loaded
var_dump($this->db->queries);
$this->db->select('*');
$this->db->from('post');
$res = $this->db->get();
// Here you should see your new queries has been loaded
var_dump($this->db->queries);

But for your task you asking, you need to extend the database class, since internally CI database class has its own cache mechanism (check out Database Caching Class)