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

[
  "E9399235-B578-45D6-8C78-EA759DF1EB1A"
  "1D23D23C-13C0-4F33-83C4-E447D60B88C5"
  "98EC9D49-769A-40FE-9C79-928FD16B9120"
  "569BB115-A500-4A16-A440-0E9F5A042B11"
  "68AD5294-8538-495F-B0C5-FEA4139B37ED"
  "29C70031-1D2F-4EAC-B523-0317C9255D81"
  "AE83F4C4-863C-4D70-88E4-C0FD8BC07877"
  "76C008AE-927B-412E-AD5B-0F413B42EEF6"
  "CAD44349-8131-432C-8A37-36381E5BBBE4"
  "A5392BBD-22ED-46F1-921B-A81831CB857C"
  "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 ('E9399235-B578-45D6-8C78-EA759DF1EB1A', '1D23D23C-13C0-4F33-83C4-E447D60B88C5', '98EC9D49-769A-40FE-9C79-928FD16B9120', '569BB115-A500-4A16-A440-0E9F5A042B11', '68AD5294-8538-495F-B0C5-FEA4139B37ED', '29C70031-1D2F-4EAC-B523-0317C9255D81', 'AE83F4C4-863C-4D70-88E4-C0FD8BC07877', '76C008AE-927B-412E-AD5B-0F413B42EEF6', 'CAD44349-8131-432C-8A37-36381E5BBBE4', 'A5392BBD-22ED-46F1-921B-A81831CB857C') 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

[
  "E9399235-B578-45D6-8C78-EA759DF1EB1A"
  "1D23D23C-13C0-4F33-83C4-E447D60B88C5"
  "98EC9D49-769A-40FE-9C79-928FD16B9120"
  "569BB115-A500-4A16-A440-0E9F5A042B11"
  "68AD5294-8538-495F-B0C5-FEA4139B37ED"
  "29C70031-1D2F-4EAC-B523-0317C9255D81"
  "AE83F4C4-863C-4D70-88E4-C0FD8BC07877"
  "76C008AE-927B-412E-AD5B-0F413B42EEF6"
  "CAD44349-8131-432C-8A37-36381E5BBBE4"
  "A5392BBD-22ED-46F1-921B-A81831CB857C"
]

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 ('E9399235-B578-45D6-8C78-EA759DF1EB1A', '1D23D23C-13C0-4F33-83C4-E447D60B88C5', '98EC9D49-769A-40FE-9C79-928FD16B9120', '569BB115-A500-4A16-A440-0E9F5A042B11', '68AD5294-8538-495F-B0C5-FEA4139B37ED', '29C70031-1D2F-4EAC-B523-0317C9255D81', 'AE83F4C4-863C-4D70-88E4-C0FD8BC07877', '76C008AE-927B-412E-AD5B-0F413B42EEF6', 'CAD44349-8131-432C-8A37-36381E5BBBE4', 'A5392BBD-22ED-46F1-921B-A81831CB857C') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "e9399235-b578-45d6-8c78-ea759df1eb1a"
  "1d23d23c-13c0-4f33-83c4-e447d60b88c5"
  "98ec9d49-769a-40fe-9c79-928fd16b9120"
  "569bb115-a500-4a16-a440-0e9f5a042b11"
  "68ad5294-8538-495f-b0c5-fea4139b37ed"
  "29c70031-1d2f-4eac-b523-0317c9255d81"
  "ae83f4c4-863c-4d70-88e4-c0fd8bc07877"
  "76c008ae-927b-412e-ad5b-0f413b42eef6"
  "cad44349-8131-432c-8a37-36381e5bbbe4"
  "a5392bbd-22ed-46f1-921b-a81831cb857c"
]

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 ('e9399235-b578-45d6-8c78-ea759df1eb1a','1d23d23c-13c0-4f33-83c4-e447d60b88c5','98ec9d49-769a-40fe-9c79-928fd16b9120','569bb115-a500-4a16-a440-0e9f5a042b11','68ad5294-8538-495f-b0c5-fea4139b37ed','29c70031-1d2f-4eac-b523-0317c9255d81','ae83f4c4-863c-4d70-88e4-c0fd8bc07877','76c008ae-927b-412e-ad5b-0f413b42eef6','cad44349-8131-432c-8a37-36381e5bbbe4','a5392bbd-22ed-46f1-921b-a81831cb857c');