Symfony Profiler

Query Metrics

17 Database Queries

6 Different statements

13.50 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.01 ms
(66.76%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.alt AS alt_4 FROM realisation_images t0 INNER JOIN realisation_realisation_images ON t0.id = realisation_realisation_images.realisation_images_id WHERE realisation_realisation_images.realisation_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.alt AS alt_4
FROM
  realisation_images t0
  INNER JOIN realisation_realisation_images ON t0.id = realisation_realisation_images.realisation_images_id
WHERE
  realisation_realisation_images.realisation_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.alt AS alt_4 FROM realisation_images t0 INNER JOIN realisation_realisation_images ON t0.id = realisation_realisation_images.realisation_images_id WHERE realisation_realisation_images.realisation_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 219)
9	__TwigTemplate_61f5dc411a5931804da12283609fcc8f->block_body (line 431)
10	Twig\Template->yieldBlock (line 240)
11	__TwigTemplate_cf513f93b794e4de243daecf84871b93->doDisplay (line 387)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_61f5dc411a5931804da12283609fcc8f->doDisplay (line 387)
14	Twig\Template->yield (line 343)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 320)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 30)
22	App\Controller\RealisationController->index (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.42 ms
(10.54%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_logo AS site_logo_3, t0.site_url AS site_url_4, t0.site_urlfull AS site_urlfull_5, t0.site_email AS site_email_6, t0.site_address AS site_address_7, t0.site_cp AS site_cp_8, t0.site_city AS site_city_9, t0.site_telephone AS site_telephone_10, t0.site_horaires AS site_horaires_11, t0.site_map AS site_map_12 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_logo AS site_logo_3,
  t0.site_url AS site_url_4,
  t0.site_urlfull AS site_urlfull_5,
  t0.site_email AS site_email_6,
  t0.site_address AS site_address_7,
  t0.site_cp AS site_cp_8,
  t0.site_city AS site_city_9,
  t0.site_telephone AS site_telephone_10,
  t0.site_horaires AS site_horaires_11,
  t0.site_map AS site_map_12
FROM
  setting t0

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_logo AS site_logo_3, t0.site_url AS site_url_4, t0.site_urlfull AS site_urlfull_5, t0.site_email AS site_email_6, t0.site_address AS site_address_7, t0.site_cp AS site_cp_8, t0.site_city AS site_city_9, t0.site_telephone AS site_telephone_10, t0.site_horaires AS site_horaires_11, t0.site_map AS site_map_12 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 24)
5	App\Controller\RealisationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.90 ms
(6.68%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.image_alt AS image_alt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8 FROM produit 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.image AS image_4,
  t0.image_alt AS image_alt_5,
  t0.content AS content_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8
FROM
  produit t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.image_alt AS image_alt_5, t0.content AS content_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8 FROM produit t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 25)
5	App\Controller\RealisationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.77 ms
(5.71%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.hero_image AS hero_image_6, t0.hero_imagealt AS hero_imagealt_7, t0.main_title AS main_title_8, t0.content AS content_9 FROM realisationpage 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.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.hero_image AS hero_image_6,
  t0.hero_imagealt AS hero_imagealt_7,
  t0.main_title AS main_title_8,
  t0.content AS content_9
FROM
  realisationpage t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.hero_image AS hero_image_6, t0.hero_imagealt AS hero_imagealt_7, t0.main_title AS main_title_8, t0.content AS content_9 FROM realisationpage t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 26)
5	App\Controller\RealisationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.74 ms
(5.46%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.image_alt AS image_alt_4 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.image AS image_3,
  t0.image_alt AS image_alt_4
FROM
  realisation t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.image_alt AS image_alt_4 FROM realisation t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 27)
5	App\Controller\RealisationController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.65 ms
(4.85%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.hero_image AS hero_image_6, t0.hero_imagealt AS hero_imagealt_7, t0.main_title AS main_title_8, t0.content AS content_9 FROM realisationpage t0 LIMIT 1

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.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.hero_image AS hero_image_6,
  t0.hero_imagealt AS hero_imagealt_7,
  t0.main_title AS main_title_8,
  t0.content AS content_9
FROM
  realisationpage t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.hero_image AS hero_image_6, t0.hero_imagealt AS hero_imagealt_7, t0.main_title AS main_title_8, t0.content AS content_9 FROM realisationpage t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 29)
4	App\Controller\RealisationController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Setting	No errors.
App\Entity\Produit	No errors.
App\Entity\ProduitMarque	No errors.
App\Entity\Realisationpage	No errors.
App\Entity\Realisation	No errors.
App\Entity\RealisationImages	No errors.

Symfony Profiler

GET https://preprod.cheminees-gourdy-bocca.fr/realisations

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping