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

[
  "74C6DDCE-1907-4C5D-BC03-FD1EEFE15339"
  "35934626-30F2-4728-8192-6DCD2FEFFB00"
  "2C07DA50-00B9-49C5-A4CB-1AC72A830985"
  "59869DCD-E332-4694-A5B1-1D134D0E4CE4"
  "4473804C-E5A6-433A-AAB5-B42957FC4C0C"
  "5D6EFE93-ACC5-4BF5-B45D-803A79176DA9"
  "20A05F1B-8716-4DF8-B080-88B98BF6C51F"
  "250C87A8-5CFA-44C1-9CFA-1D81A5FAD2E2"
  "5AA2266C-8A55-47F0-81B0-E3EF2A3E0C16"
  "85244A23-5736-43E8-AD0A-D1E03DAB6F98"
  "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 ('74C6DDCE-1907-4C5D-BC03-FD1EEFE15339', '35934626-30F2-4728-8192-6DCD2FEFFB00', '2C07DA50-00B9-49C5-A4CB-1AC72A830985', '59869DCD-E332-4694-A5B1-1D134D0E4CE4', '4473804C-E5A6-433A-AAB5-B42957FC4C0C', '5D6EFE93-ACC5-4BF5-B45D-803A79176DA9', '20A05F1B-8716-4DF8-B080-88B98BF6C51F', '250C87A8-5CFA-44C1-9CFA-1D81A5FAD2E2', '5AA2266C-8A55-47F0-81B0-E3EF2A3E0C16', '85244A23-5736-43E8-AD0A-D1E03DAB6F98') 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

[
  "74C6DDCE-1907-4C5D-BC03-FD1EEFE15339"
  "35934626-30F2-4728-8192-6DCD2FEFFB00"
  "2C07DA50-00B9-49C5-A4CB-1AC72A830985"
  "59869DCD-E332-4694-A5B1-1D134D0E4CE4"
  "4473804C-E5A6-433A-AAB5-B42957FC4C0C"
  "5D6EFE93-ACC5-4BF5-B45D-803A79176DA9"
  "20A05F1B-8716-4DF8-B080-88B98BF6C51F"
  "250C87A8-5CFA-44C1-9CFA-1D81A5FAD2E2"
  "5AA2266C-8A55-47F0-81B0-E3EF2A3E0C16"
  "85244A23-5736-43E8-AD0A-D1E03DAB6F98"
]

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 ('74C6DDCE-1907-4C5D-BC03-FD1EEFE15339', '35934626-30F2-4728-8192-6DCD2FEFFB00', '2C07DA50-00B9-49C5-A4CB-1AC72A830985', '59869DCD-E332-4694-A5B1-1D134D0E4CE4', '4473804C-E5A6-433A-AAB5-B42957FC4C0C', '5D6EFE93-ACC5-4BF5-B45D-803A79176DA9', '20A05F1B-8716-4DF8-B080-88B98BF6C51F', '250C87A8-5CFA-44C1-9CFA-1D81A5FAD2E2', '5AA2266C-8A55-47F0-81B0-E3EF2A3E0C16', '85244A23-5736-43E8-AD0A-D1E03DAB6F98') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "74c6ddce-1907-4c5d-bc03-fd1eefe15339"
  "35934626-30f2-4728-8192-6dcd2feffb00"
  "2c07da50-00b9-49c5-a4cb-1ac72a830985"
  "59869dcd-e332-4694-a5b1-1d134d0e4ce4"
  "4473804c-e5a6-433a-aab5-b42957fc4c0c"
  "5d6efe93-acc5-4bf5-b45d-803a79176da9"
  "20a05f1b-8716-4df8-b080-88b98bf6c51f"
  "250c87a8-5cfa-44c1-9cfa-1d81a5fad2e2"
  "5aa2266c-8a55-47f0-81b0-e3ef2a3e0c16"
  "85244a23-5736-43e8-ad0a-d1e03dab6f98"
]

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 ('74c6ddce-1907-4c5d-bc03-fd1eefe15339','35934626-30f2-4728-8192-6dcd2feffb00','2c07da50-00b9-49c5-a4cb-1ac72a830985','59869dcd-e332-4694-a5b1-1d134d0e4ce4','4473804c-e5a6-433a-aab5-b42957fc4c0c','5d6efe93-acc5-4bf5-b45d-803a79176da9','20a05f1b-8716-4df8-b080-88b98bf6c51f','250c87a8-5cfa-44c1-9cfa-1d81a5fad2e2','5aa2266c-8a55-47f0-81b0-e3ef2a3e0c16','85244a23-5736-43e8-ad0a-d1e03dab6f98');