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

[
  "9DBF6428-3620-4751-A064-E14DF0CBC6CC"
  "2825A6D0-3BC7-49AB-A93B-E7AAE46B576D"
  "C1F5E8B6-3071-4AAC-8C1C-61B3AFBF091A"
  "609F86EB-1F52-4841-8E51-7A688C751EEE"
  "607DCB0F-3DF4-42A7-921D-07C772DD1734"
  "28BF5B5E-12BF-4BDB-87A1-E3241CBFB8EF"
  "F59FBF12-5DF7-4485-A1EE-F7AB0F5690EE"
  "284DEAD7-BBF7-4EBA-944D-0BDD715860D0"
  "54657AA7-E2FD-425E-A76A-3088771274FC"
  "FDA8F011-5587-416F-A3AE-D2E72071DD30"
  "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 ('9DBF6428-3620-4751-A064-E14DF0CBC6CC', '2825A6D0-3BC7-49AB-A93B-E7AAE46B576D', 'C1F5E8B6-3071-4AAC-8C1C-61B3AFBF091A', '609F86EB-1F52-4841-8E51-7A688C751EEE', '607DCB0F-3DF4-42A7-921D-07C772DD1734', '28BF5B5E-12BF-4BDB-87A1-E3241CBFB8EF', 'F59FBF12-5DF7-4485-A1EE-F7AB0F5690EE', '284DEAD7-BBF7-4EBA-944D-0BDD715860D0', '54657AA7-E2FD-425E-A76A-3088771274FC', 'FDA8F011-5587-416F-A3AE-D2E72071DD30') 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

[
  "9DBF6428-3620-4751-A064-E14DF0CBC6CC"
  "2825A6D0-3BC7-49AB-A93B-E7AAE46B576D"
  "C1F5E8B6-3071-4AAC-8C1C-61B3AFBF091A"
  "609F86EB-1F52-4841-8E51-7A688C751EEE"
  "607DCB0F-3DF4-42A7-921D-07C772DD1734"
  "28BF5B5E-12BF-4BDB-87A1-E3241CBFB8EF"
  "F59FBF12-5DF7-4485-A1EE-F7AB0F5690EE"
  "284DEAD7-BBF7-4EBA-944D-0BDD715860D0"
  "54657AA7-E2FD-425E-A76A-3088771274FC"
  "FDA8F011-5587-416F-A3AE-D2E72071DD30"
]

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 ('9DBF6428-3620-4751-A064-E14DF0CBC6CC', '2825A6D0-3BC7-49AB-A93B-E7AAE46B576D', 'C1F5E8B6-3071-4AAC-8C1C-61B3AFBF091A', '609F86EB-1F52-4841-8E51-7A688C751EEE', '607DCB0F-3DF4-42A7-921D-07C772DD1734', '28BF5B5E-12BF-4BDB-87A1-E3241CBFB8EF', 'F59FBF12-5DF7-4485-A1EE-F7AB0F5690EE', '284DEAD7-BBF7-4EBA-944D-0BDD715860D0', '54657AA7-E2FD-425E-A76A-3088771274FC', 'FDA8F011-5587-416F-A3AE-D2E72071DD30') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "9dbf6428-3620-4751-a064-e14df0cbc6cc"
  "2825a6d0-3bc7-49ab-a93b-e7aae46b576d"
  "c1f5e8b6-3071-4aac-8c1c-61b3afbf091a"
  "609f86eb-1f52-4841-8e51-7a688c751eee"
  "607dcb0f-3df4-42a7-921d-07c772dd1734"
  "28bf5b5e-12bf-4bdb-87a1-e3241cbfb8ef"
  "f59fbf12-5df7-4485-a1ee-f7ab0f5690ee"
  "284dead7-bbf7-4eba-944d-0bdd715860d0"
  "54657aa7-e2fd-425e-a76a-3088771274fc"
  "fda8f011-5587-416f-a3ae-d2e72071dd30"
]

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 ('9dbf6428-3620-4751-a064-e14df0cbc6cc','2825a6d0-3bc7-49ab-a93b-e7aae46b576d','c1f5e8b6-3071-4aac-8c1c-61b3afbf091a','609f86eb-1f52-4841-8e51-7a688c751eee','607dcb0f-3df4-42a7-921d-07c772dd1734','28bf5b5e-12bf-4bdb-87a1-e3241cbfb8ef','f59fbf12-5df7-4485-a1ee-f7ab0f5690ee','284dead7-bbf7-4eba-944d-0bdd715860d0','54657aa7-e2fd-425e-a76a-3088771274fc','fda8f011-5587-416f-a3ae-d2e72071dd30');