Query Metrics
20
Database Queries
11
Different statements
2.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.49 ms |
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
Parameters:
[] |
| 2 | 0.17 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.grandeRegion_id AS grandeRegion_id_3 FROM Region t0
Parameters:
[] |
| 3 | 0.14 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionPublic t0
Parameters:
[] |
| 4 | 0.13 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionFamiliale t0
Parameters:
[] |
| 5 | 0.12 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionEconomique t0
Parameters:
[] |
| 6 | 0.12 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionEconomique t0
Parameters:
[] |
| 7 | 0.09 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionPolitique t0
Parameters:
[] |
| 8 | 0.09 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM ActionTag t0
Parameters:
[] |
| 9 | 0.13 ms |
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
Parameters:
[] |
| 10 | 0.11 ms |
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 750
Parameters:
[] |
| 11 | 0.19 ms |
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
Parameters:
[ 136 21 137 22 138 41 7 8 13 32 49 14 130 123 ] |
| 12 | 0.17 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:
[
861
]
|
| 13 | 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:
[
583
]
|
| 14 | 0.13 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:
[
1348
]
|
| 15 | 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:
[
224
]
|
| 16 | 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:
[
1098
]
|
| 17 | 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:
[
1364
]
|
| 18 | 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:
[
887
]
|
| 19 | 0.16 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:
[
667
]
|
| 20 | 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:
[
1175
]
|
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.