Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

42.63 ms Query time

2 Invalid entities

95 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

27.13 ms
(63.65%)

SELECT DISTINCT l0_.id AS id_0, i1_.reference AS reference_1 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = ? ORDER BY i1_.reference ASC LIMIT 35

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l0_.id AS id_0,
  i1_.reference AS reference_1
FROM
  lieu l0_
  LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id
  LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id
WHERE
  i1_.client_id = ?
ORDER BY
  i1_.reference ASC
LIMIT
  35

SELECT DISTINCT l0_.id AS id_0, i1_.reference AS reference_1 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = 1 ORDER BY i1_.reference ASC LIMIT 35;

#	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->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerQRuow7R\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\Client\LieuController->index (line 60)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

12.45 ms
(29.21%)

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lieu l0_
  LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id
  LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id
WHERE
  i1_.client_id = ?

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = 1;

#	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->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerQRuow7R\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\Client\LieuController->index (line 60)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.83 ms
(1.94%)

SELECT l0_.id AS id_0, l0_.etage AS etage_1, l0_.numero AS numero_2, l0_.type_id AS type_id_3, l0_.pieces_nb AS pieces_nb_4, l0_.reference AS reference_5, l0_.surface AS surface_6, l0_.occupant_id AS occupant_id_7, l0_.intervention_site_id AS intervention_site_id_8 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = ? AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i1_.reference ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.etage AS etage_1,
  l0_.numero AS numero_2,
  l0_.type_id AS type_id_3,
  l0_.pieces_nb AS pieces_nb_4,
  l0_.reference AS reference_5,
  l0_.surface AS surface_6,
  l0_.occupant_id AS occupant_id_7,
  l0_.intervention_site_id AS intervention_site_id_8
FROM
  lieu l0_
  LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id
  LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id
WHERE
  i1_.client_id = ?
  AND l0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  i1_.reference ASC

SELECT l0_.id AS id_0, l0_.etage AS etage_1, l0_.numero AS numero_2, l0_.type_id AS type_id_3, l0_.pieces_nb AS pieces_nb_4, l0_.reference AS reference_5, l0_.surface AS surface_6, l0_.occupant_id AS occupant_id_7, l0_.intervention_site_id AS intervention_site_id_8 FROM lieu l0_ LEFT JOIN intervention_site i1_ ON l0_.intervention_site_id = i1_.id LEFT JOIN adresses a2_ ON i1_.adresse_id = a2_.id WHERE i1_.client_id = 1 AND l0_.id IN (51, 43, 44, 45, 46, 47, 48, 49, 50, 26, 52, 53, 54, 55, 56, 57, 58, 59, 41, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 42) ORDER BY i1_.reference ASC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerQRuow7R\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\Client\LieuController->index (line 60)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.52 ms
(1.23%)

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\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
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)

0.52 ms
(1.23%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.the_statut_id AS the_statut_id_3, t0.reference AS reference_4, t0.reference_index AS reference_index_5, t0.reference_bailleur AS reference_bailleur_6, t0.bailleur_id AS bailleur_id_7, t0.adresse_id AS adresse_id_8, t0.client_id AS client_id_9, t0.agence_id AS agence_id_10 FROM intervention_site t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.the_statut_id AS the_statut_id_3,
  t0.reference AS reference_4,
  t0.reference_index AS reference_index_5,
  t0.reference_bailleur AS reference_bailleur_6,
  t0.bailleur_id AS bailleur_id_7,
  t0.adresse_id AS adresse_id_8,
  t0.client_id AS client_id_9,
  t0.agence_id AS agence_id_10
FROM
  intervention_site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.the_statut_id AS the_statut_id_3, t0.reference AS reference_4, t0.reference_index AS reference_index_5, t0.reference_bailleur AS reference_bailleur_6, t0.bailleur_id AS bailleur_id_7, t0.adresse_id AS adresse_id_8, t0.client_id AS client_id_9, t0.agence_id AS agence_id_10 FROM intervention_site t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\InterventionSite::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\InterventionSite->__get (line 153)
7	App\Entity\InterventionSite->getNom (line 168)
8	App\Entity\InterventionSite->getNomAdresse (line 128)
9	App\Entity\InterventionSite->__toString (line 122)
10	Twig\Runtime\EscaperRuntime->escape (line 126)
11	__TwigTemplate_03febdc1616b68e2c74e4d3495e1d617->block_body (line 189)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 99)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_03febdc1616b68e2c74e4d3495e1d617->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\Client\LieuController->index (line 67)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.46 ms
(1.09%)

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.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 WHERE t0.id = ?

Parameters:

[
  1
]

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.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.email AS email_10,
  t0.the_statut_id AS the_statut_id_11,
  t0.stripe_customer_id AS stripe_customer_id_12,
  t0.sous_domaine AS sous_domaine_13,
  t0.capital AS capital_14,
  t0.num_tva_intra AS num_tva_intra_15,
  t0.footer_devis AS footer_devis_16,
  t0.secteurs_id AS secteurs_id_17
FROM
  clients 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.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.email AS email_10, t0.the_statut_id AS the_statut_id_11, t0.stripe_customer_id AS stripe_customer_id_12, t0.sous_domaine AS sous_domaine_13, t0.capital AS capital_14, t0.num_tva_intra AS num_tva_intra_15, t0.footer_devis AS footer_devis_16, t0.secteurs_id AS secteurs_id_17 FROM clients t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Clients::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Clients->__get (line 153)
7	App\Entity\Clients->getLogo (line 275)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_372f934bb29cae84ce4bf007afb7f246::doDisplay (line 58)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 88)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_03febdc1616b68e2c74e4d3495e1d617->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\Client\LieuController->index (line 67)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.40 ms
(0.94%)

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\LieuVoter->hasPermission (line 14)
7	App\Voter\Client\LieuVoter->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.31 ms
(0.72%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.complement AS complement_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.the_type_id AS the_type_id_10 FROM adresses t0 WHERE t0.id = ?

Parameters:

[
  18
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.rue AS rue_3,
  t0.code_postal AS code_postal_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.complement AS complement_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.the_type_id AS the_type_id_10
FROM
  adresses t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.rue AS rue_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.complement AS complement_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.the_type_id AS the_type_id_10 FROM adresses t0 WHERE t0.id = 18;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Adresses::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Adresses->__get (line 153)
7	App\Entity\Adresses->getRue (line 97)
8	App\Entity\InterventionSite->getNomAdresse (line 128)
9	App\Entity\InterventionSite->__toString (line 122)
10	Twig\Runtime\EscaperRuntime->escape (line 126)
11	__TwigTemplate_03febdc1616b68e2c74e4d3495e1d617->block_body (line 189)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 99)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_03febdc1616b68e2c74e4d3495e1d617->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\Client\LieuController->index (line 67)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	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\Lieu	35
App\Entity\User	1
App\Entity\Clients	1
App\Entity\InterventionSite	1
App\Entity\Secteurs	1
App\Entity\Bailleurs	1
App\Entity\Adresses	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\Lieu	No errors.
App\Entity\InterventionSite	No errors.
App\Entity\Adresses	No errors.
App\Entity\Occupant	No errors.
App\Entity\Secteurs	No errors.
App\Entity\Agence	No errors.
App\Entity\CommandeSite	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.

Symfony Profiler

GET https://www.test.fluxxo.fr/client/lieu/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping