Query Metrics
89
Database Queries
10
Different statements
108.28 ms
Query time
0
Invalid entities
401
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
46.78 ms (43.20%) |
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
]
|
||||||||||||||||||||||||||||
|
20.78 ms (19.20%) |
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_.type_localisation AS type_localisation_5, j0_.commentaire_regional AS commentaire_regional_6, j0_.date_creation AS date_creation_7, j0_.date_revision AS date_revision_8, j0_.envoi_inpn AS envoi_inpn_9, j0_.autorise_transmission AS autorise_transmission_10, j0_.blocage_diffusion AS blocage_diffusion_11, j0_.date_mise_en_circulation AS date_mise_en_circulation_12, j0_.motif_blocage_diffusion AS motif_blocage_diffusion_13, j0_.bypass_habilite_region AS bypass_habilite_region_14, j0_.date_envoi_inpn AS date_envoi_inpn_15, j0_.infos_supp_ds AS infos_supp_ds_16, j0_.ouverture_publique AS ouverture_publique_17, j0_.date_fin_enquete_participative AS date_fin_enquete_participative_18, j0_.photo AS photo_19, j0_.enquete_privee AS enquete_privee_20, j0_.cle_mobile AS cle_mobile_21, j0_.cle_web AS cle_web_22, j1_.id AS id_23, j1_.nb_obs AS nb_obs_24, j1_.nb_obs_presence AS nb_obs_presence_25, j1_.date_max AS date_max_26, j1_.envelope_geojson AS envelope_geojson_27, j1_.date_derniere_creation_donnee AS date_derniere_creation_donnee_28, j1_.date_derniere_modif_donnee AS date_derniere_modif_donnee_29, o2_.orgid AS orgid_30, o2_.libelle_court AS libelle_court_31, o2_.libelle_long AS libelle_long_32, o2_.logo AS logo_33, o2_.clef_modif AS clef_modif_34, o2_.adherent_sinp AS adherent_sinp_35, o2_.gestion_autonome_habilitation AS gestion_autonome_habilitation_36, o2_.date_creation AS date_creation_37, o2_.habilite_region AS habilite_region_38, u3_.uid AS uid_39, u3_.username AS username_40, u3_.password AS password_41, u3_.username_externe_inaturalist AS username_externe_inaturalist_42, u3_.id_externe_kollect AS id_externe_kollect_43, u3_.forgotpassword_key AS forgotpassword_key_44, u3_.token_suppression_compte AS token_suppression_compte_45, u3_.mail_transitoire_code_verif AS mail_transitoire_code_verif_46, u3_.mail AS mail_47, u3_.mail_transitoire AS mail_transitoire_48, u3_.prenom AS prenom_49, u3_.nom AS nom_50, u3_.utilisation_perso_newsletter AS utilisation_perso_newsletter_51, u3_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_52, u3_.creation_en_interne AS creation_en_interne_53, u3_.date_creation_compte AS date_creation_compte_54, u3_.date_suppression_compte AS date_suppression_compte_55, u3_.date_derniere_connexion AS date_derniere_connexion_56, u3_.utilisation_perso_commentaire AS utilisation_perso_commentaire_57, j4_.id_jdd_contact AS id_jdd_contact_58, j4_.nom_prenom_acteur AS nom_prenom_acteur_59, j4_.mail AS mail_60, j4_.nom_cite_organisme AS nom_cite_organisme_61, o5_.orgid AS orgid_62, o5_.libelle_court AS libelle_court_63, o5_.libelle_long AS libelle_long_64, o5_.logo AS logo_65, o5_.clef_modif AS clef_modif_66, o5_.adherent_sinp AS adherent_sinp_67, o5_.gestion_autonome_habilitation AS gestion_autonome_habilitation_68, o5_.date_creation AS date_creation_69, o5_.habilite_region AS habilite_region_70, r6_.id_ref AS id_ref_71, r6_.id_sinp AS id_sinp_72, r6_.libelle AS libelle_73, r6_.description AS description_74, r6_.nom_machine AS nom_machine_75, c7_.id_ca AS id_ca_76, c7_.uuid AS uuid_77, c7_.nom_complet AS nom_complet_78, c7_.resume AS resume_79, c7_.commentaire_regional AS commentaire_regional_80, c7_.date_lancement AS date_lancement_81, c7_.date_cloture AS date_cloture_82, c7_.groupe_ecologique_ou_geologique AS groupe_ecologique_ou_geologique_83, c7_.precision_cible_geographique AS precision_cible_geographique_84, c7_.date_creation_metadonnee AS date_creation_metadonnee_85, c7_.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_86, c7_.date_envoi_inpn AS date_envoi_inpn_87, c7_.ouverture_publique AS ouverture_publique_88, j0_.id_jdd_valide AS id_jdd_valide_89, j0_.id_ca AS id_ca_90, j0_.organisme_gestionnaire AS organisme_gestionnaire_91, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_92, j0_.id_numerisateur AS id_numerisateur_93, j0_.id_statut_metadonnee AS id_statut_metadonnee_94, j0_.id_processus_collecte AS id_processus_collecte_95, j0_.id_ds_publique_prive AS id_ds_publique_prive_96, j0_.id_floutage_prod AS id_floutage_prod_97, j0_.type_donnees AS type_donnees_98, j0_.id_diffusion AS id_diffusion_99, j0_.id_bdd AS id_bdd_100, j0_.id_jdd_parent AS id_jdd_parent_101, j0_.format_donnees AS format_donnees_102, j0_.format_donnees_mobile AS format_donnees_mobile_103, j1_.id_jdd AS id_jdd_104, o2_.id_numerisateur AS id_numerisateur_105, o2_.id_type AS id_type_106, o2_.id_type_friendly AS id_type_friendly_107, u3_.user_simulation AS user_simulation_108, j4_.id_jdd AS id_jdd_109, j4_.role_acteur AS role_acteur_110, j4_.organisme AS organisme_111, o5_.id_numerisateur AS id_numerisateur_112, o5_.id_type AS id_type_113, o5_.id_type_friendly AS id_type_friendly_114, c7_.id_ca_valide AS id_ca_valide_115, c7_.type_financement AS type_financement_116, c7_.niveau_territorial AS niveau_territorial_117, c7_.id_numerisateur AS id_numerisateur_118, c7_.organisme_gestionnaire AS organisme_gestionnaire_119, c7_.id_statut_metadonnee AS id_statut_metadonnee_120 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:38:43"
]
|
||||||||||||||||||||||||||||
|
9.85 ms (9.10%) |
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.56 ms (8.83%) |
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.11 ms (8.41%) |
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.20 ms (5.72%) |
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.82 ms (3.53%) |
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_.icone AS icone_7, p0_.libelle_uri AS libelle_uri_8, g1_.gid AS gid_9, g1_.libelle_item AS libelle_item_10, g1_.icone AS icone_11, g1_.libelle_uri AS libelle_uri_12, g1_.cd_ref_gpes AS cd_ref_gpes_13, g1_.gpe_sup AS gpe_sup_14, g1_.code_machine AS code_machine_15, g1_.resume AS resume_16, g1_.ordre AS ordre_17, g1_.portail_ouvert AS portail_ouvert_18, g1_.classes_richesse AS classes_richesse_19, g1_.classes_pression_obs AS classes_pression_obs_20, g1_.portail_restreint_users AS portail_restreint_users_21, g2_.gid AS gid_22, g2_.libelle_item AS libelle_item_23, g2_.libelle_uri AS libelle_uri_24, g2_.resume AS resume_25, g2_.icone AS icone_26, g2_.portail_ouvert AS portail_ouvert_27, g2_.portail_restreint_users AS portail_restreint_users_28, g2_.code_machine AS code_machine_29, p3_.pid AS pid_30, p3_.credits AS credits_31, p3_.description AS description_32, p3_.nom_fichier AS nom_fichier_33, p3_.photo_ref AS photo_ref_34, p3_.date_creation AS date_creation_35, p3_.date_revision AS date_revision_36, p4_.pid AS pid_37, p4_.nb_observations AS nb_observations_38, p4_.nb_photos AS nb_photos_39, p4_.nb_especes AS nb_especes_40, p4_.nb_proteges AS nb_proteges_41, p4_.nb_menaces AS nb_menaces_42, p4_.nb_introduites AS nb_introduites_43, p4_.nb_contributeurs AS nb_contributeurs_44, p0_.groupe_usuel_id AS groupe_usuel_id_45, p0_.groupe_fonctionnel_id AS groupe_fonctionnel_id_46, p0_.photo_taxon_reference AS photo_taxon_reference_47, p0_.id AS id_48, g1_.gid AS gid_49, p3_.cd_ref AS cd_ref_50, p3_.id_numerisateur AS id_numerisateur_51, p3_.id_licence AS id_licence_52, p3_.id_statut AS id_statut_53, p3_.gestionnaire AS gestionnaire_54 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.03 ms (0.95%) |
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.59 ms (0.55%) |
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:
[]
|
||||||||||||||||||||||||||||
|
0.56 ms (0.51%) |
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:
[]
|
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\NiveauTerritorial | 5 |
| App\Entity\TypeOrganisme | 4 |
| App\Entity\JDD\RoleActeur | 3 |
| App\Entity\JDD\TypeFinancement | 3 |
| App\Entity\Photo\Licence | 3 |
| App\Entity\JDD\ProcessusCollecte | 2 |
| App\Entity\JDD\StatutDS | 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\Indicateurs\Donnees\NbObsOccSINP | 1 |
| App\Entity\Photo\StatutPhoto | 1 |
| App\Entity\Taxonomie\GroupeFonctionnel | 1 |