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

[
  "2003DB32-2CE3-43DA-8E9D-304D96332ABD"
  "40ACAB92-88B2-4FB0-AF03-C4923D7DA50D"
  "FCF5E809-13FC-481E-B7B5-094E9FEB71B8"
  "2672575F-E745-45A5-B276-53D228C62D32"
  "4AC960C3-69C9-484B-A88D-334FE7259072"
  "E4D1D38F-5B0B-4B32-8A50-ED23BE5A4B7E"
  "50446995-7C25-4BCF-A31E-76C342093807"
  "D4F7BAE2-0FE8-4E9B-A80A-5CF41186E374"
  "573B7C8F-B869-4AAD-9C2C-7E53419DA788"
  "D7458A04-052E-4876-B4DF-22FDE0E5639A"
  "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 ('2003DB32-2CE3-43DA-8E9D-304D96332ABD', '40ACAB92-88B2-4FB0-AF03-C4923D7DA50D', 'FCF5E809-13FC-481E-B7B5-094E9FEB71B8', '2672575F-E745-45A5-B276-53D228C62D32', '4AC960C3-69C9-484B-A88D-334FE7259072', 'E4D1D38F-5B0B-4B32-8A50-ED23BE5A4B7E', '50446995-7C25-4BCF-A31E-76C342093807', 'D4F7BAE2-0FE8-4E9B-A80A-5CF41186E374', '573B7C8F-B869-4AAD-9C2C-7E53419DA788', 'D7458A04-052E-4876-B4DF-22FDE0E5639A') 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

[
  "2003DB32-2CE3-43DA-8E9D-304D96332ABD"
  "40ACAB92-88B2-4FB0-AF03-C4923D7DA50D"
  "FCF5E809-13FC-481E-B7B5-094E9FEB71B8"
  "2672575F-E745-45A5-B276-53D228C62D32"
  "4AC960C3-69C9-484B-A88D-334FE7259072"
  "E4D1D38F-5B0B-4B32-8A50-ED23BE5A4B7E"
  "50446995-7C25-4BCF-A31E-76C342093807"
  "D4F7BAE2-0FE8-4E9B-A80A-5CF41186E374"
  "573B7C8F-B869-4AAD-9C2C-7E53419DA788"
  "D7458A04-052E-4876-B4DF-22FDE0E5639A"
]

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 ('2003DB32-2CE3-43DA-8E9D-304D96332ABD', '40ACAB92-88B2-4FB0-AF03-C4923D7DA50D', 'FCF5E809-13FC-481E-B7B5-094E9FEB71B8', '2672575F-E745-45A5-B276-53D228C62D32', '4AC960C3-69C9-484B-A88D-334FE7259072', 'E4D1D38F-5B0B-4B32-8A50-ED23BE5A4B7E', '50446995-7C25-4BCF-A31E-76C342093807', 'D4F7BAE2-0FE8-4E9B-A80A-5CF41186E374', '573B7C8F-B869-4AAD-9C2C-7E53419DA788', 'D7458A04-052E-4876-B4DF-22FDE0E5639A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "2003db32-2ce3-43da-8e9d-304d96332abd"
  "40acab92-88b2-4fb0-af03-c4923d7da50d"
  "fcf5e809-13fc-481e-b7b5-094e9feb71b8"
  "2672575f-e745-45a5-b276-53d228c62d32"
  "4ac960c3-69c9-484b-a88d-334fe7259072"
  "e4d1d38f-5b0b-4b32-8a50-ed23be5a4b7e"
  "50446995-7c25-4bcf-a31e-76c342093807"
  "d4f7bae2-0fe8-4e9b-a80a-5cf41186e374"
  "573b7c8f-b869-4aad-9c2c-7e53419da788"
  "d7458a04-052e-4876-b4df-22fde0e5639a"
]

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 ('2003db32-2ce3-43da-8e9d-304d96332abd','40acab92-88b2-4fb0-af03-c4923d7da50d','fcf5e809-13fc-481e-b7b5-094e9feb71b8','2672575f-e745-45a5-b276-53d228c62d32','4ac960c3-69c9-484b-a88d-334fe7259072','e4d1d38f-5b0b-4b32-8a50-ed23be5a4b7e','50446995-7c25-4bcf-a31e-76c342093807','d4f7bae2-0fe8-4e9b-a80a-5cf41186e374','573b7c8f-b869-4aad-9c2c-7e53419da788','d7458a04-052e-4876-b4df-22fde0e5639a');