I came across this helpful way to debug SQL in Magento. Go to and change $_debug to be true. Then you will get a file that shows all the SQL goings on:
Kategori: Magento
/lib/Varen/Db/Adapter/Pdo/Mysql.php
/var/debug/sql.txt