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

[
  "5867DCE0-FEDC-4606-9FEE-0EAC7947F76F"
  "A2CC217D-C400-450E-B390-85303B2E277A"
  "73E9793E-0D48-46FA-B656-C7178D30FABA"
  "A0914289-8E1A-41A3-84E9-59947D0CCF66"
  "252470E7-E2E3-4762-A611-6DC86646F9BD"
  "4C9221C2-A16C-4AAB-9CD4-B5C99C779EF2"
  "B4B5638F-448B-411E-9722-8D4A072469F2"
  "87B09683-0D3E-4A0B-91C5-BD1A8A329D08"
  "0F51F852-3E5E-40B3-A5D4-0A5388A1EA71"
  "60E78CE8-133A-42DC-B496-9662F446E354"
  "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 ('5867DCE0-FEDC-4606-9FEE-0EAC7947F76F', 'A2CC217D-C400-450E-B390-85303B2E277A', '73E9793E-0D48-46FA-B656-C7178D30FABA', 'A0914289-8E1A-41A3-84E9-59947D0CCF66', '252470E7-E2E3-4762-A611-6DC86646F9BD', '4C9221C2-A16C-4AAB-9CD4-B5C99C779EF2', 'B4B5638F-448B-411E-9722-8D4A072469F2', '87B09683-0D3E-4A0B-91C5-BD1A8A329D08', '0F51F852-3E5E-40B3-A5D4-0A5388A1EA71', '60E78CE8-133A-42DC-B496-9662F446E354') 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

[
  "5867DCE0-FEDC-4606-9FEE-0EAC7947F76F"
  "A2CC217D-C400-450E-B390-85303B2E277A"
  "73E9793E-0D48-46FA-B656-C7178D30FABA"
  "A0914289-8E1A-41A3-84E9-59947D0CCF66"
  "252470E7-E2E3-4762-A611-6DC86646F9BD"
  "4C9221C2-A16C-4AAB-9CD4-B5C99C779EF2"
  "B4B5638F-448B-411E-9722-8D4A072469F2"
  "87B09683-0D3E-4A0B-91C5-BD1A8A329D08"
  "0F51F852-3E5E-40B3-A5D4-0A5388A1EA71"
  "60E78CE8-133A-42DC-B496-9662F446E354"
]

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 ('5867DCE0-FEDC-4606-9FEE-0EAC7947F76F', 'A2CC217D-C400-450E-B390-85303B2E277A', '73E9793E-0D48-46FA-B656-C7178D30FABA', 'A0914289-8E1A-41A3-84E9-59947D0CCF66', '252470E7-E2E3-4762-A611-6DC86646F9BD', '4C9221C2-A16C-4AAB-9CD4-B5C99C779EF2', 'B4B5638F-448B-411E-9722-8D4A072469F2', '87B09683-0D3E-4A0B-91C5-BD1A8A329D08', '0F51F852-3E5E-40B3-A5D4-0A5388A1EA71', '60E78CE8-133A-42DC-B496-9662F446E354') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "5867dce0-fedc-4606-9fee-0eac7947f76f"
  "a2cc217d-c400-450e-b390-85303b2e277a"
  "73e9793e-0d48-46fa-b656-c7178d30faba"
  "a0914289-8e1a-41a3-84e9-59947d0ccf66"
  "252470e7-e2e3-4762-a611-6dc86646f9bd"
  "4c9221c2-a16c-4aab-9cd4-b5c99c779ef2"
  "b4b5638f-448b-411e-9722-8d4a072469f2"
  "87b09683-0d3e-4a0b-91c5-bd1a8a329d08"
  "0f51f852-3e5e-40b3-a5d4-0a5388a1ea71"
  "60e78ce8-133a-42dc-b496-9662f446e354"
]

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 ('5867dce0-fedc-4606-9fee-0eac7947f76f','a2cc217d-c400-450e-b390-85303b2e277a','73e9793e-0d48-46fa-b656-c7178d30faba','a0914289-8e1a-41a3-84e9-59947d0ccf66','252470e7-e2e3-4762-a611-6dc86646f9bd','4c9221c2-a16c-4aab-9cd4-b5c99c779ef2','b4b5638f-448b-411e-9722-8d4a072469f2','87b09683-0d3e-4a0b-91c5-bd1a8a329d08','0f51f852-3e5e-40b3-a5d4-0a5388a1ea71','60e78ce8-133a-42dc-b496-9662f446e354');