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

[
  "BA908780-C94D-4CF0-8108-BBDE96A35349"
  "BC874D67-56E2-4A30-95D1-F2CE0DBC79BC"
  "13CE26E6-7130-4877-99AF-1BC2C8DC1A4F"
  "6A60CE0A-960B-4AEF-9C31-8981E17D0D28"
  "1BA86C5D-6543-494C-B0E0-BFF2ABF85F42"
  "6ED9E30D-A326-49F7-963A-8ED99A4412C7"
  "FAEFD35B-F265-4186-918D-BC49F5C373C6"
  "AB1A745A-8C77-48C0-8CF0-0587FF510CC5"
  "3D394C17-F806-42DA-80A6-BF2F2F0046DF"
  "D2CE29F0-1693-4BBD-8E40-CCBFFE5FB451"
  "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 ('BA908780-C94D-4CF0-8108-BBDE96A35349', 'BC874D67-56E2-4A30-95D1-F2CE0DBC79BC', '13CE26E6-7130-4877-99AF-1BC2C8DC1A4F', '6A60CE0A-960B-4AEF-9C31-8981E17D0D28', '1BA86C5D-6543-494C-B0E0-BFF2ABF85F42', '6ED9E30D-A326-49F7-963A-8ED99A4412C7', 'FAEFD35B-F265-4186-918D-BC49F5C373C6', 'AB1A745A-8C77-48C0-8CF0-0587FF510CC5', '3D394C17-F806-42DA-80A6-BF2F2F0046DF', 'D2CE29F0-1693-4BBD-8E40-CCBFFE5FB451') 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

[
  "BA908780-C94D-4CF0-8108-BBDE96A35349"
  "BC874D67-56E2-4A30-95D1-F2CE0DBC79BC"
  "13CE26E6-7130-4877-99AF-1BC2C8DC1A4F"
  "6A60CE0A-960B-4AEF-9C31-8981E17D0D28"
  "1BA86C5D-6543-494C-B0E0-BFF2ABF85F42"
  "6ED9E30D-A326-49F7-963A-8ED99A4412C7"
  "FAEFD35B-F265-4186-918D-BC49F5C373C6"
  "AB1A745A-8C77-48C0-8CF0-0587FF510CC5"
  "3D394C17-F806-42DA-80A6-BF2F2F0046DF"
  "D2CE29F0-1693-4BBD-8E40-CCBFFE5FB451"
]

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 ('BA908780-C94D-4CF0-8108-BBDE96A35349', 'BC874D67-56E2-4A30-95D1-F2CE0DBC79BC', '13CE26E6-7130-4877-99AF-1BC2C8DC1A4F', '6A60CE0A-960B-4AEF-9C31-8981E17D0D28', '1BA86C5D-6543-494C-B0E0-BFF2ABF85F42', '6ED9E30D-A326-49F7-963A-8ED99A4412C7', 'FAEFD35B-F265-4186-918D-BC49F5C373C6', 'AB1A745A-8C77-48C0-8CF0-0587FF510CC5', '3D394C17-F806-42DA-80A6-BF2F2F0046DF', 'D2CE29F0-1693-4BBD-8E40-CCBFFE5FB451') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "ba908780-c94d-4cf0-8108-bbde96a35349"
  "bc874d67-56e2-4a30-95d1-f2ce0dbc79bc"
  "13ce26e6-7130-4877-99af-1bc2c8dc1a4f"
  "6a60ce0a-960b-4aef-9c31-8981e17d0d28"
  "1ba86c5d-6543-494c-b0e0-bff2abf85f42"
  "6ed9e30d-a326-49f7-963a-8ed99a4412c7"
  "faefd35b-f265-4186-918d-bc49f5c373c6"
  "ab1a745a-8c77-48c0-8cf0-0587ff510cc5"
  "3d394c17-f806-42da-80a6-bf2f2f0046df"
  "d2ce29f0-1693-4bbd-8e40-ccbffe5fb451"
]

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 ('ba908780-c94d-4cf0-8108-bbde96a35349','bc874d67-56e2-4a30-95d1-f2ce0dbc79bc','13ce26e6-7130-4877-99af-1bc2c8dc1a4f','6a60ce0a-960b-4aef-9c31-8981e17d0d28','1ba86c5d-6543-494c-b0e0-bff2abf85f42','6ed9e30d-a326-49f7-963a-8ed99a4412c7','faefd35b-f265-4186-918d-bc49f5c373c6','ab1a745a-8c77-48c0-8cf0-0587ff510cc5','3d394c17-f806-42da-80a6-bf2f2f0046df','d2ce29f0-1693-4bbd-8e40-ccbffe5fb451');