Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.52 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.98 ms

SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3 FROM config t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key AS key_2,
  t0.value AS value_3
FROM
  config t0

SELECT t0.id AS id_1, t0.key AS key_2, t0.value AS value_3 FROM config t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 21)
5	App\Manager\ConfigManager->__construct (line 29)
6	Container7DjD19V\getConfigManagerService::do (line 580)
7	Container7DjD19V\App_KernelDevDebugContainer->load (line 39)
8	Container7DjD19V\getMailerService::do (line 580)
9	Container7DjD19V\App_KernelDevDebugContainer->load (line 43)
10	Container7DjD19V\getZmluvaManagerService::do (line 580)
11	Container7DjD19V\App_KernelDevDebugContainer->load (line 30)
12	Container7DjD19V\getZmluvaPdfGeneratorService::do (line 580)
13	Container7DjD19V\App_KernelDevDebugContainer->load (line 33)
14	Container7DjD19V\getAgentManagerService::do (line 580)
15	Container7DjD19V\App_KernelDevDebugContainer->load (line 38)
16	Container7DjD19V\getUcetManagerService::do (line 580)
17	Container7DjD19V\App_KernelDevDebugContainer->load (line 28)
18	Container7DjD19V\getTatrabankaManagerService::do (line 580)
19	Container7DjD19V\App_KernelDevDebugContainer->load (line 24)
20	Container7DjD19V\getTatrabankaControllerService::do (line 580)
21	Container7DjD19V\App_KernelDevDebugContainer->load (line 229)
22	Symfony\Component\DependencyInjection\Container::make (line 211)
23	Symfony\Component\DependencyInjection\Container->get (line 40)
24	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
25	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
26	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
27	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
28	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 19)

2.54 ms

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.refresh_token AS refresh_token_3, t0.code_verifier AS code_verifier_4, t0.code_chalenge AS code_chalenge_5, t0.created_at AS created_at_6 FROM tb_access_token t0 WHERE t0.id = ?

Parameters:

[
  "2c3ddc20-6699-d377-0e06-ce5970861202"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.access_token AS access_token_2,
  t0.refresh_token AS refresh_token_3,
  t0.code_verifier AS code_verifier_4,
  t0.code_chalenge AS code_chalenge_5,
  t0.created_at AS created_at_6
FROM
  tb_access_token t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.refresh_token AS refresh_token_3, t0.code_verifier AS code_verifier_4, t0.code_chalenge AS code_chalenge_5, t0.created_at AS created_at_6 FROM tb_access_token t0 WHERE t0.id = '2c3ddc20-6699-d377-0e06-ce5970861202';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 501)
5	App\Intergacia\Tatrabanka\TatrabankaManager->findAccessToken (line 610)
6	App\Intergacia\Tatrabanka\TatrabankaManager->refreshAccessToken (line 132)
7	App\Intergacia\Tatrabanka\TatrabankaManager->processUpdate (line 39)
8	App\Controller\TatrabankaController->retrieveTransactions (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 19)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Config	No errors.
App\Entity\TbAccessToken	No errors.

Symfony Profiler

GET https://sezam.space/bank/cron-transactions-retrieve

Configuration Settings

Theme