Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.83 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.81 ms
(41.14%)

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, c1_.id AS id_19, c1_.name AS name_20, c1_.description AS description_21, c1_.code AS code_22, c1_.icon AS icon_23, c1_.api_id AS api_id_24, c1_.current_form AS current_form_25, c2_.id AS id_26, c2_.name AS name_27, c2_.description AS description_28, c2_.code AS code_29, c2_.icon AS icon_30, c2_.api_id AS api_id_31, c2_.current_form AS current_form_32, b3_.id AS id_33, b3_.prediction AS prediction_34, b3_.score AS score_35, b3_.evaluated AS evaluated_36, b3_.boosted AS boosted_37, b3_.created_at AS created_at_38, b3_.updated_at AS updated_at_39, g0_.competition_id AS competition_id_40, g0_.round_id AS round_id_41, g0_.home_competitor_id AS home_competitor_id_42, g0_.away_competitor_id AS away_competitor_id_43, c1_.participant_id AS participant_id_44, c1_.competition_id AS competition_id_45, c2_.participant_id AS participant_id_46, c2_.competition_id AS competition_id_47, b3_.user_id AS user_id_48, b3_.game_id AS game_id_49 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,
  c1_.id AS id_19,
  c1_.name AS name_20,
  c1_.description AS description_21,
  c1_.code AS code_22,
  c1_.icon AS icon_23,
  c1_.api_id AS api_id_24,
  c1_.current_form AS current_form_25,
  c2_.id AS id_26,
  c2_.name AS name_27,
  c2_.description AS description_28,
  c2_.code AS code_29,
  c2_.icon AS icon_30,
  c2_.api_id AS api_id_31,
  c2_.current_form AS current_form_32,
  b3_.id AS id_33,
  b3_.prediction AS prediction_34,
  b3_.score AS score_35,
  b3_.evaluated AS evaluated_36,
  b3_.boosted AS boosted_37,
  b3_.created_at AS created_at_38,
  b3_.updated_at AS updated_at_39,
  g0_.competition_id AS competition_id_40,
  g0_.round_id AS round_id_41,
  g0_.home_competitor_id AS home_competitor_id_42,
  g0_.away_competitor_id AS away_competitor_id_43,
  c1_.participant_id AS participant_id_44,
  c1_.competition_id AS competition_id_45,
  c2_.participant_id AS participant_id_46,
  c2_.competition_id AS competition_id_47,
  b3_.user_id AS user_id_48,
  b3_.game_id AS game_id_49
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, c1_.id AS id_19, c1_.name AS name_20, c1_.description AS description_21, c1_.code AS code_22, c1_.icon AS icon_23, c1_.api_id AS api_id_24, c1_.current_form AS current_form_25, c2_.id AS id_26, c2_.name AS name_27, c2_.description AS description_28, c2_.code AS code_29, c2_.icon AS icon_30, c2_.api_id AS api_id_31, c2_.current_form AS current_form_32, b3_.id AS id_33, b3_.prediction AS prediction_34, b3_.score AS score_35, b3_.evaluated AS evaluated_36, b3_.boosted AS boosted_37, b3_.created_at AS created_at_38, b3_.updated_at AS updated_at_39, g0_.competition_id AS competition_id_40, g0_.round_id AS round_id_41, g0_.home_competitor_id AS home_competitor_id_42, g0_.away_competitor_id AS away_competitor_id_43, c1_.participant_id AS participant_id_44, c1_.competition_id AS competition_id_45, c2_.participant_id AS participant_id_46, c2_.competition_id AS competition_id_47, b3_.user_id AS user_id_48, b3_.game_id AS game_id_49 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 = 23 ORDER BY g0_.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\GameRepository->findWithUserBet (line 21)
8	App\Service\RoundManager->fetch (line 30)
9	App\Controller\CompetitionController->show (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.87 ms
(27.34%)

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:

[
  "1"
]

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 = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 119)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.13 ms
(16.55%)

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:

[
  3
]

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 = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Sport::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Sport->__get (line 75)
8	App\Entity\Sport->getCode (line 1863)
9	Twig\Extension\CoreExtension::getAttribute (line 108)
10	__TwigTemplate_500514684c790feefd7bc6f663899367->block_body (line 431)
11	Twig\Template->yieldBlock (line 214)
12	__TwigTemplate_a186ad43b42505cd70fd4e4e54550594->doDisplay (line 387)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_500514684c790feefd7bc6f663899367->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 32)
23	App\Controller\CompetitionController->show (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.02 ms
(14.97%)

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:

[
  1
]

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 = 1 ORDER BY t0.sequence ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 29)
8	App\Controller\CompetitionController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\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 https://gg.betfor.fun/competition/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping