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

[
  "0AAEA282-91CF-4B77-9767-1F990D8AAB39"
  "211F6431-38D6-40EC-9734-3FACEB759CFC"
  "19FDDD44-3177-4389-A45A-8D086319D21B"
  "4F55951A-B3F5-4261-8C46-51F13A0C8E07"
  "2004319A-48F3-4353-86F7-5C2EF386239D"
  "F35448CF-352F-4426-8A16-3EE809D6DDFF"
  "BAC338DD-75D7-47A9-BAB9-FF3961C1C778"
  "9626DDDF-B9F4-439E-9BAE-92F9ADB8EC08"
  "171ECDB6-E708-4028-AE1D-67C378531CA8"
  "C35E469E-A8D9-44BC-BE22-7AB134B0A51A"
  "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 ('0AAEA282-91CF-4B77-9767-1F990D8AAB39', '211F6431-38D6-40EC-9734-3FACEB759CFC', '19FDDD44-3177-4389-A45A-8D086319D21B', '4F55951A-B3F5-4261-8C46-51F13A0C8E07', '2004319A-48F3-4353-86F7-5C2EF386239D', 'F35448CF-352F-4426-8A16-3EE809D6DDFF', 'BAC338DD-75D7-47A9-BAB9-FF3961C1C778', '9626DDDF-B9F4-439E-9BAE-92F9ADB8EC08', '171ECDB6-E708-4028-AE1D-67C378531CA8', 'C35E469E-A8D9-44BC-BE22-7AB134B0A51A') 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

[
  "0AAEA282-91CF-4B77-9767-1F990D8AAB39"
  "211F6431-38D6-40EC-9734-3FACEB759CFC"
  "19FDDD44-3177-4389-A45A-8D086319D21B"
  "4F55951A-B3F5-4261-8C46-51F13A0C8E07"
  "2004319A-48F3-4353-86F7-5C2EF386239D"
  "F35448CF-352F-4426-8A16-3EE809D6DDFF"
  "BAC338DD-75D7-47A9-BAB9-FF3961C1C778"
  "9626DDDF-B9F4-439E-9BAE-92F9ADB8EC08"
  "171ECDB6-E708-4028-AE1D-67C378531CA8"
  "C35E469E-A8D9-44BC-BE22-7AB134B0A51A"
]

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 ('0AAEA282-91CF-4B77-9767-1F990D8AAB39', '211F6431-38D6-40EC-9734-3FACEB759CFC', '19FDDD44-3177-4389-A45A-8D086319D21B', '4F55951A-B3F5-4261-8C46-51F13A0C8E07', '2004319A-48F3-4353-86F7-5C2EF386239D', 'F35448CF-352F-4426-8A16-3EE809D6DDFF', 'BAC338DD-75D7-47A9-BAB9-FF3961C1C778', '9626DDDF-B9F4-439E-9BAE-92F9ADB8EC08', '171ECDB6-E708-4028-AE1D-67C378531CA8', 'C35E469E-A8D9-44BC-BE22-7AB134B0A51A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "0aaea282-91cf-4b77-9767-1f990d8aab39"
  "211f6431-38d6-40ec-9734-3faceb759cfc"
  "19fddd44-3177-4389-a45a-8d086319d21b"
  "4f55951a-b3f5-4261-8c46-51f13a0c8e07"
  "2004319a-48f3-4353-86f7-5c2ef386239d"
  "f35448cf-352f-4426-8a16-3ee809d6ddff"
  "bac338dd-75d7-47a9-bab9-ff3961c1c778"
  "9626dddf-b9f4-439e-9bae-92f9adb8ec08"
  "171ecdb6-e708-4028-ae1d-67c378531ca8"
  "c35e469e-a8d9-44bc-be22-7ab134b0a51a"
]

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 ('0aaea282-91cf-4b77-9767-1f990d8aab39','211f6431-38d6-40ec-9734-3faceb759cfc','19fddd44-3177-4389-a45a-8d086319d21b','4f55951a-b3f5-4261-8c46-51f13a0c8e07','2004319a-48f3-4353-86f7-5c2ef386239d','f35448cf-352f-4426-8a16-3ee809d6ddff','bac338dd-75d7-47a9-bab9-ff3961c1c778','9626dddf-b9f4-439e-9bae-92f9adb8ec08','171ecdb6-e708-4028-ae1d-67c378531ca8','c35e469e-a8d9-44bc-be22-7ab134b0a51a');