Symfony Profiler

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

SELECT
  DISTINCT s0_.id AS id_0,
  c1_.nom AS nom_1
FROM
  Structure s0_
  LEFT JOIN Commune c1_ ON s0_.commune_implementation_id = c1_.id
  LEFT JOIN Departement d2_ ON c1_.departement_id = d2_.id
WHERE
  s0_.type_structure_id = ?
  AND s0_.is_actif = 1
  AND s0_.is_delete = 0
ORDER BY
  c1_.nom ASC
LIMIT
  25
OFFSET
  825

SELECT DISTINCT s0_.id AS id_0, c1_.nom AS nom_1 FROM Structure s0_ LEFT JOIN Commune c1_ ON s0_.commune_implementation_id = c1_.id LEFT JOIN Departement d2_ ON c1_.departement_id = d2_.id WHERE s0_.type_structure_id = 4 AND s0_.is_actif = 1 AND s0_.is_delete = 0 ORDER BY c1_.nom ASC LIMIT 25 OFFSET 825;

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  Structure s0_
  LEFT JOIN Commune c1_ ON s0_.commune_implementation_id = c1_.id
  LEFT JOIN Departement d2_ ON c1_.departement_id = d2_.id
WHERE
  s0_.type_structure_id = ?
  AND s0_.is_actif = 1
  AND s0_.is_delete = 0

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM Structure s0_ LEFT JOIN Commune c1_ ON s0_.commune_implementation_id = c1_.id LEFT JOIN Departement d2_ ON c1_.departement_id = d2_.id WHERE s0_.type_structure_id = 4 AND s0_.is_actif = 1 AND s0_.is_delete = 0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  AdherentAutreFederation t0
  INNER JOIN structures_adherentAutreFederation ON t0.id = structures_adherentAutreFederation.adherent_autre_federation_id
WHERE
  structures_adherentAutreFederation.structure_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM AdherentAutreFederation t0 INNER JOIN structures_adherentAutreFederation ON t0.id = structures_adherentAutreFederation.adherent_autre_federation_id WHERE structures_adherentAutreFederation.structure_id = 447;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  PolitiqueVille t0
  INNER JOIN structures_politique_villes ON t0.id = structures_politique_villes.politique_ville_id
WHERE
  structures_politique_villes.structure_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM PolitiqueVille t0 INNER JOIN structures_politique_villes ON t0.id = structures_politique_villes.politique_ville_id WHERE structures_politique_villes.structure_id = 447;

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.adresse AS adresse_2,
  s0_.code_postal AS code_postal_3,
  s0_.telephone AS telephone_4,
  s0_.fax AS fax_5,
  s0_.site_internet AS site_internet_6,
  s0_.email AS email_7,
  s0_.code_ape AS code_ape_8,
  s0_.siret AS siret_9,
  s0_.directorName AS directorName_10,
  s0_.presidentName AS presidentName_11,
  s0_.login AS login_12,
  s0_.password AS password_13,
  s0_.is_actif AS is_actif_14,
  s0_.is_delete AS is_delete_15,
  s0_.dureeAgrement AS dureeAgrement_16,
  s0_.autre_mode_gestion AS autre_mode_gestion_17,
  s0_.haveSystemeAdhesion AS haveSystemeAdhesion_18,
  s0_.adhesionIndividuel AS adhesionIndividuel_19,
  s0_.adhesionFamiliale AS adhesionFamiliale_20,
  s0_.nbPersonneAdhesion AS nbPersonneAdhesion_21,
  s0_.nbParticipantActivite AS nbParticipantActivite_22,
  s0_.nbParticipantAction AS nbParticipantAction_23,
  s0_.nbParticipantPonctuel AS nbParticipantPonctuel_24,
  s0_.activityDomain AS activityDomain_25,
  s0_.is_adherent_federation AS is_adherent_federation_26,
  s0_.precision_adherent_autre_federation AS precision_adherent_autre_federation_27,
  s0_.is_gens_voyage AS is_gens_voyage_28,
  s0_.is_multiSite AS is_multiSite_29,
  s0_.is_itinerante AS is_itinerante_30,
  s0_.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_31,
  s0_.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_32,
  s0_.qpvNumbers AS qpvNumbers_33,
  s0_.zrrCities AS zrrCities_34,
  s0_.date_1er_agrement AS date_1er_agrement_35,
  s0_.populationZoneCompetence AS populationZoneCompetence_36,
  s0_.historique AS historique_37,
  s0_.nbCommuneUrbain AS nbCommuneUrbain_38,
  s0_.nbCommuneRural AS nbCommuneRural_39,
  s0_.observation AS observation_40,
  s0_.axe_projet_1 AS axe_projet_1_41,
  s0_.axe_projet_2 AS axe_projet_2_42,
  s0_.axe_projet_3 AS axe_projet_3_43,
  s0_.axe_projet_4 AS axe_projet_4_44,
  s0_.axe_projet_5 AS axe_projet_5_45,
  s0_.token AS token_46,
  s0_.logo AS logo_47,
  s0_.createdAt AS createdAt_48,
  s0_.updatedAt AS updatedAt_49,
  s0_.latitude AS latitude_50,
  s0_.longitude AS longitude_51,
  s0_.canShowCSO AS canShowCSO_52,
  s0_.canShowEVS AS canShowEVS_53,
  s0_.hasEVSAgrement AS hasEVSAgrement_54,
  s0_.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_55,
  s0_.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_56,
  s0_.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_57,
  s0_.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_58,
  c1_.id AS id_59,
  c1_.nom AS nom_60,
  c1_.nom_insee AS nom_insee_61,
  c1_.population AS population_62,
  c1_.insee AS insee_63,
  c1_.codePostal AS codePostal_64,
  c1_.aucode AS aucode_65,
  c1_.aulibelle AS aulibelle_66,
  c1_.latitude AS latitude_67,
  c1_.longitude AS longitude_68,
  d2_.id AS id_69,
  d2_.nom AS nom_70,
  d2_.num AS num_71,
  s0_.type_structure_id AS type_structure_id_72,
  s0_.commune_implementation_id AS commune_implementation_id_73,
  s0_.departement_id AS departement_id_74,
  s0_.region_id AS region_id_75,
  s0_.grandeRegion_id AS grandeRegion_id_76,
  s0_.mode_gestion_id AS mode_gestion_id_77,
  s0_.convention_collective_id AS convention_collective_id_78,
  s0_.agrement_id AS agrement_id_79,
  s0_.agrement_duree_id AS agrement_duree_id_80,
  s0_.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_81,
  s0_.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_82,
  s0_.adherent_autre_federation_id AS adherent_autre_federation_id_83,
  s0_.territoire_intervention_id AS territoire_intervention_id_84,
  s0_.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_85,
  s0_.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_86,
  s0_.user_id AS user_id_87,
  c1_.departement_id AS departement_id_88,
  d2_.region_id AS region_id_89
FROM
  Structure s0_
  LEFT JOIN Commune c1_ ON s0_.commune_implementation_id = c1_.id
  LEFT JOIN Departement d2_ ON c1_.departement_id = d2_.id
WHERE
  s0_.type_structure_id = ?
  AND s0_.is_actif = 1
  AND s0_.is_delete = 0
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  c1_.nom ASC

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.adresse AS adresse_2, s0_.code_postal AS code_postal_3, s0_.telephone AS telephone_4, s0_.fax AS fax_5, s0_.site_internet AS site_internet_6, s0_.email AS email_7, s0_.code_ape AS code_ape_8, s0_.siret AS siret_9, s0_.directorName AS directorName_10, s0_.presidentName AS presidentName_11, s0_.login AS login_12, s0_.password AS password_13, s0_.is_actif AS is_actif_14, s0_.is_delete AS is_delete_15, s0_.dureeAgrement AS dureeAgrement_16, s0_.autre_mode_gestion AS autre_mode_gestion_17, s0_.haveSystemeAdhesion AS haveSystemeAdhesion_18, s0_.adhesionIndividuel AS adhesionIndividuel_19, s0_.adhesionFamiliale AS adhesionFamiliale_20, s0_.nbPersonneAdhesion AS nbPersonneAdhesion_21, s0_.nbParticipantActivite AS nbParticipantActivite_22, s0_.nbParticipantAction AS nbParticipantAction_23, s0_.nbParticipantPonctuel AS nbParticipantPonctuel_24, s0_.activityDomain AS activityDomain_25, s0_.is_adherent_federation AS is_adherent_federation_26, s0_.precision_adherent_autre_federation AS precision_adherent_autre_federation_27, s0_.is_gens_voyage AS is_gens_voyage_28, s0_.is_multiSite AS is_multiSite_29, s0_.is_itinerante AS is_itinerante_30, s0_.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_31, s0_.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_32, s0_.qpvNumbers AS qpvNumbers_33, s0_.zrrCities AS zrrCities_34, s0_.date_1er_agrement AS date_1er_agrement_35, s0_.populationZoneCompetence AS populationZoneCompetence_36, s0_.historique AS historique_37, s0_.nbCommuneUrbain AS nbCommuneUrbain_38, s0_.nbCommuneRural AS nbCommuneRural_39, s0_.observation AS observation_40, s0_.axe_projet_1 AS axe_projet_1_41, s0_.axe_projet_2 AS axe_projet_2_42, s0_.axe_projet_3 AS axe_projet_3_43, s0_.axe_projet_4 AS axe_projet_4_44, s0_.axe_projet_5 AS axe_projet_5_45, s0_.token AS token_46, s0_.logo AS logo_47, s0_.createdAt AS createdAt_48, s0_.updatedAt AS updatedAt_49, s0_.latitude AS latitude_50, s0_.longitude AS longitude_51, s0_.canShowCSO AS canShowCSO_52, s0_.canShowEVS AS canShowEVS_53, s0_.hasEVSAgrement AS hasEVSAgrement_54, s0_.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_55, s0_.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_56, s0_.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_57, s0_.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_58, c1_.id AS id_59, c1_.nom AS nom_60, c1_.nom_insee AS nom_insee_61, c1_.population AS population_62, c1_.insee AS insee_63, c1_.codePostal AS codePostal_64, c1_.aucode AS aucode_65, c1_.aulibelle AS aulibelle_66, c1_.latitude AS latitude_67, c1_.longitude AS longitude_68, d2_.id AS id_69, d2_.nom AS nom_70, d2_.num AS num_71, s0_.type_structure_id AS type_structure_id_72, s0_.commune_implementation_id AS commune_implementation_id_73, s0_.departement_id AS departement_id_74, s0_.region_id AS region_id_75, s0_.grandeRegion_id AS grandeRegion_id_76, s0_.mode_gestion_id AS mode_gestion_id_77, s0_.convention_collective_id AS convention_collective_id_78, s0_.agrement_id AS agrement_id_79, s0_.agrement_duree_id AS agrement_duree_id_80, s0_.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_81, s0_.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_82, s0_.adherent_autre_federation_id AS adherent_autre_federation_id_83, s0_.territoire_intervention_id AS territoire_intervention_id_84, s0_.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_85, s0_.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_86, s0_.user_id AS user_id_87, c1_.departement_id AS departement_id_88, d2_.region_id AS region_id_89 FROM Structure s0_ LEFT JOIN Commune c1_ ON s0_.commune_implementation_id = c1_.id LEFT JOIN Departement d2_ ON c1_.departement_id = d2_.id WHERE s0_.type_structure_id = 4 AND s0_.is_actif = 1 AND s0_.is_delete = 0 AND s0_.id IN (447, 1102, 11999, 1139, 248, 1147, 807, 11091, 16650, 12693, 91, 11943, 12587, 554, 1001, 464, 1179, 453, 420, 15469, 10655, 12081, 694, 73, 601) ORDER BY c1_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  TerritoireInterventionUrbaine t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM TerritoireInterventionUrbaine t0 WHERE t0.id = 1;

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.num AS num_2,
  d0_.region_id AS region_id_3
FROM
  Departement d0_
ORDER BY
  d0_.nom ASC

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.num AS num_2, d0_.region_id AS region_id_3 FROM Departement d0_ ORDER BY d0_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  ModeGestion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ModeGestion t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  TerritoireIntervention t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM TerritoireIntervention t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  TypeStructure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM TypeStructure t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.grandeRegion_id AS grandeRegion_id_3
FROM
  Region t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.grandeRegion_id AS grandeRegion_id_3 FROM Region t0;