Query Metrics
13
Database Queries
7
Different statements
1.84 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.17 ms |
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
]
|
2 | 0.09 ms |
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
]
|
3 | 0.30 ms |
SELECT t0.id AS id_1, t0.cerrado AS cerrado_2, t0.tipo AS tipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.fecha_actualizacion AS fecha_actualizacion_5, t0.usuario_id_open AS usuario_id_open_6, t0.usuario_id_close AS usuario_id_close_7 FROM mc_cajas t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3"
]
|
4 | 0.12 ms |
SELECT t0.id AS id_1, t0.cerrado AS cerrado_2, t0.tipo AS tipo_3, t0.fecha_creacion AS fecha_creacion_4, t0.fecha_actualizacion AS fecha_actualizacion_5, t0.usuario_id_open AS usuario_id_open_6, t0.usuario_id_close AS usuario_id_close_7 FROM mc_cajas t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3"
]
|
5 | 0.11 ms |
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:
[
1
]
|
6 | 0.09 ms |
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:
[
"1"
]
|
7 | 0.09 ms |
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:
[
"40"
]
|
8 | 0.09 ms |
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:
[
3
]
|
9 | 0.08 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ?
Parameters:
[
1
]
|
10 | 0.12 ms |
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:
[
3
]
|
11 | 0.33 ms |
SELECT m0_.id AS id_0, m0_.monto AS monto_1, m0_.modalidad AS modalidad_2, m0_.detalle AS detalle_3, m0_.tipo AS tipo_4, m0_.tipo_detalle AS tipo_detalle_5, m0_.devolucion AS devolucion_6, m0_.monto_devolucion AS monto_devolucion_7, m0_.facturado AS facturado_8, m0_.fecha_creacion AS fecha_creacion_9, m0_.fecha_actualizacion AS fecha_actualizacion_10, m0_.caja_id AS caja_id_11, m0_.cliente_id AS cliente_id_12, m0_.chofer_id AS chofer_id_13, m0_.usuario_id AS usuario_id_14, m0_.moneda_id AS moneda_id_15, m0_.precarga_id AS precarga_id_16 FROM mc_movimientos m0_ WHERE m0_.caja_id = ?
Parameters:
[
"3"
]
|
12 | 0.14 ms |
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:
[
33
]
|
13 | 0.10 ms |
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:
[
32
]
|
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. |
Noahtech\Sistemas\InterjamaBundle\Entity\McMovimiento | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McChofer | No errors. |
Noahtech\Sistemas\InterjamaBundle\Entity\McPrecarga | No errors. |