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

[
  "6258C13A-66FD-44CA-B62A-C50923456E51"
  "1A099F5E-4FA9-4ED1-AAD1-3499E49C53D8"
  "F2A9256A-0681-494D-B9C2-FCE566D4CDA7"
  "93DAFF1F-284A-45B4-88DE-88EBAC2ECB9F"
  "8549BED8-419D-4237-8DF8-94D93F1FA468"
  "848C45A6-A8C1-4C1C-B343-1C32F0619786"
  "CF3D81C8-9B43-421B-89A8-266869331BDA"
  "F52F6981-C59C-42C8-B18F-D1941144DAD7"
  "6642BFB3-4AF1-4953-8C79-A0C2F97FA60D"
  "1C577655-700B-40A5-8E04-3C0BD287065D"
  "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 ('6258C13A-66FD-44CA-B62A-C50923456E51', '1A099F5E-4FA9-4ED1-AAD1-3499E49C53D8', 'F2A9256A-0681-494D-B9C2-FCE566D4CDA7', '93DAFF1F-284A-45B4-88DE-88EBAC2ECB9F', '8549BED8-419D-4237-8DF8-94D93F1FA468', '848C45A6-A8C1-4C1C-B343-1C32F0619786', 'CF3D81C8-9B43-421B-89A8-266869331BDA', 'F52F6981-C59C-42C8-B18F-D1941144DAD7', '6642BFB3-4AF1-4953-8C79-A0C2F97FA60D', '1C577655-700B-40A5-8E04-3C0BD287065D') 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

[
  "6258C13A-66FD-44CA-B62A-C50923456E51"
  "1A099F5E-4FA9-4ED1-AAD1-3499E49C53D8"
  "F2A9256A-0681-494D-B9C2-FCE566D4CDA7"
  "93DAFF1F-284A-45B4-88DE-88EBAC2ECB9F"
  "8549BED8-419D-4237-8DF8-94D93F1FA468"
  "848C45A6-A8C1-4C1C-B343-1C32F0619786"
  "CF3D81C8-9B43-421B-89A8-266869331BDA"
  "F52F6981-C59C-42C8-B18F-D1941144DAD7"
  "6642BFB3-4AF1-4953-8C79-A0C2F97FA60D"
  "1C577655-700B-40A5-8E04-3C0BD287065D"
]

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 ('6258C13A-66FD-44CA-B62A-C50923456E51', '1A099F5E-4FA9-4ED1-AAD1-3499E49C53D8', 'F2A9256A-0681-494D-B9C2-FCE566D4CDA7', '93DAFF1F-284A-45B4-88DE-88EBAC2ECB9F', '8549BED8-419D-4237-8DF8-94D93F1FA468', '848C45A6-A8C1-4C1C-B343-1C32F0619786', 'CF3D81C8-9B43-421B-89A8-266869331BDA', 'F52F6981-C59C-42C8-B18F-D1941144DAD7', '6642BFB3-4AF1-4953-8C79-A0C2F97FA60D', '1C577655-700B-40A5-8E04-3C0BD287065D') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "6258c13a-66fd-44ca-b62a-c50923456e51"
  "1a099f5e-4fa9-4ed1-aad1-3499e49c53d8"
  "f2a9256a-0681-494d-b9c2-fce566d4cda7"
  "93daff1f-284a-45b4-88de-88ebac2ecb9f"
  "8549bed8-419d-4237-8df8-94d93f1fa468"
  "848c45a6-a8c1-4c1c-b343-1c32f0619786"
  "cf3d81c8-9b43-421b-89a8-266869331bda"
  "f52f6981-c59c-42c8-b18f-d1941144dad7"
  "6642bfb3-4af1-4953-8c79-a0c2f97fa60d"
  "1c577655-700b-40a5-8e04-3c0bd287065d"
]

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 ('6258c13a-66fd-44ca-b62a-c50923456e51','1a099f5e-4fa9-4ed1-aad1-3499e49c53d8','f2a9256a-0681-494d-b9c2-fce566d4cda7','93daff1f-284a-45b4-88de-88ebac2ecb9f','8549bed8-419d-4237-8df8-94d93f1fa468','848c45a6-a8c1-4c1c-b343-1c32f0619786','cf3d81c8-9b43-421b-89a8-266869331bda','f52f6981-c59c-42c8-b18f-d1941144dad7','6642bfb3-4af1-4953-8c79-a0c2f97fa60d','1c577655-700b-40a5-8e04-3c0bd287065d');