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

[
  "C417009E-1F4B-4460-AEC6-A9F8DC748843"
  "61BACA68-59D6-4970-B9BB-5B62486B9333"
  "FF7CDE78-DBAE-453C-A3CF-54767AB7069E"
  "615AA808-2769-4C1B-BA06-E2847C70200E"
  "A6F18808-8B6F-44DD-9D5F-92DD26B168AA"
  "F749393D-B684-4A8E-BF41-0F4EA869C0DD"
  "A0DD060C-FB3A-4696-9B67-94D6BCD7C22B"
  "74ACA66F-DA52-45DF-BF15-4A8661D69075"
  "8D4FACE9-5BB5-43E6-861F-04FC6E118879"
  "42CFCE46-8B7A-49C5-9AE4-4A46C77E7329"
  "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 ('C417009E-1F4B-4460-AEC6-A9F8DC748843', '61BACA68-59D6-4970-B9BB-5B62486B9333', 'FF7CDE78-DBAE-453C-A3CF-54767AB7069E', '615AA808-2769-4C1B-BA06-E2847C70200E', 'A6F18808-8B6F-44DD-9D5F-92DD26B168AA', 'F749393D-B684-4A8E-BF41-0F4EA869C0DD', 'A0DD060C-FB3A-4696-9B67-94D6BCD7C22B', '74ACA66F-DA52-45DF-BF15-4A8661D69075', '8D4FACE9-5BB5-43E6-861F-04FC6E118879', '42CFCE46-8B7A-49C5-9AE4-4A46C77E7329') 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

[
  "C417009E-1F4B-4460-AEC6-A9F8DC748843"
  "61BACA68-59D6-4970-B9BB-5B62486B9333"
  "FF7CDE78-DBAE-453C-A3CF-54767AB7069E"
  "615AA808-2769-4C1B-BA06-E2847C70200E"
  "A6F18808-8B6F-44DD-9D5F-92DD26B168AA"
  "F749393D-B684-4A8E-BF41-0F4EA869C0DD"
  "A0DD060C-FB3A-4696-9B67-94D6BCD7C22B"
  "74ACA66F-DA52-45DF-BF15-4A8661D69075"
  "8D4FACE9-5BB5-43E6-861F-04FC6E118879"
  "42CFCE46-8B7A-49C5-9AE4-4A46C77E7329"
]

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 ('C417009E-1F4B-4460-AEC6-A9F8DC748843', '61BACA68-59D6-4970-B9BB-5B62486B9333', 'FF7CDE78-DBAE-453C-A3CF-54767AB7069E', '615AA808-2769-4C1B-BA06-E2847C70200E', 'A6F18808-8B6F-44DD-9D5F-92DD26B168AA', 'F749393D-B684-4A8E-BF41-0F4EA869C0DD', 'A0DD060C-FB3A-4696-9B67-94D6BCD7C22B', '74ACA66F-DA52-45DF-BF15-4A8661D69075', '8D4FACE9-5BB5-43E6-861F-04FC6E118879', '42CFCE46-8B7A-49C5-9AE4-4A46C77E7329') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "c417009e-1f4b-4460-aec6-a9f8dc748843"
  "61baca68-59d6-4970-b9bb-5b62486b9333"
  "ff7cde78-dbae-453c-a3cf-54767ab7069e"
  "615aa808-2769-4c1b-ba06-e2847c70200e"
  "a6f18808-8b6f-44dd-9d5f-92dd26b168aa"
  "f749393d-b684-4a8e-bf41-0f4ea869c0dd"
  "a0dd060c-fb3a-4696-9b67-94d6bcd7c22b"
  "74aca66f-da52-45df-bf15-4a8661d69075"
  "8d4face9-5bb5-43e6-861f-04fc6e118879"
  "42cfce46-8b7a-49c5-9ae4-4a46c77e7329"
]

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 ('c417009e-1f4b-4460-aec6-a9f8dc748843','61baca68-59d6-4970-b9bb-5b62486b9333','ff7cde78-dbae-453c-a3cf-54767ab7069e','615aa808-2769-4c1b-ba06-e2847c70200e','a6f18808-8b6f-44dd-9d5f-92dd26b168aa','f749393d-b684-4a8e-bf41-0f4ea869c0dd','a0dd060c-fb3a-4696-9b67-94d6bcd7c22b','74aca66f-da52-45df-bf15-4a8661d69075','8d4face9-5bb5-43e6-861f-04fc6e118879','42cfce46-8b7a-49c5-9ae4-4a46c77e7329');