Query Metrics
46
Database Queries
16
Different statements
29.20 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
13.24 ms (45.33%) |
20 |
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.token_basicompta AS token_basicompta_50, t0.created_interco_basicompta AS created_interco_basicompta_51, t0.comptabilisation_heures_presence AS comptabilisation_heures_presence_52, t0.forfait_demi_journee AS forfait_demi_journee_53, t0.forfait_journee AS forfait_journee_54, t0.autorisation_paiements_plusieurs_fois AS autorisation_paiements_plusieurs_fois_55, t0.nbre_max_paiements_plusieurs_fois AS nbre_max_paiements_plusieurs_fois_56, t0.montant_minimum_paiements_plusieurs_fois AS montant_minimum_paiements_plusieurs_fois_57, t0.pourcentage_montant_initial_paiement_plusieurs_fois AS pourcentage_montant_initial_paiement_plusieurs_fois_58, t0.date_rapatriement_basicompta AS date_rapatriement_basicompta_59, t0.type_delai_blocage_accueil AS type_delai_blocage_accueil_60, t0.desactivation_qf AS desactivation_qf_61, t0.nom_tampon AS nom_tampon_62, t0.fonction_directeur AS fonction_directeur_63, t0.inscription_adultes AS inscription_adultes_64, t0.unite_presence_sejour AS unite_presence_sejour_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:
[] |
2.88 ms (9.85%) |
7 |
SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ INNER JOIN type_duree t1_ ON t0_.type_duree_id = t1_.id WHERE t0_.plein_tarif = ? AND EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t0_.id AND t2_.sejour_id IN (?)) AND t0_.commune IS NULL AND t1_.nom = ? LIMIT 1
Parameters:
[ 0 80 "Soir" ] |
1.87 ms (6.42%) |
6 |
SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = ? AND q0_.qfmin = ? AND q0_.qfmax = ? LIMIT 1
Parameters:
[ 32 0 300 ] |
1.32 ms (4.51%) |
1 |
SELECT DISTINCT t0_.id AS id_0, t0_.nom AS nom_1, t0_.duree AS duree_2, t0_.h_debut AS h_debut_3, t0_.h_fin AS h_fin_4, t0_.jour_dispo AS jour_dispo_5, t0_.demi_journees_dispo AS demi_journees_dispo_6, t0_.h_debut_aprem AS h_debut_aprem_7, t0_.h_fin_aprem AS h_fin_aprem_8, t0_.matin_aprem AS matin_aprem_9 FROM type_duree t0_ INNER JOIN tarif t1_ ON t0_.id = t1_.type_duree_id WHERE EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t1_.id AND t2_.sejour_id IN (?)) ORDER BY t0_.duree ASC
Parameters:
[
80
]
|
1.18 ms (4.03%) |
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:
[
80
]
|
1.17 ms (4.01%) |
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:
[
"80"
]
|
1.16 ms (3.97%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.num_tel AS num_tel_3, t0.adresse1 AS adresse1_4, t0.adresse2 AS adresse2_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.nom_adresse AS nom_adresse_8, t0.tel_pro AS tel_pro_9, t0.code_insee AS code_insee_10, t0.creation_admin AS creation_admin_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 coordonnees t0 LEFT JOIN user t12 ON t12.coordonnees_id = t0.id WHERE t0.id = ?
Parameters:
[
34
]
|
1.04 ms (3.57%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.nom_periode AS nom_periode_3, t0.nb_places_prises AS nb_places_prises_4, t0.num_semaine AS num_semaine_5, t0.en_liste_attente AS en_liste_attente_6, t0.activite_id AS activite_id_7 FROM creneau_activite t0 WHERE t0.activite_id = ?
Parameters:
[
80
]
|
1.04 ms (3.55%) |
1 |
SELECT t0.id AS id_1, t0.nom_hebergement AS nom_hebergement_2, t0.description AS description_3, t0.coordonnees_id AS coordonnees_id_4 FROM info_hebergement t0 INNER JOIN info_hebergement_sejour ON t0.id = info_hebergement_sejour.info_hebergement_id WHERE info_hebergement_sejour.sejour_id = ?
Parameters:
[
80
]
|
0.92 ms (3.15%) |
1 |
SELECT DISTINCT q0_.qfmin AS qfmin_0, q0_.qfmax AS qfmax_1, q0_.nom AS nom_2 FROM quotient_familial q0_ INNER JOIN tarif t1_ ON q0_.tarif_id = t1_.id WHERE EXISTS (SELECT 1 FROM tarif_sejour t2_ WHERE t2_.tarif_id = t1_.id AND t2_.sejour_id IN (?)) AND t1_.type_duree_id = ?
Parameters:
[ 80 12 ] |
0.79 ms (2.72%) |
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:
[
80
]
|
0.68 ms (2.32%) |
1 |
SELECT o0_.id AS id_0, o0_.label AS label_1, o0_.valeur_defaut AS valeur_defaut_2, o0_.slug AS slug_3 FROM `option` o0_ INNER JOIN option_tarif o1_ ON o0_.id = o1_.option_t_id INNER JOIN tarif t2_ ON o1_.tarif_id = t2_.id WHERE t2_.id IN (?) AND o1_.en_fonction IS NOT NULL
Parameters:
[
32
]
|
0.58 ms (1.98%) |
1 |
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.updated_at AS updated_at_3, t0.sejour_id AS sejour_id_4, t0.info_hebergement_id AS info_hebergement_id_5 FROM image t0 WHERE t0.sejour_id = ?
Parameters:
[
80
]
|
0.49 ms (1.70%) |
1 |
SELECT t0_.id AS id_0, t0_.prix AS prix_1, t0_.commune AS commune_2, t0_.plein_tarif AS plein_tarif_3, t0_.nom AS nom_4, t0_.type_duree_id AS type_duree_id_5 FROM tarif t0_ WHERE EXISTS (SELECT 1 FROM tarif_sejour t1_ WHERE t1_.tarif_id = t0_.id AND t1_.sejour_id IN (?)) AND t0_.type_duree_id = ?
Parameters:
[ 80 12 ] |
0.49 ms (1.68%) |
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:
[
80
]
|
0.36 ms (1.23%) |
1 |
SELECT q0_.id AS id_0, q0_.qfmin AS qfmin_1, q0_.qfmax AS qfmax_2, q0_.nom AS nom_3, q0_.prix_qf AS prix_qf_4, q0_.tarif_id AS tarif_id_5, q0_.variables_id AS variables_id_6 FROM quotient_familial q0_ WHERE q0_.tarif_id = ? AND q0_.qfmin = ? AND q0_.qfmax IS NULL LIMIT 1
Parameters:
[ 32 2201 ] |
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\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\ContactUrgence | No errors. |
App\Entity\Variables | No errors. |
App\Entity\TypeDuree | No errors. |
App\Entity\QuotientFamilial | No errors. |
App\Entity\ReservationCreneauActivite | No errors. |
App\Entity\OptionTarif | No errors. |
App\Entity\DecoupageCreneau | No errors. |
App\Entity\Option | No errors. |
App\Entity\UniteTemps | No errors. |
App\Entity\Commune | No errors. |