Query Metrics
89
Database Queries
7
Different statements
9.17 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.13 ms (77.74%) |
70 |
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:
[
72
]
|
0.78 ms (8.49%) |
6 |
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.58 ms (6.32%) |
6 |
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:
[
"45"
]
|
0.38 ms (4.19%) |
4 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.12 ms (1.26%) |
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.10 ms (1.05%) |
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.97%) |
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. |