Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenoms AS prenoms_6,
  t0.telephone AS telephone_7,
  t0.fonction AS fonction_8,
  t0.plain_password AS plain_password_9,
  t0.enable AS enable_10,
  t0.deleted AS deleted_11,
  t0.birth_date AS birth_date_12,
  t0.birth_place AS birth_place_13,
  t0.cnps AS cnps_14,
  t0.embauche_date AS embauche_date_15,
  t0.renvoi_date AS renvoi_date_16,
  t0.signature_url AS signature_url_17,
  t0.initiale AS initiale_18,
  t0.signature_data AS signature_data_19,
  t0.signature_name AS signature_name_20,
  t0.signature_size AS signature_size_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.service_id AS service_id_24,
  t0.departement_id AS departement_id_25
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 FROM `user` t0 WHERE t0.id = 163;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3
FROM
  permission t0
  INNER JOIN permission_user ON t0.id = permission_user.permission_id
WHERE
  permission_user.user_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM permission t0 INNER JOIN permission_user ON t0.id = permission_user.permission_id WHERE permission_user.user_id = 163;

SELECT
  d0_.id AS id_0,
  d0_.reference AS reference_1,
  d0_.objet AS objet_2,
  d0_.debut AS debut_3,
  d0_.fin AS fin_4,
  d0_.objectif AS objectif_5,
  d0_.carburant AS carburant_6,
  d0_.nature_equipement AS nature_equipement_7,
  d0_.total AS total_8,
  d0_.statut AS statut_9,
  d0_.date AS date_10,
  d0_.validated1_at AS validated1_at_11,
  d0_.validated2_at AS validated2_at_12,
  d0_.validated3_at AS validated3_at_13,
  d0_.delivery_at AS delivery_at_14,
  d0_.cancelled_at AS cancelled_at_15,
  d0_.motif_rejet AS motif_rejet_16,
  d0_.modif AS modif_17,
  d0_.rejected_at AS rejected_at_18,
  d0_.created_at AS created_at_19,
  d0_.updated_at AS updated_at_20,
  d0_.vehicule_id AS vehicule_id_21,
  d0_.validated1_by_id AS validated1_by_id_22,
  d0_.validated2_by_id AS validated2_by_id_23,
  d0_.validated3_by_id AS validated3_by_id_24,
  d0_.titulaire_id AS titulaire_id_25,
  d0_.owner_id AS owner_id_26,
  d0_.delivery_by_id AS delivery_by_id_27,
  d0_.cancelled_by_id AS cancelled_by_id_28,
  d0_.rejected_by_id AS rejected_by_id_29,
  d0_.asked_by_id AS asked_by_id_30
FROM
  document d0_
WHERE
  d0_.date BETWEEN ?
  AND ?
ORDER BY
  d0_.date ASC

SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.created_at AS created_at_19, d0_.updated_at AS updated_at_20, d0_.vehicule_id AS vehicule_id_21, d0_.validated1_by_id AS validated1_by_id_22, d0_.validated2_by_id AS validated2_by_id_23, d0_.validated3_by_id AS validated3_by_id_24, d0_.titulaire_id AS titulaire_id_25, d0_.owner_id AS owner_id_26, d0_.delivery_by_id AS delivery_by_id_27, d0_.cancelled_by_id AS cancelled_by_id_28, d0_.rejected_by_id AS rejected_by_id_29, d0_.asked_by_id AS asked_by_id_30 FROM document d0_ WHERE d0_.date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' ORDER BY d0_.date ASC;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nom AS nom_4,
  u0_.prenoms AS prenoms_5,
  u0_.telephone AS telephone_6,
  u0_.fonction AS fonction_7,
  u0_.plain_password AS plain_password_8,
  u0_.enable AS enable_9,
  u0_.deleted AS deleted_10,
  u0_.birth_date AS birth_date_11,
  u0_.birth_place AS birth_place_12,
  u0_.cnps AS cnps_13,
  u0_.embauche_date AS embauche_date_14,
  u0_.renvoi_date AS renvoi_date_15,
  u0_.signature_url AS signature_url_16,
  u0_.initiale AS initiale_17,
  u0_.signature_data AS signature_data_18,
  u0_.signature_name AS signature_name_19,
  u0_.signature_size AS signature_size_20,
  u0_.created_at AS created_at_21,
  u0_.updated_at AS updated_at_22,
  u0_.service_id AS service_id_23,
  u0_.departement_id AS departement_id_24
FROM
  `user` u0_
  LEFT JOIN service s1_ ON u0_.service_id = s1_.id
WHERE
  s1_.description = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenoms AS prenoms_5, u0_.telephone AS telephone_6, u0_.fonction AS fonction_7, u0_.plain_password AS plain_password_8, u0_.enable AS enable_9, u0_.deleted AS deleted_10, u0_.birth_date AS birth_date_11, u0_.birth_place AS birth_place_12, u0_.cnps AS cnps_13, u0_.embauche_date AS embauche_date_14, u0_.renvoi_date AS renvoi_date_15, u0_.signature_url AS signature_url_16, u0_.initiale AS initiale_17, u0_.signature_data AS signature_data_18, u0_.signature_name AS signature_name_19, u0_.signature_size AS signature_size_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.service_id AS service_id_23, u0_.departement_id AS departement_id_24 FROM `user` u0_ LEFT JOIN service s1_ ON u0_.service_id = s1_.id WHERE s1_.description = 'DG';

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nom AS nom_4,
  u0_.prenoms AS prenoms_5,
  u0_.telephone AS telephone_6,
  u0_.fonction AS fonction_7,
  u0_.plain_password AS plain_password_8,
  u0_.enable AS enable_9,
  u0_.deleted AS deleted_10,
  u0_.birth_date AS birth_date_11,
  u0_.birth_place AS birth_place_12,
  u0_.cnps AS cnps_13,
  u0_.embauche_date AS embauche_date_14,
  u0_.renvoi_date AS renvoi_date_15,
  u0_.signature_url AS signature_url_16,
  u0_.initiale AS initiale_17,
  u0_.signature_data AS signature_data_18,
  u0_.signature_name AS signature_name_19,
  u0_.signature_size AS signature_size_20,
  u0_.created_at AS created_at_21,
  u0_.updated_at AS updated_at_22,
  u0_.service_id AS service_id_23,
  u0_.departement_id AS departement_id_24
FROM
  `user` u0_
  LEFT JOIN service s1_ ON u0_.service_id = s1_.id
WHERE
  s1_.description = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenoms AS prenoms_5, u0_.telephone AS telephone_6, u0_.fonction AS fonction_7, u0_.plain_password AS plain_password_8, u0_.enable AS enable_9, u0_.deleted AS deleted_10, u0_.birth_date AS birth_date_11, u0_.birth_place AS birth_place_12, u0_.cnps AS cnps_13, u0_.embauche_date AS embauche_date_14, u0_.renvoi_date AS renvoi_date_15, u0_.signature_url AS signature_url_16, u0_.initiale AS initiale_17, u0_.signature_data AS signature_data_18, u0_.signature_name AS signature_name_19, u0_.signature_size AS signature_size_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.service_id AS service_id_23, u0_.departement_id AS departement_id_24 FROM `user` u0_ LEFT JOIN service s1_ ON u0_.service_id = s1_.id WHERE s1_.description = 'DGA';

SELECT
  v0_.id AS id_0,
  v0_.libelle AS libelle_1,
  v0_.marque AS marque_2,
  v0_.immatriculation AS immatriculation_3,
  v0_.created_at AS created_at_4,
  v0_.updated_at AS updated_at_5
FROM
  vehicule v0_

SELECT v0_.id AS id_0, v0_.libelle AS libelle_1, v0_.marque AS marque_2, v0_.immatriculation AS immatriculation_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5 FROM vehicule v0_;

SELECT
  v0_.id AS id_0,
  v0_.code AS code_1,
  v0_.nom AS nom_2,
  v0_.created_at AS created_at_3,
  v0_.updated_at AS updated_at_4
FROM
  ville v0_

SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.nom AS nom_2, v0_.created_at AS created_at_3, v0_.updated_at AS updated_at_4 FROM ville v0_;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.nom AS nom_4,
  u0_.prenoms AS prenoms_5,
  u0_.telephone AS telephone_6,
  u0_.fonction AS fonction_7,
  u0_.plain_password AS plain_password_8,
  u0_.enable AS enable_9,
  u0_.deleted AS deleted_10,
  u0_.birth_date AS birth_date_11,
  u0_.birth_place AS birth_place_12,
  u0_.cnps AS cnps_13,
  u0_.embauche_date AS embauche_date_14,
  u0_.renvoi_date AS renvoi_date_15,
  u0_.signature_url AS signature_url_16,
  u0_.initiale AS initiale_17,
  u0_.signature_data AS signature_data_18,
  u0_.signature_name AS signature_name_19,
  u0_.signature_size AS signature_size_20,
  u0_.created_at AS created_at_21,
  u0_.updated_at AS updated_at_22,
  u0_.service_id AS service_id_23,
  u0_.departement_id AS departement_id_24
FROM
  `user` u0_
WHERE
  u0_.deleted = 0

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nom AS nom_4, u0_.prenoms AS prenoms_5, u0_.telephone AS telephone_6, u0_.fonction AS fonction_7, u0_.plain_password AS plain_password_8, u0_.enable AS enable_9, u0_.deleted AS deleted_10, u0_.birth_date AS birth_date_11, u0_.birth_place AS birth_place_12, u0_.cnps AS cnps_13, u0_.embauche_date AS embauche_date_14, u0_.renvoi_date AS renvoi_date_15, u0_.signature_url AS signature_url_16, u0_.initiale AS initiale_17, u0_.signature_data AS signature_data_18, u0_.signature_name AS signature_name_19, u0_.signature_size AS signature_size_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.service_id AS service_id_23, u0_.departement_id AS departement_id_24 FROM `user` u0_ WHERE u0_.deleted = 0;

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.libelle AS libelle_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4
FROM
  charge c0_

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.libelle AS libelle_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4 FROM charge c0_;

SELECT
  n0_.id AS id_0,
  n0_.message AS message_1,
  n0_.link_to AS link_to_2,
  n0_.unread AS unread_3,
  n0_.permission AS permission_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.document_id AS document_id_7,
  n0_.owner_id AS owner_id_8,
  n0_.destinataire_id AS destinataire_id_9
FROM
  notification n0_
WHERE
  n0_.permission IN (?, ?, ?, ?, ?)
  AND n0_.unread = 1
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.link_to AS link_to_2, n0_.unread AS unread_3, n0_.permission AS permission_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.document_id AS document_id_7, n0_.owner_id AS owner_id_8, n0_.destinataire_id AS destinataire_id_9 FROM notification n0_ WHERE n0_.permission IN ('ROLE_ADMIN', 'ROLE_DELIVERY', 'ROLE_CANCEL', 'ROLE_EMISSION', 'ROLE_USER') AND n0_.unread = 1 ORDER BY n0_.created_at DESC;

SELECT
  m0_.id AS id_0,
  m0_.commentaire AS commentaire_1,
  m0_.unread AS unread_2,
  m0_.link_to AS link_to_3,
  m0_.created_at AS created_at_4,
  m0_.updated_at AS updated_at_5,
  m0_.emissaire_id AS emissaire_id_6,
  m0_.destinataire_id AS destinataire_id_7,
  m0_.document_id AS document_id_8
FROM
  message m0_
WHERE
  m0_.destinataire_id = ?
  AND m0_.unread = 1
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.commentaire AS commentaire_1, m0_.unread AS unread_2, m0_.link_to AS link_to_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.emissaire_id AS emissaire_id_6, m0_.destinataire_id AS destinataire_id_7, m0_.document_id AS document_id_8 FROM message m0_ WHERE m0_.destinataire_id = 163 AND m0_.unread = 1 ORDER BY m0_.created_at DESC;