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

[
  "EAF774A2-13B4-4DBA-A6BE-13744A5FCC78"
  "20512227-AD53-4009-A7AA-CD0142218D8B"
  "6643B181-F525-4D6C-81B9-55F09C142BC9"
  "644537E3-55EF-4141-88CD-331B6FB02B52"
  "D759BDBC-BE7A-4508-A36F-1F76C17DD23F"
  "E0855685-01A5-49C2-8548-CB937BBE3F51"
  "0F93618B-9ADE-4C62-A21F-646B9A84F0D9"
  "7BFA8EB8-EDCA-427D-956C-516F5F86F7F0"
  "AB276870-F442-4746-B4A6-0D0B1C7FACBE"
  "F76DB7D8-18B4-4C9D-98D0-34BE40667F89"
  "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 ('EAF774A2-13B4-4DBA-A6BE-13744A5FCC78', '20512227-AD53-4009-A7AA-CD0142218D8B', '6643B181-F525-4D6C-81B9-55F09C142BC9', '644537E3-55EF-4141-88CD-331B6FB02B52', 'D759BDBC-BE7A-4508-A36F-1F76C17DD23F', 'E0855685-01A5-49C2-8548-CB937BBE3F51', '0F93618B-9ADE-4C62-A21F-646B9A84F0D9', '7BFA8EB8-EDCA-427D-956C-516F5F86F7F0', 'AB276870-F442-4746-B4A6-0D0B1C7FACBE', 'F76DB7D8-18B4-4C9D-98D0-34BE40667F89') 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

[
  "EAF774A2-13B4-4DBA-A6BE-13744A5FCC78"
  "20512227-AD53-4009-A7AA-CD0142218D8B"
  "6643B181-F525-4D6C-81B9-55F09C142BC9"
  "644537E3-55EF-4141-88CD-331B6FB02B52"
  "D759BDBC-BE7A-4508-A36F-1F76C17DD23F"
  "E0855685-01A5-49C2-8548-CB937BBE3F51"
  "0F93618B-9ADE-4C62-A21F-646B9A84F0D9"
  "7BFA8EB8-EDCA-427D-956C-516F5F86F7F0"
  "AB276870-F442-4746-B4A6-0D0B1C7FACBE"
  "F76DB7D8-18B4-4C9D-98D0-34BE40667F89"
]

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 ('EAF774A2-13B4-4DBA-A6BE-13744A5FCC78', '20512227-AD53-4009-A7AA-CD0142218D8B', '6643B181-F525-4D6C-81B9-55F09C142BC9', '644537E3-55EF-4141-88CD-331B6FB02B52', 'D759BDBC-BE7A-4508-A36F-1F76C17DD23F', 'E0855685-01A5-49C2-8548-CB937BBE3F51', '0F93618B-9ADE-4C62-A21F-646B9A84F0D9', '7BFA8EB8-EDCA-427D-956C-516F5F86F7F0', 'AB276870-F442-4746-B4A6-0D0B1C7FACBE', 'F76DB7D8-18B4-4C9D-98D0-34BE40667F89') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "eaf774a2-13b4-4dba-a6be-13744a5fcc78"
  "20512227-ad53-4009-a7aa-cd0142218d8b"
  "6643b181-f525-4d6c-81b9-55f09c142bc9"
  "644537e3-55ef-4141-88cd-331b6fb02b52"
  "d759bdbc-be7a-4508-a36f-1f76c17dd23f"
  "e0855685-01a5-49c2-8548-cb937bbe3f51"
  "0f93618b-9ade-4c62-a21f-646b9a84f0d9"
  "7bfa8eb8-edca-427d-956c-516f5f86f7f0"
  "ab276870-f442-4746-b4a6-0d0b1c7facbe"
  "f76db7d8-18b4-4c9d-98d0-34be40667f89"
]

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 ('eaf774a2-13b4-4dba-a6be-13744a5fcc78','20512227-ad53-4009-a7aa-cd0142218d8b','6643b181-f525-4d6c-81b9-55f09c142bc9','644537e3-55ef-4141-88cd-331b6fb02b52','d759bdbc-be7a-4508-a36f-1f76c17dd23f','e0855685-01a5-49c2-8548-cb937bbe3f51','0f93618b-9ade-4c62-a21f-646b9a84f0d9','7bfa8eb8-edca-427d-956c-516f5f86f7f0','ab276870-f442-4746-b4a6-0d0b1c7facbe','f76db7d8-18b4-4c9d-98d0-34be40667f89');