Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 91
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Serializer
• Redis
• Mercure
• Configuration

Query Metrics

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, SUBSTRING(UPPER(a0_.tracker) FROM 0 FOR 4) AS sclr_1 FROM app_lead a0_ LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a0_.tracker IS NOT NULL AND a0_.created_at >= ? AND a0_.created_at < ? AND a0_.deleted_at IS NULL GROUP BY sclr_1

[
  "2026-04-14"
  "2026-04-15 00:00:00"
]

SELECT
  COUNT(
    DISTINCT (a0_.id)
  ) AS sclr_0,
  SUBSTRING(
    UPPER(a0_.tracker)
    FROM
      0 FOR 4
  ) AS sclr_1
FROM
  app_lead a0_
  LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id
  LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id
  LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id
WHERE
  a0_.tracker IS NOT NULL
  AND a0_.created_at >= ?
  AND a0_.created_at < ?
  AND a0_.deleted_at IS NULL
GROUP BY
  sclr_1

SELECT COUNT(DISTINCT (a0_.id)) AS sclr_0, SUBSTRING(UPPER(a0_.tracker) FROM 0 FOR 4) AS sclr_1 FROM app_lead a0_ LEFT JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN app_tool a2_ ON a0_.tool_id = a2_.id LEFT JOIN app_campaign a3_ ON a2_.campaign_id = a3_.id WHERE a0_.tracker IS NOT NULL AND a0_.created_at >= '2026-04-14' AND a0_.created_at < '2026-04-15 00:00:00' AND a0_.deleted_at IS NULL GROUP BY sclr_1;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone_number AS phone_number_7,
  t0.street AS street_8,
  t0.postcode AS postcode_9,
  t0.city AS city_10,
  t0.referrer AS referrer_11,
  t0.external_reference AS external_reference_12,
  t0.is_enabled AS is_enabled_13,
  t0.import_reference AS import_reference_14,
  t0.ip AS ip_15,
  t0.last_activity_at AS last_activity_at_16,
  t0.birthday AS birthday_17,
  t0.archived_at AS archived_at_18,
  t0.session_token AS session_token_19,
  t0.compliance AS compliance_20,
  t0.is_valid_email AS is_valid_email_21,
  t0.deleted_at AS deleted_at_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.uuid AS uuid_25,
  t0.civility_id AS civility_id_26,
  t0.avatar_id AS avatar_id_27,
  t0.company_id AS company_id_28
FROM
  app_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.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = 1;