Symfony Profiler

Query Metrics

2 Database Queries

1 Different statements

1.88 ms Query time

0 Invalid entities

#▲

Time

Info

1.64 ms

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = ? LIMIT 1

Parameters:

[
  "nsk"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'nsk' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 41)
4	App\EnvironmentProcessors\KolexTownProcessor->getEnv (line 368)
5	Symfony\Component\DependencyInjection\Container->getEnv (line 2200)
6	ContainerG0Am81P\App_KernelDevDebugContainer::getTwigService (line 598)
7	ContainerG0Am81P\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1774)
8	ContainerG0Am81P\App_KernelDevDebugContainer::getProfilerListenerService (line 876)
9	ContainerG0Am81P\App_KernelDevDebugContainer::ContainerG0Am81P\{closure} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 257)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 121)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.24 ms

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = ? LIMIT 1

Parameters:

[
  "nsk"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'nsk' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 41)
4	App\EnvironmentProcessors\KolexTownProcessor->getEnv (line 368)
5	Symfony\Component\DependencyInjection\Container->getEnv (line 2201)
6	ContainerG0Am81P\App_KernelDevDebugContainer::getTwigService (line 598)
7	ContainerG0Am81P\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1774)
8	ContainerG0Am81P\App_KernelDevDebugContainer::getProfilerListenerService (line 876)
9	ContainerG0Am81P\App_KernelDevDebugContainer::ContainerG0Am81P\{closure} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 257)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 121)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 211)
14	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 199)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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.