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

[
  "737B4D95-30BE-4142-81D1-85EA0ED1CAB5"
  "D2848255-0414-45F0-A6B6-11D5B440016B"
  "95079EA4-D742-4E5D-845D-F25206F771F5"
  "577A52E0-983A-418C-9BAC-A6534B4BB9BB"
  "E47797E7-6A34-4935-A41F-26E5E8A127E1"
  "F3F081CD-11AD-4FBF-88DA-CF9ABF1BE420"
  "DBCA988E-9785-48F1-A5D8-20F3AB46DC1F"
  "D73D10FF-52AE-441F-95F2-B7216CCE8739"
  "DF36A63D-C605-4697-82DE-866F87E4EFBC"
  "DA381FFB-FA45-47C4-A1B8-9F6BD33E0041"
  "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 ('737B4D95-30BE-4142-81D1-85EA0ED1CAB5', 'D2848255-0414-45F0-A6B6-11D5B440016B', '95079EA4-D742-4E5D-845D-F25206F771F5', '577A52E0-983A-418C-9BAC-A6534B4BB9BB', 'E47797E7-6A34-4935-A41F-26E5E8A127E1', 'F3F081CD-11AD-4FBF-88DA-CF9ABF1BE420', 'DBCA988E-9785-48F1-A5D8-20F3AB46DC1F', 'D73D10FF-52AE-441F-95F2-B7216CCE8739', 'DF36A63D-C605-4697-82DE-866F87E4EFBC', 'DA381FFB-FA45-47C4-A1B8-9F6BD33E0041') 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

[
  "737B4D95-30BE-4142-81D1-85EA0ED1CAB5"
  "D2848255-0414-45F0-A6B6-11D5B440016B"
  "95079EA4-D742-4E5D-845D-F25206F771F5"
  "577A52E0-983A-418C-9BAC-A6534B4BB9BB"
  "E47797E7-6A34-4935-A41F-26E5E8A127E1"
  "F3F081CD-11AD-4FBF-88DA-CF9ABF1BE420"
  "DBCA988E-9785-48F1-A5D8-20F3AB46DC1F"
  "D73D10FF-52AE-441F-95F2-B7216CCE8739"
  "DF36A63D-C605-4697-82DE-866F87E4EFBC"
  "DA381FFB-FA45-47C4-A1B8-9F6BD33E0041"
]

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 ('737B4D95-30BE-4142-81D1-85EA0ED1CAB5', 'D2848255-0414-45F0-A6B6-11D5B440016B', '95079EA4-D742-4E5D-845D-F25206F771F5', '577A52E0-983A-418C-9BAC-A6534B4BB9BB', 'E47797E7-6A34-4935-A41F-26E5E8A127E1', 'F3F081CD-11AD-4FBF-88DA-CF9ABF1BE420', 'DBCA988E-9785-48F1-A5D8-20F3AB46DC1F', 'D73D10FF-52AE-441F-95F2-B7216CCE8739', 'DF36A63D-C605-4697-82DE-866F87E4EFBC', 'DA381FFB-FA45-47C4-A1B8-9F6BD33E0041') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "737b4d95-30be-4142-81d1-85ea0ed1cab5"
  "d2848255-0414-45f0-a6b6-11d5b440016b"
  "95079ea4-d742-4e5d-845d-f25206f771f5"
  "577a52e0-983a-418c-9bac-a6534b4bb9bb"
  "e47797e7-6a34-4935-a41f-26e5e8a127e1"
  "f3f081cd-11ad-4fbf-88da-cf9abf1be420"
  "dbca988e-9785-48f1-a5d8-20f3ab46dc1f"
  "d73d10ff-52ae-441f-95f2-b7216cce8739"
  "df36a63d-c605-4697-82de-866f87e4efbc"
  "da381ffb-fa45-47c4-a1b8-9f6bd33e0041"
]

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 ('737b4d95-30be-4142-81d1-85ea0ed1cab5','d2848255-0414-45f0-a6b6-11d5b440016b','95079ea4-d742-4e5d-845d-f25206f771f5','577a52e0-983a-418c-9bac-a6534b4bb9bb','e47797e7-6a34-4935-a41f-26e5e8a127e1','f3f081cd-11ad-4fbf-88da-cf9abf1be420','dbca988e-9785-48f1-a5d8-20f3ab46dc1f','d73d10ff-52ae-441f-95f2-b7216cce8739','df36a63d-c605-4697-82de-866f87e4efbc','da381ffb-fa45-47c4-a1b8-9f6bd33e0041');