Symfony Profiler

Query Metrics

125 Database Queries

2 Different statements

18.56 ms Query time

1 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

17.82 ms
(96.00%)

124

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.started_at AS started_at_2,
  l0_.ended_at AS ended_at_3,
  l0_.is_active AS is_active_4
FROM
  league l0_
WHERE
  l0_.is_active = 1

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.started_at AS started_at_2, l0_.ended_at AS ended_at_3, l0_.is_active AS is_active_4 FROM league l0_ WHERE l0_.is_active = 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 39)
7	App\Repository\LeagueRepository->findActiveLeague (line 19)
8	App\Service\GlobalTwigVariableService->getCurrentLeague (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 54)
10	__TwigTemplate_d5cf50b52b5b15032f7f9271ccbf78bf->doDisplay (line 402)
11	Twig\Template->yield (line 90)
12	__TwigTemplate_6ae2611feff00bcb35a013f9179f5fff->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_1f19666091f5bb60a5ccbd50a79323a6->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
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 40)
23	App\Controller\EconomyController->index (line 17)
24	App\Controller\EconomyController->default (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.74 ms
(4.00%)

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.type AS type_2, i0_.icon AS icon_3, i0_.slug AS slug_4, i0_.sub_category AS sub_category_5 FROM item i0_ WHERE i0_.type = ? ORDER BY i0_.name ASC

Parameters:

[
  "Currency"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.type AS type_2,
  i0_.icon AS icon_3,
  i0_.slug AS slug_4,
  i0_.sub_category AS sub_category_5
FROM
  item i0_
WHERE
  i0_.type = ?
ORDER BY
  i0_.name ASC

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.type AS type_2, i0_.icon AS icon_3, i0_.slug AS slug_4, i0_.sub_category AS sub_category_5 FROM item i0_ WHERE i0_.type = 'Currency' ORDER BY i0_.name 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 56)
7	App\Repository\ItemRepository->findAllByType (line 23)
8	App\Controller\EconomyController->index (line 17)
9	App\Controller\EconomyController->default (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)

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\League	1

Entities Mapping

Class	Mapping errors
App\Entity\Item	The mappings App\Entity\Item#currencyPrices and App\Entity\CurrencyPrice#type are inconsistent with each other.
App\Entity\League	No errors.

Symfony Profiler

GET https://exile-economics.com/

Configuration Settings

Theme

Page Width