Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

8.23 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.47 ms
(42.23%)

SELECT t0.id AS id_1, t0.home_score AS home_score_2, t0.away_score AS away_score_3, t0.cancelled AS cancelled_4, t0.forfeit AS forfeit_5, t0.completed AS completed_6, t0.phase_clubee_id AS phase_clubee_id_7, t0.phase_name AS phase_name_8, t0.updated_at AS updated_at_9, t0.result_recorded_at AS result_recorded_at_10, t0.detail_fetched_at AS detail_fetched_at_11, t0.clubee_id AS clubee_id_12, t0.starts_at AS starts_at_13, t0.venue_name AS venue_name_14, t0.venue_street AS venue_street_15, t0.venue_city AS venue_city_16, t0.venue_zip AS venue_zip_17, t0.venue_country AS venue_country_18, t0.venue_latitude AS venue_latitude_19, t0.venue_longitude AS venue_longitude_20, t0.home_team_id AS home_team_id_21, t0.away_team_id AS away_team_id_22, t0.competition_id AS competition_id_23, t0.season_id AS season_id_24 FROM "game" t0 WHERE t0.id = ?

Parameters:

[
  5376
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.home_score AS home_score_2,
  t0.away_score AS away_score_3,
  t0.cancelled AS cancelled_4,
  t0.forfeit AS forfeit_5,
  t0.completed AS completed_6,
  t0.phase_clubee_id AS phase_clubee_id_7,
  t0.phase_name AS phase_name_8,
  t0.updated_at AS updated_at_9,
  t0.result_recorded_at AS result_recorded_at_10,
  t0.detail_fetched_at AS detail_fetched_at_11,
  t0.clubee_id AS clubee_id_12,
  t0.starts_at AS starts_at_13,
  t0.venue_name AS venue_name_14,
  t0.venue_street AS venue_street_15,
  t0.venue_city AS venue_city_16,
  t0.venue_zip AS venue_zip_17,
  t0.venue_country AS venue_country_18,
  t0.venue_latitude AS venue_latitude_19,
  t0.venue_longitude AS venue_longitude_20,
  t0.home_team_id AS home_team_id_21,
  t0.away_team_id AS away_team_id_22,
  t0.competition_id AS competition_id_23,
  t0.season_id AS season_id_24
FROM
  "game" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.home_score AS home_score_2, t0.away_score AS away_score_3, t0.cancelled AS cancelled_4, t0.forfeit AS forfeit_5, t0.completed AS completed_6, t0.phase_clubee_id AS phase_clubee_id_7, t0.phase_name AS phase_name_8, t0.updated_at AS updated_at_9, t0.result_recorded_at AS result_recorded_at_10, t0.detail_fetched_at AS detail_fetched_at_11, t0.clubee_id AS clubee_id_12, t0.starts_at AS starts_at_13, t0.venue_name AS venue_name_14, t0.venue_street AS venue_street_15, t0.venue_city AS venue_city_16, t0.venue_zip AS venue_zip_17, t0.venue_country AS venue_country_18, t0.venue_latitude AS venue_latitude_19, t0.venue_longitude AS venue_longitude_20, t0.home_team_id AS home_team_id_21, t0.away_team_id AS away_team_id_22, t0.competition_id AS competition_id_23, t0.season_id AS season_id_24 FROM "game" t0 WHERE t0.id = 5376;

#	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\ServiceEntityRepository->find (line 66)
6	App\Controller\GameController->entityOf (line 34)
7	App\Controller\GameController->show (line 17)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

2.13 ms
(25.93%)

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?

Parameters:

[
  515
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.search_name AS search_name_2,
  t0.subname AS subname_3,
  t0.category AS category_4,
  t0.gender AS gender_5,
  t0.crest_url AS crest_url_6,
  t0.name AS name_7,
  t0.normalized_name AS normalized_name_8,
  t0.clubee_id AS clubee_id_9,
  t0.club_id AS club_id_10
FROM
  "team" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 515;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Team::getFullName (line 107)
5	App\Entity\Game->getSlug (line 138)
6	App\Controller\GameController->canonical (line 46)
7	App\Controller\GameController->show (line 19)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.42 ms
(17.20%)

SELECT t0.id AS id_1, t0.home_run AS home_run_2, t0.away_run AS away_run_3, t0.number AS number_4, t0.home_points AS home_points_5, t0.away_points AS away_points_6, t0.game_id AS game_id_7 FROM "game_set" t0 WHERE t0.game_id = ? ORDER BY t0.number ASC

Parameters:

[
  5376
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.home_run AS home_run_2,
  t0.away_run AS away_run_3,
  t0.number AS number_4,
  t0.home_points AS home_points_5,
  t0.away_points AS away_points_6,
  t0.game_id AS game_id_7
FROM
  "game_set" t0
WHERE
  t0.game_id = ?
ORDER BY
  t0.number ASC

SELECT t0.id AS id_1, t0.home_run AS home_run_2, t0.away_run AS away_run_3, t0.number AS number_4, t0.home_points AS home_points_5, t0.away_points AS away_points_6, t0.game_id AS game_id_7 FROM "game_set" t0 WHERE t0.game_id = 5376 ORDER BY t0.number 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 2746)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	IteratorIterator->__construct (line 2004)
8	Twig\Extension\CoreExtension->filter (line 2004)
9	__TwigTemplate_d14ac2525fa5e08df1c5c85e9a917dd4::block_body (line 108)
10	Twig\Template->yieldBlock (line 458)
11	__TwigTemplate_8aad3bdaca766e12d95e945ccfc4bef2->doDisplay (line 191)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_d14ac2525fa5e08df1c5c85e9a917dd4->doDisplay (line 55)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
22	App\Controller\GameController->show (line 19)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
25	Symfony\Component\HttpKernel\Kernel->handle (line 143)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

1.20 ms
(14.65%)

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.gender AS gender_3, t0.region AS region_4, t0.category AS category_5, t0.type AS type_6, t0.active AS active_7, t0.scanned_at AS scanned_at_8, t0.name AS name_9, t0.clubee_id AS clubee_id_10, t0.season_id AS season_id_11 FROM "competition" t0 WHERE t0.id = ?

Parameters:

[
  61
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.search_name AS search_name_2,
  t0.gender AS gender_3,
  t0.region AS region_4,
  t0.category AS category_5,
  t0.type AS type_6,
  t0.active AS active_7,
  t0.scanned_at AS scanned_at_8,
  t0.name AS name_9,
  t0.clubee_id AS clubee_id_10,
  t0.season_id AS season_id_11
FROM
  "competition" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.gender AS gender_3, t0.region AS region_4, t0.category AS category_5, t0.type AS type_6, t0.active AS active_7, t0.scanned_at AS scanned_at_8, t0.name AS name_9, t0.clubee_id AS clubee_id_10, t0.season_id AS season_id_11 FROM "competition" t0 WHERE t0.id = 61;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1801)
5	__TwigTemplate_d14ac2525fa5e08df1c5c85e9a917dd4::block_body (line 117)
6	Twig\Template->yieldBlock (line 458)
7	__TwigTemplate_8aad3bdaca766e12d95e945ccfc4bef2->doDisplay (line 191)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_d14ac2525fa5e08df1c5c85e9a917dd4->doDisplay (line 55)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
18	App\Controller\GameController->show (line 19)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Team	2
App\Entity\Club	2
App\Entity\Game	1
App\Entity\Competition	1
App\Entity\Season	1

Entities Mapping

Class	Mapping errors
App\Entity\Address	No errors.
App\Entity\Game	No errors.
App\Entity\Team	No errors.
App\Entity\Competition	No errors.
App\Entity\Season	No errors.
App\Entity\GameSet	No errors.
App\Entity\Referee	No errors.
App\Entity\Club	No errors.

GET http://beta.easyscore.be/match/5376-thimister-herve-s-c-f-verviers-athenee-v-c-c

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping