Symfony Profiler

Query Metrics

35 Database Queries

11 Different statements

22.69 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.28 ms
(45.30%)

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"
  "2018"
  "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 = '2018' 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 14)
9	App\Controller\PageController->index (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)

7.55 ms
(33.26%)

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 14)
9	App\Controller\PageController->index (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.77 ms
(3.40%)

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_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals DESC, v0_.player ASC LIMIT 20

Parameters:

[
  10
]

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_.matches_played AS matches_played_5,
  v0_.minutes_played AS minutes_played_6,
  v0_.min_minutes_played AS min_minutes_played_7,
  v0_.goals_scored AS goals_scored_8,
  v0_.expected_goals AS expected_goals_9,
  v0_.ordinary_position AS ordinary_position_10,
  v0_.expected_goals90 AS expected_goals90_11,
  v0_.tournament_id AS tournament_id_12
FROM
  view_tpmxg01 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.goals_scored DESC,
  v0_.expected_goals90 DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.expected_goals 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_.matches_played AS matches_played_5, v0_.minutes_played AS minutes_played_6, v0_.min_minutes_played AS min_minutes_played_7, v0_.goals_scored AS goals_scored_8, v0_.expected_goals AS expected_goals_9, v0_.ordinary_position AS ordinary_position_10, v0_.expected_goals90 AS expected_goals90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmxg01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.goals_scored DESC, v0_.expected_goals90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.expected_goals 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\ViewTPMXG01Repository->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 99)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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.59 ms
(2.59%)

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_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists DESC, v0_.player ASC LIMIT 20

Parameters:

[
  10
]

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_.player_goals AS player_goals_5,
  v0_.assists AS assists_6,
  v0_.points AS points_7,
  v0_.matches_played AS matches_played_8,
  v0_.minutes_played AS minutes_played_9,
  v0_.min_minutes_played AS min_minutes_played_10,
  v0_.points90 AS points90_11,
  v0_.tournament_id AS tournament_id_12
FROM
  view_tpmap01 v0_
WHERE
  v0_.minutes_played >= v0_.min_minutes_played
  AND v0_.tournament_id = ?
ORDER BY
  v0_.points DESC,
  v0_.points90 DESC,
  v0_.matches_played DESC,
  v0_.minutes_played DESC,
  v0_.player_goals DESC,
  v0_.assists 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_.player_goals AS player_goals_5, v0_.assists AS assists_6, v0_.points AS points_7, v0_.matches_played AS matches_played_8, v0_.minutes_played AS minutes_played_9, v0_.min_minutes_played AS min_minutes_played_10, v0_.points90 AS points90_11, v0_.tournament_id AS tournament_id_12 FROM view_tpmap01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 ORDER BY v0_.points DESC, v0_.points90 DESC, v0_.matches_played DESC, v0_.minutes_played DESC, v0_.player_goals DESC, v0_.assists 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 48)
7	Allsvenskan\Data\Repository\ViewTPMAP01Repository->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 91)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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
(2.57%)

SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.position AS position_1,
  v0_.team AS team_2,
  v0_.team_logo AS team_logo_3,
  v0_.games_matches AS games_matches_4,
  v0_.won AS won_5,
  v0_.tied_draw AS tied_draw_6,
  v0_.lost AS lost_7,
  v0_.goals_scored AS goals_scored_8,
  v0_.goals_conceded AS goals_conceded_9,
  v0_.points AS points_10,
  v0_.tournament_id AS tournament_id_11
FROM
  view_ttaht01 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.points DESC,
  v0_.goals_scored - v0_.goals_conceded DESC,
  v0_.games_matches DESC,
  v0_.won DESC,
  v0_.tied_draw DESC,
  v0_.lost DESC,
  v0_.goals_conceded DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttaht01 v0_ WHERE v0_.tournament_id = 10 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded 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 47)
7	Allsvenskan\Data\Repository\ViewTTAHT01Repository->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 79)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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
(2.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_.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_tpxgxaxp01 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:

[
  10
]

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_tpxgxaxp01 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_tpxgxaxp01 v0_ WHERE v0_.minutes_played >= v0_.min_minutes_played AND v0_.tournament_id = 10 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\ViewTPXGXAXP01Repository->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 95)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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.56 ms
(2.46%)

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.birth_date AS birth_date_3, v0_.team AS team_4, v0_.team_logo AS team_logo_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_.goals90 AS goals90_9, v0_.shots90 AS shots90_10, v0_.goals AS goals_11, v0_.shots AS shots_12, v0_.role_name AS role_name_13, v0_.role_code2 AS role_code2_14, v0_.is_min_minutes_played AS is_min_minutes_played_15, v0_.tournament_id AS tournament_id_16 FROM view_spmvs9001 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.player ASC

Parameters:

[
  10
]

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_.birth_date AS birth_date_3,
  v0_.team AS team_4,
  v0_.team_logo AS team_logo_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_.goals90 AS goals90_9,
  v0_.shots90 AS shots90_10,
  v0_.goals AS goals_11,
  v0_.shots AS shots_12,
  v0_.role_name AS role_name_13,
  v0_.role_code2 AS role_code2_14,
  v0_.is_min_minutes_played AS is_min_minutes_played_15,
  v0_.tournament_id AS tournament_id_16
FROM
  view_spmvs9001 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.player ASC

SELECT v0_.id AS id_0, v0_.player_id AS player_id_1, v0_.player AS player_2, v0_.birth_date AS birth_date_3, v0_.team AS team_4, v0_.team_logo AS team_logo_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_.goals90 AS goals90_9, v0_.shots90 AS shots90_10, v0_.goals AS goals_11, v0_.shots AS shots_12, v0_.role_name AS role_name_13, v0_.role_code2 AS role_code2_14, v0_.is_min_minutes_played AS is_min_minutes_played_15, v0_.tournament_id AS tournament_id_16 FROM view_spmvs9001 v0_ WHERE v0_.tournament_id = 10 ORDER BY v0_.player 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 40)
7	Allsvenskan\Data\Repository\ViewSPMVS9001Repository->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 270)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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.52 ms
(2.27%)

SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.position ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.position AS position_1,
  v0_.team AS team_2,
  v0_.team_logo AS team_logo_3,
  v0_.games_matches AS games_matches_4,
  v0_.won AS won_5,
  v0_.tied_draw AS tied_draw_6,
  v0_.lost AS lost_7,
  v0_.goals_scored AS goals_scored_8,
  v0_.goals_conceded AS goals_conceded_9,
  v0_.points AS points_10,
  v0_.tournament_id AS tournament_id_11
FROM
  view_ttat01 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.position ASC

SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttat01 v0_ WHERE v0_.tournament_id = 10 ORDER BY v0_.position 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 39)
7	Allsvenskan\Data\Repository\ViewTTAT01Repository->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 75)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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
(2.11%)

SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded DESC, v0_.team ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.position AS position_1,
  v0_.team AS team_2,
  v0_.team_logo AS team_logo_3,
  v0_.games_matches AS games_matches_4,
  v0_.won AS won_5,
  v0_.tied_draw AS tied_draw_6,
  v0_.lost AS lost_7,
  v0_.goals_scored AS goals_scored_8,
  v0_.goals_conceded AS goals_conceded_9,
  v0_.points AS points_10,
  v0_.tournament_id AS tournament_id_11
FROM
  view_ttabt01 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.points DESC,
  v0_.goals_scored - v0_.goals_conceded DESC,
  v0_.games_matches DESC,
  v0_.won DESC,
  v0_.tied_draw DESC,
  v0_.lost DESC,
  v0_.goals_conceded DESC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.position AS position_1, v0_.team AS team_2, v0_.team_logo AS team_logo_3, v0_.games_matches AS games_matches_4, v0_.won AS won_5, v0_.tied_draw AS tied_draw_6, v0_.lost AS lost_7, v0_.goals_scored AS goals_scored_8, v0_.goals_conceded AS goals_conceded_9, v0_.points AS points_10, v0_.tournament_id AS tournament_id_11 FROM view_ttabt01 v0_ WHERE v0_.tournament_id = 10 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.games_matches DESC, v0_.won DESC, v0_.tied_draw DESC, v0_.lost DESC, v0_.goals_conceded 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 47)
7	Allsvenskan\Data\Repository\ViewTTABT01Repository->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 83)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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.96%)

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = ? ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, v0_.team ASC

Parameters:

[
  10
]

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_.games_matches AS games_matches_3,
  v0_.won AS won_4,
  v0_.tied_draw AS tied_draw_5,
  v0_.lost AS lost_6,
  v0_.goals_scored AS goals_scored_7,
  v0_.goals_conceded AS goals_conceded_8,
  v0_.points AS points_9,
  v0_.ordinary_position AS ordinary_position_10,
  v0_.tournament_id AS tournament_id_11
FROM
  view_ttatxg01 v0_
WHERE
  v0_.tournament_id = ?
ORDER BY
  v0_.points DESC,
  v0_.goals_scored - v0_.goals_conceded DESC,
  v0_.won DESC,
  v0_.goals_scored ASC,
  v0_.team ASC

SELECT v0_.id AS id_0, v0_.team AS team_1, v0_.team_logo AS team_logo_2, v0_.games_matches AS games_matches_3, v0_.won AS won_4, v0_.tied_draw AS tied_draw_5, v0_.lost AS lost_6, v0_.goals_scored AS goals_scored_7, v0_.goals_conceded AS goals_conceded_8, v0_.points AS points_9, v0_.ordinary_position AS ordinary_position_10, v0_.tournament_id AS tournament_id_11 FROM view_ttatxg01 v0_ WHERE v0_.tournament_id = 10 ORDER BY v0_.points DESC, v0_.goals_scored - v0_.goals_conceded DESC, v0_.won DESC, v0_.goals_scored ASC, 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\ViewTTATXG01Repository->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 87)
11	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->block_body (line 430)
12	Twig\Template->yieldBlock (line 806)
13	__TwigTemplate_18a735c7d9faa42a7d13cc3d9c8124a1->doDisplay (line 360)
14	Twig\Template->yield (line 49)
15	__TwigTemplate_fb578bfbdc1725443a0e5ec73ac683d9->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 13)
22	App\Controller\PageController->index (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.34 ms
(1.51%)

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 14)
9	App\Controller\PageController->index (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\ViewTTAT01	No errors.
Allsvenskan\Data\Entity\ViewTTAHT01	No errors.
Allsvenskan\Data\Entity\ViewTTABT01	No errors.
Allsvenskan\Data\Entity\ViewTTATXG01	No errors.
Allsvenskan\Data\Entity\ViewTPMAP01	No errors.
Allsvenskan\Data\Entity\ViewTPXGXAXP01	No errors.
Allsvenskan\Data\Entity\ViewTPMXG01	No errors.
Allsvenskan\Data\Entity\ViewSPMVS9001	No errors.

Symfony Profiler

GET https://devcodin.com/?season_name=2018

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping