Symfony Profiler

Query Metrics

35 Database Queries

33 Different statements

106.21 ms Query time

0 Invalid entities

54 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

48.24 ms
(45.42%)

SELECT
				row_number() OVER () as id_unique,
				c.nb_obs,
				c.anciennete,
				ST_AsGeoJSON(ST_Transform(c.the_geom,3857::int),0,0) as geojson
			FROM ipn_requeteur_v3.carte_maille10_par_espece c
			WHERE cd_ref = 224041;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  row_number() OVER () as id_unique,
  c.nb_obs,
  c.anciennete,
  ST_AsGeoJSON(
    ST_Transform(c.the_geom, 3857 :: int),
    0,
    0
  ) as geojson
FROM
  ipn_requeteur_v3.carte_maille10_par_espece c
WHERE
  cd_ref = 224041;

SELECT
				row_number() OVER () as id_unique,
				c.nb_obs,
				c.anciennete,
				ST_AsGeoJSON(ST_Transform(c.the_geom,3857::int),0,0) as geojson
			FROM ipn_requeteur_v3.carte_maille10_par_espece c
			WHERE cd_ref = 224041;
		;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 3524)
2	App\Repository\Taxonomie\TaxrefLastRepository->getCartoMailleByEspece (line 181)
3	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
4	App\Controller\PortailExotique\PortailController->especes (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

11.56 ms
(10.89%)

SELECT e0_.cd_espece AS cd_espece_0, e0_.annee AS annee_1, e0_.nb_obs AS nb_obs_2, e0_.nb_obs_occ AS nb_obs_occ_3, e0_.nb_obs_synth AS nb_obs_synth_4 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_ WHERE e0_.cd_espece = 224041 ORDER BY e0_.annee ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.cd_espece AS cd_espece_0,
  e0_.annee AS annee_1,
  e0_.nb_obs AS nb_obs_2,
  e0_.nb_obs_occ AS nb_obs_occ_3,
  e0_.nb_obs_synth AS nb_obs_synth_4
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_
WHERE
  e0_.cd_espece = 224041
ORDER BY
  e0_.annee ASC

SELECT e0_.cd_espece AS cd_espece_0, e0_.annee AS annee_1, e0_.nb_obs AS nb_obs_2, e0_.nb_obs_occ AS nb_obs_occ_3, e0_.nb_obs_synth AS nb_obs_synth_4 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_ WHERE e0_.cd_espece = 224041 ORDER BY e0_.annee ASC;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 32)
7	App\Repository\Indicateurs\Donnees\EspecesParAnneeObservationRepository->getNombreObservationsParAnneeByEspece (line 172)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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)

6.86 ms
(6.46%)

SELECT e0_.cd_espece AS cd_espece_0, e0_.nb_obs_presence AS nb_obs_presence_1, e0_.nb_communes_presence AS nb_communes_presence_2, e0_.nb_communes_total AS nb_communes_total_3, e0_.nb_maille5_presence AS nb_maille5_presence_4, e0_.nb_jdd_presence AS nb_jdd_presence_5, d1_.code_dept AS code_dept_6, d1_.nom_dept AS nom_dept_7, e0_.departement AS departement_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_departements e0_ INNER JOIN ipn_carto.departement d1_ ON e0_.departement = d1_.code_dept WHERE e0_.cd_espece = 224041

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.cd_espece AS cd_espece_0,
  e0_.nb_obs_presence AS nb_obs_presence_1,
  e0_.nb_communes_presence AS nb_communes_presence_2,
  e0_.nb_communes_total AS nb_communes_total_3,
  e0_.nb_maille5_presence AS nb_maille5_presence_4,
  e0_.nb_jdd_presence AS nb_jdd_presence_5,
  d1_.code_dept AS code_dept_6,
  d1_.nom_dept AS nom_dept_7,
  e0_.departement AS departement_8
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_departements e0_
  INNER JOIN ipn_carto.departement d1_ ON e0_.departement = d1_.code_dept
WHERE
  e0_.cd_espece = 224041

SELECT e0_.cd_espece AS cd_espece_0, e0_.nb_obs_presence AS nb_obs_presence_1, e0_.nb_communes_presence AS nb_communes_presence_2, e0_.nb_communes_total AS nb_communes_total_3, e0_.nb_maille5_presence AS nb_maille5_presence_4, e0_.nb_jdd_presence AS nb_jdd_presence_5, d1_.code_dept AS code_dept_6, d1_.nom_dept AS nom_dept_7, e0_.departement AS departement_8 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_departements e0_ INNER JOIN ipn_carto.departement d1_ ON e0_.departement = d1_.code_dept WHERE e0_.cd_espece = 224041;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 37)
7	App\Repository\Indicateurs\Donnees\ChiffresClesObsOccSINPParEspeceEtDepartementRepository->getSeriesChiffresClesParDepartementByEspece (line 177)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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.73 ms
(5.39%)

SELECT e0_.cd_espece AS cd_espece_0, e0_.mois AS mois_1, e0_.nb_obs AS nb_obs_2 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_ WHERE e0_.cd_espece = 224041

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.cd_espece AS cd_espece_0,
  e0_.mois AS mois_1,
  e0_.nb_obs AS nb_obs_2
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_
WHERE
  e0_.cd_espece = 224041

SELECT e0_.cd_espece AS cd_espece_0, e0_.mois AS mois_1, e0_.nb_obs AS nb_obs_2 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_mois_obs_presence e0_ WHERE e0_.cd_espece = 224041;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 31)
7	App\Repository\Indicateurs\Donnees\EspecesParMoisObservationRepository->getNombreObservationsParMoisByEspece (line 171)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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)

4.22 ms
(3.97%)

SELECT t0.cd_ref AS cd_ref_1, t0.categorie AS categorie_2, t0.emprise AS emprise_3, t0.region AS region_4, t0.source AS source_5, t0.source_friendly AS source_friendly_6, t0.population AS population_7, t0.particularite AS particularite_8, t0.nom_cite AS nom_cite_9, t0.cd_ref AS cd_ref_10, t0.categorie AS categorie_11, t12.id_categorie AS id_categorie_13, t12.libelle AS libelle_14 FROM ipn_referentiel_taxo_v2.taxons_statuts_liste_rouge t0 INNER JOIN ipn_liste_rouge.ref_categorie_liste_rouge t12 ON t0.categorie = t12.id_categorie WHERE t0.cd_ref = ? ORDER BY t0.particularite DESC

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.cd_ref AS cd_ref_1,
  t0.categorie AS categorie_2,
  t0.emprise AS emprise_3,
  t0.region AS region_4,
  t0.source AS source_5,
  t0.source_friendly AS source_friendly_6,
  t0.population AS population_7,
  t0.particularite AS particularite_8,
  t0.nom_cite AS nom_cite_9,
  t0.cd_ref AS cd_ref_10,
  t0.categorie AS categorie_11,
  t12.id_categorie AS id_categorie_13,
  t12.libelle AS libelle_14
FROM
  ipn_referentiel_taxo_v2.taxons_statuts_liste_rouge t0
  INNER JOIN ipn_liste_rouge.ref_categorie_liste_rouge t12 ON t0.categorie = t12.id_categorie
WHERE
  t0.cd_ref = ?
ORDER BY
  t0.particularite DESC

SELECT t0.cd_ref AS cd_ref_1, t0.categorie AS categorie_2, t0.emprise AS emprise_3, t0.region AS region_4, t0.source AS source_5, t0.source_friendly AS source_friendly_6, t0.population AS population_7, t0.particularite AS particularite_8, t0.nom_cite AS nom_cite_9, t0.cd_ref AS cd_ref_10, t0.categorie AS categorie_11, t12.id_categorie AS id_categorie_13, t12.libelle AS libelle_14 FROM ipn_referentiel_taxo_v2.taxons_statuts_liste_rouge t0 INNER JOIN ipn_liste_rouge.ref_categorie_liste_rouge t12 ON t0.categorie = t12.id_categorie WHERE t0.cd_ref = 224041 ORDER BY t0.particularite DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1142)
8	App\Entity\Taxonomie\TaxrefLast->getMenaces (line 1164)
9	App\Entity\Taxonomie\TaxrefLast->isMenace (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 67)
11	__TwigTemplate_c0ca0336c79ced2704b4184ae06499bc->doDisplay (line 388)
12	Twig\Template->yield (line 383)
13	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 227)
19	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
20	App\Controller\PortailExotique\PortailController->especes (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

3.16 ms
(2.97%)

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 = 224041

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 = 224041

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 = 224041;

#	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 3502)
7	App\Repository\Taxonomie\TaxrefLastRepository->getFicheEspeceCompleteByCdRef (line 140)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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)

2.57 ms
(2.42%)

SELECT t0.cd_espece AS cd_espece_1, t0.nb_obs_presence AS nb_obs_presence_2, t0.nb_communes_presence AS nb_communes_presence_3, t0.nb_maille5_presence AS nb_maille5_presence_4, t0.nb_maille10_presence AS nb_maille10_presence_5, t0.nb_maille10_pour_calcul_idr AS nb_maille10_pour_calcul_idr_6, t0.nb_jdd_presence AS nb_jdd_presence_7 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece t0 WHERE t0.cd_espece = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.cd_espece AS cd_espece_1,
  t0.nb_obs_presence AS nb_obs_presence_2,
  t0.nb_communes_presence AS nb_communes_presence_3,
  t0.nb_maille5_presence AS nb_maille5_presence_4,
  t0.nb_maille10_presence AS nb_maille10_presence_5,
  t0.nb_maille10_pour_calcul_idr AS nb_maille10_pour_calcul_idr_6,
  t0.nb_jdd_presence AS nb_jdd_presence_7
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece t0
WHERE
  t0.cd_espece = ?

SELECT t0.cd_espece AS cd_espece_1, t0.nb_obs_presence AS nb_obs_presence_2, t0.nb_communes_presence AS nb_communes_presence_3, t0.nb_maille5_presence AS nb_maille5_presence_4, t0.nb_maille10_presence AS nb_maille10_presence_5, t0.nb_maille10_pour_calcul_idr AS nb_maille10_pour_calcul_idr_6, t0.nb_jdd_presence AS nb_jdd_presence_7 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece t0 WHERE t0.cd_espece = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 154)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 173)
7	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
8	App\Controller\PortailExotique\PortailController->especes (line 181)
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)

2.52 ms
(2.38%)

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

Parameters:

[
  "224041"
]

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

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 = '224041';

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

1.78 ms
(1.68%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.the_geom AS the_geom_3, t0.key AS key_4 FROM ipn_referentiel_taxo_v2.ref_exotique_origine t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_origine ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_origine.id_origine WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_origine.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.the_geom AS the_geom_3,
  t0.key AS key_4
FROM
  ipn_referentiel_taxo_v2.ref_exotique_origine t0
  INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_origine ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_origine.id_origine
WHERE
  ipn_referentiel_taxo_v2.corr_taxon_exotique_origine.cd_ref = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.the_geom AS the_geom_3, t0.key AS key_4 FROM ipn_referentiel_taxo_v2.ref_exotique_origine t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_origine ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_origine.id_origine WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_origine.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 685)
9	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 227)
17	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
18	App\Controller\PortailExotique\PortailController->especes (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.76 ms
(1.65%)

SELECT t0.cd_ref AS cd_ref_1, t0.cd_reglementation AS cd_reglementation_2, t0.cd_doc AS cd_doc_3, t0.libelle_friendly AS libelle_friendly_4, t0.article AS article_5, t0.href_publication AS href_publication_6, t0.type AS type_7, t0.cd_ref AS cd_ref_8, t0.ref_type AS ref_type_9, t0.cd_type_statut AS cd_type_statut_10 FROM ipn_referentiel_taxo_v2.taxons_statuts_reglementation t0 WHERE t0.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.cd_ref AS cd_ref_1,
  t0.cd_reglementation AS cd_reglementation_2,
  t0.cd_doc AS cd_doc_3,
  t0.libelle_friendly AS libelle_friendly_4,
  t0.article AS article_5,
  t0.href_publication AS href_publication_6,
  t0.type AS type_7,
  t0.cd_ref AS cd_ref_8,
  t0.ref_type AS ref_type_9,
  t0.cd_type_statut AS cd_type_statut_10
FROM
  ipn_referentiel_taxo_v2.taxons_statuts_reglementation t0
WHERE
  t0.cd_ref = ?

SELECT t0.cd_ref AS cd_ref_1, t0.cd_reglementation AS cd_reglementation_2, t0.cd_doc AS cd_doc_3, t0.libelle_friendly AS libelle_friendly_4, t0.article AS article_5, t0.href_publication AS href_publication_6, t0.type AS type_7, t0.cd_ref AS cd_ref_8, t0.ref_type AS ref_type_9, t0.cd_type_statut AS cd_type_statut_10 FROM ipn_referentiel_taxo_v2.taxons_statuts_reglementation t0 WHERE t0.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1072)
8	App\Entity\Taxonomie\TaxrefLast->getProtections (line 1083)
9	App\Entity\Taxonomie\TaxrefLast->isProtege (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 67)
11	__TwigTemplate_c0ca0336c79ced2704b4184ae06499bc->doDisplay (line 388)
12	Twig\Template->yield (line 383)
13	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 227)
19	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
20	App\Controller\PortailExotique\PortailController->especes (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

1.63 ms
(1.54%)

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.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

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.id = ?

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.id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ReferentielTaxo\StatutPresence::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ReferentielTaxo\StatutPresence->__get (line 55)
8	App\Entity\ReferentielTaxo\StatutPresence->getLibelle (line 190)
9	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
10	App\Controller\PortailExotique\PortailController->especes (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.16 ms
(1.10%)

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:

[
  224041
]

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 = 224041 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 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 158)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 113)
7	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
8	App\Controller\PortailExotique\PortailController->especes (line 181)
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)

0.97 ms
(0.92%)

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

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

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 163)
5	App\Controller\Fauna\MenuController->menuPrincipal (line 67)
6	App\Controller\Fauna\MenuController->menu (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 466)
14	__TwigTemplate_86a391e172b7e6eb0255a9b323ad5eee->block_header (line 432)
15	Twig\Template->yieldBlock (line 122)
16	__TwigTemplate_86a391e172b7e6eb0255a9b323ad5eee->doDisplay (line 388)
17	Twig\Template->yield (line 60)
18	__TwigTemplate_94e8f62a337b18d2a26bf06e45d2d75c->doDisplay (line 388)
19	Twig\Template->yield (line 344)
20	Twig\Template->display (line 359)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 334)
23	Twig\Environment->render (line 229)
24	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
25	App\Controller\PortailExotique\PortailController->especes (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.97 ms
(0.91%)

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

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

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;

#	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 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 33)
7	App\Repository\ReferentielCarto\EnvironnementCartoRepository->getEnvironnementCartoById (line 34)
8	App\Controller\ReferentielCarto\EnvironnementCartoController->getEnvironnementDefaut (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 65)
16	__TwigTemplate_09828de23003f3aab1356affdc13ce5f->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1493)
21	Twig\Extension\CoreExtension::include (line 48)
22	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 227)
28	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
29	App\Controller\PortailExotique\PortailController->especes (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.96 ms
(0.91%)

SELECT t0.id AS id_1, t0.cd_ref AS cd_ref_2, t0.deb_possible AS deb_possible_3, t0.deb_sur AS deb_sur_4, t0.fin_sur AS fin_sur_5, t0.fin_possible AS fin_possible_6, t0.cd_ref AS cd_ref_7, t0.ref_stade AS ref_stade_8 FROM ipn_validation.corr_pheno t0 WHERE t0.cd_ref = ? ORDER BY t0.id ASC

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cd_ref AS cd_ref_2,
  t0.deb_possible AS deb_possible_3,
  t0.deb_sur AS deb_sur_4,
  t0.fin_sur AS fin_sur_5,
  t0.fin_possible AS fin_possible_6,
  t0.cd_ref AS cd_ref_7,
  t0.ref_stade AS ref_stade_8
FROM
  ipn_validation.corr_pheno t0
WHERE
  t0.cd_ref = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.cd_ref AS cd_ref_2, t0.deb_possible AS deb_possible_3, t0.deb_sur AS deb_sur_4, t0.fin_sur AS fin_sur_5, t0.fin_possible AS fin_possible_6, t0.cd_ref AS cd_ref_7, t0.ref_stade AS ref_stade_8 FROM ipn_validation.corr_pheno t0 WHERE t0.cd_ref = 224041 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 153)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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)

0.88 ms
(0.83%)

SELECT t0.id AS id_1, t0.departement AS departement_2, t0.statut_pres_dpt AS statut_pres_dpt_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxon_presence_departementale t0 WHERE t0.cd_nom = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.departement AS departement_2,
  t0.statut_pres_dpt AS statut_pres_dpt_3,
  t0.cd_nom AS cd_nom_4
FROM
  ipn_referentiel_taxo_v2.taxon_presence_departementale t0
WHERE
  t0.cd_nom = ?

SELECT t0.id AS id_1, t0.departement AS departement_2, t0.statut_pres_dpt AS statut_pres_dpt_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxon_presence_departementale t0 WHERE t0.cd_nom = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 189)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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)

0.87 ms
(0.82%)

SELECT t0.id AS id_1, t0.libelle_court AS libelle_court_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.groupes_usuels AS groupes_usuels_5 FROM ipn_referentiel_taxo_v2.ref_statut_phenologique t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique.statut_phenologique WHERE ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle_court AS libelle_court_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.groupes_usuels AS groupes_usuels_5
FROM
  ipn_referentiel_taxo_v2.ref_statut_phenologique t0
  INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique.statut_phenologique
WHERE
  ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique.cd_ref = ?

SELECT t0.id AS id_1, t0.libelle_court AS libelle_court_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.groupes_usuels AS groupes_usuels_5 FROM ipn_referentiel_taxo_v2.ref_statut_phenologique t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique.statut_phenologique WHERE ipn_referentiel_taxo_v2.corr_taxon_statut_phenologique.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 422)
10	__TwigTemplate_c0ca0336c79ced2704b4184ae06499bc->doDisplay (line 388)
11	Twig\Template->yield (line 383)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.84 ms
(0.79%)

SELECT t0.cd_ref AS cd_ref_1, t0.comparaison_autocompletion AS comparaison_autocompletion_2, t0.est_menace AS est_menace_3, t0.est_protege AS est_protege_4, t0.est_exotique AS est_exotique_5, t0.meilleure_photo_disponible AS meilleure_photo_disponible_6, t0.extension_imagine_filter AS extension_imagine_filter_7, t0.credits AS credits_8, t0.licence AS licence_9, t0.licence_url AS licence_url_10, t0.licence_libelle AS licence_libelle_11, t0.licence_version AS licence_version_12, t0.icone AS icone_13, t0.fiche_descriptive AS fiche_descriptive_14, t0.fiche_descriptive_source AS fiche_descriptive_source_15, t0.nb_obs AS nb_obs_16 FROM ipn_requeteur_v3.referentiel_espece t0 WHERE t0.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.cd_ref AS cd_ref_1,
  t0.comparaison_autocompletion AS comparaison_autocompletion_2,
  t0.est_menace AS est_menace_3,
  t0.est_protege AS est_protege_4,
  t0.est_exotique AS est_exotique_5,
  t0.meilleure_photo_disponible AS meilleure_photo_disponible_6,
  t0.extension_imagine_filter AS extension_imagine_filter_7,
  t0.credits AS credits_8,
  t0.licence AS licence_9,
  t0.licence_url AS licence_url_10,
  t0.licence_libelle AS licence_libelle_11,
  t0.licence_version AS licence_version_12,
  t0.icone AS icone_13,
  t0.fiche_descriptive AS fiche_descriptive_14,
  t0.fiche_descriptive_source AS fiche_descriptive_source_15,
  t0.nb_obs AS nb_obs_16
FROM
  ipn_requeteur_v3.referentiel_espece t0
WHERE
  t0.cd_ref = ?

SELECT t0.cd_ref AS cd_ref_1, t0.comparaison_autocompletion AS comparaison_autocompletion_2, t0.est_menace AS est_menace_3, t0.est_protege AS est_protege_4, t0.est_exotique AS est_exotique_5, t0.meilleure_photo_disponible AS meilleure_photo_disponible_6, t0.extension_imagine_filter AS extension_imagine_filter_7, t0.credits AS credits_8, t0.licence AS licence_9, t0.licence_url AS licence_url_10, t0.licence_libelle AS licence_libelle_11, t0.licence_version AS licence_version_12, t0.icone AS icone_13, t0.fiche_descriptive AS fiche_descriptive_14, t0.fiche_descriptive_source AS fiche_descriptive_source_15, t0.nb_obs AS nb_obs_16 FROM ipn_requeteur_v3.referentiel_espece t0 WHERE t0.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional->__get (line 125)
8	App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional->getMeilleurePhotoDisponible (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 202)
10	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
11	Twig\Template->yield (line 344)
12	Twig\Template->display (line 359)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 334)
15	Twig\Environment->render (line 227)
16	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
17	App\Controller\PortailExotique\PortailController->especes (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.78 ms
(0.74%)

SELECT t0.id AS id_1, t0.cd_ref AS cd_ref_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.cd_ref AS cd_ref_5, t0.ref_diff AS ref_diff_6, t0.ref_sexe AS ref_sexe_7, t0.ref_stade AS ref_stade_8, t0.ref_proc_obs AS ref_proc_obs_9, t0.ref_indice_pres AS ref_indice_pres_10 FROM ipn_validation.corr_determination t0 WHERE t0.cd_ref = ? ORDER BY t0.id ASC

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cd_ref AS cd_ref_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.cd_ref AS cd_ref_5,
  t0.ref_diff AS ref_diff_6,
  t0.ref_sexe AS ref_sexe_7,
  t0.ref_stade AS ref_stade_8,
  t0.ref_proc_obs AS ref_proc_obs_9,
  t0.ref_indice_pres AS ref_indice_pres_10
FROM
  ipn_validation.corr_determination t0
WHERE
  t0.cd_ref = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.cd_ref AS cd_ref_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.cd_ref AS cd_ref_5, t0.ref_diff AS ref_diff_6, t0.ref_sexe AS ref_sexe_7, t0.ref_stade AS ref_stade_8, t0.ref_proc_obs AS ref_proc_obs_9, t0.ref_indice_pres AS ref_indice_pres_10 FROM ipn_validation.corr_determination t0 WHERE t0.cd_ref = 224041 ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 619)
10	__TwigTemplate_c0ca0336c79ced2704b4184ae06499bc->doDisplay (line 388)
11	Twig\Template->yield (line 383)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.73 ms
(0.69%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_raison t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_raison ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_raison.id_raison WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_raison.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  ipn_referentiel_taxo_v2.ref_exotique_raison t0
  INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_raison ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_raison.id_raison
WHERE
  ipn_referentiel_taxo_v2.corr_taxon_exotique_raison.cd_ref = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_raison t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_raison ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_raison.id_raison WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_raison.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 504)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.72 ms
(0.68%)

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.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

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.cd_ref = ?

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.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 48)
10	__TwigTemplate_b92c6bd256f853aebdb31f9823a46b6b->doDisplay (line 388)
11	Twig\Template->yield (line 440)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.71 ms
(0.67%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_impact_indigenes t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes.id_impact_indigenes WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  ipn_referentiel_taxo_v2.ref_exotique_impact_indigenes t0
  INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes.id_impact_indigenes
WHERE
  ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes.cd_ref = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_impact_indigenes t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes.id_impact_indigenes WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_indigenes.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 610)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.70 ms
(0.66%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_impact_habitat t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat.id_impact_habitat WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  ipn_referentiel_taxo_v2.ref_exotique_impact_habitat t0
  INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat.id_impact_habitat
WHERE
  ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat.cd_ref = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_impact_habitat t0 INNER JOIN ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat ON t0.id = ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat.id_impact_habitat WHERE ipn_referentiel_taxo_v2.corr_taxon_exotique_impact_habitat.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 554)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.68 ms
(0.64%)

SELECT t0.cd_ref AS cd_ref_1, t0.cd_doc AS cd_doc_2, t0.libelle_friendly AS libelle_friendly_3, t0.annee_publication AS annee_publication_4, t0.source AS source_5, t0.href_publication AS href_publication_6, t0.cd_ref AS cd_ref_7, t0.cd_type_statut AS cd_type_statut_8 FROM ipn_referentiel_taxo_v2.taxons_statuts_pna t0 WHERE t0.cd_ref = ? ORDER BY t0.annee_publication DESC

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.cd_ref AS cd_ref_1,
  t0.cd_doc AS cd_doc_2,
  t0.libelle_friendly AS libelle_friendly_3,
  t0.annee_publication AS annee_publication_4,
  t0.source AS source_5,
  t0.href_publication AS href_publication_6,
  t0.cd_ref AS cd_ref_7,
  t0.cd_type_statut AS cd_type_statut_8
FROM
  ipn_referentiel_taxo_v2.taxons_statuts_pna t0
WHERE
  t0.cd_ref = ?
ORDER BY
  t0.annee_publication DESC

SELECT t0.cd_ref AS cd_ref_1, t0.cd_doc AS cd_doc_2, t0.libelle_friendly AS libelle_friendly_3, t0.annee_publication AS annee_publication_4, t0.source AS source_5, t0.href_publication AS href_publication_6, t0.cd_ref AS cd_ref_7, t0.cd_type_statut AS cd_type_statut_8 FROM ipn_referentiel_taxo_v2.taxons_statuts_pna t0 WHERE t0.cd_ref = 224041 ORDER BY t0.annee_publication DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 112)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.67 ms
(0.63%)

SELECT t0.id AS id_1, t0.zonage_marin AS zonage_marin_2, t0.statut_presence AS statut_presence_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxon_presence_zonage_marin t0 WHERE t0.cd_nom = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.zonage_marin AS zonage_marin_2,
  t0.statut_presence AS statut_presence_3,
  t0.cd_nom AS cd_nom_4
FROM
  ipn_referentiel_taxo_v2.taxon_presence_zonage_marin t0
WHERE
  t0.cd_nom = ?

SELECT t0.id AS id_1, t0.zonage_marin AS zonage_marin_2, t0.statut_presence AS statut_presence_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxon_presence_zonage_marin t0 WHERE t0.cd_nom = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 196)
8	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
9	App\Controller\PortailExotique\PortailController->especes (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)

0.65 ms
(0.62%)

SELECT t0.cd_nom AS cd_nom_1, t0.region AS region_2, t0.determinante_stricte AS determinante_stricte_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxons_statuts_determinantes_znieff t0 WHERE t0.cd_nom = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.cd_nom AS cd_nom_1,
  t0.region AS region_2,
  t0.determinante_stricte AS determinante_stricte_3,
  t0.cd_nom AS cd_nom_4
FROM
  ipn_referentiel_taxo_v2.taxons_statuts_determinantes_znieff t0
WHERE
  t0.cd_nom = ?

SELECT t0.cd_nom AS cd_nom_1, t0.region AS region_2, t0.determinante_stricte AS determinante_stricte_3, t0.cd_nom AS cd_nom_4 FROM ipn_referentiel_taxo_v2.taxons_statuts_determinantes_znieff t0 WHERE t0.cd_nom = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 113)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.64 ms
(0.61%)

SELECT t0.pid AS pid_1, t0.credits AS credits_2, t0.nom_fichier AS nom_fichier_3, t0.ecarte AS ecarte_4, t0.cd_ref AS cd_ref_5, t0.licence AS licence_6 FROM ipn_photo.photo_taxon_api_taxref t0 WHERE t0.cd_ref = ?

Parameters:

[
  224041
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.pid AS pid_1,
  t0.credits AS credits_2,
  t0.nom_fichier AS nom_fichier_3,
  t0.ecarte AS ecarte_4,
  t0.cd_ref AS cd_ref_5,
  t0.licence AS licence_6
FROM
  ipn_photo.photo_taxon_api_taxref t0
WHERE
  t0.cd_ref = ?

SELECT t0.pid AS pid_1, t0.credits AS credits_2, t0.nom_fichier AS nom_fichier_3, t0.ecarte AS ecarte_4, t0.cd_ref AS cd_ref_5, t0.licence AS licence_6 FROM ipn_photo.photo_taxon_api_taxref t0 WHERE t0.cd_ref = 224041;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 48)
10	__TwigTemplate_b92c6bd256f853aebdb31f9823a46b6b->doDisplay (line 388)
11	Twig\Template->yield (line 440)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.57 ms
(0.54%)

SELECT t0.lid AS lid_1, t0.libelle AS libelle_2, t0.url AS url_3, t0.version AS version_4, t0.licence_ouverte AS licence_ouverte_5, t0.sort AS sort_6 FROM ipn_photo.licences_cc t0 WHERE t0.lid = ?

Parameters:

[
  "BY-NC-SA"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.lid AS lid_1,
  t0.libelle AS libelle_2,
  t0.url AS url_3,
  t0.version AS version_4,
  t0.licence_ouverte AS licence_ouverte_5,
  t0.sort AS sort_6
FROM
  ipn_photo.licences_cc t0
WHERE
  t0.lid = ?

SELECT t0.lid AS lid_1, t0.libelle AS libelle_2, t0.url AS url_3, t0.version AS version_4, t0.licence_ouverte AS licence_ouverte_5, t0.sort AS sort_6 FROM ipn_photo.licences_cc t0 WHERE t0.lid = 'BY-NC-SA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Photo\Licence::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Photo\Licence->__get (line 39)
8	App\Entity\Photo\Licence->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 165)
10	__TwigTemplate_b92c6bd256f853aebdb31f9823a46b6b->doDisplay (line 388)
11	Twig\Template->yield (line 440)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.54 ms
(0.51%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_type_introduction t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  ipn_referentiel_taxo_v2.ref_exotique_type_introduction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_type_introduction t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ReferentielTaxo\Exotiques\TypeIntroduction::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ReferentielTaxo\Exotiques\TypeIntroduction->__get (line 28)
8	App\Entity\ReferentielTaxo\Exotiques\TypeIntroduction->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 725)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.53 ms
(0.50%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_tendance t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  ipn_referentiel_taxo_v2.ref_exotique_tendance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_tendance t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ReferentielTaxo\Exotiques\Tendance::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ReferentielTaxo\Exotiques\Tendance->__get (line 28)
8	App\Entity\ReferentielTaxo\Exotiques\Tendance->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 494)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.53 ms
(0.50%)

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 WHERE t0.hid = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

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
WHERE
  t0.hid = ?

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 WHERE t0.hid = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Taxonomie\TaxrefLastHabitat::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Taxonomie\TaxrefLastHabitat->__get (line 33)
8	App\Entity\Taxonomie\TaxrefLastHabitat->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 281)
10	__TwigTemplate_c0ca0336c79ced2704b4184ae06499bc->doDisplay (line 388)
11	Twig\Template->yield (line 383)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.53 ms
(0.50%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_reproduction t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  ipn_referentiel_taxo_v2.ref_exotique_reproduction t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM ipn_referentiel_taxo_v2.ref_exotique_reproduction t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ReferentielTaxo\Exotiques\Reproduction::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ReferentielTaxo\Exotiques\Reproduction->__get (line 28)
8	App\Entity\ReferentielTaxo\Exotiques\Reproduction->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 491)
10	__TwigTemplate_99446e977c571d189d24333cfe160f43->doDisplay (line 388)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.53 ms
(0.50%)

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 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

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
WHERE
  t0.id = ?

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 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\ReferentielTaxo\StatutIndigenatRegional::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ReferentielTaxo\StatutIndigenatRegional->__get (line 58)
8	App\Entity\ReferentielTaxo\StatutIndigenatRegional->getLibelle (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 366)
10	__TwigTemplate_c0ca0336c79ced2704b4184ae06499bc->doDisplay (line 388)
11	Twig\Template->yield (line 383)
12	__TwigTemplate_22557e8820795a5b0bbc202b6575ea88->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 227)
18	App\Service\Requeteurs\EspeceService->getFicheEspece (line 142)
19	App\Controller\PortailExotique\PortailController->especes (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\ReferentielTaxo\TaxonEvaluePresenceZonageMarin	7
App\Entity\ReferentielCarto\ZonageMarin	7
App\Entity\ReferentielTaxo\TaxonEvaluePresenceDepartementale	6
App\Entity\ReferentielCarto\Departement	6
App\Entity\ReferentielTaxo\StatutPresence	3
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
App\Entity\User	1
App\Entity\ReferentielTaxo\StatutIndigenatRegional	1
App\Entity\ReferentielTaxo\StatutEndemisme	1
App\Entity\ReferentielTaxo\Exotiques\TaxonExotique	1
App\Entity\ReferentielTaxo\Exotiques\Reproduction	1
App\Entity\ReferentielTaxo\Exotiques\Tendance	1
App\Entity\ReferentielTaxo\Exotiques\TypeIntroduction	1
App\Entity\Indicateurs\Donnees\ChiffresClesObsOccSINPParEspece	1
App\Entity\ListeRouge\EvaluationListeRouge	1
App\Entity\ListeRouge\Categorie	1
App\Entity\ReferentielTaxo\Exotiques\Raison	1
App\Entity\ReferentielTaxo\Exotiques\ImpactHabitat	1
App\Entity\ReferentielTaxo\Exotiques\ImpactIndigenes	1
App\Entity\ReferentielTaxo\Exotiques\Origine	1
App\Entity\Taxonomie\TaxrefAPIPhoto	1
App\Entity\Photo\Licence	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\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\AttributNomenclature	No errors.
App\Entity\Indicateurs\Donnees\EspecesParAnneeObservation	No errors.
App\Entity\Indicateurs\Donnees\ChiffresClesObsOccSINPParEspece	No errors.
App\Entity\Indicateurs\Donnees\ChiffresClesObsOccSINPParEspeceEtDepartement	No errors.
App\Entity\ReferentielCarto\Departement	No errors.
App\Entity\ReferentielCarto\ZonageMarin	No errors.
App\Entity\ReferentielCarto\EnvironnementCarto	No errors.
App\Entity\ReferentielCarto\EnvironnementCartoCorrFondPlan	No errors.
App\Entity\ReferentielCarto\EnvironnementCartoFondPlanDisponible	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\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\OrganismesUser	No errors.
App\Entity\Donnees\AttributVersion	No errors.
App\Entity\Organisme	No errors.
App\Entity\Droits\Role	No errors.
App\Entity\Taxonomie\GroupeUsuel	No errors.
App\Entity\Projet\Projet	No errors.
App\Entity\RoleOrganisme	No errors.
App\Entity\DemandeDonnees\Demande	No errors.
App\Entity\Donnees\Attribut	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\Indicateurs\Donnees\OccSINPValide\GroupeUsuel\General	No errors.
App\Entity\Projet\Type	No errors.
App\Entity\Projet\CorrProjetIndicateurEnDirect	No errors.
App\Entity\Projet\CorrProjetIndicateur	No errors.
App\Entity\JDD\JDD	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\Donnees\CorrespondanceAttributFormatDonnees	No errors.
App\Entity\Donnees\CorrespondanceAttributFormatDescriptif	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\RoleActeur	No errors.
App\Entity\JDD\CadreAcquisition	No errors.

Symfony Profiler

GET https://dev1.observatoire-fauna.fr/programmes/portail-exotique/fiche-espece/224041

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping