GET http://api97485-albarkaznt.maialbarka.com/api/customer/latest/transaction

Query Metrics

6 Database Queries
6 Different statements
5.05 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.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:
[
  "22789900000"
]
2 0.49 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:
[
  "22789900000"
]
3 0.54 ms
SELECT t0.id AS id_1, t0.compte AS compte_2, t0.id_operation AS id_operation_3, t0.operation AS operation_4, t0.movement_type AS movement_type_5, t0.amount AS amount_6, t0.balance_before AS balance_before_7, t0.sale_after AS sale_after_8, t0.id_client AS id_client_9, t0.reference AS reference_10, t0.date_update AS date_update_11, t0.id_user AS id_user_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.status AS status_15, t0.n_recu AS n_recu_16, t0.id_store AS id_store_17, t0.commission_avant AS commission_avant_18, t0.commission_apres AS commission_apres_19 FROM movement_account t0 WHERE t0.status = ? AND t0.id_client = ? ORDER BY t0.id DESC LIMIT 5
Parameters:
[
  1
  15
]
4 0.25 ms
"START TRANSACTION"
Parameters:
[]
5 0.48 ms
INSERT INTO log (action, message, context, source, created_at, updated_at, identifiant) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "TRANSACTIONS"
  "Affichage de la liste dernieres transaction"
  "{"client":15}"
  "ApiListController"
  "2025-12-28 09:55:01"
  null
  "1"
]
6 2.50 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\MovementAccount 5
App\Entity\Customer 1
App\Entity\Roles 1
App\Entity\Log 1

Entities Mapping

Class Mapping errors
App\Entity\Customer No errors.
App\Entity\Roles No errors.
App\Entity\MovementAccount No errors.
App\Entity\Log No errors.