POST https://api.madex.mg/api/v1/transferts

Query Metrics

6 Database Queries
6 Different statements
4.45 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.83 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.last_connection_at AS last_connection_at_9, t0.last_activity_at AS last_activity_at_10, t0.utilisateur_role_id AS utilisateur_role_id_11 FROM utilisateur t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "340000001"
]
2 0.81 ms
SELECT COALESCE(SUM(t0_.montant), 0) AS sclr_0 FROM transfert t0_ WHERE t0_.emetteur_id = ? AND t0_.status IN (?, ?) AND t0_.created_at >= ? AND t0_.created_at < ?
Parameters:
[
  2
  "PAID"
  "PENDING_PAYMENT"
  "2026-09-07 21:00:00"
  "2026-09-08 21:00:00"
]
3 0.76 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.reference AS reference_3, t0.montant AS montant_4, t0.frais AS frais_5, t0.destinataire_phone AS destinataire_phone_6, t0.note AS note_7, t0.status AS status_8, t0.paid_at AS paid_at_9, t0.sent_at AS sent_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.emetteur_id AS emetteur_id_13 FROM transfert t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
  "MDX-AA380CCC"
]
4 0.62 ms
"START TRANSACTION"
Parameters:
[]
5 0.75 ms
INSERT INTO transfert (code, reference, montant, frais, destinataire_phone, note, status, paid_at, sent_at, created_at, updated_at, emetteur_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "TRN6AA00F573E92820260908133623"
  "MDX-AA380CCC"
  500
  null
  "326232244"
  null
  "PENDING_PAYMENT"
  null
  null
  "2026-09-08 13:36:23"
  "2026-09-08 13:36:23"
  2
]
6 0.68 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\Utilisateur 1
App\Entity\UtilisateurRole 1
App\Entity\Transfert 1

Entities Mapping