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

Query Metrics

18 Database Queries
11 Different statements
7.70 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 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
]
2 1.01 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.fecha AS fecha_3, t0.valor_sin_iva AS valor_sin_iva_4, t0.porcentaje_iva AS porcentaje_iva_5, t0.iva AS iva_6, t0.valor_descuento AS valor_descuento_7, t0.valor_iva_cero AS valor_iva_cero_8, t0.pagada AS pagada_9, t0.credito AS credito_10, t0.numero_pagos_credito AS numero_pagos_credito_11, t0.id_usuario_modificacion AS id_usuario_modificacion_12, t0.fecha_modificacion AS fecha_modificacion_13, t0.ip_modificacion AS ip_modificacion_14, t0.observacion AS observacion_15, t0.registrado AS registrado_16, t0.compra_bien AS compra_bien_17, t0.id_medio_pago AS id_medio_pago_18, t0.id_proveedores AS id_proveedores_19, t0.id_subtipo_gasto AS id_subtipo_gasto_20, t0.id_tipo_comprobante_compra AS id_tipo_comprobante_compra_21 FROM contabilidad.comprobantes_compra t0 WHERE t0.registrado = ? ORDER BY t0.fecha DESC
Parameters:
[
  0
]
3 0.47 ms
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.porcentaje = ? LIMIT 1
Parameters:
[
  15.0
]
4 0.35 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.impuestos AS impuestos_4 FROM catalogos.tipo_comprobante_compra t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.40 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3 FROM catalogos.medio_pago t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.47 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.ruc AS ruc_3, t0.telefono_empresa AS telefono_empresa_4, t0.correo_electronico AS correo_electronico_5, t0.pagina_web AS pagina_web_6, t0.direccion AS direccion_7, t0.tipo AS tipo_8, t0.ofrece_credito AS ofrece_credito_9, t0.dias_credito AS dias_credito_10, t0.id_usuario_modificacion AS id_usuario_modificacion_11, t0.fecha_modificacion AS fecha_modificacion_12, t0.ip_modificacion AS ip_modificacion_13, t0.id_parroquias AS id_parroquias_14 FROM producto.proveedores t0 WHERE t0.id = ?
Parameters:
[
  9
]
7 0.25 ms
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.porcentaje = ? LIMIT 1
Parameters:
[
  0.0
]
8 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.impuestos AS impuestos_4 FROM catalogos.tipo_comprobante_compra t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 0.30 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.ruc AS ruc_3, t0.telefono_empresa AS telefono_empresa_4, t0.correo_electronico AS correo_electronico_5, t0.pagina_web AS pagina_web_6, t0.direccion AS direccion_7, t0.tipo AS tipo_8, t0.ofrece_credito AS ofrece_credito_9, t0.dias_credito AS dias_credito_10, t0.id_usuario_modificacion AS id_usuario_modificacion_11, t0.fecha_modificacion AS fecha_modificacion_12, t0.ip_modificacion AS ip_modificacion_13, t0.id_parroquias AS id_parroquias_14 FROM producto.proveedores t0 WHERE t0.id = ?
Parameters:
[
  51
]
10 0.36 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.id_tipo_gasto AS id_tipo_gasto_4 FROM catalogos.subtipo_gasto t0 WHERE t0.id = ?
Parameters:
[
  6
]
11 0.37 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.produccion AS produccion_4 FROM catalogos.tipo_gasto t0 WHERE t0.id = ?
Parameters:
[
  8
]
12 0.46 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_cantones AS id_cantones_3 FROM catalogos.parroquias t0 WHERE t0.id = ?
Parameters:
[
  1061
]
13 0.44 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.id_provincias AS id_provincias_4 FROM catalogos.cantones t0 WHERE t0.id = ?
Parameters:
[
  182
]
14 0.44 ms
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.nombre AS nombre_3 FROM catalogos.provincias t0 WHERE t0.id = ?
Parameters:
[
  17
]
15 0.28 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.id_tipo_gasto AS id_tipo_gasto_4 FROM catalogos.subtipo_gasto t0 WHERE t0.id = ?
Parameters:
[
  11
]
16 0.25 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.produccion AS produccion_4 FROM catalogos.tipo_gasto t0 WHERE t0.id = ?
Parameters:
[
  1
]
17 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_cantones AS id_cantones_3 FROM catalogos.parroquias t0 WHERE t0.id = ?
Parameters:
[
  968
]
18 0.24 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3, t0.id_provincias AS id_provincias_4 FROM catalogos.cantones t0 WHERE t0.id = ?
Parameters:
[
  177
]

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.