Query Metrics
289
Database Queries
3
Different statements
280.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
187.32 ms (66.75%) |
144 |
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_usuario = ? AND t0.activa = ? LIMIT 1
Parameters:
[ 172 1 ] |
|
89.36 ms (31.84%) |
144 |
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:
[
162
]
|
|
3.96 ms (1.41%) |
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
Parameters:
[] |
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\Cuenta | No errors. |
| App\Entity\Catalogos\EstadoCuenta | No errors. |
| App\Entity\Catalogos\Parroquias | No errors. |
| App\Entity\Fidelizacion\CategoriaCliente | No errors. |