Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.90 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.68 ms
(75.39%)

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)

0.22 ms
(24.61%)

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.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Creneaux	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://hugo.cciformationlyon.fr/terrains?max=&min=&query=&ville=

Configuration Settings

Theme