Symfony Profiler

SELECT
  DISTINCT v0_.id AS id_0
FROM
  vehicle v1_
  LEFT JOIN external_vehicle e2_ ON v1_.id = e2_.id
  INNER JOIN sale_event s3_ ON v1_.event_id = s3_.id
  INNER JOIN sale s4_ ON s3_.sale_id = s4_.id
  LEFT JOIN external_sale e5_ ON s4_.id = e5_.id
  INNER JOIN vehicle_category v0_ ON v1_.category_id = v0_.id
WHERE
  v1_.salingState NOT IN (?, ?, ?)
  AND s4_.endDate > ?
  AND v0_.name LIKE ?
LIMIT
  1

SELECT DISTINCT v0_.id AS id_0 FROM vehicle v1_ LEFT JOIN external_vehicle e2_ ON v1_.id = e2_.id INNER JOIN sale_event s3_ ON v1_.event_id = s3_.id INNER JOIN sale s4_ ON s3_.sale_id = s4_.id LEFT JOIN external_sale e5_ ON s4_.id = e5_.id INNER JOIN vehicle_category v0_ ON v1_.category_id = v0_.id WHERE v1_.salingState NOT IN ('Exclus', 'Supprimé', 'Absence mise à prix') AND s4_.endDate > '2026-02-04 07:30:00' AND v0_.name LIKE '%citroen%' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  vehicle_energy t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM vehicle_energy t0 WHERE t0.name = 'Citroen' LIMIT 1;

SELECT
  DISTINCT v0_.segmentSizeSlug AS segmentSizeSlug_0
FROM
  vehicle v0_
  LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id
  INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id
  INNER JOIN sale s3_ ON s2_.sale_id = s3_.id
  LEFT JOIN external_sale e4_ ON s3_.id = e4_.id
WHERE
  v0_.salingState NOT IN (?, ?, ?)
  AND s3_.endDate > ?
  AND v0_.segmentSizeSlug LIKE ?

SELECT DISTINCT v0_.segmentSizeSlug AS segmentSizeSlug_0 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN ('Exclus', 'Supprimé', 'Absence mise à prix') AND s3_.endDate > '2026-02-04 07:30:00' AND v0_.segmentSizeSlug LIKE '%citroen%';

SELECT
  DISTINCT v0_.makerSlug AS makerSlug_0
FROM
  vehicle v0_
  LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id
  INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id
  INNER JOIN sale s3_ ON s2_.sale_id = s3_.id
  LEFT JOIN external_sale e4_ ON s3_.id = e4_.id
WHERE
  v0_.salingState NOT IN (?, ?, ?)
  AND s3_.endDate > ?
  AND v0_.makerSlug LIKE ?
LIMIT
  1

SELECT DISTINCT v0_.makerSlug AS makerSlug_0 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN ('Exclus', 'Supprimé', 'Absence mise à prix') AND s3_.endDate > '2026-02-04 07:30:00' AND v0_.makerSlug LIKE '%citroen%' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.originalWord AS originalWord_2,
  t0.replacementWord AS replacementWord_3
FROM
  search_alias t0
WHERE
  t0.originalWord = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.originalWord AS originalWord_2, t0.replacementWord AS replacementWord_3 FROM search_alias t0 WHERE t0.originalWord = 'citroen' LIMIT 1;

SELECT
  DISTINCT v0_.modelGroupSlug AS modelGroupSlug_0,
  v0_.makerSlug AS makerSlug_1
FROM
  vehicle v0_
  LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id
  INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id
  INNER JOIN sale s3_ ON s2_.sale_id = s3_.id
  LEFT JOIN external_sale e4_ ON s3_.id = e4_.id
WHERE
  v0_.salingState NOT IN (?, ?, ?)
  AND s3_.endDate > ?
  AND v0_.modelGroupSlug LIKE ?
  AND v0_.modelGroupSlug <> 'n-a'

SELECT DISTINCT v0_.modelGroupSlug AS modelGroupSlug_0, v0_.makerSlug AS makerSlug_1 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN ('Exclus', 'Supprimé', 'Absence mise à prix') AND s3_.endDate > '2026-02-04 07:30:00' AND v0_.modelGroupSlug LIKE '%citroen%' AND v0_.modelGroupSlug <> 'n-a';

SELECT
  o0_.id AS id_0,
  o0_.codeSlug AS codeSlug_1,
  o0_.name AS name_2,
  o0_.weight AS weight_3,
  o0_.code AS code_4
FROM
  option_item o0_
WHERE
  o0_.name LIKE ?
LIMIT
  1

SELECT o0_.id AS id_0, o0_.codeSlug AS codeSlug_1, o0_.name AS name_2, o0_.weight AS weight_3, o0_.code AS code_4 FROM option_item o0_ WHERE o0_.name LIKE 'citroen%' LIMIT 1;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM vehicule_transmission t0 WHERE t0.name = 'Citroen' LIMIT 1;