Query Metrics
19
Database Queries
17
Different statements
100.01 ms
Query time
0
Invalid entities
27
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
43.23 ms (43.23%) |
1 |
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_324668 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
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
30.99 ms (30.99%) |
1 |
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_324668 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
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
8.10 ms (8.10%) |
2 |
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
Parameters:
[
"animo64"
]
|
||||||||||||||||||||||||||||||
|
7.08 ms (7.08%) |
1 |
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.commentaire_regional AS commentaire_regional_6, t0.date_creation AS date_creation_7, t0.date_revision AS date_revision_8, t0.envoi_inpn AS envoi_inpn_9, t0.autorise_transmission AS autorise_transmission_10, t0.blocage_diffusion AS blocage_diffusion_11, t0.date_mise_en_circulation AS date_mise_en_circulation_12, t0.motif_blocage_diffusion AS motif_blocage_diffusion_13, t0.date_envoi_inpn AS date_envoi_inpn_14, t0.infos_supp_ds AS infos_supp_ds_15, t0.ouverture_publique AS ouverture_publique_16, t0.date_fin_enquete_participative AS date_fin_enquete_participative_17, t0.photo AS photo_18, t0.enquete_privee AS enquete_privee_19, t0.cle_mobile AS cle_mobile_20, t0.cle_web AS cle_web_21, t0.id_jdd_valide AS id_jdd_valide_22, t0.id_ca AS id_ca_23, t0.organisme_gestionnaire AS organisme_gestionnaire_24, t25.orgid AS orgid_26, t25.libelle_court AS libelle_court_27, t25.libelle_long AS libelle_long_28, t25.logo AS logo_29, t25.clef_modif AS clef_modif_30, t25.adherent_sinp AS adherent_sinp_31, t25.gestion_autonome_habilitation AS gestion_autonome_habilitation_32, t25.date_creation AS date_creation_33, t25.habilite_region AS habilite_region_34, t25.id_numerisateur AS id_numerisateur_35, t25.id_type AS id_type_36, t25.id_type_friendly AS id_type_friendly_37, t0.utilisateur_gestionnaire AS utilisateur_gestionnaire_38, t39.uid AS uid_40, t39.username AS username_41, t39.password AS password_42, t39.username_externe_inaturalist AS username_externe_inaturalist_43, t39.id_externe_kollect AS id_externe_kollect_44, t39.forgotpassword_key AS forgotpassword_key_45, t39.token_suppression_compte AS token_suppression_compte_46, t39.mail_transitoire_code_verif AS mail_transitoire_code_verif_47, t39.mail AS mail_48, t39.mail_transitoire AS mail_transitoire_49, t39.prenom AS prenom_50, t39.nom AS nom_51, t39.utilisation_perso_newsletter AS utilisation_perso_newsletter_52, t39.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_53, t39.creation_en_interne AS creation_en_interne_54, t39.date_creation_compte AS date_creation_compte_55, t39.date_suppression_compte AS date_suppression_compte_56, t39.date_derniere_connexion AS date_derniere_connexion_57, t39.utilisation_perso_commentaire AS utilisation_perso_commentaire_58, t39.user_simulation AS user_simulation_59, t0.id_numerisateur AS id_numerisateur_60, t0.id_statut_metadonnee AS id_statut_metadonnee_61, t0.id_floutage_prod AS id_floutage_prod_62, t0.id_statut_origine_donnees AS id_statut_origine_donnees_63, t0.id_type_donnees AS id_type_donnees_64, t0.id_diffusion AS id_diffusion_65, t0.id_categorie_donnees AS id_categorie_donnees_66, t0.id_bdd AS id_bdd_67, t68.id AS id_69, t68.nb_obs AS nb_obs_70, t68.nb_obs_presence AS nb_obs_presence_71, t68.date_max AS date_max_72, t68.envelope_geojson AS envelope_geojson_73, t68.date_derniere_creation_donnee AS date_derniere_creation_donnee_74, t68.date_derniere_modif_donnee AS date_derniere_modif_donnee_75, t68.id_jdd AS id_jdd_76, t77.id AS id_78, t77.nb_obs AS nb_obs_79, t77.nb_obs_presence AS nb_obs_presence_80, t77.date_max AS date_max_81, t77.envelope_geojson AS envelope_geojson_82, t77.id_jdd AS id_jdd_83, t0.id_jdd_parent AS id_jdd_parent_84, t0.format_donnees AS format_donnees_85, t0.format_donnees_mobile AS format_donnees_mobile_86, t0.id_protocole_campanule AS id_protocole_campanule_87 FROM ipn_catalogue_connaissance_2017.jdd t0 INNER JOIN ipn_user.organisme t25 ON t0.organisme_gestionnaire = t25.orgid LEFT JOIN ipn_user.utilisateur t39 ON t0.utilisateur_gestionnaire = t39.uid LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd t68 ON t68.id_jdd = t0.id_jdd LEFT JOIN ipn_descripteurs_general_v2.jdd t77 ON t77.id_jdd = t0.id_jdd WHERE t0.id_jdd = ?
Parameters:
[
15576
]
|
||||||||||||||||||||||||||||||
|
1.13 ms (1.13%) |
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 = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||
|
1.10 ms (1.10%) |
2 |
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 = ?
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||
|
1.03 ms (1.03%) |
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
Parameters:
[
"{"echelleRestitution":"precis","profilUtilisateur":"organismeHabiliteRegion","inclureObsChevalDateMax":false,"projetID":16,"projetVersionID":1163,"acteursTestCumul":"AND ","geomTestCumul":"and","statutEspeceMode":"or"}"
]
|
||||||||||||||||||||||||||||||
|
1.03 ms (1.03%) |
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 = 2 ORDER BY f1_.ordre ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.99 ms (0.99%) |
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
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.93 ms (0.93%) |
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 = ? ORDER BY t0.date_lancement DESC LIMIT 1
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||
|
0.93 ms (0.93%) |
1 |
SELECT count(*) AS nbobs FROM ipn_requeteur_v3.temp_324668;
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.80 ms (0.80%) |
1 |
select COUNT(oid) as nb_obs from ipn_requeteur_v3.temp_324668
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.71 ms (0.71%) |
1 |
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 = ?
Parameters:
[
32
]
|
||||||||||||||||||||||||||||||
|
0.59 ms (0.59%) |
1 |
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 = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||
|
0.51 ms (0.51%) |
1 |
UPDATE ipn_requeteur_v3.sommaire SET nombre_acces = ? WHERE rid = ?
Parameters:
[ 5 324668 ]
|
||||||||||||||||||||||||||||||
|
0.47 ms (0.47%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.38 ms (0.37%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Projet\CorrProjetIndicateurEnDirect | 3 |
| App\Entity\Indicateurs\RealTime\Indicateur | 3 |
| App\Entity\User | 2 |
| App\Entity\Projet\Projet | 1 |
| App\Entity\JDD\JDD | 1 |
| App\Entity\Projet\RefTypeMajDonnees | 1 |
| App\Entity\Projet\Version | 1 |
| App\Entity\Donnees\SommaireRequetes | 1 |
| App\Entity\JDD\CadreAcquisition | 1 |
| App\Entity\JDD\StatutMetadonnee | 1 |
| App\Entity\JDD\FloutageProducteur | 1 |
| App\Entity\JDD\StatutOrigineDonnee | 1 |
| App\Entity\JDD\TypeDonnees | 1 |
| App\Entity\JDD\DiffusionJDD | 1 |
| App\Entity\JDD\CategorieDonnee | 1 |
| App\Entity\JDD\BaseDeDonnees | 1 |
| App\Entity\Donnees\FormatDonnees | 1 |
| App\Entity\Organisme | 1 |
| App\Entity\TypeOrganisme | 1 |
| App\Entity\TypeFriendlyOrganisme | 1 |
| App\Entity\JDD\VMSyntheseJDD | 1 |
| App\Entity\JDD\VMSyntheseJDDTotal | 1 |