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

[
  "38E47084-8487-4310-92A7-7A0B0E8E948B"
  "5D0159AE-2B07-47A3-8C0F-C70E2A2143EE"
  "45B9E352-ACD9-45C3-A4FC-B923DBF7F82E"
  "4E659DA2-7C1F-4528-B704-F0B6B7D19C45"
  "09407C11-CDC0-40E6-8007-D5F49CE76A30"
  "791C85B1-5736-4DE9-A974-AEFC66DE3693"
  "35BA48EB-774A-431B-99C3-06278A273269"
  "1ED2A527-F9C4-4C16-82CD-A1105998EFD3"
  "66E8A77C-1F85-4010-9AC6-9B82D4785726"
  "34B29E8E-3F97-4667-9156-A3856023C87A"
  "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 ('38E47084-8487-4310-92A7-7A0B0E8E948B', '5D0159AE-2B07-47A3-8C0F-C70E2A2143EE', '45B9E352-ACD9-45C3-A4FC-B923DBF7F82E', '4E659DA2-7C1F-4528-B704-F0B6B7D19C45', '09407C11-CDC0-40E6-8007-D5F49CE76A30', '791C85B1-5736-4DE9-A974-AEFC66DE3693', '35BA48EB-774A-431B-99C3-06278A273269', '1ED2A527-F9C4-4C16-82CD-A1105998EFD3', '66E8A77C-1F85-4010-9AC6-9B82D4785726', '34B29E8E-3F97-4667-9156-A3856023C87A') 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

[
  "38E47084-8487-4310-92A7-7A0B0E8E948B"
  "5D0159AE-2B07-47A3-8C0F-C70E2A2143EE"
  "45B9E352-ACD9-45C3-A4FC-B923DBF7F82E"
  "4E659DA2-7C1F-4528-B704-F0B6B7D19C45"
  "09407C11-CDC0-40E6-8007-D5F49CE76A30"
  "791C85B1-5736-4DE9-A974-AEFC66DE3693"
  "35BA48EB-774A-431B-99C3-06278A273269"
  "1ED2A527-F9C4-4C16-82CD-A1105998EFD3"
  "66E8A77C-1F85-4010-9AC6-9B82D4785726"
  "34B29E8E-3F97-4667-9156-A3856023C87A"
]

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 ('38E47084-8487-4310-92A7-7A0B0E8E948B', '5D0159AE-2B07-47A3-8C0F-C70E2A2143EE', '45B9E352-ACD9-45C3-A4FC-B923DBF7F82E', '4E659DA2-7C1F-4528-B704-F0B6B7D19C45', '09407C11-CDC0-40E6-8007-D5F49CE76A30', '791C85B1-5736-4DE9-A974-AEFC66DE3693', '35BA48EB-774A-431B-99C3-06278A273269', '1ED2A527-F9C4-4C16-82CD-A1105998EFD3', '66E8A77C-1F85-4010-9AC6-9B82D4785726', '34B29E8E-3F97-4667-9156-A3856023C87A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "38e47084-8487-4310-92a7-7a0b0e8e948b"
  "5d0159ae-2b07-47a3-8c0f-c70e2a2143ee"
  "45b9e352-acd9-45c3-a4fc-b923dbf7f82e"
  "4e659da2-7c1f-4528-b704-f0b6b7d19c45"
  "09407c11-cdc0-40e6-8007-d5f49ce76a30"
  "791c85b1-5736-4de9-a974-aefc66de3693"
  "35ba48eb-774a-431b-99c3-06278a273269"
  "1ed2a527-f9c4-4c16-82cd-a1105998efd3"
  "66e8a77c-1f85-4010-9ac6-9b82d4785726"
  "34b29e8e-3f97-4667-9156-a3856023c87a"
]

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 ('38e47084-8487-4310-92a7-7a0b0e8e948b','5d0159ae-2b07-47a3-8c0f-c70e2a2143ee','45b9e352-acd9-45c3-a4fc-b923dbf7f82e','4e659da2-7c1f-4528-b704-f0b6b7d19c45','09407c11-cdc0-40e6-8007-d5f49ce76a30','791c85b1-5736-4de9-a974-aefc66de3693','35ba48eb-774a-431b-99c3-06278a273269','1ed2a527-f9c4-4c16-82cd-a1105998efd3','66e8a77c-1f85-4010-9ac6-9b82d4785726','34b29e8e-3f97-4667-9156-a3856023c87a');