Symfony Profiler

Query Metrics

14 Database Queries

5 Different statements

10.26 ms Query time

0 Invalid entities

33 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.82 ms
(76.20%)

SELECT u0_.id AS id_0, u0_.view_permission AS view_permission_1, u0_.add_permission AS add_permission_2, u0_.edit_permission AS edit_permission_3, u0_.delete_permission AS delete_permission_4, u0_.function_id AS function_id_5, u0_.user_id AS user_id_6 FROM user_permission u0_ LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id WHERE u1_.user_id = ? AND f2_.function_id = ? ORDER BY u0_.id ASC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.view_permission AS view_permission_1,
  u0_.add_permission AS add_permission_2,
  u0_.edit_permission AS edit_permission_3,
  u0_.delete_permission AS delete_permission_4,
  u0_.function_id AS function_id_5,
  u0_.user_id AS user_id_6
FROM
  user_permission u0_
  LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id
  LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id
WHERE
  u1_.user_id = ?
  AND f2_.function_id = ?
ORDER BY
  u0_.id ASC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.view_permission AS view_permission_1, u0_.add_permission AS add_permission_2, u0_.edit_permission AS edit_permission_3, u0_.delete_permission AS delete_permission_4, u0_.function_id AS function_id_5, u0_.user_id AS user_id_6 FROM user_permission u0_ LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id WHERE u1_.user_id = 6 AND f2_.function_id = 3 ORDER BY u0_.id ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 36)
7	App\Repository\PermisoUsuarioRepository->BuscarPermisoUsuario (line 179)
8	App\Service\Admin\AdminAccessService->buscarPermisosMismoBase (line 159)
9	App\Service\Admin\AdminAccessService->primeraFilaPermiso (line 95)
10	App\Service\Admin\AdminAccessService->usuarioPuedeVer (line 57)
11	App\Service\Admin\AdminAccessService->requirePermission (line 48)
12	App\EventSubscriber\RequireAdminPermissionSubscriber->onKernelController (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 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.32 ms
(12.84%)

SELECT t0.rol_id AS rol_id_1, t0.name AS name_2 FROM rol t0 WHERE t0.rol_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.rol_id AS rol_id_1,
  t0.name AS name_2
FROM
  rol t0
WHERE
  t0.rol_id = ?

SELECT t0.rol_id AS rol_id_1, t0.name AS name_2 FROM rol t0 WHERE t0.rol_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\Rol::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Rol->__get (line 33)
8	App\Entity\Rol->getNombre (line 677)
9	App\Service\Admin\UsuarioService->ListarUsuarios (line 695)
10	App\Service\Admin\UsuarioService->ListarUsuariosParaAdmin (line 216)
11	App\Controller\Admin\UsuarioController->listar (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.51 ms
(5.02%)

SELECT u0_.user_id AS user_id_0, u0_.name AS name_1, u0_.lastname AS lastname_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.password AS password_5, u0_.status AS status_6, u0_.estimator AS estimator_7, u0_.bond AS bond_8, u0_.retainage AS retainage_9, u0_.chat AS chat_10, u0_.final_qty_approver AS final_qty_approver_11, u0_.sms_opt_in AS sms_opt_in_12, u0_.manage_contacts AS manage_contacts_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.player_id AS player_id_16, u0_.push_token AS push_token_17, u0_.plataforma AS plataforma_18, u0_.imagen AS imagen_19, u0_.preferred_lang AS preferred_lang_20, u0_.sidebar_color AS sidebar_color_21, u0_.rol_id AS rol_id_22 FROM user u0_ LEFT JOIN rol r1_ ON u0_.rol_id = r1_.rol_id ORDER BY u0_.email ASC LIMIT 30

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.user_id AS user_id_0,
  u0_.name AS name_1,
  u0_.lastname AS lastname_2,
  u0_.email AS email_3,
  u0_.phone AS phone_4,
  u0_.password AS password_5,
  u0_.status AS status_6,
  u0_.estimator AS estimator_7,
  u0_.bond AS bond_8,
  u0_.retainage AS retainage_9,
  u0_.chat AS chat_10,
  u0_.final_qty_approver AS final_qty_approver_11,
  u0_.sms_opt_in AS sms_opt_in_12,
  u0_.manage_contacts AS manage_contacts_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.player_id AS player_id_16,
  u0_.push_token AS push_token_17,
  u0_.plataforma AS plataforma_18,
  u0_.imagen AS imagen_19,
  u0_.preferred_lang AS preferred_lang_20,
  u0_.sidebar_color AS sidebar_color_21,
  u0_.rol_id AS rol_id_22
FROM
  user u0_
  LEFT JOIN rol r1_ ON u0_.rol_id = r1_.rol_id
ORDER BY
  u0_.email ASC
LIMIT
  30

SELECT u0_.user_id AS user_id_0, u0_.name AS name_1, u0_.lastname AS lastname_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.password AS password_5, u0_.status AS status_6, u0_.estimator AS estimator_7, u0_.bond AS bond_8, u0_.retainage AS retainage_9, u0_.chat AS chat_10, u0_.final_qty_approver AS final_qty_approver_11, u0_.sms_opt_in AS sms_opt_in_12, u0_.manage_contacts AS manage_contacts_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.player_id AS player_id_16, u0_.push_token AS push_token_17, u0_.plataforma AS plataforma_18, u0_.imagen AS imagen_19, u0_.preferred_lang AS preferred_lang_20, u0_.sidebar_color AS sidebar_color_21, u0_.rol_id AS rol_id_22 FROM user u0_ LEFT JOIN rol r1_ ON u0_.rol_id = r1_.rol_id ORDER BY u0_.email ASC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 221)
7	App\Repository\UsuarioRepository->ListarUsuariosConTotal (line 664)
8	App\Service\Admin\UsuarioService->ListarUsuarios (line 695)
9	App\Service\Admin\UsuarioService->ListarUsuariosParaAdmin (line 216)
10	App\Controller\Admin\UsuarioController->listar (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.34 ms
(3.28%)

SELECT t0.user_id AS user_id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.status AS status_7, t0.estimator AS estimator_8, t0.bond AS bond_9, t0.retainage AS retainage_10, t0.chat AS chat_11, t0.final_qty_approver AS final_qty_approver_12, t0.sms_opt_in AS sms_opt_in_13, t0.manage_contacts AS manage_contacts_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.player_id AS player_id_17, t0.push_token AS push_token_18, t0.plataforma AS plataforma_19, t0.imagen AS imagen_20, t0.preferred_lang AS preferred_lang_21, t0.sidebar_color AS sidebar_color_22, t0.rol_id AS rol_id_23 FROM user t0 WHERE t0.user_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_id AS user_id_1,
  t0.name AS name_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.password AS password_6,
  t0.status AS status_7,
  t0.estimator AS estimator_8,
  t0.bond AS bond_9,
  t0.retainage AS retainage_10,
  t0.chat AS chat_11,
  t0.final_qty_approver AS final_qty_approver_12,
  t0.sms_opt_in AS sms_opt_in_13,
  t0.manage_contacts AS manage_contacts_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.player_id AS player_id_17,
  t0.push_token AS push_token_18,
  t0.plataforma AS plataforma_19,
  t0.imagen AS imagen_20,
  t0.preferred_lang AS preferred_lang_21,
  t0.sidebar_color AS sidebar_color_22,
  t0.rol_id AS rol_id_23
FROM
  user t0
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.status AS status_7, t0.estimator AS estimator_8, t0.bond AS bond_9, t0.retainage AS retainage_10, t0.chat AS chat_11, t0.final_qty_approver AS final_qty_approver_12, t0.sms_opt_in AS sms_opt_in_13, t0.manage_contacts AS manage_contacts_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.player_id AS player_id_17, t0.push_token AS push_token_18, t0.plataforma AS plataforma_19, t0.imagen AS imagen_20, t0.preferred_lang AS preferred_lang_21, t0.sidebar_color AS sidebar_color_22, t0.rol_id AS rol_id_23 FROM user t0 WHERE t0.user_id = 6;

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

0.27 ms
(2.67%)

SELECT COUNT(u0_.user_id) AS sclr_0 FROM user u0_ LEFT JOIN rol r1_ ON u0_.rol_id = r1_.rol_id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.user_id) AS sclr_0
FROM
  user u0_
  LEFT JOIN rol r1_ ON u0_.rol_id = r1_.rol_id

SELECT COUNT(u0_.user_id) AS sclr_0 FROM user u0_ LEFT JOIN rol r1_ ON u0_.rol_id = r1_.rol_id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 228)
8	App\Repository\UsuarioRepository->ListarUsuariosConTotal (line 664)
9	App\Service\Admin\UsuarioService->ListarUsuarios (line 695)
10	App\Service\Admin\UsuarioService->ListarUsuariosParaAdmin (line 216)
11	App\Controller\Admin\UsuarioController->listar (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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\Usuario	21
App\Entity\Rol	10
App\Entity\PermisoUsuario	1
App\Entity\Funcion	1

Entities Mapping

Class	Mapping errors
App\Entity\Usuario	No errors.
App\Entity\Rol	No errors.
App\Entity\Funcion	No errors.
App\Entity\PermisoUsuario	No errors.

Symfony Profiler

POST https://testing.cagconcrete.com/admin/usuario/listar

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping