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

[
  "7B44A169-4C78-4713-B24B-44467B3E91F4"
  "E838348D-6433-4A7F-A4E8-CC375F9EEA69"
  "D8E1C70C-FF9B-4845-AFF4-EBAB097F40B2"
  "D0FE76CE-6CFC-4AEE-81B8-0BF7B660C22C"
  "7245FCD2-49A0-4538-B2A9-93460B487536"
  "0616B6D4-B7A7-4D12-B53D-F253A56D9761"
  "06D9391A-663D-4150-AA02-ADF22DF678E9"
  "AC3C4614-8B2E-4B91-A1D7-D4BF9F362681"
  "9EEBED16-D63C-4B9D-990D-E6DA24C65047"
  "6C1AA3C2-F805-4F67-9DD3-247A7C2CB22F"
  "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 ('7B44A169-4C78-4713-B24B-44467B3E91F4', 'E838348D-6433-4A7F-A4E8-CC375F9EEA69', 'D8E1C70C-FF9B-4845-AFF4-EBAB097F40B2', 'D0FE76CE-6CFC-4AEE-81B8-0BF7B660C22C', '7245FCD2-49A0-4538-B2A9-93460B487536', '0616B6D4-B7A7-4D12-B53D-F253A56D9761', '06D9391A-663D-4150-AA02-ADF22DF678E9', 'AC3C4614-8B2E-4B91-A1D7-D4BF9F362681', '9EEBED16-D63C-4B9D-990D-E6DA24C65047', '6C1AA3C2-F805-4F67-9DD3-247A7C2CB22F') 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

[
  "7B44A169-4C78-4713-B24B-44467B3E91F4"
  "E838348D-6433-4A7F-A4E8-CC375F9EEA69"
  "D8E1C70C-FF9B-4845-AFF4-EBAB097F40B2"
  "D0FE76CE-6CFC-4AEE-81B8-0BF7B660C22C"
  "7245FCD2-49A0-4538-B2A9-93460B487536"
  "0616B6D4-B7A7-4D12-B53D-F253A56D9761"
  "06D9391A-663D-4150-AA02-ADF22DF678E9"
  "AC3C4614-8B2E-4B91-A1D7-D4BF9F362681"
  "9EEBED16-D63C-4B9D-990D-E6DA24C65047"
  "6C1AA3C2-F805-4F67-9DD3-247A7C2CB22F"
]

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 ('7B44A169-4C78-4713-B24B-44467B3E91F4', 'E838348D-6433-4A7F-A4E8-CC375F9EEA69', 'D8E1C70C-FF9B-4845-AFF4-EBAB097F40B2', 'D0FE76CE-6CFC-4AEE-81B8-0BF7B660C22C', '7245FCD2-49A0-4538-B2A9-93460B487536', '0616B6D4-B7A7-4D12-B53D-F253A56D9761', '06D9391A-663D-4150-AA02-ADF22DF678E9', 'AC3C4614-8B2E-4B91-A1D7-D4BF9F362681', '9EEBED16-D63C-4B9D-990D-E6DA24C65047', '6C1AA3C2-F805-4F67-9DD3-247A7C2CB22F') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "7b44a169-4c78-4713-b24b-44467b3e91f4"
  "e838348d-6433-4a7f-a4e8-cc375f9eea69"
  "d8e1c70c-ff9b-4845-aff4-ebab097f40b2"
  "d0fe76ce-6cfc-4aee-81b8-0bf7b660c22c"
  "7245fcd2-49a0-4538-b2a9-93460b487536"
  "0616b6d4-b7a7-4d12-b53d-f253a56d9761"
  "06d9391a-663d-4150-aa02-adf22df678e9"
  "ac3c4614-8b2e-4b91-a1d7-d4bf9f362681"
  "9eebed16-d63c-4b9d-990d-e6da24c65047"
  "6c1aa3c2-f805-4f67-9dd3-247a7c2cb22f"
]

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 ('7b44a169-4c78-4713-b24b-44467b3e91f4','e838348d-6433-4a7f-a4e8-cc375f9eea69','d8e1c70c-ff9b-4845-aff4-ebab097f40b2','d0fe76ce-6cfc-4aee-81b8-0bf7b660c22c','7245fcd2-49a0-4538-b2a9-93460b487536','0616b6d4-b7a7-4d12-b53d-f253a56d9761','06d9391a-663d-4150-aa02-adf22df678e9','ac3c4614-8b2e-4b91-a1d7-d4bf9f362681','9eebed16-d63c-4b9d-990d-e6da24c65047','6c1aa3c2-f805-4f67-9dd3-247a7c2cb22f');