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

[
  "9ED7C2DC-48A9-4711-A575-465A1AD4DDB9"
  "25029E33-5CEF-4800-A14F-87DC0FE94501"
  "8AF68491-2A72-40CA-B8A3-3AE0F072D125"
  "F5F9FE57-44D1-4FEF-9F94-AB00B8F173E6"
  "4493BB98-F974-44FF-8F58-2E220E349980"
  "E5BF06C3-B22A-4B35-BAEA-AC4B092F84E5"
  "B071FC02-E88B-4C60-9D7A-F22B02948E60"
  "8BB01948-6BEC-4D1D-A1FE-2BF2DC7E2AC8"
  "D76EF71C-BE42-4AE1-8F41-4067B487CA23"
  "0A429FBF-C5B8-4B6A-8B51-4DBB6CCF1E5A"
  "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 ('9ED7C2DC-48A9-4711-A575-465A1AD4DDB9', '25029E33-5CEF-4800-A14F-87DC0FE94501', '8AF68491-2A72-40CA-B8A3-3AE0F072D125', 'F5F9FE57-44D1-4FEF-9F94-AB00B8F173E6', '4493BB98-F974-44FF-8F58-2E220E349980', 'E5BF06C3-B22A-4B35-BAEA-AC4B092F84E5', 'B071FC02-E88B-4C60-9D7A-F22B02948E60', '8BB01948-6BEC-4D1D-A1FE-2BF2DC7E2AC8', 'D76EF71C-BE42-4AE1-8F41-4067B487CA23', '0A429FBF-C5B8-4B6A-8B51-4DBB6CCF1E5A') 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

[
  "9ED7C2DC-48A9-4711-A575-465A1AD4DDB9"
  "25029E33-5CEF-4800-A14F-87DC0FE94501"
  "8AF68491-2A72-40CA-B8A3-3AE0F072D125"
  "F5F9FE57-44D1-4FEF-9F94-AB00B8F173E6"
  "4493BB98-F974-44FF-8F58-2E220E349980"
  "E5BF06C3-B22A-4B35-BAEA-AC4B092F84E5"
  "B071FC02-E88B-4C60-9D7A-F22B02948E60"
  "8BB01948-6BEC-4D1D-A1FE-2BF2DC7E2AC8"
  "D76EF71C-BE42-4AE1-8F41-4067B487CA23"
  "0A429FBF-C5B8-4B6A-8B51-4DBB6CCF1E5A"
]

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 ('9ED7C2DC-48A9-4711-A575-465A1AD4DDB9', '25029E33-5CEF-4800-A14F-87DC0FE94501', '8AF68491-2A72-40CA-B8A3-3AE0F072D125', 'F5F9FE57-44D1-4FEF-9F94-AB00B8F173E6', '4493BB98-F974-44FF-8F58-2E220E349980', 'E5BF06C3-B22A-4B35-BAEA-AC4B092F84E5', 'B071FC02-E88B-4C60-9D7A-F22B02948E60', '8BB01948-6BEC-4D1D-A1FE-2BF2DC7E2AC8', 'D76EF71C-BE42-4AE1-8F41-4067B487CA23', '0A429FBF-C5B8-4B6A-8B51-4DBB6CCF1E5A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "9ed7c2dc-48a9-4711-a575-465a1ad4ddb9"
  "25029e33-5cef-4800-a14f-87dc0fe94501"
  "8af68491-2a72-40ca-b8a3-3ae0f072d125"
  "f5f9fe57-44d1-4fef-9f94-ab00b8f173e6"
  "4493bb98-f974-44ff-8f58-2e220e349980"
  "e5bf06c3-b22a-4b35-baea-ac4b092f84e5"
  "b071fc02-e88b-4c60-9d7a-f22b02948e60"
  "8bb01948-6bec-4d1d-a1fe-2bf2dc7e2ac8"
  "d76ef71c-be42-4ae1-8f41-4067b487ca23"
  "0a429fbf-c5b8-4b6a-8b51-4dbb6ccf1e5a"
]

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 ('9ed7c2dc-48a9-4711-a575-465a1ad4ddb9','25029e33-5cef-4800-a14f-87dc0fe94501','8af68491-2a72-40ca-b8a3-3ae0f072d125','f5f9fe57-44d1-4fef-9f94-ab00b8f173e6','4493bb98-f974-44ff-8f58-2e220e349980','e5bf06c3-b22a-4b35-baea-ac4b092f84e5','b071fc02-e88b-4c60-9d7a-f22b02948e60','8bb01948-6bec-4d1d-a1fe-2bf2dc7e2ac8','d76ef71c-be42-4ae1-8f41-4067b487ca23','0a429fbf-c5b8-4b6a-8b51-4dbb6ccf1e5a');