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

[
  "452DA982-2799-4C9A-A3A2-E4458170B0A9"
  "E410E5D9-BCAB-42AD-9C5A-27A1F630FE65"
  "6C6DFC80-FEED-47D6-B1C3-F4C7321B1479"
  "4D62D934-DCC9-4888-B408-0EEF84C4359E"
  "A24AB1F7-3A21-4425-8B7A-E7718026F125"
  "FC5C908F-BEC0-4590-A0E1-97B8AADACE05"
  "FE71C0E5-0ED0-43D0-8F13-8E5F2862649A"
  "CC5602D5-9234-4776-BE6E-BB9260F87BDA"
  "56BEB127-A822-4878-B2D0-BC94CB0610C3"
  "DC09493F-9BA3-4D06-A911-3CDD32939143"
  "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 ('452DA982-2799-4C9A-A3A2-E4458170B0A9', 'E410E5D9-BCAB-42AD-9C5A-27A1F630FE65', '6C6DFC80-FEED-47D6-B1C3-F4C7321B1479', '4D62D934-DCC9-4888-B408-0EEF84C4359E', 'A24AB1F7-3A21-4425-8B7A-E7718026F125', 'FC5C908F-BEC0-4590-A0E1-97B8AADACE05', 'FE71C0E5-0ED0-43D0-8F13-8E5F2862649A', 'CC5602D5-9234-4776-BE6E-BB9260F87BDA', '56BEB127-A822-4878-B2D0-BC94CB0610C3', 'DC09493F-9BA3-4D06-A911-3CDD32939143') 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

[
  "452DA982-2799-4C9A-A3A2-E4458170B0A9"
  "E410E5D9-BCAB-42AD-9C5A-27A1F630FE65"
  "6C6DFC80-FEED-47D6-B1C3-F4C7321B1479"
  "4D62D934-DCC9-4888-B408-0EEF84C4359E"
  "A24AB1F7-3A21-4425-8B7A-E7718026F125"
  "FC5C908F-BEC0-4590-A0E1-97B8AADACE05"
  "FE71C0E5-0ED0-43D0-8F13-8E5F2862649A"
  "CC5602D5-9234-4776-BE6E-BB9260F87BDA"
  "56BEB127-A822-4878-B2D0-BC94CB0610C3"
  "DC09493F-9BA3-4D06-A911-3CDD32939143"
]

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 ('452DA982-2799-4C9A-A3A2-E4458170B0A9', 'E410E5D9-BCAB-42AD-9C5A-27A1F630FE65', '6C6DFC80-FEED-47D6-B1C3-F4C7321B1479', '4D62D934-DCC9-4888-B408-0EEF84C4359E', 'A24AB1F7-3A21-4425-8B7A-E7718026F125', 'FC5C908F-BEC0-4590-A0E1-97B8AADACE05', 'FE71C0E5-0ED0-43D0-8F13-8E5F2862649A', 'CC5602D5-9234-4776-BE6E-BB9260F87BDA', '56BEB127-A822-4878-B2D0-BC94CB0610C3', 'DC09493F-9BA3-4D06-A911-3CDD32939143') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "452da982-2799-4c9a-a3a2-e4458170b0a9"
  "e410e5d9-bcab-42ad-9c5a-27a1f630fe65"
  "6c6dfc80-feed-47d6-b1c3-f4c7321b1479"
  "4d62d934-dcc9-4888-b408-0eef84c4359e"
  "a24ab1f7-3a21-4425-8b7a-e7718026f125"
  "fc5c908f-bec0-4590-a0e1-97b8aadace05"
  "fe71c0e5-0ed0-43d0-8f13-8e5f2862649a"
  "cc5602d5-9234-4776-be6e-bb9260f87bda"
  "56beb127-a822-4878-b2d0-bc94cb0610c3"
  "dc09493f-9ba3-4d06-a911-3cdd32939143"
]

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 ('452da982-2799-4c9a-a3a2-e4458170b0a9','e410e5d9-bcab-42ad-9c5a-27a1f630fe65','6c6dfc80-feed-47d6-b1c3-f4c7321b1479','4d62d934-dcc9-4888-b408-0eef84c4359e','a24ab1f7-3a21-4425-8b7a-e7718026f125','fc5c908f-bec0-4590-a0e1-97b8aadace05','fe71c0e5-0ed0-43d0-8f13-8e5f2862649a','cc5602d5-9234-4776-be6e-bb9260f87bda','56beb127-a822-4878-b2d0-bc94cb0610c3','dc09493f-9ba3-4d06-a911-3cdd32939143');