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?

score 10 · Accepted Answer · edited May 23 '17 at 11:51

10

Try

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

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

edited May 23 '17 at 11:51

Community

1
1

answered May 23 '14 at 16:30

MagePal Extensions

17,646
2
47
62

The issue with this approach is that `limits` and `filters` are not pritned – Basheer Kharoti Oct 01 '21 at 10:03

score -1 · Answer 2 · edited May 29 '15 at 01:57

-1

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

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

edited May 29 '15 at 01:57

Undo

25,519
37
106
129

answered May 28 '15 at 17:24

P. Prakash

1
2

Output raw SQL query from Magento collection

2 Answers2

Linked