GET https://www.quiro.care/solicitudcobertura/

Query Metrics

53 Database Queries
13 Different statements
13.72 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 0.28 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:
[
  72
]
2 0.21 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
  5
]
3 0.21 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
Parameters:
[]
4 0.52 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM solicitudcobertura s0_ WHERE s0_.fechaprocedimiento <= ? AND s0_.estado_id = ?
Parameters:
[
  "2025-08-04 11:10:12"
  5
]
5 0.34 ms
UPDATE solicitudcobertura SET estado_id = 12 WHERE fechaprocedimiento <= ? AND estado_id = ?
Parameters:
[
  "2025-08-04 11:10:12"
  5
]
6 0.22 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:
[
  230
]
7 0.83 ms
SELECT t0.id AS id_1, t0.precio AS precio_2, t0.valorasegurado AS valorasegurado_3, t0.duracion AS duracion_4, t0.observacion AS observacion_5, t0.fechaprocedimiento AS fechaprocedimiento_6, t0.fechacreacion AS fechacreacion_7, t0.fechaenviada AS fechaenviada_8, t0.urldocidentificacion AS urldocidentificacion_9, t0.urlcobertura AS urlcobertura_10, t0.urlcomprobantepago AS urlcomprobantepago_11, t0.tipopersonafacturacion AS tipopersonafacturacion_12, t0.sincronizado AS sincronizado_13, t0.pedidoodoo AS pedidoodoo_14, t0.edad AS edad_15, t0.estatura AS estatura_16, t0.peso AS peso_17, t0.asa AS asa_18, t0.hemoglobina AS hemoglobina_19, t0.anexos AS anexos_20, t0.certificado AS certificado_21, t0.fechamodificacion AS fechamodificacion_22, t0.nombreodoo AS nombreodoo_23, t0.consumidorfinal AS consumidorfinal_24, t0.usuario_id AS usuario_id_25, t0.profesional_id AS profesional_id_26, t0.asistente_id AS asistente_id_27, t0.paciente_id AS paciente_id_28, t0.entidad_id AS entidad_id_29, t0.paquetecobertura_id AS paquetecobertura_id_30, t0.estado_id AS estado_id_31, t0.especialidad_id AS especialidad_id_32, t0.municipio_id AS municipio_id_33, t0.poliza_id AS poliza_id_34, t0.personafacturacion_id AS personafacturacion_id_35, t0.empresafacturacion_id AS empresafacturacion_id_36, t0.usuariocancela_id AS usuariocancela_id_37, t0.usuariomodifica_id AS usuariomodifica_id_38, t0.tipopago_id AS tipopago_id_39 FROM solicitudcobertura t0 WHERE t0.profesional_id = ? ORDER BY t0.id DESC
Parameters:
[
  147
]
8 0.52 ms
SELECT t0.id AS id_1, t0.precio AS precio_2, t0.valorasegurado AS valorasegurado_3, t0.duracion AS duracion_4, t0.observacion AS observacion_5, t0.fechaprocedimiento AS fechaprocedimiento_6, t0.fechacreacion AS fechacreacion_7, t0.fechaenviada AS fechaenviada_8, t0.urldocidentificacion AS urldocidentificacion_9, t0.urlcobertura AS urlcobertura_10, t0.urlcomprobantepago AS urlcomprobantepago_11, t0.tipopersonafacturacion AS tipopersonafacturacion_12, t0.sincronizado AS sincronizado_13, t0.pedidoodoo AS pedidoodoo_14, t0.edad AS edad_15, t0.estatura AS estatura_16, t0.peso AS peso_17, t0.asa AS asa_18, t0.hemoglobina AS hemoglobina_19, t0.anexos AS anexos_20, t0.certificado AS certificado_21, t0.fechamodificacion AS fechamodificacion_22, t0.nombreodoo AS nombreodoo_23, t0.consumidorfinal AS consumidorfinal_24, t0.usuario_id AS usuario_id_25, t0.profesional_id AS profesional_id_26, t0.asistente_id AS asistente_id_27, t0.paciente_id AS paciente_id_28, t0.entidad_id AS entidad_id_29, t0.paquetecobertura_id AS paquetecobertura_id_30, t0.estado_id AS estado_id_31, t0.especialidad_id AS especialidad_id_32, t0.municipio_id AS municipio_id_33, t0.poliza_id AS poliza_id_34, t0.personafacturacion_id AS personafacturacion_id_35, t0.empresafacturacion_id AS empresafacturacion_id_36, t0.usuariocancela_id AS usuariocancela_id_37, t0.usuariomodifica_id AS usuariomodifica_id_38, t0.tipopago_id AS tipopago_id_39 FROM solicitudcobertura t0 WHERE t0.profesional_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  147
]
9 0.19 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:
[
  3454
]
10 0.37 ms
SELECT t0.id AS id_1, t0.idfactura AS idfactura_2, t0.factura AS factura_3, t0.idcliente AS idcliente_4, t0.cliente AS cliente_5, t0.fechavencimiento AS fechavencimiento_6, t0.total AS total_7, t0.estadopago AS estadopago_8, t0.user_id AS user_id_9 FROM bloqueofactura t0 WHERE t0.idcliente = ?
Parameters:
[
  4390
]
11 0.31 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:
[
  230
]
12 0.17 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.estado AS estado_3, t0.direccion AS direccion_4, t0.empresa_id AS empresa_id_5, t0.tipoentidad_id AS tipoentidad_id_6, t0.municipio_id AS municipio_id_7 FROM entidad t0 WHERE t0.id = ?
Parameters:
[
  49
]
13 0.20 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 WHERE t0.id = ?
Parameters:
[
  722
]
14 0.18 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
]
15 0.12 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = ?
Parameters:
[
  5
]
16 0.16 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:
[
  3451
]
17 0.14 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:
[
  3292
]
18 0.12 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = ?
Parameters:
[
  12
]
19 0.16 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:
[
  3294
]
20 0.16 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = ?
Parameters:
[
  9
]
21 0.38 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:
[
  3289
]
22 0.27 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:
[
  3204
]
23 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:
[
  3103
]
24 0.29 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:
[
  3069
]
25 0.27 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:
[
  3068
]
26 0.27 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:
[
  2994
]
27 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:
[
  2993
]
28 0.27 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:
[
  2921
]
29 0.27 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:
[
  2892
]
30 0.24 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:
[
  2889
]
31 0.27 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:
[
  2820
]
32 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:
[
  2819
]
33 0.17 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.estado AS estado_3, t0.direccion AS direccion_4, t0.empresa_id AS empresa_id_5, t0.tipoentidad_id AS tipoentidad_id_6, t0.municipio_id AS municipio_id_7 FROM entidad t0 WHERE t0.id = ?
Parameters:
[
  196
]
34 0.16 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 WHERE t0.id = ?
Parameters:
[
  748
]
35 0.28 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:
[
  2168
]
36 0.29 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:
[
  2118
]
37 0.29 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:
[
  1930
]
38 0.29 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:
[
  1906
]
39 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:
[
  1776
]
40 0.28 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:
[
  1737
]
41 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:
[
  1653
]
42 0.27 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:
[
  1301
]
43 0.14 ms
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.estado AS estado_3, t0.direccion AS direccion_4, t0.empresa_id AS empresa_id_5, t0.tipoentidad_id AS tipoentidad_id_6, t0.municipio_id AS municipio_id_7 FROM entidad t0 WHERE t0.id = ?
Parameters:
[
  96
]
44 0.22 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:
[
  1299
]
45 0.24 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:
[
  1283
]
46 0.24 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:
[
  1106
]
47 0.24 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:
[
  1036
]
48 0.24 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:
[
  926
]
49 0.25 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:
[
  907
]
50 0.24 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:
[
  904
]
51 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:
[
  903
]
52 0.24 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:
[
  901
]
53 0.16 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:
[
  1
]

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\Profesionales
  • The association App\Entity\Profesionales#catalogoventa refers to the inverse side field App\Entity\GrupoListasPrecios#profesionales which does not exist.
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\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\GrupoListasPrecios No errors.
App\Entity\Contactoreferencia No errors.
App\Entity\Especializaciones No errors.
App\Entity\Asistenteprofesional No errors.
App\Entity\Entidad No errors.
App\Entity\AgendaProfesional No errors.
App\Entity\Servicio
  • The mappings App\Entity\Servicio#personaresponsable and App\Entity\Persona#servicios are inconsistent with each other.
App\Entity\Paqueteproducto No errors.
App\Entity\Estadocobertura No errors.
App\Entity\Categoriaproducto No errors.
App\Entity\Municipio No errors.
App\Entity\Tipopago
  • The mappings App\Entity\Tipopago#solicitudcoberturas and App\Entity\Solicitudcobertura#tipopago are inconsistent with each other.
App\Entity\Productos No errors.
App\Entity\Activarcobertura 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\Pedido No errors.
App\Entity\Tipoentidad No errors.
App\Entity\Departamento No errors.