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

[
  "49DD32A2-224A-47F1-A431-A13752E4751B"
  "7B113A88-8254-4C60-87CD-B2D49B20B9B5"
  "B2E7AD15-0158-4C82-90A9-24735B54E1DC"
  "A9320603-0DED-42FD-9B8F-A24AF9B86C44"
  "E8505D41-1BA0-4F3B-9463-1744C18F58B9"
  "9256A2C4-AF2E-40BA-BB54-8D38B07BA2C9"
  "28C43E79-FC0F-42B2-936D-1209C7BDBC60"
  "10B91652-1E9E-4AE9-BFE7-EB80C17078D3"
  "25F69DA0-DEFC-46A5-AB10-BEA67FDFDABE"
  "20EE2D88-4227-458D-916D-BF142D6F4356"
  "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 ('49DD32A2-224A-47F1-A431-A13752E4751B', '7B113A88-8254-4C60-87CD-B2D49B20B9B5', 'B2E7AD15-0158-4C82-90A9-24735B54E1DC', 'A9320603-0DED-42FD-9B8F-A24AF9B86C44', 'E8505D41-1BA0-4F3B-9463-1744C18F58B9', '9256A2C4-AF2E-40BA-BB54-8D38B07BA2C9', '28C43E79-FC0F-42B2-936D-1209C7BDBC60', '10B91652-1E9E-4AE9-BFE7-EB80C17078D3', '25F69DA0-DEFC-46A5-AB10-BEA67FDFDABE', '20EE2D88-4227-458D-916D-BF142D6F4356') 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

[
  "49DD32A2-224A-47F1-A431-A13752E4751B"
  "7B113A88-8254-4C60-87CD-B2D49B20B9B5"
  "B2E7AD15-0158-4C82-90A9-24735B54E1DC"
  "A9320603-0DED-42FD-9B8F-A24AF9B86C44"
  "E8505D41-1BA0-4F3B-9463-1744C18F58B9"
  "9256A2C4-AF2E-40BA-BB54-8D38B07BA2C9"
  "28C43E79-FC0F-42B2-936D-1209C7BDBC60"
  "10B91652-1E9E-4AE9-BFE7-EB80C17078D3"
  "25F69DA0-DEFC-46A5-AB10-BEA67FDFDABE"
  "20EE2D88-4227-458D-916D-BF142D6F4356"
]

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 ('49DD32A2-224A-47F1-A431-A13752E4751B', '7B113A88-8254-4C60-87CD-B2D49B20B9B5', 'B2E7AD15-0158-4C82-90A9-24735B54E1DC', 'A9320603-0DED-42FD-9B8F-A24AF9B86C44', 'E8505D41-1BA0-4F3B-9463-1744C18F58B9', '9256A2C4-AF2E-40BA-BB54-8D38B07BA2C9', '28C43E79-FC0F-42B2-936D-1209C7BDBC60', '10B91652-1E9E-4AE9-BFE7-EB80C17078D3', '25F69DA0-DEFC-46A5-AB10-BEA67FDFDABE', '20EE2D88-4227-458D-916D-BF142D6F4356') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "49dd32a2-224a-47f1-a431-a13752e4751b"
  "7b113a88-8254-4c60-87cd-b2d49b20b9b5"
  "b2e7ad15-0158-4c82-90a9-24735b54e1dc"
  "a9320603-0ded-42fd-9b8f-a24af9b86c44"
  "e8505d41-1ba0-4f3b-9463-1744c18f58b9"
  "9256a2c4-af2e-40ba-bb54-8d38b07ba2c9"
  "28c43e79-fc0f-42b2-936d-1209c7bdbc60"
  "10b91652-1e9e-4ae9-bfe7-eb80c17078d3"
  "25f69da0-defc-46a5-ab10-bea67fdfdabe"
  "20ee2d88-4227-458d-916d-bf142d6f4356"
]

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 ('49dd32a2-224a-47f1-a431-a13752e4751b','7b113a88-8254-4c60-87cd-b2d49b20b9b5','b2e7ad15-0158-4c82-90a9-24735b54e1dc','a9320603-0ded-42fd-9b8f-a24af9b86c44','e8505d41-1ba0-4f3b-9463-1744c18f58b9','9256a2c4-af2e-40ba-bb54-8d38b07ba2c9','28c43e79-fc0f-42b2-936d-1209c7bdbc60','10b91652-1e9e-4ae9-bfe7-eb80c17078d3','25f69da0-defc-46a5-ab10-bea67fdfdabe','20ee2d88-4227-458d-916d-bf142d6f4356');