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

[
  "7C350EAB-4B39-4C10-B722-6594345FE0C5"
  "4F907575-D479-416A-816F-8F5358C8D1B8"
  "E4B2AF94-5A9A-4417-8733-F5410BEFCD03"
  "8EA25853-F3C5-4477-AEC2-C42388DAE866"
  "DDFC6167-B46A-4E23-8ED3-D15FFE51E7EB"
  "8EAE7799-5B78-4930-A152-6E534B1066EE"
  "85212029-C6E4-4F4C-AB68-F1CC8D94A70D"
  "5E3CBAC0-E823-4740-B320-DFAD6012B727"
  "76CE9E00-DFD6-4EA7-9E35-6F404920C3F0"
  "873A36B0-83B3-4F4F-B52A-F1C4AA4F98F0"
  "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 ('7C350EAB-4B39-4C10-B722-6594345FE0C5', '4F907575-D479-416A-816F-8F5358C8D1B8', 'E4B2AF94-5A9A-4417-8733-F5410BEFCD03', '8EA25853-F3C5-4477-AEC2-C42388DAE866', 'DDFC6167-B46A-4E23-8ED3-D15FFE51E7EB', '8EAE7799-5B78-4930-A152-6E534B1066EE', '85212029-C6E4-4F4C-AB68-F1CC8D94A70D', '5E3CBAC0-E823-4740-B320-DFAD6012B727', '76CE9E00-DFD6-4EA7-9E35-6F404920C3F0', '873A36B0-83B3-4F4F-B52A-F1C4AA4F98F0') 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

[
  "7C350EAB-4B39-4C10-B722-6594345FE0C5"
  "4F907575-D479-416A-816F-8F5358C8D1B8"
  "E4B2AF94-5A9A-4417-8733-F5410BEFCD03"
  "8EA25853-F3C5-4477-AEC2-C42388DAE866"
  "DDFC6167-B46A-4E23-8ED3-D15FFE51E7EB"
  "8EAE7799-5B78-4930-A152-6E534B1066EE"
  "85212029-C6E4-4F4C-AB68-F1CC8D94A70D"
  "5E3CBAC0-E823-4740-B320-DFAD6012B727"
  "76CE9E00-DFD6-4EA7-9E35-6F404920C3F0"
  "873A36B0-83B3-4F4F-B52A-F1C4AA4F98F0"
]

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 ('7C350EAB-4B39-4C10-B722-6594345FE0C5', '4F907575-D479-416A-816F-8F5358C8D1B8', 'E4B2AF94-5A9A-4417-8733-F5410BEFCD03', '8EA25853-F3C5-4477-AEC2-C42388DAE866', 'DDFC6167-B46A-4E23-8ED3-D15FFE51E7EB', '8EAE7799-5B78-4930-A152-6E534B1066EE', '85212029-C6E4-4F4C-AB68-F1CC8D94A70D', '5E3CBAC0-E823-4740-B320-DFAD6012B727', '76CE9E00-DFD6-4EA7-9E35-6F404920C3F0', '873A36B0-83B3-4F4F-B52A-F1C4AA4F98F0') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "7c350eab-4b39-4c10-b722-6594345fe0c5"
  "4f907575-d479-416a-816f-8f5358c8d1b8"
  "e4b2af94-5a9a-4417-8733-f5410befcd03"
  "8ea25853-f3c5-4477-aec2-c42388dae866"
  "ddfc6167-b46a-4e23-8ed3-d15ffe51e7eb"
  "8eae7799-5b78-4930-a152-6e534b1066ee"
  "85212029-c6e4-4f4c-ab68-f1cc8d94a70d"
  "5e3cbac0-e823-4740-b320-dfad6012b727"
  "76ce9e00-dfd6-4ea7-9e35-6f404920c3f0"
  "873a36b0-83b3-4f4f-b52a-f1c4aa4f98f0"
]

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 ('7c350eab-4b39-4c10-b722-6594345fe0c5','4f907575-d479-416a-816f-8f5358c8d1b8','e4b2af94-5a9a-4417-8733-f5410befcd03','8ea25853-f3c5-4477-aec2-c42388dae866','ddfc6167-b46a-4e23-8ed3-d15ffe51e7eb','8eae7799-5b78-4930-a152-6e534b1066ee','85212029-c6e4-4f4c-ab68-f1cc8d94a70d','5e3cbac0-e823-4740-b320-dfad6012b727','76ce9e00-dfd6-4ea7-9e35-6f404920c3f0','873a36b0-83b3-4f4f-b52a-f1c4aa4f98f0');