Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.70 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = ? ORDER BY s0_.name ASC LIMIT 1

Parameters:

[
  "after_registration_discount"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.value AS value_0
FROM
  settings s0_
WHERE
  s0_.name = ?
ORDER BY
  s0_.name ASC
LIMIT
  1

SELECT s0_.value AS value_0 FROM settings s0_ WHERE s0_.name = 'after_registration_discount' ORDER BY s0_.name ASC LIMIT 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	Greendot\EshopBundle\Repository\Project\SettingsRepository->findParameterValueWithName (line 55)
8	Greendot\EshopBundle\Service\Price\ProductVariantPriceFactory->__construct (line 31)
9	ContainerTwxAYYu\App_KernelDevDebugContainer->getProductVariantPriceFactoryService (line 2138)
10	ContainerTwxAYYu\App_KernelDevDebugContainer::getPurchasePriceFactoryService (line 2154)
11	ContainerTwxAYYu\App_KernelDevDebugContainer::getPriceCalculatorService (line 2068)
12	ContainerTwxAYYu\App_KernelDevDebugContainer::getTwigService (line 4279)
13	ContainerTwxAYYu\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 881)
14	ContainerTwxAYYu\App_KernelDevDebugContainer::getProfilerListenerService (line 3777)
15	ContainerTwxAYYu\App_KernelDevDebugContainer::ContainerTwxAYYu\{closure} (line 1256)
16	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
17	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
20	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
22	Symfony\Component\HttpKernel\Kernel->handle (line 193)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.30 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = ? LIMIT 1

Parameters:

[
  "cs"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2,
  c0_.rounding AS rounding_3,
  c0_.is_default AS is_default_4,
  c0_.default_locale AS default_locale_5,
  c0_.is_symbol_left AS is_symbol_left_6,
  c0_.is_deleted AS is_deleted_7
FROM
  currency c0_
WHERE
  c0_.default_locale = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2, c0_.rounding AS rounding_3, c0_.is_default AS is_default_4, c0_.default_locale AS default_locale_5, c0_.is_symbol_left AS is_symbol_left_6, c0_.is_deleted AS is_deleted_7 FROM currency c0_ WHERE c0_.default_locale = 'cs' LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	Greendot\EshopBundle\Repository\Project\CurrencyRepository->findCurrencyByLocale (line 31)
7	Greendot\EshopBundle\Service\CurrencyManager->setByLocale (line 70)
8	Greendot\EshopBundle\Service\CurrencyManager->setLocale (line 96)
9	Symfony\Component\Translation\LocaleSwitcher->setLocale (line 49)
10	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->setLocale (line 68)
11	Symfony\Component\HttpKernel\EventListener\LocaleAwareListener->onKernelRequest (line 39)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 99)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 241)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 91)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
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
Greendot\EshopBundle\Entity\Project\Currency	1

Entities Mapping

Class	Mapping errors
Greendot\EshopBundle\Entity\Project\Settings	No errors.
Greendot\EshopBundle\Entity\Project\Currency	No errors.
Greendot\EshopBundle\Entity\Project\ConversionRate	No errors.

Symfony Profiler

GET https://proklima.greendot.cz/_profiler/d5c7b2?connection=default&page=explain&panel=db&query=148

Configuration Settings

Theme

Page Width