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

[
  "A7F77C61-41FF-4130-B9C1-5F15C7F2159B"
  "9CF2E595-CDBD-4D0F-9183-02517FDF387C"
  "63143988-958B-48EC-89DF-974A66CD8E39"
  "8891E931-F2EB-44BA-A407-9F181CD33ED5"
  "A1B2FF7F-1984-4B52-8505-1B69E36E2B50"
  "1447E3FB-EFC3-4522-94A4-292CD79EDD64"
  "713F7FB3-F420-4DAE-BECE-ACCD89DAF06A"
  "7AF8B88F-B436-4B5E-A579-64ABF0060279"
  "2B36B7BB-E3A9-4311-9BB4-3FCDF1F9118E"
  "BBDB6CCF-A039-4DB4-9257-97A729A07D7D"
  "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 ('A7F77C61-41FF-4130-B9C1-5F15C7F2159B', '9CF2E595-CDBD-4D0F-9183-02517FDF387C', '63143988-958B-48EC-89DF-974A66CD8E39', '8891E931-F2EB-44BA-A407-9F181CD33ED5', 'A1B2FF7F-1984-4B52-8505-1B69E36E2B50', '1447E3FB-EFC3-4522-94A4-292CD79EDD64', '713F7FB3-F420-4DAE-BECE-ACCD89DAF06A', '7AF8B88F-B436-4B5E-A579-64ABF0060279', '2B36B7BB-E3A9-4311-9BB4-3FCDF1F9118E', 'BBDB6CCF-A039-4DB4-9257-97A729A07D7D') 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

[
  "A7F77C61-41FF-4130-B9C1-5F15C7F2159B"
  "9CF2E595-CDBD-4D0F-9183-02517FDF387C"
  "63143988-958B-48EC-89DF-974A66CD8E39"
  "8891E931-F2EB-44BA-A407-9F181CD33ED5"
  "A1B2FF7F-1984-4B52-8505-1B69E36E2B50"
  "1447E3FB-EFC3-4522-94A4-292CD79EDD64"
  "713F7FB3-F420-4DAE-BECE-ACCD89DAF06A"
  "7AF8B88F-B436-4B5E-A579-64ABF0060279"
  "2B36B7BB-E3A9-4311-9BB4-3FCDF1F9118E"
  "BBDB6CCF-A039-4DB4-9257-97A729A07D7D"
]

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 ('A7F77C61-41FF-4130-B9C1-5F15C7F2159B', '9CF2E595-CDBD-4D0F-9183-02517FDF387C', '63143988-958B-48EC-89DF-974A66CD8E39', '8891E931-F2EB-44BA-A407-9F181CD33ED5', 'A1B2FF7F-1984-4B52-8505-1B69E36E2B50', '1447E3FB-EFC3-4522-94A4-292CD79EDD64', '713F7FB3-F420-4DAE-BECE-ACCD89DAF06A', '7AF8B88F-B436-4B5E-A579-64ABF0060279', '2B36B7BB-E3A9-4311-9BB4-3FCDF1F9118E', 'BBDB6CCF-A039-4DB4-9257-97A729A07D7D') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "a7f77c61-41ff-4130-b9c1-5f15c7f2159b"
  "9cf2e595-cdbd-4d0f-9183-02517fdf387c"
  "63143988-958b-48ec-89df-974a66cd8e39"
  "8891e931-f2eb-44ba-a407-9f181cd33ed5"
  "a1b2ff7f-1984-4b52-8505-1b69e36e2b50"
  "1447e3fb-efc3-4522-94a4-292cd79edd64"
  "713f7fb3-f420-4dae-bece-accd89daf06a"
  "7af8b88f-b436-4b5e-a579-64abf0060279"
  "2b36b7bb-e3a9-4311-9bb4-3fcdf1f9118e"
  "bbdb6ccf-a039-4db4-9257-97a729a07d7d"
]

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 ('a7f77c61-41ff-4130-b9c1-5f15c7f2159b','9cf2e595-cdbd-4d0f-9183-02517fdf387c','63143988-958b-48ec-89df-974a66cd8e39','8891e931-f2eb-44ba-a407-9f181cd33ed5','a1b2ff7f-1984-4b52-8505-1b69e36e2b50','1447e3fb-efc3-4522-94a4-292cd79edd64','713f7fb3-f420-4dae-bece-accd89daf06a','7af8b88f-b436-4b5e-a579-64abf0060279','2b36b7bb-e3a9-4311-9bb4-3fcdf1f9118e','bbdb6ccf-a039-4db4-9257-97a729a07d7d');