Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

6.82 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.97 ms

SELECT DISTINCT s0_.id AS id_0, s0_.vendor AS vendor_1, s0_.model_seria AS model_seria_2, s0_.car AS car_3, s0_.year AS year_4, s0_.modification AS modification_5, s0_.param_pcd AS param_pcd_6, s0_.param_dia AS param_dia_7, s0_.param_nut AS param_nut_8, s0_.param_bolt AS param_bolt_9, s0_.tyres_factory AS tyres_factory_10, s0_.tyres_replace AS tyres_replace_11, s0_.tyres_tuning AS tyres_tuning_12, s0_.wheels_factory AS wheels_factory_13, s0_.wheels_replace AS wheels_replace_14, s0_.wheels_tuning AS wheels_tuning_15 FROM search_by_vehicle s0_ WHERE s0_.vendor = ? AND s0_.car = ? AND s0_.year = ? AND s0_.modification = ?

Parameters:

[
  "BMW"
  "X5 (F15)"
  "2013"
  "330ci / 330d / 330i / 330xd %2…"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.vendor AS vendor_1,
  s0_.model_seria AS model_seria_2,
  s0_.car AS car_3,
  s0_.year AS year_4,
  s0_.modification AS modification_5,
  s0_.param_pcd AS param_pcd_6,
  s0_.param_dia AS param_dia_7,
  s0_.param_nut AS param_nut_8,
  s0_.param_bolt AS param_bolt_9,
  s0_.tyres_factory AS tyres_factory_10,
  s0_.tyres_replace AS tyres_replace_11,
  s0_.tyres_tuning AS tyres_tuning_12,
  s0_.wheels_factory AS wheels_factory_13,
  s0_.wheels_replace AS wheels_replace_14,
  s0_.wheels_tuning AS wheels_tuning_15
FROM
  search_by_vehicle s0_
WHERE
  s0_.vendor = ?
  AND s0_.car = ?
  AND s0_.year = ?
  AND s0_.modification = ?

SELECT DISTINCT s0_.id AS id_0, s0_.vendor AS vendor_1, s0_.model_seria AS model_seria_2, s0_.car AS car_3, s0_.year AS year_4, s0_.modification AS modification_5, s0_.param_pcd AS param_pcd_6, s0_.param_dia AS param_dia_7, s0_.param_nut AS param_nut_8, s0_.param_bolt AS param_bolt_9, s0_.tyres_factory AS tyres_factory_10, s0_.tyres_replace AS tyres_replace_11, s0_.tyres_tuning AS tyres_tuning_12, s0_.wheels_factory AS wheels_factory_13, s0_.wheels_replace AS wheels_replace_14, s0_.wheels_tuning AS wheels_tuning_15 FROM search_by_vehicle s0_ WHERE s0_.vendor = 'BMW' AND s0_.car = 'X5 (F15)' AND s0_.year = '2013' AND s0_.modification = '330ci / 330d / 330i / 330xd %2…';

#	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 98)
7	App\Repository\SearchByVehicleRepository->getTiresDisks (line 635)
8	App\Controller\MainController->car_filter (line 861)
9	App\Controller\MainController->brandauto (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

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

[
  "otradny"
]

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 = 'otradny' 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	ContainerJvrhMxj\App_KernelDevDebugContainer::getTwigService (line 598)
7	ContainerJvrhMxj\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1774)
8	ContainerJvrhMxj\App_KernelDevDebugContainer::getProfilerListenerService (line 877)
9	ContainerJvrhMxj\App_KernelDevDebugContainer::ContainerJvrhMxj\{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 236)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

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

[
  "otradny"
]

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 = 'otradny' 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	ContainerJvrhMxj\App_KernelDevDebugContainer::getTwigService (line 598)
7	ContainerJvrhMxj\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1774)
8	ContainerJvrhMxj\App_KernelDevDebugContainer::getProfilerListenerService (line 877)
9	ContainerJvrhMxj\App_KernelDevDebugContainer::ContainerJvrhMxj\{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 236)
14	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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\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.
App\Entity\Rest	No errors.
App\Entity\OrderStatus	No errors.

Symfony Profiler

GET https://otradny.test.kolex.ru/brandautodisk?brand=BMW&engine=330ci%20%2F%20330d%20%2F%20330i%20%2F%20330xd%20%252%E2%80%A6&model=X5%20%28F15%29&year=2013

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping