Symfony Profiler

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'integral_produccion'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE';

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
WHERE
  n2_.id = 1
  AND n1_.nivel = 4
ORDER BY
  n0_.valor ASC

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 WHERE n2_.id = 1 AND n1_.nivel = 4 ORDER BY n0_.valor ASC;

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
WHERE
  n2_.id = 1
  AND n1_.nivel = 1
ORDER BY
  n0_.valor ASC

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 WHERE n2_.id = 1 AND n1_.nivel = 1 ORDER BY n0_.valor ASC;

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.causa_rechazo AS causa_rechazo_15,
  t0.observaciones AS observaciones_16,
  t0.volver_presentarse AS volver_presentarse_17,
  t0.fecha_baja AS fecha_baja_18,
  t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19,
  t0.disponibilidad AS disponibilidad_20,
  t0.actividad AS actividad_21,
  t0.error_registro AS error_registro_22,
  t0.proceso AS proceso_23,
  t0.reservista AS reservista_24,
  t0.localizacion_residencia AS localizacion_residencia_25,
  t0.centro_movilizacion AS centro_movilizacion_26
FROM
  reservista_proceso t0
WHERE
  t0.id = ?

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.causa_rechazo AS causa_rechazo_15, t0.observaciones AS observaciones_16, t0.volver_presentarse AS volver_presentarse_17, t0.fecha_baja AS fecha_baja_18, t0.certificado_vacunacion_ok AS certificado_vacunacion_ok_19, t0.disponibilidad AS disponibilidad_20, t0.actividad AS actividad_21, t0.error_registro AS error_registro_22, t0.proceso AS proceso_23, t0.reservista AS reservista_24, t0.localizacion_residencia AS localizacion_residencia_25, t0.centro_movilizacion AS centro_movilizacion_26 FROM reservista_proceso t0 WHERE t0.id = '45980';

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
WHERE
  n2_.id = 1
  AND n1_.nivel = 3
ORDER BY
  n0_.valor ASC

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 WHERE n2_.id = 1 AND n1_.nivel = 3 ORDER BY n0_.valor ASC;

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.id = ?

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.id = 42158;

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
WHERE
  n2_.id = 1
  AND n1_.nivel = 2
ORDER BY
  n0_.valor ASC

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 WHERE n2_.id = 1 AND n1_.nivel = 2 ORDER BY n0_.valor ASC;

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.direccion AS direccion_2,
  c0_.geometria AS geometria_3,
  c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4,
  c0_.activo AS activo_5,
  c0_.localizacion AS localizacion_6,
  c0_.jefe AS jefe_7
FROM
  centro_movilizacion c0_
WHERE
  c0_.activo = true
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.direccion AS direccion_2, c0_.geometria AS geometria_3, c0_.direccion_acuartelamiento AS direccion_acuartelamiento_4, c0_.activo AS activo_5, c0_.localizacion AS localizacion_6, c0_.jefe AS jefe_7 FROM centro_movilizacion c0_ WHERE c0_.activo = true ORDER BY c0_.nombre ASC;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

SELECT
  r0_.id AS id_0,
  r0_.tiempo AS tiempo_1,
  r0_.detalles AS detalles_2,
  r0_.reservista AS reservista_3,
  r0_.destreza AS destreza_4
FROM
  reservistas_destrezas r0_
  INNER JOIN reservistas r1_ ON r0_.reservista = r1_.id
  INNER JOIN nmcl_destrezas n2_ ON r0_.destreza = n2_.id
WHERE
  r1_.id = ?
ORDER BY
  n2_.nombre ASC

SELECT r0_.id AS id_0, r0_.tiempo AS tiempo_1, r0_.detalles AS detalles_2, r0_.reservista AS reservista_3, r0_.destreza AS destreza_4 FROM reservistas_destrezas r0_ INNER JOIN reservistas r1_ ON r0_.reservista = r1_.id INNER JOIN nmcl_destrezas n2_ ON r0_.destreza = n2_.id WHERE r1_.id = 42158 ORDER BY n2_.nombre ASC;

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

SELECT
  r0_.id AS id_0,
  r0_.titulo AS titulo_1,
  r0_.institucion AS institucion_2,
  r0_.cursando AS cursando_3,
  r0_.fecha_emision AS fecha_emision_4,
  r0_.reservista AS reservista_5,
  r0_.nivel AS nivel_6
FROM
  reservistas_estudios r0_
  INNER JOIN reservistas r1_ ON r0_.reservista = r1_.id
WHERE
  r1_.id = ?
ORDER BY
  r0_.institucion ASC,
  r0_.titulo ASC

SELECT r0_.id AS id_0, r0_.titulo AS titulo_1, r0_.institucion AS institucion_2, r0_.cursando AS cursando_3, r0_.fecha_emision AS fecha_emision_4, r0_.reservista AS reservista_5, r0_.nivel AS nivel_6 FROM reservistas_estudios r0_ INNER JOIN reservistas r1_ ON r0_.reservista = r1_.id WHERE r1_.id = 42158 ORDER BY r0_.institucion ASC, r0_.titulo ASC;

SELECT
  n0_.id AS id_0,
  n0_.nombre AS nombre_1
FROM
  nmcl_destrezas n0_
ORDER BY
  n0_.nombre ASC

SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_destrezas n0_ ORDER BY n0_.nombre ASC;

SELECT
  n0_.id AS id_0,
  n0_.nombre AS nombre_1
FROM
  nmcl_nivel_estudios n0_
ORDER BY
  n0_.nombre ASC

SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_nivel_estudios n0_ ORDER BY n0_.nombre ASC;

SHOW search_path

SHOW search_path;