Search code examples
phpmysqlsymfonydoctrine-ormsymfony4

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


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

enter image description here


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%'