Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.16 ms Query time

2 Invalid entities

57 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.62 ms

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.token_password AS token_password_8,
  t0.token_activate AS token_activate_9,
  t0.nom AS nom_10,
  t0.prenom AS prenom_11,
  t0.created_at AS created_at_12,
  t0.the_statut_id AS the_statut_id_13,
  t0.mobile AS mobile_14,
  t0.reference AS reference_15,
  t0.the_type_id AS the_type_id_16,
  t0.the_role_principal_id AS the_role_principal_id_17,
  t0.photo AS photo_18,
  t0.updated_at AS updated_at_19,
  t0.discr,
  t2.tarif_horaire AS tarif_horaire_20,
  t2.client_id AS client_id_21,
  t3.client_id AS client_id_22,
  t3.bailleur_id AS bailleur_id_23
FROM
  user t0
  LEFT JOIN user_admin t1 ON t0.id = t1.id
  LEFT JOIN user_client t2 ON t0.id = t2.id
  LEFT JOIN user_bailleur t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.token_password AS token_password_8, t0.token_activate AS token_activate_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.created_at AS created_at_12, t0.the_statut_id AS the_statut_id_13, t0.mobile AS mobile_14, t0.reference AS reference_15, t0.the_type_id AS the_type_id_16, t0.the_role_principal_id AS the_role_principal_id_17, t0.photo AS photo_18, t0.updated_at AS updated_at_19, t0.discr, t2.tarif_horaire AS tarif_horaire_20, t2.client_id AS client_id_21, t3.client_id AS client_id_22, t3.bailleur_id AS bailleur_id_23 FROM user t0 LEFT JOIN user_admin t1 ON t0.id = t1.id LEFT JOIN user_client t2 ON t0.id = t2.id LEFT JOIN user_bailleur t3 ON t0.id = t3.id WHERE t0.id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.68 ms

SELECT t0.id AS id_1, t0.the_action_id AS the_action_id_2, t0.the_user_role_id AS the_user_role_id_3, t0.the_module_id AS the_module_id_4 FROM permission t0 WHERE t0.the_user_role_id = ?

Parameters:

[
  "ROLE_CLIENT_DIRECTION"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.the_action_id AS the_action_id_2,
  t0.the_user_role_id AS the_user_role_id_3,
  t0.the_module_id AS the_module_id_4
FROM
  permission t0
WHERE
  t0.the_user_role_id = ?

SELECT t0.id AS id_1, t0.the_action_id AS the_action_id_2, t0.the_user_role_id AS the_user_role_id_3, t0.the_module_id AS the_module_id_4 FROM permission t0 WHERE t0.the_user_role_id = 'ROLE_CLIENT_DIRECTION';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Service\EspaceClientService->getPermissions (line 67)
5	App\Service\EspaceClientService->hasPermission (line 107)
6	App\Voter\Client\SiteVoter->hasPermission (line 14)
7	App\Voter\Client\SiteVoter->voteOnAttribute (line 52)
8	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 56)
9	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 35)
10	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 88)
11	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 35)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 73)
13	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 57)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 54)
15	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 64)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.36 ms

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.updated_at AS updated_at_8, t0.email AS email_9, t0.the_statut_id AS the_statut_id_10, t0.secteurs_id AS secteurs_id_11, t0.client_id AS client_id_12 FROM bailleurs t0 WHERE t0.id = ?

Parameters:

[
  29
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.raison_sociale AS raison_sociale_3,
  t0.siret AS siret_4,
  t0.reference_index AS reference_index_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.updated_at AS updated_at_8,
  t0.email AS email_9,
  t0.the_statut_id AS the_statut_id_10,
  t0.secteurs_id AS secteurs_id_11,
  t0.client_id AS client_id_12
FROM
  bailleurs t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.raison_sociale AS raison_sociale_3, t0.siret AS siret_4, t0.reference_index AS reference_index_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.updated_at AS updated_at_8, t0.email AS email_9, t0.the_statut_id AS the_statut_id_10, t0.secteurs_id AS secteurs_id_11, t0.client_id AS client_id_12 FROM bailleurs t0 WHERE t0.id = 29;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Form\Client\InterventionSiteFilterType->buildForm (line 43)
7	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
8	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
9	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
10	Symfony\Component\Form\FormFactory->createBuilder (line 41)
11	Symfony\Component\Form\FormFactory->create (line 26)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 351)
13	App\Controller\Client\InterventionSiteController->index (line 42)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

0.50 ms

SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.raison_sociale AS raison_sociale_2, b0_.siret AS siret_3, b0_.reference_index AS reference_index_4, b0_.telephone AS telephone_5, b0_.logo AS logo_6, b0_.updated_at AS updated_at_7, b0_.email AS email_8, b0_.the_statut_id AS the_statut_id_9, b0_.secteurs_id AS secteurs_id_10, b0_.client_id AS client_id_11 FROM bailleurs b0_ LEFT JOIN bailleurs_adresses b2_ ON b0_.id = b2_.bailleurs_id LEFT JOIN adresses a1_ ON a1_.id = b2_.adresses_id WHERE b0_.client_id = ? AND b0_.id IN (?)

Parameters:

[
  1
  "29"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.reference AS reference_1,
  b0_.raison_sociale AS raison_sociale_2,
  b0_.siret AS siret_3,
  b0_.reference_index AS reference_index_4,
  b0_.telephone AS telephone_5,
  b0_.logo AS logo_6,
  b0_.updated_at AS updated_at_7,
  b0_.email AS email_8,
  b0_.the_statut_id AS the_statut_id_9,
  b0_.secteurs_id AS secteurs_id_10,
  b0_.client_id AS client_id_11
FROM
  bailleurs b0_
  LEFT JOIN bailleurs_adresses b2_ ON b0_.id = b2_.bailleurs_id
  LEFT JOIN adresses a1_ ON a1_.id = b2_.adresses_id
WHERE
  b0_.client_id = ?
  AND b0_.id IN (?)

SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.raison_sociale AS raison_sociale_2, b0_.siret AS siret_3, b0_.reference_index AS reference_index_4, b0_.telephone AS telephone_5, b0_.logo AS logo_6, b0_.updated_at AS updated_at_7, b0_.email AS email_8, b0_.the_statut_id AS the_statut_id_9, b0_.secteurs_id AS secteurs_id_10, b0_.client_id AS client_id_11 FROM bailleurs b0_ LEFT JOIN bailleurs_adresses b2_ ON b0_.id = b2_.bailleurs_id LEFT JOIN adresses a1_ ON a1_.id = b2_.adresses_id WHERE b0_.client_id = 1 AND b0_.id IN ('29');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 99)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1002)
12	Symfony\Component\Form\Form->submit (line 552)
13	Symfony\Component\Form\Form->submit (line 493)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 414)
16	App\Controller\Client\InterventionSiteController->index (line 43)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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\Permission	54
App\Entity\User	1
App\Entity\Clients	1
App\Entity\Bailleurs	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserAdmin	No errors.
App\Entity\UserClient	The association App\Entity\UserClient#diagnosticTechnicien refers to the owning side field App\Entity\Diagnostic#technicien which does not exist.
App\Entity\UserBailleur	No errors.
App\Entity\Clients	No errors.
App\Entity\Bailleurs	No errors.
App\Entity\Diagnostic	No errors.
App\Entity\Intervention	No errors.
App\Entity\Commande	No errors.
App\Entity\Permission	No errors.
App\Entity\Secteurs	No errors.
App\Entity\Adresses	No errors.
App\Entity\Contacts	The association App\Entity\Contacts#fonction refers to the inverse side field App\Entity\Fonctions#contacts which does not exist.
App\Entity\InterventionSite	No errors.
App\Entity\Agence	No errors.

Symfony Profiler

POST https://www.test.fluxxo.fr/client/sites/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping