Query Metrics

8 Database Queries
8 Different statements
13.25 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.11 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.telephone AS telephone_9, t0.actif AS actif_10, t0.trigramme AS trigramme_11, t0.agence_id AS agence_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6
]
2 0.67 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.created_at AS created_at_6, u0_.updated_at AS updated_at_7, u0_.telephone AS telephone_8, u0_.actif AS actif_9, u0_.trigramme AS trigramme_10, u0_.agence_id AS agence_id_11 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%"ROLE_USER"%"
]
3 0.77 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.adresse AS adresse_2, a0_.boite_postale AS boite_postale_3, a0_.code_postal AS code_postal_4, a0_.ville AS ville_5, a0_.telephone AS telephone_6, a0_.siret AS siret_7, a0_.code_ape AS code_ape_8, a0_.tva_intracommunautaire AS tva_intracommunautaire_9 FROM agence a0_
Parameters:
[]
4 3.42 ms
SELECT c0_.id AS id_0, c0_.societe AS societe_1, c0_.contact_nom AS contact_nom_2, c0_.contact_prenom AS contact_prenom_3, c0_.telephone AS telephone_4, c0_.email AS email_5, c0_.adresse AS adresse_6, c0_.code_postal AS code_postal_7, c0_.ville AS ville_8, c0_.remarques AS remarques_9, c0_.type_id AS type_id_10 FROM client c0_
Parameters:
[]
5 0.71 ms
SELECT c0_.id AS id_0, c0_.libelle_court AS libelle_court_1, c0_.libelle_long AS libelle_long_2, c0_.remarques AS remarques_3 FROM categorie_affaire c0_
Parameters:
[]
6 0.63 ms
SELECT p0_.id AS id_0, p0_.libelle_court AS libelle_court_1, p0_.libelle_long AS libelle_long_2 FROM proposition_origine p0_
Parameters:
[]
7 0.70 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.created_at AS created_at_6, u0_.updated_at AS updated_at_7, u0_.telephone AS telephone_8, u0_.actif AS actif_9, u0_.trigramme AS trigramme_10, u0_.agence_id AS agence_id_11 FROM user u0_
Parameters:
[]
8 5.24 ms
SELECT f0_.id AS id_0, f0_.societe AS societe_1, f0_.contrat_st AS contrat_st_2, f0_.contact_nom AS contact_nom_3, f0_.contact_prenom AS contact_prenom_4, f0_.telephone AS telephone_5, f0_.mail AS mail_6, f0_.adresse AS adresse_7, f0_.code_postal AS code_postal_8, f0_.ville AS ville_9, f0_.remarques AS remarques_10 FROM fournisseur f0_
Parameters:
[]

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\User No errors.
App\Entity\Agence No errors.
App\Entity\Proposition No errors.
App\Entity\Dossier No errors.
App\Entity\Courrier No errors.
App\Entity\Affaire No errors.
App\Entity\Client No errors.
App\Entity\CategorieAffaire No errors.
App\Entity\PropositionOrigine No errors.
App\Entity\FactureProposition No errors.
App\Entity\CommandeProposition No errors.
App\Entity\TypeClient No errors.
App\Entity\Fournisseur No errors.
App\Entity\Commande No errors.