Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

5.57 ms Query time

0 Invalid entities

0 Managed entities

#▲

Time

Info

5.57 ms

SELECT DISTINCT l.code AS language, l.name AS name FROM languages l WHERE l.status = ? ORDER BY l.code ASC

Parameters:

[
  "STATUS_ACTIVE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT l.code AS language,
  l.name AS name
FROM
  languages l
WHERE
  l.status = ?
ORDER BY
  l.code ASC

SELECT DISTINCT l.code AS language, l.name AS name FROM languages l WHERE l.status = 'STATUS_ACTIVE' ORDER BY l.code ASC;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 274)
3	App\Domain\Language\Query\FindCode\Fetcher->fetch (line 39)
4	App\EventListener\UserLocaleListener->getAvailableLocales (line 18)
5	App\EventListener\UserLocaleListener->onKernelRequest (line 33)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects

Class	Mapping errors
App\Domain\TelegramUser\Entity\TelegramUser	No errors.
App\Domain\Common\Entity\Embeddable\FullName	No errors.
App\Domain\Common\Entity\Embeddable\Taxation	No errors.
App\Domain\User\Entity\User	No errors.