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

[
  "78C2C926-AB7E-4A1B-A2C0-55E58F7E9F7D"
  "33943A1E-F90B-4E55-80DA-4B9212AFEAD5"
  "CCC4B48F-D18C-43C5-9843-6FE1CC2DAAB7"
  "B8D5DD8C-EBD0-4A95-A98F-F18BBD886B35"
  "442C7672-E5E5-447A-A5D7-0B93C1750587"
  "4BC3388D-04BF-4150-A278-D9B8D5177948"
  "9C783D58-5D71-4B7B-A622-D056A3F1545F"
  "33532A68-2C85-424D-924F-A8A025F1BE69"
  "A2DBD22B-C71E-4775-935F-E811463253C8"
  "DF30DA26-FB68-4D36-9245-7AC57ACD5E3F"
  "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 ('78C2C926-AB7E-4A1B-A2C0-55E58F7E9F7D', '33943A1E-F90B-4E55-80DA-4B9212AFEAD5', 'CCC4B48F-D18C-43C5-9843-6FE1CC2DAAB7', 'B8D5DD8C-EBD0-4A95-A98F-F18BBD886B35', '442C7672-E5E5-447A-A5D7-0B93C1750587', '4BC3388D-04BF-4150-A278-D9B8D5177948', '9C783D58-5D71-4B7B-A622-D056A3F1545F', '33532A68-2C85-424D-924F-A8A025F1BE69', 'A2DBD22B-C71E-4775-935F-E811463253C8', 'DF30DA26-FB68-4D36-9245-7AC57ACD5E3F') 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

[
  "78C2C926-AB7E-4A1B-A2C0-55E58F7E9F7D"
  "33943A1E-F90B-4E55-80DA-4B9212AFEAD5"
  "CCC4B48F-D18C-43C5-9843-6FE1CC2DAAB7"
  "B8D5DD8C-EBD0-4A95-A98F-F18BBD886B35"
  "442C7672-E5E5-447A-A5D7-0B93C1750587"
  "4BC3388D-04BF-4150-A278-D9B8D5177948"
  "9C783D58-5D71-4B7B-A622-D056A3F1545F"
  "33532A68-2C85-424D-924F-A8A025F1BE69"
  "A2DBD22B-C71E-4775-935F-E811463253C8"
  "DF30DA26-FB68-4D36-9245-7AC57ACD5E3F"
]

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 ('78C2C926-AB7E-4A1B-A2C0-55E58F7E9F7D', '33943A1E-F90B-4E55-80DA-4B9212AFEAD5', 'CCC4B48F-D18C-43C5-9843-6FE1CC2DAAB7', 'B8D5DD8C-EBD0-4A95-A98F-F18BBD886B35', '442C7672-E5E5-447A-A5D7-0B93C1750587', '4BC3388D-04BF-4150-A278-D9B8D5177948', '9C783D58-5D71-4B7B-A622-D056A3F1545F', '33532A68-2C85-424D-924F-A8A025F1BE69', 'A2DBD22B-C71E-4775-935F-E811463253C8', 'DF30DA26-FB68-4D36-9245-7AC57ACD5E3F') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "78c2c926-ab7e-4a1b-a2c0-55e58f7e9f7d"
  "33943a1e-f90b-4e55-80da-4b9212afead5"
  "ccc4b48f-d18c-43c5-9843-6fe1cc2daab7"
  "b8d5dd8c-ebd0-4a95-a98f-f18bbd886b35"
  "442c7672-e5e5-447a-a5d7-0b93c1750587"
  "4bc3388d-04bf-4150-a278-d9b8d5177948"
  "9c783d58-5d71-4b7b-a622-d056a3f1545f"
  "33532a68-2c85-424d-924f-a8a025f1be69"
  "a2dbd22b-c71e-4775-935f-e811463253c8"
  "df30da26-fb68-4d36-9245-7ac57acd5e3f"
]

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 ('78c2c926-ab7e-4a1b-a2c0-55e58f7e9f7d','33943a1e-f90b-4e55-80da-4b9212afead5','ccc4b48f-d18c-43c5-9843-6fe1cc2daab7','b8d5dd8c-ebd0-4a95-a98f-f18bbd886b35','442c7672-e5e5-447a-a5d7-0b93c1750587','4bc3388d-04bf-4150-a278-d9b8d5177948','9c783d58-5d71-4b7b-a622-d056a3f1545f','33532a68-2c85-424d-924f-a8a025f1be69','a2dbd22b-c71e-4775-935f-e811463253c8','df30da26-fb68-4d36-9245-7ac57acd5e3f');