GET https://demo.sejours-stages.fr/reservation/panier/activite/81

Response
200 OK
Browse referrer URL
IP
46.218.7.74
Profiled on
Token
dfd439

Query Metrics

62 Database Queries
31 Different statements
48.85 ms Query time
0 Invalid entities
107 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
8.84 ms
(18.10%) 		6 
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.statut_reservation AS statut_reservation_3, r0_.montant_total AS montant_total_4, r0_.montant_acompte AS montant_acompte_5, r0_.valide AS valide_6, r0_.statut AS statut_7, r0_.archive AS archive_8, r0_.num_liste_attente AS num_liste_attente_9, r0_.plus_de_six_ans AS plus_de_six_ans_10, r0_.numero_attestation_presence AS numero_attestation_presence_11, r0_.utilisateur_id AS utilisateur_id_12, r0_.enfant_id AS enfant_id_13, r0_.activite_id AS activite_id_14, r0_.commande_id AS commande_id_15, r0_.annulation_id AS annulation_id_16, r0_.presence_sejour_id AS presence_sejour_id_17, r0_.tarif_id AS tarif_id_18 FROM reservation r0_ INNER JOIN sejour s1_ ON r0_.activite_id = s1_.id WHERE r0_.utilisateur_id = ? AND r0_.statut_reservation = ? AND s1_.date_fin > ?
Parameters: 
[
  14
  "panier"
  "2025-04-23 09:14:51"
]
View formatted query    View runnable query    Explain query
7.84 ms
(16.05%) 		15 
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: 
[]
View formatted query    View runnable query    Explain query
5.16 ms
(10.56%) 		2 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "bdd_awa"
]
View formatted query    View runnable query    Explain query
3.17 ms
(6.48%) 		2 
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.utilisateur_id = ? AND t0.statut_reservation = ?
Parameters: 
[
  14
  "panier"
]
View formatted query    View runnable query    Explain query
2.71 ms
(5.54%) 		1 
SELECT r0_.id AS id_0, r0_.label AS label_1, r0_.statut AS statut_2, r0_.montant AS montant_3, r0_.debut AS debut_4, r0_.fin AS fin_5, r0_.nombre_condition AS nombre_condition_6, r0_.type AS type_7, r0_.pourcentage AS pourcentage_8, r0_.type_application AS type_application_9, r0_.application_globale AS application_globale_10, r0_.condition_reduction_id AS condition_reduction_id_11 FROM regle_reduction r0_ WHERE r0_.statut = ? AND r0_.type = ? AND (r0_.debut IS NULL OR r0_.debut <= ?) AND (r0_.fin IS NULL OR r0_.fin >= ?) ORDER BY r0_.type_application ASC
Parameters: 
[
  "active"
  "auto"
  "2025-04-23 09:14:51"
  "2025-04-23 09:14:51"
]
View formatted query    View runnable query    Explain query
2.18 ms
(4.47%) 		1 
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'bdd_awa' */ ORDER BY k.ORDINAL_POSITION
Parameters: 
[
  "bdd_awa"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
1.95 ms
(4.00%) 		1 
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "bdd_awa"
  "bdd_awa"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
1.70 ms
(3.49%) 		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: 
[
  14
]
View formatted query    View runnable query    Explain query
1.27 ms
(2.59%) 		6 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.22 ms
(2.50%) 		3 
SELECT count(e0_.id) AS sclr_0 FROM enfant e0_ LEFT JOIN est_lie e1_ ON e0_.id = e1_.enfant_id WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?) GROUP BY e0_.id HAVING count(e0_.id) < 2
Parameters: 
[
  1
  11
  13
  26
  31
  32
  33
]
View formatted query    View runnable query    Explain query
1.20 ms
(2.46%) 		1 
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: 
[
  "bdd_awa"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
1.18 ms
(2.41%) 		3 
SELECT e0_.id AS id_0 FROM enfant e0_ LEFT JOIN est_lie e1_ ON e0_.id = e1_.enfant_id WHERE e1_.user_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
0.93 ms
(1.90%) 		1 
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters: 
[
  "bdd_awa"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
0.88 ms
(1.80%) 		2 
SELECT COUNT(m0_.id) AS sclr_0 FROM mode_paiement_commande m0_ WHERE m0_.numero_avoir IS NOT NULL AND m0_.avoir_utilise IN (?, ?) AND m0_.utilisateur_id = ?
Parameters: 
[
  "pas_utilise"
  "utilise_dans_panier"
  14
]
View formatted query    View runnable query    Explain query
0.78 ms
(1.61%) 		1 
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.activite_id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
0.78 ms
(1.60%) 		1 
SELECT m0_.id AS id_0, m0_.montant_paye AS montant_paye_1, m0_.numero_cheque AS numero_cheque_2, m0_.numero_avoir AS numero_avoir_3, m0_.avoir_utilise AS avoir_utilise_4, m0_.created_at AS created_at_5, m0_.fin_validite AS fin_validite_6, m0_.id_paiement AS id_paiement_7, m0_.id_lien_paiement_stripe AS id_lien_paiement_stripe_8, m0_.somme_remboursee AS somme_remboursee_9, m0_.paiement_plusieurs_fois AS paiement_plusieurs_fois_10, m0_.montant_attendu AS montant_attendu_11, m0_.order_id AS order_id_12, m0_.cancel_order AS cancel_order_13, m0_.date_utilisation_avoir AS date_utilisation_avoir_14, m0_.moyen_paiement_id AS moyen_paiement_id_15, m0_.utilisateur_id AS utilisateur_id_16, m0_.annulation_id AS annulation_id_17 FROM mode_paiement_commande m0_ WHERE m0_.numero_avoir IS NOT NULL AND m0_.avoir_utilise IN (?, ?) AND m0_.utilisateur_id = ?
Parameters: 
[
  "pas_utilise"
  "utilise_dans_panier"
  14
]
View formatted query    View runnable query    Explain query
0.66 ms
(1.36%) 		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 = ? LIMIT 1
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
0.62 ms
(1.27%) 		1 
SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.statut AS statut_3, a0_.montant AS montant_4, a0_.statut_annulation AS statut_annulation_5, a0_.adhesion_id AS adhesion_id_6, a0_.utilisateur_id AS utilisateur_id_7, a0_.personne_id AS personne_id_8, a0_.commande_id AS commande_id_9, a0_.annulation_id AS annulation_id_10 FROM adhesion_utilisateur a0_ INNER JOIN adhesion a1_ ON a0_.adhesion_id = a1_.id WHERE (a0_.statut_annulation <> ? OR a0_.statut_annulation IS NULL) AND a1_.id = ? AND a0_.utilisateur_id = ?
Parameters: 
[
  "annule"
  5
  14
]
View formatted query    View runnable query    Explain query
0.61 ms
(1.26%) 		1 
SELECT t0.id AS id_1, t0.num_allocataire AS num_allocataire_2, t0.quotient_familial AS quotient_familial_3, t0.nom_fichier AS nom_fichier_4, t0.fichier_size AS fichier_size_5, t0.updated_at AS updated_at_6, t0.qf_inconnu AS qf_inconnu_7, t0.regime_num_alloc_inconnu AS regime_num_alloc_inconnu_8, t0.qf_valide AS qf_valide_9, t0.validation_prioritaire AS validation_prioritaire_10, t0.type_regime_id AS type_regime_id_11, t12.id AS id_13, t12.roles AS roles_14, t12.password AS password_15, t12.is_verified AS is_verified_16, t12.nom AS nom_17, t12.prenom AS prenom_18, t12.username AS username_19, t12.token AS token_20, t12.token_mdp AS token_mdp_21, t12.desactivation_compte AS desactivation_compte_22, t12.created_at AS created_at_23, t12.refus_campagne AS refus_campagne_24, t12.compte_finalise AS compte_finalise_25, t12.coordonnees_id AS coordonnees_id_26, t12.info_allocataire_id AS info_allocataire_id_27 FROM info_allocataire t0 LEFT JOIN user t12 ON t12.info_allocataire_id = t0.id WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
0.60 ms
(1.22%) 		1 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.59 ms
(1.21%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.concerne AS concerne_6, t0.age_min AS age_min_7, t0.age_max AS age_max_8, t0.tarif AS tarif_9, t0.obligatoire AS obligatoire_10, t0.archive AS archive_11 FROM adhesion t0 INNER JOIN adhesion_sejour ON t0.id = adhesion_sejour.adhesion_id WHERE adhesion_sejour.sejour_id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
0.52 ms
(1.06%) 		1 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.statut AS statut_4, t0.montant AS montant_5, t0.statut_annulation AS statut_annulation_6, t0.adhesion_id AS adhesion_id_7, t0.utilisateur_id AS utilisateur_id_8, t0.personne_id AS personne_id_9, t0.commande_id AS commande_id_10, t0.annulation_id AS annulation_id_11 FROM adhesion_utilisateur t0 WHERE t0.utilisateur_id = ? AND t0.statut = ?
Parameters: 
[
  14
  "panier"
]
View formatted query    View runnable query    Explain query
0.43 ms
(0.88%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.label_reservation AS label_reservation_4, t0.obligatoire AS obligatoire_5 FROM champ t0 INNER JOIN sejour_champ ON t0.id = sejour_champ.champ_id WHERE sejour_champ.sejour_id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
0.42 ms
(0.86%) 		1 
SELECT t0.id AS id_1, t0.label AS label_2, t0.type AS type_3 FROM condition_reduction t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
0.40 ms
(0.82%) 		1 
SELECT t0.id AS id_1, t0.en_fonction AS en_fonction_2, t0.option_t_id AS option_t_id_3, t0.tarif_id AS tarif_id_4 FROM option_tarif t0 WHERE t0.tarif_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
0.40 ms
(0.82%) 		1 
SELECT t0.id AS id_1, t0.nom_type_justificatif AS nom_type_justificatif_2, t0.duree_de_vie AS duree_de_vie_3, t0.obligatoire AS obligatoire_4, t0.famille AS famille_5 FROM type_justificatif t0 INNER JOIN type_justificatif_sejour ON t0.id = type_justificatif_sejour.type_justificatif_id WHERE type_justificatif_sejour.sejour_id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
0.38 ms
(0.78%) 		1 
SELECT count(DISTINCT (e0_.id)) AS sclr_0 FROM enfant e0_ INNER JOIN reservation r1_ ON e0_.id = r1_.enfant_id WHERE r1_.id IN (?)
Parameters: 
[
  1224
]
View formatted query    View runnable query    Explain query
0.37 ms
(0.76%) 		1 
SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commune AS commune_3, t0.plein_tarif AS plein_tarif_4, t0.nom AS nom_5, t0.type_duree_id AS type_duree_id_6 FROM tarif t0 INNER JOIN tarif_sejour ON t0.id = tarif_sejour.tarif_id WHERE tarif_sejour.sejour_id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query
0.37 ms
(0.76%) 		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: 
[
  1
]
View formatted query    View runnable query    Explain query
0.37 ms
(0.75%) 		1 
SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commune AS commune_3, t0.plein_tarif AS plein_tarif_4, t0.nom AS nom_5, t0.type_duree_id AS type_duree_id_6 FROM tarif t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
0.31 ms
(0.63%) 		1 
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur_defaut AS valeur_defaut_3, t0.slug AS slug_4 FROM `option` t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query

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\Reservation 34
App\Entity\Commande 19
App\Entity\Annulation 12
App\Entity\Enfant 11
App\Entity\User 6
App\Entity\OptionTarif 5
App\Entity\Option 5
App\Entity\Coordonnees 3
App\Entity\PresenceSejour 2
App\Entity\InfoAllocataire 1
App\Entity\Sejour 1
App\Entity\Categorie 1
App\Entity\Variables 1
App\Entity\UniteTemps 1
App\Entity\Tarif 1
App\Entity\TypeRegime 1
App\Entity\Adhesion 1
App\Entity\RegleReduction 1
App\Entity\ConditionReduction 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Coordonnees No errors.
App\Entity\InfoAllocataire No errors.
App\Entity\Animateur No errors.
App\Entity\StatutEmploye No errors.
App\Entity\EstLie No errors.
App\Entity\Reservation No errors.
App\Entity\Annulation No errors.
App\Entity\ModePaiementCommande No errors.
App\Entity\AdhesionUtilisateur No errors.
App\Entity\Sejour No errors.
App\Entity\Categorie 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\CreneauActivite No errors.
App\Entity\RegleReduction No errors.
App\Entity\Champ No errors.
App\Entity\Adhesion No errors.
App\Entity\Variables No errors.
App\Entity\UniteTemps No errors.
App\Entity\QuotientFamilial No errors.
App\Entity\Commune No errors.
App\Entity\Enfant No errors.
App\Entity\Commande No errors.
App\Entity\PresenceSejour No errors.
App\Entity\Justificatif No errors.
App\Entity\ReservationCreneauActivite No errors.
App\Entity\ChampReservation No errors.
App\Entity\ContactUrgence No errors.
App\Entity\TypeRegime No errors.
App\Entity\JustificatifAnimateur No errors.
App\Entity\LienParente No errors.
App\Entity\MoyenPaiement No errors.
App\Entity\PaiementPartiel No errors.
App\Entity\TypeDuree No errors.
App\Entity\OptionTarif No errors.
App\Entity\DecoupageCreneau No errors.
App\Entity\ConditionReduction No errors.
App\Entity\Reduction No errors.
App\Entity\EnfantsMaladies No errors.
App\Entity\EnfantsAllergies No errors.
App\Entity\LienPaiement No errors.
App\Entity\StatutPresence No errors.
App\Entity\DecoupagePresence No errors.
App\Entity\PlateformePaiement No errors.
App\Entity\Option No errors.
App\Entity\DemiJourneeDecoupage No errors.
App\Entity\Maladie No errors.
App\Entity\Allergie No errors.
App\Entity\DemiJournee No errors.
App\Entity\HelloAssoToken No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\EnvoiBasicompta No errors.
App\Entity\CalculCommande No errors.
App\Entity\Noyau\Site No errors.
App\Entity\Fermeture No errors.
Vich\UploaderBundle\Entity\File No errors.