Query Metrics
25
Database Queries
9
Different statements
17.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.06 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 | 0.63 ms |
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
]
|
| 3 | 1.30 ms |
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 ] |
| 4 | 0.28 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:
[
101
]
|
| 5 | 0.52 ms |
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:
[
100
]
|
| 6 | 0.34 ms |
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
]
|
| 7 | 2.21 ms |
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:
[
3808
]
|
| 8 | 0.36 ms |
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
]
|
| 9 | 0.42 ms |
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:
[
3808
]
|
| 10 | 1.17 ms |
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:
[
3808
]
|
| 11 | 0.25 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:
[
46
]
|
| 12 | 0.29 ms |
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:
[
47
]
|
| 13 | 1.43 ms |
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:
[
3794
]
|
| 14 | 0.26 ms |
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:
[
3794
]
|
| 15 | 0.85 ms |
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:
[
3794
]
|
| 16 | 0.32 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:
[
75
]
|
| 17 | 0.28 ms |
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
]
|
| 18 | 1.33 ms |
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:
[
3792
]
|
| 19 | 0.30 ms |
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:
[
3792
]
|
| 20 | 1.00 ms |
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:
[
3792
]
|
| 21 | 0.27 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:
[
146
]
|
| 22 | 0.31 ms |
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:
[
137
]
|
| 23 | 1.30 ms |
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:
[
3751
]
|
| 24 | 0.29 ms |
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:
[
3751
]
|
| 25 | 1.00 ms |
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:
[
3751
]
|
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. |