Query Metrics
35
Database Queries
9
Different statements
24.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.07 ms (37.06%) |
6 |
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:
[
3891
]
|
|
5.88 ms (24.04%) |
6 |
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:
[
3891
]
|
|
2.99 ms (12.21%) |
7 |
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.09 ms (8.53%) |
6 |
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:
[
78
]
|
|
1.91 ms (7.80%) |
6 |
SELECT t0.id AS id_1, t0.fecha_reserva AS fecha_reserva_2, t0.hora_reserva AS hora_reserva_3, t0.estado AS estado_4, t0.numero_personas AS numero_personas_5, t0.porcentaje_abono AS porcentaje_abono_6, t0.observaciones AS observaciones_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.id_cuenta AS id_cuenta_11, t0.id_espacios AS id_espacios_12 FROM comercio.reserva t0 WHERE t0.id_cuenta = ? LIMIT 1
Parameters:
[
3891
]
|
|
1.14 ms (4.68%) |
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 IN (?, ?) ORDER BY t0.id DESC
Parameters:
[ 1 2 ] |
|
0.67 ms (2.75%) |
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.37 ms (1.51%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.activo AS activo_3 FROM catalogos.estado_cuenta t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.35 ms (1.42%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.porcentaje AS porcentaje_3, t0.activo AS activo_4 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Seguridades\Usuario | No errors. |
| App\Entity\Persona\Persona | No errors. |
| App\Entity\Comercio\DatosComercio | No errors. |
| App\Entity\Catalogos\Personeria | No errors. |
| App\Entity\Catalogos\PorcentajeIva | No errors. |
| App\Entity\Comercio\Cuenta | No errors. |
| App\Entity\Catalogos\EstadoCuenta | No errors. |
| App\Entity\Catalogos\Parroquias | No errors. |
| App\Entity\Fidelizacion\CategoriaCliente | No errors. |
| App\Entity\Comercio\OrdenMenu | No errors. |
| App\Entity\Producto\Menu | No errors. |
| App\Entity\Comercio\Reserva | No errors. |
| App\Entity\Infraestructura\Espacios | No errors. |
| App\Entity\Contabilidad\PagoCuenta | No errors. |
| App\Entity\Contabilidad\Pagos | No errors. |