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

[
  "5B19F8E4-B8BE-4C34-8394-D4B22476EB3C"
  "F8BF0DED-9BF9-498F-8377-91D11569A0C7"
  "2665987E-5953-42CB-9BF8-201B8244B196"
  "09DCE75D-79B4-40FF-9D61-40499097E8AF"
  "2BBEE088-7AC9-402B-92D5-79373EB19203"
  "A8826C01-8729-43E1-BA20-8799529127B3"
  "C12E631F-76BA-4828-9422-9F1796F0EDBE"
  "9F94ADAC-AA4D-4A56-BC64-4E403C6AAED6"
  "717808DD-6C3B-4D19-B4C7-360D12B90496"
  "B73AB589-E172-46AF-B954-7DDB058D32D3"
  "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 ('5B19F8E4-B8BE-4C34-8394-D4B22476EB3C', 'F8BF0DED-9BF9-498F-8377-91D11569A0C7', '2665987E-5953-42CB-9BF8-201B8244B196', '09DCE75D-79B4-40FF-9D61-40499097E8AF', '2BBEE088-7AC9-402B-92D5-79373EB19203', 'A8826C01-8729-43E1-BA20-8799529127B3', 'C12E631F-76BA-4828-9422-9F1796F0EDBE', '9F94ADAC-AA4D-4A56-BC64-4E403C6AAED6', '717808DD-6C3B-4D19-B4C7-360D12B90496', 'B73AB589-E172-46AF-B954-7DDB058D32D3') 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

[
  "5B19F8E4-B8BE-4C34-8394-D4B22476EB3C"
  "F8BF0DED-9BF9-498F-8377-91D11569A0C7"
  "2665987E-5953-42CB-9BF8-201B8244B196"
  "09DCE75D-79B4-40FF-9D61-40499097E8AF"
  "2BBEE088-7AC9-402B-92D5-79373EB19203"
  "A8826C01-8729-43E1-BA20-8799529127B3"
  "C12E631F-76BA-4828-9422-9F1796F0EDBE"
  "9F94ADAC-AA4D-4A56-BC64-4E403C6AAED6"
  "717808DD-6C3B-4D19-B4C7-360D12B90496"
  "B73AB589-E172-46AF-B954-7DDB058D32D3"
]

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 ('5B19F8E4-B8BE-4C34-8394-D4B22476EB3C', 'F8BF0DED-9BF9-498F-8377-91D11569A0C7', '2665987E-5953-42CB-9BF8-201B8244B196', '09DCE75D-79B4-40FF-9D61-40499097E8AF', '2BBEE088-7AC9-402B-92D5-79373EB19203', 'A8826C01-8729-43E1-BA20-8799529127B3', 'C12E631F-76BA-4828-9422-9F1796F0EDBE', '9F94ADAC-AA4D-4A56-BC64-4E403C6AAED6', '717808DD-6C3B-4D19-B4C7-360D12B90496', 'B73AB589-E172-46AF-B954-7DDB058D32D3') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "5b19f8e4-b8be-4c34-8394-d4b22476eb3c"
  "f8bf0ded-9bf9-498f-8377-91d11569a0c7"
  "2665987e-5953-42cb-9bf8-201b8244b196"
  "09dce75d-79b4-40ff-9d61-40499097e8af"
  "2bbee088-7ac9-402b-92d5-79373eb19203"
  "a8826c01-8729-43e1-ba20-8799529127b3"
  "c12e631f-76ba-4828-9422-9f1796f0edbe"
  "9f94adac-aa4d-4a56-bc64-4e403c6aaed6"
  "717808dd-6c3b-4d19-b4c7-360d12b90496"
  "b73ab589-e172-46af-b954-7ddb058d32d3"
]

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 ('5b19f8e4-b8be-4c34-8394-d4b22476eb3c','f8bf0ded-9bf9-498f-8377-91d11569a0c7','2665987e-5953-42cb-9bf8-201b8244b196','09dce75d-79b4-40ff-9d61-40499097e8af','2bbee088-7ac9-402b-92d5-79373eb19203','a8826c01-8729-43e1-ba20-8799529127b3','c12e631f-76ba-4828-9422-9f1796f0edbe','9f94adac-aa4d-4a56-bc64-4e403c6aaed6','717808dd-6c3b-4d19-b4c7-360d12b90496','b73ab589-e172-46af-b954-7ddb058d32d3');