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

[
  "B031906E-2737-49AC-BF1F-8FAD3DE2F270"
  "6C91E3CF-AF69-4743-A420-1D76FF73F50C"
  "BBD50284-8D62-4886-AE2F-04B9C151390C"
  "14BB4639-08B0-4921-901B-9080059971EB"
  "8D5E19BD-E943-4D1C-BA6B-70280B12022D"
  "DEBBC7E2-1B8C-404A-A9F7-126FAA0A912F"
  "A3F4F084-7AE3-48B4-8A65-8A74C8BB7168"
  "738FC8E0-E7F2-4CA9-8A85-6760F1E8FF6B"
  "C87D24FA-1C14-478E-8BD9-F864F6DBE903"
  "C591F888-B598-47DD-A653-E00E7A04F2FB"
  "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 ('B031906E-2737-49AC-BF1F-8FAD3DE2F270', '6C91E3CF-AF69-4743-A420-1D76FF73F50C', 'BBD50284-8D62-4886-AE2F-04B9C151390C', '14BB4639-08B0-4921-901B-9080059971EB', '8D5E19BD-E943-4D1C-BA6B-70280B12022D', 'DEBBC7E2-1B8C-404A-A9F7-126FAA0A912F', 'A3F4F084-7AE3-48B4-8A65-8A74C8BB7168', '738FC8E0-E7F2-4CA9-8A85-6760F1E8FF6B', 'C87D24FA-1C14-478E-8BD9-F864F6DBE903', 'C591F888-B598-47DD-A653-E00E7A04F2FB') 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

[
  "B031906E-2737-49AC-BF1F-8FAD3DE2F270"
  "6C91E3CF-AF69-4743-A420-1D76FF73F50C"
  "BBD50284-8D62-4886-AE2F-04B9C151390C"
  "14BB4639-08B0-4921-901B-9080059971EB"
  "8D5E19BD-E943-4D1C-BA6B-70280B12022D"
  "DEBBC7E2-1B8C-404A-A9F7-126FAA0A912F"
  "A3F4F084-7AE3-48B4-8A65-8A74C8BB7168"
  "738FC8E0-E7F2-4CA9-8A85-6760F1E8FF6B"
  "C87D24FA-1C14-478E-8BD9-F864F6DBE903"
  "C591F888-B598-47DD-A653-E00E7A04F2FB"
]

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 ('B031906E-2737-49AC-BF1F-8FAD3DE2F270', '6C91E3CF-AF69-4743-A420-1D76FF73F50C', 'BBD50284-8D62-4886-AE2F-04B9C151390C', '14BB4639-08B0-4921-901B-9080059971EB', '8D5E19BD-E943-4D1C-BA6B-70280B12022D', 'DEBBC7E2-1B8C-404A-A9F7-126FAA0A912F', 'A3F4F084-7AE3-48B4-8A65-8A74C8BB7168', '738FC8E0-E7F2-4CA9-8A85-6760F1E8FF6B', 'C87D24FA-1C14-478E-8BD9-F864F6DBE903', 'C591F888-B598-47DD-A653-E00E7A04F2FB') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "b031906e-2737-49ac-bf1f-8fad3de2f270"
  "6c91e3cf-af69-4743-a420-1d76ff73f50c"
  "bbd50284-8d62-4886-ae2f-04b9c151390c"
  "14bb4639-08b0-4921-901b-9080059971eb"
  "8d5e19bd-e943-4d1c-ba6b-70280b12022d"
  "debbc7e2-1b8c-404a-a9f7-126faa0a912f"
  "a3f4f084-7ae3-48b4-8a65-8a74c8bb7168"
  "738fc8e0-e7f2-4ca9-8a85-6760f1e8ff6b"
  "c87d24fa-1c14-478e-8bd9-f864f6dbe903"
  "c591f888-b598-47dd-a653-e00e7a04f2fb"
]

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 ('b031906e-2737-49ac-bf1f-8fad3de2f270','6c91e3cf-af69-4743-a420-1d76ff73f50c','bbd50284-8d62-4886-ae2f-04b9c151390c','14bb4639-08b0-4921-901b-9080059971eb','8d5e19bd-e943-4d1c-ba6b-70280b12022d','debbc7e2-1b8c-404a-a9f7-126faa0a912f','a3f4f084-7ae3-48b4-8a65-8a74c8bb7168','738fc8e0-e7f2-4ca9-8a85-6760f1e8ff6b','c87d24fa-1c14-478e-8bd9-f864f6dbe903','c591f888-b598-47dd-a653-e00e7a04f2fb');