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

[
  "6D5C2F89-9A99-462E-BAD9-0D775AC01944"
  "E6BB5422-8AD3-48B2-B128-EA8036FBDD44"
  "387F8F4F-FEE1-427E-B63E-D95EC95E083B"
  "76292E3A-C900-4AE7-8B24-E34B527305C2"
  "5C6B1968-BE78-45F9-BE4B-19E5D6A6D53F"
  "3FF62C08-3CD9-4346-BC8A-30CA62674C37"
  "B6CA0DB2-8A94-4582-8BE6-684708A943EB"
  "3C732CAF-70BA-4F48-B671-6F6DA7D9C2DB"
  "DE82F0A8-8A06-4C43-B2AE-0C3CA9A0AE11"
  "BCD69CBC-B483-4D60-A42D-4D29C6631295"
  "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 ('6D5C2F89-9A99-462E-BAD9-0D775AC01944', 'E6BB5422-8AD3-48B2-B128-EA8036FBDD44', '387F8F4F-FEE1-427E-B63E-D95EC95E083B', '76292E3A-C900-4AE7-8B24-E34B527305C2', '5C6B1968-BE78-45F9-BE4B-19E5D6A6D53F', '3FF62C08-3CD9-4346-BC8A-30CA62674C37', 'B6CA0DB2-8A94-4582-8BE6-684708A943EB', '3C732CAF-70BA-4F48-B671-6F6DA7D9C2DB', 'DE82F0A8-8A06-4C43-B2AE-0C3CA9A0AE11', 'BCD69CBC-B483-4D60-A42D-4D29C6631295') 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

[
  "6D5C2F89-9A99-462E-BAD9-0D775AC01944"
  "E6BB5422-8AD3-48B2-B128-EA8036FBDD44"
  "387F8F4F-FEE1-427E-B63E-D95EC95E083B"
  "76292E3A-C900-4AE7-8B24-E34B527305C2"
  "5C6B1968-BE78-45F9-BE4B-19E5D6A6D53F"
  "3FF62C08-3CD9-4346-BC8A-30CA62674C37"
  "B6CA0DB2-8A94-4582-8BE6-684708A943EB"
  "3C732CAF-70BA-4F48-B671-6F6DA7D9C2DB"
  "DE82F0A8-8A06-4C43-B2AE-0C3CA9A0AE11"
  "BCD69CBC-B483-4D60-A42D-4D29C6631295"
]

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 ('6D5C2F89-9A99-462E-BAD9-0D775AC01944', 'E6BB5422-8AD3-48B2-B128-EA8036FBDD44', '387F8F4F-FEE1-427E-B63E-D95EC95E083B', '76292E3A-C900-4AE7-8B24-E34B527305C2', '5C6B1968-BE78-45F9-BE4B-19E5D6A6D53F', '3FF62C08-3CD9-4346-BC8A-30CA62674C37', 'B6CA0DB2-8A94-4582-8BE6-684708A943EB', '3C732CAF-70BA-4F48-B671-6F6DA7D9C2DB', 'DE82F0A8-8A06-4C43-B2AE-0C3CA9A0AE11', 'BCD69CBC-B483-4D60-A42D-4D29C6631295') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "6d5c2f89-9a99-462e-bad9-0d775ac01944"
  "e6bb5422-8ad3-48b2-b128-ea8036fbdd44"
  "387f8f4f-fee1-427e-b63e-d95ec95e083b"
  "76292e3a-c900-4ae7-8b24-e34b527305c2"
  "5c6b1968-be78-45f9-be4b-19e5d6a6d53f"
  "3ff62c08-3cd9-4346-bc8a-30ca62674c37"
  "b6ca0db2-8a94-4582-8be6-684708a943eb"
  "3c732caf-70ba-4f48-b671-6f6da7d9c2db"
  "de82f0a8-8a06-4c43-b2ae-0c3ca9a0ae11"
  "bcd69cbc-b483-4d60-a42d-4d29c6631295"
]

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 ('6d5c2f89-9a99-462e-bad9-0d775ac01944','e6bb5422-8ad3-48b2-b128-ea8036fbdd44','387f8f4f-fee1-427e-b63e-d95ec95e083b','76292e3a-c900-4ae7-8b24-e34b527305c2','5c6b1968-be78-45f9-be4b-19e5d6a6d53f','3ff62c08-3cd9-4346-bc8a-30ca62674c37','b6ca0db2-8a94-4582-8be6-684708a943eb','3c732caf-70ba-4f48-b671-6f6da7d9c2db','de82f0a8-8a06-4c43-b2ae-0c3ca9a0ae11','bcd69cbc-b483-4d60-a42d-4d29c6631295');