Query Metrics
4
Database Queries
4
Different statements
188.88 ms
Query time
0
Invalid entities
3459
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.34 ms |
SELECT t0.id AS id_1, t0.nb_observations AS nb_observations_2, t0.nb_photos AS nb_photos_3, t0.nb_especes AS nb_especes_4, t0.nb_especes_avec_obs AS nb_especes_avec_obs_5, t0.nb_contributeurs AS nb_contributeurs_6 FROM ipn_descripteurs_occurrence_sinp_valide_v2.especes_exotiques t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 184.03 ms |
SELECT t0_.cd_ref AS cd_ref_0, t0_.date_creation AS date_creation_1, t0_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_2, t0_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_3, t0_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_4, t0_.source_indice_distribution_regionale AS source_indice_distribution_regionale_5, t0_.pra AS pra_6, v1_.cd_nom AS cd_nom_7, v1_.cd_ref AS cd_ref_8, v1_.lb_nom AS lb_nom_9, v1_.lb_auteur AS lb_auteur_10, v1_.nom_vern AS nom_vern_11, v1_.premier_nom_vern AS premier_nom_vern_12, v1_.nom_valide AS nom_valide_13, v1_.rang AS rang_14, v1_.embranchement AS embranchement_15, v1_.classe AS classe_16, v1_.ordre AS ordre_17, v1_.famille AS famille_18, v1_.version AS version_19, v1_.presence_metropole AS presence_metropole_20, v1_.icone AS icone_21, v1_.cd_espece AS cd_espece_22, v1_.taxons_superieurs AS taxons_superieurs_23, v1_.groupes_usuels AS groupes_usuels_24, v1_.groupes_fonctionnels AS groupes_fonctionnels_25, r2_.id AS id_26, r2_.libelle_court AS libelle_court_27, r2_.libelle AS libelle_28, r2_.description AS description_29, r2_.couleur AS couleur_30, r2_.couleur_texte AS couleur_texte_31, r2_.ordre AS ordre_32, r2_.libelle_introduction AS libelle_introduction_33, r3_.id AS id_34, r3_.libelle_court AS libelle_court_35, r3_.libelle AS libelle_36, r3_.description AS description_37, r3_.echelle AS echelle_38, r3_.couleur AS couleur_39, r3_.couleur_texte AS couleur_texte_40, r4_.id AS id_41, r4_.libelle AS libelle_42, r4_.libelle_court AS libelle_court_43, r4_.description AS description_44, r4_.couleur AS couleur_45, r4_.couleur_texte AS couleur_texte_46, r5_.id AS id_47, r5_.libelle AS libelle_48, r5_.libelle_court AS libelle_court_49, r5_.val_min AS val_min_50, r5_.val_max AS val_max_51, r5_.couleur AS couleur_52, r5_.couleur_texte AS couleur_texte_53, r6_.id AS id_54, r6_.libelle AS libelle_55, r6_.description AS description_56, t7_.cd_ref AS cd_ref_57, t7_.liste_eee_france AS liste_eee_france_58, t7_.annexe_eee_france AS annexe_eee_france_59, t7_.liste_eee_ue AS liste_eee_ue_60, t7_.liste_eee_top100_mondial AS liste_eee_top100_mondial_61, t7_.mesures_gestion AS mesures_gestion_62, r8_.id AS id_63, r8_.libelle AS libelle_64, r8_.the_geom AS the_geom_65, r8_.key AS key_66, r9_.id AS id_67, r9_.libelle AS libelle_68, r10_.id AS id_69, r10_.libelle AS libelle_70, r11_.id AS id_71, r11_.libelle AS libelle_72, r12_.id AS id_73, r12_.libelle AS libelle_74, t0_.id_numerisateur AS id_numerisateur_75, t0_.statut_presence_regionale AS statut_presence_regionale_76, t0_.statut_indigenat_regional AS statut_indigenat_regional_77, t0_.statut_endemisme AS statut_endemisme_78, t0_.statut_rarete AS statut_rarete_79, t0_.enjeu AS enjeu_80, t0_.cd_ref AS cd_ref_81, v1_.cd_nom AS cd_nom_82, v1_.cd_nom AS cd_nom_83, v1_.cd_ref AS cd_ref_84, v1_.rang AS rang_85, v1_.habitat AS habitat_86, v1_.cd_nom AS cd_nom_87, v1_.cd_nom AS cd_nom_88, v1_.cd_nom AS cd_nom_89, v1_.cd_nom AS cd_nom_90, t7_.reproduction AS reproduction_91, t7_.tendance AS tendance_92, t7_.type_introduction AS type_introduction_93 FROM ipn_referentiel_taxo_v2.taxons t0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON t0_.cd_ref = v1_.cd_nom INNER JOIN ipn_requeteur_v3.referentiel_espece r13_ ON v1_.cd_nom = r13_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.ref_indigenat_regional r2_ ON t0_.statut_indigenat_regional = r2_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_presence r3_ ON t0_.statut_presence_regionale = r3_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_endemisme r4_ ON t0_.statut_endemisme = r4_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_rarete r5_ ON t0_.statut_rarete = r5_.id LEFT JOIN ipn_referentiel_taxo_v2.ref_statut_enjeu r6_ ON t0_.enjeu = r6_.id LEFT JOIN ipn_referentiel_taxo_v2.taxons_exotiques t7_ ON t0_.cd_ref = t7_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_origine i14_ ON t7_.cd_ref = i14_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.ref_exotique_origine r8_ ON r8_.id = i14_.id_origine LEFT JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat i15_ ON t7_.cd_ref = i15_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.ref_exotique_impact_habitat r9_ ON r9_.id = i15_.id_impact_habitat LEFT JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes i16_ ON t7_.cd_ref = i16_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.ref_exotique_impact_indigenes r10_ ON r10_.id = i16_.id_impact_indigenes LEFT JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_raison i17_ ON t7_.cd_ref = i17_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.ref_exotique_raison r11_ ON r11_.id = i17_.id_raison LEFT JOIN ipn_referentiel_taxo_v2.ref_exotique_tendance r12_ ON t7_.tendance = r12_.id WHERE r13_.est_exotique = true
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 2.30 ms |
SELECT t0.groupe_usuel AS groupe_usuel_1, t0.gpe_sup AS gpe_sup_2, t0.nb_observations AS nb_observations_3, t0.nb_photos AS nb_photos_4, t0.nb_especes AS nb_especes_5, t0.nb_especes_evaluees AS nb_especes_evaluees_6, t0.nb_proteges AS nb_proteges_7, t0.nb_menaces AS nb_menaces_8, t0.nb_exotiques AS nb_exotiques_9, t0.nb_introduites AS nb_introduites_10, t0.nb_contributeurs AS nb_contributeurs_11, t12.gid AS gid_13, t12.libelle_item AS libelle_item_14, t12.icone AS icone_15, t12.libelle_uri AS libelle_uri_16, t12.cd_ref_gpes AS cd_ref_gpes_17, t12.gpe_sup AS gpe_sup_18, t12.code_machine AS code_machine_19, t12.resume AS resume_20, t12.ordre AS ordre_21, t12.portail_ouvert AS portail_ouvert_22, t12.classes_richesse AS classes_richesse_23, t12.classes_pression_obs AS classes_pression_obs_24, t12.portail_restreint_users AS portail_restreint_users_25, t12.gid AS gid_26 FROM ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel t0 LEFT JOIN ipn_taxonomie.groupes_usuels t12 ON t12.gid = t0.groupe_usuel
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 1.22 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\ReferentielTaxo\TaxonEvalue | 366 |
| App\Entity\Taxonomie\TaxrefLast | 366 |
| App\Entity\Taxonomie\CdRefAutocompletion | 366 |
| App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional | 366 |
| App\Entity\ReferentielTaxo\AdminTaxonEvalue | 366 |
| App\Entity\ReferentielTaxo\AdminTaxonEtat | 366 |
| App\Entity\Sensibilite\TaxonSensible | 366 |
| App\Entity\ReferentielTaxo\Exotiques\TaxonExotique | 344 |
| App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General | 241 |
| App\Entity\Taxonomie\GroupeUsuel | 241 |
| App\Entity\ReferentielTaxo\Exotiques\Origine | 9 |
| App\Entity\ReferentielTaxo\Exotiques\Raison | 9 |
| App\Entity\Taxonomie\TaxrefLastHabitat | 8 |
| App\Entity\ReferentielTaxo\StatutPresence | 6 |
| App\Entity\ReferentielTaxo\Exotiques\ImpactHabitat | 6 |
| App\Entity\ReferentielTaxo\Exotiques\ImpactIndigenes | 6 |
| App\Entity\ReferentielTaxo\Exotiques\Tendance | 6 |
| App\Entity\User | 4 |
| App\Entity\ReferentielTaxo\Exotiques\TypeIntroduction | 4 |
| App\Entity\ReferentielTaxo\StatutIndigenatRegional | 3 |
| App\Entity\ReferentielTaxo\Exotiques\Reproduction | 3 |
| App\Entity\ReferentielTaxo\StatutEnjeu | 2 |
| App\Entity\ReferentielTaxo\StatutRarete | 2 |
| App\Entity\Indicateurs\Donnees\OccSINPValide\EspecesExotiques\General | 1 |
| App\Entity\Taxonomie\RefRangTaxonomique | 1 |
| App\Entity\ReferentielTaxo\StatutEndemisme | 1 |