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

[
  "F6B7ADA7-9B76-45CA-ADA6-3F85A688527F"
  "C75DBE2A-CEA9-40DC-8970-867C2F6E6DCF"
  "01D14085-A286-4AD8-B3B6-F50A764DE4BC"
  "AF72F875-31EB-40A8-88A2-FEF63AF32429"
  "D038BE0D-AC04-4741-9983-792F7C4AC2F0"
  "DE4214D1-979B-4208-A514-04A484291EA0"
  "3488D090-7D10-4F42-A8AB-3AE015EAB9FE"
  "AFFAA323-8CF2-4F20-A93F-233ABDE61F50"
  "7970FC6D-B4AA-4A01-8DF5-0C65640DB7F4"
  "3672B8D4-CD89-47DF-BE59-BB9FC19D7945"
  "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 ('F6B7ADA7-9B76-45CA-ADA6-3F85A688527F', 'C75DBE2A-CEA9-40DC-8970-867C2F6E6DCF', '01D14085-A286-4AD8-B3B6-F50A764DE4BC', 'AF72F875-31EB-40A8-88A2-FEF63AF32429', 'D038BE0D-AC04-4741-9983-792F7C4AC2F0', 'DE4214D1-979B-4208-A514-04A484291EA0', '3488D090-7D10-4F42-A8AB-3AE015EAB9FE', 'AFFAA323-8CF2-4F20-A93F-233ABDE61F50', '7970FC6D-B4AA-4A01-8DF5-0C65640DB7F4', '3672B8D4-CD89-47DF-BE59-BB9FC19D7945') 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

[
  "F6B7ADA7-9B76-45CA-ADA6-3F85A688527F"
  "C75DBE2A-CEA9-40DC-8970-867C2F6E6DCF"
  "01D14085-A286-4AD8-B3B6-F50A764DE4BC"
  "AF72F875-31EB-40A8-88A2-FEF63AF32429"
  "D038BE0D-AC04-4741-9983-792F7C4AC2F0"
  "DE4214D1-979B-4208-A514-04A484291EA0"
  "3488D090-7D10-4F42-A8AB-3AE015EAB9FE"
  "AFFAA323-8CF2-4F20-A93F-233ABDE61F50"
  "7970FC6D-B4AA-4A01-8DF5-0C65640DB7F4"
  "3672B8D4-CD89-47DF-BE59-BB9FC19D7945"
]

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 ('F6B7ADA7-9B76-45CA-ADA6-3F85A688527F', 'C75DBE2A-CEA9-40DC-8970-867C2F6E6DCF', '01D14085-A286-4AD8-B3B6-F50A764DE4BC', 'AF72F875-31EB-40A8-88A2-FEF63AF32429', 'D038BE0D-AC04-4741-9983-792F7C4AC2F0', 'DE4214D1-979B-4208-A514-04A484291EA0', '3488D090-7D10-4F42-A8AB-3AE015EAB9FE', 'AFFAA323-8CF2-4F20-A93F-233ABDE61F50', '7970FC6D-B4AA-4A01-8DF5-0C65640DB7F4', '3672B8D4-CD89-47DF-BE59-BB9FC19D7945') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "f6b7ada7-9b76-45ca-ada6-3f85a688527f"
  "c75dbe2a-cea9-40dc-8970-867c2f6e6dcf"
  "01d14085-a286-4ad8-b3b6-f50a764de4bc"
  "af72f875-31eb-40a8-88a2-fef63af32429"
  "d038be0d-ac04-4741-9983-792f7c4ac2f0"
  "de4214d1-979b-4208-a514-04a484291ea0"
  "3488d090-7d10-4f42-a8ab-3ae015eab9fe"
  "affaa323-8cf2-4f20-a93f-233abde61f50"
  "7970fc6d-b4aa-4a01-8df5-0c65640db7f4"
  "3672b8d4-cd89-47df-be59-bb9fc19d7945"
]

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 ('f6b7ada7-9b76-45ca-ada6-3f85a688527f','c75dbe2a-cea9-40dc-8970-867c2f6e6dcf','01d14085-a286-4ad8-b3b6-f50a764de4bc','af72f875-31eb-40a8-88a2-fef63af32429','d038be0d-ac04-4741-9983-792f7c4ac2f0','de4214d1-979b-4208-a514-04a484291ea0','3488d090-7d10-4f42-a8ab-3ae015eab9fe','affaa323-8cf2-4f20-a93f-233abde61f50','7970fc6d-b4aa-4a01-8df5-0c65640db7f4','3672b8d4-cd89-47df-be59-bb9fc19d7945');