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

[
  "230C6D27-0228-4DA1-A33A-0378242E3BAF"
  "0FDBB763-EC49-47C4-8FA9-A2549869E69F"
  "72239B60-903F-4A3D-9F89-149DC407AA25"
  "8EA09D52-2B4C-43DA-AA33-4DB1B5BF98FE"
  "F758E6D7-1DD5-48EF-922C-34717E44058C"
  "529B5B6A-8C73-4357-874C-6E7E1705F4DB"
  "5D527BF9-255B-4AEA-98E6-6C7C9EBC6CB6"
  "2D8590CF-4100-4CA3-A6D4-E926B2CC769C"
  "5A8B222D-60F3-4746-A95E-BB9F3B18C220"
  "22A7CE6E-1B01-4D61-94C0-77AFC25AAE00"
  "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 ('230C6D27-0228-4DA1-A33A-0378242E3BAF', '0FDBB763-EC49-47C4-8FA9-A2549869E69F', '72239B60-903F-4A3D-9F89-149DC407AA25', '8EA09D52-2B4C-43DA-AA33-4DB1B5BF98FE', 'F758E6D7-1DD5-48EF-922C-34717E44058C', '529B5B6A-8C73-4357-874C-6E7E1705F4DB', '5D527BF9-255B-4AEA-98E6-6C7C9EBC6CB6', '2D8590CF-4100-4CA3-A6D4-E926B2CC769C', '5A8B222D-60F3-4746-A95E-BB9F3B18C220', '22A7CE6E-1B01-4D61-94C0-77AFC25AAE00') 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

[
  "230C6D27-0228-4DA1-A33A-0378242E3BAF"
  "0FDBB763-EC49-47C4-8FA9-A2549869E69F"
  "72239B60-903F-4A3D-9F89-149DC407AA25"
  "8EA09D52-2B4C-43DA-AA33-4DB1B5BF98FE"
  "F758E6D7-1DD5-48EF-922C-34717E44058C"
  "529B5B6A-8C73-4357-874C-6E7E1705F4DB"
  "5D527BF9-255B-4AEA-98E6-6C7C9EBC6CB6"
  "2D8590CF-4100-4CA3-A6D4-E926B2CC769C"
  "5A8B222D-60F3-4746-A95E-BB9F3B18C220"
  "22A7CE6E-1B01-4D61-94C0-77AFC25AAE00"
]

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 ('230C6D27-0228-4DA1-A33A-0378242E3BAF', '0FDBB763-EC49-47C4-8FA9-A2549869E69F', '72239B60-903F-4A3D-9F89-149DC407AA25', '8EA09D52-2B4C-43DA-AA33-4DB1B5BF98FE', 'F758E6D7-1DD5-48EF-922C-34717E44058C', '529B5B6A-8C73-4357-874C-6E7E1705F4DB', '5D527BF9-255B-4AEA-98E6-6C7C9EBC6CB6', '2D8590CF-4100-4CA3-A6D4-E926B2CC769C', '5A8B222D-60F3-4746-A95E-BB9F3B18C220', '22A7CE6E-1B01-4D61-94C0-77AFC25AAE00') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "230c6d27-0228-4da1-a33a-0378242e3baf"
  "0fdbb763-ec49-47c4-8fa9-a2549869e69f"
  "72239b60-903f-4a3d-9f89-149dc407aa25"
  "8ea09d52-2b4c-43da-aa33-4db1b5bf98fe"
  "f758e6d7-1dd5-48ef-922c-34717e44058c"
  "529b5b6a-8c73-4357-874c-6e7e1705f4db"
  "5d527bf9-255b-4aea-98e6-6c7c9ebc6cb6"
  "2d8590cf-4100-4ca3-a6d4-e926b2cc769c"
  "5a8b222d-60f3-4746-a95e-bb9f3b18c220"
  "22a7ce6e-1b01-4d61-94c0-77afc25aae00"
]

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 ('230c6d27-0228-4da1-a33a-0378242e3baf','0fdbb763-ec49-47c4-8fa9-a2549869e69f','72239b60-903f-4a3d-9f89-149dc407aa25','8ea09d52-2b4c-43da-aa33-4db1b5bf98fe','f758e6d7-1dd5-48ef-922c-34717e44058c','529b5b6a-8c73-4357-874c-6e7e1705f4db','5d527bf9-255b-4aea-98e6-6c7c9ebc6cb6','2d8590cf-4100-4ca3-a6d4-e926b2cc769c','5a8b222d-60f3-4746-a95e-bb9f3b18c220','22a7ce6e-1b01-4d61-94c0-77afc25aae00');