Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.resume AS resume_3,
  t0.ordre AS ordre_4,
  t0.classes_richesse AS classes_richesse_5,
  t0.classes_pression_obs AS classes_pression_obs_6,
  t0.restreint_users AS restreint_users_7,
  t0.grands_habitats_taxef AS grands_habitats_taxef_8,
  t0.icone AS icone_9,
  t0.libelle_uri AS libelle_uri_10,
  t0.groupe_usuel_id AS groupe_usuel_id_11,
  t0.groupe_fonctionnel_id AS groupe_fonctionnel_id_12,
  t0.photo_taxon_reference AS photo_taxon_reference_13,
  t0.id AS id_14
FROM
  ipn_taxonomie.portail_taxo t0
WHERE
  t0.libelle_uri = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.resume AS resume_3, t0.ordre AS ordre_4, t0.classes_richesse AS classes_richesse_5, t0.classes_pression_obs AS classes_pression_obs_6, t0.restreint_users AS restreint_users_7, t0.grands_habitats_taxef AS grands_habitats_taxef_8, t0.icone AS icone_9, t0.libelle_uri AS libelle_uri_10, t0.groupe_usuel_id AS groupe_usuel_id_11, t0.groupe_fonctionnel_id AS groupe_fonctionnel_id_12, t0.photo_taxon_reference AS photo_taxon_reference_13, t0.id AS id_14 FROM ipn_taxonomie.portail_taxo t0 WHERE t0.libelle_uri = 'mammiferes-marins' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.libelle AS libelle_1,
  p0_.resume AS resume_2,
  p0_.ordre AS ordre_3,
  p0_.classes_richesse AS classes_richesse_4,
  p0_.classes_pression_obs AS classes_pression_obs_5,
  p0_.restreint_users AS restreint_users_6,
  p0_.grands_habitats_taxef AS grands_habitats_taxef_7,
  p0_.icone AS icone_8,
  p0_.libelle_uri AS libelle_uri_9,
  g1_.gid AS gid_10,
  g1_.libelle_item AS libelle_item_11,
  g1_.icone AS icone_12,
  g1_.libelle_uri AS libelle_uri_13,
  g1_.cd_ref_gpes AS cd_ref_gpes_14,
  g1_.gpe_sup AS gpe_sup_15,
  g1_.code_machine AS code_machine_16,
  g1_.resume AS resume_17,
  g1_.ordre AS ordre_18,
  g1_.portail_ouvert AS portail_ouvert_19,
  g1_.classes_richesse AS classes_richesse_20,
  g1_.classes_pression_obs AS classes_pression_obs_21,
  g1_.portail_restreint_users AS portail_restreint_users_22,
  g2_.gid AS gid_23,
  g2_.libelle_item AS libelle_item_24,
  g2_.libelle_uri AS libelle_uri_25,
  g2_.resume AS resume_26,
  g2_.icone AS icone_27,
  g2_.portail_ouvert AS portail_ouvert_28,
  g2_.portail_restreint_users AS portail_restreint_users_29,
  g2_.code_machine AS code_machine_30,
  p3_.pid AS pid_31,
  p3_.credits AS credits_32,
  p3_.description AS description_33,
  p3_.nom_fichier AS nom_fichier_34,
  p3_.photo_ref AS photo_ref_35,
  p3_.date_creation AS date_creation_36,
  p3_.date_revision AS date_revision_37,
  p4_.pid AS pid_38,
  p4_.nb_observations AS nb_observations_39,
  p4_.nb_photos AS nb_photos_40,
  p4_.nb_especes AS nb_especes_41,
  p4_.nb_proteges AS nb_proteges_42,
  p4_.nb_menaces AS nb_menaces_43,
  p4_.nb_introduites AS nb_introduites_44,
  p4_.nb_contributeurs AS nb_contributeurs_45,
  p0_.groupe_usuel_id AS groupe_usuel_id_46,
  p0_.groupe_fonctionnel_id AS groupe_fonctionnel_id_47,
  p0_.photo_taxon_reference AS photo_taxon_reference_48,
  p0_.id AS id_49,
  g1_.gid AS gid_50,
  p3_.cd_ref AS cd_ref_51,
  p3_.id_numerisateur AS id_numerisateur_52,
  p3_.id_licence AS id_licence_53,
  p3_.id_statut AS id_statut_54,
  p3_.gestionnaire AS gestionnaire_55
FROM
  ipn_taxonomie.portail_taxo p0_
  LEFT JOIN ipn_taxonomie.groupes_usuels g1_ ON p0_.groupe_usuel_id = g1_.gid
  LEFT JOIN ipn_taxonomie.groupes_fonctionnels g2_ ON p0_.groupe_fonctionnel_id = g2_.gid
  INNER JOIN ipn_photo.photo_taxon p3_ ON p0_.photo_taxon_reference = p3_.pid
  INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.portail_taxo p4_ ON p0_.id = p4_.pid
WHERE
  p0_.restreint_users IS NULL
ORDER BY
  p0_.libelle ASC

SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.resume AS resume_2, p0_.ordre AS ordre_3, p0_.classes_richesse AS classes_richesse_4, p0_.classes_pression_obs AS classes_pression_obs_5, p0_.restreint_users AS restreint_users_6, p0_.grands_habitats_taxef AS grands_habitats_taxef_7, p0_.icone AS icone_8, p0_.libelle_uri AS libelle_uri_9, g1_.gid AS gid_10, g1_.libelle_item AS libelle_item_11, g1_.icone AS icone_12, g1_.libelle_uri AS libelle_uri_13, g1_.cd_ref_gpes AS cd_ref_gpes_14, g1_.gpe_sup AS gpe_sup_15, g1_.code_machine AS code_machine_16, g1_.resume AS resume_17, g1_.ordre AS ordre_18, g1_.portail_ouvert AS portail_ouvert_19, g1_.classes_richesse AS classes_richesse_20, g1_.classes_pression_obs AS classes_pression_obs_21, g1_.portail_restreint_users AS portail_restreint_users_22, g2_.gid AS gid_23, g2_.libelle_item AS libelle_item_24, g2_.libelle_uri AS libelle_uri_25, g2_.resume AS resume_26, g2_.icone AS icone_27, g2_.portail_ouvert AS portail_ouvert_28, g2_.portail_restreint_users AS portail_restreint_users_29, g2_.code_machine AS code_machine_30, p3_.pid AS pid_31, p3_.credits AS credits_32, p3_.description AS description_33, p3_.nom_fichier AS nom_fichier_34, p3_.photo_ref AS photo_ref_35, p3_.date_creation AS date_creation_36, p3_.date_revision AS date_revision_37, p4_.pid AS pid_38, p4_.nb_observations AS nb_observations_39, p4_.nb_photos AS nb_photos_40, p4_.nb_especes AS nb_especes_41, p4_.nb_proteges AS nb_proteges_42, p4_.nb_menaces AS nb_menaces_43, p4_.nb_introduites AS nb_introduites_44, p4_.nb_contributeurs AS nb_contributeurs_45, p0_.groupe_usuel_id AS groupe_usuel_id_46, p0_.groupe_fonctionnel_id AS groupe_fonctionnel_id_47, p0_.photo_taxon_reference AS photo_taxon_reference_48, p0_.id AS id_49, g1_.gid AS gid_50, p3_.cd_ref AS cd_ref_51, p3_.id_numerisateur AS id_numerisateur_52, p3_.id_licence AS id_licence_53, p3_.id_statut AS id_statut_54, p3_.gestionnaire AS gestionnaire_55 FROM ipn_taxonomie.portail_taxo p0_ LEFT JOIN ipn_taxonomie.groupes_usuels g1_ ON p0_.groupe_usuel_id = g1_.gid LEFT JOIN ipn_taxonomie.groupes_fonctionnels g2_ ON p0_.groupe_fonctionnel_id = g2_.gid INNER JOIN ipn_photo.photo_taxon p3_ ON p0_.photo_taxon_reference = p3_.pid INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.portail_taxo p4_ ON p0_.id = p4_.pid WHERE p0_.restreint_users IS NULL ORDER BY p0_.libelle ASC;

SELECT
  e0_.mois AS mois_0,
  SUM(e0_.nb_obs) AS sclr_1
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_
  INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom
  AND (
    v1_.groupes_usuels IS NOT NULL
    AND (v1_.groupes_usuels && ARRAY[93]) = true
  )
  INNER JOIN ipn_referentiel_taxo_v2.taxons t2_ ON v1_.cd_nom = t2_.cd_ref
GROUP BY
  e0_.mois

SELECT e0_.mois AS mois_0, SUM(e0_.nb_obs) AS sclr_1 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom AND (v1_.groupes_usuels IS NOT NULL AND (v1_.groupes_usuels && ARRAY[93]) = true) INNER JOIN ipn_referentiel_taxo_v2.taxons t2_ ON v1_.cd_nom = t2_.cd_ref GROUP BY e0_.mois;

SELECT
  e0_.annee AS annee_0,
  SUM(e0_.nb_obs_occ) AS sclr_1,
  SUM(e0_.nb_obs_synth) AS sclr_2
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_
  INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom
  AND (
    v1_.groupes_usuels IS NOT NULL
    AND (v1_.groupes_usuels && ARRAY[93]) = true
  )
  INNER JOIN ipn_referentiel_taxo_v2.taxons t2_ ON v1_.cd_nom = t2_.cd_ref
GROUP BY
  e0_.annee
ORDER BY
  e0_.annee ASC

SELECT e0_.annee AS annee_0, SUM(e0_.nb_obs_occ) AS sclr_1, SUM(e0_.nb_obs_synth) AS sclr_2 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom AND (v1_.groupes_usuels IS NOT NULL AND (v1_.groupes_usuels && ARRAY[93]) = true) INNER JOIN ipn_referentiel_taxo_v2.taxons t2_ ON v1_.cd_nom = t2_.cd_ref GROUP BY e0_.annee ORDER BY e0_.annee ASC;

SELECT
  t0.serial AS serial_1,
  t0.mail AS mail_2,
  t0.mail_transitoire AS mail_transitoire_3,
  t0.validermail_key AS validermail_key_4,
  t0.poste_occupe AS poste_occupe_5,
  t0.date_creation AS date_creation_6,
  t0.derniere_date_edition AS derniere_date_edition_7,
  t0.newsletter AS newsletter_8,
  t0.statut AS statut_9,
  t0.uid AS uid_10,
  t0.orgid AS orgid_11
FROM
  ipn_user.corr_utilisateur_organisme t0
WHERE
  t0.uid IS NULL
  AND t0.statut = ?

SELECT t0.serial AS serial_1, t0.mail AS mail_2, t0.mail_transitoire AS mail_transitoire_3, t0.validermail_key AS validermail_key_4, t0.poste_occupe AS poste_occupe_5, t0.date_creation AS date_creation_6, t0.derniere_date_edition AS derniere_date_edition_7, t0.newsletter AS newsletter_8, t0.statut AS statut_9, t0.uid AS uid_10, t0.orgid AS orgid_11 FROM ipn_user.corr_utilisateur_organisme t0 WHERE t0.uid IS NULL AND t0.statut = 1;

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;