SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.004793s ]
select a.id,b.sort,a.univ_name,a.univ_ename,a.city,a.imageurl as univ_logo,area_name,if(sort_name>0,sort_name,859) as sort_name
from tb_univ_collegeinfo a
left join tb_univ_collegeinfo_sort b on a.id = b.univ_col_id and b.sort_type =1 and b.is_new =1 and sort_name=859
where a.is_show=1
and a.status=0 and country_id=10 GROUP BY a.id order by if (b.sort >0,0,1), b.sort asc [ RunTime:0.009831s ]
select a.id,b.sort,a.univ_name,a.univ_ename,a.city,a.imageurl as univ_logo,area_name,if(sort_name>0,sort_name,859) as sort_name
from tb_univ_collegeinfo a
left join tb_univ_collegeinfo_sort b on a.id = b.univ_col_id and b.sort_type =1 and b.is_new =1 and sort_name=859
where a.is_show=1
and a.status=0 and country_id=10 GROUP BY a.id order by if (b.sort >0,0,1), b.sort asc limit 0,20 [ RunTime:0.009861s ]
select distinct area_name from tb_univ_collegeinfo where country_id=10/1 and area_name!='' [ RunTime:0.009663s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.008434s ]
SHOW FULL COLUMNS FROM `tb_rankqs` [ RunTime:0.006307s ]
SELECT class,max(year) as year,cate_rs,time FROM `tb_rankqs` LEFT JOIN `tb_rankclasses` `rankclasses` ON `class_rs`=`class` WHERE ( class=307 ) AND `time` > '2025-06-05 06:51:41' ORDER BY `time` DESC LIMIT 1 [ RunTime:0.022271s ]
SELECT class,max(year) as year,cate_rs,time FROM `tb_rankqs` LEFT JOIN `tb_rankclasses` `rankclasses` ON `class_rs`=`class` WHERE ( class=307 ) AND `time` > '2023-07-16 06:51:41' ORDER BY `time` DESC LIMIT 1 [ RunTime:0.027804s ]