https://interjama.com.ar/atencion/ajax/turnos/search?direction=DESC&page=1&sort=id

Query Metrics

4 Database Queries
4 Different statements
1.02 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.16 ms
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:
[
  32
]
2 0.10 ms
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:
[
  32
]
3 0.43 ms
SELECT COUNT(m0_.id) AS sclr_0 FROM mc_turnos m0_ WHERE m0_.fecha_creacion >= ? AND m0_.fecha_creacion <= ? AND m0_.atendido = 0 ORDER BY m0_.id ASC
Parameters:
[
  "2025-07-21 00:00:00"
  "2025-07-21 23:59:59"
]
4 0.33 ms
SELECT m0_.id AS id_0, m0_.observacion AS observacion_1, m0_.atendido AS atendido_2, m0_.fecha_creacion AS fecha_creacion_3, m0_.fecha_actualizacion AS fecha_actualizacion_4 FROM mc_turnos m0_ WHERE m0_.fecha_creacion >= ? AND m0_.fecha_creacion <= ? AND m0_.atendido = 0 ORDER BY m0_.id ASC LIMIT 100
Parameters:
[
  "2025-07-21 00:00:00"
  "2025-07-21 23:59:59"
]

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\McTurno No errors.