Symfony Profiler

SELECT
  d0_.sigle AS sigle_0,
  m1_.type_operation AS type_operation_1,
  SUM(m1_.montant_operation) AS sclr_2
FROM
  mouvement m1_
  INNER JOIN devise d0_ ON m1_.devise_id = d0_.id
WHERE
  m1_.caisse_id = ?
  AND m1_.type_operation = ?
  AND (
    m1_.date_operation BETWEEN ?
    AND ?
  )
GROUP BY
  d0_.sigle,
  m1_.type_operation

SELECT d0_.sigle AS sigle_0, m1_.type_operation AS type_operation_1, SUM(m1_.montant_operation) AS sclr_2 FROM mouvement m1_ INNER JOIN devise d0_ ON m1_.devise_id = d0_.id WHERE m1_.caisse_id = 1 AND m1_.type_operation = 'DEBIT' AND (m1_.date_operation BETWEEN '2026-04-17 00:00:00' AND '2026-04-17 23:59:59') GROUP BY d0_.sigle, m1_.type_operation;

SELECT
  d.sigle AS devise,
  SUM(ab1.solde) AS totalSolde,
  MAX(ab1.period) as dateDuSolde
FROM
  account_balance ab1
  JOIN devise d ON d.id = ab1.devise_id
  INNER JOIN (
    SELECT
      caisse_id,
      devise_id,
      MAX(period) AS max_date
    FROM
      account_balance
    WHERE
      period <= :fin
      AND caisse_id = :caisse
    GROUP BY
      caisse_id,
      devise_id
  ) ab2 ON ab1.caisse_id = ab2.caisse_id
  AND ab1.devise_id = ab2.devise_id
  AND ab1.period = ab2.max_date
GROUP BY
  ab1.devise_id,
  d.sigle

SELECT d.sigle AS devise, SUM(ab1.solde) AS totalSolde, MAX(ab1.period) as dateDuSolde
        FROM account_balance ab1
        JOIN devise d ON d.id = ab1.devise_id
        INNER JOIN (
            SELECT caisse_id, devise_id, MAX(period) AS max_date
            FROM account_balance
            WHERE period <= '2026-04-17' AND caisse_id =1
            GROUP BY caisse_id, devise_id
        ) ab2
        ON ab1.caisse_id = ab2.caisse_id
        AND ab1.devise_id = ab2.devise_id
        AND ab1.period = ab2.max_date
        GROUP BY ab1.devise_id, d.sigle;

SELECT
  d.sigle AS devise,
  SUM(ab1.solde) AS totalSolde,
  MAX(ab1.period) as dateDuSolde
FROM
  account_balance ab1
  JOIN devise d ON d.id = ab1.devise_id
  INNER JOIN (
    SELECT
      caisse_id,
      devise_id,
      MAX(period) AS max_date
    FROM
      account_balance
    WHERE
      period <= DATE_SUB(:date, INTERVAL 1 DAY)
      AND caisse_id = :caisse
    GROUP BY
      caisse_id,
      devise_id
  ) ab2 ON ab1.caisse_id = ab2.caisse_id
  AND ab1.devise_id = ab2.devise_id
  AND ab1.period = ab2.max_date
GROUP BY
  ab1.devise_id,
  d.sigle

SELECT d.sigle AS devise, SUM(ab1.solde) AS totalSolde, MAX(ab1.period) as dateDuSolde
        FROM account_balance ab1
        JOIN devise d ON d.id = ab1.devise_id
        INNER JOIN (
            SELECT caisse_id, devise_id, MAX(period) AS max_date
            FROM account_balance
            WHERE period <= DATE_SUB('2026-04-17', INTERVAL 1 DAY) AND caisse_id =1
            GROUP BY caisse_id, devise_id
        ) ab2
        ON ab1.caisse_id = ab2.caisse_id
        AND ab1.devise_id = ab2.devise_id
        AND ab1.period = ab2.max_date
        GROUP BY ab1.devise_id, d.sigle;

SELECT
  a0_.id AS id_0,
  a0_.account_number AS account_number_1,
  a0_.account_name AS account_name_2,
  a0_.description AS description_3,
  a0_.account_class AS account_class_4,
  a0_.account_type AS account_type_5,
  a0_.is_active AS is_active_6,
  a0_.created_at AS created_at_7,
  a0_.is_deleted AS is_deleted_8,
  a0_.is_visible_for_caisse AS is_visible_for_caisse_9,
  a0_.parent_account_id AS parent_account_id_10
FROM
  accounts a0_

SELECT a0_.id AS id_0, a0_.account_number AS account_number_1, a0_.account_name AS account_name_2, a0_.description AS description_3, a0_.account_class AS account_class_4, a0_.account_type AS account_type_5, a0_.is_active AS is_active_6, a0_.created_at AS created_at_7, a0_.is_deleted AS is_deleted_8, a0_.is_visible_for_caisse AS is_visible_for_caisse_9, a0_.parent_account_id AS parent_account_id_10 FROM accounts a0_;

SELECT
  d0_.id AS id_0,
  d0_.intitule AS intitule_1,
  d0_.sigle AS sigle_2,
  d0_.symbole AS symbole_3,
  d0_.deleted AS deleted_4,
  d0_.is_default AS is_default_5,
  d0_.is_local AS is_local_6
FROM
  devise d0_

SELECT d0_.id AS id_0, d0_.intitule AS intitule_1, d0_.sigle AS sigle_2, d0_.symbole AS symbole_3, d0_.deleted AS deleted_4, d0_.is_default AS is_default_5, d0_.is_local AS is_local_6 FROM devise d0_;

SELECT
  t0.id AS id_1,
  t0.date_create AS date_create_2,
  t0.date_operation AS date_operation_3,
  t0.motif AS motif_4,
  t0.is_deleted AS is_deleted_5,
  t0.date_modification AS date_modification_6,
  t0.nom_partenaire AS nom_partenaire_7,
  t0.nom_ouvrier AS nom_ouvrier_8,
  t0.type_operation AS type_operation_9,
  t0.montant_operation AS montant_operation_10,
  t0.numero_piece AS numero_piece_11,
  t0.piece_comptable AS piece_comptable_12,
  t0.caisse_id AS caisse_id_13,
  t0.user_create_id AS user_create_id_14,
  t0.devise_id AS devise_id_15,
  t0.rapport_id AS rapport_id_16,
  t0.compte_id AS compte_id_17
FROM
  mouvement t0
WHERE
  t0.rapport_id = ?

SELECT t0.id AS id_1, t0.date_create AS date_create_2, t0.date_operation AS date_operation_3, t0.motif AS motif_4, t0.is_deleted AS is_deleted_5, t0.date_modification AS date_modification_6, t0.nom_partenaire AS nom_partenaire_7, t0.nom_ouvrier AS nom_ouvrier_8, t0.type_operation AS type_operation_9, t0.montant_operation AS montant_operation_10, t0.numero_piece AS numero_piece_11, t0.piece_comptable AS piece_comptable_12, t0.caisse_id AS caisse_id_13, t0.user_create_id AS user_create_id_14, t0.devise_id AS devise_id_15, t0.rapport_id AS rapport_id_16, t0.compte_id AS compte_id_17 FROM mouvement t0 WHERE t0.rapport_id = '118';

SELECT
  t0.id AS id_1,
  t0.date_rapport AS date_rapport_2,
  t0.created_at AS created_at_3,
  t0.solde_precedent AS solde_precedent_4,
  t0.total_credit AS total_credit_5,
  t0.total_debit AS total_debit_6,
  t0.solde AS solde_7,
  t0.statut AS statut_8,
  t0.is_deleted AS is_deleted_9,
  t0.caisse_id AS caisse_id_10,
  t0.created_by_id AS created_by_id_11,
  t0.devise_id AS devise_id_12
FROM
  rapport_caisse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_rapport AS date_rapport_2, t0.created_at AS created_at_3, t0.solde_precedent AS solde_precedent_4, t0.total_credit AS total_credit_5, t0.total_debit AS total_debit_6, t0.solde AS solde_7, t0.statut AS statut_8, t0.is_deleted AS is_deleted_9, t0.caisse_id AS caisse_id_10, t0.created_by_id AS created_by_id_11, t0.devise_id AS devise_id_12 FROM rapport_caisse t0 WHERE t0.id = '118';

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.sigle AS sigle_3,
  t0.symbole AS symbole_4,
  t0.deleted AS deleted_5,
  t0.is_default AS is_default_6,
  t0.is_local AS is_local_7
FROM
  devise t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.sigle AS sigle_3, t0.symbole AS symbole_4, t0.deleted AS deleted_5, t0.is_default AS is_default_6, t0.is_local AS is_local_7 FROM devise t0 WHERE t0.is_default = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.state AS state_2,
  t0.numerocaisse AS numerocaisse_3,
  t0.intitule AS intitule_4,
  t0.is_main AS is_main_5,
  t0.user_id AS user_id_6
FROM
  caisse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.state AS state_2, t0.numerocaisse AS numerocaisse_3, t0.intitule AS intitule_4, t0.is_main AS is_main_5, t0.user_id AS user_id_6 FROM caisse t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.sigle AS sigle_3,
  t0.symbole AS symbole_4,
  t0.deleted AS deleted_5,
  t0.is_default AS is_default_6,
  t0.is_local AS is_local_7
FROM
  devise t0

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.sigle AS sigle_3, t0.symbole AS symbole_4, t0.deleted AS deleted_5, t0.is_default AS is_default_6, t0.is_local AS is_local_7 FROM devise t0;

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.is_active AS is_active_7,
  t0.created_at AS created_at_8,
  t0.point_de_vente_id AS point_de_vente_id_9
FROM
  users 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.is_active AS is_active_7, t0.created_at AS created_at_8, t0.point_de_vente_id AS point_de_vente_id_9 FROM users t0 WHERE t0.id = 13;