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

[
  "C4465531-F52D-43C8-8874-C43377D982D0"
  "1BFE9DF8-F3E1-48E0-8B0A-586ACD056FA2"
  "2F7CDB61-8927-4FF4-B134-6D55B0B9BB5B"
  "24A4C02D-7ECD-492C-A7EC-48B9047DF85A"
  "A695C600-4701-4C88-BB1B-876BC80C90A8"
  "10A7449A-DE99-45F1-83AB-13DE7536305E"
  "260FC396-A6C4-4403-A256-AA361FFEC205"
  "67D8CDF7-A34A-4F0A-AF11-8DBB021192C1"
  "950E8628-1EC8-4A31-BA1E-69A5955B6813"
  "ED16BC7F-2A5D-4D92-A1A9-25FF2E7A2EF5"
  "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 ('C4465531-F52D-43C8-8874-C43377D982D0', '1BFE9DF8-F3E1-48E0-8B0A-586ACD056FA2', '2F7CDB61-8927-4FF4-B134-6D55B0B9BB5B', '24A4C02D-7ECD-492C-A7EC-48B9047DF85A', 'A695C600-4701-4C88-BB1B-876BC80C90A8', '10A7449A-DE99-45F1-83AB-13DE7536305E', '260FC396-A6C4-4403-A256-AA361FFEC205', '67D8CDF7-A34A-4F0A-AF11-8DBB021192C1', '950E8628-1EC8-4A31-BA1E-69A5955B6813', 'ED16BC7F-2A5D-4D92-A1A9-25FF2E7A2EF5') 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

[
  "C4465531-F52D-43C8-8874-C43377D982D0"
  "1BFE9DF8-F3E1-48E0-8B0A-586ACD056FA2"
  "2F7CDB61-8927-4FF4-B134-6D55B0B9BB5B"
  "24A4C02D-7ECD-492C-A7EC-48B9047DF85A"
  "A695C600-4701-4C88-BB1B-876BC80C90A8"
  "10A7449A-DE99-45F1-83AB-13DE7536305E"
  "260FC396-A6C4-4403-A256-AA361FFEC205"
  "67D8CDF7-A34A-4F0A-AF11-8DBB021192C1"
  "950E8628-1EC8-4A31-BA1E-69A5955B6813"
  "ED16BC7F-2A5D-4D92-A1A9-25FF2E7A2EF5"
]

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 ('C4465531-F52D-43C8-8874-C43377D982D0', '1BFE9DF8-F3E1-48E0-8B0A-586ACD056FA2', '2F7CDB61-8927-4FF4-B134-6D55B0B9BB5B', '24A4C02D-7ECD-492C-A7EC-48B9047DF85A', 'A695C600-4701-4C88-BB1B-876BC80C90A8', '10A7449A-DE99-45F1-83AB-13DE7536305E', '260FC396-A6C4-4403-A256-AA361FFEC205', '67D8CDF7-A34A-4F0A-AF11-8DBB021192C1', '950E8628-1EC8-4A31-BA1E-69A5955B6813', 'ED16BC7F-2A5D-4D92-A1A9-25FF2E7A2EF5') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "c4465531-f52d-43c8-8874-c43377d982d0"
  "1bfe9df8-f3e1-48e0-8b0a-586acd056fa2"
  "2f7cdb61-8927-4ff4-b134-6d55b0b9bb5b"
  "24a4c02d-7ecd-492c-a7ec-48b9047df85a"
  "a695c600-4701-4c88-bb1b-876bc80c90a8"
  "10a7449a-de99-45f1-83ab-13de7536305e"
  "260fc396-a6c4-4403-a256-aa361ffec205"
  "67d8cdf7-a34a-4f0a-af11-8dbb021192c1"
  "950e8628-1ec8-4a31-ba1e-69a5955b6813"
  "ed16bc7f-2a5d-4d92-a1a9-25ff2e7a2ef5"
]

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 ('c4465531-f52d-43c8-8874-c43377d982d0','1bfe9df8-f3e1-48e0-8b0a-586acd056fa2','2f7cdb61-8927-4ff4-b134-6d55b0b9bb5b','24a4c02d-7ecd-492c-a7ec-48b9047df85a','a695c600-4701-4c88-bb1b-876bc80c90a8','10a7449a-de99-45f1-83ab-13de7536305e','260fc396-a6c4-4403-a256-aa361ffec205','67d8cdf7-a34a-4f0a-af11-8dbb021192c1','950e8628-1ec8-4a31-ba1e-69a5955b6813','ed16bc7f-2a5d-4d92-a1a9-25ff2e7a2ef5');