GET https://dev3.observatoire-fauna.fr/programmes/sinp/rechercher-observations?cdRefs%5B0%5D=1040529&echelleRestitution=maille10&statutsPresenceID%5B0%5D=1

Response
200 OK
IP
216.73.216.40
Profiled on
Token
1083d2

Query Metrics

9 Database Queries
8 Different statements
88.57 ms Query time
0 Invalid entities
510 Managed entities

Queries

Group similar statements

#▲ Time Info
1 39.74 ms 
SELECT t0.code_dept AS code_dept_1, t0.the_geom AS the_geom_2, t0.nom_dept AS nom_dept_3, t0.code_region AS code_region_4, t0.regions AS regions_5 FROM ipn_carto.departement t0 WHERE t0.code_region = ? ORDER BY t0.nom_dept ASC
Parameters: 
[
  "75"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 3.21 ms 
SELECT t0.cd_nom AS cd_nom_1, t0.cd_ref AS cd_ref_2, t0.lb_nom AS lb_nom_3, t0.lb_auteur AS lb_auteur_4, t0.nom_vern AS nom_vern_5, t0.premier_nom_vern AS premier_nom_vern_6, t0.nom_valide AS nom_valide_7, t0.rang AS rang_8, t0.embranchement AS embranchement_9, t0.classe AS classe_10, t0.ordre AS ordre_11, t0.famille AS famille_12, t0.version AS version_13, t0.presence_metropole AS presence_metropole_14, t0.icone AS icone_15, t0.cd_espece AS cd_espece_16, t0.taxons_superieurs AS taxons_superieurs_17, t0.groupes_usuels AS groupes_usuels_18, t0.groupes_fonctionnels AS groupes_fonctionnels_19, t0.cd_nom AS cd_nom_20, t0.cd_nom AS cd_nom_21, t0.cd_ref AS cd_ref_22, t0.rang AS rang_23, t0.habitat AS habitat_24, t0.cd_nom AS cd_nom_25, t0.cd_nom AS cd_nom_26, t0.cd_nom AS cd_nom_27, t0.cd_nom AS cd_nom_28 FROM ipn_taxonomie.vm_taxref_last t0 WHERE t0.cd_nom IN (?)
Parameters: 
[
  "1040529"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 5.84 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 4.56 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 3.15 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 3.00 ms 
SELECT t0.id_statut AS id_statut_1, t0.libelle AS libelle_2, t0.description AS description_3 FROM ipn_donnees.ref_statut_presence t0 WHERE t0.id_statut IN (?, ?) ORDER BY t0.id_statut ASC
Parameters: 
[
  1
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
7 22.81 ms 
SELECT t0.id_mnhn AS id_mnhn_1, t0.the_geom AS the_geom_2, t0.nom AS nom_3 FROM ipn_carto.pnr t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8 5.24 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
]
View formatted query    View runnable query    Explain query    View query backtrace
9 1.02 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\ReferentielCarto\Departement 12
App\Entity\ReferentielCarto\PNR 5
App\Entity\Donnees\StatutPresence 2
App\Entity\Taxonomie\TaxrefLast 1
App\Entity\Taxonomie\CdRefAutocompletion 1
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional 1
App\Entity\Taxonomie\RefRangTaxonomique 1
App\Entity\Taxonomie\TaxrefLastHabitat 1
App\Entity\ReferentielTaxo\TaxonEvalue 1
App\Entity\ReferentielTaxo\AdminTaxonEvalue 1
App\Entity\ReferentielTaxo\AdminTaxonEtat 1
App\Entity\Sensibilite\TaxonSensible 1

Entities Mapping

Class Mapping errors
App\Entity\ReferentielCarto\Departement No errors.
App\Entity\Taxonomie\TaxrefLast No errors.
App\Entity\Taxonomie\CdRefAutocompletion No errors.
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional 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\ReferentielCarto\EnvironnementCarto No errors.
App\Entity\ReferentielCarto\EnvironnementCartoCorrFondPlan No errors.
App\Entity\ReferentielCarto\EnvironnementCartoFondPlanDisponible No errors.
App\Entity\Taxonomie\GroupeUsuel No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General No errors.
App\Entity\Donnees\StatutPresence No errors.
App\Entity\ReferentielCarto\PNR No errors.
App\Entity\OrganismesUser No errors.
App\Entity\User No errors.
App\Entity\Organisme 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\Donnees\AttributNomenclature No errors.
App\Entity\Validation\CritereDifficulte 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\ReferentielCarto\ZonageMarin No errors.
App\Entity\ReferentielTaxo\Exotiques\Reproduction No errors.
App\Entity\ReferentielTaxo\Exotiques\Tendance No errors.
App\Entity\ReferentielTaxo\Exotiques\TypeIntroduction No errors.
App\Entity\ReferentielTaxo\Exotiques\ImpactHabitat No errors.
App\Entity\ReferentielTaxo\Exotiques\ImpactIndigenes No errors.
App\Entity\ReferentielTaxo\Exotiques\Raison No errors.
App\Entity\ReferentielTaxo\Exotiques\Origine No errors.
App\Entity\Donnees\AttributVersion 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\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.
App\Entity\Donnees\Attribut No errors.
App\Entity\Projet\Type No errors.
App\Entity\Projet\CorrProjetIndicateurEnDirect No errors.
App\Entity\Projet\CorrProjetIndicateur No errors.
App\Entity\Projet\Version No errors.
App\Entity\Projet\RefTypeMajDonnees No errors.
App\Entity\DemandeDonnees\StatutDemande No errors.
App\Entity\DemandeDonnees\FiltreTaxons No errors.
App\Entity\DemandeDonnees\DemandeTaxonsSup No errors.
App\Entity\DemandeDonnees\TypeProjet No errors.
App\Entity\JDD\StatutMetadonnee No errors.
App\Entity\JDD\ProcessusCollecte No errors.
App\Entity\JDD\StatutDS No errors.
App\Entity\JDD\FloutageProducteur No errors.
App\Entity\JDD\TypeDonnees No errors.
App\Entity\JDD\DiffusionJDD No errors.
App\Entity\JDD\CibleGeographique No errors.
App\Entity\JDD\MethodeRecueil No errors.
App\Entity\JDD\JDDProtocole No errors.
App\Entity\Donnees\Releve No errors.
App\Entity\JDD\BaseDeDonnees 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\JDD\VMSyntheseJDD No errors.
App\Entity\JDD\VMSyntheseJDDTotal No errors.
App\Entity\UtilisateurEtOrganisme\CorrUserJDDEnquete No errors.
App\Entity\UtilisateurEtOrganisme\CorrUserDefautJDDSaisie No errors.
App\Entity\Donnees\FormatDonnees No errors.
App\Entity\JDD\TypeFinancement No errors.
App\Entity\JDD\NiveauTerritorial No errors.
App\Entity\JDD\TypeDispositif No errors.
App\Entity\JDD\VoletSINP No errors.
App\Entity\JDD\CadreAcquisitionPublication No errors.
App\Entity\JDD\CadreAcquisitionOrganismeAutorise No errors.
App\Entity\JDD\VMSyntheseCA No errors.
App\Entity\JDD\VMSyntheseCATotal No errors.