Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.81 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.96 ms
(53.15%)

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_.active = ?) AND (c0_.deleted_at IS NULL)

Parameters:

[
  1
]

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_.active = ?)
  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_.active = 1) 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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 27)
7	App\Geo\Repository\CountryRepository->findActive (line 76)
8	App\Twig\SiteExtension->getGlobals (line 331)
9	Twig\ExtensionSet->getGlobals (line 788)
10	Twig\Environment->getGlobals (line 801)
11	Twig\Environment->mergeGlobals (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 40)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
18	App\Security\Controller\User\AuthController->user_login (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.85 ms
(46.85%)

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/ru/auth/user/login

Configuration Settings

Theme