Query Metrics
3
Database Queries
3
Different statements
2.47 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.99 ms (39.88%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.token AS token_8, t0.token_mdp AS token_mdp_9, t0.desactivation_compte AS desactivation_compte_10, t0.created_at AS created_at_11, t0.refus_campagne AS refus_campagne_12, t0.compte_finalise AS compte_finalise_13, t0.coordonnees_id AS coordonnees_id_14, t0.info_allocataire_id AS info_allocataire_id_15, t16.id AS id_17, t16.date_naissance AS date_naissance_18, t16.pays_naissance AS pays_naissance_19, t16.code_postal_naissance AS code_postal_naissance_20, t16.commune_naissance AS commune_naissance_21, t16.numero_securite_social AS numero_securite_social_22, t16.intitule_poste AS intitule_poste_23, t16.nom_photo AS nom_photo_24, t16.updated_at_photo AS updated_at_photo_25, t16.notes AS notes_26, t16.code_insee AS code_insee_27, t16.user_id AS user_id_28, t16.statut_employe_id AS statut_employe_id_29 FROM user t0 LEFT JOIN animateur t16 ON t16.user_id = t0.id WHERE t0.id = ?
Parameters:
[
"45"
]
|
0.86 ms (34.65%) |
1 |
SELECT t0.id AS id_1, t0.nom_sejour AS nom_sejour_2, t0.age_min AS age_min_3, t0.age_max AS age_max_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.description AS description_7, t0.nbplace AS nbplace_8, t0.montant_acompte AS montant_acompte_9, t0.hebergement AS hebergement_10, t0.justificatif_suplementaire AS justificatif_suplementaire_11, t0.nom_image_principale AS nom_image_principale_12, t0.updated_at AS updated_at_13, t0.type_activite AS type_activite_14, t0.nb_places_prises AS nb_places_prises_15, t0.date_delai_reservation AS date_delai_reservation_16, t0.date_delai_annulation AS date_delai_annulation_17, t0.statut AS statut_18, t0.total_liste_attente AS total_liste_attente_19, t0.recurrence AS recurrence_20, t0.type_recurrence AS type_recurrence_21, t0.numero_declaration_sdjes AS numero_declaration_sdjes_22, t0.desactivation_fiche_sanitaire AS desactivation_fiche_sanitaire_23, t0.categorie_id AS categorie_id_24, t0.coordonnees_id AS coordonnees_id_25, t0.semaine_recurrence_id AS semaine_recurrence_id_26 FROM sejour t0 WHERE t0.id = ?
Parameters:
[
"81"
]
|
0.63 ms (25.47%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.sexe AS sexe_4, t0.date_naissance AS date_naissance_5, t0.autres_allergies AS autres_allergies_6, t0.remarques_medicales AS remarques_medicales_7, t0.suivi_traitement AS suivi_traitement_8, t0.traitement AS traitement_9, t0.nom_ordonnance AS nom_ordonnance_10, t0.updated_at AS updated_at_11, t0.nom_photo AS nom_photo_12, t0.updated_at_photo AS updated_at_photo_13, t0.autorisation_photo AS autorisation_photo_14, t0.aeeh AS aeeh_15, t0.est_utilisateur AS est_utilisateur_16 FROM enfant t0 WHERE t0.id = ?
Parameters:
[
"25"
]
|
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 |
---|---|
App\Entity\Coordonnees | 2 |
App\Entity\Sejour | 1 |
App\Entity\Categorie | 1 |
App\Entity\User | 1 |
App\Entity\InfoAllocataire | 1 |
App\Entity\Enfant | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Sejour | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Coordonnees | No errors. |
App\Entity\Semaine | No errors. |
App\Entity\InfoHebergement | No errors. |
App\Entity\TypeJustificatif | No errors. |
App\Entity\Image | No errors. |
App\Entity\Tarif | No errors. |
App\Entity\Reservation | No errors. |
App\Entity\CreneauActivite | No errors. |
App\Entity\RegleReduction | No errors. |
App\Entity\Champ | No errors. |
App\Entity\Animateur | No errors. |
App\Entity\Adhesion | No errors. |
App\Entity\User | No errors. |
App\Entity\InfoAllocataire | No errors. |
App\Entity\StatutEmploye | No errors. |
App\Entity\EstLie | No errors. |
App\Entity\Annulation | No errors. |
App\Entity\ModePaiementCommande | No errors. |
App\Entity\AdhesionUtilisateur | No errors. |
App\Entity\Enfant | No errors. |
App\Entity\EnfantsMaladies | No errors. |
App\Entity\EnfantsAllergies | No errors. |