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

[
  "DA4CC546-E463-45B3-B2CC-73706D9E6546"
  "0D573257-2BF2-4250-A29F-7A96FDFFC8BA"
  "114D1BCF-386C-4359-99F0-1C1B03AFE461"
  "287100AF-93F0-4FC3-9B1C-846E609F2A3C"
  "DDF37ECF-CBEB-4079-A7C4-2731ED64E01D"
  "4F116BDD-8CA1-48D0-AC19-1E239F26D11C"
  "22DB4EAA-1BC0-4AE8-9463-BF120217FE4E"
  "94D54D5B-EA28-42B5-8474-1F2C335F8C63"
  "1C5F3159-A4C8-4681-89EF-5948751EF8E9"
  "D5C097F3-C7D7-480F-A64F-ACBB08FAA9D4"
  "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 ('DA4CC546-E463-45B3-B2CC-73706D9E6546', '0D573257-2BF2-4250-A29F-7A96FDFFC8BA', '114D1BCF-386C-4359-99F0-1C1B03AFE461', '287100AF-93F0-4FC3-9B1C-846E609F2A3C', 'DDF37ECF-CBEB-4079-A7C4-2731ED64E01D', '4F116BDD-8CA1-48D0-AC19-1E239F26D11C', '22DB4EAA-1BC0-4AE8-9463-BF120217FE4E', '94D54D5B-EA28-42B5-8474-1F2C335F8C63', '1C5F3159-A4C8-4681-89EF-5948751EF8E9', 'D5C097F3-C7D7-480F-A64F-ACBB08FAA9D4') 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

[
  "DA4CC546-E463-45B3-B2CC-73706D9E6546"
  "0D573257-2BF2-4250-A29F-7A96FDFFC8BA"
  "114D1BCF-386C-4359-99F0-1C1B03AFE461"
  "287100AF-93F0-4FC3-9B1C-846E609F2A3C"
  "DDF37ECF-CBEB-4079-A7C4-2731ED64E01D"
  "4F116BDD-8CA1-48D0-AC19-1E239F26D11C"
  "22DB4EAA-1BC0-4AE8-9463-BF120217FE4E"
  "94D54D5B-EA28-42B5-8474-1F2C335F8C63"
  "1C5F3159-A4C8-4681-89EF-5948751EF8E9"
  "D5C097F3-C7D7-480F-A64F-ACBB08FAA9D4"
]

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 ('DA4CC546-E463-45B3-B2CC-73706D9E6546', '0D573257-2BF2-4250-A29F-7A96FDFFC8BA', '114D1BCF-386C-4359-99F0-1C1B03AFE461', '287100AF-93F0-4FC3-9B1C-846E609F2A3C', 'DDF37ECF-CBEB-4079-A7C4-2731ED64E01D', '4F116BDD-8CA1-48D0-AC19-1E239F26D11C', '22DB4EAA-1BC0-4AE8-9463-BF120217FE4E', '94D54D5B-EA28-42B5-8474-1F2C335F8C63', '1C5F3159-A4C8-4681-89EF-5948751EF8E9', 'D5C097F3-C7D7-480F-A64F-ACBB08FAA9D4') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "da4cc546-e463-45b3-b2cc-73706d9e6546"
  "0d573257-2bf2-4250-a29f-7a96fdffc8ba"
  "114d1bcf-386c-4359-99f0-1c1b03afe461"
  "287100af-93f0-4fc3-9b1c-846e609f2a3c"
  "ddf37ecf-cbeb-4079-a7c4-2731ed64e01d"
  "4f116bdd-8ca1-48d0-ac19-1e239f26d11c"
  "22db4eaa-1bc0-4ae8-9463-bf120217fe4e"
  "94d54d5b-ea28-42b5-8474-1f2c335f8c63"
  "1c5f3159-a4c8-4681-89ef-5948751ef8e9"
  "d5c097f3-c7d7-480f-a64f-acbb08faa9d4"
]

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 ('da4cc546-e463-45b3-b2cc-73706d9e6546','0d573257-2bf2-4250-a29f-7a96fdffc8ba','114d1bcf-386c-4359-99f0-1c1b03afe461','287100af-93f0-4fc3-9b1c-846e609f2a3c','ddf37ecf-cbeb-4079-a7c4-2731ed64e01d','4f116bdd-8ca1-48d0-ac19-1e239f26d11c','22db4eaa-1bc0-4ae8-9463-bf120217fe4e','94d54d5b-ea28-42b5-8474-1f2c335f8c63','1c5f3159-a4c8-4681-89ef-5948751ef8e9','d5c097f3-c7d7-480f-a64f-acbb08faa9d4');