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

[
  "B7C3996D-FCFE-4820-BC81-EF927F85D2AD"
  "9205678B-01E7-4630-A202-192F7900865A"
  "381B2932-0D7E-49B7-BC97-2FFDF92A566D"
  "00EC5E00-C8BA-49BE-95FF-911C5A80B6E5"
  "85C187AE-A9E3-4668-884B-BC6952C00F81"
  "A0CC5D1D-43C0-49EE-A16E-06E9D65FD276"
  "FB2E1DA4-C1AD-495D-88A0-8177AAEF18AF"
  "3016A2CE-9B87-4197-827C-E134E89331A4"
  "891308F9-ACE9-4387-A4AD-B66EED6FA69C"
  "F6EA34E0-6229-4106-BCEB-65A170A2560B"
  "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 ('B7C3996D-FCFE-4820-BC81-EF927F85D2AD', '9205678B-01E7-4630-A202-192F7900865A', '381B2932-0D7E-49B7-BC97-2FFDF92A566D', '00EC5E00-C8BA-49BE-95FF-911C5A80B6E5', '85C187AE-A9E3-4668-884B-BC6952C00F81', 'A0CC5D1D-43C0-49EE-A16E-06E9D65FD276', 'FB2E1DA4-C1AD-495D-88A0-8177AAEF18AF', '3016A2CE-9B87-4197-827C-E134E89331A4', '891308F9-ACE9-4387-A4AD-B66EED6FA69C', 'F6EA34E0-6229-4106-BCEB-65A170A2560B') 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

[
  "B7C3996D-FCFE-4820-BC81-EF927F85D2AD"
  "9205678B-01E7-4630-A202-192F7900865A"
  "381B2932-0D7E-49B7-BC97-2FFDF92A566D"
  "00EC5E00-C8BA-49BE-95FF-911C5A80B6E5"
  "85C187AE-A9E3-4668-884B-BC6952C00F81"
  "A0CC5D1D-43C0-49EE-A16E-06E9D65FD276"
  "FB2E1DA4-C1AD-495D-88A0-8177AAEF18AF"
  "3016A2CE-9B87-4197-827C-E134E89331A4"
  "891308F9-ACE9-4387-A4AD-B66EED6FA69C"
  "F6EA34E0-6229-4106-BCEB-65A170A2560B"
]

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 ('B7C3996D-FCFE-4820-BC81-EF927F85D2AD', '9205678B-01E7-4630-A202-192F7900865A', '381B2932-0D7E-49B7-BC97-2FFDF92A566D', '00EC5E00-C8BA-49BE-95FF-911C5A80B6E5', '85C187AE-A9E3-4668-884B-BC6952C00F81', 'A0CC5D1D-43C0-49EE-A16E-06E9D65FD276', 'FB2E1DA4-C1AD-495D-88A0-8177AAEF18AF', '3016A2CE-9B87-4197-827C-E134E89331A4', '891308F9-ACE9-4387-A4AD-B66EED6FA69C', 'F6EA34E0-6229-4106-BCEB-65A170A2560B') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "b7c3996d-fcfe-4820-bc81-ef927f85d2ad"
  "9205678b-01e7-4630-a202-192f7900865a"
  "381b2932-0d7e-49b7-bc97-2ffdf92a566d"
  "00ec5e00-c8ba-49be-95ff-911c5a80b6e5"
  "85c187ae-a9e3-4668-884b-bc6952c00f81"
  "a0cc5d1d-43c0-49ee-a16e-06e9d65fd276"
  "fb2e1da4-c1ad-495d-88a0-8177aaef18af"
  "3016a2ce-9b87-4197-827c-e134e89331a4"
  "891308f9-ace9-4387-a4ad-b66eed6fa69c"
  "f6ea34e0-6229-4106-bceb-65a170a2560b"
]

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 ('b7c3996d-fcfe-4820-bc81-ef927f85d2ad','9205678b-01e7-4630-a202-192f7900865a','381b2932-0d7e-49b7-bc97-2ffdf92a566d','00ec5e00-c8ba-49be-95ff-911c5a80b6e5','85c187ae-a9e3-4668-884b-bc6952c00f81','a0cc5d1d-43c0-49ee-a16e-06e9d65fd276','fb2e1da4-c1ad-495d-88a0-8177aaef18af','3016a2ce-9b87-4197-827c-e134e89331a4','891308f9-ace9-4387-a4ad-b66eed6fa69c','f6ea34e0-6229-4106-bceb-65a170a2560b');