Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

253.60 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

ki_management connection

Time▼

Count

Info

59.23 ms
(23.35%)

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 620 ROWS FETCH NEXT 10 ROWS ONLY

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
  620
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 620 ROWS FETCH NEXT 10 ROWS ONLY;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\KIManagement\Repository\MessageRepository->findSessionSummaries (line 61)
7	App\KIManagement\Service\ConversationService->getPaginatedSessions (line 35)
8	App\Controller\KIManagementConversationController->index (line 49)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

53.68 ms
(21.17%)

SELECT LOWER(CAST(Id AS NVARCHAR(36))) AS id, Name
                   FROM dbo.Sessions
                   WHERE LOWER(CAST(Id AS NVARCHAR(36))) IN (?,?,?,?,?,?,?,?,?,?)

Parameters:

[
  "d3158c56-f646-48f2-94fa-0cc6d8d26b7f"
  "5eecf1a0-9b3f-4256-8e4a-ee391adf1740"
  "04d291e0-ed5d-4b79-91c6-7fd793644574"
  "4fd4865e-6182-4dd4-8657-936ca7f9bf7c"
  "edcd0dbe-6843-4bec-885c-2810282c8b94"
  "96f0a788-4391-4d16-8717-027c00b5e095"
  "afe91adf-10b8-4c1c-8c95-76d3f08d14a7"
  "47e14cb2-b91a-46e7-a457-e876e441aa58"
  "30357cca-7c97-4dc6-a95f-79c181f95f87"
  "3da4c1af-8ed0-4f26-88d1-b284a8deb0bf"
]

View formatted query View runnable query Explain query View query backtrace

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 ('d3158c56-f646-48f2-94fa-0cc6d8d26b7f','5eecf1a0-9b3f-4256-8e4a-ee391adf1740','04d291e0-ed5d-4b79-91c6-7fd793644574','4fd4865e-6182-4dd4-8657-936ca7f9bf7c','edcd0dbe-6843-4bec-885c-2810282c8b94','96f0a788-4391-4d16-8717-027c00b5e095','afe91adf-10b8-4c1c-8c95-76d3f08d14a7','47e14cb2-b91a-46e7-a457-e876e441aa58','30357cca-7c97-4dc6-a95f-79c181f95f87','3da4c1af-8ed0-4f26-88d1-b284a8deb0bf');

#	File/Call
1	App\KIManagement\Service\ConversationService->loadSessionNames (line 406)
2	App\KIManagement\Service\ConversationService->getPaginatedSessions (line 82)
3	App\Controller\KIManagementConversationController->index (line 49)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

48.25 ms
(19.03%)

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

Parameters:

[
  "D3158C56-F646-48F2-94FA-0CC6D8D26B7F"
  "5EECF1A0-9B3F-4256-8E4A-EE391ADF1740"
  "04D291E0-ED5D-4B79-91C6-7FD793644574"
  "4FD4865E-6182-4DD4-8657-936CA7F9BF7C"
  "EDCD0DBE-6843-4BEC-885C-2810282C8B94"
  "96F0A788-4391-4D16-8717-027C00B5E095"
  "AFE91ADF-10B8-4C1C-8C95-76D3F08D14A7"
  "47E14CB2-B91A-46E7-A457-E876E441AA58"
  "30357CCA-7C97-4DC6-A95F-79C181F95F87"
  "3DA4C1AF-8ED0-4F26-88D1-B284A8DEB0BF"
]

View formatted query View runnable query Explain query View query backtrace

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 ('D3158C56-F646-48F2-94FA-0CC6D8D26B7F', '5EECF1A0-9B3F-4256-8E4A-EE391ADF1740', '04D291E0-ED5D-4B79-91C6-7FD793644574', '4FD4865E-6182-4DD4-8657-936CA7F9BF7C', 'EDCD0DBE-6843-4BEC-885C-2810282C8B94', '96F0A788-4391-4D16-8717-027C00B5E095', 'AFE91ADF-10B8-4C1C-8C95-76D3F08D14A7', '47E14CB2-B91A-46E7-A457-E876E441AA58', '30357CCA-7C97-4DC6-A95F-79C181F95F87', '3DA4C1AF-8ED0-4F26-88D1-B284A8DEB0BF') GROUP BY s0_.ChatSessionId;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\KIManagement\Repository\ContextChunkRepository->countDistinctSourcesForSessionIds (line 58)
7	App\KIManagement\Service\ConversationService->getPaginatedSessions (line 72)
8	App\Controller\KIManagementConversationController->index (line 49)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

46.53 ms
(18.35%)

SELECT COUNT(DISTINCT m0_.SessionId) AS sclr_0 FROM dbo.Messages m0_ WHERE m0_.SessionId IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\KIManagement\Repository\MessageRepository->countSessions (line 79)
8	App\KIManagement\Service\ConversationService->getPaginatedSessions (line 34)
9	App\Controller\KIManagementConversationController->index (line 49)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

45.92 ms
(18.11%)

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

Parameters:

[
  "D3158C56-F646-48F2-94FA-0CC6D8D26B7F"
  "5EECF1A0-9B3F-4256-8E4A-EE391ADF1740"
  "04D291E0-ED5D-4B79-91C6-7FD793644574"
  "4FD4865E-6182-4DD4-8657-936CA7F9BF7C"
  "EDCD0DBE-6843-4BEC-885C-2810282C8B94"
  "96F0A788-4391-4D16-8717-027C00B5E095"
  "AFE91ADF-10B8-4C1C-8C95-76D3F08D14A7"
  "47E14CB2-B91A-46E7-A457-E876E441AA58"
  "30357CCA-7C97-4DC6-A95F-79C181F95F87"
  "3DA4C1AF-8ED0-4F26-88D1-B284A8DEB0BF"
  "system"
]

View formatted query View runnable query Explain query View query backtrace

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 ('D3158C56-F646-48F2-94FA-0CC6D8D26B7F', '5EECF1A0-9B3F-4256-8E4A-EE391ADF1740', '04D291E0-ED5D-4B79-91C6-7FD793644574', '4FD4865E-6182-4DD4-8657-936CA7F9BF7C', 'EDCD0DBE-6843-4BEC-885C-2810282C8B94', '96F0A788-4391-4D16-8717-027C00B5E095', 'AFE91ADF-10B8-4C1C-8C95-76D3F08D14A7', '47E14CB2-B91A-46E7-A457-E876E441AA58', '30357CCA-7C97-4DC6-A95F-79C181F95F87', '3DA4C1AF-8ED0-4F26-88D1-B284A8DEB0BF') AND LOWER(m0_.Role) <> 'system' GROUP BY m0_.SessionId;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\KIManagement\Repository\MessageRepository->findNonSystemMessageStats (line 291)
7	App\KIManagement\Service\ConversationService->getPaginatedSessions (line 61)
8	App\Controller\KIManagementConversationController->index (line 49)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
ki_management	doctrine.dbal.ki_management_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
management	doctrine.orm.management_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

management entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

No loaded entities.

management entity manager

Class	Mapping errors
App\KIManagement\Entity\Message	No errors.
App\KIManagement\Entity\ContextChunk	No errors.

Symfony Profiler

GET https://ai-analytics-tool.staging.webwerk.at/ki-management/conversations?page=63&view=conversations

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

ki_management connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

management entity manager

Entities Mapping

default entity manager

management entity manager