Query Metrics
27
Database Queries
7
Different statements
10.07 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.82 ms (27.98%) |
6 |
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:
[
2577
]
|
1.63 ms (16.17%) |
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
]
|
1.45 ms (14.40%) |
6 |
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:
[
2577
]
|
1.42 ms (14.11%) |
6 |
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:
[
2577
]
|
1.29 ms (12.80%) |
6 |
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:
[
2577
]
|
0.90 ms (8.93%) |
1 |
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:
[ "2025-01-01 00:00:00" "2025-12-31 23:59:59" 4 ] |
0.57 ms (5.61%) |
1 |
SELECT t0.id AS id_1, t0.codigo_cuenta AS codigo_cuenta_2, t0.fecha_hora_apertura AS fecha_hora_apertura_3, t0.fecha_hora_cierre AS fecha_hora_cierre_4, t0.activa AS activa_5, t0.numero_mesa AS numero_mesa_6, t0.id_usuario_modificacion AS id_usuario_modificacion_7, t0.fecha_modificacion AS fecha_modificacion_8, t0.ip_modificacion AS ip_modificacion_9, t0.id_usuario AS id_usuario_10, t0.id_estado_cuenta AS id_estado_cuenta_11 FROM comercio.cuenta t0 WHERE t0.id = ?
Parameters:
[
"3491"
]
|
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\Comercio\Cuenta | No errors. |
App\Entity\Catalogos\EstadoCuenta | 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. |