Symfony Profiler

Query Metrics

8 Database Queries

4 Different statements

24.98 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

19.39 ms
(77.62%)

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.nom AS nom_2, t0_.description AS description_3, t0_.image_name AS image_name_4, t0_.image_size AS image_size_5, t0_.type_terrain AS type_terrain_6, t0_.taille AS taille_7, t0_.tarif_heure AS tarif_heure_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.enable AS enable_11, t0_.complexe_id AS complexe_id_12 FROM terrains t0_ WHERE t0_.enable = ? ORDER BY t0_.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.nom AS nom_2,
  t0_.description AS description_3,
  t0_.image_name AS image_name_4,
  t0_.image_size AS image_size_5,
  t0_.type_terrain AS type_terrain_6,
  t0_.taille AS taille_7,
  t0_.tarif_heure AS tarif_heure_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t0_.enable AS enable_11,
  t0_.complexe_id AS complexe_id_12
FROM
  terrains t0_
WHERE
  t0_.enable = ?
ORDER BY
  t0_.created_at DESC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.nom AS nom_2, t0_.description AS description_3, t0_.image_name AS image_name_4, t0_.image_size AS image_size_5, t0_.type_terrain AS type_terrain_6, t0_.taille AS taille_7, t0_.tarif_heure AS tarif_heure_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.enable AS enable_11, t0_.complexe_id AS complexe_id_12 FROM terrains t0_ WHERE t0_.enable = 1 ORDER BY t0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 40)
7	App\Repository\TerrainsRepository->FindAllEnableByDate (line 37)
8	App\Controller\Frontend\TerrainController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 6)

3.43 ms
(13.75%)

SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.terrain_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  AVG(a0_.note) AS sclr_0
FROM
  avis a0_
WHERE
  a0_.terrain_id = ?

SELECT AVG(a0_.note) AS sclr_0 FROM avis a0_ WHERE a0_.terrain_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 52)
8	App\Repository\AvisRepository->findAverage (line 27)
9	App\Twig\TerrainExtension->getAverage (line 92)
10	__TwigTemplate_76e0aad840ccc86d9143ab8469cce9cf->doDisplay (line 393)
11	Twig\Template->yield (line 52)
12	__TwigTemplate_a7bc3aa212ac14c14c2e3fb1249d720f->doDisplay (line 393)
13	Twig\Template->yield (line 185)
14	__TwigTemplate_14a3f10bf315867e24480d44b255831f->block_body (line 437)
15	Twig\Template->yieldBlock (line 88)
16	__TwigTemplate_eb316afbbbbaa98ff4a96554341fff0f->doDisplay (line 393)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_14a3f10bf315867e24480d44b255831f->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 55)
27	App\Controller\Frontend\TerrainController->index (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 6)

1.29 ms
(5.17%)

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.nom AS nom_2, t0_.description AS description_3, t0_.image_name AS image_name_4, t0_.image_size AS image_size_5, t0_.type_terrain AS type_terrain_6, t0_.taille AS taille_7, t0_.tarif_heure AS tarif_heure_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.enable AS enable_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.adresse AS adresse_14, c1_.description AS description_15, c1_.telephone AS telephone_16, c1_.ville AS ville_17, c1_.heure_ouverture AS heure_ouverture_18, c1_.heure_fermeture AS heure_fermeture_19, c1_.created_at AS created_at_20, c1_.updated_at AS updated_at_21, c1_.enable AS enable_22, t0_.complexe_id AS complexe_id_23, c1_.proprietaire_id AS proprietaire_id_24 FROM terrains t0_ INNER JOIN complexes c1_ ON t0_.complexe_id = c1_.id WHERE t0_.enable = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.nom AS nom_2,
  t0_.description AS description_3,
  t0_.image_name AS image_name_4,
  t0_.image_size AS image_size_5,
  t0_.type_terrain AS type_terrain_6,
  t0_.taille AS taille_7,
  t0_.tarif_heure AS tarif_heure_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t0_.enable AS enable_11,
  c1_.id AS id_12,
  c1_.nom AS nom_13,
  c1_.adresse AS adresse_14,
  c1_.description AS description_15,
  c1_.telephone AS telephone_16,
  c1_.ville AS ville_17,
  c1_.heure_ouverture AS heure_ouverture_18,
  c1_.heure_fermeture AS heure_fermeture_19,
  c1_.created_at AS created_at_20,
  c1_.updated_at AS updated_at_21,
  c1_.enable AS enable_22,
  t0_.complexe_id AS complexe_id_23,
  c1_.proprietaire_id AS proprietaire_id_24
FROM
  terrains t0_
  INNER JOIN complexes c1_ ON t0_.complexe_id = c1_.id
WHERE
  t0_.enable = ?

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.nom AS nom_2, t0_.description AS description_3, t0_.image_name AS image_name_4, t0_.image_size AS image_size_5, t0_.type_terrain AS type_terrain_6, t0_.taille AS taille_7, t0_.tarif_heure AS tarif_heure_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.enable AS enable_11, c1_.id AS id_12, c1_.nom AS nom_13, c1_.adresse AS adresse_14, c1_.description AS description_15, c1_.telephone AS telephone_16, c1_.ville AS ville_17, c1_.heure_ouverture AS heure_ouverture_18, c1_.heure_fermeture AS heure_fermeture_19, c1_.created_at AS created_at_20, c1_.updated_at AS updated_at_21, c1_.enable AS enable_22, t0_.complexe_id AS complexe_id_23, c1_.proprietaire_id AS proprietaire_id_24 FROM terrains t0_ INNER JOIN complexes c1_ ON t0_.complexe_id = c1_.id WHERE t0_.enable = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 104)
7	App\Repository\TerrainsRepository->findByFilter (line 52)
8	App\Controller\Frontend\TerrainController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 6)

0.86 ms
(3.46%)

SELECT DISTINCT t0_.type_terrain AS type_terrain_0 FROM terrains t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.type_terrain AS type_terrain_0
FROM
  terrains t0_

SELECT DISTINCT t0_.type_terrain AS type_terrain_0 FROM terrains t0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 68)
7	App\Repository\TerrainsRepository->findTypesTerrains (line 30)
8	App\Form\TerrainFilterType->buildForm (line 99)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 76)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 323)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 49)
15	App\Controller\Frontend\TerrainController->index (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 6)

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\Terrains	No errors.
App\Entity\Complexes	No errors.
App\Entity\Avis	No errors.
App\Entity\Reservations	No errors.
App\Entity\Users	No errors.

Symfony Profiler

GET https://hugo.cciformationlyon.fr/terrains

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping