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
  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 = 4
ORDER BY
  s0_.username ASC,
  s0_.cargo ASC,
  s0_.grado ASC,
  s0_.base 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 = 4 ORDER BY s0_.username ASC, s0_.cargo ASC, s0_.grado ASC, s0_.base ASC, s0_.activo ASC, s0_.fecha_acceso ASC, s0_.fecha_acceso ASC;

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.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_BASE' LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.fecha_ingreso AS fecha_ingreso_1,
  n0_.asunto AS asunto_2,
  n0_.leida AS leida_3,
  n0_.fecha_leida AS fecha_leida_4,
  n0_.texto AS texto_5,
  n0_.accion AS accion_6,
  n0_.usuario AS usuario_7
FROM
  notificacion n0_
  INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id
WHERE
  n0_.leida = false
  AND s1_.id = 122
ORDER BY
  n0_.asunto ASC,
  n0_.fecha_ingreso DESC

SELECT n0_.id AS id_0, n0_.fecha_ingreso AS fecha_ingreso_1, n0_.asunto AS asunto_2, n0_.leida AS leida_3, n0_.fecha_leida AS fecha_leida_4, n0_.texto AS texto_5, n0_.accion AS accion_6, n0_.usuario AS usuario_7 FROM notificacion n0_ INNER JOIN seg_usuario s1_ ON n0_.usuario = s1_.id WHERE n0_.leida = false AND s1_.id = 122 ORDER BY n0_.asunto ASC, n0_.fecha_ingreso DESC;

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
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

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
FROM
  nmcl_cargo n0_

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

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

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

SHOW search_path

SHOW search_path;