https://biocasemlm.com/newapimlmfinal/commission/balance/BH212669

Query Metrics

4 Database Queries
4 Different statements
2.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.