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

Query Metrics

10 Database Queries
10 Different statements
19.23 ms Query time
8 Invalid entities
1161 Managed entities

Queries

Group similar statements

# Time Info
1 0.21 ms
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
]
2 0.22 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
  7
]
3 0.26 ms
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"
]
4 0.32 ms
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:
[]
5 0.32 ms
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
]
6 0.31 ms
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
]
7 0.53 ms
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_ WHERE t0_.id IN (?)
Parameters:
[
  "1"
]
8 0.31 ms
"START TRANSACTION"
Parameters:
[]
9 15.89 ms
UPDATE persona SET primernombre = ? WHERE id = ?
Parameters:
[
  "ALEJANDRO"
  8291
]
10 0.85 ms
"COMMIT"
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\Persona 2
App\Entity\User 1
App\Entity\Rol 1
App\Entity\Tipodocumento 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.