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

[
  "0DE81547-21D9-4637-82B1-A0A537D65BB6"
  "650F0075-9EF5-49D1-B352-C182C80AD4B8"
  "9A1953E4-6775-469E-B3F3-24736CF588C2"
  "8820AAB0-C7CB-4DAA-8094-2C59F43A7A2D"
  "E57C46F5-A9C6-413D-83E9-339BDB29E4A0"
  "F49DBB7E-0911-4EAE-AEE2-F0B437A9576D"
  "ECAA407F-B587-4ADE-AF41-D7F0DE3E36F3"
  "F6A6A520-997A-4E5A-B9A7-6465C00C8C05"
  "6F1A2181-5491-4988-817D-8E079A945FE2"
  "FC67C5A5-B9E6-4296-9B53-957A99D890B7"
  "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 ('0DE81547-21D9-4637-82B1-A0A537D65BB6', '650F0075-9EF5-49D1-B352-C182C80AD4B8', '9A1953E4-6775-469E-B3F3-24736CF588C2', '8820AAB0-C7CB-4DAA-8094-2C59F43A7A2D', 'E57C46F5-A9C6-413D-83E9-339BDB29E4A0', 'F49DBB7E-0911-4EAE-AEE2-F0B437A9576D', 'ECAA407F-B587-4ADE-AF41-D7F0DE3E36F3', 'F6A6A520-997A-4E5A-B9A7-6465C00C8C05', '6F1A2181-5491-4988-817D-8E079A945FE2', 'FC67C5A5-B9E6-4296-9B53-957A99D890B7') 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

[
  "0DE81547-21D9-4637-82B1-A0A537D65BB6"
  "650F0075-9EF5-49D1-B352-C182C80AD4B8"
  "9A1953E4-6775-469E-B3F3-24736CF588C2"
  "8820AAB0-C7CB-4DAA-8094-2C59F43A7A2D"
  "E57C46F5-A9C6-413D-83E9-339BDB29E4A0"
  "F49DBB7E-0911-4EAE-AEE2-F0B437A9576D"
  "ECAA407F-B587-4ADE-AF41-D7F0DE3E36F3"
  "F6A6A520-997A-4E5A-B9A7-6465C00C8C05"
  "6F1A2181-5491-4988-817D-8E079A945FE2"
  "FC67C5A5-B9E6-4296-9B53-957A99D890B7"
]

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 ('0DE81547-21D9-4637-82B1-A0A537D65BB6', '650F0075-9EF5-49D1-B352-C182C80AD4B8', '9A1953E4-6775-469E-B3F3-24736CF588C2', '8820AAB0-C7CB-4DAA-8094-2C59F43A7A2D', 'E57C46F5-A9C6-413D-83E9-339BDB29E4A0', 'F49DBB7E-0911-4EAE-AEE2-F0B437A9576D', 'ECAA407F-B587-4ADE-AF41-D7F0DE3E36F3', 'F6A6A520-997A-4E5A-B9A7-6465C00C8C05', '6F1A2181-5491-4988-817D-8E079A945FE2', 'FC67C5A5-B9E6-4296-9B53-957A99D890B7') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "0de81547-21d9-4637-82b1-a0a537d65bb6"
  "650f0075-9ef5-49d1-b352-c182c80ad4b8"
  "9a1953e4-6775-469e-b3f3-24736cf588c2"
  "8820aab0-c7cb-4daa-8094-2c59f43a7a2d"
  "e57c46f5-a9c6-413d-83e9-339bdb29e4a0"
  "f49dbb7e-0911-4eae-aee2-f0b437a9576d"
  "ecaa407f-b587-4ade-af41-d7f0de3e36f3"
  "f6a6a520-997a-4e5a-b9a7-6465c00c8c05"
  "6f1a2181-5491-4988-817d-8e079a945fe2"
  "fc67c5a5-b9e6-4296-9b53-957a99d890b7"
]

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 ('0de81547-21d9-4637-82b1-a0a537d65bb6','650f0075-9ef5-49d1-b352-c182c80ad4b8','9a1953e4-6775-469e-b3f3-24736cf588c2','8820aab0-c7cb-4daa-8094-2c59f43a7a2d','e57c46f5-a9c6-413d-83e9-339bdb29e4a0','f49dbb7e-0911-4eae-aee2-f0b437a9576d','ecaa407f-b587-4ade-af41-d7f0de3e36f3','f6a6a520-997a-4e5a-b9a7-6465c00c8c05','6f1a2181-5491-4988-817d-8e079a945fe2','fc67c5a5-b9e6-4296-9b53-957a99d890b7');