Query Metrics
53
Database Queries
7
Different statements
16.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.44 ms (62.62%) |
24 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_password_token AS reset_password_token_4, u0_.civilite AS civilite_5, u0_.cin AS cin_6, u0_.nom AS nom_7, u0_.prenom AS prenom_8, u0_.date_naissance AS date_naissance_9, u0_.adresse AS adresse_10, u0_.code_postal AS code_postal_11, u0_.ville AS ville_12, u0_.tel AS tel_13, u0_.fax AS fax_14, u0_.etat_activation AS etat_activation_15, u0_.niveau AS niveau_16, u0_.specialite AS specialite_17, u0_.experience AS experience_18, u0_.type AS type_19, u0_.diplome AS diplome_20, u0_.institution AS institution_21, u0_.poste AS poste_22, u0_.nationnalite AS nationnalite_23, u0_.cv AS cv_24, u0_.photo_de_profil AS photo_de_profil_25, u0_.updated_at AS updated_at_26, u0_.email AS email_27, u0_.organization_id AS organization_id_28 FROM `user` u0_ LEFT JOIN engagement e1_ ON u0_.id = e1_.formateur_id WHERE e1_.module_id = ? AND e1_.session_id = ? AND e1_.cycle_id = ? AND e1_.groupe = ? LIMIT 1
Parameters:
[ 1 5 3 "3" ] |
|
4.69 ms (28.12%) |
24 |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.nombre_heure AS nombre_heure_3, t0.prix_heure AS prix_heure_4, t0.coefficient AS coefficient_5 FROM module t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.45 ms (2.68%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.reset_password_token AS reset_password_token_5, t0.civilite AS civilite_6, t0.cin AS cin_7, t0.nom AS nom_8, t0.prenom AS prenom_9, t0.date_naissance AS date_naissance_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.tel AS tel_14, t0.fax AS fax_15, t0.etat_activation AS etat_activation_16, t0.niveau AS niveau_17, t0.specialite AS specialite_18, t0.experience AS experience_19, t0.type AS type_20, t0.diplome AS diplome_21, t0.institution AS institution_22, t0.poste AS poste_23, t0.nationnalite AS nationnalite_24, t0.cv AS cv_25, t0.photo_de_profil AS photo_de_profil_26, t0.updated_at AS updated_at_27, t0.email AS email_28, t0.organization_id AS organization_id_29 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
644
]
|
|
0.30 ms (1.82%) |
1 |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.tarif_particulier AS tarif_particulier_3, t0.tarif_entreprise AS tarif_entreprise_4, t0.tarif_etrange AS tarif_etrange_5, t0.etat AS etat_6, t0.exchange_rate AS exchange_rate_7, t0.vat_rate AS vat_rate_8 FROM session t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
0.30 ms (1.78%) |
1 |
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.attestation AS attestation_3, t0.groupe AS groupe_4, t0.candidat_id AS candidat_id_5, t0.cycle_id AS cycle_id_6, t0.session_id AS session_id_7 FROM inscription t0 WHERE t0.candidat_id = ?
Parameters:
[
644
]
|
|
0.28 ms (1.66%) |
1 |
SELECT t0.id AS id_1, t0.note AS note_2, t0.inscription_id AS inscription_id_3, t0.module_id AS module_id_4 FROM inscription_module t0 WHERE t0.inscription_id = ?
Parameters:
[
293
]
|
|
0.22 ms (1.32%) |
1 |
SELECT t0.id AS id_1, t0.libele AS libele_2, t0.date_debut AS date_debut_3, t0.etat AS etat_4 FROM cycle t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Organization | No errors. |
| App\Entity\Engagement | No errors. |
| App\Entity\Inscription | No errors. |
| App\Entity\Certificat | No errors. |
| App\Entity\ServiceUsage | No errors. |
| App\Entity\Cycle | No errors. |
| App\Entity\Session | No errors. |
| App\Entity\FactureCandidat | No errors. |
| App\Entity\InscriptionModule | No errors. |
| App\Entity\Module | No errors. |