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

[
  "76427299-5C3A-409F-B9CA-24BA75581EAB"
  "1E592D9E-A313-44DE-BCD6-3A9DAEDBBA8D"
  "B5ABF344-EEE1-412C-9101-1FD4452A8234"
  "9D412A03-2565-4D39-B4FA-F009FC9B99C9"
  "C027DB22-1AB2-4905-930B-8E6393608042"
  "B16BE623-B2C7-41CF-AD47-A05E40CF88AD"
  "F48D397A-0E64-4B52-AA80-407D2752DE73"
  "79206E87-B596-4CCE-82FC-15840D2189F1"
  "7CBAE1AF-9271-4F62-B8FC-F08BCE309918"
  "A0E96A64-154C-43BB-A263-34F5A7141BE0"
  "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 ('76427299-5C3A-409F-B9CA-24BA75581EAB', '1E592D9E-A313-44DE-BCD6-3A9DAEDBBA8D', 'B5ABF344-EEE1-412C-9101-1FD4452A8234', '9D412A03-2565-4D39-B4FA-F009FC9B99C9', 'C027DB22-1AB2-4905-930B-8E6393608042', 'B16BE623-B2C7-41CF-AD47-A05E40CF88AD', 'F48D397A-0E64-4B52-AA80-407D2752DE73', '79206E87-B596-4CCE-82FC-15840D2189F1', '7CBAE1AF-9271-4F62-B8FC-F08BCE309918', 'A0E96A64-154C-43BB-A263-34F5A7141BE0') 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

[
  "76427299-5C3A-409F-B9CA-24BA75581EAB"
  "1E592D9E-A313-44DE-BCD6-3A9DAEDBBA8D"
  "B5ABF344-EEE1-412C-9101-1FD4452A8234"
  "9D412A03-2565-4D39-B4FA-F009FC9B99C9"
  "C027DB22-1AB2-4905-930B-8E6393608042"
  "B16BE623-B2C7-41CF-AD47-A05E40CF88AD"
  "F48D397A-0E64-4B52-AA80-407D2752DE73"
  "79206E87-B596-4CCE-82FC-15840D2189F1"
  "7CBAE1AF-9271-4F62-B8FC-F08BCE309918"
  "A0E96A64-154C-43BB-A263-34F5A7141BE0"
]

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 ('76427299-5C3A-409F-B9CA-24BA75581EAB', '1E592D9E-A313-44DE-BCD6-3A9DAEDBBA8D', 'B5ABF344-EEE1-412C-9101-1FD4452A8234', '9D412A03-2565-4D39-B4FA-F009FC9B99C9', 'C027DB22-1AB2-4905-930B-8E6393608042', 'B16BE623-B2C7-41CF-AD47-A05E40CF88AD', 'F48D397A-0E64-4B52-AA80-407D2752DE73', '79206E87-B596-4CCE-82FC-15840D2189F1', '7CBAE1AF-9271-4F62-B8FC-F08BCE309918', 'A0E96A64-154C-43BB-A263-34F5A7141BE0') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "76427299-5c3a-409f-b9ca-24ba75581eab"
  "1e592d9e-a313-44de-bcd6-3a9daedbba8d"
  "b5abf344-eee1-412c-9101-1fd4452a8234"
  "9d412a03-2565-4d39-b4fa-f009fc9b99c9"
  "c027db22-1ab2-4905-930b-8e6393608042"
  "b16be623-b2c7-41cf-ad47-a05e40cf88ad"
  "f48d397a-0e64-4b52-aa80-407d2752de73"
  "79206e87-b596-4cce-82fc-15840d2189f1"
  "7cbae1af-9271-4f62-b8fc-f08bce309918"
  "a0e96a64-154c-43bb-a263-34f5a7141be0"
]

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 ('76427299-5c3a-409f-b9ca-24ba75581eab','1e592d9e-a313-44de-bcd6-3a9daedbba8d','b5abf344-eee1-412c-9101-1fd4452a8234','9d412a03-2565-4d39-b4fa-f009fc9b99c9','c027db22-1ab2-4905-930b-8e6393608042','b16be623-b2c7-41cf-ad47-a05e40cf88ad','f48d397a-0e64-4b52-aa80-407d2752de73','79206e87-b596-4cce-82fc-15840d2189f1','7cbae1af-9271-4f62-b8fc-f08bce309918','a0e96a64-154c-43bb-a263-34f5a7141be0');