Symfony Profiler

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 = ?

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 = 381;

SELECT
  SUM(c0_.amount) AS sclr_0
FROM
  commission c0_
WHERE
  c0_.user_id = ?
  AND c0_.date >= ?
  AND c0_.date <= ?

SELECT SUM(c0_.amount) AS sclr_0 FROM commission c0_ WHERE c0_.user_id = 381 AND c0_.date >= '2026-09-01 00:00:00' AND c0_.date <= '2026-09-30 23:59:59';

SELECT
  SUM(o0_.total) AS sclr_0
FROM
  orders o0_
WHERE
  o0_.user_id = ?
  AND o0_.date >= ?
  AND o0_.date <= ?

SELECT SUM(o0_.total) AS sclr_0 FROM orders o0_ WHERE o0_.user_id = 381 AND o0_.date >= '2026-09-01 00:00:00' AND o0_.date <= '2026-09-30 23:59:59';

SELECT
  SUM(m0_.total_commissions) AS sclr_0
FROM
  monthly_commission_total m0_
WHERE
  m0_.user_id = ?
  AND m0_.paid_status = ?

SELECT SUM(m0_.total_commissions) AS sclr_0 FROM monthly_commission_total m0_ WHERE m0_.user_id = 381 AND m0_.paid_status = 0;

SELECT
  SUM(b0_.amount) AS sclr_0
FROM
  bonus b0_
WHERE
  b0_.user_id = ?
  AND b0_.paid_status = ?

SELECT SUM(b0_.amount) AS sclr_0 FROM bonus b0_ WHERE b0_.user_id = 381 AND b0_.paid_status = 0;

SELECT
  SUM(p0_.montant) AS sclr_0
FROM
  paiement p0_
WHERE
  p0_.user_id = ?

SELECT SUM(p0_.montant) AS sclr_0 FROM paiement p0_ WHERE p0_.user_id = 381;

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 = ?

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 = 381;

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 = ?

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 = 381;

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 >= ?

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 = 460 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 461 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 476 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 520 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 932 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 1045 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 2487 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 2537 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 2540 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 2829 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 2856 AND o0_.date >= '2026-09-01 00:00:00';

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 >= ?

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 = 3016 AND o0_.date >= '2026-09-01 00:00:00';

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 = ?

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 = 332;