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

[
  "B8EC8168-3948-4E73-ABE1-820DBF0DF51C"
  "7EB67A54-7D34-4046-AC68-33CCFE019916"
  "2E4CDDB5-E946-4C76-A9DA-A518BD8A89B5"
  "651BDD60-7902-47AC-8D6B-C1F9077407F7"
  "5A9E056B-F569-4D28-913A-8CA6A7684EC0"
  "72B28679-3AF6-4D41-94CC-F6780DBB4796"
  "1254ACED-A72D-4050-836B-B9BCCC8D4EA4"
  "8537F1A1-1FC8-4284-A6A2-42B3CF513F0E"
  "1164BE30-9B63-4E01-BDB0-29F57FE969DD"
  "79C86E1B-36F8-49EA-9CB8-09082A287C76"
  "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 ('B8EC8168-3948-4E73-ABE1-820DBF0DF51C', '7EB67A54-7D34-4046-AC68-33CCFE019916', '2E4CDDB5-E946-4C76-A9DA-A518BD8A89B5', '651BDD60-7902-47AC-8D6B-C1F9077407F7', '5A9E056B-F569-4D28-913A-8CA6A7684EC0', '72B28679-3AF6-4D41-94CC-F6780DBB4796', '1254ACED-A72D-4050-836B-B9BCCC8D4EA4', '8537F1A1-1FC8-4284-A6A2-42B3CF513F0E', '1164BE30-9B63-4E01-BDB0-29F57FE969DD', '79C86E1B-36F8-49EA-9CB8-09082A287C76') 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

[
  "B8EC8168-3948-4E73-ABE1-820DBF0DF51C"
  "7EB67A54-7D34-4046-AC68-33CCFE019916"
  "2E4CDDB5-E946-4C76-A9DA-A518BD8A89B5"
  "651BDD60-7902-47AC-8D6B-C1F9077407F7"
  "5A9E056B-F569-4D28-913A-8CA6A7684EC0"
  "72B28679-3AF6-4D41-94CC-F6780DBB4796"
  "1254ACED-A72D-4050-836B-B9BCCC8D4EA4"
  "8537F1A1-1FC8-4284-A6A2-42B3CF513F0E"
  "1164BE30-9B63-4E01-BDB0-29F57FE969DD"
  "79C86E1B-36F8-49EA-9CB8-09082A287C76"
]

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 ('B8EC8168-3948-4E73-ABE1-820DBF0DF51C', '7EB67A54-7D34-4046-AC68-33CCFE019916', '2E4CDDB5-E946-4C76-A9DA-A518BD8A89B5', '651BDD60-7902-47AC-8D6B-C1F9077407F7', '5A9E056B-F569-4D28-913A-8CA6A7684EC0', '72B28679-3AF6-4D41-94CC-F6780DBB4796', '1254ACED-A72D-4050-836B-B9BCCC8D4EA4', '8537F1A1-1FC8-4284-A6A2-42B3CF513F0E', '1164BE30-9B63-4E01-BDB0-29F57FE969DD', '79C86E1B-36F8-49EA-9CB8-09082A287C76') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "b8ec8168-3948-4e73-abe1-820dbf0df51c"
  "7eb67a54-7d34-4046-ac68-33ccfe019916"
  "2e4cddb5-e946-4c76-a9da-a518bd8a89b5"
  "651bdd60-7902-47ac-8d6b-c1f9077407f7"
  "5a9e056b-f569-4d28-913a-8ca6a7684ec0"
  "72b28679-3af6-4d41-94cc-f6780dbb4796"
  "1254aced-a72d-4050-836b-b9bccc8d4ea4"
  "8537f1a1-1fc8-4284-a6a2-42b3cf513f0e"
  "1164be30-9b63-4e01-bdb0-29f57fe969dd"
  "79c86e1b-36f8-49ea-9cb8-09082a287c76"
]

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 ('b8ec8168-3948-4e73-abe1-820dbf0df51c','7eb67a54-7d34-4046-ac68-33ccfe019916','2e4cddb5-e946-4c76-a9da-a518bd8a89b5','651bdd60-7902-47ac-8d6b-c1f9077407f7','5a9e056b-f569-4d28-913a-8ca6a7684ec0','72b28679-3af6-4d41-94cc-f6780dbb4796','1254aced-a72d-4050-836b-b9bccc8d4ea4','8537f1a1-1fc8-4284-a6a2-42b3cf513f0e','1164be30-9b63-4e01-bdb0-29f57fe969dd','79c86e1b-36f8-49ea-9cb8-09082a287c76');