Symfony Profiler

[
  "route" => "admin_expediente_aspirante_con_matricula_elegir_tramite"
  "route_parameters" => [
    "_route" => "admin_expediente_aspirante_con_matricula_elegir_tramite"
    "_controller" => "App\Controller\Backend\Expediente\ExpedienteAspirantesConMatriculaController::elegirTramite"
  ]
  "request_uri" => "https://violeta.uagro.mx/admin/expediente/elegir-tramite?aspRegistroId=83&userAlumnoId=88"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "oci8"
    "host" => "10.10.30.250"
    "port" => 1521
    "user" => "ADMCREDENCIAL"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dbsiia"
    "charset" => "AL32UTF8"
  ]
]

[
  "sql" => "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 = '.,'"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 62
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "20714@uagro.mx"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0_.id AS ID_0, t0_.nombre AS NOMBRE_1, t0_.nombre_corto AS NOMBRE_CORTO_2, t0_.clave AS CLAVE_3, t0_.beneficio AS BENEFICIO_4, t0_.requiere_firma_electronica AS REQUIERE_FIRMA_ELECTRONICA_5, t0_.publico_dirigido AS PUBLICO_DIRIGIDO_6, t0_.fecha_creacion AS FECHA_CREACION_7, t0_.fecha_actualizacion AS FECHA_ACTUALIZACION_8, t0_.documento_obtiene AS DOCUMENTO_OBTIENE_9, t0_.costo AS COSTO_10, t0_.tiempo_respuesta AS TIEMPO_RESPUESTA_11, t0_.condiciones AS CONDICIONES_12, t0_.fundamento_legal AS FUNDAMENTO_LEGAL_13, t0_.website AS WEBSITE_14, t0_.tramite_gratis AS TRAMITE_GRATIS_15, t0_.tramite_publicado AS TRAMITE_PUBLICADO_16, t0_.procedimiento_enlinea AS PROCEDIMIENTO_ENLINEA_17, t0_.procedimiento_modulo AS PROCEDIMIENTO_MODULO_18, t0_.validado AS VALIDADO_19, t0_.tiempo_validez_documento AS TIEMPO_VALIDEZ_DOCUMENTO_20, t0_.descripcion AS DESCRIPCION_21, t0_.nivel_aplica AS NIVEL_APLICA_22, t0_.unidad_responsable_id AS UNIDAD_RESPONSABLE_ID_23 FROM tramites_tramite t0_"
]

[
  "key" => "_security_main"
]

[
  "sql" => "SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM ALL_TABLES\n
    WHERE OWNER = ?\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "ADMCREDENCIAL"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM ALL_TABLES\n
    WHERE OWNER = ?\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "ADMCREDENCIAL"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL"
]

[
  "sql" => "SELECT TABLE_NAME, COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = ? AND TABLE_NAME = ?"
  "params" => [
    1 => "ADMCREDENCIAL"
    2 => "DOCTRINE_MIGRATION_VERSIONS"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL"
]

[
  "sql" => """
    SELECT                 ALC.CONSTRAINT_NAME,\n
                     ALC.DELETE_RULE,\n
                     COLS.COLUMN_NAME LOCAL_COLUMN,\n
                     COLS.POSITION,\n
                     R_COLS.TABLE_NAME REFERENCES_TABLE,\n
                     R_COLS.COLUMN_NAME FOREIGN_COLUMN\n
                FROM ALL_CONS_COLUMNS COLS\n
           LEFT JOIN ALL_CONSTRAINTS ALC ON ALC.OWNER = COLS.OWNER AND ALC.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME\n
           LEFT JOIN ALL_CONS_COLUMNS R_COLS ON R_COLS.OWNER = ALC.R_OWNER AND\n
                     R_COLS.CONSTRAINT_NAME = ALC.R_CONSTRAINT_NAME AND\n
                     R_COLS.POSITION = COLS.POSITION WHERE ALC.CONSTRAINT_TYPE = 'R' AND COLS.OWNER = ? AND COLS.TABLE_NAME = ? ORDER BY COLS.TABLE_NAME, COLS.CONSTRAINT_NAME, COLS.POSITION
    """
  "params" => [
    1 => "ADMCREDENCIAL"
    2 => "DOCTRINE_MIGRATION_VERSIONS"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => """
    SELECT                 C.COLUMN_NAME,\n
                     C.DATA_TYPE,\n
                     C.DATA_DEFAULT,\n
                     C.DATA_PRECISION,\n
                     C.DATA_SCALE,\n
                     C.CHAR_LENGTH,\n
                     C.DATA_LENGTH,\n
                     C.NULLABLE,\n
                     D.COMMENTS\n
                FROM ALL_TAB_COLUMNS C\n
            INNER JOIN ALL_TABLES T\n
                ON T.OWNER = C.OWNER\n
                AND T.TABLE_NAME = C.TABLE_NAME\n
           LEFT JOIN ALL_COL_COMMENTS D\n
               ON D.OWNER = C.OWNER\n
                      AND D.TABLE_NAME = C.TABLE_NAME\n
                      AND D.COLUMN_NAME = C.COLUMN_NAME WHERE C.OWNER = ? AND C.TABLE_NAME = ? ORDER BY C.COLUMN_ID
    """
  "params" => [
    1 => "ADMCREDENCIAL"
    2 => "DOCTRINE_MIGRATION_VERSIONS"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL"
]

[
  "sql" => """
    SELECT                 IND_COL.INDEX_NAME AS NAME,\n
                     IND.INDEX_TYPE AS TYPE,\n
                     DECODE(IND.UNIQUENESS, 'NONUNIQUE', 0, 'UNIQUE', 1) AS IS_UNIQUE,\n
                     IND_COL.COLUMN_NAME,\n
                     IND_COL.COLUMN_POSITION AS COLUMN_POS,\n
                     CON.CONSTRAINT_TYPE AS IS_PRIMARY\n
                FROM ALL_IND_COLUMNS IND_COL\n
           LEFT JOIN ALL_INDEXES IND\n
                  ON IND.OWNER = IND_COL.INDEX_OWNER\n
                 AND IND.INDEX_NAME = IND_COL.INDEX_NAME\n
           LEFT JOIN ALL_CONSTRAINTS CON\n
                  ON CON.OWNER = IND_COL.INDEX_OWNER\n
                 AND CON.INDEX_NAME = IND_COL.INDEX_NAME WHERE IND_COL.INDEX_OWNER = ? AND IND_COL.TABLE_NAME = ? ORDER BY IND_COL.TABLE_NAME, IND_COL.INDEX_NAME, IND_COL.COLUMN_POSITION
    """
  "params" => [
    1 => "ADMCREDENCIAL"
    2 => "DOCTRINE_MIGRATION_VERSIONS"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM DUAL"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]