Query Metrics
52
Database Queries
10
Different statements
1438.70 ms
Query time
0
Invalid entities
110
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
599.95 ms (41.70%) |
20 |
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.heure_arrivee AS heure_arrivee_3, t0.heure_depart AS heure_depart_4, t0.plus_de_six_ans AS plus_de_six_ans_5, t0.reservation_creneau_activite_id AS reservation_creneau_activite_id_6, t0.decoupage_creneau_id AS decoupage_creneau_id_7, t0.statut_presence_id AS statut_presence_id_8 FROM decoupage_presence t0 WHERE t0.id = ?
Parameters:
[
"12135"
]
|
|
278.42 ms (19.35%) |
15 |
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.prix_creneau AS prix_creneau_3, t0.liste_attente AS liste_attente_4, t0.num_liste_attente AS num_liste_attente_5, t0.reservation_id AS reservation_id_6, t0.creneau_activite_id AS creneau_activite_id_7, t0.tarif_id AS tarif_id_8, t0.annulation_id AS annulation_id_9 FROM reservation_creneau_activite t0 WHERE t0.id = ?
Parameters:
[
9714
]
|
|
120.23 ms (8.36%) |
1 |
SELECT t0.id AS id_1, t0.nom_site AS nom_site_2, t0.url AS url_3, t0.nom_logo AS nom_logo_4, t0.date_maj_logo AS date_maj_logo_5, t0.description AS description_6, t0.conditions_generales_services AS conditions_generales_services_7, t0.nom_img_description AS nom_img_description_8, t0.date_maj_description AS date_maj_description_9, t0.nom_structure AS nom_structure_10, t0.mail_reception_automatique AS mail_reception_automatique_11, t0.a_prix_commune AS a_prix_commune_12, t0.prix_par_quotients AS prix_par_quotients_13, t0.url_facebook AS url_facebook_14, t0.url_instagram AS url_instagram_15, t0.url_twitter AS url_twitter_16, t0.url_site_web_structure AS url_site_web_structure_17, t0.utilise_hebergements AS utilise_hebergements_18, t0.type_activite AS type_activite_19, t0.validation_reservation_par_defaut AS validation_reservation_par_defaut_20, t0.a_delai_blocage_reservation AS a_delai_blocage_reservation_21, t0.nbre_unites_temps_blocage_reservation AS nbre_unites_temps_blocage_reservation_22, t0.validation_annulation_par_defaut AS validation_annulation_par_defaut_23, t0.a_delai_blocage_annulation AS a_delai_blocage_annulation_24, t0.nbre_unites_temps_blocage_annulation AS nbre_unites_temps_blocage_annulation_25, t0.nbre_unites_temps_validite_avoir AS nbre_unites_temps_validite_avoir_26, t0.nom_responsable AS nom_responsable_27, t0.code_siren AS code_siren_28, t0.forme_juridique AS forme_juridique_29, t0.date_immatriculation AS date_immatriculation_30, t0.code_apenaf AS code_apenaf_31, t0.num_tva AS num_tva_32, t0.fonction_responsable AS fonction_responsable_33, t0.nom_directeur AS nom_directeur_34, t0.unite_presence_accueil AS unite_presence_accueil_35, t0.auto_increment_facture AS auto_increment_facture_36, t0.auto_increment_avoir AS auto_increment_avoir_37, t0.tva_applicable AS tva_applicable_38, t0.cle_publique_mailjet AS cle_publique_mailjet_39, t0.cle_secrete_mailjet AS cle_secrete_mailjet_40, t0.mail_envoi_mailjet AS mail_envoi_mailjet_41, t0.id_template_campagne AS id_template_campagne_42, t0.taux_tva AS taux_tva_43, t0.auto_increment_avoirs AS auto_increment_avoirs_44, t0.liste_attente AS liste_attente_45, t0.nbre_unites_temps_liste_attente AS nbre_unites_temps_liste_attente_46, t0.id_site_noyau AS id_site_noyau_47, t0.asso_token_api_basicompta AS asso_token_api_basicompta_48, t0.token_api_basicompta AS token_api_basicompta_49, t0.created_interco_basicompta AS created_interco_basicompta_50, t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_51, t0.forfait_demi_journee AS forfait_demi_journee_52, t0.forfait_journee AS forfait_journee_53, t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_54, t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_55, t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_56, t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_57, t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_58, t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_59, t0.desactivation_qf AS desactivation_qf_60, t0.nom_tampon AS nom_tampon_61, t0.fonction_directeur AS fonction_directeur_62, t0.inscription_adultes AS inscription_adultes_63, t0.unite_presence_sejour AS unite_presence_sejour_64, t0.token_basicompta AS token_basicompta_65, t0.adhesions AS adhesions_66, t0.coordonnee_id AS coordonnee_id_67, t0.commune_rabais_id AS commune_rabais_id_68, t0.unite_temps_blocage_reservation_id AS unite_temps_blocage_reservation_id_69, t0.unite_temps_blocage_annulation_id AS unite_temps_blocage_annulation_id_70, t0.unite_temps_validite_avoir_id AS unite_temps_validite_avoir_id_71, t0.unite_temps_liste_attente_id AS unite_temps_liste_attente_id_72 FROM variables t0
Parameters:
[] |
|
102.66 ms (7.14%) |
3 |
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.structure AS structure_14, t0.nom_structure AS nom_structure_15, t0.coordonnees_id AS coordonnees_id_16, t0.info_allocataire_id AS info_allocataire_id_17, t18.id AS id_19, t18.date_naissance AS date_naissance_20, t18.pays_naissance AS pays_naissance_21, t18.code_postal_naissance AS code_postal_naissance_22, t18.commune_naissance AS commune_naissance_23, t18.numero_securite_social AS numero_securite_social_24, t18.intitule_poste AS intitule_poste_25, t18.nom_photo AS nom_photo_26, t18.updated_at_photo AS updated_at_photo_27, t18.notes AS notes_28, t18.code_insee AS code_insee_29, t18.user_id AS user_id_30, t18.statut_employe_id AS statut_employe_id_31 FROM user t0 LEFT JOIN animateur t18 ON t18.user_id = t0.id WHERE t0.id = ?
Parameters:
[
11
]
|
|
70.66 ms (4.91%) |
3 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.statut_reservation AS statut_reservation_4, t0.montant_total AS montant_total_5, t0.montant_acompte AS montant_acompte_6, t0.valide AS valide_7, t0.statut AS statut_8, t0.archive AS archive_9, t0.num_liste_attente AS num_liste_attente_10, t0.plus_de_six_ans AS plus_de_six_ans_11, t0.numero_attestation_presence AS numero_attestation_presence_12, t0.utilisateur_id AS utilisateur_id_13, t0.enfant_id AS enfant_id_14, t0.activite_id AS activite_id_15, t0.commande_id AS commande_id_16, t0.annulation_id AS annulation_id_17, t0.presence_sejour_id AS presence_sejour_id_18, t0.tarif_id AS tarif_id_19 FROM reservation t0 WHERE t0.id = ?
Parameters:
[
1190
]
|
|
64.55 ms (4.49%) |
2 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.demi_journee_id AS demi_journee_id_3 FROM demi_journee_decoupage t0 WHERE t0.id = ?
Parameters:
[
963
]
|
|
59.46 ms (4.13%) |
2 |
SELECT t0.id AS id_1, t0.label AS label_2 FROM statut_presence t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
58.38 ms (4.06%) |
2 |
SELECT t0.id AS id_1, t0.lien_autre AS lien_autre_2, t0.user_id AS user_id_3, t0.enfant_id AS enfant_id_4, t0.contact_urgence_id AS contact_urgence_id_5, t0.lien_parente_id AS lien_parente_id_6 FROM est_lie t0 WHERE t0.enfant_id = ?
Parameters:
[
12
]
|
|
45.75 ms (3.18%) |
2 |
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:
[
12
]
|
|
38.63 ms (2.69%) |
2 |
SELECT t0.id AS id_1, t0.demi_journee_id AS demi_journee_id_2, t0.creneau_activite_id AS creneau_activite_id_3 FROM decoupage_creneau t0 WHERE t0.id = ?
Parameters:
[
2450
]
|
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\DecoupagePresence | 20 |
| App\Entity\DecoupageCreneau | 20 |
| App\Entity\ReservationCreneauActivite | 15 |
| App\Entity\CreneauActivite | 15 |
| App\Entity\Coordonnees | 4 |
| App\Entity\EstLie | 4 |
| App\Entity\LienParente | 4 |
| App\Entity\User | 3 |
| App\Entity\Reservation | 3 |
| App\Entity\Sejour | 3 |
| App\Entity\Commande | 3 |
| App\Entity\StatutPresence | 2 |
| App\Entity\Tarif | 2 |
| App\Entity\Enfant | 2 |
| App\Entity\DemiJourneeDecoupage | 2 |
| App\Entity\ContactUrgence | 2 |
| App\Entity\InfoAllocataire | 2 |
| App\Entity\Variables | 1 |
| App\Entity\UniteTemps | 1 |
| App\Entity\Annulation | 1 |
| App\Entity\DemiJournee | 1 |