Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

5.50 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.76 ms
(31.95%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.hero_image AS hero_image_4, t0.main_title AS main_title_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM produitpage 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.hero_image AS hero_image_4,
  t0.main_title AS main_title_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7
FROM
  produitpage t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.hero_image AS hero_image_4, t0.main_title AS main_title_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7 FROM produitpage 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 43)
4	App\Controller\ProduitController->show (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)

1.60 ms
(29.00%)

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 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "poele-mixte"
]

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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = 'poele-mixte' 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 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.94 ms
(17.05%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.link_url AS link_url_4, t0.link_text AS link_text_5, t0.image AS image_6 FROM produit_marque t0 INNER JOIN produit_produit_marque ON t0.id = produit_produit_marque.produit_marque_id WHERE produit_produit_marque.produit_id = ?

Parameters:

[
  12
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.link_url AS link_url_4,
  t0.link_text AS link_text_5,
  t0.image AS image_6
FROM
  produit_marque t0
  INNER JOIN produit_produit_marque ON t0.id = produit_produit_marque.produit_marque_id
WHERE
  produit_produit_marque.produit_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.link_url AS link_url_4, t0.link_text AS link_text_5, t0.image AS image_6 FROM produit_marque t0 INNER JOIN produit_produit_marque ON t0.id = produit_produit_marque.produit_marque_id WHERE produit_produit_marque.produit_id = 12;

#	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 143)
9	__TwigTemplate_87f063c4abbf45c80a9f8acef706da50->block_body (line 431)
10	Twig\Template->yieldBlock (line 240)
11	__TwigTemplate_cf513f93b794e4de243daecf84871b93->doDisplay (line 387)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_87f063c4abbf45c80a9f8acef706da50->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 47)
22	App\Controller\ProduitController->show (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)

0.64 ms
(11.66%)

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 44)
5	App\Controller\ProduitController->show (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.57 ms
(10.34%)

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 41)
5	App\Controller\ProduitController->show (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)

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\Produit	No errors.
App\Entity\ProduitMarque	No errors.
App\Entity\Setting	No errors.
App\Entity\Produitpage	No errors.

Symfony Profiler

GET https://preprod.cheminees-gourdy-bocca.fr/produits/poele-mixte

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping