Symfony Profiler

Query Metrics

62 Database Queries

20 Different statements

2461.12 ms Query time

1 Invalid entities

268 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2385.26 ms
(96.92%)

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 p0_.id <> ? AND s6_.day = ? AND s6_.open <= ? AND ? <= s6_.close ORDER BY RAND() ASC LIMIT 10

Parameters:

[
  1
  271
  "Friday"
  "2026-04-17 13:04:49"
  "2026-04-17 13:04:49"
]

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 p0_.id <> ?
  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 p0_.id <> 271 AND s6_.day = 'Friday' AND s6_.open <= '2026-04-17 13:04:49' AND '2026-04-17 13:04:49' <= 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\PartnerSiteController->show (line 45)
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)

56.89 ms
(2.31%)

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 13:04:51"
  "216.73.216.62"
  0
  271
]

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 13:04:51' AND v0_.ip = '216.73.216.62' AND v0_.preview = 0 AND v0_.partner_id = 271;

#	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 12)
8	App\Twig\ViewExtension->new (line 23)
9	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 112)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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)

4.41 ms
(0.18%)

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

Parameters:

[
  1
  "quiz-room-amiens"
]

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

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_.slug = 'quiz-room-amiens';

#	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\PartnerSiteRepository->findOne (line 45)
7	App\Controller\Site\PartnerSiteController->show (line 41)
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.28 ms
(0.09%)

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:

[
  8360
]

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

#	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\Partner->getPicturePath (line 149)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_58fffdab5f5312c061c24004483325a1::block_body (line 202)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\Site\PartnerSiteController->show (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

2.04 ms
(0.08%)

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 13:04:51"
  "site"
  0
  null
  null
  271
  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 13:04:51', 'site', 0, NULL, NULL, 271, 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_58fffdab5f5312c061c24004483325a1->block_body (line 112)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\Site\PartnerSiteController->show (line 43)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.86 ms
(0.08%)

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

Parameters:

[
  "valid"
  1
  271
]

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_.partner_id = ?
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_.partner_id = 271 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\Twig\EventExtension->all (line 17)
8	__TwigTemplate_3d6e3d0f151b325be32503471b067cdf->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 210)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\Site\PartnerSiteController->show (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.79 ms
(0.07%)

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-04-16 13:04:51"
  "216.73.216.62"
  1
  438
]

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-04-16 13:04:51' AND v0_.ip = '216.73.216.62' AND v0_.preview = 1 AND v0_.article_id = 438;

#	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_d27a584590b8cb774c11f9d29e8690c5->doDisplay (line 73)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 234)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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.58 ms
(0.06%)

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:

[
  271
]

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

#	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_58fffdab5f5312c061c24004483325a1::block_body (line 141)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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.74 ms
(0.03%)

"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_58fffdab5f5312c061c24004483325a1->block_body (line 112)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
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\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	App\Controller\Site\PartnerSiteController->show (line 43)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.65 ms
(0.03%)

SELECT t0.ip AS ip_1, t0.created AS created_2, t0.env AS env_3, t0.id AS id_4, t0.preview AS preview_5, t0.article_id AS article_id_6, t0.event_id AS event_id_7, t0.partner_id AS partner_id_8, t0.talent_id AS talent_id_9, t0.user_id AS user_id_10 FROM view t0 WHERE t0.partner_id = ?

Parameters:

[
  271
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.ip AS ip_1,
  t0.created AS created_2,
  t0.env AS env_3,
  t0.id AS id_4,
  t0.preview AS preview_5,
  t0.article_id AS article_id_6,
  t0.event_id AS event_id_7,
  t0.partner_id AS partner_id_8,
  t0.talent_id AS talent_id_9,
  t0.user_id AS user_id_10
FROM
  view t0
WHERE
  t0.partner_id = ?

SELECT t0.ip AS ip_1, t0.created AS created_2, t0.env AS env_3, t0.id AS id_4, t0.preview AS preview_5, t0.article_id AS article_id_6, t0.event_id AS event_id_7, t0.partner_id AS partner_id_8, t0.talent_id AS talent_id_9, t0.user_id AS user_id_10 FROM view t0 WHERE t0.partner_id = 271;

#	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->length (line 1270)
9	__TwigTemplate_cfe61f5a94ac840119e9baf8f1b21b78::doDisplay (line 67)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b33ccf8f5bc1daacd4a69debe82d12b8->doDisplay (line 145)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 204)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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)

0.62 ms
(0.03%)

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_.partner_id = ? ORDER BY a0_.date DESC

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_.partner_id = ?
ORDER BY
  a0_.date DESC

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_.partner_id = 271 ORDER BY a0_.date 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\Site\ArticleSiteRepository->findAll (line 29)
7	App\Twig\ArticleExtension->all (line 14)
8	__TwigTemplate_d27a584590b8cb774c11f9d29e8690c5->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 234)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\Site\PartnerSiteController->show (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.55 ms
(0.02%)

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.id AS id_3, t0.name AS name_4, t0.url AS url_5, t0.partner_id AS partner_id_6, t0.talent_id AS talent_id_7 FROM network t0 WHERE t0.partner_id = ?

Parameters:

[
  271
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.updated AS updated_1,
  t0.created AS created_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.url AS url_5,
  t0.partner_id AS partner_id_6,
  t0.talent_id AS talent_id_7
FROM
  network t0
WHERE
  t0.partner_id = ?

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.id AS id_3, t0.name AS name_4, t0.url AS url_5, t0.partner_id AS partner_id_6, t0.talent_id AS talent_id_7 FROM network t0 WHERE t0.partner_id = 271;

#	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_b33ccf8f5bc1daacd4a69debe82d12b8::doDisplay (line 174)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 204)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\Site\PartnerSiteController->show (line 43)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.50 ms
(0.02%)

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 = ? AND e0_.partner_id = ? ORDER BY e0_.id DESC

Parameters:

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 = ?
  AND e0_.partner_id = ?
ORDER BY
  e0_.id DESC

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 AND e0_.partner_id = 271 ORDER BY e0_.id 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\Site\EstateSiteRepository->findAll (line 24)
7	App\Twig\EstateExtension->all (line 14)
8	__TwigTemplate_6f9e7e6f0d94a36584bd7b16e9f1cccb->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 216)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\Site\PartnerSiteController->show (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.49 ms
(0.02%)

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 = ? AND r0_.partner_id = ?

Parameters:

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 = ?
  AND r0_.partner_id = ?

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 AND r0_.partner_id = 271;

#	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\Twig\ReductionExtension->all (line 14)
8	__TwigTemplate_87c3d90a66dde50307ff1089cbd8ab46->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 222)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\Site\PartnerSiteController->show (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.39 ms
(0.02%)

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 = ? AND j0_.partner_id = ? ORDER BY j0_.id DESC

Parameters:

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 = ?
  AND j0_.partner_id = ?
ORDER BY
  j0_.id DESC

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 AND j0_.partner_id = 271 ORDER BY j0_.id 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\Site\JobSiteRepository->findAll (line 25)
7	App\Twig\JobExtension->all (line 15)
8	__TwigTemplate_c7f8dc1b5c4f6209d710586681814847->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 228)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\Site\PartnerSiteController->show (line 43)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.30 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_58fffdab5f5312c061c24004483325a1->block_body (line 112)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
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\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
18	App\Controller\Site\PartnerSiteController->show (line 43)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

0.23 ms
(0.01%)

SELECT t0.created AS created_1, t0.env AS env_2, t0.id AS id_3, t0.article_id AS article_id_4, t0.event_id AS event_id_5, t0.partner_id AS partner_id_6, t0.publication_id AS publication_id_7, t0.talent_id AS talent_id_8, t0.user_id AS user_id_9 FROM `like` t0 WHERE t0.partner_id = ?

Parameters:

[
  271
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created AS created_1,
  t0.env AS env_2,
  t0.id AS id_3,
  t0.article_id AS article_id_4,
  t0.event_id AS event_id_5,
  t0.partner_id AS partner_id_6,
  t0.publication_id AS publication_id_7,
  t0.talent_id AS talent_id_8,
  t0.user_id AS user_id_9
FROM
  `like` t0
WHERE
  t0.partner_id = ?

SELECT t0.created AS created_1, t0.env AS env_2, t0.id AS id_3, t0.article_id AS article_id_4, t0.event_id AS event_id_5, t0.partner_id AS partner_id_6, t0.publication_id AS publication_id_7, t0.talent_id AS talent_id_8, t0.user_id AS user_id_9 FROM `like` t0 WHERE t0.partner_id = 271;

#	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->length (line 1270)
9	__TwigTemplate_cfe61f5a94ac840119e9baf8f1b21b78::doDisplay (line 129)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_b33ccf8f5bc1daacd4a69debe82d12b8->doDisplay (line 145)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 204)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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)

0.21 ms
(0.01%)

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.entities AS entities_3, t0.id AS id_4, t0.major AS major_5, t0.slug AS slug_6, t0.title AS title_7 FROM category t0 INNER JOIN partner_category ON t0.id = partner_category.category_id WHERE partner_category.partner_id = ?

Parameters:

[
  271
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.updated AS updated_1,
  t0.created AS created_2,
  t0.entities AS entities_3,
  t0.id AS id_4,
  t0.major AS major_5,
  t0.slug AS slug_6,
  t0.title AS title_7
FROM
  category t0
  INNER JOIN partner_category ON t0.id = partner_category.category_id
WHERE
  partner_category.partner_id = ?

SELECT t0.updated AS updated_1, t0.created AS created_2, t0.entities AS entities_3, t0.id AS id_4, t0.major AS major_5, t0.slug AS slug_6, t0.title AS title_7 FROM category t0 INNER JOIN partner_category ON t0.id = partner_category.category_id WHERE partner_category.partner_id = 271;

#	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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Partner->isMajor (line 186)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_58fffdab5f5312c061c24004483325a1::block_body (line 198)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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.17 ms
(0.01%)

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

Parameters:

[
  271
]

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.partner_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.partner_id = 271;

#	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_b33ccf8f5bc1daacd4a69debe82d12b8::doDisplay (line 225)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_58fffdab5f5312c061c24004483325a1->block_body (line 204)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_58fffdab5f5312c061c24004483325a1->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
24	App\Controller\Site\PartnerSiteController->show (line 43)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.17 ms
(0.01%)

SELECT t0.place AS place_1, t0.updated AS updated_2, t0.city AS city_3, t0.created AS created_4, t0.id AS id_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.postal AS postal_8, t0.street AS street_9 FROM address t0 WHERE t0.id = ?

Parameters:

[
  2409
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.place AS place_1,
  t0.updated AS updated_2,
  t0.city AS city_3,
  t0.created AS created_4,
  t0.id AS id_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.postal AS postal_8,
  t0.street AS street_9
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.place AS place_1, t0.updated AS updated_2, t0.city AS city_3, t0.created AS created_4, t0.id AS id_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.postal AS postal_8, t0.street AS street_9 FROM address t0 WHERE t0.id = 2409;

#	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\Address::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Address->__get (line 153)
7	App\Entity\Address->getPlace (line 9)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_58fffdab5f5312c061c24004483325a1::block_body (line 194)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_58fffdab5f5312c061c24004483325a1->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\PartnerSiteController->show (line 43)
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\View	167
App\Entity\Schedule	53
App\Entity\File	21
App\Entity\Partner	10
App\Entity\Address	10
App\Entity\User	2
App\Entity\Network	2
App\Entity\Category	1
App\Entity\Like	1
App\Entity\Article	1

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\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\Publication	No errors.
App\Entity\Date	No errors.

Symfony Profiler

GET https://www.dev.wakeupamiens.fr/partenaires/quiz-room-amiens

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping