Symfony Profiler

Query Metrics

148 Database Queries

12 Different statements

42.85 ms Query time

2 Invalid entities

1609 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.36 ms
(26.51%)

SELECT t0.id AS id_1, t0.etage AS etage_2, t0.numero AS numero_3, t0.type_id AS type_id_4, t0.pieces_nb AS pieces_nb_5, t0.reference AS reference_6, t0.surface AS surface_7, t0.occupant_id AS occupant_id_8, t0.intervention_site_id AS intervention_site_id_9 FROM lieu t0 WHERE t0.intervention_site_id = ? ORDER BY t0.etage ASC, t0.numero ASC

Parameters:

[
  853
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.etage AS etage_2,
  t0.numero AS numero_3,
  t0.type_id AS type_id_4,
  t0.pieces_nb AS pieces_nb_5,
  t0.reference AS reference_6,
  t0.surface AS surface_7,
  t0.occupant_id AS occupant_id_8,
  t0.intervention_site_id AS intervention_site_id_9
FROM
  lieu t0
WHERE
  t0.intervention_site_id = ?
ORDER BY
  t0.etage ASC,
  t0.numero ASC

SELECT t0.id AS id_1, t0.etage AS etage_2, t0.numero AS numero_3, t0.type_id AS type_id_4, t0.pieces_nb AS pieces_nb_5, t0.reference AS reference_6, t0.surface AS surface_7, t0.occupant_id AS occupant_id_8, t0.intervention_site_id AS intervention_site_id_9 FROM lieu t0 WHERE t0.intervention_site_id = 853 ORDER BY t0.etage ASC, t0.numero ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 108)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1698)
10	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498::block_body (line 178)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 99)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\Client\InterventionSiteController->index (line 65)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

9.41 ms
(21.96%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.fonction_id AS fonction_id_6, t0.bailleurs_id AS bailleurs_id_7, t0.client_id AS client_id_8 FROM contacts t0 INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id WHERE intervention_site_contacts.intervention_site_id = ?

Parameters:

[
  853
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.fonction_id AS fonction_id_6,
  t0.bailleurs_id AS bailleurs_id_7,
  t0.client_id AS client_id_8
FROM
  contacts t0
  INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id
WHERE
  intervention_site_contacts.intervention_site_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.fonction_id AS fonction_id_6, t0.bailleurs_id AS bailleurs_id_7, t0.client_id AS client_id_8 FROM contacts t0 INNER JOIN intervention_site_contacts ON t0.id = intervention_site_contacts.contacts_id WHERE intervention_site_contacts.intervention_site_id = 853;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1014)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2726)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 108)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1698)
10	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498::block_body (line 184)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 99)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\Client\InterventionSiteController->index (line 65)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

7.71 ms
(17.99%)

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:

[
  894
]

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 = 894;

#	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->format (line 69)
8	App\Entity\Adresses->__toString (line 64)
9	Twig\Runtime\EscaperRuntime->escape (line 126)
10	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498->block_body (line 162)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 99)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\Client\InterventionSiteController->index (line 65)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

7.58 ms
(17.68%)

SELECT t0.id AS id_1, t0.information_acces AS information_acces_2, t0.commande_id AS commande_id_3, t0.intervention_site_id AS intervention_site_id_4, t0.contact_id AS contact_id_5 FROM commande_site t0 WHERE t0.intervention_site_id = ?

Parameters:

[
  853
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.information_acces AS information_acces_2,
  t0.commande_id AS commande_id_3,
  t0.intervention_site_id AS intervention_site_id_4,
  t0.contact_id AS contact_id_5
FROM
  commande_site t0
WHERE
  t0.intervention_site_id = ?

SELECT t0.id AS id_1, t0.information_acces AS information_acces_2, t0.commande_id AS commande_id_3, t0.intervention_site_id AS intervention_site_id_4, t0.contact_id AS contact_id_5 FROM commande_site t0 WHERE t0.intervention_site_id = 853;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 108)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1698)
10	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498::block_body (line 172)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_9b03751cddc6de49f1f52beb050844d9->doDisplay (line 99)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_c2951c83487e93c9ac0e5b944a73a498->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
23	App\Controller\Client\InterventionSiteController->index (line 65)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

2.18 ms
(5.10%)

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = ? AND i0_.bailleur_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT i0_.id) AS sclr_0
FROM
  intervention_site i0_
  LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id
WHERE
  i0_.client_id = ?
  AND i0_.bailleur_id = ?

SELECT count(DISTINCT i0_.id) AS sclr_0 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = 1 AND i0_.bailleur_id = 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->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\InterventionSiteController->index (line 58)
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)

1.66 ms
(3.86%)

SELECT DISTINCT i0_.id AS id_0 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = ? AND i0_.bailleur_id = ? LIMIT 35 OFFSET 420

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT i0_.id AS id_0
FROM
  intervention_site i0_
  LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id
WHERE
  i0_.client_id = ?
  AND i0_.bailleur_id = ?
LIMIT
  35
OFFSET
  420

SELECT DISTINCT i0_.id AS id_0 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = 1 AND i0_.bailleur_id = 29 LIMIT 35 OFFSET 420;

#	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\InterventionSiteController->index (line 58)
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.67 ms
(1.57%)

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 = ?

Parameters:

[
  1
]

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 = ?

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;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 888)
21	Symfony\Component\Form\Form->createView (line 891)
22	App\Controller\Client\InterventionSiteController->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.63 ms
(1.48%)

SELECT i0_.id AS id_0, i0_.nom AS nom_1, i0_.the_statut_id AS the_statut_id_2, i0_.reference AS reference_3, i0_.reference_index AS reference_index_4, i0_.reference_bailleur AS reference_bailleur_5, i0_.bailleur_id AS bailleur_id_6, i0_.adresse_id AS adresse_id_7, i0_.client_id AS client_id_8, i0_.agence_id AS agence_id_9 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = ? AND i0_.bailleur_id = ? AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.nom AS nom_1,
  i0_.the_statut_id AS the_statut_id_2,
  i0_.reference AS reference_3,
  i0_.reference_index AS reference_index_4,
  i0_.reference_bailleur AS reference_bailleur_5,
  i0_.bailleur_id AS bailleur_id_6,
  i0_.adresse_id AS adresse_id_7,
  i0_.client_id AS client_id_8,
  i0_.agence_id AS agence_id_9
FROM
  intervention_site i0_
  LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id
WHERE
  i0_.client_id = ?
  AND i0_.bailleur_id = ?
  AND i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT i0_.id AS id_0, i0_.nom AS nom_1, i0_.the_statut_id AS the_statut_id_2, i0_.reference AS reference_3, i0_.reference_index AS reference_index_4, i0_.reference_bailleur AS reference_bailleur_5, i0_.bailleur_id AS bailleur_id_6, i0_.adresse_id AS adresse_id_7, i0_.client_id AS client_id_8, i0_.agence_id AS agence_id_9 FROM intervention_site i0_ LEFT JOIN adresses a1_ ON i0_.adresse_id = a1_.id WHERE i0_.client_id = 1 AND i0_.bailleur_id = 29 AND i0_.id IN (853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887);

#	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\InterventionSiteController->index (line 58)
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.61 ms
(1.43%)

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.44 ms
(1.04%)

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.32 ms
(0.76%)

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_c2951c83487e93c9ac0e5b944a73a498->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\InterventionSiteController->index (line 65)
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.27 ms
(0.63%)

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)

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\Lieu	728
App\Entity\Occupant	728
App\Entity\Permission	54
App\Entity\InterventionSite	35
App\Entity\Adresses	35
App\Entity\Bailleurs	26
App\Entity\User	1
App\Entity\Clients	1
App\Entity\Secteurs	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.
App\Entity\Lieu	No errors.
App\Entity\CommandeSite	No errors.
App\Entity\Occupant	No errors.
App\Entity\Fonctions	No errors.

Symfony Profiler

GET https://www.test.fluxxo.fr/client/sites/?interventionSitePage=13

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping