Symfony Profiler

Query Metrics

14 Database Queries

2 Different statements

8.76 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
7.88 ms (89.86%)	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_google_plus AS url_google_plus_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: [] View formatted query View runnable query Explain query 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_google_plus AS url_google_plus_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 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_google_plus AS url_google_plus_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;
0.89 ms (10.14%)	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: [`8`] View formatted query View runnable query Explain query 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 = ? 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 = 8;

Time▼

Count

Info

7.88 ms
(89.86%)

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_google_plus AS url_google_plus_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:

[]

View formatted query View runnable query Explain query

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_google_plus AS url_google_plus_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

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_google_plus AS url_google_plus_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;

0.89 ms
(10.14%)

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:

[
  8
]

View formatted query View runnable query Explain query

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 = ?

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 = 8;

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\Variables	No errors.
App\Entity\Coordonnees	No errors.
App\Entity\UniteTemps	No errors.
App\Entity\QuotientFamilial	No errors.
App\Entity\Commune	No errors.
App\Entity\User	No errors.
App\Entity\InfoAllocataire	No errors.
App\Entity\Sejour	No errors.
App\Entity\InfoHebergement	No errors.
App\Entity\ContactUrgence	No errors.

Symfony Profiler

GET http://test-asso.basicompta.fr/confidentialite

Configuration Settings

Theme