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

[
  "6192CA17-80F7-430D-B470-A2F3B98CD2F2"
  "F8D4CBBA-43F5-4F41-B9F2-908222FAD3DE"
  "0A351103-A0F6-469E-8E8F-B7A9CFFA7AD3"
  "299029E0-5C93-4BF9-9474-B025E96D55CD"
  "8D9B1358-1699-4E94-8185-26D007A80164"
  "7BAF0806-623D-4215-B55F-ABA4119AADB2"
  "00BC1F29-FCDE-4CA5-AB58-7CD64278D93E"
  "34D8CF34-FB51-4A8B-85FE-5757B559D1F7"
  "B2D76C00-8A9A-406B-9712-D805B80BC8AB"
  "3153D24C-3B91-43FA-9DA2-9DE08D244AD2"
  "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 ('6192CA17-80F7-430D-B470-A2F3B98CD2F2', 'F8D4CBBA-43F5-4F41-B9F2-908222FAD3DE', '0A351103-A0F6-469E-8E8F-B7A9CFFA7AD3', '299029E0-5C93-4BF9-9474-B025E96D55CD', '8D9B1358-1699-4E94-8185-26D007A80164', '7BAF0806-623D-4215-B55F-ABA4119AADB2', '00BC1F29-FCDE-4CA5-AB58-7CD64278D93E', '34D8CF34-FB51-4A8B-85FE-5757B559D1F7', 'B2D76C00-8A9A-406B-9712-D805B80BC8AB', '3153D24C-3B91-43FA-9DA2-9DE08D244AD2') 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

[
  "6192CA17-80F7-430D-B470-A2F3B98CD2F2"
  "F8D4CBBA-43F5-4F41-B9F2-908222FAD3DE"
  "0A351103-A0F6-469E-8E8F-B7A9CFFA7AD3"
  "299029E0-5C93-4BF9-9474-B025E96D55CD"
  "8D9B1358-1699-4E94-8185-26D007A80164"
  "7BAF0806-623D-4215-B55F-ABA4119AADB2"
  "00BC1F29-FCDE-4CA5-AB58-7CD64278D93E"
  "34D8CF34-FB51-4A8B-85FE-5757B559D1F7"
  "B2D76C00-8A9A-406B-9712-D805B80BC8AB"
  "3153D24C-3B91-43FA-9DA2-9DE08D244AD2"
]

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 ('6192CA17-80F7-430D-B470-A2F3B98CD2F2', 'F8D4CBBA-43F5-4F41-B9F2-908222FAD3DE', '0A351103-A0F6-469E-8E8F-B7A9CFFA7AD3', '299029E0-5C93-4BF9-9474-B025E96D55CD', '8D9B1358-1699-4E94-8185-26D007A80164', '7BAF0806-623D-4215-B55F-ABA4119AADB2', '00BC1F29-FCDE-4CA5-AB58-7CD64278D93E', '34D8CF34-FB51-4A8B-85FE-5757B559D1F7', 'B2D76C00-8A9A-406B-9712-D805B80BC8AB', '3153D24C-3B91-43FA-9DA2-9DE08D244AD2') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "6192ca17-80f7-430d-b470-a2f3b98cd2f2"
  "f8d4cbba-43f5-4f41-b9f2-908222fad3de"
  "0a351103-a0f6-469e-8e8f-b7a9cffa7ad3"
  "299029e0-5c93-4bf9-9474-b025e96d55cd"
  "8d9b1358-1699-4e94-8185-26d007a80164"
  "7baf0806-623d-4215-b55f-aba4119aadb2"
  "00bc1f29-fcde-4ca5-ab58-7cd64278d93e"
  "34d8cf34-fb51-4a8b-85fe-5757b559d1f7"
  "b2d76c00-8a9a-406b-9712-d805b80bc8ab"
  "3153d24c-3b91-43fa-9da2-9de08d244ad2"
]

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 ('6192ca17-80f7-430d-b470-a2f3b98cd2f2','f8d4cbba-43f5-4f41-b9f2-908222fad3de','0a351103-a0f6-469e-8e8f-b7a9cffa7ad3','299029e0-5c93-4bf9-9474-b025e96d55cd','8d9b1358-1699-4e94-8185-26d007a80164','7baf0806-623d-4215-b55f-aba4119aadb2','00bc1f29-fcde-4ca5-ab58-7cd64278d93e','34d8cf34-fb51-4a8b-85fe-5757b559d1f7','b2d76c00-8a9a-406b-9712-d805b80bc8ab','3153d24c-3b91-43fa-9da2-9de08d244ad2');