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

[
  "DF53447F-07E9-44F5-B0C9-F4D8C873E32A"
  "404B389F-FD9B-4F3E-83A7-47E6436F4B15"
  "A16E635F-1EBC-44F8-9834-DD2DF312C39E"
  "4657D7BE-2CFB-4B58-9EF4-15A66A503FD3"
  "FAA76773-7DB1-4743-85C4-33DEACA05A03"
  "93D00E3C-B13B-4949-9539-D8FA42C2077B"
  "64734E23-1746-433A-9923-EB7E430523AF"
  "C40B20DC-B5C1-409D-B6DD-11033C234DCB"
  "40665B43-97E1-484E-B422-BC2D5505E797"
  "2D3DC585-B981-42C6-AB46-2D937CE7C95A"
  "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 ('DF53447F-07E9-44F5-B0C9-F4D8C873E32A', '404B389F-FD9B-4F3E-83A7-47E6436F4B15', 'A16E635F-1EBC-44F8-9834-DD2DF312C39E', '4657D7BE-2CFB-4B58-9EF4-15A66A503FD3', 'FAA76773-7DB1-4743-85C4-33DEACA05A03', '93D00E3C-B13B-4949-9539-D8FA42C2077B', '64734E23-1746-433A-9923-EB7E430523AF', 'C40B20DC-B5C1-409D-B6DD-11033C234DCB', '40665B43-97E1-484E-B422-BC2D5505E797', '2D3DC585-B981-42C6-AB46-2D937CE7C95A') 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

[
  "DF53447F-07E9-44F5-B0C9-F4D8C873E32A"
  "404B389F-FD9B-4F3E-83A7-47E6436F4B15"
  "A16E635F-1EBC-44F8-9834-DD2DF312C39E"
  "4657D7BE-2CFB-4B58-9EF4-15A66A503FD3"
  "FAA76773-7DB1-4743-85C4-33DEACA05A03"
  "93D00E3C-B13B-4949-9539-D8FA42C2077B"
  "64734E23-1746-433A-9923-EB7E430523AF"
  "C40B20DC-B5C1-409D-B6DD-11033C234DCB"
  "40665B43-97E1-484E-B422-BC2D5505E797"
  "2D3DC585-B981-42C6-AB46-2D937CE7C95A"
]

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 ('DF53447F-07E9-44F5-B0C9-F4D8C873E32A', '404B389F-FD9B-4F3E-83A7-47E6436F4B15', 'A16E635F-1EBC-44F8-9834-DD2DF312C39E', '4657D7BE-2CFB-4B58-9EF4-15A66A503FD3', 'FAA76773-7DB1-4743-85C4-33DEACA05A03', '93D00E3C-B13B-4949-9539-D8FA42C2077B', '64734E23-1746-433A-9923-EB7E430523AF', 'C40B20DC-B5C1-409D-B6DD-11033C234DCB', '40665B43-97E1-484E-B422-BC2D5505E797', '2D3DC585-B981-42C6-AB46-2D937CE7C95A') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "df53447f-07e9-44f5-b0c9-f4d8c873e32a"
  "404b389f-fd9b-4f3e-83a7-47e6436f4b15"
  "a16e635f-1ebc-44f8-9834-dd2df312c39e"
  "4657d7be-2cfb-4b58-9ef4-15a66a503fd3"
  "faa76773-7db1-4743-85c4-33deaca05a03"
  "93d00e3c-b13b-4949-9539-d8fa42c2077b"
  "64734e23-1746-433a-9923-eb7e430523af"
  "c40b20dc-b5c1-409d-b6dd-11033c234dcb"
  "40665b43-97e1-484e-b422-bc2d5505e797"
  "2d3dc585-b981-42c6-ab46-2d937ce7c95a"
]

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 ('df53447f-07e9-44f5-b0c9-f4d8c873e32a','404b389f-fd9b-4f3e-83a7-47e6436f4b15','a16e635f-1ebc-44f8-9834-dd2df312c39e','4657d7be-2cfb-4b58-9ef4-15a66a503fd3','faa76773-7db1-4743-85c4-33deaca05a03','93d00e3c-b13b-4949-9539-d8fa42c2077b','64734e23-1746-433a-9923-eb7e430523af','c40b20dc-b5c1-409d-b6dd-11033c234dcb','40665b43-97e1-484e-b422-bc2d5505e797','2d3dc585-b981-42c6-ab46-2d937ce7c95a');