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

[
  "DCD35A63-CF77-4EA4-8426-882A48B0100E"
  "00E42061-9B31-4B7A-A880-9EC2D8BF8F7F"
  "00FFD57F-2FE5-45EF-9781-BABA3D79C671"
  "D1C397B6-C1B3-42BA-92D8-213CC582BAD7"
  "01035EAA-1377-4000-9FFA-2A9BFD04BF61"
  "A801B032-A09C-4D71-8CFE-50F5BAB4EFC8"
  "E75F52D5-F8D9-4C99-8091-FE67CAA2C922"
  "E25E4DD5-E18F-4334-8150-BA636D2A0F5B"
  "E2E600FA-903B-44A6-B5DB-252C21DF5DCA"
  "ED50268C-7B10-4DC9-BD59-17831C0C158E"
  "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 ('DCD35A63-CF77-4EA4-8426-882A48B0100E', '00E42061-9B31-4B7A-A880-9EC2D8BF8F7F', '00FFD57F-2FE5-45EF-9781-BABA3D79C671', 'D1C397B6-C1B3-42BA-92D8-213CC582BAD7', '01035EAA-1377-4000-9FFA-2A9BFD04BF61', 'A801B032-A09C-4D71-8CFE-50F5BAB4EFC8', 'E75F52D5-F8D9-4C99-8091-FE67CAA2C922', 'E25E4DD5-E18F-4334-8150-BA636D2A0F5B', 'E2E600FA-903B-44A6-B5DB-252C21DF5DCA', 'ED50268C-7B10-4DC9-BD59-17831C0C158E') 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

[
  "DCD35A63-CF77-4EA4-8426-882A48B0100E"
  "00E42061-9B31-4B7A-A880-9EC2D8BF8F7F"
  "00FFD57F-2FE5-45EF-9781-BABA3D79C671"
  "D1C397B6-C1B3-42BA-92D8-213CC582BAD7"
  "01035EAA-1377-4000-9FFA-2A9BFD04BF61"
  "A801B032-A09C-4D71-8CFE-50F5BAB4EFC8"
  "E75F52D5-F8D9-4C99-8091-FE67CAA2C922"
  "E25E4DD5-E18F-4334-8150-BA636D2A0F5B"
  "E2E600FA-903B-44A6-B5DB-252C21DF5DCA"
  "ED50268C-7B10-4DC9-BD59-17831C0C158E"
]

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 ('DCD35A63-CF77-4EA4-8426-882A48B0100E', '00E42061-9B31-4B7A-A880-9EC2D8BF8F7F', '00FFD57F-2FE5-45EF-9781-BABA3D79C671', 'D1C397B6-C1B3-42BA-92D8-213CC582BAD7', '01035EAA-1377-4000-9FFA-2A9BFD04BF61', 'A801B032-A09C-4D71-8CFE-50F5BAB4EFC8', 'E75F52D5-F8D9-4C99-8091-FE67CAA2C922', 'E25E4DD5-E18F-4334-8150-BA636D2A0F5B', 'E2E600FA-903B-44A6-B5DB-252C21DF5DCA', 'ED50268C-7B10-4DC9-BD59-17831C0C158E') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "dcd35a63-cf77-4ea4-8426-882a48b0100e"
  "00e42061-9b31-4b7a-a880-9ec2d8bf8f7f"
  "00ffd57f-2fe5-45ef-9781-baba3d79c671"
  "d1c397b6-c1b3-42ba-92d8-213cc582bad7"
  "01035eaa-1377-4000-9ffa-2a9bfd04bf61"
  "a801b032-a09c-4d71-8cfe-50f5bab4efc8"
  "e75f52d5-f8d9-4c99-8091-fe67caa2c922"
  "e25e4dd5-e18f-4334-8150-ba636d2a0f5b"
  "e2e600fa-903b-44a6-b5db-252c21df5dca"
  "ed50268c-7b10-4dc9-bd59-17831c0c158e"
]

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 ('dcd35a63-cf77-4ea4-8426-882a48b0100e','00e42061-9b31-4b7a-a880-9ec2d8bf8f7f','00ffd57f-2fe5-45ef-9781-baba3d79c671','d1c397b6-c1b3-42ba-92d8-213cc582bad7','01035eaa-1377-4000-9ffa-2a9bfd04bf61','a801b032-a09c-4d71-8cfe-50f5bab4efc8','e75f52d5-f8d9-4c99-8091-fe67caa2c922','e25e4dd5-e18f-4334-8150-ba636d2a0f5b','e2e600fa-903b-44a6-b5db-252c21df5dca','ed50268c-7b10-4dc9-bd59-17831c0c158e');