Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.89 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

1.20 ms

SELECT t0.id AS id_1, t0.admin_id AS admin_id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.main_admin AS main_admin_7, t0.super_admin AS super_admin_8, t0.is_active AS is_active_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.user_group_id AS user_group_id_14, t0.user_type AS user_type_15, t0.deleted_by AS deleted_by_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.admin_id AS admin_id_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.is_verified AS is_verified_6,
  t0.main_admin AS main_admin_7,
  t0.super_admin AS super_admin_8,
  t0.is_active AS is_active_9,
  t0.is_deleted AS is_deleted_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.user_group_id AS user_group_id_14,
  t0.user_type AS user_type_15,
  t0.deleted_by AS deleted_by_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.admin_id AS admin_id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.main_admin AS main_admin_7, t0.super_admin AS super_admin_8, t0.is_active AS is_active_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.user_group_id AS user_group_id_14, t0.user_type AS user_type_15, t0.deleted_by AS deleted_by_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
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 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.69 ms

SELECT d0_.op_ut_id AS op_ut_id_0, d0_.op_ut_name AS op_ut_name_1, d1_.op_type_name AS op_type_name_2, d1_.op_type_id AS op_type_id_3, d0_.time AS time_4, d2_.level_name AS level_name_5, d2_.level_id AS level_id_6, d0_.op_ut_status AS op_ut_status_7 FROM dp_operational_unit d0_ LEFT JOIN dp_level_op_ut_relation d3_ ON (d3_.lu_op_ut_id = d0_.op_ut_id) LEFT JOIN dp_operational_unit_type d1_ ON (d1_.op_type_id = d0_.op_ut_type) LEFT JOIN dp_levels d2_ ON (d2_.level_id = d3_.lu_level_id) WHERE d0_.op_ut_status <> ? AND d3_.lu_level_id = ? GROUP BY d0_.op_ut_id

Parameters:

[
  "deleted"
  "23"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.op_ut_id AS op_ut_id_0,
  d0_.op_ut_name AS op_ut_name_1,
  d1_.op_type_name AS op_type_name_2,
  d1_.op_type_id AS op_type_id_3,
  d0_.time AS time_4,
  d2_.level_name AS level_name_5,
  d2_.level_id AS level_id_6,
  d0_.op_ut_status AS op_ut_status_7
FROM
  dp_operational_unit d0_
  LEFT JOIN dp_level_op_ut_relation d3_ ON (d3_.lu_op_ut_id = d0_.op_ut_id)
  LEFT JOIN dp_operational_unit_type d1_ ON (d1_.op_type_id = d0_.op_ut_type)
  LEFT JOIN dp_levels d2_ ON (d2_.level_id = d3_.lu_level_id)
WHERE
  d0_.op_ut_status <> ?
  AND d3_.lu_level_id = ?
GROUP BY
  d0_.op_ut_id

SELECT d0_.op_ut_id AS op_ut_id_0, d0_.op_ut_name AS op_ut_name_1, d1_.op_type_name AS op_type_name_2, d1_.op_type_id AS op_type_id_3, d0_.time AS time_4, d2_.level_name AS level_name_5, d2_.level_id AS level_id_6, d0_.op_ut_status AS op_ut_status_7 FROM dp_operational_unit d0_ LEFT JOIN dp_level_op_ut_relation d3_ ON (d3_.lu_op_ut_id = d0_.op_ut_id) LEFT JOIN dp_operational_unit_type d1_ ON (d1_.op_type_id = d0_.op_ut_type) LEFT JOIN dp_levels d2_ ON (d2_.level_id = d3_.lu_level_id) WHERE d0_.op_ut_status <> 'deleted' AND d3_.lu_level_id = '23' GROUP BY d0_.op_ut_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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 299)
7	App\Repository\DpOperationalUnitRepository->getEnableDisableOperationalUnitByCell (line 240)
8	App\Controller\ActionPlanController->getEnableDisabledWorkstationsByLevel (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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

0 Hits

0 Misses

0 Puts

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\TcUserType	No errors.
App\Entity\DpOperationalUnit	No errors.
App\Entity\DpLevelOpUtRelation	No errors.
App\Entity\DpOperationalUnitType	No errors.
App\Entity\DpLevels	No errors.

Symfony Profiler

POST http://dev-lts-datapoint.ycalabs.com/action-plan/view-enable-disable-workstations

Configuration Settings

Theme