Symfony Profiler

select
  DISTINCT up.numec as numec_up,
  tu.id_gabriel as type_up_id,
  up.code_rne,
  up.id_gabriel,
  up.nom_courant,
  up.etablissement,
  adresse_cap.locality as ville,
  CONCAT_WS(
    ' ', adresse_cap.street_number, adresse_cap.street_number_ext,
    adresse_cap.street_name
  ) as adresse1,
  ac.telephone1,
  adresse_cap.postal_code as cp,
  ac.mail1,
  ac.fax1,
  ac.site_web,
  dep_up.id_gabriel as departement,
  tu.libelle_long as type_up,
  up.latitude,
  up.longitude,
  e.nom_courant as etb_nom,
  co.libelle_long as contrat,
  st.nom_usage as academie,
  st.id_gabriel as academie_id,
  s.nom_usage as diocese,
  s.id_gabriel as diocese_id,
  de.libelle_long as degre,
  up.statut,
  up.projet,
  inte.libelle_long as internat,
  up.internat_desc,
  up.etude,
  up.etude_desc,
  up.horaire_ouverture,
  up.horaire_fermeture,
  mi.libelle_long as ministere_tutelle,
  up.ecole_circonscription,
  ntu.libelle_long as type_tutelle,
  up.accueil_peri_scolaire_matin,
  accueil_peri_scolaire_soir,
  aff.libelle_long as affiliation,
  up.photo,
  up.nb_filles,
  up.nb_garcons,
  up.effectifs_total,
  up.effectifs_total_items,
  up.effectif_hors_contrat,
  civ.libelle_long as civilite,
  i.prenom_usuel as prenom,
  i.nom as nom,
  struct.nom_usage as ogec,
  up.ogec as id_ogec,
  torg.libelle_long as organisme,
  up.transport,
  up.demi_pension,
  ntp.libelle_long as lib_pension,
  up.internat as internat_code,
  njo.libelle_long jours,
  CASE WHEN up.latitude = 0 THEN
    NULL
  WHEN up.latitude = 99 THEN
    NULL
  WHEN up.latitude IS NULL THEN
    NULL
  ELSE
    CONCAT(up.latitude, ',', up.longitude)
  END AS coord,
  (
    SELECT
      DISTINCT array_agg(nl.libelle_langue)
    FROM
      annuaire._n_langues as nl
      INNER JOIN annuaire._a_langue_up as alu2 ON alu2.langue_id = nl.id_gabriel
    WHERE
      alu2.up_id = up.id_gabriel
  ) as langues,
  (
    SELECT
      DISTINCT array_agg(nd.libelle_dispositif)
    FROM
      annuaire._n_dispositif as nd
      INNER JOIN annuaire._a_dispositif_up as adu2 ON adu2.dispositif_id = nd.id_gabriel
    WHERE
      adu2.up_id = up.id_gabriel
  ) as dispositifs,
  (
    SELECT
      DISTINCT array_agg(';' || alu3.langue_id || ';')
    FROM
      annuaire._a_langue_up as alu3
    WHERE
      alu3.up_id = up.id_gabriel
  ) as langues_id,
  (
    SELECT
      array_agg(
        concat(source || ' - ' || formation)
      )
    FROM
      annuaire._n_formations AS nf
      INNER JOIN annuaire._a_formation_up AS afu2 ON afu2.formation_id = nf.id_gabriel
    WHERE
      afu2.up_id = up.id_gabriel
  ) as formations,
  case when (
    SELECT
      po.id_gabriel
    FROM
      annuaire.portes_ouvertes po
      INNER JOIN annuaire._a_formations_portes_ouvertes afpo on afpo.id_portes_ouvertes = po.id_gabriel
      INNER JOIN annuaire._n_formations_portes_ouvertes nfpo on nfpo.id_gabriel = afpo.id_formations
    WHERE
      po.id_up = up.id_gabriel
      and po.date_debut between CURRENT_DATE - interval '1 month'
      and CURRENT_DATE + interval '1 year'
    limit
      1
  ) is null then
    0
  else
    1
  end as portes_ouvertes,
  (
    SELECT
      array_agg(filiere)
    FROM
      annuaire._n_option_matiere nom
      INNER JOIN annuaire._a_specificite_up AS asu2 ON asu2.specificite_id = nom.id_gabriel
    WHERE
      asu2.up_id = up.id_gabriel
  ) as specificites,
  r.libelle_edition AS region,
  up.type_structure,
  up.validation_items_id
from
  annuaire.up
  inner join annuaire.etablissement e on e.id_gabriel = up.etablissement
  inner join annuaire.adresse_communication ac on ac.id_gabriel = up.adresse
  LEFT JOIN annuaire.adresse_cap adresse_cap ON adresse_cap.numec = up.numec
  AND adresse_cap.doublon IS NULL
  LEFT JOIN annuaire._n_departement dep_up ON dep_up.code_departement = adresse_cap.code_departement
  left join annuaire._n_region r on dep_up.code_region_interne = r.id_gabriel
  left join annuaire._n_type_organisme torg on torg.id_gabriel = e.type_organisme
  left join annuaire.structure struct on struct.id_gabriel = up.ogec
  left join annuaire.individu i ON i.id_gabriel = up.cetb_id
  left join annuaire._n_civilite civ on civ.id_gabriel = i.civilite
  left join annuaire._n_affiliation aff on aff.id_gabriel = up.affiliation
  left join annuaire._n_nat_tutelle ntu on ntu.id_gabriel = up.type_tutelle
  left join annuaire._n_ministere mi on mi.id_gabriel = up.ministere_tutelle
  left join annuaire._n_internat inte on inte.id_gabriel = up.internat
  left join annuaire._n_degre de on de.id_gabriel = up.degre
  left join annuaire.structure s on s.id_gabriel = up.diocese
  left join annuaire.structure st on st.id_gabriel = dep_up.code_academie_interne
  left join annuaire._n_type_up tu on up.type_structure = tu.id_gabriel
  left join annuaire._n_contrat co on co.id_gabriel = up.contrat
  left join annuaire._n_type_pension ntp on ntp.id_gabriel = up.demi_pension
  left join annuaire._a_up_jour auj on auj.up_id = up.id_gabriel
  left join annuaire._n_jour_ouverture njo on njo.id_gabriel = auj.jour_ouverture_id
WHERE
  up.statut != 'f'
  AND up.code_rne = ?
limit
  1
offset
  0

select DISTINCT up.numec as numec_up, tu.id_gabriel as type_up_id, up.code_rne, up.id_gabriel, up.nom_courant, up.etablissement, adresse_cap.locality as ville , CONCAT_WS(' ',adresse_cap.street_number,adresse_cap.street_number_ext,adresse_cap.street_name) as adresse1, ac.telephone1,adresse_cap.postal_code as cp, ac.mail1, ac.fax1, ac.site_web,
dep_up.id_gabriel as departement, tu.libelle_long as type_up,up.latitude,up.longitude, e.nom_courant as etb_nom, co.libelle_long as contrat, st.nom_usage as academie, st.id_gabriel as academie_id, s.nom_usage as diocese, s.id_gabriel as diocese_id, de.libelle_long as degre, up.statut, up.projet,
inte.libelle_long as internat, up.internat_desc, up.etude, up.etude_desc, up.horaire_ouverture, up.horaire_fermeture, mi.libelle_long as ministere_tutelle, up.ecole_circonscription, ntu.libelle_long as type_tutelle,
up.accueil_peri_scolaire_matin, accueil_peri_scolaire_soir, aff.libelle_long as affiliation, up.photo, up.nb_filles, up.nb_garcons, up.effectifs_total, up.effectifs_total_items, up.effectif_hors_contrat, civ.libelle_long as civilite, i.prenom_usuel
as prenom, i.nom as nom, struct.nom_usage as ogec, up.ogec as id_ogec, torg.libelle_long as organisme, up.transport, up.demi_pension, ntp.libelle_long as lib_pension, up.internat as internat_code, njo.libelle_long jours,
			CASE
				WHEN up.latitude = 0 THEN NULL
				WHEN up.latitude = 99 THEN NULL
				WHEN up.latitude IS NULL THEN NULL
				ELSE CONCAT(up.latitude ,',',up.longitude)
			END AS coord,
			(SELECT DISTINCT array_agg(nl.libelle_langue)
				FROM annuaire._n_langues as nl
				INNER JOIN annuaire._a_langue_up as alu2 ON alu2.langue_id = nl.id_gabriel
				WHERE alu2.up_id = up.id_gabriel)
			as langues,
			(SELECT DISTINCT array_agg(nd.libelle_dispositif)
				FROM annuaire._n_dispositif as nd
				INNER JOIN annuaire._a_dispositif_up as adu2 ON adu2.dispositif_id = nd.id_gabriel
				WHERE adu2.up_id = up.id_gabriel)
			as dispositifs,
			(SELECT DISTINCT array_agg(';' || alu3.langue_id || ';')
				FROM annuaire._a_langue_up as alu3
				WHERE alu3.up_id = up.id_gabriel)
			as langues_id,
			(SELECT array_agg(concat(source || ' - ' || formation))
				FROM annuaire._n_formations AS nf
				INNER JOIN annuaire._a_formation_up AS afu2 ON afu2.formation_id = nf.id_gabriel
				WHERE afu2.up_id = up.id_gabriel)
			as formations,
            case when (
				SELECT 	po.id_gabriel
				FROM annuaire.portes_ouvertes po
				INNER JOIN annuaire._a_formations_portes_ouvertes afpo on afpo.id_portes_ouvertes = po.id_gabriel
				INNER JOIN annuaire._n_formations_portes_ouvertes nfpo on nfpo.id_gabriel = afpo.id_formations
				WHERE po.id_up = up.id_gabriel and po.date_debut between CURRENT_DATE - interval '1 month' and CURRENT_DATE + interval '1 year'
				limit 1
			) is null then 0 else 1 end as portes_ouvertes,
			(SELECT array_agg(filiere)
				FROM annuaire._n_option_matiere nom
				INNER JOIN annuaire._a_specificite_up AS asu2 ON asu2.specificite_id = nom.id_gabriel
				WHERE asu2.up_id = up.id_gabriel)
			as specificites, r.libelle_edition AS region, up.type_structure, up.validation_items_id
        
			from annuaire.up
			
			inner join annuaire.etablissement e on e.id_gabriel = up.etablissement
			inner join annuaire.adresse_communication ac on ac.id_gabriel = up.adresse
			LEFT JOIN annuaire.adresse_cap adresse_cap ON adresse_cap.numec = up.numec AND adresse_cap.doublon IS NULL
			LEFT JOIN annuaire._n_departement dep_up ON dep_up.code_departement = adresse_cap.code_departement
			left join annuaire._n_region r on dep_up.code_region_interne = r.id_gabriel
			left join annuaire._n_type_organisme torg on torg.id_gabriel = e.type_organisme
			left join annuaire.structure struct on struct.id_gabriel = up.ogec
			left join annuaire.individu i ON i.id_gabriel = up.cetb_id
			left join annuaire._n_civilite civ on civ.id_gabriel = i.civilite
			left join annuaire._n_affiliation aff on aff.id_gabriel = up.affiliation
			left join annuaire._n_nat_tutelle ntu on ntu.id_gabriel = up.type_tutelle
			left join annuaire._n_ministere mi on mi.id_gabriel = up.ministere_tutelle
			left join annuaire._n_internat inte on inte.id_gabriel = up.internat
			left join annuaire._n_degre de on de.id_gabriel = up.degre
			left join annuaire.structure s on s.id_gabriel = up.diocese
			left join annuaire.structure st on st.id_gabriel = dep_up.code_academie_interne
			left join annuaire._n_type_up tu on up.type_structure = tu.id_gabriel
			left join annuaire._n_contrat co on co.id_gabriel = up.contrat
			left join annuaire._n_type_pension ntp on ntp.id_gabriel = up.demi_pension
			left join annuaire._a_up_jour auj on auj.up_id = up.id_gabriel
			left join annuaire._n_jour_ouverture njo on njo.id_gabriel=auj.jour_ouverture_id
			WHERE up.statut != 'f'  AND up.code_rne = '0280815J'
			
            limit 1 offset 0
        ;

SELECT
  t0_.id_gabriel AS id_gabriel_0,
  t0_.id_gabriel_exploit AS id_gabriel_exploit_1,
  t0_.id_ange AS id_ange_2,
  t0_.id_ecol AS id_ecol_3,
  t0_.id_men AS id_men_4,
  t0_.formation AS formation_5,
  t0_.niveau AS niveau_6,
  t0_.type AS type_7,
  t0_.famille AS famille_8,
  t0_.source AS source_9,
  t0_.date_ouverture AS date_ouverture_10,
  t0_.date_fermeture AS date_fermeture_11,
  t0_.date_creation AS date_creation_12,
  t0_.date_intervention AS date_intervention_13,
  t0_.commentaires AS commentaires_14
FROM
  annuaire._n_formations t0_
  INNER JOIN annuaire._a_formation_up t1_ ON t0_.id_gabriel = t1_.formation_id
WHERE
  (
    t0_.date_fermeture > ?
    OR t0_.date_fermeture IS NULL
  )
  AND t1_.up_id = ?
ORDER BY
  t0_.id_gabriel ASC

SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecol AS id_ecol_3, t0_.id_men AS id_men_4, t0_.formation AS formation_5, t0_.niveau AS niveau_6, t0_.type AS type_7, t0_.famille AS famille_8, t0_.source AS source_9, t0_.date_ouverture AS date_ouverture_10, t0_.date_fermeture AS date_fermeture_11, t0_.date_creation AS date_creation_12, t0_.date_intervention AS date_intervention_13, t0_.commentaires AS commentaires_14 FROM annuaire._n_formations t0_ INNER JOIN annuaire._a_formation_up t1_ ON t0_.id_gabriel = t1_.formation_id WHERE (t0_.date_fermeture > '2025-09-29 00:14:34' OR t0_.date_fermeture IS NULL) AND t1_.up_id = 5089 ORDER BY t0_.id_gabriel ASC;

SELECT
  t0_.id_gabriel AS id_gabriel_0,
  t0_.id_gabriel_exploit AS id_gabriel_exploit_1,
  t0_.id_ange AS id_ange_2,
  t0_.id_ecole AS id_ecole_3,
  t0_.id_men AS id_men_4,
  t0_.libelle_langue AS libelle_langue_5,
  t0_.niveau AS niveau_6,
  t0_.date_ouverture AS date_ouverture_7,
  t0_.date_fermeture AS date_fermeture_8,
  t0_.date_creation AS date_creation_9,
  t0_.date_intervention AS date_intervention_10,
  t0_.commentaires AS commentaires_11
FROM
  annuaire._n_langues t0_
  INNER JOIN annuaire._a_langue_up t1_ ON t0_.id_gabriel = t1_.langue_id
WHERE
  (
    t0_.date_fermeture > ?
    OR t0_.date_fermeture IS NULL
  )
  AND t1_.up_id = ?
ORDER BY
  t0_.id_gabriel ASC

SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.libelle_langue AS libelle_langue_5, t0_.niveau AS niveau_6, t0_.date_ouverture AS date_ouverture_7, t0_.date_fermeture AS date_fermeture_8, t0_.date_creation AS date_creation_9, t0_.date_intervention AS date_intervention_10, t0_.commentaires AS commentaires_11 FROM annuaire._n_langues t0_ INNER JOIN annuaire._a_langue_up t1_ ON t0_.id_gabriel = t1_.langue_id WHERE (t0_.date_fermeture > '2025-09-29 00:14:34' OR t0_.date_fermeture IS NULL) AND t1_.up_id = 5089 ORDER BY t0_.id_gabriel ASC;

SELECT
  t0_.id_gabriel AS id_gabriel_0,
  t0_.id_gabriel_exploit AS id_gabriel_exploit_1,
  t0_.id_ange AS id_ange_2,
  t0_.id_ecole AS id_ecole_3,
  t0_.id_men AS id_men_4,
  t0_.filiere AS filiere_5,
  t0_.type AS type_6,
  t0_.famille AS famille_7,
  t0_.date_ouverture AS date_ouverture_8,
  t0_.date_fermeture AS date_fermeture_9,
  t0_.date_creation AS date_creation_10,
  t0_.date_intervention AS date_intervention_11,
  t0_.commentaires AS commentaires_12
FROM
  annuaire._n_option_matiere t0_
  INNER JOIN annuaire._a_specificite_up t1_ ON t0_.id_gabriel = t1_.specificite_id
WHERE
  (
    t0_.date_fermeture > ?
    OR t0_.date_fermeture IS NULL
  )
  AND t1_.up_id = ?
ORDER BY
  t0_.id_gabriel ASC

SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.filiere AS filiere_5, t0_.type AS type_6, t0_.famille AS famille_7, t0_.date_ouverture AS date_ouverture_8, t0_.date_fermeture AS date_fermeture_9, t0_.date_creation AS date_creation_10, t0_.date_intervention AS date_intervention_11, t0_.commentaires AS commentaires_12 FROM annuaire._n_option_matiere t0_ INNER JOIN annuaire._a_specificite_up t1_ ON t0_.id_gabriel = t1_.specificite_id WHERE (t0_.date_fermeture > '2025-09-29 00:14:34' OR t0_.date_fermeture IS NULL) AND t1_.up_id = 5089 ORDER BY t0_.id_gabriel ASC;