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 = '0198eaa8-2f34-700a-8d7e-3d649d1322c7' AND t0.entity = 'Equipement' AND t0.action = 'Liste' LIMIT 1;

SELECT
  SUM(
    CASE WHEN b0_.statut IN (?, ?, ?, ?) THEN
      b0_.montant_total
    ELSE
      0
    END
  ) AS sclr_0
FROM
  bon b0_
WHERE
  (
    b0_.date_emission BETWEEN ?
    AND ?
  )
  AND b0_.service = ?

SELECT SUM(CASE WHEN b0_.statut IN ('DECAISSE', 'RECEPTION DES FONDS', 'DEPENSE EFFECTUEE', 'FACTURE RECU') THEN b0_.montant_total ELSE 0 END) AS sclr_0 FROM bon b0_ WHERE (b0_.date_emission BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59') AND b0_.service = 'Moyens généraux et logistique';

SELECT
  SUM(b0_.montant_total) AS sclr_0
FROM
  bon b0_
WHERE
  b0_.statut = 'VALIDE PAR LA COMPTABILITE'
  AND b0_.service = ?

SELECT SUM(b0_.montant_total) AS sclr_0 FROM bon b0_ WHERE b0_.statut = 'VALIDE PAR LA COMPTABILITE' AND b0_.service = 'Moyens généraux et logistique';

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  demande d0_
WHERE
  d0_.status = ?
  AND (
    d0_.date_signal_panne BETWEEN ?
    AND ?
  )
  AND d0_.user_id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM demande d0_ WHERE d0_.status = 'NOUVELLE' AND (d0_.date_signal_panne BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59') AND d0_.user_id = '0198eaa8-2f34-700a-8d7e-3d649d1322c7';

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_.user_id = ?
  AND (
    b0_.created_at BETWEEN ?
    AND ?
  )
ORDER BY
  b0_.created_at DESC
LIMIT
  3

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_.user_id = '0198eaa8-2f34-700a-8d7e-3d649d1322c7' AND (b0_.created_at BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59') ORDER BY b0_.created_at DESC LIMIT 3;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  bon b0_
WHERE
  b0_.statut = ?
  AND (
    b0_.date_emission BETWEEN ?
    AND ?
  )
  AND b0_.user_id = ?

SELECT COUNT(b0_.id) AS sclr_0 FROM bon b0_ WHERE b0_.statut = 'EN ATTENTE' AND (b0_.date_emission BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59') AND b0_.user_id = '0198eaa8-2f34-700a-8d7e-3d649d1322c7';

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 = '0198eaa8-2f34-700a-8d7e-3d649d1322c7';

SELECT
  DATE_FORMAT(date_emission, '%Y-%m') AS mois,
  SUM(
    CASE WHEN statut IN (
      'DECAISSE', 'RECEPTION DES FONDS',
      'DEPENSE EFFECTUEE', 'FACTURE RECU'
    ) THEN
      montant_total
    ELSE
      0
    END
  ) AS decaissements,
  COUNT(*) AS totalBons,
  SUM(montant_total) AS montantTotal
FROM
  bon
WHERE
  date_emission BETWEEN :dateDebut
  AND :dateFin
  AND user_id = :userId
GROUP BY
  mois
ORDER BY
  mois DESC

SELECT 
            DATE_FORMAT(date_emission, '%Y-%m') AS mois,
            SUM(CASE WHEN statut IN ('DECAISSE', 'RECEPTION DES FONDS', 'DEPENSE EFFECTUEE', 'FACTURE RECU') 
                THEN montant_total ELSE 0 END) AS decaissements,
            COUNT(*) AS totalBons,
            SUM(montant_total) AS montantTotal
        FROM bon
        WHERE date_emission BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59'
         AND user_id = '0198eaa8-2f34-700a-8d7e-3d649d1322c7'
        GROUP BY mois
        ORDER BY mois DESC
        ;

SELECT
  MONTH(date_signal_panne) AS mois,
  COUNT(id) AS total,
  SUM(
    CASE WHEN status = 'VALIDEE' THEN
      1
    ELSE
      0
    END
  ) AS validees,
  SUM(
    CASE WHEN status = 'REJETEE' THEN
      1
    ELSE
      0
    END
  ) AS rejetees
FROM
  demande
WHERE
  YEAR(date_signal_panne) = :annee
  AND date_signal_panne BETWEEN :startDate
  AND :endDate
  AND user_id = :userId
GROUP BY
  mois
ORDER BY
  mois ASC

SELECT 
            MONTH(date_signal_panne) AS mois,
            COUNT(id) AS total,
            SUM(CASE WHEN status = 'VALIDEE' THEN 1 ELSE 0 END) AS validees,
            SUM(CASE WHEN status = 'REJETEE' THEN 1 ELSE 0 END) AS rejetees
        FROM demande
        WHERE YEAR(date_signal_panne) = '2026'
     AND date_signal_panne BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59' AND user_id = '0198eaa8-2f34-700a-8d7e-3d649d1322c7'
        GROUP BY mois
        ORDER BY mois ASC
    ;

SELECT
  d0_.id AS id_0,
  d0_.description_panne AS description_panne_1,
  d0_.motif_rejet AS motif_rejet_2,
  d0_.status AS status_3,
  d0_.date_constat AS date_constat_4,
  d0_.date_signal_panne AS date_signal_panne_5,
  d0_.service_concerne AS service_concerne_6,
  d0_.quantite AS quantite_7,
  d0_.created_at AS created_at_8,
  d0_.updated_at AS updated_at_9,
  d0_.deleted_at AS deleted_at_10,
  d0_.created_by AS created_by_11,
  d0_.updated_by AS updated_by_12,
  d0_.validateur_realisee_id AS validateur_realisee_id_13,
  d0_.validateur_pris_en_compte_id AS validateur_pris_en_compte_id_14,
  d0_.rejeter_par_id AS rejeter_par_id_15,
  d0_.user_id AS user_id_16,
  d0_.equipement_id AS equipement_id_17,
  d0_.produit_id AS produit_id_18
FROM
  demande d0_
WHERE
  d0_.user_id = ?
  AND (
    d0_.created_at BETWEEN ?
    AND ?
  )
ORDER BY
  d0_.created_at DESC
LIMIT
  3

SELECT d0_.id AS id_0, d0_.description_panne AS description_panne_1, d0_.motif_rejet AS motif_rejet_2, d0_.status AS status_3, d0_.date_constat AS date_constat_4, d0_.date_signal_panne AS date_signal_panne_5, d0_.service_concerne AS service_concerne_6, d0_.quantite AS quantite_7, d0_.created_at AS created_at_8, d0_.updated_at AS updated_at_9, d0_.deleted_at AS deleted_at_10, d0_.created_by AS created_by_11, d0_.updated_by AS updated_by_12, d0_.validateur_realisee_id AS validateur_realisee_id_13, d0_.validateur_pris_en_compte_id AS validateur_pris_en_compte_id_14, d0_.rejeter_par_id AS rejeter_par_id_15, d0_.user_id AS user_id_16, d0_.equipement_id AS equipement_id_17, d0_.produit_id AS produit_id_18 FROM demande d0_ WHERE d0_.user_id = '0198eaa8-2f34-700a-8d7e-3d649d1322c7' AND (d0_.created_at BETWEEN '2025-08-11 00:00:00' AND '2026-02-11 23:59:59') ORDER BY d0_.created_at DESC LIMIT 3;