Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

4.42 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.94 ms
(66.55%)

SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.titre AS titre_3, t0.seo_description AS seo_description_4, t0.hero_image AS hero_image_5, t0.hero_image_alt AS hero_image_alt_6, t0.hotel_link AS hotel_link_7 FROM contact_page t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.seo_title AS seo_title_2,
  t0.titre AS titre_3,
  t0.seo_description AS seo_description_4,
  t0.hero_image AS hero_image_5,
  t0.hero_image_alt AS hero_image_alt_6,
  t0.hotel_link AS hotel_link_7
FROM
  contact_page t0
LIMIT
  1

SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.titre AS titre_3, t0.seo_description AS seo_description_4, t0.hero_image AS hero_image_5, t0.hero_image_alt AS hero_image_alt_6, t0.hotel_link AS hotel_link_7 FROM contact_page t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 30)
4	App\Controller\ContactController->index (line 166)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.48 ms
(33.45%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.home_image AS home_image_3, t0.name AS name_4, t0.description AS description_5, t0.home_image_alt AS home_image_alt_6, t0.color AS color_7, t0.service_first_line AS service_first_line_8, t0.service_second_line AS service_second_line_9, t0.service_third_line AS service_third_line_10, t0.service_fourth_line AS service_fourth_line_11, t0.slug AS slug_12, t0.background_image AS background_image_13, t0.plaquette AS plaquette_14, t0.seminaire_background_image AS seminaire_background_image_15, t0.seminaire_text AS seminaire_text_16, t0.seminaire_plaquette AS seminaire_plaquette_17, t0.logo_dedicated_page AS logo_dedicated_page_18, t0.logo_dedicated_page_alt AS logo_dedicated_page_alt_19, t0.mail AS mail_20, t0.tel AS tel_21, t0.fifth_service AS fifth_service_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.adresse AS adresse_25, t0.ville AS ville_26, t0.code_postal AS code_postal_27, t0.link AS link_28, t0.etoiles AS etoiles_29 FROM hotel t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.home_image AS home_image_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.home_image_alt AS home_image_alt_6,
  t0.color AS color_7,
  t0.service_first_line AS service_first_line_8,
  t0.service_second_line AS service_second_line_9,
  t0.service_third_line AS service_third_line_10,
  t0.service_fourth_line AS service_fourth_line_11,
  t0.slug AS slug_12,
  t0.background_image AS background_image_13,
  t0.plaquette AS plaquette_14,
  t0.seminaire_background_image AS seminaire_background_image_15,
  t0.seminaire_text AS seminaire_text_16,
  t0.seminaire_plaquette AS seminaire_plaquette_17,
  t0.logo_dedicated_page AS logo_dedicated_page_18,
  t0.logo_dedicated_page_alt AS logo_dedicated_page_alt_19,
  t0.mail AS mail_20,
  t0.tel AS tel_21,
  t0.fifth_service AS fifth_service_22,
  t0.seo_title AS seo_title_23,
  t0.seo_description AS seo_description_24,
  t0.adresse AS adresse_25,
  t0.ville AS ville_26,
  t0.code_postal AS code_postal_27,
  t0.link AS link_28,
  t0.etoiles AS etoiles_29
FROM
  hotel t0

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.home_image AS home_image_3, t0.name AS name_4, t0.description AS description_5, t0.home_image_alt AS home_image_alt_6, t0.color AS color_7, t0.service_first_line AS service_first_line_8, t0.service_second_line AS service_second_line_9, t0.service_third_line AS service_third_line_10, t0.service_fourth_line AS service_fourth_line_11, t0.slug AS slug_12, t0.background_image AS background_image_13, t0.plaquette AS plaquette_14, t0.seminaire_background_image AS seminaire_background_image_15, t0.seminaire_text AS seminaire_text_16, t0.seminaire_plaquette AS seminaire_plaquette_17, t0.logo_dedicated_page AS logo_dedicated_page_18, t0.logo_dedicated_page_alt AS logo_dedicated_page_alt_19, t0.mail AS mail_20, t0.tel AS tel_21, t0.fifth_service AS fifth_service_22, t0.seo_title AS seo_title_23, t0.seo_description AS seo_description_24, t0.adresse AS adresse_25, t0.ville AS ville_26, t0.code_postal AS code_postal_27, t0.link AS link_28, t0.etoiles AS etoiles_29 FROM hotel t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 32)
5	App\Controller\ContactController->index (line 166)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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\ContactPage	No errors.
App\Entity\Hotel	No errors.
App\Entity\Service	No errors.
App\Entity\Chambre	No errors.
App\Entity\ServiceEquipement	No errors.
App\Entity\ServicePicto	No errors.
App\Entity\OffreSeminaire	No errors.
App\Entity\Avis	No errors.
App\Entity\ServiceLine	No errors.

Symfony Profiler

GET https://preprod.theoriginals-bourges.fr/contact

Configuration Settings

Theme