https://interjama.com.ar/admin/ajax/cajas/search?direction=DESC&page=1&sort=fecha_creacion

Query Metrics

89 Database Queries
7 Different statements
9.17 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.13 ms
(77.74%)
70
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:
[
  72
]
0.78 ms
(8.49%)
6
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.58 ms
(6.32%)
6
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:
[
  "45"
]
0.38 ms
(4.19%)
4
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM mc_monedas t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.12 ms
(1.26%)
1
SELECT m0_.id AS id_0, m0_.cerrado AS cerrado_1, m0_.tipo AS tipo_2, m0_.fecha_creacion AS fecha_creacion_3, m0_.fecha_actualizacion AS fecha_actualizacion_4, m0_.usuario_id_open AS usuario_id_open_5, m0_.usuario_id_close AS usuario_id_close_6 FROM mc_cajas m0_ WHERE m0_.tipo = ? ORDER BY m0_.fecha_creacion DESC LIMIT 100
Parameters:
[
  "operador"
]
0.10 ms
(1.05%)
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.09 ms
(0.97%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM mc_cajas m0_ WHERE m0_.tipo = ? ORDER BY m0_.fecha_creacion DESC
Parameters:
[
  "operador"
]

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.