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

[
  "2224D83F-70FE-4613-87DC-9EAEACAD796F"
  "4B09D4C7-4CAB-4368-BD9B-EC01600A0BFB"
  "24E2F5E6-A832-4A75-B205-4080BB2DD42F"
  "95FDD4E1-AA09-4536-97DB-6E90DFE352F2"
  "B81A6572-84B2-401E-B1E8-E73C1B635ABB"
  "75046ECC-98F6-47BB-88BF-D7C61290E4D0"
  "14A7B36E-0D6F-43C8-8A8E-6773EF7EE1AE"
  "81FCFFD5-BBF3-4E80-95D6-D4A15559FF14"
  "9BD10E63-50F9-4B30-B99D-B4C2368D7759"
  "78E8B5C4-92A7-41F1-83F9-C597E71E7127"
  "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 ('2224D83F-70FE-4613-87DC-9EAEACAD796F', '4B09D4C7-4CAB-4368-BD9B-EC01600A0BFB', '24E2F5E6-A832-4A75-B205-4080BB2DD42F', '95FDD4E1-AA09-4536-97DB-6E90DFE352F2', 'B81A6572-84B2-401E-B1E8-E73C1B635ABB', '75046ECC-98F6-47BB-88BF-D7C61290E4D0', '14A7B36E-0D6F-43C8-8A8E-6773EF7EE1AE', '81FCFFD5-BBF3-4E80-95D6-D4A15559FF14', '9BD10E63-50F9-4B30-B99D-B4C2368D7759', '78E8B5C4-92A7-41F1-83F9-C597E71E7127') 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

[
  "2224D83F-70FE-4613-87DC-9EAEACAD796F"
  "4B09D4C7-4CAB-4368-BD9B-EC01600A0BFB"
  "24E2F5E6-A832-4A75-B205-4080BB2DD42F"
  "95FDD4E1-AA09-4536-97DB-6E90DFE352F2"
  "B81A6572-84B2-401E-B1E8-E73C1B635ABB"
  "75046ECC-98F6-47BB-88BF-D7C61290E4D0"
  "14A7B36E-0D6F-43C8-8A8E-6773EF7EE1AE"
  "81FCFFD5-BBF3-4E80-95D6-D4A15559FF14"
  "9BD10E63-50F9-4B30-B99D-B4C2368D7759"
  "78E8B5C4-92A7-41F1-83F9-C597E71E7127"
]

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 ('2224D83F-70FE-4613-87DC-9EAEACAD796F', '4B09D4C7-4CAB-4368-BD9B-EC01600A0BFB', '24E2F5E6-A832-4A75-B205-4080BB2DD42F', '95FDD4E1-AA09-4536-97DB-6E90DFE352F2', 'B81A6572-84B2-401E-B1E8-E73C1B635ABB', '75046ECC-98F6-47BB-88BF-D7C61290E4D0', '14A7B36E-0D6F-43C8-8A8E-6773EF7EE1AE', '81FCFFD5-BBF3-4E80-95D6-D4A15559FF14', '9BD10E63-50F9-4B30-B99D-B4C2368D7759', '78E8B5C4-92A7-41F1-83F9-C597E71E7127') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "2224d83f-70fe-4613-87dc-9eaeacad796f"
  "4b09d4c7-4cab-4368-bd9b-ec01600a0bfb"
  "24e2f5e6-a832-4a75-b205-4080bb2dd42f"
  "95fdd4e1-aa09-4536-97db-6e90dfe352f2"
  "b81a6572-84b2-401e-b1e8-e73c1b635abb"
  "75046ecc-98f6-47bb-88bf-d7c61290e4d0"
  "14a7b36e-0d6f-43c8-8a8e-6773ef7ee1ae"
  "81fcffd5-bbf3-4e80-95d6-d4a15559ff14"
  "9bd10e63-50f9-4b30-b99d-b4c2368d7759"
  "78e8b5c4-92a7-41f1-83f9-c597e71e7127"
]

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 ('2224d83f-70fe-4613-87dc-9eaeacad796f','4b09d4c7-4cab-4368-bd9b-ec01600a0bfb','24e2f5e6-a832-4a75-b205-4080bb2dd42f','95fdd4e1-aa09-4536-97db-6e90dfe352f2','b81a6572-84b2-401e-b1e8-e73c1b635abb','75046ecc-98f6-47bb-88bf-d7c61290e4d0','14a7b36e-0d6f-43c8-8a8e-6773ef7ee1ae','81fcffd5-bbf3-4e80-95d6-d4a15559ff14','9bd10e63-50f9-4b30-b99d-b4c2368d7759','78e8b5c4-92a7-41f1-83f9-c597e71e7127');