Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

10.83 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

9.61 ms

SELECT DISTINCT s0_.modification AS modification_0 FROM search_by_vehicle s0_ WHERE s0_.vendor = ? AND s0_.car = ? AND s0_.year = ? ORDER BY s0_.modification ASC

Parameters:

[
  "ВАЗ"
  "2101-2107"
  "1991"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.modification AS modification_0
FROM
  search_by_vehicle s0_
WHERE
  s0_.vendor = ?
  AND s0_.car = ?
  AND s0_.year = ?
ORDER BY
  s0_.modification ASC

SELECT DISTINCT s0_.modification AS modification_0 FROM search_by_vehicle s0_ WHERE s0_.vendor = 'ВАЗ' AND s0_.car = '2101-2107' AND s0_.year = '1991' ORDER BY s0_.modification ASC;

#	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 925)
6	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 81)
7	App\Repository\SearchByVehicleRepository->getEnginesByBrandModelYearSorted (line 863)
8	App\Controller\MainController->brandauto (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.58 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:

[
  "tolyatti"
]

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 = 'tolyatti' 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 389)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 431)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 875)
12	App\Controller\MainController->brandauto (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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:

[
  "tolyatti"
]

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 = 'tolyatti' 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 389)
7	Symfony\Component\DependencyInjection\Container->getService (line 40)
8	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 431)
9	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 875)
12	App\Controller\MainController->brandauto (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.40 ms

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.town AS town_1,
  t0_.name AS name_2,
  t0_.seo_name AS seo_name_3
FROM
  town t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC;

#	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 76)
7	App\Service\Kolex->getTowns (line 1635)
8	twig_get_attribute (line 54)
9	__TwigTemplate_af3255f4a26e139158aac2b1209ce55b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 99)
12	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->block_body (line 171)
13	Twig\Template->displayBlock (line 151)
14	__TwigTemplate_9ef0bb04516dbab8b4b6128433c217b8->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 50)
17	__TwigTemplate_e23eb1d5653c090c3dd47e0d400a3f19->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 49)
20	__TwigTemplate_2fd68ccc15e9c1f3bdc4542fb0cbe629->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 875)
29	App\Controller\MainController->brandauto (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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\Entity\Product	No errors.
App\Entity\Tire	No errors.
App\Entity\Disk	No errors.
App\Entity\Order	No errors.
App\Entity\SearchByVehicle	No errors.
App\Entity\Town	No errors.

Symfony Profiler

GET https://tolyatti.stokuznecov.ru/brandauto?brand=%D0%92%D0%90%D0%97&model=2101-2107&year=1991

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping