Redirect 303 redirect from POST @app_persona_edit (492ec1)

GET https://quiro.care/persona/8291/edit

Query Metrics

17 Database Queries
14 Different statements
6.41 ms Query time
8 Invalid entities
1202 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.09 ms
(32.67%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.departamento_id AS departamento_id_4 FROM municipio t0 ORDER BY t0.nombre ASC
Parameters:
[]
0.88 ms
(13.66%)
4
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.padre_id = ? AND m0_.activo = ? AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[
  241
  1
  "ROLE_OPERATIVO"
]
0.53 ms
(8.31%)
1
SELECT t0.id AS id_1, t0.primernombre AS primernombre_2, t0.segundonombre AS segundonombre_3, t0.primerapellido AS primerapellido_4, t0.segundoapellido AS segundoapellido_5, t0.documento AS documento_6, t0.estado AS estado_7, t0.fechanacimiento AS fechanacimiento_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.email AS email_11, t0.idintegracion AS idintegracion_12, t0.documentfile AS documentfile_13, t0.tipodocumento_id AS tipodocumento_id_14, t0.municipio_id AS municipio_id_15, t0.empresa_id AS empresa_id_16, t0.tipopago_id AS tipopago_id_17, t0.catalogoprecio_id AS catalogoprecio_id_18, t0.tipocliente_id AS tipocliente_id_19, t0.resptributaria_id AS resptributaria_id_20, t0.posicionfiscal_id AS posicionfiscal_id_21 FROM persona t0 WHERE t0.id = ?
Parameters:
[
  "8291"
]
0.38 ms
(5.98%)
1
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2 FROM tipopago t0_
Parameters:
[]
0.38 ms
(5.91%)
1
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.etiqueta AS etiqueta_2, m0_.icono AS icono_3, m0_.ruta AS ruta_4, m0_.nivel AS nivel_5, m0_.posicion AS posicion_6, m0_.activo AS activo_7, m0_.fecha_creacion AS fecha_creacion_8, m0_.fecha_actualizacion AS fecha_actualizacion_9, m0_.padre_id AS padre_id_10 FROM menu_item m0_ LEFT JOIN menu_item_rol m2_ ON m0_.id = m2_.menu_item_id LEFT JOIN rol r1_ ON r1_.id = m2_.rol_id WHERE m0_.activo = ? AND m0_.nivel = 0 AND r1_.nombre IN (?) ORDER BY m0_.posicion ASC
Parameters:
[
  1
  "ROLE_OPERATIVO"
]
0.35 ms
(5.42%)
1
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.abreviatura AS abreviatura_3, t0.tipodocumentodian AS tipodocumentodian_4, t0.idodoo AS idodoo_5 FROM tipodocumento t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.34 ms
(5.37%)
1
SELECT t0.id AS id_1, t0.numerocuenta AS numerocuenta_2, t0.anioexperiencia AS anioexperiencia_3, t0.tarjetaprofesional AS tarjetaprofesional_4, t0.validacion AS validacion_5, t0.persona_id AS persona_id_6, t0.profesion_id AS profesion_id_7, t0.banco_id AS banco_id_8, t0.tipocuenta_id AS tipocuenta_id_9, t0.comercial_id AS comercial_id_10, t0.estado_id AS estado_id_11, t0.tipofacturacion_id AS tipofacturacion_id_12, t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_13, t0.catalogoventa_id AS catalogoventa_id_14 FROM profesionales t0 WHERE t0.persona_id = ?
Parameters:
[
  8291
]
0.25 ms
(3.90%)
1
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.codigo AS codigo_2, t0_.codigoodoo AS codigoodoo_3 FROM tiporesponsabilidad t0_
Parameters:
[]
0.22 ms
(3.40%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.terminosycondiciones AS terminosycondiciones_5, t0.suscripcion AS suscripcion_6, t0.persona_id AS persona_id_7, t0.rol_id AS rol_id_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  45
]
0.21 ms
(3.32%)
1
SELECT t0_.id AS id_0, t0_.descripcion AS descripcion_1, t0_.abreviatura AS abreviatura_2, t0_.tipodocumentodian AS tipodocumentodian_3, t0_.idodoo AS idodoo_4 FROM tipodocumento t0_
Parameters:
[]
0.21 ms
(3.21%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
  7
]
0.20 ms
(3.06%)
1
SELECT g0_.id AS id_0, g0_.nombre AS nombre_1 FROM grupo_listas_precios g0_
Parameters:
[]
0.19 ms
(2.94%)
1
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2 FROM tipocliente t0_
Parameters:
[]
0.18 ms
(2.84%)
1
SELECT r0_.id AS id_0, r0_.descripcion AS descripcion_1, r0_.codigo AS codigo_2, r0_.codigoodoo AS codigoodoo_3 FROM resptributaria r0_
Parameters:
[]

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\Municipio 1123
App\Entity\Departamento 33
App\Entity\MenuItem 11
App\Entity\Tipocliente 9
App\Entity\Tipodocumento 5
App\Entity\GrupoListasPrecios 5
App\Entity\Tiporesponsabilidad 5
App\Entity\Resptributaria 4
App\Entity\Tipopago 3
App\Entity\Persona 2
App\Entity\User 1
App\Entity\Rol 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Persona
  • The mappings App\Entity\Persona#posicionfiscal and App\Entity\Tiporesponsabilidad#personas are inconsistent with each other.
  • If association App\Entity\Persona#posicionfiscal is many-to-one, then the inversed side App\Entity\Tiporesponsabilidad#personas has to be one-to-many.
App\Entity\Rol No errors.
App\Entity\Solicitudcobertura
  • The association App\Entity\Solicitudcobertura#usuariomodifica refers to the inverse side field App\Entity\User#solicitudusuariomodifica which does not exist.
App\Entity\Bloqueofactura No errors.
App\Entity\QuiroPay No errors.
App\Entity\Modulo No errors.
App\Entity\Tipodocumento No errors.
App\Entity\Municipio No errors.
App\Entity\Empresa
  • The mappings App\Entity\Empresa#posicionfiscal and App\Entity\Tiporesponsabilidad#empresas are inconsistent with each other.
  • If association App\Entity\Empresa#posicionfiscal is many-to-one, then the inversed side App\Entity\Tiporesponsabilidad#empresas has to be one-to-many.
App\Entity\Tipopago
  • The mappings App\Entity\Tipopago#solicitudcoberturas and App\Entity\Solicitudcobertura#tipopago are inconsistent with each other.
App\Entity\GrupoListasPrecios No errors.
App\Entity\Tipocliente No errors.
App\Entity\Resptributaria No errors.
App\Entity\Tiporesponsabilidad
  • The mappings App\Entity\Tiporesponsabilidad#personasposfiscal and App\Entity\Persona#posicionfiscal are inconsistent with each other.
  • The mappings App\Entity\Tiporesponsabilidad#empresasposfiscal and App\Entity\Empresa#posicionfiscal are inconsistent with each other.
App\Entity\Asistenteprofesional No errors.
App\Entity\Profesionales
  • If association App\Entity\Profesionales#poliza is many-to-many, then the inversed side App\Entity\Poliza#profesionales has to be many-to-many as well.
  • The association App\Entity\Profesionales#catalogoventa refers to the inverse side field App\Entity\GrupoListasPrecios#profesionales which does not exist.
App\Entity\Servicio
  • The mappings App\Entity\Servicio#personaresponsable and App\Entity\Persona#servicios are inconsistent with each other.
App\Entity\Pedido
  • The association App\Entity\Pedido#solicitudcobertura refers to the inverse side field App\Entity\Solicitudcobertura#pedidos which does not exist.
App\Entity\Departamento No errors.
App\Entity\Entidad No errors.
App\Entity\Profesion No errors.
App\Entity\Bancos No errors.
App\Entity\Tipocuenta No errors.
App\Entity\Comercial No errors.
App\Entity\Estadoprofesional No errors.
App\Entity\Tipofacturacion No errors.
App\Entity\Catalogoprecio No errors.
App\Entity\TipoclienteProducto No errors.
App\Entity\MenuItem No errors.