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

Grouped Statements

Show all queries

Time Count Info
1.16 ms
(15.03%)
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.01 ms
(13.16%)
1
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
]
0.76 ms
(9.91%)
2
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
]
0.72 ms
(9.33%)
2
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
]
0.70 ms
(9.09%)
2
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
]
0.67 ms
(8.77%)
2
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
]
0.64 ms
(8.29%)
2
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
]
0.61 ms
(7.98%)
2
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
]
0.59 ms
(7.62%)
2
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
]
0.44 ms
(5.65%)
1
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
]
0.40 ms
(5.17%)
1
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
]

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.