[FIXED] Doctrine 2 - MySql : multiples 'BASE TABLE' queries added to every views

Issue

Do you know why every views of my Symfony 4.4.25 website using Doctrine ORM 2.9.3 add between 3 and 10 queries like this:

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'

The database is MySQL version 5.7

Solution

I had the same issue from a recent symfony 4.4 install, and fix it by removing the following parameter from doctrine_migrations.yaml:

enable_profiler: '%kernel.debug%'

Answered By - gdus