Output raw SQL query from Magento collection

Question

I have the following collection and want to view the raw SQL within my IDE Xdebug tool -

$collection = Mage::getResourceModel('rp/organisation_collection')
                ->searchByPostcodeLastname($postcode, Slastname)
                ->addFieldToSelect(array('organisation_id'))
                ->setPageSize(1);

$qry = $organisation->load()->getSelect();

This while does show the Varien object doesn't seem to give me the raw SQL for me to check - can someone confirm what I am doing wrong?

Meldameldoh

Answer 1

Try

$collection->getSelect()->__toString()

See How do you display a Magento sql query as a string?

Craze

The issue with this approach is that limits and filters are not pritned – Chaos

Answer 2

Try out $Collection->printLogQuery(true); this will print collection query.

Mage::log($collection->getSelect(),null,'test.log',true);

Adabelle