Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 23
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Migrations 12
• Debug
• Emails
• Notifications
• VichUploader
• Configuration

Query Metrics

SELECT b.ORIGINAL_ID, b.DATOS, b.ESTADO_ORIGINAL
                FROM ADMCREDENCIAL.BACKUP_ASPIRANTE_AGUILA_GA b
                WHERE INSTR(UPPER(b.DATOS), ?) > 0
                AND ROWNUM = 1

[
  "JAEG000901MGRCSRB8"
]

SELECT
  b.ORIGINAL_ID,
  b.DATOS,
  b.ESTADO_ORIGINAL
FROM
  ADMCREDENCIAL.BACKUP_ASPIRANTE_AGUILA_GA b
WHERE
  INSTR(
    UPPER(b.DATOS),
    ?
  ) > 0
  AND ROWNUM = 1

SELECT b.ORIGINAL_ID, b.DATOS, b.ESTADO_ORIGINAL
                FROM ADMCREDENCIAL.BACKUP_ASPIRANTE_AGUILA_GA b
                WHERE INSTR(UPPER(b.DATOS), 'JAEG000901MGRCSRB8') > 0
                AND ROWNUM = 1;

SELECT s0_.id AS ID_0, s0_.UUID AS UUID_1, s0_.ASPIRANTE_ID AS ASPIRANTE_ID_2, s0_.CURP AS CURP_3, s0_.MATRICULA AS MATRICULA_4, s0_.NOMBRE_COMPLETO AS NOMBRE_COMPLETO_5, s0_.CORREO_ELECTRONICO AS CORREO_ELECTRONICO_6, s0_.TELEFONO AS TELEFONO_7, s0_.CVE_UA AS CVE_UA_8, s0_.CVE_PLAN AS CVE_PLAN_9, s0_.VRS_PLAN AS VRS_PLAN_10, s0_.NOMBRE_UA AS NOMBRE_UA_11, s0_.NOMBRE_PLAN AS NOMBRE_PLAN_12, s0_.TIPO AS TIPO_13, s0_.OP1 AS OP1_14, s0_.OP2 AS OP2_15, s0_.OP3 AS OP3_16, s0_.ESTADO AS ESTADO_17, s0_.MOTIVO_RECHAZO AS MOTIVO_RECHAZO_18, s0_.OBSERVACIONES AS OBSERVACIONES_19, s0_.FECHA_ASIGNACION_REVISOR AS FECHA_ASIGNACION_REVISOR_20, s0_.FECHA_SOLICITUD AS FECHA_SOLICITUD_21, s0_.FECHA_ACTUALIZACION AS FECHA_ACTUALIZACION_22, s0_.ACTIVO AS ACTIVO_23, s0_.CATEGORIA_COMPLETITUD AS CATEGORIA_COMPLETITUD_24, s0_.PORCENTAJE_APROBACION AS PORCENTAJE_APROBACION_25, s0_.USUARIO_ID AS USUARIO_ID_26, s0_.MODALIDAD_SELECCIONADA_ID AS MODALIDAD_SELECCIONADA_ID_27, s0_.REVISOR_ID AS REVISOR_ID_28, s0_.TRAMITE_ID AS TRAMITE_ID_29, s0_.TRAMITE_USUARIO_ID AS TRAMITE_USUARIO_ID_30, s0_.TITULACION_PIAT_ID AS TITULACION_PIAT_ID_31 FROM SOLICITUD_PONTE_AGUILA s0_ WHERE s0_.USUARIO_ID = ? AND s0_.ACTIVO = 1 ORDER BY s0_.FECHA_SOLICITUD DESC

[
  12623
]

SELECT
  s0_.id AS ID_0,
  s0_.UUID AS UUID_1,
  s0_.ASPIRANTE_ID AS ASPIRANTE_ID_2,
  s0_.CURP AS CURP_3,
  s0_.MATRICULA AS MATRICULA_4,
  s0_.NOMBRE_COMPLETO AS NOMBRE_COMPLETO_5,
  s0_.CORREO_ELECTRONICO AS CORREO_ELECTRONICO_6,
  s0_.TELEFONO AS TELEFONO_7,
  s0_.CVE_UA AS CVE_UA_8,
  s0_.CVE_PLAN AS CVE_PLAN_9,
  s0_.VRS_PLAN AS VRS_PLAN_10,
  s0_.NOMBRE_UA AS NOMBRE_UA_11,
  s0_.NOMBRE_PLAN AS NOMBRE_PLAN_12,
  s0_.TIPO AS TIPO_13,
  s0_.OP1 AS OP1_14,
  s0_.OP2 AS OP2_15,
  s0_.OP3 AS OP3_16,
  s0_.ESTADO AS ESTADO_17,
  s0_.MOTIVO_RECHAZO AS MOTIVO_RECHAZO_18,
  s0_.OBSERVACIONES AS OBSERVACIONES_19,
  s0_.FECHA_ASIGNACION_REVISOR AS FECHA_ASIGNACION_REVISOR_20,
  s0_.FECHA_SOLICITUD AS FECHA_SOLICITUD_21,
  s0_.FECHA_ACTUALIZACION AS FECHA_ACTUALIZACION_22,
  s0_.ACTIVO AS ACTIVO_23,
  s0_.CATEGORIA_COMPLETITUD AS CATEGORIA_COMPLETITUD_24,
  s0_.PORCENTAJE_APROBACION AS PORCENTAJE_APROBACION_25,
  s0_.USUARIO_ID AS USUARIO_ID_26,
  s0_.MODALIDAD_SELECCIONADA_ID AS MODALIDAD_SELECCIONADA_ID_27,
  s0_.REVISOR_ID AS REVISOR_ID_28,
  s0_.TRAMITE_ID AS TRAMITE_ID_29,
  s0_.TRAMITE_USUARIO_ID AS TRAMITE_USUARIO_ID_30,
  s0_.TITULACION_PIAT_ID AS TITULACION_PIAT_ID_31
FROM
  SOLICITUD_PONTE_AGUILA s0_
WHERE
  s0_.USUARIO_ID = ?
  AND s0_.ACTIVO = 1
ORDER BY
  s0_.FECHA_SOLICITUD DESC

SELECT s0_.id AS ID_0, s0_.UUID AS UUID_1, s0_.ASPIRANTE_ID AS ASPIRANTE_ID_2, s0_.CURP AS CURP_3, s0_.MATRICULA AS MATRICULA_4, s0_.NOMBRE_COMPLETO AS NOMBRE_COMPLETO_5, s0_.CORREO_ELECTRONICO AS CORREO_ELECTRONICO_6, s0_.TELEFONO AS TELEFONO_7, s0_.CVE_UA AS CVE_UA_8, s0_.CVE_PLAN AS CVE_PLAN_9, s0_.VRS_PLAN AS VRS_PLAN_10, s0_.NOMBRE_UA AS NOMBRE_UA_11, s0_.NOMBRE_PLAN AS NOMBRE_PLAN_12, s0_.TIPO AS TIPO_13, s0_.OP1 AS OP1_14, s0_.OP2 AS OP2_15, s0_.OP3 AS OP3_16, s0_.ESTADO AS ESTADO_17, s0_.MOTIVO_RECHAZO AS MOTIVO_RECHAZO_18, s0_.OBSERVACIONES AS OBSERVACIONES_19, s0_.FECHA_ASIGNACION_REVISOR AS FECHA_ASIGNACION_REVISOR_20, s0_.FECHA_SOLICITUD AS FECHA_SOLICITUD_21, s0_.FECHA_ACTUALIZACION AS FECHA_ACTUALIZACION_22, s0_.ACTIVO AS ACTIVO_23, s0_.CATEGORIA_COMPLETITUD AS CATEGORIA_COMPLETITUD_24, s0_.PORCENTAJE_APROBACION AS PORCENTAJE_APROBACION_25, s0_.USUARIO_ID AS USUARIO_ID_26, s0_.MODALIDAD_SELECCIONADA_ID AS MODALIDAD_SELECCIONADA_ID_27, s0_.REVISOR_ID AS REVISOR_ID_28, s0_.TRAMITE_ID AS TRAMITE_ID_29, s0_.TRAMITE_USUARIO_ID AS TRAMITE_USUARIO_ID_30, s0_.TITULACION_PIAT_ID AS TITULACION_PIAT_ID_31 FROM SOLICITUD_PONTE_AGUILA s0_ WHERE s0_.USUARIO_ID = 12623 AND s0_.ACTIVO = 1 ORDER BY s0_.FECHA_SOLICITUD DESC;

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 = '.,'

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.llave_mx_id AS LLAVE_MX_ID_13, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_14, t0.matricula AS MATRICULA_15, t0.curp AS CURP_16, t0.numero_empleado AS NUMERO_EMPLEADO_17 FROM "user" t0 WHERE t0.id = ?

[
  12623
]

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.llave_mx_id AS LLAVE_MX_ID_13,
  t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_14,
  t0.matricula AS MATRICULA_15,
  t0.curp AS CURP_16,
  t0.numero_empleado AS NUMERO_EMPLEADO_17
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.llave_mx_id AS LLAVE_MX_ID_13, t0.UNIDAD_RESPONSABLE_ID AS UNIDAD_RESPONSABLE_ID_14, t0.matricula AS MATRICULA_15, t0.curp AS CURP_16, t0.numero_empleado AS NUMERO_EMPLEADO_17 FROM "user" t0 WHERE t0.id = 12623;

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 = ?

[
  12623
]

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

SELECT b.ORIGINAL_ID, b.DATOS, b.ESTADO_ORIGINAL
                FROM ADMCREDENCIAL.BACKUP_ASPIRATE_PONTE_AGUILA b
                WHERE INSTR(UPPER(b.DATOS), ?) > 0
                AND ROWNUM = 1

[
  "JAEG000901MGRCSRB8"
]

SELECT
  b.ORIGINAL_ID,
  b.DATOS,
  b.ESTADO_ORIGINAL
FROM
  ADMCREDENCIAL.BACKUP_ASPIRATE_PONTE_AGUILA b
WHERE
  INSTR(
    UPPER(b.DATOS),
    ?
  ) > 0
  AND ROWNUM = 1

SELECT b.ORIGINAL_ID, b.DATOS, b.ESTADO_ORIGINAL
                FROM ADMCREDENCIAL.BACKUP_ASPIRATE_PONTE_AGUILA b
                WHERE INSTR(UPPER(b.DATOS), 'JAEG000901MGRCSRB8') > 0
                AND ROWNUM = 1;