Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

47.69 ms Query time

0 Invalid entities

7 Managed entities

Queries

Group similar statements

#▲

Time

Info

7.72 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.slug_web = ? LIMIT 1

Parameters:

[
  "golf-de-ceron-la-frediere-18-trous"
]

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.slug_web = ?
LIMIT
  1

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.slug_web = 'golf-de-ceron-la-frediere-18-trous' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 1305)
4	App\Controller\PublicController->infoCourse (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)

15.07 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.id = ?

Parameters:

[
  84
]

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.id = ?

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.id = 84;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Course\Golf::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Course\Golf->__get (line 253)
8	App\Entity\Course\Golf->getLatitude (line 59)
9	App\Service\AdsService->getAds (line 1333)
10	App\Controller\PublicController->infoCourse (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

16.43 ms

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.published_at AS published_at_2, o0_.type AS type_3, o0_.number AS number_4, o0_.token AS token_5, o0_.state AS state_6, o0_.index_max AS index_max_7, o0_.index_min AS index_min_8, o0_.age_max AS age_max_9, o0_.age_min AS age_min_10, o0_.sexe AS sexe_11, o0_.weekend_am AS weekend_am_12, o0_.weekend_pm AS weekend_pm_13, o0_.week_am AS week_am_14, o0_.week_pm AS week_pm_15, o0_.week_e AS week_e_16, o0_.weekend_e AS weekend_e_17, o0_.ip AS ip_18, o0_.update_at AS update_at_19, o0_.departments AS departments_20, o0_.owner_id AS owner_id_21 FROM offer o0_ INNER JOIN offer_course o2_ ON o0_.id = o2_.offer_id INNER JOIN course c1_ ON c1_.id = o2_.course_id WHERE o0_.state = ? AND EXISTS (SELECT 1 FROM offer_course o3_ WHERE o3_.offer_id = o0_.id AND o3_.course_id IN (?)) ORDER BY o0_.update_at ASC LIMIT 3

Parameters:

[
  "published"
  915
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.created_at AS created_at_1,
  o0_.published_at AS published_at_2,
  o0_.type AS type_3,
  o0_.number AS number_4,
  o0_.token AS token_5,
  o0_.state AS state_6,
  o0_.index_max AS index_max_7,
  o0_.index_min AS index_min_8,
  o0_.age_max AS age_max_9,
  o0_.age_min AS age_min_10,
  o0_.sexe AS sexe_11,
  o0_.weekend_am AS weekend_am_12,
  o0_.weekend_pm AS weekend_pm_13,
  o0_.week_am AS week_am_14,
  o0_.week_pm AS week_pm_15,
  o0_.week_e AS week_e_16,
  o0_.weekend_e AS weekend_e_17,
  o0_.ip AS ip_18,
  o0_.update_at AS update_at_19,
  o0_.departments AS departments_20,
  o0_.owner_id AS owner_id_21
FROM
  offer o0_
  INNER JOIN offer_course o2_ ON o0_.id = o2_.offer_id
  INNER JOIN course c1_ ON c1_.id = o2_.course_id
WHERE
  o0_.state = ?
  AND EXISTS (
    SELECT
      1
    FROM
      offer_course o3_
    WHERE
      o3_.offer_id = o0_.id
      AND o3_.course_id IN (?)
  )
ORDER BY
  o0_.update_at ASC
LIMIT
  3

SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.published_at AS published_at_2, o0_.type AS type_3, o0_.number AS number_4, o0_.token AS token_5, o0_.state AS state_6, o0_.index_max AS index_max_7, o0_.index_min AS index_min_8, o0_.age_max AS age_max_9, o0_.age_min AS age_min_10, o0_.sexe AS sexe_11, o0_.weekend_am AS weekend_am_12, o0_.weekend_pm AS weekend_pm_13, o0_.week_am AS week_am_14, o0_.week_pm AS week_pm_15, o0_.week_e AS week_e_16, o0_.weekend_e AS weekend_e_17, o0_.ip AS ip_18, o0_.update_at AS update_at_19, o0_.departments AS departments_20, o0_.owner_id AS owner_id_21 FROM offer o0_ INNER JOIN offer_course o2_ ON o0_.id = o2_.offer_id INNER JOIN course c1_ ON c1_.id = o2_.course_id WHERE o0_.state = 'published' AND EXISTS (SELECT 1 FROM offer_course o3_ WHERE o3_.offer_id = o0_.id AND o3_.course_id IN (915)) ORDER BY o0_.update_at ASC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 54)
7	App\Repository\Offers\OfferRepository->findByCourse (line 1388)
8	App\Controller\PublicController->infoCourse (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

8.47 ms

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.slope_m AS slope_m_4, t0.slope_w AS slope_w_5, t0.sss_m AS sss_m_6, t0.sss_w AS sss_w_7, t0.slope_mf AS slope_mf_8, t0.slope_wf AS slope_wf_9, t0.sss_mf AS sss_mf_10, t0.sss_wf AS sss_wf_11, t0.slope_mb AS slope_mb_12, t0.slope_wb AS slope_wb_13, t0.sss_mb AS sss_mb_14, t0.sss_wb AS sss_wb_15, t0.holes_number AS holes_number_16, t0.distance AS distance_17, t0.creation_date AS creation_date_18, t0.update_date AS update_date_19, t0.distances AS distances_20, t0.pars AS pars_21, t0.handicap_fbs AS handicap_fbs_22, t0.handicap_fs AS handicap_fs_23, t0.handicap_bs AS handicap_bs_24, t0.distance_by_hole AS distance_by_hole_25, t0.course_id AS course_id_26 FROM tee t0 WHERE t0.course_id = ?

Parameters:

[
  915
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.name AS name_3,
  t0.slope_m AS slope_m_4,
  t0.slope_w AS slope_w_5,
  t0.sss_m AS sss_m_6,
  t0.sss_w AS sss_w_7,
  t0.slope_mf AS slope_mf_8,
  t0.slope_wf AS slope_wf_9,
  t0.sss_mf AS sss_mf_10,
  t0.sss_wf AS sss_wf_11,
  t0.slope_mb AS slope_mb_12,
  t0.slope_wb AS slope_wb_13,
  t0.sss_mb AS sss_mb_14,
  t0.sss_wb AS sss_wb_15,
  t0.holes_number AS holes_number_16,
  t0.distance AS distance_17,
  t0.creation_date AS creation_date_18,
  t0.update_date AS update_date_19,
  t0.distances AS distances_20,
  t0.pars AS pars_21,
  t0.handicap_fbs AS handicap_fbs_22,
  t0.handicap_fs AS handicap_fs_23,
  t0.handicap_bs AS handicap_bs_24,
  t0.distance_by_hole AS distance_by_hole_25,
  t0.course_id AS course_id_26
FROM
  tee t0
WHERE
  t0.course_id = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.slope_m AS slope_m_4, t0.slope_w AS slope_w_5, t0.sss_m AS sss_m_6, t0.sss_w AS sss_w_7, t0.slope_mf AS slope_mf_8, t0.slope_wf AS slope_wf_9, t0.sss_mf AS sss_mf_10, t0.sss_wf AS sss_wf_11, t0.slope_mb AS slope_mb_12, t0.slope_wb AS slope_wb_13, t0.sss_mb AS sss_mb_14, t0.sss_wb AS sss_wb_15, t0.holes_number AS holes_number_16, t0.distance AS distance_17, t0.creation_date AS creation_date_18, t0.update_date AS update_date_19, t0.distances AS distances_20, t0.pars AS pars_21, t0.handicap_fbs AS handicap_fbs_22, t0.handicap_fs AS handicap_fs_23, t0.handicap_bs AS handicap_bs_24, t0.distance_by_hole AS distance_by_hole_25, t0.course_id AS course_id_26 FROM tee t0 WHERE t0.course_id = 915;

#	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 422)
8	__TwigTemplate_e7d609f0e4e64d371810eb15f8c67650->block_body (line 432)
9	Twig\Template->yieldBlock (line 469)
10	__TwigTemplate_2a0c9dca17b12ff4c1de514117aacf8c->doDisplay (line 388)
11	Twig\Template->yield (line 75)
12	__TwigTemplate_e7d609f0e4e64d371810eb15f8c67650->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 1419)
21	App\Controller\PublicController->infoCourse (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\Tee	5
App\Entity\Course\Course	1
App\Entity\Course\Golf	1

Entities Mapping

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

Symfony Profiler

GET https://balles-dev.ovh/calculScoreE1/golf-de-ceron-la-frediere-18-trous

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping