GET http://viaticos-test.ciencia.gba.gob.ar/notificaciones/poll?_=1782999705975&last_id=94

Query Metrics

7 Database Queries
7 Different statements
5.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.89 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.tipo_documento AS tipo_documento_4, t0.dni AS dni_5, t0.sexo AS sexo_6, t0.clase AS clase_7, t0.cuil AS cuil_8, t0.regimen_estatutario AS regimen_estatutario_9, t0.planta AS planta_10, t0.agrupamiento AS agrupamiento_11, t0.regimen_horario AS regimen_horario_12, t0.fecha_toma AS fecha_toma_13, t0.codigo_estructura AS codigo_estructura_14, t0.estructura_servicio AS estructura_servicio_15, t0.antiguedad AS antiguedad_16, t0.partido_laboral AS partido_laboral_17, t0.telefono AS telefono_18, t0.activo AS activo_19, t0.borrado AS borrado_20, t0.correo AS correo_21, t0.password AS password_22, t0.notificaciones_correo_activas AS notificaciones_correo_activas_23, t0.fecha_alta AS fecha_alta_24, t0.contratado AS contratado_25, t0.contrato_vigente AS contrato_vigente_26, t0.cbu AS cbu_27, t0.legajo AS legajo_28, t0.cuit AS cuit_29, t0.numero_categoria AS numero_categoria_30, t0.categoria_siape AS categoria_siape_31, t0.hash AS hash_32, t0.fecha_actualizacion AS fecha_actualizacion_33, t0.terminos_ycondiciones AS terminos_ycondiciones_34, t0.sistema_seleccionado AS sistema_seleccionado_35, t0.rol_id AS rol_id_36, t0.area_id AS area_id_37, t0.categoria_id AS categoria_id_38 FROM usuario t0 WHERE t0.id = ?
Parameters:
[
  133
]
2 0.73 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.abreviatura AS abreviatura_4, t0.color AS color_5 FROM rol t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.66 ms
SELECT COALESCE(MAX(n0_.id), 0) AS sclr_0 FROM notificacion n0_ WHERE n0_.usuario_id = ?
Parameters:
[
  133
]
4 0.55 ms
SELECT COUNT(n0_.id) AS sclr_0 FROM notificacion n0_ WHERE n0_.usuario_id = ? AND n0_.leida = ?
Parameters:
[
  133
  0
]
5 0.89 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM solicitud s0_ INNER JOIN area a1_ ON s0_.area_actual_id = a1_.id INNER JOIN solicitud_estado s2_ ON s0_.estado_id = s2_.id INNER JOIN cupo_tipo c3_ ON s0_.tipo_cupo_id = c3_.id WHERE a1_.id = ? AND s2_.id IN (?, ?) AND c3_.id = ?
Parameters:
[
  9
  2
  3
  1
]
6 0.79 ms
SELECT COUNT(r0_.id) AS sclr_0 FROM rendicion r0_ LEFT JOIN area a1_ ON r0_.area_id = a1_.id LEFT JOIN min_delegacion m2_ ON a1_.min_delegacion_id = m2_.id WHERE r0_.estado_id = ? AND r0_.pedido_de_fondo_id IS NULL AND m2_.id = 2
Parameters:
[
  2
]
7 0.80 ms
SELECT n0_.id AS id_0, n0_.descripcion AS descripcion_1, n0_.fecha AS fecha_2, n0_.leida AS leida_3, s1_.id AS id_4, s1_.fecha AS fecha_5, s1_.motivo AS motivo_6, s1_.motivo_rechazo AS motivo_rechazo_7, s1_.fecha_rechazo AS fecha_rechazo_8, s1_.monto_solicitado AS monto_solicitado_9, s1_.monto_aprobado AS monto_aprobado_10, s1_.monto_otorgado AS monto_otorgado_11, s1_.motivo_reduccion_de_monto AS motivo_reduccion_de_monto_12, s1_.cupo_cargado_leido_por_area AS cupo_cargado_leido_por_area_13, s1_.mes AS mes_14, s1_.ano AS ano_15, n0_.usuario_id AS usuario_id_16, n0_.solicitud_id AS solicitud_id_17, s1_.area_id AS area_id_18, s1_.tipo_id AS tipo_id_19, s1_.estado_id AS estado_id_20, s1_.area_actual_id AS area_actual_id_21, s1_.usuario_alta_id AS usuario_alta_id_22, s1_.cupo_id AS cupo_id_23, s1_.tipo_cupo_id AS tipo_cupo_id_24, s1_.usuario_rechazo_id AS usuario_rechazo_id_25 FROM notificacion n0_ LEFT JOIN solicitud s1_ ON n0_.solicitud_id = s1_.id WHERE n0_.usuario_id = ? AND n0_.leida = ? AND n0_.id > ? ORDER BY n0_.id ASC LIMIT 20
Parameters:
[
  133
  0
  94
]

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
App\Entity\Usuario No errors.
App\Entity\Rol No errors.
App\Entity\Area No errors.
App\Entity\Categoria No errors.
App\Entity\UsuarioContrato No errors.
App\Entity\Notificacion No errors.
App\Entity\Solicitud No errors.
App\Entity\SolicitudEstado No errors.
App\Entity\CupoTipo No errors.
App\Entity\Rendicion No errors.
App\Entity\MinDelegacion No errors.
App\Entity\SolicitudTipo No errors.
App\Entity\Cupo No errors.