Symfony Profiler

Query Metrics

8 Database Queries

2 Different statements

1.58 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.27 ms
(80.25%)

SELECT t0.code AS code_1, t0.rate AS rate_2, t0.updated_at AS updated_at_3 FROM currency_rates t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.rate AS rate_2,
  t0.updated_at AS updated_at_3
FROM
  currency_rates t0

SELECT t0.code AS code_1, t0.rate AS rate_2, t0.updated_at AS updated_at_3 FROM currency_rates t0;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
5	Doctrine\ORM\EntityRepository->findBy (line 110)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
7	Doctrine\ORM\EntityRepository->findAll (line 96)
8	App\Repository\CurrencyRateRepository->asMap (line 25)
9	App\Service\Currency\CurrencyConverter->convert (line 24)
10	App\Twig\AppExtension->price (line 101)
11	__TwigTemplate_fa6ee9df82b05685e667c36f72c5bc96->block_body (line 156)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_72ff5be9fc0d644930f3d35de6346f9f->block_layout (line 755)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_72ff5be9fc0d644930f3d35de6346f9f->doDisplay (line 253)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_fa6ee9df82b05685e667c36f72c5bc96->doDisplay (line 58)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\Public\FoundationController->index (line 23)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.31 ms
(19.75%)

SELECT c0_.code AS code_0, c0_.rate AS rate_1, c0_.updated_at AS updated_at_2 FROM currency_rates c0_ ORDER BY c0_.updated_at DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.code AS code_0,
  c0_.rate AS rate_1,
  c0_.updated_at AS updated_at_2
FROM
  currency_rates c0_
ORDER BY
  c0_.updated_at DESC
LIMIT
  1

SELECT c0_.code AS code_0, c0_.rate AS rate_1, c0_.updated_at AS updated_at_2 FROM currency_rates c0_ ORDER BY c0_.updated_at DESC LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
9	App\Repository\CurrencyRateRepository->latestUpdatedAt (line 36)
10	App\EventSubscriber\CurrencyTwigGlobalSubscriber->onController (line 72)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	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

Entities Mapping

Class	Mapping errors
App\Entity\CurrencyRate	No errors.

Symfony Profiler

GET https://next.mironova.art/de/foundation

Configuration Settings

Theme

Page Width