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

Query Metrics

5 Database Queries
5 Different statements
4.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.77 ms
(39.14%)
1
SELECT p0_.id AS id_0, p0_.cantidad_pagada AS cantidad_pagada_1, p0_.id_pagos AS id_pagos_2, p0_.id_menu AS id_menu_3, p0_.id_cuenta AS id_cuenta_4 FROM contabilidad.pago_cuenta p0_ WHERE p0_.id IN (SELECT MIN(p1_.id) AS sclr_5 FROM contabilidad.pago_cuenta p1_ INNER JOIN comercio.cuenta c2_ ON p1_.id_cuenta = c2_.id WHERE c2_.id = ? GROUP BY p1_.id_pagos)
Parameters:
[
  "3893"
]
1.10 ms
(24.33%)
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.78 ms
(17.19%)
1
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_medio_pago AS id_medio_pago_6, t0.id_pagos AS id_pagos_7, t0.id_entidad_financiera AS id_entidad_financiera_8 FROM contabilidad.detalle_pagos t0 WHERE t0.id_pagos = ?
Parameters:
[
  3821
]
0.44 ms
(9.77%)
1
SELECT t0.id AS id_1, t0.nombre_original AS nombre_original_2, t0.nombre_almacenado AS nombre_almacenado_3, t0.tamanio AS tamanio_4, t0.url AS url_5, t0.imagen AS imagen_6, t0.estado AS estado_7, t0.id_usuario_modificacion AS id_usuario_modificacion_8, t0.fecha_modificacion AS fecha_modificacion_9, t0.ip_modificacion AS ip_modificacion_10 FROM documentos.carga_documento t0 WHERE t0.id = ?
Parameters:
[
  2790
]
0.43 ms
(9.57%)
1
SELECT t0.id AS id_1, t0.id_usuario_modificacion AS id_usuario_modificacion_2, t0.fecha_modificacion AS fecha_modificacion_3, t0.ip_modificacion AS ip_modificacion_4, t0.id_carga_documento AS id_carga_documento_5, t0.id_detalle_pagos AS id_detalle_pagos_6 FROM documentos.documentos_detalle_pagos t0 WHERE t0.id_detalle_pagos = ? LIMIT 1
Parameters:
[
  4316
]

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.