Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.94 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.38 ms
(71.19%)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = ?) AND (c0_.deleted_at IS NULL)

Parameters:

[
  "RU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.code AS code_4,
  c0_.deleted_at AS deleted_at_5,
  c0_.currency_id AS currency_id_6
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.code AS code_4, c0_.deleted_at AS deleted_at_5, c0_.currency_id AS currency_id_6 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 38)
7	App\Geo\Repository\CountryRepository->findOneByCode (line 29)
8	App\Geo\Service\CountryService->getCountry (line 152)
9	App\Locale\Service\LocaleService->getCurrentCountry (line 33)
10	App\Shop\Price\Service\CurrencyService->getCurrentCurrency (line 28)
11	App\Shop\Price\Event\Subscriber\RequestSubscriber->onKernelRequest (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.56 ms
(28.81%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.sign AS sign_3,
  t0.active AS active_4,
  t0.deleted_at AS deleted_at_5
FROM
  currency t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.sign AS sign_3, t0.active AS active_4, t0.deleted_at AS deleted_at_5 FROM currency t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Shop\Price\Entity\Currency::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Shop\Price\Entity\Currency->__get (line 56)
8	App\Shop\Price\Entity\Currency->getCode (line 63)
9	App\Shop\Price\Service\CurrencyService->saveUserCurrency (line 29)
10	App\Shop\Price\Event\Subscriber\RequestSubscriber->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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\Geo\Entity\Country	The association App\Geo\Entity\Country#paymentMethods refers to the owning side field App\Shop\Payment\Entity\PaymentMethod#country which does not exist. If association App\Geo\Entity\Country#currency is many-to-one, then the inversed side App\Shop\Price\Entity\Currency#countries has to be one-to-many.
App\Shop\Price\Entity\Currency	No errors.
App\Shop\Payment\Entity\PaymentMethod	The mappings App\Shop\Payment\Entity\PaymentMethod#countries and App\Geo\Entity\Country#paymentMethods are inconsistent with each other.
App\Geo\Entity\CountryTranslation	No errors.

Symfony Profiler

GET https://dev.front.garmon.io/_profiler

Configuration Settings

Theme