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

[
  "536761CD-88A9-4309-B07B-748789FD231E"
  "7DB313FF-5A53-4780-A828-2C4468FA1F5C"
  "96B1FAD8-0314-4DC0-81FE-2E0652A3B1EC"
  "58EE16BC-2B9D-45DA-A064-CE2AD93184CB"
  "2B4C2FDF-C466-4FFE-87D0-607728427D7F"
  "0352B3C6-F444-4095-B0F8-DBE2200E31A2"
  "D671CCB4-F792-4E99-B98A-824B27F6F244"
  "8B1091B8-241F-4BAD-93E7-522ECDD0F572"
  "79FBD406-FC63-4F8E-A198-1AF78E543CE1"
  "90FA5ABE-593F-4117-9EF9-B02BEB308DD5"
  "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 ('536761CD-88A9-4309-B07B-748789FD231E', '7DB313FF-5A53-4780-A828-2C4468FA1F5C', '96B1FAD8-0314-4DC0-81FE-2E0652A3B1EC', '58EE16BC-2B9D-45DA-A064-CE2AD93184CB', '2B4C2FDF-C466-4FFE-87D0-607728427D7F', '0352B3C6-F444-4095-B0F8-DBE2200E31A2', 'D671CCB4-F792-4E99-B98A-824B27F6F244', '8B1091B8-241F-4BAD-93E7-522ECDD0F572', '79FBD406-FC63-4F8E-A198-1AF78E543CE1', '90FA5ABE-593F-4117-9EF9-B02BEB308DD5') 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

[
  "536761CD-88A9-4309-B07B-748789FD231E"
  "7DB313FF-5A53-4780-A828-2C4468FA1F5C"
  "96B1FAD8-0314-4DC0-81FE-2E0652A3B1EC"
  "58EE16BC-2B9D-45DA-A064-CE2AD93184CB"
  "2B4C2FDF-C466-4FFE-87D0-607728427D7F"
  "0352B3C6-F444-4095-B0F8-DBE2200E31A2"
  "D671CCB4-F792-4E99-B98A-824B27F6F244"
  "8B1091B8-241F-4BAD-93E7-522ECDD0F572"
  "79FBD406-FC63-4F8E-A198-1AF78E543CE1"
  "90FA5ABE-593F-4117-9EF9-B02BEB308DD5"
]

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 ('536761CD-88A9-4309-B07B-748789FD231E', '7DB313FF-5A53-4780-A828-2C4468FA1F5C', '96B1FAD8-0314-4DC0-81FE-2E0652A3B1EC', '58EE16BC-2B9D-45DA-A064-CE2AD93184CB', '2B4C2FDF-C466-4FFE-87D0-607728427D7F', '0352B3C6-F444-4095-B0F8-DBE2200E31A2', 'D671CCB4-F792-4E99-B98A-824B27F6F244', '8B1091B8-241F-4BAD-93E7-522ECDD0F572', '79FBD406-FC63-4F8E-A198-1AF78E543CE1', '90FA5ABE-593F-4117-9EF9-B02BEB308DD5') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "536761cd-88a9-4309-b07b-748789fd231e"
  "7db313ff-5a53-4780-a828-2c4468fa1f5c"
  "96b1fad8-0314-4dc0-81fe-2e0652a3b1ec"
  "58ee16bc-2b9d-45da-a064-ce2ad93184cb"
  "2b4c2fdf-c466-4ffe-87d0-607728427d7f"
  "0352b3c6-f444-4095-b0f8-dbe2200e31a2"
  "d671ccb4-f792-4e99-b98a-824b27f6f244"
  "8b1091b8-241f-4bad-93e7-522ecdd0f572"
  "79fbd406-fc63-4f8e-a198-1af78e543ce1"
  "90fa5abe-593f-4117-9ef9-b02beb308dd5"
]

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 ('536761cd-88a9-4309-b07b-748789fd231e','7db313ff-5a53-4780-a828-2c4468fa1f5c','96b1fad8-0314-4dc0-81fe-2e0652a3b1ec','58ee16bc-2b9d-45da-a064-ce2ad93184cb','2b4c2fdf-c466-4ffe-87d0-607728427d7f','0352b3c6-f444-4095-b0f8-dbe2200e31a2','d671ccb4-f792-4e99-b98a-824b27f6f244','8b1091b8-241f-4bad-93e7-522ecdd0f572','79fbd406-fc63-4f8e-a198-1af78e543ce1','90fa5abe-593f-4117-9ef9-b02beb308dd5');