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

[
  "221EFBDF-3C3F-41F5-A93D-F1CE64B16F3C"
  "EC71D1BF-7CD9-494E-A015-73970BBF427C"
  "5575DC96-2C65-4274-8A9D-9673BB1D4A0D"
  "DDBE2588-B3B6-40F5-BF88-9023C5A391D3"
  "CDD51DEF-4C5D-4C44-A91A-BC8DF1E87637"
  "D1804B35-5F34-4DAB-9F1B-4853CC0786BF"
  "858A25DB-14EA-43EB-B7D6-B7BDC29152A6"
  "A39CEA0E-BE2A-410C-8B9C-75DCCAF497E5"
  "B4E646F9-E4D3-493B-9BCD-02E1D8E6BBEC"
  "B7730034-96BA-42EC-B023-E99913CD3FEF"
  "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 ('221EFBDF-3C3F-41F5-A93D-F1CE64B16F3C', 'EC71D1BF-7CD9-494E-A015-73970BBF427C', '5575DC96-2C65-4274-8A9D-9673BB1D4A0D', 'DDBE2588-B3B6-40F5-BF88-9023C5A391D3', 'CDD51DEF-4C5D-4C44-A91A-BC8DF1E87637', 'D1804B35-5F34-4DAB-9F1B-4853CC0786BF', '858A25DB-14EA-43EB-B7D6-B7BDC29152A6', 'A39CEA0E-BE2A-410C-8B9C-75DCCAF497E5', 'B4E646F9-E4D3-493B-9BCD-02E1D8E6BBEC', 'B7730034-96BA-42EC-B023-E99913CD3FEF') 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

[
  "221EFBDF-3C3F-41F5-A93D-F1CE64B16F3C"
  "EC71D1BF-7CD9-494E-A015-73970BBF427C"
  "5575DC96-2C65-4274-8A9D-9673BB1D4A0D"
  "DDBE2588-B3B6-40F5-BF88-9023C5A391D3"
  "CDD51DEF-4C5D-4C44-A91A-BC8DF1E87637"
  "D1804B35-5F34-4DAB-9F1B-4853CC0786BF"
  "858A25DB-14EA-43EB-B7D6-B7BDC29152A6"
  "A39CEA0E-BE2A-410C-8B9C-75DCCAF497E5"
  "B4E646F9-E4D3-493B-9BCD-02E1D8E6BBEC"
  "B7730034-96BA-42EC-B023-E99913CD3FEF"
]

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 ('221EFBDF-3C3F-41F5-A93D-F1CE64B16F3C', 'EC71D1BF-7CD9-494E-A015-73970BBF427C', '5575DC96-2C65-4274-8A9D-9673BB1D4A0D', 'DDBE2588-B3B6-40F5-BF88-9023C5A391D3', 'CDD51DEF-4C5D-4C44-A91A-BC8DF1E87637', 'D1804B35-5F34-4DAB-9F1B-4853CC0786BF', '858A25DB-14EA-43EB-B7D6-B7BDC29152A6', 'A39CEA0E-BE2A-410C-8B9C-75DCCAF497E5', 'B4E646F9-E4D3-493B-9BCD-02E1D8E6BBEC', 'B7730034-96BA-42EC-B023-E99913CD3FEF') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "221efbdf-3c3f-41f5-a93d-f1ce64b16f3c"
  "ec71d1bf-7cd9-494e-a015-73970bbf427c"
  "5575dc96-2c65-4274-8a9d-9673bb1d4a0d"
  "ddbe2588-b3b6-40f5-bf88-9023c5a391d3"
  "cdd51def-4c5d-4c44-a91a-bc8df1e87637"
  "d1804b35-5f34-4dab-9f1b-4853cc0786bf"
  "858a25db-14ea-43eb-b7d6-b7bdc29152a6"
  "a39cea0e-be2a-410c-8b9c-75dccaf497e5"
  "b4e646f9-e4d3-493b-9bcd-02e1d8e6bbec"
  "b7730034-96ba-42ec-b023-e99913cd3fef"
]

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 ('221efbdf-3c3f-41f5-a93d-f1ce64b16f3c','ec71d1bf-7cd9-494e-a015-73970bbf427c','5575dc96-2c65-4274-8a9d-9673bb1d4a0d','ddbe2588-b3b6-40f5-bf88-9023c5a391d3','cdd51def-4c5d-4c44-a91a-bc8df1e87637','d1804b35-5f34-4dab-9f1b-4853cc0786bf','858a25db-14ea-43eb-b7d6-b7bdc29152a6','a39cea0e-be2a-410c-8b9c-75dccaf497e5','b4e646f9-e4d3-493b-9bcd-02e1d8e6bbec','b7730034-96ba-42ec-b023-e99913cd3fef');