Query Metrics
32
Database Queries
18
Different statements
48.81 ms
Query time
0
Invalid entities
17
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.86 ms (26.35%) |
13 |
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:
[] |
7.45 ms (15.27%) |
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.commande_id = ?
Parameters:
[
225
]
|
5.85 ms (11.98%) |
2 |
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.commande_id = ?
Parameters:
[
225
]
|
4.60 ms (9.43%) |
1 |
SELECT t0.id AS id_1, t0.montant_paye AS montant_paye_2, t0.numero_cheque AS numero_cheque_3, t0.numero_avoir AS numero_avoir_4, t0.avoir_utilise AS avoir_utilise_5, t0.created_at AS created_at_6, t0.fin_validite AS fin_validite_7, t0.id_paiement AS id_paiement_8, t0.id_lien_paiement_stripe AS id_lien_paiement_stripe_9, t0.somme_remboursee AS somme_remboursee_10, t0.paiement_plusieurs_fois AS paiement_plusieurs_fois_11, t0.montant_attendu AS montant_attendu_12, t0.order_id AS order_id_13, t0.cancel_order AS cancel_order_14, t0.date_utilisation_avoir AS date_utilisation_avoir_15, t0.moyen_paiement_id AS moyen_paiement_id_16, t0.utilisateur_id AS utilisateur_id_17, t0.annulation_id AS annulation_id_18 FROM mode_paiement_commande t0 INNER JOIN commande_mode_paiement_commande ON t0.id = commande_mode_paiement_commande.mode_paiement_commande_id WHERE commande_mode_paiement_commande.commande_id = ?
Parameters:
[
225
]
|
3.80 ms (7.78%) |
1 |
SELECT t0.id AS id_1, t0.montant_paye AS montant_paye_2, t0.numero_cheque AS numero_cheque_3, t0.numero_avoir AS numero_avoir_4, t0.avoir_utilise AS avoir_utilise_5, t0.created_at AS created_at_6, t0.fin_validite AS fin_validite_7, t0.id_paiement AS id_paiement_8, t0.id_lien_paiement_stripe AS id_lien_paiement_stripe_9, t0.somme_remboursee AS somme_remboursee_10, t0.paiement_plusieurs_fois AS paiement_plusieurs_fois_11, t0.montant_attendu AS montant_attendu_12, t0.order_id AS order_id_13, t0.cancel_order AS cancel_order_14, t0.date_utilisation_avoir AS date_utilisation_avoir_15, t0.moyen_paiement_id AS moyen_paiement_id_16, t0.utilisateur_id AS utilisateur_id_17, t0.annulation_id AS annulation_id_18 FROM mode_paiement_commande t0 WHERE t0.id_lien_paiement_stripe = ?
Parameters:
[
"plink_1NEZlyCRNi71Da6w8UaTuIUb"
]
|
2.52 ms (5.17%) |
1 |
SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = ?
Parameters:
[
"225"
]
|
1.85 ms (3.79%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.key_secrete AS key_secrete_3, t0.key_public AS key_public_4, t0.moyen_paiement_id AS moyen_paiement_id_5 FROM plateforme_paiement t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
"Stripe"
]
|
1.49 ms (3.04%) |
1 |
SELECT u0_.id AS id_0, u0_.roles AS roles_1, u0_.password AS password_2, u0_.is_verified AS is_verified_3, u0_.nom AS nom_4, u0_.prenom AS prenom_5, u0_.username AS username_6, u0_.token AS token_7, u0_.token_mdp AS token_mdp_8, u0_.desactivation_compte AS desactivation_compte_9, u0_.created_at AS created_at_10, u0_.refus_campagne AS refus_campagne_11, u0_.compte_finalise AS compte_finalise_12, u0_.coordonnees_id AS coordonnees_id_13, u0_.info_allocataire_id AS info_allocataire_id_14 FROM user u0_ INNER JOIN reservation r1_ ON u0_.id = r1_.utilisateur_id WHERE r1_.commande_id = ?
Parameters:
[
225
]
|
1.47 ms (3.00%) |
1 |
SELECT t0.id AS id_1, t0.total_avant_reduc AS total_avant_reduc_2, t0.total_apres_reduc AS total_apres_reduc_3, t0.created_at AS created_at_4, t0.total_acompte AS total_acompte_5, t0.statut AS statut_6, t0.num_facture AS num_facture_7, t8.id AS id_9, t8.statut_paiement AS statut_paiement_10, t8.validation_admin AS validation_admin_11, t8.created_at AS created_at_12, t8.updated_at AS updated_at_13, t8.supprimer_commande_complete AS supprimer_commande_complete_14, t8.commentaire AS commentaire_15, t8.num_facture_avoir AS num_facture_avoir_16, t8.commande_id AS commande_id_17, t8.createur_id AS createur_id_18, t8.utilisateur_concerne_id AS utilisateur_concerne_id_19 FROM commande t0 LEFT JOIN annulation t8 ON t8.commande_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"225"
]
|
1.41 ms (2.89%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ordre_cheque AS ordre_cheque_3, t0.adresse_cheque AS adresse_cheque_4, t0.utilisation_admin AS utilisation_admin_5, t0.choix_parametre AS choix_parametre_6, t0.description_sur_place AS description_sur_place_7, t8.id AS id_9, t8.nom AS nom_10, t8.key_secrete AS key_secrete_11, t8.key_public AS key_public_12, t8.moyen_paiement_id AS moyen_paiement_id_13 FROM moyen_paiement t0 LEFT JOIN plateforme_paiement t8 ON t8.moyen_paiement_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
1.04 ms (2.14%) |
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:
[
20
]
|
1.02 ms (2.08%) |
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:
[
20
]
|
0.89 ms (1.83%) |
1 |
SELECT t0.id AS id_1, t0.date_naissance AS date_naissance_2, t0.pays_naissance AS pays_naissance_3, t0.code_postal_naissance AS code_postal_naissance_4, t0.commune_naissance AS commune_naissance_5, t0.numero_securite_social AS numero_securite_social_6, t0.intitule_poste AS intitule_poste_7, t0.nom_photo AS nom_photo_8, t0.updated_at_photo AS updated_at_photo_9, t0.notes AS notes_10, t0.code_insee AS code_insee_11, t0.user_id AS user_id_12, t0.statut_employe_id AS statut_employe_id_13 FROM animateur t0 WHERE t0.user_id = ?
Parameters:
[
14
]
|
0.80 ms (1.64%) |
1 |
SELECT t0.id AS id_1, t0.date_envoi AS date_envoi_2, t0.data AS data_3, t0.code_erreur AS code_erreur_4, t0.reference AS reference_5, t0.message_erreur AS message_erreur_6 FROM envoi_basicompta t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
225
]
|
0.50 ms (1.02%) |
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:
[
11
]
|
0.42 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.statut_paiement AS statut_paiement_2, t0.validation_admin AS validation_admin_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.supprimer_commande_complete AS supprimer_commande_complete_6, t0.commentaire AS commentaire_7, t0.num_facture_avoir AS num_facture_avoir_8, t0.commande_id AS commande_id_9, t0.createur_id AS createur_id_10, t0.utilisateur_concerne_id AS utilisateur_concerne_id_11 FROM annulation t0 WHERE t0.commande_id = ?
Parameters:
[
225
]
|
0.42 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.montant_deduit AS montant_deduit_2, t0.regle_reduction_id AS regle_reduction_id_3, t0.commande_id AS commande_id_4 FROM reduction t0 WHERE t0.commande_id = ?
Parameters:
[
225
]
|
0.41 ms (0.84%) |
1 |
SELECT t0.id AS id_1, t0.nom_categorie AS nom_categorie_2, t0.description AS description_3, t0.nom_image AS nom_image_4, t0.updated_at AS updated_at_5, t0.parent_categorie_id AS parent_categorie_id_6 FROM categorie 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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Coordonnees | 3 |
App\Entity\PlateformePaiement | 2 |
App\Entity\Commande | 1 |
App\Entity\User | 1 |
App\Entity\InfoAllocataire | 1 |
App\Entity\ModePaiementCommande | 1 |
App\Entity\MoyenPaiement | 1 |
App\Entity\Reservation | 1 |
App\Entity\Enfant | 1 |
App\Entity\Sejour | 1 |
App\Entity\Tarif | 1 |
App\Entity\Variables | 1 |
App\Entity\UniteTemps | 1 |
App\Entity\Categorie | 1 |