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

[
  "ADB9DF50-799F-4BCB-9440-9FE02C82FEFB"
  "1E1441EB-5958-4F52-BE31-3C4BF7D4A0E3"
  "DEFFF3ED-FBEE-477E-B9F8-3F155B1F0772"
  "A103686D-7047-443A-808A-E2E356E8382A"
  "234C068E-834E-47D6-B966-87E20EFF223F"
  "FD161D34-E30F-4556-9E8F-A5269CF6626C"
  "DBD6D18E-D93E-4453-8328-858C7B487DB3"
  "F0528EBC-1782-4B90-8CA3-2FA5D5FC06AA"
  "1EB16BF1-ED88-475F-BFE8-080BEB2F57DA"
  "1DBC8BC3-3F5A-499F-B338-6C5BD906BAA3"
  "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 ('ADB9DF50-799F-4BCB-9440-9FE02C82FEFB', '1E1441EB-5958-4F52-BE31-3C4BF7D4A0E3', 'DEFFF3ED-FBEE-477E-B9F8-3F155B1F0772', 'A103686D-7047-443A-808A-E2E356E8382A', '234C068E-834E-47D6-B966-87E20EFF223F', 'FD161D34-E30F-4556-9E8F-A5269CF6626C', 'DBD6D18E-D93E-4453-8328-858C7B487DB3', 'F0528EBC-1782-4B90-8CA3-2FA5D5FC06AA', '1EB16BF1-ED88-475F-BFE8-080BEB2F57DA', '1DBC8BC3-3F5A-499F-B338-6C5BD906BAA3') 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

[
  "ADB9DF50-799F-4BCB-9440-9FE02C82FEFB"
  "1E1441EB-5958-4F52-BE31-3C4BF7D4A0E3"
  "DEFFF3ED-FBEE-477E-B9F8-3F155B1F0772"
  "A103686D-7047-443A-808A-E2E356E8382A"
  "234C068E-834E-47D6-B966-87E20EFF223F"
  "FD161D34-E30F-4556-9E8F-A5269CF6626C"
  "DBD6D18E-D93E-4453-8328-858C7B487DB3"
  "F0528EBC-1782-4B90-8CA3-2FA5D5FC06AA"
  "1EB16BF1-ED88-475F-BFE8-080BEB2F57DA"
  "1DBC8BC3-3F5A-499F-B338-6C5BD906BAA3"
]

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 ('ADB9DF50-799F-4BCB-9440-9FE02C82FEFB', '1E1441EB-5958-4F52-BE31-3C4BF7D4A0E3', 'DEFFF3ED-FBEE-477E-B9F8-3F155B1F0772', 'A103686D-7047-443A-808A-E2E356E8382A', '234C068E-834E-47D6-B966-87E20EFF223F', 'FD161D34-E30F-4556-9E8F-A5269CF6626C', 'DBD6D18E-D93E-4453-8328-858C7B487DB3', 'F0528EBC-1782-4B90-8CA3-2FA5D5FC06AA', '1EB16BF1-ED88-475F-BFE8-080BEB2F57DA', '1DBC8BC3-3F5A-499F-B338-6C5BD906BAA3') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "adb9df50-799f-4bcb-9440-9fe02c82fefb"
  "1e1441eb-5958-4f52-be31-3c4bf7d4a0e3"
  "defff3ed-fbee-477e-b9f8-3f155b1f0772"
  "a103686d-7047-443a-808a-e2e356e8382a"
  "234c068e-834e-47d6-b966-87e20eff223f"
  "fd161d34-e30f-4556-9e8f-a5269cf6626c"
  "dbd6d18e-d93e-4453-8328-858c7b487db3"
  "f0528ebc-1782-4b90-8ca3-2fa5d5fc06aa"
  "1eb16bf1-ed88-475f-bfe8-080beb2f57da"
  "1dbc8bc3-3f5a-499f-b338-6c5bd906baa3"
]

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 ('adb9df50-799f-4bcb-9440-9fe02c82fefb','1e1441eb-5958-4f52-be31-3c4bf7d4a0e3','defff3ed-fbee-477e-b9f8-3f155b1f0772','a103686d-7047-443a-808a-e2e356e8382a','234c068e-834e-47d6-b966-87e20eff223f','fd161d34-e30f-4556-9e8f-a5269cf6626c','dbd6d18e-d93e-4453-8328-858c7b487db3','f0528ebc-1782-4b90-8ca3-2fa5d5fc06aa','1eb16bf1-ed88-475f-bfe8-080beb2f57da','1dbc8bc3-3f5a-499f-b338-6c5bd906baa3');