Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenoms AS prenoms_4,
  t0.telephone AS telephone_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.is_active AS is_active_8,
  t0.is_email_auth_enabled AS is_email_auth_enabled_9,
  t0.is_sms_auth_enabled AS is_sms_auth_enabled_10,
  t0.auth_code AS auth_code_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.avatar AS avatar_14,
  t0.push_token AS push_token_15,
  t0.push_subscription AS push_subscription_16,
  t0.must_change_password AS must_change_password_17,
  t0.agence_id AS agence_id_18,
  t0.service_transfert_id AS service_transfert_id_19,
  t20.id AS id_21,
  t20.nom AS nom_22,
  t20.prenoms AS prenoms_23,
  t20.contact AS contact_24,
  t20.email AS email_25,
  t20.registre_commerce AS registre_commerce_26,
  t20.profession AS profession_27,
  t20.created_at AS created_at_28,
  t20.ifu AS ifu_29,
  t20.code_client AS code_client_30,
  t20.created_by_id AS created_by_id_31,
  t20.agence_id AS agence_id_32,
  t20.user_id AS user_id_33
FROM
  user t0
  LEFT JOIN client t20 ON t20.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenoms AS prenoms_4, t0.telephone AS telephone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.is_email_auth_enabled AS is_email_auth_enabled_9, t0.is_sms_auth_enabled AS is_sms_auth_enabled_10, t0.auth_code AS auth_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.avatar AS avatar_14, t0.push_token AS push_token_15, t0.push_subscription AS push_subscription_16, t0.must_change_password AS must_change_password_17, t0.agence_id AS agence_id_18, t0.service_transfert_id AS service_transfert_id_19, t20.id AS id_21, t20.nom AS nom_22, t20.prenoms AS prenoms_23, t20.contact AS contact_24, t20.email AS email_25, t20.registre_commerce AS registre_commerce_26, t20.profession AS profession_27, t20.created_at AS created_at_28, t20.ifu AS ifu_29, t20.code_client AS code_client_30, t20.created_by_id AS created_by_id_31, t20.agence_id AS agence_id_32, t20.user_id AS user_id_33 FROM user t0 LEFT JOIN client t20 ON t20.user_id = t0.id WHERE t0.email = 'zantoinette@retouralasourcefx.com' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.date_debut AS date_debut_1,
  a0_.is_active AS is_active_2,
  a0_.is_appro_initial_valide AS is_appro_initial_valide_3,
  a0_.date_fin AS date_fin_4,
  a0_.caissier_id AS caissier_id_5,
  a0_.caisse_id AS caisse_id_6
FROM
  affectation_caisse a0_
WHERE
  a0_.caissier_id = ?
  AND a0_.is_active = ?
  AND a0_.date_debut <= ?
  AND (
    a0_.date_fin IS NULL
    OR a0_.date_fin >= ?
  )
ORDER BY
  a0_.date_debut DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.is_active AS is_active_2, a0_.is_appro_initial_valide AS is_appro_initial_valide_3, a0_.date_fin AS date_fin_4, a0_.caissier_id AS caissier_id_5, a0_.caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_.caissier_id = 20 AND a0_.is_active = 1 AND a0_.date_debut <= '2026-07-31 13:02:33' AND (a0_.date_fin IS NULL OR a0_.date_fin >= '2026-07-31 13:02:33') ORDER BY a0_.date_debut DESC LIMIT 1;

DELETE FROM
  user_sessions
WHERE
  last_activity < ?

DELETE FROM user_sessions WHERE last_activity < '2026-07-31 12:47:33';

SELECT
  i0_.id AS id_0,
  i0_.key_hash AS key_hash_1,
  i0_.status_code AS status_code_2,
  i0_.response_body AS response_body_3,
  i0_.created_at AS created_at_4
FROM
  idempotency_key i0_
WHERE
  i0_.key_hash = ?
  AND i0_.created_at >= ?

SELECT i0_.id AS id_0, i0_.key_hash AS key_hash_1, i0_.status_code AS status_code_2, i0_.response_body AS response_body_3, i0_.created_at AS created_at_4 FROM idempotency_key i0_ WHERE i0_.key_hash = '3ffcbcfbca9f89f1bdd7b34ebe5ed8c208a2bde20cfbf80069a199f3e644e263' AND i0_.created_at >= '2026-07-31 12:52:33';

SELECT
  a0_.id AS id_0,
  a0_.date_debut AS date_debut_1,
  a0_.is_active AS is_active_2,
  a0_.is_appro_initial_valide AS is_appro_initial_valide_3,
  a0_.date_fin AS date_fin_4,
  a0_.caissier_id AS caissier_id_5,
  a0_.caisse_id AS caisse_id_6
FROM
  affectation_caisse a0_
WHERE
  a0_.caissier_id = ?
  AND a0_.is_active = ?
  AND a0_.date_debut <= ?
  AND (
    a0_.date_fin IS NULL
    OR a0_.date_fin >= ?
  )
ORDER BY
  a0_.date_debut DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.date_debut AS date_debut_1, a0_.is_active AS is_active_2, a0_.is_appro_initial_valide AS is_appro_initial_valide_3, a0_.date_fin AS date_fin_4, a0_.caissier_id AS caissier_id_5, a0_.caisse_id AS caisse_id_6 FROM affectation_caisse a0_ WHERE a0_.caissier_id = 20 AND a0_.is_active = 1 AND a0_.date_debut <= '2026-07-31 13:02:33' AND (a0_.date_fin IS NULL OR a0_.date_fin >= '2026-07-31 13:02:33') ORDER BY a0_.date_debut DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.numero_profil_compte AS numero_profil_compte_2,
  t0.is_actif AS is_actif_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.client_id AS client_id_6,
  t0.type_client_id AS type_client_id_7
FROM
  profil_client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_profil_compte AS numero_profil_compte_2, t0.is_actif AS is_actif_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.client_id AS client_id_6, t0.type_client_id AS type_client_id_7 FROM profil_client t0 WHERE t0.id = '66';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code_iso AS code_iso_3,
  t0.symbole AS symbole_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6
FROM
  devise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_iso AS code_iso_3, t0.symbole AS symbole_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6 FROM devise t0 WHERE t0.id = '4';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  operation o0_
WHERE
  o0_.created_at >= ?
  AND o0_.created_at < ?

SELECT COUNT(o0_.id) AS sclr_0 FROM operation o0_ WHERE o0_.created_at >= '2026-07-31 00:00:00' AND o0_.created_at < '2026-07-31 23:59:59';

SELECT
  t0.id AS id_1,
  t0.numero_bancaire AS numero_bancaire_2,
  t0.solde AS solde_3,
  t0.seuil_alerte AS seuil_alerte_4,
  t0.banque_id AS banque_id_5,
  t0.devise_id AS devise_id_6
FROM
  compte_bancaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numero_bancaire AS numero_bancaire_2, t0.solde AS solde_3, t0.seuil_alerte AS seuil_alerte_4, t0.banque_id AS banque_id_5, t0.devise_id AS devise_id_6 FROM compte_bancaire t0 WHERE t0.id = '5';

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO operation (
  type_operation, type_operation_original,
  status, montant_source, montant_cible,
  taux, sens, created_at, updated_at,
  motif, date_finalisation, nom_deposant,
  contact_deposant, nom_beneficiaire_retrait,
  contact_beneficiaire_retrait, reference,
  commission, commission_incluse,
  client_id, compte_client_source_id,
  compte_client_cible_id, devise_source_id,
  devise_cible_id, agent_id, caisse_id,
  beneficiaire_id, profil_client_id,
  compte_bancaire_id, compte_bancaire_cible_id,
  pret_id, annulation_operation_id,
  service_transfert_id, pays_destination_id,
  devise_commission_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO operation (type_operation, type_operation_original, status, montant_source, montant_cible, taux, sens, created_at, updated_at, motif, date_finalisation, nom_deposant, contact_deposant, nom_beneficiaire_retrait, contact_beneficiaire_retrait, reference, commission, commission_incluse, client_id, compte_client_source_id, compte_client_cible_id, devise_source_id, devise_cible_id, agent_id, caisse_id, beneficiaire_id, profil_client_id, compte_bancaire_id, compte_bancaire_cible_id, pret_id, annulation_operation_id, service_transfert_id, pays_destination_id, devise_commission_id) VALUES ('DEPOT_BANCAIRE', NULL, 'FINALIZED', '18776000', '18776000', '1', 'CREDIT', '2026-07-31 13:02:33', NULL, 'DÉPÔT VIREMENT BANCAIRE DE 18 776 000,00 NGN (CLIENT: CHRIST)', '2026-07-31 13:02:33', 'CHRIS', '0197856312', NULL, NULL, 'REF-20260731-0032', NULL, 0, 66, NULL, NULL, 4, 4, 20, NULL, NULL, 66, 5, NULL, NULL, NULL, NULL, NULL, NULL);

UPDATE
  compte_bancaire
SET
  solde = ?
WHERE
  id = ?

UPDATE compte_bancaire SET solde = '19051878.58' WHERE id = 5;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SELECT
  t0.id AS id_1,
  t0.solde_initial AS solde_initial_2,
  t0.solde_actuel AS solde_actuel_3,
  t0.created_at AS created_at_4,
  t0.devise_id AS devise_id_5,
  t0.profil_client_id AS profil_client_id_6
FROM
  compte_client t0
WHERE
  t0.profil_client_id = ?
  AND t0.devise_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.solde_initial AS solde_initial_2, t0.solde_actuel AS solde_actuel_3, t0.created_at AS created_at_4, t0.devise_id AS devise_id_5, t0.profil_client_id AS profil_client_id_6 FROM compte_client t0 WHERE t0.profil_client_id = 66 AND t0.devise_id = 4 LIMIT 1;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  operation o0_
WHERE
  o0_.created_at >= ?
  AND o0_.created_at < ?
  AND o0_.type_operation = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM operation o0_ WHERE o0_.created_at >= '2026-07-31 00:00:00' AND o0_.created_at < '2026-07-31 23:59:59' AND o0_.type_operation = 'DEPOT_BANCAIRE';

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

INSERT INTO mouvement_compte_bancaire (
  type_mouvement, montant, sens, date_mouvement,
  date_valeur, reference_bancaire,
  nom_deposant, contact_deposant,
  commentaire, compte_bancaire_id,
  devise_id, effectue_par_id, operation_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mouvement_compte_bancaire (type_mouvement, montant, sens, date_mouvement, date_valeur, reference_bancaire, nom_deposant, contact_deposant, commentaire, compte_bancaire_id, devise_id, effectue_par_id, operation_id) VALUES ('DEPOT', '18776000', 'CREDIT', '2026-07-31 13:02:33', '2026-07-31 00:00:00', '', 'CHRIS', '0197856312', 'DÉPÔT VIREMENT BANCAIRE DE 18 776 000,00 NGN (CLIENT: CHRIST)', 5, 4, 20, 9007);

INSERT INTO mouvement_compte_client (
  type_mouvement, montant, sens, date_mouvement,
  reference, compte_client_id, devise_id,
  effectue_par_id, operation_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mouvement_compte_client (type_mouvement, montant, sens, date_mouvement, reference, compte_client_id, devise_id, effectue_par_id, operation_id) VALUES ('DEPOT_BANCAIRE', '18776000', 'CREDIT', '2026-07-31 13:02:33', 'REF-20260731-0032', 459, 4, 20, 9007);

UPDATE
  operation
SET
  reference = ?,
  compte_client_cible_id = ?
WHERE
  id = ?

UPDATE operation SET reference = 'DEP-20260731-0008', compte_client_cible_id = 459 WHERE id = 9007;

UPDATE
  compte_client
SET
  solde_actuel = ?
WHERE
  id = ?

UPDATE compte_client SET solde_actuel = '18776000' WHERE id = 459;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.type_operation AS type_operation_2,
  t0.type_operation_original AS type_operation_original_3,
  t0.status AS status_4,
  t0.montant_source AS montant_source_5,
  t0.montant_cible AS montant_cible_6,
  t0.taux AS taux_7,
  t0.sens AS sens_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.motif AS motif_11,
  t0.date_finalisation AS date_finalisation_12,
  t0.nom_deposant AS nom_deposant_13,
  t0.contact_deposant AS contact_deposant_14,
  t0.nom_beneficiaire_retrait AS nom_beneficiaire_retrait_15,
  t0.contact_beneficiaire_retrait AS contact_beneficiaire_retrait_16,
  t0.reference AS reference_17,
  t0.commission AS commission_18,
  t0.commission_incluse AS commission_incluse_19,
  t0.client_id AS client_id_20,
  t0.compte_client_source_id AS compte_client_source_id_21,
  t0.compte_client_cible_id AS compte_client_cible_id_22,
  t0.devise_source_id AS devise_source_id_23,
  t0.devise_cible_id AS devise_cible_id_24,
  t0.agent_id AS agent_id_25,
  t0.caisse_id AS caisse_id_26,
  t0.beneficiaire_id AS beneficiaire_id_27,
  t0.profil_client_id AS profil_client_id_28,
  t0.compte_bancaire_id AS compte_bancaire_id_29,
  t0.compte_bancaire_cible_id AS compte_bancaire_cible_id_30,
  t0.pret_id AS pret_id_31,
  t0.annulation_operation_id AS annulation_operation_id_32,
  t0.service_transfert_id AS service_transfert_id_33,
  t0.pays_destination_id AS pays_destination_id_34,
  t0.devise_commission_id AS devise_commission_id_35
FROM
  operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_operation AS type_operation_2, t0.type_operation_original AS type_operation_original_3, t0.status AS status_4, t0.montant_source AS montant_source_5, t0.montant_cible AS montant_cible_6, t0.taux AS taux_7, t0.sens AS sens_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.motif AS motif_11, t0.date_finalisation AS date_finalisation_12, t0.nom_deposant AS nom_deposant_13, t0.contact_deposant AS contact_deposant_14, t0.nom_beneficiaire_retrait AS nom_beneficiaire_retrait_15, t0.contact_beneficiaire_retrait AS contact_beneficiaire_retrait_16, t0.reference AS reference_17, t0.commission AS commission_18, t0.commission_incluse AS commission_incluse_19, t0.client_id AS client_id_20, t0.compte_client_source_id AS compte_client_source_id_21, t0.compte_client_cible_id AS compte_client_cible_id_22, t0.devise_source_id AS devise_source_id_23, t0.devise_cible_id AS devise_cible_id_24, t0.agent_id AS agent_id_25, t0.caisse_id AS caisse_id_26, t0.beneficiaire_id AS beneficiaire_id_27, t0.profil_client_id AS profil_client_id_28, t0.compte_bancaire_id AS compte_bancaire_id_29, t0.compte_bancaire_cible_id AS compte_bancaire_cible_id_30, t0.pret_id AS pret_id_31, t0.annulation_operation_id AS annulation_operation_id_32, t0.service_transfert_id AS service_transfert_id_33, t0.pays_destination_id AS pays_destination_id_34, t0.devise_commission_id AS devise_commission_id_35 FROM operation t0 WHERE t0.id = 9007;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.contact AS contact_4,
  t0.email AS email_5,
  t0.registre_commerce AS registre_commerce_6,
  t0.profession AS profession_7,
  t0.created_at AS created_at_8,
  t0.ifu AS ifu_9,
  t0.code_client AS code_client_10,
  t0.created_by_id AS created_by_id_11,
  t0.agence_id AS agence_id_12,
  t0.user_id AS user_id_13
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.contact AS contact_4, t0.email AS email_5, t0.registre_commerce AS registre_commerce_6, t0.profession AS profession_7, t0.created_at AS created_at_8, t0.ifu AS ifu_9, t0.code_client AS code_client_10, t0.created_by_id AS created_by_id_11, t0.agence_id AS agence_id_12, t0.user_id AS user_id_13 FROM client t0 WHERE t0.id = 66;

SELECT
  t0.id AS id_1,
  t0.type_mouvement AS type_mouvement_2,
  t0.montant AS montant_3,
  t0.sens AS sens_4,
  t0.date_mouvement AS date_mouvement_5,
  t0.date_valeur AS date_valeur_6,
  t0.reference_bancaire AS reference_bancaire_7,
  t0.nom_deposant AS nom_deposant_8,
  t0.contact_deposant AS contact_deposant_9,
  t0.commentaire AS commentaire_10,
  t0.compte_bancaire_id AS compte_bancaire_id_11,
  t0.devise_id AS devise_id_12,
  t0.effectue_par_id AS effectue_par_id_13,
  t0.operation_id AS operation_id_14
FROM
  mouvement_compte_bancaire t0
WHERE
  t0.operation_id = ?

SELECT t0.id AS id_1, t0.type_mouvement AS type_mouvement_2, t0.montant AS montant_3, t0.sens AS sens_4, t0.date_mouvement AS date_mouvement_5, t0.date_valeur AS date_valeur_6, t0.reference_bancaire AS reference_bancaire_7, t0.nom_deposant AS nom_deposant_8, t0.contact_deposant AS contact_deposant_9, t0.commentaire AS commentaire_10, t0.compte_bancaire_id AS compte_bancaire_id_11, t0.devise_id AS devise_id_12, t0.effectue_par_id AS effectue_par_id_13, t0.operation_id AS operation_id_14 FROM mouvement_compte_bancaire t0 WHERE t0.operation_id = 9007;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ville AS ville_3,
  t0.adresse AS adresse_4,
  t0.telephone AS telephone_5,
  t0.telephone2 AS telephone2_6,
  t0.created_at AS created_at_7,
  t0.require_loan_validation AS require_loan_validation_8,
  t0.entreprise_id AS entreprise_id_9,
  t0.pays_id AS pays_id_10,
  t0.devise_source_id AS devise_source_id_11,
  t0.responsable_id AS responsable_id_12
FROM
  agence t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ville AS ville_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.telephone2 AS telephone2_6, t0.created_at AS created_at_7, t0.require_loan_validation AS require_loan_validation_8, t0.entreprise_id AS entreprise_id_9, t0.pays_id AS pays_id_10, t0.devise_source_id AS devise_source_id_11, t0.responsable_id AS responsable_id_12 FROM agence t0 WHERE t0.id = 1;