SHOW FULL COLUMNS FROM `tb_university` [ RunTime:0.005038s ]
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 in (7,9,10,11,12,13,1253) GROUP BY a.id order by if (b.sort >0,0,1), b.sort asc [ RunTime:0.017393s ]
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 in (7,9,10,11,12,13,1253) GROUP BY a.id order by if (b.sort >0,0,1), b.sort asc limit 0,20 [ RunTime:0.015075s ]
select distinct area_name from tb_univ_collegeinfo where country_id=7 and area_name!=''
union select distinct area_name from tb_univ_collegeinfo where country_id=12 and area_name!=''
union select distinct area_name from tb_univ_collegeinfo where country_id=11 and area_name!=''
union select distinct area_name from tb_univ_collegeinfo where country_id=10 and area_name!=''
union select distinct area_name from tb_univ_collegeinfo where country_id=9 and area_name!=''
union select distinct area_name from tb_univ_collegeinfo where country_id=1253 and area_name!='' [ RunTime:0.014012s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.012131s ]
SELECT max(case when brand_id=1 then year end) as maxqs,max(case when brand_id=3 then year end) as maxusnews,max(case when brand_id=2 then year end) as maxtimes FROM `tb_rank_lib` WHERE `cate_id` = 1208 AND `status` = 2 AND `delete_time` IS NULL [ RunTime:0.007963s ]
SELECT `rl`.`id`,`year`,`create_time` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE `cate_id` = 1208 AND `status` = 2 AND `rb`.`short` = 'qs' AND `year` = '2026' AND `delete_time` IS NULL ORDER BY `class_small_id` ASC LIMIT 1 [ RunTime:0.013898s ]
SELECT `rl`.`id`,`year`,`create_time` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE `cate_id` = 1208 AND `status` = 2 AND `rb`.`short` = 'times' AND `year` = '2026' AND `delete_time` IS NULL ORDER BY `class_small_id` ASC LIMIT 1 [ RunTime:0.010128s ]
SELECT `rl`.`id`,`year`,`create_time` FROM `tb_rank_lib` `rl` LEFT JOIN `tb_rank_brand` `rb` ON `rb`.`id`=`rl`.`brand_id` WHERE `cate_id` = 1208 AND `status` = 2 AND `rb`.`short` = 'usnews' AND `year` = '2026' AND `delete_time` IS NULL ORDER BY `class_small_id` ASC LIMIT 1 [ RunTime:0.017527s ]
SHOW FULL COLUMNS FROM `tb_rankqs` [ RunTime:0.007907s ]
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 00:16:32' ORDER BY `time` DESC LIMIT 1 [ RunTime:0.029235s ]
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 00:16:32' ORDER BY `time` DESC LIMIT 1 [ RunTime:0.029311s ]