Query Metrics
13
Database Queries
9
Different statements
20.18 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.39 ms |
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:
[
2675
]
|
| 2 | 0.57 ms |
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 >= ? AND o0_.date <= ? ORDER BY o0_.date ASC
Parameters:
[ 2675 "2025-11-01 00:00:00" "2025-11-30 23:59:59" ] |
| 3 | 0.34 ms |
SELECT SUM(o0_.total) AS sclr_0 FROM orders o0_ WHERE o0_.user_id = ? AND o0_.date >= ? AND o0_.date <= ?
Parameters:
[ 2675 "2025-11-01 00:00:00" "2025-11-30 23:59:59" ] |
| 4 | 0.49 ms |
SELECT c0_.level AS level_0, SUM(c0_.amount) AS sclr_1 FROM commission c0_ WHERE c0_.user_id = ? AND c0_.date >= ? AND c0_.date <= ? GROUP BY c0_.level
Parameters:
[ 2675 "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 5 | 0.45 ms |
SELECT c0_.level AS level_0, c0_.orderid_id AS sclr_1 FROM commission c0_ WHERE c0_.user_id = ? AND c0_.date >= ? AND c0_.date <= ?
Parameters:
[ 2675 "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 6 | 0.36 ms |
SELECT SUM(o0_.total) AS sclr_0 FROM orders o0_ WHERE o0_.id IN (?)
Parameters:
[
2244
]
|
| 7 | 1.31 ms |
SELECT o0_.id AS id_0, o0_.total AS total_1, c1_.amount AS amount_2, o0_.numerocommande AS numerocommande_3, u2_.id AS id_4, u2_.last_name AS last_name_5, u2_.first_name AS first_name_6, u2_.matrecul AS matrecul_7 FROM commission c1_ INNER JOIN orders o0_ ON c1_.orderid_id = o0_.id INNER JOIN user u2_ ON o0_.user_id = u2_.id WHERE c1_.user_id = ? AND c1_.level = ? AND c1_.date >= ? AND c1_.date <= ?
Parameters:
[ 2675 1 "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 8 | 1.74 ms |
SELECT o0_.id AS id_0, o0_.total AS total_1, c1_.amount AS amount_2, o0_.numerocommande AS numerocommande_3, u2_.id AS id_4, u2_.last_name AS last_name_5, u2_.first_name AS first_name_6, u2_.matrecul AS matrecul_7 FROM commission c1_ INNER JOIN orders o0_ ON c1_.orderid_id = o0_.id INNER JOIN user u2_ ON o0_.user_id = u2_.id WHERE c1_.user_id = ? AND c1_.level = ? AND c1_.date >= ? AND c1_.date <= ?
Parameters:
[ 2675 2 "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 9 | 1.73 ms |
SELECT o0_.id AS id_0, o0_.total AS total_1, c1_.amount AS amount_2, o0_.numerocommande AS numerocommande_3, u2_.id AS id_4, u2_.last_name AS last_name_5, u2_.first_name AS first_name_6, u2_.matrecul AS matrecul_7 FROM commission c1_ INNER JOIN orders o0_ ON c1_.orderid_id = o0_.id INNER JOIN user u2_ ON o0_.user_id = u2_.id WHERE c1_.user_id = ? AND c1_.level = ? AND c1_.date >= ? AND c1_.date <= ?
Parameters:
[ 2675 3 "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 10 | 1.11 ms |
SELECT o0_.id AS id_0, o0_.total AS total_1, c1_.amount AS amount_2, o0_.numerocommande AS numerocommande_3, u2_.id AS id_4, u2_.last_name AS last_name_5, u2_.first_name AS first_name_6, u2_.matrecul AS matrecul_7 FROM commission c1_ INNER JOIN orders o0_ ON c1_.orderid_id = o0_.id INNER JOIN user u2_ ON o0_.user_id = u2_.id WHERE c1_.user_id = ? AND c1_.level = ? AND c1_.date >= ? AND c1_.date <= ?
Parameters:
[ 2675 4 "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 11 | 4.11 ms |
SELECT SUM(o0_.total) AS sclr_0 FROM orders o0_ WHERE o0_.date >= ? AND o0_.date <= ?
Parameters:
[ "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 12 | 2.04 ms |
SELECT SUM(c0_.amount) AS sclr_0 FROM commission c0_ WHERE c0_.date >= ? AND c0_.date <= ?
Parameters:
[ "2025-11-01 22:44:14" "2025-11-30 22:44:14" ] |
| 13 | 5.55 ms |
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:
[
332
]
|
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. |