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

[
  "DFEDEFAA-8680-4AF0-9F39-F0B7DD56FA76"
  "BB10BC3D-6550-46D1-829E-99A25B555F17"
  "7F532382-C1A7-41C7-A3DD-F1BC741CDFB1"
  "156E4C98-4A37-4441-BDCC-6650CF77982B"
  "D108B456-AADC-4FB7-9A19-99D943B15693"
  "452172CA-B135-441A-9A00-C754451BA9B3"
  "E535D33F-5888-4465-9C70-986ADA215F9E"
  "30A0FDD0-E198-4E2D-B8E0-0C4C36E9B6DE"
  "47D63463-383D-4EE3-85B1-797F936DEB98"
  "57C87444-F903-4496-B559-F852C9E25CCF"
  "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 ('DFEDEFAA-8680-4AF0-9F39-F0B7DD56FA76', 'BB10BC3D-6550-46D1-829E-99A25B555F17', '7F532382-C1A7-41C7-A3DD-F1BC741CDFB1', '156E4C98-4A37-4441-BDCC-6650CF77982B', 'D108B456-AADC-4FB7-9A19-99D943B15693', '452172CA-B135-441A-9A00-C754451BA9B3', 'E535D33F-5888-4465-9C70-986ADA215F9E', '30A0FDD0-E198-4E2D-B8E0-0C4C36E9B6DE', '47D63463-383D-4EE3-85B1-797F936DEB98', '57C87444-F903-4496-B559-F852C9E25CCF') 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

[
  "DFEDEFAA-8680-4AF0-9F39-F0B7DD56FA76"
  "BB10BC3D-6550-46D1-829E-99A25B555F17"
  "7F532382-C1A7-41C7-A3DD-F1BC741CDFB1"
  "156E4C98-4A37-4441-BDCC-6650CF77982B"
  "D108B456-AADC-4FB7-9A19-99D943B15693"
  "452172CA-B135-441A-9A00-C754451BA9B3"
  "E535D33F-5888-4465-9C70-986ADA215F9E"
  "30A0FDD0-E198-4E2D-B8E0-0C4C36E9B6DE"
  "47D63463-383D-4EE3-85B1-797F936DEB98"
  "57C87444-F903-4496-B559-F852C9E25CCF"
]

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 ('DFEDEFAA-8680-4AF0-9F39-F0B7DD56FA76', 'BB10BC3D-6550-46D1-829E-99A25B555F17', '7F532382-C1A7-41C7-A3DD-F1BC741CDFB1', '156E4C98-4A37-4441-BDCC-6650CF77982B', 'D108B456-AADC-4FB7-9A19-99D943B15693', '452172CA-B135-441A-9A00-C754451BA9B3', 'E535D33F-5888-4465-9C70-986ADA215F9E', '30A0FDD0-E198-4E2D-B8E0-0C4C36E9B6DE', '47D63463-383D-4EE3-85B1-797F936DEB98', '57C87444-F903-4496-B559-F852C9E25CCF') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "dfedefaa-8680-4af0-9f39-f0b7dd56fa76"
  "bb10bc3d-6550-46d1-829e-99a25b555f17"
  "7f532382-c1a7-41c7-a3dd-f1bc741cdfb1"
  "156e4c98-4a37-4441-bdcc-6650cf77982b"
  "d108b456-aadc-4fb7-9a19-99d943b15693"
  "452172ca-b135-441a-9a00-c754451ba9b3"
  "e535d33f-5888-4465-9c70-986ada215f9e"
  "30a0fdd0-e198-4e2d-b8e0-0c4c36e9b6de"
  "47d63463-383d-4ee3-85b1-797f936deb98"
  "57c87444-f903-4496-b559-f852c9e25ccf"
]

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 ('dfedefaa-8680-4af0-9f39-f0b7dd56fa76','bb10bc3d-6550-46d1-829e-99a25b555f17','7f532382-c1a7-41c7-a3dd-f1bc741cdfb1','156e4c98-4a37-4441-bdcc-6650cf77982b','d108b456-aadc-4fb7-9a19-99d943b15693','452172ca-b135-441a-9a00-c754451ba9b3','e535d33f-5888-4465-9c70-986ada215f9e','30a0fdd0-e198-4e2d-b8e0-0c4c36e9b6de','47d63463-383d-4ee3-85b1-797f936deb98','57c87444-f903-4496-b559-f852c9e25ccf');