Query Metrics
4
Database Queries
4
Different statements
2.73 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.17 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.cin = ? LIMIT 1
Parameters:
[
"BH212669"
]
|
| 2 | 0.56 ms |
SELECT SUM(b0_.amount) AS sclr_0 FROM bonus b0_ WHERE b0_.user_id = ? AND b0_.paid_status = ?
Parameters:
[ 720 0 ] |
| 3 | 0.55 ms |
SELECT SUM(m0_.total_commissions) AS sclr_0 FROM monthly_commission_total m0_ WHERE m0_.user_id = ? AND m0_.paid_status = ?
Parameters:
[ 720 0 ] |
| 4 | 0.45 ms |
SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.user_id = ?
Parameters:
[
720
]
|
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. |