Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.66 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.66 ms

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.enable AS enable_4, c0_.code AS code_5, c0_.commission AS commission_6, c0_.deleted_at AS deleted_at_7, c0_.currency_id AS currency_id_8 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_.enable AS enable_4,
  c0_.code AS code_5,
  c0_.commission AS commission_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.currency_id AS currency_id_8
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_.enable AS enable_4, c0_.code AS code_5, c0_.commission AS commission_6, c0_.deleted_at AS deleted_at_7, c0_.currency_id AS currency_id_8 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 48)
7	App\Geo\Repository\CountryRepository->findOneByCode (line 29)
8	App\Geo\Service\CountryService->getCountry (line 34)
9	App\Locale\Event\Subscriber\RequestSubscriber->onKernelRequest (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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	If association App\Geo\Entity\Country#currency is many-to-one, then the inversed side App\Price\Entity\Currency#countries has to be one-to-many.
App\Price\Entity\Currency	No errors.
App\Geo\Entity\City	No errors.
App\Geo\Entity\CountryRequisite	No errors.
App\Geo\Entity\CountryTranslation	No errors.

Symfony Profiler

GET https://dev.back.garmon.io/api/event/events/?limit=10&offset=0

Configuration Settings

Theme