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

[
  "46D43C32-115D-47BF-B22D-956815A78971"
  "052AB0B8-2BB1-45E3-B5F5-B5F4E57F629B"
  "E037E09B-AA3E-4E80-A190-692EB1D76C8B"
  "A40DC7FE-59C5-45EE-B2E6-0BCA97C84BE0"
  "7BA04315-1F91-48B6-931E-E409B8F32092"
  "E9EDA393-5648-4A78-A2F4-83CEABA0723A"
  "6AC70063-D35F-4DCC-9226-DC941C5CE20B"
  "A32651AC-F857-4AB5-BF4A-F5DDEE65F2DF"
  "FB6B5781-FD0E-469C-88DA-99A551CDA381"
  "18E4D7B6-1DB0-4156-B6DD-826BB60A5147"
  "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 ('46D43C32-115D-47BF-B22D-956815A78971', '052AB0B8-2BB1-45E3-B5F5-B5F4E57F629B', 'E037E09B-AA3E-4E80-A190-692EB1D76C8B', 'A40DC7FE-59C5-45EE-B2E6-0BCA97C84BE0', '7BA04315-1F91-48B6-931E-E409B8F32092', 'E9EDA393-5648-4A78-A2F4-83CEABA0723A', '6AC70063-D35F-4DCC-9226-DC941C5CE20B', 'A32651AC-F857-4AB5-BF4A-F5DDEE65F2DF', 'FB6B5781-FD0E-469C-88DA-99A551CDA381', '18E4D7B6-1DB0-4156-B6DD-826BB60A5147') 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

[
  "46D43C32-115D-47BF-B22D-956815A78971"
  "052AB0B8-2BB1-45E3-B5F5-B5F4E57F629B"
  "E037E09B-AA3E-4E80-A190-692EB1D76C8B"
  "A40DC7FE-59C5-45EE-B2E6-0BCA97C84BE0"
  "7BA04315-1F91-48B6-931E-E409B8F32092"
  "E9EDA393-5648-4A78-A2F4-83CEABA0723A"
  "6AC70063-D35F-4DCC-9226-DC941C5CE20B"
  "A32651AC-F857-4AB5-BF4A-F5DDEE65F2DF"
  "FB6B5781-FD0E-469C-88DA-99A551CDA381"
  "18E4D7B6-1DB0-4156-B6DD-826BB60A5147"
]

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 ('46D43C32-115D-47BF-B22D-956815A78971', '052AB0B8-2BB1-45E3-B5F5-B5F4E57F629B', 'E037E09B-AA3E-4E80-A190-692EB1D76C8B', 'A40DC7FE-59C5-45EE-B2E6-0BCA97C84BE0', '7BA04315-1F91-48B6-931E-E409B8F32092', 'E9EDA393-5648-4A78-A2F4-83CEABA0723A', '6AC70063-D35F-4DCC-9226-DC941C5CE20B', 'A32651AC-F857-4AB5-BF4A-F5DDEE65F2DF', 'FB6B5781-FD0E-469C-88DA-99A551CDA381', '18E4D7B6-1DB0-4156-B6DD-826BB60A5147') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "46d43c32-115d-47bf-b22d-956815a78971"
  "052ab0b8-2bb1-45e3-b5f5-b5f4e57f629b"
  "e037e09b-aa3e-4e80-a190-692eb1d76c8b"
  "a40dc7fe-59c5-45ee-b2e6-0bca97c84be0"
  "7ba04315-1f91-48b6-931e-e409b8f32092"
  "e9eda393-5648-4a78-a2f4-83ceaba0723a"
  "6ac70063-d35f-4dcc-9226-dc941c5ce20b"
  "a32651ac-f857-4ab5-bf4a-f5ddee65f2df"
  "fb6b5781-fd0e-469c-88da-99a551cda381"
  "18e4d7b6-1db0-4156-b6dd-826bb60a5147"
]

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 ('46d43c32-115d-47bf-b22d-956815a78971','052ab0b8-2bb1-45e3-b5f5-b5f4e57f629b','e037e09b-aa3e-4e80-a190-692eb1d76c8b','a40dc7fe-59c5-45ee-b2e6-0bca97c84be0','7ba04315-1f91-48b6-931e-e409b8f32092','e9eda393-5648-4a78-a2f4-83ceaba0723a','6ac70063-d35f-4dcc-9226-dc941c5ce20b','a32651ac-f857-4ab5-bf4a-f5ddee65f2df','fb6b5781-fd0e-469c-88da-99a551cda381','18e4d7b6-1db0-4156-b6dd-826bb60a5147');