Symfony Profiler

Query Metrics

51 Database Queries

12 Different statements

79.43 ms Query time

0 Invalid entities

65 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.90 ms
(21.27%)

SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestation p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestation p0_
  INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id)
  INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id)
WHERE
  p0_.id = ?
LIMIT
  1

SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestation p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = 14 LIMIT 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\EntityGetAlias->generateUrlByEntity (line 31)
7	App\Twig\AppExtension->generateUrlByEntity (line 112)
8	__TwigTemplate_131bbd64790615f88522186125a34577->doDisplay (line 50)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_e1c7e722f4eb562cbdf839838454d7b8::doDisplay (line 81)
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\Extension\CoreExtension->include (line 1520)
20	__TwigTemplate_da6723e99791a0df9f909133945813b9::block_body (line 251)
21	Twig\Template->yieldBlock (line 446)
22	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e->doDisplay (line 100)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
33	App\Service\EntityRenderer->renderPrestation (line 94)
34	App\Controller\PrestationController->show (line 37)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 182)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

14.76 ms
(18.58%)

SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = ? LIMIT 1

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.url_alias AS url_alias_0,
  a0_.id AS id_1
FROM
  activity_domain a0_
  INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id)
  INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id)
WHERE
  a0_.id = ?
LIMIT
  1

SELECT a0_.url_alias AS url_alias_0, a0_.id AS id_1 FROM activity_domain a0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = a0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE a0_.id = 8 LIMIT 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\EntityGetAlias->generateUrlByEntity (line 31)
7	App\Twig\AppExtension->generateUrlByEntity (line 112)
8	__TwigTemplate_f01d7fef6e4b5f5251846cbf32939011->doDisplay (line 79)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e::doDisplay (line 103)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
25	App\Service\EntityRenderer->renderPrestation (line 94)
26	App\Controller\PrestationController->show (line 37)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

13.43 ms
(16.91%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = ? AND m0_.region = ? ORDER BY m0_.id ASC, m0_.weight DESC

Parameters:

[
  1
  "header"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.region AS region_2,
  m0_.link AS link_3,
  m0_.weight AS weight_4,
  m0_.created_at AS created_at_5,
  m0_.updated_at AS updated_at_6,
  m0_.uuid AS uuid_7,
  m0_.status AS status_8,
  m0_.user_id AS user_id_9
FROM
  menu_link m0_
WHERE
  m0_.status = ?
  AND m0_.region = ?
ORDER BY
  m0_.id ASC,
  m0_.weight DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.region AS region_2, m0_.link AS link_3, m0_.weight AS weight_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.uuid AS uuid_7, m0_.status AS status_8, m0_.user_id AS user_id_9 FROM menu_link m0_ WHERE m0_.status = 1 AND m0_.region = 'header' ORDER BY m0_.id ASC, m0_.weight DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MenuLinkRepository->loadLinksByRegionDisplay (line 25)
7	App\Service\EntitiesLoad->loadHeaderLinks (line 31)
8	App\Twig\AppExtension->loadHeaderLinks (line 80)
9	__TwigTemplate_256e29d11d333021db4edb894360fee5->doDisplay (line 61)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1520)
15	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e::doDisplay (line 91)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Service\EntityRenderer->renderPrestation (line 94)
27	App\Controller\PrestationController->show (line 37)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

6.93 ms
(8.73%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.prix AS prix_3, p0_.abonnement_status AS abonnement_status_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.url_alias AS url_alias_7, p0_.auto_generate_alias AS auto_generate_alias_8, p0_.uuid AS uuid_9, p0_.approval_status AS approval_status_10, p0_.approved_at AS approved_at_11, p0_.status AS status_12, p0_.prestataire_id AS prestataire_id_13, p0_.activity_domain_id AS activity_domain_id_14 FROM prestation p0_ WHERE p0_.prestataire_id = ? AND p0_.id <> ? LIMIT 9

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.prix AS prix_3,
  p0_.abonnement_status AS abonnement_status_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.url_alias AS url_alias_7,
  p0_.auto_generate_alias AS auto_generate_alias_8,
  p0_.uuid AS uuid_9,
  p0_.approval_status AS approval_status_10,
  p0_.approved_at AS approved_at_11,
  p0_.status AS status_12,
  p0_.prestataire_id AS prestataire_id_13,
  p0_.activity_domain_id AS activity_domain_id_14
FROM
  prestation p0_
WHERE
  p0_.prestataire_id = ?
  AND p0_.id <> ?
LIMIT
  9

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.prix AS prix_3, p0_.abonnement_status AS abonnement_status_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.url_alias AS url_alias_7, p0_.auto_generate_alias AS auto_generate_alias_8, p0_.uuid AS uuid_9, p0_.approval_status AS approval_status_10, p0_.approved_at AS approved_at_11, p0_.status AS status_12, p0_.prestataire_id AS prestataire_id_13, p0_.activity_domain_id AS activity_domain_id_14 FROM prestation p0_ WHERE p0_.prestataire_id = 2 AND p0_.id <> 12 LIMIT 9;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\EntityRenderer->renderPrestation (line 88)
7	App\Controller\PrestationController->show (line 37)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

6.24 ms
(7.85%)

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.response AS response_3, r0_.response_at AS response_at_4, r0_.approval_status AS approval_status_5, r0_.approved_at AS approved_at_6, r0_.status AS status_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.service_request_id AS service_request_id_10 FROM review r0_ INNER JOIN service_request s1_ ON r0_.service_request_id = s1_.id INNER JOIN prestataire p2_ ON s1_.prestataire_id = p2_.id INNER JOIN prestation p3_ ON p2_.id = p3_.prestataire_id WHERE p3_.id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.rating AS rating_1,
  r0_.comment AS comment_2,
  r0_.response AS response_3,
  r0_.response_at AS response_at_4,
  r0_.approval_status AS approval_status_5,
  r0_.approved_at AS approved_at_6,
  r0_.status AS status_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9,
  r0_.service_request_id AS service_request_id_10
FROM
  review r0_
  INNER JOIN service_request s1_ ON r0_.service_request_id = s1_.id
  INNER JOIN prestataire p2_ ON s1_.prestataire_id = p2_.id
  INNER JOIN prestation p3_ ON p2_.id = p3_.prestataire_id
WHERE
  p3_.id = ?

SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.response AS response_3, r0_.response_at AS response_at_4, r0_.approval_status AS approval_status_5, r0_.approved_at AS approved_at_6, r0_.status AS status_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.service_request_id AS service_request_id_10 FROM review r0_ INNER JOIN service_request s1_ ON r0_.service_request_id = s1_.id INNER JOIN prestataire p2_ ON s1_.prestataire_id = p2_.id INNER JOIN prestation p3_ ON p2_.id = p3_.prestataire_id WHERE p3_.id = 12;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\EntityRenderer->renderPrestation (line 80)
7	App\Controller\PrestationController->show (line 37)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

4.84 ms
(6.09%)

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 INNER JOIN prestation_files ON t0.id = prestation_files.files_id WHERE prestation_files.image_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.original_name AS original_name_3,
  t0.file_size AS file_size_4,
  t0.mime_type AS mime_type_5,
  t0.type AS type_6,
  t0.description AS description_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  files t0
  INNER JOIN prestation_files ON t0.id = prestation_files.files_id
WHERE
  prestation_files.image_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 INNER JOIN prestation_files ON t0.id = prestation_files.files_id WHERE prestation_files.image_id = 12;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
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->getIterator (line 313)
7	__TwigTemplate_a52abe374fe8da5aa678d36d9d82c316->doDisplay (line 59)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1520)
13	__TwigTemplate_da6723e99791a0df9f909133945813b9::block_body (line 219)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e->doDisplay (line 100)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
26	App\Service\EntityRenderer->renderPrestation (line 94)
27	App\Controller\PrestationController->show (line 37)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 5)

4.31 ms
(5.43%)

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.original_name AS original_name_3,
  t0.file_size AS file_size_4,
  t0.mime_type AS mime_type_5,
  t0.type AS type_6,
  t0.description AS description_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.user_id AS user_id_10
FROM
  files t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.mime_type AS mime_type_5, t0.type AS type_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM files t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Files::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Files->initializeLazyObject (line 106)
7	Proxies\__CG__\App\Entity\Files->__load (line 20)
8	Vich\UploaderBundle\Mapping\PropertyMappingFactory->fromField (line 79)
9	Vich\UploaderBundle\Storage\AbstractStorage->getFilename (line 144)
10	Vich\UploaderBundle\Storage\FileSystemStorage->resolveUri (line 68)
11	Vich\UploaderBundle\Templating\Helper\UploaderHelper->asset (line 35)
12	Vich\UploaderBundle\Twig\Extension\UploaderExtensionRuntime->asset (line 28)
13	__TwigTemplate_806b74bb3360c45356ddfb8a997cd8d6->doDisplay (line 62)
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\Extension\CoreExtension->include (line 1520)
19	__TwigTemplate_da6723e99791a0df9f909133945813b9::block_body (line 210)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e->doDisplay (line 100)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
32	App\Service\EntityRenderer->renderPrestation (line 94)
33	App\Controller\PrestationController->show (line 37)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 182)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 5)

3.93 ms
(4.95%)

SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = ? LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.url_alias AS url_alias_0,
  p0_.id AS id_1
FROM
  prestataire p0_
  INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id)
  INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id)
WHERE
  p0_.id = ?
LIMIT
  1

SELECT p0_.url_alias AS url_alias_0, p0_.id AS id_1 FROM prestataire p0_ INNER JOIN entity_url_alias e1_ ON (e1_.entity_id = p0_.id) INNER JOIN entity_type_alias e2_ ON (e2_.id = e1_.type_alias_id) WHERE p0_.id = 2 LIMIT 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\EntityGetAlias->generateUrlByEntity (line 31)
7	App\Twig\AppExtension->generateUrlByEntity (line 112)
8	__TwigTemplate_806b74bb3360c45356ddfb8a997cd8d6->doDisplay (line 50)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_da6723e99791a0df9f909133945813b9::block_body (line 210)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e->doDisplay (line 100)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
27	App\Service\EntityRenderer->renderPrestation (line 94)
28	App\Controller\PrestationController->show (line 37)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 5)

2.46 ms
(3.10%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.prix AS prix_4, t0.abonnement_status AS abonnement_status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.url_alias AS url_alias_8, t0.auto_generate_alias AS auto_generate_alias_9, t0.uuid AS uuid_10, t0.approval_status AS approval_status_11, t0.approved_at AS approved_at_12, t0.status AS status_13, t0.prestataire_id AS prestataire_id_14, t0.activity_domain_id AS activity_domain_id_15 FROM prestation t0 WHERE t0.id = ?

Parameters:

[
  "12"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.prix AS prix_4,
  t0.abonnement_status AS abonnement_status_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.url_alias AS url_alias_8,
  t0.auto_generate_alias AS auto_generate_alias_9,
  t0.uuid AS uuid_10,
  t0.approval_status AS approval_status_11,
  t0.approved_at AS approved_at_12,
  t0.status AS status_13,
  t0.prestataire_id AS prestataire_id_14,
  t0.activity_domain_id AS activity_domain_id_15
FROM
  prestation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.prix AS prix_4, t0.abonnement_status AS abonnement_status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.url_alias AS url_alias_8, t0.auto_generate_alias AS auto_generate_alias_9, t0.uuid AS uuid_10, t0.approval_status AS approval_status_11, t0.approved_at AS approved_at_12, t0.status AS status_13, t0.prestataire_id AS prestataire_id_14, t0.activity_domain_id AS activity_domain_id_15 FROM prestation t0 WHERE t0.id = '12';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
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\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

2.22 ms
(2.79%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.is_verified AS is_verified_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone AS phone_8,
  t0.address AS address_9,
  t0.gender AS gender_10,
  t0.birth_date AS birth_date_11,
  t0.last_login AS last_login_12,
  t0.login_type AS login_type_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.uuid AS uuid_16,
  t17.id AS id_18,
  t17.name AS name_19,
  t17.description AS description_20,
  t17.created_at AS created_at_21,
  t17.updated_at AS updated_at_22,
  t17.uuid AS uuid_23,
  t17.user_id AS user_id_24,
  t17.profile_image_id AS profile_image_id_25,
  t17.localisation_id AS localisation_id_26,
  t27.id AS id_28,
  t27.name AS name_29,
  t27.description AS description_30,
  t27.qualites AS qualites_31,
  t27.abonnement_status AS abonnement_status_32,
  t27.created_at AS created_at_33,
  t27.updated_at AS updated_at_34,
  t27.url_alias AS url_alias_35,
  t27.auto_generate_alias AS auto_generate_alias_36,
  t27.uuid AS uuid_37,
  t27.approval_status AS approval_status_38,
  t27.approved_at AS approved_at_39,
  t27.status AS status_40,
  t27.user_id AS user_id_41,
  t27.localisation_id AS localisation_id_42,
  t27.profile_image_id AS profile_image_id_43,
  t44.id AS id_45,
  t44.access_token AS access_token_46,
  t44.token_type AS token_type_47,
  t44.expires_in AS expires_in_48,
  t44.scope AS scope_49,
  t44.linkedin_user_id AS linkedin_user_id_50,
  t44.expires_at AS expires_at_51,
  t44.is_active AS is_active_52,
  t44.created_at AS created_at_53,
  t44.updated_at AS updated_at_54,
  t44.user_id AS user_id_55
FROM
  "user" t0
  LEFT JOIN client t17 ON t17.user_id = t0.id
  LEFT JOIN prestataire t27 ON t27.user_id = t0.id
  LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.address AS address_9, t0.gender AS gender_10, t0.birth_date AS birth_date_11, t0.last_login AS last_login_12, t0.login_type AS login_type_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.uuid AS uuid_16, t17.id AS id_18, t17.name AS name_19, t17.description AS description_20, t17.created_at AS created_at_21, t17.updated_at AS updated_at_22, t17.uuid AS uuid_23, t17.user_id AS user_id_24, t17.profile_image_id AS profile_image_id_25, t17.localisation_id AS localisation_id_26, t27.id AS id_28, t27.name AS name_29, t27.description AS description_30, t27.qualites AS qualites_31, t27.abonnement_status AS abonnement_status_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.url_alias AS url_alias_35, t27.auto_generate_alias AS auto_generate_alias_36, t27.uuid AS uuid_37, t27.approval_status AS approval_status_38, t27.approved_at AS approved_at_39, t27.status AS status_40, t27.user_id AS user_id_41, t27.localisation_id AS localisation_id_42, t27.profile_image_id AS profile_image_id_43, t44.id AS id_45, t44.access_token AS access_token_46, t44.token_type AS token_type_47, t44.expires_in AS expires_in_48, t44.scope AS scope_49, t44.linkedin_user_id AS linkedin_user_id_50, t44.expires_at AS expires_at_51, t44.is_active AS is_active_52, t44.created_at AS created_at_53, t44.updated_at AS updated_at_54, t44.user_id AS user_id_55 FROM "user" t0 LEFT JOIN client t17 ON t17.user_id = t0.id LEFT JOIN prestataire t27 ON t27.user_id = t0.id LEFT JOIN linkedin_tokens t44 ON t44.user_id = t0.id WHERE t0.id = 14;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\User->__get (line 153)
7	App\Entity\User->getFirstName (line 280)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_806b74bb3360c45356ddfb8a997cd8d6::doDisplay (line 76)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1520)
15	__TwigTemplate_da6723e99791a0df9f909133945813b9::block_body (line 210)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e->doDisplay (line 100)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Service\EntityRenderer->renderPrestation (line 94)
29	App\Controller\PrestationController->show (line 37)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

1.88 ms
(2.37%)

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.name AS name_2, a0_.description AS description_3, a0_.icon AS icon_4, a0_.level AS level_5, a0_.url_alias AS url_alias_6, a0_.auto_generate_alias AS auto_generate_alias_7, a0_.status AS status_8, a0_.parent_id AS parent_id_9 FROM activity_domain a0_ WHERE a0_.status = ? AND a0_.parent_id IS NULL ORDER BY a0_.name ASC LIMIT 9

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.uuid AS uuid_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.icon AS icon_4,
  a0_.level AS level_5,
  a0_.url_alias AS url_alias_6,
  a0_.auto_generate_alias AS auto_generate_alias_7,
  a0_.status AS status_8,
  a0_.parent_id AS parent_id_9
FROM
  activity_domain a0_
WHERE
  a0_.status = ?
  AND a0_.parent_id IS NULL
ORDER BY
  a0_.name ASC
LIMIT
  9

SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.name AS name_2, a0_.description AS description_3, a0_.icon AS icon_4, a0_.level AS level_5, a0_.url_alias AS url_alias_6, a0_.auto_generate_alias AS auto_generate_alias_7, a0_.status AS status_8, a0_.parent_id AS parent_id_9 FROM activity_domain a0_ WHERE a0_.status = 1 AND a0_.parent_id IS NULL ORDER BY a0_.name ASC LIMIT 9;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ActivityDomainRepository->findActiveActivityDomain (line 37)
7	App\Service\ActivityDomainLoader->getActiveDomains (line 15)
8	__TwigTemplate_f01d7fef6e4b5f5251846cbf32939011->doDisplay (line 73)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Extension\CoreExtension->include (line 1520)
14	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e::doDisplay (line 103)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
25	App\Service\EntityRenderer->renderPrestation (line 94)
26	App\Controller\PrestationController->show (line 37)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

1.53 ms
(1.92%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.qualites AS qualites_4, t0.abonnement_status AS abonnement_status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.url_alias AS url_alias_8, t0.auto_generate_alias AS auto_generate_alias_9, t0.uuid AS uuid_10, t0.approval_status AS approval_status_11, t0.approved_at AS approved_at_12, t0.status AS status_13, t0.user_id AS user_id_14, t0.localisation_id AS localisation_id_15, t0.profile_image_id AS profile_image_id_16, t17.id AS id_18, t17.total_orders AS total_orders_19, t17.completed_orders AS completed_orders_20, t17.in_progress_orders AS in_progress_orders_21, t17.cancel_orders AS cancel_orders_22, t17.total_reviews AS total_reviews_23, t17.average_rating AS average_rating_24, t17.positive_reviews AS positive_reviews_25, t17.negative_reviews AS negative_reviews_26, t17.average_response_time AS average_response_time_27, t17.total_earnings AS total_earnings_28, t17.completion_rate AS completion_rate_29, t17.last_updated AS last_updated_30, t17.uuid AS uuid_31, t17.prestataire_id AS prestataire_id_32 FROM prestataire t0 LEFT JOIN prestataire_stats t17 ON t17.prestataire_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.qualites AS qualites_4,
  t0.abonnement_status AS abonnement_status_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.url_alias AS url_alias_8,
  t0.auto_generate_alias AS auto_generate_alias_9,
  t0.uuid AS uuid_10,
  t0.approval_status AS approval_status_11,
  t0.approved_at AS approved_at_12,
  t0.status AS status_13,
  t0.user_id AS user_id_14,
  t0.localisation_id AS localisation_id_15,
  t0.profile_image_id AS profile_image_id_16,
  t17.id AS id_18,
  t17.total_orders AS total_orders_19,
  t17.completed_orders AS completed_orders_20,
  t17.in_progress_orders AS in_progress_orders_21,
  t17.cancel_orders AS cancel_orders_22,
  t17.total_reviews AS total_reviews_23,
  t17.average_rating AS average_rating_24,
  t17.positive_reviews AS positive_reviews_25,
  t17.negative_reviews AS negative_reviews_26,
  t17.average_response_time AS average_response_time_27,
  t17.total_earnings AS total_earnings_28,
  t17.completion_rate AS completion_rate_29,
  t17.last_updated AS last_updated_30,
  t17.uuid AS uuid_31,
  t17.prestataire_id AS prestataire_id_32
FROM
  prestataire t0
  LEFT JOIN prestataire_stats t17 ON t17.prestataire_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.qualites AS qualites_4, t0.abonnement_status AS abonnement_status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.url_alias AS url_alias_8, t0.auto_generate_alias AS auto_generate_alias_9, t0.uuid AS uuid_10, t0.approval_status AS approval_status_11, t0.approved_at AS approved_at_12, t0.status AS status_13, t0.user_id AS user_id_14, t0.localisation_id AS localisation_id_15, t0.profile_image_id AS profile_image_id_16, t17.id AS id_18, t17.total_orders AS total_orders_19, t17.completed_orders AS completed_orders_20, t17.in_progress_orders AS in_progress_orders_21, t17.cancel_orders AS cancel_orders_22, t17.total_reviews AS total_reviews_23, t17.average_rating AS average_rating_24, t17.positive_reviews AS positive_reviews_25, t17.negative_reviews AS negative_reviews_26, t17.average_response_time AS average_response_time_27, t17.total_earnings AS total_earnings_28, t17.completion_rate AS completion_rate_29, t17.last_updated AS last_updated_30, t17.uuid AS uuid_31, t17.prestataire_id AS prestataire_id_32 FROM prestataire t0 LEFT JOIN prestataire_stats t17 ON t17.prestataire_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Prestataire::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Prestataire->__isset (line 258)
7	App\Entity\Prestataire->getPrestataireStats (line 184)
8	Twig\Extension\CoreExtension->getAttribute (line 1913)
9	__TwigTemplate_5c0227a65792d5811ee40fe0327a2a9c::doDisplay (line 56)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1520)
15	__TwigTemplate_da6723e99791a0df9f909133945813b9::block_body (line 206)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_6a5d1c191e6174133b7e2cb79c5a674e->doDisplay (line 100)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_da6723e99791a0df9f909133945813b9->doDisplay (line 57)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Service\EntityRenderer->renderPrestation (line 94)
29	App\Controller\PrestationController->show (line 37)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	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\Files	33
App\Entity\MenuLink	11
App\Entity\ActivityDomain	9
App\Entity\Prestation	8
App\Entity\User	2
App\Entity\Prestataire	1
App\Entity\Localisation	1

Entities Mapping

Class	Mapping errors
App\Entity\Prestation	No errors.
App\Entity\Prestataire	No errors.
App\Entity\ActivityDomain	No errors.
App\Entity\Files	No errors.
App\Entity\Favori	No errors.
App\Entity\Client	No errors.
App\Entity\ServiceRequest	No errors.
App\Entity\Review	No errors.
App\Entity\MenuLink	No errors.
App\Entity\User	No errors.
App\Entity\Localisation	No errors.
App\Entity\PrestataireStats	No errors.
App\Entity\Proposition	No errors.
App\Entity\Order	No errors.
App\Entity\EntityUrlAlias	No errors.
App\Entity\EntityTypeAlias	No errors.
App\Entity\LinkedinToken	No errors.
App\Entity\AppelOffre	No errors.

Symfony Profiler

GET https://preprod.linko.ci/prestation/12

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping