Symfony Profiler

[
  "route" => "aspirante_verifica_identidad"
  "route_parameters" => [
    "_route" => "aspirante_verifica_identidad"
    "_controller" => "App\Controller\AspirantesController::verificaIdentidadAction"
    "identificacion" => "1401052038"
  ]
  "request_uri" => "https://integral.dirmov.mil.ec/aspirantes/verifica/identidad/1401052038?p=aspirantes%2Fverifica%2Fidentidad%2F1401052038"
  "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"
]

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

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

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

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

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

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

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

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

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

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

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

[
  "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"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_pgsql"
    "host" => "200.6.25.30"
    "port" => 5432
    "user" => "postgres"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "integral_produccion"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2, p0_.fecha_inicio_registro AS fecha_inicio_registro_3, p0_.fecha_fin_registro AS fecha_fin_registro_4, p0_.fecha_acuartelamiento AS fecha_acuartelamiento_5, p0_.fecha_fin_dias AS fecha_fin_dias_6, p0_.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_7, p0_.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_8, p0_.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_9, p0_.minutos_test AS minutos_test_10, p0_.bajas_permitidas AS bajas_permitidas_11, p0_.activo AS activo_12, p0_.cant_cursos AS cant_cursos_13, p0_.titulo_reporte_uniforme AS titulo_reporte_uniforme_14, p0_.titulo_reporte_jockey AS titulo_reporte_jockey_15, p0_.titulo_reporte_calzado AS titulo_reporte_calzado_16, p0_.titulo_reporte_camiseta AS titulo_reporte_camiseta_17, p0_.titulo_reporte_estudios AS titulo_reporte_estudios_18, p0_.foto_uniforme AS foto_uniforme_19, p0_.foto_jockey AS foto_jockey_20, p0_.foto_calzado AS foto_calzado_21, p0_.foto_camiseta AS foto_camiseta_22 FROM proceso_reclutamiento p0_ WHERE p0_.activo = true"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.nombres AS nombres_3, t0.apellido_paterno AS apellido_paterno_4, t0.apellido_materno AS apellido_materno_5, t0.telefono AS telefono_6, t0.telefono_emergencias AS telefono_emergencias_7, t0.email AS email_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.sexo AS sexo_11, t0.estado_civil AS estado_civil_12, t0.estatura AS estatura_13, t0.edad AS edad_14, t0.lugar_string AS lugar_string_15, t0.edad_string AS edad_string_16, t0.pais_nacimiento AS pais_nacimiento_17, t0.foto_cedula AS foto_cedula_18, t0.localizacion_nacimiento AS localizacion_nacimiento_19, t0.foto AS foto_20, t0.certif_covid AS certif_covid_21 FROM recluta t0 WHERE t0.identificacion = ? LIMIT 1"
  "params" => [
    1 => "1401052038"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.fecha_registro AS fecha_registro_1, r0_.pais_residencia AS pais_residencia_2, r0_.calle_principal_residencia AS calle_principal_residencia_3, r0_.calle_secundaria_residencia AS calle_secundaria_residencia_4, r0_.num_casa AS num_casa_5, r0_.referencias AS referencias_6, r0_.geometria AS geometria_7, r0_.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_8, r0_.resultados_antecedentes AS resultados_antecedentes_9, r0_.fecha_consulta_estudios AS fecha_consulta_estudios_10, r0_.resultados_estudios AS resultados_estudios_11, r0_.idoneo AS idoneo_12, r0_.fecha_resultado AS fecha_resultado_13, r0_.fecha_asignacion AS fecha_asignacion_14, r0_.causa_rechazo AS causa_rechazo_15, r0_.observaciones AS observaciones_16, r0_.volver_presentarse AS volver_presentarse_17, r0_.intentos AS intentos_18, r0_.fecha_intento1 AS fecha_intento1_19, r0_.fecha_intento2 AS fecha_intento2_20, r0_.fecha_intento3 AS fecha_intento3_21, r0_.turno AS turno_22, r0_.fecha_baja AS fecha_baja_23, r0_.certificado_vacunacion_ok AS certificado_vacunacion_ok_24, r0_.talla_uniforme AS talla_uniforme_25, r0_.talla_jockey AS talla_jockey_26, r0_.talla_calzado AS talla_calzado_27, r0_.talla_camiseta AS talla_camiseta_28, r0_.estudio AS estudio_29, r0_.proceso AS proceso_30, r0_.base_movilizacion AS base_movilizacion_31, r0_.centro_movilizacion AS centro_movilizacion_32, r0_.unidad_militar AS unidad_militar_33, r0_.recluta AS recluta_34, r0_.localizacion_residencia AS localizacion_residencia_35, r0_.unidad_militar_inicial AS unidad_militar_inicial_36 FROM recluta_proceso r0_ LEFT JOIN recluta r1_ ON r0_.recluta = r1_.id WHERE r1_.id = ? AND r0_.idoneo = false AND r0_.volver_presentarse = ?"
  "params" => [
    1 => 82354
    2 => "NUNCA"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.fecha_registro AS fecha_registro_1, r0_.pais_residencia AS pais_residencia_2, r0_.calle_principal_residencia AS calle_principal_residencia_3, r0_.calle_secundaria_residencia AS calle_secundaria_residencia_4, r0_.num_casa AS num_casa_5, r0_.referencias AS referencias_6, r0_.geometria AS geometria_7, r0_.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_8, r0_.resultados_antecedentes AS resultados_antecedentes_9, r0_.fecha_consulta_estudios AS fecha_consulta_estudios_10, r0_.resultados_estudios AS resultados_estudios_11, r0_.idoneo AS idoneo_12, r0_.fecha_resultado AS fecha_resultado_13, r0_.fecha_asignacion AS fecha_asignacion_14, r0_.causa_rechazo AS causa_rechazo_15, r0_.observaciones AS observaciones_16, r0_.volver_presentarse AS volver_presentarse_17, r0_.intentos AS intentos_18, r0_.fecha_intento1 AS fecha_intento1_19, r0_.fecha_intento2 AS fecha_intento2_20, r0_.fecha_intento3 AS fecha_intento3_21, r0_.turno AS turno_22, r0_.fecha_baja AS fecha_baja_23, r0_.certificado_vacunacion_ok AS certificado_vacunacion_ok_24, r0_.talla_uniforme AS talla_uniforme_25, r0_.talla_jockey AS talla_jockey_26, r0_.talla_calzado AS talla_calzado_27, r0_.talla_camiseta AS talla_camiseta_28, r0_.estudio AS estudio_29, r0_.proceso AS proceso_30, r0_.base_movilizacion AS base_movilizacion_31, r0_.centro_movilizacion AS centro_movilizacion_32, r0_.unidad_militar AS unidad_militar_33, r0_.recluta AS recluta_34, r0_.localizacion_residencia AS localizacion_residencia_35, r0_.unidad_militar_inicial AS unidad_militar_inicial_36 FROM recluta_proceso r0_ LEFT JOIN proceso_reclutamiento p1_ ON r0_.proceso = p1_.id LEFT JOIN recluta r2_ ON r0_.recluta = r2_.id WHERE r2_.id = ? AND p1_.activo = true"
  "params" => [
    1 => 82354
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.valor AS valor_1, n0_.nivel_localizacion AS nivel_localizacion_2, n0_.padre AS padre_3 FROM nmcl_dominio_localizacion n0_ LEFT JOIN nmcl_nivel_localizacion n1_ ON n0_.nivel_localizacion = n1_.id LEFT JOIN nmcl_localizacion n2_ ON n1_.localizacion = n2_.id LEFT JOIN nmcl_dominio_localizacion n3_ ON n0_.padre = n3_.id WHERE n2_.id = 1 AND n1_.nivel = 4 AND UPPER(n0_.valor) = ? AND UPPER(n3_.valor) = ?"
  "params" => [
    1 => "SANTIAGO"
    2 => "TIWINTZA"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.nombres AS nombres_3, t0.apellido_paterno AS apellido_paterno_4, t0.apellido_materno AS apellido_materno_5, t0.telefono AS telefono_6, t0.telefono_emergencias AS telefono_emergencias_7, t0.email AS email_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.sexo AS sexo_11, t0.estado_civil AS estado_civil_12, t0.estatura AS estatura_13, t0.edad AS edad_14, t0.lugar_string AS lugar_string_15, t0.edad_string AS edad_string_16, t0.pais_nacimiento AS pais_nacimiento_17, t0.foto_cedula AS foto_cedula_18, t0.localizacion_nacimiento AS localizacion_nacimiento_19, t0.foto AS foto_20, t0.certif_covid AS certif_covid_21 FROM recluta t0 WHERE t0.identificacion = ? LIMIT 1"
  "params" => [
    1 => "1401052038"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "UPDATE recluta SET edad = ?, edad_string = ? WHERE id = ?"
  "params" => [
    1 => "22"
    2 => "22 años 8 meses 24 días"
    3 => 82354
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.identificacion AS identificacion_2, t0.nombres AS nombres_3, t0.apellido_paterno AS apellido_paterno_4, t0.apellido_materno AS apellido_materno_5, t0.telefono AS telefono_6, t0.telefono_emergencias AS telefono_emergencias_7, t0.email AS email_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.sexo AS sexo_11, t0.estado_civil AS estado_civil_12, t0.estatura AS estatura_13, t0.edad AS edad_14, t0.lugar_string AS lugar_string_15, t0.edad_string AS edad_string_16, t0.pais_nacimiento AS pais_nacimiento_17, t0.foto_cedula AS foto_cedula_18, t0.localizacion_nacimiento AS localizacion_nacimiento_19, t0.foto AS foto_20, t0.certif_covid AS certif_covid_21 FROM recluta t0 WHERE t0.identificacion = ? LIMIT 1"
  "params" => [
    1 => "1401052038"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.anno AS anno_1, p0_.llamada AS llamada_2, p0_.fecha_inicio_registro AS fecha_inicio_registro_3, p0_.fecha_fin_registro AS fecha_fin_registro_4, p0_.fecha_acuartelamiento AS fecha_acuartelamiento_5, p0_.fecha_fin_dias AS fecha_fin_dias_6, p0_.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_7, p0_.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_8, p0_.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_9, p0_.minutos_test AS minutos_test_10, p0_.bajas_permitidas AS bajas_permitidas_11, p0_.activo AS activo_12, p0_.cant_cursos AS cant_cursos_13, p0_.titulo_reporte_uniforme AS titulo_reporte_uniforme_14, p0_.titulo_reporte_jockey AS titulo_reporte_jockey_15, p0_.titulo_reporte_calzado AS titulo_reporte_calzado_16, p0_.titulo_reporte_camiseta AS titulo_reporte_camiseta_17, p0_.titulo_reporte_estudios AS titulo_reporte_estudios_18, p0_.foto_uniforme AS foto_uniforme_19, p0_.foto_jockey AS foto_jockey_20, p0_.foto_calzado AS foto_calzado_21, p0_.foto_camiseta AS foto_camiseta_22 FROM proceso_reclutamiento p0_ WHERE p0_.activo = true"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fecha_registro AS fecha_registro_2, t0.pais_residencia AS pais_residencia_3, t0.calle_principal_residencia AS calle_principal_residencia_4, t0.calle_secundaria_residencia AS calle_secundaria_residencia_5, t0.num_casa AS num_casa_6, t0.referencias AS referencias_7, t0.geometria AS geometria_8, t0.fecha_consulta_antecedentes AS fecha_consulta_antecedentes_9, t0.resultados_antecedentes AS resultados_antecedentes_10, t0.fecha_consulta_estudios AS fecha_consulta_estudios_11, t0.resultados_estudios AS resultados_estudios_12, t0.idoneo AS idoneo_13, t0.fecha_resultado AS fecha_resultado_14, t0.fecha_asignacion AS fecha_asignacion_15, t0.causa_rechazo AS causa_rechazo_16, t0.observaciones AS observaciones_17, t0.volver_presentarse AS volver_presentarse_18, t0.intentos AS intentos_19, t0.fecha_intento1 AS fecha_intento1_20, t0.fecha_intento2 AS fecha_intento2_21, t0.fecha_intento3 AS fecha_intento3_22, t0.turno AS turno_23, t0.fecha_baja AS fecha_baja_24, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_25, t0.talla_uniforme AS talla_uniforme_26, t0.talla_jockey AS talla_jockey_27, t0.talla_calzado AS talla_calzado_28, t0.talla_camiseta AS talla_camiseta_29, t0.estudio AS estudio_30, t0.proceso AS proceso_31, t0.base_movilizacion AS base_movilizacion_32, t0.centro_movilizacion AS centro_movilizacion_33, t0.unidad_militar AS unidad_militar_34, t0.recluta AS recluta_35, t0.localizacion_residencia AS localizacion_residencia_36, t0.unidad_militar_inicial AS unidad_militar_inicial_37 FROM recluta_proceso t0 WHERE t0.recluta = ? AND t0.proceso = ? LIMIT 1"
  "params" => [
    1 => 82354
    2 => 47
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT NEXTVAL('recluta_proceso_id_seq')"
]

[
  "sql" => "INSERT INTO recluta_proceso (id, fecha_registro, pais_residencia, calle_principal_residencia, calle_secundaria_residencia, num_casa, referencias, geometria, fecha_consulta_antecedentes, resultados_antecedentes, fecha_consulta_estudios, resultados_estudios, idoneo, fecha_resultado, fecha_asignacion, causa_rechazo, observaciones, volver_presentarse, intentos, fecha_intento1, fecha_intento2, fecha_intento3, turno, fecha_baja, certificado_vacunacion_ok, talla_uniforme, talla_jockey, talla_calzado, talla_camiseta, estudio, proceso, base_movilizacion, centro_movilizacion, unidad_militar, recluta, localizacion_residencia, unidad_militar_inicial) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 230140
    2 => "2024-09-20 00:09:46"
    3 => null
    4 => null
    5 => null
    6 => null
    7 => null
    8 => null
    9 => null
    10 => null
    11 => null
    12 => null
    13 => 0
    14 => "2024-09-20 00:09:46"
    15 => null
    16 => "EDAD"
    17 => null
    18 => "PROXIMO"
    19 => null
    20 => null
    21 => null
    22 => null
    23 => null
    24 => null
    25 => null
    26 => null
    27 => null
    28 => null
    29 => null
    30 => null
    31 => 47
    32 => null
    33 => null
    34 => null
    35 => 82354
    36 => null
    37 => null
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 5
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 1
    20 => 2
    21 => 2
    22 => 2
    23 => 1
    24 => 2
    25 => 5
    26 => 2
    27 => 2
    28 => 2
    29 => 2
    30 => 2
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 1
  ]
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
           table_schema AS schema_name\n
    FROM information_schema.tables\n
    WHERE table_catalog = ?\n
      AND table_schema NOT LIKE 'pg\_%'\n
      AND table_schema != 'information_schema'\n
      AND table_name != 'geometry_columns'\n
      AND table_name != 'spatial_ref_sys'\n
      AND table_type = 'BASE TABLE'
    """
  "params" => [
    1 => "integral_produccion"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT schema_name\n
    FROM   information_schema.schemata\n
    WHERE  schema_name NOT LIKE 'pg\_%'\n
    AND    schema_name != 'information_schema'
    """
]

[
  "sql" => "SHOW search_path"
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

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

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

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

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

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

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

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

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

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

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

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

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

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

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