GET https://dev3.observatoire-fauna.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFauna%255CPortailController%253A%253Ames…

Response
200 OK
IP
216.73.216.214
Profiled on
Token
e99b19

Query Metrics

9 Database Queries
8 Different statements
66.05 ms Query time
0 Invalid entities
509 Managed entities

Queries

Group similar statements

#▲ Time Info
1 35.15 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.13 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.groupe_ecologique_ou_geologique AS groupe_ecologique_ou_geologique_8, t0.precision_cible_geographique AS precision_cible_geographique_9, t0.date_creation_metadonnee AS date_creation_metadonnee_10, t0.date_mise_a_jour_metadonnee AS date_mise_a_jour_metadonnee_11, t0.date_envoi_inpn AS date_envoi_inpn_12, t0.ouverture_publique AS ouverture_publique_13, t0.id_ca_valide AS id_ca_valide_14, t0.type_financement AS type_financement_15, t0.niveau_territorial AS niveau_territorial_16, t0.id_numerisateur AS id_numerisateur_17, t0.organisme_gestionnaire AS organisme_gestionnaire_18, t0.id_statut_metadonnee AS id_statut_metadonnee_19, t20.id AS id_21, t20.nb_obs AS nb_obs_22, t20.nb_obs_presence AS nb_obs_presence_23, t20.date_max AS date_max_24, t20.envelope_geojson AS envelope_geojson_25, t20.date_derniere_creation_donnee AS date_derniere_creation_donnee_26, t20.date_derniere_modif_donnee AS date_derniere_modif_donnee_27, t20.id_ca AS id_ca_28, t29.id AS id_30, t29.nb_obs AS nb_obs_31, t29.nb_obs_presence AS nb_obs_presence_32, t29.date_max AS date_max_33, t29.envelope_geojson AS envelope_geojson_34, t29.id_ca AS id_ca_35 FROM ipn_catalogue_connaissance_2017.ca t0 LEFT JOIN ipn_descripteurs_occurrence_sinp_valide_v2.ca t20 ON t20.id_ca = t0.id_ca LEFT JOIN ipn_descripteurs_general_v2.ca t29 ON t29.id_ca = t0.id_ca WHERE t0.id_ca = ?
Parameters: 
[
  "2627"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.14 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 2.33 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 0.98 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 0.72 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 20.76 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 1.00 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 0.86 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\JDD\CadreAcquisition 1
App\Entity\JDD\TypeFinancement 1
App\Entity\JDD\NiveauTerritorial 1
App\Entity\User 1
App\Entity\Organisme 1
App\Entity\JDD\StatutMetadonnee 1
App\Entity\JDD\VMSyntheseCA 1
App\Entity\JDD\VMSyntheseCATotal 1

Entities Mapping

Class Mapping errors
App\Entity\ReferentielCarto\Departement No errors.
App\Entity\JDD\CadreAcquisition No errors.
App\Entity\JDD\TypeFinancement No errors.
App\Entity\JDD\NiveauTerritorial No errors.
App\Entity\User No errors.
App\Entity\Organisme No errors.
App\Entity\JDD\StatutMetadonnee No errors.
App\Entity\JDD\VMSyntheseCA No errors.
App\Entity\JDD\VMSyntheseCATotal No errors.
App\Entity\JDD\CibleGeographique No errors.
App\Entity\JDD\TypeDispositif No errors.
App\Entity\JDD\VoletSINP No errors.
App\Entity\JDD\CadreAcquisitionPublication No errors.
App\Entity\JDD\CadreAcquisitionContact No errors.
App\Entity\JDD\JDD No errors.
App\Entity\JDD\CadreAcquisitionOrganismeAutorise 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\Taxonomie\TaxrefLast No errors.
App\Entity\Donnees\StatutPresence No errors.
App\Entity\ReferentielCarto\PNR No errors.
App\Entity\OrganismesUser 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\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\JDD\RoleActeur 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\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\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\Taxonomie\TaxrefLastHabitat No errors.
App\Entity\ReferentielTaxo\TaxonEvalue No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvalue No errors.
App\Entity\ReferentielTaxo\AdminTaxonEtat No errors.
App\Entity\Photo\Photo No errors.
App\Entity\Taxonomie\TaxrefAPIPhoto No errors.
App\Entity\ReferentielTaxo\TaxonPNA No errors.
App\Entity\Sensibilite\TaxonSensible 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\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\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\ReleveLocalisationCalcule No errors.
App\Entity\Donnees\CorrespondanceReleveAttributDonnee No errors.
App\Entity\JDD\BaseDeDonneesContact No errors.
App\Entity\Donnees\CorrespondanceAttributFormatDonnees No errors.
App\Entity\Donnees\FormatDonneesDescriptif No errors.
App\Entity\ReferentielTaxo\AdminInteractionCommentaireForum No errors.
App\Entity\ReferentielTaxo\AdminRefNiveauAvancementStatut 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\Photo\Licence No errors.
App\Entity\Photo\StatutPhoto No errors.
App\Entity\ReferentielTaxo\TypeStatut No errors.
App\Entity\Sensibilite\NiveauSensibilite No errors.
App\Entity\ReferentielTaxo\TypeReglementation No errors.
App\Entity\ListeRouge\Categorie No errors.
App\Entity\Validation\CritereDifficulte No errors.