Query Metrics
15
Database Queries
8
Different statements
5.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.72 ms (48.76%) |
1 |
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, m0_.pesaje_id AS pesaje_id_17 FROM mc_movimientos m0_ WHERE m0_.caja_id = ?
Parameters:
[
"178"
]
|
|
1.25 ms (22.42%) |
4 |
SELECT t0.id AS id_1, t0.dominio1 AS dominio1_2, t0.dominio2 AS dominio2_3, t0.estado AS estado_4, t0.chofer AS chofer_5, t0.aduana_nombre AS aduana_nombre_6, t0.tramite AS tramite_7, t0.tipo_pago AS tipo_pago_8, t0.total AS total_9, t0.registro AS registro_10, t0.tras AS tras_11, t0.rg AS rg_12, t0.tlmd AS tlmd_13, t0.mani AS mani_14, t0.aduana AS aduana_15, t0.archivo_reverso AS archivo_reverso_16, t0.origen AS origen_17, t0.facturado AS facturado_18, t0.plazo AS plazo_19, t0.leido AS leido_20, t0.notificacion AS notificacion_21, t0.tipo_operacion AS tipo_operacion_22, t0.pais_origen AS pais_origen_23, t0.mercaderia AS mercaderia_24, t0.exp_imp AS exp_imp_25, t0.mercaderia_1 AS mercaderia_1_26, t0.fecha_pago AS fecha_pago_27, t0.fecha_creacion AS fecha_creacion_28, t0.fecha_actualizacion AS fecha_actualizacion_29, t0.comprobante AS comprobante_30, t0.detalle_cambio AS detalle_cambio_31, t0.motivo_edicion AS motivo_edicion_32, t0.cliente_id AS cliente_id_33, t0.moneda_id AS moneda_id_34, t0.user_id AS user_id_35 FROM mc_precarga t0 WHERE t0.id = ?
Parameters:
[
3345
]
|
|
0.49 ms (8.72%) |
3 |
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.47 ms (8.39%) |
2 |
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:
[
"178"
]
|
|
0.33 ms (5.88%) |
2 |
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:
[
178
]
|
|
0.11 ms (2.03%) |
1 |
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:
[
"47"
]
|
|
0.11 ms (1.95%) |
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.10 ms (1.85%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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. |
| Noahtech\Sistemas\InterjamaBundle\Entity\McPesaje | No errors. |