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

[
  "E660C71B-CAEB-4807-AD46-FD43ACE64F48"
  "C1F1A640-A6E6-4E3F-8B66-1C859545A5F8"
  "CAC02A4E-32BC-4D0A-81D8-95737F8B0F1F"
  "F7E11BCE-0B72-4E4C-B1B3-FCD5154CDAF8"
  "FF47F3E3-001B-4B35-8DCE-B9209516C284"
  "FF71310C-D02E-489F-A484-0D72C2654CF6"
  "83287E3E-0241-4C98-A9B7-438800C03ADD"
  "3CA827FF-039F-4600-9515-AE065EC51831"
  "2905A10E-E877-48D2-ADAD-00C3C4F95ED1"
  "5909FCC7-F31C-4074-8898-12A4455468CA"
  "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 ('E660C71B-CAEB-4807-AD46-FD43ACE64F48', 'C1F1A640-A6E6-4E3F-8B66-1C859545A5F8', 'CAC02A4E-32BC-4D0A-81D8-95737F8B0F1F', 'F7E11BCE-0B72-4E4C-B1B3-FCD5154CDAF8', 'FF47F3E3-001B-4B35-8DCE-B9209516C284', 'FF71310C-D02E-489F-A484-0D72C2654CF6', '83287E3E-0241-4C98-A9B7-438800C03ADD', '3CA827FF-039F-4600-9515-AE065EC51831', '2905A10E-E877-48D2-ADAD-00C3C4F95ED1', '5909FCC7-F31C-4074-8898-12A4455468CA') 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

[
  "E660C71B-CAEB-4807-AD46-FD43ACE64F48"
  "C1F1A640-A6E6-4E3F-8B66-1C859545A5F8"
  "CAC02A4E-32BC-4D0A-81D8-95737F8B0F1F"
  "F7E11BCE-0B72-4E4C-B1B3-FCD5154CDAF8"
  "FF47F3E3-001B-4B35-8DCE-B9209516C284"
  "FF71310C-D02E-489F-A484-0D72C2654CF6"
  "83287E3E-0241-4C98-A9B7-438800C03ADD"
  "3CA827FF-039F-4600-9515-AE065EC51831"
  "2905A10E-E877-48D2-ADAD-00C3C4F95ED1"
  "5909FCC7-F31C-4074-8898-12A4455468CA"
]

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 ('E660C71B-CAEB-4807-AD46-FD43ACE64F48', 'C1F1A640-A6E6-4E3F-8B66-1C859545A5F8', 'CAC02A4E-32BC-4D0A-81D8-95737F8B0F1F', 'F7E11BCE-0B72-4E4C-B1B3-FCD5154CDAF8', 'FF47F3E3-001B-4B35-8DCE-B9209516C284', 'FF71310C-D02E-489F-A484-0D72C2654CF6', '83287E3E-0241-4C98-A9B7-438800C03ADD', '3CA827FF-039F-4600-9515-AE065EC51831', '2905A10E-E877-48D2-ADAD-00C3C4F95ED1', '5909FCC7-F31C-4074-8898-12A4455468CA') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "e660c71b-caeb-4807-ad46-fd43ace64f48"
  "c1f1a640-a6e6-4e3f-8b66-1c859545a5f8"
  "cac02a4e-32bc-4d0a-81d8-95737f8b0f1f"
  "f7e11bce-0b72-4e4c-b1b3-fcd5154cdaf8"
  "ff47f3e3-001b-4b35-8dce-b9209516c284"
  "ff71310c-d02e-489f-a484-0d72c2654cf6"
  "83287e3e-0241-4c98-a9b7-438800c03add"
  "3ca827ff-039f-4600-9515-ae065ec51831"
  "2905a10e-e877-48d2-adad-00c3c4f95ed1"
  "5909fcc7-f31c-4074-8898-12a4455468ca"
]

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 ('e660c71b-caeb-4807-ad46-fd43ace64f48','c1f1a640-a6e6-4e3f-8b66-1c859545a5f8','cac02a4e-32bc-4d0a-81d8-95737f8b0f1f','f7e11bce-0b72-4e4c-b1b3-fcd5154cdaf8','ff47f3e3-001b-4b35-8dce-b9209516c284','ff71310c-d02e-489f-a484-0d72c2654cf6','83287e3e-0241-4c98-a9b7-438800c03add','3ca827ff-039f-4600-9515-ae065ec51831','2905a10e-e877-48d2-adad-00c3c4f95ed1','5909fcc7-f31c-4074-8898-12a4455468ca');