Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.42 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.42 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:

[
  "3100"
]

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 = '3100';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 756)
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 65)
7	App\Security\OAuth2BearerAuthenticator->App\Security\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 66)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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.

Symfony Profiler

GET https://appolomovil2.ingesoftsi.com/api/username.json

Configuration Settings

Theme