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

[
  "A5CDDBAD-7C5D-4934-9A5C-2D4ED907D1C5"
  "FB0AD3CC-63BA-4997-B41A-E812CE8B3A30"
  "C4A09E36-D9F1-49A1-A8B4-C2DAC3C1E267"
  "B4F35535-9F93-4D33-8E2B-8ADBD1F958D6"
  "1EF06D29-8A0F-4535-AB9B-D0BBF31189DC"
  "4D3B7CD4-2E64-4986-ADCA-FA6F2A1C9CBA"
  "D670C68E-294C-4E8F-B6B2-417BE211D8CE"
  "10AD7273-373C-459B-9A79-54142951A290"
  "A085EFBF-A8D0-4B02-967D-9F97A2BB3B95"
  "F55932FC-8150-4C23-BA16-43A53D86EE50"
  "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 ('A5CDDBAD-7C5D-4934-9A5C-2D4ED907D1C5', 'FB0AD3CC-63BA-4997-B41A-E812CE8B3A30', 'C4A09E36-D9F1-49A1-A8B4-C2DAC3C1E267', 'B4F35535-9F93-4D33-8E2B-8ADBD1F958D6', '1EF06D29-8A0F-4535-AB9B-D0BBF31189DC', '4D3B7CD4-2E64-4986-ADCA-FA6F2A1C9CBA', 'D670C68E-294C-4E8F-B6B2-417BE211D8CE', '10AD7273-373C-459B-9A79-54142951A290', 'A085EFBF-A8D0-4B02-967D-9F97A2BB3B95', 'F55932FC-8150-4C23-BA16-43A53D86EE50') 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

[
  "A5CDDBAD-7C5D-4934-9A5C-2D4ED907D1C5"
  "FB0AD3CC-63BA-4997-B41A-E812CE8B3A30"
  "C4A09E36-D9F1-49A1-A8B4-C2DAC3C1E267"
  "B4F35535-9F93-4D33-8E2B-8ADBD1F958D6"
  "1EF06D29-8A0F-4535-AB9B-D0BBF31189DC"
  "4D3B7CD4-2E64-4986-ADCA-FA6F2A1C9CBA"
  "D670C68E-294C-4E8F-B6B2-417BE211D8CE"
  "10AD7273-373C-459B-9A79-54142951A290"
  "A085EFBF-A8D0-4B02-967D-9F97A2BB3B95"
  "F55932FC-8150-4C23-BA16-43A53D86EE50"
]

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 ('A5CDDBAD-7C5D-4934-9A5C-2D4ED907D1C5', 'FB0AD3CC-63BA-4997-B41A-E812CE8B3A30', 'C4A09E36-D9F1-49A1-A8B4-C2DAC3C1E267', 'B4F35535-9F93-4D33-8E2B-8ADBD1F958D6', '1EF06D29-8A0F-4535-AB9B-D0BBF31189DC', '4D3B7CD4-2E64-4986-ADCA-FA6F2A1C9CBA', 'D670C68E-294C-4E8F-B6B2-417BE211D8CE', '10AD7273-373C-459B-9A79-54142951A290', 'A085EFBF-A8D0-4B02-967D-9F97A2BB3B95', 'F55932FC-8150-4C23-BA16-43A53D86EE50') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "a5cddbad-7c5d-4934-9a5c-2d4ed907d1c5"
  "fb0ad3cc-63ba-4997-b41a-e812ce8b3a30"
  "c4a09e36-d9f1-49a1-a8b4-c2dac3c1e267"
  "b4f35535-9f93-4d33-8e2b-8adbd1f958d6"
  "1ef06d29-8a0f-4535-ab9b-d0bbf31189dc"
  "4d3b7cd4-2e64-4986-adca-fa6f2a1c9cba"
  "d670c68e-294c-4e8f-b6b2-417be211d8ce"
  "10ad7273-373c-459b-9a79-54142951a290"
  "a085efbf-a8d0-4b02-967d-9f97a2bb3b95"
  "f55932fc-8150-4c23-ba16-43a53d86ee50"
]

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 ('a5cddbad-7c5d-4934-9a5c-2d4ed907d1c5','fb0ad3cc-63ba-4997-b41a-e812ce8b3a30','c4a09e36-d9f1-49a1-a8b4-c2dac3c1e267','b4f35535-9f93-4d33-8e2b-8adbd1f958d6','1ef06d29-8a0f-4535-ab9b-d0bbf31189dc','4d3b7cd4-2e64-4986-adca-fa6f2a1c9cba','d670c68e-294c-4e8f-b6b2-417be211d8ce','10ad7273-373c-459b-9a79-54142951a290','a085efbf-a8d0-4b02-967d-9f97a2bb3b95','f55932fc-8150-4c23-ba16-43a53d86ee50');