Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.fecha_inicio_registro AS fecha_inicio_registro_1,
  p0_.fecha_fin_registro AS fecha_fin_registro_2,
  p0_.anno_desde AS anno_desde_3,
  p0_.anno_hasta AS anno_hasta_4,
  p0_.activo AS activo_5
FROM
  proceso_registro_reservistas p0_
WHERE
  p0_.activo = true

SELECT p0_.id AS id_0, p0_.fecha_inicio_registro AS fecha_inicio_registro_1, p0_.fecha_fin_registro AS fecha_fin_registro_2, p0_.anno_desde AS anno_desde_3, p0_.anno_hasta AS anno_hasta_4, p0_.activo AS activo_5 FROM proceso_registro_reservistas p0_ WHERE p0_.activo = true;

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.instruccion AS instruccion_19,
  t0.localizacion_nacimiento AS localizacion_nacimiento_20,
  t0.foto AS foto_21,
  t0.certif_covid AS certif_covid_22,
  t0.grado AS grado_23,
  t0.fuerza AS fuerza_24,
  t0.arma AS arma_25
FROM
  reservistas t0
WHERE
  t0.identificacion = ?
LIMIT
  1

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.instruccion AS instruccion_19, t0.localizacion_nacimiento AS localizacion_nacimiento_20, t0.foto AS foto_21, t0.certif_covid AS certif_covid_22, t0.grado AS grado_23, t0.fuerza AS fuerza_24, t0.arma AS arma_25 FROM reservistas t0 WHERE t0.identificacion = '1250036322' LIMIT 1;

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

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) = 'RICAURTE' AND UPPER(n3_.valor) = 'URDANETA';

SELECT
  t0.id AS id_1,
  t0.valor AS valor_2,
  t0.nivel_localizacion AS nivel_localizacion_3,
  t0.padre AS padre_4
FROM
  nmcl_dominio_localizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = 161;

SELECT
  t0.id AS id_1,
  t0.valor AS valor_2,
  t0.nivel_localizacion AS nivel_localizacion_3,
  t0.padre AS padre_4
FROM
  nmcl_dominio_localizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.valor AS valor_2,
  t0.nivel_localizacion AS nivel_localizacion_3,
  t0.padre AS padre_4
FROM
  nmcl_dominio_localizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.nivel_localizacion AS nivel_localizacion_3, t0.padre AS padre_4 FROM nmcl_dominio_localizacion t0 WHERE t0.id = 1;