Symfony Profiler

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 = '4-matchbox' 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 type t0 WHERE t0.slug = '404-944-turbo' LIMIT 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

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM series t0 WHERE t0.slug = '20-world-class-series-2-row' 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 series s3_ ON (s3_.id = v1_.series_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND v1_.construction_year = ?
  AND m2_.slug = ?
  AND s3_.slug = ?
ORDER BY
  t0_.name ASC

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 series s3_ ON (s3_.id = v1_.series_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '1997' AND m2_.slug = '4-matchbox' AND s3_.slug = '20-world-class-series-2-row' ORDER BY t0_.name 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_.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 series s3_ ON v0_.series_id = s3_.id
WHERE
  v0_.construction_year = ?
  AND m1_.slug = ?
  AND t2_.slug = ?
  AND s3_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  t2_.name ASC
LIMIT
  20

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 series s3_ ON v0_.series_id = s3_.id WHERE v0_.construction_year = '1997' AND m1_.slug = '4-matchbox' AND t2_.slug = '404-944-turbo' AND s3_.slug = '20-world-class-series-2-row' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY t2_.name ASC LIMIT 20;

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)
  LEFT JOIN series s4_ ON (s4_.id = v1_.series_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND v1_.construction_year = ?
  AND m2_.slug = ?
  AND t3_.slug = ?
  AND s4_.slug = ?
ORDER BY
  s0_.name ASC

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) LEFT JOIN series s4_ ON (s4_.id = v1_.series_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '1997' AND m2_.slug = '4-matchbox' AND t3_.slug = '404-944-turbo' AND s4_.slug = '20-world-class-series-2-row' ORDER BY s0_.name ASC;

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 series s4_ ON (s4_.id = v1_.series_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND v1_.construction_year = ?
  AND m2_.slug = ?
  AND t3_.slug = ?
  AND s4_.slug = ?
ORDER BY
  d0_.name ASC

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 series s4_ ON (s4_.id = v1_.series_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '1997' AND m2_.slug = '4-matchbox' AND t3_.slug = '404-944-turbo' AND s4_.slug = '20-world-class-series-2-row' ORDER BY d0_.name ASC;

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 series s4_ ON (s4_.id = v1_.series_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND v1_.construction_year = ?
  AND m2_.slug = ?
  AND t3_.slug = ?
  AND s4_.slug = ?
ORDER BY
  b0_.name ASC

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 series s4_ ON (s4_.id = v1_.series_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '1997' AND m2_.slug = '4-matchbox' AND t3_.slug = '404-944-turbo' AND s4_.slug = '20-world-class-series-2-row' ORDER BY b0_.name ASC;

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 series s3_ ON (s3_.id = v0_.series_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 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 series s3_ ON (s3_.id = v0_.series_id) WHERE v0_.construction_year IS NOT NULL AND v0_.construction_year <> 0 AND v0_.status = 'collection' AND v0_.approved = 1 AND v0_.visible = 1 AND m1_.slug = '4-matchbox' AND t2_.slug = '404-944-turbo' AND s3_.slug = '20-world-class-series-2-row' GROUP BY v0_.construction_year ORDER BY v0_.construction_year ASC;

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)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND v1_.construction_year = ?
  AND m2_.slug = ?
  AND t3_.slug = ?
ORDER BY
  s0_.name ASC

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) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '1997' AND m2_.slug = '4-matchbox' AND t3_.slug = '404-944-turbo' ORDER BY s0_.name ASC;

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 series s3_ ON (s3_.id = v1_.series_id)
WHERE
  v1_.status = ?
  AND v1_.approved = ?
  AND v1_.visible = ?
  AND v1_.construction_year = ?
  AND t2_.slug = ?
  AND s3_.slug = ?
ORDER BY
  m0_.name ASC

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 series s3_ ON (s3_.id = v1_.series_id) WHERE v1_.status = 'collection' AND v1_.approved = 1 AND v1_.visible = 1 AND v1_.construction_year = '1997' AND t2_.slug = '404-944-turbo' AND s3_.slug = '20-world-class-series-2-row' ORDER BY m0_.name ASC;

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 series s3_ ON v0_.series_id = s3_.id
WHERE
  v0_.construction_year = ?
  AND m1_.slug = ?
  AND t2_.slug = ?
  AND s3_.slug = ?
  AND v0_.visible = ?
  AND v0_.status = ?
  AND v0_.approved = ?
ORDER BY
  t2_.name ASC

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 series s3_ ON v0_.series_id = s3_.id WHERE v0_.construction_year = '1997' AND m1_.slug = '4-matchbox' AND t2_.slug = '404-944-turbo' AND s3_.slug = '20-world-class-series-2-row' AND v0_.visible = 1 AND v0_.status = 'collection' AND v0_.approved = 1 ORDER BY t2_.name 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

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 = 1028 ORDER BY t0.name_original ASC;