Symfony Profiler

Query Metrics

78 Database Queries

9 Different statements

54.44 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.07 ms
(27.67%)

SELECT t0.id AS id_1, t0.voornaam AS voornaam_2, t0.tussenvoegsels AS tussenvoegsels_3, t0.achternaam AS achternaam_4, t0.telefoonnr AS telefoonnr_5, t0.email AS email_6 FROM spelers t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.voornaam AS voornaam_2,
  t0.tussenvoegsels AS tussenvoegsels_3,
  t0.achternaam AS achternaam_4,
  t0.telefoonnr AS telefoonnr_5,
  t0.email AS email_6
FROM
  spelers t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.voornaam AS voornaam_2, t0.tussenvoegsels AS tussenvoegsels_3, t0.achternaam AS achternaam_4, t0.telefoonnr AS telefoonnr_5, t0.email AS email_6 FROM spelers t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
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\Speler::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Speler->__get (line 117)
8	App\Entity\Speler->getNaamVoluit (line 1635)
9	twig_get_attribute (line 88)
10	__TwigTemplate_a810290b7c3320a90ab1f04d168eb0a9->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
19	App\Controller\Public\SeizoenDivisieController->standperdivisie (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 132)
27	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->block_body (line 171)
28	Twig\Template->displayBlock (line 188)
29	__TwigTemplate_4cd459cfe928e1bd5b0559cfc42ee511->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 71)
32	__TwigTemplate_47fd2514f2ceca2d64c1f3726fe70b9f->doDisplay (line 394)
33	Twig\Template->displayWithErrorHandling (line 367)
34	Twig\Template->display (line 49)
35	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
36	Twig\Template->displayWithErrorHandling (line 367)
37	Twig\Template->display (line 53)
38	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
39	Twig\Template->displayWithErrorHandling (line 367)
40	Twig\Template->display (line 379)
41	Twig\Template->render (line 38)
42	Twig\TemplateWrapper->render (line 280)
43	Twig\Environment->render (line 448)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
47	App\Controller\Public\SeizoenDivisieController->standen (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 5)

9.18 ms
(16.86%)

SELECT t0.id AS id_1, t0.team1_games AS team1_games_2, t0.team2_games AS team2_games_3, t0.team1_rating AS team1_rating_4, t0.team2_rating AS team2_rating_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.team1_pos AS team1_pos_8, t0.team2_pos AS team2_pos_9, t0.token AS token_10, t0.seizoendivisie_id AS seizoendivisie_id_11, t0.seizoenronde_id AS seizoenronde_id_12, t0.seizoenteam1_id AS seizoenteam1_id_13, t0.seizoenteam2_id AS seizoenteam2_id_14 FROM seizoenwedstrijden t0 WHERE t0.seizoenteam1_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.team1_games AS team1_games_2,
  t0.team2_games AS team2_games_3,
  t0.team1_rating AS team1_rating_4,
  t0.team2_rating AS team2_rating_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.team1_pos AS team1_pos_8,
  t0.team2_pos AS team2_pos_9,
  t0.token AS token_10,
  t0.seizoendivisie_id AS seizoendivisie_id_11,
  t0.seizoenronde_id AS seizoenronde_id_12,
  t0.seizoenteam1_id AS seizoenteam1_id_13,
  t0.seizoenteam2_id AS seizoenteam2_id_14
FROM
  seizoenwedstrijden t0
WHERE
  t0.seizoenteam1_id = ?

SELECT t0.id AS id_1, t0.team1_games AS team1_games_2, t0.team2_games AS team2_games_3, t0.team1_rating AS team1_rating_4, t0.team2_rating AS team2_rating_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.team1_pos AS team1_pos_8, t0.team2_pos AS team2_pos_9, t0.token AS token_10, t0.seizoendivisie_id AS seizoendivisie_id_11, t0.seizoenronde_id AS seizoenronde_id_12, t0.seizoenteam1_id AS seizoenteam1_id_13, t0.seizoenteam2_id AS seizoenteam2_id_14 FROM seizoenwedstrijden t0 WHERE t0.seizoenteam1_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3224)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 362)
8	App\Entity\SeizoenTeam->getResults (line 1635)
9	twig_get_attribute (line 99)
10	__TwigTemplate_a810290b7c3320a90ab1f04d168eb0a9->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
19	App\Controller\Public\SeizoenDivisieController->standperdivisie (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 132)
27	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->block_body (line 171)
28	Twig\Template->displayBlock (line 188)
29	__TwigTemplate_4cd459cfe928e1bd5b0559cfc42ee511->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 71)
32	__TwigTemplate_47fd2514f2ceca2d64c1f3726fe70b9f->doDisplay (line 394)
33	Twig\Template->displayWithErrorHandling (line 367)
34	Twig\Template->display (line 49)
35	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
36	Twig\Template->displayWithErrorHandling (line 367)
37	Twig\Template->display (line 53)
38	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
39	Twig\Template->displayWithErrorHandling (line 367)
40	Twig\Template->display (line 379)
41	Twig\Template->render (line 38)
42	Twig\TemplateWrapper->render (line 280)
43	Twig\Environment->render (line 448)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
47	App\Controller\Public\SeizoenDivisieController->standen (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 5)

8.82 ms
(16.19%)

SELECT t0.id AS id_1, t0.ind_aanvoerder AS ind_aanvoerder_2, t0.seizoenteam_id AS seizoenteam_id_3, t0.speler_id AS speler_id_4 FROM seizoenteamspelers t0 WHERE t0.seizoenteam_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ind_aanvoerder AS ind_aanvoerder_2,
  t0.seizoenteam_id AS seizoenteam_id_3,
  t0.speler_id AS speler_id_4
FROM
  seizoenteamspelers t0
WHERE
  t0.seizoenteam_id = ?

SELECT t0.id AS id_1, t0.ind_aanvoerder AS ind_aanvoerder_2, t0.seizoenteam_id AS seizoenteam_id_3, t0.speler_id AS speler_id_4 FROM seizoenteamspelers t0 WHERE t0.seizoenteam_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3224)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 85)
8	__TwigTemplate_a810290b7c3320a90ab1f04d168eb0a9->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
17	App\Controller\Public\SeizoenDivisieController->standperdivisie (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
21	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
22	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
23	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
24	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 132)
25	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->block_body (line 171)
26	Twig\Template->displayBlock (line 188)
27	__TwigTemplate_4cd459cfe928e1bd5b0559cfc42ee511->doDisplay (line 394)
28	Twig\Template->displayWithErrorHandling (line 367)
29	Twig\Template->display (line 71)
30	__TwigTemplate_47fd2514f2ceca2d64c1f3726fe70b9f->doDisplay (line 394)
31	Twig\Template->displayWithErrorHandling (line 367)
32	Twig\Template->display (line 49)
33	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
34	Twig\Template->displayWithErrorHandling (line 367)
35	Twig\Template->display (line 53)
36	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
37	Twig\Template->displayWithErrorHandling (line 367)
38	Twig\Template->display (line 379)
39	Twig\Template->render (line 38)
40	Twig\TemplateWrapper->render (line 280)
41	Twig\Environment->render (line 448)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
45	App\Controller\Public\SeizoenDivisieController->standen (line 181)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
50	require_once (line 5)

7.94 ms
(14.59%)

SELECT t0.id AS id_1, t0.team1_games AS team1_games_2, t0.team2_games AS team2_games_3, t0.team1_rating AS team1_rating_4, t0.team2_rating AS team2_rating_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.team1_pos AS team1_pos_8, t0.team2_pos AS team2_pos_9, t0.token AS token_10, t0.seizoendivisie_id AS seizoendivisie_id_11, t0.seizoenronde_id AS seizoenronde_id_12, t0.seizoenteam1_id AS seizoenteam1_id_13, t0.seizoenteam2_id AS seizoenteam2_id_14 FROM seizoenwedstrijden t0 WHERE t0.seizoenteam2_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.team1_games AS team1_games_2,
  t0.team2_games AS team2_games_3,
  t0.team1_rating AS team1_rating_4,
  t0.team2_rating AS team2_rating_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.team1_pos AS team1_pos_8,
  t0.team2_pos AS team2_pos_9,
  t0.token AS token_10,
  t0.seizoendivisie_id AS seizoendivisie_id_11,
  t0.seizoenronde_id AS seizoenronde_id_12,
  t0.seizoenteam1_id AS seizoenteam1_id_13,
  t0.seizoenteam2_id AS seizoenteam2_id_14
FROM
  seizoenwedstrijden t0
WHERE
  t0.seizoenteam2_id = ?

SELECT t0.id AS id_1, t0.team1_games AS team1_games_2, t0.team2_games AS team2_games_3, t0.team1_rating AS team1_rating_4, t0.team2_rating AS team2_rating_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.team1_pos AS team1_pos_8, t0.team2_pos AS team2_pos_9, t0.token AS token_10, t0.seizoendivisie_id AS seizoendivisie_id_11, t0.seizoenronde_id AS seizoenronde_id_12, t0.seizoenteam1_id AS seizoenteam1_id_13, t0.seizoenteam2_id AS seizoenteam2_id_14 FROM seizoenwedstrijden t0 WHERE t0.seizoenteam2_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3224)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 388)
8	App\Entity\SeizoenTeam->getResults (line 1635)
9	twig_get_attribute (line 99)
10	__TwigTemplate_a810290b7c3320a90ab1f04d168eb0a9->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
19	App\Controller\Public\SeizoenDivisieController->standperdivisie (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 132)
27	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->block_body (line 171)
28	Twig\Template->displayBlock (line 188)
29	__TwigTemplate_4cd459cfe928e1bd5b0559cfc42ee511->doDisplay (line 394)
30	Twig\Template->displayWithErrorHandling (line 367)
31	Twig\Template->display (line 71)
32	__TwigTemplate_47fd2514f2ceca2d64c1f3726fe70b9f->doDisplay (line 394)
33	Twig\Template->displayWithErrorHandling (line 367)
34	Twig\Template->display (line 49)
35	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
36	Twig\Template->displayWithErrorHandling (line 367)
37	Twig\Template->display (line 53)
38	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
39	Twig\Template->displayWithErrorHandling (line 367)
40	Twig\Template->display (line 379)
41	Twig\Template->render (line 38)
42	Twig\TemplateWrapper->render (line 280)
43	Twig\Environment->render (line 448)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
47	App\Controller\Public\SeizoenDivisieController->standen (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 5)

3.56 ms
(6.55%)

SELECT s0_.id AS id_0, s0_.whatsapp_group AS whatsapp_group_1, d1_.id AS id_2, d1_.omschrijving AS omschrijving_3, s0_.seizoen_id AS seizoen_id_4, s0_.divisie_id AS divisie_id_5 FROM seizoendivisies s0_ INNER JOIN divisies d1_ ON s0_.divisie_id = d1_.id WHERE s0_.seizoen_id = ? ORDER BY d1_.omschrijving ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.whatsapp_group AS whatsapp_group_1,
  d1_.id AS id_2,
  d1_.omschrijving AS omschrijving_3,
  s0_.seizoen_id AS seizoen_id_4,
  s0_.divisie_id AS divisie_id_5
FROM
  seizoendivisies s0_
  INNER JOIN divisies d1_ ON s0_.divisie_id = d1_.id
WHERE
  s0_.seizoen_id = ?
ORDER BY
  d1_.omschrijving ASC

SELECT s0_.id AS id_0, s0_.whatsapp_group AS whatsapp_group_1, d1_.id AS id_2, d1_.omschrijving AS omschrijving_3, s0_.seizoen_id AS seizoen_id_4, s0_.divisie_id AS divisie_id_5 FROM seizoendivisies s0_ INNER JOIN divisies d1_ ON s0_.divisie_id = d1_.id WHERE s0_.seizoen_id = 1 ORDER BY d1_.omschrijving ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 26)
7	App\Controller\Public\SeizoenDivisieController->standen (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

3.34 ms
(6.14%)

SELECT t0.id AS id_1, t0.nr AS nr_2, t0.startdatum AS startdatum_3, t0.einddatum AS einddatum_4, t0.ind_aktief AS ind_aktief_5, t0.ind_verwerkt AS ind_verwerkt_6, t0.seizoen_id AS seizoen_id_7 FROM seizoenrondes t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nr AS nr_2,
  t0.startdatum AS startdatum_3,
  t0.einddatum AS einddatum_4,
  t0.ind_aktief AS ind_aktief_5,
  t0.ind_verwerkt AS ind_verwerkt_6,
  t0.seizoen_id AS seizoen_id_7
FROM
  seizoenrondes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nr AS nr_2, t0.startdatum AS startdatum_3, t0.einddatum AS einddatum_4, t0.ind_aktief AS ind_aktief_5, t0.ind_verwerkt AS ind_verwerkt_6, t0.seizoen_id AS seizoen_id_7 FROM seizoenrondes t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
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\SeizoenRonde::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\SeizoenRonde->__get (line 55)
8	App\Entity\SeizoenRonde->getNr (line 384)
9	App\Entity\SeizoenTeam->getResults (line 1635)
10	twig_get_attribute (line 99)
11	__TwigTemplate_a810290b7c3320a90ab1f04d168eb0a9->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 52)
20	App\Controller\Public\SeizoenDivisieController->standperdivisie (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
24	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
25	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
26	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
27	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 132)
28	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->block_body (line 171)
29	Twig\Template->displayBlock (line 188)
30	__TwigTemplate_4cd459cfe928e1bd5b0559cfc42ee511->doDisplay (line 394)
31	Twig\Template->displayWithErrorHandling (line 367)
32	Twig\Template->display (line 71)
33	__TwigTemplate_47fd2514f2ceca2d64c1f3726fe70b9f->doDisplay (line 394)
34	Twig\Template->displayWithErrorHandling (line 367)
35	Twig\Template->display (line 49)
36	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
37	Twig\Template->displayWithErrorHandling (line 367)
38	Twig\Template->display (line 53)
39	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
40	Twig\Template->displayWithErrorHandling (line 367)
41	Twig\Template->display (line 379)
42	Twig\Template->render (line 38)
43	Twig\TemplateWrapper->render (line 280)
44	Twig\Environment->render (line 448)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
48	App\Controller\Public\SeizoenDivisieController->standen (line 181)
49	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
50	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
51	Symfony\Component\HttpKernel\Kernel->handle (line 35)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
53	require_once (line 5)

3.34 ms
(6.13%)

SELECT s0_.id AS id_0, s0_.positie AS positie_1, s0_.ind_betaald AS ind_betaald_2, s0_.rating AS rating_3, s0_.inrondenr AS inrondenr_4, s0_.doelsaldo AS doelsaldo_5, s0_.nwrating AS nwrating_6, s0_.rondenr_verwerkt AS rondenr_verwerkt_7, s0_.nwpositie AS nwpositie_8, s0_.seizoen_id AS seizoen_id_9, s0_.seizoendivisie_id AS seizoendivisie_id_10 FROM seizoenteams s0_ WHERE s0_.seizoendivisie_id = ? ORDER BY s0_.positie ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.positie AS positie_1,
  s0_.ind_betaald AS ind_betaald_2,
  s0_.rating AS rating_3,
  s0_.inrondenr AS inrondenr_4,
  s0_.doelsaldo AS doelsaldo_5,
  s0_.nwrating AS nwrating_6,
  s0_.rondenr_verwerkt AS rondenr_verwerkt_7,
  s0_.nwpositie AS nwpositie_8,
  s0_.seizoen_id AS seizoen_id_9,
  s0_.seizoendivisie_id AS seizoendivisie_id_10
FROM
  seizoenteams s0_
WHERE
  s0_.seizoendivisie_id = ?
ORDER BY
  s0_.positie ASC

SELECT s0_.id AS id_0, s0_.positie AS positie_1, s0_.ind_betaald AS ind_betaald_2, s0_.rating AS rating_3, s0_.inrondenr AS inrondenr_4, s0_.doelsaldo AS doelsaldo_5, s0_.nwrating AS nwrating_6, s0_.rondenr_verwerkt AS rondenr_verwerkt_7, s0_.nwpositie AS nwpositie_8, s0_.seizoen_id AS seizoen_id_9, s0_.seizoendivisie_id AS seizoendivisie_id_10 FROM seizoenteams s0_ WHERE s0_.seizoendivisie_id = 1 ORDER BY s0_.positie ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 48)
7	App\Controller\Public\SeizoenDivisieController->standperdivisie (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 132)
15	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->block_body (line 171)
16	Twig\Template->displayBlock (line 188)
17	__TwigTemplate_4cd459cfe928e1bd5b0559cfc42ee511->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 71)
20	__TwigTemplate_47fd2514f2ceca2d64c1f3726fe70b9f->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 49)
23	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 53)
26	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
27	Twig\Template->displayWithErrorHandling (line 367)
28	Twig\Template->display (line 379)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 280)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
35	App\Controller\Public\SeizoenDivisieController->standen (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

2.24 ms
(4.11%)

SELECT s0_.id AS id_0, s0_.omschrijving AS omschrijving_1, s0_.startdatum AS startdatum_2, s0_.einddatum AS einddatum_3, s0_.ind_aktief AS ind_aktief_4, s0_.ind_inonderhoud AS ind_inonderhoud_5 FROM seizoenen s0_ WHERE s0_.ind_aktief = 1 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.omschrijving AS omschrijving_1,
  s0_.startdatum AS startdatum_2,
  s0_.einddatum AS einddatum_3,
  s0_.ind_aktief AS ind_aktief_4,
  s0_.ind_inonderhoud AS ind_inonderhoud_5
FROM
  seizoenen s0_
WHERE
  s0_.ind_aktief = 1
LIMIT
  1

SELECT s0_.id AS id_0, s0_.omschrijving AS omschrijving_1, s0_.startdatum AS startdatum_2, s0_.einddatum AS einddatum_3, s0_.ind_aktief AS ind_aktief_4, s0_.ind_inonderhoud AS ind_inonderhoud_5 FROM seizoenen s0_ WHERE s0_.ind_aktief = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 59)
7	App\Repository\SeizoenRepository->getActiveSeizoen (line 25)
8	App\Controller\Public\SeizoenDivisieController->standen (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.96 ms
(1.76%)

SELECT t0.id AS id_1, t0.sitename AS sitename_2, t0.skin AS skin_3, t0.naam AS naam_4, t0.adres AS adres_5, t0.postcode AS postcode_6, t0.plaats AS plaats_7, t0.telefoon AS telefoon_8, t0.email AS email_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.linkedin AS linkedin_12, t0.youtube AS youtube_13, t0.email_noreply AS email_noreply_14, t0.email_contact AS email_contact_15, t0.email_beheer AS email_beheer_16 FROM settings t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sitename AS sitename_2,
  t0.skin AS skin_3,
  t0.naam AS naam_4,
  t0.adres AS adres_5,
  t0.postcode AS postcode_6,
  t0.plaats AS plaats_7,
  t0.telefoon AS telefoon_8,
  t0.email AS email_9,
  t0.facebook AS facebook_10,
  t0.twitter AS twitter_11,
  t0.linkedin AS linkedin_12,
  t0.youtube AS youtube_13,
  t0.email_noreply AS email_noreply_14,
  t0.email_contact AS email_contact_15,
  t0.email_beheer AS email_beheer_16
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sitename AS sitename_2, t0.skin AS skin_3, t0.naam AS naam_4, t0.adres AS adres_5, t0.postcode AS postcode_6, t0.plaats AS plaats_7, t0.telefoon AS telefoon_8, t0.email AS email_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.linkedin AS linkedin_12, t0.youtube AS youtube_13, t0.email_noreply AS email_noreply_14, t0.email_contact AS email_contact_15, t0.email_beheer AS email_beheer_16 FROM settings t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 32)
6	App\Twig\Extension\SettingsExtension->settings (line 47)
7	__TwigTemplate_8550e48536ef318d5c53e227fdbfa5de->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 53)
10	__TwigTemplate_d91a134e56c7998bf6a4c9dffe918315->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 36)
19	App\Controller\Public\SeizoenDivisieController->standen (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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.

Entities Mapping

Class	Mapping errors
App\Entity\Seizoen	No errors.
App\Entity\SeizoenRonde	No errors.
App\Entity\SeizoenDivisie	No errors.
App\Entity\SeizoenTeam	No errors.
App\Entity\Divisie	No errors.
App\Entity\SeizoenWedstrijd	No errors.
App\Entity\Settings	No errors.
App\Entity\SeizoenTeamSpeler	No errors.
App\Entity\Speler	No errors.

Symfony Profiler

GET http://212.127.234.75:82/_fragment?_path=_format%3Dhtml%26_locale%3Dnl%26_controller%3DApp%255CController%255CPublic%255CSeizoenDivisieController%253A%253Astand…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping