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(m0_.Id) AS sclr_0 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL AND LOWER(m0_.Role) <> ? AND ((LOWER(m0_.Role) <> ? OR m0_.[TimeStamp] <> (SELECT MIN(m1_.[TimeStamp]) AS sclr_1 FROM dbo.Messages m1_ WHERE m1_.SessionId = m0_.SessionId AND LOWER(m1_.Role) <> ?)))

[
  "system"
  "assistant"
  "system"
]

SELECT
  COUNT(m0_.Id) AS sclr_0
FROM
  dbo.Messages m0_
WHERE
  m0_.SessionId IS NOT NULL
  AND LOWER(m0_.Role) <> ?
  AND (
    (
      LOWER(m0_.Role) <> ?
      OR m0_.[TimeStamp] <> (
        SELECT
          MIN(m1_.[TimeStamp]) AS sclr_1
        FROM
          dbo.Messages m1_
        WHERE
          m1_.SessionId = m0_.SessionId
          AND LOWER(m1_.Role) <> ?
      )
    )
  )

SELECT COUNT(m0_.Id) AS sclr_0 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL AND LOWER(m0_.Role) <> 'system' AND ((LOWER(m0_.Role) <> 'assistant' OR m0_.[TimeStamp] <> (SELECT MIN(m1_.[TimeStamp]) AS sclr_1 FROM dbo.Messages m1_ WHERE m1_.SessionId = m0_.SessionId AND LOWER(m1_.Role) <> 'system')));

SELECT m0_.Id AS Id_0, m0_.Tokens AS Tokens_1, m0_.SessionId AS SessionId_2, m0_.[TimeStamp] AS TimeStamp_3, m0_.Role AS Role_4, m0_.Content AS Content_5, m0_.Name AS Name_6 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL AND LOWER(m0_.Role) <> ? AND ((LOWER(m0_.Role) <> ? OR m0_.[TimeStamp] <> (SELECT MIN(m1_.[TimeStamp]) AS sclr_7 FROM dbo.Messages m1_ WHERE m1_.SessionId = m0_.SessionId AND LOWER(m1_.Role) <> ?))) ORDER BY m0_.[TimeStamp] DESC, m0_.Id DESC OFFSET 3770 ROWS FETCH NEXT 10 ROWS ONLY

[
  "system"
  "assistant"
  "system"
]

SELECT
  m0_.Id AS Id_0,
  m0_.Tokens AS Tokens_1,
  m0_.SessionId AS SessionId_2,
  m0_.[TimeStamp] AS TimeStamp_3,
  m0_.Role AS Role_4,
  m0_.Content AS Content_5,
  m0_.Name AS Name_6
FROM
  dbo.Messages m0_
WHERE
  m0_.SessionId IS NOT NULL
  AND LOWER(m0_.Role) <> ?
  AND (
    (
      LOWER(m0_.Role) <> ?
      OR m0_.[TimeStamp] <> (
        SELECT
          MIN(m1_.[TimeStamp]) AS sclr_7
        FROM
          dbo.Messages m1_
        WHERE
          m1_.SessionId = m0_.SessionId
          AND LOWER(m1_.Role) <> ?
      )
    )
  )
ORDER BY
  m0_.[TimeStamp] DESC,
  m0_.Id DESC
OFFSET
  3770
ROWS
FETCH
  NEXT 10
ROWS
  ONLY

SELECT m0_.Id AS Id_0, m0_.Tokens AS Tokens_1, m0_.SessionId AS SessionId_2, m0_.[TimeStamp] AS TimeStamp_3, m0_.Role AS Role_4, m0_.Content AS Content_5, m0_.Name AS Name_6 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL AND LOWER(m0_.Role) <> 'system' AND ((LOWER(m0_.Role) <> 'assistant' OR m0_.[TimeStamp] <> (SELECT MIN(m1_.[TimeStamp]) AS sclr_7 FROM dbo.Messages m1_ WHERE m1_.SessionId = m0_.SessionId AND LOWER(m1_.Role) <> 'system'))) ORDER BY m0_.[TimeStamp] DESC, m0_.Id DESC OFFSET 3770 ROWS FETCH NEXT 10 ROWS ONLY;

SELECT LOWER(CAST(Id AS NVARCHAR(36))) AS id, Name
                   FROM dbo.Sessions
                   WHERE LOWER(CAST(Id AS NVARCHAR(36))) IN (?,?,?,?,?,?)

[
  "a1d908b7-2b6c-4250-ac70-2eb991ddc201"
  "e6a62ce8-7858-4c8a-aaa5-2b3ce0f387d5"
  "3ae4606b-cce9-4565-ae31-411c61df55c0"
  "5535f0f6-5053-4a1b-bc3e-1a402f77d53a"
  "c572923e-e44b-4151-a617-0948f49a16d3"
  "accbdaee-3d7d-4379-9340-853f3724cda8"
]

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 ('a1d908b7-2b6c-4250-ac70-2eb991ddc201','e6a62ce8-7858-4c8a-aaa5-2b3ce0f387d5','3ae4606b-cce9-4565-ae31-411c61df55c0','5535f0f6-5053-4a1b-bc3e-1a402f77d53a','c572923e-e44b-4151-a617-0948f49a16d3','accbdaee-3d7d-4379-9340-853f3724cda8');