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

[
  "93600C35-69F2-43BF-A7ED-14EF799D82C8"
  "DE73B1E5-2931-41BC-82D3-220F20E1D2FF"
  "FA4320E2-D6B9-43EF-AF6D-169085543227"
  "B3FA45BE-4C67-42D5-AF4F-8B7DC7E719F0"
  "EEBAFA2E-3A2B-45CA-942C-BE6FB0974609"
  "36EF59DD-4254-4317-BB3B-2A68F91810EB"
  "A2D86FDD-DE46-468A-9B3F-6F147CB5C87C"
  "926EC3B9-80EE-44D5-B4FD-8D6692D9A040"
  "17CA5CFB-A7CE-45AE-94BB-1B98AF6B3524"
  "A8ADF984-01E2-409C-9175-18FD68EE6788"
  "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 ('93600C35-69F2-43BF-A7ED-14EF799D82C8', 'DE73B1E5-2931-41BC-82D3-220F20E1D2FF', 'FA4320E2-D6B9-43EF-AF6D-169085543227', 'B3FA45BE-4C67-42D5-AF4F-8B7DC7E719F0', 'EEBAFA2E-3A2B-45CA-942C-BE6FB0974609', '36EF59DD-4254-4317-BB3B-2A68F91810EB', 'A2D86FDD-DE46-468A-9B3F-6F147CB5C87C', '926EC3B9-80EE-44D5-B4FD-8D6692D9A040', '17CA5CFB-A7CE-45AE-94BB-1B98AF6B3524', 'A8ADF984-01E2-409C-9175-18FD68EE6788') 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

[
  "93600C35-69F2-43BF-A7ED-14EF799D82C8"
  "DE73B1E5-2931-41BC-82D3-220F20E1D2FF"
  "FA4320E2-D6B9-43EF-AF6D-169085543227"
  "B3FA45BE-4C67-42D5-AF4F-8B7DC7E719F0"
  "EEBAFA2E-3A2B-45CA-942C-BE6FB0974609"
  "36EF59DD-4254-4317-BB3B-2A68F91810EB"
  "A2D86FDD-DE46-468A-9B3F-6F147CB5C87C"
  "926EC3B9-80EE-44D5-B4FD-8D6692D9A040"
  "17CA5CFB-A7CE-45AE-94BB-1B98AF6B3524"
  "A8ADF984-01E2-409C-9175-18FD68EE6788"
]

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 ('93600C35-69F2-43BF-A7ED-14EF799D82C8', 'DE73B1E5-2931-41BC-82D3-220F20E1D2FF', 'FA4320E2-D6B9-43EF-AF6D-169085543227', 'B3FA45BE-4C67-42D5-AF4F-8B7DC7E719F0', 'EEBAFA2E-3A2B-45CA-942C-BE6FB0974609', '36EF59DD-4254-4317-BB3B-2A68F91810EB', 'A2D86FDD-DE46-468A-9B3F-6F147CB5C87C', '926EC3B9-80EE-44D5-B4FD-8D6692D9A040', '17CA5CFB-A7CE-45AE-94BB-1B98AF6B3524', 'A8ADF984-01E2-409C-9175-18FD68EE6788') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "93600c35-69f2-43bf-a7ed-14ef799d82c8"
  "de73b1e5-2931-41bc-82d3-220f20e1d2ff"
  "fa4320e2-d6b9-43ef-af6d-169085543227"
  "b3fa45be-4c67-42d5-af4f-8b7dc7e719f0"
  "eebafa2e-3a2b-45ca-942c-be6fb0974609"
  "36ef59dd-4254-4317-bb3b-2a68f91810eb"
  "a2d86fdd-de46-468a-9b3f-6f147cb5c87c"
  "926ec3b9-80ee-44d5-b4fd-8d6692d9a040"
  "17ca5cfb-a7ce-45ae-94bb-1b98af6b3524"
  "a8adf984-01e2-409c-9175-18fd68ee6788"
]

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 ('93600c35-69f2-43bf-a7ed-14ef799d82c8','de73b1e5-2931-41bc-82d3-220f20e1d2ff','fa4320e2-d6b9-43ef-af6d-169085543227','b3fa45be-4c67-42d5-af4f-8b7dc7e719f0','eebafa2e-3a2b-45ca-942c-be6fb0974609','36ef59dd-4254-4317-bb3b-2a68f91810eb','a2d86fdd-de46-468a-9b3f-6f147cb5c87c','926ec3b9-80ee-44d5-b4fd-8d6692d9a040','17ca5cfb-a7ce-45ae-94bb-1b98af6b3524','a8adf984-01e2-409c-9175-18fd68ee6788');