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 170 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
  170
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 170 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

[
  "1D522159-97B3-458A-8DD7-71D6596DA4BB"
  "50748B6E-D4AB-41A6-8266-E567BD08FCA9"
  "13A4EEA9-4CE5-4152-85CA-1BACAD38DDA6"
  "439D8FDA-080D-4F73-BB6B-404E4893864B"
  "2FEAEBFA-8BA1-4148-9A73-9078FB5363E4"
  "A5FD7C51-F8B7-4140-8F65-0FDAD00FA91D"
  "F345CF5A-CBB0-4D7F-9FDC-4EF217BB41E0"
  "EA92D938-3272-4656-AB45-DA90CC716FED"
  "B7CE803C-A190-47E0-A827-288F3CA4E4A9"
  "17BAE33D-4C38-4738-824B-9B30E2488A79"
  "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 ('1D522159-97B3-458A-8DD7-71D6596DA4BB', '50748B6E-D4AB-41A6-8266-E567BD08FCA9', '13A4EEA9-4CE5-4152-85CA-1BACAD38DDA6', '439D8FDA-080D-4F73-BB6B-404E4893864B', '2FEAEBFA-8BA1-4148-9A73-9078FB5363E4', 'A5FD7C51-F8B7-4140-8F65-0FDAD00FA91D', 'F345CF5A-CBB0-4D7F-9FDC-4EF217BB41E0', 'EA92D938-3272-4656-AB45-DA90CC716FED', 'B7CE803C-A190-47E0-A827-288F3CA4E4A9', '17BAE33D-4C38-4738-824B-9B30E2488A79') 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

[
  "1D522159-97B3-458A-8DD7-71D6596DA4BB"
  "50748B6E-D4AB-41A6-8266-E567BD08FCA9"
  "13A4EEA9-4CE5-4152-85CA-1BACAD38DDA6"
  "439D8FDA-080D-4F73-BB6B-404E4893864B"
  "2FEAEBFA-8BA1-4148-9A73-9078FB5363E4"
  "A5FD7C51-F8B7-4140-8F65-0FDAD00FA91D"
  "F345CF5A-CBB0-4D7F-9FDC-4EF217BB41E0"
  "EA92D938-3272-4656-AB45-DA90CC716FED"
  "B7CE803C-A190-47E0-A827-288F3CA4E4A9"
  "17BAE33D-4C38-4738-824B-9B30E2488A79"
]

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 ('1D522159-97B3-458A-8DD7-71D6596DA4BB', '50748B6E-D4AB-41A6-8266-E567BD08FCA9', '13A4EEA9-4CE5-4152-85CA-1BACAD38DDA6', '439D8FDA-080D-4F73-BB6B-404E4893864B', '2FEAEBFA-8BA1-4148-9A73-9078FB5363E4', 'A5FD7C51-F8B7-4140-8F65-0FDAD00FA91D', 'F345CF5A-CBB0-4D7F-9FDC-4EF217BB41E0', 'EA92D938-3272-4656-AB45-DA90CC716FED', 'B7CE803C-A190-47E0-A827-288F3CA4E4A9', '17BAE33D-4C38-4738-824B-9B30E2488A79') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "1d522159-97b3-458a-8dd7-71d6596da4bb"
  "50748b6e-d4ab-41a6-8266-e567bd08fca9"
  "13a4eea9-4ce5-4152-85ca-1bacad38dda6"
  "439d8fda-080d-4f73-bb6b-404e4893864b"
  "2feaebfa-8ba1-4148-9a73-9078fb5363e4"
  "a5fd7c51-f8b7-4140-8f65-0fdad00fa91d"
  "f345cf5a-cbb0-4d7f-9fdc-4ef217bb41e0"
  "ea92d938-3272-4656-ab45-da90cc716fed"
  "b7ce803c-a190-47e0-a827-288f3ca4e4a9"
  "17bae33d-4c38-4738-824b-9b30e2488a79"
]

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 ('1d522159-97b3-458a-8dd7-71d6596da4bb','50748b6e-d4ab-41a6-8266-e567bd08fca9','13a4eea9-4ce5-4152-85ca-1bacad38dda6','439d8fda-080d-4f73-bb6b-404e4893864b','2feaebfa-8ba1-4148-9a73-9078fb5363e4','a5fd7c51-f8b7-4140-8f65-0fdad00fa91d','f345cf5a-cbb0-4d7f-9fdc-4ef217bb41e0','ea92d938-3272-4656-ab45-da90cc716fed','b7ce803c-a190-47e0-a827-288f3ca4e4a9','17bae33d-4c38-4738-824b-9b30e2488a79');