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

[
  "421CB27D-52E7-48AE-A7FF-1D55BF306E89"
  "A75D93C2-5585-4556-8531-DAA706E8DB7B"
  "1A3B8B43-609E-4545-A969-25FB766A5204"
  "594A4AF7-3E2C-4720-B006-33D069F00D46"
  "F0FA1C00-0832-4C4A-BA9F-2A6B5E448369"
  "139FF680-E230-4D39-AED4-22CB24D3AC26"
  "9F9460F6-6F48-4E70-9297-870D1A989999"
  "E7F73DB0-EAC6-428F-A60B-A74CD03B250F"
  "AAFFAA5E-BC92-4C41-A924-C96E61D2FB1B"
  "A36E91CC-8434-46F3-9379-BA04FB6747C9"
  "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 ('421CB27D-52E7-48AE-A7FF-1D55BF306E89', 'A75D93C2-5585-4556-8531-DAA706E8DB7B', '1A3B8B43-609E-4545-A969-25FB766A5204', '594A4AF7-3E2C-4720-B006-33D069F00D46', 'F0FA1C00-0832-4C4A-BA9F-2A6B5E448369', '139FF680-E230-4D39-AED4-22CB24D3AC26', '9F9460F6-6F48-4E70-9297-870D1A989999', 'E7F73DB0-EAC6-428F-A60B-A74CD03B250F', 'AAFFAA5E-BC92-4C41-A924-C96E61D2FB1B', 'A36E91CC-8434-46F3-9379-BA04FB6747C9') 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

[
  "421CB27D-52E7-48AE-A7FF-1D55BF306E89"
  "A75D93C2-5585-4556-8531-DAA706E8DB7B"
  "1A3B8B43-609E-4545-A969-25FB766A5204"
  "594A4AF7-3E2C-4720-B006-33D069F00D46"
  "F0FA1C00-0832-4C4A-BA9F-2A6B5E448369"
  "139FF680-E230-4D39-AED4-22CB24D3AC26"
  "9F9460F6-6F48-4E70-9297-870D1A989999"
  "E7F73DB0-EAC6-428F-A60B-A74CD03B250F"
  "AAFFAA5E-BC92-4C41-A924-C96E61D2FB1B"
  "A36E91CC-8434-46F3-9379-BA04FB6747C9"
]

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 ('421CB27D-52E7-48AE-A7FF-1D55BF306E89', 'A75D93C2-5585-4556-8531-DAA706E8DB7B', '1A3B8B43-609E-4545-A969-25FB766A5204', '594A4AF7-3E2C-4720-B006-33D069F00D46', 'F0FA1C00-0832-4C4A-BA9F-2A6B5E448369', '139FF680-E230-4D39-AED4-22CB24D3AC26', '9F9460F6-6F48-4E70-9297-870D1A989999', 'E7F73DB0-EAC6-428F-A60B-A74CD03B250F', 'AAFFAA5E-BC92-4C41-A924-C96E61D2FB1B', 'A36E91CC-8434-46F3-9379-BA04FB6747C9') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "421cb27d-52e7-48ae-a7ff-1d55bf306e89"
  "a75d93c2-5585-4556-8531-daa706e8db7b"
  "1a3b8b43-609e-4545-a969-25fb766a5204"
  "594a4af7-3e2c-4720-b006-33d069f00d46"
  "f0fa1c00-0832-4c4a-ba9f-2a6b5e448369"
  "139ff680-e230-4d39-aed4-22cb24d3ac26"
  "9f9460f6-6f48-4e70-9297-870d1a989999"
  "e7f73db0-eac6-428f-a60b-a74cd03b250f"
  "aaffaa5e-bc92-4c41-a924-c96e61d2fb1b"
  "a36e91cc-8434-46f3-9379-ba04fb6747c9"
]

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 ('421cb27d-52e7-48ae-a7ff-1d55bf306e89','a75d93c2-5585-4556-8531-daa706e8db7b','1a3b8b43-609e-4545-a969-25fb766a5204','594a4af7-3e2c-4720-b006-33d069f00d46','f0fa1c00-0832-4c4a-ba9f-2a6b5e448369','139ff680-e230-4d39-aed4-22cb24d3ac26','9f9460f6-6f48-4e70-9297-870d1a989999','e7f73db0-eac6-428f-a60b-a74cd03b250f','aaffaa5e-bc92-4c41-a924-c96e61d2fb1b','a36e91cc-8434-46f3-9379-ba04fb6747c9');