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

[
  "8CBF243E-FDF2-4702-94D0-6E47A92711FE"
  "5B0C7C2C-610E-4D8C-9D68-0ED371F1BACC"
  "62A2BEA2-E20D-4044-88C4-82CAE7D9E583"
  "AC279CC9-A8F6-4B7A-A17D-332F4BE34177"
  "17A3558F-CA81-4832-91B1-74B93954DC89"
  "FBFEB6D6-2105-4307-9B7D-024E0D3E17DD"
  "C3E31898-A3CB-4EC1-A9D0-6A0B80D88417"
  "6521EE7A-EABC-4056-82FA-439DD63EC45F"
  "D322A478-BD87-420F-936C-897801002825"
  "0E56F04C-F335-4C28-86B8-8572454E74A9"
  "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 ('8CBF243E-FDF2-4702-94D0-6E47A92711FE', '5B0C7C2C-610E-4D8C-9D68-0ED371F1BACC', '62A2BEA2-E20D-4044-88C4-82CAE7D9E583', 'AC279CC9-A8F6-4B7A-A17D-332F4BE34177', '17A3558F-CA81-4832-91B1-74B93954DC89', 'FBFEB6D6-2105-4307-9B7D-024E0D3E17DD', 'C3E31898-A3CB-4EC1-A9D0-6A0B80D88417', '6521EE7A-EABC-4056-82FA-439DD63EC45F', 'D322A478-BD87-420F-936C-897801002825', '0E56F04C-F335-4C28-86B8-8572454E74A9') 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

[
  "8CBF243E-FDF2-4702-94D0-6E47A92711FE"
  "5B0C7C2C-610E-4D8C-9D68-0ED371F1BACC"
  "62A2BEA2-E20D-4044-88C4-82CAE7D9E583"
  "AC279CC9-A8F6-4B7A-A17D-332F4BE34177"
  "17A3558F-CA81-4832-91B1-74B93954DC89"
  "FBFEB6D6-2105-4307-9B7D-024E0D3E17DD"
  "C3E31898-A3CB-4EC1-A9D0-6A0B80D88417"
  "6521EE7A-EABC-4056-82FA-439DD63EC45F"
  "D322A478-BD87-420F-936C-897801002825"
  "0E56F04C-F335-4C28-86B8-8572454E74A9"
]

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 ('8CBF243E-FDF2-4702-94D0-6E47A92711FE', '5B0C7C2C-610E-4D8C-9D68-0ED371F1BACC', '62A2BEA2-E20D-4044-88C4-82CAE7D9E583', 'AC279CC9-A8F6-4B7A-A17D-332F4BE34177', '17A3558F-CA81-4832-91B1-74B93954DC89', 'FBFEB6D6-2105-4307-9B7D-024E0D3E17DD', 'C3E31898-A3CB-4EC1-A9D0-6A0B80D88417', '6521EE7A-EABC-4056-82FA-439DD63EC45F', 'D322A478-BD87-420F-936C-897801002825', '0E56F04C-F335-4C28-86B8-8572454E74A9') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "8cbf243e-fdf2-4702-94d0-6e47a92711fe"
  "5b0c7c2c-610e-4d8c-9d68-0ed371f1bacc"
  "62a2bea2-e20d-4044-88c4-82cae7d9e583"
  "ac279cc9-a8f6-4b7a-a17d-332f4be34177"
  "17a3558f-ca81-4832-91b1-74b93954dc89"
  "fbfeb6d6-2105-4307-9b7d-024e0d3e17dd"
  "c3e31898-a3cb-4ec1-a9d0-6a0b80d88417"
  "6521ee7a-eabc-4056-82fa-439dd63ec45f"
  "d322a478-bd87-420f-936c-897801002825"
  "0e56f04c-f335-4c28-86b8-8572454e74a9"
]

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 ('8cbf243e-fdf2-4702-94d0-6e47a92711fe','5b0c7c2c-610e-4d8c-9d68-0ed371f1bacc','62a2bea2-e20d-4044-88c4-82cae7d9e583','ac279cc9-a8f6-4b7a-a17d-332f4be34177','17a3558f-ca81-4832-91b1-74b93954dc89','fbfeb6d6-2105-4307-9b7d-024e0d3e17dd','c3e31898-a3cb-4ec1-a9d0-6a0b80d88417','6521ee7a-eabc-4056-82fa-439dd63ec45f','d322a478-bd87-420f-936c-897801002825','0e56f04c-f335-4c28-86b8-8572454e74a9');