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

[
  "09D78225-2AFF-48CC-893C-CB2493FC6E63"
  "9C1983E5-C017-4A6B-9F47-8E672727F56A"
  "0B14AD60-1CE0-48A2-8922-22C4ECE83F35"
  "044FCE7F-197D-4C36-9367-B5C8E678D0DD"
  "16D169B2-5CAD-4333-8346-90A1264C8AAD"
  "B986F44B-868D-4996-AB6F-475212211251"
  "2FBACBCF-9678-44E9-8910-24E8BE4F8585"
  "E4497A02-58E6-49F1-8A76-D9A04F4604B5"
  "F0B3E568-2C6E-44E8-AA11-26AA9DECE4AA"
  "C66523DD-4296-4CCA-8A79-98B5B5D09637"
  "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 ('09D78225-2AFF-48CC-893C-CB2493FC6E63', '9C1983E5-C017-4A6B-9F47-8E672727F56A', '0B14AD60-1CE0-48A2-8922-22C4ECE83F35', '044FCE7F-197D-4C36-9367-B5C8E678D0DD', '16D169B2-5CAD-4333-8346-90A1264C8AAD', 'B986F44B-868D-4996-AB6F-475212211251', '2FBACBCF-9678-44E9-8910-24E8BE4F8585', 'E4497A02-58E6-49F1-8A76-D9A04F4604B5', 'F0B3E568-2C6E-44E8-AA11-26AA9DECE4AA', 'C66523DD-4296-4CCA-8A79-98B5B5D09637') 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

[
  "09D78225-2AFF-48CC-893C-CB2493FC6E63"
  "9C1983E5-C017-4A6B-9F47-8E672727F56A"
  "0B14AD60-1CE0-48A2-8922-22C4ECE83F35"
  "044FCE7F-197D-4C36-9367-B5C8E678D0DD"
  "16D169B2-5CAD-4333-8346-90A1264C8AAD"
  "B986F44B-868D-4996-AB6F-475212211251"
  "2FBACBCF-9678-44E9-8910-24E8BE4F8585"
  "E4497A02-58E6-49F1-8A76-D9A04F4604B5"
  "F0B3E568-2C6E-44E8-AA11-26AA9DECE4AA"
  "C66523DD-4296-4CCA-8A79-98B5B5D09637"
]

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 ('09D78225-2AFF-48CC-893C-CB2493FC6E63', '9C1983E5-C017-4A6B-9F47-8E672727F56A', '0B14AD60-1CE0-48A2-8922-22C4ECE83F35', '044FCE7F-197D-4C36-9367-B5C8E678D0DD', '16D169B2-5CAD-4333-8346-90A1264C8AAD', 'B986F44B-868D-4996-AB6F-475212211251', '2FBACBCF-9678-44E9-8910-24E8BE4F8585', 'E4497A02-58E6-49F1-8A76-D9A04F4604B5', 'F0B3E568-2C6E-44E8-AA11-26AA9DECE4AA', 'C66523DD-4296-4CCA-8A79-98B5B5D09637') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "09d78225-2aff-48cc-893c-cb2493fc6e63"
  "9c1983e5-c017-4a6b-9f47-8e672727f56a"
  "0b14ad60-1ce0-48a2-8922-22c4ece83f35"
  "044fce7f-197d-4c36-9367-b5c8e678d0dd"
  "16d169b2-5cad-4333-8346-90a1264c8aad"
  "b986f44b-868d-4996-ab6f-475212211251"
  "2fbacbcf-9678-44e9-8910-24e8be4f8585"
  "e4497a02-58e6-49f1-8a76-d9a04f4604b5"
  "f0b3e568-2c6e-44e8-aa11-26aa9dece4aa"
  "c66523dd-4296-4cca-8a79-98b5b5d09637"
]

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 ('09d78225-2aff-48cc-893c-cb2493fc6e63','9c1983e5-c017-4a6b-9f47-8e672727f56a','0b14ad60-1ce0-48a2-8922-22c4ece83f35','044fce7f-197d-4c36-9367-b5c8e678d0dd','16d169b2-5cad-4333-8346-90a1264c8aad','b986f44b-868d-4996-ab6f-475212211251','2fbacbcf-9678-44e9-8910-24e8be4f8585','e4497a02-58e6-49f1-8a76-d9a04f4604b5','f0b3e568-2c6e-44e8-aa11-26aa9dece4aa','c66523dd-4296-4cca-8a79-98b5b5d09637');