https://biocasemlm.com/reports

Query Metrics

13 Database Queries
9 Different statements
20.18 ms Query time
0 Invalid entities

Queries

Group similar statements

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