Symfony Profiler

SELECT
  t0.gid AS gid_1,
  t0.libelle_item AS libelle_item_2,
  t0.icone AS icone_3,
  t0.libelle_uri AS libelle_uri_4,
  t0.cd_ref_gpes AS cd_ref_gpes_5,
  t0.gpe_sup AS gpe_sup_6,
  t0.code_machine AS code_machine_7,
  t0.resume AS resume_8,
  t0.ordre AS ordre_9,
  t0.portail_ouvert AS portail_ouvert_10,
  t0.classes_richesse AS classes_richesse_11,
  t0.classes_pression_obs AS classes_pression_obs_12,
  t0.portail_restreint_users AS portail_restreint_users_13,
  t0.gid AS gid_14
FROM
  ipn_taxonomie.groupes_usuels t0

SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.icone AS icone_3, t0.libelle_uri AS libelle_uri_4, t0.cd_ref_gpes AS cd_ref_gpes_5, t0.gpe_sup AS gpe_sup_6, t0.code_machine AS code_machine_7, t0.resume AS resume_8, t0.ordre AS ordre_9, t0.portail_ouvert AS portail_ouvert_10, t0.classes_richesse AS classes_richesse_11, t0.classes_pression_obs AS classes_pression_obs_12, t0.portail_restreint_users AS portail_restreint_users_13, t0.gid AS gid_14 FROM ipn_taxonomie.groupes_usuels t0;

SELECT
  g0_.gid AS gid_0,
  g0_.libelle_item AS libelle_item_1,
  g0_.libelle_uri AS libelle_uri_2,
  g0_.gpe_sup AS gpe_sup_3,
  g0_.icone AS icone_4,
  g1_.nb_especes AS nb_especes_5,
  g1_.nb_especes_evaluees AS nb_especes_evaluees_6,
  g1_.nb_proteges AS nb_proteges_7,
  g1_.nb_menaces AS nb_menaces_8,
  g1_.nb_exotiques AS nb_exotiques_9
FROM
  ipn_taxonomie.groupes_usuels g0_
  INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel g1_ ON g0_.gid = g1_.groupe_usuel
ORDER BY
  g0_.ordre ASC

SELECT g0_.gid AS gid_0, g0_.libelle_item AS libelle_item_1, g0_.libelle_uri AS libelle_uri_2, g0_.gpe_sup AS gpe_sup_3, g0_.icone AS icone_4, g1_.nb_especes AS nb_especes_5, g1_.nb_especes_evaluees AS nb_especes_evaluees_6, g1_.nb_proteges AS nb_proteges_7, g1_.nb_menaces AS nb_menaces_8, g1_.nb_exotiques AS nb_exotiques_9 FROM ipn_taxonomie.groupes_usuels g0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel g1_ ON g0_.gid = g1_.groupe_usuel ORDER BY g0_.ordre ASC;

SELECT
  t0.groupe_usuel AS groupe_usuel_1,
  t0.gpe_sup AS gpe_sup_2,
  t0.nb_observations AS nb_observations_3,
  t0.nb_photos AS nb_photos_4,
  t0.nb_especes AS nb_especes_5,
  t0.nb_especes_evaluees AS nb_especes_evaluees_6,
  t0.nb_proteges AS nb_proteges_7,
  t0.nb_menaces AS nb_menaces_8,
  t0.nb_exotiques AS nb_exotiques_9,
  t0.nb_introduites AS nb_introduites_10,
  t0.nb_contributeurs AS nb_contributeurs_11,
  t12.gid AS gid_13,
  t12.libelle_item AS libelle_item_14,
  t12.icone AS icone_15,
  t12.libelle_uri AS libelle_uri_16,
  t12.cd_ref_gpes AS cd_ref_gpes_17,
  t12.gpe_sup AS gpe_sup_18,
  t12.code_machine AS code_machine_19,
  t12.resume AS resume_20,
  t12.ordre AS ordre_21,
  t12.portail_ouvert AS portail_ouvert_22,
  t12.classes_richesse AS classes_richesse_23,
  t12.classes_pression_obs AS classes_pression_obs_24,
  t12.portail_restreint_users AS portail_restreint_users_25,
  t12.gid AS gid_26
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel t0
  LEFT JOIN ipn_taxonomie.groupes_usuels t12 ON t12.gid = t0.groupe_usuel
WHERE
  t0.groupe_usuel = ?

SELECT t0.groupe_usuel AS groupe_usuel_1, t0.gpe_sup AS gpe_sup_2, t0.nb_observations AS nb_observations_3, t0.nb_photos AS nb_photos_4, t0.nb_especes AS nb_especes_5, t0.nb_especes_evaluees AS nb_especes_evaluees_6, t0.nb_proteges AS nb_proteges_7, t0.nb_menaces AS nb_menaces_8, t0.nb_exotiques AS nb_exotiques_9, t0.nb_introduites AS nb_introduites_10, t0.nb_contributeurs AS nb_contributeurs_11, t12.gid AS gid_13, t12.libelle_item AS libelle_item_14, t12.icone AS icone_15, t12.libelle_uri AS libelle_uri_16, t12.cd_ref_gpes AS cd_ref_gpes_17, t12.gpe_sup AS gpe_sup_18, t12.code_machine AS code_machine_19, t12.resume AS resume_20, t12.ordre AS ordre_21, t12.portail_ouvert AS portail_ouvert_22, t12.classes_richesse AS classes_richesse_23, t12.classes_pression_obs AS classes_pression_obs_24, t12.portail_restreint_users AS portail_restreint_users_25, t12.gid AS gid_26 FROM ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel t0 LEFT JOIN ipn_taxonomie.groupes_usuels t12 ON t12.gid = t0.groupe_usuel WHERE t0.groupe_usuel = 2;

SELECT
  t0.gid AS gid_1,
  t0.libelle_item AS libelle_item_2,
  t0.icone AS icone_3,
  t0.libelle_uri AS libelle_uri_4,
  t0.cd_ref_gpes AS cd_ref_gpes_5,
  t0.gpe_sup AS gpe_sup_6,
  t0.code_machine AS code_machine_7,
  t0.resume AS resume_8,
  t0.ordre AS ordre_9,
  t0.portail_ouvert AS portail_ouvert_10,
  t0.classes_richesse AS classes_richesse_11,
  t0.classes_pression_obs AS classes_pression_obs_12,
  t0.portail_restreint_users AS portail_restreint_users_13,
  t0.gid AS gid_14
FROM
  ipn_taxonomie.groupes_usuels t0

SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.icone AS icone_3, t0.libelle_uri AS libelle_uri_4, t0.cd_ref_gpes AS cd_ref_gpes_5, t0.gpe_sup AS gpe_sup_6, t0.code_machine AS code_machine_7, t0.resume AS resume_8, t0.ordre AS ordre_9, t0.portail_ouvert AS portail_ouvert_10, t0.classes_richesse AS classes_richesse_11, t0.classes_pression_obs AS classes_pression_obs_12, t0.portail_restreint_users AS portail_restreint_users_13, t0.gid AS gid_14 FROM ipn_taxonomie.groupes_usuels t0;

SELECT
  g0_.gid AS gid_0,
  g0_.libelle_item AS libelle_item_1,
  g0_.libelle_uri AS libelle_uri_2,
  g0_.gpe_sup AS gpe_sup_3,
  g0_.icone AS icone_4
FROM
  ipn_taxonomie.groupes_usuels g0_
ORDER BY
  g0_.ordre ASC

SELECT g0_.gid AS gid_0, g0_.libelle_item AS libelle_item_1, g0_.libelle_uri AS libelle_uri_2, g0_.gpe_sup AS gpe_sup_3, g0_.icone AS icone_4 FROM ipn_taxonomie.groupes_usuels g0_ ORDER BY g0_.ordre ASC;

SELECT
  t0.hid AS hid_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.milieu_generique AS milieu_generique_4
FROM
  ipn_taxonomie.vm_taxref_last_habitats t0
ORDER BY
  t0.libelle ASC

SELECT t0.hid AS hid_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.milieu_generique AS milieu_generique_4 FROM ipn_taxonomie.vm_taxref_last_habitats t0 ORDER BY t0.libelle ASC;

SELECT
  t0.gid AS gid_1,
  t0.libelle_item AS libelle_item_2,
  t0.libelle_uri AS libelle_uri_3,
  t0.resume AS resume_4,
  t0.icone AS icone_5,
  t0.portail_ouvert AS portail_ouvert_6,
  t0.portail_restreint_users AS portail_restreint_users_7,
  t0.code_machine AS code_machine_8
FROM
  ipn_taxonomie.groupes_fonctionnels t0

SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.libelle_uri AS libelle_uri_3, t0.resume AS resume_4, t0.icone AS icone_5, t0.portail_ouvert AS portail_ouvert_6, t0.portail_restreint_users AS portail_restreint_users_7, t0.code_machine AS code_machine_8 FROM ipn_taxonomie.groupes_fonctionnels t0;

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.echelle IN (?, ?)
ORDER BY
  t0.id ASC

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.echelle IN ('all', 'reg') ORDER BY t0.id ASC;

SELECT
  d0_.code_dept AS code_dept_0,
  d0_.nom_dept AS nom_dept_1,
  d0_.code_region AS code_region_2,
  d0_.regions AS regions_3
FROM
  ipn_carto.departement d0_
WHERE
  d0_.code_region = '75'
ORDER BY
  d0_.nom_dept ASC

SELECT d0_.code_dept AS code_dept_0, d0_.nom_dept AS nom_dept_1, d0_.code_region AS code_region_2, d0_.regions AS regions_3 FROM ipn_carto.departement d0_ WHERE d0_.code_region = '75' ORDER BY d0_.nom_dept ASC;

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.echelle IN (?, ?)
ORDER BY
  t0.id ASC

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.echelle IN ('all', 'dept') ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.libelle_court AS libelle_court_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.couleur AS couleur_5,
  t0.couleur_texte AS couleur_texte_6,
  t0.ordre AS ordre_7,
  t0.libelle_introduction AS libelle_introduction_8
FROM
  ipn_referentiel_taxo_v2.ref_indigenat_regional t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.libelle_court AS libelle_court_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.couleur_texte AS couleur_texte_6, t0.ordre AS ordre_7, t0.libelle_introduction AS libelle_introduction_8 FROM ipn_referentiel_taxo_v2.ref_indigenat_regional t0 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_court AS libelle_court_3,
  t0.description AS description_4,
  t0.couleur AS couleur_5,
  t0.couleur_texte AS couleur_texte_6
FROM
  ipn_referentiel_taxo_v2.ref_statut_endemisme t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_court AS libelle_court_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.couleur_texte AS couleur_texte_6 FROM ipn_referentiel_taxo_v2.ref_statut_endemisme t0 ORDER BY t0.id ASC;

SELECT
  s.*,
  t.*
FROM
  referentiels_inpn.bdc_sources_reglementations s
  JOIN ipn_referentiel_taxo_v2.ref_type_reglementation t ON s.ref_type = t.libelle_court
ORDER BY
  s.type

SELECT
                    s.*,
                    t.*
                FROM referentiels_inpn.bdc_sources_reglementations s
                JOIN ipn_referentiel_taxo_v2.ref_type_reglementation t ON s.ref_type = t.libelle_court
                ORDER BY s.type;

SELECT
  r0_.id_categorie AS id_categorie_0,
  r0_.libelle AS libelle_1
FROM
  ipn_liste_rouge.ref_categorie_liste_rouge r0_
WHERE
  r0_.id_categorie IN (
    'CR', 'EN', 'VU', 'NT', 'LC', 'DD', 'NA',
    'EX', 'RE', 'EW'
  )

SELECT r0_.id_categorie AS id_categorie_0, r0_.libelle AS libelle_1 FROM ipn_liste_rouge.ref_categorie_liste_rouge r0_ WHERE r0_.id_categorie IN ('CR', 'EN', 'VU', 'NT', 'LC', 'DD', 'NA', 'EX', 'RE', 'EW');

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3
FROM
  ipn_referentiel_taxo_v2.ref_statut_enjeu t0
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3 FROM ipn_referentiel_taxo_v2.ref_statut_enjeu t0 ORDER BY t0.id ASC;

SELECT
  t0.cd_type_statut AS cd_type_statut_1,
  t0.libelle AS libelle_2,
  t0.regroupement AS regroupement_3
FROM
  referentiels_inpn.bdc_types_statut t0
WHERE
  t0.cd_type_statut IN (?, ?)

SELECT t0.cd_type_statut AS cd_type_statut_1, t0.libelle AS libelle_2, t0.regroupement AS regroupement_3 FROM referentiels_inpn.bdc_types_statut t0 WHERE t0.cd_type_statut IN ('exPNA', 'PNA');

SELECT
  t0.pid AS pid_1,
  t0.credits AS credits_2,
  t0.description AS description_3,
  t0.nom_fichier AS nom_fichier_4,
  t0.photo_ref AS photo_ref_5,
  t0.date_creation AS date_creation_6,
  t0.date_revision AS date_revision_7,
  t0.cd_ref AS cd_ref_8,
  t0.id_numerisateur AS id_numerisateur_9,
  t0.id_licence AS id_licence_10,
  t0.id_statut AS id_statut_11,
  t0.gestionnaire AS gestionnaire_12
FROM
  ipn_photo.photo_taxon t0
WHERE
  t0.pid = ?

SELECT t0.pid AS pid_1, t0.credits AS credits_2, t0.description AS description_3, t0.nom_fichier AS nom_fichier_4, t0.photo_ref AS photo_ref_5, t0.date_creation AS date_creation_6, t0.date_revision AS date_revision_7, t0.cd_ref AS cd_ref_8, t0.id_numerisateur AS id_numerisateur_9, t0.id_licence AS id_licence_10, t0.id_statut AS id_statut_11, t0.gestionnaire AS gestionnaire_12 FROM ipn_photo.photo_taxon t0 WHERE t0.pid = 737;

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;