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

[
  "0812F18F-7352-46DF-840F-D631C6600BC2"
  "5BBCA863-C3EC-46F4-BE06-6B15D1D1B963"
  "A489A8EC-0744-4435-8E58-83F55F1BC597"
  "DA986FEE-21BB-41A6-89E4-29A39DF9926A"
  "61FDDD42-046C-449F-9B1E-B21912691779"
  "3ACFA245-A6CA-4763-8AB3-5EAA78072549"
  "8A2B6500-786E-4304-855B-58D6C7CD0C08"
  "8DB9A299-E270-4E32-AF20-344FC70F1CEE"
  "07544C8D-1781-4196-AAD1-8A6A6515FD8D"
  "CD45E593-D059-41A2-9DED-F000B3425134"
  "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 ('0812F18F-7352-46DF-840F-D631C6600BC2', '5BBCA863-C3EC-46F4-BE06-6B15D1D1B963', 'A489A8EC-0744-4435-8E58-83F55F1BC597', 'DA986FEE-21BB-41A6-89E4-29A39DF9926A', '61FDDD42-046C-449F-9B1E-B21912691779', '3ACFA245-A6CA-4763-8AB3-5EAA78072549', '8A2B6500-786E-4304-855B-58D6C7CD0C08', '8DB9A299-E270-4E32-AF20-344FC70F1CEE', '07544C8D-1781-4196-AAD1-8A6A6515FD8D', 'CD45E593-D059-41A2-9DED-F000B3425134') 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

[
  "0812F18F-7352-46DF-840F-D631C6600BC2"
  "5BBCA863-C3EC-46F4-BE06-6B15D1D1B963"
  "A489A8EC-0744-4435-8E58-83F55F1BC597"
  "DA986FEE-21BB-41A6-89E4-29A39DF9926A"
  "61FDDD42-046C-449F-9B1E-B21912691779"
  "3ACFA245-A6CA-4763-8AB3-5EAA78072549"
  "8A2B6500-786E-4304-855B-58D6C7CD0C08"
  "8DB9A299-E270-4E32-AF20-344FC70F1CEE"
  "07544C8D-1781-4196-AAD1-8A6A6515FD8D"
  "CD45E593-D059-41A2-9DED-F000B3425134"
]

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 ('0812F18F-7352-46DF-840F-D631C6600BC2', '5BBCA863-C3EC-46F4-BE06-6B15D1D1B963', 'A489A8EC-0744-4435-8E58-83F55F1BC597', 'DA986FEE-21BB-41A6-89E4-29A39DF9926A', '61FDDD42-046C-449F-9B1E-B21912691779', '3ACFA245-A6CA-4763-8AB3-5EAA78072549', '8A2B6500-786E-4304-855B-58D6C7CD0C08', '8DB9A299-E270-4E32-AF20-344FC70F1CEE', '07544C8D-1781-4196-AAD1-8A6A6515FD8D', 'CD45E593-D059-41A2-9DED-F000B3425134') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "0812f18f-7352-46df-840f-d631c6600bc2"
  "5bbca863-c3ec-46f4-be06-6b15d1d1b963"
  "a489a8ec-0744-4435-8e58-83f55f1bc597"
  "da986fee-21bb-41a6-89e4-29a39df9926a"
  "61fddd42-046c-449f-9b1e-b21912691779"
  "3acfa245-a6ca-4763-8ab3-5eaa78072549"
  "8a2b6500-786e-4304-855b-58d6c7cd0c08"
  "8db9a299-e270-4e32-af20-344fc70f1cee"
  "07544c8d-1781-4196-aad1-8a6a6515fd8d"
  "cd45e593-d059-41a2-9ded-f000b3425134"
]

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 ('0812f18f-7352-46df-840f-d631c6600bc2','5bbca863-c3ec-46f4-be06-6b15d1d1b963','a489a8ec-0744-4435-8e58-83f55f1bc597','da986fee-21bb-41a6-89e4-29a39df9926a','61fddd42-046c-449f-9b1e-b21912691779','3acfa245-a6ca-4763-8ab3-5eaa78072549','8a2b6500-786e-4304-855b-58d6c7cd0c08','8db9a299-e270-4e32-af20-344fc70f1cee','07544c8d-1781-4196-aad1-8a6a6515fd8d','cd45e593-d059-41a2-9ded-f000b3425134');