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

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
  a0_.id AS id_0,
  a0_.intitule AS intitule_1,
  a0_.referent AS referent_2,
  a0_.email AS email_3,
  a0_.descriptif AS descriptif_4,
  a0_.origine AS origine_5,
  a0_.objectif AS objectif_6,
  a0_.impact AS impact_7,
  a0_.reussite AS reussite_8,
  a0_.limite AS limite_9,
  a0_.path AS path_10,
  a0_.created AS created_11,
  a0_.updated AS updated_12,
  s1_.id AS id_13,
  s1_.nom AS nom_14,
  s1_.adresse AS adresse_15,
  s1_.code_postal AS code_postal_16,
  s1_.telephone AS telephone_17,
  s1_.fax AS fax_18,
  s1_.site_internet AS site_internet_19,
  s1_.email AS email_20,
  s1_.code_ape AS code_ape_21,
  s1_.siret AS siret_22,
  s1_.directorName AS directorName_23,
  s1_.presidentName AS presidentName_24,
  s1_.login AS login_25,
  s1_.password AS password_26,
  s1_.is_actif AS is_actif_27,
  s1_.is_delete AS is_delete_28,
  s1_.dureeAgrement AS dureeAgrement_29,
  s1_.autre_mode_gestion AS autre_mode_gestion_30,
  s1_.haveSystemeAdhesion AS haveSystemeAdhesion_31,
  s1_.adhesionIndividuel AS adhesionIndividuel_32,
  s1_.adhesionFamiliale AS adhesionFamiliale_33,
  s1_.nbPersonneAdhesion AS nbPersonneAdhesion_34,
  s1_.nbParticipantActivite AS nbParticipantActivite_35,
  s1_.nbParticipantAction AS nbParticipantAction_36,
  s1_.nbParticipantPonctuel AS nbParticipantPonctuel_37,
  s1_.activityDomain AS activityDomain_38,
  s1_.is_adherent_federation AS is_adherent_federation_39,
  s1_.precision_adherent_autre_federation AS precision_adherent_autre_federation_40,
  s1_.is_gens_voyage AS is_gens_voyage_41,
  s1_.is_multiSite AS is_multiSite_42,
  s1_.is_itinerante AS is_itinerante_43,
  s1_.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_44,
  s1_.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_45,
  s1_.qpvNumbers AS qpvNumbers_46,
  s1_.zrrCities AS zrrCities_47,
  s1_.date_1er_agrement AS date_1er_agrement_48,
  s1_.populationZoneCompetence AS populationZoneCompetence_49,
  s1_.historique AS historique_50,
  s1_.nbCommuneUrbain AS nbCommuneUrbain_51,
  s1_.nbCommuneRural AS nbCommuneRural_52,
  s1_.observation AS observation_53,
  s1_.axe_projet_1 AS axe_projet_1_54,
  s1_.axe_projet_2 AS axe_projet_2_55,
  s1_.axe_projet_3 AS axe_projet_3_56,
  s1_.axe_projet_4 AS axe_projet_4_57,
  s1_.axe_projet_5 AS axe_projet_5_58,
  s1_.token AS token_59,
  s1_.logo AS logo_60,
  s1_.createdAt AS createdAt_61,
  s1_.updatedAt AS updatedAt_62,
  s1_.latitude AS latitude_63,
  s1_.longitude AS longitude_64,
  s1_.canShowCSO AS canShowCSO_65,
  s1_.canShowEVS AS canShowEVS_66,
  s1_.hasEVSAgrement AS hasEVSAgrement_67,
  s1_.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_68,
  s1_.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_69,
  s1_.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_70,
  s1_.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_71,
  d2_.id AS id_72,
  d2_.nom AS nom_73,
  d2_.num AS num_74,
  a0_.structure_id AS structure_id_75,
  a0_.action_public_id AS action_public_id_76,
  a0_.action_culturelle_id AS action_culturelle_id_77,
  a0_.action_economique_id AS action_economique_id_78,
  a0_.action_familiale_id AS action_familiale_id_79,
  a0_.action_politique_id AS action_politique_id_80,
  s1_.type_structure_id AS type_structure_id_81,
  s1_.commune_implementation_id AS commune_implementation_id_82,
  s1_.departement_id AS departement_id_83,
  s1_.region_id AS region_id_84,
  s1_.grandeRegion_id AS grandeRegion_id_85,
  s1_.mode_gestion_id AS mode_gestion_id_86,
  s1_.convention_collective_id AS convention_collective_id_87,
  s1_.agrement_id AS agrement_id_88,
  s1_.agrement_duree_id AS agrement_duree_id_89,
  s1_.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_90,
  s1_.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_91,
  s1_.adherent_autre_federation_id AS adherent_autre_federation_id_92,
  s1_.territoire_intervention_id AS territoire_intervention_id_93,
  s1_.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_94,
  s1_.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_95,
  s1_.user_id AS user_id_96,
  d2_.region_id AS region_id_97
FROM
  Action a0_
  INNER JOIN Structure s1_ ON a0_.structure_id = s1_.id
  INNER JOIN Departement d2_ ON s1_.departement_id = d2_.id
WHERE
  s1_.is_delete = 0
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.created DESC

SELECT a0_.id AS id_0, a0_.intitule AS intitule_1, a0_.referent AS referent_2, a0_.email AS email_3, a0_.descriptif AS descriptif_4, a0_.origine AS origine_5, a0_.objectif AS objectif_6, a0_.impact AS impact_7, a0_.reussite AS reussite_8, a0_.limite AS limite_9, a0_.path AS path_10, a0_.created AS created_11, a0_.updated AS updated_12, s1_.id AS id_13, s1_.nom AS nom_14, s1_.adresse AS adresse_15, s1_.code_postal AS code_postal_16, s1_.telephone AS telephone_17, s1_.fax AS fax_18, s1_.site_internet AS site_internet_19, s1_.email AS email_20, s1_.code_ape AS code_ape_21, s1_.siret AS siret_22, s1_.directorName AS directorName_23, s1_.presidentName AS presidentName_24, s1_.login AS login_25, s1_.password AS password_26, s1_.is_actif AS is_actif_27, s1_.is_delete AS is_delete_28, s1_.dureeAgrement AS dureeAgrement_29, s1_.autre_mode_gestion AS autre_mode_gestion_30, s1_.haveSystemeAdhesion AS haveSystemeAdhesion_31, s1_.adhesionIndividuel AS adhesionIndividuel_32, s1_.adhesionFamiliale AS adhesionFamiliale_33, s1_.nbPersonneAdhesion AS nbPersonneAdhesion_34, s1_.nbParticipantActivite AS nbParticipantActivite_35, s1_.nbParticipantAction AS nbParticipantAction_36, s1_.nbParticipantPonctuel AS nbParticipantPonctuel_37, s1_.activityDomain AS activityDomain_38, s1_.is_adherent_federation AS is_adherent_federation_39, s1_.precision_adherent_autre_federation AS precision_adherent_autre_federation_40, s1_.is_gens_voyage AS is_gens_voyage_41, s1_.is_multiSite AS is_multiSite_42, s1_.is_itinerante AS is_itinerante_43, s1_.is_territoire_revitalisation_rurale AS is_territoire_revitalisation_rurale_44, s1_.territoire_revitalisation_rurale AS territoire_revitalisation_rurale_45, s1_.qpvNumbers AS qpvNumbers_46, s1_.zrrCities AS zrrCities_47, s1_.date_1er_agrement AS date_1er_agrement_48, s1_.populationZoneCompetence AS populationZoneCompetence_49, s1_.historique AS historique_50, s1_.nbCommuneUrbain AS nbCommuneUrbain_51, s1_.nbCommuneRural AS nbCommuneRural_52, s1_.observation AS observation_53, s1_.axe_projet_1 AS axe_projet_1_54, s1_.axe_projet_2 AS axe_projet_2_55, s1_.axe_projet_3 AS axe_projet_3_56, s1_.axe_projet_4 AS axe_projet_4_57, s1_.axe_projet_5 AS axe_projet_5_58, s1_.token AS token_59, s1_.logo AS logo_60, s1_.createdAt AS createdAt_61, s1_.updatedAt AS updatedAt_62, s1_.latitude AS latitude_63, s1_.longitude AS longitude_64, s1_.canShowCSO AS canShowCSO_65, s1_.canShowEVS AS canShowEVS_66, s1_.hasEVSAgrement AS hasEVSAgrement_67, s1_.hasactionToHelpPersonRightsAccess AS hasactionToHelpPersonRightsAccess_68, s1_.actionsToHelpPersonRightsAccess AS actionsToHelpPersonRightsAccess_69, s1_.actionsToHelpPersonRightsAccessOther AS actionsToHelpPersonRightsAccessOther_70, s1_.nbAssociationAdhereProjetStructure AS nbAssociationAdhereProjetStructure_71, d2_.id AS id_72, d2_.nom AS nom_73, d2_.num AS num_74, a0_.structure_id AS structure_id_75, a0_.action_public_id AS action_public_id_76, a0_.action_culturelle_id AS action_culturelle_id_77, a0_.action_economique_id AS action_economique_id_78, a0_.action_familiale_id AS action_familiale_id_79, a0_.action_politique_id AS action_politique_id_80, s1_.type_structure_id AS type_structure_id_81, s1_.commune_implementation_id AS commune_implementation_id_82, s1_.departement_id AS departement_id_83, s1_.region_id AS region_id_84, s1_.grandeRegion_id AS grandeRegion_id_85, s1_.mode_gestion_id AS mode_gestion_id_86, s1_.convention_collective_id AS convention_collective_id_87, s1_.agrement_id AS agrement_id_88, s1_.agrement_duree_id AS agrement_duree_id_89, s1_.mode_gestion_collectivite_locale_id AS mode_gestion_collectivite_locale_id_90, s1_.mode_gestion_co_gestion_id AS mode_gestion_co_gestion_id_91, s1_.adherent_autre_federation_id AS adherent_autre_federation_id_92, s1_.territoire_intervention_id AS territoire_intervention_id_93, s1_.territoire_intervention_urbaine_id AS territoire_intervention_urbaine_id_94, s1_.territoire_intervention_rurale_id AS territoire_intervention_rurale_id_95, s1_.user_id AS user_id_96, d2_.region_id AS region_id_97 FROM Action a0_ INNER JOIN Structure s1_ ON a0_.structure_id = s1_.id INNER JOIN Departement d2_ ON s1_.departement_id = d2_.id WHERE s1_.is_delete = 0 AND a0_.id IN (64, 141, 26, 45, 65, 142, 27, 46, 66, 28, 47, 67, 48, 70, 71, 33, 50, 72, 15, 17, 18, 134, 19, 135, 20) ORDER BY a0_.created DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  ActionEconomique t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionEconomique t0;

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;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  Action a0_
  INNER JOIN Structure s1_ ON a0_.structure_id = s1_.id
  INNER JOIN Departement d2_ ON s1_.departement_id = d2_.id
WHERE
  s1_.is_delete = 0

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM Action a0_ INNER JOIN Structure s1_ ON a0_.structure_id = s1_.id INNER JOIN Departement d2_ ON s1_.departement_id = d2_.id WHERE s1_.is_delete = 0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  ActionPublic t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionPublic t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  ActionFamiliale t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionFamiliale t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  ActionPolitique t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionPolitique t0;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created AS created_1
FROM
  Action a0_
  INNER JOIN Structure s1_ ON a0_.structure_id = s1_.id
  INNER JOIN Departement d2_ ON s1_.departement_id = d2_.id
WHERE
  s1_.is_delete = 0
ORDER BY
  a0_.created DESC
LIMIT
  25
OFFSET
  725

SELECT DISTINCT a0_.id AS id_0, a0_.created AS created_1 FROM Action a0_ INNER JOIN Structure s1_ ON a0_.structure_id = s1_.id INNER JOIN Departement d2_ ON s1_.departement_id = d2_.id WHERE s1_.is_delete = 0 ORDER BY a0_.created DESC LIMIT 25 OFFSET 725;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  ActionTag t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionTag t0;