Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.22 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.72 ms
(59.02%)

SELECT t0.file AS file_1, t0.id AS id_2, t0.title AS title_3, t0.slug AS slug_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.cree_par AS cree_par_7, t0.modifie_par AS modifie_par_8, t0.info_id AS info_id_9 FROM document t0 WHERE t0.info_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.file AS file_1,
  t0.id AS id_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.cree_le AS cree_le_5,
  t0.modifie_le AS modifie_le_6,
  t0.cree_par AS cree_par_7,
  t0.modifie_par AS modifie_par_8,
  t0.info_id AS info_id_9
FROM
  document t0
WHERE
  t0.info_id = ?

SELECT t0.file AS file_1, t0.id AS id_2, t0.title AS title_3, t0.slug AS slug_4, t0.cree_le AS cree_le_5, t0.modifie_le AS modifie_le_6, t0.cree_par AS cree_par_7, t0.modifie_par AS modifie_par_8, t0.info_id AS info_id_9 FROM document t0 WHERE t0.info_id = 13;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 461)
8	Doctrine\ORM\PersistentCollection->count (line 162)
9	__TwigTemplate_580570f43c60162f342f00f9fa96fe98->block_body (line 171)
10	Twig\Template->displayBlock (line 84)
11	__TwigTemplate_ddf640ebaf771506301a84d0ab7b0b49->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 49)
14	__TwigTemplate_580570f43c60162f342f00f9fa96fe98->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 27)
23	App\Controller\Front\CommunicationController->typeCommunicationList (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.50 ms
(40.98%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.poster AS poster_4, t0.enabled AS enabled_5, t0.published AS published_6, t0.content AS content_7, t0.cree_le AS cree_le_8, t0.modifie_le AS modifie_le_9, t0.cree_par AS cree_par_10, t0.modifie_par AS modifie_par_11, t0.type_id AS type_id_12 FROM info t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "fonds-clap-acp-fonsic-2-session-2024"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.poster AS poster_4,
  t0.enabled AS enabled_5,
  t0.published AS published_6,
  t0.content AS content_7,
  t0.cree_le AS cree_le_8,
  t0.modifie_le AS modifie_le_9,
  t0.cree_par AS cree_par_10,
  t0.modifie_par AS modifie_par_11,
  t0.type_id AS type_id_12
FROM
  info t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.poster AS poster_4, t0.enabled AS enabled_5, t0.published AS published_6, t0.content AS content_7, t0.cree_le AS cree_le_8, t0.modifie_le AS modifie_le_9, t0.cree_par AS cree_par_10, t0.modifie_par AS modifie_par_11, t0.type_id AS type_id_12 FROM info t0 WHERE t0.slug = 'fonds-clap-acp-fonsic-2-session-2024' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Entities Mapping

Class	Mapping errors
App\Entity\Info	No errors.
App\Entity\TypeInfo	No errors.
App\Entity\Document	No errors.

Symfony Profiler

GET https://test.fonsic-ci.com/communication/fonds-clap-acp-fonsic-2-session-2024/

Configuration Settings

Theme