How to isolate PHP application requests to MySQL?

Question

MySQL

There is a dump of an ancient site on Zend Framework 1 with a huge database (> 200GB). A huge number of tables, some of them are used in the work, some are atavisms.

The task was to make a number of changes on the site. But in order for me to somehow advance, I need to understand which tables in the database work with certain parts of the application. Which tables are accessed when the search module is running on the site, which tables are used when inserting new data in the admin

panel, etc.

Is there any universal way to track sql queries in a php application?

Answer 1

Is there any universal way to track sql queries in a php application?

There are, for example, sql server logs to watch.