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

[
  "1E739230-2BB3-415C-B27B-FB8DFBE4240D"
  "FD91D10B-D0BC-4396-953F-E0128C45EAFD"
  "559C2A60-0D61-444A-BF41-90CEEA232FE1"
  "551A9906-9450-426E-B4B7-0C0AC8DFBC97"
  "C3849C32-4B09-4FF4-9078-A6A1E7BEE705"
  "EFB39D89-BD36-4823-B50B-BFD7573CEC4F"
  "B718CA80-1665-418A-974C-5A56140AAA29"
  "63056DB3-40FE-4C6E-852B-746B6040132C"
  "6712A12C-621C-4DE0-B2DA-E425AE1A1924"
  "A712A7AD-B93D-4B77-97AF-75E4677CE571"
  "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 ('1E739230-2BB3-415C-B27B-FB8DFBE4240D', 'FD91D10B-D0BC-4396-953F-E0128C45EAFD', '559C2A60-0D61-444A-BF41-90CEEA232FE1', '551A9906-9450-426E-B4B7-0C0AC8DFBC97', 'C3849C32-4B09-4FF4-9078-A6A1E7BEE705', 'EFB39D89-BD36-4823-B50B-BFD7573CEC4F', 'B718CA80-1665-418A-974C-5A56140AAA29', '63056DB3-40FE-4C6E-852B-746B6040132C', '6712A12C-621C-4DE0-B2DA-E425AE1A1924', 'A712A7AD-B93D-4B77-97AF-75E4677CE571') 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

[
  "1E739230-2BB3-415C-B27B-FB8DFBE4240D"
  "FD91D10B-D0BC-4396-953F-E0128C45EAFD"
  "559C2A60-0D61-444A-BF41-90CEEA232FE1"
  "551A9906-9450-426E-B4B7-0C0AC8DFBC97"
  "C3849C32-4B09-4FF4-9078-A6A1E7BEE705"
  "EFB39D89-BD36-4823-B50B-BFD7573CEC4F"
  "B718CA80-1665-418A-974C-5A56140AAA29"
  "63056DB3-40FE-4C6E-852B-746B6040132C"
  "6712A12C-621C-4DE0-B2DA-E425AE1A1924"
  "A712A7AD-B93D-4B77-97AF-75E4677CE571"
]

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 ('1E739230-2BB3-415C-B27B-FB8DFBE4240D', 'FD91D10B-D0BC-4396-953F-E0128C45EAFD', '559C2A60-0D61-444A-BF41-90CEEA232FE1', '551A9906-9450-426E-B4B7-0C0AC8DFBC97', 'C3849C32-4B09-4FF4-9078-A6A1E7BEE705', 'EFB39D89-BD36-4823-B50B-BFD7573CEC4F', 'B718CA80-1665-418A-974C-5A56140AAA29', '63056DB3-40FE-4C6E-852B-746B6040132C', '6712A12C-621C-4DE0-B2DA-E425AE1A1924', 'A712A7AD-B93D-4B77-97AF-75E4677CE571') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "1e739230-2bb3-415c-b27b-fb8dfbe4240d"
  "fd91d10b-d0bc-4396-953f-e0128c45eafd"
  "559c2a60-0d61-444a-bf41-90ceea232fe1"
  "551a9906-9450-426e-b4b7-0c0ac8dfbc97"
  "c3849c32-4b09-4ff4-9078-a6a1e7bee705"
  "efb39d89-bd36-4823-b50b-bfd7573cec4f"
  "b718ca80-1665-418a-974c-5a56140aaa29"
  "63056db3-40fe-4c6e-852b-746b6040132c"
  "6712a12c-621c-4de0-b2da-e425ae1a1924"
  "a712a7ad-b93d-4b77-97af-75e4677ce571"
]

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 ('1e739230-2bb3-415c-b27b-fb8dfbe4240d','fd91d10b-d0bc-4396-953f-e0128c45eafd','559c2a60-0d61-444a-bf41-90ceea232fe1','551a9906-9450-426e-b4b7-0c0ac8dfbc97','c3849c32-4b09-4ff4-9078-a6a1e7bee705','efb39d89-bd36-4823-b50b-bfd7573cec4f','b718ca80-1665-418a-974c-5a56140aaa29','63056db3-40fe-4c6e-852b-746b6040132c','6712a12c-621c-4de0-b2da-e425ae1a1924','a712a7ad-b93d-4b77-97af-75e4677ce571');