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

[
  "D9DFAA8E-A7F8-4519-A274-7E668D4094E8"
  "BBB8EB85-4C05-4464-A273-F1370F747575"
  "AB4D0EE4-4256-48C8-BB81-9E77F2E5977D"
  "2C7EFC04-9AEB-4CEF-A8C2-7B15F96570D2"
  "6B811D5D-0C7D-4FFE-9DA1-CAEEBA99060B"
  "70432B9C-9CD5-4811-B1D6-58688CD21AD1"
  "C5005244-3880-44C4-9D2C-BAF319FAB379"
  "C580A9BF-BAF5-4D73-8F61-861A45772462"
  "430799A5-353E-4585-BC10-D2C8ABE0C7FD"
  "28769C69-06F8-4CE9-AADC-A014283B5584"
  "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 ('D9DFAA8E-A7F8-4519-A274-7E668D4094E8', 'BBB8EB85-4C05-4464-A273-F1370F747575', 'AB4D0EE4-4256-48C8-BB81-9E77F2E5977D', '2C7EFC04-9AEB-4CEF-A8C2-7B15F96570D2', '6B811D5D-0C7D-4FFE-9DA1-CAEEBA99060B', '70432B9C-9CD5-4811-B1D6-58688CD21AD1', 'C5005244-3880-44C4-9D2C-BAF319FAB379', 'C580A9BF-BAF5-4D73-8F61-861A45772462', '430799A5-353E-4585-BC10-D2C8ABE0C7FD', '28769C69-06F8-4CE9-AADC-A014283B5584') 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

[
  "D9DFAA8E-A7F8-4519-A274-7E668D4094E8"
  "BBB8EB85-4C05-4464-A273-F1370F747575"
  "AB4D0EE4-4256-48C8-BB81-9E77F2E5977D"
  "2C7EFC04-9AEB-4CEF-A8C2-7B15F96570D2"
  "6B811D5D-0C7D-4FFE-9DA1-CAEEBA99060B"
  "70432B9C-9CD5-4811-B1D6-58688CD21AD1"
  "C5005244-3880-44C4-9D2C-BAF319FAB379"
  "C580A9BF-BAF5-4D73-8F61-861A45772462"
  "430799A5-353E-4585-BC10-D2C8ABE0C7FD"
  "28769C69-06F8-4CE9-AADC-A014283B5584"
]

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 ('D9DFAA8E-A7F8-4519-A274-7E668D4094E8', 'BBB8EB85-4C05-4464-A273-F1370F747575', 'AB4D0EE4-4256-48C8-BB81-9E77F2E5977D', '2C7EFC04-9AEB-4CEF-A8C2-7B15F96570D2', '6B811D5D-0C7D-4FFE-9DA1-CAEEBA99060B', '70432B9C-9CD5-4811-B1D6-58688CD21AD1', 'C5005244-3880-44C4-9D2C-BAF319FAB379', 'C580A9BF-BAF5-4D73-8F61-861A45772462', '430799A5-353E-4585-BC10-D2C8ABE0C7FD', '28769C69-06F8-4CE9-AADC-A014283B5584') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "d9dfaa8e-a7f8-4519-a274-7e668d4094e8"
  "bbb8eb85-4c05-4464-a273-f1370f747575"
  "ab4d0ee4-4256-48c8-bb81-9e77f2e5977d"
  "2c7efc04-9aeb-4cef-a8c2-7b15f96570d2"
  "6b811d5d-0c7d-4ffe-9da1-caeeba99060b"
  "70432b9c-9cd5-4811-b1d6-58688cd21ad1"
  "c5005244-3880-44c4-9d2c-baf319fab379"
  "c580a9bf-baf5-4d73-8f61-861a45772462"
  "430799a5-353e-4585-bc10-d2c8abe0c7fd"
  "28769c69-06f8-4ce9-aadc-a014283b5584"
]

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 ('d9dfaa8e-a7f8-4519-a274-7e668d4094e8','bbb8eb85-4c05-4464-a273-f1370f747575','ab4d0ee4-4256-48c8-bb81-9e77f2e5977d','2c7efc04-9aeb-4cef-a8c2-7b15f96570d2','6b811d5d-0c7d-4ffe-9da1-caeeba99060b','70432b9c-9cd5-4811-b1d6-58688cd21ad1','c5005244-3880-44c4-9d2c-baf319fab379','c580a9bf-baf5-4d73-8f61-861a45772462','430799a5-353e-4585-bc10-d2c8abe0c7fd','28769c69-06f8-4ce9-aadc-a014283b5584');