Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.23 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.45 ms

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:

[
  "05"
  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 = '05' 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)

0.48 ms

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:

[
  96
]

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 = 96;

#	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)

0.30 ms

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:

[
  110
]

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 = 110;

#	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)

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	3
App\Entity\Course\Golf	2

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/05

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping