Query Metrics
121
Database Queries
7
Different statements
26.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.24 ms (91.65%) |
100 |
SELECT m0_.id AS id_0, m0_.monto_inicial AS monto_inicial_1, m0_.monto_final AS monto_final_2, m0_.fecha_creacion AS fecha_creacion_3, m0_.fecha_actualizacion AS fecha_actualizacion_4, m0_.caja_id AS caja_id_5, m0_.moneda_id AS moneda_id_6 FROM mc_caja_monedas m0_ WHERE m0_.caja_id = ?
Parameters:
[
119
]
|
|
0.83 ms (3.14%) |
7 |
SELECT t0.id AS id_1, t0.usuario AS usuario_2, t0.password AS password_3, t0.salt AS salt_4, t0.estado AS estado_5, t0.fecha_creacion AS fecha_creacion_6, t0.fecha_actualizacion AS fecha_actualizacion_7, t0.id_persona AS id_persona_8, t0.cliente_id AS cliente_id_9 FROM mc_usuarios t0 WHERE t0.id = ?
Parameters:
[
30
]
|
|
0.67 ms (2.55%) |
7 |
SELECT t0.id AS id_1, t0.apellido AS apellido_2, t0.nombre AS nombre_3, t0.dni AS dni_4, t0.cuil AS cuil_5, t0.fecha_nacimiento AS fecha_nacimiento_6, t0.email AS email_7, t0.fecha_creacion AS fecha_creacion_8, t0.fecha_actualizacion AS fecha_actualizacion_9 FROM mc_personas t0 WHERE t0.id = ?
Parameters:
[
"42"
]
|
|
0.40 ms (1.52%) |
4 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.12 ms (0.46%) |
1 |
SELECT m0_.id AS id_0, m0_.cerrado AS cerrado_1, m0_.tipo AS tipo_2, m0_.fecha_creacion AS fecha_creacion_3, m0_.fecha_actualizacion AS fecha_actualizacion_4, m0_.usuario_id_open AS usuario_id_open_5, m0_.usuario_id_close AS usuario_id_close_6 FROM mc_cajas m0_ WHERE m0_.tipo = ? ORDER BY m0_.fecha_creacion DESC LIMIT 100
Parameters:
[
"operador"
]
|
|
0.09 ms (0.35%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3 FROM mc_roles t0 INNER JOIN mc_usuarios_roles ON t0.id = mc_usuarios_roles.rol_id WHERE mc_usuarios_roles.usuario_id = ?
Parameters:
[
30
]
|
|
0.09 ms (0.33%) |
1 |
SELECT COUNT(m0_.id) AS sclr_0 FROM mc_cajas m0_ WHERE m0_.tipo = ? ORDER BY m0_.fecha_creacion DESC
Parameters:
[
"operador"
]
|
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 |
|---|---|
| Noahtech\Sistemas\InterjamaBundle\Entity\McUsuario | No errors. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McPersona | No errors. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McCliente | No errors. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McRol | No errors. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McCaja | No errors. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McCajaMoneda | No errors. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McMoneda | No errors. |