Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.54 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.69 ms
(66.68%)

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)

0.84 ms
(33.32%)

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.id = ?

Parameters:

[
  "33839"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.secteur AS secteur_2,
  t0.ilot AS ilot_3,
  t0.parcelle AS parcelle_4,
  t0.stade_r_1 AS stade_r_1_5,
  t0.stade_r_2 AS stade_r_2_6,
  t0.mi_f AS mi_f_7,
  t0.mi_g AS mi_g_8,
  t0.br_f AS br_f_9,
  t0.br_g AS br_g_10,
  t0.oi_f AS oi_f_11,
  t0.oi_g AS oi_g_12,
  t0.pg_f AS pg_f_13,
  t0.pg_g AS pg_g_14,
  t0.maladie_bois AS maladie_bois_15,
  t0.note_mdb AS note_mdb_16,
  t0.cic_v AS cic_v_17,
  t0.cic_fd AS cic_fd_18,
  t0.vdg_glom AS vdg_glom_19,
  t0.vdg_perfos AS vdg_perfos_20,
  t0.carences AS carences_21,
  t0.note_carence AS note_carence_22,
  t0.commentaire AS commentaire_23,
  t0.notation AS notation_24,
  t0.created_by AS created_by_25,
  t0.last_update AS last_update_26,
  t0.last_updater AS last_updater_27,
  t0.vdg_ponte AS vdg_ponte_28,
  t0.uuid AS uuid_29,
  t0.client_uuid AS client_uuid_30,
  t0.property_id AS property_id_31,
  t0.visite_id AS visite_id_32
FROM
  observation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.ilot AS ilot_3, t0.parcelle AS parcelle_4, t0.stade_r_1 AS stade_r_1_5, t0.stade_r_2 AS stade_r_2_6, t0.mi_f AS mi_f_7, t0.mi_g AS mi_g_8, t0.br_f AS br_f_9, t0.br_g AS br_g_10, t0.oi_f AS oi_f_11, t0.oi_g AS oi_g_12, t0.pg_f AS pg_f_13, t0.pg_g AS pg_g_14, t0.maladie_bois AS maladie_bois_15, t0.note_mdb AS note_mdb_16, t0.cic_v AS cic_v_17, t0.cic_fd AS cic_fd_18, t0.vdg_glom AS vdg_glom_19, t0.vdg_perfos AS vdg_perfos_20, t0.carences AS carences_21, t0.note_carence AS note_carence_22, t0.commentaire AS commentaire_23, t0.notation AS notation_24, t0.created_by AS created_by_25, t0.last_update AS last_update_26, t0.last_updater AS last_updater_27, t0.vdg_ponte AS vdg_ponte_28, t0.uuid AS uuid_29, t0.client_uuid AS client_uuid_30, t0.property_id AS property_id_31, t0.visite_id AS visite_id_32 FROM observation t0 WHERE t0.id = '33839';

#	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)

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\Observations\Visite	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.
App\Entity\PreconisationActualisee\Param\PrecoDosagePreconisationRapide	No errors.
App\Entity\PreconisationActualisee\Param\PrecoCategorieSurface	No errors.
App\Entity\PreconisationActualisee\PreconisationDosages	No errors.
App\Entity\Param\DptSpec	No errors.
App\Entity\Calendrier\Preconisation	No errors.
App\Entity\Basagri\Ref\BasagriLmr	No errors.
App\Entity\Basagri\Ref\BasagriUsage	No errors.
App\Entity\Basagri\Ref\BasagriClassUsage	The association App\Entity\Basagri\Ref\BasagriClassUsage#code_phrase_classification refers to the inverse side field App\Entity\Basagri\Ref\BasagriClp#basagriClassUsages which does not exist.
App\Entity\Basagri\Ref\BasagriProfilVegetatif	No errors.
App\Entity\PreconisationActualisee\PreconisationRealisee	No errors.
App\Entity\Basagri\Ref\BasagriClp	The association App\Entity\Basagri\Ref\BasagriClp#basagriClpPhytos refers to the owning side field App\Entity\Basagri\Ref\BasagriClassUsage#code which does not exist.
App\Entity\Basagri\Ref\BasagriPhrase	No errors.
App\Entity\Basagri\Ref\BasagriPhytoRetire	No errors.
App\Entity\Basagri\Ref\BasagriSubstance	No errors.
App\Entity\Basagri\Ref\BasagriCible	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\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\BasagriPhrasePhyto	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\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\Ref\BasagriCeppPhyto	No errors.
App\Entity\Basagri\Ref\BasagriDistanceSecuriteRiverain	No errors.
App\Entity\Basagri\Ref\BasagriPhyto	No errors.
App\Entity\Basagri\Ref\BasagriPrecurseurExplosif	No errors.
App\Entity\Basagri\Tmp\TmpPhytoRetire	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\TmpPeriodeApplication	No errors.
App\Entity\Basagri\Tmp\TmpPhrase	No errors.
App\Entity\Basagri\Tmp\TmpPhrasePhyto	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\TmpCeppPhyto	No errors.
App\Entity\Basagri\Tmp\TmpLmr	No errors.
App\Entity\Basagri\Tmp\TmpPhyto	No errors.
App\Entity\Basagri\Tmp\TmpPrecurseurExplosif	No errors.
App\Entity\Basagri\Tmp\TmpProfilVegetatif	No errors.
App\Entity\Basagri\Tmp\TmpUsage	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\StadeCulture	No errors.
App\Entity\Param\Alternatives	No errors.
App\Entity\Param\RegroupementCibles	No errors.
App\Entity\PreconisationActualisee\Param\PrecoCritereSelection	No errors.
App\Entity\PreconisationActualisee\Param\PrecoDelais	No errors.
App\Entity\PreconisationActualisee\PreconisationRealiseeEtatTraitement	No errors.

Symfony Profiler

GET https://proviter.fr/?crudAction=delete&crudControllerFqcn=App%5CController%5CAdmin%5CObservations%5CObservationCrudController&entityId=33839&page=4234&sort%5Bvi…

Configuration Settings

Theme