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
  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
  AND u0_.id IN (?)

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 AND u0_.id IN ('210');

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
  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_.type_document AS type_document_19,
  d0_.heure_reprise AS heure_reprise_20,
  d0_.created_at AS created_at_21,
  d0_.updated_at AS updated_at_22,
  d0_.vehicule_id AS vehicule_id_23,
  d0_.validated1_by_id AS validated1_by_id_24,
  d0_.validated2_by_id AS validated2_by_id_25,
  d0_.validated3_by_id AS validated3_by_id_26,
  d0_.titulaire_id AS titulaire_id_27,
  d0_.owner_id AS owner_id_28,
  d0_.delivery_by_id AS delivery_by_id_29,
  d0_.cancelled_by_id AS cancelled_by_id_30,
  d0_.rejected_by_id AS rejected_by_id_31,
  d0_.asked_by_id AS asked_by_id_32
FROM
  document d0_
WHERE
  (
    d0_.date BETWEEN ?
    AND ?
  )
  AND d0_.type_document = ?
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_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') AND d0_.type_document = 'ORDRE_MISSION' ORDER BY d0_.date ASC;

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_
WHERE
  v0_.id IN (?)

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_ WHERE v0_.id IN ('4');

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_
WHERE
  c0_.id IN (?)

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_ WHERE c0_.id IN ('1');

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.objet AS objet_3,
  t0.debut AS debut_4,
  t0.fin AS fin_5,
  t0.objectif AS objectif_6,
  t0.carburant AS carburant_7,
  t0.nature_equipement AS nature_equipement_8,
  t0.total AS total_9,
  t0.statut AS statut_10,
  t0.date AS date_11,
  t0.validated1_at AS validated1_at_12,
  t0.validated2_at AS validated2_at_13,
  t0.validated3_at AS validated3_at_14,
  t0.delivery_at AS delivery_at_15,
  t0.cancelled_at AS cancelled_at_16,
  t0.motif_rejet AS motif_rejet_17,
  t0.modif AS modif_18,
  t0.rejected_at AS rejected_at_19,
  t0.type_document AS type_document_20,
  t0.heure_reprise AS heure_reprise_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.vehicule_id AS vehicule_id_24,
  t0.validated1_by_id AS validated1_by_id_25,
  t0.validated2_by_id AS validated2_by_id_26,
  t0.validated3_by_id AS validated3_by_id_27,
  t0.titulaire_id AS titulaire_id_28,
  t0.owner_id AS owner_id_29,
  t0.delivery_by_id AS delivery_by_id_30,
  t0.cancelled_by_id AS cancelled_by_id_31,
  t0.rejected_by_id AS rejected_by_id_32,
  t0.asked_by_id AS asked_by_id_33
FROM
  document t0
WHERE
  t0.reference = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.objet AS objet_3, t0.debut AS debut_4, t0.fin AS fin_5, t0.objectif AS objectif_6, t0.carburant AS carburant_7, t0.nature_equipement AS nature_equipement_8, t0.total AS total_9, t0.statut AS statut_10, t0.date AS date_11, t0.validated1_at AS validated1_at_12, t0.validated2_at AS validated2_at_13, t0.validated3_at AS validated3_at_14, t0.delivery_at AS delivery_at_15, t0.cancelled_at AS cancelled_at_16, t0.motif_rejet AS motif_rejet_17, t0.modif AS modif_18, t0.rejected_at AS rejected_at_19, t0.type_document AS type_document_20, t0.heure_reprise AS heure_reprise_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.vehicule_id AS vehicule_id_24, t0.validated1_by_id AS validated1_by_id_25, t0.validated2_by_id AS validated2_by_id_26, t0.validated3_by_id AS validated3_by_id_27, t0.titulaire_id AS titulaire_id_28, t0.owner_id AS owner_id_29, t0.delivery_by_id AS delivery_by_id_30, t0.cancelled_by_id AS cancelled_by_id_31, t0.rejected_by_id AS rejected_by_id_32, t0.asked_by_id AS asked_by_id_33 FROM document t0 WHERE t0.reference = '139/TOPEX-CI/OM/NKC/DGA/JSD/26' LIMIT 2;

INSERT INTO itineraire (ordre, ville_id, mission_id)
VALUES
  (?, ?, ?)

INSERT INTO itineraire (ordre, ville_id, mission_id) VALUES (1, 4, 205);

INSERT INTO detail_itineraire (
  nb_jours, prix_unitaire, total, detail,
  created_at, updated_at, document_id,
  participants_id, charge_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO detail_itineraire (nb_jours, prix_unitaire, total, detail, created_at, updated_at, document_id, participants_id, charge_id) VALUES (1, 18000, 18000, NULL, '2026-04-17 10:10:13', NULL, 205, 210, 1);

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_
WHERE
  v0_.id IN (?, ?, ?)

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_ WHERE v0_.id IN ('112', '138', '215');

INSERT INTO document (
  reference, objet, debut, fin, objectif,
  carburant, nature_equipement, total,
  statut, date, validated1_at, validated2_at,
  validated3_at, delivery_at, cancelled_at,
  motif_rejet, modif, rejected_at,
  type_document, heure_reprise, created_at,
  updated_at, vehicule_id, validated1_by_id,
  validated2_by_id, validated3_by_id,
  titulaire_id, owner_id, delivery_by_id,
  cancelled_by_id, rejected_by_id,
  asked_by_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO document (reference, objet, debut, fin, objectif, carburant, nature_equipement, total, statut, date, validated1_at, validated2_at, validated3_at, delivery_at, cancelled_at, motif_rejet, modif, rejected_at, type_document, heure_reprise, created_at, updated_at, vehicule_id, validated1_by_id, validated2_by_id, validated3_by_id, titulaire_id, owner_id, delivery_by_id, cancelled_by_id, rejected_by_id, asked_by_id) VALUES ('139/TOPEX-CI/OM/NKC/DGA/JSD/26', 'Visite des clients', '2026-04-17', '2026-04-18', 'Visite des clients', 'CARTE SHELL', 'R.A.S', 77000, 'PENDING', '2026-04-17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ORDRE_MISSION', NULL, '2026-04-17 10:10:13', NULL, 29, NULL, NULL, NULL, 210, 163, NULL, NULL, NULL, NULL);

INSERT INTO document_ville (document_id, ville_id)
VALUES
  (?, ?)

INSERT INTO document_ville (document_id, ville_id) VALUES (205, 112);

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_
WHERE
  v0_.id IN (?)

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_ WHERE v0_.id IN ('29');

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;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO document_user (document_id, user_id)
VALUES
  (?, ?)

INSERT INTO document_user (document_id, user_id) VALUES (205, 3);

"COMMIT"

"COMMIT";