SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.005068s ]
SELECT f.id,f.univ_col_id,major_cname,major_ename,univ_name,univ_ename,city,c.sort,c.sort_name,cls.order_clss
FROM tb_univ_majorinfo f,tb_classes cls,tb_univ_collegeinfo a
LEFT JOIN tb_univ_collegeinfo_sort c ON a.id = c.univ_col_id AND c.sort_type = 1 AND c.is_new = 1 AND c.sort_name = 859
WHERE f.STATUS = 0
AND f.is_show = 1
AND a.country_id IN (7,9,10,11,12,13,1253)
AND a.id = f.univ_col_id
AND a.is_show = 1
AND a.STATUS = 0
and cls.id_clss = f.major_detail_id ORDER BY IF ( sort > 0, 0, 1 ),sort ASC,order_clss DESC limit 0,20 [ RunTime:0.663029s ]
select id_clss as class_cc
,cname_clss as cname_cc
,cate_clss as cate_cc
from tb_classes
order by cate_cc desc,order_clss desc [ RunTime:0.006517s ]