Symfony Profiler

SELECT
  SUM(m0_.amount) AS sclr_0
FROM
  movement_account m0_
WHERE
  m0_.id_client = ?
  AND m0_.status = ?
  AND (
    m0_.created_at BETWEEN ?
    AND ?
  )

SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = '130' AND m0_.status = 1 AND (m0_.created_at BETWEEN '2026-06-19 00:00:00' AND '2026-06-19 23:59:59');

SELECT
  t0.id AS id_1,
  t0.last_name AS last_name_2,
  t0.first_name AS first_name_3,
  t0.address AS address_4,
  t0.password AS password_5,
  t0.phone AS phone_6,
  t0.mail AS mail_7,
  t0.canal AS canal_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code_lancement AS code_lancement_12,
  t0.kyc AS kyc_13,
  t0.piece_identite AS piece_identite_14,
  t0.code_unique AS code_unique_15,
  t0.nbre_tentative AS nbre_tentative_16,
  t0.id_session AS id_session_17,
  t0.is_active AS is_active_18,
  t0.id_roles_id AS id_roles_id_19
FROM
  customer t0
WHERE
  t0.status = ?
  AND t0.phone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.status = 1 AND t0.phone = '22799921528' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.last_name AS last_name_1,
  c0_.first_name AS first_name_2,
  c0_.address AS address_3,
  c0_.password AS password_4,
  c0_.phone AS phone_5,
  c0_.mail AS mail_6,
  c0_.canal AS canal_7,
  c0_.created_at AS created_at_8,
  c0_.deleted_at AS deleted_at_9,
  c0_.status AS status_10,
  c0_.code_lancement AS code_lancement_11,
  c0_.kyc AS kyc_12,
  c0_.piece_identite AS piece_identite_13,
  c0_.code_unique AS code_unique_14,
  c0_.nbre_tentative AS nbre_tentative_15,
  c0_.id_session AS id_session_16,
  c0_.is_active AS is_active_17,
  c0_.id_roles_id AS id_roles_id_18
FROM
  customer c0_
WHERE
  c0_.phone = ?

SELECT c0_.id AS id_0, c0_.last_name AS last_name_1, c0_.first_name AS first_name_2, c0_.address AS address_3, c0_.password AS password_4, c0_.phone AS phone_5, c0_.mail AS mail_6, c0_.canal AS canal_7, c0_.created_at AS created_at_8, c0_.deleted_at AS deleted_at_9, c0_.status AS status_10, c0_.code_lancement AS code_lancement_11, c0_.kyc AS kyc_12, c0_.piece_identite AS piece_identite_13, c0_.code_unique AS code_unique_14, c0_.nbre_tentative AS nbre_tentative_15, c0_.id_session AS id_session_16, c0_.is_active AS is_active_17, c0_.id_roles_id AS id_roles_id_18 FROM customer c0_ WHERE c0_.phone = '22799921528';

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.costs AS costs_3,
  t0.total_costs AS total_costs_4,
  t0.discount AS discount_5,
  t0.phone AS phone_6,
  t0.name AS name_7,
  t0.first_name AS first_name_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code AS code_12,
  t0.n_recu AS n_recu_13,
  t0.reference AS reference_14,
  t0.id_status_operation_id AS id_status_operation_id_15,
  t0.id_transaction_id AS id_transaction_id_16,
  t0.id_operator_id AS id_operator_id_17,
  t0.id_pricing_id AS id_pricing_id_18,
  t0.id_merchant_id AS id_merchant_id_19,
  t0.id_type_operation_id AS id_type_operation_id_20,
  t0.id_store_id AS id_store_id_21,
  t0.id_customer_send_id AS id_customer_send_id_22,
  t0.id_customer_id AS id_customer_id_23,
  t0.id_account_id AS id_account_id_24,
  t0.id_user_id AS id_user_id_25
FROM
  operation t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.costs AS costs_3, t0.total_costs AS total_costs_4, t0.discount AS discount_5, t0.phone AS phone_6, t0.name AS name_7, t0.first_name AS first_name_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code AS code_12, t0.n_recu AS n_recu_13, t0.reference AS reference_14, t0.id_status_operation_id AS id_status_operation_id_15, t0.id_transaction_id AS id_transaction_id_16, t0.id_operator_id AS id_operator_id_17, t0.id_pricing_id AS id_pricing_id_18, t0.id_merchant_id AS id_merchant_id_19, t0.id_type_operation_id AS id_type_operation_id_20, t0.id_store_id AS id_store_id_21, t0.id_customer_send_id AS id_customer_send_id_22, t0.id_customer_id AS id_customer_id_23, t0.id_account_id AS id_account_id_24, t0.id_user_id AS id_user_id_25 FROM operation t0 WHERE t0.code = 'TI26061920124268' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.last_name AS last_name_2,
  t0.first_name AS first_name_3,
  t0.address AS address_4,
  t0.password AS password_5,
  t0.phone AS phone_6,
  t0.mail AS mail_7,
  t0.canal AS canal_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code_lancement AS code_lancement_12,
  t0.kyc AS kyc_13,
  t0.piece_identite AS piece_identite_14,
  t0.code_unique AS code_unique_15,
  t0.nbre_tentative AS nbre_tentative_16,
  t0.id_session AS id_session_17,
  t0.is_active AS is_active_18,
  t0.id_roles_id AS id_roles_id_19
FROM
  customer t0
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.phone = '22799921528' LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  o0_.id AS id_0,
  o0_.amount AS amount_1,
  o0_.costs AS costs_2,
  o0_.total_costs AS total_costs_3,
  o0_.discount AS discount_4,
  o0_.phone AS phone_5,
  o0_.name AS name_6,
  o0_.first_name AS first_name_7,
  o0_.created_at AS created_at_8,
  o0_.deleted_at AS deleted_at_9,
  o0_.status AS status_10,
  o0_.code AS code_11,
  o0_.n_recu AS n_recu_12,
  o0_.reference AS reference_13,
  o0_.id_status_operation_id AS id_status_operation_id_14,
  o0_.id_transaction_id AS id_transaction_id_15,
  o0_.id_operator_id AS id_operator_id_16,
  o0_.id_pricing_id AS id_pricing_id_17,
  o0_.id_merchant_id AS id_merchant_id_18,
  o0_.id_type_operation_id AS id_type_operation_id_19,
  o0_.id_store_id AS id_store_id_20,
  o0_.id_customer_send_id AS id_customer_send_id_21,
  o0_.id_customer_id AS id_customer_id_22,
  o0_.id_account_id AS id_account_id_23,
  o0_.id_user_id AS id_user_id_24
FROM
  operation o0_
WHERE
  o0_.id_type_operation_id = ?
  AND o0_.id_customer_id = ?
  AND o0_.id_customer_send_id = ?
  AND o0_.amount = ?
  AND o0_.created_at LIKE ?
  AND (
    o0_.created_at BETWEEN ?
    AND ?
  )

SELECT o0_.id AS id_0, o0_.amount AS amount_1, o0_.costs AS costs_2, o0_.total_costs AS total_costs_3, o0_.discount AS discount_4, o0_.phone AS phone_5, o0_.name AS name_6, o0_.first_name AS first_name_7, o0_.created_at AS created_at_8, o0_.deleted_at AS deleted_at_9, o0_.status AS status_10, o0_.code AS code_11, o0_.n_recu AS n_recu_12, o0_.reference AS reference_13, o0_.id_status_operation_id AS id_status_operation_id_14, o0_.id_transaction_id AS id_transaction_id_15, o0_.id_operator_id AS id_operator_id_16, o0_.id_pricing_id AS id_pricing_id_17, o0_.id_merchant_id AS id_merchant_id_18, o0_.id_type_operation_id AS id_type_operation_id_19, o0_.id_store_id AS id_store_id_20, o0_.id_customer_send_id AS id_customer_send_id_21, o0_.id_customer_id AS id_customer_id_22, o0_.id_account_id AS id_account_id_23, o0_.id_user_id AS id_user_id_24 FROM operation o0_ WHERE o0_.id_type_operation_id = 3 AND o0_.id_customer_id = 159 AND o0_.id_customer_send_id = 130 AND o0_.amount = 100000 AND o0_.created_at LIKE '2026-06-19%' AND (o0_.created_at BETWEEN '2026-06-19 20:11:42' AND '2026-06-19 20:12:42');

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.amount_minimum_compte AS amount_minimum_compte_3,
  t0.amount_max_compte AS amount_max_compte_4,
  t0.amount_deposit AS amount_deposit_5,
  t0.amount_reel AS amount_reel_6,
  t0.amount_commission AS amount_commission_7,
  t0.amount_commission_en_attente AS amount_commission_en_attente_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.id_store_id AS id_store_id_12,
  t0.id_customer_id AS id_customer_id_13,
  t0.id_type_id AS id_type_id_14
FROM
  account t0
WHERE
  t0.status = ?
  AND t0.id_customer_id = ?
  AND t0.id_type_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount_minimum_compte AS amount_minimum_compte_3, t0.amount_max_compte AS amount_max_compte_4, t0.amount_deposit AS amount_deposit_5, t0.amount_reel AS amount_reel_6, t0.amount_commission AS amount_commission_7, t0.amount_commission_en_attente AS amount_commission_en_attente_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.id_store_id AS id_store_id_12, t0.id_customer_id AS id_customer_id_13, t0.id_type_id AS id_type_id_14 FROM account t0 WHERE t0.status = 1 AND t0.id_customer_id = 130 AND t0.id_type_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.number_of_connection_attempts AS number_of_connection_attempts_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5,
  t0.limit_mensuelle AS limit_mensuelle_6,
  t0.limit_journalier AS limit_journalier_7
FROM
  setting t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.number_of_connection_attempts AS number_of_connection_attempts_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.limit_mensuelle AS limit_mensuelle_6, t0.limit_journalier AS limit_journalier_7 FROM setting t0 WHERE t0.status = 1 LIMIT 1;

UPDATE
  account
SET
  amount_deposit = ?,
  amount_reel = ?
WHERE
  id = ?

UPDATE account SET amount_deposit = '519690', amount_reel = '519690' WHERE id = 130;

INSERT INTO movement_account (
  compte, id_operation, operation, movement_type,
  amount, balance_before, sale_after,
  id_client, reference, date_update,
  id_user, created_at, deleted_at,
  status, n_recu, id_store, commission_avant,
  commission_apres
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO movement_account (compte, id_operation, operation, movement_type, amount, balance_before, sale_after, id_client, reference, date_update, id_user, created_at, deleted_at, status, n_recu, id_store, commission_avant, commission_apres) VALUES ('NCD0000000130', NULL, 'COMPTE A COMPTE', 'DEBIT', '100000', '619690.0000', NULL, '130', NULL, NULL, NULL, '2026-06-19 20:12:42', NULL, 1, '202606192012420130634412', NULL, NULL, NULL);

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.amount_minimum_compte AS amount_minimum_compte_3,
  t0.amount_max_compte AS amount_max_compte_4,
  t0.amount_deposit AS amount_deposit_5,
  t0.amount_reel AS amount_reel_6,
  t0.amount_commission AS amount_commission_7,
  t0.amount_commission_en_attente AS amount_commission_en_attente_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.id_store_id AS id_store_id_12,
  t0.id_customer_id AS id_customer_id_13,
  t0.id_type_id AS id_type_id_14
FROM
  account t0
WHERE
  t0.id = ? FOR
UPDATE

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount_minimum_compte AS amount_minimum_compte_3, t0.amount_max_compte AS amount_max_compte_4, t0.amount_deposit AS amount_deposit_5, t0.amount_reel AS amount_reel_6, t0.amount_commission AS amount_commission_7, t0.amount_commission_en_attente AS amount_commission_en_attente_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.id_store_id AS id_store_id_12, t0.id_customer_id AS id_customer_id_13, t0.id_type_id AS id_type_id_14 FROM account t0 WHERE t0.id = 130 FOR UPDATE;

"START TRANSACTION"

"START TRANSACTION";

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5
FROM
  type_operation t0
WHERE
  t0.status = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5 FROM type_operation t0 WHERE t0.status = 1 AND t0.id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.created_at AS created_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5
FROM
  status_operation t0
WHERE
  t0.status = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5 FROM status_operation t0 WHERE t0.status = 1 AND t0.id = 2 LIMIT 1;

INSERT INTO operation (
  amount, costs, total_costs, discount,
  phone, name, first_name, created_at,
  deleted_at, status, code, n_recu,
  reference, id_status_operation_id,
  id_transaction_id, id_operator_id,
  id_pricing_id, id_merchant_id, id_type_operation_id,
  id_store_id, id_customer_send_id,
  id_customer_id, id_account_id, id_user_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO operation (amount, costs, total_costs, discount, phone, name, first_name, created_at, deleted_at, status, code, n_recu, reference, id_status_operation_id, id_transaction_id, id_operator_id, id_pricing_id, id_merchant_id, id_type_operation_id, id_store_id, id_customer_send_id, id_customer_id, id_account_id, id_user_id) VALUES ('100000', '0', '100000', NULL, '22789440530', 'Fala phone', 'Route doutchi', '2026-06-19 20:12:42', NULL, 1, 'TI26061920124268', '202606192012420130634412', NULL, 2, NULL, NULL, NULL, NULL, 3, NULL, 130, 159, 159, NULL);

SELECT
  t0.id AS id_1,
  t0.last_name AS last_name_2,
  t0.first_name AS first_name_3,
  t0.address AS address_4,
  t0.password AS password_5,
  t0.phone AS phone_6,
  t0.mail AS mail_7,
  t0.canal AS canal_8,
  t0.created_at AS created_at_9,
  t0.deleted_at AS deleted_at_10,
  t0.status AS status_11,
  t0.code_lancement AS code_lancement_12,
  t0.kyc AS kyc_13,
  t0.piece_identite AS piece_identite_14,
  t0.code_unique AS code_unique_15,
  t0.nbre_tentative AS nbre_tentative_16,
  t0.id_session AS id_session_17,
  t0.is_active AS is_active_18,
  t0.id_roles_id AS id_roles_id_19
FROM
  customer t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.address AS address_4, t0.password AS password_5, t0.phone AS phone_6, t0.mail AS mail_7, t0.canal AS canal_8, t0.created_at AS created_at_9, t0.deleted_at AS deleted_at_10, t0.status AS status_11, t0.code_lancement AS code_lancement_12, t0.kyc AS kyc_13, t0.piece_identite AS piece_identite_14, t0.code_unique AS code_unique_15, t0.nbre_tentative AS nbre_tentative_16, t0.id_session AS id_session_17, t0.is_active AS is_active_18, t0.id_roles_id AS id_roles_id_19 FROM customer t0 WHERE t0.id = 130 LIMIT 1;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

UPDATE
  movement_account
SET
  id_operation = ?,
  sale_after = ?
WHERE
  id = ?

UPDATE movement_account SET id_operation = 25522, sale_after = '519690' WHERE id = 207890;

INSERT INTO envoi_sms (
  message, numero, id_op, operation,
  id_user, id_client, created_at, deleted_at,
  status
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO envoi_sms (message, numero, id_op, operation, id_user, id_client, created_at, deleted_at, status) VALUES ('Bonjour, vous avez recu un depot de 100 000 sur votre compte venant de 22799921528. Nouveau solde : 102 211 Fcfa. Merci pour votre confiance', '22789440530', 25522, 'Compte à compte', 130, NULL, '2026-06-19 20:12:42', NULL, 1);

INSERT INTO log (
  action, message, context, source, created_at,
  updated_at, identifiant
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (action, message, context, source, created_at, updated_at, identifiant) VALUES ('WALLET_TO_WALLET', 'Compte à compte effectuer avec succès!', '{\"montant\":100000,\"tel_benef\":22789440530,\"Route\":\"api\\/customer\\/compte_a_compte\",\"Fonction\":\"ApiCompteACompte\"}', 'ApiAddUpdateController', '2026-06-19 20:12:43', NULL, '22799921528');