Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.15 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.15 ms
(36.60%)

SELECT t0.id AS id_1, t0.rut AS rut_2, t0.razon_social AS razon_social_3, t0.activa AS activa_4, t0.medipass_key AS medipass_key_5, t0.imed_key AS imed_key_6, t0.salesforce_id AS salesforce_id_7, t0.exists_in_salesforce AS exists_in_salesforce_8, t0.origen AS origen_9, t0.last_sync_at AS last_sync_at_10, t0.salesforce_parent_id AS salesforce_parent_id_11, t0.is_holding AS is_holding_12, t0.codigo_actividad AS codigo_actividad_13, t0.direccion_tramitacion AS direccion_tramitacion_14, t0.comuna_tramitacion AS comuna_tramitacion_15, t0.ciudad_tramitacion AS ciudad_tramitacion_16, t0.pais_tramitacion AS pais_tramitacion_17, t0.telefono_empresa AS telefono_empresa_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.parent_empresa_id AS parent_empresa_id_21, t0.logo_id AS logo_id_22 FROM empresa t0 INNER JOIN user_empresa ON t0.id = user_empresa.empresa_id WHERE user_empresa.user_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rut AS rut_2,
  t0.razon_social AS razon_social_3,
  t0.activa AS activa_4,
  t0.medipass_key AS medipass_key_5,
  t0.imed_key AS imed_key_6,
  t0.salesforce_id AS salesforce_id_7,
  t0.exists_in_salesforce AS exists_in_salesforce_8,
  t0.origen AS origen_9,
  t0.last_sync_at AS last_sync_at_10,
  t0.salesforce_parent_id AS salesforce_parent_id_11,
  t0.is_holding AS is_holding_12,
  t0.codigo_actividad AS codigo_actividad_13,
  t0.direccion_tramitacion AS direccion_tramitacion_14,
  t0.comuna_tramitacion AS comuna_tramitacion_15,
  t0.ciudad_tramitacion AS ciudad_tramitacion_16,
  t0.pais_tramitacion AS pais_tramitacion_17,
  t0.telefono_empresa AS telefono_empresa_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.parent_empresa_id AS parent_empresa_id_21,
  t0.logo_id AS logo_id_22
FROM
  empresa t0
  INNER JOIN user_empresa ON t0.id = user_empresa.empresa_id
WHERE
  user_empresa.user_id = ?

SELECT t0.id AS id_1, t0.rut AS rut_2, t0.razon_social AS razon_social_3, t0.activa AS activa_4, t0.medipass_key AS medipass_key_5, t0.imed_key AS imed_key_6, t0.salesforce_id AS salesforce_id_7, t0.exists_in_salesforce AS exists_in_salesforce_8, t0.origen AS origen_9, t0.last_sync_at AS last_sync_at_10, t0.salesforce_parent_id AS salesforce_parent_id_11, t0.is_holding AS is_holding_12, t0.codigo_actividad AS codigo_actividad_13, t0.direccion_tramitacion AS direccion_tramitacion_14, t0.comuna_tramitacion AS comuna_tramitacion_15, t0.ciudad_tramitacion AS ciudad_tramitacion_16, t0.pais_tramitacion AS pais_tramitacion_17, t0.telefono_empresa AS telefono_empresa_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.parent_empresa_id AS parent_empresa_id_21, t0.logo_id AS logo_id_22 FROM empresa t0 INNER JOIN user_empresa ON t0.id = user_empresa.empresa_id WHERE user_empresa.user_id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\User->getEmpresasAccesibles (line 325)
8	App\Security\UserChecker->checkPostAuth (line 59)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->postCheckCredentials (line 50)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 199)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
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 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.01 ms
(32.19%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permisos AS permisos_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.apellido AS apellido_7, t0.activo AS activo_8, t0.last_login_at AS last_login_at_9, t0.password_changed_at AS password_changed_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.failed_login_attempts AS failed_login_attempts_13, t0.locked_until AS locked_until_14, t0.must_change_password AS must_change_password_15, t0.clearance AS clearance_16, t0.avatar_id AS avatar_id_17 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "rodrigo.martinez@security.cl"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.permisos AS permisos_4,
  t0.password AS password_5,
  t0.nombre AS nombre_6,
  t0.apellido AS apellido_7,
  t0.activo AS activo_8,
  t0.last_login_at AS last_login_at_9,
  t0.password_changed_at AS password_changed_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.failed_login_attempts AS failed_login_attempts_13,
  t0.locked_until AS locked_until_14,
  t0.must_change_password AS must_change_password_15,
  t0.clearance AS clearance_16,
  t0.avatar_id AS avatar_id_17
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.permisos AS permisos_4, t0.password AS password_5, t0.nombre AS nombre_6, t0.apellido AS apellido_7, t0.activo AS activo_8, t0.last_login_at AS last_login_at_9, t0.password_changed_at AS password_changed_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.failed_login_attempts AS failed_login_attempts_13, t0.locked_until AS locked_until_14, t0.must_change_password AS must_change_password_15, t0.clearance AS clearance_16, t0.avatar_id AS avatar_id_17 FROM user t0 WHERE t0.email = 'rodrigo.martinez@security.cl' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 55)
5	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 60)
6	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 64)
7	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->{closure:Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator::authenticate():83} (line 83)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
21	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 191)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.98 ms
(31.21%)

SELECT t0.id AS id_1, t0.rut AS rut_2, t0.razon_social AS razon_social_3, t0.activa AS activa_4, t0.medipass_key AS medipass_key_5, t0.imed_key AS imed_key_6, t0.salesforce_id AS salesforce_id_7, t0.exists_in_salesforce AS exists_in_salesforce_8, t0.origen AS origen_9, t0.last_sync_at AS last_sync_at_10, t0.salesforce_parent_id AS salesforce_parent_id_11, t0.is_holding AS is_holding_12, t0.codigo_actividad AS codigo_actividad_13, t0.direccion_tramitacion AS direccion_tramitacion_14, t0.comuna_tramitacion AS comuna_tramitacion_15, t0.ciudad_tramitacion AS ciudad_tramitacion_16, t0.pais_tramitacion AS pais_tramitacion_17, t0.telefono_empresa AS telefono_empresa_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.parent_empresa_id AS parent_empresa_id_21, t0.logo_id AS logo_id_22 FROM empresa t0 WHERE t0.parent_empresa_id = ?

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rut AS rut_2,
  t0.razon_social AS razon_social_3,
  t0.activa AS activa_4,
  t0.medipass_key AS medipass_key_5,
  t0.imed_key AS imed_key_6,
  t0.salesforce_id AS salesforce_id_7,
  t0.exists_in_salesforce AS exists_in_salesforce_8,
  t0.origen AS origen_9,
  t0.last_sync_at AS last_sync_at_10,
  t0.salesforce_parent_id AS salesforce_parent_id_11,
  t0.is_holding AS is_holding_12,
  t0.codigo_actividad AS codigo_actividad_13,
  t0.direccion_tramitacion AS direccion_tramitacion_14,
  t0.comuna_tramitacion AS comuna_tramitacion_15,
  t0.ciudad_tramitacion AS ciudad_tramitacion_16,
  t0.pais_tramitacion AS pais_tramitacion_17,
  t0.telefono_empresa AS telefono_empresa_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.parent_empresa_id AS parent_empresa_id_21,
  t0.logo_id AS logo_id_22
FROM
  empresa t0
WHERE
  t0.parent_empresa_id = ?

SELECT t0.id AS id_1, t0.rut AS rut_2, t0.razon_social AS razon_social_3, t0.activa AS activa_4, t0.medipass_key AS medipass_key_5, t0.imed_key AS imed_key_6, t0.salesforce_id AS salesforce_id_7, t0.exists_in_salesforce AS exists_in_salesforce_8, t0.origen AS origen_9, t0.last_sync_at AS last_sync_at_10, t0.salesforce_parent_id AS salesforce_parent_id_11, t0.is_holding AS is_holding_12, t0.codigo_actividad AS codigo_actividad_13, t0.direccion_tramitacion AS direccion_tramitacion_14, t0.comuna_tramitacion AS comuna_tramitacion_15, t0.ciudad_tramitacion AS ciudad_tramitacion_16, t0.pais_tramitacion AS pais_tramitacion_17, t0.telefono_empresa AS telefono_empresa_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.parent_empresa_id AS parent_empresa_id_21, t0.logo_id AS logo_id_22 FROM empresa t0 WHERE t0.parent_empresa_id = 48;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Empresa->getEmpresasHijasActivas (line 213)
8	App\Entity\User->getEmpresasAccesibles (line 332)
9	App\Security\UserChecker->checkPostAuth (line 59)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->postCheckCredentials (line 50)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 199)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
21	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 191)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	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\Empresa	5
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Archivo	No errors.
App\Entity\Empresa	No errors.
App\Entity\EmpresaModulo	No errors.

Symfony Profiler

GET https://tidy.alfredocruz.cl/licencias

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping