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

[
  "544F9860-D514-41BF-8831-6D9D42854B27"
  "882D797C-AB15-463B-8503-A179A68C43C6"
  "46328CA9-6A2B-4876-AE6F-390778E34724"
  "04F3BFBD-30D2-42EB-9257-E7AF4E106C02"
  "9E7F4EE2-68C0-4D70-B7F2-A8B342EAAEF7"
  "FF60E85E-0909-4D7F-8494-5A5E91D1DEB4"
  "41298425-F375-4BFF-B665-10BF423D35E9"
  "EAE4AAF7-0F88-4663-9404-512688C76552"
  "E0016763-DB32-4721-B460-BCDCC86F03C2"
  "751102DB-652E-4117-8CB0-82BE42AB2340"
  "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 ('544F9860-D514-41BF-8831-6D9D42854B27', '882D797C-AB15-463B-8503-A179A68C43C6', '46328CA9-6A2B-4876-AE6F-390778E34724', '04F3BFBD-30D2-42EB-9257-E7AF4E106C02', '9E7F4EE2-68C0-4D70-B7F2-A8B342EAAEF7', 'FF60E85E-0909-4D7F-8494-5A5E91D1DEB4', '41298425-F375-4BFF-B665-10BF423D35E9', 'EAE4AAF7-0F88-4663-9404-512688C76552', 'E0016763-DB32-4721-B460-BCDCC86F03C2', '751102DB-652E-4117-8CB0-82BE42AB2340') 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

[
  "544F9860-D514-41BF-8831-6D9D42854B27"
  "882D797C-AB15-463B-8503-A179A68C43C6"
  "46328CA9-6A2B-4876-AE6F-390778E34724"
  "04F3BFBD-30D2-42EB-9257-E7AF4E106C02"
  "9E7F4EE2-68C0-4D70-B7F2-A8B342EAAEF7"
  "FF60E85E-0909-4D7F-8494-5A5E91D1DEB4"
  "41298425-F375-4BFF-B665-10BF423D35E9"
  "EAE4AAF7-0F88-4663-9404-512688C76552"
  "E0016763-DB32-4721-B460-BCDCC86F03C2"
  "751102DB-652E-4117-8CB0-82BE42AB2340"
]

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 ('544F9860-D514-41BF-8831-6D9D42854B27', '882D797C-AB15-463B-8503-A179A68C43C6', '46328CA9-6A2B-4876-AE6F-390778E34724', '04F3BFBD-30D2-42EB-9257-E7AF4E106C02', '9E7F4EE2-68C0-4D70-B7F2-A8B342EAAEF7', 'FF60E85E-0909-4D7F-8494-5A5E91D1DEB4', '41298425-F375-4BFF-B665-10BF423D35E9', 'EAE4AAF7-0F88-4663-9404-512688C76552', 'E0016763-DB32-4721-B460-BCDCC86F03C2', '751102DB-652E-4117-8CB0-82BE42AB2340') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "544f9860-d514-41bf-8831-6d9d42854b27"
  "882d797c-ab15-463b-8503-a179a68c43c6"
  "46328ca9-6a2b-4876-ae6f-390778e34724"
  "04f3bfbd-30d2-42eb-9257-e7af4e106c02"
  "9e7f4ee2-68c0-4d70-b7f2-a8b342eaaef7"
  "ff60e85e-0909-4d7f-8494-5a5e91d1deb4"
  "41298425-f375-4bff-b665-10bf423d35e9"
  "eae4aaf7-0f88-4663-9404-512688c76552"
  "e0016763-db32-4721-b460-bcdcc86f03c2"
  "751102db-652e-4117-8cb0-82be42ab2340"
]

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 ('544f9860-d514-41bf-8831-6d9d42854b27','882d797c-ab15-463b-8503-a179a68c43c6','46328ca9-6a2b-4876-ae6f-390778e34724','04f3bfbd-30d2-42eb-9257-e7af4e106c02','9e7f4ee2-68c0-4d70-b7f2-a8b342eaaef7','ff60e85e-0909-4d7f-8494-5a5e91d1deb4','41298425-f375-4bff-b665-10bf423d35e9','eae4aaf7-0f88-4663-9404-512688c76552','e0016763-db32-4721-b460-bcdcc86f03c2','751102db-652e-4117-8cb0-82be42ab2340');