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

[
  "74DE59BD-9200-48D9-9ABA-30A3607C242E"
  "C532FFA1-7196-4D67-8DC2-05649E944C7E"
  "375C78E8-7BC7-4361-BB26-759715150A66"
  "BE4E8F4A-D587-494D-BBEE-7948C31B9C43"
  "DCC45480-BC26-411B-BD1B-150F4F0234BF"
  "B1DEA3F3-865F-4E37-8E09-ED9317A6AF52"
  "F533E646-527F-4212-A8BC-427045566F00"
  "6C2CB019-0476-4D20-872E-231382200BE2"
  "824B4570-8748-4155-B32A-A5CE05F6BEF4"
  "0952226E-58E9-491C-92E3-3209D38F08D5"
  "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 ('74DE59BD-9200-48D9-9ABA-30A3607C242E', 'C532FFA1-7196-4D67-8DC2-05649E944C7E', '375C78E8-7BC7-4361-BB26-759715150A66', 'BE4E8F4A-D587-494D-BBEE-7948C31B9C43', 'DCC45480-BC26-411B-BD1B-150F4F0234BF', 'B1DEA3F3-865F-4E37-8E09-ED9317A6AF52', 'F533E646-527F-4212-A8BC-427045566F00', '6C2CB019-0476-4D20-872E-231382200BE2', '824B4570-8748-4155-B32A-A5CE05F6BEF4', '0952226E-58E9-491C-92E3-3209D38F08D5') 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

[
  "74DE59BD-9200-48D9-9ABA-30A3607C242E"
  "C532FFA1-7196-4D67-8DC2-05649E944C7E"
  "375C78E8-7BC7-4361-BB26-759715150A66"
  "BE4E8F4A-D587-494D-BBEE-7948C31B9C43"
  "DCC45480-BC26-411B-BD1B-150F4F0234BF"
  "B1DEA3F3-865F-4E37-8E09-ED9317A6AF52"
  "F533E646-527F-4212-A8BC-427045566F00"
  "6C2CB019-0476-4D20-872E-231382200BE2"
  "824B4570-8748-4155-B32A-A5CE05F6BEF4"
  "0952226E-58E9-491C-92E3-3209D38F08D5"
]

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 ('74DE59BD-9200-48D9-9ABA-30A3607C242E', 'C532FFA1-7196-4D67-8DC2-05649E944C7E', '375C78E8-7BC7-4361-BB26-759715150A66', 'BE4E8F4A-D587-494D-BBEE-7948C31B9C43', 'DCC45480-BC26-411B-BD1B-150F4F0234BF', 'B1DEA3F3-865F-4E37-8E09-ED9317A6AF52', 'F533E646-527F-4212-A8BC-427045566F00', '6C2CB019-0476-4D20-872E-231382200BE2', '824B4570-8748-4155-B32A-A5CE05F6BEF4', '0952226E-58E9-491C-92E3-3209D38F08D5') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "74de59bd-9200-48d9-9aba-30a3607c242e"
  "c532ffa1-7196-4d67-8dc2-05649e944c7e"
  "375c78e8-7bc7-4361-bb26-759715150a66"
  "be4e8f4a-d587-494d-bbee-7948c31b9c43"
  "dcc45480-bc26-411b-bd1b-150f4f0234bf"
  "b1dea3f3-865f-4e37-8e09-ed9317a6af52"
  "f533e646-527f-4212-a8bc-427045566f00"
  "6c2cb019-0476-4d20-872e-231382200be2"
  "824b4570-8748-4155-b32a-a5ce05f6bef4"
  "0952226e-58e9-491c-92e3-3209d38f08d5"
]

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 ('74de59bd-9200-48d9-9aba-30a3607c242e','c532ffa1-7196-4d67-8dc2-05649e944c7e','375c78e8-7bc7-4361-bb26-759715150a66','be4e8f4a-d587-494d-bbee-7948c31b9c43','dcc45480-bc26-411b-bd1b-150f4f0234bf','b1dea3f3-865f-4e37-8e09-ed9317a6af52','f533e646-527f-4212-a8bc-427045566f00','6c2cb019-0476-4d20-872e-231382200be2','824b4570-8748-4155-b32a-a5ce05f6bef4','0952226e-58e9-491c-92e3-3209d38f08d5');