Symfony Profiler

[
  "route" => "app_import_text_confirm"
  "route_parameters" => [
    "_route" => "app_import_text_confirm"
    "_controller" => "App\Controller\ImportController::importTextConfirm"
  ]
  "request_uri" => "https://bcc-flex.dynamservices.com/import/text/confirm"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => "3306"
    "dbname" => "db_bccflex_core2"
    "user" => "root"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "use_savepoints" => true
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "serverVersion" => "8.0.32"
    "defaultTableOptions" => []
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "admin@bcc.cd"
]

[
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-04-27"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2 FROM banques t0 WHERE t0.nom = ? LIMIT 1"
  "params" => [
    1 => "UBA"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
    2 => "VENTE"
    3 => 10
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2 FROM banques t0 WHERE t0.nom = ? LIMIT 1"
  "params" => [
    1 => "BGFIBANK"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
    2 => "ACHAT"
    3 => 7
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO conjoncture_jour (date_situation, date_applicable, commentaire) VALUES (?, ?, ?)"
  "params" => [
    1 => "2026-04-27"
    2 => "2026-04-28"
    3 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "INSERT INTO marche_changes (cours_indicatif, parallele_achat, parallele_vente, ecart_indic_parallele, conjoncture_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "2303.6702"
    2 => "2327.5"
    3 => "2347.13"
    4 => "33.6448"
    5 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
  ]
]

[
  "sql" => "INSERT INTO transactions_usd (type_transaction, cours, volume_usd, conjoncture_id, banque_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "VENTE"
    2 => "2366.94"
    3 => "579676.51"
    4 => 52
    5 => 10
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "INSERT INTO transactions_usd (type_transaction, cours, volume_usd, conjoncture_id, banque_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "ACHAT"
    2 => "2325.3003"
    3 => "2154326.95"
    4 => 52
    5 => 7
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 1
  ]
]

[
  "sql" => "INSERT INTO reserves_financieres (reserves_internationales_usd, avoirs_externes_usd, reserves_banques_cdf, avoirs_libres_cdf, conjoncture_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "7796.27"
    2 => "8926.38"
    3 => "4693.71"
    4 => "2633.13"
    5 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
  ]
]

[
  "sql" => "INSERT INTO encours_bcc (encours_ot_bcc, encours_b_bcc, taux_interbancaire, taux_moyen_pondere_bbcc, billets_en_circulation, conjoncture_id) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "873.06"
    2 => "1475"
    3 => null
    4 => "6.4"
    5 => "6486.96"
    6 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 1
  ]
]

[
  "sql" => "INSERT INTO finances_publiques (recettes_totales, recettes_fiscales, autres_recettes, depenses_totales, solde, conjoncture_id) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "2399.22"
    2 => "1970.94"
    3 => "428.28"
    4 => "2464.18"
    5 => "-64.96"
    6 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 1
  ]
]

[
  "sql" => "INSERT INTO tresorerie_etat (solde_avant_fin, solde_apres_fin, solde_cumule_annee, solde_cgt, depenses_urgence, excedent, reserve_sous_titres, conjoncture_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "-54.1"
    2 => "300.55"
    3 => "58.92"
    4 => "2780.27"
    5 => "-2585.89"
    6 => "6.47"
    7 => "106.15"
    8 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
  ]
]

[
  "sql" => "INSERT INTO titres_publics (encours_otindex, encours_btindex, encours_ot_usd, encours_bt_usd, conjoncture_id) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "1109.33"
    2 => null
    3 => "2131.45"
    4 => "258.49"
    5 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
  ]
]

[
  "sql" => "INSERT INTO paie_etat (montant_total, montant_paye, montant_restant, conjoncture_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "1265.57"
    2 => "242.09"
    3 => null
    4 => 52
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
  ]
]

[
  "sql" => "DELETE FROM alerte_change WHERE conjoncture_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => 52
    2 => 1
    3 => "33.6448"
    4 => "ALERTE"
    5 => "2026-04-28 08:37:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => 52
    2 => 2
    3 => "2633.13"
    4 => "ALERTE"
    5 => "2026-04-28 08:37:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => 52
    2 => 3
    3 => "7796.27"
    4 => "NORMAL"
    5 => "2026-04-28 08:37:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => 52
    2 => 4
    3 => "-64.96"
    4 => "VIGILANCE"
    5 => "2026-04-28 08:37:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => 52
    2 => 5
    3 => "2303.6702"
    4 => "NORMAL"
    5 => "2026-04-28 08:37:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "sql" => "SELECT SUM(t0_.volume_usd) AS sclr_0 FROM transactions_usd t0_ WHERE t0_.conjoncture_id = ?"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO alerte_change (conjoncture_id, indicateur_id, valeur, statut, created_at) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => 52
    2 => 6
    3 => "2734003.46"
    4 => "NORMAL"
    5 => "2026-04-28 08:37:36"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
  ]
]

[
  "conjoncture_id" => 52
  "date_situation" => "2026-04-27"
  "source" => "text_import"
]

[
  "key" => "_security_main"
]