Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 12
• Events
• Routing
• Cache
• Translation 27
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN manufacturer m1_ ON v0_.manufacturer_id = m1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id WHERE m1_.slug = ? AND d2_.slug = ? AND v0_.construction_year = ? AND s3_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY v0_.storage_location ASC

[
  "1-matchbox-rw"
  "4-kranwagen"
  "1969"
  "1-ohne-angabe"
  1
  "collection"
  1
]

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  vehicle v0_
  LEFT JOIN manufacturer m1_ ON v0_.manufacturer_id = m1_.id
  LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id
  LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id
WHERE
  m1_.slug = ?
  AND d2_.slug = ?
  AND v0_.construction_year = ?
  AND s3_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  v0_.storage_location ASC

SELECT COUNT(v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN manufacturer m1_ ON v0_.manufacturer_id = m1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id WHERE m1_.slug = '1-matchbox-rw' AND d2_.slug = '4-kranwagen' AND v0_.construction_year = '1969' AND s3_.slug = '1-ohne-angabe' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY v0_.storage_location ASC;

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 manufacturer m1_ ON v0_.manufacturer_id = m1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id WHERE m1_.slug = ? AND d2_.slug = ? AND v0_.construction_year = ? AND s3_.slug = ? AND v0_.visible = ? AND v0_.status = ? AND v0_.approved = ? ORDER BY v0_.storage_location ASC LIMIT 50

[
  "1-matchbox-rw"
  "4-kranwagen"
  "1969"
  "1-ohne-angabe"
  1
  "collection"
  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 manufacturer m1_ ON v0_.manufacturer_id = m1_.id
  LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id
  LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id
WHERE
  m1_.slug = ?
  AND d2_.slug = ?
  AND v0_.construction_year = ?
  AND s3_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  v0_.storage_location ASC
LIMIT
  50

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 manufacturer m1_ ON v0_.manufacturer_id = m1_.id LEFT JOIN design_type d2_ ON v0_.design_type_id = d2_.id LEFT JOIN scale s3_ ON v0_.scale_id = s3_.id WHERE m1_.slug = '1-matchbox-rw' AND d2_.slug = '4-kranwagen' AND v0_.construction_year = '1969' AND s3_.slug = '1-ohne-angabe' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY v0_.storage_location ASC LIMIT 50;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM manufacturer t0 WHERE t0.slug = ? LIMIT 1

[
  "1-matchbox-rw"
]

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 manufacturer t0 WHERE t0.slug = '1-matchbox-rw' 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

[
  "136-evening-news-v…"
]

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 type t0 WHERE t0.slug = '136-evening-news-v…' 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

[
  "1-ohne-angabe"
]

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.slug AS slug_3 FROM scale t0 WHERE t0.slug = '1-ohne-angabe' LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM design_type t0 WHERE t0.slug = ? LIMIT 1

[
  "4-kranwagen"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  design_type t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM design_type t0 WHERE t0.slug = '4-kranwagen' LIMIT 1;