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

[
  "B6F60851-1F38-4862-9C7E-015D8D4DFC3B"
  "2A9ADF18-8369-42EF-953B-A20510E05574"
  "5A22A1D6-E586-4624-961A-58B9CD32DD7D"
  "B8C8DA43-6C4A-4653-9CF2-2B863F8FE696"
  "E45A6AF7-B902-470B-9E12-E322D0243FF6"
  "83A1C9A3-C419-4E95-974D-413D68F78FD9"
  "C5F3A569-D8FE-4D18-BF13-0CCC203F2545"
  "99F4A209-3720-4450-9FF4-9C6E37D4F40F"
  "A8A3E705-D4D3-4242-B8E5-A1D254F6460E"
  "00654B89-520F-4FA4-A064-C73950A5281E"
  "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 ('B6F60851-1F38-4862-9C7E-015D8D4DFC3B', '2A9ADF18-8369-42EF-953B-A20510E05574', '5A22A1D6-E586-4624-961A-58B9CD32DD7D', 'B8C8DA43-6C4A-4653-9CF2-2B863F8FE696', 'E45A6AF7-B902-470B-9E12-E322D0243FF6', '83A1C9A3-C419-4E95-974D-413D68F78FD9', 'C5F3A569-D8FE-4D18-BF13-0CCC203F2545', '99F4A209-3720-4450-9FF4-9C6E37D4F40F', 'A8A3E705-D4D3-4242-B8E5-A1D254F6460E', '00654B89-520F-4FA4-A064-C73950A5281E') 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

[
  "B6F60851-1F38-4862-9C7E-015D8D4DFC3B"
  "2A9ADF18-8369-42EF-953B-A20510E05574"
  "5A22A1D6-E586-4624-961A-58B9CD32DD7D"
  "B8C8DA43-6C4A-4653-9CF2-2B863F8FE696"
  "E45A6AF7-B902-470B-9E12-E322D0243FF6"
  "83A1C9A3-C419-4E95-974D-413D68F78FD9"
  "C5F3A569-D8FE-4D18-BF13-0CCC203F2545"
  "99F4A209-3720-4450-9FF4-9C6E37D4F40F"
  "A8A3E705-D4D3-4242-B8E5-A1D254F6460E"
  "00654B89-520F-4FA4-A064-C73950A5281E"
]

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 ('B6F60851-1F38-4862-9C7E-015D8D4DFC3B', '2A9ADF18-8369-42EF-953B-A20510E05574', '5A22A1D6-E586-4624-961A-58B9CD32DD7D', 'B8C8DA43-6C4A-4653-9CF2-2B863F8FE696', 'E45A6AF7-B902-470B-9E12-E322D0243FF6', '83A1C9A3-C419-4E95-974D-413D68F78FD9', 'C5F3A569-D8FE-4D18-BF13-0CCC203F2545', '99F4A209-3720-4450-9FF4-9C6E37D4F40F', 'A8A3E705-D4D3-4242-B8E5-A1D254F6460E', '00654B89-520F-4FA4-A064-C73950A5281E') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "b6f60851-1f38-4862-9c7e-015d8d4dfc3b"
  "2a9adf18-8369-42ef-953b-a20510e05574"
  "5a22a1d6-e586-4624-961a-58b9cd32dd7d"
  "b8c8da43-6c4a-4653-9cf2-2b863f8fe696"
  "e45a6af7-b902-470b-9e12-e322d0243ff6"
  "83a1c9a3-c419-4e95-974d-413d68f78fd9"
  "c5f3a569-d8fe-4d18-bf13-0ccc203f2545"
  "99f4a209-3720-4450-9ff4-9c6e37d4f40f"
  "a8a3e705-d4d3-4242-b8e5-a1d254f6460e"
  "00654b89-520f-4fa4-a064-c73950a5281e"
]

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 ('b6f60851-1f38-4862-9c7e-015d8d4dfc3b','2a9adf18-8369-42ef-953b-a20510e05574','5a22a1d6-e586-4624-961a-58b9cd32dd7d','b8c8da43-6c4a-4653-9cf2-2b863f8fe696','e45a6af7-b902-470b-9e12-e322d0243ff6','83a1c9a3-c419-4e95-974d-413d68f78fd9','c5f3a569-d8fe-4d18-bf13-0ccc203f2545','99f4a209-3720-4450-9ff4-9c6e37d4f40f','a8a3e705-d4d3-4242-b8e5-a1d254f6460e','00654b89-520f-4fa4-a064-c73950a5281e');