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

[
  "96F0B573-FE60-4B74-B488-F6D91F4366C7"
  "6C9380BE-3BF9-4702-B957-85934D793891"
  "8CEA20F2-52DA-494F-8614-E6260C61ABE9"
  "E079D0E9-3D9C-4CB8-9D87-FE4588CD1312"
  "444AFFDC-1EED-4171-A163-CB5B02580149"
  "DA027DAC-D0ED-4FE4-9119-2D34CC5543DF"
  "94E2AEE3-A2EC-43C4-B171-511CA171225C"
  "812BBC1E-7B74-402F-B71D-B3516D6F0361"
  "6C669DA0-7742-4EB2-A389-9D42BDC9AB09"
  "26A16590-39A4-4DD7-AD93-FD95D8D6278C"
  "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 ('96F0B573-FE60-4B74-B488-F6D91F4366C7', '6C9380BE-3BF9-4702-B957-85934D793891', '8CEA20F2-52DA-494F-8614-E6260C61ABE9', 'E079D0E9-3D9C-4CB8-9D87-FE4588CD1312', '444AFFDC-1EED-4171-A163-CB5B02580149', 'DA027DAC-D0ED-4FE4-9119-2D34CC5543DF', '94E2AEE3-A2EC-43C4-B171-511CA171225C', '812BBC1E-7B74-402F-B71D-B3516D6F0361', '6C669DA0-7742-4EB2-A389-9D42BDC9AB09', '26A16590-39A4-4DD7-AD93-FD95D8D6278C') 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

[
  "96F0B573-FE60-4B74-B488-F6D91F4366C7"
  "6C9380BE-3BF9-4702-B957-85934D793891"
  "8CEA20F2-52DA-494F-8614-E6260C61ABE9"
  "E079D0E9-3D9C-4CB8-9D87-FE4588CD1312"
  "444AFFDC-1EED-4171-A163-CB5B02580149"
  "DA027DAC-D0ED-4FE4-9119-2D34CC5543DF"
  "94E2AEE3-A2EC-43C4-B171-511CA171225C"
  "812BBC1E-7B74-402F-B71D-B3516D6F0361"
  "6C669DA0-7742-4EB2-A389-9D42BDC9AB09"
  "26A16590-39A4-4DD7-AD93-FD95D8D6278C"
]

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 ('96F0B573-FE60-4B74-B488-F6D91F4366C7', '6C9380BE-3BF9-4702-B957-85934D793891', '8CEA20F2-52DA-494F-8614-E6260C61ABE9', 'E079D0E9-3D9C-4CB8-9D87-FE4588CD1312', '444AFFDC-1EED-4171-A163-CB5B02580149', 'DA027DAC-D0ED-4FE4-9119-2D34CC5543DF', '94E2AEE3-A2EC-43C4-B171-511CA171225C', '812BBC1E-7B74-402F-B71D-B3516D6F0361', '6C669DA0-7742-4EB2-A389-9D42BDC9AB09', '26A16590-39A4-4DD7-AD93-FD95D8D6278C') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "96f0b573-fe60-4b74-b488-f6d91f4366c7"
  "6c9380be-3bf9-4702-b957-85934d793891"
  "8cea20f2-52da-494f-8614-e6260c61abe9"
  "e079d0e9-3d9c-4cb8-9d87-fe4588cd1312"
  "444affdc-1eed-4171-a163-cb5b02580149"
  "da027dac-d0ed-4fe4-9119-2d34cc5543df"
  "94e2aee3-a2ec-43c4-b171-511ca171225c"
  "812bbc1e-7b74-402f-b71d-b3516d6f0361"
  "6c669da0-7742-4eb2-a389-9d42bdc9ab09"
  "26a16590-39a4-4dd7-ad93-fd95d8d6278c"
]

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 ('96f0b573-fe60-4b74-b488-f6d91f4366c7','6c9380be-3bf9-4702-b957-85934d793891','8cea20f2-52da-494f-8614-e6260c61abe9','e079d0e9-3d9c-4cb8-9d87-fe4588cd1312','444affdc-1eed-4171-a163-cb5b02580149','da027dac-d0ed-4fe4-9119-2d34cc5543df','94e2aee3-a2ec-43c4-b171-511ca171225c','812bbc1e-7b74-402f-b71d-b3516d6f0361','6c669da0-7742-4eb2-a389-9d42bdc9ab09','26a16590-39a4-4dd7-ad93-fd95d8d6278c');