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

[
  "BFE06B8B-5267-4897-82C5-DBA9D3D83C30"
  "29B34D46-C458-40EB-88FE-5C60F8607A62"
  "28134B0F-C8A6-49B1-AF8B-1F4D73B802E7"
  "39D8F10C-3BB8-42F2-8BF8-CFF141454085"
  "BE76B8BF-D19E-4054-BBF0-3A85CE6403D5"
  "E8B0B5AC-414B-420F-A4D3-1C2477DCA25F"
  "1FAC8059-6AA3-4948-8A30-B821358B81D9"
  "53300F3A-998E-4835-9B3E-A9B9A7C70F05"
  "9889E3E5-AB25-4121-9745-EBFEB96EBF81"
  "39393418-19E5-4520-AAA5-1034115087E1"
  "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 ('BFE06B8B-5267-4897-82C5-DBA9D3D83C30', '29B34D46-C458-40EB-88FE-5C60F8607A62', '28134B0F-C8A6-49B1-AF8B-1F4D73B802E7', '39D8F10C-3BB8-42F2-8BF8-CFF141454085', 'BE76B8BF-D19E-4054-BBF0-3A85CE6403D5', 'E8B0B5AC-414B-420F-A4D3-1C2477DCA25F', '1FAC8059-6AA3-4948-8A30-B821358B81D9', '53300F3A-998E-4835-9B3E-A9B9A7C70F05', '9889E3E5-AB25-4121-9745-EBFEB96EBF81', '39393418-19E5-4520-AAA5-1034115087E1') 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

[
  "BFE06B8B-5267-4897-82C5-DBA9D3D83C30"
  "29B34D46-C458-40EB-88FE-5C60F8607A62"
  "28134B0F-C8A6-49B1-AF8B-1F4D73B802E7"
  "39D8F10C-3BB8-42F2-8BF8-CFF141454085"
  "BE76B8BF-D19E-4054-BBF0-3A85CE6403D5"
  "E8B0B5AC-414B-420F-A4D3-1C2477DCA25F"
  "1FAC8059-6AA3-4948-8A30-B821358B81D9"
  "53300F3A-998E-4835-9B3E-A9B9A7C70F05"
  "9889E3E5-AB25-4121-9745-EBFEB96EBF81"
  "39393418-19E5-4520-AAA5-1034115087E1"
]

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 ('BFE06B8B-5267-4897-82C5-DBA9D3D83C30', '29B34D46-C458-40EB-88FE-5C60F8607A62', '28134B0F-C8A6-49B1-AF8B-1F4D73B802E7', '39D8F10C-3BB8-42F2-8BF8-CFF141454085', 'BE76B8BF-D19E-4054-BBF0-3A85CE6403D5', 'E8B0B5AC-414B-420F-A4D3-1C2477DCA25F', '1FAC8059-6AA3-4948-8A30-B821358B81D9', '53300F3A-998E-4835-9B3E-A9B9A7C70F05', '9889E3E5-AB25-4121-9745-EBFEB96EBF81', '39393418-19E5-4520-AAA5-1034115087E1') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "bfe06b8b-5267-4897-82c5-dba9d3d83c30"
  "29b34d46-c458-40eb-88fe-5c60f8607a62"
  "28134b0f-c8a6-49b1-af8b-1f4d73b802e7"
  "39d8f10c-3bb8-42f2-8bf8-cff141454085"
  "be76b8bf-d19e-4054-bbf0-3a85ce6403d5"
  "e8b0b5ac-414b-420f-a4d3-1c2477dca25f"
  "1fac8059-6aa3-4948-8a30-b821358b81d9"
  "53300f3a-998e-4835-9b3e-a9b9a7c70f05"
  "9889e3e5-ab25-4121-9745-ebfeb96ebf81"
  "39393418-19e5-4520-aaa5-1034115087e1"
]

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 ('bfe06b8b-5267-4897-82c5-dba9d3d83c30','29b34d46-c458-40eb-88fe-5c60f8607a62','28134b0f-c8a6-49b1-af8b-1f4d73b802e7','39d8f10c-3bb8-42f2-8bf8-cff141454085','be76b8bf-d19e-4054-bbf0-3a85ce6403d5','e8b0b5ac-414b-420f-a4d3-1c2477dca25f','1fac8059-6aa3-4948-8a30-b821358b81d9','53300f3a-998e-4835-9b3e-a9b9a7c70f05','9889e3e5-ab25-4121-9745-ebfeb96ebf81','39393418-19e5-4520-aaa5-1034115087e1');