Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.47 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.83 ms

SELECT d0_.id AS id_0, d0_.file AS file_1, d0_.document_file AS document_file_2, d0_.updated_at AS updated_at_3, d0_.customer_id AS customer_id_4, d0_.type AS type_5, d0_.validity_date AS validity_date_6, d0_.document_number AS document_number_7, d0_.is_available AS is_available_8, d0_.document_date AS document_date_9 FROM document d0_ WHERE d0_.is_available = ? ORDER BY d0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.file AS file_1,
  d0_.document_file AS document_file_2,
  d0_.updated_at AS updated_at_3,
  d0_.customer_id AS customer_id_4,
  d0_.type AS type_5,
  d0_.validity_date AS validity_date_6,
  d0_.document_number AS document_number_7,
  d0_.is_available AS is_available_8,
  d0_.document_date AS document_date_9
FROM
  document d0_
WHERE
  d0_.is_available = ?
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.file AS file_1, d0_.document_file AS document_file_2, d0_.updated_at AS updated_at_3, d0_.customer_id AS customer_id_4, d0_.type AS type_5, d0_.validity_date AS validity_date_6, d0_.document_number AS document_number_7, d0_.is_available AS is_available_8, d0_.document_date AS document_date_9 FROM document d0_ WHERE d0_.is_available = 1 ORDER BY d0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 81)
7	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 79)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 94)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 120)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 20)

0.64 ms

SELECT t0.id AS id_1, t0.webshop_type AS webshop_type_2, t0.is_kpi AS is_kpi_3, t0.url_kpi AS url_kpi_4, t0.name_kpi AS name_kpi_5, t0.user_count AS user_count_6 FROM admin_parameters t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.webshop_type AS webshop_type_2,
  t0.is_kpi AS is_kpi_3,
  t0.url_kpi AS url_kpi_4,
  t0.name_kpi AS name_kpi_5,
  t0.user_count AS user_count_6
FROM
  admin_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.webshop_type AS webshop_type_2, t0.is_kpi AS is_kpi_3, t0.url_kpi AS url_kpi_4, t0.name_kpi AS name_kpi_5, t0.user_count AS user_count_6 FROM admin_parameters t0 WHERE t0.id = 1;

#	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 196)
5	Doctrine\ORM\EntityRepository->find (line 27)
6	App\Security\Voter\DeliveryAddressVoter->__construct (line 43)
7	ContainerTQBrLZH\getDeliveryAddressVoterService::do (line 720)
8	ContainerTQBrLZH\App_KernelDevDebugContainer->load (line 1914)
9	ContainerTQBrLZH\App_KernelDevDebugContainer::{closure:ContainerTQBrLZH\App_KernelDevDebugContainer::getDebug_Security_Access_DecisionManagerService():1909} (line 131)
10	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 158)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AdminParameters	1

Entities Mapping

Class	Mapping errors
App\Entity\Document	No errors.
App\Entity\AdminParameters	No errors.

Symfony Profiler

GET https://bivteam.shop/adminApi/documents?isAvailable=1

Configuration Settings

Theme

Page Width