Symfony Profiler

Query Metrics

148 Database Queries

18 Different statements

987.37 ms Query time

1 Invalid entities

385 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

496.11 ms
(50.25%)

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 INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id WHERE p0_.visible = ? AND s6_.day = ? AND s6_.open <= ? AND ? <= s6_.close ORDER BY RAND() ASC LIMIT 10

Parameters:

[
  1
  "Friday"
  "2026-06-05 20:07:16"
  "2026-06-05 20:07:16"
]

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
  INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id
WHERE
  p0_.visible = ?
  AND s6_.day = ?
  AND s6_.open <= ?
  AND ? <= s6_.close
ORDER BY
  RAND() ASC
LIMIT
  10

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 INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id WHERE p0_.visible = 1 AND s6_.day = 'Friday' AND s6_.open <= '2026-06-05 20:07:16' AND '2026-06-05 20:07:16' <= s6_.close ORDER BY RAND() ASC LIMIT 10;

#	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->index (line 34)
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)

403.83 ms
(40.90%)

SELECT t0_.email AS email_0, t0_.phone AS phone_1, t0_.site AS site_2, t0_.updated AS updated_3, t0_.created AS created_4, t0_.description AS description_5, t0_.id AS id_6, t0_.name AS name_7, t0_.slug AS slug_8, t0_.visible AS visible_9, t0_.picture_id AS picture_id_10 FROM talent t0_ LEFT JOIN event_talent e2_ ON t0_.id = e2_.talent_id LEFT JOIN event e1_ ON e1_.id = e2_.event_id LEFT JOIN view v3_ ON t0_.id = v3_.talent_id LEFT JOIN `like` l4_ ON t0_.id = l4_.talent_id WHERE t0_.visible = ? ORDER BY RAND() ASC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.email AS email_0,
  t0_.phone AS phone_1,
  t0_.site AS site_2,
  t0_.updated AS updated_3,
  t0_.created AS created_4,
  t0_.description AS description_5,
  t0_.id AS id_6,
  t0_.name AS name_7,
  t0_.slug AS slug_8,
  t0_.visible AS visible_9,
  t0_.picture_id AS picture_id_10
FROM
  talent t0_
  LEFT JOIN event_talent e2_ ON t0_.id = e2_.talent_id
  LEFT JOIN event e1_ ON e1_.id = e2_.event_id
  LEFT JOIN view v3_ ON t0_.id = v3_.talent_id
  LEFT JOIN `like` l4_ ON t0_.id = l4_.talent_id
WHERE
  t0_.visible = ?
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT t0_.email AS email_0, t0_.phone AS phone_1, t0_.site AS site_2, t0_.updated AS updated_3, t0_.created AS created_4, t0_.description AS description_5, t0_.id AS id_6, t0_.name AS name_7, t0_.slug AS slug_8, t0_.visible AS visible_9, t0_.picture_id AS picture_id_10 FROM talent t0_ LEFT JOIN event_talent e2_ ON t0_.id = e2_.talent_id LEFT JOIN event e1_ ON e1_.id = e2_.event_id LEFT JOIN view v3_ ON t0_.id = v3_.talent_id LEFT JOIN `like` l4_ ON t0_.id = l4_.talent_id WHERE t0_.visible = 1 ORDER BY RAND() ASC LIMIT 10;

#	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\TalentSiteRepository->findAll (line 28)
7	App\Controller\Site\HomeSiteController->index (line 35)
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)

48.95 ms
(4.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_.talent_id = ?

Parameters:

[
  "2026-06-04 20:07:17"
  "216.73.216.142"
  1
  23
]

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_.talent_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-06-04 20:07:17' AND v0_.ip = '216.73.216.142' AND v0_.preview = 1 AND v0_.talent_id = 23;

#	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_297600d3b6a517762e6a47ed69da2e26->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_0f79582d16a181ad90f2cfbbb9870e63->doDisplay (line 63)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 133)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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)

8.72 ms
(0.88%)

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_.article_id = ?

Parameters:

[
  "2026-06-04 20:07:17"
  "216.73.216.142"
  1
  518
]

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_.article_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-06-04 20:07:17' AND v0_.ip = '216.73.216.142' AND v0_.preview = 1 AND v0_.article_id = 518;

#	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_512d323bcdd48ba7e2f447debb566f85->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_07dc52f4d3fd47df298e3e2533c3a44f->doDisplay (line 65)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 95)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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.51 ms
(0.76%)

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:

[
  10110
]

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

#	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\Article->getPicturePath (line 60)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_5097294756670f6359880208adbc8997::doDisplay (line 74)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_512d323bcdd48ba7e2f447debb566f85->doDisplay (line 78)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_07dc52f4d3fd47df298e3e2533c3a44f->doDisplay (line 65)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 95)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
29	App\Controller\Site\HomeSiteController->index (line 29)
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)

6.78 ms
(0.69%)

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-06-04 20:07:17"
  "216.73.216.142"
  1
  2776
]

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-06-04 20:07:17' AND v0_.ip = '216.73.216.142' AND v0_.preview = 1 AND v0_.event_id = 2776;

#	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_a9086cae7b2b7683015be06000130455->block_body (line 102)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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)

4.34 ms
(0.44%)

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 d1_.start <= ? AND d1_.end >= ? ORDER BY d1_.start ASC

Parameters:

[
  "valid"
  1
  "2026-06-05 23:59:59"
  "2026-06-05 00:00:00"
]

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 d1_.start <= ?
  AND d1_.end >= ?
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 d1_.start <= '2026-06-05 23:59:59' AND d1_.end >= '2026-06-05 00:00:00' 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->now (line 70)
7	App\Controller\Site\HomeSiteController->index (line 31)
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)

2.10 ms
(0.21%)

SELECT t0.date AS date_1, t0.email AS email_2, t0.phone AS phone_3, t0.site AS site_4, t0.updated AS updated_5, t0.center AS center_6, t0.close AS close_7, t0.created AS created_8, t0.description AS description_9, t0.id AS id_10, t0.name AS name_11, t0.slug AS slug_12, t0.title AS title_13, t0.visible AS visible_14, t0.address_id AS address_id_15, t0.pdf_id AS pdf_id_16, t0.picture_id AS picture_id_17 FROM partner t0 WHERE t0.id = ?

Parameters:

[
  97
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date AS date_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.site AS site_4,
  t0.updated AS updated_5,
  t0.center AS center_6,
  t0.close AS close_7,
  t0.created AS created_8,
  t0.description AS description_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.slug AS slug_12,
  t0.title AS title_13,
  t0.visible AS visible_14,
  t0.address_id AS address_id_15,
  t0.pdf_id AS pdf_id_16,
  t0.picture_id AS picture_id_17
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.date AS date_1, t0.email AS email_2, t0.phone AS phone_3, t0.site AS site_4, t0.updated AS updated_5, t0.center AS center_6, t0.close AS close_7, t0.created AS created_8, t0.description AS description_9, t0.id AS id_10, t0.name AS name_11, t0.slug AS slug_12, t0.title AS title_13, t0.visible AS visible_14, t0.address_id AS address_id_15, t0.pdf_id AS pdf_id_16, t0.picture_id AS picture_id_17 FROM partner t0 WHERE t0.id = 97;

#	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\Partner::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Partner->__get (line 153)
7	App\Entity\Abstract\AbstractPartner->getName (line 9)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_5097294756670f6359880208adbc8997::doDisplay (line 87)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_512d323bcdd48ba7e2f447debb566f85->doDisplay (line 78)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_07dc52f4d3fd47df298e3e2533c3a44f->doDisplay (line 65)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 95)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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)

1.65 ms
(0.17%)

SELECT a0_.updated AS updated_0, a0_.created AS created_1, a0_.date AS date_2, a0_.description AS description_3, a0_.id AS id_4, a0_.major AS major_5, a0_.slug AS slug_6, a0_.title AS title_7, a0_.top AS top_8, a0_.visible AS visible_9, a0_.partner_id AS partner_id_10, a0_.picture_id AS picture_id_11 FROM article a0_ WHERE a0_.visible = ? AND a0_.top = ? ORDER BY RAND() ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.updated AS updated_0,
  a0_.created AS created_1,
  a0_.date AS date_2,
  a0_.description AS description_3,
  a0_.id AS id_4,
  a0_.major AS major_5,
  a0_.slug AS slug_6,
  a0_.title AS title_7,
  a0_.top AS top_8,
  a0_.visible AS visible_9,
  a0_.partner_id AS partner_id_10,
  a0_.picture_id AS picture_id_11
FROM
  article a0_
WHERE
  a0_.visible = ?
  AND a0_.top = ?
ORDER BY
  RAND() ASC

SELECT a0_.updated AS updated_0, a0_.created AS created_1, a0_.date AS date_2, a0_.description AS description_3, a0_.id AS id_4, a0_.major AS major_5, a0_.slug AS slug_6, a0_.title AS title_7, a0_.top AS top_8, a0_.visible AS visible_9, a0_.partner_id AS partner_id_10, a0_.picture_id AS picture_id_11 FROM article a0_ WHERE a0_.visible = 1 AND a0_.top = 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\ArticleSiteRepository->findAll (line 29)
7	App\Controller\Site\HomeSiteController->index (line 30)
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)

1.63 ms
(0.17%)

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:

[
  2776
]

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 = 2776 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_a9086cae7b2b7683015be06000130455->block_body (line 102)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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.35 ms
(0.14%)

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:

[
  57
]

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

#	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_a9086cae7b2b7683015be06000130455->block_body (line 127)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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)

1.11 ms
(0.11%)

SELECT j0_.site AS site_0, j0_.updated AS updated_1, j0_.contract AS contract_2, j0_.created AS created_3, j0_.description AS description_4, j0_.id AS id_5, j0_.title AS title_6, j0_.visible AS visible_7, j0_.partner_id AS partner_id_8 FROM job j0_ WHERE j0_.visible = ? ORDER BY RAND() ASC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.site AS site_0,
  j0_.updated AS updated_1,
  j0_.contract AS contract_2,
  j0_.created AS created_3,
  j0_.description AS description_4,
  j0_.id AS id_5,
  j0_.title AS title_6,
  j0_.visible AS visible_7,
  j0_.partner_id AS partner_id_8
FROM
  job j0_
WHERE
  j0_.visible = ?
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT j0_.site AS site_0, j0_.updated AS updated_1, j0_.contract AS contract_2, j0_.created AS created_3, j0_.description AS description_4, j0_.id AS id_5, j0_.title AS title_6, j0_.visible AS visible_7, j0_.partner_id AS partner_id_8 FROM job j0_ WHERE j0_.visible = 1 ORDER BY RAND() ASC LIMIT 10;

#	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\JobSiteRepository->findAll (line 25)
7	App\Controller\Site\HomeSiteController->index (line 36)
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)

0.86 ms
(0.09%)

SELECT r0_.end AS end_0, r0_.start AS start_1, r0_.updated AS updated_2, r0_.created AS created_3, r0_.id AS id_4, r0_.permanent AS permanent_5, r0_.title AS title_6, r0_.visible AS visible_7, r0_.partner_id AS partner_id_8 FROM reduction r0_ WHERE r0_.visible = ? ORDER BY RAND() ASC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.end AS end_0,
  r0_.start AS start_1,
  r0_.updated AS updated_2,
  r0_.created AS created_3,
  r0_.id AS id_4,
  r0_.permanent AS permanent_5,
  r0_.title AS title_6,
  r0_.visible AS visible_7,
  r0_.partner_id AS partner_id_8
FROM
  reduction r0_
WHERE
  r0_.visible = ?
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT r0_.end AS end_0, r0_.start AS start_1, r0_.updated AS updated_2, r0_.created AS created_3, r0_.id AS id_4, r0_.permanent AS permanent_5, r0_.title AS title_6, r0_.visible AS visible_7, r0_.partner_id AS partner_id_8 FROM reduction r0_ WHERE r0_.visible = 1 ORDER BY RAND() ASC LIMIT 10;

#	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\ReductionSiteRepository->findAll (line 24)
7	App\Controller\Site\HomeSiteController->index (line 32)
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)

0.84 ms
(0.09%)

SELECT a0_.updated AS updated_0, a0_.created AS created_1, a0_.date AS date_2, a0_.description AS description_3, a0_.id AS id_4, a0_.major AS major_5, a0_.slug AS slug_6, a0_.title AS title_7, a0_.top AS top_8, a0_.visible AS visible_9, a0_.partner_id AS partner_id_10, a0_.picture_id AS picture_id_11 FROM article a0_ WHERE a0_.visible = ? ORDER BY a0_.date DESC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.updated AS updated_0,
  a0_.created AS created_1,
  a0_.date AS date_2,
  a0_.description AS description_3,
  a0_.id AS id_4,
  a0_.major AS major_5,
  a0_.slug AS slug_6,
  a0_.title AS title_7,
  a0_.top AS top_8,
  a0_.visible AS visible_9,
  a0_.partner_id AS partner_id_10,
  a0_.picture_id AS picture_id_11
FROM
  article a0_
WHERE
  a0_.visible = ?
ORDER BY
  a0_.date DESC
LIMIT
  10

SELECT a0_.updated AS updated_0, a0_.created AS created_1, a0_.date AS date_2, a0_.description AS description_3, a0_.id AS id_4, a0_.major AS major_5, a0_.slug AS slug_6, a0_.title AS title_7, a0_.top AS top_8, a0_.visible AS visible_9, a0_.partner_id AS partner_id_10, a0_.picture_id AS picture_id_11 FROM article a0_ WHERE a0_.visible = 1 ORDER BY a0_.date DESC LIMIT 10;

#	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\ArticleSiteRepository->findAll (line 29)
7	App\Controller\Site\HomeSiteController->index (line 33)
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)

0.73 ms
(0.07%)

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

Parameters:

[
  "216.73.216.142"
  "2026-06-05 20:07:17"
  "site"
  1
  null
  null
  null
  23
  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.142', '2026-06-05 20:07:17', 'site', 1, NULL, NULL, NULL, 23, 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_297600d3b6a517762e6a47ed69da2e26->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_0f79582d16a181ad90f2cfbbb9870e63->doDisplay (line 63)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 133)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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)

0.57 ms
(0.06%)

SELECT e0_.updated AS updated_0, e0_.created AS created_1, e0_.id AS id_2, e0_.price AS price_3, e0_.rental AS rental_4, e0_.site AS site_5, e0_.title AS title_6, e0_.visible AS visible_7, e0_.picture_id AS picture_id_8, e0_.partner_id AS partner_id_9 FROM estate e0_ WHERE e0_.visible = ? ORDER BY RAND() ASC LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.updated AS updated_0,
  e0_.created AS created_1,
  e0_.id AS id_2,
  e0_.price AS price_3,
  e0_.rental AS rental_4,
  e0_.site AS site_5,
  e0_.title AS title_6,
  e0_.visible AS visible_7,
  e0_.picture_id AS picture_id_8,
  e0_.partner_id AS partner_id_9
FROM
  estate e0_
WHERE
  e0_.visible = ?
ORDER BY
  RAND() ASC
LIMIT
  10

SELECT e0_.updated AS updated_0, e0_.created AS created_1, e0_.id AS id_2, e0_.price AS price_3, e0_.rental AS rental_4, e0_.site AS site_5, e0_.title AS title_6, e0_.visible AS visible_7, e0_.picture_id AS picture_id_8, e0_.partner_id AS partner_id_9 FROM estate e0_ WHERE e0_.visible = 1 ORDER BY RAND() ASC LIMIT 10;

#	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\EstateSiteRepository->findAll (line 24)
7	App\Controller\Site\HomeSiteController->index (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)

0.22 ms
(0.02%)

"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_297600d3b6a517762e6a47ed69da2e26->doDisplay (line 48)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_0f79582d16a181ad90f2cfbbb9870e63->doDisplay (line 63)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 133)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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.06 ms
(0.01%)

"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_297600d3b6a517762e6a47ed69da2e26->doDisplay (line 48)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_0f79582d16a181ad90f2cfbbb9870e63->doDisplay (line 63)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_a9086cae7b2b7683015be06000130455->block_body (line 133)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_a9086cae7b2b7683015be06000130455->doDisplay (line 53)
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->index (line 29)
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\Date	99
App\Entity\File	67
App\Entity\Schedule	55
App\Entity\Address	36
App\Entity\Partner	34
App\Entity\View	33
App\Entity\Article	12
App\Entity\Event	12
App\Entity\Reduction	10
App\Entity\Estate	10
App\Entity\Talent	9
App\Entity\User	5
App\Entity\Job	3

Entities Mapping

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\Partner	No errors.
App\Entity\File	No errors.
App\Entity\Like	No errors.
App\Entity\View	No errors.
App\Entity\Event	No errors.
App\Entity\Date	No errors.
App\Entity\Address	No errors.
App\Entity\Category	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.
App\Entity\Reduction	No errors.
App\Entity\Schedule	No errors.
App\Entity\Estate	No errors.
App\Entity\Job	No errors.
App\Entity\Network	No errors.

Symfony Profiler

GET https://dev.wakeupamiens.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping