Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.username AS username_1,
  s0_.nombres AS nombres_2,
  s0_.apellidos AS apellidos_3,
  s0_.telefono AS telefono_4,
  s0_.celular AS celular_5,
  s0_.email AS email_6,
  s0_.direccion AS direccion_7,
  s0_.fecha_registro AS fecha_registro_8,
  s0_.fecha_vigencia_password AS fecha_vigencia_password_9,
  s0_.causa_bloqueo AS causa_bloqueo_10,
  s0_.password AS password_11,
  s0_.eliminado AS eliminado_12,
  s0_.fecha_eliminacion AS fecha_eliminacion_13,
  s0_.intentos_fallidos AS intentos_fallidos_14,
  s0_.primer_ingreso AS primer_ingreso_15,
  s0_.activo AS activo_16,
  s0_.conectado AS conectado_17,
  s0_.fecha_acceso AS fecha_acceso_18,
  s0_.cargo AS cargo_19,
  s0_.grado AS grado_20,
  s0_.foto AS foto_21,
  s0_.base AS base_22,
  s0_.centro AS centro_23,
  s0_.unidad AS unidad_24,
  s0_.centro_instruccion AS centro_instruccion_25
FROM
  seg_usuario s0_

SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.nombres AS nombres_2, s0_.apellidos AS apellidos_3, s0_.telefono AS telefono_4, s0_.celular AS celular_5, s0_.email AS email_6, s0_.direccion AS direccion_7, s0_.fecha_registro AS fecha_registro_8, s0_.fecha_vigencia_password AS fecha_vigencia_password_9, s0_.causa_bloqueo AS causa_bloqueo_10, s0_.password AS password_11, s0_.eliminado AS eliminado_12, s0_.fecha_eliminacion AS fecha_eliminacion_13, s0_.intentos_fallidos AS intentos_fallidos_14, s0_.primer_ingreso AS primer_ingreso_15, s0_.activo AS activo_16, s0_.conectado AS conectado_17, s0_.fecha_acceso AS fecha_acceso_18, s0_.cargo AS cargo_19, s0_.grado AS grado_20, s0_.foto AS foto_21, s0_.base AS base_22, s0_.centro AS centro_23, s0_.unidad AS unidad_24, s0_.centro_instruccion AS centro_instruccion_25 FROM seg_usuario s0_;

SELECT
  s0_.id AS id_0,
  s0_.username AS username_1,
  s0_.nombres AS nombres_2,
  s0_.apellidos AS apellidos_3,
  s0_.telefono AS telefono_4,
  s0_.celular AS celular_5,
  s0_.email AS email_6,
  s0_.direccion AS direccion_7,
  s0_.fecha_registro AS fecha_registro_8,
  s0_.fecha_vigencia_password AS fecha_vigencia_password_9,
  s0_.causa_bloqueo AS causa_bloqueo_10,
  s0_.password AS password_11,
  s0_.eliminado AS eliminado_12,
  s0_.fecha_eliminacion AS fecha_eliminacion_13,
  s0_.intentos_fallidos AS intentos_fallidos_14,
  s0_.primer_ingreso AS primer_ingreso_15,
  s0_.activo AS activo_16,
  s0_.conectado AS conectado_17,
  s0_.fecha_acceso AS fecha_acceso_18,
  s0_.cargo AS cargo_19,
  s0_.grado AS grado_20,
  s0_.foto AS foto_21,
  s0_.base AS base_22,
  s0_.centro AS centro_23,
  s0_.unidad AS unidad_24,
  s0_.centro_instruccion AS centro_instruccion_25
FROM
  seg_usuario s0_
  INNER JOIN centro_movilizacion c1_ ON s0_.centro = c1_.id
WHERE
  s0_.activo = true
ORDER BY
  s0_.apellidos ASC,
  s0_.nombres ASC

SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.nombres AS nombres_2, s0_.apellidos AS apellidos_3, s0_.telefono AS telefono_4, s0_.celular AS celular_5, s0_.email AS email_6, s0_.direccion AS direccion_7, s0_.fecha_registro AS fecha_registro_8, s0_.fecha_vigencia_password AS fecha_vigencia_password_9, s0_.causa_bloqueo AS causa_bloqueo_10, s0_.password AS password_11, s0_.eliminado AS eliminado_12, s0_.fecha_eliminacion AS fecha_eliminacion_13, s0_.intentos_fallidos AS intentos_fallidos_14, s0_.primer_ingreso AS primer_ingreso_15, s0_.activo AS activo_16, s0_.conectado AS conectado_17, s0_.fecha_acceso AS fecha_acceso_18, s0_.cargo AS cargo_19, s0_.grado AS grado_20, s0_.foto AS foto_21, s0_.base AS base_22, s0_.centro AS centro_23, s0_.unidad AS unidad_24, s0_.centro_instruccion AS centro_instruccion_25 FROM seg_usuario s0_ INNER JOIN centro_movilizacion c1_ ON s0_.centro = c1_.id WHERE s0_.activo = true ORDER BY s0_.apellidos ASC, s0_.nombres ASC;

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_

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

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.direccion AS direccion_3,
  t0.geometria AS geometria_4,
  t0.direccion_acuartelamiento AS direccion_acuartelamiento_5,
  t0.activo AS activo_6,
  t0.localizacion AS localizacion_7,
  t0.jefe AS jefe_8
FROM
  centro_movilizacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.direccion AS direccion_3, t0.geometria AS geometria_4, t0.direccion_acuartelamiento AS direccion_acuartelamiento_5, t0.activo AS activo_6, t0.localizacion AS localizacion_7, t0.jefe AS jefe_8 FROM centro_movilizacion t0 WHERE t0.id = '40';

SELECT
  c0_.id AS id_0,
  c0_.fecha_inicio AS fecha_inicio_1,
  c0_.fecha_fin AS fecha_fin_2,
  c0_.centro AS centro_3,
  c0_.jefe AS jefe_4
FROM
  centros_movilizacion_jefe c0_
  LEFT JOIN centro_movilizacion c1_ ON c0_.centro = c1_.id
WHERE
  c1_.id = 40
ORDER BY
  c0_.fecha_inicio ASC,
  c0_.fecha_inicio ASC,
  c0_.fecha_fin ASC,
  c0_.fecha_fin ASC,
  c0_.centro ASC,
  c0_.jefe ASC

SELECT c0_.id AS id_0, c0_.fecha_inicio AS fecha_inicio_1, c0_.fecha_fin AS fecha_fin_2, c0_.centro AS centro_3, c0_.jefe AS jefe_4 FROM centros_movilizacion_jefe c0_ LEFT JOIN centro_movilizacion c1_ ON c0_.centro = c1_.id WHERE c1_.id = 40 ORDER BY c0_.fecha_inicio ASC, c0_.fecha_inicio ASC, c0_.fecha_fin ASC, c0_.fecha_fin ASC, c0_.centro ASC, c0_.jefe ASC;

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

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

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
  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_

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

SHOW search_path

SHOW search_path;