Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.nombres AS nombres_3,
  t0.apellidos AS apellidos_4,
  t0.telefono AS telefono_5,
  t0.celular AS celular_6,
  t0.email AS email_7,
  t0.direccion AS direccion_8,
  t0.fecha_registro AS fecha_registro_9,
  t0.fecha_vigencia_password AS fecha_vigencia_password_10,
  t0.causa_bloqueo AS causa_bloqueo_11,
  t0.password AS password_12,
  t0.eliminado AS eliminado_13,
  t0.fecha_eliminacion AS fecha_eliminacion_14,
  t0.intentos_fallidos AS intentos_fallidos_15,
  t0.primer_ingreso AS primer_ingreso_16,
  t0.activo AS activo_17,
  t0.conectado AS conectado_18,
  t0.fecha_acceso AS fecha_acceso_19,
  t0.cargo AS cargo_20,
  t0.grado AS grado_21,
  t0.foto AS foto_22,
  t0.base AS base_23,
  t0.centro AS centro_24,
  t0.unidad AS unidad_25,
  t0.centro_instruccion AS centro_instruccion_26
FROM
  seg_usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.nombres AS nombres_3, t0.apellidos AS apellidos_4, t0.telefono AS telefono_5, t0.celular AS celular_6, t0.email AS email_7, t0.direccion AS direccion_8, t0.fecha_registro AS fecha_registro_9, t0.fecha_vigencia_password AS fecha_vigencia_password_10, t0.causa_bloqueo AS causa_bloqueo_11, t0.password AS password_12, t0.eliminado AS eliminado_13, t0.fecha_eliminacion AS fecha_eliminacion_14, t0.intentos_fallidos AS intentos_fallidos_15, t0.primer_ingreso AS primer_ingreso_16, t0.activo AS activo_17, t0.conectado AS conectado_18, t0.fecha_acceso AS fecha_acceso_19, t0.cargo AS cargo_20, t0.grado AS grado_21, t0.foto AS foto_22, t0.base AS base_23, t0.centro AS centro_24, t0.unidad AS unidad_25, t0.centro_instruccion AS centro_instruccion_26 FROM seg_usuario t0 WHERE t0.id = 122;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.sistema AS sistema_3,
  t0.descripcion AS descripcion_4,
  t0.asignable AS asignable_5
FROM
  seg_rol t0
  INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol
WHERE
  seg_usuario_rol.usuario = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.sistema AS sistema_3, t0.descripcion AS descripcion_4, t0.asignable AS asignable_5 FROM seg_rol t0 INNER JOIN seg_usuario_rol ON t0.id = seg_usuario_rol.rol WHERE seg_usuario_rol.usuario = 122;

SELECT
  t0.id AS id_1,
  t0.anno AS anno_2,
  t0.llamada AS llamada_3,
  t0.fecha_inicio_registro AS fecha_inicio_registro_4,
  t0.fecha_fin_registro AS fecha_fin_registro_5,
  t0.fecha_acuartelamiento AS fecha_acuartelamiento_6,
  t0.fecha_fin_dias AS fecha_fin_dias_7,
  t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8,
  t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9,
  t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10,
  t0.minutos_test AS minutos_test_11,
  t0.bajas_permitidas AS bajas_permitidas_12,
  t0.activo AS activo_13,
  t0.cant_cursos AS cant_cursos_14,
  t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15,
  t0.titulo_reporte_jockey AS titulo_reporte_jockey_16,
  t0.titulo_reporte_calzado AS titulo_reporte_calzado_17,
  t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18,
  t0.titulo_reporte_estudios AS titulo_reporte_estudios_19,
  t0.foto_uniforme AS foto_uniforme_20,
  t0.foto_jockey AS foto_jockey_21,
  t0.foto_calzado AS foto_calzado_22,
  t0.foto_camiseta AS foto_camiseta_23
FROM
  proceso_reclutamiento t0
WHERE
  t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.anno AS anno_2, t0.llamada AS llamada_3, t0.fecha_inicio_registro AS fecha_inicio_registro_4, t0.fecha_fin_registro AS fecha_fin_registro_5, t0.fecha_acuartelamiento AS fecha_acuartelamiento_6, t0.fecha_fin_dias AS fecha_fin_dias_7, t0.hora_inicio_acuartelamiento AS hora_inicio_acuartelamiento_8, t0.hora_fin_acuartelamiento AS hora_fin_acuartelamiento_9, t0.fecha_fin_dias_posteriores AS fecha_fin_dias_posteriores_10, t0.minutos_test AS minutos_test_11, t0.bajas_permitidas AS bajas_permitidas_12, t0.activo AS activo_13, t0.cant_cursos AS cant_cursos_14, t0.titulo_reporte_uniforme AS titulo_reporte_uniforme_15, t0.titulo_reporte_jockey AS titulo_reporte_jockey_16, t0.titulo_reporte_calzado AS titulo_reporte_calzado_17, t0.titulo_reporte_camiseta AS titulo_reporte_camiseta_18, t0.titulo_reporte_estudios AS titulo_reporte_estudios_19, t0.foto_uniforme AS foto_uniforme_20, t0.foto_jockey AS foto_jockey_21, t0.foto_calzado AS foto_calzado_22, t0.foto_camiseta AS foto_camiseta_23 FROM proceso_reclutamiento t0 WHERE t0.activo = 1 LIMIT 1;

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_
  INNER JOIN recluta r1_ ON r0_.recluta = r1_.id
  INNER JOIN proceso_reclutamiento p2_ ON r0_.proceso = p2_.id
WHERE
  p2_.id = 47
  AND r1_.identificacion = '0805167947'
  AND r0_.unidad_militar IS NOT NULL

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_ INNER JOIN recluta r1_ ON r0_.recluta = r1_.id INNER JOIN proceso_reclutamiento p2_ ON r0_.proceso = p2_.id WHERE p2_.id = 47 AND r1_.identificacion = '0805167947' AND r0_.unidad_militar IS NOT NULL;