Query Metrics
6
Database Queries
6
Different statements
5.26 ms
Query time
0
Invalid entities
8
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.57 ms (48.95%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.83 ms (15.83%) |
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 = ?
Parameters:
[
"22789288680"
]
|
||||||||||||||||||||||||||||||
|
0.60 ms (11.39%) |
1 |
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 45 ]
|
||||||||||||||||||||||||||||||
|
0.50 ms (9.57%) |
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
Parameters:
[
"22789288680"
]
|
||||||||||||||||||||||||||||||
|
0.47 ms (8.87%) |
1 |
INSERT INTO log (action, message, context, source, created_at, updated_at, identifiant) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "TRANSACTIONS" "Affichage de la liste dernieres transaction" "{"client":45}" "ApiListController" "2025-12-28 19:50:03" null "1" ]
|
||||||||||||||||||||||||||||||
|
0.28 ms (5.38%) |
1 |
"START TRANSACTION"
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. |