Symfony Profiler

SELECT
  t0.id AS id_5,
  t0.email AS email_6,
  t0.roles AS roles_7,
  t0.password AS password_8,
  t0.is_email_verified AS is_email_verified_9,
  t0.is_phone_verified AS is_phone_verified_10,
  t0.email_verification_token AS email_verification_token_11,
  t0.phone_verification_token AS phone_verification_token_12,
  t0.status AS status_13,
  t0.pending_email AS pending_email_14,
  t0.pending_phone AS pending_phone_15,
  t0.reference AS reference_16,
  t0.created_at AS created_at_17,
  t0.last_name AS last_name_18,
  t0.first_name AS first_name_19,
  t0.phone AS phone_20,
  t0.discriminator_type,
  t2.name AS name_21,
  t2.profile_picture AS profile_picture_22,
  t2.description AS description_23,
  t2.slug AS slug_24,
  t2.is_visible AS is_visible_25,
  t3.agency_id AS agency_id_26
FROM
  user t0
  LEFT JOIN admin t1 ON t0.id = t1.id
  LEFT JOIN agency t2 ON t0.id = t2.id
  LEFT JOIN employee t3 ON t0.id = t3.id
  LEFT JOIN client t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.is_email_verified AS is_email_verified_9, t0.is_phone_verified AS is_phone_verified_10, t0.email_verification_token AS email_verification_token_11, t0.phone_verification_token AS phone_verification_token_12, t0.status AS status_13, t0.pending_email AS pending_email_14, t0.pending_phone AS pending_phone_15, t0.reference AS reference_16, t0.created_at AS created_at_17, t0.last_name AS last_name_18, t0.first_name AS first_name_19, t0.phone AS phone_20, t0.discriminator_type, t2.name AS name_21, t2.profile_picture AS profile_picture_22, t2.description AS description_23, t2.slug AS slug_24, t2.is_visible AS is_visible_25, t3.agency_id AS agency_id_26 FROM user t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN agency t2 ON t0.id = t2.id LEFT JOIN employee t3 ON t0.id = t3.id LEFT JOIN client t4 ON t0.id = t4.id WHERE t0.id = '019bd724-370a-7176-94e1-f55468d22e02';

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 (
    car c3_
    INNER JOIN vehicle v4_ ON c3_.id = v4_.id
  ) ON (v4_.id = v0_.id)
WHERE
  v0_.agency_id = ?
  AND v0_.status <> ?
  AND v0_.agency_id = ?

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 (car c3_ INNER JOIN vehicle v4_ ON c3_.id = v4_.id) ON (v4_.id = v0_.id) WHERE v0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' AND v0_.status <> 'deleted' AND v0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02';

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 (
    car c3_
    INNER JOIN vehicle v4_ ON c3_.id = v4_.id
  ) ON (v4_.id = v0_.id)
WHERE
  v0_.agency_id = ?
  AND v0_.status <> ?
  AND v0_.agency_id = ?
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 (car c3_ INNER JOIN vehicle v4_ ON c3_.id = v4_.id) ON (v4_.id = v0_.id) WHERE v0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' AND v0_.status <> 'deleted' AND v0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' 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 (
    car c3_
    INNER JOIN vehicle v4_ ON c3_.id = v4_.id
  ) ON (v4_.id = v0_.id)
WHERE
  v0_.agency_id = ?
  AND v0_.status <> ?
  AND v0_.agency_id = ?
  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 (car c3_ INNER JOIN vehicle v4_ ON c3_.id = v4_.id) ON (v4_.id = v0_.id) WHERE v0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' AND v0_.status <> 'deleted' AND v0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' AND v0_.id IN ('019bd724-4606-792e-af6e-e81a47074013', '019bd724-3d77-707f-97c8-9e23d98b6547', '019bd724-3b51-7a08-ad6e-2a25ebcace9f', '019bd724-37c1-7c4d-aae7-607123139d58', '019bd724-37fa-7c0c-a272-90c7bf6142e6', '019bd724-386a-7c12-889a-84d04e70e55b') ORDER BY v0_.created_at DESC;

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-4606-792e-af6e-e81a47074013';

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
  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-3d77-707f-97c8-9e23d98b6547';

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-3b51-7a08-ad6e-2a25ebcace9f';

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 = 6;

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-37c1-7c4d-aae7-607123139d58';

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-37fa-7c0c-a272-90c7bf6142e6';

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 = 12;

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 = 3;

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-386a-7c12-889a-84d04e70e55b';

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 = 13;

SELECT
  b0_.id AS id_0,
  b0_.date_from AS date_from_1,
  b0_.date_to AS date_to_2,
  b0_.status AS status_3,
  b0_.reference AS reference_4,
  b0_.total_amount AS total_amount_5,
  b0_.created_at AS created_at_6
FROM
  booking b0_
  LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id
  LEFT JOIN car c2_ ON v1_.id = c2_.id
WHERE
  b0_.status IN (?, ?)
  AND v1_.reference = ?

SELECT b0_.id AS id_0, b0_.date_from AS date_from_1, b0_.date_to AS date_to_2, b0_.status AS status_3, b0_.reference AS reference_4, b0_.total_amount AS total_amount_5, b0_.created_at AS created_at_6 FROM booking b0_ LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id LEFT JOIN car c2_ ON v1_.id = c2_.id WHERE b0_.status IN ('confirmed', 'completed') AND v1_.reference = 'ASBQW';

SELECT
  b0_.id AS id_0,
  b0_.date_from AS date_from_1,
  b0_.date_to AS date_to_2,
  b0_.status AS status_3,
  b0_.reference AS reference_4,
  b0_.total_amount AS total_amount_5,
  b0_.created_at AS created_at_6
FROM
  booking b0_
  LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id
  LEFT JOIN car c2_ ON v1_.id = c2_.id
WHERE
  b0_.status IN (?, ?)
  AND v1_.reference = ?

SELECT b0_.id AS id_0, b0_.date_from AS date_from_1, b0_.date_to AS date_to_2, b0_.status AS status_3, b0_.reference AS reference_4, b0_.total_amount AS total_amount_5, b0_.created_at AS created_at_6 FROM booking b0_ LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id LEFT JOIN car c2_ ON v1_.id = c2_.id WHERE b0_.status IN ('confirmed', 'completed') AND v1_.reference = '64MKR';

SELECT
  b0_.id AS id_0,
  b0_.date_from AS date_from_1,
  b0_.date_to AS date_to_2,
  b0_.status AS status_3,
  b0_.reference AS reference_4,
  b0_.total_amount AS total_amount_5,
  b0_.created_at AS created_at_6
FROM
  booking b0_
  LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id
  LEFT JOIN car c2_ ON v1_.id = c2_.id
WHERE
  b0_.status IN (?, ?)
  AND v1_.reference = ?

SELECT b0_.id AS id_0, b0_.date_from AS date_from_1, b0_.date_to AS date_to_2, b0_.status AS status_3, b0_.reference AS reference_4, b0_.total_amount AS total_amount_5, b0_.created_at AS created_at_6 FROM booking b0_ LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id LEFT JOIN car c2_ ON v1_.id = c2_.id WHERE b0_.status IN ('confirmed', 'completed') AND v1_.reference = 'Y3D7J';

SELECT
  b0_.id AS id_0,
  b0_.date_from AS date_from_1,
  b0_.date_to AS date_to_2,
  b0_.status AS status_3,
  b0_.reference AS reference_4,
  b0_.total_amount AS total_amount_5,
  b0_.created_at AS created_at_6
FROM
  booking b0_
  LEFT JOIN vehicle v1_ ON b0_.vehicle_id = v1_.id
  LEFT JOIN car c2_ ON v1_.id = c2_.id
WHERE
  b0_.status IN (?, ?)
  AND v1_.reference = ?