Symfony Profiler

Query Metrics

63 Database Queries

18 Different statements

37.21 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.57 ms
(44.54%)

SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) WHERE t0_.name = ? AND t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC LIMIT 1

Parameters:

[
  "Allsvenskan"
  "SWE"
  "2022"
  "2015"
  "2016"
  "2017"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.uuid AS uuid_1,
  t0_.name AS name_2,
  t0_.start_date AS start_date_3,
  t0_.end_date AS end_date_4,
  t0_.competition_id AS competition_id_5
FROM
  tournament t0_
  INNER JOIN competition c1_ ON t0_.competition_id = c1_.id
  AND (
    c1_.name = ?
    AND c1_.area = ?
  )
WHERE
  t0_.name = ?
  AND t0_.name NOT IN (?, ?, ?)
ORDER BY
  t0_.start_date DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = 'Allsvenskan' AND c1_.area = 'SWE') WHERE t0_.name = '2022' AND t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC 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 63)
7	Allsvenskan\Data\Repository\TournamentRepository->findActiveTournament (line 842)
8	Allsvenskan\Data\Service\WyscoutDataManager->getTournamentsData (line 35)
9	App\Controller\PageController->talangdata (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

12.55 ms
(33.73%)

SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = ? AND c1_.area = ?) INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN (?, ?, ?) ORDER BY t0_.start_date DESC

Parameters:

[
  "Allsvenskan"
  "SWE"
  "2015"
  "2016"
  "2017"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.uuid AS uuid_1,
  t0_.name AS name_2,
  t0_.start_date AS start_date_3,
  t0_.end_date AS end_date_4,
  t0_.competition_id AS competition_id_5
FROM
  tournament t0_
  INNER JOIN competition c1_ ON t0_.competition_id = c1_.id
  AND (
    c1_.name = ?
    AND c1_.area = ?
  )
  INNER JOIN team t2_ ON t0_.id = t2_.tournament_id
WHERE
  t0_.name NOT IN (?, ?, ?)
ORDER BY
  t0_.start_date DESC

SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.name AS name_2, t0_.start_date AS start_date_3, t0_.end_date AS end_date_4, t0_.competition_id AS competition_id_5 FROM tournament t0_ INNER JOIN competition c1_ ON t0_.competition_id = c1_.id AND (c1_.name = 'Allsvenskan' AND c1_.area = 'SWE') INNER JOIN team t2_ ON t0_.id = t2_.tournament_id WHERE t0_.name NOT IN ('2015', '2016', '2017') ORDER BY t0_.start_date DESC;

#	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 102)
7	Allsvenskan\Data\Repository\TournamentRepository->findTournamentsAll (line 840)
8	Allsvenskan\Data\Service\WyscoutDataManager->getTournamentsData (line 35)
9	App\Controller\PageController->talangdata (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.65 ms
(1.75%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1801 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.minutes_played AS minutes_played_6,
  v0_.min_minutes_played AS min_minutes_played_7,
  v0_.matches_played AS matches_played_8,
  v0_.tournament_id AS tournament_id_9
FROM
  view_tpsu1801 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.minutes_played DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1801 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;

#	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 36)
7	Allsvenskan\Data\Repository\ViewTPSU1801Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 110)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.61 ms
(1.64%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.matches_played AS matches_played_6,
  v0_.minutes_played AS minutes_played_7,
  v0_.min_minutes_played AS min_minutes_played_8,
  v0_.expected_goals AS expected_goals_9,
  v0_.expected_assists AS expected_assists_10,
  v0_.expected_points AS expected_points_11,
  v0_.expected_points90 AS expected_points90_12,
  v0_.tournament_id AS tournament_id_13
FROM
  view_tpxgxaxpu2101 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.expected_points90 DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.expected_goals DESC,
  v0_.expected_assists DESC,
  v0_.expected_points DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.expected_goals AS expected_goals_9, v0_.expected_assists AS expected_assists_10, v0_.expected_points AS expected_points_11, v0_.expected_points90 AS expected_points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpxgxaxpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 3 ORDER BY v0_.expected_points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.expected_assists DESC, v0_.expected_points DESC, v0_.player ASC LIMIT 20;

#	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 41)
7	Allsvenskan\Data\Repository\ViewTPXGXAXPU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 118)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.58 ms
(1.56%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.smart_passes AS smart_passes_9, v0_.progressive_passes AS progressive_passes_10, v0_.smart_progressive_passes90 AS smart_progressive_passes90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpsppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.smart_progressive_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.matches_played AS matches_played_6,
  v0_.minutes_played AS minutes_played_7,
  v0_.min_minutes_played AS min_minutes_played_8,
  v0_.smart_passes AS smart_passes_9,
  v0_.progressive_passes AS progressive_passes_10,
  v0_.smart_progressive_passes90 AS smart_progressive_passes90_11,
  v0_.tournament_id AS tournament_id_12
FROM
  view_tpsppu2101 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.smart_progressive_passes90 DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.smart_passes DESC,
  v0_.progressive_passes DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.matches_played AS matches_played_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.smart_passes AS smart_passes_9, v0_.progressive_passes AS progressive_passes_10, v0_.smart_progressive_passes90 AS smart_progressive_passes90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpsppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 3 ORDER BY v0_.smart_progressive_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.smart_passes DESC, v0_.progressive_passes DESC, v0_.player ASC LIMIT 20;

#	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 40)
7	Allsvenskan\Data\Repository\ViewTPSPPU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 130)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.58 ms
(1.56%)

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.avg_age_match_squad AS avg_age_match_squad_4, v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5, v0_.avg_age_bench AS avg_age_bench_6, v0_.avg_age_substituted_in AS avg_age_substituted_in_7, v0_.tournament_id AS tournament_id_8 FROM view_ttga01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.avg_age_substituted_in DESC, v0_.matches_played DESC, v0_.avg_age_match_squad DESC, v0_.avg_age_starting_eleven DESC, v0_.avg_age_bench DESC, v0_.team ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.team AS team_1,
  v0_.team_logo AS team_logo_2,
  v0_.matches_played AS matches_played_3,
  v0_.avg_age_match_squad AS avg_age_match_squad_4,
  v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5,
  v0_.avg_age_bench AS avg_age_bench_6,
  v0_.avg_age_substituted_in AS avg_age_substituted_in_7,
  v0_.tournament_id AS tournament_id_8
FROM
  view_ttga01 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.avg_age_substituted_in DESC,
  v0_.matches_played DESC,
  v0_.avg_age_match_squad DESC,
  v0_.avg_age_starting_eleven DESC,
  v0_.avg_age_bench DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.matches_played AS matches_played_3, v0_.avg_age_match_squad AS avg_age_match_squad_4, v0_.avg_age_starting_eleven AS avg_age_starting_eleven_5, v0_.avg_age_bench AS avg_age_bench_6, v0_.avg_age_substituted_in AS avg_age_substituted_in_7, v0_.tournament_id AS tournament_id_8 FROM view_ttga01 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.avg_age_substituted_in DESC, v0_.matches_played DESC, v0_.avg_age_match_squad DESC, v0_.avg_age_starting_eleven DESC, v0_.avg_age_bench DESC, v0_.team 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 37)
7	Allsvenskan\Data\Repository\ViewTTGA01Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 93)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.57 ms
(1.52%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.passes AS passes_6, v0_.successfull_passes AS successfull_passes_7, v0_.pass_percentage AS pass_percentage_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tppppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = ? ORDER BY v0_.pass_percentage DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.passes AS passes_6,
  v0_.successfull_passes AS successfull_passes_7,
  v0_.pass_percentage AS pass_percentage_8,
  v0_.matches_played AS matches_played_9,
  v0_.minutes_played AS minutes_played_10,
  v0_.min_minutes_played AS min_minutes_played_11,
  v0_.role_code2 AS role_code2_12,
  v0_.tournament_id AS tournament_id_13
FROM
  view_tppppu2101 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.role_code2 NOT IN ('GK')
  AND v0_.tournament_id = ?
ORDER BY
  v0_.pass_percentage DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.passes DESC,
  v0_.successfull_passes DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.passes AS passes_6, v0_.successfull_passes AS successfull_passes_7, v0_.pass_percentage AS pass_percentage_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.role_code2 AS role_code2_12, v0_.tournament_id AS tournament_id_13 FROM view_tppppu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.role_code2 NOT IN ('GK') AND v0_.tournament_id = 3 ORDER BY v0_.pass_percentage DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.successfull_passes DESC, v0_.player ASC LIMIT 20;

#	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 41)
7	Allsvenskan\Data\Repository\ViewTPPPPU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 122)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.53 ms
(1.43%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.chances_created AS chances_created_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.matches_played AS matches_played_9, v0_.chanses90 AS chanses90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpscu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.chanses90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.chances_created AS chances_created_6,
  v0_.minutes_played AS minutes_played_7,
  v0_.min_minutes_played AS min_minutes_played_8,
  v0_.matches_played AS matches_played_9,
  v0_.chanses90 AS chanses90_10,
  v0_.tournament_id AS tournament_id_11
FROM
  view_tpscu2101 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.chanses90 DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.chances_created DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.chances_created AS chances_created_6, v0_.minutes_played AS minutes_played_7, v0_.min_minutes_played AS min_minutes_played_8, v0_.matches_played AS matches_played_9, v0_.chanses90 AS chanses90_10, v0_.tournament_id AS tournament_id_11 FROM view_tpscu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 3 ORDER BY v0_.chanses90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.chances_created DESC, v0_.player ASC LIMIT 20;

#	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 39)
7	Allsvenskan\Data\Repository\ViewTPSCU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 134)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.49 ms
(1.32%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.passes AS passes_6, v0_.key_passes AS key_passes_7, v0_.key_passes90 AS key_passes90_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.tournament_id AS tournament_id_12 FROM view_tpnpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.key_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.passes AS passes_6,
  v0_.key_passes AS key_passes_7,
  v0_.key_passes90 AS key_passes90_8,
  v0_.matches_played AS matches_played_9,
  v0_.minutes_played AS minutes_played_10,
  v0_.min_minutes_played AS min_minutes_played_11,
  v0_.tournament_id AS tournament_id_12
FROM
  view_tpnpu2101 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.key_passes90 DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.passes DESC,
  v0_.key_passes DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.passes AS passes_6, v0_.key_passes AS key_passes_7, v0_.key_passes90 AS key_passes90_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.tournament_id AS tournament_id_12 FROM view_tpnpu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 3 ORDER BY v0_.key_passes90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.passes DESC, v0_.key_passes DESC, v0_.player ASC LIMIT 20;

#	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 40)
7	Allsvenskan\Data\Repository\ViewTPNPU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 126)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.49 ms
(1.32%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.minutes_played AS minutes_played_6,
  v0_.min_minutes_played AS min_minutes_played_7,
  v0_.matches_played AS matches_played_8,
  v0_.tournament_id AS tournament_id_9
FROM
  view_tpsu2001 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.minutes_played DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2001 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;

#	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 36)
7	Allsvenskan\Data\Repository\ViewTPSU2001Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 102)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.49 ms
(1.32%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1901 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.minutes_played AS minutes_played_6,
  v0_.min_minutes_played AS min_minutes_played_7,
  v0_.matches_played AS matches_played_8,
  v0_.tournament_id AS tournament_id_9
FROM
  view_tpsu1901 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.minutes_played DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu1901 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;

#	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 36)
7	Allsvenskan\Data\Repository\ViewTPSU1901Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 106)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.48 ms
(1.28%)

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2101 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.team AS team_1,
  v0_.team_logo AS team_logo_2,
  v0_.minutes_played AS minutes_played_3,
  v0_.total_minutes AS total_minutes_4,
  v0_.percent AS percent_5,
  v0_.matches_played AS matches_played_6,
  v0_.tournament_id AS tournament_id_7
FROM
  view_ttsu2101 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.percent DESC,
  v0_.matches_played DESC,
  v0_.total_minutes DESC,
  v0_.minutes_played DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2101 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team 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 36)
7	Allsvenskan\Data\Repository\ViewTTSU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 77)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.47 ms
(1.26%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.player_goals AS player_goals_6, v0_.assists AS assists_7, v0_.points AS points_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.points90 AS points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpmapu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.points DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.player_goals AS player_goals_6,
  v0_.assists AS assists_7,
  v0_.points AS points_8,
  v0_.matches_played AS matches_played_9,
  v0_.minutes_played AS minutes_played_10,
  v0_.min_minutes_played AS min_minutes_played_11,
  v0_.points90 AS points90_12,
  v0_.tournament_id AS tournament_id_13
FROM
  view_tpmapu2101 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.points90 DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.player_goals DESC,
  v0_.assists DESC,
  v0_.points DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.player_goals AS player_goals_6, v0_.assists AS assists_7, v0_.points AS points_8, v0_.matches_played AS matches_played_9, v0_.minutes_played AS minutes_played_10, v0_.min_minutes_played AS min_minutes_played_11, v0_.points90 AS points90_12, v0_.tournament_id AS tournament_id_13 FROM view_tpmapu2101 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 3 ORDER BY v0_.points90 DESC, v0_.born DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.points DESC, v0_.player ASC LIMIT 20;

#	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 49)
7	Allsvenskan\Data\Repository\ViewTPMAPU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 114)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.47 ms
(1.26%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2101 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.player_id AS player_id_1,
  v0_.player AS player_2,
  v0_.team AS team_3,
  v0_.team_logo AS team_logo_4,
  v0_.born AS born_5,
  v0_.minutes_played AS minutes_played_6,
  v0_.min_minutes_played AS min_minutes_played_7,
  v0_.matches_played AS matches_played_8,
  v0_.tournament_id AS tournament_id_9
FROM
  view_tpsu2101 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.minutes_played DESC,
  v0_.born DESC,
  v0_.matches_played DESC,
  v0_.player ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.team AS team_3, v0_.team_logo AS team_logo_4, v0_.born AS born_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.matches_played AS matches_played_8, v0_.tournament_id AS tournament_id_9 FROM view_tpsu2101 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.minutes_played DESC, v0_.born DESC, v0_.matches_played DESC, v0_.player ASC LIMIT 20;

#	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 36)
7	Allsvenskan\Data\Repository\ViewTPSU2101Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 98)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.44 ms
(1.17%)

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.team AS team_1,
  v0_.team_logo AS team_logo_2,
  v0_.minutes_played AS minutes_played_3,
  v0_.total_minutes AS total_minutes_4,
  v0_.percent AS percent_5,
  v0_.matches_played AS matches_played_6,
  v0_.tournament_id AS tournament_id_7
FROM
  view_ttsu2001 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.percent DESC,
  v0_.matches_played DESC,
  v0_.total_minutes DESC,
  v0_.minutes_played DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu2001 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team 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 36)
7	Allsvenskan\Data\Repository\ViewTTSU2001Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 81)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.43 ms
(1.15%)

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1801 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.team AS team_1,
  v0_.team_logo AS team_logo_2,
  v0_.minutes_played AS minutes_played_3,
  v0_.total_minutes AS total_minutes_4,
  v0_.percent AS percent_5,
  v0_.matches_played AS matches_played_6,
  v0_.tournament_id AS tournament_id_7
FROM
  view_ttsu1801 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.percent DESC,
  v0_.matches_played DESC,
  v0_.total_minutes DESC,
  v0_.minutes_played DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1801 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team 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 36)
7	Allsvenskan\Data\Repository\ViewTTSU1801Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 89)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.41 ms
(1.11%)

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1901 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.team AS team_1,
  v0_.team_logo AS team_logo_2,
  v0_.minutes_played AS minutes_played_3,
  v0_.total_minutes AS total_minutes_4,
  v0_.percent AS percent_5,
  v0_.matches_played AS matches_played_6,
  v0_.tournament_id AS tournament_id_7
FROM
  view_ttsu1901 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.percent DESC,
  v0_.matches_played DESC,
  v0_.total_minutes DESC,
  v0_.minutes_played DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.minutes_played AS minutes_played_3, v0_.total_minutes AS total_minutes_4, v0_.percent AS percent_5, v0_.matches_played AS matches_played_6, v0_.tournament_id AS tournament_id_7 FROM view_ttsu1901 v0_ WHERE v0_.tournament_id = 3 ORDER BY v0_.percent DESC, v0_.matches_played DESC, v0_.total_minutes DESC, v0_.minutes_played DESC, v0_.team 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 36)
7	Allsvenskan\Data\Repository\ViewTTSU1901Repository->getItems (line 186)
8	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->getViewData (line 215)
9	Allsvenskan\Data\Service\Module\AllsvenskanServiceAbstract->renderView (line 27)
10	Allsvenskan\Data\Twig\Runtime\AllsvenskanTwigExtensionRuntime->allsvenskanDataView (line 85)
11	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_375f0dfeab7dad9fea7bf043277b68ea->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 299)
19	Twig\Environment->render (line 243)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 34)
22	App\Controller\PageController->talangdata (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.41 ms
(1.10%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.area AS area_4
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.area AS area_4 FROM competition t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 185)
6	Proxies\__CG__\Allsvenskan\Data\Entity\Competition->__get (line 100)
7	Allsvenskan\Data\Entity\Competition->getArea (line 850)
8	Allsvenskan\Data\Service\WyscoutDataManager->getTournamentsData (line 35)
9	App\Controller\PageController->talangdata (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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
Allsvenskan\Data\Entity\Tournament	No errors.
Allsvenskan\Data\Entity\Competition	No errors.
Allsvenskan\Data\Entity\Team	No errors.
Allsvenskan\Data\Entity\Matches	No errors.
Allsvenskan\Data\Entity\Player	No errors.
Allsvenskan\Data\Entity\ViewTTSU2101	No errors.
Allsvenskan\Data\Entity\ViewTTSU2001	No errors.
Allsvenskan\Data\Entity\ViewTTSU1901	No errors.
Allsvenskan\Data\Entity\ViewTTSU1801	No errors.
Allsvenskan\Data\Entity\ViewTTGA01	No errors.
Allsvenskan\Data\Entity\ViewTPSU2101	No errors.
Allsvenskan\Data\Entity\ViewTPSU2001	No errors.
Allsvenskan\Data\Entity\ViewTPSU1901	No errors.
Allsvenskan\Data\Entity\ViewTPSU1801	No errors.
Allsvenskan\Data\Entity\ViewTPMAPU2101	No errors.
Allsvenskan\Data\Entity\ViewTPXGXAXPU2101	No errors.
Allsvenskan\Data\Entity\ViewTPPPPU2101	No errors.
Allsvenskan\Data\Entity\ViewTPNPU2101	No errors.
Allsvenskan\Data\Entity\ViewTPSPPU2101	No errors.
Allsvenskan\Data\Entity\ViewTPSCU2101	No errors.

Symfony Profiler

GET https://devcodin.com/talangdata/en?season_name=2022

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping