Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.89 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.00 ms
(25.62%)

SELECT d0_.id AS id_0, d0_.description AS description_1, d0_.created_at AS created_at_2, d0_.user AS user_3, d0_.libelle AS libelle_4, d0_.fk_type_document_id AS fk_type_document_id_5 FROM document d0_ INNER JOIN type_document t1_ ON d0_.fk_type_document_id = t1_.id WHERE t1_.slug = ? ORDER BY d0_.created_at DESC, d0_.id DESC LIMIT 3

Parameters:

[
  "actualites"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.description AS description_1,
  d0_.created_at AS created_at_2,
  d0_.user AS user_3,
  d0_.libelle AS libelle_4,
  d0_.fk_type_document_id AS fk_type_document_id_5
FROM
  document d0_
  INNER JOIN type_document t1_ ON d0_.fk_type_document_id = t1_.id
WHERE
  t1_.slug = ?
ORDER BY
  d0_.created_at DESC,
  d0_.id DESC
LIMIT
  3

SELECT d0_.id AS id_0, d0_.description AS description_1, d0_.created_at AS created_at_2, d0_.user AS user_3, d0_.libelle AS libelle_4, d0_.fk_type_document_id AS fk_type_document_id_5 FROM document d0_ INNER JOIN type_document t1_ ON d0_.fk_type_document_id = t1_.id WHERE t1_.slug = 'actualites' ORDER BY d0_.created_at DESC, d0_.id DESC LIMIT 3;

#	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\DocumentRepository->findLatest (line 52)
7	App\Controller\Frontend\SiteController->detailActualite (line 74)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.86 ms
(22.04%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.updated_at AS updated_at_3, t0.fk_document_id AS fk_document_id_4 FROM fichier t0 WHERE t0.fk_document_id = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.updated_at AS updated_at_3,
  t0.fk_document_id AS fk_document_id_4
FROM
  fichier t0
WHERE
  t0.fk_document_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.updated_at AS updated_at_3, t0.fk_document_id AS fk_document_id_4 FROM fichier t0 WHERE t0.fk_document_id = 30;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_2971c8dd70e1fdbeae54fe1c8bd3789b::block_og_image (line 130)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_3e05434f1c9d2e829cc0331ad604990f->doDisplay (line 92)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_2971c8dd70e1fdbeae54fe1c8bd3789b->doDisplay (line 62)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Frontend\SiteController->detailActualite (line 72)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

0.69 ms
(17.76%)

SELECT d0_.id AS id_0, f1_.id AS id_1, f1_.libelle AS libelle_2, f1_.updated_at AS updated_at_3, d0_.fk_type_document_id AS fk_type_document_id_4, f1_.fk_document_id AS fk_document_id_5 FROM document d0_ LEFT JOIN fichier f1_ ON d0_.id = f1_.fk_document_id WHERE d0_.id IN (?, ?, ?) ORDER BY f1_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  f1_.id AS id_1,
  f1_.libelle AS libelle_2,
  f1_.updated_at AS updated_at_3,
  d0_.fk_type_document_id AS fk_type_document_id_4,
  f1_.fk_document_id AS fk_document_id_5
FROM
  document d0_
  LEFT JOIN fichier f1_ ON d0_.id = f1_.fk_document_id
WHERE
  d0_.id IN (?, ?, ?)
ORDER BY
  f1_.id ASC

SELECT d0_.id AS id_0, f1_.id AS id_1, f1_.libelle AS libelle_2, f1_.updated_at AS updated_at_3, d0_.fk_type_document_id AS fk_type_document_id_4, f1_.fk_document_id AS fk_document_id_5 FROM document d0_ LEFT JOIN fichier f1_ ON d0_.id = f1_.fk_document_id WHERE d0_.id IN (50, 48, 45) ORDER BY f1_.id 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\DocumentRepository->withFichiers (line 123)
7	App\Repository\DocumentRepository->findLatest (line 54)
8	App\Controller\Frontend\SiteController->detailActualite (line 74)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.67 ms
(17.29%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.libelle AS libelle_5, t0.fk_type_document_id AS fk_type_document_id_6 FROM document t0 WHERE t0.id = ?

Parameters:

[
  "30"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.created_at AS created_at_3,
  t0.user AS user_4,
  t0.libelle AS libelle_5,
  t0.fk_type_document_id AS fk_type_document_id_6
FROM
  document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.libelle AS libelle_5, t0.fk_type_document_id AS fk_type_document_id_6 FROM document t0 WHERE t0.id = '30';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 177)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
15	require_once (line 32)
16	require_once (line 5)

0.67 ms
(17.29%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.libelle AS libelle_3 FROM type_document t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.libelle AS libelle_3
FROM
  type_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.libelle AS libelle_3 FROM type_document t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 339)
4	Proxies\__CG__\App\Entity\TypeDocument::Doctrine\ORM\Proxy\{closure} (line 417)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\TypeDocument->__get (line 153)
7	App\Entity\TypeDocument->getSlug (line 75)
8	App\Controller\Frontend\SiteController->detailActualite (line 68)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	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\Document	4
App\Entity\Fichier	4
App\Entity\TypeDocument	1

Entities Mapping

Class	Mapping errors
App\Entity\Document	No errors.
App\Entity\TypeDocument	No errors.
App\Entity\Fichier	No errors.

Symfony Profiler

GET https://menci-igen.net/detail-actualite/30

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping