Symfony Profiler

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';

SELECT
  t0.id AS ID_1,
  t0.email AS EMAIL_2,
  t0.nombre AS NOMBRE_3,
  t0.apellidos AS APELLIDOS_4,
  t0.telefono AS TELEFONO_5,
  t0.permisos AS PERMISOS_6,
  t0.fecha_creacion AS FECHA_CREACION_7,
  t0.usuario_creo AS USUARIO_CREO_8,
  t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9,
  t0.usuario_actualizo AS USUARIO_ACTUALIZO_10,
  t0.ultima_conexion AS ULTIMA_CONEXION_11,
  t0.google_id AS GOOGLE_ID_12,
  t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13,
  t0.matricula AS MATRICULA_14,
  t0.numero_empleado AS NUMERO_EMPLEADO_15
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.nombre AS NOMBRE_3, t0.apellidos AS APELLIDOS_4, t0.telefono AS TELEFONO_5, t0.permisos AS PERMISOS_6, t0.fecha_creacion AS FECHA_CREACION_7, t0.usuario_creo AS USUARIO_CREO_8, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_9, t0.usuario_actualizo AS USUARIO_ACTUALIZO_10, t0.ultima_conexion AS ULTIMA_CONEXION_11, t0.google_id AS GOOGLE_ID_12, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_13, t0.matricula AS MATRICULA_14, t0.numero_empleado AS NUMERO_EMPLEADO_15 FROM "user" t0 WHERE t0.id = 450;

SELECT
  t0.id AS ID_1,
  t0.nombre AS NOMBRE_2,
  t0.descripcion AS DESCRIPCION_3,
  t0.roles AS ROLES_4
FROM
  grupo t0
  INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id
WHERE
  user_grupo.user_id = ?

SELECT t0.id AS ID_1, t0.nombre AS NOMBRE_2, t0.descripcion AS DESCRIPCION_3, t0.roles AS ROLES_4 FROM grupo t0 INNER JOIN user_grupo ON t0.id = user_grupo.grupo_id WHERE user_grupo.user_id = 450;

SELECT
  u0_.cveentesc AS SCLR_0
FROM
  usuario_escuela_plan u0_
WHERE
  u0_.user_id = ?

SELECT u0_.cveentesc AS SCLR_0 FROM usuario_escuela_plan u0_ WHERE u0_.user_id = 450;

SELECT
  *
FROM
  (
    SELECT
      ID,
      IDTRAMITE,
      NOMBRETRAMITE,
      IDUSUARIO,
      MATRICULA,
      NOMBRECOMPLETO,
      REVISADO,
      ESTADOTRAMITE,
      ESCUELA_ID,
      NOMETIQ,
      NOMPLNETIQ,
      ZONA,
      REVISOR_ID,
      REVISOR,
      FECHA_ASIGNACION,
      ROW_NUMBER() OVER (
        partition by
          1
        order by
          1
      ) as rnum
    FROM
      ADMCREDENCIAL.VW_REVISOR_TRAMITE
    WHERE
      ESCUELA_ID IN (
        010119, 10599, 10542, 10507, 10553,
        010233
      )
      AND REVISOR_ID = 450
      AND ESTADOTRAMITE = 'SOLICITUD'
    ORDER BY
      ID DESC
  )
WHERE
  rnum <= 10
  and rnum > 0

SELECT * FROM (
                                SELECT ID, IDTRAMITE, NOMBRETRAMITE, IDUSUARIO, MATRICULA, NOMBRECOMPLETO, REVISADO, ESTADOTRAMITE, ESCUELA_ID, NOMETIQ, NOMPLNETIQ, ZONA, REVISOR_ID, REVISOR, FECHA_ASIGNACION,
                                ROW_NUMBER() OVER (partition by 1 order by 1) as rnum
                               FROM ADMCREDENCIAL.VW_REVISOR_TRAMITE  WHERE  ESCUELA_ID IN (010119,10599,10542,10507,10553,010233) AND REVISOR_ID =450 AND ESTADOTRAMITE = 'SOLICITUD'  ORDER BY ID DESC
                            ) WHERE rnum <= 10 
                              and rnum > 0;

SELECT
  COUNT(ID)
FROM
  ADMCREDENCIAL.VW_REVISOR_TRAMITE
WHERE
  ESCUELA_ID IN (
    010119, 10599, 10542, 10507, 10553,
    010233
  )
  AND REVISOR_ID = 450
  AND ESTADOTRAMITE = 'SOLICITUD'

SELECT COUNT(ID) FROM   ADMCREDENCIAL.VW_REVISOR_TRAMITE  WHERE  ESCUELA_ID IN (010119,10599,10542,10507,10553,010233) AND REVISOR_ID =450 AND ESTADOTRAMITE = 'SOLICITUD';

SELECT
  COUNT(ID)
FROM
  ADMCREDENCIAL.VW_REVISOR_TRAMITE
WHERE
  ESCUELA_ID IN (
    010119, 10599, 10542, 10507, 10553,
    010233
  )
  AND REVISOR_ID = 450
  AND ESTADOTRAMITE = 'SOLICITUD'

SELECT COUNT(ID) FROM   ADMCREDENCIAL.VW_REVISOR_TRAMITE  WHERE  ESCUELA_ID IN (010119,10599,10542,10507,10553,010233) AND REVISOR_ID =450 AND ESTADOTRAMITE = 'SOLICITUD';

SELECT
  d.ID,
  d.nombre,
  NVL(r.OBLIGATORIO, 1) as OBLIGATORIO,
  r.POSICION,
  r.CONDICION
FROM
  requisito r,
  documento d
WHERE
  r.DOCUMENTO_ID = d.ID
  AND r.activo = 1
  AND r.TRAMITE_ID = :tipoTramiteId
  AND NVL(r.OBLIGATORIO, 1) = 1
ORDER BY
  NVL(r.POSICION, 9999),
  d.nombre

SELECT d.ID, d.nombre, NVL(r.OBLIGATORIO, 1) as OBLIGATORIO, r.POSICION, r.CONDICION
                FROM requisito r, documento d
                WHERE r.DOCUMENTO_ID = d.ID AND r.activo = 1
                AND r.TRAMITE_ID = 41 AND NVL(r.OBLIGATORIO, 1) = 1 ORDER BY NVL(r.POSICION, 9999), d.nombre;

SELECT
  d.ID,
  d.nombre,
  NVL(r.OBLIGATORIO, 1) as OBLIGATORIO,
  r.POSICION,
  r.CONDICION
FROM
  requisito r,
  documento d
WHERE
  r.DOCUMENTO_ID = d.ID
  AND r.activo = 1
  AND r.TRAMITE_ID = :tipoTramiteId
  AND NVL(r.OBLIGATORIO, 1) = 1
ORDER BY
  NVL(r.POSICION, 9999),
  d.nombre

SELECT d.ID, d.nombre, NVL(r.OBLIGATORIO, 1) as OBLIGATORIO, r.POSICION, r.CONDICION
                FROM requisito r, documento d
                WHERE r.DOCUMENTO_ID = d.ID AND r.activo = 1
                AND r.TRAMITE_ID = 41 AND NVL(r.OBLIGATORIO, 1) = 1 ORDER BY NVL(r.POSICION, 9999), d.nombre;

SELECT
  d.ID,
  d.nombre,
  NVL(r.OBLIGATORIO, 1) as OBLIGATORIO,
  r.POSICION,
  r.CONDICION
FROM
  requisito r,
  documento d
WHERE
  r.DOCUMENTO_ID = d.ID
  AND r.activo = 1
  AND r.TRAMITE_ID = :tipoTramiteId
  AND NVL(r.OBLIGATORIO, 1) = 1
ORDER BY
  NVL(r.POSICION, 9999),
  d.nombre

SELECT d.ID, d.nombre, NVL(r.OBLIGATORIO, 1) as OBLIGATORIO, r.POSICION, r.CONDICION
                FROM requisito r, documento d
                WHERE r.DOCUMENTO_ID = d.ID AND r.activo = 1
                AND r.TRAMITE_ID = 42 AND NVL(r.OBLIGATORIO, 1) = 1 ORDER BY NVL(r.POSICION, 9999), d.nombre;

ALTER SESSION
SET
  NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,'

ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,';

SELECT
  eu.DOCUMENTO_ID,
  eu.ESTADO,
  eu.REEMPLAZO_RECHAZADO
FROM
  ADMCREDENCIAL.EXPEDIENTE_USUARIO eu
WHERE
  eu.USUARIO_ID = :usuarioId

SELECT eu.DOCUMENTO_ID, eu.ESTADO, eu.REEMPLAZO_RECHAZADO  
                    FROM ADMCREDENCIAL.EXPEDIENTE_USUARIO eu
                    WHERE eu.USUARIO_ID = 6191;

SELECT
  eu.DOCUMENTO_ID,
  eu.ESTADO,
  eu.REEMPLAZO_RECHAZADO
FROM
  ADMCREDENCIAL.EXPEDIENTE_USUARIO eu
WHERE
  eu.USUARIO_ID = :usuarioId

SELECT eu.DOCUMENTO_ID, eu.ESTADO, eu.REEMPLAZO_RECHAZADO  
                    FROM ADMCREDENCIAL.EXPEDIENTE_USUARIO eu
                    WHERE eu.USUARIO_ID = 7158;

SELECT
  eu.DOCUMENTO_ID,
  eu.ESTADO,
  eu.REEMPLAZO_RECHAZADO
FROM
  ADMCREDENCIAL.EXPEDIENTE_USUARIO eu
WHERE
  eu.USUARIO_ID = :usuarioId

SELECT eu.DOCUMENTO_ID, eu.ESTADO, eu.REEMPLAZO_RECHAZADO  
                    FROM ADMCREDENCIAL.EXPEDIENTE_USUARIO eu
                    WHERE eu.USUARIO_ID = 7377;