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

Method
POST
HTTP Status
200
IP
157.100.88.32
Profiled on
Token
cd1748

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 1.63 ms 
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
]
View formatted query    View runnable query    Explain query
2 0.57 ms 
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"
]
View formatted query    View runnable query    Explain query
3 0.90 ms 
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
]
View formatted query    View runnable query    Explain query
4 0.71 ms 
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
]
View formatted query    View runnable query    Explain query
5 0.38 ms 
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
]
View formatted query    View runnable query    Explain query
6 0.35 ms 
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
]
View formatted query    View runnable query    Explain query
7 0.32 ms 
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
]
View formatted query    View runnable query    Explain query
8 0.52 ms 
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: 
[
  2674
]
View formatted query    View runnable query    Explain query
9 0.24 ms 
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: 
[
  2674
]
View formatted query    View runnable query    Explain query
10 0.22 ms 
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: 
[
  2674
]
View formatted query    View runnable query    Explain query
11 0.23 ms 
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: 
[
  2674
]
View formatted query    View runnable query    Explain query
12 0.42 ms 
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: 
[
  2893
]
View formatted query    View runnable query    Explain query
13 0.24 ms 
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: 
[
  2893
]
View formatted query    View runnable query    Explain query
14 0.25 ms 
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: 
[
  2893
]
View formatted query    View runnable query    Explain query
15 0.18 ms 
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: 
[
  2893
]
View formatted query    View runnable query    Explain query
16 0.39 ms 
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: 
[
  3032
]
View formatted query    View runnable query    Explain query
17 0.20 ms 
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: 
[
  3032
]
View formatted query    View runnable query    Explain query
18 0.21 ms 
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: 
[
  3032
]
View formatted query    View runnable query    Explain query
19 0.19 ms 
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: 
[
  3032
]
View formatted query    View runnable query    Explain query
20 0.38 ms 
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: 
[
  3136
]
View formatted query    View runnable query    Explain query
21 0.20 ms 
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: 
[
  3136
]
View formatted query    View runnable query    Explain query
22 0.18 ms 
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: 
[
  3136
]
View formatted query    View runnable query    Explain query
23 0.17 ms 
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: 
[
  3136
]
View formatted query    View runnable query    Explain query
24 0.40 ms 
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: 
[
  3161
]
View formatted query    View runnable query    Explain query
25 0.20 ms 
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: 
[
  3161
]
View formatted query    View runnable query    Explain query
26 0.21 ms 
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: 
[
  3161
]
View formatted query    View runnable query    Explain query
27 0.19 ms 
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: 
[
  3161
]
View formatted query    View runnable query    Explain query

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.