Log of mysql query in magento

Go to lib/Varien/Db/Adapter/Pdo/Mysql.php

And do as following:
$_debug               = true;
$_logAllQueries       = true;
$_debugFile           = 'var/debug/pdo_mysql.log';