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

Query Metrics

7 Database Queries
7 Different statements
127.88 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 1.41 ms
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:
[
  "dongchedi"
]
2 53.91 ms
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:
[
  1
]
3 13.99 ms
SELECT DISTINCT o0_.generation AS generation_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?
Parameters:
[
  1
]
4 14.82 ms
SELECT DISTINCT o0_.configuration AS configuration_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?
Parameters:
[
  1
]
5 14.44 ms
SELECT DISTINCT o0_.color AS color_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?
Parameters:
[
  1
]
6 14.47 ms
SELECT DISTINCT o0_.engine_type AS engine_type_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?
Parameters:
[
  1
]
7 14.85 ms
SELECT DISTINCT o0_.transmission_type AS transmission_type_0 FROM offer o0_ WHERE o0_.trading_platform_id = ?
Parameters:
[
  1
]

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.