Symfony Profiler

SELECT
  row_number() OVER () as id_unique,
  c.nb_obs,
  c.anciennete,
  ST_AsGeoJSON(
    ST_Transform(c.the_geom, 3857 :: int),
    0,
    0
  ) as geojson
FROM
  ipn_requeteur_v3.carte_maille10_par_espece c
WHERE
  cd_ref = 1040529;

SELECT
				row_number() OVER () as id_unique,
				c.nb_obs,
				c.anciennete,
				ST_AsGeoJSON(ST_Transform(c.the_geom,3857::int),0,0) as geojson
			FROM ipn_requeteur_v3.carte_maille10_par_espece c
			WHERE cd_ref = 1040529;
		;

SELECT
  e0_.cd_espece AS cd_espece_0,
  e0_.annee AS annee_1,
  e0_.nb_obs AS nb_obs_2,
  e0_.nb_obs_occ AS nb_obs_occ_3,
  e0_.nb_obs_synth AS nb_obs_synth_4
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_
WHERE
  e0_.cd_espece = 1040529
ORDER BY
  e0_.annee ASC

SELECT e0_.cd_espece AS cd_espece_0, e0_.annee AS annee_1, e0_.nb_obs AS nb_obs_2, e0_.nb_obs_occ AS nb_obs_occ_3, e0_.nb_obs_synth AS nb_obs_synth_4 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_ WHERE e0_.cd_espece = 1040529 ORDER BY e0_.annee ASC;

SELECT
  e0_.cd_espece AS cd_espece_0,
  e0_.nb_obs_presence AS nb_obs_presence_1,
  e0_.nb_communes_presence AS nb_communes_presence_2,
  e0_.nb_communes_total AS nb_communes_total_3,
  e0_.nb_maille5_presence AS nb_maille5_presence_4,
  e0_.nb_jdd_presence AS nb_jdd_presence_5,
  d1_.code_dept AS code_dept_6,
  d1_.nom_dept AS nom_dept_7,
  e0_.departement AS departement_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_departements e0_
  INNER JOIN ipn_carto.departement d1_ ON e0_.departement = d1_.code_dept
WHERE
  e0_.cd_espece = 1040529

SELECT e0_.cd_espece AS cd_espece_0, e0_.nb_obs_presence AS nb_obs_presence_1, e0_.nb_communes_presence AS nb_communes_presence_2, e0_.nb_communes_total AS nb_communes_total_3, e0_.nb_maille5_presence AS nb_maille5_presence_4, e0_.nb_jdd_presence AS nb_jdd_presence_5, d1_.code_dept AS code_dept_6, d1_.nom_dept AS nom_dept_7, e0_.departement AS departement_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_departements e0_ INNER JOIN ipn_carto.departement d1_ ON e0_.departement = d1_.code_dept WHERE e0_.cd_espece = 1040529;

SELECT
  e0_.cd_espece AS cd_espece_0,
  e0_.mois AS mois_1,
  e0_.nb_obs AS nb_obs_2
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_
WHERE
  e0_.cd_espece = 1040529

SELECT e0_.cd_espece AS cd_espece_0, e0_.mois AS mois_1, e0_.nb_obs AS nb_obs_2 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_ WHERE e0_.cd_espece = 1040529;

SELECT
  t0.cd_espece AS cd_espece_1,
  t0.nb_obs_presence AS nb_obs_presence_2,
  t0.nb_communes_presence AS nb_communes_presence_3,
  t0.nb_maille5_presence AS nb_maille5_presence_4,
  t0.nb_maille10_presence AS nb_maille10_presence_5,
  t0.nb_maille10_pour_calcul_idr AS nb_maille10_pour_calcul_idr_6,
  t0.nb_jdd_presence AS nb_jdd_presence_7
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece t0
WHERE
  t0.cd_espece = ?

SELECT t0.cd_espece AS cd_espece_1, t0.nb_obs_presence AS nb_obs_presence_2, t0.nb_communes_presence AS nb_communes_presence_3, t0.nb_maille5_presence AS nb_maille5_presence_4, t0.nb_maille10_presence AS nb_maille10_presence_5, t0.nb_maille10_pour_calcul_idr AS nb_maille10_pour_calcul_idr_6, t0.nb_jdd_presence AS nb_jdd_presence_7 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece t0 WHERE t0.cd_espece = 1040529;

SELECT
  v0_.cd_nom AS cd_nom_0,
  v0_.cd_ref AS cd_ref_1,
  v0_.lb_nom AS lb_nom_2,
  v0_.lb_auteur AS lb_auteur_3,
  v0_.nom_vern AS nom_vern_4,
  v0_.premier_nom_vern AS premier_nom_vern_5,
  v0_.nom_valide AS nom_valide_6,
  v0_.rang AS rang_7,
  v0_.embranchement AS embranchement_8,
  v0_.classe AS classe_9,
  v0_.ordre AS ordre_10,
  v0_.famille AS famille_11,
  v0_.version AS version_12,
  v0_.presence_metropole AS presence_metropole_13,
  v0_.icone AS icone_14,
  v0_.cd_espece AS cd_espece_15,
  v0_.taxons_superieurs AS taxons_superieurs_16,
  v0_.groupes_usuels AS groupes_usuels_17,
  v0_.groupes_fonctionnels AS groupes_fonctionnels_18,
  t1_.cd_ref AS cd_ref_19,
  t1_.date_creation AS date_creation_20,
  t1_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_21,
  t1_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_22,
  t1_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_23,
  t1_.source_indice_distribution_regionale AS source_indice_distribution_regionale_24,
  t1_.pra AS pra_25,
  t2_.cd_ref AS cd_ref_26,
  t2_.liste_eee_france AS liste_eee_france_27,
  t2_.annexe_eee_france AS annexe_eee_france_28,
  t2_.liste_eee_ue AS liste_eee_ue_29,
  t2_.liste_eee_top100_mondial AS liste_eee_top100_mondial_30,
  t2_.mesures_gestion AS mesures_gestion_31,
  v3_.cd_ref AS cd_ref_32,
  v3_.text AS text_33,
  v3_.departements AS departements_34,
  v3_.ref_objet_denombrement AS ref_objet_denombrement_35,
  v3_.ref_stade_de_vie AS ref_stade_de_vie_36,
  v3_.ref_statut_biologique AS ref_statut_biologique_37,
  v3_.ref_processus_observation AS ref_processus_observation_38,
  v3_.ref_comportement AS ref_comportement_39,
  v3_.ref_nidification AS ref_nidification_40,
  v0_.cd_nom AS cd_nom_41,
  v0_.cd_nom AS cd_nom_42,
  v0_.cd_ref AS cd_ref_43,
  v0_.rang AS rang_44,
  v0_.habitat AS habitat_45,
  v0_.cd_nom AS cd_nom_46,
  v0_.cd_nom AS cd_nom_47,
  v0_.cd_nom AS cd_nom_48,
  v0_.cd_nom AS cd_nom_49,
  t1_.id_numerisateur AS id_numerisateur_50,
  t1_.statut_presence_regionale AS statut_presence_regionale_51,
  t1_.statut_indigenat_regional AS statut_indigenat_regional_52,
  t1_.statut_endemisme AS statut_endemisme_53,
  t1_.statut_rarete AS statut_rarete_54,
  t1_.enjeu AS enjeu_55,
  t1_.cd_ref AS cd_ref_56,
  t2_.reproduction AS reproduction_57,
  t2_.tendance AS tendance_58,
  t2_.type_introduction AS type_introduction_59,
  v3_.niveau_sensibilite_defaut AS niveau_sensibilite_defaut_60,
  v3_.niveau_sensibilite_criteres AS niveau_sensibilite_criteres_61
FROM
  ipn_taxonomie.vm_taxref_last v0_
  INNER JOIN ipn_requeteur_v3.referentiel_espece r4_ ON v0_.cd_nom = r4_.cd_ref
  LEFT JOIN ipn_referentiel_taxo_v2.taxons t1_ ON v0_.cd_nom = t1_.cd_ref
  LEFT JOIN ipn_referentiel_taxo_v2.taxons_exotiques t2_ ON t1_.cd_ref = t2_.cd_ref
  LEFT JOIN ipn_sensibilite.vm_taxons_sensibles_complet_avec_descendants v3_ ON v0_.cd_nom = v3_.cd_ref
WHERE
  v0_.cd_nom = 1040529

SELECT v0_.cd_nom AS cd_nom_0, v0_.cd_ref AS cd_ref_1, v0_.lb_nom AS lb_nom_2, v0_.lb_auteur AS lb_auteur_3, v0_.nom_vern AS nom_vern_4, v0_.premier_nom_vern AS premier_nom_vern_5, v0_.nom_valide AS nom_valide_6, v0_.rang AS rang_7, v0_.embranchement AS embranchement_8, v0_.classe AS classe_9, v0_.ordre AS ordre_10, v0_.famille AS famille_11, v0_.version AS version_12, v0_.presence_metropole AS presence_metropole_13, v0_.icone AS icone_14, v0_.cd_espece AS cd_espece_15, v0_.taxons_superieurs AS taxons_superieurs_16, v0_.groupes_usuels AS groupes_usuels_17, v0_.groupes_fonctionnels AS groupes_fonctionnels_18, t1_.cd_ref AS cd_ref_19, t1_.date_creation AS date_creation_20, t1_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_21, t1_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_22, t1_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_23, t1_.source_indice_distribution_regionale AS source_indice_distribution_regionale_24, t1_.pra AS pra_25, t2_.cd_ref AS cd_ref_26, t2_.liste_eee_france AS liste_eee_france_27, t2_.annexe_eee_france AS annexe_eee_france_28, t2_.liste_eee_ue AS liste_eee_ue_29, t2_.liste_eee_top100_mondial AS liste_eee_top100_mondial_30, t2_.mesures_gestion AS mesures_gestion_31, v3_.cd_ref AS cd_ref_32, v3_.text AS text_33, v3_.departements AS departements_34, v3_.ref_objet_denombrement AS ref_objet_denombrement_35, v3_.ref_stade_de_vie AS ref_stade_de_vie_36, v3_.ref_statut_biologique AS ref_statut_biologique_37, v3_.ref_processus_observation AS ref_processus_observation_38, v3_.ref_comportement AS ref_comportement_39, v3_.ref_nidification AS ref_nidification_40, v0_.cd_nom AS cd_nom_41, v0_.cd_nom AS cd_nom_42, v0_.cd_ref AS cd_ref_43, v0_.rang AS rang_44, v0_.habitat AS habitat_45, v0_.cd_nom AS cd_nom_46, v0_.cd_nom AS cd_nom_47, v0_.cd_nom AS cd_nom_48, v0_.cd_nom AS cd_nom_49, t1_.id_numerisateur AS id_numerisateur_50, t1_.statut_presence_regionale AS statut_presence_regionale_51, t1_.statut_indigenat_regional AS statut_indigenat_regional_52, t1_.statut_endemisme AS statut_endemisme_53, t1_.statut_rarete AS statut_rarete_54, t1_.enjeu AS enjeu_55, t1_.cd_ref AS cd_ref_56, t2_.reproduction AS reproduction_57, t2_.tendance AS tendance_58, t2_.type_introduction AS type_introduction_59, v3_.niveau_sensibilite_defaut AS niveau_sensibilite_defaut_60, v3_.niveau_sensibilite_criteres AS niveau_sensibilite_criteres_61 FROM ipn_taxonomie.vm_taxref_last v0_ INNER JOIN ipn_requeteur_v3.referentiel_espece r4_ ON v0_.cd_nom = r4_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.taxons t1_ ON v0_.cd_nom = t1_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.taxons_exotiques t2_ ON t1_.cd_ref = t2_.cd_ref LEFT JOIN ipn_sensibilite.vm_taxons_sensibles_complet_avec_descendants v3_ ON v0_.cd_nom = v3_.cd_ref WHERE v0_.cd_nom = 1040529;

SELECT
  t0.cd_nom AS cd_nom_1,
  t0.cd_ref AS cd_ref_2,
  t0.lb_nom AS lb_nom_3,
  t0.lb_auteur AS lb_auteur_4,
  t0.nom_vern AS nom_vern_5,
  t0.premier_nom_vern AS premier_nom_vern_6,
  t0.nom_valide AS nom_valide_7,
  t0.rang AS rang_8,
  t0.embranchement AS embranchement_9,
  t0.classe AS classe_10,
  t0.ordre AS ordre_11,
  t0.famille AS famille_12,
  t0.version AS version_13,
  t0.presence_metropole AS presence_metropole_14,
  t0.icone AS icone_15,
  t0.cd_espece AS cd_espece_16,
  t0.taxons_superieurs AS taxons_superieurs_17,
  t0.groupes_usuels AS groupes_usuels_18,
  t0.groupes_fonctionnels AS groupes_fonctionnels_19,
  t0.cd_nom AS cd_nom_20,
  t0.cd_nom AS cd_nom_21,
  t0.cd_ref AS cd_ref_22,
  t0.rang AS rang_23,
  t0.habitat AS habitat_24,
  t0.cd_nom AS cd_nom_25,
  t0.cd_nom AS cd_nom_26,
  t0.cd_nom AS cd_nom_27,
  t0.cd_nom AS cd_nom_28
FROM
  ipn_taxonomie.vm_taxref_last t0
WHERE
  t0.cd_nom = ?

SELECT t0.cd_nom AS cd_nom_1, t0.cd_ref AS cd_ref_2, t0.lb_nom AS lb_nom_3, t0.lb_auteur AS lb_auteur_4, t0.nom_vern AS nom_vern_5, t0.premier_nom_vern AS premier_nom_vern_6, t0.nom_valide AS nom_valide_7, t0.rang AS rang_8, t0.embranchement AS embranchement_9, t0.classe AS classe_10, t0.ordre AS ordre_11, t0.famille AS famille_12, t0.version AS version_13, t0.presence_metropole AS presence_metropole_14, t0.icone AS icone_15, t0.cd_espece AS cd_espece_16, t0.taxons_superieurs AS taxons_superieurs_17, t0.groupes_usuels AS groupes_usuels_18, t0.groupes_fonctionnels AS groupes_fonctionnels_19, t0.cd_nom AS cd_nom_20, t0.cd_nom AS cd_nom_21, t0.cd_ref AS cd_ref_22, t0.rang AS rang_23, t0.habitat AS habitat_24, t0.cd_nom AS cd_nom_25, t0.cd_nom AS cd_nom_26, t0.cd_nom AS cd_nom_27, t0.cd_nom AS cd_nom_28 FROM ipn_taxonomie.vm_taxref_last t0 WHERE t0.cd_nom = '1040529';

SELECT
  t0.id AS id_1,
  t0.libelle_court AS libelle_court_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.echelle AS echelle_5,
  t0.couleur AS couleur_6,
  t0.couleur_texte AS couleur_texte_7
FROM
  ipn_referentiel_taxo_v2.ref_statut_presence t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle_court AS libelle_court_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.echelle AS echelle_5, t0.couleur AS couleur_6, t0.couleur_texte AS couleur_texte_7 FROM ipn_referentiel_taxo_v2.ref_statut_presence t0 WHERE t0.id = 10;

SELECT
  t0.cd_nom AS cd_nom_1,
  t0.cd_ref AS cd_ref_2,
  t0.lb_nom AS lb_nom_3,
  t0.lb_auteur AS lb_auteur_4,
  t0.nom_vern AS nom_vern_5,
  t0.premier_nom_vern AS premier_nom_vern_6,
  t0.nom_valide AS nom_valide_7,
  t0.rang AS rang_8,
  t0.embranchement AS embranchement_9,
  t0.classe AS classe_10,
  t0.ordre AS ordre_11,
  t0.famille AS famille_12,
  t0.version AS version_13,
  t0.presence_metropole AS presence_metropole_14,
  t0.icone AS icone_15,
  t0.cd_espece AS cd_espece_16,
  t0.taxons_superieurs AS taxons_superieurs_17,
  t0.groupes_usuels AS groupes_usuels_18,
  t0.groupes_fonctionnels AS groupes_fonctionnels_19,
  t0.cd_nom AS cd_nom_20,
  t0.cd_nom AS cd_nom_21,
  t0.cd_ref AS cd_ref_22,
  t0.rang AS rang_23,
  t0.habitat AS habitat_24,
  t0.cd_nom AS cd_nom_25,
  t0.cd_nom AS cd_nom_26,
  t0.cd_nom AS cd_nom_27,
  t0.cd_nom AS cd_nom_28
FROM
  ipn_taxonomie.vm_taxref_last t0
WHERE
  t0.cd_nom = ?
LIMIT
  1

SELECT t0.cd_nom AS cd_nom_1, t0.cd_ref AS cd_ref_2, t0.lb_nom AS lb_nom_3, t0.lb_auteur AS lb_auteur_4, t0.nom_vern AS nom_vern_5, t0.premier_nom_vern AS premier_nom_vern_6, t0.nom_valide AS nom_valide_7, t0.rang AS rang_8, t0.embranchement AS embranchement_9, t0.classe AS classe_10, t0.ordre AS ordre_11, t0.famille AS famille_12, t0.version AS version_13, t0.presence_metropole AS presence_metropole_14, t0.icone AS icone_15, t0.cd_espece AS cd_espece_16, t0.taxons_superieurs AS taxons_superieurs_17, t0.groupes_usuels AS groupes_usuels_18, t0.groupes_fonctionnels AS groupes_fonctionnels_19, t0.cd_nom AS cd_nom_20, t0.cd_nom AS cd_nom_21, t0.cd_ref AS cd_ref_22, t0.rang AS rang_23, t0.habitat AS habitat_24, t0.cd_nom AS cd_nom_25, t0.cd_nom AS cd_nom_26, t0.cd_nom AS cd_nom_27, t0.cd_nom AS cd_nom_28 FROM ipn_taxonomie.vm_taxref_last t0 WHERE t0.cd_nom = 1040529 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cd_ref AS cd_ref_2,
  t0.deb_possible AS deb_possible_3,
  t0.deb_sur AS deb_sur_4,
  t0.fin_sur AS fin_sur_5,
  t0.fin_possible AS fin_possible_6,
  t0.cd_ref AS cd_ref_7,
  t0.ref_stade AS ref_stade_8
FROM
  ipn_validation.corr_pheno t0
WHERE
  t0.cd_ref = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.cd_ref AS cd_ref_2, t0.deb_possible AS deb_possible_3, t0.deb_sur AS deb_sur_4, t0.fin_sur AS fin_sur_5, t0.fin_possible AS fin_possible_6, t0.cd_ref AS cd_ref_7, t0.ref_stade AS ref_stade_8 FROM ipn_validation.corr_pheno t0 WHERE t0.cd_ref = 1040529 ORDER BY t0.id ASC;

SELECT
  f0_.eid AS eid_0,
  f0_.libelle AS libelle_1,
  f1_.opacite AS opacite_2,
  f1_.affiche AS affiche_3,
  f1_.ordre AS ordre_4,
  f1_.index AS index_5,
  f1_.style AS style_6,
  f1_.min_reso AS min_reso_7,
  f1_.max_reso AS max_reso_8,
  f2_.fid AS fid_9,
  f2_.libelle_court AS libelle_court_10,
  f2_.libelle AS libelle_11,
  f2_.legende AS legende_12,
  f2_.type AS type_13,
  f2_.params AS params_14,
  f2_.vignette AS vignette_15,
  f1_.eid AS eid_16,
  f1_.fid AS fid_17
FROM
  ipn_carto.fauna_environnements_carto f0_
  INNER JOIN ipn_carto.fauna_corr_environnements_carto_fonds_plans f1_ ON f0_.eid = f1_.eid
  INNER JOIN ipn_carto.fauna_fonds_plans_disponibles f2_ ON f1_.fid = f2_.fid
WHERE
  f0_.eid = 1
ORDER BY
  f1_.ordre ASC

SELECT f0_.eid AS eid_0, f0_.libelle AS libelle_1, f1_.opacite AS opacite_2, f1_.affiche AS affiche_3, f1_.ordre AS ordre_4, f1_.index AS index_5, f1_.style AS style_6, f1_.min_reso AS min_reso_7, f1_.max_reso AS max_reso_8, f2_.fid AS fid_9, f2_.libelle_court AS libelle_court_10, f2_.libelle AS libelle_11, f2_.legende AS legende_12, f2_.type AS type_13, f2_.params AS params_14, f2_.vignette AS vignette_15, f1_.eid AS eid_16, f1_.fid AS fid_17 FROM ipn_carto.fauna_environnements_carto f0_ INNER JOIN ipn_carto.fauna_corr_environnements_carto_fonds_plans f1_ ON f0_.eid = f1_.eid INNER JOIN ipn_carto.fauna_fonds_plans_disponibles f2_ ON f1_.fid = f2_.fid WHERE f0_.eid = 1 ORDER BY f1_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.departement AS departement_2,
  t0.statut_pres_dpt AS statut_pres_dpt_3,
  t0.cd_nom AS cd_nom_4
FROM
  ipn_referentiel_taxo_v2.taxon_presence_departementale t0
WHERE
  t0.cd_nom = ?

SELECT t0.id AS id_1, t0.departement AS departement_2, t0.statut_pres_dpt AS statut_pres_dpt_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxon_presence_departementale t0 WHERE t0.cd_nom = 1040529;

SELECT
  t0.id AS id_1,
  t0.zonage_marin AS zonage_marin_2,
  t0.statut_presence AS statut_presence_3,
  t0.cd_nom AS cd_nom_4
FROM
  ipn_referentiel_taxo_v2.taxon_presence_zonage_marin t0
WHERE
  t0.cd_nom = ?

SELECT t0.id AS id_1, t0.zonage_marin AS zonage_marin_2, t0.statut_presence AS statut_presence_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxon_presence_zonage_marin t0 WHERE t0.cd_nom = 1040529;