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

[
  "78D036AC-8FAD-4533-B5C4-ED25F16A9347"
  "F0409804-54D0-4B9A-A5A1-E1DC6FB0BD68"
  "8CF63977-F561-4F8D-A2C9-328ADCA049D0"
  "6C0E5D6F-F40C-4C6D-BDFF-82E2E806EDB2"
  "C7850BFB-B2D8-41D2-877F-4BE8E83BB8F6"
  "CC544464-2A9A-432A-9A5F-8FBDCDBE4710"
  "764619C7-4D13-4646-A9CC-671CC157BBE3"
  "9F190D3E-8CD7-41E1-9915-7A957E075FDC"
  "1CD8173F-8F89-4689-8D66-F27CFD60F0D3"
  "0442CBD2-662E-4634-A988-676ABCBA1D18"
  "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 ('78D036AC-8FAD-4533-B5C4-ED25F16A9347', 'F0409804-54D0-4B9A-A5A1-E1DC6FB0BD68', '8CF63977-F561-4F8D-A2C9-328ADCA049D0', '6C0E5D6F-F40C-4C6D-BDFF-82E2E806EDB2', 'C7850BFB-B2D8-41D2-877F-4BE8E83BB8F6', 'CC544464-2A9A-432A-9A5F-8FBDCDBE4710', '764619C7-4D13-4646-A9CC-671CC157BBE3', '9F190D3E-8CD7-41E1-9915-7A957E075FDC', '1CD8173F-8F89-4689-8D66-F27CFD60F0D3', '0442CBD2-662E-4634-A988-676ABCBA1D18') 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

[
  "78D036AC-8FAD-4533-B5C4-ED25F16A9347"
  "F0409804-54D0-4B9A-A5A1-E1DC6FB0BD68"
  "8CF63977-F561-4F8D-A2C9-328ADCA049D0"
  "6C0E5D6F-F40C-4C6D-BDFF-82E2E806EDB2"
  "C7850BFB-B2D8-41D2-877F-4BE8E83BB8F6"
  "CC544464-2A9A-432A-9A5F-8FBDCDBE4710"
  "764619C7-4D13-4646-A9CC-671CC157BBE3"
  "9F190D3E-8CD7-41E1-9915-7A957E075FDC"
  "1CD8173F-8F89-4689-8D66-F27CFD60F0D3"
  "0442CBD2-662E-4634-A988-676ABCBA1D18"
]

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 ('78D036AC-8FAD-4533-B5C4-ED25F16A9347', 'F0409804-54D0-4B9A-A5A1-E1DC6FB0BD68', '8CF63977-F561-4F8D-A2C9-328ADCA049D0', '6C0E5D6F-F40C-4C6D-BDFF-82E2E806EDB2', 'C7850BFB-B2D8-41D2-877F-4BE8E83BB8F6', 'CC544464-2A9A-432A-9A5F-8FBDCDBE4710', '764619C7-4D13-4646-A9CC-671CC157BBE3', '9F190D3E-8CD7-41E1-9915-7A957E075FDC', '1CD8173F-8F89-4689-8D66-F27CFD60F0D3', '0442CBD2-662E-4634-A988-676ABCBA1D18') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "78d036ac-8fad-4533-b5c4-ed25f16a9347"
  "f0409804-54d0-4b9a-a5a1-e1dc6fb0bd68"
  "8cf63977-f561-4f8d-a2c9-328adca049d0"
  "6c0e5d6f-f40c-4c6d-bdff-82e2e806edb2"
  "c7850bfb-b2d8-41d2-877f-4be8e83bb8f6"
  "cc544464-2a9a-432a-9a5f-8fbdcdbe4710"
  "764619c7-4d13-4646-a9cc-671cc157bbe3"
  "9f190d3e-8cd7-41e1-9915-7a957e075fdc"
  "1cd8173f-8f89-4689-8d66-f27cfd60f0d3"
  "0442cbd2-662e-4634-a988-676abcba1d18"
]

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 ('78d036ac-8fad-4533-b5c4-ed25f16a9347','f0409804-54d0-4b9a-a5a1-e1dc6fb0bd68','8cf63977-f561-4f8d-a2c9-328adca049d0','6c0e5d6f-f40c-4c6d-bdff-82e2e806edb2','c7850bfb-b2d8-41d2-877f-4be8e83bb8f6','cc544464-2a9a-432a-9a5f-8fbdcdbe4710','764619c7-4d13-4646-a9cc-671cc157bbe3','9f190d3e-8cd7-41e1-9915-7a957e075fdc','1cd8173f-8f89-4689-8d66-f27cfd60f0d3','0442cbd2-662e-4634-a988-676abcba1d18');