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

[
  "2412FC15-76A3-4881-9192-3D79DEF37CFF"
  "13F31C9D-779E-4394-ADDC-84792DAD6434"
  "CF2294F8-E8E8-4397-BE75-9C718302E0E4"
  "0166F7C7-597B-4CDD-ADA5-8C83E771EFB0"
  "BA1FFA4F-16E9-410E-BDBD-9C106581C1F0"
  "F233DE6A-C435-41FD-817D-5CB2D4D1A2BD"
  "15C3DFC7-C2BB-411D-82D1-413951B2C370"
  "E3E833E3-4BB2-46F2-801E-D11D6D28BA40"
  "D018A351-C039-4AB5-8B3C-F985DB1A59BA"
  "239DBA6A-CBF6-4432-87FC-DEC6B2549022"
  "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 ('2412FC15-76A3-4881-9192-3D79DEF37CFF', '13F31C9D-779E-4394-ADDC-84792DAD6434', 'CF2294F8-E8E8-4397-BE75-9C718302E0E4', '0166F7C7-597B-4CDD-ADA5-8C83E771EFB0', 'BA1FFA4F-16E9-410E-BDBD-9C106581C1F0', 'F233DE6A-C435-41FD-817D-5CB2D4D1A2BD', '15C3DFC7-C2BB-411D-82D1-413951B2C370', 'E3E833E3-4BB2-46F2-801E-D11D6D28BA40', 'D018A351-C039-4AB5-8B3C-F985DB1A59BA', '239DBA6A-CBF6-4432-87FC-DEC6B2549022') 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

[
  "2412FC15-76A3-4881-9192-3D79DEF37CFF"
  "13F31C9D-779E-4394-ADDC-84792DAD6434"
  "CF2294F8-E8E8-4397-BE75-9C718302E0E4"
  "0166F7C7-597B-4CDD-ADA5-8C83E771EFB0"
  "BA1FFA4F-16E9-410E-BDBD-9C106581C1F0"
  "F233DE6A-C435-41FD-817D-5CB2D4D1A2BD"
  "15C3DFC7-C2BB-411D-82D1-413951B2C370"
  "E3E833E3-4BB2-46F2-801E-D11D6D28BA40"
  "D018A351-C039-4AB5-8B3C-F985DB1A59BA"
  "239DBA6A-CBF6-4432-87FC-DEC6B2549022"
]

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 ('2412FC15-76A3-4881-9192-3D79DEF37CFF', '13F31C9D-779E-4394-ADDC-84792DAD6434', 'CF2294F8-E8E8-4397-BE75-9C718302E0E4', '0166F7C7-597B-4CDD-ADA5-8C83E771EFB0', 'BA1FFA4F-16E9-410E-BDBD-9C106581C1F0', 'F233DE6A-C435-41FD-817D-5CB2D4D1A2BD', '15C3DFC7-C2BB-411D-82D1-413951B2C370', 'E3E833E3-4BB2-46F2-801E-D11D6D28BA40', 'D018A351-C039-4AB5-8B3C-F985DB1A59BA', '239DBA6A-CBF6-4432-87FC-DEC6B2549022') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "2412fc15-76a3-4881-9192-3d79def37cff"
  "13f31c9d-779e-4394-addc-84792dad6434"
  "cf2294f8-e8e8-4397-be75-9c718302e0e4"
  "0166f7c7-597b-4cdd-ada5-8c83e771efb0"
  "ba1ffa4f-16e9-410e-bdbd-9c106581c1f0"
  "f233de6a-c435-41fd-817d-5cb2d4d1a2bd"
  "15c3dfc7-c2bb-411d-82d1-413951b2c370"
  "e3e833e3-4bb2-46f2-801e-d11d6d28ba40"
  "d018a351-c039-4ab5-8b3c-f985db1a59ba"
  "239dba6a-cbf6-4432-87fc-dec6b2549022"
]

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 ('2412fc15-76a3-4881-9192-3d79def37cff','13f31c9d-779e-4394-addc-84792dad6434','cf2294f8-e8e8-4397-be75-9c718302e0e4','0166f7c7-597b-4cdd-ada5-8c83e771efb0','ba1ffa4f-16e9-410e-bdbd-9c106581c1f0','f233de6a-c435-41fd-817d-5cb2d4d1a2bd','15c3dfc7-c2bb-411d-82d1-413951b2c370','e3e833e3-4bb2-46f2-801e-d11d6d28ba40','d018a351-c039-4ab5-8b3c-f985db1a59ba','239dba6a-cbf6-4432-87fc-dec6b2549022');