Query Metrics
70
Database Queries
26
Different statements
31.55 ms
Query time
11
Invalid entities
1848
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.13 ms (35.29%) |
40 |
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.pedidos AS pedidos_9, t0.user_id AS user_id_10 FROM bloqueofactura t0
Parameters:
[] |
|
3.42 ms (10.83%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadoprofesional t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
2.34 ms (7.43%) |
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:
[
133
]
|
|
2.24 ms (7.11%) |
1 |
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 = ?
Parameters:
[
67
]
|
|
1.69 ms (5.35%) |
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_ WHERE t0_.id IN (?)
Parameters:
[
"1"
]
|
|
1.25 ms (3.97%) |
1 |
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.is_active AS is_active_3, p0_.costo AS costo_4, p0_.urlimagen AS urlimagen_5, p0_.urlvideo AS urlvideo_6, p0_.visible AS visible_7, p0_.requiere_agenda AS requiere_agenda_8, p0_.categoriaproducto_id AS categoriaproducto_id_9, p0_.tipoproducto_id AS tipoproducto_id_10, p0_.subtipoproducto_id AS subtipoproducto_id_11 FROM paqueteproducto p0_
Parameters:
[] |
|
0.96 ms (3.05%) |
1 |
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2, p0_.grupo_lista_precio_id AS grupo_lista_precio_id_3 FROM poliza p0_
Parameters:
[] |
|
0.94 ms (2.98%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.grupo_lista_precio_id AS grupo_lista_precio_id_4 FROM poliza t0 INNER JOIN profesionales_poliza ON t0.id = profesionales_poliza.poliza_id WHERE profesionales_poliza.profesionales_id = ?
Parameters:
[
67
]
|
|
0.89 ms (2.82%) |
4 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM estadocobertura t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.64 ms (2.04%) |
3 |
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_ASISTENTE" ] |
|
0.64 ms (2.02%) |
1 |
SELECT p0_.id AS id_0, p0_.primernombre AS primernombre_1, p0_.segundonombre AS segundonombre_2, p0_.primerapellido AS primerapellido_3, p0_.segundoapellido AS segundoapellido_4, p0_.documento AS documento_5, p0_.estado AS estado_6, p0_.fechanacimiento AS fechanacimiento_7, p0_.direccion AS direccion_8, p0_.telefono AS telefono_9, p0_.email AS email_10, p0_.idintegracion AS idintegracion_11, p0_.documentfile AS documentfile_12, p0_.tipodocumento_id AS tipodocumento_id_13, p0_.municipio_id AS municipio_id_14, p0_.empresa_id AS empresa_id_15, p0_.tipopago_id AS tipopago_id_16, p0_.catalogoprecio_id AS catalogoprecio_id_17, p0_.tipocliente_id AS tipocliente_id_18, p0_.resptributaria_id AS resptributaria_id_19, p0_.posicionfiscal_id AS posicionfiscal_id_20 FROM persona p0_ WHERE p0_.documento = ? ORDER BY p0_.primernombre ASC
Parameters:
[
"1116723063"
]
|
|
0.62 ms (1.96%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.codigo AS codigo_2, m0_.departamento_id AS departamento_id_3 FROM municipio m0_
Parameters:
[] |
|
0.59 ms (1.86%) |
1 |
SELECT e0_.id AS id_0, e0_.descripcion AS descripcion_1, e0_.estado AS estado_2, e0_.direccion AS direccion_3, e0_.empresa_id AS empresa_id_4, e0_.tipoentidad_id AS tipoentidad_id_5, e0_.municipio_id AS municipio_id_6 FROM entidad e0_
Parameters:
[] |
|
0.58 ms (1.82%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.telefono AS telefono_3, t0.persona_id AS persona_id_4 FROM asistenteprofesional t0 WHERE t0.persona_id = ?
Parameters:
[
1002
]
|
|
0.43 ms (1.36%) |
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 INNER JOIN profesionales_asistenteprofesional ON t0.id = profesionales_asistenteprofesional.profesionales_id WHERE profesionales_asistenteprofesional.asistenteprofesional_id = ?
Parameters:
[
85
]
|
|
0.42 ms (1.34%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM rol t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
0.39 ms (1.22%) |
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_ASISTENTE" ] |
|
0.36 ms (1.14%) |
1 |
SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.descripcion AS descripcion_2 FROM estadocobertura e0_
Parameters:
[] |
|
0.33 ms (1.05%) |
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.29 ms (0.91%) |
1 |
SELECT t0.id AS id_1, t0.urlconexion AS urlconexion_2, t0.basededatos AS basededatos_3, t0.usuario AS usuario_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.idusuario AS idusuario_7, t0.sync_quiropay_recargas AS sync_quiropay_recargas_8, t0.sync_pedidos AS sync_pedidos_9, t0.sync_comprobantes_pedidos AS sync_comprobantes_pedidos_10 FROM sincronizacion t0
Parameters:
[] |
|
0.28 ms (0.88%) |
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:
[
77
]
|
|
0.25 ms (0.78%) |
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.24 ms (0.75%) |
1 |
SELECT t0.id AS id_1, t0.maxprocedalta AS maxprocedalta_2, t0.maxnumprocedimiento AS maxnumprocedimiento_3, t0.edadmin AS edadmin_4, t0.edadmax AS edadmax_5, t0.imcmax AS imcmax_6, t0.asa AS asa_7, t0.hemoglobinamax AS hemoglobinamax_8, t0.consumidorfinal AS consumidorfinal_9, t0.catalogoprecio_id AS catalogoprecio_id_10 FROM config_cobertura t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.23 ms (0.74%) |
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:
[] |
|
0.21 ms (0.66%) |
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.20 ms (0.63%) |
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
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\Entidad | 242 |
| App\Entity\Empresa | 233 |
| App\Entity\Solicitudcobertura | 62 |
| App\Entity\Persona | 56 |
| App\Entity\Departamento | 33 |
| App\Entity\Paqueteproducto | 23 |
| App\Entity\Estadocobertura | 13 |
| App\Entity\Subtipoproducto | 10 |
| App\Entity\User | 7 |
| App\Entity\MenuItem | 7 |
| App\Entity\Poliza | 6 |
| App\Entity\Tipodocumento | 5 |
| App\Entity\Tiporesponsabilidad | 5 |
| App\Entity\Resptributaria | 4 |
| App\Entity\GrupoListasPrecios | 3 |
| App\Entity\Categoriaproducto | 2 |
| App\Entity\Rol | 1 |
| App\Entity\Sincronizacion | 1 |
| App\Entity\Asistenteprofesional | 1 |
| App\Entity\Profesionales | 1 |
| App\Entity\Profesion | 1 |
| App\Entity\Comercial | 1 |
| App\Entity\Estadoprofesional | 1 |
| App\Entity\Tipofacturacion | 1 |
| App\Entity\Tipopago | 1 |
| App\Entity\ConfigCobertura | 1 |
| App\Entity\Catalogoprecio | 1 |
| App\Entity\Tipocliente | 1 |
| App\Entity\Tipoentidad | 1 |
| App\Entity\Tipoproducto | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Persona |
|
| App\Entity\Rol | No errors. |
| App\Entity\Solicitudcobertura |
|
| App\Entity\Bloqueofactura | No errors. |
| App\Entity\QuiroPay | No errors. |
| App\Entity\Modulo | No errors. |
| App\Entity\Sincronizacion | No errors. |
| App\Entity\Tipodocumento | No errors. |
| App\Entity\Municipio | No errors. |
| App\Entity\Departamento | No errors. |
| App\Entity\Empresa |
|
| App\Entity\Entidad | No errors. |
| App\Entity\Asistenteprofesional | No errors. |
| App\Entity\Profesionales |
|
| 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\GrupoListasPrecios | No errors. |
| App\Entity\Contactoreferencia | No errors. |
| App\Entity\Especializaciones | No errors. |
| App\Entity\Poliza | No errors. |
| App\Entity\AgendaProfesional | No errors. |
| App\Entity\Servicio |
|
| App\Entity\CitaProducto |
|
| App\Entity\Paqueteproducto | No errors. |
| App\Entity\Estadocobertura | No errors. |
| App\Entity\Categoriaproducto | No errors. |
| App\Entity\Tipopago |
|
| App\Entity\Productos | No errors. |
| App\Entity\Activarcobertura | No errors. |
| App\Entity\ConfigCobertura |
|
| App\Entity\Catalogoprecio | No errors. |
| App\Entity\ConfigCoberturaCategoriaproducto | No errors. |
| App\Entity\Tiporesponsabilidad |
|
| App\Entity\Resptributaria | No errors. |
| App\Entity\Tipocliente | No errors. |
| App\Entity\Pedido |
|
| App\Entity\Tipoentidad | No errors. |
| App\Entity\Tipoproducto | No errors. |
| App\Entity\Subtipoproducto | No errors. |
| App\Entity\CatalogoprecioProducto |
|
| App\Entity\ConfigPaqueteVar | No errors. |
| App\Entity\TipoclienteProducto | No errors. |
| App\Entity\MenuItem | No errors. |