Query Metrics

34 Database Queries
22 Different statements
125.04 ms Query time
0 Invalid entities
2772 Managed entities

Queries

Group similar statements

# Time Info
1 9.12 ms
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.uuid = ? LIMIT 1
Parameters:
[
  "2804527e-c748-4783-a01d-ac10eb426f76"
]
2 1.08 ms
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
]
3 6.59 ms
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, o1_.orgid AS orgid_21, o1_.libelle_court AS libelle_court_22, o1_.libelle_long AS libelle_long_23, o1_.logo AS logo_24, o1_.clef_modif AS clef_modif_25, o1_.adherent_sinp AS adherent_sinp_26, o1_.gestion_autonome_habilitation AS gestion_autonome_habilitation_27, o1_.date_creation AS date_creation_28, o1_.habilite_region AS habilite_region_29, u2_.uid AS uid_30, u2_.username AS username_31, u2_.password AS password_32, u2_.username_externe_inaturalist AS username_externe_inaturalist_33, u2_.id_externe_kollect AS id_externe_kollect_34, u2_.forgotpassword_key AS forgotpassword_key_35, u2_.token_suppression_compte AS token_suppression_compte_36, u2_.mail_transitoire_code_verif AS mail_transitoire_code_verif_37, u2_.mail AS mail_38, u2_.mail_transitoire AS mail_transitoire_39, u2_.prenom AS prenom_40, u2_.nom AS nom_41, u2_.utilisation_perso_newsletter AS utilisation_perso_newsletter_42, u2_.pseudonymisation_rgpd_saisie AS pseudonymisation_rgpd_saisie_43, u2_.creation_en_interne AS creation_en_interne_44, u2_.date_creation_compte AS date_creation_compte_45, u2_.date_suppression_compte AS date_suppression_compte_46, u2_.date_derniere_connexion AS date_derniere_connexion_47, u2_.utilisation_perso_commentaire AS utilisation_perso_commentaire_48, j0_.id_jdd_valide AS id_jdd_valide_49, j0_.id_ca AS id_ca_50, j0_.organisme_gestionnaire AS organisme_gestionnaire_51, j0_.utilisateur_gestionnaire AS utilisateur_gestionnaire_52, j0_.id_numerisateur AS id_numerisateur_53, j0_.id_statut_metadonnee AS id_statut_metadonnee_54, j0_.id_floutage_prod AS id_floutage_prod_55, j0_.id_statut_origine_donnees AS id_statut_origine_donnees_56, j0_.id_type_donnees AS id_type_donnees_57, j0_.id_diffusion AS id_diffusion_58, j0_.id_categorie_donnees AS id_categorie_donnees_59, j0_.id_bdd AS id_bdd_60, j0_.id_jdd_parent AS id_jdd_parent_61, j0_.format_donnees AS format_donnees_62, j0_.format_donnees_mobile AS format_donnees_mobile_63, j0_.id_protocole_campanule AS id_protocole_campanule_64, o1_.id_numerisateur AS id_numerisateur_65, o1_.id_type AS id_type_66, o1_.id_type_friendly AS id_type_friendly_67, u2_.user_simulation AS user_simulation_68 FROM ipn_catalogue_connaissance_2017.jdd j0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.jdd j3_ ON j0_.id_jdd = j3_.id_jdd LEFT JOIN ipn_user.organisme o1_ ON j0_.organisme_gestionnaire = o1_.orgid LEFT JOIN ipn_user.utilisateur u2_ ON j0_.utilisateur_gestionnaire = u2_.uid WHERE j0_.id_ca = ? AND j0_.id_statut_metadonnee = 3 AND j0_.blocage_diffusion <> true
Parameters:
[
  4814
]
4 1.65 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  25878
]
5 1.77 ms
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:
[
  25878
]
6 2.85 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  25909
]
7 2.65 ms
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:
[
  25909
]
8 1.73 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  25955
]
9 2.28 ms
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:
[
  25955
]
10 2.01 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  25956
]
11 1.88 ms
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:
[
  25956
]
12 3.49 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  25957
]
13 1.71 ms
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:
[
  25957
]
14 4.59 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  25958
]
15 1.73 ms
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:
[
  25958
]
16 1.61 ms
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_jdd AS id_jdd_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.jdd t0 WHERE t0.id_jdd = ?
Parameters:
[
  26966
]
17 1.71 ms
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:
[
  26966
]
18 36.51 ms
SELECT j0_.id AS id_0, j0_.taxons_superieurs AS taxons_superieurs_1, j0_.groupes_usuels AS groupes_usuels_2, j0_.nb_obs AS nb_obs_3, j0_.nb_obs_presence AS nb_obs_presence_4, j0_.date_max AS date_max_5, v1_.cd_nom AS cd_nom_6, v1_.cd_ref AS cd_ref_7, v1_.lb_nom AS lb_nom_8, v1_.lb_auteur AS lb_auteur_9, v1_.nom_vern AS nom_vern_10, v1_.premier_nom_vern AS premier_nom_vern_11, v1_.nom_valide AS nom_valide_12, v1_.rang AS rang_13, v1_.embranchement AS embranchement_14, v1_.classe AS classe_15, v1_.ordre AS ordre_16, v1_.famille AS famille_17, v1_.version AS version_18, v1_.presence_metropole AS presence_metropole_19, v1_.icone AS icone_20, v1_.cd_espece AS cd_espece_21, v1_.taxons_superieurs AS taxons_superieurs_22, v1_.groupes_usuels AS groupes_usuels_23, v1_.groupes_fonctionnels AS groupes_fonctionnels_24, r2_.cd_ref AS cd_ref_25, r2_.comparaison_autocompletion AS comparaison_autocompletion_26, r2_.est_menace AS est_menace_27, r2_.est_protege AS est_protege_28, r2_.est_exotique AS est_exotique_29, r2_.meilleure_photo_disponible AS meilleure_photo_disponible_30, r2_.extension_imagine_filter AS extension_imagine_filter_31, r2_.credits AS credits_32, r2_.licence AS licence_33, r2_.licence_url AS licence_url_34, r2_.licence_libelle AS licence_libelle_35, r2_.licence_version AS licence_version_36, r2_.icone AS icone_37, r2_.fiche_descriptive AS fiche_descriptive_38, r2_.fiche_descriptive_source AS fiche_descriptive_source_39, r2_.nb_obs AS nb_obs_40, j0_.id_jdd AS id_jdd_41, j0_.cd_ref AS cd_ref_42, v1_.cd_nom AS cd_nom_43, v1_.cd_nom AS cd_nom_44, v1_.cd_ref AS cd_ref_45, v1_.rang AS rang_46, v1_.habitat AS habitat_47, v1_.cd_nom AS cd_nom_48, v1_.cd_nom AS cd_nom_49, v1_.cd_nom AS cd_nom_50, v1_.cd_nom AS cd_nom_51 FROM ipn_descripteurs_general_v2.jdd_especes j0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON j0_.cd_ref = v1_.cd_nom LEFT JOIN ipn_requeteur_v3.referentiel_espece r2_ ON v1_.cd_nom = r2_.cd_ref WHERE j0_.id_jdd = ?
Parameters:
[
  22774
]
19 1.34 ms
SELECT t0.id_jdd_contact AS id_jdd_contact_1, t0.nom_prenom_acteur AS nom_prenom_acteur_2, t0.mail AS mail_3, t0.id_jdd AS id_jdd_4, t0.role_acteur AS role_acteur_5, t6.id_ref AS id_ref_7, t6.id_sinp AS id_sinp_8, t6.libelle AS libelle_9, t6.description AS description_10, t6.nom_machine AS nom_machine_11, t0.organisme AS organisme_12 FROM ipn_catalogue_connaissance_2017.jdd_contact_donnees t0 INNER JOIN ipn_catalogue_connaissance_2017.ref_role_acteur t6 ON t0.role_acteur = t6.id_ref WHERE t0.id_jdd = ?
Parameters:
[
  22774
]
20 4.47 ms
SELECT t0.id_ca AS id_ca_1, t0.uuid AS uuid_2, t0.nom_complet AS nom_complet_3, t0.resume AS resume_4, t0.commentaire_regional AS commentaire_regional_5, t0.date_lancement AS date_lancement_6, t0.date_cloture AS date_cloture_7, t0.date_creation_metadonnee AS date_creation_metadonnee_8, t0.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_9, t0.date_envoi_inpn AS date_envoi_inpn_10, t0.ouverture_publique AS ouverture_publique_11, t0.id_ca_valide AS id_ca_valide_12, t0.echelle_territoriale AS echelle_territoriale_13, t0.id_numerisateur AS id_numerisateur_14, t0.organisme_gestionnaire AS organisme_gestionnaire_15, t0.id_statut_metadonnee AS id_statut_metadonnee_16, t17.id AS id_18, t17.nb_obs AS nb_obs_19, t17.nb_obs_presence AS nb_obs_presence_20, t17.date_max AS date_max_21, t17.envelope_geojson AS envelope_geojson_22, t17.date_derniere_creation_donnee AS date_derniere_creation_donnee_23, t17.date_derniere_modif_donnee AS date_derniere_modif_donnee_24, t17.id_ca AS id_ca_25, t26.id AS id_27, t26.nb_obs AS nb_obs_28, t26.nb_obs_presence AS nb_obs_presence_29, t26.date_max AS date_max_30, t26.envelope_geojson AS envelope_geojson_31, t26.id_ca AS id_ca_32 FROM ipn_catalogue_connaissance_2017.ca t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.ca t17 ON t17.id_ca = t0.id_ca LEFT JOIN ipn_descripteurs_general_v2.ca t26 ON t26.id_ca = t0.id_ca WHERE t0.id_ca = ?
Parameters:
[
  4814
]
21 1.12 ms
SELECT t0.id_ca_contact AS id_ca_contact_1, t0.nom_prenom_acteur AS nom_prenom_acteur_2, t0.mail AS mail_3, t0.id_ca AS id_ca_4, t0.role_acteur AS role_acteur_5, t6.id_ref AS id_ref_7, t6.id_sinp AS id_sinp_8, t6.libelle AS libelle_9, t6.description AS description_10, t6.nom_machine AS nom_machine_11, t0.organisme AS organisme_12 FROM ipn_catalogue_connaissance_2017.ca_contact t0 INNER JOIN ipn_catalogue_connaissance_2017.ref_role_acteur t6 ON t0.role_acteur = t6.id_ref WHERE t0.id_ca = ?
Parameters:
[
  4814
]
22 2.93 ms
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
Parameters:
[]
23 1.01 ms
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
Parameters:
[]
24 2.89 ms
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:
[]
25 5.51 ms
SELECT t0.id_objectif AS id_objectif_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.gel AS gel_5 FROM ipn_catalogue_connaissance_2017.ref_objectif t0 INNER JOIN ipn_catalogue_connaissance_2017.ca_objectif ON t0.id_objectif = ipn_catalogue_connaissance_2017.ca_objectif.id_objectif WHERE ipn_catalogue_connaissance_2017.ca_objectif.id_ca = ?
Parameters:
[
  4814
]
26 0.73 ms
SELECT t0.url AS url_1, t0.reference_complete AS reference_complete_2, t0.fichier AS fichier_3, t0.id_ca AS id_ca_4 FROM ipn_catalogue_connaissance_2017.ca_publication t0 WHERE t0.id_ca = ?
Parameters:
[
  4814
]
27 5.37 ms
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_ca = ? ORDER BY t0.nom_complet ASC
Parameters:
[
  4814
]
28 3.02 ms
SELECT t0.libelle AS libelle_1, t0.url AS url_2, t0.description AS description_3, t0.fichier AS fichier_4, t0.id_jdd AS id_jdd_5, t0.type AS type_6, t7.id_ref AS id_ref_8, t7.id_sinp AS id_sinp_9, t7.libelle AS libelle_10, t7.description AS description_11 FROM ipn_catalogue_connaissance_2017.jdd_protocole t0 INNER JOIN ipn_catalogue_connaissance_2017.ref_type_protocole t7 ON t0.type = t7.id_ref WHERE t0.id_jdd = ?
Parameters:
[
  22774
]
29 0.57 ms
SELECT t0.id_statut_origine AS id_statut_origine_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3 FROM ipn_catalogue_connaissance_2017.ref_statut_origine_donnees t0 WHERE t0.id_statut_origine = ?
Parameters:
[
  1
]
30 1.50 ms
SELECT t0.id_ref AS id_ref_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.url AS url_4, t0.uid_perso AS uid_perso_5, t0.orgid_perso AS orgid_perso_6, t0.disponible_organisme AS disponible_organisme_7, t0.disponible_independant AS disponible_independant_8 FROM ipn_catalogue_connaissance_2017.ref_bdd t0 WHERE t0.id_ref = ?
Parameters:
[
  33
]
31 1.45 ms
SELECT t0.id_ref AS id_ref_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.libelle_court AS libelle_court_4, t0.description AS description_5, t0.icone AS icone_6, t0.gel AS gel_7 FROM ipn_catalogue_connaissance_2017.ref_type_donnees t0 WHERE t0.id_ref = ?
Parameters:
[
  10
]
32 0.73 ms
SELECT t0.id_territoire AS id_territoire_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM ipn_catalogue_connaissance_2017.ref_territoire t0 INNER JOIN ipn_catalogue_connaissance_2017.jdd_cible_geographique ON t0.id_territoire = ipn_catalogue_connaissance_2017.jdd_cible_geographique.id_cible WHERE ipn_catalogue_connaissance_2017.jdd_cible_geographique.id_jdd = ?
Parameters:
[
  22774
]
33 1.11 ms
SELECT t0.id_classe_ebv AS id_classe_ebv_1, t0.id_sinp AS id_sinp_2, t0.libelle AS libelle_3 FROM ipn_catalogue_connaissance_2017.ref_classe_ebv t0 INNER JOIN ipn_catalogue_connaissance_2017.jdd_classe_ebv ON t0.id_classe_ebv = ipn_catalogue_connaissance_2017.jdd_classe_ebv.id_classe_ebv WHERE ipn_catalogue_connaissance_2017.jdd_classe_ebv.id_jdd = ?
Parameters:
[
  22774
]
34 6.36 ms
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
]

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\VMEspeceParJDDTotal 280
App\Entity\Taxonomie\TaxrefLast 280
App\Entity\Taxonomie\CdRefAutocompletion 280
App\Entity\ReferentielTaxo\TaxonEvalue 280
App\Entity\ReferentielTaxo\AdminTaxonEvalue 280
App\Entity\ReferentielTaxo\AdminTaxonEtat 280
App\Entity\Sensibilite\TaxonSensible 280
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional 265
App\Entity\Taxonomie\GroupeUsuel 241
App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General 241
App\Entity\JDD\JDD 8
App\Entity\JDD\VMSyntheseJDD 8
App\Entity\JDD\VMSyntheseJDDTotal 8
App\Entity\Taxonomie\TaxrefLastHabitat 6
App\Entity\JDD\RoleActeur 5
App\Entity\User 3
App\Entity\Taxonomie\RefRangTaxonomique 3
App\Entity\JDD\CadreAcquisitionContact 3
App\Entity\JDD\JDDContactDonnees 2
App\Entity\JDD\TypeDispositif 2
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\Indicateurs\Donnees\OccSINPValide\Contributeur 1
App\Entity\JDD\EchelleTerritoriale 1
App\Entity\JDD\VMSyntheseCA 1
App\Entity\JDD\VMSyntheseCATotal 1
App\Entity\JDD\Territoire 1

Entities Mapping

Class Mapping errors
App\Entity\JDD\JDD No errors.
App\Entity\JDD\CadreAcquisition No errors.
App\Entity\Organisme No errors.
App\Entity\User No errors.
App\Entity\TypeOrganisme No errors.
App\Entity\TypeFriendlyOrganisme No errors.
App\Entity\JDD\StatutMetadonnee No errors.
App\Entity\JDD\FloutageProducteur No errors.
App\Entity\JDD\StatutOrigineDonnee No errors.
App\Entity\JDD\TypeDonnees No errors.
App\Entity\JDD\DiffusionJDD No errors.
App\Entity\JDD\CategorieDonnee No errors.
App\Entity\JDD\BaseDeDonnees No errors.
App\Entity\JDD\VMSyntheseJDD No errors.
App\Entity\JDD\VMSyntheseJDDTotal No errors.
App\Entity\Donnees\FormatDonnees No errors.
App\Entity\JDD\ProtocoleCampanule No errors.
App\Entity\JDD\ClasseEBV No errors.
App\Entity\JDD\Caracteristique No errors.
App\Entity\JDD\Territoire No errors.
App\Entity\JDD\JDDProtocole No errors.
App\Entity\Donnees\Releve No errors.
App\Entity\JDD\JDDContactDonnees No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\JDD\GroupesUsuels No errors.
App\Entity\Indicateurs\Donnees\OccTotal\JDD\GroupesUsuels No errors.
App\Entity\JDD\VMEspeceParJDD No errors.
App\Entity\JDD\VMEspeceParJDDTotal No errors.
App\Entity\UtilisateurEtOrganisme\CorrUserJDDEnquete No errors.
App\Entity\UtilisateurEtOrganisme\CorrUserDefautJDDSaisie No errors.
App\Entity\RolesOrganismes No errors.
App\Entity\Organisme\HabilitationPNR No errors.
App\Entity\Organisme\HabilitationReserve No errors.
App\Entity\Organisme\HabilitationSIC No errors.
App\Entity\Organisme\HabilitationZPS No errors.
App\Entity\Organisme\HabilitationDepartement No errors.
App\Entity\Organisme\HabilitationGEMAPI No errors.
App\Entity\JDD\CadreAcquisitionContact No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\Contributeur No errors.
App\Entity\OrganismesUser No errors.
App\Entity\Organisme\SuperviseurHabilitation No errors.
App\Entity\CertificatDepot\CertificatDepot No errors.
App\Entity\Taxonomie\TaxrefLast No errors.
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional No errors.
App\Entity\Taxonomie\CdRefAutocompletion No errors.
App\Entity\Taxonomie\RefRangTaxonomique No errors.
App\Entity\Taxonomie\TaxrefLastHabitat No errors.
App\Entity\ReferentielTaxo\TaxonEvalue No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvalue No errors.
App\Entity\ReferentielTaxo\AdminTaxonEtat No errors.
App\Entity\Sensibilite\TaxonSensible No errors.
App\Entity\ReferentielTaxo\AdminForumStatut No errors.
App\Entity\ReferentielTaxo\AdminHistoriqueStatut No errors.
App\Entity\ReferentielTaxo\AdminStatutNiveauAvancement No errors.
App\Entity\ReferentielTaxo\AdminDerniereConsultationForumStatut No errors.
App\Entity\Photo\Photo No errors.
App\Entity\Taxonomie\TaxrefAPIPhoto No errors.
App\Entity\ReferentielTaxo\TaxonPNA No errors.
App\Entity\ReferentielTaxo\TaxonReglemente No errors.
App\Entity\ReferentielTaxo\TaxonDeterminant No errors.
App\Entity\ListeRouge\EvaluationListeRouge No errors.
App\Entity\Indicateurs\Donnees\EspecesParMoisObservation No errors.
App\Entity\Validation\CorrPheno No errors.
App\Entity\Validation\CorrDifficulteDetermination No errors.
App\Entity\JDD\RoleActeur No errors.
App\Entity\JDD\EchelleTerritoriale No errors.
App\Entity\JDD\VMSyntheseCA No errors.
App\Entity\JDD\VMSyntheseCATotal No errors.
App\Entity\JDD\TypeDispositif No errors.
App\Entity\JDD\CadreAcquisitionPublication No errors.
App\Entity\JDD\CadreAcquisitionOrganismeAutorise No errors.
App\Entity\Taxonomie\GroupeUsuel No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General No errors.
App\Entity\ReferentielCarto\EnvironnementCarto No errors.
App\Entity\ReferentielCarto\EnvironnementCartoCorrFondPlan No errors.
App\Entity\ReferentielCarto\EnvironnementCartoFondPlanDisponible No errors.
App\Entity\Droits\UserRole No errors.
App\Entity\Droits\GestionRefEspGroupeUsuel No errors.
App\Entity\Droits\GestionRefEspTaxref No errors.
App\Entity\Droits\GestionSensibiliteGroupeUsuel No errors.
App\Entity\Droits\ValidationDonneesCache No errors.
App\Entity\Droits\DroitsProjet No errors.
App\Entity\DemandeDonnees\DemandeUtilisateursAutorise No errors.
App\Entity\JDD\BaseDeDonneesContact No errors.
App\Entity\Donnees\CorrespondanceAttributFormatDonnees No errors.
App\Entity\Donnees\FormatDonneesDescriptif No errors.
App\Entity\JDD\TypeProtocole No errors.
App\Entity\Donnees\Observation No errors.
App\Entity\Donnees\ReleveObservateur No errors.
App\Entity\Donnees\AttributNomenclature No errors.
App\Entity\Transmission\Envoi No errors.
App\Entity\Donnees\ReleveLocalisationOrigine No errors.
App\Entity\Donnees\CorrespondanceReleveAttributDonnee No errors.
App\Entity\RoleOrganisme No errors.
App\Entity\ReferentielCarto\PNR No errors.
App\Entity\ReferentielCarto\Reserve No errors.
App\Entity\ReferentielCarto\SIC No errors.
App\Entity\ReferentielCarto\ZPS No errors.
App\Entity\ReferentielCarto\Departement No errors.
App\Entity\ReferentielCarto\GEMAPI No errors.
App\Entity\ReferentielTaxo\StatutPresence No errors.
App\Entity\ReferentielTaxo\StatutIndigenatRegional No errors.
App\Entity\ReferentielTaxo\StatutEndemisme No errors.
App\Entity\ReferentielTaxo\StatutRarete No errors.
App\Entity\ReferentielTaxo\TaxonEvaluePresenceDepartementale No errors.
App\Entity\ReferentielTaxo\TaxonEvaluePresenceZonageMarin No errors.
App\Entity\ReferentielTaxo\StatutPhenologique No errors.
App\Entity\ReferentielTaxo\StatutEnjeu No errors.
App\Entity\ReferentielTaxo\Exotiques\TaxonExotique No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvaluePresenceDepartementale No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvaluePresenceZonageMarin No errors.
App\Entity\ReferentielTaxo\Exotiques\AdminTaxonExotique No errors.
App\Entity\ReferentielTaxo\StatutEtat No errors.
App\Entity\Sensibilite\NiveauSensibilite No errors.
App\Entity\ReferentielTaxo\AdminInteractionCommentaireForum No errors.
App\Entity\ReferentielTaxo\AdminRefNiveauAvancementStatut No errors.
App\Entity\Photo\Licence No errors.
App\Entity\Photo\StatutPhoto No errors.
App\Entity\ReferentielTaxo\TypeStatut No errors.
App\Entity\ReferentielTaxo\TypeReglementation No errors.
App\Entity\ListeRouge\Categorie No errors.
App\Entity\Validation\CritereDifficulte No errors.