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

[
  "9432B27C-160C-4DD5-AF21-207BC0CA74C7"
  "8F661992-AE10-4ECB-A470-CED829CE5444"
  "D6F7D6E6-E311-4406-8959-A0A471C34F7B"
  "BFB5A235-0B49-4D59-880B-E8CF68FEB63A"
  "5D47AAB8-6FCF-4FA0-802A-EB440F577BA7"
  "3001CFA3-C759-4B24-A705-C6A2DB05FF6E"
  "64749EBB-7A8C-4734-AD84-6663DE7EB872"
  "9306335E-EAE4-417C-A581-6DC84A04F957"
  "471FE09F-2307-4364-86A5-A7FE65BD06FC"
  "31D60AB5-C555-4238-856E-A44F507F602F"
  "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 ('9432B27C-160C-4DD5-AF21-207BC0CA74C7', '8F661992-AE10-4ECB-A470-CED829CE5444', 'D6F7D6E6-E311-4406-8959-A0A471C34F7B', 'BFB5A235-0B49-4D59-880B-E8CF68FEB63A', '5D47AAB8-6FCF-4FA0-802A-EB440F577BA7', '3001CFA3-C759-4B24-A705-C6A2DB05FF6E', '64749EBB-7A8C-4734-AD84-6663DE7EB872', '9306335E-EAE4-417C-A581-6DC84A04F957', '471FE09F-2307-4364-86A5-A7FE65BD06FC', '31D60AB5-C555-4238-856E-A44F507F602F') 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

[
  "9432B27C-160C-4DD5-AF21-207BC0CA74C7"
  "8F661992-AE10-4ECB-A470-CED829CE5444"
  "D6F7D6E6-E311-4406-8959-A0A471C34F7B"
  "BFB5A235-0B49-4D59-880B-E8CF68FEB63A"
  "5D47AAB8-6FCF-4FA0-802A-EB440F577BA7"
  "3001CFA3-C759-4B24-A705-C6A2DB05FF6E"
  "64749EBB-7A8C-4734-AD84-6663DE7EB872"
  "9306335E-EAE4-417C-A581-6DC84A04F957"
  "471FE09F-2307-4364-86A5-A7FE65BD06FC"
  "31D60AB5-C555-4238-856E-A44F507F602F"
]

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 ('9432B27C-160C-4DD5-AF21-207BC0CA74C7', '8F661992-AE10-4ECB-A470-CED829CE5444', 'D6F7D6E6-E311-4406-8959-A0A471C34F7B', 'BFB5A235-0B49-4D59-880B-E8CF68FEB63A', '5D47AAB8-6FCF-4FA0-802A-EB440F577BA7', '3001CFA3-C759-4B24-A705-C6A2DB05FF6E', '64749EBB-7A8C-4734-AD84-6663DE7EB872', '9306335E-EAE4-417C-A581-6DC84A04F957', '471FE09F-2307-4364-86A5-A7FE65BD06FC', '31D60AB5-C555-4238-856E-A44F507F602F') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "9432b27c-160c-4dd5-af21-207bc0ca74c7"
  "8f661992-ae10-4ecb-a470-ced829ce5444"
  "d6f7d6e6-e311-4406-8959-a0a471c34f7b"
  "bfb5a235-0b49-4d59-880b-e8cf68feb63a"
  "5d47aab8-6fcf-4fa0-802a-eb440f577ba7"
  "3001cfa3-c759-4b24-a705-c6a2db05ff6e"
  "64749ebb-7a8c-4734-ad84-6663de7eb872"
  "9306335e-eae4-417c-a581-6dc84a04f957"
  "471fe09f-2307-4364-86a5-a7fe65bd06fc"
  "31d60ab5-c555-4238-856e-a44f507f602f"
]

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 ('9432b27c-160c-4dd5-af21-207bc0ca74c7','8f661992-ae10-4ecb-a470-ced829ce5444','d6f7d6e6-e311-4406-8959-a0a471c34f7b','bfb5a235-0b49-4d59-880b-e8cf68feb63a','5d47aab8-6fcf-4fa0-802a-eb440f577ba7','3001cfa3-c759-4b24-a705-c6a2db05ff6e','64749ebb-7a8c-4734-ad84-6663de7eb872','9306335e-eae4-417c-a581-6dc84a04f957','471fe09f-2307-4364-86a5-a7fe65bd06fc','31d60ab5-c555-4238-856e-a44f507f602f');