Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

13.66 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.74 ms
(27.37%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.alt AS alt_3
FROM
  chambre_image t0
  INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id
WHERE
  chambre_image_chambre.chambre_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.alt AS alt_3 FROM chambre_image t0 INNER JOIN chambre_image_chambre ON t0.id = chambre_image_chambre.chambre_image_id WHERE chambre_image_chambre.chambre_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 266)
9	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->block_body (line 171)
10	Twig\Template->displayBlock (line 89)
11	__TwigTemplate_1eaae0127767e25d2847d58df665e96a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
22	App\Controller\HotelController->index (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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)

2.43 ms
(17.83%)

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 18)
5	App\Controller\HotelController->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)

1.59 ms
(11.61%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.image_alt AS image_alt_4, t0.text AS text_5, t0.name AS name_6 FROM service_equipement t0 INNER JOIN service_equipement_hotel ON t0.id = service_equipement_hotel.service_equipement_id WHERE service_equipement_hotel.hotel_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.image_alt AS image_alt_4,
  t0.text AS text_5,
  t0.name AS name_6
FROM
  service_equipement t0
  INNER JOIN service_equipement_hotel ON t0.id = service_equipement_hotel.service_equipement_id
WHERE
  service_equipement_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.image_alt AS image_alt_4, t0.text AS text_5, t0.name AS name_6 FROM service_equipement t0 INNER JOIN service_equipement_hotel ON t0.id = service_equipement_hotel.service_equipement_id WHERE service_equipement_hotel.hotel_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 331)
9	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->block_body (line 171)
10	Twig\Template->displayBlock (line 89)
11	__TwigTemplate_1eaae0127767e25d2847d58df665e96a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
22	App\Controller\HotelController->index (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.51 ms
(11.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.have_shower AS have_shower_4, t0.have_tv AS have_tv_5, t0.have_air_dryer AS have_air_dryer_6, t0.url AS url_7, t0.price AS price_8, t0.personne AS personne_9, t0.surface AS surface_10, t0.lit AS lit_11, t0.hotel_id AS hotel_id_12 FROM chambre t0 WHERE t0.hotel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.have_shower AS have_shower_4,
  t0.have_tv AS have_tv_5,
  t0.have_air_dryer AS have_air_dryer_6,
  t0.url AS url_7,
  t0.price AS price_8,
  t0.personne AS personne_9,
  t0.surface AS surface_10,
  t0.lit AS lit_11,
  t0.hotel_id AS hotel_id_12
FROM
  chambre t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.have_shower AS have_shower_4, t0.have_tv AS have_tv_5, t0.have_air_dryer AS have_air_dryer_6, t0.url AS url_7, t0.price AS price_8, t0.personne AS personne_9, t0.surface AS surface_10, t0.lit AS lit_11, t0.hotel_id AS hotel_id_12 FROM chambre t0 WHERE t0.hotel_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3140)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 140)
9	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->block_body (line 171)
10	Twig\Template->displayBlock (line 89)
11	__TwigTemplate_1eaae0127767e25d2847d58df665e96a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
22	App\Controller\HotelController->index (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.46 ms
(10.66%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.image_alt AS image_alt_3 FROM offre_seminaire t0 INNER JOIN offre_seminaire_hotel ON t0.id = offre_seminaire_hotel.offre_seminaire_id WHERE offre_seminaire_hotel.hotel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.image_alt AS image_alt_3
FROM
  offre_seminaire t0
  INNER JOIN offre_seminaire_hotel ON t0.id = offre_seminaire_hotel.offre_seminaire_id
WHERE
  offre_seminaire_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.image_alt AS image_alt_3 FROM offre_seminaire t0 INNER JOIN offre_seminaire_hotel ON t0.id = offre_seminaire_hotel.offre_seminaire_id WHERE offre_seminaire_hotel.hotel_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 458)
8	Doctrine\ORM\PersistentCollection->count (line 435)
9	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->block_body (line 171)
10	Twig\Template->displayBlock (line 89)
11	__TwigTemplate_1eaae0127767e25d2847d58df665e96a->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 50)
14	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 40)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
22	App\Controller\HotelController->index (line 166)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
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.40 ms
(10.25%)

SELECT t0.id AS id_1, t0.svg AS svg_2, t0.title AS title_3, t0.text AS text_4 FROM service_picto t0 INNER JOIN service_picto_hotel ON t0.id = service_picto_hotel.service_picto_id WHERE service_picto_hotel.hotel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.svg AS svg_2,
  t0.title AS title_3,
  t0.text AS text_4
FROM
  service_picto t0
  INNER JOIN service_picto_hotel ON t0.id = service_picto_hotel.service_picto_id
WHERE
  service_picto_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.svg AS svg_2, t0.title AS title_3, t0.text AS text_4 FROM service_picto t0 INNER JOIN service_picto_hotel ON t0.id = service_picto_hotel.service_picto_id WHERE service_picto_hotel.hotel_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3144)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 380)
8	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->block_body (line 171)
9	Twig\Template->displayBlock (line 89)
10	__TwigTemplate_1eaae0127767e25d2847d58df665e96a->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 50)
13	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
21	App\Controller\HotelController->index (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.80 ms
(5.89%)

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

Parameters:

[
  "the-originals-city"
]

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

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 WHERE t0.slug = 'the-originals-city' 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 19)
4	App\Controller\HotelController->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)

0.73 ms
(5.32%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.commentaire AS commentaire_3, t0.provenance AS provenance_4, t0.hotel_id AS hotel_id_5 FROM avis t0 WHERE t0.hotel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.commentaire AS commentaire_3,
  t0.provenance AS provenance_4,
  t0.hotel_id AS hotel_id_5
FROM
  avis t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.commentaire AS commentaire_3, t0.provenance AS provenance_4, t0.hotel_id AS hotel_id_5 FROM avis t0 WHERE t0.hotel_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3140)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 490)
8	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->block_body (line 171)
9	Twig\Template->displayBlock (line 89)
10	__TwigTemplate_1eaae0127767e25d2847d58df665e96a->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 50)
13	__TwigTemplate_b4a352f75aa88a8229792b7c51b6a524->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 40)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
21	App\Controller\HotelController->index (line 166)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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\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.
App\Entity\ChambreImage	No errors.

Symfony Profiler

GET https://preprod.theoriginals-bourges.fr/hotel/the-originals-city

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping