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

[
  "3AFC2574-F617-497F-A263-97FDF68E3DC3"
  "5EC57CD2-72E6-4281-91EB-A404FA86EB71"
  "D56164AD-1CA3-49A9-BEF0-6B0374EB7DF3"
  "ABD4B611-6315-4616-AABE-4A365B2FE087"
  "4880CC2E-E86E-4E3E-A1B2-A926B9985988"
  "31F6EE61-AFF4-4325-9550-0E7C69626A76"
  "22429BBB-61F5-42E1-982A-975E4F83DF3E"
  "87BDE412-C341-4A95-90ED-9C16E7DC8B43"
  "B8886EB1-E80F-4A94-AF15-D1FD03C0CA90"
  "183C6654-7C67-424D-859F-47B3F090C921"
  "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 ('3AFC2574-F617-497F-A263-97FDF68E3DC3', '5EC57CD2-72E6-4281-91EB-A404FA86EB71', 'D56164AD-1CA3-49A9-BEF0-6B0374EB7DF3', 'ABD4B611-6315-4616-AABE-4A365B2FE087', '4880CC2E-E86E-4E3E-A1B2-A926B9985988', '31F6EE61-AFF4-4325-9550-0E7C69626A76', '22429BBB-61F5-42E1-982A-975E4F83DF3E', '87BDE412-C341-4A95-90ED-9C16E7DC8B43', 'B8886EB1-E80F-4A94-AF15-D1FD03C0CA90', '183C6654-7C67-424D-859F-47B3F090C921') 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

[
  "3AFC2574-F617-497F-A263-97FDF68E3DC3"
  "5EC57CD2-72E6-4281-91EB-A404FA86EB71"
  "D56164AD-1CA3-49A9-BEF0-6B0374EB7DF3"
  "ABD4B611-6315-4616-AABE-4A365B2FE087"
  "4880CC2E-E86E-4E3E-A1B2-A926B9985988"
  "31F6EE61-AFF4-4325-9550-0E7C69626A76"
  "22429BBB-61F5-42E1-982A-975E4F83DF3E"
  "87BDE412-C341-4A95-90ED-9C16E7DC8B43"
  "B8886EB1-E80F-4A94-AF15-D1FD03C0CA90"
  "183C6654-7C67-424D-859F-47B3F090C921"
]

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 ('3AFC2574-F617-497F-A263-97FDF68E3DC3', '5EC57CD2-72E6-4281-91EB-A404FA86EB71', 'D56164AD-1CA3-49A9-BEF0-6B0374EB7DF3', 'ABD4B611-6315-4616-AABE-4A365B2FE087', '4880CC2E-E86E-4E3E-A1B2-A926B9985988', '31F6EE61-AFF4-4325-9550-0E7C69626A76', '22429BBB-61F5-42E1-982A-975E4F83DF3E', '87BDE412-C341-4A95-90ED-9C16E7DC8B43', 'B8886EB1-E80F-4A94-AF15-D1FD03C0CA90', '183C6654-7C67-424D-859F-47B3F090C921') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "3afc2574-f617-497f-a263-97fdf68e3dc3"
  "5ec57cd2-72e6-4281-91eb-a404fa86eb71"
  "d56164ad-1ca3-49a9-bef0-6b0374eb7df3"
  "abd4b611-6315-4616-aabe-4a365b2fe087"
  "4880cc2e-e86e-4e3e-a1b2-a926b9985988"
  "31f6ee61-aff4-4325-9550-0e7c69626a76"
  "22429bbb-61f5-42e1-982a-975e4f83df3e"
  "87bde412-c341-4a95-90ed-9c16e7dc8b43"
  "b8886eb1-e80f-4a94-af15-d1fd03c0ca90"
  "183c6654-7c67-424d-859f-47b3f090c921"
]

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 ('3afc2574-f617-497f-a263-97fdf68e3dc3','5ec57cd2-72e6-4281-91eb-a404fa86eb71','d56164ad-1ca3-49a9-bef0-6b0374eb7df3','abd4b611-6315-4616-aabe-4a365b2fe087','4880cc2e-e86e-4e3e-a1b2-a926b9985988','31f6ee61-aff4-4325-9550-0e7c69626a76','22429bbb-61f5-42e1-982a-975e4f83df3e','87bde412-c341-4a95-90ed-9c16e7dc8b43','b8886eb1-e80f-4a94-af15-d1fd03c0ca90','183c6654-7c67-424d-859f-47b3f090c921');