Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

0.89 ms Query time

0 Invalid entities

82 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.20 ms
(22.17%)

SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.bet_opened AS bet_opened_3, g0_.status AS status_4, g0_.date AS date_5, g0_.weight AS weight_6, g0_.home_scores AS home_scores_7, g0_.away_scores AS away_scores_8, g0_.api_id AS api_id_9, g0_.home_odds AS home_odds_10, g0_.away_odds AS away_odds_11, g0_.draw_odds AS draw_odds_12, g0_.status_detail AS status_detail_13, g0_.clock AS clock_14, g0_.allow_draw AS allow_draw_15, g0_.winner AS winner_16, g0_.updated_at AS updated_at_17, g0_.details AS details_18, g0_.home_odds_count AS home_odds_count_19, g0_.away_odds_count AS away_odds_count_20, g0_.draw_odds_count AS draw_odds_count_21, c1_.id AS id_22, c1_.name AS name_23, c1_.description AS description_24, c1_.code AS code_25, c1_.icon AS icon_26, c1_.api_id AS api_id_27, c1_.current_form AS current_form_28, c2_.id AS id_29, c2_.name AS name_30, c2_.description AS description_31, c2_.code AS code_32, c2_.icon AS icon_33, c2_.api_id AS api_id_34, c2_.current_form AS current_form_35, b3_.id AS id_36, b3_.prediction AS prediction_37, b3_.score AS score_38, b3_.evaluated AS evaluated_39, b3_.boosted AS boosted_40, b3_.created_at AS created_at_41, b3_.updated_at AS updated_at_42, g0_.competition_id AS competition_id_43, g0_.round_id AS round_id_44, g0_.home_competitor_id AS home_competitor_id_45, g0_.away_competitor_id AS away_competitor_id_46, c1_.participant_id AS participant_id_47, c1_.competition_id AS competition_id_48, c2_.participant_id AS participant_id_49, c2_.competition_id AS competition_id_50, b3_.user_id AS user_id_51, b3_.game_id AS game_id_52 FROM game g0_ INNER JOIN competitor c1_ ON g0_.away_competitor_id = c1_.id INNER JOIN competitor c2_ ON g0_.home_competitor_id = c2_.id LEFT JOIN bet b3_ ON g0_.id = b3_.game_id AND (b3_.user_id = ?) WHERE g0_.round_id = ? ORDER BY g0_.date ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.home_score AS home_score_1,
  g0_.away_score AS away_score_2,
  g0_.bet_opened AS bet_opened_3,
  g0_.status AS status_4,
  g0_.date AS date_5,
  g0_.weight AS weight_6,
  g0_.home_scores AS home_scores_7,
  g0_.away_scores AS away_scores_8,
  g0_.api_id AS api_id_9,
  g0_.home_odds AS home_odds_10,
  g0_.away_odds AS away_odds_11,
  g0_.draw_odds AS draw_odds_12,
  g0_.status_detail AS status_detail_13,
  g0_.clock AS clock_14,
  g0_.allow_draw AS allow_draw_15,
  g0_.winner AS winner_16,
  g0_.updated_at AS updated_at_17,
  g0_.details AS details_18,
  g0_.home_odds_count AS home_odds_count_19,
  g0_.away_odds_count AS away_odds_count_20,
  g0_.draw_odds_count AS draw_odds_count_21,
  c1_.id AS id_22,
  c1_.name AS name_23,
  c1_.description AS description_24,
  c1_.code AS code_25,
  c1_.icon AS icon_26,
  c1_.api_id AS api_id_27,
  c1_.current_form AS current_form_28,
  c2_.id AS id_29,
  c2_.name AS name_30,
  c2_.description AS description_31,
  c2_.code AS code_32,
  c2_.icon AS icon_33,
  c2_.api_id AS api_id_34,
  c2_.current_form AS current_form_35,
  b3_.id AS id_36,
  b3_.prediction AS prediction_37,
  b3_.score AS score_38,
  b3_.evaluated AS evaluated_39,
  b3_.boosted AS boosted_40,
  b3_.created_at AS created_at_41,
  b3_.updated_at AS updated_at_42,
  g0_.competition_id AS competition_id_43,
  g0_.round_id AS round_id_44,
  g0_.home_competitor_id AS home_competitor_id_45,
  g0_.away_competitor_id AS away_competitor_id_46,
  c1_.participant_id AS participant_id_47,
  c1_.competition_id AS competition_id_48,
  c2_.participant_id AS participant_id_49,
  c2_.competition_id AS competition_id_50,
  b3_.user_id AS user_id_51,
  b3_.game_id AS game_id_52
FROM
  game g0_
  INNER JOIN competitor c1_ ON g0_.away_competitor_id = c1_.id
  INNER JOIN competitor c2_ ON g0_.home_competitor_id = c2_.id
  LEFT JOIN bet b3_ ON g0_.id = b3_.game_id
  AND (b3_.user_id = ?)
WHERE
  g0_.round_id = ?
ORDER BY
  g0_.date ASC

SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.bet_opened AS bet_opened_3, g0_.status AS status_4, g0_.date AS date_5, g0_.weight AS weight_6, g0_.home_scores AS home_scores_7, g0_.away_scores AS away_scores_8, g0_.api_id AS api_id_9, g0_.home_odds AS home_odds_10, g0_.away_odds AS away_odds_11, g0_.draw_odds AS draw_odds_12, g0_.status_detail AS status_detail_13, g0_.clock AS clock_14, g0_.allow_draw AS allow_draw_15, g0_.winner AS winner_16, g0_.updated_at AS updated_at_17, g0_.details AS details_18, g0_.home_odds_count AS home_odds_count_19, g0_.away_odds_count AS away_odds_count_20, g0_.draw_odds_count AS draw_odds_count_21, c1_.id AS id_22, c1_.name AS name_23, c1_.description AS description_24, c1_.code AS code_25, c1_.icon AS icon_26, c1_.api_id AS api_id_27, c1_.current_form AS current_form_28, c2_.id AS id_29, c2_.name AS name_30, c2_.description AS description_31, c2_.code AS code_32, c2_.icon AS icon_33, c2_.api_id AS api_id_34, c2_.current_form AS current_form_35, b3_.id AS id_36, b3_.prediction AS prediction_37, b3_.score AS score_38, b3_.evaluated AS evaluated_39, b3_.boosted AS boosted_40, b3_.created_at AS created_at_41, b3_.updated_at AS updated_at_42, g0_.competition_id AS competition_id_43, g0_.round_id AS round_id_44, g0_.home_competitor_id AS home_competitor_id_45, g0_.away_competitor_id AS away_competitor_id_46, c1_.participant_id AS participant_id_47, c1_.competition_id AS competition_id_48, c2_.participant_id AS participant_id_49, c2_.competition_id AS competition_id_50, b3_.user_id AS user_id_51, b3_.game_id AS game_id_52 FROM game g0_ INNER JOIN competitor c1_ ON g0_.away_competitor_id = c1_.id INNER JOIN competitor c2_ ON g0_.home_competitor_id = c2_.id LEFT JOIN bet b3_ ON g0_.id = b3_.game_id AND (b3_.user_id = 0) WHERE g0_.round_id = 56 ORDER BY g0_.date ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\GameRepository->findWithUserBet (line 117)
7	App\Service\RoundManager->fetch (line 21)
8	App\Controller\GameController->list (line 47)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.20 ms
(21.93%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.competition_id = ? ORDER BY t0.sequence ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.external_id AS external_id_5,
  t0.competition_id AS competition_id_6
FROM
  round t0
WHERE
  t0.competition_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.competition_id = 4 ORDER BY t0.sequence ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Twig\Extension\CoreExtension->find (line 1996)
8	__TwigTemplate_b44389ede99667b5b27a9f3c79a06929::block_body (line 186)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_b9893a7e9b2ea6bc9c5eb3221b0c28f0->doDisplay (line 213)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_b44389ede99667b5b27a9f3c79a06929->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\GameController->list (line 55)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.19 ms
(21.72%)

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.id = ?

Parameters:

[
  56
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.name AS name_3,
  t0.active AS active_4,
  t0.external_id AS external_id_5,
  t0.competition_id AS competition_id_6
FROM
  round t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.active AS active_4, t0.external_id AS external_id_5, t0.competition_id AS competition_id_6 FROM round t0 WHERE t0.id = 56;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\GameController->list (line 38)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.17 ms
(19.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.icon AS icon_5,
  t0.code AS code_6,
  t0.league AS league_7,
  t0.season AS season_8,
  t0.sport_id AS sport_id_9
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\GameController->list (line 37)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.13 ms
(14.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.icon AS icon_4
FROM
  sport t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Sport::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Sport->__get (line 153)
7	App\Entity\Sport->getCode (line 75)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_b44389ede99667b5b27a9f3c79a06929::block_body (line 108)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b9893a7e9b2ea6bc9c5eb3221b0c28f0->doDisplay (line 213)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_b44389ede99667b5b27a9f3c79a06929->doDisplay (line 56)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\GameController->list (line 55)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Round	40
App\Entity\Competitor	16
App\Entity\Participant	16
App\Entity\Game	8
App\Entity\Competition	1
App\Entity\Sport	1

Entities Mapping

Class	Mapping errors
App\Entity\Competition	No errors.
App\Entity\Sport	No errors.
App\Entity\Round	No errors.
App\Entity\Competitor	No errors.
App\Entity\Game	No errors.
App\Entity\UserCompetition	No errors.
App\Entity\League	No errors.
App\Entity\UserCompetitionRound	No errors.
App\Entity\Bet	No errors.
App\Entity\Participant	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET http://betforfun.be/competition/4/round/56/games

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping