Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

33.54 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.30 ms

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.80 ms

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 = 20 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)

32.44 ms

SELECT SUM(d0_.hours * d0_.hourly_rate) AS sclr_0 FROM data_tracking_labor d0_ LEFT JOIN employee e1_ ON d0_.employee_id = e1_.employee_id LEFT JOIN data_tracking d2_ ON d0_.data_tracking_id = d2_.id LEFT JOIN project p3_ ON d2_.project_id = p3_.project_id WHERE d0_.employee_id IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  SUM(d0_.hours * d0_.hourly_rate) AS sclr_0
FROM
  data_tracking_labor d0_
  LEFT JOIN employee e1_ ON d0_.employee_id = e1_.employee_id
  LEFT JOIN data_tracking d2_ ON d0_.data_tracking_id = d2_.id
  LEFT JOIN project p3_ ON d2_.project_id = p3_.project_id
WHERE
  d0_.employee_id IS NOT NULL

SELECT SUM(d0_.hours * d0_.hourly_rate) AS sclr_0 FROM data_tracking_labor d0_ LEFT JOIN employee e1_ ON d0_.employee_id = e1_.employee_id LEFT JOIN data_tracking d2_ ON d0_.data_tracking_id = d2_.id LEFT JOIN project p3_ ON d2_.project_id = p3_.project_id WHERE d0_.employee_id IS NOT NULL;

#	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 590)
8	App\Repository\DataTrackingLaborRepository->DevolverTotalReporteEmployees (line 35)
9	App\Service\Admin\ReporteEmployeeService->DevolverTotal (line 111)
10	App\Controller\Admin\ReporteEmployeeController->devolverTotal (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)

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	1
App\Entity\Rol	1
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\PermisoUsuario	No errors.
App\Entity\Funcion	No errors.
App\Entity\DataTrackingLabor	No errors.
App\Entity\Employee	No errors.
App\Entity\DataTracking	No errors.
App\Entity\Project	No errors.

Symfony Profiler

POST https://testing.cagconcrete.com/admin/report-employee/devolverTotal

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping