Symfony Profiler

SELECT
  a0_.aid AS aid_0,
  a0_.libelle AS libelle_1,
  a0_.resume AS resume_2,
  a0_.contenu AS contenu_3,
  a0_.photo_specifique AS photo_specifique_4,
  a0_.publie AS publie_5,
  a0_.date_publication AS date_publication_6,
  a0_.date_maj AS date_maj_7,
  r1_.id AS id_8,
  r1_.libelle AS libelle_9,
  p2_.pid AS pid_10,
  p2_.credits AS credits_11,
  p2_.description AS description_12,
  p2_.nom_fichier AS nom_fichier_13,
  p2_.photo_ref AS photo_ref_14,
  p2_.date_creation AS date_creation_15,
  p2_.date_revision AS date_revision_16,
  l3_.lid AS lid_17,
  l3_.libelle AS libelle_18,
  l3_.url AS url_19,
  l3_.version AS version_20,
  l3_.licence_ouverte AS licence_ouverte_21,
  l3_.sort AS sort_22,
  a0_.photo_espece AS photo_espece_23,
  a0_.id_numerisateur AS id_numerisateur_24,
  p2_.cd_ref AS cd_ref_25,
  p2_.id_numerisateur AS id_numerisateur_26,
  p2_.id_licence AS id_licence_27,
  p2_.id_statut AS id_statut_28,
  p2_.gestionnaire AS gestionnaire_29
FROM
  ipn_actualites.actualites a0_
  LEFT JOIN ipn_actualites.corr_actualite_theme i4_ ON a0_.aid = i4_.aid
  LEFT JOIN ipn_actualites.ref_theme r1_ ON r1_.id = i4_.tid
  LEFT JOIN ipn_photo.photo_taxon p2_ ON a0_.photo_espece = p2_.pid
  LEFT JOIN ipn_photo.licences_cc l3_ ON p2_.id_licence = l3_.lid
WHERE
  a0_.publie = true
ORDER BY
  a0_.date_publication DESC

SELECT a0_.aid AS aid_0, a0_.libelle AS libelle_1, a0_.resume AS resume_2, a0_.contenu AS contenu_3, a0_.photo_specifique AS photo_specifique_4, a0_.publie AS publie_5, a0_.date_publication AS date_publication_6, a0_.date_maj AS date_maj_7, r1_.id AS id_8, r1_.libelle AS libelle_9, p2_.pid AS pid_10, p2_.credits AS credits_11, p2_.description AS description_12, p2_.nom_fichier AS nom_fichier_13, p2_.photo_ref AS photo_ref_14, p2_.date_creation AS date_creation_15, p2_.date_revision AS date_revision_16, l3_.lid AS lid_17, l3_.libelle AS libelle_18, l3_.url AS url_19, l3_.version AS version_20, l3_.licence_ouverte AS licence_ouverte_21, l3_.sort AS sort_22, a0_.photo_espece AS photo_espece_23, a0_.id_numerisateur AS id_numerisateur_24, p2_.cd_ref AS cd_ref_25, p2_.id_numerisateur AS id_numerisateur_26, p2_.id_licence AS id_licence_27, p2_.id_statut AS id_statut_28, p2_.gestionnaire AS gestionnaire_29 FROM ipn_actualites.actualites a0_ LEFT JOIN ipn_actualites.corr_actualite_theme i4_ ON a0_.aid = i4_.aid LEFT JOIN ipn_actualites.ref_theme r1_ ON r1_.id = i4_.tid LEFT JOIN ipn_photo.photo_taxon p2_ ON a0_.photo_espece = p2_.pid LEFT JOIN ipn_photo.licences_cc l3_ ON p2_.id_licence = l3_.lid WHERE a0_.publie = true ORDER BY a0_.date_publication DESC;

SELECT
  RANDOM() AS sclr_0,
  v0_.cd_nom AS cd_nom_1,
  v0_.cd_ref AS cd_ref_2,
  v0_.lb_nom AS lb_nom_3,
  v0_.lb_auteur AS lb_auteur_4,
  v0_.nom_vern AS nom_vern_5,
  v0_.premier_nom_vern AS premier_nom_vern_6,
  v0_.nom_valide AS nom_valide_7,
  v0_.rang AS rang_8,
  v0_.embranchement AS embranchement_9,
  v0_.classe AS classe_10,
  v0_.ordre AS ordre_11,
  v0_.famille AS famille_12,
  v0_.version AS version_13,
  v0_.presence_metropole AS presence_metropole_14,
  v0_.icone AS icone_15,
  v0_.cd_espece AS cd_espece_16,
  v0_.taxons_superieurs AS taxons_superieurs_17,
  v0_.groupes_usuels AS groupes_usuels_18,
  v0_.groupes_fonctionnels AS groupes_fonctionnels_19,
  r1_.cd_ref AS cd_ref_20,
  r1_.comparaison_autocompletion AS comparaison_autocompletion_21,
  r1_.est_menace AS est_menace_22,
  r1_.est_protege AS est_protege_23,
  r1_.est_exotique AS est_exotique_24,
  r1_.meilleure_photo_disponible AS meilleure_photo_disponible_25,
  r1_.extension_imagine_filter AS extension_imagine_filter_26,
  r1_.credits AS credits_27,
  r1_.licence AS licence_28,
  r1_.licence_url AS licence_url_29,
  r1_.licence_libelle AS licence_libelle_30,
  r1_.licence_version AS licence_version_31,
  r1_.icone AS icone_32,
  r1_.fiche_descriptive AS fiche_descriptive_33,
  r1_.fiche_descriptive_source AS fiche_descriptive_source_34,
  r1_.nb_obs AS nb_obs_35,
  c2_.id AS id_36,
  c2_.cd_ref AS cd_ref_37,
  c2_.deb_possible AS deb_possible_38,
  c2_.deb_sur AS deb_sur_39,
  c2_.fin_sur AS fin_sur_40,
  c2_.fin_possible AS fin_possible_41,
  v0_.cd_nom AS cd_nom_42,
  v0_.cd_nom AS cd_nom_43,
  v0_.cd_ref AS cd_ref_44,
  v0_.rang AS rang_45,
  v0_.habitat AS habitat_46,
  v0_.cd_nom AS cd_nom_47,
  v0_.cd_nom AS cd_nom_48,
  v0_.cd_nom AS cd_nom_49,
  v0_.cd_nom AS cd_nom_50,
  c2_.cd_ref AS cd_ref_51,
  c2_.ref_stade AS ref_stade_52
FROM
  ipn_taxonomie.vm_taxref_last v0_
  INNER JOIN ipn_requeteur_v3.referentiel_espece r1_ ON v0_.cd_nom = r1_.cd_ref
  INNER JOIN ipn_validation.corr_pheno c2_ ON v0_.cd_nom = c2_.cd_ref
WHERE
  c2_.ref_stade IS NULL
  AND (
    (
      c2_.deb_sur < c2_.fin_sur
      AND c2_.deb_sur <= 45
      AND c2_.fin_sur >= 45
    )
    OR (
      c2_.deb_sur > c2_.fin_sur
      AND (
        c2_.deb_sur <= 45
        OR c2_.fin_sur >= 45
      )
    )
  )
  AND r1_.meilleure_photo_disponible IS NOT NULL
ORDER BY
  sclr_0 ASC,
  c2_.id ASC
LIMIT
  10

SELECT RANDOM() AS sclr_0, v0_.cd_nom AS cd_nom_1, v0_.cd_ref AS cd_ref_2, v0_.lb_nom AS lb_nom_3, v0_.lb_auteur AS lb_auteur_4, v0_.nom_vern AS nom_vern_5, v0_.premier_nom_vern AS premier_nom_vern_6, v0_.nom_valide AS nom_valide_7, v0_.rang AS rang_8, v0_.embranchement AS embranchement_9, v0_.classe AS classe_10, v0_.ordre AS ordre_11, v0_.famille AS famille_12, v0_.version AS version_13, v0_.presence_metropole AS presence_metropole_14, v0_.icone AS icone_15, v0_.cd_espece AS cd_espece_16, v0_.taxons_superieurs AS taxons_superieurs_17, v0_.groupes_usuels AS groupes_usuels_18, v0_.groupes_fonctionnels AS groupes_fonctionnels_19, r1_.cd_ref AS cd_ref_20, r1_.comparaison_autocompletion AS comparaison_autocompletion_21, r1_.est_menace AS est_menace_22, r1_.est_protege AS est_protege_23, r1_.est_exotique AS est_exotique_24, r1_.meilleure_photo_disponible AS meilleure_photo_disponible_25, r1_.extension_imagine_filter AS extension_imagine_filter_26, r1_.credits AS credits_27, r1_.licence AS licence_28, r1_.licence_url AS licence_url_29, r1_.licence_libelle AS licence_libelle_30, r1_.licence_version AS licence_version_31, r1_.icone AS icone_32, r1_.fiche_descriptive AS fiche_descriptive_33, r1_.fiche_descriptive_source AS fiche_descriptive_source_34, r1_.nb_obs AS nb_obs_35, c2_.id AS id_36, c2_.cd_ref AS cd_ref_37, c2_.deb_possible AS deb_possible_38, c2_.deb_sur AS deb_sur_39, c2_.fin_sur AS fin_sur_40, c2_.fin_possible AS fin_possible_41, v0_.cd_nom AS cd_nom_42, v0_.cd_nom AS cd_nom_43, v0_.cd_ref AS cd_ref_44, v0_.rang AS rang_45, v0_.habitat AS habitat_46, v0_.cd_nom AS cd_nom_47, v0_.cd_nom AS cd_nom_48, v0_.cd_nom AS cd_nom_49, v0_.cd_nom AS cd_nom_50, c2_.cd_ref AS cd_ref_51, c2_.ref_stade AS ref_stade_52 FROM ipn_taxonomie.vm_taxref_last v0_ INNER JOIN ipn_requeteur_v3.referentiel_espece r1_ ON v0_.cd_nom = r1_.cd_ref INNER JOIN ipn_validation.corr_pheno c2_ ON v0_.cd_nom = c2_.cd_ref WHERE c2_.ref_stade IS NULL AND ((c2_.deb_sur < c2_.fin_sur AND c2_.deb_sur <= 45 AND c2_.fin_sur >= 45) OR (c2_.deb_sur > c2_.fin_sur AND (c2_.deb_sur <= 45 OR c2_.fin_sur >= 45))) AND r1_.meilleure_photo_disponible IS NOT NULL ORDER BY sclr_0 ASC, c2_.id ASC LIMIT 10;

SELECT
  t0.nb_obs AS nb_obs_1,
  t0.nb_communes AS nb_communes_2,
  t0.nb_maille5 AS nb_maille5_3,
  t0.nb_jdd AS nb_jdd_4,
  t0.nb_cadres AS nb_cadres_5,
  t0.nb_contributeurs_independants AS nb_contributeurs_independants_6,
  t0.nb_organismes_producteurs AS nb_organismes_producteurs_7,
  t0.nb_especes AS nb_especes_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.region t0
LIMIT
  1

SELECT t0.nb_obs AS nb_obs_1, t0.nb_communes AS nb_communes_2, t0.nb_maille5 AS nb_maille5_3, t0.nb_jdd AS nb_jdd_4, t0.nb_cadres AS nb_cadres_5, t0.nb_contributeurs_independants AS nb_contributeurs_independants_6, t0.nb_organismes_producteurs AS nb_organismes_producteurs_7, t0.nb_especes AS nb_especes_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.region t0 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;