SHOW FULL COLUMNS FROM `tb_categorys` [ RunTime:0.005353s ]
SHOW FULL COLUMNS FROM `tb_rank_brand` [ RunTime:0.014637s ]
SELECT * FROM `tb_rank_brand` WHERE `short` = 'cug' LIMIT 1 [ RunTime:0.008997s ]
SHOW FULL COLUMNS FROM `tb_rank_lib` [ RunTime:0.009643s ]
SELECT * FROM `tb_rank_lib` WHERE `year` = '2025' AND `cate_id` = 1208 AND `brand_id` = 7 AND `status` = 2 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.012736s ]
SHOW FULL COLUMNS FROM `tb_rank_lib_info` [ RunTime:0.006677s ]
SELECT `year`,`rank`,`rank_alias`,`rli`.`major_id`,`univ_cname`,`univ_ename`,`univ_id`,`college_id`,`area_name`,`area_id`,`brand_id`,`rank_major_cname`,`rank_major_ename`,`um`.`major_cname`,`um`.`major_ename` FROM `tb_rank_lib_info` `rli` LEFT JOIN `tb_univ_majorinfo` `um` ON `rli`.`major_id`=`um`.`id` WHERE `rank_lib_id` = 6605 ORDER BY if(rank is null or rank=0,9999,rank), rank asc,rli.id asc [ RunTime:0.010048s ]
SELECT distinct year FROM `tb_rank_lib` WHERE `cate_id` = 1208 AND `brand_id` = 7 AND `status` = 2 AND `delete_time` IS NULL ORDER BY `year` DESC [ RunTime:0.008865s ]
SHOW FULL COLUMNS FROM `tb_rank_introduce` [ RunTime:0.007630s ]
SELECT `ri`.`pic_url`,`ac`.`content` FROM `tb_rank_introduce` `ri` LEFT JOIN `tb_article_content` `ac` ON `ri`.`article_id`=`ac`.`id` WHERE `ri`.`cate_id` = '1208' AND `brand_id` = 7 AND ( ac.status=2 and show_type=2 ) LIMIT 1 [ RunTime:0.009200s ]