Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 1531
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 1
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_prenom AS nom_prenom_5, t0.created_at AS created_at_6, t0.is_enabled AS is_enabled_7, t0.zone AS zone_8, t0.last_activity_at AS last_activity_at_9, t0.total_commandes_value AS total_commandes_value_10, t0.total_stock_value AS total_stock_value_11, t0.paiement_left AS paiement_left_12, t0.has_device AS has_device_13, t0.is_admin AS is_admin_14, t0.phone_number AS phone_number_15, t0.last_livraison_at AS last_livraison_at_16, t0.code_collaborateur AS code_collaborateur_17, t0.last_update_at AS last_update_at_18, t0.adresse AS adresse_19, t0.total_commission AS total_commission_20, t0.total_survente AS total_survente_21, t0.initial_command_value AS initial_command_value_22, t0.utilisateur_role_id AS utilisateur_role_id_23 FROM utilisateur t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom_prenom AS nom_prenom_5,
  t0.created_at AS created_at_6,
  t0.is_enabled AS is_enabled_7,
  t0.zone AS zone_8,
  t0.last_activity_at AS last_activity_at_9,
  t0.total_commandes_value AS total_commandes_value_10,
  t0.total_stock_value AS total_stock_value_11,
  t0.paiement_left AS paiement_left_12,
  t0.has_device AS has_device_13,
  t0.is_admin AS is_admin_14,
  t0.phone_number AS phone_number_15,
  t0.last_livraison_at AS last_livraison_at_16,
  t0.code_collaborateur AS code_collaborateur_17,
  t0.last_update_at AS last_update_at_18,
  t0.adresse AS adresse_19,
  t0.total_commission AS total_commission_20,
  t0.total_survente AS total_survente_21,
  t0.initial_command_value AS initial_command_value_22,
  t0.utilisateur_role_id AS utilisateur_role_id_23
FROM
  utilisateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom_prenom AS nom_prenom_5, t0.created_at AS created_at_6, t0.is_enabled AS is_enabled_7, t0.zone AS zone_8, t0.last_activity_at AS last_activity_at_9, t0.total_commandes_value AS total_commandes_value_10, t0.total_stock_value AS total_stock_value_11, t0.paiement_left AS paiement_left_12, t0.has_device AS has_device_13, t0.is_admin AS is_admin_14, t0.phone_number AS phone_number_15, t0.last_livraison_at AS last_livraison_at_16, t0.code_collaborateur AS code_collaborateur_17, t0.last_update_at AS last_update_at_18, t0.adresse AS adresse_19, t0.total_commission AS total_commission_20, t0.total_survente AS total_survente_21, t0.initial_command_value AS initial_command_value_22, t0.utilisateur_role_id AS utilisateur_role_id_23 FROM utilisateur t0 WHERE t0.id = 1;

SELECT SUM(s0_.quantite_disponible * p1_.price) AS sclr_0 FROM stock_commercial s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.quantite_disponible > 0

[]

SELECT
  SUM(
    s0_.quantite_disponible * p1_.price
  ) AS sclr_0
FROM
  stock_commercial s0_
  INNER JOIN product p1_ ON s0_.product_id = p1_.id
WHERE
  s0_.quantite_disponible > 0

SELECT SUM(s0_.quantite_disponible * p1_.price) AS sclr_0 FROM stock_commercial s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.quantite_disponible > 0;

SELECT SUM(u0_.paiement_left) AS sclr_0 FROM utilisateur u0_ WHERE u0_.is_enabled = 1

[]

SELECT
  SUM(u0_.paiement_left) AS sclr_0
FROM
  utilisateur u0_
WHERE
  u0_.is_enabled = 1

SELECT SUM(u0_.paiement_left) AS sclr_0 FROM utilisateur u0_ WHERE u0_.is_enabled = 1;

SELECT COUNT(*) FROM commande t0

[]

SELECT
  COUNT(*)
FROM
  commande t0

SELECT COUNT(*) FROM commande t0;

SELECT AVG(c0_.total_value) AS sclr_0 FROM commande c0_

[]

SELECT
  AVG(c0_.total_value) AS sclr_0
FROM
  commande c0_

SELECT AVG(c0_.total_value) AS sclr_0 FROM commande c0_;

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.value AS value_4 FROM configuration t0 WHERE t0.code = ? LIMIT 1

[
  "MONTHLY_TARGET_AMOUNT_TEAM"
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.designation AS designation_3,
  t0.value AS value_4
FROM
  configuration t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.value AS value_4 FROM configuration t0 WHERE t0.code = 'MONTHLY_TARGET_AMOUNT_TEAM' LIMIT 1;

SELECT SUM(c0_.total_value) AS sclr_0 FROM commande c0_ WHERE c0_.commande_at >= ?

[
  "2025-09-01 00:00:00"
]

SELECT
  SUM(c0_.total_value) AS sclr_0
FROM
  commande c0_
WHERE
  c0_.commande_at >= ?

SELECT SUM(c0_.total_value) AS sclr_0 FROM commande c0_ WHERE c0_.commande_at >= '2025-09-01 00:00:00';