Symfony Profiler

SELECT
  t0_.cd_ref AS cd_ref_0,
  t0_.date_creation AS date_creation_1,
  t0_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_2,
  t0_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_3,
  t0_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_4,
  t0_.source_indice_distribution_regionale AS source_indice_distribution_regionale_5,
  t0_.pra AS pra_6,
  v1_.cd_nom AS cd_nom_7,
  v1_.cd_ref AS cd_ref_8,
  v1_.lb_nom AS lb_nom_9,
  v1_.lb_auteur AS lb_auteur_10,
  v1_.nom_vern AS nom_vern_11,
  v1_.premier_nom_vern AS premier_nom_vern_12,
  v1_.nom_valide AS nom_valide_13,
  v1_.rang AS rang_14,
  v1_.embranchement AS embranchement_15,
  v1_.classe AS classe_16,
  v1_.ordre AS ordre_17,
  v1_.famille AS famille_18,
  v1_.version AS version_19,
  v1_.presence_metropole AS presence_metropole_20,
  v1_.icone AS icone_21,
  v1_.cd_espece AS cd_espece_22,
  v1_.taxons_superieurs AS taxons_superieurs_23,
  v1_.groupes_usuels AS groupes_usuels_24,
  v1_.groupes_fonctionnels AS groupes_fonctionnels_25,
  r2_.id AS id_26,
  r2_.libelle_court AS libelle_court_27,
  r2_.libelle AS libelle_28,
  r2_.description AS description_29,
  r2_.couleur AS couleur_30,
  r2_.couleur_texte AS couleur_texte_31,
  r2_.ordre AS ordre_32,
  r2_.libelle_introduction AS libelle_introduction_33,
  r3_.id AS id_34,
  r3_.libelle_court AS libelle_court_35,
  r3_.libelle AS libelle_36,
  r3_.description AS description_37,
  r3_.echelle AS echelle_38,
  r3_.couleur AS couleur_39,
  r3_.couleur_texte AS couleur_texte_40,
  r4_.id AS id_41,
  r4_.libelle AS libelle_42,
  r4_.libelle_court AS libelle_court_43,
  r4_.description AS description_44,
  r4_.couleur AS couleur_45,
  r4_.couleur_texte AS couleur_texte_46,
  r5_.id AS id_47,
  r5_.libelle AS libelle_48,
  r5_.libelle_court AS libelle_court_49,
  r5_.val_min AS val_min_50,
  r5_.val_max AS val_max_51,
  r5_.couleur AS couleur_52,
  r5_.couleur_texte AS couleur_texte_53,
  r6_.id AS id_54,
  r6_.libelle AS libelle_55,
  r6_.description AS description_56,
  t0_.id_numerisateur AS id_numerisateur_57,
  t0_.statut_presence_regionale AS statut_presence_regionale_58,
  t0_.statut_indigenat_regional AS statut_indigenat_regional_59,
  t0_.statut_endemisme AS statut_endemisme_60,
  t0_.statut_rarete AS statut_rarete_61,
  t0_.enjeu AS enjeu_62,
  t0_.cd_ref AS cd_ref_63,
  v1_.cd_nom AS cd_nom_64,
  v1_.cd_nom AS cd_nom_65,
  v1_.cd_ref AS cd_ref_66,
  v1_.rang AS rang_67,
  v1_.habitat AS habitat_68,
  v1_.cd_nom AS cd_nom_69,
  v1_.cd_nom AS cd_nom_70,
  v1_.cd_nom AS cd_nom_71,
  v1_.cd_nom AS cd_nom_72
FROM
  ipn_referentiel_taxo_v2.taxons t0_
  INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON t0_.cd_ref = v1_.cd_nom
  INNER JOIN ipn_requeteur_v3.referentiel_espece r7_ ON v1_.cd_nom = r7_.cd_ref
  LEFT JOIN ipn_referentiel_taxo_v2.ref_indigenat_regional r2_ ON t0_.statut_indigenat_regional = r2_.id
  LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_presence r3_ ON t0_.statut_presence_regionale = r3_.id
  LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_endemisme r4_ ON t0_.statut_endemisme = r4_.id
  LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_rarete r5_ ON t0_.statut_rarete = r5_.id
  LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_enjeu r6_ ON t0_.enjeu = r6_.id
WHERE
  v1_.groupes_usuels IS NOT NULL
  AND (v1_.groupes_usuels && ARRAY[40]) = true

SELECT t0_.cd_ref AS cd_ref_0, t0_.date_creation AS date_creation_1, t0_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_2, t0_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_3, t0_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_4, t0_.source_indice_distribution_regionale AS source_indice_distribution_regionale_5, t0_.pra AS pra_6, v1_.cd_nom AS cd_nom_7, v1_.cd_ref AS cd_ref_8, v1_.lb_nom AS lb_nom_9, v1_.lb_auteur AS lb_auteur_10, v1_.nom_vern AS nom_vern_11, v1_.premier_nom_vern AS premier_nom_vern_12, v1_.nom_valide AS nom_valide_13, v1_.rang AS rang_14, v1_.embranchement AS embranchement_15, v1_.classe AS classe_16, v1_.ordre AS ordre_17, v1_.famille AS famille_18, v1_.version AS version_19, v1_.presence_metropole AS presence_metropole_20, v1_.icone AS icone_21, v1_.cd_espece AS cd_espece_22, v1_.taxons_superieurs AS taxons_superieurs_23, v1_.groupes_usuels AS groupes_usuels_24, v1_.groupes_fonctionnels AS groupes_fonctionnels_25, r2_.id AS id_26, r2_.libelle_court AS libelle_court_27, r2_.libelle AS libelle_28, r2_.description AS description_29, r2_.couleur AS couleur_30, r2_.couleur_texte AS couleur_texte_31, r2_.ordre AS ordre_32, r2_.libelle_introduction AS libelle_introduction_33, r3_.id AS id_34, r3_.libelle_court AS libelle_court_35, r3_.libelle AS libelle_36, r3_.description AS description_37, r3_.echelle AS echelle_38, r3_.couleur AS couleur_39, r3_.couleur_texte AS couleur_texte_40, r4_.id AS id_41, r4_.libelle AS libelle_42, r4_.libelle_court AS libelle_court_43, r4_.description AS description_44, r4_.couleur AS couleur_45, r4_.couleur_texte AS couleur_texte_46, r5_.id AS id_47, r5_.libelle AS libelle_48, r5_.libelle_court AS libelle_court_49, r5_.val_min AS val_min_50, r5_.val_max AS val_max_51, r5_.couleur AS couleur_52, r5_.couleur_texte AS couleur_texte_53, r6_.id AS id_54, r6_.libelle AS libelle_55, r6_.description AS description_56, t0_.id_numerisateur AS id_numerisateur_57, t0_.statut_presence_regionale AS statut_presence_regionale_58, t0_.statut_indigenat_regional AS statut_indigenat_regional_59, t0_.statut_endemisme AS statut_endemisme_60, t0_.statut_rarete AS statut_rarete_61, t0_.enjeu AS enjeu_62, t0_.cd_ref AS cd_ref_63, v1_.cd_nom AS cd_nom_64, v1_.cd_nom AS cd_nom_65, v1_.cd_ref AS cd_ref_66, v1_.rang AS rang_67, v1_.habitat AS habitat_68, v1_.cd_nom AS cd_nom_69, v1_.cd_nom AS cd_nom_70, v1_.cd_nom AS cd_nom_71, v1_.cd_nom AS cd_nom_72 FROM ipn_referentiel_taxo_v2.taxons t0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON t0_.cd_ref = v1_.cd_nom INNER JOIN ipn_requeteur_v3.referentiel_espece r7_ ON v1_.cd_nom = r7_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.ref_indigenat_regional r2_ ON t0_.statut_indigenat_regional = r2_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_presence r3_ ON t0_.statut_presence_regionale = r3_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_endemisme r4_ ON t0_.statut_endemisme = r4_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_rarete r5_ ON t0_.statut_rarete = r5_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_enjeu r6_ ON t0_.enjeu = r6_.id WHERE v1_.groupes_usuels IS NOT NULL AND (v1_.groupes_usuels && ARRAY[40]) = true;

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_.icone AS icone_7,
  p0_.libelle_uri AS libelle_uri_8,
  g1_.gid AS gid_9,
  g1_.libelle_item AS libelle_item_10,
  g1_.icone AS icone_11,
  g1_.libelle_uri AS libelle_uri_12,
  g1_.cd_ref_gpes AS cd_ref_gpes_13,
  g1_.gpe_sup AS gpe_sup_14,
  g1_.code_machine AS code_machine_15,
  g1_.resume AS resume_16,
  g1_.ordre AS ordre_17,
  g1_.portail_ouvert AS portail_ouvert_18,
  g1_.classes_richesse AS classes_richesse_19,
  g1_.classes_pression_obs AS classes_pression_obs_20,
  g1_.portail_restreint_users AS portail_restreint_users_21,
  g2_.gid AS gid_22,
  g2_.libelle_item AS libelle_item_23,
  g2_.libelle_uri AS libelle_uri_24,
  g2_.resume AS resume_25,
  g2_.icone AS icone_26,
  g2_.portail_ouvert AS portail_ouvert_27,
  g2_.portail_restreint_users AS portail_restreint_users_28,
  g2_.code_machine AS code_machine_29,
  p3_.pid AS pid_30,
  p3_.credits AS credits_31,
  p3_.description AS description_32,
  p3_.nom_fichier AS nom_fichier_33,
  p3_.photo_ref AS photo_ref_34,
  p3_.date_creation AS date_creation_35,
  p3_.date_revision AS date_revision_36,
  p4_.pid AS pid_37,
  p4_.nb_observations AS nb_observations_38,
  p4_.nb_photos AS nb_photos_39,
  p4_.nb_especes AS nb_especes_40,
  p4_.nb_proteges AS nb_proteges_41,
  p4_.nb_menaces AS nb_menaces_42,
  p4_.nb_introduites AS nb_introduites_43,
  p4_.nb_contributeurs AS nb_contributeurs_44,
  p0_.groupe_usuel_id AS groupe_usuel_id_45,
  p0_.groupe_fonctionnel_id AS groupe_fonctionnel_id_46,
  p0_.photo_taxon_reference AS photo_taxon_reference_47,
  p0_.id AS id_48,
  g1_.gid AS gid_49,
  p3_.cd_ref AS cd_ref_50,
  p3_.id_numerisateur AS id_numerisateur_51,
  p3_.id_licence AS id_licence_52,
  p3_.id_statut AS id_statut_53,
  p3_.gestionnaire AS gestionnaire_54
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_.icone AS icone_7, p0_.libelle_uri AS libelle_uri_8, g1_.gid AS gid_9, g1_.libelle_item AS libelle_item_10, g1_.icone AS icone_11, g1_.libelle_uri AS libelle_uri_12, g1_.cd_ref_gpes AS cd_ref_gpes_13, g1_.gpe_sup AS gpe_sup_14, g1_.code_machine AS code_machine_15, g1_.resume AS resume_16, g1_.ordre AS ordre_17, g1_.portail_ouvert AS portail_ouvert_18, g1_.classes_richesse AS classes_richesse_19, g1_.classes_pression_obs AS classes_pression_obs_20, g1_.portail_restreint_users AS portail_restreint_users_21, g2_.gid AS gid_22, g2_.libelle_item AS libelle_item_23, g2_.libelle_uri AS libelle_uri_24, g2_.resume AS resume_25, g2_.icone AS icone_26, g2_.portail_ouvert AS portail_ouvert_27, g2_.portail_restreint_users AS portail_restreint_users_28, g2_.code_machine AS code_machine_29, p3_.pid AS pid_30, p3_.credits AS credits_31, p3_.description AS description_32, p3_.nom_fichier AS nom_fichier_33, p3_.photo_ref AS photo_ref_34, p3_.date_creation AS date_creation_35, p3_.date_revision AS date_revision_36, p4_.pid AS pid_37, p4_.nb_observations AS nb_observations_38, p4_.nb_photos AS nb_photos_39, p4_.nb_especes AS nb_especes_40, p4_.nb_proteges AS nb_proteges_41, p4_.nb_menaces AS nb_menaces_42, p4_.nb_introduites AS nb_introduites_43, p4_.nb_contributeurs AS nb_contributeurs_44, p0_.groupe_usuel_id AS groupe_usuel_id_45, p0_.groupe_fonctionnel_id AS groupe_fonctionnel_id_46, p0_.photo_taxon_reference AS photo_taxon_reference_47, p0_.id AS id_48, g1_.gid AS gid_49, p3_.cd_ref AS cd_ref_50, p3_.id_numerisateur AS id_numerisateur_51, p3_.id_licence AS id_licence_52, p3_.id_statut AS id_statut_53, p3_.gestionnaire AS gestionnaire_54 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
  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.icone AS icone_8,
  t0.libelle_uri AS libelle_uri_9,
  t0.groupe_usuel_id AS groupe_usuel_id_10,
  t0.groupe_fonctionnel_id AS groupe_fonctionnel_id_11,
  t0.photo_taxon_reference AS photo_taxon_reference_12,
  t0.id AS id_13
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.icone AS icone_8, t0.libelle_uri AS libelle_uri_9, t0.groupe_usuel_id AS groupe_usuel_id_10, t0.groupe_fonctionnel_id AS groupe_fonctionnel_id_11, t0.photo_taxon_reference AS photo_taxon_reference_12, t0.id AS id_13 FROM ipn_taxonomie.portail_taxo t0 WHERE t0.libelle_uri = 'libellules-et-demoiselles' LIMIT 1;

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;