Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

9.00 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

5.12 ms

SELECT t0.id AS id_1, t0.cedula AS cedula_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.email AS email_6, t0.activo AS activo_7, t0.fecha_nacimiento AS fecha_nacimiento_8, t0.sesion_activa AS sesion_activa_9, t0.firebaseId AS firebaseid_10, t0.reset_password AS reset_password_11, t0.contrasena AS contrasena_12, t0.placa_agente AS placa_agente_13, t0.fecha_ultima_clave AS fecha_ultima_clave_14, t0.last_api_token AS last_api_token_15, t0.imei_radio AS imei_radio_16, t0.propietario AS propietario_17, t0.rol_id AS rol_id_18, t19.id AS id_20, t19.nombre AS nombre_21, t19.nombre_real AS nombre_real_22, t19.activo AS activo_23, t0.tipo_cargo_id AS tipo_cargo_id_24, t0.id_tipo_identificacion AS id_tipo_identificacion_25, t0.id_parqueadero AS id_parqueadero_26, t0.id_grua_asignada AS id_grua_asignada_27 FROM interno t0 LEFT JOIN rol t19 ON t0.rol_id = t19.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cedula AS cedula_2,
  t0.nombres AS nombres_3,
  t0.apellidos AS apellidos_4,
  t0.telefono AS telefono_5,
  t0.email AS email_6,
  t0.activo AS activo_7,
  t0.fecha_nacimiento AS fecha_nacimiento_8,
  t0.sesion_activa AS sesion_activa_9,
  t0.firebaseId AS firebaseid_10,
  t0.reset_password AS reset_password_11,
  t0.contrasena AS contrasena_12,
  t0.placa_agente AS placa_agente_13,
  t0.fecha_ultima_clave AS fecha_ultima_clave_14,
  t0.last_api_token AS last_api_token_15,
  t0.imei_radio AS imei_radio_16,
  t0.propietario AS propietario_17,
  t0.rol_id AS rol_id_18,
  t19.id AS id_20,
  t19.nombre AS nombre_21,
  t19.nombre_real AS nombre_real_22,
  t19.activo AS activo_23,
  t0.tipo_cargo_id AS tipo_cargo_id_24,
  t0.id_tipo_identificacion AS id_tipo_identificacion_25,
  t0.id_parqueadero AS id_parqueadero_26,
  t0.id_grua_asignada AS id_grua_asignada_27
FROM
  interno t0
  LEFT JOIN rol t19 ON t0.rol_id = t19.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cedula AS cedula_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.email AS email_6, t0.activo AS activo_7, t0.fecha_nacimiento AS fecha_nacimiento_8, t0.sesion_activa AS sesion_activa_9, t0.firebaseId AS firebaseid_10, t0.reset_password AS reset_password_11, t0.contrasena AS contrasena_12, t0.placa_agente AS placa_agente_13, t0.fecha_ultima_clave AS fecha_ultima_clave_14, t0.last_api_token AS last_api_token_15, t0.imei_radio AS imei_radio_16, t0.propietario AS propietario_17, t0.rol_id AS rol_id_18, t19.id AS id_20, t19.nombre AS nombre_21, t19.nombre_real AS nombre_real_22, t19.activo AS activo_23, t0.tipo_cargo_id AS tipo_cargo_id_24, t0.id_tipo_identificacion AS id_tipo_identificacion_25, t0.id_parqueadero AS id_parqueadero_26, t0.id_grua_asignada AS id_grua_asignada_27 FROM interno t0 LEFT JOIN rol t19 ON t0.rol_id = t19.id WHERE t0.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 366)
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 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 73)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
14	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 65)
15	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 116)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 176)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 6)

2.34 ms

SELECT t0.id_recurso AS id_recurso_1, t0.nombre_recurso AS nombre_recurso_2, t0.descripcion_recurso AS descripcion_recurso_3, t0.tipo_permiso AS tipo_permiso_4, t0.activo AS activo_5, t0.permiso_padre AS permiso_padre_6 FROM permiso t0 INNER JOIN roles_permisos ON t0.id_recurso = roles_permisos.permiso_id WHERE roles_permisos.rol_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_recurso AS id_recurso_1,
  t0.nombre_recurso AS nombre_recurso_2,
  t0.descripcion_recurso AS descripcion_recurso_3,
  t0.tipo_permiso AS tipo_permiso_4,
  t0.activo AS activo_5,
  t0.permiso_padre AS permiso_padre_6
FROM
  permiso t0
  INNER JOIN roles_permisos ON t0.id_recurso = roles_permisos.permiso_id
WHERE
  roles_permisos.rol_id = ?

SELECT t0.id_recurso AS id_recurso_1, t0.nombre_recurso AS nombre_recurso_2, t0.descripcion_recurso AS descripcion_recurso_3, t0.tipo_permiso AS tipo_permiso_4, t0.activo AS activo_5, t0.permiso_padre AS permiso_padre_6 FROM permiso t0 INNER JOIN roles_permisos ON t0.id_recurso = roles_permisos.permiso_id WHERE roles_permisos.rol_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1091)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1020)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2724)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 370)
8	App\Entity\Intern->getRoles (line 303)
9	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 212)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
16	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 65)
17	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 176)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 6)

1.06 ms

SELECT p0_.id AS id_0, p0_.id_parametro AS id_parametro_1, p0_.descripcion_parametro AS descripcion_parametro_2, p0_.valor AS valor_3, p0_.tipo_dato AS tipo_dato_4 FROM parametros p0_ ORDER BY p0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.id_parametro AS id_parametro_1,
  p0_.descripcion_parametro AS descripcion_parametro_2,
  p0_.valor AS valor_3,
  p0_.tipo_dato AS tipo_dato_4
FROM
  parametros p0_
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.id_parametro AS id_parametro_1, p0_.descripcion_parametro AS descripcion_parametro_2, p0_.valor AS valor_3, p0_.tipo_dato AS tipo_dato_4 FROM parametros p0_ ORDER BY p0_.id ASC;

#	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 189)
7	App\Controller\ParameterController->getParametersData (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 6)

0.48 ms

SELECT p0_.id AS id_0, p0_.id_parametro AS id_parametro_1, p0_.descripcion_parametro AS descripcion_parametro_2, p0_.valor AS valor_3, p0_.tipo_dato AS tipo_dato_4 FROM parametros p0_ ORDER BY p0_.id ASC LIMIT 10 OFFSET 80

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.id_parametro AS id_parametro_1,
  p0_.descripcion_parametro AS descripcion_parametro_2,
  p0_.valor AS valor_3,
  p0_.tipo_dato AS tipo_dato_4
FROM
  parametros p0_
ORDER BY
  p0_.id ASC
LIMIT
  10
OFFSET
  80

SELECT p0_.id AS id_0, p0_.id_parametro AS id_parametro_1, p0_.descripcion_parametro AS descripcion_parametro_2, p0_.valor AS valor_3, p0_.tipo_dato AS tipo_dato_4 FROM parametros p0_ ORDER BY p0_.id ASC LIMIT 10 OFFSET 80;

#	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 193)
7	App\Controller\ParameterController->getParametersData (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 6)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Intern	The association App\Entity\Intern#towInactivations refers to the owning side field App\Entity\TowInactivation#agent which does not exist. The field App\Entity\Intern#towRequestStatus is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TowRequestStatus#intern does not contain the required 'inversedBy="towRequestStatus"' attribute.
App\Entity\Role	No errors.
App\Entity\JobTitle	No errors.
App\Entity\DocumentType	No errors.
App\Entity\Parking	No errors.
App\Entity\Tow	The field App\Entity\Tow#driverHistory is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TowDriverHistory#tow does not contain the required 'inversedBy="driverHistory"' attribute. The field App\Entity\Tow#towInactivation is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TowInactivation#tow does not contain the required 'inversedBy="towInactivation"' attribute. The association App\Entity\Tow#line refers to the inverse side field App\Entity\LineType#tow which does not exist. The association App\Entity\Tow#color refers to the inverse side field App\Entity\ColorType#tow which does not exist. The association App\Entity\Tow#fuel refers to the inverse side field App\Entity\FuelType#tow which does not exist. The association App\Entity\Tow#engine refers to the inverse side field App\Entity\EngineType#tow which does not exist. The association App\Entity\Tow#transmissionType refers to the inverse side field App\Entity\TransmissionType#tow which does not exist. The association App\Entity\Tow#turnOnType refers to the inverse side field App\Entity\TurnOnType#tow which does not exist. The association App\Entity\Tow#brakeType refers to the inverse side field App\Entity\BrakeType#tow which does not exist. The association App\Entity\Tow#soat refers to the inverse side field App\Entity\Insurance#tow which does not exist. The association App\Entity\Tow#riskPolicy refers to the inverse side field App\Entity\Insurance#tow which does not exist. The association App\Entity\Tow#contractualPolicy refers to the inverse side field App\Entity\Insurance#tow which does not exist. The association App\Entity\Tow#rps refers to the inverse side field App\Entity\RpsEntity#tow which does not exist.
App\Entity\LiquidationPayment	No errors.
App\Entity\AuditEntity	No errors.
App\Entity\LoginLog	No errors.
App\Entity\TowRequest	No errors.
App\Entity\TowDriverHistory	No errors.
App\Entity\Operation	The field App\Entity\Operation#historyAgentsOperation is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AgentsOperationHistory#operation does not contain the required 'inversedBy="historyAgentsOperation"' attribute.
App\Entity\TowOwnerHistory	No errors.
App\Entity\TowInactivation	The mappings App\Entity\TowInactivation#intern and App\Entity\Intern#towInactivations are inconsistent with each other.
App\Entity\AgentsOperationHistory	No errors.
App\Entity\ImmobilizationExempted	No errors.
App\Entity\CheckListTow	No errors.
App\Entity\TowRequestStatus	No errors.
App\Entity\Permission	No errors.
App\Entity\Parameter	No errors.

Symfony Profiler

GET https://dev.appolomovil.com/intern/dataParameters?_=1765834340740&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&colum…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping