Query Metrics
856
Database Queries
9
Different statements
263.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
61.85 ms (23.51%) |
128 |
SELECT p0_.id AS id_0, p0_.valor AS valor_1, p0_.fecha_hora_pago AS fecha_hora_pago_2, p0_.pago_total AS pago_total_3, p0_.id_usuario_modificacion AS id_usuario_modificacion_4, p0_.fecha_modificacion AS fecha_modificacion_5, p0_.ip_modificacion AS ip_modificacion_6, p0_.id_usuario AS id_usuario_7 FROM contabilidad.pagos p0_ WHERE p0_.fecha_hora_pago >= ? AND p0_.fecha_hora_pago <= ? AND p0_.id_usuario = ?
Parameters:
[ "2024-12-01 00:00:00" "2025-10-22 23:59:59" 4 ] |
|
61.73 ms (23.46%) |
149 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.id_usuario_modificacion AS id_usuario_modificacion_3, t0.fecha_modificacion AS fecha_modificacion_4, t0.ip_modificacion AS ip_modificacion_5, t0.id_pagos AS id_pagos_6, t0.id_parametros_fidelizacion AS id_parametros_fidelizacion_7 FROM fidelizacion.fidelizacion t0 WHERE t0.id_pagos = ?
Parameters:
[
2458
]
|
|
36.19 ms (13.75%) |
128 |
SELECT t0.id AS id_1, t0.tipo_identificacion AS tipo_identificacion_2, t0.numero_identificacion AS numero_identificacion_3, t0.apellidos AS apellidos_4, t0.nombres AS nombres_5, t0.mail_personal AS mail_personal_6, t0.tel_celular AS tel_celular_7, t0.fecha_nacimiento AS fecha_nacimiento_8, t0.direccion_sector AS direccion_sector_9, t0.id_usuario_modificacion AS id_usuario_modificacion_10, t0.fecha_modificacion AS fecha_modificacion_11, t0.ip_modificacion AS ip_modificacion_12, t0.foto AS foto_13, t0.id_parroquias AS id_parroquias_14, t0.id_categoria_cliente AS id_categoria_cliente_15 FROM persona.persona t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
34.28 ms (13.03%) |
149 |
SELECT t0.id AS id_1, t0.porcentaje AS porcentaje_2, t0.valor AS valor_3, t0.observacion AS observacion_4, t0.id_usuario_modificacion AS id_usuario_modificacion_5, t0.fecha_modificacion AS fecha_modificacion_6, t0.ip_modificacion AS ip_modificacion_7, t0.id_pagos AS id_pagos_8 FROM contabilidad.descuentos t0 WHERE t0.id_pagos = ?
Parameters:
[
2458
]
|
|
34.18 ms (12.99%) |
149 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.observacion AS observacion_3, t0.id_usuario_modificacion AS id_usuario_modificacion_4, t0.fecha_modificacion AS fecha_modificacion_5, t0.ip_modificacion AS ip_modificacion_6, t0.id_pagos AS id_pagos_7 FROM contabilidad.pago_fidelizacion t0 WHERE t0.id_pagos = ?
Parameters:
[
2458
]
|
|
32.31 ms (12.28%) |
149 |
SELECT t0.id AS id_1, t0.valor AS valor_2, t0.id_usuario_modificacion AS id_usuario_modificacion_3, t0.fecha_modificacion AS fecha_modificacion_4, t0.ip_modificacion AS ip_modificacion_5, t0.id_cupones AS id_cupones_6, t0.id_pagos AS id_pagos_7 FROM fidelizacion.uso_cupones t0 WHERE t0.id_pagos = ?
Parameters:
[
2458
]
|
|
1.51 ms (0.57%) |
1 |
SELECT t0.id AS id_1, t0.usuario AS usuario_2, t0.password AS password_3, t0.usuario_gmail AS usuario_gmail_4, t0.activo AS activo_5, t0.bloqueado AS bloqueado_6, t0.super_admin AS super_admin_7, t0.nueva_clave AS nueva_clave_8, t0.id_usuario_modificacion AS id_usuario_modificacion_9, t0.fecha_modificacion AS fecha_modificacion_10, t0.ip_modificacion AS ip_modificacion_11, t0.id_persona AS id_persona_12 FROM seguridades.usuario t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.55 ms (0.21%) |
2 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.nivel AS nivel_4, t0.id_usuario_modificacion AS id_usuario_modificacion_5, t0.fecha_modificacion AS fecha_modificacion_6, t0.ip_modificacion AS ip_modificacion_7, t0.base AS base_8 FROM fidelizacion.categoria_cliente t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.54 ms (0.21%) |
1 |
SELECT t0.id AS id_1, t0.usuario AS usuario_2, t0.password AS password_3, t0.usuario_gmail AS usuario_gmail_4, t0.activo AS activo_5, t0.bloqueado AS bloqueado_6, t0.super_admin AS super_admin_7, t0.nueva_clave AS nueva_clave_8, t0.id_usuario_modificacion AS id_usuario_modificacion_9, t0.fecha_modificacion AS fecha_modificacion_10, t0.ip_modificacion AS ip_modificacion_11, t0.id_persona AS id_persona_12 FROM seguridades.usuario t0 ORDER BY t0.id ASC
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\Seguridades\Usuario | No errors. |
| App\Entity\Persona\Persona | No errors. |
| App\Entity\Contabilidad\Pagos | No errors. |
| App\Entity\Fidelizacion\Fidelizacion | No errors. |
| App\Entity\Fidelizacion\ParametrosFidelizacion | No errors. |
| App\Entity\Contabilidad\PagoFidelizacion | No errors. |
| App\Entity\Contabilidad\Descuentos | No errors. |
| App\Entity\Fidelizacion\UsoCupones | No errors. |
| App\Entity\Fidelizacion\Cupones | No errors. |
| App\Entity\Catalogos\Parroquias | No errors. |
| App\Entity\Fidelizacion\CategoriaCliente | No errors. |