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

[
  "2FFF1E54-D845-4EC3-A5F1-785134C44648"
  "1200D173-6674-488A-BA83-10FC8EBE4251"
  "EC3D5E0E-4FFF-4FD1-8A50-33030C983B45"
  "82C19FCF-39D1-4A87-89BD-427C5304B565"
  "AE22358C-F99C-47FF-960E-22CA272F4655"
  "A1358A6F-4D8F-465A-A22E-922843031069"
  "B17D7C19-71A7-4810-AC38-D7F98EDA461D"
  "F0A91EAC-FDF7-4A62-AA0E-6FCC1CA7FC77"
  "131D93AA-E71F-45A8-AF6D-8ECAA2CAA8A3"
  "1149BDF0-C55A-4E9C-B4F6-1B60D51982F2"
  "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 ('2FFF1E54-D845-4EC3-A5F1-785134C44648', '1200D173-6674-488A-BA83-10FC8EBE4251', 'EC3D5E0E-4FFF-4FD1-8A50-33030C983B45', '82C19FCF-39D1-4A87-89BD-427C5304B565', 'AE22358C-F99C-47FF-960E-22CA272F4655', 'A1358A6F-4D8F-465A-A22E-922843031069', 'B17D7C19-71A7-4810-AC38-D7F98EDA461D', 'F0A91EAC-FDF7-4A62-AA0E-6FCC1CA7FC77', '131D93AA-E71F-45A8-AF6D-8ECAA2CAA8A3', '1149BDF0-C55A-4E9C-B4F6-1B60D51982F2') 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

[
  "2FFF1E54-D845-4EC3-A5F1-785134C44648"
  "1200D173-6674-488A-BA83-10FC8EBE4251"
  "EC3D5E0E-4FFF-4FD1-8A50-33030C983B45"
  "82C19FCF-39D1-4A87-89BD-427C5304B565"
  "AE22358C-F99C-47FF-960E-22CA272F4655"
  "A1358A6F-4D8F-465A-A22E-922843031069"
  "B17D7C19-71A7-4810-AC38-D7F98EDA461D"
  "F0A91EAC-FDF7-4A62-AA0E-6FCC1CA7FC77"
  "131D93AA-E71F-45A8-AF6D-8ECAA2CAA8A3"
  "1149BDF0-C55A-4E9C-B4F6-1B60D51982F2"
]

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 ('2FFF1E54-D845-4EC3-A5F1-785134C44648', '1200D173-6674-488A-BA83-10FC8EBE4251', 'EC3D5E0E-4FFF-4FD1-8A50-33030C983B45', '82C19FCF-39D1-4A87-89BD-427C5304B565', 'AE22358C-F99C-47FF-960E-22CA272F4655', 'A1358A6F-4D8F-465A-A22E-922843031069', 'B17D7C19-71A7-4810-AC38-D7F98EDA461D', 'F0A91EAC-FDF7-4A62-AA0E-6FCC1CA7FC77', '131D93AA-E71F-45A8-AF6D-8ECAA2CAA8A3', '1149BDF0-C55A-4E9C-B4F6-1B60D51982F2') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "2fff1e54-d845-4ec3-a5f1-785134c44648"
  "1200d173-6674-488a-ba83-10fc8ebe4251"
  "ec3d5e0e-4fff-4fd1-8a50-33030c983b45"
  "82c19fcf-39d1-4a87-89bd-427c5304b565"
  "ae22358c-f99c-47ff-960e-22ca272f4655"
  "a1358a6f-4d8f-465a-a22e-922843031069"
  "b17d7c19-71a7-4810-ac38-d7f98eda461d"
  "f0a91eac-fdf7-4a62-aa0e-6fcc1ca7fc77"
  "131d93aa-e71f-45a8-af6d-8ecaa2caa8a3"
  "1149bdf0-c55a-4e9c-b4f6-1b60d51982f2"
]

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 ('2fff1e54-d845-4ec3-a5f1-785134c44648','1200d173-6674-488a-ba83-10fc8ebe4251','ec3d5e0e-4fff-4fd1-8a50-33030c983b45','82c19fcf-39d1-4a87-89bd-427c5304b565','ae22358c-f99c-47ff-960e-22ca272f4655','a1358a6f-4d8f-465a-a22e-922843031069','b17d7c19-71a7-4810-ac38-d7f98eda461d','f0a91eac-fdf7-4a62-aa0e-6fcc1ca7fc77','131d93aa-e71f-45a8-af6d-8ecaa2caa8a3','1149bdf0-c55a-4e9c-b4f6-1b60d51982f2');