How to check all queries executed by a specific code in Magento

Question

To check all queries by a specific piece of code I am using:

Modify from protected to public the variable $_debug in Varien_Db_Adapter_Pdo_Mysql
Do the same for $_logAllQueries

Add this before code executes:

$adapter = Mage::getSingleton('core/resource')->getConnection('core_write');
$adapter->_debug = true;
$adapter->_logAllQueries = true;

Add this after the code

$adapter->_debug = false;
$adapter->_logAllQueries = false;

so your final code will look like this:

$adapter = Mage::getSingleton('core/resource')->getConnection('core_write');
$adapter->_debug = true;
$adapter->_logAllQueries = true;

Mage::getModel('catalog/product')->load(1);

$adapter->_debug = false;
$adapter->_logAllQueries = false;

Is there any other more elegant solution?

magento.stackexchange.com/questions/25113/…

Niloct
– Niloct

2015-05-22 22:57:26 +00:00
Commented May 22, 2015 at 22:57 — Niloct
– Niloct, Commented May 22, 2015 at 22:57

Community · Accepted Answer · 2017-05-23 12:21:58Z

1

You can use a variation of my answer at How do I print all the queries in Magento?

Instead of activating the profiler globally in local.xml, add these before and after the code you want to test:

$profiler = Mage::getSingleton('core/resource')->getConnection('core_write')->getProfiler();
$profiler->setEnabled(true);

// ...

Mage::log(print_r($profiler->getQueryProfiles(), true), null, 'queries.log', true);
$profiler->setEnabled(false);

Then you will find the queries in var/log/queries.log

edited May 23, 2017 at 12:21

CommunityBot

11 silver badge

answered Aug 12, 2015 at 7:58

Fabian Schmengler

24.6k9 gold badges82 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Razvan AVRAMESCU Over a year ago

Thank you, @fschmengler, this is what I was looking for! Best, R

Ricardo Martins · Accepted Answer · 2018-03-18 23:25:07Z

1

There is an extension available for Magento which i am personally using from long time (works for Community as well as EE) :

https://github.com/madalinoprea/magneto-debug

This will let you - Check all requests - See all SQL queries executed for a request - See all layout handles executed - and many more

edited Mar 18, 2018 at 23:25

Ricardo Martins

6,0733 gold badges49 silver badges65 bronze badges

answered Aug 12, 2015 at 7:30

SwaPulAtoR

111 bronze badge

1 Comment

Razvan AVRAMESCU Over a year ago

Hi, I am using magneto-debug, a forked patched version, while Madalin Oprea does not accept any pull requests from a while. Is good, but not exactly for a specific piece of code. Thanks, R

Yazid Erman · Accepted Answer · 2015-06-03 11:19:14Z

0

You may simply open the MySQL Log file and monitor the logged queries while requesting the page, If you are using Linux for example, use the command tail -F to view all the changes on the log file in a live way.

Try this for example on debian: tail-F /var/log/mysql.log

answered Jun 3, 2015 at 11:19

Yazid Erman

1,1861 gold badge13 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to check all queries executed by a specific code in Magento

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related