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

[
  "A1D908B7-2B6C-4250-AC70-2EB991DDC201"
  "E6A62CE8-7858-4C8A-AAA5-2B3CE0F387D5"
  "3AE4606B-CCE9-4565-AE31-411C61DF55C0"
  "5535F0F6-5053-4A1B-BC3E-1A402F77D53A"
  "C572923E-E44B-4151-A617-0948F49A16D3"
  "ACCBDAEE-3D7D-4379-9340-853F3724CDA8"
  "6B2A2A75-0F51-48C1-A63D-24D5F0A6A609"
  "11F2D264-74E7-4315-8C66-938B506E821D"
  "EB062822-A0EC-4958-9BC6-1CA9898520C3"
  "EDA5B835-DEA8-430A-90F5-6559AA1565C1"
  "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 ('A1D908B7-2B6C-4250-AC70-2EB991DDC201', 'E6A62CE8-7858-4C8A-AAA5-2B3CE0F387D5', '3AE4606B-CCE9-4565-AE31-411C61DF55C0', '5535F0F6-5053-4A1B-BC3E-1A402F77D53A', 'C572923E-E44B-4151-A617-0948F49A16D3', 'ACCBDAEE-3D7D-4379-9340-853F3724CDA8', '6B2A2A75-0F51-48C1-A63D-24D5F0A6A609', '11F2D264-74E7-4315-8C66-938B506E821D', 'EB062822-A0EC-4958-9BC6-1CA9898520C3', 'EDA5B835-DEA8-430A-90F5-6559AA1565C1') 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

[
  "A1D908B7-2B6C-4250-AC70-2EB991DDC201"
  "E6A62CE8-7858-4C8A-AAA5-2B3CE0F387D5"
  "3AE4606B-CCE9-4565-AE31-411C61DF55C0"
  "5535F0F6-5053-4A1B-BC3E-1A402F77D53A"
  "C572923E-E44B-4151-A617-0948F49A16D3"
  "ACCBDAEE-3D7D-4379-9340-853F3724CDA8"
  "6B2A2A75-0F51-48C1-A63D-24D5F0A6A609"
  "11F2D264-74E7-4315-8C66-938B506E821D"
  "EB062822-A0EC-4958-9BC6-1CA9898520C3"
  "EDA5B835-DEA8-430A-90F5-6559AA1565C1"
]

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 ('A1D908B7-2B6C-4250-AC70-2EB991DDC201', 'E6A62CE8-7858-4C8A-AAA5-2B3CE0F387D5', '3AE4606B-CCE9-4565-AE31-411C61DF55C0', '5535F0F6-5053-4A1B-BC3E-1A402F77D53A', 'C572923E-E44B-4151-A617-0948F49A16D3', 'ACCBDAEE-3D7D-4379-9340-853F3724CDA8', '6B2A2A75-0F51-48C1-A63D-24D5F0A6A609', '11F2D264-74E7-4315-8C66-938B506E821D', 'EB062822-A0EC-4958-9BC6-1CA9898520C3', 'EDA5B835-DEA8-430A-90F5-6559AA1565C1') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "a1d908b7-2b6c-4250-ac70-2eb991ddc201"
  "e6a62ce8-7858-4c8a-aaa5-2b3ce0f387d5"
  "3ae4606b-cce9-4565-ae31-411c61df55c0"
  "5535f0f6-5053-4a1b-bc3e-1a402f77d53a"
  "c572923e-e44b-4151-a617-0948f49a16d3"
  "accbdaee-3d7d-4379-9340-853f3724cda8"
  "6b2a2a75-0f51-48c1-a63d-24d5f0a6a609"
  "11f2d264-74e7-4315-8c66-938b506e821d"
  "eb062822-a0ec-4958-9bc6-1ca9898520c3"
  "eda5b835-dea8-430a-90f5-6559aa1565c1"
]

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 ('a1d908b7-2b6c-4250-ac70-2eb991ddc201','e6a62ce8-7858-4c8a-aaa5-2b3ce0f387d5','3ae4606b-cce9-4565-ae31-411c61df55c0','5535f0f6-5053-4a1b-bc3e-1a402f77d53a','c572923e-e44b-4151-a617-0948f49a16d3','accbdaee-3d7d-4379-9340-853f3724cda8','6b2a2a75-0f51-48c1-a63d-24d5f0a6a609','11f2d264-74e7-4315-8c66-938b506e821d','eb062822-a0ec-4958-9bc6-1ca9898520c3','eda5b835-dea8-430a-90f5-6559aa1565c1');