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

[
  "2EC58A64-2335-4745-8C95-D5920A30F9BA"
  "68A484ED-9BFC-42D7-A66A-29EA75EF3A3A"
  "2E26879D-F317-4E6D-A944-0EAEC5F224FE"
  "C0350A45-0702-4494-AD05-4712916AFAAE"
  "87105808-5F0C-4422-8D09-1E89DE5D7985"
  "B1E9DDD9-E3C0-4BB1-8162-B3DD2E0D3059"
  "B2AA9CCD-6378-42E0-BA21-59FD5662ED9E"
  "B1111DB5-7774-4469-AA77-05F776F26FEF"
  "0CEC9508-F0C3-4419-BFFE-688DBCAB0635"
  "AA01C039-8BE1-4D16-9E47-A61016868B59"
  "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 ('2EC58A64-2335-4745-8C95-D5920A30F9BA', '68A484ED-9BFC-42D7-A66A-29EA75EF3A3A', '2E26879D-F317-4E6D-A944-0EAEC5F224FE', 'C0350A45-0702-4494-AD05-4712916AFAAE', '87105808-5F0C-4422-8D09-1E89DE5D7985', 'B1E9DDD9-E3C0-4BB1-8162-B3DD2E0D3059', 'B2AA9CCD-6378-42E0-BA21-59FD5662ED9E', 'B1111DB5-7774-4469-AA77-05F776F26FEF', '0CEC9508-F0C3-4419-BFFE-688DBCAB0635', 'AA01C039-8BE1-4D16-9E47-A61016868B59') 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

[
  "2EC58A64-2335-4745-8C95-D5920A30F9BA"
  "68A484ED-9BFC-42D7-A66A-29EA75EF3A3A"
  "2E26879D-F317-4E6D-A944-0EAEC5F224FE"
  "C0350A45-0702-4494-AD05-4712916AFAAE"
  "87105808-5F0C-4422-8D09-1E89DE5D7985"
  "B1E9DDD9-E3C0-4BB1-8162-B3DD2E0D3059"
  "B2AA9CCD-6378-42E0-BA21-59FD5662ED9E"
  "B1111DB5-7774-4469-AA77-05F776F26FEF"
  "0CEC9508-F0C3-4419-BFFE-688DBCAB0635"
  "AA01C039-8BE1-4D16-9E47-A61016868B59"
]

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 ('2EC58A64-2335-4745-8C95-D5920A30F9BA', '68A484ED-9BFC-42D7-A66A-29EA75EF3A3A', '2E26879D-F317-4E6D-A944-0EAEC5F224FE', 'C0350A45-0702-4494-AD05-4712916AFAAE', '87105808-5F0C-4422-8D09-1E89DE5D7985', 'B1E9DDD9-E3C0-4BB1-8162-B3DD2E0D3059', 'B2AA9CCD-6378-42E0-BA21-59FD5662ED9E', 'B1111DB5-7774-4469-AA77-05F776F26FEF', '0CEC9508-F0C3-4419-BFFE-688DBCAB0635', 'AA01C039-8BE1-4D16-9E47-A61016868B59') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "2ec58a64-2335-4745-8c95-d5920a30f9ba"
  "68a484ed-9bfc-42d7-a66a-29ea75ef3a3a"
  "2e26879d-f317-4e6d-a944-0eaec5f224fe"
  "c0350a45-0702-4494-ad05-4712916afaae"
  "87105808-5f0c-4422-8d09-1e89de5d7985"
  "b1e9ddd9-e3c0-4bb1-8162-b3dd2e0d3059"
  "b2aa9ccd-6378-42e0-ba21-59fd5662ed9e"
  "b1111db5-7774-4469-aa77-05f776f26fef"
  "0cec9508-f0c3-4419-bffe-688dbcab0635"
  "aa01c039-8be1-4d16-9e47-a61016868b59"
]

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 ('2ec58a64-2335-4745-8c95-d5920a30f9ba','68a484ed-9bfc-42d7-a66a-29ea75ef3a3a','2e26879d-f317-4e6d-a944-0eaec5f224fe','c0350a45-0702-4494-ad05-4712916afaae','87105808-5f0c-4422-8d09-1e89de5d7985','b1e9ddd9-e3c0-4bb1-8162-b3dd2e0d3059','b2aa9ccd-6378-42e0-ba21-59fd5662ed9e','b1111db5-7774-4469-aa77-05f776f26fef','0cec9508-f0c3-4419-bffe-688dbcab0635','aa01c039-8be1-4d16-9e47-a61016868b59');