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

[
  "57FE3123-675C-409C-97F4-FECEC0C2A7C2"
  "E7B0013B-E4D7-4CE8-94F1-387C0EF33422"
  "20CB3C15-5FB2-49F2-9899-D781478BD8D8"
  "E29F4E55-9C0C-470F-8B48-2FEF83373BFA"
  "86ACB57F-CF7C-427E-BCC9-E99F67FBA99A"
  "C688CF7A-7368-4006-81C7-1A48F7EA2FC2"
  "3D5DC5E0-8071-41F7-9ABB-8A4D262EE603"
  "A06885A1-045A-44F5-87AF-9C0568970CB4"
  "3B7E035D-73D8-40FD-BCA5-38D93546FFAA"
  "D63A1EF5-7E72-4920-876E-56CF0B94EDDA"
  "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 ('57FE3123-675C-409C-97F4-FECEC0C2A7C2', 'E7B0013B-E4D7-4CE8-94F1-387C0EF33422', '20CB3C15-5FB2-49F2-9899-D781478BD8D8', 'E29F4E55-9C0C-470F-8B48-2FEF83373BFA', '86ACB57F-CF7C-427E-BCC9-E99F67FBA99A', 'C688CF7A-7368-4006-81C7-1A48F7EA2FC2', '3D5DC5E0-8071-41F7-9ABB-8A4D262EE603', 'A06885A1-045A-44F5-87AF-9C0568970CB4', '3B7E035D-73D8-40FD-BCA5-38D93546FFAA', 'D63A1EF5-7E72-4920-876E-56CF0B94EDDA') 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

[
  "57FE3123-675C-409C-97F4-FECEC0C2A7C2"
  "E7B0013B-E4D7-4CE8-94F1-387C0EF33422"
  "20CB3C15-5FB2-49F2-9899-D781478BD8D8"
  "E29F4E55-9C0C-470F-8B48-2FEF83373BFA"
  "86ACB57F-CF7C-427E-BCC9-E99F67FBA99A"
  "C688CF7A-7368-4006-81C7-1A48F7EA2FC2"
  "3D5DC5E0-8071-41F7-9ABB-8A4D262EE603"
  "A06885A1-045A-44F5-87AF-9C0568970CB4"
  "3B7E035D-73D8-40FD-BCA5-38D93546FFAA"
  "D63A1EF5-7E72-4920-876E-56CF0B94EDDA"
]

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 ('57FE3123-675C-409C-97F4-FECEC0C2A7C2', 'E7B0013B-E4D7-4CE8-94F1-387C0EF33422', '20CB3C15-5FB2-49F2-9899-D781478BD8D8', 'E29F4E55-9C0C-470F-8B48-2FEF83373BFA', '86ACB57F-CF7C-427E-BCC9-E99F67FBA99A', 'C688CF7A-7368-4006-81C7-1A48F7EA2FC2', '3D5DC5E0-8071-41F7-9ABB-8A4D262EE603', 'A06885A1-045A-44F5-87AF-9C0568970CB4', '3B7E035D-73D8-40FD-BCA5-38D93546FFAA', 'D63A1EF5-7E72-4920-876E-56CF0B94EDDA') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "57fe3123-675c-409c-97f4-fecec0c2a7c2"
  "e7b0013b-e4d7-4ce8-94f1-387c0ef33422"
  "20cb3c15-5fb2-49f2-9899-d781478bd8d8"
  "e29f4e55-9c0c-470f-8b48-2fef83373bfa"
  "86acb57f-cf7c-427e-bcc9-e99f67fba99a"
  "c688cf7a-7368-4006-81c7-1a48f7ea2fc2"
  "3d5dc5e0-8071-41f7-9abb-8a4d262ee603"
  "a06885a1-045a-44f5-87af-9c0568970cb4"
  "3b7e035d-73d8-40fd-bca5-38d93546ffaa"
  "d63a1ef5-7e72-4920-876e-56cf0b94edda"
]

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 ('57fe3123-675c-409c-97f4-fecec0c2a7c2','e7b0013b-e4d7-4ce8-94f1-387c0ef33422','20cb3c15-5fb2-49f2-9899-d781478bd8d8','e29f4e55-9c0c-470f-8b48-2fef83373bfa','86acb57f-cf7c-427e-bcc9-e99f67fba99a','c688cf7a-7368-4006-81c7-1a48f7ea2fc2','3d5dc5e0-8071-41f7-9abb-8a4d262ee603','a06885a1-045a-44f5-87af-9c0568970cb4','3b7e035d-73d8-40fd-bca5-38d93546ffaa','d63a1ef5-7e72-4920-876e-56cf0b94edda');