Symfony Profiler

Query Metrics

176 Database Queries

10 Different statements

475.83 ms Query time

1 Invalid entities

357 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

397.59 ms
(83.56%)

SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id WHERE p0_.visible = ? AND p0_.center = ? ORDER BY RAND() ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.date AS date_0,
  p0_.email AS email_1,
  p0_.phone AS phone_2,
  p0_.site AS site_3,
  p0_.updated AS updated_4,
  p0_.center AS center_5,
  p0_.close AS close_6,
  p0_.created AS created_7,
  p0_.description AS description_8,
  p0_.id AS id_9,
  p0_.name AS name_10,
  p0_.slug AS slug_11,
  p0_.title AS title_12,
  p0_.visible AS visible_13,
  p0_.address_id AS address_id_14,
  p0_.pdf_id AS pdf_id_15,
  p0_.picture_id AS picture_id_16
FROM
  partner p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
  LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id
  LEFT JOIN category c2_ ON c2_.id = p3_.category_id
  LEFT JOIN view v4_ ON p0_.id = v4_.partner_id
  LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id
WHERE
  p0_.visible = ?
  AND p0_.center = ?
ORDER BY
  RAND() ASC

SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id WHERE p0_.visible = 1 AND p0_.center = 1 ORDER BY RAND() 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Site\PartnerSiteRepository->findAll (line 34)
7	App\Controller\Site\HomeSiteController->center (line 63)
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)

37.86 ms
(7.96%)

SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.partner_id = ?

Parameters:

[
  "2026-04-16 19:58:53"
  "216.73.216.62"
  1
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.ip AS ip_0,
  v0_.created AS created_1,
  v0_.env AS env_2,
  v0_.id AS id_3,
  v0_.preview AS preview_4,
  v0_.article_id AS article_id_5,
  v0_.event_id AS event_id_6,
  v0_.partner_id AS partner_id_7,
  v0_.talent_id AS talent_id_8,
  v0_.user_id AS user_id_9
FROM
  view v0_
WHERE
  v0_.created >= ?
  AND v0_.ip = ?
  AND v0_.preview = ?
  AND v0_.partner_id = ?

SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= '2026-04-16 19:58:53' AND v0_.ip = '216.73.216.62' AND v0_.preview = 1 AND v0_.partner_id = 77;

#	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\Repository\Site\ViewSiteRepository->verif (line 23)
7	App\Manager\ViewManager->new (line 16)
8	App\Twig\ViewExtension->new (line 23)
9	__TwigTemplate_7a797cc5610cf47ac198aa682e8a792c->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_520f414582f1db1093a5d3a7ffc04795->doDisplay (line 65)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 132)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->doDisplay (line 54)
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 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Site\HomeSiteController->center (line 62)
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)

16.41 ms
(3.45%)

SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.event_id = ?

Parameters:

[
  "2026-04-16 19:58:53"
  "216.73.216.62"
  1
  2408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.ip AS ip_0,
  v0_.created AS created_1,
  v0_.env AS env_2,
  v0_.id AS id_3,
  v0_.preview AS preview_4,
  v0_.article_id AS article_id_5,
  v0_.event_id AS event_id_6,
  v0_.partner_id AS partner_id_7,
  v0_.talent_id AS talent_id_8,
  v0_.user_id AS user_id_9
FROM
  view v0_
WHERE
  v0_.created >= ?
  AND v0_.ip = ?
  AND v0_.preview = ?
  AND v0_.event_id = ?

SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= '2026-04-16 19:58:53' AND v0_.ip = '216.73.216.62' AND v0_.preview = 1 AND v0_.event_id = 2408;

#	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\Repository\Site\ViewSiteRepository->verif (line 23)
7	App\Manager\ViewManager->new (line 16)
8	App\Twig\ViewExtension->new (line 23)
9	__TwigTemplate_ea4fc572d4aae90c7e103f9730c14017->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1ebc15e165206666a364e91c943c49d5->doDisplay (line 66)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 125)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->doDisplay (line 54)
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 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Site\HomeSiteController->center (line 62)
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)

7.56 ms
(1.59%)

SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?

Parameters:

[
  8718
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.position AS position_1,
  t0.updated AS updated_2,
  t0.created AS created_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.article_id AS article_id_6,
  t0.partner_id AS partner_id_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = 8718;

#	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 295)
4	Proxies\__CG__\App\Entity\File::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\File->__get (line 153)
7	App\Entity\Abstract\AbstractFile->getName (line 9)
8	App\Entity\Event->getPicturePath (line 114)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_ea4fc572d4aae90c7e103f9730c14017::doDisplay (line 107)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_1ebc15e165206666a364e91c943c49d5->doDisplay (line 66)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 125)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->doDisplay (line 54)
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 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\Site\HomeSiteController->center (line 62)
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)

5.71 ms
(1.20%)

SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = ? AND e0_.visible = ? AND e0_.center = ? ORDER BY d1_.start ASC

Parameters:

[
  "valid"
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.email AS email_0,
  e0_.phone AS phone_1,
  e0_.site AS site_2,
  e0_.updated AS updated_3,
  e0_.center AS center_4,
  e0_.created AS created_5,
  e0_.description AS description_6,
  e0_.id AS id_7,
  e0_.slug AS slug_8,
  e0_.status AS status_9,
  e0_.title AS title_10,
  e0_.visible AS visible_11,
  e0_.address_id AS address_id_12,
  e0_.partner_id AS partner_id_13,
  e0_.picture_id AS picture_id_14,
  e0_.user_id AS user_id_15
FROM
  event e0_
  INNER JOIN date d1_ ON e0_.id = d1_.event_id
  LEFT JOIN address a2_ ON e0_.address_id = a2_.id
  LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id
  LEFT JOIN category c3_ ON c3_.id = e4_.category_id
  LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id
  LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id
WHERE
  e0_.status = ?
  AND e0_.visible = ?
  AND e0_.center = ?
ORDER BY
  d1_.start ASC

SELECT e0_.email AS email_0, e0_.phone AS phone_1, e0_.site AS site_2, e0_.updated AS updated_3, e0_.center AS center_4, e0_.created AS created_5, e0_.description AS description_6, e0_.id AS id_7, e0_.slug AS slug_8, e0_.status AS status_9, e0_.title AS title_10, e0_.visible AS visible_11, e0_.address_id AS address_id_12, e0_.partner_id AS partner_id_13, e0_.picture_id AS picture_id_14, e0_.user_id AS user_id_15 FROM event e0_ INNER JOIN date d1_ ON e0_.id = d1_.event_id LEFT JOIN address a2_ ON e0_.address_id = a2_.id LEFT JOIN event_category e4_ ON e0_.id = e4_.event_id LEFT JOIN category c3_ ON c3_.id = e4_.category_id LEFT JOIN event_talent e6_ ON e0_.id = e6_.event_id LEFT JOIN talent t5_ ON t5_.id = e6_.talent_id WHERE e0_.status = 'valid' AND e0_.visible = 1 AND e0_.center = 1 ORDER BY d1_.start 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Site\EventSiteRepository->findAll (line 37)
7	App\Controller\Site\HomeSiteController->center (line 64)
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)

5.25 ms
(1.10%)

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = ? ORDER BY t0.start ASC

Parameters:

[
  2408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.updated AS updated_1,
  t0.created AS created_2,
  t0.end AS end_3,
  t0.id AS id_4,
  t0.start AS start_5,
  t0.event_id AS event_id_6
FROM
  date t0
WHERE
  t0.event_id = ?
ORDER BY
  t0.start ASC

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.end AS end_3, t0.id AS id_4, t0.start AS start_5, t0.event_id AS event_id_6 FROM date t0 WHERE t0.event_id = 2408 ORDER BY t0.start ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Twig\Extension\CoreExtension->slice (line 753)
8	Twig\Extension\CoreExtension::first (line 785)
9	__TwigTemplate_ea4fc572d4aae90c7e103f9730c14017::doDisplay (line 91)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1ebc15e165206666a364e91c943c49d5->doDisplay (line 66)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 125)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->doDisplay (line 54)
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 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Site\HomeSiteController->center (line 62)
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)

2.67 ms
(0.56%)

INSERT INTO view (ip, created, env, preview, article_id, event_id, partner_id, talent_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "216.73.216.62"
  "2026-04-17 19:58:53"
  "site"
  1
  null
  2408
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO view (
  ip, created, env, preview, article_id,
  event_id, partner_id, talent_id,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO view (ip, created, env, preview, article_id, event_id, partner_id, talent_id, user_id) VALUES ('216.73.216.62', '2026-04-17 19:58:53', 'site', 1, NULL, 2408, NULL, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Manager\ViewManager->new (line 22)
7	App\Twig\ViewExtension->new (line 23)
8	__TwigTemplate_ea4fc572d4aae90c7e103f9730c14017->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_1ebc15e165206666a364e91c943c49d5->doDisplay (line 66)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 125)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->doDisplay (line 54)
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 463)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
25	App\Controller\Site\HomeSiteController->center (line 62)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

2.27 ms
(0.48%)

SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = ?

Parameters:

[
  77
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.break AS break_1,
  t0.resume AS resume_2,
  t0.updated AS updated_3,
  t0.close AS close_4,
  t0.created AS created_5,
  t0.day AS day_6,
  t0.id AS id_7,
  t0.open AS open_8,
  t0.partner_id AS partner_id_9
FROM
  schedule t0
WHERE
  t0.partner_id = ?

SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = 77;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1415)
9	__TwigTemplate_7921d130fad89ceba131992efd4cd30e::doDisplay (line 105)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_7a797cc5610cf47ac198aa682e8a792c->doDisplay (line 78)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_520f414582f1db1093a5d3a7ffc04795->doDisplay (line 65)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 132)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->doDisplay (line 54)
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 463)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
28	App\Controller\Site\HomeSiteController->center (line 62)
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)

0.34 ms
(0.07%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Manager\ViewManager->new (line 22)
4	App\Twig\ViewExtension->new (line 23)
5	__TwigTemplate_ea4fc572d4aae90c7e103f9730c14017->doDisplay (line 48)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_1ebc15e165206666a364e91c943c49d5->doDisplay (line 66)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 125)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->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 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\Site\HomeSiteController->center (line 62)
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.16 ms
(0.03%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Manager\ViewManager->new (line 22)
4	App\Twig\ViewExtension->new (line 23)
5	__TwigTemplate_ea4fc572d4aae90c7e103f9730c14017->doDisplay (line 48)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_1ebc15e165206666a364e91c943c49d5->doDisplay (line 66)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->block_body (line 125)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5e50d261fee326ef02242668f8b152f3->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 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\Site\HomeSiteController->center (line 62)
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)

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\Schedule	68
App\Entity\Date	60
App\Entity\View	53
App\Entity\Address	52
App\Entity\File	52
App\Entity\Event	37
App\Entity\Partner	23
App\Entity\User	12

Entities Mapping

Class	Mapping errors
App\Entity\Partner	No errors.
App\Entity\Address	No errors.
App\Entity\Category	No errors.
App\Entity\View	No errors.
App\Entity\Like	No errors.
App\Entity\File	No errors.
App\Entity\Article	No errors.
App\Entity\Estate	No errors.
App\Entity\Event	No errors.
App\Entity\Job	No errors.
App\Entity\Network	No errors.
App\Entity\Reduction	No errors.
App\Entity\Schedule	No errors.
App\Entity\Date	No errors.
App\Entity\Talent	No errors.
App\Entity\User	The association App\Entity\User#partners refers to the owning side field App\Entity\Partner#user which does not exist.

Symfony Profiler

GET https://dev.wakeupamiens.fr/centre-ville

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping