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

[
  "BFBA0B19-0F4A-454B-B2F2-B581F03AA125"
  "81D3C4DF-803B-4326-BFC9-BFF9F26659FD"
  "1868AE9A-5214-487E-9E0F-330AAF9ED33A"
  "FE7692F7-31E7-4088-B871-9B30EDD94FC3"
  "9CF531AB-3B10-4A57-A8A3-1AB8D8C85BE9"
  "4E57B6C3-D468-457D-96CA-273A156D4C6D"
  "717913DF-98EC-4C3A-B271-3828DF32C639"
  "BF06A0F4-9E9C-46A7-A12D-E76F47B26742"
  "50614830-AAB1-45CF-8CF9-A24324B5FD7D"
  "9183ED93-81D7-45E6-BFF5-9A6957128D1A"
  "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 ('BFBA0B19-0F4A-454B-B2F2-B581F03AA125', '81D3C4DF-803B-4326-BFC9-BFF9F26659FD', '1868AE9A-5214-487E-9E0F-330AAF9ED33A', 'FE7692F7-31E7-4088-B871-9B30EDD94FC3', '9CF531AB-3B10-4A57-A8A3-1AB8D8C85BE9', '4E57B6C3-D468-457D-96CA-273A156D4C6D', '717913DF-98EC-4C3A-B271-3828DF32C639', 'BF06A0F4-9E9C-46A7-A12D-E76F47B26742', '50614830-AAB1-45CF-8CF9-A24324B5FD7D', '9183ED93-81D7-45E6-BFF5-9A6957128D1A') 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

[
  "BFBA0B19-0F4A-454B-B2F2-B581F03AA125"
  "81D3C4DF-803B-4326-BFC9-BFF9F26659FD"
  "1868AE9A-5214-487E-9E0F-330AAF9ED33A"
  "FE7692F7-31E7-4088-B871-9B30EDD94FC3"
  "9CF531AB-3B10-4A57-A8A3-1AB8D8C85BE9"
  "4E57B6C3-D468-457D-96CA-273A156D4C6D"
  "717913DF-98EC-4C3A-B271-3828DF32C639"
  "BF06A0F4-9E9C-46A7-A12D-E76F47B26742"
  "50614830-AAB1-45CF-8CF9-A24324B5FD7D"
  "9183ED93-81D7-45E6-BFF5-9A6957128D1A"
]

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 ('BFBA0B19-0F4A-454B-B2F2-B581F03AA125', '81D3C4DF-803B-4326-BFC9-BFF9F26659FD', '1868AE9A-5214-487E-9E0F-330AAF9ED33A', 'FE7692F7-31E7-4088-B871-9B30EDD94FC3', '9CF531AB-3B10-4A57-A8A3-1AB8D8C85BE9', '4E57B6C3-D468-457D-96CA-273A156D4C6D', '717913DF-98EC-4C3A-B271-3828DF32C639', 'BF06A0F4-9E9C-46A7-A12D-E76F47B26742', '50614830-AAB1-45CF-8CF9-A24324B5FD7D', '9183ED93-81D7-45E6-BFF5-9A6957128D1A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "bfba0b19-0f4a-454b-b2f2-b581f03aa125"
  "81d3c4df-803b-4326-bfc9-bff9f26659fd"
  "1868ae9a-5214-487e-9e0f-330aaf9ed33a"
  "fe7692f7-31e7-4088-b871-9b30edd94fc3"
  "9cf531ab-3b10-4a57-a8a3-1ab8d8c85be9"
  "4e57b6c3-d468-457d-96ca-273a156d4c6d"
  "717913df-98ec-4c3a-b271-3828df32c639"
  "bf06a0f4-9e9c-46a7-a12d-e76f47b26742"
  "50614830-aab1-45cf-8cf9-a24324b5fd7d"
  "9183ed93-81d7-45e6-bff5-9a6957128d1a"
]

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 ('bfba0b19-0f4a-454b-b2f2-b581f03aa125','81d3c4df-803b-4326-bfc9-bff9f26659fd','1868ae9a-5214-487e-9e0f-330aaf9ed33a','fe7692f7-31e7-4088-b871-9b30edd94fc3','9cf531ab-3b10-4a57-a8a3-1ab8d8c85be9','4e57b6c3-d468-457d-96ca-273a156d4c6d','717913df-98ec-4c3a-b271-3828df32c639','bf06a0f4-9e9c-46a7-a12d-e76f47b26742','50614830-aab1-45cf-8cf9-a24324b5fd7d','9183ed93-81d7-45e6-bff5-9a6957128d1a');