GET https://api.jplife.ru/api/v1/models/encar?mark=BYD

Query Metrics

3 Database Queries
3 Different statements
6.33 ms Query time
0 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.36 ms
(37.34%)
1
SELECT m0_.name AS name_0, m0_.name_origin AS name_origin_1, m1_.name AS name_2 FROM model_origin m0_ LEFT JOIN model m1_ ON (m1_.id = m0_.model_id) WHERE m0_.trading_platform_id = ? AND m0_.mark_origin_id = ?
Parameters:
[
  2
  279
]
2.26 ms
(35.70%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.name_origin AS name_origin_2, m0_.mark_inner_id AS mark_inner_id_3, m0_.mark_inner_str AS mark_inner_str_4, m0_.mark_origin_extra AS mark_origin_extra_5, m0_.trading_platform_id AS trading_platform_id_6, m0_.mark_id AS mark_id_7 FROM mark_origin m0_ WHERE m0_.trading_platform_id = ? AND ((LOWER(m0_.name_origin) = LOWER(?) OR LOWER(m0_.name) = LOWER(?)))
Parameters:
[
  2
  "BYD"
  "BYD"
]
1.71 ms
(26.96%)
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 = ? LIMIT 1
Parameters:
[
  "encar"
]

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
App\Entity\MarkOrigin 1
App\Entity\Mark 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.
App\Entity\Mark No errors.
App\Entity\Model No errors.