Symfony Profiler

SELECT
  t0.code_dept AS code_dept_1,
  t0.the_geom AS the_geom_2,
  t0.nom_dept AS nom_dept_3,
  t0.code_region AS code_region_4,
  t0.regions AS regions_5
FROM
  ipn_carto.departement t0
WHERE
  t0.code_region = ?
ORDER BY
  t0.nom_dept ASC

SELECT t0.code_dept AS code_dept_1, t0.the_geom AS the_geom_2, t0.nom_dept AS nom_dept_3, t0.code_region AS code_region_4, t0.regions AS regions_5 FROM ipn_carto.departement t0 WHERE t0.code_region = '75' ORDER BY t0.nom_dept ASC;

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 IN (?)

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 IN ('78141');

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.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.id_statut AS id_statut_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3
FROM
  ipn_donnees.ref_statut_presence t0
WHERE
  t0.id_statut IN (?, ?)
ORDER BY
  t0.id_statut ASC

SELECT t0.id_statut AS id_statut_1, t0.libelle AS libelle_2, t0.description AS description_3 FROM ipn_donnees.ref_statut_presence t0 WHERE t0.id_statut IN (1, 2) ORDER BY t0.id_statut ASC;

SELECT
  t0.id_mnhn AS id_mnhn_1,
  t0.the_geom AS the_geom_2,
  t0.nom AS nom_3
FROM
  ipn_carto.pnr t0

SELECT t0.id_mnhn AS id_mnhn_1, t0.the_geom AS the_geom_2, t0.nom AS nom_3 FROM ipn_carto.pnr t0;

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;