Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2
FROM
  city t0
WHERE
  t0.name_fr = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.name_fr = 'Marrakech' LIMIT 1;

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  vehicle v0_
  LEFT JOIN car c1_ ON v0_.id = c1_.id
  LEFT JOIN city c2_ ON v0_.city_id = c2_.id
  LEFT JOIN agency a3_ ON v0_.agency_id = a3_.id
  LEFT JOIN user u4_ ON a3_.id = u4_.id
  LEFT JOIN (
    car c5_
    INNER JOIN vehicle v6_ ON c5_.id = v6_.id
  ) ON (v6_.id = v0_.id)
WHERE
  a3_.is_visible = ?
  AND c2_.id = ?
  AND v0_.status = ?
  AND v0_.days_min <= ?
  AND (
    v0_.id NOT IN (
      SELECT
        b7_.vehicle_id AS sclr_1
      FROM
        booking b7_
      WHERE
        b7_.status = ?
        AND (
          b7_.date_from < ?
          AND b7_.date_to > ?
        )
    )
  )

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM vehicle v0_ LEFT JOIN car c1_ ON v0_.id = c1_.id LEFT JOIN city c2_ ON v0_.city_id = c2_.id LEFT JOIN agency a3_ ON v0_.agency_id = a3_.id LEFT JOIN user u4_ ON a3_.id = u4_.id LEFT JOIN (car c5_ INNER JOIN vehicle v6_ ON c5_.id = v6_.id) ON (v6_.id = v0_.id) WHERE a3_.is_visible = 1 AND c2_.id = 3 AND v0_.status = 'available' AND v0_.days_min <= 1 AND (v0_.id NOT IN (SELECT b7_.vehicle_id AS sclr_1 FROM booking b7_ WHERE b7_.status = 'confirmed' AND (b7_.date_from < '2026-01-20' AND b7_.date_to > '2026-01-19')));

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.created_at AS created_at_1
FROM
  vehicle v0_
  LEFT JOIN car c1_ ON v0_.id = c1_.id
  LEFT JOIN city c2_ ON v0_.city_id = c2_.id
  LEFT JOIN agency a3_ ON v0_.agency_id = a3_.id
  LEFT JOIN user u4_ ON a3_.id = u4_.id
  LEFT JOIN (
    car c5_
    INNER JOIN vehicle v6_ ON c5_.id = v6_.id
  ) ON (v6_.id = v0_.id)
WHERE
  a3_.is_visible = ?
  AND c2_.id = ?
  AND v0_.status = ?
  AND v0_.days_min <= ?
  AND (
    v0_.id NOT IN (
      SELECT
        b7_.vehicle_id AS sclr_2
      FROM
        booking b7_
      WHERE
        b7_.status = ?
        AND (
          b7_.date_from < ?
          AND b7_.date_to > ?
        )
    )
  )
ORDER BY
  v0_.created_at DESC
LIMIT
  20

SELECT DISTINCT v0_.id AS id_0, v0_.created_at AS created_at_1 FROM vehicle v0_ LEFT JOIN car c1_ ON v0_.id = c1_.id LEFT JOIN city c2_ ON v0_.city_id = c2_.id LEFT JOIN agency a3_ ON v0_.agency_id = a3_.id LEFT JOIN user u4_ ON a3_.id = u4_.id LEFT JOIN (car c5_ INNER JOIN vehicle v6_ ON c5_.id = v6_.id) ON (v6_.id = v0_.id) WHERE a3_.is_visible = 1 AND c2_.id = 3 AND v0_.status = 'available' AND v0_.days_min <= 1 AND (v0_.id NOT IN (SELECT b7_.vehicle_id AS sclr_2 FROM booking b7_ WHERE b7_.status = 'confirmed' AND (b7_.date_from < '2026-01-20' AND b7_.date_to > '2026-01-19'))) ORDER BY v0_.created_at DESC LIMIT 20;

SELECT
  v0_.id AS id_0,
  v0_.year AS year_1,
  v0_.days_min AS days_min_2,
  v0_.description AS description_3,
  v0_.reference AS reference_4,
  v0_.status AS status_5,
  v0_.price AS price_6,
  v0_.registration_number AS registration_number_7,
  v0_.registration_letter AS registration_letter_8,
  v0_.registration_city_code AS registration_city_code_9,
  v0_.created_at AS created_at_10,
  c1_.seats_nbr AS seats_nbr_11,
  c1_.doors_nbr AS doors_nbr_12,
  c1_.child_seat AS child_seat_13,
  c1_.gear_box AS gear_box_14,
  c1_.fuel AS fuel_15,
  c1_.type AS type_16,
  v0_.discriminator_type AS discriminator_type_17,
  v0_.city_id AS city_id_18,
  v0_.agency_id AS agency_id_19,
  v0_.model_id AS model_id_20
FROM
  vehicle v0_
  LEFT JOIN car c1_ ON v0_.id = c1_.id
  LEFT JOIN city c2_ ON v0_.city_id = c2_.id
  LEFT JOIN agency a3_ ON v0_.agency_id = a3_.id
  LEFT JOIN user u4_ ON a3_.id = u4_.id
  LEFT JOIN (
    car c5_
    INNER JOIN vehicle v6_ ON c5_.id = v6_.id
  ) ON (v6_.id = v0_.id)
WHERE
  a3_.is_visible = ?
  AND c2_.id = ?
  AND v0_.status = ?
  AND v0_.days_min <= ?
  AND (
    v0_.id NOT IN (
      SELECT
        b7_.vehicle_id AS sclr_21
      FROM
        booking b7_
      WHERE
        b7_.status = ?
        AND (
          b7_.date_from < ?
          AND b7_.date_to > ?
        )
    )
  )
  AND v0_.id IN (?)
ORDER BY
  v0_.created_at DESC

SELECT v0_.id AS id_0, v0_.year AS year_1, v0_.days_min AS days_min_2, v0_.description AS description_3, v0_.reference AS reference_4, v0_.status AS status_5, v0_.price AS price_6, v0_.registration_number AS registration_number_7, v0_.registration_letter AS registration_letter_8, v0_.registration_city_code AS registration_city_code_9, v0_.created_at AS created_at_10, c1_.seats_nbr AS seats_nbr_11, c1_.doors_nbr AS doors_nbr_12, c1_.child_seat AS child_seat_13, c1_.gear_box AS gear_box_14, c1_.fuel AS fuel_15, c1_.type AS type_16, v0_.discriminator_type AS discriminator_type_17, v0_.city_id AS city_id_18, v0_.agency_id AS agency_id_19, v0_.model_id AS model_id_20 FROM vehicle v0_ LEFT JOIN car c1_ ON v0_.id = c1_.id LEFT JOIN city c2_ ON v0_.city_id = c2_.id LEFT JOIN agency a3_ ON v0_.agency_id = a3_.id LEFT JOIN user u4_ ON a3_.id = u4_.id LEFT JOIN (car c5_ INNER JOIN vehicle v6_ ON c5_.id = v6_.id) ON (v6_.id = v0_.id) WHERE a3_.is_visible = 1 AND c2_.id = 3 AND v0_.status = 'available' AND v0_.days_min <= 1 AND (v0_.id NOT IN (SELECT b7_.vehicle_id AS sclr_21 FROM booking b7_ WHERE b7_.status = 'confirmed' AND (b7_.date_from < '2026-01-20' AND b7_.date_to > '2026-01-19'))) AND v0_.id IN ('019bd724-3ceb-72b6-ba4b-67e59a9a53e8') ORDER BY v0_.created_at DESC;

SELECT
  c0_.id AS id_0,
  c0_.name_fr AS name_fr_1
FROM
  city c0_

SELECT c0_.id AS id_0, c0_.name_fr AS name_fr_1 FROM city c0_;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.is_default AS is_default_3,
  t0.update_trigger AS update_trigger_4,
  t0.created_at AS created_at_5,
  t0.vehicle_id AS vehicle_id_6
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.is_default AS is_default_3, t0.update_trigger AS update_trigger_4, t0.created_at AS created_at_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_image t0 WHERE t0.vehicle_id = '019bd724-3ceb-72b6-ba4b-67e59a9a53e8';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.vehicle_type AS vehicle_type_3,
  t0.brand_id AS brand_id_4
FROM
  model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.vehicle_type AS vehicle_type_3, t0.brand_id AS brand_id_4 FROM model t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0 WHERE t0.id = 2;

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.is_email_verified AS is_email_verified_6,
  t1.is_phone_verified AS is_phone_verified_7,
  t1.email_verification_token AS email_verification_token_8,
  t1.phone_verification_token AS phone_verification_token_9,
  t1.status AS status_10,
  t1.pending_email AS pending_email_11,
  t1.pending_phone AS pending_phone_12,
  t1.reference AS reference_13,
  t1.created_at AS created_at_14,
  t1.last_name AS last_name_15,
  t1.first_name AS first_name_16,
  t1.phone AS phone_17,
  t0.name AS name_18,
  t0.profile_picture AS profile_picture_19,
  t0.description AS description_20,
  t0.slug AS slug_21,
  t0.is_visible AS is_visible_22,
  t1.discriminator_type
FROM
  agency t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.is_email_verified AS is_email_verified_6, t1.is_phone_verified AS is_phone_verified_7, t1.email_verification_token AS email_verification_token_8, t1.phone_verification_token AS phone_verification_token_9, t1.status AS status_10, t1.pending_email AS pending_email_11, t1.pending_phone AS pending_phone_12, t1.reference AS reference_13, t1.created_at AS created_at_14, t1.last_name AS last_name_15, t1.first_name AS first_name_16, t1.phone AS phone_17, t0.name AS name_18, t0.profile_picture AS profile_picture_19, t0.description AS description_20, t0.slug AS slug_21, t0.is_visible AS is_visible_22, t1.discriminator_type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = '019bd724-3715-7380-812d-4036cbef3751';