Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

3.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.57 ms
(51.50%)

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 22)
5	App\Controller\HomeController->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.67 ms
(21.88%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.hero_text AS hero_text_4, t0.cta_text AS cta_text_5, t0.section1_title AS section1_title_6, t0.section1_text AS section1_text_7, t0.section1_link AS section1_link_8, t0.section1_linktext AS section1_linktext_9, t0.section1_image AS section1_image_10, t0.section3_image AS section3_image_11, t0.section3_text1 AS section3_text1_12, t0.section3_text2 AS section3_text2_13, t0.section3_text3 AS section3_text3_14, t0.section4_image AS section4_image_15, t0.section4_text1 AS section4_text1_16, t0.section4_text2 AS section4_text2_17, t0.section4_text3 AS section4_text3_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.hero_image AS hero_image_21, t0.hero_imagealt AS hero_imagealt_22, t0.section1_imagealt AS section1_imagealt_23, t0.section3_imagealt AS section3_imagealt_24, t0.section3_pictoalt AS section3_pictoalt_25, t0.section4_imagealt AS section4_imagealt_26, t0.section4_pictoalt AS section4_pictoalt_27 FROM homepage 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_text AS hero_text_4,
  t0.cta_text AS cta_text_5,
  t0.section1_title AS section1_title_6,
  t0.section1_text AS section1_text_7,
  t0.section1_link AS section1_link_8,
  t0.section1_linktext AS section1_linktext_9,
  t0.section1_image AS section1_image_10,
  t0.section3_image AS section3_image_11,
  t0.section3_text1 AS section3_text1_12,
  t0.section3_text2 AS section3_text2_13,
  t0.section3_text3 AS section3_text3_14,
  t0.section4_image AS section4_image_15,
  t0.section4_text1 AS section4_text1_16,
  t0.section4_text2 AS section4_text2_17,
  t0.section4_text3 AS section4_text3_18,
  t0.seo_title AS seo_title_19,
  t0.seo_description AS seo_description_20,
  t0.hero_image AS hero_image_21,
  t0.hero_imagealt AS hero_imagealt_22,
  t0.section1_imagealt AS section1_imagealt_23,
  t0.section3_imagealt AS section3_imagealt_24,
  t0.section3_pictoalt AS section3_pictoalt_25,
  t0.section4_imagealt AS section4_imagealt_26,
  t0.section4_pictoalt AS section4_pictoalt_27
FROM
  homepage t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.hero_text AS hero_text_4, t0.cta_text AS cta_text_5, t0.section1_title AS section1_title_6, t0.section1_text AS section1_text_7, t0.section1_link AS section1_link_8, t0.section1_linktext AS section1_linktext_9, t0.section1_image AS section1_image_10, t0.section3_image AS section3_image_11, t0.section3_text1 AS section3_text1_12, t0.section3_text2 AS section3_text2_13, t0.section3_text3 AS section3_text3_14, t0.section4_image AS section4_image_15, t0.section4_text1 AS section4_text1_16, t0.section4_text2 AS section4_text2_17, t0.section4_text3 AS section4_text3_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.hero_image AS hero_image_21, t0.hero_imagealt AS hero_imagealt_22, t0.section1_imagealt AS section1_imagealt_23, t0.section3_imagealt AS section3_imagealt_24, t0.section3_pictoalt AS section3_pictoalt_25, t0.section4_imagealt AS section4_imagealt_26, t0.section4_pictoalt AS section4_pictoalt_27 FROM homepage 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 24)
4	App\Controller\HomeController->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)

0.46 ms
(15.00%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.hero_text AS hero_text_4, t0.cta_text AS cta_text_5, t0.section1_title AS section1_title_6, t0.section1_text AS section1_text_7, t0.section1_link AS section1_link_8, t0.section1_linktext AS section1_linktext_9, t0.section1_image AS section1_image_10, t0.section3_image AS section3_image_11, t0.section3_text1 AS section3_text1_12, t0.section3_text2 AS section3_text2_13, t0.section3_text3 AS section3_text3_14, t0.section4_image AS section4_image_15, t0.section4_text1 AS section4_text1_16, t0.section4_text2 AS section4_text2_17, t0.section4_text3 AS section4_text3_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.hero_image AS hero_image_21, t0.hero_imagealt AS hero_imagealt_22, t0.section1_imagealt AS section1_imagealt_23, t0.section3_imagealt AS section3_imagealt_24, t0.section3_pictoalt AS section3_pictoalt_25, t0.section4_imagealt AS section4_imagealt_26, t0.section4_pictoalt AS section4_pictoalt_27 FROM homepage 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.hero_text AS hero_text_4,
  t0.cta_text AS cta_text_5,
  t0.section1_title AS section1_title_6,
  t0.section1_text AS section1_text_7,
  t0.section1_link AS section1_link_8,
  t0.section1_linktext AS section1_linktext_9,
  t0.section1_image AS section1_image_10,
  t0.section3_image AS section3_image_11,
  t0.section3_text1 AS section3_text1_12,
  t0.section3_text2 AS section3_text2_13,
  t0.section3_text3 AS section3_text3_14,
  t0.section4_image AS section4_image_15,
  t0.section4_text1 AS section4_text1_16,
  t0.section4_text2 AS section4_text2_17,
  t0.section4_text3 AS section4_text3_18,
  t0.seo_title AS seo_title_19,
  t0.seo_description AS seo_description_20,
  t0.hero_image AS hero_image_21,
  t0.hero_imagealt AS hero_imagealt_22,
  t0.section1_imagealt AS section1_imagealt_23,
  t0.section3_imagealt AS section3_imagealt_24,
  t0.section3_pictoalt AS section3_pictoalt_25,
  t0.section4_imagealt AS section4_imagealt_26,
  t0.section4_pictoalt AS section4_pictoalt_27
FROM
  homepage t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.hero_text AS hero_text_4, t0.cta_text AS cta_text_5, t0.section1_title AS section1_title_6, t0.section1_text AS section1_text_7, t0.section1_link AS section1_link_8, t0.section1_linktext AS section1_linktext_9, t0.section1_image AS section1_image_10, t0.section3_image AS section3_image_11, t0.section3_text1 AS section3_text1_12, t0.section3_text2 AS section3_text2_13, t0.section3_text3 AS section3_text3_14, t0.section4_image AS section4_image_15, t0.section4_text1 AS section4_text1_16, t0.section4_text2 AS section4_text2_17, t0.section4_text3 AS section4_text3_18, t0.seo_title AS seo_title_19, t0.seo_description AS seo_description_20, t0.hero_image AS hero_image_21, t0.hero_imagealt AS hero_imagealt_22, t0.section1_imagealt AS section1_imagealt_23, t0.section3_imagealt AS section3_imagealt_24, t0.section3_pictoalt AS section3_pictoalt_25, t0.section4_imagealt AS section4_imagealt_26, t0.section4_pictoalt AS section4_pictoalt_27 FROM homepage 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 23)
5	App\Controller\HomeController->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.36 ms
(11.62%)

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 27)
5	App\Controller\HomeController->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)

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

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping