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

[
  "63547C2A-204C-4325-B1C1-EBC25899CC7F"
  "CA55A7E2-A310-4102-A4FF-ACC00229A91F"
  "1FF4D845-688F-4D57-ACEA-AEA496ED8245"
  "3453AF44-47C8-4BBC-A903-9428D7334D32"
  "59787B19-187C-4557-9429-74CD2FCB3BD9"
  "1F5C31BB-FF7E-437E-ABC0-1A48D7AFAE6A"
  "D73E9F1D-0B3C-4482-9C15-FE03A6ECA96E"
  "1C1AF4FB-333E-405C-940A-D7362F858CDF"
  "41F71F76-2802-440A-B189-C3145B442799"
  "250D3321-C3BB-4ADB-B861-179F4B0B050A"
  "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 ('63547C2A-204C-4325-B1C1-EBC25899CC7F', 'CA55A7E2-A310-4102-A4FF-ACC00229A91F', '1FF4D845-688F-4D57-ACEA-AEA496ED8245', '3453AF44-47C8-4BBC-A903-9428D7334D32', '59787B19-187C-4557-9429-74CD2FCB3BD9', '1F5C31BB-FF7E-437E-ABC0-1A48D7AFAE6A', 'D73E9F1D-0B3C-4482-9C15-FE03A6ECA96E', '1C1AF4FB-333E-405C-940A-D7362F858CDF', '41F71F76-2802-440A-B189-C3145B442799', '250D3321-C3BB-4ADB-B861-179F4B0B050A') 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

[
  "63547C2A-204C-4325-B1C1-EBC25899CC7F"
  "CA55A7E2-A310-4102-A4FF-ACC00229A91F"
  "1FF4D845-688F-4D57-ACEA-AEA496ED8245"
  "3453AF44-47C8-4BBC-A903-9428D7334D32"
  "59787B19-187C-4557-9429-74CD2FCB3BD9"
  "1F5C31BB-FF7E-437E-ABC0-1A48D7AFAE6A"
  "D73E9F1D-0B3C-4482-9C15-FE03A6ECA96E"
  "1C1AF4FB-333E-405C-940A-D7362F858CDF"
  "41F71F76-2802-440A-B189-C3145B442799"
  "250D3321-C3BB-4ADB-B861-179F4B0B050A"
]

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 ('63547C2A-204C-4325-B1C1-EBC25899CC7F', 'CA55A7E2-A310-4102-A4FF-ACC00229A91F', '1FF4D845-688F-4D57-ACEA-AEA496ED8245', '3453AF44-47C8-4BBC-A903-9428D7334D32', '59787B19-187C-4557-9429-74CD2FCB3BD9', '1F5C31BB-FF7E-437E-ABC0-1A48D7AFAE6A', 'D73E9F1D-0B3C-4482-9C15-FE03A6ECA96E', '1C1AF4FB-333E-405C-940A-D7362F858CDF', '41F71F76-2802-440A-B189-C3145B442799', '250D3321-C3BB-4ADB-B861-179F4B0B050A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "63547c2a-204c-4325-b1c1-ebc25899cc7f"
  "ca55a7e2-a310-4102-a4ff-acc00229a91f"
  "1ff4d845-688f-4d57-acea-aea496ed8245"
  "3453af44-47c8-4bbc-a903-9428d7334d32"
  "59787b19-187c-4557-9429-74cd2fcb3bd9"
  "1f5c31bb-ff7e-437e-abc0-1a48d7afae6a"
  "d73e9f1d-0b3c-4482-9c15-fe03a6eca96e"
  "1c1af4fb-333e-405c-940a-d7362f858cdf"
  "41f71f76-2802-440a-b189-c3145b442799"
  "250d3321-c3bb-4adb-b861-179f4b0b050a"
]

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 ('63547c2a-204c-4325-b1c1-ebc25899cc7f','ca55a7e2-a310-4102-a4ff-acc00229a91f','1ff4d845-688f-4d57-acea-aea496ed8245','3453af44-47c8-4bbc-a903-9428d7334d32','59787b19-187c-4557-9429-74cd2fcb3bd9','1f5c31bb-ff7e-437e-abc0-1a48d7afae6a','d73e9f1d-0b3c-4482-9c15-fe03a6eca96e','1c1af4fb-333e-405c-940a-d7362f858cdf','41f71f76-2802-440a-b189-c3145b442799','250d3321-c3bb-4adb-b861-179f4b0b050a');