Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = 'mairie@' LIMIT 1;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.amount AS amount_1
FROM
  billet b0_
  INNER JOIN ticket_visibility t1_ ON (
    t1_.billet_id = b0_.id
    AND t1_.is_visible = 1
    AND t1_.role IN (?, ?)
  )
WHERE
  b0_.created_at >= ?
  AND b0_.created_at <= ?

SELECT DISTINCT b0_.id AS id_0, b0_.amount AS amount_1 FROM billet b0_ INNER JOIN ticket_visibility t1_ ON (t1_.billet_id = b0_.id AND t1_.is_visible = 1 AND t1_.role IN ('ROLE_MAIRE', 'ROLE_USER')) WHERE b0_.created_at >= '2026-07-06 00:00:00' AND b0_.created_at <= '2026-07-06 23:59:59';

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.reference AS reference_1,
  b0_.created_at AS created_at_2,
  b0_.validity AS validity_3,
  b0_.vehicle_type AS vehicle_type_4,
  b0_.amount AS amount_5,
  b0_.identifier_mode AS identifier_mode_6,
  b0_.created_by_id AS created_by_id_7,
  b0_.motor_id AS motor_id_8,
  b0_.person_id AS person_id_9,
  b0_.terminal_id AS terminal_id_10,
  b0_.parking_id AS parking_id_11,
  b0_.voiture_id AS voiture_id_12
FROM
  billet b0_
  INNER JOIN ticket_visibility t1_ ON (
    t1_.billet_id = b0_.id
    AND t1_.is_visible = 1
    AND t1_.role IN (?, ?)
  )
WHERE
  b0_.created_at >= ?
  AND b0_.created_at <= ?
ORDER BY
  b0_.created_at DESC
LIMIT
  10

SELECT DISTINCT b0_.id AS id_0, b0_.reference AS reference_1, b0_.created_at AS created_at_2, b0_.validity AS validity_3, b0_.vehicle_type AS vehicle_type_4, b0_.amount AS amount_5, b0_.identifier_mode AS identifier_mode_6, b0_.created_by_id AS created_by_id_7, b0_.motor_id AS motor_id_8, b0_.person_id AS person_id_9, b0_.terminal_id AS terminal_id_10, b0_.parking_id AS parking_id_11, b0_.voiture_id AS voiture_id_12 FROM billet b0_ INNER JOIN ticket_visibility t1_ ON (t1_.billet_id = b0_.id AND t1_.is_visible = 1 AND t1_.role IN ('ROLE_MAIRE', 'ROLE_USER')) WHERE b0_.created_at >= '2026-07-06 00:00:00' AND b0_.created_at <= '2026-07-06 23:59:59' ORDER BY b0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 5235;

SELECT
  t0.id AS id_1,
  t0.firs_name AS firs_name_2,
  t0.last_name AS last_name_3,
  t0.location AS location_4,
  t0.phone_number AS phone_number_5,
  t0.created_at AS created_at_6,
  t0.status AS status_7,
  t0.details_status AS details_status_8
FROM
  driver t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firs_name AS firs_name_2, t0.last_name AS last_name_3, t0.location AS location_4, t0.phone_number AS phone_number_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.details_status AS details_status_8 FROM driver t0 WHERE t0.id = 28;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 5234;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 3019;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 1208;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 516;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 5232;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 5231;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 1877;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 5230;

SELECT
  t0.id AS id_1,
  t0.chasis AS chasis_2,
  t0.created_at AS created_at_3,
  t0.plaque AS plaque_4,
  t0.status AS status_5,
  t0.color AS color_6,
  t0.created_by_id AS created_by_id_7,
  t0.marque_id AS marque_id_8
FROM
  motor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.chasis AS chasis_2, t0.created_at AS created_at_3, t0.plaque AS plaque_4, t0.status AS status_5, t0.color AS color_6, t0.created_by_id AS created_by_id_7, t0.marque_id AS marque_id_8 FROM motor t0 WHERE t0.id = 3741;