Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

3.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.78 ms
(100.00%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_token AS reset_token_4, u0_.is_active AS is_active_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.function AS function_8, u0_.type_certiphyto AS type_certiphyto_9, u0_.validite_certiphyto AS validite_certiphyto_10, u0_.mobile AS mobile_11, u0_.phone AS phone_12, u0_.num_certiphyto AS num_certiphyto_13, u0_.stades_pheno AS stades_pheno_14, u0_.p_tordeuses AS p_tordeuses_15, u0_.movida AS movida_16, u0_.grp_30k AS grp_30k_17, u0_.is_admin AS is_admin_18 FROM `user` u0_ WHERE u0_.is_admin = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.reset_token AS reset_token_4,
  u0_.is_active AS is_active_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.function AS function_8,
  u0_.type_certiphyto AS type_certiphyto_9,
  u0_.validite_certiphyto AS validite_certiphyto_10,
  u0_.mobile AS mobile_11,
  u0_.phone AS phone_12,
  u0_.num_certiphyto AS num_certiphyto_13,
  u0_.stades_pheno AS stades_pheno_14,
  u0_.p_tordeuses AS p_tordeuses_15,
  u0_.movida AS movida_16,
  u0_.grp_30k AS grp_30k_17,
  u0_.is_admin AS is_admin_18
FROM
  `user` u0_
WHERE
  u0_.is_admin = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_token AS reset_token_4, u0_.is_active AS is_active_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.function AS function_8, u0_.type_certiphyto AS type_certiphyto_9, u0_.validite_certiphyto AS validite_certiphyto_10, u0_.mobile AS mobile_11, u0_.phone AS phone_12, u0_.num_certiphyto AS num_certiphyto_13, u0_.stades_pheno AS stades_pheno_14, u0_.p_tordeuses AS p_tordeuses_15, u0_.movida AS movida_16, u0_.grp_30k AS grp_30k_17, u0_.is_admin AS is_admin_18 FROM `user` u0_ WHERE u0_.is_admin = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 48)
7	App\Repository\UserRepository->findAdminsAsChoices (line 68)
8	App\Controller\Admin\Observations\ObservationCrudController->configureFilters (line 149)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getFilters (line 59)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
11	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserInfo\TypeInterlocuteur	No errors.
App\Entity\UserInfo\TypeInvitation	No errors.
App\Entity\UserInfo\TypeSpecification	No errors.
App\Entity\Properties\Property	No errors.
App\Entity\PreconisationActualisee\Param\PrecoComplementInformations	No errors.
App\Entity\PreconisationActualisee\Param\PrecoContexteSanitaire	No errors.
App\Entity\PreconisationActualisee\Param\PrecoPreconisationRapide	No errors.
App\Entity\PreconisationActualisee\Param\PrecoRegroupementProprietes	No errors.
App\Entity\PreconisationActualisee\Param\PrecoTypeTraitement	No errors.
App\Entity\PreconisationActualisee\PreconisationSaison	No errors.
App\Entity\PreconisationActualisee\Param\PrecoMail	No errors.
App\Entity\Observations\Observation	No errors.
App\Entity\Param\Departement	No errors.
App\Entity\Properties\Secteur	No errors.
App\Entity\Properties\Ilot	No errors.
App\Entity\Properties\Parcelle	No errors.
App\Entity\Calendrier\Calendrier	No errors.
App\Entity\PreconisationActualisee\PreconisationActualisee	No errors.
App\Entity\Properties\CatSurface	No errors.
App\Entity\Basagri\Ref\BasagriCulture	No errors.
App\Entity\Properties\Cepage	No errors.
App\Entity\Observations\Visite	No errors.
App\Entity\PreconisationActualisee\Param\PrecoDosagePreconisationRapide	No errors.
App\Entity\PreconisationActualisee\Param\PrecoCategorieSurface	No errors.
App\Entity\Param\DptSpec	No errors.
App\Entity\Calendrier\Preconisation	No errors.
App\Entity\PreconisationActualisee\PreconisationDosages	No errors.
App\Entity\Basagri\Ref\BasagriLmr	No errors.
App\Entity\Basagri\Ref\BasagriUsage	No errors.
App\Entity\Basagri\Ref\BasagriClassUsage	No errors.
App\Entity\Basagri\Ref\BasagriProfilVegetatif	No errors.
App\Entity\Basagri\Ref\BasagriCeppPhyto	No errors.
App\Entity\Basagri\Ref\BasagriCible	No errors.
App\Entity\Basagri\Ref\BasagriClp	No errors.
App\Entity\Basagri\Ref\BasagriClpPhyto	No errors.
App\Entity\Basagri\Ref\BasagriComposition	No errors.
App\Entity\Basagri\Ref\BasagriCultureAttractive	No errors.
App\Entity\Basagri\Ref\BasagriDistanceSecuriteRiverain	No errors.
App\Entity\Basagri\Ref\BasagriFamilleSubstance	No errors.
App\Entity\Basagri\Ref\BasagriFirme	No errors.
App\Entity\Basagri\Ref\BasagriFormulation	No errors.
App\Entity\Basagri\Ref\BasagriPeriodeApplication	No errors.
App\Entity\Basagri\Ref\BasagriPhrase	No errors.
App\Entity\Basagri\Ref\BasagriPhrasePhyto	No errors.
App\Entity\Basagri\Ref\BasagriPhyto	No errors.
App\Entity\Basagri\Ref\BasagriRestriction	No errors.
App\Entity\Basagri\Ref\BasagriRestrictionUsage	No errors.
App\Entity\Basagri\Ref\BasagriStade	No errors.
App\Entity\Basagri\Ref\BasagriSubstance	No errors.
App\Entity\Basagri\Ref\BasagriTraitement	No errors.
App\Entity\Basagri\Ref\BasagriTypeCible	No errors.
App\Entity\Basagri\Ref\BasagriTypePhyto	No errors.
App\Entity\Basagri\Ref\BasagriUniteCepp	No errors.
App\Entity\Basagri\Ref\BasagriUniteSubstance	No errors.
App\Entity\Basagri\Ref\BasagriUniteUsage	No errors.
App\Entity\Basagri\Ref\BasagriUsageMinistere	No errors.
App\Entity\Basagri\Ref\BasagriZoneVegetalisee	No errors.
App\Entity\Basagri\Tmp\TmpPhytoRetire	No errors.
App\Entity\Basagri\Tmp\TmpCeppPhyto	No errors.
App\Entity\Basagri\Tmp\TmpCible	No errors.
App\Entity\Basagri\Tmp\TmpClassUsage	No errors.
App\Entity\Basagri\Tmp\TmpClp	No errors.
App\Entity\Basagri\Tmp\TmpClpPhyto	No errors.
App\Entity\Basagri\Tmp\TmpComposition	No errors.
App\Entity\Basagri\Tmp\TmpCulture	No errors.
App\Entity\Basagri\Tmp\TmpCultureAttractive	No errors.
App\Entity\Basagri\Tmp\TmpDistanceSecuriteRiverain	No errors.
App\Entity\Basagri\Tmp\TmpFamilleSubstance	No errors.
App\Entity\Basagri\Tmp\TmpFirme	No errors.
App\Entity\Basagri\Tmp\TmpFormulation	No errors.
App\Entity\Basagri\Tmp\TmpLmr	No errors.
App\Entity\Basagri\Tmp\TmpPeriodeApplication	No errors.
App\Entity\Basagri\Tmp\TmpPhrase	No errors.
App\Entity\Basagri\Tmp\TmpPhrasePhyto	No errors.
App\Entity\Basagri\Tmp\TmpPhyto	No errors.
App\Entity\Basagri\Tmp\TmpRestriction	No errors.
App\Entity\Basagri\Tmp\TmpRestrictionUsage	No errors.
App\Entity\Basagri\Tmp\TmpStade	No errors.
App\Entity\Basagri\Tmp\TmpSubstance	No errors.
App\Entity\Basagri\Tmp\TmpTraitement	No errors.
App\Entity\Basagri\Tmp\TmpTypeCible	No errors.
App\Entity\Basagri\Tmp\TmpTypePhyto	No errors.
App\Entity\Basagri\Tmp\TmpUniteCepp	No errors.
App\Entity\Basagri\Tmp\TmpUniteSubstance	No errors.
App\Entity\Basagri\Tmp\TmpUniteUsage	No errors.
App\Entity\Basagri\Tmp\TmpUsageMinistere	No errors.
App\Entity\Basagri\Tmp\TmpZoneVegetalisee	No errors.
App\Entity\Basagri\Tmp\TmpUsage	No errors.
App\Entity\Basagri\Tmp\TmpProfilVegetatif	No errors.
App\Entity\Files\Viti77	No errors.
App\Entity\Files\Import\Parcellaire	No errors.
App\Entity\Observations\FieldStatus	No errors.
App\Entity\Param\MappingInterdictions	No errors.
App\Entity\Param\RegroupementCibles	No errors.
App\Entity\Param\StadeCulture	No errors.
App\Entity\Param\Alternatives	No errors.
App\Entity\PreconisationActualisee\Param\PrecoCritereSelection	No errors.
App\Entity\PreconisationActualisee\Param\PrecoDelais	No errors.
App\Entity\PreconisationActualisee\PreconisationRealiseeEtatTraitement	No errors.
App\Entity\PreconisationActualisee\PreconisationRealisee	No errors.

Symfony Profiler

GET https://proviter.fr/?crudAction=batchDelete&crudControllerFqcn=App%5CController%5CAdmin%5CObservations%5CObservationCrudController&page=278&sort%5Bvisite%5D=ASC…

Configuration Settings

Theme