Query Metrics
34
Database Queries
22
Different statements
125.04 ms
Query time
0
Invalid entities
2772
Managed entities
Queries
| #▲ | 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 |