Show ALL | Full magento 2 query with Sorting, Pagination and Filter in Magento 2
Open : /var/www/html/magento/jaydip kansagra/app/etc/di.xml
Find
<preference for="Magento\Framework\DB\LoggerInterface"
Replace
<preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\File"/>
<type name="Magento\Framework\DB\Logger\File">
<arguments>
<argument name="logAllQueries" xsi:type="boolean">true</argument>
<argument name="debugFile" xsi:type="string">log/sql.log</argument>
</arguments>
</type>
Open : /var/www/html/magento/frye-magento/var/log/sql.log
