Symfony Profiler

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

Query Metrics

SELECT COUNT(DISTINCT m0_.SessionId) AS sclr_0 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL

[]

SELECT
  COUNT(DISTINCT m0_.SessionId) AS sclr_0
FROM
  dbo.Messages m0_
WHERE
  m0_.SessionId IS NOT NULL

SELECT COUNT(DISTINCT m0_.SessionId) AS sclr_0 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL;

SELECT m0_.SessionId AS SessionId_0, MIN(m0_.[TimeStamp]) AS sclr_1, MAX(m0_.[TimeStamp]) AS sclr_2, COUNT(m0_.Id) AS sclr_3, MIN(m0_.[TimeStamp]) AS sclr_4 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL GROUP BY m0_.SessionId ORDER BY sclr_4 DESC OFFSET 700 ROWS FETCH NEXT 10 ROWS ONLY

[]

SELECT
  m0_.SessionId AS SessionId_0,
  MIN(m0_.[TimeStamp]) AS sclr_1,
  MAX(m0_.[TimeStamp]) AS sclr_2,
  COUNT(m0_.Id) AS sclr_3,
  MIN(m0_.[TimeStamp]) AS sclr_4
FROM
  dbo.Messages m0_
WHERE
  m0_.SessionId IS NOT NULL
GROUP BY
  m0_.SessionId
ORDER BY
  sclr_4 DESC
OFFSET
  700
ROWS
FETCH
  NEXT 10
ROWS
  ONLY

SELECT m0_.SessionId AS SessionId_0, MIN(m0_.[TimeStamp]) AS sclr_1, MAX(m0_.[TimeStamp]) AS sclr_2, COUNT(m0_.Id) AS sclr_3, MIN(m0_.[TimeStamp]) AS sclr_4 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL GROUP BY m0_.SessionId ORDER BY sclr_4 DESC OFFSET 700 ROWS FETCH NEXT 10 ROWS ONLY;

SELECT m0_.SessionId AS SessionId_0, COUNT(m0_.Id) AS sclr_1, SUM(m0_.Tokens) AS sclr_2 FROM dbo.Messages m0_ WHERE m0_.SessionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND LOWER(m0_.Role) <> ? GROUP BY m0_.SessionId

[
  "1AA684D4-5F5F-4FFC-A8B3-0BDF29FF7649"
  "19DA8A17-4BE2-486C-AEFF-1EA6FF24B3FF"
  "017E4EAA-D6EE-4B5F-B244-5657C0C69468"
  "3C92575F-EBA8-4805-BC6E-B73C6BB2D750"
  "DCF300D0-63B9-4C65-A5DF-79903C227313"
  "493F380F-7193-4219-9913-6B1289E2A94F"
  "C49B52A8-F3E0-4E2C-836C-EDEACEDAEB85"
  "058519F7-68C5-4F14-A490-744ED4D65D41"
  "889D4C6E-3142-405A-9B20-6F6DB1A4E992"
  "16D3DE39-8367-4EEF-93B3-64D64F605D04"
  "system"
]

SELECT
  m0_.SessionId AS SessionId_0,
  COUNT(m0_.Id) AS sclr_1,
  SUM(m0_.Tokens) AS sclr_2
FROM
  dbo.Messages m0_
WHERE
  m0_.SessionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND LOWER(m0_.Role) <> ?
GROUP BY
  m0_.SessionId

SELECT m0_.SessionId AS SessionId_0, COUNT(m0_.Id) AS sclr_1, SUM(m0_.Tokens) AS sclr_2 FROM dbo.Messages m0_ WHERE m0_.SessionId IN ('1AA684D4-5F5F-4FFC-A8B3-0BDF29FF7649', '19DA8A17-4BE2-486C-AEFF-1EA6FF24B3FF', '017E4EAA-D6EE-4B5F-B244-5657C0C69468', '3C92575F-EBA8-4805-BC6E-B73C6BB2D750', 'DCF300D0-63B9-4C65-A5DF-79903C227313', '493F380F-7193-4219-9913-6B1289E2A94F', 'C49B52A8-F3E0-4E2C-836C-EDEACEDAEB85', '058519F7-68C5-4F14-A490-744ED4D65D41', '889D4C6E-3142-405A-9B20-6F6DB1A4E992', '16D3DE39-8367-4EEF-93B3-64D64F605D04') AND LOWER(m0_.Role) <> 'system' GROUP BY m0_.SessionId;

SELECT s0_.ChatSessionId AS ChatSessionId_0, COUNT(DISTINCT s0_.ContentIdentifier) AS sclr_1 FROM dbo.SessionContextInformations s0_ WHERE s0_.ChatSessionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY s0_.ChatSessionId

[
  "1AA684D4-5F5F-4FFC-A8B3-0BDF29FF7649"
  "19DA8A17-4BE2-486C-AEFF-1EA6FF24B3FF"
  "017E4EAA-D6EE-4B5F-B244-5657C0C69468"
  "3C92575F-EBA8-4805-BC6E-B73C6BB2D750"
  "DCF300D0-63B9-4C65-A5DF-79903C227313"
  "493F380F-7193-4219-9913-6B1289E2A94F"
  "C49B52A8-F3E0-4E2C-836C-EDEACEDAEB85"
  "058519F7-68C5-4F14-A490-744ED4D65D41"
  "889D4C6E-3142-405A-9B20-6F6DB1A4E992"
  "16D3DE39-8367-4EEF-93B3-64D64F605D04"
]

SELECT
  s0_.ChatSessionId AS ChatSessionId_0,
  COUNT(DISTINCT s0_.ContentIdentifier) AS sclr_1
FROM
  dbo.SessionContextInformations s0_
WHERE
  s0_.ChatSessionId IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  s0_.ChatSessionId

SELECT s0_.ChatSessionId AS ChatSessionId_0, COUNT(DISTINCT s0_.ContentIdentifier) AS sclr_1 FROM dbo.SessionContextInformations s0_ WHERE s0_.ChatSessionId IN ('1AA684D4-5F5F-4FFC-A8B3-0BDF29FF7649', '19DA8A17-4BE2-486C-AEFF-1EA6FF24B3FF', '017E4EAA-D6EE-4B5F-B244-5657C0C69468', '3C92575F-EBA8-4805-BC6E-B73C6BB2D750', 'DCF300D0-63B9-4C65-A5DF-79903C227313', '493F380F-7193-4219-9913-6B1289E2A94F', 'C49B52A8-F3E0-4E2C-836C-EDEACEDAEB85', '058519F7-68C5-4F14-A490-744ED4D65D41', '889D4C6E-3142-405A-9B20-6F6DB1A4E992', '16D3DE39-8367-4EEF-93B3-64D64F605D04') GROUP BY s0_.ChatSessionId;

SELECT LOWER(CAST(Id AS NVARCHAR(36))) AS id, Name
                   FROM dbo.Sessions
                   WHERE LOWER(CAST(Id AS NVARCHAR(36))) IN (?,?,?,?,?,?,?,?,?,?)

[
  "1aa684d4-5f5f-4ffc-a8b3-0bdf29ff7649"
  "19da8a17-4be2-486c-aeff-1ea6ff24b3ff"
  "017e4eaa-d6ee-4b5f-b244-5657c0c69468"
  "3c92575f-eba8-4805-bc6e-b73c6bb2d750"
  "dcf300d0-63b9-4c65-a5df-79903c227313"
  "493f380f-7193-4219-9913-6b1289e2a94f"
  "c49b52a8-f3e0-4e2c-836c-edeacedaeb85"
  "058519f7-68c5-4f14-a490-744ed4d65d41"
  "889d4c6e-3142-405a-9b20-6f6db1a4e992"
  "16d3de39-8367-4eef-93b3-64d64f605d04"
]

SELECT
  LOWER(
    CAST(
      Id AS NVARCHAR(36)
    )
  ) AS id,
  Name
FROM
  dbo.Sessions
WHERE
  LOWER(
    CAST(
      Id AS NVARCHAR(36)
    )
  ) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT LOWER(CAST(Id AS NVARCHAR(36))) AS id, Name
                   FROM dbo.Sessions
                   WHERE LOWER(CAST(Id AS NVARCHAR(36))) IN ('1aa684d4-5f5f-4ffc-a8b3-0bdf29ff7649','19da8a17-4be2-486c-aeff-1ea6ff24b3ff','017e4eaa-d6ee-4b5f-b244-5657c0c69468','3c92575f-eba8-4805-bc6e-b73c6bb2d750','dcf300d0-63b9-4c65-a5df-79903c227313','493f380f-7193-4219-9913-6b1289e2a94f','c49b52a8-f3e0-4e2c-836c-edeacedaeb85','058519f7-68c5-4f14-a490-744ed4d65d41','889d4c6e-3142-405a-9b20-6f6db1a4e992','16d3de39-8367-4eef-93b3-64d64f605d04');