Query Metrics
90
Database Queries
11
Different statements
111.46 ms
Query time
0
Invalid entities
397
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
47.25 ms (42.39%) |
27 |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_jdd AS id_jdd_6 FROM ipn_descripteurs_general_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
22774
]
|
||||||||||||||||||||||||||||
|
21.33 ms (19.14%) |
1 |
SELECT j0_.id_jdd AS id_jdd_0, j0_.uuid AS uuid_1, j0_.nom_complet AS nom_complet_2, j0_.nom_usuel AS nom_usuel_3, j0_.resume AS resume_4, j0_.commentaire_regional AS commentaire_regional_5, j0_.date_creation AS date_creation_6, j0_.date_revision AS date_revision_7, j0_.envoi_inpn AS envoi_inpn_8, j0_.autorise_transmission AS autorise_transmission_9, j0_.blocage_diffusion AS blocage_diffusion_10, j0_.date_mise_en_circulation AS date_mise_en_circulation_11, j0_.motif_blocage_diffusion AS motif_blocage_diffusion_12, j0_.date_envoi_inpn AS date_envoi_inpn_13, j0_.infos_supp_ds AS infos_supp_ds_14, j0_.ouverture_publique AS ouverture_publique_15, j0_.date_fin_enquete_participative AS date_fin_enquete_participative_16, j0_.photo AS photo_17, j0_.enquete_privee AS enquete_privee_18, j0_.cle_mobile AS cle_mobile_19, j0_.cle_web AS cle_web_20, j1_.id AS id_21, j1_.nb_obs AS nb_obs_22, j1_.nb_obs_presence AS nb_obs_presence_23, j1_.date_max AS date_max_24, j1_.envelope_geojson AS envelope_geojson_25, j1_.date_derniere_creation_donnee AS date_derniere_creation_donnee_26, j1_.date_derniere_modif_donnee AS date_derniere_modif_donnee_27, o2_.orgid AS orgid_28, o2_.libelle_court AS libelle_court_29, o2_.libelle_long AS libelle_long_30, o2_.logo AS logo_31, o2_.clef_modif AS clef_modif_32, o2_.adherent_sinp AS adherent_sinp_33, o2_.gestion_autonome_habilitation AS gestion_autonome_habilitation_34, o2_.date_creation AS date_creation_35, o2_.habilite_region AS habilite_region_36, u3_.uid AS uid_37, u3_.username AS username_38, u3_.password AS password_39, u3_.username_externe_inaturalist AS username_externe_inaturalist_40, u3_.id_externe_kollect AS id_externe_kollect_41, u3_.forgotpassword_key AS forgotpassword_key_42, u3_.token_suppression_compte AS token_suppression_compte_43, u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_44, u3_.mail AS mail_45, u3_.mail_transitoire AS mail_transitoire_46, u3_.prenom AS prenom_47, u3_.nom AS nom_48, u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_49, u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_50, u3_.creation_en_interne AS creation_en_interne_51, u3_.date_creation_compte AS date_creation_compte_52, u3_.date_suppression_compte AS date_suppression_compte_53, u3_.date_derniere_connexion AS date_derniere_connexion_54, u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_55, j4_.id_jdd_contact AS id_jdd_contact_56, j4_.nom_prenom_acteur AS nom_prenom_acteur_57, j4_.mail AS mail_58, o5_.orgid AS orgid_59, o5_.libelle_court AS libelle_court_60, o5_.libelle_long AS libelle_long_61, o5_.logo AS logo_62, o5_.clef_modif AS clef_modif_63, o5_.adherent_sinp AS adherent_sinp_64, o5_.gestion_autonome_habilitation AS gestion_autonome_habilitation_65, o5_.date_creation AS date_creation_66, o5_.habilite_region AS habilite_region_67, r6_.id_ref AS id_ref_68, r6_.id_sinp AS id_sinp_69, r6_.libelle AS libelle_70, r6_.description AS description_71, r6_.nom_machine AS nom_machine_72, c7_.id_ca AS id_ca_73, c7_.uuid AS uuid_74, c7_.nom_complet AS nom_complet_75, c7_.resume AS resume_76, c7_.commentaire_regional AS commentaire_regional_77, c7_.date_lancement AS date_lancement_78, c7_.date_cloture AS date_cloture_79, c7_.date_creation_metadonnee AS date_creation_metadonnee_80, c7_.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_81, c7_.date_envoi_inpn AS date_envoi_inpn_82, c7_.ouverture_publique AS ouverture_publique_83, j0_.id_jdd_valide AS id_jdd_valide_84, j0_.id_ca AS id_ca_85, j0_.organisme_gestionnaire AS organisme_gestionnaire_86, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_87, j0_.id_numerisateur AS id_numerisateur_88, j0_.id_statut_metadonnee AS id_statut_metadonnee_89, j0_.id_floutage_prod AS id_floutage_prod_90, j0_.id_statut_origine_donnees AS id_statut_origine_donnees_91, j0_.id_type_donnees AS id_type_donnees_92, j0_.id_diffusion AS id_diffusion_93, j0_.id_categorie_donnees AS id_categorie_donnees_94, j0_.id_bdd AS id_bdd_95, j0_.id_jdd_parent AS id_jdd_parent_96, j0_.format_donnees AS format_donnees_97, j0_.format_donnees_mobile AS format_donnees_mobile_98, j0_.id_protocole_campanule AS id_protocole_campanule_99, j1_.id_jdd AS id_jdd_100, o2_.id_numerisateur AS id_numerisateur_101, o2_.id_type AS id_type_102, o2_.id_type_friendly AS id_type_friendly_103, u3_.user_simulation AS user_simulation_104, j4_.id_jdd AS id_jdd_105, j4_.role_acteur AS role_acteur_106, j4_.organisme AS organisme_107, o5_.id_numerisateur AS id_numerisateur_108, o5_.id_type AS id_type_109, o5_.id_type_friendly AS id_type_friendly_110, c7_.id_ca_valide AS id_ca_valide_111, c7_.echelle_territoriale AS echelle_territoriale_112, c7_.id_numerisateur AS id_numerisateur_113, c7_.organisme_gestionnaire AS organisme_gestionnaire_114, c7_.id_statut_metadonnee AS id_statut_metadonnee_115 FROM ipn_catalogue_connaissance_2017.jdd j0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j1_ ON j0_.id_jdd = j1_.id_jdd INNER JOIN ipn_user.organisme o2_ ON j0_.organisme_gestionnaire = o2_.orgid LEFT JOIN ipn_user.utilisateur u3_ ON j0_.utilisateur_gestionnaire = u3_.uid LEFT JOIN ipn_catalogue_connaissance_2017.jdd_contact_donnees j4_ ON j0_.id_jdd = j4_.id_jdd LEFT JOIN ipn_user.organisme o5_ ON j4_.organisme = o5_.orgid LEFT JOIN ipn_catalogue_connaissance_2017.ref_role_acteur r6_ ON j4_.role_acteur = r6_.id_ref INNER JOIN ipn_catalogue_connaissance_2017.ca c7_ ON j0_.id_ca = c7_.id_ca WHERE j1_.date_derniere_creation_donnee > ? ORDER BY j1_.date_derniere_creation_donnee DESC
Parameters:
[
"2026-01-13 14:43:46"
]
|
||||||||||||||||||||||||||||
|
10.03 ms (9.00%) |
13 |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.date_derniere_creation_donnee AS date_derniere_creation_donnee_6, t0.date_derniere_modif_donnee AS date_derniere_modif_donnee_7, t0.id_ca AS id_ca_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.ca t0 WHERE t0.id_ca = ?
Parameters:
[
4814
]
|
||||||||||||||||||||||||||||
|
9.74 ms (8.74%) |
13 |
SELECT t0.id AS id_1, t0.nb_obs AS nb_obs_2, t0.nb_obs_presence AS nb_obs_presence_3, t0.date_max AS date_max_4, t0.envelope_geojson AS envelope_geojson_5, t0.id_ca AS id_ca_6 FROM ipn_descripteurs_general_v2.ca t0 WHERE t0.id_ca = ?
Parameters:
[
4814
]
|
||||||||||||||||||||||||||||
|
9.24 ms (8.29%) |
18 |
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:
[
229
]
|
||||||||||||||||||||||||||||
|
6.03 ms (5.41%) |
13 |
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 = ?
Parameters:
[
111
]
|
||||||||||||||||||||||||||||
|
3.72 ms (3.34%) |
1 |
SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.resume AS resume_2, p0_.ordre AS ordre_3, p0_.classes_richesse AS classes_richesse_4, p0_.classes_pression_obs AS classes_pression_obs_5, p0_.restreint_users AS restreint_users_6, p0_.grands_habitats_taxef AS grands_habitats_taxef_7, p0_.icone AS icone_8, p0_.libelle_uri AS libelle_uri_9, g1_.gid AS gid_10, g1_.libelle_item AS libelle_item_11, g1_.icone AS icone_12, g1_.libelle_uri AS libelle_uri_13, g1_.cd_ref_gpes AS cd_ref_gpes_14, g1_.gpe_sup AS gpe_sup_15, g1_.code_machine AS code_machine_16, g1_.resume AS resume_17, g1_.ordre AS ordre_18, g1_.portail_ouvert AS portail_ouvert_19, g1_.classes_richesse AS classes_richesse_20, g1_.classes_pression_obs AS classes_pression_obs_21, g1_.portail_restreint_users AS portail_restreint_users_22, g2_.gid AS gid_23, g2_.libelle_item AS libelle_item_24, g2_.libelle_uri AS libelle_uri_25, g2_.resume AS resume_26, g2_.icone AS icone_27, g2_.portail_ouvert AS portail_ouvert_28, g2_.portail_restreint_users AS portail_restreint_users_29, g2_.code_machine AS code_machine_30, p3_.pid AS pid_31, p3_.credits AS credits_32, p3_.description AS description_33, p3_.nom_fichier AS nom_fichier_34, p3_.photo_ref AS photo_ref_35, p3_.date_creation AS date_creation_36, p3_.date_revision AS date_revision_37, p4_.pid AS pid_38, p4_.nb_observations AS nb_observations_39, p4_.nb_photos AS nb_photos_40, p4_.nb_especes AS nb_especes_41, p4_.nb_proteges AS nb_proteges_42, p4_.nb_menaces AS nb_menaces_43, p4_.nb_introduites AS nb_introduites_44, p4_.nb_contributeurs AS nb_contributeurs_45, p0_.groupe_usuel_id AS groupe_usuel_id_46, p0_.groupe_fonctionnel_id AS groupe_fonctionnel_id_47, p0_.photo_taxon_reference AS photo_taxon_reference_48, p0_.id AS id_49, g1_.gid AS gid_50, p3_.cd_ref AS cd_ref_51, p3_.id_numerisateur AS id_numerisateur_52, p3_.id_licence AS id_licence_53, p3_.id_statut AS id_statut_54, p3_.gestionnaire AS gestionnaire_55 FROM ipn_taxonomie.portail_taxo p0_ LEFT JOIN ipn_taxonomie.groupes_usuels g1_ ON p0_.groupe_usuel_id = g1_.gid LEFT JOIN ipn_taxonomie.groupes_fonctionnels g2_ ON p0_.groupe_fonctionnel_id = g2_.gid INNER JOIN ipn_photo.photo_taxon p3_ ON p0_.photo_taxon_reference = p3_.pid INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.portail_taxo p4_ ON p0_.id = p4_.pid WHERE p0_.restreint_users IS NULL ORDER BY p0_.libelle ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.26 ms (1.13%) |
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
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.24 ms (1.11%) |
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:
[] |
||||||||||||||||||||||||||||
|
1.04 ms (0.93%) |
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 = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.58 ms (0.52%) |
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
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\JDD\JDDContactDonnees | 76 |
| App\Entity\User | 35 |
| App\Entity\JDD\JDD | 27 |
| App\Entity\JDD\VMSyntheseJDDTotal | 27 |
| App\Entity\JDD\VMSyntheseJDD | 27 |
| App\Entity\Organisme | 19 |
| App\Entity\Indicateurs\Donnees\OccSINPValide\Contributeur | 17 |
| App\Entity\Taxonomie\PortailTaxonomique | 15 |
| App\Entity\Taxonomie\GroupeUsuel | 15 |
| App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General | 15 |
| App\Entity\Photo\Photo | 15 |
| App\Entity\Taxonomie\TaxrefLast | 15 |
| App\Entity\Indicateurs\Donnees\OccSINPValide\PortailTaxonomique\General | 15 |
| App\Entity\JDD\CadreAcquisition | 13 |
| App\Entity\JDD\VMSyntheseCA | 13 |
| App\Entity\JDD\VMSyntheseCATotal | 13 |
| App\Entity\TypeFriendlyOrganisme | 7 |
| App\Entity\Donnees\FormatDonnees | 6 |
| App\Entity\JDD\EchelleTerritoriale | 5 |
| App\Entity\TypeOrganisme | 4 |
| App\Entity\JDD\RoleActeur | 3 |
| App\Entity\Photo\Licence | 3 |
| App\Entity\JDD\StatutOrigineDonnee | 2 |
| App\Entity\JDD\BaseDeDonnees | 2 |
| App\Entity\JDD\StatutMetadonnee | 1 |
| App\Entity\JDD\FloutageProducteur | 1 |
| App\Entity\JDD\TypeDonnees | 1 |
| App\Entity\JDD\DiffusionJDD | 1 |
| App\Entity\JDD\CategorieDonnee | 1 |
| App\Entity\Indicateurs\Donnees\NbObsOccSINP | 1 |
| App\Entity\Photo\StatutPhoto | 1 |
| App\Entity\Taxonomie\GroupeFonctionnel | 1 |