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

[
  "242C3917-166D-4D7F-9D91-D2B393BBE28B"
  "A6A16522-DAC1-48A0-B2C2-2A096E07C587"
  "383A15DC-A1DD-41E0-B548-DEAEFACF098A"
  "67A35CDE-047E-4A25-85BD-F3F89E48A6AE"
  "554B2277-5025-4F2B-B376-DBCFC5833E3B"
  "9B7EB004-3A7A-41F6-99A1-D10209EDDD27"
  "1315496B-2D1D-4279-B525-DAAD76A1E704"
  "F07A596A-9010-4D08-87BB-F567B55C1223"
  "7B55D55E-1D02-4FDC-85FF-74CEBF0F3B29"
  "1E30EFB3-C0F8-4E9B-B4BF-028DF1DBCFE6"
  "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 ('242C3917-166D-4D7F-9D91-D2B393BBE28B', 'A6A16522-DAC1-48A0-B2C2-2A096E07C587', '383A15DC-A1DD-41E0-B548-DEAEFACF098A', '67A35CDE-047E-4A25-85BD-F3F89E48A6AE', '554B2277-5025-4F2B-B376-DBCFC5833E3B', '9B7EB004-3A7A-41F6-99A1-D10209EDDD27', '1315496B-2D1D-4279-B525-DAAD76A1E704', 'F07A596A-9010-4D08-87BB-F567B55C1223', '7B55D55E-1D02-4FDC-85FF-74CEBF0F3B29', '1E30EFB3-C0F8-4E9B-B4BF-028DF1DBCFE6') 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

[
  "242C3917-166D-4D7F-9D91-D2B393BBE28B"
  "A6A16522-DAC1-48A0-B2C2-2A096E07C587"
  "383A15DC-A1DD-41E0-B548-DEAEFACF098A"
  "67A35CDE-047E-4A25-85BD-F3F89E48A6AE"
  "554B2277-5025-4F2B-B376-DBCFC5833E3B"
  "9B7EB004-3A7A-41F6-99A1-D10209EDDD27"
  "1315496B-2D1D-4279-B525-DAAD76A1E704"
  "F07A596A-9010-4D08-87BB-F567B55C1223"
  "7B55D55E-1D02-4FDC-85FF-74CEBF0F3B29"
  "1E30EFB3-C0F8-4E9B-B4BF-028DF1DBCFE6"
]

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 ('242C3917-166D-4D7F-9D91-D2B393BBE28B', 'A6A16522-DAC1-48A0-B2C2-2A096E07C587', '383A15DC-A1DD-41E0-B548-DEAEFACF098A', '67A35CDE-047E-4A25-85BD-F3F89E48A6AE', '554B2277-5025-4F2B-B376-DBCFC5833E3B', '9B7EB004-3A7A-41F6-99A1-D10209EDDD27', '1315496B-2D1D-4279-B525-DAAD76A1E704', 'F07A596A-9010-4D08-87BB-F567B55C1223', '7B55D55E-1D02-4FDC-85FF-74CEBF0F3B29', '1E30EFB3-C0F8-4E9B-B4BF-028DF1DBCFE6') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "242c3917-166d-4d7f-9d91-d2b393bbe28b"
  "a6a16522-dac1-48a0-b2c2-2a096e07c587"
  "383a15dc-a1dd-41e0-b548-deaefacf098a"
  "67a35cde-047e-4a25-85bd-f3f89e48a6ae"
  "554b2277-5025-4f2b-b376-dbcfc5833e3b"
  "9b7eb004-3a7a-41f6-99a1-d10209eddd27"
  "1315496b-2d1d-4279-b525-daad76a1e704"
  "f07a596a-9010-4d08-87bb-f567b55c1223"
  "7b55d55e-1d02-4fdc-85ff-74cebf0f3b29"
  "1e30efb3-c0f8-4e9b-b4bf-028df1dbcfe6"
]

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 ('242c3917-166d-4d7f-9d91-d2b393bbe28b','a6a16522-dac1-48a0-b2c2-2a096e07c587','383a15dc-a1dd-41e0-b548-deaefacf098a','67a35cde-047e-4a25-85bd-f3f89e48a6ae','554b2277-5025-4f2b-b376-dbcfc5833e3b','9b7eb004-3a7a-41f6-99a1-d10209eddd27','1315496b-2d1d-4279-b525-daad76a1e704','f07a596a-9010-4d08-87bb-f567b55c1223','7b55d55e-1d02-4fdc-85ff-74cebf0f3b29','1e30efb3-c0f8-4e9b-b4bf-028df1dbcfe6');