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

[
  "C44E3840-66C2-4FAB-B88E-20C774762F11"
  "5D9A4FBD-B7A5-4B66-A5EE-243A2626FB26"
  "009B7515-83AB-4AD4-9546-B5A465C7187A"
  "DB725ACA-8BF0-4EEF-BCFB-D724E24AEF70"
  "15F62702-DFE8-4BD4-89CB-E3DA709B708A"
  "93D91F4C-C0F6-4801-BF61-9CFD9A7129C8"
  "3BE957EC-843A-441C-A6F0-E94046AE7208"
  "239C0C7E-62D4-47A7-8115-911F75C17D0E"
  "0E073CF3-4710-4954-B34D-698D6BC5935C"
  "9702A911-F7C5-4AFC-AB3B-D61464539059"
  "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 ('C44E3840-66C2-4FAB-B88E-20C774762F11', '5D9A4FBD-B7A5-4B66-A5EE-243A2626FB26', '009B7515-83AB-4AD4-9546-B5A465C7187A', 'DB725ACA-8BF0-4EEF-BCFB-D724E24AEF70', '15F62702-DFE8-4BD4-89CB-E3DA709B708A', '93D91F4C-C0F6-4801-BF61-9CFD9A7129C8', '3BE957EC-843A-441C-A6F0-E94046AE7208', '239C0C7E-62D4-47A7-8115-911F75C17D0E', '0E073CF3-4710-4954-B34D-698D6BC5935C', '9702A911-F7C5-4AFC-AB3B-D61464539059') 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

[
  "C44E3840-66C2-4FAB-B88E-20C774762F11"
  "5D9A4FBD-B7A5-4B66-A5EE-243A2626FB26"
  "009B7515-83AB-4AD4-9546-B5A465C7187A"
  "DB725ACA-8BF0-4EEF-BCFB-D724E24AEF70"
  "15F62702-DFE8-4BD4-89CB-E3DA709B708A"
  "93D91F4C-C0F6-4801-BF61-9CFD9A7129C8"
  "3BE957EC-843A-441C-A6F0-E94046AE7208"
  "239C0C7E-62D4-47A7-8115-911F75C17D0E"
  "0E073CF3-4710-4954-B34D-698D6BC5935C"
  "9702A911-F7C5-4AFC-AB3B-D61464539059"
]

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 ('C44E3840-66C2-4FAB-B88E-20C774762F11', '5D9A4FBD-B7A5-4B66-A5EE-243A2626FB26', '009B7515-83AB-4AD4-9546-B5A465C7187A', 'DB725ACA-8BF0-4EEF-BCFB-D724E24AEF70', '15F62702-DFE8-4BD4-89CB-E3DA709B708A', '93D91F4C-C0F6-4801-BF61-9CFD9A7129C8', '3BE957EC-843A-441C-A6F0-E94046AE7208', '239C0C7E-62D4-47A7-8115-911F75C17D0E', '0E073CF3-4710-4954-B34D-698D6BC5935C', '9702A911-F7C5-4AFC-AB3B-D61464539059') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "c44e3840-66c2-4fab-b88e-20c774762f11"
  "5d9a4fbd-b7a5-4b66-a5ee-243a2626fb26"
  "009b7515-83ab-4ad4-9546-b5a465c7187a"
  "db725aca-8bf0-4eef-bcfb-d724e24aef70"
  "15f62702-dfe8-4bd4-89cb-e3da709b708a"
  "93d91f4c-c0f6-4801-bf61-9cfd9a7129c8"
  "3be957ec-843a-441c-a6f0-e94046ae7208"
  "239c0c7e-62d4-47a7-8115-911f75c17d0e"
  "0e073cf3-4710-4954-b34d-698d6bc5935c"
  "9702a911-f7c5-4afc-ab3b-d61464539059"
]

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 ('c44e3840-66c2-4fab-b88e-20c774762f11','5d9a4fbd-b7a5-4b66-a5ee-243a2626fb26','009b7515-83ab-4ad4-9546-b5a465c7187a','db725aca-8bf0-4eef-bcfb-d724e24aef70','15f62702-dfe8-4bd4-89cb-e3da709b708a','93d91f4c-c0f6-4801-bf61-9cfd9a7129c8','3be957ec-843a-441c-a6f0-e94046ae7208','239c0c7e-62d4-47a7-8115-911f75c17d0e','0e073cf3-4710-4954-b34d-698d6bc5935c','9702a911-f7c5-4afc-ab3b-d61464539059');