Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.68 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.53 ms
(32.57%)

SELECT a0_.id AS id_0, a0_.original_name AS original_name_1, a0_.file_name AS file_name_2, a0_.mime_type AS mime_type_3, a0_.size AS size_4, a0_.path AS path_5, a0_.entity_type AS entity_type_6, a0_.entity_id AS entity_id_7, a0_.category AS category_8, a0_.description AS description_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12 FROM adjunto a0_ WHERE a0_.entity_type = ? AND a0_.entity_id = ? AND a0_.deleted_at IS NULL ORDER BY a0_.created_at DESC

Parameters:

[
  "tenant"
  381497
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.original_name AS original_name_1,
  a0_.file_name AS file_name_2,
  a0_.mime_type AS mime_type_3,
  a0_.size AS size_4,
  a0_.path AS path_5,
  a0_.entity_type AS entity_type_6,
  a0_.entity_id AS entity_id_7,
  a0_.category AS category_8,
  a0_.description AS description_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.deleted_at AS deleted_at_12
FROM
  adjunto a0_
WHERE
  a0_.entity_type = ?
  AND a0_.entity_id = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.original_name AS original_name_1, a0_.file_name AS file_name_2, a0_.mime_type AS mime_type_3, a0_.size AS size_4, a0_.path AS path_5, a0_.entity_type AS entity_type_6, a0_.entity_id AS entity_id_7, a0_.category AS category_8, a0_.description AS description_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12 FROM adjunto a0_ WHERE a0_.entity_type = 'tenant' AND a0_.entity_id = 381497 AND a0_.deleted_at IS NULL ORDER BY a0_.created_at DESC;

#	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->getResult (line 688)
6	App\Repository\AttachmentRepository->findByEntity (line 32)
7	App\Controller\TenantController->edit (line 646)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.21 ms
(25.75%)

SELECT t0.id AS id_1, t0.street AS street_2, t0.between_street1 AS between_street1_3, t0.between_street2 AS between_street2_4, t0.number AS number_5, t0.floor AS floor_6, t0.apartment AS apartment_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.province AS province_10, t0.country AS country_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14 FROM address t0 WHERE t0.id = ?

Parameters:

[
  "58221"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.between_street1 AS between_street1_3,
  t0.between_street2 AS between_street2_4,
  t0.number AS number_5,
  t0.floor AS floor_6,
  t0.apartment AS apartment_7,
  t0.postal_code AS postal_code_8,
  t0.city AS city_9,
  t0.province AS province_10,
  t0.country AS country_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.between_street1 AS between_street1_3, t0.between_street2 AS between_street2_4, t0.number AS number_5, t0.floor AS floor_6, t0.apartment AS apartment_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.province AS province_10, t0.country AS country_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14 FROM address t0 WHERE t0.id = '58221';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Address::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Address->__get (line 153)
7	App\Entity\Address->getStreet (line 83)
8	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
10	Symfony\Component\Form\Extension\Core\DataAccessor\PropertyPathAccessor->getPropertyValue (line 97)
11	Symfony\Component\Form\Extension\Core\DataAccessor\PropertyPathAccessor->getValue (line 48)
12	Symfony\Component\Form\Extension\Core\DataAccessor\ChainAccessor->getValue (line 35)
13	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 50)
14	Symfony\Component\Form\Form->setData (line 317)
15	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 50)
16	Symfony\Component\Form\Form->setData (line 317)
17	Symfony\Component\Form\Form->initialize (line 406)
18	Symfony\Component\Form\FormBuilder->getForm (line 171)
19	Symfony\Component\Form\FormFactory->create (line 26)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 355)
21	App\Controller\TenantController->edit (line 605)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

1.08 ms
(23.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.email_verified_at AS email_verified_at_4, t0.password AS password_5, t0.remember_token AS remember_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.roles AS roles_10 FROM user t0 WHERE t0.id = ?

Parameters:

[
  461
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.email_verified_at AS email_verified_at_4,
  t0.password AS password_5,
  t0.remember_token AS remember_token_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.roles AS roles_10
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.email_verified_at AS email_verified_at_4, t0.password AS password_5, t0.remember_token AS remember_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.roles AS roles_10 FROM user t0 WHERE t0.id = 461;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.87 ms
(18.68%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.document_type AS document_type_5, t0.document_number AS document_number_6, t0.cuit_cuil AS cuit_cuil_7, t0.nro_contrib AS nro_contrib_8, t0.marital_status AS marital_status_9, t0.type AS type_10, t0.phone AS phone_11, t0.email AS email_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.address_id AS address_id_16 FROM tenant t0 WHERE t0.id = ?

Parameters:

[
  "381497"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.last_name AS last_name_3,
  t0.first_name AS first_name_4,
  t0.document_type AS document_type_5,
  t0.document_number AS document_number_6,
  t0.cuit_cuil AS cuit_cuil_7,
  t0.nro_contrib AS nro_contrib_8,
  t0.marital_status AS marital_status_9,
  t0.type AS type_10,
  t0.phone AS phone_11,
  t0.email AS email_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.address_id AS address_id_16
FROM
  tenant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.document_type AS document_type_5, t0.document_number AS document_number_6, t0.cuit_cuil AS cuit_cuil_7, t0.nro_contrib AS nro_contrib_8, t0.marital_status AS marital_status_9, t0.type AS type_10, t0.phone AS phone_11, t0.email AS email_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.address_id AS address_id_16 FROM tenant t0 WHERE t0.id = '381497';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

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\User	1
App\Entity\Tenant	1
App\Entity\Address	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Movement	No errors.
App\Entity\Tenant	No errors.
App\Entity\Address	No errors.
App\Entity\PlotTenant	No errors.
App\Entity\Deceased	No errors.
App\Entity\Title	No errors.
App\Entity\Procedure	No errors.
App\Entity\Invoice	No errors.
App\Entity\Debt	No errors.
App\Entity\Attachment	No errors.

Symfony Profiler

GET https://webbrown2.brown.gob.ar/arrendatarios/381497/editar?deceased_id=58696&is_co_tenant=0

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping