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 = 8534;

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 = 8534;

SELECT
  a.*
FROM
  (
    SELECT
      t0.CVEENTALU AS CVEENTALU_1,
      t0.NOMENTALU AS NOMENTALU_2,
      t0.APEENTALU AS APEENTALU_3,
      t0.CRPENTALU AS CRPENTALU_4,
      t0.MAILENTALU AS MAILENTALU_5,
      t0.TELENTALU AS TELENTALU_6
    FROM
      ADMCONESC.TABENTALU t0
    WHERE
      t0.CVEENTALU = ?
  ) a
WHERE
  ROWNUM <= 1

SELECT a.* FROM (SELECT t0.CVEENTALU AS CVEENTALU_1, t0.NOMENTALU AS NOMENTALU_2, t0.APEENTALU AS APEENTALU_3, t0.CRPENTALU AS CRPENTALU_4, t0.MAILENTALU AS MAILENTALU_5, t0.TELENTALU AS TELENTALU_6 FROM ADMCONESC.TABENTALU t0 WHERE t0.CVEENTALU = '17395786') a WHERE ROWNUM <= 1;

SELECT
  t0.CVEENTALU AS CVEENTALU_1,
  t0.NOMENTALU AS NOMENTALU_2,
  t0.APEENTALU AS APEENTALU_3,
  t0.CRPENTALU AS CRPENTALU_4,
  t0.MAILENTALU AS MAILENTALU_5,
  t0.TELENTALU AS TELENTALU_6
FROM
  ADMCONESC.TABENTALU t0
WHERE
  t0.CRPENTALU = ?

SELECT t0.CVEENTALU AS CVEENTALU_1, t0.NOMENTALU AS NOMENTALU_2, t0.APEENTALU AS APEENTALU_3, t0.CRPENTALU AS CRPENTALU_4, t0.MAILENTALU AS MAILENTALU_5, t0.TELENTALU AS TELENTALU_6 FROM ADMCONESC.TABENTALU t0 WHERE t0.CRPENTALU = 'HEAG990402MGRRVD08';

SELECT
  r0_.CVEENTALU AS CVEENTALU_0,
  r0_.CVEENTESC AS CVEENTESC_1,
  r0_.CVEPLNEST AS CVEPLNEST_2,
  r0_.VRSPLNEST AS VRSPLNEST_3,
  r0_.CVEBCHALU AS CVEBCHALU_4,
  r0_.PERINIPLN AS PERINIPLN_5,
  r0_.STAPLNEST AS STAPLNEST_6,
  r0_.CVEENTALU AS CVEENTALU_7,
  r0_.CVEPLNEST AS CVEPLNEST_8,
  r0_.VRSPLNEST AS VRSPLNEST_9,
  r0_.CVEENTESC AS CVEENTESC_10
FROM
  ADMCONESC.RELALUPLN r0_
  INNER JOIN ADMCONESC.TABENTESC t1_ ON r0_.CVEENTESC = t1_.CVEENTESC
  INNER JOIN ADMCONESC.RELCNFPLN r2_ ON r0_.CVEPLNEST = r2_.CVEPLNEST
  AND r0_.VRSPLNEST = r2_.VRSPLNEST
WHERE
  r0_.CVEENTALU IN (?)
  AND t1_.CVETPOINS IN (1, 2)
ORDER BY
  t1_.NOMETIQ ASC,
  r2_.NOMPLNETIQ ASC

SELECT r0_.CVEENTALU AS CVEENTALU_0, r0_.CVEENTESC AS CVEENTESC_1, r0_.CVEPLNEST AS CVEPLNEST_2, r0_.VRSPLNEST AS VRSPLNEST_3, r0_.CVEBCHALU AS CVEBCHALU_4, r0_.PERINIPLN AS PERINIPLN_5, r0_.STAPLNEST AS STAPLNEST_6, r0_.CVEENTALU AS CVEENTALU_7, r0_.CVEPLNEST AS CVEPLNEST_8, r0_.VRSPLNEST AS VRSPLNEST_9, r0_.CVEENTESC AS CVEENTESC_10 FROM ADMCONESC.RELALUPLN r0_ INNER JOIN ADMCONESC.TABENTESC t1_ ON r0_.CVEENTESC = t1_.CVEENTESC INNER JOIN ADMCONESC.RELCNFPLN r2_ ON r0_.CVEPLNEST = r2_.CVEPLNEST AND r0_.VRSPLNEST = r2_.VRSPLNEST WHERE r0_.CVEENTALU IN ('17395786') AND t1_.CVETPOINS IN (1, 2) ORDER BY t1_.NOMETIQ ASC, r2_.NOMPLNETIQ ASC;

SELECT
  t0_.id AS ID_0,
  t0_.nombre AS NOMBRE_1,
  t0_.descripcion AS DESCRIPCION_2,
  t0_.nombre_corto AS NOMBRE_CORTO_3,
  t0_.tiempo_respuesta AS TIEMPO_RESPUESTA_4,
  t0_.publicado AS PUBLICADO_5,
  t0_.requiere_firma_electronica AS REQUIERE_FIRMA_ELECTRONICA_6,
  t0_.tipo_tramite AS TIPO_TRAMITE_7,
  t0_.GENERA_OFICIO_RESPUESTA AS GENERA_OFICIO_RESPUESTA_8,
  t0_.PLANTILLA_OFICIO AS PLANTILLA_OFICIO_9,
  t0_.CAMPOS_ADICIONALES AS CAMPOS_ADICIONALES_10,
  t0_.TEXTO_PLANTILLA_OFICIO AS TEXTO_PLANTILLA_OFICIO_11,
  t0_.PREFIJO_FOLIO AS PREFIJO_FOLIO_12,
  t0_.nivel_aplica_id AS NIVEL_APLICA_ID_13
FROM
  tramite t0_
WHERE
  t0_.id IN (?)

SELECT t0_.id AS ID_0, t0_.nombre AS NOMBRE_1, t0_.descripcion AS DESCRIPCION_2, t0_.nombre_corto AS NOMBRE_CORTO_3, t0_.tiempo_respuesta AS TIEMPO_RESPUESTA_4, t0_.publicado AS PUBLICADO_5, t0_.requiere_firma_electronica AS REQUIERE_FIRMA_ELECTRONICA_6, t0_.tipo_tramite AS TIPO_TRAMITE_7, t0_.GENERA_OFICIO_RESPUESTA AS GENERA_OFICIO_RESPUESTA_8, t0_.PLANTILLA_OFICIO AS PLANTILLA_OFICIO_9, t0_.CAMPOS_ADICIONALES AS CAMPOS_ADICIONALES_10, t0_.TEXTO_PLANTILLA_OFICIO AS TEXTO_PLANTILLA_OFICIO_11, t0_.PREFIJO_FOLIO AS PREFIJO_FOLIO_12, t0_.nivel_aplica_id AS NIVEL_APLICA_ID_13 FROM tramite t0_ WHERE t0_.id IN ('81');

SELECT
  a.*
FROM
  (
    SELECT
      t0.CVEENTALU AS CVEENTALU_1,
      t0.CVEENTESC AS CVEENTESC_2,
      t0.CVEPLNEST AS CVEPLNEST_3,
      t0.VRSPLNEST AS VRSPLNEST_4,
      t0.CVEBCHALU AS CVEBCHALU_5,
      t0.PERINIPLN AS PERINIPLN_6,
      t0.STAPLNEST AS STAPLNEST_7,
      t0.CVEENTALU AS CVEENTALU_8,
      t0.CVEPLNEST AS CVEPLNEST_9,
      t0.VRSPLNEST AS VRSPLNEST_10,
      t0.CVEENTESC AS CVEENTESC_11
    FROM
      ADMCONESC.RELALUPLN t0
    WHERE
      t0.CVEENTALU = ?
      AND t0.CVEENTESC = ?
      AND t0.CVEPLNEST = ?
      AND t0.VRSPLNEST = ?
  ) a
WHERE
  ROWNUM <= 1

SELECT a.* FROM (SELECT t0.CVEENTALU AS CVEENTALU_1, t0.CVEENTESC AS CVEENTESC_2, t0.CVEPLNEST AS CVEPLNEST_3, t0.VRSPLNEST AS VRSPLNEST_4, t0.CVEBCHALU AS CVEBCHALU_5, t0.PERINIPLN AS PERINIPLN_6, t0.STAPLNEST AS STAPLNEST_7, t0.CVEENTALU AS CVEENTALU_8, t0.CVEPLNEST AS CVEPLNEST_9, t0.VRSPLNEST AS VRSPLNEST_10, t0.CVEENTESC AS CVEENTESC_11 FROM ADMCONESC.RELALUPLN t0 WHERE t0.CVEENTALU = '17395786' AND t0.CVEENTESC = '10136' AND t0.CVEPLNEST = '010117' AND t0.VRSPLNEST = '6') a WHERE ROWNUM <= 1;

SELECT
  t0.id AS ID_1,
  t0.nombre AS NOMBRE_2,
  t0.clave AS CLAVE_3,
  t0.activo AS ACTIVO_4
FROM
  nivel_aplica t0
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.nombre AS NOMBRE_2, t0.clave AS CLAVE_3, t0.activo AS ACTIVO_4 FROM nivel_aplica t0 WHERE t0.id = 3;

SELECT
  t0.CVEPLNEST AS CVEPLNEST_1,
  t0.VRSPLNEST AS VRSPLNEST_2,
  t0.ANOPLNVRS AS ANOPLNVRS_3,
  t0.NOMPLNEST AS NOMPLNEST_4,
  t0.MINCUR AS MINCUR_5,
  t0.NIVEDUPLN AS NIVEDUPLN_6,
  t0.FLEXIBLE AS FLEXIBLE_7,
  t0.NOMPLNETIQ AS NOMPLNETIQ_8,
  t0.NOMPLNCERTIF AS NOMPLNCERTIF_9,
  t0.NOMCARTIT AS NOMCARTIT_10,
  t0.NOMCARTITMUJ AS NOMCARTITMUJ_11
FROM
  ADMCONESC.RELCNFPLN t0
WHERE
  t0.CVEPLNEST = ?
  AND t0.VRSPLNEST = ?

SELECT t0.CVEPLNEST AS CVEPLNEST_1, t0.VRSPLNEST AS VRSPLNEST_2, t0.ANOPLNVRS AS ANOPLNVRS_3, t0.NOMPLNEST AS NOMPLNEST_4, t0.MINCUR AS MINCUR_5, t0.NIVEDUPLN AS NIVEDUPLN_6, t0.FLEXIBLE AS FLEXIBLE_7, t0.NOMPLNETIQ AS NOMPLNETIQ_8, t0.NOMPLNCERTIF AS NOMPLNCERTIF_9, t0.NOMCARTIT AS NOMCARTIT_10, t0.NOMCARTITMUJ AS NOMCARTITMUJ_11 FROM ADMCONESC.RELCNFPLN t0 WHERE t0.CVEPLNEST = '010117' AND t0.VRSPLNEST = '6';

SELECT
  a.*
FROM
  (
    SELECT
      t0.id AS ID_1,
      t0.fecha_inicio AS FECHA_INICIO_2,
      t0.uuid AS UUID_3,
      t0.visto AS VISTO_4,
      t0.motivo_regreso_tramite AS MOTIVO_REGRESO_TRAMITE_5,
      t0.activo AS ACTIVO_6,
      t0.TITULO_AREA AS TITULO_AREA_7,
      t0.PERIODO_ESTUDIOS AS PERIODO_ESTUDIOS_8,
      t0.PROMEDIO_GENERAL AS PROMEDIO_GENERAL_9,
      t0.SELLO_DIGITAL AS SELLO_DIGITAL_10,
      t0.DATOS_ADICIONALES AS DATOS_ADICIONALES_11,
      t0.NUMERO_OFICIO AS NUMERO_OFICIO_12,
      t0.FECHA_OFICIO AS FECHA_OFICIO_13,
      t0.FECHA_LIMITE_DOCUMENTOS AS FECHA_LIMITE_DOCUMENTOS_14,
      t0.DOCUMENTOS_COMPLETOS AS DOCUMENTOS_COMPLETOS_15,
      t0.FECHA_DOCUMENTOS_COMPLETOS AS FECHA_DOCUMENTOS_COMPLETOS_16,
      t0.CANCELADO_POR_VENCIMIENTO AS CANCELADO_POR_VENCIMIENTO_17,
      t0.TELEFONO_CONTACTO AS TELEFONO_CONTACTO_18,
      t0.CADENA_ORIGINAL_FIRMA AS CADENA_ORIGINAL_FIRMA_19,
      t0.SELLO_DIGITAL_FIRMA AS SELLO_DIGITAL_FIRMA_20,
      t0.FECHA_FIRMA AS FECHA_FIRMA_21,
      t0.NUM_SERIE_CERTIFICADO AS NUM_SERIE_CERTIFICADO_22,
      t0.CARGO_JEFE_ASIGNADO AS CARGO_JEFE_ASIGNADO_23,
      t0.FECHA_ASIGNACION_REVISOR AS FECHA_ASIGNACION_REVISOR_24,
      t0.USUARIO_ID AS USUARIO_ID_25,
      t0.tramite_id AS TRAMITE_ID_26,
      t0.estado_atencion_id AS ESTADO_ATENCION_ID_27,
      t0.CVEENTALU AS CVEENTALU_28,
      t0.ESCUELA_ID AS ESCUELA_ID_29,
      t0.CVEPLNEST AS CVEPLNEST_30,
      t0.VRSPLNEST AS VRSPLNEST_31,
      t0.FIRMADO_POR_ID AS FIRMADO_POR_ID_32,
      t0.JEFE_ASIGNADO_ID AS JEFE_ASIGNADO_ID_33,
      t0.REVISOR_ASIGNADO_ID AS REVISOR_ASIGNADO_ID_34
    FROM
      TRAMITE_USUARIO t0
    WHERE
      t0.USUARIO_ID = ?
      AND t0.tramite_id = ?
  ) a
WHERE
  ROWNUM <= 1

SELECT a.* FROM (SELECT t0.id AS ID_1, t0.fecha_inicio AS FECHA_INICIO_2, t0.uuid AS UUID_3, t0.visto AS VISTO_4, t0.motivo_regreso_tramite AS MOTIVO_REGRESO_TRAMITE_5, t0.activo AS ACTIVO_6, t0.TITULO_AREA AS TITULO_AREA_7, t0.PERIODO_ESTUDIOS AS PERIODO_ESTUDIOS_8, t0.PROMEDIO_GENERAL AS PROMEDIO_GENERAL_9, t0.SELLO_DIGITAL AS SELLO_DIGITAL_10, t0.DATOS_ADICIONALES AS DATOS_ADICIONALES_11, t0.NUMERO_OFICIO AS NUMERO_OFICIO_12, t0.FECHA_OFICIO AS FECHA_OFICIO_13, t0.FECHA_LIMITE_DOCUMENTOS AS FECHA_LIMITE_DOCUMENTOS_14, t0.DOCUMENTOS_COMPLETOS AS DOCUMENTOS_COMPLETOS_15, t0.FECHA_DOCUMENTOS_COMPLETOS AS FECHA_DOCUMENTOS_COMPLETOS_16, t0.CANCELADO_POR_VENCIMIENTO AS CANCELADO_POR_VENCIMIENTO_17, t0.TELEFONO_CONTACTO AS TELEFONO_CONTACTO_18, t0.CADENA_ORIGINAL_FIRMA AS CADENA_ORIGINAL_FIRMA_19, t0.SELLO_DIGITAL_FIRMA AS SELLO_DIGITAL_FIRMA_20, t0.FECHA_FIRMA AS FECHA_FIRMA_21, t0.NUM_SERIE_CERTIFICADO AS NUM_SERIE_CERTIFICADO_22, t0.CARGO_JEFE_ASIGNADO AS CARGO_JEFE_ASIGNADO_23, t0.FECHA_ASIGNACION_REVISOR AS FECHA_ASIGNACION_REVISOR_24, t0.USUARIO_ID AS USUARIO_ID_25, t0.tramite_id AS TRAMITE_ID_26, t0.estado_atencion_id AS ESTADO_ATENCION_ID_27, t0.CVEENTALU AS CVEENTALU_28, t0.ESCUELA_ID AS ESCUELA_ID_29, t0.CVEPLNEST AS CVEPLNEST_30, t0.VRSPLNEST AS VRSPLNEST_31, t0.FIRMADO_POR_ID AS FIRMADO_POR_ID_32, t0.JEFE_ASIGNADO_ID AS JEFE_ASIGNADO_ID_33, t0.REVISOR_ASIGNADO_ID AS REVISOR_ASIGNADO_ID_34 FROM TRAMITE_USUARIO t0 WHERE t0.USUARIO_ID = 8534 AND t0.tramite_id = 81) a WHERE ROWNUM <= 1;

SELECT
  a.*
FROM
  (
    SELECT
      t0.id AS ID_1,
      t0.periodo AS PERIODO_2,
      t0.limite AS LIMITE_3,
      t0.activo AS ACTIVO_4,
      t0.dia_semana AS DIA_SEMANA_5,
      t0.hora_inicio AS HORA_INICIO_6,
      t0.hora_fin AS HORA_FIN_7,
      t0.tramite_id AS TRAMITE_ID_8
    FROM
      tramite_cupo t0
    WHERE
      t0.tramite_id = ?
      AND t0.activo = ?
  ) a
WHERE
  ROWNUM <= 1

SELECT a.* FROM (SELECT t0.id AS ID_1, t0.periodo AS PERIODO_2, t0.limite AS LIMITE_3, t0.activo AS ACTIVO_4, t0.dia_semana AS DIA_SEMANA_5, t0.hora_inicio AS HORA_INICIO_6, t0.hora_fin AS HORA_FIN_7, t0.tramite_id AS TRAMITE_ID_8 FROM tramite_cupo t0 WHERE t0.tramite_id = 81 AND t0.activo = 1) a WHERE ROWNUM <= 1;