Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.action AS action_3,
  t0.is_granted AS is_granted_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.user_id AS user_id_10
FROM
  permission t0
WHERE
  t0.user_id = ?
  AND t0.entity = ?
  AND t0.action = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.is_granted AS is_granted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.user_id AS user_id_10 FROM permission t0 WHERE t0.user_id = '0199b949-79f7-78a7-a47a-7d343d1f8372' AND t0.entity = 'Bon' AND t0.action = 'Liste' LIMIT 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_19
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.date_emission AS date_emission_1,
          b0_.motif_decaissement AS motif_decaissement_2,
          b0_.service AS service_3,
          b0_.montant_total AS montant_total_4,
          b0_.motif_rejet AS motif_rejet_5,
          b0_.statut AS statut_6,
          b0_.is_priority AS is_priority_7,
          b0_.objet AS objet_8,
          b0_.montant_restitue AS montant_restitue_9,
          b0_.date_restitution AS date_restitution_10,
          b0_.statut_restitution AS statut_restitution_11,
          b0_.is_facture_recue AS is_facture_recue_12,
          b0_.chemin_facture AS chemin_facture_13,
          b0_.nom_original_facture AS nom_original_facture_14,
          b0_.date_reception_facture AS date_reception_facture_15,
          b0_.montant_rejet AS montant_rejet_16,
          b0_.is_dispatch AS is_dispatch_17,
          b0_.date_decaissement AS date_decaissement_18,
          b0_.created_at AS created_at_19,
          b0_.updated_at AS updated_at_20,
          b0_.deleted_at AS deleted_at_21,
          b0_.created_by AS created_by_22,
          b0_.updated_by AS updated_by_23
        FROM
          bon b0_
        WHERE
          b0_.service = ?
          AND b0_.date_emission >= ?
          AND b0_.date_emission <= ?
      ) dctrn_result_inner
    ORDER BY
      created_at_19 DESC
  ) dctrn_result
LIMIT
  10
OFFSET
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_19 FROM (SELECT b0_.id AS id_0, b0_.date_emission AS date_emission_1, b0_.motif_decaissement AS motif_decaissement_2, b0_.service AS service_3, b0_.montant_total AS montant_total_4, b0_.motif_rejet AS motif_rejet_5, b0_.statut AS statut_6, b0_.is_priority AS is_priority_7, b0_.objet AS objet_8, b0_.montant_restitue AS montant_restitue_9, b0_.date_restitution AS date_restitution_10, b0_.statut_restitution AS statut_restitution_11, b0_.is_facture_recue AS is_facture_recue_12, b0_.chemin_facture AS chemin_facture_13, b0_.nom_original_facture AS nom_original_facture_14, b0_.date_reception_facture AS date_reception_facture_15, b0_.montant_rejet AS montant_rejet_16, b0_.is_dispatch AS is_dispatch_17, b0_.date_decaissement AS date_decaissement_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.deleted_at AS deleted_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23 FROM bon b0_ WHERE b0_.service = 'Opérations' AND b0_.date_emission >= '2025-12-01 00:00:00' AND b0_.date_emission <= '2026-06-01 00:00:00') dctrn_result_inner ORDER BY created_at_19 DESC) dctrn_result LIMIT 10 OFFSET 10;

SELECT
  SUM(b0_.montant_total) AS sclr_0
FROM
  bon b0_
WHERE
  b0_.service = ?
  AND b0_.date_emission >= ?
  AND b0_.date_emission <= ?

SELECT SUM(b0_.montant_total) AS sclr_0 FROM bon b0_ WHERE b0_.service = 'Opérations' AND b0_.date_emission >= '2025-12-01 00:00:00' AND b0_.date_emission <= '2026-06-01 00:00:00';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.date_emission AS date_emission_1,
          b0_.motif_decaissement AS motif_decaissement_2,
          b0_.service AS service_3,
          b0_.montant_total AS montant_total_4,
          b0_.motif_rejet AS motif_rejet_5,
          b0_.statut AS statut_6,
          b0_.is_priority AS is_priority_7,
          b0_.objet AS objet_8,
          b0_.montant_restitue AS montant_restitue_9,
          b0_.date_restitution AS date_restitution_10,
          b0_.statut_restitution AS statut_restitution_11,
          b0_.is_facture_recue AS is_facture_recue_12,
          b0_.chemin_facture AS chemin_facture_13,
          b0_.nom_original_facture AS nom_original_facture_14,
          b0_.date_reception_facture AS date_reception_facture_15,
          b0_.montant_rejet AS montant_rejet_16,
          b0_.is_dispatch AS is_dispatch_17,
          b0_.date_decaissement AS date_decaissement_18,
          b0_.created_at AS created_at_19,
          b0_.updated_at AS updated_at_20,
          b0_.deleted_at AS deleted_at_21,
          b0_.created_by AS created_by_22,
          b0_.updated_by AS updated_by_23
        FROM
          bon b0_
        WHERE
          b0_.service = ?
          AND b0_.date_emission >= ?
          AND b0_.date_emission <= ?
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.date_emission AS date_emission_1, b0_.motif_decaissement AS motif_decaissement_2, b0_.service AS service_3, b0_.montant_total AS montant_total_4, b0_.motif_rejet AS motif_rejet_5, b0_.statut AS statut_6, b0_.is_priority AS is_priority_7, b0_.objet AS objet_8, b0_.montant_restitue AS montant_restitue_9, b0_.date_restitution AS date_restitution_10, b0_.statut_restitution AS statut_restitution_11, b0_.is_facture_recue AS is_facture_recue_12, b0_.chemin_facture AS chemin_facture_13, b0_.nom_original_facture AS nom_original_facture_14, b0_.date_reception_facture AS date_reception_facture_15, b0_.montant_rejet AS montant_rejet_16, b0_.is_dispatch AS is_dispatch_17, b0_.date_decaissement AS date_decaissement_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.deleted_at AS deleted_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23 FROM bon b0_ WHERE b0_.service = 'Opérations' AND b0_.date_emission >= '2025-12-01 00:00:00' AND b0_.date_emission <= '2026-06-01 00:00:00' ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  b0_.id AS id_0,
  b0_.date_emission AS date_emission_1,
  b0_.motif_decaissement AS motif_decaissement_2,
  b0_.service AS service_3,
  b0_.montant_total AS montant_total_4,
  b0_.motif_rejet AS motif_rejet_5,
  b0_.statut AS statut_6,
  b0_.is_priority AS is_priority_7,
  b0_.objet AS objet_8,
  b0_.montant_restitue AS montant_restitue_9,
  b0_.date_restitution AS date_restitution_10,
  b0_.statut_restitution AS statut_restitution_11,
  b0_.is_facture_recue AS is_facture_recue_12,
  b0_.chemin_facture AS chemin_facture_13,
  b0_.nom_original_facture AS nom_original_facture_14,
  b0_.date_reception_facture AS date_reception_facture_15,
  b0_.montant_rejet AS montant_rejet_16,
  b0_.is_dispatch AS is_dispatch_17,
  b0_.date_decaissement AS date_decaissement_18,
  b0_.created_at AS created_at_19,
  b0_.updated_at AS updated_at_20,
  b0_.deleted_at AS deleted_at_21,
  b0_.created_by AS created_by_22,
  b0_.updated_by AS updated_by_23,
  b0_.chef_service_id AS chef_service_id_24,
  b0_.direction_generale_id AS direction_generale_id_25,
  b0_.rejeter_par_id AS rejeter_par_id_26,
  b0_.receptionnaire_sous_id AS receptionnaire_sous_id_27,
  b0_.depensier_id AS depensier_id_28,
  b0_.receptionnaire_facture_id AS receptionnaire_facture_id_29,
  b0_.demande_id AS demande_id_30,
  b0_.caissiere_id AS caissiere_id_31,
  b0_.user_id AS user_id_32,
  b0_.direction_financiere_id AS direction_financiere_id_33,
  b0_.compte_syscohada_id AS compte_syscohada_id_34,
  b0_.restituteur_id AS restituteur_id_35,
  b0_.objet_bon_id AS objet_bon_id_36
FROM
  bon b0_
WHERE
  b0_.service = ?
  AND b0_.date_emission >= ?
  AND b0_.date_emission <= ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.created_at DESC

SELECT b0_.id AS id_0, b0_.date_emission AS date_emission_1, b0_.motif_decaissement AS motif_decaissement_2, b0_.service AS service_3, b0_.montant_total AS montant_total_4, b0_.motif_rejet AS motif_rejet_5, b0_.statut AS statut_6, b0_.is_priority AS is_priority_7, b0_.objet AS objet_8, b0_.montant_restitue AS montant_restitue_9, b0_.date_restitution AS date_restitution_10, b0_.statut_restitution AS statut_restitution_11, b0_.is_facture_recue AS is_facture_recue_12, b0_.chemin_facture AS chemin_facture_13, b0_.nom_original_facture AS nom_original_facture_14, b0_.date_reception_facture AS date_reception_facture_15, b0_.montant_rejet AS montant_rejet_16, b0_.is_dispatch AS is_dispatch_17, b0_.date_decaissement AS date_decaissement_18, b0_.created_at AS created_at_19, b0_.updated_at AS updated_at_20, b0_.deleted_at AS deleted_at_21, b0_.created_by AS created_by_22, b0_.updated_by AS updated_by_23, b0_.chef_service_id AS chef_service_id_24, b0_.direction_generale_id AS direction_generale_id_25, b0_.rejeter_par_id AS rejeter_par_id_26, b0_.receptionnaire_sous_id AS receptionnaire_sous_id_27, b0_.depensier_id AS depensier_id_28, b0_.receptionnaire_facture_id AS receptionnaire_facture_id_29, b0_.demande_id AS demande_id_30, b0_.caissiere_id AS caissiere_id_31, b0_.user_id AS user_id_32, b0_.direction_financiere_id AS direction_financiere_id_33, b0_.compte_syscohada_id AS compte_syscohada_id_34, b0_.restituteur_id AS restituteur_id_35, b0_.objet_bon_id AS objet_bon_id_36 FROM bon b0_ WHERE b0_.service = 'Opérations' AND b0_.date_emission >= '2025-12-01 00:00:00' AND b0_.date_emission <= '2026-06-01 00:00:00' AND b0_.id IN ('019e83fd-7c5d-7b40-9a9f-e8351b20ba56', '019e83f9-724e-7e42-8957-136ebfb989ad', '019e83f8-716b-7262-87e6-353b9f2a57bb', '019e83f4-d99e-79de-b907-964abc6c0649', '019e83f2-2d6e-7487-9481-5e68b12352ec', '019e83ee-41f1-7b0f-b263-0366ab9b8ea6', '019e83eb-ae02-7e27-bf99-856ac8426390', '019e83ea-9ee8-7e9f-985f-ae5b1fa6298f', '019e824f-1d0e-7379-9417-d384acf8a06b', '019e824c-a3a6-7e14-b546-db83667077c8') ORDER BY b0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.service AS service_7,
  t0.is_active AS is_active_8,
  t0.next_id AS next_id_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14,
  t0.responsable_id AS responsable_id_15
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.service AS service_7, t0.is_active AS is_active_8, t0.next_id AS next_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.responsable_id AS responsable_id_15 FROM `user` t0 WHERE t0.id = '0199b949-79f7-78a7-a47a-7d343d1f8372';