Query Metrics
4
Database Queries
4
Different statements
4.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.76 ms (55.53%) |
1 |
SELECT o0_.id AS id_0, o0_.cantidad AS cantidad_1, o0_.cortesia AS cortesia_2, o0_.modificar_stock AS modificar_stock_3, o0_.fecha_hora_pedido AS fecha_hora_pedido_4, o0_.fecha_hora_entrega AS fecha_hora_entrega_5, o0_.estado AS estado_6, o0_.id_usuario_modificacion AS id_usuario_modificacion_7, o0_.fecha_modificacion AS fecha_modificacion_8, o0_.ip_modificacion AS ip_modificacion_9, o0_.observacion_cortesia AS observacion_cortesia_10, o0_.precio_unitario_menu AS precio_unitario_menu_11, o0_.precio_costo AS precio_costo_12, m1_.id AS id_13, m1_.nombre AS nombre_14, m1_.descripcion AS descripcion_15, m1_.precio AS precio_16, m1_.activo AS activo_17, m1_.publicar AS publicar_18, m1_.control_componente AS control_componente_19, m1_.acompanamiento AS acompanamiento_20, m1_.codigo AS codigo_21, m1_.id_usuario_modificacion AS id_usuario_modificacion_22, m1_.fecha_modificacion AS fecha_modificacion_23, m1_.ip_modificacion AS ip_modificacion_24, o0_.id_cuenta AS id_cuenta_25, o0_.id_menu AS id_menu_26, o0_.id_porcentaje_iva AS id_porcentaje_iva_27, m1_.id_categoria_producto AS id_categoria_producto_28 FROM comercio.orden_menu o0_ LEFT JOIN producto.menu m1_ ON o0_.id_menu = m1_.id WHERE o0_.id_cuenta = ? ORDER BY o0_.id DESC
Parameters:
[
"3719"
]
|
|
1.12 ms (22.57%) |
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
]
|
|
0.75 ms (15.01%) |
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.34 ms (6.89%) |
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\OrdenMenu | No errors. |
| App\Entity\Producto\Menu | No errors. |
| App\Entity\Comercio\Cuenta | No errors. |
| App\Entity\Catalogos\CategoriaProducto | No errors. |