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

[
  "5BF44198-6635-4631-8571-769EB6FBEDC6"
  "64D936AE-8F7A-4C0D-88B7-E92D351B41B9"
  "FC793CDF-5F49-467C-9033-056E9705DBC5"
  "FF4F81A7-013C-41B1-AEE5-90D0A1ACDAA8"
  "6BE7891E-4B01-448D-ADDB-E5922A44485A"
  "8BFD7064-8CEC-4678-BB70-77BCCA502F3E"
  "15F749E3-F79E-4BDF-AEAB-972CD796F51C"
  "BBE0585E-63C4-46F5-897F-547832CFF7EB"
  "838CD428-5085-4E03-A41B-1C39636DF300"
  "DDF0066F-8211-4ADF-8C7D-DFF2BAD24B5C"
  "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 ('5BF44198-6635-4631-8571-769EB6FBEDC6', '64D936AE-8F7A-4C0D-88B7-E92D351B41B9', 'FC793CDF-5F49-467C-9033-056E9705DBC5', 'FF4F81A7-013C-41B1-AEE5-90D0A1ACDAA8', '6BE7891E-4B01-448D-ADDB-E5922A44485A', '8BFD7064-8CEC-4678-BB70-77BCCA502F3E', '15F749E3-F79E-4BDF-AEAB-972CD796F51C', 'BBE0585E-63C4-46F5-897F-547832CFF7EB', '838CD428-5085-4E03-A41B-1C39636DF300', 'DDF0066F-8211-4ADF-8C7D-DFF2BAD24B5C') 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

[
  "5BF44198-6635-4631-8571-769EB6FBEDC6"
  "64D936AE-8F7A-4C0D-88B7-E92D351B41B9"
  "FC793CDF-5F49-467C-9033-056E9705DBC5"
  "FF4F81A7-013C-41B1-AEE5-90D0A1ACDAA8"
  "6BE7891E-4B01-448D-ADDB-E5922A44485A"
  "8BFD7064-8CEC-4678-BB70-77BCCA502F3E"
  "15F749E3-F79E-4BDF-AEAB-972CD796F51C"
  "BBE0585E-63C4-46F5-897F-547832CFF7EB"
  "838CD428-5085-4E03-A41B-1C39636DF300"
  "DDF0066F-8211-4ADF-8C7D-DFF2BAD24B5C"
]

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 ('5BF44198-6635-4631-8571-769EB6FBEDC6', '64D936AE-8F7A-4C0D-88B7-E92D351B41B9', 'FC793CDF-5F49-467C-9033-056E9705DBC5', 'FF4F81A7-013C-41B1-AEE5-90D0A1ACDAA8', '6BE7891E-4B01-448D-ADDB-E5922A44485A', '8BFD7064-8CEC-4678-BB70-77BCCA502F3E', '15F749E3-F79E-4BDF-AEAB-972CD796F51C', 'BBE0585E-63C4-46F5-897F-547832CFF7EB', '838CD428-5085-4E03-A41B-1C39636DF300', 'DDF0066F-8211-4ADF-8C7D-DFF2BAD24B5C') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "5bf44198-6635-4631-8571-769eb6fbedc6"
  "64d936ae-8f7a-4c0d-88b7-e92d351b41b9"
  "fc793cdf-5f49-467c-9033-056e9705dbc5"
  "ff4f81a7-013c-41b1-aee5-90d0a1acdaa8"
  "6be7891e-4b01-448d-addb-e5922a44485a"
  "8bfd7064-8cec-4678-bb70-77bcca502f3e"
  "15f749e3-f79e-4bdf-aeab-972cd796f51c"
  "bbe0585e-63c4-46f5-897f-547832cff7eb"
  "838cd428-5085-4e03-a41b-1c39636df300"
  "ddf0066f-8211-4adf-8c7d-dff2bad24b5c"
]

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 ('5bf44198-6635-4631-8571-769eb6fbedc6','64d936ae-8f7a-4c0d-88b7-e92d351b41b9','fc793cdf-5f49-467c-9033-056e9705dbc5','ff4f81a7-013c-41b1-aee5-90d0a1acdaa8','6be7891e-4b01-448d-addb-e5922a44485a','8bfd7064-8cec-4678-bb70-77bcca502f3e','15f749e3-f79e-4bdf-aeab-972cd796f51c','bbe0585e-63c4-46f5-897f-547832cff7eb','838cd428-5085-4e03-a41b-1c39636df300','ddf0066f-8211-4adf-8c7d-dff2bad24b5c');