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.siglas_unidad AS siglas_unidad_2,
  t0.nombre AS nombre_3,
  t0.fuerza AS fuerza_4,
  t0.cupo_masculino AS cupo_masculino_5,
  t0.adicional_masculino AS adicional_masculino_6,
  t0.cupo_femenino AS cupo_femenino_7,
  t0.adicional_femenino AS adicional_femenino_8,
  t0.direccion AS direccion_9,
  t0.geometria AS geometria_10,
  t0.activo AS activo_11,
  t0.centro_instruccion AS centro_instruccion_12,
  t0.localizacion AS localizacion_13
FROM
  unidad_militar t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.siglas_unidad AS siglas_unidad_2, t0.nombre AS nombre_3, t0.fuerza AS fuerza_4, t0.cupo_masculino AS cupo_masculino_5, t0.adicional_masculino AS adicional_masculino_6, t0.cupo_femenino AS cupo_femenino_7, t0.adicional_femenino AS adicional_femenino_8, t0.direccion AS direccion_9, t0.geometria AS geometria_10, t0.activo AS activo_11, t0.centro_instruccion AS centro_instruccion_12, t0.localizacion AS localizacion_13 FROM unidad_militar t0 WHERE t0.id = '67';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.fuerza AS fuerza_3,
  t0.direccion AS direccion_4,
  t0.geometria AS geometria_5,
  t0.localizacion AS localizacion_6
FROM
  centro_instruccion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.fuerza AS fuerza_3, t0.direccion AS direccion_4, t0.geometria AS geometria_5, t0.localizacion AS localizacion_6 FROM centro_instruccion t0 WHERE t0.id = 12;

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 = 1387;

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.fuerza AS fuerza_2,
  c0_.direccion AS direccion_3,
  c0_.geometria AS geometria_4,
  c0_.localizacion AS localizacion_5
FROM
  centro_instruccion c0_
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.fuerza AS fuerza_2, c0_.direccion AS direccion_3, c0_.geometria AS geometria_4, c0_.localizacion AS localizacion_5 FROM centro_instruccion c0_ WHERE c0_.id IN ('54');

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_
WHERE
  n0_.id IN (?)

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_ WHERE n0_.id IN ('1387');

SELECT
  t0.id AS id_1,
  t0.siglas_unidad AS siglas_unidad_2,
  t0.nombre AS nombre_3,
  t0.fuerza AS fuerza_4,
  t0.cupo_masculino AS cupo_masculino_5,
  t0.adicional_masculino AS adicional_masculino_6,
  t0.cupo_femenino AS cupo_femenino_7,
  t0.adicional_femenino AS adicional_femenino_8,
  t0.direccion AS direccion_9,
  t0.geometria AS geometria_10,
  t0.activo AS activo_11,
  t0.centro_instruccion AS centro_instruccion_12,
  t0.localizacion AS localizacion_13
FROM
  unidad_militar t0
WHERE
  t0.nombre = ?
  AND t0.centro_instruccion = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.siglas_unidad AS siglas_unidad_2, t0.nombre AS nombre_3, t0.fuerza AS fuerza_4, t0.cupo_masculino AS cupo_masculino_5, t0.adicional_masculino AS adicional_masculino_6, t0.cupo_femenino AS cupo_femenino_7, t0.adicional_femenino AS adicional_femenino_8, t0.direccion AS direccion_9, t0.geometria AS geometria_10, t0.activo AS activo_11, t0.centro_instruccion AS centro_instruccion_12, t0.localizacion AS localizacion_13 FROM unidad_militar t0 WHERE t0.nombre = 'CIA. CUARTEL GENERAL DE LA I-DE' AND t0.centro_instruccion = 54 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  unidad_militar
SET
  centro_instruccion = ?
WHERE
  id = ?

UPDATE unidad_militar SET centro_instruccion = 54 WHERE id = 67;

"COMMIT"

"COMMIT";

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

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
  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';

SHOW search_path

SHOW search_path;

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();