Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.77 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.77 ms (100.00%)	1	SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.procedure_collective_creation AS procedure_collective_creation_3, t0.procedure_collective AS procedure_collective_4, t0.statistique AS statistique_5, t0.etat AS etat_6, t0.detail_cloture AS detail_cloture_7, t0.date_cloture AS date_cloture_8, t0.date_modification AS date_modification_9, t0.antenne_id AS antenne_id_10, t0.methode_contact_id AS methode_contact_id_11, t0.entreprise_id AS entreprise_id_12 FROM dossier t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.procedure_collective_creation AS procedure_collective_creation_3, t0.procedure_collective AS procedure_collective_4, t0.statistique AS statistique_5, t0.etat AS etat_6, t0.detail_cloture AS detail_cloture_7, t0.date_cloture AS date_cloture_8, t0.date_modification AS date_modification_9, t0.antenne_id AS antenne_id_10, t0.methode_contact_id AS methode_contact_id_11, t0.entreprise_id AS entreprise_id_12 FROM dossier t0 SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.procedure_collective_creation AS procedure_collective_creation_3, t0.procedure_collective AS procedure_collective_4, t0.statistique AS statistique_5, t0.etat AS etat_6, t0.detail_cloture AS detail_cloture_7, t0.date_cloture AS date_cloture_8, t0.date_modification AS date_modification_9, t0.antenne_id AS antenne_id_10, t0.methode_contact_id AS methode_contact_id_11, t0.entreprise_id AS entreprise_id_12 FROM dossier t0;

Time▼

Count

Info

0.77 ms
(100.00%)

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.procedure_collective_creation AS procedure_collective_creation_3, t0.procedure_collective AS procedure_collective_4, t0.statistique AS statistique_5, t0.etat AS etat_6, t0.detail_cloture AS detail_cloture_7, t0.date_cloture AS date_cloture_8, t0.date_modification AS date_modification_9, t0.antenne_id AS antenne_id_10, t0.methode_contact_id AS methode_contact_id_11, t0.entreprise_id AS entreprise_id_12 FROM dossier t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.procedure_collective_creation AS procedure_collective_creation_3,
  t0.procedure_collective AS procedure_collective_4,
  t0.statistique AS statistique_5,
  t0.etat AS etat_6,
  t0.detail_cloture AS detail_cloture_7,
  t0.date_cloture AS date_cloture_8,
  t0.date_modification AS date_modification_9,
  t0.antenne_id AS antenne_id_10,
  t0.methode_contact_id AS methode_contact_id_11,
  t0.entreprise_id AS entreprise_id_12
FROM
  dossier t0

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.procedure_collective_creation AS procedure_collective_creation_3, t0.procedure_collective AS procedure_collective_4, t0.statistique AS statistique_5, t0.etat AS etat_6, t0.detail_cloture AS detail_cloture_7, t0.date_cloture AS date_cloture_8, t0.date_modification AS date_modification_9, t0.antenne_id AS antenne_id_10, t0.methode_contact_id AS methode_contact_id_11, t0.entreprise_id AS entreprise_id_12 FROM dossier t0;

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.

Entities Mapping

Class	Mapping errors
App\Entity\Dossier	The mappings App\Entity\Dossier#Fichiers and App\Entity\Fichier#Dossier are inconsistent with each other.
App\Entity\Antenne	No errors.
App\Entity\MethodeContact	No errors.
App\Entity\Entreprise	No errors.
App\Entity\Element	No errors.
App\Entity\Enquete	No errors.
App\Entity\Apesa	No errors.
App\Entity\Evenement	The association App\Entity\Evenement#ContactOrganismesExpert refers to the inverse side field App\Entity\ContactOrganismeExpert#Evenements which does not exist.
App\Entity\Utilisateur	No errors.
App\Entity\Fichier	The association App\Entity\Fichier#Dossier refers to the inverse side field App\Entity\Dossier#fichiers which does not exist.
App\Entity\ContactOrganismeExpert	No errors.

Symfony Profiler

POST https://89.casquesbleus.fr/api/dossiers/statistiques

Configuration Settings

Theme