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

[
  "18B58C1E-CCE3-4B84-A017-25A4491804CF"
  "96F794BC-3117-4871-B544-3AA1101CD943"
  "55A41588-4FE9-4100-8E30-2432C4722919"
  "97F8A680-623F-4685-8B58-60A1977D3EA5"
  "34D65F91-9764-40F5-9ADD-DD1893F65393"
  "AC6B81A4-8E62-4B47-AB2E-5BB850E364D8"
  "A6B1ED51-6907-4DB6-B734-FA52CDDDC1D8"
  "C787360D-3CFE-466B-9ACB-C62BD15EE8D8"
  "E56C5E3E-ED4D-46E0-B5D4-6EB7F93B88A1"
  "F4C5BA78-59CF-4577-9CC2-E040B7D7ACDA"
  "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 ('18B58C1E-CCE3-4B84-A017-25A4491804CF', '96F794BC-3117-4871-B544-3AA1101CD943', '55A41588-4FE9-4100-8E30-2432C4722919', '97F8A680-623F-4685-8B58-60A1977D3EA5', '34D65F91-9764-40F5-9ADD-DD1893F65393', 'AC6B81A4-8E62-4B47-AB2E-5BB850E364D8', 'A6B1ED51-6907-4DB6-B734-FA52CDDDC1D8', 'C787360D-3CFE-466B-9ACB-C62BD15EE8D8', 'E56C5E3E-ED4D-46E0-B5D4-6EB7F93B88A1', 'F4C5BA78-59CF-4577-9CC2-E040B7D7ACDA') 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

[
  "18B58C1E-CCE3-4B84-A017-25A4491804CF"
  "96F794BC-3117-4871-B544-3AA1101CD943"
  "55A41588-4FE9-4100-8E30-2432C4722919"
  "97F8A680-623F-4685-8B58-60A1977D3EA5"
  "34D65F91-9764-40F5-9ADD-DD1893F65393"
  "AC6B81A4-8E62-4B47-AB2E-5BB850E364D8"
  "A6B1ED51-6907-4DB6-B734-FA52CDDDC1D8"
  "C787360D-3CFE-466B-9ACB-C62BD15EE8D8"
  "E56C5E3E-ED4D-46E0-B5D4-6EB7F93B88A1"
  "F4C5BA78-59CF-4577-9CC2-E040B7D7ACDA"
]

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 ('18B58C1E-CCE3-4B84-A017-25A4491804CF', '96F794BC-3117-4871-B544-3AA1101CD943', '55A41588-4FE9-4100-8E30-2432C4722919', '97F8A680-623F-4685-8B58-60A1977D3EA5', '34D65F91-9764-40F5-9ADD-DD1893F65393', 'AC6B81A4-8E62-4B47-AB2E-5BB850E364D8', 'A6B1ED51-6907-4DB6-B734-FA52CDDDC1D8', 'C787360D-3CFE-466B-9ACB-C62BD15EE8D8', 'E56C5E3E-ED4D-46E0-B5D4-6EB7F93B88A1', 'F4C5BA78-59CF-4577-9CC2-E040B7D7ACDA') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "18b58c1e-cce3-4b84-a017-25a4491804cf"
  "96f794bc-3117-4871-b544-3aa1101cd943"
  "55a41588-4fe9-4100-8e30-2432c4722919"
  "97f8a680-623f-4685-8b58-60a1977d3ea5"
  "34d65f91-9764-40f5-9add-dd1893f65393"
  "ac6b81a4-8e62-4b47-ab2e-5bb850e364d8"
  "a6b1ed51-6907-4db6-b734-fa52cdddc1d8"
  "c787360d-3cfe-466b-9acb-c62bd15ee8d8"
  "e56c5e3e-ed4d-46e0-b5d4-6eb7f93b88a1"
  "f4c5ba78-59cf-4577-9cc2-e040b7d7acda"
]

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 ('18b58c1e-cce3-4b84-a017-25a4491804cf','96f794bc-3117-4871-b544-3aa1101cd943','55a41588-4fe9-4100-8e30-2432c4722919','97f8a680-623f-4685-8b58-60a1977d3ea5','34d65f91-9764-40f5-9add-dd1893f65393','ac6b81a4-8e62-4b47-ab2e-5bb850e364d8','a6b1ed51-6907-4db6-b734-fa52cdddc1d8','c787360d-3cfe-466b-9acb-c62bd15ee8d8','e56c5e3e-ed4d-46e0-b5d4-6eb7f93b88a1','f4c5ba78-59cf-4577-9cc2-e040b7d7acda');