Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.54 ms Query time

1 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	1.52 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"dc3o7_topill_dev"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dc3o7_topill_dev' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	0.91 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

1.12 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

1.52 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "dc3o7_topill_dev"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'dc3o7_topill_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

0.91 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
App\Entity\AsmrHas	No errors.
App\Entity\CompositionHas	No errors.
App\Entity\ConditionPrescriptionHas	No errors.
App\Entity\Contribution	No errors.
App\Entity\DossierHas	No errors.
App\Entity\Excipient	No errors.
App\Entity\FichierHas	No errors.
App\Entity\GeneriqueHas	No errors.
App\Entity\ImagePresentation	No errors.
App\Entity\InfoImportanteHas	No errors.
App\Entity\LienCtHas	No errors.
App\Entity\MedicationHistory	No errors.
App\Entity\Metadata	No errors.
App\Entity\PresentationHas	No errors.
App\Entity\Profile	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\SmrHas	No errors.
App\Entity\SpecialiteExtend	No errors.
App\Entity\SpecialiteHas	No errors.
App\Entity\SubstanceDeconseillePrescrire	No errors.
App\Entity\TitulaireSpecialiteHas	No errors.
App\Entity\User	No errors.
App\Entity\UserPreference	No errors.
App\Entity\VoiesAdministrationHas	No errors.
App\Entity\Asmr	No errors.
App\Entity\Composition	No errors.
App\Entity\ConditionPrescription	No errors.
App\Entity\Generique	No errors.
App\Entity\InfoImportante	No errors.
App\Entity\PrescrireCategorie	No errors.
App\Entity\PrescrireCible	The referenced column name 'identifiant_groupe' has to be a primary key column on the target entity class 'App\Entity\Generique'.
App\Entity\PrescrireContexte	No errors.
App\Entity\PrescrireFiche	No errors.
App\Entity\Presentation	No errors.
App\Entity\Smr	No errors.
App\Entity\Specialite	No errors.
App\Entity\Substance	No errors.
App\Entity\Titulaire	No errors.
App\Entity\TitulaireSpecialite	No errors.
App\Entity\VoieAdministration	No errors.
App\Entity\VoieAdministrationSpecialite	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.

Symfony Profiler

GET http://backend-dev.topill.fr/debug/default/view?panel=config

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping