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

[
  "89240D79-7B97-44DF-AC5B-D17703A69568"
  "1603335D-698A-4267-97AF-73EB0472C8C7"
  "2EA44905-3D9B-4BAD-8F37-D64C932C8A79"
  "536102D8-7F7D-40A5-A259-F3604CFADB2F"
  "63643E10-B452-4550-8E3E-3AD28FD5C231"
  "8A68E9E8-598B-4E36-9CFA-DF01577C0039"
  "F59A7B3F-F7F0-4D0B-B166-2CF852C58A65"
  "EA123E8F-1715-4B88-BCF7-708FDEABF331"
  "DAEB891D-89AE-4524-9615-9E7B0C915213"
  "A2FF3A3F-2808-4C88-A431-AD170B9A8D78"
  "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 ('89240D79-7B97-44DF-AC5B-D17703A69568', '1603335D-698A-4267-97AF-73EB0472C8C7', '2EA44905-3D9B-4BAD-8F37-D64C932C8A79', '536102D8-7F7D-40A5-A259-F3604CFADB2F', '63643E10-B452-4550-8E3E-3AD28FD5C231', '8A68E9E8-598B-4E36-9CFA-DF01577C0039', 'F59A7B3F-F7F0-4D0B-B166-2CF852C58A65', 'EA123E8F-1715-4B88-BCF7-708FDEABF331', 'DAEB891D-89AE-4524-9615-9E7B0C915213', 'A2FF3A3F-2808-4C88-A431-AD170B9A8D78') 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

[
  "89240D79-7B97-44DF-AC5B-D17703A69568"
  "1603335D-698A-4267-97AF-73EB0472C8C7"
  "2EA44905-3D9B-4BAD-8F37-D64C932C8A79"
  "536102D8-7F7D-40A5-A259-F3604CFADB2F"
  "63643E10-B452-4550-8E3E-3AD28FD5C231"
  "8A68E9E8-598B-4E36-9CFA-DF01577C0039"
  "F59A7B3F-F7F0-4D0B-B166-2CF852C58A65"
  "EA123E8F-1715-4B88-BCF7-708FDEABF331"
  "DAEB891D-89AE-4524-9615-9E7B0C915213"
  "A2FF3A3F-2808-4C88-A431-AD170B9A8D78"
]

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 ('89240D79-7B97-44DF-AC5B-D17703A69568', '1603335D-698A-4267-97AF-73EB0472C8C7', '2EA44905-3D9B-4BAD-8F37-D64C932C8A79', '536102D8-7F7D-40A5-A259-F3604CFADB2F', '63643E10-B452-4550-8E3E-3AD28FD5C231', '8A68E9E8-598B-4E36-9CFA-DF01577C0039', 'F59A7B3F-F7F0-4D0B-B166-2CF852C58A65', 'EA123E8F-1715-4B88-BCF7-708FDEABF331', 'DAEB891D-89AE-4524-9615-9E7B0C915213', 'A2FF3A3F-2808-4C88-A431-AD170B9A8D78') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "89240d79-7b97-44df-ac5b-d17703a69568"
  "1603335d-698a-4267-97af-73eb0472c8c7"
  "2ea44905-3d9b-4bad-8f37-d64c932c8a79"
  "536102d8-7f7d-40a5-a259-f3604cfadb2f"
  "63643e10-b452-4550-8e3e-3ad28fd5c231"
  "8a68e9e8-598b-4e36-9cfa-df01577c0039"
  "f59a7b3f-f7f0-4d0b-b166-2cf852c58a65"
  "ea123e8f-1715-4b88-bcf7-708fdeabf331"
  "daeb891d-89ae-4524-9615-9e7b0c915213"
  "a2ff3a3f-2808-4c88-a431-ad170b9a8d78"
]

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 ('89240d79-7b97-44df-ac5b-d17703a69568','1603335d-698a-4267-97af-73eb0472c8c7','2ea44905-3d9b-4bad-8f37-d64c932c8a79','536102d8-7f7d-40a5-a259-f3604cfadb2f','63643e10-b452-4550-8e3e-3ad28fd5c231','8a68e9e8-598b-4e36-9cfa-df01577c0039','f59a7b3f-f7f0-4d0b-b166-2cf852c58a65','ea123e8f-1715-4b88-bcf7-708fdeabf331','daeb891d-89ae-4524-9615-9e7b0c915213','a2ff3a3f-2808-4c88-a431-ad170b9a8d78');