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

[
  "A46A90F8-4938-4F28-B145-6966B928BAF2"
  "12E4D835-1060-4590-A8A8-9149B13DDDFA"
  "3C386497-2985-4360-9CC1-0D5F2A50F266"
  "010B60E9-47AC-446D-9E40-56A5E4E6144C"
  "160841D3-12B6-48D4-B61C-FEACEB055028"
  "B642A843-68C6-413D-8E55-15C13787BA9F"
  "30826190-6483-4F87-BAE9-AEBC53761DCF"
  "26A405B5-49EB-401E-A536-F289ACF13211"
  "59E28B2F-E514-4069-812D-B4C73B95B061"
  "D508E405-116A-46D3-809C-235A2001D4E3"
  "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 ('A46A90F8-4938-4F28-B145-6966B928BAF2', '12E4D835-1060-4590-A8A8-9149B13DDDFA', '3C386497-2985-4360-9CC1-0D5F2A50F266', '010B60E9-47AC-446D-9E40-56A5E4E6144C', '160841D3-12B6-48D4-B61C-FEACEB055028', 'B642A843-68C6-413D-8E55-15C13787BA9F', '30826190-6483-4F87-BAE9-AEBC53761DCF', '26A405B5-49EB-401E-A536-F289ACF13211', '59E28B2F-E514-4069-812D-B4C73B95B061', 'D508E405-116A-46D3-809C-235A2001D4E3') 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

[
  "A46A90F8-4938-4F28-B145-6966B928BAF2"
  "12E4D835-1060-4590-A8A8-9149B13DDDFA"
  "3C386497-2985-4360-9CC1-0D5F2A50F266"
  "010B60E9-47AC-446D-9E40-56A5E4E6144C"
  "160841D3-12B6-48D4-B61C-FEACEB055028"
  "B642A843-68C6-413D-8E55-15C13787BA9F"
  "30826190-6483-4F87-BAE9-AEBC53761DCF"
  "26A405B5-49EB-401E-A536-F289ACF13211"
  "59E28B2F-E514-4069-812D-B4C73B95B061"
  "D508E405-116A-46D3-809C-235A2001D4E3"
]

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 ('A46A90F8-4938-4F28-B145-6966B928BAF2', '12E4D835-1060-4590-A8A8-9149B13DDDFA', '3C386497-2985-4360-9CC1-0D5F2A50F266', '010B60E9-47AC-446D-9E40-56A5E4E6144C', '160841D3-12B6-48D4-B61C-FEACEB055028', 'B642A843-68C6-413D-8E55-15C13787BA9F', '30826190-6483-4F87-BAE9-AEBC53761DCF', '26A405B5-49EB-401E-A536-F289ACF13211', '59E28B2F-E514-4069-812D-B4C73B95B061', 'D508E405-116A-46D3-809C-235A2001D4E3') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "a46a90f8-4938-4f28-b145-6966b928baf2"
  "12e4d835-1060-4590-a8a8-9149b13dddfa"
  "3c386497-2985-4360-9cc1-0d5f2a50f266"
  "010b60e9-47ac-446d-9e40-56a5e4e6144c"
  "160841d3-12b6-48d4-b61c-feaceb055028"
  "b642a843-68c6-413d-8e55-15c13787ba9f"
  "30826190-6483-4f87-bae9-aebc53761dcf"
  "26a405b5-49eb-401e-a536-f289acf13211"
  "59e28b2f-e514-4069-812d-b4c73b95b061"
  "d508e405-116a-46d3-809c-235a2001d4e3"
]

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 ('a46a90f8-4938-4f28-b145-6966b928baf2','12e4d835-1060-4590-a8a8-9149b13dddfa','3c386497-2985-4360-9cc1-0d5f2a50f266','010b60e9-47ac-446d-9e40-56a5e4e6144c','160841d3-12b6-48d4-b61c-feaceb055028','b642a843-68c6-413d-8e55-15c13787ba9f','30826190-6483-4f87-bae9-aebc53761dcf','26a405b5-49eb-401e-a536-f289acf13211','59e28b2f-e514-4069-812d-b4c73b95b061','d508e405-116a-46d3-809c-235a2001d4e3');