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

Query Metrics

33 Database Queries
10 Different statements
10.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.55 ms
(42.69%)
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:
[
  "326"
]
2.63 ms
(24.66%)
10
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.tipo_pago_deuda AS tipo_pago_deuda_33, t0.comprobante_deuda AS comprobante_deuda_34, t0.cliente_id AS cliente_id_35, t0.moneda_id AS moneda_id_36, t0.user_id AS user_id_37 FROM mc_precarga t0 WHERE t0.id = ?
Parameters:
[
  5131
]
1.83 ms
(17.17%)
10
SELECT t0.id AS id_1, t0.dominio1 AS dominio1_2, t0.dominio2 AS dominio2_3, t0.ticket AS ticket_4, t0.tipo_pago AS tipo_pago_5, t0.importe AS importe_6, t0.facturado AS facturado_7, t0.crt AS crt_8, t0.chofer AS chofer_9, t0.fecha_creacion AS fecha_creacion_10, t0.fecha_actualizacion AS fecha_actualizacion_11, t0.cliente_id AS cliente_id_12, t0.moneda_id AS moneda_id_13 FROM mc_pesaje t0 WHERE t0.id = ?
Parameters:
[
  1153
]
0.53 ms
(5.00%)
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:
[
  "326"
]
0.30 ms
(2.85%)
3
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.razon_social AS razon_social_3, t0.cuit AS cuit_4, t0.celular AS celular_5, t0.condicion_iva AS condicion_iva_6, t0.mail AS mail_7, t0.mail_alternativo AS mail_alternativo_8, t0.celular2 AS celular2_9, t0.direccion AS direccion_10, t0.representante_legal AS representante_legal_11, t0.archivo_poder AS archivo_poder_12, t0.archivo_presentacion AS archivo_presentacion_13, t0.fecha_alta AS fecha_alta_14, t0.fecha_creacion AS fecha_creacion_15, t0.fecha_actualizacion AS fecha_actualizacion_16 FROM mc_clientes t0 WHERE t0.id = ?
Parameters:
[
  233
]
0.29 ms
(2.75%)
2
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.21 ms
(1.96%)
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:
[
  326
]
0.12 ms
(1.13%)
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
(0.95%)
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:
[
  "50"
]
0.09 ms
(0.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.