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 <= 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_.solde AS solde_1,
  a0_.period AS period_2,
  a0_.caisse_id AS caisse_id_3,
  a0_.devise_id AS devise_id_4
FROM
  account_balance a0_
WHERE
  a0_.caisse_id = ?
  AND a0_.devise_id = ?
  AND a0_.period <= ?
ORDER BY
  a0_.period DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.solde AS solde_1, a0_.period AS period_2, a0_.caisse_id AS caisse_id_3, a0_.devise_id AS devise_id_4 FROM account_balance a0_ WHERE a0_.caisse_id = 1 AND a0_.devise_id = 1 AND a0_.period <= '2026-04-17 00:00:00' ORDER BY a0_.period DESC LIMIT 1;

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
  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';

"COMMIT"

"COMMIT";

SELECT
  a0_.id AS id_0,
  a0_.solde AS solde_1,
  a0_.period AS period_2,
  a0_.caisse_id AS caisse_id_3,
  a0_.devise_id AS devise_id_4
FROM
  account_balance a0_
WHERE
  a0_.caisse_id = ?
  AND a0_.devise_id = ?
  AND a0_.period >= ?
ORDER BY
  a0_.period ASC

SELECT a0_.id AS id_0, a0_.solde AS solde_1, a0_.period AS period_2, a0_.caisse_id AS caisse_id_3, a0_.devise_id AS devise_id_4 FROM account_balance a0_ WHERE a0_.caisse_id = 1 AND a0_.devise_id = 1 AND a0_.period >= '2026-04-17 00:00:00' ORDER BY a0_.period ASC;

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

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

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.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;

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

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

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;

INSERT INTO mouvement (
  date_create, date_operation, motif,
  is_deleted, date_modification, nom_partenaire,
  nom_ouvrier, type_operation, montant_operation,
  numero_piece, piece_comptable, caisse_id,
  user_create_id, devise_id, rapport_id,
  compte_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO mouvement (date_create, date_operation, motif, is_deleted, date_modification, nom_partenaire, nom_ouvrier, type_operation, montant_operation, numero_piece, piece_comptable, caisse_id, user_create_id, devise_id, rapport_id, compte_id) VALUES ('2026-04-17 12:49:51', '2026-04-17', 'ACHAT FORMULAIRE CPCC, TABLEAU DE REEVALUATION, HOLOGRAMME ET ATTESTATION DE CERTIFICATION', 0, NULL, NULL, NULL, 'DEBIT', '210', 'BSC 007/4', 'WhatsApp-Image-2026-04-17-at-13-39-34-69e22c6fb4a24.jpg', 1, 13, 1, 118, 189);

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;

UPDATE
  account_balance
SET
  solde = ?
WHERE
  id = ?

UPDATE account_balance SET solde = '3063' WHERE id = 223;

"START TRANSACTION"

"START TRANSACTION";