Symfony Profiler

SELECT
  Count(p0_.pid) AS sclr_0
FROM
  ipn_photo.photo_taxon p0_
  INNER JOIN ipn_photo.ref_statut r1_ ON p0_.id_statut = r1_.sid
  INNER JOIN ipn_taxonomie.vm_taxref_last v2_ ON p0_.cd_ref = v2_.cd_nom
  INNER JOIN ipn_photo.licences_cc l3_ ON p0_.id_licence = l3_.lid
  LEFT JOIN ipn_user.utilisateur u4_ ON p0_.gestionnaire = u4_.uid
WHERE
  p0_.id_licence <> 'Copyright'
  AND p0_.id_statut = 2

SELECT Count(p0_.pid) AS sclr_0 FROM ipn_photo.photo_taxon p0_ INNER JOIN ipn_photo.ref_statut r1_ ON p0_.id_statut = r1_.sid INNER JOIN ipn_taxonomie.vm_taxref_last v2_ ON p0_.cd_ref = v2_.cd_nom INNER JOIN ipn_photo.licences_cc l3_ ON p0_.id_licence = l3_.lid LEFT JOIN ipn_user.utilisateur u4_ ON p0_.gestionnaire = u4_.uid WHERE p0_.id_licence <> 'Copyright' AND p0_.id_statut = 2;

SELECT
  p0_.pid AS pid_0,
  p0_.credits AS credits_1,
  p0_.description AS description_2,
  p0_.nom_fichier AS nom_fichier_3,
  p0_.photo_ref AS photo_ref_4,
  p0_.date_creation AS date_creation_5,
  p0_.date_revision AS date_revision_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,
  l2_.lid AS lid_26,
  l2_.libelle AS libelle_27,
  l2_.url AS url_28,
  l2_.version AS version_29,
  l2_.licence_ouverte AS licence_ouverte_30,
  l2_.sort AS sort_31,
  u3_.uid AS uid_32,
  u3_.username AS username_33,
  u3_.password AS password_34,
  u3_.username_externe_inaturalist AS username_externe_inaturalist_35,
  u3_.id_externe_kollect AS id_externe_kollect_36,
  u3_.forgotpassword_key AS forgotpassword_key_37,
  u3_.token_suppression_compte AS token_suppression_compte_38,
  u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_39,
  u3_.mail AS mail_40,
  u3_.mail_transitoire AS mail_transitoire_41,
  u3_.prenom AS prenom_42,
  u3_.nom AS nom_43,
  u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_44,
  u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_45,
  u3_.creation_en_interne AS creation_en_interne_46,
  u3_.date_creation_compte AS date_creation_compte_47,
  u3_.date_suppression_compte AS date_suppression_compte_48,
  u3_.date_derniere_connexion AS date_derniere_connexion_49,
  u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_50,
  p0_.cd_ref AS cd_ref_51,
  p0_.id_numerisateur AS id_numerisateur_52,
  p0_.id_licence AS id_licence_53,
  p0_.id_statut AS id_statut_54,
  p0_.gestionnaire AS gestionnaire_55,
  v1_.cd_nom AS cd_nom_56,
  v1_.cd_nom AS cd_nom_57,
  v1_.cd_ref AS cd_ref_58,
  v1_.rang AS rang_59,
  v1_.habitat AS habitat_60,
  v1_.cd_nom AS cd_nom_61,
  v1_.cd_nom AS cd_nom_62,
  v1_.cd_nom AS cd_nom_63,
  v1_.cd_nom AS cd_nom_64,
  u3_.user_simulation AS user_simulation_65
FROM
  ipn_photo.photo_taxon p0_
  INNER JOIN ipn_photo.ref_statut r4_ ON p0_.id_statut = r4_.sid
  INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON p0_.cd_ref = v1_.cd_nom
  INNER JOIN ipn_photo.licences_cc l2_ ON p0_.id_licence = l2_.lid
  LEFT JOIN ipn_user.utilisateur u3_ ON p0_.gestionnaire = u3_.uid
WHERE
  p0_.id_licence <> 'Copyright'
  AND p0_.id_statut = 2
ORDER BY
  p0_.date_creation DESC
LIMIT
  14

SELECT p0_.pid AS pid_0, p0_.credits AS credits_1, p0_.description AS description_2, p0_.nom_fichier AS nom_fichier_3, p0_.photo_ref AS photo_ref_4, p0_.date_creation AS date_creation_5, p0_.date_revision AS date_revision_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, l2_.lid AS lid_26, l2_.libelle AS libelle_27, l2_.url AS url_28, l2_.version AS version_29, l2_.licence_ouverte AS licence_ouverte_30, l2_.sort AS sort_31, u3_.uid AS uid_32, u3_.username AS username_33, u3_.password AS password_34, u3_.username_externe_inaturalist AS username_externe_inaturalist_35, u3_.id_externe_kollect AS id_externe_kollect_36, u3_.forgotpassword_key AS forgotpassword_key_37, u3_.token_suppression_compte AS token_suppression_compte_38, u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_39, u3_.mail AS mail_40, u3_.mail_transitoire AS mail_transitoire_41, u3_.prenom AS prenom_42, u3_.nom AS nom_43, u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_44, u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_45, u3_.creation_en_interne AS creation_en_interne_46, u3_.date_creation_compte AS date_creation_compte_47, u3_.date_suppression_compte AS date_suppression_compte_48, u3_.date_derniere_connexion AS date_derniere_connexion_49, u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_50, p0_.cd_ref AS cd_ref_51, p0_.id_numerisateur AS id_numerisateur_52, p0_.id_licence AS id_licence_53, p0_.id_statut AS id_statut_54, p0_.gestionnaire AS gestionnaire_55, v1_.cd_nom AS cd_nom_56, v1_.cd_nom AS cd_nom_57, v1_.cd_ref AS cd_ref_58, v1_.rang AS rang_59, v1_.habitat AS habitat_60, v1_.cd_nom AS cd_nom_61, v1_.cd_nom AS cd_nom_62, v1_.cd_nom AS cd_nom_63, v1_.cd_nom AS cd_nom_64, u3_.user_simulation AS user_simulation_65 FROM ipn_photo.photo_taxon p0_ INNER JOIN ipn_photo.ref_statut r4_ ON p0_.id_statut = r4_.sid INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON p0_.cd_ref = v1_.cd_nom INNER JOIN ipn_photo.licences_cc l2_ ON p0_.id_licence = l2_.lid LEFT JOIN ipn_user.utilisateur u3_ ON p0_.gestionnaire = u3_.uid WHERE p0_.id_licence <> 'Copyright' AND p0_.id_statut = 2 ORDER BY p0_.date_creation DESC LIMIT 14;

SELECT
  t0.id_combinaison AS id_combinaison_1,
  t0.combinaison AS combinaison_2,
  t0.uid AS uid_3
FROM
  ipn_requeteur_v3.sommaire_droits_validation t0
WHERE
  t0.uid = ?

SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = 14;

SELECT
  t0.id_combinaison AS id_combinaison_1,
  t0.combinaison AS combinaison_2,
  t0.uid AS uid_3
FROM
  ipn_requeteur_v3.sommaire_droits_validation t0
WHERE
  t0.uid = ?

SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = 1263;

SELECT
  t0.id_combinaison AS id_combinaison_1,
  t0.combinaison AS combinaison_2,
  t0.uid AS uid_3
FROM
  ipn_requeteur_v3.sommaire_droits_validation t0
WHERE
  t0.uid = ?

SELECT t0.id_combinaison AS id_combinaison_1, t0.combinaison AS combinaison_2, t0.uid AS uid_3 FROM ipn_requeteur_v3.sommaire_droits_validation t0 WHERE t0.uid = 26;

SELECT
  Count(p0_.pid) AS sclr_0
FROM
  ipn_photo.photo_taxon p0_
WHERE
  p0_.id_statut = 2
  AND p0_.id_licence <> 'Copyright'

SELECT Count(p0_.pid) AS sclr_0 FROM ipn_photo.photo_taxon p0_ WHERE p0_.id_statut = 2 AND p0_.id_licence <> 'Copyright';

SELECT
  Count(DISTINCT p0_.gestionnaire) AS sclr_0
FROM
  ipn_photo.photo_taxon p0_

SELECT Count(DISTINCT p0_.gestionnaire) AS sclr_0 FROM ipn_photo.photo_taxon p0_;

SELECT
  Count(DISTINCT v0_.cd_espece) AS sclr_0
FROM
  ipn_photo.photo_taxon p1_
  INNER JOIN ipn_taxonomie.vm_taxref_last v0_ ON p1_.cd_ref = v0_.cd_nom

SELECT Count(DISTINCT v0_.cd_espece) AS sclr_0 FROM ipn_photo.photo_taxon p1_ INNER JOIN ipn_taxonomie.vm_taxref_last v0_ ON p1_.cd_ref = v0_.cd_nom;

with
  etape1 as (
    select
      count(pt) as nb,
      unnest(tax.groupes_usuels) as id_groupe
    from
      ipn_photo.photo_taxon pt
      join ipn_taxonomie.vm_taxref_last tax on pt.cd_ref = tax.cd_nom
    where
      id_statut = 2
    group by
      tax.groupes_usuels
  )
select
  sum(nb) as nb,
  g.libelle_item
from
  etape1
  join ipn_taxonomie.groupes_usuels g on g.gid = etape1.id_groupe
where
  etape1.id_groupe in (
    5, 12, 33, 23, 29, 38, 40, 85, 89, 91, 81,
    90, 92
  )
group by
  g.libelle_item
order by
  nb DESC

with etape1 as (
				select 
					count(pt) as nb,
					unnest(tax.groupes_usuels) as id_groupe
				from ipn_photo.photo_taxon pt
				join ipn_taxonomie.vm_taxref_last tax on pt.cd_ref = tax.cd_nom
				where id_statut = 2
				group by tax.groupes_usuels
			)
			select 
				sum(nb) as nb,
				g.libelle_item
			from etape1
			join ipn_taxonomie.groupes_usuels g on g.gid = etape1.id_groupe
			where etape1.id_groupe in (5,12,33,23,29,38,40,85,89,91,81,90,92)
			group by g.libelle_item
			order by nb DESC
		;

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.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.lid AS lid_1,
  t0.libelle AS libelle_2,
  t0.url AS url_3,
  t0.version AS version_4,
  t0.licence_ouverte AS licence_ouverte_5,
  t0.sort AS sort_6
FROM
  ipn_photo.licences_cc t0
WHERE
  t0.lid IN (?, ?, ?, ?)
ORDER BY
  t0.sort ASC

SELECT t0.lid AS lid_1, t0.libelle AS libelle_2, t0.url AS url_3, t0.version AS version_4, t0.licence_ouverte AS licence_ouverte_5, t0.sort AS sort_6 FROM ipn_photo.licences_cc t0 WHERE t0.lid IN ('BY-NC-SA', 'BY', 'BY-NC', 'BY-SA') ORDER BY t0.sort ASC;

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 = 554;

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;