Query Metrics
18
Database Queries
11
Different statements
7.70 ms
Query time
0
Invalid entities
Queries
| #▲ | 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Seguridades\Usuario | No errors. |
| App\Entity\Persona\Persona | No errors. |
| App\Entity\Contabilidad\ComprobantesCompra | No errors. |
| App\Entity\Catalogos\MedioPago | No errors. |
| App\Entity\Producto\Proveedores | No errors. |
| App\Entity\Catalogos\SubtipoGasto | No errors. |
| App\Entity\Catalogos\TipoComprobanteCompra | No errors. |
| App\Entity\Catalogos\PorcentajeIva | No errors. |
| App\Entity\Catalogos\Parroquias | No errors. |
| App\Entity\Catalogos\TipoGasto | No errors. |
| App\Entity\Catalogos\Cantones | No errors. |
| App\Entity\Catalogos\Provincias | No errors. |