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

[
  "F689B9F2-1993-4012-ADFE-BE091AAEEED0"
  "C284A3E9-A62C-4381-808D-EBEE01EAB357"
  "EFC95CDD-B68D-4893-A5ED-53D048490042"
  "5171DA49-28D2-410A-A2DF-9CCBDBD3F9A9"
  "05035A9F-BDB8-493C-B1D1-5E835C1A59CC"
  "F70A202C-4E94-4DAC-AD85-318F10ED7108"
  "E23CF47D-5AE0-4C4A-B272-D15B1369CA53"
  "4FE77E04-9D35-4F62-A1D5-9F050FC6F1FB"
  "BAC9EB17-1843-4A2E-8FE0-8DA15CC34886"
  "AA958F8E-CB69-41CD-9343-54EF6894B78B"
  "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 ('F689B9F2-1993-4012-ADFE-BE091AAEEED0', 'C284A3E9-A62C-4381-808D-EBEE01EAB357', 'EFC95CDD-B68D-4893-A5ED-53D048490042', '5171DA49-28D2-410A-A2DF-9CCBDBD3F9A9', '05035A9F-BDB8-493C-B1D1-5E835C1A59CC', 'F70A202C-4E94-4DAC-AD85-318F10ED7108', 'E23CF47D-5AE0-4C4A-B272-D15B1369CA53', '4FE77E04-9D35-4F62-A1D5-9F050FC6F1FB', 'BAC9EB17-1843-4A2E-8FE0-8DA15CC34886', 'AA958F8E-CB69-41CD-9343-54EF6894B78B') 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

[
  "F689B9F2-1993-4012-ADFE-BE091AAEEED0"
  "C284A3E9-A62C-4381-808D-EBEE01EAB357"
  "EFC95CDD-B68D-4893-A5ED-53D048490042"
  "5171DA49-28D2-410A-A2DF-9CCBDBD3F9A9"
  "05035A9F-BDB8-493C-B1D1-5E835C1A59CC"
  "F70A202C-4E94-4DAC-AD85-318F10ED7108"
  "E23CF47D-5AE0-4C4A-B272-D15B1369CA53"
  "4FE77E04-9D35-4F62-A1D5-9F050FC6F1FB"
  "BAC9EB17-1843-4A2E-8FE0-8DA15CC34886"
  "AA958F8E-CB69-41CD-9343-54EF6894B78B"
]

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 ('F689B9F2-1993-4012-ADFE-BE091AAEEED0', 'C284A3E9-A62C-4381-808D-EBEE01EAB357', 'EFC95CDD-B68D-4893-A5ED-53D048490042', '5171DA49-28D2-410A-A2DF-9CCBDBD3F9A9', '05035A9F-BDB8-493C-B1D1-5E835C1A59CC', 'F70A202C-4E94-4DAC-AD85-318F10ED7108', 'E23CF47D-5AE0-4C4A-B272-D15B1369CA53', '4FE77E04-9D35-4F62-A1D5-9F050FC6F1FB', 'BAC9EB17-1843-4A2E-8FE0-8DA15CC34886', 'AA958F8E-CB69-41CD-9343-54EF6894B78B') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "f689b9f2-1993-4012-adfe-be091aaeeed0"
  "c284a3e9-a62c-4381-808d-ebee01eab357"
  "efc95cdd-b68d-4893-a5ed-53d048490042"
  "5171da49-28d2-410a-a2df-9ccbdbd3f9a9"
  "05035a9f-bdb8-493c-b1d1-5e835c1a59cc"
  "f70a202c-4e94-4dac-ad85-318f10ed7108"
  "e23cf47d-5ae0-4c4a-b272-d15b1369ca53"
  "4fe77e04-9d35-4f62-a1d5-9f050fc6f1fb"
  "bac9eb17-1843-4a2e-8fe0-8da15cc34886"
  "aa958f8e-cb69-41cd-9343-54ef6894b78b"
]

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 ('f689b9f2-1993-4012-adfe-be091aaeeed0','c284a3e9-a62c-4381-808d-ebee01eab357','efc95cdd-b68d-4893-a5ed-53d048490042','5171da49-28d2-410a-a2df-9ccbdbd3f9a9','05035a9f-bdb8-493c-b1d1-5e835c1a59cc','f70a202c-4e94-4dac-ad85-318f10ed7108','e23cf47d-5ae0-4c4a-b272-d15b1369ca53','4fe77e04-9d35-4f62-a1d5-9f050fc6f1fb','bac9eb17-1843-4a2e-8fe0-8da15cc34886','aa958f8e-cb69-41cd-9343-54ef6894b78b');