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

[
  "5303D6F6-EA72-4ABC-8AF5-890F2C8CFAF8"
  "89C0A9DA-BF38-422D-8C59-591B7ABDE7F5"
  "70848BB0-E31E-49CD-B8C3-73E61D8F988B"
  "207747B1-10C6-4041-9870-79BFCEC4CFAE"
  "CA41979D-2F05-4120-ABFA-328ECD43D62E"
  "463989BF-C68C-4F3D-A256-B6B65B85BFDD"
  "F51D2586-80E8-428D-8B90-03675FBA73B9"
  "3EED6167-9A5A-43EB-A0D3-A3216E8A575B"
  "881A28AA-37BD-44B1-A7D8-88615FAB72B7"
  "25435A60-90AD-4C9A-9936-47B12BBB33ED"
  "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 ('5303D6F6-EA72-4ABC-8AF5-890F2C8CFAF8', '89C0A9DA-BF38-422D-8C59-591B7ABDE7F5', '70848BB0-E31E-49CD-B8C3-73E61D8F988B', '207747B1-10C6-4041-9870-79BFCEC4CFAE', 'CA41979D-2F05-4120-ABFA-328ECD43D62E', '463989BF-C68C-4F3D-A256-B6B65B85BFDD', 'F51D2586-80E8-428D-8B90-03675FBA73B9', '3EED6167-9A5A-43EB-A0D3-A3216E8A575B', '881A28AA-37BD-44B1-A7D8-88615FAB72B7', '25435A60-90AD-4C9A-9936-47B12BBB33ED') 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

[
  "5303D6F6-EA72-4ABC-8AF5-890F2C8CFAF8"
  "89C0A9DA-BF38-422D-8C59-591B7ABDE7F5"
  "70848BB0-E31E-49CD-B8C3-73E61D8F988B"
  "207747B1-10C6-4041-9870-79BFCEC4CFAE"
  "CA41979D-2F05-4120-ABFA-328ECD43D62E"
  "463989BF-C68C-4F3D-A256-B6B65B85BFDD"
  "F51D2586-80E8-428D-8B90-03675FBA73B9"
  "3EED6167-9A5A-43EB-A0D3-A3216E8A575B"
  "881A28AA-37BD-44B1-A7D8-88615FAB72B7"
  "25435A60-90AD-4C9A-9936-47B12BBB33ED"
]

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 ('5303D6F6-EA72-4ABC-8AF5-890F2C8CFAF8', '89C0A9DA-BF38-422D-8C59-591B7ABDE7F5', '70848BB0-E31E-49CD-B8C3-73E61D8F988B', '207747B1-10C6-4041-9870-79BFCEC4CFAE', 'CA41979D-2F05-4120-ABFA-328ECD43D62E', '463989BF-C68C-4F3D-A256-B6B65B85BFDD', 'F51D2586-80E8-428D-8B90-03675FBA73B9', '3EED6167-9A5A-43EB-A0D3-A3216E8A575B', '881A28AA-37BD-44B1-A7D8-88615FAB72B7', '25435A60-90AD-4C9A-9936-47B12BBB33ED') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "5303d6f6-ea72-4abc-8af5-890f2c8cfaf8"
  "89c0a9da-bf38-422d-8c59-591b7abde7f5"
  "70848bb0-e31e-49cd-b8c3-73e61d8f988b"
  "207747b1-10c6-4041-9870-79bfcec4cfae"
  "ca41979d-2f05-4120-abfa-328ecd43d62e"
  "463989bf-c68c-4f3d-a256-b6b65b85bfdd"
  "f51d2586-80e8-428d-8b90-03675fba73b9"
  "3eed6167-9a5a-43eb-a0d3-a3216e8a575b"
  "881a28aa-37bd-44b1-a7d8-88615fab72b7"
  "25435a60-90ad-4c9a-9936-47b12bbb33ed"
]

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 ('5303d6f6-ea72-4abc-8af5-890f2c8cfaf8','89c0a9da-bf38-422d-8c59-591b7abde7f5','70848bb0-e31e-49cd-b8c3-73e61d8f988b','207747b1-10c6-4041-9870-79bfcec4cfae','ca41979d-2f05-4120-abfa-328ecd43d62e','463989bf-c68c-4f3d-a256-b6b65b85bfdd','f51d2586-80e8-428d-8b90-03675fba73b9','3eed6167-9a5a-43eb-a0d3-a3216e8a575b','881a28aa-37bd-44b1-a7d8-88615fab72b7','25435a60-90ad-4c9a-9936-47b12bbb33ed');