Symfony Profiler

Query Metrics

12 Database Queries

2 Different statements

1.69 ms Query time

0 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.40 ms
(83.28%)

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:

[
  9691
]

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

#	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\Estate->getPicturePath (line 29)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_1eac67cf1ce4908a4c972277ffa84611::doDisplay (line 74)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_16494b7cde83201b87491e32435d2075->doDisplay (line 83)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8dceaab5d99eff6938c1c64647501ac6->block_body (line 129)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_8dceaab5d99eff6938c1c64647501ac6->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\EstateSiteController->index (line 19)
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
(16.72%)

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 e0_.id DESC

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
  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 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\Controller\Site\EstateSiteController->index (line 21)
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)

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\Estate	11
App\Entity\File	11
App\Entity\Partner	2

Entities Mapping

Class	Mapping errors
App\Entity\Estate	No errors.
App\Entity\File	No errors.
App\Entity\Partner	No errors.
App\Entity\Article	No errors.

Symfony Profiler

GET https://www.dev.wakeupamiens.fr/annonces-immobilieres/

Configuration Settings

Theme

Page Width