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

[
  "0CD07F53-82B2-4B0F-AFA3-844BBFDCB6D8"
  "AA88506D-8926-40A0-AAC9-C12D0836724A"
  "BBAB9390-FFBF-429D-BA0E-DB0A643FE959"
  "648096BE-FB41-4D08-A26B-B35F95D6DFAF"
  "50920F3B-78DD-4108-B9BC-EE0578B240FF"
  "DB41B799-9C80-4AF3-BCA7-0D4EDE2737EF"
  "3366C128-1C7B-40F7-906D-C658BDFEEC02"
  "72A4849F-2D31-4261-A82D-7C06A0B3AFC0"
  "9B2A8470-8D0F-474F-8F5F-24A24742781C"
  "56821CA5-42B5-4672-BC64-F94C97C60EB4"
  "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 ('0CD07F53-82B2-4B0F-AFA3-844BBFDCB6D8', 'AA88506D-8926-40A0-AAC9-C12D0836724A', 'BBAB9390-FFBF-429D-BA0E-DB0A643FE959', '648096BE-FB41-4D08-A26B-B35F95D6DFAF', '50920F3B-78DD-4108-B9BC-EE0578B240FF', 'DB41B799-9C80-4AF3-BCA7-0D4EDE2737EF', '3366C128-1C7B-40F7-906D-C658BDFEEC02', '72A4849F-2D31-4261-A82D-7C06A0B3AFC0', '9B2A8470-8D0F-474F-8F5F-24A24742781C', '56821CA5-42B5-4672-BC64-F94C97C60EB4') 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

[
  "0CD07F53-82B2-4B0F-AFA3-844BBFDCB6D8"
  "AA88506D-8926-40A0-AAC9-C12D0836724A"
  "BBAB9390-FFBF-429D-BA0E-DB0A643FE959"
  "648096BE-FB41-4D08-A26B-B35F95D6DFAF"
  "50920F3B-78DD-4108-B9BC-EE0578B240FF"
  "DB41B799-9C80-4AF3-BCA7-0D4EDE2737EF"
  "3366C128-1C7B-40F7-906D-C658BDFEEC02"
  "72A4849F-2D31-4261-A82D-7C06A0B3AFC0"
  "9B2A8470-8D0F-474F-8F5F-24A24742781C"
  "56821CA5-42B5-4672-BC64-F94C97C60EB4"
]

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 ('0CD07F53-82B2-4B0F-AFA3-844BBFDCB6D8', 'AA88506D-8926-40A0-AAC9-C12D0836724A', 'BBAB9390-FFBF-429D-BA0E-DB0A643FE959', '648096BE-FB41-4D08-A26B-B35F95D6DFAF', '50920F3B-78DD-4108-B9BC-EE0578B240FF', 'DB41B799-9C80-4AF3-BCA7-0D4EDE2737EF', '3366C128-1C7B-40F7-906D-C658BDFEEC02', '72A4849F-2D31-4261-A82D-7C06A0B3AFC0', '9B2A8470-8D0F-474F-8F5F-24A24742781C', '56821CA5-42B5-4672-BC64-F94C97C60EB4') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "0cd07f53-82b2-4b0f-afa3-844bbfdcb6d8"
  "aa88506d-8926-40a0-aac9-c12d0836724a"
  "bbab9390-ffbf-429d-ba0e-db0a643fe959"
  "648096be-fb41-4d08-a26b-b35f95d6dfaf"
  "50920f3b-78dd-4108-b9bc-ee0578b240ff"
  "db41b799-9c80-4af3-bca7-0d4ede2737ef"
  "3366c128-1c7b-40f7-906d-c658bdfeec02"
  "72a4849f-2d31-4261-a82d-7c06a0b3afc0"
  "9b2a8470-8d0f-474f-8f5f-24a24742781c"
  "56821ca5-42b5-4672-bc64-f94c97c60eb4"
]

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 ('0cd07f53-82b2-4b0f-afa3-844bbfdcb6d8','aa88506d-8926-40a0-aac9-c12d0836724a','bbab9390-ffbf-429d-ba0e-db0a643fe959','648096be-fb41-4d08-a26b-b35f95d6dfaf','50920f3b-78dd-4108-b9bc-ee0578b240ff','db41b799-9c80-4af3-bca7-0d4ede2737ef','3366c128-1c7b-40f7-906d-c658bdfeec02','72a4849f-2d31-4261-a82d-7c06a0b3afc0','9b2a8470-8d0f-474f-8f5f-24a24742781c','56821ca5-42b5-4672-bc64-f94c97c60eb4');