GET https://tcc.se-ck.de/en/fahrzeuge/detail/13

Query Metrics

15 Database Queries
15 Different statements
22.18 ms Query time
0 Invalid entities
17 Managed entities

Queries

Group similar statements

# Time Info
1 1.17 ms
SELECT t0.id AS id_1, t0.construction_year AS construction_year_2, t0.labeling AS labeling_3, t0.article_number AS article_number_4, t0.purchased_at AS purchased_at_5, t0.storage_location AS storage_location_6, t0.condition_rating AS condition_rating_7, t0.approved AS approved_8, t0.visible AS visible_9, t0.status AS status_10, t0.description AS description_11, t0.brand_id AS brand_id_12, t0.design_type_id AS design_type_id_13, t0.bottom_embossing_id AS bottom_embossing_id_14, t0.type_id AS type_id_15, t0.tire_type_id AS tire_type_id_16, t0.scale_id AS scale_id_17, t0.series_id AS series_id_18, t0.manufacturer_id AS manufacturer_id_19, t0.category_id AS category_id_20 FROM vehicle t0 WHERE t0.id = ?
Parameters:
[
  13
]
2 0.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.95 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.id = ?
Parameters:
[
  10
]
4 5.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_original AS name_original_3, t0.mime_type AS mime_type_4, t0.path AS path_5, t0.path_base AS path_base_6, t0.category AS category_7, t0.vehicle_id AS vehicle_id_8, t0.article_id AS article_id_9 FROM file t0 WHERE t0.vehicle_id = ? ORDER BY t0.name_original ASC
Parameters:
[
  13
]
5 0.96 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 1.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM design_type t0 WHERE t0.id = ?
Parameters:
[
  5
]
7 1.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 1.12 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 1.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM bottom_embossing t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tire_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 1.30 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM color t0 INNER JOIN vehicle_color_body ON t0.id = vehicle_color_body.color_id WHERE vehicle_color_body.vehicle_id = ?
Parameters:
[
  13
]
13 1.24 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM color t0 INNER JOIN vehicle_color_interior ON t0.id = vehicle_color_interior.color_id WHERE vehicle_color_interior.vehicle_id = ?
Parameters:
[
  13
]
14 1.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM color t0 INNER JOIN vehicle_color_chassis ON t0.id = vehicle_color_chassis.color_id WHERE vehicle_color_chassis.vehicle_id = ?
Parameters:
[
  13
]
15 1.23 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM color t0 INNER JOIN vehicle_color_glazing ON t0.id = vehicle_color_glazing.color_id WHERE vehicle_color_glazing.vehicle_id = ?
Parameters:
[
  13
]

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\Color 4
App\Entity\File 3
App\Entity\Vehicle 1
App\Entity\Brand 1
App\Entity\DesignType 1
App\Entity\BottomEmbossing 1
App\Entity\Type 1
App\Entity\TireType 1
App\Entity\Scale 1
App\Entity\Series 1
App\Entity\Manufacturer 1
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\Vehicle No errors.
App\Entity\Brand No errors.
App\Entity\DesignType No errors.
App\Entity\BottomEmbossing No errors.
App\Entity\Type No errors.
App\Entity\TireType No errors.
App\Entity\Scale No errors.
App\Entity\Series No errors.
App\Entity\Manufacturer No errors.
App\Entity\Category No errors.
App\Entity\Color No errors.
App\Entity\File No errors.
App\Entity\Article No errors.