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.roles AS ROLES_3,
  t0.password AS PASSWORD_4,
  t0.nombre AS NOMBRE_5,
  t0.apellidos AS APELLIDOS_6,
  t0.photography AS PHOTOGRAPHY_7,
  t0.activo AS ACTIVO_8,
  t0.fecha_creacion AS FECHA_CREACION_9,
  t0.fecha_actualizacion AS FECHA_ACTUALIZACION_10,
  t11.id AS ID_12,
  t11.plan_ofertado_id AS PLAN_OFERTADO_ID_13,
  t11.plan_ofertado_clave_ua AS PLAN_OFERTADO_CLAVE_UA_14,
  t11.plan_ofertado_zona_escolar AS PLAN_OFERTADO_ZONA_ESCOLAR_15,
  t11.tipo_usuario AS TIPO_USUARIO_16,
  t11.usuario_id AS USUARIO_ID_17
FROM
  "user" t0
  LEFT JOIN user_plan_ofertado_asp t11 ON t11.usuario_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS ID_1, t0.email AS EMAIL_2, t0.roles AS ROLES_3, t0.password AS PASSWORD_4, t0.nombre AS NOMBRE_5, t0.apellidos AS APELLIDOS_6, t0.photography AS PHOTOGRAPHY_7, t0.activo AS ACTIVO_8, t0.fecha_creacion AS FECHA_CREACION_9, t0.fecha_actualizacion AS FECHA_ACTUALIZACION_10, t11.id AS ID_12, t11.plan_ofertado_id AS PLAN_OFERTADO_ID_13, t11.plan_ofertado_clave_ua AS PLAN_OFERTADO_CLAVE_UA_14, t11.plan_ofertado_zona_escolar AS PLAN_OFERTADO_ZONA_ESCOLAR_15, t11.tipo_usuario AS TIPO_USUARIO_16, t11.usuario_id AS USUARIO_ID_17 FROM "user" t0 LEFT JOIN user_plan_ofertado_asp t11 ON t11.usuario_id = t0.id WHERE t0.id = 62;

SELECT
  *
FROM
  (
    SELECT
      ID,
      ESTADO,
      CURP,
      NOMBRE,
      UA,
      PLANESTUDIOS,
      CLAVE_UNICA_REGISTRO,
      FOLIO_CENEVAL,
      ZONA_ESCOLAR,
      CLAVE_UNIDAD_ACADEMICA,
      CLAVE_PLAN_ESTUDIOS,
      VERSION_PLAN_ESTUDIOS,
      STATUS,
      CORREO_ELECTRONICO,
      TELEFONO_CELULAR,
      row_number() over (
        partition by
          1
        order by
          1
      ) as rnum
    from
      VW_ASPIRANTE
    WHERE
      (
        ID LIKE :binding_0
        OR ESTADO LIKE :binding_1
        OR CURP LIKE :binding_2
        OR NOMBRE LIKE :binding_3
        OR UA LIKE :binding_4
        OR PLANESTUDIOS LIKE :binding_5
        OR CLAVE_UNICA_REGISTRO LIKE :binding_6
        OR FOLIO_CENEVAL LIKE :binding_7
        OR ZONA_ESCOLAR LIKE :binding_8
        OR CLAVE_UNIDAD_ACADEMICA LIKE :binding_9
        OR CLAVE_PLAN_ESTUDIOS LIKE :binding_10
        OR VERSION_PLAN_ESTUDIOS LIKE :binding_11
        OR STATUS LIKE :binding_12
        OR CORREO_ELECTRONICO LIKE :binding_13
        OR TELEFONO_CELULAR LIKE :binding_14
        OR ID LIKE :binding_15
      )
    ORDER BY
      ID ASC
  )
where
  rnum <= 10
  and rnum > 0

SELECT * FROM (
                                SELECT ID, ESTADO, CURP, NOMBRE, UA, PLANESTUDIOS, CLAVE_UNICA_REGISTRO, FOLIO_CENEVAL, ZONA_ESCOLAR, CLAVE_UNIDAD_ACADEMICA, CLAVE_PLAN_ESTUDIOS, VERSION_PLAN_ESTUDIOS, STATUS, CORREO_ELECTRONICO, TELEFONO_CELULAR,
                                row_number() over (partition by 1 order by 1) as rnum
                               from VW_ASPIRANTE WHERE ( ID LIKE :binding_0 OR  ESTADO LIKE :binding_1 OR  CURP LIKE :binding_2 OR  NOMBRE LIKE :binding_3 OR  UA LIKE :binding_4 OR  PLANESTUDIOS LIKE :binding_5 OR  CLAVE_UNICA_REGISTRO LIKE :binding_6 OR  FOLIO_CENEVAL LIKE :binding_7 OR  ZONA_ESCOLAR LIKE :binding_8 OR  CLAVE_UNIDAD_ACADEMICA LIKE :binding_9 OR  CLAVE_PLAN_ESTUDIOS LIKE :binding_10 OR  VERSION_PLAN_ESTUDIOS LIKE :binding_11 OR  STATUS LIKE :binding_12 OR  CORREO_ELECTRONICO LIKE :binding_13 OR  TELEFONO_CELULAR LIKE :binding_14 OR  ID LIKE :binding_15)  ORDER BY ID ASC
                            ) where rnum <= 10 
                              and rnum > 0;

SELECT
  COUNT(ID)
FROM
  VW_ASPIRANTE
WHERE
  (
    ID LIKE :binding_0
    OR ESTADO LIKE :binding_1
    OR CURP LIKE :binding_2
    OR NOMBRE LIKE :binding_3
    OR UA LIKE :binding_4
    OR PLANESTUDIOS LIKE :binding_5
    OR CLAVE_UNICA_REGISTRO LIKE :binding_6
    OR FOLIO_CENEVAL LIKE :binding_7
    OR ZONA_ESCOLAR LIKE :binding_8
    OR CLAVE_UNIDAD_ACADEMICA LIKE :binding_9
    OR CLAVE_PLAN_ESTUDIOS LIKE :binding_10
    OR VERSION_PLAN_ESTUDIOS LIKE :binding_11
    OR STATUS LIKE :binding_12
    OR CORREO_ELECTRONICO LIKE :binding_13
    OR TELEFONO_CELULAR LIKE :binding_14
    OR ID LIKE :binding_15
  )

SELECT COUNT(ID) FROM   VW_ASPIRANTE WHERE ( ID LIKE :binding_0 OR  ESTADO LIKE :binding_1 OR  CURP LIKE :binding_2 OR  NOMBRE LIKE :binding_3 OR  UA LIKE :binding_4 OR  PLANESTUDIOS LIKE :binding_5 OR  CLAVE_UNICA_REGISTRO LIKE :binding_6 OR  FOLIO_CENEVAL LIKE :binding_7 OR  ZONA_ESCOLAR LIKE :binding_8 OR  CLAVE_UNIDAD_ACADEMICA LIKE :binding_9 OR  CLAVE_PLAN_ESTUDIOS LIKE :binding_10 OR  VERSION_PLAN_ESTUDIOS LIKE :binding_11 OR  STATUS LIKE :binding_12 OR  CORREO_ELECTRONICO LIKE :binding_13 OR  TELEFONO_CELULAR LIKE :binding_14 OR  ID LIKE :binding_15);

SELECT
  COUNT(ID)
FROM
  VW_ASPIRANTE
WHERE
  (
    ID LIKE :binding_0
    OR ESTADO LIKE :binding_1
    OR CURP LIKE :binding_2
    OR NOMBRE LIKE :binding_3
    OR UA LIKE :binding_4
    OR PLANESTUDIOS LIKE :binding_5
    OR CLAVE_UNICA_REGISTRO LIKE :binding_6
    OR FOLIO_CENEVAL LIKE :binding_7
    OR ZONA_ESCOLAR LIKE :binding_8
    OR CLAVE_UNIDAD_ACADEMICA LIKE :binding_9
    OR CLAVE_PLAN_ESTUDIOS LIKE :binding_10
    OR VERSION_PLAN_ESTUDIOS LIKE :binding_11
    OR STATUS LIKE :binding_12
    OR CORREO_ELECTRONICO LIKE :binding_13
    OR TELEFONO_CELULAR LIKE :binding_14
    OR ID LIKE :binding_15
  )

SELECT COUNT(ID) FROM   VW_ASPIRANTE WHERE ( ID LIKE :binding_0 OR  ESTADO LIKE :binding_1 OR  CURP LIKE :binding_2 OR  NOMBRE LIKE :binding_3 OR  UA LIKE :binding_4 OR  PLANESTUDIOS LIKE :binding_5 OR  CLAVE_UNICA_REGISTRO LIKE :binding_6 OR  FOLIO_CENEVAL LIKE :binding_7 OR  ZONA_ESCOLAR LIKE :binding_8 OR  CLAVE_UNIDAD_ACADEMICA LIKE :binding_9 OR  CLAVE_PLAN_ESTUDIOS LIKE :binding_10 OR  VERSION_PLAN_ESTUDIOS LIKE :binding_11 OR  STATUS LIKE :binding_12 OR  CORREO_ELECTRONICO LIKE :binding_13 OR  TELEFONO_CELULAR LIKE :binding_14 OR  ID LIKE :binding_15);