Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

126.40 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

54.71 ms
(43.28%)

SELECT COUNT(o0_.id) AS sclr_0, MIN(o0_.price) AS sclr_1, MAX(o0_.price) AS sclr_2, MIN(o0_.year) AS sclr_3, MAX(o0_.year) AS sclr_4, MIN(o0_.engine_displacement) AS sclr_5, MAX(o0_.engine_displacement) AS sclr_6, MIN(o0_.date_offer) AS sclr_7, MAX(o0_.date_offer) AS sclr_8, MIN(o0_.mileage) AS sclr_9, MAX(o0_.mileage) AS sclr_10 FROM offer o0_ WHERE o0_.trading_platform_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(o0_.id) AS sclr_0,
  MIN(o0_.price) AS sclr_1,
  MAX(o0_.price) AS sclr_2,
  MIN(o0_.year) AS sclr_3,
  MAX(o0_.year) AS sclr_4,
  MIN(o0_.engine_displacement) AS sclr_5,
  MAX(o0_.engine_displacement) AS sclr_6,
  MIN(o0_.date_offer) AS sclr_7,
  MAX(o0_.date_offer) AS sclr_8,
  MIN(o0_.mileage) AS sclr_9,
  MAX(o0_.mileage) AS sclr_10
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?

SELECT COUNT(o0_.id) AS sclr_0, MIN(o0_.price) AS sclr_1, MAX(o0_.price) AS sclr_2, MIN(o0_.year) AS sclr_3, MAX(o0_.year) AS sclr_4, MIN(o0_.engine_displacement) AS sclr_5, MAX(o0_.engine_displacement) AS sclr_6, MIN(o0_.date_offer) AS sclr_7, MAX(o0_.date_offer) AS sclr_8, MIN(o0_.mileage) AS sclr_9, MAX(o0_.mileage) AS sclr_10 FROM offer o0_ WHERE o0_.trading_platform_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\Vehicle->getFilters (line 574)
7	App\Controller\ApiController->getFilters (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

14.41 ms
(11.40%)

SELECT DISTINCT o0_.transmission_type AS transmission_type_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.transmission_type AS transmission_type_0
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?

SELECT DISTINCT o0_.transmission_type AS transmission_type_0 FROM offer o0_ WHERE o0_.trading_platform_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\Vehicle->getFilters (line 580)
7	App\Controller\ApiController->getFilters (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

13.94 ms
(11.03%)

SELECT DISTINCT o0_.engine_type AS engine_type_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.engine_type AS engine_type_0
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?

SELECT DISTINCT o0_.engine_type AS engine_type_0 FROM offer o0_ WHERE o0_.trading_platform_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\Vehicle->getFilters (line 580)
7	App\Controller\ApiController->getFilters (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

13.92 ms
(11.01%)

SELECT DISTINCT o0_.configuration AS configuration_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.configuration AS configuration_0
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?

SELECT DISTINCT o0_.configuration AS configuration_0 FROM offer o0_ WHERE o0_.trading_platform_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\Vehicle->getFilters (line 580)
7	App\Controller\ApiController->getFilters (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

13.84 ms
(10.95%)

SELECT DISTINCT o0_.color AS color_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.color AS color_0
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?

SELECT DISTINCT o0_.color AS color_0 FROM offer o0_ WHERE o0_.trading_platform_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\Vehicle->getFilters (line 580)
7	App\Controller\ApiController->getFilters (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

13.74 ms
(10.87%)

SELECT DISTINCT o0_.generation AS generation_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.generation AS generation_0
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?

SELECT DISTINCT o0_.generation AS generation_0 FROM offer o0_ WHERE o0_.trading_platform_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Service\Vehicle->getFilters (line 580)
7	App\Controller\ApiController->getFilters (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.84 ms
(1.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.language AS language_4, t0.comment AS comment_5, t0.code AS code_6 FROM trading_platform t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "encar"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.language AS language_4,
  t0.comment AS comment_5,
  t0.code AS code_6
FROM
  trading_platform t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.language AS language_4, t0.comment AS comment_5, t0.code AS code_6 FROM trading_platform t0 WHERE t0.code = 'encar' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Service\Vehicle->getTradingPlatform (line 411)
5	App\Controller\ApiController->getFilters (line 262)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\TradingPlatform	1

Entities Mapping

Class	Mapping errors
App\Entity\TradingPlatform	No errors.
App\Entity\MarkOrigin	No errors.
App\Entity\BodyOrigin	No errors.
App\Entity\ModelOrigin	No errors.
App\Entity\Offer	No errors.

Symfony Profiler

GET https://api.jplife.ru/api/v1/filters/encar

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping