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

[
  "E67AC046-1A62-45A2-8296-BCF838EEF932"
  "616ECA4D-084F-4888-A18C-1F22077B1B2D"
  "46AB3BF1-2323-4A55-9D6A-7584FA2B751C"
  "1F10474B-4C8B-4975-A280-7CE2011AEBF9"
  "3945EE77-F23C-408C-A904-C272BC17DA8E"
  "A43F3377-7870-44D8-8B0F-1678B8C23C13"
  "1ADB27BE-0D97-42C4-BFD1-37F63FB80A01"
  "5BD42ACE-11C0-406E-BC47-442C12074CA8"
  "EBBF53B1-6D64-4233-8512-74B9491F210C"
  "68C5B476-C903-4309-92E1-F07ADDFF14B9"
  "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 ('E67AC046-1A62-45A2-8296-BCF838EEF932', '616ECA4D-084F-4888-A18C-1F22077B1B2D', '46AB3BF1-2323-4A55-9D6A-7584FA2B751C', '1F10474B-4C8B-4975-A280-7CE2011AEBF9', '3945EE77-F23C-408C-A904-C272BC17DA8E', 'A43F3377-7870-44D8-8B0F-1678B8C23C13', '1ADB27BE-0D97-42C4-BFD1-37F63FB80A01', '5BD42ACE-11C0-406E-BC47-442C12074CA8', 'EBBF53B1-6D64-4233-8512-74B9491F210C', '68C5B476-C903-4309-92E1-F07ADDFF14B9') 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

[
  "E67AC046-1A62-45A2-8296-BCF838EEF932"
  "616ECA4D-084F-4888-A18C-1F22077B1B2D"
  "46AB3BF1-2323-4A55-9D6A-7584FA2B751C"
  "1F10474B-4C8B-4975-A280-7CE2011AEBF9"
  "3945EE77-F23C-408C-A904-C272BC17DA8E"
  "A43F3377-7870-44D8-8B0F-1678B8C23C13"
  "1ADB27BE-0D97-42C4-BFD1-37F63FB80A01"
  "5BD42ACE-11C0-406E-BC47-442C12074CA8"
  "EBBF53B1-6D64-4233-8512-74B9491F210C"
  "68C5B476-C903-4309-92E1-F07ADDFF14B9"
]

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 ('E67AC046-1A62-45A2-8296-BCF838EEF932', '616ECA4D-084F-4888-A18C-1F22077B1B2D', '46AB3BF1-2323-4A55-9D6A-7584FA2B751C', '1F10474B-4C8B-4975-A280-7CE2011AEBF9', '3945EE77-F23C-408C-A904-C272BC17DA8E', 'A43F3377-7870-44D8-8B0F-1678B8C23C13', '1ADB27BE-0D97-42C4-BFD1-37F63FB80A01', '5BD42ACE-11C0-406E-BC47-442C12074CA8', 'EBBF53B1-6D64-4233-8512-74B9491F210C', '68C5B476-C903-4309-92E1-F07ADDFF14B9') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "e67ac046-1a62-45a2-8296-bcf838eef932"
  "616eca4d-084f-4888-a18c-1f22077b1b2d"
  "46ab3bf1-2323-4a55-9d6a-7584fa2b751c"
  "1f10474b-4c8b-4975-a280-7ce2011aebf9"
  "3945ee77-f23c-408c-a904-c272bc17da8e"
  "a43f3377-7870-44d8-8b0f-1678b8c23c13"
  "1adb27be-0d97-42c4-bfd1-37f63fb80a01"
  "5bd42ace-11c0-406e-bc47-442c12074ca8"
  "ebbf53b1-6d64-4233-8512-74b9491f210c"
  "68c5b476-c903-4309-92e1-f07addff14b9"
]

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 ('e67ac046-1a62-45a2-8296-bcf838eef932','616eca4d-084f-4888-a18c-1f22077b1b2d','46ab3bf1-2323-4a55-9d6a-7584fa2b751c','1f10474b-4c8b-4975-a280-7ce2011aebf9','3945ee77-f23c-408c-a904-c272bc17da8e','a43f3377-7870-44d8-8b0f-1678b8c23c13','1adb27be-0d97-42c4-bfd1-37f63fb80a01','5bd42ace-11c0-406e-bc47-442c12074ca8','ebbf53b1-6d64-4233-8512-74b9491f210c','68c5b476-c903-4309-92e1-f07addff14b9');