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

  How to send email programmatically in Magento

  July 29, 2014

   by Prashant Kumar · Published July 29, 2014

• 0

  Magento: Display top level categories and subcategories of current category

  July 11, 2015

   by Prashant Kumar · Published July 11, 2015

• 0

  Magento: Programatically login to Magento admin section by username

  May 15, 2015

   by Prashant Kumar · Published May 15, 2015