GET https://dev1.observatoire-fauna.fr/programmes/referentiel-especes/rechercher-especes

Query Metrics

18 Database Queries
16 Different statements
20.08 ms Query time
0 Invalid entities
548 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.48 ms
(27.29%)
2
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:
[]
2.24 ms
(11.15%)
1
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, g1_.nb_especes AS nb_especes_5, g1_.nb_especes_evaluees AS nb_especes_evaluees_6, g1_.nb_proteges AS nb_proteges_7, g1_.nb_menaces AS nb_menaces_8, g1_.nb_exotiques AS nb_exotiques_9 FROM ipn_taxonomie.groupes_usuels g0_ INNER JOIN ipn_descripteurs_occurrence_sinp_valide_v2.groupe_usuel g1_ ON g0_.gid = g1_.groupe_usuel ORDER BY g0_.ordre ASC
Parameters:
[]
1.85 ms
(9.21%)
2
SELECT t0.id AS id_1, t0.libelle_court AS libelle_court_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.echelle AS echelle_5, t0.couleur AS couleur_6, t0.couleur_texte AS couleur_texte_7 FROM ipn_referentiel_taxo_v2.ref_statut_presence t0 WHERE t0.echelle IN (?, ?) ORDER BY t0.id ASC
Parameters:
[
  "all"
  "reg"
]
1.30 ms
(6.49%)
1
SELECT
                    s.*,
                    t.*
                FROM referentiels_inpn.bdc_sources_reglementations s
                JOIN ipn_referentiel_taxo_v2.ref_type_reglementation t ON s.ref_type = t.libelle_court
                ORDER BY s.type
Parameters:
[]
1.10 ms
(5.46%)
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
]
1.08 ms
(5.37%)
1
SELECT d0_.code_dept AS code_dept_0, d0_.nom_dept AS nom_dept_1, d0_.code_region AS code_region_2, d0_.regions AS regions_3 FROM ipn_carto.departement d0_ WHERE d0_.code_region = '75' ORDER BY d0_.nom_dept ASC
Parameters:
[]
0.93 ms
(4.66%)
1
SELECT t0.gid AS gid_1, t0.libelle_item AS libelle_item_2, t0.libelle_uri AS libelle_uri_3, t0.resume AS resume_4, t0.icone AS icone_5, t0.portail_ouvert AS portail_ouvert_6, t0.portail_restreint_users AS portail_restreint_users_7, t0.code_machine AS code_machine_8 FROM ipn_taxonomie.groupes_fonctionnels t0
Parameters:
[]
0.85 ms
(4.23%)
1
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:
[]
0.82 ms
(4.09%)
1
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 WHERE t0.groupe_usuel = ?
Parameters:
[
  2
]
0.82 ms
(4.06%)
1
SELECT t0.pid AS pid_1, t0.credits AS credits_2, t0.description AS description_3, t0.nom_fichier AS nom_fichier_4, t0.photo_ref AS photo_ref_5, t0.date_creation AS date_creation_6, t0.date_revision AS date_revision_7, t0.cd_ref AS cd_ref_8, t0.id_numerisateur AS id_numerisateur_9, t0.id_licence AS id_licence_10, t0.id_statut AS id_statut_11, t0.gestionnaire AS gestionnaire_12 FROM ipn_photo.photo_taxon t0 WHERE t0.pid = ?
Parameters:
[
  737
]
0.79 ms
(3.95%)
1
SELECT t0.hid AS hid_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.milieu_generique AS milieu_generique_4 FROM ipn_taxonomie.vm_taxref_last_habitats t0 ORDER BY t0.libelle ASC
Parameters:
[]
0.60 ms
(3.00%)
1
SELECT t0.cd_type_statut AS cd_type_statut_1, t0.libelle AS libelle_2, t0.regroupement AS regroupement_3 FROM referentiels_inpn.bdc_types_statut t0 WHERE t0.cd_type_statut IN (?, ?)
Parameters:
[
  "exPNA"
  "PNA"
]
0.58 ms
(2.90%)
1
SELECT t0.id AS id_1, t0.libelle_court AS libelle_court_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.couleur_texte AS couleur_texte_6, t0.ordre AS ordre_7, t0.libelle_introduction AS libelle_introduction_8 FROM ipn_referentiel_taxo_v2.ref_indigenat_regional t0 ORDER BY t0.id ASC
Parameters:
[]
0.57 ms
(2.82%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_court AS libelle_court_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.couleur_texte AS couleur_texte_6 FROM ipn_referentiel_taxo_v2.ref_statut_endemisme t0 ORDER BY t0.id ASC
Parameters:
[]
0.57 ms
(2.82%)
1
SELECT r0_.id_categorie AS id_categorie_0, r0_.libelle AS libelle_1 FROM ipn_liste_rouge.ref_categorie_liste_rouge r0_ WHERE r0_.id_categorie IN ('CR', 'EN', 'VU', 'NT', 'LC', 'DD', 'NA', 'EX', 'RE', 'EW')
Parameters:
[]
0.50 ms
(2.49%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3 FROM ipn_referentiel_taxo_v2.ref_statut_enjeu t0 ORDER BY t0.id ASC
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\Taxonomie\GroupeUsuel 241
App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General 241
App\Entity\ReferentielTaxo\StatutPresence 14
App\Entity\ReferentielTaxo\StatutEndemisme 11
App\Entity\ListeRouge\Categorie 10
App\Entity\Taxonomie\TaxrefLastHabitat 8
App\Entity\ReferentielTaxo\StatutEnjeu 8
App\Entity\ReferentielTaxo\StatutIndigenatRegional 7
App\Entity\ReferentielTaxo\TypeStatut 2
App\Entity\Taxonomie\GroupeFonctionnel 1
App\Entity\Photo\Photo 1
App\Entity\Taxonomie\TaxrefLast 1
App\Entity\User 1
App\Entity\Photo\Licence 1
App\Entity\Photo\StatutPhoto 1

Entities Mapping

Class Mapping errors
App\Entity\Taxonomie\GroupeUsuel No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General No errors.
App\Entity\Taxonomie\TaxrefLast No errors.
App\Entity\Taxonomie\TaxrefLastHabitat No errors.
App\Entity\Taxonomie\GroupeFonctionnel No errors.
App\Entity\ReferentielTaxo\StatutPresence No errors.
App\Entity\ReferentielCarto\Departement No errors.
App\Entity\ReferentielTaxo\StatutIndigenatRegional No errors.
App\Entity\ReferentielTaxo\StatutEndemisme No errors.
App\Entity\ReferentielTaxo\TaxonReglemente No errors.
App\Entity\ListeRouge\Categorie No errors.
App\Entity\ReferentielTaxo\StatutEnjeu No errors.
App\Entity\ReferentielTaxo\TypeStatut No errors.
App\Entity\Photo\Photo No errors.
App\Entity\User No errors.
App\Entity\Photo\Licence No errors.
App\Entity\Photo\StatutPhoto No errors.
App\Entity\OrganismesUser No errors.
App\Entity\Organisme No errors.
App\Entity\Taxonomie\CdRefAutocompletion No errors.
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional 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\Taxonomie\RefRangTaxonomique No errors.
App\Entity\ReferentielTaxo\TaxonEvalue No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvalue No errors.
App\Entity\ReferentielTaxo\AdminTaxonEtat No errors.
App\Entity\Taxonomie\TaxrefAPIPhoto No errors.
App\Entity\ReferentielTaxo\TaxonPNA No errors.
App\Entity\Sensibilite\TaxonSensible 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\ReferentielTaxo\TypeReglementation 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\RolesOrganismes No errors.
App\Entity\DemandeDonnees\DemandeUtilisateursAutorise 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\JDDContactDonnees No errors.
App\Entity\JDD\CadreAcquisitionContact No errors.
App\Entity\TypeOrganisme No errors.
App\Entity\TypeFriendlyOrganisme No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\Contributeur No errors.
App\Entity\Organisme\SuperviseurHabilitation No errors.
App\Entity\CertificatDepot\CertificatDepot No errors.
App\Entity\ReferentielTaxo\AdminInteractionCommentaireForum No errors.
App\Entity\ReferentielTaxo\AdminRefNiveauAvancementStatut 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\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\Donnees\AttributNomenclature No errors.
App\Entity\Validation\CritereDifficulte No errors.
App\Entity\Droits\Role No errors.
App\Entity\Projet\Projet No errors.
App\Entity\RoleOrganisme No errors.
App\Entity\DemandeDonnees\Demande 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\GEMAPI No errors.
App\Entity\JDD\JDD No errors.
App\Entity\JDD\RoleActeur No errors.
App\Entity\JDD\CadreAcquisition No errors.