Symfony Profiler

Query Metrics

57 Database Queries

3 Different statements

28.29 ms Query time

0 Invalid entities

77 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.90 ms
(45.61%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.owner_name AS owner_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.show_description AS show_description_6, t0.show_owner_name AS show_owner_name_7, t0.show_phone AS show_phone_8, t0.show_email AS show_email_9, t0.show_address AS show_address_10, t0.show_images_personnes AS show_images_personnes_11, t0.realisation_id AS realisation_id_12, t0.owner_id AS owner_id_13 FROM realisation_ownership t0 WHERE t0.realisation_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.owner_name AS owner_name_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.show_description AS show_description_6,
  t0.show_owner_name AS show_owner_name_7,
  t0.show_phone AS show_phone_8,
  t0.show_email AS show_email_9,
  t0.show_address AS show_address_10,
  t0.show_images_personnes AS show_images_personnes_11,
  t0.realisation_id AS realisation_id_12,
  t0.owner_id AS owner_id_13
FROM
  realisation_ownership t0
WHERE
  t0.realisation_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.owner_name AS owner_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.show_description AS show_description_6, t0.show_owner_name AS show_owner_name_7, t0.show_phone AS show_phone_8, t0.show_email AS show_email_9, t0.show_address AS show_address_10, t0.show_images_personnes AS show_images_personnes_11, t0.realisation_id AS realisation_id_12, t0.owner_id AS owner_id_13 FROM realisation_ownership t0 WHERE t0.realisation_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->isEmpty (line 446)
9	App\Entity\Realisation->shouldShowAddress (line 289)
10	Twig\Extension\CoreExtension->getAttribute (line 1919)
11	__TwigTemplate_5df30843790a9e606dbc5fa771ca7203::block_body (line 182)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_406552a0d3abc646266bad6957dae6a9->block_frame_content (line 217)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_406552a0d3abc646266bad6957dae6a9->doDisplay (line 86)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_5df30843790a9e606dbc5fa771ca7203->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	App\Controller\RealisationController->index (line 19)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

12.12 ms
(42.85%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.category AS category_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.realisation_id AS realisation_id_7, t0.ownership_id AS ownership_id_8 FROM realisation_image t0 WHERE t0.realisation_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.category AS category_4,
  t0.position AS position_5,
  t0.created_at AS created_at_6,
  t0.realisation_id AS realisation_id_7,
  t0.ownership_id AS ownership_id_8
FROM
  realisation_image t0
WHERE
  t0.realisation_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.category AS category_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.realisation_id AS realisation_id_7, t0.ownership_id AS ownership_id_8 FROM realisation_image t0 WHERE t0.realisation_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Realisation->getImagesByCategory (line 232)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_5df30843790a9e606dbc5fa771ca7203::block_body (line 145)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_406552a0d3abc646266bad6957dae6a9->block_frame_content (line 217)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_406552a0d3abc646266bad6957dae6a9->doDisplay (line 86)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_5df30843790a9e606dbc5fa771ca7203->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 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\RealisationController->index (line 19)
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)

3.26 ms
(11.54%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.address AS address_4, t0.show_images AS show_images_5, t0.show_images_travaux AS show_images_travaux_6, t0.show_images_exterieures AS show_images_exterieures_7, t0.show_images_interieures AS show_images_interieures_8, t0.show_maquettes AS show_maquettes_9, t0.show_plans AS show_plans_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM realisation t0

Parameters:

[]

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.address AS address_4,
  t0.show_images AS show_images_5,
  t0.show_images_travaux AS show_images_travaux_6,
  t0.show_images_exterieures AS show_images_exterieures_7,
  t0.show_images_interieures AS show_images_interieures_8,
  t0.show_maquettes AS show_maquettes_9,
  t0.show_plans AS show_plans_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  realisation t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.address AS address_4, t0.show_images AS show_images_5, t0.show_images_travaux AS show_images_travaux_6, t0.show_images_exterieures AS show_images_exterieures_7, t0.show_images_interieures AS show_images_interieures_8, t0.show_maquettes AS show_maquettes_9, t0.show_plans AS show_plans_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM realisation t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\RealisationController->index (line 17)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\Realisation	28
App\Entity\RealisationOwnership	25
App\Entity\User	24

Entities Mapping

Class	Mapping errors
App\Entity\Realisation	No errors.
App\Entity\RealisationImage	No errors.
App\Entity\RealisationOwnership	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://ecovoide-new.mountaincode.fr/renato-ligabue/realisations

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping