GET https://gs.gabriel.netstim.net/etablissement/resultats?recherche_etablissement_desktop%5Bogec%5D=7302

Response
200 OK
IP
216.73.216.120
Profiled on
Token
f30ad2

Query Metrics

17 Database Queries
11 Different statements
74.06 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
47.89 ms
(64.67%) 		1 
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.ogec = ? 
			
            limit 10 offset 0
Parameters: 
[
  7302
]
View formatted query    View runnable query    Explain query
13.26 ms
(17.90%) 		1 
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 up.ogec = ? 
			
            limit 1 offset 0
Parameters: 
[
  7302
]
View formatted query    View runnable query    Explain query
2.88 ms
(3.89%) 		3 
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_.id_gabriel = ? LIMIT 1
Parameters: 
[
  "7302"
]
View formatted query    View runnable query    Explain query
2.80 ms
(3.79%) 		2 
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
1.95 ms
(2.63%) 		2 
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
1.60 ms
(2.16%) 		2 
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
1.27 ms
(1.71%) 		2 
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
1.22 ms
(1.65%) 		1 
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
0.41 ms
(0.56%) 		1 
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
0.40 ms
(0.53%) 		1 
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
0.38 ms
(0.51%) 		1 
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

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.
App\Entity\StructureOgec No errors.
App\Entity\Up No errors.
App\Entity\AEleveInfosSupp No errors.
App\Entity\AEleveMatiere No errors.
App\Entity\AEleveRespLegal No errors.
App\Entity\AEnseignantDisciplPoste No errors.
App\Entity\AEnseignantMatiere No errors.
App\Entity\AIndividuIrc No errors.
App\Entity\RespLegal No errors.
App\Entity\NCivilite No errors.
App\Entity\NNationalite No errors.
App\Entity\NPays No errors.
App\Entity\ALangueUp No errors.
App\Entity\ASpecificiteUp No errors.
App\Entity\AFormationUp No errors.
App\Entity\NMotifDepart No errors.
App\Entity\NQualiteJuridiq No errors.
App\Entity\NAppliSource
  • The association App\Entity\NAppliSource#aFormationsPortesOuvertes refers to the owning side field App\Entity\AFormationsPortesOuvertes#appliSource which does not exist.
App\Entity\NFonction No errors.
App\Entity\AMethodAllowed No errors.
App\Entity\NNatTutelle No errors.

ange1d entity manager

No loaded entities.