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
  n0_.id AS id_0,
  n0_.date AS date_1,
  n0_.total AS total_2,
  n0_.numerocommande AS numerocommande_3,
  n0_.status AS status_4,
  n0_.user_id AS user_id_5
FROM
  nouvelleorder n0_
WHERE
  n0_.user_id = ?
  AND n0_.date >= ?
  AND n0_.date <= ?
ORDER BY
  n0_.date ASC

SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.total AS total_2, n0_.numerocommande AS numerocommande_3, n0_.status AS status_4, n0_.user_id AS user_id_5 FROM nouvelleorder n0_ WHERE n0_.user_id = 381 AND n0_.date >= '2026-09-01 00:00:00' AND n0_.date <= '2026-09-20 23:59:59' ORDER BY n0_.date ASC;

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

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

SELECT
  p0_.level AS level_0,
  SUM(p0_.amount) AS sclr_1
FROM
  precommission p0_
WHERE
  p0_.user_id = ?
  AND p0_.date >= ?
  AND p0_.date <= ?
GROUP BY
  p0_.level

SELECT p0_.level AS level_0, SUM(p0_.amount) AS sclr_1 FROM precommission p0_ WHERE p0_.user_id = 381 AND p0_.date >= '2026-09-01 10:06:43' AND p0_.date <= '2026-09-20 10:06:43' GROUP BY p0_.level;

SELECT
  p0_.level AS level_0,
  p0_.orderid_id AS sclr_1
FROM
  precommission p0_
WHERE
  p0_.user_id = ?
  AND p0_.date >= ?
  AND p0_.date <= ?

SELECT p0_.level AS level_0, p0_.orderid_id AS sclr_1 FROM precommission p0_ WHERE p0_.user_id = 381 AND p0_.date >= '2026-09-01 10:06:43' AND p0_.date <= '2026-09-20 10:06:43';

SELECT
  SUM(n0_.total) AS sclr_0
FROM
  nouvelleorder n0_
WHERE
  n0_.id IN (?, ?, ?)

SELECT SUM(n0_.total) AS sclr_0 FROM nouvelleorder n0_ WHERE n0_.id IN (2207, 2213, 2250);

SELECT
  SUM(n0_.total) AS sclr_0
FROM
  nouvelleorder n0_
WHERE
  n0_.id IN (?, ?, ?)

SELECT SUM(n0_.total) AS sclr_0 FROM nouvelleorder n0_ WHERE n0_.id IN (2211, 2222, 2246);

SELECT
  SUM(n0_.total) AS sclr_0
FROM
  nouvelleorder n0_
WHERE
  n0_.id IN (?, ?)

SELECT SUM(n0_.total) AS sclr_0 FROM nouvelleorder n0_ WHERE n0_.id IN (2226, 2254);

SELECT
  n0_.id AS id_0,
  n0_.total AS total_1,
  p1_.amount AS amount_2,
  n0_.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
  precommission p1_
  INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id
  INNER JOIN user u2_ ON n0_.user_id = u2_.id
WHERE
  p1_.user_id = ?
  AND p1_.level = ?
  AND p1_.date >= ?
  AND p1_.date <= ?

SELECT n0_.id AS id_0, n0_.total AS total_1, p1_.amount AS amount_2, n0_.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 precommission p1_ INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id INNER JOIN user u2_ ON n0_.user_id = u2_.id WHERE p1_.user_id = 381 AND p1_.level = 1 AND p1_.date >= '2026-09-01 10:06:43' AND p1_.date <= '2026-09-20 10:06:43';

SELECT
  n0_.id AS id_0,
  n0_.total AS total_1,
  p1_.amount AS amount_2,
  n0_.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
  precommission p1_
  INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id
  INNER JOIN user u2_ ON n0_.user_id = u2_.id
WHERE
  p1_.user_id = ?
  AND p1_.level = ?
  AND p1_.date >= ?
  AND p1_.date <= ?

SELECT n0_.id AS id_0, n0_.total AS total_1, p1_.amount AS amount_2, n0_.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 precommission p1_ INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id INNER JOIN user u2_ ON n0_.user_id = u2_.id WHERE p1_.user_id = 381 AND p1_.level = 2 AND p1_.date >= '2026-09-01 10:06:43' AND p1_.date <= '2026-09-20 10:06:43';

SELECT
  n0_.id AS id_0,
  n0_.total AS total_1,
  p1_.amount AS amount_2,
  n0_.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
  precommission p1_
  INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id
  INNER JOIN user u2_ ON n0_.user_id = u2_.id
WHERE
  p1_.user_id = ?
  AND p1_.level = ?
  AND p1_.date >= ?
  AND p1_.date <= ?

SELECT n0_.id AS id_0, n0_.total AS total_1, p1_.amount AS amount_2, n0_.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 precommission p1_ INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id INNER JOIN user u2_ ON n0_.user_id = u2_.id WHERE p1_.user_id = 381 AND p1_.level = 3 AND p1_.date >= '2026-09-01 10:06:43' AND p1_.date <= '2026-09-20 10:06:43';

SELECT
  n0_.id AS id_0,
  n0_.total AS total_1,
  p1_.amount AS amount_2,
  n0_.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
  precommission p1_
  INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id
  INNER JOIN user u2_ ON n0_.user_id = u2_.id
WHERE
  p1_.user_id = ?
  AND p1_.level = ?
  AND p1_.date >= ?
  AND p1_.date <= ?

SELECT n0_.id AS id_0, n0_.total AS total_1, p1_.amount AS amount_2, n0_.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 precommission p1_ INNER JOIN nouvelleorder n0_ ON p1_.orderid_id = n0_.id INNER JOIN user u2_ ON n0_.user_id = u2_.id WHERE p1_.user_id = 381 AND p1_.level = 4 AND p1_.date >= '2026-09-01 10:06:43' AND p1_.date <= '2026-09-20 10:06:43';

SELECT
  SUM(n0_.total) AS sclr_0
FROM
  nouvelleorder n0_
WHERE
  n0_.date >= ?
  AND n0_.date <= ?

SELECT SUM(n0_.total) AS sclr_0 FROM nouvelleorder n0_ WHERE n0_.date >= '2026-09-01 10:06:43' AND n0_.date <= '2026-09-20 10:06:43';

SELECT
  SUM(p0_.amount) AS sclr_0
FROM
  precommission p0_
WHERE
  p0_.date >= ?
  AND p0_.date <= ?

SELECT SUM(p0_.amount) AS sclr_0 FROM precommission p0_ WHERE p0_.date >= '2026-09-01 10:06:43' AND p0_.date <= '2026-09-20 10:06:43';

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;