Symfony Profiler

SELECT
  Count(o.oid) as nb_obs,
  extract(
    'year'
    from
      greatest(r_date_min, r_date_max)
  ) as annee_obs_max
FROM
  ipn_requeteur_v3.temp_303506 op
  JOIN ipn_requeteur_v3.observations o ON o.oid = op.oid
  JOIN ipn_requeteur_v3.releves r ON r.rid = o.id_releve
GROUP BY
  annee_obs_max
ORDER BY
  annee_obs_max ASC

SELECT
					Count(o.oid) as nb_obs,
					extract('year' from greatest(r_date_min,r_date_max)) as annee_obs_max
				FROM ipn_requeteur_v3.temp_303506 op
				JOIN ipn_requeteur_v3.observations o ON o.oid = op.oid
				JOIN ipn_requeteur_v3.releves r ON r.rid = o.id_releve
				GROUP BY
					annee_obs_max
				ORDER BY 
					annee_obs_max ASC
			;

SELECT
  Count(op.oid) as nb_obs,
  Count(distinct o.cd_espece) as nb_espece,
  CASE WHEN gpe.libelle_item IS NOT NULL THEN
    gpe.libelle_item
  ELSE
    'Autres'
  END AS groupe_libelle,
  CASE WHEN gpe.gid IS NOT NULL THEN
    gpe.gid
  ELSE
    107
  END AS groupe_id
FROM
  ipn_requeteur_v3.temp_303506 op
  JOIN ipn_requeteur_v3.observations o ON o.oid = op.oid
  LEFT JOIN ipn_taxonomie.groupes_usuels gpe ON ARRAY[gpe.gid] && groupes_usuels
  AND (
    gpe.ref_exhaustif = TRUE
    OR gpe.ref_exhaustif_terre = TRUE
    OR gpe.ref_exhaustif_mer = TRUE
  )
  AND gpe.gid != 89
GROUP BY
  gpe.libelle_item,
  gpe.gid

SELECT
					Count(op.oid) as nb_obs,
					Count(distinct o.cd_espece) as nb_espece,
					CASE WHEN gpe.libelle_item IS NOT NULL THEN gpe.libelle_item ELSE 'Autres' END AS groupe_libelle,
					CASE WHEN gpe.gid IS NOT NULL THEN gpe.gid ELSE 107 END AS groupe_id
				FROM ipn_requeteur_v3.temp_303506 op
				JOIN ipn_requeteur_v3.observations o ON o.oid = op.oid
				LEFT JOIN ipn_taxonomie.groupes_usuels gpe ON
					ARRAY[gpe.gid] && groupes_usuels
					AND (gpe.ref_exhaustif = TRUE OR gpe.ref_exhaustif_terre = TRUE OR gpe.ref_exhaustif_mer = TRUE)
					AND gpe.gid != 89
				GROUP BY
					gpe.libelle_item,
					gpe.gid
			;

SELECT
  t0.id_jdd AS id_jdd_1,
  t0.uuid AS uuid_2,
  t0.nom_complet AS nom_complet_3,
  t0.nom_usuel AS nom_usuel_4,
  t0.resume AS resume_5,
  t0.type_localisation AS type_localisation_6,
  t0.commentaire_regional AS commentaire_regional_7,
  t0.date_creation AS date_creation_8,
  t0.date_revision AS date_revision_9,
  t0.envoi_inpn AS envoi_inpn_10,
  t0.autorise_transmission AS autorise_transmission_11,
  t0.blocage_diffusion AS blocage_diffusion_12,
  t0.date_mise_en_circulation AS date_mise_en_circulation_13,
  t0.motif_blocage_diffusion AS motif_blocage_diffusion_14,
  t0.bypass_habilite_region AS bypass_habilite_region_15,
  t0.date_envoi_inpn AS date_envoi_inpn_16,
  t0.infos_supp_ds AS infos_supp_ds_17,
  t0.ouverture_publique AS ouverture_publique_18,
  t0.date_fin_enquete_participative AS date_fin_enquete_participative_19,
  t0.photo AS photo_20,
  t0.enquete_privee AS enquete_privee_21,
  t0.cle_mobile AS cle_mobile_22,
  t0.cle_web AS cle_web_23,
  t0.id_jdd_valide AS id_jdd_valide_24,
  t0.id_ca AS id_ca_25,
  t0.organisme_gestionnaire AS organisme_gestionnaire_26,
  t27.orgid AS orgid_28,
  t27.libelle_court AS libelle_court_29,
  t27.libelle_long AS libelle_long_30,
  t27.logo AS logo_31,
  t27.clef_modif AS clef_modif_32,
  t27.adherent_sinp AS adherent_sinp_33,
  t27.gestion_autonome_habilitation AS gestion_autonome_habilitation_34,
  t27.date_creation AS date_creation_35,
  t27.habilite_region AS habilite_region_36,
  t27.id_numerisateur AS id_numerisateur_37,
  t27.id_type AS id_type_38,
  t27.id_type_friendly AS id_type_friendly_39,
  t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_40,
  t41.uid AS uid_42,
  t41.username AS username_43,
  t41.password AS password_44,
  t41.username_externe_inaturalist AS username_externe_inaturalist_45,
  t41.id_externe_kollect AS id_externe_kollect_46,
  t41.forgotpassword_key AS forgotpassword_key_47,
  t41.token_suppression_compte AS token_suppression_compte_48,
  t41.mail_transitoire_code_verif AS mail_transitoire_code_verif_49,
  t41.mail AS mail_50,
  t41.mail_transitoire AS mail_transitoire_51,
  t41.prenom AS prenom_52,
  t41.nom AS nom_53,
  t41.utilisation_perso_newsletter AS utilisation_perso_newsletter_54,
  t41.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_55,
  t41.creation_en_interne AS creation_en_interne_56,
  t41.date_creation_compte AS date_creation_compte_57,
  t41.date_suppression_compte AS date_suppression_compte_58,
  t41.date_derniere_connexion AS date_derniere_connexion_59,
  t41.utilisation_perso_commentaire AS utilisation_perso_commentaire_60,
  t41.user_simulation AS user_simulation_61,
  t0.id_numerisateur AS id_numerisateur_62,
  t0.id_statut_metadonnee AS id_statut_metadonnee_63,
  t0.id_processus_collecte AS id_processus_collecte_64,
  t0.id_ds_publique_prive AS id_ds_publique_prive_65,
  t0.id_floutage_prod AS id_floutage_prod_66,
  t0.type_donnees AS type_donnees_67,
  t0.id_diffusion AS id_diffusion_68,
  t0.id_bdd AS id_bdd_69,
  t70.id AS id_71,
  t70.nb_obs AS nb_obs_72,
  t70.nb_obs_presence AS nb_obs_presence_73,
  t70.date_max AS date_max_74,
  t70.envelope_geojson AS envelope_geojson_75,
  t70.date_derniere_creation_donnee AS date_derniere_creation_donnee_76,
  t70.date_derniere_modif_donnee AS date_derniere_modif_donnee_77,
  t70.id_jdd AS id_jdd_78,
  t79.id AS id_80,
  t79.nb_obs AS nb_obs_81,
  t79.nb_obs_presence AS nb_obs_presence_82,
  t79.date_max AS date_max_83,
  t79.envelope_geojson AS envelope_geojson_84,
  t79.id_jdd AS id_jdd_85,
  t0.id_jdd_parent AS id_jdd_parent_86,
  t0.format_donnees AS format_donnees_87,
  t0.format_donnees_mobile AS format_donnees_mobile_88
FROM
  ipn_catalogue_connaissance_2017.jdd t0
  INNER JOIN ipn_user.organisme t27 ON t0.organisme_gestionnaire = t27.orgid
  LEFT JOIN ipn_user.utilisateur t41 ON t0.utilisateur_gestionnaire = t41.uid
  LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t70 ON t70.id_jdd = t0.id_jdd
  LEFT JOIN ipn_descripteurs_general_v2.jdd t79 ON t79.id_jdd = t0.id_jdd
WHERE
  t0.id_jdd = ?

SELECT t0.id_jdd AS id_jdd_1, t0.uuid AS uuid_2, t0.nom_complet AS nom_complet_3, t0.nom_usuel AS nom_usuel_4, t0.resume AS resume_5, t0.type_localisation AS type_localisation_6, t0.commentaire_regional AS commentaire_regional_7, t0.date_creation AS date_creation_8, t0.date_revision AS date_revision_9, t0.envoi_inpn AS envoi_inpn_10, t0.autorise_transmission AS autorise_transmission_11, t0.blocage_diffusion AS blocage_diffusion_12, t0.date_mise_en_circulation AS date_mise_en_circulation_13, t0.motif_blocage_diffusion AS motif_blocage_diffusion_14, t0.bypass_habilite_region AS bypass_habilite_region_15, t0.date_envoi_inpn AS date_envoi_inpn_16, t0.infos_supp_ds AS infos_supp_ds_17, t0.ouverture_publique AS ouverture_publique_18, t0.date_fin_enquete_participative AS date_fin_enquete_participative_19, t0.photo AS photo_20, t0.enquete_privee AS enquete_privee_21, t0.cle_mobile AS cle_mobile_22, t0.cle_web AS cle_web_23, t0.id_jdd_valide AS id_jdd_valide_24, t0.id_ca AS id_ca_25, t0.organisme_gestionnaire AS organisme_gestionnaire_26, t27.orgid AS orgid_28, t27.libelle_court AS libelle_court_29, t27.libelle_long AS libelle_long_30, t27.logo AS logo_31, t27.clef_modif AS clef_modif_32, t27.adherent_sinp AS adherent_sinp_33, t27.gestion_autonome_habilitation AS gestion_autonome_habilitation_34, t27.date_creation AS date_creation_35, t27.habilite_region AS habilite_region_36, t27.id_numerisateur AS id_numerisateur_37, t27.id_type AS id_type_38, t27.id_type_friendly AS id_type_friendly_39, t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_40, t41.uid AS uid_42, t41.username AS username_43, t41.password AS password_44, t41.username_externe_inaturalist AS username_externe_inaturalist_45, t41.id_externe_kollect AS id_externe_kollect_46, t41.forgotpassword_key AS forgotpassword_key_47, t41.token_suppression_compte AS token_suppression_compte_48, t41.mail_transitoire_code_verif AS mail_transitoire_code_verif_49, t41.mail AS mail_50, t41.mail_transitoire AS mail_transitoire_51, t41.prenom AS prenom_52, t41.nom AS nom_53, t41.utilisation_perso_newsletter AS utilisation_perso_newsletter_54, t41.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_55, t41.creation_en_interne AS creation_en_interne_56, t41.date_creation_compte AS date_creation_compte_57, t41.date_suppression_compte AS date_suppression_compte_58, t41.date_derniere_connexion AS date_derniere_connexion_59, t41.utilisation_perso_commentaire AS utilisation_perso_commentaire_60, t41.user_simulation AS user_simulation_61, t0.id_numerisateur AS id_numerisateur_62, t0.id_statut_metadonnee AS id_statut_metadonnee_63, t0.id_processus_collecte AS id_processus_collecte_64, t0.id_ds_publique_prive AS id_ds_publique_prive_65, t0.id_floutage_prod AS id_floutage_prod_66, t0.type_donnees AS type_donnees_67, t0.id_diffusion AS id_diffusion_68, t0.id_bdd AS id_bdd_69, t70.id AS id_71, t70.nb_obs AS nb_obs_72, t70.nb_obs_presence AS nb_obs_presence_73, t70.date_max AS date_max_74, t70.envelope_geojson AS envelope_geojson_75, t70.date_derniere_creation_donnee AS date_derniere_creation_donnee_76, t70.date_derniere_modif_donnee AS date_derniere_modif_donnee_77, t70.id_jdd AS id_jdd_78, t79.id AS id_80, t79.nb_obs AS nb_obs_81, t79.nb_obs_presence AS nb_obs_presence_82, t79.date_max AS date_max_83, t79.envelope_geojson AS envelope_geojson_84, t79.id_jdd AS id_jdd_85, t0.id_jdd_parent AS id_jdd_parent_86, t0.format_donnees AS format_donnees_87, t0.format_donnees_mobile AS format_donnees_mobile_88 FROM ipn_catalogue_connaissance_2017.jdd t0 INNER JOIN ipn_user.organisme t27 ON t0.organisme_gestionnaire = t27.orgid LEFT JOIN ipn_user.utilisateur t41 ON t0.utilisateur_gestionnaire = t41.uid LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t70 ON t70.id_jdd = t0.id_jdd LEFT JOIN ipn_descripteurs_general_v2.jdd t79 ON t79.id_jdd = t0.id_jdd WHERE t0.id_jdd = 15576;

SELECT
  t0.pid AS pid_1,
  t0.libelle AS libelle_2,
  t0.libelle_court AS libelle_court_3,
  t0.resume AS resume_4,
  t0.ressources AS ressources_5,
  t0.donnees_interrogees AS donnees_interrogees_6,
  t0.image_banniere AS image_banniere_7,
  t0.requete_donnees AS requete_donnees_8,
  t0.params AS params_9,
  t0.libelle_uri AS libelle_uri_10,
  t0.titre_logo AS titre_logo_11,
  t0.menu_logo AS menu_logo_12,
  t0.ouverture_public AS ouverture_public_13,
  t0.the_geom AS the_geom_14,
  t0.nb_jours_maj_continu AS nb_jours_maj_continu_15,
  t0.type_projet AS type_projet_16,
  t0.id_jdd AS id_jdd_17,
  t0.type_maj_donnees AS type_maj_donnees_18
FROM
  ipn_projet.projet t0
WHERE
  t0.libelle_uri = ?
LIMIT
  1

SELECT t0.pid AS pid_1, t0.libelle AS libelle_2, t0.libelle_court AS libelle_court_3, t0.resume AS resume_4, t0.ressources AS ressources_5, t0.donnees_interrogees AS donnees_interrogees_6, t0.image_banniere AS image_banniere_7, t0.requete_donnees AS requete_donnees_8, t0.params AS params_9, t0.libelle_uri AS libelle_uri_10, t0.titre_logo AS titre_logo_11, t0.menu_logo AS menu_logo_12, t0.ouverture_public AS ouverture_public_13, t0.the_geom AS the_geom_14, t0.nb_jours_maj_continu AS nb_jours_maj_continu_15, t0.type_projet AS type_projet_16, t0.id_jdd AS id_jdd_17, t0.type_maj_donnees AS type_maj_donnees_18 FROM ipn_projet.projet t0 WHERE t0.libelle_uri = 'animo64' LIMIT 1;

SELECT
  t0.rid AS rid_1,
  t0.requete AS requete_2,
  t0.date_creation AS date_creation_3,
  t0.nombre_acces AS nombre_acces_4,
  t0.active AS active_5
FROM
  ipn_requeteur_v3.sommaire t0
WHERE
  t0.requete = ?
LIMIT
  1

SELECT t0.rid AS rid_1, t0.requete AS requete_2, t0.date_creation AS date_creation_3, t0.nombre_acces AS nombre_acces_4, t0.active AS active_5 FROM ipn_requeteur_v3.sommaire t0 WHERE t0.requete = '{\"echelleRestitution\":\"precis\",\"profilUtilisateur\":\"organismeHabiliteRegion\",\"inclureObsChevalDateMax\":false,\"projetID\":16,\"projetVersionID\":810,\"acteursTestCumul\":\"AND \",\"geomTestCumul\":\"and\",\"statutEspeceMode\":\"or\"}' LIMIT 1;

SELECT
  count(*) AS nbobs
FROM
  ipn_requeteur_v3.temp_303506;

SELECT count(*) AS nbobs FROM ipn_requeteur_v3.temp_303506;;

SELECT
  t0.id AS id_1,
  t0.date_lancement AS date_lancement_2,
  t0.libelle AS libelle_3,
  t0.pid AS pid_4
FROM
  ipn_projet.versions t0
WHERE
  t0.pid = ?

SELECT t0.id AS id_1, t0.date_lancement AS date_lancement_2, t0.libelle AS libelle_3, t0.pid AS pid_4 FROM ipn_projet.versions t0 WHERE t0.pid = 16;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.nom_fichier_twig AS nom_fichier_twig_3,
  t0.description AS description_4,
  t0.info AS info_5
FROM
  ipn_indicateurs_en_direct.ref_indicateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom_fichier_twig AS nom_fichier_twig_3, t0.description AS description_4, t0.info AS info_5 FROM ipn_indicateurs_en_direct.ref_indicateur t0 WHERE t0.id = 6;

select
  COUNT(oid) as nb_obs
from
  ipn_requeteur_v3.temp_303506

select
				COUNT(oid) as nb_obs
			from ipn_requeteur_v3.temp_303506;

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 = 2
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 = 2 ORDER BY f1_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.date_lancement AS date_lancement_2,
  t0.libelle AS libelle_3,
  t0.pid AS pid_4
FROM
  ipn_projet.versions t0
WHERE
  t0.pid = ?
ORDER BY
  t0.date_lancement DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.date_lancement AS date_lancement_2, t0.libelle AS libelle_3, t0.pid AS pid_4 FROM ipn_projet.versions t0 WHERE t0.pid = 16 ORDER BY t0.date_lancement DESC LIMIT 1;

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.orgid AS orgid_1,
  t0.nb_obs AS nb_obs_2,
  t0.national AS national_3,
  t0.regional AS regional_4,
  t0.orgid AS orgid_5
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t0
WHERE
  t0.orgid = ?

SELECT t0.orgid AS orgid_1, t0.nb_obs AS nb_obs_2, t0.national AS national_3, t0.regional AS regional_4, t0.orgid AS orgid_5 FROM ipn_descripteurs_occurrence_sinp_valide_v2.contributeurs t0 WHERE t0.orgid = 32;

SELECT
  t0.sid AS sid_1,
  t0.surcharge_libelle AS surcharge_libelle_2,
  t0.highcharts_params AS highcharts_params_3,
  t0.localisation AS localisation_4,
  t0.pid AS pid_5,
  t0.iid AS iid_6
FROM
  ipn_projet.corr_projet_indicateur_en_direct t0
WHERE
  t0.pid = ?

SELECT t0.sid AS sid_1, t0.surcharge_libelle AS surcharge_libelle_2, t0.highcharts_params AS highcharts_params_3, t0.localisation AS localisation_4, t0.pid AS pid_5, t0.iid AS iid_6 FROM ipn_projet.corr_projet_indicateur_en_direct t0 WHERE t0.pid = 16;

UPDATE
  ipn_requeteur_v3.sommaire
SET
  nombre_acces = ?
WHERE
  rid = ?

UPDATE ipn_requeteur_v3.sommaire SET nombre_acces = 2 WHERE rid = 303506;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";