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

[
  "02C04DBC-F089-4D71-BB4F-97267E6501F1"
  "1A0705D6-A213-4E40-BC91-C450ECD2E202"
  "279C5F56-086C-40A3-A110-A9987CF7A529"
  "12DFED61-33BC-4C78-88B3-F33E7712C2E6"
  "224AE8A6-6DDE-4789-A758-EC1CB1B1F4BC"
  "2B1E5AD2-FFD7-49B4-A4C8-7AE9ED67AC30"
  "ECE45DB6-C9FE-4C28-B917-686F01064AC8"
  "C18D16D1-8E64-44ED-B50F-549DABA8C0BD"
  "8F2C418A-7C5C-4DDA-A315-253224AA368F"
  "90A3CD67-0C5F-4502-A979-48A2246CA216"
  "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 ('02C04DBC-F089-4D71-BB4F-97267E6501F1', '1A0705D6-A213-4E40-BC91-C450ECD2E202', '279C5F56-086C-40A3-A110-A9987CF7A529', '12DFED61-33BC-4C78-88B3-F33E7712C2E6', '224AE8A6-6DDE-4789-A758-EC1CB1B1F4BC', '2B1E5AD2-FFD7-49B4-A4C8-7AE9ED67AC30', 'ECE45DB6-C9FE-4C28-B917-686F01064AC8', 'C18D16D1-8E64-44ED-B50F-549DABA8C0BD', '8F2C418A-7C5C-4DDA-A315-253224AA368F', '90A3CD67-0C5F-4502-A979-48A2246CA216') 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

[
  "02C04DBC-F089-4D71-BB4F-97267E6501F1"
  "1A0705D6-A213-4E40-BC91-C450ECD2E202"
  "279C5F56-086C-40A3-A110-A9987CF7A529"
  "12DFED61-33BC-4C78-88B3-F33E7712C2E6"
  "224AE8A6-6DDE-4789-A758-EC1CB1B1F4BC"
  "2B1E5AD2-FFD7-49B4-A4C8-7AE9ED67AC30"
  "ECE45DB6-C9FE-4C28-B917-686F01064AC8"
  "C18D16D1-8E64-44ED-B50F-549DABA8C0BD"
  "8F2C418A-7C5C-4DDA-A315-253224AA368F"
  "90A3CD67-0C5F-4502-A979-48A2246CA216"
]

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 ('02C04DBC-F089-4D71-BB4F-97267E6501F1', '1A0705D6-A213-4E40-BC91-C450ECD2E202', '279C5F56-086C-40A3-A110-A9987CF7A529', '12DFED61-33BC-4C78-88B3-F33E7712C2E6', '224AE8A6-6DDE-4789-A758-EC1CB1B1F4BC', '2B1E5AD2-FFD7-49B4-A4C8-7AE9ED67AC30', 'ECE45DB6-C9FE-4C28-B917-686F01064AC8', 'C18D16D1-8E64-44ED-B50F-549DABA8C0BD', '8F2C418A-7C5C-4DDA-A315-253224AA368F', '90A3CD67-0C5F-4502-A979-48A2246CA216') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "02c04dbc-f089-4d71-bb4f-97267e6501f1"
  "1a0705d6-a213-4e40-bc91-c450ecd2e202"
  "279c5f56-086c-40a3-a110-a9987cf7a529"
  "12dfed61-33bc-4c78-88b3-f33e7712c2e6"
  "224ae8a6-6dde-4789-a758-ec1cb1b1f4bc"
  "2b1e5ad2-ffd7-49b4-a4c8-7ae9ed67ac30"
  "ece45db6-c9fe-4c28-b917-686f01064ac8"
  "c18d16d1-8e64-44ed-b50f-549daba8c0bd"
  "8f2c418a-7c5c-4dda-a315-253224aa368f"
  "90a3cd67-0c5f-4502-a979-48a2246ca216"
]

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 ('02c04dbc-f089-4d71-bb4f-97267e6501f1','1a0705d6-a213-4e40-bc91-c450ecd2e202','279c5f56-086c-40a3-a110-a9987cf7a529','12dfed61-33bc-4c78-88b3-f33e7712c2e6','224ae8a6-6dde-4789-a758-ec1cb1b1f4bc','2b1e5ad2-ffd7-49b4-a4c8-7ae9ed67ac30','ece45db6-c9fe-4c28-b917-686f01064ac8','c18d16d1-8e64-44ed-b50f-549daba8c0bd','8f2c418a-7c5c-4dda-a315-253224aa368f','90a3cd67-0c5f-4502-a979-48a2246ca216');