Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

30.99 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

28.09 ms

SELECT e0_.annee AS annee_0, SUM(e0_.nb_obs_occ) AS sclr_1, SUM(e0_.nb_obs_synth) AS sclr_2 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom INNER JOIN ipn_requeteur_v3.referentiel_espece r2_ ON v1_.cd_nom = r2_.cd_ref WHERE r2_.est_exotique = true GROUP BY e0_.annee ORDER BY e0_.annee ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.annee AS annee_0,
  SUM(e0_.nb_obs_occ) AS sclr_1,
  SUM(e0_.nb_obs_synth) AS sclr_2
FROM
  ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_
  INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom
  INNER JOIN ipn_requeteur_v3.referentiel_espece r2_ ON v1_.cd_nom = r2_.cd_ref
WHERE
  r2_.est_exotique = true
GROUP BY
  e0_.annee
ORDER BY
  e0_.annee ASC

SELECT e0_.annee AS annee_0, SUM(e0_.nb_obs_occ) AS sclr_1, SUM(e0_.nb_obs_synth) AS sclr_2 FROM ipn_descripteurs_occurrence_sinp_valide_v2.espece_annees_obs_presence e0_ INNER JOIN ipn_taxonomie.vm_taxref_last v1_ ON e0_.cd_espece = v1_.cd_nom INNER JOIN ipn_requeteur_v3.referentiel_espece r2_ ON v1_.cd_nom = r2_.cd_ref WHERE r2_.est_exotique = true GROUP BY e0_.annee 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 165)
7	App\Repository\Indicateurs\Donnees\EspecesParAnneeObservationRepository->getNombreObservationsParAnneeEspecesExotiques (line 158)
8	App\Controller\PortailExotique\PortailController->repartition (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)

1.49 ms

SELECT t0.serial AS serial_1, t0.mail AS mail_2, t0.mail_transitoire AS mail_transitoire_3, t0.validermail_key AS validermail_key_4, t0.poste_occupe AS poste_occupe_5, t0.date_creation AS date_creation_6, t0.derniere_date_edition AS derniere_date_edition_7, t0.newsletter AS newsletter_8, t0.statut AS statut_9, t0.uid AS uid_10, t0.orgid AS orgid_11 FROM ipn_user.corr_utilisateur_organisme t0 WHERE t0.uid IS NULL AND t0.statut = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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_284bb53f4d007d50333a9492d5018b02->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 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 162)
27	App\Controller\PortailExotique\PortailController->repartition (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.41 ms

SELECT f0_.eid AS eid_0, f0_.libelle AS libelle_1, f1_.opacite AS opacite_2, f1_.affiche AS affiche_3, f1_.ordre AS ordre_4, f1_.index AS index_5, f1_.style AS style_6, f1_.min_reso AS min_reso_7, f1_.max_reso AS max_reso_8, f2_.fid AS fid_9, f2_.libelle_court AS libelle_court_10, f2_.libelle AS libelle_11, f2_.legende AS legende_12, f2_.type AS type_13, f2_.params AS params_14, f2_.vignette AS vignette_15, f1_.eid AS eid_16, f1_.fid AS fid_17 FROM ipn_carto.fauna_environnements_carto f0_ INNER JOIN ipn_carto.fauna_corr_environnements_carto_fonds_plans f1_ ON f0_.eid = f1_.eid INNER JOIN ipn_carto.fauna_fonds_plans_disponibles f2_ ON f1_.fid = f2_.fid WHERE f0_.eid = 1 ORDER BY f1_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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 331)
22	__TwigTemplate_284bb53f4d007d50333a9492d5018b02->block_content (line 432)
23	Twig\Template->yieldBlock (line 292)
24	__TwigTemplate_86a391e172b7e6eb0255a9b323ad5eee->doDisplay (line 388)
25	Twig\Template->yield (line 60)
26	__TwigTemplate_284bb53f4d007d50333a9492d5018b02->doDisplay (line 388)
27	Twig\Template->yield (line 344)
28	Twig\Template->display (line 359)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 334)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 162)
35	App\Controller\PortailExotique\PortailController->repartition (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	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

Entities Mapping

Class	Mapping errors
App\Entity\Indicateurs\Donnees\EspecesParAnneeObservation	No errors.
App\Entity\Taxonomie\TaxrefLast	No errors.
App\Entity\Taxonomie\EspeceDansReferentielEspeceRegional	No errors.
App\Entity\OrganismesUser	No errors.
App\Entity\User	No errors.
App\Entity\Organisme	No errors.
App\Entity\Taxonomie\CdRefAutocompletion	No errors.
App\Entity\ReferentielTaxo\AdminForumStatut	No errors.
App\Entity\ReferentielTaxo\AdminHistoriqueStatut	No errors.
App\Entity\ReferentielTaxo\AdminStatutNiveauAvancement	No errors.
App\Entity\ReferentielTaxo\AdminDerniereConsultationForumStatut	No errors.
App\Entity\Taxonomie\RefRangTaxonomique	No errors.
App\Entity\Taxonomie\TaxrefLastHabitat	No errors.
App\Entity\ReferentielTaxo\TaxonEvalue	No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvalue	No errors.
App\Entity\ReferentielTaxo\AdminTaxonEtat	No errors.
App\Entity\Photo\Photo	No errors.
App\Entity\Taxonomie\TaxrefAPIPhoto	No errors.
App\Entity\ReferentielTaxo\TaxonPNA	No errors.
App\Entity\Sensibilite\TaxonSensible	No errors.
App\Entity\ReferentielTaxo\TaxonReglemente	No errors.
App\Entity\ReferentielTaxo\TaxonDeterminant	No errors.
App\Entity\ListeRouge\EvaluationListeRouge	No errors.
App\Entity\Indicateurs\Donnees\EspecesParMoisObservation	No errors.
App\Entity\Validation\CorrPheno	No errors.
App\Entity\Validation\CorrDifficulteDetermination	No errors.
App\Entity\Droits\UserRole	No errors.
App\Entity\Droits\GestionRefEspGroupeUsuel	No errors.
App\Entity\Droits\GestionRefEspTaxref	No errors.
App\Entity\Droits\GestionSensibiliteGroupeUsuel	No errors.
App\Entity\Droits\ValidationDonneesCache	No errors.
App\Entity\Droits\DroitsProjet	No errors.
App\Entity\RolesOrganismes	No errors.
App\Entity\DemandeDonnees\DemandeUtilisateursAutorise	No errors.
App\Entity\Organisme\HabilitationPNR	No errors.
App\Entity\Organisme\HabilitationReserve	No errors.
App\Entity\Organisme\HabilitationSIC	No errors.
App\Entity\Organisme\HabilitationZPS	No errors.
App\Entity\Organisme\HabilitationDepartement	No errors.
App\Entity\Organisme\HabilitationGEMAPI	No errors.
App\Entity\JDD\JDDContactDonnees	No errors.
App\Entity\JDD\CadreAcquisitionContact	No errors.
App\Entity\TypeOrganisme	No errors.
App\Entity\TypeFriendlyOrganisme	No errors.
App\Entity\Indicateurs\Donnees\OccSINPValide\Contributeur	No errors.
App\Entity\Organisme\SuperviseurHabilitation	No errors.
App\Entity\CertificatDepot\CertificatDepot	No errors.
App\Entity\ReferentielCarto\EnvironnementCarto	No errors.
App\Entity\ReferentielCarto\EnvironnementCartoCorrFondPlan	No errors.
App\Entity\ReferentielCarto\EnvironnementCartoFondPlanDisponible	No errors.
App\Entity\ReferentielTaxo\AdminInteractionCommentaireForum	No errors.
App\Entity\ReferentielTaxo\AdminRefNiveauAvancementStatut	No errors.
App\Entity\ReferentielTaxo\StatutPresence	No errors.
App\Entity\ReferentielTaxo\StatutIndigenatRegional	No errors.
App\Entity\ReferentielTaxo\StatutEndemisme	No errors.
App\Entity\ReferentielTaxo\StatutRarete	No errors.
App\Entity\ReferentielTaxo\TaxonEvaluePresenceDepartementale	No errors.
App\Entity\ReferentielTaxo\TaxonEvaluePresenceZonageMarin	No errors.
App\Entity\ReferentielTaxo\StatutPhenologique	No errors.
App\Entity\ReferentielTaxo\StatutEnjeu	No errors.
App\Entity\ReferentielTaxo\Exotiques\TaxonExotique	No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvaluePresenceDepartementale	No errors.
App\Entity\ReferentielTaxo\AdminTaxonEvaluePresenceZonageMarin	No errors.
App\Entity\ReferentielTaxo\Exotiques\AdminTaxonExotique	No errors.
App\Entity\ReferentielTaxo\StatutEtat	No errors.
App\Entity\Photo\Licence	No errors.
App\Entity\Photo\StatutPhoto	No errors.
App\Entity\ReferentielTaxo\TypeStatut	No errors.
App\Entity\Sensibilite\NiveauSensibilite	No errors.
App\Entity\ReferentielTaxo\TypeReglementation	No errors.
App\Entity\ListeRouge\Categorie	No errors.
App\Entity\Donnees\AttributNomenclature	No errors.
App\Entity\Validation\CritereDifficulte	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\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\Departement	No errors.
App\Entity\ReferentielCarto\GEMAPI	No errors.
App\Entity\JDD\JDD	No errors.
App\Entity\JDD\RoleActeur	No errors.
App\Entity\JDD\CadreAcquisition	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping