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

[
  "EFD85CB6-605D-4365-8A35-2D4EDB67B531"
  "19677A03-A01D-4D1E-9359-55AAB403B7D6"
  "95D3023A-2E7B-4848-947B-4AEFE46A6FE6"
  "1D12F0E9-7CF8-479E-9362-CD2361E1CF54"
  "3A9F2334-FDED-4C9D-8539-4A0C0CCFF314"
  "31D106D9-6C4B-4CD5-902D-C3281748AD8D"
  "3CEE0005-5442-4BD5-8B06-8F6BE06CB12A"
  "F503F8FC-0721-4E7B-BE92-1600DE1C46C4"
  "BD3ABB70-466C-4C40-8BB2-13B594B6751A"
  "E251948B-8858-48F8-ACEE-059025A4BDE4"
  "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 ('EFD85CB6-605D-4365-8A35-2D4EDB67B531', '19677A03-A01D-4D1E-9359-55AAB403B7D6', '95D3023A-2E7B-4848-947B-4AEFE46A6FE6', '1D12F0E9-7CF8-479E-9362-CD2361E1CF54', '3A9F2334-FDED-4C9D-8539-4A0C0CCFF314', '31D106D9-6C4B-4CD5-902D-C3281748AD8D', '3CEE0005-5442-4BD5-8B06-8F6BE06CB12A', 'F503F8FC-0721-4E7B-BE92-1600DE1C46C4', 'BD3ABB70-466C-4C40-8BB2-13B594B6751A', 'E251948B-8858-48F8-ACEE-059025A4BDE4') 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

[
  "EFD85CB6-605D-4365-8A35-2D4EDB67B531"
  "19677A03-A01D-4D1E-9359-55AAB403B7D6"
  "95D3023A-2E7B-4848-947B-4AEFE46A6FE6"
  "1D12F0E9-7CF8-479E-9362-CD2361E1CF54"
  "3A9F2334-FDED-4C9D-8539-4A0C0CCFF314"
  "31D106D9-6C4B-4CD5-902D-C3281748AD8D"
  "3CEE0005-5442-4BD5-8B06-8F6BE06CB12A"
  "F503F8FC-0721-4E7B-BE92-1600DE1C46C4"
  "BD3ABB70-466C-4C40-8BB2-13B594B6751A"
  "E251948B-8858-48F8-ACEE-059025A4BDE4"
]

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 ('EFD85CB6-605D-4365-8A35-2D4EDB67B531', '19677A03-A01D-4D1E-9359-55AAB403B7D6', '95D3023A-2E7B-4848-947B-4AEFE46A6FE6', '1D12F0E9-7CF8-479E-9362-CD2361E1CF54', '3A9F2334-FDED-4C9D-8539-4A0C0CCFF314', '31D106D9-6C4B-4CD5-902D-C3281748AD8D', '3CEE0005-5442-4BD5-8B06-8F6BE06CB12A', 'F503F8FC-0721-4E7B-BE92-1600DE1C46C4', 'BD3ABB70-466C-4C40-8BB2-13B594B6751A', 'E251948B-8858-48F8-ACEE-059025A4BDE4') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "efd85cb6-605d-4365-8a35-2d4edb67b531"
  "19677a03-a01d-4d1e-9359-55aab403b7d6"
  "95d3023a-2e7b-4848-947b-4aefe46a6fe6"
  "1d12f0e9-7cf8-479e-9362-cd2361e1cf54"
  "3a9f2334-fded-4c9d-8539-4a0c0ccff314"
  "31d106d9-6c4b-4cd5-902d-c3281748ad8d"
  "3cee0005-5442-4bd5-8b06-8f6be06cb12a"
  "f503f8fc-0721-4e7b-be92-1600de1c46c4"
  "bd3abb70-466c-4c40-8bb2-13b594b6751a"
  "e251948b-8858-48f8-acee-059025a4bde4"
]

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 ('efd85cb6-605d-4365-8a35-2d4edb67b531','19677a03-a01d-4d1e-9359-55aab403b7d6','95d3023a-2e7b-4848-947b-4aefe46a6fe6','1d12f0e9-7cf8-479e-9362-cd2361e1cf54','3a9f2334-fded-4c9d-8539-4a0c0ccff314','31d106d9-6c4b-4cd5-902d-c3281748ad8d','3cee0005-5442-4bd5-8b06-8f6be06cb12a','f503f8fc-0721-4e7b-be92-1600de1c46c4','bd3abb70-466c-4c40-8bb2-13b594b6751a','e251948b-8858-48f8-acee-059025a4bde4');