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

Query Metrics

13 Database Queries
7 Different statements
1.84 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.52 ms
(28.37%)
4
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.42 ms
(22.83%)
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:
[
  "3"
]
0.33 ms
(17.87%)
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 FROM mc_movimientos m0_ WHERE m0_.caja_id = ?
Parameters:
[
  "3"
]
0.21 ms
(11.48%)
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:
[
  3
]
0.18 ms
(9.86%)
2
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"
]
0.09 ms
(5.06%)
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.08 ms
(4.53%)
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.