Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

11.25 ms Query time

0 Invalid entities

8 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.74 ms
(51.03%)

SELECT v0_.cd_nom AS cd_nom_0, v0_.cd_ref AS cd_ref_1, v0_.lb_nom AS lb_nom_2, v0_.lb_auteur AS lb_auteur_3, v0_.nom_vern AS nom_vern_4, v0_.premier_nom_vern AS premier_nom_vern_5, v0_.nom_valide AS nom_valide_6, v0_.rang AS rang_7, v0_.embranchement AS embranchement_8, v0_.classe AS classe_9, v0_.ordre AS ordre_10, v0_.famille AS famille_11, v0_.version AS version_12, v0_.presence_metropole AS presence_metropole_13, v0_.icone AS icone_14, v0_.cd_espece AS cd_espece_15, v0_.taxons_superieurs AS taxons_superieurs_16, v0_.groupes_usuels AS groupes_usuels_17, v0_.groupes_fonctionnels AS groupes_fonctionnels_18, t1_.cd_ref AS cd_ref_19, t1_.date_creation AS date_creation_20, t1_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_21, t1_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_22, t1_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_23, t1_.source_indice_distribution_regionale AS source_indice_distribution_regionale_24, t1_.pra AS pra_25, t2_.cd_ref AS cd_ref_26, t2_.liste_eee_france AS liste_eee_france_27, t2_.annexe_eee_france AS annexe_eee_france_28, t2_.liste_eee_ue AS liste_eee_ue_29, t2_.liste_eee_top100_mondial AS liste_eee_top100_mondial_30, t2_.mesures_gestion AS mesures_gestion_31, v3_.cd_ref AS cd_ref_32, v3_.text AS text_33, v3_.departements AS departements_34, v3_.ref_objet_denombrement AS ref_objet_denombrement_35, v3_.ref_stade_de_vie AS ref_stade_de_vie_36, v3_.ref_statut_biologique AS ref_statut_biologique_37, v3_.ref_processus_observation AS ref_processus_observation_38, v3_.ref_comportement AS ref_comportement_39, v3_.ref_nidification AS ref_nidification_40, v0_.cd_nom AS cd_nom_41, v0_.cd_nom AS cd_nom_42, v0_.cd_ref AS cd_ref_43, v0_.rang AS rang_44, v0_.habitat AS habitat_45, v0_.cd_nom AS cd_nom_46, v0_.cd_nom AS cd_nom_47, v0_.cd_nom AS cd_nom_48, v0_.cd_nom AS cd_nom_49, t1_.id_numerisateur AS id_numerisateur_50, t1_.statut_presence_regionale AS statut_presence_regionale_51, t1_.statut_indigenat_regional AS statut_indigenat_regional_52, t1_.statut_endemisme AS statut_endemisme_53, t1_.statut_rarete AS statut_rarete_54, t1_.enjeu AS enjeu_55, t1_.cd_ref AS cd_ref_56, t2_.reproduction AS reproduction_57, t2_.tendance AS tendance_58, t2_.type_introduction AS type_introduction_59, v3_.niveau_sensibilite_defaut AS niveau_sensibilite_defaut_60, v3_.niveau_sensibilite_criteres AS niveau_sensibilite_criteres_61 FROM ipn_taxonomie.vm_taxref_last v0_ INNER JOIN ipn_requeteur_v3.referentiel_espece r4_ ON v0_.cd_nom = r4_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.taxons t1_ ON v0_.cd_nom = t1_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.taxons_exotiques t2_ ON t1_.cd_ref = t2_.cd_ref LEFT JOIN ipn_sensibilite.vm_taxons_sensibles_complet_avec_descendants v3_ ON v0_.cd_nom = v3_.cd_ref WHERE v0_.cd_nom = 192687

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.cd_nom AS cd_nom_0,
  v0_.cd_ref AS cd_ref_1,
  v0_.lb_nom AS lb_nom_2,
  v0_.lb_auteur AS lb_auteur_3,
  v0_.nom_vern AS nom_vern_4,
  v0_.premier_nom_vern AS premier_nom_vern_5,
  v0_.nom_valide AS nom_valide_6,
  v0_.rang AS rang_7,
  v0_.embranchement AS embranchement_8,
  v0_.classe AS classe_9,
  v0_.ordre AS ordre_10,
  v0_.famille AS famille_11,
  v0_.version AS version_12,
  v0_.presence_metropole AS presence_metropole_13,
  v0_.icone AS icone_14,
  v0_.cd_espece AS cd_espece_15,
  v0_.taxons_superieurs AS taxons_superieurs_16,
  v0_.groupes_usuels AS groupes_usuels_17,
  v0_.groupes_fonctionnels AS groupes_fonctionnels_18,
  t1_.cd_ref AS cd_ref_19,
  t1_.date_creation AS date_creation_20,
  t1_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_21,
  t1_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_22,
  t1_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_23,
  t1_.source_indice_distribution_regionale AS source_indice_distribution_regionale_24,
  t1_.pra AS pra_25,
  t2_.cd_ref AS cd_ref_26,
  t2_.liste_eee_france AS liste_eee_france_27,
  t2_.annexe_eee_france AS annexe_eee_france_28,
  t2_.liste_eee_ue AS liste_eee_ue_29,
  t2_.liste_eee_top100_mondial AS liste_eee_top100_mondial_30,
  t2_.mesures_gestion AS mesures_gestion_31,
  v3_.cd_ref AS cd_ref_32,
  v3_.text AS text_33,
  v3_.departements AS departements_34,
  v3_.ref_objet_denombrement AS ref_objet_denombrement_35,
  v3_.ref_stade_de_vie AS ref_stade_de_vie_36,
  v3_.ref_statut_biologique AS ref_statut_biologique_37,
  v3_.ref_processus_observation AS ref_processus_observation_38,
  v3_.ref_comportement AS ref_comportement_39,
  v3_.ref_nidification AS ref_nidification_40,
  v0_.cd_nom AS cd_nom_41,
  v0_.cd_nom AS cd_nom_42,
  v0_.cd_ref AS cd_ref_43,
  v0_.rang AS rang_44,
  v0_.habitat AS habitat_45,
  v0_.cd_nom AS cd_nom_46,
  v0_.cd_nom AS cd_nom_47,
  v0_.cd_nom AS cd_nom_48,
  v0_.cd_nom AS cd_nom_49,
  t1_.id_numerisateur AS id_numerisateur_50,
  t1_.statut_presence_regionale AS statut_presence_regionale_51,
  t1_.statut_indigenat_regional AS statut_indigenat_regional_52,
  t1_.statut_endemisme AS statut_endemisme_53,
  t1_.statut_rarete AS statut_rarete_54,
  t1_.enjeu AS enjeu_55,
  t1_.cd_ref AS cd_ref_56,
  t2_.reproduction AS reproduction_57,
  t2_.tendance AS tendance_58,
  t2_.type_introduction AS type_introduction_59,
  v3_.niveau_sensibilite_defaut AS niveau_sensibilite_defaut_60,
  v3_.niveau_sensibilite_criteres AS niveau_sensibilite_criteres_61
FROM
  ipn_taxonomie.vm_taxref_last v0_
  INNER JOIN ipn_requeteur_v3.referentiel_espece r4_ ON v0_.cd_nom = r4_.cd_ref
  LEFT JOIN ipn_referentiel_taxo_v2.taxons t1_ ON v0_.cd_nom = t1_.cd_ref
  LEFT JOIN ipn_referentiel_taxo_v2.taxons_exotiques t2_ ON t1_.cd_ref = t2_.cd_ref
  LEFT JOIN ipn_sensibilite.vm_taxons_sensibles_complet_avec_descendants v3_ ON v0_.cd_nom = v3_.cd_ref
WHERE
  v0_.cd_nom = 192687

SELECT v0_.cd_nom AS cd_nom_0, v0_.cd_ref AS cd_ref_1, v0_.lb_nom AS lb_nom_2, v0_.lb_auteur AS lb_auteur_3, v0_.nom_vern AS nom_vern_4, v0_.premier_nom_vern AS premier_nom_vern_5, v0_.nom_valide AS nom_valide_6, v0_.rang AS rang_7, v0_.embranchement AS embranchement_8, v0_.classe AS classe_9, v0_.ordre AS ordre_10, v0_.famille AS famille_11, v0_.version AS version_12, v0_.presence_metropole AS presence_metropole_13, v0_.icone AS icone_14, v0_.cd_espece AS cd_espece_15, v0_.taxons_superieurs AS taxons_superieurs_16, v0_.groupes_usuels AS groupes_usuels_17, v0_.groupes_fonctionnels AS groupes_fonctionnels_18, t1_.cd_ref AS cd_ref_19, t1_.date_creation AS date_creation_20, t1_.valeur_indice_distribution_regionale AS valeur_indice_distribution_regionale_21, t1_.annee_debut_indice_distribution_regionale AS annee_debut_indice_distribution_regionale_22, t1_.annee_fin_indice_distribution_regionale AS annee_fin_indice_distribution_regionale_23, t1_.source_indice_distribution_regionale AS source_indice_distribution_regionale_24, t1_.pra AS pra_25, t2_.cd_ref AS cd_ref_26, t2_.liste_eee_france AS liste_eee_france_27, t2_.annexe_eee_france AS annexe_eee_france_28, t2_.liste_eee_ue AS liste_eee_ue_29, t2_.liste_eee_top100_mondial AS liste_eee_top100_mondial_30, t2_.mesures_gestion AS mesures_gestion_31, v3_.cd_ref AS cd_ref_32, v3_.text AS text_33, v3_.departements AS departements_34, v3_.ref_objet_denombrement AS ref_objet_denombrement_35, v3_.ref_stade_de_vie AS ref_stade_de_vie_36, v3_.ref_statut_biologique AS ref_statut_biologique_37, v3_.ref_processus_observation AS ref_processus_observation_38, v3_.ref_comportement AS ref_comportement_39, v3_.ref_nidification AS ref_nidification_40, v0_.cd_nom AS cd_nom_41, v0_.cd_nom AS cd_nom_42, v0_.cd_ref AS cd_ref_43, v0_.rang AS rang_44, v0_.habitat AS habitat_45, v0_.cd_nom AS cd_nom_46, v0_.cd_nom AS cd_nom_47, v0_.cd_nom AS cd_nom_48, v0_.cd_nom AS cd_nom_49, t1_.id_numerisateur AS id_numerisateur_50, t1_.statut_presence_regionale AS statut_presence_regionale_51, t1_.statut_indigenat_regional AS statut_indigenat_regional_52, t1_.statut_endemisme AS statut_endemisme_53, t1_.statut_rarete AS statut_rarete_54, t1_.enjeu AS enjeu_55, t1_.cd_ref AS cd_ref_56, t2_.reproduction AS reproduction_57, t2_.tendance AS tendance_58, t2_.type_introduction AS type_introduction_59, v3_.niveau_sensibilite_defaut AS niveau_sensibilite_defaut_60, v3_.niveau_sensibilite_criteres AS niveau_sensibilite_criteres_61 FROM ipn_taxonomie.vm_taxref_last v0_ INNER JOIN ipn_requeteur_v3.referentiel_espece r4_ ON v0_.cd_nom = r4_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.taxons t1_ ON v0_.cd_nom = t1_.cd_ref LEFT JOIN ipn_referentiel_taxo_v2.taxons_exotiques t2_ ON t1_.cd_ref = t2_.cd_ref LEFT JOIN ipn_sensibilite.vm_taxons_sensibles_complet_avec_descendants v3_ ON v0_.cd_nom = v3_.cd_ref WHERE v0_.cd_nom = 192687;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 3551)
7	App\Repository\Taxonomie\TaxrefLastRepository->getFicheEspeceCompleteByCdRef (line 140)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 264)
9	App\Controller\ReferentielEspeces\RefTaxoController->ficheEspece (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

5.51 ms
(48.97%)

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 = ? LIMIT 1

Parameters:

[
  "192687"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?
LIMIT
  1

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 = '192687' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

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\TaxrefLast	1
App\Entity\Taxonomie\CdRefAutocompletion	1
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional	1
App\Entity\Taxonomie\RefRangTaxonomique	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\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\ReferentielTaxo\Exotiques\TaxonExotique	No errors.
App\Entity\User	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\StatutEnjeu	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\Sensibilite\NiveauSensibilite	No errors.
App\Entity\ReferentielTaxo\TaxonEvaluePresenceDepartementale	No errors.
App\Entity\ReferentielTaxo\TaxonEvaluePresenceZonageMarin	No errors.
App\Entity\ReferentielTaxo\StatutPhenologique	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\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\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\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\OrganismesUser	No errors.

Symfony Profiler

GET https://dev2.observatoire-fauna.fr/programmes/referentiel-especes/fiche-espece/192687

Configuration Settings

Theme

Page Width