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

[
  "3703FFD6-D16D-4B9F-9A22-DAE9B41DCAD5"
  "F0783EEB-83C1-497E-BEDB-3EDA4BF5401B"
  "F44FE395-8288-44F4-9359-29AE8901ADDF"
  "91D522A5-FF79-4276-88F7-5185D6E54B82"
  "00F68AD7-2637-4E53-B98A-0F7119CBB6AF"
  "F2BEF3E1-224D-49A0-AD2F-91400DE97FB9"
  "9F022456-429B-4E2F-9C7F-A42F77650603"
  "89E6E28C-0C07-4FC5-8211-698F8DB5A2D2"
  "AC8F789A-F7F5-4213-8AD9-EF455DDD694F"
  "C59AB91D-34B1-453F-B6E9-FCB6CF2D0FC9"
  "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 ('3703FFD6-D16D-4B9F-9A22-DAE9B41DCAD5', 'F0783EEB-83C1-497E-BEDB-3EDA4BF5401B', 'F44FE395-8288-44F4-9359-29AE8901ADDF', '91D522A5-FF79-4276-88F7-5185D6E54B82', '00F68AD7-2637-4E53-B98A-0F7119CBB6AF', 'F2BEF3E1-224D-49A0-AD2F-91400DE97FB9', '9F022456-429B-4E2F-9C7F-A42F77650603', '89E6E28C-0C07-4FC5-8211-698F8DB5A2D2', 'AC8F789A-F7F5-4213-8AD9-EF455DDD694F', 'C59AB91D-34B1-453F-B6E9-FCB6CF2D0FC9') 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

[
  "3703FFD6-D16D-4B9F-9A22-DAE9B41DCAD5"
  "F0783EEB-83C1-497E-BEDB-3EDA4BF5401B"
  "F44FE395-8288-44F4-9359-29AE8901ADDF"
  "91D522A5-FF79-4276-88F7-5185D6E54B82"
  "00F68AD7-2637-4E53-B98A-0F7119CBB6AF"
  "F2BEF3E1-224D-49A0-AD2F-91400DE97FB9"
  "9F022456-429B-4E2F-9C7F-A42F77650603"
  "89E6E28C-0C07-4FC5-8211-698F8DB5A2D2"
  "AC8F789A-F7F5-4213-8AD9-EF455DDD694F"
  "C59AB91D-34B1-453F-B6E9-FCB6CF2D0FC9"
]

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 ('3703FFD6-D16D-4B9F-9A22-DAE9B41DCAD5', 'F0783EEB-83C1-497E-BEDB-3EDA4BF5401B', 'F44FE395-8288-44F4-9359-29AE8901ADDF', '91D522A5-FF79-4276-88F7-5185D6E54B82', '00F68AD7-2637-4E53-B98A-0F7119CBB6AF', 'F2BEF3E1-224D-49A0-AD2F-91400DE97FB9', '9F022456-429B-4E2F-9C7F-A42F77650603', '89E6E28C-0C07-4FC5-8211-698F8DB5A2D2', 'AC8F789A-F7F5-4213-8AD9-EF455DDD694F', 'C59AB91D-34B1-453F-B6E9-FCB6CF2D0FC9') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "3703ffd6-d16d-4b9f-9a22-dae9b41dcad5"
  "f0783eeb-83c1-497e-bedb-3eda4bf5401b"
  "f44fe395-8288-44f4-9359-29ae8901addf"
  "91d522a5-ff79-4276-88f7-5185d6e54b82"
  "00f68ad7-2637-4e53-b98a-0f7119cbb6af"
  "f2bef3e1-224d-49a0-ad2f-91400de97fb9"
  "9f022456-429b-4e2f-9c7f-a42f77650603"
  "89e6e28c-0c07-4fc5-8211-698f8db5a2d2"
  "ac8f789a-f7f5-4213-8ad9-ef455ddd694f"
  "c59ab91d-34b1-453f-b6e9-fcb6cf2d0fc9"
]

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 ('3703ffd6-d16d-4b9f-9a22-dae9b41dcad5','f0783eeb-83c1-497e-bedb-3eda4bf5401b','f44fe395-8288-44f4-9359-29ae8901addf','91d522a5-ff79-4276-88f7-5185d6e54b82','00f68ad7-2637-4e53-b98a-0f7119cbb6af','f2bef3e1-224d-49a0-ad2f-91400de97fb9','9f022456-429b-4e2f-9c7f-a42f77650603','89e6e28c-0c07-4fc5-8211-698f8db5a2d2','ac8f789a-f7f5-4213-8ad9-ef455ddd694f','c59ab91d-34b1-453f-b6e9-fcb6cf2d0fc9');