Symfony Profiler

Query Metrics

17 Database Queries

6 Different statements

87.15 ms Query time

1 Invalid entities

94 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

83.43 ms
(95.73%)

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 = ? GROUP BY t0_.id ORDER BY COUNT(l4_.id) DESC, COUNT(v3_.id) DESC

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 = ?
GROUP BY
  t0_.id
ORDER BY
  COUNT(l4_.id) DESC,
  COUNT(v3_.id) DESC

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 GROUP BY t0_.id ORDER BY COUNT(l4_.id) DESC, COUNT(v3_.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\TalentSiteRepository->findAll (line 28)
7	App\Controller\Site\TalentSiteController->index (line 27)
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.64 ms
(1.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_.talent_id = ?

Parameters:

[
  "2026-04-20 09:15:12"
  "216.73.217.11"
  1
  45
]

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-04-20 09:15:12' AND v0_.ip = '216.73.217.11' AND v0_.preview = 1 AND v0_.talent_id = 45;

#	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_8bb13de26ed24bb21cda6ab25abe2c3b->doDisplay (line 48)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_ecc14ea2279efe2f6f3fc242f18dab84->block_body (line 135)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_ecc14ea2279efe2f6f3fc242f18dab84->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\TalentSiteController->index (line 25)
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)

1.00 ms
(1.14%)

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

Parameters:

[
  "216.73.217.11"
  "2026-04-21 09:15:12"
  "site"
  1
  null
  null
  null
  45
  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.217.11', '2026-04-21 09:15:12', 'site', 1, NULL, NULL, NULL, 45, 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_8bb13de26ed24bb21cda6ab25abe2c3b->doDisplay (line 48)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_ecc14ea2279efe2f6f3fc242f18dab84->block_body (line 135)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_ecc14ea2279efe2f6f3fc242f18dab84->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\TalentSiteController->index (line 25)
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.69 ms
(0.79%)

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:

[
  9490
]

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

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

0.28 ms
(0.32%)

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

0.12 ms
(0.13%)

"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_8bb13de26ed24bb21cda6ab25abe2c3b->doDisplay (line 48)
6	Twig\Template->yield (line 402)
7	__TwigTemplate_ecc14ea2279efe2f6f3fc242f18dab84->block_body (line 135)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_ecc14ea2279efe2f6f3fc242f18dab84->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
20	App\Controller\Site\TalentSiteController->index (line 25)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\Talent	45
App\Entity\File	44
App\Entity\View	5

Entities Mapping

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

Symfony Profiler

GET https://www.dev.wakeupamiens.fr/talents/?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping