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 = '0986351277' LIMIT 1;

SELECT
  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_
  LEFT JOIN motor m1_ ON b0_.motor_id = m1_.id
  LEFT JOIN voiture v2_ ON b0_.voiture_id = v2_.id
WHERE
  (
    b0_.created_at >= ?
    AND b0_.created_at < ?
  )
  AND (
    m1_.plaque = ?
    OR v2_.plaque = ?
  )
ORDER BY
  b0_.created_at DESC
LIMIT
  1

SELECT 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_ LEFT JOIN motor m1_ ON b0_.motor_id = m1_.id LEFT JOIN voiture v2_ ON b0_.voiture_id = v2_.id WHERE (b0_.created_at >= '2026-07-14 00:00:00' AND b0_.created_at < '2026-07-15 00:00:00') AND (m1_.plaque = '761CS' OR v2_.plaque = '761CS') ORDER BY b0_.created_at DESC LIMIT 1;

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.plaque = ?
LIMIT
  1

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.plaque = '761CS' LIMIT 1;

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.phone_number = ?
LIMIT
  1

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.phone_number = '0850147791' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO driver (
  firs_name, last_name, location, phone_number,
  created_at, status, details_status
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO driver (firs_name, last_name, location, phone_number, created_at, status, details_status) VALUES ('KITAMBALA', 'KITAMBALA', NULL, '0850147791', '2026-07-14 17:30:45', 'active', NULL);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.created_at AS created_at_3,
  t0.validity AS validity_4,
  t0.vehicle_type AS vehicle_type_5,
  t0.amount AS amount_6,
  t0.identifier_mode AS identifier_mode_7,
  t0.created_by_id AS created_by_id_8,
  t0.motor_id AS motor_id_9,
  t0.person_id AS person_id_10,
  t0.terminal_id AS terminal_id_11,
  t0.parking_id AS parking_id_12,
  t0.voiture_id AS voiture_id_13
FROM
  billet t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.created_at AS created_at_3, t0.validity AS validity_4, t0.vehicle_type AS vehicle_type_5, t0.amount AS amount_6, t0.identifier_mode AS identifier_mode_7, t0.created_by_id AS created_by_id_8, t0.motor_id AS motor_id_9, t0.person_id AS person_id_10, t0.terminal_id AS terminal_id_11, t0.parking_id AS parking_id_12, t0.voiture_id AS voiture_id_13 FROM billet t0 WHERE t0.reference = 'KMS-VILLE2-17-1784021187299-RRXH-761CS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.login_at AS login_at_2,
  t0.user_id AS user_id_3,
  t0.terminal_id AS terminal_id_4,
  t0.parking_id AS parking_id_5
FROM
  session t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login_at AS login_at_2, t0.user_id AS user_id_3, t0.terminal_id AS terminal_id_4, t0.parking_id AS parking_id_5 FROM session t0 WHERE t0.id = 718;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.model AS model_3,
  t0.label AS label_4,
  t0.code AS code_5,
  t0.imei AS imei_6,
  t0.os AS os_7,
  t0.status AS status_8,
  t0.visible_roles AS visible_roles_9,
  t0.visible_roles_from AS visible_roles_from_10,
  t0.created_at AS created_at_11,
  t0.created_by_id AS created_by_id_12,
  t0.parking_id AS parking_id_13
FROM
  terminal t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.model AS model_3, t0.label AS label_4, t0.code AS code_5, t0.imei AS imei_6, t0.os AS os_7, t0.status AS status_8, t0.visible_roles AS visible_roles_9, t0.visible_roles_from AS visible_roles_from_10, t0.created_at AS created_at_11, t0.created_by_id AS created_by_id_12, t0.parking_id AS parking_id_13 FROM terminal t0 WHERE t0.code = 'PONT VILLE 2' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO billet (
  reference, created_at, validity, vehicle_type,
  amount, identifier_mode, created_by_id,
  motor_id, person_id, terminal_id,
  parking_id, voiture_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO billet (reference, created_at, validity, vehicle_type, amount, identifier_mode, created_by_id, motor_id, person_id, terminal_id, parking_id, voiture_id) VALUES ('KMS-VILLE2-17-1784021187299-RRXH-761CS', '2026-07-14 09:26:28', 1, 'moto', 1000, 'plaque', 17, 960, 2353, 17, NULL, NULL);

"COMMIT"

"COMMIT";

DELETE FROM
  ticket_visibility
WHERE
  billet_id = ?

DELETE FROM ticket_visibility WHERE billet_id = 20542;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_ADMIN', 1, '2026-07-14 17:30:45', 20542);

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_MAIRE', 1, '2026-07-14 17:30:45', 20542);

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_SUPER_ADMIN', 0, '2026-07-14 17:30:45', 20542);

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_SECRETAIRE', 1, '2026-07-14 17:30:45', 20542);

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_OPERATEUR', 0, '2026-07-14 17:30:45', 20542);

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_PERCEPTEUR', 0, '2026-07-14 17:30:45', 20542);

INSERT INTO ticket_visibility (
  role, is_visible, created_at, billet_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ticket_visibility (role, is_visible, created_at, billet_id) VALUES ('ROLE_USER', 0, '2026-07-14 17:30:45', 20542);

"COMMIT"

"COMMIT";