Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.01 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.10 ms

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 101)
8	App\Controller\Admin\Observations\VisiteCrudController->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)

0.45 ms

SELECT t0.id AS id_1, t0.date_visite AS date_visite_2, t0.uuid AS uuid_3, t0.client_uuid AS client_uuid_4, t0.commentaire AS commentaire_5, t0.property_id AS property_id_6 FROM visite t0 WHERE t0.id = ?

Parameters:

[
  "4477"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_visite AS date_visite_2,
  t0.uuid AS uuid_3,
  t0.client_uuid AS client_uuid_4,
  t0.commentaire AS commentaire_5,
  t0.property_id AS property_id_6
FROM
  visite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_visite AS date_visite_2, t0.uuid AS uuid_3, t0.client_uuid AS client_uuid_4, t0.commentaire AS commentaire_5, t0.property_id AS property_id_6 FROM visite t0 WHERE t0.id = '4477';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 146)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 243)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 62)
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)

0.46 ms

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9 FROM property t0 WHERE t0.id = ?

Parameters:

[
  391
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.property_name AS property_name_2,
  t0.commune AS commune_3,
  t0.surface_totale AS surface_totale_4,
  t0.contract_name AS contract_name_5,
  t0.adresse_1 AS adresse_1_6,
  t0.adresse_2 AS adresse_2_7,
  t0.code_postal AS code_postal_8,
  t0.departement_id AS departement_id_9
FROM
  property t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.property_name AS property_name_2, t0.commune AS commune_3, t0.surface_totale AS surface_totale_4, t0.contract_name AS contract_name_5, t0.adresse_1 AS adresse_1_6, t0.adresse_2 AS adresse_2_7, t0.code_postal AS code_postal_8, t0.departement_id AS departement_id_9 FROM property t0 WHERE t0.id = 391;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
6	Proxies\__CG__\App\Entity\Properties\Property->__get (line 134)
7	App\Entity\Properties\Property->getPropertyName (line 211)
8	App\Entity\Observations\Visite->__toString (line 76)
9	EasyCorp\Bundle\EasyAdminBundle\Dto\EntityDto->toString (line 180)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getI18nDto (line 64)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 78)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\Visite	No errors.
App\Entity\Observations\Observation	No errors.
App\Entity\PreconisationActualisee\PreconisationActualisee	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\Properties\CatSurface	No errors.
App\Entity\Basagri\Ref\BasagriCulture	No errors.
App\Entity\Properties\Cepage	No errors.

Symfony Profiler

GET https://proviter.fr/?crudAction=delete&crudControllerFqcn=App%5CController%5CAdmin%5CObservations%5CVisiteCrudController&entityId=4477

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping