Magento: Log the collection SQL query in Magento.

$collection = Mage::getModel('catalog/product')->getCollection();

$collection->getSelect()->__toString();
 OR
$collection->printLogQuery(true);

Tags: MagentoSQL

Prashant Kumar

I am a Software Developer with 6+ years of experience in software development. I have sharp skills in PHP language, Joomla, Magento, WordPress, HTML, CSS, Jquery, AJAX. Expert Magento Certified Developer (https://u.magento.com/certification/directory/dev/262179/). Love to take challenges in troubleshooting problem of software world. Familiar with web development and content management systems. I’m not a great programmer but I feel I’m a great implementer".

• Next story Magento: Getting Associated products of bundle products or displaying simple products of bundle products
• Previous story Magento: Convert price from default currency to some other currency

You may also like...

• 0

  Resize Product Image in Magento 2

  April 29, 2018

   by Prashant Kumar · Published April 29, 2018

• 3

  Creating a Configurable Product in Magento

  September 13, 2013

   by Prashant Kumar · Published September 13, 2013 · Last modified January 11, 2014

• 0

  How to programmatically delete order in Magento

  September 2, 2014

   by Prashant Kumar · Published September 2, 2014