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

[
  "AAC98053-C6DE-44B2-B3DC-5CE42BD0A7DE"
  "BD8C9C5A-7800-4085-88DC-AE23F87666F6"
  "9002F58C-4331-4309-B9F5-065344E2C1F5"
  "C1C9AFD7-248E-4B22-B4F5-DC3952EBC734"
  "C515FDB4-BD0D-4A25-A252-6322066DF9E8"
  "FBBEAF90-91FE-45FD-805E-A612884A696C"
  "E0D92765-038A-4DE6-A8D7-8E684479E0F7"
  "6D3E1871-D1FA-4F8B-A868-7656B803EA7D"
  "F15E7535-9799-4227-97E8-51A65C36FB6A"
  "9B2F5EE8-FC53-47ED-B1B3-CB207364603F"
  "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 ('AAC98053-C6DE-44B2-B3DC-5CE42BD0A7DE', 'BD8C9C5A-7800-4085-88DC-AE23F87666F6', '9002F58C-4331-4309-B9F5-065344E2C1F5', 'C1C9AFD7-248E-4B22-B4F5-DC3952EBC734', 'C515FDB4-BD0D-4A25-A252-6322066DF9E8', 'FBBEAF90-91FE-45FD-805E-A612884A696C', 'E0D92765-038A-4DE6-A8D7-8E684479E0F7', '6D3E1871-D1FA-4F8B-A868-7656B803EA7D', 'F15E7535-9799-4227-97E8-51A65C36FB6A', '9B2F5EE8-FC53-47ED-B1B3-CB207364603F') 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

[
  "AAC98053-C6DE-44B2-B3DC-5CE42BD0A7DE"
  "BD8C9C5A-7800-4085-88DC-AE23F87666F6"
  "9002F58C-4331-4309-B9F5-065344E2C1F5"
  "C1C9AFD7-248E-4B22-B4F5-DC3952EBC734"
  "C515FDB4-BD0D-4A25-A252-6322066DF9E8"
  "FBBEAF90-91FE-45FD-805E-A612884A696C"
  "E0D92765-038A-4DE6-A8D7-8E684479E0F7"
  "6D3E1871-D1FA-4F8B-A868-7656B803EA7D"
  "F15E7535-9799-4227-97E8-51A65C36FB6A"
  "9B2F5EE8-FC53-47ED-B1B3-CB207364603F"
]

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 ('AAC98053-C6DE-44B2-B3DC-5CE42BD0A7DE', 'BD8C9C5A-7800-4085-88DC-AE23F87666F6', '9002F58C-4331-4309-B9F5-065344E2C1F5', 'C1C9AFD7-248E-4B22-B4F5-DC3952EBC734', 'C515FDB4-BD0D-4A25-A252-6322066DF9E8', 'FBBEAF90-91FE-45FD-805E-A612884A696C', 'E0D92765-038A-4DE6-A8D7-8E684479E0F7', '6D3E1871-D1FA-4F8B-A868-7656B803EA7D', 'F15E7535-9799-4227-97E8-51A65C36FB6A', '9B2F5EE8-FC53-47ED-B1B3-CB207364603F') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "aac98053-c6de-44b2-b3dc-5ce42bd0a7de"
  "bd8c9c5a-7800-4085-88dc-ae23f87666f6"
  "9002f58c-4331-4309-b9f5-065344e2c1f5"
  "c1c9afd7-248e-4b22-b4f5-dc3952ebc734"
  "c515fdb4-bd0d-4a25-a252-6322066df9e8"
  "fbbeaf90-91fe-45fd-805e-a612884a696c"
  "e0d92765-038a-4de6-a8d7-8e684479e0f7"
  "6d3e1871-d1fa-4f8b-a868-7656b803ea7d"
  "f15e7535-9799-4227-97e8-51a65c36fb6a"
  "9b2f5ee8-fc53-47ed-b1b3-cb207364603f"
]

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 ('aac98053-c6de-44b2-b3dc-5ce42bd0a7de','bd8c9c5a-7800-4085-88dc-ae23f87666f6','9002f58c-4331-4309-b9f5-065344e2c1f5','c1c9afd7-248e-4b22-b4f5-dc3952ebc734','c515fdb4-bd0d-4a25-a252-6322066df9e8','fbbeaf90-91fe-45fd-805e-a612884a696c','e0d92765-038a-4de6-a8d7-8e684479e0f7','6d3e1871-d1fa-4f8b-a868-7656b803ea7d','f15e7535-9799-4227-97e8-51a65c36fb6a','9b2f5ee8-fc53-47ed-b1b3-cb207364603f');