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

[
  "9D3DABE9-6F5B-4752-8163-947C3529BEDF"
  "60A79294-C590-44B4-BD2A-51061AE71972"
  "B4B73280-A9C2-4A7B-8549-69BC41712BAB"
  "3F6FB06F-D77E-4D08-BEA3-0A063C8546CE"
  "C7E6E837-F287-466B-8DAE-5F8F124CFDF1"
  "BDF0D953-6053-4EF6-9C75-EE2D524E120A"
  "78C7BE4B-40D5-464B-8FD0-5CE177CFC340"
  "F5F12261-1EC0-42A4-A612-9F06B26D937E"
  "725CB22D-B97C-4C4E-8E5B-776A199C0B37"
  "A879AB07-F0F7-4178-BCDB-AD956A40D86F"
  "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 ('9D3DABE9-6F5B-4752-8163-947C3529BEDF', '60A79294-C590-44B4-BD2A-51061AE71972', 'B4B73280-A9C2-4A7B-8549-69BC41712BAB', '3F6FB06F-D77E-4D08-BEA3-0A063C8546CE', 'C7E6E837-F287-466B-8DAE-5F8F124CFDF1', 'BDF0D953-6053-4EF6-9C75-EE2D524E120A', '78C7BE4B-40D5-464B-8FD0-5CE177CFC340', 'F5F12261-1EC0-42A4-A612-9F06B26D937E', '725CB22D-B97C-4C4E-8E5B-776A199C0B37', 'A879AB07-F0F7-4178-BCDB-AD956A40D86F') 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

[
  "9D3DABE9-6F5B-4752-8163-947C3529BEDF"
  "60A79294-C590-44B4-BD2A-51061AE71972"
  "B4B73280-A9C2-4A7B-8549-69BC41712BAB"
  "3F6FB06F-D77E-4D08-BEA3-0A063C8546CE"
  "C7E6E837-F287-466B-8DAE-5F8F124CFDF1"
  "BDF0D953-6053-4EF6-9C75-EE2D524E120A"
  "78C7BE4B-40D5-464B-8FD0-5CE177CFC340"
  "F5F12261-1EC0-42A4-A612-9F06B26D937E"
  "725CB22D-B97C-4C4E-8E5B-776A199C0B37"
  "A879AB07-F0F7-4178-BCDB-AD956A40D86F"
]

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 ('9D3DABE9-6F5B-4752-8163-947C3529BEDF', '60A79294-C590-44B4-BD2A-51061AE71972', 'B4B73280-A9C2-4A7B-8549-69BC41712BAB', '3F6FB06F-D77E-4D08-BEA3-0A063C8546CE', 'C7E6E837-F287-466B-8DAE-5F8F124CFDF1', 'BDF0D953-6053-4EF6-9C75-EE2D524E120A', '78C7BE4B-40D5-464B-8FD0-5CE177CFC340', 'F5F12261-1EC0-42A4-A612-9F06B26D937E', '725CB22D-B97C-4C4E-8E5B-776A199C0B37', 'A879AB07-F0F7-4178-BCDB-AD956A40D86F') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "9d3dabe9-6f5b-4752-8163-947c3529bedf"
  "60a79294-c590-44b4-bd2a-51061ae71972"
  "b4b73280-a9c2-4a7b-8549-69bc41712bab"
  "3f6fb06f-d77e-4d08-bea3-0a063c8546ce"
  "c7e6e837-f287-466b-8dae-5f8f124cfdf1"
  "bdf0d953-6053-4ef6-9c75-ee2d524e120a"
  "78c7be4b-40d5-464b-8fd0-5ce177cfc340"
  "f5f12261-1ec0-42a4-a612-9f06b26d937e"
  "725cb22d-b97c-4c4e-8e5b-776a199c0b37"
  "a879ab07-f0f7-4178-bcdb-ad956a40d86f"
]

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 ('9d3dabe9-6f5b-4752-8163-947c3529bedf','60a79294-c590-44b4-bd2a-51061ae71972','b4b73280-a9c2-4a7b-8549-69bc41712bab','3f6fb06f-d77e-4d08-bea3-0a063c8546ce','c7e6e837-f287-466b-8dae-5f8f124cfdf1','bdf0d953-6053-4ef6-9c75-ee2d524e120a','78c7be4b-40d5-464b-8fd0-5ce177cfc340','f5f12261-1ec0-42a4-a612-9f06b26d937e','725cb22d-b97c-4c4e-8e5b-776a199c0b37','a879ab07-f0f7-4178-bcdb-ad956a40d86f');