Does anyone have an answer for below question?
How to find which query is taking more time to execute in Magento 1 & Magento 2?
You need to enable profiler for that. To know how to enable it please check this.
For Magento 1
https://docs.nexcess.net/article/how-to-enable-the-magento-profiler.html
For Magento 2
http://devdocs.magento.com/guides/v2.1/config-guide/bootstrap/mage-profiler.html
Hope it'll help you.