Symfony Profiler

Query Metrics

35 Database Queries

13 Different statements

114.28 ms Query time

0 Invalid entities

162 Managed entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 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_.brand_id AS brand_id_11, v0_.design_type_id AS design_type_id_12, v0_.bottom_embossing_id AS bottom_embossing_id_13, v0_.type_id AS type_id_14, v0_.tire_type_id AS tire_type_id_15, v0_.scale_id AS scale_id_16, v0_.series_id AS series_id_17, v0_.manufacturer_id AS manufacturer_id_18, v0_.category_id AS category_id_19 FROM vehicle v0_ LEFT JOIN manufacturer m1_ ON v0_.manufacturer_id = m1_.id LEFT JOIN type t2_ ON v0_.type_id = t2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id LEFT JOIN series s4_ ON v0_.series_id = s4_.id WHERE m1_.slug = ? AND t2_.slug = ? AND s3_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY s4_.name ASC LIMIT 20
SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN manufacturer m1_ ON v0_.manufacturer_id = m1_.id LEFT JOIN type t2_ ON v0_.type_id = t2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id LEFT JOIN series s4_ ON v0_.series_id = s4_.id WHERE m1_.slug = ? AND t2_.slug = ? AND s3_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY s4_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2 FROM brand b0_ LEFT JOIN vehicle v1_ ON (v1_.brand_id = b0_.id) LEFT JOIN manufacturer m2_ ON (m2_.id = v1_.manufacturer_id) LEFT JOIN type t3_ ON (t3_.id = v1_.type_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND m2_.slug = ? AND t3_.slug = ? AND s4_.slug = ? ORDER BY b0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM type t0_ LEFT JOIN vehicle v1_ ON (v1_.type_id = t0_.id) LEFT JOIN manufacturer m2_ ON (m2_.id = v1_.manufacturer_id) LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND m2_.slug = ? AND s3_.slug = ? ORDER BY t0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 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
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2 FROM manufacturer m0_ LEFT JOIN vehicle v1_ ON (v1_.manufacturer_id = m0_.id) LEFT JOIN type t2_ ON (t2_.id = v1_.type_id) LEFT JOIN scale s3_ ON (s3_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND t2_.slug = ? AND s3_.slug = ? ORDER BY m0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM design_type d0_ LEFT JOIN vehicle v1_ ON (v1_.design_type_id = d0_.id) LEFT JOIN manufacturer m2_ ON (m2_.id = v1_.manufacturer_id) LEFT JOIN type t3_ ON (t3_.id = v1_.type_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND m2_.slug = ? AND t3_.slug = ? AND s4_.slug = ? ORDER BY d0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM scale s0_ LEFT JOIN vehicle v1_ ON (v1_.scale_id = s0_.id) LEFT JOIN manufacturer m2_ ON (m2_.id = v1_.manufacturer_id) LEFT JOIN type t3_ ON (t3_.id = v1_.type_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND m2_.slug = ? AND t3_.slug = ? ORDER BY s0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM series s0_ LEFT JOIN vehicle v1_ ON (v1_.series_id = s0_.id) LEFT JOIN manufacturer m2_ ON (m2_.id = v1_.manufacturer_id) LEFT JOIN type t3_ ON (t3_.id = v1_.type_id) LEFT JOIN scale s4_ ON (s4_.id = v1_.scale_id) WHERE v1_.status = ? AND v1_.approved = ? AND v1_.visible = ? AND m2_.slug = ? AND t3_.slug = ? AND s4_.slug = ? ORDER BY s0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM scale t0 WHERE t0.slug = ? LIMIT 1
SELECT v0_.construction_year AS construction_year_0 FROM vehicle v0_ LEFT JOIN manufacturer m1_ ON (m1_.id = v0_.manufacturer_id) LEFT JOIN type t2_ ON (t2_.id = v0_.type_id) LEFT JOIN scale s3_ ON (s3_.id = v0_.scale_id) WHERE v0_.construction_year IS NOT NULL AND v0_.construction_year <> 0 AND v0_.status = ? AND v0_.approved = ? AND v0_.visible = ? AND m1_.slug = ? AND t2_.slug = ? AND s3_.slug = ? GROUP BY v0_.construction_year ORDER BY v0_.construction_year ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM type t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 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
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
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

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

Entities Mapping

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

Symfony Profiler

GET https://tcc.se-ck.de/en/vehicles/hersteller/1-matchbox-rw/sortierung/serie/modell/77-trader-wreck-truck/ma%C3%9Fstab/1-ohne-angabe

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping