Symfony Profiler

Query Metrics

17 Database Queries

2 Different statements

8.68 ms Query time

0 Invalid entities

38 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.11 ms
(81.89%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug_web AS slug_web_3, t0.old_slug_web AS old_slug_web_4, t0.enabled AS enabled_5, t0.holes_number AS holes_number_6, t0.type AS type_7, t0.code AS code_8, t0.token AS token_9, t0.creation_date AS creation_date_10, t0.update_date AS update_date_11, t0.ffg_slug AS ffg_slug_12, t0.slug AS slug_13, t0.golf_name AS golf_name_14, t0.update_needed AS update_needed_15, t0.golf_id AS golf_id_16, t0.owner_id AS owner_id_17 FROM course t0 WHERE t0.golf_id = ?

Parameters:

[
  86
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug_web AS slug_web_3,
  t0.old_slug_web AS old_slug_web_4,
  t0.enabled AS enabled_5,
  t0.holes_number AS holes_number_6,
  t0.type AS type_7,
  t0.code AS code_8,
  t0.token AS token_9,
  t0.creation_date AS creation_date_10,
  t0.update_date AS update_date_11,
  t0.ffg_slug AS ffg_slug_12,
  t0.slug AS slug_13,
  t0.golf_name AS golf_name_14,
  t0.update_needed AS update_needed_15,
  t0.golf_id AS golf_id_16,
  t0.owner_id AS owner_id_17
FROM
  course t0
WHERE
  t0.golf_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug_web AS slug_web_3, t0.old_slug_web AS old_slug_web_4, t0.enabled AS enabled_5, t0.holes_number AS holes_number_6, t0.type AS type_7, t0.code AS code_8, t0.token AS token_9, t0.creation_date AS creation_date_10, t0.update_date AS update_date_11, t0.ffg_slug AS ffg_slug_12, t0.slug AS slug_13, t0.golf_name AS golf_name_14, t0.update_needed AS update_needed_15, t0.golf_id AS golf_id_16, t0.owner_id AS owner_id_17 FROM course t0 WHERE t0.golf_id = 86;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 182)
8	__TwigTemplate_08ab1c7778e29382c30af9c6c1dbe7cb->block_body (line 432)
9	Twig\Template->yieldBlock (line 469)
10	__TwigTemplate_2a0c9dca17b12ff4c1de514117aacf8c->doDisplay (line 388)
11	Twig\Template->yield (line 68)
12	__TwigTemplate_08ab1c7778e29382c30af9c6c1dbe7cb->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 1297)
21	App\Controller\PublicController->coursesDepartmentAction (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)

1.57 ms
(18.11%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.address AS address_5, t0.city AS city_6, t0.departement AS departement_7, t0.country AS country_8, t0.postal_code AS postal_code_9, t0.phone AS phone_10, t0.site AS site_11, t0.longitude AS longitude_12, t0.latitude AS latitude_13, t0.email AS email_14, t0.creation_date AS creation_date_15, t0.update_date AS update_date_16, t0.ffg_slug AS ffg_slug_17, t0.old_ffg_code AS old_ffg_code_18, t0.view AS view_19 FROM golf t0 WHERE t0.departement = ? AND t0.enabled = ?

Parameters:

[
  "83"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.enabled AS enabled_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.departement AS departement_7,
  t0.country AS country_8,
  t0.postal_code AS postal_code_9,
  t0.phone AS phone_10,
  t0.site AS site_11,
  t0.longitude AS longitude_12,
  t0.latitude AS latitude_13,
  t0.email AS email_14,
  t0.creation_date AS creation_date_15,
  t0.update_date AS update_date_16,
  t0.ffg_slug AS ffg_slug_17,
  t0.old_ffg_code AS old_ffg_code_18,
  t0.view AS view_19
FROM
  golf t0
WHERE
  t0.departement = ?
  AND t0.enabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.address AS address_5, t0.city AS city_6, t0.departement AS departement_7, t0.country AS country_8, t0.postal_code AS postal_code_9, t0.phone AS phone_10, t0.site AS site_11, t0.longitude AS longitude_12, t0.latitude AS latitude_13, t0.email AS email_14, t0.creation_date AS creation_date_15, t0.update_date AS update_date_16, t0.ffg_slug AS ffg_slug_17, t0.old_ffg_code AS old_ffg_code_18, t0.view AS view_19 FROM golf t0 WHERE t0.departement = '83' AND t0.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 1295)
4	App\Controller\PublicController->coursesDepartmentAction (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Course\Course	22
App\Entity\Course\Golf	16

Entities Mapping

Class	Mapping errors
App\Entity\Course\Golf	No errors.
App\Entity\Course\Course	No errors.
App\Entity\Player	No errors.
App\Entity\Course\Tee	No errors.

Symfony Profiler

GET https://balles-dev.ovh/parcoursdepartement/83

Configuration Settings

Theme

Page Width