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

[
  "9935195D-49DA-4BB6-9BA7-1136A6E6FC4C"
  "1258067C-FCF9-43F0-B493-2A95E0269B05"
  "349A6643-9FD4-47B0-BFB8-05AFC84F9245"
  "9118594A-A213-4E9F-9F29-D4C0B08B6A76"
  "E388AAB1-7E33-4FEF-A7D0-A6979AE384F8"
  "F61CA6D6-40FF-4366-8500-409220C896E5"
  "85495AFA-178B-4A53-8FB9-3E0D2A141DB3"
  "65B6EFC0-0CFC-4B6F-BEA0-49533A1299E0"
  "19152FA1-44D3-41C5-AE99-DE2D3208CEB4"
  "49CAD528-3FAD-4D2E-B9DB-88018FEAC1AE"
  "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 ('9935195D-49DA-4BB6-9BA7-1136A6E6FC4C', '1258067C-FCF9-43F0-B493-2A95E0269B05', '349A6643-9FD4-47B0-BFB8-05AFC84F9245', '9118594A-A213-4E9F-9F29-D4C0B08B6A76', 'E388AAB1-7E33-4FEF-A7D0-A6979AE384F8', 'F61CA6D6-40FF-4366-8500-409220C896E5', '85495AFA-178B-4A53-8FB9-3E0D2A141DB3', '65B6EFC0-0CFC-4B6F-BEA0-49533A1299E0', '19152FA1-44D3-41C5-AE99-DE2D3208CEB4', '49CAD528-3FAD-4D2E-B9DB-88018FEAC1AE') 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

[
  "9935195D-49DA-4BB6-9BA7-1136A6E6FC4C"
  "1258067C-FCF9-43F0-B493-2A95E0269B05"
  "349A6643-9FD4-47B0-BFB8-05AFC84F9245"
  "9118594A-A213-4E9F-9F29-D4C0B08B6A76"
  "E388AAB1-7E33-4FEF-A7D0-A6979AE384F8"
  "F61CA6D6-40FF-4366-8500-409220C896E5"
  "85495AFA-178B-4A53-8FB9-3E0D2A141DB3"
  "65B6EFC0-0CFC-4B6F-BEA0-49533A1299E0"
  "19152FA1-44D3-41C5-AE99-DE2D3208CEB4"
  "49CAD528-3FAD-4D2E-B9DB-88018FEAC1AE"
]

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 ('9935195D-49DA-4BB6-9BA7-1136A6E6FC4C', '1258067C-FCF9-43F0-B493-2A95E0269B05', '349A6643-9FD4-47B0-BFB8-05AFC84F9245', '9118594A-A213-4E9F-9F29-D4C0B08B6A76', 'E388AAB1-7E33-4FEF-A7D0-A6979AE384F8', 'F61CA6D6-40FF-4366-8500-409220C896E5', '85495AFA-178B-4A53-8FB9-3E0D2A141DB3', '65B6EFC0-0CFC-4B6F-BEA0-49533A1299E0', '19152FA1-44D3-41C5-AE99-DE2D3208CEB4', '49CAD528-3FAD-4D2E-B9DB-88018FEAC1AE') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "9935195d-49da-4bb6-9ba7-1136a6e6fc4c"
  "1258067c-fcf9-43f0-b493-2a95e0269b05"
  "349a6643-9fd4-47b0-bfb8-05afc84f9245"
  "9118594a-a213-4e9f-9f29-d4c0b08b6a76"
  "e388aab1-7e33-4fef-a7d0-a6979ae384f8"
  "f61ca6d6-40ff-4366-8500-409220c896e5"
  "85495afa-178b-4a53-8fb9-3e0d2a141db3"
  "65b6efc0-0cfc-4b6f-bea0-49533a1299e0"
  "19152fa1-44d3-41c5-ae99-de2d3208ceb4"
  "49cad528-3fad-4d2e-b9db-88018feac1ae"
]

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 ('9935195d-49da-4bb6-9ba7-1136a6e6fc4c','1258067c-fcf9-43f0-b493-2a95e0269b05','349a6643-9fd4-47b0-bfb8-05afc84f9245','9118594a-a213-4e9f-9f29-d4c0b08b6a76','e388aab1-7e33-4fef-a7d0-a6979ae384f8','f61ca6d6-40ff-4366-8500-409220c896e5','85495afa-178b-4a53-8fb9-3e0d2a141db3','65b6efc0-0cfc-4b6f-bea0-49533a1299e0','19152fa1-44d3-41c5-ae99-de2d3208ceb4','49cad528-3fad-4d2e-b9db-88018feac1ae');