Print SQL Query when user searches from admin product grid

Question

I am using Magento 2.3.4

Can we print a SQL query when product search from admin product grid?

I can print sql queries in our custom or product collection in frontend using

$collection->getSelect()->__toString();

but I want to print the SQL query in the admin product grid.

Vladyslav Sikailo · Accepted Answer · 2020-10-20 14:30:20Z

0

You can use magento cli command: bin/magento dev:query-log:enable

This will enable logging for all sql queries. It's not a perfect solution, but you will be possible to find needed sql.

answered Oct 20, 2020 at 14:30

Vladyslav Sikailo

3952 silver badges6 bronze badges

it is not print SQL query,it just show json fields and their values
– sumeet bajaj
Commented Oct 20, 2020 at 14:42
No, please check var/debug/db.log in your project. There you can see all sql queries which were executed after db query logging enabling.
– Vladyslav Sikailo
Commented Oct 21, 2020 at 8:31
It may need to flush cache bin/magento cache:flush after enabling/disabling query log.
– Jiří Chmiel
Commented Jun 24, 2022 at 15:36

Add a comment |

1 Answer 1