index main sql: select u.user_avatar,m.* from ty_main m,ty_user u where m.user_id=u.user_id and m.site_id=101 and cur_flag='1' and main_status>='A' and data_flag>=1 and main_limit>='1' and forum_type=1 and main_tag like '%工作%'
order by flag_top desc, main_time desc limit 0,32