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

Query Metrics

12 Database Queries
12 Different statements
2.67 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 0.17 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:
[
  8
]
2 0.16 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.21 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:
[
  "3489"
]
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.57 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.poliza_id AS poliza_id_11, t0.estado_id AS estado_id_12, t0.tipofacturacion_id AS tipofacturacion_id_13, t0.razonsocialfacturacion_id AS razonsocialfacturacion_id_14, t0.catalogoventa_id AS catalogoventa_id_15 FROM profesionales t0 WHERE t0.persona_id = ?
Parameters:
[
  3489
]
6 0.28 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.19 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_
Parameters:
[]
8 0.17 ms
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2 FROM tipopago t0_
Parameters:
[]
9 0.13 ms
SELECT g0_.id AS id_0, g0_.nombre AS nombre_1 FROM grupo_listas_precios g0_
Parameters:
[]
10 0.16 ms
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2 FROM tipocliente t0_
Parameters:
[]
11 0.17 ms
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:
[]
12 0.14 ms
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.

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\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
  • 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 No errors.
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\Poliza No errors.
App\Entity\Estadoprofesional No errors.
App\Entity\Tipofacturacion No errors.
App\Entity\Catalogoprecio No errors.
App\Entity\TipoclienteProducto No errors.