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

[
  "1CED1E9A-4DFC-46BF-AECB-700F98C9C774"
  "C0F92C59-CF38-4D64-B0D1-FE0135617A75"
  "41961E6E-1961-4C9E-8696-8DF3BA9ED741"
  "3F58437B-6220-45F3-9600-FB1C9D3BFC3C"
  "E5E9BDD9-D335-4CEE-A777-6847C53765AB"
  "30862071-9D69-4A1E-BBAA-9CD121E759D6"
  "BD4EF1D7-3A86-4291-95EB-BD04DDF5FAAA"
  "A86F1A23-F43C-44D2-ABDC-25A9DBB816C5"
  "E81331E2-BA09-444C-BAA2-1D2A0D0CDFB7"
  "9123A3E0-7999-4B5A-87CD-B3E761385504"
  "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 ('1CED1E9A-4DFC-46BF-AECB-700F98C9C774', 'C0F92C59-CF38-4D64-B0D1-FE0135617A75', '41961E6E-1961-4C9E-8696-8DF3BA9ED741', '3F58437B-6220-45F3-9600-FB1C9D3BFC3C', 'E5E9BDD9-D335-4CEE-A777-6847C53765AB', '30862071-9D69-4A1E-BBAA-9CD121E759D6', 'BD4EF1D7-3A86-4291-95EB-BD04DDF5FAAA', 'A86F1A23-F43C-44D2-ABDC-25A9DBB816C5', 'E81331E2-BA09-444C-BAA2-1D2A0D0CDFB7', '9123A3E0-7999-4B5A-87CD-B3E761385504') 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

[
  "1CED1E9A-4DFC-46BF-AECB-700F98C9C774"
  "C0F92C59-CF38-4D64-B0D1-FE0135617A75"
  "41961E6E-1961-4C9E-8696-8DF3BA9ED741"
  "3F58437B-6220-45F3-9600-FB1C9D3BFC3C"
  "E5E9BDD9-D335-4CEE-A777-6847C53765AB"
  "30862071-9D69-4A1E-BBAA-9CD121E759D6"
  "BD4EF1D7-3A86-4291-95EB-BD04DDF5FAAA"
  "A86F1A23-F43C-44D2-ABDC-25A9DBB816C5"
  "E81331E2-BA09-444C-BAA2-1D2A0D0CDFB7"
  "9123A3E0-7999-4B5A-87CD-B3E761385504"
]

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 ('1CED1E9A-4DFC-46BF-AECB-700F98C9C774', 'C0F92C59-CF38-4D64-B0D1-FE0135617A75', '41961E6E-1961-4C9E-8696-8DF3BA9ED741', '3F58437B-6220-45F3-9600-FB1C9D3BFC3C', 'E5E9BDD9-D335-4CEE-A777-6847C53765AB', '30862071-9D69-4A1E-BBAA-9CD121E759D6', 'BD4EF1D7-3A86-4291-95EB-BD04DDF5FAAA', 'A86F1A23-F43C-44D2-ABDC-25A9DBB816C5', 'E81331E2-BA09-444C-BAA2-1D2A0D0CDFB7', '9123A3E0-7999-4B5A-87CD-B3E761385504') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "1ced1e9a-4dfc-46bf-aecb-700f98c9c774"
  "c0f92c59-cf38-4d64-b0d1-fe0135617a75"
  "41961e6e-1961-4c9e-8696-8df3ba9ed741"
  "3f58437b-6220-45f3-9600-fb1c9d3bfc3c"
  "e5e9bdd9-d335-4cee-a777-6847c53765ab"
  "30862071-9d69-4a1e-bbaa-9cd121e759d6"
  "bd4ef1d7-3a86-4291-95eb-bd04ddf5faaa"
  "a86f1a23-f43c-44d2-abdc-25a9dbb816c5"
  "e81331e2-ba09-444c-baa2-1d2a0d0cdfb7"
  "9123a3e0-7999-4b5a-87cd-b3e761385504"
]

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 ('1ced1e9a-4dfc-46bf-aecb-700f98c9c774','c0f92c59-cf38-4d64-b0d1-fe0135617a75','41961e6e-1961-4c9e-8696-8df3ba9ed741','3f58437b-6220-45f3-9600-fb1c9d3bfc3c','e5e9bdd9-d335-4cee-a777-6847c53765ab','30862071-9d69-4a1e-bbaa-9cd121e759d6','bd4ef1d7-3a86-4291-95eb-bd04ddf5faaa','a86f1a23-f43c-44d2-abdc-25a9dbb816c5','e81331e2-ba09-444c-baa2-1d2a0d0cdfb7','9123a3e0-7999-4b5a-87cd-b3e761385504');