Query Metrics
21
Database Queries
9
Different statements
116.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
54.20 ms (46.38%) |
12 |
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.total AS total_2, o0_.numerocommande AS numerocommande_3, o0_.status AS status_4, o0_.user_id AS user_id_5 FROM orders o0_ WHERE o0_.user_id = ? AND o0_.date >= ?
Parameters:
[ 460 "2026-09-01 00:00:00" ] |
|
34.16 ms (29.23%) |
1 |
SELECT SUM(c0_.amount) AS sclr_0 FROM commission c0_ WHERE c0_.user_id = ? AND c0_.date >= ? AND c0_.date <= ?
Parameters:
[ 381 "2026-09-01 00:00:00" "2026-09-30 23:59:59" ] |
|
13.86 ms (11.86%) |
1 |
SELECT SUM(o0_.total) AS sclr_0 FROM orders o0_ WHERE o0_.user_id = ? AND o0_.date >= ? AND o0_.date <= ?
Parameters:
[ 381 "2026-09-01 00:00:00" "2026-09-30 23:59:59" ] |
|
7.26 ms (6.21%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.mobile AS mobile_6, u0_.annuler AS annuler_7, u0_.cin AS cin_8, u0_.rib AS rib_9, u0_.banque AS banque_10, u0_.ville AS ville_11, u0_.gendre AS gendre_12, u0_.datenaissance AS datenaissance_13, u0_.adresse AS adresse_14, u0_.matrecul AS matrecul_15, u0_.dateaffiliate AS dateaffiliate_16, u0_.status AS status_17, u0_.picture AS picture_18, u0_.balance AS balance_19, u0_.reset_password_token AS reset_password_token_20, u0_.reset_password_token_expires_at AS reset_password_token_expires_at_21, u0_.referral_id AS referral_id_22 FROM user u0_ WHERE u0_.referral_id = ?
Parameters:
[
381
]
|
|
4.37 ms (3.74%) |
2 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.annuler AS annuler_8, t0.cin AS cin_9, t0.rib AS rib_10, t0.banque AS banque_11, t0.ville AS ville_12, t0.gendre AS gendre_13, t0.datenaissance AS datenaissance_14, t0.adresse AS adresse_15, t0.matrecul AS matrecul_16, t0.dateaffiliate AS dateaffiliate_17, t0.status AS status_18, t0.picture AS picture_19, t0.balance AS balance_20, t0.reset_password_token AS reset_password_token_21, t0.reset_password_token_expires_at AS reset_password_token_expires_at_22, t0.referral_id AS referral_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
381
]
|
|
1.13 ms (0.97%) |
1 |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.user_id = ?
Parameters:
[
381
]
|
|
0.85 ms (0.73%) |
1 |
SELECT SUM(m0_.total_commissions) AS sclr_0 FROM monthly_commission_total m0_ WHERE m0_.user_id = ? AND m0_.paid_status = ?
Parameters:
[ 381 0 ] |
|
0.64 ms (0.55%) |
1 |
SELECT SUM(b0_.amount) AS sclr_0 FROM bonus b0_ WHERE b0_.user_id = ? AND b0_.paid_status = ?
Parameters:
[ 381 0 ] |
|
0.40 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.level AS level_3, t0.month AS month_4, t0.paid_status AS paid_status_5, t0.balance AS balance_6, t0.user_id AS user_id_7 FROM bonus t0 WHERE t0.user_id = ?
Parameters:
[
381
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Orders | No errors. |
| App\Entity\Commission | No errors. |
| App\Entity\Bonus | No errors. |
| App\Entity\Paiement | No errors. |
| App\Entity\UserGift | No errors. |
| App\Entity\PasswordResetRequest | No errors. |
| App\Entity\MonthlyCommissionTotal | No errors. |