https://interjama.com.ar/admin/ajax/cajas/178/descarga

Query Metrics

15 Database Queries
8 Different statements
5.57 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.