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

[
  "B6AA19A2-E8D4-4275-B924-F8F5BA470FA3"
  "CA071A29-B803-4DA1-B8F6-7BAAEA412AC7"
  "A5568BAF-CABC-4E56-9EEA-E58C83C21ACA"
  "F83D7246-0883-4217-86EB-29DD422B7D80"
  "64DA881B-F009-49D3-82F9-78997F1D4362"
  "7CB9A56B-A425-4167-9336-8690B667A6C3"
  "A82EA756-00A2-4B98-A757-C75AA5A3B813"
  "E7F72E65-F5C9-4CF0-B67F-4661B3092A4A"
  "263705F5-A03C-4261-B5B1-E08B52D5CD93"
  "D5C69D92-6A76-4888-9BFA-9B2704FE90D0"
  "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 ('B6AA19A2-E8D4-4275-B924-F8F5BA470FA3', 'CA071A29-B803-4DA1-B8F6-7BAAEA412AC7', 'A5568BAF-CABC-4E56-9EEA-E58C83C21ACA', 'F83D7246-0883-4217-86EB-29DD422B7D80', '64DA881B-F009-49D3-82F9-78997F1D4362', '7CB9A56B-A425-4167-9336-8690B667A6C3', 'A82EA756-00A2-4B98-A757-C75AA5A3B813', 'E7F72E65-F5C9-4CF0-B67F-4661B3092A4A', '263705F5-A03C-4261-B5B1-E08B52D5CD93', 'D5C69D92-6A76-4888-9BFA-9B2704FE90D0') 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

[
  "B6AA19A2-E8D4-4275-B924-F8F5BA470FA3"
  "CA071A29-B803-4DA1-B8F6-7BAAEA412AC7"
  "A5568BAF-CABC-4E56-9EEA-E58C83C21ACA"
  "F83D7246-0883-4217-86EB-29DD422B7D80"
  "64DA881B-F009-49D3-82F9-78997F1D4362"
  "7CB9A56B-A425-4167-9336-8690B667A6C3"
  "A82EA756-00A2-4B98-A757-C75AA5A3B813"
  "E7F72E65-F5C9-4CF0-B67F-4661B3092A4A"
  "263705F5-A03C-4261-B5B1-E08B52D5CD93"
  "D5C69D92-6A76-4888-9BFA-9B2704FE90D0"
]

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 ('B6AA19A2-E8D4-4275-B924-F8F5BA470FA3', 'CA071A29-B803-4DA1-B8F6-7BAAEA412AC7', 'A5568BAF-CABC-4E56-9EEA-E58C83C21ACA', 'F83D7246-0883-4217-86EB-29DD422B7D80', '64DA881B-F009-49D3-82F9-78997F1D4362', '7CB9A56B-A425-4167-9336-8690B667A6C3', 'A82EA756-00A2-4B98-A757-C75AA5A3B813', 'E7F72E65-F5C9-4CF0-B67F-4661B3092A4A', '263705F5-A03C-4261-B5B1-E08B52D5CD93', 'D5C69D92-6A76-4888-9BFA-9B2704FE90D0') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "b6aa19a2-e8d4-4275-b924-f8f5ba470fa3"
  "ca071a29-b803-4da1-b8f6-7baaea412ac7"
  "a5568baf-cabc-4e56-9eea-e58c83c21aca"
  "f83d7246-0883-4217-86eb-29dd422b7d80"
  "64da881b-f009-49d3-82f9-78997f1d4362"
  "7cb9a56b-a425-4167-9336-8690b667a6c3"
  "a82ea756-00a2-4b98-a757-c75aa5a3b813"
  "e7f72e65-f5c9-4cf0-b67f-4661b3092a4a"
  "263705f5-a03c-4261-b5b1-e08b52d5cd93"
  "d5c69d92-6a76-4888-9bfa-9b2704fe90d0"
]

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 ('b6aa19a2-e8d4-4275-b924-f8f5ba470fa3','ca071a29-b803-4da1-b8f6-7baaea412ac7','a5568baf-cabc-4e56-9eea-e58c83c21aca','f83d7246-0883-4217-86eb-29dd422b7d80','64da881b-f009-49d3-82f9-78997f1d4362','7cb9a56b-a425-4167-9336-8690b667a6c3','a82ea756-00a2-4b98-a757-c75aa5a3b813','e7f72e65-f5c9-4cf0-b67f-4661b3092a4a','263705f5-a03c-4261-b5b1-e08b52d5cd93','d5c69d92-6a76-4888-9bfa-9b2704fe90d0');