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

[
  "CA887622-BD66-4AD5-B22E-7A125460B74C"
  "10E46077-5D92-4FAE-887D-8573B9581A61"
  "6D034633-614B-4177-BC7F-14B7209C75B3"
  "2D7BBFBD-1C61-4F57-A1F8-81EB5CF3F9EC"
  "7782C0D3-12F0-475E-B63A-5A47C9C9CCA1"
  "7A5DC58C-5279-44A2-A268-892FEEEACB8F"
  "8D99112C-BEA2-4F64-A985-47488B98D376"
  "C2ADB87D-E600-46B3-A6DB-A2D7754E8C7C"
  "CE777A01-0495-4164-A360-52DE85818CAB"
  "4AA363BE-CAD2-4712-8B40-4E17657223BA"
  "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 ('CA887622-BD66-4AD5-B22E-7A125460B74C', '10E46077-5D92-4FAE-887D-8573B9581A61', '6D034633-614B-4177-BC7F-14B7209C75B3', '2D7BBFBD-1C61-4F57-A1F8-81EB5CF3F9EC', '7782C0D3-12F0-475E-B63A-5A47C9C9CCA1', '7A5DC58C-5279-44A2-A268-892FEEEACB8F', '8D99112C-BEA2-4F64-A985-47488B98D376', 'C2ADB87D-E600-46B3-A6DB-A2D7754E8C7C', 'CE777A01-0495-4164-A360-52DE85818CAB', '4AA363BE-CAD2-4712-8B40-4E17657223BA') 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

[
  "CA887622-BD66-4AD5-B22E-7A125460B74C"
  "10E46077-5D92-4FAE-887D-8573B9581A61"
  "6D034633-614B-4177-BC7F-14B7209C75B3"
  "2D7BBFBD-1C61-4F57-A1F8-81EB5CF3F9EC"
  "7782C0D3-12F0-475E-B63A-5A47C9C9CCA1"
  "7A5DC58C-5279-44A2-A268-892FEEEACB8F"
  "8D99112C-BEA2-4F64-A985-47488B98D376"
  "C2ADB87D-E600-46B3-A6DB-A2D7754E8C7C"
  "CE777A01-0495-4164-A360-52DE85818CAB"
  "4AA363BE-CAD2-4712-8B40-4E17657223BA"
]

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 ('CA887622-BD66-4AD5-B22E-7A125460B74C', '10E46077-5D92-4FAE-887D-8573B9581A61', '6D034633-614B-4177-BC7F-14B7209C75B3', '2D7BBFBD-1C61-4F57-A1F8-81EB5CF3F9EC', '7782C0D3-12F0-475E-B63A-5A47C9C9CCA1', '7A5DC58C-5279-44A2-A268-892FEEEACB8F', '8D99112C-BEA2-4F64-A985-47488B98D376', 'C2ADB87D-E600-46B3-A6DB-A2D7754E8C7C', 'CE777A01-0495-4164-A360-52DE85818CAB', '4AA363BE-CAD2-4712-8B40-4E17657223BA') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "ca887622-bd66-4ad5-b22e-7a125460b74c"
  "10e46077-5d92-4fae-887d-8573b9581a61"
  "6d034633-614b-4177-bc7f-14b7209c75b3"
  "2d7bbfbd-1c61-4f57-a1f8-81eb5cf3f9ec"
  "7782c0d3-12f0-475e-b63a-5a47c9c9cca1"
  "7a5dc58c-5279-44a2-a268-892feeeacb8f"
  "8d99112c-bea2-4f64-a985-47488b98d376"
  "c2adb87d-e600-46b3-a6db-a2d7754e8c7c"
  "ce777a01-0495-4164-a360-52de85818cab"
  "4aa363be-cad2-4712-8b40-4e17657223ba"
]

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 ('ca887622-bd66-4ad5-b22e-7a125460b74c','10e46077-5d92-4fae-887d-8573b9581a61','6d034633-614b-4177-bc7f-14b7209c75b3','2d7bbfbd-1c61-4f57-a1f8-81eb5cf3f9ec','7782c0d3-12f0-475e-b63a-5a47c9c9cca1','7a5dc58c-5279-44a2-a268-892feeeacb8f','8d99112c-bea2-4f64-a985-47488b98d376','c2adb87d-e600-46b3-a6db-a2d7754e8c7c','ce777a01-0495-4164-a360-52de85818cab','4aa363be-cad2-4712-8b40-4e17657223ba');