Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

71.85 ms Query time

1 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

71.85 ms

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.email AS email_4, t0.password AS password_5, t0.salt AS salt_6, t0.telefono AS telefono_7, t0.celular AS celular_8, t0.dni AS dni_9, t0.cuenta_unificacion AS cuenta_unificacion_10, t0.activo AS activo_11, t0.expirado AS expirado_12, t0.bloqueado AS bloqueado_13, t0.motivo_rechazo AS motivo_rechazo_14, t0.update_at AS update_at_15, t0.ultimo_login AS ultimo_login_16, t0.token AS token_17, t0.created_at AS created_at_18, t0.habilitado_moodle AS habilitado_moodle_19, t0.fecha_baja_hasta_moodle AS fecha_baja_hasta_moodle_20, t0.cambiar_pass AS cambiar_pass_21, t0.tieneDatosSeguroBNAcompleto AS tieneDatosSeguroBNAcompleto_22, t0.tienePdfSeguroBNAfirmado AS tienePdfSeguroBNAfirmado_23, t0.empresa_id AS empresa_id_24, t0.instructor_id AS instructor_id_25, t0.organizacion_id AS organizacion_id_26, t0.federacion_id AS federacion_id_27, t0.cuerpo_id AS cuerpo_id_28, t0.bombero_id AS bombero_id_29, t0.miembro_directivo_id AS miembro_directivo_id_30, t0.miembro_directivo_federacion_id AS miembro_directivo_federacion_id_31, t0.oba_id AS oba_id_32 FROM usuario t0 WHERE t0.id = ?

Parameters:

[
  "779"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.apellido AS apellido_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.salt AS salt_6,
  t0.telefono AS telefono_7,
  t0.celular AS celular_8,
  t0.dni AS dni_9,
  t0.cuenta_unificacion AS cuenta_unificacion_10,
  t0.activo AS activo_11,
  t0.expirado AS expirado_12,
  t0.bloqueado AS bloqueado_13,
  t0.motivo_rechazo AS motivo_rechazo_14,
  t0.update_at AS update_at_15,
  t0.ultimo_login AS ultimo_login_16,
  t0.token AS token_17,
  t0.created_at AS created_at_18,
  t0.habilitado_moodle AS habilitado_moodle_19,
  t0.fecha_baja_hasta_moodle AS fecha_baja_hasta_moodle_20,
  t0.cambiar_pass AS cambiar_pass_21,
  t0.tieneDatosSeguroBNAcompleto AS tieneDatosSeguroBNAcompleto_22,
  t0.tienePdfSeguroBNAfirmado AS tienePdfSeguroBNAfirmado_23,
  t0.empresa_id AS empresa_id_24,
  t0.instructor_id AS instructor_id_25,
  t0.organizacion_id AS organizacion_id_26,
  t0.federacion_id AS federacion_id_27,
  t0.cuerpo_id AS cuerpo_id_28,
  t0.bombero_id AS bombero_id_29,
  t0.miembro_directivo_id AS miembro_directivo_id_30,
  t0.miembro_directivo_federacion_id AS miembro_directivo_federacion_id_31,
  t0.oba_id AS oba_id_32
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.email AS email_4, t0.password AS password_5, t0.salt AS salt_6, t0.telefono AS telefono_7, t0.celular AS celular_8, t0.dni AS dni_9, t0.cuenta_unificacion AS cuenta_unificacion_10, t0.activo AS activo_11, t0.expirado AS expirado_12, t0.bloqueado AS bloqueado_13, t0.motivo_rechazo AS motivo_rechazo_14, t0.update_at AS update_at_15, t0.ultimo_login AS ultimo_login_16, t0.token AS token_17, t0.created_at AS created_at_18, t0.habilitado_moodle AS habilitado_moodle_19, t0.fecha_baja_hasta_moodle AS fecha_baja_hasta_moodle_20, t0.cambiar_pass AS cambiar_pass_21, t0.tieneDatosSeguroBNAcompleto AS tieneDatosSeguroBNAcompleto_22, t0.tienePdfSeguroBNAfirmado AS tienePdfSeguroBNAfirmado_23, t0.empresa_id AS empresa_id_24, t0.instructor_id AS instructor_id_25, t0.organizacion_id AS organizacion_id_26, t0.federacion_id AS federacion_id_27, t0.cuerpo_id AS cuerpo_id_28, t0.bombero_id AS bombero_id_29, t0.miembro_directivo_id AS miembro_directivo_id_30, t0.miembro_directivo_federacion_id AS miembro_directivo_federacion_id_31, t0.oba_id AS oba_id_32 FROM usuario t0 WHERE t0.id = '779';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 7)

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\Usuario	1
App\Entity\Cuerpo	1

Entities Mapping

Class	Mapping errors
App\Entity\Usuario\Usuario	No errors.
App\Entity\Empresa	No errors.
App\Entity\Instructor	No errors.
App\Entity\Organizacion	No errors.
App\Entity\Federacion	No errors.
App\Entity\Cuerpo	No errors.
App\Entity\Bombero	The field App\Entity\Bombero#usuarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Usuario\Usuario#bombero does not contain the required 'inversedBy: "usuarios"' attribute.
App\Entity\MiembroDirectivo	No errors.
App\Entity\Oba	No errors.
App\Entity\Usuario\Grupo	No errors.
App\Entity\FormularioArchivo	No errors.
App\Entity\Usuario\NotificacionUsuario	No errors.
App\Entity\Academia\Departamento	No errors.
App\Entity\Region	No errors.
App\Entity\FormularioSeguro	No errors.
App\Entity\Provincia	No errors.
App\Entity\Area	No errors.
App\Entity\Cemi\Recorrido	No errors.
App\Entity\Localidad	No errors.
App\Entity\Pais	No errors.
App\Entity\Incidente	No errors.
App\Entity\HistorialCertificadoRegularidad	No errors.
App\Entity\HistorialCambioEstadoCuerpo	No errors.
App\Entity\Jerarquia	No errors.
App\Entity\FamiliarBombero	No errors.
App\Entity\BomberoHistorial	No errors.
App\Entity\BomberoError	No errors.
App\Entity\BomberoInterviniente	No errors.
App\Entity\Credencial	No errors.
App\Entity\Formacion	No errors.
App\Entity\Cemi\SimulacionBombero	No errors.
App\Entity\MiembroDirectivoCargo	No errors.
App\Entity\Usuario\Roles	No errors.
App\Entity\Usuario\TipoUsuario	No errors.
App\Entity\Usuario\Notificacion	No errors.
App\Entity\Academia\Oferta	No errors.
App\Entity\Documento	No errors.
App\Entity\TipoIdentificacion	No errors.
App\Entity\EstadoCivil	No errors.
App\Entity\BeneficiarioSeguro	No errors.

Symfony Profiler

GET https://test.gestionbomberos.org/usuario/cambiar_password/779

Configuration Settings

Theme

Page Width