Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.14 ms Query time

0 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.48 ms

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.text_pres_services AS text_pres_services_3, t0.ancre_1 AS ancre_1_4, t0.ancre_2 AS ancre_2_5, t0.ancre_3 AS ancre_3_6, t0.titre_h2_1 AS titre_h2_1_7, t0.text_quotidiens AS text_quotidiens_8, t0.quotidien_charmoy AS quotidien_charmoy_9, t0.quotidien_text_charmoy AS quotidien_text_charmoy_10, t0.quotidien_cheny AS quotidien_cheny_11, t0.quotidien_text_cheny AS quotidien_text_cheny_12, t0.quotidien_laroche_st_cydroine AS quotidien_laroche_st_cydroine_13, t0.quotidien_text_laroche_st_cydroine AS quotidien_text_laroche_st_cydroine_14, t0.quotidien_migennes AS quotidien_migennes_15, t0.quotidien_text_migennes AS quotidien_text_migennes_16, t0.quotidien_inscriptions AS quotidien_inscriptions_17, t0.quotidien_text_inscriptions AS quotidien_text_inscriptions_18, t0.titre_h2_2 AS titre_h2_2_19, t0.mercredis_text AS mercredis_text_20, t0.mercredis_migennes AS mercredis_migennes_21, t0.mercredis_text_migennes AS mercredis_text_migennes_22, t0.mercredis_cheny AS mercredis_cheny_23, t0.mercredis_text_cheny AS mercredis_text_cheny_24, t0.mercredis_inscriptions AS mercredis_inscriptions_25, t0.mercredis_text_inscriptions AS mercredis_text_inscriptions_26, t0.titre_h2_3 AS titre_h2_3_27, t0.vacances_text AS vacances_text_28, t0.vacances_inscription AS vacances_inscription_29, t0.vacances_text_inscription AS vacances_text_inscription_30, t0.img_pres_service_file_name AS img_pres_service_file_name_31, t0.img_vacances1_file_name AS img_vacances1_file_name_32, t0.img_vacances2_file_name AS img_vacances2_file_name_33 FROM services t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.text_pres_services AS text_pres_services_3,
  t0.ancre_1 AS ancre_1_4,
  t0.ancre_2 AS ancre_2_5,
  t0.ancre_3 AS ancre_3_6,
  t0.titre_h2_1 AS titre_h2_1_7,
  t0.text_quotidiens AS text_quotidiens_8,
  t0.quotidien_charmoy AS quotidien_charmoy_9,
  t0.quotidien_text_charmoy AS quotidien_text_charmoy_10,
  t0.quotidien_cheny AS quotidien_cheny_11,
  t0.quotidien_text_cheny AS quotidien_text_cheny_12,
  t0.quotidien_laroche_st_cydroine AS quotidien_laroche_st_cydroine_13,
  t0.quotidien_text_laroche_st_cydroine AS quotidien_text_laroche_st_cydroine_14,
  t0.quotidien_migennes AS quotidien_migennes_15,
  t0.quotidien_text_migennes AS quotidien_text_migennes_16,
  t0.quotidien_inscriptions AS quotidien_inscriptions_17,
  t0.quotidien_text_inscriptions AS quotidien_text_inscriptions_18,
  t0.titre_h2_2 AS titre_h2_2_19,
  t0.mercredis_text AS mercredis_text_20,
  t0.mercredis_migennes AS mercredis_migennes_21,
  t0.mercredis_text_migennes AS mercredis_text_migennes_22,
  t0.mercredis_cheny AS mercredis_cheny_23,
  t0.mercredis_text_cheny AS mercredis_text_cheny_24,
  t0.mercredis_inscriptions AS mercredis_inscriptions_25,
  t0.mercredis_text_inscriptions AS mercredis_text_inscriptions_26,
  t0.titre_h2_3 AS titre_h2_3_27,
  t0.vacances_text AS vacances_text_28,
  t0.vacances_inscription AS vacances_inscription_29,
  t0.vacances_text_inscription AS vacances_text_inscription_30,
  t0.img_pres_service_file_name AS img_pres_service_file_name_31,
  t0.img_vacances1_file_name AS img_vacances1_file_name_32,
  t0.img_vacances2_file_name AS img_vacances2_file_name_33
FROM
  services t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.text_pres_services AS text_pres_services_3, t0.ancre_1 AS ancre_1_4, t0.ancre_2 AS ancre_2_5, t0.ancre_3 AS ancre_3_6, t0.titre_h2_1 AS titre_h2_1_7, t0.text_quotidiens AS text_quotidiens_8, t0.quotidien_charmoy AS quotidien_charmoy_9, t0.quotidien_text_charmoy AS quotidien_text_charmoy_10, t0.quotidien_cheny AS quotidien_cheny_11, t0.quotidien_text_cheny AS quotidien_text_cheny_12, t0.quotidien_laroche_st_cydroine AS quotidien_laroche_st_cydroine_13, t0.quotidien_text_laroche_st_cydroine AS quotidien_text_laroche_st_cydroine_14, t0.quotidien_migennes AS quotidien_migennes_15, t0.quotidien_text_migennes AS quotidien_text_migennes_16, t0.quotidien_inscriptions AS quotidien_inscriptions_17, t0.quotidien_text_inscriptions AS quotidien_text_inscriptions_18, t0.titre_h2_2 AS titre_h2_2_19, t0.mercredis_text AS mercredis_text_20, t0.mercredis_migennes AS mercredis_migennes_21, t0.mercredis_text_migennes AS mercredis_text_migennes_22, t0.mercredis_cheny AS mercredis_cheny_23, t0.mercredis_text_cheny AS mercredis_text_cheny_24, t0.mercredis_inscriptions AS mercredis_inscriptions_25, t0.mercredis_text_inscriptions AS mercredis_text_inscriptions_26, t0.titre_h2_3 AS titre_h2_3_27, t0.vacances_text AS vacances_text_28, t0.vacances_inscription AS vacances_inscription_29, t0.vacances_text_inscription AS vacances_text_inscription_30, t0.img_pres_service_file_name AS img_pres_service_file_name_31, t0.img_vacances1_file_name AS img_vacances1_file_name_32, t0.img_vacances2_file_name AS img_vacances2_file_name_33 FROM services t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 56)
7	App\Controller\HomeController->services (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.66 ms

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.num_carrousel AS num_carrousel_3, t0.page_carrousel_id AS page_carrousel_id_4 FROM carrousel t0 WHERE t0.page_carrousel_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.num_carrousel AS num_carrousel_3,
  t0.page_carrousel_id AS page_carrousel_id_4
FROM
  carrousel t0
WHERE
  t0.page_carrousel_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.num_carrousel AS num_carrousel_3, t0.page_carrousel_id AS page_carrousel_id_4 FROM carrousel t0 WHERE t0.page_carrousel_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 189)
8	__TwigTemplate_d80138a0eeaa4046d1a0449a90288999->block_body (line 432)
9	Twig\Template->yieldBlock (line 87)
10	__TwigTemplate_e6fca0f8d99b995c0bf1c946d5f7ca61->doDisplay (line 388)
11	Twig\Template->yield (line 54)
12	__TwigTemplate_d80138a0eeaa4046d1a0449a90288999->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
21	App\Controller\HomeController->services (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Carrousel	7
App\Entity\Services	1

Entities Mapping

Class	Mapping errors
App\Entity\Services	No errors.
App\Entity\Carrousel	No errors.

Symfony Profiler

GET https://www.aclm-migennois.fr/services

Configuration Settings

Theme

Page Width