https://appsrv.lemontree-gastrobar.com/getInitialCuentas?_=1783370752367

Query Metrics

16 Database Queries
7 Different statements
14.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.66 ms
(38.63%)
3
SELECT t0.id AS id_1, t0.cantidad AS cantidad_2, t0.cortesia AS cortesia_3, t0.modificar_stock AS modificar_stock_4, t0.fecha_hora_pedido AS fecha_hora_pedido_5, t0.fecha_hora_entrega AS fecha_hora_entrega_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, t0.observacion_cortesia AS observacion_cortesia_11, t0.precio_unitario_menu AS precio_unitario_menu_12, t0.precio_costo AS precio_costo_13, t0.id_cuenta AS id_cuenta_14, t0.id_menu AS id_menu_15, t0.id_porcentaje_iva AS id_porcentaje_iva_16 FROM comercio.orden_menu t0 WHERE t0.id_cuenta = ?
Parameters:
[
  3917
]
3.76 ms
(25.65%)
3
SELECT t0.id AS id_1, t0.cantidad_pagada AS cantidad_pagada_2, t0.id_pagos AS id_pagos_3, t0.id_menu AS id_menu_4, t0.id_cuenta AS id_cuenta_5 FROM contabilidad.pago_cuenta t0 WHERE t0.id_cuenta = ? LIMIT 1
Parameters:
[
  3917
]
1.53 ms
(10.41%)
4
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:
[
  75
]
1.14 ms
(7.75%)
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_estado_cuenta = ? ORDER BY t0.id DESC
Parameters:
[
  7
]
1.10 ms
(7.49%)
3
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:
[
  74
]
0.92 ms
(6.28%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nombre_comercial AS nombre_comercial_3, t0.fecha_inicio_actividades AS fecha_inicio_actividades_4, t0.logo AS logo_5, t0.ruc AS ruc_6, t0.correo AS correo_7, t0.pagina_web AS pagina_web_8, t0.telefono AS telefono_9, t0.direccion_matriz AS direccion_matriz_10, t0.direccion_establecimiento AS direccion_establecimiento_11, t0.codigo_establecimiento AS codigo_establecimiento_12, t0.codigo_punto_emision AS codigo_punto_emision_13, t0.facturar AS facturar_14, t0.id_persona AS id_persona_15, t0.id_personeria AS id_personeria_16, t0.id_porcentaje_iva AS id_porcentaje_iva_17 FROM comercio.datos_comercio t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.55 ms
(3.78%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3, t0.porcentaje AS porcentaje_4, t0.activo AS activo_5 FROM catalogos.porcentaje_iva t0 WHERE t0.id = ?
Parameters:
[
  3
]

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.