Symfony Profiler

Query Metrics

19 Database Queries

12 Different statements

121.52 ms Query time

0 Invalid entities

Queries

default connection


SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN (?) ORDER BY s0_.nom_usage ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN (?) ORDER BY s0_.nom_usage ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0
SELECT COUNT(DISTINCT up.id_gabriel) 
			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 s.id_gabriel = ? 
			
            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 s.id_gabriel = ? 
			
            limit 10 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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition 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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 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_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_ LIMIT 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_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.libelle_dispositif AS libelle_dispositif_5, t0_.date_ouverture AS date_ouverture_6, t0_.date_fermeture AS date_fermeture_7, t0_.date_creation AS date_creation_8, t0_.date_intervention AS date_intervention_9 FROM annuaire._n_dispositif t0_ INNER JOIN annuaire._a_dispositif_up t1_ ON t0_.id_gabriel = t1_.dispositif_id
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_ LIMIT 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_ LIMIT 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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition 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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC
SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC

#▲	Time	Info
1	2.62 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN (?) ORDER BY s0_.nom_usage ASC Parameters: [`"2026-01-02 17:24:32" "119"`] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE ( s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL ) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN (?) ORDER BY s0_.nom_usage ASC SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > '2026-01-02 17:24:32' OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN ('119') ORDER BY s0_.nom_usage ASC;
2	0.56 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0 Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0 SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0;
3	0.87 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN (?) ORDER BY s0_.nom_usage ASC Parameters: [`"2026-01-02 17:24:32" "119"`] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE ( s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL ) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN (?) ORDER BY s0_.nom_usage ASC SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > '2026-01-02 17:24:32' OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' AND s0_.id_gabriel IN ('119') ORDER BY s0_.nom_usage ASC;
4	0.48 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0 Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0 SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0;
5	26.84 ms	SELECT COUNT(DISTINCT up.id_gabriel) 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 s.id_gabriel = ? limit 1 offset 0 Parameters: [`119`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT up.id_gabriel) 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 s.id_gabriel = ? limit 1 offset 0 SELECT COUNT(DISTINCT up.id_gabriel) 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 s.id_gabriel = 119 limit 1 offset 0 ;
6	77.97 ms	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 s.id_gabriel = ? limit 10 offset 0 Parameters: [`119`] View formatted query View runnable query Explain query 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 s.id_gabriel = ? limit 10 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 s.id_gabriel = 119 limit 10 offset 0 ;
7	0.85 ms	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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query 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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition 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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > '2026-01-02 17:24:32' OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition ASC;
8	0.86 ms	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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query 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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE ( t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition 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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > '2026-01-02 17:24:32' OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC;
9	1.17 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE ( s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL ) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > '2026-01-02 17:24:32' OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC;
10	2.30 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE ( s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL ) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > '2026-01-02 17:24:32' OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC;
11	0.52 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0 Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0 SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ LIMIT 0;
12	0.54 ms	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_ LIMIT 0 Parameters: [] View formatted query View runnable query Explain query 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_ LIMIT 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_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_ LIMIT 0;
13	1.27 ms	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_dispositif AS libelle_dispositif_5, t0_.date_ouverture AS date_ouverture_6, t0_.date_fermeture AS date_fermeture_7, t0_.date_creation AS date_creation_8, t0_.date_intervention AS date_intervention_9 FROM annuaire._n_dispositif t0_ INNER JOIN annuaire._a_dispositif_up t1_ ON t0_.id_gabriel = t1_.dispositif_id Parameters: [] View formatted query View runnable query Explain query 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_dispositif AS libelle_dispositif_5, t0_.date_ouverture AS date_ouverture_6, t0_.date_fermeture AS date_fermeture_7, t0_.date_creation AS date_creation_8, t0_.date_intervention AS date_intervention_9 FROM annuaire._n_dispositif t0_ INNER JOIN annuaire._a_dispositif_up t1_ ON t0_.id_gabriel = t1_.dispositif_id 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_dispositif AS libelle_dispositif_5, t0_.date_ouverture AS date_ouverture_6, t0_.date_fermeture AS date_fermeture_7, t0_.date_creation AS date_creation_8, t0_.date_intervention AS date_intervention_9 FROM annuaire._n_dispositif t0_ INNER JOIN annuaire._a_dispositif_up t1_ ON t0_.id_gabriel = t1_.dispositif_id;
14	0.45 ms	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_ LIMIT 0 Parameters: [] View formatted query View runnable query Explain query 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_ LIMIT 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_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_ LIMIT 0;
15	0.42 ms	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_ LIMIT 0 Parameters: [] View formatted query View runnable query Explain query 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_ LIMIT 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_ LIMIT 0;
16	0.65 ms	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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query 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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition 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_.code_departement_interne AS code_departement_interne_3, t0_.code_academie_interne AS code_academie_interne_4, t0_.arpec_code_arpec AS arpec_code_arpec_5, t0_.code_departement AS code_departement_6, t0_.libelle_court AS libelle_court_7, t0_.libelle_long AS libelle_long_8, t0_.libelle_edition AS libelle_edition_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, t0_.statut AS statut_15, t0_.code_region_interne AS code_region_interne_16 FROM annuaire._n_departement t0_ WHERE t0_.date_fermeture > '2026-01-02 17:24:32' OR t0_.date_fermeture IS NULL ORDER BY t0_.libelle_edition ASC;
17	0.50 ms	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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query 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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE ( t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL ) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition 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_indices AS id_indices_4, t0_.id_men AS id_men_5, t0_.libelle_court AS libelle_court_6, t0_.libelle_long AS libelle_long_7, t0_.libelle_edition AS libelle_edition_8, t0_.date_ouverture AS date_ouverture_9, t0_.date_fermeture AS date_fermeture_10, t0_.date_creation AS date_creation_11, t0_.date_intervention AS date_intervention_12, t0_.commentaires AS commentaires_13, t0_.statut AS statut_14 FROM annuaire._n_region t0_ WHERE (t0_.date_fermeture > '2026-01-02 17:24:32' OR t0_.date_fermeture IS NULL) AND t0_.id_gabriel <> 98 ORDER BY t0_.libelle_edition ASC;
18	0.74 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE ( s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL ) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > '2026-01-02 17:24:32' OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 4 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC;
19	1.91 ms	SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC Parameters: [`"2026-01-02 17:24:32"`] View formatted query View runnable query Explain query SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE ( s0_.date_fermeture > ? OR s0_.date_fermeture IS NULL ) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC SELECT s0_.id_gabriel AS id_gabriel_0, s0_.id_gabriel_exploit AS id_gabriel_exploit_1, s0_.nom_usage AS nom_usage_2, s0_.nom_organisme AS nom_organisme_3, s0_.consentement AS consentement_4, s0_.id_ange AS id_ange_5, s0_.id_ecol AS id_ecol_6, s0_.appli_source AS appli_source_7, s0_.code AS code_8, s0_.lattitude AS lattitude_9, s0_.longitude AS longitude_10, s0_.date_ouverture AS date_ouverture_11, s0_.date_fermeture AS date_fermeture_12, s0_.date_creation AS date_creation_13, s0_.date_intervention AS date_intervention_14, s0_.commentaires AS commentaires_15, s0_.numec AS numec_16, s0_.num_entree_id AS num_entree_id_17, s0_.projet AS projet_18, s0_.photo AS photo_19, s0_.statut AS statut_20, s0_.siret AS siret_21, s0_.have_photo AS have_photo_22, s0_.type_organisme AS type_organisme_23, s0_.adresse AS adresse_24, s0_.struct_rattach_princ AS struct_rattach_princ_25, s0_.struct_rattach_second AS struct_rattach_second_26, s0_.cetb_id AS cetb_id_27 FROM annuaire.structure s0_ WHERE (s0_.date_fermeture > '2026-01-02 17:24:32' OR s0_.date_fermeture IS NULL) AND s0_.type_organisme = 5 AND s0_.statut = 't' ORDER BY s0_.nom_usage ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
ange1d	doctrine.dbal.ange1d_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
ange1d	doctrine.orm.ange1d_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\NDepartement	No errors.
App\Entity\NRegion	No errors.
App\Entity\Structure	No errors.
App\Entity\NTypeOrganisme	No errors.
App\Entity\AdresseCommunication	No errors.
App\Entity\Individu	No errors.
App\Entity\NLangues	No errors.
App\Entity\NDispositif	No errors.
App\Entity\ADispositifUp	No errors.
App\Entity\NOptionMatiere	No errors.
App\Entity\NFormations	No errors.
App\Entity\AIndividuUp	No errors.
App\Entity\AIndividuUpFonction	No errors.
App\Entity\WsUser	No errors.
App\Entity\Etablissement	No errors.

ange1d entity manager

No loaded entities.

Symfony Profiler

GET https://gs.gabriel.netstim.net/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CFragmentController%253A%253Aheader

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

ange1d entity manager