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

[
  "2A4AA3C3-F1FF-4E25-8FF0-D6BA23344708"
  "51293D35-556D-4167-9D09-8CEF759D192E"
  "80DCDA63-840E-4769-B1BF-03ED35D34899"
  "68BC1565-134C-4CF5-9287-C7DC27F584EC"
  "889A6403-F7CF-4021-9AEF-BF0008A62250"
  "BFD4F0F7-3B02-4152-AC80-45A2F2476386"
  "E8A7D20D-7427-4337-913E-D46A929FB4A8"
  "C5C226F0-41C1-4B4D-BACC-188191CF487C"
  "74CB53EF-CFB1-49BD-8CDC-A94DA2330D7D"
  "DA374AEF-0C0B-4AE5-8711-406D79F6EAC1"
  "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 ('2A4AA3C3-F1FF-4E25-8FF0-D6BA23344708', '51293D35-556D-4167-9D09-8CEF759D192E', '80DCDA63-840E-4769-B1BF-03ED35D34899', '68BC1565-134C-4CF5-9287-C7DC27F584EC', '889A6403-F7CF-4021-9AEF-BF0008A62250', 'BFD4F0F7-3B02-4152-AC80-45A2F2476386', 'E8A7D20D-7427-4337-913E-D46A929FB4A8', 'C5C226F0-41C1-4B4D-BACC-188191CF487C', '74CB53EF-CFB1-49BD-8CDC-A94DA2330D7D', 'DA374AEF-0C0B-4AE5-8711-406D79F6EAC1') 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

[
  "2A4AA3C3-F1FF-4E25-8FF0-D6BA23344708"
  "51293D35-556D-4167-9D09-8CEF759D192E"
  "80DCDA63-840E-4769-B1BF-03ED35D34899"
  "68BC1565-134C-4CF5-9287-C7DC27F584EC"
  "889A6403-F7CF-4021-9AEF-BF0008A62250"
  "BFD4F0F7-3B02-4152-AC80-45A2F2476386"
  "E8A7D20D-7427-4337-913E-D46A929FB4A8"
  "C5C226F0-41C1-4B4D-BACC-188191CF487C"
  "74CB53EF-CFB1-49BD-8CDC-A94DA2330D7D"
  "DA374AEF-0C0B-4AE5-8711-406D79F6EAC1"
]

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 ('2A4AA3C3-F1FF-4E25-8FF0-D6BA23344708', '51293D35-556D-4167-9D09-8CEF759D192E', '80DCDA63-840E-4769-B1BF-03ED35D34899', '68BC1565-134C-4CF5-9287-C7DC27F584EC', '889A6403-F7CF-4021-9AEF-BF0008A62250', 'BFD4F0F7-3B02-4152-AC80-45A2F2476386', 'E8A7D20D-7427-4337-913E-D46A929FB4A8', 'C5C226F0-41C1-4B4D-BACC-188191CF487C', '74CB53EF-CFB1-49BD-8CDC-A94DA2330D7D', 'DA374AEF-0C0B-4AE5-8711-406D79F6EAC1') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "2a4aa3c3-f1ff-4e25-8ff0-d6ba23344708"
  "51293d35-556d-4167-9d09-8cef759d192e"
  "80dcda63-840e-4769-b1bf-03ed35d34899"
  "68bc1565-134c-4cf5-9287-c7dc27f584ec"
  "889a6403-f7cf-4021-9aef-bf0008a62250"
  "bfd4f0f7-3b02-4152-ac80-45a2f2476386"
  "e8a7d20d-7427-4337-913e-d46a929fb4a8"
  "c5c226f0-41c1-4b4d-bacc-188191cf487c"
  "74cb53ef-cfb1-49bd-8cdc-a94da2330d7d"
  "da374aef-0c0b-4ae5-8711-406d79f6eac1"
]

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 ('2a4aa3c3-f1ff-4e25-8ff0-d6ba23344708','51293d35-556d-4167-9d09-8cef759d192e','80dcda63-840e-4769-b1bf-03ed35d34899','68bc1565-134c-4cf5-9287-c7dc27f584ec','889a6403-f7cf-4021-9aef-bf0008a62250','bfd4f0f7-3b02-4152-ac80-45a2f2476386','e8a7d20d-7427-4337-913e-d46a929fb4a8','c5c226f0-41c1-4b4d-bacc-188191cf487c','74cb53ef-cfb1-49bd-8cdc-a94da2330d7d','da374aef-0c0b-4ae5-8711-406d79f6eac1');