SHOW FULL COLUMNS FROM `tb_data_applyoffer_base` [ RunTime:0.005615s ]
SELECT DISTINCT applymajortypeid,c1.cname_cate as applymajortype FROM `tb_data_applyoffer_base` `dab` LEFT JOIN `tb_category` `c1` ON `c1`.`id_cate`=`dab`.`applymajortypeid` [ RunTime:0.005757s ]
SELECT DISTINCT applymajortypeid,`applymajortypedetailid`,c2.cname_clss as applymajortypedetail FROM `tb_data_applyoffer_base` `dab` LEFT JOIN `tb_classes` `c2` ON `c2`.`id_clss`=`dab`.`applymajortypedetailid` [ RunTime:0.010918s ]
select distinct report_id,applycountryid,applyschool,applyschoolid,sample_count,univ_ename,city,cname_clss,s.id_clss,ename_clss
from tb_data_applyoffer_base c
left join tb_classes s on c.applymajortypedetailid = s.id_clss
left join tb_univ_collegeinfo f on c.applyschoolid = f.id
left join tb_category cc on c.applymajortypeid = cc.id_cate
left join tb_univ_collegeinfo_sort d on c.applyschoolid = d.univ_col_id and d.sort_type=2 and d.sort_name=859 and d.is_show=1
where applycountryid>0 order by sample_count desc ,convert(s.cname_clss using gbk) asc, report_id asc [ RunTime:0.017249s ]
select distinct report_id,applycountryid,applyschool,applyschoolid,sample_count,univ_ename,city,cname_clss,s.id_clss,ename_clss
from tb_data_applyoffer_base c
left join tb_classes s on c.applymajortypedetailid = s.id_clss
left join tb_univ_collegeinfo f on c.applyschoolid = f.id
left join tb_category cc on c.applymajortypeid = cc.id_cate
left join tb_univ_collegeinfo_sort d on c.applyschoolid = d.univ_col_id and d.sort_type=2 and d.sort_name=859 and d.is_show=1
where applycountryid>0 order by sample_count desc ,convert(s.cname_clss using gbk) asc, report_id asc limit 0,20 [ RunTime:0.016532s ]