How do I print all the queries in Magento?

Question

Is it possible to display all the query strings in Magento? I really like to see what queries are executed.

Thanks

Answer 1

In Varien_Db_Adapter_Pdo_Mysql

Magento 1.4 : lib/varien/Db/Adapter/Pdo/Mysql.php

set

protected $_debug               = true;
protected $_logAllQueries       = true;

and (if nor already there) create the folder defined in

protected $_debugFile           = 'var/debug/sql.txt';

Give read / write permission