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

[
  "48E5A84D-DC89-4A4B-B7E7-8603002ED210"
  "FD356A07-4A2C-4476-835C-8AFDC789E82B"
  "EB3DADDE-919C-4DF0-92E7-10AB3EB1F49F"
  "75857FAE-54F1-40D5-94F4-36306E2B8D0F"
  "35FBB4D0-2520-44CF-884F-B92B13551480"
  "2AC56303-6C41-4CB5-A73A-A6ED8AE1D97C"
  "EC279D80-3BE5-4DE2-A64B-AC75E1525B84"
  "AE9DD0A5-F4A7-4745-AAF4-7E1B39F45420"
  "A3F76BEF-67BD-4FE1-9657-EA54A499D050"
  "908FC9EB-5661-49B7-B1A4-5A76D2215FA7"
  "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 ('48E5A84D-DC89-4A4B-B7E7-8603002ED210', 'FD356A07-4A2C-4476-835C-8AFDC789E82B', 'EB3DADDE-919C-4DF0-92E7-10AB3EB1F49F', '75857FAE-54F1-40D5-94F4-36306E2B8D0F', '35FBB4D0-2520-44CF-884F-B92B13551480', '2AC56303-6C41-4CB5-A73A-A6ED8AE1D97C', 'EC279D80-3BE5-4DE2-A64B-AC75E1525B84', 'AE9DD0A5-F4A7-4745-AAF4-7E1B39F45420', 'A3F76BEF-67BD-4FE1-9657-EA54A499D050', '908FC9EB-5661-49B7-B1A4-5A76D2215FA7') 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

[
  "48E5A84D-DC89-4A4B-B7E7-8603002ED210"
  "FD356A07-4A2C-4476-835C-8AFDC789E82B"
  "EB3DADDE-919C-4DF0-92E7-10AB3EB1F49F"
  "75857FAE-54F1-40D5-94F4-36306E2B8D0F"
  "35FBB4D0-2520-44CF-884F-B92B13551480"
  "2AC56303-6C41-4CB5-A73A-A6ED8AE1D97C"
  "EC279D80-3BE5-4DE2-A64B-AC75E1525B84"
  "AE9DD0A5-F4A7-4745-AAF4-7E1B39F45420"
  "A3F76BEF-67BD-4FE1-9657-EA54A499D050"
  "908FC9EB-5661-49B7-B1A4-5A76D2215FA7"
]

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 ('48E5A84D-DC89-4A4B-B7E7-8603002ED210', 'FD356A07-4A2C-4476-835C-8AFDC789E82B', 'EB3DADDE-919C-4DF0-92E7-10AB3EB1F49F', '75857FAE-54F1-40D5-94F4-36306E2B8D0F', '35FBB4D0-2520-44CF-884F-B92B13551480', '2AC56303-6C41-4CB5-A73A-A6ED8AE1D97C', 'EC279D80-3BE5-4DE2-A64B-AC75E1525B84', 'AE9DD0A5-F4A7-4745-AAF4-7E1B39F45420', 'A3F76BEF-67BD-4FE1-9657-EA54A499D050', '908FC9EB-5661-49B7-B1A4-5A76D2215FA7') 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 (?,?,?,?,?,?,?,?,?,?)

[
  "48e5a84d-dc89-4a4b-b7e7-8603002ed210"
  "fd356a07-4a2c-4476-835c-8afdc789e82b"
  "eb3dadde-919c-4df0-92e7-10ab3eb1f49f"
  "75857fae-54f1-40d5-94f4-36306e2b8d0f"
  "35fbb4d0-2520-44cf-884f-b92b13551480"
  "2ac56303-6c41-4cb5-a73a-a6ed8ae1d97c"
  "ec279d80-3be5-4de2-a64b-ac75e1525b84"
  "ae9dd0a5-f4a7-4745-aaf4-7e1b39f45420"
  "a3f76bef-67bd-4fe1-9657-ea54a499d050"
  "908fc9eb-5661-49b7-b1a4-5a76d2215fa7"
]

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 ('48e5a84d-dc89-4a4b-b7e7-8603002ed210','fd356a07-4a2c-4476-835c-8afdc789e82b','eb3dadde-919c-4df0-92e7-10ab3eb1f49f','75857fae-54f1-40d5-94f4-36306e2b8d0f','35fbb4d0-2520-44cf-884f-b92b13551480','2ac56303-6c41-4cb5-a73a-a6ed8ae1d97c','ec279d80-3be5-4de2-a64b-ac75e1525b84','ae9dd0a5-f4a7-4745-aaf4-7e1b39f45420','a3f76bef-67bd-4fe1-9657-ea54a499d050','908fc9eb-5661-49b7-b1a4-5a76d2215fa7');