Symfony Profiler

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  vehicle v0_
  LEFT JOIN vehicle_model v1_ ON v0_.vehicle_model_id = v1_.id
  LEFT JOIN brand b2_ ON v1_.brand_id = b2_.id
  LEFT JOIN model m3_ ON v1_.model_id = m3_.id
  LEFT JOIN body_type b4_ ON v1_.body_type_id = b4_.id
  LEFT JOIN fuel_type f5_ ON v1_.fuel_type_id = f5_.id

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN vehicle_model v1_ ON v0_.vehicle_model_id = v1_.id LEFT JOIN brand b2_ ON v1_.brand_id = b2_.id LEFT JOIN model m3_ ON v1_.model_id = m3_.id LEFT JOIN body_type b4_ ON v1_.body_type_id = b4_.id LEFT JOIN fuel_type f5_ ON v1_.fuel_type_id = f5_.id;

SELECT
  DISTINCT v0_.id AS id_0,
  b1_.name AS name_1
FROM
  vehicle v0_
  LEFT JOIN vehicle_model v2_ ON v0_.vehicle_model_id = v2_.id
  LEFT JOIN brand b1_ ON v2_.brand_id = b1_.id
  LEFT JOIN model m3_ ON v2_.model_id = m3_.id
  LEFT JOIN body_type b4_ ON v2_.body_type_id = b4_.id
  LEFT JOIN fuel_type f5_ ON v2_.fuel_type_id = f5_.id
ORDER BY
  b1_.name ASC
LIMIT
  12

SELECT DISTINCT v0_.id AS id_0, b1_.name AS name_1 FROM vehicle v0_ LEFT JOIN vehicle_model v2_ ON v0_.vehicle_model_id = v2_.id LEFT JOIN brand b1_ ON v2_.brand_id = b1_.id LEFT JOIN model m3_ ON v2_.model_id = m3_.id LEFT JOIN body_type b4_ ON v2_.body_type_id = b4_.id LEFT JOIN fuel_type f5_ ON v2_.fuel_type_id = f5_.id ORDER BY b1_.name ASC LIMIT 12;

SELECT
  v0_.id AS id_0,
  v0_.status AS status_1,
  v0_.usage_type AS usage_type_2,
  v0_.first_registration_date AS first_registration_date_3,
  v0_.mileage AS mileage_4,
  v0_.price AS price_5,
  v0_.vin AS vin_6,
  v0_.registration_number AS registration_number_7,
  v0_.is_featured AS is_featured_8,
  v0_.created_at AS created_at_9,
  v0_.updated_at AS updated_at_10,
  v1_.id AS id_11,
  v1_.euro_norm AS euro_norm_12,
  v1_.power_hp AS power_hp_13,
  v1_.power_fiscal AS power_fiscal_14,
  v1_.consumption AS consumption_15,
  v1_.co2 AS co2_16,
  v1_.cnit AS cnit_17,
  v1_.utac_code AS utac_code_18,
  v1_.homologation_date AS homologation_date_19,
  v1_.mass_min AS mass_min_20,
  v1_.mass_max AS mass_max_21,
  b2_.id AS id_22,
  b2_.name AS name_23,
  m3_.id AS id_24,
  m3_.name AS name_25,
  b4_.id AS id_26,
  b4_.name AS name_27,
  b4_.slug AS slug_28,
  b4_.position AS position_29,
  b4_.icon AS icon_30,
  f5_.id AS id_31,
  f5_.name AS name_32,
  v0_.vehicle_model_id AS vehicle_model_id_33,
  v0_.fuel_type_id AS fuel_type_id_34,
  v0_.gear_type_id AS gear_type_id_35,
  v0_.color_id AS color_id_36,
  v0_.supplier_id AS supplier_id_37,
  v1_.brand_id AS brand_id_38,
  v1_.model_id AS model_id_39,
  v1_.variant_id AS variant_id_40,
  v1_.fuel_type_id AS fuel_type_id_41,
  v1_.gear_type_id AS gear_type_id_42,
  v1_.body_type_id AS body_type_id_43,
  m3_.brand_id AS brand_id_44
FROM
  vehicle v0_
  LEFT JOIN vehicle_model v1_ ON v0_.vehicle_model_id = v1_.id
  LEFT JOIN brand b2_ ON v1_.brand_id = b2_.id
  LEFT JOIN model m3_ ON v1_.model_id = m3_.id
  LEFT JOIN body_type b4_ ON v1_.body_type_id = b4_.id
  LEFT JOIN fuel_type f5_ ON v1_.fuel_type_id = f5_.id
WHERE
  v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b2_.name ASC

SELECT v0_.id AS id_0, v0_.status AS status_1, v0_.usage_type AS usage_type_2, v0_.first_registration_date AS first_registration_date_3, v0_.mileage AS mileage_4, v0_.price AS price_5, v0_.vin AS vin_6, v0_.registration_number AS registration_number_7, v0_.is_featured AS is_featured_8, v0_.created_at AS created_at_9, v0_.updated_at AS updated_at_10, v1_.id AS id_11, v1_.euro_norm AS euro_norm_12, v1_.power_hp AS power_hp_13, v1_.power_fiscal AS power_fiscal_14, v1_.consumption AS consumption_15, v1_.co2 AS co2_16, v1_.cnit AS cnit_17, v1_.utac_code AS utac_code_18, v1_.homologation_date AS homologation_date_19, v1_.mass_min AS mass_min_20, v1_.mass_max AS mass_max_21, b2_.id AS id_22, b2_.name AS name_23, m3_.id AS id_24, m3_.name AS name_25, b4_.id AS id_26, b4_.name AS name_27, b4_.slug AS slug_28, b4_.position AS position_29, b4_.icon AS icon_30, f5_.id AS id_31, f5_.name AS name_32, v0_.vehicle_model_id AS vehicle_model_id_33, v0_.fuel_type_id AS fuel_type_id_34, v0_.gear_type_id AS gear_type_id_35, v0_.color_id AS color_id_36, v0_.supplier_id AS supplier_id_37, v1_.brand_id AS brand_id_38, v1_.model_id AS model_id_39, v1_.variant_id AS variant_id_40, v1_.fuel_type_id AS fuel_type_id_41, v1_.gear_type_id AS gear_type_id_42, v1_.body_type_id AS body_type_id_43, m3_.brand_id AS brand_id_44 FROM vehicle v0_ LEFT JOIN vehicle_model v1_ ON v0_.vehicle_model_id = v1_.id LEFT JOIN brand b2_ ON v1_.brand_id = b2_.id LEFT JOIN model m3_ ON v1_.model_id = m3_.id LEFT JOIN body_type b4_ ON v1_.body_type_id = b4_.id LEFT JOIN fuel_type f5_ ON v1_.fuel_type_id = f5_.id WHERE v0_.id IN (189, 235, 271, 296, 336, 417, 457, 32, 119, 127, 205, 303) ORDER BY b2_.name ASC;

SELECT
  MIN(v0_.first_registration_date) AS sclr_0,
  MAX(v0_.first_registration_date) AS sclr_1
FROM
  vehicle v0_

SELECT MIN(v0_.first_registration_date) AS sclr_0, MAX(v0_.first_registration_date) AS sclr_1 FROM vehicle v0_;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  brand b0_
WHERE
  EXISTS (
    SELECT
      1 AS sclr_2
    FROM
      vehicle v1_
      INNER JOIN vehicle_model v2_ ON v1_.vehicle_model_id = v2_.id
    WHERE
      v2_.brand_id = b0_.id
  )
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM brand b0_ WHERE EXISTS (SELECT 1 AS sclr_2 FROM vehicle v1_ INNER JOIN vehicle_model v2_ ON v1_.vehicle_model_id = v2_.id WHERE v2_.brand_id = b0_.id) ORDER BY b0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.position AS position_3,
  b0_.icon AS icon_4
FROM
  body_type b0_
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.position AS position_3, b0_.icon AS icon_4 FROM body_type b0_ ORDER BY b0_.name ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1
FROM
  fuel_type f0_
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1 FROM fuel_type f0_ ORDER BY f0_.name ASC;

SELECT
  MIN(v0_.price) AS sclr_0
FROM
  vehicle v0_

SELECT MIN(v0_.price) AS sclr_0 FROM vehicle v0_;

SELECT
  MAX(v0_.price) AS sclr_0
FROM
  vehicle v0_

SELECT MAX(v0_.price) AS sclr_0 FROM vehicle v0_;

SELECT
  MIN(v0_.first_registration_date) AS sclr_0,
  MAX(v0_.first_registration_date) AS sclr_1
FROM
  vehicle v0_

SELECT MIN(v0_.first_registration_date) AS sclr_0, MAX(v0_.first_registration_date) AS sclr_1 FROM vehicle v0_;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1
FROM
  brand b0_
WHERE
  EXISTS (
    SELECT
      1 AS sclr_2
    FROM
      vehicle v1_
      INNER JOIN vehicle_model v2_ ON v1_.vehicle_model_id = v2_.id
    WHERE
      v2_.brand_id = b0_.id
  )
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1 FROM brand b0_ WHERE EXISTS (SELECT 1 AS sclr_2 FROM vehicle v1_ INNER JOIN vehicle_model v2_ ON v1_.vehicle_model_id = v2_.id WHERE v2_.brand_id = b0_.id) ORDER BY b0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.position AS position_3,
  b0_.icon AS icon_4
FROM
  body_type b0_
ORDER BY
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.position AS position_3, b0_.icon AS icon_4 FROM body_type b0_ ORDER BY b0_.name ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1
FROM
  fuel_type f0_
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1 FROM fuel_type f0_ ORDER BY f0_.name ASC;

SELECT
  MIN(v0_.price) AS sclr_0
FROM
  vehicle v0_

SELECT MIN(v0_.price) AS sclr_0 FROM vehicle v0_;

SELECT
  MAX(v0_.price) AS sclr_0
FROM
  vehicle v0_

SELECT MAX(v0_.price) AS sclr_0 FROM vehicle v0_;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.thumbnail AS thumbnail_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.size AS size_6,
  t0.position AS position_7,
  t0.is_featured AS is_featured_8,
  t0.image_path AS image_path_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.vehicle_id AS vehicle_id_12
FROM
  image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumbnail AS thumbnail_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.size AS size_6, t0.position AS position_7, t0.is_featured AS is_featured_8, t0.image_path AS image_path_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.vehicle_id AS vehicle_id_12 FROM image t0 WHERE t0.vehicle_id = 457 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.category_id AS category_id_4
FROM
  feature t0
  INNER JOIN vehicle_feature ON t0.id = vehicle_feature.feature_id
WHERE
  vehicle_feature.vehicle_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.category_id AS category_id_4 FROM feature t0 INNER JOIN vehicle_feature ON t0.id = vehicle_feature.feature_id WHERE vehicle_feature.vehicle_id = 457;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.thumbnail AS thumbnail_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.size AS size_6,
  t0.position AS position_7,
  t0.is_featured AS is_featured_8,
  t0.image_path AS image_path_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.vehicle_id AS vehicle_id_12
FROM
  image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumbnail AS thumbnail_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.size AS size_6, t0.position AS position_7, t0.is_featured AS is_featured_8, t0.image_path AS image_path_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.vehicle_id AS vehicle_id_12 FROM image t0 WHERE t0.vehicle_id = 235 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.category_id AS category_id_4
FROM
  feature t0
  INNER JOIN vehicle_feature ON t0.id = vehicle_feature.feature_id
WHERE
  vehicle_feature.vehicle_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.category_id AS category_id_4 FROM feature t0 INNER JOIN vehicle_feature ON t0.id = vehicle_feature.feature_id WHERE vehicle_feature.vehicle_id = 235;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.thumbnail AS thumbnail_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.size AS size_6,
  t0.position AS position_7,
  t0.is_featured AS is_featured_8,
  t0.image_path AS image_path_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.vehicle_id AS vehicle_id_12
FROM
  image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumbnail AS thumbnail_3, t0.original_name AS original_name_4, t0.mime_type AS mime_type_5, t0.size AS size_6, t0.position AS position_7, t0.is_featured AS is_featured_8, t0.image_path AS image_path_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.vehicle_id AS vehicle_id_12 FROM image t0 WHERE t0.vehicle_id = 271 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.category_id AS category_id_4
FROM
  feature t0
  INNER JOIN vehicle_feature ON t0.id = vehicle_feature.feature_id
WHERE
  vehicle_feature.vehicle_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.category_id AS category_id_4 FROM feature t0 INNER JOIN vehicle_feature ON t0.id = vehicle_feature.feature_id WHERE vehicle_feature.vehicle_id = 271;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.thumbnail AS thumbnail_3,
  t0.original_name AS original_name_4,
  t0.mime_type AS mime_type_5,
  t0.size AS size_6,
  t0.position AS position_7,
  t0.is_featured AS is_featured_8,
  t0.image_path AS image_path_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.vehicle_id AS vehicle_id_12
FROM
  image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.position ASC