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_
  LEFT JOIN seg_usuario_rol s2_ ON s0_.id = s2_.usuario
  LEFT JOIN seg_rol s1_ ON s1_.id = s2_.rol
WHERE
  s1_.id = 2
ORDER BY
  s0_.username ASC,
  s0_.cargo ASC,
  s0_.grado ASC,
  s0_.base ASC,
  s0_.centro ASC,
  s0_.activo ASC,
  s0_.fecha_acceso ASC,
  s0_.fecha_acceso 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_ LEFT JOIN seg_usuario_rol s2_ ON s0_.id = s2_.usuario LEFT JOIN seg_rol s1_ ON s1_.id = s2_.rol WHERE s1_.id = 2 ORDER BY s0_.username ASC, s0_.cargo ASC, s0_.grado ASC, s0_.base ASC, s0_.centro ASC, s0_.activo ASC, s0_.fecha_acceso ASC, s0_.fecha_acceso 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
  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
WHERE
  t0.nombre = ?
LIMIT
  1

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 WHERE t0.nombre = 'ROLE_COORDINADOR_CENTRO' LIMIT 1;

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

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
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.codigo_activacion AS codigo_activacion_3,
  t0.vigencia_codigo AS vigencia_codigo_4,
  t0.default_contrasena AS default_contrasena_5,
  t0.vigencia_contrasena AS vigencia_contrasena_6,
  t0.contrasenas_viejas AS contrasenas_viejas_7,
  t0.accesos_fallidos AS accesos_fallidos_8,
  t0.fortaleza_contrasena AS fortaleza_contrasena_9
FROM
  seg_configuracion t0
WHERE
  t0.nombre = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo_activacion AS codigo_activacion_3, t0.vigencia_codigo AS vigencia_codigo_4, t0.default_contrasena AS default_contrasena_5, t0.vigencia_contrasena AS vigencia_contrasena_6, t0.contrasenas_viejas AS contrasenas_viejas_7, t0.accesos_fallidos AS accesos_fallidos_8, t0.fortaleza_contrasena AS fortaleza_contrasena_9 FROM seg_configuracion t0 WHERE t0.nombre = 'DEFAULT' LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.nombre AS nombre_1
FROM
  nmcl_cargo n0_

SELECT n0_.id AS id_0, n0_.nombre AS nombre_1 FROM nmcl_cargo n0_;

SELECT
  s0_.id AS id_0,
  s0_.nombre AS nombre_1,
  s0_.sistema AS sistema_2,
  s0_.descripcion AS descripcion_3,
  s0_.asignable AS asignable_4
FROM
  seg_rol s0_

SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.sistema AS sistema_2, s0_.descripcion AS descripcion_3, s0_.asignable AS asignable_4 FROM seg_rol s0_;

SELECT
  n0_.id AS id_0,
  n0_.nombre AS nombre_1,
  n0_.id_dir_mov AS id_dir_mov_2
FROM
  nmcl_grado n0_

SELECT n0_.id AS id_0, n0_.nombre AS nombre_1, n0_.id_dir_mov AS id_dir_mov_2 FROM nmcl_grado n0_;

SELECT
  b0_.id AS id_0,
  b0_.nombre AS nombre_1,
  b0_.direccion AS direccion_2,
  b0_.geometria AS geometria_3,
  b0_.activo AS activo_4,
  b0_.localizacion AS localizacion_5,
  b0_.jefe AS jefe_6
FROM
  base_movilizacion b0_

SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.direccion AS direccion_2, b0_.geometria AS geometria_3, b0_.activo AS activo_4, b0_.localizacion AS localizacion_5, b0_.jefe AS jefe_6 FROM base_movilizacion b0_;

SHOW search_path

SHOW search_path;