POST https://api97485-albarkaznt.maialbarka.com/api/customer/compte_a_compte

Query Metrics

33 Database Queries
22 Different statements
487.61 ms Query time
0 Invalid entities
14 Managed entities

Queries

Group similar statements

# Time Info
1 30.79 ms
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 = ?
Parameters:
[
  "22799921528"
]
2 19.69 ms
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
Parameters:
[
  "22799921528"
]
3 3.65 ms
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
Parameters:
[
  130
]
4 9.29 ms
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
Parameters:
[
  1
]
5 103.50 ms
SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = ? AND m0_.status = ? AND (m0_.created_at BETWEEN ? AND ?)
Parameters:
[
  "130"
  1
  "2026-06-19 00:00:00"
  "2026-06-19 23:59:59"
]
6 97.45 ms
SELECT SUM(m0_.amount) AS sclr_0 FROM movement_account m0_ WHERE m0_.id_client = ? AND m0_.status = ? AND (m0_.created_at BETWEEN ? AND ?)
Parameters:
[
  "130"
  1
  "2026-06-01 00:00:00"
  "2026-06-30 23:59:59"
]
7 82.79 ms
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
Parameters:
[
  1
  "22799921528"
]
8 6.62 ms
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
Parameters:
[
  1
  130
  1
]
9 11.19 ms
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
Parameters:
[
  1
  22789440530
]
10 7.85 ms
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
Parameters:
[
  1
  159
  1
]
11 17.73 ms
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 ?)
Parameters:
[
  3
  159
  130
  100000
  "2026-06-19%"
  "2026-06-19 20:11:42"
  "2026-06-19 20:12:42"
]
12 3.90 ms
"START TRANSACTION"
Parameters:
[]
13 3.91 ms
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
Parameters:
[
  130
]
14 3.87 ms
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
Parameters:
[
  159
]
15 3.82 ms
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
Parameters:
[
  1
  2
]
16 3.88 ms
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
Parameters:
[
  1
  3
]
17 29.89 ms
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
Parameters:
[
  "TI26061920124268"
]
18 3.31 ms
SAVEPOINT DOCTRINE_2
Parameters:
[]
19 3.76 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "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
]
20 3.90 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "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
]
21 3.91 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "NCD0000000159"
  null
  "COMPTE A COMPTE"
  "CREDIT"
  "100000"
  "2211.0000"
  null
  "159"
  null
  null
  null
  "2026-06-19 20:12:42"
  null
  1
  "202606192012420130634412"
  null
  null
  null
]
22 3.92 ms
UPDATE account SET amount_deposit = ?, amount_reel = ? WHERE id = ?
Parameters:
[
  "519690"
  "519690"
  130
]
23 3.95 ms
UPDATE account SET amount_deposit = ?, amount_reel = ? WHERE id = ?
Parameters:
[
  "102211"
  "102211"
  159
]
24 3.97 ms
RELEASE SAVEPOINT DOCTRINE_2
Parameters:
[]
25 7.94 ms
"COMMIT"
Parameters:
[]
26 0.72 ms
"START TRANSACTION"
Parameters:
[]
27 0.61 ms
INSERT INTO envoi_sms (message, numero, id_op, operation, id_user, id_client, created_at, deleted_at, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "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
]
28 0.56 ms
UPDATE movement_account SET id_operation = ?, sale_after = ? WHERE id = ?
Parameters:
[
  25522
  "519690"
  207890
]
29 0.30 ms
UPDATE movement_account SET id_operation = ?, sale_after = ? WHERE id = ?
Parameters:
[
  25522
  "102211"
  207891
]
30 5.33 ms
"COMMIT"
Parameters:
[]
31 0.28 ms
"START TRANSACTION"
Parameters:
[]
32 0.34 ms
INSERT INTO log (action, message, context, source, created_at, updated_at, identifiant) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "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"
]
33 5.00 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Customer 2
App\Entity\Account 2
App\Entity\MovementAccount 2
App\Entity\Roles 1
App\Entity\Setting 1
App\Entity\AccountType 1
App\Entity\StatusOperation 1
App\Entity\TypeOperation 1
App\Entity\Operation 1
App\Entity\EnvoiSms 1
App\Entity\Log 1

Entities Mapping

Class Mapping errors
App\Entity\Customer No errors.
App\Entity\Roles No errors.
App\Entity\Setting No errors.
App\Entity\MovementAccount No errors.
App\Entity\Account No errors.
App\Entity\Store No errors.
App\Entity\AccountType No errors.
App\Entity\Operation No errors.
App\Entity\StatusOperation No errors.
App\Entity\Transaction No errors.
App\Entity\Operator No errors.
App\Entity\PricingDetails No errors.
App\Entity\Merchant No errors.
App\Entity\TypeOperation No errors.
App\Entity\User No errors.
App\Entity\EnvoiSms No errors.
App\Entity\Log No errors.