Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.53 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.41 ms	SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.is_admin AS is_admin_9, t0.is_super_admin AS is_super_admin_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.valideChart_at AS valideChart_at_13, t0.updated_at AS updated_at_14, t0.roles AS roles_15, t0.password AS password_16, t17.id AS id_18, t17.nom AS nom_19, t17.adresse AS adresse_20, t17.code_postal AS code_postal_21, t17.telephone AS telephone_22, t17.fax AS fax_23, t17.site_internet AS site_internet_24, t17.email AS email_25, t17.code_ape AS code_ape_26, t17.siret AS siret_27, t17.directorName AS directorName_28, t17.presidentName AS presidentName_29, t17.login AS login_30, t17.password AS password_31, t17.is_actif AS is_actif_32, t17.is_delete AS is_delete_33, t17.dureeAgrement AS dureeAgrement_34, t17.autre_mode_gestion AS autre_mode_gestion_35, t17.haveSystemeAdhesion AS haveSystemeAdhesion_36, t17.adhesionIndividuel AS adhesionIndividuel_37, t17.adhesionFamiliale AS adhesionFamiliale_38, t17.nbPersonneAdhesion AS nbPersonneAdhesion_39, t17.nbParticipantActivite AS nbParticipantActivite_40, t17.nbParticipantAction AS nbParticipantAction_41, t17.nbParticipantPonctuel AS nbParticipantPonctuel_42, t17.activityDomain AS activityDomain_43, t17.is_adherent_federation AS is_adherent_federation_44, t17.precision_adherent_autre_federation AS precision_adherent_autre_federation_45, t17.is_gens_voyage AS is_gens_voyage_46, t17.is_multiSite AS is_multiSite_47, t17.is_itinerante AS is_itinerante_48, t17.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_49, t17.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_50, t17.qpvNumbers AS qpvNumbers_51, t17.zrrCities AS zrrCities_52, t17.date_1er_agrement AS date_1er_agrement_53, t17.populationZoneCompetence AS populationZoneCompetence_54, t17.historique AS historique_55, t17.nbCommuneUrbain AS nbCommuneUrbain_56, t17.nbCommuneRural AS nbCommuneRural_57, t17.observation AS observation_58, t17.axe_projet_1 AS axe_projet_1_59, t17.axe_projet_2 AS axe_projet_2_60, t17.axe_projet_3 AS axe_projet_3_61, t17.axe_projet_4 AS axe_projet_4_62, t17.axe_projet_5 AS axe_projet_5_63, t17.token AS token_64, t17.logo AS logo_65, t17.createdAt AS createdAt_66, t17.updatedAt AS updatedAt_67, t17.latitude AS latitude_68, t17.longitude AS longitude_69, t17.canShowCSO AS canShowCSO_70, t17.canShowEVS AS canShowEVS_71, t17.hasEVSAgrement AS hasEVSAgrement_72, t17.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_73, t17.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_74, t17.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_75, t17.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_76, t17.type_structure_id AS type_structure_id_77, t17.commune_implementation_id AS commune_implementation_id_78, t17.departement_id AS departement_id_79, t17.region_id AS region_id_80, t17.grandeRegion_id AS grandeRegion_id_81, t17.mode_gestion_id AS mode_gestion_id_82, t17.convention_collective_id AS convention_collective_id_83, t17.agrement_id AS agrement_id_84, t17.agrement_duree_id AS agrement_duree_id_85, t17.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_86, t17.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_87, t17.adherent_autre_federation_id AS adherent_autre_federation_id_88, t17.territoire_intervention_id AS territoire_intervention_id_89, t17.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_90, t17.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_91, t17.user_id AS user_id_92, t0.region_id AS region_id_93 FROM User t0 LEFT JOIN Structure t17 ON t17.user_id = t0.id WHERE t0.id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.is_admin AS is_admin_9, t0.is_super_admin AS is_super_admin_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.valideChart_at AS valideChart_at_13, t0.updated_at AS updated_at_14, t0.roles AS roles_15, t0.password AS password_16, t17.id AS id_18, t17.nom AS nom_19, t17.adresse AS adresse_20, t17.code_postal AS code_postal_21, t17.telephone AS telephone_22, t17.fax AS fax_23, t17.site_internet AS site_internet_24, t17.email AS email_25, t17.code_ape AS code_ape_26, t17.siret AS siret_27, t17.directorName AS directorName_28, t17.presidentName AS presidentName_29, t17.login AS login_30, t17.password AS password_31, t17.is_actif AS is_actif_32, t17.is_delete AS is_delete_33, t17.dureeAgrement AS dureeAgrement_34, t17.autre_mode_gestion AS autre_mode_gestion_35, t17.haveSystemeAdhesion AS haveSystemeAdhesion_36, t17.adhesionIndividuel AS adhesionIndividuel_37, t17.adhesionFamiliale AS adhesionFamiliale_38, t17.nbPersonneAdhesion AS nbPersonneAdhesion_39, t17.nbParticipantActivite AS nbParticipantActivite_40, t17.nbParticipantAction AS nbParticipantAction_41, t17.nbParticipantPonctuel AS nbParticipantPonctuel_42, t17.activityDomain AS activityDomain_43, t17.is_adherent_federation AS is_adherent_federation_44, t17.precision_adherent_autre_federation AS precision_adherent_autre_federation_45, t17.is_gens_voyage AS is_gens_voyage_46, t17.is_multiSite AS is_multiSite_47, t17.is_itinerante AS is_itinerante_48, t17.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_49, t17.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_50, t17.qpvNumbers AS qpvNumbers_51, t17.zrrCities AS zrrCities_52, t17.date_1er_agrement AS date_1er_agrement_53, t17.populationZoneCompetence AS populationZoneCompetence_54, t17.historique AS historique_55, t17.nbCommuneUrbain AS nbCommuneUrbain_56, t17.nbCommuneRural AS nbCommuneRural_57, t17.observation AS observation_58, t17.axe_projet_1 AS axe_projet_1_59, t17.axe_projet_2 AS axe_projet_2_60, t17.axe_projet_3 AS axe_projet_3_61, t17.axe_projet_4 AS axe_projet_4_62, t17.axe_projet_5 AS axe_projet_5_63, t17.token AS token_64, t17.logo AS logo_65, t17.createdAt AS createdAt_66, t17.updatedAt AS updatedAt_67, t17.latitude AS latitude_68, t17.longitude AS longitude_69, t17.canShowCSO AS canShowCSO_70, t17.canShowEVS AS canShowEVS_71, t17.hasEVSAgrement AS hasEVSAgrement_72, t17.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_73, t17.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_74, t17.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_75, t17.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_76, t17.type_structure_id AS type_structure_id_77, t17.commune_implementation_id AS commune_implementation_id_78, t17.departement_id AS departement_id_79, t17.region_id AS region_id_80, t17.grandeRegion_id AS grandeRegion_id_81, t17.mode_gestion_id AS mode_gestion_id_82, t17.convention_collective_id AS convention_collective_id_83, t17.agrement_id AS agrement_id_84, t17.agrement_duree_id AS agrement_duree_id_85, t17.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_86, t17.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_87, t17.adherent_autre_federation_id AS adherent_autre_federation_id_88, t17.territoire_intervention_id AS territoire_intervention_id_89, t17.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_90, t17.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_91, t17.user_id AS user_id_92, t0.region_id AS region_id_93 FROM User t0 LEFT JOIN Structure t17 ON t17.user_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.is_admin AS is_admin_9, t0.is_super_admin AS is_super_admin_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.valideChart_at AS valideChart_at_13, t0.updated_at AS updated_at_14, t0.roles AS roles_15, t0.password AS password_16, t17.id AS id_18, t17.nom AS nom_19, t17.adresse AS adresse_20, t17.code_postal AS code_postal_21, t17.telephone AS telephone_22, t17.fax AS fax_23, t17.site_internet AS site_internet_24, t17.email AS email_25, t17.code_ape AS code_ape_26, t17.siret AS siret_27, t17.directorName AS directorName_28, t17.presidentName AS presidentName_29, t17.login AS login_30, t17.password AS password_31, t17.is_actif AS is_actif_32, t17.is_delete AS is_delete_33, t17.dureeAgrement AS dureeAgrement_34, t17.autre_mode_gestion AS autre_mode_gestion_35, t17.haveSystemeAdhesion AS haveSystemeAdhesion_36, t17.adhesionIndividuel AS adhesionIndividuel_37, t17.adhesionFamiliale AS adhesionFamiliale_38, t17.nbPersonneAdhesion AS nbPersonneAdhesion_39, t17.nbParticipantActivite AS nbParticipantActivite_40, t17.nbParticipantAction AS nbParticipantAction_41, t17.nbParticipantPonctuel AS nbParticipantPonctuel_42, t17.activityDomain AS activityDomain_43, t17.is_adherent_federation AS is_adherent_federation_44, t17.precision_adherent_autre_federation AS precision_adherent_autre_federation_45, t17.is_gens_voyage AS is_gens_voyage_46, t17.is_multiSite AS is_multiSite_47, t17.is_itinerante AS is_itinerante_48, t17.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_49, t17.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_50, t17.qpvNumbers AS qpvNumbers_51, t17.zrrCities AS zrrCities_52, t17.date_1er_agrement AS date_1er_agrement_53, t17.populationZoneCompetence AS populationZoneCompetence_54, t17.historique AS historique_55, t17.nbCommuneUrbain AS nbCommuneUrbain_56, t17.nbCommuneRural AS nbCommuneRural_57, t17.observation AS observation_58, t17.axe_projet_1 AS axe_projet_1_59, t17.axe_projet_2 AS axe_projet_2_60, t17.axe_projet_3 AS axe_projet_3_61, t17.axe_projet_4 AS axe_projet_4_62, t17.axe_projet_5 AS axe_projet_5_63, t17.token AS token_64, t17.logo AS logo_65, t17.createdAt AS createdAt_66, t17.updatedAt AS updatedAt_67, t17.latitude AS latitude_68, t17.longitude AS longitude_69, t17.canShowCSO AS canShowCSO_70, t17.canShowEVS AS canShowEVS_71, t17.hasEVSAgrement AS hasEVSAgrement_72, t17.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_73, t17.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_74, t17.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_75, t17.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_76, t17.type_structure_id AS type_structure_id_77, t17.commune_implementation_id AS commune_implementation_id_78, t17.departement_id AS departement_id_79, t17.region_id AS region_id_80, t17.grandeRegion_id AS grandeRegion_id_81, t17.mode_gestion_id AS mode_gestion_id_82, t17.convention_collective_id AS convention_collective_id_83, t17.agrement_id AS agrement_id_84, t17.agrement_duree_id AS agrement_duree_id_85, t17.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_86, t17.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_87, t17.adherent_autre_federation_id AS adherent_autre_federation_id_88, t17.territoire_intervention_id AS territoire_intervention_id_89, t17.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_90, t17.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_91, t17.user_id AS user_id_92, t0.region_id AS region_id_93 FROM User t0 LEFT JOIN Structure t17 ON t17.user_id = t0.id WHERE t0.id = 26;
2	0.12 ms	SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = ? SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 25;

#▲

Time

Info

0.41 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.is_admin AS is_admin_9, t0.is_super_admin AS is_super_admin_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.valideChart_at AS valideChart_at_13, t0.updated_at AS updated_at_14, t0.roles AS roles_15, t0.password AS password_16, t17.id AS id_18, t17.nom AS nom_19, t17.adresse AS adresse_20, t17.code_postal AS code_postal_21, t17.telephone AS telephone_22, t17.fax AS fax_23, t17.site_internet AS site_internet_24, t17.email AS email_25, t17.code_ape AS code_ape_26, t17.siret AS siret_27, t17.directorName AS directorName_28, t17.presidentName AS presidentName_29, t17.login AS login_30, t17.password AS password_31, t17.is_actif AS is_actif_32, t17.is_delete AS is_delete_33, t17.dureeAgrement AS dureeAgrement_34, t17.autre_mode_gestion AS autre_mode_gestion_35, t17.haveSystemeAdhesion AS haveSystemeAdhesion_36, t17.adhesionIndividuel AS adhesionIndividuel_37, t17.adhesionFamiliale AS adhesionFamiliale_38, t17.nbPersonneAdhesion AS nbPersonneAdhesion_39, t17.nbParticipantActivite AS nbParticipantActivite_40, t17.nbParticipantAction AS nbParticipantAction_41, t17.nbParticipantPonctuel AS nbParticipantPonctuel_42, t17.activityDomain AS activityDomain_43, t17.is_adherent_federation AS is_adherent_federation_44, t17.precision_adherent_autre_federation AS precision_adherent_autre_federation_45, t17.is_gens_voyage AS is_gens_voyage_46, t17.is_multiSite AS is_multiSite_47, t17.is_itinerante AS is_itinerante_48, t17.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_49, t17.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_50, t17.qpvNumbers AS qpvNumbers_51, t17.zrrCities AS zrrCities_52, t17.date_1er_agrement AS date_1er_agrement_53, t17.populationZoneCompetence AS populationZoneCompetence_54, t17.historique AS historique_55, t17.nbCommuneUrbain AS nbCommuneUrbain_56, t17.nbCommuneRural AS nbCommuneRural_57, t17.observation AS observation_58, t17.axe_projet_1 AS axe_projet_1_59, t17.axe_projet_2 AS axe_projet_2_60, t17.axe_projet_3 AS axe_projet_3_61, t17.axe_projet_4 AS axe_projet_4_62, t17.axe_projet_5 AS axe_projet_5_63, t17.token AS token_64, t17.logo AS logo_65, t17.createdAt AS createdAt_66, t17.updatedAt AS updatedAt_67, t17.latitude AS latitude_68, t17.longitude AS longitude_69, t17.canShowCSO AS canShowCSO_70, t17.canShowEVS AS canShowEVS_71, t17.hasEVSAgrement AS hasEVSAgrement_72, t17.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_73, t17.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_74, t17.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_75, t17.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_76, t17.type_structure_id AS type_structure_id_77, t17.commune_implementation_id AS commune_implementation_id_78, t17.departement_id AS departement_id_79, t17.region_id AS region_id_80, t17.grandeRegion_id AS grandeRegion_id_81, t17.mode_gestion_id AS mode_gestion_id_82, t17.convention_collective_id AS convention_collective_id_83, t17.agrement_id AS agrement_id_84, t17.agrement_duree_id AS agrement_duree_id_85, t17.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_86, t17.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_87, t17.adherent_autre_federation_id AS adherent_autre_federation_id_88, t17.territoire_intervention_id AS territoire_intervention_id_89, t17.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_90, t17.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_91, t17.user_id AS user_id_92, t0.region_id AS region_id_93 FROM User t0 LEFT JOIN Structure t17 ON t17.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  26
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.enabled AS enabled_4,
  t0.salt AS salt_5,
  t0.last_login AS last_login_6,
  t0.confirmation_token AS confirmation_token_7,
  t0.password_requested_at AS password_requested_at_8,
  t0.is_admin AS is_admin_9,
  t0.is_super_admin AS is_super_admin_10,
  t0.token AS token_11,
  t0.created_at AS created_at_12,
  t0.valideChart_at AS valideChart_at_13,
  t0.updated_at AS updated_at_14,
  t0.roles AS roles_15,
  t0.password AS password_16,
  t17.id AS id_18,
  t17.nom AS nom_19,
  t17.adresse AS adresse_20,
  t17.code_postal AS code_postal_21,
  t17.telephone AS telephone_22,
  t17.fax AS fax_23,
  t17.site_internet AS site_internet_24,
  t17.email AS email_25,
  t17.code_ape AS code_ape_26,
  t17.siret AS siret_27,
  t17.directorName AS directorName_28,
  t17.presidentName AS presidentName_29,
  t17.login AS login_30,
  t17.password AS password_31,
  t17.is_actif AS is_actif_32,
  t17.is_delete AS is_delete_33,
  t17.dureeAgrement AS dureeAgrement_34,
  t17.autre_mode_gestion AS autre_mode_gestion_35,
  t17.haveSystemeAdhesion AS haveSystemeAdhesion_36,
  t17.adhesionIndividuel AS adhesionIndividuel_37,
  t17.adhesionFamiliale AS adhesionFamiliale_38,
  t17.nbPersonneAdhesion AS nbPersonneAdhesion_39,
  t17.nbParticipantActivite AS nbParticipantActivite_40,
  t17.nbParticipantAction AS nbParticipantAction_41,
  t17.nbParticipantPonctuel AS nbParticipantPonctuel_42,
  t17.activityDomain AS activityDomain_43,
  t17.is_adherent_federation AS is_adherent_federation_44,
  t17.precision_adherent_autre_federation AS precision_adherent_autre_federation_45,
  t17.is_gens_voyage AS is_gens_voyage_46,
  t17.is_multiSite AS is_multiSite_47,
  t17.is_itinerante AS is_itinerante_48,
  t17.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_49,
  t17.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_50,
  t17.qpvNumbers AS qpvNumbers_51,
  t17.zrrCities AS zrrCities_52,
  t17.date_1er_agrement AS date_1er_agrement_53,
  t17.populationZoneCompetence AS populationZoneCompetence_54,
  t17.historique AS historique_55,
  t17.nbCommuneUrbain AS nbCommuneUrbain_56,
  t17.nbCommuneRural AS nbCommuneRural_57,
  t17.observation AS observation_58,
  t17.axe_projet_1 AS axe_projet_1_59,
  t17.axe_projet_2 AS axe_projet_2_60,
  t17.axe_projet_3 AS axe_projet_3_61,
  t17.axe_projet_4 AS axe_projet_4_62,
  t17.axe_projet_5 AS axe_projet_5_63,
  t17.token AS token_64,
  t17.logo AS logo_65,
  t17.createdAt AS createdAt_66,
  t17.updatedAt AS updatedAt_67,
  t17.latitude AS latitude_68,
  t17.longitude AS longitude_69,
  t17.canShowCSO AS canShowCSO_70,
  t17.canShowEVS AS canShowEVS_71,
  t17.hasEVSAgrement AS hasEVSAgrement_72,
  t17.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_73,
  t17.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_74,
  t17.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_75,
  t17.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_76,
  t17.type_structure_id AS type_structure_id_77,
  t17.commune_implementation_id AS commune_implementation_id_78,
  t17.departement_id AS departement_id_79,
  t17.region_id AS region_id_80,
  t17.grandeRegion_id AS grandeRegion_id_81,
  t17.mode_gestion_id AS mode_gestion_id_82,
  t17.convention_collective_id AS convention_collective_id_83,
  t17.agrement_id AS agrement_id_84,
  t17.agrement_duree_id AS agrement_duree_id_85,
  t17.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_86,
  t17.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_87,
  t17.adherent_autre_federation_id AS adherent_autre_federation_id_88,
  t17.territoire_intervention_id AS territoire_intervention_id_89,
  t17.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_90,
  t17.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_91,
  t17.user_id AS user_id_92,
  t0.region_id AS region_id_93
FROM
  User t0
  LEFT JOIN Structure t17 ON t17.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.salt AS salt_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.is_admin AS is_admin_9, t0.is_super_admin AS is_super_admin_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.valideChart_at AS valideChart_at_13, t0.updated_at AS updated_at_14, t0.roles AS roles_15, t0.password AS password_16, t17.id AS id_18, t17.nom AS nom_19, t17.adresse AS adresse_20, t17.code_postal AS code_postal_21, t17.telephone AS telephone_22, t17.fax AS fax_23, t17.site_internet AS site_internet_24, t17.email AS email_25, t17.code_ape AS code_ape_26, t17.siret AS siret_27, t17.directorName AS directorName_28, t17.presidentName AS presidentName_29, t17.login AS login_30, t17.password AS password_31, t17.is_actif AS is_actif_32, t17.is_delete AS is_delete_33, t17.dureeAgrement AS dureeAgrement_34, t17.autre_mode_gestion AS autre_mode_gestion_35, t17.haveSystemeAdhesion AS haveSystemeAdhesion_36, t17.adhesionIndividuel AS adhesionIndividuel_37, t17.adhesionFamiliale AS adhesionFamiliale_38, t17.nbPersonneAdhesion AS nbPersonneAdhesion_39, t17.nbParticipantActivite AS nbParticipantActivite_40, t17.nbParticipantAction AS nbParticipantAction_41, t17.nbParticipantPonctuel AS nbParticipantPonctuel_42, t17.activityDomain AS activityDomain_43, t17.is_adherent_federation AS is_adherent_federation_44, t17.precision_adherent_autre_federation AS precision_adherent_autre_federation_45, t17.is_gens_voyage AS is_gens_voyage_46, t17.is_multiSite AS is_multiSite_47, t17.is_itinerante AS is_itinerante_48, t17.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_49, t17.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_50, t17.qpvNumbers AS qpvNumbers_51, t17.zrrCities AS zrrCities_52, t17.date_1er_agrement AS date_1er_agrement_53, t17.populationZoneCompetence AS populationZoneCompetence_54, t17.historique AS historique_55, t17.nbCommuneUrbain AS nbCommuneUrbain_56, t17.nbCommuneRural AS nbCommuneRural_57, t17.observation AS observation_58, t17.axe_projet_1 AS axe_projet_1_59, t17.axe_projet_2 AS axe_projet_2_60, t17.axe_projet_3 AS axe_projet_3_61, t17.axe_projet_4 AS axe_projet_4_62, t17.axe_projet_5 AS axe_projet_5_63, t17.token AS token_64, t17.logo AS logo_65, t17.createdAt AS createdAt_66, t17.updatedAt AS updatedAt_67, t17.latitude AS latitude_68, t17.longitude AS longitude_69, t17.canShowCSO AS canShowCSO_70, t17.canShowEVS AS canShowEVS_71, t17.hasEVSAgrement AS hasEVSAgrement_72, t17.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_73, t17.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_74, t17.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_75, t17.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_76, t17.type_structure_id AS type_structure_id_77, t17.commune_implementation_id AS commune_implementation_id_78, t17.departement_id AS departement_id_79, t17.region_id AS region_id_80, t17.grandeRegion_id AS grandeRegion_id_81, t17.mode_gestion_id AS mode_gestion_id_82, t17.convention_collective_id AS convention_collective_id_83, t17.agrement_id AS agrement_id_84, t17.agrement_duree_id AS agrement_duree_id_85, t17.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_86, t17.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_87, t17.adherent_autre_federation_id AS adherent_autre_federation_id_88, t17.territoire_intervention_id AS territoire_intervention_id_89, t17.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_90, t17.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_91, t17.user_id AS user_id_92, t0.region_id AS region_id_93 FROM User t0 LEFT JOIN Structure t17 ON t17.user_id = t0.id WHERE t0.id = 26;

0.12 ms

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2,
  t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3,
  t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4,
  t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5,
  t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6,
  t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7,
  t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8,
  t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9,
  t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10,
  t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11,
  t0.moyenHumainLsQstID AS moyenHumainLsQstID_12,
  t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13,
  t0.moyenHumainInfo AS moyenHumainInfo_14,
  t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15,
  t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16,
  t0.themeCleTitle AS themeCleTitle_17,
  t0.themeCleBody AS themeCleBody_18,
  t0.pointSurTerritoire AS pointSurTerritoire_19,
  t0.analyse_divers AS analyse_divers_20,
  t0.createdAt AS createdAt_21,
  t0.updatedAt AS updatedAt_22,
  t0.logo_name AS logo_name_23,
  t0.logo_original_name AS logo_original_name_24,
  t0.logo_mime_type AS logo_mime_type_25,
  t0.logo_size AS logo_size_26,
  t0.logo_dimensions AS logo_dimensions_27,
  t0.structure_id AS structure_id_28,
  t0.ficheAction_id AS ficheAction_id_29
FROM
  FicheSynthetique t0
WHERE
  t0.structure_id = ?

SELECT t0.id AS id_1, t0.zoneCompetencePrecisionNbHabitants AS zoneCompetencePrecisionNbHabitants_2, t0.zoneSocialAxesFortsActionTerritoire AS zoneSocialAxesFortsActionTerritoire_3, t0.shortTitleProjetSocialPrecisionAxe1 AS shortTitleProjetSocialPrecisionAxe1_4, t0.projetSocialPrecisionAxe1 AS projetSocialPrecisionAxe1_5, t0.shortTitleProjetSocialPrecisionAxe2 AS shortTitleProjetSocialPrecisionAxe2_6, t0.projetSocialPrecisionAxe2 AS projetSocialPrecisionAxe2_7, t0.shortTitleProjetSocialPrecisionAxe3 AS shortTitleProjetSocialPrecisionAxe3_8, t0.projetSocialPrecisionAxe3 AS projetSocialPrecisionAxe3_9, t0.partenariatModalitesTravailemblematique AS partenariatModalitesTravailemblematique_10, t0.moyenHumainValorisationMethod AS moyenHumainValorisationMethod_11, t0.moyenHumainLsQstID AS moyenHumainLsQstID_12, t0.moyenHumainLsAnalyse AS moyenHumainLsAnalyse_13, t0.moyenHumainInfo AS moyenHumainInfo_14, t0.moyensfinanciersAnalyse AS moyensfinanciersAnalyse_15, t0.ficheActionEmblematiqueTitle AS ficheActionEmblematiqueTitle_16, t0.themeCleTitle AS themeCleTitle_17, t0.themeCleBody AS themeCleBody_18, t0.pointSurTerritoire AS pointSurTerritoire_19, t0.analyse_divers AS analyse_divers_20, t0.createdAt AS createdAt_21, t0.updatedAt AS updatedAt_22, t0.logo_name AS logo_name_23, t0.logo_original_name AS logo_original_name_24, t0.logo_mime_type AS logo_mime_type_25, t0.logo_size AS logo_size_26, t0.logo_dimensions AS logo_dimensions_27, t0.structure_id AS structure_id_28, t0.ficheAction_id AS ficheAction_id_29 FROM FicheSynthetique t0 WHERE t0.structure_id = 25;

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\User	No errors.
App\Entity\Structure	No errors.
App\Entity\TypeStructure	No errors.
App\Entity\Commune	No errors.
App\Entity\Departement	No errors.
App\Entity\Region	No errors.
App\Entity\GrandeRegion	No errors.
App\Entity\ModeGestion	No errors.
App\Entity\ConventionCollective	No errors.
App\Entity\Agrement	No errors.
App\Entity\AgrementDuree	No errors.
App\Entity\ModeGestionCollectiviteLocale	No errors.
App\Entity\ModeGestionCoGestion	No errors.
App\Entity\AdherentAutreFederation	No errors.
App\Entity\TerritoireIntervention	No errors.
App\Entity\TerritoireInterventionUrbaine	No errors.
App\Entity\TerritoireInterventionRurale	No errors.
App\Entity\Question	No errors.
App\Entity\Action	No errors.
App\Entity\SystemeAdhesionGoal	No errors.
App\Entity\PolitiqueVille	No errors.
App\Entity\FicheAction	No errors.
App\Entity\FicheSynthetique	No errors.
App\Entity\QPV	No errors.

Symfony Profiler

https://senacs.symfyp.fr/ajax/no-expire-sessions?_=1775724217596

Configuration Settings

Theme