https://appsrv.lemontree-gastrobar.com/getClienteFidelizacion Return to referer URL

Query Metrics

27 Database Queries
7 Different statements
10.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.