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

[
  "0EB4B472-0AB1-4B41-A736-7738872E27A7"
  "3337977A-3ECA-45E4-BDB2-B98F6A20096F"
  "189C44D3-BC0B-4D08-9EAC-F1FB0B4D6C01"
  "5C13E25A-F679-4970-BD39-83C16238621F"
  "A5D3DA8B-C364-458C-B146-1E71BB33F84A"
  "D51D0B3F-E4A1-4C63-91B7-D900C2C4409D"
  "842D1D9A-C4F8-4E29-BD8A-36091EA2F6F0"
  "7A41746A-9D08-4CA3-984D-9F4AC4C51349"
  "79EA69B8-B8BB-4D90-98D0-0DCA20684DC9"
  "196F140C-A3B5-409B-814E-61A91C481040"
  "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 ('0EB4B472-0AB1-4B41-A736-7738872E27A7', '3337977A-3ECA-45E4-BDB2-B98F6A20096F', '189C44D3-BC0B-4D08-9EAC-F1FB0B4D6C01', '5C13E25A-F679-4970-BD39-83C16238621F', 'A5D3DA8B-C364-458C-B146-1E71BB33F84A', 'D51D0B3F-E4A1-4C63-91B7-D900C2C4409D', '842D1D9A-C4F8-4E29-BD8A-36091EA2F6F0', '7A41746A-9D08-4CA3-984D-9F4AC4C51349', '79EA69B8-B8BB-4D90-98D0-0DCA20684DC9', '196F140C-A3B5-409B-814E-61A91C481040') 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

[
  "0EB4B472-0AB1-4B41-A736-7738872E27A7"
  "3337977A-3ECA-45E4-BDB2-B98F6A20096F"
  "189C44D3-BC0B-4D08-9EAC-F1FB0B4D6C01"
  "5C13E25A-F679-4970-BD39-83C16238621F"
  "A5D3DA8B-C364-458C-B146-1E71BB33F84A"
  "D51D0B3F-E4A1-4C63-91B7-D900C2C4409D"
  "842D1D9A-C4F8-4E29-BD8A-36091EA2F6F0"
  "7A41746A-9D08-4CA3-984D-9F4AC4C51349"
  "79EA69B8-B8BB-4D90-98D0-0DCA20684DC9"
  "196F140C-A3B5-409B-814E-61A91C481040"
]

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 ('0EB4B472-0AB1-4B41-A736-7738872E27A7', '3337977A-3ECA-45E4-BDB2-B98F6A20096F', '189C44D3-BC0B-4D08-9EAC-F1FB0B4D6C01', '5C13E25A-F679-4970-BD39-83C16238621F', 'A5D3DA8B-C364-458C-B146-1E71BB33F84A', 'D51D0B3F-E4A1-4C63-91B7-D900C2C4409D', '842D1D9A-C4F8-4E29-BD8A-36091EA2F6F0', '7A41746A-9D08-4CA3-984D-9F4AC4C51349', '79EA69B8-B8BB-4D90-98D0-0DCA20684DC9', '196F140C-A3B5-409B-814E-61A91C481040') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "0eb4b472-0ab1-4b41-a736-7738872e27a7"
  "3337977a-3eca-45e4-bdb2-b98f6a20096f"
  "189c44d3-bc0b-4d08-9eac-f1fb0b4d6c01"
  "5c13e25a-f679-4970-bd39-83c16238621f"
  "a5d3da8b-c364-458c-b146-1e71bb33f84a"
  "d51d0b3f-e4a1-4c63-91b7-d900c2c4409d"
  "842d1d9a-c4f8-4e29-bd8a-36091ea2f6f0"
  "7a41746a-9d08-4ca3-984d-9f4ac4c51349"
  "79ea69b8-b8bb-4d90-98d0-0dca20684dc9"
  "196f140c-a3b5-409b-814e-61a91c481040"
]

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 ('0eb4b472-0ab1-4b41-a736-7738872e27a7','3337977a-3eca-45e4-bdb2-b98f6a20096f','189c44d3-bc0b-4d08-9eac-f1fb0b4d6c01','5c13e25a-f679-4970-bd39-83c16238621f','a5d3da8b-c364-458c-b146-1e71bb33f84a','d51d0b3f-e4a1-4c63-91b7-d900c2c4409d','842d1d9a-c4f8-4e29-bd8a-36091ea2f6f0','7a41746a-9d08-4ca3-984d-9f4ac4c51349','79ea69b8-b8bb-4d90-98d0-0dca20684dc9','196f140c-a3b5-409b-814e-61a91c481040');