Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

4.77 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.31 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	Doctrine\DBAL\Connection->getDatabase (line 161)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 1458)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 208)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
6	App\Repository\OwnerRepository->getAll (line 44)
7	App\Service\OwnerProfileService->App\Service\{closure} (line 43)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
9	Symfony\Component\Cache\Adapter\ChainAdapter::Symfony\Component\Cache\Adapter\{closure} (line 98)
10	Symfony\Component\Cache\LockRegistry::compute (line 98)
11	Symfony\Component\Cache\Adapter\ChainAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
12	Symfony\Component\Cache\Adapter\ChainAdapter->contractsGet (line 67)
13	Symfony\Component\Cache\Adapter\ChainAdapter->doGet (line 85)
14	Symfony\Component\Cache\Adapter\ChainAdapter->Symfony\Component\Cache\Adapter\{closure} (line 115)
15	Symfony\Component\Cache\LockRegistry->compute (line 113)
16	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
18	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
19	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
20	Symfony\Component\Cache\Adapter\ChainAdapter->Symfony\Component\Cache\Adapter\{closure} (line 113)
21	Symfony\Component\Cache\Adapter\ChainAdapter->get (line 125)
22	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
23	App\Service\OwnerProfileService->getProfile (line 40)
24	App\EventSubscriber\TwigGlobalSubscriber->__invoke (line 58)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 5)

1.80 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "craiova_amme_skeleton_api"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'craiova_amme_skeleton_api'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 360)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 207)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
4	App\Repository\OwnerRepository->getAll (line 44)
5	App\Service\OwnerProfileService->App\Service\{closure} (line 43)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
7	Symfony\Component\Cache\Adapter\ChainAdapter::Symfony\Component\Cache\Adapter\{closure} (line 98)
8	Symfony\Component\Cache\LockRegistry::compute (line 98)
9	Symfony\Component\Cache\Adapter\ChainAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
10	Symfony\Component\Cache\Adapter\ChainAdapter->contractsGet (line 67)
11	Symfony\Component\Cache\Adapter\ChainAdapter->doGet (line 85)
12	Symfony\Component\Cache\Adapter\ChainAdapter->Symfony\Component\Cache\Adapter\{closure} (line 115)
13	Symfony\Component\Cache\LockRegistry->compute (line 113)
14	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
16	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
17	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
18	Symfony\Component\Cache\Adapter\ChainAdapter->Symfony\Component\Cache\Adapter\{closure} (line 113)
19	Symfony\Component\Cache\Adapter\ChainAdapter->get (line 125)
20	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
21	App\Service\OwnerProfileService->getProfile (line 40)
22	App\EventSubscriber\TwigGlobalSubscriber->__invoke (line 58)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

2.66 ms

SELECT `key`, `value` FROM `owner`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `key`,
  `value`
FROM
  `owner`

SELECT `key`, `value` FROM `owner`;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 622)
2	App\Repository\OwnerRepository->getAll (line 50)
3	App\Service\OwnerProfileService->App\Service\{closure} (line 43)
4	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
5	Symfony\Component\Cache\Adapter\ChainAdapter::Symfony\Component\Cache\Adapter\{closure} (line 98)
6	Symfony\Component\Cache\LockRegistry::compute (line 98)
7	Symfony\Component\Cache\Adapter\ChainAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
8	Symfony\Component\Cache\Adapter\ChainAdapter->contractsGet (line 67)
9	Symfony\Component\Cache\Adapter\ChainAdapter->doGet (line 85)
10	Symfony\Component\Cache\Adapter\ChainAdapter->Symfony\Component\Cache\Adapter\{closure} (line 115)
11	Symfony\Component\Cache\LockRegistry->compute (line 113)
12	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 67)
14	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
15	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
16	Symfony\Component\Cache\Adapter\ChainAdapter->Symfony\Component\Cache\Adapter\{closure} (line 113)
17	Symfony\Component\Cache\Adapter\ChainAdapter->get (line 125)
18	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
19	App\Service\OwnerProfileService->getProfile (line 40)
20	App\EventSubscriber\TwigGlobalSubscriber->__invoke (line 58)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

No managed entities.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://www.skeleton-api.amme.ro/ro/terms-and-conditions

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

Entities Mapping