Symfony Profiler

Query Metrics

7 Database Queries

3 Different statements

9.75 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.86 ms
(49.82%)

SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = ?

Parameters:

[
  35
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.photo_liens AS photo_liens_2,
  t3.id AS id_4,
  t3.advert_name AS advert_name_5,
  t3.advert_location AS advert_location_6,
  t3.advert_pieces AS advert_pieces_7,
  t3.advert_sale AS advert_sale_8,
  t3.advert_description AS advert_description_9,
  t3.advert_date AS advert_date_10,
  t3.advert_living_space AS advert_living_space_11,
  t3.advert_total_surface AS advert_total_surface_12,
  t3.advert_rent_alone AS advert_rent_alone_13,
  t3.advert_rent_charges AS advert_rent_charges_14,
  t3.advert_type_id AS advert_type_id_15,
  t3.advert_photo_id AS advert_photo_id_16,
  t3.advert_user_id AS advert_user_id_17
FROM
  photo t0
  LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.photo_liens AS photo_liens_2, t3.id AS id_4, t3.advert_name AS advert_name_5, t3.advert_location AS advert_location_6, t3.advert_pieces AS advert_pieces_7, t3.advert_sale AS advert_sale_8, t3.advert_description AS advert_description_9, t3.advert_date AS advert_date_10, t3.advert_living_space AS advert_living_space_11, t3.advert_total_surface AS advert_total_surface_12, t3.advert_rent_alone AS advert_rent_alone_13, t3.advert_rent_charges AS advert_rent_charges_14, t3.advert_type_id AS advert_type_id_15, t3.advert_photo_id AS advert_photo_id_16, t3.advert_user_id AS advert_user_id_17 FROM photo t0 LEFT JOIN advert t3 ON t3.advert_photo_id = t0.id WHERE t0.id = 35;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Photo::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Photo->__get (line 39)
8	App\Entity\Photo->getPhotoLiens (line 1635)
9	twig_get_attribute (line 208)
10	__TwigTemplate_01ceca63aea7b8028719e5d19d738965->block_body (line 171)
11	Twig\Template->displayBlock (line 119)
12	__TwigTemplate_057c88c0355774bb21dc16a485c61ac2->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 62)
15	__TwigTemplate_01ceca63aea7b8028719e5d19d738965->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
24	App\Controller\AdvertController->index (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

3.04 ms
(31.13%)

SELECT a0_.id AS id_0, a0_.advert_name AS advert_name_1, a0_.advert_location AS advert_location_2, a0_.advert_pieces AS advert_pieces_3, a0_.advert_sale AS advert_sale_4, a0_.advert_description AS advert_description_5, a0_.advert_date AS advert_date_6, a0_.advert_living_space AS advert_living_space_7, a0_.advert_total_surface AS advert_total_surface_8, a0_.advert_rent_alone AS advert_rent_alone_9, a0_.advert_rent_charges AS advert_rent_charges_10, a0_.advert_type_id AS advert_type_id_11, a0_.advert_photo_id AS advert_photo_id_12, a0_.advert_user_id AS advert_user_id_13 FROM advert a0_ ORDER BY a0_.advert_date DESC, a0_.advert_sale ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.advert_name AS advert_name_1,
  a0_.advert_location AS advert_location_2,
  a0_.advert_pieces AS advert_pieces_3,
  a0_.advert_sale AS advert_sale_4,
  a0_.advert_description AS advert_description_5,
  a0_.advert_date AS advert_date_6,
  a0_.advert_living_space AS advert_living_space_7,
  a0_.advert_total_surface AS advert_total_surface_8,
  a0_.advert_rent_alone AS advert_rent_alone_9,
  a0_.advert_rent_charges AS advert_rent_charges_10,
  a0_.advert_type_id AS advert_type_id_11,
  a0_.advert_photo_id AS advert_photo_id_12,
  a0_.advert_user_id AS advert_user_id_13
FROM
  advert a0_
ORDER BY
  a0_.advert_date DESC,
  a0_.advert_sale ASC

SELECT a0_.id AS id_0, a0_.advert_name AS advert_name_1, a0_.advert_location AS advert_location_2, a0_.advert_pieces AS advert_pieces_3, a0_.advert_sale AS advert_sale_4, a0_.advert_description AS advert_description_5, a0_.advert_date AS advert_date_6, a0_.advert_living_space AS advert_living_space_7, a0_.advert_total_surface AS advert_total_surface_8, a0_.advert_rent_alone AS advert_rent_alone_9, a0_.advert_rent_charges AS advert_rent_charges_10, a0_.advert_type_id AS advert_type_id_11, a0_.advert_photo_id AS advert_photo_id_12, a0_.advert_user_id AS advert_user_id_13 FROM advert a0_ ORDER BY a0_.advert_date DESC, a0_.advert_sale ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 158)
7	App\Repository\AdvertRepository->findAdvertWithFilters (line 43)
8	App\Controller\AdvertController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.86 ms
(19.04%)

SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type_name AS type_name_2
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM type t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Type::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Type->__get (line 44)
8	App\Entity\Type->getTypeName (line 1635)
9	twig_get_attribute (line 237)
10	__TwigTemplate_01ceca63aea7b8028719e5d19d738965->block_body (line 171)
11	Twig\Template->displayBlock (line 119)
12	__TwigTemplate_057c88c0355774bb21dc16a485c61ac2->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 62)
15	__TwigTemplate_01ceca63aea7b8028719e5d19d738965->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
24	App\Controller\AdvertController->index (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\Advert	No errors.
App\Entity\Type	No errors.
App\Entity\Photo	No errors.
App\Entity\User	No errors.
App\Entity\Favorite	No errors.
App\Entity\FileSend	No errors.
App\Entity\Excluded	No errors.

Symfony Profiler

GET https://lipsom.lizii.fr/advert/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping