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.prenom AS prenom_6
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.prenom AS prenom_6 FROM `user` t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.date_situation AS date_situation_2,
  t0.date_applicable AS date_applicable_3,
  t0.commentaire AS commentaire_4
FROM
  conjoncture_jour t0
WHERE
  t0.date_situation = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_situation AS date_situation_2, t0.date_applicable AS date_applicable_3, t0.commentaire AS commentaire_4 FROM conjoncture_jour t0 WHERE t0.date_situation = '2026-04-27' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cours_indicatif AS cours_indicatif_2,
  t0.parallele_achat AS parallele_achat_3,
  t0.parallele_vente AS parallele_vente_4,
  t0.ecart_indic_parallele AS ecart_indic_parallele_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  marche_changes t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cours_indicatif AS cours_indicatif_2, t0.parallele_achat AS parallele_achat_3, t0.parallele_vente AS parallele_vente_4, t0.ecart_indic_parallele AS ecart_indic_parallele_5, t0.conjoncture_id AS conjoncture_id_6 FROM marche_changes t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  banques t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM banques t0 WHERE t0.nom = 'UBA' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type_transaction AS type_transaction_2,
  t0.cours AS cours_3,
  t0.volume_usd AS volume_usd_4,
  t0.conjoncture_id AS conjoncture_id_5,
  t0.banque_id AS banque_id_6
FROM
  transactions_usd t0
WHERE
  t0.conjoncture_id = ?
  AND t0.type_transaction = ?
  AND t0.banque_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_transaction AS type_transaction_2, t0.cours AS cours_3, t0.volume_usd AS volume_usd_4, t0.conjoncture_id AS conjoncture_id_5, t0.banque_id AS banque_id_6 FROM transactions_usd t0 WHERE t0.conjoncture_id = NULL AND t0.type_transaction = 'VENTE' AND t0.banque_id = 10 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  banques t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM banques t0 WHERE t0.nom = 'BGFIBANK' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type_transaction AS type_transaction_2,
  t0.cours AS cours_3,
  t0.volume_usd AS volume_usd_4,
  t0.conjoncture_id AS conjoncture_id_5,
  t0.banque_id AS banque_id_6
FROM
  transactions_usd t0
WHERE
  t0.conjoncture_id = ?
  AND t0.type_transaction = ?
  AND t0.banque_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_transaction AS type_transaction_2, t0.cours AS cours_3, t0.volume_usd AS volume_usd_4, t0.conjoncture_id AS conjoncture_id_5, t0.banque_id AS banque_id_6 FROM transactions_usd t0 WHERE t0.conjoncture_id = NULL AND t0.type_transaction = 'ACHAT' AND t0.banque_id = 7 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.reserves_internationales_usd AS reserves_internationales_usd_2,
  t0.avoirs_externes_usd AS avoirs_externes_usd_3,
  t0.reserves_banques_cdf AS reserves_banques_cdf_4,
  t0.avoirs_libres_cdf AS avoirs_libres_cdf_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  reserves_financieres t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reserves_internationales_usd AS reserves_internationales_usd_2, t0.avoirs_externes_usd AS avoirs_externes_usd_3, t0.reserves_banques_cdf AS reserves_banques_cdf_4, t0.avoirs_libres_cdf AS avoirs_libres_cdf_5, t0.conjoncture_id AS conjoncture_id_6 FROM reserves_financieres t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.encours_ot_bcc AS encours_ot_bcc_2,
  t0.encours_b_bcc AS encours_b_bcc_3,
  t0.taux_interbancaire AS taux_interbancaire_4,
  t0.taux_moyen_pondere_bbcc AS taux_moyen_pondere_bbcc_5,
  t0.billets_en_circulation AS billets_en_circulation_6,
  t0.conjoncture_id AS conjoncture_id_7
FROM
  encours_bcc t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.encours_ot_bcc AS encours_ot_bcc_2, t0.encours_b_bcc AS encours_b_bcc_3, t0.taux_interbancaire AS taux_interbancaire_4, t0.taux_moyen_pondere_bbcc AS taux_moyen_pondere_bbcc_5, t0.billets_en_circulation AS billets_en_circulation_6, t0.conjoncture_id AS conjoncture_id_7 FROM encours_bcc t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.recettes_totales AS recettes_totales_2,
  t0.recettes_fiscales AS recettes_fiscales_3,
  t0.autres_recettes AS autres_recettes_4,
  t0.depenses_totales AS depenses_totales_5,
  t0.solde AS solde_6,
  t0.conjoncture_id AS conjoncture_id_7
FROM
  finances_publiques t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.recettes_totales AS recettes_totales_2, t0.recettes_fiscales AS recettes_fiscales_3, t0.autres_recettes AS autres_recettes_4, t0.depenses_totales AS depenses_totales_5, t0.solde AS solde_6, t0.conjoncture_id AS conjoncture_id_7 FROM finances_publiques t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.solde_avant_fin AS solde_avant_fin_2,
  t0.solde_apres_fin AS solde_apres_fin_3,
  t0.solde_cumule_annee AS solde_cumule_annee_4,
  t0.solde_cgt AS solde_cgt_5,
  t0.depenses_urgence AS depenses_urgence_6,
  t0.excedent AS excedent_7,
  t0.reserve_sous_titres AS reserve_sous_titres_8,
  t0.conjoncture_id AS conjoncture_id_9
FROM
  tresorerie_etat t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.solde_avant_fin AS solde_avant_fin_2, t0.solde_apres_fin AS solde_apres_fin_3, t0.solde_cumule_annee AS solde_cumule_annee_4, t0.solde_cgt AS solde_cgt_5, t0.depenses_urgence AS depenses_urgence_6, t0.excedent AS excedent_7, t0.reserve_sous_titres AS reserve_sous_titres_8, t0.conjoncture_id AS conjoncture_id_9 FROM tresorerie_etat t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.encours_otindex AS encours_otindex_2,
  t0.encours_btindex AS encours_btindex_3,
  t0.encours_ot_usd AS encours_ot_usd_4,
  t0.encours_bt_usd AS encours_bt_usd_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  titres_publics t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.encours_otindex AS encours_otindex_2, t0.encours_btindex AS encours_btindex_3, t0.encours_ot_usd AS encours_ot_usd_4, t0.encours_bt_usd AS encours_bt_usd_5, t0.conjoncture_id AS conjoncture_id_6 FROM titres_publics t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.montant_total AS montant_total_2,
  t0.montant_paye AS montant_paye_3,
  t0.montant_restant AS montant_restant_4,
  t0.conjoncture_id AS conjoncture_id_5
FROM
  paie_etat t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.montant_total AS montant_total_2, t0.montant_paye AS montant_paye_3, t0.montant_restant AS montant_restant_4, t0.conjoncture_id AS conjoncture_id_5 FROM paie_etat t0 WHERE t0.conjoncture_id = NULL LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO conjoncture_jour (
  date_situation, date_applicable,
  commentaire
)
VALUES
  (?, ?, ?)

INSERT INTO conjoncture_jour (date_situation, date_applicable, commentaire) VALUES ('2026-04-27', '2026-04-28', NULL);

INSERT INTO marche_changes (
  cours_indicatif, parallele_achat,
  parallele_vente, ecart_indic_parallele,
  conjoncture_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO marche_changes (cours_indicatif, parallele_achat, parallele_vente, ecart_indic_parallele, conjoncture_id) VALUES ('2303.6702', '2327.5', '2347.13', '33.6448', 52);

INSERT INTO transactions_usd (
  type_transaction, cours, volume_usd,
  conjoncture_id, banque_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO transactions_usd (type_transaction, cours, volume_usd, conjoncture_id, banque_id) VALUES ('VENTE', '2366.94', '579676.51', 52, 10);

INSERT INTO transactions_usd (
  type_transaction, cours, volume_usd,
  conjoncture_id, banque_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO transactions_usd (type_transaction, cours, volume_usd, conjoncture_id, banque_id) VALUES ('ACHAT', '2325.3003', '2154326.95', 52, 7);

INSERT INTO reserves_financieres (
  reserves_internationales_usd, avoirs_externes_usd,
  reserves_banques_cdf, avoirs_libres_cdf,
  conjoncture_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO reserves_financieres (reserves_internationales_usd, avoirs_externes_usd, reserves_banques_cdf, avoirs_libres_cdf, conjoncture_id) VALUES ('7796.27', '8926.38', '4693.71', '2633.13', 52);

INSERT INTO encours_bcc (
  encours_ot_bcc, encours_b_bcc, taux_interbancaire,
  taux_moyen_pondere_bbcc, billets_en_circulation,
  conjoncture_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO encours_bcc (encours_ot_bcc, encours_b_bcc, taux_interbancaire, taux_moyen_pondere_bbcc, billets_en_circulation, conjoncture_id) VALUES ('873.06', '1475', NULL, '6.4', '6486.96', 52);

INSERT INTO finances_publiques (
  recettes_totales, recettes_fiscales,
  autres_recettes, depenses_totales,
  solde, conjoncture_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO finances_publiques (recettes_totales, recettes_fiscales, autres_recettes, depenses_totales, solde, conjoncture_id) VALUES ('2399.22', '1970.94', '428.28', '2464.18', '-64.96', 52);

INSERT INTO tresorerie_etat (
  solde_avant_fin, solde_apres_fin,
  solde_cumule_annee, solde_cgt, depenses_urgence,
  excedent, reserve_sous_titres, conjoncture_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO tresorerie_etat (solde_avant_fin, solde_apres_fin, solde_cumule_annee, solde_cgt, depenses_urgence, excedent, reserve_sous_titres, conjoncture_id) VALUES ('-54.1', '300.55', '58.92', '2780.27', '-2585.89', '6.47', '106.15', 52);

INSERT INTO titres_publics (
  encours_otindex, encours_btindex,
  encours_ot_usd, encours_bt_usd,
  conjoncture_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO titres_publics (encours_otindex, encours_btindex, encours_ot_usd, encours_bt_usd, conjoncture_id) VALUES ('1109.33', NULL, '2131.45', '258.49', 52);

INSERT INTO paie_etat (
  montant_total, montant_paye, montant_restant,
  conjoncture_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO paie_etat (montant_total, montant_paye, montant_restant, conjoncture_id) VALUES ('1265.57', '242.09', NULL, 52);

"COMMIT"

"COMMIT";

DELETE FROM
  alerte_change
WHERE
  conjoncture_id = ?

DELETE FROM alerte_change WHERE conjoncture_id = 52;

SELECT
  i0_.id AS id_0,
  i0_.code AS code_1,
  i0_.nom AS nom_2,
  i0_.unite AS unite_3,
  i0_.description AS description_4,
  i0_.type AS type_5,
  r1_.id AS id_6,
  r1_.seuil_alerte AS seuil_alerte_7,
  r1_.seuil_intervention AS seuil_intervention_8,
  r1_.sens AS sens_9,
  r1_.poids AS poids_10,
  r1_.actif AS actif_11,
  r1_.indicateur_id AS indicateur_id_12
FROM
  indicateur i0_
  LEFT JOIN regle_intervention r1_ ON i0_.id = r1_.indicateur_id
WHERE
  r1_.actif = ?

SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.nom AS nom_2, i0_.unite AS unite_3, i0_.description AS description_4, i0_.type AS type_5, r1_.id AS id_6, r1_.seuil_alerte AS seuil_alerte_7, r1_.seuil_intervention AS seuil_intervention_8, r1_.sens AS sens_9, r1_.poids AS poids_10, r1_.actif AS actif_11, r1_.indicateur_id AS indicateur_id_12 FROM indicateur i0_ LEFT JOIN regle_intervention r1_ ON i0_.id = r1_.indicateur_id WHERE r1_.actif = 1;

SELECT
  t0.id AS id_1,
  t0.cours_indicatif AS cours_indicatif_2,
  t0.parallele_achat AS parallele_achat_3,
  t0.parallele_vente AS parallele_vente_4,
  t0.ecart_indic_parallele AS ecart_indic_parallele_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  marche_changes t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cours_indicatif AS cours_indicatif_2, t0.parallele_achat AS parallele_achat_3, t0.parallele_vente AS parallele_vente_4, t0.ecart_indic_parallele AS ecart_indic_parallele_5, t0.conjoncture_id AS conjoncture_id_6 FROM marche_changes t0 WHERE t0.conjoncture_id = 52 LIMIT 1;

INSERT INTO alerte_change (
  conjoncture_id, indicateur_id, valeur,
  statut, created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (52, 1, '33.6448', 'ALERTE', '2026-04-28 08:37:36');

SELECT
  t0.id AS id_1,
  t0.reserves_internationales_usd AS reserves_internationales_usd_2,
  t0.avoirs_externes_usd AS avoirs_externes_usd_3,
  t0.reserves_banques_cdf AS reserves_banques_cdf_4,
  t0.avoirs_libres_cdf AS avoirs_libres_cdf_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  reserves_financieres t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reserves_internationales_usd AS reserves_internationales_usd_2, t0.avoirs_externes_usd AS avoirs_externes_usd_3, t0.reserves_banques_cdf AS reserves_banques_cdf_4, t0.avoirs_libres_cdf AS avoirs_libres_cdf_5, t0.conjoncture_id AS conjoncture_id_6 FROM reserves_financieres t0 WHERE t0.conjoncture_id = 52 LIMIT 1;

INSERT INTO alerte_change (
  conjoncture_id, indicateur_id, valeur,
  statut, created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (52, 2, '2633.13', 'ALERTE', '2026-04-28 08:37:36');

SELECT
  t0.id AS id_1,
  t0.reserves_internationales_usd AS reserves_internationales_usd_2,
  t0.avoirs_externes_usd AS avoirs_externes_usd_3,
  t0.reserves_banques_cdf AS reserves_banques_cdf_4,
  t0.avoirs_libres_cdf AS avoirs_libres_cdf_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  reserves_financieres t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reserves_internationales_usd AS reserves_internationales_usd_2, t0.avoirs_externes_usd AS avoirs_externes_usd_3, t0.reserves_banques_cdf AS reserves_banques_cdf_4, t0.avoirs_libres_cdf AS avoirs_libres_cdf_5, t0.conjoncture_id AS conjoncture_id_6 FROM reserves_financieres t0 WHERE t0.conjoncture_id = 52 LIMIT 1;

INSERT INTO alerte_change (
  conjoncture_id, indicateur_id, valeur,
  statut, created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (52, 3, '7796.27', 'NORMAL', '2026-04-28 08:37:36');

SELECT
  t0.id AS id_1,
  t0.recettes_totales AS recettes_totales_2,
  t0.recettes_fiscales AS recettes_fiscales_3,
  t0.autres_recettes AS autres_recettes_4,
  t0.depenses_totales AS depenses_totales_5,
  t0.solde AS solde_6,
  t0.conjoncture_id AS conjoncture_id_7
FROM
  finances_publiques t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.recettes_totales AS recettes_totales_2, t0.recettes_fiscales AS recettes_fiscales_3, t0.autres_recettes AS autres_recettes_4, t0.depenses_totales AS depenses_totales_5, t0.solde AS solde_6, t0.conjoncture_id AS conjoncture_id_7 FROM finances_publiques t0 WHERE t0.conjoncture_id = 52 LIMIT 1;

INSERT INTO alerte_change (
  conjoncture_id, indicateur_id, valeur,
  statut, created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (52, 4, '-64.96', 'VIGILANCE', '2026-04-28 08:37:36');

SELECT
  t0.id AS id_1,
  t0.cours_indicatif AS cours_indicatif_2,
  t0.parallele_achat AS parallele_achat_3,
  t0.parallele_vente AS parallele_vente_4,
  t0.ecart_indic_parallele AS ecart_indic_parallele_5,
  t0.conjoncture_id AS conjoncture_id_6
FROM
  marche_changes t0
WHERE
  t0.conjoncture_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cours_indicatif AS cours_indicatif_2, t0.parallele_achat AS parallele_achat_3, t0.parallele_vente AS parallele_vente_4, t0.ecart_indic_parallele AS ecart_indic_parallele_5, t0.conjoncture_id AS conjoncture_id_6 FROM marche_changes t0 WHERE t0.conjoncture_id = 52 LIMIT 1;