GET https://tcc.se-ck.de/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFrontendController%253A%253Aheader

Response
200 OK
IP
192.168.240.1
Profiled on
Token
8f7b2f

Query Metrics

6 Database Queries
6 Different statements
39.39 ms Query time
0 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
17.37 ms
(44.09%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM brand t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "4-un…"
]
View formatted query    View runnable query    Explain query    View query backtrace
13.50 ms
(34.27%) 		1 
SELECT v0_.id AS id_0, v0_.construction_year AS construction_year_1, v0_.labeling AS labeling_2, v0_.article_number AS article_number_3, v0_.purchased_at AS purchased_at_4, v0_.storage_location AS storage_location_5, v0_.condition_rating AS condition_rating_6, v0_.approved AS approved_7, v0_.visible AS visible_8, v0_.status AS status_9, v0_.description AS description_10, v0_.description_extra AS description_extra_11, v0_.brand_id AS brand_id_12, v0_.design_type_id AS design_type_id_13, v0_.bottom_embossing_id AS bottom_embossing_id_14, v0_.type_id AS type_id_15, v0_.tire_type_id AS tire_type_id_16, v0_.scale_id AS scale_id_17, v0_.series_id AS series_id_18, v0_.manufacturer_id AS manufacturer_id_19, v0_.category_id AS category_id_20 FROM vehicle v0_ LEFT JOIN scale s1_ ON v0_.scale_id = s1_.id LEFT JOIN series s2_ ON v0_.series_id = s2_.id LEFT JOIN design_type d3_ ON v0_.design_type_id = d3_.id WHERE s1_.slug = ? AND s2_.slug = ? AND v0_.construction_year = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY d3_.name ASC LIMIT 50
Parameters: 
[
  "34-1-54"
  "208-street-cars-series"
  "2021"
  1
  "collection"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4.27 ms
(10.85%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "208-street-cars-series"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.89 ms
(4.79%) 		1 
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN scale s1_ ON v0_.scale_id = s1_.id LEFT JOIN series s2_ ON v0_.series_id = s2_.id LEFT JOIN design_type d3_ ON v0_.design_type_id = d3_.id WHERE s1_.slug = ? AND s2_.slug = ? AND v0_.construction_year = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY d3_.name ASC
Parameters: 
[
  "34-1-54"
  "208-street-cars-series"
  "2021"
  1
  "collection"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.26 ms
(3.20%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "136-evening-news-v…"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(2.80%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "34-1-54"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\Scale 1
App\Entity\Series 1
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\Manufacturer 1
App\Entity\Category 1

Entities Mapping

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