数据库加索引

 SELECT b.id as id,
    --    '' widgetState,
       b.icon,
       b.widget_name,
       b.widget_type,
       b.field_description,
       b.create_date,
       b.modify_date,
       b.version,
       b.modify_id,
       b.type,
       b.table_id,
       b.widget_sign,
       b.table_widget_key,
       b.identification,
       b.identification_src,
       b.model,
       e.field_description name,
       e.field_name columnName,
       e.field_type fieldType,
       e.seq seq,
    --    '' length,
    --    '' decimalLength,
    --    '' wholeLength,
       c.id as id2,
       c.widget_id,
       c.type as type3,
       c.attribute_name,
       c.attribute_key,
       c.attribute_value,
       d.id as id3,
       d.wid_attr_id,
       d.key_sign,
       d.value_sign,
       d.name_sign
  FROM bos_table_description a
  left join bos_widget b on a.table_id= b.table_id
   and a.identification= b.identification_src
  left join bos_field_description e on e.table_id= b.table_id
   and e.table_widget_key= b.table_widget_key
   and e.identification= b.identification
   AND e.identification_src= b.identification_src
  LEFT JOIN bos_widget_attribute c ON b.id= c.widget_id
  LEFT JOIN bos_widget_attr_sub d ON d.wid_attr_id= c.id
 where b.table_id= '1600657006525'

-- create index bos_widget_attribute_widget_id_index on bos_widget_attribute (widget_id)

-- create index bos_widget_attr_sub on bos_widget_attr_sub (wid_attr_id)