Query Metrics
6
Database Queries
6
Different statements
95.80 ms
Query time
0
Invalid entities
5
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3.72 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:
[
"22797528788"
]
|
||||||||||||||||||||||||||||||
| 2 | 28.12 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 = ? AND t0.status = ? LIMIT 1
Parameters:
[ "22797528788" 1 ]
|
||||||||||||||||||||||||||||||
| 3 | 15.37 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 264 1 ]
|
||||||||||||||||||||||||||||||
| 4 | 36.97 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 3.69 ms |
INSERT INTO log (action, message, context, source, created_at, updated_at, identifiant) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "SOLDE_CUSTOMER" "Affichage du solde client" "{"client":264}" "ApiListController" "2026-04-11 22:14:59" null "264" ]
|
||||||||||||||||||||||||||||||
| 6 | 7.93 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 | 1 |
| App\Entity\Roles | 1 |
| App\Entity\Account | 1 |
| App\Entity\AccountType | 1 |
| App\Entity\Log | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Customer | No errors. |
| App\Entity\Roles | No errors. |
| App\Entity\Account | No errors. |
| App\Entity\Store | No errors. |
| App\Entity\AccountType | No errors. |
| App\Entity\Log | No errors. |